package com.tievd.jyz.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.tievd.jyz.dto.UpgradeRecordDTO;
|
import com.tievd.jyz.entity.UpgradeRecord;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* UpgradeRecord
|
* @author cube
|
* @since 2023-02-27
|
* @version V2.0.0
|
*/
|
public interface UpgradeRecordMapper extends BaseMapper<UpgradeRecord> {
|
|
@Select("select a.*, td.name deviceName, sd.depart_name departName from (select * from t_upgrade_record ${ew.customSqlSegment}) a left join t_device td on a.device_sn = td.sn left join sys_depart sd on td.org_code = sd.org_code order by a.issue_time desc")
|
IPage<UpgradeRecordDTO> tables(Page<UpgradeRecord> page, @Param("ew") QueryWrapper<UpgradeRecord> queryWrapper);
|
}
|
