cn.foxtech.common.entity.service.devicehistory.DeviceHistoryEntityService Maven / Gradle / Ivy

Go to download
package cn.foxtech.common.entity.service.devicehistory;


import cn.foxtech.common.entity.constant.BaseVOFieldConstant;
import cn.foxtech.common.entity.constant.Constants;
import cn.foxtech.common.entity.constant.DeviceHistoryVOFieldConstant;
import cn.foxtech.common.entity.service.mybatis.LogEntityService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.util.Map;

@Component
public class DeviceHistoryEntityService extends LogEntityService {
    @Autowired(required = false)
    private DeviceHistoryPoMapper mapper;


    /**
     * 子类将自己的mapper绑定到父类上
     */
    public void bindMapper() {
        super.mapper = this.mapper;
    }

    public String getEntityType() {
        return Constants.HistoryEntity;
    }

    private QueryWrapper makeQueryWrapper(Map param) {
        QueryWrapper queryWrapper = new QueryWrapper<>();

        for (Map.Entry entry : param.entrySet()) {
            String key = entry.getKey();
            Object value = entry.getValue();

            BaseVOFieldConstant.makeQueryWrapper(queryWrapper, key, value);


            if (key.equals(DeviceHistoryVOFieldConstant.field_device_id)) {
                queryWrapper.last("device_id " + value);
            }
            if (key.equals(DeviceHistoryVOFieldConstant.field_object_name)) {
                queryWrapper.last("object_name " + value);
            }
        }

        return queryWrapper;
    }

    public Long selectCount(Map param) {
        QueryWrapper queryWrapper = this.makeQueryWrapper(param);
        return mapper.selectCount(queryWrapper);
    }

    /**
     * 删除旧数据，只保留少数的最新的部分数据
     *
     * @param retainCount 需要保留的数据数量
     */
    public void delete(int retainCount) {
        Integer sumCount = mapper.executeSelectCount("SELECT COUNT(1) FROM  tb_device_history");
        if (sumCount <= retainCount) {
            return;
        }

        // 删除旧记录
        String sql = String.format("DELETE FROM  tb_device_history order BY id LIMIT  %d", sumCount - retainCount);
        mapper.executeDelete(sql);
    }
}