package com.by4cloud.platformx.business.entity;
|
|
import cn.hutool.core.util.StrUtil;
|
import com.by4cloud.platformx.common.data.mybatis.BaseModel;
|
import io.swagger.v3.oas.annotations.media.Schema;
|
import jakarta.persistence.Column;
|
import jakarta.persistence.Entity;
|
import lombok.Data;
|
import org.hibernate.annotations.Table;
|
|
import java.math.BigDecimal;
|
|
/**
|
* 2026年10月9日 10:13:52
|
* syt
|
*/
|
@Data
|
@Entity//加了才能自动生成表
|
@Table(appliesTo="annual_target",comment = "单位清欠指标")//给表加注释
|
@jakarta.persistence.Table(name = "annual_target")//数据库创建的表明
|
public class AnnualTarget extends BaseModel<AnnualTarget> {
|
|
@Schema(description = "类型")
|
@Column(columnDefinition="char(1) comment '类型 1/三年 2/三年以上'")
|
private String planType;
|
|
@Schema(description = "年")
|
@Column(columnDefinition="varchar(12) comment '年'")
|
private String planYear;
|
|
@Schema(description = "1月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '1月金额'")
|
private BigDecimal janAmount;
|
|
@Schema(description = "2月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '2月金额'")
|
private BigDecimal febAmount;
|
|
@Schema(description = "3月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '3月金额'")
|
private BigDecimal marAmount;
|
|
@Schema(description = "4月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '4月金额'")
|
private BigDecimal aprAmount;
|
|
@Schema(description = "5月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '5月金额'")
|
private BigDecimal mayAmount;
|
|
@Schema(description = "6月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '6月金额'")
|
private BigDecimal junAmount;
|
|
@Schema(description = "7月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '7月金额'")
|
private BigDecimal julAmount;
|
|
@Schema(description = "8月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '8月金额'")
|
private BigDecimal augAmount;
|
|
@Schema(description = "9月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '9月金额'")
|
private BigDecimal sepAmount;
|
|
@Schema(description = "10月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '10月金额'")
|
private BigDecimal octAmount;
|
|
@Schema(description = "11月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '11月金额'")
|
private BigDecimal novAmount;
|
|
@Schema(description = "12月金额")
|
@Column(columnDefinition = "decimal(14,2) comment '12月金额'")
|
private BigDecimal decAmount;
|
|
public BigDecimal getTotalAmount() {
|
// 使用 Optional 或三元运算符处理 null 值,防止 NullPointerException
|
BigDecimal b1 = janAmount == null ? BigDecimal.ZERO : janAmount;
|
BigDecimal b2 = febAmount == null ? BigDecimal.ZERO : febAmount;
|
BigDecimal b3 = marAmount == null ? BigDecimal.ZERO : marAmount;
|
BigDecimal b4 = aprAmount == null ? BigDecimal.ZERO : aprAmount;
|
BigDecimal b5 = mayAmount == null ? BigDecimal.ZERO : mayAmount;
|
BigDecimal b6 = junAmount == null ? BigDecimal.ZERO : junAmount;
|
BigDecimal b7 = julAmount == null ? BigDecimal.ZERO : julAmount;
|
BigDecimal b8 = augAmount == null ? BigDecimal.ZERO : augAmount;
|
BigDecimal b9 = sepAmount == null ? BigDecimal.ZERO : sepAmount;
|
BigDecimal b10 = octAmount == null ? BigDecimal.ZERO : octAmount;
|
BigDecimal b11 = novAmount == null ? BigDecimal.ZERO : novAmount;
|
BigDecimal b12 = decAmount == null ? BigDecimal.ZERO : decAmount;
|
|
return b1.add(b2).add(b3).add(b4).add(b5).add(b6).add(b7).add(b8).add(b9).add(b10).add(b11).add(b12);
|
}
|
|
public BigDecimal getMonthAmount(String month) {
|
// 使用 Optional 或三元运算符处理 null 值,防止 NullPointerException
|
if (StrUtil.equals("1",month)||StrUtil.equals("01",month)){
|
return janAmount;
|
}
|
if (StrUtil.equals("2",month)||StrUtil.equals("02",month)){
|
return febAmount;
|
}
|
if (StrUtil.equals("3",month)||StrUtil.equals("03",month)){
|
return marAmount;
|
}
|
if (StrUtil.equals("4",month)||StrUtil.equals("04",month)){
|
return aprAmount;
|
}
|
if (StrUtil.equals("5",month)||StrUtil.equals("05",month)){
|
return mayAmount;
|
}
|
if (StrUtil.equals("6",month)||StrUtil.equals("06",month)){
|
return junAmount;
|
}
|
if (StrUtil.equals("7",month)||StrUtil.equals("07",month)){
|
return julAmount;
|
}
|
if (StrUtil.equals("8",month)||StrUtil.equals("08",month)){
|
return augAmount;
|
}
|
if (StrUtil.equals("9",month)||StrUtil.equals("09",month)){
|
return sepAmount;
|
}
|
if (StrUtil.equals("10",month)){
|
return octAmount;
|
}
|
if (StrUtil.equals("11",month)){
|
return novAmount;
|
}
|
if (StrUtil.equals("12",month)){
|
return decAmount;
|
}
|
return new BigDecimal("0");
|
}
|
}
|