loadTemplate("ktcore/boolean_search");
$aCriteria = Criteria::getAllCriteria();
$aTemplateData = array(
"aCriteria" => $aCriteria,
);
return $oTemplate->render($aTemplateData);
}
function handleOutput($data) {
global $main;
$main->bFormDisabled = true;
$main->setCentralPayload($data);
$main->render();
}
function do_performSearch() {
// TODO first extract environ vars
// TODO second create criterion objects (see getAdvancedSearchResults for this.
// TODO third get each one to generate the SQL snippet. (ENSURE that they are wrapped in '('..')' )
// TODO fourth array().join(' AND ') where appropriate
// TODO finally return via PatternBrowseableSearchResults (urgh.)
$datavars = KTUtil::arrayGet($_REQUEST, 'boolean_search');
if (!is_array($datavars)) {
$datavars = unserialize($datavars);
}
if (empty($datavars)) {
$this->errorRedirectToMain('You need to have at least 1 condition.');
}
$res = $this->handleCriteriaSet($datavars, KTUtil::arrayGet($_REQUEST, 'fStartIndex', 1));
return $res;
}
function _oneCriteriaSetToSQL($aOneCriteriaSet) {
$aSQL = array();
$aJoinSQL = array();
$criteria_set = array();
foreach ($aOneCriteriaSet as $order => $dataset) {
$oCriterion = Criteria::getCriterionByNumber($dataset["type"]);
if (PEAR::isError($oCriterion)) {
$this->errorRedirectToMain('Invalid criteria specified.');
}
$criteria_set[] = array($oCriterion, $dataset["data"]);
}
foreach ($criteria_set as $oCriterionPair) {
$oCriterion = $oCriterionPair[0];
$aReq = $oCriterionPair[1];
$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) {
$this->errorRedirectToMain("No search criteria were specified");
exit(0);
}
return array($aCritQueries, $aCritParams, $aJoinSQL);
}
function criteriaSetToSQL($aCriteriaSet) {
$aJoinSQL = array();
$aSearchStrings = array();
$aParams = array();
foreach ($aCriteriaSet["subgroup"] as $k => $aOneCriteriaSet) {
if (is_null($aOneCriteriaSet["values"])) {
continue;
}
list($aThisCritQueries, $aThisParams, $aThisJoinSQL) = $this->_oneCriteriaSetToSQL($aOneCriteriaSet["values"]);
$aJoinSQL = array_merge($aJoinSQL, $aThisJoinSQL);
$aParams = array_merge($aParams, $aThisParams);
$aSearchStrings[] = "\n\t\t(\n\t\t\t" . join("\n " . KTUtil::arrayGet($aOneCriteriaSet, 'join', "AND") . " ", $aThisCritQueries) . "\n\t\t)";
}
$sJoinSQL = join(" ", $aJoinSQL);
$sSearchString = "\n\t(" . join("\n\t\t" . $aCriteriaSet['join'] . " ", $aSearchStrings) . "\n\t)";
return array($sSearchString, $aParams, $sJoinSQL);
}
function handleCriteriaSet($aCriteriaSet, $iStartIndex) {
global $default;
list($sSQLSearchString, $aCritParams, $sJoinSQL) = $this->criteriaSetToSQL($aCriteriaSet);
$sToSearch = KTUtil::arrayGet($aOrigReq, 'fToSearch', 'Live'); // actually never present in this version.
$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);
//print '';var_dump(DBUtil::getResultArray(array($sQuery, $aParams)));
//exit(0);
//return ''.print_r(DBUtil::getResultArray(array($sQuery, $aParams)), true).'
';
$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("");
$sFormStart = '