ProcessorMasterTable SQLDataSource? { @resource { uri="binding:NewMySQL"}};

package client;

// RUI Handler

import org.eclipse.edt.rui.infobus.InfoBus;
import org.eclipse.edt.rui.widgets.Button;
import org.eclipse.edt.rui.widgets.DataGrid;
import org.eclipse.edt.rui.widgets.DataGridColumn;
import org.eclipse.edt.rui.widgets.DataGridLib;
import org.eclipse.edt.rui.widgets.GridLayout;
import org.eclipse.edt.rui.widgets.GridLayoutData;
import org.eclipse.edt.rui.widgets.GridLayoutLib;
import org.eclipse.edt.rui.widgets.TextField;
import org.eclipse.edt.rui.widgets.TextLabel;
import common.Error;
import common.ProcessorMaster;
import dojo.widgets.DojoComboBox;
import dojo.widgets.DojoDialog;
import eglx.persistence.sql.Column;
import server.ProcessorServices;


handler ProcessorMasterList type RUIhandler {initialUI = [ listGrid ],onConstructionFunction = start, cssFile="css/CuttingInstructions.css", title="ProcessorMasterList"}
	
	dbService ProcessorServices?;
	dedicatedServiceBinding HTTPProxy;


	ProcessorMasterDefinition ProcessorMaster[];
	selectedRecord ProcessorMaster[] {};
	ProcessorMasterList ProcessorMaster[];
	
	listGrid GridLayout{
		columns = 1, rows = 2, cellPadding = 4, children = [ ControlButtons, ProcessorMasterDefinition_ui ] };

	ProcessorMasterDefinition_ui DataGrid {
		layoutData = new GridLayoutData{ row = 1, column = 1 },
		columns = [
			new DataGridColumn {name = "PROCID", displayName = "Processor ID", width = 92,
								alignment = DataGridLib.ALIGN_RIGHT, headeralignment = DataGridLib.ALIGN_CENTER},
			new DataGridColumn {name = "PROCNAME", displayName = "Processor Name", width = 320, headeralignment = DataGridLib.ALIGN_CENTER},
			new DataGridColumn {name = "PROCCONTNAME", displayName = "Contact Name", width = 320},
			new DataGridColumn {name = "PROCCITY", displayName = "City", width = 120},
			new DataGridColumn {name = "PROCSTPRV", displayName = "St/Prov", width = 60},
			new DataGridColumn {name = "PROCSETUPDT", displayName = "Setup Date", width = 90, formatters = [ formatDate ]},
			new DataGridColumn {name = "PROCSTATUS", displayName = "Status", width = 80, formatters = [setActiveInactive]}
		],
		behaviors = [ filters ],
		headerBehaviors = [],
		pagesize = 16,
		selectionMode = DataGridLib.SINGLE_SELECTION,
		selectionListeners ::= showOptions,
		pageChangeListeners ::= hideOptions,
		data = []
	};

	selectionDialog DojoDialog {
		title = "Selection Options",
		padding = 20,
		backgroundColor = "lightblue",
		draggable = true,
		children = [selectionOptions]};
		
	selectionOptions GridLayout{
		layoutData = new GridLayoutData{ row = 1, column = 2 }, cellPadding = 4, rows = 4, columns = 1,
		children = [ viewOption, changeOption, deleteOption] };
	
	
	viewOption button{ layoutData = new GridLayoutData{ row = 2, column = 1 }, text = "View Selection", onClick ::= viewRequest };
	changeOption button{ layoutData = new GridLayoutData{ row = 3, column = 1}, text = "Change Selection", onClick ::= changeRequest};
	deleteOption button{ layoutData = new GridLayoutData{ row = 4, column = 1}, text = "Delete Selection", onClick ::= deleteRequest};
	
	
	ControlButtons GridLayout{ layoutData = new GridLayoutData{ row = 2, column = 1,
		horizontalAlignment = GridLayoutLib.ALIGN_LEFT }, cellPadding = 4, rows = 1, columns = 5,
		children = [ appException, appLocation, filterPositionButton, addItemButton, printListButton ] };

	addItemButton button{ layoutData = new GridLayoutData{ row = 1, column = 2 }, text = "Add Item to List", onClick ::= addRequest };
	
	printListButton button{ layoutData = new GridLayoutData{ row = 1, column = 3 }, text = "Print List", onClick ::= printList };	
	
	filterPositionButton button{ layoutData = new GridLayoutData{ row = 1, column = 1 }, text = "Filter/Position List", onClick ::= filterPositionRequest };
	
	
	filterPositionDialog DojoDialog {
		title = "Filter/Position Options",
		padding = 20,
		backgroundColor = "lightblue",
		draggable = true,
		children = [filterPositionOptions]};
		
	filterPositionOptions GridLayout{
		layoutData = new GridLayoutData{ row = 1, column = 2 }, cellPadding = 4, rows = 1, columns = 2,
		children = [ statusFilterLabel, statusFilter ] };
	
	
	statusFilter dojoComboBox{ layoutData = new GridLayoutData{ row = 1, column = 2 }, values = ["Active","Inactive","All"], value = "All", width = 80, onChange ::= setFilter};
	statusFilterLabel TextLabel{ layoutData = new GridLayoutData{ row = 1, column = 1 }, text="Status Filter:" };
	appLocation TextField{ layoutData = new GridLayoutData{ row = 1, column = 4 }};
	appException TextField{ layoutData = new GridLayoutData{ row = 1, column = 5 }};

	function start()
//		processorList.designFile = "firstreport.rptdesign";
		
		InfoBus.subscribe("addDone", getList);
		InfoBus.subscribe("deleteDone", getList);
		InfoBus.subscribe("changeDone", getList);
		InfoBus.subscribe("viewDone", getList);
		//ProcessorMasterList ProcessorMaster[];
		applocation.text = "Step 1";
		call dbService.getProcessorMasterList(ProcessorMasterList) 
			using new HTTPProxy
			returning to RefreshTableData 
			onexception allException;
	end	
	
	function getList(eventName string in, data any in)
		ProcessorMasterList ProcessorMaster[];
		if (data as decimal(11) != 0);
			call dbService.getProcessorMasterList(ProcessorMasterList) 
				using new HTTPProxy
				returning to RefreshTableData 
				onexception allException;
		end
	end	
	
	
	function refreshTableData(ProcessorMasterList ProcessorMaster[] in, ErrorRecord Error in)
		applocation.text = applocation.text + "Step 2";
		ProcessorMasterDefinition_ui.data = ProcessorMasterList as any[];
	end // End function
	
	function showOptions(grid dataGrid in)
		selectedRecord = grid.getSelection() as ProcessorMaster[];
		if (selectedRecord.getSize() == 1);
			selectionDialog.showDialog();
		end // End if
		testing int = 1;
	end // End function
	
	
	function hideOptions(grid dataGrid in, oldPageIndex int in, newPageIndex int in)
		ProcessorMasterDefinition_UI.deselectAll();
	end // End function
	
	function setActiveInactive(class string inout, value string inout, object any in)
		testing int = 1;
		if(value == "1")
			value = "Inactive";
		else
			value = "Active";
		end
	end
	
	function addRequest(event Event in)
		selectNumber decimal(11) = 0;
		InfoBus.publish("addRequest", selectNumber);
	end
	
	
	function changeRequest(event Event in)
		selectNumber int = 0;
		selectionDialog.hideDialog();
		InfoBus.publish("changeRequest", selectedRecord);
		ProcessorMasterDefinition_UI.deselectAll();
	end
		
	function deleteRequest(event Event in)
		selectNumber int = 0;
		selectionDialog.hideDialog();
		InfoBus.publish("deleteRequest", selectedRecord);
		ProcessorMasterDefinition_UI.deselectAll();
	end
	
	function viewRequest(event Event in)
		selectionDialog.hideDialog();
		InfoBus.publish("viewRequest", selectedRecord);
		ProcessorMasterDefinition_UI.deselectAll();
	end
	
	function filterPositionRequest(event Event in)
		filterPositionDialog.showDialog();
	end
	
		function formatDate( class string inOut, value string inOut, rowData any in )
		value = stringLib.format(rowData.PROCSETUPDT as date, constants.usaDateFormat);
	end // End function	
	
	function setFilter(event Event in)
		filterPositionDialog.hideDialog();
		eventName string = " ";
		data int = 1;
		ProcessorMasterDefinition_ui.render();
		//getList(eventName, data);
		testing int = 1;
	end // End function	
	
	function filters(grid DataGrid in, cell Widget in, rowData any? in, dataIndex int in, column DataGridColumn in)
		datafield int = 0;
		if (statusFilter.value == "Active" && rowData.PROCSTATUS AS INT == 1)
			tr Widget = cell.parent;
			try 
				tr.parent.removeChild(tr);
			onException(ex anyexception)
			end	End try
		end // End if
		
		if (statusFilter.value == "Inactive" && rowData.PROCSTATUS as int == 0)
			tr Widget = cell.parent;
			try
				tr.parent.removeChild(tr);
			onException(ex anyexception)
			end // End try
		end // End if
	end // End function
	
	function printList(event Event in)
//		processorList.createReportFromDesign();
	end // End function
	
	function allException(ae AnyException in);
		applocation.text = applocation.text + "Step 3";
		appexception.text = ae.messageID + ae.message;
		workfield int = 1;
	end
end