| Deletions are marked like this. | Additions are marked like this. |
| Line 10: | Line 10: |
| Separate '''[[Classifications]]''' record will be used for every classification which is set. |
Separate '''[[Classifications]]''' records are used for every classification which is set. No empty records used, a document has as many '''[[Classifications]]''' records as many classifications are set. === Detail === No problems determined until now. A smarty loop goes through all '''[[Classifications]]''' records to display them line to line. === New/Update === For '''every''' aspects defined in table '''[[Aspects]]''' at least one line appears even if it is empty. At the right side of all line there is a ''new'' button to open additional line for entering classification in the same aspect, and a ''delete'' button to remove that classification. If there is no more classification in an aspect (after deleting the last one) an empty line appears. === Search === === List === |
MultiClassification
Requirements
- unlimited number of classifications for one document (task)
- unlimited number of assigned aspect values in one aspect
Solution
Separate Classifications records are used for every classification which is set. No empty records used, a document has as many Classifications records as many classifications are set.
Detail
No problems determined until now. A smarty loop goes through all Classifications records to display them line to line.
New/Update
For every aspects defined in table Aspects at least one line appears even if it is empty. At the right side of all line there is a new button to open additional line for entering classification in the same aspect, and a delete button to remove that classification. If there is no more classification in an aspect (after deleting the last one) an empty line appears.
Search
List
For performance tuning static database table will be used to store some information of classified documents:
drawingId |
aspect 0 |
... |
|||||
|
min code |
max code |
full code |
count |
from |
to |
... |