/** * Contacts Search method * * The sql must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav * @param string Target search string * @param string mathcing option, exact|any|all * @param string ordering option, newest|oldest|popular|alpha|category */ function plgSearchJFContacts($text, $phrase = '', $ordering = '', $areas = null) { $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $registry =& JFactory::getConfig(); $lang = $registry->getValue("config.jflang"); if (is_array($areas)) { if (!array_intersect($areas, array_keys(plgSearchContactAreas()))) { return array(); } } // load plugin params info $plugin =& JPluginHelper::getPlugin('search', 'jfcontacts'); $pluginParams = new JParameter($plugin->params); $limit = $pluginParams->def('search_limit', 50); $activeLang = $pluginParams->def('active_language_only', 0); $text = trim($text); if ($text == '') { return array(); } $section = JText::_('Contact'); switch ($ordering) { case 'alpha': $order = 'a.name ASC'; break; case 'category': $order = 'b.title ASC, a.name ASC'; break; case 'popular': case 'newest': case 'oldest': default: $order = 'a.name DESC'; } $text = $db->Quote('%' . $db->getEscaped($text, true) . '%', false); $query = 'SELECT a.id as contid, b.id as catid, a.name AS title, "" AS created,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, ' . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END AS catslug, ' . ' a.name, a.con_position, a.misc,' . ' "2" AS browsernav,' . ' jfl.code as jflang, jfl.name as jflname' . ' FROM #__contact_details AS a' . ' INNER JOIN #__categories AS b ON b.id = a.catid' . "\n LEFT JOIN #__jf_content as jfc ON reference_id = a.id" . "\n LEFT JOIN #__languages as jfl ON jfc.language_id = jfl.id" . ' WHERE jfc.value LIKE ' . $text . ' AND a.published = 1' . ' AND b.published = 1' . ' AND a.access <= ' . (int) $user->get('aid') . ' AND b.access <= ' . (int) $user->get('aid') . "\n AND jfc.reference_table = 'contact_details'" . ($activeLang ? "\n AND jfl.code = '{$lang}'" : '') . ' GROUP BY a.id' . ' ORDER BY ' . $order; $db->setQuery($query, 0, $limit); $rows = $db->loadObjectList(); foreach ($rows as $key => $row) { $rows[$key]->text = $row->name . "/" . $row->con_position . "/" . $row->misc; $rows[$key]->section = $section . "/" . $row->title . " - " . $row->jflname; $rows[$key]->href = 'index.php?option=com_contact&view=contact&id=' . $row->slug . '&catid=' . $row->catslug; } return $rows; }
/** * Contacts Search method * * The sql must return the following fields that are used in a common display * routine: href, title, section, created, text, browsernav * @param string Target search string * @param string mathcing option, exact|any|all * @param string ordering option, newest|oldest|popular|alpha|category */ function onSearch($text, $phrase = '', $ordering = '', $areas = null) { $db =& JFactory::getDbo(); $user =& JFactory::getUser(); $groups = implode(',', $user->authorisedLevels()); if (is_array($areas)) { if (!array_intersect($areas, array_keys(plgSearchContactAreas()))) { return array(); } } // load plugin params info $plugin =& JPluginHelper::getPlugin('search', 'contacts'); $pluginParams = new JParameter($plugin->params); $limit = $pluginParams->def('search_limit', 50); $text = trim($text); if ($text == '') { return array(); } $section = JText::_('Contact'); switch ($ordering) { case 'alpha': $order = 'a.name ASC'; break; case 'category': $order = 'b.title ASC, a.name ASC'; break; case 'popular': case 'newest': case 'oldest': default: $order = 'a.name DESC'; } $text = $db->Quote('%' . $db->getEscaped($text, true) . '%', false); $query = 'SELECT a.name AS title, "" AS created,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, ' . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END AS catslug, ' . ' CONCAT_WS(", ", a.name, a.con_position, a.misc) AS text,' . ' CONCAT_WS(" / ", ' . $db->Quote($section) . ', b.title) AS section,' . ' "2" AS browsernav' . ' FROM #__contact_details AS a' . ' INNER JOIN #__categories AS b ON b.id = a.catid' . ' WHERE (a.name LIKE ' . $text . ' OR a.misc LIKE ' . $text . ' OR a.con_position LIKE ' . $text . ' OR a.address LIKE ' . $text . ' OR a.suburb LIKE ' . $text . ' OR a.state LIKE ' . $text . ' OR a.country LIKE ' . $text . ' OR a.postcode LIKE ' . $text . ' OR a.telephone LIKE ' . $text . ' OR a.fax LIKE ' . $text . ')' . ' AND a.published = 1' . ' AND b.published = 1' . ' AND a.access IN (' . $groups . ')' . ' AND b.access IN (' . $groups . ')' . ' GROUP BY a.id' . ' ORDER BY ' . $order; $db->setQuery($query, 0, $limit); $rows = $db->loadObjectList(); foreach ($rows as $key => $row) { $rows[$key]->href = 'index.php?option=com_contact&view=contact&id=' . $row->slug . '&catid=' . $row->catslug; } return $rows; }