require "../includes/funcoes.php"; require "../includes/global.inc.php"; require_once "../classes/spreadsheet_excel_writer/Writer.php"; if (verifica_permissao('Rel_gerencial', $controle_id_departamento_p, $controle_id_departamento_s) == 'FALSE' and verifica_permissao('Financeiro_rel', $controle_id_departamento_p, $controle_id_departamento_s) == 'FALSE' and verifica_permissao('Rel_comercial', $controle_id_departamento_p, $controle_id_departamento_s) == 'FALSE') { echo '<br><br><strong>Você não tem permissão para acessar essa página</strong>'; exit; } $ano = $_POST['ano']; $data1 = $ano . '-01-01 00:00:00'; $data2 = $ano . '-12-31 23:59:59'; $dt = new stdClass(); $dt->id_empresa = $controle_id_empresa; $dt->data1 = $data1; $dt->data2 = $data2; $relatorioDAO = new RelatorioDAO(); $faturamento = $relatorioDAO->FaturamentoClienteCorporativo($dt); if (count($faturamento) > 0) { $arquivo = date('Y') . date('m') . date('d') . date('H') . date('i') . date('s') . '.xls'; $workbook =& new Spreadsheet_Excel_Writer(); $workbook->send($arquivo); $worksheet =& $workbook->addWorksheet('fat_cliente_corporativo_' . $ano); $style1 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'gray', 'Align' => 'left', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 1, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black')); $style2 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'gray', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 1, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black')); $style3 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'white', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 0, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black', 'NumFormat' => '_*R$ #,##0.00')); $style4 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'white', 'Align' => 'left', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 0, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black')); $style5 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'white', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 0, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black')); $style6 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'gray', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 1, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black', 'NumFormat' => '_*R$ #,##0.00')); $style7 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'white', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Top' => 0, 'Bottom' => 1, 'Left' => 1, 'Right' => 0, 'BorderColor' => 'white', 'NumFormat' => '_*R$ #,##0.00')); $style8 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'gray', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 0, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black', 'NumFormat' => '_*R$ #,##0.00')); $style9 =& $workbook->addFormat(array('Size' => 10, 'FgColor' => 'black', 'BgColor' => 'gray', 'Align' => 'center', 'vAlign' => 'vcenter', 'FontFamily' => 'Calibri', 'Bold' => 0, 'Top' => 1, 'Bottom' => 1, 'Left' => 1, 'Right' => 1, 'BorderColor' => 'black')); $worksheet->write(0, 0, ' Nome', $style1);