单据管理一键导出所有数据

pang.jiabao

2025-02-07 7726f938fda4aee9dffd188c565e715a6f17a7ff

单据管理一键导出所有数据

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

@@ -12,6 +12,7 @@
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.param.OrderDomainParam;
import com.zy.asrs.entity.result.OrderDetlVo;
import com.zy.asrs.mapper.OrderDetlMapper;
import com.zy.asrs.service.*;
import com.zy.common.CodeRes;
import com.zy.common.model.DetlDto;
@@ -52,6 +53,9 @@

    @Resource
    private UserService userService;

    @Resource
    private OrderDetlMapper orderDetlMapper;

    @RequestMapping(value = "/order/nav/list/auth")
    @ManagerAuth
@@ -470,6 +474,20 @@
                .doWrite(orderDetlVos);
    }

    @PostMapping (value = "/order/exportAll/auth")
    @ManagerAuth
    public R export() {

        User user = getUser();
        Long userId = null;
        if (user.getRoleId() != 2 && user.getRoleId() != 24) {
            userId = user.getId();
        }
        List<OrderDetlExcelVo> orderDetlExcelVoList = orderDetlMapper.selectExportExcelAllDataList(userId);

        return R.ok(orderDetlExcelVoList);
    }

    @RequestMapping(value = "/order/list/all")
    public R orderList() {


 src/main/java/com/zy/asrs/entity/OrderDetlExcelVo.java

New file
@@ -0,0 +1,115 @@
package com.zy.asrs.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotations.TableField;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;

@Data
public class OrderDetlExcelVo implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 单据编号
     */
    @ApiModelProperty(value= "单据编号")
    @TableField("order_no")
    @ExcelProperty({"单据", "单据编号"})
    private String orderNo;


    /**
     * 数量
     */
    @ApiModelProperty(value= "数量")
    @ExcelProperty({"单据", "数量"})
    private Double anfme;

    /**
     * 作业数量
     *
     *  入库 : 组托完成，组托档、工作档、入库完成数量
     *  出库 : 工作档、出库完成数量
     */
    @ApiModelProperty(value= "作业数量")
    @TableField("work_qty")
    @ExcelProperty({"单据", "作业数量"})
    private Double workQty;

    /**
     * 完成数量
     *
     *  入库 : qty 👆
     *  出库 : qty 👆
     */
    @ApiModelProperty(value= "完成数量")
    @ExcelProperty({"单据", "完成数量"})
    private Double qty;

    /**
     * 商品编码
     */
    @ApiModelProperty(value= "商品编码")
    @ExcelProperty({"单据", "商品编码"})
    private String matnr;

    /**
     * 商品名称
     */
    @ApiModelProperty(value= "商品名称")
    @ExcelProperty({"单据", "商品名称"})
    private String maktx;

    /**
     * 规格
     */
    @ApiModelProperty(value= "规格")
    @ExcelProperty({"单据", "规格"})
    private String specs;

    /**
     * 重量
     */
    @ApiModelProperty(value= "重量")
    @ExcelProperty({"单据", "重量"})
    private Double weight;

    /**
     * 拥有者
     */
    @ApiModelProperty(value= "拥有者 1: 杰克   ")
    @ExcelProperty({"单据", "货主ID"})
    private Integer owner;

    /**
     * 货物形态:0：代采、1：仓储
     */
    @ApiModelProperty(value= "货物形态:0：代采、1：仓储")
    private Integer payment;
//
//
//    public String getOwner$(){
//        LocOwnerService service = SpringUtils.getBean(LocOwnerService.class);
//        LocOwner locOwner = service.selectById(this.owner);
//        if (!Cools.isEmpty(locOwner)){
//            return String.valueOf(locOwner.getOwner());
//        }
//        return null;
//    }
//
//    public String getPayment$(){
//        if (null == this.payment){ return null; }
//        switch (this.payment){
//            case 1:
//                return "仓储";
//            case 0:
//                return "代采";
//            default:
//                return String.valueOf(this.payment);
//        }
//    }

}

 src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java

@@ -2,6 +2,7 @@

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.OrderDetl;
import com.zy.asrs.entity.OrderDetlExcelVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
@@ -38,4 +39,10 @@
    Integer checkAllDetlFinish(@Param("orderNo") String orderNo);

    Integer sameOrderComb(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch);

    /**
     * 查询导出所有单据到excel所需要的数据
     * @param userId 根据权限只能查询当前用户创建的单子
     */
    List<OrderDetlExcelVo> selectExportExcelAllDataList(@Param("userId") Long userId);
}

 src/main/resources/mapper/OrderDetlMapper.xml

@@ -146,6 +146,30 @@
        and matnr = #{matnr}
        and batch = #{batch}
    </select>
    <select id="selectExportExcelAllDataList" resultType="com.zy.asrs.entity.OrderDetlExcelVo">
        select
            mo.order_no orderNo,
            md.anfme ,
            md.work_qty workQty,
            md.qty ,
            md.matnr ,
            md.maktx ,
            md.specs ,
            md.weight ,
            md.owner ,
            md.payment
        from
            man_order mo
                left join man_order_detl md on
                mo.id = md.order_id
        where mo.status = 1
        <if test="userId != null and userId != ''">
            and mo.create_by = #{userId}
        </if>
        order by
            mo.settle asc,
            mo.create_time desc
    </select>

    <update id="increase">
        update man_order_detl

 src/main/webapp/static/js/order/order.js

@@ -82,6 +82,30 @@
        insTb.reload({where: data.field, page: {curr: 1}});
    });

    // 导出所有
    form.on('submit(exportAll)', function (data) {
        layer.closeAll();
        layer.load(1, {shade: [0.1,'#fff']});
        $.ajax({
            url: baseUrl+"/order/exportAll/auth",
            headers: {'token': localStorage.getItem('token')},
            data: {},
            dataType:'json',
            contentType:'application/json;charset=UTF-8',
            method: 'POST',
            success: function (res) {
                if (res.code === 200) {
                    table.exportFile(['单据编号','数量','作业数量','完成数量','商品编码','商品名称','规格','重量','货主id','货物形态id'],res.data,'xls');
                } else if (res.code === 403) {
                    top.location.href = baseUrl+"/";
                } else {
                    layer.msg(res.msg)
                }
            }
        });
        layer.closeAll('loading');
    });

    // 添加
    $("#orderAddBtn").click(function () {
        showEditModel();

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

@@ -76,6 +76,9 @@
                        </div>
                    </div>
                    <div class="layui-inline">
                        <button class="layui-btn icon-btn" lay-filter="exportAll" lay-submit>
                            <i class="layui-icon">&#xe67d;</i>导出所有
                        </button>
                        <button class="layui-btn icon-btn" lay-filter="tbSearch" lay-submit>
                            <i class="layui-icon">&#xe615;</i>搜索
                        </button>