@extends('panel.layouts.superadmin.app')
@section('page-title')
<title>
{{ LaraCore::setting('html_prefix') }} {{ (LaraCore::setting('html_prefix') != '') ? '|' : '' }} Subscription Bills</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">Subscription Bills</h3>
            <div class="box-tools box-tools-common ">
              {{ Form::open(["url"=>route('subscription.bill.print'),"method"=>"POST","target"=>"_blank"]) }}
              {{ Form::hidden('id','',['id'=>'subscriptionBillId']) }}
              {{ Form::close() }}
              <label class="label label-success label-space">Paid Rs. {{number_format($paid, 2)}}</label>
              <label class="label label-danger label-space">Pending Rs. {{number_format($pending, 2)}}</label>
              <a href="javascript:void(0)" class="btn btn-box-tool show-tooltip" onclick="ToggleDataTable('subscription-bills-grid')" title="Search"><i class="fa fa-search"></i></a>
            </div>
          </div>
          <div class="box-body">
            <div class="table-responsive">
              <table id="subscription-bills-grid" class="table table-bordered table-hover display">
                <thead>
                  <th>Id</th> 
                  <th>Account Name</th>
                  <th>Branch Name</th>
                  <th>Type</th>
                  <th>Start Date</th>
                  <th>End Date</th>
                  <th>Amount/Sub.</th>
                  <th>Paid Amt.</th>
                  <th>Pending Amt.</th>
                  <th>Due Date</th>
                  <th>Status</th>
                  <th>Print</th>
                  <th>Mail</th>
                  <th>Action</th>
                </thead>
                <tbody>
                </tbody>
                <tfoot>
                  <tr class="bg-color-foot-color">
                    <th colspan="6" class="border-style"> <b>Total Amount:</b></th>
                    <th class="border-style"></th>
                    <th class="border-style"></th>
                    <th class="border-style"></th>
                    <th colspan="5" class="border-style"></th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
        </div>
        <div class="incomes_modal_div">
          <div class="edit_modal">
          </div>
          {{-- @include('panel.incomes.create', [@$data]) --}}
        </div>
        @include('common.modal.send_report_mail_confirm_model',['entity' =>  'subscription_bill'])
      </section>
    </div>
    <div class="col-md-1"></div>
  </div>
</div>
@stop
@section('custom-scripts')
<script type="text/javascript">
  var rows_selected  = "";
  $(document).ready(function () {
    initDate('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initDateRange('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
    initRichText();
    SubscriptionBillsTable = $('#subscription-bills-grid').DataTable({
      'language': { "emptyTable": '{{LaraCore::setting('no_records')}}', "processing": "<i class='fa fa-spinner fa-spin fa-3x'></i>" },
      "aLengthMenu": [[50, 40, 30, 20, 10, -1], [50, 40, 30, 20, 10, 'All']],
      "order": [ 0, "desc" ],
      processing: true,
      serverSide: true,
      ajax: {
        url : '{{route("subscription.bills.list")}}',
        type: 'POST',
      },
      columns: [
      {data: 'id', name: 'id',visible: false,searchable: false},
      {data: 'account_name', name: 'account_name'},
      {data: 'branch_name', name: 'branch_name'},
      {data: 'type', name: 'type'},
      {data: 'start_date', name: 'start_date'},
      {data: 'end_date', name: 'end_date'},
      {data: 'amount', name: 'amount', className: 'text-right'},
      {data: 'paid', name: 'paid', className: 'text-right'},
      {data: 'pending', name: 'pending', className: 'text-right'},
      {data: 'due_date', name: 'due_date'},
      {data: 'status', name: 'status'},
      {data: 'print', name: 'print', orderable:false,searchable:false,className:'text-center'},
      {data: 'mail', name: 'mail', orderable:false,searchable:false,className:'text-center'},
      {data: 'action', name: 'action', orderable:false,searchable:false,className:'text-center'},
      ],'rowCallback': function(row, data, dataIndex){
              var rowId = data['id']; // Get row 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(6)
              .data()
              .reduce( function (a, b) {
                return intVal(a) + intVal(b);
              }, 0 );

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

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

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

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

              $( api.column(8).footer() ).html(
                Number(pending).toLocaleString('en')
              );
            },
          });
    // initSelectAll('#subscription-bills-grid', SubscriptionBillsTable);
    $(document).on('click', '#send_subscription_bill', function(e){
      var bill_id = $('input[name="billid"]').val();
      var url = APP_URL+"/send-subscription-bill-mail";

      $.ajax({
        type: "POST",
        url: url,
        data: {'bill_id' : bill_id},
        dataType: 'json',
        success: function (data) {
          $('#send_subscription_bill_modal').find('input[name="billid"]').val('');
          $('#send_subscription_bill_modal').modal('hide');
          DisplayMessages(data['message']);
          SubscriptionBillsTable.draw(true);
        },
        error: function (jqXHR, exception) {
          var Response = jqXHR.responseText;
          Response = $.parseJSON(Response);
          DisplayMessages(Response.message,'error');
        }
      });  
    });
  });

  function getSubscriptionBillId(element){
    var id = $(element).attr('data-id');
    $('#subscriptionBillId').val(id);
    $('#subscriptionBillId').parents('form').submit();
  }

  function getSubscriptionBillIdForMail(element){
    var id = $(element).attr('data-id');
    $('#send_subscription_bill_modal').find('input[name="billid"]').val(id);
    $('#send_subscription_bill_modal').modal('show');
  }

  function getSubscriptionBillDataForEdit(element){
    var bill_id = $(element).attr('data-id');
    $.ajax({
      type: "POST",
      url: '{{route('open.bill.edit.model')}}',
      data: {"bill_id":bill_id},
      dataType: "html",
      success: function(res) {
        $('body').append(res);
        initIcheck();
        initDate('{{AppHelper::dateFormatJS(LaraCore::setting('date_format'))}}');
      },
    }).done(function(result){
      $('#subscription_bill_edit_modal').modal('show');
      closeBillEditModel();
    });
  }

  function closeBillEditModel(){
    $('#subscription_bill_edit_modal').on('hidden.bs.modal', function () {
      $('#subscription_bill_edit_modal').remove();
    });
  }

  function saveSubscriptionBillEdit(form){
    var Data = $(form).serialize();
    $.ajax({
      type: "POST",
      url: $(form).attr('action'),
      data: Data,
      dataType: "json",
      beforeSend: function(msg){
        $(".master-loader").show();
      },
      success: function(res) {
        $("#subscription_bill_edit_modal").modal('hide');
        $(".master-loader").fadeOut();
        if(res.status == 'success' && res.message == 'updated'){
          toastr.success('Subscription bill updated successfully !', 'Success !', { onHidden: function() {
          }});
        }
        SubscriptionBillsTable.draw(true);
      },
      error: function (jqXHR, exception) {
        $(".master-loader").fadeOut();
        var Response = jqXHR.responseText;
        ErrorBlock = $(form);
        Response = $.parseJSON(Response);
        DisplayErrorMessages(Response, ErrorBlock, 'input');
      }
    });
    return false;
  }

  function openCommentModel(element){
    var bill_id = $(element).attr('bill-id');
    $.ajax({
      type: "POST",
      url: '{{route('open.bill.comment.model')}}',
      data: {"bill_id":bill_id},
      dataType: "html",
      success: function(res) {
        $('body').append(res);
      },
    }).done(function(result){
      $('#subscription_bill_comment_modal').modal('show');
      closeCommentModel();
    });
  }

  function closeCommentModel(){
    $('#subscription_bill_comment_modal').on('hidden.bs.modal', function () {
      $('#subscription_bill_comment_modal').remove();
    });
  }

  function saveSubscriptionBillComment(form){
    var Data = $(form).serialize();
    $.ajax({
      type: "POST",
      url: $(form).attr('action'),
      data: Data,
      dataType: "json",
      beforeSend: function(msg){
        $(".master-loader").show();
      },
      success: function(res) {
        $("#subscription_bill_comment_modal").modal('hide');
        $(".master-loader").fadeOut();
        if(res.status == 'success' && res.message == 'updated'){
          toastr.success('Status updated successfully !', 'Success !', { onHidden: function() {
          }});
        }
        SubscriptionBillsTable.draw(true);
      },
      error: function (jqXHR, exception) {
        $(".master-loader").fadeOut();
        var Response = jqXHR.responseText;
        ErrorBlock = $(form);
        Response = $.parseJSON(Response);
        DisplayErrorMessages(Response, ErrorBlock, 'input');
      }
    });
    return false;
  }

  
</script>
@stop