Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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