package com.aps.core.mapper;
|
|
import com.aps.core.domain.ApsGasPipelinePrediction;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
import org.jetbrains.annotations.NotNull;
|
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Set;
|
|
/**
|
* 管路手工气体预测数据Mapper接口
|
*
|
* @author ruoyi
|
* @date 2025-05-19
|
*/
|
public interface ApsGasPipelinePredictionMapper extends BaseMapper<ApsGasPipelinePrediction>
|
{
|
/**
|
* 查询管路手工气体预测数据
|
*
|
* @param id 管路手工气体预测数据主键
|
* @return 管路手工气体预测数据
|
*/
|
public ApsGasPipelinePrediction selectApsGasPipelinePredictionById(Long id);
|
|
/**
|
* 查询管路手工气体预测数据列表
|
*
|
* @param apsGasPipelinePrediction 管路手工气体预测数据
|
* @return 管路手工气体预测数据集合
|
*/
|
public List<ApsGasPipelinePrediction> selectApsGasPipelinePredictionList(ApsGasPipelinePrediction apsGasPipelinePrediction);
|
|
/**
|
* 新增管路手工气体预测数据
|
*
|
* @param apsGasPipelinePrediction 管路手工气体预测数据
|
* @return 结果
|
*/
|
public int insertApsGasPipelinePrediction(ApsGasPipelinePrediction apsGasPipelinePrediction);
|
|
/**
|
* 修改管路手工气体预测数据
|
*
|
* @param apsGasPipelinePrediction 管路手工气体预测数据
|
* @return 结果
|
*/
|
public int updateApsGasPipelinePrediction(ApsGasPipelinePrediction apsGasPipelinePrediction);
|
|
/**
|
* 删除管路手工气体预测数据
|
*
|
* @param id 管路手工气体预测数据主键
|
* @return 结果
|
*/
|
public int deleteApsGasPipelinePredictionById(Long id);
|
|
/**
|
* 批量删除管路手工气体预测数据
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteApsGasPipelinePredictionByIds(Long[] ids);
|
|
void deleteAll();
|
|
@Select("""
|
<script>
|
select id, factory || '##' || material_code || '##' || TO_CHAR(predict_date, 'yyyy-MM') as key
|
from aps_gas_pipeline_prediction
|
where 1 = 0
|
<if test="!facs.isEmpty()">or factory in
|
<foreach collection="facs" item="item" open="(" separator="," close=")">
|
#{item}
|
</foreach>
|
</if>
|
<if test="!facs.isEmpty()">or material_code in
|
<foreach collection="codes" item="item" open="(" separator="," close=")">
|
#{item}
|
</foreach>
|
</if>
|
</script>
|
""")
|
List<Map<String, Object>> selectByFacOrMaterial(@NotNull Set<String> facs, @NotNull Set<String> codes);
|
|
}
|
