I have an idea how this could work, I'd just like it confirmed:
- In one of my apps (for HR), I display the presence/ absence of employees in the different areas of my company.
=> Every employee is assigned to a certain area according to his "personell_unit" (a numerical value)
=> The structure is like this:
- 1 - company
- 11 - operative emps
- 111 - packing staff
- 1111 - packing staff shift 1
- 1112 - packing staff shift 2
=> Acc. to the hierarchical structure in our database, an employee would then have four records as he belongs to all of the above areas.
=> I don't want this, so in the script I aggregate the table and take only the largest numerical value -> thus, this employee will end up with only one record "1111" - he/she belongs to "packing staff shift 1" (or "1112" for "packing staff shift 2")
[the area labels come from a mapping table as the database table has just the key numeric values]
=> Now I'd like to have a possibility of displaying the
>>> sum of "packing staff shift 1" and "packing staff shift 2" <<<
I think I could make that by just inserting two new lines in my mapping table, assigning both the keys "1111" and "1112" to a label "packing staff" (since I don't have 111 anymore) and making one more field in my data table labeled "both_shifts" or so.
Will that work in your opinion? - Bearing in mind that there are areas without shifts - for those, the new field would just be identical to the first one.
(As always, I will try it out myself, but I'm a bit pressed as this app is supposed to be presented tomorrow)
