var DataRemit = [];
var DataFailure = [];

function PrepareDataRe(){
    console.log('PrepareDataRe');
    var $blok, $d1, $d2;
    $blok = window.ReOkruh;

    var foo = $("#dateFrom").dxDateBox('instance');
    var d1 = new Date ( foo.option('value') );    

    var foo = $("#dateTo").dxDateBox('instance');
    var d2 = new Date ( foo.option('value') );    
		        
	var $Datum1 = (d1.getDate()+'.'+(d1.getMonth()+1)+'.'+d1.getFullYear());
	var $Datum2 = (d2.getDate()+'.'+(d2.getMonth()+1)+'.'+d2.getFullYear());

    var foo = $("#filterCheck").dxCheckBox('instance');
    var $check = ( foo.option('value') );       

    console.log("AjaxRe.php?blok="+$blok+"&t1="+$Datum1+"&t2="+$Datum2+' '+$check);

    $.ajax({
        url:  "AjaxRe.php?blok="+$blok+"&t1="+$Datum1+"&t2="+$Datum2+"&check="+$check,
        dataType: "script",
        success: function(result) { 
            console.log('PrepareDataRe');
            $("#gridRemit").dxDataGrid({ dataSource: DataRemit });

            $.ajax({
                url:  "AjaxFailure.php?blok="+$blok+"&t1="+$Datum1+"&t2="+$Datum2,
                dataType: "script",
                success: function(result) { 
                    $("#gridFailure").dxDataGrid({ dataSource: DataFailure });
                }
            });                                                                

        }
    });    
    
}

function RePrepareSel() {

    console.log('Prepare Sel Re');

    var now = new Date();

    $("#dateFrom").dxDateBox({
        type: "date",
        displayFormat: "dd.MM.yyyy",
        value: now - (60*60*1000*24*30),
        onValueChanged: function(data) {
            PrepareDataRe();
        }
    });

    $("#dateTo").dxDateBox({
        type: "date",
        displayFormat: "dd.MM.yyyy",
        value: now,
        onValueChanged: function(data) {
            PrepareDataRe();
        }
    });
    PrepareDataRe();
}

function ReRange() {
    var $d1 = new Date("2024/03/30");
    var $d2 = new Date("2024/04/30");    

    $("#date-selector-re").dxRangeSelector({
        title: "interval",
        selectedRangeColor:"#2196F3",		  
        margin: { top: 10 },
        size: { height: 180 },
        scale: {
			valueType: 'datetime',
            startValue: new Date(2021, 0, 1),
            endValue: new Date(2025, 1, 1),
            minorTickInterval: "day",
            tickInterval: { day: 1 },
            minRange: "day",
            maxRange: "quarter",
            minorTick: { visible: false }
        },
        sliderMarker: { format: "monthAndDay", color: "#1565C0" },
        value: [$d1, $d2],
        onValueChanged: function (data) { RePrepareSel(); }	  
	});

    console.log('2021, 04, 29 2025, 04, 29');
}


function PrepareFormRe() {
    DevExpress.localization.locale('cs');
    DevExpress.config({ editorStylingMode: "filled" });
    var okruhy = ['TG4','TG5','TG7'];    
    window.ReOkruh = okruhy[0];

    $("#filterCheck").dxCheckBox({
        value: false,
        onValueChanged: function(data) {
            PrepareDataRe();
        }        
    });

    $("#gridRemit").dxDataGrid({
            dataSource: DataRemit,
            columnAutoWidth: false,
            loadPanel: { enabled: true },
            searchPanel: { visible: false, width: 200, placeholder: "Hledat... / Search ..." },
            allowColumnReordering: true,
            allowColumnResizing: true,
            rowAlternationEnabled: true,
            showBorders: true,      
            headerFilter: { visible: true },              
            selection: {  mode: "single" },
            hoverStateEnabled: true,
            scrolling: {  mode: "virtual" },
            onCellPrepared: function(e) {
                        if (e.rowType == 'data' ) { 
                            if ( (e.key["POZNAMKA"]!=='') && ( (e.column.dataField === 'EIC') || (e.column.dataField === 'REASON_CODE') || (e.column.dataField === 'POZNAMKA') || (e.column.dataField === 'OKRUH') ) ) { 
                               e.cellElement.css("background-color", "#0288D1"); 
                               e.cellElement.css("color", "#FFFFFF");
                            }
                        }
                    },   
            onToolbarPreparing: function(e) {
                var dataGrid = e.component;
                e.toolbarOptions.items.unshift({
                    location: "before",
                    widget: "dxButton",
				    type: "danger",
                    options: {
                        icon: "clearformat",					
				        type: "danger",
					    hint: "Zrušit filtrační podmínky ... / Clear filter ...",
                        onClick: function() {
                            DevExpress.ui.notify("ruším filtrační podmínky ...","info",500);
                            var dataGrid = $('#gridRemit').dxDataGrid('instance');
						    dataGrid.clearFilter();	
						    dataGrid.clearSorting();
                            }
                        }
            		},
                    {
                        location: "before",
                        widget: "dxSelectBox",				
                        options: {
					    items: okruhy,
					    width: 80,
					    acceptCustomValue: false,
					    value: okruhy[0],
                        onValueChanged: function(data) {                           
                            var selectedValue = data.value; 
                            window.ReOkruh = selectedValue;
                            PrepareDataRe();
                            }
      			        }
		     	    }                     
                     )
                    },	        
                    "export": {
                        enabled: true,
                        fileName: "Remit",
                        allowExportSelectedData: false,
                        hint: "Exportovat data z tabulky"
                    },
                    columnChooser: { enabled: true },
                        columns: [
                            {dataField:"OKRUH",caption:"okruh",width:55,fixed:true},                            
                            {dataField:"DATUM",caption:"datum",width:85,dataType: "date", format: "dd.MM.yyyy",allowFiltering: false },
                            {dataField:"EIC",caption:"EIC",visible:true, width:125,alignment: "center"},
                            {dataField:"REASON_CODE", caption:"KOD",visible:true, width:75,alignment: "center"},                            
                            {dataField:"POZNAMKA",caption:"poznámka",width:155},
                            {dataField:"PLAN",caption:"plánováno",width:75,alignment: "center",visible:false},                                                        
                            {dataField:"AVAILABLE_CAPACITY",caption:"dostupná kapacita",width:75,alignment: "center",visible:false},                            
                            {dataField:"KAPACITA",caption:"kapacita",width:75,alignment: "center",visible:true},                            
                        {dataField:"H0",caption:"0-1",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H1",caption:"1-2",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H2",caption:"2-3",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H3",caption:"3-4",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H4",caption:"4-5",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H5",caption:"5-6",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H6",caption:"6-7",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H7",caption:"7-8",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H8",caption:"8-9",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H9",caption:"9-10",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H10",caption:"10-11",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H11",caption:"11-12",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H12",caption:"12-13",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H13",caption:"13-14",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H14",caption:"14-15",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H15",caption:"15-16",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H16",caption:"16-17",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H17",caption:"17-18",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H18",caption:"18-19",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H19",caption:"19-20",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H20",caption:"20-21",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H21",caption:"21-22",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H22",caption:"22-23",width:52,alignment: "right",allowFiltering: false,dataType: "number"},{dataField:"H23",caption:"23-24",width:52,alignment: "right",allowFiltering: false,dataType: "number"}                        ]
                    });    

        $("#gridFailure").dxDataGrid({
            dataSource: DataFailure,
            columnAutoWidth: false,
            loadPanel: { enabled: true },
            searchPanel: { visible: false, width: 200, placeholder: "Hledat... / Search ..." },
            allowColumnReordering: true,
            allowColumnResizing: true,
            rowAlternationEnabled: true,
            showBorders: true,      
            headerFilter: { visible: true },              
            selection: {  mode: "single" },
            hoverStateEnabled: true,
            scrolling: {  mode: "virtual" },
            columnChooser: { enabled: true },
            "export": {
                        enabled: true,
                        fileName: "Remit-Failure",
                        allowExportSelectedData: false,
                        hint: "Exportovat data z tabulky"
            },            
            onToolbarPreparing: function(e) {
                var dataGrid = e.component;
                e.toolbarOptions.items.unshift({
                    location: "before",
                    widget: "dxButton",
				    type: "danger",
                    options: {
                        icon: "clearformat",					
				        type: "danger",
					    hint: "Zrušit filtrační podmínky ... / Clear filter ...",
                        onClick: function() {
                            DevExpress.ui.notify("ruším filtrační podmínky ...","info",500);
                            var dataGrid = $('#gridFailure').dxDataGrid('instance');
						    dataGrid.clearFilter();	
						    dataGrid.clearSorting();
                            }
                        }
            		})
            } 
        });
        /* PrepareDataRe(); **/
}


function ReFrm() {
    PrepareFormRe(); 
    RePrepareSel();            
};