Hi everyone,
we have a home grown order management system where there is the main
order ticket that can have approval tickets and tasks attached to it.
Acctually there is much more, but it doesn't matter here.
All of the tickets belonging to the main order ticket need to have
same Assignee Group. The Assignee Group depends on different fields of
the verious components of the order. So for example when I change the
Assigned Group of one of the tasks, the Assignee Group on all of the
order components needs to be updated. Or when I add another approver
or remove one another update is needed.
Currently I'm solving it in the following way:
1. I have a Display Only form with the Assignee Group business logic.
2. When a relevant field on any of the order ticket components changes
I make a push toward the Display Only form sendig it information like
the old group, the new group and the source of the change (i.e. form
on that the change happens).
3. The business logic on my Display Only form makes a few checks,
generates a new Assignee Group string and writes it via SQL to all
relevant tickets.
So for example let's say I have an order like this:
Main Order Ticket
/ | |
Approver_1 Task_1 Task_2
(Group1) (Group1) (Group2)
In all 3 tickets Assignee Group looks like this:
Group_1 Group_2
Now I'm changing the Assigned Group in Task_1 from Group1 to Group3
I'm sending this info to my Display Only form and let it decide what
to do.
My Display Only form sees: OK, so he changes the Assigned Group from
Group1 to Group3, so we definitely need to add Group3 to our Assignee
Group, but let's see it we can remove Group1 from the Assignee Group.
Then it performs an SQL to Approver_1 and Task_2 checking the values
of the relevant fields. If it finds Group1 there (in this case it will
in Approver_1), then Group1 stays in the Assingee Group string and
finally we have:
Main Order Ticket
/ | |
Approver_1 Task_1 Task_2
(Group1) (Group3) (Group2)
In all 3 tickets the Assignee Group looks like this:
Group_1 Group_2 Group_3
Now my Display Only forms performs an update on Approver_1, Task_1 and
Task_2
Does this make sense or is there a samrter way of doing this?
Thanks,
Mark
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
