//Defaults
include("/w/web/eecs/etc/common/sanitize.php");
$member_name = '';
$myDIV = "EECS";
include_once("/w/web/eecs/etc/events/change/db.php"); MyG::dbconnect('dconetdb');
include("/w/web/eecs/etc/events/getfunctions.php");
$cat = isset($_GET['cat']) ? $_GET['cat'] : '';
$cat = strip_tags(trim($cat));
$cat = sanitize($cat);
//Check for valid category
$is_ok = '';
$oklist = array("All","DOW","Distinguished", "Defense", "Student", "Other", "Colloquium", "Women_Computing", "WIMS2", "NLP",
"Sem_AI", "C-PHOM", "Sem_CUOS", "Sem_Signal_Processing", "Sem_ACAL", "Sem_Control", "DYNAMO", "Interactive",
"IPAN", "INEMS", "LNF", "MICL", "MIDAS", "MINDS", "Sem_MIPSE", "MPEL", "NNIN", "Sem_Optics", "Sem_Radlab", "Sem_Robotics",
"Sem_Quantum", "Sem_Security", "Sem_Software", "Sem_SSEL", "SSELS", "Sem_Systems", "Sem_Theory", "Sem_Other","Vision","UMOR","EECS_Seminar");
foreach($oklist as $okvalue) { if($cat == $okvalue) { $is_ok = 'yes'; } }
if($cat && !$is_ok) { header("Location: https://www.eecs.umich.edu/eecs/etc/events/eecsevents.html"); exit; }
$year = isset($_GET['year']) ? $_GET['year'] : ''; $year = (int)$year;
$showall = isset($_GET['showall']) ? $_GET['showall'] : ''; $showall = strip_tags(trim($showall));
$cur_date = date("Y-m-d");
//Get SQL
if($cat) { $member_name = $categories[$cat]; }
if($year > 1990)
{
$dateA = $year . "-01-01";
$dateB = $year . "-12-31";
$sql = "SELECT * FROM events " .
"WHERE event_date >= \"$dateA\" " . "AND event_date <= \"$dateB\" " .
"ORDER BY event_date, time_start";
$title0 = "All EECS Events for $year";
}
elseif($cat == "All")
{
$sql = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" " .
"AND (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR event_type = \"NLP\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" " .
"AND (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR event_type = \"NLP\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date DESC, time_start DESC LIMIT 10";
$sql2 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR event_type = \"NLP\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date DESC, time_start DESC";
$title0 = "$myDIV Seminars";
}
elseif($member_name)
{
$sql = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" " .
"AND etypes.etype = \"$cat\" ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" " .
"AND etypes.etype = \"$cat\" " .
"ORDER BY event_date DESC, time_start LIMIT 10";
$sql2 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE etypes.etype = \"$cat\" " .
"ORDER BY event_date DESC, time_start";
//printerr("$member_name");
if($member_name == "All Seminars") { $title0 = "$myDIV $member_name"; }
elseif($member_name == "Student Event") { $title0 = "$myDIV Student Events"; }
elseif($member_name == "Defense") { $title0 = "$myDIV Student Defenses"; }
elseif($member_name == "Colloquium") { $title0 = "$myDIV Colloquia"; }
elseif($member_name == "Women in Computing") { $title0 = "Women in Computing Seminars"; }
elseif($member_name == "Other Seminars") { $title0 = "Other Seminars"; }
elseif($member_name == "Other Event") { $title0 = "Other $myDIV Events"; }
elseif($member_name == "Distinguished Lecture") { $title0 = "$myDIV Distinguished Lectures"; }
elseif($member_name == "Natural Language Processing") { $title0 = "Natural Language Processing Seminars"; }
elseif($member_name == "NNIN Seminar Series") { $title0 = "NNIN Seminars"; }
elseif($member_name == "MICL Seminar Series") { $title0 = "MICL Seminars"; }
elseif($member_name == "MPEL Seminar Series") { $title0 = "MPEL Seminars"; }
elseif($member_name == "Wireless Integrated MicroSensing & Systems") { $title0 = "WIMS Seminars"; }
elseif($member_name == "SSEL Special Lecture Series") { $title0 = "SSEL Special Lecture Seminars"; }
elseif($member_name == "LNF Seminar Series") { $title0 = "LNF Seminars"; }
else { $title0 = "$member_name" . "s"; }
}
else
{
$sql = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" ORDER BY event_date DESC, time_start LIMIT 10";
$sql2 = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
//"ORDER BY event_date DESC, time_start LIMIT 100";
"WHERE event_date < \"$cur_date\" ORDER BY event_date DESC, time_start LIMIT 100";
$title0 = "$myDIV Events";
}
print <<
.left{display:inline-block; float:left}
.right{display:inline-block; float:left;}
END;
//printerr("$sql");
//Show all events
if($showall == 'yes')
{
$title = "All $title0
\n";
if($title0 == "$myDIV Events") { $title = "$title0 (Last 100)
\n"; }
getresults($sql2);
}
//Show upcoming/recent events
else
{
$title = "Upcoming $title0
\n";
if($cat=="Sem_AI")
{
$title = "Upcoming AI Events
\n";
$title .= '
CSE\'s AI Seminar Series provides a forum for researchers in this important area to share their findings and thoughts. The AI Seminar Series is sponsored by Soar Technology.
';
}
getresults($sql);
if($sql1)
{
$title = "
Recent Events
\n";
getresults($sql1);
}
if($title0 == "$myDIV Events") { print "
Show Last 100 Events\n"; }
elseif(!$year) { print "
Show All Upcoming and Past Events\n"; }
}
?>