public function comviewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('empcommunicationdetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); $empdata = array(); $empDeptdata = array(); $empDept = ''; if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); if ($id == '') { $id = $loginUserId; } $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'empcommunicationdetails'; $empcommdetailsform = new Default_Form_empcommunicationdetails(); $empcommdetailsform->removeElement("submit"); $elements = $empcommdetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } try { if ($id) { $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $empDept = $empdata[0]['department_id']; $empcommdetailsModal = new Default_Model_Empcommunicationdetails(); $usersModel = new Default_Model_Users(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $orgInfoModel = new Default_Model_Organisationinfo(); $msgarray = array(); $deptModel = new Default_Model_Departments(); if ($empDept != '' && $empDept != 'NULL') { $departmentAddress = $usersModel->getDepartmentAddress($empDept); } else { $departmentAddress = $usersModel->getOrganizationAddress($empDept); } $data = $empcommdetailsModal->getsingleEmpCommDetailsData($id); if (!empty($data)) { if ($data[0]['perm_country'] != '') { $countrieslistArr = $countriesModel->getCountryCode($data[0]['perm_country']); if (sizeof($countrieslistArr) > 0) { $empcommdetailsform->perm_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $empcommdetailsform->perm_country->addMultiOption($countrieslistres['id'], $countrieslistres['country_name']); } } } if ($data[0]['perm_country'] != '') { $statePermlistArr = $statesmodel->getStatesList($data[0]['perm_country']); if (sizeof($statePermlistArr) > 0) { $empcommdetailsform->perm_state->addMultiOption('', 'Select State'); foreach ($statePermlistArr as $statelistres) { $empcommdetailsform->perm_state->addMultiOption($statelistres['id'] . '!@#' . $statelistres['state_name'], $statelistres['state_name']); } } } if ($data[0]['perm_state'] != '') { $cityPermlistArr = $citiesmodel->getCitiesList($data[0]['perm_state']); if (sizeof($cityPermlistArr) > 0) { $empcommdetailsform->perm_city->addMultiOption('', 'Select City'); foreach ($cityPermlistArr as $cityPermlistres) { $empcommdetailsform->perm_city->addMultiOption($cityPermlistres['id'] . '!@#' . $cityPermlistres['city_name'], $cityPermlistres['city_name']); } } } if ($data[0]['current_country'] != '' && $data[0]['current_state'] != '') { $countriesArr = $countriesModel->getCountryCode($data[0]['current_country']); if (sizeof($countriesArr) > 0) { $empcommdetailsform->current_country->addMultiOption('', 'Select Country'); foreach ($countriesArr as $countrieslistres) { $empcommdetailsform->current_country->addMultiOption($countrieslistres['id'], $countrieslistres['country_name']); } } $statecurrlistArr = $statesmodel->getStatesList($data[0]['current_country']); if (sizeof($statecurrlistArr) > 0) { $empcommdetailsform->current_state->addMultiOption('', 'Select State'); foreach ($statecurrlistArr as $statecurrlistres) { $empcommdetailsform->current_state->addMultiOption($statecurrlistres['id'] . '!@#' . $statecurrlistres['state_name'], $statecurrlistres['state_name']); } } $currstateNameArr = $statesmodel->getStateName($data[0]['current_state']); } if ($data[0]['current_country'] != '' && $data[0]['current_state'] != '' && $data[0]['current_city'] != '') { $cityCurrlistArr = $citiesmodel->getCitiesList($data[0]['current_state']); if (sizeof($cityCurrlistArr) > 0) { $empcommdetailsform->current_city->addMultiOption('', 'Select State'); foreach ($cityCurrlistArr as $cityCurrlistres) { $empcommdetailsform->current_city->addMultiOption($cityCurrlistres['id'] . '!@#' . $cityCurrlistres['city_name'], $cityCurrlistres['city_name']); } } $currcityNameArr = $citiesmodel->getCityName($data[0]['current_city']); } $empcommdetailsform->populate($data[0]); if ($data[0]['perm_state'] != '') { $permstateNameArr = $statesmodel->getStateName($data[0]['perm_state']); $empcommdetailsform->setDefault('perm_state', $permstateNameArr[0]['id'] . '!@#' . $permstateNameArr[0]['statename']); } if ($data[0]['perm_city'] != '') { $permcityNameArr = $citiesmodel->getCityName($data[0]['perm_city']); $empcommdetailsform->setDefault('perm_city', $permcityNameArr[0]['id'] . '!@#' . $permcityNameArr[0]['cityname']); } if ($data[0]['perm_country'] != '') { $empcommdetailsform->setDefault('perm_country', $data[0]['perm_country']); } if ($data[0]['current_country'] != '') { $empcommdetailsform->setDefault('current_country', $data[0]['current_country']); } if ($data[0]['current_state'] != '') { $empcommdetailsform->setDefault('current_state', $currstateNameArr[0]['id'] . '!@#' . $currstateNameArr[0]['statename']); } if ($data[0]['current_city'] != '') { $empcommdetailsform->setDefault('current_city', $currcityNameArr[0]['id'] . '!@#' . $currcityNameArr[0]['cityname']); } } $this->view->controllername = $objName; $this->view->data = $data; $this->view->dataArray = $departmentAddress; $this->view->id = $id; $this->view->employeedata = $empdata[0]; $this->view->form = $empcommdetailsform; } $this->view->empdata = $empdata; } } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction_27092013() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'empcommunicationdetails'; $empcommdetailsform = new Default_Form_empcommunicationdetails(); $empcommdetailsform->removeElement("submit"); $elements = $empcommdetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } try { if ($id) { $employeeModal = new Default_Model_Employee(); $isrowexist = $employeeModal->getsingleEmployeeData($id); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($id); if (!empty($empdata)) { //TO get the Employee profile information.... $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($id); $empcommdetailsModal = new Default_Model_Empcommunicationdetails(); $usersModel = new Default_Model_Users(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $orgInfoModel = new Default_Model_Organisationinfo(); $msgarray = array(); $orgid = 1; $orgdata = $orgInfoModel->getOrganisationData($orgid); $countryId = $orgdata['country']; $stateId = $orgdata['state']; $cityId = $orgdata['city']; if ($countryId != '') { $countryData = $countriesModel->getActiveCountryName($countryId); $orgdata['country'] = $countryData[0]['country']; } if ($stateId != '') { $stateData = $statesmodel->getStateNameData($stateId); $orgdata['state'] = $stateData[0]['state']; } if ($cityId != '') { $citiesData = $citiesmodel->getCitiesNameData($cityId); $orgdata['city'] = $citiesData[0]['city']; } $countrieslistArr = $countriesModel->getActiveCountriesList(); if (sizeof($countrieslistArr) > 0) { $empcommdetailsform->perm_country->addMultiOption('', 'Select Country'); $empcommdetailsform->current_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $empcommdetailsform->perm_country->addMultiOption($countrieslistres['country_id_org'], $countrieslistres['country']); $empcommdetailsform->current_country->addMultiOption($countrieslistres['country_id_org'], $countrieslistres['country']); } } else { $msgarray['perm_country'] = 'Countries are not configured yet.'; $msgarray['current_country'] = 'Countries are not configured yet.'; } $data = $empcommdetailsModal->getsingleEmpCommDetailsData($id); if (!empty($data)) { $statePermlistArr = $statesmodel->getStatesList($data[0]['perm_country']); if (sizeof($statePermlistArr) > 0) { $empcommdetailsform->perm_state->addMultiOption('', 'Select State'); foreach ($statePermlistArr as $statelistres) { $empcommdetailsform->perm_state->addMultiOption($statelistres['id'] . '!@#' . $statelistres['state_name'], $statelistres['state_name']); } } $cityPermlistArr = $citiesmodel->getCitiesList($data[0]['perm_state']); if (sizeof($cityPermlistArr) > 0) { $empcommdetailsform->perm_city->addMultiOption('', 'Select City'); foreach ($cityPermlistArr as $cityPermlistres) { $empcommdetailsform->perm_city->addMultiOption($cityPermlistres['id'] . '!@#' . $cityPermlistres['city_name'], $cityPermlistres['city_name']); } } if ($data[0]['current_country'] != '' && $data[0]['current_state'] != '') { $statecurrlistArr = $statesmodel->getStatesList($data[0]['current_country']); if (sizeof($statecurrlistArr) > 0) { $empcommdetailsform->current_state->addMultiOption('', 'Select State'); foreach ($statecurrlistArr as $statecurrlistres) { $empcommdetailsform->current_state->addMultiOption($statecurrlistres['id'] . '!@#' . $statecurrlistres['state_name'], $statecurrlistres['state_name']); } } $currstateNameArr = $statesmodel->getStateName($data[0]['current_state']); } if ($data[0]['current_country'] != '' && $data[0]['current_state'] != '' && $data[0]['current_city'] != '') { $cityCurrlistArr = $citiesmodel->getCitiesList($data[0]['current_state']); if (sizeof($cityCurrlistArr) > 0) { $empcommdetailsform->current_city->addMultiOption('', 'Select State'); foreach ($cityCurrlistArr as $cityCurrlistres) { $empcommdetailsform->current_city->addMultiOption($cityCurrlistres['id'] . '!@#' . $cityCurrlistres['city_name'], $cityCurrlistres['city_name']); } } $currcityNameArr = $citiesmodel->getCityName($data[0]['current_city']); } $permstateNameArr = $statesmodel->getStateName($data[0]['perm_state']); $permcityNameArr = $citiesmodel->getCityName($data[0]['perm_city']); $empcommdetailsform->populate($data[0]); $empcommdetailsform->setDefault('perm_country', $data[0]['perm_country']); $empcommdetailsform->setDefault('perm_state', $permstateNameArr[0]['id'] . '!@#' . $permstateNameArr[0]['statename']); $empcommdetailsform->setDefault('perm_city', $permcityNameArr[0]['id'] . '!@#' . $permcityNameArr[0]['cityname']); if ($data[0]['current_country'] != '') { $empcommdetailsform->setDefault('current_country', $data[0]['current_country']); } if ($data[0]['current_state'] != '') { $empcommdetailsform->setDefault('current_state', $currstateNameArr[0]['id'] . '!@#' . $currstateNameArr[0]['statename']); } if ($data[0]['current_city'] != '') { $empcommdetailsform->setDefault('current_city', $currcityNameArr[0]['id'] . '!@#' . $currcityNameArr[0]['cityname']); } } $this->view->controllername = $objName; $this->view->data = $data; $this->view->dataArray = $orgdata; $this->view->id = $id; $this->view->employeedata = $employeeData[0]; $this->view->form = $empcommdetailsform; } $this->view->empdata = $empdata; } } catch (Exception $e) { $this->view->rowexist = "norows"; } }
public function workeligibilityAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('workeligibilitydetails', $empOrganizationTabs)) { $tabName = "workeligibility"; $employeeData = array(); $msgarray = array(); $emptyFlag = 0; $issuingauthority = ''; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $userid = $loginUserId; $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getsingleEmployeeData($userid); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $workeligibilityform = new Default_Form_Workeligibilitydetails(); $workeligibilityModel = new Default_Model_Workeligibilitydetails(); $workeligibilityDoctypesModal = new Default_Model_Workeligibilitydoctypes(); //fetchAll($where = null, $order = null, $count = null, $offset = null) function syntax... $workeligibilityDoctypesData = $workeligibilityDoctypesModal->fetchAll('isactive=1', 'documenttype'); $workeligibilityDoctypesDataArr = $workeligibilityDoctypesData->toArray(); if (!empty($workeligibilityDoctypesDataArr)) { foreach ($workeligibilityDoctypesDataArr as $data) { $workeligibilityform->documenttype_id->addMultiOption($data['id'], $data['documenttype']); } } else { $msgarray['documenttype_id'] = 'Work eligibility document types are not configured yet.'; $emptyFlag++; } if ($userid) { $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $countrieslistArr = $countriesModel->getTotalCountriesList(); if (sizeof($countrieslistArr) > 0) { $workeligibilityform->issuingauth_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $workeligibilityform->issuingauth_country->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); } } else { $msgarray['issuingauth_country'] = 'Countries are not configured yet.'; $emptyFlag++; } $data = $workeligibilityModel->getWorkEligibilityRecord($userid); if (!empty($data) && isset($data)) { $countryId = $data[0]['issuingauth_country']; $stateId = $data[0]['issuingauth_state']; $cityId = $data[0]['issuingauth_city']; $documenttype_id = $data[0]['documenttype_id']; //Populating states & cities Drop down......... from tbl_states & tbl_cities if ($countryId != '') { $statelistArr = $statesmodel->getStatesList($countryId); if (sizeof($statelistArr) > 0) { $workeligibilityform->issuingauth_state->addMultiOption('', 'Select State'); foreach ($statelistArr as $statelistres) { $workeligibilityform->issuingauth_state->addMultiOption($statelistres['id'] . '!@#' . $statelistres['state_name'], $statelistres['state_name']); } } } if ($stateId != '') { $citylistArr = $citiesmodel->getCitiesList($stateId); if (sizeof($citylistArr) > 0) { $workeligibilityform->issuingauth_city->addMultiOption('', 'Select City'); foreach ($citylistArr as $cityPermlistres) { $workeligibilityform->issuingauth_city->addMultiOption($cityPermlistres['id'] . '!@#' . $cityPermlistres['city_name'], $cityPermlistres['city_name']); } } $stateNameArr = $statesmodel->getStateName($stateId); } if ($cityId != '') { $cityNameArr = $citiesmodel->getCityName($cityId); } if ($documenttype_id != '') { $issuingauthorityArr = $workeligibilityDoctypesModal->getIssuingAuthority($documenttype_id); } if (!empty($issuingauthorityArr)) { $issuingauthority = $issuingauthorityArr[0]['issuingauthority']; $workeligibilityform->issuingauthflag->setValue($issuingauthority); } $workeligibilityform->setDefault("id", $data[0]["id"]); $workeligibilityform->setDefault("user_id", $data[0]["user_id"]); $workeligibilityform->setDefault('issuingauth_country', $data[0]['issuingauth_country']); if (!empty($stateNameArr)) { $workeligibilityform->setDefault('issuingauth_state', $stateNameArr[0]['id'] . '!@#' . $stateNameArr[0]['statename']); } if (!empty($cityNameArr)) { $workeligibilityform->setDefault('issuingauth_city', $cityNameArr[0]['id'] . '!@#' . $cityNameArr[0]['cityname']); } $workeligibilityform->setDefault("documenttype_id", $data[0]["documenttype_id"]); $workeligibilityform->setDefault("issuingauth_name", $data[0]["issuingauth_name"]); $workeligibilityform->setDefault("issuingauth_postalcode", $data[0]["issuingauth_postalcode"]); $issue_date = sapp_Global::change_date($data[0]["doc_issue_date"], 'view'); $workeligibilityform->setDefault('doc_issue_date', $issue_date); $expiry_date = sapp_Global::change_date($data[0]["doc_expiry_date"], 'view'); $workeligibilityform->setDefault('doc_expiry_date', $expiry_date); } $workeligibilityform->setAttrib('action', DOMAIN . 'mydetails/workeligibility'); $this->view->id = $userid; $this->view->data = $data; $this->view->form = $workeligibilityform; $this->view->issuingauthority = $issuingauthority; $this->view->msgarray = $msgarray; } if ($this->getRequest()->getPost()) { $documenttype_id = $this->_request->getParam('documenttype_id'); if ($documenttype_id != '') { $issuingauthorityArr = $workeligibilityDoctypesModal->getIssuingAuthority($documenttype_id); } if (!empty($issuingauthorityArr)) { $issuingauthority = $issuingauthorityArr[0]['issuingauthority']; if ($issuingauthority == 2) { $workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select a state.'); $workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select a state.')); } else { if ($issuingauthority == 3) { $workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select a state.'); $workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select a state.')); $workeligibilityform->issuingauth_city->setRequired(true)->addErrorMessage('Please select a city.'); $workeligibilityform->issuingauth_city->addValidator('NotEmpty', false, array('messages' => 'Please select a city.')); } } } $result = $this->save($workeligibilityform, $tabName); $result['issuingauthorityflag'] = $_POST['issuingauthflag']; $this->view->msgarray = $result; } } $this->view->empdata = $empdata; $this->view->emptyFlag = $emptyFlag; $this->view->messages = $this->_helper->flashMessenger->getMessages(); } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('workeligibilitydetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $employeeData = array(); $id = $this->getRequest()->getParam('userid'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'workeligibilitydetails'; $issuingauthority = ''; $employeeModal = new Default_Model_Employee(); $workeligibilityform = new Default_Form_Workeligibilitydetails(); $workeligibilityform->removeElement("submit"); $elements = $workeligibilityform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $usersModel = new Default_Model_Users(); $empdata = $employeeModal->getActiveEmployeeData($id); $employeeData = $usersModel->getUserDetailsByIDandFlag($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $workeligibilityModel = new Default_Model_Workeligibilitydetails(); if ($id) { $usersModel = new Default_Model_Users(); $workeligibilityDoctypesModal = new Default_Model_Workeligibilitydoctypes(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $countrieslistArr = $countriesModel->getTotalCountriesList(); if (sizeof($countrieslistArr) > 0) { $workeligibilityform->issuingauth_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $workeligibilityform->issuingauth_country->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); } } else { $msgarray['issuingauth_country'] = 'Countries are not configured yet.'; } $data = $workeligibilityModel->getWorkEligibilityRecord($id); if (!empty($data) && isset($data)) { $countryId = $data[0]['issuingauth_country']; $stateId = $data[0]['issuingauth_state']; $cityId = $data[0]['issuingauth_city']; $documenttype_id = $data[0]['documenttype_id']; if ($countryId != '') { $statelistArr = $statesmodel->getStatesList($countryId); if (sizeof($statelistArr) > 0) { $workeligibilityform->issuingauth_state->addMultiOption('', 'Select State'); foreach ($statelistArr as $statelistres) { $workeligibilityform->issuingauth_state->addMultiOption($statelistres['id'] . '!@#' . $statelistres['state_name'], $statelistres['state_name']); } } } if ($stateId != '') { $citylistArr = $citiesmodel->getCitiesList($stateId); if (sizeof($citylistArr) > 0) { $workeligibilityform->issuingauth_city->addMultiOption('', 'Select City'); foreach ($citylistArr as $cityPermlistres) { $workeligibilityform->issuingauth_city->addMultiOption($cityPermlistres['id'] . '!@#' . $cityPermlistres['city_name'], $cityPermlistres['city_name']); } } $stateNameArr = $statesmodel->getStateName($stateId); } if ($cityId != '') { $cityNameArr = $citiesmodel->getCityName($cityId); } if ($documenttype_id != '') { $issuingauthorityArr = $workeligibilityDoctypesModal->getIssuingAuthority($documenttype_id); } if (!empty($issuingauthorityArr)) { $issuingauthority = $issuingauthorityArr[0]['issuingauthority']; $workeligibilityform->issuingauthflag->setValue($issuingauthority); $workeligibilityform->documenttype_id->addMultiOption($issuingauthorityArr[0]['id'], $issuingauthorityArr[0]['documenttype']); } $workeligibilityform->setDefault("id", $data[0]["id"]); $workeligibilityform->setDefault("user_id", $data[0]["user_id"]); $workeligibilityform->setDefault('issuingauth_country', $data[0]['issuingauth_country']); if (!empty($stateNameArr)) { $workeligibilityform->setDefault('issuingauth_state', $stateNameArr[0]['id'] . '!@#' . $stateNameArr[0]['statename']); } if (!empty($cityNameArr)) { $workeligibilityform->setDefault('issuingauth_city', $cityNameArr[0]['id'] . '!@#' . $cityNameArr[0]['cityname']); } $workeligibilityform->setDefault("documenttype_id", $data[0]["documenttype_id"]); $workeligibilityform->setDefault("issuingauth_name", $data[0]["issuingauth_name"]); $workeligibilityform->setDefault("issuingauth_postalcode", $data[0]["issuingauth_postalcode"]); $issue_date = date(DATEFORMAT_PHP, strtotime($data[0]["doc_issue_date"])); $workeligibilityform->setDefault('doc_issue_date', $issue_date); $expiry_date = date(DATEFORMAT_PHP, strtotime($data[0]["doc_expiry_date"])); $workeligibilityform->setDefault('doc_expiry_date', $expiry_date); } $this->view->controllername = $objName; $this->view->id = $id; $this->view->data = $data; $this->view->employeedata = $employeeData[0]; $this->view->form = $workeligibilityform; $this->view->issuingauthority = $issuingauthority; } } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function editAction() { $auth = Zend_Auth::getInstance(); $popConfigPermission = array(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $id = $this->getRequest()->getParam('id'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } if (sapp_Global::_checkprivileges(COUNTRIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'country'); } if (sapp_Global::_checkprivileges(STATES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'state'); } $citiesform = new Default_Form_cities(); $citiesmodel = new Default_Model_Cities(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $msgarray = array(); $countrieslistArr = $countriesModel->getActiveCountriesList(); if (sizeof($countrieslistArr) > 0) { $citiesform->countryid->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $citiesform->countryid->addMultiOption($countrieslistres['country_id_org'], $countrieslistres['country']); } } else { $msgarray['countryid'] = 'Countries are not configured yet.'; } $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } try { if ($id) { $data = $citiesmodel->getCitiesDataByID($id); if (!empty($data)) { $statesmodel = new Default_Model_States(); $statesmodeldata = $statesmodel->getStatesList($data[0]['countryid']); $statenameArr = $statesmodel->getStateName($data[0]['state']); foreach ($statesmodeldata as $state) { $citiesform->state->addMultiOption($state['id'] . '!@#' . $state['state_name'], utf8_encode($state['state_name'])); } $citiesmodeldata = $citiesmodel->getCitiesList($data[0]['state']); foreach ($citiesmodeldata as $city) { $citiesform->city->addMultiOption($city['id'] . '!@#' . $city['city_name'], utf8_encode($city['city_name'])); } $citiesform->populate($data[0]); $citiesform->setDefault('state', $statenameArr[0]['id'] . '!@#' . $statenameArr[0]['statename']); $this->view->cityValue = $data[0]['city_org_id'] . '!@#' . $data[0]['city']; $this->view->data = $data; $this->view->id = $id; $this->view->ermsg = ''; } else { $this->view->ermsg = 'norecord'; } } else { $this->view->ermsg = ''; } } catch (Exception $e) { $this->view->ermsg = 'nodata'; } $this->view->form = $citiesform; $this->view->msgarray = $msgarray; if ($this->getRequest()->getPost()) { $id = $this->_request->getParam('id'); $errorflag = "true"; $msgarray = array(); $newcityArr = array(); $dbstate = ''; $citystring = ''; $dbcountryid = ''; $countryid = $this->_request->getParam('countryid'); $stateidstr = $this->_request->getParam('state'); $stateid = intval($stateidstr); $cityArr = $this->_request->getParam('city'); if (!empty($cityArr)) { $othercityname = trim($this->_request->getParam('othercityname')); if (in_array('other', $cityArr)) { if ($othercityname == '') { $msgarray['othercityname'] = "Please enter city name."; $msgarray['dupcityname'] = ''; $msgarray['countid'] = $countryid; $msgarray['stateidval'] = $stateid; $errorflag = "false"; } else { $isDuplicateCityNameArr = $citiesmodel->getDuplicateCityName($othercityname, $stateid); if ($isDuplicateCityNameArr[0]['count'] > 0) { $errorflag = "false"; $msgarray['othercityname'] = "City already exists."; $msgarray['dupcityname'] = $othercityname; $msgarray['countid'] = $countryid; $msgarray['stateidval'] = $stateid; } else { $citystring = implode(",", $cityArr); if (sizeof($cityArr) > 1) { $newcityArr = $cityArr; array_pop($newcityArr); $citystring = implode(",", $newcityArr); $citystringcomma = trim(str_replace("!@#", ",", $citystring), ','); $citystringArr = explode(",", $citystringcomma); foreach ($citystringArr as $key => $val) { if (is_numeric($val)) { $cityid[] = $val; } else { $cityname[] = $val; } } } $dbstate = $othercityname; $errorflag = "true"; } } } else { $citystring = implode(",", $cityArr); $citystringcomma = trim(str_replace("!@#", ",", $citystring), ','); $citystringArr = explode(",", $citystringcomma); foreach ($citystringArr as $key => $val) { if (is_numeric($val)) { $cityid[] = $val; } else { $cityname[] = $val; } } $errorflag = "true"; } } else { $msgarray['countid'] = $countryid; $msgarray['stateidval'] = $stateid; $msgarray['stateiddropdown'] = $stateidstr; $errorflag = "false"; } if ($citiesform->isValid($this->_request->getPost()) && $errorflag == "true" && $citystring != '') { $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; if (in_array('other', $cityArr)) { if ($othercityname != '') { $NewCityId = $citiesmodel->SaveMainCityData($stateid, $othercityname); $NewCityInsertedId = $citiesmodel->SaveorUpdateCitiesData($countryid, $stateid, $othercityname, $NewCityId, $loginUserId); if (sizeof($cityArr) > 1) { if (!empty($cityid)) { for ($j = 0; $j < sizeof($cityid); $j++) { $Id = $citiesmodel->SaveorUpdateCitiesData($countryid, $stateid, $cityname[$j], $cityid[$j], $loginUserId); } } } $actionflag = 1; $tableid = $NewCityInsertedId; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "City added successfully.")); } } else { for ($j = 0; $j < sizeof($cityid); $j++) { $Id = $citiesmodel->SaveorUpdateCitiesData($countryid, $stateid, $cityname[$j], $cityid[$j], $loginUserId); } if ($id) { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "City updated successfully.")); $actionflag = 2; $tableid = $id; } else { if (sizeof($cityid) > 1) { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Cities added successfully.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "City added successfully.")); } $actionflag = 1; $tableid = $Id; } } $menuidArr = $menumodel->getMenuObjID('/cities'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $this->_redirect('cities'); } else { $messages = $citiesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } if (isset($countryid) && $countryid != 0 && $countryid != '') { $statesmodel = new Default_Model_States(); $statesmodeldata = $statesmodel->getBasicStatesList($countryid); foreach ($statesmodeldata as $res) { $citiesform->state->addMultiOption($res['state_id_org'] . '!@#' . utf8_encode($res['state']), utf8_encode($res['state'])); } if (isset($stateidstr) && $stateidstr != 0 && $stateidstr != '') { $citiesform->setDefault('state', $stateidstr); } } if (isset($stateidstr) && $stateidstr != 0 && $stateidstr != '') { $citiesmodel = new Default_Model_Cities(); $citiesmodeldata = $citiesmodel->getCitiesList($stateid); foreach ($citiesmodeldata as $res) { $citiesform->city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name'])); } $citiesform->city->addMultiOption('other', 'Other'); } $this->view->msgarray = $msgarray; } } $this->view->popConfigPermission = $popConfigPermission; }