Subversion Repositories DevTools

Rev

Rev 6610 | Rev 6613 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5927 dpurdie 1
<%
2
'=====================================================
3
'   _used_by.asp
4
'   Core Implementation.
5
'   Needs to be used via a wrapper
6
'=====================================================
7
%>
8
<%
9
'------------ Variable Definition -------------
10
Dim rsTemp, rsState
11
Dim projId
12
Dim pkgId
13
Dim rsQry
14
Dim isDaemonEnabledRelease
15
'------------ Constants Declaration -----------
16
Const IMG_SVTREE = "<img src='images/i_vtree_small.gif' hspace='3' align='absmiddle' border='0'>"
17
Const IMG_WORLD = "<img src='images/i_foldero_small.gif' hspace='3' align='absmiddle' border='0'>"
18
Const IMG_GAP = "<img src='images/spacer.gif' width='20' height='1' border='0'>"
19
Const IMG_POINTER = "<img src='images/i_pointer.gif' border='0'>"
20
'------------ Variable Init -------------------
21
'----------------------------------------------
22
%>
23
<%
24
'-----------------------------------------------------------------------------------------------------------------------------
25
If pageIsEmbedded Then
26
    isDaemonEnabledRelease = TRUE
27
Else
28
    isDaemonEnabledRelease = is_daemon_enabled_release(parRtag_id, TRUE)
29
End If
30
 
31
If Request("action") <> "" AND NOT pageIsEmbedded Then
32
   %>
33
   <!--#include file="_access_control_login.asp"-->
34
   <!--#include file="_access_control_project.asp"-->
35
   <%
36
   If ( parRtag_id <> "") AND (parPv_id <> "") Then
37
 
38
      Dim posComma, txt, posUnderscore, dpvId, pvId, value, pvIdList, apvIdList, strList
39
 
40
      If isDaemonEnabledRelease = FALSE Then
41
 
42
         Set pvIdList = CreateObject("Scripting.Dictionary")
43
         'On Error Resume Next
44
         txt = Mid(Request("ignore_warnings"), 1, len(Request("ignore_warnings")))
45
         posComma = InStr(txt, ",")
46
 
47
         While posComma <> 0
48
            'Response.Write(txt)
49
            value = Mid(txt, 1, posComma-1)
50
            posUnderscore = Instr(value, "_")
51
            pvId = Mid(value, 1, posUnderscore - 1)
52
            dpvId = Mid(value, posUnderscore + 1, posComma-1)
53
 
54
            Call SetIgnoreWarnings(dpvId, pvId, parRtag_id)
55
            pvIdList.Add CStr( pvId ), Empty
56
            txt = Mid(txt, posComma + 1, Len(txt))
57
            posComma = InStr(txt, ",")
58
         WEnd
59
 
60
         If posComma = 0 And Len(txt) > 0 Then
61
            posUnderscore = Instr(txt, "_")
62
            pvId = Mid(txt, 1, posUnderscore - 1)
63
            dpvId = Mid(txt, posUnderscore + 1)
64
            Call SetIgnoreWarnings(dpvId, pvId, parRtag_id)
65
            pvIdList.Add CStr( pvId ), Empty
66
         End if
67
 
68
         apvIdList = pvIdList.Keys
69
 
70
      End If
71
 
5957 dpurdie 72
      Call Destroy_All_Objects
5927 dpurdie 73
      Response.Redirect("used_by.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id)
74
   Else
75
      Response.write "Some mandatory parameters are missing!" & "<br>" 'TODO
76
      Response.write QSTR_FullQuery
77
   End If
78
End If
79
%>
80
<script language="javascript">
81
<!--
82
function checkUncheckAll(theElement) {
83
   var theForm = theElement.form, z = 0;
84
   for(z=0; z<theForm.length;z++){
85
      if(theForm[z].type == 'checkbox' && theForm[z].name != 'checkall' && theForm[z].disabled != true){
86
         theForm[z].checked = theElement.checked;
87
      }
88
   }
89
}
90
 
5947 dpurdie 91
//  Show users of this package
92
function showUsedBy(el){
93
    var url = el.value;
94
    var baseId = 'EXTENDED'; 
95
    var divel = MM_findObj(baseId);
96
    if (url)
97
    {
98
        // Show the DIV we are about to load
99
        divel.style.display = 'block';
100
        divel.innerHTML = '<%=enumLOADING%>';
5927 dpurdie 101
 
5947 dpurdie 102
        // Set div name for ajax loading
103
		ajaxdivname = baseId;
104
 
105
		//Create the xmlHttp object to use in the request
106
		//stateChangeHandler will fire when the state has changed, i.e. data is received back
107
		// This is non-blocking (asynchronous)
108
		xmlHttp = GetXmlHttpObject(stateChangeHandler);
109
 
110
		//Send the xmlHttp get to the specified url
111
		xmlHttp_Get(xmlHttp, url);
112
    }
113
    else
114
    {
115
        divel.style.display = 'none';
116
    }
117
}
118
 
5927 dpurdie 119
//
120
//	Load/Hide/Show an Ajax expander
121
//	BaseId - Base for two IDs.
122
//			 IMG_BaseId - image to to toggle
123
//			 BaseId - Div to load data into
124
//	url - Url used to load subcontrol
125
function ToggleUsedByControl(baseId, url)
126
{
127
	var img, dmode;
128
	var imgel = MM_findObj("IMG_" + baseId);
129
	var divel = MM_findObj(baseId);
130
	var showing = divel.getAttribute("data-show");
131
	if(showing == 1)
132
	{
133
		img = "images/bt_minus.gif";
134
		dmode = 'block';
135
		showing = 2
136
	}
137
	else if(showing == 2)
138
	{
139
		img = "images/bt_plus.gif";
140
		dmode = 'none';
141
		showing = 1;
142
	}
143
	else
144
	{
145
		img = "images/bt_minus.gif";
146
		dmode = 'block';
147
		showing = 2;
148
 
149
		// Set div name for ajax loading
150
		ajaxdivname = baseId;
151
 
152
		//Create the xmlHttp object to use in the request
153
		//stateChangeHandler will fire when the state has changed, i.e. data is received back
154
		// This is non-blocking (asynchronous)
155
		xmlHttp = GetXmlHttpObject(stateChangeHandler);
156
 
157
		//Send the xmlHttp get to the specified url
158
		xmlHttp_Get(xmlHttp, url);
159
	}
160
	// Update image and attributes
161
	imgel.src = img;
162
	divel.style.display = dmode;
163
	divel.setAttribute("data-show", showing);
164
}
5939 dpurdie 165
 
166
function matchValue(ename) {
167
    var el
168
    el = document.getElementsByName(ename);
169
    if (el[0] && el[0].checked) return 1;
170
    return 0;
171
} 
172
 
5927 dpurdie 173
//-->
174
</script>
175
    <%
5932 dpurdie 176
    If pkgInfoHash.Exists("pv_id") Then
5927 dpurdie 177
    '-- FROM START ---------------------------------------------------------------------------------------------------------
178
    objFormComponent.FormName = "FormName"
179
    objFormComponent.Action = ScriptName&"?pv_id="&Request("pv_id")&"&rtag_id="&parRtag_id
180
    Call objFormComponent.FormStart()
181
    %>
182
    <%If Request("rtag_id") <> "" Then%>
183
     <br>
5939 dpurdie 184
     <span class="body_sect">Used by Packages In This Release</span>
185
     <br>
5927 dpurdie 186
     <!-- USED BY ------------------------------------------------>
187
     <table width="100%" border="0" cellspacing="1" cellpadding="3">
188
        <tr>
189
           <%If isDaemonEnabledRelease = FALSE Then%>
190
              <td background="images/bg_form_lightbluedark.gif" nowrap width="1" class="form_field"><INPUT type=checkbox name="checkall" value="Check All" onClick="checkUncheckAll(this);"></td>
191
           <%End If%>
192
           <td background="images/bg_form_lightbluedark.gif" nowrap width="1"></td>
193
           <td background="images/bg_form_lightbluedark.gif" nowrap width="1" class="form_field">Name</td>
194
           <td background="images/bg_form_lightbluedark.gif" nowrap width="25%" class="form_field">Version</td>
195
           <td background="images/bg_form_lightbluedark.gif" nowrap width="25%" class="form_field">Location</td>
196
           <td background="images/bg_form_lightbluedark.gif" nowrap width="1" class="form_field"></td>
197
           <td background="images/bg_form_lightbluedark.gif" nowrap width="25%" class="form_field">Version Used</td>
198
           <td background="images/bg_form_lightbluedark.gif" nowrap width="25%" class="form_field">Last Modified</td>
199
        </tr>
200
        <%
201
        OraDatabase.Parameters.Add "RTAG_ID", parRtag_id,                 ORAPARM_INPUT, ORATYPE_NUMBER
202
        OraDatabase.Parameters.Add "PKG_ID",  pkgInfoHash.Item("pkg_id"), ORAPARM_INPUT, ORATYPE_NUMBER
5939 dpurdie 203
		OraDatabase.Parameters.Add "V_EXT",   EmptyToNull(pkgInfoHash.Item ("v_ext")), ORAPARM_INPUT, ORATYPE_VARCHAR2
5927 dpurdie 204
 
205
        Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("UsedByPackagesInThisRelease.sql"), cint(0))
206
 
207
        OraDatabase.Parameters.Remove "RTAG_ID"
208
        OraDatabase.Parameters.Remove "PKG_ID"
209
        OraDatabase.Parameters.Remove "V_EXT"
210
        %>
211
        <%If rsTemp.RecordCount < 1 Then%>
212
           <tr>
213
              <%If isDaemonEnabledRelease = FALSE Then%>
214
                 <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
215
              <%End If%>
216
              <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
217
              <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
218
              <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
219
              <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td><br>
220
              <td background="images/bg_form_lightgray.gif" nowrap>&nbsp;</td>
221
              <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
222
              <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
223
           </tr>
224
        <%End If%>
225
        <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
226
           <tr>
5939 dpurdie 227
              <% Set rsState = OraDatabase.DbCreateDynaset( "select deprecated_state from release_content where rtag_id="&parRtag_id&" and pv_id="&rsTemp("pv_id"), cint(0))%>
5927 dpurdie 228
              <%If isDaemonEnabledRelease = FALSE Then%>
229
                 <%If rsTemp("dpv_id") <> parPv_id And IsNull(rsTemp("ignore_warn")) Then%>
230
                    <td background="images/bg_form_lightgray.gif" nowrap><input type="checkbox" name="ignore_warnings" value="<%=rsTemp("pv_id")%>_<%=rsTemp("dpv_id")%>"></td>
231
                 <%ElseIf rsTemp("dpv_id") = parPv_id And IsNull(rsTemp("ignore_warn")) OR NOT isNull(rsTemp("ignore_warn")) Then%>
232
                    <td background="images/bg_form_lightgray.gif" nowrap><input type="checkbox" name="ignore_warnings" value="<%=rsTemp("pv_id")%>_<%=rsTemp("dpv_id")%>" disabled></td>
233
                 <%Else%>
234
                    <td background="images/bg_form_lightgray.gif" nowrap><input type="checkbox" name="ignore_warnings" value="<%=rsTemp("pv_id")%>_<%=rsTemp("dpv_id")%>" checked></td>
235
                 <%End If%>
236
              <%End If%>
237
 
238
              <%If rsState("deprecated_state") <> "" AND rsTemp("pkg_state") = 0 Then%>
239
                 <td background="images/bg_form_lightgray.gif"><%=DefineStateIcon ( rsState("deprecated_state"), rsTemp("dlocked"), NULL, NULL, pkgInfoHash.Item("build_type"), TRUE )%></td>
240
              <%Else%>
241
                 <td background="images/bg_form_lightgray.gif"><%=DefineStateIcon ( rsTemp("pkg_state"), rsTemp("dlocked"), NULL, NULL, pkgInfoHash.Item("build_type"), TRUE )%></td>
242
              <%End If%>
243
 
244
              <td background="images/bg_form_lightgray.gif" nowrap><a href="used_by.asp?pv_id=<%=rsTemp("pv_id")%>&rtag_id=<%=parRtag_id%>" class="txt_linked"><%=rsTemp("pkg_name")%></a></td>
245
              <td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp("pkg_version")%></td>
246
              <td background="images/bg_form_lightgray.gif" class="body_txt_gray" nowrap><%=GetEnvName(rsTemp("env_area"))%></td>
247
              <td background="images/bg_form_lightgray.gif"><%=DefineStateIcon ( 0, "Y", rsTemp("ignore_warn"), rsTemp("is_patch_ignore"), pkgInfoHash.Item("build_type"), TRUE )%></td>
248
              <td background="images/bg_form_lightgray.gif" <%If rsTemp("dpv_id") <> parPv_id Then%>class="err_alert"<%Else%>class="form_item"<%End If%>><%=pkgInfoHash.Item ("pkg_name") &" "& rsTemp("dpkg_version")%></td>
6612 dpurdie 249
              <td background="images/bg_form_lightgray.gif" class="form_item"><%=emailField(enum_imgUser & rsTemp("full_name"), rsTemp("user_email"))%>&nbsp;<%=DisplayDate ( rsTemp("modified_stamp") )%></td>
5927 dpurdie 250
           </tr>
251
           <%rsTemp.MoveNext
252
           rsTemp.Close()
253
           rsState.Close()
254
 
255
           Set rsState = nothing
256
        WEnd
257
        Set rsTemp = nothing
258
        %>
259
     </table>
260
     <%If isDaemonEnabledRelease = FALSE Then%>
261
        <input name="btn" type="submit" class="form_btn" value="Apply"><br>
262
        <SPAN class="rep_small">NOTE: Click on Apply "To Ignore Warnings" On Packages Used By</SPAN><br>
263
     <%End If%>
264
     <SPAN class="rep_small">NOTE: Versions in <SPAN class="err_alert">RED</SPAN> are different from <%=pkgInfoHash.Item("pkg_name") &" "& pkgInfoHash.Item("pkg_version")%></span>
265
     <input type="hidden" name="action" value="true">
266
    <%End If%>
267
    <%
268
    Call objFormComponent.FormEnd()
269
    '-- FROM END ----------------------------------------------------------------------------------------------------------------
270
    %>
5947 dpurdie 271
    <!-- Extended Searching ---------------------------------------->
5939 dpurdie 272
    <br>
5947 dpurdie 273
    <span class=body_txt>Extended Package Usage</span>
274
    <select class=body_txt onChange="showUsedBy(this);">
275
        <option value ="">Select one</option>
6126 dpurdie 276
 
5948 dpurdie 277
        <option disabled="disabled">Projects</option>
5947 dpurdie 278
        <option value='RequestUsedByThisProjectSummary.asp?pv_id=<%=parPv_id%>&mode=2'>Projects that use: (<%=pkgInfoHash.Item("pkg_name")%>&nbsp;<%=pkgInfoHash.Item("pkg_version")%>)</option>
279
        <option value='RequestUsedByThisProjectSummary.asp?pv_id=<%=parPv_id%>&mode=1'>Projects that use: (<%=pkgInfoHash.Item("pkg_name")%><%=pkgInfoHash.Item("v_ext")%>)</option>
280
        <option value='RequestUsedByThisProjectSummary.asp?pv_id=<%=parPv_id%>&mode=0'>Projects that use: (<%=pkgInfoHash.Item("pkg_name")%>)</option>
6126 dpurdie 281
 
5948 dpurdie 282
        <option disabled="disabled">Packages</option>
5947 dpurdie 283
        <option value='UsedByPackageSummary.asp?pv_id=<%=parPv_id%>&mode=2'>Packages that use: (<%=pkgInfoHash.Item("pkg_name")%>&nbsp;<%=pkgInfoHash.Item("pkg_version")%>)</option>
284
        <option value='UsedByPackageSummary.asp?pv_id=<%=parPv_id%>&mode=1'>Packages that use: (<%=pkgInfoHash.Item("pkg_name")%><%=pkgInfoHash.Item("v_ext")%>)</option>
285
        <option value='UsedByPackageSummary.asp?pv_id=<%=parPv_id%>&mode=0'>Packages that use: (<%=pkgInfoHash.Item("pkg_name")%>)</option>
6126 dpurdie 286
 
5948 dpurdie 287
        <option disabled="disabled">SDKs</option>
5947 dpurdie 288
        <option value='UsedBySDKSummary.asp?pv_id=<%=parPv_id%>&mode=2'>SDKs that use: (<%=pkgInfoHash.Item("pkg_name")%>&nbsp;<%=pkgInfoHash.Item("pkg_version")%>)</option>
289
        <option value='UsedBySDKSummary.asp?pv_id=<%=parPv_id%>&mode=1'>SDKs that use: (<%=pkgInfoHash.Item("pkg_name")%><%=pkgInfoHash.Item("v_ext")%>)</option>
290
        <option value='UsedBySDKSummary.asp?pv_id=<%=parPv_id%>&mode=0'>SDKs that use: (<%=pkgInfoHash.Item("pkg_name")%>)</option>
6126 dpurdie 291
 
292
        <option disabled="disabled">SBOMS</option>
293
        <option value='UsedBySBOMSummary.asp?pv_id=<%=parPv_id%>&mode=2'>SBOMs that use: (<%=pkgInfoHash.Item("pkg_name")%>&nbsp;<%=pkgInfoHash.Item("pkg_version")%>)</option>
294
        <option value='UsedBySBOMSummary.asp?pv_id=<%=parPv_id%>&mode=1'>SBOMs that use: (<%=pkgInfoHash.Item("pkg_name")%><%=pkgInfoHash.Item("v_ext")%>)</option>
295
        <option value='UsedBySBOMSummary.asp?pv_id=<%=parPv_id%>&mode=0'>SBOMs that use: (<%=pkgInfoHash.Item("pkg_name")%>)</option>
296
 
5947 dpurdie 297
    </select>
298
    <DIV class="form_item" id="EXTENDED" style="display:none;"><%=enumLOADING%></DIV>
5927 dpurdie 299
    <p>
300
    <div class="rep_small">NOTE: Versions in <SPAN class="err_alert">RED</SPAN> are different from <%=pkgInfoHash.Item("pkg_name") &" "& pkgInfoHash.Item("pkg_version")%></span>
301
    <br>
5932 dpurdie 302
<%End If%>