VbzCart/archive/stored procedures - Revision history

Woozle: Woozle moved page VbzCart/obsolete/stored procedures to VbzCart/archive/stored procedures

2014-12-19T02:05:45Z

Woozle moved page VbzCart/obsolete/stored procedures to VbzCart/archive/stored procedures

← Older revision	Revision as of 02:05, 19 December 2014
(No difference)

Woozle: moved VbzCart stored procedures to VbzCart/obsolete/stored procedures: moving into "obsolete" subpage area

2010-11-15T18:00:46Z

moved VbzCart stored procedures to VbzCart/obsolete/stored procedures: moving into "obsolete" subpage area

← Older revision	Revision as of 18:00, 15 November 2010
(No difference)

Woozle: /* move stock item */ not tested

2007-07-17T00:57:31Z

move stock item: not tested

← Older revision		Revision as of 00:57, 17 July 2007
Line 7:		Line 7:
	...i.e. maintaining accurate stock records		...i.e. maintaining accurate stock records
	====move stock item====		====move stock item====
			* '''NOT TESTED''' - see next stored proc; wrote this much before figuring out that I didn't know how to call it from Access
	* '''Action''': Record (in the stock log) the fact that a stock item has been moved from one place to another.		* '''Action''': Record (in the stock log) the fact that a stock item has been moved from one place to another.
	* '''Usage''': The actual move must be accomplished by the calling routine; this just logs it. Do the move ''before'' calling this routine, as this routine looks up certain information in stk_items for the record.		* '''Usage''': The actual move must be accomplished by the calling routine; this just logs it. Do the move ''before'' calling this routine, as this routine looks up certain information in stk_items for the record.
Line 33:		Line 34:
	iNotes);		iNotes);
	END</mysql>		END</mysql>

	====(re)count stock item in bin====		====(re)count stock item in bin====
	* '''NOT WRITTEN YET'''; I ended up having to do it in Access/VBA code for now because I wasn't sure how to pass procedural calls through to MySQL from Access without using a Recordset object, and there was no point in writing it in MySQL if I couldn't use it.		* '''NOT WRITTEN YET'''; I ended up having to do it in Access/VBA code for now because I wasn't sure how to pass procedural calls through to MySQL from Access without using a Recordset object, and there was no point in writing it in MySQL if I couldn't use it.

Woozle: /* (re)count stock item in bin */ not written yet

2007-07-17T00:55:58Z

(re)count stock item in bin: not written yet

← Older revision		Revision as of 00:55, 17 July 2007
Line 34:		Line 34:
	END</mysql>		END</mysql>
	====(re)count stock item in bin====		====(re)count stock item in bin====
			* '''NOT WRITTEN YET'''; I ended up having to do it in Access/VBA code for now because I wasn't sure how to pass procedural calls through to MySQL from Access without using a Recordset object, and there was no point in writing it in MySQL if I couldn't use it.
	* '''Action''': Record 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.		* '''Action''': Record 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''':		* '''Input''':

Woozle: /* Procedures */ StkItem_LogMove() (not tested)

2007-07-02T12:35:46Z

Procedures: StkItem_LogMove() (not tested)

@@ Line 6: / Line 6: @@
 ===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.
+* '''Action''': Record 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
@@ Line 15: / Line 42: @@
 *** 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''

Woozle: New page: ==Navigation== computing: software: web: shopping carts: VbzCart: stored procedures ==Overview== This ...

2007-07-02T02:22:02Z

New page: ==Navigation== computing: software: web: shopping carts: VbzCart: stored procedures ==Overview== This ...

New page

==Navigation==
[[computing]]: [[software]]: [[web software|web]]: [[shopping cart software|shopping carts]]: [[VbzCart]]: [[VbzCart stored procedures|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''