4.23

package com.example.baoli.entity;

import jakarta.persistence.*;
import java.time.LocalDateTime;

@Entity
@Table(name = "spare_parts")
public class SparePart {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

@Column(name = "part_name", nullable = false)
private String partName;

@Column(name = "part_model")
private String partModel;

@Column(name = "part_category")
private String partCategory;

@Column(name = "part_status")
private String partStatus; // 新好件、修好件、坏件、二级修、返厂修、待调拨、待报废、已报废

@Column(name = "part_type")
private String partType; // 正常件、在保件、遗留件

@Column(name = "unit_price")
private Double unitPrice;

@Column(name = "quantity")
private Integer quantity;

@Column(name = "sn_number")
private String snNumber;

@Column(name = "tax_free_price")
private Double taxFreePrice;

@Column(name = "tax_amount")
private Double taxAmount;

@Column(name = "tax_free_total")
private Double taxFreeTotal;

@Column(name = "total_tax")
private Double totalTax;

@Column(name = "unit")
private String unit;

@Column(name = "manufacturer")
private String manufacturer;

@Column(name = "warranty_until")
private LocalDateTime warrantyUntil;

@Column(name = "location")
private String location;

@Column(name = "min_stock")
private Integer minStock;

@Column(name = "max_stock")
private Integer maxStock;

@Column(name = "created_at")
private LocalDateTime createdAt;

@Column(name = "updated_at")
private LocalDateTime updatedAt;

@PrePersist
protected void onCreate() {
createdAt = LocalDateTime.now();
updatedAt = LocalDateTime.now();
}

@PreUpdate
protected void onUpdate() {
updatedAt = LocalDateTime.now();
}

// Getters and Setters
public Long getId() { return id; }
public void setId(Long id) { this.id = id; }

public String getPartName() { return partName; }
public void setPartName(String partName) { this.partName = partName; }

public String getPartModel() { return partModel; }
public void setPartModel(String partModel) { this.partModel = partModel; }

public String getPartCategory() { return partCategory; }
public void setPartCategory(String partCategory) { this.partCategory = partCategory; }

public String getPartStatus() { return partStatus; }
public void setPartStatus(String partStatus) { this.partStatus = partStatus; }

public String getPartType() { return partType; }
public void setPartType(String partType) { this.partType = partType; }

public Double getUnitPrice() { return unitPrice; }
public void setUnitPrice(Double unitPrice) { this.unitPrice = unitPrice; }

public Integer getQuantity() { return quantity; }
public void setQuantity(Integer quantity) { this.quantity = quantity; }

public String getSnNumber() { return snNumber; }
public void setSnNumber(String snNumber) { this.snNumber = snNumber; }

public Double getTaxFreePrice() { return taxFreePrice; }
public void setTaxFreePrice(Double taxFreePrice) { this.taxFreePrice = taxFreePrice; }

public Double getTaxAmount() { return taxAmount; }
public void setTaxAmount(Double taxAmount) { this.taxAmount = taxAmount; }

public Double getTaxFreeTotal() { return taxFreeTotal; }
public void setTaxFreeTotal(Double taxFreeTotal) { this.taxFreeTotal = taxFreeTotal; }

public Double getTotalTax() { return totalTax; }
public void setTotalTax(Double totalTax) { this.totalTax = totalTax; }

public String getUnit() { return unit; }
public void setUnit(String unit) { this.unit = unit; }

public String getManufacturer() { return manufacturer; }
public void setManufacturer(String manufacturer) { this.manufacturer = manufacturer; }

public LocalDateTime getWarrantyUntil() { return warrantyUntil; }
public void setWarrantyUntil(LocalDateTime warrantyUntil) { this.warrantyUntil = warrantyUntil; }

public String getLocation() { return location; }
public void setLocation(String location) { this.location = location; }

public Integer getMinStock() { return minStock; }
public void setMinStock(Integer minStock) { this.minStock = minStock; }

public Integer getMaxStock() { return maxStock; }
public void setMaxStock(Integer maxStock) { this.maxStock = maxStock; }

public LocalDateTime getCreatedAt() { return createdAt; }
public void setCreatedAt(LocalDateTime createdAt) { this.createdAt = createdAt; }

public LocalDateTime getUpdatedAt() { return updatedAt; }
public void setUpdatedAt(LocalDateTime updatedAt) { this.updatedAt = updatedAt; }
}