Subversion Repositories DevTools

Rev

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

Rev 7225 Rev 7235
Line 28... Line 28...
28
'------------ Constants Declaration -----------
28
'------------ Constants Declaration -----------
29
'------------ Variable Init -------------------
29
'------------ Variable Init -------------------
30
Set objBtnControl = New ActionButtonControl
30
Set objBtnControl = New ActionButtonControl
31
bCanEdit = canActionControl("ConfigureBuildService")
31
bCanEdit = canActionControl("ConfigureBuildService")
32
'----------------------------------------------
32
'----------------------------------------------
-
 
33
'-------------------------------------------------
-
 
34
Sub InsertJavaScript %>
-
 
35
</script>
-
 
36
<%End Sub
33
%>
37
%>
34
<html>
38
<html>
35
<head>
39
<head>
36
<title>Build Machine Administration</title>
40
<title>Build Machine Administration</title>
37
<link rel="shortcut icon" href="<%=FavIcon%>"/>
41
<link rel="shortcut icon" href="<%=FavIcon%>"/>
38
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
42
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
39
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
43
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
40
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
44
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
41
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
45
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
-
 
46
<script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
42
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
47
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
43
<!--#include file="_jquery_includes.asp"-->
48
<!--#include file="_jquery_includes.asp"-->
44
<!-- DROPDOWN MENUS -->
49
<!-- DROPDOWN MENUS -->
45
<!--#include file="_menu_def.asp"-->
50
<!--#include file="_menu_def.asp"-->
46
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
51
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
-
 
52
<%Call InsertJavaScript %>
47
</head>
53
</head>
48
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
54
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
49
<!-- HEADER -->
55
<!-- HEADER -->
50
<!--#include file="_header.asp"-->
56
<!--#include file="_header.asp"-->
51
 
-
 
52
  <%
57
  <%
53
  '-- FROM START ---------------------------------------------------------------------------------------------------------
58
  '-- FROM START ---------------------------------------------------------------------------------------------------------
54
  objFormComponent.FormName = "BUILD_PLATFORMS"
59
  objFormComponent.FormName = "BUILD_PLATFORMS"
55
  objFormComponent.Action = ScriptName
60
  objFormComponent.Action = ScriptName
56
  objFormComponent.OnSubmit = "ShowProgress();"
61
  objFormComponent.OnSubmit = "ShowProgress();"
Line 66... Line 71...
66
                <tr>
71
                <tr>
67
                <!-- BUILD_MACHINE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
72
                <!-- BUILD_MACHINE DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
68
					<th>PLATFORM NAME</th>
73
					<th>PLATFORM NAME</th>
69
					<th>ALLOW USE</th>
74
					<th>ALLOW USE</th>
70
					<th width=250>DESCRIPTION</th>
75
					<th width=250>DESCRIPTION</th>
-
 
76
					<th>MACHTYPES</th>
71
					<th>Edit</th>         
77
					<th>Edit</th>         
72
                </tr>
78
                </tr>
73
                </thead>
79
                </thead>
74
 
80
 
75
          <%
81
          <%
Line 84... Line 90...
84
          
90
          
85
          Dim rsQry
91
          Dim rsQry
86
          Dim bp_id
92
          Dim bp_id
87
          Dim bp_name
93
          Dim bp_name
88
          Dim description, active, activeChecked
94
          Dim description, active, activeChecked
89
          
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
 
90
          Set rsQry = OraDatabase.DbCreateDynaset( "SELECT bp_id, bp_name, bp_active, bp_description FROM BUILD_PLATFORMS bp ORDER BY UPPER(bp.bp_name)", ORADYN_DEFAULT )
112
          Set rsQry = OraDatabase.DbCreateDynaset( Query, ORADYN_DEFAULT )
91
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
113
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
92
              bp_id = rsQry("bp_id")
114
              bp_id = rsQry("bp_id")
93
              bp_name = rsQry("bp_name")
115
              bp_name = rsQry("bp_name")
94
              active = rsQry("bp_active")
116
              active = rsQry("bp_active")
95
              If active = "Y" Then activeChecked = "checked" Else activeChecked = ""
117
              If active = "Y" Then activeChecked = "checked" Else activeChecked = ""
96
              description = rsQry("bp_description")
118
              description = rsQry("bp_description")
97
              %>
119
              %>
98
              <tr style="vertical-align:top;" >
120
              <tr style="vertical-align:top;">
99
                <td nowrap><%=bp_name%></td>
121
                <td nowrap>
-
 
122
					<%=bp_name%>
-
 
123
				</td>
100
                <td nowrap><input type="checkbox" disabled <%=activeChecked%> ></td>
124
                <td nowrap><input type="checkbox" disabled <%=activeChecked%> ></td>
101
                <td wrap><%=description%></td>
125
                <td wrap><%=description%></td>
-
 
126
                <td wrap><%=rsQry("machTypes")%></td>
-
 
127
                <td nowrap class=tight>
102
                <td nowrap class=tight><%Call objBtnControl.Render( Array("btnEditBuildPlatforms", "btnDeleteBuildPlatforms"), objAccessControl )%></td>
128
				<%Call objBtnControl.Render( Array("btnEditBuildPlatforms", "btnDeleteBuildPlatforms"), objAccessControl )%></td>
103
              </tr> 
129
              </tr> 
104
              <%
130
              <%
105
              rsQry.MoveNext()
131
              rsQry.MoveNext()
106
          Wend
132
          Wend
107
          rsQry.Close()
133
          rsQry.Close()
108
          Set rsQry = nothing
134
          Set rsQry = nothing
109
          %>
135
          %>
110
        
136
        
111
      <tr>
137
      <tr>
112
        <td align=right nowrap colspan=4 class=tight>
138
        <td align=right nowrap colspan=5 class=tight>
113
		<% BuildEditButtonRaw bCanEdit, "Add Build Platform", "Insert New Build Platform",TRUE, _
139
		<% BuildEditButtonRaw bCanEdit, "Add Build Platform", "Insert New Build Platform",TRUE, _
114
								 "src='icons/btn_add.gif' width='13' height='13' align='absmiddle' border='0' hspace='3'", _
140
								 "src='icons/btn_add.gif' width='13' height='13' align='absmiddle' border='0' hspace='3'", _
115
								 "MM_openVixIFrame('wAddBuildPlatform.asp','Add Build Platform')"%>
141
								 "MM_openVixIFrame('wAddBuildPlatform.asp','Add Build Platform')"%>
116
      </tr>
142
      </tr>
117
 
143