31include_once
'inc.php';
52@phan-var-force ?string $dolibarr_main_db_encryption
53@phan-var-force ?string $dolibarr_main_db_cryptkey
56require_once $dolibarr_main_document_root.
'/core/lib/admin.lib.php';
57include_once $dolibarr_main_document_root.
'/core/lib/images.lib.php';
58require_once $dolibarr_main_document_root.
'/core/class/extrafields.class.php';
59require_once $dolibarr_main_document_root.
'/core/class/html.form.class.php';
60require_once
'lib/repair.lib.php';
67$err = error_reporting();
72$setuplang =
GETPOST(
"selectlang",
'aZ09', 3) ?
GETPOST(
"selectlang",
'aZ09', 3) :
'auto';
73$langs->setDefaultLang($setuplang);
75$langs->loadLangs(array(
"admin",
"install",
"other"));
77if ($dolibarr_main_db_type ==
"mysqli") {
80if ($dolibarr_main_db_type ==
"pgsql") {
83if ($dolibarr_main_db_type ==
"mssql") {
89if (!is_object($conf)) {
97require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
105$form =
new Form($db);
107pHeader($langs->trans(
"Repair"),
"upgrade2",
GETPOST(
'action',
'aZ09'));
113print
'<table cellspacing="0" cellpadding="1" class="centpercent">';
117if (preg_match(
'/(crypted|dolcrypt):/i', $dolibarr_main_db_pass) || !empty($dolibarr_main_db_encrypted_pass)) {
118 require_once $dolibarr_main_document_root.
'/core/lib/security.lib.php';
119 if (preg_match(
'/crypted:/i', $dolibarr_main_db_pass)) {
120 $dolibarr_main_db_pass = preg_replace(
'/crypted:/i',
'', $dolibarr_main_db_pass);
121 $dolibarr_main_db_encrypted_pass = $dolibarr_main_db_pass;
122 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_pass);
123 } elseif (preg_match(
'/dolcrypt:/i', $dolibarr_main_db_pass)) {
124 $dolibarr_main_db_encrypted_pass = $dolibarr_main_db_pass;
125 $dolibarr_main_db_pass =
dolDecrypt($dolibarr_main_db_pass);
127 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_encrypted_pass);
132$conf->db->type = $dolibarr_main_db_type;
133$conf->db->host = $dolibarr_main_db_host;
134$conf->db->port = $dolibarr_main_db_port;
135$conf->db->name = $dolibarr_main_db_name;
136$conf->db->user = $dolibarr_main_db_user;
137$conf->db->pass = $dolibarr_main_db_pass;
140$conf->db->dolibarr_main_db_encryption = isset($dolibarr_main_db_encryption) ? $dolibarr_main_db_encryption : 0;
141$conf->db->dolibarr_main_db_cryptkey = isset($dolibarr_main_db_cryptkey) ? $dolibarr_main_db_cryptkey :
'';
143$db =
getDoliDBInstance($conf->db->type, $conf->db->host, $conf->db->user, $conf->db->pass, $conf->db->name, (
int) $conf->db->port);
146 print
'<tr><td class="nowrap">';
147 print $langs->trans(
"ServerConnection").
" : ".$dolibarr_main_db_host.
'</td><td class="right">'.$langs->trans(
"OK").
"</td></tr>";
148 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ServerConnection").
": ".$dolibarr_main_db_host.$langs->transnoentities(
"OK"));
151 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right">'.$langs->transnoentities(
"Error").
"</td></tr>";
152 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
157 if ($db->database_selected) {
158 print
'<tr><td class="nowrap">';
159 print $langs->trans(
"DatabaseConnection").
" : ".$dolibarr_main_db_name.
'</td><td class="right">'.$langs->trans(
"OK").
"</td></tr>";
163 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right">'.$langs->trans(
"Error").
"</td></tr>";
164 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
171 $version = $db->getVersion();
172 $versionarray = $db->getVersionArray();
173 print
'<tr><td>'.$langs->trans(
"ServerVersion").
'</td>';
174 print
'<td class="right">'.$version.
'</td></tr>';
185print
'<div class="warning" style="padding-top: 10px">';
186print
'Select a link "test" or "confirmed" to launch a reparation on the chosen option...';
191print
'<table class="liste centpercent" style="border: 1px solid #ccc">';
193print
'<th>Option</th>';
194print
'<th>Information</th>';
195print
'<th>Launch test</th>';
196print
'<th>Launch confirmed</th>';
199$warning_using_utf8mb4 =
'';
200if ($dolibarr_main_db_character_set !=
'utf8mb4') {
201 $warning_using_utf8mb4 =
'<img src="../theme/eldy/img/warning.png" class="pictofortooltip valignmiddle" title="If you switch to utf8mb4, you must also check the value for $dolibarr_main_db_character_set and $dolibarr_main_db_collation into conf/conf.php file.">';
207 'name' =>
'standard',
213 'name' =>
'force_disable_of_modules_not_found',
214 'info' =>
'Disable modules not found'
219 'name' =>
'restore_thirdparties_logos',
220 'info' =>
'Restore logos for thirdparties'
223 'name' =>
'restore_user_pictures',
224 'info' =>
'Restore user pictures'
227 'name' =>
'rebuild_product_thumbs',
228 'info' =>
'Rebuild product thumbnails'
231 'name' =>
'repair_mailing_path',
232 'info' =>
'Repair path of mailing files',
233 'tooltip' =>
'Should be applied when using emailing module with > 99 mailings. In that case, please also set MAILING_USE_NEW_PATH_FOR_FILES.'
236 'Clean tables and data' => [
238 'name' =>
'clean_linked_elements',
239 'info' =>
'Clean linked elements'
242 'name' =>
'clean_menus',
243 'info' =>
'Clean menus'
246 'name' =>
'clean_orphelin_dir',
247 'info' =>
'Clean orphan directories'
250 'name' =>
'clean_product_stock_batch',
251 'info' =>
'Clean product stock batch'
254 'name' =>
'clean_perm_table',
255 'info' =>
'Clean permissions table'
258 'name' =>
'clean_ecm_files_table',
259 'info' =>
'Clean ECM files table'
262 'name' =>
'repair_link_dispatch_lines_supplier_order_lines',
263 'info' =>
'Repair link between dispatch lines and supplier order lines'
268 'name' =>
'set_empty_time_spent_amount',
269 'info' =>
'Init empty time spent amount'
274 'name' =>
'force_utf8_on_tables',
275 'info' =>
'Force utf8 + row=dynamic, for mysql/mariadb only'
278 'name' =>
'force_utf8mb4_on_tables',
279 'info' =>
'Force utf8mb4 + row=dynamic, for mysql/mariadb only' . $warning_using_utf8mb4
282 'name' =>
'force_collation_from_conf_on_tables',
283 'info' =>
'Force '.$conf->db->character_set.
'/'.$conf->db->dolibarr_main_db_collation.
' + row=dynamic, for mysql/mariadb only'
286 'Rebuild sequence' => [
288 'name' =>
'rebuild_sequences',
289 'info' =>
'For postgresql only'
294$conf->use_javascript_ajax = 1;
296foreach ($sections as $section => $options) {
297 print
'<tr style="background:#f4f4f4;font-weight:bold"><td colspan="5">'.$section.
'</td></tr>';
298 foreach ($options as $opt) {
299 $option = $opt[
'name'];
300 $info = $opt[
'info'];
301 $tooltip = empty($opt[
'tooltip']) ?
'' : $opt[
'tooltip'];
302 $value =
GETPOST($option,
'alpha') ?
GETPOST($option,
'alpha') :
'undefined';
304 $url_test = $_SERVER[
'PHP_SELF'].
'?'.$option.
'=test';
305 $url_confirmed = $_SERVER[
'PHP_SELF'].
'?'.$option.
'=confirmed';
307 print
'<td>' . $option .
'</td>';
310 print $form->textwithpicto($info, $tooltip);
315 print
'<td class="center"><a href="'.$url_test.
'" title="Launch test on option '.$option.
'">test</a>'.($value ==
'test' ?
' (X)' :
'').
'</td>';
316 print
'<td class="center"><a href="'.$url_confirmed.
'" title="Launch confirmed on option '.$option.
'">confirmed</a>'.($value ==
'confirmed' ?
' (X)' :
'').
'</td>';
323print
'<br id="sectionresult">';
327$conf->setValues($db);
329if (defined(
'SYSLOG_FILE')) {
330 $conf->global->SYSLOG_FILE = constant(
'SYSLOG_FILE');
332$conf->global->MAIN_ENABLE_LOG_TO_HTML = 1;
337$oneoptionset = (
GETPOST(
'standard',
'alpha') ||
GETPOST(
'restore_thirdparties_logos',
'alpha') ||
GETPOST(
'clean_linked_elements',
'alpha') ||
GETPOST(
'clean_menus',
'alpha')
338 ||
GETPOST(
'clean_orphelin_dir',
'alpha') ||
GETPOST(
'clean_product_stock_batch',
'alpha') ||
GETPOST(
'set_empty_time_spent_amount',
'alpha') ||
GETPOST(
'rebuild_product_thumbs',
'alpha')
339 ||
GETPOST(
'clean_perm_table',
'alpha') ||
GETPOST(
'clean_ecm_files_table',
'alpha')
340 ||
GETPOST(
'force_disable_of_modules_not_found',
'alpha')
341 ||
GETPOST(
'force_utf8_on_tables',
'alpha') ||
GETPOST(
'force_utf8mb4_on_tables',
'alpha') ||
GETPOST(
'force_collation_from_conf_on_tables',
'alpha')
342 ||
GETPOST(
'rebuild_sequences',
'alpha') ||
GETPOST(
'recalculateinvoicetotal',
'alpha')) ||
GETPOST(
'repair_mailing_path',
'alpha');
344if ($ok && $oneoptionset) {
346 print $langs->trans(
"PleaseBePatient").
'<br><br>';
349 print str_repeat(
' ', 1024);
356print
'<table cellspacing="0" cellpadding="1" class="centpercent">';
359if ($ok &&
GETPOST(
'standard',
'alpha')) {
360 $dir =
"mysql/migration/";
367 $filesindir = array();
368 $handle = opendir($dir);
369 if (is_resource($handle)) {
370 while (($file = readdir($handle)) !==
false) {
371 if (preg_match(
'/\.sql$/i', $file)) {
372 $filesindir[] = $file;
378 foreach ($filesindir as $file) {
379 if (preg_match(
'/repair/i', $file)) {
385 foreach ($filelist as $file) {
386 print
'<tr><td class="nowrap">*** ';
387 print $langs->trans(
"Script").
'</td><td class="right">'.$file.
'</td></tr>';
389 $name = substr($file, 0,
dol_strlen($file) - 4);
392 $ok =
run_sql($dir.$file, 0, 0, 1);
399if ($ok &&
GETPOST(
'standard',
'alpha')) {
400 require_once DOL_DOCUMENT_ROOT.
'/contrat/class/contratligne.class.php';
402 print
'<tr><td colspan="2"><br>*** Update denormalized_lower_planned_end_date.</td></tr>';
403 $sqltoupdatecontract =
"UPDATE ".MAIN_DB_PREFIX.
"contrat";
404 $sqltoupdatecontract .=
" SET denormalized_lower_planned_end_date = (SELECT MIN(date_fin_validite) FROM ".MAIN_DB_PREFIX.
"contratdet as cd WHERE cd.fk_contrat = c.rowid AND cd.statut = ".ContratLigne::STATUS_OPEN.
")";
405 $resqltoupdatecontract = $db->query($sqltoupdatecontract);
410 $listofmodulesextra = array(
'societe' =>
'societe',
'adherent' =>
'adherent',
'product' =>
'product',
411 'socpeople' =>
'socpeople',
'propal' =>
'propal',
'commande' =>
'commande',
412 'facture' =>
'facture',
'facturedet' =>
'facturedet',
'facture_rec' =>
'facture_rec',
'facturedet_rec' =>
'facturedet_rec',
413 'supplier_proposal' =>
'supplier_proposal',
'commande_fournisseur' =>
'commande_fournisseur',
414 'facture_fourn' =>
'facture_fourn',
'facture_fourn_rec' =>
'facture_fourn_rec',
'facture_fourn_det' =>
'facture_fourn_det',
'facture_fourn_det_rec' =>
'facture_fourn_det_rec',
415 'fichinter' =>
'fichinter',
'fichinterdet' =>
'fichinterdet',
416 'inventory' =>
'inventory',
417 'actioncomm' =>
'actioncomm',
'bom_bom' =>
'bom_bom',
'mrp_mo' =>
'mrp_mo',
418 'adherent_type' =>
'adherent_type',
'user' =>
'user',
'partnership' =>
'partnership',
'projet' =>
'projet',
'projet_task' =>
'projet_task',
'ticket' =>
'ticket');
421 print
'<tr><td colspan="2"><br>*** Check that fields into the extra table structure match the table of definition. If not, add column into table</td></tr>';
422 foreach ($listofmodulesextra as $tablename => $elementtype) {
424 $tableextra = MAIN_DB_PREFIX.$tablename.
'_extrafields';
427 $arrayoffieldsdesc = $extrafields->fetch_name_optionals_label($elementtype);
430 $arrayoffieldsfound = array();
431 $resql = $db->DDLDescTable($tableextra);
433 print
'<tr><td>Check availability of extra field for '.$tableextra;
435 while ($obj = $db->fetch_object($resql)) {
436 $fieldname = $fieldtype =
'';
437 if (preg_match(
'/mysql/', $db->type)) {
438 $fieldname = $obj->Field;
439 $fieldtype = $obj->Type;
441 $fieldname = isset($obj->Key) ? $obj->Key : $obj->attname;
442 $fieldtype = isset($obj->Type) ? $obj->Type :
'varchar';
445 if (empty($fieldname)) {
448 if (in_array($fieldname, array(
'rowid',
'tms',
'fk_object',
'import_key'))) {
451 $arrayoffieldsfound[$fieldname] = array(
'type' => $fieldtype);
453 print
' - Found '.count($arrayoffieldsfound).
' fields into table';
454 if (count($arrayoffieldsfound) > 0) {
455 print
' <span class="opacitymedium">('.implode(
', ', array_keys($arrayoffieldsfound)).
')</span>';
460 foreach ($arrayoffieldsdesc as $code => $label) {
461 if (!in_array($code, array_keys($arrayoffieldsfound))) {
462 print
'Found field '.$code.
' declared into '.MAIN_DB_PREFIX.
'extrafields table but not found into desc of table '.$tableextra.
" -> ";
463 $type = $extrafields->attributes[$elementtype][
'type'][$code];
464 $length = $extrafields->attributes[$elementtype][
'size'][$code];
470 if ($type ==
'boolean') {
473 } elseif ($type ==
'price') {
476 } elseif ($type ==
'phone') {
479 } elseif ($type ==
'mail') {
482 } elseif (($type ==
'select') || ($type ==
'sellist') || ($type ==
'radio') || ($type ==
'checkbox') || ($type ==
'chkbxlst')) {
485 } elseif ($type ==
'link') {
495 'value' => $lengthdb,
496 'attribute' => $attribute,
497 'default' => $default,
504 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
505 $result = $db->DDLAddField($tableextra, $code, $field_desc,
"");
508 print
"KO ".$db->lasterror.
"<br>\n";
513 print
' - Mode test, no column added.';
518 print
"</td><td> </td></tr>\n";
520 print
'<tr><td>Table '.$tableextra.
' is not found</td><td></td></tr>'.
"\n";
527if ($ok &&
GETPOST(
'standard',
'alpha')) {
533if ($ok &&
GETPOST(
'standard',
'alpha')) {
534 print
'<tr><td colspan="2"><br>*** Clean constant record of modules not enabled</td></tr>';
536 $sql =
"SELECT name, entity, value";
537 $sql .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
538 $sql .=
" WHERE name LIKE 'MAIN_MODULE_%_TPL' OR name LIKE 'MAIN_MODULE_%_CSS' OR name LIKE 'MAIN_MODULE_%_JS' OR name LIKE 'MAIN_MODULE_%_HOOKS'";
539 $sql .=
" OR name LIKE 'MAIN_MODULE_%_TRIGGERS' OR name LIKE 'MAIN_MODULE_%_THEME' OR name LIKE 'MAIN_MODULE_%_SUBSTITUTIONS' OR name LIKE 'MAIN_MODULE_%_MODELS'";
540 $sql .=
" OR name LIKE 'MAIN_MODULE_%_MENUS' OR name LIKE 'MAIN_MODULE_%_LOGIN' OR name LIKE 'MAIN_MODULE_%_BARCODE' OR name LIKE 'MAIN_MODULE_%_TABS_%'";
541 $sql .=
" OR name LIKE 'MAIN_MODULE_%_MODULEFOREXTERNAL'";
542 $sql .=
" ORDER BY name, entity";
544 $resql = $db->query($sql);
546 $num = $db->num_rows($resql);
553 $obj = $db->fetch_object($resql);
556 if (preg_match(
'/MAIN_MODULE_([^_]+)_(.+)/i', $obj->name, $reg)) {
560 $sql2 =
"SELECT COUNT(*) as nb";
561 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
562 $sql2 .=
" WHERE name = 'MAIN_MODULE_".$name.
"'";
563 $sql2 .=
" AND entity = ".((int) $obj->entity);
564 $resql2 = $db->query($sql2);
566 $obj2 = $db->fetch_object($resql2);
567 if ($obj2 && $obj2->nb == 0) {
569 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = '".$db->escape($obj->name).
"' AND entity = ".((int) $obj->entity);
571 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
572 $db->query($sqldelete);
574 print
'<tr><td>Widget '.$obj->name.
' set in entity '.$obj->entity.
' with value '.$obj->value.
' -> Module '.$name.
' not enabled in entity '.((int) $obj->entity).
', we delete record</td></tr>';
576 print
'<tr><td>Widget '.$obj->name.
' set in entity '.$obj->entity.
' with value '.$obj->value.
' -> Module '.$name.
' not enabled in entity '.((int) $obj->entity).
', we should delete record (not done, mode test)</td></tr>';
596if ($ok &&
GETPOST(
'standard',
'alpha')) {
597 print
'<tr><td colspan="2"><br>*** Clean definition of boxes of modules not enabled</td></tr>';
599 $sql =
"SELECT file, entity FROM ".MAIN_DB_PREFIX.
"boxes_def";
600 $sql .=
" WHERE file like '%@%'";
602 $resql = $db->query($sql);
604 $num = $db->num_rows($resql);
611 $obj = $db->fetch_object($resql);
614 if (preg_match(
'/^(.+)@(.+)$/i', $obj->file, $reg)) {
618 $sql2 =
"SELECT COUNT(*) as nb";
619 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
620 $sql2 .=
" WHERE name = 'MAIN_MODULE_".strtoupper($module).
"'";
621 $sql2 .=
" AND entity = ".((int) $obj->entity);
622 $sql2 .=
" AND value <> 0";
623 $resql2 = $db->query($sql2);
625 $obj2 = $db->fetch_object($resql2);
626 if ($obj2 && $obj2->nb == 0) {
628 $sqldeletea =
"DELETE FROM ".MAIN_DB_PREFIX.
"boxes WHERE entity = ".((int) $obj->entity).
" AND box_id IN (SELECT rowid FROM ".MAIN_DB_PREFIX.
"boxes_def WHERE file = '".$db->escape($obj->file).
"' AND entity = ".((int) $obj->entity).
")";
629 $sqldeleteb =
"DELETE FROM ".MAIN_DB_PREFIX.
"boxes_def WHERE file = '".$db->escape($obj->file).
"' AND entity = ".((int) $obj->entity);
631 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
632 $db->query($sqldeletea);
633 $db->query($sqldeleteb);
635 print
'<tr><td>Constant '.$obj->file.
' set in boxes_def for entity '.$obj->entity.
' but MAIN_MODULE_'.strtoupper($module).
' not defined in entity '.((int) $obj->entity).
', we delete record</td></tr>';
637 print
'<tr><td>Constant '.$obj->file.
' set in boxes_def for entity '.$obj->entity.
' but MAIN_MODULE_'.strtoupper($module).
' not defined in entity '.((int) $obj->entity).
', we should delete record (not done, mode test)</td></tr>';
655if ($ok &&
GETPOST(
'restore_thirdparties_logos')) {
660 print
'<tr><td colspan="2"><br>*** Restore thirdparties logo<br>';
662 $sql =
"SELECT s.rowid, s.nom as name, s.logo FROM ".MAIN_DB_PREFIX.
"societe as s ORDER BY s.nom";
663 $resql = $db->query($sql);
665 $num = $db->num_rows($resql);
669 $obj = $db->fetch_object($resql);
677 $tmp = explode(
'.', (
string) $obj->logo);
679 if (isset($tmp[1])) {
684 $filetotest = $dolibarr_main_data_root.
'/societe/logos/'.$name.$ext;
685 $filetotestsmall = $dolibarr_main_data_root.
'/societe/logos/thumbs/'.$name.
'_small'.$ext;
687 print
'Check thirdparty '.$obj->rowid.
' name='.$obj->name.
' logo='.$obj->logo.
' file '.$filetotest.
" exists=".$exists.
"<br>\n";
689 $filetarget = $dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/'.$name.$ext;
690 $filetargetsmall = $dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/thumbs/'.$name.
'_small'.$ext;
693 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
694 dol_mkdir($dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos');
697 print
" -> Copy file ".$filetotest.
" -> ".$filetarget.
"<br>\n";
698 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
699 dol_copy($filetotest, $filetarget,
'', 0);
705 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
706 dol_mkdir($dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/thumbs');
708 print
" -> Copy file ".$filetotestsmall.
" -> ".$filetargetsmall.
"<br>\n";
709 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
710 dol_copy($filetotestsmall, $filetargetsmall,
'', 0);
729if ($ok &&
GETPOST(
'restore_user_pictures',
'alpha')) {
734 print
'<tr><td colspan="2"><br>*** Restore user pictures<br>';
736 $sql =
"SELECT s.rowid, s.firstname, s.lastname, s.login, s.photo FROM ".MAIN_DB_PREFIX.
"user as s ORDER BY s.rowid";
737 $resql = $db->query($sql);
739 $num = $db->num_rows($resql);
743 $obj = $db->fetch_object($resql);
751 $tmp = explode(
'.', (
string) $obj->photo);
753 if (isset($tmp[1])) {
758 $filetotest = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/'.$name.$ext;
759 $filetotestsmall = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/thumbs/'.$name.
'_small'.$ext;
760 $filetotestmini = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/thumbs/'.$name.
'_mini'.$ext;
762 print
'Check user '.$obj->rowid.
' lastname='.$obj->lastname.
' firstname='.$obj->firstname.
' photo='.$obj->photo.
' file '.$filetotest.
" exists=".$exists.
"<br>\n";
764 $filetarget = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/'.$name.$ext;
765 $filetargetsmall = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs/'.$name.
'_small'.$ext;
766 $filetargetmini = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs/'.$name.
'_mini'.$ext;
770 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
771 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid);
774 print
" -> Copy file ".$filetotest.
" -> ".$filetarget.
"<br>\n";
775 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
776 dol_copy($filetotest, $filetarget,
'', 0);
782 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
783 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs');
786 print
" -> Copy file ".$filetotestsmall.
" -> ".$filetargetsmall.
"<br>\n";
787 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
788 dol_copy($filetotestsmall, $filetargetsmall,
'', 0);
794 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
795 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs');
798 print
" -> Copy file ".$filetotestmini.
" -> ".$filetargetmini.
"<br>\n";
799 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
800 dol_copy($filetotestmini, $filetargetmini,
'', 0);
818if ($ok &&
GETPOST(
'rebuild_product_thumbs',
'alpha')) {
820 global $maxwidthsmall, $maxheightsmall, $maxwidthmini, $maxheightmini;
822 print
'<tr><td colspan="2"><br>*** Rebuild product thumbs<br>';
824 $sql =
"SELECT s.rowid, s.ref FROM ".MAIN_DB_PREFIX.
"product as s ORDER BY s.ref";
825 $resql = $db->query($sql);
827 $num = $db->num_rows($resql);
831 $obj = $db->fetch_object($resql);
833 if (!empty($obj->ref)) {
834 $files =
dol_dir_list($dolibarr_main_data_root.
'/produit/'.$obj->ref,
'files', 0);
835 foreach ($files as $file) {
838 $imgThumbSmall =
'notbuild';
839 if (
GETPOST(
'rebuild_product_thumbs',
'alpha') ==
'confirmed') {
841 $imgThumbSmall =
vignette($file[
'fullname'], $maxwidthsmall, $maxheightsmall,
'_small', 50,
"thumbs");
843 print
'Check product '.$obj->rowid.
", file ".$file[
'fullname'].
" -> ".$imgThumbSmall.
" maxwidthsmall=".$maxwidthsmall.
" maxheightsmall=".$maxheightsmall.
"<br>\n";
844 $imgThumbMini =
'notbuild';
845 if (
GETPOST(
'rebuild_product_thumbs',
'alpha') ==
'confirmed') {
848 $imgThumbMini =
vignette($file[
'fullname'], $maxwidthmini, $maxheightmini,
'_mini', 50,
"thumbs");
850 print
'Check product '.$obj->rowid.
", file ".$file[
'fullname'].
" -> ".$imgThumbMini.
" maxwidthmini=".$maxwidthmini.
" maxheightmini=".$maxheightmini.
"<br>\n";
866if ($ok &&
GETPOST(
'clean_linked_elements',
'alpha')) {
867 print
'<tr><td colspan="2"><br>*** Check table of linked elements and delete orphelins links</td></tr>';
869 print
'<tr><td colspan="2">'.checkLinkedElements(
'propal',
'commande').
"</td></tr>\n";
872 print
'<tr><td colspan="2">'.checkLinkedElements(
'propal',
'facture').
"</td></tr>\n";
875 print
'<tr><td colspan="2">'.checkLinkedElements(
'commande',
'facture').
"</td></tr>\n";
878 print
'<tr><td colspan="2">'.checkLinkedElements(
'commande',
'shipping').
"</td></tr>\n";
881 print
'<tr><td colspan="2">'.checkLinkedElements(
'shipping',
'delivery').
"</td></tr>\n";
884 print
'<tr><td colspan="2">'.checkLinkedElements(
'order_supplier',
'invoice_supplier').
"</td></tr>\n";
889if ($ok &&
GETPOST(
'clean_menus',
'alpha')) {
890 print
'<tr><td colspan="2"><br>*** Clean menu entries coming from disabled modules</td></tr>';
892 $sql =
"SELECT rowid, module";
893 $sql .=
" FROM ".MAIN_DB_PREFIX.
"menu as c";
894 $sql .=
" WHERE module IS NOT NULL AND module <> ''";
895 $sql .=
" ORDER BY module";
897 $resql = $db->query($sql);
899 $num = $db->num_rows($resql);
903 $obj = $db->fetch_object($resql);
905 $modulecond = $obj->module;
906 $modulecondarray = explode(
'|', $obj->module);
915 foreach ($modulecondarray as $tmpname) {
916 if ($tmpname ==
'margins') {
921 if (!empty($conf->$tmpname)) {
922 $result = $conf->$tmpname->enabled;
929 if (!$moduleok && $modulecond) {
930 print
' - Module condition '.$modulecond.
' seems ko, we delete menu entry.';
931 if (
GETPOST(
'clean_menus') ==
'confirmed') {
932 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"menu WHERE module = '".$db->escape($modulecond).
"'";
933 $resql2 = $db->query($sql2);
938 print
' - <span class="warning">Cleaned</span>';
941 print
' - <span class="warning">Canceled (test mode)</span>';
944 print
' - Module condition '.$modulecond.
' is ok, we do nothing.';
963 print
'<tr><td>No menu entries of disabled menus found</td></tr>';
973if ($ok &&
GETPOST(
'clean_orphelin_dir',
'alpha')) {
974 $listmodulepart = array(
'company',
'invoice',
'invoice_supplier',
'propal',
'order',
'order_supplier',
'contract',
'tax');
975 foreach ($listmodulepart as $modulepart) {
976 $filearray = array();
977 $upload_dir = isset($conf->$modulepart->dir_output) ? $conf->$modulepart->dir_output :
'';
978 if ($modulepart ==
'company') {
979 $upload_dir = $conf->societe->dir_output;
981 if ($modulepart ==
'invoice') {
982 $upload_dir = $conf->facture->dir_output;
984 if ($modulepart ==
'invoice_supplier') {
985 $upload_dir = $conf->fournisseur->facture->dir_output;
987 if ($modulepart ==
'order') {
988 $upload_dir = $conf->commande->dir_output;
990 if ($modulepart ==
'order_supplier') {
991 $upload_dir = $conf->fournisseur->commande->dir_output;
993 if ($modulepart ==
'contract') {
994 $upload_dir = $conf->contrat->dir_output;
997 if (empty($upload_dir)) {
1001 print
'<tr><td colspan="2"><br>*** Clean orphelins files into files '.$upload_dir.
'</td></tr>';
1003 $filearray =
dol_dir_list($upload_dir,
"files", 1,
'', array(
'^SPECIMEN\.pdf$',
'^\.',
'(\.meta|_preview.*\.png)$',
'^temp$',
'^payments$',
'^CVS$',
'^thumbs$'),
'', SORT_DESC, 1, 1);
1005 $object_instance =
null;
1007 if ($modulepart ==
'company') {
1008 include_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
1009 $object_instance =
new Societe($db);
1011 if ($modulepart ==
'invoice') {
1012 include_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
1013 $object_instance =
new Facture($db);
1014 } elseif ($modulepart ==
'invoice_supplier') {
1015 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
1017 } elseif ($modulepart ==
'propal') {
1018 include_once DOL_DOCUMENT_ROOT.
'/comm/propal/class/propal.class.php';
1019 $object_instance =
new Propal($db);
1020 } elseif ($modulepart ==
'order') {
1021 include_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
1022 $object_instance =
new Commande($db);
1023 } elseif ($modulepart ==
'order_supplier') {
1024 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.class.php';
1026 } elseif ($modulepart ==
'contract') {
1027 include_once DOL_DOCUMENT_ROOT.
'/contrat/class/contrat.class.php';
1028 $object_instance =
new Contrat($db);
1029 } elseif ($modulepart ==
'tax') {
1030 include_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
1034 foreach ($filearray as $key => $file) {
1035 if (!is_dir($file[
'name'])
1036 && $file[
'name'] !=
'.'
1037 && $file[
'name'] !=
'..'
1038 && $file[
'name'] !=
'CVS'
1041 $relativefile = preg_replace(
'/'.preg_quote($upload_dir.
'/',
'/').
'/',
'', $file[
'fullname']);
1046 $object_instance->id = 0;
1047 $object_instance->ref =
'';
1051 if ($modulepart ==
'invoice') {
1052 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1053 $ref = empty($reg[1]) ?
'' : $reg[1];
1055 if ($modulepart ==
'invoice_supplier') {
1056 preg_match(
'/(\d+)\/[^\/]+$/', $relativefile, $reg);
1057 $id = empty($reg[1]) ?
'' : $reg[1];
1059 if ($modulepart ==
'propal') {
1060 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1061 $ref = empty($reg[1]) ?
'' : $reg[1];
1063 if ($modulepart ==
'order') {
1064 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1065 $ref = empty($reg[1]) ?
'' : $reg[1];
1067 if ($modulepart ==
'order_supplier') {
1068 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1069 $ref = empty($reg[1]) ?
'' : $reg[1];
1071 if ($modulepart ==
'contract') {
1072 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1073 $ref = empty($reg[1]) ?
'' : $reg[1];
1075 if ($modulepart ==
'tax') {
1076 preg_match(
'/(\d+)\/[^\/]+$/', $relativefile, $reg);
1080 if ((
$id || $ref) && $object_instance !==
null) {
1082 $result = $object_instance->fetch(
$id, $ref);
1086 print
'<tr><td colspan="2">';
1087 print
'Delete orphelins file '.$file[
'fullname'].
'<br>';
1088 if (
GETPOST(
'clean_orphelin_dir',
'alpha') ==
'confirmed') {
1093 } elseif ($result < 0) {
1094 print
'Error in '.get_class($object_instance).
'.fetch of id'.
$id.
' ref='.$ref.
', result='.$result.
'<br>';
1104if ($ok &&
GETPOST(
'clean_product_stock_batch',
'alpha')) {
1105 $methodtofix =
GETPOST(
'methodtofix',
'alpha') ?
GETPOST(
'methodtofix',
'alpha') :
'updatestock';
1107 print
'<tr><td colspan="2"><br>*** Clean table product_batch, methodtofix='.$methodtofix.
' (possible values: updatestock or updatebatch)</td></tr>';
1109 $sql =
"SELECT p.rowid, p.ref, p.tobatch, ps.rowid as psrowid, ps.fk_entrepot, ps.reel, SUM(pb.qty) as reelbatch";
1110 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product as p, ".MAIN_DB_PREFIX.
"product_stock as ps LEFT JOIN ".MAIN_DB_PREFIX.
"product_batch as pb ON ps.rowid = pb.fk_product_stock";
1111 $sql .=
" WHERE p.rowid = ps.fk_product";
1112 $sql .=
" GROUP BY p.rowid, p.ref, p.tobatch, ps.rowid, ps.fk_entrepot, ps.reel";
1113 $sql .=
" HAVING (SUM(pb.qty) IS NOT NULL AND reel != SUM(pb.qty)) OR (SUM(pb.qty) IS NULL AND p.tobatch > 0)";
1115 $resql = $db->query($sql);
1117 $num = $db->num_rows($resql);
1122 $obj = $db->fetch_object($resql);
1123 print
'<tr><td>Product '.$obj->rowid.
'-'.$obj->ref.
' in warehouse id='.$obj->fk_entrepot.
' (product_stock.id='.$obj->psrowid.
'): '.$obj->reel.
' (Stock product_stock.reel) != '.($obj->reelbatch ? $obj->reelbatch :
'0').
' (Stock batch sum product_batch)';
1126 if ($obj->reel != $obj->reelbatch) {
1127 if (empty($obj->tobatch)) {
1129 print
' -> Delete qty '.$obj->reelbatch.
' for any lot linked to fk_product_stock='.$obj->psrowid;
1130 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_batch";
1131 $sql2 .=
" WHERE fk_product_stock = ".((int) $obj->psrowid);
1134 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1135 $resql2 = $db->query($sql2);
1142 if ($methodtofix ==
'updatebatch') {
1144 print
' -> Insert qty '.($obj->reel - $obj->reelbatch).
' with lot 000000 linked to fk_product_stock='.$obj->psrowid;
1145 $sql2 =
"INSERT INTO ".MAIN_DB_PREFIX.
"product_batch(fk_product_stock, batch, qty)";
1146 $sql2 .=
"VALUES(".((int) $obj->psrowid).
", '000000', ".((float) ($obj->reel - $obj->reelbatch)).
")";
1149 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1150 $resql2 = $db->query($sql2);
1159 if ($methodtofix ==
'updatestock') {
1161 print
' -> Update qty of product_stock with qty = '.($obj->reelbatch ? ((float) $obj->reelbatch) :
'0').
' for ps.rowid = '.((
int) $obj->psrowid);
1162 $sql2 =
"UPDATE ".MAIN_DB_PREFIX.
"product_stock";
1163 $sql2 .=
" SET reel = ".($obj->reelbatch ? ((float) $obj->reelbatch) :
'0').
" WHERE rowid = ".((
int) $obj->psrowid);
1166 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1171 $resql2 = $db->query($sql2);
1174 $sql3 =
'UPDATE '.MAIN_DB_PREFIX.
'product p SET p.stock= (SELECT SUM(ps.reel) FROM '.MAIN_DB_PREFIX.
'product_stock ps WHERE ps.fk_product = p.rowid)';
1175 $resql3 = $db->query($sql3);
1200 print
'<tr><td colspan="2">Nothing to do</td></tr>';
1209if ($ok &&
GETPOST(
'clean_product_stock_negative_if_batch',
'alpha')) {
1210 print
'<tr><td colspan="2"><br>Clean table product_batch, methodtofix='.$methodtofix.
' (possible values: updatestock or updatebatch)</td></tr>';
1212 $sql =
"SELECT p.rowid, p.ref, p.tobatch, ps.rowid as psrowid, ps.fk_entrepot, ps.reel, SUM(pb.qty) as reelbatch";
1213 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product as p, ".MAIN_DB_PREFIX.
"product_stock as ps, ".MAIN_DB_PREFIX.
"product_batch as pb";
1214 $sql .=
" WHERE p.rowid = ps.fk_product AND ps.rowid = pb.fk_product_stock";
1215 $sql .=
" AND p.tobatch > 0";
1216 $sql .=
" GROUP BY p.rowid, p.ref, p.tobatch, ps.rowid, ps.fk_entrepot, ps.reel";
1217 $sql .=
" HAVING reel != SUM(pb.qty)";
1218 $resql = $db->query($sql);
1220 $num = $db->num_rows($resql);
1225 $obj = $db->fetch_object($resql);
1226 print
'<tr><td>'.$obj->rowid.
'-'.$obj->ref.
'-'.$obj->fk_entrepot.
' -> '.$obj->psrowid.
': '.$obj->reel.
' != '.$obj->reelbatch;
1235if ($ok &&
GETPOST(
'set_empty_time_spent_amount',
'alpha')) {
1236 print
'<tr><td colspan="2"><br>*** Set value of time spent without amount</td></tr>';
1238 $sql =
"SELECT COUNT(ptt.rowid) as nb, u.rowid as user_id, u.login, u.thm as user_thm";
1239 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time as ptt, ".MAIN_DB_PREFIX.
"user as u";
1240 $sql .=
" WHERE ptt.fk_user = u.rowid";
1241 $sql .=
" AND ptt.thm IS NULL and u.thm > 0";
1242 $sql .=
" GROUP BY u.rowid, u.login, u.thm";
1244 $resql = $db->query($sql);
1246 $num = $db->num_rows($resql);
1251 $obj = $db->fetch_object($resql);
1252 print
'<tr><td>'.$obj->login.
'-'.$obj->user_id.
' ('.$obj->nb.
' lines to fix) -> '.$obj->user_thm;
1256 if (
GETPOST(
'set_empty_time_spent_amount') ==
'confirmed') {
1257 $sql2 =
"UPDATE ".MAIN_DB_PREFIX.
"element_time";
1258 $sql2 .=
" SET thm = ".$obj->user_thm.
" WHERE thm IS NULL AND fk_user = ".((int) $obj->user_id);
1259 $resql2 = $db->query($sql2);
1281 print
'<tr><td>No time spent with empty line on users with a hourly rate defined</td></tr>';
1290if ($ok &&
GETPOST(
'force_disable_of_modules_not_found',
'alpha')) {
1291 print
'<tr><td colspan="2"><br>*** Force modules not found physically to be disabled (only modules adding js, css or hooks can be detected as removed physically)</td></tr>';
1293 $arraylistofkey = array(
'hooks',
'js',
'css');
1295 foreach ($arraylistofkey as $key) {
1296 $sql =
"SELECT DISTINCT name, value";
1297 $sql .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
1298 $sql .=
" WHERE name LIKE 'MAIN_MODULE_%_".strtoupper($db->escape($key)).
"'";
1299 $sql .=
" ORDER BY name";
1301 $resql = $db->query($sql);
1303 $num = $db->num_rows($resql);
1307 $obj = $db->fetch_object($resql);
1308 $constantname = $obj->name;
1316 if (preg_match(
'/MAIN_MODULE_(.*)_'.strtoupper($key).
'/i', $constantname, $reg)) {
1317 $name = strtolower($reg[1]);
1323 if ($key ==
'hooks') {
1324 $reloffile = $name.
'/class/actions_'.$name.
'.class.php';
1327 $value = $obj->value;
1328 $valuearray = (array) json_decode($value);
1329 $reloffile = $valuearray[0];
1330 $reloffile = preg_replace(
'/^\//',
'', $valuearray[0]);
1332 if ($key ==
'css') {
1333 $value = $obj->value;
1334 $valuearray = (array) json_decode($value);
1335 if ($value && (!is_array($valuearray) || count($valuearray) == 0)) {
1336 $valuearray = array();
1337 $valuearray[0] = $value;
1339 $reloffile = preg_replace(
'/^\//',
'', $valuearray[0]);
1354 print
' - File of '.$key.
' ('.$reloffile.
') NOT found, we disable the module.';
1355 if (
GETPOST(
'force_disable_of_modules_not_found') ==
'confirmed') {
1356 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = 'MAIN_MODULE_".strtoupper($name).
"_".strtoupper($key).
"'";
1357 $resql2 = $db->query($sql2);
1362 $sql3 =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = 'MAIN_MODULE_".strtoupper($name).
"'";
1363 $resql3 = $db->query($sql3);
1368 print
' - <span class="warning">Cleaned</span>';
1371 print
' - <span class="warning">Canceled (test mode)</span>';
1374 print
' - File of '.$key.
' ('.$reloffile.
') found, we do nothing.';
1394 print
'<tr><td>No active module with missing files found by searching on MAIN_MODULE_(.*)_'.strtoupper($key).
'</td></tr>';
1404if ($ok &&
GETPOST(
'clean_perm_table',
'alpha')) {
1405 print
'<tr><td colspan="2"><br>*** Clean table user_rights from lines of external modules no more enabled</td></tr>';
1408 foreach ($conf->modules as $key => $val) {
1409 $listofmods .= ($listofmods ?
',' :
'').
"'".$db->escape($val).
"'";
1412 $sql =
"SELECT id, entity, libelle as label, module from ".MAIN_DB_PREFIX.
"rights_def WHERE module NOT IN (".$db->sanitize($listofmods, 1).
") AND id > 100000";
1414 $resql = $db->query($sql);
1416 $num = $db->num_rows($resql);
1420 $obj = $db->fetch_object($resql);
1422 print
'<tr><td>Found line with id '.$obj->id.
', entity '.$obj->entity.
', label "'.$obj->label.
'" of module "'.$obj->module.
'" to delete';
1423 if (
GETPOST(
'clean_perm_table',
'alpha') ==
'confirmed') {
1426 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"rights_def WHERE id = ".((int) $obj->id);
1427 $sqldelete .=
" AND entity = ".((int) $obj->entity);
1428 $resqldelete = $db->query($sqldelete);
1429 if (!$resqldelete) {
1439 print
'<tr><td>No lines of a disabled external module (with id > 100000) found into table rights_def</td></tr>';
1448if ($ok &&
GETPOST(
'clean_ecm_files_table',
'alpha')) {
1449 print
'<tr><td colspan="2"><br>*** Clean table ecm_files from lines of entries whose physical files does not exists anymore (emplemented for entity 1 only)</td></tr>';
1453 $sql =
"SELECT rowid, filename, filepath, entity from ".MAIN_DB_PREFIX.
"ecm_files";
1454 $sql .=
" WHERE entity = 1";
1455 $sql .=
" ORDER BY rowid ASC";
1458 $nbfiletodelete = 0;
1460 $resql = $db->query($sql);
1462 $num = $db->num_rows($resql);
1466 $obj = $db->fetch_object($resql);
1467 if ($obj->rowid > 0) {
1468 $filetocheck = DOL_DATA_ROOT.
'/'.$obj->filepath.
'/'.$obj->filename;
1472 if ($nbfiletodelete <= $MAXTODELETE) {
1473 print
'<tr><td>Found line with id '.$obj->rowid.
', entity '.$obj->entity.
', file "'.$filetocheck.
'" to delete';
1474 if (
GETPOST(
'clean_ecm_files_table',
'alpha') ==
'confirmed') {
1475 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"ecm_files WHERE rowid = ".((int) $obj->rowid);
1476 $resqldelete = $db->query($sqldelete);
1477 if (!$resqldelete) {
1491 if ($nbfiletodelete > $MAXTODELETE) {
1492 print
'<tr><td>There is more than '.$MAXTODELETE.
' invalid entries into ecm_files index table (among '.$nbfile.
' analyzed) with no valid physical files. Run the page several time to process all of them.</td></tr>';
1494 print
'<tr><td>Nb of entries processed into ecm_files index table: '.$nbfile.
', number of invalid record: '.$nbfiletodelete.
'</td></tr>';
1502if ($ok &&
GETPOST(
'force_utf8_on_tables',
'alpha')) {
1503 print
'<tr><td colspan="2"><br>*** Force page code and collation of tables into utf8/utf8_unicode_ci and row_format=dynamic (for mysql/mariadb only)</td></tr>';
1505 if ($db->type ==
"mysql" || $db->type ==
"mysqli") {
1506 $force_utf8_on_tables =
GETPOST(
'force_utf8_on_tables',
'alpha');
1508 $listoftables = $db->DDLListTablesFull($db->database_name);
1511 if ($force_utf8_on_tables ==
'confirmed') {
1512 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1513 print
'<!-- '.$sql.
' -->';
1514 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1515 $resql = $db->query($sql);
1518 $foreignkeystorestore = array();
1521 foreach ($listoftables as $table) {
1523 if ($conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1526 if ($table[1] ==
'VIEW') {
1527 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1532 $arrayofforeignkey = array(
1533 'llx_accounting_account' =>
'fk_accounting_account_fk_pcg_version',
1534 'llx_accounting_system' =>
'fk_accounting_account_fk_pcg_version',
1535 'llx_c_type_contact' =>
'fk_societe_commerciaux_fk_c_type_contact_code',
1536 'llx_societe_commerciaux' =>
'fk_societe_commerciaux_fk_c_type_contact_code'
1539 foreach ($arrayofforeignkey as $tmptable => $foreignkeyname) {
1540 if ($table[0] == $tmptable) {
1541 print
'<tr><td colspan="2">';
1542 $sqltmp =
"ALTER TABLE ".$db->sanitize($table[0]).
" DROP FOREIGN KEY ".$db->sanitize($foreignkeyname);
1544 if ($force_utf8_on_tables ==
'confirmed') {
1545 $resqltmp = $db->query($sqltmp);
1547 print
' - <span class="opacitymedium">Disabled</span>';
1550 $foreignkeystorestore[$tmptable] = $foreignkeyname;
1555 foreach ($listoftables as $table) {
1557 if ($conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1560 if ($table[1] ==
'VIEW') {
1561 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1565 $collation =
'utf8_unicode_ci';
1566 $defaultcollation = $db->getDefaultCollationDatabase();
1567 if (preg_match(
'/general/', $defaultcollation)) {
1568 $collation =
'utf8_general_ci';
1571 print
'<tr><td colspan="2">';
1573 $sql1 =
"ALTER TABLE ".$db->sanitize($table[0]).
" ROW_FORMAT=dynamic";
1574 $sql2 =
"ALTER TABLE ".$db->sanitize($table[0]).
" CONVERT TO CHARACTER SET utf8 COLLATE ".$db->sanitize($collation);
1575 print
'<!-- '.$sql1.
' -->';
1576 print
'<!-- '.$sql2.
' -->';
1577 if ($force_utf8_on_tables ==
'confirmed') {
1578 $resql1 = $db->query($sql1);
1580 $resql2 = $db->query($sql2);
1584 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag($db->lasterror).
'">(KO)</span>');
1586 print
' - <span class="opacitymedium">Disabled</span>';
1590 if (ob_get_level() > 0) {
1596 foreach ($foreignkeystorestore as $tmptable => $foreignkeyname) {
1597 $stringtofindinline =
"ALTER TABLE .* ADD CONSTRAINT ".$db->sanitize($foreignkeyname);
1598 $fileforkeys = DOL_DOCUMENT_ROOT.
'/install/mysql/tables/'.$tmptable.
'.key.sql';
1601 $handle = fopen($fileforkeys,
'r');
1603 while (($line = fgets($handle)) !==
false) {
1605 if (preg_match(
'/^'.$stringtofindinline.
'/i', $line)) {
1606 $resqltmp = $db->query($line);
1607 print
'<tr><td colspan="2">';
1609 print
' - Done '.($resqltmp ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.dol_escape_htmltag($db->lasterror).
'">(KO)</span>');
1617 if (ob_get_level() > 0) {
1623 if ($force_utf8_on_tables ==
'confirmed') {
1624 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1625 print
'<!-- '.$sql.
' -->';
1626 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1627 $resql = $db->query($sql);
1630 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1635if ($ok &&
GETPOST(
'force_utf8mb4_on_tables',
'alpha')) {
1636 print
'<tr><td colspan="2"><br>*** Force page code and collation of tables into utf8mb4/utf8mb4_unicode_ci (for mysql/mariadb only)</td></tr>';
1638 if ($db->type ==
"mysql" || $db->type ==
"mysqli") {
1639 $force_utf8mb4_on_tables =
GETPOST(
'force_utf8mb4_on_tables',
'alpha');
1642 $listoftables = $db->DDLListTablesFull($db->database_name);
1645 if ($force_utf8mb4_on_tables ==
'confirmed') {
1646 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1647 print
'<!-- '.$sql.
' -->';
1648 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1649 $resql = $db->query($sql);
1652 $foreignkeystorestore = array();
1655 foreach ($listoftables as $table) {
1657 if ($conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1660 if ($table[1] ==
'VIEW') {
1661 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1666 $arrayofforeignkey = array(
1667 'llx_accounting_account' =>
'fk_accounting_account_fk_pcg_version',
1668 'llx_accounting_system' =>
'fk_accounting_account_fk_pcg_version',
1669 'llx_c_type_contact' =>
'fk_societe_commerciaux_fk_c_type_contact_code',
1670 'llx_societe_commerciaux' =>
'fk_societe_commerciaux_fk_c_type_contact_code'
1673 foreach ($arrayofforeignkey as $tmptable => $foreignkeyname) {
1674 if ($table[0] == $tmptable) {
1675 print
'<tr><td colspan="2">';
1676 $sqltmp =
"ALTER TABLE ".$db->sanitize($table[0]).
" DROP FOREIGN KEY ".$db->sanitize($foreignkeyname);
1678 if ($force_utf8mb4_on_tables ==
'confirmed') {
1679 $resqltmp = $db->query($sqltmp);
1681 print
' - <span class="opacitymedium">Disabled</span>';
1684 $foreignkeystorestore[$tmptable] = $foreignkeyname;
1689 foreach ($listoftables as $table) {
1691 if ($conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1694 if ($table[1] ==
'VIEW') {
1695 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1699 $collation =
'utf8mb4_unicode_ci';
1700 $defaultcollation = $db->getDefaultCollationDatabase();
1701 if (preg_match(
'/general/', $defaultcollation)) {
1702 $collation =
'utf8mb4_general_ci';
1705 print
'<tr><td colspan="2">';
1707 $sql1 =
"ALTER TABLE ".$db->sanitize($table[0]).
" ROW_FORMAT=dynamic";
1708 $sql2 =
"ALTER TABLE ".$db->sanitize($table[0]).
" CONVERT TO CHARACTER SET utf8mb4 COLLATE ".$db->sanitize($collation);
1709 print
'<!-- '.$sql1.
' -->';
1710 print
'<!-- '.$sql2.
' -->';
1711 if ($force_utf8mb4_on_tables ==
'confirmed') {
1712 $resql1 = $db->query($sql1);
1714 $resql2 = $db->query($sql2);
1718 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag($db->lasterror).
'">(KO)</span>');
1720 print
' - <span class="opacitymedium">Disabled</span>';
1724 if (ob_get_level() > 0) {
1730 foreach ($foreignkeystorestore as $tmptable => $foreignkeyname) {
1731 $stringtofindinline =
"ALTER TABLE .* ADD CONSTRAINT ".$db->sanitize($foreignkeyname);
1732 $fileforkeys = DOL_DOCUMENT_ROOT.
'/install/mysql/tables/'.$tmptable.
'.key.sql';
1735 $handle = fopen($fileforkeys,
'r');
1737 while (($line = fgets($handle)) !==
false) {
1739 if (preg_match(
'/^'.$stringtofindinline.
'/i', $line)) {
1740 $resqltmp = $db->query($line);
1741 print
'<tr><td colspan="2">';
1743 print
' - Done '.($resqltmp ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.dol_escape_htmltag($db->lasterror).
'">(KO)</span>');
1751 if (ob_get_level() > 0) {
1757 if ($force_utf8mb4_on_tables ==
'confirmed') {
1758 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1759 print
'<!-- '.$sql.
' -->';
1760 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1761 $resql = $db->query($sql);
1764 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1768if ($ok &&
GETPOST(
'force_collation_from_conf_on_tables',
'alpha')) {
1769 print
'<tr><td colspan="2"><br>*** Force page code and collation of tables into '.$conf->db->character_set.
'/'.$conf->db->dolibarr_main_db_collation.
' and row_format=dynamic (for mysql/mariadb only)</td></tr>';
1771 if ($db->type ==
"mysql" || $db->type ==
"mysqli") {
1772 $force_collation_from_conf_on_tables =
GETPOST(
'force_collation_from_conf_on_tables',
'alpha');
1774 $listoftables = $db->DDLListTablesFull($db->database_name);
1777 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1778 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1779 print
'<!-- '.$sql.
' -->';
1780 $resql = $db->query($sql);
1783 foreach ($listoftables as $table) {
1785 if ($conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1788 if ($table[1] ==
'VIEW') {
1789 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' (Skipped)</td></tr>';
1793 print
'<tr><td colspan="2">';
1795 $sql1 =
"ALTER TABLE ".$table[0].
" ROW_FORMAT=dynamic";
1796 $sql2 =
"ALTER TABLE ".$table[0].
" CONVERT TO CHARACTER SET ".$conf->db->character_set.
" COLLATE ".$conf->db->dolibarr_main_db_collation;
1797 print
'<!-- '.$sql1.
' -->';
1798 print
'<!-- '.$sql2.
' -->';
1799 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1800 $resql1 = $db->query($sql1);
1802 $resql2 = $db->query($sql2);
1806 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag($db->lasterror).
'">(KO)</span>');
1808 print
' - <span class="opacitymedium">Disabled</span>';
1814 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1815 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1816 print
'<!-- '.$sql.
' -->';
1817 $resql = $db->query($sql);
1820 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1825if ($ok &&
GETPOST(
'rebuild_sequences',
'alpha')) {
1826 print
'<tr><td colspan="2"><br>*** Force to rebuild sequences (for postgresql only)</td></tr>';
1828 if ($db->type ==
"pgsql") {
1829 $rebuild_sequence =
GETPOST(
'rebuild_sequences',
'alpha');
1831 if ($rebuild_sequence ==
'confirmed') {
1832 $sql =
"SELECT dol_util_rebuild_sequences();";
1833 print
'<!-- '.$sql.
' -->';
1834 $resql = $db->query($sql);
1837 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1842if ($ok &&
GETPOST(
'repair_link_dispatch_lines_supplier_order_lines')) {
1866 $repair_link_dispatch_lines_supplier_order_lines =
GETPOST(
'repair_link_dispatch_lines_supplier_order_lines',
'alpha');
1869 echo
'<tr><th>Repair llx_receptiondet_batch.fk_commandefourndet</th></tr>';
1870 echo
'<tr><td>Repair in progress. This may take a while.</td></tr>';
1872 $sql_dispatch =
'SELECT * FROM '.MAIN_DB_PREFIX.
'receptiondet_batch WHERE COALESCE(fk_elementdet, 0) = 0';
1874 $resql_dispatch = $db->query($sql_dispatch);
1875 $n_processed_rows = 0;
1877 if ($resql_dispatch) {
1878 if ($db->num_rows($resql_dispatch) == 0) {
1879 echo
'<tr><td>Nothing to do.</td></tr>';
1882 while ($obj_dispatch = $db->fetch_object($resql_dispatch)) {
1883 $sql_line =
'SELECT line.rowid, line.qty FROM '.MAIN_DB_PREFIX.
'commande_fournisseurdet AS line';
1884 $sql_line .=
' WHERE line.fk_commande = '.((int) $obj_dispatch->fk_commande);
1885 $sql_line .=
' AND line.fk_product = '.((int) $obj_dispatch->fk_product);
1886 $resql_line = $db->query($sql_line);
1892 $remaining_qty = $obj_dispatch->qty;
1893 $first_iteration =
true;
1895 echo
'<tr><td>Unable to find a matching supplier order line for dispatch #'.$obj_dispatch->rowid.
'</td></tr>';
1896 $errors[] = $sql_line;
1897 $n_processed_rows++;
1900 if ($db->num_rows($resql_line) == 0) {
1903 while ($obj_line = $db->fetch_object($resql_line)) {
1904 if (!$remaining_qty) {
1907 if (!$obj_line->rowid) {
1910 $qty_for_line = min($remaining_qty, $obj_line->qty);
1911 if ($first_iteration) {
1912 $sql_attach =
'UPDATE '.MAIN_DB_PREFIX.
'receptiondet_batch';
1913 $sql_attach .=
' SET fk_elementdet = '.((int) $obj_line->rowid).
', qty = '.((float) $qty_for_line);
1914 $sql_attach .=
' WHERE rowid = '.((int) $obj_dispatch->rowid);
1915 $first_iteration =
false;
1917 $sql_attach_values = array(
1918 (
string) ((
int) $obj_dispatch->fk_element),
1919 (
string) ((
int) $obj_dispatch->fk_product),
1920 (
string) ((
int) $obj_line->rowid),
1921 (
string) ((
float) $qty_for_line),
1922 (
string) ((
int) $obj_dispatch->fk_entrepot),
1923 (
string) ((
int) $obj_dispatch->fk_user),
1924 $obj_dispatch->datec ?
"'".$db->idate($db->jdate($obj_dispatch->datec)).
"'" :
'NULL',
1925 $obj_dispatch->comment ?
"'".$db->escape($obj_dispatch->comment).
"'" :
'NULL',
1926 $obj_dispatch->
status ? (string) ((int) $obj_dispatch->
status) :
'NULL',
1927 $obj_dispatch->tms ?
"'".$db->idate($db->jdate($obj_dispatch->tms)).
"'" :
'NULL',
1928 $obj_dispatch->batch ?
"'".$db->escape($obj_dispatch->batch).
"'" :
'NULL',
1929 $obj_dispatch->eatby ?
"'".$db->escape($obj_dispatch->eatby).
"'" :
'NULL',
1930 $obj_dispatch->sellby ?
"'".$db->escape($obj_dispatch->sellby).
"'" :
'NULL'
1932 $sql_attach_values = implode(
', ', $sql_attach_values);
1934 $sql_attach =
'INSERT INTO '.MAIN_DB_PREFIX.
'receptiondet_batch';
1935 $sql_attach .=
' (fk_element, fk_product, fk_elementdet, qty, fk_entrepot, fk_user, datec, comment, status, tms, batch, eatby, sellby)';
1936 $sql_attach .=
" VALUES (".$sql_attach_values.
")";
1939 if ($repair_link_dispatch_lines_supplier_order_lines ==
'confirmed') {
1940 $resql_attach = $db->query($sql_attach);
1942 $resql_attach =
true;
1945 if ($resql_attach) {
1946 $remaining_qty -= $qty_for_line;
1948 $errors[] = $sql_attach;
1951 $first_iteration =
false;
1953 $n_processed_rows++;
1956 if (!($n_processed_rows & 0xff)) {
1957 echo
'<tr><td>Processed '.$n_processed_rows.
' rows with '.count($errors).
' errors…'.
"</td></tr>\n";
1959 if (ob_get_level() > 0) {
1965 echo
'<tr><td>Unable to find any dispatch without an fk_commandefourndet.'.
"</td></tr>\n";
1966 echo $sql_dispatch.
"\n";
1968 echo
'<tr><td>Fixed '.$n_processed_rows.
' rows with '.count($errors).
' errors…'.
"</td></tr>\n";
1969 echo
'<tr><td>DONE.'.
"</td></tr>\n";
1971 if (count($errors)) {
1973 echo
'<tr><td>The transaction was rolled back due to errors: nothing was changed by the script.</td></tr>';
1979 echo
'<tr><td><h3>SQL queries with errors:</h3></tr></td>';
1980 echo
'<tr><td>'.implode(
'</td></tr><tr><td>', $errors).
'</td></tr>';
1984if ($ok &&
GETPOST(
'repair_supplier_order_duplicate_ref')) {
1985 require_once DOL_DOCUMENT_ROOT .
'/fourn/class/fournisseur.commande.class.php';
1986 include_once DOL_DOCUMENT_ROOT .
'/societe/class/societe.class.php';
1993 $sql =
"SELECT * FROM " . MAIN_DB_PREFIX .
"commande_fournisseur";
1994 $sql .=
" WHERE ref IN (SELECT cf.ref FROM " . MAIN_DB_PREFIX .
"commande_fournisseur cf GROUP BY cf.ref, cf.entity HAVING COUNT(cf.rowid) > 1)";
1997 $duplicateSupplierOrders = [];
1998 $resql = $db->query($sql);
2000 while ($rawSupplierOrder = $db->fetch_object($resql)) {
2002 $supplierOrder->setVarsFromFetchObj($rawSupplierOrder);
2004 $duplicateSupplierOrders[$rawSupplierOrder->ref] [] = $supplierOrder;
2011 foreach ($duplicateSupplierOrders as $ref => $supplierOrders) {
2013 foreach (array_slice($supplierOrders, 1) as $supplierOrder) {
2016 $soc->fetch((
int) $supplierOrder->fourn_id);
2018 $newRef = $supplierOrder->getNextNumRef($soc);
2020 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"commande_fournisseur cf SET cf.ref = '" . $db->escape($newRef) .
"' WHERE cf.rowid = " . (int) $supplierOrder->id;
2021 if (!$db->query($sql)) {
2037if ($ok &&
GETPOST(
'recalculateinvoicetotal') ==
'confirmed') {
2043 SUM(fd.total_ht) as total_ht
2044 FROM ".MAIN_DB_PREFIX.
"facture f
2045 LEFT JOIN ".MAIN_DB_PREFIX.
"facturedet fd
2046 ON fd.fk_facture = f.rowid
2047 WHERE f.total_ht = 0
2048 GROUP BY fd.fk_facture HAVING SUM(fd.total_ht) <> 0";
2049 $resql = $db->query($sql);
2051 $num = $db->num_rows($resql);
2052 print
"We found ".$num.
" factures qualified that will have their total recalculated because they are at zero and line items not at zero\n";
2053 dol_syslog(
"We found ".$num.
" factures qualified that will have their total recalculated because they are at zero and line items not at zero");
2058 $obj = $db->fetch_object($resql);
2061 SUM(fd.total_ht) as 'total_ht',
2062 SUM(fd.total_tva) as 'total_tva',
2063 SUM(fd.total_localtax1) as 'localtax1',
2064 SUM(fd.total_localtax2) as 'localtax2',
2065 SUM(fd.total_ttc) as 'total_ttc'
2067 ".MAIN_DB_PREFIX.
"facturedet fd
2069 fd.fk_facture = $obj->rowid";
2070 $ressql_calculs = $db->query($sql_calculs);
2071 while ($obj_calcul = $db->fetch_object($ressql_calculs)) {
2073 $sql_paiements =
"SELECT SUM(amount) as somme from ".MAIN_DB_PREFIX.
"paiement_facture WHERE fk_facture = $obj->rowid";
2074 $montantPaiements = $db->fetch_object($db->query($sql_paiements))->somme;
2075 $totHt= ($obj_calcul->total_ht ?
price2num($obj_calcul->total_ht,
'MT') : 0);
2076 $totTva = ($obj_calcul->total_tva ?
price2num($obj_calcul->total_tva,
'MT') : 0);
2077 $totLocal1 = ($obj_calcul->localtax1 ?
price2num($obj_calcul->localtax1,
'MT') : 0);
2078 $totLocal2 = ($obj_calcul->localtax2 ?
price2num($obj_calcul->localtax2,
'MT') : 0);
2079 $totTtc = $totHt + $totTva + $totLocal1 + $totLocal2;
2081 UPDATE ".MAIN_DB_PREFIX.
"facture
2084 total_tva = $totTva,
2085 localtax1 = $totLocal1,
2086 localtax2 = $totLocal2,
2087 total_ttc = $totTtc,
2088 fk_statut = ".($totTtc ==
price2num($montantPaiements,
'MT') ? 2 : 1 ).
",
2089 paid = ".($totTtc ==
price2num($montantPaiements,
'MT') ? 1 : 0 ).
"
2091 rowid = $obj->rowid";
2092 $db->query($sql_maj);
2097 print
"Pas de factures à traiter\n";
2101 dol_syslog(
"calculate_total_and_taxes.php: Error");
2113if ($ok &&
GETPOST(
'repair_mailing_path')) {
2115 $sav_user = is_object($user) ? clone $user : $user;
2117 require_once DOL_DOCUMENT_ROOT.
'/comm/mailing/class/mailing.class.php';
2118 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
2120 print
'<tr><td colspan="2"><br>*** Repair mailing path<br>';
2128 function migrate_mailing_filespath($mailing)
2130 global $db, $conf, $user;
2132 $dir = $conf->mailing->dir_output;
2133 $origin = $dir.
'/'.
get_exdir($mailing->id, 2, 0, 1, $mailing,
'mailing');
2134 $destin = $dir.
'/'.
get_exdir($mailing->id, 0, 0, 1, $mailing,
'mailing');
2140 $user =
new User($db);
2141 $user->fetch($mailing->user_creation_id);
2144 $handle = opendir($origin_osencoded);
2145 if (is_resource($handle)) {
2146 while (($file = readdir($handle)) !==
false) {
2147 if ($file !=
'.' && $file !=
'..' && is_dir($origin_osencoded.
'/'.$file)) {
2148 $thumbs = opendir($origin_osencoded.
'/'.$file);
2149 if (is_resource($thumbs)) {
2151 while (($thumb = readdir($thumbs)) !==
false) {
2152 $res =
dol_move($origin.
'/'.$file.
'/'.$thumb, $destin.
'/'.$file.
'/'.$thumb);
2153 $msg = ($res ?
' * Migration successful' :
'Migration failed') .
' for file '.$origin.
'/'.$file.
'.<br>';
2160 $res =
dol_move($origin.
'/'.$file, $destin.
'/'.$file);
2161 $msg = ($res ?
' * Migration successful' :
'Migration failed') .
' for file '.$origin.
'/'.$file.
'.<br>';
2172 $sql =
"SELECT rowid as mid from ".MAIN_DB_PREFIX.
"mailing";
2173 $resql = $db->query($sql);
2175 while ($obj = $db->fetch_object($resql)) {
2176 $mailing->fetch($obj->mid);
2177 print
"Migrating mailing id=".$mailing->id.
" ref=".$mailing->ref.
"<br>\n";
2178 migrate_mailing_filespath($mailing);
2192if (empty($actiondone)) {
2193 print
'<div class="error">'.$langs->trans(
"ErrorWrongParameters").
'</div>';
2198 print
'<div class="center" style="padding-top: 10px"><a href="../index.php?mainmenu=home&leftmenu=home'.(GETPOSTISSET(
"login") ?
'&username='.urlencode(
GETPOST(
"login")) :
'').
'">';
2199 print
img_picto(
'',
'url',
'class="pictofixedwidth"');
2200 print $langs->trans(
"GoToDolibarr");
2207if ($db->connected) {
2212if (!$ok && isset($argv[1])) {
$id
Support class for third parties, contacts, members, users or resources.
run_sql($sqlfile, $silent=1, $entity=0, $usesavepoint=1, $handler='', $okerror='default', $linelengthlimit=32768, $nocommentremoval=0, $offsetforchartofaccount=0, $colspan=0, $onlysqltoimportwebsite=0, $database='')
Launch a sql file.
Class for managing the social charges.
Class to manage predefined suppliers products.
Class to manage customers orders.
Class to manage suppliers invoices.
Class to manage invoices.
Class to manage emailings module.
Class to manage proposals.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
dol_move($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=1, $moreinfo=array(), $entity=null)
Move a file into another name.
dol_copy($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=0)
Copy a file to another 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.
dol_delete_dir($dir, $nophperrors=0)
Remove a directory (not recursive, so content must be empty).
dol_is_file($pathoffile)
Return if path is a file.
dol_dir_list($utf8_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.
dol_is_dir($folder)
Test if filename is a directory.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dol_osencode($str)
Return a string encoded into OS filesystem encoding.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
get_exdir($num, $level, $alpha, $withoutslash, $object, $modulepart='')
Return a path to have a the directory according to object where files are stored.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
getDoliDBInstance($type, $host, $user, $pass, $name, $port)
Return a DoliDB instance (database handler).
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
vignette($file, $maxWidth=160, $maxHeight=120, $extName='_small', $quality=50, $outdir='thumbs', $targetformat=0)
Create a thumbnail from an image file (Supported extensions are gif, jpg, png and bmp).
image_format_supported($file, $acceptsvg=0)
Return if a filename is file name of a supported image format.
pHeader($subtitle, $next, $action='set', $param='', $forcejqueryurl='', $csstable='main-inside')
Show HTML header of install pages.
pFooter($nonext=0, $setuplang='', $jscheckfunction='', $withpleasewait=0, $morehtml='')
Print HTML footer of install pages.
dolibarr_install_syslog($message, $level=LOG_DEBUG)
Log function for install pages.
clean_data_ecm_directories()
Clean data into ecm_directories table.
dol_decode($chain, $key='1')
Decode a base 64 encoded + specific delta change.
dolDecrypt($chain, $key='')
Decode a string with a symmetric encryption.