| If you are unable to view this email, try the online version |
|
|
|
|
| Don't miss out! |
|
These items on your Watch List are only around for one more day!
If you haven't already, register for the auction now – and don't forget to bid. |
|
%%[
IF ROWCOUNT(@watchlistitems) > 6 then
SET @emaillots=6
ELSE SET @emaillots=ROWCOUNT(@watchlistitems)
ENDIF
FOR @rowcount = 1 to @emaillots do
SET @currentlotid = FIELD(ROW(@watchlistitems, @rowcount), "LotId")
SET @lotdetails = ROW(LOOKUPROWS("ent.lotDE", "lotid", @currentlotid), 1)
SET @currentauctionid = FIELD(@lotdetails, "auctionid")
SET @auctiondetails = ROW(LOOKUPROWS("ent.auctionDE", "AuctionId", @currentauctionid), 1)
SET @currentclientid = FIELD(@auctiondetails, "clientId")
SET @clientdetails = LOOKUPROWS("ent.client", "clientId", @currentclientid)
SET @lotnumber = FIELD(@lotdetails, "lotnumber")
SET @lottitle = FIELD(@lotdetails, "title")
if length(@lottitle) > 80 then
set @charcount = length(@lottitle)
for @i = 81 to @charcount do
IF substring(@lottitle, @i, 1) == " " THEN
set @end = @i
set @lottitle = concat(substring(@lottitle,1,subtract(@end,1)), "�")
set @charcount = 0
endif
next @i
endif
SET @auctioneer = FIELD(ROW(@clientdetails, 1), "ClientName")
SET @clienturl = FIELD(ROW(@clientdetails, 1), "urlName")
SET @auctiontitle = FIELD(@auctiondetails, "Title")
SET @auctiontype = FIELD(@auctiondetails, "auctionType")
SET @auctiondate = Format(FIELD(@auctiondetails, "AuctionDateTimeLocal"),"dd/MM/yyyy HH:mm")
SET @timezone = 'BST' /*FIELD(@auctiondetails, "timezone")*/
SET @currency = FIELD(@auctiondetails, "currency")
SET @lowestimate = FIELD(@lotdetails, "lowEstimate")
SET @highestimate = FIELD(@lotdetails, "highEstimate")
SET @lotimage = CONCAT(FIELD(@lotdetails, "firstLotImage"),"540x360.jpg")
SET @loturl = CONCAT("http://www.bidspotter.co.uk/en-gb/auction-catalogues/",@clienturl,"/catalogue-id-",FIELD(@auctiondetails, "auctionreference"),"/lot-",@currentlotid)
]%%
|
|
|
|
Lot %%= v(@lotnumber) =%% - %%= v(@lottitle) =%%
%%[if @auctiontype=="Live" then]%%Starts: %%= v(@auctiondate) =%% %%= v(@timezone) =%%
%%[elseif @auctiontype =="Timed" then]%%Ends From: %%= v(@auctiondate) =%% %%= v(@timezone) =%%
%%[else @auctiontype !="Timed" AND @auctiontype !="Live" then]%%
%%[endif]%%
%%[if not empty(@lowestimate) then]%%
%%[if @lowestimate >0 AND @highestimate >0 then]%%Estimate: %%= Format(@lowestimate,"#,#") =%% - %%= Format(@highestimate,"#,#") =%% %%= v(@currency) =%%
%%[elseif @lowestimate>0 AND @highestimate<=0 then]%%Estimate: %%= Format(@lowestimate,"#,#") =%% %%= v(@currency) =%%
%%[elseif @lowestimate<=0 AND @highestimate>0 then]%%Estimate: %%= Format(@highestimate,"#,#") =%% %%= v(@currency) =%%
%%[else @lowestimate<=0 AND @highestimate<0 then]%%
%%[endif]%%
%%[endif]%% |
|
|
|
|
|
|
|
|
|
|
%%[
NEXT @rowcount
]%%
|
|
|
|
|
|
%%[endif]%%
