<?php
    $ck='not';
    //putenv("NLS_LANG=AMERICAN_AMERICA.TH8TISASCII");
    include("../include/class.php");
    include("../include/table_name.php");
    require '../vendor/autoload.php';

    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

    $date_year = date("Y");
    $date_month = date("m");

    $request = array();
    $data = $customer_db->ExportToExcel($request);
    $arrayData = $data;
    $totalRow = count($data);

    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();

    // การกำหนดค่า ข้อมูลเกี่ยวกับไฟล์ excel
    $spreadsheet->getProperties()
      ->setCreator("Maarten Balliauw")
      ->setLastModifiedBy("Maarten Balliauw")
      ->setTitle("Office 2007 XLSX Test Document")
      ->setSubject("Office 2007 XLSX Test Document")
      ->setDescription(
          "Test document for Office 2007 XLSX, generated using PHP classes."
      )
      ->setKeywords("office 2007 openxml php")
      ->setCategory("Test result file");


    $style_center = array(
        'alignment' => array(
            'horizontal' => PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
        )
    );


    $sheet->setCellValue('A1', 'Customer');
    $sheet ->mergeCells('A1:J1');
    $sheet->getStyle('A1:J1')->applyFromArray($style_center);


    $columnName = ["No.","Customer Code","Customer Name","Address","Telephone","Fax","Electronic Email","Tax ID","Remark","Initial"];
    $sheet->fromArray($columnName, NULL, 'A2');
    $ct = 3;
    $i = 1;
    foreach ($arrayData['Data'] as $key => $value) {
      $sheet->setCellValue('A'.$ct, $i);
      $sheet->setCellValue('B'.$ct, $value['NamesCode']);
      $sheet->setCellValue('C'.$ct, $value['NamesName']);
      $sheet->setCellValue('D'.$ct, $value['PostalAddress']);
      $sheet->setCellValue('E'.$ct, $value['Telephone']);
      $sheet->setCellValue('F'.$ct, $value['Fax']);
      $sheet->setCellValue('G'.$ct, $value['ElectronicMail']);
      $sheet->setCellValue('H'.$ct, $value['TaxID']);
      $sheet->setCellValue('T'.$ct, $value['Remark']);
      $sheet->setCellValue('J'.$ct, $value['Initial']);
      $i++;
      $ct++;
    }
    //$sheet->fromArray($arrayData, NULL, 'A4');

    $writer = new Xlsx($spreadsheet);
    $output_file = "report_excel/Customer.xlsx"; // กำหนดชื่อไฟล์ excel ที่ต้องการ
    $writer->save($output_file); // สร้าง excel

    if(file_exists($output_file)){ // ตรวจสอบว่ามีไฟล์ หรือมีการสร้างไฟล์ แล้วหรือไม่
      //echo '<a href="'.$output_file.'" target="_blank">Download</a>';
      $message = array('mes' => 'success');
      echo json_encode($message ,JSON_UNESCAPED_UNICODE);
    }else{
      $message = array('mes' => 'false');
      echo json_encode($message ,JSON_UNESCAPED_UNICODE);
    }
    ?>