public function workshopListAction()
{
$this->view->acl = array('viewDisabled' => $this->_helper->hasAccess('view-disabled'));
$workshop = new Workshop();
$where = null;
if (!$this->_helper->hasAccess('view-disabled')) {
$where = $workshop->getAdapter()->quoteInto('status = ?', 'enabled');
}
$workshops = $workshop->fetchAll($where, array('status', 'title ASC'))->toArray();
$this->view->workshops = $workshops;
$this->_helper->pageTitle("workshop-index-workshopList:title");
}
/**
* The main scheduler page. This allows a user to view and edit the schedule. Users
* will almost certainly need access to this entire controller to make the
* scheduler work properly and look right.
*
*/
public function indexAction()
{
$this->view->acl = array('addEvent' => $this->_helper->hasAccess('add-event'));
$get = Zend_Registry::get('getFilter');
if (isset($get->workshopId)) {
$workshopId = $get->workshopId;
$this->view->workshopId = $workshopId;
$this->view->startInAddMode = 1;
}
if (isset($get->startYear)) {
$this->view->startYear = $get->startYear;
} else {
$this->view->startYear = date('Y');
}
if (isset($get->startMonth)) {
$this->view->startMonth = $get->startMonth;
} else {
$this->view->startMonth = date('m');
}
$eventId = null;
if (isset($get->eventId)) {
$eventId = $get->eventId;
$this->view->eventId = $eventId;
$this->view->startInEditMode = 1;
$e = new Event();
$thisEvent = $e->find($eventId)->toArray();
$this->view->locationId = $thisEvent['locationId'];
}
$zd = new Zend_Date();
$this->view->workshopLength = mktime(1, 0, 0, 1, 1, 1970);
$this->view->startTime = mktime(0, 0, 0, 1, 1, 1970);
$this->view->endTime = mktime(23, 30, 0, 1, 1, 1970);
$this->view->baseTime = mktime(0, 0, 0, 1, 1, 1970);
$this->view->today = $zd->get(Zend_Date::MONTH) . "/" . $zd->get(Zend_Date::DAY) . "/" . $zd->get(Zend_Date::YEAR);
$this->view->thisYear = $zd->get(Zend_Date::YEAR);
$this->view->thisWeek = $zd->get(Zend_Date::WEEK);
if (!is_null($eventId)) {
$tmpDate = explode('-', $thisEvent['date']);
$zd->setYear($tmpDate[0]);
$zd->setMonth($tmpDate[1]);
$zd->setDay($tmpDate[2]);
}
$this->view->year = $zd->get(Zend_Date::YEAR);
$this->view->week = $zd->get(Zend_Date::WEEK);
$this->_helper->pageTitle('workshop-schedule-index:title');
$workshop = new Workshop();
$where = $workshop->getAdapter()->quoteInto('status = ?', 'enabled');
$workshops = $workshop->fetchAll($where, 'title');
$workshopList = array();
$workshopList[0] = "";
foreach ($workshops as $w) {
$workshopList[$w->workshopId] = $w->title;
}
$this->view->workshops = $workshopList;
$location = new Location();
$where = $location->getAdapter()->quoteInto('status = ?', 'enabled');
$locations = $location->fetchAll($where, 'name');
if (count($locations) == 0) {
$this->_helper->redirector->gotoUrl('/workshop/schedule/noLocationsFound');
}
foreach ($locations as $l) {
$locationList[$l->locationId] = $l->name;
}
$this->view->locationList = $locationList;
//get all the users available for the instructor list
$profile = new Ot_Account();
$profiles = $profile->fetchAll(null, array('lastName', 'firstName'))->toArray();
$instructors = array();
foreach ($profiles as $p) {
$instructors[$p['username']] = $p['lastName'] . ", " . $p['firstName'];
}
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->view->instructors = $instructors;
$this->view->headScript()->appendFile($this->view->baseUrl() . '/public/scripts/jMonthCalendar-1.1.0.js');
//$this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/jMonthCalendar-1.2.2.js');
$this->view->headScript()->appendFile($this->view->baseUrl() . '/public/scripts/jquery.bt.min.js');
}
public function deleterecursiveAction()
{
//delete workshop files
//delete workshop -> triggers delete ce
//delete ws info -> DB on delete cascade
//delete ce
//delete imageset attributes -> DB on delete cascade
//delete ce has image -> DB on delete cascade
//delete ce has attribute desc. -> DB on delete cascade
//delete participants -> DB on delete cascade
//delete annotations -> DB on delete cascade
//delete dots -> DB on delete cascade
$request = $this->getRequest();
$workId = intval($this->getRequest()->getParam(Workshop::COL_ID));
if (AuthQuery::getUserRole() == 'admin') {
$request = $this->getRequest();
$workId = intval($this->getRequest()->getParam(Workshop::COL_ID));
$workshop = new Workshop();
$rowset = $workshop->find($workId);
if (count($rowset) == 1) {
$table = new WorkshopInfo();
//$tableAdapter = $table->getAdapter();
$select = $table->select();
//$select->from(WorkshopInfo::TABLE_NAME);
$select->where(WorkshopInfo::COL_WORKSHOP_ID . ' = ?', $workId, 'int');
echo $select;
$rowset = $table->fetchAll($select);
if (count($rowset) >= 1) {
$rowsetArray = $rowset->toArray();
$RELATIVE_WORKSHOP_FILES_PATH = 'infoFiles';
//without pre- and post-slash!
foreach ($rowsetArray as $row) {
try {
$filename = $row[WorkshopInfo::COL_FILE];
if ($filename != NULL) {
$myFile = $RELATIVE_WORKSHOP_FILES_PATH . '/' . $filename;
$fh = fopen($myFile, 'w');
fclose($fh);
unlink($myFile);
}
} catch (Exception $e) {
throw new Zend_Exception('Error: can not open file');
}
}
}
//note: delete of workshop_info is executed from db
$workshop->delete($workshop->getAdapter()->quoteInto(Workshop::COL_ID . ' = ?', $workId));
}
}
$redirect = new Zend_Controller_Action_Helper_Redirector();
$redirect->setGoto('myws', 'search', 'workshop');
}
public function form($values = array())
{
$config = Zend_Registry::get('config');
$form = new Zend_Form();
$form->setAttrib('id', 'eventForm')->setDecorators(array('FormElements', array('HtmlTag', array('tag' => 'div', 'class' => 'zend_form')), 'Form'));
$workshop = new Workshop();
$where = $workshop->getAdapter()->quoteInto('status = ?', 'enabled');
$workshops = $workshop->fetchAll($where, 'title');
$workshopList = array();
foreach ($workshops as $w) {
$workshopList[$w->workshopId] = $w->title;
}
$workshopElement = $form->createElement('select', 'workshop', array('label' => 'Workshop:'));
$workshopElement->setMultiOptions($workshopList)->setValue(isset($values['workshopId']) ? $values['workshopId'] : '');
$location = new Location();
$where = $location->getAdapter()->quoteInto('status = ?', 'enabled');
$locations = $location->fetchAll($where, 'name');
$locationList = array();
$locationCapacity = array();
foreach ($locations as $l) {
$locationList[$l->locationId] = $l->name;
$locationCapacity['loc_' . $l->locationId] = $l->capacity;
}
$locationIds = array_keys($locationList);
// add the location capacities to the page in js so we can process it as a json object for the "live" max size changing with location selection
Zend_Layout::getMvcInstance()->getView()->headScript()->appendScript('var locationCapacitiesString = ' . Zend_Json::encode($locationCapacity) . ';');
$locationElement = $form->createElement('select', 'location', array('label' => 'Location:'));
$locationElement->setMultiOptions($locationList)->setValue(isset($values['locationId']) ? $values['locationId'] : $locationCapacity['loc_' . $locationIds[0]]);
$date = $form->createElement('text', 'date', array('label' => 'Date:'));
$date->setRequired(true)->addFilter('StringTrim')->addFilter('StripTags')->setAttrib('maxlength', '128')->setAttrib('style', 'width: 200px')->setValue(isset($values['date']) ? strftime('%A, %B %e, %Y', strtotime($values['date'])) : '');
$password = $form->createElement('text', 'password', array('label' => 'Event Password:'******'StringTrim')->addFilter('StripTags')->setAttrib('maxlength', '100')->setValue(isset($values['password']) ? $values['password'] : '');
// add the start time selector
$startTimeSub = new Zend_Form_SubForm();
$startTimeSub->setDecorators(array('FormElements', array('HtmlTag', array('tag' => 'div', 'class' => 'zend_form'))));
$startTimeSub->setAttrib('class', 'sub');
$startTimeHour = $startTimeSub->createElement('select', 'hour', array('label' => 'Start Time:'));
for ($i = 1; $i <= 12; $i++) {
$startTimeHour->addMultiOption($i, $i);
}
$startTimeHour->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect')), array('Label')));
$startTimeHour->setValue(isset($values['startTime']) ? date('g', strtotime($values['startTime'])) : date('g'));
$startTimeMinute = $startTimeSub->createElement('select', 'minute');
for ($i = 0; $i < 60; $i += 5) {
$startTimeMinute->addMultiOption(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
}
$startTimeMinute->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect'))));
$startTimeMinute->setValue(isset($values['startTime']) ? date('i', strtotime($values['startTime'])) : date('i'));
$startTimeMeridian = $startTimeSub->createElement('select', 'meridian');
$startTimeMeridian->addMultiOption('am', 'AM')->addMultiOption('pm', 'PM')->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect'))));
$startTimeMeridian->setValue(isset($values['startTime']) ? date('a', strtotime($values['startTime'])) : date('a'));
$startTimeSub->addElements(array($startTimeHour, $startTimeMinute, $startTimeMeridian));
// add the end time selector
$endTimeSub = new Zend_Form_SubForm();
$endTimeSub->setDecorators(array('FormElements', array('HtmlTag', array('tag' => 'div', 'class' => 'zend_form'))));
$endTimeSub->setAttrib('class', 'sub');
$endTimeHour = $endTimeSub->createElement('select', 'hour', array('label' => 'End Time:'));
for ($i = 1; $i <= 12; $i++) {
$endTimeHour->addMultiOption($i, $i);
}
$endTimeHour->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect')), array('Label')));
$endTimeHour->setValue(isset($values['endTime']) ? date('g', strtotime($values['endTime'])) : date('g'));
$endTimeMinute = $endTimeSub->createElement('select', 'minute');
for ($i = 0; $i < 60; $i += 5) {
$endTimeMinute->addMultiOption(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT));
}
$endTimeMinute->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect'))));
$endTimeMinute->setValue(isset($values['endTime']) ? date('i', strtotime($values['endTime'])) : date('i'));
$endTimeMeridian = $endTimeSub->createElement('select', 'meridian');
$endTimeMeridian->addMultiOption('am', 'AM')->addMultiOption('pm', 'PM')->setDecorators(array(array('ViewHelper', array('helper' => 'formSelect'))));
$endTimeMeridian->setValue(isset($values['endTime']) ? date('a', strtotime($values['endTime'])) : date('a'));
$endTimeSub->addElements(array($endTimeHour, $endTimeMinute, $endTimeMeridian));
// get all the users available for the instructor list
$otAccount = new Ot_Account();
$accounts = $otAccount->fetchAll(null, array('lastName', 'firstName'))->toArray();
$instructorList = array();
foreach ($accounts as $a) {
$instructorList[$a['accountId']] = $a['lastName'] . ", " . $a['firstName'];
}
$instructorElement = $form->createElement('multiselect', 'instructors', array('label' => 'Instructor(s):'));
$instructorElement->setMultiOptions($instructorList)->setAttrib('size', 10)->setValue(isset($values['instructorIds']) ? $values['instructorIds'] : '');
$minSize = $form->createElement('text', 'minSize', array('label' => 'Min Size:'));
$minSize->setRequired(true)->addFilter('StringTrim')->addFilter('StripTags')->setAttrib('maxlength', '64')->setAttrib('style', 'width: 50px;')->setValue(isset($values['minSize']) ? $values['minSize'] : $config->user->defaultMinWorkshopSize->val);
$maxSize = $form->createElement('text', 'maxSize', array('label' => 'Max Size:'));
$maxSize->setRequired(true)->addFilter('StringTrim')->addFilter('StripTags')->setAttrib('maxlength', '64')->setAttrib('style', 'width: 50px;')->setValue(isset($values['maxSize']) ? $values['maxSize'] : $locationElement->getValue());
$waitlistSize = $form->createElement('text', 'waitlistSize', array('label' => 'Waitlist Size:'));
$waitlistSize->setRequired(true)->addFilter('StringTrim')->addFilter('StripTags')->setAttrib('maxlength', '64')->setAttrib('style', 'width: 50px;')->setValue(isset($values['waitlistSize']) ? $values['waitlistSize'] : $config->user->defaultWorkshopWaitlistSize->val);
$evaluationType = $form->createElement('select', 'evaluationType', array('label' => 'Evaluation Type:'));
$evaluationType->setMultiOptions(array('default' => 'Default', 'google' => 'Google Form'))->setRequired(true)->setValue(isset($values['evaluationType']) ? $values['evaluationType'] : 'default');
$formKey = $form->createElement('textarea', 'formKey', array('label' => 'Google Form Question Key:'));
$formKey->setAttribs(array('cols' => '10', 'rows' => '5', 'style' => 'width : 250px;'))->addDecorators(array('ViewHelper', 'Errors', 'HtmlTag', array('Label', array('tag' => 'span')), array(array('elementDiv' => 'HtmlTag'), array('tag' => 'div', 'id' => 'formKey', 'class' => 'elm'))))->setValue(isset($values['formKey']) ? $values['formKey'] : '');
$answerKey = $form->createElement('textarea', 'answerKey', array('label' => 'Google Form Answer Key:'));
$answerKey->addFilter('StringTrim')->addFilter('StripTags')->setAttribs(array('cols' => '10', 'rows' => '3', 'style' => 'width : 250px;'))->addDecorators(array('ViewHelper', 'Errors', 'HtmlTag', array('Label', array('tag' => 'span')), array(array('elementDiv' => 'HtmlTag'), array('tag' => 'div', 'id' => 'answerKey', 'class' => 'elm'))))->setValue(isset($values['answerKey']) ? $values['answerKey'] : '');
$submit = $form->createElement('submit', 'submitButton', array('label' => 'Submit'));
$submit->setDecorators(array(array('ViewHelper', array('helper' => 'formSubmit'))));
$cancel = $form->createElement('button', 'cancel', array('label' => 'Cancel'));
$cancel->setAttrib('id', 'cancel');
$cancel->setDecorators(array(array('ViewHelper', array('helper' => 'formButton'))));
$form->addElements(array($workshopElement, $locationElement, $password, $date, $evaluationType))->addSubForms(array('startTime' => $startTimeSub, 'endTime' => $endTimeSub))->addElements(array($minSize, $maxSize, $waitlistSize, $instructorElement));
$form->addDisplayGroup(array('instructors'), 'instructors-group', array('legend' => 'Instructors'));
$form->addDisplayGroup(array('workshop', 'password', 'location', 'minSize', 'maxSize', 'waitlistSize'), 'generalInformation', array('legend' => 'General Information'));
$form->setElementDecorators(array('ViewHelper', 'Errors', array('HtmlTag', array('tag' => 'div', 'class' => 'elm')), array('Label', array('tag' => 'span'))))->addElements(array($submit, $cancel));
$form->addElements(array($evaluationType, $formKey, $answerKey));
$form->addDisplayGroup(array('evaluationType', 'formKey', 'answerKey'), 'evaluationTypes', array('legend' => 'Evaluations'));
$form->addDisplayGroup(array('submitButton', 'cancel'), 'buttons');
$form->setDisplayGroupDecorators(array('FormElements', array('HtmlTag', array('tag' => 'div', 'class' => 'widget-content')), array(array('elementDiv' => 'HtmlTag'), array('tag' => 'div', 'class' => array('widget-footer', 'ui-corner-bottom'), 'placement' => Zend_Form_Decorator_Abstract::APPEND)), array('FieldSet', array('class' => 'formField'))));
$buttons = $form->getDisplayGroup('buttons');
$buttons->setDecorators(array('FormElements', array('HtmlTag', array('tag' => 'div', 'style' => 'clear : both;'))));
if (isset($values['eventId'])) {
$eventId = $form->createElement('hidden', 'eventId');
$eventId->setValue($values['eventId']);
$eventId->setDecorators(array(array('ViewHelper', array('helper' => 'formHidden'))));
$form->addElement($eventId);
}
return $form;
}