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 init()
{
$this->setMethod('post');
$this->setAttrib('action', BASE_URL . 'businessunits/edit');
$this->setAttrib('id', 'formid');
$this->setAttrib('name', 'businessunits');
$id = new Zend_Form_Element_Hidden('id');
$unitname = new Zend_Form_Element_Text('unitname');
$unitname->setAttrib('maxLength', 50);
$unitname->addFilter(new Zend_Filter_StringTrim());
$unitname->setRequired(true);
$unitname->addValidator('NotEmpty', false, array('messages' => 'Please enter name.'));
$unitname->addValidator("regex", true, array('pattern' => '/^(?![0-9]{4})[a-zA-Z0-9.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid name.')));
$unitname->addValidator(new Zend_Validate_Db_NoRecordExists(array('table' => 'main_businessunits', 'field' => 'unitname', 'exclude' => 'id!="' . Zend_Controller_Front::getInstance()->getRequest()->getParam('id') . '" and isactive=1')));
$unitname->getValidator('Db_NoRecordExists')->setMessage('Name already exists.');
$unitcode = new Zend_Form_Element_Text('unitcode');
$unitcode->addFilter(new Zend_Filter_StringTrim());
$unitcode->setRequired(true);
$unitcode->setAttrib("maxlength", 4);
$unitcode->addValidator('NotEmpty', false, array('messages' => 'Please enter code.'));
$unitcode->addValidators(array(array('StringLength', false, array('min' => 2, 'max' => 4, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Code must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Code must contain at least %min% characters.')))));
$unitcode->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[a-zA-Z0-9\\&\'\\.\\s]+$/', 'messages' => array(Zend_Validate_Regex::NOT_MATCH => 'Please enter valid code.')))));
$unitcode->addValidator(new Zend_Validate_Db_NoRecordExists(array('table' => 'main_businessunits', 'field' => 'unitcode', 'exclude' => 'id!="' . Zend_Controller_Front::getInstance()->getRequest()->getParam('id') . '" and isactive=1')));
$unitcode->getValidator('Db_NoRecordExists')->setMessage('Code already exists.');
$description = new Zend_Form_Element_Textarea('description');
$description->setAttrib('rows', 10);
$description->setAttrib('cols', 50);
$start_date = new ZendX_JQuery_Form_Element_DatePicker('start_date');
$start_date->setAttrib('readonly', 'true');
$start_date->setAttrib('onfocus', 'this.blur()');
$start_date->setOptions(array('class' => 'brdr_none'));
$country = new Zend_Form_Element_Select('country');
$country->setLabel('country');
$country->setRequired(true);
$country->addValidator('NotEmpty', false, array('messages' => 'Please select country.'));
$country->setAttrib('onchange', 'displayParticularState_normal(this,"state","state","city")');
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
$country->addMultiOption('', 'Select country');
foreach ($countriesData->toArray() as $data) {
$country->addMultiOption($data['country_id_org'], $data['country']);
}
$country->setRegisterInArrayValidator(false);
$state = new Zend_Form_Element_Select('state');
$state->setAttrib('onchange', 'displayParticularCity_normal(this,"city","city","")');
$state->setRegisterInArrayValidator(false);
$state->addMultiOption('', 'Select State');
$state->setRequired(true);
$state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
$city = new Zend_Form_Element_Select('city');
$city->setAttrib('class', 'selectoption');
$city->setAttrib('onchange', 'displayCityCode(this)');
$city->setRegisterInArrayValidator(false);
$city->addMultiOption('', 'Select City');
$city->setRequired(true);
$city->addValidator('NotEmpty', false, array('messages' => 'Please select city.'));
$address1 = new Zend_Form_Element_Textarea('address1');
$address1->setAttrib('rows', 10);
$address1->setAttrib('cols', 50);
$address1->setRequired(true);
$address1->addValidator('NotEmpty', false, array('messages' => 'Please enter street address.'));
$address2 = new Zend_Form_Element_Textarea('address2');
$address2->setAttrib('rows', 10);
$address2->setAttrib('cols', 50);
$address3 = new Zend_Form_Element_Textarea('address3');
$address3->setAttrib('rows', 10);
$address3->setAttrib('cols', 50);
$timezone = new Zend_Form_Element_Select('timezone');
$timezone->setLabel('timezone');
$timezone->setRequired(true);
$timezone->addValidator('NotEmpty', false, array('messages' => 'Please select time zone.'));
$timezoneModel = new Default_Model_Timezone();
$timezonedata = $timezoneModel->fetchAll('isactive=1', 'timezone');
$timezone->addMultiOption('', 'Select Time zone');
foreach ($timezonedata->toArray() as $data) {
$timezone->addMultiOption($data['id'], $data['timezone'] . ' [' . $data['timezone_abbr'] . ']');
}
$timezone->setRegisterInArrayValidator(false);
$unithead = new Zend_Form_Element_Text('unithead');
$unithead->setLabel('timezone');
$unithead->setAttrib('maxlength', '50');
$unithead->addValidator("regex", true, array('pattern' => '/^[a-zA-Z.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid name.')));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$submit->setLabel('Save');
$this->addElements(array($id, $unitname, $unitcode, $description, $start_date, $country, $state, $city, $address1, $address2, $address3, $timezone, $unithead, $submit));
$this->setElementDecorators(array('ViewHelper'));
$this->setElementDecorators(array('UiWidgetElement'), array('start_date'));
}
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 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 departmentsAction()
{
$form = new Default_Form_departmentsreport();
$reportsmodel = new Default_Model_Reports();
$msgarray = array();
$selectColumns = array();
$searchQuery = '';
$deptname = intval($this->_request->getParam('deptname'));
$dcode = intval($this->_request->getParam('dcode'));
$bunitname = $this->_request->getParam('bunitname');
$startdate = $this->_request->getParam('startdate');
$country = $this->_request->getParam('country');
$pageno = intval($this->_request->getParam('pageno', 1));
$perpage = intval($this->_request->getParam('perpage', PERPAGE));
if ($perpage == 0) {
$perpage = PERPAGE;
}
$by = $this->_request->getParam('by', 'Desc');
$sortby = $this->_request->getParam('sortby', 'd.modifieddate');
$columnby = $this->_request->getParam('columnby');
$columnsortby = $this->_request->getParam('columnsortby');
$funorder = '';
$checkedheaders = $this->_request->getParam('checkedheaders');
$gr = $this->_request->getParam('generatereport');
if ($gr == 'pdf' || $gr == 'excel') {
$bunitname = intval($this->_request->getParam('hiddenbuname'));
$dcode = intval($this->_request->getParam('hiddendeptcode'));
$deptname = intval($this->_request->getParam('hiddendeptname'));
}
if ($checkedheaders != '') {
$selectColumns = explode(',', $checkedheaders);
}
if ($columnby != '') {
$by = $columnby;
}
if ($columnsortby != '') {
$sortby = $columnsortby;
}
if ($deptname != '') {
$searchQuery .= 'd.id = "' . $deptname . '" AND ';
}
if (isset($bunitname) && $bunitname != '') {
$searchQuery .= 'd.unitid = "' . $bunitname . '" AND ';
}
if ($dcode != '') {
$searchQuery .= 'd.id = "' . $dcode . '" AND ';
}
if ($country != '') {
$searchQuery .= 'd.country = ' . $country . ' AND ';
}
if ($startdate != '') {
$startdate = sapp_Global::change_date($startdate, 'database');
$searchQuery .= 'DATE(d.startdate) = "' . $startdate . '" AND ';
}
$searchQuery = rtrim($searchQuery, " AND");
$selectColumnLabels = array();
$DepartmentLabelsArr = array('deptname' => 'Department', 'deptcode' => 'Code', 'unitname' => 'Business Unit', 'startdate' => 'Started on', 'empcount' => '# Emp', 'address' => 'Address', 'ccity' => 'City', 'sstate' => 'State', 'ccountry' => 'Country', 'status' => 'Status');
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country')->toArray();
if (!empty($countriesData)) {
$form->country->addMultiOption('', 'All');
foreach ($countriesData as $data) {
$form->country->addMultiOption($data['country_id_org'], $data['country']);
}
} else {
$form->country->addMultiOption('', 'Select Country');
$msgarray['country'] = 'Countries are not configured yet';
}
if (empty($selectColumns)) {
$selectColumns = array('deptname', 'deptcode', 'unitname', 'startdate', 'empcount', 'address', 'ccity', 'sstate', 'ccountry', 'status');
$selectColumnLabels = $DepartmentLabelsArr;
} else {
foreach ($DepartmentLabelsArr as $key => $val) {
foreach ($selectColumns as $column) {
if ($column == $key) {
$selectColumnLabels[$key] = $val;
}
}
}
}
/* Column sort for city state country */
if ($sortby == 'unitname') {
$buOrder = $reportsmodel->getBusinessunitOrder($by);
if (!empty($buOrder)) {
$inId = implode(',', $buOrder);
$funorder = 'FIND_IN_SET(d.unitid,"' . $inId . '")';
}
}
if ($sortby == 'ccity') {
$cityorder = $reportsmodel->getCityOrder($by);
if (!empty($cityorder)) {
$inId = implode(',', $cityorder);
$funorder = 'FIND_IN_SET(d.city,"' . $inId . '")';
}
}
if ($sortby == 'sstate') {
$stateorder = $reportsmodel->getStateOrder($by);
if (!empty($stateorder)) {
$inId = implode(',', $stateorder);
$funorder = 'FIND_IN_SET(d.state,"' . $inId . '")';
}
}
/* END */
$departmentsArr = $reportsmodel->getDepartmentsInfo($sortby, $by, $pageno, $perpage, $searchQuery, $funorder);
$departmentsCount = $reportsmodel->getDepartmentsCount($searchQuery);
if ($departmentsCount > 0) {
$lastpage = ceil($departmentsCount / $perpage);
} else {
$lastpage = '';
$departmentsCount = '';
}
$finalArray = $this->createDepartmentsReportFinalArray($departmentsArr, $selectColumns);
$departmentsArr = $finalArray;
if ($this->getRequest()->getPost()) {
if ($this->_request->getParam('generatereport') == 'pdf') {
} else {
if ($this->_request->getParam('generatereport') == 'excel') {
$this->generateExcel($departmentsArr, $selectColumns, $DepartmentLabelsArr);
return;
}
}
}
$this->view->selectColumnLabels = $selectColumnLabels;
$this->view->departmentLabelsArr = $DepartmentLabelsArr;
$this->view->departmentsArr = $departmentsArr;
$this->view->pageno = $pageno;
$this->view->perpage = $perpage;
$this->view->lastpage = $lastpage;
$this->view->by = $by;
$this->view->sortby = $sortby;
$this->view->totalcount = $departmentsCount;
$this->view->msgarray = $msgarray;
$this->view->form = $form;
}
public function init()
{
$this->setMethod('post');
$this->setAttrib('id', 'formid');
$this->setAttrib('enctype', 'multipart/form-data');
$this->setAttrib('name', 'organisationinfo');
$this->setAttrib('action', DOMAIN . 'organisationinfo/edit');
$id = new Zend_Form_Element_Hidden('id');
$orgname = new Zend_Form_Element_Text('organisationname');
$orgname->setAttrib('maxLength', 50);
$orgname->addFilter(new Zend_Filter_StringTrim());
$orgname->setRequired(true);
$orgname->addValidator('NotEmpty', false, array('messages' => 'Please enter organization name.'));
$orgname->addValidator("regex", true, array('pattern' => '/^[a-zA-Z0-9.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid organization name.')));
$domain = new Zend_Form_Element_Multiselect('domain');
$domain->setLabel('domain')->setMultiOptions(array('1' => 'Admin/Secretarial', '2' => 'Customer Service/ Call Centre/ BPO', '3' => 'Finance & Accounts', '4' => 'Human Resources', '5' => 'IT', '6' => 'Legal', '7' => 'Marketing & Communications', '8' => 'Purchase/ Logistics/ Supply Chain', '9' => 'Sales/ Business Development', '10' => 'Sales & Marketing & Advertisement'));
$org_image_value = new Zend_Form_Element_Hidden('org_image_value');
$imgerr = new Zend_Form_Element_Hidden('imgerr');
$imgerrmsg = new Zend_Form_Element_Hidden('imgerrmsg');
$orgdescription = new Zend_Form_Element_Textarea('orgdescription');
$orgdescription->setAttrib('rows', 10);
$orgdescription->setAttrib('cols', 50);
$website = new Zend_Form_Element_Text('website');
$website->setAttrib('maxLength', 50);
$website->addFilter(new Zend_Filter_StringTrim());
$website->setRequired(true);
$website->addValidator('NotEmpty', false, array('messages' => 'Please enter website.'));
$website->addValidator(new Zend_Validate_Uri());
$totalemployees = new Zend_Form_Element_Select('totalemployees');
$totalemployees->setRegisterInArrayValidator(false);
$totalemployees->setMultiOptions(array('1' => '20-50', '2' => '51-100', '3' => '101-500', '4' => '501 -1000', '5' => '> 1000'));
$totalemployees->setRequired(true);
$totalemployees->addValidator('NotEmpty', false, array('messages' => 'Please enter total employees.'));
$org_startdate = new ZendX_JQuery_Form_Element_DatePicker('org_startdate');
$org_startdate->setAttrib('readonly', 'true');
$org_startdate->setAttrib('onfocus', 'this.blur()');
$org_startdate->setOptions(array('class' => 'brdr_none'));
$phonenumber = new Zend_Form_Element_Text('phonenumber');
$phonenumber->addFilter(new Zend_Filter_StringTrim());
$phonenumber->setAttrib('maxLength', 15);
$phonenumber->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Phone number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Phone number must contain at least %min% characters.')))));
$phonenumber->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid phone number.')))));
$secondaryphone = new Zend_Form_Element_Text('secondaryphone');
$secondaryphone->setAttrib('maxLength', 15);
$secondaryphone->addFilter(new Zend_Filter_StringTrim());
$secondaryphone->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Secondary phone number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Secondary phone number must contain at least %min% characters.')))));
$secondaryphone->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid phone number.')))));
$faxnumber = new Zend_Form_Element_Text('faxnumber');
$faxnumber->setAttrib('maxLength', 15);
$faxnumber->addFilter(new Zend_Filter_StringTrim());
$faxnumber->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Fax number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Fax number must contain at least %min% characters.')))));
$faxnumber->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid fax number.')))));
$country = new Zend_Form_Element_Select('country');
$country->setLabel('country');
$country->setRequired(true);
$country->addValidator('NotEmpty', false, array('messages' => 'Please select country.'));
$country->setAttrib('onchange', 'displayParticularState(this,"state","state","")');
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
$country->addMultiOption('', 'Select country');
foreach ($countriesData->toArray() as $data) {
$country->addMultiOption($data['country_id_org'], $data['country']);
}
$country->setRegisterInArrayValidator(false);
$state = new Zend_Form_Element_Select('state');
$state->setAttrib('class', 'selectoption');
$state->setAttrib('onchange', 'displayParticularCity(this,"city","city","")');
$state->setRegisterInArrayValidator(false);
$state->addMultiOption('', 'Select State');
$state->setRequired(true);
$state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
$city = new Zend_Form_Element_Select('city');
$city->setAttrib('class', 'selectoption');
$city->setAttrib('onchange', 'displayCityCode(this)');
$city->setRegisterInArrayValidator(false);
$city->addMultiOption('', 'Select City');
$city->setRequired(true);
$city->addValidator('NotEmpty', false, array('messages' => 'Please select city.'));
$address1 = new Zend_Form_Element_Textarea('address1');
$address1->setAttrib('rows', 10);
$address1->setAttrib('cols', 50);
$address2 = new Zend_Form_Element_Textarea('address2');
$address2->setAttrib('rows', 10);
$address2->setAttrib('cols', 50);
$address3 = new Zend_Form_Element_Textarea('address3');
$address3->setAttrib('rows', 10);
$address3->setAttrib('cols', 50);
$description = new Zend_Form_Element_Textarea('description');
$description->setAttrib('rows', 10);
$description->setAttrib('cols', 50);
$designation = new Zend_Form_Element_Text('designation');
$designation->setAttrib('maxLength', 50);
$designation->addFilter(new Zend_Filter_StringTrim());
$designation->addValidator("regex", true, array('pattern' => '/^[a-zA-Z.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid designation.')));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$submit->setLabel('Save');
$this->addElements(array($id, $orgname, $imgerrmsg, $imgerr, $org_image_value, $domain, $orgdescription, $website, $totalemployees, $org_startdate, $phonenumber, $secondaryphone, $faxnumber, $country, $state, $city, $address1, $address2, $address3, $description, $designation, $submit));
//$email,$secondaryemail,
$this->setElementDecorators(array('ViewHelper'));
$this->setElementDecorators(array('File'), array('org_image'));
$this->setElementDecorators(array('UiWidgetElement'), array('org_startdate', 'date_of_joining'));
}
public function init()
{
$this->setMethod('post');
$this->setAttrib('id', 'formid');
$this->setAttrib('enctype', 'multipart/form-data');
$this->setAttrib('name', 'organisationinfo');
$this->setAttrib('action', DOMAIN . 'organisationinfo/edit');
$id = new Zend_Form_Element_Hidden('id');
$orgname = new Zend_Form_Element_Text('organisationname');
$orgname->setAttrib('maxLength', 50);
$orgname->addFilter(new Zend_Filter_StringTrim());
$orgname->setRequired(true);
$orgname->addValidator('NotEmpty', false, array('messages' => 'Please enter organization name.'));
$orgname->addValidator("regex", true, array('pattern' => '/^[a-zA-Z0-9.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid organization name.')));
$domain = new Zend_Form_Element_Multiselect('domain');
$domain->setRequired(true);
$domain->addValidator('NotEmpty', false, array('messages' => 'Please select domain.'));
$domain->setLabel('domain')->setMultiOptions(array('1' => 'Admin/Secretarial', '2' => 'Customer Service/ Call Centre/ BPO', '3' => 'Finance & Accounts', '4' => 'Human Resources', '5' => 'IT', '6' => 'Legal', '7' => 'Marketing & Communications', '8' => 'Purchase/ Logistics/ Supply Chain', '9' => 'Sales/ Business Development', '10' => 'Sales & Marketing & Advertisement'));
$org_image_value = new Zend_Form_Element_Hidden('org_image_value');
$imgerr = new Zend_Form_Element_Hidden('imgerr');
$imgerrmsg = new Zend_Form_Element_Hidden('imgerrmsg');
$orgdescription = new Zend_Form_Element_Textarea('orgdescription');
$orgdescription->setAttrib('rows', 10);
$orgdescription->setAttrib('cols', 50);
$orgdescription->setRequired(true);
$orgdescription->addValidator('NotEmpty', false, array('messages' => 'Please enter organization description.'));
$website = new Zend_Form_Element_Text('website');
$website->setAttrib('maxLength', 50);
$website->addFilter(new Zend_Filter_StringTrim());
$website->setRequired(true);
$website->addValidator('NotEmpty', false, array('messages' => 'Please enter website.'));
$website->addValidator(new Zend_Validate_Uri());
$totalemployees = new Zend_Form_Element_Select('totalemployees');
$totalemployees->setRegisterInArrayValidator(false);
$totalemployees->setMultiOptions(array('1' => '20-50', '2' => '51-100', '3' => '101-500', '4' => '501 -1000', '5' => '> 1000'));
$totalemployees->setRequired(true);
$totalemployees->addValidator('NotEmpty', false, array('messages' => 'Please enter total employees.'));
$org_startdate = new ZendX_JQuery_Form_Element_DatePicker('org_startdate');
$org_startdate->setAttrib('readonly', 'true');
$org_startdate->setAttrib('onfocus', 'this.blur()');
$org_startdate->setOptions(array('class' => 'brdr_none'));
$phonenumber = new Zend_Form_Element_Text('phonenumber');
$phonenumber->addFilter(new Zend_Filter_StringTrim());
$phonenumber->setRequired(true);
$phonenumber->setAttrib('maxLength', 15);
$phonenumber->addValidator('NotEmpty', false, array('messages' => 'Please enter phone number.'));
$phonenumber->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Phone number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Phone number must contain at least %min% characters.')))));
$phonenumber->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid phone number.')))));
$secondaryphone = new Zend_Form_Element_Text('secondaryphone');
$secondaryphone->setAttrib('maxLength', 15);
$secondaryphone->addFilter(new Zend_Filter_StringTrim());
$secondaryphone->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Secondary phone number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Secondary phone number must contain at least %min% characters.')))));
$secondaryphone->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid phone number.')))));
$faxnumber = new Zend_Form_Element_Text('faxnumber');
$faxnumber->setAttrib('maxLength', 15);
$faxnumber->addFilter(new Zend_Filter_StringTrim());
$faxnumber->addValidators(array(array('StringLength', false, array('min' => 10, 'max' => 15, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Fax number must contain at most %max% characters.', Zend_Validate_StringLength::TOO_SHORT => 'Fax number must contain at least %min% characters.')))));
$faxnumber->addValidators(array(array('validator' => 'Regex', 'breakChainOnFailure' => true, 'options' => array('pattern' => '/^[0-9-]+$/i', 'messages' => array('regexNotMatch' => 'Please enter valid fax number.')))));
$country = new Zend_Form_Element_Select('country');
$country->setLabel('country');
$country->setRequired(true);
$country->addValidator('NotEmpty', false, array('messages' => 'Please select country.'));
$country->setAttrib('onchange', 'displayParticularState(this,"state","state","")');
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
$country->addMultiOption('', 'Select country');
foreach ($countriesData->toArray() as $data) {
$country->addMultiOption($data['country_id_org'], $data['country']);
}
$country->setRegisterInArrayValidator(false);
$state = new Zend_Form_Element_Select('state');
$state->setAttrib('class', 'selectoption');
$state->setAttrib('onchange', 'displayParticularCity(this,"city","city","")');
$state->setRegisterInArrayValidator(false);
$state->addMultiOption('', 'Select State');
$state->setRequired(true);
$state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
$city = new Zend_Form_Element_Select('city');
$city->setAttrib('class', 'selectoption');
$city->setAttrib('onchange', 'displayCityCode(this)');
$city->setRegisterInArrayValidator(false);
$city->addMultiOption('', 'Select City');
$city->setRequired(true);
$city->addValidator('NotEmpty', false, array('messages' => 'Please select city.'));
$address1 = new Zend_Form_Element_Textarea('address1');
$address1->setAttrib('rows', 10);
$address1->setAttrib('cols', 50);
$address1->setRequired(true);
$address1->addValidator('NotEmpty', false, array('messages' => 'Please enter main branch address.'));
$address2 = new Zend_Form_Element_Textarea('address2');
$address2->setAttrib('rows', 10);
$address2->setAttrib('cols', 50);
$address3 = new Zend_Form_Element_Textarea('address3');
$address3->setAttrib('rows', 10);
$address3->setAttrib('cols', 50);
$description = new Zend_Form_Element_Textarea('description');
$description->setAttrib('rows', 10);
$description->setAttrib('cols', 50);
$orghead = new Zend_Form_Element_Select('orghead');
$orghead->setLabel('orghead');
$orghead->setRequired(true);
$orghead->addValidator('NotEmpty', false, array('messages' => 'Please select organization head.'));
$orghead->setAttrib('onchange', 'getdetailsoforghead(this)');
$orghead->setRegisterInArrayValidator(false);
$prevorgheadrm = new Zend_Form_Element_Select('prevorgheadrm');
$prevorgheadrm->setLabel('orghead');
$prevorgheadrm->setRegisterInArrayValidator(false);
$rmflag = Zend_Controller_Front::getInstance()->getRequest()->getParam('rmflag', null);
if ($rmflag == '1') {
$prevorgheadrm->setRequired(true);
$prevorgheadrm->addValidator('NotEmpty', false, array('messages' => 'Please select reporting manager for current organization head.'));
}
$designation = new Zend_Form_Element_Text('designation');
$designation->setAttrib('maxLength', 50);
$designation->addFilter(new Zend_Filter_StringTrim());
$designation->addValidator("regex", true, array('pattern' => '/^[a-zA-Z.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid designation.')));
$employeeId = new Zend_Form_Element_Text("employeeId");
$employeeId->setRequired("true");
$employeeId->setLabel("Employee ID");
$employeeId->setAttrib("class", "formDataElement");
$employeeId->setAttrib("readonly", "readonly");
$employeeId->setAttrib('onfocus', 'this.blur()');
$employeeId->addValidator('NotEmpty', false, array('messages' => 'Identity codes are not configured yet.'));
$prefix_id = new Zend_Form_Element_Select('prefix_id');
$prefix_id->setLabel("Prefix");
$prefix_id->setRegisterInArrayValidator(false);
$emprole = new Zend_Form_Element_Select("emprole");
$emprole->setRegisterInArrayValidator(false);
$emprole->setRequired(true);
$emprole->setLabel("Role");
$emprole->setAttrib("class", "formDataElement");
$emprole->addValidator('NotEmpty', false, array('messages' => 'Please select role.'));
$emailaddress = new Zend_Form_Element_Text("emailaddress");
$emailaddress->setRequired(true);
$emailaddress->addValidator('NotEmpty', false, array('messages' => 'Please enter email.'));
$emailaddress->addValidator("regex", true, array('pattern' => '/^(?!.*\\.{2})[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\\.[a-zA-Z0-9-.]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid email.')));
$emailaddress->setLabel("Email");
$emailaddress->setAttrib("class", "formDataElement");
$emailaddress->addValidator(new Zend_Validate_Db_NoRecordExists(array('table' => 'main_users', 'field' => 'emailaddress', 'exclude' => 'id!="' . Zend_Controller_Front::getInstance()->getRequest()->getParam('orghead', 0) . '" and isactive!=0')));
$emailaddress->getValidator('Db_NoRecordExists')->setMessage('Email already exists.');
$jobtitle = new Zend_Form_Element_Select('jobtitle_id');
$jobtitle->setLabel("Job Title");
$jobtitle->addMultiOption('', 'Select Job Title');
$jobtitle->setAttrib('onchange', 'displayPositions(this,"position_id","")');
$jobtitle->setRegisterInArrayValidator(false);
$position = new Zend_Form_Element_Select('position_id');
$position->setLabel("Position");
$position->addMultiOption('', 'Select Position');
$position->setRegisterInArrayValidator(false);
$date_of_joining = new ZendX_JQuery_Form_Element_DatePicker('date_of_joining');
$date_of_joining->setLabel("Date Of Joining");
$date_of_joining->setOptions(array('class' => 'brdr_none'));
$date_of_joining->setRequired(true);
$date_of_joining->setAttrib('readonly', 'true');
$date_of_joining->setAttrib('onfocus', 'this.blur()');
$date_of_joining->addValidator('NotEmpty', false, array('messages' => 'Please select date of joining.'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$submit->setLabel('Save');
$this->addElements(array($id, $prevorgheadrm, $orgname, $imgerrmsg, $imgerr, $org_image_value, $domain, $orgdescription, $website, $totalemployees, $org_startdate, $phonenumber, $secondaryphone, $faxnumber, $country, $state, $city, $address1, $address2, $address3, $description, $orghead, $designation, $employeeId, $prefix_id, $emprole, $emailaddress, $jobtitle, $position, $date_of_joining, $submit));
//$email,$secondaryemail,
$this->setElementDecorators(array('ViewHelper'));
$this->setElementDecorators(array('File'), array('org_image'));
$this->setElementDecorators(array('UiWidgetElement'), array('org_startdate', 'date_of_joining'));
}
public function init()
{
$this->setMethod('post');
$this->setAttrib('id', 'formid');
$this->setAttrib('name', 'frm_sinterview_rounds');
$id = new Zend_Form_Element_Hidden('id');
$req_id = new Zend_Form_Element_Select("req_id");
$req_id->setRegisterInArrayValidator(false);
$req_id->setRequired(true);
$req_id->setAttrib("class", "formDataElement");
$req_id->addValidator('NotEmpty', false, array('messages' => 'Please select requisition id.'));
$req_id->setAttrib('title', 'Interviewer');
$req_id->setAttrib('onchange', 'displayParticularCandidates(this,"")');
$candidate_name = new Zend_Form_Element_Select('candidate_name');
$candidate_name->setAttrib('title', 'Candidate Name');
$candidate_name->addFilter(new Zend_Filter_StringTrim());
$candidate_name->setRequired(true);
$candidate_name->addValidator('NotEmpty', false, array('messages' => 'Please select candidate.'));
$candidate_name->addMultiOption('', 'Select candidate');
$candidate_name->setRegisterInArrayValidator(false);
$interviewer_id = new Zend_Form_Element_Select("interviewer_id");
$interviewer_id->setRegisterInArrayValidator(false);
$interviewer_id->setAttrib("class", "formDataElement");
$interviewer_id->setAttrib('title', 'Interviewer');
$interview_mode = new Zend_Form_Element_Select("interview_mode");
$interview_mode->setRegisterInArrayValidator(true);
$interview_mode->setAttrib("class", "formDataElement");
$interview_mode->addMultiOptions(array('' => 'Select Interview Type', 'In person' => 'In person', 'Phone' => 'Phone', 'Video conference' => 'Video conference'));
$interview_mode->setAttrib('title', 'Interview Type');
$int_location = new Zend_Form_Element_Text('int_location');
$int_location->setAttrib('maxLength', 100);
$int_location->setAttrib('title', 'Location');
$int_location->addFilter(new Zend_Filter_StringTrim());
$job_title = new Zend_Form_Element_Text('job_title');
$job_title->setAttrib('readonly', 'readonly');
$country = new Zend_Form_Element_Select('country');
$country->setLabel('country');
$country->setAttrib('onchange', 'displayParticularState_normal(this,"state","state","city")');
$country->setRegisterInArrayValidator(false);
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
$country->addMultiOption('', 'Select country');
foreach ($countriesData->toArray() as $data) {
$country->addMultiOption(trim($data['country_id_org']), $data['country']);
}
$state = new Zend_Form_Element_Select('state');
$state->setAttrib('onchange', 'displayParticularCity_normal(this,"city","city","")');
$state->setRegisterInArrayValidator(false);
$state->addMultiOption('', 'Select State');
$city = new Zend_Form_Element_Select('city');
$city->setAttrib('class', 'selectoption');
$city->setAttrib('onchange', 'displayCityCode(this)');
$city->setRegisterInArrayValidator(false);
$city->addMultiOption('', 'Select City');
$interview_time = new Zend_Form_Element_Text('interview_time');
$interview_time->setAttrib('title', 'Interview Time');
$interview_time->setAttrib('readonly', 'readonly');
$interview_time->setAttrib('onfocus', 'this.blur()');
$interview_time->setAttrib('class', 'time');
$interview_time->addFilter(new Zend_Filter_StringTrim());
$interview_date = new Zend_Form_Element_Text('interview_date');
$interview_date->setAttrib('readonly', 'readonly');
$interview_date->setAttrib('onfocus', 'this.blur()');
$interview_date->setAttrib('title', 'Interview Date');
$interview_date->addFilter(new Zend_Filter_StringTrim());
$interview_round = new Zend_Form_Element_Text('interview_round');
$interview_round->setAttrib('title', 'Interview Round');
$interview_round->addFilter(new Zend_Filter_StringTrim());
$interview_round->setAttrib('maxlength', 45);
$interview_feedback = new Zend_Form_Element_Textarea('interview_feedback');
$interview_feedback->setAttrib('rows', 10);
$interview_feedback->setAttrib('cols', 50);
$interview_feedback->setAttrib('maxlength', 300);
$interview_feedback->setAttrib('title', 'Feedback.');
$interview_comments = new Zend_Form_Element_Textarea('interview_comments');
$interview_comments->setAttrib('rows', 10);
$interview_comments->setAttrib('cols', 50);
$interview_comments->setAttrib('maxlength', 300);
$interview_comments->setAttrib('title', 'Comments.');
$round_status = new Zend_Form_Element_Select('round_status');
$round_status->setRegisterInArrayValidator(false);
$round_status->setLabel('Round status');
$round_status->addMultiOptions(array('' => 'Select status', 'Schedule for next round' => 'Schedule for next round', 'Qualified' => 'Qualified', 'Selected' => 'Selected', 'Disqualified' => 'Disqualified', 'Incompetent' => 'Incompetent', 'Ineligible' => 'Ineligible', 'Candidate no show' => 'Candidate no show'));
$hid_round_status_val = Zend_Controller_Front::getInstance()->getRequest()->getParam('hid_round_status', null);
$interview_status = new Zend_Form_Element_Select('interview_status');
$interview_status->setLabel('Interview status')->setMultiOptions(array('' => 'Select status', 'In process' => 'In process', 'Completed' => 'Complete', 'On hold' => 'On hold'));
$interview_status->setRegisterInArrayValidator(false);
$cand_status = new Zend_Form_Element_Select('cand_status');
$cand_status->setLabel('Candidate status')->setMultiOptions(array('' => 'Select status'));
$cand_status->setRegisterInArrayValidator(false);
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$intrvid_val = Zend_Controller_Front::getInstance()->getRequest()->getParam('intrvid', null);
if ($loginuserGroup == MANAGER_GROUP || $loginuserGroup == EMPLOYEE_GROUP || $loginuserGroup == SYSTEMADMIN_GROUP || ($loginuserGroup == HR_GROUP || $loginuserGroup == MANAGEMENT_GROUP) && $intrvid_val == $loginUserId) {
$round_status->setRequired(true);
$round_status->addValidator('NotEmpty', false, array('messages' => 'Please select status.'));
$interview_comments->setRequired(true);
$interview_comments->addValidator('NotEmpty', false, array('messages' => 'Please select comments.'));
$interview_feedback->setRequired(true);
$interview_feedback->addValidator('NotEmpty', false, array('messages' => 'Please select feedback.'));
}
if (($loginuserGroup == HR_GROUP || $loginuserGroup == MANAGEMENT_GROUP || $loginuserGroup == '') && $intrvid_val != $loginUserId) {
if ($hid_round_status_val != '' && ($loginuserGroup == HR_GROUP || $loginuserGroup == MANAGEMENT_GROUP || $loginuserGroup == '')) {
$round_status->setRequired(true);
$round_status->addValidator('NotEmpty', false, array('messages' => 'Please select status.'));
} else {
$interview_status->setRequired(true);
$interview_status->addValidator('NotEmpty', false, array('messages' => 'Please select interview status.'));
$cand_status->setRequired(true);
$cand_status->addValidator('NotEmpty', false, array('messages' => 'Please select candidate status.'));
$interviewer_id->setRequired(true);
$interviewer_id->addValidator('NotEmpty', false, array('messages' => 'Please select interviewer.'));
$interview_mode->setRequired(true);
$interview_mode->addValidator('NotEmpty', false, array('messages' => 'Please select interview type.'));
$int_location->setRequired(true);
$int_location->addValidator('NotEmpty', false, array('messages' => 'Please enter location.'));
$country->setRequired(true);
$country->addValidator('NotEmpty', false, array('messages' => 'Please select country.'));
$state->setRequired(true);
$state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
$city->setRequired(true);
$city->addValidator('NotEmpty', false, array('messages' => 'Please select city.'));
$interview_time->setRequired(true);
$interview_time->addValidator('NotEmpty', false, array('messages' => 'Please select interview time.'));
$interview_date->setRequired(true);
$interview_date->addValidator('NotEmpty', false, array('messages' => 'Please select interview date.'));
$interview_round->setRequired(true);
$interview_round->addValidator('NotEmpty', false, array('messages' => 'Please select interview name.'));
}
}
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$submit->setLabel('Update');
$int_location->addValidator("regex", true, array('pattern' => '/^[a-zA-Z.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please enter valid location.')));
$interview_round->addValidator("regex", true, array('pattern' => '/^[0-9a-zA-Z.\\- ?]+$/', 'messages' => array('regexNotMatch' => 'Please select valid interview name.')));
$this->addElements(array($req_id, $id, $candidate_name, $job_title, $interviewer_id, $interview_mode, $int_location, $country, $state, $city, $interview_time, $interview_date, $round_status, $interview_feedback, $interview_comments, $interview_round, $interview_status, $cand_status, $submit));
$this->setElementDecorators(array('ViewHelper'));
}
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;
}
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');
$callval = $this->getRequest()->getParam('call');
$countriesform = new Default_Form_countries();
$countriesmodel = new Default_Model_Countries();
$countriesform->setAction(BASE_URL . 'countries/addpopup');
$controllername = 'countries';
if ($this->getRequest()->getPost()) {
$id = $this->_request->getParam('id');
$errorflag = "true";
$msgarray = array();
$dbcountry = '';
$dbcountryid = '';
$country = $this->_request->getParam('country');
$othercountry = $this->_request->getParam('othercountry');
$countrycode = $this->_request->getParam('countrycode');
$citizenship = $this->_request->getParam('citizenship');
if ($country == 'other') {
if ($othercountry == '') {
$msgarray['othercountry'] = "Please enter other country";
$errorflag = "false";
} else {
$isduplicatecountrynameArr = $countriesmodel->getDuplicateCountryName($othercountry);
if ($isduplicatecountrynameArr[0]['count'] > 0) {
$errorflag = "false";
$msgarray['othercountry'] = "Country already exists";
$msgarray['othercountryname'] = $othercountry;
} else {
if (!preg_match('/^[^ ][a-z0-9 ]*$/i', $othercountry)) {
$errorflag = "false";
$msgarray['othercountry'] = "Please enter valid country name.";
$msgarray['othercountryname'] = $othercountry;
} else {
$dbcountry = $othercountry;
$errorflag = "true";
}
}
}
} else {
$countrynamearr = $countriesmodel->getCountryCode($country);
if (!empty($countrynamearr)) {
$dbcountry = $countrynamearr[0]['country_name'];
$dbcountryid = $countrynamearr[0]['id'];
$errorflag = "true";
} else {
$msgarray['country'] = $dbcountry . " already added";
$errorflag = "false";
}
}
if ($countriesform->isValid($this->_request->getPost()) && $errorflag == "true") {
$date = new Zend_Date();
$actionflag = '';
$tableid = '';
if ($country == 'other') {
if ($othercountry != '' && $countrycode != '') {
$countryID = $countriesmodel->SaveMainCountryData($othercountry, $countrycode);
}
}
$data = array('country' => trim($dbcountry), 'countrycode' => trim($countrycode), 'citizenship' => NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'country_id_org' => $dbcountryid != '' ? $dbcountryid : $countryID);
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 = $countriesmodel->SaveorUpdateCountryData($data, $where);
$tableid = $Id;
$menuID = COUNTRIES;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$countryData = $countriesmodel->fetchAll('isactive = 1', 'country')->toArray();
$opt = '';
foreach ($countryData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['country_id_org'], $record['country']);
}
$this->view->countryData = $opt;
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$messages = $countriesform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$this->view->msgarray = $msgarray;
}
}
$this->view->ermsg = '';
$this->view->form = $countriesform;
$this->view->controllername = $controllername;
}
public function viewpopupAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$cand_model = new Default_Model_Candidatedetails();
$requi_model = new Default_Model_Requisition();
$jobtitleModel = new Default_Model_Jobtitles();
$intrvwModel = new Default_Model_Interviewdetails();
$interview_round_model = new Default_Model_Interviewrounddetails();
$user_model = new Default_Model_Usermanagement();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$jobtitle = '';
$deptid = $this->getRequest()->getParam('deptid');
if ($deptid == '') {
$deptid = $this->getRequest()->getParam('deptidform');
}
$intId = $this->getRequest()->getParam('unitId');
$roundId = $this->getRequest()->getParam('id');
$ir_form = new Default_Form_Interviewrounds();
$elements = $ir_form->getElements();
//giving only for hr,management and super admin
if ($loginuserGroup == HR_GROUP || $loginuserGroup == '' || $loginuserGroup == MANAGEMENT_GROUP) {
$ir_form->round_status->addMultiOptions(array('Decision pending' => 'Decision pending', 'On hold' => 'On hold'));
}
if (count($elements) > 0) {
foreach ($elements as $key => $element) {
if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") {
$element->setAttrib("disabled", "disabled");
}
}
}
$intData = $intrvwModel->getReqByintrvwID($intId);
$roundData = $interview_round_model->getSingleRoundData($roundId);
$this->view->ermsg = '';
$edit_flag = 'no';
if ($roundData['interviewer_id'] == $loginUserId) {
$edit_flag = 'yes';
}
if ($loginuserGroup == MANAGER_GROUP || $loginuserGroup == HR_GROUP || $loginuserGroup == MANAGEMENT_GROUP || $loginuserGroup == '' || $loginuserGroup == EMPLOYEE_GROUP || $loginuserGroup == SYSTEMADMIN_GROUP) {
$countryId = $roundData['int_country'];
$stateId = $roundData['int_state'];
$cityId = $roundData['int_city'];
$country_name = '';
$state_name = '';
$city_name = '';
if ($countryId && $stateId) {
$statesmodel = new Default_Model_States();
$citiesmodel = new Default_Model_Cities();
$countryModal = new Default_Model_Countries();
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
foreach ($countriesData as $cdata) {
if ($roundData['int_country'] == $cdata['country_id_org']) {
$country_name = $cdata['country'];
break;
}
}
$statesData = $statesmodel->getBasicStatesList($countryId);
$citiesData = $citiesmodel->getBasicCitiesList($stateId);
foreach ($statesData as $res) {
$ir_form->state->addMultiOption($res['state_id_org'], utf8_encode($res['state']));
if ($roundData['int_state'] == $res['state_id_org']) {
$state_name = $res['state'];
}
}
foreach ($citiesData as $res) {
$ir_form->city->addMultiOption($res['city_org_id'], utf8_encode($res['city']));
if ($roundData['int_city'] == $res['city_org_id']) {
$city_name = $res['city'];
}
}
}
$interviewer_data = $user_model->getUserDataById($roundData['interviewer_id']);
$jobttlArr = $jobtitleModel->getsingleJobTitleData($interviewer_data['jobtitle_id']);
if (!empty($jobttlArr) && $jobttlArr != 'norows') {
$jobtitle = ', ' . $jobttlArr[0]['jobtitlename'];
$data['jobtitlename'] = $jobttlArr[0]['jobtitlename'];
}
$ir_form->interviewer_id->addMultiOptions(array('' => $interviewer_data['userfullname'] . $jobtitle));
$roundData['interview_date'] = sapp_Global::change_date($roundData['interview_date'], 'view');
$roundData['interview_time'] = sapp_Global::change_time($roundData['interview_time'], 'view');
$ir_form->populate($roundData);
$this->view->form = $ir_form;
$this->view->intId = $intId;
$this->view->deptid = $deptid;
$this->view->roundId = $roundId;
$this->view->ermsg = '';
$this->view->country_name = $country_name;
$this->view->state_name = $state_name;
$this->view->city_name = $city_name;
$this->view->edit_flag = $edit_flag;
} else {
$this->view->ermsg = 'nodata';
}
}
/**
* This function acts as a service for adding a interview.
* @param array $params_arr = array of parameters
* @return array Array of results.
*/
public function addinterview($params_arr)
{
$result = array();
$status = 0;
$message = "No access to add interview.";
if (isset($params_arr['role_id']) && $params_arr['role_id'] != '' && isset($params_arr['group_id']) && $params_arr['group_id'] != '' && isset($params_arr['userid']) && $params_arr['userid'] != '') {
$role_id = $params_arr['role_id'];
$group_id = $params_arr['group_id'];
$userid = $params_arr['userid'];
if ($role_id == SUPERADMINROLE || $group_id == MANAGEMENT_GROUP || $group_id == HR_GROUP) {
$privilege_flag = sapp_Global::_checkprivileges(SCHEDULEINTERVIEWS, $group_id, $role_id, 'add');
if ($privilege_flag == 'Yes') {
$status = 1;
$message = "success";
$req_model = new Default_Model_Requisition();
$countryModal = new Default_Model_Countries();
$req_data = $req_model->getReqForInterviews();
$req_options = $requisition_options = array();
$countries_options = $cntry_options = array();
foreach ($req_data as $req) {
$req_options[$req['id']] = $req['requisition_code'] . ' - ' . $req['jobtitlename'];
}
$requisition_options = array('' => 'Select Requisition ID') + $req_options;
$countriesData = $countryModal->fetchAll('isactive=1', 'country');
foreach ($countriesData->toArray() as $data) {
$cntry_options[trim($data['country_id_org'])] = $data['country'];
}
$countries_options = array('' => 'Select country') + $cntry_options;
$interview_type_options = array('' => 'Select Interview Type', 'In person' => 'In person', 'Phone' => 'Phone', 'Video conference' => 'Video conference');
if (empty($req_options) && count($req_options) == 0) {
$status = 0;
$message = "No approved requisitions.";
} else {
if (empty($cntry_options) && count($cntry_options) == 0) {
$status = 0;
$message = "Countries are not configured yet.";
} else {
$result['req_id'] = $requisition_options;
$result['country'] = $countries_options;
$result['interview_mode'] = $interview_type_options;
}
}
}
}
}
return array('status' => $status, 'message' => $message, 'result' => $result);
}
