Overview
Comment:Order reminders by sent order
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk | stable
Files: files | file ages | folders
SHA3-256: 2273bb1c8036ee229be86bff83e9df951152157dfcb4a4303ef2a2c3917916b6
User & Date: bohwaz on 2021-06-01 22:08:47
Other Links: manifest | tags
Context
2021-06-02
16:02
Add attachment image file name in gallery see ticket [d04db0a0f3147b2a5375da475c2bc076b589efc9] check-in: 1113c8751c user: bohwaz tags: trunk, stable
2021-06-01
22:08
Order reminders by sent order check-in: 2273bb1c80 user: bohwaz tags: trunk, stable
22:03
Fix reminder date in message body Fix: get last reminder sent, not any random one check-in: 3faf645a60 user: bohwaz tags: trunk, stable
Changes

Modified src/include/lib/Garradin/Entities/Services/Reminder.php from [0d2c963b3c] to [52650ee9cf].

78
79
80
81
82
83
84

85
86
87
88
89
90
91
92
93
94
95
96
97
			'email' => [
				'label' => 'Adresse e-mail',
				'select' => 'm.email',
			],
			'date' => [
				'label' => 'Date d\'envoi',
				'select' => 'srs.sent_date',

			],
		];

		$tables = 'services_reminders_sent srs
			INNER JOIN membres m ON m.id = srs.id_user';
		$conditions = sprintf('srs.id_reminder = %d', $this->id());

		$list = new DynamicList($columns, $tables, $conditions);
		$list->orderBy('date', true);
		return $list;
	}

}







>













78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
			'email' => [
				'label' => 'Adresse e-mail',
				'select' => 'm.email',
			],
			'date' => [
				'label' => 'Date d\'envoi',
				'select' => 'srs.sent_date',
				'order' => 'srs.sent_date %s, srs.id %1$s',
			],
		];

		$tables = 'services_reminders_sent srs
			INNER JOIN membres m ON m.id = srs.id_user';
		$conditions = sprintf('srs.id_reminder = %d', $this->id());

		$list = new DynamicList($columns, $tables, $conditions);
		$list->orderBy('date', true);
		return $list;
	}

}