@extends('layouts/microfin_layout')
@section('title', '| Loan Rebate Report V2')
@section('content')
<style>
  .grandTotal td{
      background-color: #819bc4;
  }
</style>

<div class="container-fluid">

  <!-- Start of the Dropdown form -->
  <div class="row">
    <div class="col-md-12">
      <div class="" style="">
        <div class="">
          <div class="panel panel-default" style="background-color:#708090;">
            <div class="panel-heading" style="padding-bottom:0px">
              <div class="panel-options">
                <button id="printIcon" class="btn btn-info pull-left print-icon"  target="_blank" style="">
                  <i class="fa fa-print fa-lg" aria-hidden="true">Print</i>
                </button>
                <button id="btnExportExcel" class="btn btn-info pull-center print-icon"  target="_blank" style="">
                  <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Excel</i>
                </button>

                <button  id="btnExportPdf" class="btn btn-info pull-right print-icon"  target="_blank" style="">
                  <i class="fa-file-excel-o fa-lg" aria-hidden="true"> Pdf</i>
                </button>
                {{-- <button id="printIcon" class="btn btn-info pull-right print-icon"  target="_blank" style="">
                    <i class="fa fa-print fa-lg" aria-hidden="true"> Print</i>
                  </button> --}}
                </div>
                <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">
                  LOAN REBATE REPORT V2
                </h3>
              </div>

              <div class="panel-body panelBodyView">
                <!-- Filtering Start-->
                {!! Form::open(array('url' => 'LoanRebateReportView', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'get')) !!}

                <div class="row">
                  {{-- Start of Branch Name --}}
                  <div class="col-md-12">

                  @if(!in_array($userRoleId, Config('services.branch_level_user_roles')))
                            <div class="col-md-1">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        {!! Form::label('', 'Report Level:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                                    </div>
                                    <div class="col-md-12">
                                        {!! Form::select('filReportLevel',$reportLevelList, null ,['id'=>'filReportLevel','class'=>'form-control input-sm','autocomplete'=>'off', 'autofocus']) !!}
                                    </div>
                                </div>
                            </div>                            

                            <div class="col-md-1" id="areaDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        {!! Form::label('', 'Area:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                                    </div>
                                    <div class="col-md-12">                                  
                                        <select id="filArea" name="filArea" class="form-control input-sm">
                                            <option value="">--Select Area--</option>
                                            @foreach ($areaList as $area)
                                            <option value="{{$area->id}}">{{$area->name}}</option>
                                            @php
                                            $barnchIds = str_replace(['"','[',']'], '', $area->branchId);
                                            $barnchIds = explode(',', $barnchIds);
                                            $branches = DB::table('gnr_branch')
                                            ->whereIn('id',$barnchIds)
                                            ->select(DB::raw("CONCAT ( LPAD(branchCode,3,0) ,' - ', name ) AS name"))
                                            ->get();
                                            @endphp
                                            @foreach ($branches as $branch)
                                            <option value="" disabled="disabled">&nbsp {{$branch->name}}</option>
                                            @endforeach
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-1" id="zoneDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        {!! Form::label('', 'Zone:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                                    </div>
                                    <div class="col-md-12">                                  
                                        <select id="filZone" name="filZone" class="form-control input-sm">
                                            <option value="">--Select Zone--</option>
                                            @foreach ($zoneList as $zone)
                                            <option value="{{$zone->id}}">{{$zone->name}}</option>
                                            @php
                                            $areaIds = str_replace(['"','[',']'], '', $zone->areaId);
                                            $areaIds = explode(',', $areaIds);
                                            $areas = DB::table('gnr_area')
                                            ->whereIn('id',$areaIds)
                                            ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                            ->get();
                                            @endphp
                                            @foreach ($areas as $area)
                                            <option value="" disabled="disabled">&nbsp {{$area->name}}</option>
                                            @endforeach
                                            @endforeach
                                        </select>

                                    </div>
                                </div>
                            </div>
                            <div class="col-md-1" id="regionDiv" style="display: none;">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        {!! Form::label('', 'Division:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                                    </div>
                                    <div class="col-md-12">                                  
                                        <select id="filRegion" name="filRegion" class="form-control input-sm">
                                            <option value="">--Select Division--</option>
                                            @foreach ($regionList as $region)
                                            <option value="{{$region->id}}">{{$region->name}}</option>
                                            @php
                                            $zoneIds = str_replace(['"','[',']'], '', $region->zoneId);
                                            $zoneIds = explode(',', $zoneIds);
                                            $zones = DB::table('gnr_zone')
                                            ->whereIn('id',$zoneIds)
                                            ->select(DB::raw("CONCAT ( LPAD(code,3,0) ,' - ', name ) AS name"))
                                            ->get();
                                            @endphp
                                            @foreach ($zones as $zone)
                                            <option value="" disabled="disabled">&nbsp {{$zone->name}}</option>
                                            @endforeach
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-1" id="branchDiv">
                                <div class="form-group">
                                    <div class="col-md-12">
                                        {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                                    </div>
                                    <div class="col-md-12">
                                        {!! Form::select('filBranch', [''=>'--All--']+$branchList, null ,['id'=>'filBranch','class'=>'form-control input-sm','autocomplete'=>'off']) !!}
                                        <p id='filBranchE' style="max-height:3px; color:red;"></p>
                                    </div>
                                </div>
                            </div>
                            @endif
               

                    <div class="col-md-1">
                      <div class="form-group">
                        <div class="col-md-12">
                          {!! Form::label('', 'Product:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                        </div>
                        <div class="col-md-12">
                          <select name="searchProduct" class="form-control input-sm" id="searchSamity" style="color: black;" required="true">>
                            <option value=""> -- Select Product -- </option>
                            <option value="All"> All </option>
                            @foreach($ProductDatas as $ProductData)
                            <option value="{{ $ProductData->id }}"> {{ str_pad($ProductData->code, 3, '0', STR_PAD_LEFT) }}-{{ $ProductData->shortName }} </option>             //Loop for showing the data in the Branch selection option
                            @endforeach
                          </select>
                        </div>
                      </div>
                    </div>
                    {{-- End of Samity Name --}}

                    {{-- Start of the to date --}}
                    <div class="col-md-1">
                      <div class="form-group">
                        <div class="col-md-12">
                          {!! Form::label('','Date From: ', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                        </div>
                        <div class="col-md-12">
                          <input type="text" class="form-control input-sm" id="txtDate1" name="txtDate1" value="" placeholder="dd-mm-yy" autocomplete="off">
                          
                        </div>
                      </div>
                    </div>
                    {{-- End of the to date --}}

                    {{-- Start of the to date --}}
                    <div class="col-md-1">
                      <div class="form-group">
                        <div class="col-md-12">
                          {!! Form::label('','Date To: ', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                        </div>
                        <div class="col-md-12">
                          <input type="text" class="form-control input-sm" id="txtDate2" name="txtDate2" value="" placeholder="dd-mm-yy" required  autocomplete="off">
                        </div>
                      </div>
                    </div>
                    {{-- End of the to date --}}

                  
                    <div class="col-md-1">
                        <div class="form-group">
                            <div class="col-md-12">
                                {!! Form::label('', 'Actual Rebate 0:', ['class' => 'control-label pull-left', 'style' => 'color:black']) !!}
                            </div>
                            <div class="col-md-12">
                                {!! Form::select('fillActualRebate',['no'=>'No','yes'=>'Yes'], null,['id'=>'fillActualRebate','class'=>'form-control input-sm', 'autocomplete'=>'off']) !!}
                            </div>
                        </div>
                    </div>

                    {{-- Start of the Submit Button --}}
                    <div class="col-md-1">
                      <div class="form-group">
                        {!! Form::label('', '.', ['class' => 'control-label col-md-12', 'style' => 'color:#708090']) !!}
                        <div class="col-md-12">
                          {!! Form::submit('Show Report', ['id' => 'reportSubmit', 'class' => 'btn btn-primary']); !!}
                          
                        </div>
                      </div>
                    </div>
                    {{-- End of the Submit button --}}
                  </div>

                  {!! Form::close()  !!}
                  <!-- filtering end-->
                </div>
              </div>
              <div class="row" id="reportingDiv">

              </div>
            </div>      {{-- panel-body panelBodyView DIV --}}
          </div>
        </div>
      </div>
    </div>
    <!-- End of Dropdown form -->

  </div>

  <script type="text/javascript">
// function myFunction() {
  document.getElementById("txtDate1").style.cursor = "pointer";
// }

// function myFunction() {
  document.getElementById("txtDate2").style.cursor = "pointer";
// }

$("#txtDate2, #txtDate1").on('keydown paste', function(e){
  e.preventDefault();
    // alert("Key pressing");
  });


// validation for date

$(document).ready(function(){

  $.datepicker.setDefaults({
    dateFormat: "dd-mm-yy",
    showOtherMonths: true,
    selectOtherMonths: true,
    changeMonth: true,
    changeYear: true,
    yearRange: "-50:+0",
    maxDate: "dateToday",
  });

/*    function toDate(dateStr) {

      var parts = dateStr.split("-");

      return new Date(parts[2], parts[1] - 1, parts[0]);

    }

    $("#txtDate1").datepicker({   

           onSelect: function () {

               $("#txtDate2").datepicker("option","minDate",new Date(toDate($(this).val())));                    

           }

       });

    $("#txtDate2").datepicker({

           onSelect: function () {

               $("#txtDate1").datepicker("option","maxDate",new Date(toDate($(this).val())));                    

           }

         });   */

         $("#txtDate1").datepicker({

           onSelect: function () {

             $("#txtDate2").datepicker("option", "minDate", $(this).datepicker('getDate'));                    

           }

         });

         $("#txtDate2").datepicker({

           onSelect: function () {

             $("#txtDate1").datepicker("option", "maxDate", $(this).datepicker('getDate'));                    

           }

         });

       });

//end date validation



//
$("form").submit(function( event ) {
 event.preventDefault();

 var serializeValue=$(this).serialize();


 $('#loadingModal').show();
 $("#reportingDiv").load('{{ URL::to("LoanRebateReportV2View") }}'+'?'+serializeValue);
});

$(document).ready(function() {

  $("#printIcon").click(function(event) {

    var mainContents = document.getElementById("reportingDiv").innerHTML;
    var headerContents = '';

    var printStyle = '<style>.amount{text-align: right;} thead tr th{text-align:center;vertical-align: middle;padding:3px;font-size:11px}  tr{ page-break-inside:avoid; page-break-after:auto } </style><style media="print">@page{margin:10mm 10mm;}</style><style>@media print {.element-that-contains-table { overflow: visible !important; }}</style><style>@page:first{tr:nth-of-type(4n){page-break-after: always;}}</style>';

    var printContents = '<div id="order-details-wrapper">' + headerContents +printStyle+ mainContents +'</div>';

    var win = window.open('','printwindow');
    win.document.write(printContents);
    win.print();
    win.close();
  });

  $("#loadingModal").hide();


      /*on change filReportLevel hide/show contents*/
      $("#filReportLevel").change(function(event) {
                if ($(this).val()=="Branch") {
                    $("#branchDiv").show();  
                    $("#areaDiv").hide();  
                    $("#zoneDiv").hide();  
                    $("#regionDiv").hide(); 

                    $("#filArea").prop('required', false);
                    $("#filZone").prop('required', false);
                    $("#filRegion").prop('required', false); 
                }
                else if($(this).val()=="Area"){
                    $("#branchDiv").hide(); 
                    $("#areaDiv").show(); 
                    $("#zoneDiv").hide(); 
                    $("#regionDiv").hide(); 

            //$("#filBranch").prop('required', false);
            $("#filArea").prop('required', true);
            $("#filZone").prop('required', false);
            $("#filRegion").prop('required', false);
        }
        else if($(this).val()=="Zone"){
            $("#branchDiv").hide(); 
            $("#areaDiv").hide(); 
            $("#zoneDiv").show(); 
            $("#regionDiv").hide(); 

            //$("#filBranch").prop('required', false);
            $("#filArea").prop('required', false);
            $("#filZone").prop('required', true);
            $("#filRegion").prop('required', false);
        }
        else if($(this).val()=="Region"){
            $("#branchDiv").hide(); 
            $("#areaDiv").hide(); 
            $("#zoneDiv").hide(); 
            $("#regionDiv").show(); 

            //$("#filBranch").prop('required', false);
            $("#filArea").prop('required', false);
            $("#filZone").prop('required', false);
            $("#filRegion").prop('required', true);
        }        
    });
            /*end on change filReportLevel hide/show contents*/
            $("#filReportLevel").trigger('change');

  }); /* Ready*/


</script>

@endsection