Subversion Repositories DevTools

Rev

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

Rev 15 Rev 5355
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
'=====================================================
 3 
'=====================================================
4 
'|                                                   |
 4 
'|                                                   |
5 
'|			          OSDefault					 	 |
 5 
'|			          OSDefault					 	 |
6 
'|                                                   |
 6 
'|                                                   |
7 
'=====================================================
 7 
'=====================================================
8 
%>
 8 
%>
9 
<%
 9 
<%
10 
Option explicit
 10 
Option explicit
11 
Response.Expires = 0
 11 
Response.Expires = 0
12 
%>
 12 
%>
13 
<!--#include file="common/config.asp"-->
 13 
<!--#include file="common/config.asp"-->
14 
<!--#include file="common/common_subs.asp"-->
 14 
<!--#include file="common/common_subs.asp"-->
15 
<%
 15 
<%
16 
'------------ VARIABLE DEFINITION -------------
 16 
'------------ VARIABLE DEFINITION -------------
17 
Dim bom_version, bom_lifecycle,sbom
 17 
Dim bom_version, bom_lifecycle,sbom
18 
Dim bom_id
 18 
Dim bom_id
19 
Dim os_id
 19 
Dim os_id
20 
Dim pos, pos2, pos3, pos4
 20 
Dim pos, pos2, pos3, pos4
21 
Dim rsQry, rsPD
 21 
Dim rsQry, rsPD
22 
'------------ CONSTANTS DECLARATION -----------
 22 
'------------ CONSTANTS DECLARATION -----------
23 
'------------ VARIABLE INIT -------------------
 23 
'------------ VARIABLE INIT -------------------
24 
sbom = Request("sbom")
 24 
sbom = Request("sbom")
25 
'------------ CONDITIONS ----------------------
 25 
'------------ CONDITIONS ----------------------
26 
'----------------------------------------------
 26 
'----------------------------------------------
27 
%>
 27 
%>
28 
 
 28 
 
29 
 
 29 
 
30 
<html>
 30 
<html>
31 
<head>
 31 
<head>
32 
<title>Deployment Manager</title>
 32 
<title>Deployment Manager</title>
33 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
 33 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
34 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 34 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
35 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
 35 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
36 
<script language="JavaScript" src="scripts/common.js"></script>
 36 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
37 
 
 37 
<script language="JavaScript" src="scripts/common.js"></script>
38 
<style type="text/css">
 38 
 
39 
<!--
 39 
<style type="text/css">
40 
.style1 {color: #0000FF}
 40 
<!--
41 
.style2 {
 41 
.style1 {color: #0000FF}
42 
	font-size: 14px;
 42 
.style2 {
43 
	font-weight: bold;
 43 
	font-size: 14px;
44 
}
 44 
	font-weight: bold;
45 
-->
 45 
}
46 
</style>
 46 
-->
47 
</head>
 47 
</style>
48 
 
 48 
</head>
49 
<body leftmargin="0" topmargin="0">
 49 
 
50 
 
 50 
<body leftmargin="0" topmargin="0">
51 
<%
 51 
 
52 
	OraDatabase.Parameters.Add "NODE_NAME", 		Request("node"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
52 
<%
53 
	OraDatabase.Parameters.Add "PROJ_NAME", 		Request("project"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
53 
	OraDatabase.Parameters.Add "NODE_NAME", 		Request("node"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
54 
	OraDatabase.Parameters.Add "BRANCH_NAME", 		Request("release"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
54 
	OraDatabase.Parameters.Add "PROJ_NAME", 		Request("project"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
55 
	OraDatabase.Parameters.Add "BOM_VERSION", 		Request("version"),		ORAPARM_INPUT, ORATYPE_NUMBER
 55 
	OraDatabase.Parameters.Add "BRANCH_NAME", 		Request("release"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
56 
	OraDatabase.Parameters.Add "BOM_LIFECYCLE", 	Request("lifecycle"),		ORAPARM_INPUT, ORATYPE_NUMBER
56 
	OraDatabase.Parameters.Add "BOM_VERSION", 		Request("version"),		ORAPARM_INPUT, ORATYPE_NUMBER
57 
	OraDatabase.Parameters.Add "OS_NAME", 			Request("os"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
57 
	OraDatabase.Parameters.Add "BOM_LIFECYCLE", 	Request("lifecycle"),		ORAPARM_INPUT, ORATYPE_NUMBER
58 
 
 58 
	OraDatabase.Parameters.Add "OS_NAME", 			Request("os"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
59 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
 59 
 
60
60 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
61 
If rsQry.Recordcount > 0 Then
61
62 
%>
62 
If rsQry.Recordcount > 0 Then
63 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
 63 
%>
64 
  <tr>
 64 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
65 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
 65 
  <tr>
66 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
 66 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
67 
  </tr>
67 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
68 
   <tr>
 68 
  </tr>
69 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 69 
   <tr>
70 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
 70 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
71 
	<td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 71 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
72 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
72 
	<td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
73 
 </tr>
73 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
74 
<%
 74 
 </tr>
75 
Else
 75 
<%
76 
Response.Write("No Patches Found For "&Request("node")&".")
 76 
Else
77 
End If
 77 
Response.Write("No Patches Found For "&Request("node")&".")
78 
		While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 78 
End If
79 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
79 
		While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
80 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
80 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
81 
%>
81 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
82 
  <tr>
 82 
%>
83 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
 83 
  <tr>
84 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
 84 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
85 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
 85 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
86 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
86 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
87 
  </tr>
 87 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
88 
<%
88 
  </tr>
89 
	OraDatabase.Parameters.Remove "PV_ID"
89 
<%
90 
		rsPD.Close()
 90 
	OraDatabase.Parameters.Remove "PV_ID"
91 
		Set rsPD = nothing
 91 
		rsPD.Close()
92 
		rsQry.MoveNext
92 
		Set rsPD = nothing
93 
		WEnd
93 
		rsQry.MoveNext
94 
	OraDatabase.Parameters.Remove "OS_NAME"
94 
		WEnd
95 
	OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
95 
	OraDatabase.Parameters.Remove "OS_NAME"
96 
	OraDatabase.Parameters.Remove "BOM_VERSION"
96 
	OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
97 
	OraDatabase.Parameters.Remove "RBANCH_NAME"
97 
	OraDatabase.Parameters.Remove "BOM_VERSION"
98 
	OraDatabase.Parameters.Remove "PROJ_NAME"
98 
	OraDatabase.Parameters.Remove "RBANCH_NAME"
99 
	OraDatabase.Parameters.Remove "NODE_NAME"
99 
	OraDatabase.Parameters.Remove "PROJ_NAME"
100
100 
	OraDatabase.Parameters.Remove "NODE_NAME"
101 
		rsQry.Close()
 101
102 
		Set rsQry = nothing
 102 
		rsQry.Close()
103 
%>
 103 
		Set rsQry = nothing
104 
</table>
 104 
%>
105 
</body>
 105 
</table>
106 
</html>
 106 
</body>
107 
<%
 107 
</html>
108 
'------------ RUN AFTER PAGE RENDER -----------
 108 
<%
109 
 
 109 
'------------ RUN AFTER PAGE RENDER -----------
110 
 
 110 
 
111 
'----------------------------------------------
 111 
 
- 
 
 112 
'----------------------------------------------
112 
%>
 113 
%>
113 

            114