special_exports.php 11 KB

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