$v) {
if (searchCriteria($k) === 1) {
$v = trim($v);
if ($v === "") {
continue;
}
if ($v === "-1") {
continue;
}
$aReq[$k] = $v;
}
}
$aIDs = array_unique(array_map("criteriaNumber", array_keys($aReq)));
$aSQL = array();
foreach ($aIDs as $iID) {
$oCriterion =& Criteria::getCriterionByNumber($iID);
$res = $oCriterion->searchSQL($aReq);
if (!is_null($res)) {
$aSQL[] = $res;
}
}
$aCritParams = array();
$aCritQueries = array();
foreach ($aSQL as $sSQL) {
if (is_array($sSQL)) {
$aCritQueries[] = $sSQL[0];
$aCritParams = array_merge($aCritParams , $sSQL[1]);
} else {
$aCritQueries[] = $sSQL;
}
}
$sSQLSearchString = join(" AND ", $aCritQueries);
$sQuery = DBUtil::compactQuery("
SELECT
F.name AS folder_name, F.id AS folder_id, D.id AS document_id,
D.name AS document_name, COUNT(D.id) AS doc_count
FROM
$default->documents_table AS D
INNER JOIN $default->folders_table AS F ON D.folder_id = F.id
LEFT JOIN $default->document_fields_link_table AS DFL ON DFL.document_id = D.id
LEFT JOIN $default->document_fields_table AS DF ON DF.id = DFL.document_field_id
INNER JOIN $default->search_permissions_table AS SDUL ON SDUL.document_id = D.id
INNER JOIN $default->status_table AS SL on D.status_id=SL.id
WHERE
SDUL.user_id = ?
AND SL.name = ?
AND ($sSQLSearchString)
GROUP BY D.id
ORDER BY doc_count DESC");
$aParams = array();
$aParams[] = $_SESSION["userID"];
$aParams[] = "Live";
$aParams = array_merge($aParams, $aCritParams);
//var_dump(DBUtil::getResultArray(array($sQuery, $aParams)));
//exit(0);
$aColumns = array("folder_name", "document_name", "doc_count");
$aColumnTypes = array(3,3,1);
$aColumnHeaders = array("graphicsUrl/widgets/dfolder.gif>" . _("Folder") . "","" . _("Document") . "", "" . _("Matches") . "");
$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(array($sQuery, $aParams), 10, $aColumns, $aColumnTypes, $aColumnHeaders, $aLinkURLs, $aDBQueryStringColumns, $aQueryStringVariableNames);
$oPatternBrowse->setStartIndex($iStartIndex);
$oPatternBrowse->setSearchText("");
$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") . "