store

package
v1.136.0-pfs-166-payme... Latest Latest
Warning

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

 Go to latest Published: Jan 29, 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 Assignee added in v1.135.0 

type Assignee struct {
	ID      int32
	Name    pgtype.Text
	Surname pgtype.Text
}

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 Case added in v1.135.0 

type Case struct {
	ID          int32
	ClientID    pgtype.Int4
	Orderstatus 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
}

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 Person added in v1.135.0 

type Person struct {
	ID            int32
	Firstname     pgtype.Text
	Surname       pgtype.Text
	Caserecnumber pgtype.Text
	FeepayerID    pgtype.Int4
	Deputytype    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) 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 Tx added in v1.135.0 

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

Tx is a wrapper around pgx.Tx that adds the transaction to the Queries, providing a method to commit

func NewTx added in v1.135.0 

func NewTx(tx pgx.Tx) *Tx

func (*Tx) Commit added in v1.135.0 

func (s *Tx) Commit(ctx context.Context) error

type UpdateClientParams 

type UpdateClientParams struct {
	CourtRef pgtype.Text
	ClientID 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.