Overview
Comment: | Essai de correction / simplification envoi rappels |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk | stable |
Files: | files | file ages | folders |
SHA1: |
16d295170c709abdcd11ec5790d01d42 |
User & Date: | bohwaz on 2020-06-24 01:49:18 |
Other Links: | manifest | tags |
Context
2020-07-03
| ||
02:10 | Fix nom de colonne liste des cotisations check-in: 4ea98fe3d5 user: bohwaz tags: trunk, stable | |
2020-06-24
| ||
01:49 | Essai de correction / simplification envoi rappels check-in: 16d295170c user: bohwaz tags: trunk, stable | |
2020-06-23
| ||
00:21 | Afficher le lien vers l'historique des rappels dans tous les cas check-in: cba6b145a6 user: bohwaz tags: trunk, stable | |
Changes
Modified src/include/lib/Garradin/Rappels.php from [7c23d0c913] to [ac12c6b477].
︙ | ︙ | |||
187 188 189 190 191 192 193 194 195 196 197 198 199 200 | ) WHERE nb_jours >= delai /* Pour ne pas spammer on n\'envoie pas de rappel antérieur au dernier rappel déjà effectué */ AND id NOT IN (SELECT id_membre FROM rappels_envoyes AS re WHERE id_cotisation = re.id_cotisation AND re.date >= date(expiration, delai || \' days\') ) ORDER BY nb_jours DESC;'; $db->begin(); $re = new Rappels_Envoyes; foreach ($db->iterate($query) as $row) { | > | 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 | ) WHERE nb_jours >= delai /* Pour ne pas spammer on n\'envoie pas de rappel antérieur au dernier rappel déjà effectué */ AND id NOT IN (SELECT id_membre FROM rappels_envoyes AS re WHERE id_cotisation = re.id_cotisation AND re.date >= date(expiration, delai || \' days\') ) AND CASE WHEN delai < 0 THEN nb_jours < 0 WHEN delai > 0 THEN nb_jours > 0 ELSE nb_jours = 0 END ORDER BY nb_jours DESC;'; $db->begin(); $re = new Rappels_Envoyes; foreach ($db->iterate($query) as $row) { |
︙ | ︙ |