Table of Contents
Locking model
Main goal: not add new records with dates inside the locked period.
New invoice or cost date never keep into the locking period.
For example, if the invoice_date can be Mar 29, and the Match is locked – FDM will calculate next unlocking date – Apr 1.
The table "Lockes"
| Field | Description | Example |
| year | The year of the locked period | 2011 |
| month | The month number (1..12) of the locked period | 3 |
| locked | The locking state (0..1) | 1 |
Primary keys is year + month.
The table is controlled by forms Lock Month and Lock Month Edit.
Locking in the Cost Edit form
Cost records contain the invoice date and the payment date.
For the locking model important date is invoice date.
Known locking states:
| Locked | Date processing |
| 0 | Any changes in the record are allowing, on submit FDM will calculate nearest date in the unlocking period. |
| 1 | No changes allowed. User with unlocking rights can unlock the record. |
Locking in the Box Office Edit form
Box office records are binded by SQL with invoices table that contains the invoice date.
For the locking model important date is invoice date.
Known locking states:
| Locked | Date processing |
| 0 | Any changes in the record are allowing, on submit FDM will calculate nearest date in the unlocking period. If the record is not complete – FDM calculate invoiced date as start date + 7 |
| 1 | No changes allowed. User with unlocking rights can unlock the record. |
Here's is the locking model is simpler – after unlock user can change the invoice date, it'll be calculated based on the Lockes table.
“Complete” is not checked – means the record is not finished. Not all days of week are filled by numbers. Everyday user can add more or edit other days. And when user will finished – he can check the box “Complete”.
“Locked” – if not checked, user can check it, and the form will become locked. And only proved user will can unlock it.
Locking in the Flat Edit form
The form is simpler than box office edit. And it's working similar to box office edit form.
Locking in Inserting forms
Inserting forms are box office, flat sale, cost.
If the invoice date is in the locked period – FDM calculated it into the nearest unlocked period. Therefore any new record will never be in old reports that were printed in past.
This is the locking goal.