|
dolibarr 18.0.6
|
Upgrade some data. More...
Go to the source code of this file.
Functions | |
| if($db->connected) if( $ret) | migrate_paiements ($db, $langs, $conf) |
| Reporte liens vers une facture de paiements sur table de jointure (lien n-n paiements factures) | |
| migrate_paiements_orphelins_1 ($db, $langs, $conf) | |
| Corrige paiement orphelins (liens paumes suite a bugs) Pour verifier s'il reste des orphelins: 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) | |
| Corrige paiement orphelins (liens paumes suite a bugs) Pour verifier s'il reste des orphelins: 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) | |
| Correspondance des expeditions et des commandes clients dans la table llx_co_exp. | |
| migrate_commande_livraison ($db, $langs, $conf) | |
| Correspondance 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 lien dans llx_societe_remise_except vers 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 assignement to owner. | |
| migrate_event_assignement_contact ($db, $langs, $conf) | |
| Migrate event assignement 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/Reenable 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 3264 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_categorie_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate categorie association.
Definition at line 3488 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 3413 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 2458 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_expedition | ( | $db, | |
| $langs, | |||
| $conf ) |
Correspondance des expeditions et des commandes clients dans la table llx_co_exp.
Definition at line 2082 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_livraison | ( | $db, | |
| $langs, | |||
| $conf ) |
Correspondance des livraisons et des commandes clients dans la table llx_co_liv.
Definition at line 2147 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 4781 of file upgrade2.php.
References dol_print_error().
| migrate_contractdet_rank | ( | ) |
Migrate Rank into contract line.
Definition at line 5038 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 1215 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 1257 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 1325 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 1056 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 1355 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 3012 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 4190 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 4095 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 2227 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 2907 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignement to owner.
Definition at line 3554 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement_contact | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignement to owner.
Definition at line 3620 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 4969 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 1141 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 4689 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 2391 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 3323 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 2024 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 1418 of file upgrade2.php.
References dolibarr_install_syslog().
Reporte liens vers une facture de paiements sur table de jointure (lien n-n paiements factures)
Definition at line 743 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_paiements_orphelins_1 | ( | $db, | |
| $langs, | |||
| $conf ) |
Corrige paiement orphelins (liens paumes suite a bugs) Pour verifier s'il reste des orphelins: 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 822 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_paiements_orphelins_2 | ( | $db, | |
| $langs, | |||
| $conf ) |
Corrige paiement orphelins (liens paumes suite a bugs) Pour verifier s'il reste des orphelins: 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 932 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
| migrate_price_commande | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of sales order lines.
Definition at line 1804 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 1914 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 1720 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 1514 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 1619 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 2746 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 2665 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 |
| int | $fk_source | Id of element source |
| string | $sourcetype | Type of element source |
| int | $fk_target | Id of element target |
| string | $targettype | Type of element target |
Definition at line 2828 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 4368 of file upgrade2.php.
References dolibarr_install_syslog(), and run_sql().
| migrate_reload_modules | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $listofmodule = array(), | |||
| $force = 0 ) |
Disable/Reenable 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 | $listofmodule | List of modules, like array('MODULE_KEY_NAME'=>', $reloadmode) |
| int | $force | 1=Reload module even if not already loaded |
Definition at line 4235 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 3786 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 3852 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 4076 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 3687 of file upgrade2.php.
References 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 lien dans llx_societe_remise_except vers llx_facturedet.
Definition at line 2528 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 3096 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 3191 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 2329 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 4877 of file upgrade2.php.
References dol_print_error().
| migrate_user_photospath | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4405 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 4494 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 3944 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 4009 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 4598 of file upgrade2.php.
References dol_print_error().