Procedure

1. Set up online data collection. For more details see article: Configuring POS servers online data collection. Check on the reports that there is data on the open shift.
2. In the "Settings - Settings - Extended properties" directory create extended properties for the restaurant, in the "List of Types: System -> Restaurant" property:

Figure 1. Extended properties

Note: the system name of all extended properties, except IPAddress, can be arbitrary, the main thing is to know the ID of the extended properties.

Note: the system name of all extended properties, except IPAddress, can be arbitrary, the main thing is to know the ID of the extended properties.

Figure 2. Filled in extended properties at the restaurant

1. Amend script (\custhtml\sql\script.sqlfrom archive 1):

SET @COUNTFIELD = 1000016; --RESTAURANT'S CHECK COUNT PLAN EXTRA FIELD;;; Plan for a receipt month

SET @AMOUNT FIELD = 1000013; --RESTAURANT'S AMOUNT PLAN EXTRA FIELD;;; Monthly plan revenue

SET @FOODCLASS = 2 * 256;--CHOSEN FOOD CLASSIFICATION (POTATO/ICECREAM);;; id of the food classification. in our example, 512. we write strictly in the form of 256 * X, where X = id of the classification of dishes / 256

SET @FOODCAT1 = @FOODCLASS + 1;;; id of category # 1 in the classification

SET @FOODCAT2 = @FOODCLASS + 2;;; id of category # 2 in the classification

SET @FOODCAT3 = @FOODCLASS + 3;;; id of category # 3 in the classification

SET @FOODCAT4 = @FOODCLASS + 4;;; category id # 4 in the classification

SET @FOODCAT5 = @FOODCLASS + 5;;; id of category # 5 in the classification

SET @FOODFIELD1 = 1000014;;; Plan for category # 1

SET @FOODFIELD2 = 1000015;;; Plan for category # 2

SET @FOODFIELD3 = 1000018;;; Plan for category # 3

SET @FOODFIELD4 = 1000019;;; Plan for category # 4

SET @FOODFIELD5 = 1000020;;; Plan for category # 5

Important: at the moment, the script is unique for each database, since it is necessary to specify the IDs of categories and extended properties from the RK7 management station in the scripts.

1. Execute the script script.sql on the current SQL-database (using SQL Management Studio is recommended);

Important: after executing the script. sql script, be sure to execute the stored procedure RK7SQLPROC_REP_CALC. This procedure should be added to the scheduler and run every time after the general shift is closed.

Figure 3. Executing a stored procedure

1. In the properties of the reference (reports) server, specify the HTTP port and address (the "Settings - OLAP reports - Report servers" reference book in the "HTTP Server" section).

Note: it is recommended to read the article http://tracker.ucs.ru:8080/redmine/projects/-helpdesk-/wiki/R-keeper-7-xmlinterface-ru.

Figure 4. HTTP Port of the directory/report server

1. In the manager station, fill in the extended property IPAddress, which contains the IP address of the report server (this way you can change the address of the server);
2. In the folder with the report server exe file, a folder /custhtmlis created, into which files from archive 1are placed (except for the folder with scripts);
3. A script is created in the manager station, which is bound to a custom operation, which in turn is bound to a button, the button is posted to the selector;

The script is:

procedure ProcessOperation1000489(Parameter: integer);

var

s:string;

begin

s:= TRK7Restaurant(RK7.CashGroup.MainParent).genIPAddress;

GUI.CmdExec('fsWeb2.exe "https://'+s+':8081/custhtml/overall1.html"');

end;

Figure 5. Startup script fsWeb2.exe

1. Copy the fsWeb2.exe and *.dll files from archive 2;
2. By clicking on the created button at the checkout, fsweb2.exe is launched, which demonstrates the reports.

Figure 6. Example of how reports work

ATTACHMENT FILES:

custhtml.7z

fsweb2.7z

 Adding VAT fields to the food consumption cube  Creating a new fact in a cube