278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
|
CASE WHEN c.duree IS NOT NULL THEN date(cm.date, \'+\'||c.duree||\' days\') >= date()
WHEN c.fin IS NOT NULL THEN c.fin >= date() ELSE 1 END AS a_jour
FROM cotisations_membres AS cm
INNER JOIN cotisations AS c ON c.id = cm.id_cotisation
INNER JOIN membres AS m ON m.id = cm.id_membre
WHERE
cm.id_cotisation = ?
AND m.id_categorie NOT IN (SELECT id FROM membres_categories WHERE cacher = 1)
GROUP BY cm.id_membre ORDER BY '.$order.' '.$desc.' LIMIT ?,?;',
\SQLITE3_ASSOC, (int)$id, $begin, self::ITEMS_PER_PAGE);
}
/**
* Liste des événements d'un membre
* @param integer $id Numéro de membre
|
|
|
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
|
CASE WHEN c.duree IS NOT NULL THEN date(cm.date, \'+\'||c.duree||\' days\') >= date()
WHEN c.fin IS NOT NULL THEN c.fin >= date() ELSE 1 END AS a_jour
FROM cotisations_membres AS cm
INNER JOIN cotisations AS c ON c.id = cm.id_cotisation
INNER JOIN membres AS m ON m.id = cm.id_membre
WHERE
cm.id_cotisation = ?
AND m.id_categorie NOT IN (SELECT mc.id FROM membres_categories AS mc WHERE mc.cacher = 1)
GROUP BY cm.id_membre ORDER BY '.$order.' '.$desc.' LIMIT ?,?;',
\SQLITE3_ASSOC, (int)$id, $begin, self::ITEMS_PER_PAGE);
}
/**
* Liste des événements d'un membre
* @param integer $id Numéro de membre
|