public function insert($data)
{
try {
parent::insert($data);
} catch (\DibiException $e) {
}
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_class");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_class.*, user.firstname AS teacher_firstname, user.lastname AS teacher_lastname, COUNT(sch_student.user_id) as students")->leftJoin("user")->on("sch_class.teacher_id = user.id")->leftJoin("sch_student")->on("sch_class.id = sch_student.class_id")->groupBy("sch_class.id");
$this->setPrimaryKey("sch_class.id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_group_membership");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("user.*, user_id AS user_id")->join("user")->on("sch_group_membership.user_id = user.id");
$this->setPrimaryKey("sch_group_membership.user_id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_load");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_load.*, sch_subject.name AS subject_name, sch_group.name AS group_name, user.firstname AS teacher_firstname, user.lastname AS teacher_lastname, sch_class.shortname AS class_name, user.id AS user_id")->leftJoin("sch_subject")->on("sch_load.sch_subject_id = sch_subject.id")->leftJoin("sch_group")->on("sch_load.sch_group_id = sch_group.id")->leftJoin("sch_teacher")->on("sch_load.sch_teacher_id = sch_teacher.user_id")->leftJoin("user")->on("sch_teacher.user_id = user.id")->leftJoin("sch_class")->on("sch_group.sch_class_id = sch_class.id");
$this->setPrimaryKey("sch_load.id");
}
public function __construct(\DibiConnection $connection)
{
parent::__construct($connection, "wrk_work");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("wrk_work.*, user.firstname, user.lastname, wrk_set.name as set_name")->leftJoin("user")->on("wrk_work.user_id = user.id")->leftJoin("wrk_set")->on("wrk_work.wrk_set_id = wrk_set.id");
$this->setPrimaryKey("wrk_work.id");
}
public function __construct(\DibiConnection $connection)
{
parent::__construct($connection, "wrk_assignment");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("wrk_assignment.*, user.firstname, user.lastname, count(wrk_work.id) as works")->leftJoin("user")->on("wrk_assignment.user_id = user.id")->leftJoin("wrk_work")->on("wrk_assignment.id = wrk_work.wrk_assignment_id")->groupBy("wrk_assignment.id");
$this->setPrimaryKey("wrk_assignment.id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_subject");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_subject.*,SUM(hours) AS hours")->leftJoin("sch_load")->on("sch_load.sch_subject_id = sch_subject.id")->groupBy("sch_subject.id");
$this->setPrimaryKey("sch_subject.id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_group");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_group.*, sch_class.shortname AS class, count(user_id) AS members")->join("sch_class")->on("sch_group.sch_class_id = sch_class.id")->leftJoin("sch_group_membership")->on("sch_group_membership.sch_group_id = sch_group.id")->groupBy("sch_group.id");
$this->setPrimaryKey("sch_group.id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_teacher");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_teacher.*, user.firstname, user.lastname, user.title, user.title_after, user.email, user.phone, user.gender, SUM(sch_load.hours) AS hours")->join("user")->on("sch_teacher.user_id = user.id")->leftJoin("sch_load")->on("sch_load.sch_teacher_id = sch_teacher.user_id")->groupBy("sch_teacher.user_id");
$this->setPrimaryKey("sch_teacher.user_id");
}
public function __construct(\DibiConnection $connection, \Nette\Security\User $user)
{
parent::__construct($connection, "sch_student");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("sch_student.*, user.firstname, user.lastname, user.title, user.title_after, user.email, user.phone, user.gender, sch_class.shortname AS class")->join("user")->on("sch_student.user_id = user.id")->leftJoin("sch_class")->on("sch_student.class_id = sch_class.id");
$this->setPrimaryKey("sch_student.user_id");
}
public function __construct(\DibiConnection $connection)
{
//odpoved je ve WorksPresenter - model je treba model->getSomeSelection($id);
parent::__construct($connection, "act_works");
$this->getSelection()->removeClause("SELECT");
$this->getSelection()->select("act_works.*, user.firstname as fn, user.lastname as ln, group.name as pk")->leftJoin("user")->on("act_works.user_id = user.id")->leftJoin("group")->on("act_works.act_notebooks_id = group.id")->where("group.pk = ?", 1)->groupBy("act_works.id");
$this->setPrimaryKey("act_works.id");
$this->pkGroups = $this->getWorksPkHead();
}
public function __construct(\DibiConnection $connection)
{
parent::__construct($connection, "wrk_set");
}
