DevExpress.config({ editorStylingMode: "filled" });
var kot = ["dohromady", "B4", "B5", "B7"];
var kotle = [{"name":"B4"}, {"name":"B5"}, {"name":"B7"}];
var footer = ["průměr","minimum","maximum","suma"];
var footer2 = ["minimum","maximum","suma"];
var cas = ["měsíc", "3 měsíce", "rok", "vše"];
var typAV = ["vzorkovač pro K4", "vzorkovač pro K5", "vzorkovač pro K7"];
var SILO = ["SF4 - V14", "SF5 - V15", "SF7 - V17", "LP - V2"];
window.ShowChart60 = 0;
window.ShowChart15 = 0;
window.VLDateFrom = "*";
window.VLDateTo = "*";
window.DateFrom60 = "*";
window.DateTo60 = "*";
window.DateFrom15 = "*";
window.DateTo15 = "*";
window.JidelnicekMisto = 1;
window.SILODateFrom = "*";
function LoadFrm($data) {
console.log('LoadFrm: '+$data);
if ($data=='El-60') { ElFrm();}
else if ($data=='El-15') { El15Frm(); }
else if ($data=='Gas') { GasFrm(); }
else if ($data=='GasGrid') { GasGridFrm(); }
else if ($data=='ElDiagramFrm') { ElDiagramFrm(); }
else if ($data=='HomeTemperature') { TemperatureFrm(); }
else if ($data=='HomePressure') { PressureFrm(); }
else if ($data=='Lab') { AVFrm(); }
else if ($data=='Lab-VP') { VPFrm(); }
else if ($data=='Lab-NE') { NEFrm(); }
else if ($data=='Lab-CH') { CHFrm(); }
else if ($data=='Contacts') { ContactFrm(); }
else if ($data=='KatalogKKS') { SignalyKKSFrm(); }
else if ($data=='Jid-LOG') { JidLogFrm(); }
else if ($data=='Jid-SOUHRN') { JidStatFrm(); }
else if ($data=='Jid-JIDELNICEK') { JidJidelnicekFrm(); }
else if ($data=='Jid-SEZNAM') { JidSeznamFrm(); }
else if ($data=='Jid-OBJ') { JidObjednatFrm(); ObjednatReadData(); }
else if ($data=='Papers') { VLFrm(); }
else if ($data=='Papers-Pivot') { VLPivotFrm(); }
else if ($data=='Remit') { ReFrm(); }
else if ($data=='Coal') { CoalFrm(); }
else if ($data=='Temperature') { TemperatureFrm(); }
else if ($data=='Temperature-Day') { TemperatureDayFrm(); }
else if ($data=='Pressure') { PressureFrm(); }
else if ($data=='Pressure-Day') { PressureDayFrm(); }
else if ($data=='SILO') { SILOFrm(); }
else if ($data=='HomeHelp') { }
else if ($data=='HomeFiles') { }
else if ($data=='Data-KKS-min') { DataKKSminFrm(); }
else if ($data=='Data-KKS-Drevosrot') { DrevosrotFrm();}
else { HomeFrm(); }
}
function prepareMenuListener() {
var $MainMenu = document.querySelector('#MainMenu');
console.log('prepareMenuListener');
$MainMenu.addEventListener('click', function(e){
if(e.target != e.currentTarget){
e.preventDefault();
var $data = e.target.getAttribute('data-name'),
url = "/login/?p="+$data;
history.pushState($data, null, url);
document.title = "Teplárna Kladno | " + $data;
console.log($data);
LoadFrm($data);
}
e.stopPropagation();
}, false);
}
/* id: -1 */ var dateList = ["5/2024","4/2024","3/2024","2/2024","1/2024","12/2023","11/2023","10/2023","9/2023","8/2023","7/2023","6/2023"];
var yearList = ["2024","2023","2022","2021","2020","2019","2018","2017","2016","2015","2014","2013"];
var $loader ='
").text(data.FakturaName);
},
onSelectionChanged: function(data) {
/* console.log(data); */
if (!data.addedItems[0]) {return;}
console.log(data.addedItems[0].FakturaCislo);
LoadDataTemp(data.addedItems[0].FakturaCislo);
}
});
var DataTemp = [];
$("#GridTemperature").dxDataGrid({
dataSource: DataTemp,
allowColumnResizing: true,
rowAlternationEnabled: false,
allowColumnReordering: true,
columnResizingMode: "widget",
showBorders: true,
showRowLines: true,
columnFixing: { enabled: true },
filterRow: { visible: false, applyFilter: "auto" },
headerFilter: { visible: true },
sorting: { mode: "multiple" },
scrolling: { mode: "virtual" },
selection: { mode: "single" },
sorting: { mode: "multiple" },
hoverStateEnabled: true,
columnChooser: { enabled: true },
"export": { enabled: true, fileName: "Temperature" },
searchPanel: { visible: true, width: 240, placeholder: "Hledej..." },
onToolbarPreparing: function(e) {
var dataGrid = e.component;
e.toolbarOptions.items.unshift({
location: "before",
widget: "dxButton",
type: "danger",
options: {
icon: "fas fa-angle-double-down",
type: "danger",
hint: "Zrušit filtrační podmínky ...",
onClick: function() {
DevExpress.ui.notify("ruším filtrační podmínky ...","info",500);
var dataGrid = $('#GridTemperature').dxDataGrid('instance');
dataGrid.clearFilter();
dataGrid.clearSorting();
}
}
})
},
columns:
[
{ dataField: "FakturaCislo", caption: "fakturace", width: 70, visible: true },
{ dataField: "OMisto", caption: "odběrné místo", width: 160, visible: true },
{ dataField: "Name", caption: "jméno", visible: true },
{ dataField: "OD", caption: "počáteční stav", width: 95, dataType: "number", visible: true },
{
dataField: "DO",
caption: "koncový stav",
width: 95,
dataType: "number",
visible: true
},
{
dataField: "MNOZSTVI",
caption: "množství",
width: 85,
dataType: "number",
cssClass: 'red-1',
visible: true
},
{
dataField: "jednotka",
width: 65,
visible: true,
cssClass: 'blue-1'
},
{
dataField: "KONSTANTA",
caption: "konstanta",
width: 65,
dataType: "number",
visible: true,
cssClass: 'blue-2'
},
{
dataField: "OdbMistoId",
caption: "odb. misto ID",
width: 65,
dataType: "number",
visible: false,
cssClass: 'silver-2'
},
{
dataField: "Object_Index",
caption: "Object_Index",
width: 65,
dataType: "number",
visible: false,
cssClass: 'silver-2'
}
],
summary: {
totalItems: [
{
column: "OMisto",
summaryType: "count",
displayFormat: "{0}"
},
{
column: "MNOZSTVI",
summaryType: "sum",
displayFormat: "{0}"
}
]
}
});
} // sucess
});
}
function TemperatureFrm() {
window.GetDate = 0;
$.ajax({
url: "frm-temperature.php",
dataType : "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
PrepareFormTemperature();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Teplo v páře';
prepareMenuListener();
}
}); // ajax end
};
window.DataDayTemp = '60043';
function LoadDataDayTemp() {
window.GetDate = 0;
var loadPanelDayTemp = $("#LoadPanelDayTemp").dxLoadPanel({
shadingColor: "rgba(0,0,0,0)",
position: { of: "#GridDayTemperature" },
visible: false,
showIndicator: true,
showPane: true,
shading: true,
closeOnOutsideClick: false,
onShown: function(){ },
onHidden: function(){ }
}).dxLoadPanel("instance");
loadPanelDayTemp.show();
var dateFrom = $("#TempDateFrom").dxDateBox("instance");
var dateBoxValueFrom = new Date ( dateFrom.option('value') );
var dateTo = $("#TempDateTo").dxDateBox("instance");
var dateBoxValueTo = new Date ( dateTo.option('value') );
var fooSel = $("#TempPlace").dxSelectBox("instance").option("value");
$Datum1=dateBoxValueFrom.getDate()+'.'+(dateBoxValueFrom.getMonth()+1)+'.'+dateBoxValueFrom.getFullYear();
$Datum2=dateBoxValueTo.getDate()+'.'+(dateBoxValueTo.getMonth()+1)+'.'+dateBoxValueTo.getFullYear();
console.log(fooSel);
$.ajax({
url: "AjaxTemperatureDay.php",
dataType : "script",
type: "post",
data: { Item: fooSel, d1: $Datum1, d2: $Datum2 },
success: function(result) {
$("#GridDayTemperature").dxPivotGrid({
allowSorting: true,
allowFiltering: true,
allowExpandAll: true,
allowSortingBySummary: true,
"export": { enabled: true, fileName: "TemperatureDay" },
fieldPanel: {
showColumnFields: true,
showDataFields: true,
showFilterFields: false,
showRowFields: true,
allowFieldDragging: false,
visible: true
},
fieldChooser: {
enabled: false,
applyChangesMode: "instantly",
allowSearch: true
},
onCellPrepared: function(e){
if(e.area==="row"){
e.cellElement.css("backgroundColor", "#E3F2FD");
}
else if(e.area==="column"){
e.cellElement.css("backgroundColor", "#E3F2FD");
}
},
dataSource: {
fields: [
{
caption: "DATUM",
width: 100,
dataField: "D",
area: "row"
},
{
caption: "HODINA",
width: 80,
dataField: "HODINA",
dataType: "number",
area: "row"
},
{
caption: "minuta",
width: 120,
dataField: "MINUTA",
cssClass: 'blue-1',
dataType: "number",
area: "column"
},
{
caption: "hodnota",
width: 120,
dataField: "HODNOTA",
dataType: "number",
summaryType: "sum",
format: { type: "fixedPoint", precision: 3 },
area: "data"
}
],
store: DataDayTemp
}
});
var palette = ["#E1F5FE", "#B3E5FC", "#81D4FA", "#4FC3F7", "#29B6F6", "#03A9F4", "#039BE5", "#0288D1",
"#FFF3E0", "#FFE0B2", "#FFCC80", "#FFB74D", "#FFA726", "#FF9800", "#FB8C00", "#F57C00"],
paletteIndex = 0;
$("#ChartDayTemp").dxChart({
dataSource: ChartDayTemp,
tooltip: { enabled: true },
series: {
argumentField: "D",
valueField: "HODNOTA",
name: "",
type: "bar",
color: '#ffaa66'
},
valueAxis: { title: { text: "GJ" } },
argumentAxis: {
title: { text: "čas" },
label: {
customizeText: function () {
var res = this.valueText.split(" ");
if (res[1]=='00') { return res[0]; } else { return res[1]; }
}
}
},
customizePoint: function () {
var color = palette[paletteIndex];
paletteIndex = paletteIndex === 15 ? 0 : paletteIndex + 1;
return { color: color };
},
scrollingMode: "all",
zoomingMode: "all",
legend:{ visible: false },
"export": { enabled: true },
title: {
text: "Hodinový graf",
subtitle: {
text: ""
}
}
});
$("#ChartDayHourTemp").dxChart({
dataSource: ChartDayHourTemp,
tooltip: { enabled: true },
"export": { enabled: true },
scrollingMode: "all",
zoomingMode: "all",
commonSeriesSettings: {
argumentField: "datum",
type: "bar",
hoverMode: "allArgumentPoints",
selectionMode: "allArgumentPoints"
},
legend: {
verticalAlignment: "bottom",
horizontalAlignment: "center"
},
title: "Po čtvrthodině",
series: [
{ valueField: "H1", name: "00" },
{ valueField: "H2", name: "15" },
{ valueField: "H3", name: "30" },
{ valueField: "H4", name: "45" }
],
valueAxis: { title: { text: "GJ" } },
argumentAxis: {
title: { text: "čas" },
label: {
customizeText: function () {
var res = this.valueText.split(" ");
if (res[1]=='00') { return res[0]; } else { return res[1]; }
}
}
}
});
loadPanelDayTemp.hide();
}
});
}
function PrepareFormDayTemperature() {
var now = new Date();
$("#TempDateFrom").dxDateBox({
displayFormat: "dd.MM.yyyy",
value: now - (60*60*1000*24*2),
onValueChanged: function(date) {
LoadDataDayTemp();
}
});
$("#TempDateTo").dxDateBox({
displayFormat: "dd.MM.yyyy",
value: now,
onValueChanged: function(date) {
LoadDataDayTemp();
}
});
$.ajax({
url: "AjaxTemperatureDayOM.php",
dataType : "script",
type: "post",
success: function(result) {
// console.log(result);
// LoadDataDayTemp();
$("#TempPlace").dxSelectBox({
dataSource: new DevExpress.data.ArrayStore({
data: TempOdbMis,
key: "Object_Index"
}),
displayExpr: "Object_Name",
valueExpr: "Object_Index",
value: TempOdbMis[0].Object_Index,
onValueChanged: function(data) {
/* console.log(data.value); */
window.DataDayTemp = data.value;
LoadDataDayTemp();
}
});
} // sucess
});
}
function TemperatureDayFrm() {
window.GetDate = 0;
$.ajax({
url: "frm-temperature-day.php",
dataType : "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
PrepareFormDayTemperature();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Teplo v páře';
prepareMenuListener();
}
}); // ajax end
};
function LoadDataPress($fa) {
$.ajax({
url: "AjaxPressure.php",
dataType : "script",
type: "post",
data: { FA: $fa },
success: function(result) {
$("#GridPressure").dxDataGrid({ dataSource: DataPress });
}
});
}
function PrepareFormPressure() {
$.ajax({
url: "AjaxTemperatureFA.php",
dataType : "script",
type: "post",
data: { TYP: 6 },
success: function(result) {
$("#ListPressFa").dxList({
dataSource: new DevExpress.data.DataSource({
store: DataTempFa,
group: "FakturaRok",
sort: { getter: "FakturaRok", desc: true }
}),
height: 500,
grouped: true,
collapsibleGroups: true,
selectionMode: "single",
searchEnabled: true,
searchExpr: "FakturaName",
itemTemplate: function(data) {
return $("
").text(data.FakturaName);
},
onSelectionChanged: function(data) {
/* console.log(data); */
if (!data.addedItems[0]) {return;}
console.log(data.addedItems[0].FakturaCislo);
LoadDataPress(data.addedItems[0].FakturaCislo);
}
});
var DataPress = [];
$("#GridPressure").dxDataGrid({
dataSource: DataPress,
allowColumnResizing: true,
rowAlternationEnabled: false,
allowColumnReordering: true,
columnResizingMode: "widget",
showBorders: true,
showRowLines: true,
columnChooser: { enabled: true },
columnFixing: { enabled: true },
filterRow: { visible: false, applyFilter: "auto" },
headerFilter: { visible: true },
sorting: { mode: "multiple" },
scrolling: { mode: "virtual" },
selection: { mode: "single" },
sorting: { mode: "multiple" },
hoverStateEnabled: true,
"export": { enabled: true, fileName: "Pressure" },
searchPanel: { visible: true, width: 240, placeholder: "Hledej..." },
onToolbarPreparing: function(e) {
var dataGrid = e.component;
e.toolbarOptions.items.unshift({
location: "before",
widget: "dxButton",
type: "danger",
options: {
icon: "fas fa-angle-double-down",
type: "danger",
hint: "Zrušit filtrační podmínky ...",
onClick: function() {
DevExpress.ui.notify("ruším filtrační podmínky ...","info",500);
var dataGrid = $('#GridPressure').dxDataGrid('instance');
dataGrid.clearFilter();
dataGrid.clearSorting();
}
}
})
},
columns:
[
{ dataField: "FakturaCislo", caption: "fakturace", width: 70, visible: true },
{
dataField: "OMisto",
caption: "odběrné místo",
width: 200,
visible: true
},
{
dataField: "Name",
caption: "jméno",
width: 230,
visible: true
},
{
dataField: "OD",
caption: "počáteční stav",
width: 95,
dataType: "number",
visible: true
},
{
dataField: "DO",
caption: "koncový stav",
width: 95,
dataType: "number",
visible: true
},
{
dataField: "MNOZSTVI",
caption: "množství",
width: 85,
dataType: "number",
cssClass: 'red-1',
visible: true
},
{
dataField: "jednotka",
width: 65,
visible: true,
cssClass: 'blue-1'
},
{
dataField: "KONSTANTA",
caption: "konstanta",
width: 65,
dataType: "number",
visible: true,
cssClass: 'blue-2'
},
{
dataField: "OdbMistoId",
caption: "odb. misto ID",
width: 65,
dataType: "number",
visible: false,
cssClass: 'silver-2'
},
{
dataField: "Object_Index",
caption: "Object_Index",
width: 65,
dataType: "number",
visible: false,
cssClass: 'silver-2'
}
],
summary: {
totalItems: [
{
column: "OMisto",
summaryType: "count",
displayFormat: "{0}"
},
{
column: "MNOZSTVI",
summaryType: "sum",
displayFormat: "{0}"
}
]
}
});
} // sucess
});
}
function PressureFrm() {
window.GetDate = 0;
$.ajax({
url: "frm-pressure.php",
dataType : "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
PrepareFormPressure();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Tlakový vzduch';
prepareMenuListener();
}
}); // ajax end
};
function LoadDataDayPress($Item) {
window.GetDate = 0;
var loadPanelDayPress = $("#LoadPanelDayPress").dxLoadPanel({
shadingColor: "rgba(0,0,0,0)",
position: { of: "#GridDayPressure" },
visible: false,
showIndicator: true,
showPane: true,
shading: true,
closeOnOutsideClick: false,
onShown: function(){ },
onHidden: function(){ }
}).dxLoadPanel("instance");
loadPanelDayPress.show();
var dateFrom = $("#PressDateFrom").dxDateBox("instance");
var dateBoxValueFrom = new Date ( dateFrom.option('value') );
var dateTo = $("#PressDateTo").dxDateBox("instance");
var dateBoxValueTo = new Date ( dateTo.option('value') );
$Datum1=dateBoxValueFrom.getDate()+'.'+(dateBoxValueFrom.getMonth()+1)+'.'+dateBoxValueFrom.getFullYear();
$Datum2=dateBoxValueTo.getDate()+'.'+(dateBoxValueTo.getMonth()+1)+'.'+dateBoxValueTo.getFullYear();
$.ajax({
url: "AjaxPressureDay.php",
dataType : "script",
type: "post",
data: { Item: $Item, d1: $Datum1, d2: $Datum2 },
success: function(result) {
/* console.log(result); */
var pivotGridDayPressure = $("#GridDayPressure").dxPivotGrid({
allowSorting: true,
allowFiltering: true,
allowExpandAll: true,
allowSortingBySummary: true,
"export": { enabled: true, fileName: "PressureDay" },
fieldPanel: {
showColumnFields: true,
showDataFields: true,
showFilterFields: false,
showRowFields: true,
allowFieldDragging: false,
visible: true
},
fieldChooser: {
enabled: false,
applyChangesMode: "instantly",
allowSearch: true
},
onCellPrepared: function(e){
if(e.area==="row"){
e.cellElement.css("backgroundColor", "#E3F2FD");
}
else if(e.area==="column"){
e.cellElement.css("backgroundColor", "#E3F2FD");
}
},
dataSource: {
fields: [
{
caption: "DATUM",
width: 100,
dataField: "D",
area: "row"
},
{
caption: "HODINA",
width: 80,
dataField: "HODINA",
dataType: "number",
area: "row"
},
{
caption: "minuta",
width: 120,
dataField: "MINUTA",
cssClass: 'blue-1',
dataType: "number",
area: "column"
},
{
caption: "hodnota",
width: 120,
dataField: "HODNOTA",
dataType: "number",
summaryType: "sum",
format: { type: "fixedPoint", precision: 3 },
area: "data"
}
],
store: DataDayPress
}
}).dxPivotGrid("instance");
var palette = ["#E1F5FE", "#B3E5FC", "#81D4FA", "#4FC3F7", "#29B6F6", "#03A9F4", "#039BE5", "#0288D1",
"#FFEBEE", "#FFCDD2", "#EF9A9A", "#E57373", "#EF5350", "#F44336", "#E53935", "#D32F2F"],
paletteIndex = 0;
$("#ChartDayPressure").dxChart({
dataSource: ChartDayPress,
tooltip: { enabled: true },
series: {
argumentField: "D",
valueField: "HODNOTA",
name: "",
type: "bar",
color: '#ffaa66'
},
valueAxis: { title: { text: 'm³' } },
argumentAxis: {
title: { text: "čas" },
label: {
customizeText: function () {
var res = this.valueText.split(" ");
if (res[1]=='00') { return res[0]; } else { return res[1]; }
}
}
},
customizePoint: function () {
var color = palette[paletteIndex];
paletteIndex = paletteIndex === 15 ? 0 : paletteIndex + 1;
return { color: color };
},
scrollingMode: "all",
zoomingMode: "all",
legend:{ visible: false },
"export": { enabled: true },
title: {
text: "Hodinový graf",
subtitle: {
text: ""
}
}
});
$("#ChartDayHourPressure").dxChart({
dataSource: ChartDayHourPress,
tooltip: { enabled: true },
"export": { enabled: true },
scrollingMode: "all",
zoomingMode: "all",
commonSeriesSettings: {
argumentField: "datum",
type: "bar",
hoverMode: "allArgumentPoints",
selectionMode: "allArgumentPoints"
},
legend: {
verticalAlignment: "bottom",
horizontalAlignment: "center"
},
title: "Po čtvrthodině",
series: [
{ valueField: "H1", name: "00" },
{ valueField: "H2", name: "15" },
{ valueField: "H3", name: "30" },
{ valueField: "H4", name: "45" }
],
valueAxis: { title: { text: 'm³' } },
argumentAxis: {
title: { text: "čas" },
label: {
customizeText: function () {
var res = this.valueText.split(" ");
if (res[1]=='00') { return res[0]; } else { return res[1]; }
}
}
}
});
loadPanelDayPress.hide();
} // success
});
}
function PrepareFormDayPressure() {
var now = new Date();
$("#PressDateFrom").dxDateBox({
displayFormat: "dd.MM.yyyy",
value: now - (60*60*1000*24*2),
onValueChanged: function(date) {
LoadDataDayPress();
}
});
$("#PressDateTo").dxDateBox({
displayFormat: "dd.MM.yyyy",
value: now,
onValueChanged: function(date) {
LoadDataDayPress();
}
});
$.ajax({
url: "AjaxPressureDayOM.php",
dataType : "script",
type: "post",
success: function(result) {
// console.log(result);
LoadDataDayPress('*');
$("#PressPlace").dxSelectBox({
dataSource: new DevExpress.data.ArrayStore({
data: PressOdbMis,
key: "Object_Index"
}),
displayExpr: "Object_Name",
valueExpr: "Object_Index",
value: PressOdbMis[0].Object_Index,
onValueChanged: function(data) {
/* console.log(data.value); */
LoadDataDayPress(data.value);
}
});
} // sucess
});
}
function PressureDayFrm() {
window.GetDate = 0;
$.ajax({
url: "frm-pressure-day.php",
dataType : "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
PrepareFormDayPressure();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Tlakový vzduch';
prepareMenuListener();
}
}); // ajax end
};function JidelnaFrm() {
DevExpress.config({ editorStylingMode: "filled" });
JidObjednatFrm();
window.GetDate = 0;
}
var $Jidelnicek = [];
var $jidla = [];
var $SelDatum = new Date();
function TextAreaSavePaste() {
var $d = document.getElementById("TextAreaPaste").value;
/* console.log($val); */
$.ajax({
url: "AjaxJidPasteSave.php",
dataType: "html",
type: "POST",
data: { paste: $d, misto: window.JidelnicekMisto },
success: function(result) {
console.log(result);
}
});
}
function JidelnicekRead($datum) {
window.GetDate = 0;
$d = $datum.getDate()+'.'+($datum.getMonth()+1) +'.'+$datum.getFullYear();
console.log($d+' '+window.JidelnicekMisto);
$.ajax({
url: "AjaxJidJidelnicekRead.php",
dataType: "script",
type: "POST",
data: { datum: $d, misto: window.JidelnicekMisto },
success: function(result) {
/* console.log(result); */
$("#GridJidelnicek").dxDataGrid({ dataSource: $Jidelnicek });
}
});
}
function JidelnicekSave() {
var dataGrid = $('#GridJidelnicek').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
$foo = '';
$seznam_dni = '';
for ($i=0;$i<$Jidelnicek.length;$i++) {
$f = $Jidelnicek[$i]['DA'];
$ff = $f.split(',');
if ($seznam_dni.indexOf($ff[1].trim())<0) {
$seznam_dni = $seznam_dni + $ff[1].trim()+';';
}
if ( $Jidelnicek[$i]['JI'] > 0 ) {
$foo += 'DA:'
+$ff[1].trim()
+',PO:'
+$Jidelnicek[$i]['PO']
+',JI:'
+$Jidelnicek[$i]['JI']+';';
}
}
console.log($foo);
console.log($seznam_dni);
$.ajax({
url: "AjaxJidJidelnicekSave.php",
dataType: "script",
type: "POST",
data: { d: $foo, seznamDni: $seznam_dni },
success: function(result) {
/* console.log(result); */
/* DevExpress.ui.notify("Odesláno ..."); */
}
});
}
function JidelnicekPrepareUI() {
$d = $SelDatum.getDate()+'.'+($SelDatum.getMonth()+1) +'.'+$SelDatum.getFullYear();
/* JidelnicekRead($datum); */
$("#BtnSendFood").dxButton({
text: "Uložit",
type: "success",
width: 150,
icon: "fas fa-check",
onClick: function(e) {
JidelnicekSave();
}
});
$.ajax({
url: "AjaxJidJidelnicekRead.php",
dataType: "script",
type: "POST",
data: { datum: $d },
success: function(result) {
/* console.log(result); */
var dataGrid = $("#GridJidelnicek").dxDataGrid({
dataSource: $Jidelnicek,
showBorders: true,
showRowLines: true,
showColumnLines: false,
grouping: { autoExpandAll: true },
searchPanel: { visible: false },
scrolling: { mode: "virtual" },
groupPanel: { visible: false },
editing: { mode: "batch", allowUpdating: true },
"export": { enabled: true, fileName: "Jidelnicek" },
onRowUpdated: function (e) { JidelnicekSave(); },
onToolbarPreparing: function(e) {
var toolbarItems = e.toolbarOptions.items;
$.each(toolbarItems, function (_, item) {
if (item.name == "saveButton" || item.name == "revertButton") { item.visible = false; }
});
var dataGrid = e.component;
e.toolbarOptions.items.unshift(
{
location: "before",
widget: "dxSelectBox",
options: {
width: 130,
items:
[
{
value: 0,
text: "Kladno"
},
{
value: 1,
text: "Zlín"
}
],
displayExpr: "text",
valueExpr: "value",
value: window.JidelnicekMisto,
onValueChanged: function(data) {
window.JidelnicekMisto = data.value;
JidelnicekRead($SelDatum);
}
}
},
{
location: "before",
widget: "dxDateBox",
options: {
width: 130,
type: "date",
value: $SelDatum,
onValueChanged: function(data) {
JidelnicekRead(data.value);
$SelDatum = data.value;
}
}
},
{
location: "after",
widget: "dxButton",
options: {
type: "date",
type: "",
text: "vložení seznamu",
onClick: function() {
if (window.JidelnicekMisto == 0) { $foo = "Kladno"; }
else if (window.JidelnicekMisto == 1) { $foo = "Zlín"; }
document.getElementById("PasteMisto").innerHTML = $foo;
$('#ModalPaste').modal('show');
}
}
},
{
location: "after",
widget: "dxButton",
type: "danger",
options: {
icon: "fas fa-check",
type: "success",
width: 150,
text: "Uložit",
hint: "Uložit ...",
onClick: function() {
JidelnicekSave();
}
}
},
{
location: "after",
widget: "dxButton",
type: "default",
options: {
icon: "fa fa-print",
type: "",
text: "tisk",
hint: "vytisknout jídelníček ...",
onClick: function() {
console.log('tisk');
$d = $SelDatum.getDate()+'.'+($SelDatum.getMonth()+1) +'.'+$SelDatum.getFullYear();
window.open("AjaxJidPrintJidelnicek2.php?datum="+$d,"_blank");
}
}
}
)
},
columns: [
{ dataField: "DA", caption: "den", groupIndex: 0, dateType: "date", sortOrder: "none" },
{ dataField: "PO", caption: "po", width: 50, allowEditing: false, visible: false },
{ dataField: "TE", caption: "číslo", width: 150, allowEditing: false, visible: true },
{ dataField: "JI", caption: "jídlo", allowEditing: true,
lookup: {
dataSource: function (options) {
if (options.data) {
console.log(options.data);
/* console.log(options.data.TE); */
if (options.data.TE == 'polévka') { return $polevky; } else { return $jidla; }
} else { return $jidla_dohromady; }
},
valueExpr: "ID_POKRM",
displayExpr: "JI"
}
}
]
} ).dxDataGrid("instance");
}
});
}
function JidJidelnicekFrm() {
document.getElementById("MainPlace").innerHTML=$loader;
console.log("JidelnicekFrm loading");
window.LiveTab = 0;
window.GetDate = 0;
$.ajax({
url: "frm-jidelna-jidelnicek.php",
dataType: "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
console.log("JidelnicekFrm loaded");
JidelnicekPrepareUI();
prepareMenuListener();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Jídelna: '+strJidelna;
} // success
});
}
var $StatistikaLog = [];
function JidLogDataRead($d) {
window.GetDate = 0;
$.ajax({
url: "AjaxJidLogRead.php",
dataType: "script",
type: "POST",
data: { d: $d },
success: function(result) {
/* console.log(result); */
$("#GridLog").dxDataGrid({ dataSource: $StatistikaLog });
}
});
}
function JidLogPrepareUI() {
$StatDatum = new Date();
$("#GridLog").dxDataGrid({
dataSource: $StatistikaLog,
showBorders: true,
showRowLines: true,
showColumnLines: false,
rowAlternationEnabled: true,
"export": { enabled: true, fileName: "Log" },
headerFilter: { visible: true },
selection: { mode: "single" },
scrolling: { mode: "infinite" },
summary: {
totalItems: [
{
column: "CAS",
summaryType: "count"
},
{
column: "KS",
displayFormat: "{0}",
summaryType: "sum"
}
]
},
columns: [
{ dataField: "CAS", caption: "čas objednání", width: 160, dataType: "datetime" },
{ dataField: "DATUM", caption: "jídlo pro den", width: 110 },
{ dataField: "MENU", caption: "menu", width: 50 },
{ dataField: "KS", caption: "ks", width: 50 },
{ dataField: "STRAVNIK", caption: "strávník", width: 250 },
{ dataField: "OBJEDNAL", caption: "objednal na intranetu" },
{ dataField: "PRACOVISTE", caption: "pracoviště" }
]
});
}
function JidLogFrm() {
console.log("LogFrm loading");
window.LiveTab = 0;
window.GetDate = 0;
$.ajax({
url: "frm-jidelna-log.php",
dataType: "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
console.log("LogFrm frm loaded");
var d = new Date();
$d = d.getDate()+'.'+(d.getMonth()+1) +'.'+d.getFullYear();
JidLogDataRead($d);
JidLogPrepareUI();
prepareMenuListener();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Jídelna: '+strJidelna;
} // success
});
}
var $sel = [];
window.JidelnaUzivatelID = -1;
var $storeObj = new DevExpress.data.ArrayStore({ data: $Objednavka, key: "ID", SortOrder: "ID" });
console.log(-1);
var $Objednavka = [
{
"ID": 1, "MRAZENE": 0,
"PORADI":"1",
"DATUM":"(1) pondělí, 19.11.2018",
"JIDLO": "Restovaná kachní jatýrka se slaninou, šalotkou, portským vínem a opečenými řezy bagetky",
"KS": 0
}
];
function ObjednatPrepareUI($UzivatelID) {
console.log("ObjednatFrm loading: "+$UzivatelID);
DevExpress.config({ editorStylingMode: "filled" });
window.GetDate = 0;
var strMrazene = [{
"ID_MRAZENE": 0,
"STR_MRAZENE": ""
}, {
"ID_MRAZENE": 1,
"STR_MRAZENE": "10:00-10:30"
}, {
"ID_MRAZENE": 2,
"STR_MRAZENE": "18:15-18:45"
}];
function DoplnSel() {
for ($i=0;$i<$Objednavka.length;$i++) {
if($Objednavka[$i]['KS'] > 0) {
if ($sel.indexOf($i)<0) {
$sel[$sel.length] = $i;
}
}
}
}
function KSdleSel() {
/* console.log($sel); */
for ($i=0;$i<$Objednavka.length;$i++) {
if($Objednavka[$i]['KS'] > 0) {
if ( ($sel.indexOf($i)<0) || ($sel.length == 0) ) {
$Objednavka[$i]['KS'] = 0;
$Objednavka[$i]['MRAZENE'] = 0;
$Objednavka[$i]['JIDELNA'] = 0;
$Objednavka[$i]['KRABICKY'] = 0;
}
} else if ( ($sel.indexOf($i)>-1) && ($Objednavka[$i]['KS'] == 0) ) {
$Objednavka[$i]['KS'] = 1;
$Objednavka[$i]['JIDELNA'] = 1;
$Objednavka[$i]['KRABICKY'] = 0;
}
}
}
function DoplnKS() {
/* console.log($sel); */
for ($i=0;$i<$sel.length;$i++) {
if($Objednavka[$sel[$i]]['KS'] == 0) {
$Objednavka[$sel[$i]]['KS'] = 1;
$Objednavka[$sel[$i]]['JIDELNA'] = 1;
$Objednavka[$sel[$i]]['KRABICKY'] = 0;
} else if($Objednavka[$sel[$i]]['KS'] > 99) {
$Objednavka[$sel[$i]]['KS'] = 99;
}
}
/* console.log($sel); */
}
function ZrusKS() {
for ($i=0;$i<$Objednavka.length;$i++) {
$Objednavka[$i]['KS'] = 0;
$Objednavka[$i]['JIDELNA'] = 0;
$Objednavka[$i]['KRABICKY'] = 0;
}
}
$.ajax({
url: "AjaxJidSeznamJmen.php",
dataType: "script",
type: "POST",
data: { tip: 1, oc: $UzivatelID },
success: function(result) {
/* console.log('AjaxJidSeznamJmen: '+$UzivatelID); */
$("#SearchNames").dxSelectBox({
items: $SeznamJmen,
displayExpr: "JMENO",
valueExpr: "ID",
value: $UzivatelID,
searchEnabled: true,
onValueChanged: function(data) {
/* console.log('SearchNames: '+data.value); */
$UzivatelID = data.value;
window.JidelnaUzivatelID = data.value;
ObjednatReadData($UzivatelID);
}
});
}
});
$("#BtnSend").dxButton({
text: "Potvrdit výběr",
type: "success",
width: 250,
icon: "fas fa-check",
onClick: function(e) {
var dataGrid = $('#GridMenu').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
DoplnSel();
DoplnKS();
var $storeObj = new DevExpress.data.ArrayStore({ data: $Objednavka, key: "ID", SortOrder: "ID" });
$("#GridMenu").dxDataGrid({ dataSource: { store: $storeObj }, selectedRowKeys: $sel });
$fooDatum = ''; $foo = '';
for ($i=0;$i<$Objednavka.length;$i++) {
$f = $Objednavka[$i]['DATUM'];
$ff = $f.split(',');
if ( $fooDatum.indexOf( $ff[1].trim() ) <0 ) { $fooDatum = $fooDatum + $ff[1].trim()+','; }
}
for ($i=0;$i<$sel.length;$i++) {
$f = $Objednavka[ $sel[$i] ]['DATUM'];
$ff = $f.split(',');
$foo += 'DAT:'+$ff[1].trim()
+ ',P:' +$Objednavka[ $sel[$i] ]['PORADI']
+ ',POK:' +$Objednavka[ $sel[$i] ]['ID_POKRM']
+ ',KRA:' +$Objednavka[ $sel[$i] ]['KRABICKY']
+ ',JID:' +$Objednavka[ $sel[$i] ]['JIDELNA']
+ ',KS:' +$Objednavka[ $sel[$i] ]['KS']
+ ',MRA:' +$Objednavka[ $sel[$i] ]['MRAZENE']
+';';
}
$.ajax({
url: "AjaxJidObjednatSave.php",
dataType: "script",
type: "POST",
data: { d: $foo, datumy: $fooDatum, oc: $UzivatelID },
success: function(result) {
console.log($foo);
console.log(result);
DevExpress.ui.notify("Odesláno ...");
}
});
}
});
var dataGrid = $("#GridMenu").dxDataGrid({
dataSource: { store: $storeObj },
allowColumnResizing: true,
columnAutoWidth: true,
showBorders: true,
showRowLines: true,
sorting: { mode: "none" },
showColumnLines: false,
grouping: { autoExpandAll: true },
searchPanel: { visible: false },
scrolling: { mode: "virtual", useNative: true },
selection: { mode: "multiple", showCheckBoxesMode: "always", allowSelectAll: false },
"export": { enabled: true, fileName: "jidelnicek", allowExportSelectedData: false },
groupPanel: { visible: false },
editing: { mode: "batch", allowUpdating: true },
onRowUpdated: function ( obj ) {
/* console.log(obj); */
},
onSelectionChanged: function( obj ) {
dataGrid.saveEditData();
dataGrid.endUpdate();
/* console.log(obj); */
$sel = [];
if( obj.selectedRowsData) {
if( obj.selectedRowsData.length > 0) {
for ($i=0;$i"+$jidlo+" "+$suma+" ks"+$fooAlergeny+"
");
}
},
{ dataField: "MRAZENE", caption: "mražené", cssClass: 'blue-1',
lookup: {
dataSource: strMrazene,
displayExpr: "STR_MRAZENE",
valueExpr: "ID_MRAZENE"
}
},
{ dataField: "ALERGENY", caption: "alergeny", width: 75, allowEditing: false, cssClass: 'small' },
{ dataField: "KRABICKY", caption: "krabička (ks)", dateType: "number", width: 90, cssClass: 'green-1', visible: false, editorOptions: { showSpinButtons: true }
},
{ dataField: "JIDELNA", caption: "jídelna (ks)", dateType: "number", width: 90, cssClass: 'blue-1', visible: false, editorOptions: { showSpinButtons: true }
},
{ dataField: "KS", caption: "ks", dateType: "number", width: 90, cssClass: 'blue-1', editorOptions: { showSpinButtons: true }
}
],
selectedRowKeys: $sel
}).dxDataGrid("instance");
$("#SearchNames").dxSelectBox({ value: $UzivatelID });
if ( ($UzivatelID == 5747) || ($UzivatelID == 5748) || ($UzivatelID < 500000) ) {
$("#BtnChlazene10").dxButton({ visible: true });
$("#BtnChlazene18").dxButton({ visible: true });
}
}
function ObjednatReadData() {
$UzivatelID = window.JidelnaUzivatelID;
console.log('ObjednatReadData: '+$UzivatelID);
$Objednavka = [];
$.ajax({
url: "AjaxJidObjednatRead.php",
dataType: "script",
type: "POST",
data: { oc: $UzivatelID },
success: function(result) {
/* console.log(result); */
var $storeObj = new DevExpress.data.ArrayStore({ data: $Objednavka, key: "ID", SortOrder: ["ID", "PORADI"] });
$("#GridMenu").dxDataGrid({ dataSource: { store: $storeObj }, selectedRowKeys: $sel });
}
});
}
function JidObjednatFrm(){
console.log("JidObjednatFrm: "+strLoginID);
window.JidelnaUzivatelID = strLoginID;
window.LiveTab = 0;
window.GetDate = 0;
$.ajax({
url: "frm-jidelna-jidlo.php",
dataType: "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
ObjednatPrepareUI(strLoginID);
prepareMenuListener();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Jídelna: '+strJidelna;
ObjednatReadData(strLoginID);
console.log("Objednat frm loaded");
} // success
});
}
function SeznamPrepareUI() {
window.GetDate = 0;
$.ajax({
url: "AjaxJidSeznamJidelRead.php",
dataType: "script",
success: function(result) {
$("#BtnSendSeznam").dxButton({
text: "Uložit",
type: "success",
width: 150,
icon: "fas fa-check",
onClick: function(e) {
var dataGrid = $('#GridSeznam').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
var dataGrid = $('#GridPolevky').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
}
});
$("#BtnSendPolevky").dxButton({
text: "Uložit",
type: "success",
width: 150,
icon: "fas fa-check",
onClick: function(e) {
var dataGrid = $('#GridPolevky').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
var dataGrid = $('#GridSeznam').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
}
});
/* console.log(result); */
$("#GridSeznam").dxDataGrid({
dataSource: $SeznamJidel,
showBorders: true,
showRowLines: true,
showColumnLines: false,
editing: { mode: "batch", allowUpdating: true, allowDeleting: true, allowAdding: true },
"export": { enabled: true, fileName: "Jidla" },
rowAlternationEnabled: true,
searchPanel: { visible: true, width: 240, placeholder: "hledat..." },
scrolling: { mode: "virtual", rowRenderingMode: "virtual" },
/*
onToolbarPreparing: function(e) {
var dataGrid = e.component;
e.toolbarOptions.items.unshift(
{
location: "before",
widget: "dxButton",
type: "danger",
options: {
icon: "fas fa-check",
type: "success",
width: 150,
text: "Uložit",
hint: "Uložit ...",
onClick: function() {
var dataGrid = $('#GridSeznam').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
var dataGrid = $('#GridPolevky').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
}
}
})
},*/
onRowRemoved: function(e) {
console.log("onRowRemoved");
var datagrid = $("#GridSeznam").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
/* console.log ("AjaxJidSeznamJidelSave.php?in="+output); */
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:3, t: 0 },
success: function(result) {
SeznamPrepareUI();
}
});
},
onRowInserted: function(e) {
console.log("onRowInserted");
var datagrid = $("#GridSeznam").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
console.log ("AjaxJidSeznamJidelSave.php?in="+output);
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:1, t: 0 },
success: function(result) {
SeznamPrepareUI();
}
});
},
onRowUpdated: function (e) {
console.log("onRowUpdated");
DevExpress.ui.notify("aktualizuji data ...","info",500);
var datagrid = $("#GridSeznam").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
// key, data, component, element
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
/* console.log ("AjaxJidSeznamJidelSave.php?in="+output); */
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:2, t: 0 },
success: function(result) {
DevExpress.ui.notify("ok ...","success",500);
}
});
},
columns: [
{ dataField: "ID_POKRM", caption: "ID", dateType: "number", width: 60, allowEditing: false, visible: false },
{ dataField: "MISTO", caption: "M", dateType: "number", width: 60,allowEditing: false, visible: false },
{ dataField: "TIP", caption: "tip", dateType: "number", width: 60, allowEditing: false, visible: false },
{ dataField: "POPIS", caption: "jídlo", width: 960, allowEditing: true }
],
summary: {
totalItems: [{
column: "POPIS",
summaryType: "count"
}]
}
});
$("#GridPolevky").dxDataGrid({
dataSource: $SeznamPolevek,
showBorders: true,
showRowLines: true,
showColumnLines: false,
rowAlternationEnabled: true,
editing: { mode: "batch", allowUpdating: true, allowDeleting: true, allowAdding: true },
scrolling: { mode: "virtual", rowRenderingMode: "virtual" },
searchPanel: { visible: true, width: 240, placeholder: "hledat..." },
"export": { enabled: true, fileName: "Jidla" },
/*
onToolbarPreparing: function(e) {
var dataGrid = e.component;
e.toolbarOptions.items.unshift(
{
location: "before",
widget: "dxButton",
type: "danger",
options: {
icon: "fas fa-check",
type: "success",
width: 150,
text: "Uložit",
hint: "Uložit ...",
onClick: function() {
var dataGrid = $('#GridSeznam').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
var dataGrid = $('#GridPolevky').dxDataGrid('instance');
dataGrid.saveEditData();
dataGrid.endUpdate();
}
}
})
},
*/
onRowRemoved: function(e) {
console.log("onRowRemoved");
var datagrid = $("#GridPolevky").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
console.log ("AjaxJidSeznamJidelSave.php?in="+output);
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:3, t: 1 },
success: function(result) {
SeznamPrepareUI();
}
});
},
onRowInserted: function(e) {
console.log("onRowInserted");
var datagrid = $("#GridPolevky").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
console.log ("AjaxJidSeznamJidelSave.php?in="+output);
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:1, t: 1 },
success: function(result) {
SeznamPrepareUI();
}
});
},
onRowUpdated: function (e) {
console.log("onRowUpdated");
DevExpress.ui.notify("aktualizuji data ...","info",500);
var datagrid = $("#GridSeznam").dxDataGrid('instance');
row = datagrid.getSelectedRowKeys();
// key, data, component, element
var output = '';
for (var property in e.key) { output += property + ': ' + e.key[property]+'; '; }
/* console.log ("AjaxSeznamJidelSave.php?in="+output); */
$.ajax({
url: "AjaxJidSeznamJidelSave.php",
dataType : "script",
type: "POST",
data: { in: output, sw:2, t: 1 },
success: function(result) {
DevExpress.ui.notify("ok ...","success",500);
}
});
},
columns: [
{ dataField: "ID_POKRM", caption: "ID", dateType: "number", width: 60, allowEditing: false, visible: false },
{ dataField: "MISTO", caption: "M", dateType: "number", width: 60, allowEditing: false, visible: false },
{ dataField: "POPIS", caption: "jídlo", width: 980, allowEditing: true }
],
summary: {
totalItems: [{
column: "POPIS",
summaryType: "count"
}]
}
});
}
});
}
function JidSeznamFrm() {
console.log("StatFrm loading");
window.LiveTab = 0;
window.GetDate = 0;
$.ajax({
url: "frm-jidelna-seznam.php",
dataType: "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
console.log("SeznamFrm frm loaded");
SeznamPrepareUI();
prepareMenuListener();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Jídelna: '+strJidelna;
} // success
});
}
var $StatistikaJmena = [];
var $Statistika = [];
var $StatDatum = new Date();
function JidStatDataRead($d) {
$.ajax({
url: "AjaxJidStatRead.php",
dataType: "script",
type: "POST",
data: { d: $d },
success: function(result) {
/* console.log(result); */
$("#GridStatJmena").dxDataGrid({ dataSource: $StatistikaJmena });
$("#GridStatCelkem").dxDataGrid({ dataSource: $Statistika });
}
});
}
function JidStatPrepareUI() {
$StatDatum = new Date();
var strMrazene = [{
"ID_MRAZENE": 0,
"STR_MRAZENE": ""
}, {
"ID_MRAZENE": 1,
"STR_MRAZENE": "10:00-10:30"
}, {
"ID_MRAZENE": 2,
"STR_MRAZENE": "18:15-18:45"
}];
$("#GridStatJmena").dxDataGrid({
dataSource: $StatistikaJmena,
showBorders: true,
showRowLines: true,
scrolling: { mode: "virtual" },
showColumnLines: false,
"export": { enabled: true, fileName: "Objednávky" },
onToolbarPreparing: function(e) {
var toolbarItems = e.toolbarOptions.items;
$.each(toolbarItems, function (_, item) {
if (item.name == "saveButton" || item.name == "revertButton") { item.visible = false; }
});
var dataGrid = e.component;
e.toolbarOptions.items.unshift(
{
location: "after",
widget: "dxButton",
type: "default",
options: {
icon: "fa fa-print",
type: "",
text: "tisk",
hint: "vytisknout objednávky ...",
onClick: function() {
console.log('tisk');
$d = $StatDatum.getDate()+'.'+($StatDatum.getMonth()+1) +'.'+$StatDatum.getFullYear();
window.open("AjaxJidPrintStat.php?datum="+$d,"_blank");
}
}
},
{
location: "before",
widget: "dxDateBox",
options: {
width: 130,
type: "date",
value: $StatDatum,
onValueChanged: function(data) {
$d = data.value.getDate()+'.'+(data.value.getMonth()+1) +'.'+data.value.getFullYear();
console.log($d);
JidStatDataRead($d);
$StatDatum = data.value;
}
}
}
)
},
columns: [
{ dataField: "DATUM", caption: "datum", width: 100 },
{ dataField: "JMENO", caption: "strávník", width: 300 },
{ dataField: "PORADI", caption: "pořadí", width: 70 },
{ dataField: "JIDLO", caption: "jídlo" },
{ dataField: "MRAZENE",
caption: "chlazené",
width: 125,
lookup: {
dataSource: strMrazene,
displayExpr: "STR_MRAZENE",
valueExpr: "ID_MRAZENE"
}
},
{ dataField: "KS", caption: "ks", width: 70 }
]
});
$("#GridStatCelkem").dxDataGrid({
dataSource: $Statistika,
showBorders: true,
showRowLines: true,
showColumnLines: false,
scrolling: { mode: "virtual" },
"export": { enabled: true, fileName: "Objednávky" },
columns: [
{ dataField: "DATUM", caption: "datum", width: 100 },
{ dataField: "PORADI", caption: "pořadí", width: 70 },
{ dataField: "JIDLO", caption: "jídlo" },
{ dataField: "MRAZENE",
caption: "chlazené",
width: 125,
lookup: {
dataSource: strMrazene,
displayExpr: "STR_MRAZENE",
valueExpr: "ID_MRAZENE"
}
},
{ dataField: "KS", caption: "ks", width: 70 }
]
});
}
function JidStatFrm() {
console.log("StatFrm loading");
window.LiveTab = 0;
window.GetDate = 0;
$.ajax({
url: "frm-jidelna-stat.php",
dataType: "html",
success: function(result) {
document.getElementById("MainPlace").innerHTML = result;
console.log("SouhrnFrm frm loaded");
var d = new Date();
$d = d.getDate()+'.'+(d.getMonth()+1) +'.'+d.getFullYear();
JidStatDataRead($d);
JidStatPrepareUI();
prepareMenuListener();
document.getElementById("MenuDashboardSubmenu").innerHTML = 'Jídelna: '+strJidelna;
} // success
});
}