UFN_AUCTIONITEM_GETVALUES_INCURRENCY

Returns a table of values with their currency IDs for an auction item or package.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONITEMID	uniqueidentifier	IN
Definition

Copy


            create function dbo.UFN_AUCTIONITEM_GETVALUES_INCURRENCY
            (
                @AUCTIONITEMID uniqueidentifier
            )
            returns @AUCTIONITEMINFO table
            (
                VALUE money,
                BASECURRENCYID uniqueidentifier,
                TRANSACTIONVALUE money,
                TRANSACTIONCURRENCYID uniqueidentifier,
                ORGANIZATIONVALUE money
            )
            as begin
                declare @TYPECODE tinyint = 0;

                select @TYPECODE = TYPECODE from dbo.AUCTIONITEM where AUCTIONITEM.ID = @AUCTIONITEMID;

                if @TYPECODE = 0
                begin
                    insert into @AUCTIONITEMINFO
                    (
                        VALUE,
                        BASECURRENCYID,
                        TRANSACTIONVALUE,
                        TRANSACTIONCURRENCYID,
                        ORGANIZATIONVALUE
                    )
                    select
                        AUCTIONITEM.VALUE,
                        AUCTIONITEM.BASECURRENCYID,
                        AUCTIONITEM.TRANSACTIONVALUE,
                        AUCTIONITEM.TRANSACTIONCURRENCYID,
                        AUCTIONITEM.ORGANIZATIONVALUE
                    from dbo.AUCTIONITEM
                    where AUCTIONITEM.ID = @AUCTIONITEMID
                end
                else
                begin
                    insert into @AUCTIONITEMINFO
                    (
                        VALUE,
                        BASECURRENCYID,
                        TRANSACTIONVALUE,
                        TRANSACTIONCURRENCYID,
                        ORGANIZATIONVALUE
                    )
                    select 
                        sum(AUCTIONITEM.VALUE),
                        AUCTIONITEM.BASECURRENCYID,
                        sum(AUCTIONITEM.TRANSACTIONVALUE),
                        AUCTIONITEM.TRANSACTIONCURRENCYID,
                        sum(AUCTIONITEM.ORGANIZATIONVALUE)
                    from dbo.AUCTIONITEM
                    where AUCTIONITEM.PACKAGEID = @AUCTIONITEMID
                    group by AUCTIONITEM.BASECURRENCYID,AUCTIONITEM.TRANSACTIONCURRENCYID

                end

                return
            end