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 { @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"); } }