If your browser displays a 'Warning: Page has Expired' message when you attempt to return to these search results, please click your browser's 'Refresh' button
";
return renderHeading("Standard Search") . getSearchResults($sFolderIDs, $sSQLSearchString, $iStartIndex, $bSearchByDocument) . $sRefreshMessage . getSearchVariablesHtml($sSearchText, $sBrowseType, $iFolderID, $iDocumentID, $sCategoryName, $iDocType);
}
function getSearchResults($sFolderIDs, $sKeywords, $iStartIndex) {
global $default;
$sQuery = "SELECT DISTINCT '" . "$default->graphicsUrl/widgets/dfolder.gif" . "' AS folder_image_url, F.id AS folder_id, D.id AS document_id, D.name AS document_name, ROUND(MATCH(DT.document_text) AGAINST ('" . $sKeywords . "'),3) AS score " .
"FROM search_document_user_link AS SDUL INNER JOIN document_text AS DT ON SDUL.document_id = DT.document_id " .
"INNER JOIN documents AS D ON D.id = SDUL.document_id " .
"INNER JOIN status_lookup AS SL ON D.status_id = SL.id " .
"INNER JOIN folders AS F on F.ID = D.folder_id " .
"WHERE MATCH(DT.document_text) AGAINST ('" . $sKeywords . "') " .
"AND SDUL.user_id = " . $_SESSION["userID"] . " " .
"AND SL.name='Live' " .
"AND F.id IN ($sFolderIDs) " .
"ORDER BY score DESC";
$aColumns = array("folder_image_url", "document_name","score");
$aColumnTypes = array(4,3,3);
$aColumnHeaders = array("Folder","Document","Score");
$aLinkURLs = array("$default->rootUrl/control.php?action=browse","$default->rootUrl/control.php?action=viewDocument");
$aDBQueryStringColumns = array("document_id","folder_id","score");
$aQueryStringVariableNames = array("fDocumentID", "fFolderID");
$oPatternBrowse = & new PatternBrowseableSearchResults($sQuery, 10, $aColumns, $aColumnTypes, $aColumnHeaders, $aLinkURLs, $aDBQueryStringColumns, $aQueryStringVariableNames);
$oPatternBrowse->setStartIndex($iStartIndex);
return $oPatternBrowse->render();
}
function getSearchVariablesHtml($sSearchText, $sBrowseType, $iFolderID, $iDocumentID, $sCategoryName, $iDocType) {
$sToRender = "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
return $sToRender;
}
?>