package com.skua.modules.threedimensional.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.threedimensional.entity.DataCountDay;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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

/**
 * 日数据
 */
public interface DataCountDayMapper extends BaseMapper<DataCountDay> {

    List<Map<String, Object>> currentDrain(@Param("time") String time);


    @Select("select item_alias as itemAlias,item_code as itemCode,item_value as itemValue,friv.depart_id,data_time dataTime from f_report_item fri \n" +
            "\tleft join f_report_itemv friv on fri.id = friv.reit_id ${ew.customSqlSegment}")
    List<Map<String, Object>> getFillCodeValue(@Param(Constants.WRAPPER) QueryWrapper queryWrapper);

    int updateByFactoryAndDate(@Param("dataCountDay") DataCountDay dataCountDay);

    int updateFillCountByFactoryAndDate(@Param("dataCountDay") DataCountDay dataCountDay);

    List<Map<String, Object>> biochemicalForFactory(@Param("startTime") String startTime, @Param("endTime") String endTime);
}