protected function build()
{
$this->select[] = 'group_information.*';
if ($this->event) {
$this->joins[] = " JOIN event_in_group AS event_in_group ON event_in_group.group_id = group_information.id " . " AND event_in_group.event_id = :event_id ";
$this->params['event_id'] = $this->event->getId();
}
}
public function addEventToGroup(EventModel $event, GroupModel $group)
{
$stat = $this->siteContainer['databasehelper']->getPDO()->prepare("SELECT * FROM event_in_group WHERE group_id=:group_id AND " . " event_id=:event_id ");
$stat->execute(array('group_id' => $group->getId(), 'event_id' => $event->getId()));
if ($stat->fetch()) {
return;
}
$stat = $this->siteContainer['databasehelper']->getPDO()->prepare("INSERT INTO event_in_group " . "(event_id, group_id )" . " VALUES " . "(:event_id, :group_id)");
$stat->execute(array('event_id' => $event->getId(), 'group_id' => $group->getId()));
}
