package model

import "time"

type PublicCollection struct {
	ID                 int       `json:"id" csv:"id"`
	OrderID            string    `json:"order_id,omitempty" csv:"order_id"`
	ActualBillingDate  string    `json:"actual_billing_date,omitempty" csv:"actual_billing_date"`
	OrgID              string    `json:"org_id,omitempty" csv:"org_id"`
	AccountName        string    `json:"account_name,omitempty" csv:"account_name"`
	AccountID          string    `json:"account_id,omitempty" csv:"account_id"`
	NsOrderNumber      string    `json:"ns_order_number,omitempty" csv:"ns_order_number"`
	PayableAmount      string    `json:"payable_amount,omitempty" csv:"payable_amount"`
	CurrencyISOCode    string    `json:"currency_iso_code,omitempty" csv:"currency_iso_code"`
	ExchangeRateToUse  string    `json:"exchange_rate_to_use,omitempty" csv:"exchange_rate_to_use"`
	CollectionsMonth   string    `json:"collections_month,omitempty" csv:"collections_month"`
	CollectionsDate    string    `json:"collections_date,omitempty" csv:"collections_date"`
	PayableDate        string    `json:"payable_date,omitempty" csv:"payable_date"`
	CollectionsAmount  string    `json:"collections_amount,omitempty" csv:"collections_amount"`
	NsCollectionNumber string    `json:"ns_collection_number,omitempty" csv:"ns_collection_number"`
	OrderNumber        string    `json:"order_number,omitempty" csv:"order_number"`
	InvoiceNumber      string    `json:"invoice_number,omitempty" csv:"invoice_number"`
	CollectionStatus   string    `json:"collection_status,omitempty" csv:"collection_status"`
	Sync               int       `json:"sync,omitempty" csv:"sync"`
	SyncTime           time.Time `json:"sync_time,omitempty" csv:"sync_time"`
	CollectionID       string    `json:"collection_id,omitempty" csv:"collection_id"`
	CollectionNumber   string    `json:"collection_number,omitempty" csv:"collection_number"`
	CreatedAt          time.Time `json:"created_at,omitempty" csv:"created_at"`     // 使用 time.Time 处理 datetime 类型
	UpdatedTime        time.Time `json:"updated_time,omitempty" csv:"updated_time"` // 使用 time.Time 处理 datetime 类型
}

func (PublicCollection) TableName() string {
	return "public_collection"
}