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 
{
        const CONCAT_AND = 0;
        const CONCAT_OR = 1;
        
        var $search_terms;

        var $concatenation;

        var $search_field;

        var $search_type;

        var $search_results;

        var $ilDB;


        function SurveySearch(
          $search_text = "",
          $concatenation = self::CONCAT_AND,
          $search_field = "all",
                  $search_type = "all"
        )
        {
                global $ilDB;

                $this->ilDB =& $ilDB;

                $this->search_terms = split(" +", $search_text);
                $this->concatenation = $concatenation;
                        $this->search_field = $search_field;
                $this->search_type = $search_type;
                        $this->search_results = array();
        }
        
        function search()
        {
                global $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($params, " OR ") . ")");
                }
                $str_where = "";
                if ($this->concatenation == self::CONCAT_AND)
                {
                        $str_where = "(" . join($cumulated_fields, " AND ") . ")";
                }
                else
                {
                        $str_where = "(" . join($cumulated_fields, " OR ") . ")";
                }
                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();
                global $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;
        }
}

?>