出入库历史 +月结管理 按钮权限+sql

chen.llin

2025-12-25 5232d8b5939cb832c3d17c2aa1d6eaf66e5acb74

出入库历史 +月结管理 按钮权限+sql

 src/main/java/com/zy/asrs/controller/MonthlySettleController.java

@@ -4,15 +4,19 @@
import com.core.annotations.ManagerAuth;
import com.core.common.R;
import com.zy.asrs.entity.MonthlySettle;
import com.zy.asrs.entity.MonthlySettleDetail;
import com.zy.asrs.entity.param.DateRangeParam;
import com.zy.asrs.entity.param.MonthlySettleQueryParam;
import com.zy.asrs.entity.result.MonthlySettleStatisticsVO;
import com.zy.asrs.service.MonthlySettleService;
import com.zy.common.web.BaseController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@RestController
public class MonthlySettleController extends BaseController {
@@ -131,5 +135,34 @@
        return R.ok("删除成功");
    }

    /**
     * å¯¼å‡ºæœˆç»“明细
     */
    @RequestMapping(value = "/monthlySettle/detail/export/{id}/auth")
    @ManagerAuth(memo = "导出月结明细")
    public R exportDetail(@PathVariable("id") Long id) {
        // èŽ·å–月结统计信息
        MonthlySettleStatisticsVO statistics = monthlySettleService.getSettleStatistics(id);
        if (statistics == null || statistics.getDetails() == null) {
            return R.error("月结明细不存在");
        }
        
        List<MonthlySettleDetail> details = statistics.getDetails();
        
        // å®šä¹‰å¯¼å‡ºå­—段
        List<String> fields = new ArrayList<>();
        fields.add("matnr");
        fields.add("maktx");
        fields.add("batch");
        fields.add("brand");
        fields.add("beginningQty");
        fields.add("endingQty");
        fields.add("diffQty");
        fields.add("inQty");
        fields.add("outQty");
        
        return R.ok(exportSupport(details, fields));
    }

}


 src/main/java/com/zy/asrs/service/impl/MonthlySettleServiceImpl.java

@@ -498,8 +498,6 @@
        detail.setInQty(inQty);
        detail.setOutQty(outQty);
        detail.setEndingQty(endingQty);
        // stock_qty å­—段已废弃，实际库存等于期末库存，不再单独存储
        // detail.setStockQty(endingQty);
        detail.setDiffQty(diffQty);
        // æ—¶é—´ä¿¡æ¯
        detail.setCreateTime(new Date());

 src/main/resources/sql/°´Å¥È¨ÏÞ.sql

New file
@@ -0,0 +1,24 @@
--  æœˆç»“
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'monthlySettle/monthlySettle.html', N'月结管理', null, '2', null, '1');

insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'monthlySettle#btn-view', N'查询',    ''     , '3', '0', '1');
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'monthlySettle#btn-add', N'发起月结',   ''     , '3', '1', '1');
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'monthlySettle#btn-export', N'导出',   ''    , '3', '2', '1');
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'monthlySettle#btn-delete', N'删除',  ''     , '3', '3', '1');

-- å…¥åº“历史订单
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakinLog/order.html', N'入库历史单据', null, '2', null, '1');

insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakinLog#btn-view', N'查询',       ''   , '3', '0', '1');
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakinLog#btn-edit', N'修改业务时间',   ''   , '3', '1', '1');

-- å‡ºåº“历史订单
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakoutLog/order.html', N'出库历史单据', null, '2', null, '1');

insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakoutLog#btn-view', N'查询',       ''    , '3', '0', '1');
insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'orderPakoutLog#btn-edit', N'修改业务时间',   ''  , '3', '1', '1');






 src/main/webapp/static/css/common.css

@@ -206,6 +206,9 @@
#btn-into {
    display: none;
}
.btn-view {
    display: none;
}

/*修改复选框颜色*/
/*.layui-form-checked[lay-skin=primary] i {*/

 src/main/webapp/static/js/monthlySettle/monthlySettle.js

@@ -29,7 +29,7 @@
            {field: 'totalOutQty', align: 'center', title: '总出库数量', width: 120},
            {field: 'totalMaterials', align: 'center', title: '物料种类数', width: 120},
            {field: 'createTime$', title: '创建时间', minWidth: 180, width: 180},
            {align: 'center', title: '操作', toolbar: '#operate', width: 180}
            {align: 'center', title: '操作', toolbar: '#operate', width: 240}
        ]],
        request: {
            pageName: 'curr',
@@ -368,6 +368,8 @@
        var layEvent = obj.event;
        if (layEvent === 'detail') {
            showDetailDialog(data);
        } else if (layEvent === 'export') {
            exportDetail(data);
        } else if (layEvent === 'delete') {
            deleteSettle(data);
        }
@@ -478,6 +480,50 @@
        });
    }

    // å¯¼å‡ºæœˆç»“明细
    function exportDetail(data) {
        layer.confirm('确定导出月结明细 "' + data.settleNo + '" å—？', {
            shade: .1,
            skin: 'layui-layer-admin'
        }, function (i) {
            layer.close(i);
            layer.load(2);
            $.ajax({
                url: baseUrl + '/monthlySettle/detail/export/' + data.id + '/auth',
                headers: {'token': localStorage.getItem('token')},
                method: 'POST',
                success: function (res) {
                    layer.closeAll('loading');
                    if (res.code === 200) {
                        // å®šä¹‰è¡¨å¤´
                        var titles = [
                            '物料编码',
                            '物料名称',
                            '批次',
                            '品牌',
                            '期初库存',
                            '期末库存',
                            '差异数量',
                            '本期入库',
                            '本期出库'
                        ];
                        // ä½¿ç”¨ table.exportFile å¯¼å‡º
                        table.exportFile(titles, res.data, 'xls');
                        layer.msg('导出成功', {icon: 1});
                    } else if (res.code === 403) {
                        top.location.href = baseUrl + "/";
                    } else {
                        layer.msg(res.msg || '导出失败', {icon: 2});
                    }
                },
                error: function() {
                    layer.closeAll('loading');
                    layer.msg('导出失败', {icon: 2});
                }
            });
        });
    }

    // åˆ é™¤æœˆç»“记录
    function deleteSettle(data) {
        layer.confirm('确认要删除月结记录 "' + data.settleNo + '" å—？删除后将清除关联的出入库订单月结信息，可以重新进行月结。', {

 src/main/webapp/views/monthlySettle/monthlySettle.html

@@ -9,6 +9,31 @@
    <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../static/css/admin.css?v=318" media="all">
    <link rel="stylesheet" href="../../static/css/cool.css" media="all">
    <style>
        .btn-add {
            display: none;
        }

        .btn-edit {
            display: none;
        }

        .btn-complete {
            display: none;
        }

        .btn-delete {
            display: none;
        }

        .btn-export {
            display: none;
        }

        .btn-view {
            display: none;
        }
    </style>
</head>
<body>

@@ -28,10 +53,10 @@
                        </div>
                    </div>
                    <div class="layui-inline">
                        <button class="layui-btn icon-btn" lay-filter="search" lay-submit>
                        <button class="layui-btn icon-btn btn-view" lay-filter="search" lay-submit>
                            <i class="layui-icon">&#xe615;</i>搜索
                        </button>
                        <button id="startSettleBtn" class="layui-btn icon-btn layui-btn-normal">
                        <button id="startSettleBtn" class="layui-btn icon-btn layui-btn-normal btn-add">
                            <i class="layui-icon">&#xe608;</i>发起月结
                        </button>
                        <button type="button" class="layui-btn icon-btn layui-btn-primary" lay-filter="reset" lay-submit>
@@ -47,8 +72,9 @@

<!-- è¡¨æ ¼æ“ä½œåˆ— -->
<script type="text/html" id="operate">
    <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">查看明细</a>
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="delete">删除</a>
    <a class="layui-btn layui-btn-normal layui-btn-xs btn-export" lay-event="export">导出</a>
    <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">明细</a>
    <a class="layui-btn layui-btn-danger layui-btn-xs btn-delete" lay-event="delete">删除</a>
</script>

<!-- å‘起月结弹窗 -->

 src/main/webapp/views/orderPakinLog/order.html

@@ -25,6 +25,26 @@
        .layui-timeline:first-child .layui-timeline-item {
            margin-top: 30px;
        }

        .btn-add {
            display: none;
        }

        .btn-edit {
            display: none;
        }

        .btn-complete {
            display: none;
        }

        .btn-delete {
            display: none;
        }

        .btn-view {
            display: none;
        }
    </style>
</head>

@@ -66,7 +86,7 @@
                            </div>
                        </div>
                        <div class="layui-inline">
                            <button class="layui-btn icon-btn" lay-filter="tbSearch" lay-submit>
                            <button class="layui-btn icon-btn btn-view" lay-filter="tbSearch" lay-submit>
                                <i class="layui-icon">&#xe615;</i>搜索
                            </button>
                        </div>
@@ -92,7 +112,7 @@
    <!-- æ“ä½œåˆ— -->
    <script type="text/html" id="operate">
    {{# if(!d.monthlySettleId || d.monthlySettleId == 0){ }}
    <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="editOrderTime">修改业务时间</a>
    <a class="layui-btn layui-btn-primary layui-btn-xs btn-edit" lay-event="editOrderTime">修改业务时间</a>
    {{# } }}
</script>
    <script type="text/html" id="orderNoTpl">

 src/main/webapp/views/orderPakoutLog/order.html

@@ -25,6 +25,26 @@
        .layui-timeline:first-child .layui-timeline-item {
            margin-top: 30px;
        }

        .btn-add {
            display: none;
        }

        .btn-edit {
            display: none;
        }

        .btn-complete {
            display: none;
        }

        .btn-delete {
            display: none;
        }

        .btn-view {
            display: none;
        }
    </style>
</head>

@@ -66,7 +86,7 @@
                            </div>
                        </div>
                        <div class="layui-inline">
                            <button class="layui-btn icon-btn" lay-filter="tbSearch" lay-submit>
                            <button class="layui-btn icon-btn btn-view" lay-filter="tbSearch" lay-submit>
                                <i class="layui-icon">&#xe615;</i>搜索
                            </button>
                        </div>
@@ -92,7 +112,7 @@
    <!-- æ“ä½œåˆ— -->
    <script type="text/html" id="operate">
    {{# if(!d.monthlySettleId || d.monthlySettleId == 0){ }}
    <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="editOrderTime">修改业务时间</a>
    <a class="layui-btn layui-btn-primary layui-btn-xs btn-edit" lay-event="editOrderTime">修改业务时间</a>
    {{# } }}
</script>
    <script type="text/html" id="orderNoTpl">