VbzCart/procs/Upd StkContainers
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- Purpose update (replace/fill) _stk_containers
- Status: NOT USED
- if something ever does need to cache container data, just change this so it SELECTs * from
- REDIRECT Template:l/vc/query
- Packages and Restocks were not yet migrated when this was written as it is now, which is why those sections are commented out
SQL
<mysql>CREATE PROCEDURE Upd_StkContainers()
REPLACE INTO _stk_containers /* SELECT CONCAT("P.",p.ID) AS IDS, "P" AS Type, p.ID AS ID_forType, CONCAT(o.Number,"-",p.Seq) AS Name, s.WhenShipped AS TimeStamp FROM (Packages AS p LEFT JOIN Orders AS o ON p.ID_Order=o.ID) LEFT JOIN Shipments AS s ON p.ID_Shipment=s.ID; UNION /**/ SELECT CONCAT("L.",l.ID) AS IDS, "L" AS Type, l.ID AS ID_forType, l.Code AS Name, l.WhenCreated AS TimeStamp FROM stk_bins AS l UNION /* SELECT CONCAT("R.",r.ID) AS IDS, "R" AS Type, r.ID AS ID_forType, "po"&r.PurchOrdNum&"/ord"&SuppOrdNum&"/inv"&SuppInvcNum AS Name, RestockEffDate(r.ID) AS TimeStamp FROM Restocks AS r UNION /**/ SELECT CONCAT("M.",i.ID) AS IDS, "M" AS Type, i.ID AS ID_forType, i.CatNum AS Name, NULL AS TimeStamp FROM cat_items AS i WHERE i.IsMaster;</mysql>