VbzCart/docs/procs/Upd CatItems fr StkItems StkBins: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Action''': updates availability from current stock ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins() UPDATE cat_items AS i LEFT JOI...) |
(No difference)
|
Revision as of 18:24, 8 March 2009
About
- Action: updates availability from current stock
SQL
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatItems_fr_StkItems_StkBins()
UPDATE cat_items AS i LEFT JOIN ( SELECT si.ID_Item, SUM(si.Qty) AS QtyInStock FROM stk_items AS si LEFT JOIN stk_bins AS sb ON si.ID_Bin=sb.ID WHERE (sb.isForSale) AND ISNULL(sb.WhenVoided) AND ISNULL(si.WhenRemoved) GROUP BY ID_Item ) AS sig ON i.ID=sig.ID_Item SET i.QtyInStock = sig.QtyInStock, i.isForSale = i.isInPrint OR (sig.QtyInStock > 0);</mysql>
<section end=sql />