$numrows = GetRowCount($strSQL); } else { $strSQL = gSQLWhere($strWhereClause, $strHavingClause); $strSQL .= " " . trim($strOrderBy); $rowcount = false; if ($eventObj->exists("ListGetRowCount")) { $masterKeysReq = array(); for ($i = 0; $i < count($pageObject->detailKeysByM); $i++) { $masterKeysReq[] = $_SESSION[$strTableName . "_masterkey" . ($i + 1)]; } $rowcount = $eventObj->ListGetRowCount($pageObject->searchClauseObj, $_SESSION[$strTableName . "_mastertable"], $masterKeysReq, $selected_recs); } if ($rowcount !== false) { $numrows = $rowcount; } else { $numrows = gSQLRowCount($strWhereClause, $strHavingClause); } } LogInfo($strSQL); // Pagination: $nPageSize = 0; if (@$_REQUEST["records"] == "page" && $numrows) { $mypage = (int) @$_SESSION[$strTableName . "_pagenumber"]; $nPageSize = (int) @$_SESSION[$strTableName . "_pagesize"]; if (!$nPageSize) { $nPageSize = GetTableData($strTableName, ".pageSize", 0); } if ($nPageSize < 0) { $nPageSize = 0; } if ($nPageSize > 0) {
} } else { $mastertable = $_SESSION[$strTableName . "_mastertable"]; } //$strSQL = $gstrSQL; if ($mastertable == "dbo.Module") { $where = ""; $where .= GetFullFieldName("Module ID") . "=" . make_db_value("Module ID", $_SESSION[$strTableName . "_masterkey1"]); } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strSQL = gSQLWhere($where); $strSQL .= " " . $gstrOrderBy; $rowcount = gSQLRowCount($where); $xt->assign("row_count", $rowcount); if ($rowcount) { $xt->assign("details_data", true); $rs = db_query($strSQL, $conn); $display_count = 10; if ($mode == "inline") { $display_count *= 2; } if ($rowcount > $display_count + 2) { $xt->assign("display_first", true); $xt->assign("display_count", $display_count); } else { $display_count = $rowcount; } $rowinfo = array();