80 lines
4.0 KiB
Go
80 lines
4.0 KiB
Go
package fmreport
|
|
|
|
import (
|
|
"time"
|
|
|
|
"gorm.io/gorm"
|
|
|
|
"wucher/internal/shared/pkg/uuidv7"
|
|
)
|
|
|
|
// FleetHistory is the 1:1 snapshot of the flown helicopter's fleet status, frozen
|
|
// when an FM report is created at after-flight inspection. It is read-only
|
|
// afterwards so later complaints / maintenance changes do not alter a historical
|
|
// report. Next-inspection rows use fixed columns (A/F, ENG1, ENG2, MAIN1, MAIN2)
|
|
// mirroring the report layout.
|
|
type FleetHistory struct {
|
|
ID []byte `gorm:"type:binary(16);primaryKey;column:id"`
|
|
FMReportID []byte `gorm:"type:binary(16);not null;uniqueIndex:uidx_fm_report_fleet_history_fm_report_id;column:fm_report_id"`
|
|
|
|
HelicopterStatus string `gorm:"type:varchar(16);column:helicopter_status"`
|
|
|
|
AirframeHours float64 `gorm:"type:decimal(12,2);not null;default:0;column:airframe_hours"`
|
|
Engine1Hours float64 `gorm:"type:decimal(12,2);not null;default:0;column:engine1_hours"`
|
|
Engine2Hours float64 `gorm:"type:decimal(12,2);not null;default:0;column:engine2_hours"`
|
|
|
|
AFType string `gorm:"type:varchar(255);column:af_type"`
|
|
AFDue string `gorm:"type:varchar(255);column:af_due"`
|
|
AFExt string `gorm:"type:varchar(255);column:af_ext"`
|
|
Eng1Type string `gorm:"type:varchar(255);column:eng1_type"`
|
|
Eng1Due string `gorm:"type:varchar(255);column:eng1_due"`
|
|
Eng1Ext string `gorm:"type:varchar(255);column:eng1_ext"`
|
|
Eng2Type string `gorm:"type:varchar(255);column:eng2_type"`
|
|
Eng2Due string `gorm:"type:varchar(255);column:eng2_due"`
|
|
Eng2Ext string `gorm:"type:varchar(255);column:eng2_ext"`
|
|
Main1Type string `gorm:"type:varchar(255);column:main1_type"`
|
|
Main1Due string `gorm:"type:varchar(255);column:main1_due"`
|
|
Main1Ext string `gorm:"type:varchar(255);column:main1_ext"`
|
|
Main2Type string `gorm:"type:varchar(255);column:main2_type"`
|
|
Main2Due string `gorm:"type:varchar(255);column:main2_due"`
|
|
Main2Ext string `gorm:"type:varchar(255);column:main2_ext"`
|
|
|
|
EASAReleaseID []byte `gorm:"type:binary(16);column:easa_release_id"`
|
|
EASAIsSigned bool `gorm:"not null;default:false;column:easa_is_signed"`
|
|
EASADate *time.Time `gorm:"type:date;column:easa_date"`
|
|
EASAACHours *string `gorm:"type:varchar(20);column:easa_ac_hours"`
|
|
EASALocation *string `gorm:"type:varchar(255);column:easa_location"`
|
|
EASAWONo *string `gorm:"type:varchar(100);column:easa_wo_no"`
|
|
EASAMaintManualRevAirframe *string `gorm:"type:varchar(100);column:easa_maint_manual_rev_airframe"`
|
|
EASAMaintManualRevEngine *string `gorm:"type:varchar(100);column:easa_maint_manual_rev_engine"`
|
|
EASASignerID *string `gorm:"type:varchar(100);column:easa_signer_id"`
|
|
EASAPermitNo *string `gorm:"type:varchar(100);column:easa_permit_no"`
|
|
EASASignedAt *time.Time `gorm:"type:datetime(3);column:easa_signed_at"`
|
|
EASASignedBy []byte `gorm:"type:binary(16);column:easa_signed_by"`
|
|
|
|
MCFID []byte `gorm:"type:binary(16);column:mcf_id"`
|
|
MCFIsSigned bool `gorm:"not null;default:false;column:mcf_is_signed"`
|
|
MCFDate *time.Time `gorm:"type:date;column:mcf_date"`
|
|
MCFAFHours *string `gorm:"type:varchar(20);column:mcf_af_hours"`
|
|
MCFLandingCount *int `gorm:"column:mcf_landing_count"`
|
|
MCFSignedBy []byte `gorm:"type:binary(16);column:mcf_signed_by"`
|
|
MCFSignedByName string `gorm:"type:varchar(255);column:mcf_signed_by_name"`
|
|
|
|
CreatedAt time.Time `gorm:"column:created_at"`
|
|
}
|
|
|
|
func (FleetHistory) TableName() string { return "fm_report_fleet_history" }
|
|
|
|
func (f *FleetHistory) BeforeCreate(_ *gorm.DB) error {
|
|
if len(f.ID) == 0 {
|
|
f.ID = uuidv7.MustBytes()
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// HasEASA reports whether an EASA release was captured in this snapshot.
|
|
func (f *FleetHistory) HasEASA() bool { return f != nil && len(f.EASAReleaseID) == 16 }
|
|
|
|
// HasMCF reports whether an MCF was captured in this snapshot.
|
|
func (f *FleetHistory) HasMCF() bool { return f != nil && len(f.MCFID) == 16 }
|