public function getFieldByEvent(SxCms_Event $event)
{
$db = Zend_Registry::get('db');
$select = $db->select()->from('EventField', array('*'))->where('event_id = ?', $event->getId())->where('language = ?', $event->getLanguage());
$results = $db->fetchAll($select);
foreach ($results as $result) {
$eventfield = new SxCms_Event_Field();
$eventfield->setId($result['field_id'])->setEventId($result['event_id'])->setLanguage($result['language'])->setLabel($result['label'])->setName($result['name'])->setType($result['type']);
$event->addFields($eventfield, $result['field_id']);
$proxy = new SxCms_Event_Field_List_DataMapper();
$proxy->getListByField($eventfield);
}
return;
}
public function getAllEvents()
{
$db = Zend_Registry::get('db');
$select = $db->select()->from(array('e' => 'Event'), array('*'))->join(array('t' => 'EventTsl'), 'e.event_id = t.event_id', array('language', 'title', 'description', 'mail_remember', 'mail_confirmation'))->where('t.language = ?', $_SESSION['System']['lng'])->order('datetime_event');
$results = $db->fetchAll($select);
$events = array();
foreach ($results as $result) {
$date = split(' ', $result['datetime_event']);
$event = new SxCms_Event();
$event->setId((int) $result['event_id'])->setLanguage($result['language'])->setTitle($result['title'])->setDescription($result['description'])->setDateEvent($date[0])->setTimeEvent($date[1])->setLocation($result['location'])->setMailRemember($result['mail_remember'])->setMailConfirmation($result['mail_confirmation'])->setSubscriptionAllow($result['subscription_allow'])->setSubscriptionMax($result['subscription_max'])->setDateStart($result['date_start'])->setDateEnd($result['date_end'])->setRememberDays($result['remember_days'])->setConfirmationLink($result['confirmation_link'])->setValidateIntern($result['validate_intern']);
$events[] = $event;
}
return $events;
}
