baofeng/src/main/java/com/template/mapper/RepairsMapper.java

package com.template.mapper;

import com.template.model.Repairs;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2024-06-18
 */
@Mapper
@Component
public interface RepairsMapper extends BaseMapper<Repairs> {

    @Select("select r.*,d.name dname,u.name uname from repairs r ,devices d ,users u where \n" +
            "r.device_id =d.id and u.id=r.user_id and r.deleted =0 and r.device_id=#{deviceId}")
    List<Map<String, Object>> listRepair(String deviceId);
}