-
Notifications
You must be signed in to change notification settings - Fork 0
/
attendance.php
181 lines (180 loc) · 7.27 KB
/
attendance.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
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<?php
require_once 'get_user_info.php';
//用于检测是否登录，测试本页面时可暂时屏蔽以下几行php代码
if(!$is_login){
echo "<script> alert('Please login...');parent.location.href='./index.php'; </script>";
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>点名信息查询</title>
<script src="js/jquery-3.2.1.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/layer/layer.js"></script>
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="http://">
<link href='http://cdn.webfont.youziku.com/webfonts/nomal/107666/45803/59b53de8f629d81184f0b95c.css' rel='stylesheet' type='text/css' />
<link href='http://cdn.webfont.youziku.com/webfonts/nomal/107666/45803/59bf958cf629d80f5860546d.css' rel='stylesheet' type='text/css' /></head>
<style>
html,body{margin-top:0px;padding-top:0px;}
#course_name span{color:#000000;font-size:35px;}
#course_name{border:1px solid #fffdfc;width:100%;min-height:100px;height:auto;line-height:100px;text-align:center;}
/*#select_course{height:25px;text-align:center;margin-top:20px;margin-left:160px;margin-bottom: 20px;}*/
#menuselect{border-bottom:1px solid #fffdfc;width:100%;height:20px;margin: 0px;color:#92A1AC; text-align:center;padding:0px;line-height:20px;}
#menuselect ul{border-bottom:1px solid #fffdfc;margin-top:-10px;display:block;padding:0px;}
.showa{font-size: 20px;color: white;}
ul li{list-style-type:none;display:inline;margin:4%;}
#menuselect a{color:#000000;}
#menusure{display:block;width:100%;height:70px;border-top:1px solid #fffdfc;text-align:center;line-height:70px;}
#menusure span{font-size:25px;font-family:'LiDeBiao-Xing3d11231b241a492';}
/*#select-class{margin:10px;}*/
th,tr{text-align: center;}
/*select{width:auto;min-width: 100px;text-align: center;}*/
/*清掉默认设置的样式*/
a:hover {color: white;}
a:active {color: white;}
a:visited{color: white;}
a:link{color: white;}
#select_course{
margin-top:30px;
}
#select-class,#select_course{
border-radius:10px;
position: relative;
min-width: 200px;
width:auto;
height:40px;
margin: 0 auto;
padding: 0px;
background: #fff;
border-left: 5px solid grey;
cursor: pointer;
outline: none;
}
#showdata{margin-top:60px;}
</style>
<body>
<div id="course_name">
<span style="font-family:'LiDeBiao-Xing3d11231b241a492';font-size:30px;" >选择课程</span>
<select id="select_course" onChange = "getcourse()">
<option value="请选择" selected>选择课程</option>
<?php
$userid = $_SESSION['userid'];
$find_course = "SELECT distinct courseId,courseName FROM basic_relation WHERE userId=$userid";
$set=mysqli_query($db,$find_course);
while($row=mysqli_fetch_assoc($set)){
echo "<option value='".$row['courseName']."'>".$row['courseName']."</option>";
}
mysqli_close($db);?>
</select>
</div>
<div id="menuselect">
<ul>
<li> <a style="font-family:'LiDeBiao-Xing3d11231b241a492';color:grey" href="#" class="showa" id="showaone" onclick="searchdate()">按日期查询</a></li>
<li> <a style="font-family:'LiDeBiao-Xing3d11231b241a492';color:grey" href="#" class="showa" id="showatwo" onclick="searchclass()">按班级查询</a></li>
</ul>
</div>
<div id="menusure">
<span style="font-family:'LiDeBiao-Xing3d398973181a492';font-size:30px;" >选择班级</span>
<select id="select-class" onChange = "attendance_data()">
<!-- <option>国贸</option>-->
<!-- <option>计科</option>-->
</select>
</div>
<div id="showdata">
<table class="table table-bordered table-hover table-condensed" id="showTable">
</table>
</div>
</body>
<script>
var date_array=new Array();
var class_array=new Array();
$( '#select_course' ).dropdown( {
gutter : 2,
stack : false,
slidingIn : 100
} );
$( '#select-class' ).dropdown( {
gutter : 2,
stack : false,
slidingIn : 100
} );
function getcourse(){
$("#menusure span").html("选择查询方式");
$("#select-class").html("");
var obj = $("#select_course");
var index = obj.selectedIndex;
$("#showTable").empty();
if ("请选择" != obj.val()) {
$.ajax({
type:"POST",
url:"phpData/return_class_date.php",
data:{userId:<?php echo $_SESSION['userid'];?>,selected_course:obj.val()},
dataType:"json",
success:function(data) { //返回一个json数组，数组中分别包含班级和日期两个数组
date_array=data.search_date;
class_array=data.search_class;
}
});
}else{
window.location.reload();
}
}
function searchdate()
{
$("#showTable").empty();
$("#menusure span").html("");
$("#menusure span").html("选择日期");
$("#select-class").html("");
$("#select-class").append("<option value='请选择' selected>选择日期</option>");
var str="";
for(var i=0;i<date_array.length;i++)
{
str += "<option value='"+date_array[i]+"'>"+date_array[i]+"</option>";
}
$("#select-class").append(str);
}
function searchclass(){
$("#showTable").empty();
$("#menusure span").html("");
$("#menusure span").html("选择班级");
$("#select-class").html("");
$("#select-class").append("<option value='请选择' selected>选择班级</option>");
var str="";
for(var i=0;i<class_array.length;i++)
{
str += "<option value='"+class_array[i]+"'>"+class_array[i]+"</option>";
}
$("#select-class").append(str);
}
function attendance_data() {
var search = $("#menusure span").html(); //获取当前标签值
var obj = document.getElementById("select-class");
var index = obj.selectedIndex;
if (search == "选择日期") {
if (obj.options[index].value!="请选择") {
$.post("phpData/return_rosterDate.php",{search: search, selected_date: obj.options[index].value,userId:<?php echo $_SESSION['userid'];?>,selected_course:obj.options[index].value},function(data){
$("#showTable").empty();
$("#showTable").append(data);
});
}
else{$("#showTable").empty();}
}
else if (search == "选择班级") {
if (obj.options[index].value != "请选择") {
$.post("phpData/return_rosterDate.php",{search: search, selected_course:$("#select_course").val(),userId:<?php echo $_SESSION['userid'];?>,select_class:obj.options[index].value},function(data){
//处理并显示返回来的学生成绩
$("#showTable").empty();
$("#showTable").append(data);
});
}
else{$("#showTable").empty();}
}
else {
}
}
</script>
</html>