store

package
v1.120.0-renovate-lock... Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jan 6, 2025 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Account 

type Account struct {
	Code                   int64
	AccountCodeDescription string
	CostCentre             pgtype.Int4
}

type AddFeeReductionParams 

type AddFeeReductionParams struct {
	ClientID     int32
	Type         string
	Startdate    pgtype.Date
	Enddate      pgtype.Date
	Notes        string
	Datereceived pgtype.Date
	CreatedBy    pgtype.Int4
}

type AddInvoiceParams 

type AddInvoiceParams struct {
	PersonID   pgtype.Int4
	Feetype    string
	Reference  string
	Startdate  pgtype.Date
	Enddate    pgtype.Date
	Amount     int32
	Raiseddate pgtype.Date
	Source     pgtype.Text
	CreatedBy  pgtype.Int4
}

type AddInvoiceRangeParams 

type AddInvoiceRangeParams struct {
	InvoiceID        pgtype.Int4
	Supervisionlevel string
	Fromdate         pgtype.Date
	Todate           pgtype.Date
	Amount           int32
}

type BillingPeriod 

type BillingPeriod struct {
	ID              int32
	FinanceClientID pgtype.Int4
	OrderID         pgtype.Int4
	StartDate       pgtype.Date
	EndDate         pgtype.Date
}

type CancelFeeReductionParams 

type CancelFeeReductionParams struct {
	ID                 int32
	CancelledBy        pgtype.Int4
	CancellationReason pgtype.Text
}

type CostCentre 

type CostCentre struct {
	Code                  int32
	CostCentreDescription string
}

type CountOverlappingFeeReductionParams 

type CountOverlappingFeeReductionParams struct {
	ClientID   int32
	Overlaps   interface{}
	Overlaps_2 interface{}
}

type Counter 

type Counter struct {
	ID      int32
	Key     string
	Counter int32
}

type CreateLedgerAllocationParams 

type CreateLedgerAllocationParams struct {
	LedgerID  pgtype.Int4
	InvoiceID pgtype.Int4
	Amount    int32
	Status    string
	Notes     pgtype.Text
}

type CreateLedgerForAdjustmentParams 

type CreateLedgerForAdjustmentParams struct {
	ClientID       int32
	Amount         int32
	Notes          pgtype.Text
	Type           string
	Status         string
	FeeReductionID pgtype.Int4
	CreatedBy      pgtype.Int4
	ID             int32
}

type CreateLedgerForCourtRefParams 

type CreateLedgerForCourtRefParams struct {
	CourtRef  pgtype.Text
	Datetime  pgtype.Timestamp
	Bankdate  pgtype.Date
	Amount    int32
	Notes     pgtype.Text
	Type      string
	Status    string
	CreatedBy pgtype.Int4
}

type CreateLedgerParams 

type CreateLedgerParams struct {
	ClientID       int32
	Amount         int32
	Notes          pgtype.Text
	Type           string
	Status         string
	FeeReductionID pgtype.Int4
	CreatedBy      pgtype.Int4
}

type CreatePendingInvoiceAdjustmentParams 

type CreatePendingInvoiceAdjustmentParams struct {
	ClientID       int32
	InvoiceID      int32
	AdjustmentType string
	Amount         int32
	Notes          string
	CreatedBy      int32
}

type DBTX 

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type FeeReduction 

type FeeReduction struct {
	ID              int32
	FinanceClientID pgtype.Int4
	// (DC2Type:refdata)
	Type string
	// (DC2Type:refdata)
	Evidencetype       pgtype.Text
	Startdate          pgtype.Date
	Enddate            pgtype.Date
	Notes              string
	Deleted            bool
	Datereceived       pgtype.Date
	CreatedAt          pgtype.Timestamp
	CreatedBy          pgtype.Int4
	CancelledAt        pgtype.Timestamp
	CancelledBy        pgtype.Int4
	CancellationReason pgtype.Text
}

type FinanceClient 

type FinanceClient struct {
	ID        int32
	ClientID  int32
	SopNumber string
	// (DC2Type:refdata)
	PaymentMethod string
	Batchnumber   pgtype.Int4
	CourtRef      pgtype.Text
}

type GetAccountInformationRow 

type GetAccountInformationRow struct {
	Outstanding   int32
	Credit        int32
	PaymentMethod string
}

type GetAdjustmentForDecisionRow 

type GetAdjustmentForDecisionRow struct {
	Amount          int32
	AdjustmentType  string
	FinanceClientID int32
	InvoiceID       int32
	Outstanding     int32
}

type GetCreditBalanceAndOldestOpenInvoiceRow 

type GetCreditBalanceAndOldestOpenInvoiceRow struct {
	Credit      int32
	InvoiceID   pgtype.Int4
	Outstanding pgtype.Int4
}

type GetFeeReductionEventsRow 

type GetFeeReductionEventsRow struct {
	Type               string
	Startdate          pgtype.Date
	Enddate            pgtype.Date
	Datereceived       pgtype.Date
	Notes              string
	CreatedAt          pgtype.Timestamp
	CreatedBy          pgtype.Int4
	CancelledAt        pgtype.Timestamp
	CancelledBy        pgtype.Int4
	CancellationReason pgtype.Text
	Status             pgtype.Text
	Amount             pgtype.Int4
	LedgerDate         pgtype.Timestamp
	ClientID           int32
	InvoiceID          pgtype.Int4
	Reference          pgtype.Text
}

type GetFeeReductionForDateParams 

type GetFeeReductionForDateParams struct {
	ClientID     int32
	Datereceived pgtype.Date
}

type GetFeeReductionForDateRow 

type GetFeeReductionForDateRow struct {
	ID   int32
	Type string
}

type GetFeeReductionsRow 

type GetFeeReductionsRow struct {
	ID              int32
	FinanceClientID pgtype.Int4
	Type            string
	Startdate       pgtype.Date
	Enddate         pgtype.Date
	Datereceived    pgtype.Date
	Notes           string
	Deleted         bool
}

type GetGeneratedInvoicesRow 

type GetGeneratedInvoicesRow struct {
	InvoiceID int32
	Reference string
	Feetype   string
	Amount    int32
	CreatedBy pgtype.Int4
	CreatedAt pgtype.Timestamp
}

type GetInvoiceAdjustmentsRow 

type GetInvoiceAdjustmentsRow struct {
	ID             int32
	InvoiceRef     string
	RaisedDate     pgtype.Date
	AdjustmentType string
	Amount         int32
	Notes          string
	Status         string
}

type GetInvoiceBalanceDetailsRow 

type GetInvoiceBalanceDetailsRow struct {
	Initial        int32
	Outstanding    int32
	Feetype        string
	WriteOffAmount int32
}

type GetInvoiceBalancesForFeeReductionRangeRow 

type GetInvoiceBalancesForFeeReductionRangeRow struct {
	ID                    int32
	Amount                int32
	GeneralSupervisionFee int64
	Outstanding           int32
	Feetype               string
}

type GetInvoicesForCourtRefRow 

type GetInvoicesForCourtRefRow struct {
	ID          int32
	Outstanding int32
}

type GetInvoicesRow 

type GetInvoicesRow struct {
	ID               int32
	Raiseddate       pgtype.Date
	Reference        string
	Amount           int32
	Received         int32
	FeeReductionType string
}

type GetLedgerAllocationsForClientRow 

type GetLedgerAllocationsForClientRow struct {
	LedgerID         int32
	InvoiceID        pgtype.Int4
	Reference        pgtype.Text
	Type             string
	Status           string
	LedgerAmount     int32
	AllocationAmount int32
	CreatedAt        pgtype.Timestamp
	CreatedBy        pgtype.Int4
}

type GetLedgerAllocationsRow 

type GetLedgerAllocationsRow struct {
	InvoiceID          pgtype.Int4
	Amount             int32
	RaisedDate         pgtype.Date
	Type               string
	Status             string
	CreatedAt          pgtype.Timestamp
	LedgerAllocationID int32
}

type GetLedgerForPaymentParams 

type GetLedgerForPaymentParams struct {
	Amount   int32
	Bankdate pgtype.Date
	Type     string
	CourtRef pgtype.Text
}

type GetPendingInvoiceAdjustmentsRow 

type GetPendingInvoiceAdjustmentsRow struct {
	InvoiceID      int32
	Reference      string
	AdjustmentType string
	Amount         int32
	Notes          string
	CreatedAt      pgtype.Timestamp
	CreatedBy      int32
}

type GetSupervisionLevelsRow 

type GetSupervisionLevelsRow struct {
	InvoiceID        pgtype.Int4
	Supervisionlevel string
	Fromdate         pgtype.Date
	Todate           pgtype.Date
	Amount           int32
}

type Invoice 

type Invoice struct {
	ID              int32
	PersonID        pgtype.Int4
	FinanceClientID pgtype.Int4
	Feetype         string
	Reference       string
	Startdate       pgtype.Date
	Enddate         pgtype.Date
	// (DC2Type:money)
	Amount int32
	// (DC2Type:refdata)
	Supervisionlevel  pgtype.Text
	Confirmeddate     pgtype.Date
	Batchnumber       pgtype.Int4
	Raiseddate        pgtype.Date
	Source            pgtype.Text
	Scheduledfn14date pgtype.Date
	// (DC2Type:money)
	Cacheddebtamount pgtype.Int4
	CreatedAt        pgtype.Timestamp
	CreatedBy        pgtype.Int4
}

type InvoiceAdjustment 

type InvoiceAdjustment struct {
	ID              int32
	FinanceClientID int32
	InvoiceID       int32
	RaisedDate      pgtype.Date
	AdjustmentType  string
	Amount          int32
	Notes           string
	Status          string
	CreatedAt       pgtype.Timestamp
	CreatedBy       int32
	UpdatedAt       pgtype.Timestamp
	UpdatedBy       pgtype.Int4
	LedgerID        pgtype.Int4
}

type InvoiceEmailStatus 

type InvoiceEmailStatus struct {
	ID        int32
	InvoiceID pgtype.Int4
	// (DC2Type:refdata)
	Status string
	// (DC2Type:refdata)
	Templateid  string
	Createddate pgtype.Date
}

type InvoiceFeeRange 

type InvoiceFeeRange struct {
	ID        int32
	InvoiceID pgtype.Int4
	// (DC2Type:refdata)
	Supervisionlevel string
	Fromdate         pgtype.Date
	Todate           pgtype.Date
	// (DC2Type:money)
	Amount int32
}

type Ledger 

type Ledger struct {
	ID        int32
	Reference string
	Datetime  pgtype.Timestamp
	Method    string
	// (DC2Type:money)
	Amount int32
	Notes  pgtype.Text
	// (DC2Type:refdata)
	Type string
	// (DC2Type:refdata)
	Status          string
	FinanceClientID pgtype.Int4
	ParentID        pgtype.Int4
	FeeReductionID  pgtype.Int4
	Confirmeddate   pgtype.Date
	Bankdate        pgtype.Date
	Batchnumber     pgtype.Int4
	// (DC2Type:refdata)
	Bankaccount pgtype.Text
	Source      pgtype.Text
	Line        pgtype.Int4
	CreatedAt   pgtype.Timestamp
	CreatedBy   pgtype.Int4
}

type LedgerAllocation 

type LedgerAllocation struct {
	ID        int32
	LedgerID  pgtype.Int4
	InvoiceID pgtype.Int4
	Datetime  pgtype.Timestamp
	// (DC2Type:money)
	Amount int32
	// (DC2Type:refdata)
	Status        string
	Reference     pgtype.Text
	Notes         pgtype.Text
	Allocateddate pgtype.Date
	Batchnumber   pgtype.Int4
	Source        pgtype.Text
}

type Property 

type Property struct {
	ID    int32
	Key   string
	Value string
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddFeeReduction 

func (q *Queries) AddFeeReduction(ctx context.Context, arg AddFeeReductionParams) (FeeReduction, error)

func (*Queries) AddInvoice 

func (q *Queries) AddInvoice(ctx context.Context, arg AddInvoiceParams) (Invoice, error)

func (*Queries) AddInvoiceRange 

func (q *Queries) AddInvoiceRange(ctx context.Context, arg AddInvoiceRangeParams) error

func (*Queries) CancelFeeReduction 

func (q *Queries) CancelFeeReduction(ctx context.Context, arg CancelFeeReductionParams) (FeeReduction, error)

func (*Queries) CountOverlappingFeeReduction 

func (q *Queries) CountOverlappingFeeReduction(ctx context.Context, arg CountOverlappingFeeReductionParams) (int64, error)

func (*Queries) CreateLedger 

func (q *Queries) CreateLedger(ctx context.Context, arg CreateLedgerParams) (int32, error)

func (*Queries) CreateLedgerAllocation 

func (q *Queries) CreateLedgerAllocation(ctx context.Context, arg CreateLedgerAllocationParams) error

func (*Queries) CreateLedgerForAdjustment 

func (q *Queries) CreateLedgerForAdjustment(ctx context.Context, arg CreateLedgerForAdjustmentParams) (int32, error)

func (*Queries) CreateLedgerForCourtRef 

func (q *Queries) CreateLedgerForCourtRef(ctx context.Context, arg CreateLedgerForCourtRefParams) (int32, error)

func (*Queries) CreatePendingInvoiceAdjustment 

func (q *Queries) CreatePendingInvoiceAdjustment(ctx context.Context, arg CreatePendingInvoiceAdjustmentParams) (string, error)

func (*Queries) GetAccountInformation 

func (q *Queries) GetAccountInformation(ctx context.Context, clientID int32) (GetAccountInformationRow, error)

func (*Queries) GetAdjustmentForDecision 

func (q *Queries) GetAdjustmentForDecision(ctx context.Context, id int32) (GetAdjustmentForDecisionRow, error)

func (*Queries) GetCreditBalanceAndOldestOpenInvoice 

func (q *Queries) GetCreditBalanceAndOldestOpenInvoice(ctx context.Context, clientID int32) (GetCreditBalanceAndOldestOpenInvoiceRow, error)

func (*Queries) GetFeeReductionEvents 

func (q *Queries) GetFeeReductionEvents(ctx context.Context, clientID int32) ([]GetFeeReductionEventsRow, error)

func (*Queries) GetFeeReductionForDate 

func (q *Queries) GetFeeReductionForDate(ctx context.Context, arg GetFeeReductionForDateParams) (GetFeeReductionForDateRow, error)

func (*Queries) GetFeeReductions 

func (q *Queries) GetFeeReductions(ctx context.Context, clientID int32) ([]GetFeeReductionsRow, error)

func (*Queries) GetGeneratedInvoices 

func (q *Queries) GetGeneratedInvoices(ctx context.Context, clientID int32) ([]GetGeneratedInvoicesRow, error)

func (*Queries) GetInvoiceAdjustments 

func (q *Queries) GetInvoiceAdjustments(ctx context.Context, clientID int32) ([]GetInvoiceAdjustmentsRow, error)

func (*Queries) GetInvoiceBalanceDetails 

func (q *Queries) GetInvoiceBalanceDetails(ctx context.Context, id int32) (GetInvoiceBalanceDetailsRow, error)

func (*Queries) GetInvoiceBalancesForFeeReductionRange 

func (q *Queries) GetInvoiceBalancesForFeeReductionRange(ctx context.Context, id int32) ([]GetInvoiceBalancesForFeeReductionRangeRow, error)

func (*Queries) GetInvoiceCounter 

func (q *Queries) GetInvoiceCounter(ctx context.Context, key string) (string, error)

func (*Queries) GetInvoices 

func (q *Queries) GetInvoices(ctx context.Context, clientID int32) ([]GetInvoicesRow, error)

func (*Queries) GetInvoicesForCourtRef 

func (q *Queries) GetInvoicesForCourtRef(ctx context.Context, courtRef pgtype.Text) ([]GetInvoicesForCourtRefRow, error)

func (*Queries) GetLedgerAllocations 

func (q *Queries) GetLedgerAllocations(ctx context.Context, dollar_1 []int32) ([]GetLedgerAllocationsRow, error)

func (*Queries) GetLedgerAllocationsForClient 

func (q *Queries) GetLedgerAllocationsForClient(ctx context.Context, clientID int32) ([]GetLedgerAllocationsForClientRow, error)

func (*Queries) GetLedgerForPayment 

func (q *Queries) GetLedgerForPayment(ctx context.Context, arg GetLedgerForPaymentParams) (int32, error)

func (*Queries) GetPendingInvoiceAdjustments 

func (q *Queries) GetPendingInvoiceAdjustments(ctx context.Context, clientID int32) ([]GetPendingInvoiceAdjustmentsRow, error)

func (*Queries) GetSupervisionLevels 

func (q *Queries) GetSupervisionLevels(ctx context.Context, dollar_1 []int32) ([]GetSupervisionLevelsRow, error)

func (*Queries) SetAdjustmentDecision 

func (q *Queries) SetAdjustmentDecision(ctx context.Context, arg SetAdjustmentDecisionParams) (SetAdjustmentDecisionRow, error)

func (*Queries) UpdateClient 

func (q *Queries) UpdateClient(ctx context.Context, arg UpdateClientParams) error

func (*Queries) UpdateLedgerAllocationAdjustment 

func (q *Queries) UpdateLedgerAllocationAdjustment(ctx context.Context, arg UpdateLedgerAllocationAdjustmentParams) error

func (*Queries) WithTx 

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type Rate 

type Rate struct {
	ID        int32
	Type      string
	Startdate pgtype.Date
	Enddate   pgtype.Date
	// (DC2Type:money)
	Amount int32
}

type Report 

type Report struct {
	ID          int32
	Batchnumber int32
	// (DC2Type:refdata)
	Type        string
	Datetime    pgtype.Timestamp
	Count       int32
	Invoicedate pgtype.Timestamp
	// (DC2Type:money)
	Totalamount           pgtype.Int4
	Firstinvoicereference pgtype.Text
	Lastinvoicereference  pgtype.Text
	CreatedbyuserID       pgtype.Int4
}

type SetAdjustmentDecisionParams 

type SetAdjustmentDecisionParams struct {
	ID        int32
	Status    string
	UpdatedBy pgtype.Int4
}

type SetAdjustmentDecisionRow 

type SetAdjustmentDecisionRow struct {
	Amount          int32
	AdjustmentType  string
	FinanceClientID int32
	InvoiceID       int32
	Outstanding     int32
}

type TransactionType 

type TransactionType struct {
	ID               int32
	FeeType          string
	SupervisionLevel string
	LedgerType       pgtype.Text
	AccountCode      pgtype.Int8
	Description      pgtype.Text
}

type UpdateClientParams 

type UpdateClientParams struct {
	CourtRef pgtype.Text
	ClientID int32
}

type UpdateLedgerAllocationAdjustmentParams 

type UpdateLedgerAllocationAdjustmentParams struct {
	Status string
	ID     int32
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.