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: 620e523fe46c6ced7b27471c4f0e4e418e9755b2
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
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($columns['change']['select'], $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);







|







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);