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