public function saveNoteAction() { $data = $this->_getAllParams(); $panelNote = new Tri_Db_Table('panel_note'); $panelNote->delete(array('panel_id = ?' => $data['panel_id'], 'user_id = ?' => $data['user_id'])); $panelNote->createRow($data)->save(); exit('ok'); }
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 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/'); }
/** * @access public * @return void * @final */ public function deleteAction() { $id = Zend_Filter::filterStatic($this->_getParam("id"), "int"); $content = new Tri_Db_Table('content'); $contentAccess = new Tri_Db_Table('content_access'); $restriction = new Tri_Db_Table('restriction_panel'); try { if ($id) { $restriction->delete(array('content_id = ?' => $id)); $contentAccess->delete(array('content_id = ?' => $id)); $content->delete(array('id = ?' => $id)); } } catch (Exception $e) { $this->_helper->_flashMessenger->addMessage('Error'); } $session = new Zend_Session_Namespace('data'); unset($session->contents); $this->_redirect('/content/composer/index/'); }
/** * Action remove course * * @return void */ public function removeCourseAction() { $selection_process_id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $classroom_id = Zend_Filter::filterStatic($this->_getParam('classroom'), 'int'); $table = new Tri_Db_Table('selection_process_classroom'); if (!empty($selection_process_id) && !empty($classroom_id)) { $data = array('selection_process_id =?' => $selection_process_id, 'classroom_id =?' => $classroom_id); if ($table->delete($data)) { $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('selection-process/index/list-classroom/id/' . $selection_process_id); } } else { if (empty($selection_process_id)) { $this->_helper->_flashMessenger->addMessage('select a selective process'); $this->_redirect('selection-process/index/'); } } $this->_helper->_flashMessenger->addMessage('Error'); $this->_redirect('selection-process/index/list-classroom/id/' . $selection_process_id); }
public function deleteAction() { $id = Zend_filter::filterStatic($this->_getParam('id'), 'int'); $userId = Zend_filter::filterStatic($this->_getParam('userId'), 'int'); $classroomUser = new Tri_Db_Table('classroom_user'); $classroomUser->delete(array('user_id = ?' => $userId, 'classroom_id = ?' => $id)); $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('admin/classroom/list-user/id/' . $id); }