public function getAll(\Core\Database $db)
{
$recs = $db->fetchAllAssoc("select * from rooms", array());
$result = array();
for ($i = 0; $i < count($recs); $i++) {
$result[] = new \Application\RoomItem($recs[$i]);
}
return $result;
}
public function getAll(\Core\Database $db)
{
if ($recs = $db->fetchAllAssoc("select * from employees", array())) {
$result = array();
foreach ($recs as $record) {
$result[] = new \Application\EmpItem($record);
}
return $result;
} else {
return array();
}
}
public function getChain($chainId, \Core\Database $db)
{
$sql = "select * from appointments where chain=:chain";
if ($recs = $db->fetchAllAssoc($sql, array(":chain" => $chainId))) {
$result = new \Application\AppointmentChain();
foreach ($recs as $record) {
$result->add(new \Application\AppointmentItem($record));
}
return $result;
} else {
return new \Application\AppointmentChain();
}
}
