Overview
Comment: | Keep transaction type when migrating |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
904fef3ed650f33664a0593b8dec21d5 |
User & Date: | bohwaz on 2020-11-26 18:04:50 |
Other Links: | branch diff | manifest | tags |
Context
2020-11-26
| ||
18:51 | Remove console.log check-in: ca861c3f0c user: bohwaz tags: dev | |
18:04 | Keep transaction type when migrating check-in: 904fef3ed6 user: bohwaz tags: dev | |
13:05 | Improve reconcile: fix reconcile sum, improve form UI for small screens check-in: c9518cd0c7 user: bohwaz tags: dev | |
Changes
Modified src/include/data/1.0.0_migration.sql from [36a9974aec] to [0ed78b78c8].
︙ | ︙ | |||
62 63 64 65 66 67 68 69 70 71 72 73 74 75 | UPDATE acc_accounts SET type = 4 WHERE code IN (SELECT id FROM compta_comptes WHERE id LIKE '4%' AND plan_comptable = 0 AND desactive = 0); -- 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(REPLACE(montant * 100, '.0', '') 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; INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, reference, id_analytical) | > > > > > > | 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | UPDATE acc_accounts SET type = 4 WHERE code IN (SELECT id FROM compta_comptes WHERE id LIKE '4%' AND plan_comptable = 0 AND desactive = 0); -- 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; -- Recettes UPDATE acc_transactions SET type = 1 WHERE id IN (SELECT id FROM compta_journal WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = 1)); -- Dépenses UPDATE acc_transactions SET type = 2 WHERE id IN (SELECT id FROM compta_journal WHERE id_categorie IN (SELECT id FROM compta_categories WHERE type = -1)); -- 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(REPLACE(montant * 100, '.0', '') 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; INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, reference, id_analytical) |
︙ | ︙ |