db

package
v0.5.2 Latest Latest
Warning

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

 Go to latest Published: Sep 5, 2026 License: Apache-2.0 Imports: 3 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 {
	ID   uuid.UUID
	Code string
	Name string
	Type string
}

type AddProductBranchParams added in v0.5.1 

type AddProductBranchParams struct {
	ProductID uuid.UUID
	BranchID  uuid.UUID
}

type AddProductCategoryParams added in v0.1.7 

type AddProductCategoryParams struct {
	ProductID  uuid.UUID
	CategoryID uuid.UUID
}

type Branch 

type Branch struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Address   string
	CreatedAt string
	UpdatedAt string
}

type Category added in v0.1.7 

type Category struct {
	ID             uuid.UUID
	CompanyID      uuid.UUID
	Name           string
	NameNormalized string
	CreatedAt      string
}

type CloseSessionParams 

type CloseSessionParams struct {
	ClosedAt sql.NullString
	ID       uuid.UUID
}

type Company 

type Company struct {
	ID                       uuid.UUID
	OwnerID                  uuid.UUID
	Name                     string
	Currency                 string
	CreatedAt                string
	UpdatedAt                string
	Handle                   string
	LogoFileID               sql.NullString
	EnableRecipes            bool
	EnableAdvancedAccounting bool
	EnableAssetTracking      bool
}

type CountCustomersByCompanyParams 

type CountCustomersByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
}

type CountDiscountsByCompanyParams 

type CountDiscountsByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
}

type CountExpensesByCompanyParams 

type CountExpensesByCompanyParams struct {
	CompanyID   uuid.UUID
	Description string
}

type CountJournalEntriesByBranchEventParams added in v0.5.1 

type CountJournalEntriesByBranchEventParams struct {
	CompanyID uuid.UUID
	BranchID  sql.NullString
	EventName string
}

type CountJournalEntriesByCompanyFilteredParams added in v0.5.1 

type CountJournalEntriesByCompanyFilteredParams struct {
	CompanyID uuid.UUID
	DateFrom  interface{}
	DateTo    interface{}
	BranchID  interface{}
	EventName interface{}
}

type CountJournalEntriesByReferenceEventParams added in v0.5.1 

type CountJournalEntriesByReferenceEventParams struct {
	Reference string
	EventName string
}

type CountOrdersByCompanyAndDateParams 

type CountOrdersByCompanyAndDateParams struct {
	CompanyID uuid.UUID
	CreatedAt string
}

type CountProductsByCompanyAndTypeParams 

type CountProductsByCompanyAndTypeParams struct {
	CompanyID uuid.UUID
	Type      string
	Name      string
}

type CountProductsByCompanyFilteredParams added in v0.5.1 

type CountProductsByCompanyFilteredParams struct {
	CompanyID  uuid.UUID
	Name       string
	Type       interface{}
	CategoryID interface{}
	BranchID   interface{}
}

type CountProductsByCompanyParams 

type CountProductsByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
}

type CountProductsByCompanySellableForBranchParams added in v0.5.1 

type CountProductsByCompanySellableForBranchParams struct {
	CompanyID uuid.UUID
	Name      string
	BranchID  uuid.UUID
}

type CountProductsByCompanySellableParams 

type CountProductsByCompanySellableParams struct {
	CompanyID uuid.UUID
	Name      string
}

type CountStockMovementsByProductParams 

type CountStockMovementsByProductParams struct {
	ProductID uuid.UUID
	CompanyID uuid.UUID
}

type CountSuppliersByCompanyParams 

type CountSuppliersByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
}

type CreateBranchParams 

type CreateBranchParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Address   string
	CreatedAt string
	UpdatedAt string
}

type CreateCompanyParams 

type CreateCompanyParams struct {
	ID        uuid.UUID
	OwnerID   uuid.UUID
	Name      string
	Handle    string
	Currency  string
	CreatedAt string
	UpdatedAt string
}

type CreateCustomerParams 

type CreateCustomerParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Email     string
	Phone     string
	CreatedAt string
	UpdatedAt string
}

type CreateDiscountParams 

type CreateDiscountParams struct {
	ID             uuid.UUID
	CompanyID      uuid.UUID
	Name           string
	Type           string
	Value          int64
	Active         int64
	CreatedAt      string
	Code           sql.NullString
	ValidFrom      sql.NullString
	ValidUntil     sql.NullString
	MaxRedemptions sql.NullInt64
}

type CreateDiscountRedemptionParams added in v0.1.4 

type CreateDiscountRedemptionParams struct {
	ID         uuid.UUID
	DiscountID uuid.UUID
	OrderID    uuid.UUID
	CompanyID  uuid.UUID
	CreatedAt  string
}

type CreateExpenseParams 

type CreateExpenseParams struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	Amount      int64
	AccountCode string
	PaidFrom    string
	BranchID    sql.NullString
	CreatedAt   string
}

type CreateFileParams 

type CreateFileParams struct {
	ID         uuid.UUID
	CompanyID  uuid.UUID
	Intent     string
	StorageKey string
	MimeType   string
	SizeBytes  int64
	UploadedBy sql.NullString
	CreatedAt  string
}

type CreateFixedAssetParams added in v0.5.1 

type CreateFixedAssetParams struct {
	ID               uuid.UUID
	CompanyID        uuid.UUID
	BranchID         uuid.UUID
	Name             string
	Category         string
	PurchaseDate     string
	PurchaseCost     int64
	SalvageValue     int64
	UsefulLifeMonths int64
	Status           string
	CreatedAt        string
}

type CreateJournalEntryParams 

type CreateJournalEntryParams struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	EventName   string
	Reference   string
	BranchID    sql.NullString
	CreatedAt   string
	EntryDate   string
}

type CreateJournalLineParams 

type CreateJournalLineParams struct {
	ID        uuid.UUID
	EntryID   uuid.UUID
	AccountID uuid.UUID
	Debit     int64
	Credit    int64
}

type CreateOrderItemParams 

type CreateOrderItemParams struct {
	ID             uuid.UUID
	OrderID        uuid.UUID
	ProductID      uuid.UUID
	Quantity       int64
	UnitPrice      int64
	Subtotal       int64
	DiscountAmount int64
	DiscountID     sql.NullString
}

type CreateOrderParams 

type CreateOrderParams struct {
	ID         uuid.UUID
	CompanyID  uuid.UUID
	BranchID   uuid.UUID
	StationID  uuid.UUID
	SessionID  uuid.UUID
	CustomerID sql.NullString
	Status     string
	Total      int64
	CreatedAt  string
	UpdatedAt  string
}

type CreateOrderReturnItemParams 

type CreateOrderReturnItemParams struct {
	ID          uuid.UUID
	ReturnID    uuid.UUID
	OrderItemID uuid.UUID
	ProductID   uuid.UUID
	Quantity    int64
	UnitPrice   int64
	Subtotal    int64
}

type CreateOrderReturnParams 

type CreateOrderReturnParams struct {
	ID              uuid.UUID
	CompanyID       uuid.UUID
	OriginalOrderID uuid.UUID
	RefundAmount    int64
	RefundMethod    string
	Reason          string
	CreatedBy       uuid.UUID
	CreatedAt       string
}

type CreatePOSSessionParams 

type CreatePOSSessionParams struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	BranchID    uuid.UUID
	StationID   uuid.UUID
	UserID      uuid.UUID
	Status      string
	OpeningCash int64
	OpenedAt    string
}

type CreatePOSStationParams 

type CreatePOSStationParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	BranchID  uuid.UUID
	Name      string
	CreatedAt string
	UpdatedAt string
}

type CreatePaymentParams 

type CreatePaymentParams struct {
	ID             uuid.UUID
	OrderID        uuid.UUID
	Amount         int64
	Method         string
	Status         string
	CreatedAt      string
	TenderedAmount sql.NullInt64
}

type CreateProcurementInvoiceParams added in v0.5.1 

type CreateProcurementInvoiceParams struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	BranchID    sql.NullString
	SupplierID  uuid.UUID
	EntryDate   string
	DueDate     sql.NullString
	TotalAmount int64
	PaidAmount  int64
	Status      string
	CreatedAt   string
}

type CreateProductParams 

type CreateProductParams struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
}

type CreateRecipeComponentParams 

type CreateRecipeComponentParams struct {
	ID           uuid.UUID
	RecipeID     uuid.UUID
	IngredientID uuid.UUID
	Quantity     interface{}
}

type CreateRecipeOverheadParams 

type CreateRecipeOverheadParams struct {
	ID          uuid.UUID
	RecipeID    uuid.UUID
	Description string
	Cost        int64
}

type CreateSessionReconciliationParams 

type CreateSessionReconciliationParams struct {
	SessionID    uuid.UUID
	CompanyID    uuid.UUID
	ExpectedCash int64
	DeclaredCash int64
	Difference   int64
	ReconciledBy uuid.UUID
	ReconciledAt string
}

type CreateSupplierParams 

type CreateSupplierParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Contact   string
	Phone     string
	Email     string
	Address   string
	CreatedAt string
	UpdatedAt string
}

type CreateSupplierPaymentParams 

type CreateSupplierPaymentParams struct {
	ID         uuid.UUID
	CompanyID  uuid.UUID
	SupplierID uuid.UUID
	Amount     int64
	Notes      string
	PaidFrom   string
	CreatedAt  string
	InvoiceID  sql.NullString
}

type CreateUserParams 

type CreateUserParams struct {
	ID           uuid.UUID
	Email        string
	Name         string
	Role         int64
	PasswordHash string
	CompanyID    sql.NullString
	CreatedAt    string
	UpdatedAt    string
}

type Customer 

type Customer struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Email     string
	Phone     string
	CreatedAt string
	UpdatedAt string
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteFileParams 

type DeleteFileParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
}

type Discount 

type Discount struct {
	ID             uuid.UUID
	CompanyID      uuid.UUID
	Name           string
	Type           string
	Value          int64
	Active         int64
	CreatedAt      string
	Code           sql.NullString
	ValidFrom      sql.NullString
	ValidUntil     sql.NullString
	MaxRedemptions sql.NullInt64
}

type DiscountRedemption added in v0.1.4 

type DiscountRedemption struct {
	ID         uuid.UUID
	DiscountID uuid.UUID
	OrderID    uuid.UUID
	CompanyID  uuid.UUID
	CreatedAt  string
}

type Expense 

type Expense struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	Amount      int64
	CreatedAt   string
	AccountCode string
	PaidFrom    string
	BranchID    sql.NullString
}

type File 

type File struct {
	ID         uuid.UUID
	CompanyID  uuid.UUID
	Intent     string
	StorageKey string
	MimeType   string
	SizeBytes  int64
	UploadedBy sql.NullString
	CreatedAt  string
}

type FixedAsset added in v0.5.1 

type FixedAsset struct {
	ID               uuid.UUID
	CompanyID        uuid.UUID
	BranchID         uuid.UUID
	Name             string
	Category         string
	PurchaseDate     string
	PurchaseCost     int64
	SalvageValue     int64
	UsefulLifeMonths int64
	Status           string
	CreatedAt        string
	DisposedAt       sql.NullString
}

type GetCategoriesByProductRow added in v0.1.7 

type GetCategoriesByProductRow struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	CreatedAt string
}

type GetCompanyByHandleRow 

type GetCompanyByHandleRow struct {
	ID                       uuid.UUID
	OwnerID                  uuid.UUID
	Name                     string
	Handle                   string
	Currency                 string
	CreatedAt                string
	UpdatedAt                string
	LogoFileID               sql.NullString
	EnableRecipes            bool
	EnableAdvancedAccounting bool
	EnableAssetTracking      bool
}

type GetCompanyByIDRow 

type GetCompanyByIDRow struct {
	ID                       uuid.UUID
	OwnerID                  uuid.UUID
	Name                     string
	Handle                   string
	Currency                 string
	CreatedAt                string
	UpdatedAt                string
	LogoFileID               sql.NullString
	EnableRecipes            bool
	EnableAdvancedAccounting bool
	EnableAssetTracking      bool
}

type GetCustomerByCompanyAndEmailParams added in v0.1.2 

type GetCustomerByCompanyAndEmailParams struct {
	CompanyID uuid.UUID
	Email     string
}

type GetCustomerByCompanyAndPhoneParams added in v0.1.2 

type GetCustomerByCompanyAndPhoneParams struct {
	CompanyID uuid.UUID
	Phone     string
}

type GetDiscountByCodeParams added in v0.1.4 

type GetDiscountByCodeParams struct {
	CompanyID uuid.UUID
	Code      sql.NullString
}

type GetFileByIDParams 

type GetFileByIDParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
}

type GetOpenSessionByUserParams 

type GetOpenSessionByUserParams struct {
	CompanyID uuid.UUID
	UserID    uuid.UUID
}

type GetProductByIDRow 

type GetProductByIDRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type GetProductBySKUForBranchParams added in v0.5.1 

type GetProductBySKUForBranchParams struct {
	CompanyID uuid.UUID
	Sku       string
	BranchID  uuid.UUID
}

type GetProductBySKUForBranchRow added in v0.5.1 

type GetProductBySKUForBranchRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type GetProductBySKUParams 

type GetProductBySKUParams struct {
	CompanyID uuid.UUID
	Sku       string
}

type GetProductBySKURow 

type GetProductBySKURow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type GetUserByEmailRow 

type GetUserByEmailRow struct {
	ID              uuid.UUID
	Email           string
	Name            string
	Role            int64
	PasswordHash    string
	CompanyID       sql.NullString
	CreatedAt       string
	UpdatedAt       string
	TokenValidAfter sql.NullString
}

type GetUserByIDRow 

type GetUserByIDRow struct {
	ID              uuid.UUID
	Email           string
	Name            string
	Role            int64
	PasswordHash    string
	CompanyID       sql.NullString
	CreatedAt       string
	UpdatedAt       string
	TokenValidAfter sql.NullString
}

type Goqite 

type Goqite struct {
	ID       string
	Created  string
	Updated  string
	Queue    string
	Body     []byte
	Timeout  string
	Received int64
	Priority int64
}

type InvalidateUserTokensParams 

type InvalidateUserTokensParams struct {
	TokenValidAfter sql.NullString
	ID              uuid.UUID
}

type JournalEntry 

type JournalEntry struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	EventName   string
	Reference   string
	CreatedAt   string
	BranchID    sql.NullString
	EntryDate   string
}

type JournalLine 

type JournalLine struct {
	ID        uuid.UUID
	EntryID   uuid.UUID
	AccountID uuid.UUID
	Debit     int64
	Credit    int64
}

type ListActiveFixedAssetsByBranchParams added in v0.5.1 

type ListActiveFixedAssetsByBranchParams struct {
	CompanyID uuid.UUID
	BranchID  uuid.UUID
}

type ListBranchesByCompanyParams 

type ListBranchesByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListCategoriesByCompanyRow added in v0.1.7 

type ListCategoriesByCompanyRow struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	CreatedAt string
}

type ListCompaniesByOwnerParams 

type ListCompaniesByOwnerParams struct {
	OwnerID uuid.UUID
	Limit   int64
	Offset  int64
}

type ListCompaniesByOwnerRow 

type ListCompaniesByOwnerRow struct {
	ID                       uuid.UUID
	OwnerID                  uuid.UUID
	Name                     string
	Handle                   string
	Currency                 string
	CreatedAt                string
	UpdatedAt                string
	LogoFileID               sql.NullString
	EnableRecipes            bool
	EnableAdvancedAccounting bool
	EnableAssetTracking      bool
}

type ListCustomersByCompanyParams 

type ListCustomersByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
	Limit     int64
	Offset    int64
}

type ListDiscountsByCompanyParams 

type ListDiscountsByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
	Limit     int64
	Offset    int64
}

type ListExpensesByCompanyParams 

type ListExpensesByCompanyParams struct {
	CompanyID   uuid.UUID
	Description string
	Limit       int64
	Offset      int64
}

type ListJournalEntriesByCompanyFilteredParams added in v0.5.1 

type ListJournalEntriesByCompanyFilteredParams struct {
	CompanyID uuid.UUID
	DateFrom  interface{}
	DateTo    interface{}
	BranchID  interface{}
	EventName interface{}
	Offset    int64
	Limit     int64
}

type ListJournalEntriesByCompanyFilteredRow added in v0.5.1 

type ListJournalEntriesByCompanyFilteredRow struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	EventName   string
	Reference   string
	BranchID    sql.NullString
	CreatedAt   string
	EntryDate   string
}

type ListJournalEntriesByCompanyParams 

type ListJournalEntriesByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListJournalEntriesByCompanyRow added in v0.5.1 

type ListJournalEntriesByCompanyRow struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	Description string
	EventName   string
	Reference   string
	BranchID    sql.NullString
	CreatedAt   string
	EntryDate   string
}

type ListOrdersByCompanyParams 

type ListOrdersByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListOrdersBySessionParams 

type ListOrdersBySessionParams struct {
	SessionID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListPOSStationsByBranchParams 

type ListPOSStationsByBranchParams struct {
	BranchID uuid.UUID
	Limit    int64
	Offset   int64
}

type ListPOSStationsByCompanyParams 

type ListPOSStationsByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListProcurementInvoicesByCompanyParams added in v0.5.1 

type ListProcurementInvoicesByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListProcurementInvoicesBySupplierParams added in v0.5.1 

type ListProcurementInvoicesBySupplierParams struct {
	SupplierID uuid.UUID
	Limit      int64
	Offset     int64
}

type ListProductsByCompanyAndTypeParams 

type ListProductsByCompanyAndTypeParams struct {
	CompanyID uuid.UUID
	Type      string
	Name      string
	Limit     int64
	Offset    int64
}

type ListProductsByCompanyAndTypeRow 

type ListProductsByCompanyAndTypeRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type ListProductsByCompanyFilteredParams added in v0.5.1 

type ListProductsByCompanyFilteredParams struct {
	CompanyID  uuid.UUID
	Name       string
	Type       interface{}
	CategoryID interface{}
	BranchID   interface{}
	Offset     int64
	Limit      int64
}

type ListProductsByCompanyFilteredRow added in v0.5.1 

type ListProductsByCompanyFilteredRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type ListProductsByCompanyParams 

type ListProductsByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
	Limit     int64
	Offset    int64
}

type ListProductsByCompanyRow 

type ListProductsByCompanyRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type ListProductsByCompanySellableForBranchParams added in v0.5.1 

type ListProductsByCompanySellableForBranchParams struct {
	CompanyID uuid.UUID
	Name      string
	BranchID  uuid.UUID
	Limit     int64
	Offset    int64
}

type ListProductsByCompanySellableForBranchRow added in v0.5.1 

type ListProductsByCompanySellableForBranchRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type ListProductsByCompanySellableParams 

type ListProductsByCompanySellableParams struct {
	CompanyID uuid.UUID
	Name      string
	Limit     int64
	Offset    int64
}

type ListProductsByCompanySellableRow 

type ListProductsByCompanySellableRow struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	CreatedAt         string
	UpdatedAt         string
	ImageFileID       sql.NullString
}

type ListSelectableDiscountsByCompanyParams added in v0.1.4 

type ListSelectableDiscountsByCompanyParams struct {
	CompanyID  uuid.UUID
	ValidFrom  sql.NullString
	ValidUntil sql.NullString
}

type ListSessionsByCompanyParams 

type ListSessionsByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListStockMovementsByCompanyParams 

type ListStockMovementsByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListStockMovementsByProductParams 

type ListStockMovementsByProductParams struct {
	ProductID uuid.UUID
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListSupplierPaymentsByCompanyParams 

type ListSupplierPaymentsByCompanyParams struct {
	CompanyID uuid.UUID
	Limit     int64
	Offset    int64
}

type ListSupplierPaymentsBySupplierParams 

type ListSupplierPaymentsBySupplierParams struct {
	SupplierID uuid.UUID
	Limit      int64
	Offset     int64
}

type ListSuppliersByCompanyParams 

type ListSuppliersByCompanyParams struct {
	CompanyID uuid.UUID
	Name      string
	Limit     int64
	Offset    int64
}

type Order 

type Order struct {
	ID             uuid.UUID
	CompanyID      uuid.UUID
	BranchID       uuid.UUID
	StationID      uuid.UUID
	SessionID      uuid.UUID
	CustomerID     sql.NullString
	ReceiptNumber  sql.NullString
	Status         string
	Total          int64
	VoidedBy       sql.NullString
	VoidedAt       sql.NullString
	CreatedAt      string
	UpdatedAt      string
	DiscountAmount int64
	DiscountID     sql.NullString
}

type OrderItem 

type OrderItem struct {
	ID             uuid.UUID
	OrderID        uuid.UUID
	ProductID      uuid.UUID
	Quantity       int64
	UnitPrice      int64
	Subtotal       int64
	DiscountAmount int64
	DiscountID     sql.NullString
}

type OrderReturn 

type OrderReturn struct {
	ID              uuid.UUID
	CompanyID       uuid.UUID
	OriginalOrderID uuid.UUID
	RefundAmount    int64
	RefundMethod    string
	Reason          string
	CreatedBy       uuid.UUID
	CreatedAt       string
}

type OrderReturnItem 

type OrderReturnItem struct {
	ID          uuid.UUID
	ReturnID    uuid.UUID
	OrderItemID uuid.UUID
	ProductID   uuid.UUID
	Quantity    int64
	UnitPrice   int64
	Subtotal    int64
}

type PaginateUsersByCompanyParams 

type PaginateUsersByCompanyParams struct {
	CompanyID sql.NullString
	Limit     int64
	Offset    int64
}

type PaginateUsersByCompanyRow 

type PaginateUsersByCompanyRow struct {
	ID              uuid.UUID
	Email           string
	Name            string
	Role            int64
	PasswordHash    string
	CompanyID       sql.NullString
	CreatedAt       string
	UpdatedAt       string
	TokenValidAfter sql.NullString
}

type PaginateUsersParams 

type PaginateUsersParams struct {
	Limit  int64
	Offset int64
}

type PaginateUsersRow 

type PaginateUsersRow struct {
	ID              uuid.UUID
	Email           string
	Name            string
	Role            int64
	PasswordHash    string
	CompanyID       sql.NullString
	CreatedAt       string
	UpdatedAt       string
	TokenValidAfter sql.NullString
}

type Payment 

type Payment struct {
	ID             uuid.UUID
	OrderID        uuid.UUID
	Amount         int64
	Method         string
	Status         string
	CreatedAt      string
	TenderedAmount sql.NullInt64
}

type PosSession 

type PosSession struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	BranchID    uuid.UUID
	StationID   uuid.UUID
	UserID      uuid.UUID
	Status      string
	OpeningCash int64
	OpenedAt    string
	ClosedAt    sql.NullString
}

type PosStation 

type PosStation struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	BranchID  uuid.UUID
	Name      string
	CreatedAt string
	UpdatedAt string
}

type ProcurementInvoice added in v0.5.1 

type ProcurementInvoice struct {
	ID          uuid.UUID
	CompanyID   uuid.UUID
	BranchID    sql.NullString
	SupplierID  uuid.UUID
	EntryDate   string
	DueDate     sql.NullString
	TotalAmount int64
	PaidAmount  int64
	Status      string
	CreatedAt   string
}

type Product 

type Product struct {
	ID                uuid.UUID
	CompanyID         uuid.UUID
	Type              string
	Name              string
	BasePrice         int64
	Unit              string
	CreatedAt         string
	UpdatedAt         string
	LowStockThreshold int64
	Sku               string
	ImageFileID       sql.NullString
	ExpiryWarningDays int64
}

type ProductBranch added in v0.5.1 

type ProductBranch struct {
	ProductID uuid.UUID
	BranchID  uuid.UUID
}

type ProductCategory added in v0.1.7 

type ProductCategory struct {
	ProductID  uuid.UUID
	CategoryID uuid.UUID
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddProductBranch added in v0.5.1 

func (q *Queries) AddProductBranch(ctx context.Context, arg AddProductBranchParams) error

func (*Queries) AddProductCategory added in v0.1.7 

func (q *Queries) AddProductCategory(ctx context.Context, arg AddProductCategoryParams) error

func (*Queries) CloseSession 

func (q *Queries) CloseSession(ctx context.Context, arg CloseSessionParams) error

func (*Queries) CountBranchesByCompany 

func (q *Queries) CountBranchesByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountCompaniesByOwner 

func (q *Queries) CountCompaniesByOwner(ctx context.Context, ownerID uuid.UUID) (int64, error)

func (*Queries) CountCustomersByCompany 

func (q *Queries) CountCustomersByCompany(ctx context.Context, arg CountCustomersByCompanyParams) (int64, error)

func (*Queries) CountDiscountRedemptionsByDiscount added in v0.1.4 

func (q *Queries) CountDiscountRedemptionsByDiscount(ctx context.Context, discountID uuid.UUID) (int64, error)

func (*Queries) CountDiscountsByCompany 

func (q *Queries) CountDiscountsByCompany(ctx context.Context, arg CountDiscountsByCompanyParams) (int64, error)

func (*Queries) CountExpensesByCompany 

func (q *Queries) CountExpensesByCompany(ctx context.Context, arg CountExpensesByCompanyParams) (int64, error)

func (*Queries) CountJournalEntriesByBranchEvent added in v0.5.1 

func (q *Queries) CountJournalEntriesByBranchEvent(ctx context.Context, arg CountJournalEntriesByBranchEventParams) (int64, error)

func (*Queries) CountJournalEntriesByCompany 

func (q *Queries) CountJournalEntriesByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountJournalEntriesByCompanyFiltered added in v0.5.1 

func (q *Queries) CountJournalEntriesByCompanyFiltered(ctx context.Context, arg CountJournalEntriesByCompanyFilteredParams) (int64, error)

func (*Queries) CountJournalEntriesByReferenceEvent added in v0.5.1 

func (q *Queries) CountJournalEntriesByReferenceEvent(ctx context.Context, arg CountJournalEntriesByReferenceEventParams) (int64, error)

func (*Queries) CountMovementsReversing added in v0.1.2 

func (q *Queries) CountMovementsReversing(ctx context.Context, reversesMovementID sql.NullString) (int64, error)

func (*Queries) CountOrdersByCompany 

func (q *Queries) CountOrdersByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountOrdersByCompanyAndDate 

func (q *Queries) CountOrdersByCompanyAndDate(ctx context.Context, arg CountOrdersByCompanyAndDateParams) (int64, error)

func (*Queries) CountOrdersBySession 

func (q *Queries) CountOrdersBySession(ctx context.Context, sessionID uuid.UUID) (int64, error)

func (*Queries) CountPOSStationsByCompany 

func (q *Queries) CountPOSStationsByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountProcurementInvoicesByCompany added in v0.5.1 

func (q *Queries) CountProcurementInvoicesByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountProcurementInvoicesBySupplier added in v0.5.1 

func (q *Queries) CountProcurementInvoicesBySupplier(ctx context.Context, supplierID uuid.UUID) (int64, error)

func (*Queries) CountProductsByCompany 

func (q *Queries) CountProductsByCompany(ctx context.Context, arg CountProductsByCompanyParams) (int64, error)

func (*Queries) CountProductsByCompanyAndType 

func (q *Queries) CountProductsByCompanyAndType(ctx context.Context, arg CountProductsByCompanyAndTypeParams) (int64, error)

func (*Queries) CountProductsByCompanyFiltered added in v0.5.1 

func (q *Queries) CountProductsByCompanyFiltered(ctx context.Context, arg CountProductsByCompanyFilteredParams) (int64, error)

func (*Queries) CountProductsByCompanySellable 

func (q *Queries) CountProductsByCompanySellable(ctx context.Context, arg CountProductsByCompanySellableParams) (int64, error)

func (*Queries) CountProductsByCompanySellableForBranch added in v0.5.1 

func (q *Queries) CountProductsByCompanySellableForBranch(ctx context.Context, arg CountProductsByCompanySellableForBranchParams) (int64, error)

func (*Queries) CountSessionsByCompany 

func (q *Queries) CountSessionsByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountStockMovementsByCompany 

func (q *Queries) CountStockMovementsByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountStockMovementsByProduct 

func (q *Queries) CountStockMovementsByProduct(ctx context.Context, arg CountStockMovementsByProductParams) (int64, error)

func (*Queries) CountSupplierPaymentsByCompany 

func (q *Queries) CountSupplierPaymentsByCompany(ctx context.Context, companyID uuid.UUID) (int64, error)

func (*Queries) CountSupplierPaymentsBySupplier 

func (q *Queries) CountSupplierPaymentsBySupplier(ctx context.Context, supplierID uuid.UUID) (int64, error)

func (*Queries) CountSuppliersByCompany 

func (q *Queries) CountSuppliersByCompany(ctx context.Context, arg CountSuppliersByCompanyParams) (int64, error)

func (*Queries) CountUsers 

func (q *Queries) CountUsers(ctx context.Context) (int64, error)

func (*Queries) CountUsersByCompany 

func (q *Queries) CountUsersByCompany(ctx context.Context, companyID sql.NullString) (int64, error)

func (*Queries) CountUsersByRole added in v0.1.7 

func (q *Queries) CountUsersByRole(ctx context.Context, role int64) (int64, error)

func (*Queries) CreateBranch 

func (q *Queries) CreateBranch(ctx context.Context, arg CreateBranchParams) error

func (*Queries) CreateCompany 

func (q *Queries) CreateCompany(ctx context.Context, arg CreateCompanyParams) error

func (*Queries) CreateCustomer 

func (q *Queries) CreateCustomer(ctx context.Context, arg CreateCustomerParams) error

func (*Queries) CreateDiscount 

func (q *Queries) CreateDiscount(ctx context.Context, arg CreateDiscountParams) error

func (*Queries) CreateDiscountRedemption added in v0.1.4 

func (q *Queries) CreateDiscountRedemption(ctx context.Context, arg CreateDiscountRedemptionParams) error

func (*Queries) CreateExpense 

func (q *Queries) CreateExpense(ctx context.Context, arg CreateExpenseParams) error

func (*Queries) CreateFile 

func (q *Queries) CreateFile(ctx context.Context, arg CreateFileParams) error

func (*Queries) CreateFixedAsset added in v0.5.1 

func (q *Queries) CreateFixedAsset(ctx context.Context, arg CreateFixedAssetParams) error

func (*Queries) CreateJournalEntry 

func (q *Queries) CreateJournalEntry(ctx context.Context, arg CreateJournalEntryParams) error

func (*Queries) CreateJournalLine 

func (q *Queries) CreateJournalLine(ctx context.Context, arg CreateJournalLineParams) error

func (*Queries) CreateOrder 

func (q *Queries) CreateOrder(ctx context.Context, arg CreateOrderParams) error

func (*Queries) CreateOrderItem 

func (q *Queries) CreateOrderItem(ctx context.Context, arg CreateOrderItemParams) error

func (*Queries) CreateOrderReturn 

func (q *Queries) CreateOrderReturn(ctx context.Context, arg CreateOrderReturnParams) error

func (*Queries) CreateOrderReturnItem 

func (q *Queries) CreateOrderReturnItem(ctx context.Context, arg CreateOrderReturnItemParams) error

func (*Queries) CreatePOSSession 

func (q *Queries) CreatePOSSession(ctx context.Context, arg CreatePOSSessionParams) error

func (*Queries) CreatePOSStation 

func (q *Queries) CreatePOSStation(ctx context.Context, arg CreatePOSStationParams) error

func (*Queries) CreatePayment 

func (q *Queries) CreatePayment(ctx context.Context, arg CreatePaymentParams) error

func (*Queries) CreateProcurementInvoice added in v0.5.1 

func (q *Queries) CreateProcurementInvoice(ctx context.Context, arg CreateProcurementInvoiceParams) error

func (*Queries) CreateProduct 

func (q *Queries) CreateProduct(ctx context.Context, arg CreateProductParams) error

func (*Queries) CreateRecipeComponent 

func (q *Queries) CreateRecipeComponent(ctx context.Context, arg CreateRecipeComponentParams) error

func (*Queries) CreateRecipeOverhead 

func (q *Queries) CreateRecipeOverhead(ctx context.Context, arg CreateRecipeOverheadParams) error

func (*Queries) CreateSessionReconciliation 

func (q *Queries) CreateSessionReconciliation(ctx context.Context, arg CreateSessionReconciliationParams) error

func (*Queries) CreateSupplier 

func (q *Queries) CreateSupplier(ctx context.Context, arg CreateSupplierParams) error

func (*Queries) CreateSupplierPayment 

func (q *Queries) CreateSupplierPayment(ctx context.Context, arg CreateSupplierPaymentParams) error

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error

func (*Queries) CurrentStockByProduct 

func (q *Queries) CurrentStockByProduct(ctx context.Context, productID uuid.UUID) (interface{}, error)

func (*Queries) DeleteBranch 

func (q *Queries) DeleteBranch(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteCompany 

func (q *Queries) DeleteCompany(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteCustomer 

func (q *Queries) DeleteCustomer(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteDiscount 

func (q *Queries) DeleteDiscount(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteDiscountRedemptionByOrder added in v0.1.4 

func (q *Queries) DeleteDiscountRedemptionByOrder(ctx context.Context, orderID uuid.UUID) error

func (*Queries) DeleteFile 

func (q *Queries) DeleteFile(ctx context.Context, arg DeleteFileParams) error

func (*Queries) DeleteOpenOrdersBySession 

func (q *Queries) DeleteOpenOrdersBySession(ctx context.Context, sessionID uuid.UUID) (int64, error)

func (*Queries) DeleteOrder 

func (q *Queries) DeleteOrder(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteOrderItem 

func (q *Queries) DeleteOrderItem(ctx context.Context, id uuid.UUID) error

func (*Queries) DeletePOSStation 

func (q *Queries) DeletePOSStation(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteProduct 

func (q *Queries) DeleteProduct(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteProductBranches added in v0.5.1 

func (q *Queries) DeleteProductBranches(ctx context.Context, productID uuid.UUID) error

func (*Queries) DeleteProductCategories added in v0.1.7 

func (q *Queries) DeleteProductCategories(ctx context.Context, productID uuid.UUID) error

func (*Queries) DeleteRecipeComponentsByRecipe 

func (q *Queries) DeleteRecipeComponentsByRecipe(ctx context.Context, recipeID uuid.UUID) error

func (*Queries) DeleteRecipeOverheadsByRecipe 

func (q *Queries) DeleteRecipeOverheadsByRecipe(ctx context.Context, recipeID uuid.UUID) error

func (*Queries) DeleteSupplier 

func (q *Queries) DeleteSupplier(ctx context.Context, id uuid.UUID) error

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error

func (*Queries) GetAccountByCode 

func (q *Queries) GetAccountByCode(ctx context.Context, code string) (Account, error)

func (*Queries) GetBranchByID 

func (q *Queries) GetBranchByID(ctx context.Context, id uuid.UUID) (Branch, error)

func (*Queries) GetBranchesByProduct added in v0.5.1 

func (q *Queries) GetBranchesByProduct(ctx context.Context, productID uuid.UUID) ([]Branch, error)

func (*Queries) GetCategoriesByProduct added in v0.1.7 

func (q *Queries) GetCategoriesByProduct(ctx context.Context, productID uuid.UUID) ([]GetCategoriesByProductRow, error)

func (*Queries) GetCompanyByHandle 

func (q *Queries) GetCompanyByHandle(ctx context.Context, handle string) (GetCompanyByHandleRow, error)

func (*Queries) GetCompanyByID 

func (q *Queries) GetCompanyByID(ctx context.Context, id uuid.UUID) (GetCompanyByIDRow, error)

func (*Queries) GetCustomerByCompanyAndEmail added in v0.1.2 

func (q *Queries) GetCustomerByCompanyAndEmail(ctx context.Context, arg GetCustomerByCompanyAndEmailParams) (Customer, error)

func (*Queries) GetCustomerByCompanyAndPhone added in v0.1.2 

func (q *Queries) GetCustomerByCompanyAndPhone(ctx context.Context, arg GetCustomerByCompanyAndPhoneParams) (Customer, error)

func (*Queries) GetCustomerByID 

func (q *Queries) GetCustomerByID(ctx context.Context, id uuid.UUID) (Customer, error)

func (*Queries) GetDiscountByCode added in v0.1.4 

func (q *Queries) GetDiscountByCode(ctx context.Context, arg GetDiscountByCodeParams) (Discount, error)

func (*Queries) GetDiscountByID 

func (q *Queries) GetDiscountByID(ctx context.Context, id uuid.UUID) (Discount, error)

func (*Queries) GetExpenseByID 

func (q *Queries) GetExpenseByID(ctx context.Context, id uuid.UUID) (Expense, error)

func (*Queries) GetFileByID 

func (q *Queries) GetFileByID(ctx context.Context, arg GetFileByIDParams) (File, error)

func (*Queries) GetFixedAssetByID added in v0.5.1 

func (q *Queries) GetFixedAssetByID(ctx context.Context, id uuid.UUID) (FixedAsset, error)

func (*Queries) GetLPPByProduct 

func (q *Queries) GetLPPByProduct(ctx context.Context, productID uuid.UUID) (sql.NullInt64, error)

func (*Queries) GetLPPHistoryByProduct added in v0.5.1 

func (q *Queries) GetLPPHistoryByProduct(ctx context.Context, productID uuid.UUID) ([]sql.NullInt64, error)

func (*Queries) GetOpenOrderBySession added in v0.5.1 

func (q *Queries) GetOpenOrderBySession(ctx context.Context, sessionID uuid.UUID) (Order, error)

A session has at most one open order at a time (all others are paid or voided), so this is a direct status filter, unlike ListOrdersBySession, which isn't bounded by pagination and stays correct no matter how many orders the session has accumulated.

func (*Queries) GetOpenSessionByStation 

func (q *Queries) GetOpenSessionByStation(ctx context.Context, stationID uuid.UUID) (PosSession, error)

func (*Queries) GetOpenSessionByUser 

func (q *Queries) GetOpenSessionByUser(ctx context.Context, arg GetOpenSessionByUserParams) (PosSession, error)

func (*Queries) GetOrderByID 

func (q *Queries) GetOrderByID(ctx context.Context, id uuid.UUID) (Order, error)

func (*Queries) GetOrderItemByID 

func (q *Queries) GetOrderItemByID(ctx context.Context, id uuid.UUID) (OrderItem, error)

func (*Queries) GetOrderReturnByID 

func (q *Queries) GetOrderReturnByID(ctx context.Context, id uuid.UUID) (OrderReturn, error)

func (*Queries) GetPOSSessionByID 

func (q *Queries) GetPOSSessionByID(ctx context.Context, id uuid.UUID) (PosSession, error)

func (*Queries) GetPOSStationByID 

func (q *Queries) GetPOSStationByID(ctx context.Context, id uuid.UUID) (PosStation, error)

func (*Queries) GetProcurementInvoiceByID added in v0.5.1 

func (q *Queries) GetProcurementInvoiceByID(ctx context.Context, id uuid.UUID) (ProcurementInvoice, error)

func (*Queries) GetProductByID 

func (q *Queries) GetProductByID(ctx context.Context, id uuid.UUID) (GetProductByIDRow, error)

func (*Queries) GetProductBySKU 

func (q *Queries) GetProductBySKU(ctx context.Context, arg GetProductBySKUParams) (GetProductBySKURow, error)

func (*Queries) GetProductBySKUForBranch added in v0.5.1 

func (q *Queries) GetProductBySKUForBranch(ctx context.Context, arg GetProductBySKUForBranchParams) (GetProductBySKUForBranchRow, error)

func (*Queries) GetRecipeComponents 

func (q *Queries) GetRecipeComponents(ctx context.Context, recipeID uuid.UUID) ([]RecipeComponent, error)

func (*Queries) GetRecipeOverheads 

func (q *Queries) GetRecipeOverheads(ctx context.Context, recipeID uuid.UUID) ([]RecipeOverhead, error)

func (*Queries) GetReconciliationBySession 

func (q *Queries) GetReconciliationBySession(ctx context.Context, sessionID uuid.UUID) (SessionReconciliation, error)

func (*Queries) GetStockMovementByID 

func (q *Queries) GetStockMovementByID(ctx context.Context, id uuid.UUID) (StockMovement, error)

func (*Queries) GetSupplierByID 

func (q *Queries) GetSupplierByID(ctx context.Context, id uuid.UUID) (Supplier, error)

func (*Queries) GetSupplierPaymentByID 

func (q *Queries) GetSupplierPaymentByID(ctx context.Context, id uuid.UUID) (SupplierPayment, error)

func (*Queries) GetUserByEmail 

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (GetUserByEmailRow, error)

func (*Queries) GetUserByID 

func (q *Queries) GetUserByID(ctx context.Context, id uuid.UUID) (GetUserByIDRow, error)

func (*Queries) HasAssetsForCompany added in v0.5.1 

func (q *Queries) HasAssetsForCompany(ctx context.Context, companyID uuid.UUID) (bool, error)

func (*Queries) HasMovementsByProduct 

func (q *Queries) HasMovementsByProduct(ctx context.Context, productID uuid.UUID) (int64, error)

func (*Queries) HasOpenOrdersBySession 

func (q *Queries) HasOpenOrdersBySession(ctx context.Context, sessionID uuid.UUID) (int64, error)

func (*Queries) HasRecipeOrIngredientProducts added in v0.5.1 

func (q *Queries) HasRecipeOrIngredientProducts(ctx context.Context, companyID uuid.UUID) (bool, error)

func (*Queries) InvalidateUserTokens 

func (q *Queries) InvalidateUserTokens(ctx context.Context, arg InvalidateUserTokensParams) error

func (*Queries) ListAccounts 

func (q *Queries) ListAccounts(ctx context.Context) ([]Account, error)

func (*Queries) ListActiveFixedAssetsByBranch added in v0.5.1 

func (q *Queries) ListActiveFixedAssetsByBranch(ctx context.Context, arg ListActiveFixedAssetsByBranchParams) ([]FixedAsset, error)

func (*Queries) ListBranchesByCompany 

func (q *Queries) ListBranchesByCompany(ctx context.Context, arg ListBranchesByCompanyParams) ([]Branch, error)

func (*Queries) ListCategoriesByCompany added in v0.1.7 

func (q *Queries) ListCategoriesByCompany(ctx context.Context, companyID uuid.UUID) ([]ListCategoriesByCompanyRow, error)

func (*Queries) ListCompaniesByOwner 

func (q *Queries) ListCompaniesByOwner(ctx context.Context, arg ListCompaniesByOwnerParams) ([]ListCompaniesByOwnerRow, error)

func (*Queries) ListCustomersByCompany 

func (q *Queries) ListCustomersByCompany(ctx context.Context, arg ListCustomersByCompanyParams) ([]Customer, error)

func (*Queries) ListDiscountsByCompany 

func (q *Queries) ListDiscountsByCompany(ctx context.Context, arg ListDiscountsByCompanyParams) ([]Discount, error)

func (*Queries) ListExpensesByCompany 

func (q *Queries) ListExpensesByCompany(ctx context.Context, arg ListExpensesByCompanyParams) ([]Expense, error)

func (*Queries) ListFixedAssetsByCompany added in v0.5.1 

func (q *Queries) ListFixedAssetsByCompany(ctx context.Context, companyID uuid.UUID) ([]FixedAsset, error)

func (*Queries) ListJournalEntriesByCompany 

func (q *Queries) ListJournalEntriesByCompany(ctx context.Context, arg ListJournalEntriesByCompanyParams) ([]ListJournalEntriesByCompanyRow, error)

func (*Queries) ListJournalEntriesByCompanyFiltered added in v0.5.1 

func (q *Queries) ListJournalEntriesByCompanyFiltered(ctx context.Context, arg ListJournalEntriesByCompanyFilteredParams) ([]ListJournalEntriesByCompanyFilteredRow, error)

func (*Queries) ListJournalLinesByEntry 

func (q *Queries) ListJournalLinesByEntry(ctx context.Context, entryID uuid.UUID) ([]JournalLine, error)

func (*Queries) ListOpenProcurementInvoicesBySupplier added in v0.5.1 

func (q *Queries) ListOpenProcurementInvoicesBySupplier(ctx context.Context, supplierID uuid.UUID) ([]ProcurementInvoice, error)

func (*Queries) ListOrderItemsByOrder 

func (q *Queries) ListOrderItemsByOrder(ctx context.Context, orderID uuid.UUID) ([]OrderItem, error)

func (*Queries) ListOrderReturnItemsByReturn 

func (q *Queries) ListOrderReturnItemsByReturn(ctx context.Context, returnID uuid.UUID) ([]OrderReturnItem, error)

func (*Queries) ListOrderReturnsByOrder 

func (q *Queries) ListOrderReturnsByOrder(ctx context.Context, originalOrderID uuid.UUID) ([]OrderReturn, error)

func (*Queries) ListOrdersByCompany 

func (q *Queries) ListOrdersByCompany(ctx context.Context, arg ListOrdersByCompanyParams) ([]Order, error)

func (*Queries) ListOrdersBySession 

func (q *Queries) ListOrdersBySession(ctx context.Context, arg ListOrdersBySessionParams) ([]Order, error)

func (*Queries) ListPOSStationsByBranch 

func (q *Queries) ListPOSStationsByBranch(ctx context.Context, arg ListPOSStationsByBranchParams) ([]PosStation, error)

func (*Queries) ListPOSStationsByCompany 

func (q *Queries) ListPOSStationsByCompany(ctx context.Context, arg ListPOSStationsByCompanyParams) ([]PosStation, error)

func (*Queries) ListPaymentsByOrder 

func (q *Queries) ListPaymentsByOrder(ctx context.Context, orderID uuid.UUID) ([]Payment, error)

func (*Queries) ListProcurementInvoicesByCompany added in v0.5.1 

func (q *Queries) ListProcurementInvoicesByCompany(ctx context.Context, arg ListProcurementInvoicesByCompanyParams) ([]ProcurementInvoice, error)

func (*Queries) ListProcurementInvoicesBySupplier added in v0.5.1 

func (q *Queries) ListProcurementInvoicesBySupplier(ctx context.Context, arg ListProcurementInvoicesBySupplierParams) ([]ProcurementInvoice, error)

func (*Queries) ListProductsByCompany 

func (q *Queries) ListProductsByCompany(ctx context.Context, arg ListProductsByCompanyParams) ([]ListProductsByCompanyRow, error)

func (*Queries) ListProductsByCompanyAndType 

func (q *Queries) ListProductsByCompanyAndType(ctx context.Context, arg ListProductsByCompanyAndTypeParams) ([]ListProductsByCompanyAndTypeRow, error)

func (*Queries) ListProductsByCompanyFiltered added in v0.5.1 

func (q *Queries) ListProductsByCompanyFiltered(ctx context.Context, arg ListProductsByCompanyFilteredParams) ([]ListProductsByCompanyFilteredRow, error)

func (*Queries) ListProductsByCompanySellable 

func (q *Queries) ListProductsByCompanySellable(ctx context.Context, arg ListProductsByCompanySellableParams) ([]ListProductsByCompanySellableRow, error)

func (*Queries) ListProductsByCompanySellableForBranch added in v0.5.1 

func (q *Queries) ListProductsByCompanySellableForBranch(ctx context.Context, arg ListProductsByCompanySellableForBranchParams) ([]ListProductsByCompanySellableForBranchRow, error)

func (*Queries) ListSelectableDiscountsByCompany added in v0.1.4 

func (q *Queries) ListSelectableDiscountsByCompany(ctx context.Context, arg ListSelectableDiscountsByCompanyParams) ([]Discount, error)

func (*Queries) ListSessionsByCompany 

func (q *Queries) ListSessionsByCompany(ctx context.Context, arg ListSessionsByCompanyParams) ([]PosSession, error)

func (*Queries) ListStockMovementsByCompany 

func (q *Queries) ListStockMovementsByCompany(ctx context.Context, arg ListStockMovementsByCompanyParams) ([]StockMovement, error)

func (*Queries) ListStockMovementsByProduct 

func (q *Queries) ListStockMovementsByProduct(ctx context.Context, arg ListStockMovementsByProductParams) ([]StockMovement, error)

func (*Queries) ListSupplierPaymentsByCompany 

func (q *Queries) ListSupplierPaymentsByCompany(ctx context.Context, arg ListSupplierPaymentsByCompanyParams) ([]SupplierPayment, error)

func (*Queries) ListSupplierPaymentsBySupplier 

func (q *Queries) ListSupplierPaymentsBySupplier(ctx context.Context, arg ListSupplierPaymentsBySupplierParams) ([]SupplierPayment, error)

func (*Queries) ListSuppliersByCompany 

func (q *Queries) ListSuppliersByCompany(ctx context.Context, arg ListSuppliersByCompanyParams) ([]Supplier, error)

func (*Queries) PaginateUsers 

func (q *Queries) PaginateUsers(ctx context.Context, arg PaginateUsersParams) ([]PaginateUsersRow, error)

func (*Queries) PaginateUsersByCompany 

func (q *Queries) PaginateUsersByCompany(ctx context.Context, arg PaginateUsersByCompanyParams) ([]PaginateUsersByCompanyRow, error)

func (*Queries) RecordStockMovement 

func (q *Queries) RecordStockMovement(ctx context.Context, arg RecordStockMovementParams) error

func (*Queries) StockAtByProduct 

func (q *Queries) StockAtByProduct(ctx context.Context, arg StockAtByProductParams) (interface{}, error)

func (*Queries) SumCashPaymentsBySession 

func (q *Queries) SumCashPaymentsBySession(ctx context.Context, sessionID uuid.UUID) (interface{}, error)

Nets refunds against completed sales: a cash refund on a return should reduce the tracked drawer balance, not merely be excluded from it.

func (*Queries) SumPaymentsByOrder 

func (q *Queries) SumPaymentsByOrder(ctx context.Context, orderID uuid.UUID) (interface{}, error)

func (*Queries) UpdateBranch 

func (q *Queries) UpdateBranch(ctx context.Context, arg UpdateBranchParams) error

func (*Queries) UpdateCompany 

func (q *Queries) UpdateCompany(ctx context.Context, arg UpdateCompanyParams) error

func (*Queries) UpdateCustomer 

func (q *Queries) UpdateCustomer(ctx context.Context, arg UpdateCustomerParams) error

func (*Queries) UpdateDiscount 

func (q *Queries) UpdateDiscount(ctx context.Context, arg UpdateDiscountParams) error

func (*Queries) UpdateFixedAsset added in v0.5.1 

func (q *Queries) UpdateFixedAsset(ctx context.Context, arg UpdateFixedAssetParams) error

func (*Queries) UpdateOrder 

func (q *Queries) UpdateOrder(ctx context.Context, arg UpdateOrderParams) error

func (*Queries) UpdateOrderItem 

func (q *Queries) UpdateOrderItem(ctx context.Context, arg UpdateOrderItemParams) error

func (*Queries) UpdatePOSStation 

func (q *Queries) UpdatePOSStation(ctx context.Context, arg UpdatePOSStationParams) error

func (*Queries) UpdateProcurementInvoicePaid added in v0.5.1 

func (q *Queries) UpdateProcurementInvoicePaid(ctx context.Context, arg UpdateProcurementInvoicePaidParams) error

func (*Queries) UpdateProcurementInvoiceTotalAmount added in v0.5.1 

func (q *Queries) UpdateProcurementInvoiceTotalAmount(ctx context.Context, arg UpdateProcurementInvoiceTotalAmountParams) error

func (*Queries) UpdateProduct 

func (q *Queries) UpdateProduct(ctx context.Context, arg UpdateProductParams) error

func (*Queries) UpdateSupplier 

func (q *Queries) UpdateSupplier(ctx context.Context, arg UpdateSupplierParams) error

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) error

func (*Queries) UpdateUserPasswordHash 

func (q *Queries) UpdateUserPasswordHash(ctx context.Context, arg UpdateUserPasswordHashParams) error

func (*Queries) UpsertCategory added in v0.1.7 

func (q *Queries) UpsertCategory(ctx context.Context, arg UpsertCategoryParams) (UpsertCategoryRow, error)

func (*Queries) WithTx 

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

type RecipeComponent 

type RecipeComponent struct {
	ID           uuid.UUID
	RecipeID     uuid.UUID
	IngredientID uuid.UUID
	Quantity     interface{}
}

type RecipeOverhead 

type RecipeOverhead struct {
	ID          uuid.UUID
	RecipeID    uuid.UUID
	Description string
	Cost        int64
}

type RecordStockMovementParams 

type RecordStockMovementParams struct {
	ID                  uuid.UUID
	CompanyID           uuid.UUID
	ProductID           uuid.UUID
	Reason              string
	Delta               interface{}
	UnitCost            sql.NullInt64
	Notes               string
	CreatedAt           string
	SupplierID          sql.NullString
	ReversesMovementID  sql.NullString
	PostedAmount        sql.NullInt64
	PostedCreditAccount sql.NullString
	InvoiceID           sql.NullString
	BranchID            sql.NullString
	ExpiryDate          sql.NullString
}

type SessionReconciliation 

type SessionReconciliation struct {
	SessionID    uuid.UUID
	CompanyID    uuid.UUID
	ExpectedCash int64
	DeclaredCash int64
	Difference   int64
	ReconciledBy uuid.UUID
	ReconciledAt string
}

type StockAtByProductParams 

type StockAtByProductParams struct {
	ProductID uuid.UUID
	CreatedAt string
}

type StockMovement 

type StockMovement struct {
	ID                  uuid.UUID
	CompanyID           uuid.UUID
	ProductID           uuid.UUID
	Reason              string
	Delta               interface{}
	UnitCost            sql.NullInt64
	Notes               string
	CreatedAt           string
	SupplierID          sql.NullString
	ReversesMovementID  sql.NullString
	PostedAmount        sql.NullInt64
	PostedCreditAccount sql.NullString
	InvoiceID           sql.NullString
	BranchID            sql.NullString
	ExpiryDate          sql.NullString
}

type Supplier 

type Supplier struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	Contact   string
	Phone     string
	Email     string
	Address   string
	CreatedAt string
	UpdatedAt string
}

type SupplierPayment 

type SupplierPayment struct {
	ID         uuid.UUID
	CompanyID  uuid.UUID
	SupplierID uuid.UUID
	Amount     int64
	Notes      string
	CreatedAt  string
	PaidFrom   string
	InvoiceID  sql.NullString
}

type UpdateBranchParams 

type UpdateBranchParams struct {
	Name      string
	Address   string
	UpdatedAt string
	ID        uuid.UUID
}

type UpdateCompanyParams 

type UpdateCompanyParams struct {
	Name                     string
	Handle                   string
	Currency                 string
	LogoFileID               sql.NullString
	EnableRecipes            bool
	EnableAdvancedAccounting bool
	EnableAssetTracking      bool
	UpdatedAt                string
	ID                       uuid.UUID
}

type UpdateCustomerParams 

type UpdateCustomerParams struct {
	Name      string
	Email     string
	Phone     string
	UpdatedAt string
	ID        uuid.UUID
}

type UpdateDiscountParams 

type UpdateDiscountParams struct {
	Name           string
	Value          int64
	Active         int64
	Code           sql.NullString
	ValidFrom      sql.NullString
	ValidUntil     sql.NullString
	MaxRedemptions sql.NullInt64
	ID             uuid.UUID
}

type UpdateFixedAssetParams added in v0.5.1 

type UpdateFixedAssetParams struct {
	Name             string
	Category         string
	BranchID         uuid.UUID
	PurchaseDate     string
	PurchaseCost     int64
	SalvageValue     int64
	UsefulLifeMonths int64
	Status           string
	DisposedAt       sql.NullString
	ID               uuid.UUID
}

type UpdateOrderItemParams 

type UpdateOrderItemParams struct {
	Quantity int64
	Subtotal int64
	ID       uuid.UUID
}

type UpdateOrderParams 

type UpdateOrderParams struct {
	Status         string
	Total          int64
	ReceiptNumber  sql.NullString
	VoidedBy       sql.NullString
	VoidedAt       sql.NullString
	DiscountAmount int64
	DiscountID     sql.NullString
	CustomerID     sql.NullString
	UpdatedAt      string
	ID             uuid.UUID
}

type UpdatePOSStationParams 

type UpdatePOSStationParams struct {
	Name      string
	UpdatedAt string
	ID        uuid.UUID
}

type UpdateProcurementInvoicePaidParams added in v0.5.1 

type UpdateProcurementInvoicePaidParams struct {
	PaidAmount int64
	Status     string
	ID         uuid.UUID
}

type UpdateProcurementInvoiceTotalAmountParams added in v0.5.1 

type UpdateProcurementInvoiceTotalAmountParams struct {
	TotalAmount int64
	ID          uuid.UUID
}

type UpdateProductParams 

type UpdateProductParams struct {
	Name              string
	BasePrice         int64
	Unit              string
	LowStockThreshold int64
	ExpiryWarningDays int64
	Sku               string
	ImageFileID       sql.NullString
	UpdatedAt         string
	ID                uuid.UUID
}

type UpdateSupplierParams 

type UpdateSupplierParams struct {
	Name      string
	Contact   string
	Phone     string
	Email     string
	Address   string
	UpdatedAt string
	ID        uuid.UUID
}

type UpdateUserParams 

type UpdateUserParams struct {
	Email     string
	Name      string
	UpdatedAt string
	ID        uuid.UUID
}

type UpdateUserPasswordHashParams 

type UpdateUserPasswordHashParams struct {
	PasswordHash string
	UpdatedAt    string
	ID           uuid.UUID
}

type UpsertCategoryParams added in v0.1.7 

type UpsertCategoryParams struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	CreatedAt string
}

type UpsertCategoryRow added in v0.1.7 

type UpsertCategoryRow struct {
	ID        uuid.UUID
	CompanyID uuid.UUID
	Name      string
	CreatedAt string
}

type User 

type User struct {
	ID              uuid.UUID
	Email           string
	Name            string
	CreatedAt       string
	UpdatedAt       string
	Role            int64
	PasswordHash    string
	CompanyID       sql.NullString
	TokenValidAfter sql.NullString
}

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.