dolibarr 19.0.4
|
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 3280 of file upgrade2.php.
References dol_print_error(), and dolibarr_install_syslog().
migrate_categorie_association | ( | $db, | |
$langs, | |||
$conf ) |
Migrate categorie association.
Definition at line 3504 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 3429 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 2470 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 2094 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 2159 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 4809 of file upgrade2.php.
References dol_print_error().
migrate_contractdet_rank | ( | ) |
Migrate Rank into contract line.
Definition at line 5066 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 1225 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 1267 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 1335 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 1066 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 1365 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 3028 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 4216 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 4111 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 2239 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 2923 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 3570 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 3636 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 4997 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 1151 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 4717 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 2403 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 3339 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 2036 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 1428 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 753 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 832 of file upgrade2.php.
References dol_print_error(), dolibarr_install_syslog(), and getDolGlobalInt().
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 942 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 1814 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 1924 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 1730 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 1524 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 1629 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 2762 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 2681 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 2844 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 4396 of file upgrade2.php.
References dolibarr_install_syslog(), getDolGlobalString(), 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 4261 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 3802 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 3868 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 4092 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 3703 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 2540 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 3112 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 3207 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 2341 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 4905 of file upgrade2.php.
References dol_print_error().
migrate_user_photospath | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4433 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 4522 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 3960 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 4025 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 4626 of file upgrade2.php.
References dol_print_error().