class.ilLikeAdvancedSearch.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilLikeAdvancedSearch extends ilAdvancedSearch
{
    public function __createTaxonWhereCondition(): string
    {
        if ($this->options['lom_taxon']) {
            $where = " WHERE (";
 
            $counter = 0;
            foreach ($this->query_parser->getQuotedWords() as $word) {
                if ($counter++) {
                    $where .= "OR";
                }
 
                $where .= $this->db->like('taxon', 'text', '%' . $word . '%');
            }
            $where .= ') ';
            return $where;
        }
        return '';
    }
 
    public function __createKeywordWhereCondition(): string
    {
        $where = " WHERE (";
 
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $where .= "OR";
            }
 
            $where .= $this->db->like('keyword', 'text', '%' . $word . '%');
        }
        $where .= ') ';
        return $where;
    }
 
    public function __createLifecycleWhereCondition(): string
    {
        if ($this->options['lom_version']) {
            $where = " WHERE (";
 
            $counter = 0;
            foreach ($this->query_parser->getQuotedWords() as $word) {
                if ($counter++) {
                    $where .= "OR";
                }
 
                $where .= $this->db->like('meta_version', 'text', '%' . $word . '%');
            }
            $where .= ') ';
            return $where;
        }
        return '';
    }
 
    public function __createEntityWhereCondition(): string
    {
        if ($this->options['lom_role_entry']) {
            $where = " WHERE (";
 
            $counter = 0;
            foreach ($this->query_parser->getQuotedWords() as $word) {
                if ($counter++) {
                    $where .= "OR";
                }
 
                $where .= $this->db->like('entity', 'text', '%' . $word . '%');
            }
            $where .= ') ';
            return $where;
        }
        return '';
    }
 
    public function __createCoverageAndCondition(): string
    {
        if ($this->options['lom_coverage']) {
            $where = " AND (";
 
            $counter = 0;
            foreach ($this->query_parser->getQuotedWords() as $word) {
                if ($counter++) {
                    $where .= "OR";
                }
 
                $where .= $this->db->like('coverage', 'text', '%' . $word . '%');
            }
            $where .= ') ';
            return $where;
        }
        return '';
    }
 
    public function __createObjectPropertiesWhereCondition(string ...$fields): string
    {
        $concat_array = [];
        foreach ($fields as $field) {
            $concat_array[] = [$field, 'text'];
        }
        $concat = $this->db->concat($concat_array);
 
        $where = " WHERE (";
 
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $where .= "OR";
            }
 
            $where .= $this->db->like($concat, 'text', '%' . $word . '%');
        }
        $where .= ') ';
 
        return $where;
    }
}