Overview
Comment:Fix duration in services list
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk | stable
Files: files | file ages | folders
SHA3-256: d99d64b8b51ab40e346c346c8ca35783cd64837683e6c7b456e5980840a37ad5
User & Date: bohwaz on 2022-06-07 17:20:25
Other Links: manifest | tags
Context
2022-06-07
22:05
Add export of mailing recipients check-in: b26d78bdd5 user: bohwaz tags: trunk, stable
17:20
Fix duration in services list check-in: d99d64b8b5 user: bohwaz tags: trunk, stable
16:40
Add list of debts and credits for a user check-in: 328a714b2c user: bohwaz tags: trunk
Changes

Modified src/include/lib/Garradin/Services/Services.php from [8596a5134e] to [25df3ae571].

71
72
73
74
75
76
77



78
79
80
81
82
83
84
			$db->where('m.id_category', 'NOT IN', $hidden_cats));

		$db->exec($sql);


		$columns = [
			'id' => [],



			'label' => [
				'label' => 'Activité',
			],
			'date' => [
				'label' => 'Période',
				'order' => 'start_date %s, duration %1$s',
				'select' => 'CASE WHEN start_date IS NULL THEN duration ELSE NULL END',







>
>
>







71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
			$db->where('m.id_category', 'NOT IN', $hidden_cats));

		$db->exec($sql);


		$columns = [
			'id' => [],
			'duration' => [],
			'start_date' => [],
			'end_date' => [],
			'label' => [
				'label' => 'Activité',
			],
			'date' => [
				'label' => 'Période',
				'order' => 'start_date %s, duration %1$s',
				'select' => 'CASE WHEN start_date IS NULL THEN duration ELSE NULL END',