Caller id - CID POP

🍎SambaPOS V5
1

image

image
image410×508 11.2 KB 

<b>{ENTITY NAME}</b><linebreak/>{ENTITY DATA:Telefon}<linebreak/>{ENTITY DATA:Adres}
    Son Sipariş Bilgileri<br/>
{REPORT SQL DETAILS:SELECT TOP (1)  Tickets.Date "Tarih", Tickets.TotalAmount "Tutar", TicketEntities.Ticket_Id "Id", CASE WHEN IsClosed = 0 THEN '<color red>Ödenmedi</color>' ELSE '<color green>Ödendi</color>' END  "Durum" FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('{ENTITY NAME}') ORDER BY TicketEntities.Ticket_Id DESC:FD([F.Tarih], 'dd.MM.yyyy HH\:mm\:ss'),F.Tutar,F.Id,F.Durum::ID\:  <b>{2}</b>   -   Tutar\:  <b>{1}</b><br/>Tarih\: <b>{0}</b> - {3}}
5 Likes