class.SurveySearch.php

Go to the documentation of this file.

<?php
 /*
   +----------------------------------------------------------------------------+
   | ILIAS open source                                                          |
   +----------------------------------------------------------------------------+
   | Copyright (c) 1998-2001 ILIAS open source, University of Cologne           |
   |                                                                            |
   | This program is free software; you can redistribute it and/or              |
   | modify it under the terms of the GNU General Public License                |
   | as published by the Free Software Foundation; either version 2             |
   | of the License, or (at your option) any later version.                     |
   |                                                                            |
   | This program is distributed in the hope that it will be useful,            |
   | but WITHOUT ANY WARRANTY; without even the implied warranty of             |
   | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the              |
   | GNU General Public License for more details.                               |
   |                                                                            |
   | You should have received a copy of the GNU General Public License          |
   | along with this program; if not, write to the Free Software                |
   | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
   +----------------------------------------------------------------------------+
*/
 
class SurveySearch
{
    protected $rbacsystem;
 
    const CONCAT_AND = 0;
    const CONCAT_OR = 1;
    
    public $search_terms;
 
    public $concatenation;
 
    public $search_field;
 
    public $search_type;
 
    public $search_results;
 
    public $ilDB;
 
 
    public function __construct($search_text = "", $concatenation = self::CONCAT_AND, $search_field = "all", $search_type = "all")
    {
        global $DIC;
 
        $this->rbacsystem = $DIC->rbac()->system();
        $ilDB = $DIC->database();
 
        $this->ilDB = $ilDB;
 
        $this->search_terms = explode(" +", $search_text);
        $this->concatenation = $concatenation;
        $this->search_field = $search_field;
        $this->search_type = $search_type;
        $this->search_results = array();
    }
    
    public function search()
    {
        $ilDB = $this->ilDB;
        
        $where = "";
        $fields = array();
        if (strcmp($this->search_type, "all") != 0) {
            $where = "svy_qtype.type_tag = " . $ilDB->quote($this->search_type, 'text');
        }
        foreach ($this->search_terms as $term) {
            switch ($this->search_field) {
                case "all":
                    $fields["$term"] = array();
                    array_push($fields["$term"], $ilDB->like("svy_question.title", 'text', "%" . $term . "%"));
                    array_push($fields["$term"], $ilDB->like("svy_question.description", 'text', "%" . $term . "%"));
                    array_push($fields["$term"], $ilDB->like("svy_question.author", 'text', "%" . $term . "%"));
                    array_push($fields["$term"], $ilDB->like("svy_question.questiontext", 'text', "%" . $term . "%"));
                    break;
                default:
                    $fields["$term"] = array();
                    array_push($fields["$term"], $ilDB->like("svy_question." . $this->search_field, 'text', "%" . $term . "%"));
                    break;
            }
        }
        $cumulated_fields = array();
        foreach ($fields as $params) {
            array_push($cumulated_fields, "(" . join(" OR ", $params) . ")");
        }
        $str_where = "";
        if ($this->concatenation == self::CONCAT_AND) {
            $str_where = "(" . join(" AND ", $cumulated_fields) . ")";
        } else {
            $str_where = "(" . join(" OR ", $cumulated_fields) . ")";
        }
        if ($str_where) {
            $str_where = " AND $str_where";
        }
        if ($where) {
            $str_where .= " AND (" . $where . ")";
        }
        $result = $ilDB->query("SELECT svy_question.*, svy_qtype.type_tag, object_reference.ref_id FROM " .
            "svy_question, svy_qtype, object_reference WHERE svy_question.questiontype_fi = svy_qtype.questiontype_id " .
            "AND svy_question.original_id IS NULL AND svy_question.obj_fi = object_reference.obj_id AND " .
            "svy_question.obj_fi > 0$str_where");
        $result_array = array();
        $rbacsystem = $this->rbacsystem;
        if ($result->numRows() > 0) {
            while ($row = $ilDB->fetchAssoc($result)) {
                if (($row["complete"] == 1) and ($rbacsystem->checkAccess('write', $row["ref_id"]))) {
                    array_push($result_array, $row);
                }
            }
        }
        $this->search_results = &$result_array;
    }
}