public function adminAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $isValidUser = "******"; $leaverequestmodel = new Default_Model_Leaverequest(); $eligibleEmployeeIDs = $dateofjoining = explode(",", $leaverequestmodel->getConfigValue(EMPLOYEEVACATIONEXCEPTIONSADMIN)); if (in_array($loginUserId, $eligibleEmployeeIDs)) { $isValidUser = "******"; } $call = $this->_getParam('call'); if ($call == 'ajaxcall') { $this->_helper->layout->disableLayout(); } if ($this->getRequest()->getPost()) { $temployeeIDs[] = $_POST['employeeID']; $tleaveGroups[] = $_POST['leaveGroup']; $tleavetypeIDs[] = $_POST['leavetypeID']; $tleaveCounts[] = $_POST['leaveCount']; $tleaveComments[] = $_POST['leaveComments']; foreach ($temployeeIDs as $temployeeIDs1) { $arrCnt = 0; foreach ($temployeeIDs1 as $temployeeID) { if ($temployeeID != "-1") { $user_id = $temployeeID; $alloted_year = CURRENTYEARYYYY; $alloted_year_half_for = $tleaveGroups[0][$arrCnt]; $leavetypecode = $tleavetypeIDs[0][$arrCnt]; $noofleavesalloted = $tleaveCounts[0][$arrCnt]; $comments = $tleaveComments[0][$arrCnt]; if ($alloted_year_half_for == "1") { if (CURRENTMONTHMM > 6) { $alloted_year = CURRENTYEARYYYY + 1; } } $insString = sprintf("INSERT INTO `tbl_employeeleaves_exception` \r\n (`user_id`,`alloted_year`,`alloted_year_half_for`,`leavetypecode`,\r\n `noofleavesalloted`,`comments`,`createdby`,`createddate`) VALUES \r\n (%s,%s,%s,%s,%s,'%s',%s,now());", $user_id, $alloted_year, $alloted_year_half_for, $leavetypecode, $noofleavesalloted, $comments, $loginUserId); $insID = $leaverequestmodel->ExecuteInsertQuery($insString); } $arrCnt = $arrCnt + 1; } } } $data = array(); $this->view->dataArray = $data; $this->view->id = $loginUserId; $this->view->activeUsers = $leaverequestmodel->getAllActiveUsers(); $this->view->activeLeaveTypes = $leaverequestmodel->getAllActiveLeaveTypes(); $this->view->ActiveLeaveExceptions = $leaverequestmodel->getAllActiveLeaveExceptions($loginUserId); $this->view->isEligible = $isValidUser; $this->view->call = $call; $this->view->messages = $this->_helper->flashMessenger->getMessages(); }