@extends('layout.main')

@section('content')

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

@include('includes.errors')
@include('includes.success')
<ul class="nav nav-tabs bordered"><!-- available classes "bordered", "right-aligned" -->
    <li >
        <a href="{{ URL::to('/cdr_upload') }}" >
            <span class="hidden-xs">Customer CDR Upload</span>
        </a>
    </li>
    <li class="active">
        <a href="{{ URL::to('/vendorcdr_upload') }}" >
            <span class="hidden-xs">Vendor CDR Upload</span>
        </a>
    </li>
</ul>
<div class="tab-content">
    <div class="tab-pane active">
<div class="row">
    <div class="col-md-12">
        <form novalidate class="form-horizontal form-groups-bordered validate" method="post" id="bulk_upload" enctype="multipart/form-data">
            <div data-collapsed="0" class="panel panel-primary">
                <div class="panel-heading">
                    <div class="panel-title">
                        Bulk Vendor CDR Upload
                    </div>
                </div>
                <div class="panel-body">
                    <div class="form-group">
                        <label class="col-sm -2 control-label" for="field-1">Upload Template</label>
                        <div class="col-sm-3">
                            {{ Form::select('FileUploadTemplateID', $UploadTemplate, '' , array("class"=>"select2 small")) }}
                        </div>
                    </div>
                    <div class="form-group">
                        <label class="col-sm-2 control-label" for="field-1">Gateway</label>
                        <div class="col-sm-3">
                            {{ Form::select('CompanyGatewayID',$gateway,'', array("class"=>"select2")) }}
                        </div>
                    </div>
                    {{--<div id="trunk_dropdown" class="form-group hidden">
                        <label class="col-sm-2 control-label" for="field-1">Trunk</label>
                        <div class="col-sm-3">
                            {{ Form::select('TrunkID',$trunks,'', array("class"=>"select2")) }}
                        </div>
                    </div>--}}
                    <div class="form-group">
                        <label for="field-1" class="col-sm-2 control-label">Upload (.xls, .xlxs, .csv)</label>
                        <div class="col-sm-4">
                            <input name="excel" type="file" class="form-control file2 inline btn btn-primary" data-label="
                            <i class='glyphicon glyphicon-circle-arrow-up'></i>&nbsp;   Browse" />

                        </div>
                    </div>
                     <div class="form-group">
                        <label class="col-sm-2 control-label">Settings</label>

                        <div class="col-sm-10">
                            <div class="checkbox ">
                                <label>
                                <input type="hidden" name="RateCDR" value="0" >
                                <input type="checkbox" id="RateCDR" name="RateCDR" value="1" > Rate CDR</label>
                            </div>
                        </div>
                    </div>
                    <div class="form-group">
                        <label for="field-1" class="col-sm-2 control-label">Note</label>
                        <div class="col-sm-8">
                            <p><i class="glyphicon glyphicon-minus"></i><strong>Allowed Extension</strong> .xls, .xlxs, .csv</p>
                            {{--<p>Please upload the file in given <span class="label label-info" onclick="jQuery('#modal-fileformat-detail').modal('show');" style="cursor: pointer">Detail File Format</span> </p>
                            <p>Sample File <a href="{{URL::to('cdr_upload/download_sample_excel_file',array('type'=>'detail'))}}" class="btn btn-success btn-sm btn-icon icon-left"><i class="entypo-down"></i>Detail File Download</a> </p>--}}
                        </div>
                    </div>
                    <p style="text-align: right;">

                        @if(User::checkCategoryPermission('CDR','Upload'))
                        <button id="upload" class="btn btn-primary btn-sm btn-icon icon-left" type="submit">
                            <i class="glyphicon glyphicon-circle-arrow-up"></i>
                            Upload
                        </button>
                        @endif
                    </p>
                </div>
            </div>
        </form>
    </div>
</div>

<div class="row hidden" id="add-template">
    <div class="col-md-12">
        <form id="add-template-form" method="post">
                <div class="panel panel-primary" data-collapsed="0">
                    <div class="panel-heading">
                        <div class="panel-title">
                            Add New Template
                        </div>
                    </div>
                    <div class="panel-body">
                        <div class="form-group">
                            <label for="field-1" class="col-sm-2 control-label">Template Name:</label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="TemplateName" value="" />
                            </div>
                        </div>
                        <br />
                        <br />
                    </div>
                    <div class="panel-heading">
                        <div class="panel-title">
                            Call Rate Rules CSV Importer
                        </div>
                    </div>
                    <div class="panel-body">
                        <div class="form-group">
                            <label for="field-1" class="col-sm-2 control-label">Delimiter:</label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="option[Delimiter]" value="," />
                                <input type="hidden" name="TemplateFile" value="" />
                                <input type="hidden" name="OriginalFile" value="" />
                            </div>
                            <label for="field-1" class="col-sm-2 control-label">Enclosure:</label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="option[Enclosure]" value="" />
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label class="col-sm-2 control-label">Escape:</label>
                            <div class="col-sm-4">
                                <input type="text" class="form-control" name="option[Escape]" value="" />
                            </div>
                            <label for="field-1" class="col-sm-2 control-label">First row:</label>
                            <div class="col-sm-4">
                                {{Form::select('option[Firstrow]', array('columnname'=>'Column Name','data'=>'Data'),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <p style="text-align: right;">
                            <br />
                            <br />
                            <button id="check_vendorupload" class="check btn btn-primary btn-sm btn-icon icon-left" data-loading-text="Loading...">
                                <i class="entypo-floppy"></i>
                                Check
                            </button>
                        </p>
                    </div>
                </div>
                <div class="panel panel-primary" data-collapsed="0">
                    <div class="panel-heading">
                        <div class="panel-title">
                            Field Remapping
                        </div>

                        <div class="panel-options">
                            <a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
                        </div>
                    </div>

                    <div class="panel-body" id="mapping">
                        <div class="form-group">
                            <label for="field-1" class="col-sm-2 control-label">Connect DateTime</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[connect_datetime]', array(),'',array("class"=>"select2 small"))}}
                            </div>

                            <label for="field-1" class="col-sm-2 control-label">Disconnect DateTime</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[disconnect_time]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for="field-1" class="col-sm-2 control-label">Connect Date</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[connect_date]', array(),'',array("class"=>"select2 small"))}}
                            </div>

                            <label for="field-1" class="col-sm-2 control-label">Connect Time</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[connect_time]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for="field-1" class="col-sm-2 control-label">Billed Duration</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[billed_duration]', array(),'',array("class"=>"select2 small"))}}
                            </div>

                            <label for="field-1" class="col-sm-2 control-label">Duration</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[duration]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for=" field-1" class="col-sm-2 control-label">CLI</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[cli]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                            <label for="field-1" class="col-sm-2 control-label">CLD</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[cld]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for="field-1" class="col-sm-2 control-label">Account</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[Account]', array(),'',array("class"=>"select2 small"))}}
                            </div>

                            <label for=" field-1" class="col-sm-2 control-label">Selling Cost</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[sellcost]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for=" field-1" class="col-sm-2 control-label">Date Format</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[DateFormat]',Company::$date_format ,'',array("class"=>"select2 small"))}}
                            </div>
                            <label for=" field-1" class="col-sm-2 control-label">Buying Cost</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[buycost]',array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label class="col-sm-2 control-label">ID</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[ID]', array(),'',array("class"=>"select2 small"))}}
                            </div>

                            <label class="col-sm-2 control-label">Remote IP</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[remote_ip]', array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for=" field-1" class="col-sm-2 control-label">Area Prefix</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[area_prefix]',array(),'',array("class"=>"select2 small"))}}
                            </div>
                            <label class="col-sm-2 control-label">Trunk</label>
                            <div class="col-sm-4">
                                {{ Form::select('selection[TrunkID]',$trunks,'', array("class"=>"select2")) }}
                            </div>
                        </div>
                        <div class="form-group">
                            <br />
                            <br />
                            <label for=" field-1" class="col-sm-2 control-label">Callee IP</label>
                            <div class="col-sm-4">
                                {{Form::select('selection[calleeip]',array(),'',array("class"=>"select2 small"))}}
                            </div>
                        </div>
                    </div>
                </div>
                <div class="panel panel-primary" data-collapsed="0">
                    <div class="panel-heading">
                        <div class="panel-title">
                            CSV File to be loaded
                        </div>

                        <div class="panel-options">
                            <a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
                        </div>
                    </div>

                    <div class="panel-body scrollx">
                        <table class="table table-bordered datatable" id="table-4">
                            <thead>
                            <tr>
                            </tr>
                            </thead>
                            <tbody>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button id="save_template" type="submit"  class="save btn btn-primary btn-sm btn-icon icon-left" data-loading-text="Loading...">
                        <i class="entypo-floppy"></i>
                        Save
                    </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>
</div>
<script type="text/javascript">
var $searchFilter = {};
var update_new_url;
var postdata;
var click_btn;
    jQuery(document).ready(function ($) {
        public_vars.$body = $("body");
        //show_loading_bar(40);
        $('#summer_filter').submit(function(e){
            e.preventDefault();
            var formData = new FormData($('#summer_filter')[0]);
             show_loading_bar(0);
            $.ajax({
                url:  baseurl +'/cdr_upload/upload',  //Server script to process data
                type: 'POST',
                dataType: 'json',
                beforeSend: function(){
                    $('.btn.upload').button('loading');
                    show_loading_bar({
                        pct: 50,
                        delay: 5
                    });

                },
                afterSend: function(){
                    console.log("Afer Send");
                },
                success: function (response) {
                    show_loading_bar({
                        pct: 100,
                        delay: 2
                    });

                    if (response.status == 'success') {
                        toastr.success(response.message, "Success", toastr_opts);
                        reloadJobsDrodown(0);
                     } else {
                        toastr.error(response.message, "Error", toastr_opts);
                    }
                    //alert(response.message);
                    $('.btn.upload').button('reset');
                },
                // Form data
                data: formData,
                //Options to tell jQuery not to process data or worry about content-type.
                cache: false,
                contentType: false,
                processData: false
            });
            return false;
        });
        $('#bulk_upload').submit(function(e){
            e.preventDefault();
            update_new_url = '{{URL::to('cdr_upload/check_vendorupload')}}';

            var formData = new FormData($('#bulk_upload')[0]);
             show_loading_bar(0);
            $.ajax({
                url: update_new_url,  //Server script to process data
                type: 'POST',
                dataType: 'json',
                beforeSend: function(){
                    $('.btn.upload').button('loading');
                    show_loading_bar({
                        pct: 50,
                        delay: 5
                    });

                },
                afterSend: function(){
                    console.log("Afer Send");
                },
                success: function (response) {
                    show_loading_bar({
                        pct: 100,
                        delay: 2
                    });

                    if (response.status == 'success') {
                        toastr.success(response.message, "Success", toastr_opts);
                        reloadJobsDrodown(0);
                         var data = response.data;
                        $('#add-template').removeClass('hidden');
                        var scrollTo = $('#add-template').offset().top;
                        $('html, body').animate({scrollTop:scrollTo}, 1000);
                        createGrid(data);
                     } else {
                        toastr.error(response.message, "Error", toastr_opts);
                    }
                    //alert(response.message);
                    $('.btn.upload').button('reset');
                },
                // Form data
                data: formData,
                //Options to tell jQuery not to process data or worry about content-type.
                cache: false,
                contentType: false,
                processData: false
            });
            return false;
        });
        $('#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
            });
        }
        });
        // Replace Checboxes
        $(".pagination a").click(function (ev) {
            replaceCheckboxes();
        });
        $('#add-template').hide();
            $(document).ajaxSuccess(function( event, jqXHR, ajaxSettings, ResponseData ) {
                if (ResponseData.status != undefined &&  ResponseData.status == 'success' && ResponseData.data) {
                   createGrid(ResponseData.data);
                   $('#add-template').show();
                   var scrollTo = $('#add-template').offset().top;
                   $('html, body').animate({scrollTop:scrollTo}, 1000);
                }
            });
        $('#check_vendorupload').click(function(e){

                var btn = $(this);
                btn.button('loading');
                $('#table-4_processing').removeClass('hidden');
                update_new_url = '{{URL::to('cdr_upload/ajaxfilegrid')}}';
                data =$('#add-template-form').serialize()+'&'+$("#bulk_upload").serialize();
                $.ajax({
                    url:update_new_url, //Server script to process data
                    type: 'POST',
                    dataType: 'json',
                    success: function(response) {
                        btn.button('reset');
                        if (response.status == 'success') {
                            var data = response.data;
                            createGrid(data);
                            toastr.success(response.message, "Success", toastr_opts);
                        } else {
                            toastr.error(response.message, "Error", toastr_opts);
                        }
                    },
                    data: data,
                    //Options to tell jQuery not to process data or worry about content-type.
                    cache: false
                });
                $('#table-4_processing').addClass('hidden');
                e.preventDefault();
            });
            $("#save_template").click(function(e){
                update_new_url = '{{URL::to('cdr_upload/storeVendorTemplate')}}';
                click_btn = $(this);
            });
            $('#add-template-form').submit(function(e){
                e.preventDefault();
                submit_ajaxbtn(update_new_url,$('#add-template-form').serialize()+'&'+$('#bulk_upload').serialize(),'',click_btn,1);
                return false;
            });
        $('#RateCDR').change(function(){
            if($('#RateCDR').is(":checked")){
                //$('select[name=TrunkID]').select2("val","");
                $('select[name=RateFormat]').select2("val","");
                //$("#trunk_dropdown").removeClass("hidden");
                $("#rate_dropdown").removeClass("hidden");
            }else{
                //$("#trunk_dropdown").addClass("hidden");
                $("#rate_dropdown").addClass("hidden");
            }
        });
        $('#RateCDR').trigger('change');

    });
    function createGrid(data){
        var tr = $('#table-4 thead tr');
        var body = $('#table-4 tbody');
        tr.empty();
        body.empty();
        $.each( data.columns, function( key, value ) {
            tr.append('<th>'+value+'</th>');
        });

        $.each( data.rows, function(key, row) {
            var tr = '<tr>';
            $.each( row, function(key, item) {
                tr+='<td>'+item+'</td>';
            });
            tr += '</tr>';
            body.append(tr);
        });
        $("#mapping select").each(function(i, el){
            if(el.name == 'selection[TrunkID]') {
                var self = $('#add-template-form [name="'+el.name+'"]');
                var label = 'Map From File';
                rebuildSelectComposite(self,data.columns,label);
            } else if (el.name !='selection[DateFormat]') {
                var self = $('#add-template-form [name="'+el.name+'"]');
                rebuildSelect2(self,data.columns,'Skip loading');
            }
        });
        if(data.FileUploadTemplate){
            $.each( data.FileUploadTemplate, function( optionskey, option_value ) {
                if(optionskey == 'Title'){
                    $('#add-template-form').find('[name="TemplateName"]').val(option_value)
                }
                if(optionskey == 'Options'){
                    $.each( option_value.option, function( key, value ) {

                    if(typeof $("#add-template-form [name='option["+key+"]']").val() != 'undefined'){
                        $('#add-template-form').find('[name="option['+key+']"]').val(value)
                        if(key == 'Firstrow'){
                            $("#add-template-form [name='option["+key+"]']").val(value).trigger("change");
                        }
                    }

                    });
                    $.each( option_value.selection, function( key, value ) {
                        if(typeof $("#add-template-form input[name='selection["+key+"]']").val() != 'undefined'){
                            $('#add-template-form').find('input[name="selection['+key+']"]').val(value)
                        }else if(typeof $("#add-template-form select[name='selection["+key+"]']").val() != 'undefined'){
                            $("#add-template-form [name='selection["+key+"]']").val(value).trigger("change");
                        }
                    });
                }
            });
        }else{
            $('#add-template-form').find('[name="TemplateName"]').val('');
        }

        $('#add-template-form').find('[name="TemplateFile"]').val(data.filename);
        $('#add-template-form').find('[name="TempFileName"]').val(data.tempfilename);
        $('#add-template-form').find('[name="OriginalFile"]').val(data.tempfilename);
    }

</script>
<style>
.dataTables_filter label{
    display:none !important;
}
.dataTables_wrapper .export-data{
    right: 30px !important;
}
</style>
@stop
@section('footer_ext')
@parent
<div class="modal fade custom-width in" id="modal-fileformat-detail">
    <div class="modal-dialog" style="width: 60%;">
        <div class="modal-content">

            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                <h4 class="modal-title">CDR Detail File Format</h4>
            </div>



            <div class="modal-body">
            <p>All columns are mandatory and the first line should have the column headings.</p>
                        <table class="table responsive">
                            <thead>
                                <tr>
                                    <th>Account id</th>
                                    <th>CLI</th>
                                    <th>CLD</th>
                                    <th>Billing Prefix</th>
                                    <th>Connect Time</th>
                                    <th>Disconnect Time</th>
                                    <th>Duration, sec</th>
                                    <th>Billed Duration, sec</th>
                                    <th>Cost</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td>BRIGHT TELECOM-563</td>
                                    <td>2035000755</td>
                                    <td>2222441638507980</td>
                                    <td>2222441</td>
                                    <td>25/03/2015  11:01:32 AM</td>
                                    <td>25/03/2015  11:01:58 AM</td>
                                    <td>26</td>
                                    <td>60</td>
                                    <td>0.00399</td>
                                </tr>
                                <tr>
                                    <td>BRIGHT TELECOM-563</td>
                                    <td>1636858774</td>
                                    <td>2222441780755810</td>
                                    <td>2222442</td>
                                    <td>23/03/2015  05:31:26 PM</td>
                                    <td>23/03/2015  05:33:25 PM</td>
                                    <td>119</td>
                                    <td>120</td>
                                    <td>0.00798</td>
                                </tr>
                               <tr>
                                   <td>BRIGHT TELECOM-563</td>
                                   <td>1636858774</td>
                                   <td>2222443301348680</td>
                                   <td>2222443</td>
                                   <td>23/03/2015  11:21:35 AM</td>
                                   <td>23/03/2015  11:22:44 AM</td>
                                   <td>69</td>
                                   <td>120</td>
                                   <td>0.02048</td>
                               </tr>
                            </tbody>
                        </table>

            </div>

            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

@stop