/* SearchBean - Decompiled by JODE
 * Visit http://jode.sourceforge.net/
 */
package psdi.webclient.beans.woreq;
import java.rmi.RemoteException;

import psdi.mbo.MboRemote;
import psdi.util.MXException;
import psdi.webclient.system.beans.DataBean;

public class SearchBean extends DataBean
{
    public int clear() throws MXException, RemoteException {
        DataBean databean = app.getDataBean("search");
        databean.setValue("wonum", "", 2L);
        databean.setValue("description", "", 2L);
        //databean.setValue("HDUNIT", "", 2L);
        databean.setValue("assetnum", "", 2L);
        databean.setValue("location", "", 2L);
        databean.setValue("HDDEPT", "", 2L);
        databean.setValue("HDONGROUP", "", 2L);
        databean.setValue("WO18", "", 2L);
        databean.setValue("DATEFROM", "", 2L);
        databean.setValue("DATETO", "", 2L);
        databean.setValue("WO9", "", 2L);
        DataBean databean1 = app.getDataBean("results_showlist");
        databean1.resetQbe();
        databean1.reset();
        sessionContext.queueRefreshEvent();
        return 1;
    }

    public int find() throws MXException, RemoteException {
        MboRemote mboremote = app.getDataBean("search").getMbo();
        String s = mboremote.getString("wonum");
        String s1 = mboremote.getString("description");
        //String s2 = mboremote.getString("HDUNIT");
        String s3 = mboremote.getString("assetnum");
        String s4 = mboremote.getString("location");
        String s5 = mboremote.getString("HDDEPT");
        String s6 = mboremote.getString("HDONGROUP");
        String s7 = mboremote.getString("WO18");
        String s8 = mboremote.getString("DATEFROM");
        String s9 = mboremote.getString("DATETO");
        String s10 = mboremote.getString("WO9");
        String s11 = mboremote.getString("WOPM2");
        DataBean databean = app.getDataBean("results_showlist");
        databean.refreshTable();
        databean.resetQbe();
        databean.setQbeCaseSensitive(false);
        String[] as = { "REPORTDATE", "REPORTDATE" };
        databean.getMboSet().addSubQbe("QBE1", as, "AND");
        databean.setQbe("wonum", s);
        databean.setQbe("description", s1);
        //databean.setQbe("HDUNIT", s2);
        databean.setQbe("assetnum", s3);
        databean.setQbe("location", s4);
        databean.setQbe("HDDEPT", s5);
        databean.setQbe("HDONGROUP", s6);
        databean.setQbe("WO18", s7);
        databean.setQbe("WO9", s10);
        databean.setQbe("WOPM2", s11);
        if (s8.length() > 0)
            databean.setQbe("REPORTDATE", ">=" + s8);
        if (s9.length() > 0)
            databean.setQbe("REPORTDATE", "<=" + s9);
        //System.out.println("sql is : " + databean.getCompleteWhere());
        databean.reset();
        sessionContext.queueRefreshEvent();
        return 1;
    }
}