public function configureorganisationAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $popConfigPermission = array(); $new_stateId = ''; 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'); } if (sapp_Global::_checkprivileges(CITIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'city'); } $msgarray = array(); $new_stateId = ''; $new_cityId = ''; $id = $this->getRequest()->getParam('id'); $form = new Default_Form_Organisationinfo(); $orgInfoModel = new Default_Model_Organisationinfo(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $wizard_model = new Default_Model_Wizard(); $wizardData = $wizard_model->getWizardData(); $orginfodata = $orgInfoModel->getOrganisationInfo(); $allCountriesData = $countriesModel->fetchAll('isactive=1', 'country')->toArray(); $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); $allCitiesData = $citiesmodel->fetchAll('isactive=1', 'city')->toArray(); $form->setAttrib('action', DOMAIN . 'wizard/configureorganisation'); $flag = 'true'; if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; $flag = 'false'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; $flag = 'false'; } if (!empty($orginfodata)) { try { $data = $orginfodata[0]; $data['org_startdate'] = sapp_Global::change_date($data['org_startdate'], 'view'); $form->populate($data); $countryId = $data['country']; $stateId = $data['state']; $cityId = $data['city']; $actionpage = 'edit'; if (count($_POST) > 0) { $countryId = isset($_POST['country']) ? $_POST['country'] : ""; $stateId = isset($_POST['state']) ? $_POST['state'] : ""; $cityId = isset($_POST['city']) ? $_POST['city'] : ""; } if ($countryId != '') { $statesData = $statesmodel->getBasicStatesList((int) $countryId); foreach ($statesData as $res) { if ($stateId == $res['state_id_org']) { $new_stateId = $res['state_id_org'] . '!@#' . utf8_encode($res['state']); } $form->state->addMultiOption($res['state_id_org'] . '!@#' . utf8_encode($res['state']), utf8_encode($res['state'])); } if (count($_POST) == 0) { $stateId = $new_stateId; } } if ($stateId != '') { $citiesData = $citiesmodel->getBasicCitiesList((int) $stateId); foreach ($citiesData as $res) { if ($cityId == $res['city_org_id']) { $new_cityId = $res['city_org_id'] . '!@#' . utf8_encode($res['city']); } $form->city->addMultiOption($res['city_org_id'] . '!@#' . utf8_encode($res['city']), utf8_encode($res['city'])); } if (count($_POST) == 0) { $cityId = $new_cityId; } } $form->setDefault('country', $countryId); $form->setDefault('state', $stateId); $form->setDefault('city', $cityId); $this->view->domainValue = $data['domain']; $this->view->org_image = $data['org_image']; $this->view->ermsg = ''; $this->view->datarr = $data; } catch (Exception $e) { $this->view->ermsg = 'nodata'; } } else { sapp_Global::buildlocations($form, $wizardData); } $this->view->form = $form; if (!empty($allCountriesData) && !empty($allStatesData) && !empty($allCitiesData)) { $this->view->configuremsg = ''; } else { $this->view->configuremsg = 'notconfigurable'; } $this->view->wizarddata = $wizardData; $this->view->msgarray = $msgarray; $this->view->popConfigPermission = $popConfigPermission; $this->view->messages = $this->_helper->flashMessenger->getMessages(); if ($this->getRequest()->getPost()) { $result = $this->saveorginfo($form, $loginUserId, $wizardData); $this->view->msgarray = $result; if (isset($this->msgarray['domain'])) { $this->view->msMsg = 'multiselecterror'; } } }
public function editpopupAction() { Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $orgInfoModel = new Default_Model_Organisationinfo(); $getorgData = $orgInfoModel->getorgrecords(); $deptModel = new Default_Model_Departments(); if (!empty($getorgData)) { $orgdata = ''; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $msgarray = array(); $flag = 'true'; $bunitid = $this->getRequest()->getParam('unitId'); $id = intVal($this->getRequest()->getParam('id')); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $timezonemodel = new Default_Model_Timezone(); $businessunitsmodel = new Default_Model_Businessunits(); $allTimezoneData = $timezonemodel->fetchAll('isactive=1', 'timezone')->toArray(); $allCountriesData = $countriesModel->fetchAll('isactive=1', 'country')->toArray(); $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); $allCitiesData = $citiesmodel->fetchAll('isactive=1', 'city')->toArray(); $allBusinessunitsData = $businessunitsmodel->fetchAll('isactive=1', 'unitname')->toArray(); $deptModel = new Default_Model_Departments(); $deptform = new Default_Form_departments(); $deptform->setAction(BASE_URL . 'departments/editpopup/id/' . $id . '/unitId/' . $bunitid); $country = $getorgData[0]['country']; if (isset($_POST['country'])) { $country = $_POST['country']; } $state = $getorgData[0]['state']; if (isset($_POST['state'])) { $state = $_POST['state']; } $city = $getorgData[0]['city']; if (isset($_POST['city'])) { $city = $_POST['city']; } $address = $getorgData[0]['address1']; //department head data $managementUsersData = $deptModel->getDepartmenttHead(''); foreach ($managementUsersData as $mgmtdata) { $deptform->depthead->addMultiOption($mgmtdata['user_id'], $mgmtdata['userfullname']); } if (isset($country) && $country != 0 && $country != '') { $deptform->setDefault('country', $country); $statesData = $statesmodel->getBasicStatesList($country); foreach ($statesData as $res) { $deptform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } if (isset($state) && $state != 0 && $state != '') { $deptform->setDefault('state', $state); } } if (isset($state) && $state != 0 && $state != '') { $citiesData = $citiesmodel->getBasicCitiesList($state); foreach ($citiesData as $res) { $deptform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } if (isset($city) && $city != 0 && $city != '') { $deptform->setDefault('city', $city); } } if (isset($address) && $address != '') { $deptform->address1->setValue($address); } $close = ''; $controllername = 'departments'; $deptData = array(); if ($id) { $data = $deptModel->getSingleDepartmentData($id); if (!empty($data)) { $deptform->populate($data); $deptform->submit->setLabel('Update'); $st_date = sapp_Global::change_date($data['startdate'], 'view'); $deptform->setDefault('start_date', $st_date); $deptform->setDefault('start_date', $st_date); $deptform->state->clearMultiOptions(); $deptform->city->clearMultiOptions(); $countryId = $data['country']; if (isset($_POST['country'])) { $countryId = $_POST['country']; } $stateId = $data['state']; if (isset($_POST['state'])) { $stateId = $_POST['state']; } $cityId = $data['city']; if (isset($_POST['city'])) { $cityId = $_POST['city']; } if ($countryId != '') { $statesmodel = new Default_Model_States(); $statesData = $statesmodel->getBasicStatesList($countryId); foreach ($statesData as $res) { $deptform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } } if ($stateId != '') { $citiesmodel = new Default_Model_Cities(); $citiesData = $citiesmodel->getBasicCitiesList($stateId); foreach ($citiesData as $res) { $deptform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } } $deptform->setDefault('country', $countryId); $deptform->setDefault('state', $stateId); $deptform->setDefault('city', $cityId); $this->view->ermsg = ''; $this->view->datarr = $data; } else { $this->view->ermsg = 'nodata'; } } $bname = $deptModel->getbusinessunitname($bunitid); $this->view->bunitname = $bname; $this->view->deptData = sizeof($deptData); $this->view->form = $deptform; $this->view->unitid = $bunitid; $this->view->controllername = $controllername; if (!empty($allBusinessunitsData) && !empty($allCountriesData) && !empty($allStatesData) && !empty($allCitiesData) && !empty($allTimezoneData)) { $this->view->configuremsg = ''; } else { $this->view->configuremsg = 'notconfigurable'; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; $flag = 'false'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; $flag = 'false'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; $flag = 'false'; } $this->view->msgarray = $msgarray; if ($this->getRequest()->getPost()) { if ($deptform->isValid($this->_request->getPost()) && $flag == 'true') { $deptname = $this->_request->getParam('deptname'); $deptcode = $this->_request->getParam('deptcode'); $description = $this->_request->getParam('description'); $start_date = $this->_request->getParam('start_date', null); $start_date = sapp_Global::change_date($start_date, 'database'); $country = $this->_request->getParam('country'); $state = intval($this->_request->getParam('state')); $city = intval($this->_request->getParam('city')); $address1 = $this->_request->getParam('address1'); $address2 = $this->_request->getParam('address2'); $address3 = $this->_request->getParam('address3'); $unitid = $this->_request->getParam('unitid'); $timezone = $this->_request->getParam('timezone'); $depthead = $this->_request->getParam('depthead'); if (!isset($unitid) || $unitid == '') { $unitid = $bunitid; } $deptcodeExistance = $deptModel->checkCodeDuplicates($deptcode, $id); if (!$deptcodeExistance) { $date = new Zend_Date(); $actionflag = ''; $tableid = ''; $data = array('deptname' => trim($deptname), 'deptcode' => trim($deptcode), 'description' => trim($description), 'startdate' => $start_date != '' ? $start_date : NULL, 'country' => trim($country), 'state' => trim($state), 'city' => trim($city), 'address1' => trim($address1), 'address2' => trim($address2), 'address3' => trim($address3), 'timezone' => trim($timezone), 'unitid' => $unitid, 'depthead' => trim($depthead), 'modifiedby' => $loginUserId, 'modifieddate' => $date->get('yyyy-MM-dd HH:mm:ss')); if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = $date->get('yyyy-MM-dd HH:mm:ss'); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $deptModel->SaveorUpdateDepartmentsUnits($data, $where); if ($Id == 'update') { $this->view->eventact = 'updated'; $tableid = $id; } else { $this->view->eventact = 'added'; $tableid = $Id; } $menuID = DEPARTMENTS; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $close = 'close'; $this->view->popup = $close; $this->view->controllername = $controllername; } else { $msgarray['message'] = 'A Department, with the given code, already exists.'; $msgarray['msgtype'] = 'error'; $this->view->messages = $msgarray; } } else { $messages = $deptform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; } } $this->view->msgarray = $msgarray; } } } else { $orgdata = 'noorgdata'; $this->view->orgdata = $orgdata; } }
public function addpopupAction() { Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('id'); $selectedcountryid = $this->_request->getParam('selectcountryid', null); $countryid = $this->_request->getParam('countryid'); $msgarray = array(); $controllername = 'states'; $statestring = ''; $statesform = new Default_Form_states(); $statesmodel = new Default_Model_States(); $countriesModel = new Default_Model_Countries(); $statesform->setAction(BASE_URL . 'states/addpopup/selectcountryid/' . $selectedcountryid); $countrieslistArr = $countriesModel->getActiveCountriesList(); if (sizeof($countrieslistArr) > 0) { $statesform->countryid->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { if (isset($selectedcountryid)) { if ($countrieslistres['country_id_org'] == $selectedcountryid) { $statesform->countryid->addMultiOption($countrieslistres['country_id_org'], $countrieslistres['country']); $statesform->setDefault('countryid', $selectedcountryid); } } else { $statesform->countryid->addMultiOption($countrieslistres['country_id_org'], $countrieslistres['country']); } } } else { $msgarray['countryid'] = 'Countries are not configured yet'; } if (isset($selectedcountryid) && $selectedcountryid != 0 && $selectedcountryid != '') { $statesmodeldata = $statesmodel->getStatesList($selectedcountryid, 'addstate'); $statesform->state->addMultiOption('', 'Select State'); foreach ($statesmodeldata as $res) { $statesform->state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name'])); } $statesform->state->addMultiOption('other', 'Other'); if ($statestring == 'other') { $statesform->setDefault('state', 'other'); } } if ($this->getRequest()->getPost()) { $id = $this->_request->getParam('id'); $errorflag = "true"; $msgarray = array(); $newstateArr = array(); $dbstate = ''; $dbcountryid = ''; $statestring = ''; $stateArr = $this->_request->getParam('state'); if (!empty($stateArr)) { $otherstatename = $this->_request->getParam('otherstatename'); if (in_array('other', $stateArr)) { if ($otherstatename == '') { $msgarray['otherstatename'] = "Please enter state name."; $msgarray['dupstatename'] = ''; $msgarray['countid'] = $countryid; $errorflag = "false"; } else { $isDuplicateStateNameArr = $statesmodel->getDuplicateStateName($otherstatename, $countryid); if ($isDuplicateStateNameArr[0]['count'] > 0) { $errorflag = "false"; $msgarray['otherstatename'] = "State already exists"; $msgarray['dupstatename'] = $otherstatename; $msgarray['countid'] = $countryid; } else { $statestring = implode(",", $stateArr); if (sizeof($stateArr) > 1) { $newstateArr = $stateArr; array_pop($newstateArr); $statestring = implode(",", $newstateArr); $statestringcomma = trim(str_replace("!@#", ",", $statestring), ','); $statestringArr = explode(",", $statestringcomma); foreach ($statestringArr as $key => $val) { if (is_numeric($val)) { $stateid[] = $val; } else { $statename[] = $val; } } } $dbstate = $otherstatename; $errorflag = "true"; } } } else { $statestring = implode(",", $stateArr); $statestringcomma = trim(str_replace("!@#", ",", $statestring), ','); $statestringArr = explode(",", $statestringcomma); foreach ($statestringArr as $key => $val) { if (is_numeric($val)) { $stateid[] = $val; } else { $statename[] = $val; } } $errorflag = "true"; } } else { $msgarray['countid'] = $countryid; $errorflag = "false"; } if ($statesform->isValid($this->_request->getPost()) && $errorflag == "true" && $statestring != '') { $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; if (in_array('other', $stateArr)) { if ($otherstatename != '') { $NewStateId = $statesmodel->SaveMainStateData($countryid, $otherstatename); $NewStateInsertedId = $statesmodel->SaveorUpdateStatesData($countryid, $otherstatename, $NewStateId, $loginUserId); if (sizeof($stateArr) > 1) { if (!empty($stateid)) { for ($j = 0; $j < sizeof($stateid); $j++) { $Id = $statesmodel->SaveorUpdateStatesData($countryid, $statename[$j], $stateid[$j], $loginUserId); } } } $actionflag = 1; $tableid = $NewStateInsertedId; } } else { for ($j = 0; $j < sizeof($stateid); $j++) { $Id = $statesmodel->SaveorUpdateStatesData($countryid, $statename[$j], $stateid[$j], $loginUserId); } $tableid = $Id; $actionflag = 1; } $menuidArr = $menumodel->getMenuObjID('/states'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); if (isset($selectedcountryid)) { $stateData = $statesmodel->fetchAll('isactive = 1 and countryid = ' . $selectedcountryid, 'state')->toArray(); } else { $stateData = array(); } $opt = ''; foreach ($stateData as $record) { $opt .= sapp_Global::selectOptionBuilder($record['state_id_org'], $record['state']); } $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; } } if (isset($countryid) && $countryid != 0 && $countryid != '') { $statesmodeldata = $statesmodel->getStatesList($countryid); $statesform->state->addMultiOption('', 'Select State'); foreach ($statesmodeldata as $res) { $statesform->state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name'])); } $statesform->state->addMultiOption('other', 'Other'); if ($statestring == 'other') { $statesform->setDefault('state', 'other'); } } } } $this->view->ermsg = ''; $this->view->form = $statesform; $this->view->msgarray = $msgarray; $this->view->controllername = $controllername; }
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; }
public function editAction() { $orgInfoModel = new Default_Model_Organisationinfo(); $getorgData = $orgInfoModel->getorgrecords(); $popConfigPermission = array(); if (!empty($getorgData)) { $orgdata = ''; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } if (sapp_Global::_checkprivileges(TIMEZONE, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'timezone'); } 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'); } if (sapp_Global::_checkprivileges(CITIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'city'); } $msgarray = array(); $flag = 'true'; $id = $this->getRequest()->getParam('id'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $timezonemodel = new Default_Model_Timezone(); $allTimezoneData = $timezonemodel->fetchAll('isactive=1', 'timezone')->toArray(); $allCountriesData = $countriesModel->fetchAll('isactive=1', 'country')->toArray(); $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); $allCitiesData = $citiesmodel->fetchAll('isactive=1', 'city')->toArray(); $businessunitsform = new Default_Form_businessunits(); $businessunitsmodel = new Default_Model_Businessunits(); $orgInfoModel = new Default_Model_Organisationinfo(); $deptModel = new Default_Model_Departments(); $deptform = new Default_Form_departments(); $deptData = array(); $msgarray = array(); $businessunitsform->setAttrib('action', DOMAIN . 'businessunits/edit'); $country = $getorgData[0]['country']; if (isset($_POST['country'])) { $country = $_POST['country']; } $state = $getorgData[0]['state']; if (isset($_POST['state'])) { $state = $_POST['state']; } $city = $getorgData[0]['city']; if (isset($_POST['city'])) { $city = $_POST['city']; } $address = $getorgData[0]['address1']; if (isset($country) && $country != 0 && $country != '') { $businessunitsform->setDefault('country', $country); $statesData = $statesmodel->getBasicStatesList($country); foreach ($statesData as $res) { $businessunitsform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } if (isset($state) && $state != 0 && $state != '') { $businessunitsform->setDefault('state', $state); } } if (isset($state) && $state != 0 && $state != '') { $citiesData = $citiesmodel->getBasicCitiesList($state); foreach ($citiesData as $res) { $businessunitsform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } if (isset($city) && $city != 0 && $city != '') { $businessunitsform->setDefault('city', $city); } } if (isset($address) && $address != '') { $businessunitsform->address1->setValue($address); } if (is_numeric($id) && $id > 0) { $data = $businessunitsmodel->getSingleUnitData($id); if (!empty($data)) { $businessunitsform->setAttrib('action', DOMAIN . 'businessunits/edit/id/' . $id); $businessunitsform->populate($data); $businessunitsform->submit->setLabel('Update'); $st_date = sapp_Global::change_date($data["startdate"], 'view'); $businessunitsform->setDefault('start_date', $st_date); $businessunitsform->state->clearMultiOptions(); $businessunitsform->city->clearMultiOptions(); $businessunitsform->state->addMultiOption('', utf8_encode("Select State")); $businessunitsform->city->addMultiOption('', utf8_encode("Select City")); $countryId = $data['country']; if (isset($_POST['country'])) { $countryId = $_POST['country']; } $stateId = $data['state']; if (isset($_POST['state'])) { $stateId = $_POST['state']; } $cityId = $data['city']; if (isset($_POST['city'])) { $cityId = $_POST['city']; } if ($countryId != '') { $statesData = $statesmodel->getBasicStatesList($countryId); foreach ($statesData as $res) { $businessunitsform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } $businessunitsform->setDefault('country', $countryId); $businessunitsform->setDefault('state', $stateId); } if ($stateId != '') { $citiesData = $citiesmodel->getBasicCitiesList($stateId); foreach ($citiesData as $res) { $businessunitsform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } $businessunitsform->setDefault('city', $cityId); } $deptData = $deptModel->getAllDeptsForUnit($id); $this->view->ermsg = ''; $this->view->datarr = $data; } else { $this->view->ermsg = 'nodata'; } } else { if ($id != '') { $this->view->ermsg = 'nodata'; } } $deptaddpermission = sapp_Global::_checkprivileges(DEPARTMENTS, $loginuserGroup, $loginuserRole, 'add'); $this->view->deptaddpermission = $deptaddpermission; $this->view->dataArray = $this->departmentGrid($id); $this->view->deptData = sizeof($deptData); $this->view->form = $businessunitsform; $this->view->unitid = $id; if (!empty($allCountriesData) && !empty($allStatesData) && !empty($allCitiesData) && !empty($allTimezoneData)) { $this->view->configuremsg = ''; } else { $this->view->configuremsg = 'notconfigurable'; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; $flag = 'false'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; $flag = 'false'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; $flag = 'false'; } $start_date = $this->_request->getParam('start_date'); $start_date = sapp_Global::change_date($start_date, 'database'); $this->view->msgarray = $msgarray; if ($this->getRequest()->getPost()) { if ($businessunitsform->isValid($this->_request->getPost()) && $flag == 'true') { $unitname = $this->_request->getParam('unitname'); $unitcode = $this->_request->getParam('unitcode'); $description = $this->_request->getParam('description'); $country = $this->_request->getParam('country'); $state = intval($this->_request->getParam('state')); $city = $this->_request->getParam('city'); $address1 = $this->_request->getParam('address1'); $address2 = $this->_request->getParam('address2'); $address3 = $this->_request->getParam('address3'); $timezone = $this->_request->getParam('timezone'); $unithead = $this->_request->getParam('unithead'); $unitcodeExistance = $businessunitsmodel->checkUnitCodeDuplicates($unitcode, $id); if (!$unitcodeExistance) { $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('unitname' => trim($unitname), 'unitcode' => trim($unitcode), 'description' => trim($description), 'startdate' => $start_date != '' ? $start_date : NULL, 'country' => trim($country), 'state' => trim($state), 'city' => trim($city), 'address1' => trim($address1), 'address2' => trim($address2), 'address3' => trim($address3), 'timezone' => trim($timezone), 'unithead' => trim($unithead), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); 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 = $businessunitsmodel->SaveorUpdateBusinessUnits($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage("Business unit updated successfully."); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage("Business unit added successfully."); } $menuidArr = $menumodel->getMenuObjID('/businessunits'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $this->_redirect('businessunits'); } else { $msgarray['message'] = 'A Business Unit, with the given code, already exists.'; $msgarray['msgtype'] = 'error'; $this->view->messages = $msgarray; } } else { $messages = $businessunitsform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; } } $this->view->msgarray = $msgarray; } } } else { $orgdata = 'noorgdata'; $this->view->orgdata = $orgdata; } $this->view->popConfigPermission = $popConfigPermission; }
public function edit_oldAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $popConfigPermission = array(); $empid = ''; $orgheadsData = array(); $oldOrgHead = ''; $new_stateId = ''; $actionpage = ''; if (sapp_Global::_checkprivileges(PREFIX, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'prefix'); } if (sapp_Global::_checkprivileges(IDENTITYCODES, $loginuserGroup, $loginuserRole, 'edit') == 'Yes') { array_push($popConfigPermission, 'identitycodes'); } if (sapp_Global::_checkprivileges(JOBTITLES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'jobtitles'); } if (sapp_Global::_checkprivileges(POSITIONS, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'position'); } 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'); } if (sapp_Global::_checkprivileges(CITIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'city'); } if (sapp_Global::_checkprivileges(EMPLOYEE, $loginuserGroup, $loginuserRole, 'edit') == 'Yes') { array_push($popConfigPermission, 'employee'); } $msgarray = array(); $new_stateId = ''; $new_cityId = ''; $id = $this->getRequest()->getParam('id'); $form = new Default_Form_Organisationinfo(); $user_model = new Default_Model_Usermanagement(); $orgInfoModel = new Default_Model_Organisationinfo(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $role_model = new Default_Model_Roles(); $prefixModel = new Default_Model_Prefix(); $identity_code_model = new Default_Model_Identitycodes(); $jobtitlesModel = new Default_Model_Jobtitles(); $employeeModal = new Default_Model_Employee(); $positionsmodel = new Default_Model_Positions(); $identity_codes = $identity_code_model->getIdentitycodesRecord(); $role_data = $role_model->getRolesList_orginfo(); $allCountriesData = $countriesModel->fetchAll('isactive=1', 'country')->toArray(); $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); $allCitiesData = $citiesmodel->fetchAll('isactive=1', 'city')->toArray(); $flag = 'true'; $emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : ""; if ($emp_identity_code != '') { $emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); } else { $emp_id = ''; $msgarray['employeeId'] = 'Identity codes are not configured yet.'; $flag = 'false'; } $form->employeeId->setValue($emp_id); $form->emprole->addMultiOptions(array('' => 'Select Role') + $role_data); if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; $flag = 'false'; } if (empty($role_data)) { $msgarray['emprole'] = 'Roles are not added yet.'; $flag = 'false'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; $flag = 'false'; } $prefixData = $prefixModel->getPrefixList(); $form->prefix_id->addMultiOption('', 'Select Prefix'); if (!empty($prefixData)) { foreach ($prefixData as $prefixres) { $form->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']); } } else { $msgarray['prefix_id'] = 'Prefixes are not configured yet.'; } $jobtitleData = $jobtitlesModel->getJobTitleList(); if (!empty($jobtitleData)) { foreach ($jobtitleData as $jobtitleres) { $form->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']); } } else { $msgarray['jobtitle_id'] = 'Job titles are not configured yet.'; $msgarray['position_id'] = 'Positions are not configured yet.'; } $orgheadsData = $employeeModal->getEmployeesForOrgHead(); $currentOrgHead = $employeeModal->getCurrentOrgHead(); if (!empty($currentOrgHead)) { $oldOrgHead = $currentOrgHead[0]['user_id']; } if ($id) { $form->submit->setLabel('Update'); try { $data = $orgInfoModel->getOrganisationData($id); $form->setAttrib('action', BASE_URL . 'organisationinfo/edit/id/' . $id); $data['org_startdate'] = sapp_Global::change_date($data['org_startdate'], 'view'); $form->populate($data); $countryId = $data['country']; $stateId = $data['state']; $cityId = $data['city']; $actionpage = 'edit'; if (count($_POST) > 0) { $countryId = isset($_POST['country']) ? $_POST['country'] : ""; $stateId = isset($_POST['state']) ? $_POST['state'] : ""; $cityId = isset($_POST['city']) ? $_POST['city'] : ""; } if ($countryId != '') { $statesData = $statesmodel->getBasicStatesList((int) $countryId); foreach ($statesData as $res) { if ($stateId == $res['state_id_org']) { $new_stateId = $res['state_id_org'] . '!@#' . utf8_encode($res['state']); } $form->state->addMultiOption($res['state_id_org'] . '!@#' . utf8_encode($res['state']), utf8_encode($res['state'])); } if (count($_POST) == 0) { $stateId = $new_stateId; } } if ($stateId != '') { $citiesData = $citiesmodel->getBasicCitiesList((int) $stateId); foreach ($citiesData as $res) { if ($cityId == $res['city_org_id']) { $new_cityId = $res['city_org_id'] . '!@#' . utf8_encode($res['city']); } $form->city->addMultiOption($res['city_org_id'] . '!@#' . utf8_encode($res['city']), utf8_encode($res['city'])); } if (count($_POST) == 0) { $cityId = $new_cityId; } } $emp_data = $employeeModal->fetchRow("is_orghead = 1"); if (!empty($emp_data)) { $user_data = $user_model->fetchRow("id = " . $emp_data->user_id); if (!empty($user_data)) { $form->setDefault('firstname_orghead', $user_data->firstname); $form->setDefault('lastname_orghead', $user_data->lastname); $form->setDefault('employeeId', $user_data->employeeId); $form->setDefault('emprole', $user_data->emprole); $form->setDefault('emailaddress', $user_data->emailaddress); $form->setDefault('jobtitle_id', $user_data->jobtitle_id); $form->setDefault('prefix_id', $emp_data->prefix_id); $form->setDefault('date_of_joining', sapp_Global::change_date($emp_data->date_of_joining, 'view')); $jobtitle_id = $emp_data->jobtitle_id; if (isset($_POST['jobtitle_id'])) { $jobtitle_id = $_POST['jobtitle_id']; } $form->position_id->addMultiOption('', 'Select a Position'); if ($jobtitle_id != '') { $positionlistArr = $positionsmodel->getPositionList($jobtitle_id); if (sizeof($positionlistArr) > 0) { foreach ($positionlistArr as $positionlistres) { $form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']); } } } $form->setDefault('position_id', $emp_data->position_id); $form->setDefault('orghead', $user_data->id); } $empid = $emp_data->user_id; } else { $form->setDefault('orghead', ''); } if (empty($orgheadsData)) { $msgarray['orghead'] = 'Management employees are not added yet.'; } $form->setDefault('country', $countryId); $form->setDefault('state', $stateId); $form->setDefault('city', $cityId); $this->view->domainValue = $data['domain']; $this->view->org_image = $data['org_image']; $this->view->ermsg = ''; $this->view->datarr = $data; $this->view->user_id = $empid; $this->view->orgheadsData = $orgheadsData; } catch (Exception $e) { $this->view->ermsg = 'nodata'; } } else { $actionpage = 'add'; $activeOrgs = $orgInfoModel->getorgrecords(); if (empty($activeOrgs)) { $form->setAttrib('action', BASE_URL . 'organisationinfo/edit'); $country = $this->_request->getParam('country'); $state = intVal($this->_request->getParam('state')); $city = intVal($this->_request->getParam('city')); if (isset($country) && $country != 0 && $country != '') { $statesData = $statesmodel->getBasicStatesList($country); foreach ($statesData as $res) { $form->state->addMultiOption($res['state_id_org'] . '!@#' . utf8_encode($res['state']), utf8_encode($res['state'])); } if (isset($state) && $state != 0 && $state != '') { $form->setDefault('state', $state); } } if (isset($state) && $state != 0 && $state != '') { $citiesData = $citiesmodel->getBasicCitiesList($state); foreach ($citiesData as $res) { $form->city->addMultiOption($res['city_org_id'] . '!@#' . utf8_encode($res['city']), utf8_encode($res['city'])); } if (isset($city) && $city != 0 && $city != '') { $form->setDefault('city', $city); } } $this->view->ermsg = ''; } else { $this->view->ermsg = 'cannotadd'; } $form->position_id->addMultiOption('', 'Select a Position'); if (isset($_POST['jobtitle_id']) && $_POST['jobtitle_id'] != '') { $jobtitle_id = $_POST['jobtitle_id']; $positionlistArr = $positionsmodel->getPositionList($jobtitle_id); if (sizeof($positionlistArr) > 0) { foreach ($positionlistArr as $positionlistres) { $form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']); } } } $emp_data = $employeeModal->fetchRow("is_orghead = 1"); if (!empty($emp_data)) { $user_data = $user_model->fetchRow("id = " . $emp_data->user_id); if (!empty($user_data)) { $form->setDefault('employeeId', $user_data->employeeId); $form->setDefault('emprole', $user_data->emprole); $form->setDefault('emailaddress', $user_data->emailaddress); $form->setDefault('jobtitle_id', $user_data->jobtitle_id); $form->setDefault('prefix_id', $emp_data->prefix_id); $form->setDefault('date_of_joining', sapp_Global::change_date($emp_data->date_of_joining, 'view')); $jobtitle_id = $emp_data->jobtitle_id; if (isset($_POST['jobtitle_id'])) { $jobtitle_id = $_POST['jobtitle_id']; } $form->position_id->addMultiOption('', 'Select a Position'); if ($jobtitle_id != '') { $positionlistArr = $positionsmodel->getPositionList($jobtitle_id); if (sizeof($positionlistArr) > 0) { foreach ($positionlistArr as $positionlistres) { $form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']); } } } $form->setDefault('position_id', $emp_data->position_id); $form->setDefault('orghead', $user_data->id); } $empid = $emp_data->user_id; } else { $form->setDefault('orghead', ''); } if (empty($orgheadsData)) { $msgarray['orghead'] = 'Management employees are not added yet.'; } $this->view->user_id = $empid; $this->view->orgheadsData = $orgheadsData; } $this->view->form = $form; $this->view->currentOrgHead = $currentOrgHead; $this->view->actionpage = $actionpage; if (!empty($allCountriesData) && !empty($allStatesData) && !empty($allCitiesData)) { $this->view->configuremsg = ''; } else { $this->view->configuremsg = 'notconfigurable'; } if (isset($_POST['prevorgheadrm'])) { $prevorgheadrm = $this->_request->getParam('prevorgheadrm'); } else { $prevorgheadrm = ''; } $this->view->prevorgheadrmval = $prevorgheadrm; if (isset($_POST['rmflag'])) { $rmflag = $this->_request->getParam('rmflag'); } else { $rmflag = '0'; } $this->view->rmflag = $rmflag; if ($this->getRequest()->getPost()) { $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); $prevorgheadrm = $this->_request->getParam('prevorgheadrm'); $actionflag = ''; $date = new Zend_Date(); $newOrgHead = $this->_request->getParam('orghead'); if ($newOrgHead != '') { $neworgHeadData = $employeeModal->getsingleEmployeeData($newOrgHead); } if (!empty($neworgHeadData)) { $headfullname = $neworgHeadData[0]['userfullname']; } else { $headfullname = ''; } $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')), 'orghead' => trim($this->_request->getParam('orghead')), '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 { if ($oldOrgHead != $newOrgHead && $oldOrgHead != '' && $newOrgHead != '' && $prevorgheadrm) { $orgInfoModel->changeOrgHead($oldOrgHead, $newOrgHead, $prevorgheadrm); } $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); $jobtitle_id = $this->_request->getParam('jobtitle_id', null); $position_id = $this->_request->getParam('position_id', null); $date_of_joining = sapp_Global::change_date($this->_request->getParam('date_of_joining', null), 'database'); $employeeId = $this->_getParam('employeeId', null); $emprole = $this->_getParam('emprole', null); $emailaddress = $this->_getParam('emailaddress', null); $emppassword = sapp_Global::generatePassword(); $first_name = trim($this->_request->getParam('firstname_orghead', null)); $last_name = trim($this->_request->getParam('lastname_orghead', null)); $userfullname = $first_name . ' ' . $last_name; //$userfullname = $headfullname; $prefix_id = $this->_getParam('prefix_id', null); $user_id = $this->_getParam('user_id', null); $user_data = array('emprole' => $emprole, 'firstname' => $first_name, 'lastname' => $last_name, 'userfullname' => $userfullname, 'emailaddress' => $emailaddress, 'jobtitle_id' => $jobtitle_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'selecteddate' => $date_of_joining, 'userstatus' => 'old', 'modeofentry' => 'Direct'); $emp_data = array('user_id' => $newOrgHead, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'reporting_manager' => 0, 'date_of_joining' => $date_of_joining, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($Id == 'update') { $tableid = $id; unset($user_data['emppassword']); unset($user_data['modeofentry']); unset($user_data['userstatus']); if ($newOrgHead != '') { $user_st = $user_model->SaveorUpdateUserData($user_data, " id = " . $newOrgHead); $employeeModal->SaveorUpdateEmployeeData($emp_data, " user_id = " . $newOrgHead); } else { $user_data['userstatus'] = 'old'; $user_data['emppassword'] = md5($emppassword); $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; if ($emp_identity_code != '') { $emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); } else { $emp_id = ''; } $user_data['employeeId'] = $emp_id; $user_id = $user_model->SaveorUpdateUserData($user_data, ''); $emp_data['user_id'] = $newOrgHead; $emp_data['createdby'] = $loginUserId; $emp_data['createddate'] = gmdate("Y-m-d H:i:s"); $emp_data['isactive'] = 1; $emp_data['is_orghead'] = 1; $employeeModal->SaveorUpdateEmployeeData($emp_data, ''); } if ($filecopy == 'success') { $this->_helper->getHelper("FlashMessenger")->addMessage("Organization information updated successfully."); } else { $this->_helper->getHelper("FlashMessenger")->addMessage("Organization information updated successfully but failed to upload the logo."); } } else { //start of saving into employee table $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; if ($emp_identity_code != '') { $emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); } else { $emp_id = ''; } $user_data['employeeId'] = $emp_id; $user_id = $user_model->SaveorUpdateUserData($user_data, ''); $emp_data['user_id'] = $user_id; $emp_data['createdby'] = $loginUserId; $emp_data['createddate'] = gmdate("Y-m-d H:i:s"); $emp_data['isactive'] = 1; $emp_data['is_orghead'] = 1; $employeeModal->SaveorUpdateEmployeeData($emp_data, ''); $tableid = $Id; 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."); } } $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(); } /* Send Mail to the user */ if ($Id != 'update') { $base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $view = $this->getHelper('ViewRenderer')->view; $this->view->emp_name = $userfullname; $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 */ $db->commit(); $this->_redirect('organisationinfo'); } catch (Exception $e) { $db->rollBack(); return 'failed'; } } else { $messages = $form->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; } } if (isset($this->msgarray['domain'])) { $this->view->msMsg = 'multiselecterror'; } } } $this->view->msgarray = $msgarray; $this->view->popConfigPermission = $popConfigPermission; }