Subversion Repositories DevTools

Rev

Rev 62 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 62 Rev 5356
Line 1... Line 1...
1 
<%@LANGUAGE="VBSCRIPT"%>
 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
 2 
<%
3 
'=====================================================
 3 
'=====================================================
4 
'|                                                   |
 4 
'|                                                   |
5 
'|			          UsedBy					 	 |
 5 
'|			          UsedBy					 	 |
6 
'|                                                   |
 6 
'|                                                   |
7 
'=====================================================
 7 
'=====================================================
8 
%>
 8 
%>
9 
<%
 9 
<%
10 
Option explicit
 10 
Option explicit
11 
Response.Expires = 0
 11 
Response.Expires = 0
12 
%>
 12 
%>
13 
<!--#include file="common/globals.asp"-->
 13 
<!--#include file="common/globals.asp"-->
14 
<!--#include file="common/config.asp"-->
 14 
<!--#include file="common/config.asp"-->
15 
<!--#include file="common/common_subs.asp"-->
 15 
<!--#include file="common/common_subs.asp"-->
16 
<!--#include file="common/_product_common.asp"-->
 16 
<!--#include file="common/_product_common.asp"-->
17 
<%
 17 
<%
18 
'------------ ACCESS CONTROL ------------------
 18 
'------------ ACCESS CONTROL ------------------
19 
%>
 19 
%>
20 
<!--#include file="_access_control_general.asp"-->
 20 
<!--#include file="_access_control_general.asp"-->
21 
<%
 21 
<%
22 
'------------ VARIABLE DEFINITION -------------
 22 
'------------ VARIABLE DEFINITION -------------
23 
Dim rsQry
 23 
Dim rsQry
24 
'------------ CONSTANTS DECLARATION -----------
 24 
'------------ CONSTANTS DECLARATION -----------
25 
'------------ VARIABLE INIT -------------------
 25 
'------------ VARIABLE INIT -------------------
26 
'------------ CONDITIONS ----------------------
 26 
'------------ CONDITIONS ----------------------
27 
'----------------------------------------------
 27 
'----------------------------------------------
28 
%>
 28 
%>
29 
<%
 29 
<%
30 
'------------ RUN BEFORE PAGE RENDER ----------
 30 
'------------ RUN BEFORE PAGE RENDER ----------
31 
'----------------------------------------------
 31 
'----------------------------------------------
32 
%>
 32 
%>
33 
<html>
 33 
<html>
34 
<head>
 34 
<head>
35 
<title>Production Manager</title>
 35 
<title>Production Manager</title>
36 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
 36 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
37 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 37 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
38 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
 38 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
39 
<script language="JavaScript" src="scripts/common.js"></script>
 39 
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
40 
</head>
 40 
<script language="JavaScript" src="scripts/common.js"></script>
41 
 
 41 
</head>
42 
<body leftmargin="0" topmargin="0">
 42 
 
43 
<!-- HEADER ++++++++++++++++ -->
 43 
<body leftmargin="0" topmargin="0">
44 
<!--#include file="_header.asp"-->
 44 
<!-- HEADER ++++++++++++++++ -->
45 
<!-- +++++++++++++++++++++++ -->
 45 
<!--#include file="_header.asp"-->
46 
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
 46 
<!-- +++++++++++++++++++++++ -->
47 
<!--#include file="_main_menu.asp"-->
 47 
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
48 
<!-- +++++++++++++++++++++++++++++++++++++ -->
 48 
<!--#include file="_main_menu.asp"-->
49 
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
 49 
<!-- +++++++++++++++++++++++++++++++++++++ -->
50 
  <tr>
 50 
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
51 
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
 51 
  <tr>
52 
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
 52 
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
53 
	<!--#include file="_bom_browser.asp"-->
 53 
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
54 
	<!-- END OF NODE BROWSER +++++++++++++++ -->
 54 
	<!--#include file="_bom_browser.asp"-->
55 
	</td>
 55 
	<!-- END OF NODE BROWSER +++++++++++++++ -->
56 
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
 56 
	</td>
57 
    <td width="100%" valign="top" bgcolor="#FFFFFF">
 57 
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
58 
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
 58 
    <td width="100%" valign="top" bgcolor="#FFFFFF">
59 
	  <tr>
 59 
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
60 
        <td valign="top" background="images/bg_green.gif"></td>
 60 
	  <tr>
61 
        <td align="right" valign="bottom" background="images/bg_green.gif" class="body_txtw"><%Call RenderTitle( objProdCollector )%></td>
 61 
        <td valign="top" background="images/bg_green.gif"></td>
62 
        <td background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="20"></td>
 62 
        <td align="right" valign="bottom" background="images/bg_green.gif" class="body_txtw"><%Call RenderTitle( objProdCollector )%></td>
63 
      </tr>
 63 
        <td background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="20"></td>
64 
      <tr>
 64 
      </tr>
65 
        <td width="1%" valign="top" background="images/bg_green.gif"></td>
 65 
      <tr>
66 
        <td width="100%" valign="bottom" background="images/bg_green.gif">
 66 
        <td width="1%" valign="top" background="images/bg_green.gif"></td>
67 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
 67 
        <td width="100%" valign="bottom" background="images/bg_green.gif">
68 
		<!--#include file="_tabs_definition.asp"-->
 68 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
69 
		<%
 69 
		<!--#include file="_tabs_definition.asp"-->
70 
		Set objTabControl = New TabControl
 70 
		<%
71 
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
 71 
		Set objTabControl = New TabControl
72 
		objTabControl.TabStyle = "StyleWinXP"
 72 
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
73 
		objTabControl.AddTabDefnition ( arrProdTabDef )
 73 
		objTabControl.TabStyle = "StyleWinXP"
74 
		objTabControl.SelectByName ("Used By")
 74 
		objTabControl.AddTabDefnition ( arrProdTabDef )
75 
		objTabControl.Render ()
 75 
		objTabControl.SelectByName ("Used By")
76 
		%>
 76 
		objTabControl.Render ()
77 
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
 77 
		%>
78 
		</td>
 78 
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
79 
        <td width="1%" background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="35"></td>
 79 
		</td>
80 
        </tr>
 80 
        <td width="1%" background="images/bg_green.gif"><img src="images/spacer.gif" width="10" height="35"></td>
81 
      <tr>
 81 
        </tr>
82 
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
 82 
      <tr>
83 
        <td background="images/bg_bage_0.gif">
 83 
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
84 
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
 84 
        <td background="images/bg_bage_0.gif">
85 
		<%
 85 
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
86 
		'-- Define Action buttons on this tab
 86 
		<%
87 
		'aTabBtnsDef = Array("btnAddOs", "width=10", "btnCopyOs", "btnPasteOs")
 87 
		'-- Define Action buttons on this tab
88
88 
		'aTabBtnsDef = Array("btnAddOs", "width=10", "btnCopyOs", "btnPasteOs")
89 
		'Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
 89
90
90 
		'Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
91 
		'objBtnControl.Render( aTabBtnsDef )
 91
92 
		%>
 92 
		'objBtnControl.Render( aTabBtnsDef )
93 
		<!-- +++++++++++++++++++++++++++++++++++ -->
 93 
		%>
94 
		</td>
 94 
		<!-- +++++++++++++++++++++++++++++++++++ -->
95 
        <td background="images/bg_green.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
 95 
		</td>
96 
        </tr>
 96 
        <td background="images/bg_green.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
97 
      <tr>
 97 
        </tr>
98 
        <td>&nbsp;</td>
 98 
      <tr>
99 
        <td>&nbsp;</td>
 99 
        <td>&nbsp;</td>
100 
        <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>
 100 
        <td>&nbsp;</td>
101 
        </tr>
 101 
        <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>
102 
    </table>
 102 
        </tr>
103 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
 103 
    </table>
104 
      <tr>
 104 
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
105 
        <td>
 105 
      <tr>
106 
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 106 
        <td>
107 
		<table width="100%"  border="0" cellspacing="3" cellpadding="0">
 107 
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
108 
          <tr>
 108 
		<table width="100%"  border="0" cellspacing="3" cellpadding="0">
109 
            <td width="30%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
 109 
          <tr>
110 
              <tr>
 110 
            <td width="30%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
111 
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Location</td>
 111 
              <tr>
112 
              </tr>
 112 
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Location</td>
113 
            </table></td>
 113 
              </tr>
114 
			<td width="20%" align="right" background="images/bg_table_col.gif" class="body_col">Product Name</td>
 114 
            </table></td>
115 
			<td width="10%" align="right" background="images/bg_table_col.gif" class="body_col">Version</td>
 115 
			<td width="20%" align="right" background="images/bg_table_col.gif" class="body_col">Product Name</td>
116 
			<td width="50%" align="right" background="images/bg_table_col.gif" class="body_col">Comments</td>
 116 
			<td width="10%" align="right" background="images/bg_table_col.gif" class="body_col">Version</td>
117 
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 117 
			<td width="50%" align="right" background="images/bg_table_col.gif" class="body_col">Comments</td>
118 
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 118 
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
119 
          </tr>
 119 
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
120 
		  <%
 120 
          </tr>
121 
		  OraDatabase.Parameters.Add "PROD_ID", dbPARprod_id,		ORAPARM_INPUT, ORATYPE_NUMBER
121 
		  <%
122 
		  OraDatabase.Parameters.Add "BOM_ID",  dbPARbom_id,		ORAPARM_INPUT, ORATYPE_NUMBER
122 
		  OraDatabase.Parameters.Add "PROD_ID", dbPARprod_id,		ORAPARM_INPUT, ORATYPE_NUMBER
123
123 
		  OraDatabase.Parameters.Add "BOM_ID",  dbPARbom_id,		ORAPARM_INPUT, ORATYPE_NUMBER
124 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ProductNameAtOtherLocations.sql"), ORADYN_DEFAULT )
 124
125 
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 125 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ProductNameAtOtherLocations.sql"), ORADYN_DEFAULT )
126 
		  %>
 126 
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
127 
          <tr>
 127 
		  %>
128 
            <td nowrap valign="top"><a href="ProdDefault.asp?prod_id=<%=rsQry("prod_id")%>&os_id=<%=rsQry("os_id")%><%=objPMod.ComposeURLWithout("prod_id,os_id")%>" title="Go to This Location" class="body_link"><img src="icons/<%=rsQry("node_icon")%>" border="0" align='absmiddle' hspace="2"><%=rsQry("node_name").Value &" / "& rsQry("os_name").Value %></a></td>
 128 
          <tr>
129 
			<td nowrap class="body_row" valign="top"><%=LIMG_PRODUCT  &  rsQry("prod_name").Value%></td>
 129 
            <td nowrap valign="top"><a href="ProdDefault.asp?prod_id=<%=rsQry("prod_id")%>&os_id=<%=rsQry("os_id")%><%=objPMod.ComposeURLWithout("prod_id,os_id")%>" title="Go to This Location" class="body_link"><img src="icons/<%=rsQry("node_icon")%>" border="0" align='absmiddle' hspace="2"><%=rsQry("node_name").Value &" / "& rsQry("os_name").Value %></a></td>
130 
            <td nowrap <%If CBool(rsQry("is_different")) Then%>class="body_txtr"<%Else%>class="body_row"<%End If%> valign="top"><%=rsQry("prod_version")%></td>
 130 
			<td nowrap class="body_row" valign="top"><%=LIMG_PRODUCT  &  rsQry("prod_name").Value%></td>
131 
            <td class="body_rowlite" valign="top"><%=rsQry("product_comments")%></td>
 131 
            <td nowrap <%If CBool(rsQry("is_different")) Then%>class="body_txtr"<%Else%>class="body_row"<%End If%> valign="top"><%=rsQry("prod_version")%></td>
132 
          </tr>
 132 
            <td class="body_rowlite" valign="top"><%=rsQry("product_comments")%></td>
133 
		  <%rsQry.MoveNext%>
 133 
          </tr>
134
134 
		  <%rsQry.MoveNext%>
135 
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
 135
136 
          <tr>
 136 
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
137 
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 137 
          <tr>
138 
          </tr>
 138 
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
139 
		  <%End If%>
 139 
          </tr>
140
140 
		  <%End If%>
141 
		  <%
 141
142 
		  WEnd
 142 
		  <%
143
143 
		  WEnd
144 
		  OraDatabase.Parameters.Remove "PROD_ID"
 144
145 
		  OraDatabase.Parameters.Remove "BOM_ID"
 145 
		  OraDatabase.Parameters.Remove "PROD_ID"
146 
		  %>
 146 
		  OraDatabase.Parameters.Remove "BOM_ID"
147 
          <tr>
 147 
		  %>
148 
            <td colspan="6" background="images/bg_table_border.gif">
 148 
          <tr>
149 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
 149 
            <td colspan="6" background="images/bg_table_border.gif">
150 
              <tr>
 150 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
151 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 151 
              <tr>
152 
              </tr>
 152 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
153 
             </table>
 153 
              </tr>
154 
			</td>
 154 
             </table>
155 
          </tr>
 155 
			</td>
156 
         </table>
156 
          </tr>
157 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 157 
         </table>
158 
		</td>
 158 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
159 
      </tr>
 159 
		</td>
160 
    </table>
 160 
      </tr>
161 
	</td>
 161 
    </table>
162 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
 162 
	</td>
163 
	<!-- PERSONAL BAR +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 163 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
164 
	<!--#include file="_personal_bar.asp"-->
 164 
	<!-- PERSONAL BAR +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
165 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 165 
	<!--#include file="_personal_bar.asp"-->
166 
   </td>
 166 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
167 
  </tr>
 167 
   </td>
168 
  <tr>
 168 
  </tr>
169 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
 169 
  <tr>
170 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 170 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
171 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 171 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
172 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 172 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
173 
  </tr>
 173 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
174 
  <tr>
 174 
  </tr>
175 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
 175 
  <tr>
176 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 176 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
177 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 177 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
178 
    <td bgcolor="#FFFFFF">&nbsp;</td>
 178 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
179 
  </tr>
 179 
    <td bgcolor="#FFFFFF">&nbsp;</td>
180 
</table>
 180 
  </tr>
181 
<!-- FOOTER ++++++++++++++++ -->
 181 
</table>
182 
<!--#include file="_footer.asp"-->
 182 
<!-- FOOTER ++++++++++++++++ -->
183 
<!-- +++++++++++++++++++++++ -->
 183 
<!--#include file="_footer.asp"-->
184 
</body>
 184 
<!-- +++++++++++++++++++++++ -->
185 
</html>
 185 
</body>
186 
<%
 186 
</html>
187 
'------------ RUN AFTER PAGE RENDER -----------
 187 
<%
188 
Set objPMod = Nothing
 188 
'------------ RUN AFTER PAGE RENDER -----------
189 
Set objCrumbs = Nothing
 189 
Set objPMod = Nothing
190 
Set objTabControl = Nothing
 190 
Set objCrumbs = Nothing
191 
Set objBtnControl = Nothing
 191 
Set objTabControl = Nothing
192 
'----------------------------------------------
 192 
Set objBtnControl = Nothing
- 
 
 193 
'----------------------------------------------
193 
%><!--#include file="common/globals_destructor.asp"-->
 194 
%><!--#include file="common/globals_destructor.asp"-->
194 

            195