VbzCart/docs/procs/Upd StkContainers: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''' update (replace/fill) {{vbzcart|table|_stk_containers}} * '''Status''': in progress; Packages and Restocks were not yet migrated when this was designed, but they ...) |
m (Woozle moved page VbzCart/VbzCart/procs/Upd StkContainers to VbzCart/docs/procs/Upd StkContainers without leaving a redirect: part 2) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''' update (replace/fill) {{vbzcart|table|_stk_containers}} | * '''Purpose''' update (replace/fill) {{vbzcart|table|_stk_containers}} | ||
* '''Status''': | * '''Status''': NOT USED | ||
** if something ever does need to cache container data, just change this so it SELECTs * from {{vbzcart/query|qryStock_containers}} | |||
** Packages and Restocks were not yet migrated when this was written as it is now, which is why those sections are commented out | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE PROCEDURE Upd_StkContainers() | <section begin=sql /><mysql>CREATE PROCEDURE Upd_StkContainers() | ||
Latest revision as of 01:55, 25 February 2024
About
- Purpose update (replace/fill) Template:Vbzcart
- Status: NOT USED
- if something ever does need to cache container data, just change this so it SELECTs * from Template:Vbzcart/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
<section begin=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>
<section end=sql />