Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
Option explicit
4
Response.Expires = 0	' always load the page, dont store
5
%>
6
<%
7
'=====================================================
8
'					ISSUE DETAILS
9
'=====================================================
10
%>
11
<!--#include file="common/conf.asp"-->
12
<!--#include file="common/globals.asp"-->
13
<!--#include file="common/formating.asp"-->
14
<!--#include file="common/qstr.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="_tabs.asp"-->
17
<!--#include file="common/cq_common_subs.asp"-->
18
<!--#include file="common/_popup_window_common.asp"-->
19
<%
20
'------------ ACCESS CONTROL ------------------
21
%>
22
<!--#include file="_access_control_general.asp"-->
23
<%
24
'------------ Variable Definition -------------
25
Dim rsCQ
26
Dim ddWidth
27
Dim parIss_db
28
Dim parIss_id
29
'------------ Constants Declaration -----------
30
'------------ Variable Init -------------------
31
Set pkgInfoHash = CreateObject("Scripting.Dictionary")
32
Set rsCQ = Server.CreateObject("ADODB.Recordset")
33
Call Get_Iss_Parameters ( parIss_db, parIss_id )
34
ddWidth = 20
35
'----------------------------------------------
36
%>
37
<%
38
Sub Get_Issue_Details ( NNiss_db, NNiss_id, OOrsCQ )
39
	Dim SQLstr
40
	If Cint(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
41
		SQLstr = _
42
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
43
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
44
	    "        ap.fullname AS approver, si.description"&_
45
		"	FROM devi_prod.admin.software_issue si INNER JOIN"&_
46
	    "        devi_prod.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
47
	    "        devi_prod.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
48
	    "        devi_prod.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
49
	    "        devi_prod.admin.users ap ON si.approver = ap.dbid"&_
50
		"  WHERE si.dbid = "& NNiss_id
51
 
52
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
53
		SQLstr = _
54
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
55
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
56
	    "        ap.fullname AS approver, si.description"&_
57
		"	FROM VT5DM.admin.software_issue si INNER JOIN"&_
58
	    "        VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
59
	    "        VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
60
	    "        VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
61
	    "        VT5DM.admin.users ap ON si.approver = ap.dbid"&_
62
		"  WHERE si.dbid = "& NNiss_id
63
 
64
	End If
65
 
66
	OOrsCQ.ActiveConnection = CQ_conn
67
	OOrsCQ.Source = SQLstr
68
	OOrsCQ.CursorType = 0
69
	OOrsCQ.CursorLocation = 2
70
	OOrsCQ.LockType = 3
71
	OOrsCQ.Open()
72
End Sub 
73
%>
74
<%If parIss_db <> enumCLEARQUEST_DEVI_ID AND parIss_db <> enumCLEARQUEST_VT5DM_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
75
<%Call Get_Issue_Details ( parIss_db, parIss_id, rsCQ )%>
76
<!--#include file="_menu_def.asp"-->
77
<html>
78
<head>
79
<title><%=rsCQ("iss_num")%> - <%=rsCQ("summary")%></title>
80
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
81
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
82
<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
83
<link rel="stylesheet" href="images/navigation.css" type="text/css">
84
<script language="JavaScript" src="images/common.js"></script>
85
<script language="JavaScript">
86
<!--
87
function height()
88
{ 
89
	if( typeof( window.innerWidth ) == 'number' ) 
90
	{
91
		h = window.innerHeight;
92
	}
93
	else if(document.documentElement&&(document.documentElement.clientHeight ))
94
	{
95
		h = document.documentElement.clientHeight;
96
	} 
97
	else if( document.body &&	( document.body.clientWidth || document.body.clientHeight ) )
98
	{
99
		h = document.body.clientHeight;
100
	} 
101
 
102
	var e = document.getElementById("LayerDescription");
103
 
104
	if (navigator.userAgent.indexOf('Internet Explorer'))
105
	{
106
		e.style.height = h - 350 + "px";
107
		e.style.overflow = "auto";
108
	}
109
	else
110
	{
111
		// This line shouldn't be run by IE; it doesn't seem to work. It gets run in Firefox, etc.
112
		e.style.minHeight= h - 350 + "px";
113
		e.style.overflow = "auto";
114
	}
115
}
116
//-->
117
</script>
118
</head>
119
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();height();" onresize="height();" >
120
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
121
  <tr> 
122
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
123
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span> 
124
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
125
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=HTMLEncode(rsCQ("summary"))%>" readonly> </td>
126
  </tr>
127
  <tr> 
128
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
129
    <td valign="top" background="images/bg_form_lightbluedark.gif">
130
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
131
        <tr> 
132
          <td align="right" background="images/bg_lght_gray.gif"><br> 
133
            <!-- TABS ------------------------------------------->
134
            <%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
135
            <!------------------------------------------------------------->
136
          </td>
137
        </tr>
138
        <tr>
139
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
140
        </tr>
141
      </table><br>
142
	  <table width="100%" border="0" cellspacing="5" cellpadding="1">
143
        <tr>
144
          <td background="images/bg_vtree_h1.gif">
145
			<table width="100%" border="0" cellspacing="0" cellpadding="2">
146
              <tr> 
147
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
148
                <td background="images/bg_lght_gray.gif">
149
				  <select name="group_id" class="form_item" disabled>
150
                    <option selected><%=rsCQ("issue_type")%></option>
151
					<option><%=String(ddWidth, "_")%></option>
152
                  </select></td>
153
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Submitter</td>
154
                <td background="images/bg_lght_gray.gif">
155
				  <select name="group_id" class="form_item" disabled>
156
                    <option selected><%=rsCQ("submitter")%></option>
157
					<option><%=String(ddWidth, "_")%></option>
158
                  </select></td>
159
              </tr>
160
              <tr>
161
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Detected in Version</td>
162
                <td background="images/bg_lght_gray.gif">
163
				  <select name="group_id" class="form_item" disabled>
164
                    <option selected><%=rsCQ("release_part1") &"."& rsCQ("release_part2") &"."& rsCQ("release_part3") %></option>
165
					<option><%=String(ddWidth, "_")%></option>
166
                  </select></td>
167
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Submitted on Date</td>
168
                <td background="images/bg_lght_gray.gif">
169
				  <select name="group_id" class="form_item" disabled>
170
                    <option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
171
					<option><%=String(ddWidth, "_")%></option>
172
                  </select></td>
173
              </tr>
174
              <tr> 
175
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
176
                <td background="images/bg_lght_gray.gif">
177
				  <select name="group_id" class="form_item" disabled>
178
                    <option selected><%=rsCQ("project")%></option>
179
					<option><%=String(ddWidth, "_")%></option>
180
                  </select></td>
181
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Owner</td>
182
                <td background="images/bg_lght_gray.gif">
183
				 <select name="group_id" class="form_item" disabled>
184
                    <option selected><%=rsCQ("owner")%></option>
185
					<option><%=String(ddWidth, "_")%></option>
186
                  </select></td>
187
              </tr>
188
              <tr> 
189
			  	<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
190
                <td background="images/bg_lght_gray.gif">
191
				  <select name="group_id" class="form_item" disabled>
192
                    <option selected><%=rsCQ("product")%></option>
193
					<option><%=String(ddWidth, "_")%></option>
194
                  </select></td>
195
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Approver</td>
196
                <td background="images/bg_lght_gray.gif">
197
				  <select name="group_id" class="form_item" disabled>
198
                    <option selected><%=rsCQ("approver")%></option>
199
					<option><%=String(ddWidth, "_")%></option>
200
                  </select></td>
201
              </tr>
202
			  <tr> 
203
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
204
                <td background="images/bg_lght_gray.gif">
205
				  <select name="group_id" class="form_item" disabled>
206
                    <option selected><%=rsCQ("package")%></option>
207
					<option><%=String(ddWidth, "_")%></option>
208
                  </select></td>
209
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
210
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
211
              </tr>
212
              <tr> 
213
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
214
                <td background="images/bg_lght_gray.gif">
215
				  <select name="group_id" class="form_item" disabled>
216
                    <option selected><%=rsCQ("priority")%></option>
217
					<option><%=String(ddWidth, "_")%></option>
218
                  </select></td>
219
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
220
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
221
              </tr>
222
              <tr> 
223
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
224
                <td background="images/bg_lght_gray.gif">
225
				  <select name="group_id" class="form_item" disabled>
226
                    <option selected><%=rsCQ("status")%></option>
227
					<option><%=String(ddWidth, "_")%></option>
228
                  </select></td>
229
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp; 
230
                </td>
231
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
232
              </tr>
233
			  <tr> 
234
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
235
                <td background="images/bg_lght_gray.gif"></td>
236
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
237
                <td background="images/bg_lght_gray.gif"></td>
238
              </tr>
239
            </table>
240
          </td>
241
        </tr>
242
		<tr>
243
          <td background="images/bg_vtree_h1.gif">
244
			  <table width="100%" border="0" cellspacing="0" cellpadding="2">
245
		        <tr> 
246
		          <td bgcolor="White" class="form_item"><span class="form_field">Description</span><br>
247
		            <div id="LayerDescription" style="height:height(); overflow: auto;"><%=NewLine_To_BR( Server.HTMLEncode( rsCQ("description") ) )%></div>
248
				  </td>
249
		        </tr>
250
		      </table>
251
		  </td>
252
		</tr>
253
      </table>
254
	  </td>
255
  </tr>
256
  <tr> 
257
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
258
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
259
  </tr>
260
</table>
261
</body>
262
</html>
263
 
264
 
265
<!-- DESTRUCTOR ------->
266
<!--#include file="common/destructor.asp"-->