Posflow
1
I get the column fields just fine but I cant wrap my head around how to format it in HTML print template.
-- ---------------------------------
-- Output column values
-- ---------------------------------
{REPORT SQL DETAILS:@@GetStatement;{ENTITY NAME},1:F.Date,F.Time,F.BillNo,F.Description,F.Amount:
<div style="margin-left:20px;margin-right:20px;font-size:12px;background-color:black;color:white;font-weight:bold;font-family:'Calibri'">
<table>
<tr>
<td width=15* align=left>{0}</td>
<td width=15* align=left>{1}</td>
<td width=20* align=right>{2}</td>
<td width=30* align=right>{3}</td>
<td width=20* align=right>{4}</td>
</tr>
</table>
</div>
}
Jesse
4
Here is an example for you. As you can see there is a lot of escaping that needs to be done.
[LAYOUT]
<EC>
-- Alternative logo method
-- <img src="C:\Users\josep\Documents\SambaPOS5\plogo.png">
<div style="font-size:28px;text-align:center;font-weight:bold;font-family:'Helvetica'">Fox Creek BBQ & Catering</div>
<div style="font-size:20px;text-align:center;font-family:'Calibri'">129 Lawrence St.<br>Batesville, AR 72501<br>(870) 698-0034</div>
{REPORT SQL DETAILS:SELECT TOP 1 [Id]
,jsonData.[pdauth_code]
,jsonData.[pdCardholder]
,jsonData.[pdCardBrand]
,jsonData.[pdAccount]
,jsonData.[pdTransactionID]
,jsonData.[pdentry_mode]
,[Date]
,[Amount]
,[Name]
,Format([Date],'hh.mm tt') as Time
FROM [Payments] p
CROSS APPLY OPENJSON(p.[PaymentData])
-- this WITH portion allows explicit definition of the schema JSON Keys for output
-- and gives references to the columns/fields above in the SELECT portion
-- we can also use these as filters in the WHERE clause below
WITH (
pdTransactionID varchar(1000) '$.TransactionID'
,pdauth_code varchar(1000) '$.auth_code'
,pdCardholder varchar(1000) '$.Cardholder'
,pdCardBrand varchar(1000) '$.CardBrand'
,pdAccount varchar(1000) '$.Account'
,pdTransactionID varchar(1000) '$.TransactionID'
,pdentry_mode varchar(1000) '$.entry_mode'
) jsonData
WHERE 1=1
AND [Name]='Credit Card'
AND [TicketID]='@1'
ORDER BY [Id] desc
;{TICKET ID}
:F.Date
,F.Amount
,F.Id
,F.pdauth_code
,F.pdCardholder
,F.pdCardBrand
,F.pdAccount
,F.Time
,F.pdTransactionID
,F.pdentry_mode::
<div style="font-size\:10px;font-weight\:bold;margin\:20 10 0 20;text-align\:justify;font-family\:'Calibri'">
<table>
<tr>
<td align="left">Acct\: **** **** **** [='{6}'.substr(12,4)]<br />MerchId\: ****8881 <br />TransId\: {8}<br />Auth Code\: {3}<br />Card Type\: {5}</td><td align="right">{0}<br />{7}<br/> Server\: {USER NAME}<br />Pay ID\: {2}<br /> Entry Mode\: {9}</td>
</tr>
<tr>
<td align="left"><br /><span style="font-size\:13px;">Non Cash Adj\:</span></td><td align="right"><Br /><span style="font-size\:13px;">${CALCULATION TOTAL:Non Cash Adjustment}</span></td></tr>
<td align="right"><br /><span style="font-size\:22px;">Sale (USD)\:</span></td><td align="right"><Br /><span style="font-size\:22px;"> ${1}</span></td>
</tr>
<tr>
<td align="left"><br /></td><td align="right"><span style="font-size\:22px;"><br />+ Tip\:</span><span style="font-size\: 9pt"> _________</span></td>
</tr>
<tr>
<td align="left"><br /></td><td align="right"><span style="font-size\:22px;"><br />Total\:</span><span style="font-size\: 9pt"> _________</span></td>
</tr>
</table>
</div>
</div>
<div style="font-size\:15px;font-weight\:normal;text-align\:center;font-family\:'Calibri'">
<table>
<tr>
<td><span style="font-size\: 9pt"><Br />I agree to pay the above total amount <br>according to the card issuer agreement.<br />(Merchant Agreement if Credit Voucher)</span></td>
</tr>
<tr><td>‌</td>
</tr>
</tr>
<tr><td>X____________________________
<br /><span style="font-size\: 9pt">{4}</span>
<br /><span style="font-size\: 11pt"><b>Suggested Tip Amount</b></span>
<span style="font-size\: 10pt"> 18% = <b>$[=F(Math.round((TN('{1}') * 0.18)*100)/100,'0.00')]</b> Total <b>$[=F(Math.round((TN('{1}') * 0.18)*100)/100+{1},'0.00')]</b><br /> 20% = <b>$[=F(Math.round((TN('{1}') * 0.20)*100)/100,'0.00')]</b> Total <b>$[=F(Math.round((TN('{1}') * 0.20)*100)/100+{1},'0.00')]</b><br /> 22% = <b>$[=F(Math.round((TN('{1}') * 0.22)*100)/100,'0.00')]</b> Total <b>$[=F(Math.round((TN('{1}') * 0.22)*100)/100+{1},'0.00')]</b><br /> 25% = <b>$[=F(Math.round((TN('{1}') * 0.25)*100)/100,'0.00')]</b> Total <b>$[=F(Math.round((TN('{1}') * 0.25)*100)/100+{1},'0.00')]</b></span>
</td>
</tr>
</table>
</div>
<div style="font-size\:15px;font-weight\:normal;text-align\:center;font-family\:'Calibri'">
<L00>{2}
</div>
<EC>
<BAR>{2}
<div style="font-size\:15px;font-weight\:normal;text-align\:center;font-family\:'Calibri'">
<table>
<tr>
<td><span style="font-size\: 8pt"><br /><br /><Br /><Br />powered by</span><span style="font-size\: 12pt"> Samba<b>POS</b></span></td>
</tr>
</table
</div>
}
3 Likes
Jesse
5
Pretty much every colon in the html needs escaped if its used inside the report tag. It looks like you were close to figuring it out.
1 Like
Looks great, thank you all!
I sorted the order by - after taking the photo 
