home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / HelpDesk_Module / OpenRequests.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  12.3 KB  |  516 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Color;
  3. import java.awt.Container;
  4. import java.awt.Event;
  5. import java.awt.List;
  6. import java.awt.Panel;
  7. import java.util.StringTokenizer;
  8. import java.util.Vector;
  9.  
  10. public class OpenRequests extends JDPClassLayout {
  11.    JDPUser user;
  12.    JDPJagg jaggSQL;
  13.    JDPPopupMessage popuppanel;
  14.    JDPMaskEdit JDPMaskEditMain;
  15.    String moduleParameter;
  16.    Panel Main;
  17.    JDPChiselFramePanel ChiselPanel1;
  18.    Panel Grid1;
  19.    Panel Panel1;
  20.    JDPWhereClause Grid1SP1;
  21.    JDPTextGrid Grid1GL1;
  22.    JDPButtons JDPButtons1;
  23.  
  24.    void Grid1LoadChoices() {
  25.       JDPTextGrid var1 = this.Grid1GL1;
  26.       byte var2 = 7;
  27.       this.jaggSQL.loadJdbcSettings("JDPHelpDesk");
  28.       this.jaggSQL.setUID("");
  29.       this.jaggSQL.setPWD("");
  30.       this.jaggSQL.setMRW("1000");
  31.       this.jaggSQL.setTOUT("60");
  32.       var1.isPullDownCol = new boolean[var2];
  33.       var1.pullDownColType = new int[var2];
  34.       var1.pullDownList = new List[var2][1];
  35.       var1.isPullDownCol[2] = true;
  36.       var1.isPullDownCol[4] = true;
  37.       var1.isPullDownCol[5] = true;
  38.       var1.pullDownColType[2] = 0;
  39.       var1.pullDownColType[4] = 0;
  40.       var1.pullDownColType[5] = 0;
  41.       var1.pullDownList[2][0] = new List();
  42.       var1.pullDownList[4][0] = new List();
  43.       var1.pullDownList[5][0] = new List();
  44.       var1.isPullDownCol[6] = true;
  45.       var1.pullDownColType[6] = 1;
  46.       var1.pullDownValue[2][0] = new Vector();
  47.       var1.pullDownList[2][0].addItem("Low");
  48.       var1.pullDownValue[2][0].addElement("Low");
  49.       var1.pullDownList[2][0].addItem("Medium");
  50.       var1.pullDownValue[2][0].addElement("Medium");
  51.       var1.pullDownList[2][0].addItem("High");
  52.       var1.pullDownValue[2][0].addElement("High");
  53.       var1.pullDownValue[5][0] = new Vector();
  54.       var1.pullDownList[5][0].addItem("Progress");
  55.       var1.pullDownValue[5][0].addElement("Progress");
  56.       var1.pullDownList[5][0].addItem("Assigned");
  57.       var1.pullDownValue[5][0].addElement("Assigned");
  58.       var1.pullDownList[5][0].addItem("Reassign");
  59.       var1.pullDownValue[5][0].addElement("Reassign");
  60.       var1.pullDownList[5][0].addItem("Closed");
  61.       var1.pullDownValue[5][0].addElement("Closed");
  62.       var1.pullDownList[5][0].addItem("Pending");
  63.       var1.pullDownValue[5][0].addElement("Pending");
  64.       var1.pullDownValue[4][0] = new Vector();
  65.       new JDPLoadChoice(this.user, this.jaggSQL, var1.pullDownList[4][0], "username", "username", "JDPUser", "(1=1)", var1.pullDownValue[4][0]);
  66.    }
  67.  
  68.    boolean Grid1SaveData(int var1, String var2) {
  69.       JDPTextGrid var3 = this.Grid1GL1;
  70.       int var4 = 0;
  71.       Vector var5 = new Vector();
  72.       this.jaggSQL.getSEP();
  73.       String var6 = "";
  74.       String var7 = null;
  75.       this.jaggSQL.loadJdbcSettings("JDPHelpDesk");
  76.       this.jaggSQL.setUID("");
  77.       this.jaggSQL.setPWD("");
  78.       this.jaggSQL.setMRW("1000");
  79.       this.jaggSQL.setTOUT("60");
  80.       if (var2.equals("I")) {
  81.          var6 = "INSERT INTO JDPHelpDesk (LASTNAME, PROBSUMM, IMPACT, ASSIGNEDTO, STATUS, ENTRYDATE, FIRSTNAME, EMPID, PHONE, EMAIL, PROBTYPE, ITEMAFFECT, POSSOLUTN, PROBDETAIL, WORKLOG, FINLSOLUTN) VALUES('" + this.user.u.replace(var3.currentText[0][var1], "'", "''") + "', " + "'" + this.user.u.replace(var3.currentText[1][var1], "'", "''") + "', " + "'" + (String)var3.pullDownValue[2][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[2][0], var3.currentText[2][var1])) + "', " + "'" + (String)var3.pullDownValue[4][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[4][0], var3.currentText[4][var1])) + "', " + "'" + (String)var3.pullDownValue[5][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[5][0], var3.currentText[5][var1])) + "', " + "" + JDPDate.formatForSql(var3.currentText[6][var1], this.user.u.getDataSourceType(this.jaggSQL)) + ", " + "'', " + "'', " + "'', " + "'', " + "'', " + "'', " + "'', " + "'', " + "'', " + "'')";
  82.       } else if (var2.equals("D")) {
  83.          var6 = "DELETE FROM JDPHelpDesk WHERE CALLID=" + var3.rowKey[var1][0] + "";
  84.          if (var3.recordLockValue[var1] != null) {
  85.             var7 = var6;
  86.          }
  87.       } else {
  88.          var6 = "UPDATE JDPHelpDesk SET LASTNAME = '" + this.user.u.replace(var3.currentText[0][var1], "'", "''") + "', " + "PROBSUMM = '" + this.user.u.replace(var3.currentText[1][var1], "'", "''") + "', " + "IMPACT = '" + (String)var3.pullDownValue[2][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[2][0], var3.currentText[2][var1])) + "', " + "ASSIGNEDTO = '" + (String)var3.pullDownValue[4][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[4][0], var3.currentText[4][var1])) + "', " + "STATUS = '" + (String)var3.pullDownValue[5][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[5][0], var3.currentText[5][var1])) + "', " + "ENTRYDATE = " + JDPDate.formatForSql(var3.currentText[6][var1], this.user.u.getDataSourceType(this.jaggSQL)) + "" + " WHERE CALLID=" + var3.rowKey[var1][0] + "";
  89.          if (var3.recordLockValue[var1] != null) {
  90.             var7 = var6;
  91.          }
  92.       }
  93.  
  94.       var4 = this.jaggSQL.execSQL(var6, var5);
  95.       if (this.user.DEBUG) {
  96.          System.out.println("saveData CNT: " + Integer.toString(var4));
  97.       }
  98.  
  99.       if (var4 == 0 && var7 != null) {
  100.          String[] var8 = new String[]{JDPLang.get("Reload"), JDPLang.get("Update")};
  101.          int[] var9 = new int[]{6, 0};
  102.          JDPMessageDialog var10 = new JDPMessageDialog(this.user, this.user.jdpMainWindow, JDPLang.get("Dialog0"), JDPLang.get("Dialog1"), var8, var9);
  103.          ((JDPDialog)var10).display();
  104.          if (var10.getPressedButton() != 1) {
  105.             return true;
  106.          }
  107.  
  108.          var5 = new Vector();
  109.          var4 = this.jaggSQL.execSQL(var7, var5);
  110.       }
  111.  
  112.       if (var4 == -1) {
  113.          this.user.u.setSqlMessage(this.jaggSQL, var6);
  114.          return false;
  115.       } else {
  116.          if (var4 == 1) {
  117.             if (var2.equals("I")) {
  118.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message4"), 3);
  119.             } else if (var2.equals("D")) {
  120.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message5"), 3);
  121.             } else {
  122.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message6"), 3);
  123.             }
  124.          } else {
  125.             this.user.u.setSqlMessage(this.jaggSQL, var6);
  126.          }
  127.  
  128.          return var7 != null;
  129.       }
  130.    }
  131.  
  132.    void Grid1UpdateRowsMain(String[] var1, String var2) {
  133.       JDPTextGrid var3 = this.Grid1GL1;
  134.       int var4 = 0;
  135.       int var5 = 0;
  136.       int var6 = 1;
  137.       int var7 = 1;
  138.       boolean var8 = false;
  139.  
  140.       for(int var9 = 0; var9 < var3.rowChanged.length; ++var9) {
  141.          if (var3.rowChanged[var9]) {
  142.             if (var9 >= var3.totalDataRows) {
  143.                ++var5;
  144.             } else {
  145.                ++var4;
  146.             }
  147.          }
  148.       }
  149.  
  150.       for(int var10 = 0; var10 < var3.rowChanged.length; ++var10) {
  151.          if (var3.rowChanged[var10]) {
  152.             if (var10 >= var3.totalDataRows) {
  153.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message7", var7++, var5), 0);
  154.                this.Grid1SaveData(var10, "I");
  155.             } else {
  156.                this.user.mainmsg.setStatusMsg(JDPLang.get("Message8", var6++, var4), 0);
  157.                if (this.Grid1SaveData(var10, "U")) {
  158.                   var8 = true;
  159.                }
  160.             }
  161.  
  162.             var3.rowChanged[var10] = false;
  163.          }
  164.       }
  165.  
  166.       if (var5 > 0 || var8) {
  167.          this.Grid1LoadGridMain(var1, var2);
  168.       }
  169.  
  170.    }
  171.  
  172.    public void Grid1WhereClauseMain() {
  173.       String[] var1 = new String[4];
  174.       String[] var2 = new String[4];
  175.       Vector var3 = new Vector();
  176.       Vector var4 = new Vector();
  177.       var1[0] = "Last Name";
  178.       var2[0] = "LASTNAME";
  179.       var1[1] = "First Name";
  180.       var2[1] = "FIRSTNAME";
  181.       var1[2] = "Employee ID";
  182.       var2[2] = "EMPID";
  183.       var1[3] = "Call ID";
  184.       var2[3] = "CALLID";
  185.       var3.addElement(new Vector());
  186.       var4.addElement(new Vector());
  187.       var3.addElement(new Vector());
  188.       var4.addElement(new Vector());
  189.       var3.addElement(new Vector());
  190.       var4.addElement(new Vector());
  191.       var3.addElement(new Vector());
  192.       var4.addElement(new Vector());
  193.       ((Vector)var3.elementAt(0)).addElement("Begins with");
  194.       ((Vector)var4.elementAt(0)).addElement("like");
  195.       ((Vector)var3.elementAt(0)).addElement("Contains");
  196.       ((Vector)var4.elementAt(0)).addElement("like");
  197.       ((Vector)var3.elementAt(1)).addElement("Begins with");
  198.       ((Vector)var4.elementAt(1)).addElement("like");
  199.       ((Vector)var3.elementAt(1)).addElement("Contains");
  200.       ((Vector)var4.elementAt(1)).addElement("like");
  201.       ((Vector)var3.elementAt(2)).addElement("Begins with");
  202.       ((Vector)var4.elementAt(2)).addElement("like");
  203.       ((Vector)var3.elementAt(2)).addElement("Contains");
  204.       ((Vector)var4.elementAt(2)).addElement("like");
  205.       ((Vector)var3.elementAt(3)).addElement("Greater than");
  206.       ((Vector)var4.elementAt(3)).addElement(">");
  207.       ((Vector)var3.elementAt(3)).addElement("Less than");
  208.       ((Vector)var4.elementAt(3)).addElement("<");
  209.       ((Vector)var3.elementAt(3)).addElement("Equal to");
  210.       ((Vector)var4.elementAt(3)).addElement("=");
  211.       int[] var5 = new int[4];
  212.       boolean[] var6 = new boolean[4];
  213.       var5[0] = 19;
  214.       var6[0] = true;
  215.       var5[1] = 19;
  216.       var6[1] = true;
  217.       var5[2] = 54;
  218.       var6[2] = true;
  219.       var5[3] = 8;
  220.       var6[3] = false;
  221.       this.Grid1SP1 = new JDPWhereClause(this.user, super.targetPanel, "", true, "", var1, var2, var3, var4, (String[][])null, (String[][])null, var5, var6, "FROM JDPHelpDesk WHERE (1=1)");
  222.       this.Grid1SP1.setDSNType("ACCESS");
  223.       this.Grid1SP1.setDataType(0, 12);
  224.       this.Grid1SP1.setDataType(1, 12);
  225.       this.Grid1SP1.setDataType(2, 1);
  226.       this.Grid1SP1.setDataType(3, 4);
  227.    }
  228.  
  229.    public void Grid1LoadEmptyGrid() {
  230.       JDPTextGrid var1 = this.Grid1GL1;
  231.       byte var2 = 7;
  232.       var1.currentText = new String[var2][50];
  233.       var1.cellChanged = null;
  234.       var1.rowChanged = null;
  235.       var1.columnSelected = null;
  236.       var1.rowKey = new String[50][1];
  237.       var1.newTable();
  238.       var1.totalDataRows = 0;
  239.       var1.setSortingEnabled(true);
  240.    }
  241.  
  242.    public void Grid1UpdateRows(String[] var1) {
  243.       this.Grid1UpdateRowsMain(var1, (String)null);
  244.    }
  245.  
  246.    public void Grid1LoadGridFromWhereClause(String var1) {
  247.       int var2 = var1.indexOf("WHERE ");
  248.       var1 = " AND" + var1.substring(var2 + 5);
  249.       String[] var3 = new String[0];
  250.       this.Grid1LoadGridMain(var3, var1);
  251.    }
  252.  
  253.    public void Grid1DeleteRowsFromWhereClause(String var1) {
  254.       int var2 = var1.indexOf("WHERE ");
  255.       var1 = " AND" + var1.substring(var2 + 5);
  256.       String[] var3 = new String[0];
  257.       this.Grid1DeleteRowsMain(var3, var1);
  258.    }
  259.  
  260.    public void Grid1UpdateRowsFromWhereClause(String var1) {
  261.       int var2 = var1.indexOf("WHERE ");
  262.       var1 = " AND" + var1.substring(var2 + 5);
  263.       String[] var3 = new String[0];
  264.       this.Grid1UpdateRowsMain(var3, var1);
  265.    }
  266.  
  267.    public void Grid1SearchResultsMain() {
  268.    }
  269.  
  270.    public void InitComponents() {
  271.       this.jaggSQL.setKeepConnectionOpen(false);
  272.    }
  273.  
  274.    public boolean handleEvent(Event var1) {
  275.       switch (var1.id) {
  276.          case 503:
  277.          case 504:
  278.          case 505:
  279.             this.popuppanel.postEvent(var1);
  280.             return false;
  281.          case 1001:
  282.             if (var1.target.equals(this.Grid1SP1)) {
  283.                this.Grid1LoadGridFromWhereClause(this.Grid1SP1.getFromWhereClause());
  284.                return true;
  285.             } else if (var1.target.equals(this.JDPButtons1.button[0])) {
  286.                this.Grid1UpdateRowsFromWhereClause(this.Grid1SP1.getFromWhereClause());
  287.                return true;
  288.             } else if (var1.target.equals(this.JDPButtons1.button[1])) {
  289.                this.Grid1LoadGridFromWhereClause(this.Grid1SP1.getFromWhereClause());
  290.                return true;
  291.             } else {
  292.                if (var1.target.equals(this.JDPButtons1.button[2])) {
  293.                   this.Grid1DeleteRowsFromWhereClause(this.Grid1SP1.getFromWhereClause());
  294.                   return true;
  295.                }
  296.  
  297.                return false;
  298.             }
  299.          default:
  300.             return false;
  301.       }
  302.    }
  303.  
  304.    public void Grid1Main() {
  305.       this.Grid1SetGridSettings();
  306.       this.Grid1WhereClauseMain();
  307.       this.Grid1SearchResultsMain();
  308.       this.Grid1LoadGrid(new String[0]);
  309.    }
  310.  
  311.    public void Grid1LoadGrid(String[] var1) {
  312.       this.Grid1LoadGridMain(var1, (String)null);
  313.    }
  314.  
  315.    void Grid1LoadGridMain(String[] var1, String var2) {
  316.       JDPTextGrid var3 = this.Grid1GL1;
  317.       int var5 = 0;
  318.       Vector var6 = new Vector();
  319.       String var7 = this.jaggSQL.getSEP();
  320.       int var8 = 0;
  321.       byte var10 = 7;
  322.       new Vector();
  323.       new Vector();
  324.       String var11 = "SELECT CALLID, LASTNAME, PROBSUMM, IMPACT, CALLID, ASSIGNEDTO, STATUS, ENTRYDATE FROM JDPHelpDesk WHERE status <> 'Closed' AND (assignedto = '" + this.user.cust.username + "' OR '" + this.user.cust.username + "' = 'supportadmin')  ";
  325.       if (var1.length > 0 && var1[0] != null) {
  326.          var11 = var11 + " AND CALLID=" + var1[0] + "";
  327.       }
  328.  
  329.       if (var2 != null) {
  330.          var11 = var11 + var2;
  331.       }
  332.  
  333.       this.user.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);
  334.       this.jaggSQL.loadJdbcSettings("JDPHelpDesk");
  335.       this.jaggSQL.setUID("");
  336.       this.jaggSQL.setPWD("");
  337.       this.jaggSQL.setMRW("1000");
  338.       this.jaggSQL.setTOUT("60");
  339.       var5 = this.jaggSQL.execSQL(var11, var6);
  340.       if (var5 == -1) {
  341.          this.user.u.setSqlMessage(this.jaggSQL, var11);
  342.       } else {
  343.          var3.totalDataRows = this.jaggSQL.getRowCount();
  344.          var8 = this.jaggSQL.getRowCount() + 20;
  345.          var3.currentText = new String[var10][var8];
  346.          var3.cellChanged = null;
  347.          var3.rowChanged = null;
  348.          var3.columnSelected = null;
  349.          byte var12 = 1;
  350.          var3.rowKey = new String[var8][var12];
  351.          var3.recordLockValue = new String[var8];
  352.  
  353.          for(int var14 = 0; var14 < var8 - 20; ++var14) {
  354.             String var9 = (String)var6.elementAt(var14);
  355.             if (var9 != null && var9.trim().compareTo("") != 0) {
  356.                StringTokenizer var4 = new StringTokenizer(var9, var7);
  357.  
  358.                for(int var15 = 0; var15 < var12; ++var15) {
  359.                   var3.rowKey[var14][var15] = var4.nextToken().trim();
  360.                }
  361.  
  362.                for(int var19 = 0; var19 < var10; ++var19) {
  363.                   String var13 = var4.nextToken().trim();
  364.                   var3.currentText[var19][var14] = var13;
  365.                   if (var19 == 2 && var3.pullDownValue[2][0].indexOf(var13) >= 0) {
  366.                      var3.currentText[var19][var14] = var3.pullDownList[2][0].getItem(var3.pullDownValue[2][0].indexOf(var13));
  367.                   }
  368.  
  369.                   if (var19 == 4 && var3.pullDownValue[4][0].indexOf(var13) >= 0) {
  370.                      var3.currentText[var19][var14] = var3.pullDownList[4][0].getItem(var3.pullDownValue[4][0].indexOf(var13));
  371.                   }
  372.  
  373.                   if (var19 == 5 && var3.pullDownValue[5][0].indexOf(var13) >= 0) {
  374.                      var3.currentText[var19][var14] = var3.pullDownList[5][0].getItem(var3.pullDownValue[5][0].indexOf(var13));
  375.                   }
  376.  
  377.                   if (var19 == 6) {
  378.                      var3.currentText[var19][var14] = JDPDate.format(Long.valueOf(var13));
  379.                   }
  380.                }
  381.             }
  382.          }
  383.  
  384.          for(int var18 = var8 - 20; var18 < var8; ++var18) {
  385.             for(int var20 = 0; var20 < var1.length; ++var20) {
  386.                var3.rowKey[var18][var20] = var1[var20];
  387.             }
  388.          }
  389.  
  390.          var3.newTable();
  391.          this.user.mainmsg.clearStatusMsg();
  392.       }
  393.    }
  394.  
  395.    void Grid1DeleteRowsMain(String[] var1, String var2) {
  396.       JDPTextGrid var3 = this.Grid1GL1;
  397.       int var4 = 0;
  398.       int var5 = 1;
  399.  
  400.       for(int var6 = 0; var6 < var3.rowChanged.length; ++var6) {
  401.          if (var3.rowSelected[var6]) {
  402.             ++var4;
  403.          }
  404.       }
  405.  
  406.       for(int var7 = 0; var7 < var3.rowChanged.length; ++var7) {
  407.          if (var3.rowSelected[var7]) {
  408.             this.user.mainmsg.setStatusMsg(JDPLang.get("Message9", var5++, var4), 0);
  409.             this.Grid1SaveData(var7, "D");
  410.          }
  411.       }
  412.  
  413.       if (var4 > 0) {
  414.          this.Grid1LoadGridMain(var1, var2);
  415.       }
  416.  
  417.    }
  418.  
  419.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  420.       this.user = var1;
  421.       this.moduleParameter = var3;
  422.       super.targetPanel = var2;
  423.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  424.       ((Container)this).setLayout(new BorderLayout());
  425.       this.popuppanel = new JDPPopupMessage(var1, this);
  426.       ((Container)this).add(this.popuppanel);
  427.       this.JDPMaskEditMain = new JDPMaskEdit();
  428.       this.Main = new Panel();
  429.       this.ChiselPanel1 = new JDPChiselFramePanel(var1, "Open Requests");
  430.       this.Grid1 = new Panel();
  431.       this.Panel1 = new Panel();
  432.       this.Grid1GL1 = new JDPTextGrid(var1);
  433.       String[] var4 = new String[]{"Apply", "Refresh", "Remove"};
  434.       int[] var5 = new int[]{JDPButton.getIconValue("Save"), JDPButton.getIconValue("Undo"), JDPButton.getIconValue("Delete")};
  435.       this.JDPButtons1 = new JDPButtons(var1, var4, var5, JDPButtons.getAlignmentValue("Horizontal"));
  436.       this.Main.setLayout(new BorderLayout());
  437.       this.Main.setForeground(var1.u._cvtcolor("Black"));
  438.       this.Main.setBackground(var1.u._cvtcolor("LightGray"));
  439.       ((Container)this).add("Center", this.Main);
  440.       this.Main.add("Center", this.ChiselPanel1);
  441.       this.ChiselPanel1.add("Center", this.Grid1);
  442.       this.Grid1.setLayout(new BorderLayout());
  443.       this.Grid1Main();
  444.       this.Grid1.add("Center", this.Panel1);
  445.       this.Panel1.setLayout(new BorderLayout());
  446.       this.Panel1.add("North", this.Grid1SP1);
  447.       this.Panel1.add("Center", this.Grid1GL1);
  448.       this.Panel1.add("South", this.JDPButtons1);
  449.       this.Grid1SP1.setHorizontalLayout(true);
  450.       var1.gParm.addElement(this);
  451.       this.InitComponents();
  452.    }
  453.  
  454.    public void Grid1DeleteRows(String[] var1) {
  455.       this.Grid1DeleteRowsMain(var1, (String)null);
  456.    }
  457.  
  458.    void Grid1SetGridSettings() {
  459.       if (this.Grid1 == null) {
  460.          this.Grid1 = new JDPTextGrid(this.user);
  461.       }
  462.  
  463.       JDPTextGrid var1 = this.Grid1GL1;
  464.       byte var2 = 7;
  465.       var1.fieldTypeCol = new int[var2];
  466.       var1.columnHeader = new String[var2];
  467.       var1.columnHeaderStyle = new int[var2];
  468.       var1.columnStyle = new int[var2];
  469.       var1.columnHeaderColor = new Color[var2];
  470.       var1.columnColor = new Color[var2];
  471.       var1.columnBGColor = new Color[var2];
  472.       var1.columnProtected = new boolean[var2];
  473.       var1.columnDisabled = new boolean[var2];
  474.       var1.columnWidth = new int[var2];
  475.       var1.rightJustify = new boolean[var2];
  476.       var1.rowHeader = null;
  477.       var1.columnHeight = null;
  478.  
  479.       for(int var3 = 0; var3 < var2; ++var3) {
  480.          var1.columnHeaderStyle[var3] = 1;
  481.          var1.columnStyle[var3] = 0;
  482.          var1.columnHeaderColor[var3] = Color.black;
  483.          var1.columnColor[var3] = Color.black;
  484.          var1.columnBGColor[var3] = Color.white;
  485.          var1.columnStyle[var3] = 0;
  486.       }
  487.  
  488.       var1.columnProtected[2] = true;
  489.       var1.columnProtected[3] = true;
  490.       var1.columnProtected[4] = true;
  491.       var1.columnProtected[5] = true;
  492.       var1.columnProtected[6] = true;
  493.       var1.columnDisabled[6] = true;
  494.       var1.columnWidth[0] = 73;
  495.       var1.columnWidth[1] = 239;
  496.       var1.columnWidth[2] = 70;
  497.       var1.columnWidth[3] = 42;
  498.       var1.columnWidth[4] = 87;
  499.       var1.columnWidth[5] = 65;
  500.       var1.columnWidth[6] = 72;
  501.       var1.rightJustify[3] = true;
  502.       var1.columnHeader[0] = "Last Name";
  503.       var1.columnHeader[1] = "Prob Summary";
  504.       var1.columnHeader[2] = "Impact";
  505.       var1.columnHeader[3] = "Call ID";
  506.       var1.columnHeader[4] = "Assigned To";
  507.       var1.columnHeader[5] = "Status";
  508.       var1.columnHeader[6] = "Entrydate";
  509.       var1.columnColor[2] = this.user.u._cvtcolor("Red");
  510.       var1.columnColor[6] = this.user.u._cvtcolor("Blue");
  511.       var1.columnBGColor[3] = this.user.u._cvtcolor("LightGray");
  512.       this.Grid1LoadEmptyGrid();
  513.       this.Grid1LoadChoices();
  514.    }
  515. }
  516.