CD Actual Thematic 7: Programming/CDAT7.iso/Share/Java/JDesignerPro/Jdp3_0.exe/data1.cab/HelpDesk_Module/Applications/HelpDesk/OpenRequests.jdp

Text File | 1999-04-09 | 58.3 KB | 2,983 lines

#C:\Microsoft\Inetsrv\wwwroot\JDesignerPro\Applications\HelpDesk\OpenRequests.jdp
#Tue Nov 03 09:32:48 PST 1998
56|1|1=FIRSTNAME
56|1|0=LASTNAME
JDPSearchLayoutGrid1|columns=61
68|16|19=
68|16|18=
68|16|17=
68|16|16=
68|16|15=
110|16=Y
68|16|14=
110|15=Y
68|16|13=
110|14=Y
68|16|12=
110|13=Y
68|16|11=
110|12=Y
68|16|10=
110|11=Y
110|10=Y
117|3|9=
117|3|8=
117|3|7=
117|3|6=
117|3|5=
117|3|4=
117|3|3=
117|3|2=
117|3|1=like
117|3|0=like
124|x=7
226|Grid1UpdateRows3=233
124|6=72
124|5=65
124|4=87
JDPListLayoutGrid1|includeTree=79
124|3=42
124|2=70
124|1=239
124|0=73
JDPSelectColumnsGrid1|columns=58
116|14|9=
116|14|8=
116|14|7=
116|14|6=
116|14|5=
116|14|4=Pending
116|14|3=Closed
116|14|2=Reassign
116|14|1=Assigned
116|14|0=Progress
70|x=17
69|10|19=
115|x=17
69|10|18=
69|10|17=
69|10|16=
69|10|15=
69|10|14=
69|10|13=
69|10|12=
69|10|11=
69|10|10=
147|1|10=true
70|9=
70|8=
70|7=
70|6=
70|5=
70|4=
70|3=
70|2=
70|1=
70|0=
118|16=
118|15=
118|13=JDPUser
118|12=
118|11=
118|10=
115|9=Fields entered here
115|8=Fields entered here
115|7=Fields entered here
115|6=Fields entered here
115|5=Fields entered here
115|4=Fields entered here
115|3=Fields entered here
115|2=Fields entered here
115|1=Fields entered here
115|0=Fields entered here
24|1|9=Black
24|1|8=11
24|1|7=Plain
24|1|6=Helvetica
24|1|5=
24|1|4=
24|1|3=
24|1|2=
24|1|1=Open Requests
24|1|0=Center
58|0|9=IMPACT
58|0|8=PROBSUMM
58|0|7=POSSOLUTN
58|0|6=ITEMAFFECT
58|0|5=PROBTYPE
58|0|4=EMAIL
58|0|3=PHONE
58|0|2=EMPID
58|0|1=FIRSTNAME
58|0|0=LASTNAME
68|14|9=
68|14|8=
68|14|7=
68|14|6=
69|14|19=
68|14|5=
69|14|18=
68|14|4=support4
69|14|17=
68|14|3=support3
69|14|16=
68|14|2=support2
69|14|15=
68|14|1=support1
69|14|14=
68|14|0=Support Admin
69|14|13=
69|14|12=
69|14|11=
69|14|10=
JDPSearchLayoutGrid1|constantLength=65
106|x=17
283|bi=287
12|y=11
12|x=3
JDPChoiceLayoutGrid1SL1|tableWhereClause=75
210|y=23
210|x=3
250|bi=254
106|9=10
106|8=102
106|7=40
106|6=52
106|5=12
106|4=52
106|3=15
106|2=52
106|1=17
106|0=17
154|Grid1GL11=163
259|v=1
259|t=265
259|n=260
259|i=262
259|e=261
146|x=1
259|d=264
259|a=281
250|v=1
250|t=258
250|n=251
250|m=257
250|k=256
314|x=1
250|i=253
250|e=252
250|d=255
250|a=282
146|0=
89|16=Finlsolutn
89|15=Entrydate
89|14=Status
89|13=Assignedto
89|12=Worklog
89|11=Callid
89|10=Probdetail
299|x=306
JDPSelectDSNGrid1|sourcetype=44
299|w=1
299|t=305
299|n=300
68|3|9=
68|3|8=
68|3|7=
314|0=Grid1DeleteRows5
68|3|6=
299|i=302
68|3|5=
68|3|4=
68|3|3=
55|1|9=IMPACT
68|3|2=
55|1|8=PROBSUMM
299|e=301
186|x=1
68|3|1=Contains
55|1|7=POSSOLUTN
299|d=304
68|3|0=Begins with
55|1|6=ITEMAFFECT
55|1|5=PROBTYPE
299|b=313
55|1|4=EMAIL
55|1|3=PHONE
55|1|2=EMPID
55|1|1=FIRSTNAME
55|1|0=LASTNAME
116|10|19=
116|10|18=
116|10|17=
116|10|16=
116|10|15=
116|10|14=
116|10|13=
116|10|12=
116|10|11=
116|10|10=
137|y=11
137|x=3
100|16=0
100|15=0
100|14=0
100|13=0
100|12=0
100|11=0
100|10=0
116|3|9=
116|3|8=
116|3|7=
116|3|6=
116|3|5=
116|3|4=
116|3|3=
116|3|2=
116|3|1=Contains
116|3|0=Begins with
137|0|9=FColor:
137|0|8=Size:
241|n=242
137|0|7=Style:
137|0|6=Font:
137|0|5=Back to:
137|0|4=Tab to:
137|0|3=Status:
241|i=244
137|0|2=Popup:
137|0|1=Layout:
137|0|0=Pos:
241|e=243
241|d=246
186|0=Grid1GL11
1|ChiselPanel10=13
69|7|9=
69|7|8=
69|7|7=
69|7|6=
69|7|5=
69|7|4=
69|7|3=
69|7|2=
69|7|1=like
69|7|0=like
116|14|19=
116|14|18=
116|14|17=
116|14|16=
116|14|15=
116|14|14=
116|14|13=
116|14|12=
116|14|11=
116|14|10=
177|x=1
104|16=Left
104|15=Left
104|14=Left
104|13=Left
83|x=17
104|12=Left
104|11=Right
104|10=Left
148|ACTION_EVENT0=154
281|x=1
117|7|9=
117|7|8=
117|7|7=
117|7|6=
117|7|5=
117|7|4=
117|7|3=
117|7|2=
117|7|1=like
117|7|0=like
83|9=0
83|8=0
83|7=0
177|0=Grid1LoadGridFromWhereClause(Grid1SP1.getFromWhereClause());
83|6=0
83|5=0
83|4=0
83|3=0
83|2=0
83|1=0
83|0=0
JDPGridSettingsGrid1|fieldStyle=100
281|0=Grid1LoadGrid4
JDPSelectDSNGrid1|usernameChoice=50
108|16=
108|15=
108|14=
108|13=
108|12=
108|11=
108|10=
JDPSelectTableGrid1|tableTypes=51
JDPSelectDSNGrid1|datasourceC=43
JDPSelectDSNGrid1|datasource=38
JDPSelectDSNGrid1|dataSources=37
74|x=17
71|16=
71|15=
71|14=
71|12=
71|11=
71|10=
126|bi=130
119|x=17
25|x=35
25|v=1
25|t=33
25|r=36
25|p=34
25|n=26
25|m=32
117|1|19=
117|1|18=
25|k=31
117|1|17=
117|1|16=
25|i=28
117|1|15=
117|1|14=
117|1|13=
117|1|12=
25|e=27
36|1|10=LightGray
117|1|11=
25|d=30
117|1|10=
25|a=319
110|x=17
74|9=
74|8=
74|7=
74|6=
74|5=
74|4=
74|3=
74|2=
74|1=
74|0=
58|0|16=FINLSOLUTN
58|0|15=ENTRYDATE
58|0|14=STATUS
58|0|13=ASSIGNEDTO
JDPGridSettingsGrid1|maxRows=113
58|0|12=WORKLOG
58|0|11=CALLID
58|0|10=PROBDETAIL
119|8=
119|7=
119|6=
119|5=
119|4=
119|3=
119|2=
119|1=
119|0=
117|12|19=
117|12|18=
117|12|17=
117|12|16=
117|12|15=
117|12|14=
117|12|13=
117|12|12=
117|12|11=
75|16=(1=1)
117|12|10=
JDPGridSettingsGrid1|fieldTotal=105
75|15=(1=1)
75|14=(1=1)
75|13=(1=1)
75|12=(1=1)
110|9=Y
75|11=(1=1)
110|8=Y
75|10=(1=1)
110|7=Y
110|6=Y
110|5=Y
110|4=Y
110|3=Y
110|2=Y
110|1=Y
110|0=Y
65|x=17
117|5|19=
117|5|18=
117|5|17=
117|5|16=
117|5|15=
117|5|14=
117|5|13=
117|5|12=
117|5|11=
117|5|10=
69|1|19=
69|1|18=
69|1|17=
69|1|16=
69|1|15=
69|1|14=
69|1|13=
69|1|12=
69|1|11=
69|1|10=
211|bi=215
101|x=17
65|9=12
65|8=104
24|1|10=LightGray
65|7=42
170|bi=174
65|6=54
65|5=14
65|4=54
65|3=17
65|2=54
65|1=19
65|0=19
117|16|19=
117|16|18=
117|16|17=
117|16|16=
117|16|15=
117|16|14=
117|16|13=
117|16|12=
117|16|11=
117|16|10=
199|y=10
199|x=3
117|9|19=
117|9|18=
117|9|17=
117|9|16=
117|9|15=
117|9|14=
101|9=Black
117|9|13=
101|8=Black
117|9|12=
101|7=Black
117|9|11=
101|6=Black
117|9|10=
101|5=Black
101|4=Black
101|3=Black
101|2=Black
123|16=(1=1)
101|1=Black
123|15=(1=1)
101|0=Black
123|14=(1=1)
123|13=(1=1)
123|12=(1=1)
123|11=(1=1)
123|10=(1=1)
117|12|9=
117|12|8=
117|12|7=
117|12|6=
117|12|5=
117|12|4=
69|5|19=
117|12|3=
69|5|18=
117|12|2=
69|5|17=
117|12|1=like
69|5|16=
JDPListLayoutGrid1|psortOrder=91
117|12|0=like
69|5|15=
69|5|14=
69|5|13=
69|5|12=
69|5|11=
69|5|10=
318|x=3
116|2|19=
116|2|18=
116|2|17=
116|2|16=
116|2|15=
116|2|14=
116|2|13=
116|2|12=
116|2|11=
116|2|10=
199|0|9=BColor:
199|0|8=FColor:
199|0|7=Size:
199|0|6=Style:
199|0|5=Font:
199|0|4=Back to:
199|0|3=Tab to:
199|0|2=Status:
199|0|1=Popup:
199|0|0=Pos:
57|1|16=FINLSOLUTN
57|1|15=ENTRYDATE
57|1|14=STATUS
JDPGridSettingsGrid1|fieldTextColor=102
57|1|13=ASSIGNEDTO
57|1|12=WORKLOG
57|1|11=CALLID
57|1|10=PROBDETAIL
12|1|10=LightGray
JDPGridSettingsGrid1|fieldWidth=106
68|7|9=
318|2=JDPButtons110
68|7|8=
318|1=Grid1GL18
68|7|7=
318|0=Grid1SP17
68|7|6=
68|7|5=
68|7|4=
68|7|3=
68|7|2=
68|7|1=Contains
68|7|0=Begins with
96|x=17
69|9|19=
69|9|18=
69|9|17=
69|9|16=
69|9|15=
69|9|14=
69|9|13=
69|9|12=
69|9|11=
69|9|10=
116|6|19=
116|6|18=
116|6|17=
116|6|16=
178|bi=182
116|6|15=
116|6|14=
116|6|13=
116|7|9=
116|6|12=
116|7|8=
116|6|11=
116|7|7=
116|6|10=
116|7|6=
116|7|5=
116|7|4=
116|7|3=
69|12|9=
116|7|2=
69|12|8=
90|16=FINLSOLUTN
116|7|1=Contains
69|12|7=
90|15=ENTRYDATE
116|7|0=Begins with
69|12|6=
90|14=STATUS
69|12|5=
90|13=ASSIGNEDTO
69|12|4=
90|12=WORKLOG
69|12|3=
90|11=CALLID
69|12|2=
90|10=PROBDETAIL
69|12|1=like
69|12|0=like
68|2|19=
96|9=IMPACT
68|2|18=
96|8=PROBSUMM
68|2|17=
96|7=POSSOLUTN
68|2|16=
96|6=ITEMAFFECT
68|2|15=
96|5=PROBTYPE
266|MethodParameters=274
68|2|14=
96|4=EMAIL
68|2|13=
96|3=PHONE
68|2|12=
96|2=EMPID
68|2|11=
96|1=FIRSTNAME
68|2|10=
96|0=LASTNAME
292|bi=296
210|1|22=LightGray
210|1|21=Black
210|1|20=11
69|2|9=
69|2|8=
JDPSelectTableGrid1|stables=53
69|2|7=
69|2|6=
69|2|5=
69|2|4=
69|2|3=
69|2|2=
69|2|1=like
69|2|0=like
94|16=false
94|15=true
94|14=true
94|13=true
94|12=false
94|11=true
94|10=false
210|1|19=Plain
210|1|18=Helvetica
68|6|19=
210|1|17=
68|6|18=
210|1|16=
68|6|17=
210|1|15=
68|6|16=
210|1|14=
68|6|15=
210|1|13=
68|6|14=
210|1|12=
68|6|13=
210|1|11=
68|6|12=
210|1|10=
68|6|11=
68|6|10=
117|2|9=
117|2|8=
117|2|7=
117|2|6=
117|2|5=
117|2|4=
117|2|3=
117|2|2=
117|2|1=like
117|2|0=like
123|x=17
68|11|19=
68|11|18=
68|11|17=
68|11|16=
68|11|15=
68|11|14=
68|11|13=
68|11|12=
68|11|11=
68|11|10=
98|16=true
98|15=false
98|14=false
98|13=false
98|12=true
98|11=false
98|10=true
123|9=(1=1)
123|8=(1=1)
123|7=(1=1)
123|6=(1=1)
123|5=(1=1)
123|4=(1=1)
123|3=(1=1)
123|2=(1=1)
123|1=(1=1)
123|0=(1=1)
65|16=42
65|15=14
65|14=14
65|13=19
65|12=42
65|11=8
65|10=42
116|13|9=
116|13|8=
116|13|7=
116|13|6=
116|13|5=
116|13|4=Support4
163|v=1
116|13|3=Support3
137|1|10=LightGray
116|13|2=Support2
163|t=169
116|13|1=Support1
116|13|0=Admin
163|n=164
68|15|19=
68|15|18=
68|15|17=
68|15|16=
163|i=166
68|15|15=
68|15|14=
68|15|13=
68|15|12=
163|e=165
68|15|11=
163|d=168
68|15|10=
163|a=185
JDPListLayoutGrid1|psortChoiceText=89
JDPListLayoutGrid1|psortChoiceSql=90
24|0|9=FColor:
24|0|8=Size:
24|0|7=Style:
69|y=20
24|0|6=Font:
69|x=17
24|0|5=Back to:
24|0|4=Tab to:
24|0|3=Status:
24|0|2=Popup:
24|0|1=Title:
24|0|0=Pos:
JDPGridSettingsGrid1|fieldActive=94
JDPGridSettingsGrid1|fieldLStyle=99
JDPSelectDSNGrid1|userid=46
68|13|9=
68|13|8=
68|13|7=
68|13|6=
68|13|5=
154|v=1
68|13|4=Support4
68|13|3=Support3
154|t=162
68|13|2=Support2
68|13|1=Support1
68|13|0=Admin
154|n=155
154|m=161
154|k=160
154|i=157
154|e=156
154|d=159
JDPSelectColumnsGrid1|columnsItems=55
154|a=186
105|x=17
11|x=2
147|0|10=HorizontalLayout:
JDPGridSettingsGrid1|fieldEditMask=109
JDPGridSettingsGrid1|fieldEditable=98
105|9=false
105|8=false
105|7=false
105|6=false
105|5=false
JDPGridSettingsGrid1|fieldAlignment=104
105|4=false
105|3=false
105|2=false
105|1=false
105|0=false
11|1=InitComponents|L|\t//\r\n\t//  Initialise other components by calling their methods\r\n\t//\r\n\tpublic void InitComponents() {\r\n\r\n\t\tjaggSQL.setKeepConnectionOpen(false);\r\n\r\n\t}\r\n\r\n
11|0=InitClass|L|//--------------------------------------------------------------------\r\n//                                                                    \r\n//  Module:       OpenRequests                                       \r\n//  Description:  OpenRequests\r\n//                                                                    \r\n//--------------------------------------------------------------------\r\n\r\nimport java.awt.*;\r\nimport java.awt.event.*;\r\nimport java.applet.*;\r\nimport java.util.*;\r\nimport java.io.*;\r\nimport java.net.*;\r\n\r\n\r\npublic class OpenRequests extends JDPClassLayout <Listeners> {\r\n\r\n\tJDPUser user;\r\n\tJDPJagg jaggSQL;\r\n\tJDPPopupMessage popuppanel;\r\n\tJDPMaskEdit JDPMaskEditMain;\r\n\tString moduleParameter;\r\n\t//\r\n\t//  Declare screen components\r\n\t//\r\n\tPanel Main;\r\n\tJDPChiselFramePanel ChiselPanel1;\r\n\tPanel Grid1;\r\n\tPanel Panel1;\r\n\tJDPWhereClause Grid1SP1;\r\n\tJDPTextGrid Grid1GL1;\r\n\tJDPButtons JDPButtons1;\r\n\r\n\tpublic void InitClass(JDPUser user, Panel targetPanel, String moduleParameter) {\r\n\r\n\t\tthis.user = user;\r\n\t\tthis.moduleParameter = moduleParameter;\r\n\t\t//\r\n\t\t//  Set JAGG settings for this class\r\n\t\t//\r\n\t\tjaggSQL = new JDPJagg(user.jaggPath);\r\n\r\n\t\tsetLayout(new BorderLayout());\r\n\t\tpopuppanel = new JDPPopupMessage(user,this);\r\n\t\tadd(popuppanel);\r\n\t\tJDPMaskEditMain = new JDPMaskEdit();\r\n\r\n\t\tMain = new Panel();\r\n\t\tChiselPanel1 = new JDPChiselFramePanel(user, "Open Requests");\r\n\t\tGrid1 = new Panel();\r\n\t\tPanel1 = new Panel();\r\n\t\t\t\tGrid1GL1 = new JDPTextGrid(user);\r\n\t\tString[] JDPButtons1btns = {"Apply","Refresh","Remove"};\r\n\t\tint[] JDPButtons1icns = {JDPButton.getIconValue("Save"),JDPButton.getIconValue("Undo"),JDPButton.getIconValue("Delete")};\r\n\t\tJDPButtons1 = new JDPButtons(user, JDPButtons1btns, JDPButtons1icns, JDPButtons.getAlignmentValue("Horizontal"));\r\n\r\n\t\tMain.setLayout(new BorderLayout());\r\n\t\tadd("Center", Main);\r\n\t\tMain.add("Center", ChiselPanel1);\r\n\t\tChiselPanel1.add("Center", Grid1);\r\n\t\tGrid1.setLayout(new BorderLayout());\r\n\t\tGrid1Main();\r\n\t\tGrid1.add("Center", Panel1);\r\n\t\tPanel1.setLayout(new BorderLayout());\r\n\t\tPanel1.add("North", Grid1SP1);\r\n\t\tPanel1.add("Center", Grid1GL1);\r\n\t\tPanel1.add("South", JDPButtons1);\r\n\r\n\t\tGrid1SP1.setHorizontalLayout(true);\r\n\r\n<ObjectListeners>\r\n\t\t//\r\n\t\t//  Initialise Components\r\n\t\t//\r\n\t\tInitComponents();\r\n\t\t//\r\n\t\t//  Add the handle to this panel to the global vector so other panels can\r\n\t\t//  access this one\r\n\t\t//\r\n\t\tuser.gParm.addElement(this);\r\n\t}\r\n\r\n<Events>\r\n\r\n<CodeBody>\r\n}\r\n\r\n
117|16|9=
117|16|8=
117|16|7=
117|16|6=
117|16|5=
117|16|4=
117|16|3=
117|16|2=
117|16|1=like
117|16|0=like
69|13|19=
69|13|18=
69|13|17=
69|13|16=
69|13|15=
69|13|14=
69|13|13=
69|13|12=
69|13|11=
69|13|10=
25|bi=29
209|x=1
313|x=1
200|x=209
200|w=1
JDPGridSettingsGrid1|uncheckedValue=111
200|t=207
200|r=210
200|p=208
200|n=201
200|k=206
JDPGridSettingsGrid1|fieldDefault=108
200|i=203
200|e=202
200|d=205
200|b=317
209|0=
68|2|9=
68|2|8=
68|2|7=
313|0=Method Parameters
68|2|6=
68|2|5=
68|2|4=
68|2|3=
68|2|2=
185|x=1
68|2|1=Contains
68|2|0=Begins with
91|x=17
69|16|9=
249|x=1
69|16|8=
69|16|7=
69|16|6=
1|x=11
69|16|5=
69|16|4=
1|v=1
69|16|3=
69|16|2=
1|t=9
69|16|1=like
69|16|0=like
1|r=12
1|p=10
1|n=2
1|m=8
1|k=7
1|i=4
136|x=1
1|e=3
1|d=6
1|a=321
116|2|9=
116|2|8=
116|2|7=
116|2|6=
116|2|5=
116|2|4=
116|2|3=
240|x=1
116|2|2=
116|2|1=Contains
116|2|0=Begins with
91|9=Ascending
91|8=Ascending
91|7=Ascending
185|0=LoadGridFromWhereClause(String)1
91|6=Ascending
91|5=Ascending
91|4=Ascending
91|3=Ascending
91|2=Ascending
91|1=Ascending
91|0=Ascending
JDPGridSettingsGrid1|fieldBackColor=103
JDPGridSettingsGrid1|fieldLText=95
249|0=Grid13
211|ACTION_BTN_22=283
211|ACTION_BTN_11=250
211|ACTION_BTN_00=217
136|0=
69|6|9=
69|6|8=
69|6|7=
JDPGridSettingsGrid1|fieldLabelColor=101
69|6|6=
69|6|5=
69|6|4=
69|6|3=
69|6|2=
240|0=Grid1UpdateRowsFromWhereClause(Grid1SP1.getFromWhereClause());
69|6|1=like
69|6|0=like
312=false
311=0
310=4
299|MethodParameters=307
309=true
308=Method Parameters
280|x=1
305=Grid1DeleteRows
304=false
303=5
302=1
301=false
300=Grid1DeleteRows
117|6|9=
117|6|8=
117|6|7=
117|6|6=
117|6|5=
117|6|4=
117|6|3=
117|6|2=
117|6|1=like
117|6|0=like
JDPSelectTableGrid1|tables=52
280|0=Method Parameters
116|13|19=
116|13|18=
116|13|17=
116|13|16=
116|13|15=
116|13|14=
116|13|13=
116|13|12=
116|13|11=
116|13|10=
103|16=White
103|15=White
103|14=White
103|13=White
73|x=17
103|12=White
103|11=LightGray
103|10=White
118|x=17
24|y=11
24|x=3
154|bi=158
73|9=
73|8=
73|7=
73|6=
73|5=
73|4=
73|3=
73|2=
73|1=
73|0=
JDPChoiceLayoutGrid1GS1|valuesFrom=115
118|8=
118|7=
118|6=
138|ComponentEvents=148
118|5=
118|4=
118|3=
118|2=
118|1=
118|0=
107|16=TextField
107|15=JDPDate
107|14=JDPChoice
107|13=JDPChoice
107|12=TextField
107|11=TextField
107|10=TextField
61|0|3=CALLID
61|0|2=EMPID
61|0|1=FIRSTNAME
61|0|0=LASTNAME
70|16=
70|15=
70|14=
70|12=
70|11=
70|10=
109|x=17
117|0|19=
117|0|18=
117|0|17=
117|0|16=
117|0|15=
117|0|14=
117|0|13=
117|0|12=
117|0|11=
36|0|10=BColor:
117|0|10=
100|x=17
109|9=
109|8=
109|7=
109|6=
109|5=
109|4=
109|3=
109|2=
109|1=
109|0=
198|x=1
117|11|19=
117|11|18=
117|11|17=
117|11|16=
117|11|15=
117|11|14=
117|11|13=
117|11|12=
117|11|11=
117|11|10=
74|16=
74|15=
74|14=
74|13=
100|9=0
74|12=
100|8=0
74|11=
100|7=0
74|10=
100|6=0
100|5=0
100|4=0
100|3=0
100|2=0
100|1=0
100|0=0
117|11|9=
JDPListLayoutGrid1|mainBranchText=80
117|11|8=
117|11|7=
117|11|6=
117|11|5=
117|4|19=
117|11|4=
117|4|18=
117|11|3=
117|4|17=
JDPListLayoutGrid1|mainBranchIcon=81
117|11|2==
117|4|16=
117|11|1=<
117|4|15=
117|11|0=>
117|4|14=
117|4|13=
117|4|12=
117|4|11=
117|4|10=
317|x=1
69|0|19=
69|0|18=
69|0|17=
69|0|16=
69|0|15=
69|0|14=
69|0|13=
69|0|12=
69|0|11=
69|0|10=
24|0|10=BColor:
JDPSearchLayoutGrid1|constantIsString=66
117|15|19=
117|15|18=
117|15|17=
117|15|16=
117|15|15=
117|15|14=
117|15|13=
117|15|12=
117|15|11=
117|15|10=
68|6|9=
68|6|8=
68|6|7=
317|0=Component Events
68|6|6=
68|6|5=
68|6|4=
68|6|3=
68|6|2=
189|x=198
68|6|1=Contains
68|6|0=Begins with
189|t=196
189|r=199
95|x=17
189|p=197
189|n=190
189|k=195
189|i=192
117|8|19=
189|e=191
117|8|18=
189|d=194
117|8|17=
117|8|16=
117|8|15=
117|8|14=
117|8|13=
117|8|12=
117|8|11=
117|8|10=
122|16=
122|15=
122|14=(1=1)
122|13=username
122|12=
122|11=
122|10=
116|6|9=
116|6|8=
116|6|7=
116|6|6=
116|6|5=
116|6|4=
116|6|3=
69|11|9=
116|6|2=
69|11|8=
116|6|1=Contains
69|11|7=
116|6|0=Begins with
69|11|6=
69|11|5=
69|4|19=
69|11|4=
69|4|18=
69|11|3=
69|4|17=
69|11|2==
69|4|16=
69|11|1=<
69|4|15=
69|11|0=>
69|4|14=
69|4|13=
69|4|12=
69|4|11=
69|4|10=
116|1|19=
95|9=Impact
116|1|18=
95|8=Prob Summary
116|1|17=
95|7=Possolutn
116|1|16=
95|6=Itemaffect
116|1|15=
95|5=Probtype
116|1|14=
95|4=Email
116|1|13=
95|3=Phone
116|1|12=
95|2=Empid
116|1|11=
95|1=First Name
116|1|10=
95|0=Last Name
12|0|10=BColor:
JDPSearchLayoutGrid1|pchooseFrom=62
69|1|9=
69|1|8=
69|1|7=
69|1|6=
69|1|5=
69|1|4=
69|1|3=
69|1|2=
69|1|1=like
69|1|0=like
69|8|19=
69|8|18=
69|8|17=
69|8|16=
69|8|15=
69|8|14=
JDPChoiceLayoutGrid1SL1|columnTextList=71
69|8|13=
69|8|12=
69|8|11=
69|8|10=
116|5|19=
116|5|18=
116|5|17=
116|5|16=
116|5|15=
116|5|14=
116|5|13=
116|5|12=
116|5|11=
116|5|10=
117|1|9=
JDPSelectColumnsGrid1|keys=59
117|1|8=
117|1|7=
117|1|6=
117|1|5=
117|1|4=
117|1|3=
117|1|2=
117|1|1=like
117|1|0=like
122|x=17
68|1|19=
68|1|18=
68|1|17=
68|1|16=
68|1|15=
68|1|14=
68|1|13=
68|1|12=
68|1|11=
68|1|10=
250|Grid14=259
122|9=(1=1)
122|8=
122|7=
122|6=
122|5=
122|4=
122|3=
122|2=
122|1=
122|0=
116|9|19=
116|9|18=
116|9|17=
210|0|22=BColor:
116|9|16=
210|0|21=FColor:
116|9|15=
210|0|20=Size:
116|9|14=
116|9|13=
116|9|12=
116|9|11=
116|9|10=
60|0|0=CALLID
148|bi=152
116|12|9=
116|12|8=
116|12|7=
116|12|6=
210|0|19=Style:
116|12|5=
210|0|18=Font:
116|12|4=
68|5|19=
210|0|17=Back to:
116|12|3=
68|5|18=
210|0|16=Tab to:
116|12|2=
68|5|17=
210|0|15=Status2:
116|12|1=Contains
68|5|16=
210|0|14=Popup2:
116|12|0=Begins with
68|5|15=
210|0|13=Status1:
JDPSearchLayoutGrid1|pinitChoice=64
68|5|14=
210|0|12=Popup1:
68|5|13=
210|0|11=Status0:
JDPChoiceLayoutGrid1SL1|columnDataType=73
68|5|12=
210|0|10=Popup0:
68|5|11=
68|5|10=
226|v=1
226|t=232
226|n=227
226|i=229
226|e=228
226|d=231
226|a=248
68|10|19=
68|10|18=
68|10|17=
68|10|16=
68|10|15=
56|1|16=FINLSOLUTN
68|10|14=
56|1|15=ENTRYDATE
68|10|13=
56|1|14=STATUS
68|10|12=
56|1|13=ASSIGNEDTO
68|10|11=
56|1|12=WORKLOG
68|10|10=
56|1|11=CALLID
56|1|10=PROBDETAIL
97|16=Yes
97|15=Yes
97|14=Yes
97|13=Yes
97|12=Yes
97|11=Yes
97|10=Yes
68|9|19=
68|9|18=
68|y=20
68|9|17=
68|x=17
68|9|16=
68|9|15=
68|9|14=
68|9|13=
68|9|12=
68|9|11=
JDPSelectColumnsGrid1|keysUpdateItems=57
68|9|10=
266|x=273
266|w=1
299|bi=303
266|t=272
266|n=267
266|i=269
68|12|9=
68|12|8=
68|12|7=
307|bi=311
266|e=268
68|12|6=
266|d=271
68|12|5=
68|12|4=
266|b=280
137|0|10=BColor:
68|12|3=
68|12|2=
68|12|1=Contains
266|bi=270
68|12|0=Begins with
JDPChoiceLayoutGrid1SL1|valuesFrom=67
68|14|19=
68|14|18=
68|14|17=
68|14|16=
68|14|15=
217|v=1
68|14|14=
68|14|13=
217|t=225
68|14|12=
68|14|11=
68|14|10=
217|n=218
217|m=224
163|LoadGridFromWhereClause(String)1=170
217|k=223
233|bi=237
217|i=220
321|x=1
217|e=219
104|x=17
217|d=222
217|a=249
200|bi=204
298=Grid1DeleteRows
297=false
296=5
295=27
294=true
293=Grid1
291=ACTION_BTN_2
290=Drop here to attach this component/method to this Event
JDPListLayoutGrid1|pinitChoice=92
12|1|9=Black
12|1|8=11
12|1|7=Plain
104|9=Left
12|1|6=Helvetica
104|8=Left
12|1|5=
104|7=Left
12|1|4=
104|6=Left
12|1|3=
104|5=Left
35|15=Grid1SearchResultsMain|R|\t/**\n\t * Create and load the Result List Panel\n\t */\n\tpublic void Grid1SearchResultsMain() {\r\n\r\n\t}\r\n\r\n
12|1|2=
104|4=Left
321|0=ChiselPanel10
35|14=Grid1WhereClauseMain|R|\t/**\n\t * Create and load the Search Panel\n\t */\n\tpublic void Grid1WhereClauseMain() {\r\n\r\n\t\tString[] Grid1cf = new String[4];\r\n\t\tString[] Grid1acf = new String[4];\r\n\t\tVector Grid1mu = new Vector();\r\n\t\tVector Grid1amu = new Vector();\r\n\t\tGrid1cf[0] = "Last Name";\r\n\t\tGrid1acf[0] = "LASTNAME";\r\n\t\tGrid1cf[1] = "First Name";\r\n\t\tGrid1acf[1] = "FIRSTNAME";\r\n\t\tGrid1cf[2] = "Employee ID";\r\n\t\tGrid1acf[2] = "EMPID";\r\n\t\tGrid1cf[3] = "Call ID";\r\n\t\tGrid1acf[3] = "CALLID";\r\n\t\tGrid1mu.addElement(new Vector());\r\n\t\tGrid1amu.addElement(new Vector());\r\n\t\tGrid1mu.addElement(new Vector());\r\n\t\tGrid1amu.addElement(new Vector());\r\n\t\tGrid1mu.addElement(new Vector());\r\n\t\tGrid1amu.addElement(new Vector());\r\n\t\tGrid1mu.addElement(new Vector());\r\n\t\tGrid1amu.addElement(new Vector());\r\n\t\t((Vector)Grid1mu.elementAt(0)).addElement("Begins with");\r\n\t\t((Vector)Grid1amu.elementAt(0)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(0)).addElement("Contains");\r\n\t\t((Vector)Grid1amu.elementAt(0)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(1)).addElement("Begins with");\r\n\t\t((Vector)Grid1amu.elementAt(1)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(1)).addElement("Contains");\r\n\t\t((Vector)Grid1amu.elementAt(1)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(2)).addElement("Begins with");\r\n\t\t((Vector)Grid1amu.elementAt(2)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(2)).addElement("Contains");\r\n\t\t((Vector)Grid1amu.elementAt(2)).addElement("like");\r\n\t\t((Vector)Grid1mu.elementAt(3)).addElement("Greater than");\r\n\t\t((Vector)Grid1amu.elementAt(3)).addElement(">");\r\n\t\t((Vector)Grid1mu.elementAt(3)).addElement("Less than");\r\n\t\t((Vector)Grid1amu.elementAt(3)).addElement("<");\r\n\t\t((Vector)Grid1mu.elementAt(3)).addElement("Equal to");\r\n\t\t((Vector)Grid1amu.elementAt(3)).addElement("=");\r\n\t\tint[] Grid1cl = new int[4];\r\n\t\tboolean[] Grid1cis = new boolean[4];\r\n\t\tGrid1cl[0] = 19;\r\n\t\tGrid1cis[0] = true;\r\n\t\tGrid1cl[1] = 19;\r\n\t\tGrid1cis[1] = true;\r\n\t\tGrid1cl[2] = 54;\r\n\t\tGrid1cis[2] = true;\r\n\t\tGrid1cl[3] = 8;\r\n\t\tGrid1cis[3] = false;\r\n\t\tGrid1SP1 = new JDPWhereClause(user, targetPanel, "", true, "", Grid1cf, Grid1acf, Grid1mu, Grid1amu, null, null, Grid1cl, Grid1cis, "FROM JDPHelpDesk WHERE (1=1)");\r\n\t\tGrid1SP1.setDSNType("ACCESS");\r\n\t\tGrid1SP1.setDataType(0,12);\r\n\t\tGrid1SP1.setDataType(1,12);\r\n\t\tGrid1SP1.setDataType(2,1);\r\n\t\tGrid1SP1.setDataType(3,4);\r\n\t}\r\n\r\n
12|1|1=BorderLayout
104|3=Left
35|13=Grid1LoadChoices|R|\t//\r\n\t//  Load all of the Screen Choices\r\n\t//\r\n\tvoid Grid1LoadChoices() {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\t\tint columnCount = 7;\r\n\r\n\t\tjaggSQL.loadJdbcSettings("JDPHelpDesk");\r\n\t\tjaggSQL.setUID("");\r\n\t\tjaggSQL.setPWD("");\r\n\t\tjaggSQL.setMRW("1000");\r\n\t\tjaggSQL.setTOUT("60");\r\n\r\n\t\ttableContents.isPullDownCol = new boolean[columnCount];\r\n\t\ttableContents.pullDownColType = new int[columnCount];\r\n\t\ttableContents.pullDownList = new List[columnCount][1];\r\n\t\ttableContents.isPullDownCol[2] = true;\r\n\t\ttableContents.isPullDownCol[4] = true;\r\n\t\ttableContents.isPullDownCol[5] = true;\r\n\t\ttableContents.pullDownColType[2] = JDPTextGrid.REGULAR;\r\n\t\ttableContents.pullDownColType[4] = JDPTextGrid.REGULAR;\r\n\t\ttableContents.pullDownColType[5] = JDPTextGrid.REGULAR;\r\n\t\ttableContents.pullDownList[2][0] = new List();\r\n\t\ttableContents.pullDownList[4][0] = new List();\r\n\t\ttableContents.pullDownList[5][0] = new List();\r\n\t\ttableContents.isPullDownCol[6] = true;\r\n\t\ttableContents.pullDownColType[6] = JDPTextGrid.DATE;\r\n\r\n\t\ttableContents.pullDownValue[2][0] = new Vector(); \r\n\t\ttableContents.pullDownList[2][0].addItem("Low"); \r\n\t\ttableContents.pullDownValue[2][0].addElement("Low"); \r\n\t\ttableContents.pullDownList[2][0].addItem("Medium"); \r\n\t\ttableContents.pullDownValue[2][0].addElement("Medium"); \r\n\t\ttableContents.pullDownList[2][0].addItem("High"); \r\n\t\ttableContents.pullDownValue[2][0].addElement("High"); \r\n\r\n\t\ttableContents.pullDownValue[5][0] = new Vector(); \r\n\t\ttableContents.pullDownList[5][0].addItem("Progress"); \r\n\t\ttableContents.pullDownValue[5][0].addElement("Progress"); \r\n\t\ttableContents.pullDownList[5][0].addItem("Assigned"); \r\n\t\ttableContents.pullDownValue[5][0].addElement("Assigned"); \r\n\t\ttableContents.pullDownList[5][0].addItem("Reassign"); \r\n\t\ttableContents.pullDownValue[5][0].addElement("Reassign"); \r\n\t\ttableContents.pullDownList[5][0].addItem("Closed"); \r\n\t\ttableContents.pullDownValue[5][0].addElement("Closed"); \r\n\t\ttableContents.pullDownList[5][0].addItem("Pending"); \r\n\t\ttableContents.pullDownValue[5][0].addElement("Pending"); \r\n\r\n\t\ttableContents.pullDownValue[4][0] = new Vector(); \r\n\t\tnew JDPLoadChoice(user,jaggSQL,tableContents.pullDownList[4][0],"username","username","JDPUser","(1=1)",tableContents.pullDownValue[4][0]);\r\n\t}\r\n\r\n
12|1|0=Center
104|2=Left
35|12=Grid1SetGridSettings|R|\t//\r\n\t//  Set up the parameters for this grid\r\n\t//\r\n\tvoid Grid1SetGridSettings() {\r\n\r\n\t\tif (Grid1 == null) {\r\n\t\t\tGrid1 = new JDPTextGrid(user);\r\n\t\t} \r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\t\tint columnCount = 7;\r\n\r\n\t\ttableContents.fieldTypeCol = new int[columnCount];\r\n\t\ttableContents.columnHeader = new String[columnCount];\r\n\t\ttableContents.columnHeaderStyle = new int[columnCount];\r\n\t\ttableContents.columnStyle = new int[columnCount];\r\n\t\ttableContents.columnHeaderColor = new Color[columnCount];\r\n\t\ttableContents.columnColor = new Color[columnCount];\r\n\t\ttableContents.columnBGColor = new Color[columnCount];\r\n\t\ttableContents.columnProtected = new boolean[columnCount];\r\n\t\ttableContents.columnDisabled = new boolean[columnCount];\r\n\t\ttableContents.columnWidth = new int[columnCount];\r\n\t\ttableContents.rightJustify = new boolean[columnCount];\r\n\t\ttableContents.rowHeader = null;\r\n\t\ttableContents.columnHeight = null;\r\n\t\tfor (int ix=0; ix<columnCount; ix++) {\r\n\t\t\ttableContents.columnHeaderStyle[ix] = Font.BOLD;\r\n\t\t\ttableContents.columnStyle[ix] = Font.PLAIN;\r\n\t\t\ttableContents.columnHeaderColor[ix] = Color.black;\r\n\t\t\ttableContents.columnColor[ix] = Color.black;\r\n\t\t\ttableContents.columnBGColor[ix] = Color.white;\r\n\t\t\ttableContents.columnStyle[ix] = Font.PLAIN;\r\n\t\t}\r\n\t\ttableContents.columnProtected[2] = true;\r\n\t\ttableContents.columnProtected[3] = true;\r\n\t\ttableContents.columnProtected[4] = true;\r\n\t\ttableContents.columnProtected[5] = true;\r\n\t\ttableContents.columnProtected[6] = true;\r\n\t\ttableContents.columnDisabled[6] = true;\r\n\t\ttableContents.columnWidth[0] = 73;\r\n\t\ttableContents.columnWidth[1] = 239;\r\n\t\ttableContents.columnWidth[2] = 70;\r\n\t\ttableContents.columnWidth[3] = 42;\r\n\t\ttableContents.columnWidth[4] = 87;\r\n\t\ttableContents.columnWidth[5] = 65;\r\n\t\ttableContents.columnWidth[6] = 72;\r\n\t\ttableContents.rightJustify[3] = true;\r\n\t\ttableContents.columnHeader[0] = "Last Name";\r\n\t\ttableContents.columnHeader[1] = "Prob Summary";\r\n\t\ttableContents.columnHeader[2] = "Impact";\r\n\t\ttableContents.columnHeader[3] = "Call ID";\r\n\t\ttableContents.columnHeader[4] = "Assigned To";\r\n\t\ttableContents.columnHeader[5] = "Status";\r\n\t\ttableContents.columnHeader[6] = "Entrydate";\r\n\t\ttableContents.columnColor[2] = user.u._cvtcolor("Red");\r\n\t\ttableContents.columnColor[6] = user.u._cvtcolor("Blue");\r\n\t\ttableContents.columnBGColor[3] = user.u._cvtcolor("LightGray");\r\n\r\n\t\tGrid1LoadEmptyGrid();\r\n\t\tGrid1LoadChoices();\r\n\t}\r\n\r\n
104|1=Left
289=Methods
35|11=Grid1LoadEmptyGrid|R|\t//\r\n\t//  Load the grid with the blank rows to allow data entry\r\n\t//\r\n\tpublic void Grid1LoadEmptyGrid() {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\t\tint columnCount = 7;\r\n\r\n\t\ttableContents.currentText = new String[columnCount][50];\r\n\t\ttableContents.cellChanged = null;\r\n\t\ttableContents.rowChanged = null;\r\n\t\ttableContents.columnSelected = null;\r\n\t\ttableContents.rowKey = new String[50][1];\r\n\t\ttableContents.newTable();\r\n\t\ttableContents.totalDataRows = 0;\r\n\t\ttableContents.setSortingEnabled(true);\r\n\t}\r\n\r\n
104|0=Left
288=false
35|10=Grid1SaveData|R|\t//\r\n\t//  Save the selected item\r\n\t//\r\n\tboolean Grid1SaveData(int tableRow, String action) {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\t\tint recCount = 0;\r\n\t\tVector results = new Vector();\r\n\t\tString sep = jaggSQL.getSEP();\r\n\t\tString SQL = "";\r\n\t\tString prevSQL = null;\r\n\r\n\t\tjaggSQL.loadJdbcSettings("JDPHelpDesk");\r\n\t\tjaggSQL.setUID("");\r\n\t\tjaggSQL.setPWD("");\r\n\t\tjaggSQL.setMRW("1000");\r\n\t\tjaggSQL.setTOUT("60");\r\n\r\n\t\tif (action.equals("I")) {\r\n\t\t\tSQL = "INSERT INTO JDPHelpDesk (LASTNAME, " +\r\n\t\t\t\t\t"PROBSUMM, " +\r\n\t\t\t\t\t"IMPACT, " +\r\n\t\t\t\t\t"ASSIGNEDTO, " +\r\n\t\t\t\t\t"STATUS, " +\r\n\t\t\t\t\t"ENTRYDATE, " +\r\n\t\t\t\t\t"FIRSTNAME, " +\r\n\t\t\t\t\t"EMPID, " +\r\n\t\t\t\t\t"PHONE, " +\r\n\t\t\t\t\t"EMAIL, " +\r\n\t\t\t\t\t"PROBTYPE, " +\r\n\t\t\t\t\t"ITEMAFFECT, " +\r\n\t\t\t\t\t"POSSOLUTN, " +\r\n\t\t\t\t\t"PROBDETAIL, " +\r\n\t\t\t\t\t"WORKLOG, " +\r\n\t\t\t\t\t"FINLSOLUTN) VALUES('" + user.u.replace(tableContents.currentText[0][tableRow],"'","''") + "', " +\r\n\t\t\t\t\t"'" + user.u.replace(tableContents.currentText[1][tableRow],"'","''") + "', " +\r\n\t\t\t\t\t"'" + (String)tableContents.pullDownValue[2][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[2][0],tableContents.currentText[2][tableRow])) + "', " +\r\n\t\t\t\t\t"'" + (String)tableContents.pullDownValue[4][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[4][0],tableContents.currentText[4][tableRow])) + "', " +\r\n\t\t\t\t\t"'" + (String)tableContents.pullDownValue[5][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[5][0],tableContents.currentText[5][tableRow])) + "', " +\r\n\t\t\t\t\t"" + JDPDate.formatForSql(tableContents.currentText[6][tableRow], user.u.getDataSourceType(jaggSQL)) + ", " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'', " +\r\n\t\t\t\t\t"'')";\r\n\t\t} else {\r\n\t\t\tif (action.equals("D")) {\r\n\t\t\t\tSQL = "DELETE FROM JDPHelpDesk" +\r\n\t\t\t\t\t" WHERE CALLID=" + tableContents.rowKey[tableRow][0]+ "" ;\r\n\t\t\t\tif (tableContents.recordLockValue[tableRow] != null) {\r\n\t\t\t\t\tprevSQL = SQL;\r\n\t\t\t\t}\r\n\t\t\t} else {\r\n\t\t\t\tSQL = "UPDATE JDPHelpDesk SET LASTNAME = '" + user.u.replace(tableContents.currentText[0][tableRow],"'","''") + "', " +\r\n\t\t\t\t\t"PROBSUMM = '" + user.u.replace(tableContents.currentText[1][tableRow],"'","''") + "', " +\r\n\t\t\t\t\t"IMPACT = '" + (String)tableContents.pullDownValue[2][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[2][0],tableContents.currentText[2][tableRow])) + "', " +\r\n\t\t\t\t\t"ASSIGNEDTO = '" + (String)tableContents.pullDownValue[4][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[4][0],tableContents.currentText[4][tableRow])) + "', " +\r\n\t\t\t\t\t"STATUS = '" + (String)tableContents.pullDownValue[5][0].elementAt(user.u.listIndexOf(tableContents.pullDownList[5][0],tableContents.currentText[5][tableRow])) + "', " +\r\n\t\t\t\t\t"ENTRYDATE = " + JDPDate.formatForSql(tableContents.currentText[6][tableRow], user.u.getDataSourceType(jaggSQL)) + "" +\r\n\t\t\t\t\t" WHERE CALLID=" + tableContents.rowKey[tableRow][0]+ "" ;\r\n\t\t\t\tif (tableContents.recordLockValue[tableRow] != null) {\r\n\t\t\t\t\tprevSQL = SQL;\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n\r\n\t\trecCount = jaggSQL.execSQL(SQL, results);\r\n\r\n\t\tif (user.DEBUG) System.out.println("saveData CNT: "+Integer.toString(recCount));\r\n\r\n\t\tif (recCount == 0 && prevSQL != null) {\r\n\t\t\tString[] buttons = {JDPLang.get("Reload"),JDPLang.get("Update")};\r\n\t\t\tint[] icons = {JDPButton.UNDO,JDPButton.SAVE};\r\n\t\t\tJDPMessageDialog d = new JDPMessageDialog(user, user.jdpMainWindow, JDPLang.get("Dialog0"), JDPLang.get("Dialog1"), buttons, icons);\r\n\t\t\td.display();\r\n\t\t\tif (d.getPressedButton() == 1) {\r\n\t\t\t\tresults = new Vector();\r\n\t\t\t\trecCount = jaggSQL.execSQL(prevSQL, results);\r\n\t\t\t} else {\r\n\t\t\t\treturn true;\r\n\t\t\t}\r\n\t\t}\r\n\r\n\t\tif(recCount == -1) {\r\n\t\t\tuser.u.setSqlMessage(jaggSQL,SQL);\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\tif(recCount == 1) {\r\n\t\t\tif (action.equals("I")) {\r\n\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message4"),3);\r\n\t\t\t} else \r\n\t\t\tif (action.equals("D")) {\r\n\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message5"),3);\r\n\t\t\t} else {\r\n\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message6"),3);\r\n\t\t\t}\r\n\t\t} else {\r\n\t\t\tuser.u.setSqlMessage(jaggSQL,SQL);\r\n\t\t}\r\n\t\tif (prevSQL != null) {\r\n\t\t\treturn true;\r\n\t\t}\r\n\t\treturn false;\r\n\r\n\t}\r\n\r\n
287=2
286=1
285=true
284=ACTION_BTN_2
117|15|9=
117|15|8=
117|15|7=
117|15|6=
117|15|5=
117|15|4=
117|15|3=
117|15|2=
117|15|1=like
117|15|0=like
279=false
278=0
277=4
276=true
275=Method Parameters
272=Grid1LoadGrid
271=false
270=4
163|bi=167
269=1
268=false
267=Grid1LoadGrid
265=Grid1LoadGrid
264=false
263=4
262=27
261=true
260=Grid1
258=ACTION_BTN_1
JDPListLayoutGrid1|uniqueTree=84
257=Drop here to attach this component/method to this Event
99|x=17
256=Methods
255=false
254=1
253=1
252=true
251=ACTION_BTN_1
68|1|9=
68|1|8=
68|1|7=
68|1|6=
68|1|5=
68|1|4=
68|1|3=
68|1|2=
184|x=1
68|1|1=Contains
68|1|0=Begins with
90|x=17
84|0|0=CALLID
246=false
245=0
244=4
243=true
242=Method Parameters
69|15|9=
248|x=1
69|15|8=
69|15|7=
69|15|6=
69|15|5=
69|15|4=
69|15|3=
69|15|2=
69|15|1=like
69|15|0=like
13|Grid11=25
69|12|19=
99|9=1
69|12|18=
99|8=1
69|12|17=
99|7=1
69|12|16=
99|6=1
69|12|15=
99|5=1
69|12|14=
99|4=1
69|12|13=
99|3=1
69|12|12=
99|2=1
69|12|11=
99|1=1
69|12|10=
116|1|9=
239=Grid1UpdateRows
99|0=1
116|1|8=
238=false
116|1|7=
237=3
116|1|6=
236=1
116|1|5=
235=false
116|1|4=
234=Grid1UpdateRows
116|1|3=
116|1|2=
232=Grid1UpdateRows
116|1|1=Contains
231=false
116|1|0=Begins with
230=3
90|9=IMPACT
90|8=PROBSUMM
90|7=POSSOLUTN
184|0=Method Parameters
90|6=ITEMAFFECT
90|5=PROBTYPE
90|4=EMAIL
90|3=PHONE
90|2=EMPID
90|1=FIRSTNAME
90|0=LASTNAME
229=27
228=true
227=Grid1
225=ACTION_BTN_0
224=Drop here to attach this component/method to this Event
248|0=Grid1UpdateRows3
223=Methods
222=false
221=0
220=1
69|5|9=
69|5|8=
69|5|7=
69|5|6=
219=true
69|5|5=
218=ACTION_BTN_0
69|5|4=
69|5|3=
216=false
69|5|2=
215=0
69|5|1=like
214=4
69|5|0=like
213=true
212=Component Events
69|16|19=
83|16=0
69|16|18=
83|15=0
69|16|17=
83|14=0
69|16|16=
83|13=0
69|16|15=
83|12=0
69|16|14=
83|11=0
69|16|13=
83|10=0
69|16|12=
69|16|11=
69|16|10=
138|bi=142
208=South
207=JDPButtons
206=Components
205=true
204=10
203=17
202=false
201=JDPButtons1
117|5|9=
117|5|8=
117|5|7=
117|5|6=
117|5|5=
117|5|4=
117|5|3=
117|5|2=
117|5|1=like
117|5|0=like
126|x=136
126|v=3
126|t=134
126|r=137
126|p=135
126|n=127
126|m=133
126|k=132
126|i=129
126|e=128
126|d=131
126|a=318
JDPLayoutMgr|compTree=1
36|1|9=Black
36|1|8=11
36|1|7=Plain
36|1|6=Helvetica
36|1|5=
36|1|4=
36|1|3=
36|1|2=
36|1|1=BorderLayout
36|1|0=Center
52|0|0=JDPHelpDesk
116|16|9=
nextIndex=321
116|16|8=
116|16|7=
116|16|6=
116|16|5=
116|16|4=
116|16|3=
116|16|2=
116|16|1=Contains
116|16|0=Begins with
72|x=17
117|y=20
117|x=17
23|x=1
147|1|9=LightGray
147|1|8=Black
147|1|7=11
147|1|6=Plain
147|1|5=Helvetica
147|1|4=
147|1|3=
147|1|2=
147|1|1=
147|1|0=North
JDPGridSettingsGrid1|includeInUpdateSql=97
72|9=
72|8=
72|7=
72|6=
72|5=
72|4=
72|3=
72|2=
72|1=
72|0=
JDPSelectColumnsGrid1|keysItems=56
116|12|19=
116|12|18=
116|12|17=
116|12|16=
116|12|15=
116|12|14=
116|12|13=
116|12|12=
68|16|9=
116|12|11=
68|16|8=
116|12|10=
68|16|7=
68|16|6=
68|16|5=
68|16|4=
102|16=Black
68|16|3=
102|15=Blue
68|16|2=
102|14=Black
68|16|1=Contains
102|13=Black
68|16|0=Begins with
63|x=17
102|12=Black
102|11=Black
102|10=Black
108|x=17
63|9=IMPACT
63|8=PROBSUMM
63|7=POSSOLUTN
63|6=ITEMAFFECT
63|5=PROBTYPE
63|4=EMAIL
63|3=PHONE
63|2=EMPID
63|1=FIRSTNAME
63|0=LASTNAME
JDPSelectTableGrid1|joinConditions=54
116|16|19=
108|9=
116|16|18=
108|8=
116|16|17=
108|7=
116|16|16=
108|6=
116|16|15=
108|5=
116|16|14=
108|4=
116|16|13=
108|3=
116|16|12=
108|2=
116|16|11=
108|1=
116|16|10=
108|0=
106|16=40
106|15=12
106|14=12
106|13=17
106|12=40
106|11=6
106|10=40
JDPChoiceLayoutGrid1GS1|columnTextList=119
148|v=1
210|1|9=Delete
210|1|8=Remove
148|n=149
210|1|7=Undo
210|1|6=Refresh
210|1|5=Save
210|1|4=Apply
117|10|9=
210|1|3=3
148|i=151
117|10|8=
210|1|2=Horizontal
117|10|7=
210|1|1=Yes
117|10|6=
210|1|0=South
117|10|5=
148|e=150
117|10|4=
148|d=153
117|10|3=
117|10|2=
117|10|1=like
148|a=187
117|10|0=like
JDPListLayoutGrid1|maxRows=86
316|x=3
JDPGridSettingsGrid1|pfromwhereclause=112
JDPGridSettingsGrid1|checkedValue=110
68|5|9=
316|2=ACTION_BTN_22
68|5|8=
316|1=ACTION_BTN_11
68|5|7=
316|0=ACTION_BTN_00
68|5|6=
68|5|5=
68|5|4=
68|5|3=
68|5|2=
188|x=1
68|5|1=Contains
68|5|0=Begins with
94|x=17
117|10|19=
117|10|18=
117|10|17=
117|10|16=
117|10|15=
117|10|14=
117|10|13=
292|v=1
117|10|12=
117|10|11=
292|t=298
73|16=
117|10|10=
73|15=
73|14=
73|13=
73|12=
73|11=
292|n=293
73|10=
JDPChoiceLayoutGrid1GS1|columnDataType=121
292|i=295
JDPSelectDSNGrid1|connectstring=47
292|e=294
292|d=297
93=(1=1)
92=
292|a=314
116|5|9=
116|5|8=
116|5|7=
116|5|6=
116|5|5=
116|5|4=
116|5|3=
69|10|9=
116|5|2=
69|10|8=
116|5|1=Contains
69|10|7=
116|5|0=Begins with
117|3|19=
69|10|6=
117|3|18=
69|10|5=
117|3|17=
69|10|4=
117|3|16=
69|10|3=
117|3|15=
69|10|2=
117|3|14=
69|10|1=like
117|3|13=
69|10|0=like
117|3|12=
117|3|11=
117|3|10=
88=Yes
94|9=true
87=Total Entries:
94|8=true
86=100
94|7=false
188|0=Component Events
85=130
94|6=false
307|n=308
94|5=false
94|4=false
82=Folder
94|3=false
81=Folder
94|2=false
80=
94|1=false
307|i=310
94|0=true
307|e=309
307|d=312
77=Tree Structure
69|9|9=
69|9|8=
69|9|7=
69|9|6=
JDPChoiceLayoutGrid1SL1|actualChoiceValue=69
69|9|5=
69|9|4=
117|14|19=
69|9|3=
117|14|18=
69|9|2=
117|14|17=
69|9|1=like
117|14|16=
69|9|0=like
117|14|15=
117|14|14=
117|14|13=
117|14|12=
117|14|11=
117|14|10=
JDPListLayoutGrid1|displayCount=88
64=
69|0|9=
69|0|8=
69|0|7=
69|0|6=
69|0|5=
69|0|4=
69|0|3=
69|0|2=
69|0|1=like
69|0|0=like
283|v=1
117|7|19=
117|7|18=
283|t=291
117|7|17=
117|7|16=
117|7|15=
117|7|14=
117|9|9=
117|7|13=
117|9|8=
117|7|12=
117|9|7=
283|n=284
117|7|11=
117|9|6=
283|m=290
117|7|10=
117|9|5=
117|9|4=
283|k=289
117|9|3=
117|9|2=High
283|i=286
117|9|1=Medium
121|16=
117|9|0=Low
121|15=
283|e=285
170|x=177
121|13=1
283|d=288
170|w=1
121|12=
121|11=
121|10=
36|y=11
283|a=315
170|t=176
36|x=3
170|n=171
51=Tables and Views
50=This username/password
170|i=173
69|3|19=
69|3|18=
170|e=172
69|3|17=
170|d=175
69|3|16=
69|3|15=
170|b=184
69|3|14=
117|0|9=
69|3|13=
117|0|8=
69|3|12=
117|0|7=
69|3|11=
117|0|6=
69|3|10=
117|0|5=
117|0|4=
117|0|3=
117|0|2=
117|0|1=like
117|0|0=like
121|x=17
116|0|19=
116|0|18=
116|0|17=
116|0|16=
116|0|15=
116|0|14=
116|0|13=
116|0|12=
116|0|11=
49=60
116|0|10=
48=1000
47=DSN=JDPHelpDesk;UID=;PWD=;
46=
45=
44=
43=JDPHelpDesk
42=No
41=JDPHelpDesk
40=jdbc:odbc:
39=sun.jdbc.odbc.JdbcOdbcDriver
38=JDPHelpDesk
34=Center
33=JDPWizGrid
32=Drop here to add this component to the Panel
31=Components
30=true
121|8=
121|7=
121|6=
121|5=
121|4=
121|3=
121|2=
121|1=
121|0=
126|JDPButtons110=200
JDPListLayoutGrid1|iconList=83
29=1
28=27
27=true
26=Grid1
22=Center
21=JDPChiselFramePanel
20=Drop here to add this component to the Panel
69|7|19=
69|7|18=
69|7|17=
69|7|16=
69|7|15=
69|7|14=
69|7|13=
274|n=275
69|7|12=
69|7|11=
69|7|10=
274|i=277
116|11|9=
116|11|8=
217|bi=221
116|11|7=
116|11|6=
274|e=276
116|11|5=
116|4|19=
274|d=279
116|11|4=
116|4|18=
116|11|3=
116|4|17=
116|11|2=Equal to
116|4|16=
116|11|1=Less than
116|4|15=
116|11|0=Greater than
116|4|14=
116|4|13=
116|4|12=
116|4|11=
116|4|10=
19=Components
18=true
17=0
16=16
15=true
14=ChiselPanel1
10=Center
68|0|19=
68|0|18=
68|0|17=
68|0|16=
68|0|15=
68|0|14=
68|0|13=
68|0|12=
68|0|11=
68|0|10=
JDPListLayoutGrid1|columns=76
JDPListLayoutGrid1|columns1=78
116|8|19=
116|8|18=
116|8|17=
37|0|0=JDPHelpDesk
116|8|16=
67|x=17
116|8|15=
116|8|14=
116|8|13=
116|8|12=
116|8|11=
JDPChoiceLayoutGrid1GS1|columnActualList=120
116|8|10=
JDPGridSettingsGrid1|fieldType=107
68|11|9=
68|11|8=
JDPGridSettingsGrid1|fieldSql=96
68|11|7=
68|11|6=
JDPSelectDSNGrid1|jdbcdirect=42
68|11|5=
68|4|19=
68|11|4=
68|4|18=
68|11|3=
68|4|17=
68|11|2=Equal to
68|4|16=
68|11|1=Less than
68|4|15=
68|11|0=Greater than
68|4|14=
68|4|13=
68|4|12=
68|4|11=
68|4|10=
320|x=1
103|x=17
1|bi=5
67|9=Fields entered here
67|8=Fields entered here
67|7=Fields entered here
67|6=Fields entered here
67|5=Fields entered here
67|4=Fields entered here
67|3=Fields entered here
67|2=Fields entered here
67|1=Fields entered here
67|0=Fields entered here
197=Center
196=JDPGridLayout
JDPListLayoutGrid1|mainIcon=82
195=Components
194=true
193=8
192=27
191=false
190=Grid1GL1
96|16=FINLSOLUTN
96|15=ENTRYDATE
96|14=STATUS
96|13=ASSIGNEDTO
96|12=WORKLOG
12|0|9=FColor:
96|11=CALLID
12|0|8=Size:
96|10=PROBDETAIL
12|0|7=Style:
103|9=White
12|0|6=Font:
103|8=White
12|0|5=Back to:
103|7=White
12|0|4=Tab to:
103|6=White
12|0|3=Status:
103|5=White
12|0|2=Popup:
103|4=White
320|0=Grid11
12|0|1=Layout:
103|3=White
12|0|0=Pos:
103|2=White
103|1=White
103|0=White
68|8|19=
68|8|18=
68|8|17=
183=false
68|8|16=
63|16=FINLSOLUTN
182=0
68|8|15=
63|15=ENTRYDATE
181=4
68|8|14=
63|14=STATUS
180=true
68|8|13=
63|13=ASSIGNEDTO
68|8|12=
63|12=WORKLOG
68|8|11=
63|11=CALLID
68|8|10=
63|10=PROBDETAIL
117|14|9=
117|14|8=
117|14|7=
117|14|6=
117|14|5=
117|14|4=Pending
117|14|3=Closed
117|14|2=Reassign
117|14|1=Assigned
117|14|0=Progress
179=Method Parameters
176=LoadGridFromWhereClause(String)
175=false
174=1
173=1
172=false
171=LoadGridFromWhereClause(String)
68|13|19=
68|13|18=
68|13|17=
68|13|16=
68|13|15=
68|13|14=
68|13|13=
68|13|12=
68|13|11=
68|13|10=
169=LoadGridFromWhereClause(String)
168=false
167=1
166=27
165=true
164=Grid1GL1
162=ACTION_EVENT
161=Drop here to attach this component/method to this Event
160=Methods
68|9|9=
68|9|8=
68|9|7=
68|9|6=
68|9|5=
68|9|4=
68|9|3=
68|9|2=
68|9|1=Contains
68|9|0=Begins with
159=false
158=0
157=1
67|16=Fields entered here
98|x=17
156=true
67|15=Fields entered here
155=ACTION_EVENT
67|14=Fields entered here
67|13=Fields entered here
153=false
67|12=Fields entered here
152=0
67|11=Fields entered here
151=4
67|10=Fields entered here
150=true
JDPListLayoutGrid1|useTree=77
68|0|9=
68|0|8=
68|0|7=
68|0|6=
68|0|5=
68|0|4=
68|0|3=
68|0|2=
68|0|1=Contains
68|0|0=Begins with
149=Component Events
116|9|9=
116|9|8=
116|9|7=
145=North
116|9|6=
144=JDPWhereClause
116|9|5=
143=false
116|9|4=
142=7
116|9|3=
69|14|9=
247|x=1
141=7
116|9|2=High
69|14|8=
140=false
116|9|1=Medium
69|14|7=
116|9|0=Low
69|14|6=
111|16=N
69|14|5=
111|15=N
69|14|4=='support4'
111|14=N
69|14|3=='support3'
111|13=N
69|14|2=='support2'
JDPSelectDSNGrid1|maxRows=48
111|12=N
69|14|1=='support1'
111|11=N
69|14|0=='supportadmin'
111|10=N
98|9=false
98|8=true
98|7=true
98|6=true
98|5=true
98|4=true
98|3=true
98|2=true
116|0|9=
98|1=true
139=Grid1SP1
116|0|8=
98|0=true
116|0|7=
116|0|6=
116|0|5=
135=Center
116|0|4=
134=Panel
116|0|3=
133=Drop here to add this component to the Panel
116|0|2=
132=Components
116|0|1=Contains
131=true
116|0|0=Begins with
130=6
55|1|16=FINLSOLUTN
55|1|15=ENTRYDATE
55|1|14=STATUS
55|1|13=ASSIGNEDTO
55|1|12=WORKLOG
55|1|11=CALLID
55|1|10=PROBDETAIL
129=24
128=true
127=Panel1
247|0=Method Parameters
JDPSelectDSNGrid1|jdbcdriver=39
JDPGridSettingsGrid1|lockingColumn=114
89|x=17
69|4|9=
69|4|8=
69|4|7=
69|4|6=
69|4|5=
69|4|4=
69|4|3=
69|4|2=
69|4|1=like
69|4|0=like
114=
113=1000
115|16=Fields entered here
112=status <> 'Closed' AND (assignedto = '" + user.cust.username + "' OR '" + user.cust.username + "' = 'supportadmin')
115|15=Fields entered here
115|14=Fields entered here
115|13=Database table/columns
115|12=Fields entered here
115|11=Fields entered here
115|10=Fields entered here
117|4|9=
117|4|8=
117|4|7=
117|4|6=
117|4|5=
117|4|4=
117|4|3=
117|4|2=
117|4|1=like
117|4|0=like
125|x=7
69|11|19=
69|11|18=
89|9=Impact
69|11|17=
89|8=Probsumm
69|11|16=
89|7=Possolutn
69|11|15=
89|6=Itemaffect
69|11|14=
89|5=Probtype
69|11|13=
89|4=Email
69|11|12=
89|3=Phone
69|11|11=
89|2=Empid
69|11|10=
89|1=First Name
89|0=Last Name
147|2|10=boolean
JDPSelectDSNGrid1|jdbcsuffix=41
119|16=
119|15=
119|13=username
119|12=
119|11=
119|10=
125|6=6
125|5=5
125|4=4
125|3=3
125|2=2
125|1=1
125|0=0
JDPSelectDSNGrid1|jdbcprefix=40
36|0|9=FColor:
36|0|8=Size:
36|0|7=Style:
36|0|6=Font:
36|0|5=Back to:
36|0|4=Tab to:
36|0|3=Status:
36|0|2=Popup:
36|0|1=Layout:
36|0|0=Pos:
116|15|9=
116|15|8=
116|15|7=
116|15|6=
69|15|19=
116|15|5=
69|15|18=
116|15|4=
69|15|17=
116|15|3=
69|15|16=
116|15|2=
69|15|15=
116|15|1=Contains
69|15|14=
116|15|0=Begins with
69|15|13=
71|x=17
69|15|12=
69|15|11=
69|15|10=
116|y=20
116|x=17
JDPSelectDSNGrid1|password=45
147|0|9=BColor:
147|0|8=FColor:
147|0|7=Size:
147|0|6=Style:
147|0|5=Font:
147|0|4=Back to:
147|0|3=Tab to:
147|0|2=Status:
147|0|1=Popup:
147|0|0=Pos:
126|Grid1GL18=189
71|9=
71|8=
71|7=
71|6=
71|5=
71|4=
71|3=
71|2=
71|1=
71|0=
JDPChoiceLayoutGrid1SL1|textChoiceSql=74
JDPChoiceLayoutGrid1SL1|textChoiceValue=68
68|15|9=
68|15|8=
68|15|7=
68|15|6=
68|15|5=
68|15|4=
68|15|3=
68|15|2=
68|15|1=Contains
62|x=17
68|15|0=Begins with
25|Panel16=126
107|x=17
13|x=23
13|v=1
13|t=21
13|r=24
13|p=22
13|n=14
13|m=20
211|v=3
13|k=19
13|i=16
13|e=15
211|n=212
13|d=18
13|a=320
211|i=214
211|e=213
211|d=216
JDPChoiceLayoutGrid1SL1|columnActualList=72
62|9=Impact
JDPChoiceLayoutGrid1GS1|actualChoiceValue=117
62|8=Probsumm
62|7=Possolutn
211|a=316
62|6=Itemaffect
62|5=Probtype
62|4=Email
62|3=Phone
62|2=Employee ID
62|1=First Name
62|0=Last Name
259|Grid1LoadGrid4=266
107|9=JDPChoice
107|8=TextField
107|7=TextField
107|6=TextField
107|5=TextField
107|4=TextField
107|3=TextField
107|2=TextField
107|1=TextField
107|0=TextField
116|11|19=
116|11|18=
116|11|17=
259|bi=263
116|11|16=
116|11|15=
116|11|14=
116|11|13=
116|11|12=
116|11|11=
116|11|10=
147|y=11
147|x=3
101|16=Black
101|15=Black
101|14=Black
101|13=Black
101|12=Black
101|11=Black
101|10=Black
210|0|9=Icon#2:
210|0|8=Btn#2:
210|0|7=Icon#1:
210|0|6=Btn#1:
210|0|5=Icon#0:
226|bi=230
210|0|4=Btn#0:
210|0|3=# Btns:
233|MethodParameters=241
210|0|2=Align:
210|0|1=Labels:
210|0|0=Pos:
315|x=1
116|15|19=
116|15|18=
116|15|17=
116|15|16=
68|4|9=
116|15|15=
68|4|8=
116|15|14=
68|4|7=
315|0=Grid15
116|15|13=
68|4|6=
116|15|12=
68|4|5=
116|15|11=
68|4|4=
116|15|10=
68|4|3=
68|4|2=
187|x=1
68|4|1=Contains
68|4|0=Begins with
105|16=false
105|15=false
105|14=false
JDPChoiceLayoutGrid1GS1|tableList=118
105|13=false
105|12=false
105|11=true
105|10=false
189|bi=193
138|x=146
138|w=1
138|t=144
138|r=147
138|p=145
116|4|9=
138|n=139
116|4|8=
116|4|7=
116|4|6=
116|4|5=
116|4|4=
138|i=141
116|4|3=
116|4|2=
116|4|1=Contains
116|4|0=Begins with
138|e=140
138|d=143
138|b=188
137|1|9=Black
137|1|8=11
137|1|7=Plain
137|1|6=Helvetica
137|1|5=
137|1|4=
306|x=1
137|1|3=
13|bi=17
137|1|2=
137|1|1=BorderLayout
137|1|0=Center
187|0=ACTION_EVENT0
109|16=
109|15=
109|14=
109|13=
109|12=
69|8|9=
109|11=
69|8|8=
109|10=
69|8|7=
69|8|6=
69|8|5=
69|8|4=
69|8|3=
69|8|2=
69|8|1=like
69|8|0=like
306|0=Grid1DeleteRowsFromWhereClause(Grid1SP1.getFromWhereClause());
217|Grid13=226
178|n=179
178|i=181
282|x=1
178|e=180
178|d=183
72|16=
72|15=
72|14=
117|8|9=
117|8|8=
72|12=
117|8|7=
72|11=
117|8|6=
72|10=
117|8|5=
117|8|4=
117|8|3=
117|8|2=
117|8|1=like
117|8|0=like
35|x=16
233|x=240
233|w=1
117|2|19=
117|2|18=
233|t=239
117|2|17=
117|2|16=
274|bi=278
117|2|15=
117|2|14=
117|2|13=
117|2|12=
233|n=234
117|2|11=
117|2|10=
233|i=236
233|e=235
120|x=17
233|d=238
233|b=247
241|bi=245
282|0=Grid14
292|Grid1DeleteRows5=299
JDPListLayoutGrid1|pfromwhereclause=93
35|9=Grid1DeleteRowsMain|L|\t//\r\n\t//  Check each row that has changed and issue an update to the database\r\n\t//\r\n\tvoid Grid1DeleteRowsMain(String[] keys, String whereClause) {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\r\n\t\tint deletedCount = 0;\r\n\t\tint cCount = 1;\r\n\t\tint iCount = 1;\r\n\t\t\r\n\t\tfor (int ix=0; ix<tableContents.rowChanged.length; ix++) {\r\n\t\t\tif (tableContents.rowSelected[ix]) {\r\n\t\t\t\tdeletedCount++;\r\n\t\t\t} \r\n\t\t}\r\n\t\tfor (int ix=0; ix<tableContents.rowChanged.length; ix++) {\r\n\t\t\tif (tableContents.rowSelected[ix]) {\r\n\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message9",iCount++,deletedCount), 0);\r\n\t\t\t\tGrid1SaveData(ix,"D");\r\n\t\t\t}\r\n\t\t}\r\n\t\tif (deletedCount > 0) {\r\n\t\t\tGrid1LoadGridMain(keys, whereClause);\r\n\t\t}\r\n\t}\r\n\r\n\n
35|8=Grid1DeleteRows|L|\t//\r\n\t//  Check each row that has changed and issue an update to the database\r\n\t//\r\n\tpublic void Grid1DeleteRows(String[] keys) {\r\n\r\n\t\tGrid1DeleteRowsMain(keys, null);\r\n\t}\r\n\r\n\n
35|7=Grid1DeleteRowsFromWhereClause|L|\t//\r\n\t//  Delete any of the selected rows\r\n\t//\r\n\tpublic void Grid1DeleteRowsFromWhereClause(String whereClause) {\r\n\r\n\tint fPos = whereClause.indexOf("WHERE ");\r\n\t\twhereClause = " AND" + whereClause.substring(fPos+5);\r\n\t\tString[] keys = new String[0];\r\n\r\n\t\tGrid1DeleteRowsMain(keys, whereClause);\r\n\t}\r\n\r\n\n
35|6=Grid1UpdateRowsMain|L|\t//\r\n\t//  Check each row that has changed and issue an update to the database\r\n\t//\r\n\tvoid Grid1UpdateRowsMain(String[] keys, String whereClause) {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\r\n\t\tint changedCount = 0;\r\n\t\tint insertedCount = 0;\r\n\t\tint cCount = 1;\r\n\t\tint iCount = 1;\r\n\t\tboolean reload = false;\r\n\t\t\r\n\t\tfor (int ix=0; ix<tableContents.rowChanged.length; ix++) {\r\n\t\t\tif (tableContents.rowChanged[ix]) {\r\n\t\t\t\tif (ix >= tableContents.totalDataRows) {\r\n\t\t\t\t\tinsertedCount++;\r\n\t\t\t\t} else {\r\n\t\t\t\t\tchangedCount++;\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n\t\tfor (int ix=0; ix<tableContents.rowChanged.length; ix++) {\r\n\t\t\tif (tableContents.rowChanged[ix]) {\r\n\t\t\t\tif (ix >= tableContents.totalDataRows) {\r\n\t\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message7",iCount++,insertedCount), 0);\r\n\t\t\t\t\tGrid1SaveData(ix,"I");\r\n\t\t\t\t} else {\r\n\t\t\t\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message8",cCount++,changedCount), 0);\r\n\t\t\t\t\tif (Grid1SaveData(ix,"U")) {\r\n\t\t\t\t\t\treload = true;\r\n\t\t\t\t\t}\r\n\t\t\t\t}\r\n\t\t\t\ttableContents.rowChanged[ix] = false;\r\n\t\t\t}\r\n\t\t}\r\n\t\tif (insertedCount > 0 || reload) {\r\n\t\t\tGrid1LoadGridMain(keys, whereClause);\r\n\t\t}\r\n\t}\r\n\r\n\n
35|5=Grid1UpdateRows|L|\t//\r\n\t//  Check each row that has changed and issue an update to the database\r\n\t//\r\n\tpublic void Grid1UpdateRows(String[] keys) {\r\n\r\n\t\tGrid1UpdateRowsMain(keys, null);\r\n\t}\r\n\r\n\n
35|4=Grid1UpdateRowsFromWhereClause|L|\t//\r\n\t//  Check each row that has changed and issue an update to the database\r\n\t//\r\n\tpublic void Grid1UpdateRowsFromWhereClause(String whereClause) {\r\n\r\n\t\tint fPos = whereClause.indexOf("WHERE ");\r\n\t\twhereClause = " AND" + whereClause.substring(fPos+5);\r\n\t\tString[] keys = new String[0];\r\n\r\n\t\tGrid1UpdateRowsMain(keys, whereClause);\r\n\t}\r\n\r\n\n
35|3=Grid1LoadGridMain|R|\t//\r\n\t//  Load the grid with the specified parameters and selected data\r\n\t//\r\n\tvoid Grid1LoadGridMain(String[] keys, String whereClause) {\r\n\r\n\t\tJDPTextGrid tableContents = Grid1GL1;\r\n\r\n\t\tStringTokenizer stok;\r\n\t\tint recCount = 0;\r\n\t\tVector results = new Vector();\r\n\t\tString sep = jaggSQL.getSEP();\r\n\t\tint actualRows = 0;\r\n\t\tString row;\r\n\t\tint columnCount = 7;\r\n\r\n\t\tVector columns = new Vector();\r\n\t\tVector indexes = new Vector();\r\n\r\n\t\tString SQL = "SELECT CALLID, " +\r\n\t\t\t\t\t"LASTNAME, " +\r\n\t\t\t\t\t"PROBSUMM, " +\r\n\t\t\t\t\t"IMPACT, " +\r\n\t\t\t\t\t"CALLID, " +\r\n\t\t\t\t\t"ASSIGNEDTO, " +\r\n\t\t\t\t\t"STATUS, " +\r\n\t\t\t\t\t"ENTRYDATE FROM JDPHelpDesk WHERE status <> 'Closed' AND (assignedto = '" + user.cust.username + "' OR '" + user.cust.username + "' = 'supportadmin')  ";\r\n\t\tif (keys.length > 0 && keys[0] != null) SQL += " AND CALLID=" + keys[0]+ "" ;\r\n\t\tif (whereClause != null) {\r\n\t\t\tSQL += whereClause;\r\n\t\t}\r\n\r\n\t\tuser.mainmsg.setStatusMsg(JDPLang.get("Message0"), 0);\r\n\r\n\t\tjaggSQL.loadJdbcSettings("JDPHelpDesk");\r\n\t\tjaggSQL.setUID("");\r\n\t\tjaggSQL.setPWD("");\r\n\t\tjaggSQL.setMRW("1000");\r\n\t\tjaggSQL.setTOUT("60");\r\n\r\n\t\trecCount = jaggSQL.execSQL(SQL, results);\r\n\r\n\t\tif(recCount == -1) {\r\n\t\t\tuser.u.setSqlMessage(jaggSQL,SQL);\r\n\t\t\treturn;\r\n\t\t}\r\n\r\n\t\t//\r\n\t\t//  Initialise result arrays\r\n\t\t//\r\n\t\ttableContents.totalDataRows = jaggSQL.getRowCount();\r\n\t\tactualRows = jaggSQL.getRowCount()+20;\r\n\t\ttableContents.currentText = new String[columnCount][actualRows];\r\n\r\n\t\ttableContents.cellChanged = null;\r\n\t\ttableContents.rowChanged = null;\r\n\t\ttableContents.columnSelected = null;\r\n\t\tint keyCount = 1;\r\n\t\ttableContents.rowKey = new String[actualRows][keyCount];\r\n\t\ttableContents.recordLockValue = new String[actualRows];\r\n\t\t\r\n\t\t//\r\n\t\t//  Load key array and grid array\r\n\t\t//\r\n\t\tString tempText;\r\n\t\tfor (int ix=0; ix<actualRows-20; ix++) {\r\n\t\t\trow = (String)results.elementAt(ix);\r\n\t\t\tif ((row != null) && (row.trim().compareTo("") != 0)) {\r\n\t\t\t\tstok = new StringTokenizer(row,sep);\r\n\t\t\t\tfor (int iy=0; iy<keyCount; iy++) {\r\n\t\t\t\t\ttableContents.rowKey[ix][iy] = stok.nextToken().trim();\r\n\t\t\t\t}\r\n\t\t\t\tfor (int iy=0; iy<columnCount; iy++) {\r\n\t\t\t\t\ttempText = stok.nextToken().trim();\r\n\t\t\t\t\ttableContents.currentText[iy][ix] = tempText;\r\n\t\t\t\t\tif ((iy == 2) && (tableContents.pullDownValue[2][0].indexOf(tempText) >= 0)) tableContents.currentText[iy][ix] = tableContents.pullDownList[2][0].getItem(tableContents.pullDownValue[2][0].indexOf(tempText));\r\n\t\t\t\t\tif ((iy == 4) && (tableContents.pullDownValue[4][0].indexOf(tempText) >= 0)) tableContents.currentText[iy][ix] = tableContents.pullDownList[4][0].getItem(tableContents.pullDownValue[4][0].indexOf(tempText));\r\n\t\t\t\t\tif ((iy == 5) && (tableContents.pullDownValue[5][0].indexOf(tempText) >= 0)) tableContents.currentText[iy][ix] = tableContents.pullDownList[5][0].getItem(tableContents.pullDownValue[5][0].indexOf(tempText));\r\n\t\t\t\t\tif (iy == 6) tableContents.currentText[iy][ix] = JDPDate.format(Long.valueOf(tempText).longValue());\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n\t\tfor (int ix=actualRows-20; ix<actualRows; ix++) {\r\n\t\t\tfor (int iy=0; iy<keys.length; iy++) {\r\n\t\t\t\ttableContents.rowKey[ix][iy] = keys[iy];\r\n\t\t\t}\r\n\t\t}\r\n\r\n\t\ttableContents.newTable();\r\n\r\n\t\t//\r\n\t\t//  Clear status message\r\n\t\t//\r\n\t\tuser.mainmsg.clearStatusMsg();\r\n\t}\r\n\r\n
35|2=Grid1LoadGrid|L|\t//\r\n\t//  Load the grid with the specified parameters and selected data\r\n\t//\r\n\tpublic void Grid1LoadGrid(String[] keys) {\r\n\r\n\t\tGrid1LoadGridMain(keys, null);\r\n\t}\r\n\r\n\n
35|1=Grid1LoadGridFromWhereClause|L|\t//\r\n\t//  Load the grid with the specified parameters and selected data\r\n\t//\r\n\tpublic void Grid1LoadGridFromWhereClause(String whereClause) {\r\n\r\n\t\tint fPos = whereClause.indexOf("WHERE ");\r\n\t\twhereClause = " AND" + whereClause.substring(fPos+5);\r\n\t\tString[] keys = new String[0];\r\n\r\n\t\tGrid1LoadGridMain(keys, whereClause);\r\n\t}\r\n\r\n\n
JDPSelectDSNGrid1|timeOut=49
35|0=Grid1Main|L|\t//\r\n\t//  Main initialization method\r\n\t//\r\n\tpublic void Grid1Main() {\r\n\r\n\t\tGrid1SetGridSettings();\r\n\t\tGrid1WhereClauseMain();\r\n\t\tGrid1SearchResultsMain();\r\n\t\tGrid1LoadGrid(new String[0]);\r\n\t}\r\n\r\n\n\r\n\r\n
117|13|19=
117|13|18=
117|13|17=
117|13|16=
117|13|15=
117|13|14=
117|13|13=
117|13|12=
117|13|11=
117|13|10=
120|8=
120|7=
120|6=
120|5=
57|1|9=IMPACT
120|4=
57|1|8=PROBSUMM
120|3=
57|1|7=POSSOLUTN
120|2=
57|1|6=ITEMAFFECT
120|1=
57|1|5=PROBTYPE
120|0=
57|1|4=EMAIL
57|1|3=PHONE
57|1|2=EMPID
57|1|1=FIRSTNAME
57|1|0=LASTNAME
75|x=17
273|x=1
117|6|19=
117|6|18=
117|6|17=
JDPListLayoutGrid1|treeMinWidth=85
117|6|16=
117|6|15=
117|6|14=
117|6|13=
117|6|12=
117|6|11=
117|6|10=
116|10|9=
120|16=
116|10|8=
120|15=
116|10|7=
116|10|6=
120|13=username
116|10|5=
120|12=
116|10|4=
120|11=
116|10|3=
120|10=
116|10|2=
116|10|1=Contains
116|10|0=Begins with
69|2|19=
69|2|18=
69|2|17=
69|2|16=
69|2|15=
69|2|14=
69|2|13=
69|2|12=
69|2|11=
69|2|10=
111|x=17
75|9=(1=1)
75|8=(1=1)
75|7=(1=1)
75|6=(1=1)
75|5=(1=1)
75|4=(1=1)
75|3=(1=1)
75|2=(1=1)
75|1=(1=1)
75|0=(1=1)
JDPGridLayoutGrid1|columnOrder=125
JDPGridLayoutGrid1|columnWidth=124
273|0=Grid1LoadGridFromWhereClause(Grid1SP1.getFromWhereClause());
JDPChoiceLayoutGrid1GS1|tableWhereClause=123
111|9=N
111|8=N
111|7=N
111|6=N
111|5=N
111|4=N
111|3=N
111|2=N
111|1=N
111|0=N
66|x=17
69|6|19=
69|6|18=
69|6|17=
69|6|16=
69|6|15=
69|6|14=
69|6|13=
69|6|12=
69|6|11=
69|6|10=
68|10|9=
68|10|8=
68|10|7=
116|3|19=
68|10|6=
116|3|18=
68|10|5=
116|3|17=
68|10|4=
116|3|16=
68|10|3=
116|3|15=
68|10|2=
116|3|14=
68|10|1=Contains
116|3|13=
68|10|0=Begins with
116|3|12=
116|3|11=
116|3|10=
102|x=17
66|9=true
66|8=true
JDPListLayoutGrid1|pcounttext=87
66|7=true
66|6=true
66|5=true
66|4=true
66|3=true
66|2=true
66|1=true
66|0=true
283|Grid15=292
102|9=Red
102|8=Black
102|7=Black
102|6=Black
102|5=Black
102|4=Black
102|3=Black
102|2=Black
102|1=Black
102|0=Black
59|0|0=CALLID
116|7|19=
116|7|18=
116|7|17=
116|7|16=
116|7|15=
116|7|14=
116|7|13=
116|7|12=
116|7|11=
116|7|10=
117|13|9=
117|13|8=
117|13|7=
117|13|6=
91|16=Ascending
117|13|5=
91|15=Ascending
117|13|4=support4
91|14=Ascending
117|13|3=support3
91|13=Ascending
117|13|2=support2
91|12=Ascending
117|13|1=support1
91|11=Ascending
117|13|0=supportadmin
91|10=Ascending
319|x=1
68|3|19=
68|3|18=
68|3|17=
68|3|16=
68|3|15=
68|3|14=
68|3|13=
68|3|12=
68|3|11=
68|3|10=
199|1|9=LightGray
199|1|8=Black
199|1|7=11
199|1|6=Plain
199|1|5=Helvetica
199|1|4=
199|1|3=
199|1|2=
199|1|1=
199|1|0=Center
200|ComponentEvents=211
68|8|9=
JDPSearchLayoutGrid1|pactualchooseFrom=63
68|8|8=
68|8|7=
319|0=Panel16
68|8|6=
68|8|5=
68|8|4=
68|8|3=
68|8|2=
68|8|1=Contains
68|8|0=Begins with
126|Grid1SP17=138
97|x=17
95|16=Finlsolutn
95|15=Entrydate
95|14=Status
95|13=Assigned To
95|12=Worklog
95|11=Call ID
95|10=Probdetail
68|7|19=
68|7|18=
68|7|17=
68|7|16=
62|16=Finlsolutn
68|7|15=
62|15=Entrydate
68|7|14=
62|14=Status
116|8|9=
68|7|13=
62|13=Assignedto
116|8|8=
68|7|12=
62|12=Worklog
116|8|7=
68|7|11=
62|11=Call ID
116|8|6=
68|7|10=
62|10=Probdetail
116|8|5=
116|8|4=
116|8|3=
69|13|9=
116|8|2=
69|13|8=
116|8|1=Contains
69|13|7=
116|8|0=Begins with
69|13|6=
69|13|5=
69|13|4=support4
69|13|3=support3
69|13|2=support2
69|13|1=support1
69|13|0=supportadmin
JDPSelectColumnsGrid1|keysUpdate=60
97|9=Yes
97|8=Yes
97|7=Yes
97|6=Yes
97|5=Yes
97|4=Yes
97|3=Yes
97|2=Yes
97|1=Yes
97|0=Yes
68|12|19=
68|12|18=
68|12|17=
68|12|16=
68|12|15=
68|12|14=
68|12|13=
68|12|12=
68|12|11=
68|12|10=
JDPChoiceLayoutGrid1SL1|tableList=70
9=Panel
8=Drop here to add this component to the Panel
7=Components
6=false
5=0
4=24
170|MethodParameters=178
3=true
2=Main
99|16=1
99|15=1
99|14=1
99|13=1
99|12=1
99|11=1
99|10=1
JDPChoiceLayoutGrid1GS1|textChoiceSql=122
JDPChoiceLayoutGrid1GS1|textChoiceValue=116
66|16=true
66|15=true
66|14=true
69|3|9=
66|13=true
69|3|8=
66|12=true
69|3|7=
66|11=false
69|3|6=
66|10=true
69|3|5=
69|3|4=
69|3|3=
56|1|9=IMPACT
69|3|2=
56|1|8=PROBSUMM
69|3|1=like
56|1|7=POSSOLUTN
69|3|0=like
56|1|6=ITEMAFFECT
56|1|5=PROBTYPE
56|1|4=EMAIL
56|1|3=PHONE
56|1|2=EMPID