From 4be36d9ecc4283d484b87d2ff2f775a426adfef2 Mon Sep 17 00:00:00 2001
From: elgekko <vasary@elgekko.net>
Date: Tue, 10 May 2022 11:10:08 +0200
Subject: [PATCH] tabulator listazo alapok

---
 server/user.mediacube.gui/pages/jobeditor.zul |   6 +-
 .../user.mediacube.gui/pages/jobeditor2.zul   |   1 +
 server/user.mediacube.gui/pages/jobs.zul      |  10 +-
 .../pages/searchitems/tabulatorresults.zul    | 128 ++++++++++++------
 .../zk/converter/TabulatorDataConverter.java  |  30 ++++
 .../jobengine/zk/model/CachedListModel.java   |   9 +-
 .../jobengine/zk/model/GridSearchModel.java   |  54 +++-----
 .../user/jobengine/zk/model/IndexModel.java   |  10 +-
 .../jobengine/zk/model/JobEditorModel.java    |  15 +-
 .../zk/model/MissingMaterialsModel.java       |  14 +-
 .../zk/model/TabulatorSearchModel.java        |  99 +++++++++-----
 11 files changed, 228 insertions(+), 148 deletions(-)
 create mode 100644 server/user.mediacube.gui/src/user/jobengine/zk/converter/TabulatorDataConverter.java

diff --git a/server/user.mediacube.gui/pages/jobeditor.zul b/server/user.mediacube.gui/pages/jobeditor.zul
index ad865467..7a194d85 100644
--- a/server/user.mediacube.gui/pages/jobeditor.zul
+++ b/server/user.mediacube.gui/pages/jobeditor.zul
@@ -12,6 +12,8 @@
 	<vlayout height="100%" viewModel="@id('jlm') @init('user.jobengine.zk.model.JobEditorModel')">
 		<toolbar>
 			<toolbarbutton label="Futtatás" iconSclass="z-icon-play" onClick="@command('execute')" disabled="${not sessionScope.userPrincipal.admin}" autodisable="self" />
+			<separator orient="vertical"/>
+			<toolbarbutton label="Újratöltés" iconSclass="z-icon-dot-circle-o" onClick="@command('reload')" autodisable="self"/>
 		</toolbar>
 		<borderlayout vflex="true">
 			<center border="none" vflex="true">
@@ -34,7 +36,6 @@
 					<tabs visible="true">
 						<tab id="tab0" label="Paraméterek" selected="true" />
 						<tab id="tab1" label="Részletek" />
-						<tab id="tab2" label="Ábra" />
 					</tabs>
 					<tabpanels>
 						<tabpanel>
@@ -102,9 +103,6 @@
 							<label height="100%" ca:data-syntax-highlight="true" multiline="true" pre="true" 
 								value="@bind(jlm.selectedJob['xml'])" />
 						</tabpanel>
-						<tabpanel>
-							<include src="pages/processVisualizer.zul" />
-						</tabpanel>
 					</tabpanels>
 				</tabbox>
 			</east>
diff --git a/server/user.mediacube.gui/pages/jobeditor2.zul b/server/user.mediacube.gui/pages/jobeditor2.zul
index 4f9e2dc1..693abe5f 100644
--- a/server/user.mediacube.gui/pages/jobeditor2.zul
+++ b/server/user.mediacube.gui/pages/jobeditor2.zul
@@ -15,6 +15,7 @@
 				disabled="${not sessionScope.userPrincipal.admin}" autodisable="self" />
 			<toolbarbutton label="Duplikálás" iconSclass="z-icon-copy" onClick="@command('duplicateProcessEntry')" />
 			<toolbarbutton label="Másolás" id="CopyProcessButton" iconSclass="z-icon-copy" onClick="@command('copyProcessEntry')" />
+			<separator orient="vertical"/>
 			<toolbarbutton label="Újratöltés" iconSclass="z-icon-dot-circle-o" onClick="@command('reload')" autodisable="self"/>
 		</toolbar>
 		<borderlayout vflex="true">
diff --git a/server/user.mediacube.gui/pages/jobs.zul b/server/user.mediacube.gui/pages/jobs.zul
index f4cee7ce..d31bd44c 100644
--- a/server/user.mediacube.gui/pages/jobs.zul
+++ b/server/user.mediacube.gui/pages/jobs.zul
@@ -2,13 +2,11 @@
 <!DOCTYPE xml>
 
 <zk xmlns:w="http://www.zkoss.org/2005/zk/client" xmlns:ca="client/attribute" xmlns:x="xhtml">
-	<style src="css/joblist.css" />
-
 	<tabbox id="pagesTab" vflex="true" hflex="true" orient="top">
 		<tabs visible="true">
 			<tab id="tab0" label="Futó folyamatok" selected="true" />
 			<tab id="tab1" label="Folyamat szerkesztő" />
-			<tab id="tab2" label="Folyamat szerkesztő2" />
+<!-- 			<tab id="tab2" label="Folyamat szerkesztő2" /> -->
 		</tabs>
 		<tabpanels>
 			<tabpanel>
@@ -17,9 +15,9 @@
 			<tabpanel>
 				<include src="/pages/jobeditor.zul"/>
 			</tabpanel>
-			<tabpanel>
- 				<include src="/pages/jobeditor2.zul" /> 
-			</tabpanel>
+<!-- 			<tabpanel> -->
+<!--  				<include src="/pages/jobeditor2.zul" />  -->
+<!-- 			</tabpanel> -->
 		</tabpanels>
 	</tabbox>
 </zk>
\ No newline at end of file
diff --git a/server/user.mediacube.gui/pages/searchitems/tabulatorresults.zul b/server/user.mediacube.gui/pages/searchitems/tabulatorresults.zul
index fbe73b2a..4ee48d0a 100644
--- a/server/user.mediacube.gui/pages/searchitems/tabulatorresults.zul
+++ b/server/user.mediacube.gui/pages/searchitems/tabulatorresults.zul
@@ -5,48 +5,100 @@
  	<style src="/css/tabulator.css" />
  	<script src="/js/tabulator.js" />
 
-<paging totalSize="100" pageSize="20"/>
-<h:div id="example_table"></h:div>
-<h:script>
-//define data array
-var tabledata = [
-    {id:1, name:"Oli Bob", progress:12, gender:"male", rating:1, col:"red", dob:"19/02/1984", car:1,serviceHistory:"Jimmy Brown"},
-    {id:2, name:"Mary May", progress:1, gender:"female", rating:2, col:"blue", dob:"14/05/1982", car:true},
-    {id:3, name:"Christine Lobowski", progress:42, gender:"female", rating:0, col:"green", dob:"22/05/1982", car:"true"},
-    {id:4, name:"Brendon Philips", progress:100, gender:"male", rating:1, col:"orange", dob:"01/08/1980"},
-    {id:5, name:"Margret Marmajuke", progress:16, gender:"female", rating:5, col:"yellow", dob:"31/01/1999"},
-    {id:6, name:"Frank Harbours", progress:38, gender:"male", rating:4, col:"red", dob:"12/05/1966", car:1},
-];
-
-//initialize table
-var table = new Tabulator("#example_table", {
-	layout:"fitDataStretch",
-	height: "100%",
-    data:tabledata, //assign data to table
-    autoColumns:true, //create columns from data field names
-    sortMode:"remote",
-	columnDefaults:{
-    	resizable:true,
-    },  
-    rowFormatter:function(row){
-		 //create and style holder elements
-		var holderEl = document.createElement("div");
-		var tableEl = document.createElement("div");
+	<paging totalSize="100" pageSize="20"/>
+	<h:div id="result_table" onTableBuilt="@command('onTableBuilt')" onRowSelectionChanged="@command('onRowSelectionChanged')"></h:div>
+	<h:script>
+	
+	try {
+		var table = initTable();
+	} catch(error){
+		console.error(error);
+	}
+	
+	
+	function initTable() {
+		var table = new Tabulator("#result_table", {
+			layout:"fitDataStretch",
+			height: "100%",
+		    //data:tabledata,
+		<!--     autoColumns:true, -->
+			columns:[
+		        {title:"ID", field:"id", headerSortTristate:true, headerClick:function(e, column){ onSort(column); }},
+		        {title:"Cím", field:"name", headerSortTristate:true, headerClick:function(e, column){ onSort(column); }},
+		        {title:"Fájlnév", field:"fileName", headerSortTristate:true, headerClick:function(e, column){ onSort(column); }},
+		        {title:"Archiválva", field:"archiveDate", headerSortTristate:true, headerClick:function(e, column){ onSort(column); }},
+		        {title:"Hossz", field:"length", headerSortTristate:true, headerClick:function(e, column){ onSort(column); }}
+		    ],
+	        initialSort:[
+		        {column:"fileName", dir:"asc"}
+    		],
+		    sortMode:"remote",
+		    selectable: true,
+			columnDefaults:{
+		    	resizable:true,
+		    },  
+		    rowFormatter:function(row){
+				console.log("Formatting", row);
 		
-		holderEl.style.boxSizing = "border-box";
-		holderEl.style.padding = "10px 30px 10px 10px";
-		holderEl.style.borderTop = "1px solid #333";
-		holderEl.style.borderBotom = "1px solid #333";
+				var holderEl = document.createElement("div");
+				var tableEl = document.createElement("div");
+				tableEl.style.margin = "5px";
+				tableEl.style.width = "60%"
+				tableEl.style.boxSizing = "border-box";
+				
+				holderEl.style.boxSizing = "border-box";
+				holderEl.style.padding = "10px 30px 10px 10px";
+		<!-- 		holderEl.style.borderTop = "1px solid #333"; -->
+		<!-- 		holderEl.style.borderBotom = "1px solid #333"; -->
+				
+				
+				//tableEl.style.border = "1px solid #333";
+				
+				holderEl.appendChild(tableEl);
+				
+				row.getElement().appendChild(holderEl);
+				var relevant = row.getData().relevant;
+				if (relevant)
+			 		tableEl.innerHTML = relevant; 
+		    },  
+		});
 		
+		function onSort(column){
+			//console.log("onSort", column);
+		}
+
+		table.on("headerClick", function(e, column){
+		    //e - the click event object
+		    //column - column component
+			console.log("headerClick", column._column.field, column._column.modules.sort.dir);
+		});
+				
+		table.on("rowClick", function(e, row){
+		    //e - the click event object
+		    //row - row component
+			console.log("rowClick", e, row);
+		});
 		
-		tableEl.style.border = "1px solid #333";
+		table.on("rowSelectionChanged", function(data, rows){
+			console.log("rowSelectionChanged", data, rows);
+			zk.Widget.$('$result_table').fire('onRowSelectionChanged', {
+				meta : data
+			}, {
+				toServer : true
+			});
+		});
 		
-		holderEl.appendChild(tableEl);
+		table.on("tableBuilt", function(){
+			console.log("tableBuilt");
+			zk.Widget.$('$result_table').fire('onTableBuilt', {
+				meta : null
+			}, {
+				toServer : true
+			});
+		});
 		
-		row.getElement().appendChild(holderEl);
-		tableEl.innerHTML = row.getData().serviceHistory; 
-    },  
-});
-</h:script>
+		return table;
+	}
+	</h:script>
 
 </zk>
\ No newline at end of file
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/converter/TabulatorDataConverter.java b/server/user.mediacube.gui/src/user/jobengine/zk/converter/TabulatorDataConverter.java
new file mode 100644
index 00000000..5a788f5f
--- /dev/null
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/converter/TabulatorDataConverter.java
@@ -0,0 +1,30 @@
+package user.jobengine.zk.converter;
+
+import java.util.List;
+
+import com.ibm.nosql.json.api.BasicDBList;
+import com.ibm.nosql.json.api.BasicDBObject;
+
+import user.jobengine.db.ArchivedMedia;
+
+public class TabulatorDataConverter {
+	
+	public BasicDBList convert(List<ArchivedMedia> data) {
+		BasicDBList result = new BasicDBList();
+		
+		for (ArchivedMedia am : data) {
+			BasicDBObject row = new BasicDBObject();
+			row.put("id", am.getMedia().getHouseId());
+			row.put("name", am.getMedia().getTitle());
+//			row.put("fileName", am.getMedia().getMediaFilesName());
+			row.put("archiveDate", am.getMedia().getArchived().toString());
+			row.put("length", am.getMedia().getLength());
+			//row.put("itemType", am.getMedia().getItemType().getName());
+			row.put("itemTitle", am.getItem().getTitle());
+			row.put("relevant", am.getRelevant());
+			result.add(row);
+		}
+		return result;
+	}
+
+}
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/CachedListModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/CachedListModel.java
index dded66f5..622dbab7 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/CachedListModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/CachedListModel.java
@@ -29,8 +29,6 @@ public class CachedListModel extends ListModelList<ArchivedMedia> {
 	private int cacheSize = 1000;
 	private HashMap<Integer, ArchivedMedia> cache = new HashMap<Integer, ArchivedMedia>();
 	private boolean cachedMode = true;
-
-	private String searchValue = null;
 	private int resultSetSize = -1;
 
 	private ArrayList<Item> docSelection = new ArrayList<Item>();
@@ -129,6 +127,8 @@ public class CachedListModel extends ListModelList<ArchivedMedia> {
 	 */
 	private void loadCache(int forIndex) {
 		try {
+			long startSearch = System.currentTimeMillis();
+
 			logger.info("Loading {}", forIndex);
 			clearCache();
 			SearchResult<ArchivedMedia> sr = null;
@@ -167,6 +167,9 @@ public class CachedListModel extends ListModelList<ArchivedMedia> {
 				cacheStart = startPos + 1;
 				cacheEnd = cacheStart + (cache.size() == 0 ? 0 : (cache.size() - 1));
 			}
+
+			long endSearch = System.currentTimeMillis();
+			logger.info("Cache filled in {} s", (float) (endSearch - startSearch) / 1000);
 		} catch (Exception e) {
 			fireCacheEvent(new Event(Events.ON_ERROR, null, e));
 			// ki kell nullazni, egyebkent tobbszeros lekerdezes van
@@ -189,8 +192,6 @@ public class CachedListModel extends ListModelList<ArchivedMedia> {
 			}
 		} catch (Exception e) {
 			fireCacheEvent(new Event(Events.ON_ERROR, null, e));
-			// ki kell nullazni, egyebkent tobbszeros lekerdezes van
-			resultSetSize = 0;
 		}
 		return result;
 	}
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/GridSearchModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/GridSearchModel.java
index 8cfb9b9e..2d55d438 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/GridSearchModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/GridSearchModel.java
@@ -150,7 +150,6 @@ public class GridSearchModel extends AsyncBaseModel {
 	private boolean missingProxy;
 	private int selectedDateOption;
 	private Window metaWindow;
-	private long startSearch;
 
 	public GridSearchModel() {
 		this.itemManager = ItemManager.getInstance();
@@ -245,8 +244,7 @@ public class GridSearchModel extends AsyncBaseModel {
 			tags = itemManager.getAllTags();
 			// lekerdezesi hiba
 			if (tags == null)
-				Clients.showNotification("A cimkék inicializálása sikertelen!", "error", tagsToolbar, "start_center",
-						3000);
+				Clients.showNotification("A cimkék inicializálása sikertelen!", "error", tagsToolbar, "start_center", 3000);
 			else
 				setSearchTags();
 
@@ -284,13 +282,11 @@ public class GridSearchModel extends AsyncBaseModel {
 
 	@Command
 	public void copyMediaIdToClipboard() {
-		String port = (Executions.getCurrent().getServerPort() == 80) ? ""
-				: (":" + Executions.getCurrent().getServerPort());
+		String port = (Executions.getCurrent().getServerPort() == 80) ? "" : (":" + Executions.getCurrent().getServerPort());
 		String baseURL = Executions.getCurrent().getScheme() + "://" + Executions.getCurrent().getServerName() + port
 				+ Executions.getCurrent().getContextPath();
 		String url = String.format("%s/?%s=%d", baseURL, MEDIA_ID, selectedObject.getMedia().getId());
-		String email = String.format("mailto:?subject=Média címe: %s &body=A média itt tekinthető meg: %s",
-				selectedObject.getMedia().getTitle(), url);
+		String email = String.format("mailto:?subject=Média címe: %s &body=A média itt tekinthető meg: %s", selectedObject.getMedia().getTitle(), url);
 		Executions.getCurrent().sendRedirect(email);
 	}
 
@@ -307,14 +303,12 @@ public class GridSearchModel extends AsyncBaseModel {
 		parameters.put("successRecipient", SessionUtil.getUserPrincipal().getEmail());
 
 		try {
-			jobEngine.submit(CREATE_LOWRES_TEMPLATE, scheduledJob.getJobName(), parameters,
-					SessionUtil.getUserPrincipal().getDisplayName());
-			Messagebox.show("A proxy pótlása elindult, emailben értesíti a rendszer a folyamat végeztével.",
-					"Információ", Messagebox.OK, Messagebox.INFORMATION);
+			jobEngine.submit(CREATE_LOWRES_TEMPLATE, scheduledJob.getJobName(), parameters, SessionUtil.getUserPrincipal().getDisplayName());
+			Messagebox.show("A proxy pótlása elindult, emailben értesíti a rendszer a folyamat végeztével.", "Információ", Messagebox.OK,
+					Messagebox.INFORMATION);
 		} catch (JobEngineException e) {
 			logger.info("Hiba a feladat indításakor", e);
-			Messagebox.show("Hiba a feladat indításakor. A rendszer üzenete: " + e.getMessage(), "Hiba", Messagebox.OK,
-					Messagebox.ERROR);
+			Messagebox.show("Hiba a feladat indításakor. A rendszer üzenete: " + e.getMessage(), "Hiba", Messagebox.OK, Messagebox.ERROR);
 		}
 	}
 
@@ -322,8 +316,6 @@ public class GridSearchModel extends AsyncBaseModel {
 	@NotifyChange({ "searchResult", "selectedObject", "hasTSMMediaFile", "hasLowresMediaFile", "lowresMediaFilePath" })
 	public void doSearch() {
 
-		startSearch = System.currentTimeMillis();
-
 		try {
 			search.close();
 			search.select();
@@ -350,13 +342,11 @@ public class GridSearchModel extends AsyncBaseModel {
 
 			List<Long> selectedTypeIds = getTypeIDs(searchFilters);
 
-			SearchOptions options = SearchOptions.create().setText(searchValue).setTypes(selectedTypeIds)
-					.setTags(searchTags).setFrom(searchFrom).setTo(searchTo).setMissingProxy(missingProxy)
-					.setDescLength(descLength).setOrder(orderBy, orderAscending);
+			SearchOptions options = SearchOptions.create().setText(searchValue).setTypes(selectedTypeIds).setTags(searchTags).setFrom(searchFrom)
+					.setTo(searchTo).setMissingProxy(missingProxy).setDescLength(descLength).setOrder(orderBy, orderAscending);
 
 			if (!options.isValid())
-				throw new Exception(
-						"Legalább egy keresési opció használata kötelező: 3 karakter, hiányzó proxy, dátum, típus, cimke!");
+				throw new Exception("Legalább egy keresési opció használata kötelező: 3 karakter, hiányzó proxy, dátum, típus, cimke!");
 			searchResult = new CachedListModel(options);
 			searchResult.addEventListener(e -> {
 				if (e.getName().equals(Events.ON_ERROR)) {
@@ -659,8 +649,6 @@ public class GridSearchModel extends AsyncBaseModel {
 		} catch (Exception e) {
 			handleSearchError(e);
 		}
-		long endSearch = System.currentTimeMillis();
-		logger.info("onAfterRenderGrid end, ellapsed {} s", (float) (endSearch - startSearch) / 1000);
 	}
 
 	@Command
@@ -703,8 +691,7 @@ public class GridSearchModel extends AsyncBaseModel {
 			doubleVar = (Double) jsObject.get("meta");
 		}
 
-		if (doubleVar.floatValue() >= ((selectedObject.getTcOut() == null) ? 9999999999999999999999.9
-				: selectedObject.getTcOut())) {
+		if (doubleVar.floatValue() >= ((selectedObject.getTcOut() == null) ? 9999999999999999999999.9 : selectedObject.getTcOut())) {
 			throw new Exception("A kilépés időpontjának későbbinek kell lennie mint a belépés időpontja!");
 		} else {
 			selectedObject.setTcIn(new Float(doubleVar.floatValue()));
@@ -751,8 +738,7 @@ public class GridSearchModel extends AsyncBaseModel {
 			metaWindow = null;
 		};
 
-		metaWindow = (Window) Executions.createComponents(template, null,
-				ListUtils.asMap("selectedObject", selectedObject, "listener", listener));
+		metaWindow = (Window) Executions.createComponents(template, null, ListUtils.asMap("selectedObject", selectedObject, "listener", listener));
 		metaWindow.doOverlapped();
 		metaWindow.addEventListener("onClose", listener);
 	}
@@ -817,8 +803,7 @@ public class GridSearchModel extends AsyncBaseModel {
 		case TAGTYPE_REMOVE:
 			mediaTags.remove(tagText.toLowerCase());
 			if (id == 0) {
-				Messagebox.show("A cimke már nem található az adatbázisban: " + tagText, "Belső hiba!", Messagebox.OK,
-						Messagebox.EXCLAMATION);
+				Messagebox.show("A cimke már nem található az adatbázisban: " + tagText, "Belső hiba!", Messagebox.OK, Messagebox.EXCLAMATION);
 				return;
 			}
 			itemManager.removeMediaTag(id, selectedObject.getMedia().getId());
@@ -840,8 +825,7 @@ public class GridSearchModel extends AsyncBaseModel {
 
 	@Command
 	@NotifyChange({ "selectedObject", "hasLowresMediaFile", "hasTSMMediaFile", "lowresMediaFilePath" })
-	public void select(@BindingParam("selectedObject") ArchivedMedia selectedObject,
-			@ContextParam(ContextType.BIND_CONTEXT) BindContext ctx) {
+	public void select(@BindingParam("selectedObject") ArchivedMedia selectedObject, @ContextParam(ContextType.BIND_CONTEXT) BindContext ctx) {
 		Event event = ctx.getTriggerEvent();
 		// Nem mindig a row a target, ha a kepre kattintunk akkor az image
 		// selectedRowIndex = ((Row) event.getTarget()).getIndex();
@@ -1137,9 +1121,7 @@ public class GridSearchModel extends AsyncBaseModel {
 		// preventAfterRender = true;
 		if (activePageIndex != itemsGrid.getActivePage()) {
 			itemsGrid.setActivePage(activePageIndex);
-			logger.info(
-					"Selected media is shown in the results, which can be found on {} page and also it will be highlighted.",
-					activePageIndex + 1);
+			logger.info("Selected media is shown in the results, which can be found on {} page and also it will be highlighted.", activePageIndex + 1);
 		} else {
 			// TODO for debug purposes
 			// onAfterRenderGrid();
@@ -1148,9 +1130,9 @@ public class GridSearchModel extends AsyncBaseModel {
 	}
 
 	private void showSearchTypeWarning() {
-		Clients.showNotification(String.format(
-				"Figyelem!<br><br><span style='white-space:nowrap'> A keresés eredménye nem tartalmazza az összes típust.</span>"),
-				"warning", toggleShowTypeFilters, "end_center", 3000);
+		Clients.showNotification(
+				String.format("Figyelem!<br><br><span style='white-space:nowrap'> A keresés eredménye nem tartalmazza az összes típust.</span>"), "warning",
+				toggleShowTypeFilters, "end_center", 3000);
 	}
 
 	@Command
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/IndexModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/IndexModel.java
index cb01bdc8..21d1e57a 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/IndexModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/IndexModel.java
@@ -24,16 +24,14 @@ import user.jobengine.zk.util.SessionUtil;
 public class IndexModel extends BaseModel {
 	private static final Logger logger = LogManager.getLogger();
 	private String page;
-	private Map<String, Object> pathMap = ListUtils.asMap("/", "searchitems", "jobs", "jobs", "missingmaterials",
-			"missingmaterials", "newshistory", "newshistory", "edithistory", "edithistory", "statistics", "statistics",
-			"maestro", "maestro", "pwdgen", "pwdgen");
+	private Map<String, Object> pathMap = ListUtils.asMap("/", "searchitems", "jobs", "jobs", "missingmaterials", "missingmaterials", "newshistory",
+			"newshistory", "edithistory", "edithistory", "statistics", "statistics", "maestro", "maestro", "pwdgen", "pwdgen");
 
 	@AfterCompose
 	public void afterCompose(@ContextParam(ContextType.VIEW) Component view) {
 		Selectors.wireComponents(view, this, false);
 		Selectors.wireEventListeners(view, this);
-		route(Executions.getCurrent().getParameter("action"), SessionUtil.getQueryString(Arrays.asList("action")),
-				false);
+		route(Executions.getCurrent().getParameter("action"), SessionUtil.getQueryString(Arrays.asList("action")), false);
 		SessionUtil.setAttribute(IndexModel.class.getCanonicalName(), this);
 	}
 
@@ -54,7 +52,7 @@ public class IndexModel extends BaseModel {
 		String realAction = action.equals("/") ? action : "/actions/" + action;
 		realAction += query;
 		Clients.evalJavaScript(String.format("window.history.pushState(null, null, '%s');", realAction));
-		logger.info("Pushed to client: {}", realAction);
+		logger.debug("Pushed to client: {}", realAction);
 	}
 
 	public void route(String action, String query, boolean silently) {
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/JobEditorModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/JobEditorModel.java
index 3070cbd8..f171bcce 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/JobEditorModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/JobEditorModel.java
@@ -46,7 +46,6 @@ import user.jobengine.server.ast.ParameterExpression;
 import user.jobengine.server.ast.VariableDeclaration;
 import user.jobengine.server.ast.VariableName;
 import user.jobengine.server.scheduler.ScheduledJob;
-import user.jobengine.server.scheduler.SchedulerService;
 
 public class JobEditorModel extends BaseModel {
 	private static final String XML = "xml";
@@ -213,8 +212,7 @@ public class JobEditorModel extends BaseModel {
 //	}
 
 	private void toast(IJobRuntime runtime) {
-		Clients.evalJavaScript(
-				String.format("showToast('<b>%s</b> elindítva.</br>ID %d')", runtime.getName(), runtime.getId()));
+		Clients.evalJavaScript(String.format("showToast('<b>%s</b> elindítva.</br>ID %d')", runtime.getName(), runtime.getId()));
 	}
 
 	public ListModelList<BasicDBObject> getJobs() {
@@ -247,6 +245,7 @@ public class JobEditorModel extends BaseModel {
 	}
 
 	private void initJobList() {
+		setSelectedJob(null);
 		List<BasicDBObject> jobsCollection = new ArrayList<BasicDBObject>();
 		for (int index = 0; index < jobEngine.getJobEngineConfiguration().getSchedules().size(); index++) {
 			jobsCollection.add(jobEngine.getJobEngineConfiguration().getSchedules().get(index).getValue());
@@ -262,21 +261,17 @@ public class JobEditorModel extends BaseModel {
 			return aName.toLowerCase().compareTo(bName.toLowerCase());
 		});
 		jobs = new ListModelList<>(jobsCollection);
-
 	}
 
 	@Command
-	@NotifyChange("jobs")
+	@NotifyChange({ "selectedJob", "jobs" })
 	public void reload() {
-		SchedulerService scheduler = jobEngine.getScheduler();
 		try {
-			scheduler.restart();
+			jobEngine.reloadGracefully();
 			initJobList();
-
 		} catch (Exception e) {
-			logger.info("Scheduler reload error. System message: {}", e.getMessage());
+			Messagebox.show(e.getMessage(), "Hiba!", Messagebox.OK, Messagebox.ERROR);
 		}
-
 	}
 
 	public void setJobs(ListModelList<BasicDBObject> jobs) {
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/MissingMaterialsModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/MissingMaterialsModel.java
index 45ea3b67..86fd8e1f 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/MissingMaterialsModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/MissingMaterialsModel.java
@@ -73,8 +73,7 @@ public class MissingMaterialsModel extends AsyncBaseModel implements IJobChanged
 		Map<String, Object> jobParameters = importJob.getJobParameters();
 		Object targetPath = jobParameters.get(TARGETPATH);
 		if (!(targetPath instanceof String)) {
-			Messagebox.show(
-					"Nem található az 'import-morpheus-missing-materials.xml' folyamatsablonban a 'targetPath' paraméter.");
+			Messagebox.show("Nem található az 'import-morpheus-missing-materials.xml' folyamatsablonban a 'targetPath' paraméter.");
 			return;
 
 		}
@@ -84,8 +83,7 @@ public class MissingMaterialsModel extends AsyncBaseModel implements IJobChanged
 			if (!MorpheusStrings.STATUS_RESTORABLE.equals(status))
 				continue;
 			List<IJobRuntime> jobRuntimes = new ArrayList<>(jobEngine.getJobs().values());
-			Optional<IJobRuntime> findFirst = jobRuntimes.stream()
-					.filter(jobRuntime -> isRetrieveJobFor(jobRuntime, material)).findFirst();
+			Optional<IJobRuntime> findFirst = jobRuntimes.stream().filter(jobRuntime -> isRetrieveJobFor(jobRuntime, material)).findFirst();
 
 			String name = material.getString(MorpheusStrings.MATERIALID);
 			if (findFirst.isPresent()) {
@@ -96,7 +94,7 @@ public class MissingMaterialsModel extends AsyncBaseModel implements IJobChanged
 					ScheduledJob retrieveJob = jobEngine.getScheduledJob(RETRIEVE_TEMPLATE);
 					Map<String, Object> parameters = retrieveJob.getJobParameters();
 					parameters.put(MorpheusStrings.MATERIAL, material);
-					jobEngine.submit(RETRIEVE_TEMPLATE, String.format("%s hiányzó anyag visszatöltése", name), parameters);
+					jobEngine.submit(RETRIEVE_TEMPLATE, String.format("%s hiányzó anyag visszatöltése", name), parameters);
 				} catch (Exception e) {
 					logger.catching(e);
 				}
@@ -141,8 +139,7 @@ public class MissingMaterialsModel extends AsyncBaseModel implements IJobChanged
 			importJob = jobEngine.getScheduledJob(IMPORT_TEMPLATE);
 
 			List<IJobRuntime> jobRuntimes = new ArrayList<>(jobEngine.getJobs().values());
-			Optional<IJobRuntime> findFirst = jobRuntimes.stream()
-					.filter(jobRuntime -> isImportJob(jobRuntime.getTemplate())).findFirst();
+			Optional<IJobRuntime> findFirst = jobRuntimes.stream().filter(jobRuntime -> isImportJob(jobRuntime.getTemplate())).findFirst();
 			if (findFirst.isPresent())
 				setImportDisabled(true);
 			initializeList();
@@ -202,8 +199,7 @@ public class MissingMaterialsModel extends AsyncBaseModel implements IJobChanged
 	}
 
 	private void onRetrieveJobChanged(IJobRuntime jobRuntime) {
-		Optional<BasicDBObject> findFirst = jobList.stream().filter(material -> isRetrieveJobFor(jobRuntime, material))
-				.findFirst();
+		Optional<BasicDBObject> findFirst = jobList.stream().filter(material -> isRetrieveJobFor(jobRuntime, material)).findFirst();
 		if (findFirst.isPresent()) {
 			BasicDBObject material = findFirst.get();
 			BindUtils.postNotifyChange(null, null, material, "*");
diff --git a/server/user.mediacube.gui/src/user/jobengine/zk/model/TabulatorSearchModel.java b/server/user.mediacube.gui/src/user/jobengine/zk/model/TabulatorSearchModel.java
index d7af8b0a..9ba3597a 100644
--- a/server/user.mediacube.gui/src/user/jobengine/zk/model/TabulatorSearchModel.java
+++ b/server/user.mediacube.gui/src/user/jobengine/zk/model/TabulatorSearchModel.java
@@ -57,6 +57,8 @@ import org.zkoss.zul.Vlayout;
 import org.zkoss.zul.West;
 import org.zkoss.zul.Window;
 
+import com.ibm.nosql.json.api.BasicDBList;
+
 import user.commons.ListUtils;
 import user.commons.StoreUri;
 import user.commons.remotestore.RemoteStoreProtocol;
@@ -71,6 +73,7 @@ import user.jobengine.gui.ComponentBinder;
 import user.jobengine.server.IJobEngine;
 import user.jobengine.server.JobEngineException;
 import user.jobengine.server.scheduler.ScheduledJob;
+import user.jobengine.zk.converter.TabulatorDataConverter;
 import user.jobengine.zk.util.SessionUtil;
 
 public class TabulatorSearchModel extends AsyncBaseModel {
@@ -101,7 +104,7 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 	private Map<String, Long> tags = null;
 	private List<Long> searchTags = new ArrayList<Long>();
 	protected IItemManager itemManager = null;
-
+	private TabulatorDataConverter tabulatorConverter = new TabulatorDataConverter();
 	@Wire
 	Timer timer;
 	@Wire
@@ -204,8 +207,8 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 	@AfterCompose
 	public void afterCompose(@ContextParam(ContextType.VIEW) Component view) {
 		// A MediaFileServlet a services/proxy alatt szolgal ki
-		// Clients.evalJavaScript("setSource('http://localhost:9080/services/proxy/20209535_1-20205617.mp4',
-		// 'video/mp4')");
+//		Clients.evalJavaScript("setSource('http://localhost:9080/services/proxy/20209535_1-20205617.mp4', 'video/mp4')");
+//		Clients.evalJavaScript("setSource('https://d2zihajmogu5jn.cloudfront.net/bipbop-advanced/bipbop_16x9_variant.m3u8', 'application/x-mpegURL', 5.56)");
 
 		try {
 
@@ -364,12 +367,21 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 
 			int pageSize = SessionUtil.getUserPageSize();
 			List<ArchivedMedia> page = searchResult.loadPage(0, pageSize);
-
+			BasicDBList jsonData = tabulatorConverter.convert(page);
+			setResultGridData(jsonData);
 		} catch (Exception e) {
 			handleSearchError(e);
 		}
 	}
 
+	private void setResultGridData(BasicDBList jsonData) {
+		StringBuilder sb = new StringBuilder();
+		sb.append("table.setData(");
+		sb.append(jsonData.toString());
+		sb.append(");");
+		Clients.evalJavaScript(sb.toString());
+	}
+
 	public void doSort(Event event) throws Exception {
 		// TODO hande sort
 		// itemsGrid.getColumns().getChildren().forEach(c -> ((Column)
@@ -633,36 +645,36 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 		return rowsExpanded;
 	}
 
-	@Command
-	public void onAfterRenderGrid() {
-		logger.info("onAfterRenderGrid begin");
-		// aszinkron fut le, kulon kezelendo a hiba
-		try {
-
-			if (searchResult != null)
-				logger.info("isempty {}", searchResult.isEmpty());
-
-			String mediaID = SessionUtil.getQueryParameter(MEDIA_ID);
-			if (mediaID != null) {
-				selectedObject = searchResult.getElementAt(0);
-				highlight(selectedObject, true);
-				notifyChange("selectedObject", "hasLowresMediaFile", "hasTSMMediaFile", "lowresMediaFilePath");
-				logger.info("onAfterRenderGrid end");
-			} else {
-				if (!preventAfterRender) {
-					preventAfterRender = true;
-
-					if (positionToScroll != -1) {
-						ensureVisible(positionToScroll);
-					}
-				}
-			}
-		} catch (Exception e) {
-			handleSearchError(e);
-		}
-		long endSearch = System.currentTimeMillis();
-		logger.info("onAfterRenderGrid end, ellapsed {} s", (float) (endSearch - startSearch) / 1000);
-	}
+//	@Command
+//	public void onAfterRenderGrid() {
+//		logger.info("onAfterRenderGrid begin");
+//		// aszinkron fut le, kulon kezelendo a hiba
+//		try {
+//
+//			if (searchResult != null)
+//				logger.info("isempty {}", searchResult.isEmpty());
+//
+//			String mediaID = SessionUtil.getQueryParameter(MEDIA_ID);
+//			if (mediaID != null) {
+//				selectedObject = searchResult.getElementAt(0);
+//				highlight(selectedObject, true);
+//				notifyChange("selectedObject", "hasLowresMediaFile", "hasTSMMediaFile", "lowresMediaFilePath");
+//				logger.info("onAfterRenderGrid end");
+//			} else {
+//				if (!preventAfterRender) {
+//					preventAfterRender = true;
+//
+//					if (positionToScroll != -1) {
+//						ensureVisible(positionToScroll);
+//					}
+//				}
+//			}
+//		} catch (Exception e) {
+//			handleSearchError(e);
+//		}
+//		long endSearch = System.currentTimeMillis();
+//		logger.info("onAfterRenderGrid end, ellapsed {} s", (float) (endSearch - startSearch) / 1000);
+//	}
 
 	@Command
 	public void onChangingCombo(@ContextParam(ContextType.BIND_CONTEXT) BindContext ctx) {
@@ -1028,7 +1040,7 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 			sb.append("]);");
 
 			String js = sb.toString();
-			logger.info(js);
+			// logger.info(js);
 			Clients.evalJavaScript(js);
 		}
 	}
@@ -1173,4 +1185,21 @@ public class TabulatorSearchModel extends AsyncBaseModel {
 		timer.start();
 	}
 
+	@Command
+	public void onTableBuilt(@ContextParam(ContextType.TRIGGER_EVENT) Event event) {
+		logger.info("tableBuilt");
+		String mediaID = SessionUtil.getQueryParameter(MEDIA_ID);
+		if (mediaID != null) {
+			selectedObject = searchResult.getElementAt(0);
+			highlight(selectedObject, true);
+			notifyChange("selectedObject", "hasLowresMediaFile", "hasTSMMediaFile", "lowresMediaFilePath");
+		}
+	}
+
+	@Command
+	public void onRowSelectionChanged(@ContextParam(ContextType.TRIGGER_EVENT) Event event) {
+		logger.info("rowSelectionChanged");
+		JSONObject jsObject = (JSONObject) event.getData();
+		// NoSQLUtils.getValue("")
+	}
 }
-- 
2.54.0