package com.doumee.dao.business;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.doumee.dao.business.model.Sites;
|
import com.doumee.dao.business.web.request.SitesMonitorDTO;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @author 江蹄蹄
|
* @date 2023/09/27 18:06
|
*/
|
public interface SitesMapper extends BaseMapper<Sites> {
|
|
|
/**
|
* @return
|
*/
|
@Select("SELECT \n" +
|
"sites.id,\n" +
|
"sites.name as name,\n" +
|
"sites.code as code,\n" +
|
"count(l.id) as lid,\n" +
|
"count(l.bike_code ) as lbikeCount\n" +
|
"from \n" +
|
"sites sites\n" +
|
"LEFT JOIN locks l on sites.id = l.site_id\n" +
|
"GROUP BY sites.id ")
|
SitesMonitorDTO getSitesMonitorDTO();
|
|
}
|
