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 ($bSearchByDocument) {
$sQuery .= "WHERE D.id IN ($sIDs) ";
} else {
$sQuery .= "WHERE F.id IN ($sIDs) ";
}
$sQuery .= "AND ($sSQLSearchString)";
$sQuery .= "ORDER BY D.name ASC";
$aColumns = array("folder_image_url", "document_name");
$aColumnTypes = array(4,3);
$aColumnHeaders = array("","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;
}
?>