|
dolibarr 21.0.3
|
Upgrade some data. More...
Go to the source code of this file.
Functions | |
| if($db->connected) if( $ret) | migrate_paiements ($db, $langs, $conf) |
| Records payment links for an invoice in a join table (link n<-->n for payments<-->invoices) | |
| migrate_paiements_orphelins_1 ($db, $langs, $conf) | |
| Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL) | |
| migrate_paiements_orphelins_2 ($db, $langs, $conf) | |
| Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL) | |
| migrate_contracts_det ($db, $langs, $conf) | |
| Mise a jour des contrats (gestion du contrat + detail de contrat) | |
| migrate_links_transfert ($db, $langs, $conf) | |
| Function to migrate links into llx_bank_url. | |
| migrate_contracts_date1 ($db, $langs, $conf) | |
| Mise a jour des date de contrats non renseignees. | |
| migrate_contracts_date2 ($db, $langs, $conf) | |
| Update contracts with date min real if service date is lower. | |
| migrate_contracts_date3 ($db, $langs, $conf) | |
| Mise a jour des dates de creation de contrat. | |
| migrate_contracts_open ($db, $langs, $conf) | |
| Reouverture des contrats qui ont au moins une ligne non fermee. | |
| migrate_paiementfourn_facturefourn ($db, $langs, $conf) | |
| Factures fournisseurs. | |
| migrate_price_facture ($db, $langs, $conf) | |
| Update total of invoice lines. | |
| migrate_price_propal ($db, $langs, $conf) | |
| Update total of proposal lines. | |
| migrate_price_contrat ($db, $langs, $conf) | |
| Update total of contract lines. | |
| migrate_price_commande ($db, $langs, $conf) | |
| Update total of sales order lines. | |
| migrate_price_commande_fournisseur ($db, $langs, $conf) | |
| Update total of purchase order lines. | |
| migrate_modeles ($db, $langs, $conf) | |
| Mise a jour des modeles selectionnes. | |
| migrate_commande_expedition ($db, $langs, $conf) | |
| Correspondence des expeditions et des commandes clients dans la table llx_co_exp. | |
| migrate_commande_livraison ($db, $langs, $conf) | |
| Correspondence des livraisons et des commandes clients dans la table llx_co_liv. | |
| migrate_detail_livraison ($db, $langs, $conf) | |
| Migration des details commandes dans les details livraisons. | |
| migrate_stocks ($db, $langs, $conf) | |
| Migration du champ stock dans produits. | |
| migrate_menus ($db, $langs, $conf) | |
| Migration of menus (use only 1 table instead of 3) 2.6 -> 2.7. | |
| migrate_commande_deliveryaddress ($db, $langs, $conf) | |
| Migration du champ fk_adresse_livraison dans expedition 2.6 -> 2.7. | |
| migrate_restore_missing_links ($db, $langs, $conf) | |
Migration du champ fk_remise_except dans llx_facturedet doit correspondre a Link in llx_societe_remise_except to llx_facturedet | |
| migrate_project_user_resp ($db, $langs, $conf) | |
| Migration du champ fk_user_resp de llx_projet vers llx_element_contact. | |
| migrate_project_task_actors ($db, $langs, $conf) | |
| Migration de la table llx_projet_task_actors vers llx_element_contact. | |
| migrate_relationship_tables ($db, $langs, $conf, $table, $fk_source, $sourcetype, $fk_target, $targettype) | |
| Migration des tables de relation. | |
| migrate_element_time ($db, $langs, $conf) | |
| Migrate duration in seconds. | |
| migrate_customerorder_shipping ($db, $langs, $conf) | |
| Migrate order ref_customer and date_delivery fields to llx_expedition. | |
| migrate_shipping_delivery ($db, $langs, $conf) | |
| Migrate link stored into fk_expedition into llx_element_element. | |
| migrate_shipping_delivery2 ($db, $langs, $conf) | |
| We try to complete field ref_customer and date_delivery that are empty into llx_livraison. | |
| migrate_actioncomm_element ($db, $langs, $conf) | |
| Migrate link stored into fk_xxxx into fk_element and elementtype. | |
| migrate_mode_reglement ($db, $langs, $conf) | |
| Migrate link stored into fk_mode_reglement. | |
| migrate_clean_association ($db, $langs, $conf) | |
| Delete duplicates in table categorie_association. | |
| migrate_categorie_association ($db, $langs, $conf) | |
| Migrate categorie association. | |
| migrate_event_assignement ($db, $langs, $conf) | |
| Migrate event assignment to owner. | |
| migrate_event_assignement_contact ($db, $langs, $conf) | |
| Migrate event assignment to owner. | |
| migrate_reset_blocked_log ($db, $langs, $conf) | |
| Migrate to reset the blocked log for V7+ algorithm. | |
| migrate_remise_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_societe_remise. | |
| migrate_remise_except_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_societe_remise_except. | |
| migrate_user_rights_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_user_rights. | |
| migrate_usergroup_rights_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_usergroup_rights. | |
| migrate_rename_directories ($db, $langs, $conf, $oldname, $newname) | |
| Migration directory. | |
| migrate_delete_old_files ($db, $langs, $conf) | |
| Delete deprecated files. | |
| migrate_delete_old_dir ($db, $langs, $conf) | |
| Remove deprecated directories. | |
| migrate_reload_modules ($db, $langs, $conf, $listofmodule=array(), $force=0) | |
| Disable/Re-enable features modules. | |
| migrate_reload_menu ($db, $langs, $conf) | |
| Reload SQL menu file (if dynamic menus, if modified by version) | |
| migrate_productlot_path () | |
| Migrate file from old path to new one for lot path. | |
| migrate_user_photospath () | |
| Migrate file from old path to new one for users. | |
| migrate_user_photospath2 () | |
| Migrate file from old path users/99/file.jpg into users/99/photos/file.jpg. | |
| migrate_users_socialnetworks () | |
| Migrate users fields facebook and co to socialnetworks. | |
| migrate_members_socialnetworks () | |
| Migrate members fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_contacts_socialnetworks () | |
| Migrate contacts fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_thirdparties_socialnetworks () | |
| Migrate thirdparties fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_export_import_profiles ($mode='export') | |
| Migrate export and import profiles to fix field name that was renamed. | |
| migrate_contractdet_rank () | |
| Migrate Rank into contract line. | |
| migrate_invoice_export_models () | |
| Invoice exports been shifted (facture_1 => facture_0, facture_2 => facture_1) in version 20, shift export models accordingly. | |
Upgrade some data.
Definition in file upgrade2.php.
| migrate_actioncomm_element | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_xxxx into fk_element and elementtype.
Definition at line 3304 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_categorie_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate categorie association.
Definition at line 3528 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_clean_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Delete duplicates in table categorie_association.
Definition at line 3453 of file upgrade2.php.
References dolibarr_install_syslog().
| migrate_commande_deliveryaddress | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_adresse_livraison dans expedition 2.6 -> 2.7.
Definition at line 2492 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_expedition | ( | $db, | |
| $langs, | |||
| $conf ) |
Correspondence des expeditions et des commandes clients dans la table llx_co_exp.
Definition at line 2116 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_livraison | ( | $db, | |
| $langs, | |||
| $conf ) |
Correspondence des livraisons et des commandes clients dans la table llx_co_liv.
Definition at line 2181 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_contacts_socialnetworks | ( | ) |
Migrate contacts fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 4899 of file upgrade2.php.
References dol_print_error().
| migrate_contractdet_rank | ( | ) |
Migrate Rank into contract line.
Definition at line 5156 of file upgrade2.php.
References dol_print_error().
| migrate_contracts_date1 | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des date de contrats non renseignees.
Definition at line 1305 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_date2 | ( | $db, | |
| $langs, | |||
| $conf ) |
Update contracts with date min real if service date is lower.
Definition at line 1347 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_date3 | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des dates de creation de contrat.
Definition at line 1415 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_det | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des contrats (gestion du contrat + detail de contrat)
Definition at line 1146 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_open | ( | $db, | |
| $langs, | |||
| $conf ) |
Reouverture des contrats qui ont au moins une ligne non fermee.
Definition at line 1445 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_customerorder_shipping | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate order ref_customer and date_delivery fields to llx_expedition.
Definition at line 3052 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_delete_old_dir | ( | $db, | |
| $langs, | |||
| $conf ) |
Remove deprecated directories.
Definition at line 4240 of file upgrade2.php.
References dol_delete_dir_recursive(), and dolibarr_install_syslog().
| migrate_delete_old_files | ( | $db, | |
| $langs, | |||
| $conf ) |
Delete deprecated files.
Definition at line 4135 of file upgrade2.php.
References dol_delete_file(), and dolibarr_install_syslog().
| migrate_detail_livraison | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration des details commandes dans les details livraisons.
Definition at line 2261 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_element_time | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate duration in seconds.
Definition at line 2947 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignment to owner.
Definition at line 3594 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement_contact | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignment to owner.
Definition at line 3660 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_export_import_profiles | ( | $mode = 'export' | ) |
Migrate export and import profiles to fix field name that was renamed.
| string | $mode | 'export' or 'import' |
Definition at line 5087 of file upgrade2.php.
References dol_print_error().
| migrate_invoice_export_models | ( | ) |
Invoice exports been shifted (facture_1 => facture_0, facture_2 => facture_1) in version 20, shift export models accordingly.
Definition at line 5213 of file upgrade2.php.
References dol_print_error(), dolibarr_set_const(), getDolGlobalInt(), getDolGlobalString(), and versioncompare().
| migrate_links_transfert | ( | $db, | |
| $langs, | |||
| $conf ) |
Function to migrate links into llx_bank_url.
Definition at line 1231 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_members_socialnetworks | ( | ) |
Migrate members fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 4807 of file upgrade2.php.
References dol_print_error().
| migrate_menus | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration of menus (use only 1 table instead of 3) 2.6 -> 2.7.
Definition at line 2425 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_mode_reglement | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_mode_reglement.
Definition at line 3363 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_modeles | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des modeles selectionnes.
Definition at line 2058 of file upgrade2.php.
References dol_print_error(), dolibarr_install_syslog(), ModelePDFCommandes\liste_modeles(), ModelePdfExpedition\liste_modeles(), and ModelePDFFactures\liste_modeles().
| migrate_paiementfourn_facturefourn | ( | $db, | |
| $langs, | |||
| $conf ) |
Factures fournisseurs.
Definition at line 1508 of file upgrade2.php.
References dolibarr_install_syslog().
Records payment links for an invoice in a join table (link n<-->n for payments<-->invoices)
Definition at line 832 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_paiements_orphelins_1 | ( | $db, | |
| $langs, | |||
| $conf ) |
Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL)
Definition at line 912 of file upgrade2.php.
References dol_print_error(), dolibarr_install_syslog(), and getDolGlobalInt().
| migrate_paiements_orphelins_2 | ( | $db, | |
| $langs, | |||
| $conf ) |
Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL)
Definition at line 1022 of file upgrade2.php.
References dol_print_error(), dolibarr_install_syslog(), and getDolGlobalInt().
| migrate_price_commande | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of sales order lines.
Definition at line 1874 of file upgrade2.php.
References $conf, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_commande_fournisseur | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of purchase order lines.
Definition at line 1965 of file upgrade2.php.
References $conf, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_contrat | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of contract lines.
Definition at line 1790 of file upgrade2.php.
References $conf, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_facture | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of invoice lines.
Definition at line 1604 of file upgrade2.php.
References $conf, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_propal | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of proposal lines.
Definition at line 1709 of file upgrade2.php.
References $conf, calcul_price_total(), and dolibarr_install_syslog().
| migrate_productlot_path | ( | ) |
Migrate file from old path to new one for lot path.
Definition at line 4461 of file upgrade2.php.
References $conf, dol_is_dir(), dol_move_dir(), and get_exdir().
| migrate_project_task_actors | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration de la table llx_projet_task_actors vers llx_element_contact.
Definition at line 2786 of file upgrade2.php.
References dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_project_user_resp | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_user_resp de llx_projet vers llx_element_contact.
Definition at line 2705 of file upgrade2.php.
References dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_relationship_tables | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $table, | |||
| $fk_source, | |||
| $sourcetype, | |||
| $fk_target, | |||
| $targettype ) |
Migration des tables de relation.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| string | $table | Table name |
| string | $fk_source | Id of element source (name of field) |
| string | $sourcetype | Type of element source |
| string | $fk_target | Id of element target |
| string | $targettype | Type of element target |
Definition at line 2868 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_reload_menu | ( | $db, | |
| $langs, | |||
| $conf ) |
Reload SQL menu file (if dynamic menus, if modified by version)
Definition at line 4424 of file upgrade2.php.
References $conf, dolibarr_install_syslog(), getDolGlobalString(), and run_sql().
| migrate_reload_modules | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $listofmodule = array(), | |||
| $force = 0 ) |
Disable/Re-enable features modules.
We must do this when internal menu of module or permissions has changed or when triggers have moved.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| array<string,'noboxes'|'newboxdefonly'|'forceactivate'> | $listofmodule List of modules, like array('MODULE_KEY_NAME'=>$reloadmode, ...) | |
| int<0,1> | $force 1=Reload module even if not already loaded |
Definition at line 4285 of file upgrade2.php.
References $conf, dol_include_once(), and dolibarr_install_syslog().
| migrate_remise_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_societe_remise.
Definition at line 3826 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_remise_except_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_societe_remise_except.
Definition at line 3892 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_rename_directories | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $oldname, | |||
| $newname ) |
Migration directory.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| string | $oldname | Old name (relative to DOL_DATA_ROOT) |
| string | $newname | New name (relative to DOL_DATA_ROOT) |
Definition at line 4116 of file upgrade2.php.
References dolibarr_install_syslog().
| migrate_reset_blocked_log | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to reset the blocked log for V7+ algorithm.
Definition at line 3727 of file upgrade2.php.
References $object, dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_restore_missing_links | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_remise_except dans llx_facturedet doit correspondre a Link in llx_societe_remise_except to llx_facturedet
Definition at line 2562 of file upgrade2.php.
References dol_print_error(), dolibarr_install_syslog(), and versioncompare().
| migrate_shipping_delivery | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_expedition into llx_element_element.
Definition at line 3136 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_shipping_delivery2 | ( | $db, | |
| $langs, | |||
| $conf ) |
We try to complete field ref_customer and date_delivery that are empty into llx_livraison.
We set them with value from llx_expedition.
Definition at line 3231 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_stocks | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ stock dans produits.
Definition at line 2363 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_thirdparties_socialnetworks | ( | ) |
Migrate thirdparties fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 4995 of file upgrade2.php.
References dol_print_error().
| migrate_user_photospath | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4523 of file upgrade2.php.
References $conf, dol_copy(), dol_is_dir(), dol_is_file(), dol_mkdir(), dol_osencode(), and get_exdir().
| migrate_user_photospath2 | ( | ) |
Migrate file from old path users/99/file.jpg into users/99/photos/file.jpg.
Definition at line 4612 of file upgrade2.php.
References dol_copy(), dol_is_dir(), dol_is_file(), dol_mkdir(), and dol_osencode().
| migrate_user_rights_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_user_rights.
Definition at line 3984 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_usergroup_rights_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_usergroup_rights.
Definition at line 4049 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_users_socialnetworks | ( | ) |
Migrate users fields facebook and co to socialnetworks.
Can be called only when version is 10.0.* or lower. Fields does not exists after.
Definition at line 4716 of file upgrade2.php.
References dol_print_error().