VbzCart/queries/qryStk lines remaining - Revision history

Woozle: names of things that replaced it have changed

2017-03-24T19:19:46Z

names of things that replaced it have changed

← Older revision		Revision as of 19:19, 24 March 2017
Line 1:		Line 1:
	==About==		==About==
	* '''~~Obsolete~~''': ~~use '''VCT_StkLines::SQL_forRemaining~~()~~''' instead~~		* '''OBSOLETE''': replaced by a number of things (search for query name to find them)
	* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:		* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:
	** "forSale": items which are visible as "in stock" to customers		** "forSale": items which are visible as "in stock" to customers

Woozle: obsolete

2015-12-31T01:34:31Z

obsolete

← Older revision		Revision as of 01:34, 31 December 2015
Line 1:		Line 1:
	==About==		==About==
			* '''Obsolete''': use '''VCT_StkLines::SQL_forRemaining()''' instead
	* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:		* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:
	** "forSale": items which are visible as "in stock" to customers		** "forSale": items which are visible as "in stock" to customers
Line 10:		Line 11:
	** '''2010-06-15''' added BinCode (sb.Code) -- needed for clsStkItems::List_forItem()		** '''2010-06-15''' added BinCode (sb.Code) -- needed for clsStkItems::List_forItem()
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS		<mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS
	SELECT		SELECT
	st.ID,		st.ID,
Line 35:		Line 36:
	ON sb.ID_Place=sp.ID		ON sb.ID_Place=sp.ID
	WHERE (st.WhenRemoved IS NULL) AND (sb.WhenVoided IS NULL) AND (st.Qty <> 0);</mysql>		WHERE (st.WhenRemoved IS NULL) AND (sb.WhenVoided IS NULL) AND (st.Qty <> 0);</mysql>
	~~<section end=sql />~~

Woozle: added BinCode

2010-06-15T19:42:01Z

added BinCode

← Older revision		Revision as of 19:42, 15 June 2010
Line 8:		Line 8:
	* '''History''':		* '''History''':
	** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''		** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''
			** '''2010-06-15''' added BinCode (sb.Code) -- needed for clsStkItems::List_forItem()
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS
Line 22:		Line 23:
	st.WhenCounted,		st.WhenCounted,
	st.Notes,		st.Notes,
			sb.Code AS BinCode,
	sb.ID_Place,		sb.ID_Place,
	sp.Name AS WhName		sp.Name AS WhName

Woozle: another dependent

2010-02-23T13:39:16Z

another dependent

← Older revision		Revision as of 13:39, 23 February 2010
Line 5:		Line 5:
	** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)		** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
	* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}		* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}
	* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}, {{vbzcart/query\|qryStk_items_remaining}}		* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}, {{vbzcart/query\|qryStk_items_remaining}}, {{vbzcart/query\|qryStk_byItem_byBin}}
	* '''History''':		* '''History''':
	** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''		** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''

Woozle: another used-by

2009-11-29T23:20:13Z

another used-by

← Older revision		Revision as of 23:20, 29 November 2009
Line 5:		Line 5:
	** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)		** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
	* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}		* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}
	* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}		* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}, {{vbzcart/query\|qryStk_items_remaining}}
	* '''History''':		* '''History''':
	** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''		** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''

Woozle: post-move update

2009-11-29T22:59:05Z

post-move update

← Older revision		Revision as of 22:59, 29 November 2009
Line 1:		Line 1:
	==~~Details~~==		==About==
	* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:		* '''Returns''': {{vbzcart/table\|stk_items}} actually in stock, which is actually different things:
	** "forSale": items which are visible as "in stock" to customers		** "forSale": items which are visible as "in stock" to customers
Line 6:		Line 6:
	* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}		* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}
	* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}		* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}
			* '''History''':
			** '''2009-11-29''' renamed from '''v_stk_lines_remaining''' to '''qryStk_lines_remaining'''
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW ~~v_stk_lines_remaining~~ AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_remaining AS
	SELECT		SELECT
	st.ID,		st.ID,

Woozle: moved VbzCart/queries/v stk lines remaining to VbzCart/queries/qryStk lines remaining: more consistent with naming of other queries; needed rebuilding anyway, so now seems like a good time

2009-11-29T22:57:40Z

moved VbzCart/queries/v stk lines remaining to VbzCart/queries/qryStk lines remaining: more consistent with naming of other queries; needed rebuilding anyway, so now seems like a good time

← Older revision	Revision as of 22:57, 29 November 2009
(No difference)

Woozle: another used-by

2009-11-29T22:56:45Z

another used-by

← Older revision		Revision as of 22:56, 29 November 2009
Line 5:		Line 5:
	** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)		** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
	* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}		* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}
	* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}		* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}, {{vbzcart/query\|qryStk_lines_remaining_byBin}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_lines_remaining AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_lines_remaining AS

Woozle: used by qryStk_lines_remaining_forSale

2009-02-08T01:44:26Z

used by qryStk_lines_remaining_forSale

← Older revision		Revision as of 01:44, 8 February 2009
Line 5:		Line 5:
	** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)		** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
	* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}		* '''Requires''': {{vbzcart/table\|stk_items}}, {{vbzcart/table\|stk_places}}
	* '''Used by''':		* '''Used by''': {{vbzcart/query\|qryStk_lines_remaining_forSale}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_lines_remaining AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_lines_remaining AS

Woozle: New page: ==Details== * '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things: "forSale": items which are visible as "in stock" to customers "forShip...

2008-12-04T01:49:13Z

New page: ==Details== * '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things: ** "forSale": items which are visible as "in stock" to customers ** "forShip...

New page

==Details==
* '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things:
** "forSale": items which are visible as "in stock" to customers
** "forShip": items which are available for shipping
** items neither for shipping nor for sale (probably some kind of recordkeeping purpose)
* '''Requires''': {{vbzcart/table|stk_items}}, {{vbzcart/table|stk_places}}
* '''Used by''':
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_lines_remaining AS
SELECT
st.ID,
st.ID_Bin,
st.ID_Item,
IF(sb.isForSale,st.Qty,0) AS QtyForSale,
IF(sb.isForShip,st.Qty,0) AS QtyForShip,
st.Qty AS QtyExisting,
st.CatNum,
st.WhenAdded,
st.WhenChanged,
st.WhenCounted,
st.Notes,
sb.ID_Place,
sp.Name AS WhName
FROM
(
stk_items AS st
LEFT JOIN stk_bins AS sb
ON sb.ID=st.ID_Bin
)
LEFT JOIN stk_places AS sp
ON sb.ID_Place=sp.ID
WHERE (st.WhenRemoved IS NULL) AND (sb.WhenVoided IS NULL) AND (st.Qty <> 0);</mysql>
<section end=sql />

VbzCart/queries/qryStk lines remaining - Revision history

Woozle: names of things that replaced it have changed

Woozle: obsolete

Woozle: added BinCode

Woozle: another dependent

Woozle: another used-by

Woozle: post-move update

Woozle: moved VbzCart/queries/v stk lines remaining to VbzCart/queries/qryStk lines remaining: more consistent with naming of other queries; needed rebuilding anyway, so now seems like a good time

Woozle: another used-by

Woozle: used by qryStk_lines_remaining_forSale

Woozle: New page: ==Details== * '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things: ** "forSale": items which are visible as "in stock" to customers ** "forShip...

Woozle: New page: ==Details== * '''Returns''': {{vbzcart/table|stk_items}} actually in stock, which is actually different things: "forSale": items which are visible as "in stock" to customers "forShip...