Overview
Comment: | Use SUM as we are grouping |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
620e523fe46c6ced7b27471c4f0e4e41 |
User & Date: | bohwaz on 2020-12-02 00:08:02 |
Other Links: | branch diff | manifest | tags |
Context
2020-12-02
| ||
00:56 | Include global.js all the time, no need to ask for it check-in: 85270b560e user: bohwaz tags: dev | |
00:08 | Use SUM as we are grouping check-in: 620e523fe4 user: bohwaz tags: dev | |
00:01 | Use autocomplete="new-password" for password change check-in: ab3d150448 user: bohwaz tags: dev | |
Changes
Modified src/include/lib/Garradin/Accounting/Transactions.php from [04872dade5] to [6561462819].
︙ | ︙ | |||
372 373 374 375 376 377 378 | static public function listByType(int $year_id, int $type) { $reverse = 1; $columns = Account::LIST_COLUMNS; unset($columns['line_label'], $columns['sum'], $columns['debit'], $columns['credit']); $columns['line_reference']['label'] = 'Réf. paiement'; | | | 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 | static public function listByType(int $year_id, int $type) { $reverse = 1; $columns = Account::LIST_COLUMNS; unset($columns['line_label'], $columns['sum'], $columns['debit'], $columns['credit']); $columns['line_reference']['label'] = 'Réf. paiement'; $columns['change']['select'] = sprintf('SUM(l.credit) * %d', $reverse); $columns['change']['label'] = 'Montant'; $tables = 'acc_transactions_lines l INNER JOIN acc_transactions t ON t.id = l.id_transaction INNER JOIN acc_accounts a ON a.id = l.id_account LEFT JOIN acc_accounts b ON b.id = l.id_analytical'; $conditions = sprintf('t.type = %s AND t.id_year = %d', $type, $year_id); |
︙ | ︙ |