Subversion Repositories DevTools

Rev

Rev 5071 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5071 Rev 5084
Line 34... Line 34...
34 
Dim sdkAdded
 34 
Dim sdkAdded
35 
Dim rsView
 35 
Dim rsView
36 
'------------ Constants Declaration -----------
 36 
'------------ Constants Declaration -----------
37 
'------------ Variable Init -------------------
 37 
'------------ Variable Init -------------------
38 
sdkAdded = FALSE
 38 
sdkAdded = FALSE
39 
 
 - 
 
- 
 
 39 
Set pkgInfoHash = CreateObject("Scripting.Dictionary")
40 
'----------------------------------------------
 40 
'----------------------------------------------
41 
%>
 41 
%>
42 
<%
 42 
<%
43 
'-------------------------------------------------
 43 
'-------------------------------------------------
44 
' Function:     AddReleaseSDK
44 
' Function:     AddReleaseSDK
Line 87... Line 87...
87 
%>
 87 
%>
88 
<%
 88 
<%
89 
'-----------------------  MAIN LINE  ---------------------------
 89 
'-----------------------  MAIN LINE  ---------------------------
90 
 
 90 
 
91 
'------ ACCESS CONTROL ----------
 91 
'------ ACCESS CONTROL ----------
92 
'If NOT canShowControlInProject("AddReleaseSDK") Then
 92 
If NOT canShowControlInProject("AddSdk") Then
93 
'   Err.Raise 8, "User not authorized to add an SDK.<br>"& objPMod.ComposeURL()
 93 
    Call RaiseMsg(enum_MSG_ERROR, "User not authorized to add an SDK.<br>User login may have expired.")
94 
'End If
 94 
End If
95 
'--------------------------------
 95 
'--------------------------------
96 
 
 96 
 
97 
If (Request("rtag_id") <> "")  AND  (Request("sdktag_id") <> "") Then
 97 
If (Request("rtag_id") <> "")  AND  (Request("sdktag_id") <> "") Then
98 
 
 98 
 
99 
   '--- Process submition ---
 99 
   '--- Process submition ---
Line 107... Line 107...
107 
 
 107 
 
108 
   Err.Raise 8, "This page requires more paramaters to run.<br>"& objPMod.ComposeURL()
 108 
   Err.Raise 8, "This page requires more paramaters to run.<br>"& objPMod.ComposeURL()
109 
 
 109 
 
110 
End If
 110 
End If
111 
 
 111 
 
- 
 
 112 
'-------------------------------------------------
- 
 
 113 
' Function:     GetPackageInfo
- 
 
 114 
' Description:  Build up a hash of the required package information for  the display
- 
 
 115 
'               Start with the results of one query that is a list of pv_ids
- 
 
 116 
Sub GetPackageInfo
- 
 
 117 
   Dim listPvid : listPvid = ""
- 
 
 118 
   Dim joiner : joiner = ""
- 
 
 119 
   Dim rsTemp, sqlStr
- 
 
 120 
   Dim nRtagId : nRtagId = Request("rtag_id")
- 
 
 121 
 
- 
 
 122 
   '    Build up a list of pv_id's to process
- 
 
 123 
 
- 
 
 124 
    While ((NOT rsView.BOF) AND (NOT rsView.EOF))
- 
 
 125 
        listPvid = listPvid & joiner & rsView(0)
- 
 
 126 
        joiner = ", "
- 
 
 127 
    rsView.MoveNext
- 
 
 128 
    WEnd
- 
 
 129 
 
- 
 
 130 
    sqlStr = "Select pv.pv_id, pv.pkg_version, p.pkg_name, NVL(rc.sdktag_id,0) as sdktag_id, sn.sdk_name || '::' || st.sdktag_name as sdk_name" &_
- 
 
 131 
             " FROM RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, PACKAGES p, SDK_TAGS st, SDK_NAMES sn" &_
- 
 
 132 
             " WHERE rc.pv_id = pv.pv_id" &_
- 
 
 133 
             " AND st.SDKTAG_ID(+) = rc.SDKTAG_ID" &_
- 
 
 134 
             " AND st.SDK_ID = sn.SDK_ID(+)" &_
- 
 
 135 
             " AND pv.PKG_ID = p.PKG_ID" &_
- 
 
 136 
             " AND rc.rtag_id = :RTAG_ID " &_
- 
 
 137 
             " AND pv.pv_id in ("&listPvid&")" &_
- 
 
 138 
             " ORDER BY UPPER(p.pkg_name)"
- 
 
 139 
 
- 
 
 140 
    OraDatabase.Parameters.Add "RTAG_ID",        nRtagId,       ORAPARM_INPUT, ORATYPE_NUMBER
- 
 
 141 
 
- 
 
 142 
    Set rsTemp = OraDatabase.DbCreateDynaset( sqlStr, 0 )
- 
 
 143 
      Do Until ((rsTemp.BOF) OR (rsTemp.EOF))
- 
 
 144 
         Response.Write "<tr>"
- 
 
 145 
         Response.Write "<td>"
- 
 
 146 
         If rsTemp("sdktag_id") <> 0 Then Response.Write enum_imgSdkImport
- 
 
 147 
         Response.Write "<td nowrap>" & rsTemp("pkg_name")
- 
 
 148 
         Response.Write "<td nowrap>" & rsTemp("pkg_version")
- 
 
 149 
         Response.Write "<td>"
- 
 
 150 
         If rsTemp("sdktag_id") <> 0 Then Response.Write rsTemp("sdk_name")
- 
 
 151 
         Response.Write "<td>"
- 
 
 152 
         If rsTemp("sdktag_id") = 0 Then Response.Write "<img src='images/i_delete_disable.gif' width='13' height='12' hspace='2' border='0' title='Delete this package from the Release'>"
- 
 
 153 
         Response.Write "</tr>"
- 
 
 154 
         rsTemp.MoveNext
- 
 
 155 
      Loop
- 
 
 156 
    rsTemp.Close
- 
 
 157 
    Set rsTemp = nothing
- 
 
 158 
 
- 
 
 159 
    OraDatabase.Parameters.Remove "RTAG_ID"
- 
 
 160 
End Sub
112 
'----------------------------------------------------------------
 161 
'----------------------------------------------------------------
- 
 
 162 
'
- 
 
 163 
'   The body of this page will be displayed only if an error in the insertion process
- 
 
 164 
'   occured. Not packages will have been inserted as the transaction will have been
- 
 
 165 
'   rolled back. We have a list if PV_ID's that conflicted
- 
 
 166 
'
- 
 
 167 
'   Generate a display showing:
- 
 
 168 
'       Conflicting package name and version
- 
 
 169 
'       If the package is imported via an SDK - then highlight this
- 
 
 170 
'       If the package is not, then allow the user to delete the package-version from the release
113 
%>
 171 
%>
114 
 
 - 
 
115 
 
 - 
 
116 
<html>
 172 
<html>
117 
<head>
 173 
<head>
118 
<title>Release Manager</title>
 174 
<title>Release Manager</title>
119 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
 175 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
120 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 176 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
Line 123... Line 179...
123 
<script language="JavaScript" src="images/common.js"></script>
 179 
<script language="JavaScript" src="images/common.js"></script>
124 
 
 180 
 
125 
</head>
 181 
</head>
126 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
 182 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
127 
<!-- BODY ---->
 183 
<!-- BODY ---->
128 
 
 - 
 
129 
 
 - 
 
130 
<table width="100%" height="98%"  border="0" cellpadding="0" cellspacing="0">
 184 
<table width="100%" height="98%"  border="0" cellpadding="0" cellspacing="0">
131 
   <tr>
 185 
   <tr>
132 
      <td align="center" valign="middle" background="images/bg_form_lightgray.gif">
 186 
      <td align="center" valign="middle" class="form_item_grey">
133 
         <table width="650" border="0" cellspacing="0" cellpadding="0">
 187 
         <table width="650" border="0" cellspacing="0" cellpadding="0">
134 
            <tr>
 188 
            <tr>
135 
               <td>
 189 
               <td>
136 
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
 190 
                  <table class="full_table rounded_box" bgcolor="#FFFFFF">
137 
                     <tr>
 191 
                     <tr>
138 
                        <td align="left" valign="top" width="1%" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>
 - 
 
139 
                        <td background="images/lbox_bg_blue.gif"><!-- Heading -->
 - 
 
140 
                        <img src="images/h_trsp_dot.gif" width="1" height="20">
 - 
 
141 
                        <!-- END Heading --></td>
 192 
                        <td width="10px"></td>
142 
                        <td align="right" valign="top" width="1%" background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>
 - 
 
143 
                     </tr>
 - 
 
144 
                     <tr>
 - 
 
145 
                        <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
 - 
 
146 
                        <td bgcolor="#FFFFFF" valign="top">
 193 
                        <td valign="top">
147 
                           <!-- Body -->
 194 
                           <!-- Body -->
148 
                           <table width="100%" border="0" cellspacing="1" cellpadding="2">
 195 
                           <table class="full_table">
149 
                              <form name="form" method="get" action="<%=ScriptName%>">
 196 
                              <form name="form" method="get" action="<%=ScriptName%>">
150 
                                 <tr>
 197 
                                 <tr>
151 
                                    <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
 - 
 
152 
                                    <td width="1%" nowrap class="form_group" valign="bottom"></td>
 - 
 
153 
                                    <td nowrap width="100%" align="right" class="form_step"></td>
 198 
                                    <td width="10px" height=10"px"></td>
154 
                                 </tr>
 199 
                                 </tr>
155 
                                 <tr>
 200 
                                 <tr>
156 
                                    <td width="1%">&nbsp;</td>
 - 
 
157 
                                    <td colspan="2" width="1%" nowrap class="form_field">
 201 
                                    <td nowrap class="form_field">
158 
                                       <table width="100%"  border="0" cellspacing="0" cellpadding="10">
 202 
                                       <table class="full_table form_item_grey" style="border-spacing: 1px 1px;">
159 
                                          <tr>
 203 
                                          <tr>
160 
                                             <td background="images/bg_form_lightbluedark.gif"><p class="err_ttl">Please note:</p></td>
 204 
                                             <td colspan=5 class="form_field_bg"><p class="err_ttl">Import SDK. Conflicting Packages</p></td>
- 
 
 205 
                                          </tr>
- 
 
 206 
                                          <tr class="form_field form_field_bg">
- 
 
 207 
                                              <td width="15px"></td>
- 
 
 208 
                                              <td width="1%">Name</td>
- 
 
 209 
                                              <td>Version</td>
- 
 
 210 
                                              <td>SDK</td>
- 
 
 211 
                                              <td width="1%"></td>
161 
                                          </tr>
 212 
                                          </tr>
162 
<%While ((NOT rsView.BOF) AND (NOT rsView.EOF))%>
 - 
 
163 
 
 - 
 
164 
                                          <tr>
 213 
                                          <tr>
165 
                                             <td background="images/bg_form_lightgray.gif" class="form_item">
 - 
 
166 
                                                <%
 - 
 
167 
                                                Response.write "PVID:" & rsView(0)
 - 
 
168 
                                                %>
 214 
                                            <% Call GetPackageInfo %>
169 
                                             </td>
 - 
 
170 
                                          </tr>
 215 
                                          </tr>
171 
<%rsView.MoveNext%>
 - 
 
172 
<%WEnd%>
 - 
 
173 
                                          <tr>
 216 
                                          <tr>
- 
 
 217 
                                             <td colspan=5 class="form_field_hdr">
- 
 
 218 
                                                This action will be cancelled&nbsp;
174 
                                             <td background="images/bg_form_lightgray.gif" class="form_item">This action will be cancelled ? </td>
 219 
                                                <input type="reset" name="btn" value="Return" class="form_btn" onClick="history.back();">
- 
 
 220 
                                              </td>
175 
                                          </tr>
 221 
                                          </tr>
176 
                                       </table>
 222 
                                       </table>
177 
                                    </td>
 223 
                                    </td>
178 
                                 </tr>
 224 
                                 </tr>
179 
                                 <tr>
 225 
                                 <tr>
180 
                                    <td width="1%">&nbsp;</td>
 226 
                                    <td height="10px"></td>
181 
                                    <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
 - 
 
182 
                                    <td nowrap width="100%" class="body_scol">
 - 
 
183 
                                       <br>
 - 
 
184 
                                       <input type="reset" name="btn" value="   OK   " class="form_btn" onClick="history.back();">
 - 
 
185 
                                       <br><br>
 - 
 
186 
                                    </td>
 - 
 
187 
                                 </tr>
 - 
 
188 
                                 <%=objPMod.ComposeHiddenTags()%>
 227 
                                 <%=objPMod.ComposeHiddenTags()%>
189 
                              </form>
 228 
                              </form>
190 
                           </table>
 229 
                           </table>
191 
                           <!-- END Body-->
 230 
                           <!-- END Body-->
192 
                        </td>
 231 
                        </td>
193 
                        <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
 - 
 
194 
                     </tr>
 - 
 
195 
                     <tr>
 - 
 
196 
                        <td width="1%" background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
 - 
 
197 
                        <td background="images/lbox_bg_blue.gif"></td>
 232 
                        <td width="10px"></td>
198 
                        <td width="1%" background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>
 - 
 
199 
                     </tr>
 233 
                     </tr>
200 
                  </table>
 234 
                  </table>
201 
               </td>
 235 
               </td>
202 
            </tr>
 236 
            </tr>
203 
         </table>
 237 
         </table>