Site Content Structure - advice requested
PHP knowledge: expert
Drupal knowledge: new new newbie :)
I need some advice on how best to set up content structure on a site. I could do this in pure PHP but we're wanting the expandability that Drupal offers for possible future enhancements.
The site is for reporting the number of people in a zone. There are (and always will be) 80 zones.
Users belong to districts-40 districts (may grow/shrink).
A district may have one or more zones, and a zone may belong to one or more districts.
I guess think like district=city, zone=zipcode, tho they aren't that, but both districts and zones are geographic areas that we'd like to show on a map.
I want a User to be able to log on, and go to the update screen for their district.
The screen shows 1 textfield for each zone in the district, 1 textfield for the district total, and a comment area.
e.g.
User of district 1 would see:
Enter number of people:
zone A: ____ zone C: ____ zone Q: ____ total: ____ comment: ____
User of district 5 would see:
Enter number of people:
zone C: ____ zone Q: ____ zone R: ____ total: ____ comment: ____
User of district 24 would see:
Enter number of people:
zone P: ____ total: ____ comment: ____
Then I need to be able to pull up the info by district(s) or zone(s)-only the most recent entry in each district. (admin may want to see a timeline but general viewing is just the latest)
Overview: (say county)
District 1: total: 89; 40 in zone A, 24 in zone T, 16 in zone W
......
District 40: total: 12; 4 in zone B, 2 in zone P, 6 in zone W
Or by zone:
zone A: 45 total; 40 in district 1, 2 in district 8, 0 in district 23, 0 in district 32, 1 in district 34, 1 in district 40
...
zone WWW: 3 total; 0 in district 10, 3 in district 14
And we want to do the clickable map of zone/district but I think I can manage that if I get the structure setup correctly.
I've got 3 taxonomies set up: Districts, Zones and a Nested District -> zones in district (multiple parent hierarchy).
My original thought was to set up both Districts and Zones as content types and using the taxonomy_dss module + views, but that's an awful lot of types that are nearly identical.
My next thought was to set up one cck field for each zone, one content type (people_update) and use taxonomy_fields in the form to limit their fields to just those for their district. But again, I'm making multiple identical field types. And I'm not sure just how I would filter/search this for the zone->district view
I would greatly appreciate any suggestions. I want to do this right the first time rather than fumble around as I'm currently doing.
Ng
