public function Find() { $conn = parent::GetConnection(); $query = $this->SetupQuery(Query::FIND_STATISTICS); $result = odbc_exec($conn, $query); if (!$result) { return $this->HandleError(); } $row = array(); if (!odbc_fetch_into($result, $row)) { return $this->HandleError(); } $this->idDailyTask = $row[0]; $this->StatsClass = $row[1]; $this->StartDate = $row[2]; $this->EndDate = $row[3]; return true; }
public function ListStatistics($StartDateMin, $StartDateMax, $EndDateMin, $EndDateMax) { $StatsClass = substr($this->DailyTaskClass, 0, strlen($this->DailyTaskClass) - 4) . "Stats"; $conn = parent::GetConnection(); $query = Query::FIND_STATS_RANGE; $needles = array("%Key", "%idDailyTask", "%StatsClass", "%StartDateMin", "%StartDateMax", "%EndDateMin", "%EndDateMax"); $replace = array(Config::DB_KEY, $this->idDailyTask, $StatsClass, $StartDateMin, $StartDateMax, $EndDateMin, $EndDateMax); $query = str_replace($needles, $replace, $query); if (Config::DAO_DEBUG_MODE == 1) { print $query; } $result = odbc_exec($conn, $query); if (!$result) { $this->HandleError(); return null; } $row = array(); $statsArray = array(); $className = $StatsClass . "DAO"; while (odbc_fetch_into($result, $row)) { $statsArray[] = new $className(); $i = count($statsArray) - 1; $statsArray[$i]->idStatistics = $row[0]; $statsArray[$i]->Find(); } return $statsArray; }
public function ListPatients() { $this->Find(); if ($this->UserClass != "Clinician") { return array(); } $conn = parent::GetConnection(); $query = $this->SetupQuery(Query::LIST_PATIENTS); $patientArray = array(); $result = odbc_exec($conn, $query); if (!$result) { $this->HandleError($conn); return array(); } $row = array(); while (odbc_fetch_into($result, $row)) { $className = $row[1] . "DAO"; $patientArray[] = new $className(); $i = count($patientArray) - 1; $patientArray[$i]->Username = $row[0]; $patientArray[$i]->Find(); } return $patientArray; }