siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sColor = $default->siteMap->getSectionColour($sSectionName, "th"); $sToRender .= "Standard Search\n"; $sToRender .= "\n"; $sToRender .= "\n"; return $sToRender; } function getPage($sSearchText, $sBrowseType, $iFolderID, $iDocumentID, $sCategoryName, $iDocType, $sFolderIDs, $iStartIndex, $sSQLSearchString, $bSearchByDocument = false) { $sRefreshMessage = "
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() . "
" . getSearchResults($sFolderIDs, $sSQLSearchString, $iStartIndex, $bSearchByDocument) . $sRefreshMessage . getSearchVariablesHtml($sSearchText, $sBrowseType, $iFolderID, $iDocumentID, $sCategoryName, $iDocType); } function getSearchResults($sIDs,$sSQLSearchString, $iStartIndex, $bSearchByDocument = false) { global $default; $sQuery = "SELECT DISTINCT '" . "$default->graphicsUrl/widgets/dfolder.gif" . "' AS folder_image_url, F.id folder_id, D.id document_id, D.name AS document_name " . "FROM $default->owl_documents_table AS D INNER JOIN $default->owl_folders_table AS F ON D.folder_id = F.id " . "INNER JOIN $default->owl_document_words_table AS DWL ON DWL.document_id = D.id " . "INNER JOIN $default->owl_words_lookup_table AS WL ON WL.id = DWL.word_id "; if (strlen($sIDs) > 0) { if ($bSearchByDocument) { $sQuery .= "WHERE D.id IN ($sIDs) "; } else { $sQuery .= "WHERE F.id IN ($sIDs) "; } $sQuery .= "AND ($sSQLSearchString)"; } else { $sQuery .= "WHERE ($sSQLSearchString)"; } $sQuery .= "ORDER BY D.name ASC"; $aColumns = array("folder_image_url", "document_name"); $aColumnTypes = array(4,3); $aColumnHeaders = array("Folder","Document"); $aLinkURLs = array("$default->rootUrl/control.php?action=browse","$default->rootUrl/control.php?action=viewDocument"); $aDBQueryStringColumns = array("document_id","folder_id"); $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; } ?>