special_exports.php 12 KB

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