PHP listCells函数代码示例

function renderFlatIP()
{
    if (isset($_REQUEST['attr_id']) && isset($_REQUEST['attr_value'])) {
        $params = array('attr_id' => $_REQUEST['attr_id'], 'attr_value' => $_REQUEST['attr_value']);
        $av = $_REQUEST['attr_value'];
        if ($av === 'NULL') {
            $av = NULL;
        }
        $nets = fetchNetworksByAttr($_REQUEST['attr_id'], $av, TRUE);
    } else {
        $params = array();
        $nets = array_merge(listCells('ipv4net'), listCells('ipv6net'));
    }
    $cf = getCellFilter();
    $nets = filterCellList($nets, $cf['expression']);
    echo "<table border=0 class=objectview>\n";
    echo "<tr><td class=pcleft>";
    startPortlet(sprintf("Networks (%d)", count($nets)));
    echo '<ol>';
    foreach ($nets as $network) {
        echo '<li>';
        renderCell($network);
        echo '</li>';
    }
    echo '</ol>';
    finishPortlet();
    echo '</td><td class=pcright>';
    renderCellFilterPortlet($cf, 'ipv4net', $nets, $params);
    echo '</td></tr></table>';
}

function FullRowView()
{
    if (isset($_REQUEST['row_id'])) {
        $row_id = $_REQUEST['row_id'];
    } else {
        $rack_id = 1;
    }
    global $frvVersion;
    $rowData = getRowInfo($row_id);
    $cellfilter = getCellFilter();
    $rackList = filterCellList(listCells('rack', $row_id), $cellfilter['expression']);
    // echo "<form method=post name=ImportObject action='?module=redirect&page=row&row_id=$row_id&tab=full_row_view&op=preparePrint'>";
    echo "<font size=1em color=gray>version {$frvVersion}&nbsp;</font>";
    // echo "<input type=submit name=got_very_fast_data value='Print view'>";
    // echo "</form>";
    echo '<table><tr><td nowrap="nowrap" valign="top">';
    $count = 1;
    foreach ($rackList as $rack) {
        // echo "<br>Schrank: ${rack['name']} ${rack['id']}";
        // $rackData = spotEntity ('rack', ${rack['id']});
        echo '<div class="phgrack" style="float: top; width: 240px">';
        renderReducedRack("{$rack['id']}");
        echo '</div>';
        echo '</td><td nowrap="nowrap" valign="top">';
    }
    echo '</td></tr></table>';
}

function renderUserListEditor()
{
    function printNewItemTR()
    {
        startPortlet('Add new');
        printOpFormIntro('createUser');
        echo '<table cellspacing=0 cellpadding=5 align=center>';
        echo '<tr><th>&nbsp;</th><th>&nbsp;</th><th>Tags</th></tr>';
        echo '<tr><th class=tdright>Username</th><td class=tdleft><input type=text size=64 name=username></td>';
        echo '<tr><th class=tdright>Real name</th><td class=tdleft><input type=text size=64 name=realname></td></tr>';
        echo '<tr><th class=tdright>Password</th><td class=tdleft><input type=password size=64 name=password></td></tr>';
        echo '<tr><th class=tdright>Tags</th><td class=tdleft>';
        printTagsPicker();
        echo '</td></tr>';
        echo '<tr><td colspan=2>';
        printImageHREF('CREATE', 'Add new account', TRUE);
        echo '</td></tr>';
        echo '</table></form>';
        finishPortlet();
    }
    if (getConfigVar('ADDNEW_AT_TOP') == 'yes') {
        printNewItemTR();
    }
    $accounts = listCells('user');
    startPortlet('Manage existing (' . count($accounts) . ')');
    echo '<table cellspacing=0 cellpadding=5 align=center class=widetable>';
    echo '<tr><th>Username</th><th>Real name</th><th>New password (use old if blank)</th><th>&nbsp;</th></tr>';
    foreach ($accounts as $account) {
        printOpFormIntro('updateUser', array('user_id' => $account['user_id']));
        echo "<tr><td><input type=text name=username value='{$account['user_name']}' size=16></td>";
        echo "<td><input type=text name=realname value='{$account['user_realname']}' size=24></td>";
        echo "<td><input type=password name=password size=40></td><td>";
        printImageHREF('save', 'Save changes', TRUE);
        echo '</td></form></tr>';
    }
    echo '</table><br>';
    finishPortlet();
    if (getConfigVar('ADDNEW_AT_TOP') != 'yes') {
        printNewItemTR();
    }
}

function getProximateRacks($rack_id, $proximity = 0)
{
    $ret = array($rack_id);
    if ($proximity > 0) {
        $rack = spotEntity('rack', $rack_id);
        $rackList = doubleLink(listCells('rack', $rack['row_id']));
        $todo = $proximity;
        $cur_item = $rackList[$rack_id];
        while ($todo and array_key_exists('prev_key', $cur_item)) {
            $cur_item = $rackList[$cur_item['prev_key']];
            $ret[] = $cur_item['id'];
            $todo--;
        }
        $todo = $proximity;
        $cur_item = $rackList[$rack_id];
        while ($todo and array_key_exists('next_key', $cur_item)) {
            $cur_item = $rackList[$cur_item['next_key']];
            $ret[] = $cur_item['id'];
            $todo--;
        }
    }
    return $ret;
}

function getNarrowObjectList($varname = '')
{
    $wideList = listCells('object');
    if (strlen($varname) and strlen(getConfigVar($varname))) {
        global $parseCache;
        if (!isset($parseCache[$varname])) {
            $parseCache[$varname] = spotPayload(getConfigVar($varname), 'SYNT_EXPR');
        }
        if ($parseCache[$varname]['result'] != 'ACK') {
            return array();
        }
        $wideList = filterCellList($wideList, $parseCache[$varname]['load']);
    }
    $ret = array();
    foreach ($wideList as $cell) {
        $ret[$cell['id']] = $cell['dname'];
    }
    return $ret;
}

function renderRealServerList()
{
    global $nextorder;
    $rslist = getRSList();
    $pool_list = listCells('ipv4rspool');
    echo "<table class=widetable border=0 cellpadding=10 cellspacing=0 align=center>\n";
    echo "<tr><th>RS pool</th><th>in service</th><th>real IP address</th><th>real port</th><th>RS configuration</th></tr>";
    $order = 'even';
    $last_pool_id = 0;
    foreach ($rslist as $rsinfo) {
        if ($last_pool_id != $rsinfo['rspool_id']) {
            $order = $nextorder[$order];
            $last_pool_id = $rsinfo['rspool_id'];
        }
        echo "<tr valign=top class=row_{$order}><td>";
        $dname = strlen($pool_list[$rsinfo['rspool_id']]['name']) ? $pool_list[$rsinfo['rspool_id']]['name'] : 'ANONYMOUS';
        echo mkA($dname, 'ipv4rspool', $rsinfo['rspool_id']);
        echo '</td><td align=center>';
        if ($rsinfo['inservice'] == 'yes') {
            printImageHREF('inservice', 'in service');
        } else {
            printImageHREF('notinservice', 'NOT in service');
        }
        echo '</td><td>' . mkA($rsinfo['rsip'], 'ipaddress', $rsinfo['rsip']) . '</td>';
        echo "<td>{$rsinfo['rsport']}</td>";
        echo "<td><pre>{$rsinfo['rsconfig']}</pre></td>";
        echo "</tr>\n";
    }
    echo "</table>";
}

 function get_realm_data($realm)
 {
     $name = NULL;
     $list = array();
     $options = array();
     switch ($realm) {
         case 'object':
             $name = 'Load balancer';
             $list = getNarrowObjectList('IPV4LB_LISTSRC');
             $options = array('name' => 'object_id');
             break;
         case 'ipvs':
             $name = 'Virtual service';
             $list = formatEntityList(listCells('ipvs'));
             $options = array('name' => 'vs_id');
             break;
         case 'ipv4rspool':
             $name = 'RS pool';
             $list = formatEntityList(listCells('ipv4rspool'));
             $options = array('name' => 'rspool_id');
             break;
         default:
             throw new InvalidArgException('realm', $realm);
     }
     return array('name' => $name, 'list' => $list, 'options' => $options);
 }

function getIPv4RSPoolOptions()
{
    $ret = array();
    foreach (listCells('ipv4rspool') as $pool_id => $poolInfo) {
        $ret[$pool_id] = $poolInfo['name'];
    }
    return $ret;
}

//.........这里部分代码省略.........
    $result = usePreparedSelectBlade('SELECT CONSTRAINT_NAME, TABLE_NAME ' . 'FROM information_schema.TABLE_CONSTRAINTS ' . "WHERE CONSTRAINT_SCHEMA = SCHEMA() AND CONSTRAINT_TYPE = 'FOREIGN KEY'");
    $rows = $result->fetchAll(PDO::FETCH_ASSOC);
    unset($result);
    $existing_fkeys = $missing_fkeys = array();
    foreach ($rows as $row) {
        $existing_fkeys[$row['CONSTRAINT_NAME']] = $row['TABLE_NAME'];
    }
    foreach ($fkeys as $fkey => $table) {
        if (!array_key_exists($fkey, $existing_fkeys)) {
            $missing_fkeys[$fkey] = $table;
        }
    }
    if (count($missing_fkeys)) {
        $violations = TRUE;
        startPortlet('Missing Foreign Keys (' . count($missing_fkeys) . ')');
        echo "<table cellpadding=5 cellspacing=0 align=center class=cooltable>\n";
        echo "<tr><th>Table</th><th>Key</th></tr>\n";
        $order = 'odd';
        foreach ($missing_fkeys as $fkey => $table) {
            echo "<tr class=row_{$order}>";
            echo "<td>{$table}</td>";
            echo "<td>{$fkey}</td>";
            echo "</tr>\n";
            $order = $nextorder[$order];
        }
        echo "</table>\n";
        finishPortLet();
    }
    // check 10: circular references
    //     - all affected members of the tree are displayed
    //     - it would be beneficial to only display the offending records
    // check 10.1: locations
    $invalids = array();
    $locations = listCells('location');
    foreach ($locations as $location) {
        try {
            $children = getLocationChildrenList($location['id']);
        } catch (RackTablesError $e) {
            $invalids[] = $location;
        }
    }
    if (count($invalids)) {
        $violations = TRUE;
        startPortlet('Locations: Tree Contains Circular References (' . count($invalids) . ')');
        echo "<table cellpadding=5 cellspacing=0 align=center class=cooltable>\n";
        echo "<tr><th>Child ID</th><th>Child Location</th><th>Parent ID</th><th>Parent Location</th></tr>\n";
        $order = 'odd';
        foreach ($invalids as $invalid) {
            echo "<tr class=row_{$order}>";
            echo "<td>{$invalid['id']}</td>";
            echo "<td>{$invalid['name']}</td>";
            echo "<td>{$invalid['parent_id']}</td>";
            echo "<td>{$invalid['parent_name']}</td>";
            echo "</tr>\n";
            $order = $nextorder[$order];
        }
        echo "</table>\n";
        finishPortLet();
    }
    // check 10.2: objects
    $invalids = array();
    $objects = listCells('object');
    foreach ($objects as $object) {
        try {
            $children = getObjectContentsList($object['id']);
        } catch (RackTablesError $e) {

     foreach ($racklist as $rack_id) {
         usePreparedDeleteBlade('RackThumbnail', array('rack_id' => $rack_id));
     }
     // redirect to the depot method
     redirectUser($_SERVER['SCRIPT_NAME'] . "?method=get_depot");
     break;
     // get all objects
     //    UI equivalent: /index.php?page=depot&tab=default
     //    UI handler: renderDepot()
 // get all objects
 //    UI equivalent: /index.php?page=depot&tab=default
 //    UI handler: renderDepot()
 case 'get_depot':
     require_once 'inc/init.php';
     $cellfilter = getCellFilter();
     $objects = filterCellList(listCells('object'), $cellfilter['expression']);
     // get details if requested
     if (isset($_REQUEST['include_attrs'])) {
         foreach ($objects as $object_id => $object) {
             amplifyCell($object);
             // return the attributes in an array keyed on 'name', unless otherwise requested
             $key_attrs_on = 'name';
             if (isset($_REQUEST['key_attrs_on'])) {
                 $key_attrs_on = $_REQUEST['key_attrs_on'];
             }
             $attrs = array();
             foreach (getAttrValues($object_id) as $record) {
                 // check that the key exists for this record
                 if (!isset($record[$key_attrs_on])) {
                     throw new InvalidRequestArgException('key_attrs_on', $_REQUEST['key_attrs_on'], 'requested keying value not set for all attributes');
                 }

function getWattsPerRow()
{
    // assertions
    // find the needed attributes
    global $nextorder;
    // Was this function called with a specific row_id?
    if (isset($_REQUEST['row_id'])) {
        assertStringArg('row_id');
        $row_toshow = $_REQUEST['row_id'];
    } else {
        $row_toshow = -1;
    }
    //from renderRackspace(), interface.php:151
    $found_racks = array();
    $rows = array();
    $cellfilter = getCellFilter();
    $rackCount = 0;
    $order = 'odd';
    // get rackspace information
    foreach (getAllRows() as $row_id => $rowInfo) {
        $rackList = filterCellList(listCells('rack', $row_id), $cellfilter['expression']);
        $found_racks = array_merge($found_racks, $rackList);
        $rows[] = array('location_id' => $rowInfo['location_id'], 'location_name' => $rowInfo['location_name'], 'row_id' => $row_id, 'row_name' => $rowInfo['name'], 'racks' => $rackList);
        $rackCount += count($rackList);
    }
    // Main layout starts.
    echo "<table border=0 class=objectview cellspacing=0 cellpadding=0>";
    // Left portlet with list of rows.
    echo "<tr><td class=pcleft width='50%'>";
    startPortlet('Rack Rows (' . count($rows) . ')');
    echo "<table border=0 cellspacing=0 cellpadding=3 width='100%'>\n";
    foreach ($rows as $row) {
        $row_id = $row['row_id'];
        $row_name = $row['row_name'];
        $row_location = $row['location_name'];
        $rackList = $row['racks'];
        echo "<tr class=row_{$order}><td width='20%'></td><td class=tdleft>";
        if (!count($rackList)) {
            echo "{$row_location} - {$row_name} (empty row)";
        } else {
            echo "<a href='" . makeHref(array('page' => 'reports', 'tab' => 'watts_per_row', 'row_id' => $row_id)) . "'>{$row_location} - {$row_name}</a>";
        }
        echo "<td><tr>\n";
        $order = $nextorder[$order];
    }
    echo "</td></tr>\n";
    echo "</table><br>\n";
    finishPortlet();
    echo "</td><td class=pcright>";
    // Right Portlet: Draw the racks in the selected row
    if ($row_toshow > -1) {
        $rowInfo = getRowInfo($row_toshow);
        $cellfilter = getCellFilter();
        $rackList = filterCellList(listCells('rack', $row_toshow), $cellfilter['expression']);
        $rackwidth = getRackImageWidth() * getConfigVar('ROW_SCALE');
        // Maximum number of racks per row is proportionally less, but at least 1.
        $maxPerRow = max(floor(getConfigVar('RACKS_PER_ROW') / getConfigVar('ROW_SCALE')), 1);
        $rackListIdx = 0;
        $rowTotalWattage = 0;
        $order = 'odd';
        startPortlet('Racks within ' . $rowInfo['name'] . ' (' . count($rackList) . ')');
        echo "<table border=0 cellspacing=5 align='center'><tr>";
        foreach ($rackList as $rack) {
            $rackTotalWattage = 0;
            // see renderRack(), interface.php:311
            $rackData = spotEntity('rack', $rack['id']);
            amplifyCell($rackData);
            $objectChildren = getEntityRelatives('children', 'object', $objectData['id']);
            foreach ($rackData['mountedObjects'] as $object) {
                $objectData = spotEntity('object', $object);
                amplifyCell($objectData);
                foreach (getAttrValues($objectData['id']) as $record) {
                    if ($record['name'] == 'Wattage consumption') {
                        $rackTotalWattage += $record['value'];
                    }
                }
            }
            if ($rackListIdx % $maxPerRow == 0) {
                echo $rackListIdx > 0 ? '</tr><tr>' : '<tr>';
            }
            echo "<td align=center class=row_{$order}><a href='" . makeHref(array('page' => 'rack', 'rack_id' => $rack['id'])) . "'>";
            echo "<img border=0 width={$rackwidth} height=" . getRackImageHeight($rack['height']) * getConfigVar('ROW_SCALE');
            echo " title='{$rack['height']} units'";
            echo "src='?module=image&img=minirack&rack_id={$rack['id']}'>";
            echo "<br>{$rack['name']} ({$rackTotalWattage})</a></td>";
            $order = $nextorder[$order];
            $rackListIdx++;
            $rowTotalWattage += $rackTotalWattage;
        }
        echo "</tr><tr><td align=center colspan=";
        print count($rackList);
        echo "><br><b>The row total for attribute Wattage consuption is:  {$rowTotalWattage}</b></td>\n";
        echo "</tr></table>\n";
        finishPortlet();
    }
    echo "</td></tr></table>";
}

function renderSearchNewIP4Range()
{
    global $pTable;
    // prepare $cellfilter
    $cellfilter = getCellFilter();
    if ($cellfilter['is_empty'] || !isset($_REQUEST['cfp'])) {
        if (defined('SPARE_SEARCH_PREDICATE') && isset($pTable[SPARE_SEARCH_PREDICATE])) {
            $_REQUEST['cfp'] = array(SPARE_SEARCH_PREDICATE);
            $cellfilter = getCellFilter();
        }
    }
    $mask = NULL;
    if (!empty($_REQUEST['pref_len'])) {
        $mask = intval($_REQUEST['pref_len']);
    }
    $nets = array();
    foreach (filterCellList(listCells('ipv4net'), $cellfilter['expression']) as $net) {
        if (!isset($mask)) {
            $nets[] = $net;
        } elseif ($net['mask'] <= $mask) {
            $is_aggregate = FALSE;
            foreach ($net['atags'] as $atag) {
                if ($atag['tag'] == '$aggregate') {
                    $is_aggregate = TRUE;
                } elseif (preg_match('/^\\$spare_(\\d+)$/', $atag['tag'], $m) && $mask >= $m[1]) {
                    $nets[] = $net;
                    continue 2;
                }
            }
            if (!$is_aggregate) {
                $nets[] = $net;
            }
        }
    }
    $filter = getOutputOf('renderCellFilterPortlet', $cellfilter, 'ipv4net', $nets);
    echo '<table width="100%"><tr valign=top>';
    echo '<td>';
    startPortlet("Results (" . count($nets) . ")");
    echo '<ul class="spare-nets">';
    foreach ($nets as $net) {
        echo '<li>';
        renderNetCellForAlloc($net, $mask);
        echo '</li>';
    }
    echo '</ul>';
    finishPortlet();
    echo '</td>';
    echo '<td width="33%">';
    echo preg_replace_callback('/(<form[^<>]*>)/', 'generatePrefixLengthInput', $filter);
    echo '</td>';
    echo '</tr></table>';
    addCSS(<<<END
ul.spare-nets {
\tlist-style: none;
\tpadding: 0px;
}
ul.spare-nets li {
\tmargin: 5px 0px;
}

END
, TRUE);
}

function getLocationSelectAJAX()
{
    $locationlist = listCells('location');
    $locationtree = treeFromList($locationlist);
    // adds ['trace'] keys into $locationlist items
    $options = array();
    $selected_id = '';
    if (!isset($_REQUEST['locationid'])) {
        $options['error'] = "Sorry, param 'locationid' is empty. Reload page and try again";
    } elseif (!preg_match("/locationid_(\\d+)/i", $_REQUEST['locationid'], $m)) {
        $options['error'] = "Sorry, wrong format locationid:'" . $_REQUEST['locationid'] . "'. Reload page and try again";
    } else {
        $current_location_id = $m[1];
        $selected_id = $locationlist[$current_location_id]['parent_id'];
        echo $selected_id;
        echo "<option value=0>-- NONE --</option>";
    }
    foreach ($locationtree as $location) {
        if ($location['id'] == $current_location_id) {
            continue;
        }
        echo "<option value={$location['id']} ";
        if ($location['id'] == $selected_id) {
            echo 'selected ';
        }
        echo "style='font-weight: bold'>{$location['name']}</option>";
        if ($location['kidc'] > 0) {
            printLocationChildrenSelectOptions($location, 0, $selected_id, $current_location_id);
        }
    }
}

 function __construct($object_id = NULL, $port_id = NULL, $allports = false, $hl = NULL, $remote_id = NULL)
 {
     $this->allports = $allports;
     $this->object_id = $object_id;
     $this->port_id = $port_id;
     $this->remote_id = $remote_id;
     $this->hl = $hl;
     $hllabel = "";
     /* suppress strict standards warnings for Image_GraphViz and PHP 5.4.0
      * output would corrupt image data
      */
     $this->errorlevel = error_reporting();
     error_reporting($this->errorlevel & ~E_STRICT);
     $graphattr = array('rankdir' => 'LR', 'nodesep' => '0');
     unset($_GET['module']);
     $_GET['all'] = 1;
     $graphattr['URL'] = $this->_makeHrefProcess($_GET);
     unset($_GET['all']);
     switch ($hl) {
         case 'o':
         case 'p':
             $this->alpha = '30';
             break;
     }
     //$this->gv = new Image_GraphViz(true, $graphattr, "map".$object_id);
     $this->gv = new lm_Image_GraphViz(true, $graphattr, "map" . $object_id);
     /* --------------------------- */
     if ($object_id === NULL) {
         /* all objects ! */
         unset($_GET['all']);
         $_GET['hl'] = 'o';
         $this->gv->addAttributes(array('label' => 'Showing all objects' . $hllabel, 'labelloc' => 't'));
         $objects = listCells('object');
         foreach ($objects as $obj) {
             //$this->addlinkchainsobject($obj['id']); // longer runtimes !!
             $this->_add($this->gv, $obj['id'], NULL);
         }
         // for all still faster and nicer looking graph
         return;
     } else {
         $object = spotEntity('object', $object_id);
         $this->gv->addAttributes(array('label' => "Graph for {$object['dname']}{$hllabel}", 'labelloc' => 't'));
         $this->addlinkchainsobject($object_id);
         //$this->_add($this->gv, $object_id, $port_id);
         $children = getEntityRelatives('children', 'object', $object_id);
         //'entity_id'
         foreach ($children as $child) {
             $this->addlinkchainsobject($child['entity_id']);
         }
         //	$this->_add($this->gv, $child['entity_id'], NULL);
     }
     /* add hl label */
     $this->gv->addAttributes(array('label' => $this->gv->graph['attributes']['label'] . $hllabel));
     //	portlist::var_dump_html($this->gv);
     //		portlist::var_dump_html($this->data);
     //		echo json_encode($this->data);
     //	$this->gv->saveParsedGraph('/tmp/graph.txt');
     //	error_reporting( E_ALL ^ E_NOTICE);
 }

function getVSTOptions()
{
    $ret = array();
    foreach (listCells('vst') as $vst) {
        $ret[$vst['id']] = niftyString($vst['description'], 30, FALSE);
    }
    return $ret;
}