4 ini_set('include_path', '.:../include:/usr/share/php');
5 require_once('connect.db.inc.php');
6 require_once('marketing.inc.php');
8 $opts = getopt('f:l:m:');
9 if (($opts['f'] && $opts['f'] == '-') ||
empty($opts['f'])) {
10 $file = 'php://stdin';
14 if (empty($opts['l']) ||
empty($opts['m'])) {
17 $matcol = intval($opts['m']);
18 $logcol = intval($opts['l']);
19 $handle = fopen($file, 'r');
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";
28 $query = XDB
::query("SELECT user_id
30 WHERE matricule = {?}",
32 $uid = $query->fetchOneCell();
34 echo "WARNING Can't find uid for matricule $matri (login $login)\n";
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";
42 $market = new Marketing($uid, "$login@poly.polytechnique.fr", 'default', null
, 'staff');
47 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: