exit;
}
+$plural = $nb == 1 ? "" : "s";
+
$mymail = new PlMailer();
-$mymail->setFrom('validation@polytechnique.org');
-$mymail->addTo("validation@polytechnique.org");
-$mymail->setSubject((empty($nbveryold)?"":"[urgent] ")."il y a $nb validations non effectuées");
+$mymail->setFrom('validation@' . $globals->mail->domain);
+$mymail->addTo("validation@" . $globals->mail->domain);
+$mymail->setSubject((empty($nbveryold)?"":"[urgent] ")."il y a $nb validation$plural non effectuée$plural");
$message =
- "il y a $nb validation à effectuer \n"
+ "il y a $nb validation$plural à effectuer \n"
.(empty($nbold)?"":"dont $nbold depuis le dernier mail !!!\n")
- .(empty($nbveryold)?"":"et dont *$nbveryold* sont en retard de plus de 6h !!!")
+ .(empty($nbveryold)?"":"et dont *$nbveryold* ".($nbveryold == 1 ? "est" : "sont")." en retard de plus de 6h !!!")
."\n"
- ."https://www.polytechnique.org/admin/validate\n";
+ ."https://www.polytechnique.org/admin/validate\n\n"
+ ."Par catégorie :\n";
+$res = XDB::iterRow("SELECT type, count(*)
+ FROM x4dat.requests
+ GROUP BY type
+ ORDER BY type");
+while (list($type, $nb) = $res->next()) {
+ $message .= "- $type: $nb\n";
+}
$message = wordwrap($message,78);
$mymail->setTxtBody($message);