Overview
Comment: | Fix: third party accounts were in the wrong type after migration |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
73f23232090c6982d76e118370f58dc2 |
User & Date: | bohwaz on 2020-10-11 16:00:07 |
Other Links: | branch diff | manifest | tags |
Context
2020-10-11
| ||
17:24 | Add: reconcile bank accounts check-in: 1467749329 user: bohwaz tags: dev | |
16:00 | Fix: third party accounts were in the wrong type after migration check-in: 73f2323209 user: bohwaz tags: dev | |
2020-10-10
| ||
23:22 | Move account management to charts management, instead show current accounts sum for current year check-in: 4082ed3ad9 user: bohwaz tags: dev | |
Changes
Modified src/include/data/1.0.0_migration.sql from [8a3b6f3f0f] to [2fd124d853].
︙ | ︙ | |||
55 56 57 58 59 60 61 | -- Comptes analytiques UPDATE acc_accounts SET type_parent = 6 WHERE code = '9'; -- Bénévolat en nature UPDATE acc_accounts SET type_parent = 7 WHERE code = '870'; -- Comptes de tiers | | | 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | -- Comptes analytiques UPDATE acc_accounts SET type_parent = 6 WHERE code = '9'; -- Bénévolat en nature UPDATE acc_accounts SET type_parent = 7 WHERE code = '870'; -- Comptes de tiers UPDATE acc_accounts SET type_parent = 8 WHERE code = '4'; -- Comptes d'ouverture et de clôture UPDATE acc_accounts SET type = 9 WHERE code = '890'; UPDATE acc_accounts SET type = 10 WHERE code = '891'; -- Recopie des mouvements INSERT INTO acc_transactions (id, label, notes, reference, date, id_year, id_creator) |
︙ | ︙ | |||
82 83 84 85 86 87 88 | FROM compta_journal; -- Recopie des descriptions de catégories dans la table des comptes, et mise des comptes en signets UPDATE acc_accounts SET type = 1, description = (SELECT description FROM compta_categories WHERE compte = acc_accounts.code) WHERE id IN (SELECT a.id FROM acc_accounts a INNER JOIN compta_categories c ON c.compte = a.code AND c.type = 1); UPDATE acc_accounts SET type = 2, description = (SELECT description FROM compta_categories WHERE compte = acc_accounts.code) | | > > > | 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | FROM compta_journal; -- Recopie des descriptions de catégories dans la table des comptes, et mise des comptes en signets UPDATE acc_accounts SET type = 1, description = (SELECT description FROM compta_categories WHERE compte = acc_accounts.code) WHERE id IN (SELECT a.id FROM acc_accounts a INNER JOIN compta_categories c ON c.compte = a.code AND c.type = 1); UPDATE acc_accounts SET type = 2, description = (SELECT description FROM compta_categories WHERE compte = acc_accounts.code) WHERE id IN (SELECT a.id FROM acc_accounts a INNER JOIN compta_categories c ON c.compte = a.code AND c.type = -1 AND c.compte NOT LIKE '4%'); UPDATE acc_accounts SET type = 8, description = (SELECT description FROM compta_categories WHERE compte = acc_accounts.code) WHERE id IN (SELECT a.id FROM acc_accounts a INNER JOIN compta_categories c ON c.compte = a.code AND c.type = -1 AND c.compte LIKE '4%'); -- Recopie des opérations, mais le nom a changé pour acc_transactions_users INSERT INTO acc_transactions_users SELECT * FROM membres_operations_old; -- FIXME: ajout d'entrées dans le le log utilisateur à partir de id_auteur |
︙ | ︙ |