@extends('layouts.app')

        @section('styles')

        @endsection

            @section('content')
                             <!-- PAGE-HEADER -->
                            <div class="page-header">
                                <h1 class="page-title">Month Wise Report</h1>
                                <div>
                                    <ol class="breadcrumb">
                                        <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                                         <li class="breadcrumb-item"><a href="javascript:void(0)">Reports</a></li>
                                        <li class="breadcrumb-item active" aria-current="page">Month Wise Report</li>
                                    </ol>
                                </div>
                            </div>
                            <!-- PAGE-HEADER END -->

                               <!-- Row -->
                        
                            <input type="hidden" name="" id="order_id">
                             <div class="row">
                            <div class="col-12 col-sm-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title mb-0">View Month Wise Report</h3>
                                    </div>
                                    <div class="card-body pt-4">
                                        <div class="grid-margin">
                                            <div class="">
                                                <div class="panel panel-primary">
                                                    <div class="tab-menu-heading border-0 p-0">
                                                        <div class="tabs-menu1">
         
                                                            <ul class=" nav panel-tabs product-sale">
                                                

                                                <li class="">
                                         <a target="_blank" title="Download Excel" class="btn custom-btn-success btn-sm" href="/admin/reports/monthly_report_export"><span class="fa fa-file-excel-o text-white"> </span></a>
                                         
                                         
                                             {{--    <button type="button" class="btn btn-icon  btn-danger"><i class="fa fa-file-pdf-o"></i></button> --}}

                                                </li>


                                               


                                                <li class="px-2">
                                                <div class="input-group">
                                                <div class="input-group-text custom-btn-info">
                                                    <i class="fa fa-calendar tx-16 lh-0 op-6"></i>
                                                </div>
                                                @php
                                                    $from_date="";
                                                    if(session('from_date')){
                                                        $from_date=session('from_date');
                                                    }
                                                @endphp
                                                <input class="form-control fc-datepicker from_date" placeholder="From Date" value="{{$from_date}}" type="text">
                                                </div>    
                                                </li>
                                                        
                                                <li class="px-1">
                                                <div class="input-group">
                                                <div class="input-group-text custom-btn-info">
                                                    <i class="fa fa-calendar tx-16 lh-0 op-6"></i>
                                                </div>
                                                @php
                                                    $to_date="";
                                                    if(session('to_date')){
                                                        $to_date=session('to_date');
                                                    }
                                                @endphp
                                                <input class="form-control fc-datepicker to_date" placeholder="To Date" value="{{$to_date}}" type="text">
                                                </div>
                                                </li>
                                            
                                            
                                                <li class="px-1">
                                                    <div class="input-group">
                                                <button id="reset_btn"  class="btn custom-btn-danger"><i class="fa fa-repeat"></i></button>  
                                                    </div>    
                                                </li>

                                                        
                                                         </ul>
                                                        </div>
                                                    </div>
                                                    <div class="panel-body tabs-menu-body border-0 pt-0">
                                                        <div class="tab-content">
                                                            <div class="tab-pane active" id="tab5">
                                                                <div class="table-responsive">
                                                                    <table class="table table-bordered text-nowrap border-bottom " style="width: 100% !important;"  id="table_datatable">
                                                                        <thead class="border-top text-center">
                                                                            <tr>
                                                                                 <th class="bg-transparent border-bottom-0 w-5">#</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Month</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Success Order</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Failed Order</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5" >Total Order </th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Success Amt</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Failed Amt</th>
                                                                                    <th class="bg-transparent border-bottom-0 w-5">Total Amt</th>
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody></tbody>
            <tfoot>
                  <tr id="footer">
                  <td colspan="2">
                      <span>Total</span>
                  </td>
                 
                  <td colspan="1">
                    <span>   </span>
                  </td>
                  <td colspan="1">
                    <span>   </span>
                  </td>
                  <td colspan="1">
                  <span>   </span>
                  </td>
                   <td colspan="1">
                   <span> </span>
                  </td>
                   <td colspan="1">
                   <span>  </span>
                  </td>
                   <td colspan="1">
                   <span>  </span>
                  </td>
                
                </tfoot>
                                                               
                                                                    </table>
                                                                </div>
                                                            </div>
                                                           
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                      
    

            @endsection
              @section('scripts')  
{{-- ################################Jquery Datatable########################### --}}
   <script src="{{asset('assets/jquery-datatable/jquery.min.js')}}"></script>
   <link rel="stylesheet" type="text/css" href="{{asset('assets/jquery-datatable/jquery.dataTables.css')}}">
   <script src="{{asset('assets/jquery-datatable/jquery.dataTables.js')}}"></script>
 {{-- ########################################################################## --}}
        <script>
    var token = $("meta[name=csrf-token]").attr("content");  
    var base_url='{{url('/')}}';
    var print_url  = '{{url('')}}/admin/order_print';
    var datatable_name="table_datatable";
$('#table_datatable').DataTable({
        "responsive": true,
       "serverSide": true,
       "ordering": false,
       "searching": false,
       "bLengthChange": false,
       "info":false,
       "bSort": true,
       "order": [
           [0, 'desc']
       ],
       "columnDefs": [{
               "targets": [0,4],
               "orderable": true
           },
           {"className": "text-center", "targets": [0,1,2,3,4,]},
           {"className": "text-left", "targets": []},
           
       ],
       "displayLength":10,
       "ajax": {
           "url":  "/admin/reports/month_wise_datatable",
           "type": "post",
           "data": function (data) {
                data._token = token;
              
               return data;
  
           }
       }, "AutoWidth": true,
       "columns": [
                  {"data": "month_name", "name": "month_name"},
                  {"data": "month_name", "name": "month_name"},
                  {"data": "payment_success_count", "name": "payment_success_count"},
                  {"data": "payment_failed_count", "name": "payment_failed_count"},
                  {"data": "total_order_count", "name": "total_order_count"},
                  {"data": "payment_success_total", "name": "payment_success_total"}, 
                  {"data": "payment_failed_total", "name": "payment_failed_total"},
                  {"data": "grand_total", "name": "grand_total"},
                   ],
      
      "fnCreatedRow": function (nRow, aData, iDataIndex) {
          var info = this.dataTable().api().page.info();
          var page = info.page;
          var length = info.length;
          var index = (page * length + (iDataIndex + 1));
          
           var success_total=Math.round(aData.payment_success_total);
          var failed_total=Math.round(aData.payment_failed_total);
          var grand_total=Math.round(aData.grand_total);
          
          
            $('td:eq(0)', nRow).html(index);
            $('td:eq(1)', nRow).html(aData.month_name+' - '+aData.year);
            $('td:eq(5)', nRow).html(success_total.toFixed(2)).css('text-align','right');
            $('td:eq(6)', nRow).html(failed_total.toFixed(2)).css('text-align','right');
            $('td:eq(7)', nRow).html(grand_total.toFixed(2)).css('text-align','right'); 
 },
   "footerCallback": function ( row, data, start, end, display ) {
             var org_api=this.api() ,data;
             var api=data;
            // Update footer
             if(end!=start){
            $('#footer').show();
            $( org_api.column( 2 ).footer() ).html(api[0].sum_payment_success_count).css({'font-weight':'bold'});
            $( org_api.column( 3 ).footer() ).html(api[0].sum_payment_failed_count).css({'font-weight':'bold'});
            $( org_api.column( 4 ).footer() ).html(api[0].sum_total_order_count).css({'font-weight':'bold'});
            $( org_api.column( 5 ).footer() ).html(api[0].sum_payment_success_total).css({'font-weight':'bold',"text-align":'right'});
            $( org_api.column( 6 ).footer() ).html(api[0].sum_payment_failed_total).css({'font-weight':'bold',"text-align":'right'});
            $( org_api.column( 7 ).footer() ).html(api[0].sum_grand_total).css({'font-weight':'bold',"text-align":'right'});
         }
          else{
             $('#footer').hide();
          }

        },
 });


 $('.from_date').change(function(){
                $.ajax({
                        type: 'POST',
                        data: {"_token": token,"from_date":  $('.from_date').val()},
                        url: '/admin/from_date_filter',
                        success: function (result) {
                        $("#table_datatable").DataTable().ajax.reload(null, false);
                        }
                    })

 })

 $('.to_date').change(function(){
                $.ajax({
                        type: 'POST',
                        data: {"_token": token,"to_date":  $('.to_date').val()},
                        url: '/admin/to_date_filter',
                        success: function (result) {
                        $("#table_datatable").DataTable().ajax.reload(null, false);
                        }
                    })

 })

 $('#reset_btn').click(function(){
        $.ajax({
                        type: 'POST',
                        data: {"_token": token},
                        url: '/admin/reset_session',
                        success: function (result) {
                        $('.from_date').val('');
                        $('.to_date').val('');
                        $("#table_datatable").DataTable().ajax.reload(null, false);
                        }
                    })
 });

        </script>
    <script src="{{asset('assets/js/tooltip&popover.js')}}"></script>
    <!-- INTERNAL Bootstrap-Datepicker js-->
    <script src="{{asset('assets/plugins/bootstrap-daterangepicker/daterangepicker.js')}}"></script>
    <!-- INTERNAL Bootstrap-Datepicker js-->
    <script src="{{asset('assets/plugins/bootstrap-datepicker/bootstrap-datepicker.js')}}"></script>
    <!-- TIMEPICKER JS -->
    <script src="{{asset('assets/plugins/time-picker/jquery.timepicker.js')}}"></script>
    <script src="{{asset('assets/plugins/time-picker/toggles.min.js')}}"></script>
    <!-- INTERNAL jquery transfer js-->
    <script src="{{asset('assets/plugins/jQuerytransfer/jquery.transfer.js')}}"></script>
    <!-- DATEPICKER JS -->
    <script src="{{asset('assets/plugins/date-picker/date-picker.js')}}"></script>
    <script src="{{asset('assets/plugins/date-picker/jquery-ui.js')}}"></script>
    <script src="{{asset('assets/plugins/input-mask/jquery.maskedinput.js')}}"></script>
    <!-- FORMELEMENTS JS -->
    <script src="{{asset('assets/js/formelementadvnced.js')}}"></script>
    <script src="{{asset('assets/js/form-elements.js')}}"></script>
        @endsection