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_id )
34 
ddWidth = 20
35 
'----------------------------------------------
36 
%>
37 
<%
38 
Sub Get_Issue_Details (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"&_
159 ghuddy 45 
    " FROM CQ_DEVI.admin.software_issue si INNER JOIN"&_
46 
      "        CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
47 
      "        CQ_DEVI.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
48 
      "        CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
49 
      "        CQ_DEVI.admin.users ap ON si.approver = ap.dbid"&_
119 ghuddy 50 
		"  WHERE si.dbid = "& NNiss_id
159 ghuddy 51 
 
119 ghuddy 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"&_
159 ghuddy 57 
    " FROM CQ_VT5DM.admin.software_issue si INNER JOIN"&_
58 
      "        CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
59 
      "        CQ_VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
60 
      "        CQ_VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
61 
      "        CQ_VT5DM.admin.users ap ON si.approver = ap.dbid"&_
119 ghuddy 62 
		"  WHERE si.dbid = "& NNiss_id
159 ghuddy 63 
 
119 ghuddy 64 
	End If
159 ghuddy 65 
 
119 ghuddy 66 
	OOrsCQ.ActiveConnection = CQ_conn
67 
	OOrsCQ.Source = SQLstr
68 
	OOrsCQ.CursorType = 0
69 
	OOrsCQ.CursorLocation = 2
70 
	OOrsCQ.LockType = 3
71 
	OOrsCQ.Open()
159 ghuddy 72 
End Sub
119 ghuddy 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_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 
</head>
86 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
87 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
159 ghuddy 88 
  <tr>
119 ghuddy 89 
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
159 ghuddy 90 
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span>
119 ghuddy 91 
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
92 
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
93 
  </tr>
159 ghuddy 94 
  <tr>
119 ghuddy 95 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
96 
    <td valign="top" background="images/bg_form_lightbluedark.gif">
97 
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
159 ghuddy 98 
        <tr>
99 
          <td align="right" background="images/bg_lght_gray.gif"><br>
119 ghuddy 100 
            <!-- TABS ------------------------------------------->
101 
            <%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
102 
            <!------------------------------------------------------------->
103 
          </td>
104 
        </tr>
105 
        <tr>
106 
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
107 
        </tr>
108 
      </table><br>
109 
	  <table width="100%" border="0" cellspacing="5" cellpadding="1">
110 
        <tr>
111 
          <td background="images/bg_vtree_h1.gif">
112 
			<table width="100%" border="0" cellspacing="0" cellpadding="2">
159 ghuddy 113 
              <tr>
119 ghuddy 114 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
115 
                <td background="images/bg_lght_gray.gif">
116 
				  <select name="group_id" class="form_item" disabled>
117 
                    <option selected><%=rsCQ("issue_type")%></option>
118 
					<option><%=String(ddWidth, "_")%></option>
119 
                  </select></td>
120 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Submitter</td>
121 
                <td background="images/bg_lght_gray.gif">
122 
				  <select name="group_id" class="form_item" disabled>
123 
                    <option selected><%=rsCQ("submitter")%></option>
124 
					<option><%=String(ddWidth, "_")%></option>
125 
                  </select></td>
126 
              </tr>
127 
              <tr>
128 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Detected in Version</td>
129 
                <td background="images/bg_lght_gray.gif">
130 
				  <select name="group_id" class="form_item" disabled>
131 
                    <option selected><%=rsCQ("release_part1") &"."& rsCQ("release_part2") &"."& rsCQ("release_part3") %></option>
132 
					<option><%=String(ddWidth, "_")%></option>
133 
                  </select></td>
134 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Submitted on Date</td>
135 
                <td background="images/bg_lght_gray.gif">
136 
				  <select name="group_id" class="form_item" disabled>
137 
                    <option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
138 
					<option><%=String(ddWidth, "_")%></option>
139 
                  </select></td>
140 
              </tr>
159 ghuddy 141 
              <tr>
119 ghuddy 142 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
143 
                <td background="images/bg_lght_gray.gif">
144 
				  <select name="group_id" class="form_item" disabled>
145 
                    <option selected><%=rsCQ("project")%></option>
146 
					<option><%=String(ddWidth, "_")%></option>
147 
                  </select></td>
148 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Owner</td>
149 
                <td background="images/bg_lght_gray.gif">
150 
				 <select name="group_id" class="form_item" disabled>
151 
                    <option selected><%=rsCQ("owner")%></option>
152 
					<option><%=String(ddWidth, "_")%></option>
153 
                  </select></td>
154 
              </tr>
159 ghuddy 155 
              <tr>
119 ghuddy 156 
			  	<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
157 
                <td background="images/bg_lght_gray.gif">
158 
				  <select name="group_id" class="form_item" disabled>
159 
                    <option selected><%=rsCQ("product")%></option>
160 
					<option><%=String(ddWidth, "_")%></option>
161 
                  </select></td>
162 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Approver</td>
163 
                <td background="images/bg_lght_gray.gif">
164 
				  <select name="group_id" class="form_item" disabled>
165 
                    <option selected><%=rsCQ("approver")%></option>
166 
					<option><%=String(ddWidth, "_")%></option>
167 
                  </select></td>
168 
              </tr>
159 ghuddy 169 
			  <tr>
119 ghuddy 170 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
171 
                <td background="images/bg_lght_gray.gif">
172 
				  <select name="group_id" class="form_item" disabled>
173 
                    <option selected><%=rsCQ("package")%></option>
174 
					<option><%=String(ddWidth, "_")%></option>
175 
                  </select></td>
176 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
177 
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
178 
              </tr>
159 ghuddy 179 
              <tr>
119 ghuddy 180 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
181 
                <td background="images/bg_lght_gray.gif">
182 
				  <select name="group_id" class="form_item" disabled>
183 
                    <option selected><%=rsCQ("priority")%></option>
184 
					<option><%=String(ddWidth, "_")%></option>
185 
                  </select></td>
186 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
187 
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
188 
              </tr>
159 ghuddy 189 
              <tr>
119 ghuddy 190 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
191 
                <td background="images/bg_lght_gray.gif">
192 
				  <select name="group_id" class="form_item" disabled>
193 
                    <option selected><%=rsCQ("status")%></option>
194 
					<option><%=String(ddWidth, "_")%></option>
195 
                  </select></td>
159 ghuddy 196 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;
119 ghuddy 197 
                </td>
198 
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
199 
              </tr>
159 ghuddy 200 
			  <tr>
119 ghuddy 201 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
202 
                <td background="images/bg_lght_gray.gif"></td>
203 
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
204 
                <td background="images/bg_lght_gray.gif"></td>
205 
              </tr>
206 
            </table>
207 
          </td>
208 
        </tr>
209 
		<tr>
210 
          <td background="images/bg_vtree_h1.gif">
211 
			  <table width="100%" border="0" cellspacing="0" cellpadding="2">
159 ghuddy 212 
		        <tr>
119 ghuddy 213 
		          <td bgcolor="White" class="form_item"><span class="form_field">Description</span><br>
214 
		            <div id="LayerDescription" style="height:160px; overflow: auto;"><%=NewLine_To_BR( Server.HTMLEncode( rsCQ("description") ) )%></div>
215 
				  </td>
216 
		        </tr>
217 
		      </table>
218 
		  </td>
219 
		</tr>
220 
      </table>
221 
	  </td>
222 
  </tr>
159 ghuddy 223 
  <tr>
119 ghuddy 224 
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
225 
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
226 
  </tr>
227 
</table>
228 
</body>
229 
</html>
230 
 
231 
 
232 
<!-- DESTRUCTOR ------->
159 ghuddy 233 
<!--#include file="common/destructor.asp"-->