VbzCart/docs/queries/qryItems needed forStock: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(Created page with '==About== * '''History''': ** '''2010-01-02''' Created * '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin * '''Requires''': {{vbzcart/query|qryStk…')
 
 
(3 intermediate revisions by one other user not shown)
Line 1: Line 1:
==About==
==About==
* '''Obsolete''': use VCA_Items::SQL_forNeeded_forStock() instead
* '''Returns''': catalog items we need to order more of in order to satisfy stock minima
** Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.
* '''History''':
* '''History''':
** '''2010-01-02''' Created
** '''2010-01-02''' Created
* '''Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
** '''2015-12-30''' Replaced with PHP-generated SQL
** '''2016-03-02''' Query no longer works; removing from database.
* '''Was Used by''': VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
* '''Requires''': {{vbzcart/query|qryStkItms_for_sale}}
* '''Requires''': {{vbzcart/query|qryStkItms_for_sale}}
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS
<mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS
SELECT
SELECT
   i.ID,
   i.ID,
Line 14: Line 19:
   ON s.ID_Item=i.ID
   ON s.ID_Item=i.ID
WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>
WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>
<section end=sql />

Latest revision as of 01:55, 25 February 2024

About

  • Obsolete: use VCA_Items::SQL_forNeeded_forStock() instead
  • Returns: catalog items we need to order more of in order to satisfy stock minima
    • Items may be needed for other reasons, but they will not be listed here unless they satisfy that criterion.
  • History:
    • 2010-01-02 Created
    • 2015-12-30 Replaced with PHP-generated SQL
    • 2016-03-02 Query no longer works; removing from database.
  • Was Used by: VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
  • Requires: Template:Vbzcart/query

SQL

<mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS SELECT 

 i.ID,
 i.QtyMin_Stk,
 s.QtyForSale

FROM cat_items AS i 

 LEFT JOIN qryStkItms_for_sale AS s
 ON s.ID_Item=i.ID

WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql>

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