Subversion Repositories DevTools

Rev

Rev 29 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 29 Rev 5355
Line 1... Line 1...
1
<%@LANGUAGE="VBSCRIPT"%>
1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
2
<%
3
'=====================================================
3
'=====================================================
4
'|                                                   |
4
'|                                                   |
5
'|			          ReleaseTo				 	 |
5
'|			          ReleaseTo				 	 |
6
'|                                                   |
6
'|                                                   |
7
'=====================================================
7
'=====================================================
8
%>
8
%>
9
<%
9
<%
10
Option explicit
10
Option explicit
11
Response.Expires = 0
11
Response.Expires = 0
12
%>
12
%>
13
<!--#include file="common/globals.asp"-->
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_form_window_common.asp"-->
16
<!--#include file="common/_form_window_common.asp"-->
17
<%
17
<%
18
'------------ ACCESS CONTROL ------------------
18
'------------ ACCESS CONTROL ------------------
19
%>
19
%>
20
<!--#include file="_access_control_general.asp"-->
20
<!--#include file="_access_control_general.asp"-->
21
<%
21
<%
22
'------------ VARIABLE DEFINITION -------------
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsQry
23
Dim rsQry
24
Dim parState_id
24
Dim parState_id
25
Dim parBom_id_list
25
Dim parBom_id_list
26
Dim parParentBomId
26
Dim parParentBomId
27
'------------ CONSTANTS DECLARATION -----------
27
'------------ CONSTANTS DECLARATION -----------
28
'------------ VARIABLE INIT -------------------
28
'------------ VARIABLE INIT -------------------
29
parState_id = Request("state_id")
29
parState_id = Request("state_id")
30
parBom_id_list = Request("bom_id_list")
30
parBom_id_list = Request("bom_id_list")
31
parParentBomId = Request("parent_bom_id")
31
parParentBomId = Request("parent_bom_id")
32
'------------ CONDITIONS ----------------------
32
'------------ CONDITIONS ----------------------
33
'----------------------------------------------
33
'----------------------------------------------
34
%>
34
%>
35
<%
35
<%
36
'--------------------------------------------------------------------------------------------------------------------------
36
'--------------------------------------------------------------------------------------------------------------------------
37
Sub GetFormDetails ( nState_id, ByRef outobjDetails )
37
Sub GetFormDetails ( nState_id, ByRef outobjDetails )
38
	Dim rsQry, query
38
	Dim rsQry, query
39
	OraDatabase.Parameters.Add "STATE_ID", 		nState_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
39
	OraDatabase.Parameters.Add "STATE_ID", 		nState_id,		ORAPARM_INPUT, ORATYPE_NUMBER 
40
	
40
	
41
	query = _
41
	query = _
42
	" SELECT st.STATE_SEQ FROM STATES st WHERE st.STATE_ID = :STATE_ID"
42
	" SELECT st.STATE_SEQ FROM STATES st WHERE st.STATE_ID = :STATE_ID"
43
	
43
	
44
	Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
44
	Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
45
	
45
	
46
	If rsQry.RecordCount > 0 Then
46
	If rsQry.RecordCount > 0 Then
47
		outobjDetails.Item ("state_seq") = rsQry("state_seq")
47
		outobjDetails.Item ("state_seq") = rsQry("state_seq")
48
		
48
		
49
	End If
49
	End If
50
	
50
	
51
	OraDatabase.Parameters.Remove "STATE_ID"
51
	OraDatabase.Parameters.Remove "STATE_ID"
52
	
52
	
53
	rsQry.Close
53
	rsQry.Close
54
	Set rsQry = Nothing
54
	Set rsQry = Nothing
55
End Sub
55
End Sub
56
'--------------------------------------------------------------------------------------------------------------------------
56
'--------------------------------------------------------------------------------------------------------------------------
57
Sub ReleaseTo ()
57
Sub ReleaseTo ()
58
	On Error Resume Next
58
	On Error Resume Next
59
	
59
	
60
	OraDatabase.Parameters.Add "BOM_ID", 		Request("bom_id_list"), 		ORAPARM_INPUT, ORATYPE_NUMBER
60
	OraDatabase.Parameters.Add "BOM_ID", 		Request("bom_id_list"), 		ORAPARM_INPUT, ORATYPE_NUMBER
61
	OraDatabase.Parameters.Add "USER_ID", 		objAccessControl.UserId, 		ORAPARM_INPUT, ORATYPE_NUMBER 
61
	OraDatabase.Parameters.Add "USER_ID", 		objAccessControl.UserId, 		ORAPARM_INPUT, ORATYPE_NUMBER 
62
	OraDatabase.Parameters.Add "TOSTATE_ID", 	Request("tostate_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER 
62
	OraDatabase.Parameters.Add "TOSTATE_ID", 	Request("tostate_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER 
63
	OraDatabase.Parameters.Add "COMMENTS", 		Request("release_to_comments"), ORAPARM_INPUT, ORATYPE_VARCHAR2
63
	OraDatabase.Parameters.Add "COMMENTS", 		Request("release_to_comments"), ORAPARM_INPUT, ORATYPE_VARCHAR2
64
	
64
	
65
	
65
	
66
	objEH.TryORA ( OraSession )
66
	objEH.TryORA ( OraSession )
67
	
67
	
68
	OraDatabase.ExecuteSQL _
68
	OraDatabase.ExecuteSQL _
69
	"BEGIN   pk_Bom.Release_To ( :BOM_ID, :USER_ID, :TOSTATE_ID, :COMMENTS );   END;"
69
	"BEGIN   pk_Bom.Release_To ( :BOM_ID, :USER_ID, :TOSTATE_ID, :COMMENTS );   END;"
70
	
70
	
71
	objEH.CatchORA ( OraSession )
71
	objEH.CatchORA ( OraSession )
72
	
72
	
73
	
73
	
74
	OraDatabase.Parameters.Remove "BOM_ID"
74
	OraDatabase.Parameters.Remove "BOM_ID"
75
	OraDatabase.Parameters.Remove "USER_ID"
75
	OraDatabase.Parameters.Remove "USER_ID"
76
	OraDatabase.Parameters.Remove "TOSTATE_ID"
76
	OraDatabase.Parameters.Remove "TOSTATE_ID"
77
	OraDatabase.Parameters.Remove "COMMENTS"
77
	OraDatabase.Parameters.Remove "COMMENTS"
78
	
78
	
79
End Sub
79
End Sub
80
'--------------------------------------------------------------------------------------------------------------------------
80
'--------------------------------------------------------------------------------------------------------------------------
81
Sub CheckPackages ()
81
Sub CheckPackages ()
82
	'On Error Resume Next
82
	'On Error Resume Next
83
	Dim objWSH, IntReturn
83
	Dim objWSH, IntReturn
84
	Set objWSH = Server.CreateObject("WScript.Shell")
84
	Set objWSH = Server.CreateObject("WScript.Shell")
85
 
85
 
86
	objWSH.Run   "cmd.exe /c cscript.exe //B //NoLogo "& APP_ROOT &"\jobs\CheckForPackageVersions.wsf /user_name:"&objAccessControl.UserName&" /bom_id:"& parBom_id_list&" /compare_bom_id:"&parParentBomId , 0, False
86
	objWSH.Run   "cmd.exe /c cscript.exe //B //NoLogo "& APP_ROOT &"\jobs\CheckForPackageVersions.wsf /user_name:"&objAccessControl.UserName&" /bom_id:"& parBom_id_list&" /compare_bom_id:"&parParentBomId , 0, False
87
 
87
 
88
	Set objWSH = nothing
88
	Set objWSH = nothing
89
	
89
	
90
End Sub
90
End Sub
91
'--------------------------------------------------------------------------------------------------------------------------
91
'--------------------------------------------------------------------------------------------------------------------------
92
%>
92
%>
93
<%
93
<%
94
'------------ RUN BEFORE PAGE RENDER ----------
94
'------------ RUN BEFORE PAGE RENDER ----------
95
' --- Get Form details from DB ---
95
' --- Get Form details from DB ---
96
Call GetFormDetails ( Request("state_id"), objFormCollector )
96
Call GetFormDetails ( Request("state_id"), objFormCollector )
97
 
97
 
98
' --- Load Validation Rules ---
98
' --- Load Validation Rules ---
99
Call objForm.LoadValidationRules ( Array("release_to_comments"), OraDatabase )		' Load Validation Rules
99
Call objForm.LoadValidationRules ( Array("release_to_comments"), OraDatabase )		' Load Validation Rules
100
 
100
 
101
' --- Enter Form Validation Rule Changes here... ----
101
' --- Enter Form Validation Rule Changes here... ----
102
'----------------------------------------------------
102
'----------------------------------------------------
103
 
103
 
104
' --- RUN onPostBack ---
104
' --- RUN onPostBack ---
105
If Request("action") <> "" Then
105
If Request("action") <> "" Then
106
	If objForm.IsValidOnPostBack Then
106
	If objForm.IsValidOnPostBack Then
107
		' --- Form is Valid ---
107
		' --- Form is Valid ---
108
		Call ReleaseTo()
108
		Call ReleaseTo()
109
		If Request("proj_id") = 122 Then
109
		If Request("proj_id") = 122 Then
110
			Call CheckPackages()
110
			Call CheckPackages()
111
		End If
111
		End If
112
			
112
			
113
		If objEH.Finally Then
113
		If objEH.Finally Then
114
			Call OpenInWindow ( Request("rfile") &"?DONE=OK"& objPMod.ComposeURLWithout("rfile") )
114
			Call OpenInWindow ( Request("rfile") &"?DONE=OK"& objPMod.ComposeURLWithout("rfile") )
115
		End If
115
		End If
116
		
116
		
117
	End If
117
	End If
118
End If
118
End If
119
 
119
 
120
'----------------------------------------------
120
'----------------------------------------------
121
%>
121
%>
122
<html>
122
<html>
123
<head>
123
<head>
124
<title>Deployment Manager</title>
124
<title>Deployment Manager</title>
125
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
125
<link rel="shortcut icon" href="<%=FavIcon%>"/>
126
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
126
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
127
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
127
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
128
<script language="JavaScript" src="scripts/common.js"></script>
128
<link href="scripts/deployment_manager.css" rel="stylesheet" type="text/css">
129
 
129
<script language="JavaScript" src="scripts/common.js"></script>
130
</head>
130
 
131
<body background="images/bg_lite_blue.gif" leftmargin="0" topmargin="0" onLoad="FormName.release_to_comments.focus();">
131
</head>
132
<!-- HEADER ++++++++++++++++ -->
132
<body background="images/bg_lite_blue.gif" leftmargin="0" topmargin="0" onLoad="FormName.release_to_comments.focus();">
133
<!--#include file="_header.asp"-->
133
<!-- HEADER ++++++++++++++++ -->
134
<!-- +++++++++++++++++++++++ -->
134
<!--#include file="_header.asp"-->
135
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
135
<!-- +++++++++++++++++++++++ -->
136
<form name="FormName" method="post" action="<%=SCRIPT_NAME%>" onSubmit="ShowProgress();">
136
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
137
<%
137
<form name="FormName" method="post" action="<%=SCRIPT_NAME%>" onSubmit="ShowProgress();">
138
	Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM BOMS WHERE BOM_ID="&parBom_id_list, ORADYN_DEFAULT )
138
<%
139
	parParentBomId = rsQry("parent_bom_id")	
139
	Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM BOMS WHERE BOM_ID="&parBom_id_list, ORADYN_DEFAULT )
140
	rsQry.Close()
140
	parParentBomId = rsQry("parent_bom_id")	
141
	Set rsQry = nothing
141
	rsQry.Close()
142
%>
142
	Set rsQry = nothing
143
 
143
%>
144
  <tr>
144
 
145
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
145
  <tr>
146
  </tr>
146
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
147
  <tr>
147
  </tr>
148
    <td align="center" valign="middle" bgcolor="#FFFFFF">
148
  <tr>
149
	<!-- LOGIN FROM ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
149
    <td align="center" valign="middle" bgcolor="#FFFFFF">
150
    <table width="570" border="0" cellspacing="0" cellpadding="1">
150
	<!-- LOGIN FROM ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
151
        <tr>
151
    <table width="570" border="0" cellspacing="0" cellpadding="1">
152
          <td background="images/bg_bage_2.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
152
        <tr>
153
            <tr>
153
          <td background="images/bg_bage_2.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
154
              <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="10">
154
            <tr>
155
                <tr>
155
              <td bgcolor="#FFFFFF"><table width="100%"  border="0" cellspacing="0" cellpadding="10">
156
                  <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/mi_release_to.gif" width="19" height="19" align="absmiddle" border="0">&nbsp;Release BOM</span> <br>
156
                <tr>
157
      			Select where do you want to release BOM.</td>
157
                  <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="icons/mi_release_to.gif" width="19" height="19" align="absmiddle" border="0">&nbsp;Release BOM</span> <br>
158
                </tr>
158
      			Select where do you want to release BOM.</td>
159
                <tr>
159
                </tr>
160
                  <td background="images/bg_bage_0.gif"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
160
                <tr>
161
                      <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
161
                  <td background="images/bg_bage_0.gif"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
162
                      <%If NOT objEH.Finally Then%>
162
                      <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
163
                      <tr>
163
                      <%If NOT objEH.Finally Then%>
164
                        <td class="form_iname">&nbsp;</td>
164
                      <tr>
165
                        <td>
165
                        <td class="form_iname">&nbsp;</td>
166
                          <%objEH.DisplayMessage()%>
166
                        <td>
167
                        </td>
167
                          <%objEH.DisplayMessage()%>
168
                        <td class="val_err"></td>
168
                        </td>
169
                      </tr>
169
                        <td class="val_err"></td>
170
                      <%End If%>
170
                      </tr>
171
                      <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
171
                      <%End If%>
172
                      <tr>
172
                      <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
173
                        <td valign="top" nowrap class="form_iname">Release To </td>
173
                      <tr>
174
                        <td valign="top" class="body_txt">
174
                        <td valign="top" nowrap class="form_iname">Release To </td>
175
                          <select name="tostate_id" class="form_ivalue" >
175
                        <td valign="top" class="body_txt">
176
                          <%
176
                          <select name="tostate_id" class="form_ivalue" >
177
						  OraDatabase.Parameters.Add "TOSTATE_ID",  Request("tostate_id"),					ORAPARM_INPUT, ORATYPE_NUMBER 
177
                          <%
178
						  OraDatabase.Parameters.Add "PROJ_ID",   Request("proj_id"),					ORAPARM_INPUT, ORATYPE_NUMBER 
178
						  OraDatabase.Parameters.Add "TOSTATE_ID",  Request("tostate_id"),					ORAPARM_INPUT, ORATYPE_NUMBER 
179
						  OraDatabase.Parameters.Add "STATE_SEQ", objFormCollector.Item("state_seq"),	ORAPARM_INPUT, ORATYPE_NUMBER 
179
						  OraDatabase.Parameters.Add "PROJ_ID",   Request("proj_id"),					ORAPARM_INPUT, ORATYPE_NUMBER 
180
						  
180
						  OraDatabase.Parameters.Add "STATE_SEQ", objFormCollector.Item("state_seq"),	ORAPARM_INPUT, ORATYPE_NUMBER 
181
						  
181
						  
182
						  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseToStateList.sql"), ORADYN_DEFAULT )
182
						  
183
						  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
183
						  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseToStateList.sql"), ORADYN_DEFAULT )
184
						  %>
184
						  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
185
                            <option value="<%=rsQry("state_id")%>" <%=rsQry("selected")%>><%=rsQry("state_name").Value%></option>
185
						  %>
186
                          <%
186
                            <option value="<%=rsQry("state_id")%>" <%=rsQry("selected")%>><%=rsQry("state_name").Value%></option>
187
						  	rsQry.MoveNext
187
                          <%
188
						  WEnd
188
						  	rsQry.MoveNext
189
						  rsQry.Close
189
						  WEnd
190
						  
190
						  rsQry.Close
191
						  OraDatabase.Parameters.Remove "TOSTATE_ID"
191
						  
192
						  OraDatabase.Parameters.Remove "PROJ_ID"
192
						  OraDatabase.Parameters.Remove "TOSTATE_ID"
193
						  OraDatabase.Parameters.Remove "STATE_SEQ"
193
						  OraDatabase.Parameters.Remove "PROJ_ID"
194
						  %>
194
						  OraDatabase.Parameters.Remove "STATE_SEQ"
195
                          </select>
195
						  %>
196
                        </td>
196
                          </select>
197
                        <td valign="top"></td>
197
                        </td>
198
                      </tr>
198
                        <td valign="top"></td>
199
                      <tr>
199
                      </tr>
200
                        <td valign="top" nowrap class="form_iname">Comments</td>
200
                      <tr>
201
                        <td valign="top"><textarea name="release_to_comments" cols="60" rows="14" class="form_ivalue"><%=Request("release_to_comments")%></textarea></td>
201
                        <td valign="top" nowrap class="form_iname">Comments</td>
202
                        <td valign="top"><%=objForm.Validate ("release_to_comments")%> </td>
202
                        <td valign="top"><textarea name="release_to_comments" cols="60" rows="14" class="form_ivalue"><%=Request("release_to_comments")%></textarea></td>
203
                      </tr>
203
                        <td valign="top"><%=objForm.Validate ("release_to_comments")%> </td>
204
                      <tr>
204
                      </tr>
205
                        <td width="10%" class="form_iname">&nbsp;</td>
205
                      <tr>
206
                        <td width="1%">&nbsp;</td>
206
                        <td width="10%" class="form_iname">&nbsp;</td>
207
                        <td width="90%" class="val_err"></td>
207
                        <td width="1%">&nbsp;</td>
208
                      </tr>
208
                        <td width="90%" class="val_err"></td>
209
                  </table></td>
209
                      </tr>
210
                </tr>
210
                  </table></td>
211
				<tr>
211
                </tr>
212
                  <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
212
				<tr>
213
                      <tr>
213
                  <td background="images/bg_login.gif"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
214
                        <td></td>
214
                      <tr>
215
                        <td align="right"><input name="btn" type="submit" class="form_btn" value="Submit">
215
                        <td></td>
216
                            <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="window.location='<%=Request("rfile") &"?CANCEL=OK"& objPMod.ComposeURLWithout("rfile")%>';"></td>
216
                        <td align="right"><input name="btn" type="submit" class="form_btn" value="Submit">
217
                      </tr>
217
                            <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="window.location='<%=Request("rfile") &"?CANCEL=OK"& objPMod.ComposeURLWithout("rfile")%>';"></td>
218
                  </table></td>
218
                      </tr>
219
                </tr>
219
                  </table></td>
220
                <%=objPMod.ComposeHiddenTags()%>
220
                </tr>
221
                <input type="hidden" name="bom_id_list" value="<%=parBom_id_list%>">
221
                <%=objPMod.ComposeHiddenTags()%>
222
				<input type="hidden" name="parent_bom_id" value="<%=parParentBomId%>">
222
                <input type="hidden" name="bom_id_list" value="<%=parBom_id_list%>">
223
                <input type="hidden" name="action" value="true">
223
				<input type="hidden" name="parent_bom_id" value="<%=parParentBomId%>">
224
              </table>                </td>
224
                <input type="hidden" name="action" value="true">
225
            </tr>
225
              </table>                </td>
226
          </table></td>
226
            </tr>
227
        </tr>
227
          </table></td>
228
      </table>
228
        </tr>
229
	  <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->	  </td>
229
      </table>
230
  </tr>
230
	  <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->	  </td>
231
  <tr>
231
  </tr>
232
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
232
  <tr>
233
  </tr>
233
    <td bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="42"></td>
234
</form>  
234
  </tr>
235
</table>
235
</form>  
236
<!-- FOOTER ++++++++++++++++++++++ -->
236
</table>
237
<!--#include file="_footer.asp"-->
237
<!-- FOOTER ++++++++++++++++++++++ -->
238
<!-- +++++++++++++++++++++++++++++ -->
238
<!--#include file="_footer.asp"-->
239
</body>
239
<!-- +++++++++++++++++++++++++++++ -->
240
</html>
240
</body>
241
<%
241
</html>
242
'------------ RUN AFTER PAGE RENDER -----------
242
<%
243
Set objPMod = Nothing
243
'------------ RUN AFTER PAGE RENDER -----------
244
'----------------------------------------------
244
Set objPMod = Nothing
245
%>
245
'----------------------------------------------
246
<!--#include file="common/globals_destructor.asp"-->
246
%>
-
 
247
<!--#include file="common/globals_destructor.asp"-->