/** * Function: getPaymentsBySearch */ public function getPaymentsBySearch(stdClass $params) { $patientPayments = array(); $whereClause = ''; // Look between date the payment was created if (isset($params->datefrom) && isset($params->dateto)) { $whereClause .= chr(13) . " AND date_created BETWEEN '" . substr($params->datefrom, 0, -9) . " 00:00:00' AND '" . substr($params->dateto, 0, -9) . " 23:00:00'"; } // Look for the Paying Entity if (isset($params->payingEntityCombo)) { $whereClause .= chr(13) . " AND paying_entity = '" . $params->payingEntityCombo . "'"; } // Look for the Patient if (isset($params->patientSearch)) { $whereClause .= chr(13) . " AND paying_entity = '" . $params->payingEntityCombo . "'"; } // If the whereClause variable is used go ahead and // and add the where command. if ($whereClause != '') { $whereClause = 'WHERE ' . $whereClause; } $sql = "SELECT\n\t\t\t\t\tpatient.fname,\n\t\t\t\t\tpatient.mname,\n\t\t\t\t\tpatient.lname,\n\t\t\t\t\tpatient.pid,\n\t\t\t\t\tpayments.dtime,\n\t\t\t\t\tpayments.encounter,\n\t\t\t\t\tpayments.user,\n\t\t\t\t\tpayments.method,\n\t\t\t\t\tpayments.source,\n\t\t\t\t\tpayments.amount1,\n\t\t\t\t\tpayments.amount2,\n\t\t\t\t\tpayments.posted1,\n\t\t\t\t\tpayments.posted2\n\t\t\t\tFROM\n\t\t\t\t\tpayments\n\t\t\t\tINNER JOIN\n\t\t\t\t\tpatient\n\t\t\t\tON\n\t\t\t\t\tpatient.pid = payments.pid\n\t\t\t\t{$whereClause}"; $this->db->setSQL($sql); // Loop through the results. // in here you can do calculations or other stuff. foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) { $patientPayments[] = $row; } $total = count($patientPayments); // Return the results back to ExtJS. return array('totals' => $total, 'rows' => $patientPayments); }
public function getLabsLiveSearch(stdClass $params) { $this->db->setSQL("SELECT id,\n\t\t\t\t\t\t\t\t parent_loinc,\n\t\t\t\t\t\t\t\t loinc_number,\n\t\t\t\t\t\t\t\t loinc_name\n\t\t\t\t\t\t\tFROM labs_panels\n\t\t\t\t\t\t\tWHERE parent_loinc <> loinc_number\n\t\t\t\t\t\t\t AND loinc_name LIKE'{$params->query}%'"); $records = $this->db->fetchRecords(PDO::FETCH_ASSOC); $total = count($records); $records = array_slice($records, $params->start, $params->limit); return array('totals' => $total, 'rows' => $records); }
public function removeAllowBlank($table) { $this->db->setSQL("Select `id`, `options` FROM {$table}"); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) { $options = json_decode($row['options'], true); if (isset($options['allowBlank'])) { unset($options['allowBlank']); $id = $row['id']; $data['options'] = json_encode($options); $this->db->setSQL($this->db->sqlBind($data, $table, 'U', array('id' => $id))); $this->db->execOnly(); } } }
public function getPreventiveCareDismissedAlertsByPid(stdClass $params) { $this->db->setSQL("SELECT pcig.id,\n pcig.preventive_care_id,\n pcig.reason,\n pcig.dismiss,\n pcig.date,\n pcig.observation,\n pcg.description\n FROM preventive_care_inactive_patient AS pcig\n LEFT JOIN preventive_care_guidelines AS pcg ON pcig.preventive_care_id = pcg.id\n WHERE pcig.pid = '{$params->pid}'\n AND pcig.dismiss = 1"); return $this->db->fetchRecords(); }
/** * @return array */ public function getCptUsedByClinic() { $this->db->setSQL("SELECT DISTINCT cpt.code, cpt.code_text, cpt.code_text_medium, cpt.code_text_short\n FROM encounter_services AS ecc\n LEFT JOIN cpt_codes AS cpt ON ecc.code = cpt.code\n ORDER BY cpt.code DESC"); $records = $this->db->fetchRecords(PDO::FETCH_ASSOC); return ['totals' => count($records), 'rows' => $records]; }