API CreateProductGroup - Historie editací

Chrzaszcz v 13. 8. 2020, 08:28

2020-08-13T08:28:40Z

← Starší verze		Verze z 13. 8. 2020, 08:28
Řádek 179:		Řádek 179:

	1 = On		1 = On
			\|
			\|-
			\|@InfoReturnOfGoods
			\|nvarchar(50)
			\|
			\|Info return of goods
	\|		\|
	\|}		\|}
Řádek 189:		Řádek 195:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	DECLARE @return_value int		DECLARE @return_value int
	EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0, @IsHiddenOnEshop = 0		EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0, @IsHiddenOnEshop = 0, @InfoReturnOfGoods = ''
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 19. 2. 2020, 10:20

2020-02-19T10:20:23Z

← Starší verze		Verze z 19. 2. 2020, 10:20
Řádek 167:		Řádek 167:
	\|		\|
	\|Is sale:		\|Is sale:
			0 = Off,

			1 = On
			\|
			\|-
			\|@IsHiddenOnEshop
			\|bit
			\|
			\|Is hidden on eshop:
	0 = Off,		0 = Off,

Řádek 180:		Řádek 189:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	DECLARE @return_value int		DECLARE @return_value int
	EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0		EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0, @IsHiddenOnEshop = 0
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 22. 7. 2019, 07:56

2019-07-22T07:56:38Z

← Starší verze		Verze z 22. 7. 2019, 07:56
Řádek 166:		Řádek 166:
	\|bit		\|bit
	\|		\|
	\|Is ~~Sale~~:		\|Is sale:
	0 = Off,		0 = Off,

Chrzaszcz v 22. 7. 2019, 07:49

2019-07-22T07:49:38Z

← Starší verze		Verze z 22. 7. 2019, 07:49
Řádek 73:		Řádek 73:
	\|int		\|int
	\|		\|
	\|Is new		\|Is new:
			0 = Off,

			1 = On
	\|		\|
	\|-		\|-
Řádek 159:		Řádek 162:
	\|ID of unit from units list (see relation)		\|ID of unit from units list (see relation)
	\|API_GetUnits.ID		\|API_GetUnits.ID
			\|-
			\|@IsSale
			\|bit
			\|
			\|Is Sale:
			0 = Off,

			1 = On
			\|
	\|}		\|}

Řádek 168:		Řádek 180:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	DECLARE @return_value int		DECLARE @return_value int
	EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148		EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148, @IsSale= 0
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 9. 11. 2018, 13:44

2018-11-09T13:44:49Z

← Starší verze		Verze z 9. 11. 2018, 13:44
Řádek 131:		Řádek 131:
	\|-		\|-
	\|@Description		\|@Description
	\|~~varchar~~(250)		\|nvarchar(250)
	\|		\|
	\|Description		\|Description

Chrzaszcz v 22. 9. 2017, 08:34

2017-09-22T08:34:13Z

← Starší verze		Verze z 22. 9. 2017, 08:34
Řádek 160:		Řádek 160:
	\|API_GetUnits.ID		\|API_GetUnits.ID
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be created

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148		DECLARE @return_value int
			EXEC @return_value = [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 7. 8. 2017, 07:37

2017-08-07T07:37:14Z

Ukázat změny

Chrzaszcz v 7. 8. 2017, 07:04

2017-08-07T07:04:54Z

← Starší verze		Verze z 7. 8. 2017, 07:04
Řádek 15:		Řádek 15:
	!Description		!Description
	!Relation		!Relation
	!
	\|-		\|-
	\|@ProductCode		\|@ProductCode

Chrzaszcz v 7. 8. 2017, 07:04

2017-08-07T07:04:09Z

← Starší verze		Verze z 7. 8. 2017, 07:04
Řádek 1:		Řádek 1:
	==== Description ====		==== Description ====
	Method allows You to create new ~~branch~~ in system.		Method allows You to create new product group in system.

	==== Exact name ====		==== Exact name ====
	<code>~~API_CreateBranch~~</code>		<code>API_CreateProductGroup</code>

	==== Type ====		==== Type ====
Řádek 17:		Řádek 17:
	!		!
	\|-		\|-
	\|ProductCode		\|@ProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
Řádek 23:		Řádek 23:
	\|		\|
	\|-		\|-
	\|Name		\|@Name
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
Řádek 29:		Řádek 29:
	\|		\|
	\|-		\|-
	\|Description		\|@Description
	\|varchar(250)		\|varchar(250)
	\|		\|
Řádek 35:		Řádek 35:
	\|		\|
	\|-		\|-
	\|EshopDescription		\|@EshopDescription
	\|nvarchar(500)		\|nvarchar(500)
	\|		\|
Řádek 41:		Řádek 41:
	\|		\|
	\|-		\|-
	\|TecDocCode		\|@TecDocCode
	\|nvarchar(35)		\|nvarchar(35)
	\|		\|
Řádek 47:		Řádek 47:
	\|		\|
	\|-		\|-
	\|TecDocBrandID		\|@TecDocBrandID
	\|int		\|int
	\|		\|
Řádek 53:		Řádek 53:
	\|		\|
	\|-		\|-
	\|TecDocBrandName		\|@TecDocBrandName
	\|nvarchar(80)		\|nvarchar(80)
	\|		\|
Řádek 59:		Řádek 59:
	\|		\|
	\|-		\|-
	\|VATRate		\|@VATRate
	\|int		\|int
	\|		\|
Řádek 65:		Řádek 65:
	\|API_GetVATRates.ID		\|API_GetVATRates.ID
	\|-		\|-
	\|MinimumOrderablePieces		\|@MinimumOrderablePieces
	\|decimal(18,2)		\|decimal(18,2)
	\|		\|
Řádek 71:		Řádek 71:
	\|		\|
	\|-		\|-
	\|UnitID		\|@UnitID
	\|int		\|int
	\|		\|
Řádek 77:		Řádek 77:
	\|API_GetUnits.ID		\|API_GetUnits.ID
	\|-		\|-
	\|IsNew		\|@IsNew
	\|int		\|int
	\|		\|
Řádek 83:		Řádek 83:
	\|		\|
	\|-		\|-
	\|PurchasePrice		\|@PurchasePrice
	\|decimal(18,6)		\|decimal(18,6)
	\|		\|
Řádek 89:		Řádek 89:
	\|		\|
	\|-		\|-
	\|RetailPrice		\|@RetailPrice
	\|decimal(18,6)		\|decimal(18,6)
	\|		\|
Řádek 95:		Řádek 95:
	\|		\|
	\|-		\|-
	\|GroupID		\|@GroupID
	\|int		\|int
	\|		\|
Řádek 101:		Řádek 101:
	\|		\|
	\|-		\|-
	\|GroupName		\|@GroupName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
Řádek 107:		Řádek 107:
	\|		\|
	\|-		\|-
	\|SubGroupID		\|@SubGroupID
	\|int		\|int
	\|		\|
Řádek 113:		Řádek 113:
	\|		\|
	\|-		\|-
	\|SubGoupName		\|@SubGoupName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
Řádek 119:		Řádek 119:
	\|		\|
	\|-		\|-
	\|AssortmentID		\|@AssortmentID
	\|int		\|int
	\|		\|
Řádek 125:		Řádek 125:
	\|		\|
	\|-		\|-
	\|AssortmentName		\|@AssortmentName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
Řádek 134:		Řádek 134:
	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [~~API_CreateBranch~~] @~~WorkshopID~~ = 1 ,@~~Name~~ = '~~Name~~' ,@~~Street~~ = '~~Street~~' ,@~~City~~ = '~~City~~' ,@~~ZIPCode~~ = '~~ZIPCode~~' ,@~~Country~~ = '~~Country~~' ,@~~Region~~ = '~~Region~~' ,@~~State~~ ='~~Česká republika~~' ,@~~StateID~~ = ~~15797~~ ,@~~Phone~~ = '~~+420 556 621 300~~' ,@~~Fax~~ = '~~+420 596 790 789~~' ,@~~MobilePhone~~ = '~~+420 556 621 301~~' ,@~~Email~~ = '~~info~~@~~nextis.cz~~' ,@~~Web~~ = '~~www.nextis.cz~~'		EXEC [API_CreateProductGroup] @ProductCode= '1457429619' ,@TecDocCode= '1 457 429 619' ,@TecDocBrandName= 'BOSCH' ,@TecDocBrandID= 30 ,@GroupName= 'GroupName' ,@SubGoupName= 'SubGoupName' ,@AssortmentName= 'AssortmentName' ,@Name= 'Name' ,@Name2= 'Name2' ,@IsNew= 0 ,@PurchasePrice= 100 ,@RetailPrice= 190 ,@SupplierID= 2 ,@Prefix= '' ,@SupplierProductCode= '1457429619BS' ,@ManufacturerSupplier= 'BOSCH2' ,@SupplierItemName= 'SupplierItemName' ,@BasicPrice= 100 ,@SupplierRetailPrice= 220 ,@Description= 'Description' ,@EshopDescription= 'EshopDescription' ,@VATRate = 16028 ,@MinimumOrderablePieces= 1 ,@UnitID= 148
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 7. 8. 2017, 06:45

2017-08-07T06:45:01Z

← Starší verze		Verze z 7. 8. 2017, 06:45
Řádek 15:		Řádek 15:
	!Description		!Description
	!Relation		!Relation
			!
	\|-		\|-
	\|ProductCode		\|ProductCode
	\|nvarchar(40)		\|nvarchar(40)
			\|
	\|Product code		\|Product code
	\|		\|
Řádek 23:		Řádek 25:
	\|Name		\|Name
	\|nvarchar(100)		\|nvarchar(100)
			\|
	\|Name		\|Name
	\|		\|
Řádek 28:		Řádek 31:
	\|Description		\|Description
	\|varchar(250)		\|varchar(250)
			\|
	\|Description		\|Description
	\|		\|
Řádek 33:		Řádek 37:
	\|EshopDescription		\|EshopDescription
	\|nvarchar(500)		\|nvarchar(500)
			\|
	\|Eshop description		\|Eshop description
	\|		\|
Řádek 38:		Řádek 43:
	\|TecDocCode		\|TecDocCode
	\|nvarchar(35)		\|nvarchar(35)
			\|
	\|TecDoc code		\|TecDoc code
	\|		\|
Řádek 43:		Řádek 49:
	\|TecDocBrandID		\|TecDocBrandID
	\|int		\|int
			\|
	\|TecDoc brand ID		\|TecDoc brand ID
	\|		\|
Řádek 48:		Řádek 55:
	\|TecDocBrandName		\|TecDocBrandName
	\|nvarchar(80)		\|nvarchar(80)
			\|
	\|TecDoc brand name		\|TecDoc brand name
	\|		\|
Řádek 53:		Řádek 61:
	\|VATRate		\|VATRate
	\|int		\|int
			\|
	\|ID of VAT rates from VAT rates list (see relation)		\|ID of VAT rates from VAT rates list (see relation)
	\|API_GetVATRates.ID		\|API_GetVATRates.ID
Řádek 58:		Řádek 67:
	\|MinimumOrderablePieces		\|MinimumOrderablePieces
	\|decimal(18,2)		\|decimal(18,2)
			\|
	\|Minimum orderable pieces		\|Minimum orderable pieces
	\|		\|
Řádek 63:		Řádek 73:
	\|UnitID		\|UnitID
	\|int		\|int
			\|
	\|ID of unit from units list (see relation)		\|ID of unit from units list (see relation)
	\|API_GetUnits.ID		\|API_GetUnits.ID
Řádek 68:		Řádek 79:
	\|IsNew		\|IsNew
	\|int		\|int
			\|
	\|Is new		\|Is new
	\|		\|
Řádek 73:		Řádek 85:
	\|PurchasePrice		\|PurchasePrice
	\|decimal(18,6)		\|decimal(18,6)
			\|
	\|Purchase price		\|Purchase price
	\|		\|
Řádek 78:		Řádek 91:
	\|RetailPrice		\|RetailPrice
	\|decimal(18,6)		\|decimal(18,6)
			\|
	\|Retail price		\|Retail price
	\|		\|
Řádek 83:		Řádek 97:
	\|GroupID		\|GroupID
	\|int		\|int
			\|
	\|GroupID		\|GroupID
	\|		\|
Řádek 88:		Řádek 103:
	\|GroupName		\|GroupName
	\|nvarchar(100)		\|nvarchar(100)
			\|
	\|Group name		\|Group name
	\|		\|
Řádek 93:		Řádek 109:
	\|SubGroupID		\|SubGroupID
	\|int		\|int
			\|
	\|SubGroupID		\|SubGroupID
	\|		\|
Řádek 98:		Řádek 115:
	\|SubGoupName		\|SubGoupName
	\|nvarchar(100)		\|nvarchar(100)
			\|
	\|Sub goup name		\|Sub goup name
	\|		\|
Řádek 103:		Řádek 121:
	\|AssortmentID		\|AssortmentID
	\|int		\|int
			\|
	\|AssortmentID		\|AssortmentID
	\|		\|
Řádek 108:		Řádek 127:
	\|AssortmentName		\|AssortmentName
	\|nvarchar(100)		\|nvarchar(100)
			\|
	\|AssortmentName		\|AssortmentName
	\|		\|