• Overview
• Past projects
• Summary

Projects summary

" . utf8_decode($row[1]) . ""; $funding = utf8_decode($row[3]); $start = ""; $end = ""; $percent_complete = 0; $totalyrs = null; $starttime = null; if (strlen($row[5])>0 && strlen($row[6])>0){ $starttime = strtotime($row[5]); $endtime = strtotime($row[6]); $totaltime = $endtime - $starttime; $totalyrs = round($totaltime/(60*60*24*365.25)); $now = time(); if ($now > $starttime) $percent_complete = ($now - $starttime) / $totaltime * 100; $start = date("d/m/y", $starttime); $end = date("d/m/y", $endtime); } print("\n"); print("\n"); print("\n"); print("\n"); } else { print("\n"); } ?> \n"); } pg_close($connection); ?>

Project	Funding	Timeline	People	Publications
$name	$funding"); if($totalyrs != null){ print(" ($totalyrs years)	$start - $end \n"); print(" "); print(" \n"); print("		=$startyear AND pu1.pub_type='Journal Article' "; $sql .= "UNION "; $sql .= "SELECT pu2.pub_id, pu2.year, pu2.author, pu2.title, pu2.sec_title, pu2.pub_type "; $sql .= "FROM publications as pu2, projects_pubs as pp2 "; $sql .= "WHERE pu2.pub_id=pp2.pub_id AND pp2.project_id=$pid AND pu2.year>=$startyear AND pu2.pub_type='Conference Paper' "; $sql .= "UNION "; $sql .= "SELECT pu3.pub_id, pu3.year, pu3.author, pu3.title, pu3.sec_title, pu3.pub_type "; $sql .= "FROM publications as pu3, projects_pubs as pp3 "; $sql .= "WHERE pu3.pub_id=pp3.pub_id AND pp3.project_id=$pid AND pu3.year>=$startyear AND NOT pu3.pub_type='Journal Article' AND NOT pu3.pub_type='Conference Paper' "; $sql .= "ORDER by pub_type, year, pub_id;"; $pubslist = pg_query($connection, $sql); if ($peoplelist) { while ($pers = pg_fetch_row($peoplelist)) { if ($pers[2] == "t") print(""); print("" . utf8_decode($pers[0])); print(" " . utf8_decode($pers[1]) . ""); if ($pers[2] == "t") print(""); print(" \n"); } } print("	"); if ($pubslist) { $pubtype = ""; while ($pub = pg_fetch_row($pubslist)) { if ($pub[5] != $pubtype){ if($pub[5] == "Journal Article" || $pub[5] == "Conference Paper") print("" . $pub[5] . "s: \n"); else print("Other: \n"); $pubtype = $pub[5]; } $citation = make_citation(utf8_decode($pub[1]), utf8_decode($pub[2])); $ref = make_short_ref($pub[5], utf8_decode($pub[1]), utf8_decode($pub[2]), utf8_decode($pub[3]), utf8_decode($pub[4]), false); print("$citation \n"); } } ?>