public function getList()
{
$list = $this->db->fetchAll('SELECT id, nazov FROM predmety');
$pair = array();
foreach ($list as $predmet) {
$pair[$predmet['id']] = $predmet['nazov'];
}
unset($list);
return $pair;
}
public function getList()
{
$list = $this->db->fetchAll('SELECT id, rocnik, kod FROM triedy');
$pair = array();
foreach ($list as $trieda) {
$pair[$trieda['id']] = ($trieda['rocnik'] < 4 ? str_repeat('I', $trieda['rocnik']) : 'IV') . '. ' . $trieda['kod'];
}
unset($list);
return $pair;
}
/**
* @When /^I select all records from the event table$/
*/
public function iSelectAllRecordsFromTheEventTable()
{
$sql = 'SELECT * FROM event';
$rows = self::$db->fetchAll($sql);
$this->qResult = $rows;
}
public function getNotes($zadanieId)
{
return $this->db->fetchAll("SELECT o.poznamka, p.login FROM odovzdania AS o" . " LEFT JOIN pouzivatelia AS p ON o.pouzivatel_id = p.id" . " WHERE o.zadanie_id = ? AND o.poznamka IS NOT NULL AND p.login IS NOT NULL", array($zadanieId));
}
