public static function log($message, $origin, $destination = '') { $log_mapper = new Application_Model_LogMapper(); $log = new Application_Model_Log(); $log->setOrigin($origin)->setDestination($destination)->setMessage(serialize($message))->setTstamp(date('Y-m-d H:i:s')); $log_mapper->save($log); }
public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Log(); $entry->setId($row->id)->setOrigin($row->origin)->setDestination($row->destination)->setTstamp($row->tstamp)->setMessage($row->message); $entries[] = $entry; } return $entries; }
public function init() { $this->setName('frmDbConfig'); $model = new Application_Model_Log(); $configArray = $model->getLogs(); $this->addElement('select', 'configId', array('label' => 'Config File Id:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'Select Config Id')))), 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $configArray)); $this->addElement('text', 'dbServerName', array('label' => 'Database Server Name :', 'autocomplete' => "off", 'required' => true, 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'You must enter database server name')))))); // Add an first name element $this->addElement('text', 'dbServerPort', array('label' => 'Database Server Port:', 'class' => 'text-input medium-input', 'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'You must enter databse server port')))), 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); // Add an last name element $this->addElement('text', 'dbName', array('label' => 'Database Name:', 'class' => 'text-input medium-input', 'required' => true, 'decorators' => $this->elementDecorators, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'You must enter databse name name')))), 'filters' => array('StringTrim'))); $this->addElement('text', 'dbUser', array('label' => 'Database User:'******'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'You must enter database user')))), 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'dbPassword', array('label' => 'Database password:'******'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'Please enter databse password')))), 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('select', 'dbTransType', array('label' => 'Databse Transection Type:', 'class' => 'text-input small-input', 'required' => true, 'decorators' => $this->elementDecorators, 'MultiOptions' => array('0' => "select", '1' => "Insert", '2' => "Update", '3' => "Delete"), 'value' => "select")); $this->addElement('select', 'status', array('label' => 'Status:', 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'required' => false, 'MultiOptions' => array('0' => "Inactive", '1' => "Active"))); $this->addElement('submit', 'submit', array('required' => false, 'class' => 'button', 'ignore' => true, 'label' => 'Submit', 'value' => 'submit', 'decorators' => $this->buttonDecorators)); }
public function init() { $this->setName('frmConfiguration'); $model = new Application_Model_Log(); $arrlogs1 = array(0 => 'Select Parent Config id'); $arrLogs = $model->getLogs(); $result = array_merge($arrlogs1, $arrLogs); $this->addElement('select', 'parentConfigId', array('label' => 'Parent Config Id:', 'id' => 'parentConfigId', 'style' => 'width:193px', 'class' => 'text-input small-input', 'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'Please select user group.')))), 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'), 'MultiOptions' => $result)); $this->addElement('text', 'configName', array('label' => 'Config Name:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'required' => true, 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'You must enter Configuration Name')))), 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('textarea', 'configDesc', array('rowss' => '10', 'label' => 'Config Desc:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'validators' => array(array('NotEmpty', true, array('messages' => array('isEmpty' => 'Please Enter Config Description.')))), 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'param1', array('label' => 'Param1:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'param2', array('label' => 'Param2:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'param3', array('label' => 'Param3:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'param4', array('label' => 'Param4:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('text', 'param5', array('label' => 'Param5:', 'autocomplete' => "off", 'class' => 'text-input medium-input', 'decorators' => $this->elementDecorators, 'filters' => array('StringTrim'))); $this->addElement('submit', 'submit', array('required' => false, 'class' => 'button', 'ignore' => true, 'label' => 'Submit', 'value' => 'submit', 'decorators' => $this->buttonDecorators)); }
public function deleteLogAction() { $id = $this->_getParam('id'); $usersNs = new Zend_Session_Namespace("members"); $this->view->config_id = $id; $model1 = new Application_Model_Log(); $model = $model1->find($id); if (false === $model) { $this->_flashMessenger->addMessage(array('error' => 'Invalid request! Please try again.')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/admin/log')); } if ($model->delete("config_id={$id}")) { $this->_flashMessenger->addMessage(array('success' => 'Data Deleted succesfully')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/admin/log/')); } else { $this->_flashMessenger->addMessage(array('error' => 'Failed to Delete the data ')); $this->_helper->_redirector->gotoUrl($this->view->seoUrl('/admin/log')); } }
public function editAction() { $acl_id = $this->getRequest()->getParam('id'); if (!$acl_id) { $acl_id = 0; } $form = new RsvAcl_Form_FrmAcl(); $db = new RsvAcl_Model_DbTable_DbAcl(); $rs = $db->getUserInfo('SELECT * FROM rms_acl_acl where acl_id=' . $acl_id); $this->view->acl_data = $rs[0]; $this->view->acl_id = $acl_id; if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if ($rs[0]['action'] == $post['action']) { $db->updateAcl($post, $rs[0]['acl_id']); //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($acl_id); //End write log file //Application_Form_FrmMessage::message('One row affected!'); Application_Form_FrmMessage::redirector('/rsvAcl/acl/index'); } else { if (!$db->isActionExist($post['action'])) { $db->updateAcl($post, $rs[0]['acl_id']); //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($acl_id); //End write log file //Application_Form_FrmMessage::message('One row affected!'); Application_Form_FrmMessage::redirector('/rsvAcl/acl/index'); } else { Application_Form_FrmMessage::message('Action had existed already'); } } } }
public function editUserTypeAction() { if ($this->getRequest()->getParam('id')) { $db = new RsvAcl_Model_DbTable_DbUserType(); $user_type_id = $this->getRequest()->getParam('id'); $rs = $db->getUserType($user_type_id); $this->view->usertype = $rs; $db1 = new Application_Model_DbTable_DbGlobal(); $allusertype = $db1->getGlobalDb('SELECT user_type_id,user_type FROM rsv_acl_user_type WHERE status=1 AND user_type_id <> ' . $user_type_id); $options = array('' => 'Please select'); foreach ($allusertype as $read) { $options[$read['user_type_id']] = $read['user_type']; } $this->view->usertype_list = $options; } else { Application_Form_FrmMessage::message('User type had not existed'); } if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); //print_r($rs); exit; if ($rs['user_type'] == $post['user_type']) { $db->updateUserType($post, $rs['user_type_id']); //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($user_type_id); //End write log file //Application_Form_FrmMessage::message('One row affected!'); Application_Form_FrmMessage::redirector('/rsvAcl/user-type/index'); } else { if (!$db->isUserTypeExist($post['user_type'])) { $db->updateUserType($post, $rs['user_type_id']); //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($user_type_id); //End write log file //Application_Form_FrmMessage::message('One row affected!'); Application_Form_FrmMessage::redirector('/rsvAcl/user-type/index'); } else { Application_Form_FrmMessage::message('User had existed already'); } } } }
public function updateStatusAction() { if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); $db = new RsvAcl_Model_DbTable_DbUserAccess(); $user_type_id = $post['user_type_id']; $acl_id = $post['acl_id']; $status = $post['status']; $data = array('acl_id' => $acl_id, 'user_type_id' => $user_type_id); if ($status === "yes") { $where = "user_type_id='" . $user_type_id . "' AND acl_id='" . $acl_id . "'"; $db->delete($where); echo "no"; } elseif ($status === "no") { $db->insert($data); echo "yes"; } //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($acl_id); } exit; }
public function changePasswordAction() { $session_user = new Zend_Session_Namespace('auth'); if ($session_user->user_id == $this->getRequest()->getParam('id') or $session_user->level == 1) { $form = new RsvAcl_Form_FrmChgpwd(); //echo $form->getElement('current_password'); exit; $this->view->form = $form; //echo "Work"; exit; if ($this->getRequest()->isPost()) { $db = new RsvAcl_Model_DbTable_DbUser(); $user_id = $this->getRequest()->getParam('id'); if (!$user_id) { $user_id = 0; } $current_password = $this->getRequest()->getParam('current_password'); $password = $this->getRequest()->getParam('password'); if ($db->isValidCurrentPassword($user_id, $current_password)) { $db->changePassword($user_id, md5($password)); //write log file $userLog = new Application_Model_Log(); $userLog->writeUserLog($user_id); //End write log file Application_Form_FrmMessage::message('Password has been changed'); Application_Form_FrmMessage::redirector('/rsvAcl/user/view-user/id/' . $user_id); } else { Application_Form_FrmMessage::message('Invalid current password'); } } } else { Application_Form_FrmMessage::message('Access Denied!'); Application_Form_FrmMessage::redirector('/rsvAcl'); } }
public function configInfoAction() { $this->view->layout()->disableLayout(); $configId = $this->_getParam("config_id"); $model = new Application_Model_Log(); $config = $model->find($configId); if (false === $config) { exit("Records not found for config id : {$configId}!"); } $this->view->config = $config; }
public function getLogs() { $obj = new Application_Model_Log(); $entries = $obj->fetchAll(); $arrLogs = array(); foreach ($entries as $entry) { $arrlogs[$entry->getConfigId()] = ucfirst($entry->getConfigName()); } return $arrlogs; }