Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>

<%

'=====================================================

'|                                                   |

'|		          RequestProductLocation		 	 |

'|                                                   |

'=====================================================

%>

<%

Option explicit

Response.Expires = 0

%>

<!--#include file="common/globals.asp"-->

<!--#include file="common/config.asp"-->

<!--#include file="common/common_subs.asp"-->

<%

'------------ VARIABLE DEFINITION -------------

Dim rsQry

Dim IsProductInNewBom

Dim bgColor

Dim QueryName

Dim parBomId

Dim objWSH

Dim rsPkg, pkgName, pkgVersion, pkgId

Dim rsProj, projName, branchName

Dim rsOS, OSName

'------------ CONSTANTS DECLARATION -----------

'------------ VARIABLE INIT -------------------

parBomId = Request("bom_id")

'------------ CONDITIONS ----------------------

'----------------------------------------------

%>

<%

'--------------------------------------------------------------------------------------------------------------

'--------------------------------------------------------------------------------------------------------------

%>

<%

'------------ RUN BEFORE PAGE RENDER ----------

'If (Request("change_type") = "R") Then

'	QueryName = "BomRemovedProductLocation.sql"

'	IsProductInNewBom = FALSE

'ElseIf (Request("change_type") = "U") Then

'	QueryName = "BomUpdatedProductLocation.sql"

'	IsProductInNewBom = FALSE

'Else

	QueryName = "BomAddedProductLocation.sql"

'	IsProductInNewBom = TRUE

'End If

'----------------------------------------------

%>

		<table width="100%"  border="0" cellspacing="3" cellpadding="0">

        <tr>

			<td background="images/bg_form_lightgray.gif" nowrap class="body_txt">

			<SPAN id="IMG_EXPAND_PROD_<%=Request("new_prod_id")%>" style="display:block;"><a href="javascript:;" class="menu_link" onClick="RequestProductNotes('?prod_id=<%=Request("prod_id")%>&new_prod_id=<%=request("new_prod_id")%>', '<%=Request("new_prod_id")%>');"><img src="icons/i_plus.gif" border="0" align="absmiddle" hspace="3"><img src="icons/i_product.gif" border="0" align="absmiddle" hspace="3">Product Notes</a></SPAN>							

			<SPAN id="IMG_COLLAPSE_PROD_<%=Request("new_prod_id")%>" style="display:none;"><a href="javascript:;" class="menu_link" onClick="ToggleDisplay( 'PROD_<%=Request("new_prod_id")%>', 'IMG_EXPAND_PROD_<%=Request("new_prod_id")%>', 'IMG_COLLAPSE_PROD_<%=Request("new_prod_id")%>');"><img src="icons/i_minus.gif" border="0" align="absmiddle" hspace="3"><img src="icons/i_product.gif" border="0" align="absmiddle" hspace="3">Product Notes</a></SPAN>

			</td>

		</tr>	

		<tr>

	    	<td nowrap valign="top" class="body_row" colspan="3">

			<DIV id="PROD_<%=Request("new_prod_id")%>" name="PROD_<%=Request("new_prod_id")%>" style="display:none;"><%=enumLOADING%></DIV>

			</td>

	    </tr>	

          <%

		  OraDatabase.Parameters.Add "BOM_ID", 			Request("bom_id"),			ORAPARM_INPUT, ORATYPE_NUMBER 

		  OraDatabase.Parameters.Add "COMPARE_BOM_ID", 	Request("compare_bom_id"),	ORAPARM_INPUT, ORATYPE_NUMBER 

		  OraDatabase.Parameters.Add "PROD_ID",  		Request("prod_id"),		ORAPARM_INPUT, ORATYPE_NUMBER 

		  OraDatabase.Parameters.Add "PKG_ID",  		Request("pkg_id"),		ORAPARM_INPUT, ORATYPE_NUMBER 

		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ( QueryName ), ORADYN_DEFAULT )

		  bgColor = NULL

		  If rsQry.RecordCount < 1 Then

		  %>

		  <tr>

            <td <%=bgColor%> nowrap valign="top" class="body_row" colspan="2">Product not found.

			</td>

          </tr>

		  <%

		  End If

		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)

		  	If IsNull( bgColor ) Then

				bgColor = "bgcolor='#F5F5F5'"

			Else

				bgColor = NULL

			End If

If Request("bom_id") <> "" AND Request("prod_id") <> "" Then

	Set rsPkg = OraDatabase.DbCreateDynaset( "select * from package_versions pv, packages pkg where pv.pv_id = "&Request("new_prod_id")&" and pkg.pkg_id = pv.pkg_id", cint(0))

	pkgName = rsPkg("pkg_name")

	pkgVersion = rsPkg("pkg_version")

	pkgId = rsPkg("pkg_id")

	rsPkg.Close()

	Set rsPkg = nothing

	Set rsProj = OraDatabase.DbCreateDynaset( "select br.branch_name, prj.proj_name from boms bm, branches br, dm_projects prj where bm.bom_id = "&Request("bom_id")&" and br.BRANCH_ID = bm.RTAG_ID_FK and prj.PROJ_ID = br.PROJ_ID", cint(0))

	projName = rsProj("proj_name")	

	branchName = rsProj("branch_name")

	rsProj.Close()

	Set rsProj = nothing

	Set rsOS = OraDatabase.DbCreateDynaset( "select bt.bos_type from os_base_env obe, base_env be, bos_types bt where obe.OS_ID = "&rsQry("os_id")&" and be.BASE_ENV_ID = obe.BASE_ENV_ID and bt.BOS_ID = be.BOS_ID", cint(0))

	OSName = rsOS("bos_type")

	If OSName = "Windows" OR OSName = "MOS" Then

		OSName = "win32"

	Else

		OSName = "sparc"

	End If	

	rsOS.Close()

	Set rsOS = nothing	

End If

		  %>

		  <tr>

            <td <%=bgColor%> nowrap valign="top" class="body_row" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;

			<%'If IsProductInNewBom Then%>

				<img hspace="4" src="icons/<%=rsQry("node_icon")%>" align="absmiddle" border="0"><a href="NodeDefault.asp?node_id=<%=rsQry("node_id")%>&bom_id=<%=parBomId%>" class="body_link"><%=rsQry("node_name")%></a>

				&nbsp;/&nbsp;<a href="OsDefault.asp?os_id=<%=rsQry("os_id")%>&bom_id=<%=parBomId%>" class="body_link"><%=rsQry("os_name") %></a>

				&nbsp;/&nbsp;<%=rsQry("pkg_name") &" "& rsQry("pkg_version")%>

			<%'Else%>

				&nbsp;&nbsp;<a href="LogDownload.asp?url=http://auperaunx26/releases/<%=projName%>/<%=branchName%>/<%=pkgName%>/<%=OSName%>/<%=pkgVersion%>/<%=pkgName%>-<%=pkgVersion%>-<%=OSName%>.zip&pkg_id=<%=pkgId%>&pkg_version=<%=pkgVersion%>"  target="_blank" class="body_link">Download Version: <%=Request("new_version") %></a>&nbsp;&nbsp;

			<%'End If%>

</td>

          </tr>

	  	  <%

		  	rsQry.MoveNext

		  WEnd

		  OraDatabase.Parameters.Remove "BOM_ID"

		  OraDatabase.Parameters.Remove "PROD_ID"

		  OraDatabase.Parameters.Remove "PKG_ID_ID"

		  rsQry.Close

		  Set rsQry = Nothing

		  %>

		</table>	

<%

'------------ RUN AFTER PAGE RENDER -----------

'----------------------------------------------

%><!--#include file="common/globals_destructor.asp"-->