| 1 | <html>
|
|---|
| 2 | <head>
|
|---|
| 3 | <meta name="Author" content="Daniela Dorner" />
|
|---|
| 4 | <meta http-equiv="content-type" content="text/html; charset=utf-8" />
|
|---|
| 5 | <title>FACT Project</title>
|
|---|
| 6 | <link rel="StyleSheet" type="text/css" href="../style.css" />
|
|---|
| 7 | </head>
|
|---|
| 8 | <?php
|
|---|
| 9 |
|
|---|
| 10 | echo (file_get_contents("../shifteval/header.html"));
|
|---|
| 11 |
|
|---|
| 12 | if (!empty($_GET["date"]))
|
|---|
| 13 | $date=$_GET["date"];
|
|---|
| 14 | else
|
|---|
| 15 | $date=date("Ymd");
|
|---|
| 16 |
|
|---|
| 17 | $starttimestamp = new DateTime($startdate);
|
|---|
| 18 | date_add($starttimestamp, date_interval_create_from_date_string("12 hours"));
|
|---|
| 19 | $stoptimestamp = new DateTime($stopdate);
|
|---|
| 20 | date_add($stoptimestamp, date_interval_create_from_date_string("12 hours"));
|
|---|
| 21 |
|
|---|
| 22 | echo "<body>\n";
|
|---|
| 23 | echo "<form action='memberlist.php' METHOD='GET'>\n";
|
|---|
| 24 | echo "<b>FACT Collaboration</b> status of date ";
|
|---|
| 25 | printf("<input name='date' type='text' size='10' maxlength='10' value='%s'>\n", $date);
|
|---|
| 26 | echo "<input type='submit' value='Show'> \n";
|
|---|
| 27 |
|
|---|
| 28 | include ("db.php");
|
|---|
| 29 | $db_id = mysql_connect($host, $user, $pw);
|
|---|
| 30 |
|
|---|
| 31 | //without institute:
|
|---|
| 32 | //select username, Date(Min(start)) as 'from', if(Max(stop)='2020-12-31
|
|---|
| 33 | //23:59:59', 'unlimited', Date(Max(stop))) as 'until',
|
|---|
| 34 | //Date(Adddate(Min(start), interval 6 MONTH)) as 'author since',
|
|---|
| 35 | //if(Max(stop)='2020-12-31 23:59:59', 'unlimited',
|
|---|
| 36 | //Date(Adddate(Max(stop), interval 1 year))) as 'author until' from
|
|---|
| 37 | //members where not isnull(start) and not isnull(stop) group by username;
|
|---|
| 38 |
|
|---|
| 39 | $query="SELECT username, Date(start) AS 'from', if(stop='2020-12-31 23:59:59', 'unlimited', Date(stop)) AS 'until',";
|
|---|
| 40 | $query.=" DATE(ADDDATE(start, INTERVAL 6 MONTH)) AS 'author since', ";
|
|---|
| 41 | $query.=" IF(stop='2020-12-31 23:59:59', 'unlimited', DATE(ADDDATE(stop, INTERVAL 1 YEAR))) AS 'author until', ";
|
|---|
| 42 | $query.=" institutename, MID(username, LOCATE(' ', username)+1) AS surname, ";
|
|---|
| 43 | $query.=" MID(username, 1, LOCATE(' ', username)) AS firstname ";
|
|---|
| 44 | $query.=" FROM memberlist.members LEFT JOIN memberlist.institutes USING(instituteid) ";
|
|---|
| 45 | $query.=" WHERE NOT start='0000-00-00 00:00:00' AND NOT stop='0000-00-00 00:00:00' ";
|
|---|
| 46 | $querycurrent=$query." AND ADDDATE(start, INTERVAL 6 MONTH) < '".$date."' AND ADDDATE(stop, INTERVAL 1 YEAR) > '".$date."' ";
|
|---|
| 47 | $querycurrent=$querycurrent." ORDER BY surname";
|
|---|
| 48 | $queryall=$query." ORDER BY surname";
|
|---|
| 49 |
|
|---|
| 50 | echo "<br>\n<br>\n";
|
|---|
| 51 | echo "<h3>Current Author List:</h3>\n";
|
|---|
| 52 | echo "<table border='1'>\n";
|
|---|
| 53 | echo "<thead><tr><th>Surname</th><th>Firstname</th><th>institute</th></tr></thead>\n";
|
|---|
| 54 | echo "<tbody>\n";
|
|---|
| 55 | $result = mysql_query($querycurrent);
|
|---|
| 56 | while ($row = mysql_fetch_row($result))
|
|---|
| 57 | echo "<tr><td>".$row[6]."</td><td>".$row[7]."</td><td>".$row[5]."</td></tr>";
|
|---|
| 58 | echo "<tbody>\n";
|
|---|
| 59 | echo "</table>\n<br>\n";
|
|---|
| 60 | mysql_free_result($result);
|
|---|
| 61 |
|
|---|
| 62 | echo "<br>\n<br>\n";
|
|---|
| 63 | echo "<h3>Full list:</h3>\n";
|
|---|
| 64 | echo "<table border='1'>\n";
|
|---|
| 65 | echo "<thead><tr><th>Name</th><th>Institute</th><th>Member since</th><th>Member until</th><th>Author since</th><th>Author until</th></tr></thead>\n";
|
|---|
| 66 | $result = mysql_query($queryall);
|
|---|
| 67 | echo "<tbody>\n";
|
|---|
| 68 | while ($row = mysql_fetch_row($result))
|
|---|
| 69 | echo "<tr><td>".$row[0]."</td><td>".$row[5]."</td><td>".$row[1]."</td><td>".$row[2]."</td><td>".$row[3]."</td><td>".$row[4]."</td></tr>";
|
|---|
| 70 | echo "</tbody>\n";
|
|---|
| 71 | echo "</table>\n<br>\n";
|
|---|
| 72 | mysql_free_result($result);
|
|---|
| 73 |
|
|---|
| 74 | mysql_close($db_id);
|
|---|
| 75 |
|
|---|
| 76 | echo "</form>\n";
|
|---|
| 77 | echo "</body>\n";
|
|---|
| 78 | echo "</html>\n";
|
|---|
| 79 |
|
|---|
| 80 | ?>
|
|---|
