VbzCart/archive/stored procedures

Navigation

computing: software: web: shopping carts: VbzCart: stored procedures

Overview

This page is about stored procedures for accomplishing particular tasks within VbzCart. For stored procedures which are solely for maintaining cached data, see VbzCart tables.

Procedures

Inventory

...i.e. maintaining accurate stock records

(re)count stock item in bin

• Action: Log the fact that inventory is being counted; use the stock log, and record the event as an item of stock being moved from one place back into the same place.
• Input:
  • iQty: quantity counted or previously recorded
  • iItem: ID of stock record whose count is being verified/updated
  • iIsOld:
    • TRUE = iQty is the quantity previously recorded before counting
    • FALSE = iQty is the (new) quantity found during this inventory count

<mysql>CREATE PROCEDURE StkItem_Count(IN iQty INT, IN iItem INT, iIsOld BOOL) BEGIN

END</mysql> writing in progress