VbzCart/docs/queries/qryCat Items Stock: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(New page: ==About== * '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_items_remaining}} * '''Used by''': {{vbzcart/query|qryItTypsDepts grpItems}} * '''Notes''': This may turn out...)
 
m (Woozle moved page VbzCart/VbzCart/queries/qryCat Items Stock to VbzCart/docs/queries/qryCat Items Stock without leaving a redirect: part 2)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Requires''': {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_items_remaining}}
* '''Requires''': {{vbzcart|table|cat_items}}, {{vbzcart/query|qryStk_items_remaining}}
* '''Used by''': {{vbzcart/query|qryItTypsDepts grpItems}}
* '''Used by''': {{vbzcart/query|qryItTypsDepts_grpItems}}
* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
* '''Notes''': This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
* '''History''':
* '''History''':
** '''2009-04-12''' Created to replace cat_items.qtyInStock field
** '''2009-04-12''' Created to replace cat_items.qtyInStock field
** '''2009-11-29''' Underlying query renamed
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS
Line 11: Line 12:
   SUM(st.qtyForSale) AS qtyForSale,
   SUM(st.qtyForSale) AS qtyForSale,
   SUM(st.qtyForShip) AS qtyForShip
   SUM(st.qtyForShip) AS qtyForShip
FROM (cat_items AS i LEFT JOIN v_stk_items_remaining AS st on i.ID=st.ID_Item)
FROM (cat_items AS i LEFT JOIN qryStk_items_remaining AS st on i.ID=st.ID_Item)
GROUP BY i.ID;</mysql>
GROUP BY i.ID;</mysql>
<section end=sql />
<section end=sql />

Latest revision as of 01:55, 25 February 2024

About

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS SELECT 

 i.*,
 SUM(st.qtyForSale) AS qtyForSale,
 SUM(st.qtyForShip) AS qtyForShip

FROM (cat_items AS i LEFT JOIN qryStk_items_remaining AS st on i.ID=st.ID_Item) GROUP BY i.ID;</mysql> <section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryCat_Items_Stock&oldid=6737"