CD Actual Thematic 7: Programming/CDAT7.iso/Share/Java/JDesignerPro/Jdp3_0.exe/data1.cab/HelpDesk_Module/TotalEntry.class

Java Class File | 1999-04-09 | 19.4 KB | 752 lines

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Event;
import java.awt.Font;
import java.awt.Label;
import java.awt.Panel;
import java.awt.TextArea;
import java.awt.TextField;
import java.util.StringTokenizer;
import java.util.Vector;

public class TotalEntry extends JDPClassLayout {
   JDPUser user;
   JDPJagg jaggSQL;
   JDPPopupMessage popuppanel;
   JDPMaskEdit JDPMaskEditMain;
   String moduleParameter;
   Panel Main;
   JDPChiselFramePanel ChiselPanel1;
   Panel Form1;
   Panel Panel1;
   Panel Panel2;
   JDPTabSelectPanel TabPanel1;
   JDPScrollPanel ScrollPanel1;
   Label LASTNAMELabel1;
   Panel LASTNAMELine1;
   TextField LASTNAME1;
   TextField FIRSTNAME1;
   TextField EMPID1;
   Label PHONELabel1;
   Panel PHONELine1;
   TextField PHONE1;
   TextField EMAIL1;
   Label CALLIDLabel1;
   Panel CALLIDLine1;
   TextField CALLID1;
   JDPDate ENTRYDATE1;
   Label IMPACTLabel1;
   JDPChoice IMPACT1;
   Vector valueIMPACT1;
   Label PROBTYPELabel1;
   JDPChoice PROBTYPE1;
   Vector valuePROBTYPE1;
   Label ITEMAFFECTLabel1;
   TextField ITEMAFFECT1;
   Label ASSIGNEDTOLabel1;
   Panel ASSIGNEDTOLine1;
   JDPChoice ASSIGNEDTO1;
   Vector valueASSIGNEDTO1;
   Label STATUSLabel1;
   JDPChoice STATUS1;
   Vector valueSTATUS1;
   Label PROBSUMMLabel1;
   TextField PROBSUMM1;
   Label FINLSOLUTNLabel1;
   TextArea FINLSOLUTN1;
   JDPScrollPanel ScrollPanel2;
   Label PROBDETAILLabel1;
   TextArea PROBDETAIL1;
   Label POSSOLUTNLabel1;
   TextArea POSSOLUTN1;
   Label WORKLOGLabel1;
   TextArea WORKLOG1;
   JDPButtons JDPButtons1;
   Panel Panel3;
   JDPWhereClause Form1SP1;
   JDPSearchResults Form1RL1;

   public void InitClass(JDPUser var1, Panel var2, String var3) {
      this.user = var1;
      this.moduleParameter = var3;
      this.jaggSQL = new JDPJagg(var1.jaggPath);
      ((Container)this).setLayout(new BorderLayout());
      this.popuppanel = new JDPPopupMessage(var1, this);
      ((Container)this).add(this.popuppanel);
      this.JDPMaskEditMain = new JDPMaskEdit();
      this.Main = new Panel();
      this.ChiselPanel1 = new JDPChiselFramePanel(var1, "Admin Detail");
      this.Form1 = new Panel();
      this.Panel1 = new Panel();
      this.Panel2 = new Panel();
      String[] var4 = new String[2];
      Panel[] var5 = new Panel[]{new Panel(), null};
      var5[0].setLayout(new BorderLayout());
      var4[0] = "Employee Detail";
      var5[1] = new Panel();
      var5[1].setLayout(new BorderLayout());
      var4[1] = "Problem Detail";
      this.TabPanel1 = new JDPTabSelectPanel(var1, var4, var5, "North");
      this.ScrollPanel1 = new JDPScrollPanel();
      this.LASTNAMELabel1 = new Label("Last / First / ID:", 0);
      this.LASTNAMELine1 = new Panel();
      this.LASTNAME1 = new TextField("LASTNAME", 15);
      this.FIRSTNAME1 = new TextField("FIRSTNAME", 15);
      this.EMPID1 = new TextField("EMPID", 10);
      this.PHONELabel1 = new Label("Phone / Email:", 0);
      this.PHONELine1 = new Panel();
      this.PHONE1 = new TextField("PHONE", 14);
      this.EMAIL1 = new TextField("EMAIL", 30);
      this.CALLIDLabel1 = new Label("Call ID / Date:", 0);
      this.CALLIDLine1 = new Panel();
      this.CALLID1 = new TextField("CALLID", 8);
      this.ENTRYDATE1 = new JDPDate(var1, "", 10);
      this.IMPACTLabel1 = new Label("Impact:", 0);
      this.IMPACT1 = new JDPChoice();
      this.PROBTYPELabel1 = new Label("Problem Type:", 0);
      this.PROBTYPE1 = new JDPChoice();
      this.ITEMAFFECTLabel1 = new Label("Item Affected:", 0);
      this.ITEMAFFECT1 = new TextField("ITEMAFFECT", 30);
      this.ASSIGNEDTOLabel1 = new Label("Assigned To:", 0);
      this.ASSIGNEDTOLine1 = new Panel();
      this.ASSIGNEDTO1 = new JDPChoice();
      this.STATUSLabel1 = new Label("Status:", 0);
      this.STATUS1 = new JDPChoice();
      this.PROBSUMMLabel1 = new Label("Problem Summary:", 0);
      this.PROBSUMM1 = new TextField("PROBSUMM", 48);
      this.FINLSOLUTNLabel1 = new Label("Final Solution:", 0);
      this.FINLSOLUTN1 = new TextArea("FINLSOLUTN", 6, 48);
      this.ScrollPanel2 = new JDPScrollPanel();
      this.PROBDETAILLabel1 = new Label("Problem Detail:", 0);
      this.PROBDETAIL1 = new TextArea("PROBDETAIL", 6, 48);
      this.POSSOLUTNLabel1 = new Label("Poss Solution:", 0);
      this.POSSOLUTN1 = new TextArea("POSSOLUTN", 3, 48);
      this.WORKLOGLabel1 = new Label("Work Log:", 0);
      this.WORKLOG1 = new TextArea("WORKLOG", 6, 48);
      String[] var6 = new String[]{"Apply", "Add", "Remove"};
      int[] var7 = new int[]{JDPButton.getIconValue("Save"), JDPButton.getIconValue("New"), JDPButton.getIconValue("Delete")};
      this.JDPButtons1 = new JDPButtons(var1, var6, var7, JDPButtons.getAlignmentValue("Horizontal"));
      this.Panel3 = new Panel();
      this.Main.setLayout(new BorderLayout());
      ((Container)this).add("Center", this.Main);
      this.Main.add("Center", this.ChiselPanel1);
      this.ChiselPanel1.add("Center", this.Form1);
      this.Form1.setLayout(new BorderLayout());
      this.Form1Main();
      this.Form1.add("Center", this.Panel1);
      this.Panel1.setLayout(new BorderLayout());
      this.Panel1.add("Center", this.Panel2);
      this.Panel2.setLayout(new BorderLayout());
      this.Panel2.add("Center", this.TabPanel1);
      var5[0].add("Center", this.ScrollPanel1);
      this.ScrollPanel1.add("Left", this.LASTNAMELabel1);
      this.ScrollPanel1.add("Right", this.LASTNAMELine1);
      this.LASTNAMELine1.setLayout(new JDPLineLayout());
      this.LASTNAMELine1.add("Left", this.LASTNAME1);
      this.LASTNAMELine1.add("Left", this.FIRSTNAME1);
      this.LASTNAMELine1.add("Left", this.EMPID1);
      this.ScrollPanel1.add("Left", this.PHONELabel1);
      this.ScrollPanel1.add("Right", this.PHONELine1);
      this.PHONELine1.setLayout(new JDPLineLayout());
      this.PHONELine1.add("Left", this.PHONE1);
      this.PHONELine1.add("Left", this.EMAIL1);
      this.ScrollPanel1.add("Left", this.CALLIDLabel1);
      this.ScrollPanel1.add("Right", this.CALLIDLine1);
      this.CALLIDLine1.setLayout(new JDPLineLayout());
      this.CALLIDLine1.add("Left", this.CALLID1);
      this.CALLIDLine1.add("Left", this.ENTRYDATE1);
      this.CALLIDLine1.add("Left", this.IMPACTLabel1);
      this.CALLIDLine1.add("Left", this.IMPACT1);
      this.ScrollPanel1.add("Left", this.PROBTYPELabel1);
      this.ScrollPanel1.add("Right", this.PROBTYPE1);
      this.ScrollPanel1.add("Left", this.ITEMAFFECTLabel1);
      this.ScrollPanel1.add("Right", this.ITEMAFFECT1);
      this.ScrollPanel1.add("Left", this.ASSIGNEDTOLabel1);
      this.ScrollPanel1.add("Right", this.ASSIGNEDTOLine1);
      this.ASSIGNEDTOLine1.setLayout(new JDPLineLayout());
      this.ASSIGNEDTOLine1.add("Left", this.ASSIGNEDTO1);
      this.ASSIGNEDTOLine1.add("Left", this.STATUSLabel1);
      this.ASSIGNEDTOLine1.add("Left", this.STATUS1);
      this.ScrollPanel1.add("Left", this.PROBSUMMLabel1);
      this.ScrollPanel1.add("Right", this.PROBSUMM1);
      this.ScrollPanel1.add("Left", this.FINLSOLUTNLabel1);
      this.ScrollPanel1.add("Right", this.FINLSOLUTN1);
      var5[1].add("Center", this.ScrollPanel2);
      this.ScrollPanel2.add("Left", this.PROBDETAILLabel1);
      this.ScrollPanel2.add("Right", this.PROBDETAIL1);
      this.ScrollPanel2.add("Left", this.POSSOLUTNLabel1);
      this.ScrollPanel2.add("Right", this.POSSOLUTN1);
      this.ScrollPanel2.add("Left", this.WORKLOGLabel1);
      this.ScrollPanel2.add("Right", this.WORKLOG1);
      this.Panel1.add("South", this.JDPButtons1);
      this.Form1.add("West", this.Panel3);
      this.Panel3.setLayout(new BorderLayout());
      this.Panel3.add("North", this.Form1SP1);
      this.Panel3.add("Center", this.Form1RL1);
      this.TabPanel1.setTabcolor(0, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
      this.TabPanel1.setTabcolor(1, var1.u._cvtcolor("Black"), var1.u._cvtcolor("LightGray"));
      this.ScrollPanel1.setFont(new Font("Helvetica", 0, 11));
      this.ScrollPanel1.setForeground(var1.u._cvtcolor("Black"));
      this.ScrollPanel1.setBackground(var1.u._cvtcolor("LightGray"));
      this.LASTNAMELabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.LASTNAME1, "Last Name", "Enter your last name.");
      this.popuppanel.addComponent(this.FIRSTNAME1, "First Name", "Enter your first name.");
      this.popuppanel.addComponent(this.EMPID1, "Employee ID", "Enter your Employee ID code.");
      this.PHONELabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.PHONE1, "Phone", "Enter your phone number or extension.");
      this.popuppanel.addComponent(this.EMAIL1, "Email", "Enter your complete email address.");
      this.CALLIDLabel1.setFont(new Font("Helvetica", 1, 11));
      this.CALLID1.setEditable(false);
      this.popuppanel.addComponent(this.CALLID1, "Call ID", "This is automatically assigned.");
      this.CALLID1.setEditable(false);
      this.ENTRYDATE1.setForeground(var1.u._cvtcolor("Blue"));
      this.popuppanel.addComponent(this.ENTRYDATE1, "Entry Date", "Date of problem entry.");
      this.IMPACTLabel1.setFont(new Font("Helvetica", 1, 11));
      this.IMPACT1.setForeground(var1.u._cvtcolor("Red"));
      this.popuppanel.addComponent(this.IMPACT1, "Impact", "How much does this affect your ability to work?");
      this.PROBTYPELabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.PROBTYPE1, "Problem Type", "Select the area causing the problem.");
      this.ITEMAFFECTLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.ITEMAFFECT1, "Item Affect", "Enter the exact item affected by the problem.");
      this.ASSIGNEDTOLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.ASSIGNEDTO1, "Assigned To", "Assign this task to one of the support professionals.");
      this.STATUSLabel1.setFont(new Font("Helvetica", 1, 11));
      this.STATUS1.setForeground(var1.u._cvtcolor("Red"));
      this.popuppanel.addComponent(this.STATUS1, "Status", "Choose the status of the problem.");
      this.PROBSUMMLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.PROBSUMM1, "Problem Summary", "Enter a brief description of the problem.");
      this.FINLSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.FINLSOLUTN1, "Final Solution", "The final soluton to the closed problem.");
      this.ScrollPanel2.setFont(new Font("Helvetica", 0, 11));
      this.ScrollPanel2.setForeground(var1.u._cvtcolor("Black"));
      this.ScrollPanel2.setBackground(var1.u._cvtcolor("LightGray"));
      this.PROBDETAILLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.PROBDETAIL1, "Problem Detail", "Enter a detailed description with any error messages received.");
      this.POSSOLUTNLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.POSSOLUTN1, "Possible Solution", "Possible solution(s).");
      this.WORKLOGLabel1.setFont(new Font("Helvetica", 1, 11));
      this.popuppanel.addComponent(this.WORKLOG1, "Work Log", "This is a log of the work done so far on this problem.");
      this.InitComponents();
      var1.gParm.addElement(this);
   }

   public boolean handleEvent(Event var1) {
      switch (var1.id) {
         case 401:
            if (var1.key == 9 && var1.modifiers != 1) {
               if (var1.target.equals(this.LASTNAME1)) {
                  this.user.u.cursor(this.FIRSTNAME1);
                  return true;
               }

               if (var1.target.equals(this.FIRSTNAME1)) {
                  this.user.u.cursor(this.EMPID1);
                  return true;
               }

               if (var1.target.equals(this.EMPID1)) {
                  this.user.u.cursor(this.PHONE1);
                  return true;
               }

               if (var1.target.equals(this.PHONE1)) {
                  this.user.u.cursor(this.EMAIL1);
                  return true;
               }

               if (var1.target.equals(this.EMAIL1)) {
                  this.user.u.cursor(this.CALLID1);
                  return true;
               }

               if (var1.target.equals(this.CALLID1)) {
                  this.user.u.cursor(this.ENTRYDATE1);
                  return true;
               }

               if (var1.target.equals(this.ENTRYDATE1)) {
                  this.user.u.cursor(this.IMPACT1);
                  return true;
               }

               if (var1.target.equals(this.IMPACT1)) {
                  this.user.u.cursor(this.PROBTYPE1);
                  return true;
               }

               if (var1.target.equals(this.PROBTYPE1)) {
                  this.user.u.cursor(this.ITEMAFFECT1);
                  return true;
               }

               if (var1.target.equals(this.ITEMAFFECT1)) {
                  this.user.u.cursor(this.ASSIGNEDTO1);
                  return true;
               }

               if (var1.target.equals(this.ASSIGNEDTO1)) {
                  this.user.u.cursor(this.STATUS1);
                  return true;
               }

               if (var1.target.equals(this.STATUS1)) {
                  this.user.u.cursor(this.PROBSUMM1);
                  return true;
               }

               if (var1.target.equals(this.PROBSUMM1)) {
                  this.user.u.cursor(this.FINLSOLUTN1);
                  return true;
               }

               if (var1.target.equals(this.FINLSOLUTN1)) {
                  this.user.u.cursor(this.PROBDETAIL1);
                  return true;
               }

               if (var1.target.equals(this.PROBDETAIL1)) {
                  this.user.u.cursor(this.POSSOLUTN1);
                  return true;
               }

               if (var1.target.equals(this.POSSOLUTN1)) {
                  this.user.u.cursor(this.WORKLOG1);
                  return true;
               }

               if (var1.target.equals(this.WORKLOG1)) {
                  this.user.u.cursor(this.LASTNAME1);
                  return true;
               }
            }

            if (var1.key == 9 && var1.modifiers == 1) {
               if (var1.target.equals(this.LASTNAME1)) {
                  this.user.u.cursor(this.WORKLOG1);
                  return true;
               }

               if (var1.target.equals(this.FIRSTNAME1)) {
                  this.user.u.cursor(this.LASTNAME1);
                  return true;
               }

               if (var1.target.equals(this.EMPID1)) {
                  this.user.u.cursor(this.FIRSTNAME1);
                  return true;
               }

               if (var1.target.equals(this.PHONE1)) {
                  this.user.u.cursor(this.EMPID1);
                  return true;
               }

               if (var1.target.equals(this.EMAIL1)) {
                  this.user.u.cursor(this.PHONE1);
                  return true;
               }

               if (var1.target.equals(this.CALLID1)) {
                  this.user.u.cursor(this.EMAIL1);
                  return true;
               }

               if (var1.target.equals(this.ENTRYDATE1)) {
                  this.user.u.cursor(this.CALLID1);
                  return true;
               }

               if (var1.target.equals(this.IMPACT1)) {
                  this.user.u.cursor(this.ENTRYDATE1);
                  return true;
               }

               if (var1.target.equals(this.PROBTYPE1)) {
                  this.user.u.cursor(this.IMPACT1);
                  return true;
               }

               if (var1.target.equals(this.ITEMAFFECT1)) {
                  this.user.u.cursor(this.PROBTYPE1);
                  return true;
               }

               if (var1.target.equals(this.ASSIGNEDTO1)) {
                  this.user.u.cursor(this.ITEMAFFECT1);
                  return true;
               }

               if (var1.target.equals(this.STATUS1)) {
                  this.user.u.cursor(this.ASSIGNEDTO1);
                  return true;
               }

               if (var1.target.equals(this.PROBSUMM1)) {
                  this.user.u.cursor(this.STATUS1);
                  return true;
               }

               if (var1.target.equals(this.FINLSOLUTN1)) {
                  this.user.u.cursor(this.PROBSUMM1);
                  return true;
               }

               if (var1.target.equals(this.PROBDETAIL1)) {
                  this.user.u.cursor(this.FINLSOLUTN1);
                  return true;
               }

               if (var1.target.equals(this.POSSOLUTN1)) {
                  this.user.u.cursor(this.PROBDETAIL1);
                  return true;
               }

               if (var1.target.equals(this.WORKLOG1)) {
                  this.user.u.cursor(this.POSSOLUTN1);
                  return true;
               }
            }

            return false;
         case 503:
         case 504:
         case 505:
            this.popuppanel.postEvent(var1);
            return false;
         case 1001:
            if (var1.target.equals(this.JDPButtons1.button[0])) {
               this.Form1updateRow(this.Form1RL1.getSelectedKey());
               return true;
            } else if (var1.target.equals(this.JDPButtons1.button[1])) {
               this.Form1insertRow(this.Form1RL1.getSelectedKey());
               return true;
            } else if (var1.target.equals(this.JDPButtons1.button[2])) {
               this.Form1removeRow(this.Form1RL1.getSelectedKey());
               return true;
            } else if (var1.target.equals(this.Form1SP1)) {
               this.Form1RL1.clearList();
               this.Form1RL1.setFromWhereClause(this.Form1SP1.getFromWhereClause());
               this.Form1RL1.loadList();
               return true;
            } else {
               if (var1.target.equals(this.Form1RL1)) {
                  this.Form1Load(this.Form1RL1.getSelectedKey());
                  return true;
               }

               return false;
            }
         default:
            return false;
      }
   }

   public void InitComponents() {
      this.jaggSQL.setKeepConnectionOpen(false);
   }

   public void Form1Main() {
      this.Form1LoadChoices();
      this.Form1ClearFields();
      this.Form1WhereClauseMain();
      this.Form1SearchResultsMain();
   }

   public void Form1Load(String[] var1) {
      int var3 = 0;
      Vector var4 = new Vector();
      String var5 = this.jaggSQL.getSEP();
      if (var1 != null && var1.length >= 0) {
         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)";
         if (var1.length > 0 && var1[0] != null) {
            var8 = var8 + " AND CALLID=" + var1[0] + "";
         }

         this.jaggSQL.setDSN("JDPHelpDesk");
         this.jaggSQL.setUID("");
         this.jaggSQL.setPWD("");
         this.jaggSQL.setMRW("1000");
         this.jaggSQL.setTOUT("60");
         this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
         var3 = this.jaggSQL.execSQL(var8, var4);
         if (var3 == -1) {
            this.user.u.setSqlMessage(this.jaggSQL, var8);
         } else if (var3 >= 1) {
            String var6 = (String)var4.elementAt(0);
            if (var6 != null && var6.trim().compareTo("") != 0) {
               StringTokenizer var2 = new StringTokenizer(var6, var5);
               this.LASTNAME1.setText(var2.nextToken().trim());
               this.FIRSTNAME1.setText(var2.nextToken().trim());
               this.EMPID1.setText(var2.nextToken().trim());
               this.PHONE1.setText(var2.nextToken().trim());
               this.EMAIL1.setText(var2.nextToken().trim());
               String var7 = var2.nextToken(var5).trim();
               if (this.valuePROBTYPE1.indexOf(var7) >= 0) {
                  this.PROBTYPE1.select(this.valuePROBTYPE1.indexOf(var7));
               }

               this.ITEMAFFECT1.setText(var2.nextToken().trim());
               this.POSSOLUTN1.setText(var2.nextToken().trim());
               this.PROBSUMM1.setText(var2.nextToken().trim());
               var7 = var2.nextToken(var5).trim();
               if (this.valueIMPACT1.indexOf(var7) >= 0) {
                  this.IMPACT1.select(this.valueIMPACT1.indexOf(var7));
               }

               this.PROBDETAIL1.setText(var2.nextToken().trim());
               this.CALLID1.setText(var2.nextToken().trim());
               this.WORKLOG1.setText(var2.nextToken().trim());
               var7 = var2.nextToken(var5).trim();
               if (this.valueASSIGNEDTO1.indexOf(var7) >= 0) {
                  this.ASSIGNEDTO1.select(this.valueASSIGNEDTO1.indexOf(var7));
               }

               var7 = var2.nextToken(var5).trim();
               if (this.valueSTATUS1.indexOf(var7) >= 0) {
                  this.STATUS1.select(this.valueSTATUS1.indexOf(var7));
               }

               this.ENTRYDATE1.setText(JDPDate.format(Long.valueOf(var2.nextToken())));
               this.FINLSOLUTN1.setText(var2.nextToken().trim());
            }

            if (var3 > 1) {
               this.user.mainmsg.setStatusMsg(JDPLang.get("Message1"), 10);
            } else {
               this.user.mainmsg.clearStatusMsg();
            }
         } else {
            this.user.mainmsg.setStatusMsg(JDPLang.get("Message2"), 10);
            this.Form1ClearFields();
         }
      } else {
         this.Form1ClearFields();
      }
   }

   public boolean Form1updateRow(String[] var1) {
      return this.Form1CheckFields() ? this.Form1Save(var1, "U") : false;
   }

   public boolean Form1insertRow(String[] var1) {
      return this.Form1CheckFields() ? this.Form1Save(var1, "I") : false;
   }

   public boolean Form1removeRow(String[] var1) {
      return this.Form1Save(var1, "D");
   }

   boolean Form1Save(String[] var1, String var2) {
      int var3 = 0;
      Vector var4 = new Vector();
      this.jaggSQL.getSEP();
      String var5 = "";
      Object var6 = null;
      if (var2.equals("I")) {
         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(), "'", "''") + "', " + "'" + (String)this.valuePROBTYPE1.elementAt(this.PROBTYPE1.getSelectedIndex()) + "', " + "'" + 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(), "'", "''") + "', " + "'" + (String)this.valueASSIGNEDTO1.elementAt(this.ASSIGNEDTO1.getSelectedIndex()) + "', " + "'" + (String)this.valueSTATUS1.elementAt(this.STATUS1.getSelectedIndex()) + "', " + "'" + JDPDate.format(this.ENTRYDATE1.getText()) + "', " + "'" + this.user.u.replace(this.FINLSOLUTN1.getText(), "'", "''") + "')";
      } else {
         if (var1 == null || var1.length == 0) {
            this.user.mainmsg.setStatusMsg(JDPLang.get("Message3"), 5);
            return false;
         }

         if (var2.equals("D")) {
            var5 = "DELETE FROM JDPHelpDesk WHERE CALLID=" + var1[0];
         } else {
            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 = '" + (String)this.valuePROBTYPE1.elementAt(this.PROBTYPE1.getSelectedIndex()) + "', " + "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 = '" + (String)this.valueASSIGNEDTO1.elementAt(this.ASSIGNEDTO1.getSelectedIndex()) + "', " + "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];
         }
      }

      this.jaggSQL.setDSN("JDPHelpDesk");
      this.jaggSQL.setUID("");
      this.jaggSQL.setPWD("");
      this.jaggSQL.setMRW("1000");
      this.jaggSQL.setTOUT("60");
      this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
      var3 = this.jaggSQL.execSQL(var5, var4);
      if (var3 == 0 && var6 != null) {
         String[] var7 = new String[]{JDPLang.get("Reload"), JDPLang.get("Update")};
         int[] var8 = new int[]{6, 0};
         JDPMessageDialog var9 = new JDPMessageDialog(this.user, this.user.jdpMainWindow, JDPLang.get("Dialog0"), JDPLang.get("Dialog1"), var7, var8);
         ((JDPDialog)var9).display();
         if (var9.getPressedButton() != 1) {
            this.Form1Load(var1);
            return true;
         }

         var4 = new Vector();
         var3 = this.jaggSQL.execSQL((String)var6, var4);
      }

      if (var3 == -1) {
         this.user.u.setSqlMessage(this.jaggSQL, var5);
         return false;
      } else {
         if (var3 == 1) {
            if (var2.equals("I")) {
               this.user.mainmsg.setStatusMsg(JDPLang.get("Message4"), 3);
            } else if (var2.equals("D")) {
               this.user.mainmsg.setStatusMsg(JDPLang.get("Message5"), 3);
            } else {
               this.user.mainmsg.setStatusMsg(JDPLang.get("Message6"), 3);
            }
         } else {
            this.user.u.setSqlMessage(this.jaggSQL, var5);
         }

         if (var6 != null) {
            this.Form1Load(var1);
         }

         return true;
      }
   }

   public void Form1ClearFields() {
      this.LASTNAME1.setText("");
      this.FIRSTNAME1.setText("");
      this.EMPID1.setText("");
      this.PHONE1.setText("");
      this.EMAIL1.setText("");
      this.PROBTYPE1.select(0);
      this.ITEMAFFECT1.setText("");
      this.POSSOLUTN1.setText("");
      this.PROBSUMM1.setText("");
      this.IMPACT1.select(0);
      this.PROBDETAIL1.setText("");
      this.CALLID1.setText("");
      this.WORKLOG1.setText("");
      this.ASSIGNEDTO1.select(0);
      this.STATUS1.select(0);
      this.ENTRYDATE1.setText("");
      this.FINLSOLUTN1.setText("");
   }

   void Form1LoadChoices() {
      this.jaggSQL.setDSN("JDPHelpDesk");
      this.jaggSQL.setUID("");
      this.jaggSQL.setPWD("");
      this.jaggSQL.setMRW("1000");
      this.jaggSQL.setTOUT("60");
      this.valueIMPACT1 = new Vector();
      this.IMPACT1.addItem("Low");
      this.valueIMPACT1.addElement("Low");
      this.IMPACT1.addItem("Medium");
      this.valueIMPACT1.addElement("Medium");
      this.IMPACT1.addItem("High");
      this.valueIMPACT1.addElement("High");
      this.valueSTATUS1 = new Vector();
      this.STATUS1.addItem("Assigned");
      this.valueSTATUS1.addElement("Assigned");
      this.STATUS1.addItem("In Progress");
      this.valueSTATUS1.addElement("Progress");
      this.STATUS1.addItem("Pending Info");
      this.valueSTATUS1.addElement("Pending");
      this.STATUS1.addItem("Reassign");
      this.valueSTATUS1.addElement("Reassign");
      this.STATUS1.addItem("Closed");
      this.valueSTATUS1.addElement("Closed");
      this.valuePROBTYPE1 = new Vector();
      new JDPLoadChoice(this.user, this.jaggSQL, this.PROBTYPE1, "PROBTYPE", "PROBTYPE", "JDPProbType", "(1=1)", this.valuePROBTYPE1);
      this.valueASSIGNEDTO1 = new Vector();
      new JDPLoadChoice(this.user, this.jaggSQL, this.ASSIGNEDTO1, "username", "username", "JDPUser", "username like 'sup%'", this.valueASSIGNEDTO1);
   }

   public boolean Form1CheckFields() {
      return true;
   }

   public void Form1WhereClauseMain() {
      String[] var1 = new String[5];
      String[] var2 = new String[5];
      Vector var3 = new Vector();
      Vector var4 = new Vector();
      var1[0] = "Last Name";
      var2[0] = "LASTNAME";
      var1[1] = "First Name";
      var2[1] = "FIRSTNAME";
      var1[2] = "Employee ID";
      var2[2] = "EMPID";
      var1[3] = "Call ID";
      var2[3] = "CALLID";
      var1[4] = "Entry Date";
      var2[4] = "ENTRYDATE";
      var3.addElement(new Vector());
      var4.addElement(new Vector());
      var3.addElement(new Vector());
      var4.addElement(new Vector());
      var3.addElement(new Vector());
      var4.addElement(new Vector());
      var3.addElement(new Vector());
      var4.addElement(new Vector());
      var3.addElement(new Vector());
      var4.addElement(new Vector());
      ((Vector)var3.elementAt(0)).addElement("Begins with");
      ((Vector)var4.elementAt(0)).addElement("like");
      ((Vector)var3.elementAt(0)).addElement("Contains");
      ((Vector)var4.elementAt(0)).addElement("like");
      ((Vector)var3.elementAt(1)).addElement("Begins with");
      ((Vector)var4.elementAt(1)).addElement("like");
      ((Vector)var3.elementAt(1)).addElement("Contains");
      ((Vector)var4.elementAt(1)).addElement("like");
      ((Vector)var3.elementAt(2)).addElement("Begins with");
      ((Vector)var4.elementAt(2)).addElement("like");
      ((Vector)var3.elementAt(2)).addElement("Contains");
      ((Vector)var4.elementAt(2)).addElement("like");
      ((Vector)var3.elementAt(3)).addElement("Greater than");
      ((Vector)var4.elementAt(3)).addElement(">");
      ((Vector)var3.elementAt(3)).addElement("Less than");
      ((Vector)var4.elementAt(3)).addElement("<");
      ((Vector)var3.elementAt(3)).addElement("Equal to");
      ((Vector)var4.elementAt(3)).addElement("=");
      ((Vector)var3.elementAt(4)).addElement("Equal to");
      ((Vector)var4.elementAt(4)).addElement("=");
      ((Vector)var3.elementAt(4)).addElement("Greater than");
      ((Vector)var4.elementAt(4)).addElement(">");
      ((Vector)var3.elementAt(4)).addElement("Less than");
      ((Vector)var4.elementAt(4)).addElement("<");
      int[] var5 = new int[5];
      boolean[] var6 = new boolean[5];
      var5[0] = 19;
      var6[0] = true;
      var5[1] = 19;
      var6[1] = true;
      var5[2] = 54;
      var6[2] = true;
      var5[3] = 8;
      var6[3] = false;
      var5[4] = 14;
      var6[4] = true;
      this.Form1SP1 = new JDPWhereClause(this.user, super.targetPanel, "", true, "Last Name", var1, var2, var3, var4, (String[][])null, (String[][])null, var5, var6, "FROM JDPHelpDesk WHERE (1=1)");
      this.Form1SP1.setDSNType("ACCESS");
      this.Form1SP1.setDataType(0, 12);
      this.Form1SP1.setDataType(1, 12);
      this.Form1SP1.setDataType(2, 1);
      this.Form1SP1.setDataType(3, 4);
      this.Form1SP1.setDataType(4, 11);
   }

   public void Form1SearchResultsMain() {
      String var1 = "CALLID";
      String[] var2 = new String[0];
      String var3 = "(1=1)";
      String[] var4 = new String[]{"Last Name", "First Name", "Employee ID", "Call ID", "Entry Date"};
      String[] var5 = new String[]{"LASTNAME", "FIRSTNAME", "EMPID", "CALLID", "ENTRYDATE"};
      JDPJagg var6 = new JDPJagg(this.user.jaggPath);
      var6.setDSN("JDPHelpDesk");
      var6.setUID("");
      var6.setPWD("");
      var6.setMRW("1000");
      var6.setTOUT("60");
      this.Form1RL1 = new JDPSearchResults(this.user, super.targetPanel, false, var6, false, var1, var2, var3, var4, var5, var5, "Last Name", true, "Total Entries:");
      int[] var7 = new int[19];
      var7[0] = 0;
      var7[1] = 0;
      this.Form1RL1.setMinWidth(130);
      this.Form1RL1.setIcons(var7);
      this.Form1RL1.setFromWhereClause(" FROM JDPHelpDesk WHERE (1=1)");
      this.Form1RL1.clearList("");
      this.Form1RL1.loadList();
   }
}