<%@page import="ng.db.DBHelper"%>
|
<%@ page contentType="text/html;charset=UTF-8" %>
|
<html>
|
<head>
|
<title>任务统计</title>
|
<link rel="stylesheet" href="../static/AdminLTE/bower_components/bootstrap/dist/css/bootstrap.min.css">
|
<!-- Font Awesome -->
|
<link rel="stylesheet" href="../static/AdminLTE/bower_components/font-awesome/css/font-awesome.min.css">
|
<!-- Ionicons -->
|
<link rel="stylesheet" href="../static/AdminLTE/bower_components/Ionicons/css/ionicons.min.css">
|
<!-- Theme style -->
|
<link rel="stylesheet" href="../static/AdminLTE/dist/css/AdminLTE.min.css">
|
<link rel="stylesheet" href="../static/AdminLTE/dist/css/skins/skin-blue.min.css">
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
<link href="../static/bootstrap/2.3.2/css/bootstrap.min.css" type="text/css" rel="stylesheet"/>
|
<link rel="stylesheet" href="${ctx }/static/js/jquery-ui.css">
|
|
<script src="../static/jquery/jquery-3.1.0.min.js" type="text/javascript"></script>
|
<script src="../static/js/jquery-ui.js"></script>
|
<script language="javascript" type="text/javascript" src="../static/util2.js"></script>
|
<script>
|
$(document).ready(function(){
|
var info = $("#info").attr("info");
|
$("#infos").html(info);
|
});
|
$(function() {
|
$( "#completetime" ).datepicker({
|
showOn: "button",
|
buttonImage: "../static/images/time.png",
|
buttonImageOnly: true,
|
buttonText: "Select date"
|
});
|
|
$( "#starttime" ).datepicker({
|
showOn: "button",
|
buttonImage: "../static/images/time.png",
|
buttonImageOnly: true,
|
buttonText: "Select date"
|
});
|
} );
|
</script>
|
|
<script type="text/javascript">
|
function checkData(){
|
//主要是对时间的校验
|
var starttime = document.getElementById("starttime").value;
|
var completetime = document.getElementById("completetime").value;
|
//两个时间都是空
|
if(starttime == ""){
|
/* document.getElementById("formid").submit();//表单提交 */
|
$.MsgBox.Alert("WARM PROMPT", "开始时间不能为空!");
|
}
|
//开始时间不为空
|
else if(completetime == ""){
|
|
$.MsgBox.Alert("WARM PROMPT", "截至时间不能为空!");
|
|
}
|
//都不为空
|
else{
|
//转换成日期类型（只是为了比较大小）
|
var startTime = new Date(starttime);
|
var completeTime = new Date(completetime);
|
//当起始时间大于完成时间
|
if(startTime.getTime() > completeTime.getTime()){
|
//非法输入
|
$.MsgBox.Alert("WARM PROMPT", "开始时间不能大于完成时间!");
|
return false;
|
}
|
//当起始时间小于等于完成时间，都是合法的
|
else {
|
document.getElementById("formid").submit();//表单提交
|
}
|
}
|
}
|
|
</script>
|
|
<script type="text/javascript">
|
$(function(){
|
$(".download").click(function(){
|
//主要是对时间的校验
|
var starttime = document.getElementById("starttime").value;
|
var completetime = document.getElementById("completetime").value;
|
//两个时间都是空
|
if(starttime == ""){
|
/* document.getElementById("formid").submit();//表单提交 */
|
$.MsgBox.Alert("WARM PROMPT", "下载时开始时间不能为空!");
|
}
|
//开始时间不为空
|
else if(completetime == ""){
|
|
$.MsgBox.Alert("WARM PROMPT", "下载时截至时间不能为空!");
|
|
}
|
//都不为空
|
else{
|
//转换成日期类型（只是为了比较大小）
|
var startTime = new Date(starttime);
|
var completeTime = new Date(completetime);
|
//当起始时间大于完成时间
|
if(startTime.getTime() > completeTime.getTime()){
|
//非法输入
|
$.MsgBox.Alert("WARM PROMPT", "开始时间不能大于完成时间!");
|
return false;
|
}
|
//当起始时间小于等于完成时间，都是合法的
|
else {
|
window.location.href="../shelfmanager/downExcel?starttime="+starttime+"&completetime="+completetime;
|
}
|
}
|
})
|
})
|
</script>
|
</head>
|
<body>
|
<div id='app' style='background-color:#D5EAFF;height:100%'>
|
<!-- Content Header (Page header) -->
|
<div>
|
<section class="content-header">
|
<h1>
|
出入库统计
|
<small></small>
|
</h1>
|
<ol class="breadcrumb">
|
<li><a href="${ctx }/reportmanage/taskreport"><i class="fa fa-reply"></i>出入库统计</a></li>
|
<li class="active">统计信息</li>
|
</ol>
|
</section>
|
<div id = "info" info = "${info}"></div>
|
</div>
|
<div>
|
<!-- Main content -->
|
<section class="content container-fluid">
|
<div class="box" style="margin-top: 10px;">
|
<div class="box-header" align="center">
|
<h3 class="box-title">筛选条件</h3>
|
</div>
|
<div style="overflow: auto;height:160px;" class="box-body no-padding">
|
<table class="table" style="font-size: medium; width: 100%;width:90%" id="table" >
|
<tr>
|
<td style="width: 40%; border: 0px solid white; vertical-align: top;">
|
<div>
|
<fieldset>
|
<div>
|
<form action="${ctx }/shelfmanager/selectrank" id="formid" method="post">
|
<table style="font-size: large;">
|
<tr>
|
<td>开始时间:</td><td style="padding-left: 20px;"><input type="date" id="" name="starttime" style="height: 28px;" readonly="readonly" value="${starttime}"></td>
|
<td style="padding-left: 150px;">完成时间:</td><td style="padding-left: 20px;"><input type="date" name="completetime" style="height: 28px;" readonly="readonly" value="${completetime}"></td>
|
</tr>
|
<tr>
|
<td><input type="button" value="查询" onclick="checkData()" class="btn btn-large btn-info"/></td>
|
<td style="padding-left: 100px;">
|
<input type="button" value="下载" class="download btn btn-large btn-info"/>
|
</td>
|
</tr>
|
</table>
|
</form>
|
</div>
|
</fieldset>
|
</div>
|
</td>
|
</tr>
|
</table>
|
</div>
|
</div>
|
|
<div class="box" style="margin-top: 10px;">
|
<div class="box-header" align="center">
|
<h3 class="box-title">统计信息</h3>
|
</div>
|
<div style="overflow: auto;height:50%;" class="box-body no-padding">
|
<table class="table table-striped" style="font-size: medium; width: 100%;" id="table">
|
<tr>
|
<td style="width: 100%; border: 0px solid white; vertical-align: top;">
|
<fieldset>
|
<div style="overflow: auto;">
|
<table class="table table-striped table-hover">
|
<tr>
|
<th width="200px" height="40px" align="left">序号</th>
|
<th width="120px" height="40px" align="left">类型</th>
|
<th width="120px" height="40px" align="left">库位号</th>
|
<th width="120px" height="40px" align="left">GlassId</th>
|
<th width="120px" height="40px" align="left">宽(mm)</th>
|
<th width="120px" height="40px" align="left">高(mm)</th>
|
<th width="120px" height="40px" align="left">厚度(mm)</th>
|
<th width="120px" height="40px" align="left">数量</th>
|
<th width="120px" height="40px" align="left">平方</th>
|
<th width="200px" height="40px" align="left">进库时间</th>
|
<th width="200px" height="40px" align="left">操作时间</th>
|
<th width="200px" height="40px" align="left">原片厂家</th>
|
</tr>
|
<tr v-for='(items,index) in shuzu' :key='index'>
|
<td v-for='(item,key1) in items' :key='items.list1' >
|
{{item}}
|
</td>
|
</tr>
|
</table>
|
</div>
|
</fieldset>
|
</td>
|
</tr>
|
</table>
|
</div>
|
</div>
|
</section>
|
</div>
|
<!-- /.content -->
|
</div>
|
</body>
|
<script src="../js/vue.min.js"></script>
|
<script>
|
let app = new Vue({
|
el:'#app',
|
data:{
|
shuzu:<%= DBHelper.getDBHelper("mes").query(false,"SELECT id,type,shelf_rack_id,glass_id,width,height,thickness,pieces,round(width*height*pieces/1000000,4),createtime,createtime,ifnull(manufacturer,'') from gmms_rank ORDER BY createtime desc LIMIT 10;") %>,
|
|
},
|
|
})
|
</script>
|
</html>
|
