Discount calculation function windows
Windows used for managing directory contents:
Entry window
The entry window is used to enter a discount calculation function.
The is opened by the command from the directory context menu.
The window contains the Properties, Query, Filter, Filter settings, Information and Comment panels.
New discount calculation function entry window
Properties panel fields:
-
Name — name of the discount calculation function. Required field.
-
Description — brief description.
A more detailed description can be entered in the Information panel.
Selecting will add the item to the directory and close the entry window. Selecting will close the window without saving the item. Selecting will add the item to the directory without closing the window.
The editor window allows one or more discount calculation functions to be edited.
The editor window is opened by the command in the context menu when one or more discount calculation functions are selected.
Editor window
If one discount calculation function is selected, the editor window will open:
Discount calculation function editor window
The fields and panels are the same as in the window.
Multiple editor window
When two or more discount calculation functions are selected for editing, the multiple editor window will open. It has a panel displaying a list of the selected discount calculation functions and displays only the Properties, Information and Comment panels. The title in the window header is .
Multiple discount calculation functions editor window
When multiple discount functions are selected for editing, any changes that are saved will be applied to all of the selected discount functions.
Query panel in the Discount calculation function window
The Query panel contains the SQL query used to select data for calculating a discount:
Query panel in the discount calculation function entry window
The panel contains a multiline text field for entering an SQL query.
This SQL query is used to select data from the database to calculate a discount. The query is written using .
Example SQL query used for discount calculation
Query panel with SQL query entered
The context menu for the text field in the Query panel contains standard commands for working with text (highlight, copy, paste, etc.) and an additional Test query command. This command is only available when a query has been entered in the field. On execution it tests the query for errors and opens an alert window informing of the outcome.
When testing the query, specify filter setting at each filter step. If the query is completed successfully, the success message will appear.
Success message
If an error occurs, the error message will appear.
Error message
Filter panel in the Discount calculation function window
The Filter panel is used to add filter steps to the discount calculation function. Filtering is used to select the data used to calculate discounts:
Filter panel in the Discount calculation function entry window
Each filter step in the Filter settings panel is displayed as a filter parameter in the Filter panel.
Filter panel with filter parameters
Filter settings panel in the Discount calculation function window
The Filter settings panel is used to add filter steps to the discount calculation function. Filtering is used to select the data used to calculate discounts:
Filter settings panel in the Discount calculation function entry window
Columns in the Filter settings panel data grid:
Name — name of the filter step.
Form class — class of the form to which the filter step corresponds.
Input parameters — parameters passed to the filter before moving on to the next step.
Output parameters — parameters received on completion of the filter step.
Caption — caption text displayed in the filter window.
Header — filter parameter panel header.
Required — whether the filter step is required.
Index — order in which the filter step is carried out relative to other filter steps in the same data grid.
Multi-select — defines whether multiple values can be selected in the filter step.
Empty values — defines whether empty values can be selected in the filter step.
Required selection — whether a selection must be made in the filter step.
The Filter settings panel context menu contains the following commands:
-
— add new filter step.
-
— edit selected filter steps in the filter settings panel.
-
— permanently delete filter steps.
-
— print out.
-
— contains additional commands for working with data grids.
Each filter step in the Filter settings panel is displayed as a filter parameter in the Filter panel.
In the discount calculation function entry window, the filter has not been applied, so all filter setting panes display Not initialised.
Filter panel with filter parameters
The entry window is used to add a new filter step to the Filter settings panel. The window is used for editing.
The permanent delete confirmation prompt is used when deleting filter steps from the Filter settings panel.
Information panel in the Discount calculation function window
The Information panel contains a multiline text field for entering arbitrary information about the discount calculation function.
