survey/classes/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. |
   +----------------------------------------------------------------------------+
*/

define ("CONCAT_AND", 0);
define ("CONCAT_OR", 1);

class SurveySearch {
  var $search_terms;

  var $concatenation;

  var $search_field;

  var $search_type;

  var $search_results;

  var $ilDB;


  function SurveySearch(
    $search_text = "",
    $concatenation = 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()
        {
                $where = "";
                $fields = array();
                if (strcmp($this->search_type, "all") != 0)
                {
                        $where = sprintf("survey_questiontype.type_tag = %s",
                                $this->ilDB->quote($this->search_type)
                        );
                }
                foreach ($this->search_terms as $term)
                {
                        switch ($this->search_field)
                        {
                                case "all":
                                        $fields["$term"] = array();
                                        array_push($fields["$term"], sprintf("survey_question.title LIKE %s",
                                                $this->ilDB->quote("%$term%")
                                        ));
                                        array_push($fields["$term"], sprintf("survey_question.description LIKE %s",
                                                $this->ilDB->quote("%$term%")
                                        ));
                                        array_push($fields["$term"], sprintf("survey_question.author LIKE %s",
                                                $this->ilDB->quote("%$term%")
                                        ));
                                        array_push($fields["$term"], sprintf("survey_question.questiontext LIKE %s",
                                                $this->ilDB->quote("%$term%")
                                        ));
                                        break;
                                default:
                                        $fields["$term"] = array();
                                        array_push($fields["$term"], sprintf("survey_question.$this->search_field LIKE %s",
                                                $this->ilDB->quote("%$term%")
                                        ));
                                        break;                          
                        }
                }
                $cumulated_fields = array();
                foreach ($fields as $params)
                {
                        array_push($cumulated_fields, "(" . join($params, " OR ") . ")");
                }
                $str_where = "";
                if ($this->concatenation == 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 . ")";
                }
                $query = "SELECT survey_question.*, survey_questiontype.type_tag, object_reference.ref_id FROM survey_question, survey_questiontype, object_reference WHERE survey_question.questiontype_fi = survey_questiontype.questiontype_id AND ISNULL(survey_question.original_id) AND survey_question.obj_fi = object_reference.obj_id AND survey_question.obj_fi > 0$str_where";
                $result = $this->ilDB->query($query);
                $result_array = array();
                global $rbacsystem;
    if (strcmp(strtolower(get_class($result)), db_result) == 0) {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                if (($row["complete"] == 1) and ($rbacsystem->checkAccess('write', $row["ref_id"])))
                                {
                                        array_push($result_array, $row);
                                }
                        }
                }
                $this->search_results =& $result_array;
        }
}
?>