修改补片审核

廖井涛

2024-03-07 012a7061f18eaa5524747dc60faae131831793fe

修改补片审核

 north-glass-erp/src/main/java/com/example/erp/service/pp/ReplenishService.java

@@ -99,7 +99,8 @@

    public Boolean updateReplenish(Map<String,Object> object) {
        boolean saveState = true;

        Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
        try {
        String userName = "";
        String userId = "";
        if (object.get("userName") != null) {
@@ -119,6 +120,16 @@
            }
        }

        } catch (Exception e) {
            TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
            //将异常传入数据库
            SysError sysError = new SysError();
            sysError.setError(e.toString());
            sysError.setFunc("saveOrder");
            sysErrorService.insert(sysError);
            saveState = false;

        }

        return saveState;


 north-glass-erp/src/main/resources/mapper/pp/PatchLogMapper.xml

@@ -89,7 +89,10 @@
    </update>

    <update id="updateOrderProcessDetail"  >
        update pp.patch_log set reviewer=#{userName},review_status=1,update_time=now() where id=#{patchLog.id}
        update sd.order_process_detail set reporting_work_num=reporting_work_num-#{patchLog.patchNum} where order_id=#{patchLog.orderId} and
        order_number=#{patchLog.orderSort} and technology_number=#{patchLog.technologyNumber} and id <![CDATA[<]]> (select a.opdid from(select id as opdid from
        sd.order_process_detail opd where opd.order_id=#{patchLog.orderId} and opd.order_number=#{patchLog.orderSort} and opd.technology_number=#{patchLog.technologyNumber}
        and process=#{patchLog.patchProcesses}) as a)
    </update>

    <update id="updateDamageDetails"  >

 north-glass-erp/target/classes/mapper/pp/PatchLogMapper.xml

@@ -88,6 +88,13 @@
        update pp.patch_log set reviewer=#{userName},review_status=1,update_time=now() where id=#{patchLog.id}
    </update>

    <update id="updateOrderProcessDetail"  >
        update sd.order_process_detail set reporting_work_num=reporting_work_num-#{patchLog.patchNum} where order_id=#{patchLog.orderId} and
        order_number=#{patchLog.orderSort} and technology_number=#{patchLog.technologyNumber} and id <![CDATA[<]]> (select a.opdid from(select id as opdid from
        sd.order_process_detail opd where opd.order_id=#{patchLog.orderId} and opd.order_number=#{patchLog.orderSort} and opd.technology_number=#{patchLog.technologyNumber}
        and process=#{patchLog.patchProcesses}) as a)
    </update>

    <update id="updateDamageDetails"  >
        update pp.damage_details set quantity=quantity+#{patchLog.patchNum},patch_status=1 where id=#{patchLog.reviewer}
    </update>