272 lines
11 KiB
JavaScript
272 lines
11 KiB
JavaScript
import {boroughList, layuiObj,schoolBasicInfo } from "../index.js";
|
||
import { schoolStarRatingHistoryGetlist } from "../orgApi/starRatingHistoryData.js";
|
||
import { getYearOption } from "../centerPage.js";
|
||
let starRatingHistoryList=[];
|
||
function showStarRatingHistoryData(){
|
||
layuiObj.layer.open({
|
||
type: 1,
|
||
title: '星级评定-历史数据', //不显示标题栏
|
||
area: ['1360px', '600px'],
|
||
shade: 0.6,
|
||
id:new Date().getTime(), //设定一个id，防止重复弹出
|
||
btnAlign: 'c',
|
||
moveType: 1, //拖拽模式，0或者1
|
||
content: `<div style="padding:10px;color:#fff;background:#032357;height:calc(100% - 20px);overflow-y:auto;">
|
||
<div class="legalitySchoolInfo">
|
||
<form class="layui-form" action="" id="legalitySchoolForm" lay-filter="legalitySchoolForm" >
|
||
<div class="layui-input-inline">
|
||
<select name="interest" lay-filter="historyYearSelect" id="historyYearSelect" lay-search></select>
|
||
</div>
|
||
<div class="layui-input-inline">
|
||
<select name="interest" lay-filter="historyBoroughSelect" id="historyBoroughSelect" lay-search></select>
|
||
</div>
|
||
<div class="layui-input-inline">
|
||
<select name="interest" lay-filter="historyStationSelect" id="historyStationSelect" lay-search></select>
|
||
</div>
|
||
<div class="layui-input-inline">
|
||
<button class="layui-btn" id="starRatingHistoryBtn" style="height:38px !important;line-height:38px !important;">查询</button>
|
||
</div>
|
||
<div class="layui-input-inline">
|
||
<button class="layui-btn" id="starRatingHistoryExportBtn" style="height:38px !important;line-height:38px !important;display:none">导出</button>
|
||
</div>
|
||
</form>
|
||
</div>
|
||
<div class="staffSignSelectContent">
|
||
<table class="layui-hide" id="starRatingHistoryDataTable" lay-filter="starRatingHistoryDataTable"></table>
|
||
</div>
|
||
</div>`,
|
||
success: function(layero){
|
||
$("#historyYearSelect").html(getYearOption());
|
||
$("#historyBoroughSelect").html(starRatingBoroughSelectOptions());
|
||
$("#historyStationSelect").html(starRatingStationSelectOptions(schoolBasicInfo));
|
||
layuiObj.layuiForm.render("select","legalitySchoolForm")
|
||
addStarRatingHistoryDataEvent();
|
||
var year=$("#historyYearSelect").find("option:selected").val();
|
||
var obj={
|
||
schoolTime:year
|
||
}
|
||
selectYearStarRatingData(obj)
|
||
boroughOptionsChange();
|
||
}
|
||
});
|
||
}
|
||
|
||
//监听borough的改变
|
||
function boroughOptionsChange(){
|
||
layuiObj.layuiForm.on('select(historyBoroughSelect)', function(data){
|
||
var value=data["value"];
|
||
if(value=="000"){
|
||
$("#historyStationSelect").html(starRatingStationSelectOptions(schoolBasicInfo));
|
||
}else{
|
||
var temp=[];
|
||
for(var i=0;i<schoolBasicInfo.length;i++){
|
||
if(value==schoolBasicInfo[i]["borough"]){
|
||
temp.push(schoolBasicInfo[i]);
|
||
}
|
||
}
|
||
$("#historyStationSelect").html(starRatingStationSelectOptions(temp));
|
||
}
|
||
layuiObj.layuiForm.render("select","legalitySchoolForm")
|
||
})
|
||
}
|
||
|
||
function starRatingBoroughSelectOptions(){
|
||
var options=`<option value="000">请选择派出所</option>`;
|
||
for(var i=0;i<boroughList.length;i++){
|
||
var borough=boroughList[i]["borough"]
|
||
options+=`<option value="${borough}">${borough}</option>`;
|
||
}
|
||
return options;
|
||
}
|
||
|
||
function starRatingStationSelectOptions(list){
|
||
var options=`<option value="000">请选择学校</option>`;
|
||
for(var i=0;i<list.length;i++){
|
||
var name=list[i]["name"]
|
||
options+=`<option value="${name}" >${name}</option>`;
|
||
}
|
||
return options;
|
||
}
|
||
|
||
|
||
function addStarRatingHistoryDataEvent(){
|
||
$("#starRatingHistoryBtn").on('click',function(e){
|
||
e.preventDefault();
|
||
var year=$("#historyYearSelect").find("option:selected").val();
|
||
var borough=$("#historyBoroughSelect").find("option:selected").val();
|
||
var station=$("#historyStationSelect").find("option:selected").val();
|
||
var obj={
|
||
schoolTime:year
|
||
}
|
||
if(borough!="000"){
|
||
obj["borough"]=borough
|
||
}
|
||
if(station!="000"){
|
||
obj["station"]=station
|
||
}
|
||
selectYearStarRatingData(obj)
|
||
})
|
||
$("#starRatingHistoryExportBtn").on('click',function(e){
|
||
e.preventDefault();
|
||
export2TroubleExcel();
|
||
})
|
||
}
|
||
|
||
function export2TroubleExcel() {
|
||
var tableName=$("#historyYearSelect").find("option:selected").val()+"校园星级评定数据统计表"
|
||
// 添加表头信息
|
||
let thead = `
|
||
<thead>
|
||
<tr style="font-size:22px;">
|
||
<td colspan="9" style="text-align:center;">校园星级评定数据统计表</td>
|
||
</tr>
|
||
<tr style="font-size:16px;">
|
||
<th>序号</th>
|
||
<th>所属派出所</th>
|
||
<th>校园名称</th>
|
||
<th>自评扣分</th>
|
||
<th>得分</th>
|
||
<th>自评加分</th>
|
||
<th>分局评定扣分</th>
|
||
<th>分局评定加分</th>
|
||
<th>最终得分</th>
|
||
</tr>
|
||
</thead>`;
|
||
var tr=``;
|
||
for(var i=0;i<starRatingHistoryList.length;i++){
|
||
tr+=`<tr style="font-size:16px;" rowspan="2">
|
||
<td>${i+1}</td>
|
||
<td>${starRatingHistoryList[i]["borough"]}</td>
|
||
<td>${starRatingHistoryList[i]["station"]}</td>
|
||
<td>${starRatingHistoryList[i]["ratingBonusStation"]}</td>
|
||
<td
|
||
style="
|
||
background:#fff;
|
||
border:0.5px solid #C3CBDD;
|
||
text-align:center;
|
||
">
|
||
${getStationLevel(starRatingHistoryList[i])}
|
||
</td>
|
||
<td>${starRatingHistoryList[i]["ratingBonusStation"]}</td>
|
||
<td>${starRatingHistoryList[i]["ratingDescriptionBrigade"]}</td>
|
||
<td>${starRatingHistoryList[i]["ratingBonusBrigade"]}</td>
|
||
<td
|
||
style="
|
||
background:#fff;
|
||
border:0.5px solid #C3CBDD;
|
||
text-align:center;
|
||
">${getBrigadeLevel(starRatingHistoryList[i])}</td>
|
||
</tr>`
|
||
}
|
||
// 添加每一行数据
|
||
let tbody = `<tbody>${tr}</tbody>`;
|
||
let table = thead + tbody;
|
||
// 导出表格
|
||
exportToExcel(table,tableName);
|
||
};
|
||
|
||
function selectYearStarRatingData(obj){
|
||
starRatingHistoryList=[];
|
||
schoolStarRatingHistoryGetlist(obj).then(res=>{
|
||
var code=res["data"]["code"];
|
||
if(code==0){
|
||
var data=res["data"]["data"];
|
||
for(var i=0;i<data.length;i++){
|
||
data[i]["index"]=i+1;
|
||
data[i]["scoreTotalBrigade"]=data[i]["scoreTotalBrigade"]/10
|
||
data[i]["ratingBonusBrigade"]=data[i]["ratingBonusBrigade"]/10
|
||
data[i]["ratingBonusStation"]=data[i]["ratingBonusStation"]/10
|
||
data[i]["scoreTotalStation"]=data[i]["scoreTotalStation"]/10
|
||
}
|
||
starRatingHistoryList=data;
|
||
}
|
||
|
||
if(starRatingHistoryList.length==0){
|
||
$("#starRatingHistoryExportBtn").css("display","none");
|
||
}else{
|
||
$("#starRatingHistoryExportBtn").css("display","block");
|
||
}
|
||
showStarRatingHistoryTable();
|
||
})
|
||
}
|
||
|
||
function showStarRatingHistoryTable(){
|
||
layuiObj.layuitable.render({
|
||
elem:'#starRatingHistoryDataTable',
|
||
data:starRatingHistoryList,
|
||
cols:[[
|
||
{field:'index', width:"5%", title: '序号'},
|
||
{field:'borough', width:"15%", title: '所属派出所'},
|
||
{field:'station', width:"10%", title: '校园名称'},
|
||
{field:'ratingDescriptionStation', width:"15%", title: '自评扣分',type:"scoreTotal"},
|
||
{field:'scoreTotalStation', width:"10%", title: '得分',type:"scoreDesire",templet:function(data) {// 替换数据
|
||
return getStationLevel(data)
|
||
}},
|
||
{field:'ratingBonusStation', width:"10%", title: '自评加分',type:"scoreHuman"},
|
||
{field:'ratingDescriptionBrigade', width:"15%", title: '分局评定扣分',type:"scoreDevices"},
|
||
{field:'ratingBonusBrigade', width:"10%", title: '分局评定加分',type:"scoreTech"},
|
||
{field:'scoreTotalBrigade', width:"10%", title: '最终得分',type:"scoreDesire",templet:function(data) {// 替换数据
|
||
return getBrigadeLevel(data)
|
||
}},
|
||
|
||
]],
|
||
limit:Number.MAX_VALUE // 数据表格默认全部显示
|
||
});
|
||
}
|
||
|
||
function getStationLevel(data){
|
||
var levelStation=parseInt(data["levelStation"]);
|
||
switch(levelStation){
|
||
case 1:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(一星)</p>`;
|
||
break;
|
||
case 2:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(二星)</p>`;
|
||
break;
|
||
case 3:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(三星)</p>`;
|
||
break;
|
||
case 4:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(四星)</p>`;
|
||
break;
|
||
case 5:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(五星)</p>`;
|
||
break;
|
||
default:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalStation"]}<br/>(五星)<p/>`;
|
||
break;
|
||
}
|
||
return span;
|
||
}
|
||
|
||
function getBrigadeLevel(data){
|
||
var levelBrigade=parseInt(data["levelBrigade"]);
|
||
switch(levelBrigade){
|
||
case 1:
|
||
var span=`<p style="line-height:27px; ">${data["scoreTotalBrigade"]}<br/>(一星)</p>`;
|
||
break;
|
||
case 2:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalBrigade"]}<br/>(二星)</p>`;
|
||
break;
|
||
case 3:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalBrigade"]}<br/>(三星)</p>`;
|
||
break;
|
||
case 4:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalBrigade"]}<br/>(四星)</p>`;
|
||
break;
|
||
case 5:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalBrigade"]}<br/>(五星)</p>`;
|
||
break;
|
||
default:
|
||
var span=`<p style="line-height:27px;">${data["scoreTotalBrigade"]}<br/>(五星)</p>`;
|
||
break;
|
||
}
|
||
return span;
|
||
}
|
||
|
||
|
||
|
||
export {
|
||
showStarRatingHistoryData,
|
||
}
|