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();
}
}
