TYPO3 Core

/**

* Get search result rows / data from database. Returned as data in array.

*

* @param array Search word array

* @return array False if no result, otherwise an array with keys for first row, result rows and total number of results found.

*/

function getResultRows($sWArr) {

// Getting SQL result pointer:

$GLOBALS['TT']->push('Searching result');

$res = $this->getResultRows_SQLpointer($sWArr);

$GLOBALS['TT']->pull();

// Organize and process result:

if ($res) {

// Get some variables:

$count = $GLOBALS['TYPO3_DB']->sql_num_rows($res);

$pointer = t3lib_div::intInRange($this->piVars['pointer'],0,floor($count/$this->piVars['results']));

// Initialize result accumulation variables:

$c = 0;

$lines = Array();

$grouping_phashes = array(); // Used to filter out duplicates.

$grouping_chashes = array(); // Used to filter out duplicates BASED ON cHash.

$firstRow = Array(); // Will hold the first row in result - used to calculate relative hit-ratings.

$resultRows = Array(); // Will hold the results rows for display.

// Now, traverse result and put the rows to be displayed into an array

// Each row should be a the fields from 'ISEC.*, IP.*' combined + artificial fields "show_resume" (boolean) and "result_number" (counter)

while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {

// Set first row:

if (!$c) {

$firstRow = $row;

}

$row['show_resume'] = $this->checkResume($row); // Tells whether we can link directly to a document or not (depends on possible right problems)

$phashGr = !in_array($row['phash_grouping'], $grouping_phashes);

$chashGr = !in_array($row['contentHash'].'.'.$row['data_page_id'], $grouping_chashes);

if ($phashGr && $chashGr) {

if ($row['show_resume']) { // Only if the resume may be shown are we going to filter out duplicates...

if (!$this->multiplePagesType($row['item_type'])) { // Only on documents which are not multiple pages documents

$grouping_phashes[] = $row['phash_grouping'];

}

$grouping_chashes[] = $row['contentHash'].'.'.$row['data_page_id'];

}

$c++;

// All rows for display is put into resultRows[]

if ($c > $pointer * $this->piVars['results']) {

$row['result_number'] = $c;

$resultRows[] = $row;

if ($c+1 > ($pointer+1)*$this->piVars['results']) break;

}

} else {

$count--; // For each time a phash_grouping document is found (which is thus not displayed) the search-result count is reduced, so that it matches the number of rows displayed.

}

}

return array(

'resultRows' => $resultRows,

'firstRow' => $firstRow,

'count' => $count

);

} else { // No results found:

return FALSE;

}

}