public function indexAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $id = $this->getRequest()->getParam('id'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $leaverequestmodel = new Default_Model_Leaverequest(); if ($this->getRequest()->getPost()) { //Grid Edit values $lblIDs[] = $this->_getParam('lblID', null); $txtControllerNos[] = $this->_getParam('txtConfigValues', null); $currRecord = 0; foreach ($lblIDs[0] as $lblID) { if ($lblID > 0) { $updQuery = sprintf("update tbl_config set value = '%s' where id = %s;", $txtControllerNos[0][$currRecord], $lblID); $leaverequestmodel->ExecuteUpdateQuery($updQuery); $currRecord = $currRecord + 1; } } if ($currRecord > 0) { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Configuration table data updated successfully.")); } //for SD Admins $lblSDIDs[] = $this->_getParam('lblSDID', null); $txtSDAdmin1[] = $this->_getParam('txtSDAdmin1', null); $txtSDAdmin2[] = $this->_getParam('txtSDAdmin2', null); $currRecord1 = 0; foreach ($lblSDIDs[0] as $lblSDID) { if ($lblSDID > 0) { $updQuery1 = sprintf("update main_sd_depts set Admin1=%s, Admin2=%s where id = %s;", $txtSDAdmin1[0][$currRecord1], $txtSDAdmin2[0][$currRecord1], $lblSDID); $leaverequestmodel->ExecuteUpdateQuery($updQuery1); $currRecord1 = $currRecord1 + 1; } } if ($currRecord1 > 0) { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "ServiceDesk table data updated successfully.")); } } $this->view->allServiceDeskAdmins = $leaverequestmodel->getServiceDeskAdministrators(); $this->view->allServiceDeskDepartments = $leaverequestmodel->getServiceDeskDepartments(); $this->view->allConfigValues = $leaverequestmodel->getAllConfigValues(); $this->view->messages = $this->_helper->flashMessenger->getMessages(); }