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