@extends('layout.master',['activePage' => 'migraciones', 'menuParent' => 'Configuracion', 'titlePage' => __('Migraciones')])

@push('plugin-styles')
    {!! Html::style('assets/css/loader.css') !!}
    {!! Html::style('assets/css/apps/tickets.css') !!}
    {!! Html::style('assets/css/elements/tooltip.css') !!}
    {!! Html::style('plugins/apex/apexcharts.css') !!}
    {!! Html::style('plugins/sweetalerts/sweetalert2.min.css') !!}
    {!! Html::style('plugins/sweetalerts/sweetalert.css') !!}
    {!! Html::style('assets/css/basic-ui/custom_sweetalert.css') !!}
    {!! Html::style('plugins/notification/snackbar/snackbar.min.css') !!}
@endpush

@section('content')
    <!--  Navbar Starts / Breadcrumb Area Starts -->
    <div class="sub-header-container">
        <header class="header navbar navbar-expand-sm">
            <ul class="navbar-nav flex-row">
                <li>
                    <div class="page-header">
                        <nav class="breadcrumb-one" aria-label="breadcrumb">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item"><a href="javascript:void(0);"> {{__('CR')}}</a></li>
                                <li class="breadcrumb-item"><a href="javascript:void(0);"> {{__('Clientes')}}</a></li>
                                <li class="breadcrumb-item active" aria-current="page">
                                    <span> {{__('MIGRACIONES')}}</span></li>
                            </ol>
                        </nav>
                    </div>
                </li>
            </ul>
        </header>
    </div>
    <!--  Navbar Ends / Breadcrumb Area Ends -->
    <div class="col-lg-12">
        <div class="row">
            <div class="col-lg-12">
                <div class="statbox widget box box-shadow mb-4">
                    <div class="widget-content widget-content-area">
                        <div class="w-100">
                            <div class="row">
                                <div class="col-md-6">
                                    <label>DB Origen</label>
                                    <select class="form-control" id="dbOrigen" name="dbOrigen" required>
                                        <option value="" selected disabled>-[Selecciona una Opción]-</option>
                                        @foreach( $data['dbs'] as $d)
                                            <option value="{{$d->Database}}" @if($d->Database=='terra'):
                                                    {{'selected'}} @endif >{{$d->Database}}</option>
                                        @endforeach;
                                    </select>
                                </div>
                                <div class="col-md-6">
                                    <label>DB Destino</label>
                                    <select class="form-control" id="dbDestino" name="dbDestino" required>
                                        <option value="" selected disabled>-[Selecciona una Opción]-</option>
                                        @foreach( $data['dbs'] as $d)
                                            <option value="{{$d->Database}}" @if($d->Database=='terra2'):
                                                    {{'selected'}} @endif readonly>{{$d->Database}}</option>
                                        @endforeach;
                                    </select>
                                </div>
                            </div>

                        </div>
                    </div>
                </div>
                <div class="statbox widget box box-shadow mb-4">
                    <div class="widget-content widget-content-area">
                        <div class="w-100 p-5">
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Sucursales</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_sucursales">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_sucursales">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_sucursales"
                                            onclick="migraTabla('sucursales')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-sucursales br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>ConceptosCr</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_conceptoscr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_conceptoscr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_conceptoscr"
                                            onclick="migraTabla('conceptoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-conceptoscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Usuarios</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_usuarios">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_usuarios">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_usuarios"
                                            onclick="migraTabla('usuarios')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-usuarios br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Agentes</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_agentes">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_agentes">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_agentes"
                                            onclick="migraTabla('agentes')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-agentes br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Rutas Cobro</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_rutas">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_rutas">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_rutas"
                                            onclick="migraTabla('rutas')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-rutas br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Rutas Cobro Detalle</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_rutas_detalle">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_rutas_detalle">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_rutas_detalle"
                                            onclick="migraTabla('rutas_detalle')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-rutas_detalle br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Folios</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_folios">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_folios">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_folios"
                                            onclick="migraTabla('folios')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-folios br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>ClientesCr</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_clientescr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_clientescr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_clientescr"
                                            onclick="migraTabla('clientescr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-clientescr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>ClientesCr Correos</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_clientescr_correos">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_clientescr_correos">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_clientescr_correos"
                                            onclick="migraTabla('clientescr_correos')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-clientescr_correos br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Telefonos</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_telefonos">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_telefonos">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_telefonos"
                                            onclick="migraTabla('telefonos')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-telefonos br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Solicitantes</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_solicitantes">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_solicitantes">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_solicitantes"
                                            onclick="migraTabla('solicitantes')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-solicitantes br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>SaldosCR</small>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_saldoscr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_saldoscr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_saldoscr"
                                            onclick="migraTabla('saldoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-saldoscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>SaldosDetalleCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_saldosdetallecr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_saldosdetallecr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_saldosdetallecr"
                                            onclick="migraTabla('saldosdetallecr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-saldosdetallecr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Tarjetas</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_tarjetas">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_tarjetas">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_tarjetas"
                                            onclick="migraTabla('tarjetas')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-tarjetas br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>HistorCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_historcr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_historcr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_historcr"
                                            onclick="migraTabla('historcr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-historcr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>HistdomCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_histdomcr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_histdomcr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_histdomcr"
                                            onclick="migraTabla('histdomcr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-histdomcr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Histortarjcr</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_histortarjcr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_histortarjcr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_histortarjcr"
                                            onclick="migraTabla('histortarjcr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-histortarjcr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Notas ClientesCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_notasclientescr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_notasclientescr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_notasclientescr"
                                            onclick="migraTabla('notasclientescr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-notasclientescr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>CompromisosCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_compromisoscr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_compromisoscr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_compromisoscr"
                                            onclick="migraTabla('compromisoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-compromisoscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Notas Cobranza CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_notascobranzacr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_notascobranzacr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_notascobranzacr"
                                            onclick="migraTabla('notascobranzacr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-notascobranzacr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>HhistorCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_hhistorcr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_hhistorcr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_hhistorcr"
                                            onclick="migraTabla('hhistorcr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-hhistorcr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>HistestatusCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_histestatuscr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_histestatuscr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_histestatuscr"
                                            onclick="migraTabla('histestatuscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-histestatuscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Archivos Expediente</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_archivosexpediente">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_archivosexpediente">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_archivosexpediente"
                                            onclick="migraTabla('archivosexpediente')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-archivosexpediente br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Preautorizaciones</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_preautorizaciones">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_preautorizaciones">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_preautorizaciones"
                                            onclick="migraTabla('preautorizaciones')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-preautorizaciones br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Estadisticas</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_estadisticas" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_estadisticas" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_estadisticas"
                                            onclick="migraTabla('estadisticas')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-estadisticas br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Solicitantes Emails CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_solicitantes_emailscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_solicitantes_emailscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_solicitantes_emailscr"
                                            onclick="migraTabla('solicitantes_emailscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-solicitantes_emailscr br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Solicitantes Telefonos CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_solicitantes_telefonoscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_solicitantes_telefonoscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_solicitantes_telefonoscr"
                                            onclick="migraTabla('solicitantes_telefonoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-solicitantes_telefonoscr br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Solicitantes Complemento CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_solicitantescr_complemento" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_solicitantescr_complemento" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2"
                                            id="btn_solicitantescr_complemento"
                                            onclick="migraTabla('solicitantescr_complemento')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-solicitantescr_complemento br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Solicitantes Rechazados CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_solicitantescr_rechazados" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_solicitantescr_rechazados" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2"
                                            id="btn_solicitantescr_rechazados"
                                            onclick="migraTabla('solicitantescr_rechazados')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-solicitantescr_rechazados br-0"
                                             role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>HistlimCR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_histlimcr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_histlimcr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_histlimcr"
                                            onclick="migraTabla('histlimcr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-histlimcr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Notas Documentos CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_notasdocumentoscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_notasdocumentoscr" disabled>
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_notasdocumentoscr"
                                            onclick="migraTabla('notasdocumentoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-notasdocumentoscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Cortes CR</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Año:"
                                           id="desde_cortescr" maxlength="4">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Mes:"
                                           id="hasta_cortescr" maxlength="2">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_cortescr"
                                            onclick="migraTabla('cortescr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-cortescr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Familiar</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_familias">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_familias">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_familias"
                                            onclick="migraTabla('familias')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-familias br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Referencias Personales</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_refes">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_refes">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_refes"
                                            onclick="migraTabla('refes')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-refes br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Referencias Comerciales</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_refescomerciales">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_refescomerciales">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_refescomerciales"
                                            onclick="migraTabla('refescomerciales')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-refescomerciales br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Datos Vivienda</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_viviendas">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_viviendas">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_viviendas"
                                            onclick="migraTabla('viviendas')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-viviendas br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Datos Laborales</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_laborales">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_laborales">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_laborales"
                                            onclick="migraTabla('laborales')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-laborales br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Promociones</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_promocionescr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_promocionescr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_promocionescr"
                                            onclick="migraTabla('promocionescr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-promocionescr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>


                            <div class="form-group row">
                                <div class="col-lg-2">

                                    <small>Doctoscr</small>
                                    <div class="input-group">
                                        <input type="text" class="form-control form-control-sm" placeholder="AAAAMMDD"
                                               id="anio_doctoscr">

                                    </div>
                                </div>

                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_doctoscr">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_doctoscr">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_doctoscr"
                                            onclick="migraTabla('doctoscr')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-doctoscr br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <!-- <div class="form-group row">
                                <div class="col-lg-2">
                                    <small>Promociones Sucursales</small>

                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Desde:"
                                           id="desde_promocionescr_sucursales">
                                </div>
                                <div class="col-lg-2">
                                    <input type="number" class="form-control form-control-sm" placeholder="Hasta:"
                                           id="hasta_promocionescr_sucursales">
                                </div>
                                <div class="col-lg-2">
                                    <button type="button" class="btn btn-primary mr-2" id="btn_promocionescr_sucursales"
                                            onclick="migraTabla('promocionescr_sucursales')">
                                        Migrar
                                    </button>
                                </div>
                                <div class="col-lg-4">
                                    <div class="progress mb-2 br-30">
                                        <div class="progress-bar progress-bar-promocionescr_sucursales br-0" role="progressbar"
                                             aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"
                                             style="width: 1%;">
                                        </div>
                                    </div>
                                </div>
                            </div> -->
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </div>


@endsection

@push('plugin-scripts')
    {!! Html::script('assets/js/loader.js') !!}
    {!! Html::script('plugins/jquery-ui/jquery-ui.min.js') !!}
    {!! Html::script('plugins/sweetalerts/sweetalert2.min.js') !!}
    {!! Html::script('assets/js/basicui/sweet_alerts.js') !!}
    {!! Html::script('plugins/notification/snackbar/snackbar.min.js') !!}
@endpush

@push('custom-scripts')
    <script type="text/javascript">
		$(document).ready(function () {


		});

		function migraTabla(id) {

			// alert(id);
			$("#btn_" + id).prop('disabled', true);
			var anio = $("#anio_"+id).val();
			var dbOrigen = $("#dbOrigen").val();
			if (dbOrigen == null) {
				Swal.fire({
					type: 'info',
					title: 'Seleccione una Base de Datos de Origen',
					showConfirmButton: false,
					timer: 2500
				});
				$("#dbOrigen").focus();
				return false;
			}
			var dbDestino = $("#dbDestino").val();
			var desde = $("#desde_" + id).val();
			var hasta = $("#hasta_" + id).val();

			var percent = 0;
			timerId = setInterval(function () {
				//increment progress bar
				percent += 5;
				$('.progress-bar-' + id).css('width', percent + '%');
				$('.progress-bar-' + id).attr('aria-valuenow', percent);
				$('.progress-bar-' + id).text(percent + '%');

				//complete
				if (percent == 100) {
					clearInterval(timerId);
					Swal.fire({
						type: 'info',
						title: 'Espere un momento...',
						showConfirmButton: false,
						timerProgressBar: true
					});
				}
			}, 1000);
			let patch = '../configuracion/migra-' + id;
			$.ajax({
				url: patch,
				type: 'POST',
				dataType: 'json',
				data: {
					dbOrigen: dbOrigen,
					dbDestino: dbDestino,
					desde: desde,
					hasta: hasta,
					anio: anio,
				},
			})
				.done(function (resp) {
					$("#btn_" + id).prop('disabled', false);
					percent = 100;
					clearInterval(timerId);
					$('.progress-bar-' + id).css('width', '100%');
					$('.progress-bar-' + id).attr('aria-valuenow', 100);
					$('.progress-bar-' + id).text('100%');
					swal.close();

					Snackbar.show({
						text: '¡Se ha completado la migración!',
						actionTextColor: '#fff',
						backgroundColor: '#8dbf42',
						pos: 'top-right'
					});
				})
				.fail(function () {
					console.log("error");
					swal.close();
					clearInterval(timerId);
					Swal.fire({
						type: 'error',
						title: 'Algo salio mal durante el proceso, intentalo más tarde',
						showConfirmButton: false,
						timer: 2500
					});
				})
				.always(function (resp) {
					console.log("complete");
					$("#btn_" + id).prop('disabled', false);
				});
		}

    </script>

@endpush