package cn.iocoder.yudao.module.crm.controller.admin.contract.vo.contract; import cn.idev.excel.annotation.ExcelIgnoreUnannotated; import cn.idev.excel.annotation.ExcelProperty; import io.swagger.v3.oas.annotations.media.Schema; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.math.BigDecimal; import java.time.LocalDateTime; import java.util.List; @Schema(description = "管理后台 - CRM 合同 Response VO") @Data @ExcelIgnoreUnannotated public class CrmContractRespVO { @Schema(description = "合同编号", requiredMode = Schema.RequiredMode.REQUIRED, example = "10430") private Long id; @Schema(description = "合同名称", requiredMode = Schema.RequiredMode.REQUIRED, example = "王五") @ExcelProperty(value = "合同名称", index = 1) private String name; @Schema(description = "合同编号", requiredMode = Schema.RequiredMode.REQUIRED, example = "20230101") @ExcelProperty(value = "合同编号", index = 0) private String no; @Schema(description = "客户编号", requiredMode = Schema.RequiredMode.REQUIRED, example = "18336") private Long customerId; @Schema(description = "客户名称", requiredMode = Schema.RequiredMode.REQUIRED, example = "18336") @ExcelProperty(value = "客户名称", index = 2) private String customerName; @Schema(description = "商机编号", example = "10864") private Long businessId; @Schema(description = "商机名称", example = "10864") @ExcelProperty(value = "商机名称", index = 3) private String businessName; @Schema(description = "最后跟进时间") @ExcelProperty(value = "最后跟进时间", index = 14) private LocalDateTime contactLastTime; @Schema(description = "负责人的用户编号", example = "25682") private Long ownerUserId; @Schema(description = "负责人名字", example = "25682") @ExcelProperty(value = "负责人", index = 15) private String ownerUserName; @Schema(description = "负责人部门") @ExcelProperty(value = "所属部门", index = 16) private String ownerUserDeptName; @Schema(description = "工作流编号", example = "1043") private String processInstanceId; @Schema(description = "审批状态", requiredMode = Schema.RequiredMode.REQUIRED, example = "0") private Integer auditStatus; @Schema(description = "合同状态名称", example = "审批中") @ExcelProperty(value = "合同状态", index = 20) private String auditStatusName; @Schema(description = "下单日期", requiredMode = Schema.RequiredMode.REQUIRED) @ExcelProperty(value = "下单时间", index = 6) private LocalDateTime orderDate; @Schema(description = "开始时间") @ExcelProperty(value = "合同开始时间", index = 7) private LocalDateTime startTime; @Schema(description = "结束时间") @ExcelProperty(value = "合同结束时间", index = 8) private LocalDateTime endTime; @Schema(description = "产品总金额", example = "19510") private BigDecimal totalProductPrice; @Schema(description = "整单折扣") private BigDecimal discountPercent; @Schema(description = "合同金额", example = "5617") @ExcelProperty(value = "合同金额(元)", index = 4) private BigDecimal totalPrice; @Schema(description = "定金金额,单位:元", example = "1000.00") @ExcelProperty(value = "定金金额(元)", index = 5) private BigDecimal depositPrice; @Schema(description = "已回款金额", example = "5617") @ExcelProperty(value = "已回款金额(元)", index = 12) private BigDecimal totalReceivablePrice; @Schema(description = "未回款金额,等于 合同金额 - 已回款金额", example = "1000.00") @ExcelProperty(value = "未回款金额(元)", index = 13) private BigDecimal unReceivablePrice; @Schema(description = "已开票金额(含审批中),统计审批通过 + 审批中的开票", example = "5617") private BigDecimal totalInvoicePrice; @Schema(description = "未开票金额,等于 合同金额 - 已开票金额", example = "1000.00") private BigDecimal unInvoicePrice; @Schema(description = "关联 ERP 销售订单编号", example = "12345") private Long orderId; @Schema(description = "ERP 销售订单单号", example = "SO001") @ExcelProperty(value = "关联订单", index = 21) private String orderNo; @Schema(description = "客户签约人编号", example = "18546") private Long signContactId; @Schema(description = "客户签约人", example = "小豆") @ExcelProperty(value = "客户签约人", index = 9) private String signContactName; @Schema(description = "公司签约人", example = "14036") private Long signUserId; @Schema(description = "公司签约人", example = "小明") @ExcelProperty(value = "公司签约人", index = 10) private String signUserName; @Schema(description = "备注", example = "你猜") @ExcelProperty(value = "备注", index = 11) private String remark; @Schema(description = "创建时间", requiredMode = Schema.RequiredMode.REQUIRED) @ExcelProperty(value = "创建时间", index = 18) private LocalDateTime createTime; @Schema(description = "创建人", example = "25682") private String creator; @Schema(description = "创建人名字", example = "test") @ExcelProperty(value = "创建人", index = 19) private String creatorName; @Schema(description = "更新时间", requiredMode = Schema.RequiredMode.REQUIRED) @ExcelProperty(value = "更新时间", index = 17) private LocalDateTime updateTime; @Schema(description = "产品列表") private List products; @Schema(description = "产品列表") @Data @NoArgsConstructor @AllArgsConstructor public static class Product { @Schema(description = "编号", requiredMode = Schema.RequiredMode.REQUIRED, example = "888") private Long id; @Schema(description = "MDM 物料编号", requiredMode = Schema.RequiredMode.REQUIRED, example = "20529") private Long itemId; @Schema(description = "物料编码", requiredMode = Schema.RequiredMode.REQUIRED, example = "ITEM001") private String itemCode; @Schema(description = "物料名称", requiredMode = Schema.RequiredMode.REQUIRED, example = "物料A") private String itemName; @Schema(description = "物料条码", example = "BAR001") private String itemBarCode; @Schema(description = "计量单位编号", example = "1") private Long itemUnitId; @Schema(description = "计量单位名称", example = "个") private String itemUnitName; @Schema(description = "物料原价", requiredMode = Schema.RequiredMode.REQUIRED, example = "100.00") private BigDecimal itemPrice; @Schema(description = "合同价格", requiredMode = Schema.RequiredMode.REQUIRED, example = "123.00") private BigDecimal contractPrice; @Schema(description = "产品数量", requiredMode = Schema.RequiredMode.REQUIRED, example = "8911") private BigDecimal count; @Schema(description = "总计价格", requiredMode = Schema.RequiredMode.REQUIRED, example = "123.00") private BigDecimal totalPrice; } }