Subversion Repositories DevTools

<%
'===================================================================
'                                                       Product Common
'===================================================================
%>
<!--#include file="../class/classTemplateManager.asp"-->
<!--#include file="../class/classCrumbs.asp"-->
<!--#include file="../class/classTabControl.asp"-->
<!--#include file="../class/classActionButtonControl.asp"-->
<!--#include file="../class/classPopupMenuControl.asp"-->
<!--#include file="../class/classFormater.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
Dim objTabControl
Dim objTemplateManager
Dim objProdCollector
Dim objBomCollector
Dim objBtnControl
Dim objFormater
Dim aTabBtnsDef
'------------ CONSTANTS DECLARATION -----------
Const LIMG_PRODUCT = "<img src='icons/i_product.gif' width='19' height='19' border='0' hspace='2' align='absmiddle'>"
Const LIMG_PROCESS = "<img src='icons/i_process.gif' width='15' height='14' border='0' hspace='2' align='absmiddle'>"
Const LIMG_EDIT = "<img src='icons/i_edit.gif' width='16' height='16' border='0' hspace='2'>"
Const LIMG_REMOVE = "<img src='icons/i_remove.gif' width='16' height='16' border='0' hspace='2'>"
Const LIMG_EMAIL = "<img src='icons/i_email.gif' width='15' height='10' border='0' hspace='2' align='absmiddle' vspace='3'>"
Const LIMG_UPDATED = "<img src='icons/i_updated.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Updated'>"
Const LIMG_ADDED = "<img src='icons/i_added.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Added'>"
Const LIMG_REMOVED = "<img src='icons/i_removed.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Removed'>"
'------------ VARIABLE INIT -------------------
Set objFormater = New Formater
Set objCrumbs = New Crumbs
Set objPMod = New PersistanceModule
Set objProdCollector = CreateObject("Scripting.Dictionary")
Set objBomCollector = CreateObject("Scripting.Dictionary")
Set objBtnControl = New ActionButtonControl
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'------------ RUN BEFORE PAGE RENDER ----------
Call GetMainDBParameters ( dbPARproj_id, dbPARbranch_id, dbPARbom_id, dbPARnode_id, dbPARos_id, dbPARprod_id )
Call InitialiseCrumbs ( objCrumbs )
objPMod.PersistInCookie ("bom_browser")
objPMod.PersistInCookie ("user_bar")
objPMod.PersistInQryString ( aPersistList(enumPAR_BOM_ID) )
objPMod.PersistInQryString ( aPersistList(enumPAR_OS_ID) )
objPMod.PersistInQryString ( aPersistList(enumPAR_PROD_ID) )
Call GetBomDetails ( dbPARbom_id, objBomCollector )
Call GetProdDetails ( dbPARprod_id, objProdCollector )
'----------------------------------------------
%>
<%
'-----------------------------------------------------------------------------------------------------------------
Sub GetProdDetails ( nProd_id, ByRef outobjDetails )
        Dim rsQry, query
        OraDatabase.Parameters.Add "PROD_ID", nProd_id, ORAPARM_INPUT, ORATYPE_NUMBER 
        
        '-- Get Product Details --
        query = _
                " SELECT pv.pv_id, "&_
                "        pkg.pkg_name,"&_
                "            pv.pkg_version,"&_
                "            pv.pkg_id,"&_
                "            pv.v_ext,"&_
                "            pv.last_pv_id,"&_
                "            pv.DLOCKED,  "&_
                "                pd.IS_REJECTED"&_
                "   FROM PACKAGES pkg, PACKAGE_VERSIONS pv,  "&_
                "                PRODUCT_DETAILS pd"&_
                "  WHERE pv.pkg_id = pkg.pkg_id  "&_
                "        AND pd.PROD_ID (+) = pv.PV_ID"&_
                "    AND pv.pv_id = :PROD_ID"
        
        Set rsQry = OraDatabase.DbCreateDynaset( query , ORADYN_DEFAULT )
        
        If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) Then
                outobjDetails.Item ("pv_id")   = rsQry("pv_id")
                outobjDetails.Item ("pkg_id")   = rsQry("pkg_id")
                outobjDetails.Item ("pkg_name") = rsQry("pkg_name")
                outobjDetails.Item ("pkg_version") = rsQry("pkg_version")
                outobjDetails.Item ("last_pv_id")   = rsQry("last_pv_id")
                outobjDetails.Item ("v_ext")   = rsQry("v_ext")
                outobjDetails.Item ("dlocked") = rsQry("dlocked")
                outobjDetails.Item ("is_rejected") = rsQry("is_rejected")
                
        Else
                Err.Raise 8, "Sub GetProdDetails", "Empty record set returned. nProd_id="& nProd_id
                
        End If
        
        
        '-- Get Rtag_id --
        OraDatabase.Parameters.Add "BRANCH_ID", dbPARbranch_id, ORAPARM_INPUT, ORATYPE_NUMBER 
        Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseManagerVtreeRtagId.sql") , ORADYN_DEFAULT )
        
        If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) Then
                outobjDetails.Item ("rtag_id")   = rsQry("rtag_id")
                
        Else
                Err.Raise 8, "Sub GetProdDetails", "Empty record set returned. dbPARbranch_id="& dbPARbranch_id
                
        End If
        
        
        OraDatabase.Parameters.Remove "PROD_ID"
        OraDatabase.Parameters.Remove "BRANCH_ID"
        rsQry.Close
        Set rsQry = Nothing
End Sub
'-----------------------------------------------------------------------------------------------------------------
Sub RenderTitle ( objCollector )
        Response.write "<b>"& objCollector.Item("pkg_name") &" "& objCollector.Item("pkg_version") &"</b>"
End Sub
'-----------------------------------------------------------------------------------------------------------------
%>