Overview
Comment: | Give a type to transfers, debts and credits when migrating (if possible) |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev | 1.0.0-rc3 |
Files: | files | file ages | folders |
SHA1: |
c347cd4a83b8f2252b6b05267e86f899 |
User & Date: | bohwaz on 2020-11-30 17:00:10 |
Other Links: | branch diff | manifest | tags |
Context
2020-11-30
| ||
21:08 | Fix local_login with automatic user id check-in: a302e98a8e user: bohwaz tags: dev | |
17:00 | Give a type to transfers, debts and credits when migrating (if possible) check-in: c347cd4a83 user: bohwaz tags: dev, 1.0.0-rc3 | |
15:30 | Automatically select if there is only one result check-in: 38a82aaff0 user: bohwaz tags: dev, 1.0.0-rc3 | |
Changes
Modified src/include/data/1.0.0_migration.sql from [0ed78b78c8] to [ee5739a872].
︙ | ︙ | |||
68 69 70 71 72 73 74 75 76 77 78 79 80 81 | -- 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) | > > > > > > > > > > > | 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 | -- 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)); -- Virements UPDATE acc_transactions SET type = 3 WHERE id IN (SELECT id FROM compta_journal WHERE (compte_credit IN ('530', '5112', '5115') OR compte_credit LIKE '512%') AND (compte_debit IN ('530', '5112', '5115') OR compte_debit LIKE '512%')); -- Dettes UPDATE acc_transactions SET type = 4 WHERE id IN (SELECT id FROM compta_journal WHERE compte_debit LIKE '6%' AND compte_credit LIKE '4%'); -- Créances UPDATE acc_transactions SET type = 5 WHERE id IN (SELECT id FROM compta_journal WHERE compte_credit LIKE '7%' AND compte_debit LIKE '4%'); -- 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) |
︙ | ︙ |