public function saveAction() { $form = new Calendar_Form_Form(); $table = new Tri_Db_Table('calendar'); $data = $this->_getAllParams(); if ($form->isValid($data)) { $data = $form->getValues(); $data['user_id'] = Zend_Auth::getInstance()->getIdentity()->id; if (!$data['classroom_id']) { unset($data['classroom_id']); } if (isset($data['id']) && $data['id']) { $row = $table->find($data['id'])->current(); $row->setFromArray($data); } else { unset($data['id']); $row = $table->createRow($data); } $id = $row->save(); $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('calendar/index/form/id/' . $id); } $this->_helper->_flashMessenger->addMessage('Error'); $this->view->form = $form; $this->render('form'); }
/** * (non-PHPdoc) * @see Zend_Controller_Action#init() */ public function init() { if (!Zend_Auth::getInstance()->getIdentity()) { $page = new Tri_Db_Table('page'); $this->view->pages = $page->fetchAll("status = 'active'", 'position'); } }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('activity'); $validators = $table->getValidators(); $filters = $table->getFilters(); $statusOptions = $table->fetchPairs('status', 'status'); $this->setAction('activity/index/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['title'][] = 'StripTags'; $title = new Zend_Form_Element_Text('title'); $title->setLabel('Title')->addValidators($validators['title'])->addFilters($filters['title']); $filters['description'][] = 'StripTags'; $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 10)->setAllowEmpty(false); if (!$statusOptions || isset($statusOptions[''])) { $status = new Zend_Form_Element_Text('status'); } else { $statusOptions = array_unique($statusOptions); $status = new Zend_Form_Element_Select('status'); $status->addMultiOptions(array('' => '[select]') + $statusOptions)->setRegisterInArrayValidator(false); } $begin = new Zend_Form_Element_Text('begin'); $begin->setLabel('Begin')->setAttrib('class', 'date')->addFilters($filters['begin'])->addValidators($validators['begin'])->setAllowEmpty(false)->getPluginLoader('filter')->addPrefixPath('Tri_Filter', 'Tri/Filter'); $end = new Zend_Form_Element_Text('end'); $end->setLabel('End')->setAttrib('class', 'date')->addFilters($filters['end'])->getPluginLoader('filter')->addPrefixPath('Tri_Filter', 'Tri/Filter'); $status->setLabel('Status')->addValidators($validators['status'])->addFilters($filters['status']); $this->addElement($id)->addElement($title)->addElement($description)->addElement($begin)->addElement($end)->addElement($status)->addElement('submit', 'Save'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $this->addElementPrefixPath('Tri_Filter', 'Tri/Filter', 'FILTER'); $table = new Tri_Db_Table('classroom'); $course = new Tri_Db_Table('course'); $user = new Tri_Db_Table('user'); $validators = $table->getValidators(); $filters = $table->getFilters(); $where = array("role = 'institution' OR role = 'Teacher' OR role = 'Creator'"); $users = $user->fetchPairs('id', 'name', $where, 'name'); $statusOptions = array('active' => 'active', 'inactive' => 'inactive', 'open' => 'open'); $courses = $course->fetchPairs('id', 'name', "status = 'active'"); $this->setAction('admin/classroom/save')->setMethod('post')->setAttrib('enctype', 'multipart/form-data'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $courseId = new Zend_Form_Element_Select('course_id'); $courseId->setLabel('Course')->addValidators($validators['course_id'])->addFilters($filters['course_id'])->addMultiOptions(array('' => '[select]') + $courses); $filters['name'][] = 'StripTags'; $name = new Zend_Form_Element_Text('name'); $name->setLabel('Name')->addValidators($validators['name'])->addFilters($filters['name']); $responsible = new Zend_Form_Element_Select('responsible'); $responsible->setLabel('Responsible')->addValidators($validators['responsible'])->addFilters($filters['responsible'])->addMultiOptions(array('' => '[select]') + $users); $begin = new Zend_Form_Element_Text('begin'); $begin->setLabel('Begin')->setAttrib('class', 'date')->addFilters($filters['begin'])->addValidators($validators['begin'])->setAllowEmpty(false); $end = new Zend_Form_Element_Text('end'); $end->setLabel('End')->setAttrib('class', 'date')->addFilters($filters['end']); $max = new Zend_Form_Element_Text('max_student'); $max->setLabel('Max student')->addValidators($validators['max_student'])->addFilters($filters['max_student']); $amount = new Zend_Form_Element_Text('amount'); $amount->setLabel('Amount')->addValidators($validators['amount'])->addFilters($filters['amount']); $status = new Zend_Form_Element_Select('status'); $status->addMultiOptions($statusOptions)->setRegisterInArrayValidator(false)->setLabel('Status')->addValidators($validators['status'])->addFilters($filters['status']); $this->addElement($id)->addElement($courseId)->addElement($name)->addElement($responsible)->addElement($begin)->addElement($end)->addElement($max)->addElement($amount)->addElement($status)->addElement('submit', 'Save'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('activity_text'); $validators = $table->getValidators(); $filters = $table->getFilters(); $translate = Zend_Registry::get('Zend_Translate'); $this->setAction('activity/text/save')->setMethod('post'); $activityId = new Zend_Form_Element_Hidden('activity_id'); $activityId->addValidators($validators['activity_id'])->addFilters($filters['activity_id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $userId = new Zend_Form_Element_Hidden('user_id'); $userId->addValidators($validators['user_id'])->addFilters($filters['user_id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 20)->setAttrib('cols', '70%')->setAttrib('id', 'text-description-text')->setAllowEmpty(false); $status = new Zend_Form_Element_Hidden('status'); $status->removeDecorator('Label')->removeDecorator('HtmlTag'); $this->addElement($userId)->addElement($activityId)->addElement($status)->addElement($description); if (Zend_Auth::getInstance()->getIdentity()->role == 'student') { $saveDraft = new Zend_Form_Element_Submit('saveDraft'); $sendCorrection = new Zend_Form_Element_Submit('sendCorrection'); $saveDraft->removeDecorator('Label')->removeDecorator('DtDdWrapper'); $sendCorrection->removeDecorator('Label')->removeDecorator('DtDdWrapper'); $this->addElement($saveDraft)->addElement($sendCorrection); } else { $openButton = new Zend_Form_Element_Submit('openButton'); $finalize = new Zend_Form_Element_Submit('finalize'); $openButton->removeDecorator('Label')->removeDecorator('DtDdWrapper'); $finalize->removeDecorator('Label')->removeDecorator('DtDdWrapper'); $note = new Zend_Form_Element_Text('note'); $note->setLabel('Note')->addValidator('Int')->addFilter('Digits'); $this->addElement($note)->addElement($openButton)->addElement($finalize); } }
public function viewAction() { $identity = Zend_Auth::getInstance()->getIdentity(); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $exerciseId = Zend_Filter::filterStatic($this->_getParam('exerciseId'), 'int'); $userId = Zend_Filter::filterStatic($this->_getParam('userId', $identity->id), 'int'); $exercise = new Tri_Db_Table('exercise'); $exerciseQuestion = new Tri_Db_Table('exercise_question'); $exerciseNote = new Tri_Db_Table('exercise_note'); $exerciseAnswer = new Tri_Db_Table('exercise_answer'); if ($id) { $note = $exerciseNote->fetchRow(array('id = ?' => $id)); } elseif ($exerciseId) { $note = $exerciseNote->fetchRow(array('exercise_id = ?' => $exerciseId, 'user_id = ?' => $userId), 'id DESC'); } if ($note) { $row = $exercise->fetchRow(array('id = ?' => $note->exercise_id)); if ($row) { $where = array('exercise_id = ?' => $row->id, 'status = ?' => 'active'); $this->view->questions = $exerciseQuestion->fetchAll($where); $this->view->exercise = $row; $this->view->answers = $exerciseAnswer->fetchAll(array('exercise_note_id = ?' => $note->id)); $this->view->note = $note; $whereNote = array('exercise_id = ?' => $note->exercise_id, 'id <> ?' => $note->id, 'user_id = ?' => $userId); $this->view->notes = $exerciseNote->fetchAll($whereNote, 'id DESC'); $this->view->userId = $userId; } else { $this->view->message = 'there are no records'; } } else { $this->view->message = 'there are no records'; } }
public function saveAction() { $form = new Forum_Form_Forum(); $table = new Tri_Db_Table('forum'); $session = new Zend_Session_Namespace('data'); $data = $this->_getAllParams(); if ($form->isValid($data)) { $data = $form->getValues(); $data['user_id'] = Zend_Auth::getInstance()->getIdentity()->id; $data['classroom_id'] = $session->classroom_id; if (!$data['end']) { unset($data['end']); } if (isset($data['id']) && $data['id']) { $row = $table->find($data['id'])->current(); $row->setFromArray($data); $id = $row->save(); } else { unset($data['id']); $row = $table->createRow($data); $id = $row->save(); Application_Model_Timeline::save('created a new forum', $data['title']); } $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('forum/index/form/id/' . $id); } $this->_helper->_flashMessenger->addMessage('Error'); $this->view->form = $form; $this->render('form'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $this->addElementPrefixPath('Tri_Filter', 'Tri/Filter', 'FILTER'); $table = new Tri_Db_Table('chat_room'); $validators = $table->getValidators(); $filters = $table->getFilters(); $statusOptions = array('open' => 'open', 'close' => 'close'); $this->setAction('chat/room/save')->setMethod('post')->setAttrib('enctype', 'multipart/form-data'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['name'][] = 'StripTags'; $title = new Zend_Form_Element_Text('title'); $title->setLabel('Title')->addValidators($validators['title'])->addFilters($filters['title']); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 10); $max = new Zend_Form_Element_Text('max_student'); $max->setLabel('Max student')->addValidators($validators['max_student'])->addFilters($filters['max_student']); if (!$statusOptions || isset($statusOptions[''])) { $status = new Zend_Form_Element_Text('status'); } else { $statusOptions = array_unique($statusOptions); $status = new Zend_Form_Element_Select('status'); $status->addMultiOptions(array('' => '[select]') + $statusOptions)->setRegisterInArrayValidator(false); } $status->setLabel('Status')->addValidators($validators['status'])->addFilters($filters['status']); $this->addElement($id)->addElement($title)->addElement($description)->addElement($status)->addElement('submit', 'Save'); }
private function _verifyTime($in) { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('restriction_time'); $select = $table->select()->where('classroom_id = ?', $session->classroom_id)->where('content_id IN(?)', $in); $result = $table->fetchAll($select); if (count($result)) { foreach ($result as $rs) { $started = (double) preg_replace('/[^0-9]/', '', $rs->begin); $finished = (double) preg_replace('/[^0-9]/', '', $rs->end); $today = (double) date('Ymd'); if ($started > $today) { self::$restriction['has'] = true; self::$restriction['content'] = "restricted content, access after"; self::$restriction['value'] = $rs->begin; return false; } if ($finished < $today) { self::$restriction['has'] = true; self::$restriction['content'] = "content expired since the"; self::$restriction['value'] = $rs->end; return false; } } } }
public function init() { $session = new Zend_Session_Namespace('data'); $calendar = new Tri_Db_Table('calendar'); $classroom = new Tri_Db_Table('classroom'); $validators = $calendar->getValidators(); $filters = $calendar->getFilters(); $options = $classroom->fetchPairs('id', 'name', array('id IN(?)' => $session->classrooms)); $this->setAction('calendar/index/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $classroom_id = new Zend_Form_Element_Select('classroom_id'); $classroom_id->setLabel('Classroom')->addValidators($validators['classroom_id'])->addFilters($filters['classroom_id'])->addMultiOptions(array('' => '[select]') + $options); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAllowEmpty(false)->setAttrib('rows', 7); $begin = new Zend_Form_Element_Text('begin'); $begin->setLabel('Begin')->setAttrib('class', 'date')->addFilters($filters['begin'])->addValidators($validators['begin'])->setAllowEmpty(false)->getPluginLoader('filter')->addPrefixPath('Tri_Filter', 'Tri/Filter'); $end = new Zend_Form_Element_Text('end'); $end->setLabel('End')->setAttrib('class', 'date')->addFilters($filters['end'])->getPluginLoader('filter')->addPrefixPath('Tri_Filter', 'Tri/Filter'); $this->addElement($id); $this->addElement($classroom_id); $this->addElement($description); $this->addElement($begin); $this->addElement($end); $this->addElement('submit', 'Save'); }
public function saveAction() { $form = new Activity_Form_Text(); $table = new Tri_Db_Table('activity_text'); $session = new Zend_Session_Namespace('data'); $data = $this->_getAllParams(); $statusList = array('openButton' => 'open', 'finalize' => 'final'); if (Zend_Auth::getInstance()->getIdentity()->role == 'student') { $statusList['sendCorrection'] = 'close'; $statusList['saveDraft'] = 'open'; } if ($form->isValid($data)) { $data = $form->getValues(); $data['sender'] = Zend_Auth::getInstance()->getIdentity()->id; $data['status'] = $statusList[$data['status']]; $row = $table->createRow($data); $id = $row->save(); if (isset($data['note']) && $data['note']) { Panel_Model_Panel::addNote($row->user_id, 'activity', $data['activity_id'], $data['note']); } $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('activity/text/index/id/' . $data['activity_id'] . '/textId/' . $id . '/userId/' . $data['user_id']); } $activity = new Tri_Db_Table('activity'); $this->view->parent = $activity->find($data['activity_id'])->current(); $this->view->messages = array('Error'); $this->view->form = $form; $this->render('index'); }
public function validateAction() { $uniqueId = $this->_getParam('uniqueId'); if ($uniqueId) { $certificate = new Tri_Db_Table('certificate'); $select = $certificate->select(true)->setIntegrityCheck(false)->join('classroom', 'classroom.id = certificate.classroom_id', array())->join('course', 'course.id = classroom.course_id')->join('user', 'user.id = certificate.user_id', array('user.name as uname'))->where('unique_id = ?', $uniqueId); $this->view->data = $certificate->fetchRow($select); } }
/** * Create initial content * * @param integer $courseId */ public static function createInitialContent($courseId) { $data = array(); $data['course_id'] = $courseId; $data['title'] = "Introdução"; $data['description'] = "Bem vindo ao curso!"; $table = new Tri_Db_Table('content'); $table->createRow($data)->save(); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $this->addElementPrefixPath('Tri_Filter', 'Tri/Filter', 'FILTER'); $this->addElementPrefixPath('Tri_Validate', 'Tri/Validate', 'VALIDATE'); $user = new Tri_Db_Table('user'); $validators = $user->getValidators(); $filters = $user->getFilters(); $statusOptions = $user->fetchPairs('status', 'status'); $roles = $user->fetchPairs('role', 'role'); $uploadDir = str_replace('APPLICATION_PATH', APPLICATION_PATH, Tri_Config::get('tri_upload_dir')); $this->setAction('user/save')->setMethod('post')->setAttrib('enctype', 'multipart/form-data'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['name'][] = 'StripTags'; $name = new Zend_Form_Element_Text('name'); $name->setLabel('Name')->addValidators($validators['name'])->addFilters($filters['name'])->setAllowEmpty(false); $email = new Zend_Form_Element_Text('email'); $email->setLabel('Email')->addValidators($validators['email'])->addFilters($filters['email'])->setAllowEmpty(false); $filters['password'][] = 'Md5'; $validators['password'][] = 'PasswordConfirmation'; $password = new Zend_Form_Element_Password('password'); $password->setLabel('Password')->addValidators($validators['password'])->addFilters($filters['password']); $passwordConfirmation = new Zend_Form_Element_Password('password_confirm'); $passwordConfirmation->setLabel('Password confirmation')->addFilter('Md5'); $sex = new Zend_Form_Element_Select('sex'); $sex->setLabel('Sex')->addValidators($validators['sex'])->addFilters($filters['sex'])->addMultiOptions(array('' => '[select]', 'M' => 'Male', 'F' => 'Female')); $born = new Zend_Form_Element_Text('born'); $born->setLabel('Born')->setAttrib('class', 'date')->addFilters($filters['born'])->addValidators($validators['born']); $filters['description'][] = 'StripTags'; $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAllowEmpty(false); $file = new Zend_Form_Element_File('image'); $file->setLabel('Image')->setDestination($uploadDir)->setMaxFileSize(2097152)->setValueDisabled(true)->addFilter('Rename', uniqid())->addValidator('Count', false, 1)->addValidator('Size', false, 2097152)->addValidator('Extension', false, 'jpg,png,gif'); if (!$roles || isset($roles[''])) { $role = new Zend_Form_Element_Text('role'); } else { $rolea = array_unique($roles); $role = new Zend_Form_Element_Select('role'); $role->addMultiOptions(array('' => '[select]') + $roles)->setRegisterInArrayValidator(false); } $role->setLabel('Role')->addValidators($validators['role'])->addFilters($filters['role']); if (!$statusOptions || isset($statusOptions[''])) { $status = new Zend_Form_Element_Text('status'); } else { $statusOptions = array_unique($statusOptions); $status = new Zend_Form_Element_Select('status'); $status->addMultiOptions(array('' => '[select]') + $statusOptions)->setRegisterInArrayValidator(false); } $status->setLabel('Status')->addValidators($validators['status'])->addFilters($filters['status']); $this->addElement($id)->addElement($name)->addElement($email)->addElement($password)->addElement($passwordConfirmation)->addElement($description)->addElement($sex)->addElement($born)->addElement($file); $identity = Zend_Auth::getInstance()->getIdentity(); if ($identity && $identity->role == 'institution') { $this->addElement($status)->addElement($role); } $this->addElement('submit', 'Save'); }
public function deleteAction() { $table = new Tri_Db_Table('glossary'); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); if ($id) { $table->delete(array('id = ?' => $id)); $this->_helper->_flashMessenger->addMessage('Success'); } $this->_redirect('glossary/index/'); }
/** * * @param string $type * @param integer $id * @param integer $note */ public static function addNote($userId, $type, $id, $note) { $session = new Zend_Session_Namespace('data'); $panel = new Tri_Db_Table('panel'); $row = $panel->fetchRow(array('type = ?' => $type, 'item_id = ?' => $id, 'classroom_id = ?' => $session->classroom_id)); if ($row) { $panelNote = new Tri_Db_Table('panel_note'); $panelNote->delete(array('panel_id = ?' => $row->id, 'user_id = ?' => $userId)); $panelNote->createRow(array('panel_id' => $row->id, 'user_id' => $userId, 'note' => $note))->save(); } }
public function saveAction() { $form = new Exercise_Form_Question(); $table = new Tri_Db_Table('exercise_question'); $option = new Tri_Db_Table('exercise_option'); $session = new Zend_Session_Namespace('data'); $allData = $this->_getAllParams(); $form->addMultipleText(); if ($form->isValid($allData)) { $data = $form->getValues(); if (isset($data['id']) && $data['id']) { $row = $table->find($data['id'])->current(); $row->setFromArray($data); $id = $row->save(); } else { unset($data['id']); if (isset($session->exercise_id) && $session->exercise_id) { $exerciseId = $data['exercise_id'] = $session->exercise_id; } $row = $table->createRow($data); $id = $row->save(); } if (count($allData['option'])) { foreach ($allData['option'] as $key => $value) { $status = "wrong"; if ($allData['right_option'] == $key) { $status = "right"; } if ($value) { if (isset($allData['id_option'][$key]) && $allData['id_option'][$key] != 0) { $row = $option->find($allData['id_option'][$key])->current(); $row->setFromArray(array('description' => $value, 'status' => $status)); $row->save(); } else { $data = array('description' => $value, 'exercise_question_id' => $id, 'status' => $status); $row = $option->createRow($data); $row->save(); } } else { if (isset($allData['id_option'][$key]) && $allData['id_option'][$key] != 0) { $option->find($allData['id_option'][$key])->current()->delete(); } } } } $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('exercise/question/index/id/' . $exerciseId); } $this->view->messages = array('Error'); $this->getResponse()->prepend('messages', $this->view->render('message.phtml')); $this->view->form = $form; $this->render('form'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $user = new Tri_Db_Table('user'); $this->addElementPrefixPath('Tri_Filter', 'Tri/Filter', 'FILTER'); $this->addElementPrefixPath('Tri_Validate', 'Tri/Validate', 'VALIDATE'); $validators = $user->getValidators(); $filters = $user->getFilters(); $this->setAction('forgot/send')->setMethod('post'); $email = new Zend_Form_Element_Text('email'); $email->setLabel('Email')->setRequired()->addValidators($validators['email'])->addFilters($filters['email']); $this->addElement($email)->addElement('submit', 'Enviar'); }
public function viewAction() { $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); if ($id) { $course = new Tri_Db_Table('course'); $classroom = new Tri_Db_Table('classroom'); $this->view->data = $course->find($id)->current(); $where = array('course_id = ?' => $id, 'status = ?' => 'open', 'end >= ? OR end IS NULL' => date('Y-m-d')); $this->view->classroom = $classroom->fetchAll($where, 'begin'); $this->view->selectionProcess = SelectionProcess_Model_SelectionProcess::getAvailableProcessByCourse($id); } }
public function deleteAction() { $table = new Tri_Db_Table('content_file'); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $location = $this->_getParam('location'); @unlink(APPLICATION_PATH . '/../data/upload/' . $location); if ($id) { $table->delete(array('id = ?' => $id)); $this->_helper->_flashMessenger->addMessage('Success'); } $this->_redirect('content/file/index/'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('file'); $validators = $table->getValidators(); $filters = $table->getFilters(); $this->setAction('content/file/save')->setMethod('post')->setAttrib('enctype', 'multipart/form-data'); $filters['name'][] = 'StripTags'; $name = new Zend_Form_Element_Text('name'); $name->setLabel('Name')->addValidators($validators['name'])->addFilters($filters['name']); $file = new Zend_Form_Element_File('location'); $file->setLabel('File')->setDestination(APPLICATION_PATH . '/../data/upload/')->setMaxFileSize(10485760)->setValueDisabled(true)->addFilter('Rename', uniqid())->addValidator('Count', false, 1)->addValidator('Size', false, 10485760)->addValidator('Extension', false, 'doc,docx,pdf,ppt,pps,txt,odt,ods,jpg,png,gif,xls,xlsx,swf'); $this->addElement($name)->addElement($file)->addElement('submit', 'Save'); }
/** * Save timeline * * @param string $description * @param string $postInfo * @return void */ public static function save($description, $postInfo = null) { $timeline = new Tri_Db_Table('timeline'); $session = new Zend_Session_Namespace('data'); $translate = Zend_Registry::get('Zend_Translate'); $userId = Zend_Auth::getInstance()->getIdentity()->id; if ($postInfo) { $postInfo = ' - ' . $postInfo; } if (isset($session->classroom_id) && $userId) { $data = array('user_id' => $userId, 'classroom_id' => $session->classroom_id, 'description' => $translate->_($description) . $postInfo); $timeline->createRow($data)->save(); } }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('message'); $validators = $table->getValidators(); $filters = $table->getFilters(); $this->setAction('chat/message/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $receiver = new Zend_Form_Element_Hidden('receiver'); $receiver->addValidators($validators['receiver'])->addFilters($filters['receiver'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 10)->setAllowEmpty(false); $this->addElement($id)->addElement($receiver)->addElement($description)->addElement('submit', 'Save'); }
public static function set($name, $data, $encoded = false) { $table = new Tri_Db_Table('configuration'); $where = array('name = ?' => $name); $row = $table->fetchRow($where); if (!$row) { $row = $table->createRow(); } if ($encoded) { $data = Zend_Json::encode($data); } self::$_data[$name] = $row->value = $data; $row->save(); return $row->value; }
public static function getByClassroom($courses) { if ($courses) { foreach ($courses as $course) { $ids[] = $course['classroom_id']; } } else { $ids = array(0); } $calendar = new Tri_Db_Table('calendar'); $where = array(); $where['end IS NULL OR end > ?'] = date('Y-m-d'); $where['classroom_id IS NULL OR classroom_id IN(?)'] = $ids; return $calendar->fetchAll($where); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('glossary'); $validators = $table->getValidators(); $filters = $table->getFilters(); $this->setAction('glossary/index/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['word'][] = 'StripTags'; $word = new Zend_Form_Element_Text('word'); $word->setLabel('Word')->addValidators($validators['word'])->addFilters($filters['word']); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 15)->setAllowEmpty(false); $this->addElement($id)->addElement($word)->addElement($description)->addElement('submit', 'Save'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('forum_reply'); $validators = $table->getValidators(); $filters = $table->getFilters(); $this->setAction('forum/reply/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $forumId = new Zend_Form_Element_Hidden('forum_id'); $forumId->addValidators($validators['forum_id'])->addFilters($filters['forum_id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['description'][] = 'StripTags'; $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 6)->setAttrib('cols', 60)->setAllowEmpty(false); $this->addElement($id)->addElement($forumId)->addElement($description)->addElement('submit', 'Save'); }
/** * (non-PHPdoc) * @see Zend_Form#init() */ public function init() { $table = new Tri_Db_Table('content_template'); $validators = $table->getValidators(); $filters = $table->getFilters(); $this->setAction('content/template/save')->setMethod('post'); $id = new Zend_Form_Element_Hidden('id'); $id->addValidators($validators['id'])->addFilters($filters['id'])->removeDecorator('Label')->removeDecorator('HtmlTag'); $filters['name'][] = 'StripTags'; $name = new Zend_Form_Element_Text('name'); $name->setLabel('Name')->addValidators($validators['name'])->addFilters($filters['name']); $description = new Zend_Form_Element_Textarea('description'); $description->setLabel('Description')->addValidators($validators['description'])->addFilters($filters['description'])->setAttrib('rows', 15)->setAttrib('id', 'template-description-text')->setAllowEmpty(false); $this->addElement($id)->addElement($name)->addElement($description)->addElement('submit', 'Save'); }
public function saveAction() { $data = $_POST['position']; $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $content = new Tri_Db_Table('content'); $i = 1; foreach ($data as $key => $val) { $row = $content->find($key)->current(); $row->position = $i; $row->save(); $i++; } $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('/content/organizer/index/id/' . $id); }
/** * Emit certificate * * @param integer $userId * @param integer $classroomId */ public static function emit($userId, $classroomId) { $classroom = new Tri_Db_Table('classroom'); $row = $classroom->fetchRow(array('id = ?' => $classroomId)); if ($row) { $classroomUser = new Tri_Db_Table('classroom_user'); $certificate = new Tri_Db_Table('certificate'); $uniqueId = uniqid(); $where = array('classroom_id = ?' => $classroomId, 'user_id = ?' => $userId); $update = $classroomUser->fetchRow($where); $update->status = 'approved'; $update->save(); $data = array('classroom_id' => $classroomId, 'user_id' => $userId, 'unique_id' => $uniqueId, 'begin' => $row->begin, 'end' => date('Y-m-d')); $certificate->createRow($data)->save(); } }