-
Notifications
You must be signed in to change notification settings - Fork 0
/
conference.php
149 lines (139 loc) · 5.19 KB
/
conference.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Conference Page</title>
<link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://cdn.staticfile.org/jquery/2.1.1/jquery.min.js"></script>
<script src="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
<style type="text/css">
body {
text-align: center;
}
.table{
text-align: left;
}
</style>
<script src="echarts.min.js"></script>
</head>
<body>
<h1>Conference Page</h1>
<?php
$Conference_Name = $_GET["Conference_Name"];
$link = mysqli_connect("localhost:3306", 'root', '', 'test');
$result = mysqli_query($link, "SELECT ConferenceID from conferences where ConferenceName='$Conference_Name '");
if ($result) {
$conferece_id = mysqli_fetch_array($result)['ConferenceID'];
echo"<p style='margin:4px auto;border:1px solid;border-radius:15px;Width:200px'>ConferenceName: $Conference_Name ConferenceID: $conferece_id</p>";
} else {
echo "Conference name not found";
}
?>
<div id="paperchart" style="width: 800px;height:500px;margin:0 auto;"></div>
<?php
$pagesize=10;
$page=$_GET['page']?$_GET['page'] : 1;
$startpage=($page-1)*$pagesize;
$totalpage = ceil(mysqli_fetch_array(mysqli_query($link, "SELECT count(*)from papers where ConferenceID='$conferece_id'"))[0]/$pagesize);
$result = mysqli_query($link, "SELECT PaperID,Title,PaperPublishYear from papers where ConferenceID='$conferece_id'");
$conference_statistics = array();
$result = mysqli_fetch_all(mysqli_query($link, "SELECT PaperPublishYear from Papers where ConferenceID='$conferece_id'"));
foreach ($result as $paper_info) {
$publish_year = $paper_info[0];
if(array_key_exists($publish_year, $conference_statistics))
$conference_statistics[$publish_year]++;
else
$conference_statistics[$publish_year]=1;
}
$result = mysqli_query($link, "SELECT PaperID,Title from papers where ConferenceID='$conferece_id'limit $startpage,$pagesize");
if ($result) {
?>
<table class="table table-hover table-bordered";>
<thead><tr><th>Title</th><th>Authors</th><th>Conference</th></tr></thead>
<?php
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
if($row){
$paper_title = $row['Title'];
$PaperID = $row['PaperID'];
echo "<td><a href=\"/paper.php?PaperID=$PaperID\">$paper_title</a></td>";
echo "<td>";
$author_1 = mysqli_fetch_all(mysqli_query($link, "SELECT AuthorName,authors.AuthorID from paper_author_affiliation INNER JOIN authors on authors.AuthorID=paper_author_affiliation.AuthorID where PaperID='$PaperID' order by AuthorSequence ASC"));
foreach ($author_1 as $author) {
$author_id = $author[1];
echo "<a href='author.php?author_id=$author_id&page=".(1)."'>$author[0]</a>; ";
}
echo "<td><a href='conference.php?Conference_Name=$Conference_Name&page=".(1)."'>$Conference_Name</a></td>";
}
echo "</tr>";
}
echo "</table>";
echo "<a class='btn btn-default btn-sm' role='button' href='conference.php?Conference_Name=$Conference_Name&page=".(1)."'>Front Page</a> ";
if($page!=1)echo "<a class='btn btn-default btn-sm' role='button' href='conference.php?Conference_Name=$Conference_Name&page=".($page-1)."'>Previous Page</a> ";
echo "<a class='btn btn-default btn-sm disabled' style='opacity:0.8;' role='button'>Current Page： $page/$totalpage</a>";
if($page!=$totalpage)echo "<a class='btn btn-default btn-sm' role='button' href='conference.php?Conference_Name=$Conference_Name&page=".($page+1)."'>Next Page</a> ";
echo "<a class='btn btn-default btn-sm' role='button' href='conference.php?Conference_Name=$Conference_Name&page=".$totalpage."'>Last Page</a>";
echo "<br><br><a style='border-radius:25px;' class='btn btn-default btn-lg' role='button' href='index.php'>Homepage</a> ";
}
?>
<script type="text/javascript">
var myChart = echarts.init(document.getElementById('paperchart'));
<?php
ksort($conference_statistics);
$years=array_keys($conference_statistics);
for ($y=$years[0]; $y<=$years[count($years)-1]; $y++) if(!array_key_exists($y,$conference_statistics)) $conference_statistics[$y]=0;
ksort($conference_statistics);
$years=implode(", ",array_keys($conference_statistics));
$counts=implode(", ",array_values($conference_statistics));
echo "var years = [$years];";
echo "var counts = [$counts];";
echo "var Conference_Name = \"$Conference_Name\";";
echo "//"
?>
option = {
title: {
text: 'Conference Papers Statistics'
},
legend: {
data: [years],
align: 'left'
},
toolbox: {
// y: 'bottom',
feature: {
magicType: {
type: ['stack', 'tiled']
},
dataView: {},
saveAsImage: {
pixelRatio: 2
}
}
},
tooltip: {},
xAxis: {
data: years,
silent: false,
splitLine: {
show: false
}
},
yAxis: {
},
series: [{
name: Conference_Name,
type: 'bar',
data: counts,
animationDelay: function (idx) {
return idx * 10;
}
}],
animationEasing: 'elasticOut',
animationDelayUpdate: function (idx) {
return idx * 5;
}
};
myChart.setOption(option);
</script>
</body>
</html>