Differences From Artifact [96c4b53767]:

To Artifact [e268d29158]:


54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
-- 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';

-- Recopie des mouvements
INSERT INTO acc_transactions (id, label, notes, reference, date, id_year)
	SELECT id, libelle, remarques, numero_piece, date, id_exercice
	FROM compta_journal;

-- Création des lignes associées aux mouvements
INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, reference, id_analytical)
	SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_credit), 0, CAST(montant * 100 AS INT), numero_cheque,
	CASE WHEN id_projet IS NOT NULL THEN (SELECT id FROM acc_accounts WHERE code = '99' || substr('0000' || id_projet, -4)) ELSE NULL END
	FROM compta_journal;







|
|







54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
-- 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';

-- Recopie des mouvements
INSERT INTO acc_transactions (id, label, notes, reference, date, id_year, id_creator)
	SELECT id, libelle, remarques, numero_piece, date, id_exercice, id_auteur
	FROM compta_journal;

-- Création des lignes associées aux mouvements
INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, reference, id_analytical)
	SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_credit), 0, CAST(montant * 100 AS INT), numero_cheque,
	CASE WHEN id_projet IS NOT NULL THEN (SELECT id FROM acc_accounts WHERE code = '99' || substr('0000' || id_projet, -4)) ELSE NULL END
	FROM compta_journal;