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 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 updateCptCode(stdClass $params) { $data = get_object_vars($params); unset($data['id'], $data['eid'], $data['code'], $data['code_text'], $data['code_text_medium']); $params->id = intval($params->id); $this->db->setSQL($this->db->sqlBind($data, 'encounter_services', 'U', "id='{$params->id}'")); $this->db->execLog(); return ['totals' => 1, 'rows' => $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 reviewMedicalWindowEncounter(stdClass $params) { $data = get_object_vars($params); $eid = $data['eid']; $area = $data['area']; unset($data['area'], $data['eid']); $data[$area] = 1; $this->db->setSQL($this->db->sqlBind($data, 'encounters', 'U', array('eid' => $eid))); $this->db->execLog(); return array('success' => true); }
/** * Function: addPayment */ public function addPayment(stdClass $params) { $data = get_object_vars($params); $this->db->setSQL($this->db->sqlBind($data, "payment_transactions", "I")); $this->db->execLog(); if ($this->db->lastInsertId == 0) { return (array) ($success = 'false'); } else { return (array) ($success = 'true'); } }
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);