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