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