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: 73f23232090c6982d76e118370f58dc23db19215
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
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 = 4 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)







|







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
89



90
91
92
93
94
95
96
	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);




-- 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








|
>
>
>







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