123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603 |
- <?php
- class SurveyTree {
- public $surveylist;
- public $plainsurveylist;
- public $numbersurveys;
-
- public function __construct() {
-
- $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);
-
- $search_restriction = SurveyUtil::survey_search_restriction();
- if ($search_restriction) {
- $search_restriction = ' AND '.$search_restriction;
- }
- $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.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;
- }
-
- public function getParentId ($id) {
- $node = $this->plainsurveylist[$id];
- if (is_array($node)&& !empty($node['parent_id']))
- return $node['parent_id'];
- else
- return -1;
- }
-
- public function createList ($list) {
- $result=array();
- if(is_array($list)) {
- foreach ($list as $key=>$node) {
- if (is_array($node['children']))
- {
-
-
-
- $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;
- }
- }
- ?>
|