Commit | Line | Data |
---|---|---|
ee68ddc1 | 1 | #!/usr/bin/php5 -q |
0337d704 | 2 | <?php |
d293e17c | 3 | require('connect.db.inc.php'); |
0337d704 | 4 | $MESSAGE = ''; |
5 | ||
6 | // --------------------------------------- | |
7 | ||
08cce2ff | 8 | $res = XDB::iterRow( |
0337d704 | 9 | "SELECT a.alias, u.promo, email |
10 | FROM auth_user_md5 AS u | |
11 | LEFT JOIN aliases AS a ON( u.user_id=a.id AND a.type='a_vie' ) | |
12 | LEFT JOIN emails AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) ) | |
13 | WHERE u.date_ins > {?} | |
14 | GROUP BY alias | |
15 | ORDER BY promo", date("Ymd000000", strtotime ("last Monday"))); | |
16 | if ($a = $res->total()) { | |
17 | $MESSAGE.="$a INSCRIPTIONS CONFIRMEES:\n"; | |
18 | while (list($usern,$promo,$mail) = $res->next()) { | |
19 | $MESSAGE.="X$promo, $usern, $mail\n"; | |
20 | } | |
21 | } | |
22 | ||
23 | // --------------------------------------- | |
24 | ||
08cce2ff | 25 | $res = XDB::iterRow( |
d293e17c VZ |
26 | "SELECT u.hruid, r.email, r.date |
27 | FROM register_pending AS r | |
28 | LEFT JOIN auth_user_md5 AS u ON (u.user_id = r.uid) | |
29 | WHERE r.hash != 'INSCRIT' | |
30 | ORDER BY r.date"); | |
0337d704 | 31 | if ($b = $res->total()) { |
32 | $MESSAGE.="\n$b INSCRIPTIONS NON CONFIRMEES:\n"; | |
2e3d2005 | 33 | while (list($usern, $mail, $quand) = $res->next()) { |
34 | $MESSAGE.="$quand, $usern,\n $mail\n"; | |
0337d704 | 35 | } |
36 | } | |
37 | ||
38 | // --------------------------------------- | |
39 | ||
08cce2ff | 40 | $res = XDB::query('SELECT COUNT(DISTINCT uid), COUNT(*) FROM register_marketing'); |
0337d704 | 41 | list($a, $b) = $res->fetchOneRow(); |
d293e17c | 42 | $MESSAGE .= "\nINSCRIPTIONS SOLICITÉES :\n"; |
faefdbb7 | 43 | $MESSAGE .= " $a utilisateurs\n $b adresses email\n"; |
0337d704 | 44 | |
45 | // --------------------------------------- | |
46 | ||
47 | $MESSAGE .= "\n\n"; | |
48 | ||
1e33266a | 49 | $mailer = new PlMailer(); |
a7de4ef7 | 50 | $mailer->setSubject("$a confirmées, $b en attente et $c sollicitées"); |
40bc7e89 | 51 | $mailer->setFrom($globals->register->notif); |
52 | $mailer->addTo($globals->register->notif); | |
0337d704 | 53 | $mailer->setTxtBody($MESSAGE); |
54 | $mailer->send(); | |
a7de4ef7 | 55 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
0337d704 | 56 | ?> |