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'"