Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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