X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fcron_validations.php;h=6efa5bad5e33896c33b4afe67bd17ecd22d54d99;hb=ebd515f95f03f8a87f9b846d65e179b39a535222;hp=dce1a642c0dfa9544c2a0c901f421b11fe2cb182;hpb=1d55fe45fa148bbe6209f82f97d19dcd26455eeb;p=platal.git

diff --git a/bin/cron/cron_validations.php b/bin/cron/cron_validations.php
index dce1a64..6efa5ba 100755
--- a/bin/cron/cron_validations.php
+++ b/bin/cron/cron_validations.php
@@ -1,7 +1,7 @@
 #!/usr/bin/php5 -q
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2007 Polytechnique.org                              *
+ *  Copyright (C) 2003-2008 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -21,7 +21,7 @@
  ***************************************************************************/
 /* vim: set sw=4 ts=4 sts=4 tw=100:
  * vérifie qu'il n'y a pas de validations en cours, et maile si c'est le cas
-*/ 
+*/
 
 $M_PERIOD = "INTERVAL 3 HOUR"; // période d'envoi des mails de 3h
 $R_PERIOD = "INTERVAL 6 HOUR"; // période de réponse moyenne de 6h
@@ -29,8 +29,27 @@ $R_PERIOD = "INTERVAL 6 HOUR"; // période de réponse moyenne de 6h
 require('./connect.db.inc.php');
 require('plmailer.php');
 
-$res = XDB::query("SELECT count(stamp), sum(stamp < NOW() - $M_PERIOD), sum(stamp < NOW() - $R_PERIOD) FROM x4dat.requests");
-list($nb,$nbold,$nbveryold) = $res->fetchOneRow();
+$res = XDB::query("SELECT  count(r.stamp), UNIX_TIMESTAMP(MIN(r.stamp)),
+                           sum(r.stamp < NOW() - $M_PERIOD), sum(r.stamp < NOW() - $R_PERIOD)
+                     FROM  x4dat.requests AS r");
+list($nb, $age, $nbold, $nbveryold) = $res->fetchOneRow();
+
+$age = (time() - intval($age)) / 86400;
+$head = "";
+if ($age > 15) {
+    $head = "[autodestruction du serveur] ";
+} elseif ($age > 7) {
+    $head = "[armageddon imminent] ";
+} elseif ($age > 5) {
+    $head = "[guerre nucléaire] ";
+} elseif ($age > 3) {
+    $head = "[ET Téléphone maison] ";
+} elseif ($age > 1) {
+    $head = "[réveil !] ";
+} elseif (!empty($nbveryold)) {
+    $head = "[urgent] ";
+}
+
 
 if (empty($nb)) {
     exit;
@@ -41,7 +60,7 @@ $plural = $nb == 1 ? "" : "s";
 $mymail = new PlMailer();
 $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");
+$mymail->setSubject($head . "il y a $nb validation$plural non effectuée$plural");
 
 $message =
 	"il y a $nb validation$plural à effectuer \n"
@@ -58,7 +77,7 @@ while (list($type, $nb) = $res->next()) {
     $message .= "- $type: $nb\n";
 }
 
-$message = wordwrap($message,78);  
+$message = wordwrap($message,78);
 $mymail->setTxtBody($message);
 $mymail->send();
 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: