0337d704 |
1 | #!/usr/bin/php4 -q |
2 | <?php |
3 | require('./connect.db.inc.php'); |
4 | $MESSAGE = ''; |
5 | |
6 | // --------------------------------------- |
7 | |
8 | $res = $globals->xdb->iterRow( |
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 | |
25 | $res = $globals->xdb->iterRow( |
26 | "SELECT hash, forlife, email, date |
27 | FROM register_pending |
28 | WHERE hash != 'INSCRIT' |
29 | ORDER BY date"); |
30 | if ($b = $res->total()) { |
31 | $MESSAGE.="\n$b INSCRIPTIONS NON CONFIRMEES:\n"; |
32 | while (list($code, $usern, $mail, $quand) = $res->next()) { |
33 | $MESSAGE.="$quand, $usern,\n $mail"; |
34 | $MESSAGE.="\n"; |
35 | $MESSAGE.="https://www.polytechnique.org/register/end.php?hash=$code\n"; |
36 | } |
37 | } |
38 | |
39 | // --------------------------------------- |
40 | |
41 | $res = $globals->xdb->query('SELECT COUNT(DISTINCT uid), COUNT(*) FROM register_marketing'); |
42 | list($a, $b) = $res->fetchOneRow(); |
43 | $MESSAGE .= "\n$c INSCRIPTIONS SOLICITÉES :\n"; |
44 | $MESSAGE .= " $a utilisateurs\n $b adresses mails\n"; |
45 | |
46 | // --------------------------------------- |
47 | |
48 | $MESSAGE .= "\n\n"; |
49 | |
50 | require_once('diogenes/diogenes.hermes.inc.php'); |
51 | $mailer = new HermesMailer(); |
52 | $mailer->setSubject("$a confirmées, $b en attente et $c sollicitées"); |
53 | $mailer->setFrom('register@polytechnique.org'); |
54 | $mailer->addTo('register@polytechnique.org'); |
55 | $mailer->addCc('jean-michel.yolin+register@polytechnique.org'); |
56 | $mailer->setTxtBody($MESSAGE); |
57 | $mailer->send(); |
58 | ?> |