You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

492 lines
29 KiB

3 months ago
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<link rel="stylesheet" href="../../../component/layui/css/layui.css" />
<link rel="stylesheet" href="../../../component/pear/css/module/toast.css" />
<style>
th {
color: #303133;
background-color: #f5f7fa;
}
.layui-card {
box-shadow: 0 0 0 0 rgba(0, 0, 0, 0) !important;
margin-bottom: 0 !important;
}
.layui-form-item {
margin-bottom: 0;
}
.layui-table td,
.layui-table th {
font-size: 12px;
}
.bp {
background-color: rgba(23, 179, 163, .1);
padding: 5px 10px;
height: 32px;
line-height: 30px;
font-size: 12px;
color: #17b3a3;
border-radius: 4px;
-webkit-box-sizing: border-box;
box-sizing: border-box;
border: 1px solid rgba(23, 179, 163, .2);
white-space: nowrap;
}
.xp {
background-color: rgba(144, 147, 153, .1);
padding: 5px 10px;
height: 32px;
line-height: 30px;
font-size: 12px;
color: #909399;
border-radius: 4px;
-webkit-box-sizing: border-box;
box-sizing: border-box;
border: 1px solid rgba(144, 147, 153, .2);
white-space: nowrap;
}
</style>
</head>
<body class="layui-form">
<div class="layui-card">
<div class="layui-card-body">
<div class="layui-form-item layui-inline">
<label class="layui-form-label" style="width: auto;">行政区划:</label>
<div class="layui-input-inline" id="xzqhView"></div>
<script id="xzqhScript" type="text/html">
<select id="xzqhId" lay-filter="xzqh">
<option value="">全部</option>
{{# layui.each(d, function(index, item){ }}
<option value="{{item.id}}">{{item.area_name}}</option>
{{# }); }}
</select>
</script>
</div>
<div class="layui-form-item layui-inline">
<label class="layui-form-label" style="width: auto;">学校类型:</label>
<div class="layui-input-inline" id="xxlxView"></div>
<script id="xxlxScript" type="text/html">
<select id="xxlxId" lay-filter="xxlx">
<option value="0">全部</option>
{{# layui.each(d, function(index, item){ }}
<option value="{{item.school_type_id}}">{{item.school_type_name}}</option>
{{# }); }}
</select>
</script>
</div>
<div class="layui-form-item layui-inline">
<label class="layui-form-label" style="width: auto;">分类:</label>
<div class="layui-input-inline">
<select id="flId" lay-filter="fl">
<option value="1">基础环境</option>
<option value="2">数字终端</option>
<option value="3">多媒体班级教室设备</option>
<option value="4">多功能教室、录播室等设备</option>
<option value="5">校园广播设备</option>
<option value="6">虚拟演播室设备</option>
<option value="7">校园电视系统等设备</option>
<option value="8">网络安全</option>
</select>
</div>
</div>
<div class="layui-form-item layui-inline">
<label class="layui-form-label" style="width: auto;">学校名称:</label>
<div class="layui-input-inline">
<input type="text" lay-affix="clear" id="xxmc" placeholder="请输入学校名称" class="layui-input">
</div>
</div>
<div class="layui-form-item layui-inline">
<button class="layui-btn layui-btn-sm" lay-submit lay-filter="user-query">
<i class="layui-icon layui-icon-search"></i>
查询
</button>
</div>
<button class="layui-btn layui-btn-sm layui-bg-orange" lay-submit lay-filter="export"
style="position: fixed;right: 20px;top:15px">
<i class="layui-icon layui-icon-download-circle"></i>
导出
</button>
<table class="layui-table" id="myTable"></table>
</div>
</div>
<script src="../../../component/layui/layui.js"></script>
<script src="../../../component/pear/xm-select.js"></script>
<script>
layui.use(function () {
var $ = layui.jquery;
var table = layui.table;
var toast = layui.toast;
var form = layui.form;
var laytpl = layui.laytpl;
$.ajax({
type: "GET",
async: false,
3 months ago
url: "/dsBase/zbdc/getXzqhList",
3 months ago
success: function (res) {
var xzqhTpl = xzqhScript.innerHTML,
xzqhView = document.getElementById('xzqhView');
laytpl(xzqhTpl).render(res.data, function (html) {
xzqhView.innerHTML = html;
});
form.render();
}
});
$.ajax({
type: "GET",
async: false,
3 months ago
url: "/dsBase/zbdc/getCurrentPersonAreaInfo",
3 months ago
success: function (res) {
if (res.shi_master != 1) {
$("#xzqhId").val(res.area_id);
$("#xzqhId").prop('disabled', true);
}
}
});
$.ajax({
type: "GET",
async: false,
3 months ago
url: "/dsBase/zbdc/getQuerySchoolType",
3 months ago
success: function (res) {
var xxlxTpl = xxlxScript.innerHTML,
xxlxView = document.getElementById('xxlxView');
laytpl(xxlxTpl).render(res.data, function (html) {
xxlxView.innerHTML = html;
});
form.render();
}
});
tableRender();
function tableRender() {
var customCols;
switch ($("#flId").val()) {
case '1':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 3 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '网络带宽MB', field: 'wangluodaikuan', align: 'center', width: "135", rowspan: 2 },
{ title: '网络服务供应商', field: 'wangluofuwushang', align: 'center', width: "135", rowspan: 2 },
],
[
{ title: '具体装备情况', field: 'jtzbqk', align: 'center', width: "115" },
{ title: '台数', field: 'taishu', align: 'center', width: "60" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" },
]
];
break;
case '2':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 3 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '配置(如计算机请标明:处理器/内存/硬盘/显示器等)', field: 'peizhi', align: 'center', width: "305" },
{ title: '台数', field: 'taishu', align: 'center', width: "60" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '3':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 3 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '配置(如交互式白板标明尺寸,如计算机标明处理器/内存/硬盘等)', field: 'peizhi', align: 'center', width: "360" },
{ title: '台数', field: 'taishu', align: 'center', width: "60" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '4':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 4 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '主要设备情况(如尺寸等)', field: 'zhuyaoshebeiqingkuang', align: 'center', width: "175" },
{ title: '数量', field: 'shuliang', align: 'center', width: "60" },
{ title: '座位数', field: 'zuoweishu', align: 'center', width: "80" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '5':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 5 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '教室内音箱(对)', field: 'jsnyxs', align: 'center', width: "125" },
{ title: '走廊音箱(只)', field: 'zlyxs', align: 'center', width: "115" },
{ title: '室外音柱(个)', field: 'swyzs', align: 'center', width: "115" },
{ title: '合计点数', field: 'jsds', align: 'center', width: "115" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '6':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 8 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '摄像机数量', field: 'sxjs', align: 'center', width: "100" },
{ title: '提词器', field: 'tcqs', align: 'center', width: "80" },
{ title: '效果监视屏', field: 'xgjsps', align: 'center', width: "100" },
{ title: '计算机数量', field: 'jsjs', align: 'center', width: "100" },
{ title: '非编', field: 'fbs', align: 'center', width: "75" },
{ title: '蓝箱系统', field: 'xinghao', field: 'lxxts', align: 'center', width: "110" },
{ title: '面积(平方米)', field: 'mj', align: 'center', width: "110" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '7':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "60", type: 'numbers', rowspan: 2 },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '类别', field: 'lb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '主要设备', field: 'lb_sb_name', align: 'center', width: "160", rowspan: 2 },
{ title: '品牌', field: 'pinpai', align: 'center', width: "110", rowspan: 2 },
{ title: '型号', field: 'xinghao', align: 'center', width: "110", rowspan: 2 },
{ title: '现状', align: 'center', colspan: 3 },
{ title: '工作状态', align: 'center', colspan: 6 },
{ title: '备注', field: 'beizhu', align: 'center', width: "135", rowspan: 2 }
],
[
{ title: '主要设备情况', field: 'zysbqk', align: 'center', width: "150" },
{ title: '面积(平方米)', field: 'mj', align: 'center', width: "110" },
{ title: '启用日期', field: 'qiyongriqi', align: 'center', width: "110" },
{ title: '正常使用(台)', field: 'zhengchang', align: 'center', width: "110" },
{ title: '待修(台)', field: 'daixiu', align: 'center', width: "90" },
{ title: '在修(台)', field: 'zaixiu', align: 'center', width: "90" },
{ title: '闲置(台)', field: 'xianzhi', align: 'center', width: "90" },
{ title: '其他(台)', field: 'qita', align: 'center', width: "90" },
{ title: '其它(说明原因)', field: 'yuanyin', align: 'center', width: "125" }
]
];
break;
case '8':
customCols = [
[
{ title: '序号', fixed: 'left', align: 'center', width: "5%", type: 'numbers' },
{ title: '行政区域', fixed: 'left', field: 'area_name', align: 'center', width: "150", rowspan: 2 },
{ title: '学校名称', fixed: 'left', field: 'bureau_name', align: 'center', width: "300", rowspan: 2 },
{ title: '学校类型', field: 'school_type_name', align: 'center', width: "125", rowspan: 2 },
{ title: '互联网带宽(MB)', field: 'hlwdk', align: 'center', width: "150" },
{ title: '接入IP', field: 'jrip', align: 'center', width: "100" },
{ title: '服务商(联通,电信,移动等)', field: 'wfs', align: 'center', width: "180" },
{ title: '合同年均费用(万元)', field: 'htnjfy', align: 'center', width: "150" },
{ title: '合同服务期', field: 'htfwq', align: 'center', width: "100" },
{ title: '班级数', field: 'bjs', align: 'center', width: "100" },
{ title: '是否有防火墙', field: 'fhq', align: 'center', width: "125", },
{ title: '内部主干网络是否为光纤', field: 'zgwgx', align: 'center', width: "165" }
//{ title: '带宽(MB)', field: 'dk', align: 'center', width: "100" }
]
];
break;
}
table.render({
elem: '#myTable',
3 months ago
url: '/dsBase/zbdc/getQueryXxhsb',
3 months ago
where: {
area_id: $("#xzqhId").val(),
school_type_id: $("#xxlxId").val(),
dcb_id: $("#flId").val(),
keyword: $("#xxmc").val()
},
cellExpandedMode: "tips",
height: 'full-70',
page: {
limit: 15
, layout: ['count', 'prev', 'page', 'next', 'skip']
, prev: "上一页"
, next: "下一页"
},
cols:
customCols
,
// skin: 'line',
defaultToolbar: []
});
}
form.on('submit(export)', function () {
3 months ago
var url = "/dsBase/zbdc/getQueryXxhsb?export_flag=1&page=1&limit=50000&dcb_id=" + $("#flId").val() + "&area_id=" + $("#xzqhId").val() + "&school_type_id=" + $("#xxlxId").val() + "&keyword=" + $("#xxmc").val();
3 months ago
window.location.href = url;
// 阻止表单的默认提交行为
return false;
});
form.on('submit(user-query)', function () {
tableRender()
// 阻止表单的默认提交行为
return false;
});
form.on('select(xzqh)', function () {
tableRender();
// 阻止表单的默认提交行为
return false;
});
form.on('select(fl)', function () {
tableRender();
// 阻止表单的默认提交行为
return false;
});
form.on('select(xxlx)', function () {
tableRender();
// 阻止表单的默认提交行为
return false;
});
});
</script>
</body>
</html>