TransWar File Browser

Path: C:\

<?php
date_default_timezone_set('America/Sao_Paulo');
$DT=date('d-m-Y_G\hi\m');
$ds_grupo=$_POST['dsgrupo'];$lin=$_POST['lin'];
$arqxlsx="FUP_".$DT.".xlsx";
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
/* Set CSV parsing options */
$reader->setDelimiter(',');
$reader->setEnclosure('"');
$logo1="images/".$ds_grupo."1.png";
$logo2="images/".$ds_grupo."2.png";
$logo3="images/".$ds_grupo."3.png";
$reader->setSheetIndex(0);
/* Load a CSV file and save as a XLS */
$spreadsheet = $reader->load("fup_temp.csv");
$writer = new Xlsx($spreadsheet);
$spreadsheet->getActiveSheet()->setTitle('FUP');
$drawing1 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing1->setPath($logo3);
$drawing1->setHeight(70);
$drawing1->setWorksheet($spreadsheet->getActiveSheet());
$drawing1->setCoordinates('B1');
$drawing2 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing2->setPath($logo2);
$drawing2->setHeight(70);
$drawing2->setWorksheet($spreadsheet->getActiveSheet());
$drawing2->setCoordinates('E1');
$drawing3 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing3->setPath($logo1);
$drawing3->setHeight(70);
$drawing3->setWorksheet($spreadsheet->getActiveSheet());
$drawing3->setCoordinates('G1');
$spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(80);
$spreadsheet->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
$spreadsheet->getActiveSheet()->mergeCells('B1:J1');
$styleArray = [
    'borders' => [
        'outline' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => '000000'],
        ],
    ],
];
$styleArray2 = [
    'borders' => [
        'vertical' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => 'a4a4a4'],
        ],
    ],
];
$format = '* #,###';
$spreadsheet->getActiveSheet()->getStyle('B2:J'.$lin)->applyFromArray($styleArray);
$spreadsheet->getActiveSheet()->getStyle('B2:J'.$lin)->applyFromArray($styleArray2);
$spreadsheet->getActiveSheet()->getStyle('B1:J1')->getFont()->setSize(20);
$spreadsheet->getActiveSheet()->getStyle('B2:J2')->getFont()->setSize(11);
$spreadsheet->getActiveSheet()->getStyle('B1:J2')->getFont()->setBold(true);
$spreadsheet->getActiveSheet()->getStyle('B2:J2')
    ->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('B1:J2')
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('J1:J'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('B1:D'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('e1:f'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('B2:J2')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE);
$spreadsheet->getActiveSheet()->getStyle('G3:I'.$lin)->getNumberFormat()->setFormatCode($format);
for ($c=3; $c <= $lin; $c++) 
  { if ($c % 2 == 0) { $bg="d8d8d8";} else {$bg="ffffff";}
    $range='B'.$c.':J'.$c;
    $spreadsheet->getActiveSheet()->getStyle($range)->getFill()
        ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
        ->getStartColor()->setARGB($bg);

    $validation = $spreadsheet->getActiveSheet()->getCell('C'.$c)
        ->getDataValidation();
    $validation->setType( \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_LIST );
    $validation->setErrorStyle( \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_INFORMATION );
    $validation->setAllowBlank(false);
    $validation->setShowInputMessage(true);
    $validation->setShowDropDown(true);
    $validation->setFormula1('"Aguardando Agendamento,Aguardando AR,Aguardando Consolidação,Agendado"');

    $spreadsheet->getActiveSheet()->setCellValue('D'.$c,'=if(C'.$c.'="","",if(C'.$c.'="Aguardando AR","Fiscal",if(C'.$c.'="Aguardando Agendamento","Recebimento",if(C'.$c.'="Aguardando Consolidação","Transportadora",if(C'.$c.'="Agendado","Transportadora","")))))');
  }
$spreadsheet->getActiveSheet()->getStyle('B2:J2')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('5882FA');
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(50);
$spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(35);
$spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('I')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('J')->setWidth(15);
$spreadsheet->getActiveSheet()->getStyle('B1:J2')->getAlignment()->setWrapText(true);

$writer->save($arqxlsx);
$spreadsheet->disconnectWorksheets();
unset($spreadsheet);
unlink('fup_temp.csv'); 
echo "<script language='JavaScript'>location.href='FUP.php?arquivo=".$arqxlsx."';</script>";
?>