I’ll be a little busy for next two days so I might not respond some issues immediately. Don’t forget backups and you can safely downgrade to 4.1.61 if you notice an issue.
Hello. Sorry for that brief explanation. Tomorrow I’ll fly back at home and I’ll write more detailed explanation especially for custom reports.
###Custom keyboard for rule queries.
We’ve recently implemented numeric keyboard for query dialogs. On this release you’ll be able to configure a custom keyboard set if your setting contains N flag. For query settings after flags section add one more section to configure custom keyboard. Default setting is 49,50,51|52,53,54|55,56,57|8,48,13. Pipe splits rows and these numbers are ascii key codes of keys. Use 0 for blank buttons.
###Pivot Tables
Use a ! symbol before table name to convert a custom report table to a pivot table.
This is a sample template.
[!Tickets:2,2,2,3, 2, 2, 2, 2]
>Number|Date|Time|Table|Discount|[C]Cash|[C]Credit Card|[C]Amount
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Table,CA.Discount,PA.Cash,PA.Credit Card,TN.TotalAmount:(DE=Restaurant) AND (TY=Ticket)}
For pivot tables we need to know if a value is Currency, Number or string. [C] section on Cash, Credit Card and Amount headers defines these columns as currencies. Use N for quantities.
####Abbreviations
You’ll notice we’re using some abbreviations such as EN, CA. Here is a list of them.
EN: Entity Name
EC: Entity Custom Field
TS: Ticket State
TT: Ticket Tag
CA: Calculation
PA: Payment
T.x A ticket database value named as x. For example. T.TotalAmount is TotalAmount field value. As TotalAmount is a numeric value we can use TN instead of T to format it better.
###New Custom Report Tags
{REPORT ORDER DETAILS:X}
{REPORT ORDER COUNT:X}
{REPORT ORDER TOTAL:X}
{REPORT PAYMENT DETAILS:X}
{REPORT PAYMENT COUNT:X}
{REPORT PAYMENT TOTAL:X}
{REPORT CALCULATION DETAILS:X}
{REPORT CALCULATION COUNT:X}
{REPORT CALCULATION TOTAL:X}
{REPORT TICKET DETAILS:X}
{REPORT TICKET TOTAL:X}
{REPORT TICKET PAYMENT TOTAL:X}
{REPORT TICKET CALCULATION TOTAL:X}
{REPORT TICKET COUNT:X}
X is <expression> for Totals and Counts. <fields>:<expression> for Detail tags. Expression syntax is (<Field>=<Value>) or (<Field>.<SubField>=<Value>). In our sample template (DE=Restaurant) means we’ll list tickets where department name is restaurant or (TS.Status=Paid) returns paid tickets. I’ve listed fields on previous section. Here is a list of expression abbreviations.
EN Ticket.Entity Name Equals
ENC Ticket.Entity Name Contains
EC Ticket.Custom Field Equals
ECC Ticket.Custom Field Contains
TU Ticket.User
DE Ticket.Department
TE Ticket.Terminal
TY Ticket.TicketType
PA Ticket.Payment
CA Ticket.Calculation
TT Ticket.Ticket Tag
TS Ticket.Ticket State
OT Order.Order Tag
OS Order.Order State
OU Order.User
MT Order.MenuItem.Custom Tag
MG Order.MenuItem.Group
PT Payment.Payment Type
CT Calculation.Calculation Type
###Activation Warnings
SambaPOS will display warnings if there are modules that needs activation.
###Other Fixes
This release also contains fixes for some reported issues.
