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