Subversion Repositories DevTools

Rev

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

Rev 119 Rev 121
Line 20... Line 20...
20
<!--#include file="_access_control_general.asp"-->
20
<!--#include file="_access_control_general.asp"-->
21
<%
21
<%
22
'------------ Variable Definition -------------
22
'------------ Variable Definition -------------
23
Dim parPkg_id
23
Dim parPkg_id
24
Dim parPkg_name
24
Dim parPkg_name
25
Dim parRfield
-
 
26
Dim parPv_id
25
Dim parPv_id
27
Dim rsLatest
26
Dim rsLatest
28
Dim parHidePatches
27
Dim parHidePatches
29
Dim aVersions
28
Dim aVersions
30
Dim lastRow, i
29
Dim lastRow, i
31
Dim objSortHelper
30
Dim objSortHelper
32
'------------ Constants Declaration -----------
31
'------------ Constants Declaration -----------
33
'------------ Variable Init -------------------
32
'------------ Variable Init -------------------
34
parPkg_id = QStrPar("pkg_id")
33
parPkg_id = QStrPar("pkg_id")
35
parPkg_name = QStrPar("pkg_name")
34
parPkg_name = QStrPar("pkg_name")
36
parRfield = QStrPar("rfield")
-
 
37
If Request("pv_id") <> "" Then
35
If Request("pv_id") <> "" Then
38
	parPv_id = Request("pv_id")
36
	parPv_id = Request("pv_id")
39
Else
37
Else
40
	parPv_id = -1 
38
	parPv_id = -1
41
End If	
39
End If
42
parHidePatches = Request("hidepatches")
40
parHidePatches = Request("hidepatches")
43
'----------------------------------------------
41
'----------------------------------------------
44
%>
42
%>
45
<%
43
<%
46
Sub Get_Pkg_Info_From_Rel ( SSrtag_id, SSpv_id )
44
Sub Get_Pkg_Info_From_Rel ( SSrtag_id, SSpv_id )
47
	Dim rsTemp, Query_String
45
	Dim rsTemp, Query_String
48
	
46
 
49
	Query_String = _
47
	Query_String = _
50
	" SELECT pkg.pkg_name, pv.pkg_version, gr.group_id"&_
48
	" SELECT pkg.pkg_name, pv.pkg_version, gr.group_id"&_
51
	"  FROM PACKAGES pkg, package_versions pv, release_content rc, GROUPS gr"&_
49
	"  FROM PACKAGES pkg, package_versions pv, release_content rc, GROUPS gr"&_
52
	" WHERE     pkg.pkg_id = pv.pkg_id"&_
50
	" WHERE     pkg.pkg_id = pv.pkg_id"&_
53
	"        AND pv.pv_id = rc.pv_id"&_
51
	"        AND pv.pv_id = rc.pv_id"&_
54
	"        AND gr.group_id = rc.group_id"&_
52
	"        AND gr.group_id = rc.group_id"&_
55
	"        AND rc.rtag_id = "& SSrtag_id &_
53
	"        AND rc.rtag_id = "& SSrtag_id &_
56
	"        AND rc.pv_id = "& SSpv_id
54
	"        AND rc.pv_id = "& SSpv_id
57
	
55
 
58
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
56
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
59
	
57
 
60
	If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
58
	If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
61
		pkgInfoHash.Add "pkg_name", (rsTemp.Fields("pkg_name"))
59
		pkgInfoHash.Add "pkg_name", (rsTemp.Fields("pkg_name"))
62
		pkgInfoHash.Add "pkg_version", (rsTemp.Fields("pkg_version"))
60
		pkgInfoHash.Add "pkg_version", (rsTemp.Fields("pkg_version"))
63
		pkgInfoHash.Add "group_id", (rsTemp.Fields("group_id"))
61
		pkgInfoHash.Add "group_id", (rsTemp.Fields("group_id"))
64
	End If
62
	End If
65
	
63
 
66
	rsTemp.Close
64
	rsTemp.Close
67
	Set rsTemp = nothing
65
	Set rsTemp = nothing
68
End Sub
66
End Sub
69
 
67
 
70
 
68
 
Line 72... Line 70...
72
	Get_Latest_All_Ext = _
70
	Get_Latest_All_Ext = _
73
	" SELECT pv.pkg_version, pv.dlocked,"&_
71
	" SELECT pv.pkg_version, pv.dlocked,"&_
74
	"        DECODE ( pv.pv_id, "& nPv_id &", 'selected', NULL ) AS selected"&_
72
	"        DECODE ( pv.pv_id, "& nPv_id &", 'selected', NULL ) AS selected"&_
75
	"    FROM PACKAGES pkg, package_versions pv"&_
73
	"    FROM PACKAGES pkg, package_versions pv"&_
76
	"   WHERE pkg.pkg_id = pv.pkg_id  AND  pkg.pkg_id = "& NNpkg_id
74
	"   WHERE pkg.pkg_id = pv.pkg_id  AND  pkg.pkg_id = "& NNpkg_id
77
	
75
 
78
	If parHidePatches <> "" Then Get_Latest_All_Ext = Get_Latest_All_Ext &" AND pv.is_patch IS NULL"
76
	If parHidePatches <> "" Then Get_Latest_All_Ext = Get_Latest_All_Ext &" AND pv.is_patch IS NULL"
79
	
77
 
80
	'Get_Latest_All_Ext = Get_Latest_All_Ext &"   ORDER BY pv.v_ext ASC, pv.pkg_version ASC"
78
	'Get_Latest_All_Ext = Get_Latest_All_Ext &"   ORDER BY pv.v_ext ASC, pv.pkg_version ASC"
81
	'Response.write Get_Latest_All_Ext
79
	'Response.write Get_Latest_All_Ext
82
End Function
80
End Function
83
 
81
 
84
'------------------------------------------------------------------------------------------------------------------
82
'------------------------------------------------------------------------------------------------------------------
Line 92... Line 90...
92
  Dim i,j
90
  Dim i,j
93
  Response.Write "<table border=""1"" cellspacing=""0"">"
91
  Response.Write "<table border=""1"" cellspacing=""0"">"
94
  For i = lo to hi
92
  For i = lo to hi
95
    Response.Write "<tr>"
93
    Response.Write "<tr>"
96
    For j = 0 to Ubound(vec,1)
94
    For j = 0 to Ubound(vec,1)
97
      If j = mark then 
95
      If j = mark then
98
        Response.Write "<td bgcolor=""FFFFCC"">"
96
        Response.Write "<td bgcolor=""FFFFCC"">"
99
      Else 
97
      Else
100
        Response.Write "<td>"
98
        Response.Write "<td>"
101
      End If
99
      End If
102
      Response.Write vec(j,i) &  "</td>"
100
      Response.Write vec(j,i) &  "</td>"
103
    Next
101
    Next
104
    Response.Write "</tr>"
102
    Response.Write "</tr>"
Line 115... Line 113...
115
<link rel="stylesheet" href="images/navigation.css" type="text/css">
113
<link rel="stylesheet" href="images/navigation.css" type="text/css">
116
<script language="JavaScript" src="images/tipster.js"></script>
114
<script language="JavaScript" src="images/tipster.js"></script>
117
<script language="JavaScript" src="images/_help_tips.js"></script>
115
<script language="JavaScript" src="images/_help_tips.js"></script>
118
<script language="JavaScript">
116
<script language="JavaScript">
119
<!--
117
<!--
120
function updateParent( ) {
118
function updateParent(cancelled) {
121
	var cv;
-
 
122
	cv = document.NewVersion.FRpkgver.value;
119
	window.opener.updateFields("<%=parPv_id%>","<%=parPkg_id%>",document.NewVersion.FRpkgver.value,cancelled);
123
    window.opener.document.<%=parRfield%>.value = cv;
-
 
124
	window.opener.document.<%=parRfield%>.focus();
-
 
125
    self.close();
120
	self.close();
126
    return false;
121
    return false;
127
}
122
}
128
// -->
123
// -->
129
</script>
124
</script>
130
 
125
 
131
</head>
126
</head>
132
 
127
 
133
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
128
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
134
<form name="NewVersion" >
129
<form name="NewVersion" >
135
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
130
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
136
    <tr> 
131
    <tr>
137
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="22" height="25" hspace="5"></td>
132
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="22" height="25" hspace="5"></td>
138
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;Get Package Version</td>
133
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;Get Package Version</td>
139
      <td background="images/lbox_bg_blue.gif" align="right" width="50%"> 
134
      <td background="images/lbox_bg_blue.gif" align="right" width="50%">
140
        <input type="reset" name="btn" value=" Get " class="form_btn_comp" onClick="return updateParent();">
135
        <input type="reset" name="btn" value=" Get " class="form_btn_comp" onClick="return updateParent(false);">
141
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onClick="self.close()">
136
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onClick="return updateParent(true);">
142
      </td>
137
      </td>
143
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap> 
138
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap>
144
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
139
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
145
    </tr>
140
    </tr>
146
    <tr> 
141
    <tr>
147
      <td height="100%" width="1%">&nbsp;</td>
142
      <td height="100%" width="1%">&nbsp;</td>
148
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif"> 
143
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
149
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
144
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
150
          <tr> 
145
          <tr>
151
            <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
146
            <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
152
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
147
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
153
            <td nowrap width="100%">&nbsp; </td>
148
            <td nowrap width="100%">&nbsp; </td>
154
          </tr>
149
          </tr>
155
          <tr> 
150
          <tr>
156
            <td width="1%">&nbsp;</td>
151
            <td width="1%">&nbsp;</td>
157
            <td width="1%" nowrap class="form_item" background="images/bg_form_lightbluedark.gif"><%=parPkg_name%></td>
152
            <td width="1%" nowrap class="form_item" background="images/bg_form_lightbluedark.gif"><%=parPkg_name%></td>
158
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
153
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif">
159
			<select name="FRpkgver" class="form_item">
154
			<select name="FRpkgver" class="form_item">
160
				<option value=""></option>
155
				<option value=""></option>
161
			<%Set rsLatest = OraDatabase.DbCreateDynaset( Get_Latest_All_Ext( parPkg_id, parPv_id ), cint(0))
156
			<%Set rsLatest = OraDatabase.DbCreateDynaset( Get_Latest_All_Ext( parPkg_id, parPv_id ), cint(0))
162
			
157
 
163
			If rsLatest.RecordCount > 0 Then
158
			If rsLatest.RecordCount > 0 Then
164
				
159
 
165
				aVersions = rsLatest.GetRows()
160
				aVersions = rsLatest.GetRows()
166
				lastRow = UBound( aVersions, 2 )
161
				lastRow = UBound( aVersions, 2 )
167
				
162
 
168
				Set objSortHelper = New SortHelper
163
				Set objSortHelper = New SortHelper
169
				
164
 
170
				' Sort versions
165
				' Sort versions
171
				Call objSortHelper.VersionSort( aVersions, 0, lastRow, rsLatest.FieldIndex("pkg_version") )
166
				Call objSortHelper.VersionSort( aVersions, 0, lastRow, rsLatest.FieldIndex("pkg_version") )
172
				
167
 
173
				' Descending order
168
				' Descending order
174
				For i = lastRow To 0 Step -1
169
				For i = lastRow To 0 Step -1
175
				%>
170
				%>
176
					<option value="<%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%>" <%=aVersions( rsLatest.FieldIndex("selected"), i )%>><%If aVersions( rsLatest.FieldIndex("dlocked"), i ) = "Y" Then%>R&nbsp;<%Else%>&nbsp;&nbsp;&nbsp;&nbsp;<%End If%><%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%></option>
171
					<option value="<%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%>" <%=aVersions( rsLatest.FieldIndex("selected"), i )%>><%If aVersions( rsLatest.FieldIndex("dlocked"), i ) = "Y" Then%>R&nbsp;<%Else%>&nbsp;&nbsp;&nbsp;&nbsp;<%End If%><%=aVersions( rsLatest.FieldIndex("pkg_version"), i )%></option>
177
				<%
172
				<%
178
				Next
173
				Next
179
				
174
 
180
				Set objSortHelper = nothing
175
				Set objSortHelper = nothing
181
				
176
 
182
			End If
177
			End If
183
			%>
178
			%>
184
			</select>
179
			</select>
185
			</td>
180
			</td>
186
          </tr>
181
          </tr>
187
          <tr> 
182
          <tr>
188
            <td width="1%">&nbsp;</td>
183
            <td width="1%">&nbsp;</td>
189
            <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
184
            <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
190
            <td nowrap width="100%"></td>
185
            <td nowrap width="100%"></td>
191
          </tr>
186
          </tr>
192
		  <tr> 
187
		  <tr>
193
            <td width="1%">&nbsp;</td>
188
            <td width="1%">&nbsp;</td>
194
            <td width="1%" nowrap class="form_field" colspan="2">R = Released</td>
189
            <td width="1%" nowrap class="form_field" colspan="2">R = Released</td>
195
          </tr>
190
          </tr>
196
        </table>
191
        </table>
197
      </td>
192
      </td>
Line 208... Line 203...
208
</body>
203
</body>
209
</html>
204
</html>
210
 
205
 
211
 
206
 
212
<!-- DESTRUCTOR ------->
207
<!-- DESTRUCTOR ------->
213
<!--#include file="common/destructor.asp"-->
-
 
214
208
<!--#include file="common/destructor.asp"-->
-
 
209