Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
6683 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'   form_export_simple_dependencies.asp
5
'=====================================================
6
%>
7
<%
8
Option explicit
9
' Good idea to set when using redirect
10
Response.Expires = 0	' always load the page, dont store
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="_tabs.asp"-->
18
<%
19
' Make sure rtag_id is always present
20
If Request("pv_id") = "" Then
21
    Call Destroy_All_Objects
22
	Response.Redirect("index.asp")
23
End If
24
%>
25
<%
26
'------------ ACCESS CONTROL ------------------
27
%>
28
<!--#include file="_access_control_login_optional.asp"-->
29
<!--#include file="_access_control_general.asp"-->
30
<%
31
'------------ Variable Definition -------------
32
Dim parPv_id
33
'------------ Constants Declaration -----------
34
'------------ Variable Init -------------------
35
Set pkgInfoHash = CreateObject("Scripting.Dictionary")
36
parPv_id = QStrPar("pv_id")
37
'----------------------------------------------
38
%>
39
<%
40
Function Dependency_List ( NNpv_id )
41
	Dim rsTemp, Query_String, tempSTR
42
	tempSTR = ""
43
 
44
	Query_String = _
45
	" SELECT pkg.pkg_name, pv.pkg_version"&_
46
	"	FROM packages pkg,"&_
47
	"	     package_versions pv,"&_
48
	"	     package_dependencies dep"&_
49
	"	WHERE pv.pkg_id = pkg.pkg_id"&_
50
	"	  AND dep.dpv_id = pv.pv_id"&_
51
	"	  AND dep.pv_id = "& NNpv_id &_
52
	"	ORDER BY UPPER(pkg.pkg_name)"
53
 
54
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
55
 
56
	While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
57
		tempSTR = tempSTR & To_Simple( rsTemp("pkg_name"), rsTemp("pkg_version") ) & VBNewLine
58
		rsTemp.MoveNext
59
	WEnd
60
 
61
	Dependency_List = tempSTR
62
 
63
	rsTemp.Close
64
	Set rsTemp = nothing
65
End Function
66
%>
67
<%
68
Call Get_Pkg_Info ( parPv_id, NULL )
69
%>
70
<%Response.Cookies(COOKIE_RELEASEMANAGER_MEMORY)("devl_environment") = "jats"%>
71
<html>
72
<head>
73
<title>Release Manager</title>
74
<link rel="shortcut icon" href="<%=FavIcon%>"/>
75
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
76
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
77
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
78
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
79
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
80
<!-- TIPS -->
81
<script language="JavaScript" src="images/tipster.js?ver=<%=VixVerNum%>"></script>
82
<script language="JavaScript" src="images/_help_tips.js?ver=<%=VixVerNum%>"></script>
83
<!--#include file="_jquery_includes.asp"-->
84
<!-- DROPDOWN MENUS -->
85
<!--#include file="_menu_def.asp"-->
86
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
87
 
88
</head>
89
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
90
<!-- HEADER -->
91
<!--#include file="_header.asp"-->
92
<!-- BODY ---->
93
<table width="100%" height="80%" border="0" cellpadding="0" cellspacing="0">
94
  <tr>
6874 dpurdie 95
    <td align="center" valign="top" class='bg_grey'>
6683 dpurdie 96
		  <!-- MIDDLE --------------------------------------->
97
		    <table width="650" border="0" cellspacing="0" cellpadding="0">
98
			  <tr> 
99
			    <td> 
100
			      <table width="100%" border="0" cellspacing="0" cellpadding="0">
101
			        <tr> 
102
			          <td width="1%">&nbsp;</td>
103
			          <td align="right"><img src="images/h_trsp_dot.gif" width="30" height="30"></td>
104
			          <td width="1%">&nbsp;</td>
105
			        </tr>
106
			        <tr> 
107
			          <td width="1%">&nbsp;</td>
108
			          <td> 
109
			            <table width="100%" border="0" cellspacing="0" cellpadding="0">
110
			              <tr> 
111
			                <td nowrap class="form_ttl">EXPORT dependencies</td>
112
			                <td align="right" valign="bottom">
113
			                  <%Call Generate_Tab_Menu ( TABarray3, "Simple List", "blue" )%>
114
			                </td>
115
			              </tr>
116
			            </table>
117
			          </td>
118
			          <td width="1%">&nbsp;</td>
119
			        </tr>
120
			        <tr> 
121
			          <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>
122
			          <td background="images/lbox_bg_blue.gif">
123
					    <!-- Heading -->
124
					  	<table width="100%" border="0" cellspacing="0" cellpadding="0">
125
			              <tr> 
126
			                <td nowrap class="lbox_ttl_w"><%=pkgInfoHash.Item ("pkg_name")%>&nbsp;<%=pkgInfoHash.Item ("pkg_version")%></td>
127
							<td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="46"></td>
128
			                <td align="right">
129
							<!-- ACTION BUTTONS ------------------------------------------->
130
							<!------------------------------------------------------------->
131
			                </td>
132
			              </tr>
133
			            </table>
134
			            <!-- END Heading -->
135
			          </td>
136
			          <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>
137
			        </tr>
138
			        <tr> 
139
			          <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>
140
			          <td bgcolor="#FFFFFF" valign="top"> 
141
			            <!-- Body -->
142
			            <table width="100%" border="0" cellspacing="1" cellpadding="2">
143
						<form name="close" method="post" action="dependencies.asp?done=done&hidenv=<%=QSTR_All%>">
144
			                <tr> 
145
			                  <td nowrap width="100%">&nbsp; </td>
146
			                </tr>
147
			                <tr> 
148
			                  <td nowrap width="100%"><span class="form_txt">Copy this dependency export list into your build file to build this package.</span><br><br>
149
			                    <textarea rows="25" cols="100" wrap="OFF" style="width:100%;height:100%" class="form_item" onFocus="this.select()"><%=Dependency_List( parPv_id )%></textarea>
150
								<br><br>
151
								<input type="submit" name="btn" value="  Close  " class="form_btn">
152
								<br><br>
153
			                  </td>
154
			                </tr>
155
						</form>
156
			            </table>
157
					  </td>
158
			          <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
159
			        </tr>
160
			        <tr> 
161
			          <td width="1%" background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>
162
			          <td background="images/lbox_bg_blue.gif"></td>
163
			          <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>
164
			        </tr>
165
			      </table>
166
			    </td>
167
			  </tr>
168
			</table>
169
		<!-- END DETAILS ------------------------------------------------------------->
170
		</td>
171
  </tr>
172
</table>
173
<!-- FOOTER -->
174
<!--#include file="_footer.asp"-->
175
</body>
176
</html>