dolibarr  19.0.0-dev
dolibarr_export.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2006-2018 Laurent Destailleur <eldy@users.sourceforge.net>
3  * Copyright (C) 2006-2021 Regis Houssin <regis.houssin@inodbox.com>
4  *
5  * This program is free software; you can redistribute it and/or modify
6  * it under the terms of the GNU General Public License as published by
7  * the Free Software Foundation; either version 3 of the License, or
8  * (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13  * GNU General Public License for more details.
14  *
15  * You should have received a copy of the GNU General Public License
16  * along with this program. If not, see <https://www.gnu.org/licenses/>.
17  */
18 
25 // Load Dolibarr environment
26 require '../../main.inc.php';
27 require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
28 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
29 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
30 
31 $langs->load("admin");
32 
33 $action = GETPOST('action', 'aZ09');
34 
35 $sortfield = GETPOST('sortfield', 'aZ09comma');
36 $sortorder = GETPOST('sortorder', 'aZ09comma');
37 $page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
38 if (!$sortorder) {
39  $sortorder = "DESC";
40 }
41 if (!$sortfield) {
42  $sortfield = "date";
43 }
44 if (empty($page) || $page == -1) {
45  $page = 0;
46 }
47 $limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;
48 $offset = $limit * $page;
49 
50 if (!$user->admin) {
51  accessforbidden();
52 }
53 
54 
55 /*
56  * Actions
57  */
58 
59 if ($action == 'deletefile') {
60  if (preg_match('/^backup\//', GETPOST('urlfile', 'alpha'))) {
61  $file = $conf->admin->dir_output.'/backup/'.basename(GETPOST('urlfile', 'alpha'));
62  $ret = dol_delete_file($file, 1);
63  if ($ret) {
64  setEventMessages($langs->trans("FileWasRemoved", GETPOST('urlfile')), null, 'mesgs');
65  } else {
66  setEventMessages($langs->trans("ErrorFailToDeleteFile", GETPOST('urlfile')), null, 'errors');
67  }
68  } else {
69  $file = $conf->admin->dir_output.'/documents/'.basename(GETPOST('urlfile', 'alpha'));
70  $ret = dol_delete_file($file, 1);
71  if ($ret) {
72  setEventMessages($langs->trans("FileWasRemoved", GETPOST('urlfile')), null, 'mesgs');
73  } else {
74  setEventMessages($langs->trans("ErrorFailToDeleteFile", GETPOST('urlfile')), null, 'errors');
75  }
76  }
77  $action = '';
78 }
79 
80 
81 /*
82  * View
83  */
84 
85 $form = new Form($db);
86 $formfile = new FormFile($db);
87 
88 $label = $db::LABEL;
89 $type = $db->type;
90 //var_dump($db);
91 
92 $help_url = 'EN:Backups|FR:Sauvegardes|ES:Copias_de_seguridad';
93 llxHeader('', '', $help_url);
94 
95 print '<script type="text/javascript">
96 jQuery(document).ready(function() {';
97 ?>
98 
99  function hideoptions () {
100  jQuery("#mysql_options").hide();
101  jQuery("#mysql_nobin_options").hide();
102  jQuery("#postgresql_options").hide();
103  }
104 
105  hideoptions();
106  jQuery("#radio_dump_mysql").click(function() {
107  hideoptions();
108  jQuery("#mysql_options").show();
109  });
110  jQuery("#radio_dump_mysql_nobin").click(function() {
111  hideoptions();
112  jQuery("#mysql_nobin_options").show();
113  });
114  jQuery("#radio_dump_postgresql").click(function() {
115  hideoptions();
116  jQuery("#postgresql_options").show();
117  });
118  jQuery("#select_sql_compat").click(function() {
119  if (jQuery("#select_sql_compat").val() == 'POSTGRESQL')
120  {
121  jQuery("#checkbox_dump_disable-add-locks").prop('checked',true);
122  }
123  });
124 
125 <?php
126 if (in_array($type, array('mysql', 'mysqli'))) {
127  print 'jQuery("#radio_dump_mysql").click();';
128 }
129 if (in_array($type, array('pgsql'))) {
130  print 'jQuery("#radio_dump_postgresql").click();';
131 }
132 print "});\n";
133 print "</script>\n";
134 
135 $title = $langs->trans("Backup");
136 
137 print load_fiche_titre($title, '', 'title_setup');
138 //print_barre_liste($langs->trans("Backup"), '', '', '', '', '', $langs->trans("BackupDesc",DOL_DATA_ROOT), 0, 0, 'title_setup');
139 
140 print '<div class="center">';
141 print $langs->trans("BackupDesc", DOL_DATA_ROOT);
142 print '</div>';
143 print '<br>';
144 
145 print "<!-- Dump of a server -->\n";
146 print '<form method="post" action="export.php" name="dump">';
147 print '<input type="hidden" name="token" value="'.newToken().'" />';
148 print '<input type="hidden" name="export_type" value="server" />';
149 print '<input type="hidden" name="page_y" value="" />';
150 
151 print '<fieldset id="fieldsetexport"><legend class="legendforfieldsetstep" style="font-size: 3em">1</legend>';
152 
153 print '<span class="opacitymedium">';
154 print $langs->trans("BackupDesc3", $dolibarr_main_db_name).'<br>';
155 //print $langs->trans("BackupDescY").'<br>';
156 print '</span>';
157 
158 print '<br>';
159 
160 print '<div id="backupdatabaseleft" class="fichehalfleft" >';
161 
162 $title = $langs->trans("BackupDumpWizard");
163 
164 print load_fiche_titre($title);
165 
166 //print '<table class="liste nohover centpercent noborderbottom">';
167 //print '<tr class="liste_titre">';
168 //print '<td class="liste_titre">';
169 print '<span class="opacitymedium">'.$langs->trans("DatabaseName").' : </span><b>'.$dolibarr_main_db_name.'</b><br><br>';
170 //print '</td>';
171 //print '</tr>';
172 //print '<tr class="oddeven nohover"><td class="nohover">';
173 
174 print '<table class="centpercent noborderbottom">';
175 
176 print '<tr>';
177 print '<td class="tdtop nopaddingleftimp">';
178 
179 print '<div id="div_container_exportoptions">';
180 print '<fieldset id="exportoptions"><legend>'.$langs->trans("ExportMethod").'</legend>';
181 if (in_array($type, array('mysql', 'mysqli'))) {
182  print '<div class="formelementrow"><input type="radio" name="what" value="mysql" id="radio_dump_mysql" />';
183  print '<label for="radio_dump_mysql">MySQL Dump (mysqldump)</label>';
184  print '</div>';
185  print '<br>';
186  print '<div class="formelementrow"><input type="radio" name="what" value="mysqlnobin" id="radio_dump_mysql_nobin" />';
187  print '<label for="radio_dump_mysql_nobin">MySQL Dump (php) '.img_warning($langs->trans('BackupPHPWarning')).'</label>';
188  print '</div>';
189 } elseif (in_array($type, array('pgsql'))) {
190  print '<div class="formelementrow"><input type="radio" name="what" value="postgresql" id="radio_dump_postgresql" />';
191  print '<label for="radio_dump_postgresql">PostgreSQL Dump (pg_dump)</label>';
192  print '</div>';
193 } else {
194  print 'No method available with database '.$label;
195 }
196 print '</fieldset>';
197 print '</div>';
198 
199 print '</td>';
200 print '</tr>';
201 
202 print '<tr>';
203 print '<td class="tdtop nopaddingleftimp">';
204 
205 print '<div class="centpercent center margintoponly marginbottomonly">';
206 print img_picto('', 'setup', 'class="pictofixedwidth"').'<a id="lnk">'.$langs->trans("ShowAdvancedOptions").'...</a>';
207 print '</div>';
208 
209 print '<script type="text/javascript">
210 jQuery(document).ready(function() {
211  jQuery("#lnk").click(function() {
212  console.log("We click on link");
213  hideoptions(this);
214  });
215 });
216 
217 function hideoptions(domelem) {
218  const div = document.getElementById("div_container_sub_exportoptions");
219 
220  if (div.style.display === "none") {
221  div.style.display = "block";
222  domelem.innerText="'.dol_escape_js($langs->transnoentitiesnoconv("HideAdvancedoptions")).'";
223  } else {
224  div.style.display = "none";
225  domelem.innerText="'.dol_escape_js($langs->transnoentitiesnoconv("ShowAdvancedOptions")).'...";
226  }
227 }
228 </script>';
229 
230 
231 print '<div id="div_container_sub_exportoptions" style="display: none;">';
232 
233 if (in_array($type, array('mysql', 'mysqli'))) {
234  print "<!-- Fieldset mysqldump -->\n";
235  print '<fieldset id="mysql_options">';
236 
237  print '<fieldset class="formelementrow"><legend>'.$langs->trans("FullPathToMysqldumpCommand").'</legend>';
238  if (empty($conf->global->SYSTEMTOOLS_MYSQLDUMP)) {
239  $fullpathofmysqldump = $db->getPathOfDump();
240  } else {
241  $fullpathofmysqldump = $conf->global->SYSTEMTOOLS_MYSQLDUMP;
242  }
243  print '<input type="text" name="mysqldump" style="width: 80%" value="'.$fullpathofmysqldump.'">';
244  print '</fieldset>';
245 
246  print '<br>';
247  print '<fieldset><legend>'.$langs->trans("ExportOptions").'</legend>';
248 
249  if (!empty($conf->global->MYSQL_OLD_OPTION_DISABLE_FK)) {
250  print '<div class="formelementrow">';
251  print '<input type="checkbox" name="disable_fk" value="yes" id="checkbox_disable_fk" checked>';
252  print '<label for="checkbox_disable_fk">'.$langs->trans("CommandsToDisableForeignKeysForImport").' '.img_info($langs->trans('CommandsToDisableForeignKeysForImportWarning')).'</label>';
253  print '</div>';
254  }
255 
256  print '<label for="select_sql_compat">'.$langs->trans("ExportCompatibility").'</label>';
257 
258  print '<select name="sql_compat" id="select_sql_compat" class="flat">';
259  print '<option value="NONE" selected>NONE</option>';
260  print '<option value="ANSI">ANSI</option>';
261  print '<option value="DB2">DB2</option>';
262  print '<option value="MAXDB">MAXDB</option>';
263  print '<option value="MYSQL323">MYSQL323</option>';
264  print '<option value="MYSQL40">MYSQL40</option>';
265  print '<option value="MSSQL">MSSQL</option>';
266  print '<option value="ORACLE">ORACLE</option>';
267  print '<option value="POSTGRESQL">POSTGRESQL</option>';
268  print '</select>';
269  print '<br><br>';
270 
271  print '<div class="formelementrow">';
272  print '<input type="checkbox" name="use_transaction" value="yes" id="checkbox_use_transaction" checked="checked">';
273  print '<label for="checkbox_use_transaction">'.$langs->trans("UseTransactionnalMode").'</label>';
274  print '</div>';
275 
276  print '<input type="checkbox" name="use_mysql_quick_param" value="yes" id="checkbox_use_quick" checked="checked" />';
277  print '<label for="checkbox_use_quick">';
278  print $form->textwithpicto($langs->trans('ExportUseMySQLQuickParameter'), $langs->trans('ExportUseMySQLQuickParameterHelp'));
279  print '</label>';
280  print '<br>';
281 
282  $execmethod = 0;
283  if (!empty($conf->global->MAIN_EXEC_USE_POPEN)) {
284  $execmethod = $conf->global->MAIN_EXEC_USE_POPEN;
285  }
286  if (empty($execmethod)) {
287  $execmethod = 1;
288  }
289  if ($execmethod == 1) {
290  // If we use the "exec" method for shell, we ask if we need to use the alternative low memory exec mode.
291  print '<input type="checkbox" name="lowmemorydump" value="yes" id="lowmemorydump"'.((GETPOSTISSET('lowmemorydump') ? GETPOST('lowmemorydump', 'alpha') : getDolGlobalString('MAIN_LOW_MEMORY_DUMP')) ? ' checked="checked"' : '').'" />';
292  print '<label for="lowmemorydump">';
293  print $form->textwithpicto($langs->trans('ExportUseLowMemoryMode'), $langs->trans('ExportUseLowMemoryModeHelp'));
294  print '</label>';
295  print '<br>';
296  }
297 
298  print '<!-- <input type="checkbox" name="drop_database" value="yes" id="checkbox_drop_database" />';
299  print '<label for="checkbox_drop_database">'.$langs->trans("AddDropDatabase").'</label>';
300  print '-->';
301  print '</fieldset>';
302 
303  print '<br>';
304  print '<fieldset>';
305  print '<legend>';
306  print '<input type="checkbox" name="sql_structure" value="structure" id="checkbox_sql_structure" checked />';
307  print '<label for="checkbox_sql_structure">'.$langs->trans('ExportStructure').'</label>';
308  print '</legend>';
309 
310  print '<input type="checkbox" name="drop"'.((!GETPOSTISSET("drop") || GETPOST('drop')) ? ' checked' : '').' id="checkbox_dump_drop" />';
311  print '<label for="checkbox_dump_drop">'.$langs->trans("AddDropTable").'</label>';
312  print '<br>';
313  print '</fieldset>';
314 
315  print '<br>';
316  print '<fieldset>';
317  print '<legend>';
318  print '<input type="checkbox" name="sql_data" value="data" id="checkbox_sql_data" checked />';
319  print '<label for="checkbox_sql_data">'.$langs->trans("Datas").'</label>';
320  print '</legend>';
321  print '<input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" checked />';
322  print '<label for="checkbox_dump_showcolumns">'.$langs->trans("NameColumn").'</label>';
323  print '<br>';
324 
325  print '<input type="checkbox" name="extended_ins" value="yes" id="checkbox_dump_extended_ins" checked />';
326  print '<label for="checkbox_dump_extended_ins">'.$langs->trans("ExtendedInsert").'</label>';
327  print '<br>';
328 
329  print '<input type="checkbox" name="disable-add-locks" value="no" id="checkbox_dump_disable-add-locks" />';
330  print '<label for="checkbox_dump_disable-add-locks">'.$langs->trans("NoLockBeforeInsert").'</label>';
331  print '<br>';
332 
333  print '<input type="checkbox" name="delayed" value="yes" id="checkbox_dump_delayed" />';
334  print '<label for="checkbox_dump_delayed">'.$langs->trans("DelayedInsert").'</label>';
335  print '<br>';
336 
337  print '<input type="checkbox" name="sql_ignore" value="yes" id="checkbox_dump_ignore" />';
338  print '<label for="checkbox_dump_ignore">'.$langs->trans("IgnoreDuplicateRecords").'</label>';
339  print '<br>';
340 
341  print '<input type="checkbox" name="hexforbinary" value="yes" id="checkbox_hexforbinary" checked />';
342  print '<label for="checkbox_hexforbinary">'.$langs->trans("EncodeBinariesInHexa").'</label>';
343  print '<br>';
344 
345  print '<input type="checkbox" name="charset_utf8" value="yes" id="checkbox_charset_utf8" checked disabled />';
346  print '<label for="checkbox_charset_utf8">'.$langs->trans("UTF8").'</label>';
347  print '<br>';
348 
349  print '</fieldset>';
350  print '</fieldset>';
351 
352  // Export mysql bin
353  print "<!-- Fieldset mysql_nobin -->\n";
354  print '<fieldset id="mysql_nobin_options">';
355 
356  print '<fieldset>';
357  print '<legend>'.$langs->trans("ExportOptions").'</legend>';
358 
359  print '<div class="formelementrow">';
360  print '<input type="checkbox" name="nobin_use_transaction" value="yes" id="checkbox_use_transaction" />';
361  print '<label for="checkbox_use_transaction">'.$langs->trans("UseTransactionnalMode").'</label>';
362  print '</div>';
363 
364  if (!empty($conf->global->MYSQL_OLD_OPTION_DISABLE_FK)) {
365  print '<div class="formelementrow">';
366  print '<input type="checkbox" name="nobin_disable_fk" value="yes" id="checkbox_disable_fk" checked />';
367  print '<label for="checkbox_disable_fk">'.$langs->trans("CommandsToDisableForeignKeysForImport").' '.img_info($langs->trans('CommandsToDisableForeignKeysForImportWarning')).'</label>';
368  print '</div>';
369  }
370  print '</fieldset>';
371 
372  print '<br>';
373  print '<fieldset><legend>'.$langs->trans('ExportStructure').'</legend>';
374  print '<input type="checkbox" name="nobin_drop"'.((!GETPOSTISSET("nobin_drop") || GETPOST('nobin_drop')) ? ' checked' : '').' id="checkbox_dump_drop" />';
375  print '<label for="checkbox_dump_drop">'.$langs->trans("AddDropTable").'</label>';
376  print '<br>';
377  print '</fieldset>';
378 
379  print '<br>';
380  print '<fieldset>';
381  print '<legend>'.$langs->trans("Datas").'</legend>';
382 
383  print '<input type="checkbox" name="nobin_nolocks" value="no" id="checkbox_dump_disable-add-locks" />';
384  print '<label for="checkbox_dump_disable-add-locks">'.$langs->trans("NoLockBeforeInsert").'</label>';
385  print '<br>';
386 
387  print '<input type="checkbox" name="nobin_delayed" value="yes" id="checkbox_dump_delayed" />';
388  print '<label for="checkbox_dump_delayed">'.$langs->trans("DelayedInsert").'</label>';
389  print '<br>';
390 
391  print '<input type="checkbox" name="nobin_sql_ignore" value="yes" id="checkbox_dump_ignore" />';
392  print '<label for="checkbox_dump_ignore">'.$langs->trans("IgnoreDuplicateRecords").'</label>';
393  print '<br>';
394 
395  print '<input type="checkbox" name="nobin_charset_utf8" value="yes" id="checkbox_charset_utf8" checked disabled />';
396  print '<label for="checkbox_charset_utf8">'.$langs->trans("UTF8").'</label>';
397  print '<br>';
398 
399  print '</fieldset>';
400  print '</fieldset>';
401 }
402 
403 if (in_array($type, array('pgsql'))) {
404  print "<!-- Fieldset pg_dump -->\n";
405  print '<fieldset id="postgresql_options">';
406 
407 
408  print '<fieldset class="formelementrow"><legend>'.$langs->trans("FullPathToPostgreSQLdumpCommand").'</legend>';
409  if (empty($conf->global->SYSTEMTOOLS_POSTGRESQLDUMP)) {
410  $fullpathofpgdump = $db->getPathOfDump();
411  } else {
412  $fullpathofpgdump = $conf->global->SYSTEMTOOLS_POSTGRESQLDUMP;
413  }
414  print '<br>';
415  print '<input type="text" name="postgresqldump" style="width: 80%" value="'.$fullpathofpgdump.'" />';
416  print '</fieldset>';
417 
418  print '<br>';
419  print '<fieldset>';
420  print '<legend>'.$langs->trans("ExportOptions").'</legend>';
421  print '<label for="select_sql_compat">'.$langs->trans("ExportCompatibility").'</label>';
422  print '<select name="sql_compat" id="select_sql_compat" class="flat">';
423  print '<option value="POSTGRESQL" selected>POSTGRESQL</option>';
424  print '<option value="ANSI">ANSI</option>';
425  print '</select>';
426  print '<br>';
427  print '<!-- <input type="checkbox" name="drop_database" value="yes" id="checkbox_drop_database" />';
428  print '<label for="checkbox_drop_database">'.$langs->trans("AddDropDatabase").'</label>';
429  print '-->';
430  print '</fieldset>';
431  print '<br>';
432  print '<fieldset>';
433  print '<legend>';
434  print '<input type="checkbox" name="sql_structure" value="structure" id="checkbox_sql_structure" checked />';
435  print '<label for="checkbox_sql_structure">'.$langs->trans('ExportStructure').'</label>';
436  print '</legend>';
437  print '</fieldset>';
438  print '<br>';
439  print '<fieldset>';
440  print '<legend>';
441  print '<input type="checkbox" name="sql_data" value="data" id="checkbox_sql_data" checked />';
442  print '<label for="checkbox_sql_data">'.$langs->trans("Datas").'</label>';
443  print '</legend>';
444  print '<input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" checked />';
445  print '<label for="checkbox_dump_showcolumns">'.$langs->trans("NameColumn").'</label>';
446  print '<br>';
447  print '</fieldset>';
448  print '</fieldset>';
449 }
450 print '</div>';
451 
452 print '</td>';
453 print '</tr>';
454 print '</table>';
455 
456 
457 
458 
459 print '<!--<fieldset>';
460 print '<legend>'.$langs->trans("Destination").'</legend> -->';
461 print '<br>';
462 print '<label for="filename_template" class="line-height-large opacitymedium">'.$langs->trans("FileNameToGenerate").'</label>';
463 print '<br>';
464 $prefix = 'dump';
465 $ext = '.sql';
466 if (in_array($type, array('mysql', 'mysqli'))) {
467  $prefix = 'mysqldump';
468  $ext = 'sql';
469 }
470 //if ($label == 'PostgreSQL') {
471 // $prefix='pg_dump';
472 // $ext='dump';
473 //}
474 if (in_array($type, array('pgsql'))) {
475  $prefix = 'pg_dump';
476  $ext = 'sql';
477 }
478 $file = $prefix.'_'.$dolibarr_main_db_name.'_'.dol_sanitizeFileName(DOL_VERSION).'_'.dol_print_date(dol_now('gmt'), "dayhourlogsmall", 'tzuser').'.'.$ext;
479 print '<input type="text" name="filename_template" style="width: 90%" id="filename_template" value="'.$file.'" />';
480 print '<br>';
481 print '<br>';
482 
483 // Define compressions array
484 $compression = array();
485 if (in_array($type, array('mysql', 'mysqli'))) {
486  $compression['gz'] = array(
487  'function' => 'gzopen',
488  'id' => 'radio_compression_gzip',
489  'label' => $langs->trans("Gzip")
490  );
491  // Not open source format. Must implement dol_compress function
492  // $compression['zip']= array(
493  // 'function' => 'dol_compress',
494  // 'id' => 'radio_compression_zip',
495  // 'label' => $langs->trans("FormatZip")
496  // );
497  $compression['bz'] = array(
498  'function' => 'bzopen',
499  'id' => 'radio_compression_bzip',
500  'label' => $langs->trans("Bzip2")
501  );
502  $compression['zstd'] = array(
503  'function' => 'zstd_compress',
504  'id' => 'radio_compression_zstd',
505  'label' => $langs->trans("Zstd")
506  );
507  $compression['none'] = array(
508  'function' => '',
509  'id' => 'radio_compression_none',
510  'label' => $langs->trans("None")
511  );
512 } else {
513  $compression['none'] = array(
514  'function' => '',
515  'id' => 'radio_compression_none',
516  'label' => $langs->trans("None")
517  );
518  $compression['gz'] = array(
519  'function' => 'gzopen',
520  'id' => 'radio_compression_gzip',
521  'label' => $langs->trans("Gzip")
522  );
523 }
524 
525 // Show compression choices
526 print '<div class="formelementrow">';
527 print "\n";
528 
529 print $langs->trans("Compression").': &nbsp; ';
530 
531 $i = 0;
532 foreach ($compression as $key => $val) {
533  if (!$val['function'] || function_exists($val['function'])) {
534  // Enabled export format
535  $checked = '';
536  if ($key == 'gz') {
537  $checked = ' checked';
538  }
539  print '<input type="radio" name="compression" value="'.$key.'" id="'.$val['id'].'"'.$checked.'>';
540  print ' <label for="'.$val['id'].'">'.$val['label'].'</label>';
541  } else {
542  // Disabled export format
543  print '<input type="radio" name="compression" value="'.$key.'" id="'.$val['id'].'" disabled>';
544  print ' <label for="'.$val['id'].'">'.$val['label'].'</label>';
545  print ' <span class="opacitymedium">('.$langs->trans("NotAvailable").')</span>';
546  }
547  print ' &nbsp; &nbsp; ';
548  $i++;
549 }
550 
551 print '</div>';
552 print "\n";
553 
554 print "<!--</fieldset>--> <!-- End destination -->\n";
555 
556 print '<br>';
557 print '<div class="center">';
558 print '<input type="submit" class="button reposition" value="'.$langs->trans("GenerateBackup").'" id="buttonGo">';
559 print '<br>';
560 print '<br>';
561 
562 if (!empty($_SESSION["commandbackuplastdone"])) {
563  print '<br><b>'.$langs->trans("RunCommandSummary").':</b><br>'."\n";
564  print '<textarea rows="'.ROWS_2.'" class="centpercent">'.$_SESSION["commandbackuplastdone"].'</textarea><br>'."\n";
565  print '<br>';
566 
567  //print $paramclear;
568 
569  // Now show result
570  print '<b>'.$langs->trans("BackupResult").':</b> ';
571  print $_SESSION["commandbackupresult"];
572 
573  $_SESSION["commandbackuplastdone"] = '';
574  $_SESSION["commandbackuptorun"] = '';
575  $_SESSION["commandbackupresult"] = '';
576 }
577 if (!empty($_SESSION["commandbackuptorun"])) {
578  print '<br><span class="warning">'.$langs->trans("YouMustRunCommandFromCommandLineAfterLoginToUser", $dolibarr_main_db_user, $dolibarr_main_db_user).':</span><br>'."\n";
579  print '<textarea id="commandbackuptoruntext" rows="'.ROWS_2.'" class="centpercent">'.$_SESSION["commandbackuptorun"].'</textarea><br>'."\n";
580  print ajax_autoselect("commandbackuptoruntext", 0);
581  print '<br>';
582 
583  //print $paramclear;
584 
585  $_SESSION["commandbackuplastdone"] = '';
586  $_SESSION["commandbackuptorun"] = '';
587  $_SESSION["commandbackupresult"] = '';
588 }
589 
590 print "</div> <!-- end div center button -->\n";
591 
592 //print '</td></tr>';
593 //print '</table>';
594 
595 print "</div> <!-- end div fichehalfleft -->\n";
596 
597 
598 print '<div id="backupdatabaseright" class="fichehalfright">';
599 
600 $filearray = dol_dir_list($conf->admin->dir_output.'/backup', 'files', 0, '', '', $sortfield, (strtolower($sortorder) == 'asc' ?SORT_ASC:SORT_DESC), 1);
601 $result = $formfile->list_of_documents($filearray, null, 'systemtools', '', 1, 'backup/', 1, 0, $langs->trans("NoBackupFileAvailable"), 0, $langs->trans("PreviousDumpFiles"), '', 0, -1, '', '', 'ASC', 1, 0, -1, 'style="height:250px; overflow: auto;"');
602 print '<br>';
603 
604 print '</div>';
605 print '</form>';
606 print '</fieldset>';
607 
608 
609 $title = $langs->trans("BackupZipWizard");
610 
611 print "<br>\n";
612 print "<!-- Dump of a server -->\n";
613 
614 print '<form method="post" action="export_files.php" name="dump">';
615 print '<input type="hidden" name="token" value="'.newToken().'" />';
616 print '<input type="hidden" name="export_type" value="server" />';
617 print '<input type="hidden" name="page_y" value="" />';
618 
619 print '<fieldset><legend class="legendforfieldsetstep" style="font-size: 3em">2</legend>';
620 
621 print '<span class="opacitymedium">';
622 print $langs->trans("BackupDesc2", DOL_DATA_ROOT).'<br>';
623 print $langs->trans("BackupDescX").'<br><br>';
624 print '</span>';
625 
626 print '<div id="backupfilesleft" class="fichehalfleft">';
627 
628 print load_fiche_titre($title);
629 
630 print '<label for="zipfilename_template" class="line-height-large paddingbottom opacitymedium">'.$langs->trans("FileNameToGenerate").'</label><br>';
631 $prefix = 'documents';
632 $ext = 'zip';
633 $file = $prefix.'_'.$dolibarr_main_db_name.'_'.dol_sanitizeFileName(DOL_VERSION).'_'.dol_print_date(dol_now('gmt'), "dayhourlogsmall", 'tzuser');
634 print '<input type="text" name="zipfilename_template" style="width: 90%" id="zipfilename_template" value="'.$file.'" /> <br>';
635 print '<br>';
636 
637 
638 // Show compression choices
639 // Example: With gz choice, you can compress in 5mn, a file of 2GB directory (after compression) with 10 Mb memory.
640 print '<div class="formelementrow">';
641 print "\n";
642 
643 print $langs->trans("Compression").': &nbsp; ';
644 $filecompression = $compression;
645 unset($filecompression['none']);
646 $filecompression['zip'] = array('function' => 'dol_compress_dir', 'id' => 'radio_compression_zip', 'label' => $langs->trans("FormatZip"));
647 
648 $i = 0;
649 foreach ($filecompression as $key => $val) {
650  if (!$val['function'] || function_exists($val['function'])) { // Enabled export format
651  $checked = '';
652  if ($key == 'gz') {
653  $checked = ' checked';
654  }
655  print '<input type="radio" name="compression" value="'.$key.'" id="'.$val['id'].'2"'.$checked.'>';
656  print ' <label for="'.$val['id'].'2">'.$val['label'].'</label>';
657  } else // Disabled export format
658  {
659  print '<input type="radio" name="compression" value="'.$key.'" id="'.$val['id'].'2" disabled>';
660  print ' <label for="'.$val['id'].'2">'.$val['label'].'</label>';
661  print ' <span class="opacitymedium">('.$langs->trans("NotAvailable").')</span>';
662  }
663  print ' &nbsp; &nbsp; ';
664  $i++;
665 }
666 
667 print '</div>';
668 print "\n";
669 
670 print '<br>';
671 print '<div class="center">';
672 print '<input type="submit" class="button reposition" value="'.$langs->trans("GenerateBackup").'" id="buttonGo" /><br>';
673 print '<br>';
674 print '</div>';
675 
676 print '</div>';
677 
678 print '<div id="backupfileright" class="fichehalfright">';
679 
680 $filearray = dol_dir_list($conf->admin->dir_output.'/documents', 'files', 0, '', '', $sortfield, (strtolower($sortorder) == 'asc' ?SORT_ASC:SORT_DESC), 1);
681 $result = $formfile->list_of_documents($filearray, null, 'systemtools', '', 1, 'documents/', 1, 0, $langs->trans("NoBackupFileAvailable"), 0, $langs->trans("PreviousArchiveFiles"), '', 0, -1, '', '', 'ASC', 1, 0, -1, 'style="height:250px; overflow: auto;"');
682 print '<br>';
683 
684 print '</div>';
685 
686 print '</fieldset>';
687 print '</form>';
688 
689 print '<br>';
690 
691 // End of page
692 llxFooter();
693 $db->close();
$help_url
if(GETPOST('button_removefilter_x', 'alpha')||GETPOST('button_removefilter.x', 'alpha')||GETPOST('button_removefilter', 'alpha')) if(GETPOST('button_search_x', 'alpha')||GETPOST('button_search.x', 'alpha')||GETPOST('button_search', 'alpha')) if($action=="save" &&empty($cancel)) $help_url
View.
Definition: agenda.php:118
llxHeader
if(!defined('NOREQUIRESOC')) if(!defined('NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) llxHeader()
Empty header.
Definition: wrapper.php:56
llxFooter
llxFooter()
Empty footer.
Definition: wrapper.php:70
FormFile
Class to offer components to list and upload files.
Definition: html.formfile.class.php:37
Form
Class to manage generation of HTML components Only common components must be here.
Definition: html.form.class.php:54
$form
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:143
dol_delete_file
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
Definition: files.lib.php:1334
dol_dir_list
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition: files.lib.php:62
load_fiche_titre
load_fiche_titre($titre, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
Definition: functions.lib.php:5477
dol_print_date
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
Definition: functions.lib.php:2675
dol_now
dol_now($mode='auto')
Return date for now.
Definition: functions.lib.php:3056
img_picto
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
Definition: functions.lib.php:4135
dol_escape_js
dol_escape_js($stringtoescape, $mode=0, $noescapebackslashn=0)
Returns text escaped for inclusion into javascript code.
Definition: functions.lib.php:1546
ajax_autoselect
ajax_autoselect($htmlname, $addlink='', $textonlink='Link')
Make content of an input box selected when we click into input field.
Definition: functions.lib.php:10310
GETPOST
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
Definition: functions.lib.php:609
setEventMessages
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
Definition: functions.lib.php:8673
dol_sanitizeFileName
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
Definition: functions.lib.php:1323
GETPOSTISSET
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
Definition: functions.lib.php:509
getDolGlobalString
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
Definition: functions.lib.php:142
img_info
img_info($titlealt='default')
Show info logo.
Definition: functions.lib.php:4765
accessforbidden
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.
Definition: security.lib.php:1169
Generated on Mon Apr 1 2024 01:00:46 for dolibarr by Doxygen 1.9.1