Advertisement
Guest User

Untitled

a guest
Nov 21st, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.84 KB | None | 0 0
  1. $dateStart = $this->_getParam('dateStart');
  2.             $dateEnd = $this->_getParam('dateEnd');
  3.             $idclient = $this->_getParam('cbClient');
  4.  
  5.             /** @desc Inicializa o contador */
  6.             $count = 1;
  7.             $dep = '';
  8.             $array = '';
  9.             $soma = '';
  10.  
  11.             //Relatório de logistica por centro de custo
  12.             $arquivo = 'LOGISTICAS POR CENTRO DE CUSTO.xls';
  13.  
  14.             $html = "";
  15.             $html .= "<table border=1>";
  16.             $html .= "<tr>";
  17.             $html .= "<td><b>ORDEM SERVIÇO</b></td>";
  18.             $html .= "<td><b>DATA ATENDIMENTO</b></td>";
  19.             $html .= "<td><b>SERVIÇO</b></td>";
  20.             $html .= "<td><b>QTD</b></td>";
  21.             $html .= "<td><b>CENTRO CUSTO</b></td>";
  22.             $html .= "<td><b>DEPARTAMENTO</b></td>";
  23.             $html .= "<td><b>TRANSPORTES</b></td>";
  24.             $html .= "</tr>";
  25.  
  26.             /** @desc Varre registro */
  27.             foreach ($model->relogisticaCC($dateStart, $dateEnd, $idclient) as $obj) {
  28.  
  29.                 $qtd = $model->countqtdsss($dateStart, $dateEnd, $idclient, $obj->ID_CENTROCUSTO);
  30.                 $array .= $qtd . ',';
  31.  
  32.                 /** @desc Gera HTML */
  33.                 $html .= "<tr>";
  34.                 $html .= "<td>{$obj->ID_ORDEMSERVCO}</td>";
  35.                 $html .= "<td>{$obj->DTATDMTO}</td>";
  36.                 $html .= "<td>{$obj->NM}</td>";
  37.                 $html .= "<td>{$obj->QT}</td>";
  38.                 $html .= "<td>{$obj->NMCENTROCUSTO}</td>";
  39.                 $html .= "<td>{$obj->NMDEPTO}</td>";
  40.                
  41.                 if($dep !== $obj->NMCENTROCUSTO){
  42.                     $html .= "<td rowspan='{$qtd}' align='center' valign='center'>{$qtd}</td>";
  43.                 }
  44.  
  45.                 $html .= "</tr>";
  46.  
  47.                 $dep = $obj->NMCENTROCUSTO;
  48.                 $count++;
  49.             }
  50.             $html .= "<tr>";
  51.             $html .= "<td></td>";
  52.             $html .= "<td></td>";
  53.             $html .= "<td></td>";
  54.             $html .= "<td></td>";
  55.             $html .= "<td></td>";
  56.             $html .= "<td><b>TOTAL</b></td>";
  57.             $html .= "<td align=center><b>{$model->countqtdsss($dateStart, $dateEnd, $idclient, 'CENTRO')}</b></td>";
  58.             $html .= "</tr>";
  59.             $html .= "</table>";
  60.  
  61.             //echo $html;exit;
  62.             /** @desc Gera o arquivo */
  63.             header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
  64.             header("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
  65.             header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  66.             header("Cache-Control: no-cache, must-revalidate");
  67.             header("Pragma: no-cache");
  68.             header("Content-type: application/x-msexcel");
  69.             header("Content-Disposition: attachment; filename=\"{$arquivo}\"");
  70.             header("Content-Description: PHP Generated Data");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement