<?php
session_start();
include "../config.php";
if(!isset($_SESSION['username'])){
echo "<script type=\"text/javascript\"> window.location.href=\"login.php\" </script>";
}
function tj($s){
global $conn;
$sq=$s;
$re=$conn->query($sq);
$rest=$re->fetch_assoc();
return $rest;
}
$sqlxb="SELECT COUNT(*) as 'twsp' FROM sq where twspqk=1";
$xb=tj($sqlxb);
$sqlld="SELECT COUNT(*) as 'ldsp' FROM sq where ldspqk=1";
$ld=tj($sqlld);
$sqlqb="SELECT COUNT(*) as 'qb' FROM sq where ldspqk=0 and twspqk=0 ";
$qb=tj($sqlqb);
$data1="['团委审批','领导审批','未审批']";
$data2="["."'".$xb['twsp']."'".','."'".$ld['ldsp']."'".','."'".$qb['qb']."'"."]";
$user="SELECT xb,COUNT(*) as zrs FROM yh GROUP BY xb ";
$xb=$conn->query($user);
$arry=array();
while($xbrs=$xb->fetch_assoc()){
$arr=array('value'=>$xbrs['zrs'],'name'=>$xbrs['xb']);
array_push($arry,$arr);
}
//管理员人数统计
$sqladmin="select count(*) as gly from user ";
$gly=tj($sqladmin);
//教师人数统计
$sqlt="select count(*) as js from yh ";
$jsrs=tj($sqlt);
//当日提交申请
$dqrq=date('Ymd',time());
$sqldrtj="select count(*) as drtj from sq where from_unixtime(tjsj,'%Y%m%d')='$dqrq' ";
$drtj=tj($sqldrtj);
//查询当月调课走势图
$yf=date('m',time());
$sqldy="select count(*) as zs ,from_unixtime(tjsj,'%m%d') as rq from sq where from_unixtime(tjsj,'%m')='$yf' group by from_unixtime(tjsj,'%Y%m%d') ";
$redy=$conn->query($sqldy);
$dyrq=array();
$dysl=array();
while($resdy=$redy->fetch_assoc()){
array_push($dysl,$resdy['zs']);
array_push($dyrq,$resdy['rq']);
}
$dx=json_encode($dyrq);
$dy=json_encode($dysl);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>main</title>
<link rel="stylesheet" type="text/css" href="../layui-v2.6.7/layui/css/layui.css"/>
<style type="text/css">
.rs{
font-size;30px;
font-weight: bold;
color: #009688;
}
</style>
<script src="js/echarts.min.js" type="text/javascript" charset="utf-8"></script>
<script src="js/zt.js" type="text/javascript" charset="utf-8"></script>
</head>
<body background="../img/51.JPG">
<div class="layui-row layui-col-space15">
<div class="layui-col-md4" >
<div class="layui-card" style="height: 200px; font-size: 20px;">
<!-- <div class="layui-card-header"><blockquote class="layui-elem-quote" style="color: #00007F;font-size: 15px;font-family: 楷体;">管理员统计</blockquote></div> -->
<div class="layui-card-header" style="color: #00007F;font-size: 25px;font-family: 楷体;text-align: center;"><img src="../img/gl.png" width=50px ; align="center" >管理员统计</div>
<br />
<br />
<div class="layui-card-body"style="text-align: center;">
系统管理员人数为: <span class="rs"><?php echo $gly['gly'];?> </span>人
</div>
</div>
</div>
<div class="layui-col-md4">
<div class="layui-card" style="height: 200px; font-size: 20px;">
<div class="layui-card-header" style="color: #00007F;font-size: 25px;font-family: 楷体;text-align: center;"><img src="../img/yhtj.png" width=50px ; align="center" >用户人数统计</div>
<br />
<br />
<div class="layui-card-body" style="text-align: center;">
用户人数为:<span class="rs"><?php echo $jsrs['js'];?></span> 人
</div>
</div>
</div>
<div class="layui-col-md4">
<div class="layui-card" style="height: 200px; font-size: 20px;">
<div class="layui-card-header"style="color: #00007F;font-size: 25px;font-family: 楷体;text-align: center;"><img src="../img/sqtj.png" width=50px ; align="center" >当日活动申请统计</div>
<br />
<br />
<div class="layui-card-body" style="text-align: center;">
当日提交申请总数为:<span class="rs"><?php echo $drtj['drtj'];?></span> 人
</div>
</div>
</div>
</div>
<div class="layui-row layui-col-space15">
<div class="layui-col-md6">
<div class="layui-card">
<div class="layui-card-header" style="text-align: center;color: #00007F;font-size: 25px;font-family: 楷体;"><img src="../img/tj2.png" width=50px ; align="center" >审批情况统计图</div>
<div class="layui-card-body">
<div id="main" style="width:90%;height:400px;"></div>
<script type="text/javascript">
var myChart = echarts.init(document.getElementById('main'),'walden');
option = {
xAxis: {
type: 'category',
data: <?php echo $data1;?>
},
title:{
show:true,
text:'审批情况对比图',
color: '#33333',
},
grid:{
show:true
},
yAxis: {
type: 'value'
},
series: [{
data: <?php echo $data2;?>,
type: 'bar',
showBackground: true,
backgroundStyle: {
color: 'rgba(220, 220, 220, 0.8)'
},
label:{
show:true,
position:'top',
distance: 5,
//color:"#CD3333"
}
}]
};
myChart.setOption(option);
</script>
</div>
</div>
</div>
<div class="layui-col-md6">
<div class="layui-card">
<div class="layui-card-header" style="text-align: center;color: #00007F;font-size: 25px;font-family: 楷体;"><img src="../img/tj3.png" width=50px ; align="center" >用户性别比例统计图</div>
<div class="layui-card-body">
<div id="bxt" style="width:90%;height:400px;"></div>
<script type="text/javascript">
var myChart = echarts.init(document.getElementById('bxt'),'walden');
var option = {
title: {
text: '人员性别比例',
subtext: '性别',
left: 'center'
},
tooltip: {
trigger: 'item'
},
legend: {
orient: 'vertical',
left: 'left',
},
series: [
{
name: '教师性别',
label:{
show:true
},
type: 'pie',
radius: '50%',
data: <?php echo json_encode($arry); ?>,
emphasis: {
itemStyle: {
shadowBlur: 10,
shadowOffsetX: 0,
shadowColor: 'rgba(0, 0, 0, 0.5)'
}
}
}
]
};
myChart.setOption(option);
</script>
</div>
</div>
</div>
<div class="layui-col-md4">
<div class="layui-card">
<div class="layui-card-header">本月调停课走势图</div>
<div class="layui-card-body">
<div id="zst" style="width:90%;height:400px;"></div>
<script type="text/javascript">
var myChart = echarts.init(document.getElementById('zst'),'walden');
var option = {
title: {
text: '本月调课数量变化',
subtext: '当日调课次数',
left: 'center'
},
xAxis: {
type: 'category',
data: <? echo $dx;?>
},
yAxis: {
type: 'value'
},
series: [{
data: <? echo $dy;?>,
type: 'line',
name: '调课次数',
label:{
show:true
}
}]
};
myChart.setOption(option);
</script>
</div>
</div>
</div>
</div>
</body>
</html>