special_exports.php 12 KB

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