Developing (v7+)

How to change search block to filterByAttribute?

Permalink May 23, 2010 at 8:54 AM

I'm overriding the 'search' block controller's 'do_search' function:

function do_search() {
      $q = $_REQUEST['query'];
      Loader::library('database_indexed_search');
      $ipl = new IndexedPageList();
      $ipl->filterByKeywords($q);
      if( is_array($_REQUEST['search_paths']) ){ 
         foreach($_REQUEST['search_paths'] as $path) {
            //if(!strlen($path)) continue;
            $ipl->addSearchPath($path);
         }
      }
      $res = $ipl->getPage(); 
      foreach($res as $r) { 
         $results[] = new IndexedSearchResult($r['cID'], $r['cName'], $r['cDescription'], $r['score'], $r['cPath'], $r['content']);
      }

Viewing 15 lines of 19 lines. View entire code block.

 
   function do_search() {
      $q = $_REQUEST['query'];
 
      Loader::library('database_indexed_search');
      $ipl = new IndexedPageList();
      $ipl->filterByKeywords($q);
 
      if( is_array($_REQUEST['search_paths']) ){ 
         foreach($_REQUEST['search_paths'] as $path) {
            //if(!strlen($path)) continue;
            $ipl->addSearchPath($path);
         }
      }
 
      $res = $ipl->getPage(); 
 
      foreach($res as $r) { 
         $results[] = new IndexedSearchResult($r['cID'], $r['cName'], $r['cDescription'], $r['score'], $r['cPath'], $r['content']);
      }
 
      $this->set('query', $q);
      $this->set('paginator', $ipl->getPagination());
      $this->set('results', $results);
   }

If I change the loader library for a model and change the filterByKeywords for filterByAttribute:

function do_search() {
      $q = $_REQUEST['query'];
      $length = $_REQUEST['length'];
      $continent = $_REQUEST['continent'];
      $adventure = $_REQUEST['adventure'];
      $interest = $_REQUEST['interest'];
      $attributeKeyHandle = 'continent';
      //Loader::library('database_indexed_search');
      //$ipl = new IndexedPageList();
      //$ipl->filterByKeywords($q);
      Loader::model('page_list');
      $ipl = new PageList();
      $ipl->filterByAttribute('continent', '%' . $continent . '%', 'like');
      if( is_array($_REQUEST['search_paths']) ){ 
         foreach($_REQUEST['search_paths'] as $path) {

Viewing 15 lines of 28 lines. View entire code block.

 
   function do_search() {
      $q = $_REQUEST['query'];
      $length = $_REQUEST['length'];
      $continent = $_REQUEST['continent'];
      $adventure = $_REQUEST['adventure'];
      $interest = $_REQUEST['interest'];
      $attributeKeyHandle = 'continent';
 
      //Loader::library('database_indexed_search');
      //$ipl = new IndexedPageList();
      //$ipl->filterByKeywords($q);
 
      Loader::model('page_list');
      $ipl = new PageList();
      $ipl->filterByAttribute('continent', '%' . $continent . '%', 'like');
 
      if( is_array($_REQUEST['search_paths']) ){ 
         foreach($_REQUEST['search_paths'] as $path) {
            //if(!strlen($path)) continue;
            $ipl->addSearchPath($path);
         }
      }
 
      $res = $ipl->getPage(); 
 
      foreach($res as $r) { 
         $results[] = new IndexedSearchResult($r['cID'], $r['cName'], $r['cDescription'], $r['score'], $r['cPath'], $r['content']);
      }
 
      $this->set('query', $q);
      $this->set('paginator', $ipl->getPagination());
      $this->set('results', $results);
      $this->set('temp', $continent);
   }

it throws an error: "Fatal error: Class 'IndexedSearchResult' not found in /srv/www/htdocs/c5/blocks/search/controller.php".

And if I add a library 'Loader::library('indexed_search');', it says "Fatal error: Cannot use object of type Page as array in /srv/www/htdocs/c5/blocks/search/controller.php"

How can I search for pages by attributes and only show those which match all? Thank you.

linuxoid replied on May 23, 2010 at 9:54 am Permalink Reply

$%@%$@#%#^%#^%@^#&^##$%%!!!!!!! I'll be damned!!! I've just got back to a default Search block controller, just changed the filterByKeywords for filterByAttribute - it showed me that fatal database error which said something about 'cIndexScore' table couldn't be found, then by pure luck I saw this in the database_indexed_search.php:

class IndexedPageList extends PageList {
   public function getPage() {
      $this->sortByMultiple('cIndexScore desc', 'cDatePublic desc');
      $r = parent::getPage();
      $results = array();
      foreach($r as $c) {
         $results[] = array('cID' => $c->getCollectionID(), 'cName' => $c->getCollectionName(), 'cDescription' => $c->getCollectionDescription(), 'score' => $c->getPageIndexScore(), 'cPath' => $c->getCollectionPath(), 'content' => $c->getPageIndexContent());
      }
      return $results;
   }
}

So I've removed the 'cIndexScore desc' from the getPage() function and it started workign! The search actually finds the attributes and displays all relevant pages. Holy sh*t! I've wasted 3 weeks trying to fix this. I don't know if removing 'cIndexScore desc' broke something else, but at least the search works.

Can anyone shed some more light on this? What's the 'cIndexScore desc' and why doesn't this table exist in the database?

jincmd replied on May 23, 2010 at 2:46 pm Permalink Reply

Could you link me to a page that displays this mod in action?

linuxoid replied on May 23, 2010 at 6:35 pm Permalink Reply

You mean to a real web page? Sorry, I'm currently running only on localhost. What would you like to see? Maybe I can take some screen shots and attach them here.

jincmd replied on May 23, 2010 at 6:51 pm Permalink Reply

That would be just as well....

synlag replied on May 24, 2010 at 1:37 am Permalink Reply

cIndexScore is not set in <web-root>/concrete/config/db.xml, dunno might be a miss, i couldn't locate it elsewhere.

sortByMultiple is implemented in item_list.

i've found a comment by andrew
/**
* @DEPRECATED.
* Just use PageList with filterByKeywords instead. We'll keep this around so people know what to expect
*/

filterByKeywords and filterByAttribute works fine.

http://docs.concrete5addons.com/... might help

linuxoid replied on May 24, 2010 at 2:55 am Permalink Reply

If you read my first post, when I changed IndexedPageList for just PageList, it gave me those two errors: "Fatal error: Class 'IndexedSearchResult' not found in /srv/www/htdocs/c5/blocks/search/controller.php" and "Fatal error: Cannot use object of type Page as array in /srv/www/htdocs/c5/blocks/search/controller.php".

Could you please paste a code example of searching by attributes? If my page has a few attributes and some have multiple choices, will it search and match only all those set or I have to implement it all in a loop myself, checking for each attribute for each query? Thank you.

synlag replied on May 24, 2010 at 3:05 am Permalink Reply

Yes, i see.

Guess the search block needs a bit of overwork, as it makes use of IndexedPageList which is depricated.

linuxoid replied on May 24, 2010 at 5:01 am Permalink Reply 1 Attachment

How come the Documentation (http://www.concrete5.org/documentation/developers/pages/searching-and-filtering/) shows Filtering Methods Available - $pl->filterByAttribute($attributeKeyHandle, $value, $comparison) when it doesn't exist in the page_list.php?

Would greatly appreciate your help (code example) to filterByAttribute to match all multiple attributes selected by select boxes (attached screenshot)

synlag replied on May 24, 2010 at 5:52 am Permalink Reply

It's implemented in Matogertels search tools package.

Take a look

http://www.concrete5.org/marketplace/addons/search-tools/...

Tony replied on May 24, 2010 at 11:33 pm Permalink Reply

related thread, with some code examples and some explanations:

http://www.concrete5.org/index.php?cID=51736...

Forums

Developing (v7+)

How to change search block to filterByAttribute?

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?