@extends('panel.layouts.app')
@section('page-title')
<title>
{{ LaraCore::setting('html_prefix') }} {{ (LaraCore::setting('html_prefix') != '') ? '|' : '' }} Sales 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-cube"></i>
            <h3 class="box-title">
              Sales Report
            </h3>
            <div class="box-tools box-tools-common pull-right">
              {{ Form::open(["url"=>route('print.sales.report'),"method"=>"POST","target"=>"_blank"]) }}
              {{ Form::hidden('id','',['id'=>'billId']) }}
              {{ Form::close() }}
              {{ Form::open(["url"=>route('print.sales.gstformat.report'),"method"=>"POST","target"=>"_blank"]) }}
              {{ Form::hidden('id','',['id'=>'billIdForGSTFormat']) }}
              {{ Form::close() }}
              {{ Form::open(["url"=>route('genarate.sales.excel.report'),"method"=>"POST"]) }}
              {{ Form::hidden('id','',['id'=>'genarateBillExcelReport']) }}
              {{ Form::close() }}
              <a href="javascript:void(0)" class="btn btn-box-tool show-tooltip" onclick="ToggleDataTable('bills-grid')" title="Search"><i class="fa fa-search"></i></a>
            </div>

          </div>
          <div class="box-body">
            <div class="table-responsive">
             <table id="bills-grid" class="table table-bordered table-hover display">
               <thead>
                <th>Order</th>
                <th>Month</th>
                <th class="text-center">Amount</th>
                <th>&nbsp;</th>  
              </thead>
              <tbody>
              </tbody>
              <tfoot>
                <tr class="bg-color-foot-color">
                  <th colspan="2" class="border-style"> <b>Total Amount:</b></th>
                  <th class="border-style"></th>
                  <th class="border-style"></th>
                </tr>
              </tfoot>
            </table> 
          </div>
        </div>
      </div>
      <div class="bills_modal_div">
        <div class="edit_modal">
        </div>
      </div>
      @include('common.modal.send_outward_mail_confirm_model',['entity' =>  'monthly_report'])
    </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();
    billsTable = $('#bills-grid').DataTable({
      'language': { "emptyTable": '{{LaraCore::setting('no_records')}}', "processing": "<i class='fa fa-spinner fa-spin fa-3x'></i>" },
      "aLengthMenu": [[10, 20, 30, 40, 50], [10, 20, 30, 40, 50]],
      "order": [ '0', "desc" ],
      processing: true,
      serverSide: true,
      ajax: {
        url : '{{route("post.sales.report")}}',
        type: 'POST',
      },
      columns: [
      {data: 'order', name: 'order', visible : false},
      {data: 'month', name: 'month'},
      {data: 'amount', name: 'amount',className:'text-right'},
      {data: 'actions', name: 'actions', orderable:false,searchable:false,className:'text-center',width: "35%"},
      ],'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(2)
        .data()
        .reduce( function (a, b) {
          return intVal(a) + intVal(b);
        }, 0 );

        $( api.column(2).footer() ).html(
          Number(amount).toLocaleString('en')
          );
      },
    });

    $(document).on('click', '#send_monthly_report', function(e){
      var email = $('input[name=email]').val();
      var name = $('input[name=name]').val();
      var id = $('#billIdForMail').val();
      
      if(email == '' || email == null){
        $('.err').addClass('has-error');
      }else{
        $('.err').removeClass('has-error');
        var url = APP_URL+"/send-sales-report-mail";
        var btn = $(this);
        btn.prop("disabled", true);
        btn.html('Yes, Send <i class="fa fa-spinner fa-spin"></i>');
        $.ajax({
          type: "POST",
          url: url,
          data: { 'email' : email, 'id' : id },
          dataType: 'json',
          success: function (data) {
            btn.prop("disabled", false);
            btn.html('Yes, Send');
            $('#send_monthly_report_modal').modal('hide');
            DisplayMessages(data['message']);
          },
          error: function (jqXHR, exception) {
            var Response = jqXHR.responseText;
            Response = $.parseJSON(Response);
            DisplayMessages(Response.message,'error');
          }
        });  
      }
    });
  });

  $(document).on('hidden.bs.modal', '#send_monthly_report_modal',function (event) { 
    $('.err').removeClass('has-error');
    var email = $('input[name=email]').val('');
    var name = $('input[name=name]').val('');
    var id = $('#billIdForMail').val('');
  });

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

  function getBillIdForMail(element) {
    var id = $(element).attr('data-id');
    $('#send_monthly_report_modal').find('#billIdForMail').val(id);
  }

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

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

</script>
@stop