transactions

type Attachment struct {
	ID               uuid.UUID `json:"id" db:"id"`
	TransactionID    uuid.UUID `json:"transaction_id" db:"transaction_id"`
	Filename         string    `json:"filename" db:"filename"`
	OriginalFilename string    `json:"original_filename" db:"original_filename"`
	FileSize         int64     `json:"file_size" db:"file_size"`
	MimeType         string    `json:"mime_type" db:"mime_type"`
	StorageKey       string    `json:"storage_key" db:"storage_key"`
	BucketName       string    `json:"bucket_name" db:"bucket_name"`
	IsEncrypted      bool      `json:"is_encrypted" db:"is_encrypted"`
	EncryptionKeyID  *string   `json:"encryption_key_id,omitempty" db:"encryption_key_id"`
	UploadedBy       uuid.UUID `json:"uploaded_by" db:"uploaded_by"`
	CreatedAt        time.Time `json:"created_at" db:"created_at"`

	// Computed fields
	PresignedURL *string `json:"presigned_url,omitempty"` // Temporary download URL
}

type AttachmentDownloadResponse struct {
	DownloadURL string    `json:"download_url"`
	ExpiresAt   time.Time `json:"expires_at"`
}

type AttachmentUploadResponse struct {
	AttachmentID uuid.UUID `json:"attachment_id"`
	UploadURL    string    `json:"upload_url"` // Presigned URL for upload
	ExpiresAt    time.Time `json:"expires_at"`
}

type CreateMerchantRequest struct {
	Name     string   `json:"name" validate:"required,min=1,max=255"`
	Category *string  `json:"category,omitempty"`
	Website  *string  `json:"website,omitempty" validate:"omitempty,url"`
	Phone    *string  `json:"phone,omitempty"`
	Address  *Details `json:"address,omitempty"`
	LogoURL  *string  `json:"logo_url,omitempty" validate:"omitempty,url"`
}

type CreateTagRequest struct {
	Name  string  `json:"name" validate:"required,min=1,max=100"`
	Color *string `json:"color,omitempty" validate:"omitempty,hexcolor"`
	Icon  *string `json:"icon,omitempty"`
}

type CreateTransactionRequest struct {
	TransactionDatetime time.Time   `json:"transaction_datetime"`
	Description         *string     `json:"description"`
	Type                string      `json:"type"`
	AccountID           string      `json:"account_id"`
	CategoryID          string      `json:"category_id"`
	Details             dto.Details `json:"details"`
	Amount              float64     `json:"amount"`
}

type CreateTransactionSplit struct {
	CategoryID  string           `json:"category_id" validate:"required,uuid"`
	Amount      decimal.Decimal  `json:"amount" validate:"required,gt=0"`
	Description *string          `json:"description,omitempty"`
	Percentage  *decimal.Decimal `json:"percentage,omitempty"`
}

type CreateTransfertRequest struct {
	TransactionDatetime  time.Time   `json:"transaction_datetime"`
	Description          *string     `json:"description"`
	Type                 string      `json:"type"`
	AccountID            string      `json:"account_id"`
	DestinationAccountID string      `json:"destination_account_id"`
	CategoryID           string      `json:"category_id"`
	Details              dto.Details `json:"details"`
	Amount               float64     `json:"amount"`
}

type Currency struct {
	Code          string    `json:"code" db:"code"`
	Name          string    `json:"name" db:"name"`
	Symbol        *string   `json:"symbol,omitempty" db:"symbol"`
	DecimalPlaces int       `json:"decimal_places" db:"decimal_places"`
	IsActive      bool      `json:"is_active" db:"is_active"`
	CreatedAt     time.Time `json:"created_at" db:"created_at"`
	UpdatedAt     time.Time `json:"updated_at" db:"updated_at"`
}

type Details struct {
	PaymentMedium        string           `json:"payment_medium"` // credit_card, debit_card, cash, check, etc.
	Location             string           `json:"location"`
	Note                 string           `json:"note"`
	PaymentStatus        string           `json:"payment_status"` // pending, completed, failed, cancelled
	CardLastFour         string           `json:"card_last_four,omitempty"`
	AuthorizationCode    string           `json:"authorization_code,omitempty"`
	MerchantCategoryCode string           `json:"merchant_category_code,omitempty"` // MCC code
	RewardsEarned        *decimal.Decimal `json:"rewards_earned,omitempty"`
	ReceiptNumber        string           `json:"receipt_number,omitempty"`
	TipAmount            *decimal.Decimal `json:"tip_amount,omitempty"`
	TaxAmount            *decimal.Decimal `json:"tax_amount,omitempty"`
	DiscountAmount       *decimal.Decimal `json:"discount_amount,omitempty"`
	InvoiceNumber        string           `json:"invoice_number,omitempty"`
	ProjectCode          string           `json:"project_code,omitempty"` // For business expense tracking
	ClientName           string           `json:"client_name,omitempty"`
	SubTransactions      []SubTransaction `json:"sub_transactions,omitempty"` // For itemized receipts
}

type EnhancedTransaction struct {
	repository.ListTransactionsRow
	DestinationAccount *repository.GetAccountsRow `json:"destination_account,omitempty"`
}

type ExchangeRate struct {
	ID           uuid.UUID       `json:"id" db:"id"`
	FromCurrency string          `json:"from_currency" db:"from_currency"`
	ToCurrency   string          `json:"to_currency" db:"to_currency"`
	Rate         decimal.Decimal `json:"rate" db:"rate"`
	RateDate     time.Time       `json:"rate_date" db:"rate_date"`
	Source       *string         `json:"source,omitempty" db:"source"`
	CreatedAt    time.Time       `json:"created_at" db:"created_at"`
}

type Group struct {
	ID           string                `json:"id"`
	Date         string                `json:"date"`  // e.g., "October 19 2029 - 2"
	Total        float64               `json:"total"` // e.g., "$700.00"
	Transactions []EnhancedTransaction `json:"transactions"`
}

type Handler struct {
	// contains filtered or unexported fields
}

type LocationData struct {
	Latitude   *float64 `json:"latitude,omitempty"`
	Longitude  *float64 `json:"longitude,omitempty"`
	Address    string   `json:"address,omitempty"`
	City       string   `json:"city,omitempty"`
	State      string   `json:"state,omitempty"`
	Country    string   `json:"country,omitempty"`
	PostalCode string   `json:"postal_code,omitempty"`
	PlaceID    string   `json:"place_id,omitempty"` // Google Places ID
	Accuracy   *float64 `json:"accuracy,omitempty"` // GPS accuracy in meters
}

type Merchant struct {
	ID        uuid.UUID  `json:"id" db:"id"`
	Name      string     `json:"name" db:"name"`
	Category  *string    `json:"category,omitempty" db:"category"`
	Website   *string    `json:"website,omitempty" db:"website"`
	Phone     *string    `json:"phone,omitempty" db:"phone"`
	Address   *Details   `json:"address,omitempty" db:"address"` // Reuse Details for address structure
	LogoURL   *string    `json:"logo_url,omitempty" db:"logo_url"`
	CreatedBy *uuid.UUID `json:"created_by,omitempty" db:"created_by"`
	CreatedAt time.Time  `json:"created_at" db:"created_at"`
	UpdatedAt time.Time  `json:"updated_at" db:"updated_at"`
	DeletedAt *time.Time `json:"deleted_at,omitempty" db:"deleted_at"`
}

type Repository interface {
	// Transaction operations
	GetTransactions(ctx context.Context, params repository.ListTransactionsParams) ([]Group, error)
	GetTransaction(ctx context.Context, id uuid.UUID) (repository.Transaction, error)
	CreateTransaction(ctx context.Context, params repository.CreateTransactionParams) (repository.Transaction, error)
	CreateTransfertTransaction(ctx context.Context, params TransfertParams) (repository.Transaction, error)
	UpdateTransaction(ctx context.Context, params repository.UpdateTransactionParams) (repository.Transaction, error)
	DeleteTransaction(ctx context.Context, id uuid.UUID) error
}

type SubTransaction struct {
	Description string           `json:"description"`
	Amount      decimal.Decimal  `json:"amount"`
	Quantity    int              `json:"quantity,omitempty"`
	UnitPrice   *decimal.Decimal `json:"unit_price,omitempty"`
	Category    string           `json:"category,omitempty"`
}

type Tag struct {
	ID        uuid.UUID `json:"id" db:"id"`
	Name      string    `json:"name" db:"name"`
	Color     *string   `json:"color,omitempty" db:"color"`
	Icon      *string   `json:"icon,omitempty" db:"icon"`
	UserID    uuid.UUID `json:"user_id" db:"user_id"`
	CreatedAt time.Time `json:"created_at" db:"created_at"`
}

type Transaction struct {
	ID                      uuid.UUID        `json:"id" db:"id"`
	Amount                  decimal.Decimal  `json:"amount" db:"amount"`
	Type                    string           `json:"type" db:"type"`
	AccountID               uuid.UUID        `json:"account_id" db:"account_id"`
	CategoryID              uuid.UUID        `json:"category_id" db:"category_id"`
	DestinationAccountID    *uuid.UUID       `json:"destination_account_id,omitempty" db:"destination_account_id"`
	MerchantID              *uuid.UUID       `json:"merchant_id,omitempty" db:"merchant_id"`
	Payee                   *string          `json:"payee,omitempty" db:"payee"`
	CurrencyCode            string           `json:"currency_code" db:"currency_code"`
	ExchangeRate            *decimal.Decimal `json:"exchange_rate,omitempty" db:"exchange_rate"`
	BaseCurrencyAmount      *decimal.Decimal `json:"base_currency_amount,omitempty" db:"base_currency_amount"`
	LocationData            *LocationData    `json:"location_data,omitempty" db:"location_data"`
	RecurringTransactionID  *uuid.UUID       `json:"recurring_transaction_id,omitempty" db:"recurring_transaction_id"`
	ExternalTransactionID   *string          `json:"external_transaction_id,omitempty" db:"external_transaction_id"`
	ReferenceNumber         *string          `json:"reference_number,omitempty" db:"reference_number"`
	TaxDeductible           bool             `json:"tax_deductible" db:"tax_deductible"`
	BusinessExpense         bool             `json:"business_expense" db:"business_expense"`
	SplitTransactionGroupID *uuid.UUID       `json:"split_transaction_group_id,omitempty" db:"split_transaction_group_id"`
	TransactionDatetime     time.Time        `json:"transaction_datetime" db:"transaction_datetime"`
	Description             *string          `json:"description,omitempty" db:"description"`
	Details                 *Details         `json:"details,omitempty" db:"details"`
	CreatedBy               *uuid.UUID       `json:"created_by,omitempty" db:"created_by"`
	UpdatedBy               *uuid.UUID       `json:"updated_by,omitempty" db:"updated_by"`
	CreatedAt               time.Time        `json:"created_at" db:"created_at"`
	UpdatedAt               time.Time        `json:"updated_at" db:"updated_at"`
	DeletedAt               *time.Time       `json:"deleted_at,omitempty" db:"deleted_at"`

	// Related data that can be loaded with joins
	Merchant    *Merchant          `json:"merchant,omitempty"`
	Tags        []Tag              `json:"tags,omitempty"`
	Attachments []Attachment       `json:"attachments,omitempty"`
	Splits      []TransactionSplit `json:"splits,omitempty"`
}

type TransactionResponse struct {
	*Transaction
	Currency *Currency `json:"currency,omitempty"`
}

type TransactionSplit struct {
	ID                  uuid.UUID        `json:"id" db:"id"`
	ParentTransactionID uuid.UUID        `json:"parent_transaction_id" db:"parent_transaction_id"`
	CategoryID          uuid.UUID        `json:"category_id" db:"category_id"`
	Amount              decimal.Decimal  `json:"amount" db:"amount"`
	Description         *string          `json:"description,omitempty" db:"description"`
	Percentage          *decimal.Decimal `json:"percentage,omitempty" db:"percentage"`
	CreatedAt           time.Time        `json:"created_at" db:"created_at"`
}

type TransactionTag struct {
	TransactionID uuid.UUID `json:"transaction_id" db:"transaction_id"`
	TagID         uuid.UUID `json:"tag_id" db:"tag_id"`
	CreatedAt     time.Time `json:"created_at" db:"created_at"`
}

type TransfertParams struct {
	Amount               float64
	Type                 string
	AccountID            uuid.UUID
	DestinationAccountID uuid.UUID
	CategoryID           uuid.UUID
	Description          *string
	TransactionDatetime  time.Time
	Details              dto.Details
	UserID               uuid.UUID
}

type Trsrepo struct {
	DB      *pgxpool.Pool
	Queries *repository.Queries
}

type UploadAttachmentRequest struct {
	TransactionID string `json:"transaction_id" validate:"required,uuid"`
	Filename      string `json:"filename" validate:"required"`
	FileSize      int64  `json:"file_size" validate:"required,gt=0"`
	MimeType      string `json:"mime_type" validate:"required"`
}