| Line 40... |
Line 40... |
| 40 |
If Cint(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
|
40 |
If Cint(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
|
| 41 |
SQLstr = _
|
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, "&_
|
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, "&_
|
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"&_
|
44 |
" ap.fullname AS approver, si.description"&_
|
| 45 |
" FROM devi_prod.admin.software_issue si INNER JOIN"&_
|
45 |
" FROM CQ_DEVI.admin.software_issue si INNER JOIN"&_
|
| 46 |
" devi_prod.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
46 |
" CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
| 47 |
" devi_prod.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
47 |
" CQ_DEVI.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
| 48 |
" devi_prod.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
48 |
" CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
| 49 |
" devi_prod.admin.users ap ON si.approver = ap.dbid"&_
|
49 |
" CQ_DEVI.admin.users ap ON si.approver = ap.dbid"&_
|
| 50 |
" WHERE si.dbid = "& NNiss_id
|
50 |
" WHERE si.dbid = "& NNiss_id
|
| 51 |
|
51 |
|
| 52 |
ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
|
52 |
ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
|
| 53 |
SQLstr = _
|
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, "&_
|
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, "&_
|
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"&_
|
56 |
" ap.fullname AS approver, si.description"&_
|
| 57 |
" FROM VT5DM.admin.software_issue si INNER JOIN"&_
|
57 |
" FROM CQ_VT5DM.admin.software_issue si INNER JOIN"&_
|
| 58 |
" VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
58 |
" CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
| 59 |
" VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
59 |
" CQ_VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
| 60 |
" VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
60 |
" CQ_VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
| 61 |
" VT5DM.admin.users ap ON si.approver = ap.dbid"&_
|
61 |
" CQ_VT5DM.admin.users ap ON si.approver = ap.dbid"&_
|
| 62 |
" WHERE si.dbid = "& NNiss_id
|
62 |
" WHERE si.dbid = "& NNiss_id
|
| 63 |
|
63 |
|
| 64 |
End If
|
64 |
End If
|
| 65 |
|
65 |
|
| 66 |
OOrsCQ.ActiveConnection = CQ_conn
|
66 |
OOrsCQ.ActiveConnection = CQ_conn
|
| 67 |
OOrsCQ.Source = SQLstr
|
67 |
OOrsCQ.Source = SQLstr
|
| 68 |
OOrsCQ.CursorType = 0
|
68 |
OOrsCQ.CursorType = 0
|
| 69 |
OOrsCQ.CursorLocation = 2
|
69 |
OOrsCQ.CursorLocation = 2
|
| 70 |
OOrsCQ.LockType = 3
|
70 |
OOrsCQ.LockType = 3
|
| 71 |
OOrsCQ.Open()
|
71 |
OOrsCQ.Open()
|
| 72 |
End Sub
|
72 |
End Sub
|
| 73 |
%>
|
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!" )%>
|
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 )%>
|
75 |
<%Call Get_Issue_Details (parIss_id, rsCQ )%>
|
| 76 |
<!--#include file="_menu_def.asp"-->
|
76 |
<!--#include file="_menu_def.asp"-->
|
| 77 |
<html>
|
77 |
<html>
|
| Line 83... |
Line 83... |
| 83 |
<link rel="stylesheet" href="images/navigation.css" type="text/css">
|
83 |
<link rel="stylesheet" href="images/navigation.css" type="text/css">
|
| 84 |
<script language="JavaScript" src="images/common.js"></script>
|
84 |
<script language="JavaScript" src="images/common.js"></script>
|
| 85 |
</head>
|
85 |
</head>
|
| 86 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
|
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">
|
87 |
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
|
| 88 |
<tr>
|
88 |
<tr>
|
| 89 |
<td width="1%" background="images/bg_lght_gray.gif"> </td>
|
89 |
<td width="1%" background="images/bg_lght_gray.gif"> </td>
|
| 90 |
<td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br> Issue</span>
|
90 |
<td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br> Issue</span>
|
| 91 |
<input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
|
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>
|
92 |
<input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
|
| 93 |
</tr>
|
93 |
</tr>
|
| 94 |
<tr>
|
94 |
<tr>
|
| 95 |
<td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
|
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">
|
96 |
<td valign="top" background="images/bg_form_lightbluedark.gif">
|
| 97 |
<table width="100%" border="0" cellspacing="0" cellpadding="0">
|
97 |
<table width="100%" border="0" cellspacing="0" cellpadding="0">
|
| 98 |
<tr>
|
98 |
<tr>
|
| 99 |
<td align="right" background="images/bg_lght_gray.gif"><br>
|
99 |
<td align="right" background="images/bg_lght_gray.gif"><br>
|
| 100 |
<!-- TABS ------------------------------------------->
|
100 |
<!-- TABS ------------------------------------------->
|
| 101 |
<%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
|
101 |
<%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
|
| 102 |
<!------------------------------------------------------------->
|
102 |
<!------------------------------------------------------------->
|
| 103 |
</td>
|
103 |
</td>
|
| 104 |
</tr>
|
104 |
</tr>
|
| Line 108... |
Line 108... |
| 108 |
</table><br>
|
108 |
</table><br>
|
| 109 |
<table width="100%" border="0" cellspacing="5" cellpadding="1">
|
109 |
<table width="100%" border="0" cellspacing="5" cellpadding="1">
|
| 110 |
<tr>
|
110 |
<tr>
|
| 111 |
<td background="images/bg_vtree_h1.gif">
|
111 |
<td background="images/bg_vtree_h1.gif">
|
| 112 |
<table width="100%" border="0" cellspacing="0" cellpadding="2">
|
112 |
<table width="100%" border="0" cellspacing="0" cellpadding="2">
|
| 113 |
<tr>
|
113 |
<tr>
|
| 114 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
|
114 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
|
| 115 |
<td background="images/bg_lght_gray.gif">
|
115 |
<td background="images/bg_lght_gray.gif">
|
| 116 |
<select name="group_id" class="form_item" disabled>
|
116 |
<select name="group_id" class="form_item" disabled>
|
| 117 |
<option selected><%=rsCQ("issue_type")%></option>
|
117 |
<option selected><%=rsCQ("issue_type")%></option>
|
| 118 |
<option><%=String(ddWidth, "_")%></option>
|
118 |
<option><%=String(ddWidth, "_")%></option>
|
| Line 136... |
Line 136... |
| 136 |
<select name="group_id" class="form_item" disabled>
|
136 |
<select name="group_id" class="form_item" disabled>
|
| 137 |
<option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
|
137 |
<option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
|
| 138 |
<option><%=String(ddWidth, "_")%></option>
|
138 |
<option><%=String(ddWidth, "_")%></option>
|
| 139 |
</select></td>
|
139 |
</select></td>
|
| 140 |
</tr>
|
140 |
</tr>
|
| 141 |
<tr>
|
141 |
<tr>
|
| 142 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
|
142 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
|
| 143 |
<td background="images/bg_lght_gray.gif">
|
143 |
<td background="images/bg_lght_gray.gif">
|
| 144 |
<select name="group_id" class="form_item" disabled>
|
144 |
<select name="group_id" class="form_item" disabled>
|
| 145 |
<option selected><%=rsCQ("project")%></option>
|
145 |
<option selected><%=rsCQ("project")%></option>
|
| 146 |
<option><%=String(ddWidth, "_")%></option>
|
146 |
<option><%=String(ddWidth, "_")%></option>
|
| Line 150... |
Line 150... |
| 150 |
<select name="group_id" class="form_item" disabled>
|
150 |
<select name="group_id" class="form_item" disabled>
|
| 151 |
<option selected><%=rsCQ("owner")%></option>
|
151 |
<option selected><%=rsCQ("owner")%></option>
|
| 152 |
<option><%=String(ddWidth, "_")%></option>
|
152 |
<option><%=String(ddWidth, "_")%></option>
|
| 153 |
</select></td>
|
153 |
</select></td>
|
| 154 |
</tr>
|
154 |
</tr>
|
| 155 |
<tr>
|
155 |
<tr>
|
| 156 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
|
156 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
|
| 157 |
<td background="images/bg_lght_gray.gif">
|
157 |
<td background="images/bg_lght_gray.gif">
|
| 158 |
<select name="group_id" class="form_item" disabled>
|
158 |
<select name="group_id" class="form_item" disabled>
|
| 159 |
<option selected><%=rsCQ("product")%></option>
|
159 |
<option selected><%=rsCQ("product")%></option>
|
| 160 |
<option><%=String(ddWidth, "_")%></option>
|
160 |
<option><%=String(ddWidth, "_")%></option>
|
| Line 164... |
Line 164... |
| 164 |
<select name="group_id" class="form_item" disabled>
|
164 |
<select name="group_id" class="form_item" disabled>
|
| 165 |
<option selected><%=rsCQ("approver")%></option>
|
165 |
<option selected><%=rsCQ("approver")%></option>
|
| 166 |
<option><%=String(ddWidth, "_")%></option>
|
166 |
<option><%=String(ddWidth, "_")%></option>
|
| 167 |
</select></td>
|
167 |
</select></td>
|
| 168 |
</tr>
|
168 |
</tr>
|
| 169 |
<tr>
|
169 |
<tr>
|
| 170 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
|
170 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
|
| 171 |
<td background="images/bg_lght_gray.gif">
|
171 |
<td background="images/bg_lght_gray.gif">
|
| 172 |
<select name="group_id" class="form_item" disabled>
|
172 |
<select name="group_id" class="form_item" disabled>
|
| 173 |
<option selected><%=rsCQ("package")%></option>
|
173 |
<option selected><%=rsCQ("package")%></option>
|
| 174 |
<option><%=String(ddWidth, "_")%></option>
|
174 |
<option><%=String(ddWidth, "_")%></option>
|
| 175 |
</select></td>
|
175 |
</select></td>
|
| 176 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"> </td>
|
176 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"> </td>
|
| 177 |
<td background="images/bg_lght_gray.gif"> </td>
|
177 |
<td background="images/bg_lght_gray.gif"> </td>
|
| 178 |
</tr>
|
178 |
</tr>
|
| 179 |
<tr>
|
179 |
<tr>
|
| 180 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
|
180 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
|
| 181 |
<td background="images/bg_lght_gray.gif">
|
181 |
<td background="images/bg_lght_gray.gif">
|
| 182 |
<select name="group_id" class="form_item" disabled>
|
182 |
<select name="group_id" class="form_item" disabled>
|
| 183 |
<option selected><%=rsCQ("priority")%></option>
|
183 |
<option selected><%=rsCQ("priority")%></option>
|
| 184 |
<option><%=String(ddWidth, "_")%></option>
|
184 |
<option><%=String(ddWidth, "_")%></option>
|
| 185 |
</select></td>
|
185 |
</select></td>
|
| 186 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"> </td>
|
186 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"> </td>
|
| 187 |
<td background="images/bg_lght_gray.gif"> </td>
|
187 |
<td background="images/bg_lght_gray.gif"> </td>
|
| 188 |
</tr>
|
188 |
</tr>
|
| 189 |
<tr>
|
189 |
<tr>
|
| 190 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
|
190 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
|
| 191 |
<td background="images/bg_lght_gray.gif">
|
191 |
<td background="images/bg_lght_gray.gif">
|
| 192 |
<select name="group_id" class="form_item" disabled>
|
192 |
<select name="group_id" class="form_item" disabled>
|
| 193 |
<option selected><%=rsCQ("status")%></option>
|
193 |
<option selected><%=rsCQ("status")%></option>
|
| 194 |
<option><%=String(ddWidth, "_")%></option>
|
194 |
<option><%=String(ddWidth, "_")%></option>
|
| 195 |
</select></td>
|
195 |
</select></td>
|
| 196 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">
|
196 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field">
|
| 197 |
</td>
|
197 |
</td>
|
| 198 |
<td background="images/bg_lght_gray.gif"> </td>
|
198 |
<td background="images/bg_lght_gray.gif"> </td>
|
| 199 |
</tr>
|
199 |
</tr>
|
| 200 |
<tr>
|
200 |
<tr>
|
| 201 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
|
201 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
|
| 202 |
<td background="images/bg_lght_gray.gif"></td>
|
202 |
<td background="images/bg_lght_gray.gif"></td>
|
| 203 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
|
203 |
<td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
|
| 204 |
<td background="images/bg_lght_gray.gif"></td>
|
204 |
<td background="images/bg_lght_gray.gif"></td>
|
| 205 |
</tr>
|
205 |
</tr>
|
| Line 207... |
Line 207... |
| 207 |
</td>
|
207 |
</td>
|
| 208 |
</tr>
|
208 |
</tr>
|
| 209 |
<tr>
|
209 |
<tr>
|
| 210 |
<td background="images/bg_vtree_h1.gif">
|
210 |
<td background="images/bg_vtree_h1.gif">
|
| 211 |
<table width="100%" border="0" cellspacing="0" cellpadding="2">
|
211 |
<table width="100%" border="0" cellspacing="0" cellpadding="2">
|
| 212 |
<tr>
|
212 |
<tr>
|
| 213 |
<td bgcolor="White" class="form_item"><span class="form_field">Description</span><br>
|
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>
|
214 |
<div id="LayerDescription" style="height:160px; overflow: auto;"><%=NewLine_To_BR( Server.HTMLEncode( rsCQ("description") ) )%></div>
|
| 215 |
</td>
|
215 |
</td>
|
| 216 |
</tr>
|
216 |
</tr>
|
| 217 |
</table>
|
217 |
</table>
|
| 218 |
</td>
|
218 |
</td>
|
| 219 |
</tr>
|
219 |
</tr>
|
| 220 |
</table>
|
220 |
</table>
|
| 221 |
</td>
|
221 |
</td>
|
| 222 |
</tr>
|
222 |
</tr>
|
| 223 |
<tr>
|
223 |
<tr>
|
| 224 |
<td background="images/bg_lght_gray.gif"> </td>
|
224 |
<td background="images/bg_lght_gray.gif"> </td>
|
| 225 |
<td background="images/lbox_bg_blue.gif"> </td>
|
225 |
<td background="images/lbox_bg_blue.gif"> </td>
|
| 226 |
</tr>
|
226 |
</tr>
|
| 227 |
</table>
|
227 |
</table>
|
| 228 |
</body>
|
228 |
</body>
|
| 229 |
</html>
|
229 |
</html>
|
| 230 |
|
230 |
|
| 231 |
|
231 |
|
| 232 |
<!-- DESTRUCTOR ------->
|
232 |
<!-- DESTRUCTOR ------->
|
| 233 |
<!--#include file="common/destructor.asp"-->
|
- |
|
| 234 |
|
233 |
<!--#include file="common/destructor.asp"-->
|
| - |
|
234 |
|