//pdf,print,export datatable
let jqry = $.noConflict();
jqry(document).ready(function () {
    "use strict";

    //use for every report view
    let today = new Date();
    let dd = today.getDate();
    let mm = today.getMonth() + 1; //January is 0!
    let yyyy = today.getFullYear();

    if (dd < 10) {
        dd = "0" + dd;
    }

    if (mm < 10) {
        mm = "0" + mm;
    }
    today = yyyy + "-" + mm + "-" + dd;

    //get title and datatable id name from hidden input filed that is before in the table in view page for every datatable
    let datatable_name = $(".datatable_name").attr("data-id_name");
    let title = $(".datatable_name").attr("data-title");
    let TITLE = title + ", " + today;
    document.title = title;

    jqry(`#${datatable_name},#datatable2`).DataTable({
        autoWidth: false,
        ordering: false,
        paging:false,
        dom: '<"top-left-item col-sm-12 col-md-6"lf> <"top-right-item col-sm-12 col-md-6"B> t <"bottom-left-item col-sm-12 col-md-6 "i><"bottom-right-item col-sm-12 col-md-6 "p>',
        buttons: [
            {
                extend: "print",
                text: '<i class="fa fa-print"></i> Print',
                titleAttr: "print",
            },
            {
                extend: "copyHtml5",
                text: '<i class="fa fa-files-o"></i> Copy',
                titleAttr: "Copy",
            },
            {
                extend: "excelHtml5",
                text: '<i class="fa fa-file-excel-o"></i> Excel',
                titleAttr: "Excel",
                customize: function ( xlsx ) {
                    var sheet = xlsx.xl.worksheets['sheet1.xml'];
                   // $('row c[r*="3"]', sheet).attr( 's', '2' );
                    //$('row:eq(6) c', sheet).attr( 's', '2');
                    //$('row:eq(7) c', sheet).attr( 's', '2');
                    //$('row:eq(8) c', sheet).attr( 's', '2');
                    //$('row:eq(9) c', sheet).attr( 's', '2');
                }
            },
            {
                extend: "csvHtml5",
                text: '<i class="fa fa-file-text-o"></i> CSV',
                titleAttr: "CSV",
            },
            {
                extend: "pdfHtml5",
                text: '<i class="fa fa-file-pdf-o"></i> PDF',
                titleAttr: "PDF",
            },
        ],
        language: {
            paginate: {
                previous: "<i class='fa fa-chevron-left'></i>",
                next: "<i class='fa fa-chevron-right'></i>",
            },
        },

    });
});
