Subversion Repositories DevTools

Rev

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

Rev 7162 Rev 7260
Line 9... Line 9...
9
'   Get a set of Build Instances for the current package
9
'   Get a set of Build Instances for the current package
10
'       Populates biQry
10
'       Populates biQry
11
Sub getBuildInstances
11
Sub getBuildInstances
12
   Dim query
12
   Dim query
13
   query = _
13
   query = _
14
        "select bi.BUILD_ID, bi.PV_ID, bi.RTAG_ID,pv.pkg_id," &_
14
        "select bi.BUILD_ID, bi.PV_ID, bi.RTAG_ID,pv.pkg_id, bi.build_ref," &_
15
        "  SUBSTR(NVL(pj.PROJ_NAME,'-Deleted-'), 0, 60) as PROJ_NAME, " &_
15
        "  SUBSTR(NVL(pj.PROJ_NAME,'-Deleted-'), 0, 60) as PROJ_NAME, " &_
16
        "  pj.PROJ_ID, " &_
16
        "  pj.PROJ_ID, " &_
17
        "  SUBSTR(NVL(rt.RTAG_NAME,'-Deleted-'), 0, 60) as RTAG_NAME, " &_
17
        "  SUBSTR(NVL(rt.RTAG_NAME,'-Deleted-'), 0, 60) as RTAG_NAME, " &_
18
        "  TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') as TIMESTAMP, " &_
18
        "  TO_CHAR(bi.TIMESTAMP, 'Dy DD-Mon-YYYY HH24:MI:SS') as TIMESTAMP, " &_
19
        "  DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'F', 'ForcedRipple', 'Unknown') as REASON," &_
19
        "  DECODE(bi.reason, 'N', 'New Version', 'R', 'Ripple', 'T', 'Test', 'P', 'Restored', 'F', 'ForcedRipple', 'Unknown') as REASON," &_
Line 51... Line 51...
51
 
51
 
52
   OraDatabase.Parameters.Add "BUILD_ID",   nBuildId,    ORAPARM_INPUT, ORATYPE_NUMBER
52
   OraDatabase.Parameters.Add "BUILD_ID",   nBuildId,    ORAPARM_INPUT, ORATYPE_NUMBER
53
   Set utQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
53
   Set utQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
54
   OraDatabase.Parameters.Remove "BUILD_ID"
54
   OraDatabase.Parameters.Remove "BUILD_ID"
55
End Sub
55
End Sub
-
 
56
'----------------------------------------------
-
 
57
Sub BuildJsButtonHref (bState, sClass, sTitle, sImage, shref)%>
-
 
58
    <%If bState Then%>
-
 
59
		<span class="<%=sClass%>" title="<%=sTitle%>" href="<%=shref%>"><img <%=sImage%>></span>
-
 
60
    <%Else%>
-
 
61
		<span class="abtnItemDis" title="<%=sTitle%>"><img <%=sImage%> class="lessOpacity"></span>
-
 
62
    <%End If%>
-
 
63
<%End Sub
56
 
64
 
57
%>
65
%>
58
<!--#include file="_jquery_includes.asp"-->
66
<!--#include file="_jquery_includes.asp"-->
59
<script type="text/javascript" charset="utf-8">
67
<script type="text/javascript" charset="utf-8">
60
function toggleTest(id)
68
function toggleTest(id)
Line 95... Line 103...
95
        Dim displayClass1  : displayClass1  = "display-none"
103
        Dim displayClass1  : displayClass1  = "display-none"
96
        Dim displayClassI1 : displayClassI1 = "display-none"
104
        Dim displayClassI1 : displayClassI1 = "display-none"
97
        While ((NOT biQry.BOF) AND (NOT biQry.EOF))
105
        While ((NOT biQry.BOF) AND (NOT biQry.EOF))
98
      %>
106
      %>
99
      <tr> 
107
      <tr> 
-
 
108
        <td nowrap>
-
 
109
			<%BuildJsButtonHref biQry("build_ref") <> "", "vixIframeDialog", "Associated Log Files", "src='images/log_file-512.png' height=13px", "_iframe_build_logs.asp?rtag_id="&biQry("RTAG_ID")&"&build_ref="&biQry("build_ref")%>
100
        <td nowrap><%=biQry("proj_name")%></td>
110
			<%=biQry("proj_name")%>
-
 
111
	    </td>
101
        <td nowrap><%=biQry("rtag_name")%></td>
112
        <td nowrap><%=biQry("rtag_name")%></td>
102
        <td nowrap><%=biQry("timestamp")%></td>
113
        <td nowrap><%=biQry("timestamp")%></td>
103
        <td nowrap><%=biQry("reason")%></td>
114
        <td nowrap><%=biQry("reason")%></td>
104
        <td nowrap><%=biQry("state")%></td>
115
        <td nowrap><%=biQry("state")%></td>
105
      </tr>
116
      </tr>