Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@LANGUAGE="VBSCRIPT"%><%'====================================================='| |'| Bom_History |'| |'=====================================================%><%Option explicitResponse.Expires = 0%><!--#include file="common/globals.asp"--><!--#include file="common/config.asp"--><!--#include file="common/common_subs.asp"--><!--#include file="common/_bom_common.asp"--><%'------------ ACCESS CONTROL ------------------%><!--#include file="_access_control_general.asp"--><%'------------ VARIABLE DEFINITION -------------Dim rsQry'------------ CONSTANTS DECLARATION -----------'------------ VARIABLE INIT -------------------'------------ CONDITIONS ----------------------'----------------------------------------------%><%'------------ RUN BEFORE PAGE RENDER ----------'----------------------------------------------'-----------------------------------------------------------------------------------------------------------------Function UserName (nUserId)If nUserId <> "" ThenDim rsTemp, user_nameSet rsTemp = OraDatabase.DbCreateDynaset( "select * from users where user_id ="&nUserId , ORADYN_DEFAULT )user_name = rsTemp("full_name")rsTemp.Close()Set rsTemp = NothingUserName = user_nameElseUserName = NULLEnd IfEnd Function'-----------------------------------------------------------------------------------------------------------------%><html><head><title>Production Manager</title><meta HTTP-EQUIV="Pragma" CONTENT="no-cache"><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css"><script language="JavaScript" src="scripts/common.js"></script></head><body leftmargin="0" topmargin="0"><!-- HEADER ++++++++++++++++ --><!--#include file="_header.asp"--><!-- +++++++++++++++++++++++ --><!-- MAIN MENU + CRUMBS ++++++++++++++++ --><!--#include file="_main_menu.asp"--><!-- +++++++++++++++++++++++++++++++++++++ --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="1%" valign="top" background="images/bg_bage_0.gif"><!-- NODE BROWSER ++++++++++++++++++++++ --><!--#include file="_bom_browser.asp"--><!-- END OF NODE BROWSER +++++++++++++++ --></td><td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td><td width="100%" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" background="images/bg_green.gif"></td><td align="right" valign="bottom" background="images/bg_green.gif" class="body_txtw"><%Call RenderTitleWithoutVersion( objBomCollector )%></td><td background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="20"></td></tr><tr><td width="1%" valign="top" background="images/bg_green.gif"></td><td width="100%" valign="bottom" background="images/bg_green.gif"><!-- TAB CONTROLS ++++++++++++++++++++++ --><!--#include file="_tabs_definition.asp"--><%Set objTabControl = New TabControlobjTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definitionobjTabControl.TabStyle = "StyleWinXP"objTabControl.AddTabDefnition ( arrBomTabDef )objTabControl.SelectByName("History")objTabControl.Render ()%><!-- END OF TAB CONTROLS +++++++++++++++ --></td><td width="1%" background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="35"></td></tr><tr><td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td><td background="images/bg_bage_0.gif"> </td><td background="images/bg_green.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td></tr><tr><td> </td><td> </td><td valign="top"><%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) = "hide" Then%><a href="<%=SCRIPT_NAME%>?user_bar=<%=enumDEFAULT%>&<%=objPMod.ComposeURL()%>"><img src="icons/b_left.gif" title="Maximize favourits" width="13" height="13" vspace="5" border="0"></a><%End If%></td></tr></table><table width="100%" border="0" cellspacing="10" cellpadding="0"><tr><td><!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><%OraDatabase.Parameters.Add "BOM_ID", dbPARbom_id, ORAPARM_INPUT, ORATYPE_NUMBERSet rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomHistory.sql") , ORADYN_DEFAULT )'Pass record set to RepeaterobjRepeater.RecordSet = rsQry'Define Table Row with bound variablesobjRepeater.Row = _"<tr>"&_" <td bgcolor='#FFFFFF' class='body_smltxtg' nowrap valign='top'>""& <#DATE_TIME_STAMP#> &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#TRAIL_ACTION#> &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#TRAIL_COMMENTS#> ) &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' nowrap valign='top'><a href='mailto:""& <#USER_EMAIL#> &""' class='body_link'>"&_" <img src='icons/i_email.gif' width='15' height='10' hspace='2' border='0' align='absmiddle' title='Send email to ""& <#USER_EMAIL#> &""'>""& <#FULL_NAME#> &""</a></td>"&_"</tr>"%><%Call objRepeater.Navigator ( TRUE, TRUE )%><!-- DATA TABLE ++++++++++++++++++++++++++++++++++++++++++++++ --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td background="images/bg_bage_0a.gif"><table width="100%" border="0" cellspacing="1" cellpadding="3"><tr><td width="1%" background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td><td width="40%" background="images/bg_bage_0.gif" class="body_col" nowrap>Action</td><td width="60%" background="images/bg_bage_0.gif" class="body_col" nowrap>User Comments</td><td width="1%" background="images/bg_bage_0.gif" class="body_col" nowrap>User</td></tr><%objRepeater.RenderDataGrid ()%></table></td></tr></table><%OraDatabase.Parameters.Remove "BOM_ID"rsQry.Close()Set rsQry = Nothing%><%Call objRepeater.Navigator ( FALSE, TRUE )%><br><!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --></td></tr></table><table width="100%" border="0" cellspacing="10" cellpadding="0"><tr><td><!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><%OraDatabase.Parameters.Add "BOM_ID", dbPARbom_id, ORAPARM_INPUT, ORATYPE_NUMBERSet rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseAuthorisationHistory.sql") , ORADYN_DEFAULT )'Pass record set to RepeaterobjRepeater.RecordSet = rsQry'Define Table Row with bound variablesobjRepeater.Row = _"<tr>"&_" <td bgcolor='#FFFFFF' class='body_smltxtg' nowrap valign='top'>""& <#PKG_NAME#> &"" ""& <#PKG_VERSION#> &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#TESTER_DATESTAMP#> &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& UserName( <#TESTER_ID#> ) &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#TESTER_COMMENTS#> ) &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#MANAGER_DATESTAMP#> &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& UserName( <#MANAGER_ID#> ) &""</td>"&_" <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#MANAGER_COMMENTS#> ) &""</td>"&_"</tr>"%><SPAN class="body_colb">BOM - Release Authorisation History</SPAN><%Call objRepeater.Navigator ( TRUE, TRUE )%><!-- DATA TABLE ++++++++++++++++++++++++++++++++++++++++++++++ --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td background="images/bg_bage_0a.gif"><table width="100%" border="0" cellspacing="1" cellpadding="3"><tr><td background="images/bg_bage_0.gif" class="body_col" nowrap>Package</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Tester</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Comments</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Manager</td><td background="images/bg_bage_0.gif" class="body_col" nowrap>Comments</td></tr><%objRepeater.RenderDataGrid ()%></table></td></tr></table><%OraDatabase.Parameters.Remove "BOM_ID"rsQry.Close()Set rsQry = Nothing%><%Call objRepeater.Navigator ( FALSE, TRUE )%><br><!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --></td></tr></table></td><td width="1%" valign="top" background="images/bg_favourits.gif"><%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%><%End If%></td></tr><tr><td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td><td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td><td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td><td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td></tr><tr><td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td><td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td><td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td><td bgcolor="#FFFFFF"> </td></tr></table><!-- FOOTER ++++++++++++++++ --><!--#include file="_footer.asp"--><!-- +++++++++++++++++++++++ --></body></html><%'------------ RUN AFTER PAGE RENDER -----------Set objPMod = NothingSet objCrumbs = NothingSet objTabControl = Nothing'----------------------------------------------%><!--#include file="common/globals_destructor.asp"-->