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