<?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(
      'ClassesCode' => @$_REQUEST['ClassesCode'],
      'ClassesText' => @$_REQUEST['ClassesText'],
    );
    $data = $classes_db->ExportsClasses($request);


    $_title = $_REQUEST['title'][0];

    $arrayData = $data;
    $totalRow = count($data);
    /*
      echo "<pre>";
      print_r($_title);
      echo "</pre>";
      exit();
    */

    $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', 'Classes');
    $sheet ->mergeCells('A1:E1');
    $sheet->getStyle('A1:E1')->applyFromArray($style_center);

    $colum = array("Classes","Text Th","Text En","Status","LastUpdateBy","LastUpdateDateTime","CreateBy","CreateDateTime");
    $columID = array("ClassesCode","ClassesTextTH","ClassesTextEN","StatusActive","LastUpdateBy","LastUpdateDateTime","CreateBy","CreateDateTime");

    $columnName = $_title;

    $sheet->fromArray($columnName, NULL, 'A2');

    $CaseId='';
    $ct = 3;
    $runcolum = ["A","B","C","D","E","F","G","H","I","J","K","L"];
    foreach ($data['Data'] as $key => $value) {
      $b = 0;
      for ($a=0; $a < count($_title); $a++) {
        for ($i=0; $i < count($columID); $i++) {
          if($_title[$a] == $columID[$i]){
            if($i==0){ $sheet->setCellValue($runcolum[$b].$ct, $value['ClassesCode']); }
            if($i==1){ $sheet->setCellValue($runcolum[$b].$ct, $value['ClassesTextTH']); }
            if($i==2){ $sheet->setCellValue($runcolum[$b].$ct, $value['ClassesTextEN']); }
            if($i==3){ $sheet->setCellValue($runcolum[$b].$ct, $value['StatusActive']); }
            if($i==4){ $sheet->setCellValue($runcolum[$b].$ct, $value['LastUpdateBy']); }
            if($i==5){ $sheet->setCellValue($runcolum[$b].$ct, $value['LastUpdateDateTime']); }
            if($i==6){ $sheet->setCellValue($runcolum[$b].$ct, $value['CreateBy']); }
            if($i==7){ $sheet->setCellValue($runcolum[$b].$ct, $value['CreateDateTime']); }

            $b++;
          }
        }
      }
      $ct++;
    }
    /*
    echo json_encode($data ,JSON_UNESCAPED_UNICODE);
    exit();
    */
    $writer = new Xlsx($spreadsheet);
    $output_file = "report_excel/ClassesReport.xlsx"; // กำหนดชื่อไฟล์ excel ที่ต้องการ
    $writer->save($output_file); // สร้าง excel

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