Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5356 dpurdie 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
'=====================================================
4 
'|                                                   |
5 
'|			          Bom_History				 	 |
6 
'|                                                   |
7 
'=====================================================
8 
%>
9 
<%
10 
Option explicit
11 
Response.Expires = 0
12 
%>
13 
<!--#include file="common/globals.asp"-->
14 
<!--#include file="common/config.asp"-->
15 
<!--#include file="common/common_subs.asp"-->
16 
<!--#include file="common/_bom_common.asp"-->
17 
<%
18 
'------------ ACCESS CONTROL ------------------
19 
%>
20 
<!--#include file="_access_control_general.asp"-->
21 
<%
22 
'------------ VARIABLE DEFINITION -------------
23 
Dim rsQry
24 
'------------ CONSTANTS DECLARATION -----------
25 
'------------ VARIABLE INIT -------------------
26 
'------------ CONDITIONS ----------------------
27 
'----------------------------------------------
28 
%>
29 
<%
30 
'------------ RUN BEFORE PAGE RENDER ----------
31 
'----------------------------------------------
32 
'-----------------------------------------------------------------------------------------------------------------
33 
Function UserName (nUserId)
34 
 
35 
If nUserId <> "" Then
36 
 
37 
	Dim rsTemp, user_name
38 
 
39 
	Set rsTemp = OraDatabase.DbCreateDynaset( "select * from users where user_id ="&nUserId , ORADYN_DEFAULT )
40 
 
41 
	user_name = rsTemp("full_name")
42 
 
43 
	rsTemp.Close()
44 
	Set rsTemp = Nothing
45 
 
46 
UserName = user_name
47 
 
48 
Else
49 
 
50 
UserName = NULL
51 
 
52 
End If
53 
 
54 
 
55 
End Function
56 
'-----------------------------------------------------------------------------------------------------------------
57 
%>
58 
<html>
59 
<head>
60 
<title>Production Manager</title>
61 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
62 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
63 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
64 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
65 
<script language="JavaScript" src="scripts/common.js"></script>
66 
</head>
67 
 
68 
<body leftmargin="0" topmargin="0">
69 
<!-- HEADER ++++++++++++++++ -->
70 
<!--#include file="_header.asp"-->
71 
<!-- +++++++++++++++++++++++ -->
72 
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
73 
<!--#include file="_main_menu.asp"-->
74 
<!-- +++++++++++++++++++++++++++++++++++++ -->
75 
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
76 
  <tr>
77 
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
78 
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
79 
	<!--#include file="_bom_browser.asp"-->
80 
	<!-- END OF NODE BROWSER +++++++++++++++ -->
81 
	</td>
82 
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
83 
    <td width="100%" valign="top" bgcolor="#FFFFFF">
84 
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
85 
	  <tr>
86 
        <td valign="top" background="images/bg_green.gif"></td>
87 
        <td align="right" valign="bottom" background="images/bg_green.gif" class="body_txtw"><%Call RenderTitleWithoutVersion( objBomCollector )%></td>
88 
        <td background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="20"></td>
89 
      </tr>
90 
      <tr>
91 
        <td width="1%" valign="top" background="images/bg_green.gif"></td>
92 
        <td width="100%" valign="bottom" background="images/bg_green.gif">
93 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
94 
		<!--#include file="_tabs_definition.asp"-->
95 
		<%
96 
		Set objTabControl = New TabControl
97 
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
98 
		objTabControl.TabStyle = "StyleWinXP"
99 
		objTabControl.AddTabDefnition ( arrBomTabDef )
100 
		objTabControl.SelectByName("History")
101 
		objTabControl.Render ()
102 
		%>
103 
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
104 
		</td>
105 
        <td width="1%" background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="35"></td>
106 
        </tr>
107 
      <tr>
108 
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
109 
        <td background="images/bg_bage_0.gif">&nbsp;</td>
110 
        <td background="images/bg_green.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
111 
        </tr>
112 
      <tr>
113 
        <td>&nbsp;</td>
114 
        <td>&nbsp;</td>
115 
        <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>
116 
        </tr>
117 
    </table>
118 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
119 
      <tr>
120 
        <td>
121 
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
122 
		<%
123 
		OraDatabase.Parameters.Add "BOM_ID", 	dbPARbom_id,	ORAPARM_INPUT, ORATYPE_NUMBER
124 
 
125 
 
126 
		Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BomHistory.sql") , ORADYN_DEFAULT )
127 
 
128 
		'Pass record set to Repeater
129 
		objRepeater.RecordSet = rsQry
130 
 
131 
		'Define Table Row with bound variables
132 
		objRepeater.Row = _
133 
			"<tr>"&_
134 
			"  <td bgcolor='#FFFFFF' class='body_smltxtg' nowrap valign='top'>""& <#DATE_TIME_STAMP#> &""</td>"&_
135 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#TRAIL_ACTION#> &""</td>"&_
136 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#TRAIL_COMMENTS#> )  &""</td>"&_
137 
			"  <td bgcolor='#FFFFFF' class='body_row' nowrap valign='top'><a href='mailto:""& <#USER_EMAIL#> &""' class='body_link'>"&_
138 
			"    <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>"&_
139 
			"</tr>"
140 
		%>
141 
		<%Call objRepeater.Navigator ( TRUE, TRUE )%>
142 
		<!-- DATA TABLE ++++++++++++++++++++++++++++++++++++++++++++++ -->
143 
		  <table width="100%"  border="0" cellspacing="0" cellpadding="0">
144 
            <tr>
145 
              <td background="images/bg_bage_0a.gif">
146 
			   <table width="100%"  border="0" cellspacing="1" cellpadding="3">
147 
                <tr>
148 
                  <td width="1%" background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td>
149 
                  <td width="40%" background="images/bg_bage_0.gif" class="body_col" nowrap>Action</td>
150 
				  <td width="60%" background="images/bg_bage_0.gif" class="body_col" nowrap>User Comments</td>
151 
				  <td width="1%" background="images/bg_bage_0.gif" class="body_col" nowrap>User</td>
152 
                </tr>
153 
				<%objRepeater.RenderDataGrid ()%>
154 
              </table>
155 
			 </td>
156 
            </tr>
157 
          </table>
158 
		  <%
159 
		  OraDatabase.Parameters.Remove "BOM_ID"
160 
 
161 
		  rsQry.Close()
162 
		  Set rsQry = Nothing
163 
		  %>
164 
		  <%Call objRepeater.Navigator ( FALSE, TRUE )%>
165 
		<br>
166 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
167 
		</td>
168 
      </tr>
169 
    </table>
170 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
171 
      <tr>
172 
        <td>
173 
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
174 
		<%
175 
		OraDatabase.Parameters.Add "BOM_ID", 	dbPARbom_id,	ORAPARM_INPUT, ORATYPE_NUMBER
176 
 
177 
 
178 
		Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseAuthorisationHistory.sql") , ORADYN_DEFAULT )
179 
 
180 
		'Pass record set to Repeater
181 
		objRepeater.RecordSet = rsQry
182 
 
183 
		'Define Table Row with bound variables
184 
		objRepeater.Row = _
185 
			"<tr>"&_
186 
			"  <td bgcolor='#FFFFFF' class='body_smltxtg' nowrap valign='top'>""& <#PKG_NAME#> &"" ""& <#PKG_VERSION#> &""</td>"&_
187 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#TESTER_DATESTAMP#> &""</td>"&_
188 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& UserName( <#TESTER_ID#> ) &""</td>"&_
189 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#TESTER_COMMENTS#> )  &""</td>"&_
190 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& <#MANAGER_DATESTAMP#> &""</td>"&_
191 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& UserName( <#MANAGER_ID#> ) &""</td>"&_
192 
			"  <td bgcolor='#FFFFFF' class='body_row' valign='top'>""& objFormater.TextToHtml( <#MANAGER_COMMENTS#> )  &""</td>"&_
193 
 
194 
			"</tr>"
195 
		%>
196 
		<SPAN class="body_colb">BOM - Release Authorisation History</SPAN>
197 
		<%Call objRepeater.Navigator ( TRUE, TRUE )%>
198 
		<!-- DATA TABLE ++++++++++++++++++++++++++++++++++++++++++++++ -->
199 
		  <table width="100%"  border="0" cellspacing="0" cellpadding="0">
200 
            <tr>
201 
              <td background="images/bg_bage_0a.gif">
202 
			   <table width="100%"  border="0" cellspacing="1" cellpadding="3">
203 
                <tr>
204 
                  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Package</td>
205 
                  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td>
206 
				  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Tester</td>
207 
				  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Comments</td>
208 
				  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Date</td>
209 
				  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Manager</td>
210 
				  <td background="images/bg_bage_0.gif" class="body_col" nowrap>Comments</td>
211 
                </tr>
212 
				<%objRepeater.RenderDataGrid ()%>
213 
              </table>
214 
			 </td>
215 
            </tr>
216 
          </table>
217 
		  <%
218 
		  OraDatabase.Parameters.Remove "BOM_ID"
219 
 
220 
		  rsQry.Close()
221 
		  Set rsQry = Nothing
222 
		  %>
223 
		  <%Call objRepeater.Navigator ( FALSE, TRUE )%>
224 
		<br>
225 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
226 
		</td>
227 
      </tr>
228 
    </table>
229 
	</td>
230 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
231 
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
232 
 
233 
	<%End If%>
234 
   </td>
235 
  </tr>
236 
  <tr>
237 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
238 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
239 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
240 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
241 
  </tr>
242 
  <tr>
243 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
244 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
245 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
246 
    <td bgcolor="#FFFFFF">&nbsp;</td>
247 
  </tr>
248 
</table>
249 
<!-- FOOTER ++++++++++++++++ -->
250 
<!--#include file="_footer.asp"-->
251 
<!-- +++++++++++++++++++++++ -->
252 
</body>
253 
</html>
254 
<%
255 
'------------ RUN AFTER PAGE RENDER -----------
256 
Set objPMod = Nothing
257 
Set objCrumbs = Nothing
258 
Set objTabControl = Nothing
259 
'----------------------------------------------
62 rsolanki 260 
%><!--#include file="common/globals_destructor.asp"-->