Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|				    	Edit Project View Details    |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
' Good idea to set when using redirect
12
Response.Expires = 0	' always load the page, dont store
13
%>
14
<!--#include file="common/conf.asp"-->
15
<!--#include file="common/globals.asp"-->
16
<!--#include file="common/formating.asp"-->
17
<!--#include file="common/qstr.asp"-->
18
<!--#include file="common/common_subs.asp"-->
19
<!--#include file="common/_form_window_common.asp"-->
20
<%
21
' Set rfile parameter. This is a return page after Login
22
Call objPMod.StoreParameter ( "rfile", "rtree.asp" )
23
objPMod.PersistInQryString("proj_id")
24
'------------ ACCESS CONTROL ------------------
25
%>
26
<!--#include file="_access_control_login.asp"-->
27
<!--#include file="_access_control_general.asp"-->
28
<!--#include file="_access_control_project.asp"-->
29
<%
30
'------------ Variable Definition -------------
31
Dim objSortHelper
32
Dim rsQry
33
Dim parProjId
34
Dim parSourceRtagId
35
'------------ Constants Declaration -----------
36
'------------ Variable Init -------------------
37
parProjId = Request("proj_id")
38
objPMod.PersistInQryString("proj_id")
39
'----------------------------------------------
40
%>
41
<%
42
'--------------------------------------------------------------------------------------------------------------------------
43
Sub GetFormDetails ( parProjId, ByRef outobjDetails )
44
	Dim rsQry, query
45
 
46
 
47
	OraDatabase.Parameters.Add "PROJ_ID", 	parProjId,		ORAPARM_INPUT, ORATYPE_NUMBER 
48
 
49
	query = _
50
	" SELECT prj.* "&_
51
	"  FROM PROJECTS prj"&_
52
	" WHERE prj.PROJ_ID = :PROJ_ID"
53
 
54
	Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
55
 
56
	OraDatabase.Parameters.Remove "PROJ_ID"
57
 
58
 
59
 
60
	If rsQry.RecordCount > 0 Then
61
		outobjDetails.Item ("proj_id") = rsQry("proj_id")
62
		outobjDetails.Item ("proj_name") = rsQry("proj_name")
63
		'outobjDetails.Item ("description") = rsQry("description")
64
		'outobjDetails.Item ("parent_rtag_id") = rsQry("parent_rtag_id")
65
		'outobjDetails.Item ("config_spec_branch") = rsQry("config_spec_branch")
66
		'outobjDetails.Item ("owner_email") = rsQry("owner_email")
67
		'If rsQry("assoc_mass_ref") <> "" Then
68
		'outobjDetails.Item ("massref_rtag_id") = rsQry("assoc_mass_ref")
69
		'End If
70
	Else
71
		Err.Raise 8, "Sub GetFormDetails in "& ScriptName, "Empty record set returned. parProjId="& parProjId
72
 
73
	End If
74
 
75
 
76
	rsQry.Close
77
	Set rsQry = Nothing
78
End Sub
79
'--------------------------------------------------------------------------------------------------------------------------
80
Sub DeleteViewOwner (userId, viewId)
81
 
82
	On Error Resume Next
83
 
84
	'Response.Write(Request("user_view_id_list"))
85
 
86
 
87
 
88
 
89
 
90
 
91
	OraDatabase.BeginTrans
92
 
93
	OraDatabase.Parameters.Add "PROJ_ID",		Request("proj_id"), ORAPARM_INPUT, ORATYPE_NUMBER	
94
	OraDatabase.Parameters.Add "VIEW_ID",		viewId, 	ORAPARM_INPUT, ORATYPE_NUMBER	
95
	OraDatabase.Parameters.Add "USER_ID_LIST",	userId, 	ORAPARM_INPUT, ORATYPE_VARCHAR2		
96
	OraDatabase.Parameters.Add "USER_ID", 	objAccessControl.UserId, 	ORAPARM_INPUT, ORATYPE_NUMBER 
97
 
98
	objEH.TryORA ( OraSession )
99
 
100
	OraDatabase.ExecuteSQL _
101
	"BEGIN   REMOVE_PROJECT_VIEW_OWNER ( :PROJ_ID, :VIEW_ID, :USER_ID_LIST, :USER_ID );   END;"
102
 
103
	objEH.CatchORA ( OraSession )
104
 
105
 
106
	OraDatabase.Parameters.Remove "PROJ_ID"	
107
	OraDatabase.Parameters.Remove "VIEW_ID"	
108
	OraDatabase.Parameters.Remove "USER_ID_LIST"	
109
	OraDatabase.Parameters.Remove "USER_ID"
110
 
111
	OraDatabase.CommitTrans	
112
 
113
 
114
End Sub
115
'--------------------------------------------------------------------------------------------------------------------------
116
Sub GetUserViewId(value, posComma)
117
		txt = value
118
		posComma = InStr(txt, ",")
119
End Sub
120
'--------------------------------------------------------------------------------------------------------------------------
121
%>
122
<%
123
'------------ RUN BEFORE PAGE RENDER ----------
124
' --- Get Form details from DB ---
125
Call GetFormDetails ( Request("proj_id"), objFormCollector )
126
 
127
' --- Load Validation Rules ---
128
'Call objForm.LoadValidationRules ( Array("rtag_name","rtag_description", "config_spec_branch"), OraDatabase )		' Load Validation Rules
129
 
130
' --- Enter Form Validation Rule Changes here... ----
131
'----------------------------------------------------
132
 
133
' --- RUN onPostBack ---
134
If Request("action") <> "" Then
135
	If objForm.IsValidOnPostBack Then
136
		Dim txt,posComma, posUnderscore, userId, viewId, value
137
 
138
		Call GetUserViewId(Request("user_view_id_list"), posComma)
139
 
140
		While posComma <> 0
141
			'Response.Write(txt)
142
			value = Mid(txt, 1, posComma-1)
143
			posUnderscore = Instr(value, "_")
144
			userId = Mid(value, 1, posUnderscore - 1)
145
			viewId = Mid(value, posUnderscore + 1, posComma-1)
146
			Call DeleteViewOwner(userId, viewId)
147
			txt = Mid(txt, posComma + 1, Len(txt))
148
			posComma = InStr(txt, ",")
149
		Wend
150
 
151
		If posComma = 0 Then
152
			posUnderscore = Instr(txt, "_")
153
			userId = Mid(txt, 1, posUnderscore - 1)
154
			viewId = Mid(txt, posUnderscore + 1)
155
			Call DeleteViewOwner(userId, viewId)
156
		Else
157
 
158
 
159
 
160
		End if  	
161
 
162
		' --- Form is Valid ---
163
		'Call DeleteViewOwner()
164
 
165
		If objEH.Finally Then
166
			Call OpenInWindow ( "form_edit_project_view.asp?proj_id="&Request("proj_id")&"&FRview_id="&Request("FRview_id") )
167
		End If
168
 
169
	End If
170
 
171
End If
172
 
173
'----------------------------------------------
174
%>
175
 
176
<html>
177
<head>
178
<title>Release Manager</title>
179
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
180
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
181
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
182
<link rel="stylesheet" href="images/navigation.css" type="text/css">
183
<script language="JavaScript" src="images/common.js"></script>
184
 
185
<!-- DROPDOWN MENUS -->
186
 
187
 
188
<!--#include file="_menu_def.asp"-->
189
<script language="JavaScript1.2" src="images/popup_menu.js"></script>
190
 
191
</head>
192
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
193
<!-- MENU LAYERS -------------------------------------->
194
<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)"> 
195
</div>
196
<!-- TIPS LAYERS -------------------------------------->
197
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
198
<!----------------------------------------------------->
199
<!-- HEADER -->
200
<!--#include file="_header.asp"-->
201
<!-- BODY ---->
202
 
203
<table width="100%" border="0" cellspacing="0" cellpadding="0">
204
<%
205
'-- FROM START ---------------------------------------------------------------------------------------------------------
206
objFormComponent.FormName = "FormName"
207
objFormComponent.Action = ScriptName
208
Call objFormComponent.FormStart()
209
%>
210
  <tr> 
211
    <td width="1" background="images/bg_home_orange.gif" valign="top">
212
	</td>
213
	<td width="100%" rowspan="2" align="center" valign="top" bgcolor="#EEEFEF"><table width="10" border="0" cellspacing="0" cellpadding="0">
214
      <tr>
215
        <td width="1%"></td>
216
        <td width="100%">
217
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
218
            <tr>
219
              <td nowrap class="body_txt">
220
 
221
			  </td>
222
 
223
            </tr>
224
          </table>
225
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
226
            <tr>
227
              <td nowrap class="form_ttl"><p>&nbsp;</p>
228
                <p>EDIT PROJECT VIEW DETAILS </p></td>
229
              <td align="right" valign="bottom"></td>
230
            </tr>
231
        </table></td>
232
        <td width="1%"></td>
233
      </tr>
234
      <tr>
235
        <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
236
        <td background="images/lbox_bg_blue.gif" class="lbox_ttl_w"><img src="images/h_trsp_dot.gif" width="600" height="15"></td>
237
        <td align="right" valign="top"  background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
238
      </tr>
239
      <tr>
240
        <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
241
        <td bgcolor="#FFFFFF" valign="top">
242
		<%
243
		If parSourceRtagId <> "" Then
244
			Call Messenger ( "New release will be created from <br>"& objFormCollector.Item("location"), 3, "100%" )
245
		End If
246
		%>
247
		<!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->	
248
		<!--#include file="messages/_msg_inline.asp"-->
249
		<!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
250
		<br>
251
 
252
		<table width="100%"  border="0" cellspacing="2" cellpadding="0">
253
		  <tr>
254
			<td valign="top" nowrap class="form_iname">Project Name </td>
255
			<td valign="top" nowrap><%=objFormComponent.TextBox ( "project_name", objForm.GetValue( "project_name", objFormCollector.Item("proj_name") ), "class='form_ivalue' readonly" )%></td>
256
		  </tr>
257
		  <tr>
258
			<td nowrap class="form_iname" valign="top">Select Base View </td>
259
			<td valign="top" nowrap class="form_iname">
260
			<%
261
			  OraDatabase.Parameters.Add "PROJ_ID", parProjId, 	ORAPARM_INPUT, ORATYPE_NUMBER
262
			  Dim Query_String
263
			  	Query_String = _
264
				"	SELECT DISTINCT vi.view_id, vi.view_name"&_
265
				"	FROM VIEWS vi,"&_
266
				"   RELEASE_CONTENT rc,"&_
267
				"   RELEASE_TAGS rt"&_
268
				"	WHERE rc.BASE_VIEW_ID = vi.VIEW_ID"&_
269
				"   AND rt.proj_id = "& parProjId &_
270
				"   AND rc.rtag_id = rt.rtag_id"&_
271
				" 	ORDER BY UPPER( vi.view_name )"
272
 
273
 
274
			  Set rsQry = OraDatabase.DbCreateDynaset( Query_String , cint(0) )
275
 
276
			  OraDatabase.Parameters.Remove "PROJ_ID"
277
	Response.write "<select name='FRview_id' onChange=""Cascaded_Menu('parent','"& scriptName &"?proj_id="& parProjId &"&FRview_id=',this,0)"" class='form_item'>"
278
Response.write "<option value='0' selected>--NONE--</option>"
279
			  %>
280
 
281
 
282
 
283
				<%While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
284
 
285
			If CDbl(Request("FRview_id")) = CDbl(rsQry.Fields("view_id")) Then
286
	        	Response.write "<option value='"& rsQry.Fields("view_id") &"' selected>"& UCase(rsQry.Fields("view_name")) &"</option>"
287
	        Else
288
 
289
				Response.write "<option value='"& rsQry.Fields("view_id") &"'>"& UCase(rsQry.Fields("view_name")) &"</option>"
290
			End If		
291
					rsQry.MoveNext
292
				WEnd
293
 
294
				rsQry.Close()
295
				Set rsQry = nothing
296
				%>
297
			  </select>			    
298
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
299
		<%If request("FRview_id") <> "" And objAccessControl.IsActive("AdminView") Then %>
300
		<a href="javascript:;" class ="form_iname" onClick="MM_openBrWindow('wAddApplicationUser.asp?proj_id=<%=parProjId%>&view_id=<%=Request("FRview_id")%>','AddApplicationUser','scrollbars=yes,resizable=yes,width=650,height=800')"><img src="images/email-contact-orange.gif">Add View Owner</a>	
301
		<%End If%>
302
		<!-- +++++++++++++++++++++++++++++++++++ -->
303
			</td>
304
			<td width="9%" valign="top"></td>
305
		  </tr>
306
		  		  <tr>
307
			<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col"></td>				  
308
			<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Base View</td>
309
 
310
			<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Full Name</td>
311
			<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">User Name</td>
312
			<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">User Email</td>
313
			<td valign="top">
314
		  </tr>
315
		  <%
316
		  Dim currViewId
317
		  currViewId = -1
318
			  Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM USERS USR, MEMBERS_GROUP MG, VIEWS V, AUTOBUILD_FAILURE AF WHERE  AF.PROJ_ID = "& Request("proj_id") &" AND AF.GROUP_EMAIL_ID = MG.GROUP_EMAIL_ID AND USR.USER_ID = MG.USER_ID AND V.VIEW_ID = AF.VIEW_ID ORDER BY V.VIEW_NAME, USR.FULL_NAME" , cint(0) )
319
		  '--- Render rows ---
320
		  Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
321
		  ' -------- GROUP BY BASE VIEW  -----------------
322
		  If CDbl(currViewid) <> CDbl(rsQry("view_id")) Then		  
323
		 	%>
324
      <tr>
325
        <td colspan="5" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
326
      </tr>
327
      <tr>
328
	  	<td nowrap class="body_scol"></td>
329
        <td nowrap class="body_scol"><%=rsQry("view_name")%></td>
330
		<td nowrap class="body_scol"></td>
331
        <td nowrap class="body_scol"></td>
332
		<td nowrap class="body_scol"></td>
333
      </tr>
334
      <%
335
		  	currViewId = CDbl(rsQry("view_id"))
336
		  End If	  
337
 
338
	  %>
339
 
340
		 <tr>
341
		 <td align="center"><input type="checkbox" name="user_view_id_list" value="<%=rsQry("user_id")%>_<%=rsQry("view_id")%>"></td>
342
		 <td nowrap class="body_rowg"></td>
343
		 <td nowrap class="body_rowg"><%=rsQry("full_name")%></td>
344
		 <td nowrap class="body_rowg"><%=rsQry("user_name")%></td>
345
		 <td nowrap class="body_rowg"><%=rsQry("user_email")%></td>
346
		 </tr>
347
		 <%
348
		 	rsQry.MoveNext
349
 
350
				If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
351
          	<tr>
352
            <td colspan="8" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
353
         	 </tr>
354
		 	 <%End If			
355
		 Loop	
356
		 				rsQry.Close()
357
				Set rsQry = nothing	
358
		  %>		  
359
 
360
 
361
 
362
		  <tr>
363
		    <td class="form_iname">&nbsp;</td>
364
		    <td>&nbsp;</td>
365
		    <td class="val_err"></td>
366
		    </tr>
367
		</table>
368
 
369
 
370
		</td>
371
        <td background="images/lbox_bgside_white.gif">&nbsp;</td>
372
      </tr>
373
	  <tr>
374
        <td background="images/bg_action_norm.gif" ></td>
375
        <td align="right" background="images/bg_action_norm.gif" >
376
 
377
		<%=objFormComponent.CancelButton ( "OK", "class='form_btn'", "rtree.asp?CANCEL=OK&"& objPMod.ComposeURL() )%>
378
		<%=objPMod.ComposeHiddenTags()%>
379
		<%If objAccessControl.IsActive("AdminView") Then%>
380
		<input name="btn" type="submit" class="form_btn" value="Remove View Owner(s)">
381
		<%End If%>
382
		<input type="hidden" name="user_id_list" value="<%=Request("user_id_list")%>">
383
		<input type="hidden" name="action" value="true">
384
		</td>
385
        <td background="images/bg_action_norm.gif" ><img src="images/h_trsp_dot.gif" width="5" height="30"></td>
386
      </tr>
387
      <tr>
388
        <td background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
389
        <td background="images/lbox_bg_blue.gif"></td>
390
        <td background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
391
      </tr>
392
    </table>
393
 
394
	<!-- ACTION BUTTONS ---------------------------------------------->
395
	<!-- ACTION BUTTONS END  ------------------------------------------></td>
396
	<td width="1" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
397
  </tr>
398
  <tr> 
399
    <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_vtree.gif" width="86" height="99" vspace="20" hspace="30"></td>
400
    <td background="images/bg_lght_gray.gif" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="500"></td>
401
  </tr>
402
<%
403
Call objFormComponent.FormEnd()
404
'-- FROM END ----------------------------------------------------------------------------------------------------------------
405
%>   
406
</table>
407
 
408
 
409
<!-- FOOTER -->
410
<!--#include file="_footer.asp"-->
411
</body>
412
</html>
413
<%
414
Call Destroy_All_Objects
415
%>