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
'|			          OSDefault					 	 |
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 rsolanki 23
Dim rsQry, rsTemp
15 rsolanki 24
Dim selected, nodeSpec
13 rsolanki 25
Dim parHold_selection
25 rsolanki 26
Dim ProdId, pkgId 
13 rsolanki 27
Dim ProdName
25 rsolanki 28
Dim ProdVersion, objFormCollector
13 rsolanki 29
'------------ CONSTANTS DECLARATION -----------
30
'------------ VARIABLE INIT -------------------
31
parHold_selection = Request("hold_selection")
25 rsolanki 32
Set	objFormCollector=CreateObject("Scripting.Dictionary")
13 rsolanki 33
'------------ CONDITIONS ----------------------
34
'----------------------------------------------
35
%>
36
<%
37
'------------ RUN BEFORE PAGE RENDER ----------
38
If (Request("action") <> "") Then
39
	'-- Select Action
40
 
41
	Select Case Request("action")
42
		Case "btnMoveUpProd"
43
			Call OpenInWindow ( "_ShiftBulkProducts.asp?prod_id_list="& Request("prod_id_list") &"&shift_dir="& Server.URLEncode("-") &"&action=true&rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() )
44
		Case "btnMoveDownProd"
45
			Call OpenInWindow ( "_ShiftBulkProducts.asp?prod_id_list="& Request("prod_id_list") &"&shift_dir="& Server.URLEncode("+") &"&action=true&rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() )
46
		Case "btnAcceptRejectProd"
47
			Call OpenInWindow ( "_AcceptRejectProd.asp?prod_id_list="& Request("prod_id_list") &"&rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() )
48
		Case "btnCopyProd"
49
			Call OpenInWindow ( "_CopyItems.asp?copy_type=prod_id_list&prod_id_list="& Request("prod_id_list") &"&rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() )
50
		Case "btnRemoveProdBulk"
51
			Call OpenInWindow ( "_RemoveProductFromOs.asp?rfile="& SCRIPT_NAME &"&prod_id_list="& Request("prod_id_list") &"&"& objPMod.ComposeURL() )
15 rsolanki 52
		Case "btnIsNodeSpec"
23 rsolanki 53
			Call OpenInWindow ( "_AddProductFromOs.asp?rfile="& SCRIPT_NAME &"&prod_id_list="& Request("node_spec_list") &"&"& objPMod.ComposeURL() )
54
		Case "btnRemoveObsoletePatches"
55
			Call OpenInWindow ( "_RemoveObsoletePatches.asp?rfile="& SCRIPT_NAME &"&"& objPMod.ComposeURL() )
13 rsolanki 56
 
57
	End Select
58
 
59
End If
25 rsolanki 60
 
61
Call GetProjDetails ( Request("bom_id"), objFormCollector )
13 rsolanki 62
'----------------------------------------------
63
%>
64
<html>
65
<head>
66
<title>Deployment Manager</title>
67
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
68
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
69
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
70
<script language="JavaScript" src="scripts/common.js"></script>
71
 
72
</head>
73
 
74
<body leftmargin="0" topmargin="0">
75
<!-- HEADER ++++++++++++++++ -->
76
<!--#include file="_header.asp"-->
77
<!-- +++++++++++++++++++++++ -->
78
<!-- MAIN MENU  +  CRUMBS ++++++++++++++++ -->
79
<!--#include file="_main_menu.asp"-->
80
<!-- +++++++++++++++++++++++++++++++++++++ -->
81
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
82
  <tr>
83
    <td width="1%" valign="top" background="images/bg_bage_0.gif">
84
	<!-- NODE BROWSER ++++++++++++++++++++++ -->
85
	<!--#include file="_bom_browser.asp"-->
86
	<!-- END OF NODE BROWSER +++++++++++++++ -->
87
	</td>
88
    <td width="1" background="images/bg_bage_1.gif"><img src="images/spacer.gif" width="1" height="600"></td>
89
    <td width="100%" valign="top" bgcolor="#FFFFFF">
90
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
91
	<form name="FormName" method="post" action="<%=SCRIPT_NAME%>">
92
	  <tr>
93
        <td valign="top" background="images/bg_blue.gif"></td>
94
        <td align="right" valign="bottom" background="images/bg_blue.gif" class="body_txtw"><%Call RenderTitle( objOsCollector )%></td>
95
        <td background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="20"></td>
96
      </tr>
97
      <tr>
98
        <td width="1%" valign="top" background="images/bg_blue.gif"></td>
99
        <td width="100%" valign="bottom" background="images/bg_blue.gif">
100
		<!-- TAB CONTROLS ++++++++++++++++++++++ -->
101
		<!--#include file="_tabs_definition.asp"-->
102
		<%
103
		Set objTabControl = New TabControl
104
		objTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleWinXP/tab_style.html") ) ' Supply tab style definition
105
		objTabControl.TabStyle = "StyleWinXP"
106
		objTabControl.AddTabDefnition ( arrOsTabDef )
107
		objTabControl.Render ()
108
		%>
109
		<!-- END OF TAB CONTROLS +++++++++++++++ -->
110
		</td>
111
        <td width="1%" background="images/bg_blue.gif"><img src="images/spacer.gif" width="10" height="35"></td>
112
        </tr>
113
      <tr>
114
        <td background="images/bg_bage_0.gif"><img src="images/spacer.gif" width="30" height="10"></td>
115
        <td background="images/bg_bage_0.gif">
116
		<!-- BUTTONS CONTROL +++++++++++++++++++ -->
117
		<%
118
		OraDatabase.Parameters.Add "BOM_ID",	Request("bom_id"), ORAPARM_INPUT, ORATYPE_NUMBER 		
119
		OraDatabase.Parameters.Add "OS_IDA",	Request("os_id"), ORAPARM_INPUT, ORATYPE_NUMBER 		
120
 
121
		Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("run_patch.sql"), ORADYN_DEFAULT )
122
 
123
 
124
		'-- Define Action buttons on this tab
23 rsolanki 125
		aTabBtnsDef = Array("btnAddProd", "btnIsNodeSpec", "btnRemoveProdBulk", "height=30", "btnSortProd", "height=30", "btnAcceptRejectProd", "height=30", "btnCopyProd", "btnPasteProd", "btnPatchGenerate", "btnRemoveObsoletePatches")
13 rsolanki 126
 
127
		Call LoadTabActionButtons ( aTabBtnsDef, objBtnControl )
128
 
129
		' -- Tell control if buttons need to be readonly actions 
130
		objBtnControl.IsReadonlyAction = objBomCollector.Item("is_readonly")
131
 
132
		' -- Conditions 
133
		If Session( enumSESSION_COPY_TYPE ) <> "prod_id_list" Then
134
			Call objBtnControl.Active ( "btnPasteProd", "N" )
135
		End If
136
 
137
		' -- Render Buttons
138
		Call objBtnControl.Render  ( aTabBtnsDef )
15 rsolanki 139
 
25 rsolanki 140
	Dim rsProj, projName, branchName, projId, rsOS, OSName
141
	Set rsProj = OraDatabase.DbCreateDynaset( "select br.branch_name, prj.proj_name, prj.proj_id from boms bm, branches br, dm_projects prj where bm.bom_id = "&Request("bom_id")&" and br.BRANCH_ID = bm.BRANCH_ID and prj.PROJ_ID = br.PROJ_ID", cint(0))
142
 
143
	projName = rsProj("proj_name")	
144
	branchName = rsProj("branch_name")
145
	projId = rsProj("proj_id")
146
 
147
	rsProj.Close()
148
	Set rsProj = nothing
149
 
150
 
151
 
152
	Set rsOS = OraDatabase.DbCreateDynaset( "select bt.bos_type from os_base_env obe, base_env be, bos_types bt where obe.OS_ID = "&Request("os_id")&" and be.BASE_ENV_ID = obe.BASE_ENV_ID and bt.BOS_ID = be.BOS_ID", cint(0))
153
 
154
	OSName = rsOS("bos_type")
155
 
156
	If OSName = "Windows" OR OSName = "MOS" Then
157
		OSName = "win32"
158
	Else
159
		OSName = "sparc"
160
	End If	
161
 
162
	rsOS.Close()
163
	Set rsOS = nothing		
164
 
13 rsolanki 165
		%>
166
		<%
167
 
168
 
169
 
170
		OraDatabase.Parameters.Remove "BOM_ID"
171
		OraDatabase.Parameters.Remove "OS_IDA"
172
 
173
'		Response.Write "<font size=2><a target=Window_Name  href=""run_patch.asp?project="&"'" &rsQry("proj_name") & "'"&"&release="&"'"& rsQry("branch_name") &"'"&"&sbom="& rsQry("sbom_version") &"&node="&"'" &rsQry("node_name") &"'"&"&OS="&"'" &rsQry("os_name") &"'"&""">Patch Generation</a></font>" 
174
'		Response.Write "<font size=2><img src=""icons/i_patch_small.gif""><a target=Window_Name href=""run_patch_GUI.asp?project=" &rsQry("proj_name") & "&release="& rsQry("branch_name") &"&sbom="& rsQry("sbom_version") &"&node=" &rsQry("node_name") &"&OS=" &rsQry("os_name") &""">Patch Generation</a></font>" 	
175
		rsQry.Close
176
		Set rsQry = Nothing
177
		%>
178
 
179
		</td>
180
        <td background="images/bg_blue.gif"><img src="images/p_bar_corrner.gif" width="17" height="42"></td>
181
        </tr>
182
      <tr>
183
        <td>&nbsp;</td>
184
        <td>&nbsp;</td>
185
        <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>
186
        </tr>
187
    </table>
188
	<table width="100%"  border="0" cellspacing="10" cellpadding="0">
189
      <tr>
190
        <td>
191
		<!-- PAGE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
192
		<table width="100%"  border="0" cellspacing="3" cellpadding="0">
193
          <tr>
194
		  	<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
195
            <td width="1%" background="images/bg_table_border.gif"><table width="100%"  border="0" cellspacing="1" cellpadding="2">
196
              <tr>
15 rsolanki 197
                <td align="center" nowrap background="images/bg_table_col.gif" class="body_col">&nbsp;Install Order</td>
13 rsolanki 198
              </tr>
199
            </table></td>
15 rsolanki 200
			<td width="10%" align="center" nowrap background="images/bg_table_col.gif" class="body_col">Product Name</td>
201
            <td width="10%" align="center" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
25 rsolanki 202
			<td width="2%" align="center" background="images/bg_table_col.gif" class="body_col">In Spec</td>
15 rsolanki 203
			<td width="78%" align="center" background="images/bg_table_col.gif" class="body_col">
13 rsolanki 204
			<SPAN id="IMG_EXPAND_ALL" name="IMG_EXPAND_ALL" style="display:block;"><a href="javascript:;" onClick="ExpandAll(); ToggleDisplay('IMG_EXPAND_ALL','IMG_COLLAPSE_ALL');" title="Show All Installation Comments."><img src="icons/b_expand_all.gif" border="0" align="absmiddle" hspace="3"></a>Installation Comments</SPAN>
205
			<SPAN id="IMG_COLLAPSE_ALL" name="IMG_COLLAPSE_ALL" style="display:none;"><a href="javascript:;" onClick="CollapseAll(); ToggleDisplay('IMG_EXPAND_ALL','IMG_COLLAPSE_ALL');" title="Hide All Installation Comments."><img src="icons/b_collapse_all.gif" border="0" align="absmiddle" hspace="3"></a>Installation Comments</SPAN>
206
			</td>
207
			<td width="1" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
208
          </tr>
209
		  <%If objOsCollector.Item("base_env_id") <> "" Then%>
210
		  <tr>
211
		  	<td align="center" valign="top"></td>
212
			<td align="center" valign="top"></td>
213
            <td class="body_row" valign="top"><a href="Os_BaseConf.asp?<%=objPMod.ComposeURL()%>" class="body_link"><%=objOsCollector.Item("base_env_name")%></a></td>
214
			<td nowrap class="body_row" valign="top"></td>
15 rsolanki 215
			<td nowrap class="body_row" valign="top"></td>
13 rsolanki 216
            <td class="body_rowlite" valign="top">This base configuration contains the common operating system requirements and software applications.</td>
217
			<td align="center"></td>
218
          </tr>	
219
		  <tr>
220
            <td colspan="7" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
221
          </tr>
222
		  <%End If%>
223
		  <%
224
		  ' Load some action buttons
225
		  Call objBtnControl.LoadActionButtons ( Array("btnEditProd", "btnRemoveProd"), OraDatabase )
226
		  objBtnControl.ButtonSpacer = 1
227
 
228
		  OraDatabase.Parameters.Add "OS_ID", 	dbPARos_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
229
 
230
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ProductsList.sql"), ORADYN_DEFAULT )
231
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
232
		  	ProdId = rsQry("prod_id")
233
			ProdName = rsQry("pkg_name").Value
23 rsolanki 234
			ProdVersion = rsQry("pkg_version").Value
25 rsolanki 235
			pkgId = rsQry("pkg_id").Value
13 rsolanki 236
		  	selected = ""
15 rsolanki 237
			nodeSpec = ""
238
			If rsQry("is_node_spec") = "on" Then 
239
				nodeSpec = "checked"
240
			End If	
13 rsolanki 241
		  	If parHold_selection <> "" Then
242
 
243
				If IsTicked ( rsQry("prod_id"), Request("prod_id_list") ) Then 
244
					selected = "checked"
15 rsolanki 245
				End If			
13 rsolanki 246
			End If
247
		  %>
248
          <tr>
249
		  	<td align="center" valign="top"><input type="checkbox" name="prod_id_list" value="<%=ProdId%>" <%=selected%>></td>
250
			<td align="center" valign="top" class="body_txt"><%=rsQry("seq_num")%></td>
251
            <td nowrap class="body_row" valign="top"><a href="ProdDefault.asp?prod_id=<%=ProdId%>&<%=objPMod.ComposeURL()%>" class="body_link"><%=GetProductIcon(rsQry)  &  ProdName%></a></td>
25 rsolanki 252
			<%If NOT IsNull(objFormCollector.Item("is_download")) Then%>
253
			<td valign="top" nowrap class="body_row"><%=rsQry("pkg_version")%><a href="javascript:;" onClick="popup = window.open('LogDownload.asp?url=http://auperaunx26/releases/<%=projName%>/<%=branchName%>/<%=ProdName%>/<%=OSName%>/<%=rsQry("pkg_version")%>/<%=ProdName%>-<%=rsQry("pkg_version")%>-<%=OSName%>.zip&pkg_id=<%=pkgId%>&pkg_version=<%=rsQry("pkg_version")%>', 'Download Version', 'height=440,width=600,scrollbars=yes,resizable=yes'); return false" class="body_link"><img src="icons\i_folder_open.gif" border='0' align="right"></a></td>
254
			<%Else%>
13 rsolanki 255
			<td nowrap class="body_row" valign="top"><%=rsQry("pkg_version")%></td>
25 rsolanki 256
			<%End If%>
23 rsolanki 257
			<td nowrap class="body_row" valign="top"><input type="checkbox" name="node_spec_list" value="<%=ProdId%>" <%=nodeSpec%>></td>
25 rsolanki 258
 
13 rsolanki 259
            <td class="body_rowlite" valign="top">
260
				<DIV style="display:block;" id="SHORT_<%=ProdId%>" name="SHORT_<%=ProdId%>" >
261
					<a href="javascript:;" onclick="ToggleDisplay('SHORT_<%=ProdId%>','LONG_<%=ProdId%>');" class="body_rowlite" title="Click to see more...">Click to see more...</a>
262
				</DIV>
263
				<DIV style="display:none;" id="LONG_<%=ProdId%>" name="LONG_<%=ProdId%> style="display:none;">
264
					<a href="javascript:;" onclick="ToggleDisplay('SHORT_<%=ProdId%>','LONG_<%=ProdId%>');" class="body_row" title="Click to hide."><%=objFormater.TextToHtml( rsQry("product_comments") )%></a>
265
				</DIV>			
266
			</td>
23 rsolanki 267
			<%
268
 
269
			OraDatabase.Parameters.Add "PV_ID", 	ProdId,		ORAPARM_INPUT, ORATYPE_NUMBER
270
 
271
			Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery ("Package_Patches.sql"), ORADYN_DEFAULT )
272
 
273
			If rsTemp.RecordCount = 0 Then
274
 
275
 
276
			%>
13 rsolanki 277
			<td align="center" valign="top" bgcolor="#FAFAF6"><%Call objBtnControl.Render  ( Array("btnEditProd", "btnRemoveProd") )%></td>
278
          </tr>
23 rsolanki 279
		  <%
280
		  Else
281
		  %>
282
 
283
		  <td align="center" valign="top" bgcolor="#FAFAF6"><%Call objBtnControl.Render  ( Array("btnEditProd") )%></td>
284
          </tr>
285
		  <%
286
		  End If
287
 
288
		  OraDatabase.Parameters.Remove "PV_ID"
289
		  rsTemp.Close()
290
		  Set rsTemp = nothing
291
		  %>
13 rsolanki 292
		  <%rsQry.MoveNext%>
293
 
294
		  <%If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then%>
295
          <tr>
296
            <td colspan="6" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
297
          </tr>
298
		  <%End If%>
299
 
300
		  <%
301
		  WEnd
302
 
303
		  OraDatabase.Parameters.Remove "OS_ID"
304
		  %>
305
          <tr>
306
            <td colspan="6" background="images/bg_table_border.gif">
307
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
308
              <tr>
309
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
310
              </tr>
311
             </table>
312
			</td>
313
          </tr>
314
         </table>	
315
		<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
316
		</td>
317
      </tr>
318
	  <%=objPMod.ComposeHiddenTags()%>
15 rsolanki 319
 
13 rsolanki 320
	  <input type="hidden" name="action" value="true">
321
	</form>
322
    </table>
323
	</td>
324
    <td width="1%" valign="top" background="images/bg_favourits.gif">
325
	<!-- PERSONAL BAR +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
326
	<!--#include file="_personal_bar.asp"-->
327
	<!-- END OF PERSONAL BAR ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
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
Set objBtnControl = Nothing
354
'----------------------------------------------
355
%><!--#include file="common/globals_destructor.asp"-->