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

package com.template.mapper;

import com.template.model.Records;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
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 RecordsMapper extends BaseMapper<Records> {

    @Select("select 'Electric' type, date_format(update_at, '%Y-%m') mon,sum(value) total from records where `type` ='Electric' and device_id =#{device_id}" +
            "  group by date_format(update_at, '%Y-%m') order by date_format(update_at, '%Y-%m') desc limit 6")
    List<Map<String, Object>> listElectric(@Param("device_id") String device_id);

    @Select("select 'Water' type, date_format(update_at, '%Y-%m') mon,sum(value) total from records where `type` ='Water' and device_id =#{device_id} group by date_format(update_at, '%Y-%m')" +
            " order by date_format(update_at, '%Y-%m') desc limit 6")
    List<Map<String, Object>> listWater(String device_id);
}