Subversion Repositories DevTools

Rev

Rev 62 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
62 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          AdminProjectStates 		 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0
12
%>
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_admin_projects_common.asp"-->
17
<%
18
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<!--#include file="_access_control_admin_pages.asp"-->
22
<%
23
'------------ VARIABLE DEFINITION -------------
24
Dim rsQry
25
Dim i
26
Dim LastRow
27
Dim aStateCollector
28
Dim parAction
29
Dim parState_id
30
'------------ CONSTANTS DECLARATION -----------
31
'------------ VARIABLE INIT -------------------
32
parAction = Request("action")
33
parState_id = Request("state_id")
34
'------------ CONDITIONS ----------------------
35
'----------------------------------------------
36
%>
37
<%
38
'--------------------------------------------------------------------------------------------------------------------------------
39
Sub GetStates ( aStateCollector, nProj_id )
40
	Dim rsQry
41
 
42
	OraDatabase.Parameters.Add "PROJ_ID", nProj_id,	ORAPARM_INPUT, ORATYPE_NUMBER 
43
 
44
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("StateList.sql"), ORADYN_DEFAULT )
45
 
46
	If rsQry.RecordCount > 0 Then
47
		aStateCollector = rsQry.GetRows()
48
	Else
49
		aStateCollector = NULL
50
	End If
51
 
52
	rsQry.Close
53
	Set rsQry = Nothing
54
	OraDatabase.Parameters.Remove "PROJ_ID"
55
End Sub
56
'--------------------------------------------------------------------------------------------------------------------------------
57
Sub RenderStateTypesCombo( nStateType ) 
58
	Dim aStateTypes, LastState, i, Selected
59
 
60
	'--- Get State Types from collector
61
	aStateTypes = oEnumStateTypeNames.Keys
62
 
63
 
64
	Response.write "<select name='state_type_enum' class='form_iname' >"
65
 
66
 
67
	LastState = UBound( aStateTypes )
68
 
69
	For i = 0 To LastState
70
		Selected = ""
71
		If aStateTypes(i) = nStateType Then Selected = "selected"
72
 
73
		Response.write "<option value='"& aStateTypes(i) &"' "& Selected &">"& oEnumStateTypeNames.Item ( aStateTypes(i) )  &"</option>"
74
 
75
	Next
76
 
77
 
78
	Response.write "</select>"
79
 
80
End Sub
81
'--------------------------------------------------------------------------------------------------------------------------------
82
Sub RenderStateSeqCombo( nProj_id, nState_seq ) 
83
	Dim rsQry, Selected
84
 
85
	OraDatabase.Parameters.Add "PROJ_ID", nProj_id,	ORAPARM_INPUT, ORATYPE_NUMBER
86
 
87
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("StateList.sql"), ORADYN_DEFAULT )
88
 
89
 
90
	Response.write "<select name='state_seq' class='form_iname'>"
91
 
92
 
93
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
94
		Selected = ""
95
		If CInt(nState_seq) = CInt(rsQry("state_seq")) Then Selected = "selected"
96
 
97
		Response.write "<option value='"& rsQry("state_seq") &"' "& Selected &">"& rsQry("state_seq") &"</option>"
98
 
99
		rsQry.MoveNext
100
	WEnd
101
 
102
 
103
	Response.write "</select>"
104
 
105
 
106
 
107
	rsQry.Close
108
	Set rsQry = Nothing
109
 
110
	OraDatabase.Parameters.Remove "PROJ_ID"
111
End Sub
112
'--------------------------------------------------------------------------------------------------------------------------------
113
Sub AddState ()
114
	On Error Resume Next
115
 
116
	OraDatabase.Parameters.Add "STATE_NAME", 	  Request("state_name"),	ORAPARM_INPUT, ORATYPE_VARCHAR2
117
	OraDatabase.Parameters.Add "PROJ_ID", 		  Request("proj_id"), 		ORAPARM_INPUT, ORATYPE_NUMBER 
118
	OraDatabase.Parameters.Add "STATE_TYPE_ENUM", Request("state_type_enum"), 	ORAPARM_INPUT, ORATYPE_NUMBER 
119
 
120
 
121
	objEH.TryORA ( OraSession )
122
 
123
	OraDatabase.ExecuteSQL _
124
	"BEGIN   pk_State.Add_State ( :STATE_NAME, :STATE_TYPE_ENUM, :PROJ_ID );   END;"
125
 
126
	objEH.CatchORA ( OraSession )
127
 
128
 
129
	OraDatabase.Parameters.Remove "STATE_NAME"
130
	OraDatabase.Parameters.Remove "PROJ_ID"
131
	OraDatabase.Parameters.Remove "STATE_TYPE_ENUM"
132
 
133
End Sub
134
'--------------------------------------------------------------------------------------------------------------------------------
135
Sub EditState ()
136
	On Error Resume Next
137
 
138
	OraDatabase.Parameters.Add "STATE_ID", 			Request("state_id"), 		ORAPARM_INPUT, ORATYPE_NUMBER 
139
	OraDatabase.Parameters.Add "STATE_NAME", 		Request("state_name"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
140
	OraDatabase.Parameters.Add "STATE_SEQ", 		Request("state_seq"), 		ORAPARM_INPUT, ORATYPE_NUMBER 
141
	OraDatabase.Parameters.Add "STATE_TYPE_ENUM", 	Request("state_type_enum"), 		ORAPARM_INPUT, ORATYPE_NUMBER 
142
 
143
 
144
 
145
	objEH.TryORA ( OraSession )
146
 
147
	OraDatabase.ExecuteSQL _
148
	"BEGIN   pk_State.Update_State ( :STATE_ID, :STATE_NAME, :STATE_SEQ, :STATE_TYPE_ENUM );   END;"
149
 
150
	objEH.CatchORA ( OraSession )
151
 
152
 
153
	OraDatabase.Parameters.Remove "STATE_ID"
154
	OraDatabase.Parameters.Remove "STATE_NAME"
155
	OraDatabase.Parameters.Remove "STATE_SEQ"
156
	OraDatabase.Parameters.Remove "STATE_TYPE_ENUM"
157
 
158
End Sub
159
'--------------------------------------------------------------------------------------------------------------------------------
160
%>
161
<%
162
'------------ RUN BEFORE PAGE RENDER ----------
163
' --- Get Form details from DB ---
164
 
165
' --- Load Validation Rules ---
166
Call objForm.LoadValidationRules ( Array("state_name"), OraDatabase )		' Load Validation Rules
167
 
168
' --- Enter Form Validation Rule Changes here... ----
169
'----------------------------------------------------
170
 
171
' --- RUN onPostBack ---
172
If Request("doit") <> "" Then
173
	If objForm.IsValidOnPostBack Then
174
		' --- Form is Valid ---
175
 
176
		Select Case Request("action")
177
			Case "new"
178
				Call AddState()
179
			Case "edit"
180
				Call EditState()
181
 
182
		End Select
183
 
184
 
185
		If objEH.Finally Then
186
			Call OpenInWindow ( SCRIPT_NAME &"?"& objPMod.ComposeURL() )
187
		End If
188
 
189
	End If
190
 
191
 
192
 
193
End If
194
 
195
'----------------------------------------------
196
%>
197
<html>
198
<head>
199
<title>Deployment Manager</title>
200
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
201
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
202
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
203
<script language="JavaScript" src="scripts/common.js"></script>
204
</head>
205
 
206
<body leftmargin="0" topmargin="0" <%If parAction <> "" Then%>onLoad="FormName.state_name.focus();"<%End If%>>
207
<!-- HEADER ++++++++++++++++ -->
208
<!--#include file="_header.asp"-->
209
<!-- +++++++++++++++++++++++ -->
210
<!-- MAIN MENU  ++++++++++++++++++++++++++ -->
211
<!--#include file="_main_menu_admin.asp"-->
212
<!-- +++++++++++++++++++++++++++++++++++++ -->
213
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
214
  <tr>
215
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
216
	<!-- ADMIN BROWSER ++++++++++++++++++++++ -->
217
	<!--#include file="_admin_project_browser.asp"-->
218
    <!-- END OF ADMIN BROWSER +++++++++++++++ -->
219
	</td>
220
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
221
    <td width="100%" valign="top" bgcolor="#FFFFFF">
222
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
223
      <tr>
224
        <td width="1%" valign="top" background="images/bg_darkbage.gif"></td>
225
        <td width="100%" valign="bottom" background="images/bg_darkbage.gif">
226
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
227
		<!--#include file="_tabs_definition.asp"-->
228
		<%
229
		Set objTabControl = New TabControl
230
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
231
		objTabControl.TabStyle = "StyleWinXP"
232
		objTabControl.AddTabDefnition ( arrAdminProjectsTabDef )
233
		objTabControl.SelectByName ("States")
234
		objTabControl.Render ()
235
		%>
236
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
237
		</td>
238
        <td width="1%" background="images/bg_darkbage.gif"><img src="images/img_spanner.gif" width="190" height="55"></td>
239
        </tr>
240
      <tr>
241
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
242
        <td background="images/bg_bage_0.gif">
243
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
244
		<%
245
		'-- Define Action buttons on this tab
246
		'aTabBtnsDef = Array("abtnAddBranch")
247
 
248
		'Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
249
 
250
		'objBtnControl.Render( aTabBtnsDef )
251
		%>
252
		<!-- +++++++++++++++++++++++++++++++++++ -->
253
		</td>
254
        <td background="images/bg_darkbage.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
255
          <tr>
256
            <td width="100%" background="images/bg_bage_0.gif">&nbsp;</td>
257
            <td width="1"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
258
          </tr>
259
        </table></td>
260
        </tr>
261
      <tr>
262
        <td>&nbsp;</td>
263
        <td><br><br>
264
		  <!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
265
          <table width="100%"  border="0" cellspacing="0" cellpadding="0">
266
		  <form name="FormName" method="post" action="<%=SCRIPT_NAME%>" onSubmit="ShowProgress();">
267
		  <%
268
		  Call GetStates ( aStateCollector, parProj_id )
269
 
270
 
271
		  %>
272
            <tr>
273
              <td background="images/bg_bage_0a.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
274
                <tr>
275
                  <td width="1" background="images/bg_bage_0.gif"></td>
276
                  <td width="1%" background="images/bg_bage_0.gif" class="body_col" nowrap>Release Sequence</td>
277
                  <td width="20%" background="images/bg_bage_0.gif" class="body_col" nowrap>State Name</td>
278
				  <td width="80%" background="images/bg_bage_0.gif" class="body_col" nowrap>State Type</td>
279
                  <td background="images/bg_bage_0.gif">&nbsp;</td>
280
                </tr>
281
				<%
282
				If NOT IsNull(aStateCollector) Then
283
					LastRow = Ubound( aStateCollector, 2 )
284
					For i = 0 To LastRow
285
					%>
286
					<%If parAction = "" Then%>
287
					<!-- NORMAL ROW +++++++++++++++++++ -->
288
	                <tr>
289
	                  <td background="images/bg_bage_0.gif" align="center"></td>
290
	                  <td bgcolor="#FFFFFF" class="body_row" nowrap><%=aStateCollector(2, i)%></td>
291
	                  <td bgcolor="#FFFFFF" class="body_row" nowrap><%=aStateCollector(1, i)%></td>
292
					  <td bgcolor="#FFFFFF" class="body_row"><%=oEnumStateTypeNames.Item( aStateCollector(3, i) )%></td>
293
	                  <td align="center" nowrap background="images/bg_bage_0.gif"><a href="<%=SCRIPT_NAME%>?action=edit&state_id=<%=aStateCollector(0, i)%>&<%=objPMod.ComposeURL()%>"><%=LIMG_EDIT%></a><a href="_RemoveState.asp?rfile=<%=SCRIPT_NAME%>&state_id=<%=aStateCollector(0, i)%>&<%=objPMod.ComposeURL()%>" onClick="return confirmAction('Remove \'<%=aStateCollector(1, i)%>\' from this list?');"><%=LIMG_REMOVE%></a></td>
294
	                </tr>
295
					<!-- +++++++++++++++++++++++++++++++++ -->
296
 
297
					<%Else%>
298
 
299
						<%If CStr(aStateCollector(0, i)) <> parState_id Then%>
300
						<!-- JUST DATA ROW +++++++++++++++++++ -->
301
						<tr>
302
		                  <td background="images/bg_bage_0.gif" align="center"></td>
303
		                  <td bgcolor="#FFFFFF" class="body_row" nowrap><%=aStateCollector(2, i)%></td>
304
		                  <td bgcolor="#FFFFFF" class="body_row" nowrap><%=aStateCollector(1, i)%></td>
305
						  <td bgcolor="#FFFFFF" class="body_row" nowrap><%=oEnumStateTypeNames.Item( aStateCollector(3, i) )%></td>
306
		                  <td align="center" nowrap background="images/bg_bage_0.gif">&nbsp;</td>
307
		                </tr>
308
						<!-- +++++++++++++++++++++++++++++++++ -->
309
						<%Else%>
310
						<!-- EDIT ROW ++++++++++++++++++++++++ -->
311
						<input type="hidden" name="action" value="edit">
312
						<tr>
313
		                  <td background="images/bg_bage_0.gif" align="center" valign="top"><%=LIMG_POINTER%></td>
314
						  <td background="images/bg_note.gif" class="body_row" valign="top"><%Call RenderStateSeqCombo( parProj_id, aStateCollector(2, i) ) %></td>
315
		                  <td background="images/bg_note.gif" class="body_row" valign="top">
316
						  <input type="text" name="state_name" class='form_iname' value="<%=objForm.GetValue( "state_name", aStateCollector(1, i) )%>">
317
						  <%=objForm.Validate ("state_name")%>
318
						  </td>
319
		                  <td background="images/bg_note.gif" class="body_row" valign="top"><%Call RenderStateTypesCombo( aStateCollector(3, i) )%></td>
320
		                  <td background="images/bg_note.gif" align="center" valign="top" nowrap><%=LIMG_ROW_SUBMIT%><a href="<%=SCRIPT_NAME%>?<%=objPMod.ComposeURL()%>" ><%=LIMG_ROW_CANCEL%></a></td>
321
		                </tr>
322
						<!-- +++++++++++++++++++++++++++++++++ -->
323
						<%End If%>
324
					<%End If%>
325
 
326
 
327
				<%
328
					Next
329
 
330
				End If
331
				%>
332
 
333
 
334
				<!-- NEW ENTRY ROW FORM ++++++++++++++ -->
335
				<%If parAction = "new" Then%>
336
 
337
				<input type="hidden" name="action" value="new">
338
				<tr>
339
                  <td background="images/bg_bage_0.gif" align="center" valign="top"><%=LIMG_POINTER%></td>
340
				  <td background="images/bg_note.gif" class="body_row" valign="top"></td>
341
                  <td background="images/bg_note.gif" class="body_row" valign="top">
342
				  <input type="text" name="state_name" class='form_iname' value="<%=Request("state_name")%>">
343
				  <%=objForm.Validate ("state_name")%>
344
				  </td>
345
                  <td background="images/bg_note.gif" class="body_row" valign="top"><%Call RenderStateTypesCombo( NULL )%></td>
346
                  <td background="images/bg_note.gif" align="center" nowrap valign="top"><%=LIMG_ROW_SUBMIT%><a href="<%=SCRIPT_NAME%>?<%=objPMod.ComposeURL()%>" ><%=LIMG_ROW_CANCEL%></a></td>
347
                </tr>
348
				<%End If%>
349
				<!-- +++++++++++++++++++++++++++++++++ -->
350
 
351
 
352
				<!-- NEW ENTRY BUTTON ++++++++++++++++ -->
353
				<%If parAction = "" Then%>
354
				<tr>
355
                  <td background="images/bg_bage_0.gif" align="center"><a href="<%=SCRIPT_NAME%>?action=new&<%=objPMod.ComposeURL()%>"><%=LIMG_NEW_ENTRY%></a></td>
356
                  <td bgcolor="#FFFFFF" class="body_row">&nbsp;</td>
357
                  <td bgcolor="#FFFFFF" class="body_row">&nbsp;</td>
358
				  <td bgcolor="#FFFFFF" class="body_row">&nbsp;</td>
359
                  <td bgcolor="#FFFFFF">&nbsp;</td>
360
                </tr>
361
				<%End If%>
362
				<!-- +++++++++++++++++++++++++++++++++ -->
363
 
364
              </table></td>
365
            </tr>
366
		  <%=objPMod.ComposeHiddenTags()%>
367
		  <input type="hidden" name="state_id" value="<%=parState_id%>">
368
		  <input type="hidden" name="doit" value="true">
369
		  </form>
370
          </table>
371
          </td>
372
        <td valign="top"></td>
373
        </tr>
374
    </table>
375
	<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
376
	</td>
377
  </tr>
378
  <tr>
379
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="200" height="15"></td>
380
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
381
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
382
  </tr>
383
  <tr>
384
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
385
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
386
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
387
  </tr>
388
</table>
389
<!-- FOOTER ++++++++++++++++ -->
390
<!--#include file="_footer.asp"-->
391
<!-- +++++++++++++++++++++++ -->
392
</body>
393
</html>
394
<%
395
'------------ RUN AFTER PAGE RENDER -----------
396
Set objPMod = Nothing
397
Set objTabControl = Nothing
398
'----------------------------------------------
399
%><!--#include file="common/globals_destructor.asp"-->