Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
5357 dpurdie 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", RequestDefault("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 rsQry
32
Dim parProjId
33
Dim parModeCode
6694 dpurdie 34
Dim pvIdList, pvIds, PVS, i, aFullList
5357 dpurdie 35
Dim ProblemsString
36
Dim ProblemInfo
37
Dim rfile
38
'------------ Constants Declaration -----------
6694 dpurdie 39
'Const imgPkgLocked                = "<img src='images/i_locked.gif' width='7' height='10' hspace='4' align='absmiddle' title='Package Locked'>"
5357 dpurdie 40
'------------ Variable Init -------------------
41
parProjId = Request("proj_id")
42
parModeCode = Request("mode_code")
43
objPMod.PersistInQryString("proj_id")
44
rfile = RequestDefault("rfile", "dependencies.asp")
45
Set ProblemInfo =   Server.CreateObject("Scripting.Dictionary")
46
'----------------------------------------------
47
Sub DestroyPackage ( nPvId, cOverrideWarnings, outProblemsString )
48
 
49
   OraDatabase.Parameters.Add "PV_ID",             nPvId,             ORAPARM_INPUT,  ORATYPE_NUMBER
50
   OraDatabase.Parameters.Add "OVERRIDE_WARNINGS", cOverrideWarnings, ORAPARM_INPUT,  ORATYPE_CHAR
51
   OraDatabase.Parameters.Add "PROBLEM_STRING",    NULL,              ORAPARM_OUTPUT, ORATYPE_VARCHAR2
6693 dpurdie 52
   OraDatabase.Parameters("PROBLEM_STRING").MinimumSize = 1000
5357 dpurdie 53
 
54
   'Response.write nPvId &"-"& cOverrideWarnings &"-"& Request("btn")
55
 
56
   objEH.TryORA ( OraSession )
57
   On Error Resume Next
58
   OraDatabase.ExecuteSQL _
59
   "BEGIN "&_
60
   " PK_PACKAGE.DESTROY_PACKAGE ( :PV_ID, :OVERRIDE_WARNINGS, :PROBLEM_STRING ); "&_
61
   "END; "
62
 
63
   objEH.CatchORA ( OraSession )
64
 
65
   outProblemsString = OraDatabase.Parameters("PROBLEM_STRING").Value
66
 
67
   OraDatabase.Parameters.Remove "PV_ID"
68
   OraDatabase.Parameters.Remove "OVERRIDE_WARNINGS"
69
   OraDatabase.Parameters.Remove "PROBLEM_STRING"
70
End Sub
6694 dpurdie 71
'----------------------------------------------
72
Sub RemovePackage ( nPvId, cOverrideWarnings, outProblemsString )
73
    Dim ReturnCode
74
 
75
    'Response.Write "<br>RemovePackage:" & nPvId & "<br>"
76
 
77
    OraDatabase.Parameters.Add "PV_ID",       nPvId,                  ORAPARM_INPUT, ORATYPE_NUMBER
78
    OraDatabase.Parameters.Add "RTAG_ID",     DB_RTAG_ID,             ORAPARM_INPUT, ORATYPE_NUMBER
79
    OraDatabase.Parameters.Add "USER_ID",     objAccessControl.UserId,ORAPARM_INPUT, ORATYPE_NUMBER
80
    OraDatabase.Parameters.Add "FORCE_REMOVE", cOverrideWarnings,     ORAPARM_INPUT, ORATYPE_NUMBER
81
    OraDatabase.Parameters.Add "RETURN_CODE", NULL,                   ORAPARM_OUTPUT, ORATYPE_NUMBER
82
 
83
    objEH.TryORA ( OraSession )
84
    On Error Resume Next
85
 
86
    OraDatabase.ExecuteSQL _
87
    "BEGIN "&_
88
    "   :RETURN_CODE := PK_ENVIRONMENT.REMOVE_PACKAGE ( :PV_ID, :RTAG_ID, :USER_ID, :FORCE_REMOVE );"&_
89
    "END; "
90
 
91
    objEH.CatchORA ( OraSession )
92
 
93
    ReturnCode = OraDatabase.Parameters("RETURN_CODE").Value
94
 
95
    If ( ReturnCode <> 0 ) Then
96
       outProblemsString = "- Unexpected error"
97
    End If
98
 
99
    OraDatabase.Parameters.Remove "PV_ID"
100
    OraDatabase.Parameters.Remove "RTAG_ID"
101
    OraDatabase.Parameters.Remove "USER_ID"
102
    OraDatabase.Parameters.Remove "FORCE_REMOVE"
103
    OraDatabase.Parameters.Remove "RETURN_CODE"
104
 
105
End Sub
106
'----------------------------------------------
5357 dpurdie 107
Sub MovePackage(nPvId, newRtagId)
108
 
109
   OraDatabase.Parameters.Add "PV_ID",          nPvId,    ORAPARM_INPUT, ORATYPE_NUMBER
6694 dpurdie 110
   OraDatabase.Parameters.Add "CURRENT_RTAG_ID",    DB_RTAG_ID,    ORAPARM_INPUT, ORATYPE_NUMBER
5357 dpurdie 111
   OraDatabase.Parameters.Add "NEW_RTAG_ID",       newRtagId,    ORAPARM_INPUT, ORATYPE_NUMBER
112
   OraDatabase.Parameters.Add "USER_ID",          objAccessControl.UserId,    ORAPARM_INPUT, ORATYPE_NUMBER
113
 
114
   'Response.write nPvId &"-"& cOverrideWarnings &"-"& Request("btn")
115
 
116
   objEH.TryORA ( OraSession )
117
   On Error Resume Next
118
 
119
   OraDatabase.ExecuteSQL _
120
   "BEGIN "&_
121
   " PK_PACKAGE.MOVE_PACKAGE ( :PV_ID, :CURRENT_RTAG_ID, :NEW_RTAG_ID, :USER_ID ); "&_
122
   "END; "
123
 
124
   objEH.CatchORA ( OraSession )
125
 
126
   OraDatabase.Parameters.Remove "PV_ID"
127
   OraDatabase.Parameters.Remove "CURRENT_RTAG_ID"
128
   OraDatabase.Parameters.Remove "NEW_RTAG_ID"
129
   OraDatabase.Parameters.Remove "USER_ID"
130
 
131
End Sub
132
'------------ RUN BEFORE PAGE RENDER ----------
133
' --- Enter Form Validation Rule Changes here... ----
134
'----------------------------------------------------
135
 
136
' --- RUN onPostBack ---
137
If Request("action") <> "" Then
138
   Dim decision
139
   Dim problem : problem = false
6694 dpurdie 140
   Dim mode, pvid
5357 dpurdie 141
 
142
   decision = Left(Request("decision"), 1) 'Gets the decision based on the combo box selection
143
 
144
   aFullList = Split ( Replace( Request("pvIds"), " ", "" ), "," )
145
 
146
   If decision = 0 Then
6694 dpurdie 147
      Call OpenInWindow ( rfile & "?rtag_id="&DB_RTAG_ID )
5357 dpurdie 148
   ElseIf decision = 1 Then
6694 dpurdie 149
    '   Destroy or Remove-from-release
150
    '   If the package is 'locked' then it will be removed from the release
151
    '   Otherwise the package will be destroyed
5357 dpurdie 152
      For Each PVS In aFullList
6694 dpurdie 153
          If PVS <> "" Then
154
             mode = Mid(PVS,1,1)
155
             pvid = Mid(PVS,2) 
156
             If mode = "U" Then Call DestroyPackage(pvid, "N", ProblemsString)
157
             If mode = "L" Then Call RemovePackage (pvid, "N", ProblemsString)
158
 
159
             If ProblemsString <> "" Then
160
                ProblemInfo.Add pvid, ProblemsString
161
                problem = true
162
             End If
5357 dpurdie 163
         End If
164
      Next
165
   ElseIf decision = 2 Then
166
      For Each PVS In aFullList
6694 dpurdie 167
        If PVS <> "" Then
168
            mode = Mid(PVS,1,1)
169
            pvid = Mid(PVS,2) 
170
            Call MovePackage(pvid,Request("FRrtag_id"))
171
        End If
5357 dpurdie 172
      Next
173
   End If
174
 
175
   If objEH.Finally AND NOT problem Then
6694 dpurdie 176
      Call OpenInWindow ( "_change_release_mode.asp?mode_code=" & parModeCode & "&rtag_id="&DB_RTAG_ID )
5357 dpurdie 177
   End If
178
 
179
End If
180
 
181
'----------------------------------------------
182
%>
183
 
184
<html>
185
<head>
186
<title>Release Manager</title>
187
<link rel="shortcut icon" href="<%=FavIcon%>"/>
188
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
189
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 190
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
191
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
192
<script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
193
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
5357 dpurdie 194
<script language="JavaScript" type="text/javascript">
195
<!--
196
 
197
function RequestDetails( option, paramString, rowId){
198
 
199
   // Drive the OK button.
200
   // Enable it if user has selected an option
201
   var okBtn = MM_findObj( 'FormOk' );
202
   if (okBtn ) {
203
    okBtn.disabled  = option == 0;
204
    }
205
 
206
   if ( option == 2 )
207
   {
208
      var requestURL = 'RequestReleaseMoveCombo.asp';
209
 
210
      // Set ajax divname
211
      ajaxdivname = rowId;
212
 
213
      //Append the name to search for to the requestURL
214
      var url = requestURL + paramString;
215
 
216
      //Progress
217
      rowId.options[0] = new Option('Loading...','');
218
      rowId.selectedIndex = 0;
219
 
220
 
221
      //Create the xmlHttp object to use in the request
222
      //stateChangeHandler will fire when the state has changed, i.e. data is received back
223
      // This is non-blocking (asynchronous)
224
      xmlHttp = GetXmlHttpObject(stateComboChangeHandler);
225
 
226
      //Send the xmlHttp get to the specified url
227
      xmlHttp_Get(xmlHttp, url);
228
 
229
   }
230
   else
231
   {
232
      var requestURL = 'RequestReleaseMoveCombo.asp';
233
      // Set ajax divname
234
      ajaxdivname = rowId;
235
 
236
      //Append the name to search for to the requestURL
237
      var url = requestURL + '?proj_id=0';
238
 
239
      //Progress
240
 
241
      //Create the xmlHttp object to use in the request
242
      //stateChangeHandler will fire when the state has changed, i.e. data is received back
243
      // This is non-blocking (asynchronous)
244
      xmlHttp = GetXmlHttpObject(stateComboChangeHandler);
245
 
246
      //Send the xmlHttp get to the specified url
247
      xmlHttp_Get(xmlHttp, url);
248
   }
249
}
250
 
251
//-->
252
</script>
253
<!-- DROPDOWN MENUS -->
5983 dpurdie 254
<!--#include file="_jquery_includes.asp"-->
5357 dpurdie 255
<!--#include file="_menu_def.asp"-->
6579 dpurdie 256
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
5357 dpurdie 257
 
258
</head>
259
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onLoad="FormName.proj_name.focus();">
260
<!-- HEADER -->
261
<!--#include file="_header.asp"-->
262
<!-- BODY ---->
263
 
264
<table width="100%" border="0" cellspacing="0" cellpadding="0">
265
   <%
266
   '-- FROM START ---------------------------------------------------------------------------------------------------------
267
   objFormComponent.FormName = "FormName"
268
   objFormComponent.Action = ScriptName
269
   Call objFormComponent.FormStart()
270
   %>
271
   <tr>
6876 dpurdie 272
      <td class='bg_panel'></td>
5357 dpurdie 273
      <td width="100%" rowspan="2" align="center" valign="top" bgcolor="#EEEFEF">
274
         <table width="10" border="0" cellspacing="0" cellpadding="0">
275
            <tr>
276
               <td width="1%"></td>
277
               <td width="100%">
278
                  <table width="100%"  border="0" cellspacing="0" cellpadding="0">
279
                     <tr>
280
                        <td nowrap class="body_txt">
281
                        </td>
282
                     </tr>
283
                  </table>
284
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
285
                     <tr>
286
                        <td nowrap class="form_ttl"><p>&nbsp;</p>
287
                        <%If parModeCode = 5 Then%>
288
                           <p>EDIT RELEASE BEFORE ARCHIVING</p>
289
                        <%ElseIf parModeCode = 6 Then%>
290
                           <p>EDIT RELEASE BEFORE PRESERVING</p>
291
                        <%Else%>
292
                           <p>EDIT RELEASE BEFORE CLOSING</p>
293
                        <%End If%>
294
                        </td>
295
                        <td align="right" valign="bottom"></td>
296
                     </tr>
297
                  </table>
298
               </td>
299
               <td width="1%"></td>
300
            </tr>
301
            <tr>
302
               <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
303
               <td background="images/lbox_bg_blue.gif" class="lbox_ttl_w"><img src="images/h_trsp_dot.gif" width="600" height="15"></td>
304
               <td align="right" valign="top"  background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
305
            </tr>
306
            <tr>
307
               <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
308
               <td bgcolor="#FFFFFF" valign="top">
309
                  <%If ProblemInfo.Count > 0 Then%>
310
                  <span class=err_alert>Problems encountered</span>
311
                  <%End If%>
312
                  <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
313
                  <!--#include file="messages/_msg_inline.asp"-->
314
                  <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
315
                  <br>
316
 
317
                  <table width="100%"  border="0" cellspacing="2" cellpadding="0">
318
 
319
                     <tr>
320
                        <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">State</td>
321
 
322
                        <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Package</td>
323
                        <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
6694 dpurdie 324
                        <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col" width="1%">Lck</td>
5357 dpurdie 325
                        <%If ProblemInfo.Count > 0 Then%>
326
                        <td valign="top" wrap background="images/bg_table_col.gif" class="body_col">Problem</td>
327
                        <%End If%>
328
                        <td valign="top">
329
                     </tr>
330
                     <%
331
                     Dim currState
332
                     currState = ""
6694 dpurdie 333
                     OraDatabase.Parameters.Add "RTAG_ID", DB_RTAG_ID, ORAPARM_INPUT, ORATYPE_NUMBER
5357 dpurdie 334
                     Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("CheckWIPS.sql") , cint(0) )
335
                     OraDatabase.Parameters.Remove "RTAG_ID"
336
 
337
                     '--- Render rows ---
338
                     Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
6694 dpurdie 339
                        Dim vlink, pvidFlag
5357 dpurdie 340
 
6694 dpurdie 341
                        pvid = CStr(rsQry("pv_id"))
342
                        vlink = "dependencies.asp?rtag_id=" & DB_RTAG_ID & "&pv_id=" & pvid  
343
 
5357 dpurdie 344
                        'Add   the   pv_ids   to   the   Array
6694 dpurdie 345
                        pvidFlag = "U"
346
                        If rsQry("dlocked") = "Y" Then
347
                            pvidFlag = "L"
348
                        End If
349
 
350
                        PVS = PVS + pvidFlag + pvid +  ","
351
 
5357 dpurdie 352
                        ' -------- GROUP BY BASE VIEW  -----------------
353
                        If CStr(currState) <> CStr(rsQry("state")) Then
354
                        %>
355
                           <tr>
356
                              <td colspan="5" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
357
                           </tr>
358
                           <tr>
359
                              <td nowrap class="body_scol"><%=rsQry("state")%></td>
360
                              <td nowrap class="body_scol"></td>
361
                              <td nowrap class="body_scol"></td>
362
                           </tr>
363
                           <%
364
                           currState = CStr(rsQry("state"))
365
                        End If
366
                        %>
367
 
368
                        <tr>
369
                           <td nowrap class="body_rowg"></td>
370
                           <td nowrap class="body_rowg"><%=rsQry("pkg_name")%></td>
6694 dpurdie 371
                           <td nowrap class="body_rowg"><a href=<%=vlink%>><%=rsQry("pkg_version")%></a></td>
372
                           <td nowrap class="body_rowg">
373
                           <%If pvidFlag = "L" Then
374
                                Response.Write imgPkgLocked
375
                            End If     
376
                           %> 
377
                           </td>
5357 dpurdie 378
                        <%If ProblemInfo.Count > 0 Then%>
6694 dpurdie 379
                           <td nowrap class="body_rowg err_alert"><%=NewLine_To_BR(ProblemInfo.Item(pvid))%></td>
5357 dpurdie 380
                        <%End If%>
381
                        </tr>
382
                        <%
383
                        rsQry.MoveNext
384
 
385
                        If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
386
                           <tr>
387
                              <td colspan="8" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
388
                           </tr>
389
                        <%End If
390
                     Loop
391
                     rsQry.Close()
392
                     Set rsQry = nothing
393
                     %>
394
                     <tr>
395
                        <td class="form_iname">&nbsp;</td>
396
                        <td>&nbsp;</td>
397
                        <td class="val_err"></td>
398
                     </tr>
399
                  </table>
400
               </td>
401
               <td background="images/lbox_bgside_white.gif">&nbsp;</td>
402
            </tr>
403
            <tr>
6877 dpurdie 404
               <td class='bg_dialog'></td>
405
               <td align="right" class='bg_dialog' >
5357 dpurdie 406
                  <a class="body_col">Select Decision: </a>
6694 dpurdie 407
                  <select name="decision" id="decision" onChange="RequestDetails( this.value, '?proj_id=<%=DB_PROJ_ID%>&rtag_id=<%=DB_RTAG_ID%>', FormName.FRrtag_id );" class="form_item">
5357 dpurdie 408
                     <option value='0' selected>--None--</option>
409
                     <option value='1' >Delete All</option>
410
                     <option value='2' >Move All</option>
411
                  </select>
412
 
413
                  <a class="body_col">Select Destination: </a>
414
                  <select name="FRrtag_id" id="FRrtag_id" class="form_item">
415
                  </select>
416
 
417
                  <%=objFormComponent.SubmitButton ( "OK", "class='form_btn' id='FormOk' disabled" )%>&nbsp;
6694 dpurdie 418
                  <%=objFormComponent.CancelButton ( "Cancel", "class='form_btn'", rfile&"?rtag_id="&DB_RTAG_ID )%>
5357 dpurdie 419
                  <%=objPMod.ComposeHiddenTags()%>
420
                  <input type="hidden" name="decision" value="decision.value">
421
                  <%If Request("FRrtag_id") <> "" Then%>
422
                     <input type="hidden" name="FRrtag_id" value="FRrtag_id.value">
423
                  <%End If%>
424
                  <input type="hidden" name="action" value="true">
425
                  <input type="hidden" name="pvIds" value=<%=PVS%>>
426
                  <input type="hidden" name="mode_code" value=<%=parModeCode%>>
427
               </td>
6877 dpurdie 428
               <td class='bg_dialog'><img src="images/h_trsp_dot.gif" width="5" height="30"></td>
5357 dpurdie 429
            </tr>
430
            <tr>
431
               <td background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
432
               <td background="images/lbox_bg_blue.gif"></td>
433
               <td background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
434
            </tr>
435
         </table>
436
 
437
         <!-- ACTION BUTTONS ---------------------------------------------->
438
         <!-- ACTION BUTTONS END  ------------------------------------------>
439
      </td>
440
      <td width="1" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
441
   </tr>
442
   <tr>
6876 dpurdie 443
      <td class='bg_panel_btm'><img src="images/img_vtree.gif" width="86" height="99" vspace="20" hspace="30"></td>
5357 dpurdie 444
      <td background="images/bg_lght_gray.gif" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="500"></td>
445
   </tr>
446
   <%
447
   Call objFormComponent.FormEnd()
448
   '-- FROM END ----------------------------------------------------------------------------------------------------------------
449
   %>
450
</table>
451
<!-- FOOTER -->
452
<!--#include file="_footer.asp"-->
453
</body>
454
</html>