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);
