package com.ruoyi.account.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.account.api.dto.VinManagementExcelDTO;
|
import com.ruoyi.account.api.dto.VinManagementQueryDTO;
|
import com.ruoyi.account.api.model.TVinManagement;
|
import org.apache.ibatis.annotations.Param;
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
public interface TVinManagementMapper extends BaseMapper<TVinManagement> {
|
IPage<TVinManagement> selectPageList(Page<TVinManagement> page, @Param("query") VinManagementQueryDTO query);
|
List<VinManagementExcelDTO> selectExportList(@Param("query") VinManagementQueryDTO query);
|
int countByVin(@Param("vin") String vin, @Param("excludeId") Long excludeId);
|
/** 余额原子累加(额度分配专用,null 视为 0) */
|
int addBalance(@Param("id") Long id, @Param("amount") BigDecimal amount, @Param("updateBy") Long updateBy);
|
List<TVinManagement> selectAppletVehicleList(@Param("appUserId") Long appUserId);
|
TVinManagement selectEnabledVehicle(@Param("keyword") String keyword);
|
int bindAppletVehicle(@Param("id") Long id, @Param("appUserId") Long appUserId);
|
int unbindAppletVehicle(@Param("id") Long id, @Param("appUserId") Long appUserId);
|
List<Long> selectIdsByAppUserId(@Param("appUserId") Long appUserId);
|
}
|