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