From 1d8794523e5de5752a1042c319248f8f4d04dbef Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Sat, 2 Oct 2004 15:44:00 +0000
Subject: [PATCH] ins reports

---
 scripts/cron/rapports_inscription.php | 69 +++++++++++++++++++++++++++++++++++
 1 file changed, 69 insertions(+)
 create mode 100755 scripts/cron/rapports_inscription.php

diff --git a/scripts/cron/rapports_inscription.php b/scripts/cron/rapports_inscription.php
new file mode 100755
index 0000000..85b8626
--- /dev/null
+++ b/scripts/cron/rapports_inscription.php
@@ -0,0 +1,69 @@
+#!/usr/bin/php4 -q
+<?php
+require('./connect.db.inc.php');
+$MESSAGE = '';
+
+// ---------------------------------------
+
+$result=mysql_query("SELECT  a.alias, u.promo, email
+                       FROM  ins_confirmees AS i
+		  LEFT JOIN  auth_user_md5  AS u ON( i.id = u.user_id )
+		  LEFT JOIN  aliases        AS a ON( i.id=a.id AND a.type='a_vie' )
+		  LEFT JOIN  emails         AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
+		   GROUP BY  alias
+		   ORDER BY  promo");
+$a = mysql_num_rows($result);
+if ($a > 0) {
+    $MESSAGE.="$a INSCRIPTIONS CONFIRMEES:\n";
+    while (list($usern,$promo,$mail) = mysql_fetch_row($result)) {
+	$MESSAGE.="X$promo, $usern, $mail\n";
+    }
+}
+mysql_free_result($result);
+
+// ---------------------------------------
+
+$result=mysql_query("SELECT  ins_id,username,promo,email,date
+		       FROM  en_cours
+		      WHERE  loginbis != 'INSCRIT'
+		   ORDER BY  date");
+$b = mysql_num_rows($result);
+if ($b > 0) {
+    $MESSAGE.="\n$b INSCRIPTIONS NON CONFIRMEES:\n";
+    while (list($code,$usern,$prom,$mail,$quand) = mysql_fetch_row($result)) {	
+	$MESSAGE.="$quand, X$prom, $usern\n$mail";
+	$MESSAGE.="\n";
+	$MESSAGE.="http://www.polytechnique.org/step4.php?ref=$code\n";
+    }
+}
+mysql_free_result($result);
+
+// ---------------------------------------
+
+$result=mysql_query("SELECT  nom, prenom, promo, email, DATE_FORMAT(date_envoi,'%d/%m/%Y')
+                       FROM  envoidirect 
+		      WHERE  date_succes = ''
+		   ORDER BY  date_envoi DESC, promo, nom");
+$c = mysql_num_rows($result);
+if ($c > 0) {
+    $MESSAGE.="\n$c INSCRIPTIONS SOLICITÉEs:\n";
+    while (list($nom,$prenom,$promo,$mail,$date) = mysql_fetch_row($result)) {
+	$MESSAGE.="$date: X$promo, $nom $prenom,\t$mail\n";
+    }
+}
+mysql_free_result($result);
+
+// ---------------------------------------
+
+$MESSAGE=$MESSAGE."\n\n";
+
+// envoi du mail à register@
+$HEADER="From: register\nReply-To: register@polytechnique.org\n".
+	"X-Mailer: PHP/" . phpversion()."\n".
+        "Mime-Version: 1.0\n".
+        "Content-Type: text/plain; charset=iso-8859-1\n".
+        "Content-Disposition: inline\n".
+        "Content-Transfer-Encoding: 8bit\n";
+mail("register@polytechnique.org, jean-michel.yolin+register@polytechnique.org","$a confirmées, $b en attente et $c sollicitées",$MESSAGE,$HEADER);
+mysql_query("DELETE FROM ins_confirmees");
+?>
-- 
2.1.4