123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * This library provides functions for user management.
- * Include/require it in your code to use its functionality.
- *
- * @package chamilo.library
- */
- /**
- *
- * Manage the "versioning" of a conditional survey
- * @package chamilo.survey
- * */
- class SurveyTree
- {
- public $surveylist;
- public $plainsurveylist;
- public $numbersurveys;
- /**
- * Sets the surveylist and the plainsurveylist
- */
- public function __construct()
- {
- // Database table definitions
- $table_survey = Database :: get_course_table(TABLE_SURVEY);
- $table_survey_question = Database :: get_course_table(TABLE_SURVEY_QUESTION);
- $table_user = Database :: get_main_table(TABLE_MAIN_USER);
- // searching
- $search_restriction = SurveyUtil::survey_search_restriction();
- if ($search_restriction) {
- $search_restriction = ' AND '.$search_restriction;
- }
-
- $course_id = api_get_course_int_id();
- $sql = "SELECT survey.survey_id , survey.parent_id, survey_version, survey.code as name
- FROM $table_survey survey LEFT JOIN $table_survey_question survey_question
- ON survey.survey_id = survey_question.survey_id , $table_user user
- WHERE
- survey.c_id = $course_id AND
- survey_question.c_id = $course_id AND
- survey.author = user.user_id
- GROUP BY survey.survey_id";
- $res = Database::query($sql);
- $surveys_parents = array ();
- $refs = array();
- $list = array();
- $last = array();
- $plain_array=array();
- while ($survey = Database::fetch_array($res,'ASSOC'))
- {
- $plain_array[$survey['survey_id']]=$survey;
- $surveys_parents[]=$survey['survey_version'];
- $thisref = &$refs[ $survey['survey_id'] ];
- $thisref['parent_id'] = $survey['parent_id'];
- $thisref['name'] = $survey['name'];
- $thisref['id'] = $survey['survey_id'];
- $thisref['survey_version'] = $survey['survey_version'];
- if ($survey['parent_id'] == 0) {
- $list[ $survey['survey_id'] ] = &$thisref;
- } else {
- $refs[ $survey['parent_id'] ]['children'][ $survey['survey_id'] ] = &$thisref;
- }
- }
- $this->surveylist = $list;
- $this->plainsurveylist = $plain_array;
- }
- /**
- * This function gets the parent id of a survey
- *
- * @param int survey id
- * @return int survey parent id
- *
- * @author Julio Montoya <gugli100@gmail.com>, Dokeos
- * @version September 2008
- */
- public function getParentId($id)
- {
- $node = $this->plainsurveylist[$id];
- if (is_array($node)&& !empty($node['parent_id'])) {
- return $node['parent_id'];
- } else {
- return -1;
- }
- }
- /**
- * This function creates a list of all surveys id
- * @param list of nodes
- * @return array with the structure survey_id => survey_name
- * @author Julio Montoya <gugli100@gmail.com>
- * @version September 2008
- */
- public function createList ($list)
- {
- $result = array();
- if (is_array($list)) {
- foreach ($list as $key=>$node) {
- if (isset($node['children']) && is_array($node['children'])) {
- //echo $key; echo '--<br>';
- //print_r($node);
- //echo '<br>';
- $result[$key]= $node['name'];
- $re = self::createList($node['children']);
- if (!empty($re)) {
- if (is_array($re)) {
- foreach ($re as $key=>$r) {
- $result[$key]=''.$r;
- }
- } else {
- $result[]=$re;
- }
- }
- } else {
- $result[$key]=$node['name'];
- }
- }
- }
- return $result;
- }
- }
|