Page History

Procedure

1. Configure online data gathering.  Check on the reports that For more details see the Online Data Gathering article. Check if there is data on the open shift in the reports.
2. Go to Options > Customization > Extended properties and create extended properties for the restaurant, :
   Image Added
   
   1. Click on three dots Image Addedin the
   "List
   1. end of
   Types: System -> Restaurant" property:
   Note: the
   1. the Types List line
   2. Click the Add reference to Item button

   3. Select the Restaurant on the Class Infos tab and click OK.
      Image Added

      Info
      The system name of all extended properties, except IPAddress, can be arbitrary

   , the main thing is

   1. . It is only necessary to know the

   ID of the

   1. extended properties ID.

   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.

   1. The specified extended properties of the restaurant:
      Image Added

3. Amend the

   Amend

   script (\custhtml\sql\script.

   sql

   sql from archive 1):

   Code Block
   language sql firstline 1

   Important: at

   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 № 5

   
   

   Note
   title 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

   r_keeper 7 manager station in the scripts.

   
   

4. Execute

   the

   script

   script

   .sql

   on

   for the current SQL

   -database (using

   database. We recommend to use SQL Management Studio

   is recommended);

   .

   Note
   title Important

   : after

   After executing

   the

   script.sql

   script

   , be sure to execute the

   stored procedure

   RK7SQLPROC_REP_CALC stored procedure. This procedure should be added to the scheduler and run every time after the

   general

   common shift is closed.

   Figure 3. Executing a stored procedure

   Image Added

5. 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 serverin the reference or report server properties. Restart the server to apply the changes.
   Image Added
6. 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);.
7. 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);

8. In

   A script is created in

   the manager station,

   which is bound to a custom operation, which in turn is

   the script should be created. This script is linked to the user operation, bound to a button,

   the button

   which is

   posted

   added to the selector;
   The script is as follows:

   
   Figure 5. Startup script fsWeb2.exe

   Code Block
   language delphi firstline 1
   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;

   
   

9. Copy the fsWeb2.exe and *.dll files from archive 2;
10. 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

ATTACHMENT FILES:

Attached Files

1. custhtml.7z
2. fsweb2.7z

...