surveymanager.lib.php 71 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150
  1. <?php // $Id: usermanager.lib.php,v 1.9.2.3 2005/10/28 14:31:45 bmol Exp $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2004-2008 Dokeos SPRL
  6. Copyright (c) 2003 Ghent University (UGent)
  7. Copyright (c) 2001 Universite catholique de Louvain (UCL)
  8. Copyright (c) various contributors
  9. For a full list of contributors, see "credits.txt".
  10. The full license can be read in "license.txt".
  11. This program is free software; you can redistribute it and/or
  12. modify it under the terms of the GNU General Public License
  13. as published by the Free Software Foundation; either version 2
  14. of the License, or (at your option) any later version.
  15. See the GNU General Public License for more details.
  16. Contact: Dokeos, rue du Corbeau, 108, B-1030 Brussels, Belgium, info@dokeos.com
  17. ==============================================================================
  18. */
  19. /**
  20. ==============================================================================
  21. * This library provides functions for user management.
  22. * Include/require it in your code to use its functionality.
  23. *
  24. * @author Bart Mollet, main author
  25. * @package dokeos.library
  26. ==============================================================================
  27. */
  28. class SurveyManager {
  29. private function __construct() {
  30. }
  31. /**
  32. * Creates a new survey for the platform
  33. * Possible deprecated method
  34. */
  35. public static function select_survey_list ($seleced_surveyid='', $extra_script='') {
  36. $survey_table = Database :: get_course_table(TABLE_SURVEY);
  37. $sql = "SELECT * FROM $survey_table";// WHERE is_shared='1'";
  38. $sql_result = Database::query($sql,__FILE__,__LINE__);
  39. if (Database::num_rows($sql_result) > 0)
  40. {
  41. $str_survey_list = "";
  42. $str_survey_list .= "<select name=\"exiztingsurvey\" $extra_script>\n";
  43. $str_survey_list .= "<option value=\"\">--Select Survey--</option>";
  44. while($result=Database::fetch_array($sql_result))
  45. {
  46. $selected = ($seleced_surveyid==$result[survey_id])?"selected":"";
  47. $str_survey_list .= "\n<option value=\"".$result[survey_id]."\" ".$selected.">".$result[title]."</option>";
  48. }
  49. $str_survey_list .= "</select>";
  50. return $str_survey_list;
  51. }
  52. else
  53. {
  54. return false;
  55. }
  56. }
  57. /*function getsurveyid($existing)
  58. {
  59. $survey_table = Database :: get_course_table(TABLE_MAIN_SURVEY);
  60. $sql = "SELECT survey_id FROM $survey_table WHERE title='$existing'" ;
  61. $result = Database::query($sql,__FILE__,__LINE__);
  62. $i=0;
  63. $survey_id=Database::result($result,$i,'survey_id');
  64. echo "in getsurveyid".$survey_id;
  65. return(survey_id);
  66. }
  67. */
  68. /**
  69. * Possible deprecated method
  70. */
  71. function create_group($survey_id,$group_title,$introduction,$table_group)
  72. {
  73. $sql_query = "SELECT * FROM $table_group WHERE groupname='".Database::escape_string($group_title)."' AND survey_id=".Database::escape_string($survey_id);
  74. $res = Database::query($sql_query, __FILE__, __LINE__);
  75. if (Database::num_rows($res))
  76. {
  77. return false;
  78. }
  79. else
  80. {
  81. $sql = 'SELECT MAX(sortby) FROM '.$table_group.' WHERE survey_id="'.Database::escape_string($survey_id).'"';
  82. $rs = Database::query($sql, __FILE__, __LINE__);
  83. list($sortby) = Database::fetch_array($rs);
  84. $sortby++;
  85. $sql="INSERT INTO $table_group(group_id,survey_id,groupname,introduction, sortby) values('','$survey_id','$group_title','$introduction','$sortby')";
  86. $result=Database::query($sql, __FILE__, __LINE__);
  87. return Database::insert_id();
  88. }
  89. }
  90. /**
  91. * Possible deprecated method
  92. */
  93. function get_survey_author($authorid)
  94. {
  95. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  96. $authorid = Database::escape_string($authorid);
  97. $sql_query = "SELECT * FROM $user_table WHERE user_id='$authorid'";
  98. $res = Database::query($sql_query, __FILE__, __LINE__);
  99. $firstname=@Database::result($res,0,'firstname');
  100. return $firstname;
  101. }
  102. /**
  103. * Possible deprecated method
  104. */
  105. function get_author($db_name,$survey_id)
  106. {
  107. //$table_survey = Database :: get_course_table(TABLE_SURVEY);
  108. $survey_id = Database::escape_string($survey_id);
  109. $sql = "SELECT author FROM $db_name.survey WHERE survey_id='$survey_id'";
  110. $res = Database::query($sql, __FILE__, __LINE__);
  111. $author=@Database::result($res,0,'author');
  112. return $author;
  113. }
  114. /**
  115. * Possible deprecated method
  116. */
  117. function get_surveyid($db_name,$group_id)
  118. {
  119. //$group_table = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  120. $group_id = Database::escape_string($group_id);
  121. $sql = "SELECT survey_id FROM $db_name.survey_group WHERE group_id='$group_id'";
  122. $res = Database::query($sql, __FILE__, __LINE__);
  123. $surveyid=@Database::result($res,0,'survey_id');
  124. return $surveyid;
  125. }
  126. public static function get_groupname ($db_name,$gid) {
  127. //$grouptable = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  128. $gid = Database::escape_string($gid);
  129. $sql = "SELECT * FROM $db_name.survey_group WHERE group_id='$gid'";
  130. $res=Database::query($sql, __FILE__, __LINE__);
  131. $code=@Database::result($res,0,'groupname');
  132. return($code);
  133. }
  134. /**
  135. * Possible deprecated method
  136. */
  137. function insert_into_group ($survey_id,$group_title,$introduction,$tb) {
  138. $survey_id = Database::escape_string($survey_id);
  139. $group_title = Database::escape_string($group_title);
  140. $introduction = Database::escape_string($introduction);
  141. $sql="INSERT INTO $tb (group_id,survey_id,group_title,introduction) values('','$survey_id','$group_title','$introduction')";
  142. $result=Database::query($sql, __FILE__, __LINE__);
  143. return Database::insert_id();
  144. }
  145. /**
  146. * Possible deprecated method
  147. */
  148. function get_survey_code ($table_survey,$survey_code)
  149. {
  150. $survey_code = Database::escape_string($survey_code);
  151. $sql="SELECT code FROM $table_survey where code='$survey_code'";
  152. //echo $sql;
  153. //exit;
  154. $result=Database::query($sql, __FILE__, __LINE__);
  155. $code=@Database::result($result,0,'code');
  156. //echo $code;exit;
  157. return($code);
  158. }
  159. /**
  160. * Possible deprecated method
  161. */
  162. function get_survey_list()
  163. {
  164. $survey_table = Database :: get_course_table(TABLE_SURVEY);
  165. $sql_query = "SELECT survey_id,title FROM $survey_table where title!='' ";
  166. $sql_result = Database::query($sql_query,__FILE__,__LINE__);
  167. echo "<select name=\"author\">";
  168. echo "<option value=\"\"><--Select Survey--></optional>";
  169. while ($result =@Database::fetch_array($sql_result))
  170. {
  171. echo "\n<option value=\"".$result[survey_id]."\">".$result[title]."</option>";
  172. }
  173. echo "</select>";
  174. }
  175. /**
  176. * Possible deprecated method
  177. */
  178. function create_survey ($surveycode,$surveytitle, $surveysubtitle, $author, $survey_language, $availablefrom, $availabletill,$isshare, $surveytemplate, $surveyintroduction, $surveythanks, $table_survey, $table_group)
  179. {
  180. //$table_survey = Database :: get_course_table(TABLE_SURVEY);
  181. $sql = "INSERT INTO $table_survey (code,title, subtitle, author,lang,avail_from,avail_till, is_shared,template,intro,surveythanks,creation_date) values('$surveycode','$surveytitle','$surveysubtitle','$author','$survey_language','$availablefrom','$availabletill','$isshare','$surveytemplate','$surveyintroduction','$surveythanks',curdate())";
  182. $result = Database::query($sql, __FILE__, __LINE__);
  183. //$result = Database::query($sql, __FILE__, __LINE__);
  184. $survey_id = Database::insert_id();
  185. $sql2 = "INSERT INTO $table_group(group_id,survey_id,groupname,introduction) values('','$survey_id','No Group','This is your Default Group')";
  186. $result = Database::query($sql2, __FILE__, __LINE__);
  187. return $survey_id;
  188. }
  189. /**
  190. * Possible deprecated method
  191. */
  192. function create_survey_in_another_language($id, $lang){
  193. global $_course;
  194. $original_survey = self::get_all_datas($id);
  195. // copy the survey itself
  196. $sql = 'INSERT INTO '.$_course['dbName'].'.survey SET
  197. code = "'.$original_survey->code.'",
  198. title = "'.addslashes($original_survey->title).'",
  199. subtitle = "'.addslashes($original_survey->subtitle).'",
  200. author = "'.$original_survey->author.'",
  201. lang = "'.$lang.'",
  202. avail_from = "'.$original_survey->avail_from.'",
  203. avail_till = "'.$original_survey->avail_till.'",
  204. is_shared = "'.$original_survey->is_shared.'",
  205. template = "'.$original_survey->template.'",
  206. intro = "'.addslashes($original_survey->intro).'",
  207. surveythanks = "'.addslashes($original_survey->surveythanks).'",
  208. creation_date = "NOW()"';
  209. $result = Database::query($sql, __FILE__, __LINE__);
  210. $new_survey_id = Database::insert_id();
  211. // copy the groups
  212. $groups = self::listGroups($id);
  213. foreach($groups as $group)
  214. {
  215. self::import_group($new_survey_id, $group['group_id'], $_course['dbName'], $_course['dbName']);
  216. }
  217. }
  218. /**
  219. * Possible deprecated method
  220. */
  221. function create_survey_attach($surveycode,$surveytitle, $surveysubtitle, $author, $survey_language, $availablefrom, $availabletill,$isshare, $surveytemplate, $surveyintroduction, $surveythanks, $table_survey, $table_group)
  222. {
  223. //$table_survey = Database :: get_course_table(TABLE_SURVEY);
  224. $sql = "INSERT INTO $table_survey (code,title, subtitle, author,lang,avail_from,avail_till, is_shared,template,intro,surveythanks,creation_date) values('$surveycode','$surveytitle','$surveysubtitle','$author','$survey_language','$availablefrom','$availabletill','$isshare','$surveytemplate','$surveyintroduction','$surveythanks',curdate())";
  225. $result = Database::query($sql, __FILE__, __LINE__);
  226. $survey_id = Database::insert_id();
  227. return $survey_id;
  228. }
  229. /**
  230. * Possible deprecated method
  231. */
  232. function update_survey($surveyid,$surveycode,$surveytitle, $surveysubtitle, $author, $survey_language, $availablefrom, $availabletill,$isshare, $surveytemplate, $surveyintroduction, $surveythanks, $cidReq,$table_course)
  233. {
  234. $sql_course = "SELECT * FROM $table_course WHERE code = '$cidReq'";
  235. $res_course = Database::query($sql_course,__FILE__,__LINE__);
  236. $obj_course=@Database::fetch_object($res_course);
  237. $curr_dbname = $obj_course->db_name ;
  238. $surveyid = Database::escape_string($surveyid);
  239. $sql = "UPDATE $curr_dbname.survey SET code='$surveycode', title='$surveytitle', subtitle='$surveysubtitle', lang='$survey_language', avail_from='$availablefrom', avail_till='$availabletill', is_shared='$isshare', template='$surveytemplate', intro='$surveyintroduction',surveythanks='$surveythanks'
  240. WHERE survey_id='$surveyid'";
  241. Database::query($sql, __FILE__, __LINE__);
  242. return $curr_dbname;
  243. }
  244. /*
  245. function create_question($gid,$type,$caption,$answers,$open_ans,$answerT,$answerD,$rating,$table_question)
  246. {
  247. for($i=0;$i<10;$i++)
  248. {
  249. $x.= "'".$answers[$i]."',";
  250. }
  251. //echo "Hello".$x;
  252. for($j=0;$j<10;$j++)
  253. {
  254. if($j==9)
  255. {
  256. $y.= "'".$rating[$j]."'";
  257. }
  258. else
  259. {
  260. $y.= "'".$rating[$j]."',";
  261. }
  262. }
  263. $anst = implode(", " ,$answerT);
  264. $ansd = implode(", " ,$answerD);
  265. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  266. $sql = "INSERT INTO $table_question (gid,type,caption,ans1,ans2,ans3,ans4,ans5,ans6,ans7,ans8,ans9,ans10,open_ans,anst,ansd,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('$gid','$type','$caption',$x'$open_ans','$anst','$ansd',$y)";
  267. $result = Database::query($sql, __FILE__, __LINE__);
  268. return Database::insert_id();
  269. }
  270. function get_question($questionid)
  271. {
  272. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  273. $sql = "SELECT * FROM $table_question where qid='$questionid'";
  274. $res=Database::query($sql, __FILE__, __LINE__);
  275. $code=@Database::result($res,0,'caption');
  276. return($code);
  277. }
  278. */
  279. /**
  280. * Possible deprecated method
  281. */
  282. function create_question($gid,$surveyid,$qtype,$caption,$alignment,$answers,$open_ans,$answerT,$answerD,$rating,$curr_dbname)
  283. {
  284. $sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
  285. $res_sort=Database::query($sql_sort, __FILE__, __LINE__);
  286. $rs=Database::fetch_object($res_sort);
  287. $sortby=$rs->sortby;
  288. if(empty($sortby))
  289. {
  290. $sortby=1;
  291. }
  292. else
  293. {
  294. $sortby=$sortby+1;
  295. }
  296. for($i=0;$i<10;$i++)
  297. {
  298. $x.= "'".$answers[$i]."',";
  299. }
  300. for($j=0;$j<10;$j++)
  301. {
  302. if($j==9)
  303. {
  304. $y.= "'".$rating[$j]."'";
  305. }
  306. else
  307. {
  308. $y.= "'".$rating[$j]."',";
  309. }
  310. }
  311. /*if($qtype=='Multiple Choice (multiple answer)')
  312. {
  313. $anst = implode(", " ,$answerT);
  314. $ansd = implode(", " ,$answerD);
  315. }
  316. else
  317. {*/
  318. $anst = $answerT;
  319. $ansd = $answerD;
  320. //}
  321. $sql = "INSERT INTO $curr_dbname.questions (gid,survey_id,qtype,caption,alignment,sortby,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('$gid','$surveyid','$qtype','$caption','$alignment','$sortby',$x'$anst','$ansd',$y)";
  322. $result = Database::query($sql, __FILE__, __LINE__);
  323. return Database::insert_id();
  324. }
  325. /**
  326. * Possible deprecated method
  327. */
  328. function update_question($qid,$qtype,$caption,$alignment,$answers,$open_ans,$curr_dbname)
  329. {
  330. for($i=0;$i<10;$i++)
  331. {
  332. $k=$i+1;
  333. $a.$k= $answers[$i];
  334. }
  335. $anst = $answerT;
  336. $ansd = $answerD;
  337. $sql = "UPDATE $curr_dbname.questions SET qtype='$qtype',caption='$caption',alignment='$alignment',a1='$answers[0]',a2='$answers[1]',a3='$answers[2]',a4='$answers[3]',a5='$answers[4]',a6='$answers[5]',a7='$answers[6]',a8='$answers[7]',a9='$answers[8]',a10='$answers[9]' WHERE qid='$qid'";
  338. $result = Database::query($sql, __FILE__, __LINE__);
  339. return Database::insert_id();
  340. }
  341. /**
  342. * Possible deprecated method
  343. */
  344. function get_question_type($questionid)
  345. {
  346. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  347. $questionid = Database::escape_string($questionid);
  348. $sql = "SELECT * FROM $table_question WHERE qid='$questionid'";
  349. $res=Database::query($sql, __FILE__, __LINE__);
  350. $code=@Database::result($res,0,'type');
  351. return($code);
  352. }
  353. /**
  354. * Possible deprecated method
  355. */
  356. function no_of_question($db_name,$gid)
  357. {
  358. //$table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  359. $gid = Database::escape_string($gid);
  360. $sql = "SELECT * FROM $db_name.questions WHERE gid='$gid'";
  361. $res=Database::query($sql, __FILE__, __LINE__);
  362. $code=@Database::num_rows($res);
  363. return($code);
  364. }
  365. /**
  366. * Possible deprecated method
  367. */
  368. function get_question_data($qid,$curr_dbname)
  369. {
  370. $qid = Database::escape_string($qid);
  371. $sql = "SELECT * FROM $curr_dbname.questions where qid='$qid'";
  372. $res=Database::query($sql, __FILE__, __LINE__);
  373. $rs=Database::fetch_object($res);
  374. $properties = get_object_vars($rs);
  375. foreach ($properties as $property=>$val){
  376. $val = stripslashes($val);
  377. $rs->$property = $val;
  378. }
  379. return $rs;
  380. }
  381. /**
  382. * Possible deprecated method
  383. */
  384. function get_data($id, $field)
  385. {
  386. global $_course;
  387. $sql='SELECT '.$field.' FROM '.$_course['dbName'].'.survey WHERE survey_id='.intval($id);
  388. $res=Database::query($sql, __FILE__, __LINE__);
  389. $code=@Database::result($res,0);
  390. return($code);
  391. }
  392. /**
  393. * Possible deprecated method
  394. */
  395. function get_all_datas($id)
  396. {
  397. global $_course;
  398. $sql='SELECT * FROM '.$_course['dbName'].'.survey WHERE survey_id='.intval($id);
  399. $res=Database::query($sql, __FILE__, __LINE__);
  400. return Database::fetch_object($res);
  401. }
  402. /**
  403. * Possible deprecated method
  404. */
  405. function get_surveyname($db_name,$sid)
  406. {
  407. //$surveytable=Database:: get_course_table(TABLE_SURVEY);
  408. $sid = Database::escape_string($sid);
  409. $sql="SELECT * FROM $db_name.survey WHERE survey_id=$sid";
  410. $res=Database::query($sql, __FILE__, __LINE__);
  411. $code=@Database::result($res,0,'title');
  412. return($code);
  413. }
  414. /**
  415. * Possible deprecated method
  416. */
  417. function get_surveyname_display($sid)
  418. {
  419. $sid = Database::escape_string($sid);
  420. $surveytable=Database:: get_course_table(TABLE_SURVEY);
  421. $sql="SELECT * FROM $surveytable WHERE survey_id=$sid";
  422. $res=Database::query($sql, __FILE__, __LINE__);
  423. $code=@Database::result($res,0,'title');
  424. return($code);
  425. }
  426. /*
  427. function join_survey($question_type)
  428. {
  429. $table_survey = Database :: get_course_table(TABLE_MAIN_SURVEY);
  430. $table_group = Database :: get_course_table(TABLE_MAIN_GROUP);
  431. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  432. echo $sql="select t1.title as stitle, t3.type as type, t3.caption as caption, t2.groupname as groupname from $table_survey t1, $table_group t2, $table_question t3 where t1.survey_id=t2.survey_id and t3.gid=t2.group_id and t3.type='$question_type'";
  433. $sql_result = Database::query($sql,__FILE__,__LINE__);
  434. $result = Database::fetch_object($sql_result);
  435. return ($result);
  436. }
  437. */
  438. /**
  439. * Possible deprecated method
  440. */
  441. function import_questions($import_type, $ids)
  442. {
  443. //$groupname=surveymanager::get_groupname($gid_arr[$index]);
  444. switch ($import_type) {
  445. case "survey":
  446. {
  447. }
  448. case "groups":
  449. {
  450. foreach ($ids as $gid){
  451. $sql="insert into $table_question SELECT ('',gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) FROM $table_question where gid=$gid";
  452. }
  453. }
  454. case "questions":
  455. {
  456. }
  457. }
  458. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  459. if(isset($selected_group)){
  460. if($selected_group!=''){
  461. $sql = "SELECT $table_group('survey_id', 'groupname') values('$sid', '$groupname')";
  462. $res = Database::query($sql, __FILE__, __LINE__);
  463. $sql = "INSERT INTO $table_group('survey_id', 'groupname') values('$sid', '$groupname')";
  464. $res = Database::query($sql, __FILE__, __LINE__);
  465. $gid_arr[$index]+= Database::insert_id();
  466. $groupids=implode(",",$gid_arr);
  467. }
  468. }
  469. echo $groupids;
  470. }
  471. /**
  472. * This function deletes a survey and all the groups and question belonging to it.
  473. *
  474. * @param unknown_type $survey_id
  475. *
  476. * @author unknown
  477. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, cleanup and refactoring
  478. *
  479. */
  480. public static function delete_survey($survey_id)
  481. {
  482. $table_survey = Database :: get_course_table(TABLE_SURVEY);
  483. $table_group = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  484. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  485. $survey_id = Database::escape_string($survey_id);
  486. // Deleting the survey
  487. $sql = "DELETE FROM $table_survey WHERE survey_id='".$survey_id."'";
  488. Database::query($sql,__FILE__,__LINE__);
  489. // Deleting all the questions of the survey
  490. $sql = "SELECT * FROM $table_group WHERE survey_id='".$survey_id."'";
  491. $res = Database::query($sql,__FILE__,__LINE__);
  492. while($obj = Database::fetch_object($res))
  493. {
  494. $sql = "DELETE FROM $table_question WHERE gid='".$obj->group_id."'";
  495. Database::query($sql,__FILE__,__LINE__);
  496. }
  497. // Deleting the groups of the survey
  498. $sql = "DELETE FROM $table_group WHERE survey_id='".$survey_id."'";
  499. Database::query($sql,__FILE__,__LINE__);
  500. return true;
  501. }
  502. /**
  503. * Possible deprecated method
  504. * This function deletes a
  505. * @param unknown_type $group_id
  506. * @param unknown_type $curr_dbname
  507. *
  508. * @author unknown
  509. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, refactoring: using correct database calls and removing useless second parameter
  510. */
  511. function delete_group($group_id)
  512. {
  513. // Database table definitions
  514. /** @todo use database constants for the survey tables */
  515. $table_question = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  516. $table_survey_group = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  517. $sql = "DELETE FROM $table_question WHERE gid='".$group_id."'";
  518. Database::query($sql,__FILE__,__LINE__);
  519. $sql = "DELETE FROM $table_survey_group WHERE group_id='".$group_id."'";
  520. Database::query($sql,__FILE__,__LINE__);
  521. }
  522. /**
  523. * Possible deprecated method
  524. */
  525. function ques_id_group_name($qid)
  526. {
  527. $ques_table=Database::get_course_table(TABLE_MAIN_SURVEYQUESTION);
  528. $sql="SELECT gid FROM $ques_table where qid=$qid";
  529. $res=Database::query($sql, __FILE__, __LINE__);
  530. $id=@Database::result($res,0,'gid');
  531. $gname=surveymanager::get_groupname($id);
  532. return($gname);
  533. }
  534. /**
  535. * Possible deprecated method
  536. */
  537. function insert_questions($sid,$newgid,$gid,$table_group)
  538. {
  539. $sql_select = "SELECT * FROM $table_group WHERE group_id IN (".$gid.")";
  540. $res = Database::query($sql_select, __FILE__, __LINE__);
  541. $num = Database::num_rows($res);
  542. $i=0;
  543. while($i<$num)
  544. {
  545. $sql_insert = "INSERT INTO $table_group(group_id, survey_id, groupname) values('', '$sid', 'Imported Group')";
  546. $result = Database::query($sql_insert, __FILE__, __LINE__);
  547. $i++;
  548. }
  549. }
  550. /**
  551. * Possible deprecated method
  552. */
  553. function select_group_list($survey_id, $seleced_groupid='', $extra_script='')
  554. {
  555. $group_table = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  556. $sql = "SELECT * FROM $group_table WHERE survey_id='$survey_id'";
  557. $sql_result = Database::query($sql,__FILE__,__LINE__);
  558. if(Database::num_rows($sql_result)>0)
  559. {
  560. $str_group_list = "";
  561. $str_group_list .= "<select name=\"exiztinggroup\" $extra_script>\n";
  562. while($result=Database::fetch_array($sql_result))
  563. {
  564. $selected = ($seleced_groupid==$result[group_id])?"selected":"";
  565. $str_group_list .= "\n<option value=\"".$result[group_id]."\" ".$selected.">".$result[groupname]."</option>\n";
  566. }
  567. $str_group_list .= "</select>";
  568. return $str_group_list;
  569. }
  570. else
  571. {
  572. return false;
  573. }
  574. }
  575. /**
  576. * Possible deprecated method
  577. */
  578. //For importing the groups to new survey
  579. function insert_groups($sid,$newgid,$gids,$table_group,$table_question)
  580. {
  581. $gid_arr = explode(",",$gids);
  582. $num = count($gid_arr);
  583. $queryone = "SELECT * FROM $table_question WHERE gid = '$newgid'";
  584. $rs = Database::query($queryone, __FILE__, __LINE__);
  585. $numrs=Database::num_rows($rs);
  586. for($k=0;$k<$numrs;$k++)
  587. {
  588. $imp[]=Database::result($rs,$k,"imported_group");
  589. }
  590. $imp=@array_unique($imp);
  591. for($n=0;$n<count($gid_arr);$n++)
  592. {
  593. if(@in_array($gid_arr[$n],$imp))
  594. {
  595. $gname=surveymanager::get_groupname($gid_arr[$n]);
  596. $alr[]=$gname;
  597. //$alr[]=$gid_arr[$n];
  598. //$unique_arr = @array_unique($alr);
  599. // print_r($unique_arr);
  600. }
  601. }
  602. //$unique_arr = @array_unique($alr);
  603. //print_r($unique_arr);
  604. /*if($msg)
  605. {
  606. echo "You have already imported the following group(s)";
  607. echo "<br>".$msg;
  608. }*/
  609. for($index=0;$index<$num;$index++)
  610. {
  611. if(@!in_array($gid_arr[$index],$imp))
  612. {
  613. $temp_gid = $gid_arr[$index];
  614. $sql = "SELECT * FROM $table_question WHERE gid = '$temp_gid'";
  615. $res = Database::query($sql, __FILE__, __LINE__);
  616. $num_rows = Database::num_rows($res);
  617. while($obj = Database::fetch_object($res))
  618. {
  619. $temp_qtype = $obj->qtype;
  620. $temp_caption = $obj->caption;
  621. $y="";
  622. $x="";
  623. for($i=1;$i<=10;$i++)
  624. {
  625. $temp = "a".$i;
  626. $x.= "'".$obj->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
  627. }
  628. for($j=1;$j<=10;$j++)
  629. {
  630. if($j==10)
  631. {
  632. $temps = "r".$j;
  633. $y.= "'".$obj->$temps."'";
  634. }
  635. else
  636. {
  637. $temps = "r".$j;
  638. $y.= "'".$obj->$temps."',";
  639. }
  640. }
  641. $sql_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$newgid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$temp_gid')";
  642. $res2 = Database::query($sql_insert, __FILE__, __LINE__);
  643. }
  644. }
  645. }
  646. }
  647. /**
  648. * Possible deprecated method
  649. */
  650. function display_imported_group($sid,$table_group,$table_question)
  651. {
  652. $sql = "SELECT group_id FROM $table_group WHERE survey_id='$sid'";
  653. $res = Database::query($sql, __FILE__, __LINE__);
  654. $num = @Database::num_rows($res);
  655. //echo "ths is num".$num;
  656. $parameters = array();
  657. $displays = array();
  658. while($obj = @Database::fetch_object($res))
  659. {
  660. $groupid = $obj->group_id;
  661. $query = "SELECT * FROM $table_question WHERE gid = '$groupid'";
  662. $result = Database::query($query, __FILE__, __LINE__);
  663. while($object = @Database::fetch_object($result))
  664. {
  665. $display = array();
  666. $display[] = '<input type="checkbox" name="course[]" value="'.$object->qid.'"/>';
  667. $display[] = $object->caption;
  668. $display[] = $object->qtype;
  669. $id = $object->gid;
  670. //echo "THIS IS GROUP NAME ID".$id;
  671. $gname = surveymanager::get_groupname($id);
  672. $display[] = $gname;
  673. $displays[] = $display;
  674. }
  675. }
  676. $table_header[] = array('', false);
  677. $table_header[] = array(get_lang('Question'), true);
  678. $table_header[] = array(get_lang('QuestionType'), true);
  679. $table_header[] = array(get_lang('Group'), true);
  680. Display :: display_sortable_table($table_header, $displays, array (), array (), $parameters);
  681. }
  682. /**
  683. * Possible deprecated method
  684. */
  685. function attach_survey($surveyid,$newsurveyid,$db_name,$curr_dbname)
  686. //For attaching the whole survey with its groups and questions
  687. {
  688. $sql = "SELECT * FROM $db_name.survey_group WHERE survey_id = '$surveyid'";
  689. $res = Database::query($sql,__FILE__,__LINE__);
  690. while($obj=@Database::fetch_object($res))
  691. {
  692. $groupname=addslashes($obj->groupname);
  693. $introduction=addslashes($obj->introduction);
  694. $sql_insert = "INSERT INTO $curr_dbname.survey_group(group_id,survey_id,groupname,introduction) values('','$newsurveyid','$groupname','$introduction')";
  695. $resnext = Database::query($sql_insert,__FILE__,__LINE__);
  696. $groupid = Database::insert_id();
  697. $sql_q = "SELECT * FROM $db_name.questions WHERE gid = '$obj->group_id'";
  698. $res_q = Database::query($sql_q,__FILE__,__LINE__);
  699. while($obj_q = Database::fetch_object($res_q))
  700. {
  701. $caption1=addslashes($obj_q->caption);
  702. $a1=addslashes($obj_q->a1);
  703. $a2=addslashes($obj_q->a2);
  704. $a3=addslashes($obj_q->a3);
  705. $a4=addslashes($obj_q->a4);
  706. $a5=addslashes($obj_q->a5);
  707. $a6=addslashes($obj_q->a6);
  708. $a7=addslashes($obj_q->a7);
  709. $a8=addslashes($obj_q->a8);
  710. $a9=addslashes($obj_q->a9);
  711. $a10=addslashes($obj_q->a10);
  712. $at=addslashes($obj_q->at);
  713. $ad=addslashes($obj_q->ad);
  714. $r1=addslashes($obj_q->r1);
  715. $r2=addslashes($obj_q->r2);
  716. $r3=addslashes($obj_q->r3);
  717. $r4=addslashes($obj_q->r4);
  718. $r5=addslashes($obj_q->r5);
  719. $r6=addslashes($obj_q->r6);
  720. $r7=addslashes($obj_q->r7);
  721. $r8=addslashes($obj_q->r8);
  722. $r9=addslashes($obj_q->r9);
  723. $r10=addslashes($obj_q->r10);
  724. $sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
  725. $res_sort=Database::query($sql_sort, __FILE__, __LINE__);
  726. $rs=Database::fetch_object($res_sort);
  727. $sortby=$rs->sortby;
  728. if(empty($sortby))
  729. {$sortby=1;}
  730. else{$sortby=$sortby+1;}
  731. $sql_q_insert = "INSERT INTO $curr_dbname.questions (qid,gid,survey_id,qtype,caption,alignment,sortby,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$groupid','$newsurveyid','$obj_q->qtype','$caption1','$obj_q->alignment','$sortby','$a1','$a2','$a3','$a4','$a5','$a6','$a7','$a8','$a9','$a10','$at','$ad','$r1','$r2','$r3','$r4','$r5','$r6','$r7','$r8','$r9','$r10')";
  732. Database::query($sql_q_insert,__FILE__,__LINE__);
  733. }
  734. }
  735. }
  736. /**
  737. * Possible deprecated method
  738. */
  739. function update_group($groupid,$surveyid,$groupnamme,$introduction,$curr_dbname)
  740. {
  741. $sql = "UPDATE $curr_dbname.survey_group SET group_id='$groupid', survey_id='$surveyid', groupname='$groupnamme', introduction='$introduction' WHERE group_id='$groupid'";
  742. Database::query($sql, __FILE__, __LINE__);
  743. }
  744. /*
  745. function insert_old_groups($sid,$gids,$table_group,$table_question)
  746. {
  747. $gid_arr = explode(",",$gids);
  748. $index = count($gid_arr);
  749. ($gid_arr);
  750. for($p=0;$p<$index;$p++)
  751. {
  752. $sql = "SELECT * FROM $table_group WHERE group_id = '$gid_arr[$p]'";
  753. $res = Database::query($sql, __FILE__, __LINE__);
  754. $obj = Database::fetch_object($res);
  755. $gname = $obj->groupname;
  756. if($gname=='Default')
  757. {
  758. $query = "SELECT * FROM $table_group WHERE survey_id = '$sid' AND groupname = 'Default'";
  759. $result = Database::query($query, __FILE__, __LINE__);
  760. $object = Database::fetch_object($result);
  761. $gid = $object->group_id;
  762. $sql_def_check = "SELECT * FROM $table_question WHERE gid = '$gid'";
  763. $res_def_check = Database::query($sql_def_check, __FILE__, __LINE__);
  764. $count_def_check = Database::num_rows($res_def_check);
  765. for($ctr=0;$ctr<$count_def_check;$ctr++)
  766. {
  767. $imp[]=Database::result($res_def_check,$ctr,"imported_group");
  768. }
  769. $imp = @array_unique($imp);
  770. if(!@in_array($gid_arr[$p],$imp))
  771. {
  772. $sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
  773. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  774. $num = Database::num_rows($res_ques);
  775. while($obj_ques = Database::fetch_object($res_ques))
  776. {
  777. $temp_qtype = $obj_ques->qtype;
  778. $temp_caption = $obj_ques->caption;
  779. $anst = $obj_ques->at;
  780. $ansd = $obj_ques->ad;
  781. $y="";
  782. $x="";
  783. for($i=1;$i<=10;$i++)
  784. {
  785. $temp = "a".$i;
  786. $x.= "'".$obj_ques->$temp."',";
  787. }
  788. for($j=1;$j<=10;$j++)
  789. {
  790. if($j==10)
  791. {
  792. $temps = "r".$j;
  793. $y.= "'".$obj_ques->$temps."'";
  794. }
  795. else
  796. {
  797. $temps = "r".$j;
  798. $y.= "'".$obj_ques->$temps."',";
  799. }
  800. }
  801. $sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  802. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  803. }
  804. }
  805. else
  806. {
  807. $flag = 1;
  808. }
  809. }
  810. else
  811. {
  812. $intro = $obj->introduction;
  813. $sql_check = "SELECT * FROM $table_group WHERE survey_id = '$sid'";
  814. $res_check = Database::query($sql_check, __FILE__, __LINE__);
  815. $num_check = Database::num_rows($res_check);
  816. for($k=0;$k<$num_check;$k++)
  817. {
  818. $imp[]=Database::result($res_check,$k,"imported_group");
  819. }
  820. $imp = @array_unique($imp);
  821. if(!@in_array($gid_arr[$p],$imp))
  822. {
  823. $sql_insert = "INSERT INTO $table_group(group_id,survey_id,groupname,introduction,imported_group) values('','$sid','$gname','$intro','$gid_arr[$p]')";
  824. $res_insert = Database::query($sql_insert, __FILE__, __LINE__);
  825. $new_gid = Database::insert_id();
  826. $sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
  827. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  828. $num = Database::num_rows($res_ques);
  829. while($obj_ques = Database::fetch_object($res_ques))
  830. {
  831. $temp_qtype = $obj_ques->qtype;
  832. $temp_caption = $obj_ques->caption;
  833. $anst = $obj_ques->at;
  834. $ansd = $obj_ques->ad;
  835. $y="";
  836. $x="";
  837. for($i=1;$i<=10;$i++)
  838. {
  839. $temp = "a".$i;
  840. $x.= "'".$obj_ques->$temp."',";
  841. }
  842. for($j=1;$j<=10;$j++)
  843. {
  844. if($j==10)
  845. {
  846. $temps = "r".$j;
  847. $y.= "'".$obj_ques->$temps."'";
  848. }
  849. else
  850. {
  851. $temps = "r".$j;
  852. $y.= "'".$obj_ques->$temps."',";
  853. }
  854. }
  855. $sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$new_gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  856. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  857. }
  858. }
  859. else
  860. {
  861. $flag = 1;
  862. }
  863. }
  864. }
  865. return ($flag);
  866. }
  867. */
  868. /**
  869. * Possible deprecated method
  870. */
  871. function insert_old_groups($sid,$gids,$table_group,$table_question,$db_name,$cidReq)
  872. {
  873. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  874. $sql = "SELECT * FROM $table_course WHERE code = '$cidReq'";
  875. $res = Database::query($sql,__FILE__,__LINE__);
  876. $obj_name=@Database::fetch_object($res);
  877. $current_db_name = $obj_name->db_name ;
  878. $gid_arr = explode(",",$gids);
  879. $index = count($gid_arr);
  880. ($gid_arr);
  881. for($p=0;$p<$index;$p++)
  882. {
  883. $sql = "SELECT * FROM $db_name.survey_group WHERE group_id = '$gid_arr[$p]'";
  884. $res = Database::query($sql, __FILE__, __LINE__);
  885. $obj = Database::fetch_object($res);
  886. $gname = $obj->groupname;
  887. if($gname=='No Group')
  888. {
  889. $query = "SELECT * FROM $db_name.survey_group WHERE survey_id = '$sid' AND groupname = 'No Group'";
  890. $result = Database::query($query, __FILE__, __LINE__);
  891. $object = Database::fetch_object($result);
  892. $gid = $object->group_id;
  893. $sql_def_check = "SELECT * FROM $db_name.questions WHERE gid = '$gid'";
  894. $res_def_check = Database::query($sql_def_check, __FILE__, __LINE__);
  895. $count_def_check = Database::num_rows($res_def_check);
  896. for($ctr=0;$ctr<$count_def_check;$ctr++)
  897. {
  898. $imp[]=Database::result($res_def_check,$ctr,"imported_group");
  899. }
  900. $imp = @array_unique($imp);
  901. $gid_arr[$p];
  902. if(!@in_array($gid_arr[$p],$imp))
  903. {
  904. $sql_ques = "SELECT * FROM $db_name.questions WHERE gid= '$gid_arr[$p]'";
  905. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  906. $num = Database::num_rows($res_ques);
  907. while($obj_ques = Database::fetch_object($res_ques))
  908. {
  909. $temp_qtype = $obj_ques->qtype;
  910. $temp_caption = $obj_ques->caption;
  911. $anst = $obj_ques->at;
  912. $ansd = $obj_ques->ad;
  913. $y="";
  914. $x="";
  915. for($i=1;$i<=10;$i++)
  916. {
  917. $temp = "a".$i;
  918. $x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
  919. }
  920. for($j=1;$j<=10;$j++)
  921. {
  922. if($j==10)
  923. {
  924. $temps = "r".$j;
  925. $y.= "'".$obj_ques->$temps."'";
  926. }
  927. else
  928. {
  929. $temps = "r".$j;
  930. $y.= "'".$obj_ques->$temps."',";
  931. }
  932. }
  933. $sql_ques_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  934. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  935. }
  936. }
  937. else
  938. {
  939. $flag = 1;
  940. }
  941. }
  942. else
  943. {
  944. $intro = $obj->introduction;
  945. $sql_check = "SELECT * FROM $db_name.survey_group WHERE survey_id = '$sid'";
  946. $res_check = Database::query($sql_check, __FILE__, __LINE__);
  947. $num_check = Database::num_rows($res_check);
  948. for($k=0;$k<$num_check;$k++)
  949. {
  950. $imp[]=Database::result($res_check,$k,"imported_group");
  951. }
  952. $imp = @array_unique($imp);
  953. if(!@in_array($gid_arr[$p],$imp))
  954. {
  955. $sql_insert = "INSERT INTO $current_db_name.survey_group(group_id,survey_id,groupname,introduction,imported_group) values('','$sid','$gname','$intro','$gid_arr[$p]')";
  956. $res_insert = Database::query($sql_insert, __FILE__, __LINE__);
  957. $new_gid = Database::insert_id();
  958. $sql_ques = "SELECT * FROM $db_name.questions WHERE gid= '$gid_arr[$p]'";
  959. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  960. $num = Database::num_rows($res_ques);
  961. while($obj_ques = Database::fetch_object($res_ques))
  962. {
  963. $temp_qtype = $obj_ques->qtype;
  964. $temp_caption = $obj_ques->caption;
  965. $anst = $obj_ques->at;
  966. $ansd = $obj_ques->ad;
  967. $y="";
  968. $x="";
  969. for($i=1;$i<=10;$i++)
  970. {
  971. $temp = "a".$i;
  972. $x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
  973. }
  974. for($j=1;$j<=10;$j++)
  975. {
  976. if($j==10)
  977. {
  978. $temps = "r".$j;
  979. $y.= "'".$obj_ques->$temps."'";
  980. }
  981. else
  982. {
  983. $temps = "r".$j;
  984. $y.= "'".$obj_ques->$temps."',";
  985. }
  986. }
  987. $sql_ques_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$new_gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  988. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  989. }
  990. }
  991. else
  992. {
  993. $flag = 1;
  994. }
  995. }
  996. }
  997. return ($flag);
  998. }
  999. /**
  1000. * Possible deprecated method
  1001. */
  1002. function import_question($surveyid,$qids,$table_group,$table_question,$db_name,$cidReq,$yes)
  1003. {
  1004. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  1005. $sql_course = "SELECT * FROM $table_course WHERE code = '$cidReq'";
  1006. $res_course = Database::query($sql_course,__FILE__,__LINE__);
  1007. $obj_name=@Database::fetch_object($res_course);
  1008. $current_db_name = $obj_name->db_name ;
  1009. $qid=explode(",",$qids);
  1010. $count = count($qid);
  1011. for($i=0; $i<$count; $i++)
  1012. {
  1013. $sql_q = "SELECT * FROM $table_question WHERE qid = '$qid[$i]'";
  1014. $res_q = Database::query($sql_q,__FILE__,__LINE__);
  1015. $obj=@Database::fetch_object($res_q);
  1016. $oldgid=$obj->gid;
  1017. $sql = "SELECT * FROM $table_group WHERE group_id = '$oldgid'";
  1018. $res = Database::query($sql,__FILE__,__LINE__);
  1019. $obj_gr = @Database::fetch_object($res);
  1020. $gname = $obj_gr->groupname;
  1021. $gintro = $obj_gr->introduction;
  1022. $sql_gid = "SELECT * FROM $table_group WHERE survey_id = '$surveyid' AND groupname = '$gname'";
  1023. $res_gid = Database::query($sql_gid,__FILE__,__LINE__);
  1024. $num=Database::num_rows($res_gid);
  1025. $obj_gid=@Database::fetch_object($res_gid);
  1026. $sql_quesid = "SELECT * FROM $table_question WHERE gid = '$obj_gid->group_id' AND caption = '$obj->caption'";
  1027. $res_quesid = Database::query($sql_quesid,__FILE__,__LINE__);
  1028. $num_ques=Database::num_rows($res_quesid);
  1029. if($num_ques>0)
  1030. {
  1031. $message=1;
  1032. //echo "<div align=\"center\"><strong><font color=\"#FF0000\">Already Imported !</font></strong></div>" ;
  1033. }
  1034. else
  1035. {
  1036. if($num>0 && $yes=="yes")
  1037. {
  1038. $sql_q_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$obj_gid->group_id','$obj->qtype','$obj->caption','$obj->a1','$obj->a2','$obj->a3','$obj->a4','$obj->a5','$obj->a6','$obj->a7','$obj->a8','$obj->a9','$obj->a10','$obj->at','$obj->ad','$obj->r1','$obj->r2','$obj->r3','$obj->r4','$obj->r5','$obj->r6','$obj->r7','$obj->r8','$obj->r9','$obj->r10')";
  1039. Database::query($sql_q_insert,__FILE__,__LINE__);
  1040. }
  1041. else
  1042. {
  1043. $sql_ginsert="INSERT INTO $current_db_name.survey_group(group_id,survey_id,groupname,introduction) values('','$surveyid','$gname','$gintro')";
  1044. Database::query($sql_ginsert,__FILE__,__LINE__);
  1045. $new_gid = Database::insert_id();
  1046. $sql_q_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$new_gid','$obj->qtype','$obj->caption','$obj->a1','$obj->a2','$obj->a3','$obj->a4','$obj->a5','$obj->a6','$obj->a7','$obj->a8','$obj->a9','$obj->a10','$obj->at','$obj->ad','$obj->r1','$obj->r2','$obj->r3','$obj->r4','$obj->r5','$obj->r6','$obj->r7','$obj->r8','$obj->r9','$obj->r10')";
  1047. Database::query($sql_q_insert,__FILE__,__LINE__);
  1048. }
  1049. }
  1050. }
  1051. return $message;
  1052. }
  1053. /**
  1054. * Possible deprecated method
  1055. */
  1056. function create_course_survey_rel($cidReq,$survey_id,$table_course,$table_course_survey_rel)
  1057. {
  1058. $sql = "SELECT * FROM $table_course WHERE code = '$cidReq'";
  1059. $res = Database::query($sql,__FILE__,__LINE__);
  1060. $obj=@Database::fetch_object($res);
  1061. $db_name = $obj->db_name ;
  1062. $sql="INSERT INTO $table_course_survey_rel(id,course_code,db_name,survey_id) values('','$cidReq','$db_name','$survey_id')";
  1063. Database::query($sql,__FILE__,__LINE__);
  1064. return $db_name;
  1065. }
  1066. /**
  1067. * Possible deprecated method
  1068. */
  1069. function import_existing_question($surveyid,$qids,$table_group,$table_question,$yes)
  1070. {
  1071. $qid=explode(",",$qids);
  1072. $count = count($qid);
  1073. for($i=0; $i<$count; $i++)
  1074. {
  1075. $sql_q = "SELECT * FROM $table_question WHERE qid = '$qid[$i]'";
  1076. $res_q = Database::query($sql_q,__FILE__,__LINE__);
  1077. $obj=@Database::fetch_object($res_q);
  1078. $oldgid=$obj->gid;
  1079. $sql = "SELECT * FROM $table_group WHERE group_id = '$oldgid'";
  1080. $res = Database::query($sql,__FILE__,__LINE__);
  1081. $obj_gr = @Database::fetch_object($res);
  1082. $gname = $obj_gr->groupname;
  1083. $gintro = $obj_gr->introduction;
  1084. $sql_gid = "SELECT * FROM $table_group WHERE survey_id = '$surveyid' AND groupname = '$gname'";
  1085. $res_gid = Database::query($sql_gid,__FILE__,__LINE__);
  1086. $num=Database::num_rows($res_gid);
  1087. $obj_gid=@Database::fetch_object($res_gid);
  1088. $sql_quesid = "SELECT * FROM $table_question WHERE gid = '$obj_gid->group_id' AND caption = '$obj->caption'";
  1089. $res_quesid = Database::query($sql_quesid,__FILE__,__LINE__);
  1090. $num_ques=Database::num_rows($res_quesid);
  1091. if($num_ques>0)
  1092. {
  1093. $message=1;
  1094. //echo "<div align=\"center\"><strong><font color=\"#FF0000\">Already Imported !</font></strong></div>" ;
  1095. }
  1096. else
  1097. {
  1098. if($num>0 && $yes=="yes")
  1099. {
  1100. $sql_q_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$obj_gid->group_id','$obj->qtype','$obj->caption','$obj->a1','$obj->a2','$obj->a3','$obj->a4','$obj->a5','$obj->a6','$obj->a7','$obj->a8','$obj->a9','$obj->a10','$obj->at','$obj->ad','$obj->r1','$obj->r2','$obj->r3','$obj->r4','$obj->r5','$obj->r6','$obj->r7','$obj->r8','$obj->r9','$obj->r10')";
  1101. Database::query($sql_q_insert,__FILE__,__LINE__);
  1102. }
  1103. else
  1104. {
  1105. $sql_ginsert="INSERT INTO $table_group(group_id,survey_id,groupname,introduction) values('','$surveyid','$gname','$gintro')";
  1106. Database::query($sql_ginsert,__FILE__,__LINE__);
  1107. $new_gid = Database::insert_id();
  1108. $sql_q_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$new_gid','$obj->qtype','$obj->caption','$obj->a1','$obj->a2','$obj->a3','$obj->a4','$obj->a5','$obj->a6','$obj->a7','$obj->a8','$obj->a9','$obj->a10','$obj->at','$obj->ad','$obj->r1','$obj->r2','$obj->r3','$obj->r4','$obj->r5','$obj->r6','$obj->r7','$obj->r8','$obj->r9','$obj->r10')";
  1109. Database::query($sql_q_insert,__FILE__,__LINE__);
  1110. }
  1111. }
  1112. }
  1113. return $message;
  1114. }
  1115. /**
  1116. * Possible deprecated method
  1117. */
  1118. function insert_existing_groups ($sid,$gids,$table_group,$table_question)
  1119. {
  1120. $gid_arr = explode(",",$gids);
  1121. $index = count($gid_arr);
  1122. ($gid_arr);
  1123. for($p=0;$p<$index;$p++)
  1124. {
  1125. $sql = "SELECT * FROM $table_group WHERE group_id = '$gid_arr[$p]'";
  1126. $res = Database::query($sql, __FILE__, __LINE__);
  1127. $obj = Database::fetch_object($res);
  1128. $gname = $obj->groupname;
  1129. if($gname=='No Group')
  1130. {
  1131. $query = "SELECT * FROM $table_group WHERE survey_id = '$sid' AND groupname = 'No Group'";
  1132. $result = Database::query($query, __FILE__, __LINE__);
  1133. $object = Database::fetch_object($result);
  1134. $gid = $object->group_id;
  1135. $sql_def_check = "SELECT * FROM $table_question WHERE gid = '$gid'";
  1136. $res_def_check = Database::query($sql_def_check, __FILE__, __LINE__);
  1137. $count_def_check = Database::num_rows($res_def_check);
  1138. for($ctr=0;$ctr<$count_def_check;$ctr++)
  1139. {
  1140. $imp[]=Database::result($res_def_check,$ctr,"imported_group");
  1141. }
  1142. $imp = @array_unique($imp);
  1143. if(!@in_array($gid_arr[$p],$imp))
  1144. {
  1145. $sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
  1146. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  1147. $num = Database::num_rows($res_ques);
  1148. while($obj_ques = Database::fetch_object($res_ques))
  1149. {
  1150. $temp_qtype = $obj_ques->qtype;
  1151. $temp_caption = $obj_ques->caption;
  1152. $anst = $obj_ques->at;
  1153. $ansd = $obj_ques->ad;
  1154. $y="";
  1155. $x="";
  1156. for($i=1;$i<=10;$i++)
  1157. {
  1158. $temp = "a".$i;
  1159. $x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
  1160. }
  1161. for($j=1;$j<=10;$j++)
  1162. {
  1163. if($j==10)
  1164. {
  1165. $temps = "r".$j;
  1166. $y.= "'".$obj_ques->$temps."'";
  1167. }
  1168. else
  1169. {
  1170. $temps = "r".$j;
  1171. $y.= "'".$obj_ques->$temps."',";
  1172. }
  1173. }
  1174. $sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  1175. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  1176. }
  1177. }
  1178. else
  1179. {
  1180. $flag = 1;
  1181. }
  1182. }
  1183. else
  1184. {
  1185. $intro = $obj->introduction;
  1186. $sql_check = "SELECT * FROM $table_group WHERE survey_id = '$sid'";
  1187. $res_check = Database::query($sql_check, __FILE__, __LINE__);
  1188. $num_check = Database::num_rows($res_check);
  1189. for($k=0;$k<$num_check;$k++)
  1190. {
  1191. $imp[]=Database::result($res_check,$k,"imported_group");
  1192. }
  1193. $imp = @array_unique($imp);
  1194. if(!@in_array($gid_arr[$p],$imp))
  1195. {
  1196. $sql_insert = "INSERT INTO $table_group(group_id,survey_id,groupname,introduction,imported_group) values('','$sid','$gname','$intro','$gid_arr[$p]')";
  1197. $res_insert = Database::query($sql_insert, __FILE__, __LINE__);
  1198. $new_gid = Database::insert_id();
  1199. $sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
  1200. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  1201. $num = Database::num_rows($res_ques);
  1202. while($obj_ques = Database::fetch_object($res_ques))
  1203. {
  1204. $temp_qtype = $obj_ques->qtype;
  1205. $temp_caption = $obj_ques->caption;
  1206. $anst = $obj_ques->at;
  1207. $ansd = $obj_ques->ad;
  1208. $y="";
  1209. $x="";
  1210. for($i=1;$i<=10;$i++)
  1211. {
  1212. $temp = "a".$i;
  1213. $x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
  1214. }
  1215. for($j=1;$j<=10;$j++)
  1216. {
  1217. if($j==10)
  1218. {
  1219. $temps = "r".$j;
  1220. $y.= "'".$obj_ques->$temps."'";
  1221. }
  1222. else
  1223. {
  1224. $temps = "r".$j;
  1225. $y.= "'".$obj_ques->$temps."',";
  1226. }
  1227. }
  1228. $sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$new_gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
  1229. $res_ques_insert = Database::query($sql_ques_insert, __FILE__, __LINE__);
  1230. }
  1231. }
  1232. else
  1233. {
  1234. $flag = 1;
  1235. }
  1236. }
  1237. }
  1238. return ($flag);
  1239. }
  1240. /**
  1241. * Possible deprecated method
  1242. */
  1243. function pick_surveyname($sid)
  1244. {
  1245. $surveytable=Database:: get_course_table(TABLE_SURVEY);
  1246. $sql="SELECT * FROM $surveytable WHERE survey_id=$sid";
  1247. $res=Database::query($sql, __FILE__, __LINE__);
  1248. $code=@Database::result($res,0,'title');
  1249. return($code);
  1250. }
  1251. /**
  1252. * Possible deprecated method
  1253. */
  1254. function pick_author($survey_id)
  1255. {
  1256. $survey_table = Database :: get_course_table(TABLE_SURVEY);
  1257. $sql = "SELECT author FROM $survey_table WHERE survey_id='$survey_id'";
  1258. $res = Database::query($sql, __FILE__, __LINE__);
  1259. $author=@Database::result($res,0,'author');
  1260. return $author;
  1261. }
  1262. /**
  1263. * Possible deprecated method
  1264. */
  1265. function question_import($surveyid,$qids,$db_name,$curr_dbname)
  1266. {
  1267. $qid=explode(",",$qids);
  1268. $count = count($qid);
  1269. for($i=0; $i<$count; $i++)
  1270. {
  1271. $sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
  1272. $res_sort=Database::query($sql_sort, __FILE__, __LINE__);
  1273. $rs=Database::fetch_object($res_sort);
  1274. $sortby=$rs->sortby;
  1275. if(empty($sortby))
  1276. {$sortby=1;}
  1277. else{$sortby=$sortby+1;}
  1278. $sql_q = "SELECT * FROM $db_name.questions WHERE qid = '$qid[$i]'";
  1279. $res_q = Database::query($sql_q,__FILE__,__LINE__);
  1280. $obj=@Database::fetch_object($res_q);
  1281. $oldgid=$obj->gid;
  1282. $caption1=addslashes($obj->caption);
  1283. $a1=addslashes($obj->a1);
  1284. $a2=addslashes($obj->a2);
  1285. $a3=addslashes($obj->a3);
  1286. $a4=addslashes($obj->a4);
  1287. $a5=addslashes($obj->a5);
  1288. $a6=addslashes($obj->a6);
  1289. $a7=addslashes($obj->a7);
  1290. $a8=addslashes($obj->a8);
  1291. $a9=addslashes($obj->a9);
  1292. $a10=addslashes($obj->a10);
  1293. $at=addslashes($obj->at);
  1294. $ad=addslashes($obj->ad);
  1295. $r1=addslashes($obj->r1);
  1296. $r2=addslashes($obj->r2);
  1297. $r3=addslashes($obj->r3);
  1298. $r4=addslashes($obj->r4);
  1299. $r5=addslashes($obj->r5);
  1300. $r6=addslashes($obj->r6);
  1301. $r7=addslashes($obj->r7);
  1302. $r8=addslashes($obj->r8);
  1303. $r9=addslashes($obj->r9);
  1304. $r10=addslashes($obj_q->r10);
  1305. //$sql_gr = "SELECT * FROM $db_name.survey_group WHERE group_id = '$oldgid'";
  1306. //$res_gr = Database::query($sql_gr,__FILE__,__LINE__);
  1307. // $obj_gr=@Database::fetch_object($res_gr);
  1308. //$groupname = $obj_gr->groupname
  1309. $sql_quesid = "SELECT * FROM $curr_dbname.questions WHERE survey_id = '$surveyid' AND imported_question = '$qid[$i]' AND db_name = '$db_name'";
  1310. $res_quesid = Database::query($sql_quesid,__FILE__,__LINE__);
  1311. $num_ques=Database::num_rows($res_quesid);
  1312. if($num_ques>0)
  1313. {
  1314. $message=1;
  1315. }
  1316. else
  1317. {
  1318. $sql_group = "SELECT * FROM $db_name.survey_group WHERE group_id = '$oldgid'";
  1319. $res_group = Database::query($sql_group,__FILE__,__LINE__);
  1320. $obj_group=@Database::fetch_object($res_group);
  1321. $groupname = $obj_group->groupname;
  1322. $sql = "SELECT * FROM $curr_dbname.survey_group WHERE groupname = '$groupname' AND survey_id = '$surveyid'";
  1323. $res = Database::query($sql,__FILE__,__LINE__);
  1324. $obj_gro = Database::fetch_object($res);
  1325. $num_group=Database::num_rows($res);
  1326. if($num_group>0)
  1327. {
  1328. $sql_q_insert = "INSERT INTO $curr_dbname.questions (qid,gid,survey_id,qtype,caption,alignment,sortby,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_question,db_name) values('','$obj_gro->group_id','$surveyid','$obj->qtype','$caption1','$obj->alignment','$sortby','$a1','$a2','$a3','$a4','$a5','$a6','$a7','$a8','$a9','$a10','$at','$ad','$r1','$r2','$r3','$r4','$r5','$r6','$r7','$r8','$r9','$r10','$qid[$i]','$db_name')";
  1329. Database::query($sql_q_insert,__FILE__,__LINE__);
  1330. }
  1331. else
  1332. {
  1333. //$num_group;
  1334. $sql_ginsert="INSERT INTO $curr_dbname.survey_group(group_id,survey_id,groupname,introduction,imported_group, db_name) values('','$surveyid','$groupname','$obj_group->introduction','$oldgid','$db_name')";
  1335. Database::query($sql_ginsert,__FILE__,__LINE__);
  1336. $new_gid = Database::insert_id();
  1337. $sql_q_insert = "INSERT INTO $curr_dbname.questions (qid,gid,survey_id,qtype,caption,alignment,sortby,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_question,db_name) values('','$new_gid','$surveyid','$obj->qtype','$caption1','$obj->alignment','$sortby','$a1','$a2','$a3','$a4','$a5','$a6','$a7','$a8','$a9','$a10','$at','$ad','$r1','$r2','$r3','$r4','$r5','$r6','$r7','$r8','$r9','$r10','$qid[$i]','$db_name')";
  1338. Database::query($sql_q_insert,__FILE__,__LINE__);
  1339. }
  1340. }
  1341. }
  1342. return $message;
  1343. }
  1344. /*
  1345. function import_group($surveyid,$gids,$db_name,$curr_dbname)
  1346. {
  1347. $gid_arr = explode(",",$gids);
  1348. $index = count($gid_arr);
  1349. for($i=0;$i<$index;$i++)
  1350. {
  1351. $sql = "SELECT * FROM $db_name.survey_group WHERE group_id = '$gid_arr[$i]'";
  1352. $res = Database::query($sql,__FILE__,__LINE__);
  1353. $obj = Database::fetch_object($res);
  1354. $sql_ques = "SELECT * FROM $db_name.questions WHERE gid = '$gid_arr[$i]'";
  1355. $res_ques = Database::query($sql_ques,__FILE__,__LINE__);
  1356. $obj_ques = Database::fetch_object($res_ques);
  1357. $sql_check = "SELECT * FROM $curr_dbname.survey_group WHERE survey_id = '$surveyid' AND imported_group = '$gid_arr[$i]' AND db_name = '$db_name'";
  1358. $res_check = Database::query($sql_check, __FILE__, __LINE__);
  1359. $obj_check = Database::fetch_object($res_check);
  1360. $num = Database::num_rows($res_check);
  1361. if($num>0)
  1362. {
  1363. $sql_question = "SELECT * FROM $curr_dbname.questions WHERE survey_id='$surveyid' AND imported_question = '$obj_ques->qid' AND db_name = '$db_name'";
  1364. $res_question = Database::query($sql_question,__FILE__,__LINE__);
  1365. $num_ques = Database::num_rows($res_question);
  1366. if($num_ques>0)
  1367. {
  1368. $message=1;
  1369. }
  1370. else
  1371. {
  1372. $sql_insert_ques = "INSERT INTO $curr_dbname.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_question,db_name) values('','$obj_check->group_id','$surveyid','$obj_ques->qtype','$obj_ques->caption','$obj_ques->a1','$obj_ques->a2','$obj_ques->a3','$obj_ques->a4','$obj_ques->a5','$obj_ques->a6','$obj_ques->a7','$obj_ques->a8','$obj_ques->a9','$obj_ques->a10','$obj_ques->at','$obj_ques->ad','$obj_ques->r1','$obj_ques->r2','$obj_ques->r3','$obj_ques->r4','$obj_ques->r5','$obj_ques->r6','$obj_ques->r7','$obj_ques->r8','$obj_ques->r9','$obj_ques->r10','$obj_ques->qid','$db_name')";
  1373. Database::query($sql_insert_ques, __FILE__, __LINE__);
  1374. }
  1375. }
  1376. else
  1377. {
  1378. $insert_group = "INSERT INTO $curr_dbname.survey_group (group_id,survey_id,groupname,introduction,imported_group,db_name) values('','$surveyid','$obj->groupname','$obj->introduction','$obj->group_id','$db_name')";
  1379. $res_insert_group=Database::query($insert_group, __FILE__, __LINE__);
  1380. $new_gid = Database::insert_id();
  1381. $sql_insert_grp = "INSERT INTO $curr_dbname.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_question,db_name) values('','$new_gid','$surveyid','$obj_ques->qtype','$obj_ques->caption','$obj_ques->a1','$obj_ques->a2','$obj_ques->a3','$obj_ques->a4','$obj_ques->a5','$obj_ques->a6','$obj_ques->a7','$obj_ques->a8','$obj_ques->a9','$obj_ques->a10','$obj_ques->at','$obj_ques->ad','$obj_ques->r1','$obj_ques->r2','$obj_ques->r3','$obj_ques->r4','$obj_ques->r5','$obj_ques->r6','$obj_ques->r7','$obj_ques->r8','$obj_ques->r9','$obj_ques->r10','$obj_ques->qid','$db_name')";
  1382. Database::query($sql_insert_grp, __FILE__, __LINE__);
  1383. }
  1384. }
  1385. return $message;
  1386. }
  1387. */
  1388. /**
  1389. * Possible deprecated method
  1390. */
  1391. function import_group($sid,$gids,$db_name,$curr_dbname)
  1392. {
  1393. $gid_arr = explode(",",$gids);
  1394. $index = count($gid_arr);
  1395. for($i=0;$i<$index;$i++)
  1396. {
  1397. $sql = "SELECT * FROM $db_name.survey_group WHERE group_id = '$gid_arr[$i]'";
  1398. $res = Database::query($sql, __FILE__, __LINE__);
  1399. $obj = Database::fetch_object($res);
  1400. $groupname=addslashes($obj->groupname);
  1401. $introduction=addslashes($obj->introduction);
  1402. $g_sortby = intval($obj->sortby);
  1403. $sql_curr = "SELECT * FROM $curr_dbname.survey_group WHERE survey_id = '$sid' AND groupname = '$obj->groupname'";
  1404. $res_curr = Database::query($sql_curr, __FILE__, __LINE__);
  1405. $obj_curr = Database::fetch_object($res_curr);
  1406. $gid = $obj_curr->group_id;
  1407. $num = Database::num_rows($res_curr);
  1408. if($num>0) //the group name exists and the questions will be imported in this group.
  1409. {
  1410. $sql_ques = "SELECT * FROM $curr_dbname.questions WHERE gid = '$gid'";
  1411. $res_ques = Database::query($sql_ques, __FILE__, __LINE__);
  1412. $obj_ques = Database::fetch_object($res_ques);
  1413. $count = Database::num_rows($res_ques);
  1414. for($j=0;$j<$count;$j++)
  1415. {
  1416. $check_qid[] = Database::result($res_ques,$j,"imported_question");
  1417. $check_db[] = Database::result($res_ques,$j,"db_name");
  1418. }
  1419. $check_qid = @array_unique($check_qid);
  1420. $check_db = @array_unique($check_db);
  1421. $sql_old = "SELECT * FROM $db_name.questions WHERE gid = '$gid_arr[$i]'";
  1422. $res_old = Database::query($sql_old, __FILE__, __LINE__);
  1423. while($obj_old = Database::fetch_object($res_old))
  1424. {
  1425. $caption1=addslashes($obj_old->caption);
  1426. $a1=addslashes($obj_old->a1);
  1427. $a2=addslashes($obj_old->a2);
  1428. $a3=addslashes($obj_old->a3);
  1429. $a4=addslashes($obj_old->a4);
  1430. $a5=addslashes($obj_old->a5);
  1431. $a6=addslashes($obj_old->a6);
  1432. $a7=addslashes($obj_old->a7);
  1433. $a8=addslashes($obj_old->a8);
  1434. $a9=addslashes($obj_old->a9);
  1435. $a10=addslashes($obj_old->a10);
  1436. $at=addslashes($obj_old->at);
  1437. $ad=addslashes($obj_old->ad);
  1438. $r1=addslashes($obj_old->r1);
  1439. $r2=addslashes($obj_old->r2);
  1440. $r3=addslashes($obj_old->r3);
  1441. $r4=addslashes($obj_old->r4);
  1442. $r5=addslashes($obj_old->r5);
  1443. $r6=addslashes($obj_old->r6);
  1444. $r7=addslashes($obj_old->r7);
  1445. $r8=addslashes($obj_old->r8);
  1446. $r9=addslashes($obj_old->r9);
  1447. $r10=addslashes($obj_old->r10);
  1448. $sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
  1449. $res_sort=Database::query($sql_sort, __FILE__, __LINE__);
  1450. $rs=Database::fetch_object($res_sort);
  1451. $sortby=$rs->sortby;
  1452. if(empty($sortby))
  1453. {$sortby=1;}
  1454. else{$sortby=$sortby+1;}
  1455. if(@in_array($obj_old->qid,$check_qid)&&@in_array($db_name,$check_db)) //the question has already been imported
  1456. {
  1457. $flag=1;
  1458. continue;
  1459. }
  1460. else
  1461. {
  1462. $sql_insertq = "INSERT INTO $curr_dbname.questions (qid, gid, survey_id, qtype, caption, alignment, sortby, a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, at, ad, alt_text, r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, imported_question, db_name) VALUES('', '$gid', '$sid', '$obj_old->qtype', '$caption1', '$obj_old->alignment', '$sortby', '$a1', '$a2', '$a3', '$a4', '$a5', '$a6', '$a7', '$a8', '$a9', '$a10', '$at', '$ad', '$alt_text', '$r1', '$r2', '$r3', '$r4', '$r5', '$r6', '$r7', '$r8', '$r9', '$r10', '$obj_old->qid', '$db_name')";
  1463. Database::query($sql_insertq, __FILE__, __LINE__);
  1464. }
  1465. }
  1466. }
  1467. else //the groupname does not exist. Create group with this name and insert questions in this new group.
  1468. {
  1469. $sql_insertg = "INSERT INTO $curr_dbname.survey_group (group_id, survey_id, groupname, introduction, imported_group, db_name, sortby) VALUES ('', '$sid', '$groupname', '$introduction', '$obj->group_id', '$db_name', $g_sortby)";
  1470. Database::query($sql_insertg, __FILE__, __LINE__);
  1471. $group_id = Database::insert_id();
  1472. $sql_old = "SELECT * FROM $db_name.questions WHERE gid = '$gid_arr[$i]'";
  1473. $res_old = Database::query($sql_old, __FILE__, __LINE__);
  1474. while($obj_old = Database::fetch_object($res_old))
  1475. {
  1476. $caption1=addslashes($obj_old->caption);
  1477. $a1=addslashes($obj_old->a1);
  1478. $a2=addslashes($obj_old->a2);
  1479. $a3=addslashes($obj_old->a3);
  1480. $a4=addslashes($obj_old->a4);
  1481. $a5=addslashes($obj_old->a5);
  1482. $a6=addslashes($obj_old->a6);
  1483. $a7=addslashes($obj_old->a7);
  1484. $a8=addslashes($obj_old->a8);
  1485. $a9=addslashes($obj_old->a9);
  1486. $a10=addslashes($obj_old->a10);
  1487. $at=addslashes($obj_old->at);
  1488. $ad=addslashes($obj_old->ad);
  1489. $r1=addslashes($obj_old->r1);
  1490. $r2=addslashes($obj_old->r2);
  1491. $r3=addslashes($obj_old->r3);
  1492. $r4=addslashes($obj_old->r4);
  1493. $r5=addslashes($obj_old->r5);
  1494. $r6=addslashes($obj_old->r6);
  1495. $r7=addslashes($obj_old->r7);
  1496. $r8=addslashes($obj_old->r8);
  1497. $r9=addslashes($obj_old->r9);
  1498. $r10=addslashes($obj_old->r10);
  1499. $sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
  1500. $res_sort=Database::query($sql_sort, __FILE__, __LINE__);
  1501. $rs=Database::fetch_object($res_sort);
  1502. $sortby=$rs->sortby;
  1503. if(empty($sortby))
  1504. {$sortby=1;}
  1505. else{$sortby=$sortby+1;}
  1506. $sql_insertq = "INSERT INTO $curr_dbname.questions (qid, gid, survey_id, qtype, caption, alignment, sortby, a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, at, ad, alt_text, r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, imported_question, db_name) VALUES('', '$group_id', '$sid', '$obj_old->qtype', '$caption1', '$obj_old->alignment', '$sortby', '$a1', '$a2', '$a3', '$a4', '$a5', '$a6', '$a7', '$a8', '$a9', '$a10', '$at', '$ad', '$obj_old->alt_text', '$r1', '$r2', '$r3', '$r4', '$r5', '$r6', '$r7', '$r8', '$r9', '$r10', '$obj_old->qid', '$db_name')";
  1507. Database::query($sql_insertq, __FILE__, __LINE__);
  1508. }
  1509. }
  1510. }
  1511. return ($flag);
  1512. }
  1513. /**
  1514. * Possible deprecated method
  1515. * Enter description here...
  1516. *
  1517. * @return unknown
  1518. * @todo remove this function because this is of no use and should not be used.
  1519. */
  1520. function get_status()
  1521. {
  1522. global $_user;
  1523. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  1524. $sqlm = "SELECT status FROM $table_user WHERE user_id = '".Database::escape_string($_user['user_id'])."'";
  1525. $resm = Database::query($sqlm,__FILE__,__LINE__);
  1526. $objm=@Database::fetch_object($resm);
  1527. $ss = $objm->status ;
  1528. return $ss;
  1529. }
  1530. /**
  1531. * Possible deprecated method
  1532. */
  1533. function move_question($direction,$qid,$sort,$curr_dbname)
  1534. {
  1535. $questions=self::get_questions_move($curr_dbname);
  1536. foreach ($questions as $key=>$value)
  1537. {
  1538. if ($qid==$value['qid'])
  1539. {
  1540. $source_course=$value;
  1541. if ($direction=="up")
  1542. {
  1543. $target_course=$questions[$key-1];
  1544. }
  1545. else
  1546. {$target_course=$questions[$key+1];}
  1547. }
  1548. }
  1549. $sql_update1="UPDATE $curr_dbname.questions SET sortby='".$target_course['sortby']."' WHERE qid='".$source_course['qid']."'";
  1550. $sql_update2="UPDATE $curr_dbname.questions SET sortby='".$source_course['sortby']."' WHERE qid='".$target_course['qid']."'";
  1551. Database::query($sql_update2, __FILE__, __LINE__);
  1552. Database::query($sql_update1, __FILE__, __LINE__);
  1553. //return ;
  1554. }
  1555. /**
  1556. * Possible deprecated method
  1557. */
  1558. function get_questions_move($curr_dbname)
  1559. {
  1560. $sql_select_questions="SELECT * from $curr_dbname.questions order by `sortby` asc";
  1561. $result=Database::query($sql_select_questions, __FILE__, __LINE__);
  1562. while ($row=Database::fetch_array($result))
  1563. {
  1564. // we only need the database name of the course
  1565. $question1[]=array("caption"=> $row['caption'], "qid" => $row['qid'],"sortby" => $row['sortby']);
  1566. }
  1567. return $question1;
  1568. }
  1569. /**
  1570. * Possible deprecated method
  1571. */
  1572. function listGroups($id_survey, $fields = '*')
  1573. {
  1574. $groups_table = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  1575. $sql = 'SELECT '.$fields.' FROM '.$groups_table.'
  1576. WHERE survey_id='.$id_survey.' ORDER BY sortby';
  1577. $rs = Database::query($sql, __FILE__, __LINE__);
  1578. $groups = array();
  1579. while($row = Database::fetch_array($rs)){
  1580. $groups[] = $row;
  1581. }
  1582. return $groups;
  1583. }
  1584. /**
  1585. * Possible deprecated method
  1586. */
  1587. function listQuestions($id_survey, $fields = '*')
  1588. {
  1589. $questions_table = Database :: get_course_table(TABLE_MAIN_SURVEYQUESTION);
  1590. $groups_table = Database :: get_course_table(TABLE_SURVEY_QUESTION_GROUP);
  1591. $sql = 'SELECT '.$fields.'
  1592. FROM '.$questions_table.' questions
  1593. INNER JOIN '.$groups_table.' groups
  1594. ON questions.gid = groups.group_id
  1595. WHERE questions.survey_id='.$id_survey.'
  1596. ORDER BY groups.sortby, questions.sortby';
  1597. $rs = Database::query($sql, __FILE__, __LINE__);
  1598. $questions = array();
  1599. while($row = Database::fetch_array($rs)){
  1600. $questions[] = $row;
  1601. }
  1602. return $questions;
  1603. }
  1604. /**
  1605. * Possible deprecated method
  1606. */
  1607. function listAnswers($qid){
  1608. $answers_table = Database :: get_course_table(TABLE_SURVEY_REPORT);
  1609. $sql = 'SELECT DISTINCT answer FROM '.$answers_table.'
  1610. WHERE qid='.$qid;
  1611. $rs = Database::query($sql, __FILE__, __LINE__);
  1612. $answers = array();
  1613. while($row = Database::fetch_array($rs)){
  1614. $answers[] = $row;
  1615. }
  1616. return $answers;
  1617. }
  1618. /**
  1619. * Possible deprecated method
  1620. */
  1621. function listUsers($survey_id, $dbname, $fields='id, user_id, firstname, lastname, email, organization') {
  1622. $tbl_survey_users = Database :: get_main_table(TABLE_MAIN_SURVEY_USER);
  1623. $order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname' : ' ORDER BY lastname, firstname';
  1624. $sql = 'SELECT '.$fields.' FROM '.$tbl_survey_users.'
  1625. WHERE survey_id='.$survey_id.'
  1626. AND db_name="'.$dbname.
  1627. $order_clause;
  1628. $rs = Database::query($sql, __FILE__, __LINE__);
  1629. $users = array();
  1630. while ($row = Database::fetch_array($rs)) {
  1631. $users[] = $row;
  1632. }
  1633. return $users;
  1634. }
  1635. /**
  1636. * Possible deprecated method
  1637. */
  1638. function getUserAnswersDetails($id_userAnswers, $params=''){
  1639. $table_answers = Database :: get_main_table(TABLE_MAIN_SURVEY_USER);
  1640. $sql = 'SELECT * FROM '.$table_answers.' '.$where.' '.$order;
  1641. $rs = Database::query($sql, __FILE__, __LINE__);
  1642. $answers = array();
  1643. while($row = Database::fetch_array($rs))
  1644. $answers[] = $row;
  1645. return $answers;
  1646. }
  1647. }
  1648. /**
  1649. *
  1650. * Manage the "versioning" of a conditional survey
  1651. *
  1652. * */
  1653. class SurveyTree {
  1654. public $surveylist;
  1655. public $plainsurveylist;
  1656. public $numbersurveys;
  1657. /**
  1658. * Sets the surveylist and the plainsurveylist
  1659. */
  1660. public function __construct() {
  1661. // Database table definitions
  1662. $table_survey = Database :: get_course_table(TABLE_SURVEY);
  1663. $table_survey_question = Database :: get_course_table(TABLE_SURVEY_QUESTION);
  1664. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1665. // searching
  1666. $search_restriction = SurveyUtil::survey_search_restriction();
  1667. if ($search_restriction) {
  1668. $search_restriction = ' AND '.$search_restriction;
  1669. }
  1670. $sql = "SELECT survey.survey_id , survey.parent_id, survey_version, survey.code as name
  1671. FROM $table_survey survey
  1672. LEFT JOIN $table_survey_question survey_question
  1673. ON survey.survey_id = survey_question.survey_id , $table_user user
  1674. WHERE survey.author = user.user_id
  1675. GROUP BY survey.survey_id";
  1676. $res = Database::query($sql, __FILE__, __LINE__);
  1677. $surveys_parents = array ();
  1678. $refs = array();
  1679. $list = array();
  1680. $last=array();
  1681. $plain_array=array();
  1682. while ($survey = Database::fetch_array($res,'ASSOC'))
  1683. {
  1684. $plain_array[$survey['survey_id']]=$survey;
  1685. $surveys_parents[]=$survey['survey_version'];
  1686. $thisref = &$refs[ $survey['survey_id'] ];
  1687. $thisref['parent_id'] = $survey['parent_id'];
  1688. $thisref['name'] = $survey['name'];
  1689. $thisref['id'] = $survey['survey_id'];
  1690. $thisref['survey_version'] = $survey['survey_version'];
  1691. if ($survey['parent_id'] == 0)
  1692. {
  1693. $list[ $survey['survey_id'] ] = &$thisref;
  1694. }
  1695. else
  1696. {
  1697. $refs[ $survey['parent_id'] ]['children'][ $survey['survey_id'] ] = &$thisref;
  1698. }
  1699. }
  1700. $this->surveylist = $list;
  1701. $this->plainsurveylist = $plain_array;
  1702. }
  1703. /*
  1704. function read_children($space=array(),$i=0)
  1705. {
  1706. foreach ( $this->surveylist as $key=>$node)
  1707. {
  1708. if (is_array($node['children']))
  1709. {
  1710. if (($node['parent_id']==0))
  1711. {
  1712. //echo '1<br>';
  1713. }
  1714. else
  1715. {
  1716. $space[]='2>';
  1717. }
  1718. //if have children
  1719. for ($j=0;$j<count($space);$j++)
  1720. {
  1721. //echo $space[$j]; echo 'dd<br>';
  1722. }
  1723. //echo $node['name']; echo '3<br>';
  1724. read_children($node['children'],$space,$i);
  1725. }
  1726. else
  1727. {
  1728. for ($j=0;$j<count($space);$j++)
  1729. {
  1730. echo $space[$j]; echo '4<br>';
  1731. }
  1732. echo $node['name']; echo '5<br>';
  1733. }
  1734. }
  1735. }
  1736. */
  1737. /*
  1738. if (($key==$id))
  1739. {
  1740. echo $node['name']; echo '<br>';
  1741. //$node['children']=array();
  1742. return $node['children'];
  1743. }
  1744. else
  1745. {
  1746. if (is_array($node['children']))
  1747. {
  1748. return SurveyTree::get_children($node['children'],$id);
  1749. }
  1750. else
  1751. {
  1752. //return SurveyTree::get_children($node, $id);
  1753. }
  1754. }
  1755. */
  1756. /**
  1757. * This function gets all the children of a given survey id
  1758. *
  1759. * @param array the list where we are going to search the children
  1760. * @param id the id of the survey
  1761. * @return array the children of a given survey id
  1762. *
  1763. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1764. * @version September 2008
  1765. */
  1766. public function get_children ($list,$id) {
  1767. $result=array();
  1768. foreach ($list as $key=>$node)
  1769. {
  1770. if ($key==$id)
  1771. {
  1772. $result = $node['children'];
  1773. break;
  1774. }
  1775. if (is_array($node['children']))
  1776. {
  1777. //echo $key; echo '--<br>';
  1778. $re=self::get_children($node['children'],$id);
  1779. if (!empty($re))
  1780. {
  1781. $result=$re;
  1782. }
  1783. }
  1784. else
  1785. {
  1786. //echo $key; echo '-<br>';
  1787. }
  1788. }
  1789. return $result;
  1790. }
  1791. /**
  1792. * This function gets the parent id of a survey
  1793. *
  1794. * @param int survey id
  1795. * @return int survey parent id
  1796. *
  1797. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1798. * @version September 2008
  1799. */
  1800. public function getParentId ($id) {
  1801. $node = $this->plainsurveylist[$id];
  1802. if (is_array($node)&& !empty($node['parent_id']))
  1803. return $node['parent_id'];
  1804. else
  1805. return -1;
  1806. }
  1807. /**
  1808. * This function gets all the siblings of a given survey id
  1809. *
  1810. * @param array the list where we are going to search the children
  1811. * @param id the id of the survey
  1812. * @return array the children of a given survey id
  1813. *
  1814. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1815. * @version September 2008
  1816. */
  1817. public function nextSibling($id) {
  1818. $result=array();
  1819. $parent_id = self::getParentId($id);
  1820. $siblings = self::get_children($this->surveylist ,$parent_id);
  1821. //print_r($siblings);
  1822. if (count($siblings) > 1)
  1823. {
  1824. // $key> $id means that the siblings are order 1 2 3 and we suppose that you can't change that order
  1825. foreach ($siblings as $key=>$bro)
  1826. {
  1827. if ($key> $id && $key != $id)
  1828. {
  1829. $result[$key]=($bro);
  1830. }
  1831. }
  1832. }
  1833. return $result;
  1834. }
  1835. /**
  1836. *
  1837. * This function shows the last sibling from a given list of surveys
  1838. * @param id of the survey
  1839. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1840. * @version September 2008
  1841. *
  1842. */
  1843. public function lastSibling($id) {
  1844. $result=array();
  1845. $parent_id = self::getParentId($id);
  1846. $siblings = self::get_children($this->surveylist ,$parent_id);
  1847. //print_r($siblings);
  1848. if (count($siblings) > 1)
  1849. {
  1850. // $key> $id means that the siblings are order 1 2 3 and we suppose that you can't change that order
  1851. $i=0;
  1852. foreach ($siblings as $key=>$bro)
  1853. {
  1854. if ($key> $id && $key != $id&& $i==count($siblings)-1)
  1855. {
  1856. $result[$key]=($bro);
  1857. }
  1858. $i++;
  1859. }
  1860. }
  1861. return $result;
  1862. }
  1863. /**
  1864. *
  1865. * This function shows the last children of a branch
  1866. * @param list of nodes
  1867. * @return array of the lastest node
  1868. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1869. * @version September 2008
  1870. *
  1871. */
  1872. public function get_last_children_from_branch($list) {
  1873. $result=array();
  1874. foreach ($list as $key=>$node)
  1875. {
  1876. //echo 'frist<br>'; echo $key;
  1877. //print_r($node);
  1878. if ($node['parent_id']!=0)
  1879. {
  1880. $list_bros = self::lastSibling($key);
  1881. //echo ' list_bro <br>';
  1882. //print_r($list_bros);
  1883. if (is_array($list_bros) && !empty($list_bros))
  1884. {
  1885. foreach ($list_bros as $bro)
  1886. {
  1887. //echo '0';
  1888. if (is_array($bro['children']))
  1889. {
  1890. //print_r($bro['children']);
  1891. return $result[]=self::get_last_children_from_branch($bro['children']);
  1892. }
  1893. else
  1894. {
  1895. //echo 'esl';
  1896. $result=$bro;
  1897. //print_r($bro);
  1898. return $result;
  1899. }
  1900. }
  1901. }
  1902. else
  1903. {
  1904. //SurveyTree::get_last_children_from_branch($list_bros);
  1905. //echo 'sss';
  1906. //if if (is_array($node['children']))
  1907. $children = self::get_children($node,$key);
  1908. //return $result[]=SurveyTree::get_last_children_from_branch($node);
  1909. if (is_array($node['children']))
  1910. {
  1911. return $result[]=self::get_last_children_from_branch($node['children']);
  1912. }
  1913. else
  1914. {
  1915. //return $result[]=SurveyTree::get_last_children_from_branch($node['children']);
  1916. return $result[]=$node;
  1917. }
  1918. }
  1919. }
  1920. else
  1921. {
  1922. //print_r($key);print_r($node['children']);
  1923. if (is_array($node['children']))
  1924. {
  1925. $result[]=self::get_last_children_from_branch($node['children']);
  1926. }
  1927. else
  1928. {
  1929. $result[]=$node;
  1930. }
  1931. }
  1932. }
  1933. return $result;
  1934. }
  1935. /*
  1936. *
  1937. *
  1938. * This function show the last children of list
  1939. * @param id
  1940. * @param array
  1941. * @return array of the lastest node
  1942. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1943. * @version September 2008
  1944. *
  1945. function get_last_children($id,$last)
  1946. {
  1947. foreach ( $this->_list as $key=>$node)
  1948. {
  1949. if (($node['parent_id']==$id))
  1950. {
  1951. $last=$node['name']; echo '<br>';
  1952. }
  1953. else
  1954. {
  1955. if (is_array($node['children']))
  1956. {
  1957. return $last = get_last_children($node['children'],$id);
  1958. }
  1959. }
  1960. }
  1961. return $last;
  1962. }
  1963. */
  1964. /**
  1965. * This function creates a list of all surveys id
  1966. * @param list of nodes
  1967. * @return array with the structure survey_id => survey_name
  1968. * @author Julio Montoya <gugli100@gmail.com>, Dokeos
  1969. * @version September 2008
  1970. *
  1971. */
  1972. public function createList ($list) {
  1973. $result=array();
  1974. foreach ($list as $key=>$node)
  1975. {
  1976. if (is_array($node['children']))
  1977. {
  1978. //echo $key; echo '--<br>';
  1979. //print_r($node);
  1980. //echo '<br>';
  1981. $result[$key]= $node['name'];
  1982. $re=self::createList($node['children']);
  1983. if (!empty($re))
  1984. {
  1985. if (is_array($re))
  1986. foreach ($re as $key=>$r)
  1987. {
  1988. $result[$key]=''.$r;
  1989. }
  1990. else
  1991. {
  1992. $result[]=$re;
  1993. }
  1994. }
  1995. }
  1996. else
  1997. {
  1998. //echo $key; echo '-<br>';
  1999. $result[$key]=$node['name'];
  2000. }
  2001. }
  2002. return $result;
  2003. }
  2004. }
  2005. ?>