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();
}
}
}
/**
* @brief MatchaHelper constructor.
* @details This method starts the connection with mysql server using
* $_SESSION values
* during the login process.
*
* @author Gino Rivera (Certun) <*****@*****.**>
* @version Vega 1.0
*
*/
function __construct()
{
self::$__freeze = false;
// Connect to the database
// This is compatible with the old methods
if (defined('site_db_type')) {
self::connect(array('host' => site_db_host, 'port' => site_db_port, 'name' => site_db_database, 'user' => site_db_username, 'pass' => site_db_password, 'app' => ROOT . '/app'));
}
self::$__secretKey = site_aes_key;
MatchaAudit::$__audit = true;
MatchaAudit::$hookTable = 'audit_transaction_log';
MatchaAudit::$hookClass = 'MatchaHelper';
MatchaAudit::$hookMethod = 'storeAudit';
MatchaModel::setSenchaModel('App.model.administration.TransactionLog');
MatchaModel::setSenchaModel('App.model.administration.AuditLog');
}
/**
* Created by JetBrains PhpStorm.
* User: Untusoft
* Date: 3/20/12
* Time: 8:52 AM
* To change this template use File | Settings | File Templates.
*/
if (!isset($_SESSION)) {
session_name('Untusoft');
session_start();
session_cache_limiter('private');
}
include_once ROOT . '/classes/MatchaHelper.php';
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];
/**
* Created by JetBrains PhpStorm.
* User: ernesto
* Date: 7/4/12
* Time: 2:23 PM
* To change this template use File | Settings | File Templates.
*/
if (!isset($_SESSION)) {
session_name('GaiaEHR');
session_start();
session_cache_limiter('private');
}
define('_GaiaEXEC', 1);
include_once dirname(dirname(__FILE__)) . '/registry.php';
include_once dirname(dirname(__FILE__)) . '/classes/MatchaHelper.php';
$db = new MatchaHelper();
$tables = array('calendar_events', 'emergencies', 'encounters', 'encounter_services', 'encounter_1500_options', 'encounter_dictation', 'encounter_dx', 'encounter_history', 'encounter_procedures', 'encounter_review_of_systems', 'encounter_review_of_systems_check', 'encounter_services', 'encounter_soap', 'encounter_vitals', 'messages', 'users_sessions', 'patient', 'patient_allergies', 'patient_care_plan_goals', 'patient_cognitive_functional_status', 'patient_disclosures', 'patient_images', 'patient_immunizations', 'patient_medications', 'patient_notes', 'patient_active_problems', 'patient_dental', 'patient_doctors_notes', 'patient_family_history', 'patient_orders', 'patient_order_results', 'patient_order_results_observations', 'patient_pools', 'patient_labs_results', 'patient_labs', 'patient_documents', 'patient_pools', 'patient_prescriptions', 'patient_referrals', 'patient_reminders', 'patient_social_history', 'patient_disclosures', 'patient_surgery', 'patient_chart_checkout', 'patient_zone', 'preventive_care_inactive_patient', 'patient_insurances', 'audit_log', 'audit_transaction_log', 'payment_transactions', 'log');
function getDirectoryList($directory)
{
$results = array();
$handler = opendir($directory);
while ($file = readdir($handler)) {
if ($file != "." && $file != "..") {
$results[] = $file;
}
}
closedir($handler);
return $results;
}
function RemoveReclusiveDir($dir)
{
/**
* 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];
}
function __construct()
{
$this->conn = MatchaHelper::getConn();
}
