Subversion Repositories DevTools

Rev

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

Rev 6786 Rev 6873
Line 102... Line 102...
102 
                                "   run_level rl," &_
 102 
                                "   run_level rl," &_
103 
                                "   packages pk," &_
 103 
                                "   packages pk," &_
104 
                                "   package_versions pv" &_
 104 
                                "   package_versions pv" &_
105 
                                " WHERE rc.rtag_id     = " & parRtagId &_
 105 
                                " WHERE rc.rtag_id     = " & parRtagId &_
106 
                                "  AND gm.gbe_id        = rc.gbe_id" &_
 106 
                                "  AND gm.gbe_id        = rc.gbe_id" &_
107 
                                "  AND rl.rcon_id       = rc.rcon_id" &_
 107 
                                "  AND rl.rcon_id(+)       = rc.rcon_id" &_
108 
                                "  AND rc.bmcon_id      =bm.bmcon_id(+)" &_
 108 
                                "  AND rc.bmcon_id      =bm.bmcon_id(+)" &_
109 
                                "  AND pk.pkg_id(+)     = rl.current_pkg_id_being_built" &_
 109 
                                "  AND pk.pkg_id(+)     = rl.current_pkg_id_being_built" &_
110 
                                "  AND rl.current_pv_id = pv.pv_id(+)" &_
 110 
                                "  AND rl.current_pv_id = pv.pv_id(+)" &_
111 
                                " ORDER BY bm.display_name, rc.rcon_id"
 111 
                                " ORDER BY bm.display_name, rc.rcon_id"
112 
 
 112 
 
Line 227... Line 227...
227 
<table class="embedded_table" style="margin-bottom:20px;min-width:470px">
 227 
<table class="embedded_table" style="margin-bottom:20px;min-width:470px">
228 
<%
 228 
<%
229 
Set rsQry = OraDatabase.DbCreateDynaset( "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta, rl.LAST_BUILD as BuildStart, rl.current_pv_id, SYSDATE" &_
 229 
Set rsQry = OraDatabase.DbCreateDynaset( "SELECT TRUNC (86400*(SYSDATE - rl.LAST_BUILD)) as delta, rl.LAST_BUILD as BuildStart, rl.current_pv_id, SYSDATE" &_
230 
                                        " FROM release_config rc,  run_level rl " &_
 230 
                                        " FROM release_config rc,  run_level rl " &_
231 
                                        " WHERE rc.rtag_id   = " & parRtagId &_
 231 
                                        " WHERE rc.rtag_id   = " & parRtagId &_
232 
                                        " AND rc.daemon_mode = 'M' AND rl.rcon_id = rc.rcon_id", ORADYN_DEFAULT )
 232 
                                        " AND rc.daemon_mode = 'M' AND rl.rcon_id(+) = rc.rcon_id", ORADYN_DEFAULT )
233 
Dim BuildStart
 233 
Dim BuildStart
234 
Dim BuildDelta
 234 
Dim BuildDelta
235 
Dim BuildPvId
 235 
Dim BuildPvId
236 
Dim BuildNow
 236 
Dim BuildNow
237 
If (rsQry.RecordCount > 0) Then
 237 
If (rsQry.RecordCount > 0) Then
Line 242... Line 242...
242 
End If
 242 
End If
243 
rsQry.Close()
 243 
rsQry.Close()
244 
Set rsQry = nothing
 244 
Set rsQry = nothing
245 
%>
 245 
%>
246 
  <tr>
 246 
  <tr>
247 
     <td>
 - 
 
248 
        <table width="95%" class="embedded_table" align="center">
 - 
 
249 
           <tr>
 - 
 
250 
              <td nowrap class="form_ttl">DAEMON BUILD PLAN<%=Quick_Help("h_buildplan")%>
 - 
 
251 
              </td>
 - 
 
252 
              <td  valign="bottom" align="right" class="body_txt_gray nowrap">
 - 
 
253 
                Now: <%=DisplayShortDateTimeSecs(BuildNow)%> AWST
 - 
 
254 
              </td>
 - 
 
255 
           </tr>
 - 
 
256 
        </table>
 - 
 
257 
     </td>
 - 
 
258 
  </tr>
 - 
 
259 
  <tr>
 - 
 
260 
    <td>
 247 
    <td>
261 
        <table  class="rounded_box embedded_table" width="100%">
 248 
        <table  class="rounded_box embedded_table" width="100%">
- 
 
 249 
            <caption>
- 
 
 250 
                DAEMON BUILD PLAN<%=Quick_Help("h_buildplan")%>
- 
 
 251 
                <span class="body_txt_gray nowrap tright">Now: <%=DisplayShortDateTimeSecs(BuildNow)%> AWST</span>
- 
 
 252 
            </caption>
262 
             <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" ></td>
 253 
             <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" ></td>
263 
             <td bgcolor="#FFFFFF" valign="top">
 254 
             <td bgcolor="#FFFFFF" valign="top">
264 
                <table width="100%" border="0" cellspacing="2" cellpadding="0">
 255 
                <table width="100%" border="0" cellspacing="2" cellpadding="0">
265 
 
 - 
 
266 
                   <tr>
 256 
                   <tr>
267 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Package</td>
 257 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Package</td>
268 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
 258 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Version</td>
269 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Duration<%=Quick_Help("h_buildDuration")%></td>
 259 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Duration<%=Quick_Help("h_buildDuration")%></td>
270 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Build Completion<%=Quick_Help("h_buildEnd")%></td>
 260 
                      <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Build Completion<%=Quick_Help("h_buildEnd")%></td>