API CreateBasketItem: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
(Nejsou zobrazeny 4 mezilehlé verze od stejného uživatele.)
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
−
|CustomerID
+
|@CustomerID
 
|int
 
|int
 
|
 
|
Řádka 22: Řádka 22:
 
|API_GetCustomers.ID
 
|API_GetCustomers.ID
 
|-
 
|-
−
|CustomerWorkshopID
+
|@CustomerWorkshopID
 
|int
 
|int
 
|
 
|
Řádka 28: Řádka 28:
 
|API_GetWorkshops.ID = API_GetCustomers.WorkshopID
 
|API_GetWorkshops.ID = API_GetCustomers.WorkshopID
 
|-
 
|-
−
|GroupID
+
|@GroupID
 
|int
 
|int
 
|
 
|
Řádka 34: Řádka 34:
 
|API_GetProductGroups.ID
 
|API_GetProductGroups.ID
 
|-
 
|-
−
|ProductID
+
|@ProductID
 
|int
 
|int
 
|
 
|
Řádka 40: Řádka 40:
 
|API_GetProducts.ID
 
|API_GetProducts.ID
 
|-
 
|-
−
|StorageCardID
+
|@StorageCardID
 
|int
 
|int
 
|
 
|
Řádka 46: Řádka 46:
 
|API_GetStockDispositions.ID
 
|API_GetStockDispositions.ID
 
|-
 
|-
−
|OrderID
+
|@OrderID
 
|int
 
|int
 
|
 
|
Řádka 52: Řádka 52:
 
|API_GetOrders.ID
 
|API_GetOrders.ID
 
|-
 
|-
−
|GroupCode
+
|@GroupCode
 
|nvarchar(40)
 
|nvarchar(40)
 
|
 
|
−
|
+
|Group code
 
|
 
|
 
|-
 
|-
−
|ProductCode
+
|@ProductCode
 
|nvarchar(40)
 
|nvarchar(40)
 
|
 
|
−
|
+
|Product code
 
|
 
|
 
|-
 
|-
−
|ManufacturerCode
+
|@ManufacturerCode
 
|nvarchar(40)
 
|nvarchar(40)
 
|
 
|
−
|
+
|Manufacturer code
 
|
 
|
 
|-
 
|-
−
|SupplierCode
+
|@SupplierCode
 
|nvarchar(40)
 
|nvarchar(40)
 
|
 
|
−
|
+
|Supplier code
 
|
 
|
 
|-
 
|-
−
|Brand
+
|@Brand
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
−
|
+
|Brand
 
|
 
|
 
|-
 
|-
−
|Desription
+
|@Desription
 
|nvarchar(250)
 
|nvarchar(250)
 
|
 
|
Řádka 88: Řádka 88:
 
|
 
|
 
|-
 
|-
−
|OrderedQuantity
+
|@OrderedQuantity
 
|decimal(18,2)
 
|decimal(18,2)
 
|
 
|
Řádka 94: Řádka 94:
 
|
 
|
 
|-
 
|-
−
|PricePerPiece
+
|@PricePerPiece
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 100: Řádka 100:
 
|
 
|
 
|-
 
|-
−
|PricePerPieceWithVAT
+
|@PricePerPieceWithVAT
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 106: Řádka 106:
 
|
 
|
 
|-
 
|-
−
|PurchasePricePerPiece
+
|@PurchasePricePerPiece
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 112: Řádka 112:
 
|
 
|
 
|-
 
|-
−
|PurchasePricePerPieceWithVAT
+
|@PurchasePricePerPieceWithVAT
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 118: Řádka 118:
 
|
 
|
 
|-
 
|-
−
|TotalPrice
+
|@TotalPrice
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 124: Řádka 124:
 
|
 
|
 
|-
 
|-
−
|TotalPriceWithVAT
+
|@TotalPriceWithVAT
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 130: Řádka 130:
 
|
 
|
 
|-
 
|-
−
|TotalPurchasePrice
+
|@TotalPurchasePrice
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 136: Řádka 136:
 
|
 
|
 
|-
 
|-
−
|TotalPurchasePriceWithVAT
+
|@TotalPurchasePriceWithVAT
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 142: Řádka 142:
 
|
 
|
 
|-
 
|-
−
|DiscountInPercent
+
|@DiscountInPercent
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 148: Řádka 148:
 
|
 
|
 
|-
 
|-
−
|DiscountPrice
+
|@DiscountPrice
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 154: Řádka 154:
 
|
 
|
 
|-
 
|-
−
|SurchargesPrice
+
|@SurchargesPrice
 
|decimal(18,2)
 
|decimal(18,2)
 
|
 
|
Řádka 160: Řádka 160:
 
|
 
|
 
|-
 
|-
−
|SurchargePriceWithVAT
+
|@SurchargePriceWithVAT
 
|decimal(18,2)
 
|decimal(18,2)
 
|
 
|
Řádka 166: Řádka 166:
 
|
 
|
 
|-
 
|-
−
|PricePerPieceInCurrency
+
|@PricePerPieceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 172: Řádka 172:
 
|
 
|
 
|-
 
|-
−
|PricePerPieceWithVATInCurrency
+
|@PricePerPieceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 178: Řádka 178:
 
|
 
|
 
|-
 
|-
−
|PurchasePricePerPieceInCurrency
+
|@PurchasePricePerPieceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 184: Řádka 184:
 
|
 
|
 
|-
 
|-
−
|PurchasePricePerPieceWithVATInCurrency
+
|@PurchasePricePerPieceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 190: Řádka 190:
 
|
 
|
 
|-
 
|-
−
|TotalPriceInCurrency
+
|@TotalPriceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 196: Řádka 196:
 
|
 
|
 
|-
 
|-
−
|TotalPriceWithVATInCurrency
+
|@TotalPriceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 202: Řádka 202:
 
|
 
|
 
|-
 
|-
−
|TotalPurchasePriceInCurrency
+
|@TotalPurchasePriceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 208: Řádka 208:
 
|
 
|
 
|-
 
|-
−
|TotalPurchasePriceWithVATInCurrency
+
|@TotalPurchasePriceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 214: Řádka 214:
 
|
 
|
 
|-
 
|-
−
|DiscountPriceInCurrency
+
|@DiscountPriceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 220: Řádka 220:
 
|
 
|
 
|-
 
|-
−
|SurchargesPriceInCurrency
+
|@SurchargesPriceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 226: Řádka 226:
 
|
 
|
 
|-
 
|-
−
|SurchargesPriceWithVATInCurrency
+
|@SurchargesPriceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 232: Řádka 232:
 
|
 
|
 
|-
 
|-
−
|CurrencyID
+
|@CurrencyID
 
|int
 
|int
 
|
 
|
Řádka 238: Řádka 238:
 
|API_GetCurrency.ID
 
|API_GetCurrency.ID
 
|-
 
|-
−
|ForeignCurrencyID
+
|@ForeignCurrencyID
 
|int
 
|int
 
|
 
|
Řádka 244: Řádka 244:
 
|API_GetCurrency.ID
 
|API_GetCurrency.ID
 
|-
 
|-
−
|Note
+
|@Note
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
Řádka 250: Řádka 250:
 
|
 
|
 
|-
 
|-
−
|VATRate
+
|@VATRate
 
|decimal(18,2)
 
|decimal(18,2)
 
|
 
|
Řádka 256: Řádka 256:
 
|
 
|
 
|-
 
|-
−
|HistoryInfo
+
|@HistoryInfo
 
|nvarchar(300)
 
|nvarchar(300)
 
|
 
|
Řádka 262: Řádka 262:
 
|
 
|
 
|-
 
|-
−
|ActionPrice
+
|@ActionPrice
 
|int
 
|int
 
|
 
|
Řádka 268: Řádka 268:
 
|
 
|
 
|-
 
|-
−
|ChildPricePerPieceInCurrency
+
|@ChildPricePerPieceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 274: Řádka 274:
 
|
 
|
 
|-
 
|-
−
|ChildPricePerPieceWithVATInCurrency
+
|@ChildPricePerPieceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 280: Řádka 280:
 
|
 
|
 
|-
 
|-
−
|ChildPurchasePricePerPieceInCurrency
+
|@ChildPurchasePricePerPieceInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 286: Řádka 286:
 
|
 
|
 
|-
 
|-
−
|ChildPurchasePricePerPieceWithVATInCurrency
+
|@ChildPurchasePricePerPieceWithVATInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
Řádka 292: Řádka 292:
 
|
 
|
 
|-
 
|-
−
|ChildDiscountInCurrency
+
|@ChildDiscountInCurrency
 
|decimal(18,3)
 
|decimal(18,3)
 
|
 
|
 
|Child discount in currency
 
|Child discount in currency
−
||}
+
|
 +
|}
 +
 
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be created
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
−
EXEC [API_CreateBasketItem] @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'
+
DECLARE @return_value int
 +
EXEC @return_value = [API_CreateShopBasket] @CustomerID= 12 ,@CustomerWorkshopID= 12 ,@GroupID= 32 ,@ProductID= 34 ,@StorageCardID= -1 ,@OrderID= -1 ,@GroupCode= 'OP570' ,@ProductCode= 'A000000034' ,@ManufacturerCode= 'OP570' ,@SupplierCode= 'A000000034' ,@Brand= 'FILTRON' ,@Desription= 'Oil filter' ,@OrderedQuantity= 8 ,@PricePerPiece= 6.743 ,@PricePerPieceWithVAT= 8.29 ,@PurchasePricePerPiece= 5.348 ,@PurchasePricePerPieceWithVAT= 6.58 ,@TotalPrice= 53.94 ,@TotalPriceWithVAT= 66.32 ,@TotalPurchasePrice= 42.78 ,@TotalPurchasePriceWithVAT= 52.64 ,@DiscountInPercent= 20.7 ,@DiscountPrice= -11.16 ,@SurchargesPrice= 0 ,@SurchargePriceWithVAT= 0 ,@PricePerPieceInCurrency= 6.740 ,@PricePerPieceWithVATInCurrency= 8.290 ,@PurchasePricePerPieceInCurrency= 5.350 ,@PurchasePricePerPieceWithVATInCurrency= 6.580 ,@TotalPriceInCurrency= 53.920 ,@TotalPriceWithVATInCurrency= 66.320 ,@TotalPurchasePriceInCurrency= 42.800 ,@TotalPurchasePriceWithVATInCurrency= 52.640 ,@DiscountPriceInCurrency= -1.390 ,@SurchargesPriceInCurrency= 0 ,@SurchargesPriceWithVATInCurrency= 0 ,@CurrencyID= 16034 ,@ForeignCurrencyID= 16034 ,@Note= '',@VATRate= 23.00 ,@HistoryInfo= '' ,@ActionPrice= 0 ,@ChildPricePerPieceInCurrency= -1.000 ,@ChildPricePerPieceWithVATInCurrency= -1.000 ,@ChildPurchasePricePerPieceInCurrency= -1.000 ,@ChildPurchasePricePerPieceWithVATInCurrency= -1.000 ,@ChildDiscountInCurrency= -1.000
 +
 +
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
−
None.
+
None.|}

Aktuální verze z 22. 9. 2017, 10:21

Description

Method allows You to create new basket item in system.

Exact name

API_CreateBasketItem

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@CustomerID int ID of customer from customers list (see relation) API_GetCustomers.ID
@CustomerWorkshopID int ID of workshops from workshops list (see relation) API_GetWorkshops.ID = API_GetCustomers.WorkshopID
@GroupID int ID of product groups from product groups list (see relation) API_GetProductGroups.ID
@ProductID int ID of product from product list (see relation) API_GetProducts.ID
@StorageCardID int ID of stock dispositions from stock dispositions list (see relation) API_GetStockDispositions.ID
@OrderID int ID of orders from orders list (see relation) API_GetOrders.ID
@GroupCode nvarchar(40) Group code
@ProductCode nvarchar(40) Product code
@ManufacturerCode nvarchar(40) Manufacturer code
@SupplierCode nvarchar(40) Supplier code
@Brand nvarchar(50) Brand
@Desription nvarchar(250) Desription
@OrderedQuantity decimal(18,2) Ordered quantity
@PricePerPiece decimal(18,3) Price per piece
@PricePerPieceWithVAT decimal(18,3) Price per piece with VAT
@PurchasePricePerPiece decimal(18,3) Purchase price per piece
@PurchasePricePerPieceWithVAT decimal(18,3) Purchase price per piece with VAT
@TotalPrice decimal(18,3) Total price
@TotalPriceWithVAT decimal(18,3) Total price with VAT
@TotalPurchasePrice decimal(18,3) Total purchase Price
@TotalPurchasePriceWithVAT decimal(18,3) Total purchase price with VAT
@DiscountInPercent decimal(18,3) DiscountIn percent
@DiscountPrice decimal(18,3) Discount price
@SurchargesPrice decimal(18,2) Surcharges price
@SurchargePriceWithVAT decimal(18,2) Surcharge price with VAT
@PricePerPieceInCurrency decimal(18,3) Price per piece in currency
@PricePerPieceWithVATInCurrency decimal(18,3) Price per piece with VAT in currency
@PurchasePricePerPieceInCurrency decimal(18,3) Purchase price per piece in currency
@PurchasePricePerPieceWithVATInCurrency decimal(18,3) Purchase price per piece with VAT in currency
@TotalPriceInCurrency decimal(18,3) Total price in currency
@TotalPriceWithVATInCurrency decimal(18,3) Total price with VAT in currency
@TotalPurchasePriceInCurrency decimal(18,3) Total purchase price in currency
@TotalPurchasePriceWithVATInCurrency decimal(18,3) Total purchase price with VAT in currency
@DiscountPriceInCurrency decimal(18,3) Discount price in currency
@SurchargesPriceInCurrency decimal(18,3) Surcharges price in currency
@SurchargesPriceWithVATInCurrency decimal(18,3) Surcharges price with VAT in currency
@CurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
@ForeignCurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
@Note nvarchar(50) Note
@VATRate decimal(18,2) VAT rate
@HistoryInfo nvarchar(300) History info
@ActionPrice int Action price
@ChildPricePerPieceInCurrency decimal(18,3) Child price per piece in currency
@ChildPricePerPieceWithVATInCurrency decimal(18,3) Child price per piece with VAT in currency
@ChildPurchasePricePerPieceInCurrency decimal(18,3) Child purchase price per piece in currency
@ChildPurchasePricePerPieceWithVATInCurrency decimal(18,3) Child purchase price per piece with VAT in currency
@ChildDiscountInCurrency decimal(18,3) Child discount in currency

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateShopBasket] @CustomerID= 12 ,@CustomerWorkshopID= 12 ,@GroupID= 32 ,@ProductID= 34 ,@StorageCardID= -1 ,@OrderID= -1 ,@GroupCode= 'OP570' ,@ProductCode= 'A000000034' ,@ManufacturerCode= 'OP570' ,@SupplierCode= 'A000000034' ,@Brand= 'FILTRON' ,@Desription= 'Oil filter' ,@OrderedQuantity= 8 ,@PricePerPiece= 6.743 ,@PricePerPieceWithVAT= 8.29 ,@PurchasePricePerPiece= 5.348 ,@PurchasePricePerPieceWithVAT= 6.58 ,@TotalPrice= 53.94 ,@TotalPriceWithVAT= 66.32 ,@TotalPurchasePrice= 42.78 ,@TotalPurchasePriceWithVAT= 52.64 ,@DiscountInPercent= 20.7 ,@DiscountPrice= -11.16 ,@SurchargesPrice= 0 ,@SurchargePriceWithVAT= 0 ,@PricePerPieceInCurrency= 6.740 ,@PricePerPieceWithVATInCurrency= 8.290 ,@PurchasePricePerPieceInCurrency= 5.350 ,@PurchasePricePerPieceWithVATInCurrency= 6.580 ,@TotalPriceInCurrency= 53.920 ,@TotalPriceWithVATInCurrency= 66.320 ,@TotalPurchasePriceInCurrency= 42.800 ,@TotalPurchasePriceWithVATInCurrency= 52.640 ,@DiscountPriceInCurrency= -1.390 ,@SurchargesPriceInCurrency= 0 ,@SurchargesPriceWithVATInCurrency= 0 ,@CurrencyID= 16034 ,@ForeignCurrencyID= 16034 ,@Note= '',@VATRate= 23.00 ,@HistoryInfo= '' ,@ActionPrice= 0 ,@ChildPricePerPieceInCurrency= -1.000 ,@ChildPricePerPieceWithVATInCurrency= -1.000 ,@ChildPurchasePricePerPieceInCurrency= -1.000 ,@ChildPurchasePricePerPieceWithVATInCurrency= -1.000 ,@ChildDiscountInCurrency= -1.000

Notices

None.|}

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateBasketItem&oldid=1024“