/favorites/admin/models/scopes.php

<?php
/**
 * @version	1.5
 * @package	Tags
 * @author 	Dioscouri Design
 * @link 	http://www.dioscouri.com
 * @copyright Copyright (C) 2007 Dioscouri Design. All rights reserved.
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
*/

/** ensure this file is being included by a parent file */
defined('_JEXEC') or die('Restricted access');
Favorites::load( 'FavoritesModelBase', 'models.base' );
class FavoritesModelScopes extends FavoritesModelBase   
{
    protected function _buildQueryWhere(&$query)
    {
       	$filter                  = $this->getState('filter');
        $filter_id_from	         = $this->getState('filter_id_from');
        $filter_id_to	         = $this->getState('filter_id_to');
        $filter_name	         = $this->getState('filter_name');
        $filter_identifier       = $this->getState('filter_identifier');
        $filter_url              = $this->getState('filter_url');
        $filter_table            = $this->getState('filter_table');
        $filter_table_field      = $this->getState('filter_table_field');
        $filter_table_name_field = $this->getState('filter_table_name_field');

       	if ($filter) 
       	{
			$key	= $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter ) ) ).'%');

			$where = array();
			$where[] = 'LOWER(tbl.scope_id) LIKE '.$key;
			$where[] = 'LOWER(tbl.scope_name) LIKE '.$key;
			$where[] = 'LOWER(tbl.scope_identifier) LIKE '.$key;
			$where[] = 'LOWER(tbl.scope_url) LIKE '.$key;
			
			$query->where('('.implode(' OR ', $where).')');
       	}
       	
		if (strlen($filter_id_from))
        {
            if (strlen($filter_id_to))
        	{
        		$query->where('tbl.scope_id >= '.(int) $filter_id_from);	
        	}
        		else
        	{
        		$query->where('tbl.scope_id = '.(int) $filter_id_from);
        	}
       	}
       	
		if (strlen($filter_id_to))
        {
        	$query->where('tbl.scope_id <= '.(int) $filter_id_to);
       	}
       	
    	if (strlen($filter_name))
        {
        	$key	= $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_name ) ) ).'%');
        	$query->where('LOWER(tbl.scope_name) LIKE '.$key);
       	}

       	if (strlen($filter_identifier))
        {
            $key    = $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_identifier ) ) ).'%');
            $query->where('LOWER(tbl.scope_identifier) LIKE '.$key);
        }
        
        if (strlen($filter_url))
        {
            $key    = $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_url ) ) ).'%');
            $query->where('LOWER(tbl.scope_url) LIKE '.$key);
        }
        
    	if (strlen($filter_table))
        {
            $key    = $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_table ) ) ).'%');
            $query->where('LOWER(tbl.scope_table) LIKE '.$key);
        }
        
    	if (strlen($filter_table_field))
        {
            $key    = $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_table_field ) ) ).'%');
            $query->where('LOWER(tbl.scope_table_field) LIKE '.$key);
        }
        
    	if (strlen($filter_table_name_field))
        {
            $key    = $this->_db->Quote('%'.$this->_db->getEscaped( trim( strtolower( $filter_table_name_field ) ) ).'%');
            $query->where('LOWER(tbl.scope_table_name_field) LIKE '.$key);
        }
    }
        	
	public function getList($refresh = false)
	{
		$list = parent::getList($refresh); 
		foreach(@$list as $item)
		{
			$item->link = 'index.php?option=com_favorites&view=scopes&task=edit&id='.$item->scope_id;
		}
		return $list;
	}
		
}