
package org.sky.scientific.excel;


import lombok.Data;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import java.io.Serializable;
import java.io.Serial;
import java.math.BigDecimal;


/**
 * 技术人员工资表 Excel实体类
 *
 * @author Kd
 * @since 2025-06-19
 */
@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class SalaryExcel implements Serializable {

	@Serial
	private static final long serialVersionUID = 1L;

	@ColumnWidth(20)
	@ExcelProperty("主键")
	private Long id;

	@ColumnWidth(20)
	@ExcelProperty("租户ID")
	private String tenantId;

	@ColumnWidth(20)
	@ExcelProperty("姓名")
	private String name;

	@ColumnWidth(20)
	@ExcelProperty("工号")
	private String number;

	@ColumnWidth(20)
	@ExcelProperty("身份证号码")
	private String identityCard;

	@ColumnWidth(20)
	@ExcelProperty("所属年月，只需要年份，如2025")
	private String yearAndMonth;

	@ColumnWidth(20)
	@ExcelProperty("部门")
	private String department;

	@ColumnWidth(20)
	@ExcelProperty("人员类型")
	private String personnelType;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均工资(元)")
	private BigDecimal averageMonthlySalary;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分养老保险")
	private BigDecimal pensionInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分医疗保险")
	private BigDecimal medicalInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分失业保险")
	private BigDecimal unemploymentInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分工伤保险")
	private BigDecimal injuryInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分生育保险")
	private BigDecimal maternityInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分社保合计(元)")
	private BigDecimal socialInsurance;

	@ColumnWidth(20)
	@ExcelProperty("上一年度月均单位承担部分公积金")
	private BigDecimal providentFund;

	@ColumnWidth(20)
	@ExcelProperty("台计(元)")
	private BigDecimal total;

}
