/** * @param stdClass $params * @return array * NOTES: Address of who?, * Naming: "getAddressesFromPatient" ??? */ public function getAddresses(stdClass $params) { $this->db->setSQL("SELECT *\n FROM users\n WHERE users.active = 1 AND ( users.authorized = 1 OR users.username = '' )\n LIMIT {$params->start},{$params->limit}"); $records = $this->db->fetchRecords(PDO::FETCH_ASSOC); $total = count($records); $rows = array(); foreach ($records as $row) { $row['fullname'] = Person::fullname($row['fname'], $row['mname'], $row['lname']); $row['fulladdress'] = Person::fulladdress($row['street'], $row['streetb'], $row['city'], $row['state'], $row['zip']); array_push($rows, $row); } return array('totals' => $total, 'rows' => $rows); }
public function logoutInactiveUsers() { $now = time(); $foo = $now - $_SESSION['inactive']['time']; $users = array(); $this->db->setSQL("SELECT id, uid FROM users_sessions WHERE last_request < {$foo} AND logout IS NULL"); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $user) { $id = $user['id']; $users[] = array('uid' => $user['uid']); $this->db->setSQL("UPDATE users_sessions SET logout = '{$now}' WHERE id = '{$id}'"); $this->db->execOnly(); } return $users; }
/** * Function: getPaymentsBySearch */ public function getPaymentsBySearch(stdClass $params) { // Declare all the variables that we are going to use. (array) ($patientPayments = ''); (int) ($total = 0); (string) ($sql = ''); (string) ($whereClause = ''); // Look between date the payment was created if ($params->datefrom && $params->dateto) { $whereClause .= chr(13) . " AND date_created BETWEEN '" . substr($params->datefrom, 0, -9) . " 00:00:00' AND '" . substr($params->dateto, 0, -9) . " 23:00:00'"; } // Look for the Paying Entity if ($params->payingEntityCombo) { $whereClause .= chr(13) . " AND paying_entity = '" . $params->payingEntityCombo . "'"; } // Look for the Patient if ($params->patientSearch) { $whereClause .= chr(13) . " AND paying_entity = '" . $params->payingEntityCombo . "'"; } // If the whereClause variable is used go ahead and // and add the where command. if ($whereClause) { $whereClause = 'WHERE ' . $whereClause; } $sql = "SELECT\n\t\t\t\t\tpatient_demographics.fname,\n\t\t\t\t\tpatient_demographics.mname,\n\t\t\t\t\tpatient_demographics.lname,\n\t\t\t\t\tpatient_demographics.pid,\n\t\t\t\t\tpayments.dtime,\n\t\t\t\t\tpayments.encounter,\n\t\t\t\t\tpayments.user,\n\t\t\t\t\tpayments.method,\n\t\t\t\t\tpayments.source,\n\t\t\t\t\tpayments.amount1,\n\t\t\t\t\tpayments.amount2,\n\t\t\t\t\tpayments.posted1,\n\t\t\t\t\tpayments.posted2\n\t\t\t\tFROM\n\t\t\t\t\tpayments\n\t\t\t\tINNER JOIN\n\t\t\t\t\tpatient_demographics \n\t\t\t\tON\n\t\t\t\t\tpatient_demographics.pid = payments.pid\n\t\t\t\t{$whereClause}"; $this->db->setSQL($sql); // Loop through the results. // in here you can do calculations or other stuff. foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) { $patientPayments[] = $row; } $total = count($patientPayments); // Return the results back to ExtJS. return array('totals' => $total, 'rows' => $patientPayments); }
public function getPatientFutureEventsByPid($pid) { $date = Time::getLocalTime(); $tomorrow = date('Y-m-d 0000:00:00', strtotime($date . ' + 1 days')); $this->db->setSQL("SELECT * FROM calendar_events WHERE patient_id = '{$pid}' AND start >= '{$tomorrow}'"); return $this->db->fetchRecords(PDO::FETCH_ASSOC); }
public function getTemplatesTypes() { $this->db->setSQL("SELECT DISTINCT title, body\n \t FROM documents_templates\n \t WHERE template_type ='documenttemplate'"); $records = $this->db->fetchRecords(PDO::FETCH_ASSOC); $records[] = array('title' => 'Empty'); return $records; }
/** * @param $parent * @return array * * Here we use the parent id to get the child items and it options * using basically the same logic of getFields() function and returning * an array of child items */ function getChildItems($parent) { $items = array(); $this->db->setSQL("Select * FROM forms_fields WHERE parentId = '{$parent}' ORDER BY pos ASC"); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $item) { $opts = $this->getItemsOptions($item['id']); foreach ($opts as $opt => $val) { $item[$opt] = $val; } /** * If the item is a combo box lets create a store... */ if ($item['xtype'] == 'combobox') { $item = $this->getComboDefaults($item); $item['store'] = $this->getStore($item['list_id']); } if ($item['xtype'] == 'datefield') { $item['format'] = 'Y-m-d'; } /** * this if what makes this function reclusive this function will keep * calling it self */ $item['items'] = $this->getChildItems($item['id']); if ($item['items'] == null) { unset($item['items']); } unset($item['id'], $item['form_id'], $item['parentId'], $item['pos']); array_push($items, $item); } return $items; }
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 getMedicationAttributesByCODE($CODE) { $this->db->setSQL("\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DST' AND `SAB` = 'MMSL'\n UNION\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DRT' AND `SAB` = 'MMSL'\n UNION\n SELECT `ATV`, `ATN` FROM rxnsat WHERE `CODE` = '{$CODE}' AND `ATN` = 'DDF' AND `SAB` = 'MMSL'\n "); $foo = array(); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $fo) { $foo[$fo['ATN']] = $fo['ATV']; } return $foo; }
private function getPatientsByPoolAreaId($area_id, $in_queue) { $this->db->setSQL("SELECT pp.*\n\t\t\t\t\t\t\t FROM patient_pools AS pp\n\t\t\t\t\t\t\tWHERE pp.area_id = '{$area_id}'\n\t\t\t\t\t\t\t AND pp.time_out IS NULL\n\t\t\t\t\t\t\t AND pp.in_queue = '{$in_queue}'"); $records = array(); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $patient) { $patient['name'] = ($patient['eid'] != null ? '*' : '') . $this->patient->getPatientFullNameByPid($patient['pid']); $records[] = $patient; } return $records; }
/** * @static * @return mixed */ public static function setGlobals() { $conn = new dbHelper(); $conn->setSQL("SELECT gl_name, gl_value FROM globals"); foreach ($conn->fetchRecords(PDO::FETCH_ASSOC) as $setting) { $_SESSION['global_settings'][$setting['gl_name']] = $setting['gl_value']; } $_SESSION['global_settings']['timezone_offset'] = -14400; $_SESSION['global_settings']['date_time_display_format'] = $_SESSION['global_settings']['date_display_format'] . ' ' . $_SESSION['global_settings']['time_display_format']; return $_SESSION['site']['path']; }
/** * @param stdClass $params * @return array */ public function getFacilities(stdClass $params) { if (isset($params->active)) { $wherex = 'active = ' . $params->active; } else { $wherex = 'active = 1'; } if (isset($params->sort)) { $orderx = $params->sort[0]->property . ' ' . $params->sort[0]->direction; } else { $orderx = 'name'; } $sql = "SELECT * FROM facility WHERE {$wherex} ORDER BY {$orderx} LIMIT {$params->start},{$params->limit}"; $this->db->setSQL($sql); $rows = array(); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) { if (strlen($row['pos_code']) <= 1) { $row['pos_code'] = '0' . $row['pos_code']; } array_push($rows, $row); } return $rows; }
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', "id='{$id}'")); $this->db->execOnly(); } } }
private function getGraphCurves($type, $sex) { $this->db->setSQL("SELECT * FROM vector_graphs WHERE type = '{$type}' AND sex = '{$sex}'"); $records = array(); foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $row) { unset($row['type'], $row['sex'], $row['L'], $row['M'], $row['S']); foreach ($row as $key => $val) { if ($val == null) { unset($row[$key]); } } $records[] = $row; } return $records; }
/** * @internal param $user_id * @return array */ public function getUserPerms() { $this->conn->setSQL("SELECT * FROM acl_user_perms WHERE user_id = '{$this->user_id}' ORDER BY add_date ASC"); $perms = array(); foreach ($this->conn->fetchRecords(PDO::FETCH_ASSOC) as $row) { $pK = strtolower($row['perm_key']); if ($pK == '') { continue; } if ($row['value'] == '1') { $hP = true; } else { $hP = false; } $perms[$pK] = array('perm' => $pK, 'inheritted' => false, 'value' => $hP, 'Name' => $this->getPermNameByPermKey($row['perm_key']), 'id' => $row['id']); } return $perms; }
private function getFloorPlanZonesByFloorPlanId($floor_plan_id) { $this->db->setSQL("SELECT * FROM floor_plans_zones WHERE floor_plan_id = '{$floor_plan_id}'"); return $this->db->fetchRecords(PDO::FETCH_ASSOC); }
/** * @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_codes_cpt 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 array('totals' => count($records), 'rows' => $records); }
public function getPreventiveCareDismissedAlertsByPid(stdClass $params) { $this->db->setSQL("SELECT pcig.id,\n pcig.preventive_care_id,\n pcig.reason,\n pcig.dismiss,\n pcig.date,\n pcig.observation,\n pcg.description\n FROM preventive_care_inactive_patient as pcig\n LEFT JOIN preventive_care_guidelines as pcg on pcig.preventive_care_id = pcg.id\n WHERE pcig.pid = '{$params->pid}'\n AND pcig.dismiss = 1"); return $this->db->fetchRecords(); }
public function getUserRolesByCurrentUserOrUserId($uid = null) { $uid = $uid == null ? $_SESSION['user']['id'] : $uid; $this->db->setSQL("SELECT * FROM acl_user_roles WHERE user_id = '{$uid}'"); return $this->db->fetchRecords(PDO::FETCH_ASSOC); }
public function getEncounterHCFAOptionsByEid($eid) { $this->db->setSQL("SELECT * FROM encounter_hcfa_1500_options WHERE eid = '{$eid}'"); return $this->db->fetchRecords(PDO::FETCH_ASSOC); }
public function getPatientDisclosures(stdClass $params) { $this->db->setSQL("SELECT * FROM patient_disclosures WHERE pid = '{$params->pid}'"); return $this->db->fetchRecords(); }