public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $messages['flagtype'] = ''; $actionflag = 3; if ($id) { $payfrequencymodel = new Default_Model_Payfrequency(); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $pay_data = $payfrequencymodel->getsinglePayfrequencyData($id); $Id = $payfrequencymodel->SaveorUpdatePayFrequencyData($data, $where); if ($Id == 'update') { sapp_Global::send_configuration_mail("Pay Frequency", $pay_data[0]['freqtype']); $menuID = PAYFREQUENCY; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Pay frequency deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Pay frequency Status cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Pay frequency cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function comsave($empcommdetailsform, $userid) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $perm_country = $this->_request->getParam('perm_country'); $perm_stateparam = $this->_request->getParam('perm_state'); $perm_stateArr = explode("!@#", $this->_request->getParam('perm_state')); $perm_state = $perm_stateArr[0]; $perm_cityparam = $this->_request->getParam('perm_city'); $perm_cityArr = explode("!@#", $this->_request->getParam('perm_city')); $perm_city = $perm_cityArr[0]; $address_flag = $this->_request->getParam('address_flag'); $current_country = $this->_request->getParam('current_country'); $current_stateparam = $this->_request->getParam('current_state'); $current_stateArr = explode("!@#", $this->_request->getParam('current_state')); $current_state = $current_stateArr[0]; $current_cityparam = $this->_request->getParam('current_city'); $current_cityArr = explode("!@#", $this->_request->getParam('current_city')); $current_city = $current_cityArr[0]; if ($empcommdetailsform->isValid($this->_request->getPost())) { $post_values = $this->_request->getPost(); if (isset($post_values['id'])) { unset($post_values['id']); } if (isset($post_values['user_id'])) { unset($post_values['user_id']); } if (isset($post_values['submit'])) { unset($post_values['submit']); } $new_post_values = array_filter($post_values); if (!empty($new_post_values)) { $empcommdetailsModal = new Default_Model_Empcommunicationdetails(); $id = $this->_request->getParam('id'); $user_id = $userid; $personalemail = $this->_request->getParam('personalemail'); $perm_streetaddress = $this->_request->getParam('perm_streetaddress'); $perm_pincode = $this->_request->getParam('perm_pincode'); $current_streetaddress = $this->_request->getParam('current_streetaddress'); $current_pincode = $this->_request->getParam('current_pincode'); $emergency_number = $this->_request->getParam('emergency_number'); $emergency_name = $this->_request->getParam('emergency_name'); $emergency_email = $this->_request->getParam('emergency_email'); $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('user_id' => $user_id, 'personalemail' => $personalemail, 'perm_streetaddress' => $perm_streetaddress, 'perm_country' => $perm_country != '' ? $perm_country : NULL, 'perm_state' => $perm_state != '' ? $perm_state : NULL, 'perm_city' => $perm_city != '' ? $perm_city : NULL, 'perm_pincode' => $perm_pincode, 'current_streetaddress' => $current_streetaddress != '' ? $current_streetaddress : NULL, 'current_country' => $current_country != '' ? $current_country : NULL, 'current_state' => $current_state != '' ? $current_state : NULL, 'current_city' => $current_city != '' ? $current_city : NULL, 'current_pincode' => $current_pincode != '' ? $current_pincode : NULL, 'emergency_number' => $emergency_number != '' ? $emergency_number : NULL, 'emergency_name' => $emergency_name != '' ? $emergency_name : NULL, 'emergency_email' => $emergency_email != '' ? $emergency_email : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $empcommdetailsModal->SaveorUpdateEmpcommData($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details updated successfully.")); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG)); } $this->_redirect('myemployees/comedit/userid/' . $userid); } else { $messages = $empcommdetailsform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } if (isset($perm_country) && $perm_country != 0 && $perm_country != '') { $statesmodel = new Default_Model_States(); $statesmodeldata = $statesmodel->getStatesList($perm_country); $empcommdetailsform->perm_state->clearMultiOptions(); $empcommdetailsform->perm_city->clearMultiOptions(); $empcommdetailsform->perm_state->addMultiOption('', 'Select State'); foreach ($statesmodeldata as $res) { $empcommdetailsform->perm_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name'])); } if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') { $empcommdetailsform->setDefault('perm_state', $perm_stateparam); } } if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') { $citiesmodel = new Default_Model_Cities(); $citiesmodeldata = $citiesmodel->getCitiesList($perm_state); $empcommdetailsform->perm_city->addMultiOption('', 'Select City'); foreach ($citiesmodeldata as $res) { $empcommdetailsform->perm_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name'])); } if (isset($perm_cityparam) && $perm_cityparam != 0 && $perm_cityparam != '') { $empcommdetailsform->setDefault('perm_city', $perm_cityparam); } } if (isset($current_country) && $current_country != 0 && $current_country != '') { $statesmodel = new Default_Model_States(); $statesmodeldata = $statesmodel->getStatesList($current_country); $empcommdetailsform->current_state->addMultiOption('', 'Select State'); foreach ($statesmodeldata as $res) { $empcommdetailsform->current_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name'])); } if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') { $empcommdetailsform->setDefault('current_state', $current_stateparam); } } if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') { $citiesmodel = new Default_Model_Cities(); $citiesmodeldata = $citiesmodel->getCitiesList($current_state); $empcommdetailsform->current_city->addMultiOption('', 'Select City'); foreach ($citiesmodeldata as $res) { $empcommdetailsform->current_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name'])); } if (isset($current_cityparam) && $current_cityparam != 0 && $current_cityparam != '') { $empcommdetailsform->setDefault('current_city', $current_cityparam); } } return $msgarray; } }
public function saveorginfo($form, $loginUserId, $wizardData) { $orgInfoModel = new Default_Model_Organisationinfo(); $wizard_model = new Default_Model_Wizard(); $id = $this->getRequest()->getParam('id'); $imagerror = $this->_request->getParam('imgerr'); $imagepath = $this->_request->getParam('org_image_value'); $imgerrmsg = $this->_request->getParam('imgerrmsg'); $pphnumber = $this->_request->getParam('phonenumber'); $sphnumber = $this->_request->getParam('secondaryphone'); $org_startdate = sapp_Global::change_date($this->_request->getParam('org_startdate'), 'database'); $flag = 'true'; if (isset($imagepath) && $imagepath != '') { $imageArr = explode('.', $imagepath); if (sizeof($imageArr) > 1) { $imagename = $imageArr[0]; $imageext = $imageArr[1]; $extArr = array('gif', 'jpg', 'jpeg', 'png'); if (!in_array($imageext, $extArr)) { $msgarray['org_image_value'] = 'Please upload an appropriate image file.'; $flag = 'false'; } } else { $msgarray['org_image_value'] = 'Please upload an appropriate image file.'; $flag = 'false'; } } if ($imagerror == 'error') { if ($imgerrmsg != '' && $imgerrmsg != 'undefined') { $msgarray['org_image_value'] = $imgerrmsg; } else { $msgarray['org_image_value'] = 'Please upload an appropriate image file.'; } $flag = 'false'; } if ($pphnumber == $sphnumber && $sphnumber != '' && $pphnumber != '') { $msgarray['secondaryphone'] = 'Please enter different phone number.'; $flag = 'false'; } if ($form->isValid($this->_request->getPost()) && $flag != 'false') { $domain = $this->_request->getParam('domain'); $domain = implode(',', $domain); $date = new Zend_Date(); $data = array('organisationname' => trim($this->_request->getParam('organisationname')), 'domain' => trim($domain), 'website' => trim($this->_request->getParam('website')), 'org_image' => $imagepath, 'orgdescription' => trim($this->_request->getParam('orgdescription')), 'totalemployees' => trim($this->_request->getParam('totalemployees')), 'org_startdate' => $org_startdate != '' ? $org_startdate : NULL, 'phonenumber' => trim($this->_request->getParam('phonenumber')), 'secondaryphone' => trim($this->_request->getParam('secondaryphone')), 'faxnumber' => trim($this->_request->getParam('faxnumber')), 'country' => trim((int) $this->_request->getParam('country')), 'state' => trim(intval($this->_request->getParam('state'))), 'city' => trim(intval($this->_request->getParam('city'))), 'address1' => trim($this->_request->getParam('address1')), 'address2' => trim($this->_request->getParam('address2')), 'address3' => trim($this->_request->getParam('address3')), 'description' => trim($this->_request->getParam('description')), 'designation' => trim($this->_request->getParam('jobtitle_id', null)), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $db = Zend_Db_Table::getDefaultAdapter(); $db->beginTransaction(); try { $path = IMAGE_UPLOAD_PATH; $imagepath = $this->_request->getParam('org_image_value'); $filecopy = 'success'; if ($imagepath != '') { $filecopy = 'error'; if (file_exists(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath)) { try { if (copy(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath, $path . '//' . $imagepath)) { $filecopy = 'success'; } unlink(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath); } catch (Exception $e) { echo $msgarray['org_image_value'] = $e->getMessage(); exit; } } } $where = array('id=?' => $id); if ($imagepath == '') { unset($data['org_image']); } else { if ($filecopy == 'error') { unset($data['org_image']); } } if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $orgInfoModel->SaveorUpdateData($data, $where); $menuID = ORGANISATIONINFO; try { if ($Id != '' && $Id != 'update') { $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $Id); } else { $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); } } catch (Exception $e) { echo $e->getMessage(); } $wizardarray = array('org_details' => 2, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($wizardData['site_config'] == 2) { $wizardarray['iscomplete'] = 2; } $wizard_model->SaveorUpdateWizardData($wizardarray, ''); $location_data = array('country' => trim((int) $this->_request->getParam('country')), 'state' => trim(intval($this->_request->getParam('state'))), 'city' => trim(intval($this->_request->getParam('city'))), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $LocationId = $wizard_model->SaveorUpdateWizardData($location_data, ''); $db->commit(); if ($filecopy == 'success') { $this->_helper->getHelper("FlashMessenger")->addMessage("Organization information saved successfully."); } else { $this->_helper->getHelper("FlashMessenger")->addMessage("Organization information saved successfully but failed to upload the logo."); } $this->_redirect('wizard/configureorganisation'); } catch (Exception $e) { $db->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong,please try again later.")); $this->_redirect('wizard/configureorganisation'); } } else { $messages = $form->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } //echo '<pre>';print_r($messages);exit; return $msgarray; } }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id) { $systempreferencemodel = new Default_Model_Sitepreference(); $menumodel = new Default_Model_Menu(); $data = array('isactive' => 0); $where = array('id=?' => $id); $Id = $systempreferencemodel->SaveorUpdateSystemPreferanceData($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/sitepreference'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Site preferences deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Site preferences cannot be deleted.'; } $messages['msgtype'] = 'error'; } else { $messages['message'] = 'Site preferences cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function updatecontactnumberAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('id'); $contactnumber = $this->_request->getParam('contactnumber'); $messages['message'] = ''; $actionflag = 2; if ($id) { $usersModal = new Default_Model_Users(); $menumodel = new Default_Model_Menu(); $data = array('contactnumber' => $contactnumber); $where = array('id=?' => $id); $Id = $usersModal->addOrUpdateUserModel($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Contact number updated successfully.'; } else { $messages['message'] = 'Contact number cannot be updated.'; } } else { $messages['message'] = 'Contact number cannot be updated.'; } $this->_helper->json($messages); }
public function save($empleavesform, $userid, $used_leaves, $leavetransfercount, $isleavetrasnferset, $currentyearleavecount) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } if ($empleavesform->isValid($this->_request->getPost())) { $employeeleavesModel = new Default_Model_Employeeleaves(); $id = $this->_request->getParam('id'); $user_id = $userid; $emp_leave_limit = $this->_request->getParam('leave_limit'); if ($leavetransfercount != '' && $currentyearleavecount == '') { $emp_leave_limit = $emp_leave_limit + $leavetransfercount; } else { $emp_leave_limit = $emp_leave_limit + $currentyearleavecount; } $isleavetrasnfer = 0; if ($isleavetrasnferset == 1) { $isleavetrasnfer = 1; } $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; /* Save employee leaves in allotted leaves log */ $postedArr = array(); $postedArr = $_POST; $saveID = $employeeleavesModel->saveallotedleaves($postedArr, $emp_leave_limit, $user_id, $loginUserId); /* END */ $Id = $employeeleavesModel->SaveorUpdateEmployeeLeaves($user_id, $emp_leave_limit, $isleavetrasnfer, $loginUserId); if ($id) { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details updated successfully.")); $actionflag = 2; $tableid = $id; } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details added successfully.")); $actionflag = 1; $tableid = $Id; } $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); $this->_redirect('empleaves/edit/userid/' . $user_id); } else { $messages = $empleavesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id) { $leavemanagementmodel = new Default_Model_Leavemanagement(); $menumodel = new Default_Model_Menu(); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $leavemanagementmodel->SaveorUpdateLeaveManagementData($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/leavemanagement'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Leave management deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Leave management cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Leave management cannot be deleted.'; $messages['msgtype'] = 'succerroress'; } $this->_helper->json($messages); }
public function updateempdetails($employeeform) { $emproleStr = ''; $roleArr = array(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $usersModel = new Default_Model_Usermanagement(); $employeeModal = new Default_Model_Employee(); $businessunit_id = $this->_request->getParam('businessunit_id', null); $department_id = $this->_request->getParam('department_id', null); $reporting_manager = $this->_request->getParam('reporting_manager', null); $jobtitle_id = $this->_request->getParam('jobtitle_id', null); $position_id = $this->_request->getParam('position_id', null); $user_id = $this->_getParam('user_id', null); $prefix_id = $this->_getParam('prefix_id', null); $extension_number = $this->_getParam('extension_number', null); if ($employeeform->isValid($this->_request->getPost())) { $id = $this->_request->getParam('id'); $emp_status_id = $this->_request->getParam('emp_status_id', null); $date_of_joining = $this->_request->getParam('date_of_joining', null); $date_of_joining = sapp_Global::change_date($date_of_joining, 'database'); $date_of_leaving = $this->_request->getParam('date_of_leaving', null); $date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database'); $years_exp = $this->_request->getParam('years_exp'); //FOR USER table $employeeId = $this->_getParam('employeeId', null); $modeofentry = $this->_getParam('modeofentry', null); $hid_modeofentry = $this->_getParam('hid_modeofentry', null); $other_modeofentry = $this->_getParam('other_modeofentry', null); $userfullname = $this->_getParam('userfullname', null); $candidatereferredby = $this->_getParam('candidatereferredby', null); $rccandidatename = $this->_getParam('rccandidatename', null); $emprole = $this->_getParam('emprole', null); //roleid_group_id if ($emprole != "") { $roleArr = explode('_', $emprole); if (!empty($roleArr)) { $emproleStr = $roleArr[0]; } } $emailaddress = $this->_getParam('emailaddress', null); $tmp_name = $this->_request->getParam('tmp_emp_name', null); $act_inact = $this->_request->getParam("act_inact", null); //end of user table $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $empstatusarray = array(8, 9, 10); $actionflag = ''; $tableid = ''; if ($modeofentry == 'Direct' || $hid_modeofentry == 'Direct') { $candidate_key = 'userfullname'; $candidate_value = $userfullname; $emp_name = $userfullname; $candidate_flag = 'no'; } else { $candidate_key = 'rccandidatename'; $candidate_value = $rccandidatename; $emp_name = $tmp_name; $candidate_flag = 'yes'; } $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $emppassword = sapp_Global::generatePassword(); $user_data = array('emprole' => $emproleStr, $candidate_key => $candidate_value, 'emailaddress' => $emailaddress, 'modifiedby' => $loginUserId, 'modifieddate' => Zend_Registry::get('currentdate'), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => $id == '' ? $modeofentry : "", 'selecteddate' => $date_of_joining, 'candidatereferredby' => $candidatereferredby, 'userstatus' => 'old', 'other_modeofentry' => $other_modeofentry); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; $user_where = "id = " . $user_id; unset($user_data['candidatereferredby']); unset($user_data['userstatus']); unset($user_data['emppassword']); unset($user_data['employeeId']); unset($user_data['modeofentry']); unset($user_data['other_modeofentry']); } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; if ($modeofentry != 'Direct') { $user_data['userfullname'] = $emp_name; } $where = ''; $actionflag = 1; $user_where = ''; } $user_status = $usersModel->SaveorUpdateUserData($user_data, $user_where); if ($id == '') { $user_id = $user_status; } $data = array('user_id' => $user_id, 'reporting_manager' => $reporting_manager, 'emp_status_id' => $emp_status_id, 'businessunit_id' => $businessunit_id, 'department_id' => $department_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'extension_number' => $extension_number, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'years_exp' => $years_exp == '' ? null : $years_exp, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $employeeModal->SaveorUpdateEmployeeData($data, $where); $statuswhere = array('id=?' => $user_id); if (in_array($emp_status_id, $empstatusarray)) { $isactivestatus = ''; if ($emp_status_id == 8) { $isactivestatus = 2; } else { if ($emp_status_id == 9) { $isactivestatus = 3; } else { if ($emp_status_id == 10) { $isactivestatus = 4; } } } $statusdata = array('isactive' => $isactivestatus); $empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere); } else { $statusdata = array('isactive' => 1); $empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere); } if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details updated successfully.")); } else { //start of mailing $base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $view = $this->getHelper('ViewRenderer')->view; $this->view->emp_name = $emp_name; $this->view->password = $emppassword; $this->view->emp_id = $employeeId; $this->view->base_url = $base_url; $text = $view->render('mailtemplates/newpassword.phtml'); $options['subject'] = APPLICATION_NAME . ' login credentials'; $options['header'] = 'Greetings from Sentrifugo'; $options['toEmail'] = $emailaddress; $options['toName'] = $this->view->emp_name; $options['message'] = $text; $result = sapp_Global::_sendEmail($options); //end of mailing $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $menuidArr = $menumodel->getMenuObjID('/usermanagement'); $menuID_user = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); if ($act_inact == 1) { if ($user_data['isactive'] == 1) { $act_str = array("Activated" => Zend_Registry::get('currentdate')); } else { $act_str = array("Inactivated" => Zend_Registry::get('currentdate')); } $result = sapp_Global::logManager($menuID_user, 4, $loginUserId, $user_id, '', $act_str); } $trDb->commit(); $this->_redirect('employee/edit/id/' . $user_id); } catch (Exception $e) { $trDb->rollBack(); $msgarray['employeeId'] = "Something went wrong,please try again later."; return $msgarray; } } else { $messages = $employeeform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } $usersModel = new Default_Model_Users(); if (isset($businessunit_id) && $businessunit_id != 0 && $businessunit_id != '') { $departmentsmodel = new Default_Model_Departments(); $departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id); $employeeform->department_id->clearMultiOptions(); $employeeform->reporting_manager->clearMultiOptions(); $employeeform->department_id->addMultiOption('', 'Select Department'); foreach ($departmentlistArr as $departmentlistresult) { $employeeform->department_id->addMultiOption($departmentlistresult['id'], utf8_encode($departmentlistresult['deptname'])); } if (isset($department_id) && $department_id != 0 && $department_id != '') { $employeeform->setDefault('department_id', $department_id); } } if (isset($department_id) && $department_id != 0 && $department_id != '') { $reportingManagerArr = $usersModel->getReportingManagerList($department_id, $user_id); $employeeform->reporting_manager->addMultiOption('', 'Select Reporting Manager'); foreach ($reportingManagerArr as $reportingManagerresult) { $employeeform->reporting_manager->addMultiOption($reportingManagerresult['id'], utf8_encode($reportingManagerresult['userfullname'])); } if (isset($reporting_manager) && $reporting_manager != 0 && $reporting_manager != '') { $employeeform->setDefault('reporting_manager', $reporting_manager); } } if (isset($jobtitle_id) && $jobtitle_id != 0 && $jobtitle_id != '') { $positionsmodel = new Default_Model_Positions(); $positionlistArr = $positionsmodel->getPositionList($jobtitle_id); $employeeform->position_id->clearMultiOptions(); $employeeform->position_id->addMultiOption('', 'Select Position'); foreach ($positionlistArr as $positionlistRes) { $employeeform->position_id->addMultiOption($positionlistRes['id'], utf8_encode($positionlistRes['positionname'])); } if (isset($position_id) && $position_id != 0 && $position_id != '') { $employeeform->setDefault('position_id', $position_id); } } return $msgarray; } }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $messages['flagtype'] = ''; $actionflag = 3; if ($id) { $empadditionaldetailsModal = new Default_Model_Empadditionaldetails(); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $empadditionaldetailsModal->SaveorUpdateEmpAdditionalData($data, $where); if ($Id == 'update') { $menuID = EMPLOYEE; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Employee additional details deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Employee additional details cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Employee additional details cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id) { $currencyconvertermodel = new Default_Model_Currencyconverter(); $currencyconverterdata = $currencyconvertermodel->getCurrencyConverterDatabyID($id); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $currencyconvertermodel->SaveorUpdateCurrencyConverterData($data, $where); if ($Id == 'update') { $menuID = CURRENCYCONVERTER; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $configmail = sapp_Global::send_configuration_mail('Base Currency', $currencyconverterdata[0]['basecurrtext']); $messages['message'] = 'Currency converter deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Currency converter cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Currency converter cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id) { $numberformatsmodel = new Default_Model_Numberformats(); $menumodel = new Default_Model_Menu(); $numberformatdata = $numberformatsmodel->getNumberFormatDataByID($id); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $numberformatsmodel->SaveorUpdateNumberFormatData($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/numberformats'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $configmail = sapp_Global::send_configuration_mail('Number Format', $numberformatdata[0]['numberformattype']); $messages['message'] = 'Number format deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Number format cannot be deleted.'; $messages['msgtype'] = 'success'; } } else { $messages['message'] = 'Number format cannot be deleted.'; $messages['msgtype'] = 'success'; } $this->_helper->json($messages); }
public function savegroupedemployees() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $appraisalinitmodel = new Default_Model_Appraisalgroupemployeestemp(); $menumodel = new Default_Model_Menu(); $groupid = $this->_request->getParam('group_id'); $appraisalid = $this->_request->getParam('appraisalid'); $empids = $this->_request->getParam('empids'); $id = ''; $actionflag = ''; $tableid = ''; $msgarray = array(); if (!isset($groupid) && $groupid == '') { $groupid = 0; } try { $ifrecordexists = $appraisalinitmodel->checkAppraisalRecordexists($groupid, $appraisalid); if (!empty($ifrecordexists)) { $id = $ifrecordexists[0]['id']; } $insertdata = array('pa_initialization_id' => $appraisalid, 'group_id' => $groupid, 'employee_ids' => $empids, 'isactive' => 1, 'createdby' => $loginUserId, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s")); $updatedata = array('employee_ids' => $empids, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; $tableid = $id; $appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($updatedata, $where); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees updated successfully.")); } else { $where = ''; $actionflag = 1; $Id = $appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($insertdata, $where); $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/appraisalinit'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $this->_redirect('appraisalinit/assigngroups/id/' . $appraisalid); } catch (Exception $e) { $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => $e->getMessage())); } return $msgarray; }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserEmail = $auth->getStorage()->read()->emailaddress; $loginUserName = $auth->getStorage()->read()->userfullname; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $actionflag = 5; $businessunitid = ''; $leavetypetext = ''; if ($id) { $leaverequestmodel = new Default_Model_Leaverequest(); $usersmodel = new Default_Model_Users(); $employeesmodel = new Default_Model_Employees(); $employeeleavetypesmodel = new Default_Model_Employeeleavetypes(); $loggedInEmployeeDetails = $employeesmodel->getLoggedInEmployeeDetails($loginUserId); if ($loggedInEmployeeDetails[0]['businessunit_id'] != '') { $businessunitid = $loggedInEmployeeDetails[0]['businessunit_id']; } $dataarr = array('leavestatus' => 4, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId); $where = array('id=?' => $id); $Id = $leaverequestmodel->SaveorUpdateLeaveRequest($dataarr, $where); $data = $leaverequestmodel->getsinglePendingLeavesData($id); $data = $data[0]; $appliedleavesdaycount = $data['appliedleavescount']; $to_date = $data['to_date']; $from_date = $data['from_date']; $reason = $data['reason']; $leavetypeid = $data['leavetypeid']; $repmngrnameArr = $usersmodel->getUserDetailsByID($data['rep_mang_id']); $reportingmanageremail = $repmngrnameArr[0]['emailaddress']; $reportingmanagername = $repmngrnameArr[0]['userfullname']; if ($Id == 'update') { $menuID = PENDINGLEAVES; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); /** MAILING CODE **/ if ($to_date == '' || $to_date == NULL) { $to_date = $from_date; } /* Mail to Employee */ $options['subject'] = 'Leave request cancelled'; $options['header'] = 'Leave Request'; $options['toEmail'] = $loginUserEmail; $options['toName'] = $loginUserName; $options['message'] = '<div>Hi,</div> <div>The below leave(s) has been cancelled.</div> <div> <table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff"> <tbody><tr> <td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td> <td width="72%">' . $loginUserName . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td> <td>' . $appliedleavesdaycount . '</td> </tr> <tr> <td style="border-right:2px solid #BBBBBB;">From</td> <td>' . $from_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">To</td> <td>' . $to_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">Reason for Leave</td> <td>' . $reason . '</td> </tr> </tbody></table> </div> <div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>'; $result = sapp_Global::_sendEmail($options); /* End */ /* Mail to Reporting Manager */ $options['subject'] = 'Leave request cancelled'; $options['header'] = 'Leave Request'; $options['toEmail'] = $reportingmanageremail; $options['toName'] = $reportingmanagername; $options['message'] = '<div>Hi,</div> <div>The below leave(s) has been cancelled.</div> <div> <table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff"> <tbody><tr> <td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td> <td width="72%">' . $loginUserName . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td> <td>' . $appliedleavesdaycount . '</td> </tr> <tr> <td style="border-right:2px solid #BBBBBB;">From</td> <td>' . $from_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">To</td> <td>' . $to_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">Reason for Leave</td> <td>' . $reason . '</td> </tr> </tbody></table> </div> <div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>'; $result = sapp_Global::_sendEmail($options); /* End */ /* Mail to HR */ if (defined('LV_HR_' . $businessunitid) && $businessunitid != '') { $options['subject'] = 'Leave request cancelled'; $options['header'] = 'Leave Request'; $options['toEmail'] = constant('LV_HR_' . $businessunitid); $options['toName'] = 'Leave management'; $options['message'] = '<div>Hi,</div> <div>The below leave(s) has been cancelled by the Employee.</div> <div> <table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff"> <tbody><tr> <td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td> <td width="72%">' . $loginUserName . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td> <td>' . $appliedleavesdaycount . '</td> </tr> <tr> <td style="border-right:2px solid #BBBBBB;">From</td> <td>' . $from_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">To</td> <td>' . $to_date . '</td> </tr> <tr bgcolor="#e9f6fc"> <td style="border-right:2px solid #BBBBBB;">Reason for Leave</td> <td>' . $reason . '</td> </tr> </tbody></table> </div> <div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>'; $options['cron'] = 'yes'; $result = sapp_Global::_sendEmail($options); } $messages['message'] = 'Leave request cancelled'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Leave request cannot be cancelled'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Leave request cannot be cancelled'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function deleteAction() { $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->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $count = 0; $actionflag = 3; if ($id) { $appraisalquestionsmodel = new Default_Model_Appraisalquestions(); $menumodel = new Default_Model_Menu(); $appraisalquestionsdata = $appraisalquestionsmodel->getAppraisalQuestionbyID($id); if ($appraisalquestionsdata[0]['isused'] == 0) { $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId); $where = array('id=?' => $id); $Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/appraisalquestions'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $configmail = sapp_Global::send_configuration_mail('Question', $appraisalquestionsdata[0]['question']); $messages['message'] = 'Question deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Question cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Question cannot be deleted as its using in appraisal process.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Question cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function savepopupAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $feedforwardquestionsmodel = new Default_Model_Feedforwardquestions(); $msgarray = array(); $result['msg'] = ''; $result['id'] = ''; $result['question'] = ''; $result['description'] = ''; try { $question = trim($this->_request->getParam('question')); $description = trim($this->_request->getParam('description')); $actionflag = ''; $data = array('question' => $question, 'description' => $description != '' ? $description : NULL, 'module_flag' => 2, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $data['createdby_role'] = $loginuserRole; $data['createdby_group'] = $loginuserGroup; $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; $Id = $feedforwardquestionsmodel->SaveorUpdateFeedforwardQuestionData($data, $where); $menuID = FEEDFORWARDQUESTIONS; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $Id); $result['msg'] = 'success'; $result['id'] = $Id; $result['question'] = $question; $result['description'] = $description; } catch (Exception $e) { $result['msg'] = $e->getMessage(); $result['id'] = ''; $result['question'] = ''; $result['description'] = ''; } $this->_helper->json($result); }
public function savequestionpopupAction() { $ajaxContext = $this->_helper->getHelper('AjaxContext'); $ajaxContext->addActionContext('savequestionpopup', 'json')->initContext(); $this->_helper->layout->disableLayout(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $appraisalquestionsmodel = new Default_Model_Appraisalquestions(); $result['result'] = ''; $result['id'] = ''; $result['question'] = ''; $result['description'] = ''; try { $categoryval = $this->_request->getParam('categoryval'); $questionval = urldecode($this->_request->getParam('questionval')); $description = trim($this->_request->getParam('description')); $moduleflag = trim($this->_request->getParam('moduleflag')); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('pa_category_id' => $categoryval, 'question' => $questionval, 'description' => $description != '' ? $description : NULL, 'module_flag' => $moduleflag, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'createdby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = ''; $actionflag = 1; if ($questionval != '' && $categoryval != '' && $moduleflag != '' && preg_match('/^[a-zA-Z0-9.\\- ?\',\\/#@$&*()!]+$/', $questionval)) { $Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where); $menuidArr = $menumodel->getMenuObjID('/appraisalquestions'); $menuID = $menuidArr[0]['id']; $logresult = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $result['msg'] = 'success'; $result['id'] = $Id; $result['question'] = $questionval; $result['description'] = $description; } else { $result['msg'] = 'error'; $result['id'] = ''; $result['question'] = ''; $result['description'] = ''; } } catch (Exception $e) { $result['msg'] = $e->getMessage(); $result['id'] = ''; $result['question'] = ''; $result['description'] = ''; } $this->_helper->json($result); }
public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $sess_vals = $auth->getStorage()->read(); $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $timesheetDay = date('d-m-Y'); $id = $this->getRequest()->getParam('id', null); $timeSheetModel = new Default_Model_Fillintimesheet(); $nonProjecttimeSheetModel = new Default_Model_Fillintimesheetnonproject(); $where = ""; $actionflag = 1; $form = new Default_Form_createprojects(); //$form->setAttrib('action', DOMAIN . 'fillintimesheet/edit/id/' . $id); if ($this->getRequest()->getPost()) { $trDb = Zend_Db_Table::getDefaultAdapter(); try { //Task Details //$tprojectSelected = $this->_getParam('projectSelected', null); //$ttaskSelected = $this->_getParam('taskSelected', null); $thid_status = $this->_getParam('hid_status', null); $timesheetDay = $this->_getParam('timesheetDay', null); if ($thid_status == "0") { // starting transaction $trDb->beginTransaction(); //record Project Timesheet $thid_allocationkeyids = $this->_getParam('hid_allocationkeyid', null); $thid_actualeffort = $this->_getParam('hid_actualeffort', null); $thid_actualeffortcomments = $this->_getParam('hid_actualeffortcomments', null); $ttimesheetDay = $this->_getParam('timesheetDay', null); $ttimesheetDay = sapp_Global::change_date(trim($ttimesheetDay), 'database'); $curRow = 0; foreach ($thid_allocationkeyids as $thid_allocationkeyid) { $curActualEffort = $thid_actualeffort[$curRow]; if (is_numeric($curActualEffort)) { if ($curActualEffort > 0) { $existingID = $timeSheetModel->isTimeAlreadySubmitted($thid_allocationkeyid, $ttimesheetDay); if ($existingID == "0") { $mpolicydata = array('resourcetaskactivityid' => trim($thid_allocationkeyid), 'effort' => trim($curActualEffort), 'comments' => trim($thid_actualeffortcomments[$curRow]), 'workdate' => $ttimesheetDay, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = ""; $Id = $timeSheetModel->SaveorUpdateData($mpolicydata, $where); } else { $where = array('id=?' => $existingID); $mpolicydata = array('effort' => trim($curActualEffort), 'comments' => trim($thid_actualeffortcomments[$curRow]), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $timeSheetModel->SaveorUpdateData($mpolicydata, $where); } } } $curRow = $curRow + 1; } //record Non-Project Timesheet $tnonprojectrowremoves = $this->_getParam('nonprojectrowremove', null); $tnonprojectrowids = $this->_getParam('nonprojectrowid', null); $tcategorySelecteds = $this->_getParam('categorySelected', null); $tcategoryactivityselected = $this->_getParam('categoryactivityselected', null); $tcategoryreference = $this->_getParam('categoryreference', null); $tcategoryreferencedescription = $this->_getParam('categoryreferencedescription', null); $tcategoryactualeffort = $this->_getParam('categoryactualeffort', null); $tcategoryactualeffortcomments = $this->_getParam('categoryactualeffortcomments', null); $curRow = 0; //Insert or update foreach ($tcategorySelecteds as $tcategorySelected) { $categoryActualEffort = $tcategoryactualeffort[$curRow]; $categoryactivityselected = $tcategoryactivityselected[$curRow]; if (is_numeric($categoryActualEffort)) { if ($categoryActualEffort > 0) { //$existingID = $nonProjecttimeSheetModel->isTimeAlreadySubmitted($tcategorySelected, $categoryactivityselected, $loginUserId, $ttimesheetDay1); $existingID = $tnonprojectrowids[$curRow]; if ($existingID == "0") { $mpolicydata = array('categoryid' => trim($tcategorySelected), 'activityid' => trim($categoryactivityselected), 'resourceid' => trim($loginUserId), 'workdate' => $ttimesheetDay, 'reference' => trim($tcategoryreference[$curRow]), 'referencedescription' => trim($tcategoryreferencedescription[$curRow]), 'effort' => trim($categoryActualEffort), 'comments' => trim($tcategoryactualeffortcomments[$curRow]), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = ""; $Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where); } else { $where = array('id=?' => $existingID); $mpolicydata = array('categoryid' => trim($tcategorySelected), 'activityid' => trim($categoryactivityselected), 'reference' => trim($tcategoryreference[$curRow]), 'referencedescription' => trim($tcategoryreferencedescription[$curRow]), 'effort' => trim($categoryActualEffort), 'comments' => trim($tcategoryactualeffortcomments[$curRow]), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where); } } } $curRow = $curRow + 1; } //Soft Delete foreach ($tnonprojectrowremoves as $tnonprojectrowremove) { $where = array('id=?' => $tnonprojectrowremove); $mpolicydata = array('isactive' => 0, 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where); } //if ($Id > 0 && is_numeric($Id)) { $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Timesheet details successfully added.")); //} else { // $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding Timesheet details.")); //} $trDb->commit(); //$this->view->messages = $this->_helper->flashMessenger->getMessages(); $this->_redirect('/fillintimesheet'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); //$this->view->messages = $this->_helper->flashMessenger->getMessages(); $this->_redirect('/fillintimesheet'); } } $form->submit->setLabel('Submit'); $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $ttimesheetDay = sapp_Global::change_date(trim($timesheetDay), 'database'); $this->view->sess_vals = $sess_vals; $this->view->loginUserId = $loginUserId; $this->view->loginuserRole = $loginuserRole; $this->view->loginuserGroup = $loginuserGroup; $this->view->selDate = $ttimesheetDay; $this->view->projectcategories = $timeSheetModel->getProjectCategories(); $this->view->categoryActivities = $timeSheetModel->AllCategoryActivities(); $timesheetGrid = $timeSheetModel->getEmployeeTimesheetGrid($ttimesheetDay, $loginUserId); $nonprojecttimesheetGrid = $timeSheetModel->getEmployeeNonProjectTimesheetGrid($ttimesheetDay, $loginUserId); $this->view->timesheetGrid = $timesheetGrid; $this->view->nonprojecttimesheetGrid = $nonprojecttimesheetGrid; }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $messages['flagtype'] = ''; $actionflag = 3; if ($id) { $positionsmodel = new Default_Model_Positions(); $menumodel = new Default_Model_Menu(); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $position_data = $positionsmodel->getsinglePositionData($id); $Id = $positionsmodel->SaveorUpdatePositionData($data, $where); if ($Id == 'update') { sapp_Global::send_configuration_mail("Positions", $position_data[0]['positionname']); $menuidArr = $menumodel->getMenuObjID('/positions'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Position deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Position cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Position cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $actionflag = 3; if ($id) { $departmentsmodel = new Default_Model_Departments(); $checkemployees = $departmentsmodel->checkemployeestodepartment($id); if ($checkemployees == 0) { $data = array('isactive' => 0); $where = array('id=?' => $id); $Id = $departmentsmodel->SaveorUpdateDepartmentsUnits($data, $where); if ($Id == 'update') { $menuID = DEPARTMENTS; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Department deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Department cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Please re-assign the employees to another department'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Department cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $messages['flagtype'] = ''; $weekname = ''; $actionflag = 3; if ($id) { $weekdaysmodel = new Default_Model_Weekdays(); $weekname = $weekdaysmodel->getcombinedweekname($id); $data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $weekdaysmodel->SaveorUpdateWeekdaysdataData($data, $where); if ($Id == 'update') { $menuID = WEEKDAYS; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); if (!empty($weekname)) { $configmail = sapp_Global::send_configuration_mail('Days List', $weekname[0]['week_name']); } $messages['message'] = 'Day deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Day cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Day cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function save($IdentityCodesform, $redirect_flag = '') { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $date = new Zend_Date(); if ($IdentityCodesform->isValid($this->_request->getPost())) { $IdentityCodesModel = new Default_Model_Identitycodes(); $id = $this->_request->getParam('id'); $employeeCode = $this->_request->getParam('employee_code'); $bgAgencyCode = $this->_request->getParam('bg_code'); $vendorCode = $this->_request->getParam('vendor_code'); $staffingCode = $this->_request->getParam('staffing_code'); $users_code = $this->_request->getParam('users_code'); $requisition_code = $this->_request->getParam('requisition_code'); $data = array('employee_code' => $employeeCode, 'backgroundagency_code' => $bgAgencyCode, 'vendor_code' => $vendorCode, 'staffing_code' => $staffingCode, 'users_code' => $users_code, 'requisition_code' => $requisition_code, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); /* Removing the codes which we are not being using for the first phase*/ unset($data['vendor_code']); unset($data['staffing_code']); if (!sapp_Global::_isactivemodule(RESOURCEREQUISITION)) { unset($data['requisition_code']); } if (!sapp_Global::_isactivemodule(BGCHECKS)) { unset($data['backgroundagency_code']); } if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $where = ''; $actionflag = 1; } $Id = $IdentityCodesModel->SaveorUpdateIdentitycodesData($data, $where); if ($Id == 'update') { $tableid = $id; if ($redirect_flag == '') { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Identity codes updated successfully.")); } $smessage = "Identity codes updated successfully."; } else { $tableid = $Id; if ($redirect_flag == '') { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Identity codes added successfully.")); } $smessage = "Identity codes added successfully."; } $menuID = IDENTITYCODES; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); if ($redirect_flag == '') { $this->_redirect('identitycodes'); } else { return array('msg' => $smessage); } } else { $messages = $IdentityCodesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $actionflag = 3; if ($id) { $leaverequestmodel = new Default_Model_Leaverequest(); $data = array('leavestatus' => 4); $where = array('id=?' => $id); $Id = $leaverequestmodel->SaveorUpdateLeaveRequest($data, $where); if ($Id == 'update') { $menuID = PENDINGLEAVES; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Leave request cancelled.'; } else { $messages['message'] = 'Leave request cannot be cancelled.'; } } else { $messages['message'] = 'Leave request cannot be cancelled.'; } $this->_helper->json($messages); }
public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $sess_vals = $auth->getStorage()->read(); $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $messages['message'] = ''; $id = $this->getRequest()->getParam('id', null); $taskModel = new Default_Model_Createtasks(); $currprojectsModel = new Default_Model_Createprojects(); $activityModel = new Default_Model_Createactivities(); $requi_model = new Default_Model_Requisition(); $usersModel = new Default_Model_Users(); $currentUserSummary = $usersModel->getEmployeeSummaryByID($loginUserId); $taskAllocationModel = new Default_Model_Tasksallocation(); $where = ""; $actionflag = 1; $form = new Default_Form_createprojects(); $form->setAttrib('action', DOMAIN . 'createtasks/edit/id/' . $id); //$this->view->activeprojects = $taskModel->getActiveProjects(); $this->view->activeprojects = $taskAllocationModel->getActiveProjectsForTasksForUser($currentUserSummary['businessunit_id'], $loginUserId, $loginuserGroup); $this->view->projectCategories = $taskModel->getProjectCategories(); $this->view->business_units_list = $requi_model->getBusinessUnits(); $this->view->allusers = array(); //$this->view->allusers = $usersModel->getAllActiveUsers(); try { if ($id > 0 && is_numeric($id)) { //update code $where = ""; $actionflag = 2; $id = abs($id); $taskdata = $taskModel->getTaskDataByID($id); $Currprojectdata = $currprojectsModel->getProjectDataByID($taskdata['projectid']); $form->submit->setLabel('Update Task'); $this->view->taskpagerefresh = '0'; $this->view->TaskID = $id; $this->view->loginuserGroup = $loginuserGroup; $this->view->form = $form; $this->view->isEdit = "1"; $this->view->data = $taskdata; $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']); $this->view->TrackingCodes = $currprojectsModel->getTrackingCodesByCategory($Currprojectdata['category']); if ($this->getRequest()->getPost()) { $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Task Details $tprojectSelected = $this->_getParam('projectSelected', null); $ttaskName = $this->_getParam('taskName', null); $ttaskDescription = $this->_getParam('taskDescription', null); $ttaskStartDate = $this->_getParam('taskStartDate', null); $ttaskEndDate = $this->_getParam('taskEndDate', null); $ttaskStatus = $this->_getParam('taskStatus', null); $ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null); $ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null); $ttaskEffort = $this->_getParam('taskEffort', null); //Task Activity Details $tprjactivitytaskid = $this->_getParam('prjactivitytaskid', null); $tprjactivityid = $this->_getParam('prjactivityid', null); $tprjactivitysdate = $this->_getParam('prjactivitysdate', null); $tprjactivityedate = $this->_getParam('prjactivityedate', null); $tprjactivityeffort = $this->_getParam('prjactivityeffort', null); $tprojectStartDate1 = sapp_Global::change_date(trim($ttaskStartDate), 'database'); $tprojectEndDate1 = sapp_Global::change_date(trim($ttaskEndDate), 'database'); $tprojectStartDate2 = sapp_Global::change_date(trim($taskdata['startdate']), 'database'); $tprojectEndDate2 = sapp_Global::change_date(trim($taskdata['enddate']), 'database'); //get tracking codes for edits $ttrackingcodestartdate = $this->_getParam('trackingcodestartdate', null); $ttrackingcodeenddate = $this->_getParam('trackingcodeenddate', null); $ttrackingcodeeffort = $this->_getParam('trackingcodeenddate', null); $mtaskactivitytrackingdata = array('startdate' => implode(',', $ttrackingcodestartdate), 'enddate' => implode(',', $ttrackingcodeenddate), 'effort' => implode(',', $ttrackingcodeeffort)); $this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata; $this->view->taskpagerefresh = '1'; if ($tprojectStartDate2 != $tprojectStartDate1 && ($ttrackingcodestartdate <= 0 || $ttrackingcodestartdate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Start Date.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned Start Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectEndDate2 != $tprojectEndDate1 && ($ttrackingcodeenddate <= 0 || $ttrackingcodeenddate == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned End Date.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned End Date.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($taskdata['effort'] != $ttaskEffort && ($ttrackingcodeeffort <= 0 || $ttrackingcodeeffort == '')) { //$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Effort.")); $validationMsg['message'] = 'Tracking code due to change in Task Planned Effort.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($tprojectSelected <= 0) { $validationMsg['message'] = 'Please select project.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskName)) <= 0) { $validationMsg['message'] = 'Task name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskDescription)) <= 0) { $validationMsg['message'] = 'Task description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskStartDate)) <= 0) { $validationMsg['message'] = 'Task startdate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEndDate)) <= 0) { $validationMsg['message'] = 'Task enddate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEffort)) <= 0) { $validationMsg['message'] = 'Task effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskPrimaryLead <= 0) { $validationMsg['message'] = 'Please select primary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskSecondaryLead <= 0) { $validationMsg['message'] = 'Please select secondary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } } } } if ($bFlag) { $mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $taskModel->SaveorUpdateData($mpolicydata, $where); if ($tprojectStartDate2 != $tprojectStartDate1 || $tprojectEndDate2 != $tprojectEndDate1 || $taskdata['effort'] != $ttaskEffort) { $taskslogModel = new Default_Model_Createtaskslog(); $mprojectlogdata = array('taskid' => trim($taskdata['id']), 'startdatetrackingcodeid' => trim($ttrackingcodestartdate), 'enddatetrackingcodeid' => trim($ttrackingcodeenddate), 'efforttrackingcodeid' => trim($ttrackingcodeeffort), 'effortold' => trim($taskdata['effort']), 'startdateold' => $tprojectStartDate2, 'enddateold' => $tprojectEndDate2, 'effortnew' => $ttaskEffort, 'startdatenew' => $tprojectStartDate1, 'enddatenew' => $tprojectEndDate1, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s")); $where = ""; $Id = $taskslogModel->SaveorUpdateData($mprojectlogdata, $where); } //update Task Activities $currRow = 0; foreach ($tprjactivityid as $tprjactid) { $mactivitydata = array('effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $tprjactivitytaskid[$currRow]); $Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where); $currRow = $currRow + 1; } $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Task details successfully modified.")); $trDb->commit(); $this->_redirect('/createtasks'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createtasks'); } } } else { //Insert code $actionflag = 1; if ($this->getRequest()->getPost()) { #$result = $this->save($form, $policydata); $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $bFlag = true; //Task Details $tprojectSelected = $this->_getParam('projectSelected', null); $ttaskName = $this->_getParam('taskName', null); $ttaskDescription = $this->_getParam('taskDescription', null); $ttaskStartDate = $this->_getParam('taskStartDate', null); $ttaskEndDate = $this->_getParam('taskEndDate', null); $ttaskStatus = $this->_getParam('taskStatus', null); $ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null); $ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null); $ttaskEffort = $this->_getParam('taskEffort', null); //Task Activity Details $tprjactivityid = $this->_getParam('prjactivityid', null); $tprjactivitysdate = $this->_getParam('prjactivitysdate', null); $tprjactivityedate = $this->_getParam('prjactivityedate', null); $tprjactivityeffort = $this->_getParam('prjactivityeffort', null); $tprjactivitysdate1 = implode(',', $tprjactivitysdate); $mtaskactivitytrackingdata = array('startdate' => implode(',', $tprjactivitysdate), 'enddate' => implode(',', $tprjactivityedate), 'effort' => implode(',', $tprjactivityeffort)); $this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata; $this->view->taskpagerefresh = '1'; if ($tprojectSelected <= 0) { $validationMsg['message'] = 'Please select project.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskName)) <= 0) { $validationMsg['message'] = 'Task name cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskDescription)) <= 0) { $validationMsg['message'] = 'Task description cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskStartDate)) <= 0) { $validationMsg['message'] = 'Task startdate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEndDate)) <= 0) { $validationMsg['message'] = 'Task enddate cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if (strlen(trim($ttaskEffort)) <= 0) { $validationMsg['message'] = 'Task effort cannot be empty.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskPrimaryLead <= 0) { $validationMsg['message'] = 'Please select primary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } else { if ($ttaskSecondaryLead <= 0) { $validationMsg['message'] = 'Please select secondary lead.'; $validationMsg['msgtype'] = 'error'; $this->view->validationMsg = $validationMsg; $bFlag = false; } } } } } } } } $mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($bFlag) { $Id = $taskModel->SaveorUpdateData($mpolicydata, $where); if ($Id > 0 && is_numeric($Id)) { //Insert Task Activities $currRow = 0; foreach ($tprjactivityid as $tprjactid) { $mactivitydata = array('taskid' => trim($Id), 'activityid' => trim($tprjactid), 'status' => trim($ttaskStatus), 'effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s")); $currRow = $currRow + 1; $Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where); } $menuID = -999; sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully added.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding project details.")); } $trDb->commit(); $this->_redirect('/createtasks'); } } catch (Exception $e) { $trDb->rollBack(); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later.")); $this->_redirect('/createtasks'); } } if ($tprojectSelected > 0) { $Currprojectdata = $currprojectsModel->getProjectDataByID($tprojectSelected); $this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']); } $form->submit->setLabel('Add Task'); $this->view->loginuserGroup = $loginuserGroup; $this->view->TaskID = "0"; $this->view->form = $form; $this->view->isEdit = "0"; $this->view->data = $mpolicydata; } } catch (Exception $e) { $this->view->nodata = 'nodata'; } }
public function save($workeligibilityform) { $result = ""; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $date = new Zend_Date(); $workeligibilitydoctypesmodel = new Default_Model_Workeligibilitydoctypes(); $documenttype_id = $this->_request->getParam('documenttype_id'); if ($documenttype_id != '') { $issuingauthorityArr = $workeligibilitydoctypesmodel->getIssuingAuthority($documenttype_id); } if (!empty($issuingauthorityArr)) { $issuingauthority = $issuingauthorityArr[0]['issuingauthority']; if ($issuingauthority == 2) { $workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select state.'); $workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select state.')); } else { if ($issuingauthority == 3) { $workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select state.'); $workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select state.')); $workeligibilityform->issuingauth_city->setRequired(true)->addErrorMessage('Please select city.'); $workeligibilityform->issuingauth_city->addValidator('NotEmpty', false, array('messages' => 'Please select city.')); } } } if ($workeligibilityform->isValid($this->_request->getPost())) { $post_values = $this->_request->getPost(); if (isset($post_values['id'])) { unset($post_values['id']); } if (isset($post_values['user_id'])) { unset($post_values['user_id']); } if (isset($post_values['submit'])) { unset($post_values['submit']); } $new_post_values = array_filter($post_values); $user_id = $this->_request->getParam('userid'); if (!empty($new_post_values)) { $workeligibilityModel = new Default_Model_Workeligibilitydetails(); $id = $this->_request->getParam('id'); $doc_issue_date = $this->_request->getParam('doc_issue_date', null); $doc_expiry_date = $this->_request->getParam('doc_expiry_date', null); $issuingauth_name = $this->_request->getParam('issuingauth_name'); $issuingauth_country = $this->_request->getParam('issuingauth_country'); $issuingauth_state = $this->_request->getParam('issuingauth_state'); $issuingauth_city = $this->_request->getParam('issuingauth_city'); $issuingauth_postalcode = $this->_request->getParam('issuingauth_postalcode'); $docissueDate = sapp_Global::change_date($doc_issue_date, 'database'); $docexpiryDate = sapp_Global::change_date($doc_expiry_date, 'database'); $data = array('documenttype_id' => $documenttype_id, 'doc_issue_date' => $docissueDate, 'doc_expiry_date' => $docexpiryDate, 'issuingauth_name' => $issuingauth_name, 'issuingauth_country' => $issuingauth_country, 'issuingauth_state' => $issuingauth_state, 'issuingauth_city' => $issuingauth_city, 'issuingauth_postalcode' => $issuingauth_postalcode, 'user_id' => $user_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $where = ''; $actionflag = 1; } $Id = $workeligibilityModel->SaveorUpdateWorkEligibilityDetails($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee work eligibility details updated successfully.")); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee work eligibility details added successfully.")); } $menuID = EMPLOYEE; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG)); } $this->_redirect('workeligibilitydetails/edit/userid/' . $user_id); } else { $messages = $workeligibilityform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } if ($this->_request->getPost()) { $issuingauth_country = $this->_request->getParam('issuingauth_country'); $issuingauth_state = $this->_request->getParam('issuingauth_state'); $stateArr = explode("!@#", $issuingauth_state); $stateStr = $stateArr[0]; $issuingauth_city = $this->_request->getParam('issuingauth_city'); $cityArr = explode("!@#", $issuingauth_city); $cityStr = $cityArr[0]; } else { $issuingauth_country = ''; $issuingauth_state = ''; $issuingauth_city = ''; } if (isset($issuingauth_country) && $issuingauth_country != 0 && $issuingauth_country != '') { $statesmodel = new Default_Model_States(); $statesmodeldata = $statesmodel->getStatesList($issuingauth_country); $workeligibilityform->issuingauth_state->addMultiOption('', 'Select State'); foreach ($statesmodeldata as $res) { $workeligibilityform->issuingauth_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name'])); } if (isset($issuingauth_state) && $issuingauth_state != 0 && $issuingauth_state != '') { $workeligibilityform->setDefault('issuingauth_state', $issuingauth_state); } } if (isset($issuingauth_state) && $issuingauth_state != 0 && $issuingauth_state != '') { $citiesmodel = new Default_Model_Cities(); $citiesmodeldata = $citiesmodel->getCitiesList($stateStr); $workeligibilityform->issuingauth_city->addMultiOption('', 'Select City'); foreach ($citiesmodeldata as $res) { $workeligibilityform->issuingauth_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name'])); } if (isset($issuingauth_city) && $issuingauth_city != 0 && $issuingauth_city != '') { $workeligibilityform->setDefault('issuingauth_city', $issuingauth_city); } } return $msgarray; } }
public function multipleresumeAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserId = trim($loginUserId); } $priv_check = sapp_Global::_checkprivileges(CANDIDATEDETAILS, '', $auth->getStorage()->read()->emprole, 'add'); if ($priv_check == 'Yes') { $msgarray = $req_options = array(); $form = new Default_Form_Multipleresume(); $form->setAction(DOMAIN . 'candidatedetails/multipleresume'); // To show list of requisitions to user $req_model = new Default_Model_Requisition(); $req_data = $req_model->getRequisitionsForCV("'Approved','In process'"); foreach ($req_data as $req) { $req_options[$req['id']] = $req['requisition_code'] . ' - ' . $req['jobtitlename']; } if (count($req_options) == 0) { $msgarray['requisition_id'] = "No active requisitions are found."; } $form->requisition_id->addMultiOptions(array('' => 'Select Requisition ID') + $req_options); $form_post_status = $this->_request->getPost(); if ($form_post_status) { $candidate_firstname = $this->_getParam('candidate_firstname', null); $candidate_lastname = $this->_getParam('candidate_lastname', null); $cand_resumes = $this->_getParam('cand_resume', null); if ($form->isValid($form_post_status)) { $cand_details_model = new Default_Model_Candidatedetails(); $requisition_id = $this->_getParam('requisition_id', null); $cand_status = $this->_getParam('cand_status', null); $req_records = $cand_details_model->getcountofrecords($requisition_id); $curr_date = gmdate("Y-m-d H:i:s"); if (empty($req_records)) { $rdata = array('req_status' => 'In process', 'modifiedby' => $loginUserId, 'modifiedon' => $curr_date); $rwhere = ' id = ' . $requisition_id; $req_model->SaveorUpdateRequisitionData($rdata, $rwhere); } // To insert records in a single query $records = array(); foreach ($candidate_firstname as $key => $candidate_fname) { $cfull_name = $candidate_fname . ' ' . $candidate_lastname[$key]; $records[] = "({$requisition_id}, '{$candidate_fname}','{$candidate_lastname[$key]}','{$cfull_name}', '{$cand_resumes[$key]}', '{$cand_status}', 1, {$loginUserId}, {$loginUserId}, '{$curr_date}', '{$curr_date}')"; } $data_fields = array('requisition_id', 'candidate_firstname', 'candidate_lastname', 'candidate_name', 'cand_resume', 'cand_status', 'isactive', 'createdby', 'modifiedby', 'createddate', 'modifieddate'); $last_insert_id = $cand_details_model->insertMultipleRecords($data_fields, $records); // Log status to Log manager and redirect to Resource Pooling list page. if ($last_insert_id != '') { $menumodel = new Default_Model_Menu(); $objidArr = $menumodel->getMenuObjID('/candidatedetails'); $objID = $objidArr[0]['id']; $log_status = sapp_Global::logManager($objID, 1, $loginUserId, $last_insert_id); //$this->_helper->FlashMessenger()->setNamespace('success')->addMessage('Candidate details added successfully.'); $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Candidate details added successfully.")); $this->_redirect('/candidatedetails'); } } else { // To handle server validation, when Javascript is disabled $messages = $form->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } $form->setDefault('candidate_firstname', $candidate_firstname[0]); $form->setDefault('cand_resume', ''); } } $this->view->form = $form; $this->view->msgarray = $msgarray; } else { $this->_redirect('error'); } }
public function save($empsalarydetailsform, $userid) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } if ($empsalarydetailsform->isValid($this->_request->getPost())) { $empsalarydetailsModal = new Default_Model_Empsalarydetails(); $id = $this->_request->getParam('id'); $user_id = $userid; $currencyid = $this->_request->getParam('currencyid'); $salarytype = $this->_request->getParam('salarytype'); $salary = $this->_request->getParam('salary'); $bankname = trim($this->_request->getParam('bankname')); $accountholder_name = trim($this->_request->getParam('accountholder_name')); $accountclasstypeid = $this->_request->getParam('accountclasstypeid'); $bankaccountid = $this->_request->getParam('bankaccountid'); $accountnumber = trim($this->_request->getParam('accountnumber')); $accountholding = $this->_request->getParam('accountholding'); $accountholding = sapp_Global::change_date($accountholding, 'database'); $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('user_id' => $user_id, 'currencyid' => $currencyid, 'salarytype' => $salarytype, 'salary' => $salary, 'bankname' => $bankname != '' ? $bankname : NULL, 'accountholder_name' => $accountholder_name != '' ? $accountholder_name : NULL, 'accountclasstypeid' => $accountclasstypeid != '' ? $accountclasstypeid : NULL, 'bankaccountid' => $bankaccountid != '' ? $bankaccountid : NULL, 'accountnumber' => $accountnumber != '' ? $accountnumber : NULL, 'accountholding' => $accountholding != '' ? $accountholding : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $empsalarydetailsModal->SaveorUpdateEmpSalaryData($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details updated successfully.")); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); $this->_redirect('empsalarydetails/edit/userid/' . $user_id); } else { $messages = $empsalarydetailsform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
public function updateAction() { $empDocuModel = new Default_Model_Employeedocs(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('doc_id'); $name = $this->_request->getParam('doc_name'); $userid = $this->_request->getParam('userid'); // Get attachments $file_original_names = $this->getRequest()->getParam('file_original_names'); $file_new_names = $this->getRequest()->getParam('file_new_names'); $org_names = explode(',', $file_original_names); $new_names = explode(',', $file_new_names); $attachment_array = array(); for ($i = 0; $i < count($org_names); $i++) { if ($new_names[$i] != '') { $attachment_array[] = array("original_name" => $org_names[$i], "new_name" => $new_names[$i]); } } $data = array('name' => $name, 'attachments' => count($attachment_array) > 0 ? json_encode($attachment_array) : null, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); // Validate duplicate document name $empDocuments = $empDocuModel->checkDocNameByUserIdAndDocId($userid, $name, $id); $count_emp_docs = count($empDocuments); if ($count_emp_docs == 0) { $where = array('id=?' => $id); $actionflag = 2; $recordId = $empDocuModel->SaveorUpdateEmpDocuments($data, $where); $menumodel = new Default_Model_Menu(); $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $userid); $this->_helper->json(array('result' => 'success')); } else { if ($count_emp_docs > 0) { $this->_helper->json(array('result' => 'exists')); } else { $this->_helper->json(array('result' => 'error')); } } }
public function save($creditcardDetailsform) { $result = ""; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $date = new Zend_Date(); if ($creditcardDetailsform->isValid($this->_request->getPost())) { $post_values = $this->_request->getPost(); if (isset($post_values['id'])) { unset($post_values['id']); } if (isset($post_values['user_id'])) { unset($post_values['user_id']); } if (isset($post_values['submit'])) { unset($post_values['submit']); } $new_post_values = array_filter($post_values); $user_id = $this->_request->getParam('userid'); if (!empty($new_post_values)) { $creditcardDetailsModel = new Default_Model_Creditcarddetails(); $id = $this->_request->getParam('id'); $card_type = $this->_request->getParam('card_type'); $card_number = $this->_request->getParam('card_number'); $card_name = $this->_request->getParam('nameoncard'); $card_expiry_1 = $this->_request->getParam('card_expiration', null); $card_expiry = sapp_Global::change_date($card_expiry_1, 'database'); $card_issuedBy = $this->_request->getParam('card_issuedby'); $card_code = $this->_request->getParam('card_code'); $data = array('card_type' => $card_type, 'card_number' => $card_number, 'nameoncard' => $card_name, 'card_expiration' => $card_expiry, 'card_issued_comp' => $card_issuedBy, 'card_code' => $card_code, 'user_id' => $user_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $where = ''; $actionflag = 1; } $Id = $creditcardDetailsModel->SaveorUpdateCreditcardDetails($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details updated successfully.")); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details added successfully.")); } $menumodel = new Default_Model_Menu(); $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG)); } $this->_redirect('creditcarddetails/edit/userid/' . $user_id); } else { $messages = $creditcardDetailsform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $actionflag = 3; if ($id) { $assignmententryreasoncodemodel = new Default_Model_Assignmententryreasoncode(); $data = array('isactive' => 0); $where = array('id=?' => $id); $Id = $assignmententryreasoncodemodel->SaveorUpdateAssignmentEntryData($data, $where); if ($Id == 'update') { $menuID = ASSIGNMENTENTRYREASONCODE; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Assignment entry reason code deleted successfully.'; } else { $messages['message'] = 'Assignment entry reason code cannot be deleted.'; } } else { $messages['message'] = 'Assignment entry reason code cannot be deleted.'; } $this->_helper->json($messages); }
public function addnewstateAction() { Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $msgarray = array(); $controllername = 'states'; $statestring = ''; $id = $this->getRequest()->getParam('id'); $selectedcountryid = $this->_request->getParam('selectcountryid', null); $statesform = new Default_Form_states(); $statesmodel = new Default_Model_States(); $countriesModel = new Default_Model_Countries(); /* Changing the form */ $statesform->setAction(BASE_URL . 'states/addnewstate/selectcountryid/' . $selectedcountryid); $statesform->removeElement('state'); $statesform->addElement('text', 'state', array('label' => 'State', 'maxlength' => '20', 'required' => true, 'validators' => array(array('validator' => 'NotEmpty', 'options' => array('messages' => 'Please enter state name.'))))); /* END */ $countrieslistArr = $countriesModel->getTotalCountriesList(''); if (sizeof($countrieslistArr) > 0) { $statesform->countryid->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { if (isset($selectedcountryid)) { if ($countrieslistres['id'] == $selectedcountryid) { $statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); $statesform->setDefault('countryid', $selectedcountryid); } } else { $statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); } } } else { $msgarray['countryid'] = 'Countries are not configured yet'; } if ($this->getRequest()->getPost()) { $errorflag = "true"; $msgarray = array(); $id = $this->_request->getParam('id'); $dbstate = ''; $dbcountryid = ''; $state = trim($this->_request->getParam('state')); $countryid = $this->_request->getParam('countryid'); if (isset($countryid) && $countryid != '') { $isDuplicateStateNameArr = $statesmodel->getDuplicateStateName($state, $countryid); if ($isDuplicateStateNameArr[0]['count'] > 0) { $errorflag = "false"; $msgarray['state'] = "State already exists."; } } else { $errorflag = "false"; $msgarray['countryid'] = "Please select country."; } if ($statesform->isValid($this->_request->getPost()) && $errorflag == "true") { $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $NewStateId = $statesmodel->SaveMainStateData($countryid, $state); $tableid = $NewStateId; $actionflag = 1; $menuidArr = $menumodel->getMenuObjID('/states'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); if (isset($selectedcountryid)) { $stateData = $statesmodel->getStatesList($selectedcountryid, ''); } else { $stateData = array(); } $opt = ''; foreach ($stateData as $record) { $opt .= sapp_Global::selectOptionBuilder($record['id'], $record['state_name']); } $this->view->stateData = $opt; $this->view->eventact = 'added'; $close = 'close'; $this->view->popup = $close; } else { $messages = $statesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } } } $this->view->ermsg = ''; $this->view->form = $statesform; $this->view->msgarray = $msgarray; $this->view->controllername = $controllername; }