<?php
  $year = date("Y");
  $month = date("m");
  if(@$_GET['Year']!=''){$year=@$_GET['Year'];}
  if(@$_GET['Month']!=''){$month=@$_GET['Month'];}
?>
<input type="hidden" id="page-menu-id" name="" value="#menu_case" />
<div class="d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800">Case > Report > Time Sheet Summary</h1>
</div>
<form action="" method="get" id="export-timesheet" class="mb-3">
    <div class="row">
        <div class="col-md-1">
            Year:
        </div>
        <div class="col-md-2">
            <select class="form-control" name="Year">
              <?php for($i = $year-3; $i<=$year+1;$i++){ //  @for (int i = (DateTime.Now.Year - 1); i <= (DateTime.Now.Year + 1); i++){ ?>

                    <option value="<?php echo $i; ?>" <?php echo ($year==$i)?"selected" : ""; ?>><?php echo $i; ?></option>
                <?php } ?>
            </select>
        </div>
        <div class="col-md-1">
            Month:
        </div>
        <div class="col-md-2">
            <select class="form-control" name="Month">
              <?php for($i = 1; $i<=12;$i++){ //  @for (int i = (DateTime.Now.Year - 1); i <= (DateTime.Now.Year + 1); i++){ ?>
                    <option value="<?php echo $i; ?>" <?php echo ($month==$i)?"selected" : ""; ?>>
                      <?php echo $util_class->m_th_re($i); ?>
                    </option>

              <?php } ?>
            </select>
        </div>
        <div class="col-md-6">
            <button class="btn btn-success" type="button" onclick="ExportExcel()"><i class="fas fa-file-excel"></i> Export to Excel</button>
            <button class="btn btn-danger" type="button" onclick="ExportPdf()"><i class="fas fa-file-pdf"></i> Export to Pdf</button>
        </div>
    </div>
</form>

    <script>
        function ExportExcel() {
            var objForm = $("#export-timesheet").serializeFormJSON();
            $.ajax({
              url: 'MyTimeSheetSummaryExcel.php',
              data: objForm,
              type: 'POST',
              success: function (resp) {
                //console.log(resp);
                var res = JSON.parse(resp);
                if(res.mes == 'success'){
                  window.open(res.file, "new");
                }
              }
            });
        }
        function ExportPdf() {
            var objForm = $("#export-timesheet").serializeFormJSON();
            window.open("MyTimeSheetSummaryPdf.php?" + $.param(objForm), "new");
        }
    </script>