Assign things to users
| From: | Dan Joseph | Date: | Tue, 26 Aug 2008 14:20:31 +0000 |
| Subject: | Assign things to users | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-278718@lists.php.net to get a copy of this message | ||
Hi,
This is more of a logic question than a PHP question. I wanted to get some
opinions on how some of you are doing things like this.
I have a set of employees in our quote management system. We get thousands
of quotes per hour, and every 15 minutes I have a cron that goes out and
grabs the unassigned and goes in a round robin fashion assigning the quotes
to the employees. I have the table setup like:
User ID, Username, AssignTolken
What I've been doing is grabbing the user who has AssignTolken = 1, and
giving them the next quote. Then I change them to 0, pull up the next user
in line, and set them up to get the next quote with AssignTolken = 1.
My question is: How do you all do handle similar situations like this?
I've been thinking there has to be a better way to do it, but I have not
been able to think of a good way to do it. I'd like to see how if I'm doing
it like everyone else, or what else is out there. Any ideas would be
appreciated!
--
-Dan Joseph
www.canishosting.com - Plans start @ $1.99/month.
"Build a man a fire, and he will be warm for the rest of the day.
Light a man on fire, and will be warm for the rest of his life."