special_exports.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
  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 chamilo.include.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($Code_course);
  66. $tbl_document = Database::get_course_table(TABLE_DOCUMENT);
  67. $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
  68. $course_id = $_course['real_id'];
  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." AND docs.c_id = $course_id AND props.c_id = $course_id";
  78. $query = Database::query($sql );
  79. while ($rows_course_file = Database::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);
  97. while ($rows_course_session_file = Database::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. if ($export && $name) {
  122. Display::display_confirmation_message(get_lang('BackupCreated'));
  123. 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>';
  124. } else {
  125. // Display forms especial export
  126. if (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'select_items') {
  127. $cb = new CourseBuilder();
  128. $course = $cb->build_session_course();
  129. if($course === false){
  130. Display::display_error_message(get_lang('ErrorMsgSpecialExport'));
  131. form_special_export();
  132. } else {
  133. Display::display_normal_message(get_lang('ToExportSpecialSelect'));
  134. CourseSelectForm :: display_form_session_export($course);
  135. }
  136. } else {
  137. form_special_export();
  138. }
  139. }
  140. /* FOOTER */
  141. Display::display_footer();
  142. function form_special_export() {
  143. $htlm = get_lang('SelectOptionExport');
  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. $tbl_document = Database::get_course_table(TABLE_DOCUMENT);
  201. $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
  202. if (count($list_course) >0 ) {
  203. foreach($list_course as $_course) {
  204. if($FileZip['PATH'] == '/') {
  205. $querypath=''; // to prevent ...path LIKE '//%'... in query
  206. } else {
  207. $querypath = $FileZip['PATH'];
  208. }
  209. $course_id = $_course['real_id'];
  210. //Add tem to the zip file course
  211. $sql = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props
  212. WHERE props.tool='".TOOL_DOCUMENT."'
  213. AND docs.id=props.ref
  214. AND docs.path LIKE '".$querypath."/%'
  215. AND docs.filetype='file'
  216. AND docs.session_id = '0'
  217. AND props.visibility<>'2'
  218. AND props.to_group_id=".$to_group_id." AND docs.c_id = $course_id AND props.c_id = $course_id";
  219. $query = Database::query($sql );
  220. while ($rows_course_file = Database::fetch_assoc($query)) {
  221. $rows_course_file['path'];
  222. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory']."/document".$rows_course_file['path'],
  223. PCLZIP_OPT_ADD_PATH, $_course['directory'],
  224. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory']."/document".$FileZip['PATH_REMOVE']
  225. );
  226. }
  227. //Add tem to the zip file session course
  228. $code_course = $_course['code'];
  229. $sql_session = "SELECT id, name, course_code FROM $tbl_session_course
  230. INNER JOIN $tbl_session ON id_session = id
  231. WHERE course_code = '$code_course' ";
  232. $query_session = Database::query($sql_session);
  233. while ($rows_session = Database::fetch_assoc($query_session)) {
  234. $session_id = $rows_session['id'];
  235. $sql_session_doc = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props
  236. WHERE props.tool='".TOOL_DOCUMENT."'
  237. AND docs.id=props.ref
  238. AND docs.path LIKE '".$querypath."/%'
  239. AND docs.filetype='file'
  240. AND docs.session_id = '$session_id'
  241. AND props.visibility<>'2'
  242. AND props.to_group_id=".$to_group_id." AND docs.c_id = $course_id AND props.c_id = $course_id ";
  243. $query_session_doc = Database::query($sql_session_doc);
  244. while ($rows_course_session_file = Database::fetch_assoc($query_session_doc)) {
  245. $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory'].'/document'.$rows_course_session_file['path'],
  246. PCLZIP_OPT_ADD_PATH, $_course['directory']."/".$rows_session['name'],
  247. PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE']
  248. );
  249. }
  250. }
  251. }
  252. $name = rename_zip($FileZip);
  253. if($name === false){
  254. $export = false;
  255. return false;
  256. }else{
  257. $export = true;
  258. return $name;
  259. }
  260. }else{
  261. Display::display_error_message(get_lang('ErrorMsgSpecialExport')); //main API
  262. $export = false;
  263. return false;
  264. }
  265. }