package com.hb.proj.base.service;

import java.util.Date;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.hb.proj.model.AlarmDefinePO;
import com.hb.proj.model.AlarmDefineVO;
import com.hb.xframework.dao.core.SpringJdbcDAO;
import com.hb.xframework.dao.util.UUIDHexGenerator;

@Service
public class AlarmDefineService {

	@Autowired
	private SpringJdbcDAO  dao;
	
	public List<AlarmDefineVO> loadByHolder(String holderId) {
		String sql="""
				select alarm_id,alarm_desc,alarm_source,alarm_express,express_desc,alarm_mode,alarm_grade,
				alm.using_if,alm.modify_time,alm.modify_by,
				ifnull(wp.param_name,w.well_name) alarm_source_name
				from tzl_alarm alm
				left join tzl_well_param wp on alm.alarm_source=wp.param_id
				left join tzl_well w on alm.alarm_source=w.well_id
				where alm.del_if=false and alm.alarm_source=?
				""";
		return dao.queryForList(sql, AlarmDefineVO.class, holderId);
	}
	
	
	public String add(AlarmDefinePO alarm) {
		UUIDHexGenerator uuid=UUIDHexGenerator.getInstance();
		alarm.setAlarmId(uuid.generate());
		alarm.setModifyTime(new Date());
		alarm.setDelIf(false);
		dao.insert(alarm, "tzl_alarm");
		return alarm.getAlarmId();
	}
	
	public boolean delete(String alarmId) {
		dao.exeUpdate("update tzl_alarm set del_if=true where alarm_id=?",alarmId);
		return true;
	}
	
	public boolean update(AlarmDefinePO alarm) {
		alarm.setModifyTime(new Date());
		alarm.setDelIf(false);
		dao.update(alarm, "tzl_alarm", "alarm_id");
		return true;
	}
}