PHP GetTableData函数代码示例

 /**
  * Static function for create list page
  * Read params from setting 
  * Create object of class in accordance with mode displaying page 
  */
 function &createListPage($table, $options)
 {
     global $bSubqueriesSupported, $strTableName, $conn, $locale_info, $isGroupSecurity;
     $gQuery = GetTableData($table, ".sqlquery", null);
     $params = array();
     $params = $options;
     $params['origTName'] = GetTableData($table, ".OriginalTable", '');
     $params['sessionPrefix'] = $strTableName;
     $params['tName'] = $table;
     $params['conn'] =& $conn;
     $params['gPageSize'] = GetTableData($table, ".pageSize", 0);
     $params['gOrderIndexes'] = GetTableData($table, ".orderindexes", array());
     $params['gstrOrderBy'] = GetTableData($table, ".strOrderBy", '');
     $params['gsqlHead'] = GetTableData($table, ".sqlHead", '');
     $params['gsqlFrom'] = GetTableData($table, ".sqlFrom", '');
     $params['gsqlWhereExpr'] = GetTableData($table, ".sqlWhereExpr", '');
     $params['gsqlGroupBy'] = $gQuery->GroupByToSql();
     $oHaving = $gQuery->Having();
     $params['gsqlHaving'] = $oHaving->toSql($gQuery);
     $params['locale_info'] =& $locale_info;
     $params["subQueriesSupp"] = $bSubqueriesSupported;
     $params['nSecOptions'] = GetTableData($table, ".nSecOptions", 0);
     $params['nLoginMethod'] = GetGlobalData("nLoginMethod", 0);
     $params['recsPerRowList'] = GetTableData($table, ".recsPerRowList", 0);
     $params['tableGroupBy'] = GetTableData($table, ".tableGroupBy", '');
     $params['dbType'] = GetGlobalData("dbType", 0);
     $params['mainTableOwnerID'] = GetTableData($table, ".mainTableOwnerID", '');
     $params['moveNext'] = GetTableData($table, ".moveNext", 0);
     $params['exportTo'] = GetTableData($table, ".exportTo", false);
     $params['printFriendly'] = GetTableData($table, ".printFriendly", false);
     $params['deleteRecs'] = GetTableData($table, ".delete", false);
     $params['rowHighlite'] = GetTableData($table, ".rowHighlite", false);
     $params["delFile"] = GetGlobalData("delFile", false);
     $params["isGroupSecurity"] = $isGroupSecurity;
     $params['arrKeyFields'] = GetTableData($table, ".arrKeyFields", array());
     $params["useIbox"] = GetTableData($table, ".useIbox", false);
     $params["isUseInlineAdd"] = GetTableData($table, ".isUseInlineAdd", false);
     $params["isUseInlineEdit"] = GetTableData($table, ".isUseInlineEdit", false);
     $params["isUseInlineJs"] = $params["isUseInlineAdd"] || $params["isUseInlineEdit"];
     $params["globSearchFields"] = GetTableData($table, ".globSearchFields", array());
     $params["panelSearchFields"] = GetTableData($table, ".panelSearchFields", array());
     $params['isVerLayout'] = GetTableData($table, ".isVerLayout", false);
     $params['isDisplayLoading'] = GetTableData($table, ".isDisplayLoading", false);
     $params['createLoginPage'] = GetGlobalData("createLoginPage", false);
     $params['subQueriesSupAccess'] = GetTableData($table, ".subQueriesSupAccess", false);
     $params['noRecordsFirstPage'] = GetTableData($table, ".noRecordsFirstPage", false);
     $params['totalsFields'] = GetTableData($table, ".totalsFields", array());
     $params['listIcons'] = GetTableData($table, ".listIcons", false);
     $params['edit'] = GetTableData($table, ".edit", false);
     $params['inlineEdit'] = GetTableData($table, ".inlineEdit", false);
     $params['iCopy'] = GetTableData($table, ".copy", false);
     $params['iView'] = GetTableData($table, ".view", false);
     $params['listAjax'] = GetTableData($table, ".listAjax", false);
     $params['arrRecsPerPage'] = GetTableData($table, ".arrRecsPerPage", array());
     $params['audit'] = GetAuditObject($table);
     $params['listFields'] = array();
     $allfields = GetFieldsList($table);
     foreach ($allfields as $f) {
         if (!AppearOnListPage($f, $table)) {
             continue;
         }
         $params['listFields'][] = array("fName" => $f, "goodFieldName" => GoodFieldName($f), "valueFieldName" => GoodFieldName($f) . "_value", "viewFormat" => GetFieldData($table, $f, "ViewFormat", ""), "editFormat" => GetFieldData($table, $f, "EditFormat", ""));
     }
     // choose class by mode
     if ($params["mode"] == LIST_SIMPLE) {
         $pageObject = new ListPage_Simple($params);
     } else {
         if ($params["mode"] == LIST_AJAX) {
             $pageObject = new ListPage_Ajax($params);
         } else {
             if ($params["mode"] == LIST_LOOKUP) {
                 $pageObject = new ListPage_Lookup($params);
             } else {
                 if ($params["mode"] == LIST_DETAILS) {
                     $pageObject = new ListPage_DPInline($params);
                 } else {
                     if ($params["mode"] == RIGHTS_PAGE) {
                         $pageObject = new RightsPage($params);
                     } else {
                         if ($params["mode"] == MEMBERS_PAGE) {
                             $pageObject = new MembersPage($params);
                         }
                     }
                 }
             }
         }
     }
     return $pageObject;
 }

 function searchAssign()
 {
     parent::searchAssign();
     $searchGlobalParams = $this->searchClauseObj->getSearchGlobalParams();
     $searchPanelAttrs = $this->searchClauseObj->getSrchPanelAttrs();
     // show hide window
     $this->pageObj->xt->assign("showHideSearchWin_attrs", 'align="absmiddle" title="Floating window" alt="Floating window"');
     $searchOpt_mess = $searchPanelAttrs['srchOptShowStatus'] ? mlang_message("SEARCH_HIDE_OPTIONS") : mlang_message("SEARCH_SHOW_OPTIONS");
     $this->pageObj->xt->assign("showHideSearchPanel_attrs", 'align="absmiddle" title="' . $searchOpt_mess . '" alt="' . $searchOpt_mess . '"');
     $searchforAttrs = "";
     if ($this->isUseAjaxSuggest) {
         $searchforAttrs .= "autocomplete=off ";
     }
     if (!$this->searchClauseObj->isUsedSrch()) {
         $searchforAttrs .= 'class="ctlSearchFor"';
     }
     $searchforAttrs .= " name=\"ctlSearchFor" . $this->id . "\" id=\"ctlSearchFor" . $this->id . "\"";
     $valSrchFor = $this->searchClauseObj->isUsedSrch() ? $searchGlobalParams["simpleSrch"] : mlang_message("SEARCH_TIP");
     $searchforAttrs .= " value=\"" . htmlspecialchars($valSrchFor) . "\"";
     $this->pageObj->xt->assignbyref("searchfor_attrs", $searchforAttrs);
     $this->pageObj->xt->assign('searchPanelTopButtons', $this->isDisplaySearchPanel);
     if (GetTableData($this->tName, ".showSimpleSearchOptions", false)) {
         $simpleSearchTypeCombo = '<select id="simpleSrchTypeCombo' . $this->id . '" name="simpleSrchTypeCombo' . $this->id . '" size="1">';
         $simpleSearchTypeCombo .= $this->searchControlBuilder->getSimpleSearchTypeCombo($searchGlobalParams["simpleSrchTypeComboOpt"], $searchGlobalParams["simpleSrchTypeComboNot"]);
         $simpleSearchTypeCombo .= "</select>";
         $this->pageObj->xt->assign('simpleSearchTypeCombo', $simpleSearchTypeCombo);
         $simpleSearchFieldCombo = '<select id="simpleSrchFieldsCombo' . $this->id . '" name="simpleSrchFieldsCombo' . $this->id . '" size="1">';
         $simpleSearchFieldCombo .= $this->searchControlBuilder->simpleSearchFieldCombo($this->allSearchFields, $searchGlobalParams["simpleSrchFieldsComboOpt"]);
         $simpleSearchFieldCombo .= "</select>";
         $this->pageObj->xt->assign('simpleSearchFieldCombo', $simpleSearchFieldCombo);
     }
 }

 function SearchClause(&$params)
 {
     global $strTableName;
     $this->tName = $params['tName'] ? $params['tName'] : $strTableName;
     $this->sessionPrefix = $params['sessionPrefix'] ? $params['sessionPrefix'] : $this->tName;
     $this->searchFieldsArr = $params['searchFieldsArr'];
     $this->panelSearchFields = $params['panelSearchFields'] ? $params['panelSearchFields'] : GetTableData($this->tName, ".panelSearchFields", array());
     $this->googleLikeFields = $params['googleLikeFields'] ? $params['googleLikeFields'] : GetTableData($this->tName, ".googleLikeFields", array());
 }

 function simpleSearchFieldCombo($fNamesArr, $selOpt)
 {
     $options = "";
     if (sizeof(GetTableData($this->tName, ".googleLikeFields", array())) != 0) {
         $options = '<option value="" >' . mlang_message("ANY_FIELD") . '</option>';
     }
     foreach ($fNamesArr as $fName) {
         $fLabel = GetFieldLabel(GoodFieldName($this->tName), GoodFieldName($fName));
         $options .= '<option value="' . $fName . '" ' . ($selOpt == $fName ? 'selected' : '') . '>' . $fLabel . '</option>';
     }
     return $options;
 }

function GetTableDataBySidAndName()
{
    $sid = $_POST["sid"];
    $table_name = $_POST["table_name"];
    $perPage = $_POST["perPage"];
    $pageNo = $_POST["pageNo"];
    //$logger->info("In GetTableDataBySidAndName for sid = $sid, tableName = $table_name, perPage = $perPage, pageNo = $pageNo");
    if (is_string($sid)) {
        $sid = json_decode($sid);
    }
    echo json_encode(GetTableData($sid, $table_name, $perPage, $pageNo));
}

 public function testGetTableDataBySidAndTableName()
 {
     $sid = 2122;
     $table_name = 's6.xlsx';
     $perPage = 10;
     $pageNo = 1;
     $expected = array();
     $expected['data'][] = array('rownum' => "1", "F" => "F1", "G" => "G1");
     $expected['data'][] = array('rownum' => "2", "F" => "F2", "G" => "G2");
     $expected['data'][] = array('rownum' => "3", "F" => "F3", "G" => "G3");
     $expected['Control'] = array('perPage' => $perPage, 'totalPage' => 1, 'pageNo' => $pageNo, 'cols' => "rownum,F,G");
     $result = GetTableData($sid, $table_name, $perPage, $pageNo);
     $this->assertEquals(json_encode($result), json_encode($expected));
 }

    if ($moduleManager->VersionHandler()->CompareVersionsNewer($infos['CurrentVersion'], $infos['Version'])) {
        $infos['AvailableVersion'] = $infos['Version'];
        $versionAttribute = 'color:red;';
        $updateButton = true;
    }
    if ($infos['State'] != 'OK') {
        $stateAttribute = 'color:red;';
    }
    $html .= '  <tr>';
    $html .= GetTableData(null, null, $module, '', 'Module', $module);
    $html .= GetTableData($infos, 'CurrentVersion');
    $html .= GetTableData($infos, 'AvailableVersion', '', $versionAttribute, 'Updates');
    $html .= GetTableData($infos, 'State', '', $stateAttribute);
    //$html .=  GetTableData($infos, 'LastRepository');
    //$html .=  GetTableData($infos, 'Repository');
    $html .= GetTableData($infos, 'Description');
    $html .= '</tr>' . PHP_EOL;
}
echo $html;
?>
</table>


<?php 
if (!$processing) {
    if (count($modules) > 0) {
        echo '<input type="button" name="Text" value="Update aller Module" onclick="trigger_button(\'UpdateAll\', \'\', \'\')">';
    }
    echo '<input type="button" name="Text" value="Nach neuen Update\'s Suchen" onclick="trigger_button(\'SearchUpdates\', \'\', \'\')">';
} else {
    echo 'processing ...';

@ini_set("display_startup_errors", "1");
include "include/dbcommon.php";
header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
$table = postvalue("table");
$strTableName = GetTableByShort($table);
if (!checkTableName($table)) {
    exit(0);
}
include "include/" . $table . "_variables.php";
$field = postvalue('searchField');
$value = postvalue('searchFor');
$lookupValue = postvalue('lookupValue');
$LookupSQL = "";
$response = array();
$output = "";
$strDataSourceTable = GetTableData($strTableName, '.OriginalTable', '');
$strLoginTable = "dbo.System Users";
if ($strDataSourceTable != $strLoginTable) {
    if (!@$_SESSION["UserID"]) {
        return;
    }
    if (!CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Edit") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Add") && !CheckSecurity(@$_SESSION["_" . $strTableName . "_OwnerID"], "Search")) {
        return;
    }
} else {
    $checkResult = true;
    if ($field == "UserID") {
        $checkResult = false;
    }
    if ($field == "Password") {
        $checkResult = false;

 * Далее если пользователь желает уточнить данные то в данный скрипт передаются запрашиваемые данные.
 */
require_once '../conf/login.php';
$mssqlConn = sqlsrv_connect($serverName, $connectionInfo);
if ($mssqlConn === false) {
    die(print_r(sqlsrv_errors(), true));
}
//Получаем полную информацию для каждой вкладки.
$tab = $_POST['tab'];
$predicate = $_POST['queryId'];
//Функиции получения данных и отрисовки таблицы
//GetInfo($mssqlConn,$tab);
//Формируем заголовоки столбцов таблицы и строки для поиска
$thead = MakeTableHead(GetTableHeaders($mssqlConn, $tab), $tab);
//Содержимое таблицы
$tbody = GetTableData($mssqlConn, $tab, $predicate);
//Отрисовка таблицы
DrawTable($thead, $tbody);
function GetTableHeaders($conn, $table)
{
    $queryFields = "Select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME ='" . $table . "'";
    $resultFields = sqlsrv_query($conn, $queryFields) or die(print_r(sqlsrv_errors(), true));
    return $resultFields;
}
function MakeTableHead($th, $tid)
{
    //Заголовоки столбцов
    $headersCount = 0;
    $tableHead = '<table class="table" border="1" id="' . $tid . 'Table"> <thead><tr>';
    while ($row = sqlsrv_fetch_array($th, SQLSRV_FETCH_NUMERIC)) {
        $tableHead .= '<td>' . $row[0] . '</td>';

 /**
  * Use for count details recs number, if subQueryes not supported, or keys have different types
  *
  * @param integer $i
  * @param array $detailid
  */
 function countDetailsRecsNoSubQ($dInd, &$detailid)
 {
     global $tables_data;
     global $masterTablesData;
     global $detailsTablesData;
     $dDataSourceTable = $this->allDetailsTablesArr[$dInd]['dDataSourceTable'];
     $gQuery = GetTableData($dDataSourceTable, '.sqlquery', null);
     $dObjHaving = $gQuery->Having();
     $dSqlHaving = $dObjHaving->toSql($gQuery);
     $dSqlGroupBy = $gQuery->GroupByToSql();
     $dSqlHead = $this->allDetailsTablesArr[$dInd]['sqlHead'];
     $dSqlFrom = $this->allDetailsTablesArr[$dInd]['sqlFrom'];
     $dSqlWhere = $this->allDetailsTablesArr[$dInd]['sqlWhere'];
     //$sqlTail = $detailTableInfo['sqlTail'];
     $detailKeys = GetDetailKeysByMasterTable($this->tName, $dDataSourceTable);
     $securityClause = SecuritySQL("Search", $dDataSourceTable);
     // add where
     if (strlen($securityClause)) {
         $dSqlWhere = whereAdd($dSqlWhere, $securityClause);
     }
     $masterwhere = "";
     foreach ($this->masterKeysByD[$dInd] as $idx => $val) {
         if ($masterwhere) {
             $masterwhere .= " and ";
         }
         $masterwhere .= GetFullFieldName($detailKeys[$idx], $dDataSourceTable) . "=" . make_db_value($detailKeys[$idx], $detailid[$idx]);
     }
     return gSQLRowCount_int($dSqlHead, $dSqlFrom, $dSqlWhere, $dSqlGroupBy, $dSqlHaving, $masterwhere, "");
 }

 function buildSearchPanel($xtVarName)
 {
     $this->xt->enable_section("searchPanel");
     $params = array();
     $params['pageObj'] =& $this;
     $params['globSearchFields'] = $this->globSearchFields;
     $params['panelSearchFields'] = $this->panelSearchFields;
     $panelSearchFields = array();
     $allSearchFields = GetTableData($this->tName, '.allSearchFields', array());
     for ($i = 0; $i < count($allSearchFields); $i++) {
         if (!$this->matchWithDetailKeys($allSearchFields[$i])) {
             $panelSearchFields[] = $allSearchFields[$i];
         }
     }
     $params['allSearchFields'] = $panelSearchFields;
     $this->searchPanel = new SearchPanelSimple($params);
     $this->searchPanel->buildSearchPanel($xtVarName);
 }

    $xt->assign("mastertable_block", true);
}
$strSQL = $_SESSION[$strTableName . "_sql"];
$isPdfView = false;
if (GetTableData($strTableName, ".isUsebuttonHandlers", false) || $isPdfView) {
    $pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/loadfirst.js\"></script>\r\n";
    $pageObject->body["begin"] .= "<script type=\"text/javascript\" src=\"include/lang/" . getLangFileName(mlang_getcurrentlang()) . ".js\"></script>";
    $pageObject->fillSetCntrlMaps();
    $pageObject->body['end'] .= '<script>';
    $pageObject->body['end'] .= "window.controlsMap = " . my_json_encode($pageObject->controlsHTMLMap) . ";";
    $pageObject->body['end'] .= "window.settings = " . my_json_encode($pageObject->jsSettings) . ";";
    $pageObject->body['end'] .= '</script>';
    $pageObject->body["end"] .= "<script language=\"JavaScript\" src=\"include/runnerJS/RunnerAll.js\"></script>\r\n";
    $pageObject->addCommonJs();
}
if (GetTableData($strTableName, ".isUsebuttonHandlers", false) || $isPdfView) {
    $pageObject->body["end"] .= "<script>" . $pageObject->PrepareJS() . "</script>";
}
$xt->assignbyref("body", $pageObject->body);
$xt->assign("grid_block", true);
$xt->assign("UserID_fieldheadercolumn", true);
$xt->assign("UserID_fieldheader", true);
$xt->assign("UserID_fieldcolumn", true);
$xt->assign("UserID_fieldfootercolumn", true);
$xt->assign("Password_fieldheadercolumn", true);
$xt->assign("Password_fieldheader", true);
$xt->assign("Password_fieldcolumn", true);
$xt->assign("Password_fieldfootercolumn", true);
$xt->assign("User_Name_fieldheadercolumn", true);
$xt->assign("User_Name_fieldheader", true);
$xt->assign("User_Name_fieldcolumn", true);

$knownModules = $moduleManager->VersionHandler()->GetKnownModules();
$installedModules = $moduleManager->VersionHandler()->GetInstalledModules();
$html = '';
foreach ($knownModules as $module => $data) {
    $infos = $moduleManager->GetModuleInfos($module);
    $html .= '  <tr>';
    $html .= GetTableData($module, '', 'Module', $module);
    $html .= GetTableData($infos['Version']);
    if (array_key_exists($module, $installedModules)) {
        $html .= '<td></td>';
    } elseif ($processing) {
        $html .= '<td>processing ...</td>';
    } else {
        $html .= '<td><input type="button" name="Text" value="Modul Laden" onclick="trigger_button(\'Load\', \'' . $module . '\', \'\')"></td>';
    }
    $html .= GetTableData($infos['Description']);
    $html .= '</tr>' . PHP_EOL;
}
echo $html;
?>
</table>

<?php 
function GetTableData($value = '', $displayAttributes = '', $action = '', $module = '', $info = '')
{
    $text = $value;
    if ($text == '') {
        $text = '-';
    }
    $text = htmlentities($text);
    if ($action != '') {

$modules = $moduleManager->VersionHandler()->GetKnownUpdates();
$html = '';
foreach ($modules as $idx => $module) {
    $moduleManager = new IPSModuleManager($module);
    $infos = $moduleManager->GetModuleInfos();
    $changes = $moduleManager->VersionHandler()->GetChangeList($module);
    $text = '<table><tr><td><div style="text-align:left; color:grey; padding-left:10px; padding-right:10px;">Aktuelles Repository</div></td>' . '<td><div style="text-align:left; color:grey; padding-left:10px; padding-right:10px;">' . $infos['LastRepository'] . '</div></td></tr>';
    $text .= '<tr><td><div style="text-align:left; color:grey; padding-left:10px; padding-right:10px;">Neues Repository</div></td>' . '<td><div style="text-align:left; color:grey; padding-left:10px; padding-right:10px;">' . $infos['Repository'] . '</div></td></tr>';
    foreach ($changes as $version => $change) {
        $text .= '<tr><td><div style="text-align:left; color:white; padding-left:10px; padding-right:10px;">Version ' . $version . '</div></td>' . '<td><div style="text-align:left; color:white; padding-left:10px; padding-right:10px;">' . htmlentities($change, ENT_COMPAT, 'ISO-8859-1') . '</div></td></tr>';
    }
    $text .= '</table>';
    $html .= '  <tr>';
    $html .= GetTableData($module, '', 'Module', $module);
    $html .= GetTableData($infos['CurrentVersion']);
    $html .= GetTableData($infos['Version']);
    if (!$processing) {
        $html .= '<td><input type="button" name="Text" value="Update" onclick="trigger_button(\'Update\', \'' . $module . '\', \'\')"></td>';
    } else {
        $html .= '<td>processing ...</td>';
    }
    $html .= '<td><div style="text-align:left; overflow:hidden; padding-left:10px; padding-right:10px;">' . $text . '</div></td>';
    $html .= '</tr>' . PHP_EOL;
}
echo $html;
?>
</table>


<?php 
if (!$processing) {

if ($dump['num_tables'] > 0 && $action != 'backupnow') {
    $info_text = TEXT_INFO_DO_BACKUP;
    @xtc_set_time_limit(0);
    if ($dump['nr'] < $dump['num_tables']) {
        $nr = $dump['nr'];
        $dump['aufruf']++;
        $table_ok = 'Tabellen gesichert: ' . ($nr + 1) . '<br><br>Zuletzt bearbeitet: ' . $dump['tables'][$nr] . '<br><br>Seitenaufrufe: ' . $dump['aufruf'];
        //Neue Tabelle
        if ($dump['table_offset'] == 0) {
            $dump['table_records'] = GetTableInfo($dump['tables'][$nr]);
            $dump['anzahl_zeilen'] = ANZAHL_ZEILEN_BKUP;
            $dump['table_offset'] = 1;
            $dump['zeilen_offset'] = 0;
        } else {
            //Daten aus  Tabelle lesen
            GetTableData($dump['tables'][$nr]);
        }
        $_SESSION['dump'] = $dump;
        $selbstaufruf = '<script language="javascript" type="text/javascript">setTimeout("document.dump.submit()", 10);</script></div>';
        //Verhindert Endlosschleife - Script wir nach MAX_RELOADS beendet
        if ($dump['aufruf'] > MAX_RELOADS) {
            $selbstaufruf = '';
        }
    } else {
        //Fertig
        $info_wait = '';
        $info_text = TEXT_INFO_DO_BACKUP_OK;
        $table_ok = 'Tabellen gesichert: ' . $dump['nr'] . '<br><br>Seitenaufrufe: ' . $dump['aufruf'];
        $button_back = '<a href="backup.php" class="btn btn-default">' . BUTTON_BACK . '</a>';
        $selbstaufruf = '';
        unset($_SESSION['dump']);