<?php
    $arrayName = array(  'LoadCountry' => '');
    $data_Country = $quotation_db->LoadCountry($arrayName);

 ?>
    <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 > Case Summary</h1>
    </div>
    <form action="" method="get" id="form-report">
        <div class="row">
            <div class="col-md-1">
                Country:
            </div>
            <div class="col-md-3">
                <select class="form-control" name="CountryId" onchange="loadCaseType(this.value)">
                    <option value="">All Country</option>
                    <?php foreach ($data_Country as $key => $value) { ?>
                      <option value="<?php echo @$value['CountryId']; ?>" <?php echo (@$value['CountryId']==@$data_iTem[0]['CountryId'])? "selected" : ""; ?>><?php echo $value['CountryCode']; ?></option>
                    <?php }  ?>
                </select>
            </div>
            <div class="col-md-1">
                Case Type:
            </div>
            <div class="col-md-3">
                <select class="form-control" name="CaseTypeId" id="ddl_case_type">
                    <option value="">All Case Type</option>
                </select>
            </div>
            <div class="col-md-1">
                Case Number:
            </div>
            <div class="col-md-3">
                <input type="text" class="form-control" name="CaseNumber" id="case-filter" value="" autocomplete="off" />
                <input type="hidden" value="" name="CaseId" id="hd-case-id" />
            </div>
        </div>
        <div class="row mt-2">
            <div class="col-md-1">
                Customer:
            </div>
            <div class="col-md-3">
                <input type="text" class="form-control" id="customer-filter" value="" autocomplete="off" />
                <input type="hidden" value="" name="CustomerId" id="hd-customer-id" />
            </div>
            <div class="col-md-1">
                Status:
            </div>
            <div class="col-md-3">
                <select class="form-control" name="Status">
                    <option value="0">All Status</option>
                    <option value="1">Opening</option>
                    <option value="2">Completed</option>
                </select>
            </div>
            <div class="col-md-1">
                Quotation Type:
            </div>
            <div class="col-md-3">
                <select class="form-control" name="IsRetainer">
                    <option value="0">All Type</option>
                    <option value="1">One Time only</option>
                    <option value="2">Retainer Only</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="exportToExcel()" id="btn_ete">
                  <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 urlLoadCaseNumber = "LoadCaseAutoComplete.php";
        var urlLoadCustomer = "LoadCustomerAutoComplete.php";

        var urlExport = "CaseSummaryExcel.php";
        var urlLoadCaseType = "LoadCaseTypeByCountry.php";
        function exportToExcel() {
            var objParams = $("#form-report").serializeFormJSON();

          //  window.open("CaseSummaryExcel.php?" + $.param(objParams), "new");

            $("#btn_ete").prop("disabled", true);
            $('#btn_ete').append('<div class="spinner-border" id="spinner"></div>');
            $.ajax({
              url: 'CaseSummaryExcel.php',
              data: objParams,
              type: 'POST',
              success: function (resp) {
                var res = JSON.parse(resp);
                if(res.mes == 'success'){
                  $("#btn_ete").prop("disabled", false);
                  $('#spinner').hide();
                  window.open(res.file, "new");
                }
              }
            });

        }
        function ExportPdf() {
            var objForm = $("#form-report").serializeFormJSON();
            window.open("CaseSummaryPdf.php?" + $.param(objForm), "new");
        }
        function loadCaseType(val) {
            $("#ddl_case_type option[class*='load']").remove();
            $.get(urlLoadCaseType, { CountryId: val })
                .done(function (resp) {
                    var res = JSON.parse(resp);
                    $.each(res, function (key, value) {
                        $('<option value="' + value.CaseTypeId + '" class="load">' + value.CaseTypeName + '</option>').appendTo("#ddl_case_type");
                    })
                });
        }
    </script>
    <script src="<?php echo $path; ?>Scripts/pages_v1/casesummary.js?t=<?php echo $date_ticks; ?>"></script>