public function getCCDAComponents($type)
{
$components = array();
$query = "select * from ccda_components where ccda_type = ?";
$appTable = new ApplicationTable();
$result = $appTable->zQuery($query, array($type));
foreach ($result as $row) {
$components[$row['ccda_components_field']] = $row['ccda_components_name'];
}
return $components;
}
/**
* @param array $parameters
* @return array
*/
public function getPatients(array $parameters)
{
//You can use this function to write whatever rules that you need from the DB
//$sql="SELECT * FROM patient_data WHERE fname like ".$parameters['fname']." OR lname like ".$parameters['lname'] ." OR DOB like ".$parameters['DOB'];
$obj = new ApplicationTable();
$sql = " SELECT * FROM patient_data WHERE fname like ? OR lname like ? OR DOB like ? OR pubpid = ?";
$params = array($parameters['fname'], $parameters['lname'], $parameters['DOB'], isset($parameters['pubpid']) ? $parameters['pubpid'] : '');
$rowset = $obj->zQuery($sql, $params);
$results = array();
foreach ($rowset as $row) {
$results[] = $row;
}
return $results;
}
public function getRefferals($pid, $encounter)
{
$appTable = new ApplicationTable();
$referrals = '';
$query = "SELECT field_value FROM transactions JOIN lbt_data ON form_id=id AND field_id = 'body' WHERE pid = ?";
$result = $appTable->zQuery($query, array($pid));
$referrals = '<referral_reason>';
foreach ($result as $row) {
$referrals .= '<text>' . htmlspecialchars($row['field_value']) . '</text>';
}
$referrals .= '</referral_reason>';
return $referrals;
}
public function update_document_table($document_id, $audit_master_id, $audit_master_approval_status)
{
$appTable = new ApplicationTable();
$query = "UPDATE documents \n SET audit_master_id = ?,\n imported = ?,\n audit_master_approval_status=? \n WHERE id = ?";
$appTable->zQuery($query, array($audit_master_id, 1, $audit_master_approval_status, $document_id));
}
public function update_imported($document_id)
{
$appTable = new ApplicationTable();
$appTable->zQuery("UPDATE documents SET imported = 1 WHERE id = ?", array($document_id));
}
public function getRefferals($pid, $encounter)
{
$appTable = new ApplicationTable();
$referrals = '';
$query = "SELECT body FROM transactions WHERE pid = ?";
$result = $appTable->zQuery($query, array($pid));
$referrals = '<referral_reason>';
foreach ($result as $row) {
$referrals .= '<text>' . htmlspecialchars($row['body']) . '</text>';
}
$referrals .= '</referral_reason>';
return $referrals;
}
public function getList($list_id, $selected = '', $opt = '')
{
$appTable = new ApplicationTable();
$this->listenerObject = new Listener();
$res = $appTable->zQuery("SELECT * FROM list_options WHERE list_id=? ORDER BY seq, title", array($list_id));
$i = 0;
if ($opt == 'search') {
$rows[$i] = array('value' => 'all', 'label' => $this->listenerObject->z_xlt('All'), 'selected' => TRUE);
$i++;
} elseif ($opt == '') {
$rows[$i] = array('value' => '', 'label' => $this->listenerObject->z_xlt('Unassigned'), 'disabled' => FALSE);
$i++;
}
foreach ($res as $row) {
$sel = $row['option_id'] == $selected ? TRUE : FALSE;
$rows[$i] = array('value' => htmlspecialchars($row['option_id'], ENT_QUOTES), 'label' => $this->listenerObject->z_xlt($row['title']), 'selected' => $sel);
$i++;
}
return $rows;
}
public function fetchXmlDocuments()
{
$obj = new ApplicationTable();
$query = "SELECT doc.id \n\t FROM categories_to_documents AS cat_doc\n\t JOIN documents AS doc ON doc.imported = 0 AND doc.id = cat_doc.document_id AND doc.mimetype = 'text/xml'\n\t WHERE cat_doc.category_id = 1";
$result = $obj->zQuery($query);
$count = 0;
$module = array();
foreach ($result as $row) {
$content = \Documents\Plugin\Documents::getDocument($row['id']);
$module[$count]['doc_id'] = $row['id'];
if (preg_match("/<ClinicalDocument/", $content)) {
if (preg_match("/2.16.840.1.113883.3.88.11.32.1/", $content)) {
$module[$count]['doc_type'] = 'CCD';
} else {
$module[$count]['doc_type'] = 'CCDA';
}
} elseif (preg_match("/<ccr:ContinuityOfCareRecord/", $content)) {
$module[$count]['doc_type'] = 'CCR';
}
$count++;
}
return $module;
}
/**
* deleteDocument - remove document from list
* @param Int $docid
*/
public function deleteDocument($docid)
{
$obj = new ApplicationTable();
$sql = "UPDATE \n `documents` \n SET\n `activity` = ? \n WHERE `id` = ?";
$obj->zQuery($sql, array(0, $docid));
}
public function getListtitle($listId, $listOptionId)
{
$appTable = new ApplicationTable();
$sql = "SELECT title FROM list_options WHERE list_id = ? AND option_id = ? ";
$result = $appTable->zQuery($sql, array($listId, $listOptionId));
$row = $result->current();
$return = xl_list_label($row['title']);
return $return;
}
public function updateExistingMappedFields($values)
{
$appTable = new ApplicationTable();
$res = $appTable->zQuery("update ccda_table_mapping set deleted = 1 where id <= ? and user_id = ?", $values);
}
/**
*Update document category using category name
*@param $category_name - Name of the category to which the document has to be moved
*@param $document_id - Documents whose category has to be updated with $category_name
*/
public function updateDocumentCategoryUsingCatname($category_name, $document_id)
{
$obj = new ApplicationTable();
$sql = "UPDATE categories_to_documents \n JOIN categories ON `name` = ?\n SET category_id=id\n WHERE document_id = ?";
$result = $obj->zQuery($sql, array($category_name, $document_id));
}
public function getList($list)
{
$appTable = new ApplicationTable();
$query = "SELECT title,option_id,notes,codes FROM list_options WHERE list_id = ?";
$result = $appTable->zQuery($query, array($list));
$records = array();
foreach ($result as $row) {
$records[] = $row;
}
return $records;
}
public function deleteACLSections($module_id)
{
$obj = new ApplicationTable();
$sql = "DELETE FROM module_acl_sections WHERE module_id =? AND parent_section <> 0";
$obj->zQuery($sql, array($module_id));
$sqsl = "DELETE FROM modules_settings WHERE mod_id =? AND fld_type = 1";
$obj->zQuery($sql, array($module_id));
}
public function getLatestEncounter($pid)
{
$encounter = '';
$appTable = new ApplicationTable();
$query = "SELECT encounter FROM form_encounter WHERE pid = ? ORDER BY id DESC LIMIT 1";
$result = $appTable->zQuery($query, array($pid));
foreach ($result as $row) {
$encounter = $row['encounter'];
}
return $encounter;
}
public function AddNewUSer($data = array())
{
$fname = $data['fname'];
$lname = $data['lname'];
$direct_address = $data['direct_address'];
$appTable = new ApplicationTable();
$query = "INSERT INTO users SET username = ? ,password = ? ,authorized = ?,fname = ?,lname = ?,email = ?,active = ?,abook_type = ?";
$appTable->zQuery($query, array('', '', 0, $fname, $lname, $direct_address, 1, 'emr_direct'));
}
public function getModuleSections($module_id)
{
$sql = "SELECT * FROM module_acl_sections WHERE module_id = ?";
$obj = new ApplicationTable();
$result = $obj->zQuery($sql, array($module_id));
return $result;
}
public function getCodes($option_id, $list_id)
{
$appTable = new ApplicationTable();
if ($option_id) {
$query = "SELECT notes \n FROM list_options \n WHERE list_id=? AND option_id=?";
$result = $appTable->zQuery($query, array($list_id, $option_id));
$res_cur = $result->current();
}
return $res_cur['notes'];
}
public function getCareTeamProviderId($pid)
{
$appTable = new ApplicationTable();
$query = "SELECT care_team FROM patient_data WHERE `pid` = ?";
$result = $appTable->zQuery($query, array($pid));
$row = $result->current();
return $row['care_team'];
}