library/weno/src/TransmitData.php

   1 <?php
   2 /**
   3  * TransmitData class.
   4  *
   5  * @package OpenEMR
   6  * @link    http://www.open-emr.org
   7  * @author  Sherwin Gaddis <sherwingaddis@gmail.com>
   8  * @copyright Copyright (c) 2016-2017 Sherwin Gaddis <sherwingaddis@gmail.com>
   9  * @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  10  */
  11
  12
  13 namespace OpenEMR\Rx\Weno;
  14
  15 class TransmitData
  16 {
  17
  18     public function __construct()
  19     {
  20     }
  21
  22     public function getDrugList($pid, $date)
  23     {
  24
  25         $sql = "SELECT * FROM prescriptions WHERE patient_id = ? AND ntx = 1 AND txDate = ?";
  26         $res = sqlStatement($sql, array($pid, $date));
  27         return $res;
  28     }
  29
  30     public function getProviderFacility($uid)
  31     {
  32
  33         $sql = "SELECT a.fname, a.lname, a.npi, a.weno_prov_id, b.name, b.phone, b.fax, b.street, b.city, b.state,
  34                                 b.postal_code FROM `users` AS a, facility AS b WHERE a.id = ? AND
  35                                 a.facility_id = b.id ";
  36
  37         $pFinfo = sqlQuery($sql, array($uid));
  38
  39         return array($pFinfo);
  40     }
  41
  42     public function findPharmacy($id)
  43     {
  44         //$sql = "SELECT store_name, NCPDP, NPI, Pharmacy_Phone, Pharmacy_Fax FROM erx_pharmacies WHERE id = ?";
  45         $sql = "SELECT name, ncpdp, npi FROM pharmacies WHERE id = ? ";
  46         $find = sqlQuery($sql, array($id));
  47
  48         $nSql = "SELECT area_code, prefix, type, number FROM phone_numbers WHERE foreign_id = ?";
  49         $numbers = sqlStatement($nSql, array($id));
  50
  51         $numberArray = array();
  52         while ($row = sqlFetchArray($numbers)) {
  53             $numberArray[] = $row;
  54         }
  55
  56         return array($find, $numberArray);
  57     }
  58
  59     public function oneDrug($id)
  60     {
  61         $sql = "SELECT date_Added,date_Modified,drug,drug_id,dosage,refills,quantity,note FROM prescriptions WHERE id = ?";
  62         $res = sqlQuery($sql, array($id));
  63         return $res;
  64     }
  65
  66
  67     public function patientPharmacyInfo($pid)
  68     {
  69         $sql = "SELECT a.pharmacy_id, b.name FROM patient_data AS a, pharmacies AS b WHERE a.pid = ? AND a.pharmacy_id = b.id";
  70         $res = sqlQuery($sql, $pid);
  71         return $res;
  72     }
  73
  74     public function mailOrderPharmacy()
  75     {
  76         $sql = "SELECT id FROM pharmacies WHERE name LIKE ?";
  77         $res = sqlQuery($sql, 'CCS Medical');
  78         return $res;
  79     }
  80
  81
  82     public function validatePatient($pid)
  83     {
  84          $patientInfo = "SELECT DOB, street, postal_code, city, state, sex FROM patient_data WHERE pid = ?";
  85          $val = array($pid);
  86          $patientRes = sqlQuery($patientInfo, $val);
  87          return $patientRes;
  88     }
  89 }