Changeset 19743


Ignore:
Timestamp:
Oct 8, 2019, 9:04:08 AM (11 days ago)
Author:
dorner
Message:
added all expert info
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/www/dch/shiftinfo.php

    r18880 r19743  
    1414Who is on shift?
    1515(from <a href='https://www.fact-project.org/shift'>FACT shift plan<a>
    16 and <a href='https://www.fact-project.org/logbook/memberlist.php'>FACT logbook<a>)
    17 
     16and <a href='https://www.fact-project.org/logbook/memberlist.php'>FACT logbook<a>)<br>
    1817<?php
    1918
     
    6766
    6867
    69 function get_expertinfo($db)
     68function get_expertinfo($db, $type)
    7069{
    7170    $query="SELECT username as login, usertitle as name, email, fid5 as mobile, fid7 as skype, fid8 as contactinfo, fid6 as availability
     
    7473        LEFT JOIN memberlist.experts
    7574        ON (ufid=userid)
    76         WHERE now() < stop and now() > start";
     75        WHERE now() < stop and now() > start AND not isnull (".$type.")";
    7776    $result  = $db->query($query);
    7877    $all = $result->fetch_all(MYSQLI_ASSOC);
     
    128127    }
    129128}
    130 echo "</ul>\n <br>\n <br>\n ";
     129echo "</ul>\n <br>\n";
    131130$result->free();
     131
     132echo "Remark for MAGIC shifters: please keep in mind that FACT shifters and experts will \n ";
     133echo "usually be asleep during the night, so that messages on skype or by email might stay \n ";
     134echo "unnoticed until the next morning.<br>\n  <br>\n ";
     135
    132136
    133137echo "Expert-On-Call Contact Info: <br>\n <ul>\n";
    134138
    135 foreach (get_expertinfo($db) as $expertinfo)
     139foreach (get_expertinfo($db, "expert") as $expertinfo)
     140{
     141    echo "<li>".userinfo_to_string($expertinfo)."</li><br>\n";
     142
     143}
     144echo "</ul>\n";
     145
     146echo "Flare-Expert-On-Call Contact Info: <br>\n <ul>\n";
     147
     148foreach (get_expertinfo($db, "flare") as $expertinfo)
     149{
     150    echo "<li>".userinfo_to_string($expertinfo)."</li><br>\n";
     151
     152}
     153echo "</ul>\n";
     154
     155echo "SH-Expert-On-Call Contact Info: <br>\n <ul>\n";
     156
     157foreach (get_expertinfo($db, "sh") as $expertinfo)
     158{
     159    echo "<li>".userinfo_to_string($expertinfo)."</li><br>\n";
     160
     161}
     162echo "</ul>\n";
     163
     164echo "Fallback-Shifter Contact Info: <br>\n <ul>\n";
     165
     166foreach (get_expertinfo($db, "fallback") as $expertinfo)
    136167{
    137168    echo "<li>".userinfo_to_string($expertinfo)."</li><br>\n";
Note: See TracChangeset for help on using the changeset viewer.