WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/web/runtime_dependencies.asp



<%
'------------ Variable Definition -------------
Dim rsTemp
Dim	rsQry
Dim criticalSectionIsEditable
Dim canEdit
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )
canEdit = pkgInfoHash.Item("dlocked") = "N" OR (pkgInfoHash.Item("dlocked") = "R") OR criticalSectionIsEditable
'----------------------------------------------
 
 
Function Get_Runtime_Dependencies ( NNpv_id )
	Get_Runtime_Dependencies = _
	" SELECT rtd.rtd_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url, "&_
	"       rtd.mod_date, usr.full_name, usr.user_email"&_
	"  FROM packages pkg, package_versions pv, runtime_dependencies rtd, users usr"&_

	"   AND rtd.mod_user = usr.user_id"&_
	"   AND rtd.pv_id = "& NNpv_id &_
	" ORDER BY UPPER(pkg.pkg_name) "
End Function
%>
 
<%
'------------------------- MAIN LINE ---------------------------
 
%>
 
<html>
<head>
<title><%=Title(Request("rtag_id"))%></title>
<link rel="shortcut icon" href="<%=FavIcon%>"/>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">

		  </tr>
		  <tr>
		    <td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>
		    <td background="images/lbox_bg_orange.gif">
			<!-- TAB ACTION BUTTONS ------------------------------------->
			<%Call Action_Buttons_State ( "Runtime Dependencies", canEdit )%>
			</td>
		    <td background="images/lbox_bg_orange.gif">&nbsp;</td>
		  </tr>
		  <tr>
		    <td></td>

                            <td background="images/bg_form_lightgray.gif" class="form_item">&nbsp;</td>
                          </tr>
                          <%End If%>
                          <%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
                          <tr>
						    <%If canEdit Then%>
                            	<td align="center" nowrap background="images/bg_form_lightgray.gif"><a href="javascript:;" onClick="MM_openVixIFrame('_wform_update_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>','Update Runtime Dependency')"><img src="images/i_edit.gif" alt="Edit" width="12" height="12" hspace="3" vspace="3" border="0"></a></td>
							<%Else%>
								<td align="center" nowrap background="images/bg_form_lightgray.gif"><img src="images/i_edit_disable.gif" alt="Edit disabled." width="12" height="12" hspace="3" vspace="3" border="0"></td>
							<%End If%>
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_name")%></td>
                            <td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_version")%></td>
                            <td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("rtd_comments")%></td>
							<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsTemp("rtd_url")) Then Response.write "<a href='http://"& rsTemp("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsTemp("rtd_url") &"'></a>"%></td>
							<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=DisplayDate(rsTemp("mod_date"))%> by <%=emailField(enum_imgUser & rsTemp("full_name") ,rsTemp("user_email"))%></td>
							<%If canEdit  Then%>
                            	<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><a href="_remove_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>" onClick="return vixConfirmDelete('this Runtime Dependency');"><img src="images/i_delete.gif" alt="Remove from list." width="13" height="12" hspace="3" border="0"></a></td>
							<%Else%>
								<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><img src="images/i_delete_disable.gif" alt="Remove disabled." width="13" height="12" hspace="3" border="0"></td>
							<%End If%>
                          </tr>

Rev 6612	Rev 6788
Line 28...	Line 28...
28	`<%`	28	`<%`
29	`'------------ Variable Definition -------------`	29	`'------------ Variable Definition -------------`
30	`Dim rsTemp`	30	`Dim rsTemp`
31	`Dim rsQry`	31	`Dim rsQry`
32	`Dim criticalSectionIsEditable`	32	`Dim criticalSectionIsEditable`
-		33	`Dim canEdit`
33	`'------------ Constants Declaration -----------`	34	`'------------ Constants Declaration -----------`
34	`'------------ Variable Init -------------------`	35	`'------------ Variable Init -------------------`
-		36	`criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )`
-		37	`canEdit = pkgInfoHash.Item("dlocked") = "N" OR (pkgInfoHash.Item("dlocked") = "R") OR criticalSectionIsEditable`
35	`'----------------------------------------------`	38	`'----------------------------------------------`
36	`%>`	-
37	`<%`	-
38	`Function Get_Runtime_Dependencies ( NNpv_id )`	39	`Function Get_Runtime_Dependencies ( NNpv_id )`
39	`Get_Runtime_Dependencies = _`	40	`Get_Runtime_Dependencies = _`
40	`" SELECT rtd.rtd_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url, "&_`	41	`" SELECT rtd.rtd_id, pkg.pkg_name, pv.pkg_version, rtd.rtd_comments, rtd.rtd_url, "&_`
41	`" rtd.mod_date, usr.full_name, usr.user_email"&_`	42	`" rtd.mod_date, usr.full_name, usr.user_email"&_`
42	`" FROM packages pkg, package_versions pv, runtime_dependencies rtd, users usr"&_`	43	`" FROM packages pkg, package_versions pv, runtime_dependencies rtd, users usr"&_`
Line 45...	Line 46...
45	`" AND rtd.mod_user = usr.user_id"&_`	46	`" AND rtd.mod_user = usr.user_id"&_`
46	`" AND rtd.pv_id = "& NNpv_id &_`	47	`" AND rtd.pv_id = "& NNpv_id &_`
47	`" ORDER BY UPPER(pkg.pkg_name) "`	48	`" ORDER BY UPPER(pkg.pkg_name) "`
48	`End Function`	49	`End Function`
49	`%>`	50	`%>`
50		-
51	`<%`	51	`<%`
52	`'------------------------- MAIN LINE ---------------------------`	52	`'------------------------- MAIN LINE ---------------------------`
53	`criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )`	-
54	`%>`	53	`%>`
55		-
56	`<html>`	54	`<html>`
57	`<head>`	55	`<head>`
58	`<title><%=Title(Request("rtag_id"))%></title>`	56	`<title><%=Title(Request("rtag_id"))%></title>`
59	`<link rel="shortcut icon" href="<%=FavIcon%>"/>`	57	`<link rel="shortcut icon" href="<%=FavIcon%>"/>`
60	`<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">`	58	`<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">`
Line 109...	Line 107...
109	`</tr>`	107	`</tr>`
110	`<tr>`	108	`<tr>`
111	`<td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>`	109	`<td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>`
112	`<td background="images/lbox_bg_orange.gif">`	110	`<td background="images/lbox_bg_orange.gif">`
113	`<!-- TAB ACTION BUTTONS ------------------------------------->`	111	`<!-- TAB ACTION BUTTONS ------------------------------------->`
114	`<%Call Action_Buttons ( "Runtime Dependencies" )%>`	112	`<%Call Action_Buttons_State ( "Runtime Dependencies", canEdit )%>`
115	`</td>`	113	`</td>`
116	`<td background="images/lbox_bg_orange.gif"> </td>`	114	`<td background="images/lbox_bg_orange.gif"> </td>`
117	`</tr>`	115	`</tr>`
118	`<tr>`	116	`<tr>`
119	`<td></td>`	117	`<td></td>`
Line 143...	Line 141...
143	`<td background="images/bg_form_lightgray.gif" class="form_item"> </td>`	141	`<td background="images/bg_form_lightgray.gif" class="form_item"> </td>`
144	`</tr>`	142	`</tr>`
145	`<%End If%>`	143	`<%End If%>`
146	`<%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>`	144	`<%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>`
147	`<tr>`	145	`<tr>`
148	`<%If (pkgInfoHash.Item("dlocked") = "N") OR (pkgInfoHash.Item("dlocked") = "R") Then%>`	146	`<%If canEdit Then%>`
149	`<td align="center" nowrap background="images/bg_form_lightgray.gif"><a href="javascript:;" onClick="MM_openVixIFrame('_wform_update_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>','Update Runtime Dependency')"><img src="images/i_edit.gif" alt="Edit" width="12" height="12" hspace="3" vspace="3" border="0"></a></td>`	147	`<td align="center" nowrap background="images/bg_form_lightgray.gif"><a href="javascript:;" onClick="MM_openVixIFrame('_wform_update_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>','Update Runtime Dependency')"><img src="images/i_edit.gif" alt="Edit" width="12" height="12" hspace="3" vspace="3" border="0"></a></td>`
150	`<%Else%>`	148	`<%Else%>`
151	`<td align="center" nowrap background="images/bg_form_lightgray.gif"><img src="images/i_edit_disable.gif" alt="Edit disabled." width="12" height="12" hspace="3" vspace="3" border="0"></td>`	149	`<td align="center" nowrap background="images/bg_form_lightgray.gif"><img src="images/i_edit_disable.gif" alt="Edit disabled." width="12" height="12" hspace="3" vspace="3" border="0"></td>`
152	`<%End If%>`	150	`<%End If%>`
153	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_name")%></td>`	151	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_name")%></td>`
154	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_version")%></td>`	152	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("pkg_version")%></td>`
155	`<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("rtd_comments")%></td>`	153	`<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=rsTemp("rtd_comments")%></td>`
156	`<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsTemp("rtd_url")) Then Response.write "<a href='http://"& rsTemp("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsTemp("rtd_url") &"'></a>"%></td>`	154	`<td background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%If NOT IsNull(rsTemp("rtd_url")) Then Response.write "<a href='http://"& rsTemp("rtd_url") &"' target='_blank'><img src='images/i_url.gif' width='15' height='15' hspace='3' vspace='3' border='0' alt='"& rsTemp("rtd_url") &"'></a>"%></td>`
157	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=DisplayDate(rsTemp("mod_date"))%> by <%=emailField(enum_imgUser & rsTemp("full_name") ,rsTemp("user_email"))%></td>`	155	`<td nowrap background="images/bg_form_lightgray.gif" class="form_item" valign="top"><%=DisplayDate(rsTemp("mod_date"))%> by <%=emailField(enum_imgUser & rsTemp("full_name") ,rsTemp("user_email"))%></td>`
158	`<%If pkgInfoHash.Item("dlocked") = "N" OR (pkgInfoHash.Item("dlocked") = "R") Then%>`	156	`<%If canEdit Then%>`
159	`<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><a href="_remove_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>" onClick="return vixConfirmDelete('this Runtime Dependency');"><img src="images/i_delete.gif" alt="Remove from list." width="13" height="12" hspace="3" border="0"></a></td>`	157	`<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><a href="_remove_runtime_dependency.asp?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>&rtd_id=<%=rsTemp("rtd_id")%>" onClick="return vixConfirmDelete('this Runtime Dependency');"><img src="images/i_delete.gif" alt="Remove from list." width="13" height="12" hspace="3" border="0"></a></td>`
160	`<%Else%>`	158	`<%Else%>`
161	`<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><img src="images/i_delete_disable.gif" alt="Remove disabled." width="13" height="12" hspace="3" border="0"></td>`	159	`<td align="center" background="images/bg_form_lightgray.gif" class="form_item" valign="top"><img src="images/i_delete_disable.gif" alt="Remove disabled." width="13" height="12" hspace="3" border="0"></td>`
162	`<%End If%>`	160	`<%End If%>`
163	`</tr>`	161	`</tr>`

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/runtime_dependencies.asp – Rev 6612 → 6788