库存调整（未完成）

pjb

2025-07-10 59faff8bcfda7d9b33e133f88b3f3e97f3d84db3

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

@@ -2,11 +2,40 @@

import com.zy.asrs.entity.WrkDetlLog;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Mapper
@Repository
public interface WrkDetlLogMapper extends BaseMapper<WrkDetlLog> {

    @Insert("insert into asr_wrk_detl_log select * from asr_wrk_detl where wrk_no=#{workNo}")
    int save(Integer workNo);

    List<WrkDetlLog> selectWrkDetlLogs(@Param("wrkNo") Integer wrkNo,
                                       @Param("orderNo") String orderNo,
                                       @Param("maktx") String maktx,
                                       @Param("model") String model,
                                       @Param("zpallet") String zpallet,
                                       @Param("volume") Double volume,
                                       @Param("modiTimeStart") Date modiTimeStart,
                                       @Param("modiTimeEnd") Date modiTimeEnd,
                                       @Param("pageNumber") Integer curr,
                                       @Param("pageSize") Integer limit);

    Long selectWrkDetlLogsTotal(@Param("wrkNo") Integer wrkNo,
                                @Param("orderNo") String orderNo,
                                @Param("maktx") String maktx,
                                @Param("model") String model,
                                @Param("zpallet") String zpallet,
                                @Param("volume") Double volume,
                                @Param("modiTimeStart") Date modiTimeStart,
                                @Param("modiTimeEnd") Date modiTimeEnd);


}