public function getPatientsArrivalLog(stdClass $params)
{
$visits = array();
foreach ($this->getPatientParentPools() as $visit) {
$id = $visit['id'];
$this->db->setSQL("SELECT pp.id, pa.title AS area, pp.time_out, pp.eid\n\t\t\t\t\t\t\t\t FROM patient_pools AS pp\n\t\t\t\t\t\t LEFT JOIN pool_areas AS pa ON pp.area_id = pa.id\n\t\t\t\t\t\t\t WHERE pp.parent_id = {$id}\n\t\t\t\t\t\t\t ORDER BY pp.id DESC");
$foo = $this->db->fetchRecord(PDO::FETCH_ASSOC);
$visit['area'] = $foo['area'];
$visit['area_id'] = $foo['id'];
$visit['name'] = ($foo['eid'] != null ? '*' : '') . $this->patient->getPatientFullNameByPid($visit['pid']);
$visit['warning'] = $this->patient->getPatientArrivalLogWarningByPid($visit['pid']);
$visit['warningMsg'] = $visit['warning'] ? 'Patient \'Sex\' or \'Date Of Birth\' not set' : '';
if ($foo['time_out'] == null) {
$visits[] = $visit;
}
}
return $visits;
}
public function getPatientsArrivalLog(stdClass $params)
{
$this->setPatient();
$this->setPaModel();
$visits = [];
foreach ($this->getPatientParentPools() as $visit) {
$id = $visit['id'];
$foo = $this->pa->sql("SELECT pp.id, pa.title AS area, pp.time_out, pp.eid\n\t\t\t\t\t\t\t\t FROM patient_pools AS pp\n\t\t\t\t\t\t LEFT JOIN pool_areas AS pa ON pp.area_id = pa.id\n\t\t\t\t\t\t\t WHERE pp.parent_id = '{$id}'\n\t\t\t\t\t\t\t ORDER BY pp.id DESC")->one();
$visit['area'] = $foo['area'];
$visit['area_id'] = $foo['id'];
$visit['name'] = ($foo['eid'] != null ? '*' : '') . $this->patient->getPatientFullNameByPid($visit['pid']);
$visit['warning'] = $this->patient->getPatientArrivalLogWarningByPid($visit['pid']);
$visit['warningMsg'] = $visit['warning'] ? 'Patient "Sex" or "Date Of Birth" not set' : '';
if ($foo['time_out'] == null) {
$visits[] = $visit;
}
}
return $visits;
}
public function getPatientsZonesByFloorPlanId($FloorPlanId)
{
$zones = array();
$this->db->setSQL("SELECT pz.id AS patientZoneId,\n\t\t\t\t\t\t\t\t pz.pid,\n\t\t\t\t\t\t\t\t pz.uid,\n\t\t\t\t\t\t\t\t pz.zone_id AS zoneId,\n\t\t\t\t\t\t\t\t time_in AS zoneTimerIn,\n\t\t\t\t\t\t\t\t fpz.floor_plan_id AS floorPlanId\n\t\t\t\t\t\t\t FROM patient_zone AS pz\n\t\t\t\t\t\tLEFT JOIN floor_plans_zones AS fpz ON pz.zone_id = fpz.id\n\t\t\t\t\t\t\tWHERE fpz.floor_plan_id = {$FloorPlanId} AND pz.time_out IS NULL");
foreach ($this->db->fetchRecords(PDO::FETCH_ASSOC) as $zone) {
$zone['patient'] = $this->patient->getPatientDemographicDataByPid($zone['pid']);
$zone['warning'] = $this->patient->getPatientArrivalLogWarningByPid($zone['pid']);
$pool = $this->pool->getCurrentPatientPoolAreaByPid($zone['pid']);
$zone['poolArea'] = $pool['poolArea'];
$zone['priority'] = $pool['priority'];
$zone['eid'] = $pool['eid'];
$zones[] = $zone;
}
return $zones;
}
public function getPatientsZonesByFloorPlanId($FloorPlanId)
{
$Patient = new Patient();
$Pool = new PoolArea();
$zones = $this->pz->sql("SELECT pz.id AS patientZoneId,\n\t\t\t\t\t\t\t\t pz.pid,\n\t\t\t\t\t\t\t\t pz.uid,\n\t\t\t\t\t\t\t\t pz.zone_id AS zoneId,\n\t\t\t\t\t\t\t\t time_in AS zoneTimerIn,\n\t\t\t\t\t\t\t\t fpz.floor_plan_id AS floorPlanId\n\t\t\t\t\t\t\t FROM patient_zone AS pz\n\t\t\t\t\t\tLEFT JOIN floor_plans_zones AS fpz ON pz.zone_id = fpz.id\n\t\t\t\t\t\t\tWHERE fpz.floor_plan_id = {$FloorPlanId} AND pz.time_out IS NULL")->all();
foreach ($zones as $i => $zone) {
$zone['patient'] = $Patient->getPatientDemographicDataByPid($zone['pid']);
$zone['name'] = $Patient->getPatientFullName();
$zone['warning'] = $Patient->getPatientArrivalLogWarningByPid($zone['pid']);
$pool = $Pool->getCurrentPatientPoolAreaByPid($zone['pid']);
$zone['poolArea'] = $pool['poolArea'];
$zone['priority'] = $pool['priority'];
$zone['eid'] = $pool['eid'];
$zones[$i] = $zone;
}
unset($Patient, $Pool);
return $zones;
}
