|
dolibarr 21.0.0-alpha
|
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_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. | |
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 3231 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_categorie_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate categorie association.
Definition at line 3455 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 3380 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 2419 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 2043 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 2108 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 4764 of file upgrade2.php.
References dol_print_error().
| migrate_contractdet_rank | ( | ) |
Migrate Rank into contract line.
Definition at line 5021 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 1232 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 1274 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 1342 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 1073 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 1372 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 2979 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 4167 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 4062 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 2188 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 2874 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 3521 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 3587 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 4952 of file upgrade2.php.
References dol_print_error().
| migrate_links_transfert | ( | $db, | |
| $langs, | |||
| $conf ) |
Function to migrate links into llx_bank_url.
Definition at line 1158 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 4672 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 2352 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 3290 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 1985 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 1435 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 759 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 839 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 949 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 1801 of file upgrade2.php.
References calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_commande_fournisseur | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of purchase order lines.
Definition at line 1892 of file upgrade2.php.
References calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_contrat | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of contract lines.
Definition at line 1717 of file upgrade2.php.
References calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_facture | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of invoice lines.
Definition at line 1531 of file upgrade2.php.
References calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_propal | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of proposal lines.
Definition at line 1636 of file upgrade2.php.
References calcul_price_total(), and dolibarr_install_syslog().
| migrate_project_task_actors | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration de la table llx_projet_task_actors vers llx_element_contact.
Definition at line 2713 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 2632 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 2795 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 4351 of file upgrade2.php.
References 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 4212 of file upgrade2.php.
References 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 3753 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 3819 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 4043 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 3654 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 2489 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 3063 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 3158 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 2290 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 4860 of file upgrade2.php.
References dol_print_error().
| migrate_user_photospath | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4388 of file upgrade2.php.
References 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 4477 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 3911 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 3976 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 4581 of file upgrade2.php.
References dol_print_error().