Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
5357 dpurdie 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
Option explicit
4 
Response.Expires = 0	' always load the page, dont store
5 
%>
6 
<%
7 
'=====================================================
8 
'			VERSIONS HISTORY - RUNTIME
9 
'=====================================================
10 
%>
11 
<!--#include file="common/conf.asp"-->
12 
<!--#include file="common/globals.asp"-->
13 
<!--#include file="common/formating.asp"-->
14 
<!--#include file="common/qstr.asp"-->
15 
<!--#include file="common/common_subs.asp"-->
16 
<!--#include file="_tabs.asp"-->
17 
<!--#include file="_wform_versions_history_main.asp"-->
18 
<!--#include file="common/_popup_window_common.asp"-->
19 
<%
20 
'------------ ACCESS CONTROL ------------------
21 
%>
22 
<!--#include file="_access_control_general.asp"-->
23 
<%
24 
'------------ Variable Definition -------------
25 
Dim rsSQL
26 
'------------ Constants Declaration -----------
27 
'------------ Variable Init -------------------
28 
'----------------------------------------------
29 
%>
30 
<%
31 
'-----------------------------------------------------------------------------------------------------------------------------------
32 
Function DBGet_Runtime_Dependencies ( nPv_id )
33 
	DBGet_Runtime_Dependencies = _
34 
	"   SELECT pv.pv_id, pv.pkg_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments,"&_
35 
	"	       rtd.rtd_url, rtd.mod_date, usr.full_name, usr.user_email"&_
36 
	"	  FROM RUNTIME_DEPENDENCIES rtd, PACKAGES pkg, PACKAGE_VERSIONS pv, USERS usr"&_
37 
	"	 WHERE rtd.rtd_id = pv.pv_id"&_
38 
	"	   AND pv.pkg_id = pkg.pkg_id"&_
39 
	"	   AND rtd.mod_user = usr.user_id"&_
40 
	"	   AND rtd.pv_id = "& nPv_id &_
41 
	"	ORDER BY UPPER(pkg.pkg_name)"
42 
End Function
43 
'-----------------------------------------------------------------------------------------------------------------------------------
44 
%>
45 
<!--#include file="_menu_def.asp"-->
46 
<html>
47 
<head>
48 
<title>Release Manager</title>
49 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
50 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
51 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
52 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
53 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
54 
<script language="JavaScript" src="images/common.js"></script>
55 
<!--#include file="_jquery_includes.asp"-->
56 
</head>
5933 dpurdie 57 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();setLayerHeight();scrollToPvId();">
5357 dpurdie 58 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
59 
  <tr>
60 
    <td width="1%" background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
61 
    <td width="100%" valign="top" background="images/bg_lght_gray.gif">
62 
	  <!--#include file="_version_browser.asp"-->
63 
    </td>
64 
  </tr>
65 
  <tr>
66 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="300"></td>
67 
    <td valign="top">
68 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
69 
        <tr>
70 
          <td align="right" background="images/bg_lght_gray.gif"><br>
71 
            <!-- TABS ------------------------------------------->
72 
            <%
73 
			If IsEmpty( Request("pv_id") ) Then
74 
				Call Generate_Tab_Menu ( TABarray5D, Empty, "blue" )
75 
			Else
76 
				Call Generate_Tab_Menu ( TABarray5, "Runtime", "blue" )
77 
			End If
78 
			%>
79 
            <!------------------------------------------------------------->
80 
          </td>
81 
        </tr>
82 
        <tr>
83 
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
84 
        </tr>
85 
      </table>
86 
	  <!----------------------------------------------  DETAILS --------------------------------------------------->
87 
	  <%If NOT IsEmpty( Request("pv_id") ) Then%>
88 
      <table width="100%" border="0" cellspacing="0" cellpadding="10">
89 
        <tr>
90 
          <td>
91 
		  <div id="LayerDetails" style="height: 350px; overflow: auto;" name="LayerDetails">
92 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
93 
                <tr>
94 
				  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Product&nbsp;&nbsp;</td>
95 
                  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Versions&nbsp;&nbsp;</td>
96 
                  <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Comments&nbsp;&nbsp;</td>
97 
                  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">URL</td>
98 
				  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Added</td>
99 
                </tr>
100 
				<%Set rsSQL = OraDatabase.DbCreateDynaset( DBGet_Runtime_Dependencies ( parPv_id ), cint(0))%>
101 
				<%If rsSQL.RecordCount < 1 Then%>
102 
				<tr>
103 
				  <td background="images/bg_form_lightgray.gif">&nbsp;</td>
104 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
105 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
106 
				  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
107 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
108 
                </tr>
109 
				<%End If%>
110 
				<%While (NOT rsSQL.BOF) AND (NOT rsSQL.EOF)%>
111 
                <tr>
112 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsSQL("pkg_name")%></td>
113 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsSQL("pkg_version")%></td>
114 
				  <td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=NewLine_To_BR ( To_HTML( rsSQL("rtd_comments") ) )%></td>
115 
				  <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsSQL("rtd_url")) Then Response.write "<a href='http://"& rsSQL("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsSQL("rtd_url") &"'></a>"%></td>
5632 dpurdie 116 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=DisplayDate ( rsSQL("mod_date") )%> by <a href="mailto:<%=rsSQL("user_email")%>" class="txt_linked"><%=rsSQL("full_name")%></a></td>
5357 dpurdie 117 
                </tr>
118 
				<%rsSQL.MoveNext
119 
				  WEnd%>
120 
              </table>
121 
            </div>
122 
		  </td>
123 
        </tr>
124 
      </table>
125 
	  <%End If%>
126 
	  <!----------------------------------------------  END DETAILS --------------------------------------------------->
127 
	  </td>
128 
  </tr>
129 
  <tr>
130 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
131 
    <td background="images/lbox_bg_blue.gif"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
132 
  </tr>
133 
</table>
134 
</body>
135 
</html>
136 
<!-- DESTRUCTOR ------->
119 ghuddy 137 
<!--#include file="common/destructor.asp"-->