Files
SIPAIIS_WMS_JSSW/WebRoot/jsp/sparepart/materialSummary.jsp

251 lines
12 KiB
Plaintext
Raw Permalink Normal View History

2026-01-16 14:13:44 +08:00
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ page import="com.sipai.entity.base.ServerObject"%>
<%@ taglib uri="http://www.springsecurity.org/jsp" prefix="security"%>
<!DOCTYPE html>
<!-- <html lang="zh-CN"> -->
<!-- BEGIN HEAD -->
<head>
<title><%= ServerObject.atttable.get("TOPTITLE")%></title>
<!-- 引用页头及CSS页-->
<jsp:include page="/jsp/inc.jsp"></jsp:include>
<!-- bootstrap switch -->
<link rel="stylesheet" href="<%=request.getContextPath()%>/node_modules/bootstrap-switch/dist/css/bootstrap3/bootstrap-switch.min.css"/>
<script type="text/javascript" src="<%=request.getContextPath()%>/node_modules/bootstrap-switch/dist/js/bootstrap-switch.min.js" charset="utf-8"></script>
<script type="text/javascript">
var dosearch = function() {
$('#table').remove();
var includeTaxrate = $('#includeTaxrate').val();
$.post(ext.contextPath + "/sparepart/goods/getList4Summary.do", {companyId:unitId,
warehouse_id: $('#warehouse_id').val(), dt_month: $('#dt_month').val()}, function(data) {
console.log(data);
var goodsClass = data.GoodsClass;
var in_num_now = data.in_num_now;
var stock_bef = data.stock_bef;
var goodsClassStr = "";
var in_num_nowStr = "";
var stock_befStr = "";
var stock_Str = "";
var in_num_nowSum = 0;
var stock_befSum = 0;
var out_num_nowSumStr = "";
var nowSumStr = "";
if(goodsClass!=null && goodsClass.length>0){
for(var i=0;i<goodsClass.length;i++){
goodsClassStr += '<td align=center>'+goodsClass[i].name+'</td>';
if(includeTaxrate=='0'){
//不含税
in_num_nowStr += '<td align=center>'+in_num_now[i].in_totalMoney_now+'</td>';
stock_befStr += '<td align=center>'+stock_bef[i].stock_totalMoney_bef+'</td>';
stock_Str += '<td align=center class="stock_Str_'+i+'">'+(in_num_now[i].in_totalMoney_now+stock_bef[i].stock_totalMoney_bef)+'</td>';
in_num_nowSum += in_num_now[i].in_totalMoney_now;
stock_befSum += stock_bef[i].stock_totalMoney_bef;
}else{
//含税
in_num_nowStr += '<td align=center>'+in_num_now[i].in_includeTaxrate_totalMoney_now+'</td>';
stock_befStr += '<td align=center>'+stock_bef[i].stock_includeTaxrate_totalMoney_bef+'</td>';
stock_Str += '<td align=center class="stock_Str_'+i+'">'+(in_num_now[i].in_includeTaxrate_totalMoney_now+stock_bef[i].stock_includeTaxrate_totalMoney_bef)+'</td>';
in_num_nowSum += in_num_now[i].in_includeTaxrate_totalMoney_now;
stock_befSum += stock_bef[i].stock_includeTaxrate_totalMoney_bef;
}
out_num_nowSumStr += '<td align=center class="out_num_now_class_sum_'+i+'"></td>';
nowSumStr += '<td align=center class="nowSumStr_'+i+'"></td>';
}
}
var out_num_now = data.out_num_now;
var out_num_nowStr = "";
var out_num_nowSum = 0;
var out_num_nowAllSum = 0;
if(out_num_now!=null && out_num_now.length>0){
for(var i=0;i<out_num_now.length;i++){
if(i==0){
out_num_nowStr += '<tr><td rowspan='+(out_num_now.length+1)+' align=center>本月减少</td>'+
'<td align=center>'+out_num_now[i].unitSname+'</td>';
}else{
out_num_nowStr += '<tr><td align=center>'+out_num_now[i].unitSname+'</td>';
}
var unit_out_num_now = out_num_now[i].unit_out_num_now;
if(unit_out_num_now!=null && unit_out_num_now.length>0){
out_num_nowSum = 0;
for(var ii=0;ii<unit_out_num_now.length;ii++){
if(includeTaxrate=='0'){
//不含税
out_num_nowStr += '<td align=center class="out_num_now_'+ii+'">'+unit_out_num_now[ii].out_totalMoney_now+'</td>';
out_num_nowSum += unit_out_num_now[ii].out_totalMoney_now;
}else{
//含税
out_num_nowStr += '<td align=center class="out_num_now_'+ii+'">'+unit_out_num_now[ii].out_includeTaxrate_totalMoney_now+'</td>';
out_num_nowSum += unit_out_num_now[ii].out_includeTaxrate_totalMoney_now;
}
}
}
out_num_nowStr += '<td align=center class="out_num_now_sum">'+out_num_nowSum+'</td></tr>';
}
}
out_num_nowSumStr += '<td align=center class="out_num_now_class_sum"></td>';
nowSumStr += '<td align=center class="nowSumStr_sum"></td>';
var htmlStr =
'<table class="table table-bordered table-condensed" style="background: #ffffff;" id="table">'+
'<tr><td align=center colspan='+(goodsClass.length+3)+'>材料设备增减汇总表</td></tr>'+
'<tr>'+
'<td align=left colspan='+(goodsClass.length+2)+'>制表部门:</td>'+
'<td align=center>'+$('#dt_month').val()+'</td>'+
'</tr>'+
'<tr>'+
'<td colspan=2 align=center>应记账户\材设类别</td>'+goodsClassStr+
'<td align=center>合计</td>'+
'</tr>'+
'<tr>'+
'<td colspan=2 align=center>上月库存总量</td>'+stock_befStr+
'<td align=center>'+stock_befSum+'</td>'+
'</tr>'+
'<tr>'+
'<td rowspan=2 align=center>本月增加</td><td align=center>入库</td>'+in_num_nowStr+
'<td align=center>'+in_num_nowSum+'</td>'+
'</tr>'+
'<tr>'+
'<td align=center>合计</td>'+stock_Str+
'<td align=center>'+(in_num_nowSum+stock_befSum)+'</td>'+
'</tr>'+out_num_nowStr+
'<tr>'+
'<td align=center>合计</td>'+out_num_nowSumStr+
'</tr>'+
'<tr>'+
'<td colspan=2 align=center>本月库存</td>'+nowSumStr+
'</tr>'+
'</table>';
$('#content').append(htmlStr);
if(goodsClass!=null && goodsClass.length>0){
for(var i=0;i<goodsClass.length;i++){
var value = 0;
$('.out_num_now_'+i).each(function(){
value+=$(this).text()-0;
})
$('.out_num_now_class_sum_'+i).html(value);
}
var value = 0;
$('.out_num_now_sum').each(function(){
value+=$(this).text()-0;
})
$('.out_num_now_class_sum').html(value);
for(var i=0;i<goodsClass.length;i++){
var stock_Str = $('.stock_Str_'+i).text()-0;
var out_num_now_class_sum = $('.out_num_now_class_sum_'+i).text()-0;
$('.nowSumStr_'+i).html(stock_Str-out_num_now_class_sum);
}
var out_num_now_class_sum = $('.out_num_now_class_sum').text()-0;
$('.nowSumStr_sum').html(stock_befSum-out_num_now_class_sum);
}
},'json');
};
var dowarehouse = function() {
//选择仓库
$.post(ext.contextPath + "/sparepart/warehouse/getWarehouseForSelectByCompanyId.do", {companyId:unitId}, function(data) {
$('#name1').val(data[0].id);
var selelct =$("#warehouse_id").select2({
data: data,
placeholder:'请选择',//默认文字提示
allowClear: false,//允许清空
escapeMarkup: function (markup) { return markup; }, // 自定义格式化防止xss注入
language: "zh-CN",
minimumInputLength: 0,
minimumResultsForSearch: 10,//数据超过十个启用搜索框
formatResult: function formatRepo(repo){return repo.text;}, // 函数用来渲染结果
formatSelection: function formatRepoSelection(repo){return repo.text;} // 函数用于呈现当前的选择
});
selelct.val(data[0].id).trigger("change");
selelct.on("change",function(e){
dosearch();
});
dosearch();
},'json');
}
$(function() {
$('#dt_month').datepicker({
format: 'yyyy-mm',
weekStart: 1,
autoclose: true,
startView: 2,
minViewMode: 1,
maxViewMode: 2,
forceParse: false,
language: 'zh-CN',
}).on('changeDate',function(ev){
dosearch();
});
dowarehouse();
var data = [{ id: 0, text: '不含税' }, { id: 1, text: '含税' }];
var selelct =$("#includeTaxrate").select2({
data: data,
placeholder:'请选择',//默认文字提示
allowClear: false,//允许清空
escapeMarkup: function (markup) { return markup; }, // 自定义格式化防止xss注入
language: "zh-CN",
minimumInputLength: 0,
minimumResultsForSearch: 10,//数据超过十个启用搜索框
formatResult: function formatRepo(repo){return repo.text;}, // 函数用来渲染结果
formatSelection: function formatRepoSelection(repo){return repo.text;} // 函数用于呈现当前的选择
});
selelct.val('0').trigger("change");
selelct.on("change",function(e){
dosearch();
});
});
</script>
</head>
<body onload="initMenu()" class="hold-transition ${cu.themeclass} sidebar-mini">
<div class="wrapper">
<!-- 引用top -->
<%-- <jsp:include page="/jsp/top.jsp"></jsp:include> --%>
<!-- 菜单栏 -->
<%-- <jsp:include page="/jsp/left.jsp"></jsp:include> --%>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<!-- <section class="content-header">
<h1 id ="head_title"></h1>
<ol class="breadcrumb">
<li><a id ='head_firstlevel' href="#"><i class="fa fa-dashboard"></i> </a></li>
<li class="active">Here</li>
</ol>
</section> -->
<!-- Main content -->
<section class="content container-fluid">
<div id="mainAlertdiv"></div>
<div id="subDiv"></div>
<div id="fault4SelectDiv"></div>
<div id="equ4SelectDiv"></div>
<div id="content">
<div class="form-group pull-right form-inline" >
<div class="input-group input-group-sm">
<input class="form-control date-picker" id="dt_month" style="width: 160px;" value="${nowmonth}"
type="text" style="background-color:#FFFFFF;height:100%;" />
<span class="input-group-addon">
<i class="fa fa-calendar bigger-110"></i>
</span>
</div>
<div class="input-group input-group-sm">
<label class="form-label">所属仓库:</label>
<select class="form-control select2 " id="warehouse_id" name ="warehouse_id" style="width: 160px;">
</select>
</div>
<div class="input-group input-group-sm">
<label class="form-label">是否含税:</label>
<select class="form-control select2 " id="includeTaxrate" name ="includeTaxrate" style="width: 160px;">
</select>
</div>
</div>
</div>
</section>
<!-- /.content -->
</div>
<%-- <jsp:include page="/jsp/bottom.jsp"></jsp:include> --%>
<%-- <jsp:include page="/jsp/side.jsp"></jsp:include> --%>
</div>
</body>
</html>