Changeset 18208 for trunk/www/dch

Timestamp:

06/15/15 00:09:36 (9 years ago)

Author:

Daniela Dorner

Message:

added expert-on-call info

File:

• trunk/www/dch/shiftinfo.php (modified) (3 diffs)

trunk/www/dch/shiftinfo.php

@@ -16 +16 @@
 and <a href='https://www.fact-project.org/logbook/memberlist.php'>FACT logbook<a>)
 
+<!--#!/usr/bin/php-->
 <?php
 
-if (date("H")>8)
-    $today=date("Ymd", mktime(0,0,0,date("m"), date("d"), date("Y")));
+if ($argv)
+    parse_str(implode('&', array_slice($argv, 1)), $_GET);
+
+if (isset($_GET['date']))
+    $today=date("Ymd", strtotime($_GET["date"]));
 else
-    $today=date("Ymd",strtotime(date("Y-m-d", mktime(0,0,0,date("m"), date("d"), date("Y")))." -1 day"));
+{
+    if (date("H")>8)
+        $today=date("Ymd", mktime(0,0,0,date("m"), date("d"), date("Y")));
+    else
+        $today=date("Ymd",strtotime(date("Y-m-d", mktime(0,0,0,date("m"), date("d"), date("Y")))." -1 day"));
+}
+
+function send_email($date, $msg_part)
+{
+    //echo "WARNING: no shift crew found -> need to send email.<br>\n";
+    $to = "fact-online@lists.phys.ethz.ch";
+    //$to = "dorner@astro.uni-wuerzburg.de";
+    $subject = $date.": shifter-info missing";
+    $msg = "WARNING: No shifter-info available for ".$date."\n\n";
+    $msg .= $msg_part;
+
+    if (!mail($to, $subject, $msg, 'From:observations@fact-project.org'))
+        echo "Sending warning email failed.<br>\n\n";
+}
+
 
 echo "<br> &nbsp;&nbsp;Night: ".$today." (date of sunset) <br>";
-$query="SELECT u FROM calendar.Data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."' AND x=0 ";
-//echo $query;
+$query="SELECT u FROM calendar.Data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."'";
+//excluding experts and institutes (apart from 'moon')
+$query.=" AND NOT x=1 AND u NOT in('ISDC','ETHZ','TUDO','UNIWUE')";
 include ("db.php");
 $db_id = mysql_connect($host, $user, $pw);
 $result  = mysql_query($query);
-echo "&nbsp;&nbsp;Contact Info Shiftcrew: <br>\n <ul>\n";
+$numrows=mysql_num_rows($result);
+if ($numrows==0)
+    send_email($today, "Whoever is on shift, please insert your name to the shift calendar!\n");
+else
+    echo "&nbsp;&nbsp;Contact Info Shiftcrew: <br>\n ";
+echo "<ul>\n";
 while ($row = mysql_fetch_row($result))
 {
-    //echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;".$row[0]." ";
     $query2="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='".$row[0]."'";
-    //echo $query2;
     $result2  = mysql_query($query2);
     while ($row2 = mysql_fetch_row($result2))
     {
         echo "<li>".$row2[0].": ".$row2[1]."</li>\n";
+        if (!$row2[1])
+            send_email($today, "Dear ".$row2[0].", please insert your 'Contact Info' in your logbook user-profile!");
     }
     mysql_free_result($result2);
@@ -45 +74 @@
 mysql_free_result($result);
 
-echo "General Contact Info: <br>\n <ul>\n";
-$query3="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='dorner'";
+echo "Expert-On-Call Contact Info: <br>\n <ul>\n";
+$query3="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) LEFT JOIN memberlist.experts ON (ufid=userid) WHERE now() < stop and now() > start";
 $result3  = mysql_query($query3);
 while ($row3 = mysql_fetch_row($result3))
@@ -53 +82 @@
 }
 mysql_free_result($result3);
+echo "</ul>\n";
 
+/*
+echo "General Contact Info: <br>\n <ul>\n";
+$query4="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='dorner'";
+$result4  = mysql_query($query4);
+while ($row4 = mysql_fetch_row($result4))
+{
+    echo "<li>".$row4[0].": ".$row4[1]."</li>\n";
+}
+mysql_free_result($result4);
 echo "</ul>\n";
+*/
 
 ?>