home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / HelpDesk_Module / RequestDetail.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  19.2 KB  |  760 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 RequestDetail extends JDPClassLayout {
  13.    JDPUser user;
  14.    JDPJagg jaggSQL;
  15.    JDPPopupMessage popuppanel;
  16.    JDPMaskEdit JDPMaskEditMain;
  17.    String moduleParameter;
  18.    Panel Main;
  19.    JDPEmailSender EMail1;
  20.    JDPChiselFramePanel ChiselPanel1;
  21.    Panel Panel3;
  22.    Panel Panel1;
  23.    JDPButtons JDPButtons1;
  24.    Panel Columns1;
  25.    JDPTabSelectPanel TabPanel1;
  26.    JDPScrollPanel ScrollPanel1;
  27.    Label LASTNAMELabel1;
  28.    Panel LASTNAMELine1;
  29.    TextField LASTNAME1;
  30.    TextField FIRSTNAME1;
  31.    TextField EMPID1;
  32.    Label PHONELabel1;
  33.    Panel PHONELine1;
  34.    TextField PHONE1;
  35.    TextField EMAIL1;
  36.    Label PROBTYPELabel1;
  37.    TextField PROBTYPE1;
  38.    Label ITEMAFFECTLabel1;
  39.    TextField ITEMAFFECT1;
  40.    Label PROBSUMMLabel1;
  41.    TextField PROBSUMM1;
  42.    Label CALLIDLabel1;
  43.    Panel CALLIDLine1;
  44.    TextField CALLID1;
  45.    JDPDate ENTRYDATE1;
  46.    Label IMPACTLabel1;
  47.    JDPChoice IMPACT1;
  48.    Vector valueIMPACT1;
  49.    Label ASSIGNEDTOLabel1;
  50.    Panel ASSIGNEDTOLine1;
  51.    TextField ASSIGNEDTO1;
  52.    Label STATUSLabel1;
  53.    JDPChoice STATUS1;
  54.    Vector valueSTATUS1;
  55.    Label FINLSOLUTNLabel1;
  56.    TextArea FINLSOLUTN1;
  57.    JDPScrollPanel ScrollPanel2;
  58.    Label PROBDETAILLabel1;
  59.    TextArea PROBDETAIL1;
  60.    Label POSSOLUTNLabel1;
  61.    TextArea POSSOLUTN1;
  62.    Label WORKLOGLabel1;
  63.    TextArea WORKLOG1;
  64.    Panel Panel2;
  65.    JDPSearchResults ResultList1;
  66.    JDPWhereClause SearchPanel1;
  67.  
  68.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  69.       this.user = var1;
  70.       this.moduleParameter = var3;
  71.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  72.       ((Container)this).setLayout(new BorderLayout());
  73.       this.popuppanel = new JDPPopupMessage(var1, this);
  74.       ((Container)this).add(this.popuppanel);
  75.       this.JDPMaskEditMain = new JDPMaskEdit();
  76.       this.Main = new Panel();
  77.       this.EMail1 = new JDPEmailSender(var1);
  78.       this.ChiselPanel1 = new JDPChiselFramePanel(var1, "Support Request Detail");
  79.       this.Panel3 = new Panel();
  80.       this.Panel1 = new Panel();
  81.       String[] var4 = new String[]{"Apply Changes", "Send Email Status Report"};
  82.       int[] var5 = new int[]{JDPButton.getIconValue("Save"), JDPButton.getIconValue("Email")};
  83.       this.JDPButtons1 = new JDPButtons(var1, var4, var5, JDPButtons.getAlignmentValue("Horizontal"));
  84.       this.Columns1 = new Panel();
  85.       String[] var6 = new String[2];
  86.       Panel[] var7 = new Panel[]{new Panel(), null};
  87.       var7[0].setLayout(new BorderLayout());
  88.       var6[0] = "Employee Detail";
  89.       var7[1] = new Panel();
  90.       var7[1].setLayout(new BorderLayout());
  91.       var6[1] = "Problem Detail";
  92.       this.TabPanel1 = new JDPTabSelectPanel(var1, var6, var7, "North");
  93.       this.ScrollPanel1 = new JDPScrollPanel();
  94.       this.LASTNAMELabel1 = new Label("Last / First / ID:", 0);
  95.       this.LASTNAMELine1 = new Panel();
  96.       this.LASTNAME1 = new TextField("LASTNAME", 15);
  97.       this.FIRSTNAME1 = new TextField("FIRSTNAME", 15);
  98.       this.EMPID1 = new TextField("EMPID", 15);
  99.       this.PHONELabel1 = new Label("Phone / Email:", 0);
  100.       this.PHONELine1 = new Panel();
  101.       this.PHONE1 = new TextField("PHONE", 13);
  102.       this.EMAIL1 = new TextField("EMAIL", 35);
  103.       this.PROBTYPELabel1 = new Label("Problem Type:", 0);
  104.       this.PROBTYPE1 = new TextField("PROBTYPE", 10);
  105.       this.ITEMAFFECTLabel1 = new Label("Item Affected:", 0);
  106.       this.ITEMAFFECT1 = new TextField("ITEMAFFECT", 50);
  107.       this.PROBSUMMLabel1 = new Label("Problem Summary:", 0);
  108.       this.PROBSUMM1 = new TextField("PROBSUMM", 50);
  109.       this.CALLIDLabel1 = new Label("Call ID / Date:", 0);
  110.       this.CALLIDLine1 = new Panel();
  111.       this.CALLID1 = new TextField("CALLID", 10);
  112.       this.ENTRYDATE1 = new JDPDate(var1, "", 19);
  113.       this.IMPACTLabel1 = new Label("Impact:", 0);
  114.       this.IMPACT1 = new JDPChoice();
  115.       this.ASSIGNEDTOLabel1 = new Label("Assigned To:", 0);
  116.       this.ASSIGNEDTOLine1 = new Panel();
  117.       this.ASSIGNEDTO1 = new TextField("ASSIGNEDTO", 15);
  118.       this.STATUSLabel1 = new Label("Status:", 0);
  119.       this.STATUS1 = new JDPChoice();
  120.       this.FINLSOLUTNLabel1 = new Label("Final Solution:", 0);
  121.       this.FINLSOLUTN1 = new TextArea("FINLSOLUTN", 6, 60);
  122.       this.ScrollPanel2 = new JDPScrollPanel();
  123.       this.PROBDETAILLabel1 = new Label("Problem Detail:", 0);
  124.       this.PROBDETAIL1 = new TextArea("PROBDETAIL", 6, 60);
  125.       this.POSSOLUTNLabel1 = new Label("Possible Solution:", 0);
  126.       this.POSSOLUTN1 = new TextArea("POSSOLUTN", 6, 60);
  127.       this.WORKLOGLabel1 = new Label("Work Log:", 0);
  128.       this.WORKLOG1 = new TextArea("WORKLOG", 6, 60);
  129.       this.Panel2 = new Panel();
  130.       this.ResultList1Main();
  131.       this.SearchPanel1Main();
  132.       this.Main.setLayout(new BorderLayout());
  133.       ((Container)this).add("Center", this.Main);
  134.       this.Main.add("Center", this.ChiselPanel1);
  135.       this.ChiselPanel1.add("Center", this.Panel3);
  136.       this.Panel3.setLayout(new BorderLayout());
  137.       this.Panel3.add("Center", this.Panel1);
  138.       this.Panel1.setLayout(new BorderLayout());
  139.       this.Panel1.add("South", this.JDPButtons1);
  140.       this.Panel1.add("Center", this.Columns1);
  141.       this.Columns1.setLayout(new BorderLayout());
  142.       this.Columns1Main();
  143.       this.Columns1.add("Center", this.TabPanel1);
  144.       var7[0].add("Center", this.ScrollPanel1);
  145.       this.ScrollPanel1.add("Left", this.LASTNAMELabel1);
  146.       this.ScrollPanel1.add("Right", this.LASTNAMELine1);
  147.       this.LASTNAMELine1.setLayout(new JDPLineLayout());
  148.       this.LASTNAMELine1.add("Left", this.LASTNAME1);
  149.       this.LASTNAMELine1.add("Left", this.FIRSTNAME1);
  150.       this.LASTNAMELine1.add("Left", this.EMPID1);
  151.       this.ScrollPanel1.add("Left", this.PHONELabel1);
  152.       this.ScrollPanel1.add("Right", this.PHONELine1);
  153.       this.PHONELine1.setLayout(new JDPLineLayout());
  154.       this.PHONELine1.add("Left", this.PHONE1);
  155.       this.PHONELine1.add("Left", this.EMAIL1);
  156.       this.ScrollPanel1.add("Left", this.PROBTYPELabel1);
  157.       this.ScrollPanel1.add("Right", this.PROBTYPE1);
  158.       this.ScrollPanel1.add("Left", this.ITEMAFFECTLabel1);
  159.       this.ScrollPanel1.add("Right", this.ITEMAFFECT1);
  160.       this.ScrollPanel1.add("Left", this.PROBSUMMLabel1);
  161.       this.ScrollPanel1.add("Right", this.PROBSUMM1);
  162.       this.ScrollPanel1.add("Left", this.CALLIDLabel1);
  163.       this.ScrollPanel1.add("Right", this.CALLIDLine1);
  164.       this.CALLIDLine1.setLayout(new JDPLineLayout());
  165.       this.CALLIDLine1.add("Left", this.CALLID1);
  166.       this.CALLIDLine1.add("Left", this.ENTRYDATE1);
  167.       this.CALLIDLine1.add("Left", this.IMPACTLabel1);
  168.       this.CALLIDLine1.add("Left", this.IMPACT1);
  169.       this.ScrollPanel1.add("Left", this.ASSIGNEDTOLabel1);
  170.       this.ScrollPanel1.add("Right", this.ASSIGNEDTOLine1);
  171.       this.ASSIGNEDTOLine1.setLayout(new JDPLineLayout());
  172.       this.ASSIGNEDTOLine1.add("Left", this.ASSIGNEDTO1);
  173.       this.ASSIGNEDTOLine1.add("Left", this.STATUSLabel1);
  174.       this.ASSIGNEDTOLine1.add("Left", this.STATUS1);
  175.       this.ScrollPanel1.add("Left", this.FINLSOLUTNLabel1);
  176.       this.ScrollPanel1.add("Right", this.FINLSOLUTN1);
  177.       var7[1].add("Center", this.ScrollPanel2);
  178.       this.ScrollPanel2.add("Left", this.PROBDETAILLabel1);
  179.       this.ScrollPanel2.add("Right", this.PROBDETAIL1);
  180.       this.ScrollPanel2.add("Left", this.POSSOLUTNLabel1);
  181.       this.ScrollPanel2.add("Right", this.POSSOLUTN1);
  182.       this.ScrollPanel2.add("Left", this.WORKLOGLabel1);
  183.       this.ScrollPanel2.add("Right", this.WORKLOG1);
  184.       this.Panel3.add("West", this.Panel2);
  185.       this.Panel2.setLayout(new BorderLayout());
  186.       this.Panel2.add("Center", this.ResultList1);
  187.       this.Panel2.add("North", this.SearchPanel1);
  188.       this.ChiselPanel1.setFont(new Font("Helvetica", 0, 11));
  189.       this.ChiselPanel1.setForeground(var1.u._cvtcolor("Black"));
  190.       this.ChiselPanel1.setBackground(var1.u._cvtcolor("LightGray"));
  191.       this.Columns1.setFont(new Font("Helvetica", 0, 11));
  192.       this.Columns1.setForeground(var1.u._cvtcolor("Black"));
  193.       this.Columns1.setBackground(var1.u._cvtcolor("LightGray"));
  194.       this.TabPanel1.setTabcolor(0, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
  195.       this.TabPanel1.setTabcolor(1, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
  196.       this.ScrollPanel1.setFont(new Font("Helvetica", 0, 11));
  197.       this.ScrollPanel1.setForeground(var1.u._cvtcolor("Black"));
  198.       this.ScrollPanel1.setBackground(var1.u._cvtcolor("LightGray"));
  199.       this.LASTNAMELabel1.setFont(new Font("Helvetica", 1, 11));
  200.       this.popuppanel.addComponent(this.LASTNAME1, "Last Name", "");
  201.       this.popuppanel.addComponent(this.FIRSTNAME1, "First Name", "");
  202.       this.popuppanel.addComponent(this.EMPID1, "Empid", "");
  203.       this.PHONELabel1.setFont(new Font("Helvetica", 1, 11));
  204.       this.popuppanel.addComponent(this.PHONE1, "Phone", "");
  205.       this.popuppanel.addComponent(this.EMAIL1, "Email", "");
  206.       this.PROBTYPELabel1.setFont(new Font("Helvetica", 1, 11));
  207.       this.popuppanel.addComponent(this.PROBTYPE1, "Probtype", "");
  208.       this.ITEMAFFECTLabel1.setFont(new Font("Helvetica", 1, 11));
  209.       this.popuppanel.addComponent(this.ITEMAFFECT1, "Itemaffect", "");
  210.       this.PROBSUMMLabel1.setFont(new Font("Helvetica", 1, 11));
  211.       this.popuppanel.addComponent(this.PROBSUMM1, "Probsumm", "");
  212.       this.CALLIDLabel1.setFont(new Font("Helvetica", 1, 11));
  213.       this.CALLID1.setEditable(false);
  214.       this.popuppanel.addComponent(this.CALLID1, "Callid", "");
  215.       this.CALLID1.setEditable(false);
  216.       this.popuppanel.addComponent(this.ENTRYDATE1, "Entrydate", "");
  217.       this.IMPACTLabel1.setFont(new Font("Helvetica", 1, 11));
  218.       this.popuppanel.addComponent(this.IMPACT1, "Impact", "");
  219.       this.ASSIGNEDTOLabel1.setFont(new Font("Helvetica", 1, 11));
  220.       this.popuppanel.addComponent(this.ASSIGNEDTO1, "Assignedto", "");
  221.       this.STATUSLabel1.setFont(new Font("Helvetica", 1, 11));
  222.       this.popuppanel.addComponent(this.STATUS1, "Status", "");
  223.       this.FINLSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
  224.       this.popuppanel.addComponent(this.FINLSOLUTN1, "Finlsolutn", "");
  225.       this.ScrollPanel2.setFont(new Font("Helvetica", 0, 11));
  226.       this.ScrollPanel2.setForeground(var1.u._cvtcolor("Black"));
  227.       this.ScrollPanel2.setBackground(var1.u._cvtcolor("LightGray"));
  228.       this.PROBDETAILLabel1.setFont(new Font("Helvetica", 1, 11));
  229.       this.popuppanel.addComponent(this.PROBDETAIL1, "Probdetail", "");
  230.       this.POSSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
  231.       this.popuppanel.addComponent(this.POSSOLUTN1, "Possolutn", "");
  232.       this.WORKLOGLabel1.setFont(new Font("Helvetica", 1, 11));
  233.       this.popuppanel.addComponent(this.WORKLOG1, "Worklog", "");
  234.       this.InitComponents();
  235.       var1.gParm.addElement(this);
  236.    }
  237.  
  238.    public boolean handleEvent(Event var1) {
  239.       switch (var1.id) {
  240.          case 401:
  241.             if (var1.key == 9 && var1.modifiers != 1) {
  242.                if (var1.target.equals(this.LASTNAME1)) {
  243.                   this.user.u.cursor(this.FIRSTNAME1);
  244.                   return true;
  245.                }
  246.  
  247.                if (var1.target.equals(this.FIRSTNAME1)) {
  248.                   this.user.u.cursor(this.EMPID1);
  249.                   return true;
  250.                }
  251.  
  252.                if (var1.target.equals(this.EMPID1)) {
  253.                   this.user.u.cursor(this.PHONE1);
  254.                   return true;
  255.                }
  256.  
  257.                if (var1.target.equals(this.PHONE1)) {
  258.                   this.user.u.cursor(this.EMAIL1);
  259.                   return true;
  260.                }
  261.  
  262.                if (var1.target.equals(this.EMAIL1)) {
  263.                   this.user.u.cursor(this.PROBTYPE1);
  264.                   return true;
  265.                }
  266.  
  267.                if (var1.target.equals(this.PROBTYPE1)) {
  268.                   this.user.u.cursor(this.ITEMAFFECT1);
  269.                   return true;
  270.                }
  271.  
  272.                if (var1.target.equals(this.ITEMAFFECT1)) {
  273.                   this.user.u.cursor(this.PROBSUMM1);
  274.                   return true;
  275.                }
  276.  
  277.                if (var1.target.equals(this.PROBSUMM1)) {
  278.                   this.user.u.cursor(this.CALLID1);
  279.                   return true;
  280.                }
  281.  
  282.                if (var1.target.equals(this.CALLID1)) {
  283.                   this.user.u.cursor(this.ENTRYDATE1);
  284.                   return true;
  285.                }
  286.  
  287.                if (var1.target.equals(this.ENTRYDATE1)) {
  288.                   this.user.u.cursor(this.IMPACT1);
  289.                   return true;
  290.                }
  291.  
  292.                if (var1.target.equals(this.IMPACT1)) {
  293.                   this.user.u.cursor(this.ASSIGNEDTO1);
  294.                   return true;
  295.                }
  296.  
  297.                if (var1.target.equals(this.ASSIGNEDTO1)) {
  298.                   this.user.u.cursor(this.STATUS1);
  299.                   return true;
  300.                }
  301.  
  302.                if (var1.target.equals(this.STATUS1)) {
  303.                   this.user.u.cursor(this.FINLSOLUTN1);
  304.                   return true;
  305.                }
  306.  
  307.                if (var1.target.equals(this.FINLSOLUTN1)) {
  308.                   this.user.u.cursor(this.PROBDETAIL1);
  309.                   return true;
  310.                }
  311.  
  312.                if (var1.target.equals(this.PROBDETAIL1)) {
  313.                   this.user.u.cursor(this.POSSOLUTN1);
  314.                   return true;
  315.                }
  316.  
  317.                if (var1.target.equals(this.POSSOLUTN1)) {
  318.                   this.user.u.cursor(this.WORKLOG1);
  319.                   return true;
  320.                }
  321.  
  322.                if (var1.target.equals(this.WORKLOG1)) {
  323.                   this.user.u.cursor(this.LASTNAME1);
  324.                   return true;
  325.                }
  326.             }
  327.  
  328.             if (var1.key == 9 && var1.modifiers == 1) {
  329.                if (var1.target.equals(this.LASTNAME1)) {
  330.                   this.user.u.cursor(this.WORKLOG1);
  331.                   return true;
  332.                }
  333.  
  334.                if (var1.target.equals(this.FIRSTNAME1)) {
  335.                   this.user.u.cursor(this.LASTNAME1);
  336.                   return true;
  337.                }
  338.  
  339.                if (var1.target.equals(this.EMPID1)) {
  340.                   this.user.u.cursor(this.FIRSTNAME1);
  341.                   return true;
  342.                }
  343.  
  344.                if (var1.target.equals(this.PHONE1)) {
  345.                   this.user.u.cursor(this.EMPID1);
  346.                   return true;
  347.                }
  348.  
  349.                if (var1.target.equals(this.EMAIL1)) {
  350.                   this.user.u.cursor(this.PHONE1);
  351.                   return true;
  352.                }
  353.  
  354.                if (var1.target.equals(this.PROBTYPE1)) {
  355.                   this.user.u.cursor(this.EMAIL1);
  356.                   return true;
  357.                }
  358.  
  359.                if (var1.target.equals(this.ITEMAFFECT1)) {
  360.                   this.user.u.cursor(this.PROBTYPE1);
  361.                   return true;
  362.                }
  363.  
  364.                if (var1.target.equals(this.PROBSUMM1)) {
  365.                   this.user.u.cursor(this.ITEMAFFECT1);
  366.                   return true;
  367.                }
  368.  
  369.                if (var1.target.equals(this.CALLID1)) {
  370.                   this.user.u.cursor(this.PROBSUMM1);
  371.                   return true;
  372.                }
  373.  
  374.                if (var1.target.equals(this.ENTRYDATE1)) {
  375.                   this.user.u.cursor(this.CALLID1);
  376.                   return true;
  377.                }
  378.  
  379.                if (var1.target.equals(this.IMPACT1)) {
  380.                   this.user.u.cursor(this.ENTRYDATE1);
  381.                   return true;
  382.                }
  383.  
  384.                if (var1.target.equals(this.ASSIGNEDTO1)) {
  385.                   this.user.u.cursor(this.IMPACT1);
  386.                   return true;
  387.                }
  388.  
  389.                if (var1.target.equals(this.STATUS1)) {
  390.                   this.user.u.cursor(this.ASSIGNEDTO1);
  391.                   return true;
  392.                }
  393.  
  394.                if (var1.target.equals(this.FINLSOLUTN1)) {
  395.                   this.user.u.cursor(this.STATUS1);
  396.                   return true;
  397.                }
  398.  
  399.                if (var1.target.equals(this.PROBDETAIL1)) {
  400.                   this.user.u.cursor(this.FINLSOLUTN1);
  401.                   return true;
  402.                }
  403.  
  404.                if (var1.target.equals(this.POSSOLUTN1)) {
  405.                   this.user.u.cursor(this.PROBDETAIL1);
  406.                   return true;
  407.                }
  408.  
  409.                if (var1.target.equals(this.WORKLOG1)) {
  410.                   this.user.u.cursor(this.POSSOLUTN1);
  411.                   return true;
  412.                }
  413.             }
  414.  
  415.             return false;
  416.          case 503:
  417.          case 504:
  418.          case 505:
  419.             this.popuppanel.postEvent(var1);
  420.             return false;
  421.          case 1001:
  422.             if (var1.target.equals(this.JDPButtons1.button[0])) {
  423.                this.Columns1updateRow(this.ResultList1.getSelectedKey());
  424.                return true;
  425.             } else if (var1.target.equals(this.JDPButtons1.button[1])) {
  426.                this.EMail1.setMailServer("mail");
  427.                this.EMail1.setToAddress(this.EMAIL1.getText());
  428.                if (this.user.cust.getEmailaddr().equals("")) {
  429.                   this.EMail1.setReturnAddress("support");
  430.                } else {
  431.                   this.EMail1.setReturnAddress(this.user.cust.getEmailaddr());
  432.                }
  433.  
  434.                this.EMail1.setMessageSubject("Re:" + this.PROBSUMM1.getText());
  435.                this.EMail1.setMessage(this.createEmailText());
  436.                this.EMail1.sendSingleMessage();
  437.                return true;
  438.             } else if (var1.target.equals(this.ResultList1)) {
  439.                this.Columns1Load(this.ResultList1.getSelectedKey());
  440.                return true;
  441.             } else {
  442.                if (var1.target.equals(this.SearchPanel1)) {
  443.                   this.ResultList1.clearList();
  444.                   this.ResultList1.setFromWhereClause(this.SearchPanel1.getFromWhereClause());
  445.                   this.ResultList1.loadList();
  446.                   return true;
  447.                }
  448.  
  449.                return false;
  450.             }
  451.          default:
  452.             return false;
  453.       }
  454.    }
  455.  
  456.    public void InitComponents() {
  457.    }
  458.  
  459.    public String createEmailText() {
  460.       StringBuffer var1 = new StringBuffer();
  461.       var1.append("Call ID:         ");
  462.       var1.append(this.CALLID1.getText());
  463.       var1.append("\n");
  464.       var1.append("Name:            ");
  465.       var1.append(this.FIRSTNAME1.getText() + " " + this.LASTNAME1.getText());
  466.       var1.append("\n");
  467.       var1.append("Problem Summary: ");
  468.       var1.append(this.PROBSUMM1.getText());
  469.       var1.append("\n");
  470.       var1.append("Status:          ");
  471.       var1.append(this.STATUS1.getSelectedItem());
  472.       var1.append("\n\n");
  473.       var1.append("Probem Detail:\n");
  474.       var1.append(this.PROBDETAIL1.getText());
  475.       var1.append("\n\n");
  476.       var1.append("Possible Solution:\n");
  477.       var1.append(this.PROBDETAIL1.getText());
  478.       var1.append("\n");
  479.       return var1.toString();
  480.    }
  481.  
  482.    public void Columns1Main() {
  483.       this.Columns1LoadChoices();
  484.       this.Columns1ClearFields();
  485.    }
  486.  
  487.    public void Columns1Load(String[] var1) {
  488.       int var3 = 0;
  489.       Vector var4 = new Vector();
  490.       String var5 = this.jaggSQL.getSEP();
  491.       if (var1 != null && var1.length >= 0) {
  492.          String var8 = "SELECT LASTNAME,FIRSTNAME,EMPID,PHONE,EMAIL,PROBTYPE,ITEMAFFECT,POSSOLUTN,PROBSUMM,IMPACT,PROBDETAIL,CALLID,WORKLOG,ASSIGNEDTO,STATUS,ENTRYDATE,FINLSOLUTN FROM JDPHelpDesk WHERE (1=1)";
  493.          if (var1.length > 0 && var1[0] != null) {
  494.             var8 = var8 + " AND CALLID=" + var1[0] + "";
  495.          }
  496.  
  497.          this.jaggSQL.setDSN("JDPHelpDesk");
  498.          this.jaggSQL.setUID("");
  499.          this.jaggSQL.setPWD("");
  500.          this.jaggSQL.setMRW("1000");
  501.          this.jaggSQL.setTOUT("60");
  502.          this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
  503.          var3 = this.jaggSQL.execSQL(var8, var4);
  504.          if (var3 == -1) {
  505.             this.user.u.setSqlMessage(this.jaggSQL, var8);
  506.          } else if (var3 >= 1) {
  507.             String var6 = (String)var4.elementAt(0);
  508.             if (var6 != null && var6.trim().compareTo("") != 0) {
  509.                StringTokenizer var2 = new StringTokenizer(var6, var5);
  510.                this.LASTNAME1.setText(var2.nextToken().trim());
  511.                this.FIRSTNAME1.setText(var2.nextToken().trim());
  512.                this.EMPID1.setText(var2.nextToken().trim());
  513.                this.PHONE1.setText(var2.nextToken().trim());
  514.                this.EMAIL1.setText(var2.nextToken().trim());
  515.                this.PROBTYPE1.setText(var2.nextToken().trim());
  516.                this.ITEMAFFECT1.setText(var2.nextToken().trim());
  517.                this.POSSOLUTN1.setText(var2.nextToken().trim());
  518.                this.PROBSUMM1.setText(var2.nextToken().trim());
  519.                String var7 = var2.nextToken(var5).trim();
  520.                if (this.valueIMPACT1.indexOf(var7) >= 0) {
  521.                   this.IMPACT1.select(this.valueIMPACT1.indexOf(var7));
  522.                }
  523.  
  524.                this.PROBDETAIL1.setText(var2.nextToken().trim());
  525.                this.CALLID1.setText(var2.nextToken().trim());
  526.                this.WORKLOG1.setText(var2.nextToken().trim());
  527.                this.ASSIGNEDTO1.setText(var2.nextToken().trim());
  528.                var7 = var2.nextToken(var5).trim();
  529.                if (this.valueSTATUS1.indexOf(var7) >= 0) {
  530.                   this.STATUS1.select(this.valueSTATUS1.indexOf(var7));
  531.                }
  532.  
  533.                this.ENTRYDATE1.setText(JDPDate.format(Long.valueOf(var2.nextToken())));
  534.                this.FINLSOLUTN1.setText(var2.nextToken().trim());
  535.             }
  536.  
  537.             if (var3 > 1) {
  538.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message1"), 10);
  539.             } else {
  540.                this.user.mainmsg.clearStatusMsg();
  541.             }
  542.          } else {
  543.             this.user.mainmsg.setStatusMsg(JDPLang.get("Message2"), 10);
  544.             this.Columns1ClearFields();
  545.          }
  546.       } else {
  547.          this.Columns1ClearFields();
  548.       }
  549.    }
  550.  
  551.    public boolean Columns1updateRow(String[] var1) {
  552.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "U") : false;
  553.    }
  554.  
  555.    public boolean Columns1insertRow(String[] var1) {
  556.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "I") : false;
  557.    }
  558.  
  559.    public boolean Columns1removeRow(String[] var1) {
  560.       return this.Columns1Save(var1, "D");
  561.    }
  562.  
  563.    boolean Columns1Save(String[] var1, String var2) {
  564.       int var3 = 0;
  565.       Vector var4 = new Vector();
  566.       this.jaggSQL.getSEP();
  567.       String var5 = "";
  568.       Object var6 = null;
  569.       if (var2.equals("I")) {
  570.          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.LASTNAME1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.FIRSTNAME1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.EMPID1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.PHONE1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.EMAIL1.getText(), "'", "''") + "', " + "'" + 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(), "'", "''") + "', " + "'" + (String)this.valueIMPACT1.elementAt(this.IMPACT1.getSelectedIndex()) + "', " + "'" + this.user.u.replace(this.PROBDETAIL1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.WORKLOG1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.ASSIGNEDTO1.getText(), "'", "''") + "', " + "'" + (String)this.valueSTATUS1.elementAt(this.STATUS1.getSelectedIndex()) + "', " + "'" + JDPDate.format(this.ENTRYDATE1.getText()) + "', " + "'" + this.user.u.replace(this.FINLSOLUTN1.getText(), "'", "''") + "')";
  571.       } else {
  572.          if (var1 == null || var1.length == 0) {
  573.             this.user.mainmsg.setStatusMsg(JDPLang.get("Message3"), 5);
  574.             return false;
  575.          }
  576.  
  577.          if (var2.equals("D")) {
  578.             var5 = "DELETE FROM JDPHelpDesk WHERE CALLID=" + var1[0];
  579.          } else {
  580.             var5 = "UPDATE JDPHelpDesk SET LASTNAME = '" + this.user.u.replace(this.LASTNAME1.getText(), "'", "''") + "', " + "FIRSTNAME = '" + this.user.u.replace(this.FIRSTNAME1.getText(), "'", "''") + "', " + "EMPID = '" + this.user.u.replace(this.EMPID1.getText(), "'", "''") + "', " + "PHONE = '" + this.user.u.replace(this.PHONE1.getText(), "'", "''") + "', " + "EMAIL = '" + this.user.u.replace(this.EMAIL1.getText(), "'", "''") + "', " + "PROBTYPE = '" + this.user.u.replace(this.PROBTYPE1.getText(), "'", "''") + "', " + "ITEMAFFECT = '" + this.user.u.replace(this.ITEMAFFECT1.getText(), "'", "''") + "', " + "POSSOLUTN = '" + this.user.u.replace(this.POSSOLUTN1.getText(), "'", "''") + "', " + "PROBSUMM = '" + this.user.u.replace(this.PROBSUMM1.getText(), "'", "''") + "', " + "IMPACT = '" + (String)this.valueIMPACT1.elementAt(this.IMPACT1.getSelectedIndex()) + "', " + "PROBDETAIL = '" + this.user.u.replace(this.PROBDETAIL1.getText(), "'", "''") + "', " + "WORKLOG = '" + this.user.u.replace(this.WORKLOG1.getText(), "'", "''") + "', " + "ASSIGNEDTO = '" + this.user.u.replace(this.ASSIGNEDTO1.getText(), "'", "''") + "', " + "STATUS = '" + (String)this.valueSTATUS1.elementAt(this.STATUS1.getSelectedIndex()) + "', " + "ENTRYDATE = '" + JDPDate.format(this.ENTRYDATE1.getText()) + "', " + "FINLSOLUTN = '" + this.user.u.replace(this.FINLSOLUTN1.getText(), "'", "''") + "'" + " WHERE CALLID=" + var1[0];
  581.          }
  582.       }
  583.  
  584.       this.jaggSQL.setDSN("JDPHelpDesk");
  585.       this.jaggSQL.setUID("");
  586.       this.jaggSQL.setPWD("");
  587.       this.jaggSQL.setMRW("1000");
  588.       this.jaggSQL.setTOUT("60");
  589.       this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
  590.       var3 = this.jaggSQL.execSQL(var5, var4);
  591.       if (var3 == 0 && var6 != null) {
  592.          String[] var7 = new String[]{JDPLang.get("Reload"), JDPLang.get("Update")};
  593.          int[] var8 = new int[]{6, 0};
  594.          JDPMessageDialog var9 = new JDPMessageDialog(this.user, this.user.jdpMainWindow, JDPLang.get("Dialog0"), JDPLang.get("Dialog1"), var7, var8);
  595.          ((JDPDialog)var9).display();
  596.          if (var9.getPressedButton() != 1) {
  597.             this.Columns1Load(var1);
  598.             return true;
  599.          }
  600.  
  601.          var4 = new Vector();
  602.          var3 = this.jaggSQL.execSQL((String)var6, var4);
  603.       }
  604.  
  605.       if (var3 == -1) {
  606.          this.user.u.setSqlMessage(this.jaggSQL, var5);
  607.          return false;
  608.       } else {
  609.          if (var3 == 1) {
  610.             if (var2.equals("I")) {
  611.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message4"), 3);
  612.             } else if (var2.equals("D")) {
  613.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message5"), 3);
  614.             } else {
  615.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message6"), 3);
  616.             }
  617.          } else {
  618.             this.user.u.setSqlMessage(this.jaggSQL, var5);
  619.          }
  620.  
  621.          if (var6 != null) {
  622.             this.Columns1Load(var1);
  623.          }
  624.  
  625.          return true;
  626.       }
  627.    }
  628.  
  629.    public void Columns1ClearFields() {
  630.       this.LASTNAME1.setText("");
  631.       this.FIRSTNAME1.setText("");
  632.       this.EMPID1.setText("");
  633.       this.PHONE1.setText("");
  634.       this.EMAIL1.setText("");
  635.       this.PROBTYPE1.setText("");
  636.       this.ITEMAFFECT1.setText("");
  637.       this.POSSOLUTN1.setText("");
  638.       this.PROBSUMM1.setText("");
  639.       this.IMPACT1.select(0);
  640.       this.PROBDETAIL1.setText("");
  641.       this.CALLID1.setText("");
  642.       this.WORKLOG1.setText("");
  643.       this.ASSIGNEDTO1.setText("");
  644.       this.STATUS1.select(0);
  645.       this.ENTRYDATE1.setText("");
  646.       this.FINLSOLUTN1.setText("");
  647.    }
  648.  
  649.    void Columns1LoadChoices() {
  650.       this.jaggSQL.setDSN("JDPHelpDesk");
  651.       this.jaggSQL.setUID("");
  652.       this.jaggSQL.setPWD("");
  653.       this.jaggSQL.setMRW("1000");
  654.       this.jaggSQL.setTOUT("60");
  655.       this.valueIMPACT1 = new Vector();
  656.       this.IMPACT1.addItem("");
  657.       this.valueIMPACT1.addElement("");
  658.       this.valueSTATUS1 = new Vector();
  659.       this.STATUS1.addItem("");
  660.       this.valueSTATUS1.addElement("");
  661.    }
  662.  
  663.    public boolean Columns1CheckFields() {
  664.       return true;
  665.    }
  666.  
  667.    public void ResultList1Main() {
  668.       String var1 = "CALLID";
  669.       String[] var2 = new String[0];
  670.       String var3 = "ASSIGNEDTO='" + this.user.cust.username + "' OR '" + this.user.cust.username + "' = 'supportadmin'";
  671.       String[] var4 = new String[]{"Last Name", "First Name", "Employee ID", "Call ID", "Entry Date"};
  672.       String[] var5 = new String[]{"LASTNAME", "FIRSTNAME", "EMPID", "CALLID", "ENTRYDATE"};
  673.       JDPJagg var6 = new JDPJagg(this.user.jaggPath);
  674.       var6.setDSN("JDPHelpDesk");
  675.       var6.setUID("");
  676.       var6.setPWD("");
  677.       var6.setMRW("1000");
  678.       var6.setTOUT("60");
  679.       this.ResultList1 = new JDPSearchResults(this.user, super.targetPanel, false, var6, false, var1, var2, var3, var4, var5, var5, "", true, "Total Entries:");
  680.       int[] var7 = new int[19];
  681.       var7[0] = 0;
  682.       var7[1] = 0;
  683.       this.ResultList1.setMinWidth(130);
  684.       this.ResultList1.setIcons(var7);
  685.       this.ResultList1.setFromWhereClause(" FROM JDPHelpDesk WHERE ASSIGNEDTO='" + this.user.cust.username + "' OR '" + this.user.cust.username + "' = 'supportadmin'");
  686.       this.ResultList1.clearList("");
  687.       this.ResultList1.loadList();
  688.    }
  689.  
  690.    public void SearchPanel1Main() {
  691.       String[] var1 = new String[5];
  692.       String[] var2 = new String[5];
  693.       Vector var3 = new Vector();
  694.       Vector var4 = new Vector();
  695.       var1[0] = "Last Name";
  696.       var2[0] = "LASTNAME";
  697.       var1[1] = "First Name";
  698.       var2[1] = "FIRSTNAME";
  699.       var1[2] = "Employee ID";
  700.       var2[2] = "EMPID";
  701.       var1[3] = "Call ID";
  702.       var2[3] = "CALLID";
  703.       var1[4] = "Entry Date";
  704.       var2[4] = "format(ENTRYDATE,'yyyy/mm/dd')";
  705.       var3.addElement(new Vector());
  706.       var4.addElement(new Vector());
  707.       var3.addElement(new Vector());
  708.       var4.addElement(new Vector());
  709.       var3.addElement(new Vector());
  710.       var4.addElement(new Vector());
  711.       var3.addElement(new Vector());
  712.       var4.addElement(new Vector());
  713.       var3.addElement(new Vector());
  714.       var4.addElement(new Vector());
  715.       ((Vector)var3.elementAt(0)).addElement("Begins with");
  716.       ((Vector)var4.elementAt(0)).addElement("like");
  717.       ((Vector)var3.elementAt(0)).addElement("Contains");
  718.       ((Vector)var4.elementAt(0)).addElement("like");
  719.       ((Vector)var3.elementAt(1)).addElement("Begins with");
  720.       ((Vector)var4.elementAt(1)).addElement("like");
  721.       ((Vector)var3.elementAt(1)).addElement("Contains");
  722.       ((Vector)var4.elementAt(1)).addElement("like");
  723.       ((Vector)var3.elementAt(2)).addElement("Begins with");
  724.       ((Vector)var4.elementAt(2)).addElement("like");
  725.       ((Vector)var3.elementAt(2)).addElement("Contains");
  726.       ((Vector)var4.elementAt(2)).addElement("like");
  727.       ((Vector)var3.elementAt(3)).addElement("Greater than");
  728.       ((Vector)var4.elementAt(3)).addElement(">");
  729.       ((Vector)var3.elementAt(3)).addElement("Less than");
  730.       ((Vector)var4.elementAt(3)).addElement("<");
  731.       ((Vector)var3.elementAt(3)).addElement("Equal to");
  732.       ((Vector)var4.elementAt(3)).addElement("=");
  733.       ((Vector)var3.elementAt(4)).addElement("Equal to");
  734.       ((Vector)var4.elementAt(4)).addElement("=");
  735.       ((Vector)var3.elementAt(4)).addElement("Greater than");
  736.       ((Vector)var4.elementAt(4)).addElement(">");
  737.       ((Vector)var3.elementAt(4)).addElement("Less than");
  738.       ((Vector)var4.elementAt(4)).addElement("<");
  739.       int[] var5 = new int[5];
  740.       boolean[] var6 = new boolean[5];
  741.       var5[0] = 19;
  742.       var6[0] = true;
  743.       var5[1] = 19;
  744.       var6[1] = true;
  745.       var5[2] = 54;
  746.       var6[2] = true;
  747.       var5[3] = 8;
  748.       var6[3] = false;
  749.       var5[4] = 21;
  750.       var6[4] = true;
  751.       this.SearchPanel1 = new JDPWhereClause(this.user, super.targetPanel, "", true, "", var1, var2, var3, var4, (String[][])null, (String[][])null, var5, var6, "FROM JDPHelpDesk WHERE (1=1)");
  752.       this.SearchPanel1.setDSNType("ACCESS");
  753.       this.SearchPanel1.setDataType(0, 12);
  754.       this.SearchPanel1.setDataType(1, 12);
  755.       this.SearchPanel1.setDataType(2, 1);
  756.       this.SearchPanel1.setDataType(3, 4);
  757.       this.SearchPanel1.setDataType(4, 11);
  758.    }
  759. }
  760.