Subversion Repositories DevTools

Rev

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

Rev 119 Rev 5357
Line 1... Line 1...
1
<%@LANGUAGE="VBSCRIPT"%>
1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
2
<%
3
Option explicit
3
Option explicit
4
Response.Expires = 0	' always load the page, dont store
4
Response.Expires = 0	' always load the page, dont store
5
%>
5
%>
6
<%
6
<%
7
'=====================================================
7
'=====================================================
8
'					Reference Release
8
'					Reference Release
9
'=====================================================
9
'=====================================================
10
%>
10
%>
11
<!--#include file="common/conf.asp"-->
11
<!--#include file="common/conf.asp"-->
12
<!--#include file="common/globals.asp"-->
12
<!--#include file="common/globals.asp"-->
13
<!--#include file="common/qstr.asp"-->
13
<!--#include file="common/qstr.asp"-->
14
<!--#include file="common/common_subs.asp"-->
14
<!--#include file="common/common_subs.asp"-->
15
<!--#include file="common/common_dbedit.asp"-->
15
<!--#include file="common/common_dbedit.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
17
<%
17
<%
18
'------------ ACCESS CONTROL ------------------
18
'------------ ACCESS CONTROL ------------------
19
%>
19
%>
20
<!--#include file="_access_control_login.asp"-->
20
<!--#include file="_access_control_login.asp"-->
21
<!--#include file="_access_control_general.asp"-->
21
<!--#include file="_access_control_general.asp"-->
22
<!--#include file="_access_control_project.asp"-->
22
<!--#include file="_access_control_project.asp"-->
23
<%
23
<%
24
'------------ Variable Definition -------------
24
'------------ Variable Definition -------------
25
Dim parFRproj_id
25
Dim parFRproj_id
26
Dim parFRrtag_id
26
Dim parFRrtag_id
27
Dim parToRtag_id
27
Dim parToRtag_id
28
'------------ Constants Declaration -----------
28
'------------ Constants Declaration -----------
29
'------------ Variable Init -------------------
29
'------------ Variable Init -------------------
30
parFRproj_id = QStrPar("FRproj_id")
30
parFRproj_id = QStrPar("FRproj_id")
31
parFRrtag_id = QStrPar("FRrtag_id")
31
parFRrtag_id = QStrPar("FRrtag_id")
32
parToRtag_id = QStrPar("ToRtag_id")
32
parToRtag_id = QStrPar("ToRtag_id")
33
If parFRproj_id = "" Then parFRproj_id = "-1"
33
If parFRproj_id = "" Then parFRproj_id = "-1"
34
If parFRrtag_id = "" Then parFRrtag_id = "-1"
34
If parFRrtag_id = "" Then parFRrtag_id = "-1"
35
'----------------------------------------------
35
'----------------------------------------------
36
%>
36
%>
37
<%
37
<%
38
Sub Get_Projects ( NNproj_id )
38
Sub Get_Projects ( NNproj_id )
39
	Dim rsTemp, Query_String, tempLINK
39
	Dim rsTemp, Query_String, tempLINK
40
	Query_String = _
40
	Query_String = _
41
	"SELECT * FROM projects ORDER BY  UPPER( proj_name ) "
41
	"SELECT * FROM projects ORDER BY  UPPER( proj_name ) "
42
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
42
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
43
	
43
	
44
	Response.write "<select name='FRproj_id' onChange=""MM_jumpMenu('parent',this,0)"" class='form_item'>"
44
	Response.write "<select name='FRproj_id' onChange=""MM_jumpMenu('parent',this,0)"" class='form_item'>"
45
		Response.write "<option value=''>Select Project</option>"
45
		Response.write "<option value=''>Select Project</option>"
46
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
46
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
47
			tempLINK = scriptName &"?FRproj_id="& rsTemp.Fields("proj_id") &"&FRrtag_id=&ToRtag_id="& parToRtag_id &"&"& objPMod.ComposeURL()
47
			tempLINK = scriptName &"?FRproj_id="& rsTemp.Fields("proj_id") &"&FRrtag_id=&ToRtag_id="& parToRtag_id &"&"& objPMod.ComposeURL()
48
			
48
			
49
			If NNproj_id = Cstr(rsTemp.Fields("proj_id")) Then
49
			If NNproj_id = Cstr(rsTemp.Fields("proj_id")) Then
50
	        	Response.write "<option value='"& tempLINK &"' selected>"& UCase(rsTemp.Fields("proj_name")) &"</option>"
50
	        	Response.write "<option value='"& tempLINK &"' selected>"& UCase(rsTemp.Fields("proj_name")) &"</option>"
51
	        Else
51
	        Else
52
				Response.write "<option value='"& tempLINK &"'>"& UCase(rsTemp.Fields("proj_name")) &"</option>"
52
				Response.write "<option value='"& tempLINK &"'>"& UCase(rsTemp.Fields("proj_name")) &"</option>"
53
			End If
53
			End If
54
			rsTemp.MoveNext
54
			rsTemp.MoveNext
55
		WEnd
55
		WEnd
56
	Response.write "</select>"
56
	Response.write "</select>"
57
	
57
	
58
	rsTemp.Close
58
	rsTemp.Close
59
	Set rsTemp = nothing
59
	Set rsTemp = nothing
60
End Sub
60
End Sub
61
 
61
 
62
 
62
 
63
 
63
 
64
Sub Get_Release_Labels ( NNproj_id, NNrtag_id )
64
Sub Get_Release_Labels ( NNproj_id, NNrtag_id )
65
	Dim rsTemp, Query_String, tempLINK
65
	Dim rsTemp, Query_String, tempLINK
66
	Query_String = _
66
	Query_String = _
67
	"SELECT rtag_id, rtag_name FROM release_tags WHERE proj_id = "& NNproj_id &"  AND  OFFICIAL='Y' ORDER BY UPPER(rtag_name)"
67
	"SELECT rtag_id, rtag_name FROM release_tags WHERE proj_id = "& NNproj_id &"  AND  OFFICIAL='Y' ORDER BY UPPER(rtag_name)"
68
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
68
	Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
69
	
69
	
70
	Response.write "<select name='FRrtag_id' onChange=""MM_jumpMenu('parent',this,0)"" class='form_item'>"
70
	Response.write "<select name='FRrtag_id' onChange=""MM_jumpMenu('parent',this,0)"" class='form_item'>"
71
		If NNproj_id <> "-1" Then
71
		If NNproj_id <> "-1" Then
72
			Response.write "<option value=''>Select Release Name</option>"
72
			Response.write "<option value=''>Select Release Name</option>"
73
			While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
73
			While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
74
				tempLINK = scriptName &"?FRrtag_id="& rsTemp.Fields("rtag_id") &"&FRproj_id="& NNproj_id  &"&ToRtag_id="& parToRtag_id &"&"& objPMod.ComposeURL()
74
				tempLINK = scriptName &"?FRrtag_id="& rsTemp.Fields("rtag_id") &"&FRproj_id="& NNproj_id  &"&ToRtag_id="& parToRtag_id &"&"& objPMod.ComposeURL()
75
				
75
				
76
				If NNrtag_id = Cstr(rsTemp.Fields("rtag_id")) Then
76
				If NNrtag_id = Cstr(rsTemp.Fields("rtag_id")) Then
77
		        	Response.write "<option value='"& tempLINK &"' selected>"& (rsTemp.Fields("rtag_name")) &"</option>"
77
		        	Response.write "<option value='"& tempLINK &"' selected>"& (rsTemp.Fields("rtag_name")) &"</option>"
78
		        Else
78
		        Else
79
					Response.write "<option value='"& tempLINK &"'>"& (rsTemp.Fields("rtag_name")) &"</option>"
79
					Response.write "<option value='"& tempLINK &"'>"& (rsTemp.Fields("rtag_name")) &"</option>"
80
				End If
80
				End If
81
				rsTemp.MoveNext
81
				rsTemp.MoveNext
82
			WEnd
82
			WEnd
83
		End If
83
		End If
84
	Response.write "</select>"
84
	Response.write "</select>"
85
	
85
	
86
	rsTemp.Close
86
	rsTemp.Close
87
	Set rsTemp = nothing
87
	Set rsTemp = nothing
88
End Sub
88
End Sub
89
%>
89
%>
90
<%
90
<%
91
'Process submition
91
'Process submition
92
If CBool(QStrPar("action")) Then
92
If CBool(QStrPar("action")) Then
93
	%>
93
	%>
94
	<script language="JavaScript" type="text/javascript">
94
	<script language="JavaScript" type="text/javascript">
95
	window.opener.location='_add_release_reference.asp?RefRtag_id=<%=Request.Form("RefRtag_id")%>&ToRtag_id=<%=Request.Form("ToRtag_id")%>&<%=objPMod.ComposeURL()%>';
95
	window.opener.location='_add_release_reference.asp?RefRtag_id=<%=Request.Form("RefRtag_id")%>&ToRtag_id=<%=Request.Form("ToRtag_id")%>&<%=objPMod.ComposeURL()%>';
96
	</script>		
96
	</script>		
97
	<%
97
	<%
98
	Call CloseWindow
98
	Call CloseWindow
99
End If
99
End If
100
%>
100
%>
101
<html>
101
<html>
102
<head>
102
<head>
103
<title>Release Manager</title>
103
<title>Release Manager</title>
104
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
104
<link rel="shortcut icon" href="<%=FavIcon%>"/>
105
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
105
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
106
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
106
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
107
<link rel="stylesheet" href="images/navigation.css" type="text/css">
107
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
108
<script language="JavaScript" src="images/common.js"></script>
108
<link rel="stylesheet" href="images/navigation.css" type="text/css">
109
</head>
109
<script language="JavaScript" src="images/common.js"></script>
110
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
110
</head>
111
<form name="refrelease" method="post" action="<%=scriptName%>">
111
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
112
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
112
<form name="refrelease" method="post" action="<%=scriptName%>">
113
    <tr> 
113
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
114
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_change_group_off.gif" width="22" height="25" hspace="5"></td>
114
    <tr> 
115
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">Reference a Release </td>
115
      <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_change_group_off.gif" width="22" height="25" hspace="5"></td>
116
      <td background="images/lbox_bg_blue.gif" align="right" width="50%"> 
116
      <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">Reference a Release </td>
117
        <input type="submit" name="btn" value="Add" class="form_btn_comp" onClick="MM_validateForm('FRproj_id','Project','R','FRrtag_id','Release Name','R');return document.MM_returnValue">
117
      <td background="images/lbox_bg_blue.gif" align="right" width="50%"> 
118
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
118
        <input type="submit" name="btn" value="Add" class="form_btn_comp" onClick="MM_validateForm('FRproj_id','Project','R','FRrtag_id','Release Name','R');return document.MM_returnValue">
119
      </td>
119
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
120
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap> 
120
      </td>
121
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
121
      <td background="images/lbox_bg_blue.gif" align="right" width="1%%" nowrap> 
122
    </tr>
122
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
123
    <tr> 
123
    </tr>
124
      <td height="100%" width="1%">&nbsp;</td>
124
    <tr> 
125
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif"> 
125
      <td height="100%" width="1%">&nbsp;</td>
126
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
126
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif"> 
127
          <tr> 
127
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
128
            <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
128
          <tr> 
129
            <td colspan="2" valign="middle" nowrap class="form_group"><strong>NOTE:</strong> You can only reference locked releases.</td>
129
            <td width="1%"><img src="images/h_trsp_dot.gif" width="10" height="30"></td>
130
          </tr>
130
            <td colspan="2" valign="middle" nowrap class="form_group"><strong>NOTE:</strong> You can only reference locked releases.</td>
131
          <tr> 
131
          </tr>
132
            <td width="1%">&nbsp;</td>
132
          <tr> 
133
            <td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Project</td>
133
            <td width="1%">&nbsp;</td>
134
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt"> 
134
            <td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Project</td>
135
              <%Call Get_Projects ( parFRproj_id )%>
135
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt"> 
136
            </td>
136
              <%Call Get_Projects ( parFRproj_id )%>
137
          </tr>
137
            </td>
138
          <tr> 
138
          </tr>
139
            <td width="1%">&nbsp;</td>
139
          <tr> 
140
            <td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Release 
140
            <td width="1%">&nbsp;</td>
141
              Name </td>
141
            <td width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">Release 
142
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt"> 
142
              Name </td>
143
              <%Call Get_Release_Labels ( parFRproj_id,  parFRrtag_id )%>
143
            <td nowrap width="100%" background="images/bg_form_lightbluedark.gif" class="form_txt"> 
144
              <input type="hidden" name="ToRtag_id" value="<%=parToRtag_id%>">
144
              <%Call Get_Release_Labels ( parFRproj_id,  parFRrtag_id )%>
145
			  <input type="hidden" name="RefRtag_id" value="<%=parFRrtag_id%>">
145
              <input type="hidden" name="ToRtag_id" value="<%=parToRtag_id%>">
146
			  <input type="hidden" name="rtag_id" value="<%=Request("rtag_id")%>">
146
			  <input type="hidden" name="RefRtag_id" value="<%=parFRrtag_id%>">
147
              <input type="hidden" name="action" value="true">
147
			  <input type="hidden" name="rtag_id" value="<%=Request("rtag_id")%>">
148
            </td>
148
              <input type="hidden" name="action" value="true">
149
          </tr>
149
            </td>
150
          <tr> 
150
          </tr>
151
            <td width="1%">&nbsp;</td>
151
          <tr> 
152
            <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
152
            <td width="1%">&nbsp;</td>
153
            <td nowrap width="100%"> 
153
            <td width="1%" nowrap class="form_field"><img src="images/h_trsp_dot.gif" width="100" height="10"></td>
154
              <p>&nbsp;</p>
154
            <td nowrap width="100%"> 
155
            </td>
155
              <p>&nbsp;</p>
156
          </tr>
156
            </td>
157
        </table>
157
          </tr>
158
      </td>
158
        </table>
159
    </tr>
159
      </td>
160
    <tr> 
160
    </tr>
161
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
161
    <tr> 
162
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
162
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
163
    </tr>
163
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
164
  </table>
164
    </tr>
165
</form>
165
  </table>
166
</body>
166
</form>
167
</html>
167
</body>
168
 
168
</html>
169
 
169
 
170
<!-- DESTRUCTOR ------->
170
 
-
 
171
<!-- DESTRUCTOR ------->
171
<!--#include file="common/destructor.asp"-->
172
<!--#include file="common/destructor.asp"-->
172
173