API CreateProductGroup - Historie editací

Chrzaszcz v 13. 8. 2020, 08:28

2020-08-13T08:28:40Z

Chrzaszcz v 19. 2. 2020, 10:20

2020-02-19T10:20:23Z

Chrzaszcz v 22. 7. 2019, 07:56

2019-07-22T07:56:38Z

Chrzaszcz v 22. 7. 2019, 07:49

2019-07-22T07:49:38Z

Chrzaszcz v 9. 11. 2018, 13:44

2018-11-09T13:44:49Z

Chrzaszcz v 22. 9. 2017, 08:34

2017-09-22T08:34:13Z

Chrzaszcz v 7. 8. 2017, 07:37

2017-08-07T07:37:14Z

Chrzaszcz v 7. 8. 2017, 07:04

2017-08-07T07:04:54Z

Chrzaszcz v 7. 8. 2017, 07:04

2017-08-07T07:04:09Z

Chrzaszcz v 7. 8. 2017, 06:45

2017-08-07T06:45:01Z

@@ Řádka 179: / Řádka 179: @@
 = On
+|
 |}
@@ Řádka 189: / Řádka 195: @@
 <syntaxhighlight lang="sql">
   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>
 ==== Notices ====
 None.

@@ Řádka 167: / Řádka 167: @@
+|
 |Is sale:
 = Off,
@@ Řádka 180: / Řádka 189: @@
 <syntaxhighlight lang="sql">
   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>
 ==== Notices ====
 None.

@@ Řádka 166: / Řádka 166: @@
 |bit
+|
-|Is Sale:
+|Is sale:
 = Off,

@@ Řádka 73: / Řádka 73: @@
 |int
+|
-|Is new
+|Is new:
+|
 |-
@@ Řádka 159: / Řádka 162: @@
 |ID of unit from units list (see relation)
 |API_GetUnits.ID
 |}
@@ Řádka 168: / Řádka 180: @@
 <syntaxhighlight lang="sql">
   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>
 ==== Notices ====
 None.

@@ Řádka 131: / Řádka 131: @@
 |-
 |@Description
-|varchar(250)
+|nvarchar(250)
+|
 |Description

@@ Řádka 22: / Řádka 22: @@
+|
 |-
-|@Name
+|@TecDocCode
-|nvarchar(100)
+|nvarchar(35)
+|
-|Name
+|TecDoc code
+|
 |-
-|@Description
+|@TecDocBrandName
-|varchar(250)
+|nvarchar(80)
+|
-|Description
+|TecDoc brand name
+|
 |-
-|@EshopDescription
+|@TecDocBrandID
-|nvarchar(500)
+|int
+|
-|Eshop description
+|TecDoc brand ID
+|
 |-
-|@TecDocCode
+|@GroupName
-|nvarchar(35)
+|nvarchar(100)
+|
-|TecDoc code
+|Group name
+|
 |-
-|@TecDocBrandID
+|@SubGoupName
-|int
+|nvarchar(100)
+|
-|TecDoc brand ID
+|Sub goup name
+|
 |-
-|@TecDocBrandName
+|@AssortmentName
-|nvarchar(80)
+|nvarchar(100)
+|
-|TecDoc brand name
+|AssortmentName
+|
 |-
-|@VATRate
+|@Name
-|int
+|nvarchar(100)
+|
 |-
-|@MinimumOrderablePieces
+|@Name2
-|decimal(18,2)
+|nvarchar(150)
+|
-|Minimum orderable pieces
+|Name 2
+|
 |-
 |@IsNew
@@ Řádka 94: / Řádka 88: @@
+|
 |-
-|@GroupID
+|@SupplierID
 |int
+|
-|GroupID
+|Basic price
+|
 |-
-|@GroupName
+|@SupplierRetailPrice
-|nvarchar(100)
+|decimal(19,6)
+|
-|Group name
+|Supplier retail price
+|
 |-
-|@SubGroupID
+|@Description
-|int
+|varchar(250)
+|
-|SubGroupID
+|Description
+|
 |-
-|@SubGoupName
+|@EshopDescription
-|nvarchar(100)
+|nvarchar(500)
+|
-|Sub goup name
+|Eshop description
+|
 |-
-|@AssortmentID
+|@VATRate
 |int
+|
-|AssortmentID
+|ID of VAT rates from VAT rates list (see relation)
+|
 |-
-|@AssortmentName
+|@UnitID
-|nvarchar(100)
+|int
+|
 |}

@@ Řádka 15: / Řádka 15: @@
 !Description
 !Relation
 |-
 |@ProductCode

@@ Řádka 1: / Řádka 1: @@
 ==== Description ====
-Method allows You to create new branch in system.
+Method allows You to create new product group in system.
 ==== Exact name ====
-<code>API_CreateBranch</code>
+<code>API_CreateProductGroup</code>
 ==== Type ====
@@ Řádka 17: / Řádka 17: @@
+!
 |-
-|ProductCode
+|@ProductCode
 |nvarchar(40)
+|
@@ Řádka 23: / Řádka 23: @@
+|
 |-
-|Name
+|@Name
 |nvarchar(100)
+|
@@ Řádka 29: / Řádka 29: @@
+|
 |-
-|Description
+|@Description
 |varchar(250)
+|
@@ Řádka 35: / Řádka 35: @@
+|
 |-
-|EshopDescription
+|@EshopDescription
 |nvarchar(500)
+|
@@ Řádka 41: / Řádka 41: @@
+|
 |-
-|TecDocCode
+|@TecDocCode
 |nvarchar(35)
+|
@@ Řádka 47: / Řádka 47: @@
+|
 |-
-|TecDocBrandID
+|@TecDocBrandID
 |int
+|
@@ Řádka 53: / Řádka 53: @@
+|
 |-
-|TecDocBrandName
+|@TecDocBrandName
 |nvarchar(80)
+|
@@ Řádka 59: / Řádka 59: @@
+|
 |-
-|VATRate
+|@VATRate
 |int
+|
@@ Řádka 65: / Řádka 65: @@
 |API_GetVATRates.ID
 |-
-|MinimumOrderablePieces
+|@MinimumOrderablePieces
 |decimal(18,2)
+|
@@ Řádka 71: / Řádka 71: @@
+|
 |-
-|UnitID
+|@UnitID
 |int
+|
@@ Řádka 77: / Řádka 77: @@
 |API_GetUnits.ID
 |-
-|IsNew
+|@IsNew
 |int
+|
@@ Řádka 83: / Řádka 83: @@
+|
 |-
-|PurchasePrice
+|@PurchasePrice
 |decimal(18,6)
+|
@@ Řádka 89: / Řádka 89: @@
+|
 |-
-|RetailPrice
+|@RetailPrice
 |decimal(18,6)
+|
@@ Řádka 95: / Řádka 95: @@
+|
 |-
-|GroupID
+|@GroupID
 |int
+|
@@ Řádka 101: / Řádka 101: @@
+|
 |-
-|GroupName
+|@GroupName
 |nvarchar(100)
+|
@@ Řádka 107: / Řádka 107: @@
+|
 |-
-|SubGroupID
+|@SubGroupID
 |int
+|
@@ Řádka 113: / Řádka 113: @@
+|
 |-
-|SubGoupName
+|@SubGoupName
 |nvarchar(100)
+|
@@ Řádka 119: / Řádka 119: @@
+|
 |-
-|AssortmentID
+|@AssortmentID
 |int
+|
@@ Řádka 125: / Řádka 125: @@
+|
 |-
-|AssortmentName
+|@AssortmentName
 |nvarchar(100)
+|
@@ Řádka 134: / Řádka 134: @@
 ==== Example ====
 <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>
 ==== Notices ====
 None.