Overview
Comment: | Suppression du type dépense/recette pour un seul type "signet", car on saut déjà si c'est une charge ou produit avec la position |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
f264c68657ba899e936e7d61cd564aa3 |
User & Date: | bohwaz on 2020-04-22 02:16:38 |
Other Links: | branch diff | manifest | tags |
Context
2020-04-22
| ||
02:17 | Widget input select_groups fonctionnel check-in: 53ae33d9ff user: bohwaz tags: dev | |
02:16 | Suppression du type dépense/recette pour un seul type "signet", car on saut déjà si c'est une charge ou produit avec la position check-in: f264c68657 user: bohwaz tags: dev | |
2020-04-21
| ||
23:16 | Fix upgrade check-in: c9d0003024 user: bohwaz tags: dev | |
Changes
Modified src/include/data/1.0.0_migration.sql from [fc5fa4bc56] to [aa5bbeff90].
︙ | ︙ | |||
54 55 56 57 58 59 60 | -- Création des lignes associées aux mouvements INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, payment_reference) SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_credit), 0, CAST(montant * 100 AS INT), numero_cheque FROM compta_journal_old; INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, payment_reference) SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_debit), CAST(montant * 100 AS INT), 0, numero_cheque FROM compta_journal_old; | | | | 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | -- Création des lignes associées aux mouvements INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, payment_reference) SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_credit), 0, CAST(montant * 100 AS INT), numero_cheque FROM compta_journal_old; INSERT INTO acc_transactions_lines (id_transaction, id_account, debit, credit, payment_reference) SELECT id, (SELECT id FROM acc_accounts WHERE code = compte_debit), CAST(montant * 100 AS INT), 0, numero_cheque FROM compta_journal_old; -- Recopie des descriptions de catégories dans la table des comptes, et mise des comptes en signets UPDATE acc_accounts SET (type, description) = (SELECT 6, c.description FROM compta_categories_old c WHERE c.id = code) WHERE EXISTS (SELECT rowid FROM compta_categories_old c WHERE c.id = code); -- Recopie des opérations, mais le nom a changé pour "mouvements" INSERT INTO membres_mouvements SELECT * FROM membres_operations_old; -- FIXME: ajout d'entrées dans le le log utilisateur à partir de id_auteur |
︙ | ︙ |
Modified src/include/lib/Garradin/Entities/Accounting/Account.php from [6f2a3dd0eb] to [35e07dec9e].
︙ | ︙ | |||
27 28 29 30 31 32 33 | * Outstanding transaction accounts (like cheque or card payments) */ const TYPE_OUTSTANDING = 3; const TYPE_ANALYTICAL = 4; const TYPE_VOLUNTEERING = 5; | | < | 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | * Outstanding transaction accounts (like cheque or card payments) */ const TYPE_OUTSTANDING = 3; const TYPE_ANALYTICAL = 4; const TYPE_VOLUNTEERING = 5; const TYPE_BOOKMARK = 6; protected $id; protected $id_plan; protected $code; protected $parent; protected $label; protected $position; |
︙ | ︙ |