datastore

type Account struct {
	AccountID            uint64         `db:"account_id,omitempty"`
	AccountParent        uint64         `db:"account_parent"`
	AccountName          string         `db:"account_name"`
	AccountFullName      string         `db:"account_full_name"`
	AccountMemo          string         `db:"account_memo"`
	AccountCurrent       bool           `db:"account_current"`
	AccountLeft          uint64         `db:"account_left"`
	AccountRight         uint64         `db:"account_right"`
	AccountBalance       int64          `db:"account_balance"`
	AccountSubtotal      int64          `db:"account_subtotal"`
	AccountDecimals      uint64         `db:"account_decimals"`
	AccountReconcileDate sql.NullTime   `db:"account_reconcile_date"`
	AccountFlagged       bool           `db:"account_flagged"`
	AccountLocked        bool           `db:"account_locked"`
	AccountOpenDate      time.Time      `db:"account_open_date"`
	AccountCloseDate     sql.NullTime   `db:"account_close_date"`
	AccountCode          sql.NullString `db:"account_code"`
	AccountSign          AccountSign    `db:"account_sign"`
	AccountType          AccountType    `db:"account_type"`
}

type AccountSign string

type AccountStore struct {
	Client *sqlx.DB
}

type AccountSubtotal struct {
	Subtotal      uint64      `db:"subtotal"`
	DebitOrCredit AccountSign `db:"debit_or_credit"`
}

type AccountType string

type AccountWithLevel struct {
	Account
	Level int `db:"level"`
}

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

type PostgresConfig struct {
	Host, Username, Password, DBName string
	Port, MaxConnLifetime            int
	DisableSSL                       bool
}

type Report struct {
	ReportID   uint64     `db:"report_id,omitempty"`
	ReportName string     `db:"report_name"`
	ReportBody ReportBody `db:"report_body"`
}

type ReportAccountSetType string

type ReportBody struct {
	SourceAccountSetType          ReportAccountSetType `json:"sourceAccountSetType"`
	SourceAccountGroup            AccountType          `json:"sourceAccountGroup,omitempty"`
	SourcePredefinedAccounts      []uint64             `json:"sourcePredefinedAccounts"`
	SourceRecurseSubAccounts      bool                 `json:"sourceRecurseSubAccounts"`
	SourceRecurseSubAccountsDepth int                  `json:"sourceRecurseSubAccountsDepth"`
	FilterAccountSetType          ReportAccountSetType `json:"filterAccountSetType"`
	FilterAccountGroup            AccountType          `json:"filterAccountGroup,omitempty"`
	FilterPredefinedAccounts      []uint64             `json:"filterPredefinedAccounts"`
	FilterRecurseSubAccounts      bool                 `json:"filterRecurseSubAccounts"`
	FilterRecurseSubAccountsDepth int                  `json:"filterRecurseSubAccountsDepth"`
	DataSetType                   ReportDataSetType    `json:"dataSetType"`
}

type ReportDataSetType string

type ReportStore struct {
	Client *sqlx.DB
}

type Transaction struct {
	TransactionID            uint64       `db:"transaction_id,omitempty"`
	TransactionDate          time.Time    `db:"transaction_date,omitempty"`
	TransactionReconcileDate sql.NullTime `db:"transaction_reconcile_date"`
	TransactionComment       string       `db:"transaction_comment"`
	TransactionAmount        uint64       `db:"transaction_amount"`
	TransactionReference     string       `db:"transaction_reference"` // this could be a check number, batch ,etc
	IsReconciled             bool         `db:"is_reconciled"`
	IsSplit                  bool         `db:"is_split"`
}

type TransactionDebitCredit struct {
	TransactionDCID     uint64      `db:"transaction_dc_id,omitempty"`
	TransactionID       uint64      `db:"transaction_id"`
	AccountID           uint64      `db:"account_id"`
	TransactionDCAmount uint64      `db:"transaction_dc_amount"`
	DebitOrCredit       AccountSign `db:"debit_or_credit"`
}

type TransactionDebitCreditStore struct {
	Client *sqlx.DB
}

type TransactionLedger struct {
	TransactionID            uint64       `db:"transaction_id"`
	TransactionDate          time.Time    `db:"transaction_date"`
	TransactionReconcileDate sql.NullTime `db:"transaction_reconcile_date"`
	TransactionComment       string       `db:"transaction_comment"`
	TransactionReference     string       `db:"transaction_reference"` // this could be a check number, batch ,etc
	IsReconciled             bool         `db:"is_reconciled"`
	IsSplit                  bool         `db:"is_split"`
	TransactionDCAmount      uint64       `db:"transaction_dc_amount"`
	DebitOrCredit            AccountSign  `db:"debit_or_credit"`
	// split is a generated field, a comma separated list of the other d/c
	Split string `db:"split"`
}

type TransactionReconciliation struct {
	TransactionID            uint64       `db:"transaction_id"`
	AccountID                uint64       `db:"account_id"`
	TransactionDate          time.Time    `db:"transaction_date"`
	TransactionReconcileDate sql.NullTime `db:"transaction_reconcile_date"`
	TransactionComment       string       `db:"transaction_comment"`
	TransactionReference     string       `db:"transaction_reference"` // this could be a check number, batch ,etc
	IsReconciled             bool         `db:"is_reconciled"`
	IsSplit                  bool         `db:"is_split"`
	TransactionDCAmount      uint64       `db:"transaction_dc_amount"`
	DebitOrCredit            AccountSign  `db:"debit_or_credit"`
	// split is a generated field, a comma separated list of the other d/c
	Split string `db:"split"`
}

type TransactionStore struct {
	Client *sqlx.DB
}