Program reports

Home Topic  Previous Topic  Next Topic  Print this Topic

This chapter of manual describes the most important part of server program - reports. Internet cafe owner can be sure that operators don't cheat and he earns maximal profits.

 

To observe reports, you should start the "Reports" program:

 

Start->Programs->Internet Cafe->Reports
Or simply find and execute LOG3View.exe in the program installation directory
You can press any "Statistics" button of indicators or "All statistics for today" or  "Main report" - all these buttons open the same program, but show different reports. You can switch between reports.

 

You can also open many copies of "Reports" program.

 

After starting Reports program, it can ask you a password (if it was set in security settings).

 

rep-stat-all

 

Window title shows up a Reports program version. It is important to use the latest version as we consistently improve it, fix errors.

 

Below title you see: "Statistics::All computers::Current work shift (Ruslan, 2018-04-05 10:48:14)". Means current report type is "Statistics", time interval is "Current work shift", operator name is "Ruslan",

working shift start "April, 5 2018 10:48".

 

Just below is a rectangular area that contains data for selected report type. In this case "Statistics".

 

Look even below. To the left is an area where you can select time interval for current report. In this case it is "Current work shift". Date of work shift start (2018.04.05 10:48 and finish - year 2100.04.05). As we don't know when work shift will finish, the year is 2100.

If you choose "Select work shift", you will be proposed to view the previous work shifts. "Current day" mode shows you the report for the current day. "All time" - shows you from year 1900 to 2100. "Select time interval" allows entering the begin and end of the interval.

 

To the right you can see a report type selection drop box. It currently shows "Statistics". To the right of it is report filter. In this case "Full". We will review each report later in this chapter.

 

"All computers" drop box allows switching filtering by specific client computer or all computers.

 

"Refresh" button just updates the latest data (if server program is running in parallel it keeps creating new records).

 

Right part contains "Tools" button:

 

rep-service-menu

 

This menu allows you to delete/truncate reports and do a backup actions.

 

When selecting "Delete database":

 

rep-clean

 

Pressing first button will delete all the data and reset program to "factory defaults". Be careful!

It is often our customers study how to operate with server program, then "Delete all database" and start working from scratch using "clean environment".

 

Selecting "Delete old work shifts" allows you to select interval of work shifts that you would like to delete (when they are not needed anymore).

 

Selecting "Database backup" shows you:

 

rep-backup

 

This menu allow you to save and restore reports as backup. Pay attention: when restoring reports - old data is deleted. Reports are saved in a single file with .l3z extension. The name of the file and created from current date and time.

 

Selecting "Report protection" shows a message that these settings were moved to security settings.

 

"Export" button allows to save current report to text file.

 

"Print" button will print the current report, you can also use "CTRL+P" shortcut.

 

Now we will review each report separate in details:

 

Statistics

 

rep-stat-all

 

Statistics is a full log of operator actions (operations) for the given period of time. You can observe it per specific computer or for all of them.To the right of report type you can find a drop box for switching statistics mode (or filter): full, financial, technical, free time, connection with clients, notes is report, security, regular client.

 

You can quick access the statistics for all computers using "All statistics for today" button of server program. Statistics for particular computer can be accessed by using "Statistics" button of each server program indicator.

 

Left column of statistics report is called ID. Each record of report receives the number in the order, i.e. ID. Each next record should have the +1 number, without skips. Program database is robust against crashes and intrusions from hackers so it likely impossible to corrupt the above order because of computer fault. Breaking the ID order can mean that operator did it on purpose.

 

Next column is "Operation date/time". Each record of report has time stamp. As you recall, it is strictly forbidden for operator to change the system clock of computer. It is our program requirement.

 

Last column "operation description" contains the description for that record.

 

Statistics allows cafe owner to investigate the operator(s) actions in details for the any time interval, for all computers or selected. As there are a lot of records, use statistics filter (currently "Full") to focus on something specific. For example, you are interested in records that describe free of charge time usage. Choose "free time" filter.

 

Statistics report has the following hotkeys: to choose computer, type its number keeping CTRL button pressed (may not work in windows 10).

For example: CTRL-3, CTRL-0 will select computer 30. CTRL-0 will select ALL computers.

To choose statistics filter, press CTRL + one of the buttons Q, W, E, R, T, Y, U, I.

 

Main report

 

report-main-mix copy

 

Main report shows you financial table for (earned money for a given period). You can see sums by each client computer, total. Separately for games and Internet, night mode of payment.

 

The table contains of the following columns:

computer number (1-12)
"Time", "Sum", "Night" related to games and Internet

 

"Time" - show you the total amount of time customers spent on that client computer

"Sum" - the amount of cash you earned

"Night" - the amount of cash earned using night and half-night mode.

 

"Total" column is a sum of earned cash for that row.

 

Below the table:

 

"Services" - amount of cash earned from additional services (POS). I.e. coffee, hamburgers, printing, writng cd's.
"Issued" - if cafe owner took some amount of money from cashbox in the middle of working shift.
"Total" - current remaining amount of money in cashbox.

 

"No link" shows how long "hours:minutes" there were no connection with given client computer. As we already mentioned, for cafe owner it probably means that client computer was without control, how long and it is possible cheat by operator. The total amount of time without connection (link) should be reasonably small.

 

 

In case operator started free of charge time (payment sum is 0), "Free" column will show total time that was spend without payment. It also accumulates invalidated operations (i.e. free of charge).

 

 

Security report

 

report-secur-mix copy

 

One of the most important reports for cafe owner. Operators don't nee to observe it and you can prohibit it in security settings.

 

Each row contains of two columns: description and value. Lets review each:

 

"Corrupted records" - number of corrupted records for the given period of time. Reports contain of records. Theoretically record can be corrupted because of computer fault or because of operator cheat. The smaller number (ideally 0), the fair operator work on you.

 

"Invalid ID" - we've described about that each record has its unique number (ID). Each next record has a number plus one. If the order is different, the number of "invalid ID's" growing up. Should be 0. In case it is not 0, operators are probably cheat.

 

"Lost ID" - as ID's are sequentially added to records, there should be no passes. I.e. right after ID = 243 should be ID = 244, but not 245 or 246. Breaking this rule, increases that security parameter. The smaller this number, the fair operations are happen in your cafe. It should be 0. If it is grows up, operators probably cheat.

 

"Lost 5 minute labels" - simple method to be sure that server program is started and running. Each 5 minutes server program does a special record "I'm working, current time is the following...". I.e. if operator will cheat by disabling server program, this parameter will start growing up. Switching off server program for one hour will increase this parameter by 12 (program didn't save these labels each 5 minutes during the hour 12 times). Server computer reboot will also grow up this parameter. Cafe owner should trust those operators who have the smallest number of that parameter.

 

Further two parameter about changing system clock back. One of the possible cheats that unfair operators try to use to corrupt the report. They think that it is possible to prolong the time for customers and put the cash to their pocket instead of cashbox. System clock on server computer should not be changed, we mentioned about it several times. After adding that parameter, operators started to close server program, change system clock and start it again. Such cheat are shown up in "Hidden changing of system clock back". Cafe owner, please watch for these params. You should have them as 0.

 

 

"Rough mismatches". Reports program analyzes report and tries to find mismatches. What is that? For example, statistics have "Stop pressed". Then "Stop pressed" again. It should not happen as you can't Stop time twice. There likely was a "Start" between (with payment details) that was corrupted on purpose. Such cases are calculated and shown here. It should be zero. If not zero, the operator probably cheats. There is a special report that decodes each mismatch.

 

Below you can see lists of user tariffs (prices), discounts, "free time to customize PC", total time spent on client computer customizations. Do check these numbers so they correspond what should be used in your cafe.

 

"Control of the printers: printed pages". In case you use printers control, this line shows the amount of printed black-white and color pages.

 

"Rough mismatches" report

 

report-grub-mix

 

This report should normally be empty, but if you have some records it can mean that operator tries to cheat. We've described above what is "rough mismatches"

 

 

Missing 5 min labels report

 

report-5min-mix

 

 

This report describes "5 min labels" that were lost by some reason. We've described them above in security report. You can find the time intervals when these labels were lost. In this case 22:52 to 23:57 there are 12 missing labels. Server program

was disabled for 1 hour by some reason. One more lost between 22:20 and 22:27, probably it was a server computer reboot.

 

"Operation changes" report

 

indmenu-chop-report-ch

 

"Operation changes" report. It is possible to change last operation in case of possible error. Unfair operators can use it. For example, customer paid for 1 hour of work in Internet, paid $5. Customer finishes work. Minute before the end of his session, operator changes last operation to games ($3 per hour) and gets the difference to his pocket. To avoid this cheat, it was decided to explicitly log all operation changes. More details about it in"change operation control".

 

"Tariffs, discounts, time for customization" report

 

report-prices-mix

 

The report shows you lists of tariffs, discounts and free time for customization for the given period of time. First time is by hours, second by computers.

 

Why do you need it. In case your cafe has fixed tariffs (depending or not depending) from time of the day, using that table you can check what tariffs were used at given time of day. If you allow using specific discounts (for example, for regular clients), the table should not have any other numbers. The same for free time for customization.

 

"Additional services (POS)" report

 

report-serv-mix

 

The report shows additional services (POS). Service name column, in square brackets has a price of 1 piece. Read more about setting up additional services (POS items) in work with indicators.

 

"Used IP-packet filters" report

 

report-filter-mix

 

Warning, it is legacy functionality. Nowadays almost nobody configures client computers to not have the access to Internet in games mode. You likely will skip reading this manual chapter.

 

Useful report for (Windows XP/2003/Vista) for those who use Network filter. Allows to control used IP-packet network filters so nobody changed them by mistake or intentionally. As soon as you have configured it for each client computer (set of filtering rules), CRC (checksum) is calculated for it (8 characters). In case all client computers use the same rules, the checksum will also be the same. Changing rules, changes checksum. The report allows to see all used checksums. Other words, how many different lists was in use.

 

Report should have the same checksum for each client computer. Nowadays you like to not use this report and should be empty.

 

"Used client processes" report

 

report-prop-all

 

The reports shows what programs (processes) were in use by customers, when and in what computers. First column shows date/time, second - computer number, third - path to executable.

 

You can show popularity rating of programs used by customers. Choose "Popularity rating" instead of "All":

 

report-prop-rating

 

That report shows 2 columns. First shows the duration of using program - days/hours:minutes:seconds. Second - path to executable of process (program). Pay attention that you can view this report per all computers and by selected one, for the current work shift or for any time interval. For example, you can find the most popular games used in previous month.

 

Just below the process names there is a histogram of usage of given process (program). It allows you to visually estimate which are used more often (their popularity rating).

 

Continue to "Work with regular clients".


Rambler's Top100