models

Documentation

Index

• func AllTransactionEntries(logger *slog.Logger, db *sql.DB, transactionID int) (*[]TransactionEntry, error)
• func ArchiveItem(logger *slog.Logger, db *sql.DB, itemID int) error
• func CloseConnection(db *sql.DB, logger *slog.Logger) error
• func CreateConnection(c *utils.Config, logger *slog.Logger) (*sql.DB, error)
• func CreateItem(logger *slog.Logger, db *sql.DB, categoryID int, name string, ...) error
• func RemoveItemFromTransaction(logger *slog.Logger, db *sql.DB, entryID int) error
• func SetTransactionPayment(logger *slog.Logger, db *sql.DB, transactionID int, paymentID int) error
• func UpdateCategory(logger *slog.Logger, db *sql.DB, itemID int, categoryID int) error
• func UpdateDescription(logger *slog.Logger, db *sql.DB, itemID int, description string) error
• func UpdateName(logger *slog.Logger, db *sql.DB, itemID int, name string) error
• func UpdatePrice(logger *slog.Logger, db *sql.DB, itemID int, price float64) error
• func UpdateStatus(logger *slog.Logger, db *sql.DB, transactionID int, status string) error
• type Item
  • func GetItemByID(logger *slog.Logger, db *sql.DB, itemID int) (item *Item, err error)
• type Transaction
  • func CreateTransaction(logger *slog.Logger, db *sql.DB, posID int, storeID int, userID int) (*Transaction, error)
  • func GetTransactionByID(logger *slog.Logger, db *sql.DB, transactionID int) (*Transaction, error)
• type TransactionEntry
  • func AddItemToTransaction(logger *slog.Logger, db *sql.DB, transactionID int, itemID int) (*TransactionEntry, error)
  • func GetTransactionEntry(logger *slog.Logger, db *sql.DB, entryID int) (*TransactionEntry, error)

Functions

func AllTransactionEntries

func AllTransactionEntries(logger *slog.Logger, db *sql.DB, transactionID int) (*[]TransactionEntry, error)

func ArchiveItem

func ArchiveItem(logger *slog.Logger, db *sql.DB, itemID int) error

func CloseConnection

func CloseConnection(db *sql.DB, logger *slog.Logger) error

func CreateConnection

func CreateConnection(c *utils.Config, logger *slog.Logger) (*sql.DB, error)

func CreateItem

func CreateItem(logger *slog.Logger, db *sql.DB, categoryID int, name string, description string, price float64) error

func RemoveItemFromTransaction

func RemoveItemFromTransaction(logger *slog.Logger, db *sql.DB, entryID int) error

Remove item from transaction

func SetTransactionPayment

func SetTransactionPayment(logger *slog.Logger, db *sql.DB, transactionID int, paymentID int) error

func UpdateCategory

func UpdateCategory(logger *slog.Logger, db *sql.DB, itemID int, categoryID int) error

func UpdateDescription

func UpdateDescription(logger *slog.Logger, db *sql.DB, itemID int, description string) error

func UpdateName

func UpdateName(logger *slog.Logger, db *sql.DB, itemID int, name string) error

func UpdatePrice

func UpdatePrice(logger *slog.Logger, db *sql.DB, itemID int, price float64) error

func UpdateStatus

func UpdateStatus(logger *slog.Logger, db *sql.DB, transactionID int, status string) error

Types

type Item

type Item struct {
	ItemID      int     `json:"itemID"`
	CategoryID  int     `json:"categoryID"`
	Name        string  `json:"name"`
	Description string  `json:"description"`
	Price       float64 `json:"price"`
	Archived    bool    `json:"archived"`

	CreatedDate string `json:"createdDate"`
}

func GetItemByID

func GetItemByID(logger *slog.Logger, db *sql.DB, itemID int) (item *Item, err error)

type Transaction

type Transaction struct {
	TransactionID int     `json:"transactionID"`
	Status        string  `json:"status"`
	POS_ID        int     `json:"posID"`
	StoreID       *int    `json:"storeID"`
	UserID        *int    `json:"userID"`
	Total         float64 `json:"total"`
	PaymentID     *int    `json:"paymentID"`
	Archived      bool    `json:"archived"`

	Entries *[]TransactionEntry `json:"entries"`

	StartTime   time.Time  `json:"startTime"`
	EndTime     *time.Time `json:"endTime"`
	CreatedDate time.Time  `json:"createdDate"`
}

func CreateTransaction

func CreateTransaction(logger *slog.Logger, db *sql.DB, posID int, storeID int, userID int) (*Transaction, error)

func GetTransactionByID

func GetTransactionByID(logger *slog.Logger, db *sql.DB, transactionID int) (*Transaction, error)

type TransactionEntry

type TransactionEntry struct {
	EntryID       int `json:"entryID"`
	TransactionID int `json:"transactionID"`
	ItemID        int `json:"itemID"`

	CreatedAt time.Time `json:"createdAt"`
}

func AddItemToTransaction

func AddItemToTransaction(logger *slog.Logger, db *sql.DB, transactionID int, itemID int) (*TransactionEntry, error)

Add item to transaction

func GetTransactionEntry

func GetTransactionEntry(logger *slog.Logger, db *sql.DB, entryID int) (*TransactionEntry, error)

Get a transaction entry