Procedure
- Set up Configure online data collectiongathering. For more details see article: Configuring POS servers online data collection. Check on the reports that the Online Data Gathering article. Check if there is data on the open shift .in the reports.
- Go to Options > Customization > Extended properties and In the "Settings - Settings - Extended properties" directory create extended properties for the restaurant, :
- Click on three dots
in the
- end of
- Click on three dots
Figure 1. Extended properties
...
- the Types List line
- Click the Add reference to Item button
Select the Restaurant on the Class Infos tab and click OK.
Info The system name of all extended properties, except IPAddress, can be arbitrary
...
. It is only necessary to know
...
the extended properties
...
ID
...
.
...
The specified extended properties
...
of the restaurant:
Amend the script (\custhtml\sql\script.
sqlsql from archive 1):
...
Code Block language sql firstline 1 SET @COUNTFIELD = 1000016; --RESTAURANT'S CHECK COUNT PLAN EXTRA FIELD;
...
;; Monhly plan of checks SET @AMOUNTFIELD = 1000013; --RESTAURANT'S AMOUNT PLAN EXTRA FIELD; ;; Monthly plan
...
of revenue SET @FOODCLASS = 2 * 256;--CHOSEN FOOD CLASSIFICATION (POTATO/ICECREAM); ;;
...
Dishes classification id. In our example, it is 512. Specify only in the form 256 * Х, where Х = dishes classification id / 256 SET @FOODCAT1 = @FOODCLASS + 1; ;; id of category # 1 in classification SET @FOODCAT2 = @FOODCLASS + 2; ;; id of category # 2 in calssification SET @FOODCAT3 = @FOODCLASS + 3; ;; id of category # 3 in classification SET @FOODCAT4 = @FOODCLASS + 4; ;; id of category # 4 in classification SET @FOODCAT5 = @FOODCLASS + 5; ;; id of category # 5 in 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 № 5Note title Important At
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
...
the moment, the script is unique for each database, since it is necessary to specify the IDs of categories and extended properties from the
...
r_keeper 7 manager station in the scripts.
Execute
the scriptscript.sql
onfor the current SQL
-database (usingdatabase. We recommend to use SQL Management Studio
is recommended);.
Note title Important
...
After executing
...
script.sql
...
, be sure to execute the
...
RK7SQLPROC_REP_CALC stored procedure. This procedure should be added to the scheduler and run every time after the
...
common shift is closed.
...
- In the properties of the reference (reports) server, specify manager station, go to Options > OLAP reports > Reporting servers and 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
- in the reference or report server properties. Restart the server to apply the changes.
- Open the manager station and fill in the IPAddressextended propertyIn the manager station, fill in the extended property IPAddress, which contains the IP address of the report server (. In this way you can change the address of the server);.
- In the folder with the report server .exe file, a folder /custhtmlis created, into which files from archive 1are placed (create the /custhtml folder and place the files from archive 1 to it, except for the folder with scripts);
In
A script is created inthe manager station,
which is bound to a custom operation, which in turn isthe script should be created. This script is linked to the user operation, bound to a button,
the buttonwhich is
postedadded to the selector;
The script is as follows:
...
Code Block language delphi firstline 1 procedure ProcessOperation1000489(Parameter:
...
integer);
...
var
...
s:string;
...
begin
...
begin s:= TRK7Restaurant(RK7.CashGroup.MainParent).genIPAddress;
...
GUI.CmdExec('fsWeb2.exe "https://'+s+':8081/custhtml/overall1.html"');
...
end;
...
- Copy the fsWeb2.exe and *.dll files from archive 2;
- By When clicking on the created button at the checkoutcash station, fsweb2.exe is launched, which demonstrates the reports.
Figure 6. Example of how reports work
...
Attached Files
...