API UpdateProductGroup - Historie editací

Chrzaszcz v 13. 8. 2020, 08:37

2020-08-13T08:37:25Z

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

	1 = On		1 = On
			\|
			\|-
			\|@InfoReturnOfGoods
			\|nvarchar(50)
			\|
			\|Info return of goods
	\|		\|
	\|}		\|}
Řádek 236:		Řádek 242:
	DECLARE @IsSale bit		DECLARE @IsSale bit
	DECLARE @IsHiddenOnEshop bit		DECLARE @IsHiddenOnEshop bit
			DECLARE @InfoReturnOfGoods nvarchar(50)


Řádek 258:		Řádek 265:
	@UnitID = [UnitID],		@UnitID = [UnitID],
	@IsArchiving = [IsArchiving],		@IsArchiving = [IsArchiving],
	@IsSale = [IsSale]		@IsSale = [IsSale],
	@IsHiddenOnEshop = [IsHiddenOnEshop]		@IsHiddenOnEshop = [IsHiddenOnEshop]
	FROM [API_GetProductGroups]		FROM [API_GetProductGroups]
	WHERE id = 3		WHERE id = 3
Řádek 270:		Řádek 277:
	@SupplierItemName = [SupplierItemName],		@SupplierItemName = [SupplierItemName],
	@BasicPrice = [BasicPrice],		@BasicPrice = [BasicPrice],
	@SupplierRetailPrice = [RetailPrice]		@SupplierRetailPrice = [RetailPrice],
	@SupplierIsArchiving = [IsArchiving]		@SupplierIsArchiving = [IsArchiving],
			@InfoReturnOfGoods = [InfoReturnOfGoods]
	FROM [API_GetProducts]		FROM [API_GetProducts]
	WHERE GroupID = @ID and SupplierID = @SupplierID		WHERE GroupID = @ID and SupplierID = @SupplierID
Řádek 305:		Řádek 313:
	@UnitID,		@UnitID,
	@IsSale,		@IsSale,
	@IsHiddenOnEshop		@IsHiddenOnEshop,
			@InfoReturnOfGoods

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz: Add IsHiddenOnEshop

2020-02-19T10:25:00Z

Add IsHiddenOnEshop

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

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

Řádek 226:		Řádek 235:
	DECLARE @UnitID int		DECLARE @UnitID int
	DECLARE @IsSale bit		DECLARE @IsSale bit
			DECLARE @IsHiddenOnEshop bit


Řádek 249:		Řádek 259:
	@IsArchiving = [IsArchiving],		@IsArchiving = [IsArchiving],
	@IsSale = [IsSale]		@IsSale = [IsSale]
			@IsHiddenOnEshop = [IsHiddenOnEshop]
	FROM [API_GetProductGroups]		FROM [API_GetProductGroups]
	WHERE id = 3		WHERE id = 3
Řádek 293:		Řádek 304:
	@MinimumOrderablePieces,		@MinimumOrderablePieces,
	@UnitID,		@UnitID,
	@IsSale		@IsSale,
			@IsHiddenOnEshop

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz v 22. 7. 2019, 07:55

2019-07-22T07:55:53Z

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

			1 = On
	\|		\|
	\|-		\|-
Řádek 177:		Řádek 180:
	\|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 213:		Řádek 225:
	DECLARE @MinimumOrderablePieces decimal(18,2)		DECLARE @MinimumOrderablePieces decimal(18,2)
	DECLARE @UnitID int		DECLARE @UnitID int
			DECLARE @IsSale bit


Řádek 234:		Řádek 247:
	@MinimumOrderablePieces = [MinimumOrderablePieces],		@MinimumOrderablePieces = [MinimumOrderablePieces],
	@UnitID = [UnitID],		@UnitID = [UnitID],
	@IsArchiving = [IsArchiving]		@IsArchiving = [IsArchiving],
			@IsSale = [IsSale]
	FROM [API_GetProductGroups]		FROM [API_GetProductGroups]
	WHERE id = 3		WHERE id = 3
Řádek 278:		Řádek 292:
	@VATRate,		@VATRate,
	@MinimumOrderablePieces,		@MinimumOrderablePieces,
	@UnitID		@UnitID,
			@IsSale

	</syntaxhighlight>		</syntaxhighlight>

Chrzaszcz v 9. 11. 2018, 13:46

2018-11-09T13:46:58Z

← Starší verze		Verze z 9. 11. 2018, 13:46
Řádek 71:		Řádek 71:
	\|-		\|-
	\|@Name2		\|@Name2
	\|~~varchar~~(150)		\|nvarchar(150)
	\|		\|
	\|Name2		\|Name2
Řádek 149:		Řádek 149:
	\|-		\|-
	\|@Description		\|@Description
	\|~~varchar~~(250)		\|nvarchar(250)
	\|		\|
	\|Description		\|Description
Řádek 195:		Řádek 195:
	DECLARE @AssortmentName nvarchar(100)		DECLARE @AssortmentName nvarchar(100)
	DECLARE @Name nvarchar(100)		DECLARE @Name nvarchar(100)
	DECLARE @Name2 ~~varchar~~(150)		DECLARE @Name2 nvarchar(150)
	DECLARE @IsNew bit		DECLARE @IsNew bit
	DECLARE @PurchasePrice decimal(19,6)		DECLARE @PurchasePrice decimal(19,6)
Řádek 208:		Řádek 208:
	DECLARE @SupplierRetailPrice decimal(19,6)		DECLARE @SupplierRetailPrice decimal(19,6)
	DECLARE @SupplierIsArchiving int		DECLARE @SupplierIsArchiving int
	DECLARE @Description ~~varchar~~(250)		DECLARE @Description nvarchar(250)
	DECLARE @EshopDescription nvarchar(500)		DECLARE @EshopDescription nvarchar(500)
	DECLARE @VATRate int		DECLARE @VATRate int

Chrzaszcz v 28. 9. 2017, 13:21

2017-09-28T13:21:00Z

← Starší verze		Verze z 28. 9. 2017, 13:21
Řádek 92:		Řádek 92:
	\|		\|
	\|Retail price		\|Retail price
			\|
			\|-
			\|@IsArchiving
			\|int
			\|
			\|Is archiving
	\|		\|
	\|-		\|-
Řádek 134:		Řádek 140:
	\|		\|
	\|Supplier retail price		\|Supplier retail price
			\|
			\|-
			\|@SupplierIsArchiving
			\|int
			\|
			\|Supplier is archiving
	\|		\|
	\|-		\|-
Řádek 187:		Řádek 199:
	DECLARE @PurchasePrice decimal(19,6)		DECLARE @PurchasePrice decimal(19,6)
	DECLARE @RetailPrice decimal(19,6)		DECLARE @RetailPrice decimal(19,6)
			DECLARE @IsArchiving int
	DECLARE @SupplierID int		DECLARE @SupplierID int
	DECLARE @Prefix nvarchar(3)		DECLARE @Prefix nvarchar(3)
Řádek 194:		Řádek 207:
	DECLARE @BasicPrice decimal(19,6)		DECLARE @BasicPrice decimal(19,6)
	DECLARE @SupplierRetailPrice decimal(19,6)		DECLARE @SupplierRetailPrice decimal(19,6)
			DECLARE @SupplierIsArchiving int
	DECLARE @Description varchar(250)		DECLARE @Description varchar(250)
	DECLARE @EshopDescription nvarchar(500)		DECLARE @EshopDescription nvarchar(500)
Řádek 219:		Řádek 233:
	@VATRate = [VATRate],		@VATRate = [VATRate],
	@MinimumOrderablePieces = [MinimumOrderablePieces],		@MinimumOrderablePieces = [MinimumOrderablePieces],
	@UnitID = [UnitID]		@UnitID = [UnitID],
			@IsArchiving = [IsArchiving]
	FROM [API_GetProductGroups]		FROM [API_GetProductGroups]
	WHERE id = 3		WHERE id = 3
Řádek 231:		Řádek 246:
	@BasicPrice = [BasicPrice],		@BasicPrice = [BasicPrice],
	@SupplierRetailPrice = [RetailPrice]		@SupplierRetailPrice = [RetailPrice]
			@SupplierIsArchiving = [IsArchiving]
	FROM [API_GetProducts]		FROM [API_GetProducts]
	WHERE GroupID = @ID and SupplierID = @SupplierID		WHERE GroupID = @ID and SupplierID = @SupplierID
Řádek 249:		Řádek 265:
	@PurchasePrice,		@PurchasePrice,
	@RetailPrice,		@RetailPrice,
			@IsArchiving,
	@SupplierID,		@SupplierID,
	@Prefix,		@Prefix,
Řádek 256:		Řádek 273:
	@BasicPrice,		@BasicPrice,
	@SupplierRetailPrice,		@SupplierRetailPrice,
			@SupplierIsArchiving,
	@Description,		@Description,
	@EshopDescription,		@EshopDescription,

Chrzaszcz v 22. 9. 2017, 08:35

2017-09-22T08:35:15Z

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

			==== 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 @ProductCode nvarchar(40)		DECLARE @ProductCode nvarchar(40)
Řádek 231:		Řádek 235:


	EXECUTE [API_UpdateProductGroup]		EXECUTE @return_value = [API_UpdateProductGroup]
	@ID,		@ID,
	@ProductCode,		@ProductCode,

Chrzaszcz v 8. 8. 2017, 07:27

2017-08-08T07:27:06Z

← Starší verze		Verze z 8. 8. 2017, 07:27
Řádek 20:		Řádek 20:
	\|		\|
	\|Internal system id		\|Internal system id
	\|~~API_GetBranches~~.ID		\|API_GetProductGroups.ID
	\|-
	~~\|@ID~~
	~~\|int~~
	\|
	\|
	\|
	\|-		\|-
	\|@ProductCode		\|@ProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Product code
	\|		\|
	\|-		\|-
Řádek 37:		Řádek 31:
	\|nvarchar(35)		\|nvarchar(35)
	\|		\|
	\|		\|TecDoc code
	\|		\|
	\|-		\|-
Řádek 43:		Řádek 37:
	\|nvarchar(80)		\|nvarchar(80)
	\|		\|
	\|		\|TecDoc brand name
	\|		\|
	\|-		\|-
Řádek 49:		Řádek 43:
	\|int		\|int
	\|		\|
	\|		\|TecDoc brand ID
	\|		\|
	\|-		\|-
Řádek 55:		Řádek 49:
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|Group name
	\|		\|
	\|-		\|-
Řádek 61:		Řádek 55:
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|Sub goup name
	\|		\|
	\|-		\|-
Řádek 67:		Řádek 61:
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|AssortmentName
	\|		\|
	\|-		\|-
Řádek 73:		Řádek 67:
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|Name
	\|		\|
	\|-		\|-
Řádek 79:		Řádek 73:
	\|varchar(150)		\|varchar(150)
	\|		\|
	\|		\|Name2
	\|		\|
	\|-		\|-
Řádek 85:		Řádek 79:
	\|bit		\|bit
	\|		\|
	\|		\|Is new
	\|		\|
	\|-		\|-
Řádek 91:		Řádek 85:
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|Purchase price
	\|		\|
	\|-		\|-
Řádek 97:		Řádek 91:
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|Retail price
	\|		\|
	\|-		\|-
Řádek 103:		Řádek 97:
	\|int		\|int
	\|		\|
	\|		\|Supplier ID
	\|		\|API_GetCustomers.ID
	\|-		\|-
	\|@Prefix		\|@Prefix
	\|nvarchar(3)		\|nvarchar(3)
	\|		\|
	\|		\|@Prefix
	\|		\|
	\|-		\|-
Řádek 115:		Řádek 109:
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|Supplier product code
	\|		\|
	\|-		\|-
Řádek 121:		Řádek 115:
	\|nvarchar(50)		\|nvarchar(50)
	\|		\|
	\|		\|Manufacturer supplier
	\|		\|
	\|-		\|-
Řádek 127:		Řádek 121:
	\|nvarchar(300)		\|nvarchar(300)
	\|		\|
	\|		\|Supplier item name
	\|		\|
	\|-		\|-
Řádek 133:		Řádek 127:
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|Basic price
	\|		\|
	\|-		\|-
Řádek 139:		Řádek 133:
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|Supplier retail price
	\|		\|
	\|-		\|-
Řádek 145:		Řádek 139:
	\|varchar(250)		\|varchar(250)
	\|		\|
	\|		\|Description
	\|		\|
	\|-		\|-
Řádek 151:		Řádek 145:
	\|nvarchar(500)		\|nvarchar(500)
	\|		\|
	\|		\|Eshop description
	\|		\|
	\|-		\|-
Řádek 157:		Řádek 151:
	\|int		\|int
	\|		\|
	\|		\|ID of VAT rates from VAT rates list (see relation)
	\|		\|API_GetVATRates.ID
	\|-		\|-
	\|@MinimumOrderablePieces		\|@MinimumOrderablePieces
	\|decimal(18,2)		\|decimal(18,2)
	\|		\|
	\|		\|Minimum orderable pieces
	\|		\|
	\|-		\|-
Řádek 169:		Řádek 163:
	\|int		\|int
	\|		\|
	\|		\|ID of unit from units list (see relation)
	\|		\|API_GetUnits.ID
	\|}		\|}

Chrzaszcz v 8. 8. 2017, 07:15

2017-08-08T07:15:11Z

← Starší verze		Verze z 8. 8. 2017, 07:15
Řádek 21:		Řádek 21:
	\|Internal system id		\|Internal system id
	\|API_GetBranches.ID		\|API_GetBranches.ID
	\|-@ID		\|-
			\|@ID
	\|int		\|int
	\|		\|
	\|		\|
	\|		\|
	\|-@ProductCode		\|-
			\|@ProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|
	\|		\|
	\|-@TecDocCode		\|-
			\|@TecDocCode
	\|nvarchar(35)		\|nvarchar(35)
	\|		\|
	\|		\|
	\|		\|
	\|-@TecDocBrandName		\|-
			\|@TecDocBrandName
	\|nvarchar(80)		\|nvarchar(80)
	\|		\|
	\|		\|
	\|		\|
	\|-@TecDocBrandID		\|-
			\|@TecDocBrandID
	\|int		\|int
	\|		\|
	\|		\|
	\|		\|
	\|-@GroupName		\|-
			\|@GroupName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|
	\|		\|
	\|-@SubGoupName		\|-
			\|@SubGoupName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|
	\|		\|
	\|-@AssortmentName		\|-
			\|@AssortmentName
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|
	\|		\|
	\|-@Name		\|-
			\|@Name
	\|nvarchar(100)		\|nvarchar(100)
	\|		\|
	\|		\|
	\|		\|
	\|-@Name2		\|-
			\|@Name2
	\|varchar(150)		\|varchar(150)
	\|		\|
	\|		\|
	\|		\|
	\|-@IsNew		\|-
			\|@IsNew
	\|bit		\|bit
	\|		\|
	\|		\|
	\|		\|
	\|-@PurchasePrice		\|-
			\|@PurchasePrice
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|
	\|		\|
	\|-@RetailPrice		\|-
			\|@RetailPrice
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|
	\|		\|
	\|-@SupplierID		\|-
			\|@SupplierID
	\|int		\|int
	\|		\|
	\|		\|
	\|		\|
	\|-@Prefix		\|-
			\|@Prefix
	\|nvarchar(3)		\|nvarchar(3)
	\|		\|
	\|		\|
	\|		\|
	\|-@SupplierProductCode		\|-
			\|@SupplierProductCode
	\|nvarchar(40)		\|nvarchar(40)
	\|		\|
	\|		\|
	\|		\|
	\|-@ManufacturerSupplier		\|-
			\|@ManufacturerSupplier
	\|nvarchar(50)		\|nvarchar(50)
	\|		\|
	\|		\|
	\|		\|
	\|-@SupplierItemName		\|-
			\|@SupplierItemName
	\|nvarchar(300)		\|nvarchar(300)
	\|		\|
	\|		\|
	\|		\|
	\|-@BasicPrice		\|-
			\|@BasicPrice
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|
	\|		\|
	\|-@SupplierRetailPrice		\|-
			\|@SupplierRetailPrice
	\|decimal(19,6)		\|decimal(19,6)
	\|		\|
	\|		\|
	\|		\|
	\|-@Description		\|-
			\|@Description
	\|varchar(250)		\|varchar(250)
	\|		\|
	\|		\|
	\|		\|
	\|-@EshopDescription		\|-
			\|@EshopDescription
	\|nvarchar(500)		\|nvarchar(500)
	\|		\|
	\|		\|
	\|		\|
	\|-@VATRate		\|-
			\|@VATRate
	\|int		\|int
	\|		\|
	\|		\|
	\|		\|
	\|-@MinimumOrderablePieces		\|-
			\|@MinimumOrderablePieces
	\|decimal(18,2)		\|decimal(18,2)
	\|		\|
	\|		\|
	\|		\|
	\|-@UnitID		\|-
			\|@UnitID
	\|int		\|int
	\|		\|

Chrzaszcz v 8. 8. 2017, 07:13

2017-08-08T07:13:09Z

@@ Řádek 21: / Řádek 21: @@
 |Internal system id
 |API_GetBranches.ID
+|-@ID
+|int
 |}

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update product group in system. ==== Exact name ==== `API_UpdateProductGroup` ==== Type ==== Standa…“

2017-08-07T15:01:03Z

Založena nová stránka s textem „==== Description ==== Method allows You to update product group in system. ==== Exact name ==== <code>API_UpdateProductGroup</code> ==== Type ==== Standa…“

Nová stránka

==== Description ====
Method allows You to update product group in system.

==== Exact name ====
<code>API_UpdateProductGroup</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|API_GetBranches.ID

|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @ProductCode nvarchar(40)
DECLARE @TecDocCode nvarchar(35)
DECLARE @TecDocBrandName nvarchar(80)
DECLARE @TecDocBrandID int
DECLARE @GroupName nvarchar(100)
DECLARE @SubGoupName nvarchar(100)
DECLARE @AssortmentName nvarchar(100)
DECLARE @Name nvarchar(100)
DECLARE @Name2 varchar(150)
DECLARE @IsNew bit
DECLARE @PurchasePrice decimal(19,6)
DECLARE @RetailPrice decimal(19,6)
DECLARE @SupplierID int
DECLARE @Prefix nvarchar(3)
DECLARE @SupplierProductCode nvarchar(40)
DECLARE @ManufacturerSupplier nvarchar(50)
DECLARE @SupplierItemName nvarchar(300)
DECLARE @BasicPrice decimal(19,6)
DECLARE @SupplierRetailPrice decimal(19,6)
DECLARE @Description varchar(250)
DECLARE @EshopDescription nvarchar(500)
DECLARE @VATRate int
DECLARE @MinimumOrderablePieces decimal(18,2)
DECLARE @UnitID int

SELECT @ID = [ID],
@ProductCode = [ProductCode],
@TecDocCode = [TecDocCode],
@TecDocBrandName = [TecDocBrandName],
@TecDocBrandID = [TecDocBrandID],
@GroupName = [GroupName],
@SubGoupName = [SubGoupName],
@AssortmentName = [AssortmentName],
@Name = 'Name 2',
@Name2 = [Name2],
@IsNew = [IsNew],
@PurchasePrice = [PurchasePrice],
@RetailPrice = [RetailPrice],
@Description = [Description],
@EshopDescription = [EshopDescription],
@VATRate = [VATRate],
@MinimumOrderablePieces = [MinimumOrderablePieces],
@UnitID = [UnitID]
FROM [API_GetProductGroups]
WHERE id = 3

SELECT @SupplierID = [SupplierID],
@Prefix = [Prefix],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@SupplierItemName = [SupplierItemName],
@BasicPrice = [BasicPrice],
@SupplierRetailPrice = [RetailPrice]
FROM [API_GetProducts]
WHERE GroupID = @ID and SupplierID = @SupplierID

EXECUTE [API_UpdateProductGroup]
@ID,
@ProductCode,
@TecDocCode,
@TecDocBrandName,
@TecDocBrandID,
@GroupName,
@SubGoupName,
@AssortmentName,
@Name,
@Name2,
@IsNew,
@PurchasePrice,
@RetailPrice,
@SupplierID,
@Prefix,
@SupplierProductCode,
@ManufacturerSupplier,
@SupplierItemName,
@BasicPrice,
@SupplierRetailPrice,
@Description,
@EshopDescription,
@VATRate,
@MinimumOrderablePieces,
@UnitID

</syntaxhighlight>

==== Notices ====
None.