Overview
Comment: | Don't set "expense or revenue" positions to 0, instead match them to something valid |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0d0115af9870aac4b02c2dfa3c3677d9 |
User & Date: | bohwaz on 2020-12-09 18:19:54 |
Other Links: | manifest | tags |
Context
2020-12-09
| ||
18:20 | Just in case ther's a mixed position and outside of 6/7 account codes check-in: 04a0506fd2 user: bohwaz tags: trunk | |
18:19 | Don't set "expense or revenue" positions to 0, instead match them to something valid check-in: 0d0115af98 user: bohwaz tags: trunk | |
01:43 | Float image check-in: c92dd96354 user: bohwaz tags: trunk | |
Changes
Modified src/include/data/1.0.0_migration.sql from [ba81ccc806] to [c04d39f6e6].
︙ | ︙ | |||
15 16 17 18 19 20 21 | -------- MIGRATION COMPTA --------- INSERT INTO acc_charts (id, country, code, label) VALUES (1, 'FR', 'PCGA1999', 'Plan comptable associatif 1999'); -- Migration comptes de code comme identifiant à ID unique -- Inversement valeurs actif/passif et produit/charge INSERT INTO acc_accounts (id, id_chart, code, label, position, user) SELECT NULL, 1, id, libelle, | | | | | | | | > | 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | -------- MIGRATION COMPTA --------- INSERT INTO acc_charts (id, country, code, label) VALUES (1, 'FR', 'PCGA1999', 'Plan comptable associatif 1999'); -- Migration comptes de code comme identifiant à ID unique -- Inversement valeurs actif/passif et produit/charge INSERT INTO acc_accounts (id, id_chart, code, label, position, user) SELECT NULL, 1, id, libelle, CASE WHEN position = 1 THEN 2 WHEN position = 2 THEN 1 WHEN position = 3 THEN 3 WHEN position = 4 THEN 5 WHEN position = 8 THEN 4 -- Suppression de la position "charge ou produit" qui n'a aucun sens WHEN position = 12 AND code LIKE '6%' THEN 4 WHEN position = 12 AND code LIKE '7%' THEN 5 ELSE 0 END, CASE WHEN plan_comptable = 1 THEN 0 ELSE 1 END FROM compta_comptes; -- Migrations projets vers comptes analytiques INSERT INTO acc_accounts (id_chart, code, label, position, user, type) |
︙ | ︙ |