Subversion Repositories DevTools

Rev

Rev 6548 | Rev 6566 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6548 Rev 6549
Line 262... Line 262...
262 
'-------------------------------------------------
 262 
'-------------------------------------------------
263 
'
263 
'
264 
Sub ShowBuildPlan
 264 
Sub ShowBuildPlan
265 
%>
 265 
%>
266 
<!-- Planned Builds Display -->
 266 
<!-- Planned Builds Display -->
267 
<table class="embedded_table" style="margin-bottom:20px">
 267 
<table class="embedded_table" style="margin-bottom:20px;min-width:470px">
268 
<%
 268 
<%
269 
Set rsQry = OraDatabase.DbCreateDynaset( "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta, rl.LAST_BUILD as BuildStart, rl.current_pv_id, SYSDATE" &_
 269 
Set rsQry = OraDatabase.DbCreateDynaset( "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta, rl.LAST_BUILD as BuildStart, rl.current_pv_id, SYSDATE" &_
270 
                                        " FROM release_config rc,  run_level rl " &_
 270 
                                        " FROM release_config rc,  run_level rl " &_
271 
                                        " WHERE rc.rtag_id   = " & parRtagId &_
 271 
                                        " WHERE rc.rtag_id   = " & parRtagId &_
272 
                                        " AND rc.daemon_mode = 'M' AND rl.rcon_id = rc.rcon_id", ORADYN_DEFAULT )
 272 
                                        " AND rc.daemon_mode = 'M' AND rl.rcon_id = rc.rcon_id", ORADYN_DEFAULT )
Line 287... Line 287...
287 
     <td>
 287 
     <td>
288 
        <table width="95%" class="embedded_table" align="center">
 288 
        <table width="95%" class="embedded_table" align="center">
289 
           <tr>
 289 
           <tr>
290 
              <td nowrap class="form_ttl">DAEMON BUILD PLAN<%=Quick_Help("h_buildplan")%>
 290 
              <td nowrap class="form_ttl">DAEMON BUILD PLAN<%=Quick_Help("h_buildplan")%>
291 
              </td>
 291 
              </td>
292 
              <td  valign="bottom" align="right" class="body_rowg nowrap">
 292 
              <td  valign="bottom" align="right" class="body_txt_gray nowrap">
293 
                Now: <%=DisplayShortDateTimeSecs(BuildNow)%> AWST
 293 
                Now: <%=DisplayShortDateTimeSecs(BuildNow)%> AWST
294 
              </td>
 294 
              </td>
295 
           </tr>
 295 
           </tr>
296 
        </table>
 296 
        </table>
297 
     </td>
 297 
     </td>
Line 319... Line 319...
319 
                                                            "  package_versions pv" &_
 319 
                                                            "  package_versions pv" &_
320 
                                                            " WHERE bp.PV_ID = pv.pv_id" &_
 320 
                                                            " WHERE bp.PV_ID = pv.pv_id" &_
321 
                                                            " AND RTAG_ID = " & parRtagId &_
 321 
                                                            " AND RTAG_ID = " & parRtagId &_
322 
                                                            " AND pv.PKG_ID  = p.pkg_id" &_
 322 
                                                            " AND pv.PKG_ID  = p.pkg_id" &_
323 
                                                            " ORDER BY build_order" , ORADYN_DEFAULT )
 323 
                                                            " ORDER BY build_order" , ORADYN_DEFAULT )
- 
 
 324 
                   If rsQry.RecordCount = 0 Then
- 
 
 325 
                       %>
- 
 
 326 
                       <tr>
- 
 
 327 
                        <td nowrap colspan="4" align="center" class="body_txt">No packages to be built </td>
- 
 
 328 
                       </tr>
- 
 
 329 
                       <%
- 
 
 330 
                   End If
324 
                   While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 331 
                   While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
325 
                       completionText = ""
 332 
                       completionText = ""
326 
                       buildDuration = rsQry("BUILD_TIME")
 333 
                       buildDuration = rsQry("BUILD_TIME")
327 
                       durationDisplay = buildDuration
 334 
                       durationDisplay = buildDuration
328 
 
 335