<%@ 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>
|
<title>任务统计</title>
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
<link href="${ctx}/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="${ctx}/static/jquery/jquery-3.1.0.min.js" type="text/javascript"></script>
|
<script src="${ctx}/static/js/jquery-ui.js"></script>
|
<script language="javascript" type="text/javascript" src="${ctx}/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="${ctx}/shelfmanager/downExcel?starttime="+starttime+"&completetime="+completetime;
|
}
|
}
|
})
|
})
|
</script>
|
</head>
|
<body>
|
<div class="content-wrapper">
|
<!-- 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%;" 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="text" id="starttime" name="starttime" style="height: 28px;" readonly="readonly" value="${starttime}"></td>
|
<td style="padding-left: 150px;">完成时间:</td><td style="padding-left: 20px;"><input type="text" id="completetime" 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:350px;" 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>
|
<c:forEach items="${rankList}" var="rankList" varStatus="status1">
|
<tr>
|
<%-- <td height="30px"><a type ='button' class='btn btn-info' href="${ctx}/reportmanage/lookinfobyoptname?optname=${reportTask.opt_name}">${reportTask.opt_name}</a></td> --%>
|
<td height="30px">${rankList.id}</td>
|
<td height="30px">${rankList.type}</td>
|
<td height="30px">${rankList.shelfRack.id}</td>
|
<td height="30px">${rankList.glassId}</td>
|
<td height="30px">${rankList.width}</td>
|
<td height="30px">${rankList.height}</td>
|
<td height="30px">${rankList.thickness}</td>
|
<td height="30px">${rankList.pieces}</td>
|
<td height="30px">${rankList.pieces*(rankList.height/1000)*(rankList.height/1000)}</td>
|
<td height="30px">${rankList.createtime}</td>
|
<td height="30px">${rankList.endtime}</td>
|
<td height="30px">${rankList.manufacturer}</td>
|
</tr>
|
</c:forEach>
|
</table>
|
</div>
|
</fieldset>
|
</td>
|
</tr>
|
</table>
|
</div>
|
</div>
|
</section>
|
</div>
|
<!-- /.content -->
|
</div>
|
</body>
|
</html>
|
