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