public function dadosalldepartmentAction() { $this->_helper->layout->disableLayout(); $page = $this->_request->getParam("page", 1); $limit = $this->_request->getParam("rows"); $sidx = $this->_request->getParam("sidx", 1); $sord = $this->_request->getParam("sord"); $departmentModel = new DepartmentModel(); $departmentcomapnyModel = new CompanydepartmentModel(); $cdcompany = $this->_request->getParam("cdcompany"); $cddepartment = $this->_request->getParam("cddepartment"); $deparmentData = $departmentModel->fetchall(); if (!isset($cddepartment)) { $_SESSION['cddepartment'] = '0'; if (isset($cdcompany)) { $_SESSION['cdcompany'] = $cdcompany; } $deparmentData = $departmentcomapnyModel->fetchAll('cdcompany=' . $_SESSION['cdcompany']); $count = count($deparmentData); if ($count > 0 && $limit > 0) { $deparmentData = $this->_model->getDepartmentById($_SESSION['cdcompany'], $sidx, $sord, $limit, $page); $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $_SESSION['idelement'] = "company_" . $cdcompany; $responce = new stdClass(); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; } else { $_SESSION['cddepartment'] = $cddepartment; $deparmentData = $this->_model->fetchAll('cddepartment=' . $cddepartment); $count = count($deparmentData); if ($count > 0 && $limit > 0) { $deparmentData = $this->_model->getAllDepartmentParentByCompany($cddepartment, $sidx, $sord, $limit, $page); $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $responce = new stdClass(); $count = count($deparmentData); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; } $i = 0; foreach ($deparmentData as $row) { switch ($row->fgactive) { case 1: $fgactive = 'Ativo'; break; case 2: $fgactive = 'Inativo'; break; } $companyModel = new CompanyModel(); $cdcompany = $_SESSION['cdcompany']; $companyData = $companyModel->fetchRow('cdcompany=' . $cdcompany); $nmcompany = $companyData->nmcompany; $responce->rows[$i]['cddepartment'] = $row->cddepartment; $responce->rows[$i]['cell'] = array($row->iddepartment, $row->cddepartment, $row->nmdepartment, $fgactive, $nmcompany); $i++; } $this->view->dadosalldepartment = $responce; }