public function dadosmethodAction()
{
$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");
$methodsupplyModel = new MethodsupplyModel();
$methodModel = new MethodModel();
$methodData = $methodModel->fetchAll($methodModel->getAllMethod());
// var_dump($methodData);
// die;
$count = count($methodData);
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$methodData = $methodModel->fetchAll($methodModel->getAllMethod($sidx, $sord, $limit, $page));
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
$nmsupply = '';
foreach ($methodData as $row) {
$supply = $methodsupplyModel->fetchAll($methodsupplyModel->getSupplyByMethod($row->cdmethod));
foreach ($supply as $rows) {
$nmsupply .= $rows->nmsupply . ',';
}
$nmsupply = explode(",", $nmsupply);
$nmsupply2 = array_slice($nmsupply, 0, count($nmsupply) - 1);
$nmsupply3 = implode(",", $nmsupply2);
if ($row->fgactive == '1') {
$status = 'Ativo';
} else {
$status = 'Inativo';
}
$responce->rows[$i]['cell'] = array($row->cdmethod, $row->nmmethod, $row->cdequipment, $row->nmequipment, $nmsupply3, $row->cddocument, $row->nmdocument, $row->fgactive, $status);
$i++;
$nmsupply = '';
}
$this->view->dadosmethod = $responce;
}
public function dadosmethodAction()
{
$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");
$methodModel = new MethodModel();
$methodData = $methodModel->fetchAll($methodModel->getMethodByEachSupply());
$count = count($methodData);
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$methodData = $methodModel->fetchAll(null, "{$sidx} {$sord}", $limit, $page * $limit - $limit);
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
var_dump($methodData);
foreach ($methodData as $row) {
$responce->rows[$i]['cdmethod'] = $row->cdmethod;
$responce->rows[$i]['cell'] = array($row->cdmethod, $row->nmmethod, $row->cdequipment, '', $row->cddocument);
$i++;
}
$this->view->dadosmethod = $responce;
}
