<input type="hidden" id="page-menu-id" name="" value="#menu_account" />
<div class="d-sm-flex align-items-center justify-content-between mb-4">
    <h1 class="h3 mb-0 text-gray-800">Account > Report > Finance Status Report</h1>
</div>

<form action="" method="get" id="form-report">
    <div class="row">
        <div class="col-md-2">
            Date
        </div>
        <div class="col-md-4">
            <div class="input-group input-daterange">
                <input type="text" id="start-date" class="form-control" name="StartDate" value="" autocomplete="off" readonly>
                <div class="input-group-text" style="border-radius:0px">to</div>
                <input type="text" id="end-date" class="form-control" name="EndDate" value="" autocomplete="off" readonly>
            </div>
        </div>
        <div class="col-md-2">
            Case No.:
        </div>
        <div class="col-md-4">
            <input type="text" class="form-control" name="CaseNumber" value="" autocomplete="off" />
        </div>
    </div>
    <div class="row mt-2">
        <div class="col-md-2">
            Person
        </div>
        <div class="col-md-4">
            <input type="text" class="form-control" id="person-filter" value="" autocomplete="off" />
            <input type="hidden" value="" name="UserId" id="hd-user-id" />
        </div>
        <div class="col-md-2">
            Case Status
        </div>
        <div class="col-md-4">
            <select class="form-control" name="CaseStatus">
                <option value="0">All Status</option>
                <option value="1">Opening</option>
                <option value="2">Completed</option>
            </select>
        </div>
    </div>
    <div class="row mt-2">
        <div class="col-md-2">
            Payment Status
        </div>
        <div class="col-md-4">
            <select class="form-control" name="PaymentStatus">
                <option value="0">All Status</option>
                <option value="1">Not Received</option>
                <option value="2">Received Some</option>
                <option value="3">Received All</option>
            </select>
        </div>
    </div>
    <div class="row col-md-12">&nbsp;</div>
    <div class="row">
        <div class="col-md-12 text-right">
            <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>
    <link href="<?php echo $path; ?>Assets/Backend/vendor/jquery-ui/jquery-ui.min.css" rel="stylesheet" />
    <script src="<?php echo $path; ?>Assets/Backend/vendor/jquery-ui/jquery-ui.min.js"></script>


    <script>
    var urlLoadUser = "LoadUsersAutoComplete.php";
    $(document).ready(function ($) {

        if ($("#person-filter").length > 0) {
          var personInput = $("#person-filter");
          var autocompUser = personInput.autocomplete({
              source: function (request, response) {
                  $.getJSON(urlLoadUser, {
                      Keyword: personInput.val()
                  }, response);
              },
              select: function (event, ui) {
                  personInput.val(ui.item.Name + ' ' + ui.item.Surname);
                  $("#hd-user-id").val(ui.item.Id);
                  return false;
              }
          }).change(function (e) {
              if (e.target.value == "") { $("#hd-user-id").val('');}
          });
          autocompUser.autocomplete("instance")._renderItem = function (ul, item) {
              return $("<li>").append(item.Name+' '+item.Surname).appendTo(ul);
          };
        }

          var dateAuto = moment();
          var dateAuto_m = dateAuto.format('DD/MM/YYYY');
          var dateAuto_m2 =  moment(dateAuto, "DD/MM/YYYY").add(1, 'days');
          $('#start-date').val(dateAuto_m);
          $('#end-date').val(dateAuto_m2.format('DD/MM/YYYY'));

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

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




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

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

      function ExportExcel() {
          var objForm = $("#form-report").serializeFormJSON();
          //window.open("FinanceStatusReportExcel.php?" + $.param(objForm), "new");
          $.ajax({
            url: 'FinanceStatusReportExcel.php',
            data: objForm,
            type: 'POST',
            success: function (resp) {
              console.log(resp);
              var res = JSON.parse(resp);
              //console.log(res);
              if(res['mes'] == 'success'){
                window.open("report_excel/FinanceStatusReport.xlsx", "new");
              }
            }
          });
      }
      function ExportPdf() {
          var objForm = $("#form-report").serializeFormJSON();
          window.open("FinanceStatusReportPdf.php?" + $.param(objForm), "new");

      }
    </script>