SurveySearch Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for SurveySearch:

Public Member Functions
	__construct (string $search_text="", int $concatenation=self::CONCAT_AND, string $search_field="all", string $search_type="all")
	search ()

Data Fields
const	CONCAT_AND = 0
const	CONCAT_OR = 1
array	$search_terms
int	$concatenation
string	$search_field
string	$search_type
array	$search_results
ilDBInterface	$ilDB

Protected Attributes
ilRbacSystem	$rbacsystem

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class for search actions in ILIAS survey tool The SurveySearch class defines and encapsulates basic methods and attributes to search the ILIAS survey tool for questions.

Author

Helmut Schottmüller helmu.nosp@m.t.sc.nosp@m.hottm.nosp@m.uell.nosp@m.er@ma.nosp@m.c.co.nosp@m.m

Definition at line 25 of file class.SurveySearch.php.

Constructor & Destructor Documentation

__construct()

SurveySearch::__construct	(	string	$search_text = "",
		int	$concatenation = self::CONCAT_AND,
		string	$search_field = "all",
		string	$search_type = "all"
	)

Definition at line 50 of file class.SurveySearch.php.

References $concatenation, $DIC, $ilDB, $search_field, and $search_type.

      {
        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();
    }

Member Function Documentation

search()

SurveySearch::search

(

)

Definition at line 71 of file class.SurveySearch.php.

References $ilDB, $params, $rbacsystem, ilRbacSystem\checkAccess(), ilDBInterface\fetchAssoc(), ilDBInterface\like(), ilDBInterface\query(), and ilDBInterface\quote().

                            : void
    {
        $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) {
            $fields[(string) $term] = array();
            switch ($this->search_field) {
                case "all":
                    $fields[(string) $term][] = $ilDB->like("svy_question.title", 'text', "%" . $term . "%");
                    $fields[(string) $term][] = $ilDB->like("svy_question.description", 'text', "%" . $term . "%");
                    $fields[(string) $term][] = $ilDB->like("svy_question.author", 'text', "%" . $term . "%");
                    $fields[(string) $term][] = $ilDB->like("svy_question.questiontext", 'text', "%" . $term . "%");
                    break;
                default:
                    $fields[(string) $term][] = $ilDB->like("svy_question." . $this->search_field, 'text', "%" . $term . "%");
                    break;
            }
        }
        $cumulated_fields = array();
        foreach ($fields as $params) {
            $cumulated_fields[] = "(" . implode(" OR ", $params) . ")";
        }
        $str_where = "";
        if ($this->concatenation === self::CONCAT_AND) {
            $str_where = "(" . implode(" AND ", $cumulated_fields) . ")";
        } else {
            $str_where = "(" . implode(" 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 (((int) $row["complete"]) === 1 && $rbacsystem->checkAccess('write', $row["ref_id"])) {
                    $result_array[] = $row;
                }
            }
        }
        $this->search_results = $result_array;
    }

Here is the call graph for this function:

Field Documentation

$concatenation

int SurveySearch::$concatenation

Definition at line 36 of file class.SurveySearch.php.

Referenced by __construct().

$ilDB

ilDBInterface SurveySearch::$ilDB

Definition at line 47 of file class.SurveySearch.php.

Referenced by __construct(), and search().

$rbacsystem

ilRbacSystem SurveySearch::$rbacsystem

protected

Definition at line 30 of file class.SurveySearch.php.

Referenced by search().

$search_field

string SurveySearch::$search_field

Definition at line 39 of file class.SurveySearch.php.

Referenced by __construct().

$search_results

array SurveySearch::$search_results

Definition at line 45 of file class.SurveySearch.php.

$search_terms

array SurveySearch::$search_terms

Definition at line 33 of file class.SurveySearch.php.

$search_type

string SurveySearch::$search_type

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

Referenced by __construct().

CONCAT_AND

const SurveySearch::CONCAT_AND = 0

Definition at line 27 of file class.SurveySearch.php.

CONCAT_OR

const SurveySearch::CONCAT_OR = 1

Definition at line 28 of file class.SurveySearch.php.

---

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

• components/ILIAS/Survey/classes/class.SurveySearch.php