API UpdateCustomer - Historie editací

Chrzaszcz v 13. 8. 2020, 10:24

2020-08-13T10:24:59Z

← Starší verze		Verze z 13. 8. 2020, 10:24
Řádek 468:		Řádek 468:
	@AreOrdersVisible = G.[AreOrdersVisible],		@AreOrdersVisible = G.[AreOrdersVisible],
	@DeliveryAddressID = G.[DeliveryAddressID],		@DeliveryAddressID = G.[DeliveryAddressID],
	@DefaultPaymentType = [DefaultPaymentType],		@DefaultPaymentType = S.[DefaultPaymentType],
	@DueType = [DueType],		@DueType = S.[DueType],
	@DueDays = [DueDays],		@DueDays = S.[DueDays],
	@CorrectionPaymentType = [CorrectionPaymentType],		@CorrectionPaymentType = S.[CorrectionPaymentType],
	@CorrectionPaymentRange = [CorrectionPaymentRange],		@CorrectionPaymentRange = S.[CorrectionPaymentRange],
	@CorrectionPaymentRangeDays = [CorrectionPaymentRangeDays]		@CorrectionPaymentRangeDays = S.[CorrectionPaymentRangeDays]
	FROM [API_GetCustomers] G		FROM [API_GetCustomers] G
	LEFT JOIN [API_GetCustomerSettings] S ON G.ID = S.CustomerID		LEFT JOIN [API_GetCustomerSettings] S ON G.ID = S.CustomerID

Chrzaszcz v 13. 8. 2020, 10:23

2020-08-13T10:23:34Z

Ukázat změny

Chrzaszcz v 7. 3. 2019, 10:55

2019-03-07T10:55:04Z

← Starší verze		Verze z 7. 3. 2019, 10:55
Řádek 287:		Řádek 287:

	1000 = full amount		1000 = full amount
			\|
			\|-
			\|@AreOrdersVisible
			\|int
			\|
			\|Are visible orders:
			-1 = Default,

			0 = Off,

			1 = On
	\|		\|
	\|}		\|}
Řádek 341:		Řádek 352:
	DECLARE @IsArchiving int		DECLARE @IsArchiving int
	DECLARE @VisibleProductsAmountOnStockLimit int		DECLARE @VisibleProductsAmountOnStockLimit int
			DECLARE AreOrdersVisible int


Řádek 387:		Řádek 399:
	@IsArchiving = [IsArchiving],		@IsArchiving = [IsArchiving],
	@VisibleProductsAmountOnStockLimit = [VisibleProductsAmountOnStockLimit]		@VisibleProductsAmountOnStockLimit = [VisibleProductsAmountOnStockLimit]
			@AreOrdersVisible = [AreOrdersVisible]
	FROM [API_GetCustomers]		FROM [API_GetCustomers]
	WHERE id = 3		WHERE id = 3
Řádek 434:		Řádek 447:
	@ParentID,		@ParentID,
	@IsArchiving,		@IsArchiving,
	@VisibleProductsAmountOnStockLimit		@VisibleProductsAmountOnStockLimit,
			@AreOrdersVisible

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz: /* Specification */

2018-12-11T14:50:32Z

Specification

← Starší verze		Verze z 11. 12. 2018, 14:50
Řádek 272:		Řádek 272:
	\|		\|
	\|Is archiving		\|Is archiving
			\|
			\|-
			\|@VisibleProductsAmountOnStockLimit
			\|int
			\|
			\|Visible products amount on stock limit
			-1 = Default,

			0 = Picture,

			5 = up to 5 products,

			10 = up to 10 products,

			1000 = full amount
	\|		\|
	\|}		\|}
Řádek 325:		Řádek 340:
	DECLARE @ParentID int		DECLARE @ParentID int
	DECLARE @IsArchiving int		DECLARE @IsArchiving int
			DECLARE @VisibleProductsAmountOnStockLimit int


Řádek 369:		Řádek 385:
	@GPSLongitude = [GPSLongitude],		@GPSLongitude = [GPSLongitude],
	@ParentID = [ParentID],		@ParentID = [ParentID],
	@IsArchiving = [IsArchiving]		@IsArchiving = [IsArchiving],
			@VisibleProductsAmountOnStockLimit = [VisibleProductsAmountOnStockLimit]
	FROM [API_GetCustomers]		FROM [API_GetCustomers]
	WHERE id = 3		WHERE id = 3
Řádek 416:		Řádek 433:
	@GPSLongitude,		@GPSLongitude,
	@ParentID,		@ParentID,
	@IsArchiving		@IsArchiving,
			@VisibleProductsAmountOnStockLimit

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz v 28. 9. 2017, 13:06

2017-09-28T13:06:51Z

← Starší verze		Verze z 28. 9. 2017, 13:06
Řádek 271:		Řádek 271:
	\|int		\|int
	\|		\|
	\|Is ~~Archiving~~		\|Is archiving
	\|		\|
	\|}		\|}

Chrzaszcz v 28. 9. 2017, 12:58

2017-09-28T12:58:01Z

← Starší verze		Verze z 28. 9. 2017, 12:58
Řádek 266:		Řádek 266:
	\|		\|
	\|ParentID		\|ParentID
			\|
			\|-
			\|@IsArchiving
			\|int
			\|
			\|Is Archiving
	\|		\|
	\|}		\|}
Řádek 318:		Řádek 324:
	DECLARE @GPSLongitude nvarchar(20)		DECLARE @GPSLongitude nvarchar(20)
	DECLARE @ParentID int		DECLARE @ParentID int
			DECLARE @IsArchiving int


Řádek 361:		Řádek 368:
	@GPSLatitude = [GPSLatitude],		@GPSLatitude = [GPSLatitude],
	@GPSLongitude = [GPSLongitude],		@GPSLongitude = [GPSLongitude],
	@ParentID = [ParentID]		@ParentID = [ParentID],
			@IsArchiving = [IsArchiving]
	FROM [API_GetCustomers]		FROM [API_GetCustomers]
	WHERE id = 3		WHERE id = 3
Řádek 407:		Řádek 415:
	@GPSLatitude,		@GPSLatitude,
	@GPSLongitude,		@GPSLongitude,
	@ParentID		@ParentID,
			@IsArchiving

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz v 22. 9. 2017, 08:24

2017-09-22T08:24:18Z

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

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	DECLARE @ID int		DECLARE @ID int
	DECLARE @ShortName nvarchar(30)		DECLARE @ShortName nvarchar(30)
Řádek 361:		Řádek 365:
	WHERE id = 3		WHERE id = 3

	EXECUTE [API_UpdateCustomer]		EXECUTE @return_value = [API_UpdateCustomer]
	@ID,		@ID,
	@ShortName,		@ShortName,

Chrzaszcz v 7. 8. 2017, 14:06

2017-08-07T14:06:11Z

@@ Řádek 100: / Řádek 100: @@
+|
 |-
-|@State
+|@Region
-|int
+|nvarchar(30)
+|
 |-
 |@BranchID
@@ Řádek 129: / Řádek 141: @@
 |ID of currency from currency list (see relation)
 |API_GetCurrency.ID
 |-
 |@SendOrderConfirmationEmail
@@ Řádek 164: / Řádek 182: @@
+|
 |Is supplier
+|
 |-
@@ Řádek 182: / Řádek 188: @@
+|
 |Is competition
+|
 |-

Chrzaszcz v 7. 8. 2017, 13:57

2017-08-07T13:57:02Z

← Starší verze		Verze z 7. 8. 2017, 13:57
Řádek 20:		Řádek 20:
	\|		\|
	\|Internal system id		\|Internal system id
	\|~~API_GetBranches~~.ID		\|API_GetCustomers.ID
	\|-		\|-
	\|@ShortName		\|@ShortName

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update customer in system. ==== Exact name ==== `API_UpdateCustomer` ==== Type ==== Standard execut…“

2017-08-07T13:56:29Z

Založena nová stránka s textem „==== Description ==== Method allows You to update customer in system. ==== Exact name ==== <code>API_UpdateCustomer</code> ==== Type ==== Standard execut…“

Nová stránka

==== Description ====
Method allows You to update customer in system.

==== Exact name ====
<code>API_UpdateCustomer</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetBranches.ID
|-
|@ShortName
|nvarchar(30)
|
|Short name
|
|-
|@CompanyName
|nvarchar(250)
|
|Company name
|
|-
|@CompanyRegistrationNumber
|nvarchar(20)
|
|Company registration number
|
|-
|@VATNumber
|nvarchar(20)
|
|VAT number
|
|-
|@VATNumber2
|nvarchar(15)
|
|VAT number 2
|
|-
|@VATPayer
|int
|
|VATPayer
|
|-
|@TransportID
|int
|
|ID of transport from transport list (see relation)
|API_GetTransports.ID
|-
|@Username
|nvarchar(255)
|
|Username
|
|-
|@Password
|nvarchar(25)
|
|Password
|
|-
|@OrderConfirmationPassword
|nvarchar(25)
|
|Order confirmation password
|
|-
|@Street
|nvarchar(100)
|
|Street
|
|-
|@City
|nvarchar(80)
|
|City
|
|-
|@ZIPCode
|nvarchar(15)
|
|ZIP code
|
|-
|@State
|int
|
|ID of country from country list (see relation)
|API_GetCountry.ID
|-
|@BranchID
|int
|
|ID of branche from branch list (see relation)
|API_GetBranches.ID
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|-
|@StockID
|int
|
|ID of stock from stock list (see relation)
|API_GetStocks.ID
|-
|@CurrencyID
|int
|
|ID of currency from currency list (see relation)
|API_GetCurrency.ID
|-
|@SendOrderConfirmationEmail
|int
|
|Send order confirmation email
|
|-
|@OrderConfirmationEmail
|nvarchar(100)
|
|Order confirmation email
|
|-
|@Email
|nvarchar(100)
|
|Email
|
|-
|@EshopEmails
|nvarchar(400)
|
|Eshop emails
|
|-
|@IsBuyer
|int
|
|Is buyer
|
|-
|@IsSupplier
|int
|
|Is supplier
|
|-
|@Region
|nvarchar(30)
|
|Region
|
|-
|@Country
|nvarchar(50)
|
|Country
|
|-
|@IsCompetition
|int
|
|Is competition
|
|-
|@FileMarkText
|nvarchar(200)
|
|File mark text
|
|-
|@IsWSInvoicesExportAllowed
|bit
|
|Is WS invoices export allowed
|
|-
|@IsWSDeliveryNotesExportAllowed
|bit
|
|Is WS delivery notes export Allowed
|
|-
|@IsWSImportOrdersAllowed
|bit
|
|Is WS import orders Allowed
|
|-
|@StoreBackOrder
|int
|
|Store backorder
|
|-
|@IsSupplierIndividualOrders
|int
|
|Is supplier individual orders
|
|-
|@IsSupplierShortcut
|nvarchar(10)
|
|Is supplier shortcut
|
|-
|@Note
|nvarchar(500)
|
|Note
|
|-
|@Note2
|nvarchar(500)
|
|Note 2
|
|-
|@GlobalPricing
|int
|
|Global pricing
|
|-
|@OrderGroup
|nvarchar(10)
|
|Order group
|
|-
|@GPSLatitude
|nvarchar(20)
|
|GPS latitude
|
|-
|@GPSLongitude
|nvarchar(20)
|
|GPS longitude
|
|-
|@ParentID
|int
|
|ParentID
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @ShortName nvarchar(30)
DECLARE @CompanyName nvarchar(250)
DECLARE @CompanyRegistrationNumber nvarchar(20)
DECLARE @VATNumber nvarchar(20)
DECLARE @VATNumber2 nvarchar(15)
DECLARE @VATPayer int
DECLARE @TransportID int
DECLARE @Username nvarchar(20)
DECLARE @Password nvarchar(25)
DECLARE @OrderConfirmationPassword nvarchar(25)
DECLARE @Street nvarchar(100)
DECLARE @City nvarchar(80)
DECLARE @ZIPCode nvarchar(15)
DECLARE @Region nvarchar(30)
DECLARE @Country nvarchar(50)
DECLARE @FileMarkText nvarchar(200)
DECLARE @BranchID int
DECLARE @WorkshopID int
DECLARE @StockID int
DECLARE @CurrencyID int
DECLARE @State int
DECLARE @SendOrderConfirmationEmail int
DECLARE @OrderConfirmationEmail nvarchar(100)
DECLARE @Email nvarchar(100)
DECLARE @EShopEMails nvarchar(400)
DECLARE @IsBuyer bit
DECLARE @IsSupplier bit
DECLARE @IsCompetition bit
DECLARE @IsWSInvoicesExportAllowed bit
DECLARE @IsWSDeliveryNotesExportAllowed bit
DECLARE @IsWSImportOrdersAllowed bit
DECLARE @StoreBackOrder bit
DECLARE @IsSupplierIndividualOrders bit
DECLARE @IsSupplierShortcut nvarchar(10)
DECLARE @Note nvarchar(500)
DECLARE @Note2 nvarchar(500)
DECLARE @GlobalPricing bit
DECLARE @OrderGroup nvarchar(10)
DECLARE @GPSLatitude nvarchar(20)
DECLARE @GPSLongitude nvarchar(20)
DECLARE @ParentID int

SELECT @ID = [ID],
@ShortName = [ShortName],
@CompanyName = [CompanyName],
@CompanyRegistrationNumber = [CompanyRegistrationNumber],
@VATNumber = [VATNumber],
@VATNumber2 = [VATNumber2],
@VATPayer = [VATPayer],
@TransportID = [TransportID],
@Username = [Username],
@Password = [Password],
@OrderConfirmationPassword = [OrderConfirmationPassword],
@Street = [Street],
@City = [City],
@ZIPCode = [ZIPCode],
@Region = [Region],
@Country = [Country],
@FileMarkText = [FileMarkText],
@BranchID = [BranchID],
@WorkshopID = [WorkshopID],
@StockID = [StockID],
@CurrencyID = [CurrencyID],
@State = [State],
@SendOrderConfirmationEmail = [SendOrderConfirmationEmail],
@OrderConfirmationEmail = [OrderConfirmationEmail],
@Email = [Email],
@EShopEMails = [EShopEMails],
@IsBuyer = [IsBuyer],
@IsSupplier = [IsSupplier],
@IsCompetition = [IsCompetition],
@IsWSInvoicesExportAllowed = [IsWSInvoicesExportAllowed],
@IsWSDeliveryNotesExportAllowed = [IsWSDeliveryNotesExportAllowed],
@IsWSImportOrdersAllowed = [IsWSImportOrdersAllowed],
@StoreBackOrder = [StoreBackOrder],
@IsSupplierIndividualOrders = [IsSupplierIndividualOrders],
@IsSupplierShortcut = [IsSupplierShortcut],
@Note = [Note],
@Note2 = [Note2],
@GlobalPricing = [GlobalPricing],
@OrderGroup = [OrderGroup],
@GPSLatitude = [GPSLatitude],
@GPSLongitude = [GPSLongitude],
@ParentID = [ParentID]
FROM [API_GetCustomers]
WHERE id = 3

EXECUTE [API_UpdateCustomer]
@ID,
@ShortName,
@CompanyName,
@CompanyRegistrationNumber,
@VATNumber,
@VATNumber2,
@VATPayer,
@TransportID,
@Username,
@Password,
@OrderConfirmationPassword,
@Street,
@City,
@ZIPCode,
@Region,
@Country,
@FileMarkText,
@BranchID,
@WorkshopID,
@StockID,
@CurrencyID,
@State,
@SendOrderConfirmationEmail,
@OrderConfirmationEmail,
@Email,
@EShopEMails,
@IsBuyer,
@IsSupplier,
@IsCompetition,
@IsWSInvoicesExportAllowed,
@IsWSDeliveryNotesExportAllowed,
@IsWSImportOrdersAllowed,
@StoreBackOrder,
@IsSupplierIndividualOrders,
@IsSupplierShortcut,
@Note,
@Note2,
@GlobalPricing,
@OrderGroup,
@GPSLatitude,
@GPSLongitude,
@ParentID

</syntaxhighlight>

==== Notices ====
None.