Subversion Repositories DevTools

Rev

Rev 64 | Details | Compare with Previous | Last modification | View Log | RSS feed

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