@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 end_date"  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 end_date">
                        </div>
                    </div>
                </div>
                <div class="form-group">
                    <label class="control-label small_label" for="field-1">End Date</label>
                    <div class="row">
                        <div class="col-sm-6">
                            <input type="text" name="EndDate" class="form-control datepicker end_date"  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 end_date">
                        </div>
                    </div>
                </div>
                <div class="form-group">
                    <label for="field-1" class="control-label" style="width: 6%;">Currency</label>
                    {{Form::select('CurrencyID',Currency::getCurrencyDropdownIDList(),(Input::get('CurrencyID')>0?Input::get('CurrencyID'):$DefaultCurrencyID),array("class"=>"select2"))}}
                </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_CompanyGatewayID1")) }}
                </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="zerovaluebuyingcost" class="control-label" >Show</label>
                                        {{ Form::select('zerovaluebuyingcost',$options,'', array("class"=>"select2 small","id"=>"bulk_AccountID",'allowClear'=>'true')) }}
                </div>
                <div class="form-group">
                    <br/>
                    <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>Vendor SMS</strong> </li>
    </ol>
    <h3>Vendor SMS</h3>

    @if(User::checkCategoryPermission('SMS','Delete') )
        <button id="delete-vendor-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-vendor-sms-form" >
        <input type="hidden" name="VendorSMSIDs" />
        <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> -->
    <ul class="nav nav-tabs bordered">
        <!-- available classes "bordered", "right-aligned" -->
        <li > <a href="{{ URL::to('sms_show') }}" > <span class="hidden-xs">Customer SMS</span> </a> </li>
        <li class="active"> <a href="{{ URL::to('/vendorsms_show') }}" > <span class="hidden-xs">Vendor SMS</span> </a> </li>
    </ul>
    <style>
        /*.end_date{width:80.6667%;}*/
        .small_label{width:5.0%;}
    </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>-->
    <div class="tab-content">
        <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="5%" >
                                <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 $searchFilter = {};
        var update_new_url;
        var postdata;
        var checked='';
        var TotalCall = 0;
        var TotalDuration = 0;
        var TotalCost = 0;
        var CurrencyCode = '';

        jQuery(document).ready(function ($) {

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

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

            $('#bluk_CompanyGatewayID1').change(function(e){
                if($(this).val()){
                    $('#sms_rerate').removeClass('hidden');
                }else{
                    $('#sms_rerate').addClass('hidden');
                }
            });
            $('#bluk_CompanyGatewayID1').trigger('change');

            $('#bluk_CompanyGatewayID').change(function(e){
                if($(this).val()){
                    $.ajax({
                        url:  baseurl +'/cdr_upload/get_accounts/'+$(this).val(),  //Server script to process data
                        type: 'POST',
                        success: function (response) {
                            $('#bulk_AccountID').empty();
                            $('#bulk_AccountID').append(response);
                            setTimeout(function(){
                                $("#bulk_AccountID").select2('val','');
                            },200)
                        },
                        //Options to tell jQuery not to process data or worry about content-type.
                        cache: false
                    });

                }
            });
            $('#bluk_CompanyGatewayID').trigger('change');
            // Replace Checboxes
            $(".pagination a").click(function (ev) {
                replaceCheckboxes();
            });

            $("#sms_filter").submit(function(e) {
                e.preventDefault();
                var list_fields  =['VendorCDRID','AccountName','connect_time','disconnect_time','duration','cost','cli','cld','AccountID','CompanyGatewayID','start_date','end_date'];
                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.zerovaluesellingcost 		= 		$("#sms_filter [name='zerovaluesellingcost']").prop("checked");
                $searchFilter.zerovaluebuyingcost 		= 		$("#sms_filter [name='zerovaluebuyingcost']").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_vendorsms/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":"zerovaluebuyingcost","value":$searchFilter.zerovaluebuyingcost},
                                {"name":"CurrencyID","value":$searchFilter.CurrencyID}
                        );
                        data_table_extra_params.length = 0;
                        data_table_extra_params.push(
                                {"name":"Export","value":1},
                                {"name":"StartDate","value":$searchFilter.StartDate},
                                {"name":"EndDate","value":$searchFilter.EndDate},
                                {"name":"CompanyGatewayID","value":$searchFilter.CompanyGatewayID},
                                {"name":"AccountID","value":$searchFilter.AccountID},
                                {"name":"zerovaluebuyingcost","value":$searchFilter.zerovaluebuyingcost},
                                {"name":"CurrencyID","value":$searchFilter.CurrencyID}
                        );
                    },
                    "sPaginationType": "bootstrap",
                    "aaSorting"   : [[0, 'asc']],
                    "oTableTools":
                    {
                        "aButtons": [
                            {
                                "sExtends": "download",
                                "sButtonText": "EXCEL",
                                "sUrl": baseurl + "/sms_upload/ajax_datagrid_vendorsms/xlsx",
                                sButtonClass: "save-collection btn-sm"
                            },
                            {
                                "sExtends": "download",
                                "sButtonText": "CSV",
                                "sUrl": baseurl + "/sms_upload/ajax_datagrid_vendorsms/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 },//Account Name
                                { "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 } //Message ID
                            ],
                    "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 < 8; 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 + "/cdr_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 + "/cdr_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_vendorcdr",$.param($searchFilter)+'&'+$(this).serialize())
            });

            $("#delete-vendor-sms").click(function(e) {
                e.preventDefault();
                var criteria='';
                if($('#selectallbutton').is(':checked')){
                    criteria = JSON.stringify($searchFilter);
                }
                var VendorSMSIDs = [];
                var i = 0;
                $('#table-4 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    VendorSMSID = $(this).val();
                    if(typeof VendorSMSID != 'undefined' && VendorSMSID != null && VendorSMSID != 'null'){
                        VendorSMSIDs[i++] = VendorSMSID;
                    }
                });

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

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

                    var formData = new FormData($('#delete-vendor-sms-form')[0]);
                    $(this).button('loading');

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

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



            });




        });

    </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">SMS 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',VendorCDR::$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