rkiss
Posts: 14
|
| Posted: 11/05/2004, 8:07 AM |
|
Hi,
I was wondering if this would be possible to do:
When a staff member creates a new task, he/she will have to assign it to the group of users (tenants at specific units at specific properties). The issue here is that a staff member should have the ability to pick mutliple units using checkboxes (could be a pop up page) and tenants at these units should be notified via email of new task.
("Property" table and "Property_Unit" table are related with property_id field and "unit_id" from "Property_Unit" table is related with "Tenant" table).
How can I set up the following
- display units grouped by property
(example:
193 Albert Street
[check box] Unit 1
[check box] Unit 2
[check box] Unit 3
282 Erb Street West
[check box] Unit 1
[check box] Unit 2
[check box] Unit 3
)
- option to have "Select all units" for each property
(example:
193 Albert Street [check box] select all units
[check box] Unit 1
[check box] Unit 2
[check box] Unit 3
)
- option to have expanding and collapsing tree structures for properties/units. Staff member will at first see all properties with the ability to expand by clicking on the + sign to see all units at the property.
(example:
+ 193 Albert Street [check box] select all units
+ 282 Erb Street West [check box] select all units
)
Is this all possible using arrays? some sample help would be great.
The task table will have duplicated task_id, since one task_id will have multiple unit_ids. How should this be processed when inserting new task into task table. Should I create a "task" table with the task information (such as: subject, body, importance, expiry_date,etc) and another table "task_destination" with task_id, unit_id attributes?
Also, how can I have ensure that tenants received the notification. I would like to log these sent emails to tenants. "Notification" table would have task_id, email attributes.
Any help/direction is appreciated. I know that it is a lot, I just would like some direction on this task.
Thank you
R
|
 |
 |
rkiss
Posts: 14
|
| Posted: 11/09/2004, 5:25 AM |
|
Hi,
Could some please direct me on how to create a check box for each result set data in the array?
Thanks
Roman
|
|
|
|
|
