package com.sutternow.swingkar.gui;import javax.swing.*;import javax.swing.text.MaskFormatter;import javax.swing.event.CellEditorListener;import javax.swing.table.DefaultTableModel;import javax.swing.table.TableCellEditor;import javax.swing.table.AbstractTableModel;import javax.swing.border.Border;import java.awt.event.*;import java.awt.*;import java.util.*;import java.util.List;import java.text.ParseException;import org.dom4j.Element;import org.dom4j.DocumentHelper;import net.sf.easylayouts.*;import com.gargoylesoftware.base.gui.TableLayout;import com.sutternow.swingkar.ConfigManager;/** * Created by IntelliJ IDEA. * User: Matthew Payne * Date: Jan 18, 2003 * Time: 1:01:50 AM * To change this template use Options | File Templates. */public class QueryEditPane implements SimpleForm,  ActionListener, MouseListener {    public String Title = "Query";    public QueryEditPane(ConfigManager _cm) {        cm = _cm;        props = new LinkedHashMap();        queryPanel = this.createPanel();    }    public String getTitle() {        return Title;    }    public JPanel getEditForm() {        return queryPanel;    }    private JPanel createPanel() {        final TableLayout layout = new TableLayout();        final JPanel panel = new JPanel();        final JPanel topPanel = new JPanel(new TableLayout());        final JPanel bottomPanel = new JPanel();        /* rowLayout used as parent panel */        RowLayout rowLayout = new RowLayout(panel, 1, 25);        topPanel.add(new JLabel("Name:"), "1,1");        colName = new JTextField(10);        topPanel.add(colName, "1,2");        topPanel.add(new JLabel("Result:"), "2,1");        String types[] = {"single", "list"};        resultType = new JComboBox(types);        topPanel.add(resultType, "2,2");        topPanel.add(new JLabel("Details:"), "3,1");        qtm = new QueryTableModel(props.entrySet());        fieldsTable = new JTable(qtm);        JComboBox conditBox = new JComboBox();        conditBox.addItem("");        conditBox.addItem("=?");        conditBox.addItem(">?");        conditBox.addItem("<?");        conditBox.addItem("=<?");        conditBox.addItem("=>?");        fieldsTable.getColumn("Condition").setCellEditor(new DefaultCellEditor(conditBox));        MaskFormatter formatter = null;        try {            formatter = new MaskFormatter("#");        } catch (ParseException e) {            e.printStackTrace();  //To change body of catch statement use Options | File Templates.        }        fieldsTable.getColumn("Order").setCellEditor(new DefaultCellEditor(new JFormattedTextField(formatter)));        JScrollPane jsp = new JScrollPane(fieldsTable);        jsp.setMinimumSize(new Dimension(130, 80));        jsp.setMaximumSize(new Dimension(390, 260));        jsp.setPreferredSize(new Dimension(360, 240));        fieldsTable.getColumn("Order").setPreferredWidth(6);        fieldsTable.getColumn("Condition").setPreferredWidth(18);       /* cmdSave = new JButton("Save");        cmdCancel = new JButton("Cancel");        cmdSave.addActionListener(this);        cmdCancel.addActionListener(this);        bottomPanel.add(cmdSave);        bottomPanel.add(cmdCancel);*/        layout.setColumnExpandable(0, true);        layout.setColumnExpandable(1, true);        rowLayout.add(topPanel, 0);        rowLayout.add(jsp, 1);        rowLayout.add(bottomPanel, 2);        return panel;    }    public void setValues(Element beanCfg) {        this.clearForm();        String relPath = beanCfg.getUniquePath();        colProps = beanCfg;        colName.setText(colProps.valueOf(relPath + "/name"));        resultType.setSelectedItem(colProps.elementText("result"));        List choices = beanCfg.selectNodes(relPath + "/../*[name()='primary-key' or name()='attribute']/column");        System.out.println("field count is=" + choices.size());        for (Iterator iter = choices.listIterator(); iter.hasNext();) {            QueryBean query = new QueryBean();            String display = "";            Element element = (Element) iter.next();            display = element.elementText("name");            query.setFieldName(element.elementText("name"));            String cond = beanCfg.valueOf(relPath + "/condition[field-name='" + display + "']/field-condition");            if (cond != null) {                query.setCondition(cond);            }            /*                  <condition>                       <field-name>role</field-name>                       <field-condition>=?</field-condition>                  </condition>            */            props.put(display, query);        }        /*         <sorting>             <field-name>firstName</field-name>         </sorting>     */        choices = beanCfg.selectNodes(relPath + "/sorting");        for (int i = 0; i < choices.size(); i++) {            Element elm = (Element) choices.get(i);            elm.elementText("field-name");            QueryBean query = (QueryBean) props.get(elm.elementText("field-name"));            query.setOrder(Integer.toString(i + 1));        }        qtm.requestRefresh();    }    public void actionPerformed(ActionEvent ae) {        JButton src = (JButton) ae.getSource();    }    private void clearForm() {        /*            Set values to defaults        */        colName.setText("");        resultType.setSelectedIndex(1);        props.clear();    }    public void doSave() {        colProps.element("name").setText(colName.getText());        colProps.elements("result").clear();        colProps.addElement("result").setText((String) resultType.getSelectedItem());        colProps.elements("condition").clear();        // clear then save current conditions        Iterator itr = props.entrySet().iterator();        while (itr.hasNext()) {            Map.Entry entry = (Map.Entry) itr.next();            QueryBean qb = (QueryBean) entry.getValue();            if (qb.getCondition() != null && qb.getCondition() != "") {                Element cond = colProps.addElement("condition");                cond.addElement("field-name").setText(qb.getFieldName());                cond.addElement("field-condition").setText(qb.getCondition());            }        }        colProps.elements("sorting").clear();        ArrayList orderedList = new ArrayList(props.values());        Collections.sort(orderedList, new QuerySort());        itr = orderedList.iterator();        while (itr.hasNext()) {            QueryBean qb = (QueryBean) itr.next();            if (qb.getOrder() != null && qb.getOrder().trim() != "") {                System.out.println(qb.getFieldName() + qb.getOrder());                Element cond = colProps.addElement("sorting");                cond.addElement("field-name").setText(qb.getFieldName());            }        }        cm.saveChanges();        System.out.println(this.Title + " Saved");        //cm.saveBuildConfig(this.makeResponse());    }    private void handleMouseEvent(MouseEvent evt) {    }    public void mousePressed(MouseEvent evt) {        handleMouseEvent(evt);    }    public void mouseReleased(MouseEvent evt) {        handleMouseEvent(evt);    }    public void mouseClicked(MouseEvent e) {    }    public void mouseEntered(MouseEvent e) {    }    public void mouseExited(MouseEvent e) {    }    private JPanel queryPanel;    private JTextField colName;    private JComboBox resultType;    private QueryTableModel qtm;    private JTable fieldsTable;    private Map props;   // private JButton cmdSave;  //  private JButton cmdCancel;    private ConfigManager cm;    private Element colProps;}class QueryBean {    String fieldName;    String condition;    String order;    String aggregateCondition;    public String getFieldName() {        return fieldName;    }    public void setFieldName(String fieldName) {        this.fieldName = fieldName;    }    public String getCondition() {        return condition;    }    public void setCondition(String condition) {        this.condition = condition;    }    public String getOrder() {        return order;    }    public void setOrder(String order) {        this.order = order;    }    public String getAggregateCondition() {        return aggregateCondition;    }    public void setAggregateCondition(String aggregateCondition) {        this.aggregateCondition = aggregateCondition;    }}class QuerySort implements Comparator {    public int compare(Object o1, Object o2) {        QueryBean r1 = (QueryBean) o1;        QueryBean r2 = (QueryBean) o2;        if (r2.order == null && r1.order == null) return 0;        if (r1.order == null) return -1;        if (r2.order == null) return 1;        return r2.order.compareTo(r1.order);    }}class QueryTableModel extends AbstractTableModel {    /**     * Constructs an AppList table model.     * @param _appSet  the collection of extentions and associations     */    public QueryTableModel(Set _appSet) {        appSet = _appSet;    }    public int getRowCount() {        return appSet.size();    }    public boolean isCellEditable(int rowIndex, int columnIndex) {        return true;    }    public void requestRefresh() {        /* Used to refresh the table */        super.fireTableDataChanged();    }    public int getColumnCount() {        return 4;    }    public void setValueAt(Object aValue, int r, int c) {        Iterator iter = appSet.iterator();        int iCurrentRow = 0;        while (iter.hasNext()) {            Map.Entry entry = (Map.Entry) iter.next();            if (iCurrentRow == r) {                QueryBean query = (QueryBean) entry.getValue();                switch (c) {                    case 0:                        break; // column 1 not editable                    case 1:                        query.setCondition((String) aValue);                        break;                    case 2:                        query.setAggregateCondition((String) aValue);                        break;                    case 3:                        query.setOrder((String) aValue);                }            }            iCurrentRow++;        }    }    public Object getValueAt(int r, int c) {        Iterator iter = appSet.iterator();        int iCurrentRow = 0;        while (iter.hasNext()) {            Map.Entry entry = (Map.Entry) iter.next();            if (iCurrentRow == r) {                QueryBean query = (QueryBean) entry.getValue();                switch (c) {                    case 0:                        return entry.getKey();                    case 1:                        return query.getCondition();                    case 2:                        return query.getAggregateCondition();                    case 3:                        return query.getOrder();                }            }            iCurrentRow++;        }        return "no value dude";    }    public String getColumnName(int c) {        switch (c) {            case 0:                return "Field Name";            case 1:                return "Condition";            case 2:                return "Aggregate Condition";            case 3:                return "Order";        }        return "no value dude";    }    private Set appSet;} //}}}