package com.xhpc.charging.station.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * program: ruoyi
 * User: HongYun
 * Date:2021-09-30 15
 */
@Mapper
public interface XhpcDownCodeMapper {

    List<Map<String, Object>> selectStationsBy(@Param(value = "operatorId")Long operatorId,@Param(value = "chargingStationId")Long chargingStationId,@Param(value = "stationName") String stationName,@Param("type") Integer type,@Param("userId") Long userId,@Param("tenantId") String tenantId);

    List<Map<String, Object>> selectPilesBy(@Param(value = "stationId") Long stationId);

    /**
     * 用于excel表格中的信息，
     * 根据桩的id，查找出未删除的对应的终端信息
     *
     * @param pileId 桩的id
     * @return List<Map < String, Object>> 一个装着每条终端数据的List集合
     * @author WH
     * @date 2021/11/25 13:46
     * @since version-1.0
     */
    List<Map<String, Object>> selectExcelDataByPileId(@Param("pileId") Long pileId);

    /**
     * 查询出桩下面的未删除的终端的图片url地址
     *
     * @param pileId 桩的id
     * @return List<String> 一个装着每个终端url图片的List
     * @author WH
     * @date 2021/11/25 14:02
     * @since version-1.0
     */
    List<String> selectUrlsByPile(@Param(value = "pileId") Long pileId);

    /**
     * 查询出场站下面的未删除的终端的图片url地址
     *
     * @param stationId 场站id
     * @return 返回装有终端url的List
     * @author WH
     * @date 2021/11/25 15:24
     * @since version-1.0
     */
    List<String> selectUrlsByStation(@Param(value = "stationId") Long stationId);

    /**
     * 查找场站下方有图片的终端的相关的信息存入excel表格中
     *
     * @param stationId 场站id
     * @return 装有每一个终端信息的List集合
     * @author WH
     * @date 2021/11/25 15:11
     * @since version-1.0
     */
    List<Map<String, Object>> selectExcelDataByStationId(@Param(value = "stationId") Long stationId);

}
