Subversion Repositories DevTools

Rev

Go to most recent revision | Details | 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"
116
		OraDatabase.Parameters.Remove "OS_ID"
117
		OraDatabase.Parameters.Remove "CMD_INTERFACE"
118
		OraDatabase.Parameters.Remove "PKG_OWNER"		
119
		OraDatabase.Parameters.Remove "IS_INTERFACE"	
120
		OraDatabase.Parameters.Remove "PROD_ID"		
121
		OraDatabase.Parameters.Remove "USER_ID"			
122
 
123
	If objEH.Finally Then
124
		Call OpenInParentWindow ("Os_Processes.asp?bom_id="& parBom_id &"&os_id="& parOs_id)
125
		Call CloseWindow()
126
	End If
127
	Else
128
		Call Messenger ("Cannot add process! The process already exists in the database. Select a product and search for the process by name.", 1, "100%")
129
	End If		
130
End If
131
 
132
'--------------------------------------------------------------------------------------------------------------------------
133
Sub GetFormDetails ( nBom_id, ByRef outobjDetails )
134
	Dim rsQry, query
135
	OraDatabase.Parameters.Add "BOM_ID", 		nBom_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
136
 
137
	query = _
138
	"  SELECT bo.RTAG_ID_FK,"&_
139
	"	   rm_proj.PROJ_ID,"&_
140
	"	   rm_proj.PROJ_NAME,"&_
141
	"	   rt.RTAG_NAME"&_
142
	"  FROM BOMS bo,"&_
143
	"	   PROJECTS rm_proj,"&_
144
	"	   RELEASE_TAGS rt"&_
145
	" WHERE rt.PROJ_ID = rm_proj.PROJ_ID"&_
146
	"   AND bo.RTAG_ID_FK = rt.RTAG_ID"&_
147
	"   AND bo.BOM_ID = :BOM_ID"
148
 
149
	Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
150
	If (NOT rsQry.BOF) AND (NOT rsQry.EOF)Then
151
		outobjDetails.Item ("rtag_id_fk") = rsQry("rtag_id_fk")
152
		outobjDetails.Item ("proj_id") = rsQry("proj_id")
153
		outobjDetails.Item ("proj_name") = rsQry("proj_name")
154
		outobjDetails.Item ("rtag_name") = rsQry("rtag_name")
155
 
156
	End If
157
 
158
 
159
	OraDatabase.Parameters.Remove "BOM_ID"
160
 
161
	rsQry.Close
162
	Set rsQry = Nothing
163
End Sub
164
'--------------------------------------------------------------------------------------------------------------------------
165
 
166
Call GetFormDetails ( parBom_id, objFormCollector )
167
'----------------------------------------------
168
%>
169
<html>
170
<head>
171
<title>Deployment Manager</title>
172
<link rel="shortcut icon" href="<%=FavIcon%>"/>
173
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
174
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
175
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
176
<script language="JavaScript" src="scripts/common.js"></script>
177
</head>
178
 
179
<body background="images/bg_bage_0.gif" leftmargin="0" topmargin="0" onLoad="self.focus();FormSearch.prod_name.focus();">
180
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
181
  <tr>
182
    <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>
183
    Add a process for the node.
184
      </td>
185
  </tr>
186
 
187
<%
188
'-- FROM START ---------------------------------------------------------------------------------------------------------------
189
objFormComponent.FormName = "FormSearch"
190
objFormComponent.Action = "wAddProcessBySearch.asp"
191
Call objFormComponent.FormStart()
192
%>  
193
  <tr>
194
    <td background="images/bg_quicksearch.gif" class="body_txt"><table width="100" border="0" cellspacing="3" cellpadding="0">
195
  <tr>
196
    <td nowrap class="body_txtw"><strong>Package/Product</strong> </td>
197
    <td><%
198
	Dim rsTemp
199
 
200
	OraDatabase.Parameters.Add "OS_ID", 	Request("os_id"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
201
 
202
	Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ProductsLessPatches.sql"), cint(0))
203
 
204
 
205
	Response.write "<select name='prod_id' class='body_txt'>"
206
	Response.write "<option value =''>"
207
 
208
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
209
 
210
				Response.write "<option value='"& rsTemp.Fields("prod_id") &"'>"& (rsTemp.Fields("pkg_name")) &" - "& (rsTemp.Fields("pkg_version")) &"</option>"
211
 
212
			rsTemp.MoveNext
213
		WEnd
214
	Response.write "</select>"
215
 
216
	rsTemp.Close
217
	Set rsTemp = nothing	
218
 
219
	OraDatabase.Parameters.Remove "OS_ID"
220
 
221
	%></td>
222
  </tr>       
223
	    <tr>
224
          <td nowrap class="body_txtw"><strong>Process Search</strong> </td>
225
          <td><input name="prod_name" type="text" class="body_txt" size="20"></td>
226
          <td><input name="btn" type="image" src="icons/b_search.gif" width="16" height="16" border="0"></td>
227
        </tr>
228
      </table></td>
229
  </tr>
230
  <%=objPMod.ComposeHiddenTags()%>
231
<%
232
Call objFormComponent.FormEnd()
233
'-- FROM END ----------------------------------------------------------------------------------------------------------------
234
%>
235
 
236
<%
237
'-- FROM START --------------------------------------------------------------------------------------------------------------
238
objFormComponent.FormName = "FormName"
239
objFormComponent.Action = SCRIPT_NAME
240
objFormComponent.OnSubmit = "ShowProgress();"
241
Call objFormComponent.FormStart()
242
 
243
%>  
244
  <tr>
245
    <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
246
      <tr>
247
        <td><%=ProgressBar()%></td>
248
        <td align="right"><input name="btn" type="submit" class="form_btn" value="Add">
249
          <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();"></td>
250
      </tr>
251
    </table></td>
252
  </tr>
253
  <tr>
254
    <td>
255
<!-- NEW PRODUCT ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->		
256
	<%Call Messenger ( sMessage , 3, "100%" )%>
257
	<!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->	
258
	<!--#include file="messages/_msg_inline.asp"-->
259
<table width="664" border="0">
260
  <tr>
261
    <td><span class="body_txt">Package Health Tag</span>&nbsp;</td>
262
    <td><input name="healthTag" type="text" class="body_txt" value="<%=healthTag%>">&nbsp;</td>
263
  </tr>
264
  <tr>
265
    <td><span class="body_txt">Package/Product</span></td>
266
    <td><%
267
 
268
 
269
	OraDatabase.Parameters.Add "OS_ID", 	Request("os_id"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
270
 
271
	Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ProductsLessPatches.sql"), cint(0))
272
 
273
 
274
	Response.write "<select name='prod_id' class='body_txt'>"
275
	Response.write "<option value =''>"
276
 
277
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
278
 
279
				Response.write "<option value='"& rsTemp.Fields("prod_id") &"'>"& (rsTemp.Fields("pkg_name")) &" - "& (rsTemp.Fields("pkg_version")) &"</option>"
280
 
281
			rsTemp.MoveNext
282
		WEnd
283
	Response.write "</select>"
284
 
285
	rsTemp.Close
286
	Set rsTemp = nothing	
287
 
288
	OraDatabase.Parameters.Remove "OS_ID"
289
 
290
	%></td>
291
  </tr>
292
  <tr>
293
    <td><span class="body_txt">Process Description</span></td>
294
    <td><textarea name="procDesc" rows=3 cols=50 class="body_txt"><%=procDesc%></textarea>
295
	</td>
296
  </tr>  
297
  <tr>
298
    <td><span class="body_txt">Command Interface</span></td>
299
    <td><input name="cmdInterface" type="text" class="body_txt" value="<%=cmdInterface%>" size=80></td>
300
  </tr>
301
  <tr>
302
    <td><span class="body_txt">Is Interface</span></td>
303
    <td><input type="checkbox" name="isInterface">
304
      <span class="body_txt">(Checked If True)</span> </td>
305
  </tr>
306
  <tr>
307
    <td><span class="body_txt">Package Owner</span></td>
308
    <td><input name="pkgOwner" type="text" class="body_txt" value="<%=pkgOwner%>">
309
	</td>
310
  </tr>
311
  <tr>
312
    <td>&nbsp;</td>
313
    <td>&nbsp;</td>
314
  </tr>
315
</table>    
316
 
317
 
318
 
319
 
320
 
321
 
322
</td>
323
  </tr>
324
  <%=objPMod.ComposeHiddenTags()%>
325
  <input type="hidden" name="action" value="true">
326
 
327
 
328
<%
329
Call objFormComponent.FormEnd()
330
'-- FROM END ----------------------------------------------------------------------------------------------------------------
331
%>
332
<%
333
'-- FROM START ---------------------------------------------------------------------------------------------------------------
334
objFormComponent.FormName = "FormSearch"
335
objFormComponent.Action = SCRIPT_NAME
336
Call objFormComponent.FormStart()
337
%>
338
<td width="50%" valign="top" nowrap class="body_txt"><strong>Add Product Processes from Release Manager</strong><br>     
339
<%If (objFormCollector.Item("rtag_id_fk") <> "")  Then%>
340
<%=objFormCollector.Item ("proj_name") &"&nbsp;/&nbsp;"& objFormCollector.Item ("rtag_name")%>
341
<%Else%>
342
<%Call Messenger ( "This BOM does not have Release Manager Reference release.<br>Please edit BOM properties first.<br>" , 1, "100%" )%>
343
<%End If%>
344
<br>
345
          <table width="100%"  border="0" cellspacing="3" cellpadding="0">
346
            <tr>
347
              <td width="1"><img src="images/spacer.gif" width="1" height="1"></td>
348
              <td width="100%"><img src="images/spacer.gif" width="1" height="1"></td>
349
            </tr>
350
            <%
351
	  ' -- Only run if links with Release Manager
352
	  If (objFormCollector.Item("rtag_id_fk") <> "")  Then
353
 
354
		  '===== Release Manager PRODUCTS =====
355
		  OraDatabase.Parameters.Add "RTAG_ID_FK", 				objFormCollector.Item("rtag_id_fk"),	ORAPARM_INPUT, ORATYPE_NUMBER 
356
		  OraDatabase.Parameters.Add "enumPRODUCTS_BASE_VIEW_ID", 	enumPRODUCTS_BASE_VIEW_ID,				ORAPARM_INPUT, ORATYPE_NUMBER 
357
		  OraDatabase.Parameters.Add "OS_ID", 						parOs_id,								ORAPARM_INPUT, ORATYPE_NUMBER 
358
 
359
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseManagerProductsViewProcesses.sql"), ORADYN_DEFAULT )
360
 
361
		  If rsQry.RecordCount < 1 Then
362
		  	Response.write "No Products Found."
363
		  End If
364
 
365
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
366
		  %>
367
            <tr>
368
              <td nowrap class="form_iname"><input type="checkbox" name="prod_id_list" value="<%=rsQry("prod_id")%>" <%=rsQry("used")%>></td>
369
              <td nowrap class="body_txt"><%=Eval( rsQry("icon") )%><%=rsQry("pkg_name") &" "& rsQry("pkg_version")%></td>
370
            </tr>
371
            <%rsQry.MoveNext%>
372
            <%
373
		  WEnd
374
		  OraDatabase.Parameters.Remove "RM_BRANCH_ID"
375
		  OraDatabase.Parameters.Remove "enumPRODUCTS_BASE_VIEW_ID"
376
		  OraDatabase.Parameters.Remove "OS_ID"
377
 
378
	  End If		  
379
 
380
 
381
 
382
		  %>
383
		  </table>
384
<input name="btn" type="submit" class="form_btn" value="Import">
385
 
386
</td>
387
  <%=objPMod.ComposeHiddenTags()%>
388
 
389
 
390
 
391
<%
392
Call objFormComponent.FormEnd()
393
%>
394
</table>
395
</body>
396
</html>
397
<%
398
'------------ RUN AFTER PAGE RENDER -----------
399
Set objFormCollector = Nothing
400
'----------------------------------------------
401
%><!--#include file="common/globals_destructor.asp"-->