package com.sckw.payment.model.vo.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.sckw.excel.annotation.ExcelContext;
import lombok.Getter;
import lombok.Setter;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.Date;

/**
 * 运营端导出
 *
 * @author 徐才钦
 * @date 2023-07-20 12:26
 */
@Getter
@Setter
@ExcelContext(fileName = "贸易结算订单列表", sheetName = "贸易结算订单列表")
public class SettlementTradeExportVo {
    /**
     * 主键
     */
    @ExcelProperty(value = "主键")
    private Long id;

    @ExcelProperty(value = "状态")
    private String statusLabel;
    /**
     * 结算单编号
     */
    @ExcelProperty(value = "结算单编号")
    private String stOrderNo;

    @JsonProperty("tLedgerNo")
    @ExcelProperty(value = "对账单编号")
    private String tLedgerNo;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @JsonProperty("generateTime")
    @ExcelProperty(value = "生成时间")
    private LocalDateTime generateTime;
    /**
     * 结算单名称
     */
    @ExcelProperty(value = "对账表名称")
    private String name;

    @ExcelProperty(value = "供应单位")
    private String sellFirmName;
    @ExcelProperty(value = "采购单位")
    private String purchaseFirmName;
    @ExcelProperty(value = "支付方式")
    private String tradingLabel;
    /**
     * 总应收/元
     */
    @ExcelProperty(value = "实际应收/元")
    private BigDecimal totalPrice;

    /**
     * 当前收款/元
     */
    @ExcelProperty(value = "当前收款/元")
    private BigDecimal actualPrice;
    /**
     * 剩余待收款/元
     */
    @ExcelProperty(value = "剩余待收款/元")
    private BigDecimal waitPrice;

    /**
     * 预计收款日期
     */
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @ExcelProperty(value = "预计收款日期")
    @DateTimeFormat("yyyy-MM-dd")
    private Date receiptTime;


    /**
     * 对账采购财务联系人名称
     */
    @ExcelProperty(value = "供方联系人")
    private String auditUser;

    /**
     * 对账采购财务联系人电话
     */
    @ExcelProperty(value = "供方联系电话")
    private String auditPhone;

    /**
     * 对账销售财务联系人名称
     */
    @ExcelProperty(value = "采方联系人")
    private String successUser;

    /**
     * 对账销售财务联系人电话
     */
    @ExcelProperty(value = "采方联系电话")
    private String successPhone;

    @ExcelProperty(value = "提交人")
    private String createByLabel;
}
