From 7ecdc67dfb92b63bdc742e5c95d62bf9774cbd7f Mon Sep 17 00:00:00 2001 From: feiyu02 <risaku@163.com> Date: 星期一, 13 十一月 2023 16:06:24 +0800 Subject: [PATCH] 1. 新增风险值的计算逻辑; --- src/main/java/com/flightfeather/monitor/domain/ds1/repository/RiskValueRep.kt | 41 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 41 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/flightfeather/monitor/domain/ds1/repository/RiskValueRep.kt b/src/main/java/com/flightfeather/monitor/domain/ds1/repository/RiskValueRep.kt new file mode 100644 index 0000000..dc3e5d6 --- /dev/null +++ b/src/main/java/com/flightfeather/monitor/domain/ds1/repository/RiskValueRep.kt @@ -0,0 +1,41 @@ +package com.flightfeather.monitor.domain.ds1.repository + +import com.flightfeather.monitor.domain.ds1.entity.RiskValue +import com.flightfeather.monitor.domain.ds1.mapper.RiskValueMapper +import com.github.pagehelper.PageHelper +import org.springframework.stereotype.Repository +import tk.mybatis.mapper.entity.Example +import java.time.LocalDate + +@Repository +class RiskValueRep(private val riskValueMapper: RiskValueMapper) { + + /** + * 鑾峰彇鏈�鏂颁竴鏉¤褰� + */ + fun findLatestData(type: String): RiskValue? { + val p = PageHelper.startPage<RiskValue>(1, 1) + riskValueMapper.selectByExample(Example(RiskValue::class.java).apply { + createCriteria().andEqualTo("type", type) + orderBy("lst").desc() + }) + return if (p.isNotEmpty()) { + p[0] + } else { + null + } + } + + fun insert(list: List<RiskValue>): Int { + return riskValueMapper.insertList(list) + } + + fun select(mnCode: String, date: LocalDate): List<RiskValue?> { + val s = date.withDayOfMonth(1).atStartOfDay() + val e = s.plusMonths(1).minusSeconds(1) + return riskValueMapper.selectByExample(Example(RiskValue::class.java).apply { + createCriteria().andEqualTo("mnCode", mnCode) + .andBetween("lst", s, e) + }) + } +} \ No newline at end of file -- Gitblit v1.9.3