Is FACT taking data?
Who is on shift?
(from FACT shift plan
and FACT logbook)
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)
{
$to = "fact-online@lists.phys.ethz.ch";
$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.
\n\n";
}
function get_userinfo($db, $username)
{
// this is getting exactly one entry from the DB, since we get only
// one username, which is unique in the DB.
// contactinfo and availability need to be queried as else PHP complains
// in the function userinfo_to_string(), but for shifter they can/should be empty
$query="SELECT username as login, usertitle as name, email, fid5 as mobile, fid7 as skype, '' as contactinfo, '' as availability
FROM logbook.userfields
LEFT JOIN logbook.users
ON (uid=ufid)
WHERE username='".$username."'";
$result = $db->query($query);
$all = $result->fetch_assoc();
$result->free();
return $all;
}
function get_expertinfo($db, $type)
{
$query="SELECT username as login, usertitle as name, email, fid5 as mobile, fid7 as skype, fid8 as contactinfo, fid6 as availability
FROM logbook.userfields
LEFT JOIN logbook.users ON (uid=ufid)
LEFT JOIN memberlist.experts
ON (ufid=userid)
WHERE now() < stop and now() > start AND not isnull (".$type.")";
$result = $db->query($query);
$all = $result->fetch_all(MYSQLI_ASSOC);
$result->free();
return $all;
}
function userinfo_to_string($userinfo)
{
$s = $userinfo['name'] . "[" .$userinfo['login']."]" . ":
";
if (str_replace(' ', '', $userinfo['contactinfo']))
$s .= $userinfo['contactinfo']."
";
else
{
$s .= " email:" . $userinfo['email'] . "
";
$s .= " mobile:" . $userinfo['mobile'] . "
";
$s .= " skype:" . $userinfo['skype'] . "
";
}
if ((strcmp($_SERVER['REMOTE_USER'], "FACT")==0) && str_replace(' ', '', $userinfo['availability']))
$s .= "availability information:
".$userinfo['availability']."
";
return $s;
}
function send_warning_mail_to_user($userinfo, $today)
{
$msg = "Dear " . $userinfo['name'] . "[".$userinfo['login']."]," ."\n\n";
$msg .= "please insert your 'Shifthelper Mobile Phone Number' in ";
$msg .= ' https://www.fact-project.org/logbook/usercp.php?action=profile';
send_email($today, $msg);
}
echo "
Night: ".$today." (date of sunset)
";
$query="SELECT u FROM calendar.Data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."'";
$query.=" AND NOT x=1 AND u NOT in('ISDC','ETHZ','TUDO','UNIWUE')";
include ("db.php");
$db = new mysqli($host, $user, $pw, $database);
$db->set_charset("utf8");
$result = $db->query($query);
$numrows=mysqli_num_rows($result);
if ($numrows==0)
send_email($today, "Whoever is on shift, please insert your name to the shift calendar!\n");
else
echo " Contact Info Shiftcrew:
\n ";
echo "\n";
while ($row = $result->fetch_assoc())
{
$userinfo = get_userinfo($db, $row['u']);
if ($userinfo['name'])
{
echo "- ".userinfo_to_string($userinfo)."
\n";
if (!$userinfo['mobile'])
send_warning_mail_to_user($userinfo, $today);
}
}
echo "
\n
\n";
$result->free();
echo "Remark for MAGIC shifters: please keep in mind that FACT shifters and experts will \n ";
echo "usually be asleep during the night, so that messages on skype or by email might stay \n ";
echo "unnoticed until the next morning.
\n
\n ";
echo "Expert-On-Call Contact Info:
\n \n";
foreach (get_expertinfo($db, "expert") as $expertinfo)
{
echo "- ".userinfo_to_string($expertinfo)."
\n";
}
echo "
\n";
echo "Flare-Expert-On-Call Contact Info:
\n \n";
foreach (get_expertinfo($db, "flare") as $expertinfo)
{
echo "- ".userinfo_to_string($expertinfo)."
\n";
}
echo "
\n";
echo "SH-Expert-On-Call Contact Info:
\n \n";
foreach (get_expertinfo($db, "sh") as $expertinfo)
{
echo "- ".userinfo_to_string($expertinfo)."
\n";
}
echo "
\n";
echo "Fallback-Shifter Contact Info:
\n \n";
foreach (get_expertinfo($db, "fallback") as $expertinfo)
{
echo "- ".userinfo_to_string($expertinfo)."
\n";
}
echo "
\n";
?>