@extends('layouts.app')

@section('appjs')
    <script type="application/javascript" src="{{ asset('js/app.js') }}"></script>
@endsection

@section('content')
@section('page_title')
    Gateway-Wise
@endsection
<style>
    thead, th {text-align: center;}
    .export_account_based_report,.greenIcon{
        cursor: pointer;
    }
    #childtable-account-based-1_wrapper .dataTable thead th{
        color: black;
    }
</style>
<div class="container-fluid">
    <div class="card">      
    <div class="card-header"><h2>  Gateway Wise
        @can('hasExcelPermission')
        <form action="{{ url('exportGatewayWiseReport') }}" class="pull-right">
                @csrf
                <button type="submit" class="gateway_excel_btn btn excel-btn btn-sm pull-right border-radius-0"><i class="fa fa-download"></i> Export</button>
                <input type="hidden" name="fromdate" id="from_date_hidden" />
                <input type="hidden" name="todate" id="to_date_hidden"/>
                <input type="hidden" name="date_filter" id="date_filter_hidden"/>
            </form>
            <form class="pull-right mr-3" id="account_based_form" action="{{ url('exportAccountBased') }}">
                <input type="hidden" name="acc_fromdate" id="acc_from_date_hidden" />
                <input type="hidden" name="acc_todate" id="acc_to_date_hidden"/>
                <input type="hidden" name="acc_date_filter" id="acc_date_filter_hidden"/>
                <input type="hidden" name="acc_server_id" id="serverid_filter_hidden"/>
            </form>
        @endcan
    </h2></div>

    <div class="card-body table-responsive">
    <form class="flex">
                <div class="form-group col-md-2 col-sm-2 col-xs-2 col-lg-2">
                        <label for="period_filter">Choose Time Period</label>
                        <select id="period_filter" class="form-control">
                            <option value=''>Select</option>
                            <option value="1">Today</option>
                            <option value="2">Yesterday</option>
                            <option value="3">This Month</option>
                            <option value="4">Last Month</option>
                            <option value="5">Last 6 Months</option>
                            <option value="6">This Year</option>
                            <option value="7">Last Year</option>
                        </select>
                    </div>
            <div class="form-group col-md-2">
                <label for="start_date">From Date</label>
                <input type="text" class="form-control" id="start_date" name="start_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
            </div>

            <div class="form-group col-md-2">
                <label for="end_date">To Date</label>
                <input type="text" class="form-control" id="end_date" name="end_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
            </div>
            <div class="form-group col-md-2">
                <label for="date_filter">Date Filter</label>
                    <select id="date_filter" class="form-control">
                            <option value='0'>Day</option>
                            <option value='1'>Month</option>
                            <option value='2'>Year</option>
                    </select>
             </div>
    </form>
        <table class="table-bordered table-hover" id="report-main-table">
        <thead>
                <tr>
                    <th align="center">Sl.No</th>
                    <th align="center">Date</th>
                    <th align="center">Gateway</th>
                    <th align="center">Application  Gateway</th>
                    <th align="center">Sms Type</th>
                    <th align="center">Volume Pushed</th>
                    <th align="center">Total SMS  Units <span data-toggle="tooltip" title="(Gateway Submission + Yulore Submission)"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                    <th align="center">Volume Submitted By Gateway </th>
                    <th align="center">Volume Submitted By Yulore </th>
                    <th align="center">Total Delivery Count <span data-toggle="tooltip" title="(Gateway Delivery Count + Yulore Delivery Count)"><i class="fa fa-info-circle" aria-hidden="true"></i></span> </th>
                    <th align="center">Volume Delivered BY Gateway</th>
                    <th align="center">Volume Delivered By Yulore </th>
                    <th align="center">Total Volume Submitted</th>
                    <th align="center">Total Users</th>
                    <th align="center">Account Based</th>
                </tr>
            </thead>
            <tfoot>
            <tr>
                <th>Total</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>
                <th>NA</th>

            </tr>
         </tfoot>
    </table>
    </div>
</div>
<link rel="stylesheet" href="{{asset('css/jquery-ui.css')}}"/>
<script type="application/javascript" src="{{ asset('js/jquery-ui.js') }}"></script>
<script type="application/javascript">

$(document).ready(function() {
    /* call function while DOM get ready to get all records.*/
    var date_filter = '';
    getGatwayReportList();

    $(".gateway_excel_btn").click(function(){
            var start_date = $('#start_date').val();
            var end_date = $('#end_date').val();
            var date_filter = $('#date_filter').val();
            $('#from_date_hidden').val(start_date);
            $('#to_date_hidden').val(end_date);
            $('#date_filter_hidden').val(date_filter);
            $(this).submit();
        });

        $(document).on('click',".export_account_based_report", function(){
            var start_date = $('#start_date').val();
            var end_date = $('#end_date').val();
            var date_filter = $('#date_filter').val();
            var server_id = $(this).data('server-id');
            $('#acc_from_date_hidden').val(start_date);
            $('#acc_to_date_hidden').val(end_date);
            $('#acc_date_filter_hidden').val(date_filter);
            $('#serverid_filter_hidden').val(server_id);
            $('#account_based_form').submit();
        });

  /**select from date here***/
    $("#start_date").datepicker({
        dateFormat: 'yy-mm-dd',
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        endDate: 'today',
        onSelect: function (selectedDate) {
            var startDate = $('#start_date').datepicker('getDate');
            $('#end_date').datepicker('option', 'minDate', startDate);
            $('#end_date').datepicker('setDate', startDate);
            var date_filter = $('#date_filter').val();
            getGatwayReportList(date_filter);
            $('#period_filter').val('');
        }
    });

    /**select to date here***/
    $("#end_date").datepicker({
        dateFormat: 'yy-mm-dd',
        minDate: $("#start_date").datepicker("getDate"),
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        onClose: function() {
            var startDate = $('#start_date').datepicker('getDate');
            var endDate = $('#end_date').datepicker('getDate');
            if(startDate==null){
                $('#start_date').datepicker('setDate', endDate);
            }
            if (endDate < startDate) {
                var minDate = $('#end_date').datepicker('option', 'minDate', startDate);
                $('#end_date').datepicker('setDate', minDate);
            }
            var date_filter = $('#date_filter').val();
            getGatwayReportList(date_filter);
        },
        onSelect: function() {
            $('#period_filter').val('');
        }
    });

    $("body").on("change", "#period_filter", function(){
            var periodValue = $(this).val();           
            $("#start_date").val('');
            $("#end_date").val('');
            if(periodValue==''){
                getGatwayReportList();
            }
            //filter by today
            if(periodValue=='1'){
                var start_date = new Date().toJSON().slice(0,10);
                var end_date = new Date().toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }

            //filter by yesterday
            else if(periodValue=='2'){
                var start_date =  new Date(Date.now() - 864e5).toJSON().slice(0,10);
                var end_date =  new Date(Date.now() - 864e5).toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }

            //filter by this month
            else if(periodValue=='3'){
                var start_date = new Date();
                var end_date = new Date().toJSON().slice(0,10);
                start_date = new Date(start_date.setMonth(start_date.getMonth()));
                start_date = new Date(start_date.setDate(1));
                start_date = start_date.toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }

            //filter by last month
            else if(periodValue=='4'){
                var start_date = new Date();
                var end_date = new Date();
                start_date = new Date(start_date.setDate(1));
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 1));
                start_date = start_date.toJSON().slice(0,10);
                end_date = new Date(end_date.setDate(1)-864e5);
                end_date = end_date.toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }

            //filter by last 6 month
            else if(periodValue=='5')
            {
                var start_date = new Date();
                var end_date = new Date();
                end_date = new Date(end_date.setDate(1)-864e5);
                end_date = end_date.toJSON().slice(0,10);
                start_date = new Date(start_date.setDate(1));
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 6));
                start_date = start_date.toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }

            //filter by this year
            else if(periodValue=='6')
            {
                var end_date = new Date().toJSON().slice(0,10);
                var makeDate = new Date(end_date);
                var start_date = new Date(makeDate.setMonth(0));
                start_date = new Date(makeDate.setDate(1));
                start_date = start_date.toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }
            //filter by previous year
            else if(periodValue=='7'){
                var end_date = new Date();
                var start_date = new Date();
                end_date = new Date(end_date.setMonth(0));
                end_date = new Date(end_date.setDate(1)-864e5).toJSON().slice(0,10);
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 12));
                start_date = new Date(start_date.setMonth(0));
                start_date = new Date(start_date.setDate(1)).toJSON().slice(0,10);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                var date_filter = $('#date_filter').val();
                getGatwayReportList(date_filter);
            }
        });
        $("body").on("change", "#date_filter", function(){
            var date_filter = $(this).val();
            getGatwayReportList(date_filter);
        });

});

//all records displaying here

function getGatwayReportList(){
        var start_date = $('#start_date').val();
        var end_date = $('#end_date').val();
        var date_filter = $('#date_filter').val();
        $.ajax({
            type: "POST",
            url: 'gatewayWiseReport',
            data: {
                "_token"     : "{{ csrf_token() }}",
                "start_date" : start_date,
                "end_date"   : end_date,
                "date_filter" : date_filter,
            },
            success: function(data) {
                var gatewaydata = data['data'];
                $("#report-main-table").DataTable().clear().destroy();
                $('#report-main-table').DataTable({
                    data: gatewaydata,
                    "bFilter": false,
                    "bLengthChange": false,
                    "bPaginate": false,
                    "scrollX": true,
                    "paging": true,
                    "bProcessing":true,
                    "bLengthChange": true,
                    "scrollY":  400,
                    "pageLength": 20,
                    "scrollCollapse": true,
                    "language": { search: '', searchPlaceholder: "Search..." },
                    columnDefs: [ { searchable: false, orderable: false, targets: 0,},],
                aoColumns: [
                    { data: "", render: function ( data, type, row ) {
                        return '';
				    }
			        },
                    { data: "date_report",
                         render: function(data, type, row, meta) {
                            return ((row.date_report)  ? row.date_report :  "NA")
                          }
                    },
                    { data: "server_name",
                         render: function(data, type, row, meta) {
                            return ((row.server_name)  ? row.server_name :  "NA")
                          }
                    },
                    { data: "alias_server_name",
                         render: function(data, type, row, meta) {
                            return ((row.alias_server_name)  ? row.alias_server_name :  "NA")
                          }
                    },
                    { data: "sms_type",
                         render: function(data, type, row, meta) {
                            return ((row.sms_type)  ? row.sms_type :  "NA")
                          }
                    },
                    { data: "pushed_volume",
                         render: function(data, type, row, meta) {
                            return ((row.pushed_volume)  ? row.pushed_volume :  "0")
                          }
                    },
                    { data: "sms_unit",
                         render: function(data, type, row, meta) {
                            return ((row.sms_unit)  ? row.sms_unit :  "0")
                          }
                    },
                    { data: "gateway_submission",
                         render: function(data, type, row, meta) {
                            return ((row.gateway_submission)  ? row.gateway_submission :  "0")
                          }
                    },
                    { data: "yulore_submission",
                         render: function(data, type, row, meta) {
                            return ((row.yulore_submission)  ? row.yulore_submission :  "0")
                          }
                    },
                    { data: "delivery_count",
                         render: function(data, type, row, meta) {
                            return ((row.delivery_count)  ? row.delivery_count :  "0")
                          }
                    },
                    { data: "gateway_delivery_count",
                         render: function(data, type, row, meta) {
                            return ((row.gateway_delivery_count)  ? row.gateway_delivery_count :  "0")
                          }
                    },
                    { data: "yulore_delivery_count",
                         render: function(data, type, row, meta) {
                            return ((row.yulore_delivery_count)  ? row.yulore_delivery_count :  "0")
                          }
                    },
                    { data: "volume_count",
                         render: function(data, type, row, meta) {
                            return ((row.volume_count)  ? row.volume_count :  "0")
                          }
                    },
                    {
                        "className":      '',
                        "defaultContent": '<i class="fa fa-plus-circle greenIcon" aria-hidden="true"></i>',
                        render: function(data, type, row, meta) {
                          var users =(row.total_user) ? row.total_user : "0";
                            var noofuser =users.split(",");
                            if(noofuser.length>0){
                                if(row.server_name == 'RCS' || row.server_name == 'RCS_J'){
                                    return '<span class="dt-control"><i class="fa fa-plus-circle greenIcon" data-campaign_type="RCS"  data-server-id="'+row.server_id+'" aria-hidden="true"></i></span>' ;
                                }
                                else{
                                    return '<span class="dt-control"><i class="fa fa-plus-circle greenIcon" data-campaign_type="non_RCS" data-server-id="'+row.server_id+'" aria-hidden="true"></i></span>' ;
                                }
                            }
                            else{
                                return "---";
                            }
                          }
                    },
                    {
                        "defaultContent": '<i class="fa fa-plus-circle greenIcon" aria-hidden="true"></i>',
                        render: function(data, type, row, meta) {
                            return '<span class="dt-accountbased"><i class="fa fa-plus-circle greenIcon" data-server-id="'+row.server_id+'" aria-hidden="true"></i></span> <span class="m-2"> <i title="Account Based Report" class="export_account_based_report fa fa-cloud-download text-primary" data-server-id="'+row.server_id+'" aria-hidden="true"> </i>  </span> ';
                          }
                    }
                ],
                order:[],
                fnRowCallback: function(nRow, aData, iDisplayIndex, iDisplayIndexFull) {
                    $('td:eq(0)', nRow).html(iDisplayIndexFull + 1);
                    return nRow;
                },               
                "footerCallback": function ( row, data, start, end, display ) {
                    var api = this.api(), data;

                    // Remove the formatting to get integer data for summation
                    var intVal = function ( i ) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '')*1 :
                            typeof i === 'number' ?
                                i : 0;
                    };

                    // Total  in footer
                    pageTotalVolumePushed = api.column(5).data().reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );

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

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

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

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

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

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

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

                    // Update footer total
                    $( api.column( 5 ).footer() ).html(pageTotalVolumePushed);
                    $( api.column( 6 ).footer() ).html(pageTotalVolumeSubmitted);
                    $( api.column( 7 ).footer() ).html(pageTotalGatewaySubmitted);
                    $( api.column( 8 ).footer() ).html(pageTotalYuloreSubmitted);
                    $( api.column( 9 ).footer() ).html(pageTotalDeliveryCount);
                    $( api.column( 10 ).footer() ).html(pageGatewayDeliveryCount);
                    $( api.column( 11 ).footer() ).html(pageYuloreDeliveryCount);
                    $( api.column( 12 ).footer() ).html(pageTotalSmsUnit);

                 }
                });
            }
        });
    }

        //child table
        $('body').on('click', '.dt-control', function() {
                var campaign_type = $(this).find('i').data('campaign_type');
                var start_date = $('#start_date').val();
                var end_date = $('#end_date').val();
                var table = $("#report-main-table").DataTable();
                var tr = $(this).closest('tr');
                var row = table.row(tr);
                var serverid = $(this).find('i').data('server-id');
                if (row.child.isShown()) {
                    // This row is already open - close it
                    row.child.hide();
                    tr.removeClass('shown');
                    $("i", this).toggleClass("fa fa-minus-circle redIcon fa fa-plus-circle greenIcon");
                } else {
                    // Open this row
                    row.child('<table class="table table-small-font table-bordered child-gateway-table" id="childtable-username-based-'+serverid+'"></table>').show();
                    tr.addClass('shown');
                    $("i", this).toggleClass("fa fa-plus-circle  fa fa-minus-circle redIcon");
                }
                if(!row.child.isShown()) return;

                if(campaign_type=="non_RCS"){
                    $.ajax({
                        type: 'POST',
                        async: true,
                        url: "{{url('getSubuserGatewayReport')}}"  ,
                        dataType: "json",
                        data: {
                            "_token": "{{ csrf_token() }}",
                            'serverid': serverid,
                            'start_date':start_date,
                            'end_date':end_date,
                            'campaign_type':campaign_type
                        },
                        cache: false,
                        success: function(detailsData) {
                        var   subuserdata =  detailsData['subuserdata'];
                            $('#childtable-username-based-'+serverid).DataTable({
                                data: subuserdata,
                                paging: false,
                                deferRender: true,
                                lengthChange: false,
                                bSort: false,
                                searching: false,
                                order: [],
                                columns: [
                                    {
                                        title: 'UserName',
                                        data:  "username",
                                        render: function(data, type, row, meta) {
                                            return ((row.username)  ? row.username :  "NA")
                                        }
                                    },
                                    {
                                        title: 'Volume Pushed',
                                        data: 'pushed_volume',
                                        render: function(data, type, row, meta) {
                                            return ((row.pushed_volume)  ? row.pushed_volume :  "0")
                                        }
                                    },
                                    {
                                        title: 'SMS Submitted',
                                        data: 'volume_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.volume_count)  ? row.volume_count :  "0")
                                        }
                                    },
                                    {
                                        title: 'Total SMS Unit',
                                        data: 'sms_unit',
                                        render: function(data, type, row, meta) {
                                            return ((row.sms_unit)  ? row.sms_unit :  "0")
                                        }
                                    },
                                    {
                                        title: 'Delivery Count',
                                        data: 'delivery_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.delivery_count)  ? row.delivery_count :  "0")
                                        }
                                    },
                                ]
                            });
                        }
                    });
                }
                else{
                    $.ajax({
                        type: 'POST',
                        async: true,
                        url: "{{url('getSubuserGatewayReport')}}"  ,
                        dataType: "json",
                        data: {
                            "_token": "{{ csrf_token() }}",
                            'serverid': serverid,
                            'start_date':start_date,
                            'end_date':end_date,
                            'campaign_type':campaign_type
                        },
                        cache: false,
                        success: function(detailsData) {
                         var   subuserdata =  detailsData['subuserdata'];
                            $('#childtable-username-based-'+serverid).DataTable({
                                data: subuserdata,
                                paging: false,
                                deferRender: true,
                                lengthChange: false,
                                bSort: false,
                                searching: false,
                                order: [],
                                columns: [
                                    {
                                        title: 'Bot Name',
                                        data:  "header_name",
                                        render: function(data, type, row, meta) {
                                            return ((row.header_name)  ? row.header_name :  "NA")
                                        }
                                    },
                                    {
                                        title: 'Volume Pushed',
                                        data: 'pushed_volume',
                                        render: function(data, type, row, meta) {
                                            return ((row.pushed_volume)  ? row.pushed_volume :  "0")
                                        }
                                    },
                                    {
                                        title: 'Volume Submitted',
                                        data: 'volume_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.volume_count)  ? row.volume_count :  "0")
                                        }
                                    },
                                    {
                                        title: 'Sent Count',
                                        data: 'sent_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.sent_count)  ? row.sent_count :  "0")
                                        }
                                    },
                                    {
                                        title: 'Delivery Count',
                                        data: 'delivery_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.delivery_count)  ? row.delivery_count :  "0")
                                        }
                                    },
                                    {
                                        title: 'Read Count',
                                        data: 'read_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.read_count)  ? row.read_count :  "0")
                                        }
                                    },
                                    {
                                        title: 'Failed Count',
                                        data: 'failed_count',
                                        render: function(data, type, row, meta) {
                                            return ((row.failed_count)  ? row.failed_count :  "0")
                                        }
                                    },
                                ]
                            });
                        }
                    });

                }
            });


//*Account based childtabe*/
  //child table
  $('body').on('click', '.dt-accountbased', function() {
                var start_date = $('#start_date').val();
                var end_date = $('#end_date').val();
                var date_filter = $('#date_filter').val();
                var table = $("#report-main-table").DataTable();
                var tr = $(this).closest('tr');
                var row = table.row(tr);
                var serverid = $(this).find('i').data('server-id');
                if (row.child.isShown()) {
                    // This row is already open - close it
                    row.child.hide();
                    tr.removeClass('shown');
                    $("i", this).toggleClass("fa fa-minus-circle redIcon fa fa-plus-circle greenIcon");
                } else {
                    // Open this row
                    row.child('<table class="table table-small-font table-bordered child-gateway-table" id="childtable-account-based-'+serverid+'"></table>').show();
                    tr.addClass('shown');
                    $("i", this).toggleClass("fa fa-plus-circle  fa fa-minus-circle redIcon");
                }
                if(!row.child.isShown()) return;
                $.ajax({
                    type: 'POST',
                    async: true,
                    url: "{{url('getAccountBasedGatewayReport')}}",
                    dataType: "json",
                    data: {
                        "_token": "{{ csrf_token() }}",
                        'serverid': serverid,
                        'start_date':start_date,
                        'end_date':end_date,
                        'date_filter':date_filter,
                    },
                    cache: false,
                    success: function(detailsData) {
                     var   subuserdata =  detailsData['accountbaseddata'];
                        $('#childtable-account-based-'+serverid).DataTable({
                            data: subuserdata,
                            paging: false,
                            deferRender: true,
                            lengthChange: false,
                            bSort: false,
                            searching: false,
                            order: [],
                            columns: [
                                {
                                    title: 'Date',
                                    data:  "date_report",
                                    render: function(data, type, row, meta) {
                                        return ((row.date_report)  ? row.date_report :  "NA")
                                    }
                                },
                                {
                                    title: 'Account Name',
                                    data:  "account_name",
                                    render: function(data, type, row, meta) {
                                        return ((row.account_name)  ? row.account_name :  "NA")
                                    }
                                },
                                {
                                    title: 'Volume Pushed',
                                    data: 'pushed_volume',
                                    render: function(data, type, row, meta) {
                                        return ((row.pushed_volume)  ? row.pushed_volume :  "0")
                                    }
                                },
                                {
                                    title: 'Total SMS Unit',
                                    data: 'sms_unit',
                                    render: function(data, type, row, meta) {
                                        return ((row.sms_unit)  ? row.sms_unit :  "0")
                                    }
                                },
                                { 
                                    title: 'Volume Submitted By Gateway',
                                    data: "gateway_submission",
                                    render: function(data, type, row, meta) {
                                        return ((row.gateway_submission)  ? row.gateway_submission :  "0")
                                    }
                                },
                                { 
                                    title: 'Volume Submitted By Yulore',
                                    data: "yulore_submission",
                                    render: function(data, type, row, meta) {
                                        return ((row.yulore_submission)  ? row.yulore_submission :  "0")
                                    }
                                },
                                {
                                    title: 'Total Delivery Count',
                                    data: 'delivery_count',
                                    render: function(data, type, row, meta) {
                                        return ((row.delivery_count)  ? row.delivery_count :  "0")
                                    }
                                },
                                { 
                                    title: 'Volume Delivered BY Gateway',
                                    data: "gateway_delivery_count",
                                    render: function(data, type, row, meta) {
                                        return ((row.gateway_delivery_count)  ? row.gateway_delivery_count :  "0")
                                    }
                                },
                                { 
                                    title: 'Volume Delivered BY Yulore',
                                    data: "yulore_delivery_count",
                                    render: function(data, type, row, meta) {
                                        return ((row.yulore_delivery_count)  ? row.yulore_delivery_count :  "0")
                                    }
                                },
                                {
                                    title: 'Total Volume Submitted',
                                    data: 'volume_count',
                                    render: function(data, type, row, meta) {
                                        return ((row.volume_count)  ? row.volume_count :  "0")
                                    }
                                },
                            ]
                        });
                    }
                });
            });
</script>
@endsection