/* -------------------------------------------------------------------------- *

 * Datum Heute im Format YYYY-MM-DD

 * -------------------------------------------------------------------------- */

var today = new Date().toISOString().slice(0,10); //alert(today);

​

​

​

​

​

​

/* -------------------------------------------------------------------------- *

 * .dataTable - TABLES                                               defaults

 *  datatables.net/reference/option/

 * -------------------------------------------------------------------------- */

/* Temporär *///$.fn.dataTable.ext.errMode = 'none';

$.extend( true, $.fn.dataTable.defaults, 

{

  dom:           'B f <"myGroup"i p l> r t',  /* datatables.net/reference/option/dom */

  order:          [],                         /* Sort OnLoad zB. [[ 3, 'asc' ]] */

  stateSave:      false,                      /* datatables.net/reference/option/stateSave */

  colReorder:     false,                      /* datatables.net/extensions/colreorder/ */

  autoWidth:      false,                      /* Auto Column Witdh */

  select:         true,                       /* datatables.net/reference/option/select */

  mark:           true,                       /* (plug-in) github.com/julmot/datatables.mark.js/ */

  deferRender:    true,                       /* datatables.net/examples/ajax/defer_render */

  serverSide:     false,        

  processing:     true,

  buttons:        [],                         /* setze diese immer beim jeweiligen Table */

  stripeClasses:  [],                         /* Empty Array verhindert odd/even Class */

  paging:         true,

  pagingType:    'full',                      /* simple full simple_numbers (default) full_numbers */

  pageLength:     10,                         /* Default Anzeige */

  lengthMenu:     [[1, 5, 10, 50, 100, 500], 

                   [1, 5, 10, 50, 100, 500]], /* 'alle' nicht Live verwenden, dauert zu lange */

  language: {

    decimal:           ",",

    thousands:         ".",    

    emptyTable:        "... No Data ...",

    info:              "_START_ - _END_ / _TOTAL_",

    infoEmpty:         "0 - 0 / 0",

    infoFiltered:      "(_MAX_)",

    infoPostFix:        "",

    infoThousands:        ".",

    lengthMenu:        "_MENU_",

    loadingRecords:    "... Wird geladen ...",

    processing:        "... Bitte warten ...",

    search:            "",

    searchPlaceholder: "...",

    zeroRecords:       "... Keine Daten gefunden ...",

    paginate: {

      first:    "<i class='fas | fa-angle-double-left'></i>",

      previous: "<i class='fas | fa-angle-left'></i>",

      next:     "<i class='fas | fa-angle-right'></i>",

      last:     "<i class='fas | fa-angle-double-right'></i>",

    }, /* paginate */

    buttons: {

      print:      "Drucken",

      colvis:     "Spalten",

      copy:       "Kopieren",

      copyTitle:  "Copy & Paste",

      copyKeys:   "Taste <i>ctrl</i> oder <i>\u2318</i> + <i>C</i> um Tabelle<br>in Zwischenspeicher zu kopieren.<br><br>Um abzubrechen die Nachricht anklicken oder Escape drücken.",

      copySuccess: {

        "_": "%d Zeilen in <b>Zwischenablage</b> kopiert.<br>Weitere Infos zu <a target='_blank' href='https://de.wikipedia.org/wiki/Kopieren_und_Einfügen'>Copy & Paste</a>.",

        "1": " 1 Zeile  in <b>Zwischenablage</b> kopiert.<br>Weitere Infos zu <a target='_blank' href='https://de.wikipedia.org/wiki/Kopieren_und_Einfügen'>Copy & Paste</a>."

      },

    }, /* buttons */

    select: {

      rows: {

        "_": "%d Zeilen",

        "0": "",

        "1": "1 Zeile"

      },

    }, /* selects */    

  }, /* language */

​

​

  initComplete: function (settings, json) 

  {

    /* ------------------------------------------------------ *

     * (iC) - Responsive Table                         tables

     * ------------------------------------------------------ */        

     //$('table.editorTable').wrap('<div class="b-scrollbox-x"></div>');

​

​

    /* ------------------------------------------------------ *

     * (iC) - DoubleClick Suchfeld Reset               tables

     * ------------------------------------------------------ */        

     $('input[type="search"]').on('dblclick', function() { $('input[type="search"]').val('').keyup(); });

​

​

    /* ------------------------------------------------------ *

     * (iC) - ColSearch                                tables

     * ------------------------------------------------------ */        

     $('table.editorTable tfoot.group2head tr').appendTo('table.editorTable thead'); /* ColSearch tfoot nach oben */

​

     this.api().columns().every( function() 

     { // datatables.net/examples/api/multi_filter

       var column = this;

       if ($(column.footer()).hasClass('colSearch')) { /* Suche bei Eingabe */ var that = this; $('input[type="search"]', this.footer()).on('keyup change', function() { that.search(this.value).draw(); }); } /* colSearch */

     }); /* this.api().columns().every() */

​

​

    /* ------------------------------------------------------ *

     * (iC) - DoubleClick Zelle 'Inline Edit'          editor

     * ------------------------------------------------------ */

     $('table.editorTable').on('dblclick', 'tbody td:not(:first-child)', function (e) { editor.inline( this, { onBlur: 'submit' }); });

​

​

    /* ------------------------------------------------------ *

     * (iC) - Table Row-Buttons                        editor

     * ------------------------------------------------------ */ 

     // Row Button 'bearbeiten'

     $('table.editorTable').on('click', '.editor_edit', function (e) { e.preventDefault();

        editor

            .title('Eintrag bearbeiten')

            .buttons({ 'label': 'Update', 'fn': function () { editor.submit(); } })

            .edit( $(this).closest('tr') );

     }); /* editor_edit */

     // Row Button 'löschen'

     $('table.editorTable').on('click', '.editor_remove', function (e) { e.preventDefault();

        editor

            .title('Eintrag löschen')

            .message('Diesen Eintrag löschen?')

            .buttons({ 'label': 'Löschen', 'fn': function () { editor.submit(); } })

            .remove( $(this).closest('tr') );

     }); /* editor_remove */

  } /* initComplete (iC) */

}); /* $.extend.defaults.dataTable */

​

​

​

​

​

/* -------------------------------------------------------------------------- *

 * .dataTable - EDITOR                                               defaults

 * editor.datatables.net/reference/option/

 * -------------------------------------------------------------------------- */

//@codekit-prepend "datatables/dt-extensions/editor/1.9.6/js/dataTables.editor.js";

var editor;

​

$.extend( true, $.fn.dataTable.Editor.defaults, {  

    display: 'lightbox', /* lightbox / envelope */

​

  // Language

  // https://editor.datatables.net/manual/i18n

  i18n: {

  datetime: {

    previous: 'Zurück',

    next:     'Weiter',

    months:   [ 'Jänner', 'Februar', 'März', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Dezember' ],

    weekdays: [ 'So', 'Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa' ]

    },

​

    error:  { system: 'Ein Fehler ist aufgetreten. (<a target=\"_blank\" href=\"//datatables.net/tn/12\">More</a>)' },    

    create: { button: 'Neu',        title: 'Neuer Eintrag',      submit: 'Ok' },

    edit:   { button: 'Bearbeiten', title: 'Eintrag bearbeiten', submit: 'Update' },

    remove: { button: 'Löschen',    title: 'Eintrag löschen',    submit: 'Löschen', confirm: 'Einträge (%d) löschen' },

    multi:  {

      title:   'Mehrfach Bearbeitung',

      info:    'Die ausgewählten Felder enthalten unterschiedliche Werte. Klicken Sie hier, um alle Elemente für dieses Feld zu bearbeiten und auf denselben Wert zu setzen.',

      restore: 'Änderungen abbrechen'

    }, /* multi */

  }, /* i18n */

}); /* $.extend.defaults.Editor */

​

​

​

​

​

​

​

​

​

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

            /* -------------------------------------------------------------------------- *

    .dataTable                                                   [ thisEditor ]

     defaults => datatables-editor.js

   * -------------------------------------------------------------------------- */

            editor = new $.fn.dataTable.Editor({

                ajax: "http://10.0.0.4/set-pepples/set-golf20/-admin/editor-alle_zzzz-ssp.php",

                table: "table.editorTable",

                //template: '.customForm',  /* https://editor.datatables.net/manual/templates */

                fields: [

                    // Site

                    {

                        name: "alle_zzzz.webx_idn",

                        label: "Site",

                        type: "select",

                        options: [

                            { label: "-", value: "" },

                            { label: "%", value: "%" },

                            { label: "boehmerwaldgolf.at", value: "boehmerwaldgolf.at" },

                            { label: "gclinz.at", value: "gclinz.at" },

                        ],

                    },

​

                    // Status

                    {

                        name: "alle_zzzz.zzzz_sta",

                        label: "Status",

                        type: "select",

                        options: [

                            { label: "online", value: "" },

                            { label: "offline", value: "offline" },

                            { label: "locked", value: "locked" },

                        ],

                    },

​

                    // Datum (datetime)

                    { name: "alle_zzzz.zzzz_dto", label: "Datum", type: "datetime", format: "DD/MM/YYYY - HH:mm" /* Formate siehe zzzz-ssp Template */, opts: { showWeekNumber: true } },

​

                    // Titel

                    { name: "alle_zzzz.zzzz_tit", label: "Titel", type: "text" },

​

                    // Upload (beta)

                    {

                        name: "users_images.imageId",

                        label: "Upload:",

                        type: "upload",

                        display: function (id) {

                            return '<img src="' + editor.file("images", id).webPath + '"/>';

                        },

                        noImageText: "No image",

                    },

                ],

            }); /* fn.dataTable.Editor */

​

            /* -------------------------------------------------------------------------- *

    .dataTable                                                   [ thisTables ]

     defaults => app-datatables-tables-defaults.js

   * -------------------------------------------------------------------------- */

            var thisDataTable = $("table.editorTable").DataTable({

                ajax: {

                    url: "http://10.0.0.4/set-pepples/set-golf20/-admin/editor-alle_zzzz-ssp.php",

                    type: "POST",

                    data: {

                        webx_idn: "gclinz.at",

                    },

                },

                order: [[1, "desc"]] /* default (idn) wenn nicht stateSave */,

                pageLength: 5,

                stateSave: true,

                colReorder: true,

                //language:  { url: '-min/datatables-german.json' }, /* in defaults.js - hier individuelles File möglich. Muss dann unter der Domain verfügbar sein */

​

                columns: [

                    // Spalten (1) index / (2) idn / (3) trash / (4) edit

                    { className: "th-idex", data: null, defaultContent: "" /* indexRow content by CSS */ },

                    { className: "th-idnx", data: "alle_zzzz.zzzz_idn" },

                    { className: "th-icon", data: null, defaultContent: '<a class="editor_remove" title="Eintrag entfernen"><i class="far | fa-trash-alt"></i></a>' },

                    { className: "th-icon", data: null, defaultContent: '<a class="editor_edit" title="Eintrag bearbeiten (Lightbox)"><i class="fas | fa-edit"></i></a>' },

​

                    // Upload

                    {

                        data: "image",

                        className: "-text-center",

                        render: function (file_id) {

                            return file_id;

                            //return file_id ? '<img src="'+editor.file('files', file_id ).web_path+'"/>' : null;

                        },

                        defaultContent: '<i class="fas | fa-image"></i>',

                    },

​

                    // Titel

                    {

                        data: null,

                        render: function (data, type, row) {

                            return '<b class="-text-italic">' + data.alle_zzzz.zzzz_tit + "</b> <br>" + data.alle_zzzz.webx_idn;

                        },

                        editField: "alle_zzzz.zzzz_tit",

                    },

​

                    // Text

                    { data: "alle_zzzz.zzzz_txt" },

​

                    // Status

                    {

                        data: null,

                        className: "-text-center",

                        render: function (data, type, row) {

                            var output = null;

                            if (data.alle_zzzz.zzzz_sta === "offline") {

                                output = '<i class="fas | fa-toggle-off"></i><br>' + data.alle_zzzz.zzzz_sta;

                            } else {

                                output = '<i class="fas | fa-toggle-on"></i><br>' + data.alle_zzzz.zzzz_sta;

                            }

                            return output;

                        },

                        editField: "alle_zzzz.zzzz_sta",

                    },

​

                    // Datum (datetime)

                    { data: "alle_zzzz.zzzz_dto", className: "th-date" },

​

                    // Datum Update

                    {

                        data: null,

                        className: "th-date",

                        render: function (data, type, row) {

                            var output = data.alle_zzzz.zzzz_upd.replace(" - ", "<br>"); /* Zeilenumbruch vor Uhrzeit */

                            if (data.alle_zzzz.zzzz_upd.includes("0001")) {

                                output = "";

                            } /* kein Datum mysql(000-00-00 00:00:00) kommt von ssp als '30/11/-0001 - 00:00' zurück */

                            return output;

                        },

                    },

​

                    // webx_idn

                    { data: "alle_zzzz.webx_idn" },

                ],

​

                // tableRow AddClass

                createdRow: function (row, data, dataIndex) {

                    $(row).addClass(data.alle_zzzz.zzzz_sta.toLowerCase()); // Status (zB. offline)

                    //if(data.alle_zzzz.zzzz_sta.indexOf("Kat") !== -1) { $(row).addClass('-testcol ' + dataIndex); } // contains string

                },

​

                // columnDefs

                columnDefs: [

                    //  Zeige alle Cols grundsätzlich an. Kann sich der Admin per ColVis und stateSave(true) selbst einstellen

                    //{ visible: false, targets: [ 3,4 ] } /* Diese Cols onLoad nicht anzeigen (start bei 0), stateSave abhängig

                ],

​

                /* ------------------------------------------------------ *

                 * Buttons                (hier thisDataTable definieren)

                 * ------------------------------------------------------ */

                /* -------------------------------------------------------------------------- *

                 * _datatables-editor-buttons.js - (!) File nicht per Codekit compilieren.

                 * -------------------------------------------------------------------------- */

                buttons: [

                    // Button Toggle Section Breite

                    //{ text:      '<i class="fas | fa-expand"></i>',

                    //  titleAttr: 'Tabelle maximieren',

                    //  action:     function () { $('.secDashboard').toggleClass('secPepplesFullWidth'); }

                    //},

​

                    // Button Hilfe - öffnet Modal

                    {

                        text: '<i class="fas | fa-info-circle"></i>',

                        titleAttr: "Hilfe",

                        action: function () {

                            $("#reveal-dttipps").foundation("open");

                        },

                    },

​

                    // Button Table - state.clear()

                    {

                        text: '<i class="fas | fa-recycle"></i>',

                        titleAttr: "Tabelle Reset",

                        action: function () {

                            thisDataTable.state.clear();

                            window.location.reload();

                            alert("Recycle Tabelle. Alle Tabellen Filter zurücksetzen.");

                        },

                    },

​

                    // Button Table - 'ColVis' - datatables.net/reference/button/colvis

                    {

                        extend: "colvis",

                        text: '<i class="fas | fa-columns"></i>',

                        titleAttr: "Spalten ein/ausblenden",

                        className: "-subs-text-left" /* eigene Class */,

                        columns: ":not(.noColVis)" /* siehe th class */,

                        background: false,

                        autoClose: false,

                    },

​

                    // Button Table - 'Print'

                    { extend: "print", text: '<i class="fas | fa-print"></i>', titleAttr: "Drucken", autoPrint: true },

​

                    // Button Table - 'Export' Collection - datatables.net/extensions/buttons/built-in

                    {

                        extend: "collection",

                        text: '<i class="fas | fa-download"></i>',

                        titleAttr: "Download",

                        className: "-subs-text-left" /* eigene Class */,

                        background: false,

                        autoClose: true,

                        buttons: [

                            { extend: "copyHtml5", text: '<i class="far | fa-fw | fa-files"></i>      Auswahl <b>kopieren </b>' },

                            { extend: "csvHtml5", text: '<i class="far | fa-fw | fa-file-alt"></i>   Auswahl <b>Export CSV</b>' },

                            //{ extend: 'excelHtml5', text: '<i class="far | fa-fw | fa-file-excel"></i> Auswahl <b>Export Excel</b>' },

                            //{ extend: 'pdfHtml5',   text: '<i class="far | fa-fw | fa-file-pdf"></i>   Auswahl <b>Export PDF</b>' },

                        ],

                    },

​

                    // Button Editor - 'Edit' / 'Delete' / 'Neu' (float: right)

                    { extend: "remove", text: '<i class="far | fa-trash-alt"></i><abbr>Löschen</abbr>', titleAttr: "Löschen", className: "-float-right", editor: editor },

                    { extend: "edit", text: '<i class="fas | fa-edit"></i><abbr>Bearbeiten</abbr>', titleAttr: "Bearbeiten", className: "-float-right", editor: editor },

                    { extend: "create", text: '<i class="fas | fa-plus-square"></i><abbr>Neu</abbr>', titleAttr: "Neu hinzufügen", className: "-float-right -text-bold", editor: editor },

                ] /* buttons */,

            }); // thisDataTable

        }); // $(document).ready