public function editAction()
{
$orgInfoModel = new Default_Model_Organisationinfo();
$getorgData = $orgInfoModel->getorgrecords();
$sitepreferencemodel = new Default_Model_Sitepreference();
$activerecordArr = $sitepreferencemodel->getActiveRecord();
$timezoneid = !empty($activerecordArr[0]['timezoneid']) ? $activerecordArr[0]['timezoneid'] : '';
$popConfigPermission = array();
$organisationHead = 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');
}
if (sapp_Global::_checkprivileges(EMPLOYEE, $loginUserGroup, $loginUserRole, 'add') == 'Yes') {
array_push($popConfigPermission, 'employee');
}
$msgarray = array();
$flag = 'true';
$id = $this->getRequest()->getParam('id');
$callval = $this->getRequest()->getParam('call');
$deptModel = new Default_Model_Departments();
$deptform = new Default_Form_departments();
$statesmodel = new Default_Model_States();
$citiesmodel = new Default_Model_Cities();
$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();
$orgInfoModel = new Default_Model_Organisationinfo();
$employeeModal = new Default_Model_Employee();
$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();
$deptData = array();
$deptform->setAttrib('action', BASE_URL . 'departments/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'];
}
$deptform->setDefault('timezone', $timezoneid);
$address = $getorgData[0]['address1'];
$organisationHead = $employeeModal->getCurrentOrgHead();
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);
}
if (is_numeric($id) && $id > 0) {
$data = $deptModel->getSingleDepartmentData($id);
if (!empty($data)) {
$deptform->setAttrib('action', BASE_URL . 'departments/edit/id/' . $id);
$managementUsersData = $deptModel->getDepartmenttHead($data['depthead']);
foreach ($managementUsersData as $mgmtdata) {
$deptform->depthead->addMultiOption($mgmtdata['user_id'], $mgmtdata['userfullname']);
}
$deptform->populate($data);
$deptform->setDefault('depthead', $data['depthead']);
$deptform->submit->setLabel('Update');
$deptform->state->clearMultiOptions();
$deptform->city->clearMultiOptions();
$deptform->state->addMultiOption('', utf8_encode("Select State"));
$deptform->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) {
$deptform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state']));
}
$deptform->setDefault('country', $countryId);
$deptform->setDefault('state', $stateId);
}
if ($stateId != '') {
$citiesData = $citiesmodel->getBasicCitiesList($stateId);
foreach ($citiesData as $res) {
$deptform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city']));
}
$deptform->setDefault('city', $cityId);
}
if ($data["startdate"] != '') {
$st_date = sapp_Global::change_date($data["startdate"], 'view');
$deptform->setDefault('start_date', $st_date);
}
$this->view->ermsg = '';
$this->view->datarr = $data;
} else {
$this->view->ermsg = 'nodata';
}
} else {
if ($id != '') {
$this->view->ermsg = 'nodata';
} else {
$managementUsersData = $deptModel->getDepartmenttHead('');
foreach ($managementUsersData as $mgmtdata) {
$deptform->depthead->addMultiOption($mgmtdata['user_id'], $mgmtdata['userfullname']);
}
}
}
$this->view->deptData = sizeof($deptData);
$this->view->form = $deptform;
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($allBusinessunitsData)) {
$msgarray['unitid'] = 'Business units are not added yet.';
$flag = 'false';
}
if (empty($allTimezoneData)) {
$msgarray['timezone'] = 'Time zones are not configured yet.';
$flag = 'false';
}
$this->view->msgarray = $msgarray;
if ($this->getRequest()->getPost()) {
$deptname = trim($this->_request->getParam('deptname'));
$unitid = $this->_request->getParam('unitid');
if ($deptname != '' && $unitid != '') {
if (!preg_match('/^[a-zA-Z.\\- ?]+$/', $deptname)) {
$msgarray['deptname'] = "Please enter valid department name.";
$flag = 'false';
} else {
$checkExists = $deptModel->checkExistance($deptname, $unitid, $id);
if ($checkExists != 0) {
$msgarray['deptname'] = "Department name already exists.";
$flag = 'false';
}
}
} else {
$flag = 'false';
}
$start_date = $this->_request->getParam('start_date', null);
$start_date = sapp_Global::change_date($start_date, 'database');
if ($deptform->isValid($this->_request->getPost()) && $flag == 'true') {
$deptname = $this->_request->getParam('deptname');
$deptcode = $this->_request->getParam('deptcode');
$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');
$unitid = $this->_request->getParam('unitid');
$timezone = $this->_request->getParam('timezone');
$depthead = $this->_request->getParam('depthead');
$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);
/* Updating business unit and department for org head*/
$emp_data = array('businessunit_id' => $unitid, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$emp_where = array('user_id=?' => $depthead);
if ($Id == 'update') {
$tableid = $id;
$emp_data['department_id'] = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage("Department updated successfully.");
} else {
$tableid = $Id;
$emp_data['department_id'] = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage("Department added successfully.");
}
$employeeModal->SaveorUpdateEmployeeData($emp_data, $emp_where);
$menuID = DEPARTMENTS;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$this->_redirect('departments');
} 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($allBusinessunitsData)) {
$msgarray['unitid'] = 'Business units are not added 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;
$this->view->organisationHead = $organisationHead;
}
public function addAction()
{
$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();
if (sapp_Global::_checkprivileges(CURRENCY, $loginuserGroup, $loginuserRole, 'add') == 'Yes') {
array_push($popConfigPermission, 'currency');
}
if (sapp_Global::_checkprivileges(TIMEZONE, $loginuserGroup, $loginuserRole, 'add') == 'Yes') {
array_push($popConfigPermission, 'timezone');
}
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$systempreferenceform = new Default_Form_systempreference();
$dateformatidmodel = new Default_Model_Dateformat();
$timeformatidmodel = new Default_Model_Timeformat();
$currencyidmodel = new Default_Model_Currency();
$systempreferencemodel = new Default_Model_Sitepreference();
$activerecordArr = $systempreferencemodel->getActiveRecord();
$msgarray = array();
$timezonemodel = new Default_Model_Timezone();
$allTimezoneData = $timezonemodel->fetchAll('isactive=1', 'timezone')->toArray();
$date_formats_arr = $dateformatidmodel->getAllDateFormats();
$time_formats_arr = $timeformatidmodel->fetchAll()->toArray();
if (sizeof($date_formats_arr) > 0) {
$this->view->date_formats_arr = $date_formats_arr;
} else {
$msgarray['dateformatid'] = 'Date Formats are not configured yet';
}
if (sizeof($time_formats_arr) > 0) {
$this->view->time_formats_arr = $time_formats_arr;
} else {
$msgarray['timeformatid'] = 'Time Formats are not configured yet';
}
$currencyidmodeldata = $currencyidmodel->getCurrencyList();
$systempreferenceform->currencyid->addMultiOption('', 'Select Currency');
if (sizeof($currencyidmodeldata) > 0) {
foreach ($currencyidmodeldata as $currencyidres) {
$systempreferenceform->currencyid->addMultiOption($currencyidres['id'], utf8_encode($currencyidres['currency']));
}
} else {
$msgarray['currencyid'] = 'Currency is not configured yet';
}
$passworddataArr = $systempreferencemodel->getPasswordData();
$systempreferenceform->passwordid->addMultiOption('', 'Select Password Preference');
foreach ($passworddataArr as $passwordres) {
$systempreferenceform->passwordid->addMultiOption($passwordres['id'], utf8_encode($passwordres['passwordtype']));
}
if (sizeof($allTimezoneData) > 0) {
foreach ($allTimezoneData as $timezoneidres) {
$systempreferenceform->timezoneid->addMultiOption($timezoneidres['id'], utf8_encode($timezoneidres['timezone'] . ' [' . $timezoneidres['timezone_abbr'] . ']'));
}
} else {
$msgarray['timezoneid'] = 'Time Zone is not configured yet.';
}
$systempreferenceform->setAttrib('action', DOMAIN . 'sitepreference/add');
$this->view->form = $systempreferenceform;
$this->view->passworddata = $passworddataArr;
$this->view->msgarray = $msgarray;
$this->view->popConfigPermission = $popConfigPermission;
if (count($activerecordArr) > 0) {
$this->view->nodata = "nodata";
}
if ($this->getRequest()->getPost()) {
$result = $this->save($systempreferenceform);
$this->view->msgarray = $result;
}
}
/**
* This function is used to write site constants to a php file.
*/
public static function generateSiteConstants()
{
$filename = Zend_Registry::get('siteconstant_file_path');
$site_model = new Default_Model_Sitepreference();
$site_data = $site_model->getActiveRecord();
if (!empty($site_data)) {
$site_data = $site_data[0];
$utc = new DateTimeZone('UTC');
$dt = new DateTime('now', $utc);
$current_tz = new DateTimeZone($site_data['tz_value']);
$tzoffset = $current_tz->getOffset($dt);
$offset = self::formatOffset($tzoffset);
$site_content = "<?php\n defined('DATEFORMAT_PHP') || define('DATEFORMAT_PHP','" . $site_data['date_format'] . "');\n defined('DATEFORMAT_MYSQL') || define('DATEFORMAT_MYSQL','" . $site_data['mysql_dateformat'] . "');\n defined('DATEFORMAT_JS') || define('DATEFORMAT_JS','" . $site_data['js_dateformat'] . "');\n defined('DATE_DESCRIPTION') || define('DATE_DESCRIPTION','" . $site_data['date_description'] . "');\n defined('TIME_FORMAT') || define('TIME_FORMAT','" . $site_data['time_format'] . "'); \n defined('TIMEZONE_OFFSET') || define('TIMEZONE_OFFSET','" . $offset . "'); \n defined('CURRENCY_FORMAT') || define('CURRENCY_FORMAT','" . $site_data['currency'] . "');\n defined('PASSWORD_FORMAT') || define('PASSWORD_FORMAT','" . $site_data['passwordtype'] . "');\n ?>";
try {
$handle = fopen($filename, "w+");
fwrite($handle, trim($site_content));
fclose($handle);
} catch (Exception $e) {
}
}
}