Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
Option explicit
4 
Response.Expires = 0	' always load the page, dont store
5 
%>
6 
<%
7 
'=====================================================
8 
'			VERSIONS HISTORY - PATCHES
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_Patches ( nPv_id )
33 
	DBGet_Patches = _
34 
	"   SELECT pv.pkg_version, pv.dlocked, pv.modified_stamp, usr.full_name,"&_
35 
	"	       usr.user_email, pv.pv_id, pv.comments"&_
36 
	"	  FROM PACKAGE_PATCHES pp, PACKAGE_VERSIONS pv, USERS usr"&_
37 
	"	 WHERE pp.patch_id = pv.pv_id"&_
38 
	"	   AND pv.modifier_id = usr.user_id"&_
39 
	"	   AND pp.pv_id = "& nPv_id &_
40 
	"	ORDER BY pv.modified_stamp"
41 
End Function
42 
'-----------------------------------------------------------------------------------------------------------------------------------
43 
%>
44 
<!--#include file="_menu_def.asp"-->
45 
<html>
46 
<head>
47 
<title>Release Manager</title>
48 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
49 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
50 
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
51 
<link rel="stylesheet" href="images/navigation.css" type="text/css">
52 
<script language="JavaScript" src="images/common.js"></script>
53 
<script language="JavaScript" type="text/JavaScript">
54 
<!--
55 
function setLayerHeight () {
56 
	var h = screen.height;
57 
	MM_findObj("LayerDetails").style.height = (h-300)/2 +"px";
58 
	MM_findObj("LayerVersions").style.height = (h-300)/2 +"px";
59 
}
60 
//-->
61 
</script>
62 
</head>
63 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();setLayerHeight();">
64 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
65 
  <tr>
66 
    <td width="1%" background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
67 
    <td width="100%" valign="top" background="images/bg_lght_gray.gif">
68 
	  <!--#include file="_version_browser.asp"-->
69 
    </td>
70 
  </tr>
71 
  <tr>
72 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="300"></td>
73 
    <td valign="top">
74 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
75 
        <tr>
76 
          <td align="right" background="images/bg_lght_gray.gif"><br>
77 
            <!-- TABS ------------------------------------------->
78 
            <%
79 
			If IsEmpty( Request("pv_id") ) Then
80 
				Call Generate_Tab_Menu ( TABarray5D, Empty, "blue" )
81 
			Else
82 
				Call Generate_Tab_Menu ( TABarray5, "Patches", "blue" )
83 
			End If
84 
			%>
85 
            <!------------------------------------------------------------->
86 
          </td>
87 
        </tr>
88 
        <tr>
89 
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
90 
        </tr>
91 
      </table>
92 
	  <!----------------------------------------------  DETAILS --------------------------------------------------->
93 
	  <%If NOT IsEmpty( Request("pv_id") ) Then%>
94 
      <table width="100%" border="0" cellspacing="0" cellpadding="10">
95 
        <tr>
96 
          <td>
97 
		  <div id="LayerDetails" style="height: 350px; overflow: auto;" name="LayerDetails">
98 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
99 
                <tr>
100 
				  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
101 
				  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version&nbsp;&nbsp;</td>
102 
                  <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Reason for this version&nbsp;&nbsp;</td>
103 
                  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Release Date</td>
104 
                </tr>
105 
				<%Set rsSQL = OraDatabase.DbCreateDynaset( DBGet_Patches ( parPv_id ), cint(0))%>
106 
				<%If rsSQL.RecordCount < 1 Then%>
107 
				<tr>
108 
				  <td background="images/bg_form_lightgray.gif">&nbsp;</td>
109 
				  <td background="images/bg_form_lightgray.gif">&nbsp;</td>
110 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
111 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
112 
                </tr>
113 
				<%End If%>
114 
				<%While (NOT rsSQL.BOF) AND (NOT rsSQL.EOF)%>
115 
				<%
116 
				anchorName = "ANC_"& rsSQL("pv_id")
117 
				' Because this is a patch link, make sure it is transfered to release notes tab
118 
				URLstring = "_wform_versions_history_release_notes.asp?"& Persists_Query_String( "pv_id="& rsSQL("pv_id") &"&filter_reset=true" ) &"#"& anchorName
119 
				%>
120 
                <tr>
121 
				  <td background="images/bg_form_lightgray.gif"><%If rsSQL("dlocked") = "Y" Then%><%=IMG_OFFICIAL%><%Else%><%=IMG_NOT_OFFICIAL%><%End If%></td>
122 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item"><a href="<%=URLstring%>" class="txt_linked"><%=rsSQL("pkg_version")%></a></td>
123 
				  <td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=NewLine_To_BR ( To_HTML( rsSQL("comments") ) )%></td>
124 
                  <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If rsSQL("dlocked") = "Y" Then%><%=EuroDate ( rsSQL("modified_stamp") )%> by <a href="mailto:<%=rsSQL("user_email")%>" class="txt_linked"><%=rsSQL("full_name")%></a><%End If%></td>
125 
                </tr>
126 
				<%rsSQL.MoveNext
127 
				  WEnd%>
128 
              </table>
129 
            </div>
130 
		  </td>
131 
        </tr>
132 
      </table>
133 
	  <%End If%>
134 
	  <!----------------------------------------------  END DETAILS --------------------------------------------------->
135 
	  </td>
136 
  </tr>
137 
  <tr>
138 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
139 
    <td background="images/lbox_bg_blue.gif"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
140 
  </tr>
141 
</table>
142 
</body>
143 
</html>
144 
 
145 
<!-- DESTRUCTOR ------->
146 
<!--#include file="common/destructor.asp"-->