Exemplo n.º 1
0
 public function onTagSearch(&$query, &$where, $tag = null)
 {
     if (!$this->params->get("tag_search", 0)) {
         return false;
     }
     if ($tag !== "") {
         $tag = JUDirectoryFrontHelper::UrlDecode($tag);
         $address_id = (int) $tag;
         if ($address_id) {
             $db = JFactory::getDbo();
             $_query = $db->getQuery(true);
             $_query->select('n.id')->from('#__judirectory_addresses AS n, #__judirectory_addresses AS p')->where('n.lft BETWEEN p.lft AND p.rgt')->where('p.id = ' . $address_id)->order('n.lft');
             $db->setQuery($_query);
             $address_ids = $db->loadColumn();
             $query->join('LEFT', '#__judirectory_locations AS location ON location.listing_id = listing.id');
             $where[] = 'location.address_id IN (' . implode(', ', $address_ids) . ')';
             $query->group('listing.id');
         }
     }
 }
Exemplo n.º 2
0
 public function onSimpleSearch(&$query, &$where, $search)
 {
     if ($search !== "") {
         $search = JUDirectoryFrontHelper::UrlDecode($search);
         $db = JFactory::getDbo();
         $_query = array();
         $query->join('LEFT', '#__judirectory_locations AS location ON location.listing_id = listing.id');
         $_query[] = $db->quoteName('location.address') . " LIKE " . $db->quote("%" . $search . "%");
         $_query[] = $db->quoteName('location.description') . " LIKE " . $db->quote("%" . $search . "%");
         $query->join('LEFT', '#__judirectory_addresses AS address ON address.id = location.address_id');
         $where[] = '(' . implode($_query, ' OR ') . ')';
     }
 }
Exemplo n.º 3
0
 public function onTagSearch(&$query, &$where, $tag = null)
 {
     if (!$this->params->get("tag_search", 0)) {
         return false;
     }
     if (is_null($tag)) {
         $app = JFactory::getApplication();
         $tag = $app->input->get("tag", "", "string");
     }
     if (!$this->isCore()) {
         $query->join('', '#__judirectory_fields_values AS field_values_' . $this->id . ' ON (listing.id = field_values_' . $this->id . '.listing_id AND field_values_' . $this->id . '.field_id = ' . $this->id . ')');
     }
     if ($tag !== "") {
         $tag = JUDirectoryFrontHelper::UrlDecode($tag);
         $db = JFactory::getDbo();
         $_where = "(( " . $this->fieldvalue_column . " = " . $db->quote($tag) . " OR " . $this->fieldvalue_column . " LIKE '" . $db->escape($tag, true) . "|%'" . " OR " . $this->fieldvalue_column . " LIKE '%|" . $db->escape($tag, true) . "|%'" . " OR " . $this->fieldvalue_column . " LIKE '%|" . $db->escape($tag, true) . "' )";
         $_where .= " OR ( " . $this->fieldvalue_column . " LIKE '" . $db->escape($tag, true) . ",%'" . " OR " . $this->fieldvalue_column . " LIKE '%," . $db->escape($tag, true) . ",%'" . " OR " . $this->fieldvalue_column . " LIKE '%," . $db->escape($tag, true) . "' ))";
         $where[] = $_where;
     }
 }