|
|
<%--
|
|
|
Created by IntelliJ IDEA.
|
|
|
User: 周训凯
|
|
|
Date: 2019/4/24
|
|
|
Time: 23:00
|
|
|
To change this template use File | Settings | File Templates.
|
|
|
--%>
|
|
|
|
|
|
<%@ page contentType="text/html;charset=UTF-8" language="java" import="com.itheima.po.DormClean" %> <!-- 设置页面编码为UTF-8，指定Java语言，并导入DormClean类 -->
|
|
|
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <!-- 引入JSTL核心标签库 -->
|
|
|
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%> <!-- 引入JSTL格式化标签库 -->
|
|
|
|
|
|
<html>
|
|
|
<head>
|
|
|
<title>后台登录</title> <!-- 设置页面标题为“后台登录” -->
|
|
|
<meta name="renderer" content="webkit|ie-comp|ie-stand"> <!-- 设定页面的渲染方式 -->
|
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <!-- 兼容IE浏览器的渲染模式 -->
|
|
|
<meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" /> <!-- 设置视窗适配 -->
|
|
|
<%--<meta http-equiv="Cache-Control" content="no-siteapp" />--%> <!-- 注释掉的Cache控制 -->
|
|
|
|
|
|
<link rel="icon" href="/images/favicon.ico" sizes="32x32" /> <!-- 设置网页的图标 -->
|
|
|
<link rel="stylesheet" href="./css/font.css"> <!-- 引入字体样式 -->
|
|
|
<link rel="stylesheet" href="./css/xadmin.css"> <!-- 引入后台管理系统的CSS样式 -->
|
|
|
<script type="text/javascript" src="./js/jquery-1.3.2.min.js"></script> <!-- 引入jQuery库 -->
|
|
|
<script src="lib/layui/layui.js"></script> <!-- 引入layui框架 -->
|
|
|
<script type="text/javascript" src="./js/xadmin.js"></script> <!-- 引入自定义的后台管理脚本 -->
|
|
|
<script src="/layui_exts/excel.js"></script> <!-- 引入Excel导出扩展脚本 -->
|
|
|
|
|
|
<style type="text/css">
|
|
|
.layui-table{
|
|
|
text-align: center; <!-- 设置表格内容居中 -->
|
|
|
}
|
|
|
.layui-table th{
|
|
|
text-align: center; <!-- 设置表格标题居中 -->
|
|
|
}
|
|
|
</style>
|
|
|
</head>
|
|
|
|
|
|
<body>
|
|
|
<div class="x-nav"> <!-- 顶部导航栏 -->
|
|
|
<span class="layui-breadcrumb">
|
|
|
<a href="">首页</a> <!-- 首页链接 -->
|
|
|
<a href="/findDormClean">宿舍卫生</a> <!-- 宿舍卫生列表链接 -->
|
|
|
</span>
|
|
|
<a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right" href="/findDormClean" title="刷新">
|
|
|
<i class="layui-icon" style="line-height:30px">ဂ</i></a> <!-- 刷新按钮 -->
|
|
|
</div>
|
|
|
|
|
|
<div class="x-body">
|
|
|
<div class="layui-row">
|
|
|
<form class="layui-form layui-col-md12 x-so" action="/findDormClean">
|
|
|
<input class="layui-input" placeholder="请输入宿舍编号" name="d_id" id="d_id"> <!-- 输入框，搜索宿舍编号 -->
|
|
|
<input class="layui-input" placeholder="请输入宿舍楼" name="d_dormbuilding" id="d_dormbuilding"> <!-- 输入框，搜索宿舍楼 -->
|
|
|
|
|
|
<input class="layui-input" type="hidden" name="pageIndex" value="1"> <!-- 隐藏字段，页面索引 -->
|
|
|
<input class="layui-input" type="hidden" name="pageSize" value="3"> <!-- 隐藏字段，页面大小 -->
|
|
|
<button class="layui-btn" lay-submit="" lay-filter="sreach"><i class="layui-icon"></i></button> <!-- 搜索按钮 -->
|
|
|
</form>
|
|
|
</div>
|
|
|
|
|
|
<xblock>
|
|
|
<button id="addStudnetBtn" class="layui-btn layui-btn-normal"> <i class="layui-icon"></i>添加 </button> <!-- 添加按钮 -->
|
|
|
<button class="layui-btn layui-btn-warm" lay-filter="toolbarDemo" lay-submit=""><i class="layui-icon"></i>导出</button> <!-- 导出按钮 -->
|
|
|
<span class="x-right" style="line-height:40px">共有数据：${di.totalCount} 条</span> <!-- 显示总记录数 -->
|
|
|
</xblock>
|
|
|
|
|
|
<%--添加模态框--%>
|
|
|
<div class="layui-row" id="test" style="display: none;">
|
|
|
<div class="layui-col-md10">
|
|
|
<form class="layui-form" id="addEmployeeForm">
|
|
|
<div class="layui-form-item">
|
|
|
<label class="layui-form-label">宿舍编号：</label>
|
|
|
<div class="layui-input-block">
|
|
|
<input type="text" name="d_id" class="layui-input" placeholder="请输入宿舍编号"> <!-- 输入框，宿舍编号 -->
|
|
|
</div>
|
|
|
</div>
|
|
|
|
|
|
<div class="layui-form-item">
|
|
|
<label class="layui-form-label">宿舍楼：</label>
|
|
|
<div class="layui-input-block">
|
|
|
<input type="text" name="d_dormbuilding" class="layui-input" placeholder="请输入宿舍楼"> <!-- 输入框，宿舍楼 -->
|
|
|
</div>
|
|
|
</div>
|
|
|
|
|
|
<div class="layui-form-item">
|
|
|
<label class="layui-form-label">宿舍卫生：</label>
|
|
|
<div class="layui-input-block">
|
|
|
<input type="text" name="d_grade" class="layui-input" placeholder="请输入卫生打分"> <!-- 输入框，卫生打分 -->
|
|
|
</div>
|
|
|
</div>
|
|
|
|
|
|
<div class="layui-form-item">
|
|
|
<div class="layui-input-block">
|
|
|
<button type="button" class="layui-btn layui-btn-normal" lay-submit lay-filter="formDemo">提交</button> <!-- 提交按钮 -->
|
|
|
<button type="reset" class="layui-btn layui-btn-primary">重置</button> <!-- 重置按钮 -->
|
|
|
</div>
|
|
|
</div>
|
|
|
</form>
|
|
|
</div>
|
|
|
</div>
|
|
|
|
|
|
<%--表格数据--%>
|
|
|
<table class="layui-table">
|
|
|
<thead>
|
|
|
<tr>
|
|
|
<%--<th>--%>
|
|
|
<%--<div class="layui-unselect header layui-form-checkbox" lay-skin="primary"><i class="layui-icon"></i></div>--%>
|
|
|
<%--</th>--%>
|
|
|
<th>ID</th> <!-- ID列 -->
|
|
|
<th>宿舍编号</th> <!-- 宿舍编号列 -->
|
|
|
<th>宿舍楼</th> <!-- 宿舍楼列 -->
|
|
|
<th>宿舍卫生</th> <!-- 卫生打分列 -->
|
|
|
<th>创建日期</th> <!-- 创建日期列 -->
|
|
|
<th>更新日期</th> <!-- 更新日期列 -->
|
|
|
<th>操作</th> <!-- 操作列 -->
|
|
|
</thead>
|
|
|
<tbody>
|
|
|
<c:forEach items="${di.list}" var="di">
|
|
|
<tr>
|
|
|
<td>${di.g_id}</td> <!-- 显示ID -->
|
|
|
<td>${di.d_id}</td> <!-- 显示宿舍编号 -->
|
|
|
<td>${di.d_dormbuilding}</td> <!-- 显示宿舍楼 -->
|
|
|
<td>${di.d_grade}</td> <!-- 显示卫生打分 -->
|
|
|
<td><fmt:formatDate pattern="yyyy-MM-dd HH:mm:ss" value="${di.create_time}"/></td> <!-- 格式化创建时间 -->
|
|
|
<td><fmt:formatDate pattern="yyyy-MM-dd HH:mm:ss" value="${di.update_time}"/></td> <!-- 格式化更新时间 -->
|
|
|
<td>
|
|
|
<a title="编辑" id="updateEdit" href="/findDormCleanById?g_id=${di.g_id}">
|
|
|
<i class="layui-icon"></i>
|
|
|
</a>
|
|
|
<a title="删除" onclick="member_del(this,'${di.g_id}')" href="javascript:;">
|
|
|
<i class="layui-icon"></i>
|
|
|
</a>
|
|
|
</td>
|
|
|
</tr>
|
|
|
</c:forEach>
|
|
|
</tbody>
|
|
|
</table>
|
|
|
|
|
|
<div class="">
|
|
|
<input type="hidden" id="totalPageCount" value="${di.pageTotalCount}"/> <!-- 隐藏字段，表示总页数 -->
|
|
|
<c:import url="pageBtn.jsp">
|
|
|
<c:param name="totalCount" value="${di.totalCount}"/>
|
|
|
<c:param name="currentPageNo" value="${di.pageIndex}"/>
|
|
|
<c:param name="totalPageCount" value="${di.pageTotalCount}"/>
|
|
|
</c:import>
|
|
|
</div>
|
|
|
|
|
|
<script>
|
|
|
// layui 配置并导入 excel 扩展
|
|
|
layui.config({
|
|
|
base: 'layui_exts/',
|
|
|
}).extend({
|
|
|
excel: 'excel',
|
|
|
});
|
|
|
|
|
|
layui.use(['jquery', 'excel','form','layer','laydate'], function(){
|
|
|
var form = layui.form,
|
|
|
$ = layui.jquery,
|
|
|
laydate = layui.laydate;
|
|
|
var excel = parent.layui.excel;
|
|
|
|
|
|
// 使用 layui 的日期控件
|
|
|
laydate.render({
|
|
|
elem: '#start' //指定元素
|
|
|
});
|
|
|
|
|
|
form.on('submit(toolbarDemo)', function(){
|
|
|
$.ajax({
|
|
|
url: '/exportdormcleanlist',
|
|
|
type: 'post',
|
|
|
dataType: 'json',
|
|
|
contentType: "application/json; charset=utf-8",
|
|
|
success: function (data) {
|
|
|
console.log(data);
|
|
|
|
|
|
// 1. 数据处理：如果需要调整顺序，使用 excel.filterExportData 函数
|
|
|
var dt = excel.filterExportData(data, [
|
|
|
'g_id'
|
|
|
,'d_id'
|
|
|
,'d_dormbuilding'
|
|
|
,'d_grade'
|
|
|
,'create_time'
|
|
|
,'update_time'
|
|
|
]);
|
|
|
|
|
|
// 2. 数组头部新增表头
|
|
|
dt.unshift({g_id: 'ID', d_id: '宿舍编号', d_dormbuilding: '宿舍楼', d_grade: '宿舍卫生', create_time: '创建日期', update_time: '更新日期'});
|
|
|
|
|
|
// 配置列宽
|
|
|
var colConf = excel.makeColConfig({
|
|
|
'E': 160,
|
|
|
'F': 160
|
|
|
}, 60);
|
|
|
|
|
|
var timestart = Date.now();
|
|
|
// 3. 执行导出
|
|
|
excel.exportExcel({
|
|
|
sheet1: dt
|
|
|
}, '宿舍卫生数据.xlsx', 'xlsx', {
|
|
|
extend: {
|
|
|
'!cols': colConf
|
|
|
}
|
|
|
});
|
|
|
|
|
|
var timeend = Date.now();
|
|
|
var spent = (timeend - timestart) / 1000;
|
|
|
layer.alert('导出耗时 '+spent+' s');
|
|
|
},
|
|
|
|
|
|
error: function () {
|
|
|
setTimeout(function () {window.location.href='/findDormClean';},2000);
|
|
|
}
|
|
|
});
|
|
|
});
|
|
|
|
|
|
/*添加弹出框*/
|
|
|
$("#addStudnetBtn").click(function () {
|
|
|
layer.open({
|
|
|
type:1,
|
|
|
title:"添加班级",
|
|
|
skin:"myclass",
|
|
|
area:["50%"],
|
|
|
anim:2,
|
|
|
content:$("#test").html()
|
|
|
});
|
|
|
$("#addEmployee
|
