File odules/page/class/plugin/search.php

 1: <?php
 2: /*
 3:  You may not change or alter any portion of this comment or credits
 4:  of supporting developers from this source code or any supporting source code
 5:  which is considered copyrighted (c) material of the original comment or credit authors.
 6: 
 7:  This program is distributed in the hope that it will be useful,
 8:  but WITHOUT ANY WARRANTY; without even the implied warranty of
 9:  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10: */
11: 
12: use Xoops\Module\Plugin\PluginAbstract;
13: use Xmf\Metagen;
14: 
15: /**
16:  * page module
17:  *
18:  * @author          Mage Grégory (AKA Mage)
19:  * @copyright       2000-2015 XOOPS Project (http://xoops.org)
20:  * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
21:  * @since           2.6.0
22:  */
23: class PageSearchPlugin extends PluginAbstract implements SearchPluginInterface
24: {
25:     /**
26:      * search - search
27:      *
28:      * @param string[] $queryArray search terms
29:      * @param string   $andor      and/or how to treat search terms
30:      * @param integer  $limit      max number to return
31:      * @param integer  $offset     offset of first row to return
32:      * @param integer  $userid     a specific user id to limit the query
33:      *
34:      * @return array of result items
35:      *           'title' => the item title
36:      *           'content' => brief content or summary
37:      *           'link' => link to visit item
38:      *           'time' => time modified (unix timestamp)
39:      *           'uid' => author uid
40:      *           'image' => icon for search display
41:      *
42:      */
43:     public function search($queryArray, $andor, $limit, $offset, $userid)
44:     {
45:         $andor = strtolower($andor)==='and' ? 'and' : 'or';
46: 
47:         $qb = \Xoops::getInstance()->db()->createXoopsQueryBuilder();
48:         $eb = $qb->expr();
49:         $qb ->select('DISTINCT *')
50:             ->fromPrefix('page_content')
51:             ->where($eb->neq('content_status', '0'))
52:             ->orderBy('content_create', 'DESC')
53:             ->setFirstResult($offset)
54:             ->setMaxResults($limit);
55:         if (is_array($queryArray) && !empty($queryArray)) {
56:             $queryParts = array();
57:             foreach ($queryArray as $i => $q) {
58:                 $qterm = ':qterm' . $i;
59:                 $qb->setParameter($qterm, '%' . $q . '%', \PDO::PARAM_STR);
60:                 $queryParts[] = $eb -> orX(
61:                     $eb->like('content_title', $qterm),
62:                     $eb->like('content_text', $qterm),
63:                     $eb->like('content_shorttext', $qterm)
64:                 );
65:             }
66:             if ($andor === 'and') {
67:                 $qb->andWhere(call_user_func_array(array($eb, "andX"), $queryParts));
68:             } else {
69:                 $qb->andWhere(call_user_func_array(array($eb, "orX"), $queryParts));
70:             }
71:         } else {
72:             $qb->setParameter(':uid', (int) $userid, \PDO::PARAM_INT);
73:             $qb->andWhere($eb->eq('content_author', ':uid'));
74:         }
75: 
76:         $myts = \Xoops\Core\Text\Sanitizer::getInstance();
77:         $items = array();
78:         $result = $qb->execute();
79:         while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {
80:             $content = $myrow["content_shorttext"] . "<br /><br />" . $myrow["content_text"];
81:             $content = $myts->displayTarea($content);
82:             $items[] = array(
83:                 'title' => $myrow['content_title'],
84:                 'content' => Metagen::getSearchSummary($content, $queryArray),
85:                 'link' => "viewpage.php?id=" . $myrow["content_id"],
86:                 'time' => $myrow['content_create'],
87:                 'uid' => $myrow['content_author'],
88:                 'image' => 'images/logo_small.png',
89:             );
90:         }
91:         return $items;
92:     }
93: }
94:
Namespaces

Classes

Interfaces

Exceptions

Functions
