Subversion Repositories DevTools

Rev

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

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

            150