surveymanager.lib.php 69 KB

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