Commit | Line | Data |
---|---|---|
5be526be FB |
1 | #!/usr/bin/php5 -q |
2 | <?php | |
3 | ||
4 | ini_set('include_path', '.:../include:/usr/share/php'); | |
5 | require_once('connect.db.inc.php'); | |
6 | require_once('marketing.inc.php'); | |
7 | ||
8 | $opts = getopt('f:l:m:'); | |
9 | if (($opts['f'] && $opts['f'] == '-') || empty($opts['f'])) { | |
10 | $file = 'php://stdin'; | |
11 | } else { | |
12 | $file = $opts['f']; | |
13 | } | |
14 | if (empty($opts['l']) || empty($opts['m'])) { | |
15 | exit; | |
16 | } | |
17 | $matcol = intval($opts['m']); | |
18 | $logcol = intval($opts['l']); | |
19 | $handle = fopen($file, 'r'); | |
20 | ||
21 | while ($data = fgetcsv($handle)) { | |
22 | $login = $data[$logcol]; | |
23 | $matri = preg_replace('/1(\d{2})(\d{3})/', '20${1}0\2', $data[$matcol]); | |
24 | if (!is_numeric($matri)) { | |
25 | echo "ERROR The matricule ($matri) is not a numerical value\n"; | |
26 | break; | |
27 | } | |
28 | $query = XDB::query("SELECT user_id | |
29 | FROM auth_user_md5 | |
30 | WHERE matricule = {?}", | |
31 | $matri); | |
32 | $uid = $query->fetchOneCell(); | |
33 | if (!$uid) { | |
34 | echo "WARNING Can't find uid for matricule $matri (login $login)\n"; | |
35 | continue; | |
36 | } | |
37 | $market = Marketing::get($uid, "$login@poly.polytechnique.fr"); | |
38 | if (!is_null($market)) { | |
39 | echo "WARNING A marketing has already been to $matri on $login\n"; | |
40 | continue; | |
41 | } | |
42 | $market = new Marketing($uid, "$login@poly.polytechnique.fr", 'default', null, 'staff'); | |
43 | $market->add(false); | |
44 | $market->send(); | |
45 | } | |
46 | ||
47 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: | |
48 | ?> | |
49 |