X-Git-Url: http://git.phpeclipse.com

diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/wizards/SortFilterPage.java b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/wizards/SortFilterPage.java
index e0500bd..0c6b9b4 100644
--- a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/wizards/SortFilterPage.java
+++ b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/wizards/SortFilterPage.java
@@ -2,164 +2,356 @@ package com.quantum.wizards;
 
 import java.sql.SQLException;
 
+import com.quantum.ImageStore;
+import com.quantum.model.Column;
+import com.quantum.model.Entity;
+import com.quantum.model.NotConnectedException;
 import com.quantum.sql.FilterSort;
 import com.quantum.sql.SQLResultSetResults;
 import com.quantum.ui.dialog.SQLExceptionDialog;
 import com.quantum.util.connection.ConnectionUtil;
 
+import org.eclipse.jface.viewers.CellEditor;
+import org.eclipse.jface.viewers.CheckboxCellEditor;
+import org.eclipse.jface.viewers.ComboBoxCellEditor;
+import org.eclipse.jface.viewers.ICellModifier;
+import org.eclipse.jface.viewers.ILabelProviderListener;
+import org.eclipse.jface.viewers.IStructuredContentProvider;
+import org.eclipse.jface.viewers.ITableLabelProvider;
+import org.eclipse.jface.viewers.TableViewer;
+import org.eclipse.jface.viewers.TextCellEditor;
+import org.eclipse.jface.viewers.Viewer;
 import org.eclipse.jface.wizard.WizardPage;
 import org.eclipse.swt.SWT;
-import org.eclipse.swt.events.ModifyEvent;
-import org.eclipse.swt.events.ModifyListener;
-import org.eclipse.swt.events.SelectionEvent;
-import org.eclipse.swt.events.SelectionListener;
+import org.eclipse.swt.graphics.Image;
 import org.eclipse.swt.layout.GridData;
 import org.eclipse.swt.layout.GridLayout;
-import org.eclipse.swt.widgets.Button;
-import org.eclipse.swt.widgets.Combo;
 import org.eclipse.swt.widgets.Composite;
 import org.eclipse.swt.widgets.Label;
-import org.eclipse.swt.widgets.Text;
+import org.eclipse.swt.widgets.Table;
+import org.eclipse.swt.widgets.TableItem;
 
 public class SortFilterPage extends WizardPage implements SQLPage {
-	Button[] filter;
-	Combo[] operator;
-	Text[] filterValues;
-	Button[] stringFlags;
-	Button[] sort;
-	Combo[] ascDesc;
-	private SQLResultSetResults.Row row;
 	
+	class SortFilterTableValues {
+		private String colNames = null;
+		private boolean isWhere = false;
+		private String operators = "";
+		private String values = null;
+		private boolean isString = false;
+		private boolean isOrderBy = false;
+		private String sorter = "";
+		
+		/**
+		 * @return Returns the isOrderBy.
+		 */
+		public boolean isOrderBy() {
+			return isOrderBy;
+		}
+		/**
+		 * @param isOrderBy The isOrderBy to set.
+		 */
+		public void setOrderBy(boolean isOrderBy) {
+			this.isOrderBy = isOrderBy;
+		}
+		/**
+		 * @return Returns the isString.
+		 */
+		public boolean isString() {
+			return isString;
+		}
+		/**
+		 * @param isString The isString to set.
+		 */
+		public void setString(boolean isString) {
+			this.isString = isString;
+		}
+		/**
+		 * @return Returns the isWhere.
+		 */
+		public boolean isWhere() {
+			return isWhere;
+		}
+		/**
+		 * @param isWhere The isWhere to set.
+		 */
+		public void setWhere(boolean isWhere) {
+			this.isWhere = isWhere;
+		}
+		/**
+		 * @return Returns the operators.
+		 */
+		public String getOperators() {
+			return operators;
+		}
+		/**
+		 * @param operators The operators to set.
+		 */
+		public void setOperators(String operators) {
+			this.operators = operators;
+		}
+		/**
+		 * @return Returns the sorter.
+		 */
+		public String getSorter() {
+			return sorter;
+		}
+		/**
+		 * @param sorter The sorter to set.
+		 */
+		public void setSorter(String sorter) {
+			this.sorter = sorter;
+		}
+		/**
+		 * @return Returns the values.
+		 */
+		public String getValues() {
+			return values;
+		}
+		/**
+		 * @param values The values to set.
+		 */
+		public void setValues(String values) {
+			this.values = values;
+		}
+		/**
+		 * @return Returns the colNames.
+		 */
+		public String getColNames() {
+			return colNames;
+		}
+		/**
+		 * @param colNames The colNames to set.
+		 */
+		public void setColNames(String colNames) {
+			this.colNames = colNames;
+		}
+	}
+
+	class LabelProviderImpl implements ITableLabelProvider {
+		public Image getColumnImage(Object element, int columnIndex) {
+			if (columnIndex == 0) {
+		        return ((SortFilterTableValues)element).isWhere() ? imgCheck : imgUncheck;
+		    } else if (columnIndex == 3) {
+		        return ((SortFilterTableValues)element).isString() ? imgCheck : imgUncheck;
+		    } else if (columnIndex == 4) {
+			    return ((SortFilterTableValues)element).isOrderBy() ? imgCheck : imgUncheck;
+		    } else {
+		        return null;
+		    }
+		}
+		public String getColumnText(Object element, int columnIndex) {
+			String sReturn = "";			
+			SortFilterTableValues sortFilterRow = (SortFilterTableValues)element;
+						
+			switch (columnIndex) {
+				case 0: // isWhere
+					sReturn = sortFilterRow.getColNames();
+				    break;
+				case 1: // operators
+				    sReturn = sortFilterRow.getOperators();
+				    break;
+				case 2: // values
+					sReturn = sortFilterRow.getValues();
+					break;
+				case 3: // isString
+					break;
+				case 4: // isOrderBy
+					sReturn = sortFilterRow.getColNames();
+					break;
+				case 5: // sorter
+					sReturn = sortFilterRow.getSorter();
+					break;
+				default:
+				    break;
+			}
+			return sReturn;
+		}
+		public void addListener(ILabelProviderListener listener) {}
+		public void dispose() {}
+		public boolean isLabelProperty(Object element, String property) {
+			return false;
+		}
+		public void removeListener(ILabelProviderListener listener) {}
+	}
+	
+    class ContentProviderImpl implements IStructuredContentProvider {
+		public Object[] getElements(Object inputElement) {
+			return sortFilterValues;
+		}
+
+		public void dispose() {}
+		public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {}		
+	}
+        
+    class CellModifierImpl implements ICellModifier {
+
+    	public boolean canModify(Object element, String property) {
+    		return true;
+    	}
+    	
+    	public Object getValue(Object element, String property) {		
+    		System.out.println("getValue called");
+    	
+    		// Find the index of the column
+    		int colIndx = comUI.getColumnNamesAsList(colNames).indexOf(property);
+    		System.out.println("colIndx : " + colIndx);		
+    		 
+    		Object rResult = null;
+    		SortFilterTableValues sortFilterVal = (SortFilterTableValues)element;
+    				
+    		switch (colIndx) {
+	    		case 0: // isWhere
+	    		    rResult = new Boolean(sortFilterVal.isWhere());
+				    break;
+				case 1: // operators
+					String sTemp = sortFilterVal.getOperators();
+					int nIndex = comUI.getColumnNamesAsList(oper).indexOf(sTemp);					
+				    rResult = new Integer(nIndex);
+				    break;
+				case 2: // values
+					rResult = sortFilterVal.getValues();
+					break;
+				case 3: // isString
+					rResult = new Boolean(sortFilterVal.isString());
+					break;
+				case 4: // isOrderBy
+					rResult = new Boolean(sortFilterVal.isOrderBy());
+					break;
+				case 5: // sorter
+					String sTemp2 = sortFilterVal.getSorter();
+					int nIndx = comUI.getColumnNamesAsList(order).indexOf(sTemp2);					
+				    rResult = new Integer(nIndx);
+					break;
+	    		default:
+    				rResult = "";
+    				break;
+    		}
+    		
+    		return rResult;
+    	}
+    	
+    	public void modify(Object element, String property, Object value) {
+    		int colIndx = comUI.getColumnNamesAsList(colNames).indexOf(property);
+    		
+    		TableItem item = (TableItem) element;
+    		SortFilterTableValues sortFilterVal = (SortFilterTableValues)item.getData();
+    		
+    		switch (colIndx) {
+    			case 0: // isWhere
+    				sortFilterVal.setWhere(((Boolean)value).booleanValue());
+    			    break;
+    			case 1: // operators    				
+    				int nIdx = ((Integer)value).intValue();
+    				if (nIdx != -1)
+    					sortFilterVal.setOperators(oper[nIdx]);
+    				else
+    					sortFilterVal.setOperators("");
+    				
+    			    break;
+    			case 2: // values
+    				sortFilterVal.setValues(value.toString());
+    				break;
+    			case 3: // isString
+    				sortFilterVal.setString(((Boolean)value).booleanValue());
+    				break;
+    			case 4: // isOrderBy
+    				sortFilterVal.setOrderBy(((Boolean)value).booleanValue());
+    				break;
+				case 5: // sorter
+					int nId = ((Integer)value).intValue();
+					if (nId != -1)
+						sortFilterVal.setSorter(order[nId]);
+					else 
+						sortFilterVal.setSorter("");
+					
+					break;
+    			default:
+    			    break;
+    		}
+    		
+    		updateView();    			    
+		    updateQuery();
+    	}
+    }
+	
+	private SQLResultSetResults.Row row;
 	private ConnectionUtil connectionUtil = new ConnectionUtil();
+	CommonWizardUI comUI;
 	
+	SortFilterTableValues[] sortFilterValues;
+	TableViewer tableViewer = null;
+	static Image imgCheck = null;
+	static Image imgUncheck = null;
 	String columnNames[];
 	Label query;
 	FilterSort filterSort = new FilterSort();
 	private SQLResultSetResults results;
+	
+	static {
+	    imgCheck = ImageStore.getImage(ImageStore.CHECKED);
+	    imgUncheck = ImageStore.getImage(ImageStore.UNCHECKED);
+	}
+	
+	// constant declarations
+	String[] colNames = new String[] { "Where", "Operator", "Values", "Is String", "Order By", "Sorter" };
+	String[] oper = new String[] { "=", "<>", "<", ">" };
+	String[] order = new String[] { "", "ASC", "DESC" };
+	
 	public SortFilterPage(String pageName) {
 		super(pageName);
 	}
 
 	public void init(SQLResultSetResults results, SQLResultSetResults.Row row) {
 		this.results = results;
-		this.row = row;
+		this.row = row;		
 	}
 
 	public void createControl(Composite parent) {
 		System.out.println("page create control"); //$NON-NLS-1$
-		
+				
 		Composite container = new Composite(parent, SWT.NULL);
-		GridLayout layout = new GridLayout();
-		container.setLayout(layout);
-		int layoutColumns = 6;
-		layout.numColumns = layoutColumns;
-
-		columnNames = this.results.getColumnNames();
+		container.setLayout(new GridLayout());
+		container.setLayoutData(new GridData(GridData.FILL_BOTH | GridData.VERTICAL_ALIGN_BEGINNING));
 		
-		int size = this.results.getColumnCount();
-		filter = new Button[size];
-		operator = new Combo[size];
-		filterValues = new Text[size];
-		stringFlags = new Button[size];
-		sort = new Button[size];
-		ascDesc = new Combo[size];
-		for (int i = 0; i < size; i++) {
-			filter[i] = new Button(container, SWT.CHECK);
-			filter[i].setText(columnNames[i]);
-			filter[i].addSelectionListener(new SelectionListener() {
-				public void widgetDefaultSelected(SelectionEvent e) {
-				}
-				public void widgetSelected(SelectionEvent e) {
-					updateQuery();
-				}
-			});
-
-			operator[i] = new Combo(container, SWT.SINGLE | SWT.READ_ONLY);
-			operator[i].add("="); //$NON-NLS-1$
-			operator[i].add("<>"); //$NON-NLS-1$
-			operator[i].add("<"); //$NON-NLS-1$
-			operator[i].add(">"); //$NON-NLS-1$
-			operator[i].addSelectionListener(new SelectionListener() {
-				public void widgetDefaultSelected(SelectionEvent e) {
-				}
-				public void widgetSelected(SelectionEvent e) {
-					updateQuery();
-				}
-			});
-			
-			filterValues[i] = new Text(container, SWT.BORDER);
-			Object data = this.row == null ? null : this.row.get(i+1);
-			filterValues[i].setText(data == null ? "" : data.toString());
-			filterValues[i].addModifyListener(new ModifyListener() {
-				public void modifyText(ModifyEvent e) {
-					updateQuery();
-				}				
-			});
-			
-			stringFlags[i] = new Button(container, SWT.CHECK);
-			stringFlags[i].setText("String"); //$NON-NLS-1$
-			stringFlags[i].addSelectionListener(new SelectionListener() {
-				public void widgetDefaultSelected(SelectionEvent e) {
-				}
-				public void widgetSelected(SelectionEvent e) {
-					updateQuery();
-				}
-			});
+		comUI = new CommonWizardUI();
+		
+		columnNames = this.results.getColumnNames();		
+		int nLen = columnNames.length;
+		sortFilterValues = new SortFilterTableValues[nLen];
+		
+		for (int nCtr = 0; nCtr < nLen; nCtr++) {
+			sortFilterValues[nCtr] = new SortFilterTableValues();	
+			sortFilterValues[nCtr].setColNames(columnNames[nCtr]);
 			
-			final int index = i;
-			sort[i] = new Button(container, SWT.CHECK);
-			sort[i].setText(columnNames[i]);
-			sort[i].addSelectionListener(new SelectionListener() {
-				public void widgetDefaultSelected(SelectionEvent e) {
-				}
-				public void widgetSelected(SelectionEvent e) {
-					if (sort[index].getSelection()) {
-						filterSort.addSort(columnNames[index], ascDesc[index].getText());
-					} else {
-						filterSort.removeSort(columnNames[index]);
-					}
-					updateQuery();
-				}
-			});
-
-			ascDesc[i] = new Combo(container, SWT.SINGLE | SWT.READ_ONLY);
-			ascDesc[i].add(""); //$NON-NLS-1$
-			ascDesc[i].add("ASC"); //$NON-NLS-1$
-			ascDesc[i].add("DESC"); //$NON-NLS-1$
-			ascDesc[i].addSelectionListener(new SelectionListener() {
-				public void widgetDefaultSelected(SelectionEvent e) {
-				}
-				public void widgetSelected(SelectionEvent e) {
-					if (sort[index].getSelection()) {
-						filterSort.addSort(columnNames[index], ascDesc[index].getText());
-					} else {
-						filterSort.removeSort(columnNames[index]);
-					}
-					updateQuery();
-				}
-			});
+			Object data = this.row == null ? null : this.row.get(nCtr+1);
+			sortFilterValues[nCtr].setValues(data == null ? "" : data.toString());
 		}
+		
+		createTable(container);
+		
 		query = new Label(container, SWT.WRAP);
- 		GridData gridData = new GridData();
- 		gridData.horizontalSpan = layoutColumns;
-		gridData.horizontalAlignment = GridData.FILL;
-		gridData.verticalAlignment = GridData.FILL;
-		gridData.grabExcessHorizontalSpace = true;
-		gridData.grabExcessVerticalSpace = true;
-		query.setLayoutData(gridData);
+		query.setLayoutData(comUI.createGridData(1, GridData.FILL));
 
- 		setControl(container);
-       
+ 		setControl(container);       
 		setPageComplete(true);
 	}
 
 	public void updateQuery() {
 		filterSort.clearFilters();
-		for (int i = 0; i < filter.length; i++) {
-			if (filter[i].getSelection()) {
-				filterSort.addFilter(filter[i].getText(), operator[i].getText(), filterValues[i].getText(), stringFlags[i].getSelection());
+		
+		int nLen = columnNames.length;
+		for (int nCtr = 0; nCtr < nLen; nCtr++) {
+			if (sortFilterValues[nCtr].isWhere()) {
+				filterSort.addFilter(columnNames[nCtr], sortFilterValues[nCtr].getOperators(), sortFilterValues[nCtr].getValues(), sortFilterValues[nCtr].isString());
+			}
+			if (sortFilterValues[nCtr].isOrderBy()) {
+				filterSort.addSort(columnNames[nCtr], sortFilterValues[nCtr].getSorter());
+			} else {
+				filterSort.removeSort(columnNames[nCtr]);
 			}
 		}
+		
 		query.setText(filterSort.toString());
 	}
 
@@ -174,4 +366,59 @@ public class SortFilterPage extends WizardPage implements SQLPage {
 			return false;
 		}
 	}
+	
+	private void updateView() {
+        this.tableViewer.update(sortFilterValues, null);
+    }
+	
+	/**
+	 * @param entity
+	 * @param columnName
+	 * @return
+	 * @throws NotConnectedException
+	 * @throws SQLException
+	 */
+	protected Column getColumn(Entity entity, String columnName)  {
+		try {
+			return entity == null ? null : entity.getColumn(columnName);
+		} catch (NotConnectedException e) {
+			return null;
+		} catch (SQLException e) {
+			return null;
+		}
+	}
+	
+	private void createTable(Composite composite) {
+        System.out.println("Creating table...");        
+        Table table = comUI.createTablePage(composite);    	
+
+        comUI.createTableColumn(table, colNames[0], SWT.LEFT, 0, 150); // isWhere
+        comUI.createTableColumn(table, colNames[1], SWT.CENTER, 1, 70); // operator
+        comUI.createTableColumn(table, colNames[2], SWT.LEFT, 2, 150); // values
+        comUI.createTableColumn(table, colNames[3], SWT.LEFT, 3, 70); // isString
+        comUI.createTableColumn(table, colNames[4], SWT.LEFT, 4, 150); // isOrderBy
+        comUI.createTableColumn(table, colNames[5], SWT.CENTER, 5, 70); // sorter
+		this.tableViewer = new TableViewer(table);
+		this.tableViewer.setColumnProperties(colNames);
+
+		CellEditor[] editor = new CellEditor[colNames.length];
+		
+		editor[0] = new CheckboxCellEditor(table, SWT.NULL);
+				
+		editor[1] = new ComboBoxCellEditor(table, oper, SWT.READ_ONLY);
+				
+		editor[2] = new TextCellEditor(table);				
+		
+		editor[3] = new CheckboxCellEditor(table, SWT.NULL);
+		
+		editor[4] = new CheckboxCellEditor(table, SWT.NULL);
+				
+		editor[5] = new ComboBoxCellEditor(table, order, SWT.READ_ONLY);
+				
+		this.tableViewer.setCellEditors(editor);
+		this.tableViewer.setLabelProvider(new LabelProviderImpl());
+		this.tableViewer.setContentProvider(new ContentProviderImpl());
+		this.tableViewer.setCellModifier(new CellModifierImpl());
+		this.tableViewer.setInput(sortFilterValues);    	
+    }		
 }