forked from luyuting/Scholarship
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhistory.php
63 lines (63 loc) · 1.81 KB
/
history.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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>申请历史</title>
<meta charset="utf-8">
<link rel="stylesheet" href="css/gather.css"/>
<link rel="stylesheet" href="css/history.css"/>
</head>
<body>
<?php
include('nav.php');
require_once('php/dao/BaseDao.php');
class HistoryDao extends BaseDao{
public function applyHistory($ap_student,$sc_annual){
$sql="select count(*) num,sc_name from t_apply,t_scholarship where sc_annual='$sc_annual' and sc_id=
ap_scho_type and ap_student='$ap_student' group by(sc_name) order by sc_name asc";
return $this->query($sql);
}
}
?>
<div class="main-box">
<?php
$year=Date("Y");
$hDao=new HistoryDao;
$ap_student=$_SESSION['u_sid'];
for($i=2013;$i<=$year;$i++){
$describe=array();
switch($i){
case 2013:$describe[]="使用校园资助网进行奖学金评审";break;
case 2014:
$describe[]="Torch奖学金评审系统1.0";
$describe[]="职业生涯档案系统";
break;
case 2015:
$describe[]="Torch奖学金评审系统2.0";
break;
default:;break;
}
echo "<div class='section'>
<div class='arrow'>{$i}</div>";
for($j=0;$j<count($describe);$j++)
echo "<span class='describe'>
{$describe[$j]}
</span>";
$history_arr=$hDao->applyHistory($ap_student,$i);
echo "<div>";
for($k=0;$k<count($history_arr);$k++){
echo "<span class='describe audit'>
{$history_arr[$k]->sc_name}（审核中）
</span>";
}
echo "</div></div>";
}
?>
</div>
<center>
<div class="bottom">
Copyright © 2014 - 2015 Torch.All Rights Reserved.<br>
Torch职业生涯规划团队 版权所有
</div>
</center>
</body>
</html>