| Line 161... |
Line 161... |
| 161 |
</table>
|
161 |
</table>
|
| 162 |
<!-- MESSAGE BOARD END ---------------------------------------------->
|
162 |
<!-- MESSAGE BOARD END ---------------------------------------------->
|
| 163 |
<br>
|
163 |
<br>
|
| 164 |
<br>
|
164 |
<br>
|
| 165 |
<!-- WORK IN PROGRESS ---------------------------------------------->
|
165 |
<!-- WORK IN PROGRESS ---------------------------------------------->
|
| 166 |
<table width="100%" border="0" cellspacing="1" cellpadding="1">
|
- |
|
| 167 |
<tr>
|
166 |
<div>
|
| 168 |
<td colspan="4" class="body_sect">Work In Progress<%=Quick_Help("h_wip")%>
|
167 |
<div class="body_sect">Work In Progress<%=Quick_Help("h_wip")%></div>
|
| 169 |
</td>
|
168 |
<table width="100%" border="0" cellspacing="1" cellpadding="1" class=stdGrey>
|
| 170 |
</tr>
|
- |
|
| 171 |
<tr>
|
169 |
<tr class=hline>
|
| 172 |
<td width="40%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif"> User</td>
|
170 |
<td width="40%" nowrap > User</td>
|
| 173 |
<td width="50%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif"> Package Count</td>
|
171 |
<td width="50%" nowrap > Package Count</td>
|
| 174 |
</tr>
|
172 |
</tr>
|
| 175 |
<!-- PERSONAL WORK IN PROGRESS -->
|
173 |
<!-- PERSONAL WORK IN PROGRESS -->
|
| 176 |
<%
|
174 |
<%
|
| 177 |
If objAccessControl.UserLogedIn Then
|
175 |
If objAccessControl.UserLogedIn Then
|
| 178 |
|
176 |
|
| 179 |
OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
|
177 |
OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 180 |
|
178 |
|
| 181 |
Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("WorkInProgressByUser.sql"), cint(0))
|
179 |
Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("WorkInProgressByUser.sql"), cint(0))
|
| 182 |
|
180 |
|
| 183 |
OraDatabase.Parameters.Remove "USER_ID"
|
181 |
OraDatabase.Parameters.Remove "USER_ID"
|
| 184 |
|
182 |
|
| 185 |
userId = rsTemp("user_id")
|
183 |
userId = rsTemp("user_id")
|
| 186 |
%>
|
184 |
%>
|
| 187 |
<tr>
|
185 |
<tr>
|
| 188 |
<td nowrap>
|
186 |
<td nowrap>
|
| 189 |
<img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_WIP_<%=userId%>" class="pointer txt_linked" onClick="ToggleLoadControl ('WIP_<%=userId%>','RequestUserWip.asp?user_id=<%=userId%>');">
|
187 |
<img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_WIP_<%=userId%>" class="pointer txt_linked" onClick="ToggleLoadControl ('WIP_<%=userId%>','RequestUserWip.asp?user_id=<%=userId%>');">
|
| 190 |
<%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%>
|
188 |
<%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%>
|
| 191 |
</td>
|
189 |
</td>
|
| 192 |
<td nowrap class="body_txt"><%=rsTemp("counter")%></td>
|
190 |
<td nowrap><%=rsTemp("counter")%></td>
|
| 193 |
</tr>
|
191 |
</tr>
|
| 194 |
<tr id="TGL_WIP_<%=userId%>" style="display:none;">
|
192 |
<tr id="TGL_WIP_<%=userId%>" style="display:none;">
|
| 195 |
<td nowrap class="body_txt" colspan="3"><div class="subSectionIndent" id="WIP_<%=userId%>"><%=enumLOADING%></div></td>
|
193 |
<td nowrap colspan="3"><div class="subSectionIndent" id="WIP_<%=userId%>"><%=enumLOADING%></div></td>
|
| 196 |
</tr>
|
194 |
</tr>
|
| 197 |
<tr>
|
195 |
<tr>
|
| 198 |
<td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
196 |
<td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
| 199 |
</tr>
|
197 |
</tr>
|
| 200 |
<%
|
198 |
<%
|
| 201 |
rsTemp.Close
|
199 |
rsTemp.Close
|
| 202 |
Set rsTemp = nothing
|
200 |
Set rsTemp = nothing
|
| 203 |
End If%>
|
201 |
End If%>
|
| 204 |
</table>
|
202 |
</table>
|
| - |
|
203 |
</div>
|
| 205 |
<!-- WORK IN PROGRESS END ------------------------------------------>
|
204 |
<!-- WORK IN PROGRESS END ------------------------------------------>
|
| 206 |
<!-- DANGLING PACKAGES ---------------------------------------------->
|
205 |
<!-- DANGLING PACKAGES ---------------------------------------------->
|
| 207 |
<%
|
206 |
<%
|
| 208 |
pkgCount = 0
|
207 |
pkgCount = 0
|
| 209 |
If objAccessControl.UserLogedIn Then
|
208 |
If objAccessControl.UserLogedIn Then
|
| Line 212... |
Line 211... |
| 212 |
OraDatabase.Parameters.Remove "USER_ID"
|
211 |
OraDatabase.Parameters.Remove "USER_ID"
|
| 213 |
userId = rsTemp("user_id")
|
212 |
userId = rsTemp("user_id")
|
| 214 |
pkgCount = rsTemp("counter")
|
213 |
pkgCount = rsTemp("counter")
|
| 215 |
End If
|
214 |
End If
|
| 216 |
%>
|
215 |
%>
|
| 217 |
<table width="100%" border="0" cellspacing="1" cellpadding="1">
|
216 |
<div>
|
| 218 |
<tr>
|
217 |
<div class="body_sect">
|
| 219 |
<td colspan="4" class="body_sect">Dangling Package Versions
|
218 |
Dangling Package Versions
|
| 220 |
<%=Quick_Help("h_dangling")%>
|
219 |
<%=Quick_Help("h_dangling")%>
|
| 221 |
<%If pkgCount > 10 Then%>
|
220 |
<%If pkgCount > 10 Then%>
|
| 222 |
<img src='images/a_warning.gif' width='21' height='21' border='0' title='Unreleased packages that are not in use.'>
|
221 |
<img src='images/a_warning.gif' width='21' height='21' border='0' title='Unreleased packages that are not in use.'>
|
| 223 |
<%End If%>
|
222 |
<%End If%>
|
| 224 |
</td>
|
223 |
</div>
|
| 225 |
</tr>
|
224 |
<table width="100%" border="0" cellspacing="1" cellpadding="1" class='stdGrey'>
|
| 226 |
<tr>
|
225 |
<tr class=hline>
|
| 227 |
<td width="40%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif"> User
|
226 |
<td width="40%" nowrap> User
|
| 228 |
</td>
|
227 |
</td>
|
| 229 |
<td width="50%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif"> Package Count</td>
|
228 |
<td width="50%" nowrap> Package Count</td>
|
| 230 |
</tr>
|
229 |
</tr>
|
| 231 |
<%If objAccessControl.UserLogedIn Then %>
|
230 |
<%If objAccessControl.UserLogedIn Then %>
|
| 232 |
<tr>
|
231 |
<tr>
|
| 233 |
<td nowrap>
|
232 |
<td nowrap>
|
| 234 |
<img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_DGL_<%=userId%>" class="pointer txt_linked" onClick="ToggleLoadControl('DGL_<%=userId%>','RequestUserDangle.asp?user_id=<%=userId%>');"><%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%>
|
233 |
<img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_DGL_<%=userId%>" class="pointer txt_linked" onClick="ToggleLoadControl('DGL_<%=userId%>','RequestUserDangle.asp?user_id=<%=userId%>');"><%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%>
|
| 235 |
</td>
|
234 |
</td>
|
| 236 |
<td nowrap class="body_txt"><%=pkgCount%></td>
|
235 |
<td nowrap class="body_txt"><%=pkgCount%></td>
|
| 237 |
</tr>
|
236 |
</tr>
|
| 238 |
<tr id="TGL_DGL_<%=userId%>" style="display:none;">
|
237 |
<tr id="TGL_DGL_<%=userId%>" style="display:none;">
|
| 239 |
<td nowrap class="body_txt" colspan="3"><div class=subSectionIndent id='DGL_<%=userId%>'><%=enumLOADING%></div></td>
|
238 |
<td nowrap class="body_txt" colspan="3"><div class=subSectionIndent id='DGL_<%=userId%>'><%=enumLOADING%></div></td>
|
| 240 |
</tr>
|
239 |
</tr>
|
| 241 |
<tr>
|
240 |
<tr>
|
| 242 |
<td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
241 |
<td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
| 243 |
</tr>
|
242 |
</tr>
|
| 244 |
<%
|
243 |
<%
|
| 245 |
rsTemp.Close
|
244 |
rsTemp.Close
|
| 246 |
Set rsTemp = nothing
|
245 |
Set rsTemp = nothing
|
| 247 |
End If%>
|
246 |
End If%>
|
| 248 |
</table>
|
247 |
</table>
|
| - |
|
248 |
</div>
|
| 249 |
<!-- DANGLING PACKAGES END ------------------------------------------>
|
249 |
<!-- DANGLING PACKAGES END ------------------------------------------>
|
| 250 |
<br>
|
250 |
<br>
|
| 251 |
<br>
|
251 |
<br>
|
| 252 |
<!-- RELEASE METRICS -------------------------------------------------------->
|
252 |
<!-- RELEASE METRICS -------------------------------------------------------->
|
| 253 |
<table width="100%" border="0" cellspacing="0" cellpadding="0">
|
- |
|
| 254 |
<tr>
|
253 |
<div>
|
| 255 |
<td class="body_sect">Release Metrics</td>
|
254 |
<div class="body_sect">Release Metrics</div>
|
| 256 |
</tr>
|
- |
|
| 257 |
<tr>
|
- |
|
| 258 |
<td>
|
- |
|
| 259 |
<table width="100%" border="0" cellspacing="1" cellpadding="1" class="etable">
|
255 |
<table width="100%" border="0" cellspacing="1" cellpadding="1" class="etable">
|
| 260 |
<tr class="form_field_bg">
|
256 |
<tr class="form_field_bg">
|
| 261 |
<th nowrap class="body_row" valign="top">Project</th>
|
257 |
<th nowrap class="body_row" valign="top">Project</th>
|
| 262 |
<th nowrap class="body_row" valign="top">Last Built Release</th>
|
258 |
<th nowrap class="body_row" valign="top">Last Built Release</th>
|
| 263 |
<th nowrap class="body_row" valign="top">Completed</th>
|
259 |
<th nowrap class="body_row" valign="top">Completed</th>
|
| 264 |
<th nowrap class="body_row" valign="top">Autobuilt Packages</th>
|
260 |
<th nowrap class="body_row" valign="top">Autobuilt Packages</th>
|
| 265 |
</tr>
|
261 |
</tr>
|
| 266 |
<%
|
262 |
<%
|
| 267 |
Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseMetricsSummary.sql"), cint(0))
|
263 |
Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ReleaseMetricsSummary.sql"), cint(0))
|
| 268 |
|
264 |
|
| 269 |
While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
|
265 |
While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
|
| 270 |
Dim proj_id: proj_id = rsQry("proj_id")
|
266 |
Dim proj_id: proj_id = rsQry("proj_id")
|
| 271 |
Auto=FormatPercent(rsQry("autobuilt")/rsQry("total_packages"), 2)
|
267 |
Auto=FormatPercent(rsQry("autobuilt")/rsQry("total_packages"), 2)
|
| 272 |
%>
|
268 |
%>
|
| 273 |
<tr class="form_field_grey_bg csvData">
|
269 |
<tr class="form_field_grey_bg csvData">
|
| 274 |
<td nowrap class="body_row">
|
270 |
<td nowrap class="body_row">
|
| 275 |
<a title="Show all metrics for this Project" href='javascript://proj_id=<%=proj_id%>;' class="txt_linked" onClick="ToggleLoadControl('RPM_<%=proj_id%>','RequestProjectRelease.asp?proj_id=<%=rsQry("proj_id")%>');"><img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_RPM_<%=proj_id%>"><img src="images/i_world.gif" border="0" align="absmiddle" hspace="3"></a>
|
271 |
<a title="Show all metrics for this Project" href='javascript://proj_id=<%=proj_id%>;' class="txt_linked" onClick="ToggleLoadControl('RPM_<%=proj_id%>','RequestProjectRelease.asp?proj_id=<%=rsQry("proj_id")%>');"><img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_RPM_<%=proj_id%>"><img src="images/i_world.gif" border="0" align="absmiddle" hspace="3"></a>
|
| 276 |
<a title="Open this Project" href="rtree.asp?proj_id=<%=proj_id%>"><%=rsQry("proj_name")%></a>
|
272 |
<a title="Open this Project" href="rtree.asp?proj_id=<%=proj_id%>"><%=rsQry("proj_name")%></a>
|
| 277 |
</td>
|
273 |
</td>
|
| 278 |
<td nowrap class="body_row" title="Open this Release">
|
274 |
<td nowrap class="body_row" title="Open this Release">
|
| 279 |
<a href='dependencies.asp?rtag_id=<%=rsQry("rtag_id")%>'><%=rsQry("rtag_name")%></a>
|
275 |
<a href='dependencies.asp?rtag_id=<%=rsQry("rtag_id")%>'><%=rsQry("rtag_name")%></a>
|
| 280 |
</td>
|
276 |
</td>
|
| 281 |
<td nowrap class="body_row"><%=rsQry("last_build_time")%></td>
|
277 |
<td nowrap class="body_row"><%=rsQry("last_build_time")%></td>
|
| 282 |
<td nowrap class="body_row tright"><%=rsQry("autobuilt")%>/<%=rsQry("total_packages")%> (<%=Auto%>)</td>
|
278 |
<td nowrap class="body_row tright"><%=rsQry("autobuilt")%>/<%=rsQry("total_packages")%> (<%=Auto%>)</td>
|
| 283 |
</tr>
|
279 |
</tr>
|
| 284 |
<tr id="TGL_RPM_<%=proj_id%>" style="display:none;" class="form_field_grey_bg">
|
280 |
<tr id="TGL_RPM_<%=proj_id%>" style="display:none;" class="form_field_grey_bg">
|
| 285 |
<td nowrap class="body_row" colspan="4"><div class=subSectionIndent id='RPM_<%=proj_id%>'><%=enumLOADING%></div></td>
|
281 |
<td nowrap class="body_row" colspan="4"><div class=subSectionIndent id='RPM_<%=proj_id%>'><%=enumLOADING%></div></td>
|
| 286 |
</tr>
|
282 |
</tr>
|
| 287 |
<%
|
283 |
<%
|
| 288 |
rsQry.MoveNext
|
284 |
rsQry.MoveNext
|
| 289 |
Wend
|
285 |
Wend
|
| 290 |
|
286 |
|
| 291 |
rsQry.Close()
|
287 |
rsQry.Close()
|
| 292 |
Set rsQry = Nothing
|
288 |
Set rsQry = Nothing
|
| 293 |
%>
|
- |
|
| 294 |
</table>
|
- |
|
| 295 |
</td>
|
289 |
%>
|
| 296 |
</tr>
|
290 |
</table>
|
| 297 |
</table>
|
291 |
</div>
|
| 298 |
<!-- DASH BOARD END ---------------------------------------------------->
|
292 |
<!-- DASH BOARD END ---------------------------------------------------->
|
| 299 |
</td>
|
293 |
</td>
|
| 300 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="15" height="10"></td>
|
294 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="15" height="10"></td>
|
| 301 |
<td background="images/bg_action_norm.gif" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="10"></td>
|
295 |
<td background="images/bg_action_norm.gif" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="10"></td>
|
| 302 |
</tr>
|
296 |
</tr>
|