<%@ page contentType="text/html;charset=UTF-8"%>
|
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
|
<c:set var="ctx" value="${pageContext.request.contextPath}" />
|
|
<html>
|
<head>
|
<script src="tb.js"></script>
|
<script src="jq.js"></script>
|
<script src="${ctx}/static/js/ng/tb.js" type="text/javascript"></script>
|
|
<style>
|
.table>tbody>tr>td {
|
vertical-align: middle;
|
/* content:middle; */
|
text-align: center;
|
font-weight: bold;
|
font-size: 16px;
|
/* border: 1px solid green; */
|
}
|
|
.table>thead>tr>th {
|
font-weight: bold;
|
font-size: 20px;
|
text-align: center;
|
}
|
|
h1 {
|
display: inline;
|
}
|
|
.s-style {
|
font-size: 18px;
|
font-weight: bold;
|
}
|
|
.s-title {
|
font-size: 18px;
|
/*font-weight: bold;
|
text-align :center; */
|
vertical-align: middle;
|
text-align: center
|
}
|
|
.sel-style {
|
width: 200px;
|
font-size: 20px;
|
}
|
|
.span-data {
|
font-weight: bold;
|
color: red;
|
}
|
</style>
|
|
<script>
|
var rTime = 500000;//自动刷新间隔时间 单位：毫秒
|
var rf_url = "/gmms2/mesview/data/_reportform_manage";
|
var p_url = "/gmms2/mesview/data/_public_manage";
|
|
<%String group = request.getParameter("group");
|
String gongyi = request.getParameter("gongyi");
|
String reportFName = request.getParameter("rfName");%>
|
var group = "<%=group%>";
|
var gongyi = "<%=gongyi%>";
|
var rfName ="<%=reportFName%>";
|
var isChaXun = false;//是否查询
|
var total_num = 0;
|
</script>
|
|
<title>报表</title>
|
</head>
|
<body>
|
<div class="content-wrapper">
|
<!-- <div>
|
<section class="content-header">
|
<h1>
|
<span id="h1_content"> </span> <span
|
style="font-size: 20px">共</span> <span id="ps_info"></span>
|
<span style="font-size: 20px">条数据</span>
|
</h1>
|
|
<ol class="breadcrumb">
|
<li></li>
|
<li class="active"></li>
|
</ol>
|
</section>
|
</div> -->
|
|
<!-- 理片任务信息 -->
|
<div style="">
|
<section class="content container-fluid">
|
<h3 id="rf_title">报表</h3>
|
<span id="rf_total"></span>
|
<div class="box" id="rf_condition">
|
<div class="box-header">
|
<h4>
|
<span class="s-title">开始时间</span> <input type="date"
|
id="starttime" class="mdate" name="starttime" /> <span class="s-title">结束时间</span>
|
<input type="date" id="endtime" class="mdate" name="endtime" /> <span
|
class="s-title">选择班组</span> <select id="rf_banzu"
|
class="span_tasktext">
|
<option value="0">全部班组</option>
|
</select> <span class="s-title">生产线</span> <select id="rf_chanxian"
|
class="span_tasktext">
|
<option value="0">全部生产线</option>
|
</select>
|
|
|
<!-- <input type="checkbox" data-group-cls="btn-group-sm"> -->
|
<span id="pc_c"><input type="checkbox" style="width:20px;height:20px" id="pc_isShow"> 显示批次 </span>
|
|
|
<span id="fz_c"><input type="checkbox" style="width:20px;height:20px" id="fz_isShow"> 汇总 </span>
|
|
|
|
|
<button id='' type='button' data-toggle='popover' data-content=''
|
data-trigger='hover' class="btn btn-sm btn-success"
|
onclick="ChaXun()">查询</button>
|
|
<button id="ms_baipian" class="btn btn-sm btn-success"
|
type='button' onclick="ExportTable();">导出表格</button>
|
</h4>
|
</div>
|
|
<p style="font-size: 20px" id="p_total">
|
查询数据总览： 【共 <span id="rNum" class="span-data"></span> 条数据】
|
【破损数量：<span id="noNum" class="span-data"></span>】【破损面积：<span
|
id="noMJ" class="span-data"></span> ㎡】 【完成数量：<span id="okNum"
|
class="span-data"></span>】【完成面积：<span id="okMJ"
|
class="span-data"></span> ㎡】
|
</p>
|
|
<p style="font-size: 20px;" id="ljg_total">
|
查询数据总览： 【共 <span id="rRow" class="span-data"></span> 条数据】
|
【总数量：<span id="rSL" class="span-data"></span>】
|
【总面积：<span id="rMJ" class="span-data"></span> ㎡】
|
</p>
|
|
</div>
|
|
|
<!-- /.box-header -->
|
|
<!-- style="height:10%;width:100%;overflow:auto" -->
|
|
</div>
|
<div class="box-body no-padding" id="glass-data" style="overflow-y:scroll"></div>
|
</section>
|
</div>
|
|
<%@ include file="/WEB-INF/views/mes/view/modal_tishi.jsp"%>
|
</div>
|
<!-- /.content-wrapper -->
|
<!-- 希望每次打开都要默认为今天日期+00:00 -->
|
<script>
|
//默认时间
|
var myDate = new Date(), Y = myDate.getFullYear(), M = myDate.getMonth() + 1, D = myDate.getDate();
|
//处理月是一位的情况
|
if((M + '').length == 1){
|
M = '0' + (M + '');
|
}
|
//处理日是一位的情况
|
if((D + '').length == 1){
|
D = '0' + (D + '')
|
}
|
var curDay = Y + '-' + M + '-' + D;
|
console.log(curDay);
|
$('.mdate').val(curDay);
|
</script>
|
|
|
<!-- 初始化班组，线别 -->
|
<script>
|
function initPage() {
|
var html = " <option selected=\"selected\" value='0'>全部产线</option>";
|
$("#rf_chanxian").empty();
|
var num = 1;
|
|
if(rfName =="切割明细"){
|
gongyi="冷加工";
|
}
|
|
html += " <option value='1' >" + gongyi + " 1 线</option>";
|
html += " <option value='2' >" + gongyi + " 2 线</option>";
|
if (gongyi == "钢化") {
|
|
} else if (gongyi == "中空") {
|
html += " <option value='3' >" + gongyi + " 3 线</option>";
|
html += " <option value='4' >" + gongyi + " 4 线</option>";
|
} else if (gongyi == "冷加工") {
|
html += " <option value='3' >" + gongyi + " 3 线</option>";
|
html += " <option value='4' >" + gongyi + " 4 线</option>";
|
}
|
document.getElementById("rf_chanxian").innerHTML += html;
|
|
}
|
|
|
function initBanZu() {
|
var gy = gongyi;
|
if (gongyi == "冷加工") {
|
gy = "磨边";
|
}
|
|
if(rfName=="切割明细"){
|
gy="磨边";
|
}
|
|
$.ajax({
|
type : "post",
|
data : {
|
caozuo : "查询",
|
leixing : "班组列表",
|
gongyi : gy,
|
line : group
|
},
|
dataType : "json",
|
url : p_url,
|
success : function(data) {
|
d = data;
|
var html = " <option selected=\"selected\" value='0'>全部班组</option>";
|
$("#rf_banzu").empty();
|
for (var i = 0; i < d.length; i++) {
|
html += " <option value="+d[i][0]+">"
|
+ d[i][0] + "</option>";
|
}
|
document.getElementById("rf_banzu").innerHTML += html;
|
|
//AddBPShow(2,isshow);
|
|
},
|
error : function(data) {
|
|
}
|
});
|
}
|
|
</script>
|
|
<!-- 冷加工\钢化 表内容显示 -->
|
<script>
|
var opt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [
|
|
{
|
name : "序号",
|
binding : 0,
|
type : "element",
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
filter : {}
|
|
}, {
|
name : "班组",
|
binding : 1,
|
//style : "display:none;",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "线别",
|
binding : 2,
|
//type : "element",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "流程卡号",
|
binding : 3,
|
filter : {}
|
}, {
|
|
name : "破损数",
|
binding : 4,
|
type : "element",
|
filter : {}
|
}, {
|
|
name : "破损面积",
|
binding : 5,
|
filter : {}
|
}, {
|
|
name : "完成数",
|
binding : 6,
|
//type : "element",
|
filter : {}
|
}, {
|
|
name : "完成面积",
|
binding : 7,
|
type : "element",
|
filter : {}
|
}, {
|
|
name : "膜系",
|
binding : 8,
|
type : "element",
|
filter : {}
|
}, {
|
|
name : "完成时间",
|
binding : 9,
|
type : "element",
|
filter : {}
|
} ]
|
};
|
//创建表
|
|
var a = true;
|
var t = false;
|
|
|
//加载表格内容
|
function loadTable() {
|
|
var stime = $("#starttime").val();
|
if (stime == "" || stime == null) {
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("查询:");
|
$("#cz_Zhuangtai").html("查询失败");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("请选择或输入开始时间！");
|
return;
|
|
}
|
/* alert(stime);
|
return; */
|
var etime = $("#endtime").val();
|
var gy = gongyi;
|
if (gongyi == "冷加工") {
|
gy = "磨边";
|
}
|
var chanxian = $("#rf_chanxian").val();
|
var banzu = $("#rf_banzu").val();
|
/*
|
|
alert(stime+"\r\n"+etime+"\r\n"+gy+"\r\n"+chanxian+"\r\n"+banzu)
|
;return; */
|
$.ajax({
|
type : "post",
|
data : {
|
gongyi : gy,
|
banzu : banzu,
|
line : chanxian,
|
startTime : stime,
|
endTime : etime
|
},
|
dataType : "json",
|
url : rf_url,
|
success : loadSuccess,
|
error : loadError
|
});
|
|
//a = true;
|
}
|
|
function loadSuccess(data) {
|
var db = createTable(document.getElementById("glass-data"), opt);
|
isChaXun = true;
|
|
var d = data;
|
var noNum = 0;
|
var noMJ = 0;
|
var okNum = 0;
|
var okMJ = 0;
|
|
for (var i = 0; i < d.length; i++) {
|
d[i][0] = i + 1;
|
//d[i][5] = Math.pow(d[i][5],-6);
|
|
if (gongyi == "钢化") {
|
if (d[i][2] == "1") {
|
d[i][2] = "兰迪";
|
|
}
|
if (d[i][2] == "2") {
|
d[i][2] = "北玻";
|
|
}
|
|
}
|
if (d[i][5] != null && d[i][5] != "") {
|
noMJ += d[i][5];
|
d[i][5] = keepTwoDecimalFull(d[i][5] / 1000000);
|
}
|
|
noNum += d[i][4];
|
okNum += d[i][6];
|
okMJ += d[i][7];
|
d[i][7] = keepTwoDecimalFull(d[i][7] / 1000000);
|
|
}
|
db.update(d);
|
total_num = d.length;
|
$("#rNum").text(d.length);
|
$("#okNum").text(okNum);
|
$("#noNum").text(noNum);
|
//$("#noMJ").text(Math.pow(noMJ,-6)+" ㎡");
|
$("#okMJ").text(keepTwoDecimalFull(okMJ / 1000000));
|
//noMJ = Math.pow(noMJ,-6);
|
$("#noMJ").text(keepTwoDecimalFull(noMJ / 1000000));
|
|
if (gongyi == "钢化") {
|
CountRate();
|
}
|
}
|
|
function loadError(data) {
|
//alert("刷新了");
|
/* if (a == true) {
|
setTimeout(loadTable, 5000);
|
a = false;
|
} */
|
}
|
|
|
|
function keepTwoDecimalFull(num) {
|
var result = parseFloat(num);
|
if (isNaN(result)) {
|
|
return;
|
}
|
result = Math.round(num * 100) / 100;
|
var s_x = result.toString();
|
var pos_decimal = s_x.indexOf('.');
|
if (pos_decimal < 0) {
|
pos_decimal = s_x.length;
|
s_x += ".";
|
|
}
|
while (s_x.length <= pos_decimal + 2) {
|
s_x += '0';
|
}
|
return s_x;
|
|
}
|
|
//计算装载率
|
var isShowed = false;
|
function CountRate() {
|
var stime = $("#starttime").val();
|
var etime = $("#endtime").val();
|
var gy = gongyi;
|
if (gongyi == "冷加工") {
|
gy = "磨边";
|
}
|
var chanxian = $("#rf_chanxian").val();
|
var banzu = $("#rf_banzu").val();
|
|
$.ajax({
|
type : "post",
|
data : {
|
gongyi : "钢化装载",
|
banzu : banzu,
|
line : chanxian,
|
startTime : stime,
|
endTime : etime
|
},
|
dataType : "json",
|
url : rf_url,
|
success : function(data) {
|
var d = data;
|
var num = 0;
|
if (d.length > 0) {
|
num = d[0][0];
|
}
|
|
if (num != 0) {
|
|
var mjl = (($("#okMJ").text() / num) / (14.64)) * 100;
|
t = keepTwoDecimalFull(mjl);
|
|
}
|
|
if (isShowed) {
|
$("#ls").text(num);
|
$("#ghzzl").text(t);
|
} else {
|
isShowed = true;
|
$("#p_total").append(
|
"【钢化炉数：<span class='span-data' id='ls'>" + num
|
+ "</span>】");
|
$("#p_total").append(
|
"【钢化装载率：<span class='span-data' id='ghzzl'> "
|
+ t + " </span> % 】")
|
|
}
|
|
},
|
error : function(data) {
|
|
alert(data);
|
}
|
});
|
}
|
</script>
|
|
<!-- 切割明细报表 -->
|
<script>
|
//切割明细 表头，含批次
|
var cuteOpt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [
|
|
{
|
name : "序号",
|
binding : 0,
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
filter : {}
|
|
}, {
|
name : "长度",
|
binding : 1,
|
//style : "display:none;",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "高度",
|
binding : 2,
|
//type : "element",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "厚度",
|
binding : 3,
|
filter : {}
|
}, {
|
|
name : "颜色",
|
binding : 4,
|
filter : {}
|
}, {
|
|
name : "批次号",
|
binding : 5,
|
filter : {}
|
}, {
|
|
name : "数量",
|
binding : 6,
|
//type : "element",
|
filter : {}
|
}, {
|
|
name : "面积",
|
binding : 7,
|
filter : {}
|
}, {
|
|
name : "线路",
|
binding : 8,
|
filter : {}
|
}, {
|
|
name : "班组",
|
binding : 9,
|
filter : {}
|
}, {
|
|
name : "报工时间",
|
binding : 10,
|
filter : {}
|
} ]
|
};
|
|
|
//切割总览
|
var cOpt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [
|
|
{
|
name : "序号",
|
binding : 0,
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
filter : {}
|
|
}, {
|
name : "长度",
|
binding : 1,
|
//style : "display:none;",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "高度",
|
binding : 2,
|
//type : "element",
|
filter : {}
|
}, {
|
name : "厚度",
|
binding : 3,
|
filter : {}
|
}, {
|
|
name : "颜色",
|
binding : 4,
|
filter : {}
|
}, {
|
|
name : "数量",
|
binding : 5,
|
filter : {}
|
}, {
|
|
name : "面积",
|
binding : 6,
|
filter : {}
|
}, {
|
|
name : "线路",
|
binding : 7,
|
filter : {}
|
}, {
|
|
name : "班组",
|
binding : 8,
|
filter : {}
|
} , {
|
|
name : "报工时间",
|
binding : 9,
|
filter : {}
|
}]
|
};
|
|
|
function loadCutTable(){
|
|
var stime = $("#starttime").val();
|
if (stime == "" || stime == null) {
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("查询:");
|
$("#cz_Zhuangtai").html("查询失败");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("请选择或输入开始时间！");
|
return;
|
|
}
|
/* alert(stime);
|
return; */
|
var etime = $("#endtime").val();
|
var chanxian = $("#rf_chanxian").val();
|
var banzu = $("#rf_banzu").val();
|
|
|
var qCaoZao ;
|
if($("#pc_isShow").is(':checked')){
|
if($("#fz_isShow").is(':checked')){
|
qCaoZuo = '切割明细-分组';
|
}
|
else{
|
qCaoZuo='切割明细';
|
}
|
}
|
else{
|
if($("#fz_isShow").is(':checked')){
|
qCaoZuo = '切割总览-分组';
|
}
|
else{
|
qCaoZuo='切割总览';
|
}
|
}
|
|
$.ajax({
|
type:'post',
|
data:{
|
gongyi:qCaoZuo,
|
banzu : banzu,
|
line : chanxian,
|
startTime : stime,
|
endTime : etime
|
},
|
dataType:'json',
|
url:rf_url,
|
success:function(data){
|
if($("#pc_isShow").is(':checked')){
|
var cDB = createTable(document.getElementById("glass-data"), cuteOpt);
|
var d = data;
|
var zMj = 0;
|
var zSl =0;
|
if(d!=null && d.length>0){
|
total_num = d.length;
|
for(i=0;i<d.length;i++){
|
d[i][0] = i+1;
|
zSl+=d[i][6];
|
//zMj+=d[i][1]*d[i][2]*d[i][6];
|
d[i][7]= keepTwoDecimalFull((d[i][1]*d[i][2]*d[i][6]) / 1000000);
|
zMj+=parseFloat(keepTwoDecimalFull((d[i][1]*d[i][2]*d[i][6]) / 1000000));
|
|
}
|
$("#rRow").text(d.length);
|
$("#rSL").text(zSl);
|
$("#rMJ").text(keepTwoDecimalFull(zMj));
|
//$("#rMJ").text(keepTwoDecimalFull(zMj/1000000));
|
}else{
|
$("#rRow").text(0);
|
$("#rSL").text(0);
|
$("#rMJ").text(0);
|
}
|
cDB.update(d);
|
|
}else{
|
var gDB = createTable(document.getElementById("glass-data"), cOpt);
|
var d = data;
|
var zMj = 0;
|
var zSl =0;
|
if(d!=null && d.length>0){
|
total_num = d.length;
|
for(i=0;i<d.length;i++){
|
d[i][0] = i+1;
|
zSl+=d[i][5];
|
//zMj+=d[i][1]*d[i][2]*d[i][5];
|
|
d[i][6]= keepTwoDecimalFull((d[i][1]*d[i][2]*d[i][5]) / 1000000);
|
zMj+=parseFloat(keepTwoDecimalFull((d[i][1]*d[i][2]*d[i][5]) / 1000000));
|
}
|
$("#rRow").text(d.length);
|
$("#rSL").text(zSl);
|
//$("#rMJ").text(keepTwoDecimalFull(zMj/1000000));
|
$("#rMJ").text(keepTwoDecimalFull(zMj));
|
}else{
|
$("#rRow").text(0);
|
$("#rSL").text(0);
|
$("#rMJ").text(0);
|
}
|
gDB.update(d);
|
|
}
|
},
|
error:function(data){
|
|
}
|
})
|
}
|
</script>
|
|
|
<!-- 切割单片 -->
|
<script>
|
|
|
</script>
|
|
<!-- 导出表格 -->
|
<script>
|
function ExportTable() {
|
|
if (total_num < 1) {
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("导出表格:");
|
$("#cz_Zhuangtai").html("无需导出");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("没有数据，不需要导出！");
|
return;
|
|
}
|
var dt = new Date().getFullYear().toString();
|
dt += (new Date().getMonth() + 1).toString();
|
dt += new Date().getDate().toString();
|
if(rfName !="null" && rfName != ""){
|
var tName = rfName + "报表-" + dt + ".xls";
|
}else{
|
var tName = gongyi + "报表-" + dt + ".xls";
|
}
|
|
let exportFileContent = document.getElementById('glass-data').outerHTML;
|
let blob = new Blob([ exportFileContent ], {
|
type : 'text/plain;charset=utf-8'
|
}); // 解决中文乱码问题
|
blob = new Blob([ String.fromCharCode(0xFEFF), blob ], {
|
type : blob.type
|
});
|
// 设置链接
|
let
|
link = window.URL.createObjectURL(blob);
|
let
|
a = document.createElement('a'); // 创建a标签
|
a.download = tName; // 设置被下载的超链接目标（文件名）
|
a.href = link; // 设置a标签的链接
|
document.body.appendChild(a); // a标签添加到页面
|
a.click(); // 设置a标签触发单击事件
|
document.body.removeChild(a); // 移除a标签
|
}
|
</script>
|
|
<!-- 初始执行 -->
|
<script>
|
initPage();
|
initBanZu();
|
if(rfName !="null" && rfName != ""){
|
$("h3").text(rfName + " 报表");
|
/* $("#p_total").attr("style","display:none");
|
|
$("#ljg_total").attr("style","display:"); */
|
$("#ljg_total").attr("style","font-size:20px;display:");
|
$("#p_total").attr("style","font-size:20px;display:none");
|
$("#pc_c").attr("style","font-size:20px;display:");
|
}else{
|
$("h3").text(gongyi + " 报表");
|
/* $("#ljg_total").attr("style","display:none;font-size:20px");
|
$("#p_total").attr("style","display:;font-size:20px"); */
|
|
$("#ljg_total").attr("style","font-size:20px;display:none");
|
$("#p_total").attr("style","font-size:20px;display:");
|
$("#pc_c").attr("style","font-size:20px;display:none");
|
}
|
|
function pageShow(){
|
var winHeight=0;
|
winHeight=document.body.scrollHeight;
|
document.getElementById("glass-data").style.height =(winHeight-100)+"px";
|
}
|
|
function ChaXun() {
|
if (rfName == "切割明细") {
|
loadCutTable();
|
} else {
|
loadTable();
|
}
|
}
|
pageShow();
|
</script>
|
|
</body>
|
</html>
|
