@extends('layout.main')

@section('filter')
    <div id="datatable-filter" class="fixed new_filter" data-current-user="Art Ramadani" data-order-by-status="1" data-max-chat-history="25">
        <div class="filter-inner">
            <h2 class="filter-header">
                <a href="#" class="filter-close" data-animate="1"><i class="entypo-cancel"></i></a>
                <i class="fa fa-filter"></i>
                Filter
            </h2>
            <form novalidate class="form-horizontal form-groups-bordered validate" method="post" id="sms_filter">
                <div class="form-group">
                    <label class="control-label small_label" for="field-1">Start Date</label>
                    <div class="row">
                        <div class="col-sm-6">
                            <input type="text" name="StartDate" class="form-control datepicker"  data-date-format="yyyy-mm-dd" value="{{Input::get('StartDate')!=null?substr(Input::get('StartDate'),0,10):date('Y-m-d') }}" data-enddate="{{date('Y-m-d')}}" />
                        </div>
                        <div class="col-sm-6">
                            <input type="text" name="StartTime" data-minute-step="5" data-show-meridian="false" data-default-time="00:00:00" value="{{Input::get('StartDate')!=null && strlen(Input::get('StartDate'))> 10 && substr(Input::get('StartDate'),11,8) != '00:00:00' ?substr(Input::get('StartDate'),11,8):'00:00:00'}}" data-show-seconds="true" data-template="dropdown" class="form-control timepicker">
                        </div>
                    </div>
                </div>
                <div class="form-group">
                    <label class="col-md-1 control-label small_label" for="field-1" style="padding-left: 0px;">End Date</label>
                    <div class="row">
                        <div class="col-sm-6">
                            <input type="text" name="EndDate" class="form-control datepicker"  data-date-format="yyyy-mm-dd" value="{{Input::get('EndDate')!=null?substr(Input::get('EndDate'),0,10):date('Y-m-d') }}" data-enddate="{{date('Y-m-d')}}" />
                        </div>
                        <div class="col-sm-6">
                            <input type="text" name="EndTime" data-minute-step="5" data-show-meridian="false" data-default-time="23:59:59" value="{{Input::get('EndDate')!=null && strlen(Input::get('EndDate'))> 10?substr(Input::get('EndDate'),11,2).':59:59':'23:59:59'}}" data-show-seconds="true" data-template="dropdown" class="form-control timepicker">
                        </div>
                    </div>
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label">Currency</label>
                    {{Form::select('CurrencyID',Currency::getCurrencyDropdownIDList(),(Input::get('CurrencyID')>0?Input::get('CurrencyID'):$DefaultCurrencyID),array("class"=>"select2 small"))}}
                </div>
                <div class="form-group">
                    <label class="control-label" for="field-1">Gateway</label>
                    {{ Form::select('CompanyGatewayID',$gateway,Input::get('CompanyGatewayID'), array("class"=>"select2","id"=>"bluk_CompanyGatewayID")) }}
                </div>
                <div class="form-group">
                    <label class="control-label" for="field-1">Account</label>
                    {{ Form::select('AccountID',$accounts,Input::get('AccountID'), array("class"=>"select2","id"=>"bulk_AccountID",'allowClear'=>'true')) }}
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label">Show</label>
                                        {{ Form::select('zerovaluecost',$options,'', array("class"=>"select2 small","id"=>"bulk_zerovaluecost",'allowClear'=>'true')) }}
                </div>

                <!--
                <div class="form-group">
                    <label class="control-label" for="field-1">Reseller</label>
                    {{ Form::select('ResellerOwner',$reseller_owners,Input::get('ResellerOwner'), array("class"=>"select2","id"=>"bluk_ResellerOwner")) }}
                        </div>-->
                <div class="form-group">
                    <br/>
                    <input type="hidden" name="ResellerOwner" value="0">
                    <button type="submit" class="btn btn-primary btn-md btn-icon icon-left">
                        <i class="entypo-search"></i>
                        Search
                    </button>
                </div>
            </form>
        </div>
    </div>
@stop


@section('content')
<style>
    td {
        max-width: 150px;
        word-wrap:break-word;
    }

</style>
    <ol class="breadcrumb bc-3">
        <li>
            <a href="{{URL::to('dashboard')}}"><i class="entypo-home"></i>Home</a>
        </li>
        <li>
            <a>SMS</a>
        </li>
        <li class="active">
            <strong>Customer SMS</strong>
        </li>
    </ol>
    <h3>Customer SMS</h3>

    @if(User::checkCategoryPermission('SMS','Delete') )
        <button id="delete-customer-sms" class="btn btn-danger btn-sm btn-icon icon-left pull-right mar-left-2" data-loading-text="Loading..."> <i class="entypo-trash"></i> Delete</button>
    @endif
    <form id="delete-customer-sms-form" >
        <input type="hidden" name="CustomerSMSIDs" />
        <input type="hidden" name="criteria" />
    </form>

    @include('includes.errors')
    @include('includes.success')
<!--
    <a href="javascript:void(0)" id="sms_rerate" class="btn btn-primary btn-sm btn-icon icon-left pull-right hidden">
        <i class="entypo-check"></i>
        <span>SMS Rerate</span>
    </a>
    -->
    <style>
        .small_fld{width:80.6667%;}
        .small_label{width:5.0%;}

        .col-md-e1{ padding-left:8px;padding-right:8px;}
        .col-md-e12{padding-left:5px;padding-right:5px; width:11%;}
    </style>
    <!--
    <div class="row">
    <div  class="col-md-12">
        <div class="input-group-btn pull-right" style="width:70px;">
            <button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">Action <span class="caret"></span></button>
            <ul class="dropdown-menu dropdown-menu-left" role="menu" style="background-color: #000; border-color: #000; margin-top:0px;">
                <li><a class="generate_rate create" id="bulk_clear_cdr" href="javascript:;" style="width:100%">
                        Bulk clear
                    </a>
                </li>
            </ul>

        </div><!-- /btn-group -->
    <!--</div>
    <div class="clear"></div>
    </div>-->
    <ul class="nav nav-tabs bordered"><!-- available classes "bordered", "right-aligned" -->
        <li class="active">
            <a href="{{ URL::to('sms_show') }}" >
                <span class="hidden-xs">Customer SMS</span>
            </a>
        </li>
        <li>
            <a href="{{ URL::to('/vendorsms_show') }}" >
                <span class="hidden-xs">Vendor SMS</span>
            </a>
        </li>
    </ul>
    <div class="tab-content" style="padding:0;">
        <div class="tab-pane active">
            <div class="row">
                <div class="col-md-12">
                    <table class="table table-bordered datatable" id="table-4">
                        <thead>
                        <tr>
                            <th width="3%" >
                                <div class="checkbox ">
                                    <input type="checkbox" id="selectall" name="checkbox[]" />
                                </div>
                            </th>
                            <th width="10%" >Account Name</th>
                            <th width="10%" >EDR Date</th>
                            <th width="5%" >Dnis</th>
                            <th width="5%" >Cost</th>
                            <th width="5%" >Network</th>
                            <th width="5%" >Country</th>
                            <th width="25%" >Message</th>
                            <th width="5%" >MCMNC</th>
                            <th width="5%" >EDR Status</th>
                            <th width="10%" >Service</th>
                            <th width="10%" >Message ID</th>
                        </tr>
                        </thead>
                        <tbody>
                        </tbody>
                        <tfoot>
                        <tr>
                        </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>


    <script type="text/javascript">
        var currency_symbol = '';
        var $searchFilter = {};
        var update_new_url;
        var postdata;
        var checked='';
        var TotalCall = 0;
        var TotalDuration = 0;
        var TotalCost = 0;
        var CurrencyCode = '';
        var rate_cdr = jQuery.parseJSON('{{json_encode($rate_cdr)}}');
        jQuery(document).ready(function ($) {

            $('#filter-button-toggle').show();

            $('input[name="StartTime"]').click();
            public_vars.$body = $("body");

            $('#bluk_CompanyGatewayID').change(function(e){
                if($(this).val()){
                    $('#sms_rerate').removeClass('hidden');
                }else{
                    $('#sms_rerate').addClass('hidden');
                }
            });
            $('#bluk_CompanyGatewayID').trigger('change');
            // Replace Checboxes
            $(".pagination a").click(function (ev) {
                replaceCheckboxes();
            });

            $("#sms_filter").submit(function(e) {
                e.preventDefault();
                $('.result_tr_end').remove();
                var list_fields  =['CustomerSMSID','AccountName','edr_date','dnis','network','country','message','mccmnc','edr_status','cost','Service','MessageID'];

                var starttime = $("#sms_filter [name='StartTime']").val();
                if(starttime =='00:00:01'){
                    starttime = '00:00:00';
                }

                $searchFilter.StartDate 			= 		$("#sms_filter [name='StartDate']").val();
                $searchFilter.EndDate 				= 		$("#sms_filter [name='EndDate']").val();
                $searchFilter.CompanyGatewayID 		= 		$("#sms_filter [name='CompanyGatewayID']").val();
                $searchFilter.AccountID 			= 		$("#sms_filter [name='AccountID']").val();
                $searchFilter.ResellerOwner 		= 		$("#sms_filter [name='ResellerOwner']").val();
                $searchFilter.zerovaluecost 		= 		$("#sms_filter [name='zerovaluecost']").val();
                $searchFilter.CurrencyID 			= 		$("#sms_filter [name='CurrencyID']").val();

                if(typeof $searchFilter.StartDate  == 'undefined' || $searchFilter.StartDate.trim() == ''){
                    toastr.error("Please Select a Start date", "Error", toastr_opts);
                    return false;
                }
                if(typeof $searchFilter.EndDate  == 'undefined' || $searchFilter.EndDate.trim() == ''){
                    toastr.error("Please Select a End date", "Error", toastr_opts);
                    return false;
                }
                $searchFilter.StartDate += ' '+starttime;
                $searchFilter.EndDate += ' '+$("#sms_filter [name='EndTime']").val();
                data_table = $("#table-4").DataTable({
                    "scrollX": true,
                    "initComplete": function(settings, json) { // to hide extra row which is displaying due to scrollX
                        $('.dataTables_scrollBody thead tr').css({visibility:'collapse'});
                    },
                    "bProcessing":true,
                    "bDestroy": true,
                    "bServerSide":true,
                    "sAjaxSource": baseurl + "/sms_upload/ajax_datagrid/type",
                    "sDom": "<'row'<'col-xs-6 col-left '<'#selectcheckbox.col-xs-1'>'l><'col-xs-6 col-right'<'export-data'T>f>r>t<'row'<'col-xs-6 col-left'i><'col-xs-6 col-right'p>>",
                    "iDisplayLength": parseInt('{{CompanyConfiguration::get('PAGE_SIZE')}}'),
                    "fnServerParams": function(aoData) {
                        aoData.push(
                                {"name":"StartDate","value":$searchFilter.StartDate},
                                {"name":"EndDate","value":$searchFilter.EndDate},
                                {"name":"CompanyGatewayID","value":$searchFilter.CompanyGatewayID},
                                {"name":"AccountID","value":$searchFilter.AccountID},
                                {"name":"ResellerOwner","value":$searchFilter.ResellerOwner},
                                {"name":"zerovaluecost","value":$searchFilter.zerovaluecost},
                                {"name":"CurrencyID","value":$searchFilter.CurrencyID}

                        );
                        data_table_extra_params.length = 0;
                        data_table_extra_params.push(
                                {"name":"StartDate","value":$searchFilter.StartDate},
                                {"name":"EndDate","value":$searchFilter.EndDate},
                                {"name":"CompanyGatewayID","value":$searchFilter.CompanyGatewayID},
                                {"name":"AccountID","value":$searchFilter.AccountID},
                                {"name":"ResellerOwner","value":$searchFilter.ResellerOwner},
                                {"name":"Export","value":1},
                                {"name":"zerovaluecost","value":$searchFilter.zerovaluecost},
                                {"name":"CurrencyID","value":$searchFilter.CurrencyID}

                        );
                    },
                    "sPaginationType": "bootstrap",
                    "aaSorting"   : [[0, 'asc']],
                    "oTableTools":
                    {
                        "aButtons": [
                            {
                                "sExtends": "download",
                                "sButtonText": "EXCEL",
                                "sUrl": baseurl + "/sms_upload/ajax_datagrid/xlsx",
                                sButtonClass: "save-collection btn-sm"
                            },
                            {
                                "sExtends": "download",
                                "sButtonText": "CSV",
                                "sUrl": baseurl + "/sms_upload/ajax_datagrid/csv",
                                sButtonClass: "save-collection btn-sm"
                            }
                        ]
                    },
                    "aoColumns":
                            [
                                {"bSortable": false,
                                    mRender: function(id, type, full) {
                                        return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                    }
                                }, //0Checkbox
                                { "bSortable": false },//AccountName
                                { "bSortable": false },//EDR Date
                                { "bSortable": false },//Dnis
                                { "bSortable": false },//Network
                                { "bSortable": false },//Country
                                { "bSortable": false },//Message
                                { "bSortable": false },//MCMNC
                                { "bSortable": false },//EDR Status
                                { "bSortable": false }, //Cost
                                { "bSortable": false }, //Service
                                { "bSortable": false } //MessageID
                            ],
                    "fnDrawCallback": function() {
                        $(".dataTables_wrapper select").select2({
                            minimumResultsForSearch: -1
                        });

                        $("#selectall").click(function(ev) {
                            var is_checked = $(this).is(':checked');
                            $('#table-4 tbody tr').each(function(i, el) {
                                if (is_checked) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                    $(this).addClass('selected');
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                    $(this).removeClass('selected');
                                }
                            });
                        });

                        //select all button
                        $('#table-4 tbody tr').each(function(i, el) {
                            if($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                if (checked != '') {
                                    $(this).find('.rowcheckbox').prop("checked", true).prop('disabled', true);
                                    $(this).addClass('selected');
                                    $('#selectallbutton').prop("checked", true);
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                }
                            }
                        });

                        $('#selectallbutton').click(function(ev) {
                            if($(this).is(':checked')){
                                checked = 'checked=checked disabled';
                                $("#selectall").prop("checked", true).prop('disabled', true);
                                if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                    $('#table-4 tbody tr').each(function(i, el) {
                                        if($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                            $(this).find('.rowcheckbox').prop("checked", true).prop('disabled', true);
                                            $(this).addClass('selected');
                                        }
                                    });
                                }
                            }else{
                                checked = '';
                                $("#selectall").prop("checked", false).prop('disabled', false);
                                if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                    $('#table-4 tbody tr').each(function(i, el) {
                                        if($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                            $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                            $(this).removeClass('selected');
                                        }
                                    });
                                }
                            }
                        });
                    },
                    "fnServerData": function ( sSource, aoData, fnCallback ) {
                        /* Add some extra data to the sender */
                        $.getJSON( sSource, aoData, function (json) {
                            /* Do whatever additional processing you want on the callback, then tell DataTables */
                            TotalCall = json.Total.totalcount;
                            TotalCost = json.Total.total_cost;
                            CurrencyCode = json.Total.CurrencyCode != null? json.Total.CurrencyCode : '';
                            fnCallback(json)
                        });
                    },
                    "fnFooterCallback": function ( row, data, start, end, display ) {
                        if (end > 0) {
                            $(row).html('');
                            for (var i = 0; i < $('#table-4 thead th').length; i++) {
                                var a = document.createElement('td');
                                $(a).html('');
                                $(row).append(a);
                            }
                            $($(row).children().get(0)).html('<strong>Total</strong>')
                            $($(row).children().get(3)).html('<strong>'+TotalCall+' Calls</strong>');
                            $($(row).children().get(4)).html('<strong>' + CurrencyCode + TotalCost + '</strong>');
                        }else{
                            $("#table-4").find('tfoot').find('tr').html('');
                        }
                    }
                });
                $("#selectcheckbox").append('<input type="checkbox" id="selectallbutton" name="checkboxselect[]" class="" title="Select All Found Records" />');
            });

            $('#table-4 tbody').on('click', 'tr', function() {
                if (checked =='') {
                    $(this).toggleClass('selected');
                    if ($(this).hasClass('selected')) {
                        $(this).find('.rowcheckbox').prop("checked", true);
                    } else {
                        $(this).find('.rowcheckbox').prop("checked", false);
                    }
                }
            });
            /*
            $('table tbody').on('click', '.delete_cdr', function (e) {
                response = confirm('Are you sure?');
                if (response) {
                    submit_ajax(baseurl + "/sms_upload/delete_cdr",$(this).prev("div.hiddenRowData").find("input").serialize())
                }
            });
            $('#bulk_clear_cdr').on('click',function (e) {
                if(typeof $searchFilter.StartDate  == 'undefined' || $searchFilter.StartDate.trim() == ''){
                    toastr.error("Please Select a Start date then search", "Error", toastr_opts);
                    return false;
                }
                if(typeof $searchFilter.EndDate  == 'undefined' || $searchFilter.EndDate.trim() == ''){
                    toastr.error("Please Select a End date then search", "Error", toastr_opts);
                    return false;
                }
                response = confirm('Are you sure?');
                if (response) {
                    submit_ajax(baseurl + "/sms_upload/delete_cdr",$.param($searchFilter))
                }
            }); */
            $('#sms_rerate').on('click',function (e) {
                if(typeof $searchFilter.StartDate  == 'undefined' || $searchFilter.StartDate.trim() == ''){
                    toastr.error("Please Select a Start date then search", "Error", toastr_opts);
                    return false;
                }
                if(typeof $searchFilter.EndDate  == 'undefined' || $searchFilter.EndDate.trim() == ''){
                    toastr.error("Please Select a End date then search", "Error", toastr_opts);
                    return false;
                }
                if(typeof $searchFilter.CompanyGatewayID  == 'undefined' || $searchFilter.CompanyGatewayID.trim() == ''){
                    toastr.error("Please Select a Gateway then search", "Error", toastr_opts);
                    return false;
                }
                if($("#table-4 tbody tr").html().indexOf("No data available in table") > 0){
                    toastr.error("No data available To ReRate", "Error", toastr_opts);
                    return false;
                }
                $("#cdr-rerate-user").modal('show', {backdrop: 'static'});
                /*response = confirm('Are you sure?');
                 if (response) {
                 submit_ajax(baseurl + "/rate_cdr",$.param($searchFilter))
                 }*/
            });
            $('#cdr-rerate-form [name="RateMethod"]').change(function (e) {
                e.preventDefault();
                $('#cdr-rerate-form [name="SpecifyRate"]').parents('.row').addClass('hidden');
                if ($(this).val() != 'CurrentRate' ) {
                    $('#cdr-rerate-form [name="SpecifyRate"]').parents('.row').removeClass('hidden');
                }
            });
            $("#cdr-rerate-form").submit(function (e) {
                e.preventDefault();
                submit_ajax(baseurl + "/rate_cdr",$.param($searchFilter)+'&'+$(this).serialize())
            });
            $("#delete-customer-sms").click(function(e) {
                e.preventDefault();
                var criteria='';
                if($('#selectallbutton').is(':checked')){
                    criteria = JSON.stringify($searchFilter);
                }
                var CustomerSMSIDs = [];
                var i = 0;
                $('#table-4 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    CustomerSMSID = $(this).val();
                    if(typeof CustomerSMSID != 'undefined' && CustomerSMSID != null && CustomerSMSID != 'null'){
                        CustomerSMSIDs[i++] = CustomerSMSID;
                    }
                });

                if(CustomerSMSIDs.length){
                    if (!confirm('Are you sure you want to delete sms?')) {
                        return;
                    }

                    $("#delete-customer-sms-form").find("input[name='CustomerSMSIDs']").val(CustomerSMSIDs.join(","));
                    $("#delete-customer-sms-form").find("input[name='criteria']").val(criteria);


                    var formData = new FormData($('#delete-customer-sms-form')[0]);
                    $(this).button('loading');
                    $.ajax({
                        url: baseurl + '/sms_upload/delete_customer_sms',
                        type: 'POST',
                        error: function () {
                            $('#delete-customer-sms').button('reset');
                            toastr.error("error", "Error", toastr_opts);
                        },
                        dataType: 'json',
                        success: function (response) {
                            if (response.status == 'success') {
                                $('#delete-customer-sms').button('reset');
                                toastr.success(response.message, "Success", toastr_opts);
                                data_table.fnFilter('', 0);
                            } else {
                                $('#delete-customer-sms').button('reset');
                                toastr.error(response.message, "Error", toastr_opts);
                            }
                        },
                        data: formData,
                        cache: false,
                        contentType: false,
                        processData: false
                    });

                }else{
                    alert("Please select cdr.");
                    return false;
                }



            });


            if (isxs()|| is('tabletscreen')) {
                $('#cdrfilter').find('.col-md-1,.col-md-2').each(function () {
                    $(this).removeAttr('style');
                    $(this).removeClass("small_label");
                });
                $('#cdrfilter').find('.small_fld').each(function () {
                    $(this).removeClass("small_fld");
                });
            }


        });

    </script>
    <style>
        .dataTables_filter label{
            /*display:none !important;*/
        }
        .dataTables_wrapper .export-data{
            right: 30px !important;
        }
        #selectcheckbox{
            padding: 15px 10px;
        }
    </style>
@stop
@section('footer_ext')
    @parent
    <div class="modal fade in" id="cdr-rerate-user">
        <div class="modal-dialog">
            <div class="modal-content">
                <form id="cdr-rerate-form" method="post">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        <h4 class="modal-title">CDR Rerate</h4>
                    </div>
                    <div class="modal-body">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="form-group">
                                    <label for="field-5" class="control-label">Rerate Method</label>
                                    {{ Form::select('RateMethod',UsageDetail::$RateMethod , '', array("class"=>"select2","data-allow-clear"=>"true","data-placeholder"=>"Select Status")) }}
                                </div>
                            </div>
                        </div>
                        <div class="row hidden">
                            <div class="col-md-12">
                                <div class="form-group">
                                    <label for="field-5" class="control-label">Rerate Method Value</label>
                                    <input type="text" name="SpecifyRate" class="form-control" value=""/>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="submit" class="btn btn-primary btn-sm btn-icon icon-left" data-loading-text="Loading..." id="rerate-customer-cdr">
                            <i class="entypo-floppy"></i>
                            Rerate
                        </button>
                        <button type="button" class="btn btn-danger btn-sm btn-icon icon-left" data-dismiss="modal">
                            <i class="entypo-cancel"></i>
                            Close
                        </button>
                    </div>
                </form>
            </div>
        </div>
    </div>
@stop