4.17

package com.example.baoli.entity;

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

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

@Column(name = "order_number", unique = true)
private String orderNumber;

@Column(name = "equipment_info")
private String equipmentInfo;

@Column(name = "fault_description", columnDefinition = "TEXT")
private String faultDescription;

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

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

@Column(name = "maintenance_info", columnDefinition = "TEXT")
private String maintenanceInfo;

@Column(name = "application_info", columnDefinition = "TEXT")
private String applicationInfo;

@Column(name = "status")
private String status; // 待处理、处理中、已完成、已关闭

@Column(name = "progress")
private Integer progress; // 0-100

@Column(name = "before_photos", columnDefinition = "TEXT")
private String beforePhotos; // JSON格式存储照片路径

@Column(name = "after_photos", columnDefinition = "TEXT")
private String afterPhotos; // JSON格式存储照片路径

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

@Column(name = "created_by")
private String createdBy;

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

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

@Column(name = "completed_at")
private LocalDateTime completedAt;

@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 getOrderNumber() { return orderNumber; }
public void setOrderNumber(String orderNumber) { this.orderNumber = orderNumber; }

public String getEquipmentInfo() { return equipmentInfo; }
public void setEquipmentInfo(String equipmentInfo) { this.equipmentInfo = equipmentInfo; }

public String getFaultDescription() { return faultDescription; }
public void setFaultDescription(String faultDescription) { this.faultDescription = faultDescription; }

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 getMaintenanceInfo() { return maintenanceInfo; }
public void setMaintenanceInfo(String maintenanceInfo) { this.maintenanceInfo = maintenanceInfo; }

public String getApplicationInfo() { return applicationInfo; }
public void setApplicationInfo(String applicationInfo) { this.applicationInfo = applicationInfo; }

public String getStatus() { return status; }
public void setStatus(String status) { this.status = status; }

public Integer getProgress() { return progress; }
public void setProgress(Integer progress) { this.progress = progress; }

public String getBeforePhotos() { return beforePhotos; }
public void setBeforePhotos(String beforePhotos) { this.beforePhotos = beforePhotos; }

public String getAfterPhotos() { return afterPhotos; }
public void setAfterPhotos(String afterPhotos) { this.afterPhotos = afterPhotos; }

public String getAssignee() { return assignee; }
public void setAssignee(String assignee) { this.assignee = assignee; }

public String getCreatedBy() { return createdBy; }
public void setCreatedBy(String createdBy) { this.createdBy = createdBy; }

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; }

public LocalDateTime getCompletedAt() { return completedAt; }
public void setCompletedAt(LocalDateTime completedAt) { this.completedAt = completedAt; }
}