public function handleRequest($command, $date = NULL)
{
$events = Event::find($command, $date);
if (empty($events)) {
throw new Exception("Nothing found");
}
$formattedEvents = Event::format($events);
render('event', array('events' => $formattedEvents));
}
public function destroy($id)
{
// delete
$event = Event::find($id);
$event->delete();
// redirect
Session::flash('message', 'Successfully deleted the event!');
return Redirect::to('events');
}
function index() {
$recent_events = Event::find()->where(array('created_at >= NOW() - INTERVAL 1 WEEK'))->order('created_at DESC')->all();
$find_news = News::find()
->order(array('weight ASC', 'updated_at DESC'))
->limit(5);
$this->render(array(
'recent_events' => $recent_events,
'news' => $find_news->all(),
));
}
function create()
{
$types = Event::getTypes();
RoutingEngine::getSmarty()->assign("event_types", $types);
if (isset($_GET["eid"])) {
$eid = $_GET["eid"];
$event = Event::find($eid);
if ($event->uid == User::$current_user->uid) {
RoutingEngine::getSmarty()->assign("event", $event);
}
}
}
function show($params) {
$char = Character::find()->where(array('guid' => $params['guid']))->realm($params['rid'])->first();
$events = Event::find()->where(array('target_class' => 'Character', 'target_dbid' => $params['rid'], 'target_id' => $params['guid']));
$cheats = CheatLogEntry::find()->realm($params['rid'])->where(array('guid' => $params['guid']));
if ($char->guid == $params['guid']) {
$this->render(array(
'character' => $char,
'events_count' => $events->count(),
'cheats_count' => $cheats->count()
));
} else {
$this->render_error('404');
}
}
function sync_dbid(){
Event::$per_page = null;
$events = Event::find()->all();
foreach($events as $event){
$target = unserialize($event->target_obj);
if($target->realm != null && $target->realm->id != $event->target_dbid){
$event->target_dbid = $target->realm->id;
echo "missing dbid in event " . $event->id . " - actual: " . $event->target_dbid . " correct: " . $target->realm->id;
if($event->save())
echo " - currected <br>\n";
else
echo " - can't correct <br>\n";
}
}
}
public function test_belongs_to_returns_null_when_no_record()
{
$event = Event::find(6);
$this->assert_null($event->venue);
}
/**
* Allows a user to cancel an event
*
*/
public function cancelEventAction()
{
$get = Zend_Registry::get('getFilter');
if (!isset($get->eventId)) {
throw new Ot_Exception_Input('msg-error-eventIdNotSet');
}
$workshop = new Workshop();
$event = new Event();
$location = new Location();
$thisEvent = $event->find($get->eventId);
if (is_null($thisEvent)) {
throw new Ot_Exception_Data('msg-error-noEvent');
}
$i = new Event_Instructor();
$where = $i->getAdapter()->quoteInto('eventId = ?', $get->eventId);
$results = $i->fetchAll($where);
$currentInstructors = array();
foreach ($results as $r) {
$currentInstructors[] = $r->accountId;
}
if (!$this->_helper->hasAccess('view-all-instructor-pages') && !in_array(Zend_Auth::getInstance()->getIdentity()->accountId, $currentInstructors)) {
throw new Ot_Exception_Access('msg-error-noWorkshopAccess');
}
$thisEvent = $thisEvent->toArray();
$thisEvent['startTime'] = strftime('%l:%M %p', strtotime($thisEvent['startTime']));
$thisEvent['endTime'] = strftime('%l:%M %p', strtotime($thisEvent['endTime']));
$thisEvent['location'] = $location->find($thisEvent['locationId'])->toArray();
$thisEvent['workshop'] = $workshop->find($thisEvent['workshopId'])->toArray();
$this->view->event = $thisEvent;
$form = Ot_Form_Template::delete('eventDelete', 'workshop-schedule-cancelEvent:cancel');
if ($this->_request->isPost() && $form->isValid($_POST)) {
$dba = $event->getAdapter();
$dba->beginTransaction();
$where = $dba->quoteInto('eventId = ?', $get->eventId);
$data = array('status' => 'canceled');
try {
$result = $event->update($data, $where);
} catch (Exception $e) {
$dba->rollback();
throw $e;
}
$attendee = new Event_Attendee();
try {
$attendee->update($data, $where);
} catch (Exception $e) {
$dba->rollback();
throw $e;
}
$dba->commit();
$this->_helper->flashMessenger->addMessage('msg-info-eventCanceled');
$date = explode('-', $thisEvent['date']);
$this->_helper->redirector->gotoUrl('/workshop/schedule?startYear=' . $date[0] . '&startMonth=' . (int) $date[1]);
}
$this->_helper->pageTitle('workshop-schedule-cancelEvent:title');
$this->view->form = $form;
}
public function v152()
{
// Regenerate cache
Cache::clear(false);
// Timezone
$this->Setting->setOption('timezone', 'Europe/Paris');
// Update events registration end date
App::uses('Event', 'Model');
$EventModel = new Event();
$params = array();
$params['recursive'] = -1;
$params['fields'] = array('id', 'time_start', 'time_inscription');
$params['conditions']['time_inscription'] = null;
if ($events = $EventModel->find('all', $params)) {
foreach ($events as $event) {
$EventModel->query("UPDATE " . $EventModel->tablePrefix . "events SET time_inscription='" . $event['Event']['time_start'] . "' WHERE id = " . $event['Event']['id']);
}
}
}
public function test_eager_loading_clones_related_objects()
{
$events = Event::find(array(2, 3), array('include' => array('venue')));
$venue = $events[0]->venue;
$venue->name = "new name";
$this->assert_equals($venue->id, $events[1]->venue->id);
$this->assert_not_equals($venue->name, $events[1]->venue->name);
$this->assert_not_equals(spl_object_hash($venue), spl_object_hash($events[1]->venue));
}
public function award()
{
if ($this->post) {
$achievement = $this->load_achievement($this->PostData('achievement_id'));
$user_temp = $this->PostData('users');
if (!is_array($user_temp)) {
$user_temp = explode(',', $user_temp);
}
$error_on = array();
$success = 0;
foreach ($user_temp as $name_temp) {
$user_id = mysql_real_escape_string($name_temp);
$user = User::find_by_id($user_id);
if ($user) {
if ($achievement->award($user, $this->PostData("category_id"))) {
$success++;
} else {
$error_on[] = $name;
}
} else {
$error_on[] = $name;
}
}
if (count($user_temp) == 1) {
if ($success == 1) {
Site::InstantFlash("notice", "{$user->nickname} has been awarded {$achievement->name}");
} else {
Site::InstantFlash("error", "Unable to award achievement");
}
} else {
if ($success == 0) {
Site::InstantFlash("error", "Unable to award achievements to any of the users listed");
} elseif (count($error_on) > 0) {
Site::InstantFlash("error", "Awarded achievement to {$success} user" . ($success != 1 ? "s" : "") . ", failed to award to " . implode(", ", $error_on));
} else {
Site::InstantFlash("notice", "Awarded achievements to all users listed.");
}
}
}
$filters = array();
$pageQuery = '';
if ($this->GetData('query')) {
$pageQuery = $this->GetData('query');
$query = mysql_real_escape_string($this->GetData('query'));
$filters[] = "users.nickname LIKE '%{$query}%'";
}
$filter = implode('AND', $filters);
$achievement_id = null;
if ($this->GetData('achievement_id')) {
$achievement_id = $this->GetData('achievement_id');
}
$page = 1;
if ($this->GetData('page')) {
$page = $this->GetData('page');
}
$users = User::paginate($filter, 'users.nickname ASC', $page, 50);
$achievements = Achievement::find_all("", "achievements.created_at ASC");
$achlist = array();
foreach ($achievements as $ach) {
$achlist[$ach->id] = "{$ach->id}. {$ach->name}";
}
// Yay - Magic Numbers!
$category_id = 11;
$categories = array();
$all_categories = array();
$all_categories = AchievementCategory::find_all();
foreach ($all_categories as $category) {
$event = Event::find("achievement_category_id={$category->id}");
if (!$event || $event->check_user(Site::CurrentUser()) && $event->display_achievements) {
$categories[$category->id] = $category->category_name;
if ($category->default_category) {
$category_id = $category->id;
}
}
}
if ($this->GetData('category_id')) {
$category_id = $this->GetData('category_id');
}
$this->assign("achievements", $achlist);
$this->assign("categories", $categories);
$this->assign("category_id", $category_id);
$this->assign("achievement_id", $achievement_id);
$this->assign("users", $users);
$this->assign('pagequery', $pageQuery);
$this->title = "Award Achievement";
$this->render("achievement/award.tpl");
}
$row = Group::find($id);
$row->delete();
} else {
// Set error.
$error = "CantDeleteGroup";
$message = "The group could not be deleted since they are persons that belong to them";
$statusCode = 422;
}
}
// Event.
if ($type == "event") {
// Verify if the event is used by assistances.
$count = Assistance::count(array('conditions' => 'event_id = ' . $id));
if ($count <= 0) {
// Delete event.
$row = Event::find($id);
$row->delete();
} else {
// Set error.
$error = "CantDeleteEvent";
$message = "The event could not be deleted since some assistance lists are linked to him";
$statusCode = 422;
}
}
// Person.
if ($type == "person") {
// Verify if the person is used by assistances.
$count = Assistance::count(array('conditions' => 'person_id = ' . $id));
if ($count <= 0) {
// Delete person.
$row = Person::find($id);
<?php
$res->currentPage = isset($currentPage) ? $currentPage : 1;
$res->limit = $args['limit'] = isset($limit) ? $limit : 20;
$args['offset'] = ($res->currentPage - 1) * $args['limit'];
$args['order'] = isset($order) ? $order : 'updated_at desc';
if (isset($event) && is_numeric($event) && Event::find($event)->user_id == $res->membre->id) {
$res->events = array(Event::find($event));
} else {
$res->events = $res->membre->id == $res->user->id ? $res->membre->getEvents(true, $args) : $res->membre->getEvents(false, $args);
$res->total = $res->membre->id == $res->user->id ? $res->membre->getEvents(true)->count : $res->membre->getEvents(false)->count;
}
$res->useTemplate();
/**
* Allows a user to cancel their reservation for an event.
*
*/
public function cancelAction()
{
$get = Zend_Registry::get('getFilter');
if (!isset($get->eventId)) {
throw new Ot_Exception_Input('msg-error-eventIdNotSet');
}
$event = new Event();
$location = new Location();
$workshop = new Workshop();
$instructor = new Event_Instructor();
$attendee = new Event_Attendee();
$thisEvent = $event->find($get->eventId);
if (is_null($thisEvent)) {
throw new Ot_Exception_Data('msg-error-noEvent');
}
$this->view->event = $thisEvent->toArray();
$status = $event->getStatusOfUserForEvent(Zend_Auth::getInstance()->getIdentity()->accountId, $thisEvent->eventId);
if ($status != 'waitlist' && $status != 'attending') {
throw new Ot_Exception_Data('msg-error-notAttending');
}
$this->view->status = $status;
$this->view->reservationCancelable = $event->isReservationCancelable($thisEvent->eventId);
$thisLocation = $location->find($thisEvent->locationId);
if (is_null($thisLocation)) {
throw new Ot_Exception_Data('msg-error-noLocation');
}
$this->view->location = $thisLocation->toArray();
$thisWorkshop = $workshop->find($thisEvent->workshopId);
if (is_null($thisWorkshop)) {
throw new Ot_Exception_Data('msg-error-noWorkshop');
}
$this->view->workshop = $thisWorkshop->toArray();
$instructors = $instructor->getInstructorsForEvent($thisEvent->eventId);
$inst = array();
foreach ($instructors as $i) {
$inst[] = $i['firstName'] . ' ' . $i['lastName'];
}
$this->view->instructors = $inst;
$events = $event->getEvents($thisWorkshop->workshopId, null, null, time(), null, 'open')->toArray();
$newEvents = array();
foreach ($events as $e) {
if ($e['eventId'] != $thisEvent->eventId) {
$e['status'] = $event->getStatusOfUserForEvent(Zend_Auth::getInstance()->getIdentity()->accountId, $e['eventId']);
$e['workshop'] = $thisWorkshop->toArray();
$newEvents[] = $e;
}
}
$this->view->events = $newEvents;
$form = Ot_Form_Template::delete('cancelReservation', 'workshop-signup-cancel:cancel', 'workshop-signup-cancel:keep');
if ($this->_request->isPost() && $form->isValid($_POST)) {
$instructorNames = array();
$instructorEmails = array();
foreach ($instructors as $i) {
$instructorNames[] = $i['firstName'] . ' ' . $i['lastName'];
$instructorEmails[] = $i['emailAddress'];
}
$attendee->cancelReservation(Zend_Auth::getInstance()->getIdentity()->accountId, $thisEvent->eventId);
$startDt = strtotime($thisEvent->date . ' ' . $thisEvent->startTime);
$endDt = strtotime($thisEvent->date . ' ' . $thisEvent->endTime);
$data = array('workshopName' => $thisWorkshop->title, 'workshopDate' => date('m/d/Y', $startDt), 'workshopStartTime' => date('g:i a', $startDt), 'workshopEndTime' => date('g:i a', $endDt), 'workshopMinimumEnrollment' => $thisEvent->minSize, 'locationName' => $thisLocation->name, 'locationAddress' => $thisLocation->address, 'instructorNames' => implode(', ', $instructorNames), 'instructorEmails' => implode(', ', $instructorEmails), 'studentEmail' => Zend_Auth::getInstance()->getIdentity()->emailAddress, 'studentName' => Zend_Auth::getInstance()->getIdentity()->firstName . ' ' . Zend_Auth::getInstance()->getIdentity()->lastName, 'studentUsername' => Zend_Auth::getInstance()->getIdentity()->username);
$this->_helper->flashMessenger->addMessage($this->view->translate('msg-info-canceled', $thisWorkshop->title));
$trigger = new Ot_Trigger();
$trigger->setVariables($data);
$trigger->dispatch('Event_Cancel_Reservation');
$account = new Ot_Account();
if ($status != 'waitlist') {
$waiting = $attendee->getAttendeesForEvent($thisEvent->eventId, 'waitlist');
if (count($waiting) != 0) {
$newAccount = $account->find($waiting[0]['accountId']);
if (!is_null($newAccount)) {
$attendee->makeReservation($newAccount->accountId, $thisEvent->eventId);
$data['studentEmail'] = $newAccount->emailAddress;
$data['studentName'] = $newAccount->firstName . ' ' . $newAccount->lastName;
$data['studentUsername'] = $newAccount->username;
$trigger = new Ot_Trigger();
$trigger->setVariables($data);
$trigger->dispatch('Event_Waitlist_To_Attending');
}
}
}
$this->_redirect('/');
}
$this->view->form = $form;
$this->view->layout()->setLayout('twocolumn');
$this->view->layout()->rightContent = $this->view->render('signup/right.phtml');
}
public function afterSave($created, $options)
{
// Mark the user as absent in all his games
// Get characters, so we can also have the game list
App::uses('Character', 'Model');
$Character = new Character();
$params = array();
$params['recursive'] = -1;
$params['fields'] = array('Character.id', 'Character.game_id', 'Character.level', 'Character.default_role_id');
$params['group'] = 'game_id';
$params['conditions']['user_id'] = $this->data['Availability']['user_id'];
$params['conditions']['main'] = 1;
if ($characters = $Character->find('all', $params)) {
App::uses('Event', 'Model');
$Event = new Event();
$Event->Behaviors->detach('Commentable');
App::uses('EventsCharacter', 'Model');
$EventsCharacter = new EventsCharacter();
foreach ($characters as $character) {
// Get events for this period
$params = array();
$params['recursive'] = -1;
$params['fields'] = array('Event.id');
$params['conditions']['game_id'] = $character['Character']['game_id'];
$params['conditions']['character_level <='] = $character['Character']['level'];
$params['conditions']['time_start >='] = $this->data['Availability']['start'] . ' 00:00:00';
$params['conditions']['time_start <='] = $this->data['Availability']['end'] . ' 23:59:59';
if ($events = $Event->find('all', $params)) {
foreach ($events as $event) {
// If already registered to this event, update it
$paramsEventsCharacter = array();
$paramsEventsCharacter['recursive'] = -1;
$paramsEventsCharacter['fields'] = array('id');
$paramsEventsCharacter['conditions']['event_id'] = $event['Event']['id'];
$paramsEventsCharacter['conditions']['user_id'] = $this->data['Availability']['user_id'];
if ($eventCharacter = $EventsCharacter->find('first', $paramsEventsCharacter)) {
$eventCharacter['EventsCharacter']['status'] = 0;
$EventsCharacter->save($eventCharacter['EventsCharacter']);
} else {
$toSave = array();
$toSave['event_id'] = $event['Event']['id'];
$toSave['user_id'] = $this->data['Availability']['user_id'];
$toSave['character_id'] = $character['Character']['id'];
$toSave['raids_role_id'] = $character['Character']['default_role_id'];
$toSave['comment'] = $this->data['Availability']['comment'];
$toSave['status'] = 0;
$EventsCharacter->__add($toSave);
}
}
}
}
}
return true;
}
echo 'Missing event ID.';
} else {
if (!isUserLoggedIn()) {
http_response_code(403);
echo 'You need to login to edit this event.';
} else {
if (!validateCSRFToken($_POST["csrf_token"])) {
http_response_code(403);
echo 'Invalid CSRF token.';
} else {
$event_id = $_POST["id"];
if (!canSeeEvent(getUserID(), $event_id)) {
http_response_code(403);
echo 'You do not have access to edit this event.';
} else {
$event = Event::find($event_id);
if (isset($_POST['name'])) {
$event->setName($_POST['name']);
}
if (isset($_POST['date'])) {
$event->setDate($_POST['date']);
}
if (isset($_POST['description'])) {
$event->setDescription($_POST['description']);
}
if (isset($_POST['public'])) {
$event->setPublic($_POST['public']);
}
$event->update();
header('Content-Type: application/json');
echo json_encode($event->expose());
<?php
include 'includes/header.php';
$allEvents = Event::find('all');
?>
<div class="col-sm-9 col-md-10">
<?php
if (isset($_SESSION['event'])) {
?>
<?php
$thisEvent = Event::find_by_eventid($_SESSION['event']);
?>
<h2>Now managing: <?php
echo $thisEvent->name;
?>
</h2>
<h2>Change Event:</h2>
<form action="/includes/modules/eventManagement/events.php?selectEvent" class="form-horizontal" method="POST">
<select class="form-control" name="eventID" required>
<option value>Please Select</option>
<?php
foreach ($allEvents as $thisEvent) {
echo '<option value="' . $thisEvent->eventid . '">' . $thisEvent->name . '</option>';
}
?>
</select>
<button type="submit" name="action" class="btn btn-primary">Select</button>
</form>
<?php
} else {
?>
public static function edit($id)
{
self::check_logged_in();
$Event = Event::find($id);
View::make('Event/edit.html', array('attributes' => $Event));
}
private function sendStats()
{
$stats = array();
// Website
$stats['Website']['url'] = Router::url('/', true);
$stats['Website']['version'] = Configure::read('mushraider.version');
$stats['Website']['php'] = phpversion();
$stats['Website']['lang'] = Configure::read('Settings.language');
// Events
App::uses('Event', 'Model');
$EventModel = new Event();
$params = array();
$params['recursive'] = -1;
$params['order'] = array('time_start ASC');
if ($firstEvent = $EventModel->find('first', $params)) {
$stats['Event']['first'] = $firstEvent['Event']['time_start'];
} else {
$stats['Event']['first'] = null;
}
$params['conditions']['time_start <='] = date('Y-m-d');
$params['order'] = array('time_start DESC');
if ($lastEvent = $EventModel->find('first', $params)) {
$stats['Event']['last'] = $lastEvent['Event']['time_start'];
} else {
$stats['Event']['last'] = null;
}
$params = array();
$params['recursive'] = -1;
$params['conditions']['time_start <='] = date('Y-m-d');
$countEvents = $EventModel->find('count', $params);
$stats['Event']['total'] = $countEvents;
// Reports
App::uses('Report', 'Model');
$ReportModel = new Report();
$params = array();
$params['recursive'] = -1;
$countReports = $ReportModel->find('count', $params);
$stats['Report']['total'] = $countReports;
// Users
App::uses('User', 'Model');
$UserModel = new User();
$params = array();
$params['recursive'] = -1;
$countUsers = $UserModel->find('count', $params);
$stats['User']['total'] = $countUsers;
// Characters
App::uses('Character', 'Model');
$CharacterModel = new Character();
$params = array();
$params['recursive'] = -1;
$countCharacters = $CharacterModel->find('count', $params);
$stats['Character']['total'] = $countCharacters;
// Games
App::uses('Game', 'Model');
$GameModel = new Game();
$params = array();
$params['recursive'] = -1;
if ($games = $GameModel->find('all', $params)) {
foreach ($games as $game) {
$stats['Game'][$game['Game']['slug']]['title'] = $game['Game']['title'];
$stats['Game'][$game['Game']['slug']]['imported'] = $game['Game']['import_modified'] > 0 ? 1 : 0;
$params = array();
$params['recursive'] = -1;
$params['conditions']['game_id'] = $game['Game']['id'];
$params['group'] = array('user_id');
$countCharacters = $CharacterModel->find('count', $params);
$stats['Game'][$game['Game']['slug']]['players'] = $countCharacters;
}
}
// Bridge
$bridgeSetting = json_decode($this->SettingModel->getOption('bridge'));
$stats['Bridge']['enabled'] = !empty($bridgeSetting) && $bridgeSetting->enabled ? 1 : 0;
// Widgets
App::uses('Widget', 'Model');
$WidgetModel = new Widget();
$params = array();
$params['recursive'] = -1;
if ($widgets = $WidgetModel->find('all', $params)) {
foreach ($widgets as $widget) {
if (!isset($stats['Widget'][$widget['Widget']['controller']])) {
$stats['Widget'][$widget['Widget']['controller']]['total'] = 1;
} else {
$stats['Widget'][$widget['Widget']['controller']]['total']++;
}
}
}
App::uses('HttpSocket', 'Network/Http');
$this->http = new HttpSocket();
$this->http->post('http://stats.mushraider.com/acquire', $stats);
}
/**
* Displays the results of an evaluation as long as the user requesting the
* page is an instructor of the event.
*
*/
public function evaluationResultsAction()
{
$get = Zend_Registry::get('getFilter');
if (!isset($get->eventId)) {
throw new Ot_Exception_Input('msg-error-eventIdNotSet');
}
$event = new Event();
$thisEvent = $event->find($get->eventId);
if (is_null($thisEvent)) {
throw new Ot_Exception_Data('msg-error-noEvent');
}
$this->view->event = $thisEvent->toArray();
$workshop = new Workshop();
$thisWorkshop = $workshop->find($thisEvent->workshopId);
if (is_null($thisWorkshop)) {
throw new Ot_Exception_Data('msg-error-noWorkshop');
}
$this->view->workshop = $thisWorkshop->toArray();
$location = new Location();
$thisLocation = $location->find($thisEvent->locationId);
if (is_null($thisLocation)) {
throw new Ot_Exception_Data('msg-error-noLocation');
}
$this->view->location = $thisLocation->toArray();
$instructor = new Event_Instructor();
$instructors = $instructor->getInstructorsForEvent($thisEvent->eventId);
$instructorList = array();
foreach ($instructors as $i) {
$instructorList[] = $i['firstName'] . ' ' . $i['lastName'];
}
$this->view->instructors = $instructorList;
$this->_checkValidViewer($instructors);
if ($thisEvent['evaluationType'] == 'custom') {
// get the evaluationId from the eventId
$evaluation = new Evaluation();
$where = $evaluation->getAdapter()->quoteInto('eventId = ?', $thisEvent->eventId);
$evaluations = $evaluation->fetchAll($where);
if ($evaluations->count() == 0) {
$this->view->noEvaluationsYet = true;
}
$this->view->totalEvaluations = $evaluations->count();
$ca = new Ot_Custom();
$questions = $ca->getAttributesForObject('evaluations');
foreach ($questions as &$q) {
$q['options'] = $ca->convertOptionsToArray($q['options']);
$answers = array();
foreach ($evaluations as $e) {
$tmpAnswers = $ca->getData($q['objectId'], $e->evaluationId);
$tmp = array();
foreach ($tmpAnswers as $ta) {
$tmp[$ta['attribute']['attributeId']] = $ta['value'];
}
$answers[] = $tmp;
}
if ($q['type'] == 'ranking' || $q['type'] == 'select' || $q['type'] == 'radio') {
foreach ($q['options'] as $value) {
$answerCount = 0;
foreach ($answers as $a) {
if ($a[$q['attributeId']] == $value) {
$answerCount++;
}
}
$q['results'][] = array('answerLabel' => $value, 'answerCount' => $answerCount);
}
} else {
foreach ($answers as $a) {
$q['results'][] = $a[$q['attributeId']];
}
}
}
$this->view->evaluationResults = $questions;
} elseif ($thisEvent['evaluationType'] == 'google') {
$evaluationKeys = new Evaluation_Key();
$keys = $evaluationKeys->find($get->eventId);
if (is_null($keys)) {
throw new Ot_Exception_Data('msg-error-noFormKey');
}
$this->view->keys = $keys->toArray();
}
$this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/jquery.gchart.min.js');
}
public function cancelReservation($accountId, $eventId)
{
$event = new Event();
$status = $event->getStatusOfUserForEvent($accountId, $eventId);
if ($status == 'restricted') {
throw new Ot_Exception_Data('Reservation not made because class is restricted');
}
if ($status == 'instructor') {
throw new Ot_Exception_Data('Reservation not made because user is an instructor for this class');
}
if ($status == '') {
throw new Ot_Exception_Data('User is not on the role for this class');
}
$thisEvent = $event->find($eventId);
$eventTime = strtotime($thisEvent->date . ' ' . $thisEvent->startTime);
if ($eventTime < time()) {
throw new Ot_Exception_Data('The signup for this class is closed');
}
$dba = $this->getAdapter();
$inTransaction = false;
try {
$dba->beginTransaction();
} catch (Exception $e) {
$inTransaction = true;
}
$data = array('eventId' => $eventId, 'accountId' => $accountId, 'status' => 'canceled');
try {
$this->update($data, null);
} catch (Exception $e) {
if (!$inTransaction) {
$dba->rollBack();
}
throw $e;
}
$data = array('eventId' => $eventId);
if ($status == 'attending') {
$data['roleSize'] = $thisEvent->roleSize - 1;
} else {
$data['waitlistTotal'] = $thisEvent->waitlistTotal - 1;
}
try {
$event->update($data, null);
} catch (Exception $e) {
if (!$inTransaction) {
$dba->rollBack();
}
throw $e;
}
if (!$inTransaction) {
$dba->commit();
}
return $status;
}
public function testGh40RelationshipsWithJoinsAliasesTableNameInConditions()
{
$event = Event::find(1, array('joins' => array('venue')));
$this->assertEquals($event->id, $event->venue->id);
}
public function registerUser($id)
{
$user = Auth::user();
if (!$user->eventsAttending->contains($id)) {
$user->eventsAttending()->attach($id);
$event = Event::find($id);
$notification = new Notification();
$notification->notification_type = 'registered';
$notification->notified_id = $event->user_id;
$notification->notifier_id = Auth::id();
$event->notification()->save($notification);
}
Flash::message('You a now registered for this event');
return Redirect::action('EventsController@show', $id);
}
public function delete($id)
{
$event = Event::find($id);
$event->delete();
}
function read()
{
return $this->render(["event" => Event::find($this->params["id"])]);
}
public function test_save_resets_changed_attributes()
{
$event = Event::find(1);
$event->type = "Groovy Music";
$event->save();
$changed_attributes = $event->changed_attributes();
$this->assert_true(empty($changed_attributes));
}
/**
* Handles the evaluation for an event. Shows the user the evaluation and
* saves the data from the evaluation.
*
*/
public function indexAction()
{
$get = Zend_Registry::get('getFilter');
if (!isset($get->eventId)) {
throw new Ot_Exception_Input('msg-error-eventIdNotSet');
}
$event = new Event();
$eu = new Evaluation_User();
$evaluation = new Evaluation();
$thisEvent = $event->find($get->eventId);
if (is_null($thisEvent)) {
throw new Ot_Exception_Data('msg-error-noEvent');
}
$this->view->event = $thisEvent->toArray();
$thisAccount = Zend_Auth::getInstance()->getIdentity();
$status = $event->getStatusOfUserForEvent($thisAccount->accountId, $thisEvent->eventId);
if ($status == "instructor") {
throw new Ot_Exception_Access('msg-error-cannotEval');
}
if ($status != "attending") {
throw new Ot_Exception_Access('msg-error-notAttended');
}
$config = Zend_Registry::get('config');
$endDt = strtotime($thisEvent->date . " " . $thisEvent->endTime);
if (time() > $endDt + $config->user->numHoursEvaluationAvailability->val * 3600) {
throw new Ot_Exception_Access('msg-error-evalEnded');
}
if ($eu->hasCompleted($thisAccount->accountId, $thisEvent->eventId)) {
throw new Ot_Exception_Access('msg-error-alreadyEval');
}
$workshop = new Workshop();
$thisWorkshop = $workshop->find($thisEvent->workshopId);
if (is_null($thisWorkshop)) {
throw new Ot_Exception_Data('msg-error-noWorkshop');
}
$this->view->workshop = $thisWorkshop->toArray();
$instructor = new Event_Instructor();
$instructors = $instructor->getInstructorsForEvent($thisEvent->eventId);
$inst = array();
foreach ($instructors as $i) {
$inst[] = $i['firstName'] . ' ' . $i['lastName'];
}
$this->view->instructors = $inst;
// lookup the location of the event
$location = new Location();
$thisLocation = $location->find($thisEvent->locationId);
if (is_null($thisLocation)) {
throw new Ot_Exception_Data('msg-error-noLocation');
}
$this->view->location = $thisLocation->toArray();
if ($thisEvent->evaluationType == 'custom') {
$form = $evaluation->form();
$this->view->form = $form;
}
if ($this->_request->isPost()) {
if ($thisEvent->evaluationType == 'custom') {
if ($form->isValid($_POST)) {
$custom = new Ot_Custom();
$attributes = $custom->getAttributesForObject('evaluations');
$data = array();
foreach ($attributes as $a) {
$data[$a['attributeId']] = is_null($form->getValue('custom_' . $a['attributeId'])) ? '' : $form->getValue('custom_' . $a['attributeId']);
}
// custom attributes is the custom array that will be save by the CustomAttributes model
$evaluation->saveEvaluation($thisEvent->eventId, $thisAccount->accountId, $data);
$this->_helper->flashMessenger->addMessage('msg-info-evalThanks');
$this->_redirect('/');
}
} elseif ($thisEvent->evaluationType == 'google' && isset($_POST['googleSubmit'])) {
$eu = new Evaluation_User();
$dba = $eu->getAdapter();
$dba->beginTransaction();
$data = array('eventId' => $get->eventId, 'accountId' => $thisAccount->accountId);
try {
$eu->insert($data);
} catch (Exception $e) {
$dba->rollBack();
throw $e;
}
$dba->commit();
$this->_helper->flashMessenger->addMessage('msg-info-evalThanks');
$this->_redirect('/');
}
}
if ($thisEvent->evaluationType == 'google') {
$evaluationKeys = new Evaluation_Key();
$keys = $evaluationKeys->find($get->eventId);
if (is_null($keys)) {
throw new Ot_Exception_Data('msg-error-noFormKey');
}
$this->view->keys = $keys->toArray();
}
$this->_helper->pageTitle('workshop-evaluate-index:title');
}
public function test_gh_40_relationships_with_joins_aliases_table_name_in_conditions()
{
$event = Event::find(1, array('joins' => array('venue')));
$this->assert_equals($event->id, $event->venue->id);
}
} else {
// Return error message.
ApiUtils::returnError($app, 'UserNotLogged');
}
} catch (Exception $e) {
// An exception ocurred. Return an error message.
ApiUtils::handleException($app, $e);
}
});
// Service for get all persons from a group.
$app->get('/assistanceList/:groupId/:eventId/:date', function ($groupId, $eventId, $date) use($app) {
try {
// Verify that the user is logged.
if (isset($_SESSION['user'])) {
// Get list of persons in the group.
$now = new DateTime();
$rows = ApiUtils::rowsToMaps(Assistance::find_by_sql("select * from get_assistance(" . $_SESSION['user']['id'] . "," . $groupId . "," . $eventId . "," . "'" . ($date !== 'today' ? $date : $now->format('Y-m-d')) . "')"));
// Get name of event and group.
$event = ApiUtils::rowToMap(Event::find($eventId));
$group = ApiUtils::rowToMap(Group::find($groupId));
// Return result.
echo json_encode(array("rows" => $rows, "date" => $date !== 'today' ? $date : $now->format('Y-m-d'), "event" => $event, "group" => $group, "error" => null));
} else {
// Return error message.
ApiUtils::returnError($app, 'UserNotLogged');
}
} catch (Exception $e) {
// An exception ocurred. Return an error message.
ApiUtils::handleException($app, $e);
}
});
