API CreateBasketItem - Historie editací

Chrzaszcz v 22. 9. 2017, 08:21

2017-09-22T08:21:29Z

← Starší verze		Verze z 22. 9. 2017, 08:21
Řádek 298:		Řádek 298:
	\|		\|
	\|}		\|}

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	EXEC [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		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

Chrzaszcz v 31. 7. 2017, 13:59

2017-07-31T13:59:48Z

← Starší verze		Verze z 31. 7. 2017, 13:59
Řádek 301:		Řádek 301:
	==== 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'~~		EXEC [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.\|}

Chrzaszcz v 31. 7. 2017, 13:38

2017-07-31T13:38:37Z

← Starší verze		Verze z 31. 7. 2017, 13:38
Řádek 55:		Řádek 55:
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Group code
	\|		\|
	\|-		\|-
Řádek 61:		Řádek 61:
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Product code
	\|		\|
	\|-		\|-
Řádek 67:		Řádek 67:
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Manufacturer code
	\|		\|
	\|-		\|-
Řádek 73:		Řádek 73:
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Supplier code
	\|		\|
	\|-		\|-
Řádek 79:		Řádek 79:
	\|nvarchar(50)		\|nvarchar(50)
	\|		\|
	\|		\|Brand
	\|		\|
	\|-		\|-

Chrzaszcz v 31. 7. 2017, 13:29

2017-07-31T13:29:36Z

← Starší verze		Verze z 31. 7. 2017, 13:29
Řádek 296:		Řádek 296:
	\|		\|
	\|Child discount in currency		\|Child discount in currency
	\|\|}		\|
			\|}

	==== Example ====		==== Example ====

Chrzaszcz v 31. 7. 2017, 13:28

2017-07-31T13:28:31Z

Ukázat změny

Chrzaszcz v 31. 7. 2017, 13:23

2017-07-31T13:23:05Z

Ukázat změny

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new basket item in system. ==== Exact name ==== `API_CreateBasketItem` ==== Type ==== Standa…“

2017-07-31T13:19:07Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new basket item in system. ==== Exact name ==== <code>API_CreateBasketItem</code> ==== Type ==== Standa…“

Nová stránka

==== Description ====
Method allows You to create new basket item in system.

==== Exact name ====
<code>API_CreateBasketItem</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|}

==== Example ====
<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'
</syntaxhighlight>

==== Notices ====
None.