API UpdateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
(Add IsHiddenOnEshop) |
|||
| Řádka 197: | Řádka 197: | ||
1 = On | 1 = On | ||
| + | | | ||
| + | |- | ||
| + | |@InfoReturnOfGoods | ||
| + | |nvarchar(50) | ||
| + | | | ||
| + | |Info return of goods | ||
| | | | ||
|} | |} | ||
| Řádka 236: | Řádka 242: | ||
DECLARE @IsSale bit | DECLARE @IsSale bit | ||
DECLARE @IsHiddenOnEshop bit | DECLARE @IsHiddenOnEshop bit | ||
| + | DECLARE @InfoReturnOfGoods nvarchar(50) | ||
| Řádka 258: | Řádka 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 | ||
| Řádka 270: | Řádka 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 | ||
| Řádka 305: | Řádka 313: | ||
@UnitID, | @UnitID, | ||
@IsSale, | @IsSale, | ||
| − | @IsHiddenOnEshop | + | @IsHiddenOnEshop, |
| + | @InfoReturnOfGoods | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Aktuální verze z 13. 8. 2020, 10:37
Description
Method allows You to update product group in system.
Exact name
API_UpdateProductGroup
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | API_GetProductGroups.ID | |
| @ProductCode | nvarchar(40) | Product code | ||
| @TecDocCode | nvarchar(35) | TecDoc code | ||
| @TecDocBrandName | nvarchar(80) | TecDoc brand name | ||
| @TecDocBrandID | int | TecDoc brand ID | ||
| @GroupName | nvarchar(100) | Group name | ||
| @SubGoupName | nvarchar(100) | Sub goup name | ||
| @AssortmentName | nvarchar(100) | AssortmentName | ||
| @Name | nvarchar(100) | Name | ||
| @Name2 | nvarchar(150) | Name2 | ||
| @IsNew | bit | Is new:
0 = Off, 1 = On |
||
| @PurchasePrice | decimal(19,6) | Purchase price | ||
| @RetailPrice | decimal(19,6) | Retail price | ||
| @IsArchiving | int | Is archiving | ||
| @SupplierID | int | Supplier ID | API_GetCustomers.ID | |
| @Prefix | nvarchar(3) | @Prefix | ||
| @SupplierProductCode | nvarchar(40) | Supplier product code | ||
| @ManufacturerSupplier | nvarchar(50) | Manufacturer supplier | ||
| @SupplierItemName | nvarchar(300) | Supplier item name | ||
| @BasicPrice | decimal(19,6) | Basic price | ||
| @SupplierRetailPrice | decimal(19,6) | Supplier retail price | ||
| @SupplierIsArchiving | int | Supplier is archiving | ||
| @Description | nvarchar(250) | Description | ||
| @EshopDescription | nvarchar(500) | Eshop description | ||
| @VATRate | int | ID of VAT rates from VAT rates list (see relation) | API_GetVATRates.ID | |
| @MinimumOrderablePieces | decimal(18,2) | Minimum orderable pieces | ||
| @UnitID | int | ID of unit from units list (see relation) | API_GetUnits.ID | |
| @IsSale | bit | Is sale:
0 = Off, 1 = On |
||
| @IsHiddenOnEshop | bit | Is hidden on eshop:
0 = Off, 1 = On |
||
| @InfoReturnOfGoods | nvarchar(50) | Info return of goods |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
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 nvarchar(150)
DECLARE @IsNew bit
DECLARE @PurchasePrice decimal(19,6)
DECLARE @RetailPrice decimal(19,6)
DECLARE @IsArchiving int
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 @SupplierIsArchiving int
DECLARE @Description nvarchar(250)
DECLARE @EshopDescription nvarchar(500)
DECLARE @VATRate int
DECLARE @MinimumOrderablePieces decimal(18,2)
DECLARE @UnitID int
DECLARE @IsSale bit
DECLARE @IsHiddenOnEshop bit
DECLARE @InfoReturnOfGoods nvarchar(50)
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],
@IsArchiving = [IsArchiving],
@IsSale = [IsSale],
@IsHiddenOnEshop = [IsHiddenOnEshop]
FROM [API_GetProductGroups]
WHERE id = 3
SELECT @SupplierID = [SupplierID],
@Prefix = [Prefix],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@SupplierItemName = [SupplierItemName],
@BasicPrice = [BasicPrice],
@SupplierRetailPrice = [RetailPrice],
@SupplierIsArchiving = [IsArchiving],
@InfoReturnOfGoods = [InfoReturnOfGoods]
FROM [API_GetProducts]
WHERE GroupID = @ID and SupplierID = @SupplierID
EXECUTE @return_value = [API_UpdateProductGroup]
@ID,
@ProductCode,
@TecDocCode,
@TecDocBrandName,
@TecDocBrandID,
@GroupName,
@SubGoupName,
@AssortmentName,
@Name,
@Name2,
@IsNew,
@PurchasePrice,
@RetailPrice,
@IsArchiving,
@SupplierID,
@Prefix,
@SupplierProductCode,
@ManufacturerSupplier,
@SupplierItemName,
@BasicPrice,
@SupplierRetailPrice,
@SupplierIsArchiving,
@Description,
@EshopDescription,
@VATRate,
@MinimumOrderablePieces,
@UnitID,
@IsSale,
@IsHiddenOnEshop,
@InfoReturnOfGoods
Notices
None.
