package com.zy.asrs.mapper;

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

@Mapper
@Repository
public interface WaitPakinLogMapper extends BaseMapper<WaitPakinLog> {

    @Insert("insert into cust_wait_pakin_log (zpallet, anfme, loc_no, matnr, maktx, batch, order_no, origin, freq_type, manu, specs, model, color, brand, unit, price, sku, units, barcode, manu_date, item_num, safe_qty, weight, man_length, volume, three_code, supp, supp_code, be_batch, dead_time, dead_warn, source, inspect, danger, status, io_status, modi_time, modi_user, appe_time, appe_user, memo, standby1, standby2, standby3, box_type1, box_type2, box_type3) " +
            "select zpallet, anfme, loc_no, matnr, maktx, batch, order_no, origin, freq_type, manu, specs, model, color, brand, unit, price, sku, units, barcode, manu_date, item_num, safe_qty, weight, man_length, volume, three_code, supp, supp_code, be_batch, dead_time, dead_warn, source, inspect, danger, status, io_status, modi_time, modi_user, appe_time, appe_user, memo, standby1, standby2, standby3, box_type1, box_type2, box_type3 from cust_wait_pakin where zpallet=#{zpallet}")
    int save(@Param("zpallet") String zpallet);

}