@extends('layouts.main')
@section('title', 'Gesamt-Import verwalten')
@section('headline', 'Gesamt-Import verwalten')
@section('content')

    <div id="main-wrapper">
        <div class="row">
            <div class="col-md-12">
                @if (Session::has('errorMessage'))
                    <div class="alert alert-danger">
                        @foreach(Session::get('errorMessage') as $errorMessage)
                            <div>
                                <strong>{{ $errorMessage['row'] }}:</strong>
                                @foreach($errorMessage['message'] as $message)
                                    <div style="padding-left: 8px;">{{ $message }}</div>
                                @endforeach
                            </div>
                        @endforeach
                    </div>
                @endif
                @if($alert == 'successUpload')
                    <div class="alert alert-success" role="alert">
                        Das Kunstobjekt wurde erfolgreich aktualisiert!
                    </div>
                @endif

                <div class="panel panel-white">
                    <div class="panel-heading clearfix">
                    </div>
                    <div class="panel-body">
                        <div class="table-responsive">
                            <div class="filter-container" id="filterContainer">
                                {!! Form::open(['action' => 'AuctionObjectsImport\AuctionObjectsImportAllOverviewController@index', 'class' => 'form-horizontal', 'id' => 'filterAuctionObjectForm', 'method' => 'get', 'role' => 'form', 'files' => true]) !!}
                                    <input name="filtered" id="filtered" type="hidden" value="1">
                                    <input name="page" id="page" type="hidden" value="{{$page}}">
                                    <div id="pageLen" style="float: right; margin-left: 20px;">
                                        <input class="form-control" name="len" id="inputPageLen" type="text" max="999" maxlength="3" value="@if($pageLength){{$pageLength}}@else{{auth()->user()->table_page_length}}@endif" style="float: left; width: 50px;"> <label style="float: right; padding: 7px 5px 0;">Einträge anzeigen</label>
                                    </div>
                                    <select class="form-control" id="selectFilterArtistStatus" name="status" style="width: 175px; float: right;">
                                        <option value="" @if(is_null($selectedFilterStatus)) selected @endif>- Status wählen -</option>
                                        <option value="0" @if($selectedFilterStatus == 0 && !is_null($selectedFilterStatus)) selected @endif>Neu</option>
                                        <option value="1" @if($selectedFilterStatus == 1) selected @endif>Übernehmen</option>
                                        <option value="2" @if($selectedFilterStatus == 2) selected @endif>Verwerfen</option>
                                        <option value="3" @if($selectedFilterStatus == 3) selected @endif>Übernommen</option>
                                        <option value="4" @if($selectedFilterStatus == 4) selected @endif>Verworfen</option>
                                    </select>
                                    <label style="float: right; padding: 7px 5px 0;">Filtern:</label>
                                {!! Form::close() !!}
                            </div>

                            <div class="button-line" id="buttonLine">
                                <button class="btn btn-primary btn-search" type="button" onclick="document.getElementById('filterAuctionObjectForm').submit()">Suchen</button>
                            </div>

                            {!! Form::open(['action' => 'Ajax\AuctionObjectsImportAllOverviewController@bulkEditStatus', 'class' => 'form-horizontal', 'id' => 'frm-bulk-edit', 'method' => 'post', 'role' => 'form', 'files' => true]) !!}
                            <table id="data-table-auction-objects-import-all" class="cell-border data-table display table table-data-width nowrap hover">
                                <thead>
                                    <tr>
                                        <th class="col-bulk">
                                            <input id="dt-check-all" type="checkbox">
                                        </th>
                                        <th>Status</th>
                                        <th>Auktion</th>
                                        <th>Künstler VN</th>
                                        <th>Künstler NN</th>
                                        <th>Geb.Ort</th>
                                        <th>Geb.</th>
                                        <th>Gest.</th>
                                        <th>Gest.Ort</th>
                                        <th>Technik</th>
                                        <th>Pfad</th>
                                        <th>Auktionsnr.</th>
                                        <th>Lot Nr.</th>
                                        <th>Titel</th>
                                        <th>Entst.Txt 1</th>
                                        <th>Entstehung</th>
                                        <th>Entst.Txt 2</th>
                                        <th>SP von</th>
                                        <th>SP bis</th>
                                        <th>SP Währ.</th>
                                        <th>Erlös</th>
                                        <th>Erlös Währ.</th>
                                        <th>Katalog.</th>
                                        <th>Höhe</th>
                                        <th>Breite</th>
                                        <th>Tiefe</th>
                                        <th>Einheit</th>
                                        <th>Bildpfad</th>
                                        <th>Auktionsort</th>
                                        <th>Auktionsdat.</th>
                                        <th>Auktionshaus</th>
                                        <th>Objektnr.</th>
                                        <th class="col-id">ID</th>
                                        <th>Anlagedat.</th>
                                        <th>Auslesedat.</th>
                                        <th>Essay</th>
                                        <th>Zustand</th>
                                        <th>Provenance</th>
                                        <th>Exhibition</th>
                                        <th>Lot Detail</th>
                                    </tr>
                                </thead>
                            </table>

                            <div class="row" style="padding-bottom: 20px;">
                                <div class="col-md-12">
                                    <label for="bulk_action" class="control-label pull-left" style="padding: 0 20px; font-size: 24px;"><i class="fa fa-level-up" aria-hidden="true" style="transform: rotate(90deg);"></i></label>
                                    <select class="form-control pull-left" name="bulk_action" id="bulk_action" style="margin-right: 20px; width: 200px;">
                                        <option value="">- Aktion wählen -</option>
                                        <option value="0">Status: Neu</option>
                                        <option value="1">Status: Übernehmen</option>
                                        <option value="2">Status: Verwerfen</option>
                                    </select>
                                    <button type="submit" id="btnBulkAction" class="btn btn-primary">Absenden</button>
                                    <button type="button" id="btnStartTransferProcess" class="btn btn-primary pull-right" style="margin-left: 75px;">
                                        <span class="button-text"><i class="fa fa-check" aria-hidden="true"></i> Datenübertragung starten</span>
                                        <span class="message-running-service" style="display: none;"><i class="fa fa-hourglass-start" aria-hidden="true"></i> Bitte warten...</span>
                                    </button>
                                </div>
                            </div>
                            {!! Form::close() !!}

                            {!! Form::open(['action' => 'AuctionObjectsImport\AuctionObjectsImportAllOverviewController@startTransferProcess', 'class' => 'form-horizontal', 'id' => 'transferProcessForm', 'method' => 'post', 'role' => 'form', 'files' => true]) !!}
                                <input type="hidden" name="transfer-process-started" id="transfer-process-started" value="1">
                                <input type="hidden" name="editor" id="editor" value="{{Auth::user()->id}}">
                            {!! Form::close() !!}

                            <div class="clear"></div>

                            @if (Auth::user()->user_role_id == 1 || Auth::user()->user_role_id == 2)
                                {!! Form::open(['action' => 'AuctionObjectsImport\ArtSpotterImportFileController@upload', 'class' => 'form-horizontal', 'id' => 'transferProcessForm', 'method' => 'post', 'role' => 'form', 'files' => true]) !!}

                                    <div class="container-fluid" style="background: #eee; padding: 25px 50px;">
                                        <div class="row">
                                            <div class="col-md-6 col-sm-12">
                                                <div class="form-group" id="logoUploadField">
                                                    <h2>Datei-Upload</h2>
                                                    <div id="auktionshaus">
                                                        <label for="auktionshaus">Auktionshaus:</label>
                                                        <div class="auktionshaus-input">
                                                            {{--<input name="auctionHouse" type="text" required>--}}
                                                            <select class="form-control" name="auctionHouse" id="auktionshaus" style="min-width: 275px;" required>
                                                                <option value="">- Bitte wählen -</option>
                                                                @foreach($sourceTypes as $sourceType)
                                                                    <option value="{{ $sourceType->url }}">{{ $sourceType->name }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <div id="waehrung">
                                                        <label for="waehrung">Währung:</label>
                                                        <div class="waehrung-input">
                                                            <select class="form-control" name="currency" id="currency" required>
                                                                <option value="">- Bitte wählen -</option>
                                                                <option value="AUD">AUD</option>
                                                                <option value="CAD">CAD</option>
                                                                <option value="CHF">CHF</option>
                                                                <option value="CNY">CNY</option>
                                                                <option value="DKK">DKK</option>
                                                                <option value="EUR">EUR</option>
                                                                <option value="GBP">GBP</option>
                                                                <option value="HKD">HKD</option>
                                                                <option value="INR">INR</option>
                                                                <option value="JPY">JPY</option>
                                                                <option value="KRW">KRW</option>
                                                                <option value="MAD">MAD</option>
                                                                <option value="PHP">PHP</option>
                                                                <option value="SEK">SEK</option>
                                                                <option value="USD">USD</option>
                                                                <option value="ZAR">ZAR</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                                    <label for="file_logo">Excel Datei auswählen</label>
                                                    <input type="file" class="form-control-file" id="import_file" name="import_file">
                                                    <button class="btn btn-primary" type="submit" style="margin-top: 15px;">Datei hochladen</button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

                                {!! Form::close() !!}
                            @endif

                            <script type="text/javascript">
                                var filterStatus = @if(!is_null($selectedFilterStatus)) {{$selectedFilterStatus}} @else null @endif;

                                var pageParam = @if($page) {{$page}} @else null @endif;
                                var lenParam = @if($pageLength) {{$pageLength}} @else 10 @endif;
                                @if(session('auctionObjectsImportOrderColumn') && !is_null(session('auctionObjectsImportOrderColumn')))
                                    var sortcParam = {{ session('auctionObjectsImportOrderColumn') }};
                                    var sortdParam = '{{ session('auctionObjectsImportOrderDirection') }}';
                                @else
                                    var sortcParam = ($.urlParam('sortc') == null || $.urlParam('sortc') == '') ? 31 : $.urlParam('sortc');
                                    var sortdParam = ($.urlParam('sortd') == null || $.urlParam('sortd') == '') ? 'desc' : $.urlParam('sortd');
                                @endif
                                var displayStart = 0;

                                if (pageParam != null) {
                                    displayStart = (pageParam - 1) * lenParam;
                                }

                                var table = $('#data-table-auction-objects-import-all').DataTable({
                                    fixedHeader: {
                                        header: true,
                                        headerOffset: $('.page-header').outerHeight()
                                    },
                                    processing: true,
                                    serverSide: true,
                                    ordering: true,
                                    autoWidth: false,
                                    scrollY: '65vh',
                                    "sScrollX": "100%",
                                    "scrollCollapse": true,
                                    "displayStart": displayStart,
                                    "pageLength": {{ $pageLength }},
                                    "lengthMenu": [ 10, 25, 50, 100 ],
                                    "lengthChange": false,
                                    "order": [[ 23, "asc" ]],
                                    "ajax": {
                                        "url": "/ajax/ajax-auction-objects-import-all-overview",
                                        "type": "POST",
                                        "headers": {'X-CSRF-TOKEN': $('meta[name="csrf_token"]').attr('content')},
                                        "dataSrc": "data",
                                        "data": {
                                            'status': filterStatus,
                                        },
                                    },
                                    "deferRender": true,
                                    "columns": [
                                        {
                                            "data": "id",
                                            "name": "ao.id",
                                            "searchable": false,
                                            "orderable": false,
                                            className: "col-bulk",
                                            "mRender": function ( data, type, row ) {

                                                if (row.status == 0 || row.status == 1 || row.status == 2) {
                                                    return '<input class="dt-checkboxes" name="dt_checkbox[]" type="checkbox" value="'+row.id+'">';
                                                } else {
                                                    return '';
                                                }
                                            },
                                        },
                                        {
                                            "data": "status",
                                            "name": "ao.status",
                                            "mRender": function ( data, type, row ) {
                                                var status = '';

                                                if (row.status == 0 ||row.status == 1 || row.status == 2 || row.status == 5) {
                                                    status += '<select class="" name="" onchange="dynamicAssignStatus(' + row.id + ', this)" style="width: 120px;">';
                                                    status += '<option value="">- Bitte wählen -</option>';
                                                    status += '<option value="0" ' + (row.status == 0 ? 'selected' : '') + '>Neu</option>';
                                                    status += '<option value="1" ' + (row.status == 1 ? 'selected' : '') + '>Übernehmen</option>';
                                                    status += '<option value="2" ' + (row.status == 2 ? 'selected' : '') + '>Verwerfen</option>';
                                                    status += '<option value="5" ' + (row.status == 5 ? 'selected' : '') + '>Deaktiviert</option>';
                                                    status += '</select>';
                                                } else if (row.status == 3) {
                                                    status += '<i class="fa fa-check" aria-hidden="true"></i> Übernommen';
                                                } else if (row.status == 4) {
                                                    status += '<i class="fa fa-ban" aria-hidden="true"></i> Verworfen';
                                                }

                                                return status;
                                            },
                                            width: 100,
                                            "searchable": false,
                                            "orderDataType": "dom-select"
                                        },
                                        //{ "data": "lang_code", "name": "l.lang_code", "searchable": true },
                                        { "data": "auction_name", "name": "ao.auction_name", "searchable": true },
                                        { "data": "artist_firstname", "name": "ao.artist_firstname", "searchable": true },
                                        { "data": "artist_lastname", "name": "ao.artist_lastname", "searchable": true },
                                        { "data": "artist_born_loc", "name": "ao.artist_born_loc", "searchable": false },
                                        { "data": "artist_born_date", "name": "artist_born_date", "searchable": false, "orderDataType": "dom-text", "type": "date" },
                                        { "data": "artist_died_date", "name": "artist_died_date", "searchable": false, "orderDataType": "dom-text", "type": "date" },
                                        { "data": "artist_died_loc", "name": "ao.artist_died_loc", "searchable": false },
                                        { "data": "object_medium", "name": "ao.object_medium", "searchable": false },
                                        {
                                            "mRender": function ( data, type, row ) {
                                                return '<a href="'+row.object_url+'" target="_blank">'+row.object_url+'</a>';
                                            }
                                        },
                                        { "data": "auction_no", "name": "ao.auction_no", "searchable": false },
                                        { "data": "lot_no", "name": "ao.lot_no", "searchable": false },
                                        { "data": "object_title", "name": "ao.object_title", "searchable": true },
                                        { "data": "object_date_pre", "name": "ao.object_date_pre", "searchable": false },
                                        { "data": "object_date", "name": "ao.object_date", "searchable": false },
                                        { "data": "object_date_post", "name": "ao.object_date_post", "searchable": false },
                                        { "data": "object_est_from", "name": "ao.object_est_from", "searchable": false },
                                        { "data": "object_est_to", "name": "ao.object_est_to", "searchable": false },
                                        { "data": "object_est_curr", "name": "ao.object_est_curr", "searchable": false },
                                        { "data": "object_result", "name": "ao.object_result", "searchable": false },
                                        { "data": "object_result_curr", "name": "ao.object_result_curr", "searchable": false },
                                        { "data": "object_indicators", "name": "ao.object_indicators", "searchable": false },
                                        { "data": "object_height", "name": "ao.object_height", "searchable": false },
                                        { "data": "object_width", "name": "ao.object_width", "searchable": false },
                                        { "data": "object_depth", "name": "ao.object_depth", "searchable": false },
                                        { "data": "object_size_unit", "name": "ao.object_size_unit", "searchable": false },
                                        {
                                            "mRender": function ( data, type, row ) {
                                                return '<a href="'+row.object_image_url+'" target="_blank">'+row.object_image_url+'</a>';
                                            }
                                        },
                                        { "data": "auction_loc", "name": "ao.auction_loc", "searchable": false },
                                        { "data": "auction_date", "name": "auction_date", "searchable": false },
                                        { "data": "source_type", "name": "ao.source_type", "searchable": true },
                                        { "data": "object_id", "name": "ao.object_id", "searchable": false },
                                        { "data": "id", "name": "ao.id", "searchable": true, "searchable": false },
                                        { "data": "created_at", "name": "created_at", "searchable": false, "orderDataType": "dom-text", "type": "date" },
                                        { "data": "crawled_at", "name": "crawled_at", "searchable": false, "orderDataType": "dom-text", "type": "date" },
                                        { "data": "essay", "name": "ao.essay", "searchable": false },
                                        { "data": "zustand", "name": "ao.zustand", "searchable": false },
                                        { "data": "provenance", "name": "ao.provenance", "searchable": false },
                                        { "data": "exhibition", "name": "ao.exhibition", "searchable": false },
                                        { "data": "lot_detail", "name": "ao.lot_detail", "searchable": false },
                                    ],
                                    'stateSave': false,
                                    'select': 'multiple',
                                    "language": {
                                        "url": "/plugins/datatables/i18n/German.json",
                                        "processing": "<img src='/images/loading.gif'>",
                                    },
                                    "fnInitComplete": function (settings, json) {
                                        $('#filterContainer').insertAfter('#data-table-auction-objects-import-all_filter');
                                        $('#buttonLine').insertBefore('#data-table-auction-objects-import-all_filter');
                                        $('#filterContainer').show();
                                        $('#buttonLine').show();
                                    },
                                });

                                $('.table-responsive').on('scroll', function(e) {
                                    var left = $(this).scrollLeft();
                                    var left = left - 17;
                                    $('.fixedHeader-floating').css('left', -left);
                                });

                                // Bulk edit
                                $('#frm-bulk-edit').on('submit', function(e){

                                    e.preventDefault();

                                    var form = this;

                                    // Ajax request
                                    $.ajax({
                                        url: '/ajax/auction-object-import-all-bulk-edit-status',
                                        type: 'POST',
                                        beforeSend: function (xhr) {
                                            var token = $('meta[name="csrf_token"]').attr('content');

                                            if (token) {
                                                return xhr.setRequestHeader('X-CSRF-TOKEN', token);
                                            }
                                        },
                                        data: $('#frm-bulk-edit').serialize(),
                                        success:function(data){
                                            table.ajax.reload(null, false);
                                            //table.column(0).checkboxes.deselect(); // deselect all checkboxes
                                            $('#dt-check-all').prop('checked', false);
                                            $('#bulk_action').val(''); // reset select field
                                            $('.selectedRow').remove(); // remove temporary hidden fields
                                        },
                                        error:function(e){
                                            console.log(e);
                                            console.log('Ajax Error while assigning');
                                        }
                                    });
                                });

                                $(document).on('change', '#dt-check-all', function(e){

                                    if(this.checked){
                                        $('.dt-checkboxes').each(function(){
                                            this.checked = true;
                                        });
                                    }else{
                                        $('.dt-checkboxes').each(function(){
                                            this.checked = false;
                                        });
                                    }
                                });

                                var lastChecked = null;

                                $(document).on('mousedown', '.dt-checkboxes', function(e){


                                    if(!lastChecked) {
                                        lastChecked = this;
                                        return;
                                    }

                                    if(e.shiftKey) {
                                        var from = $('.dt-checkboxes').index(this);
                                        var to = $('.dt-checkboxes').index(lastChecked);

                                        var start = Math.min(from, to);
                                        var end = Math.max(from, to) + 0;

                                        $('.dt-checkboxes').slice(start, end)
                                            .filter(':not(:disabled)')
                                            //.prop('checked', lastChecked.checked).parent().parent().addClass('selected')
                                            .prop('checked', true)
                                            .parent().parent().addClass('selected');

                                        console.log(table.column(0).checkboxes.selected());
                                    }

                                    lastChecked = this;

                                    if(e.altKey){

                                        $('.dt-checkboxes')
                                            .filter(':not(:disabled)')
                                            .each(function () {
                                                var $checkbox = $(this);
                                                $checkbox.prop('checked', !$checkbox.is(':checked'));
                                            });
                                    }

                                });

                                // cut column values
                                $.fn.dataTable.render.ellipsis = function ( cutoff, wordbreak, escapeHtml ) {
                                    var esc = function ( t ) {
                                        return t
                                            .replace( /&/g, '&amp;' )
                                            .replace( /</g, '&lt;' )
                                            .replace( />/g, '&gt;' )
                                            .replace( /"/g, '&quot;' );
                                    };

                                    return function ( d, type, row ) {
                                        // Order, search and type get the original data
                                        if ( type !== 'display' ) {
                                            return d;
                                        }

                                        if ( typeof d !== 'number' && typeof d !== 'string' ) {
                                            return d;
                                        }

                                        d = d.toString(); // cast numbers

                                        if ( d.length < cutoff ) {
                                            return d;
                                        }

                                        var shortened = d.substr(0, cutoff-1);

                                        // Find the last white space character in the string
                                        if ( wordbreak ) {
                                            shortened = shortened.replace(/\s([^\s]*)$/, '');
                                        }

                                        // Protect against uncontrolled HTML input
                                        if ( escapeHtml ) {
                                            shortened = esc( shortened );
                                        }

                                        return '<span class="ellipsis" title="'+esc(d)+'">'+shortened+'&#8230;</span>';
                                    };
                                };

                                // assign status
                                function dynamicAssignStatus(id, selectObject) {

                                    var auctionObjectStageId = id;
                                    var status = selectObject.value;

                                    // Ajax request
                                    $.ajax({
                                        url: '/ajax/post-ajax-auction-object-import-all-assignment-status',
                                        type: 'POST',
                                        beforeSend: function (xhr) {
                                            var token = $('meta[name="csrf_token"]').attr('content');

                                            if (token) {
                                                return xhr.setRequestHeader('X-CSRF-TOKEN', token);
                                            }
                                        },
                                        data: {
                                            auction_object_id : auctionObjectStageId,
                                            status : status
                                        },
                                        success:function(data){
                                            table.ajax.reload(null, false);
                                        },error:function(e){
                                            console.log(e);
                                            console.log('Ajax Error while assigning');
                                        }
                                    });
                                }

                                $(document).on('change', '.dt-checkboxes-select-all input', function(e){

                                    if ($(this).prop('checked')) {
                                        $('.dt-checkboxes').parent().parent().addClass('selected');
                                    } else {
                                        $('.dt-checkboxes').parent().parent().removeClass('selected');
                                    }
                                });

                                $(document).on('change', '.dt-checkboxes', function(e){

                                    if ($(this).prop('checked')) {
                                        $(this).parent().parent().addClass('selected');
                                    } else {
                                        $(this).parent().parent().removeClass('selected');
                                    }
                                });

                                $(document).on('click', '#btnStartTransferProcess', function(e){

                                    $('#transferProcessForm').submit();
                                });

                                if($.urlParam('ps') == 1) {

                                    $('#btnStartTransferProcess').prop("disabled",true);
                                    $('#btnStartTransferProcess .button-text').hide();
                                    $('#btnStartTransferProcess .message-running-service').show();

                                    setTimeout(function(){
                                        $('#btnStartTransferProcess .button-text').show();
                                        $('#btnStartTransferProcess .message-running-service').hide();
                                        $('#btnStartTransferProcess').prop("disabled",false);
                                    }, 5000);
                                }


                            </script>

                        </div>
                    </div>
                </div>


            </div>
        </div>
    </div>

@stop