function newEvent()
{
if (isset($_POST['saveChanges'])) {
$event = new Event();
$event->storeFormValues($_POST);
$event->insert();
header("Location: index.php?action=listEvent&success=eventCreated");
}
}
if ($_POST['eventallowlatesignups'] != "") {
$event->setField('AllowLateSignups', 1);
} else {
$event->setField('AllowLateSignups', 0);
}
/* Event Description */
$event->setField('Description', $_POST['eventdescription']);
/* Event Rules */
$event->setField('Rules', $_POST['eventrules']);
if ($event_id) {
// Need to update the event in database
$event->updateDB();
} else {
// Need to create an event.
$event->setField('Owner', USERID);
$event_id = $event->insert();
// TODO: only for ladders?
$event->initStats();
}
//echo "-- eventsettingssave --<br />";
header("Location: eventmanage.php?eventid={$event_id}");
exit;
}
if (isset($_POST['eventdeletemap'])) {
$eventmap = $_POST['eventdeletemap'];
$mapPool = explode(",", $event->getField('MapPool'));
unset($mapPool[$eventmap]);
$event->updateMapPool($mapPool);
$event->updateFieldDB('MapPool');
//echo "-- eventdeletemap --<br />";
header("Location: eventmanage.php?eventid={$event_id}");
// $GeneralObj->checkDuplicate('iUserId', 'User', Array('vUsername'),$redirect_file, "Username is Already Exists ", $vUsername);
//January 01, 1970 01:00 AM
// $userObj->setdCreated($dCreated);
/* if($dEventDateTime=='1970-01-01 01:00:00') {
$dEventDateTime='0000-00-00 00:00:00';
} */
if (strtotime($dEventDateTime) >= 0 && strtotime($dEventDateTime) != "") {
$dEventDateTime = $dEventDateTime;
} else {
$dEventDateTime = "0000-00-00";
}
$eventObj->setdEventDateTime($dEventDateTime);
$eventObj->setiSGroupId($iSGroupId);
// $redirect_file="index.php?file=m-directoryadd".$qs;
//$GeneralObj->checkDuplicate('iDirectoryId', 'Directory', Array('iSGroupId','vEmpId'),$redirect_file, "iSGroupId/vEmpId is Already Exists ", $vDirectoryId," AND");
$id1 = $eventObj->insert();
if ($eStatus == 'Active') {
// for Notification of users
$user_emails = $userObj->getNotificationUsers($iSGroupId);
if (is_Array($user_emails) && count($user_emails) > 0) {
for ($i = 0; $i < count($user_emails); $i++) {
// $emailObj->send_add_eventmail($user_emails[$i]['vUsername'],$vEventTitle,$user_emails['admin_email'],$user_emails[$i]['vEmail']);
$sql_insert = "INSERT INTO `cron_email` (`vEmail` ,`vUsername` ,`vName` ,`vAdmin_email` ,`vCategoryName` ,`eType` ,`iID`)\n\t\t\t\t\t\tVALUES ('" . $user_emails[$i]['vEmail'] . "', '" . $user_emails[$i]['vUsername'] . "', '" . $vEventTitle . "', '" . $user_emails['admin_email'] . "', '" . $catagery_Array[0]['vCategoryName'] . "', 'Event', '" . $id1 . "')";
//echo $sql_insert;exit;
$id = $obj->insert($sql_insert);
/*
$to = ''.$user_emails[$i]['vEmail'].'';
$subject = 'New Event added - Check it out';
$message="<html>
<head><title></title></head>
<body>
/**
* Allows a user to create an event.
*
*/
public function addEventAction()
{
$messages = array();
$get = Zend_Registry::get('getFilter');
$event = new Event();
$values = array();
if (isset($get->date)) {
$values['date'] = $get->date;
}
$form = $event->form($values);
if ($this->_request->isPost()) {
if ($form->isValid($_POST)) {
$workshopId = $form->getValue('workshop');
$locationId = $form->getValue('location');
$startTime = $form->getValue('startTime');
$endTime = $form->getValue('endTime');
$date = $form->getValue('date');
$minSize = $form->getValue('minSize');
$maxSize = $form->getValue('maxSize');
$waitlistSize = $form->getValue('waitlistSize');
$instructors = $form->getValue('instructors');
$password = $form->getValue('password');
$evaluationType = $form->getValue('evaluationType');
$formKey = $form->getValue('formKey');
$answerKey = $form->getValue('answerKey');
if (isset($formKey) && $formKey != '') {
$regex = '(?<=key\\=)\\w*';
$matches = array();
preg_match_all("/" . $regex . "/is", $form->getValue('formKey'), $matches);
$formKey = $matches[0][0];
}
if (isset($answerKey) && $answerKey != '') {
$regex = '(?<=key\\=)\\w*';
$matches = array();
preg_match_all("/" . $regex . "/is", $form->getValue('answerKey'), $matches);
$answerKey = $matches[0][0];
}
$date = strtotime($date);
$date = strftime('%Y', $date) . "-" . strftime('%m', $date) . "-" . strftime('%d', $date);
if (strtolower($startTime['meridian']) == "pm" && $startTime['hour'] < 12) {
$startTime['hour'] += 12;
}
if (strtolower($startTime['meridian']) == "am" && $startTime['hour'] == 12) {
$startTime['hour'] = 0;
}
if (strtolower($endTime['meridian']) == "pm" && $endTime['hour'] < 12) {
$endTime['hour'] += 12;
}
if (strtolower($endTime['meridian']) == "am" && $endTime['hour'] == 12) {
$endTime['hour'] = 0;
}
$timesOk = true;
$st = new Zend_Date($date);
$st->setHour($startTime['hour'])->setMinute($startTime['minute']);
$et = new Zend_Date($date);
$et->setHour($endTime['hour'])->setMinute($endTime['minute']);
if ($st->isLater($et)) {
$timesOk = false;
$messages[] = "msg-error-eventStartsAfter";
} else {
if ($st->equals($et)) {
$timesOk = false;
$messages[] = "msg-error-eventTimesEqual";
}
}
$startTime = $startTime['hour'] . ":" . $startTime['minute'] . ":00";
$endTime = $endTime['hour'] . ":" . $endTime['minute'] . ":00";
$where = $event->getAdapter()->quoteInto('date = ?', $date) . " AND " . $event->getAdapter()->quoteInto('locationId = ?', $locationId) . " AND " . $event->getAdapter()->quoteInto('status = ?', 'open');
$possibleConflicts = $event->fetchAll($where);
$conflictFound = false;
if ($possibleConflicts->count() > 0) {
$startTs = strtotime($startTime);
$endTs = strtoTime($endTime);
foreach ($possibleConflicts as $pc) {
$pcStart = strtotime($pc->startTime);
$pcEnd = strtotime($pc->endTime);
if ($startTs == $pcStart) {
$conflictFound = true;
} else {
if ($startTs < $pcStart && $endTs > $pcStart) {
$conflictFound = true;
} else {
if ($startTs >= $pcStart && $endTs <= $pcEnd) {
$conflictFound = true;
} else {
if ($startTs < $pcEnd && $endTs >= $pcEnd) {
$conflictFound = true;
} else {
if ($startTs < $pcStart && $endTime > $pcEnd) {
$conflictFound = true;
}
}
}
}
}
if ($conflictFound) {
$messages[] = "msg-error-eventAlreadyScheduled";
break;
}
}
}
$evaluationCheck = true;
if ($evaluationType == 'google') {
$evaluationCheck = isset($formKey) && isset($answerKey);
} else {
$evaluationCheck = $evaluationType == 'default';
}
if (!$evaluationCheck) {
$messages[] = 'msg-error-eventFormKeyMissing';
}
if (!$conflictFound && $timesOk && $evaluationCheck) {
$data = array('locationId' => $locationId, 'workshopId' => $workshopId, 'startTime' => $startTime, 'endTime' => $endTime, 'date' => $date, 'minSize' => $minSize, 'maxSize' => $maxSize, 'waitlistSize' => $waitlistSize, 'password' => $password, 'evaluationType' => $evaluationType, 'formKey' => $formKey, 'answerKey' => $answerKey);
$eventId = $event->insert($data);
$instructor = new Event_Instructor();
foreach ($instructors as $i) {
$instructor->insert(array('accountId' => $i, 'eventId' => $eventId));
}
$this->_helper->flashMessenger->addMessage('msg-info-eventAdded');
$date = explode('-', $date);
$this->_helper->redirector->gotoUrl('/workshop/schedule?startYear=' . $date[0] . '&startMonth=' . (int) $date[1]);
}
} else {
$messages[] = "msg-error-formSubmitProblem";
}
}
$this->view->messages = $messages;
$this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/jquery.autocomplete.js');
$this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/workshop/schedule/help.js');
$this->view->headLink()->appendStylesheet($this->view->baseUrl() . '/css/jquery.autocomplete.css');
$this->view->headLink()->appendStylesheet($this->view->baseUrl() . '/css/workshop/schedule/help.css');
$this->view->form = $form;
$this->_helper->pageTitle('workshop-schedule-addEvent:title');
}
$page = "proofreader.php";
} else {
$page = "regular.php";
}
if (User::insert($db, $uname, $pass, $type, 0, $roll, $page, $mac, $date, $date)) {
$msg = "Signed Up Successfully.";
}
} else {
if ($_POST["type"] == "mn") {
$ecode = $_POST['ecode'];
$ename = $_POST['ename'];
//$ename = str_replace("'", "'", $ename);
$category = $_POST['category'];
$db->autocommit(FALSE);
if (User::insert($db, $uname, $pass, $ecode, 0, $roll, 'manager.php', $mac, $date, $date)) {
if (Event::insert($db, $ecode, $ename, $category, "", "", "", "", "", "", "", 0, "")) {
$db->commit();
$msg = "Signed Up Successfully.";
} else {
$db->rollback();
$msg = "Event code alreadt exist.";
}
} else {
$db->rollback();
$msg = "Unknown error occured.";
}
$db->autocommit(TRUE);
}
}
} else {
$msg = "Username already exist.";