Subversion Repositories DevTools

Rev

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