库存冻结

Junjie

2023-05-13 5b957de9535cf32876777eba52ce68e10b4ff24b

库存冻结

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

@@ -67,4 +67,6 @@

    List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);//通过订单号、物料号、物料名称、规格、库位号进行模糊搜索

    List<LocDetl> selectByLocNo(String locNo);

}

 src/main/java/com/zy/asrs/service/LocDetlService.java

@@ -60,4 +60,6 @@

    List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);//通过订单号、物料号、物料名称、规格、库位号进行模糊搜索

    List<LocDetl> selectByLocNo(String locNo);

}

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

@@ -121,4 +121,9 @@
    public List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo) {
        return this.baseMapper.searchByLike(orderNo, matnr, maktx, specs, locNo);
    }

    @Override
    public List<LocDetl> selectByLocNo(String locNo) {
        return this.baseMapper.selectByLocNo(locNo);
    }
}

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

@@ -173,6 +173,19 @@
            if (sign){
                break;
            }

            //检测出库的货物中是否有状态为禁止的货物。
            for (LocDetl locDetl : locDetlService.selectByLocNo(locNo)) {
                Mat mat = matService.selectByMatnr(locDetl.getMatnr());
                if (mat == null) {
                    continue;
                }
                if (mat.getStatus() == 0) {
                    th="库位号："+locNo+" 有禁止出库的货物！";
                    throw new CoolException("出库失败；"+th);
                }
            }

            List<String> groupInsideLoc = Utils.getGroupInsideLoc(locNo);
            if (!Cools.isEmpty(groupInsideLoc)) {
                for (String insideLoc : groupInsideLoc) {

 src/main/resources/mapper/LocDetlMapper.xml

@@ -341,4 +341,10 @@
            and maktx like '%' + #{maktx} + '%';
        </if>
    </select>

    <select id="selectByLocNo" resultMap="BaseResultMap">
        select * from asr_loc_detl
        where 1=1
        and loc_no = #{locNo}
    </select>
</mapper>

 src/main/webapp/static/js/mat/mat.js

@@ -8,6 +8,7 @@
        ,{field: 'storeMax', align: 'center',title: '库存上限',width: 90}
        ,{field: 'storeMin', align: 'center',title: '库存下限',width: 90}
        ,{field: 'storeMaxDate', align: 'center',title: '库龄上限(天)',width: 90}
        ,{field: 'status$', align: 'center',title: '状态'}
    ];
    cols.push.apply(cols, matCols);
    cols.push(

 src/main/webapp/views/mat/mat.html

@@ -178,6 +178,7 @@
        <input name="createBy" type="hidden">
        <input name="updateTime$" type="hidden">
        <input name="updateBy" type="hidden">
        <input name="status" type="hidden">
        <div class="layui-row">


@@ -208,6 +209,15 @@
                        <input name="storeMaxDate" placeholder="库龄上限(天)" type="number" class="layui-input">
                    </div>
                </div>
                <div class="layui-form-item">
                    <label class="layui-form-label">状态:</label>
                    <div class="layui-input-block">
                        <select name="status">
                            <option value="1">正常</option>
                            <option value="0" selected>禁用</option>
                        </select>
                    </div>
                </div>

            </div>