<?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-2">
            Task Date
        </div>
        <div class="col-md-4">
            <div class="input-group input-daterange">
                <input type="text" id="task-start-date" class="form-control" name="TaskDateStart" value="" autocomplete="off" readonly>
                <div class="input-group-text" style="border-radius:0px">to</div>
                <input type="text" id="task-end-date" class="form-control" name="TaskDateEnd" value="" autocomplete="off" readonly>
            </div>
        </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>
<link href="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/css/bootstrap-datepicker3.min.css" rel="stylesheet" />
    <script src="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
    <script src="<?php echo $path; ?>Assets/Backend/vendor/moment.js"></script>
    <script>
      $(document).ready(function ($) {
          var dateAuto = moment();
          var dateAuto_m = moment(dateAuto, "DD/MM/YYYY").subtract(15, 'days');
          var dateAuto_m2 =  dateAuto.format('DD/MM/YYYY');
          $('#task-start-date').val(dateAuto_m.format('DD/MM/YYYY'));
          $('#task-end-date').val(dateAuto_m2);

          //var dateAuto_m = dateAuto.format('DD/MM/YYYY');
          //var dateAuto_m2 =  moment(dateAuto, "DD/MM/YYYY").add(15, 'days');

          $('#task-start-date').datepicker({
              format: "dd/mm/yyyy",
          });

          $('#task-end-date').datepicker({
              format: "dd/mm/yyyy",
          });




          $('#task-start-date').datepicker().on("changeDate", function () {
              var startDate = $('#task-start-date').datepicker("getDate");
              var oneDayFromStartDate = moment(startDate).add(1, 'days').toDate();
              $('#task-end-date').datepicker('setStartDate', oneDayFromStartDate);
          });

          $('#task-end-date').datepicker().on("show", function () {
              var startDate = $('#task-start-date').datepicker('getDate');
              $('.day.disabled').filter(function (index) {
                  return $(this).text() === moment(startDate).format('D');
              }).addClass('active');
          });
        });

        function ExportExcel() {
            let objForm = $("#export-timesheet").serializeFormJSON();
            
            $.ajax({
              url: 'MyTimeSheetSummaryExcel.php',
              data: objForm,
              type: 'POST',
              success: function (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>