32include_once
'inc.php';
54@phan-var-force ?string $dolibarr_main_db_encryption
55@phan-var-force ?string $dolibarr_main_db_cryptkey
56@phan-var-force ?string $dolibarr_main_db_type
63require_once $dolibarr_main_document_root.
'/core/lib/admin.lib.php';
64include_once $dolibarr_main_document_root.
'/core/lib/images.lib.php';
65require_once $dolibarr_main_document_root.
'/core/class/extrafields.class.php';
66require_once $dolibarr_main_document_root.
'/core/class/html.form.class.php';
67require_once
'lib/repair.lib.php';
74$err = error_reporting();
79$setuplang =
GETPOST(
"selectlang",
'aZ09', 3) ?
GETPOST(
"selectlang",
'aZ09', 3) :
'auto';
80$langs->setDefaultLang($setuplang);
82$langs->loadLangs(array(
"admin",
"install",
"other"));
84if ($dolibarr_main_db_type ==
"mysqli") {
87if ($dolibarr_main_db_type ==
"pgsql") {
90if ($dolibarr_main_db_type ==
"mssql") {
96if (!is_object(
$conf)) {
104require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
105$user =
new User($db);
112pHeader($langs->trans(
"Repair"),
"upgrade2",
GETPOST(
'action',
'aZ09'));
117print
'<div class="div-table-responsive-no-min">';
118print
'<table cellspacing="0" cellpadding="1" class="centpercent">';
122if (preg_match(
'/(crypted|dolcrypt):/i', $dolibarr_main_db_pass) || !empty($dolibarr_main_db_encrypted_pass)) {
123 require_once $dolibarr_main_document_root.
'/core/lib/security.lib.php';
124 if (preg_match(
'/crypted:/i', $dolibarr_main_db_pass)) {
125 $dolibarr_main_db_pass = preg_replace(
'/crypted:/i',
'', $dolibarr_main_db_pass);
126 $dolibarr_main_db_encrypted_pass = $dolibarr_main_db_pass;
127 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_pass);
128 } elseif (preg_match(
'/dolcrypt:/i', $dolibarr_main_db_pass)) {
129 $dolibarr_main_db_encrypted_pass = $dolibarr_main_db_pass;
130 $dolibarr_main_db_pass =
dolDecrypt($dolibarr_main_db_pass);
132 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_encrypted_pass);
137$conf->db->type = $dolibarr_main_db_type;
138$conf->db->host = $dolibarr_main_db_host;
139$conf->db->port = $dolibarr_main_db_port;
140$conf->db->name = $dolibarr_main_db_name;
141$conf->db->user = $dolibarr_main_db_user;
142$conf->db->pass = $dolibarr_main_db_pass;
145$conf->db->dolibarr_main_db_encryption = isset($dolibarr_main_db_encryption) ? $dolibarr_main_db_encryption : 0;
146$conf->db->dolibarr_main_db_cryptkey = isset($dolibarr_main_db_cryptkey) ? $dolibarr_main_db_cryptkey :
'';
150$form =
new Form($db);
153 print
'<tr><td class="nowrap">';
154 print $langs->trans(
"ServerConnection").
" : ".$dolibarr_main_db_host.
'</td><td class="right">'.$langs->trans(
"OK").
"</td></tr>";
155 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ServerConnection").
": ".$dolibarr_main_db_host.$langs->transnoentities(
"OK"));
158 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right">'.$langs->transnoentities(
"Error").
"</td></tr>";
159 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
164 if (
$db->database_selected) {
165 print
'<tr><td class="nowrap">';
166 print $langs->trans(
"DatabaseConnection").
" : ".$dolibarr_main_db_name.
'</td><td class="right">'.$langs->trans(
"OK").
"</td></tr>";
170 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right">'.$langs->trans(
"Error").
"</td></tr>";
171 dolibarr_install_syslog(
"repair: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
178 $version =
$db->getVersion();
179 $versionarray =
$db->getVersionArray();
180 print
'<tr><td>'.$langs->trans(
"ServerVersion").
'</td>';
181 print
'<td class="right">'.$version.
'</td></tr>';
192print
'<div class="info" style="padding-top: 10px">';
193print
'Select a link "test" or "confirmed" to launch a reparation on the chosen option...';
197print
'<div class="div-table-responsive-no-min">';
198print
'<table class="liste centpercent" style="border: 1px solid #ccc">';
202print
'<th>Launch test</th>';
203print
'<th>Launch confirmed</th>';
206$warning_using_utf8mb4 =
'';
207if ($dolibarr_main_db_character_set !=
'utf8mb4') {
208 $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.">';
214 'name' =>
'standard',
215 'info' =>
'Miscellaneous fixes'
220 'name' =>
'force_disable_of_modules_not_found',
221 'info' =>
'Disable modules not found'
226 'name' =>
'restore_thirdparties_logos',
227 'info' =>
'Restore logos for thirdparties'
230 'name' =>
'restore_user_pictures',
231 'info' =>
'Restore user pictures'
234 'name' =>
'rebuild_product_thumbs',
235 'info' =>
'Rebuild product thumbnails'
238 'name' =>
'repair_mailing_path',
239 'info' =>
'Repair path of mailing files',
240 'tooltip' =>
'Should be applied when using emailing module with > 99 mailings. In that case, please also set MAILING_USE_NEW_PATH_FOR_FILES.'
243 'Clean tables and data' => [
245 'name' =>
'clean_linked_elements',
246 'info' =>
'Clean linked elements'
249 'name' =>
'clean_menus',
250 'info' =>
'Clean menus'
253 'name' =>
'clean_orphelin_dir',
254 'info' =>
'Clean orphan directories'
257 'name' =>
'clean_product_stock_batch',
258 'info' =>
'Clean product stock batch'
261 'name' =>
'clean_perm_table',
262 'info' =>
'Clean permissions table'
265 'name' =>
'clean_ecm_files_table',
266 'info' =>
'Clean ECM files table'
269 'name' =>
'repair_link_dispatch_lines_supplier_order_lines',
270 'info' =>
'Repair link between dispatch lines and supplier order lines'
273 'Init empty data' => [
275 'name' =>
'set_empty_time_spent_amount',
276 'info' =>
'Init empty time spent amount'
281 'name' =>
'force_utf8_on_tables',
282 'info' =>
'Force utf8 + row=dynamic, for mysql/mariadb only'
285 'name' =>
'force_utf8mb4_on_tables',
286 'info' =>
'Force utf8mb4 + row=dynamic, for mysql/mariadb only' . $warning_using_utf8mb4
289 'name' =>
'force_collation_from_conf_on_tables',
290 'info' =>
'Force '.$conf->db->character_set.
'/'.
$conf->db->dolibarr_main_db_collation.
' + row=dynamic, for mysql/mariadb only'
295if (
$db->type ==
'pgsql') {
296 $sections[
'Rebuild sequence'] = [
298 'name' =>
'rebuild_sequences',
299 'info' =>
'For postgresql only'
304$conf->use_javascript_ajax = 1;
306foreach ($sections as $section => $options) {
307 print
'<tr style="background:#f4f4f4;font-weight:bold"><td colspan="5">'.$section.
'</td></tr>';
308 foreach ($options as $opt) {
309 $option = $opt[
'name'];
310 $info = $opt[
'info'];
311 $tooltip = empty($opt[
'tooltip']) ?
'' : $opt[
'tooltip'];
312 $value =
GETPOST($option,
'alpha') ?
GETPOST($option,
'alpha') :
'undefined';
314 $url_test = $_SERVER[
'PHP_SELF'].
'?'.$option.
'=test#pleasebepatient';
315 $url_confirmed = $_SERVER[
'PHP_SELF'].
'?'.$option.
'=confirmed#pleasebepatient';
317 print
'<td>' . $option .
'</td>';
320 print $form->textwithpicto($info, $tooltip);
325 print
'<td class="center"><a href="'.$url_test.
'" title="Launch test on option '.$option.
'">test</a>'.($value ==
'test' ?
' (launched)' :
'').
'</td>';
326 print
'<td class="center"><a href="'.$url_confirmed.
'" title="Launch repair on option '.$option.
'">repair</a>'.($value ==
'confirmed' ?
' (launched)' :
'').
'</td>';
334print
'<br id="sectionresult">';
338$conf->setValues($db);
340if (defined(
'SYSLOG_FILE')) {
341 $conf->global->SYSLOG_FILE = constant(
'SYSLOG_FILE');
343$conf->global->MAIN_ENABLE_LOG_TO_HTML = 1;
348$oneoptionset = (
GETPOST(
'standard',
'alpha') ||
GETPOST(
'restore_thirdparties_logos',
'alpha') ||
GETPOST(
'clean_linked_elements',
'alpha') ||
GETPOST(
'clean_menus',
'alpha')
349 ||
GETPOST(
'clean_orphelin_dir',
'alpha') ||
GETPOST(
'clean_product_stock_batch',
'alpha') ||
GETPOST(
'set_empty_time_spent_amount',
'alpha') ||
GETPOST(
'rebuild_product_thumbs',
'alpha')
350 ||
GETPOST(
'clean_perm_table',
'alpha') ||
GETPOST(
'clean_ecm_files_table',
'alpha')
351 ||
GETPOST(
'force_disable_of_modules_not_found',
'alpha')
352 ||
GETPOST(
'force_utf8_on_tables',
'alpha') ||
GETPOST(
'force_utf8mb4_on_tables',
'alpha') ||
GETPOST(
'force_collation_from_conf_on_tables',
'alpha')
353 ||
GETPOST(
'rebuild_sequences',
'alpha') ||
GETPOST(
'recalculateinvoicetotal',
'alpha')) ||
GETPOST(
'repair_mailing_path',
'alpha');
355if ($ok && $oneoptionset) {
356 print
'<div id="pleasebepatient"></div>';
358 print $langs->trans(
"PleaseBePatient").
'<br><br>';
361 print str_repeat(
' ', 1024);
368print
'<table cellspacing="0" cellpadding="1" class="centpercent">';
371if ($ok &&
GETPOST(
'standard',
'alpha')) {
372 $dir =
"mysql/migration/";
379 $filesindir = array();
380 $handle = opendir($dir);
381 if (is_resource($handle)) {
382 while (($file = readdir($handle)) !==
false) {
383 if (preg_match(
'/\.sql$/i', $file)) {
384 $filesindir[] = $file;
390 foreach ($filesindir as $file) {
391 if (preg_match(
'/repair/i', $file)) {
397 foreach ($filelist as $file) {
398 print
'<tr><td class="nowrap">*** ';
399 print $langs->trans(
"Script").
'</td><td class="right">'.$file.
'</td></tr>';
401 $name = substr($file, 0,
dol_strlen($file) - 4);
404 $ok =
run_sql($dir.$file, 0, 0, 1);
411if ($ok &&
GETPOST(
'standard',
'alpha')) {
412 require_once DOL_DOCUMENT_ROOT.
'/contrat/class/contratligne.class.php';
414 print
'<tr><td colspan="2"><br>*** Update denormalized_lower_planned_end_date.</td></tr>';
415 $sqltoupdatecontract =
"UPDATE ".MAIN_DB_PREFIX.
"contrat";
416 $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.
")";
417 $resqltoupdatecontract =
$db->query($sqltoupdatecontract);
422 $listofmodulesextra = array(
'societe' =>
'societe',
'adherent' =>
'adherent',
'product' =>
'product',
423 'socpeople' =>
'socpeople',
'propal' =>
'propal',
'commande' =>
'commande',
424 'facture' =>
'facture',
'facturedet' =>
'facturedet',
'facture_rec' =>
'facture_rec',
'facturedet_rec' =>
'facturedet_rec',
425 'supplier_proposal' =>
'supplier_proposal',
'commande_fournisseur' =>
'commande_fournisseur',
426 'facture_fourn' =>
'facture_fourn',
'facture_fourn_rec' =>
'facture_fourn_rec',
'facture_fourn_det' =>
'facture_fourn_det',
'facture_fourn_det_rec' =>
'facture_fourn_det_rec',
427 'fichinter' =>
'fichinter',
'fichinterdet' =>
'fichinterdet',
428 'inventory' =>
'inventory',
429 'actioncomm' =>
'actioncomm',
'bom_bom' =>
'bom_bom',
'mrp_mo' =>
'mrp_mo',
430 'adherent_type' =>
'adherent_type',
'user' =>
'user',
'partnership' =>
'partnership',
'projet' =>
'projet',
'projet_task' =>
'projet_task',
'ticket' =>
'ticket',
'payment_various' =>
'payment_various');
433 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>';
434 foreach ($listofmodulesextra as $tablename => $elementtype) {
436 $tableextra = MAIN_DB_PREFIX.$tablename.
'_extrafields';
439 $arrayoffieldsdesc = $extrafields->fetch_name_optionals_label($elementtype);
442 $arrayoffieldsfound = array();
443 $resql =
$db->DDLDescTable($tableextra);
445 print
'<tr><td>Check availability of extra field for '.$tableextra;
447 while ($obj =
$db->fetch_object($resql)) {
448 $fieldname = $fieldtype =
'';
449 if (preg_match(
'/mysql/',
$db->type)) {
450 $fieldname = $obj->Field;
451 $fieldtype = $obj->Type;
453 $fieldname = isset($obj->Key) ? $obj->Key : $obj->attname;
454 $fieldtype = isset($obj->Type) ? $obj->Type :
'varchar';
457 if (empty($fieldname)) {
460 if (in_array($fieldname, array(
'rowid',
'tms',
'fk_object',
'import_key'))) {
463 $arrayoffieldsfound[$fieldname] = array(
'type' => $fieldtype);
465 print
' - Found '.count($arrayoffieldsfound).
' fields into table';
466 if (count($arrayoffieldsfound) > 0) {
467 print
' <span class="opacitymedium">('.implode(
', ', array_keys($arrayoffieldsfound)).
')</span>';
472 foreach ($arrayoffieldsdesc as $code => $label) {
473 if (!in_array($code, array_keys($arrayoffieldsfound))) {
474 print
'Found field '.$code.
' declared into '.MAIN_DB_PREFIX.
'extrafields table but not found into desc of table '.$tableextra.
" -> ";
475 $type = $extrafields->attributes[$elementtype][
'type'][$code];
476 $length = $extrafields->attributes[$elementtype][
'size'][$code];
482 if ($type ==
'boolean') {
485 } elseif ($type ==
'price') {
488 } elseif ($type ==
'phone') {
491 } elseif ($type ==
'mail') {
494 } elseif (($type ==
'select') || ($type ==
'sellist') || ($type ==
'radio') || ($type ==
'checkbox') || ($type ==
'chkbxlst')) {
497 } elseif ($type ==
'link') {
507 'value' => $lengthdb,
508 'attribute' => $attribute,
509 'default' => $default,
516 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
517 $result =
$db->DDLAddField($tableextra, $code, $field_desc,
"");
520 print
"KO ".$db->lasterror.
"<br>\n";
525 print
' - Mode test, no column added.';
530 print
"</td><td> </td></tr>\n";
532 print
'<tr><td>Table '.$tableextra.
' is not found</td><td></td></tr>'.
"\n";
539if ($ok &&
GETPOST(
'standard',
'alpha')) {
545if ($ok &&
GETPOST(
'standard',
'alpha')) {
546 print
'<tr><td colspan="2"><br>*** Clean constant record of modules not enabled</td></tr>';
548 $sql =
"SELECT name, entity, value";
549 $sql .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
550 $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'";
551 $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'";
552 $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_%'";
553 $sql .=
" OR name LIKE 'MAIN_MODULE_%_MODULEFOREXTERNAL'";
554 $sql .=
" ORDER BY name, entity";
556 $resql =
$db->query($sql);
558 $num =
$db->num_rows($resql);
565 $obj =
$db->fetch_object($resql);
568 if (preg_match(
'/MAIN_MODULE_([^_\W]+)_(\w+)/i', $obj->name, $reg)) {
572 $sql2 =
"SELECT COUNT(*) as nb";
573 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
574 $sql2 .=
" WHERE name = 'MAIN_MODULE_".$db->sanitize($name).
"'";
575 $sql2 .=
" AND entity = ".((int) $obj->entity);
576 $resql2 =
$db->query($sql2);
578 $obj2 =
$db->fetch_object($resql2);
579 if ($obj2 && $obj2->nb == 0) {
581 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = '".
$db->escape($obj->name).
"' AND entity = ".((int) $obj->entity);
583 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
584 $db->query($sqldelete);
586 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>';
588 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>';
608if ($ok &&
GETPOST(
'standard',
'alpha')) {
609 print
'<tr><td colspan="2"><br>*** Clean definition of boxes of modules not enabled</td></tr>';
611 $sql =
"SELECT file, entity FROM ".MAIN_DB_PREFIX.
"boxes_def";
612 $sql .=
" WHERE file like '%@%'";
614 $resql =
$db->query($sql);
616 $num =
$db->num_rows($resql);
623 $obj =
$db->fetch_object($resql);
626 if (preg_match(
'/^(\w+)@(\w+)$/i', $obj->file, $reg)) {
630 $sql2 =
"SELECT COUNT(*) as nb";
631 $sql2 .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
632 $sql2 .=
" WHERE name = 'MAIN_MODULE_".strtoupper($module).
"'";
633 $sql2 .=
" AND entity = ".((int) $obj->entity);
634 $sql2 .=
" AND value <> 0";
635 $resql2 =
$db->query($sql2);
637 $obj2 =
$db->fetch_object($resql2);
638 if ($obj2 && $obj2->nb == 0) {
640 $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).
")";
641 $sqldeleteb =
"DELETE FROM ".MAIN_DB_PREFIX.
"boxes_def WHERE file = '".
$db->escape($obj->file).
"' AND entity = ".((int) $obj->entity);
643 if (
GETPOST(
'standard',
'alpha') ==
'confirmed') {
644 $db->query($sqldeletea);
645 $db->query($sqldeleteb);
647 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>';
649 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>';
667if ($ok &&
GETPOST(
'restore_thirdparties_logos')) {
672 print
'<tr><td colspan="2"><br>*** Restore thirdparties logo<br>';
674 $sql =
"SELECT s.rowid, s.nom as name, s.logo FROM ".MAIN_DB_PREFIX.
"societe as s ORDER BY s.nom";
675 $resql =
$db->query($sql);
677 $num =
$db->num_rows($resql);
681 $obj =
$db->fetch_object($resql);
689 $tmp = explode(
'.', (
string) $obj->logo);
691 if (isset($tmp[1])) {
696 $filetotest = $dolibarr_main_data_root.
'/societe/logos/'.$name.$ext;
697 $filetotestsmall = $dolibarr_main_data_root.
'/societe/logos/thumbs/'.$name.
'_small'.$ext;
699 print
'Check thirdparty '.$obj->rowid.
' name='.$obj->name.
' logo='.$obj->logo.
' file '.$filetotest.
" exists=".$exists.
"<br>\n";
701 $filetarget = $dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/'.$name.$ext;
702 $filetargetsmall = $dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/thumbs/'.$name.
'_small'.$ext;
705 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
706 dol_mkdir($dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos');
709 print
" -> Copy file ".$filetotest.
" -> ".$filetarget.
"<br>\n";
710 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
711 dol_copy($filetotest, $filetarget,
'', 0);
717 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
718 dol_mkdir($dolibarr_main_data_root.
'/societe/'.$obj->rowid.
'/logos/thumbs');
720 print
" -> Copy file ".$filetotestsmall.
" -> ".$filetargetsmall.
"<br>\n";
721 if (
GETPOST(
'restore_thirdparties_logos',
'alpha') ==
'confirmed') {
722 dol_copy($filetotestsmall, $filetargetsmall,
'', 0);
741if ($ok &&
GETPOST(
'restore_user_pictures',
'alpha')) {
746 print
'<tr><td colspan="2"><br>*** Restore user pictures<br>';
748 $sql =
"SELECT s.rowid, s.firstname, s.lastname, s.login, s.photo FROM ".MAIN_DB_PREFIX.
"user as s ORDER BY s.rowid";
749 $resql =
$db->query($sql);
751 $num =
$db->num_rows($resql);
755 $obj =
$db->fetch_object($resql);
763 $tmp = explode(
'.', (
string) $obj->photo);
765 if (isset($tmp[1])) {
770 $filetotest = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/'.$name.$ext;
771 $filetotestsmall = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/thumbs/'.$name.
'_small'.$ext;
772 $filetotestmini = $dolibarr_main_data_root.
'/users/'.substr(sprintf(
'%08d', $obj->rowid), -1, 1).
'/'.substr(sprintf(
'%08d', $obj->rowid), -2, 1).
'/thumbs/'.$name.
'_mini'.$ext;
774 print
'Check user '.$obj->rowid.
' lastname='.$obj->lastname.
' firstname='.$obj->firstname.
' photo='.$obj->photo.
' file '.$filetotest.
" exists=".$exists.
"<br>\n";
776 $filetarget = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/'.$name.$ext;
777 $filetargetsmall = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs/'.$name.
'_small'.$ext;
778 $filetargetmini = $dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs/'.$name.
'_mini'.$ext;
782 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
783 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid);
786 print
" -> Copy file ".$filetotest.
" -> ".$filetarget.
"<br>\n";
787 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
788 dol_copy($filetotest, $filetarget,
'', 0);
794 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
795 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs');
798 print
" -> Copy file ".$filetotestsmall.
" -> ".$filetargetsmall.
"<br>\n";
799 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
800 dol_copy($filetotestsmall, $filetargetsmall,
'', 0);
806 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
807 dol_mkdir($dolibarr_main_data_root.
'/users/'.$obj->rowid.
'/thumbs');
810 print
" -> Copy file ".$filetotestmini.
" -> ".$filetargetmini.
"<br>\n";
811 if (
GETPOST(
'restore_user_pictures',
'alpha') ==
'confirmed') {
812 dol_copy($filetotestmini, $filetargetmini,
'', 0);
830if ($ok &&
GETPOST(
'rebuild_product_thumbs',
'alpha')) {
832 global $maxwidthsmall, $maxheightsmall, $maxwidthmini, $maxheightmini;
834 print
'<tr><td colspan="2"><br>*** Rebuild product thumbs<br>';
836 $sql =
"SELECT s.rowid, s.ref FROM ".MAIN_DB_PREFIX.
"product as s ORDER BY s.ref";
837 $resql =
$db->query($sql);
839 $num =
$db->num_rows($resql);
843 $obj =
$db->fetch_object($resql);
845 if (!empty($obj->ref)) {
846 $files =
dol_dir_list($dolibarr_main_data_root.
'/produit/'.$obj->ref,
'files', 0);
847 foreach ($files as $file) {
850 $imgThumbSmall =
'notbuild';
851 if (
GETPOST(
'rebuild_product_thumbs',
'alpha') ==
'confirmed') {
853 $imgThumbSmall =
vignette($file[
'fullname'], $maxwidthsmall, $maxheightsmall,
'_small', 50,
"thumbs");
855 print
'Check product '.$obj->rowid.
", file ".$file[
'fullname'].
" -> ".$imgThumbSmall.
" maxwidthsmall=".$maxwidthsmall.
" maxheightsmall=".$maxheightsmall.
"<br>\n";
856 $imgThumbMini =
'notbuild';
857 if (
GETPOST(
'rebuild_product_thumbs',
'alpha') ==
'confirmed') {
860 $imgThumbMini =
vignette($file[
'fullname'], $maxwidthmini, $maxheightmini,
'_mini', 50,
"thumbs");
862 print
'Check product '.$obj->rowid.
", file ".$file[
'fullname'].
" -> ".$imgThumbMini.
" maxwidthmini=".$maxwidthmini.
" maxheightmini=".$maxheightmini.
"<br>\n";
878if ($ok &&
GETPOST(
'clean_linked_elements',
'alpha')) {
879 print
'<tr><td colspan="2"><br>*** Check table of linked elements and delete orphelins links</td></tr>';
881 print
'<tr><td colspan="2">'.checkLinkedElements(
'propal',
'commande').
"</td></tr>\n";
884 print
'<tr><td colspan="2">'.checkLinkedElements(
'propal',
'facture').
"</td></tr>\n";
887 print
'<tr><td colspan="2">'.checkLinkedElements(
'commande',
'facture').
"</td></tr>\n";
890 print
'<tr><td colspan="2">'.checkLinkedElements(
'commande',
'shipping').
"</td></tr>\n";
893 print
'<tr><td colspan="2">'.checkLinkedElements(
'shipping',
'delivery').
"</td></tr>\n";
896 print
'<tr><td colspan="2">'.checkLinkedElements(
'order_supplier',
'invoice_supplier').
"</td></tr>\n";
901if ($ok &&
GETPOST(
'clean_menus',
'alpha')) {
902 print
'<tr><td colspan="2"><br>*** Clean menu entries coming from disabled modules</td></tr>';
904 $sql =
"SELECT rowid, module";
905 $sql .=
" FROM ".MAIN_DB_PREFIX.
"menu as c";
906 $sql .=
" WHERE module IS NOT NULL AND module <> ''";
907 $sql .=
" ORDER BY module";
909 $resql =
$db->query($sql);
911 $num =
$db->num_rows($resql);
915 $obj =
$db->fetch_object($resql);
917 $modulecond = $obj->module;
918 $modulecondarray = explode(
'|', $obj->module);
927 foreach ($modulecondarray as $tmpname) {
928 if ($tmpname ==
'margins') {
933 if (!empty(
$conf->$tmpname)) {
934 $result =
$conf->$tmpname->enabled;
941 if (!$moduleok && $modulecond) {
942 print
' - Module condition '.$modulecond.
' seems ko, we delete menu entry.';
943 if (
GETPOST(
'clean_menus') ==
'confirmed') {
944 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"menu WHERE module = '".
$db->escape($modulecond).
"'";
945 $resql2 =
$db->query($sql2);
950 print
' - <span class="warning">Cleaned</span>';
953 print
' - <span class="warning">Canceled (test mode)</span>';
956 print
' - Module condition '.$modulecond.
' is ok, we do nothing.';
975 print
'<tr><td>No menu entries of disabled menus found</td></tr>';
985if ($ok &&
GETPOST(
'clean_orphelin_dir',
'alpha')) {
986 $listmodulepart = array(
'company',
'invoice',
'invoice_supplier',
'propal',
'order',
'order_supplier',
'contract',
'tax');
987 foreach ($listmodulepart as $modulepart) {
988 $filearray = array();
989 $upload_dir = isset(
$conf->$modulepart->dir_output) ?
$conf->$modulepart->dir_output :
'';
990 if ($modulepart ==
'company') {
991 $upload_dir =
$conf->societe->dir_output;
993 if ($modulepart ==
'invoice') {
994 $upload_dir =
$conf->facture->dir_output;
996 if ($modulepart ==
'invoice_supplier') {
997 $upload_dir =
$conf->fournisseur->facture->dir_output;
999 if ($modulepart ==
'order') {
1000 $upload_dir =
$conf->commande->dir_output;
1002 if ($modulepart ==
'order_supplier') {
1003 $upload_dir =
$conf->fournisseur->commande->dir_output;
1005 if ($modulepart ==
'contract') {
1006 $upload_dir =
$conf->contrat->dir_output;
1009 if (empty($upload_dir)) {
1013 print
'<tr><td colspan="2"><br>*** Clean orphelins files into files '.$upload_dir.
'</td></tr>';
1015 $filearray =
dol_dir_list($upload_dir,
"files", 1,
'', array(
'^SPECIMEN\.pdf$',
'^\.',
'(\.meta|_preview.*\.png)$',
'^temp$',
'^payments$',
'^CVS$',
'^thumbs$'),
'', SORT_DESC, 1, 1);
1017 $object_instance =
null;
1019 if ($modulepart ==
'company') {
1020 include_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
1021 $object_instance =
new Societe($db);
1023 if ($modulepart ==
'invoice') {
1024 include_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
1025 $object_instance =
new Facture($db);
1026 } elseif ($modulepart ==
'invoice_supplier') {
1027 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
1029 } elseif ($modulepart ==
'propal') {
1030 include_once DOL_DOCUMENT_ROOT.
'/comm/propal/class/propal.class.php';
1031 $object_instance =
new Propal($db);
1032 } elseif ($modulepart ==
'order') {
1033 include_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
1034 $object_instance =
new Commande($db);
1035 } elseif ($modulepart ==
'order_supplier') {
1036 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.class.php';
1038 } elseif ($modulepart ==
'contract') {
1039 include_once DOL_DOCUMENT_ROOT.
'/contrat/class/contrat.class.php';
1040 $object_instance =
new Contrat($db);
1041 } elseif ($modulepart ==
'tax') {
1042 include_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
1046 foreach ($filearray as $key => $file) {
1047 if (!is_dir($file[
'name'])
1048 && $file[
'name'] !=
'.'
1049 && $file[
'name'] !=
'..'
1050 && $file[
'name'] !=
'CVS'
1053 $relativefile = preg_replace(
'/'.preg_quote($upload_dir.
'/',
'/').
'/',
'', $file[
'fullname']);
1058 $object_instance->id = 0;
1059 $object_instance->ref =
'';
1063 if ($modulepart ==
'invoice') {
1064 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1065 $ref = empty($reg[1]) ?
'' : $reg[1];
1067 if ($modulepart ==
'invoice_supplier') {
1068 preg_match(
'/(\d+)\/[^\/]+$/', $relativefile, $reg);
1069 $id = empty($reg[1]) ?
'' : $reg[1];
1071 if ($modulepart ==
'propal') {
1072 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1073 $ref = empty($reg[1]) ?
'' : $reg[1];
1075 if ($modulepart ==
'order') {
1076 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1077 $ref = empty($reg[1]) ?
'' : $reg[1];
1079 if ($modulepart ==
'order_supplier') {
1080 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1081 $ref = empty($reg[1]) ?
'' : $reg[1];
1083 if ($modulepart ==
'contract') {
1084 preg_match(
'/(.*)\/[^\/]+$/', $relativefile, $reg);
1085 $ref = empty($reg[1]) ?
'' : $reg[1];
1087 if ($modulepart ==
'tax') {
1088 preg_match(
'/(\d+)\/[^\/]+$/', $relativefile, $reg);
1092 if ((
$id || $ref) && $object_instance !==
null) {
1094 $result = $object_instance->fetch(
$id, $ref);
1098 print
'<tr><td colspan="2">';
1099 print
'Delete orphelins file '.$file[
'fullname'].
'<br>';
1100 if (
GETPOST(
'clean_orphelin_dir',
'alpha') ==
'confirmed') {
1105 } elseif ($result < 0) {
1106 print
'Error in '.get_class($object_instance).
'.fetch of id'.
$id.
' ref='.$ref.
', result='.$result.
'<br>';
1116if ($ok &&
GETPOST(
'clean_product_stock_batch',
'alpha')) {
1117 $methodtofix =
GETPOST(
'methodtofix',
'alpha') ?
GETPOST(
'methodtofix',
'alpha') :
'updatestock';
1119 print
'<tr><td colspan="2"><br>*** Clean table product_batch, methodtofix='.$methodtofix.
' (possible values: updatestock or updatebatch)</td></tr>';
1121 $sql =
"SELECT p.rowid, p.ref, p.tobatch, ps.rowid as psrowid, ps.fk_entrepot, ps.reel, SUM(pb.qty) as reelbatch";
1122 $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";
1123 $sql .=
" WHERE p.rowid = ps.fk_product";
1124 $sql .=
" GROUP BY p.rowid, p.ref, p.tobatch, ps.rowid, ps.fk_entrepot, ps.reel";
1125 $sql .=
" HAVING (SUM(pb.qty) IS NOT NULL AND reel != SUM(pb.qty)) OR (SUM(pb.qty) IS NULL AND p.tobatch > 0)";
1127 $resql =
$db->query($sql);
1129 $num =
$db->num_rows($resql);
1134 $obj =
$db->fetch_object($resql);
1135 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)';
1138 if ($obj->reel != $obj->reelbatch) {
1139 if (empty($obj->tobatch)) {
1141 print
' -> Delete qty '.$obj->reelbatch.
' for any lot linked to fk_product_stock='.$obj->psrowid;
1142 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_batch";
1143 $sql2 .=
" WHERE fk_product_stock = ".((int) $obj->psrowid);
1146 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1147 $resql2 =
$db->query($sql2);
1154 if ($methodtofix ==
'updatebatch') {
1156 print
' -> Insert qty '.($obj->reel - $obj->reelbatch).
' with lot 000000 linked to fk_product_stock='.$obj->psrowid;
1157 $sql2 =
"INSERT INTO ".MAIN_DB_PREFIX.
"product_batch(fk_product_stock, batch, qty)";
1158 $sql2 .=
"VALUES(".((int) $obj->psrowid).
", '000000', ".((float) ($obj->reel - $obj->reelbatch)).
")";
1161 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1162 $resql2 =
$db->query($sql2);
1171 if ($methodtofix ==
'updatestock') {
1173 print
' -> Update qty of product_stock with qty = '.($obj->reelbatch ? ((float) $obj->reelbatch) :
'0').
' for ps.rowid = '.((
int) $obj->psrowid);
1174 $sql2 =
"UPDATE ".MAIN_DB_PREFIX.
"product_stock";
1175 $sql2 .=
" SET reel = ".($obj->reelbatch ? ((float) $obj->reelbatch) :
'0').
" WHERE rowid = ".((
int) $obj->psrowid);
1178 if (
GETPOST(
'clean_product_stock_batch') ==
'confirmed') {
1183 $resql2 =
$db->query($sql2);
1186 $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)';
1187 $resql3 =
$db->query($sql3);
1212 print
'<tr><td colspan="2">Nothing to do</td></tr>';
1221if ($ok &&
GETPOST(
'clean_product_stock_negative_if_batch',
'alpha')) {
1222 print
'<tr><td colspan="2"><br>Clean table product_batch, methodtofix='.$methodtofix.
' (possible values: updatestock or updatebatch)</td></tr>';
1224 $sql =
"SELECT p.rowid, p.ref, p.tobatch, ps.rowid as psrowid, ps.fk_entrepot, ps.reel, SUM(pb.qty) as reelbatch";
1225 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product as p, ".MAIN_DB_PREFIX.
"product_stock as ps, ".MAIN_DB_PREFIX.
"product_batch as pb";
1226 $sql .=
" WHERE p.rowid = ps.fk_product AND ps.rowid = pb.fk_product_stock";
1227 $sql .=
" AND p.tobatch > 0";
1228 $sql .=
" GROUP BY p.rowid, p.ref, p.tobatch, ps.rowid, ps.fk_entrepot, ps.reel";
1229 $sql .=
" HAVING reel != SUM(pb.qty)";
1230 $resql =
$db->query($sql);
1232 $num =
$db->num_rows($resql);
1237 $obj =
$db->fetch_object($resql);
1238 print
'<tr><td>'.$obj->rowid.
'-'.$obj->ref.
'-'.$obj->fk_entrepot.
' -> '.$obj->psrowid.
': '.$obj->reel.
' != '.$obj->reelbatch;
1247if ($ok &&
GETPOST(
'set_empty_time_spent_amount',
'alpha')) {
1248 print
'<tr><td colspan="2"><br>*** Set value of time spent without amount</td></tr>';
1250 $sql =
"SELECT COUNT(ptt.rowid) as nb, u.rowid as user_id, u.login, u.thm as user_thm";
1251 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time as ptt, ".MAIN_DB_PREFIX.
"user as u";
1252 $sql .=
" WHERE ptt.fk_user = u.rowid";
1253 $sql .=
" AND ptt.thm IS NULL and u.thm > 0";
1254 $sql .=
" GROUP BY u.rowid, u.login, u.thm";
1256 $resql =
$db->query($sql);
1258 $num =
$db->num_rows($resql);
1263 $obj =
$db->fetch_object($resql);
1264 print
'<tr><td>'.$obj->login.
'-'.$obj->user_id.
' ('.$obj->nb.
' lines to fix) -> '.$obj->user_thm;
1268 if (
GETPOST(
'set_empty_time_spent_amount') ==
'confirmed') {
1269 $sql2 =
"UPDATE ".MAIN_DB_PREFIX.
"element_time";
1270 $sql2 .=
" SET thm = ".((float) $obj->user_thm).
" WHERE thm IS NULL AND fk_user = ".((int) $obj->user_id);
1271 $resql2 =
$db->query($sql2);
1293 print
'<tr><td>No time spent with empty line on users with a hourly rate defined</td></tr>';
1302if ($ok &&
GETPOST(
'force_disable_of_modules_not_found',
'alpha')) {
1303 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>';
1305 $arraylistofkey = array(
'hooks',
'js',
'css');
1307 foreach ($arraylistofkey as $key) {
1308 $sql =
"SELECT DISTINCT name, value";
1309 $sql .=
" FROM ".MAIN_DB_PREFIX.
"const as c";
1310 $sql .=
" WHERE name LIKE 'MAIN_MODULE_%_".strtoupper(
$db->escape($key)).
"'";
1311 $sql .=
" ORDER BY name";
1313 $resql =
$db->query($sql);
1315 $num =
$db->num_rows($resql);
1319 $obj =
$db->fetch_object($resql);
1320 $constantname = $obj->name;
1328 if (preg_match(
'/MAIN_MODULE_(.*)_'.strtoupper($key).
'/i', $constantname, $reg)) {
1329 $name = strtolower($reg[1]);
1335 if ($key ==
'hooks') {
1336 $reloffile = $name.
'/class/actions_'.$name.
'.class.php';
1339 $value = $obj->value;
1340 $valuearray = (array) json_decode($value);
1341 $reloffile = $valuearray[0];
1342 $reloffile = preg_replace(
'/^\//',
'', $valuearray[0]);
1344 if ($key ==
'css') {
1345 $value = $obj->value;
1346 $valuearray = (array) json_decode($value);
1347 if ($value && (!is_array($valuearray) || count($valuearray) == 0)) {
1348 $valuearray = array();
1349 $valuearray[0] = $value;
1351 $reloffile = preg_replace(
'/^\//',
'', $valuearray[0]);
1366 print
' - File of '.$key.
' ('.$reloffile.
') NOT found, we disable the module.';
1367 if (
GETPOST(
'force_disable_of_modules_not_found') ==
'confirmed') {
1368 $sql2 =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = 'MAIN_MODULE_".strtoupper($name).
"_".strtoupper($key).
"'";
1369 $resql2 =
$db->query($sql2);
1374 $sql3 =
"DELETE FROM ".MAIN_DB_PREFIX.
"const WHERE name = 'MAIN_MODULE_".strtoupper($name).
"'";
1375 $resql3 =
$db->query($sql3);
1380 print
' - <span class="warning">Cleaned</span>';
1383 print
' - <span class="warning">Canceled (test mode)</span>';
1386 print
' - File of '.$key.
' ('.$reloffile.
') found, we do nothing.';
1406 print
'<tr><td>No active module with missing files found by searching on MAIN_MODULE_(.*)_'.strtoupper($key).
'</td></tr>';
1416if ($ok &&
GETPOST(
'clean_perm_table',
'alpha')) {
1417 print
'<tr><td colspan="2"><br>*** Clean table user_rights from lines of external modules no more enabled</td></tr>';
1420 foreach (
$conf->modules as $key => $val) {
1421 $listofmods .= ($listofmods ?
',' :
'').
"'".
$db->escape($val).
"'";
1424 $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";
1426 $resql =
$db->query($sql);
1428 $num =
$db->num_rows($resql);
1432 $obj =
$db->fetch_object($resql);
1434 print
'<tr><td>Found line with id '.$obj->id.
', entity '.$obj->entity.
', label "'.$obj->label.
'" of module "'.$obj->module.
'" to delete';
1435 if (
GETPOST(
'clean_perm_table',
'alpha') ==
'confirmed') {
1438 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"rights_def WHERE id = ".((int) $obj->id);
1439 $sqldelete .=
" AND entity = ".((int) $obj->entity);
1440 $resqldelete =
$db->query($sqldelete);
1441 if (!$resqldelete) {
1451 print
'<tr><td>No lines of a disabled external module (with id > 100000) found into table rights_def</td></tr>';
1460if ($ok &&
GETPOST(
'clean_ecm_files_table',
'alpha')) {
1461 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>';
1465 $sql =
"SELECT rowid, filename, filepath, entity from ".MAIN_DB_PREFIX.
"ecm_files";
1466 $sql .=
" WHERE entity = 1";
1467 $sql .=
" ORDER BY rowid ASC";
1470 $nbfiletodelete = 0;
1472 $resql =
$db->query($sql);
1474 $num =
$db->num_rows($resql);
1478 $obj =
$db->fetch_object($resql);
1479 if ($obj->rowid > 0) {
1480 $filetocheck = DOL_DATA_ROOT.
'/'.$obj->filepath.
'/'.$obj->filename;
1484 if ($nbfiletodelete <= $MAXTODELETE) {
1485 print
'<tr><td>Found line with id '.$obj->rowid.
', entity '.$obj->entity.
', file "'.$filetocheck.
'" to delete';
1486 if (
GETPOST(
'clean_ecm_files_table',
'alpha') ==
'confirmed') {
1487 $sqldelete =
"DELETE FROM ".MAIN_DB_PREFIX.
"ecm_files WHERE rowid = ".((int) $obj->rowid);
1488 $resqldelete =
$db->query($sqldelete);
1489 if (!$resqldelete) {
1503 if ($nbfiletodelete > $MAXTODELETE) {
1504 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>';
1506 print
'<tr><td>Nb of entries processed into ecm_files index table: '.$nbfile.
', number of invalid record: '.$nbfiletodelete.
'</td></tr>';
1514if ($ok &&
GETPOST(
'force_utf8_on_tables',
'alpha')) {
1515 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>';
1517 if (
$db->type ==
"mysql" ||
$db->type ==
"mysqli") {
1518 $force_utf8_on_tables =
GETPOST(
'force_utf8_on_tables',
'alpha');
1520 $listoftables =
$db->DDLListTablesFull(
$db->database_name);
1523 if ($force_utf8_on_tables ==
'confirmed') {
1524 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1525 print
'<!-- '.$sql.
' -->';
1526 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1527 $resql =
$db->query($sql);
1530 $foreignkeystorestore = array();
1533 foreach ($listoftables as $table) {
1535 if (
$conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1538 if ($table[1] ==
'VIEW') {
1539 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1544 $arrayofforeignkey = array(
1545 'llx_accounting_account' =>
'fk_accounting_account_fk_pcg_version',
1546 'llx_accounting_system' =>
'fk_accounting_account_fk_pcg_version',
1547 'llx_c_type_contact' =>
'fk_societe_commerciaux_fk_c_type_contact_code',
1548 'llx_societe_commerciaux' =>
'fk_societe_commerciaux_fk_c_type_contact_code'
1551 foreach ($arrayofforeignkey as $tmptable => $foreignkeyname) {
1552 if ($table[0] == $tmptable) {
1553 print
'<tr><td colspan="2">';
1554 $sqltmp =
"ALTER TABLE ".$db->sanitize($table[0]).
" DROP FOREIGN KEY ".
$db->sanitize($foreignkeyname);
1556 if ($force_utf8_on_tables ==
'confirmed') {
1557 $resqltmp =
$db->query($sqltmp);
1559 print
' - <span class="opacitymedium">Disabled</span>';
1562 $foreignkeystorestore[$tmptable] = $foreignkeyname;
1567 foreach ($listoftables as $table) {
1569 if (
$conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1572 if ($table[1] ==
'VIEW') {
1573 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1577 $collation =
'utf8_unicode_ci';
1578 $defaultcollation =
$db->getDefaultCollationDatabase();
1579 if (preg_match(
'/general/', $defaultcollation)) {
1580 $collation =
'utf8_general_ci';
1583 print
'<tr><td colspan="2">';
1585 $sql1 =
"ALTER TABLE ".$db->sanitize($table[0]).
" ROW_FORMAT=dynamic";
1586 $sql2 =
"ALTER TABLE ".$db->sanitize($table[0]).
" CONVERT TO CHARACTER SET utf8 COLLATE ".
$db->sanitize($collation);
1587 print
'<!-- '.$sql1.
' -->';
1588 print
'<!-- '.$sql2.
' -->';
1589 if ($force_utf8_on_tables ==
'confirmed') {
1590 $resql1 =
$db->query($sql1);
1592 $resql2 =
$db->query($sql2);
1596 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag(
$db->lasterror).
'">(KO)</span>');
1598 print
' - <span class="opacitymedium">Disabled</span>';
1602 if (ob_get_level() > 0) {
1608 foreach ($foreignkeystorestore as $tmptable => $foreignkeyname) {
1609 $stringtofindinline =
"ALTER TABLE .* ADD CONSTRAINT ".$db->sanitize($foreignkeyname);
1610 $fileforkeys = DOL_DOCUMENT_ROOT.
'/install/mysql/tables/'.$tmptable.
'.key.sql';
1613 $handle = fopen($fileforkeys,
'r');
1615 while (($line = fgets($handle)) !==
false) {
1617 if (preg_match(
'/^'.$stringtofindinline.
'/i', $line)) {
1618 $resqltmp =
$db->query($line);
1619 print
'<tr><td colspan="2">';
1621 print
' - Done '.($resqltmp ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.dol_escape_htmltag(
$db->lasterror).
'">(KO)</span>');
1629 if (ob_get_level() > 0) {
1635 if ($force_utf8_on_tables ==
'confirmed') {
1636 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1637 print
'<!-- '.$sql.
' -->';
1638 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1639 $resql =
$db->query($sql);
1642 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1647if ($ok &&
GETPOST(
'force_utf8mb4_on_tables',
'alpha')) {
1648 print
'<tr><td colspan="2"><br>*** Force page code and collation of tables into utf8mb4/utf8mb4_unicode_ci (for mysql/mariadb only)</td></tr>';
1650 if (
$db->type ==
"mysql" ||
$db->type ==
"mysqli") {
1651 $force_utf8mb4_on_tables =
GETPOST(
'force_utf8mb4_on_tables',
'alpha');
1654 $listoftables =
$db->DDLListTablesFull(
$db->database_name);
1657 if ($force_utf8mb4_on_tables ==
'confirmed') {
1658 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1659 print
'<!-- '.$sql.
' -->';
1660 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1661 $resql =
$db->query($sql);
1664 $foreignkeystorestore = array();
1667 foreach ($listoftables as $table) {
1669 if (
$conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1672 if ($table[1] ==
'VIEW') {
1673 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1678 $arrayofforeignkey = array(
1679 'llx_accounting_account' =>
'fk_accounting_account_fk_pcg_version',
1680 'llx_accounting_system' =>
'fk_accounting_account_fk_pcg_version',
1681 'llx_c_type_contact' =>
'fk_societe_commerciaux_fk_c_type_contact_code',
1682 'llx_societe_commerciaux' =>
'fk_societe_commerciaux_fk_c_type_contact_code'
1685 foreach ($arrayofforeignkey as $tmptable => $foreignkeyname) {
1686 if ($table[0] == $tmptable) {
1687 print
'<tr><td colspan="2">';
1688 $sqltmp =
"ALTER TABLE ".$db->sanitize($table[0]).
" DROP FOREIGN KEY ".
$db->sanitize($foreignkeyname);
1690 if ($force_utf8mb4_on_tables ==
'confirmed') {
1691 $resqltmp =
$db->query($sqltmp);
1693 print
' - <span class="opacitymedium">Disabled</span>';
1696 $foreignkeystorestore[$tmptable] = $foreignkeyname;
1701 foreach ($listoftables as $table) {
1703 if (
$conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1706 if ($table[1] ==
'VIEW') {
1707 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' <span class="opacitymedium">(Skipped)</span></td></tr>';
1711 $collation =
'utf8mb4_unicode_ci';
1712 $defaultcollation =
$db->getDefaultCollationDatabase();
1713 if (preg_match(
'/general/', $defaultcollation)) {
1714 $collation =
'utf8mb4_general_ci';
1717 print
'<tr><td colspan="2">';
1719 $sql1 =
"ALTER TABLE ".$db->sanitize($table[0]).
" ROW_FORMAT=dynamic";
1720 $sql2 =
"ALTER TABLE ".$db->sanitize($table[0]).
" CONVERT TO CHARACTER SET utf8mb4 COLLATE ".
$db->sanitize($collation);
1721 print
'<!-- '.$sql1.
' -->';
1722 print
'<!-- '.$sql2.
' -->';
1723 if ($force_utf8mb4_on_tables ==
'confirmed') {
1724 $resql1 =
$db->query($sql1);
1726 $resql2 =
$db->query($sql2);
1730 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag(
$db->lasterror).
'">(KO)</span>');
1732 print
' - <span class="opacitymedium">Disabled</span>';
1736 if (ob_get_level() > 0) {
1742 foreach ($foreignkeystorestore as $tmptable => $foreignkeyname) {
1743 $stringtofindinline =
"ALTER TABLE .* ADD CONSTRAINT ".$db->sanitize($foreignkeyname);
1744 $fileforkeys = DOL_DOCUMENT_ROOT.
'/install/mysql/tables/'.$tmptable.
'.key.sql';
1747 $handle = fopen($fileforkeys,
'r');
1749 while (($line = fgets($handle)) !==
false) {
1751 if (preg_match(
'/^'.$stringtofindinline.
'/i', $line)) {
1752 $resqltmp =
$db->query($line);
1753 print
'<tr><td colspan="2">';
1755 print
' - Done '.($resqltmp ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.dol_escape_htmltag(
$db->lasterror).
'">(KO)</span>');
1763 if (ob_get_level() > 0) {
1769 if ($force_utf8mb4_on_tables ==
'confirmed') {
1770 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1771 print
'<!-- '.$sql.
' -->';
1772 print
'<tr><td colspan="2">'.$sql.
'</td></tr>';
1773 $resql =
$db->query($sql);
1776 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1780if ($ok &&
GETPOST(
'force_collation_from_conf_on_tables',
'alpha')) {
1781 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>';
1783 if (
$db->type ==
"mysql" ||
$db->type ==
"mysqli") {
1784 $force_collation_from_conf_on_tables =
GETPOST(
'force_collation_from_conf_on_tables',
'alpha');
1786 $listoftables =
$db->DDLListTablesFull(
$db->database_name);
1789 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1790 $sql =
'SET FOREIGN_KEY_CHECKS=0';
1791 print
'<!-- '.$sql.
' -->';
1792 $resql =
$db->query($sql);
1795 foreach ($listoftables as $table) {
1797 if (
$conf->db->dolibarr_main_db_encryption != 0 && preg_match(
'/\_const$/', $table[0])) {
1800 if ($table[1] ==
'VIEW') {
1801 print
'<tr><td colspan="2">'.$table[0].
' is a '.$table[1].
' (Skipped)</td></tr>';
1805 print
'<tr><td colspan="2">';
1807 $sql1 =
"ALTER TABLE ".$table[0].
" ROW_FORMAT=dynamic";
1808 $sql2 =
"ALTER TABLE ".$table[0].
" CONVERT TO CHARACTER SET ".
$conf->db->character_set.
" COLLATE ".
$conf->db->dolibarr_main_db_collation;
1809 print
'<!-- '.$sql1.
' -->';
1810 print
'<!-- '.$sql2.
' -->';
1811 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1812 $resql1 =
$db->query($sql1);
1814 $resql2 =
$db->query($sql2);
1818 print
' - Done '.(($resql1 && $resql2) ?
'<span class="opacitymedium">(OK)</span>' :
'<span class="error" title="'.
dol_escape_htmltag(
$db->lasterror).
'">(KO)</span>');
1820 print
' - <span class="opacitymedium">Disabled</span>';
1826 if ($force_collation_from_conf_on_tables ==
'confirmed') {
1827 $sql =
'SET FOREIGN_KEY_CHECKS=1';
1828 print
'<!-- '.$sql.
' -->';
1829 $resql =
$db->query($sql);
1832 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1837if ($ok &&
GETPOST(
'rebuild_sequences',
'alpha')) {
1838 print
'<tr><td colspan="2"><br>*** Force to rebuild sequences (for postgresql only)</td></tr>';
1840 if (
$db->type ==
"pgsql") {
1841 $rebuild_sequence =
GETPOST(
'rebuild_sequences',
'alpha');
1843 if ($rebuild_sequence ==
'confirmed') {
1844 $sql =
"SELECT dol_util_rebuild_sequences();";
1845 print
'<!-- '.$sql.
' -->';
1846 $resql =
$db->query($sql);
1849 print
'<tr><td colspan="2">Not available with database type '.$db->type.
'</td></tr>';
1854if ($ok &&
GETPOST(
'repair_link_dispatch_lines_supplier_order_lines')) {
1878 $repair_link_dispatch_lines_supplier_order_lines =
GETPOST(
'repair_link_dispatch_lines_supplier_order_lines',
'alpha');
1881 echo
'<tr><th>Repair llx_receptiondet_batch.fk_commandefourndet</th></tr>';
1882 echo
'<tr><td>Repair in progress. This may take a while.</td></tr>';
1884 $sql_dispatch =
'SELECT * FROM '.MAIN_DB_PREFIX.
'receptiondet_batch WHERE COALESCE(fk_elementdet, 0) = 0';
1886 $resql_dispatch =
$db->query($sql_dispatch);
1887 $n_processed_rows = 0;
1889 if ($resql_dispatch) {
1890 if (
$db->num_rows($resql_dispatch) == 0) {
1891 echo
'<tr><td>Nothing to do.</td></tr>';
1894 while ($obj_dispatch =
$db->fetch_object($resql_dispatch)) {
1895 $sql_line =
'SELECT line.rowid, line.qty FROM '.MAIN_DB_PREFIX.
'commande_fournisseurdet AS line';
1896 $sql_line .=
' WHERE line.fk_commande = '.((int) $obj_dispatch->fk_commande);
1897 $sql_line .=
' AND line.fk_product = '.((int) $obj_dispatch->fk_product);
1898 $resql_line =
$db->query($sql_line);
1904 $remaining_qty = $obj_dispatch->qty;
1905 $first_iteration =
true;
1907 echo
'<tr><td>Unable to find a matching supplier order line for dispatch #'.$obj_dispatch->rowid.
'</td></tr>';
1908 $errors[] = $sql_line;
1909 $n_processed_rows++;
1912 if (
$db->num_rows($resql_line) == 0) {
1915 while ($obj_line =
$db->fetch_object($resql_line)) {
1916 if (!$remaining_qty) {
1919 if (!$obj_line->rowid) {
1922 $qty_for_line = min($remaining_qty, $obj_line->qty);
1923 if ($first_iteration) {
1924 $sql_attach =
'UPDATE '.MAIN_DB_PREFIX.
'receptiondet_batch';
1925 $sql_attach .=
' SET fk_elementdet = '.((int) $obj_line->rowid).
', qty = '.((float) $qty_for_line);
1926 $sql_attach .=
' WHERE rowid = '.((int) $obj_dispatch->rowid);
1927 $first_iteration =
false;
1929 $sql_attach_values = array(
1930 (
string) ((
int) $obj_dispatch->fk_element),
1931 (
string) ((
int) $obj_dispatch->fk_product),
1932 (
string) ((
int) $obj_line->rowid),
1933 (
string) ((
float) $qty_for_line),
1934 (
string) ((
int) $obj_dispatch->fk_entrepot),
1935 (
string) ((
int) $obj_dispatch->fk_user),
1936 $obj_dispatch->datec ?
"'".$db->idate(
$db->jdate($obj_dispatch->datec)).
"'" :
'NULL',
1937 $obj_dispatch->comment ?
"'".
$db->escape($obj_dispatch->comment).
"'" :
'NULL',
1939 $obj_dispatch->tms ?
"'".
$db->idate(
$db->jdate($obj_dispatch->tms)).
"'" :
'NULL',
1940 $obj_dispatch->batch ?
"'".
$db->escape($obj_dispatch->batch).
"'" :
'NULL',
1941 $obj_dispatch->eatby ?
"'".
$db->escape($obj_dispatch->eatby).
"'" :
'NULL',
1942 $obj_dispatch->sellby ?
"'".
$db->escape($obj_dispatch->sellby).
"'" :
'NULL'
1944 $sql_attach_values = implode(
', ', $sql_attach_values);
1946 $sql_attach =
'INSERT INTO '.MAIN_DB_PREFIX.
'receptiondet_batch';
1947 $sql_attach .=
' (fk_element, fk_product, fk_elementdet, qty, fk_entrepot, fk_user, datec, comment, status, tms, batch, eatby, sellby)';
1948 $sql_attach .=
" VALUES (".$sql_attach_values.
")";
1951 if ($repair_link_dispatch_lines_supplier_order_lines ==
'confirmed') {
1952 $resql_attach =
$db->query($sql_attach);
1954 $resql_attach =
true;
1957 if ($resql_attach) {
1958 $remaining_qty -= $qty_for_line;
1960 $errors[] = $sql_attach;
1963 $first_iteration =
false;
1965 $n_processed_rows++;
1968 if (!($n_processed_rows & 0xff)) {
1969 echo
'<tr><td>Processed '.$n_processed_rows.
' rows with '.count($errors).
' errors…'.
"</td></tr>\n";
1971 if (ob_get_level() > 0) {
1977 echo
'<tr><td>Unable to find any dispatch without an fk_commandefourndet.'.
"</td></tr>\n";
1978 echo $sql_dispatch.
"\n";
1980 echo
'<tr><td>Fixed '.$n_processed_rows.
' rows with '.count($errors).
' errors…'.
"</td></tr>\n";
1981 echo
'<tr><td>DONE.'.
"</td></tr>\n";
1983 if (count($errors)) {
1985 echo
'<tr><td>The transaction was rolled back due to errors: nothing was changed by the script.</td></tr>';
1991 echo
'<tr><td><h3>SQL queries with errors:</h3></tr></td>';
1992 echo
'<tr><td>'.implode(
'</td></tr><tr><td>', $errors).
'</td></tr>';
1996if ($ok &&
GETPOST(
'repair_supplier_order_duplicate_ref')) {
1997 require_once DOL_DOCUMENT_ROOT .
'/fourn/class/fournisseur.commande.class.php';
1998 include_once DOL_DOCUMENT_ROOT .
'/societe/class/societe.class.php';
2005 $sql =
"SELECT * FROM " . MAIN_DB_PREFIX .
"commande_fournisseur";
2006 $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)";
2009 $duplicateSupplierOrders = [];
2010 $resql =
$db->query($sql);
2012 while ($rawSupplierOrder =
$db->fetch_object($resql)) {
2014 $supplierOrder->setVarsFromFetchObj($rawSupplierOrder);
2016 $duplicateSupplierOrders[$rawSupplierOrder->ref] [] = $supplierOrder;
2023 foreach ($duplicateSupplierOrders as $ref => $supplierOrders) {
2025 foreach (array_slice($supplierOrders, 1) as $supplierOrder) {
2028 $soc->fetch((
int) $supplierOrder->fourn_id);
2030 $newRef = $supplierOrder->getNextNumRef($soc);
2032 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"commande_fournisseur cf SET cf.ref = '" .
$db->escape($newRef) .
"' WHERE cf.rowid = " . (int) $supplierOrder->id;
2033 if (!
$db->query($sql)) {
2049if ($ok &&
GETPOST(
'recalculateinvoicetotal') ==
'confirmed') {
2055 SUM(fd.total_ht) as total_ht
2056 FROM ".MAIN_DB_PREFIX.
"facture f
2057 LEFT JOIN ".MAIN_DB_PREFIX.
"facturedet fd
2058 ON fd.fk_facture = f.rowid
2059 WHERE f.total_ht = 0
2060 GROUP BY fd.fk_facture HAVING SUM(fd.total_ht) <> 0";
2061 $resql =
$db->query($sql);
2063 $num =
$db->num_rows($resql);
2064 print
"We found ".$num.
" factures qualified that will have their total recalculated because they are at zero and line items not at zero\n";
2065 dol_syslog(
"We found ".$num.
" factures qualified that will have their total recalculated because they are at zero and line items not at zero");
2070 $obj =
$db->fetch_object($resql);
2073 SUM(fd.total_ht) as 'total_ht',
2074 SUM(fd.total_tva) as 'total_tva',
2075 SUM(fd.total_localtax1) as 'localtax1',
2076 SUM(fd.total_localtax2) as 'localtax2',
2077 SUM(fd.total_ttc) as 'total_ttc'
2079 ".MAIN_DB_PREFIX.
"facturedet fd
2081 fd.fk_facture = ".((int) $obj->rowid);
2082 $ressql_calculs =
$db->query($sql_calculs);
2083 while ($obj_calcul =
$db->fetch_object($ressql_calculs)) {
2085 $sql_paiements =
"SELECT SUM(amount) as somme from ".MAIN_DB_PREFIX.
"paiement_facture WHERE fk_facture = ".((int) $obj->rowid);
2086 $montantPaiements =
$db->fetch_object(
$db->query($sql_paiements))->somme;
2087 $totHt = ($obj_calcul->total_ht ?
price2num($obj_calcul->total_ht,
'MT') : 0);
2088 $totTva = ($obj_calcul->total_tva ?
price2num($obj_calcul->total_tva,
'MT') : 0);
2089 $totLocal1 = ($obj_calcul->localtax1 ?
price2num($obj_calcul->localtax1,
'MT') : 0);
2090 $totLocal2 = ($obj_calcul->localtax2 ?
price2num($obj_calcul->localtax2,
'MT') : 0);
2091 $totTtc = $totHt + $totTva + $totLocal1 + $totLocal2;
2093 UPDATE ".MAIN_DB_PREFIX.
"facture
2095 total_ht = ".((float) $totHt).
",
2096 total_tva = ".((float) $totTva).
",
2097 localtax1 = ".((float) $totLocal1).
",
2098 localtax2 = ".((float) $totLocal2).
",
2099 total_ttc = ".((float) $totTtc).
",
2100 fk_statut = ".($totTtc ==
price2num($montantPaiements,
'MT') ? 2 : 1).
",
2101 paid = ".($totTtc ==
price2num($montantPaiements,
'MT') ? 1 : 0).
"
2103 rowid = ".((
int) $obj->rowid);
2104 $db->query($sql_maj);
2109 print
"Pas de factures à traiter\n";
2113 dol_syslog(
"calculate_total_and_taxes.php: Error");
2125if ($ok &&
GETPOST(
'repair_mailing_path')) {
2127 $sav_user = is_object($user) ? clone $user : $user;
2129 require_once DOL_DOCUMENT_ROOT.
'/comm/mailing/class/mailing.class.php';
2130 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
2132 print
'<tr><td colspan="2"><br>*** Repair mailing path<br>';
2140 function migrate_mailing_filespath($mailing)
2144 $dir =
$conf->mailing->dir_output;
2145 $origin = $dir.
'/'.
get_exdir($mailing->id, 2, 0, 1, $mailing,
'mailing');
2146 $destin = $dir.
'/'.
get_exdir($mailing->id, 0, 0, 1, $mailing,
'mailing');
2152 $user =
new User($db);
2153 $user->fetch($mailing->user_creation_id);
2156 $handle = opendir($origin_osencoded);
2157 if (is_resource($handle)) {
2158 while (($file = readdir($handle)) !==
false) {
2159 if ($file !=
'.' && $file !=
'..' && is_dir($origin_osencoded.
'/'.$file)) {
2160 $thumbs = opendir($origin_osencoded.
'/'.$file);
2161 if (is_resource($thumbs)) {
2163 while (($thumb = readdir($thumbs)) !==
false) {
2164 $res =
dol_move($origin.
'/'.$file.
'/'.$thumb, $destin.
'/'.$file.
'/'.$thumb);
2165 $msg = ($res ?
' * Migration successful' :
'Migration failed') .
' for file '.$origin.
'/'.$file.
'.<br>';
2172 $res =
dol_move($origin.
'/'.$file, $destin.
'/'.$file);
2173 $msg = ($res ?
' * Migration successful' :
'Migration failed') .
' for file '.$origin.
'/'.$file.
'.<br>';
2184 $sql =
"SELECT rowid as mid from ".MAIN_DB_PREFIX.
"mailing";
2185 $resql =
$db->query($sql);
2187 while ($obj =
$db->fetch_object($resql)) {
2188 $mailing->fetch($obj->mid);
2189 print
"Migrating mailing id=".$mailing->id.
" ref=".$mailing->ref.
"<br>\n";
2190 migrate_mailing_filespath($mailing);
2204if (empty($actiondone)) {
2205 print
'<div class="error">'.$langs->trans(
"ErrorWrongParameters").
'</div>';
2210 print
'<div class="center" style="padding-top: 10px"><a href="../index.php?mainmenu=home&leftmenu=home'.(GETPOSTISSET(
"login") ?
'&username='.urlencode(
GETPOST(
"login")) :
'').
'">';
2211 print
img_picto(
'',
'url',
'class="pictofixedwidth"');
2212 print $langs->trans(
"GoToDolibarr");
2219if (
$db->connected) {
2224if (!$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, $nodefault=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.
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
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='', $patterntotest='')
Decode a string with a symmetric encryption.