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);
}