" . _("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") . "
";
$aReq = array();
foreach ($aOrigReq as $k => $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();
$aJoinSQL = array();
foreach ($aIDs as $iID) {
$oCriterion =& Criteria::getCriterionByNumber($iID);
$res = $oCriterion->searchSQL($aReq);
if (!is_null($res)) {
$aSQL[] = $res;
}
$res = $oCriterion->searchJoinSQL();
if (!is_null($res)) {
$aJoinSQL[] = $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;
}
}
if (count($aCritQueries) == 0) {
return "No search criteria were specified";
}
$sSQLSearchString = join(" AND ", $aCritQueries);
$sJoinSQL = join(" ", $aJoinSQL);
$sToSearch = KTUtil::arrayGet($aOrigReq, 'fToSearch', 'Live');
$oPermission =& KTPermission::getByName('ktcore.permissions.read');
$sPermissionLookupsTable = KTUtil::getTableName('permission_lookups');
$sPermissionLookupAssignmentsTable = KTUtil::getTableName('permission_lookup_assignments');
$sPermissionDescriptorsTable = KTUtil::getTableName('permission_descriptors');
$aGroups = GroupUtil::listGroupsForUserExpand($_SESSION['userID']);
$aPermissionDescriptors = KTPermissionDescriptor::getByGroups($aGroups, array('ids' => true));
$sPermissionDescriptors = DBUtil::paramArray($aPermissionDescriptors);
$sQuery = DBUtil::compactQuery("
SELECT
F.name AS folder_name, F.id AS folder_id, D.id AS document_id,
D.name AS document_name, D.filename AS file_name, COUNT(D.id) AS doc_count, 'View' AS view
FROM
$default->documents_table AS D
INNER JOIN $default->folders_table AS F ON D.folder_id = F.id
$sJoinSQL
INNER JOIN $default->status_table AS SL ON D.status_id=SL.id
INNER JOIN $sPermissionLookupsTable AS PL ON D.permission_lookup_id = PL.id
INNER JOIN $sPermissionLookupAssignmentsTable AS PLA ON PL.id = PLA.permission_lookup_id AND PLA.permission_id = ?
WHERE
PLA.permission_descriptor_id IN ($sPermissionDescriptors)
AND SL.name = ?
AND ($sSQLSearchString)
GROUP BY D.id
ORDER BY doc_count DESC");
$aParams = array();
$aParams[] = $oPermission->getId();
$aParams = array_merge($aParams, $aPermissionDescriptors);
$aParams[] = $sToSearch;
$aParams = array_merge($aParams, $aCritParams);
//var_dump(DBUtil::getResultArray(array($sQuery, $aParams)));
//exit(0);
$aColumns = array("folder_name", "file_name", "document_name", "doc_count", "view");
$aColumnTypes = array(3,3,3,1,3);
$aColumnHeaders = array("graphicsUrl/widgets/dfolder.gif>" . _("Folder") . "", "" . _("Name") . "", "" . _("Title") . "", "" . _("Matches") . "", "" . _("View") . "");
$aLinkURLs = array("$default->rootUrl/control.php?action=browse","$default->rootUrl/control.php?action=viewDocument", "$default->rootUrl/control.php?action=viewDocument", null, "$default->rootUrl/control.php?action=downloadDocument");
$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("");
$oPatternBrowse->setRememberValues($aReq);
$sForSearch = "";
return renderHeading(_("Advanced Search")) . $oPatternBrowse->render() . $sForSearch . $sRefreshMessage;
}
function dealWithAdvancedSearch($aReq, $iStartIndex) {
global $main;
$oPatternCustom = & new PatternCustom();
$oPatternCustom->setHtml(getAdvancedSearchResults($aReq, $iStartIndex));
$main->setCentralPayload($oPatternCustom);
$main->render();
}
?>