go install code.pfad.fr/buchungssystem/cmd/import@latest
type Booking struct {
ID int32
HouseID string
StartAt time.Time
EndAt time.Time
PeopleOver json.RawMessage
Contact string
Email string
Phone string
Comment string
Invoice json.RawMessage
CreatedAt time.Time
AdminConfirmedAt sql.NullTime
UserConfirmedAt sql.NullTime
CancelledAt sql.NullTime
HashedToken string
Landline string
}
type Charge struct {
ID string
Name string
Description string
HouseID string
PriceID string
Unit string
Amount int32
MinPersonCharged int32
ChargedOverPersonCount int32
ExemptedUnderAge int32
Optionality string
CreatedAt time.Time
DeletedAt sql.NullTime
}
type DBTX interface {
ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
PrepareContext(context.Context, string) (*sql.Stmt, error)
QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}
type Email struct {
ID string
BookingID int32
HeaderFrom string
HeaderTo string
HeaderSubject string
TextPlain string
CreatedAt time.Time
SentAt sql.NullTime
FatalError string
}
type ExtraRequest struct {
ID int32
Weight int32
HouseID string
Description string
Pricing string
}
type House struct {
ID string
Name string
CreatedAt time.Time
MaxPerson int32
StartMinute int32
EndMinute int32
ReplyTo string
DaysForUserConfirmation int32
MonthsForPublicBooking int32
PublicBookingType string
}
type ImportBookingParams struct {
HouseID string
StartAt time.Time
EndAt time.Time
PeopleOver json.RawMessage
Contact string
Email string
Phone string
Landline string
Comment string
Invoice json.RawMessage
CreatedAt time.Time
AdminConfirmedAt sql.NullTime
UserConfirmedAt sql.NullTime
CancelledAt sql.NullTime
HashedToken string
ID int32
}
type ImportEmailParams struct {
BookingID int32
HeaderFrom string
HeaderTo string
HeaderSubject string
TextPlain string
CreatedAt time.Time
SentAt sql.NullTime
ID string
}
type Kunde struct {
KundeID
Lastname string
MobilePhone string
Company string
Street string
Number string
City string
ZipCode string
Country string
}
func (k Kunde) BillingInfo() app.BillingInfo
type LogEvent struct {
ID int32
BookingID int32
UserID sql.NullString
Message string
CreatedAt time.Time
}
type Queries struct {/* contains filtered or unexported fields */}
type UpdateBookingParams struct {
HouseID string
StartAt time.Time
EndAt time.Time
PeopleOver json.RawMessage
Contact string
Email string
Phone string
Landline string
Comment string
Invoice json.RawMessage
CreatedAt time.Time
AdminConfirmedAt sql.NullTime
UserConfirmedAt sql.NullTime
CancelledAt sql.NullTime
HashedToken string
ID int32
}
type UpdateEmailParams struct {
BookingID int32
HeaderFrom string
HeaderTo string
HeaderSubject string
TextPlain string
CreatedAt time.Time
SentAt sql.NullTime
ID string
}
type User struct {
ID string
Email string
Name string
CreatedAt time.Time
AuthorizedAt sql.NullTime
Role string
}
db.go main.go models.go nachrichten.go xls.go xls_kundenliste.go xls_reservierungen.go zql.queries.go