VbzCart/docs/queries/qryRstkItms active: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (obsolete) |
m (Woozle moved page VbzCart/VbzCart/queries/qryRstkItms active to VbzCart/docs/queries/qryRstkItms active without leaving a redirect: part 2) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 2: | Line 2: | ||
* '''Obsolete''': use '''VCT_RstkReqItems::SQLobj_Items_active()''' or '''::SQLstr_Items_active()''' instead | * '''Obsolete''': use '''VCT_RstkReqItems::SQLobj_Items_active()''' or '''::SQLstr_Items_active()''' instead | ||
* '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). | * '''Returns''': Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled). | ||
* '''Requires''': {{ | * '''Requires''': {{l/vc/table|rstk_req_item}}, {{l/vc/query|qryRstks_active}} | ||
* '''Used by''': {{ | * '''Used by''': {{l/vc/query|qryRstkItms_expected}} | ||
* '''Note''': This is different from qryRstkLines_en_route (deprecated): | * '''Note''': This is different from qryRstkLines_en_route (deprecated): | ||
** Grouped by Item instead of Restock Line | ** Grouped by Item instead of Restock Line | ||
| Line 11: | Line 11: | ||
** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp | ** '''2010-01-04''' now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp | ||
** '''2015-12-31''' replacing this with PHP-generated SQL | ** '''2015-12-31''' replacing this with PHP-generated SQL | ||
** '''2016-03-02''' Query no longer works; removing from database. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS | <mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS | ||
Latest revision as of 01:55, 25 February 2024
Details
- Obsolete: use VCT_RstkReqItems::SQLobj_Items_active() or ::SQLstr_Items_active() instead
- Returns: Data about items which are in active restocks, i.e. on restock orders but not yet received (or cancelled).
- Requires: Template:L/vc/table, Template:L/vc/query
- Used by: Template:L/vc/query
- Note: This is different from qryRstkLines_en_route (deprecated):
- Grouped by Item instead of Restock Line
- Uses new Restock tables
- History:
- 2008-11-18 Created for new restock process
- 2010-01-04 now allowing QtyExp to override QtyOrd; resulting field renamed from QtyOrd to QtyExp
- 2015-12-31 replacing this with PHP-generated SQL
- 2016-03-02 Query no longer works; removing from database.
SQL
<mysql>CREATE OR REPLACE VIEW qryRstkItms_active AS SELECT
rrq.ID_Restock, rrq.ID_Item, SUM(IFNULL(rrq.QtyExp,rrq.QtyOrd)) AS QtyExp
FROM rstk_req_item AS rrq
LEFT JOIN qryRstks_active AS rq ON rrq.ID_Restock=rq.ID
WHERE rq.ID IS NOT NULL GROUP BY rrq.ID_Restock, rrq.ID_Item;</mysql>