copy_course_session.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Copy resources from one course in a session to another one.
  5. *
  6. * @author Christian Fasanando <christian.fasanando@dokeos.com>
  7. * @author Julio Montoya <gugli100@gmail.com> Lots of bug fixes/improvements
  8. * @package chamilo.backup
  9. */
  10. /* INIT SECTION */
  11. // Language files that need to be included
  12. $language_file = array('coursebackup', 'admin');
  13. $cidReset = true;
  14. require_once '../inc/global.inc.php';
  15. require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
  16. require_once api_get_path(LIBRARY_PATH).'sessionmanager.lib.php';
  17. require_once api_get_path(LIBRARY_PATH).'xajax/xajax.inc.php';
  18. require_once 'classes/CourseBuilder.class.php';
  19. require_once 'classes/CourseRestorer.class.php';
  20. require_once 'classes/CourseSelectForm.class.php';
  21. $xajax = new xajax();
  22. $xajax->registerFunction('search_courses');
  23. if (!api_is_allowed_to_edit() && !api_is_session_admin()) {
  24. api_not_allowed(true);
  25. }
  26. // Remove memory and time limits as much as possible as this might be a long process...
  27. if (function_exists('ini_set')) {
  28. ini_set('memory_limit', '256M');
  29. ini_set('max_execution_time', 1800);
  30. }
  31. $this_section = SECTION_PLATFORM_ADMIN;
  32. $nameTools = get_lang('CopyCourse');
  33. $interbreadcrumb[] = array('url' => '../admin/index.php', 'name' => get_lang('PlatformAdmin'));
  34. // Database Table Definitions
  35. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  36. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  37. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  38. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  39. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  40. /* FUNCTIONS */
  41. function make_select_session_list($name, $sessions, $attr = array()) {
  42. $attrs = '';
  43. if (count($attr) > 0) {
  44. foreach ($attr as $key => $value) {
  45. $attrs .= ' '.$key.'="'.$value.'"';
  46. }
  47. }
  48. $output = '<select name="'.$name.'" '.$attrs.'>';
  49. if (count($sessions) == 0) {
  50. $output .= '<option value = "0">'.get_lang('ThereIsNotStillASession').'</option>';
  51. } else {
  52. $output .= '<option value = "0">'.get_lang('SelectASession').'</option>';
  53. }
  54. if (is_array($sessions)) {
  55. foreach ($sessions as $session) {
  56. $category_name = '';
  57. if (!empty($session['category_name'])) {
  58. $category_name = ' ('.$session['category_name'].')';
  59. }
  60. $output .= '<option value="'.$session['id'].'">'.$session['name'].' '.$category_name.'</option>';
  61. }
  62. }
  63. $output .= '</select>';
  64. return $output;
  65. }
  66. function display_form() {
  67. $html = '';
  68. $sessions = SessionManager::get_sessions_list();
  69. // Actions
  70. $html .= '<div class="actions">';
  71. // Link back to the documents overview
  72. $html .= '<a href="../admin/index.php">'.Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('PlatformAdmin'),'','32').'</a>';
  73. $html .= '</div>';
  74. $html .= Display::return_message(get_lang('CopyCourseFromSessionToSessionExplanation'));
  75. $html .= '<form name="formulaire" method="post" action="'.api_get_self().'" >';
  76. $html .= '<table border="0" cellpadding="5" cellspacing="0" width="100%" align="center">';
  77. //left
  78. $html .= '<tr><td width="50%" align="center"><b>'.get_lang('OriginCoursesFromSession').':</b></td>';
  79. $html .= '<td align="center" width="30%"><b>'.get_lang('DestinationCoursesFromSession').':</b></td></tr>';
  80. $html .= '<tr><td width="50%" align="center">'.make_select_session_list('sessions_list_origin', $sessions, array('onchange' => 'javascript: xajax_search_courses(this.value,\'origin\');')).'</td>';
  81. $html .= '<td width="50%" align="center"><div id="ajax_sessions_list_destination">';
  82. $html .= '<select name="sessions_list_destination" onchange="javascript: xajax_search_courses(this.value,\'destination\');">';
  83. $html .= '<option value = "0">'.get_lang('ThereIsNotStillASession').'</option></select ></div></td></tr>';
  84. $html .= '<tr><td width="50%" align="center"><div id="ajax_list_courses_origin">';
  85. $html .= '<select id="origin" name="SessionCoursesListOrigin[]" multiple="multiple" size="20" style="width:380px;"></select></div></td>';
  86. //Right
  87. $html .= '<td width="50%" align="center">';
  88. $html .= '<div id="ajax_list_courses_destination">';
  89. $html .= '<select id="destination" name="SessionCoursesListDestination[]" multiple="multiple" size="20" style="width:380px;" ></select></div></td>';
  90. $html .= '</tr></table>';
  91. $html .= '<h3>'.get_lang('TypeOfCopy').'</h3>';
  92. $html .= '<input type="radio" class="checkbox" id="copy_option_1" name="copy_option" value="full_copy" checked="checked"/>';
  93. $html .= '<label for="copy_option_1"> '.get_lang('FullCopy').'</label><br/>';
  94. $html .= '<input type="radio" class="checkbox" id="copy_option_2" name="copy_option" value="select_items" disabled="disabled"/>';
  95. $html .= '<label for="copy_option_2"><span id="title_option2" style="color:#aaa"> '.get_lang('LetMeSelectItems').'</span></label><br/><br/>';
  96. $html .= '<button class="save" type="submit" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES))."'".')) return false;">'.get_lang('CopyCourse').'</button>';
  97. $html .= '</form>';
  98. echo $html;
  99. }
  100. function search_courses($id_session, $type) {
  101. global $tbl_course, $tbl_session_rel_course, $course_list;
  102. $xajax_response = new XajaxResponse();
  103. $return_origin = '';
  104. $select_destination = '';
  105. if (!empty($type)) {
  106. $id_session = intval($id_session);
  107. if ($type == 'origin') {
  108. $course_list = SessionManager::get_course_list_by_session_id($id_session);
  109. $temp_course_list = array();
  110. $return .= '<select id="origin" name="SessionCoursesListOrigin[]" multiple="multiple" size="20" style="width:380px;" onclick="javascript: checkSelected(this.id,\'copy_option_2\',\'title_option2\',\'destination\');">';
  111. foreach ($course_list as $course) {
  112. $temp_course_list[] = "'{$course['code']}'";
  113. $course_title=str_replace("'","\'",$course_title);
  114. $return .= '<option value="'.$course['code'].'" title="'.@htmlspecialchars($course['title'].' ('.$course['visual_code'].')', ENT_QUOTES, api_get_system_encoding()).'">'.$course['title'].' ('.$course['visual_code'].')</option>';
  115. }
  116. $return .= '</select>';
  117. $_SESSION['course_list'] = $temp_course_list;
  118. $_SESSION['session_origin'] = $id_session;
  119. // Build select for destination sessions where is not included current session from select origin
  120. if (!empty($id_session)) {
  121. $sessions = SessionManager::get_sessions_list();
  122. $select_destination .= '<select name="sessions_list_destination" width="380px" onchange = "javascript: xajax_search_courses(this.value,\'destination\');">';
  123. $select_destination .= '<option value = "0">-- '.get_lang('SelectASession').' --</option>';
  124. foreach ($sessions as $session) {
  125. if ($id_session == $session['id']) { continue; };
  126. if (!empty($session['category_name'])) {
  127. $session['category_name'] = ' ('.$session['category_name'].') ';
  128. }
  129. $select_destination .= '<option value="'.$session['id'].'">'.$session['name'].' '.$session['category_name'].'</option>';
  130. }
  131. $select_destination .= '</select>';
  132. $xajax_response -> addAssign('ajax_sessions_list_destination', 'innerHTML', api_utf8_encode($select_destination));
  133. } else {
  134. $select_destination .= '<select name="sessions_list_destination" width="380px" onchange = "javascript: xajax_search_courses(this.value,\'destination\');">';
  135. $select_destination .= '<option value = "0">'.get_lang('ThereIsNotStillASession').'</option>';
  136. $select_destination .= '</select>';
  137. $xajax_response -> addAssign('ajax_sessions_list_destination', 'innerHTML', api_utf8_encode($select_destination));
  138. }
  139. // Select multiple destination empty
  140. $select_multiple_empty = '<select id="destination" name="SessionCoursesListDestination[]" multiple="multiple" size="20" style="width:380px;"></select>';
  141. // Send response by ajax
  142. $xajax_response -> addAssign('ajax_list_courses_origin', 'innerHTML', api_utf8_encode($return));
  143. $xajax_response -> addAssign('ajax_list_courses_destination', 'innerHTML', api_utf8_encode($select_multiple_empty));
  144. } else {
  145. //Left Select - Destination
  146. $list_courses_origin = implode(',', $_SESSION['course_list']);
  147. $session_origin = $_SESSION['session_origin'];
  148. // Search courses by id_session where course codes is include en courses list destination
  149. $sql = "SELECT c.code, c.visual_code, c.title, src.id_session
  150. FROM $tbl_course c, $tbl_session_rel_course src
  151. WHERE src.course_code = c.code
  152. AND src.id_session = '".intval($id_session)."'";
  153. //AND c.code IN ($list_courses_origin)";
  154. $rs = Database::query($sql);
  155. $course_list_destination = array();
  156. //onmouseover="javascript: this.disabled=true;" onmouseout="javascript: this.disabled=false;"
  157. $return .= '<select id="destination" name="SessionCoursesListDestination[]" multiple="multiple" size="20" style="width:380px;" >';
  158. while ($course = Database :: fetch_array($rs)) {
  159. $course_list_destination[] = $course['code'];
  160. $course_title = str_replace("'", "\'", $course_title);
  161. $return .= '<option value="'.$course['code'].'" title="'.@htmlspecialchars($course['title'].' ('.$course['visual_code'].')', ENT_QUOTES, api_get_system_encoding()).'">'.$course['title'].' ('.$course['visual_code'].')</option>';
  162. }
  163. $return .= '</select>';
  164. $_SESSION['course_list_destination'] = $course_list_destination;
  165. // Send response by ajax
  166. $xajax_response -> addAssign('ajax_list_courses_destination', 'innerHTML', api_utf8_encode($return));
  167. /*
  168. // Disable option from session courses list origin where if no the same con the destination
  169. $sql = "SELECT c.code, c.visual_code, c.title, src.id_session
  170. FROM $tbl_course c, $tbl_session_rel_course src
  171. WHERE src.course_code = c.code
  172. AND src.id_session = '".intval($session_origin)."'";
  173. $result = Database::query($sql);
  174. $return_option_disabled = '<select id="origin" name="SessionCoursesListOrigin[]" multiple="multiple" size="20" style="width:320px;" onclick="javascript: checkSelected(this.id,\'copy_option_2\',\'title_option2\',\'destination\');">';
  175. while ($cours = Database :: fetch_array($result)) {
  176. $course_title=str_replace("'", "\'", $course_title);
  177. if (count($course_list_destination) > 0) {
  178. if (!in_array($cours['code'], $course_list_destination)) {
  179. $return_option_disabled .= '<optgroup style="color:#ccc" label="'.$cours['title'].' ('.$cours['visual_code'].')" >'.$cours['title'].' ('.$cours['visual_code'].')</optgroup>';
  180. } else {
  181. $return_option_disabled .= '<option value="'.$cours['code'].'" title="'.@htmlspecialchars($cours['title'].' ('.$cours['visual_code'].')', ENT_QUOTES, api_get_system_encoding()).'">'.$cours['title'].' ('.$cours['visual_code'].')</option>';
  182. }
  183. } else {
  184. if (empty($id_session)) {
  185. $return_option_disabled .= '<option value="'.$cours['code'].'" title="'.@htmlspecialchars($cours['title'].' ('.$cours['visual_code'].')', ENT_QUOTES, api_get_system_encoding()).'">'.$cours['title'].' ('.$cours['visual_code'].')</option>';
  186. } else {
  187. $return_option_disabled .= '<optgroup style="color:#ccc" label="'.$cours['title'].'('.$cours['visual_code'].')" >'.$cours['title'].' ('.$cours['visual_code'].')</optgroup>';
  188. }
  189. }
  190. }
  191. $return_option_disabled .= '</select>';*/
  192. // Send response by ajax
  193. //$xajax_response -> addAssign('ajax_list_courses_origin', 'innerHTML', api_utf8_encode($return_option_disabled));
  194. }
  195. }
  196. return $xajax_response;
  197. }
  198. $xajax -> processRequests();
  199. /* HTML head extra */
  200. $htmlHeadXtra[] = $xajax->getJavascript( api_get_path(WEB_LIBRARY_PATH).'xajax/');
  201. $htmlHeadXtra[] = '<script type="text/javascript">
  202. function checkSelected(id_select,id_radio,id_title,id_destination) {
  203. var num=0;
  204. obj_origin = document.getElementById(id_select);
  205. obj_destination = document.getElementById(id_destination);
  206. for (x=0;x<obj_origin.options.length;x++) {
  207. if (obj_origin.options[x].selected) {
  208. if (obj_destination.options.length > 0) {
  209. for (y=0;y<obj_destination.options.length;y++) {
  210. if (obj_origin.options[x].value == obj_destination.options[y].value) {
  211. obj_destination.options[y].selected = true;
  212. }
  213. }
  214. }
  215. num++;
  216. } else {
  217. if (obj_destination.options.length > 0) {
  218. for (y=0;y<obj_destination.options.length;y++) {
  219. if (obj_origin.options[x].value == obj_destination.options[y].value) {
  220. obj_destination.options[y].selected = false;
  221. }
  222. }
  223. }
  224. }
  225. }
  226. if (num == 1) {
  227. document.getElementById(id_radio).disabled = false;
  228. document.getElementById(id_title).style.color = \'#000\';
  229. } else {
  230. document.getElementById(id_radio).disabled = true;
  231. document.getElementById(id_title).style.color = \'#aaa\';
  232. }
  233. }
  234. </script>';
  235. Display::display_header($nameTools);
  236. /* MAIN CODE */
  237. if ((isset($_POST['action']) && $_POST['action'] == 'course_select_form') || (isset($_POST['copy_option']) && $_POST['copy_option'] == 'full_copy')) {
  238. $destination_course = $origin_course = $destination_session = $origin_session = '';
  239. if (isset ($_POST['action']) && $_POST['action'] == 'course_select_form') {
  240. $destination_course = $_POST['destination_course'];
  241. $origin_course = $_POST['origin_course'];
  242. $destination_session = $_POST['destination_session'];
  243. $origin_session = $_POST['origin_session'];
  244. $course = CourseSelectForm :: get_posted_course('copy_course', $origin_session, $origin_course);
  245. //print_r($course);
  246. $cr = new CourseRestorer($course);
  247. //$cr->set_file_option($_POST['same_file_name_option']);
  248. $cr->restore($destination_course, $destination_session);
  249. Display::display_normal_message(get_lang('CopyFinished'));
  250. display_form();
  251. } else {
  252. $arr_course_origin = array();
  253. $arr_course_destination = array();
  254. $destination_session = '';
  255. $origin_session = '';
  256. if (isset($_POST['SessionCoursesListOrigin'])) {
  257. $arr_course_origin = $_POST['SessionCoursesListOrigin'];
  258. }
  259. if (isset($_POST['SessionCoursesListDestination'])) {
  260. $arr_course_destination = $_POST['SessionCoursesListDestination'];
  261. }
  262. if (isset($_POST['sessions_list_destination'])) {
  263. $destination_session = $_POST['sessions_list_destination'];
  264. }
  265. if (isset($_POST['sessions_list_origin'])) {
  266. $origin_session = $_POST['sessions_list_origin'];
  267. }
  268. if ((is_array($arr_course_origin) && count($arr_course_origin) > 0) && !empty($destination_session)) {
  269. //We need only one value
  270. if (count($arr_course_origin) > 1 || count($arr_course_destination) > 1) {
  271. Display::display_error_message(get_lang('YouMustSelectACourseFromOriginalSession'));
  272. display_form();
  273. } else {
  274. //foreach ($arr_course_origin as $course_origin) {
  275. //first element of the array
  276. $course_code = $arr_course_origin[0];
  277. $course_destinatination = $arr_course_destination[0];
  278. $course_origin = api_get_course_info($course_code);
  279. $cb = new CourseBuilder('', $course_origin);
  280. $course = $cb->build($origin_session, $course_code);
  281. $cr = new CourseRestorer($course);
  282. //$cr->set_file_option($_POST['same_file_name_option']);
  283. $cr->restore($course_destinatination, $destination_session);
  284. //}
  285. }
  286. Display::display_normal_message(get_lang('CopyFinished'));
  287. display_form();
  288. } else {
  289. Display::display_error_message(get_lang('YouMustSelectACourseFromOriginalSession'));
  290. display_form();
  291. }
  292. }
  293. } elseif (isset($_POST['copy_option']) && $_POST['copy_option'] == 'select_items') {
  294. // Else, if a CourseSelectForm is requested, show it
  295. if (api_get_setting('show_glossary_in_documents') != 'none') {
  296. Display::display_normal_message(get_lang('ToExportDocumentsWithGlossaryYouHaveToSelectGlossary'));
  297. }
  298. $arr_course_origin = array();
  299. $arr_course_destination = array();
  300. $destination_session = '';
  301. $origin_session = '';
  302. if (isset($_POST['SessionCoursesListOrigin'])) {
  303. $arr_course_origin = $_POST['SessionCoursesListOrigin'];
  304. }
  305. if (isset($_POST['SessionCoursesListDestination'])) {
  306. $arr_course_destination = $_POST['SessionCoursesListDestination'];
  307. }
  308. if (isset($_POST['sessions_list_destination'])) {
  309. $destination_session = $_POST['sessions_list_destination'];
  310. }
  311. if (isset($_POST['sessions_list_origin'])) {
  312. $origin_session = $_POST['sessions_list_origin'];
  313. }
  314. if ((is_array($arr_course_origin) && count($arr_course_origin) > 0) && !empty($destination_session)) {
  315. Display::display_normal_message(get_lang('ToExportLearnpathWithQuizYouHaveToSelectQuiz'));
  316. $course_origin = api_get_course_info($arr_course_origin[0]);
  317. $cb = new CourseBuilder('', $course_origin);
  318. $course = $cb->build($origin_session, $arr_course_origin[0]);
  319. //$hidden_fields['same_file_name_option'] = $_POST['same_file_name_option'];
  320. $hidden_fields['destination_course'] = $arr_course_destination[0];
  321. $hidden_fields['origin_course'] = $arr_course_origin[0];
  322. $hidden_fields['destination_session'] = $destination_session;
  323. $hidden_fields['origin_session'] = $origin_session;
  324. CourseSelectForm :: display_form($course, $hidden_fields, true);
  325. echo '<div style="float:right"><a href="javascript:window.back();">'.Display::return_icon('back.png', get_lang('Back').' '.get_lang('To').' '.get_lang('PlatformAdmin'), array('style' => 'vertical-align:middle')).get_lang('Back').'</a></div>';
  326. } else {
  327. Display::display_error_message(get_lang('You must select a course from original session and select a destination session'));
  328. display_form();
  329. }
  330. } else {
  331. display_form();
  332. }
  333. /* FOOTER */
  334. Display::display_footer();