| | |
|---|
| | | @Repository |
|---|
| | | public interface WrkMastLogMapper extends BaseMapper<WrkMastLog> { |
|---|
| | | |
|---|
| | | @Insert("insert into asr_wrk_mast_log select * from asr_wrk_mast where wrk_no=#{workNo}") |
|---|
| | | @Insert("INSERT INTO asr_wrk_mast_log (" + |
|---|
| | | "wrk_no, inv_wh, ymd, mk, whs_type, wrk_sts, io_type, crn_no, sheet_no, io_pri, wrk_date, loc_no, sta_no, source_sta_no, source_loc_no, loc_sts, " + |
|---|
| | | "picking, link_mis, online_yn, upd_mk, exit_mk, plt_type, batch_seq, empty_mk, io_time, ctn_type, packed, ove_mk, mtn_type, user_no, crn_str_time, " + |
|---|
| | | "crn_end_time, plc_str_time, crn_pos_time, load_time, exp_time, ref_wrkno, ref_iotime, modi_user, modi_time, appe_user, appe_time, pause_mk, " + |
|---|
| | | "error_time, error_memo, ctn_kind, manu_type, memo_m, sc_weight, log_mk, log_err_time, log_err_memo, barcode, Pdc_type, ctn_no, full_plt, pre_have, take_none) " + |
|---|
| | | "SELECT " + |
|---|
| | | "wrk_no, inv_wh, ymd, mk, whs_type, wrk_sts, io_type, crn_no, sheet_no, io_pri, wrk_date, loc_no, sta_no, source_sta_no, source_loc_no, loc_sts, " + |
|---|
| | | "picking, link_mis, online_yn, upd_mk, exit_mk, plt_type, batch_seq, empty_mk, io_time, ctn_type, packed, ove_mk, mtn_type, user_no, crn_str_time, " + |
|---|
| | | "crn_end_time, plc_str_time, crn_pos_time, load_time, exp_time, ref_wrkno, ref_iotime, modi_user, modi_time, appe_user, appe_time, pause_mk, " + |
|---|
| | | "error_time, error_memo, ctn_kind, manu_type, memo, sc_weight, log_mk, log_err_time, log_err_memo, barcode, Pdc_type, ctn_no, full_plt, pre_have, take_none " + |
|---|
| | | "FROM asr_wrk_mast WHERE wrk_no=#{workNo}") |
|---|
| | | int save(Integer workNo); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 出库 101 下该单号已出现的 plt_type（历史表） |
|---|
| | | * 出库 101 下该单号同批次已出现的 plt_type（历史表） |
|---|
| | | */ |
|---|
| | | @Select("SELECT plt_type FROM asr_wrk_mast_log WHERE io_type = 101 AND plt_type IS NOT NULL AND plt_type > 0 AND user_no = #{userNo}") |
|---|
| | | List<Integer> listOutboundPltTypesByUserNo(@Param("userNo") String userNo); |
|---|
| | | @Select("SELECT plt_type FROM asr_wrk_mast_log WHERE io_type = 101 AND plt_type IS NOT NULL AND plt_type > 0 AND user_no = #{userNo} AND ((#{batchSeq} IS NULL AND batch_seq IS NULL) OR batch_seq = #{batchSeq})") |
|---|
| | | List<Integer> listOutboundPltTypesByUserNo(@Param("userNo") String userNo, @Param("batchSeq") String batchSeq); |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询库存移动流水记录 |
|---|
