@extends('layouts/microfin_layout')
@section('title', '|POMIS-3A Report')
@section('content')

@include('microfin/reports/pksfPomisReport/pksfPomis3AReportViews/pksfPomis3AReportAjax')

<style media="screen">
.hide {
  display:  none;
}
 
.form-group, .form-control{
    font-size: 11px !important;
    color: black !important;
}
.form-control{
    padding: 5px !important;
}
#reportSubmit{ 
    font-size: 12px;
    margin-top: 20px;
}
</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-right print-icon"  target="_blank" style="">
                    <i class="fa fa-print fa-lg" aria-hidden="true"> Print</i>
                  </button> --}}

                  <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>
                </div>
                <h3  style=" text-align: center; font-family: Antiqua; letter-spacing: 2px; color: white;">
                  POMIS-3A Report
                </h3>
              </div>

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

                <div class="row">
                  <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']) !!}
                              </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']) !!}
                              </div>
                              <div class="col-md-12">                                  
                                  <select id="filArea" name="filArea" class="form-control input-sm">
                                      <option value="All">--All--</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']) !!}
                              </div>
                              <div class="col-md-12">                                  
                                  <select id="filZone" name="filZone" class="form-control input-sm">
                                      <option value="All">--All--</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']) !!}
                              </div>
                              <div class="col-md-12">                                  
                                  <select id="filRegion" name="filRegion" class="form-control input-sm">
                                      <option value="All">--All--</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']) !!}
                              </div>
                              <div class="col-md-12">
                                  {!! Form::select('filBranch', ['All'=>'--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

                      @if(in_array($userRoleId, Config('services.branch_level_user_roles')))
                      <div class="col-md-1" id="branchDiv">
                          <div class="form-group">
                              <div class="col-md-12">
                                  {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                              </div>
                              <div class="col-md-12">
                                  {!! Form::select('filBranch', $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('', 'Year:', ['class' => 'control-label pull-left']) !!}
                              </div>
                              <div class="col-md-12">
                                  {!! Form::select('Year',[''=>'--Select Year--']+$yearsOption, null,['id'=>'filYear','class'=>'form-control input-sm', 'autocomplete'=>'off','required']) !!}
                                  <p id='filYearE' style="max-height:3px; color:red;"></p>
                              </div>
                          </div>
                      </div>

                      <div class="col-md-1">
                        <div class="form-group">
                          <div class="col-md-12">
                            {!! Form::label('', 'Month:', ['class' => 'control-label pull-left']) !!}
                          </div>
                          <div class="col-md-12">
                            <select name="searchMonth" class="form-control input-sm" id="searchMonth" required="true">
                              <option value=""> -- Select Month -- </option>
                              <option value="1-6">January to June</option>
                              <option value="7-12">July to December</option>
                            </select>
                            {{-- <p id='filBranchE' style="max-height:5px; color:red;"></p> --}}
                          </div>
                        </div>
                      </div>

                      <div class="col-md-1">
                        <div class="form-group">
                          <div class="col-md-12">
                            {!! Form::label('','Options:', ['class' => 'control-label pull-left']) !!}
                          </div>
                          <div class="col-md-12">
                            <select name="loanOptions" class="form-control input-sm" id="loanOptions"  required="true">
                              <option value=""> -- Select Loan Options-- </option>
                              <option value="LoanProduct">Loan Product</option>
                              <option value="LoanProductCategory">Loan Product Category</option>
                            </select>
                          </div>
                        </div>
                      </div>


                      <div class="col-md-1">
                        <div class="form-group">
                          {!! Form::label('', '', ['class' => 'control-label col-md-12']) !!}
                          <div class="col-md-12">                                    
                            {!! Form::submit('Show Report', ['id' => 'reportSubmit', 'class' => 'btn btn-primary btn-xs']); !!}
                          </div>
                        </div>
                      </div>
                    </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 -->

      {{-- @include('microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table'); --}}
    </div>

    <script type="text/javascript">

      /*$("select").on("change",function(){
        var a = $(this).val();
        if (a == 'Y') {
          $(".feel-me").addClass("hide");
        }else if (a == 'N') {
          $(".feel-me").removeClass("hide");
        }
      });*/

     /* $(function(){
        $( "#txtDate1" ).datepicker({
         dateFormat: "yy-mm-dd",
         showOtherMonths: true,
         selectOtherMonths: true,
         changeMonth: true,
         changeYear: true,
         yearRange: "-50:+0",
         maxDate: "dateToday"
       }).val();
      })

      $(function(){
        $( "#txtDate2" ).datepicker({
         dateFormat: "yy-mm-dd",
         showOtherMonths: true,
         selectOtherMonths: true,
         changeMonth: true,
         changeYear: true,
         yearRange: "-50:+0",
         maxDate: "dateToday"
       }).val();
      })*/

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

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

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

$(document).ready(function() {

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

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

    var printStyle = '<style>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; size: A4 landscape !important;}</style><style>@media print {.element-that-contains-table { overflow: visible !important; } body {transform: scale(1); -moz-transform: scale(1); -moz-transform: rotate(-90deg);}}</style><style>@page:first{tr:nth-of-type(4n){page-break-after: always;}}</style>';

    //transform: scale(0.5);transform-origin: 0 0;
    //-webkit-transform:scale(.8,.8);

    // var printStyle = '<style>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; size: landscape;}</style><style>@media print { body{zoom:60%} .element-that-contains-table { overflow: visible !important; } }</style><style>@page:first{tr:nth-of-type(4n){page-break-after: always;}}</style>';

    // var printStyle = '<style media="print">@media screen and (orientation:landscape){size:auto a4 landscape !important;} tbody tr td {border:1px solid black !important;font-weight:normal;} thead tr th {border:1px solid black !important;color:black !important;background-color:none; font-weight:bold; !important;} @page {size: auto;margin: 10px auto;}</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();

}); /* Ready to print */

</script>

<script type="text/javascript">
  /*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);
          }        
        });
</script>

@endsection