home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / HelpDesk_Module / Solutions.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  14.4 KB  |  546 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Container;
  3. import java.awt.Event;
  4. import java.awt.Font;
  5. import java.awt.Label;
  6. import java.awt.Panel;
  7. import java.awt.TextArea;
  8. import java.awt.TextField;
  9. import java.util.StringTokenizer;
  10. import java.util.Vector;
  11.  
  12. public class Solutions extends JDPClassLayout {
  13.    JDPUser user;
  14.    JDPJagg jaggSQL;
  15.    JDPPopupMessage popuppanel;
  16.    JDPMaskEdit JDPMaskEditMain;
  17.    String moduleParameter;
  18.    Panel Main;
  19.    JDPChiselFramePanel ChiselPanel1;
  20.    Panel Form1;
  21.    Panel Panel1;
  22.    Panel Panel2;
  23.    JDPTabSelectPanel TabPanel1;
  24.    JDPScrollPanel ScrollPanel1;
  25.    Label PROBTYPELabel1;
  26.    TextField PROBTYPE1;
  27.    Label ITEMAFFECTLabel1;
  28.    TextField ITEMAFFECT1;
  29.    Label PROBSUMMLabel1;
  30.    TextField PROBSUMM1;
  31.    Label PROBDETAILLabel1;
  32.    TextArea PROBDETAIL1;
  33.    Label CALLIDLabel1;
  34.    TextField CALLID1;
  35.    Label ENTRYDATELabel1;
  36.    JDPDate ENTRYDATE1;
  37.    JDPScrollPanel ScrollPanel2;
  38.    Label POSSOLUTNLabel1;
  39.    TextArea POSSOLUTN1;
  40.    Label WORKLOGLabel1;
  41.    TextArea WORKLOG1;
  42.    Label FINLSOLUTNLabel1;
  43.    TextArea FINLSOLUTN1;
  44.    Panel Panel3;
  45.    JDPWhereClause Form1SP1;
  46.    JDPSearchResults Form1RL1;
  47.  
  48.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  49.       this.user = var1;
  50.       this.moduleParameter = var3;
  51.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  52.       ((Container)this).setLayout(new BorderLayout());
  53.       this.popuppanel = new JDPPopupMessage(var1, this);
  54.       ((Container)this).add(this.popuppanel);
  55.       this.JDPMaskEditMain = new JDPMaskEdit();
  56.       this.Main = new Panel();
  57.       this.ChiselPanel1 = new JDPChiselFramePanel(var1, "Self Help");
  58.       this.Form1 = new Panel();
  59.       this.Panel1 = new Panel();
  60.       this.Panel2 = new Panel();
  61.       String[] var4 = new String[2];
  62.       Panel[] var5 = new Panel[]{new Panel(), null};
  63.       var5[0].setLayout(new BorderLayout());
  64.       var4[0] = "Problem Detail";
  65.       var5[1] = new Panel();
  66.       var5[1].setLayout(new BorderLayout());
  67.       var4[1] = "Solution Detail";
  68.       this.TabPanel1 = new JDPTabSelectPanel(var1, var4, var5, "North");
  69.       this.ScrollPanel1 = new JDPScrollPanel();
  70.       this.PROBTYPELabel1 = new Label("Problem Type:", 0);
  71.       this.PROBTYPE1 = new TextField("PROBTYPE", 15);
  72.       this.ITEMAFFECTLabel1 = new Label("Item Affected:", 0);
  73.       this.ITEMAFFECT1 = new TextField("ITEMAFFECT", 48);
  74.       this.PROBSUMMLabel1 = new Label("Problem Summary:", 0);
  75.       this.PROBSUMM1 = new TextField("PROBSUMM", 48);
  76.       this.PROBDETAILLabel1 = new Label("Problem Detail:", 0);
  77.       this.PROBDETAIL1 = new TextArea("PROBDETAIL", 6, 48);
  78.       this.CALLIDLabel1 = new Label("Call ID:", 0);
  79.       this.CALLID1 = new TextField("CALLID", 6);
  80.       this.ENTRYDATELabel1 = new Label("Entry Date:", 0);
  81.       this.ENTRYDATE1 = new JDPDate(var1, "", 12);
  82.       this.ScrollPanel2 = new JDPScrollPanel();
  83.       this.POSSOLUTNLabel1 = new Label("Poss Solution:", 0);
  84.       this.POSSOLUTN1 = new TextArea("POSSOLUTN", 4, 48);
  85.       this.WORKLOGLabel1 = new Label("Work Log:", 0);
  86.       this.WORKLOG1 = new TextArea("WORKLOG", 4, 48);
  87.       this.FINLSOLUTNLabel1 = new Label("Final Solution:", 0);
  88.       this.FINLSOLUTN1 = new TextArea("FINLSOLUTN", 6, 48);
  89.       this.Panel3 = new Panel();
  90.       this.Main.setLayout(new BorderLayout());
  91.       ((Container)this).add("Center", this.Main);
  92.       this.Main.add("Center", this.ChiselPanel1);
  93.       this.ChiselPanel1.add("Center", this.Form1);
  94.       this.Form1.setLayout(new BorderLayout());
  95.       this.Form1Main();
  96.       this.Form1.add("Center", this.Panel1);
  97.       this.Panel1.setLayout(new BorderLayout());
  98.       this.Panel1.add("Center", this.Panel2);
  99.       this.Panel2.setLayout(new BorderLayout());
  100.       this.Panel2.add("Center", this.TabPanel1);
  101.       var5[0].add("Center", this.ScrollPanel1);
  102.       this.ScrollPanel1.add("Left", this.PROBTYPELabel1);
  103.       this.ScrollPanel1.add("Right", this.PROBTYPE1);
  104.       this.ScrollPanel1.add("Left", this.ITEMAFFECTLabel1);
  105.       this.ScrollPanel1.add("Right", this.ITEMAFFECT1);
  106.       this.ScrollPanel1.add("Left", this.PROBSUMMLabel1);
  107.       this.ScrollPanel1.add("Right", this.PROBSUMM1);
  108.       this.ScrollPanel1.add("Left", this.PROBDETAILLabel1);
  109.       this.ScrollPanel1.add("Right", this.PROBDETAIL1);
  110.       this.ScrollPanel1.add("Left", this.CALLIDLabel1);
  111.       this.ScrollPanel1.add("Right", this.CALLID1);
  112.       this.ScrollPanel1.add("Left", this.ENTRYDATELabel1);
  113.       this.ScrollPanel1.add("Right", this.ENTRYDATE1);
  114.       var5[1].add("Center", this.ScrollPanel2);
  115.       this.ScrollPanel2.add("Left", this.POSSOLUTNLabel1);
  116.       this.ScrollPanel2.add("Right", this.POSSOLUTN1);
  117.       this.ScrollPanel2.add("Left", this.WORKLOGLabel1);
  118.       this.ScrollPanel2.add("Right", this.WORKLOG1);
  119.       this.ScrollPanel2.add("Left", this.FINLSOLUTNLabel1);
  120.       this.ScrollPanel2.add("Right", this.FINLSOLUTN1);
  121.       this.Form1.add("West", this.Panel3);
  122.       this.Panel3.setLayout(new BorderLayout());
  123.       this.Panel3.add("North", this.Form1SP1);
  124.       this.Panel3.add("Center", this.Form1RL1);
  125.       this.TabPanel1.setTabcolor(0, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
  126.       this.TabPanel1.setTabcolor(1, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
  127.       this.ScrollPanel1.setFont(new Font("Helvetica", 0, 11));
  128.       this.ScrollPanel1.setForeground(var1.u._cvtcolor("Black"));
  129.       this.ScrollPanel1.setBackground(var1.u._cvtcolor("LightGray"));
  130.       this.PROBTYPELabel1.setFont(new Font("Helvetica", 1, 11));
  131.       this.PROBTYPE1.setEditable(false);
  132.       this.popuppanel.addComponent(this.PROBTYPE1, "Problem Type", "This is the area in which the problem occured.");
  133.       this.PROBTYPE1.setEditable(false);
  134.       this.ITEMAFFECTLabel1.setFont(new Font("Helvetica", 1, 11));
  135.       this.ITEMAFFECT1.setEditable(false);
  136.       this.popuppanel.addComponent(this.ITEMAFFECT1, "Item Affected", "Short description of the item affected.");
  137.       this.ITEMAFFECT1.setEditable(false);
  138.       this.PROBSUMMLabel1.setFont(new Font("Helvetica", 1, 11));
  139.       this.PROBSUMM1.setEditable(false);
  140.       this.popuppanel.addComponent(this.PROBSUMM1, "Problem Summary", "A short summary of the problem.");
  141.       this.PROBSUMM1.setEditable(false);
  142.       this.PROBDETAILLabel1.setFont(new Font("Helvetica", 1, 11));
  143.       this.PROBDETAIL1.setEditable(false);
  144.       this.popuppanel.addComponent(this.PROBDETAIL1, "Problem Detail", "A detailed description of the problem.");
  145.       this.PROBDETAIL1.setEditable(false);
  146.       this.CALLIDLabel1.setFont(new Font("Helvetica", 1, 11));
  147.       this.CALLID1.setEditable(false);
  148.       this.popuppanel.addComponent(this.CALLID1, "Call ID", "The Call ID.");
  149.       this.CALLID1.setEditable(false);
  150.       this.ENTRYDATELabel1.setFont(new Font("Helvetica", 1, 11));
  151.       this.ENTRYDATE1.setEditable(false);
  152.       this.popuppanel.addComponent(this.ENTRYDATE1, "Entry Date", "Date the problem was reported.");
  153.       this.ENTRYDATE1.setEditable(false);
  154.       this.ScrollPanel2.setFont(new Font("Helvetica", 0, 11));
  155.       this.ScrollPanel2.setForeground(var1.u._cvtcolor("Black"));
  156.       this.ScrollPanel2.setBackground(var1.u._cvtcolor("LightGray"));
  157.       this.POSSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
  158.       this.POSSOLUTN1.setEditable(false);
  159.       this.popuppanel.addComponent(this.POSSOLUTN1, "Possible Solution", "Suggested alternatives to the final solution.");
  160.       this.POSSOLUTN1.setEditable(false);
  161.       this.WORKLOGLabel1.setFont(new Font("Helvetica", 1, 11));
  162.       this.WORKLOG1.setEditable(false);
  163.       this.popuppanel.addComponent(this.WORKLOG1, "Work Log", "What work was done to fix the problem.");
  164.       this.WORKLOG1.setEditable(false);
  165.       this.FINLSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
  166.       this.FINLSOLUTN1.setEditable(false);
  167.       this.popuppanel.addComponent(this.FINLSOLUTN1, "Final Solution", "The final outcome of the problem.");
  168.       this.FINLSOLUTN1.setEditable(false);
  169.       this.InitComponents();
  170.       var1.gParm.addElement(this);
  171.    }
  172.  
  173.    public boolean handleEvent(Event var1) {
  174.       switch (var1.id) {
  175.          case 401:
  176.             if (var1.key == 9 && var1.modifiers != 1) {
  177.                if (var1.target.equals(this.PROBTYPE1)) {
  178.                   this.user.u.cursor(this.ITEMAFFECT1);
  179.                   return true;
  180.                }
  181.  
  182.                if (var1.target.equals(this.ITEMAFFECT1)) {
  183.                   this.user.u.cursor(this.PROBSUMM1);
  184.                   return true;
  185.                }
  186.  
  187.                if (var1.target.equals(this.PROBSUMM1)) {
  188.                   this.user.u.cursor(this.PROBDETAIL1);
  189.                   return true;
  190.                }
  191.  
  192.                if (var1.target.equals(this.PROBDETAIL1)) {
  193.                   this.user.u.cursor(this.CALLID1);
  194.                   return true;
  195.                }
  196.  
  197.                if (var1.target.equals(this.CALLID1)) {
  198.                   this.user.u.cursor(this.ENTRYDATE1);
  199.                   return true;
  200.                }
  201.  
  202.                if (var1.target.equals(this.ENTRYDATE1)) {
  203.                   this.user.u.cursor(this.POSSOLUTN1);
  204.                   return true;
  205.                }
  206.  
  207.                if (var1.target.equals(this.POSSOLUTN1)) {
  208.                   this.user.u.cursor(this.WORKLOG1);
  209.                   return true;
  210.                }
  211.  
  212.                if (var1.target.equals(this.WORKLOG1)) {
  213.                   this.user.u.cursor(this.FINLSOLUTN1);
  214.                   return true;
  215.                }
  216.  
  217.                if (var1.target.equals(this.FINLSOLUTN1)) {
  218.                   this.user.u.cursor(this.PROBTYPE1);
  219.                   return true;
  220.                }
  221.             }
  222.  
  223.             if (var1.key == 9 && var1.modifiers == 1) {
  224.                if (var1.target.equals(this.PROBTYPE1)) {
  225.                   this.user.u.cursor(this.FINLSOLUTN1);
  226.                   return true;
  227.                }
  228.  
  229.                if (var1.target.equals(this.ITEMAFFECT1)) {
  230.                   this.user.u.cursor(this.PROBTYPE1);
  231.                   return true;
  232.                }
  233.  
  234.                if (var1.target.equals(this.PROBSUMM1)) {
  235.                   this.user.u.cursor(this.ITEMAFFECT1);
  236.                   return true;
  237.                }
  238.  
  239.                if (var1.target.equals(this.PROBDETAIL1)) {
  240.                   this.user.u.cursor(this.PROBSUMM1);
  241.                   return true;
  242.                }
  243.  
  244.                if (var1.target.equals(this.CALLID1)) {
  245.                   this.user.u.cursor(this.PROBDETAIL1);
  246.                   return true;
  247.                }
  248.  
  249.                if (var1.target.equals(this.ENTRYDATE1)) {
  250.                   this.user.u.cursor(this.CALLID1);
  251.                   return true;
  252.                }
  253.  
  254.                if (var1.target.equals(this.POSSOLUTN1)) {
  255.                   this.user.u.cursor(this.ENTRYDATE1);
  256.                   return true;
  257.                }
  258.  
  259.                if (var1.target.equals(this.WORKLOG1)) {
  260.                   this.user.u.cursor(this.POSSOLUTN1);
  261.                   return true;
  262.                }
  263.  
  264.                if (var1.target.equals(this.FINLSOLUTN1)) {
  265.                   this.user.u.cursor(this.WORKLOG1);
  266.                   return true;
  267.                }
  268.             }
  269.  
  270.             return false;
  271.          case 503:
  272.          case 504:
  273.          case 505:
  274.             this.popuppanel.postEvent(var1);
  275.             return false;
  276.          case 1001:
  277.             if (var1.target.equals(this.Form1SP1)) {
  278.                this.Form1RL1.clearList();
  279.                this.Form1RL1.setFromWhereClause(this.Form1SP1.getFromWhereClause());
  280.                this.Form1RL1.loadList();
  281.                return true;
  282.             } else {
  283.                if (var1.target.equals(this.Form1RL1)) {
  284.                   this.Form1Load(this.Form1RL1.getSelectedKey());
  285.                   return true;
  286.                }
  287.  
  288.                return false;
  289.             }
  290.          default:
  291.             return false;
  292.       }
  293.    }
  294.  
  295.    public void InitComponents() {
  296.       this.jaggSQL.setKeepConnectionOpen(false);
  297.    }
  298.  
  299.    public void Form1Main() {
  300.       this.Form1LoadChoices();
  301.       this.Form1ClearFields();
  302.       this.Form1WhereClauseMain();
  303.       this.Form1SearchResultsMain();
  304.    }
  305.  
  306.    public void Form1Load(String[] var1) {
  307.       int var3 = 0;
  308.       Vector var4 = new Vector();
  309.       String var5 = this.jaggSQL.getSEP();
  310.       if (var1 != null && var1.length >= 0) {
  311.          String var7 = "SELECT PROBTYPE,ITEMAFFECT,POSSOLUTN,PROBSUMM,PROBDETAIL,CALLID,WORKLOG,ENTRYDATE,FINLSOLUTN FROM JDPHelpDesk WHERE (1=1)";
  312.          if (var1.length > 0 && var1[0] != null) {
  313.             var7 = var7 + " AND CALLID=" + var1[0] + "";
  314.          }
  315.  
  316.          this.jaggSQL.setDSN("JDPHelpDesk");
  317.          this.jaggSQL.setUID("");
  318.          this.jaggSQL.setPWD("");
  319.          this.jaggSQL.setMRW("1000");
  320.          this.jaggSQL.setTOUT("60");
  321.          this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
  322.          var3 = this.jaggSQL.execSQL(var7, var4);
  323.          if (var3 == -1) {
  324.             this.user.u.setSqlMessage(this.jaggSQL, var7);
  325.          } else if (var3 >= 1) {
  326.             String var6 = (String)var4.elementAt(0);
  327.             if (var6 != null && var6.trim().compareTo("") != 0) {
  328.                StringTokenizer var2 = new StringTokenizer(var6, var5);
  329.                this.PROBTYPE1.setText(var2.nextToken().trim());
  330.                this.ITEMAFFECT1.setText(var2.nextToken().trim());
  331.                this.POSSOLUTN1.setText(var2.nextToken().trim());
  332.                this.PROBSUMM1.setText(var2.nextToken().trim());
  333.                this.PROBDETAIL1.setText(var2.nextToken().trim());
  334.                this.CALLID1.setText(var2.nextToken().trim());
  335.                this.WORKLOG1.setText(var2.nextToken().trim());
  336.                this.ENTRYDATE1.setText(JDPDate.format(Long.valueOf(var2.nextToken())));
  337.                this.FINLSOLUTN1.setText(var2.nextToken().trim());
  338.             }
  339.  
  340.             if (var3 > 1) {
  341.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message1"), 10);
  342.             } else {
  343.                this.user.mainmsg.clearStatusMsg();
  344.             }
  345.          } else {
  346.             this.user.mainmsg.setStatusMsg(JDPLang.get("Message2"), 10);
  347.             this.Form1ClearFields();
  348.          }
  349.       } else {
  350.          this.Form1ClearFields();
  351.       }
  352.    }
  353.  
  354.    public boolean Form1updateRow(String[] var1) {
  355.       return this.Form1CheckFields() ? this.Form1Save(var1, "U") : false;
  356.    }
  357.  
  358.    public boolean Form1insertRow(String[] var1) {
  359.       return this.Form1CheckFields() ? this.Form1Save(var1, "I") : false;
  360.    }
  361.  
  362.    public boolean Form1removeRow(String[] var1) {
  363.       return this.Form1Save(var1, "D");
  364.    }
  365.  
  366.    boolean Form1Save(String[] var1, String var2) {
  367.       int var3 = 0;
  368.       Vector var4 = new Vector();
  369.       this.jaggSQL.getSEP();
  370.       String var5 = "";
  371.       Object var6 = null;
  372.       if (var2.equals("I")) {
  373.          var5 = "INSERT INTO JDPHelpDesk (LASTNAME, FIRSTNAME, EMPID, PHONE, EMAIL, PROBTYPE, ITEMAFFECT, POSSOLUTN, PROBSUMM, IMPACT, PROBDETAIL, WORKLOG, ASSIGNEDTO, STATUS, ENTRYDATE, FINLSOLUTN) VALUES('', '', '', '', '', '" + this.user.u.replace(this.PROBTYPE1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.ITEMAFFECT1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.POSSOLUTN1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.PROBSUMM1.getText(), "'", "''") + "', " + "'', " + "'" + this.user.u.replace(this.PROBDETAIL1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.WORKLOG1.getText(), "'", "''") + "', " + "'', " + "'', " + "'" + JDPDate.format(this.ENTRYDATE1.getText()) + "', " + "'" + this.user.u.replace(this.FINLSOLUTN1.getText(), "'", "''") + "')";
  374.       } else {
  375.          if (var1 == null || var1.length == 0) {
  376.             this.user.mainmsg.setStatusMsg(JDPLang.get("Message3"), 5);
  377.             return false;
  378.          }
  379.  
  380.          if (var2.equals("D")) {
  381.             var5 = "DELETE FROM JDPHelpDesk WHERE CALLID=" + var1[0];
  382.          } else {
  383.             var5 = "UPDATE JDPHelpDesk SET  WHERE CALLID=" + var1[0];
  384.          }
  385.       }
  386.  
  387.       this.jaggSQL.setDSN("JDPHelpDesk");
  388.       this.jaggSQL.setUID("");
  389.       this.jaggSQL.setPWD("");
  390.       this.jaggSQL.setMRW("1000");
  391.       this.jaggSQL.setTOUT("60");
  392.       this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
  393.       var3 = this.jaggSQL.execSQL(var5, var4);
  394.       if (var3 == 0 && var6 != null) {
  395.          String[] var7 = new String[]{JDPLang.get("Reload"), JDPLang.get("Update")};
  396.          int[] var8 = new int[]{6, 0};
  397.          JDPMessageDialog var9 = new JDPMessageDialog(this.user, this.user.jdpMainWindow, JDPLang.get("Dialog0"), JDPLang.get("Dialog1"), var7, var8);
  398.          ((JDPDialog)var9).display();
  399.          if (var9.getPressedButton() != 1) {
  400.             this.Form1Load(var1);
  401.             return true;
  402.          }
  403.  
  404.          var4 = new Vector();
  405.          var3 = this.jaggSQL.execSQL((String)var6, var4);
  406.       }
  407.  
  408.       if (var3 == -1) {
  409.          this.user.u.setSqlMessage(this.jaggSQL, var5);
  410.          return false;
  411.       } else {
  412.          if (var3 == 1) {
  413.             if (var2.equals("I")) {
  414.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message4"), 3);
  415.             } else if (var2.equals("D")) {
  416.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message5"), 3);
  417.             } else {
  418.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message6"), 3);
  419.             }
  420.          } else {
  421.             this.user.u.setSqlMessage(this.jaggSQL, var5);
  422.          }
  423.  
  424.          if (var6 != null) {
  425.             this.Form1Load(var1);
  426.          }
  427.  
  428.          return true;
  429.       }
  430.    }
  431.  
  432.    public void Form1ClearFields() {
  433.       this.PROBTYPE1.setText("");
  434.       this.ITEMAFFECT1.setText("");
  435.       this.POSSOLUTN1.setText("");
  436.       this.PROBSUMM1.setText("");
  437.       this.PROBDETAIL1.setText("");
  438.       this.CALLID1.setText("");
  439.       this.WORKLOG1.setText("");
  440.       this.ENTRYDATE1.setText("");
  441.       this.FINLSOLUTN1.setText("");
  442.    }
  443.  
  444.    void Form1LoadChoices() {
  445.       this.jaggSQL.setDSN("JDPHelpDesk");
  446.       this.jaggSQL.setUID("");
  447.       this.jaggSQL.setPWD("");
  448.       this.jaggSQL.setMRW("1000");
  449.       this.jaggSQL.setTOUT("60");
  450.    }
  451.  
  452.    public boolean Form1CheckFields() {
  453.       return true;
  454.    }
  455.  
  456.    public void Form1WhereClauseMain() {
  457.       String[] var1 = new String[4];
  458.       String[] var2 = new String[4];
  459.       Vector var3 = new Vector();
  460.       Vector var4 = new Vector();
  461.       var1[0] = "Problem Type";
  462.       var2[0] = "PROBTYPE";
  463.       var1[1] = "Item Affected";
  464.       var2[1] = "ITEMAFFECT";
  465.       var1[2] = "Call ID";
  466.       var2[2] = "CALLID";
  467.       var1[3] = "Entry Date";
  468.       var2[3] = "format(ENTRYDATE, 'yyyy/mm/dd')";
  469.       var3.addElement(new Vector());
  470.       var4.addElement(new Vector());
  471.       var3.addElement(new Vector());
  472.       var4.addElement(new Vector());
  473.       var3.addElement(new Vector());
  474.       var4.addElement(new Vector());
  475.       var3.addElement(new Vector());
  476.       var4.addElement(new Vector());
  477.       this.jaggSQL.setDSN("JDPHelpDesk");
  478.       this.jaggSQL.setUID("");
  479.       this.jaggSQL.setPWD("");
  480.       this.jaggSQL.setMRW("1000");
  481.       this.jaggSQL.setTOUT("60");
  482.       JDPLoadChoice var5 = new JDPLoadChoice(this.user, this.jaggSQL, (Object)null, "", "", "", "", -1);
  483.       var5.loadChoice((Vector)var3.elementAt(0), "PROBTYPE", "PROBTYPE", "JDPProbType", "(1=1)", (Vector)var4.elementAt(0), 12);
  484.       ((Vector)var3.elementAt(1)).addElement("Begins with");
  485.       ((Vector)var4.elementAt(1)).addElement("like");
  486.       ((Vector)var3.elementAt(1)).addElement("Contains");
  487.       ((Vector)var4.elementAt(1)).addElement("like");
  488.       ((Vector)var3.elementAt(2)).addElement("Greater than");
  489.       ((Vector)var4.elementAt(2)).addElement(">");
  490.       ((Vector)var3.elementAt(2)).addElement("Less than");
  491.       ((Vector)var4.elementAt(2)).addElement("<");
  492.       ((Vector)var3.elementAt(2)).addElement("Equal to");
  493.       ((Vector)var4.elementAt(2)).addElement("=");
  494.       ((Vector)var3.elementAt(3)).addElement("Equals");
  495.       ((Vector)var4.elementAt(3)).addElement("=");
  496.       ((Vector)var3.elementAt(3)).addElement("Less than");
  497.       ((Vector)var4.elementAt(3)).addElement("<");
  498.       ((Vector)var3.elementAt(3)).addElement("Greater than");
  499.       ((Vector)var4.elementAt(3)).addElement(">");
  500.       ((Vector)var3.elementAt(3)).addElement("Less than or equal");
  501.       ((Vector)var4.elementAt(3)).addElement("<=");
  502.       ((Vector)var3.elementAt(3)).addElement("Greater than or equal");
  503.       ((Vector)var4.elementAt(3)).addElement(">=");
  504.       int[] var6 = new int[4];
  505.       boolean[] var7 = new boolean[4];
  506.       var6[0] = 0;
  507.       var7[0] = true;
  508.       var6[1] = 54;
  509.       var7[1] = true;
  510.       var6[2] = 8;
  511.       var7[2] = false;
  512.       var6[3] = 14;
  513.       var7[3] = true;
  514.       this.Form1SP1 = new JDPWhereClause(this.user, super.targetPanel, "", true, "Problem Type", var1, var2, var3, var4, (String[][])null, (String[][])null, var6, var7, "FROM JDPHelpDesk WHERE (1=1)");
  515.       this.Form1SP1.setDSNType("ACCESS");
  516.       this.Form1SP1.setDataType(0, 12);
  517.       this.Form1SP1.setDataType(1, 12);
  518.       this.Form1SP1.setDataType(2, 4);
  519.       this.Form1SP1.setDataType(3, 11);
  520.    }
  521.  
  522.    public void Form1SearchResultsMain() {
  523.       String var1 = "CALLID";
  524.       String[] var2 = new String[]{"ITEMAFFECT"};
  525.       String var3 = "Status='Closed'";
  526.       String[] var4 = new String[]{"Problem Type"};
  527.       String[] var5 = new String[]{"PROBTYPE"};
  528.       JDPJagg var6 = new JDPJagg(this.user.jaggPath);
  529.       var6.setDSN("JDPHelpDesk");
  530.       var6.setUID("");
  531.       var6.setPWD("");
  532.       var6.setMRW("1000");
  533.       var6.setTOUT("60");
  534.       this.Form1RL1 = new JDPSearchResults(this.user, super.targetPanel, true, var6, false, var1, var2, var3, var4, var5, var5, "Problem Type", true, "Total Entries:");
  535.       int[] var7 = new int[19];
  536.       var7[0] = 0;
  537.       var7[1] = 0;
  538.       var7[2] = 1;
  539.       this.Form1RL1.setMinWidth(130);
  540.       this.Form1RL1.setIcons(var7);
  541.       this.Form1RL1.setFromWhereClause(" FROM JDPHelpDesk WHERE Status='Closed'");
  542.       this.Form1RL1.clearList("Problem Type");
  543.       this.Form1RL1.loadList();
  544.    }
  545. }
  546.