Overview
Comment:Fkx right amount when nothing is paid for a service subscription
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk | stable
Files: files | file ages | folders
SHA3-256: 1c25a42adb35bf83d26f2695a988d22942d053d38f78338b0ffa9a67790eed13
User & Date: bohwaz on 2022-09-04 22:06:58
Other Links: manifest | tags
Context
2022-09-05
12:28
Do not change description and type when updating an account from update of installed chart check-in: 0854f56115 user: bohwaz tags: trunk, stable
2022-09-04
22:06
Fkx right amount when nothing is paid for a service subscription check-in: 1c25a42adb user: bohwaz tags: trunk, stable
22:06
Fix markdown help title check-in: 354a04b6bd user: bohwaz tags: trunk, stable
Changes

Modified src/include/lib/Garradin/Services/Services_User.php from [3cadb98b09] to [d96fd5df7d].

63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
			],
			'paid' => [
				'label' => 'Payé',
				'select' => 'su.paid',
			],
			'amount' => [
				'label' => 'Reste à régler',
				'select' => 'MAX(0, expected_amount - SUM(tl.debit))',
			],
			'expected_amount' => [],
		];

		$tables = 'services_users su
			INNER JOIN services s ON s.id = su.id_service
			LEFT JOIN services_fees sf ON sf.id = su.id_fee







|







63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
			],
			'paid' => [
				'label' => 'Payé',
				'select' => 'su.paid',
			],
			'amount' => [
				'label' => 'Reste à régler',
				'select' => 'MAX(0, expected_amount - IFNULL(SUM(tl.debit), 0))',
			],
			'expected_amount' => [],
		];

		$tables = 'services_users su
			INNER JOIN services s ON s.id = su.id_service
			LEFT JOIN services_fees sf ON sf.id = su.id_fee