@extends('panel.layouts.app')
@section('page-title')
<title>
{{ LaraCore::setting('html_prefix') }} {{ (LaraCore::setting('html_prefix') != '') ? '|' : '' }} Bill Pending Report</title>
@stop
@section('content')
<div class="content-wrapper">
  <div class="row">
    <div class="col-md-1"></div>
    <div class="col-md-10">
      <section class="content">
        <div class="box box-default">
          <div class="box-header with-border">
            <i class="fa fa-inr"></i>
            <h3 class="box-title">Bill Pending Report</h3>
          </div>
          <div class="box-header with-border head-design">
            <div class="col-md-3">
              <div class="form-group has-feedback">
                <label>Start Date</label>
                {{Form::text( 'start_date', $startDate, [ "class" => "form-control", "id" => 'startDate' ]) }}
              </div>
            </div>
            <div class="col-md-3">
              <div class="form-group has-feedback">
                <label>End Date</label>
                {{Form::text( 'end_date', $endDate, [ "class" => "form-control", "id" => 'endDate' ]) }}
              </div>
            </div>
            {{-- <div class="col-md-3">
              <div class="form-group has-feedback err">
                <label>Clients</label>
                {{ Form::select('clients', $clients,'',["class"=>'form-control filter select2','autofocus' => 'true', 'id' => 'clients']) }}
              </div>
            </div> --}}
            <div class="mar-top-btn">
              <div class="col-md-1">
                <button value="Reset" class="btn btn-sm btn-default btn-block reset-pending-filter">Reset</button>
              </div>
              <div class="col-md-1">
                <button value="Print" class="btn btn-sm btn-default btn-block" onclick="printBillPendingReport(this)">Print</button>
              </div>
              <div class="col-md-4">
                <div class="box-tools box-tools-common pull-right">
                  <a href="javascript:void(0)" class="btn btn-box-tool show-tooltip" onclick="ToggleDataTable('bill-pending-report-grid')" title="Search"><i class="fa fa-search"></i></a>
                </div>
              </div>
            </div>
            {{ Form::open(["url"=>route('print.bill.pending.report'),"method"=>"POST","target"=>"_blank"]) }}
            {{ Form::hidden('sdate','',['id'=>'sdate']) }}
            {{ Form::hidden('edate','',['id'=>'edate']) }}
            {{ Form::close() }}
          </div>
          <div class="box-body">
            <div class="table-responsive">
              <table id="bill-pending-report-grid" class="table table-bordered table-hover display">
                <thead>
                  <th>Id</th>
                  <th>Sr. No.</th>
                  <th>Name</th>
                  <th>Grand Total</th>
                </thead>
                <tbody>
                </tbody>
                <tfoot>
                  <tr class="bg-color-foot-color">
                    <th colspan="3" class="border-style text-center"> <b>Total Amount:</b></th>
                    <th class="border-style"></th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
        </div>
      </section>
    </div>
    <div class="col-md-1"></div>
  </div>
</div>
@stop
@section('custom-scripts')
<script type="text/javascript">
  var rows_selected  = "";
  $(document).ready(function () {
    $('#endDate, #startDate').daterangepicker({
      singleDatePicker: true,
      autoUpdateInput: true,
      drops: "down",
      locale: {
        format: '{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}',
      },
    }).on('change', function(e) {
      BillPendingReportTable.draw();
    });
    initDate('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initDateRange('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initRichText();
    BillPendingReportTable = $('#bill-pending-report-grid').DataTable({
      'language': { "emptyTable": '{{LaraCore::setting('no_records')}}', "processing": "<i class='fa fa-spinner fa-spin fa-3x'></i>" },
      "aLengthMenu": [[-1,10, 20, 30, 40, 50], ['All',10, 20, 30, 40, 50]],
      "order": [ 2, "asc" ],
      processing: true,
      serverSide: true,
      ajax: {
        url : '{{route("post.bill.pending.report")}}',
        type: 'POST',
        data: function (d) {
          d._token = $('hidden[name=_token]').val();
          d.start_date = $('input[name=start_date]').val();
          d.end_date = $('input[name=end_date]').val();
        },
      },
      columns: [
      {data: 'id', name: 'bills.id',visible: false,searchable: false},
      {data: 'sr_no', name: 'sr_no', width: 'auto', searchable:false, sorting: false, render: function (data, type, row, meta) { return meta.row + meta.settings._iDisplayStart + 1; }},
      {data: 'name', name: 'clients.name', width: 'auto%'},
      {data: 'grandtotal', name: 'bills.grandtotal', searchable:false, className:'text-right', width: 'auto%'},
      ],'rowCallback': function(row, data, dataIndex){
        var rowId = data['id'];
        if($.inArray(rowId, rows_selected) !== -1){
          $(row).find('.entity_chkbox').prop('checked', true);
          $(row).addClass('selected');
        }
      },
      footerCallback: function (row, data, start, end, display){
        var api = this.api(), data;
        var intVal = function ( i ) {
          return typeof i === 'string' ?
          i.replace(/[\$,]/g, '')*1 :
          typeof i === 'number' ?
          i : 0;
        };

        grandtotal = api
        .column(3)
        .data()
        .reduce( function (a, b) {
          return intVal(a) + intVal(b);
        }, 0 );

        $( api.column(3).footer() ).html(
          Number(grandtotal).toLocaleString('en')
          );
      },
    });
    initSelectAll('#bill-pending-report-grid', BillPendingReportTable);
  });

  $( ".filter" ).change(function(e) {
    e.preventDefault();
    BillPendingReportTable.draw();
  });

  $( ".reset-pending-filter" ).click(function(e) {
    var startDate = '{{$startDate}}';
    var endDate = '{{$endDate}}';
    $('input[name=start_date]').val(startDate);
    $('input[name=end_date]').val(endDate);
    BillPendingReportTable.draw();
  });

  function printBillPendingReport(element) {
      var start_date = $('input[name=start_date]').val();
      var end_date = $('input[name=end_date]').val();
      $('#sdate').val(start_date);
      $('#edate').val(end_date);
      $('#sdate').parents('form').submit();
  }
  
</script>
@stop