public function updateDocumentsTitle(stdClass $params) { $data = get_object_vars($params); $id = $data['id']; unset($data['id'], $data['date']); $this->db->setSQL($this->db->sqlBind($data, 'patient_documents', 'U', ['id' => $id])); $this->db->execLog(); return $params; }
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 updatePreventiveCareDismissedAlertsByPid(stdClass $params) { $data = get_object_vars($params); unset($data['id'], $data['description']); $this->db->setSQL($this->db->sqlBind($data, 'preventive_care_inactive_patient', 'U', array('id' => $params->id))); $this->db->execLog(); return $params; }
public function logEmergency() { $data['pid'] = $this->pid; $data['eid'] = $this->eid; $data['uid'] = $_SESSION['user']['id']; $data['date_created'] = Time::getLocalTime(); $this->db->setSQL($this->db->sqlBind($data, 'emergencies', 'I')); $this->db->execLog(); $this->emergencyId = $this->db->lastInsertId; }
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(); } } }
echo '<pre>'; $db = new MatchaHelper(); $file_handle = fopen("HCPC2013_A-N.csv", "r"); $rows = array(); $buff = array('code' => null, 'code_text' => null, 'code_text_short' => null); $count = 0; while (!feof($file_handle)) { $line = fgets($file_handle); $data = array(); $foo = explode("\t", $line); if ($count == 0) { $buff = array('code' => $foo[0], 'code_text' => $foo[3], 'code_text_short' => $foo[4]); } elseif ($buff['code'] != $foo[0]) { $rows[] = $buff; $buff = array('code' => $foo[0], 'code_text' => $foo[3], 'code_text_short' => $foo[4]); } else { $buff['code_text'] = $buff['code_text'] . ' ' . $foo[3]; } $count++; // $db->setSQL($db->sqlBind($data,'codes_icds','I')); // $db->execOnly(); } if (feof($file_handle)) { print 'The End!'; } fclose($file_handle); foreach ($rows as $row) { $db->setSQL($db->sqlBind($row, 'hcpcs_codes', 'I')); $db->execOnly(); } print_r($rows);
{ if (is_dir($dir)) { $objects = scandir($dir); foreach ($objects as $object) { if ($object != "." && $object != "..") { if (filetype($dir . "/" . $object) == "dir") { RemoveReclusiveDir($dir . "/" . $object); } else { unlink($dir . "/" . $object); } } } reset($objects); rmdir($dir); } return true; } //print '<h1>SQL Clean Up!</h1>'; foreach ($tables as $table) { $db->setSQL("TRUNCATE TABLE {$table}"); $err = $db->execOnly(); $msg = isset($err[1]) ? 'FAIL!' : 'PASS!'; //print 'Empty `' . $table . '` ' . $msg . '<br>'; } //print '<h1>Patient Directories Clean Up!</h1>'; $path = site_path . '/patients/'; $patientsDir = getDirectoryList($path); foreach ($patientsDir as $dir) { RemoveReclusiveDir($path . $dir); } print 'Factory Reset Complete!';
/** * Function: getPatientBalanceByPid */ public function getPatientBalanceByPid($pid) { $this->db->setSQL("SELECT SUM(amount) as balance FROM payment_transactions WHERE payer_id = '{$pid}'"); $balance_total = $this->db->fetchRecord(); return $balance_total['balance']; }
/** * @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]; }