ilLikeShopObjectSearch Class Reference

Inheritance diagram for ilLikeShopObjectSearch:

Collaboration diagram for ilLikeShopObjectSearch:

Public Member Functions
	__construct ($qp_obj)
	__createWhereCondition ()
Public Member Functions inherited from ilShopObjectSearch
	__construct ($qp_obj)
	setCustomSearchResultObject ($a_search_result_obect)
	setFilterShopTopicId ($a_topic_id)
	getFilterShopTopicId ()
	performSearch ()
	__createInStatement ()
	__createLocateString ()
	build locate string in case of AND search More...
	__prepareFound (&$row)
Public Member Functions inherited from ilAbstractSearch
	ilAbstractSearch (&$qp_obj)
	Constructor public. More...
	setFields ($a_fields)
	Set fields to search. More...
	getFields ()
	Get fields to search. More...
	setFilter ($a_filter)
	set object type to search in More...
	setIdFilter ($a_id_filter)
	Set id filter Filters search by given object id. More...
	getIdFilter ()
	Get Id filter. More...
	appendToFilter ($a_type)
	Append object type to filter. More...
	getFilter ()
	get object type to search in More...
	__createLocateString ()
	build locate string in case of AND search More...
	__prepareFound (&$row)
&	performSearch ()

Additional Inherited Members
Data Fields inherited from ilAbstractSearch
	$db = null
	$query_parser = null
	$search_result = null
	$object_types

Detailed Description

Definition at line 35 of file class.ilLikeShopObjectSearch.php.

Constructor & Destructor Documentation

__construct()

ilLikeShopObjectSearch::__construct

(

$qp_obj

)

Definition at line 37 of file class.ilLikeShopObjectSearch.php.

        {
                parent::__construct($qp_obj);
        }

Member Function Documentation

__createWhereCondition()

ilLikeShopObjectSearch::__createWhereCondition

(

)

Definition at line 42 of file class.ilLikeShopObjectSearch.php.

References $ilDB, and ilShopObjectSearch\getFilterShopTopicId().

        {
                global $ilDB;
                
                $where = '';
                $types = array();
                $values = array();              

                $where .= 'WHERE (payment_objects.status = 1 OR payment_objects.status = 2) AND (';
                $counter = 0;
                foreach($this->query_parser->getQuotedWords() as $word)
                {
                        if($counter++)
                        {
                                $where .= 'OR';
                        }       
                        $concat = $ilDB->concat(
                                array(
                                        array('title','text'),
                                        array('description','text')));
                        $where .= $this->db->like($concat, 'text', '%%'.$word.'%%');
                        
                }
                $where .= ') ';
                
                if($this->getFilterShopTopicId() != 0)
                {
                        $where .= '     AND pt_topic_fk = %s ';
                        $types[] = 'integer';
                        $values[] = $this->getFilterShopTopicId();                       
                }
                
                return array(
                        'query' => $where,
                        'types' => $types,
                        'values' => $values
                );
        }

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• Services/Search/classes/Like/class.ilLikeShopObjectSearch.php