package com.project.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.project.system.domain.SysOrderNo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.Date;

/**
 * 订单编号Mapper接口
 *
 * @author manton
 * @date 2023-03-07
 */
public interface SysOrderNoMapper extends BaseMapper<SysOrderNo>
{

    @Update("update sys_order_no set current_no = CASE WHEN exact_date=#{exactDate} THEN current_no+1 ELSE #{INIT_CURRENT_NUMBER}  END," +
            " exact_date=#{exactDate}, update_time=#{updateTime} where id = #{id}")
    Boolean updateCurrentNo(@Param("id") Long id,
                            @Param("exactDate") String exactDate,
                            @Param("updateTime") Date updateTime,
                            @Param("INIT_CURRENT_NUMBER") Integer INIT_CURRENT_NUMBER);

}