Subversion Repositories DevTools

Rev

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

Rev 13 Rev 5355
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>Deployment Manager</title>
 35 
<title>Deployment 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_blue.gif"></td>
 60 
	  <tr>
61 
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objProdCollector )%></td>
 61 
        <td valign="top" background="images/bg_blue.gif"></td>
62 
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
 62 
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objProdCollector )%></td>
63 
      </tr>
 63 
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
64 
      <tr>
 64 
      </tr>
65 
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
 65 
      <tr>
66 
        <td width="100%" valign="bottom" background="images/bg_blue.gif">
 66 
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
67 
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
 67 
        <td width="100%" valign="bottom" background="images/bg_blue.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_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
 79 
		</td>
80 
        </tr>
 80 
        <td width="1%" background="images/bg_blue.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_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
 95 
		</td>
96 
        </tr>
 96 
        <td background="images/bg_blue.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 
			<td align="center" valign="top"><a href="#" title="Edit"><%=LIMG_EDIT%></a></td>
 132 
            <td class="body_rowlite" valign="top"><%=rsQry("product_comments")%></td>
133 
			<td align="center" valign="top"><a href="#" title="Remove"><%=LIMG_REMOVE%></a></td>
 133 
			<td align="center" valign="top"><a href="#" title="Edit"><%=LIMG_EDIT%></a></td>
134 
          </tr>
 134 
			<td align="center" valign="top"><a href="#" title="Remove"><%=LIMG_REMOVE%></a></td>
135 
		  <%rsQry.MoveNext%>
 135 
          </tr>
136
136 
		  <%rsQry.MoveNext%>
137 
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
 137
138 
          <tr>
 138 
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
139 
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 139 
          <tr>
140 
          </tr>
 140 
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
141 
		  <%End If%>
 141 
          </tr>
142
142 
		  <%End If%>
143 
		  <%
 143
144 
		  WEnd
 144 
		  <%
145
145 
		  WEnd
146 
		  OraDatabase.Parameters.Remove "PROD_ID"
 146
147 
		  OraDatabase.Parameters.Remove "BOM_ID"
 147 
		  OraDatabase.Parameters.Remove "PROD_ID"
148 
		  %>
 148 
		  OraDatabase.Parameters.Remove "BOM_ID"
149 
          <tr>
 149 
		  %>
150 
            <td colspan="6" background="images/bg_table_border.gif">
 150 
          <tr>
151 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
 151 
            <td colspan="6" background="images/bg_table_border.gif">
152 
              <tr>
 152 
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
153 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 153 
              <tr>
154 
              </tr>
 154 
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
155 
             </table>
 155 
              </tr>
156 
			</td>
 156 
             </table>
157 
          </tr>
 157 
			</td>
158 
         </table>
158 
          </tr>
159 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 159 
         </table>
160 
		</td>
 160 
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
161 
      </tr>
 161 
		</td>
162 
    </table>
 162 
      </tr>
163 
	</td>
 163 
    </table>
164 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
 164 
	</td>
165 
	<!-- PERSONAL BAR +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 165 
    <td width="1%" valign="top" background="images/bg_favourits.gif">
166 
	<!--#include file="_personal_bar.asp"-->
 166 
	<!-- PERSONAL BAR +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
167 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 167 
	<!--#include file="_personal_bar.asp"-->
168 
   </td>
 168 
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
169 
  </tr>
 169 
   </td>
170 
  <tr>
 170 
  </tr>
171 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
 171 
  <tr>
172 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
 172 
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
173 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 173 
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
174 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 174 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
175 
  </tr>
 175 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
176 
  <tr>
 176 
  </tr>
177 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
 177 
  <tr>
178 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 178 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
179 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
 179 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
180 
    <td bgcolor="#FFFFFF">&nbsp;</td>
 180 
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
181 
  </tr>
 181 
    <td bgcolor="#FFFFFF">&nbsp;</td>
182 
</table>
 182 
  </tr>
183 
<!-- FOOTER ++++++++++++++++ -->
 183 
</table>
184 
<!--#include file="_footer.asp"-->
 184 
<!-- FOOTER ++++++++++++++++ -->
185 
<!-- +++++++++++++++++++++++ -->
 185 
<!--#include file="_footer.asp"-->
186 
</body>
 186 
<!-- +++++++++++++++++++++++ -->
187 
</html>
 187 
</body>
188 
<%
 188 
</html>
189 
'------------ RUN AFTER PAGE RENDER -----------
 189 
<%
190 
Set objPMod = Nothing
 190 
'------------ RUN AFTER PAGE RENDER -----------
191 
Set objCrumbs = Nothing
 191 
Set objPMod = Nothing
192 
Set objTabControl = Nothing
 192 
Set objCrumbs = Nothing
193 
Set objBtnControl = Nothing
 193 
Set objTabControl = Nothing
194 
'----------------------------------------------
 194 
Set objBtnControl = Nothing
- 
 
 195 
'----------------------------------------------
195 
%><!--#include file="common/globals_destructor.asp"-->
 196 
%><!--#include file="common/globals_destructor.asp"-->
196 

            197