db

Documentation

Index

• Constants
• type AdjustmentsSchedule
  • func (c *AdjustmentsSchedule) GetHeaders() []string
  • func (c *AdjustmentsSchedule) GetParams() []any
  • func (c *AdjustmentsSchedule) GetQuery() string
• type AgedDebt
  • func (a *AgedDebt) GetHeaders() []string
  • func (a *AgedDebt) GetParams() []any
  • func (a *AgedDebt) GetQuery() string
• type AgedDebtByCustomer
  • func (a *AgedDebtByCustomer) GetHeaders() []string
  • func (a *AgedDebtByCustomer) GetParams() []any
  • func (a *AgedDebtByCustomer) GetQuery() string
• type BadDebtWriteOff
  • func (b *BadDebtWriteOff) GetHeaders() []string
  • func (b *BadDebtWriteOff) GetParams() []any
  • func (b *BadDebtWriteOff) GetQuery() string
• type Client
  • func NewClient(db *pgxpool.Pool) *Client
  • func (c *Client) Close()
  • func (c *Client) Run(ctx context.Context, query ReportQuery) ([][]string, error)
• type CustomerCredit
  • func (c *CustomerCredit) GetHeaders() []string
  • func (c *CustomerCredit) GetParams() []any
  • func (c *CustomerCredit) GetQuery() string
• type InvoiceAdjustments
  • func (i *InvoiceAdjustments) GetHeaders() []string
  • func (i *InvoiceAdjustments) GetParams() []any
  • func (i *InvoiceAdjustments) GetQuery() string
• type InvoicesSchedule
  • func (i *InvoicesSchedule) GetHeaders() []string
  • func (i *InvoicesSchedule) GetParams() []any
  • func (i *InvoicesSchedule) GetQuery() string
• type PaidInvoices
  • func (p *PaidInvoices) GetHeaders() []string
  • func (p *PaidInvoices) GetParams() []any
  • func (p *PaidInvoices) GetQuery() string
• type PaymentsSchedule
  • func (p *PaymentsSchedule) GetHeaders() []string
  • func (p *PaymentsSchedule) GetParams() []any
  • func (p *PaymentsSchedule) GetQuery() string
• type Receipts
  • func (r *Receipts) GetHeaders() []string
  • func (r *Receipts) GetParams() []any
  • func (r *Receipts) GetQuery() string
• type ReportQuery

Constants

const AdjustmentsScheduleQuery = `` /* 792-byte string literal not displayed */

const AgedDebtByCustomerQuery = `` /* 4412-byte string literal not displayed */

const AgedDebtQuery = `` /* 6062-byte string literal not displayed */

const BadDebtWriteOffQuery = `` /* 2071-byte string literal not displayed */

const CustomerCreditQuery = `` /* 714-byte string literal not displayed */

const InvoiceAdjustmentsQuery = `` /* 2975-byte string literal not displayed */

const InvoicesScheduleQuery = `` /* 608-byte string literal not displayed */

const PaidInvoicesQuery = `` /* 5609-byte string literal not displayed */

const PaymentsScheduleQuery = `` /* 607-byte string literal not displayed */

const ReceiptsQuery = `` /* 3479-byte string literal not displayed */

Types

type AdjustmentsSchedule

type AdjustmentsSchedule struct {
	Date         *shared.Date
	ScheduleType *shared.ScheduleType
}

func (*AdjustmentsSchedule) GetHeaders

func (c *AdjustmentsSchedule) GetHeaders() []string

func (*AdjustmentsSchedule) GetParams

func (c *AdjustmentsSchedule) GetParams() []any

func (*AdjustmentsSchedule) GetQuery

func (c *AdjustmentsSchedule) GetQuery() string

type AgedDebt

type AgedDebt struct {
	FromDate *shared.Date
	ToDate   *shared.Date
}

func (*AgedDebt) GetHeaders

func (a *AgedDebt) GetHeaders() []string

func (*AgedDebt) GetParams

func (a *AgedDebt) GetParams() []any

func (*AgedDebt) GetQuery

func (a *AgedDebt) GetQuery() string

type AgedDebtByCustomer

type AgedDebtByCustomer struct{}

func (*AgedDebtByCustomer) GetHeaders

func (a *AgedDebtByCustomer) GetHeaders() []string

func (*AgedDebtByCustomer) GetParams

func (a *AgedDebtByCustomer) GetParams() []any

func (*AgedDebtByCustomer) GetQuery

func (a *AgedDebtByCustomer) GetQuery() string

type BadDebtWriteOff

type BadDebtWriteOff struct {
	FromDate   *shared.Date
	ToDate     *shared.Date
	GoLiveDate time.Time
}

func (*BadDebtWriteOff) GetHeaders

func (b *BadDebtWriteOff) GetHeaders() []string

func (*BadDebtWriteOff) GetParams

func (b *BadDebtWriteOff) GetParams() []any

func (*BadDebtWriteOff) GetQuery

func (b *BadDebtWriteOff) GetQuery() string

type Client

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

func NewClient

func NewClient(db *pgxpool.Pool) *Client

func (*Client) Close

func (c *Client) Close()

func (*Client) Run

func (c *Client) Run(ctx context.Context, query ReportQuery) ([][]string, error)

type CustomerCredit

type CustomerCredit struct{}

func (*CustomerCredit) GetHeaders

func (c *CustomerCredit) GetHeaders() []string

func (*CustomerCredit) GetParams

func (c *CustomerCredit) GetParams() []any

func (*CustomerCredit) GetQuery

func (c *CustomerCredit) GetQuery() string

type InvoiceAdjustments

type InvoiceAdjustments struct {
	FromDate   *shared.Date
	ToDate     *shared.Date
	GoLiveDate time.Time
}

func (*InvoiceAdjustments) GetHeaders

func (i *InvoiceAdjustments) GetHeaders() []string

func (*InvoiceAdjustments) GetParams

func (i *InvoiceAdjustments) GetParams() []any

func (*InvoiceAdjustments) GetQuery

func (i *InvoiceAdjustments) GetQuery() string

type InvoicesSchedule

type InvoicesSchedule struct {
	Date         *shared.Date
	ScheduleType *shared.ScheduleType
}

func (*InvoicesSchedule) GetHeaders

func (i *InvoicesSchedule) GetHeaders() []string

func (*InvoicesSchedule) GetParams

func (i *InvoicesSchedule) GetParams() []any

func (*InvoicesSchedule) GetQuery

func (i *InvoicesSchedule) GetQuery() string

type PaidInvoices

type PaidInvoices struct {
	FromDate   *shared.Date
	ToDate     *shared.Date
	GoLiveDate time.Time
}

func (*PaidInvoices) GetHeaders

func (p *PaidInvoices) GetHeaders() []string

func (*PaidInvoices) GetParams

func (p *PaidInvoices) GetParams() []any

func (*PaidInvoices) GetQuery

func (p *PaidInvoices) GetQuery() string

type PaymentsSchedule

type PaymentsSchedule struct {
	Date         *shared.Date
	ScheduleType *shared.ScheduleType
}

func (*PaymentsSchedule) GetHeaders

func (p *PaymentsSchedule) GetHeaders() []string

func (*PaymentsSchedule) GetParams

func (p *PaymentsSchedule) GetParams() []any

func (*PaymentsSchedule) GetQuery

func (p *PaymentsSchedule) GetQuery() string

type Receipts

type Receipts struct {
	FromDate *shared.Date
	ToDate   *shared.Date
}

func (*Receipts) GetHeaders

func (r *Receipts) GetHeaders() []string

func (*Receipts) GetParams

func (r *Receipts) GetParams() []any

func (*Receipts) GetQuery

func (r *Receipts) GetQuery() string

type ReportQuery

type ReportQuery interface {
	GetHeaders() []string
	GetQuery() string
	GetParams() []any
}