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