public function getdepartmentsAction()
{
$ajaxContext = $this->_helper->getHelper('AjaxContext');
$ajaxContext->addActionContext('getdepartments', 'html')->initContext();
$businessunit_id = $this->_request->getParam('business_id');
$con = $this->_request->getParam('con');
$employeeform = new Default_Form_employee();
$leavemanagementform = new Default_Form_leavemanagement();
$flag = '';
$departmentsmodel = new Default_Model_Departments();
$appraisalconfigmodel = new Default_Model_Appraisalconfig();
if ($con == 'leavemanagement') {
$leavemanagementmodel = new Default_Model_Leavemanagement();
$departmentidsArr = $leavemanagementmodel->getActiveDepartmentIds();
$depatrmentidstr = '';
$newarr = array();
if (!empty($departmentidsArr)) {
$where = '';
for ($i = 0; $i < sizeof($departmentidsArr); $i++) {
$newarr1[] = array_push($newarr, $departmentidsArr[$i]['deptid']);
}
$depatrmentidstr = implode(",", $newarr);
foreach ($newarr as $deparr) {
$where .= " id!= {$deparr} AND ";
}
$where = trim($where, " AND");
$querystring = "Select d.id,d.deptname from main_departments as d where d.unitid={$businessunit_id} and d.isactive=1 and {$where} ";
$querystring .= " order by d.deptname";
$uniquedepartmentids = $departmentsmodel->getUniqueDepartments($querystring);
if (empty($uniquedepartmentids)) {
$flag = 'true';
}
$this->view->uniquedepartmentids = $uniquedepartmentids;
} else {
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
if (empty($departmentlistArr)) {
$flag = 'true';
}
$this->view->departmentlistArr = $departmentlistArr;
}
} else {
if ($con == 'appraisal_config') {
$departmentlistArr = $appraisalconfigmodel->getExistDepartments($businessunit_id);
$dept_arr = array();
foreach ($departmentlistArr as $dept) {
$deptid = $dept['department_id'];
array_push($dept_arr, $deptid);
}
$dept_arr = array_filter($dept_arr);
$dept_arr = array_unique($dept_arr);
$dept_list = implode(',', $dept_arr);
$departmentlistArr = $appraisalconfigmodel->getDepartments($businessunit_id, $dept_list);
if (empty($departmentlistArr)) {
$flag = 'true';
}
$this->view->departmentlistArr = $departmentlistArr;
} else {
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
if (empty($departmentlistArr)) {
$flag = 'true';
}
$this->view->departmentlistArr = $departmentlistArr;
}
}
$this->view->employeeform = $employeeform;
$this->view->leavemanagementform = $leavemanagementform;
$this->view->flag = $flag;
if ($con != '') {
$this->view->con = $con;
}
}
public function getuniqueDepartment($businessunit_id)
{
$leavemanagementmodel = new Default_Model_Leavemanagement();
$departmentidsArr = $leavemanagementmodel->getActiveDepartmentIds();
$departmentsmodel = new Default_Model_Departments();
$depatrmentidstr = '';
$newarr = array();
if (!empty($departmentidsArr)) {
$where = '';
for ($i = 0; $i < sizeof($departmentidsArr); $i++) {
$newarr1[] = array_push($newarr, $departmentidsArr[$i]['deptid']);
}
$depatrmentidstr = implode(",", $newarr);
foreach ($newarr as $deparr) {
$where .= " id!= {$deparr} AND ";
}
$where = trim($where, " AND");
$querystring = "Select d.id,d.deptname from main_departments as d where d.unitid={$businessunit_id} and d.isactive=1 and {$where} ";
$uniquedepartmentids = $departmentsmodel->getUniqueDepartments($querystring);
return $uniquedepartmentids;
} else {
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
return $departmentlistArr;
}
}
