@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>
        <a href="{{URL::to('accounts')}}">Accounts</a>
    </li>
    <li class="active">
        <strong>Import Accounts</strong>
    </li>
</ol>
<h3>Import Accounts</h3>
<p style="text-align: right;margin-bottom: 20px;">
    <a class="btn btn-danger btn-sm btn-icon icon-left canbutton" href="{{URL::to('/accounts')}}">
        <i class="entypo-cancel"></i>
        Close
    </a>
</p>

@include('includes.errors')
@include('includes.success')
<style>
    .col-md-4{
        padding-left:5px;
        padding-right:5px;
    }
    #selectcheckbox1 {
        padding: 15px 10px;
    }
</style>
<div class="panel">
<form id="rootwizard-2" method="post" action="" class="form-wizard validate form-horizontal form-groups-bordered" enctype="multipart/form-data">
    <div class="steps-progress" style="display:none">
        <div class="progress-indicator"></div>
    </div>

    <ul id="wizardul" style="display:none">
        <li class="active" id="st1">
            <a href="#tab2-1" data-toggle="tab"><span>1</span><h5 class="test">Select Import Type</h5></a>
        </li>
        <li id="st2">
            <a href="#tab2-2" data-toggle="tab"><span>2</span><h5 class="test">Upload File</h5></a>
        </li>
        <li id="st3">
            <a href="#tab2-3" data-toggle="tab"><span>3</span><h5 class="test">Mapping and Submit</h5></a>
        </li>
    </ul>


    <div class="tab-content">
        <span class="itype"><h3>Select Import Type</h3></span>
        <div class="tab-pane active" id="tab2-1">

            <div class="row">

                </br></br>
                <div class="col-md-1"></div>
                    <div class="col-md-9">
                        <div class="col-md-4">
                            <input type="radio" name="size" data-id="" value="excel" id="size_S" checked />
                            <label for="size_S" class="newredio active">EXCEL</label>
                        </div>
                        <div class="col-md-4">
                            <input type="radio" name="size" data-id="" value="csv" id="size_M"/>
                            <label for="size_M" class="newredio">CSV</label>
                        </div>
                        @foreach($gatewaylist as $gateway)
                            <div class="col-md-4">
                                <input type="radio" name="size" data-id="{{$gateway['CompanyGatewayID']}}" data-name="{{$gateway['Title']}}" data-gateway="{{$gateway['Gateway']}}" value="{{$gateway['Gateway']}}" id="size_{{$gateway['CompanyGatewayID']}}"/>
                                <label for="size_{{$gateway['CompanyGatewayID']}}" class="newredio">{{$gateway['Title']}}</label>
                            </div>
                        @endforeach
                        @if(!empty($check_quickbook))
                        <div class="col-md-4">
                            <input type="radio" name="size" data-id="" value="quickbook" id="size_Q"/>
                            <label for="size_Q" class="newredio">QuickBook</label>
                        </div>
                        @endif

                    </div>
                <div class="col-md-2"></div>
            </div>
        </div>

        <div class="tab-pane" id="tab2-2">
            <input type="hidden" name="importway" value="">
            <div class="row" id="csvimport">
                <div class="col-md-1"></div>
                <div class="col-md-8">
                    <div class="form-group">
                        <input type="hidden" name="importfrom" value="">
                    </div>
                    <div class="form-group">
                        <label for="field-1" class="col-sm-2 control-label">Upload Template</label>
                        <div class="col-sm-4">
                            {{ Form::select('uploadtemplate', $UploadTemplate, '' , 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" data-validate="required"/>

                        </div>
                    </div>
                    <div class="form-group">
                        <label 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 style="cursor: pointer" onclick="jQuery('#modal-fileformat').modal('show');" 			class="label label-info">Format</span></p>

                            <p>Sample File <a class="btn btn-success btn-sm btn-icon icon-left" href="{{URL::to('/import/account/download_sample_excel_file')}}"><i class="entypo-down"></i>Download</a></p>

                        </div>

                    </div>
                </div>
                <div class="col-md-2"></div>
            </div>

            <div class="row" id="gatewayimport">
                <input type="hidden" name="gateway" value="">
                <input type="hidden" name="CompanyGatewayID" value="">
                <input type="hidden" name="importprocessid" value="">
                <input type="hidden" name="importaccountsuccess" value="">
                <input type="hidden" name="TemplateType" id="TemplateType" value="{{FileUploadTemplateType::getTemplateType(FileUploadTemplate::TEMPLATE_Account)}}" />
                <span id="gateway_filter"></span>
                <span id="get_account"></span>
                <span id="get_vendor"></span>
                <span id="get_accounts_sippy"></span>
                <span id="get_vendors_sippy"></span>
                <span class="gatewayloading">Retrieving Accounts ... </span>

                {{-- here datatable will be placed using javascript --}}
                {{-- datatable layout is at last in #table_templates div --}}
            </div>

            <div class="row" id="quickbookimport">
                <!--<input type="hidden" name="gateway" value="">
                <input type="hidden" name="CompanyGatewayID" value="">-->
                <input type="hidden" name="quickbookimportprocessid" value="">
                <input type="hidden" name="importaccountsuccess" value="">
                <span id="quickbook_filter"></span>
                <span id="get_quickbookaccount"></span>
                <span class="quickbookloading">Retrieving Accounts ... </span>
                <p style="float: right">
                    <button type="button" id="uploadaccount1"  class="btn btn-primary "><i class="entypo-download"></i><span>Import</span></button>
                </p>
                <div class="clear"></div>
                <div class="row">
                    <div class="col-md-12">
                        <table class="table table-bordered datatable" id="table-6">
                            <thead>
                            <tr>
                                <th width="5%"><input type="checkbox" id="selectall1" name="checkbox[]" class="" /></th>
                                <th width="15%" >Account Name</th>
                                <th width="15%" >First Name</th>
                                <th width="15%" >Last Name</th>
                                <th width="15%" >Email</th>
                            </tr>
                            </thead>
                            <tbody>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>


        </div>

        <div class="tab-pane" id="tab2-3">
          <div id="csvactive">
            <div class="row hidden" id="add-template">
                <div class="col-md-12">
                    <div id="add-template-form">
                        <div class="panel panel-primary" data-collapsed="0">
                            <div class="panel-heading">
                                <div class="panel-title">
                                    Mapping Template
                                </div>

                                <div class="panel-options">
                                    <a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
                                </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 />
                                <div class="panel panel-primary" data-collapsed="0">
                                    <div class="panel-heading">
                                        <div class="panel-title">
                                            Account Importer
                                        </div>

                                        <div class="panel-options">
                                            <a href="#" data-rel="collapse"><i class="entypo-down-open"></i></a>
                                        </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="TempFileName" value="" />
                                                <!--<input type="hidden" name="TemplateName" 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">
                                            <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;">
                                            <button class="check btn btn-primary btn-sm btn-icon icon-left">
                                                <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 Mapping
                                        </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">
                                                                                @include('fileuploadtemplates.accounttemplate')
                                    </div>
                                </div>
                                <div class="panel panel-primary" data-collapsed="0">
                                    <div class="panel-heading">
                                        <div class="panel-title">
                                            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">
                                        <div id="table-4_processing" class="dataTables_processing hidden">Processing...</div>
                                        <table class="table table-bordered datatable" id="table-4">
                                            <thead>
                                            <tr>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                <p style="text-align: right;">

                                    <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>
                                </p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
          </div> <!-- csv-excel over-->

          <div id="pbxactive">
              <!--<p style="text-align: right">
                  <button type="button" id="uploadaccount"  class="btn btn-primary "><span>Import</span></button>
              </p>
              <span id="gateway_filter"></span>
            <div class="row">
                <div class="col-md-12">
                    <table class="table table-bordered datatable" id="table-5">
                        <thead>
                        <tr>
                            <th width="5%"><input type="checkbox" id="selectall" name="checkbox[]" class="" /></th>
                            <th width="15%" >Account Name</th>
                            <th width="15%" >First Name</th>
                            <th width="15%" >Last Name</th>
                            <th width="15%" >Email</th>
                        </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>-->
          </div> <!-- gateway active over-->


        </div>

        <ul class="pager wizard">
            <li class="previous">
                <a href="#"><i class="entypo-left-open"></i> Previous</a>
            </li>

            <li class="next">
                <a href="#">Next <i class="entypo-right-open"></i></a>
            </li>
        </ul>
    </div>

</form><!-- Footer -->
</div>

<div id="table_templates" style="display: none;">
    <div id="table_template_sippy">
        <p style="float: right">
            <button type="button" id="uploadaccountsippy"  class="btn btn-primary "><i class="entypo-download"></i><span>Import</span></button>
        </p>
        <div class="clear"></div>
        <div class="panel-heading" style="padding: 0;">
            <ul class="nav nav-tabs">
                <li class="active"><a href="#customertab" data-toggle="tab">Customers</a></li>
                <li><a href="#vendortab" data-toggle="tab">Vendors</a></li>
            </ul>
        </div>
        <div class="panel-body" style="padding: 0;">
            <div class="tab-content" style="margin: 0;">
                <div class="tab-pane fade in active" id="customertab">
                    <div class="row">
                        <div class="col-md-12">
                            <table class="table table-bordered datatable" id="table-5">
                                <thead>
                                    <tr>
                                        <th width="5%"><input type="checkbox" id="selectall" name="checkbox[]" class="" /></th>
                                        <th width="15%" >Account Name</th>
                                        <th width="15%" >First Name</th>
                                        <th width="15%" >Last Name</th>
                                        <th width="15%" >Email</th>
                                        <th width="15%" >New Account Name</th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="tab-pane fade" id="vendortab">
                    <div class="row">
                        <div class="col-md-12">
                            <table class="table table-bordered datatable" id="table-6">
                                <thead>
                                    <tr>
                                        <th width="5%"><input type="checkbox" id="selectall1" name="checkbox[]" class="" /></th>
                                        <th width="15%" >Account Name</th>
                                        <th width="15%" >First Name</th>
                                        <th width="15%" >Last Name</th>
                                        <th width="15%" >Email</th>
                                        <th width="15%" >New Account Name</th>
                                    </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div id="table_template_default">
        <p style="float: right">
            <button type="button" id="uploadaccount"  class="btn btn-primary "><i class="entypo-download"></i><span>Import</span></button>
        </p>
        <div class="clear"></div>
        <div class="panel-heading" style="padding: 0;">
            <ul class="nav nav-tabs">
                <li class="active"><a href="#customertab-default" data-toggle="tab">Customers</a></li>
                <li><a href="#vendortab-default" data-toggle="tab">Vendors</a></li>
            </ul>
        </div>
        <div class="panel-body" style="padding: 0;">
            <div class="tab-content" style="margin: 0;">
                <div class="tab-pane fade in active" id="customertab-default">
                    <div class="row">
                        <div class="col-md-12">
                            <table class="table table-bordered datatable" id="table-5">
                                <thead>
                                <tr>
                                    <th width="5%"><input type="checkbox" id="selectall" name="checkbox[]" class="" /></th>
                                    <th width="15%" >Account Name</th>
                                    <th width="15%" >First Name</th>
                                    <th width="15%" >Last Name</th>
                                    <th width="15%" >Email</th>
                                </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="tab-pane fade" id="vendortab-default">
                    <div class="row">
                        <div class="col-md-12">
                            <table class="table table-bordered datatable" id="table-6">
                                <thead>
                                <tr>
                                    <th width="5%"><input type="checkbox" id="selectall1" name="checkbox[]" class="" /></th>
                                    <th width="15%" >Account Name</th>
                                    <th width="15%" >First Name</th>
                                    <th width="15%" >Last Name</th>
                                    <th width="15%" >Email</th>
                                    <th width="15%" >New Account Name</th>
                                </tr>
                                </thead>
                                <tbody>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script type="text/javascript">
    jQuery(document).ready(function ($) {
        var checked='';
        public_vars.$body = $("body");
        $('input[type="radio"], label').addClass('js');

        $('.newredio').on('click', function() {
            $('.newredio').removeClass('active');
            $(this).addClass('active');
        });

        $('#csvimport').hide();
        $('#csvactive').hide();
        $('#gatewayimport').hide();
        $('#pbxactive').hide();
        $('#uploadaccount').hide();
        $('#uploadaccount1').hide();
        $('#uploadaccountsippy').hide();
        $('#quickbookimport').hide();
        var activetab = '';
        var element= $("#rootwizard-2");
        var progress = element.find(".steps-progress div");
        $('#rootwizard-2').bootstrapWizard({
            tabClass:         '',
            nextSelector:     '.wizard li.next',
            previousSelector: '.wizard li.previous',
            firstSelector:    '.wizard li.first',
            lastSelector:     '.wizard li.last',
            onTabShow: function(tab, navigation, index)
            {
                setCurrentProgressTab(element, navigation, tab, progress, index);
            },
            onTabClick: function(){
                return false;
            },
            onNext: function(tab, navigation, index) {
                activetab = tab.attr('id');
                if(activetab=='st1'){
                    $('.itype').hide();
                    $('#wizardul').removeAttr('style');
                    $('.steps-progress').removeAttr('style');
                    var importfrom = $("#rootwizard-2 input[name='size']:checked").val();
                    if(importfrom=='csv' || importfrom=='excel'){
                        if($('#st3 h5').hasClass("test")){
                            $("#st2 h5.test").html('Upload File');
                            $("#st3 h5.test").html('Mapping and Submit');
                        }else{
                            $('#st3').remove();
                            var html ='';
                            html+='<li id="st3">';
                            html+='<a href="#tab2-3" data-toggle="tab"><span>3</span><h5 class="test">Mapping and Submit</h5></a>';
                            html+='</li>';
                            $('#wizardul li:eq(1)').after(html);
                            //$('#wizardul').append(html);
                            $("#st2 h5.test").html('Upload File');
                            $("#st2").removeAttr('class');
                            $("#st3").removeAttr('class');
                        }
                        $("#csvimport").find("input[name='importfrom']").val(importfrom);
                        $("#rootwizard-2").find("input[name='importway']").val(importfrom);
                        $('#gatewayimport').hide();
                        $('#csvimport').show();
                    }else if(importfrom=='PBX' || importfrom=='Porta' || importfrom=='PortaOne' || importfrom=='MOR' || importfrom =='CallShop' || importfrom =='Streamco' || importfrom =='FusionPBX' || importfrom =='M2' || importfrom =='SippySFTP' || importfrom =='VoipNow' || importfrom =='VoipMS' || importfrom =='ClarityPBX' || importfrom=='VitalPBX'|| importfrom=='VodiaPBX'){
                        $('#st3').remove();
                        $("#st2 h5.test").html('Select Accounts');
                        $("#st3 h5.test").html('Import Accounts');
                        var cgid = $("#rootwizard-2 input[name='size']:checked").attr('data-id');
                        var cgname = $("#rootwizard-2 input[name='size']:checked").attr('data-name');
                        $('#csvimport').hide();
                        $("#gatewayimport").find("input[name='gateway']").val(importfrom);
                        $("#rootwizard-2").find("input[name='importway']").val(importfrom);
                        $("#rootwizard-2").find("input[name='CompanyGatewayID']").val(cgid);
                        $("#gatewayimport").find(".gatewayname").html(cgname);
                        $('#gatewayimport').show();
                        $('#gateway_filter').trigger('click');

                    }else if(importfrom=='quickbook'){
                        $('#st3').remove();
                        $("#st2 h5.test").html('Select Accounts');
                        $("#st3 h5.test").html('Import Accounts');
                        var cgid = $("#rootwizard-2 input[name='size']:checked").attr('data-id');
                        var cgname = $("#rootwizard-2 input[name='size']:checked").attr('data-name');
                        $('#csvimport').hide();
                        $("#quickbookimport").find("input[name='gateway']").val(importfrom);
                        $("#rootwizard-2").find("input[name='importway']").val(importfrom);
                        $("#rootwizard-2").find("input[name='CompanyGatewayID']").val(cgid);
                        $("#quickbookimport").find(".gatewayname").html(cgname);
                        $('#quickbookimport').show();
                        $('#quickbook_filter').trigger('click');

                    }

                }

                if(activetab=='st2'){
                    var importway = $("#rootwizard-2 input[name='importway']").val();
                    if(importway == 'csv' || importway == 'excel') {
                        $("#st2 h5.test").html('Upload File');
                        $("#st3 h5.test").html('Mapping and Submit');
                        $(".pager .next").addClass('disabled');
                        var uploadtemplate = $("#rootwizard-2 select[name='uploadtemplate']").val();
                        var filename = $("#rootwizard-2 input[name='excel']").val();
                        if (filename == '') {
                            toastr.error('Please upload file.', "Error", toastr_opts);
                            $(".pager .next").removeClass('disabled');
                            return false;
                        } else {
                            var formData = new FormData($('#rootwizard-2')[0]);
                            var timeDelay = 500;
                            setTimeout(loadXML, timeDelay);
                            function loadXML() {
                                $.ajax({
                                    url: '{{URL::to('/import/account/check_upload')}}',  //Server script to process data
                                    type: 'POST',
                                    dataType: 'json',
                                    xhr: function () {  // Custom XMLHttpRequest
                                        var myXhr = $.ajaxSettings.xhr();
                                        if (myXhr.upload) { // Check if upload property exists
                                            myXhr.upload.addEventListener('progress', function (evt) {
                                                var percent = (evt.loaded / evt.total) * 100;
                                                show_loading_bar(percent);
                                            }, false);
                                        }
                                        return myXhr;
                                    },
                                    beforeSend: function () {

                                    },
                                    afterSend: function () {
                                        console.log("Afer Send");
                                    },
                                    success: function (response) {
                                        setTimeout(function() {
                                            if (response.status == 'success') {
                                                $('#pbxactive').hide();
                                                $('#csvactive').show();
                                                var data = response.data;
                                                createGrid(data);
                                                $('#add-template').removeClass('hidden');

                                            } else {
                                                toastr.error(response.message, "Error", toastr_opts);
                                                return false;
                                            }
                                        },500);
                                        //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
                                });
                            }
                        }
                    } // import from excel-csv over

                }
            },
            onPrevious: function(tab, navigation, index) {
                activetab = tab.attr('id');
                if(activetab=='st2'){
                    location.reload();
                }
            }
        });


        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) {
                    if(typeof item == 'object' && item != null ){
                        tr+='<td>'+item.date+'</td>';
                    }else{
                        tr+='<td>'+item+'</td>';
                    }
                });
                tr += '</tr>';
                body.append(tr);
            });
            $("#mapping select").each(function(i, el){
                if(el.name !='selection[DateFormat]'){
                    var self = $('#add-template-form [name="'+el.name+'"]');
                    rebuildSelect2(self,data.columns,'Skip loading');
                }
            });
            if(data.AccountFileUploadTemplate){
                $.each( data.AccountFileUploadTemplate, 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");
                            }
                        });
                    }
                });
            }

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

        $('.btn.check').click(function(e){
            e.preventDefault();
            $('#table-4_processing').removeClass('hidden');
            var formData = new FormData($('#add-template-form')[0]);
            var poData = $(document.forms['rootwizard-2']).serializeArray();
            for (var i=0; i<poData.length; i++){
                if(poData[i].name!='excel'){
                    formData.append(poData[i].name, poData[i].value);
                }
            }
            $.ajax({
                url:'{{URL::to('/import/account/ajaxfilegrid')}}',
                type: 'POST',
                dataType: 'json',
                beforeSend: function(){
                    $('.btn.check').button('loading');
                },
                success: function(response) {
                    $('.btn.check').button('reset');
                    if (response.status == 'success') {
                        var data = response.data;
                        createGrid(data);
                    } else {
                        toastr.error(response.message, "Error", toastr_opts);
                    }
                    $('#table-4_processing').addClass('hidden');
                },
                data: formData,
                cache: false,
                contentType: false,
                processData: false
            });
        });
        $("#save_template").click(function(e){
            e.preventDefault();
            var formData = new FormData($('#rootwizard-2')[0]);
            var poData = $(document.forms['form-upload']).serializeArray();
            for (var i=0; i<poData.length; i++){
                if(poData[i].name!='excel'){
                    formData.append(poData[i].name, poData[i].value);
                }
            }
            $.ajax({
                url:'{{URL::to('/import/account/storeTemplate')}}', //Server script to process data
                type: 'POST',
                dataType: 'json',
                beforeSend: function(){
                    $('.btn.save').button('loading');
                },
                success: function(response) {
                    $("#save_template").button('reset');
                    if (response.status == 'success') {
                        toastr.success(response.message, "Success", toastr_opts);
                        reloadJobsDrodown(0);
                        location.reload();
                    } else {
                        toastr.error(response.message, "Error", toastr_opts);
                    }
                },
                data: formData,
                //Options to tell jQuery not to process data or worry about content-type.
                cache: false,
                contentType: false,
                processData: false
            });
        });


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

        /*quickbook */ /* sippy gateway */
        $("#selectall1").click(function(ev) {
            var is_checked = $(this).is(':checked');
            $('#table-6 tbody tr').each(function(i, el) {
                if($(this).find('.rowcheckbox').hasClass('rowcheckbox')){
                    if (is_checked) {
                        $(this).find('.rowcheckbox').prop("checked", true);
                        $(this).addClass('selected');
                    } else {
                        $(this).find('.rowcheckbox').prop("checked", false);
                        $(this).removeClass('selected');
                    }
                }
            });
        });
        $('#table-6 tbody').on('click', 'tr', function() {
            if (checked =='') {
                if ($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                    $(this).toggleClass('selected');
                    if ($(this).hasClass('selected')) {
                        $(this).find('.rowcheckbox').prop("checked", true);
                    } else {
                        $(this).find('.rowcheckbox').prop("checked", false);
                    }
                }
            }
        });


        //display missing gateway account

        $("#gateway_filter").click(function(e) {
            var CompanyGatewayID = $("#rootwizard-2 input[name='size']:checked").attr('data-id');
            var gateway = $("#rootwizard-2 input[name='size']:checked").val();
            $.ajax({
                url: baseurl + '/import/account/getAccountInfoFromGateway/' + CompanyGatewayID + '/' + gateway,
                type: 'POST',
                datatype: 'json',
                data: 'gateway=' + gateway,
                beforeSend: function(){
                    $(".gatewayloading").show();
                },
                success: function (response) {
                    $('.gatewayloading').hide();
                    if (response.status == 'success') {
                        $("#gatewayimport input[name='importaccountsuccess']").val('1');
                        $("#gatewayimport .importsuccessmsg").html('Account Succesfully Import. Please click on next.');
                        $("#gatewayimport input[name='importprocessid']").val(response.processid);

                        if(response.Gateway == 'Sippy') {
                            var table_template_sippy = $('#table_template_sippy').html();
                            $('#gatewayimport').append(table_template_sippy);
                            $('#table_templates').remove();
                            $('#get_accounts_sippy').trigger('click');
                            $('#get_vendors_sippy').trigger('click');
                            $('#uploadaccountsippy').show();
                        } else {
                            var table_template_default = $('#table_template_default').html();
                            $('#gatewayimport').append(table_template_default);
                            $('#table_templates').remove();
                            $('#neon-account-name').remove();
                            $('#get_account').trigger('click');

                            if(response.Gateway == 'ClarityPBX') {
                                $('#get_vendor').trigger('click');
                            }

                            $('#uploadaccount').show();
                        }

                        $('.pager li .next').addClass('disabled');
                    } else {
                        toastr.error(response.message, "Error", toastr_opts);
                        $('#get_account').trigger('click');
                        $('#uploadaccount').show();
                        $('.pager li .next').addClass('disabled');
                    }
                }
            });

        });

        $("#get_account").click(function(e) {
            e.preventDefault();
            var CGatewayID=$("#gatewayimport input[name='CompanyGatewayID']").val();
            var cprocessid=$("#gatewayimport input[name='importprocessid']").val();
            data_table = $("#table-5").dataTable({
                "bProcessing":true,
                "bDestroy": true,
                "bServerSide":true,
                "sAjaxSource": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                "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":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":1});
                    data_table_extra_params.length = 0;
                    data_table_extra_params.push({"name":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":1},{"name":"Export","value":1});
                },
                "sPaginationType": "bootstrap",
                "aaSorting"   : [[1, 'asc']],
                "oTableTools":
                {
                    "aButtons": [
                        {
                            "sExtends": "download",
                            "sButtonText": "Export Data",
                            "sUrl": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                            sButtonClass: "save-collection"
                        }
                    ]
                },
                "aoColumns":
                        [
                            {"bSortable": false,
                                mRender: function(id, type, full) {
                                    return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                }
                            }, //0Checkbox
                            { "bSortable": true },//account name
                            { "bSortable": true },//first name
                            { "bSortable": true },// last name
                            { "bSortable": true }  /* email,
                         { mRender: function(id, type, full) {
                         action = '<div class = "hiddenRowData" >';
                         for(var i = 0 ; i< list_fields.length; i++){
                         action += '<input type = "hidden"  name = "' + list_fields[i] + '"       value = "' + (full[i]?full[i]:'')+ '" / >';
                         }
                         action += '</div>';
                         action += ' <button class="btn clear delete_cdr btn-danger btn-sm btn-icon icon-left" data-loading-text="Loading..."><i ntypo-cancel"></i>Clear CDR</button>';
                         return action;
                         }*/
                        ],
                "fnDrawCallback": function() {
                    $(".dataTables_wrapper select").select2({
                        minimumResultsForSearch: -1
                    });
                    $('#table-5 tbody').off('click');
                    $('#table-5 tbody').on('click', 'tr', function() {
                        if (checked =='') {
                            if ($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                $(this).toggleClass('selected');
                                if ($(this).hasClass('selected')) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                }
                            }
                        }
                    });
                    $("#selectall").click(function(ev) {
                        var is_checked = $(this).is(':checked');
                        $('#table-5 tbody tr').each(function(i, el) {
                            if($(this).find('.rowcheckbox').hasClass('rowcheckbox')){
                                if (is_checked) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                    $(this).addClass('selected');
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", 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-5 tbody tr').each(function(i, el) {
                                    $(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-5 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                });
                            }
                        }
                    });
                }
            });
            $("#selectcheckbox").append('<input type="checkbox" id="selectallbutton" name="checkboxselect[]" class="" title="Select All Found Records" />');
        });

        $("#get_vendor").click(function(e) {
            e.preventDefault();
            var CGatewayID=$("#gatewayimport input[name='CompanyGatewayID']").val();
            var cprocessid=$("#gatewayimport input[name='importprocessid']").val();
            data_table = $("#table-6").dataTable({
                "bProcessing":true,
                "bDestroy": true,
                "bServerSide":true,
                "sAjaxSource": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                "sDom": "<'row'<'col-xs-6 col-left '<'#selectcheckbox1.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":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":2});
                    data_table_extra_params.length = 0;
                    data_table_extra_params.push({"name":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":2},{"name":"Export","value":1});
                },
                "sPaginationType": "bootstrap",
                "aaSorting"   : [[1, 'asc']],
                "oTableTools":
                {
                    "aButtons": [
                        {
                            "sExtends": "download",
                            "sButtonText": "Export Data",
                            "sUrl": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                            sButtonClass: "save-collection"
                        }
                    ]
                },
                "aoColumns":
                        [
                            {"bSortable": false,
                                mRender: function(id, type, full) {
                                    return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                }
                            }, //0Checkbox
                            { "bSortable": true },//account name
                            { "bSortable": true },//first name
                            { "bSortable": true },// last name
                            { "bSortable": true }  /* email,
                         { mRender: function(id, type, full) {
                         action = '<div class = "hiddenRowData" >';
                         for(var i = 0 ; i< list_fields.length; i++){
                         action += '<input type = "hidden"  name = "' + list_fields[i] + '"       value = "' + (full[i]?full[i]:'')+ '" / >';
                         }
                         action += '</div>';
                         action += ' <button class="btn clear delete_cdr btn-danger btn-sm btn-icon icon-left" data-loading-text="Loading..."><i ntypo-cancel"></i>Clear CDR</button>';
                         return action;
                         }*/
                        ],
                "fnDrawCallback": function() {
                    $(".dataTables_wrapper select").select2({
                        minimumResultsForSearch: -1
                    });
                    $('#table-6 tbody').off('click');
                    $('#table-6 tbody').on('click', 'tr', function() {
                        if (checked =='') {
                            if ($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                $(this).toggleClass('selected');
                                if ($(this).hasClass('selected')) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                }
                            }
                        }
                    });
                    $("#selectall1").click(function(ev) {
                        var is_checked = $(this).is(':checked');
                        $('#table-6 tbody tr').each(function(i, el) {
                            if($(this).find('.rowcheckbox').hasClass('rowcheckbox')){
                                if (is_checked) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                    $(this).addClass('selected');
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                    $(this).removeClass('selected');
                                }
                            }
                        });
                    });
                    $('#selectallbutton1').click(function(ev) {
                        if($(this).is(':checked')){
                            checked = 'checked=checked disabled';
                            $("#selectall1").prop("checked", true).prop('disabled', true);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", true).prop('disabled', true);
                                    $(this).addClass('selected');
                                });
                            }
                        }else{
                            checked = '';
                            $("#selectall1").prop("checked", false).prop('disabled', false);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                });
                            }
                        }
                    });
                }
            });
            $("#selectcheckbox1").append('<input type="checkbox" id="selectallbutton1" name="checkboxselect[]" class="" title="Select All Found Records" />');
        });

        $("#get_accounts_sippy").click(function(e) {
            e.preventDefault();
            var CGatewayID=$("#gatewayimport input[name='CompanyGatewayID']").val();
            var cprocessid=$("#gatewayimport input[name='importprocessid']").val();
            data_table = $("#table-5").dataTable({
                "bProcessing":true,
                "bDestroy": true,
                "bServerSide":true,
                "sAjaxSource": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                "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":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":1});
                    data_table_extra_params.length = 0;
                    data_table_extra_params.push({"name":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"Export","value":1});
                },
                "sPaginationType": "bootstrap",
                "aaSorting"   : [[1, 'asc']],
                "oTableTools":
                {
                    "aButtons": [
                        {
                            "sExtends": "download",
                            "sButtonText": "Export Data",
                            "sUrl": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                            sButtonClass: "save-collection"
                        }
                    ]
                },
                "aoColumns":
                        [
                            {"bSortable": false,
                                mRender: function(id, type, full) {
                                    return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                }
                            }, //0Checkbox
                            { "bSortable": true },//account name
                            { "bSortable": true },//first name
                            { "bSortable": true },// last name
                            { "bSortable": true },  // email
                            { "bSortable": false,
                                mRender:function(id, type, full){
                                    return '<input value="'+full[1]+'" name="'+full[0]+'" class="form-control" />';
                                }
                            }
                        ],
                "fnDrawCallback": function() {
                    $(".dataTables_wrapper select").select2({
                        minimumResultsForSearch: -1
                    });
                    $('#table-5 tbody').off('click');
                    $('#table-5 tbody').on('click', 'tr', function() {
                        if (checked =='') {
                            if ($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                $(this).toggleClass('selected');
                                if ($(this).hasClass('selected')) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                }
                            }
                        }
                    });
                    $("#selectall").click(function(ev) {
                        var is_checked = $(this).is(':checked');
                        $('#table-5 tbody tr').each(function(i, el) {
                            if($(this).find('.rowcheckbox').hasClass('rowcheckbox')){
                                if (is_checked) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                    $(this).addClass('selected');
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", 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-5 tbody tr').each(function(i, el) {
                                    $(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-5 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                });
                            }
                        }
                    });
                }
            });
            $("#selectcheckbox").append('<input type="checkbox" id="selectallbutton" name="checkboxselect[]" class="" title="Select All Found Records" />');
        });

        $("#get_vendors_sippy").click(function(e) {
            e.preventDefault();
            var CGatewayID=$("#gatewayimport input[name='CompanyGatewayID']").val();
            var cprocessid=$("#gatewayimport input[name='importprocessid']").val();
            data_table = $("#table-6").dataTable({
                "bProcessing":true,
                "bDestroy": true,
                "bServerSide":true,
                "sAjaxSource": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                "sDom": "<'row'<'col-xs-6 col-left '<'#selectcheckbox1.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":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"accounttype","value":2});
                    data_table_extra_params.length = 0;
                    data_table_extra_params.push({"name":"CompanyGatewayID","value":CGatewayID},{"name":"importprocessid","value":cprocessid},{"name":"Export","value":1});
                },
                "sPaginationType": "bootstrap",
                "aaSorting"   : [[1, 'asc']],
                "oTableTools":
                {
                    "aButtons": [
                        {
                            "sExtends": "download",
                            "sButtonText": "Export Data",
                            "sUrl": baseurl + "/import/account/ajax_get_missing_gatewayaccounts",
                            sButtonClass: "save-collection"
                        }
                    ]
                },
                "aoColumns":
                        [
                            {"bSortable": false,
                                mRender: function(id, type, full) {
                                    return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                }
                            }, //0Checkbox
                            { "bSortable": true },//account name
                            { "bSortable": true },//first name
                            { "bSortable": true },// last name
                            { "bSortable": true },  // email
                            { "bSortable": false,
                                mRender:function(id, type, full){
                                    return '<input value="'+full[1]+'" name="'+full[0]+'" class="form-control" />';
                                }
                            }
                        ],
                "fnDrawCallback": function() {
                    $(".dataTables_wrapper select").select2({
                        minimumResultsForSearch: -1
                    });
                    $('#table-6 tbody').off('click');
                    $('#table-6 tbody').on('click', 'tr', function() {
                        if (checked =='') {
                            if ($(this).find('.rowcheckbox').hasClass('rowcheckbox')) {
                                $(this).toggleClass('selected');
                                if ($(this).hasClass('selected')) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                }
                            }
                        }
                    });
                    $("#selectall1").click(function(ev) {
                        var is_checked = $(this).is(':checked');
                        $('#table-6 tbody tr').each(function(i, el) {
                            if($(this).find('.rowcheckbox').hasClass('rowcheckbox')){
                                if (is_checked) {
                                    $(this).find('.rowcheckbox').prop("checked", true);
                                    $(this).addClass('selected');
                                } else {
                                    $(this).find('.rowcheckbox').prop("checked", false);
                                    $(this).removeClass('selected');
                                }
                            }
                        });
                    });
                    $('#selectallbutton1').click(function(ev) {
                        if($(this).is(':checked')){
                            checked = 'checked=checked disabled';
                            $("#selectall1").prop("checked", true).prop('disabled', true);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", true).prop('disabled', true);
                                    $(this).addClass('selected');
                                });
                            }
                        }else{
                            checked = '';
                            $("#selectall1").prop("checked", false).prop('disabled', false);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                });
                            }
                        }
                    });
                }
            });
            $("#selectcheckbox1").append('<input type="checkbox" id="selectallbutton1" name="checkboxselect[]" class="" title="Select All Found Records" />');
        });
        //ajax search over


        // import account in system from gateway
        $(document).on('click', "#uploadaccount", function(ev) {
            var criteria = '';
            var AccountIDs = [];
            var gatewayid = $("#rootwizard-2 input[name='CompanyGatewayID']").val();
            var importprocessid = $("#rootwizard-2 input[name='importprocessid']").val();
            if($('#selectallbutton').is(':checked') && $('#selectallbutton1').is(':checked')){
                //criteria = JSON.stringify($searchFilter);
                criteria = 1;
            }else{
                $('#table-5 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        AccountIDs.push(AccountID);
                    }
                });
                $('#table-6 tr .rowcheckbox:checked').each(function() {
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        AccountIDs.push(AccountID);
                    }
                });
            }
            if(AccountIDs.length || criteria==1 ){
                if(criteria==''){
                    AccountIDs=AccountIDs.join(",");
                }
                if (!confirm('Are you sure you want to import selected gateway account?')) {
                    return;
                }
                $.ajax({
                    url: baseurl + '/import/account/add_missing_gatewayaccounts',
                    data: 'TempAccountIDs='+AccountIDs+'&criteria='+criteria+'&companygatewayid='+gatewayid+'&importprocessid='+importprocessid,
                    error: function () {
                        toastr.error("error", "Error", toastr_opts);
                    },
                    dataType: 'json',
                    success: function (response) {
                        if (response.status == 'success') {
                            toastr.success(response.message, "Success", toastr_opts);
                            reloadJobsDrodown(0);
                            location.reload();
                        } else {
                            toastr.error(response.message, "Error", toastr_opts);
                        }
                    },
                    type: 'POST'
                });

            }
        });

        // import accounts in system from sippy gateway
        $(document).on('click', "#uploadaccountsippy", function(ev) {
            var criteria = '';
            var AccountIDs = [];
            var NeonAccountNames = {};
            var gatewayid = $("#rootwizard-2 input[name='CompanyGatewayID']").val();
            var importprocessid = $("#rootwizard-2 input[name='importprocessid']").val();
            if($('#selectallbutton').is(':checked') && $('#selectallbutton1').is(':checked')){
                //criteria = JSON.stringify($searchFilter);
                criteria = 1;
                var i = 0;
                $('#table-5 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        NeonAccountNames[AccountID] = $('input[name='+AccountID+']').val();
                    }
                });
                $('#table-6 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        NeonAccountNames[AccountID] = $('input[name='+AccountID+']').val();
                    }
                });
            }else{
                $('#table-5 tr .rowcheckbox:checked').each(function() {
                    //console.log($(this).val());
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        AccountIDs.push(AccountID);
                        NeonAccountNames[AccountID] = $('input[name='+AccountID+']').val();
                    }
                });
                $('#table-6 tr .rowcheckbox:checked').each(function() {
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        AccountIDs.push(AccountID);
                        NeonAccountNames[AccountID] = $('input[name='+AccountID+']').val();
                    }
                });
            }
            NeonAccountNames = JSON.stringify(NeonAccountNames);
            /*console.log(AccountIDs);
            console.log(NeonAccountNames);*/
            if(AccountIDs.length || criteria==1 ){
                if(criteria==''){
                    AccountIDs=AccountIDs.join(",");
                }
                if (!confirm('Are you sure you want to import selected gateway account?')) {
                    return;
                }
                $.ajax({
                    url: baseurl + '/import/account/add_missing_gatewayaccounts',
                    data: 'TempAccountIDs='+AccountIDs+'&criteria='+criteria+'&companygatewayid='+gatewayid+'&importprocessid='+importprocessid+'&NeonAccountNames='+NeonAccountNames+'&gateway=sippy',
                    error: function () {
                        toastr.error("error", "Error", toastr_opts);
                    },
                    dataType: 'json',
                    success: function (response) {
                        if (response.status == 'success') {
                            toastr.success(response.message, "Success", toastr_opts);
                            reloadJobsDrodown(0);
                            location.reload();
                        } else {
                            toastr.error(response.message, "Error", toastr_opts);
                        }
                    },
                    type: 'POST'
                });

            }
        });


        /*QuickBook Import*/

        $("#quickbook_filter").click(function(e) {
            $.ajax({
                url: baseurl + '/import/account/getAccountInfoFromQuickbook',
                type: 'POST',
                datatype: 'json',
                data: 'gateway=quickbook',
                beforeSend: function(){
                    $(".quickbookloading").show();
                },
                success: function (response) {
                    //$('#importaccount').button('reset');
                    $('.quickbookloading').hide();
                    if (response.status == 'success') {
                        //$('#importaccount').hide();
                        $("#quickbookimport input[name='importaccountsuccess']").val('1');
                        $("#quickbookimport .importsuccessmsg").html('Account Succesfully Import. Please click on next.');
                        $("#quickbookimport input[name='quickbookimportprocessid']").val(response.processid);
                        //toastr.success(response.message, "Success", toastr_opts);
                        $('#get_quickbookaccount').trigger('click');
                        $('#uploadaccount1').show();
                        $('.pager li .next').addClass('disabled');
                    } else {
                        toastr.error(response.message, "Error", toastr_opts);
                        $('#get_quickbookaccount').trigger('click');
                        $('#uploadaccount1').show();
                        $('.pager li .next').addClass('disabled');
                    }
                }
            });

        });

        $("#get_quickbookaccount").click(function(e) {
            e.preventDefault();
            //var CGatewayID=$("#gatewayimport input[name='CompanyGatewayID']").val();
            var cprocessid=$("#quickbookimport input[name='quickbookimportprocessid']").val();
            data_table = $("#table-6").dataTable({
                "bProcessing":true,
                "bDestroy": true,
                "bServerSide":true,
                "sAjaxSource": baseurl + "/import/account/ajax_get_missing_quickbookaccounts",
                "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":"quickbookimportprocessid","value":cprocessid});
                    data_table_extra_params.length = 0;
                    data_table_extra_params.push({"name":"quickbookimportprocessid","value":cprocessid},{"name":"Export","value":1});
                },
                "sPaginationType": "bootstrap",
                "aaSorting"   : [[1, 'asc']],
                "oTableTools":
                {
                    "aButtons": [
                        {
                            "sExtends": "download",
                            "sButtonText": "Export Data",
                            "sUrl": baseurl + "/import/account/ajax_get_missing_quickbookaccounts",
                            sButtonClass: "save-collection"
                        }
                    ]
                },
                "aoColumns":
                        [
                            {"bSortable": false,
                                mRender: function(id, type, full) {
                                    return '<div class="checkbox "><input type="checkbox" name="checkbox[]" value="' + id + '" class="rowcheckbox" ></div>';
                                }
                            }, //0Checkbox
                            { "bSortable": true },//account name
                            { "bSortable": true },//first name
                            { "bSortable": true },// last name
                            { "bSortable": true }  // email,

                        ],
                "fnDrawCallback": function() {
                    $(".dataTables_wrapper select").select2({
                        minimumResultsForSearch: -1
                    });
                    $('#table-6 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');
                            }
                        }
                    });
                    $('#selectallbutton1').click(function(ev) {
                        if($(this).is(':checked')){
                            checked = 'checked=checked disabled';
                            $("#selectall1").prop("checked", true).prop('disabled', true);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", true).prop('disabled', true);
                                    $(this).addClass('selected');
                                });
                            }
                        }else{
                            checked = '';
                            $("#selectall1").prop("checked", false).prop('disabled', false);
                            if(!$('#changeSelectedInvoice').hasClass('hidden')){
                                $('#table-6 tbody tr').each(function(i, el) {
                                    $(this).find('.rowcheckbox').prop("checked", false).prop('disabled', false);
                                    $(this).removeClass('selected');
                                });
                            }
                        }
                    });
                }
            });
            $("#selectcheckbox").append('<input type="checkbox" id="selectallbutton1" name="checkboxselect[]" class="" title="Select All Found Records" />');
        });
        //ajax search over


        // import account in system from gateway
        $("#uploadaccount1").click(function(ev) {
            var criteria = '';
            var AccountIDs = [];
            //var gatewayid = $("#rootwizard-2 input[name='CompanyGatewayID']").val();
            var quickbookimportprocessid = $("#rootwizard-2 input[name='quickbookimportprocessid']").val();

            if($('#selectallbutton1').is(':checked')){
                //criteria = JSON.stringify($searchFilter);
                criteria = 1;
            }else{
                var i = 0;
                $('#table-6 tr .rowcheckbox:checked').each(function(i, el) {
                    //console.log($(this).val());
                    AccountID = $(this).val();
                    if(typeof AccountID != 'undefined' && AccountID != null && AccountID != 'null'){
                        AccountIDs[i++] = AccountID;
                    }
                });
            }
            if(AccountIDs.length || criteria==1 ){
                if(criteria==''){
                    AccountIDs=AccountIDs.join(",");
                }
                if (!confirm('Are you sure you want to import selected gateway account?')) {
                    return;
                }
                $.ajax({
                    url: baseurl + '/import/account/add_missing_quickbookaccounts',
                    data: 'TempAccountIDs='+AccountIDs+'&criteria='+criteria+'&gateway=quickbook&quickbookimportprocessid='+quickbookimportprocessid,
                    error: function () {
                        toastr.error("error", "Error", toastr_opts);
                    },
                    dataType: 'json',
                    success: function (response) {
                        if (response.status == 'success') {
                            toastr.success(response.message, "Success", toastr_opts);
                            reloadJobsDrodown(0);
                            location.reload();
                        } else {
                            toastr.error(response.message, "Error", toastr_opts);
                        }
                    },
                    type: 'POST'
                });

            }
        });


        });
    </script>
<script type="text/javascript" src="