create_new_group.php 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244
  1. <?php
  2. // $Id: course_add.php,v 1.10 2005/05/30 11:46:48 bmol Exp $
  3. /*
  4. ==============================================================================
  5. Dokeos - elearning and course management software
  6. Copyright (c) 2004 Dokeos S.A.
  7. Copyright (c) 2003 University of Ghent (UGent)
  8. Copyright (c) 2001 Universite catholique de Louvain (UCL)
  9. Copyright (c) Olivier Brouckaert
  10. For a full list of contributors, see "credits.txt".
  11. The full license can be read in "license.txt".
  12. This program is free software; you can redistribute it and/or
  13. modify it under the terms of the GNU General Public License
  14. as published by the Free Software Foundation; either version 2
  15. of the License, or (at your option) any later version.
  16. See the GNU General Public License for more details.
  17. Contact: Dokeos, 181 rue Royale, B-1000 Brussels, Belgium, info@dokeos.com
  18. ==============================================================================
  19. */
  20. /**
  21. ==============================================================================
  22. * @package dokeos.admin
  23. ==============================================================================
  24. */
  25. /*
  26. ==============================================================================
  27. INIT SECTION
  28. ==============================================================================
  29. */
  30. $langFile = 'survey';
  31. require_once ('../inc/global.inc.php');
  32. //api_protect_admin_script();
  33. require_once (api_get_path(LIBRARY_PATH).'/fileManage.lib.php');
  34. require_once (api_get_path(CONFIGURATION_PATH) ."/add_course.conf.php");
  35. require_once (api_get_path(LIBRARY_PATH)."/add_course.lib.inc.php");
  36. require_once (api_get_path(LIBRARY_PATH)."/surveymanager.lib.php");
  37. $status = surveymanager::get_status();
  38. if($status==5)
  39. {
  40. api_protect_admin_script();
  41. }
  42. require_once (api_get_path(LIBRARY_PATH)."/usermanager.lib.php");
  43. $cidReq=$_GET['cidReq'];
  44. $curr_dbname = $_REQUEST['curr_dbname'];
  45. $table_group = Database :: get_course_table('survey_group');
  46. $table_user = Database :: get_main_table(MAIN_USER_TABLE);
  47. $tool_name1 = get_lang('createnewgroup1');
  48. $tool_name = get_lang('createnewgroup');
  49. $header1 = get_lang('GroupList');
  50. $interbredcrump[] = array ("url" => "survey_list.php", "name" => get_lang('Survey'));
  51. $surveyid = $_GET['surveyid'];
  52. $surveyname = SurveyManager::pick_surveyname($surveyid);
  53. if(isset($_GET['direction'])){
  54. $sql = 'SELECT *
  55. FROM '.$table_group.'
  56. WHERE group_id='.intval($_GET['id_group']);
  57. $rs = api_sql_query($sql, __FILE__, __LINE__);
  58. $group = mysql_fetch_object($rs);
  59. if(is_object($group)){
  60. $_GET['direction'] == 'up' ? $operateur = '-' : $operateur = '+';
  61. $sql = 'UPDATE '.$table_group.' SET
  62. sortby='.$group->sortby.'
  63. WHERE sortby='.$group->sortby.$operateur.'1' ;
  64. $rs = api_sql_query($sql,__FILE__,__LINE__);
  65. $sql = 'UPDATE '.$table_group.' SET
  66. sortby='.$group->sortby.$operateur.'1'.'
  67. WHERE group_id='.intval($_GET['id_group']);
  68. $rs = api_sql_query($sql,__FILE__,__LINE__);
  69. }
  70. }
  71. if(isset($_REQUEST['delete']))
  72. {
  73. $group_id = $_REQUEST['group_delete'];
  74. $surveyid = $_REQUEST['surveyid'];
  75. $curr_dbname = $_REQUEST['curr_dbname'];
  76. SurveyManager::delete_group($group_id,$curr_dbname);
  77. header("Location:create_new_group.php?surveyid=$surveyid&cidReq=$cidReq&curr_dbname=$curr_dbname");
  78. exit;
  79. }
  80. if ($_POST['action'] == 'new_group')
  81. {
  82. $surveyid = $_POST['surveyid'];
  83. $groupname = $_POST['groupname'];
  84. $curr_dbname = $_REQUEST['curr_dbname'];
  85. $surveyintroduction = $_POST['content'];
  86. if(isset($_POST['back']))
  87. {
  88. header("location:select_question_group.php?surveyid=$surveyid&cidReq=$cidReq&curr_dbname=$curr_dbname");
  89. exit;
  90. }
  91. $groupname=trim($groupname);
  92. if(empty ($groupname))
  93. {
  94. $error_message = get_lang('PleaseEnterGroupName');
  95. }
  96. else
  97. {
  98. $groupid = SurveyManager::create_group($surveyid,$groupname,$surveyintroduction,$table_group);
  99. $cidReq = $_GET['cidReq'];
  100. if(isset($_POST['next']) && $groupid)
  101. {
  102. header("location:addanother.php?surveyid=$surveyid&newgroupid=$groupid&cidReq=$cidReq&curr_dbname=$curr_dbname");
  103. exit;
  104. }elseif(isset($_POST['saveandexit']) && $groupid){
  105. header("location:survey_list.php?cidReq=$cidReq");
  106. exit;
  107. }
  108. else
  109. {
  110. $error_message = "This Group Already Exists !";
  111. }
  112. }
  113. }
  114. Display::display_header($tool_name1);
  115. ?>
  116. <tr>
  117. <td><? api_display_tool_title($header1) ?></td>
  118. </tr>
  119. <?
  120. if( isset($error_message) )
  121. {
  122. Display::display_error_message($error_message);
  123. }
  124. $table_group = Database :: get_course_table('survey_group');
  125. $sql = "SELECT * FROM $curr_dbname.survey_group Where survey_id='$surveyid' ORDER BY sortby ASC";
  126. $parameters = array ();
  127. $parameters['curr_dbname']=$curr_dbname;
  128. $parameters['surveyid']=$surveyid;
  129. $parameters['groupid']=$groupid;
  130. $parameters['cidReq']=$cidReq;
  131. $res = api_sql_query($sql,__FILE__,__LINE__);
  132. $countGroups = mysql_num_rows($res);
  133. if ($countGroups > 0)
  134. {
  135. $i=0;
  136. //$surveys = array ();
  137. while ($obj = mysql_fetch_object($res))
  138. {
  139. $gid=$obj->group_id;
  140. $gname = $obj->groupname;
  141. $survey = array ();
  142. $survey[] = $obj->groupname;
  143. $gid=$obj->group_id;
  144. $idd=surveymanager::pick_author($surveyid);
  145. $author=surveymanager::get_survey_author($idd);
  146. $surveyname=surveymanager::pick_surveyname($surveyid);
  147. $survey[] = $surveyname;
  148. $survey[] = $author;
  149. $directions = '<table cellpadding="0" cellspacing="0" border="0" style="border:0px"><tr>';
  150. if($i < $countGroups-1){
  151. $directions .= '<td><a href="'.$_SERVER['PHP_SELF'].'?surveyid='.$surveyid.'&cidReq='.$cidReq.'&curr_dbname='.$curr_dbname.'&direction=down&id_group='.$gid.'"><img src="../img/down.gif" border="0" title="lang_move_down"></a></td>';
  152. }
  153. else {
  154. $directions .= '<td width="20"></td>';
  155. }
  156. if($i > 0){
  157. $directions .= '<td><a href="'.$_SERVER['PHP_SELF'].'?surveyid='.$surveyid.'&cidReq='.$cidReq.'&curr_dbname='.$curr_dbname.'&direction=up&id_group='.$gid.'"><img src="../img/up.gif" border="0" title="lang_move_up"></a></td>';
  158. }
  159. else {
  160. $directions .= '<td></td>';
  161. }
  162. $directions .= '</tr></table>';
  163. $survey[] = $directions;
  164. $survey[] = '<a href="group_edit.php?groupid='.$obj->group_id.'&cidReq='.$cidReq.'&curr_dbname='.$curr_dbname.'&surveyid='.$surveyid.'"><img src="../img/edit.gif" border="0" align="absmiddle" alt="'.get_lang('Edit').'"/></a>'
  165. .'<a href="create_new_group.php?cidReq='.$cidReq.'&curr_dbname='.$curr_dbname.'&delete=1&group_delete='.$gid.'&surveyid='.$surveyid.'" onclick="javascript:if(!confirm('."'".addslashes(htmlentities(get_lang("ConfirmYourChoice")))."'".')) return false;"><img src="../img/delete.gif" border="0" align="absmiddle" alt="'.get_lang('Delete').'"/></a>'
  166. ;
  167. $surveys[] = $survey;
  168. $i++;
  169. }
  170. //$table_header[] = array (' ', false);
  171. //$table_header[] = array (get_lang('SNo'), true);
  172. $table_header[] = array (get_lang('QuesGroup'), true);
  173. $table_header[] = array (get_lang('SurveyName1'), true);
  174. $table_header[] = array (get_lang('author'), true);
  175. $table_header[] = array (get_lang('OrderBy'), true);
  176. $table_header[] = array (' ', false);
  177. Display :: display_sortable_table($table_header, $surveys, array ('column'=>get_lang('OrderBy')), array (), $parameters);
  178. }
  179. else
  180. {
  181. echo get_lang('NoSearchResults');
  182. }
  183. echo '<a href="select_question_group.php?surveyid='.$surveyid.'&cidReq='.$cidReq.'&curr_dbname='.$curr_dbname.'">'.get_lang('BackToQuestions').'</a><br><br>';
  184. api_display_tool_title($tool_name);
  185. ?>
  186. <script src=tbl_change.js type="text/javascript" language="javascript"></script>
  187. <form name="new_calendar_item" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>?cidReq=<?=$cidReq?>">
  188. <input type="hidden" name="action" value="new_group">
  189. <input type="hidden" name="surveyid" value="<?=$surveyid?>">
  190. <input type="hidden" name="groupid" value="<?=$groupid?>">
  191. <input type="hidden" name="curr_dbname" value="<?=$curr_dbname?>">
  192. <!--<input type="hidden" name="cidReq" value="<?=$_REQUEST['cidReq']?>">-->
  193. <table>
  194. <tr>
  195. <td><?php echo get_lang('groupname'); ?></td>
  196. <td><input type="text" name="groupname" size="40" maxlength="39" value="<?php echo $code ?>"></td>
  197. </tr>
  198. <tr><td valign="top"><?php echo get_lang('GroupIntroduction'); ?>&nbsp;</td>
  199. <td>
  200. <?php
  201. api_disp_html_area('content',$content,'300px');
  202. ?>
  203. <br>
  204. </td>
  205. </tr>
  206. </table>
  207. <tr>
  208. <td>&nbsp;</td>
  209. <td><input type="submit" name="back" value="<?php echo get_lang('back'); ?>"></td>
  210. <td><input type="submit" name="saveandexit" value="<?php echo get_lang('saveandexit'); ?>"></td>
  211. <td><input type="submit" name="next" value="<?php echo get_lang('next'); ?>"></td>
  212. </tr>
  213. </form>
  214. <?php
  215. /*
  216. ==============================================================================
  217. FOOTER
  218. ==============================================================================
  219. */
  220. Display :: display_footer();
  221. ?>