<?php

/**
 * PIMPED APACHE-STATUS
 * datarenderer helps to render tiles and output sections with title,
 * hint, sortable tables
 *
 * @package pimped_apache_status
 * @author Axel Hahn
 */
class Datarenderer {

    /**
     * allowed tilenames - these keys have predefined filter rules
     * @var array
     */
    private $aValidTiles = array(
        'server_count',
        'server_responsetime',
        'requests_all',
        'requests_running',
        'requests_clients',
        'requests_mostrequested',
        'requests_longest',
    );

    /**
     * allowed tablenames - these keys have predefined filter rules
     * @var array
     */
    private $aValidTables = array(
        'status',
        'requests_all',
        'requests_running',
        'requests_mostrequested',
        'requests_hostlist',
        'requests_methods',
        'requests_clients',
        'requests_longest',
        'worker_status',
    ); // allowed tables

    /**
     * list of filterarrays; these are filter rules for tiles and tables
     * and will be used for for $oServerStatus->dataFilter to generate
     * a view to the server status data
     * @var array
     */
    private $aFilterPresets = array(
        'status' => array('sType' => 'status'),
        'requests_all' => array('sType' => 'requests'),
        'requests_running' => array(
            'sType' => 'requests',
            'aRules' => array(
                array("add", "M", "gt", " "),
                array("remove", "M", "eq", "_"),
                array("remove", "M", "eq", "."),
            ),
        ),
        'requests_mostrequested' => array(
            'sType' => 'requests',
            // 'sSortkey' => array('Request', 'VHost'),
            'sSortkey' => 'Request',
            'bGroup' => true,
        ),
        'requests_hostlist' => array(
            'sType' => 'requests',
            'sSortkey' => 'VHost',
            'bGroup' => true,
        ),
        'requests_methods' => array(
            'sType' => 'requests',
            'sSortkey' => 'Method',
            'bGroup' => true,
        ),
        'requests_clients' => array(
            'sType' => 'requests',
            'sSortkey' => 'Client',
            'bGroup' => true,
        ),
        'requests_longest' => array(
            'sType' => 'requests',
            'aRows' => array("Req", "M", "VHost", "Request", "Webserver", "Comment"),
            'sSortkey' => 'Req',
            'sortorder' => SORT_DESC,
            'iLimit' => 25,
        ),
        'server_count' => array(
            'sType' => 'meta',
        ),
        'server_responsetime' => array(
            'sType' => 'meta',
        ),
        'workers_table' => array(
            'callfunction' => "_getWorkersData",
        ),
    );

    /**
     * list of css classnames for request methods, http methods and exectime
     * that will be used for all tables with request data
     * @var type 
     */
    private $aCssRows = array(
        'M' => array(
            '_' => array('class' => 'actunderscore'),
            'S' => array('class' => 'actS'),
            'R' => array('class' => 'actR'),
            'W' => array('class' => 'actW'),
            'K' => array('class' => 'actK'),
            'D' => array('class' => 'actD'),
            'C' => array('class' => 'actC'),
            'L' => array('class' => 'actL'),
            'G' => array('class' => 'actG'),
            'I' => array('class' => 'actI'),
            '.' => array('class' => 'actdot'),
        ),
        'Request' => array(
            // http methods:
            // http://www.w3.org/Protocols/rfc2616/rfc2616-sec9.html
            'GET' => array('class' => 'methodget'),
            'HEAD' => array('class' => 'methodhead'),
            'POST' => array('class' => 'methodpost'),
            'PUT' => array('class' => 'methodput'),
            'DELETE' => array('class' => 'methoddelete'),
            'TRACE' => array('class' => 'methodtrace'),
            'CONNECT' => array('class' => 'methodconnect'),
            // other things in apache server-status:
            'NULL' => array('class' => 'methodnull'),
            'OPTIONS' => array('class' => 'methodoptions'),
            'PROPFIND' => array('class' => 'methodpropfind'),
        ),
        'exectime' => array(
            'warning' => array('class' => 'exectimewarn'),
            'critical' => array('class' => 'exectimecritical'),
        ),
    );

    /**
     * export types for tables
     * @var array
     */
    private $aExports = array(
        'csv' => array('mime' => 'text/csv', 'ext' => 'csv'),
        'json' => array('mime' => 'application/json', 'ext' => 'json'),
        'serialize' => array('mime' => 'text/plain', 'ext' => 'data'),
        'xml' => array('mime' => 'text/xml', 'ext' => 'xml'),
    );

    /**
     * constructor (it does nothing)
     * @return boolean (true)
     */
    public function __construct() {

        // this test disables xml export if php-xml is not available
        if (!class_exists("DomDocument")) {
            unset($this->aExports["xml"]);
        }

        return true;
    }

    // ----------------------------------------------------------------------
    // GETTER
    // ----------------------------------------------------------------------

    /**
     * helper function: get the position of a key in an 
     * associated array
     * @param string $keyname
     * @param array $array
     * @return int 
     */
    private function _getNumberOfArraykey($keyname, $array) {
        global $aUserCfg;
        if (!count($array)) {
            return false;
        }
        $i = 0;
        foreach (array_keys($array) as $key) {
            if (in_array($key, $aUserCfg["hideRows"])) {
                continue;
            }
            if ($key == $keyname) {
                return $i;
            }
            $i++;
        }
        return false;
    }

    /**
     * get all maximum values of each column of a table; result is an array 
     * with column names as key and the maximum of this column
     * @param array $aTable
     * @return array
     */
    private function _getMaxima($aTable) {
        $aReturn = array();
        foreach ($aTable as $row) {
            foreach (array_keys($row) as $key) {
                if (!array_key_exists($key, $aReturn)) {
                    $aReturn[$key] = $row[$key];
                }
                if ($row[$key] > $aReturn[$key]) {
                    $aReturn[$key] = $row[$key];
                }
            }
        }
        return $aReturn;
    }

    /**
     * built an html tablerow for a single request
     * @global array $aLangTxt
     * @global type $aUserCfg
     * @param array $aRows
     * @param type $aHeader
     * @param type $sTableID
     * @return string
     */
    private function _getReqLine($aRows, $aHeader, $sTableID = false, $aMax = array()) {

        global $aLangTxt; // texts
        global $aUserCfg; // configuration

        $aClick2Filter = array("Client", "VHost", "Request", "Method", "Comment");
        $sHtml = '';
        $sClass = '';
        $sComment = '';

        $iExecWarn = $aUserCfg['execTimeRequest']['warning'];
        $iExecCritical = $aUserCfg['execTimeRequest']['critical'];

        $aClasses = $this->getCssClasses();

        if (array_key_exists('M', $aRows)) {
            $sM = $aRows['M']; // status of http
            if ($aClasses['M'][$sM]) {
                $sComment.=$aLangTxt['lblStatus'] . ': ' . $aLangTxt['cmtStatus' . $sM] . ' ';
                $sClass.=$aClasses['M'][$sM]['class'] . ' ';
            }
        }

        if (array_key_exists('Req', $aRows)) {
            $iExecTime = $aRows['Req']; // exec time of the request
            if ($iExecTime >= $iExecWarn && $iExecTime < $iExecCritical) {
                $sClass.="exectimewarn ";
                $sComment.='Warnung: Exec= ' . $iExecTime / 1000 . ' s (>' . $iExecWarn . ' ms).';
            }
            if ($iExecTime >= $iExecCritical) {
                $sClass.="exectimecritical ";
                $sComment.='CRITICAL: Exec= ' . $iExecTime / 1000 . ' s. (>' . $iExecCritical . ' ms).';
            }
        }

        if (array_key_exists('Request', $aRows)) {
            $sR = preg_replace('/([A-Z]*)\ .*/', "$1", $aRows['Request']);
            if (array_key_exists($sR, $aClasses['Request'])) {
                if (array_key_exists('class', $aClasses['Request'][$sR]))
                    $sClass.=$aClasses['Request'][$sR]['class'] . ' ';
            }
            // if ($aCfgTabledata['status'][$sM]) {
            if (strpos($sR, "OPTIONS ") === 0) {
                $sClass.="typeoptions ";
            }
            if (strpos($sR, "HEAD ") === 0) {
                $sClass.="typehead ";
            }
            if (strpos($sR, "GET ") === 0) {
                $sClass.="typeget ";
            }
            if (strpos($sR, "POST ") === 0) {
                $sClass.="typepost ";
            }
            if (strpos($sR, "PROPFIND ") === 0) {
                $sClass.="typepropfind ";
            }
        }

        $aRows['Comment'] = $sComment;


        $sHtml.= "<tr class=\"$sClass\">";
        foreach (array_keys($aHeader) as $key) {
            if (in_array($key, $aUserCfg["hideRows"])) {
                continue;
            }
            $s = $aRows[$key];

            if ($sTableID) {
                foreach ($aClick2Filter as $sFilterkey) {
                    if ($key == $sFilterkey) {
                        $s = '<a 
                            href="#" 
                            title="' . $aLangTxt['lblHintFilter'] . ' ' . $key . ' &laquo;' . $s . '&raquo;"
                            onclick="$(\'#' . $sTableID . '_filter>INPUT\').val(\'' . $s . '\'); $(\'#' . $sTableID . '\').dataTable().fnFilter(\'' . $s . '\'); return false;"
                            >' . $s . '</a>';
                    }
                }
            }

            if (
                    array_key_exists("tdlink", $aUserCfg) && array_key_exists($key, $aUserCfg["tdlink"])
            ) {
                $sLink = '';
                foreach ($aUserCfg["tdlink"][$key] as $sAttr => $sVal) {
                    $sLink.=$sAttr . '="' . sprintf($sVal, $aRows[$key]) . '" ';
                }
                if ($sLink) {
                    $s = '<a ' . $sLink . '>' . $aRows[$key] . '</a>';
                }
            }

            $sHtml.='<td>' . $s . '</td>';

            // v1.07: bar
            if (array_key_exists("tdbars", $aUserCfg)) {
                foreach ($aUserCfg["tdbars"] as $sCol) {
                    if ($key == $sCol ||
                            (array_key_exists($sCol, $aLangTxt) && $key == $aLangTxt[$sCol])
                    ) {
                        $iMax = false;
                        if (array_key_exists($key, $aMax))
                            $iMax = $aMax[$key];
                        if ($iMax <> 0) {
                            $iValue = $aRows[$key];
                            $iWidth = round($iValue / $iMax * 100);
                            $sHtml.='<td>
                                        <div class="barTotal" style="width: 50px; float: right;"
                                            title="' . $key . '=' . $iValue . ' (' . $iWidth . '%)" 
                                            ><div class="barValue"     
                                                style="width:' . $iWidth . '%;"
                                                >&nbsp;</div>
                                        </div>
                                    </td>';
                        }
                    }
                }
            }
        }

        $sHtml.= "</tr>";

        return $sHtml;
    }

    /**
     * get array keys for server-status tables for infos and for requests
     * @param array  $aSrvData  server status data
     * @param string $sType     type; one of status|requests
     * @return array
     */
    private function _getTableheads($aSrvData, $sType) {
        $aTmp = array();
        foreach ($aSrvData as $sHost => $aData) {
            if (array_key_exists("status", $aData) && count($aData['status'])) {
                foreach ($aData['status'] as $sKey => $aData2) {
                    $aTmp['status'][$sKey] = true;
                }
            }
            if (array_key_exists("requests", $aData) && count($aData['requests'])) {
                foreach ($aData['requests'] as $sKey => $aData2) {
                    foreach (array_keys($aData2) as $key)
                        $aTmp['requests'][$key] = true;
                }
            }
        }
        $aTmp['requests']['Method'] = true;
        $aTmp['requests']['Comment'] = true;

        return array_key_exists($sType, $aTmp) ? array_keys($aTmp[$sType]) : array();
    }

    /**
     * get list of valid filters
     * @return array
     */
    public function getValidFilters($aSrvData) {
        $aTmp = $this->aFilterPresets;

        foreach ($aTmp as $f => $data) {
            if (!array_key_exists("callfunction", $data) && !array_key_exists("aRows", $data)) {
                $aTmp[$f]["aRows"] = $this->_getTableheads($aSrvData, $data["sType"]);
            }
        }
        return $aTmp;
    }

    /**
     * get list of valid keys of tiles
     * @return array
     */
    public function getValidTiles() {
        return $this->aValidTiles;
    }

    /**
     * get css classes
     * you get classnames for request methods, http methods and exectime
     * that will be used for all tables with request data
     * @return array
     */
    public function getCssClasses() {
        return $this->aCssRows;
    }

    /**
     * get available export formats 
     * @return array
     */
    public function getExportFormats() {
        return $this->aExports;
    }

    // ----------------------------------------------------------------------
    // SETTER
    // ----------------------------------------------------------------------
    // ----------------------------------------------------------------------
    // OUTPUT
    // ----------------------------------------------------------------------

    /**
     * create bookmarklet with the current installation of pimped apachestatus
     * @return string
     */
    public function genBookmarklet($sLabel = 'Pimped Apache Status') {
        $sMyUrl = "http";
        $sMyUrl.="://";
        $sMyUrl.=$_SERVER["HTTP_HOST"];
        $sMyUrl.=$_SERVER["SCRIPT_NAME"];
        $sMyUrl.="?url=";

        $sHref = "javascript:document.location.href='$sMyUrl'+encodeURI(document.location.href);";

        return '<a href="' . $sHref . '">' . $sLabel . '</a>';
    }

    /**
     * get Export links of a table with a given filter
     * @param type $sFiltername
     * @return boolean|string
     */
    public function genExportLinks($sFiltername) {
        if (!$sFiltername)
            return false;

        $sBaseUrl = '?skin=data&amp;filter=' . $sFiltername;
        if (array_key_exists("group", $_GET)) {
            $sBaseUrl.='&amp;group=' . urlencode($_GET["group"]);
        }
        if (array_key_exists("servers", $_GET)) {
            $sBaseUrl.='&amp;servers=' . urlencode($_GET["servers"]);
        }
        if (array_key_exists("url", $_GET)) {
            $sBaseUrl.='&amp;url=' . urlencode($_GET["url"]);
        }
        if (array_key_exists("lang", $_GET)) {
            $sBaseUrl.='&amp;lang=' . urlencode($_GET["lang"]);
        }
        foreach ($this->getExportFormats() as $sFormat => $data) {
            $aExportLinks[$sFormat] = array(
                'url' => $sBaseUrl . '&amp;format=' . $sFormat,
                'label' => $sFormat,
            );
        }
        return $aExportLinks;
    }

    /**
     * create a local Link
     * @param string $sTarget
     * @param string $sLabel (optional)
     * @return string
     */
    public function genLink($sTarget, $sLabel = '') {
        if (!$sLabel) {
            $sLabel = $sTarget;
        }
        return '<a href="#' . md5($sTarget) . '">' . $sLabel . '</a>';
    }

    /**
     * generate a datalist based input field
     * @param array $aList flat list
     * @return string
     */
    public function renderDatalist($aList) {
        $sReturn = '';
        $sId = "list" . md5(date("U"));
        foreach ($aList as $sValue) {
            $sReturn.='<option value="' . $sValue . '">';
        }
        $sReturn = '<input name="servers" list="' . $sId . '">'
                . '<datalist id="' . $sId . '">' . $sReturn . '</datalist>';
        return $sReturn;
    }

    /**
     * generate a dropdown menu; use $aEnv["links"]["name"] as
     * first parameter
     * @param array $aLinks
     * @param boolean $bDrawSelect
     * @return string
     */
    public function renderDropdown($aLinks, $bDrawSelect = true) {
        $sReturn = '';
        foreach ($aLinks as $aLink) {
            $sReturn.='<option ';
            $sCssClass = '';
            foreach (array(/* "class", */ "id") as $sAttribute) {
                if (array_key_exists($sAttribute, $aLink)) {
                    $sReturn.=$sAttribute . '="' . $aLink[$sAttribute] . '" ';
                }
            }
            if (array_key_exists("url", $aLink)) {
                $sReturn.='value="' . $aLink["url"] . '" ';
            }
            if (array_key_exists("active", $aLink) && $aLink["active"]) {
                $sReturn.='selected="selected" ';
                $sCssClass = 'active ';
            }
            if (array_key_exists("class", $aLink)) {
                $sCssClass.=$aLink["class"];
            }
            if ($sCssClass) {
                $sReturn.='class="' . $sCssClass . '" ';
            }

            $sReturn.='>';

            if (array_key_exists("label", $aLink)) {
                $sReturn.=$aLink["label"];
            }

            $sReturn.='</option>';

            if (array_key_exists("subitems", $aLink)) {
                $sReturn.=$this->renderDropdown($aLink["subitems"], false);
            }
        }
        if ($bDrawSelect) {
            $sReturn = '<select class="select" onchange="location.href=this.value;">' . $sReturn . '</select>';
        }
        return $sReturn;
    }

    /**
     * generate a nested menu with li elements; use $aEnv["links"]["name"] as
     * first parameter
     * @param array $aLinks
     * @param boolean $bDrawSelect
     * @return string
     */
    public function renderLI($aLinks) {
        $sReturn = '';
        foreach ($aLinks as $aLink) {
            $sReturn.='<li';
            if (array_key_exists("active", $aLink) && $aLink["active"])
                $sReturn.=' class="active"';
            $sReturn.='><a ';

            foreach (array("class", "id", "onclick", "target") as $sAttribute) {
                if (array_key_exists($sAttribute, $aLink)) {
                    $sReturn.=$sAttribute . '="' . $aLink[$sAttribute] . '" ';
                }
            }
            if (array_key_exists("url", $aLink)) {
                $sReturn.='href="' . $aLink["url"] . '" ';
            }
            $sReturn.='>';

            if (array_key_exists("label", $aLink)) {
                $sReturn.=$aLink["label"];
            }

            $sReturn.='</a>';

            if (array_key_exists("subitems", $aLink)) {
                $sReturn.=$this->renderLI($aLink["subitems"]);
            }
            $sReturn.='</li>';
        }
        return $sReturn;
    }

    /**
     * renderTable shows the array from function dataFilter
     * It additionally fills the global variable $sJsOnReady
     * 
     * @global type $aUserCfg
     * @global string $sJsOnReady
     * @staticvar int $iTableCounter to generate uniq id for the table
     * @param array $aTable  data from function dataFilter 
     * @param type $sDatatableOptions additional options for jquery plugin datatable 
     * @return string html code
     */
    function renderRequestTable($aTable, $sDatatableOptions = '') {
        global $aUserCfg;
        global $aEnv;
        global $sJsOnReady;
        global $aLangTxt;
        $sHtml = '';
        $sJs = '';
        static $iTableCounter = 0;
        $iTableCounter++;
        $aHeader = array();
        $sTableId = 'tableRendered' . preg_replace('#[^a-z0-9]#', "", $aEnv["active"]["view"]) . $iTableCounter;

        $aHasBar = array();
        if (array_key_exists("tdbars", $aUserCfg)) {
            foreach ($aUserCfg["tdbars"] as $sKey) {
                $aHasBar[$sKey] = true;
                if (array_key_exists($sKey, $aLangTxt)) {
                    $aHasBar[$aLangTxt[$sKey]] = true;
                }
            }
        }
        $aMax = $this->_getMaxima($aTable);

        // print_r($aLangTxt); die();
        foreach ($aTable as $row) {

            $sRow = '';
            $sHead = '';
            foreach ($row as $key => $value) {
                if (in_array($key, $aUserCfg["hideRows"])) {
                    continue;
                }
                if (!$sHtml) {
                    $sHead.='<th>' . $key . '</th>';
                    if (array_key_exists($key, $aHasBar) && $aMax[$key]) {
                        $sHead.='<th> </th>';
                    }
                    $aHeader[$key] = true;
                }
                $sRow.='<td>' . $value . '</td>';
            }
            if (!$sHtml) {
                $sHtml = '<thead><tr>' . $sHead . '</tr></thead><tbody>';
            }
            $sHtml.=$this->_getReqLine($row, $aHeader, $sTableId, $aMax);
        }


        // take default options for datatable (in user config) and insert 
        // parameter values of this function
        $sOptions = $aUserCfg['datatableOptions'] ? $aUserCfg['datatableOptions'] : '{}';

        if ($sDatatableOptions) {
            $sOptions = preg_replace("/\ }$/", ", " . $sDatatableOptions . " }", $aUserCfg['datatableOptions']);
        }
        if ($sHtml) {
            $sHtml = '<table id="' . $sTableId . '" class="datatable" >' . $sHtml . '</tbody></table><div style="clear: both;"><br></div>';
        }
        $sJsResetOnclick = '$(\\\'#' . $sTableId . '_filter>INPUT\\\').val(\\\'\\\'); $(\\\'#' . $sTableId . '\\\').dataTable().fnFilter(\\\'\\\');';
        $sHtmlReset = '<a class="btnclose" href="#" onclick="' . $sJsResetOnclick . '; return false; ">X</a>';
        $sJs = '$("#' . $sTableId . '").dataTable(' . $sOptions . ');';
        $sJs.= '$("#' . $sTableId . '_filter").append(\'' . $sHtmlReset . '\');';

        $sJsOnReady.=$sJs;
        return $sHtml;
    }

    /**
     * create a section with header, hint and tabledata
     * @global array $aSrvStatus             array with server status data
     * @global type $aLangTxt       array with translated texts
     * @param type $sKey            key for preset 
     * @return string               html code
     */
    public function renderTable($sKey = false) {
        global $aSrvStatus, $aLangTxt;

        if (!$sKey) {
            return false;
        }
        if (!in_array($sKey, $this->aValidTables)) {
            die("ERROR in  " . __CLASS__ . "->" . __FUNCTION__ . "(): unknown tile " . $sKey . "<br>Valid tables are: " . implode("|", $this->getValidTiles()));
        }
        if (!key_exists($sKey, $this->aFilterPresets)) {
            die("ERROR in  " . __CLASS__ . "->" . __FUNCTION__ . "(): aFilterPresets has no definition for " . $sKey . ".");
        }

        // get title and hint text from language file
        $sTitle = $aLangTxt['lblTable_' . $sKey] ? $aLangTxt['lblTable_' . $sKey] : $sKey;
        $sHint = $aLangTxt['lblTableHint_' . $sKey] ? $aLangTxt['lblTableHint_' . $sKey] : "";


        $sType = $this->aFilterPresets[$sKey]['sType'];
        if ($sType == 'requests' || $sType == 'status') {
            $this->aFilterPresets[$sKey]['aRows'] = $this->_getTableheads($aSrvStatus, $sType);
        }

        require_once 'serverstatus.class.php';
        $oServerStatus = new ServerStatus();
        $aTData = $oServerStatus->dataFilter($aSrvStatus, $this->aFilterPresets[$sKey]);
        if (!count($aTData)) {
            // $oLog->add('Table <em>'.$sKey.'</em> was not rendered. No data.', 'error');
            return false;
        }

        $sTableOptions = '';
        $sOptPaging = '"bPaginate": true, "bLengthChange": true, "aLengthMenu": [[10, 25, 50, 100, -1],[10, 25, 50, 100, "---"]]';
        // $sContent=count($aTData);        
        switch ($sKey) {
            case 'requests_all': break;
            case 'requests_running': $sTableOptions = $sOptPaging;
                break;
            case 'requests_mostrequested':
                $sTableOptions = '"aaSorting": [[0,"desc"]], ' . $sOptPaging;
                break;
            case 'requests_hostlist':
                $sTableOptions = '"aaSorting": [[0,"desc"]], ' . $sOptPaging;
                break;
            case 'requests_methods':
                $sTableOptions = '"aaSorting": [[0,"desc"]], ' . $sOptPaging;
                break;
            case 'requests_clients':
                $sTableOptions = '"aaSorting": [[0,"desc"]], ' . $sOptPaging;
                break;
            case 'requests_longest':
                $iReq = $this->_getNumberOfArraykey("Req", $aTData[0]);
                if (!$iReq)
                    $iReq = 0;
                $sTableOptions = 'aaSorting: [[' . $iReq . ',"desc"]],"bStateSave": false';
                break;
            default:
                break;
        }

        $sExport = '<ul><li>' . $aLangTxt["lblExportLinks"] . '</li>' . $this->renderLI($this->genExportLinks($sKey)) . '</ul>';
        return $this->themeTable($sTitle, $this->renderRequestTable($aTData, $sTableOptions), $sHint, $sExport);
    }

    /**
     * generate a menu with li elements - surrounded with ul class"tabs"
     * to get a tabbed list; use $aEnv["links"]["name"] as first parameter
     * @param array $aLinks
     * @return string
     */
    public function renderTabs($aLinks) {
        return '<ul class="tabs">' . $this->renderLI($aLinks) . '</ul>';
    }

    /**
     * render a tile
     * @global array $aSrvStatus             array with server status data
     * @global array $aLangTxt       array with translated texts
     * @param string $sTilename       key for preset
     * @return string               html code
     */
    public function renderTile($sTilename = false) {
        global $aSrvStatus, $aSrvMeta, $aLangTxt;

        if (!$sTilename) {
            return false;
        }
        if (!in_array($sTilename, $this->aValidTiles)) {
            die("ERROR in  " . __CLASS__ . "->" . __FUNCTION__ . "(): unknown tile " . $sTilename . "<br>Valid tiles are: " . implode("|", $this->getValidTiles()));
        }
        if (!key_exists($sTilename, $this->aFilterPresets)) {
            die("ERROR in  " . __CLASS__ . "->" . __FUNCTION__ . "(): aFilterPresets has no definition for " . $sTilename . ".");
        }

        $sTitle = $aLangTxt['lblTile_' . $sTilename] ? $aLangTxt['lblTile_' . $sTilename] : $sTilename;
        $sHint = $aLangTxt['lblTileHint_' . $sTilename] ? $aLangTxt['lblTileHint_' . $sTilename] : $sTilename;
        $sContent = '';

        $sType = $this->aFilterPresets[$sTilename]['sType'];
        $this->aFilterPresets[$sTilename]['aRows'] = $this->_getTableheads($aSrvStatus, $sType);

        if ($this->aFilterPresets[$sTilename]["sType"] == "meta") {
            $aTData = $aSrvMeta;
        } else {
            require_once 'serverstatus.class.php';
            $oServerStatus = new ServerStatus();
            $aTData = $oServerStatus->dataFilter($aSrvStatus, $this->aFilterPresets[$sTilename]);
        }
        $sContent = '<span class="counter">' . count($aTData) . '</span>';
        if (count($aTData)) {
            switch ($sTilename) {
                // case 'requests_all': break;
                // case 'requests_running': break;
                case 'requests_mostrequested':
                    if (array_key_exists($aLangTxt['thCount'], $aTData[0])) {
                        $sReq = $aTData[0]['Request'];
                    }
                    if (!$sReq) {
                        $sReq = '?';
                    }
                    $sContent = '<span class="counter">' . $aTData[0][$aLangTxt['thCount']] . '</span><br>' . $sReq . '';
                    break;
                case 'requests_clients':
                    if (array_key_exists($aLangTxt['thCount'], $aTData[0])) {
                        $sReq = $aTData[0]['Client'];
                    }
                    if (!$sReq) {
                        $sReq = '?';
                    }
                    $sContent = '<span class="counter">' . $aTData[0][$aLangTxt['thCount']] . '</span><br>' . $sReq . '';
                    break;
                case 'requests_longest':
                    if (round($aTData[0]['Req'] / 1000) > 0) {
                        $sReq = $aTData[0]['Request'];
                        if (!$sReq) {
                            $sReq = '?';
                        }
                        $sContent = '<span class="counter">' . $aTData[0]['Req'] / 1000 . ' s</span><br>' . $sReq;
                    } else {
                        $sContent = '<span class="counter">-</span><br>';
                    }
                    break;
                case 'server_count':
                    $sContent = '<span class="counter">' . $aTData["servers"] . '</span><br>';
                    break;
                case 'server_responsetime':
                    $sContent = '<span class="counter">' . sprintf('%01.3f', $aTData["responsetime"]) . ' s</span><br>';
                    break;

                default:
                    break;
            }
        }
        if ($sContent) {
            return '<div '
                    . 'title="' . $sHint . '"'
                    . 'class="tile ' . $sTilename . '"'
                    . '><span class="title">' . $sTitle . '</span>:<br><span class="content">' . $sContent . '</span></div>';
        }
        return false;
    }

    private function _getTypes($aSrvStatus) {
        global $aLangTxt;
        $aReturn = array();
    }

    /**
     * get Metadata for workers (total, active, wait) as an array
     * @global array $aLangTxt     language dependent texts
     * @param array  $aSrvStatus   server status array
     * @param bool   $bGenerateBar flag: get html code for a bar for active workers
     * @return string
     */
    public function _getWorkersData($aSrvStatus, $bGenerateBar = false) {
        global $aLangTxt;
        $aReturn = array();
        $iMaxWith = 600;

        foreach ($aSrvStatus as $sHost => $aData) {

            $iTotal = 0;
            $iActive = 0;
            $iWait = 0;

            if (array_key_exists("requests", $aData)) {
                foreach ($aData['requests'] as $aRequest) {

                    // check status of request
                    if ($aRequest['M'] != "." && $aRequest['M'] != "_")
                        $iActive++;
                    if ($aRequest['M'] == "_")
                        $iWait++;
                    $iTotal++;
                }
            }
            $aTmp = array(
                $aLangTxt['thWorkerServer'] => $sHost,
                $aLangTxt['thWorkerTotal'] => $iTotal,
                $aLangTxt['thWorkerActive'] => $iActive,
                $aLangTxt['thWorkerWait'] => $iWait,
            );

            if ($bGenerateBar) {
                $iBarFactor = 1;

                if ($iTotal > $iMaxWith) {
                    $iBarFactor = $iMaxWith / $iTotal;
                }
                $sBar = "<div class=\"barTotal\" style=\"width: " . ($iTotal * $iBarFactor) . "px; \" title=\"" . ($iTotal - $iActive - $iWait) . " " . $aLangTxt['bartitleFreeWorkers'] . "\">
                            <div class=\"barBusyWorker\" style=\"width: " . ($iActive * $iBarFactor) . "px; \" title=\"$iActive " . $aLangTxt['bartitleBusyWorkers'] . "\"> </div>
                            <div class=\"barIdleWorker\" style=\"width: " . ($iWait * $iBarFactor) . "px; \" title=\"$iWait " . $aLangTxt['bartitleIdleWorkers'] . "\"> </div>
                        </div>";
                $aTmp[$aLangTxt['thWorkerBar']] = $sBar;
            }
            $aReturn[] = $aTmp;
        }
        return $aReturn;
    }

    /**
     * render table with worker status: total/ active/ waiting workers
     * @global type $aLangTxt language dependend texts
     * @param type $aSrvStatus data array of apache status
     * @return string html code
     */
    public function renderWorkersTable($aSrvStatus) {
        global $aLangTxt;

        if (!count($aSrvStatus)) {
            // $oLog->add('Workers table was not rendered. No data.', 'error');
            return false;
        }

        $aTData = $this->_getWorkersData($aSrvStatus, true);
        $sExport = '<ul><li>' . $aLangTxt["lblExportLinks"] . '</li>' . $this->renderLI($this->genExportLinks("workers_table")) . '</ul>';
        return $this->themeTable($aLangTxt["lblTable_status_workers"], $this->renderRequestTable($aTData, ""), $aLangTxt["lblTableHint_status_workers"], $sExport);
    }

    /**
     * render output section with title, hint and data table
     * @param string $sTitle    title for h3
     * @param string $sTable    html content (the table)
     * @param string $sHint     hint text (optional)
     * @param string $sExport   html content (export Links)
     * @return string 
     */
    public function themeTable($sTitle, $sTable, $sHint = false, $sExport = false) {

        $sContent = '<h3>' . $sTitle . '</h3><div class="h3">';
        if ($sHint) {
            $sContent.='<div class="hintbox">' . $sHint . '</div>';
        }
        $sContent.='<div class="content">';
        $sContent.= $sTable;
        if ($sExport)
            $sContent.='<div class="export">' . $sExport . '</div>';
        $sContent.= '</div>';
        $sContent.='</div>';
        return $sContent;
    }

}

?>