dbquery

Documentation

Index

• func CreateNewTransactionHistory(dao *daos.Dao, entityType string, r *models.Record) error
• func GetAllProductQuantitySummaries(dao *daos.Dao) ([]*custom_models.ProductQuantitySummary, error)
• func GetBatchProductQuantitySummaries(dao *daos.Dao, ids []string) ([]*custom_models.ProductQuantitySummary, error)
• func GetInternalOrderItemsByInternalOrderId(dao *daos.Dao, internalOrderId string) ([]*custom_models.InternalOrderItem, error)
• func GetInternalOrdersByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.InternalOrder, error)
• func GetInternalOrdersByShipmentId(dao *daos.Dao, shipmentId string) ([]*custom_models.InternalOrder, error)
• func GetInvoicesByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.Invoice, error)
• func GetOrderItemsByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.OrderItem, error)
• func GetProductQuantitiesByCategoryID(dao *daos.Dao, categoryId string) ([]*custom_models.ProductQuantity, error)
• func GetShipmentItemsByShipmentId(dao *daos.Dao, shipmentId string) ([]*custom_models.ShipmentItem, error)
• func GetShipmentsByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.Shipment, error)
• func GetSingleInternalOrderItem(dao *daos.Dao, id string) (*custom_models.InternalOrderItem, error)
• func GetSingleOrder(dao *daos.Dao, id string) (*custom_models.Order, error)
• func GetSingleOrderItem(dao *daos.Dao, id string) (*custom_models.OrderItem, error)
• func GetSingleProductQuantityByCategoryIDAndWorkingUnitID(dao *daos.Dao, categoryId string, workingUnitId string) (*custom_models.ProductQuantity, error)
• func GetSingleProductQuantitySummary(dao *daos.Dao, id string) (*custom_models.ProductQuantitySummary, error)
• func GetSingleShipment(dao *daos.Dao, id string) (*custom_models.Shipment, error)
• func GetStaffsByRole(dao *daos.Dao, role string) ([]*custom_models.StaffInfo, error)
• func GetStaffsByWorkingUnitId(dao *daos.Dao, workingUnitId string) ([]*custom_models.StaffInfo, error)
• func GetWarehouseAssignmentsByInternalOrderId(dao *daos.Dao, internalOrderId string) ([]*custom_models.WarehouseAssignment, error)

Functions

func CreateNewTransactionHistory

func CreateNewTransactionHistory(dao *daos.Dao, entityType string, r *models.Record) error

func GetAllProductQuantitySummaries

func GetAllProductQuantitySummaries(
	dao *daos.Dao,
) (
	[]*custom_models.ProductQuantitySummary,
	error,
)

func GetBatchProductQuantitySummaries

func GetBatchProductQuantitySummaries(
	dao *daos.Dao,
	ids []string,
) (
	[]*custom_models.ProductQuantitySummary,
	error,
)

func GetInternalOrderItemsByInternalOrderId

func GetInternalOrderItemsByInternalOrderId(dao *daos.Dao, internalOrderId string) ([]*custom_models.InternalOrderItem, error)

func GetInternalOrdersByOrderId

func GetInternalOrdersByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.InternalOrder, error)

func GetInternalOrdersByShipmentId

func GetInternalOrdersByShipmentId(dao *daos.Dao, shipmentId string) ([]*custom_models.InternalOrder, error)

func GetInvoicesByOrderId

func GetInvoicesByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.Invoice, error)

Get all invoices by order id, sorted descending by created_at

func GetOrderItemsByOrderId

func GetOrderItemsByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.OrderItem, error)

func GetProductQuantitiesByCategoryID

func GetProductQuantitiesByCategoryID(
	dao *daos.Dao,
	categoryId string,
) (
	[]*custom_models.ProductQuantity,
	error,
)

Return a list of product quantities by category ID sorted by priority DESC, qty DESC

func GetShipmentItemsByShipmentId

func GetShipmentItemsByShipmentId(dao *daos.Dao, shipmentId string) ([]*custom_models.ShipmentItem, error)

func GetShipmentsByOrderId

func GetShipmentsByOrderId(dao *daos.Dao, orderId string) ([]*custom_models.Shipment, error)

func GetSingleInternalOrderItem

func GetSingleInternalOrderItem(dao *daos.Dao, id string) (*custom_models.InternalOrderItem, error)

func GetSingleOrder

func GetSingleOrder(dao *daos.Dao, id string) (*custom_models.Order, error)

func GetSingleOrderItem

func GetSingleOrderItem(dao *daos.Dao, id string) (*custom_models.OrderItem, error)

func GetSingleProductQuantityByCategoryIDAndWorkingUnitID

func GetSingleProductQuantityByCategoryIDAndWorkingUnitID(
	dao *daos.Dao,
	categoryId string,
	workingUnitId string,
) (
	*custom_models.ProductQuantity,
	error,
)

Return a single product quantity summary by category ID

func GetSingleProductQuantitySummary

func GetSingleProductQuantitySummary(
	dao *daos.Dao,
	id string,
) (
	*custom_models.ProductQuantitySummary,
	error,
)

func GetSingleShipment

func GetSingleShipment(dao *daos.Dao, id string) (*custom_models.Shipment, error)

func GetStaffsByRole

func GetStaffsByRole(dao *daos.Dao, role string) ([]*custom_models.StaffInfo, error)

func GetStaffsByWorkingUnitId

func GetStaffsByWorkingUnitId(dao *daos.Dao, workingUnitId string) ([]*custom_models.StaffInfo, error)

func GetWarehouseAssignmentsByInternalOrderId

func GetWarehouseAssignmentsByInternalOrderId(dao *daos.Dao, internalOrderId string) ([]*custom_models.WarehouseAssignment, error)