package com.casic.missiles.mapper.customer;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.casic.missiles.model.customer.CustomerAdviceInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CustomerAdviceMapper extends BaseMapper<CustomerAdviceInfo> {

    @Select("SELECT IFNULL(max(RIGHT(advice_no, 12)), 0) from customer_advice_info  ")
    Long selectMaxAdviceNo();

}
