API UpdateProductGroup: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 79: | Řádka 79: | ||
|bit | |bit | ||
| | | | ||
| − | |Is new | + | |Is new: |
| + | 0 = Off, | ||
| + | |||
| + | 1 = On | ||
| | | | ||
|- | |- | ||
| Řádka 177: | Řádka 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 | ||
| + | | | ||
|} | |} | ||
| Řádka 213: | Řádka 225: | ||
DECLARE @MinimumOrderablePieces decimal(18,2) | DECLARE @MinimumOrderablePieces decimal(18,2) | ||
DECLARE @UnitID int | DECLARE @UnitID int | ||
| + | DECLARE @IsSale bit | ||
| Řádka 234: | Řádka 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 | ||
| Řádka 278: | Řádka 292: | ||
@VATRate, | @VATRate, | ||
@MinimumOrderablePieces, | @MinimumOrderablePieces, | ||
| − | @UnitID | + | @UnitID, |
| + | @IsSale | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Verze z 22. 7. 2019, 08:55
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 |
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
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]
FROM [API_GetProductGroups]
WHERE id = 3
SELECT @SupplierID = [SupplierID],
@Prefix = [Prefix],
@SupplierProductCode = [SupplierProductCode],
@ManufacturerSupplier = [ManufacturerSupplier],
@SupplierItemName = [SupplierItemName],
@BasicPrice = [BasicPrice],
@SupplierRetailPrice = [RetailPrice]
@SupplierIsArchiving = [IsArchiving]
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
Notices
None.
