@extends('panel.layouts.app')
@section('page-title')
<title>
{{ LaraCore::setting('html_prefix') }} {{ (LaraCore::setting('html_prefix') != '') ? '|' : '' }} Bill Ledger</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 Ledger</h3>
          </div>
          <div class="box-header with-border head-design row">
            <div class="col-md-2">
              <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="col-md-2">
              <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-2">
              <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-2">
              <div class="form-group has-feedback err">
                <label>GST Type</label>
                {{ Form::select('is_gst', $gstType, '',["class"=>'form-control filter select2','autofocus' => 'true', 'id' => 'is_gst']) }}
              </div>
            </div>
            <div class="mar-top-btn">
              <div class="box-tools box-tools-common custom-grid-icon">
              {!! Form::open(["url"=>route('print-bill'), "method"=>"POST", "target"=>"_blank", "id"=>"billPrintForm"]) !!}
                  {{ Form::hidden('id','',['id'=>'billId']) }}
                  {{ Form::hidden('template','',['id'=>'billTemplate']) }}
                  {{ Form::hidden('month','',['id'=>'billMonth']) }}
              {!! Form::close() !!}

                {!! Form::open(["url"=>route('print.details.bill'),"method"=>"POST","target"=>"_blank"]) !!}
                {{ Form::hidden('id','',['id'=>'detailsBillId']) }}
                {{ Form::hidden('month','',['id'=>'detailsMonth']) }}
                {{ Form::close() }}
              </div>
              <div class="col-md-1">
                <button value="Reset" class="btn btn-sm btn-default btn-block reset-lazer-report-filter">Reset</button>
              </div>
              <div class="col-md-1">
                <button value="Print" class="btn btn-sm btn-default btn-block" onclick="printBillLazer(this)">Print</button>
              </div>
              <div class="col-md-1">
                <button value="Excel" class="btn btn-sm btn-default btn-block" onclick="exportBillLedger()">Excel</button>
              </div>
              <div class="col-md-1">
                <div class="box-tools box-tools-common pull-right">
                  <a href="javascript:void(0)" class="btn btn-box-tool show-tooltip" onclick="ToggleDataTable('bill-lazer-grid')" title="Search"><i class="fa fa-search"></i></a>
                </div>
              </div>
            </div>
            {{ Form::open(["url"=>route('print.bill.ledger'),"method"=>"POST","target"=>"_blank"]) }}
            {{ Form::hidden('client','',['id'=>'client']) }}
            {{ Form::hidden('sdate','',['id'=>'sdate']) }}
            {{ Form::hidden('edate','',['id'=>'edate']) }}
            {{ Form::hidden('isgst','',['id'=>'isgst']) }}
            {{ Form::close() }}
          </div>
          <div class="box-body">
            <div class="table-responsive">
              <table id="bill-lazer-grid" class="table table-bordered table-hover display">
                <thead>
                  <th>Id</th> 
                  <th>Bill No.</th>
                  <th>Type</th>
                  <th>Name</th>
                  <th>Date</th>
                  <th>Amount</th>
                  <th>Fuel Ch.</th>
                  <th>CGST</th>
                  <th>SGST / UTGST</th>
                  <th>IGST</th>
                  <th>Grand Total</th>
                  <th>&nbsp;</th>
                </thead>
                <tbody>
                </tbody>
                <tfoot>
                  <tr class="bg-color-foot-color">
                    <th colspan="5" class="border-style text-center"> <b>Total Amount:</b></th>
                    <th class="border-style"></th>
                    <th class="border-style"></th>
                    <th class="border-style"></th>
                    <th class="border-style"></th>
                    <th class="border-style"></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) {
      BillLazerTable.draw();
    });
    initDate('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initDateRange('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initRichText();
    BillLazerTable = $('#bill-lazer-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": [ 3, "desc" ],
      processing: true,
      serverSide: true,
      ajax: {
        url : '{{route("post.bill.ledger")}}',
        type: 'POST',
        data: function (d) {
          d._token = $('hidden[name=_token]').val();
          d.client = $('select[name=clients]').val();
          d.start_date = $('input[name=start_date]').val();
          d.end_date = $('input[name=end_date]').val();
          d.is_gst = $('select[name=is_gst]').val();
        },
      },
      columns: [
      {data: 'id', name: 'bills.id',visible: false,searchable: false},
      {data: 'billno', name: 'billno', orderable: false},
      {data: 'bill_type', name: 'bill_type',searchable: true ,orderable: false}, 
      {data: 'client_name', name: 'client_name'},
      {data: 'date', name: 'date'},
      {data: 'amount', name: 'amount', className: 'text-right'},
      {data: 'fchpercent', name: 'fchpercent', className: 'text-right'},
      {data: 'cgstpercent', name: 'cgstpercent', className: 'text-right'},
      {data: 'sgstpercent', name: 'sgstpercent', className: 'text-right'},
      {data: 'igstpercent', name: 'igstpercent', className: 'text-right'},
      {data: 'grandtotal', name: 'grandtotal', searchable:false, className:'text-right'},
      {data: 'print',name: 'print',orderable: false,searchable: false, width: "5%",className: 'text-center' },       
      ],'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;
        };

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

        $( api.column(5).footer() ).html(
          Number(amount).toLocaleString('en')
          );

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

        $( api.column(6).footer() ).html(
          Number(fchpercent).toLocaleString('en')
          );

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

        $( api.column(7).footer() ).html(
          Number(cchpercent).toLocaleString('en')
          );

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

        $( api.column(8).footer() ).html(
          Number(schpercent).toLocaleString('en')
          );

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

        $( api.column(9).footer() ).html(
          Number(ichpercent).toLocaleString('en')
          );

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

        $( api.column(10).footer() ).html(
          Number(grandtotal).toLocaleString('en')
          );
      },
    });
    initSelectAll('#bill-lazer-grid', BillLazerTable);
  });

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

  $( ".reset-lazer-report-filter" ).click(function(e) {
    $('select[name=clients]').val('').change();
    var startDate = '{{$startDate}}';
    var endDate = '{{$endDate}}';
    $('input[name=start_date]').val(startDate);
    $('input[name=end_date]').val(endDate);
    $('select[name=is_gst]').val('').change();
    BillLazerTable.draw();
  });

  function printBillLazer(element) {
    var client = $('select[name=clients]').val();
    var start_date = $('input[name=start_date]').val();
    var end_date = $('input[name=end_date]').val();
    var is_gst = $('select[name=is_gst]').val();
    $('#client').val(client);
    $('#sdate').val(start_date);
    $('#edate').val(end_date);
    $('#isgst').val(is_gst);
    $('#sdate').parents('form').attr('action', "{{ route('print.bill.ledger') }}").submit();
}

function exportBillLedger() {
    var client = $('select[name=clients]').val();
    var start_date = $('input[name=start_date]').val();
    var end_date = $('input[name=end_date]').val();
    var is_gst = $('select[name=is_gst]').val();
    $('#client').val(client);
    $('#sdate').val(start_date);
    $('#edate').val(end_date);
    $('#isgst').val(is_gst);
    $('#sdate').parents('form').attr('action', "{{ route('export.bill.ledger') }}").submit();
}

function getBillId(element) {
    var billType = $(element).data('bill-type');
    var month = element.getAttribute('data-month'); 
    //console.log("Month selected: " + month);
    var id = $(element).attr('data-id');
    var template = $(element).attr('data-template');
    var isGst = $(element).attr('data-is-gst');
    //console.log("selected GST: " + isGst);
    $('#billId').val(id);
    $('#billTemplate').val(template);
    $('#billMonth').val(month); 
    var form = $('#billId').parents('form');
    var actionUrl = form.attr('action'); 
    if (billType === 'International') {
        actionUrl = "{{ route('print.international.bill') }}";
    } else if (billType === 'Cargo') {
        actionUrl = "{{ route('print.cargo.bill') }}";
    } else if (isGst === '0') {
        actionUrl = "{{ route('wg.print.bill') }}"; 
    } else {
        actionUrl = "{{ route('print-bill') }}"; 
    }
    form.attr('action', actionUrl).submit();
    if ($('input[name="print_both"]').is(':checked')) {
        setTimeout(function () {
            $('#detailsBillId').val(id);
            $('#detailsMonth').val(month);
            $('#detailsBillId').parents('form').submit();
        }, 1000);
    }
}

function loadMoreTemplate(element) {
     var id = $(element).attr('data-id');
     var loadMoreButton = $('.template-' + id).find('.hide-template').removeClass('hide-template').addClass('.show-template');
     var hideLoadMoreButton = $('.template-' + id).find('.loadMoreButton').addClass('hide-template');
}

function PrintSelectedBill(element) {
    var Id = $(element).attr('data-id');
    var template = $(element).attr('data-template');
    var ListTable = $('#' + Id);
    var ListTbody = $(ListTable).find('tbody');
    var CheckBoxes = $(ListTbody).find('input[type="checkbox"]');
    var Selected = $(ListTbody).find("input[type=checkbox]:checked").map(function () {
      return this.value;
    }).get().join(",");
    if (Selected == '') {
    toastr.error('Please select atleast one bill', 'Error !', {
           onHidden: function () {
     }
    });
    } else {
      $('#billId').val(Selected);
      $('#billTemplate').val(template);
      $('#billMonth').val($('select[name=current_month]').val());
      $('#billId').parents('form').submit();
  }
}
</script>
@stop