special_exports.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. <?php
  2. /* For licensing terms, see /dokeos_license.txt */
  3. /**
  4. * ==============================================================================
  5. * Special exports
  6. *
  7. * @author Jhon Hinojosa <jhon.hinojosa@dokeos.com>
  8. * @package special.export
  9. * ==============================================================================
  10. */
  11. // name of the language file that needs to be included
  12. $language_file = array ('admin');
  13. // including the global file
  14. include ('../inc/global.inc.php');
  15. // setting the section (for the tabs)
  16. $this_section = SECTION_PLATFORM_ADMIN;
  17. // setting breadcrumbs
  18. $interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin'));
  19. // Access restrictions
  20. api_protect_admin_script(true);
  21. $nameTools = get_lang('SpecialExports');
  22. // include additional libraries
  23. require_once '../document/document.inc.php';
  24. // include additional libraries
  25. include_once(api_get_path(LIBRARY_PATH) . 'fileManage.lib.php');
  26. require_once ('../coursecopy/classes/CourseBuilder.class.php');
  27. require_once ('../coursecopy/classes/CourseArchiver.class.php');
  28. require_once ('../coursecopy/classes/CourseRestorer.class.php');
  29. require_once ('../coursecopy/classes/CourseSelectForm.class.php');
  30. if(function_exists('ini_set')) {
  31. ini_set('memory_limit','256M');
  32. ini_set('max_execution_time',0);
  33. }
  34. // Displaying the header
  35. Display::display_header($nameTools);
  36. // Display the tool title
  37. api_display_tool_title($nameTools);
  38. $error =0;
  39. /*
  40. ==============================================================================
  41. MAIN CODE
  42. ==============================================================================
  43. */
  44. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  45. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  46. if ((isset ($_POST['action']) && $_POST['action'] == 'course_select_form') || (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'full_backup')) {
  47. require_once api_get_path(LIBRARY_PATH).'document.lib.php';
  48. require_once api_get_path(LIBRARY_PATH).'pclzip/pclzip.lib.php';
  49. $export = false;
  50. if (isset ($_POST['action']) && $_POST['action'] == 'course_select_form') {
  51. $FileZip = create_zip();
  52. $to_group_id = 0;
  53. $code_course = '';
  54. $sql_session = "SELECT id, name FROM $tbl_session ";
  55. $query_session = Database::query($sql_session, __FILE__, __LINE__);
  56. $ListSession = array();
  57. while($rows_session = mysql_fetch_assoc($query_session)) {
  58. $ListSession[$rows_session['id']] = $rows_session['name'];
  59. }
  60. $zip_folder=new PclZip($FileZip['TEMP_FILE_ZIP']);
  61. if(!isset($_POST['resource']) || count($_POST['resource']) == 0 ) {
  62. Display::display_error_message(get_lang('ErrorMsgSpecialExport'));
  63. } else {
  64. $Resource = $_POST['resource'];
  65. foreach($Resource as $Code_course => $Sessions) {
  66. $_course = Database::get_course_info(Security::remove_XSS($Code_course));
  67. $tbl_document = Database::get_course_table(TABLE_DOCUMENT, $_course['db_name']);
  68. $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY, $_course['db_name']);
  69. //Add tem to the zip file course
  70. $sql = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props
  71. WHERE `props`.`tool`='".TOOL_DOCUMENT."'
  72. AND `docs`.`id`=`props`.`ref`
  73. AND `docs`.`path` LIKE '".$querypath."/%'
  74. AND `docs`.`filetype`='file'
  75. AND `docs`.`session_id` = '0'
  76. AND `props`.`visibility`<>'2'
  77. AND `props`.`to_group_id`=".$to_group_id."";
  78. $query = Database::query($sql ,__FILE__,__LINE__);
  79. while($rows_course_file = mysql_fetch_assoc($query)) {
  80. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory']."/document".$rows_course_file['path'],
  81. PCLZIP_OPT_ADD_PATH, $_course['directory'],
  82. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory']."/document".$FileZip['PATH_REMOVE']
  83. );
  84. }
  85. foreach($Sessions as $IdSession => $value){
  86. $session_id = Security::remove_XSS($IdSession);
  87. //Add tem to the zip file session course
  88. $sql_session_doc = "SELECT path FROM $tbl_document AS docs,$tbl_property AS props
  89. WHERE `props`.`tool`='".TOOL_DOCUMENT."'
  90. AND `docs`.`id`=`props`.`ref`
  91. AND `docs`.`path` LIKE '".$querypath."/%'
  92. AND `docs`.`filetype`='file'
  93. AND `docs`.`session_id` = '$session_id'
  94. AND `props`.`visibility`<>'2'
  95. AND `props`.`to_group_id`=".$to_group_id."";
  96. $query_session_doc = Database::query($sql_session_doc, __FILE__, __LINE__);
  97. while($rows_course_session_file = mysql_fetch_assoc($query_session_doc)) {
  98. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory'].'/document'.$rows_course_session_file['path'],
  99. PCLZIP_OPT_ADD_PATH, $_course['directory']."/".$ListSession[$session_id],
  100. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE']
  101. );
  102. }
  103. }
  104. }
  105. $name = rename_zip($FileZip);
  106. $export = true;
  107. }
  108. } else {
  109. $name = fullexportspecial();
  110. }
  111. ?>
  112. <!-- Manual download <script language="JavaScript">
  113. // setTimeout(\'download_backup()\',2000);
  114. function download_backup()
  115. {
  116. window.location="../course_info/download.php?archive=<?php echo $name; ?>&session=true";
  117. }
  118. </script> //-->
  119. <?php
  120. }
  121. function create_zip(){
  122. $path = '';
  123. if(empty($path)) { $path='/'; }
  124. $remove_dir = ($path!='/') ? substr($path,0,strlen($path) - strlen(basename($path))) : '/';
  125. $to_group_id = $_SESSION['_gid'];
  126. $sys_archive_path = api_get_path(SYS_ARCHIVE_PATH);
  127. $sys_course_path = api_get_path(SYS_COURSE_PATH);
  128. $temp_zip_dir = $sys_archive_path."temp";
  129. if(!is_dir($temp_zip_dir)) {
  130. mkdir($temp_zip_dir);
  131. } else {
  132. $handle=opendir($temp_zip_dir);
  133. while (false!==($file = readdir($handle))) {
  134. if ($file != "." && $file != "..") {
  135. $Diff = (time() - filemtime("$temp_zip_dir/$file"))/60/60; //the "age" of the file in hours
  136. if ($Diff > 4) unlink("$temp_zip_dir/$file"); //delete files older than 4 hours
  137. }
  138. }
  139. closedir($handle);
  140. }
  141. $temp_zip_file = $temp_zip_dir."/".md5(time()).".zip"; //create zipfile of given directory
  142. return array('PATH' => $path,
  143. 'PATH_TEMP_ARCHIVE' => $temp_zip_dir,
  144. 'PATH_COURSE' => $sys_course_path,
  145. 'TEMP_FILE_ZIP' => $temp_zip_file,
  146. 'PATH_REMOVE' => $remove_dir);
  147. }
  148. function rename_zip($FileZip) {
  149. event_download(($FileZip['PATH'] == '/')?'full_export_'.date('Ymd').'.zip (folder)': basename($FileZip['PATH']).'.zip (folder)');
  150. $name = ($FileZip['PATH']=='/')? 'full_export_'.date('Ymd').'.zip':basename($FileZip['PATH']).'.zip';
  151. if(file_exists($FileZip['PATH_TEMP_ARCHIVE'].'/'.$name)){ unlink($FileZip['PATH_TEMP_ARCHIVE'].'/'.$name); }
  152. if(file_exists($FileZip['TEMP_FILE_ZIP'])) {
  153. rename($FileZip['TEMP_FILE_ZIP'], $FileZip['PATH_TEMP_ARCHIVE'].'/'.$name);
  154. return $name;
  155. } else { return false; }
  156. }
  157. function fullexportspecial(){
  158. global $tbl_session, $tbl_session_course, $export;
  159. $FileZip = create_zip();
  160. $to_group_id = 0;
  161. $code_course = '';
  162. $list_course = array();
  163. $zip_folder = new PclZip($FileZip['TEMP_FILE_ZIP']);
  164. $list_course = Database::get_course_list();
  165. if(count($list_course) >0 ) {
  166. foreach($list_course as $_course) {
  167. if($FileZip['PATH'] == '/') {
  168. $querypath=''; // to prevent ...path LIKE '//%'... in query
  169. } else {
  170. $querypath = $FileZip['PATH'];
  171. }
  172. $tbl_document = Database::get_course_table(TABLE_DOCUMENT, $_course['db_name']);
  173. $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY, $_course['db_name']);
  174. //Add tem to the zip file course
  175. $sql = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props
  176. WHERE `props`.`tool`='".TOOL_DOCUMENT."'
  177. AND `docs`.`id`=`props`.`ref`
  178. AND `docs`.`path` LIKE '".$querypath."/%'
  179. AND `docs`.`filetype`='file'
  180. AND `docs`.`session_id` = '0'
  181. AND `props`.`visibility`<>'2'
  182. AND `props`.`to_group_id`=".$to_group_id."";
  183. $query = Database::query($sql ,__FILE__,__LINE__);
  184. while($rows_course_file = mysql_fetch_assoc($query)) {
  185. $rows_course_file['path'];
  186. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory']."/document".$rows_course_file['path'],
  187. PCLZIP_OPT_ADD_PATH, $_course['directory'],
  188. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory']."/document".$FileZip['PATH_REMOVE']
  189. );
  190. }
  191. //Add tem to the zip file session course
  192. $code_course = $_course['code'];
  193. $sql_session = "SELECT id, name, course_code FROM $tbl_session_course
  194. INNER JOIN $tbl_session ON id_session = id
  195. WHERE course_code = '$code_course' ";
  196. $query_session = Database::query($sql_session, __FILE__, __LINE__);
  197. while($rows_session = mysql_fetch_assoc($query_session)) {
  198. $session_id = $rows_session['id'];
  199. $sql_session_doc = "SELECT path FROM $tbl_document AS docs,$tbl_property AS props
  200. WHERE `props`.`tool`='".TOOL_DOCUMENT."'
  201. AND `docs`.`id`=`props`.`ref`
  202. AND `docs`.`path` LIKE '".$querypath."/%'
  203. AND `docs`.`filetype`='file'
  204. AND `docs`.`session_id` = '$session_id'
  205. AND `props`.`visibility`<>'2'
  206. AND `props`.`to_group_id`=".$to_group_id."";
  207. $query_session_doc = Database::query($sql_session_doc, __FILE__, __LINE__);
  208. while($rows_course_session_file = mysql_fetch_assoc($query_session_doc)) {
  209. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory'].'/document'.$rows_course_session_file['path'],
  210. PCLZIP_OPT_ADD_PATH, $_course['directory']."/".$rows_session['name'],
  211. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE']
  212. );
  213. }
  214. }
  215. }
  216. $name = rename_zip($FileZip);
  217. if($name === false){
  218. $export = false;
  219. return false;
  220. }else{
  221. $export = true;
  222. return $name;
  223. }
  224. }else{
  225. Display::display_error_message(get_lang('ErrorMsgSpecialExport')); //main API
  226. $export = false;
  227. return false;
  228. }
  229. }
  230. if($export == true && $name != false) {
  231. Display::display_confirmation_message(get_lang('BackupCreated').'<br /><br /><a class="bottom-link" href="'.api_get_path(WEB_CODE_PATH).'course_info/download.php?archive='.urlencode($name).'&session=true">'.$name.'</a>', false);
  232. echo '<p><a class="bottom-link" href="'.api_get_path(WEB_CODE_PATH).'admin/index.php">&nbsp;'.get_lang('MainMenu').'</a></p>';
  233. } else{
  234. // Display forms especial export
  235. if (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'select_items') {
  236. $cb = new CourseBuilder();
  237. $course = $cb->build_session_course();
  238. if($course === false){
  239. Display::display_error_message(get_lang('ErrorMsgSpecialExport'));
  240. form_special_export();
  241. } else {
  242. Display::display_normal_message(get_lang('ToExportSpecialSelect'));
  243. CourseSelectForm :: display_form_session_export($course);
  244. }
  245. } else {
  246. form_special_export();
  247. }
  248. }
  249. function form_special_export(){
  250. $htlm = get_lang('SelectOptionExport');
  251. include_once (api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php');
  252. $form = new FormValidator('special_exports','post');
  253. $renderer = $form->defaultRenderer();
  254. $renderer->setElementTemplate('<div>{element}</div> ');
  255. $form->addElement('radio', 'backup_option', '', get_lang('SpecialCreateFullBackup'), 'full_backup');
  256. $form->addElement('radio', 'backup_option', '', get_lang('SpecialLetMeSelectItems'), 'select_items');
  257. $form->addElement('html','<br />');
  258. $form->addElement('style_submit_button', null, get_lang('CreateBackup'), 'class="save"');
  259. $form->add_progress_bar();
  260. $values['backup_option'] = 'full_backup';
  261. $form->setDefaults($values);
  262. $form->display();
  263. }
  264. /*
  265. ==============================================================================
  266. FOOTER
  267. ==============================================================================
  268. */
  269. Display::display_footer();
  270. ?>