Reports


ClubControl has several types of reports – txt reports, CSV exported report, and html reports from templates.
Reports generates from loaded to Clubcontrol server data. If you generate report in work time, only current session will come into report. To see reports for other days, use FILE – OPEN menu, or VIEW – STATISTICS CLUB - LOAD PERIOD.

HTML report generates from templates, located in ReportTemplates folder in installed server part folder. You can easily edit templates from any HTML editor.

Variables :

%DateStart
%DateStop
%TimeTotal
%MoneyTotal
%MoneyReserved
%HourCostAvgTotal
%TrafficTotal
%CurrentAdmin
%CurrentTime
%MoneyReturned
%ServicesSummary
%PagesPrinted

Tables :

%ComputersSummaryTable - computers summery
%TariffsSummaryTable - tariffs summery
%AdminsSummaryTable - stuff summery

Formulas :

Money for defined time:
%MoneyTo, ‹h:m›
(Example "%MoneyTo, 22:00")

Used traffic for defined time:
%TrafficTo, ‹h:m›
(Example "%TrafficTo, 17:30")

%UserTimePcs,‹h:m›-‹h-m›,‹m-m›,%UserTimePcs
(Example "%UserTimePcs,8:00-13:00,0-59 %UserTimePcs") – number of defined length sessions ‹m-m› sold for period ‹h:m›

%UserTime,‹h-m›-‹h-m›,‹tariff› %UserTime
(Example "%UserTime,8:00-23:00,Game %UserTime") – sessions for period ‹h-m›-‹h-m› with tariff ‹tariff›



Tables :

‹table› {[‹param› ]}›

replace ‹table› with:
CC_TABLE_OTHERTIMES or
CC_TABLE_TIMES or
CC_TABLE_RESERVEDTIMES or
CC_TABLE_DELETEDTIMES or
CC_TABLE_RETURNS or
CC_TABLE_SERVICES or
CC_TABLE_STATES (this table is without parameters)

Replace ‹param› with:
comp
start
stop
sold
check
cost
price
sold
card
flags
Traffic
TrafficLimit
Admin
Tariff
User
LogAccel
MovedFrom
MovedTo
Note
NoteSys
Discount
len
Group

 

You can use several params, separated by blank.

Example:
"‹CC_TABLE_TIMES comp Check Cost start stop len Tariff Admin TrafficLimit Traffic Note NoteSys›"
or small table:
"‹CC_TABLE_TIMES comp Cost›"