<%@ page contentType="text/html;charset=UTF-8"%>
|
|
<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 rfName = "切裁率报表";
|
//是否查询
|
var isChaXun = false;
|
//数据总量
|
var total_num = 0;
|
</script>
|
|
|
<!-- 表头 -->
|
<script>
|
//切裁率明细报表
|
var qcl_opt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [
|
|
{
|
name : "序号",
|
binding : 0,
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
style : "width:5%",
|
filter : {}
|
|
}, {
|
name : "工程号",
|
binding : 1,
|
//style : "display:none;",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "工程状态",
|
binding : 2,
|
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,
|
type : "element",
|
filter : {}
|
}, {
|
|
name : "创建时间",
|
binding : 10,
|
filter : {}
|
}, {
|
|
name : "完成时间",
|
binding : 11,
|
filter : {}
|
} ]
|
};
|
|
//流程卡切裁率报表
|
var qcl_lck_opt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [
|
|
{
|
name : "序号",
|
binding : 0,
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
style : "width:5%",
|
filter : {}
|
|
}, {
|
name : "工程号",
|
binding : 1,
|
//style : "display:none;",
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "流程卡号",
|
binding : 2,
|
filter : {}
|
//设置列可搜索
|
}, {
|
name : "厚度",
|
binding : 3,
|
filter : {}
|
}, {
|
|
name : "颜色",
|
binding : 4,
|
filter : {}
|
}, {
|
|
name : "小片数量",
|
binding : 5,
|
filter : {}
|
}, {
|
|
name : "小片面积",
|
binding : 6,
|
filter : {}
|
}, {
|
|
name : "切裁率",
|
binding : 7,
|
type : "element",
|
filter : {}
|
}, {
|
|
name : "完成时间",
|
binding : 8,
|
|
filter : {}
|
} ]
|
};
|
|
//流程卡总切裁率报表
|
var qcl_zong_opt = {
|
table : {
|
style : "width:100%",
|
"class" : "table table-striped table-hover"
|
},
|
columns : [ {
|
name : "线路",
|
binding : 0,
|
//style : "font-weight：bold",
|
//style : "text-align:center",
|
style : "width:5%"
|
|
}, {
|
name : "工程数量",
|
binding : 1,
|
//style : "display:none;",
|
//设置列可搜索
|
}, {
|
name : "小片面积",
|
binding : 2,
|
//style : "display:none;",
|
//设置列可搜索
|
}, {
|
name : "原片面积",
|
binding : 3
|
//设置列可搜索
|
}, {
|
name : "平均切裁率",
|
binding : 4,
|
type : "element"
|
} ]
|
};
|
</script>
|
|
<!-- 内容 -->
|
<script>
|
function queryLoadRFData(type) {
|
var stime = $("#starttime").val();
|
var etime = $("#endtime").val();
|
var isShowLCK = $("#rf_lck_isShow").val();
|
var gcNo = $("#rf_gc_num").val();
|
var lckNo = "";
|
if (type == 1) {
|
if (isShowLCK == 1) {
|
lckNo = $("#rf_lck_num").val();//流程卡号
|
if ((stime == "" || stime == null)
|
&& (lckNo == "" || lckNo == null)) {
|
if (gcNo == "") {
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("查询：");
|
$("#cz_Zhuangtai").html("查询失败");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("请选择开始时间或输入流程卡号！");
|
return;
|
}
|
}
|
loadLCKCutRateTable(gcNo, lckNo, stime, etime)
|
} else {
|
lckNo = "";
|
//alert(gcNo + stime + stime);
|
if ((stime == "" || stime == null)
|
&& (gcNo == "" || gcNo == null)) {
|
|
if (gcNo == "") {
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("查询：");
|
$("#cz_Zhuangtai").html("查询失败");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("请选择开始时间或输入工程号！");
|
return;
|
}
|
}
|
loadGongChengCutRateTable(gcNo, stime, etime);
|
}
|
} else if (type == 2) {
|
if (stime == "" || stime == null) {
|
|
$("#CZ_Msg").modal('toggle');
|
$("#cz_Ming").html("查询：");
|
$("#cz_Zhuangtai").html("查询失败");
|
$("#cz_Zhuangtai").attr("style", "color:red;");
|
$("#cz_mingxi").html("请选择或输入开始时间！");
|
return;
|
}
|
loadZongCutRateTable(stime, etime);
|
} else if (type == 3) {
|
loadZongCutRateTable('2008-08-08T00:00', etime);
|
}
|
|
}
|
|
function btnSetDatetime(t) {
|
var myDate = new Date();
|
var beforeseven = new Date();
|
switch (t) {
|
//近7天
|
case 7:
|
//alert(beforeseven.getFullYear() +'-' +Twodigits(beforeseven.getMonth() + 1) +'-' +Twodigits(beforeseven.getDate()-7)+"T00:00");
|
$("#starttime").val(
|
beforeseven.getFullYear() + '-'
|
+ Twodigits(beforeseven.getMonth() + 1) + '-'
|
+ Twodigits(beforeseven.getDate() - 7) + "T00:00");
|
//alert(myDate.getFullYear() +'-' +Twodigits(myDate.getMonth() + 1) +'-' + Twodigits(myDate.getDate())+"T"+Twodigits(myDate.getHours()+1)+":00");
|
//$("#endtime").val(myDate.getFullYear() +'-' +Twodigits(myDate.getMonth() + 1) +'-' + Twodigits(myDate.getDate())+"T"+Twodigits(myDate.getHours()+1)+":00");
|
break;
|
//当前月
|
case 30:
|
var getLastMonthStartDate = new Date(new Date().getFullYear(),
|
new Date().getMonth(), 1);
|
var monthEndDate = new Date(new Date().getFullYear(), new Date()
|
.getMonth(), new Date().getDate());
|
//return [formatDate(getLastMonthStartDate), formatDate(monthEndDate)];
|
//alert([formatDate(getLastMonthStartDate), formatDate(monthEndDate)]);
|
$("#starttime").val(formatDate(getLastMonthStartDate) + "T00:00");
|
//$("#endtime").val(formatDate(monthEndDate)+"T"+Twodigits(myDate.getHours()+1)+":00");
|
break;
|
//上一月
|
case 60:
|
var lastMonthStartDate = new Date(new Date().getFullYear(),
|
new Date().getMonth() - 1, 1);
|
var date = new Date();
|
var day = new Date(date.getFullYear(), date.getMonth(), 0)
|
.getDate();
|
var lastMonthEndDate = new Date(new Date().getFullYear(),
|
new Date().getMonth() - 1, day);
|
//return [formatDate(lastMonthStartDate), formatDate(lastMonthEndDate)];
|
$("#starttime").val(formatDate(lastMonthStartDate) + "T00:00");
|
$("#endtime").val(formatDate(lastMonthEndDate) + "T23:59");
|
break;
|
//今年
|
case 365:
|
var firstDay = new Date();
|
firstDay.setDate(1);
|
firstDay.setMonth(0);
|
var now = new Date();
|
//return [moment(firstDay).format('YYYY-MM-DD'),moment(now).format('YYYY-MM-DD')];
|
$("#starttime").val(firstDay.getFullYear() + "-01-01" + "T00:00");
|
//$("#endtime").val(moment(now).format('YYYY-MM-DD')+"T23:59");
|
//$("#endtime").val(myDate.getFullYear() +'-' +Twodigits(myDate.getMonth() + 1) +'-' + Twodigits(myDate.getDate())+"T23:59");
|
break;
|
case 5:
|
break;
|
default:
|
break;
|
}
|
|
}
|
|
function Twodigits(num) {
|
return num < 10 ? '0' + num : num;
|
}
|
|
function formatDate(date) {
|
var myYear = date.getFullYear();
|
var myMonth = date.getMonth() + 1;
|
var myWeekday = date.getDate();
|
if (myMonth < 10) {
|
myMonth = '0' + myMonth;
|
}
|
if (myWeekday < 10) {
|
myWeekday = '0' + myWeekday;
|
}
|
return (myYear + '-' + myMonth + '-' + myWeekday);
|
}
|
</script>
|
|
<script type="text/javascript">
|
//加载表格内容
|
function loadGongChengCutRateTable(gcNo, stime, etime) {
|
var db = createTable(document.getElementById("rf_glass_data"), qcl_opt);
|
var d = null;
|
var dNum = 0;//数据量
|
var dSum = 0;//小片数量
|
var dArea = 0;//小片面积
|
var dSArea = 0;//原片面积
|
|
$.ajax({
|
type : "post",
|
data : {
|
gongyi : "切割率明细",
|
startTime : stime,
|
endTime : etime,
|
gongchenghao : gcNo
|
},
|
dataType : "json",
|
url : rf_url,
|
success : function(data) {
|
d = data;
|
total_num = d.length;
|
dNum = d.length;
|
|
for (var i = 0; i < d.length; i++) {
|
d[i][0] = i + 1;
|
dSum += d[i][6];
|
dArea += parseFloat(d[i][7]);
|
dSArea += parseFloat(d[i][8]);
|
|
if (d[i][9] < 60) {
|
d[i][9] = "<span class='label label-warning'>"
|
+ d[i][9] + " %</span>"
|
} else if (d[i][9] < 80) {
|
d[i][9] = "<span class='label label-info'>" + d[i][9]
|
+ " %</span>"
|
} else if (d[i][9] >= 80) {
|
d[i][9] = "<span class='label label-success'>"
|
+ d[i][9] + " %</span>"
|
}
|
|
}
|
db.update(d);
|
|
$("#rNum").text(dNum);
|
$("#pZSL").text(dSum);
|
$("#pZMJ").text(keepTwoDecimalFull(dArea));
|
$("#sZMJ").text(keepTwoDecimalFull(dSArea));
|
},
|
error : function(data) {
|
|
}
|
});
|
}
|
|
function loadLCKCutRateTable(gcNo, lckNo, stime, etime) {
|
var db = createTable(document.getElementById("rf_glass_data"), qcl_lck_opt);
|
var d = null;
|
var dNum = 0;//数据量
|
var dSum = 0;//小片数量
|
var dArea = 0;//小片面积
|
var dSArea = 0;//原片面积
|
|
$.ajax({
|
type : "post",
|
data : {
|
gongyi : "流程卡切裁率",
|
startTime : stime,
|
endTime : etime,
|
gongchenghao : gcNo,
|
liuchengkahao:lckNo
|
},
|
dataType : "json",
|
url : rf_url,
|
success : function(data) {
|
d = data;
|
total_num = d.length;
|
dNum = d.length;
|
|
for (var i = 0; i < d.length; i++) {
|
d[i][0] = i + 1;
|
dSum += d[i][5];
|
dArea += parseFloat(d[i][6]);
|
|
if (d[i][7] < 60) {
|
d[i][7] = "<span class='label label-warning'>"
|
+ d[i][7] + " %</span>"
|
} else if (d[i][7] < 80) {
|
d[i][7] = "<span class='label label-info'>" + d[i][7]
|
+ " %</span>"
|
} else if (d[i][7] >= 80) {
|
d[i][7] = "<span class='label label-success'>"
|
+ d[i][7] + " %</span>"
|
}
|
|
}
|
db.update(d);
|
|
$("#rNum").text(dNum);
|
$("#pZSL").text(dSum);
|
$("#pZMJ").text(keepTwoDecimalFull(dArea));
|
|
},
|
error : function(data) {
|
|
}
|
});
|
}
|
|
function loadZongCutRateTable(stime, etime) {
|
var db = createTable(document.getElementById("qcl_rf_zl"), qcl_zong_opt);
|
var d = null;
|
var gc_num =0;
|
var gc_zxp=0;
|
var gc_zmj =0;
|
|
|
$.ajax({
|
type : "post",
|
data : {
|
gongyi : "总切裁率",
|
startTime : stime,
|
endTime : etime
|
},
|
dataType : "json",
|
url : rf_url,
|
success : function(data) {
|
d = data;
|
for (var i = 0; i < d.length; i++) {
|
zl_num = d.length;
|
if (d[i][0] == 0) {
|
|
d[i][0] = "手 动 完 成";
|
} else {
|
d[i][0] = "冷加工 " + d[i][0] + " 线";
|
}
|
|
gc_num +=d[i][1];
|
gc_zxp+=d[i][2];
|
gc_zmj+=d[i][3];
|
|
if (d[i][4] < 60) {
|
d[i][4] = "<span class='label label-warning'>"
|
+ d[i][4] + " %</span>"
|
} else if (d[i][4] < 80) {
|
d[i][4] = "<span class='label label-info'>" + d[i][4]
|
+ " %</span>"
|
} else if (d[i][4] >= 80) {
|
d[i][4] = "<span class='label label-success'>"
|
+ d[i][4] + " %</span>"
|
}
|
}
|
$("#span_zongqiecailv").text("【总工程数："+gc_num+"】【小片面积："+gc_zxp+" ㎡】【原片面积："+gc_zmj+" ㎡】【平均切裁率："+keepTwoDecimalFull(gc_zxp/gc_zmj)+"%】");
|
db.update(d);
|
},
|
error : function(data) {
|
|
}
|
});
|
}
|
|
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;
|
|
}
|
</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>";
|
|
html += " <option value='3' >" + gongyi + " 3 线</option>";
|
document.getElementById("rf_chanxian").innerHTML += html;
|
|
} */
|
</script>
|
