Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
5355 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          OS_BaseConf				 	 |
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/_os_common.asp"-->
17
<%
18
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<%
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsQry
24
Dim background
25
Dim pointer
26
Dim BaseEnvId
27
Dim BaseEnvName
28
Dim ProdId
29
Dim ProdName
30
'------------ CONSTANTS DECLARATION -----------
31
'------------ VARIABLE INIT -------------------
32
parBom_id = Request("bom_id")
33
parOs_id = Request("os_id")
34
BaseEnvName = objOsCollector.Item("base_env_name")
35
BaseEnvId = objOsCollector.Item("base_env_id")
36
'------------ CONDITIONS ----------------------
37
'----------------------------------------------
38
%>
39
<%
40
'--------------------------------------------------------------------------------------------------------------------------
41
Function GetBaseEnvList( nBom_id, nOs_id )
42
	Dim rsQry, query
43
	OraDatabase.Parameters.Add "BOM_ID", 		dbPARbom_id,	ORAPARM_INPUT, ORATYPE_NUMBER 
44
	OraDatabase.Parameters.Add "OS_ID", 		dbPARos_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
45
 
46
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BaseEnvList.sql"), ORADYN_DEFAULT )
47
 
48
	If rsQry.RecordCount > 0 Then
49
		GetBaseEnvList = rsQry.GetRows()
50
 
51
	Else
52
		GetBaseEnvList = NULL
53
 
54
	End If
55
 
5955 dpurdie 56
	OraDatabase.Parameters.Remove "BOM_ID"
5355 dpurdie 57
	OraDatabase.Parameters.Remove "OS_ID"
58
 
59
	rsQry.Close
60
	Set rsQry = Nothing
61
End Function
62
'--------------------------------------------------------------------------------------------------------------------------
63
%>
64
<%
65
'------------ RUN BEFORE PAGE RENDER ----------
66
'----------------------------------------------
67
%>
68
<html>
69
<head>
70
<title>Deployment Manager</title>
71
<link rel="shortcut icon" href="<%=FavIcon%>"/>
72
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
73
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6663 dpurdie 74
<link href="scripts/deployment_manager.css?ver=<%=VixVerNum%>" rel="stylesheet" type="text/css">
75
<script language="JavaScript" src="scripts/common.js?ver=<%=VixVerNum%>"></script>
5355 dpurdie 76
</head>
77
 
78
<body leftmargin="0" topmargin="0">
79
<!-- HEADER ++++++++++++++++ -->
80
<!--#include file="_header.asp"-->
81
<!-- +++++++++++++++++++++++ -->
82
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
83
<!--#include file="_main_menu.asp"-->
84
<!-- +++++++++++++++++++++++++++++++++++++ -->
85
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
86
  <tr>
87
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
88
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
89
	<!--#include file="_bom_browser.asp"-->
90
	<!-- END OF NODE BROWSER +++++++++++++++ -->
91
	</td>
92
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
93
    <td width="100%" valign="top" bgcolor="#FFFFFF">
94
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
95
	  <tr>
96
        <td valign="top" background="images/bg_blue.gif"></td>
97
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objOsCollector )%></td>
98
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
99
      </tr>
100
      <tr>
101
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
102
        <td width="100%" valign="bottom" background="images/bg_blue.gif">
103
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
104
		<!--#include file="_tabs_definition.asp"-->
105
		<%
106
		Set objTabControl = New TabControl
107
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
108
		objTabControl.TabStyle = "StyleWinXP"
109
		objTabControl.AddTabDefnition ( arrOsTabDef )
110
		objTabControl.SelectByName ("Base Configuration")
111
		objTabControl.Render ()
112
		%>
113
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
114
		</td>
115
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
116
        </tr>
117
      <tr>
118
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
119
        <td background="images/bg_bage_0.gif">
120
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
121
		<%
122
		'-- Define Action buttons on this tab
123
		aTabBtnsDef = Array("btnAddBaseEnv", "btnDestroyBaseEnv", "height=30", "btnPropertiesBaseEnv", "height=30", "btnSortBase")
124
 
125
		Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
126
 
127
		' -- Tell control if buttons need to be readonly actions 
128
		objBtnControl.IsReadonlyAction = objBomCollector.Item("is_readonly")
129
 
130
		' -- Conditions
131
		If IsNull( BaseEnvId ) Then
132
			Call objBtnControl.Active ("btnPropertiesBaseEnv", "N")
133
			Call objBtnControl.Active ("btnDestroyBaseEnv", "N")
134
		End If
135
 
136
		' -- Render Buttons
137
		Call objBtnControl.Render  ( aTabBtnsDef )
138
		%>
139
		<!-- +++++++++++++++++++++++++++++++++++ --></td>
140
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
141
        </tr>
142
      <tr>
143
        <td>&nbsp;</td>
144
        <td>&nbsp;</td>
145
        <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>
146
        </tr>
147
    </table>
148
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
149
      <tr>
150
        <td class="body_scol">
151
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
152
	  <%
153
	  '-- FROM START ---------------------------------------------------------------------------------------------------------
154
	  objFormComponent.FormName = "SetBaseConf"
155
	  objFormComponent.Action = "_SetBaseConf.asp"
156
	  objFormComponent.OnSubmit = "ShowProgress();"
157
	  objFormComponent.IsReadonlyAction = objBomCollector.Item("is_readonly")
158
 
159
	  Call objFormComponent.FormStart()
160
	  %>		
161
		<SPAN class="body_colb">Assign Base Configurations to OS</SPAN><br><br>
162
		<%=objFormComponent.Combo ( "base_env_id", GetBaseEnvList( parBom_id, parOs_id ), TRUE, "class='form_ivalue'" )%>
163
		<%=objPMod.ComposeHiddenTags()%>
164
		<input type="hidden" name="rfile" value="<%=SCRIPT_NAME%>">
165
		<input type="hidden" name="action" value="true">
166
		<%=objFormComponent.SubmitButton ("Assign", "name='btn' class='form_btn'")%>
167
	 <%
168
	 Call objFormComponent.FormEnd()
169
 
170
	 '-- FROM END ----------------------------------------------------------------------------------------------------------------
171
	 %>
172
	<%If BaseEnvId <> "" Then%>
173
		<hr width="100%" size="1px" noshade color="Black">
174
		<br>
175
		<SPAN class="body_colb">Base Configuration Setup</SPAN><br><br>
176
		<table width="100%"  border="0" cellspacing="0" cellpadding="3">
177
          <tr>
178
		  	<td width="100%" background="images/bg_table_col.gif">
179
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
180
		<%
181
		'-- Define Action buttons on this tab
182
		aTabBtnsDef = Array("btnAddBaseEnvProd","height=30", "btnPasteProdToBaseEnv")
183
 
184
		Call objBtnControl.LoadActionButtons ( aTabBtnsDef, OraDatabase )
185
 
186
		' -- Render Buttons
187
		Call objBtnControl.Render  ( aTabBtnsDef )
188
		%>
189
		<!-- +++++++++++++++++++++++++++++++++++ -->
190
		    </td>
191
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="20"></td>
192
		  </tr>
193
		</table>
194
		<table width="100%"  border="0" cellspacing="3" cellpadding="0">
195
          <tr>
196
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
197
            <td width="1%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
198
              <tr>
199
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">&nbsp;Install Order</td>
200
              </tr>
201
            </table></td>
202
			<td width="20%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Product Name</td>
203
            <td width="20%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
204
			<td width="60%" align="right" background="images/bg_table_col.gif" class="body_col">Installation Comments</td>
205
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
206
          </tr>
207
		  <%
208
		  ' Load some action buttons
209
		  Call objBtnControl.LoadActionButtons ( Array("btnEditProdBaseEnv", "btnRemoveProdBaseEnv"), OraDatabase )
210
		  objBtnControl.ButtonSpacer = 1
211
 
212
		  OraDatabase.Parameters.Add "BASE_ENV_ID", BaseEnvId,	ORAPARM_INPUT, ORATYPE_NUMBER 
213
 
214
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("BaseEnvContents.sql"), ORADYN_DEFAULT )
215
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
216
		  	ProdId = rsQry("prod_id")
217
		  	ProdName = rsQry("pkg_name").Value
218
		  %>
219
          <tr>
220
		  	<td align="center" valign="top"><input type="checkbox" name="prod_id_list" value="<%=ProdId%>"></td>
221
			<td align="center" valign="top" class="body_txt"><%=rsQry("seq_num")%></td>
222
            <td nowrap class="body_row" valign="top"><a href="ProdDefault.asp?prod_id=<%=ProdId%>&<%=objPMod.ComposeURL()%>" class="body_link"><%=GetProductIcon(rsQry)  &  ProdName%></a></td>
223
			<td nowrap class="body_row" valign="top"><%=rsQry("pkg_version")%></td>
224
            <td class="body_rowlite" valign="top"><%=objFormater.TextToHtml( rsQry("base_env_comments") )%></td>
225
			<td align="center" valign="top"><%Call objBtnControl.Render  ( Array("btnEditProdBaseEnv", "btnRemoveProdBaseEnv") )%></td>
226
          </tr>
227
		  <%rsQry.MoveNext%>
228
 
229
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
230
          <tr>
231
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
232
          </tr>
233
		  <%End If%>
234
 
235
		  <%
236
		  WEnd
237
 
238
		  OraDatabase.Parameters.Remove "BASE_ENV_ID"
239
		  %>
240
          <tr>
241
            <td colspan="6" background="images/bg_table_border.gif">
242
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
243
              <tr>
244
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
245
              </tr>
246
             </table>
247
			</td>
248
          </tr>
249
         </table>	
250
	<%End If%>		 
251
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
252
		</td>
253
      </tr>
254
    </table>
255
	</td>
256
    <td width="1%" valign="top" background="images/bg_favourits.gif">
257
	<%If Request.Cookies( enumCOOKIE_NAME )( "user_bar" ) <> "hide" Then%>
258
	<!-- PERSONAL PANE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
259
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
260
      <tr>
261
        <td width="100%" valign="bottom" background="images/bg_node_icon.gif"><%=GetNodeImage ( dbPARnode_id )%></td>
262
        <td width="1" background="images/bg_node_icon.gif"><img src="images/spacer.gif" width="1" height="97"></td>
263
      </tr>
264
      </table>
265
      <a href="<%=SCRIPT_NAME%>?user_bar=hide&<%=objPMod.ComposeURL()%>"><img src="icons/b_right.gif" title="Minimize favourits" width="13" height="13" vspace="5" border="0"></a>      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
266
      <tr>
267
        <td valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
268
          <tr>
269
            <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
270
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
271
            <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
272
          </tr>
273
          <tr>
274
            <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
275
              <tr>
276
                <td valign="top" class="fav_txt"><span class="fav_head">Reason for release</span><br>
277
                      <br>
278
<!--         This version needs to be rebuild on new sysbase_types 1.5.0.mas<br> -->
279
                </td>
280
              </tr>
281
            </table></td>
282
            </tr>
283
          <tr>
284
            <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
285
            <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
286
            <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
287
          </tr>
288
        </table>
289
          <br>
290
          <table width="100%"  border="0" cellspacing="0" cellpadding="0">
291
            <tr>
292
              <td valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
293
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="10" height="3"></td>
294
              <td align="right" valign="top" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
295
            </tr>
296
            <tr background="images/bg_gray.gif">
297
              <td colspan="3" background="images/bg_favourits2.gif"><table width="100%"  border="0" cellspacing="5" cellpadding="0">
298
                <tr>
299
                  <td valign="top" class="fav_txt"><span class="fav_head">Fixed Issues</span><br>
300
                      <br>
301
                      <table width="100%"  border="0" cellspacing="0" cellpadding="2">
302
<!--                         <tr>
303
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
304
                          <td><a href="#" class="fav_link">DEVI-021532</a></td>
305
                        </tr>
306
                        <tr>
307
                          <td><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
308
                          <td><a href="#" class="fav_link">DEVI-021534</a></td>
309
                        </tr>
310
                        <tr>
311
                          <td width="1%"><img src="icons/i_bulet.gif" width="4" height="4" hspace="5"></td>
312
                          <td width="100%"><a href="#" class="fav_link">DEVI-021536</a></td>
313
                        </tr> -->
314
                    </table></td>
315
                </tr>
316
              </table></td>
317
              </tr>
318
            <tr>
319
              <td valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
320
              <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="190" height="3"></td>
321
              <td align="right" valign="bottom" background="images/bg_bage_0a.gif"><img src="images/dot_white.gif" width="1" height="1"></td>
322
            </tr>
323
          </table></td>
324
        <td width="1%"><img src="images/spacer.gif" width="15" height="400"></td>
325
      </tr>
326
    </table>
327
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
328
	<%End If%>
329
   </td>
330
  </tr>
331
  <tr>
332
    <td background="images/bg_bage_0a.gif"><img src="images/spacer.gif" width="1" height="15"></td>
333
    <td background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="1"></td>
334
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
335
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
336
  </tr>
337
  <tr>
338
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="20"></td>
339
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
340
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1"></td>
341
    <td bgcolor="#FFFFFF">&nbsp;</td>
342
  </tr>
343
</table>
344
<!-- FOOTER ++++++++++++++++ -->
345
<!--#include file="_footer.asp"-->
346
<!-- +++++++++++++++++++++++ -->
347
</body>
348
</html>