Subversion Repositories DevTools

Rev

Rev 7225 | Rev 7244 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
7225 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'   admin_build_platforms.asp
5
'=====================================================
6
%>
7
<%
8
Option explicit
9
' Good idea to set when using redirect
10
Response.Expires = 0    ' always load the page, dont store
11
%>
12
<!--#include file="common/conf.asp"-->
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/formating.asp"-->
15
<!--#include file="common/qstr.asp"-->
16
<!--#include file="common/common_subs.asp"-->
17
<!--#include file="common/_form_window_common.asp"-->
18
<!--#include file="class/classActionButtonControl.asp"-->
19
<%
20
'------------ ACCESS CONTROL ------------------
21
%>
22
<!--#include file="_access_control_login_optional.asp"-->
23
<!--#include file="_access_control_general.asp"-->
24
<%
25
'------------ Variable Definition -------------
26
Dim objBtnControl
27
Dim bCanEdit
28
'------------ Constants Declaration -----------
29
'------------ Variable Init -------------------
30
Set objBtnControl = New ActionButtonControl
31
bCanEdit = canActionControl("ConfigureBuildService")
32
'----------------------------------------------
7235 dpurdie 33
'-------------------------------------------------
34
Sub InsertJavaScript %>
35
</script>
36
<%End Sub
7225 dpurdie 37
%>
38
<html>
39
<head>
40
<title>Build Machine Administration</title>
41
<link rel="shortcut icon" href="<%=FavIcon%>"/>
42
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
43
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
44
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
45
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
7235 dpurdie 46
<script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
7225 dpurdie 47
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
48
<!--#include file="_jquery_includes.asp"-->
49
<!-- DROPDOWN MENUS -->
50
<!--#include file="_menu_def.asp"-->
51
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
7235 dpurdie 52
<%Call InsertJavaScript %>
7225 dpurdie 53
</head>
54
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
55
<!-- HEADER -->
56
<!--#include file="_header.asp"-->
57
  <%
58
  '-- FROM START ---------------------------------------------------------------------------------------------------------
59
  objFormComponent.FormName = "BUILD_PLATFORMS"
60
  objFormComponent.Action = ScriptName
61
  objFormComponent.OnSubmit = "ShowProgress();"
62
  Call objFormComponent.FormStart()
63
  %>   
64
  <div class="div_table">
65
    <table border="0" cellspacing="0" cellpadding="0" class="center_table">
66
      <tr>
67
        <td>
68
            <table width="100%"  border="0" cellspacing="1" cellpadding="2" class=stdBrown>
69
                <caption>Current List of Build Platforms</caption>
70
                <thead>
71
                <tr>
72
                <!-- BUILD_MACHINE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
73
					<th>PLATFORM NAME</th>
74
					<th>ALLOW USE</th>
75
					<th width=250>DESCRIPTION</th>
7235 dpurdie 76
					<th>MACHTYPES</th>
7225 dpurdie 77
					<th>Edit</th>         
78
                </tr>
79
                </thead>
80
 
81
          <%
82
          ' Load some action buttons
83
          Call objBtnControl.LoadActionButtons ( Array("btnEditBuildPlatforms", "btnDeleteBuildPlatforms"), OraDatabase )
84
          objBtnControl.ButtonSpacer = 1
85
 
86
          If NOT bCanEdit Then
87
            Call objBtnControl.Active  ( "btnEditBuildPlatforms", "N" )
88
            Call objBtnControl.Active  ( "btnDeleteBuildPlatforms", "N" )
89
          End If
90
 
91
          Dim rsQry
92
          Dim bp_id
93
          Dim bp_name
94
          Dim description, active, activeChecked
7235 dpurdie 95
          DIM Query          
96
		  Query =   "SELECT" &_
97
                    "    bp.bp_id," &_
98
                    "    bp_name," &_
99
                    "    bp_active," &_
100
                    "    bp_description," &_
101
                    "    LISTAGG(gbe_value, ', ') within group (order by gbe_value) as machTypes" &_
102
                    " FROM" &_
103
                    "    build_platforms bp," &_
104
                    "    gbe_machtype             gbe," &_
105
                    "    build_platforms_config   bpc" &_
106
                    " WHERE" &_
107
                    "    gbe.gbe_id(+) = bpc.gbe_id" &_
108
                    "    AND bpc.bp_id(+) = bp.bp_id" &_
109
                    " GROUP BY bp.bp_id, bp_name, bp_active, bp_description" &_
110
                    " ORDER BY upper(bp.bp_name)"
111
 
112
          Set rsQry = OraDatabase.DbCreateDynaset( Query, ORADYN_DEFAULT )
7225 dpurdie 113
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
114
              bp_id = rsQry("bp_id")
115
              bp_name = rsQry("bp_name")
116
              active = rsQry("bp_active")
117
              If active = "Y" Then activeChecked = "checked" Else activeChecked = ""
118
              description = rsQry("bp_description")
119
              %>
7235 dpurdie 120
              <tr style="vertical-align:top;">
121
                <td nowrap>
122
					<%=bp_name%>
123
				</td>
7225 dpurdie 124
                <td nowrap><input type="checkbox" disabled <%=activeChecked%> ></td>
125
                <td wrap><%=description%></td>
7235 dpurdie 126
                <td wrap><%=rsQry("machTypes")%></td>
127
                <td nowrap class=tight>
128
				<%Call objBtnControl.Render( Array("btnEditBuildPlatforms", "btnDeleteBuildPlatforms"), objAccessControl )%></td>
7225 dpurdie 129
              </tr> 
130
              <%
131
              rsQry.MoveNext()
132
          Wend
133
          rsQry.Close()
134
          Set rsQry = nothing
135
          %>
136
 
137
      <tr>
7235 dpurdie 138
        <td align=right nowrap colspan=5 class=tight>
7225 dpurdie 139
		<% BuildEditButtonRaw bCanEdit, "Add Build Platform", "Insert New Build Platform",TRUE, _
140
								 "src='icons/btn_add.gif' width='13' height='13' align='absmiddle' border='0' hspace='3'", _
141
								 "MM_openVixIFrame('wAddBuildPlatform.asp','Add Build Platform')"%>
142
      </tr>
143
 
144
    </table>
145
    <%=objPMod.ComposeHiddenTags()%>
146
    <input type="hidden" name="action" value="true">
147
    <%Call objFormComponent.FormEnd()%>
148
    </table>
149
    </div>
150
<!-- FOOTER -->
151
<!--#include file="_footer.asp"-->
152
</body>
153
</html>