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
'|			          wAddProd					 	 |
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/_popup_window_common.asp"-->
17
<%
18
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<%
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsQry, healthTag, cmdInterface, pkgOwner, isInterface, package, procDesc
24
Dim Query_String
25
Dim objFormCollector
26
Dim sMessage
27
Dim SEQ_proc_id
28
'------------ CONSTANTS DECLARATION -----------
29
'------------ VARIABLE INIT -------------------
30
sMessage = NULL
31
isInterface = NULL
32
parOs_id = Request("os_id")
33
parBom_id = Request("bom_id")
34
Set objFormCollector = CreateObject("Scripting.Dictionary")
35
'------------ CONDITIONS ----------------------
36
'----------------------------------------------
37
'------------ RUN BEFORE PAGE RENDER ----------
38
If Request("btn") = "Import" Then
39
	If Request("prod_id_list") <> "" Then
40
 
41
		On Error Resume Next
42
 
43
		OraDatabase.Parameters.Add "PROD_ID", 		Request("prod_id_list"), 			ORAPARM_INPUT, ORATYPE_NUMBER 
44
		OraDatabase.Parameters.Add "OS_ID", 		Request("os_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER 
45
		OraDatabase.Parameters.Add "USER_ID", 		objAccessControl.UserId, 	ORAPARM_INPUT, ORATYPE_NUMBER 
46
 
47
		objEH.TryORA ( OraSession )
48
 
49
		OraDatabase.ExecuteSQL _
50
		"BEGIN   PK_OPERATING_SYSTEM.ADD_PACKAGES_PROCESS ( :PROD_ID, :OS_ID, :USER_ID );   END;"
51
 
52
		objEH.CatchORA ( OraSession )
53
 
54
		OraDatabase.Parameters.Remove "PROD_ID"	
55
		OraDatabase.Parameters.Remove "OS_ID"
56
		OraDatabase.Parameters.Remove "USER_ID"			
57
 
58
		If objEH.Finally Then
59
			Call OpenInParentWindow ("Os_Processes.asp?bom_id="& parBom_id &"&os_id="& parOs_id)
60
			Call CloseWindow()
61
		End If	
62
	Else
63
		sMessage = "Please select Product(s) from Release Manager list then click Add."
64
	End If
65
 
66
 
67
End If
68
 
69
If CBool(Request("action")) Then
70
 
71
 	If Request("isInterface") = "" Then
72
  		isInterface = "F"
73
  	Else
74
  		isInterface = "T"
75
  	End If	
76
 
77
	Query_String = _
78
	"	SELECT * FROM PROCESSES WHERE PROC_NAME = '"& Request("healthTag") &"'"&_
79
	"	AND RUN_AS = '"& Replace(Request("cmdInterface"), "'", "''") &"' AND PKG_OWNER = '"& Request("pkgOwner") &"'"&_
80
	"	AND IS_INTERFACE = '"& isInterface &"'"
81
 
82
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
83
 
84
	If rsTemp.RecordCount = 0 Then  	
85
 
86
		objEH.Try
87
 
88
		SEQ_proc_id = Get_From_DUAL("SEQ_PROC_ID.nextval")
89
 
90
		OraDatabase.Parameters.Add "PROC_ID", 			SEQ_proc_id, ORAPARM_INPUT, ORATYPE_NUMBER
91
		OraDatabase.Parameters.Add "PKG_HEALTH_TAG", 	Request("healthTag"), ORAPARM_INPUT, ORATYPE_VARCHAR2
92
		OraDatabase.Parameters.Add "PROC_DESC", 		Request("procDesc"), ORAPARM_INPUT, ORATYPE_VARCHAR2		
93
		OraDatabase.Parameters.Add "OS_ID", 			Request("os_id"), ORAPARM_INPUT, ORATYPE_NUMBER
94
		OraDatabase.Parameters.Add "CMD_INTERFACE", 	Request("cmdInterface"), ORAPARM_INPUT, ORATYPE_VARCHAR2
95
		OraDatabase.Parameters.Add "PKG_OWNER", 		Request("pkgOwner"), ORAPARM_INPUT, ORATYPE_VARCHAR2	
96
		OraDatabase.Parameters.Add "IS_INTERFACE", 		isInterface, ORAPARM_INPUT, ORATYPE_VARCHAR	
97
		OraDatabase.Parameters.Add "PROD_ID", 			Request("prod_id"), ORAPARM_INPUT, ORATYPE_NUMBER	
98
		OraDatabase.Parameters.Add "USER_ID", 			objAccessControl.UserId, 	ORAPARM_INPUT, ORATYPE_NUMBER 
99
 
100
		OraSession.BeginTrans
101
 
102
		OraDatabase.ExecuteSQL _
103
			"BEGIN  Add_Process( :PROC_ID, :PKG_HEALTH_TAG, :OS_ID, :CMD_INTERFACE, :PKG_OWNER, :IS_INTERFACE, :PROD_ID, :USER_ID);  END;"
104
 
105
	    OraSession.CommitTrans	
106
 
107
		OraSession.BeginTrans
108
 
109
		OraDatabase.ExecuteSQL _
110
		"BEGIN  RELEASE_MANAGER.PK_PACKAGE.ADD_PROCESS( :PROC_ID, :PKG_HEALTH_TAG, :PROC_DESC, :CMD_INTERFACE, :PKG_OWNER, :IS_INTERFACE, :PROD_ID, :USER_ID);  END;"	
111
 
112
	    OraSession.CommitTrans		
113
 
114
		OraDatabase.Parameters.Remove "PROC_ID"
115
		OraDatabase.Parameters.Remove "PKG_HEALTH_TAG"
5955 dpurdie 116
		OraDatabase.Parameters.Remove "PROC_DESC"
5355 dpurdie 117
		OraDatabase.Parameters.Remove "OS_ID"
118
		OraDatabase.Parameters.Remove "CMD_INTERFACE"
5955 dpurdie 119
		OraDatabase.Parameters.Remove "PKG_OWNER"
120
		OraDatabase.Parameters.Remove "IS_INTERFACE"
121
		OraDatabase.Parameters.Remove "PROD_ID"
122
		OraDatabase.Parameters.Remove "USER_ID"
5355 dpurdie 123
 
124
	If objEH.Finally Then
125
		Call OpenInParentWindow ("Os_Processes.asp?bom_id="& parBom_id &"&os_id="& parOs_id)
126
		Call CloseWindow()
127
	End If
128
	Else
129
		Call Messenger ("Cannot add process! The process already exists in the database. Select a product and search for the process by name.", 1, "100%")
130
	End If		
131
End If
132
 
133
'--------------------------------------------------------------------------------------------------------------------------
134
Sub GetFormDetails ( nBom_id, ByRef outobjDetails )
135
	Dim rsQry, query
136
	OraDatabase.Parameters.Add "BOM_ID", 		nBom_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
137
 
138
	query = _
139
	"  SELECT bo.RTAG_ID_FK,"&_
140
	"	   rm_proj.PROJ_ID,"&_
141
	"	   rm_proj.PROJ_NAME,"&_
142
	"	   rt.RTAG_NAME"&_
143
	"  FROM BOMS bo,"&_
144
	"	   PROJECTS rm_proj,"&_
145
	"	   RELEASE_TAGS rt"&_
146
	" WHERE rt.PROJ_ID = rm_proj.PROJ_ID"&_
147
	"   AND bo.RTAG_ID_FK = rt.RTAG_ID"&_
148
	"   AND bo.BOM_ID = :BOM_ID"
149
 
150
	Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
151
	If (NOT rsQry.BOF) AND (NOT rsQry.EOF)Then
152
		outobjDetails.Item ("rtag_id_fk") = rsQry("rtag_id_fk")
153
		outobjDetails.Item ("proj_id") = rsQry("proj_id")
154
		outobjDetails.Item ("proj_name") = rsQry("proj_name")
155
		outobjDetails.Item ("rtag_name") = rsQry("rtag_name")
156
 
157
	End If
158
 
159
 
160
	OraDatabase.Parameters.Remove "BOM_ID"
161
 
162
	rsQry.Close
163
	Set rsQry = Nothing
164
End Sub
165
'--------------------------------------------------------------------------------------------------------------------------
166
 
167
Call GetFormDetails ( parBom_id, objFormCollector )
168
'----------------------------------------------
169
%>
170
<html>
171
<head>
172
<title>Deployment Manager</title>
173
<link rel="shortcut icon" href="<%=FavIcon%>"/>
174
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
175
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6663 dpurdie 176
<link href="scripts/deployment_manager.css?ver=<%=VixVerNum%>" rel="stylesheet" type="text/css">
177
<script language="JavaScript" src="scripts/common.js?ver=<%=VixVerNum%>"></script>
5355 dpurdie 178
</head>
179
 
180
<body background="images/bg_bage_0.gif" leftmargin="0" topmargin="0" onLoad="self.focus();FormSearch.prod_name.focus();">
181
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
182
  <tr>
183
    <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/i_linkarrow_black.gif" width="11" height="11" align="absmiddle">&nbsp;Add Process</span> <br>
184
    Add a process for the node.
185
      </td>
186
  </tr>
187
 
188
<%
189
'-- FROM START ---------------------------------------------------------------------------------------------------------------
190
objFormComponent.FormName = "FormSearch"
191
objFormComponent.Action = "wAddProcessBySearch.asp"
192
Call objFormComponent.FormStart()
193
%>  
194
  <tr>
195
    <td background="images/bg_quicksearch.gif" class="body_txt"><table width="100" border="0" cellspacing="3" cellpadding="0">
196
  <tr>
197
    <td nowrap class="body_txtw"><strong>Package/Product</strong> </td>
198
    <td><%
199
	Dim rsTemp
200
 
201
	OraDatabase.Parameters.Add "OS_ID", 	Request("os_id"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
202
 
203
	Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ProductsLessPatches.sql"), cint(0))
204
 
205
 
206
	Response.write "<select name='prod_id' class='body_txt'>"
207
	Response.write "<option value =''>"
208
 
209
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
210
 
211
				Response.write "<option value='"& rsTemp.Fields("prod_id") &"'>"& (rsTemp.Fields("pkg_name")) &" - "& (rsTemp.Fields("pkg_version")) &"</option>"
212
 
213
			rsTemp.MoveNext
214
		WEnd
215
	Response.write "</select>"
216
 
217
	rsTemp.Close
218
	Set rsTemp = nothing	
219
 
220
	OraDatabase.Parameters.Remove "OS_ID"
221
 
222
	%></td>
223
  </tr>       
224
	    <tr>
225
          <td nowrap class="body_txtw"><strong>Process Search</strong> </td>
226
          <td><input name="prod_name" type="text" class="body_txt" size="20"></td>
227
          <td><input name="btn" type="image" src="icons/b_search.gif" width="16" height="16" border="0"></td>
228
        </tr>
229
      </table></td>
230
  </tr>
231
  <%=objPMod.ComposeHiddenTags()%>
232
<%
233
Call objFormComponent.FormEnd()
234
'-- FROM END ----------------------------------------------------------------------------------------------------------------
235
%>
236
 
237
<%
238
'-- FROM START --------------------------------------------------------------------------------------------------------------
239
objFormComponent.FormName = "FormName"
240
objFormComponent.Action = SCRIPT_NAME
241
objFormComponent.OnSubmit = "ShowProgress();"
242
Call objFormComponent.FormStart()
243
 
244
%>  
245
  <tr>
246
    <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
247
      <tr>
248
        <td><%=ProgressBar()%></td>
249
        <td align="right"><input name="btn" type="submit" class="form_btn" value="Add">
250
          <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();"></td>
251
      </tr>
252
    </table></td>
253
  </tr>
254
  <tr>
255
    <td>
256
<!-- NEW PRODUCT ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->		
257
	<%Call Messenger ( sMessage , 3, "100%" )%>
258
	<!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->	
259
	<!--#include file="messages/_msg_inline.asp"-->
260
<table width="664" border="0">
261
  <tr>
262
    <td><span class="body_txt">Package Health Tag</span>&nbsp;</td>
263
    <td><input name="healthTag" type="text" class="body_txt" value="<%=healthTag%>">&nbsp;</td>
264
  </tr>
265
  <tr>
266
    <td><span class="body_txt">Package/Product</span></td>
267
    <td><%
268
 
269
 
270
	OraDatabase.Parameters.Add "OS_ID", 	Request("os_id"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
271
 
272
	Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ProductsLessPatches.sql"), cint(0))
273
 
274
 
275
	Response.write "<select name='prod_id' class='body_txt'>"
276
	Response.write "<option value =''>"
277
 
278
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
279
 
280
				Response.write "<option value='"& rsTemp.Fields("prod_id") &"'>"& (rsTemp.Fields("pkg_name")) &" - "& (rsTemp.Fields("pkg_version")) &"</option>"
281
 
282
			rsTemp.MoveNext
283
		WEnd
284
	Response.write "</select>"
285
 
286
	rsTemp.Close
287
	Set rsTemp = nothing	
288
 
289
	OraDatabase.Parameters.Remove "OS_ID"
290
 
291
	%></td>
292
  </tr>
293
  <tr>
294
    <td><span class="body_txt">Process Description</span></td>
295
    <td><textarea name="procDesc" rows=3 cols=50 class="body_txt"><%=procDesc%></textarea>
296
	</td>
297
  </tr>  
298
  <tr>
299
    <td><span class="body_txt">Command Interface</span></td>
300
    <td><input name="cmdInterface" type="text" class="body_txt" value="<%=cmdInterface%>" size=80></td>
301
  </tr>
302
  <tr>
303
    <td><span class="body_txt">Is Interface</span></td>
304
    <td><input type="checkbox" name="isInterface">
305
      <span class="body_txt">(Checked If True)</span> </td>
306
  </tr>
307
  <tr>
308
    <td><span class="body_txt">Package Owner</span></td>
309
    <td><input name="pkgOwner" type="text" class="body_txt" value="<%=pkgOwner%>">
310
	</td>
311
  </tr>
312
  <tr>
313
    <td>&nbsp;</td>
314
    <td>&nbsp;</td>
315
  </tr>
316
</table>    
317
 
318
 
319
 
320
 
321
 
322
 
323
</td>
324
  </tr>
325
  <%=objPMod.ComposeHiddenTags()%>
326
  <input type="hidden" name="action" value="true">
327
 
328
 
329
<%
330
Call objFormComponent.FormEnd()
331
'-- FROM END ----------------------------------------------------------------------------------------------------------------
332
%>
333
<%
334
'-- FROM START ---------------------------------------------------------------------------------------------------------------
335
objFormComponent.FormName = "FormSearch"
336
objFormComponent.Action = SCRIPT_NAME
337
Call objFormComponent.FormStart()
338
%>
339
<td width="50%" valign="top" nowrap class="body_txt"><strong>Add Product Processes from Release Manager</strong><br>     
340
<%If (objFormCollector.Item("rtag_id_fk") <> "")  Then%>
341
<%=objFormCollector.Item ("proj_name") &"&nbsp;/&nbsp;"& objFormCollector.Item ("rtag_name")%>
342
<%Else%>
343
<%Call Messenger ( "This BOM does not have Release Manager Reference release.<br>Please edit BOM properties first.<br>" , 1, "100%" )%>
344
<%End If%>
345
<br>
346
          <table width="100%"  border="0" cellspacing="3" cellpadding="0">
347
            <tr>
348
              <td width="1"><img src="images/spacer.gif" width="1" height="1"></td>
349
              <td width="100%"><img src="images/spacer.gif" width="1" height="1"></td>
350
            </tr>
351
            <%
352
	  ' -- Only run if links with Release Manager
353
	  If (objFormCollector.Item("rtag_id_fk") <> "")  Then
354
 
355
		  '===== Release Manager PRODUCTS =====
356
		  OraDatabase.Parameters.Add "RTAG_ID_FK", 				objFormCollector.Item("rtag_id_fk"),	ORAPARM_INPUT, ORATYPE_NUMBER 
357
		  OraDatabase.Parameters.Add "enumPRODUCTS_BASE_VIEW_ID", 	enumPRODUCTS_BASE_VIEW_ID,				ORAPARM_INPUT, ORATYPE_NUMBER 
358
		  OraDatabase.Parameters.Add "OS_ID", 						parOs_id,								ORAPARM_INPUT, ORATYPE_NUMBER 
359
 
360
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseManagerProductsViewProcesses.sql"), ORADYN_DEFAULT )
361
 
362
		  If rsQry.RecordCount < 1 Then
363
		  	Response.write "No Products Found."
364
		  End If
365
 
366
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
367
		  %>
368
            <tr>
369
              <td nowrap class="form_iname"><input type="checkbox" name="prod_id_list" value="<%=rsQry("prod_id")%>" <%=rsQry("used")%>></td>
370
              <td nowrap class="body_txt"><%=Eval( rsQry("icon") )%><%=rsQry("pkg_name") &" "& rsQry("pkg_version")%></td>
371
            </tr>
372
            <%rsQry.MoveNext%>
373
            <%
374
		  WEnd
5955 dpurdie 375
		  OraDatabase.Parameters.Remove "RTAG_ID_FK"
5355 dpurdie 376
		  OraDatabase.Parameters.Remove "enumPRODUCTS_BASE_VIEW_ID"
377
		  OraDatabase.Parameters.Remove "OS_ID"
378
 
379
	  End If		  
380
 
381
 
382
 
383
		  %>
384
		  </table>
385
<input name="btn" type="submit" class="form_btn" value="Import">
386
 
387
</td>
388
  <%=objPMod.ComposeHiddenTags()%>
389
 
390
 
391
 
392
<%
393
Call objFormComponent.FormEnd()
394
%>
395
</table>
396
</body>
397
</html>
5958 dpurdie 398
<!--#include file="common/globals_destructor.asp"-->