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