Subversion Repositories DevTools

Rev

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

Rev 7244 Rev 7245
Line 47... Line 47...
47 
 
 47 
 
48 
    	$('.btnDel').click( function(){
 48 
    	$('.btnDel').click( function(){
49 
            var el = $(this);
 49 
            var el = $(this);
50 
            var trel = el.closest("tr");
 50 
            var trel = el.closest("tr");
51 
            var bmcon_id = trel.data("bmcon_id");
 51 
            var bmcon_id = trel.data("bmcon_id");
52 
			var machine_name = trel.find('td:eq(2)').text();
 52 
			var machine_name = trel.find('td:eq(0)').text();
53 
			var url = '_DeleteBuildMachine.asp?bmcon_id=' + bmcon_id + '&rfile=<%=scriptName%><%=objPMod.ComposeURL()%>'
 53 
			var url = '_DeleteBuildMachine.asp?bmcon_id=' + bmcon_id + '&rfile=<%=scriptName%><%=objPMod.ComposeURL()%>'
54 
            vixConfirm('Remove Build Machine \''+ machine_name +'\' from this list?',{title:'Delete Build Machine', button:'Delete', url: url});
 54 
            vixConfirm('Remove Build Machine \''+ machine_name +'\' from this list?',{title:'Delete Build Machine', button:'Delete', url: url});
55 
        });
 55 
        });
56 
 
 56 
 
57 
    	$('.btnClone').click( function(){
 57 
    	$('.btnClone').click( function(){
Line 105... Line 105...
105 
					<th>DISPLAY NAME</th>
 105 
					<th>DISPLAY NAME</th>
106 
					<th>MACHINE HOSTNAME</th>
 106 
					<th>MACHINE HOSTNAME</th>
107 
					<th>GBE_MACHTYPE</th>
 107 
					<th>GBE_MACHTYPE</th>
108 
					<th>ALLOW USE</th>
 108 
					<th>ALLOW USE</th>
109 
					<th width=250>DESCRIPTION</th>
 109 
					<th width=250>DESCRIPTION</th>
- 
 
 110 
					<th width=250>PLATFORMS</th>
110 
					<th>Edit</th>
111 
					<th>Edit</th>
111 
					</tr>
 112 
					</tr>
112 
                </thead>
 113 
                </thead>
113 
          <%
 114 
          <%
114 
          Dim rsQry
 115 
          Dim rsQry, query
115 
          Dim gbe_id, gbe_value
 116 
          Dim gbe_id, gbe_value
116 
          Dim bmcon_id
 117 
          Dim bmcon_id
117 
          Dim display_name
 118 
          Dim display_name
118 
          Dim machine_hostname, description, active, activeChecked
 119 
          Dim machine_hostname, description, active, activeChecked, platforms
- 
 
 120 
 
- 
 
 121 
		  query = "SELECT" &_
- 
 
 122 
                  "    bm.bmcon_id," &_
- 
 
 123 
                  "    bm.display_name," &_
- 
 
 124 
                  "    bm.machine_hostname," &_
- 
 
 125 
                  "    bm.description," &_
- 
 
 126 
                  "    bm.gbe_id," &_
- 
 
 127 
                  "    bm.active," &_
- 
 
 128 
                  "    gb.gbe_value," &_
- 
 
 129 
                  "    LISTAGG(bp_name, ', ') WITHIN GROUP( ORDER BY bp_name ) AS platforms" &_
- 
 
 130 
                  " FROM" &_
- 
 
 131 
                  "    build_machine_config      bm," &_
- 
 
 132 
                  "    gbe_machtype              gb," &_
- 
 
 133 
                  "    build_platforms           bp," &_
- 
 
 134 
                  "    build_platforms_config2   bpc2" &_
- 
 
 135 
                  " WHERE" &_
- 
 
 136 
                  "    bm.gbe_id = gb.gbe_id" &_
- 
 
 137 
                  "    AND bpc2.bmcon_id (+) = bm.bmcon_id" &_
- 
 
 138 
                  "    AND bp.bp_id (+) = bpc2.bp_id" &_
- 
 
 139 
                  " GROUP BY" &_
- 
 
 140 
                  "    bm.bmcon_id," &_
- 
 
 141 
                  "    bm.display_name," &_
- 
 
 142 
                  "    bm.machine_hostname," &_
- 
 
 143 
                  "    bm.description," &_
- 
 
 144 
                  "    bm.gbe_id," &_
- 
 
 145 
                  "    bm.active," &_
- 
 
 146 
                  "    gb.gbe_value" &_
- 
 
 147 
                  " ORDER BY" &_
- 
 
 148 
                  "    bm.display_name"
119
149
120 
          Set rsQry = OraDatabase.DbCreateDynaset( "SELECT bm.bmcon_id, bm.display_name,bm.machine_hostname, bm.description, bm.gbe_id, bm.active, gb.gbe_value FROM BUILD_MACHINE_CONFIG bm, GBE_MACHTYPE gb WHERE bm.gbe_id = gb.gbe_id ORDER BY bm.display_name", ORADYN_DEFAULT )
 150 
          Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
121 
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 151 
          While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
122 
              bmcon_id = rsQry("bmcon_id")
 152 
              bmcon_id = rsQry("bmcon_id")
123 
              display_name = rsQry("display_name")
 153 
              display_name = rsQry("display_name")
124 
              machine_hostname = rsQry("machine_hostname")
 154 
              machine_hostname = rsQry("machine_hostname")
125 
              active = rsQry("active")
 155 
              active = rsQry("active")
126 
              If active = "Y" Then activeChecked = "checked" Else activeChecked = ""
 156 
              If active = "Y" Then activeChecked = "checked" Else activeChecked = ""
127 
              description = rsQry("description")
 157 
              description = rsQry("description")
128 
              gbe_id = rsQry("gbe_id")
 158 
              gbe_id = rsQry("gbe_id")
129 
              gbe_value = rsQry("gbe_value")
 159 
              gbe_value = rsQry("gbe_value")
- 
 
 160 
              platforms = rsQry("platforms")
130 
              %>
 161 
              %>
131 
              <tr style="vertical-align:top;" data-bmcon_id="<%=bmcon_id%>">
 162 
              <tr style="vertical-align:top;" data-bmcon_id="<%=bmcon_id%>">
132 
                <td nowrap><%=display_name%></td>
 163 
                <td nowrap><%=display_name%></td>
133 
                <td nowrap><%=machine_hostname%></td>
 164 
                <td nowrap><%=machine_hostname%></td>
134 
                <td nowrap><%=gbe_value%></td>
 165 
                <td nowrap><%=gbe_value%></td>
135 
                <td nowrap><input type="checkbox" disabled <%=activeChecked%> ></td>
 166 
                <td nowrap><input type="checkbox" disabled <%=activeChecked%> ></td>
136 
                <td wrap><%=description%></td>
 167 
                <td wrap><%=description%></td>
- 
 
 168 
                <td wrap><%=platforms%></td>
137 
                <td nowrap class=tight>
 169 
                <td nowrap class=tight>
138 
				<%
 170 
				<%
139 
                    BuildJsButton bCanEdit, "btnEdit", "Edit basic machine properties", "src='icons/i_edit.gif'"
 171 
                    BuildJsButton bCanEdit, "btnEdit", "Edit basic machine properties", "src='icons/i_edit.gif'"
140 
                    BuildJsButton bCanEdit, "btnClone",  "Clone platform", "src='icons/i_clone.gif'"
 172 
                    BuildJsButton bCanEdit, "btnClone",  "Clone platform", "src='icons/i_clone.gif'"
141 
                    BuildJsButton bCanEdit, "btnDel ", "Delete the build machine", "src='icons/i_remove.gif'"
 173 
                    BuildJsButton bCanEdit, "btnDel ", "Delete the build machine", "src='icons/i_remove.gif'"
Line 148... Line 180...
148 
          rsQry.Close()
 180 
          rsQry.Close()
149 
          Set rsQry = nothing
 181 
          Set rsQry = nothing
150 
          %>
 182 
          %>
151
183
152 
      <tr>
 184 
      <tr>
153 
		<td align=right nowrap colspan=6 class=tight>
 185 
		<td align=right nowrap colspan=7 class=tight>
154 
		<% BuildEditButtonRaw bCanEdit, "Add Build Machine", "Add New Build Machine",TRUE, _
 186 
		<% BuildEditButtonRaw bCanEdit, "Add Build Machine", "Add New Build Machine",TRUE, _
155 
								 "src='icons/btn_add.gif' width='13' height='13' align='absmiddle' border='0' hspace='3'", _
 187 
								 "src='icons/btn_add.gif' width='13' height='13' align='absmiddle' border='0' hspace='3'", _
156 
								 "MM_openVixIFrame('wAddBuildMachine.asp','Add Build Machine')"%>
 188 
								 "MM_openVixIFrame('wAddBuildMachine.asp','Add Build Machine')"%>
157 
		</td>
 189 
		</td>
158 
      </tr>
 190 
      </tr>