Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dateStart = $this->_getParam('dateStart');
- $dateEnd = $this->_getParam('dateEnd');
- $idclient = $this->_getParam('cbClient');
- /** @desc Inicializa o contador */
- $count = 1;
- $dep = '';
- $array = '';
- $soma = '';
- //Relatório de logistica por centro de custo
- $arquivo = 'LOGISTICAS POR CENTRO DE CUSTO.xls';
- $html = "";
- $html .= "<table border=1>";
- $html .= "<tr>";
- $html .= "<td><b>ORDEM SERVIÇO</b></td>";
- $html .= "<td><b>DATA ATENDIMENTO</b></td>";
- $html .= "<td><b>SERVIÇO</b></td>";
- $html .= "<td><b>QTD</b></td>";
- $html .= "<td><b>CENTRO CUSTO</b></td>";
- $html .= "<td><b>DEPARTAMENTO</b></td>";
- $html .= "<td><b>TRANSPORTES</b></td>";
- $html .= "</tr>";
- /** @desc Varre registro */
- foreach ($model->relogisticaCC($dateStart, $dateEnd, $idclient) as $obj) {
- $qtd = $model->countqtdsss($dateStart, $dateEnd, $idclient, $obj->ID_CENTROCUSTO);
- $array .= $qtd . ',';
- /** @desc Gera HTML */
- $html .= "<tr>";
- $html .= "<td>{$obj->ID_ORDEMSERVCO}</td>";
- $html .= "<td>{$obj->DTATDMTO}</td>";
- $html .= "<td>{$obj->NM}</td>";
- $html .= "<td>{$obj->QT}</td>";
- $html .= "<td>{$obj->NMCENTROCUSTO}</td>";
- $html .= "<td>{$obj->NMDEPTO}</td>";
- if($dep !== $obj->NMCENTROCUSTO){
- $html .= "<td rowspan='{$qtd}' align='center' valign='center'>{$qtd}</td>";
- }
- $html .= "</tr>";
- $dep = $obj->NMCENTROCUSTO;
- $count++;
- }
- $html .= "<tr>";
- $html .= "<td></td>";
- $html .= "<td></td>";
- $html .= "<td></td>";
- $html .= "<td></td>";
- $html .= "<td></td>";
- $html .= "<td><b>TOTAL</b></td>";
- $html .= "<td align=center><b>{$model->countqtdsss($dateStart, $dateEnd, $idclient, 'CENTRO')}</b></td>";
- $html .= "</tr>";
- $html .= "</table>";
- //echo $html;exit;
- /** @desc Gera o arquivo */
- header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
- header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
- header("Cache-Control: no-cache, must-revalidate");
- header("Pragma: no-cache");
- header("Content-type: application/x-msexcel");
- header("Content-Disposition: attachment; filename=\"{$arquivo}\"");
- header("Content-Description: PHP Generated Data");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement