package com.ruoyi.device.mapper;
|
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
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.dto.DeviceTypeDetail;
|
import com.ruoyi.account.dto.DeviceTypeDistributionVO;
|
import com.ruoyi.device.dto.DeviceLedgerDto;
|
import com.ruoyi.device.execl.DeviceLedgerExeclDto;
|
import com.ruoyi.device.pojo.DeviceLedger;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
@Mapper
|
public interface DeviceLedgerMapper extends BaseMapper<DeviceLedger> {
|
|
IPage<DeviceLedgerDto> queryPage(Page page, @Param("deviceLedger") DeviceLedgerDto deviceLedgerDto);
|
|
List<DeviceLedgerExeclDto> deviceLedgerExportList(DeviceLedger deviceLedger);
|
|
@InterceptorIgnore(tenantLine = "true")
|
DeviceLedger selectById1(Long id);
|
|
/**
|
* 按年份统计设备类型分布
|
* @param year 传入的年份（如2026）
|
* @return 各类型的数量和金额
|
*/
|
List<DeviceTypeDetail> getDeviceTypeDistributionByYear(@Param("year") Integer year);
|
}
|
