> > 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, If what you're looking for is an evenly distributed workload, I don't see anything wrong with what you're already doing. However you might want to run a comparrison query every now and then to view the total number of outstanding requests assigned to your employees. Johnny and Susie might have both been assigned 1,250 qutoes today by your round robin method, but Susie is a much better worker than Johnny so her current outstanding quotes are at 50 but Johnny has 2,000 because he works slower. You might want to assign more quotes to Susie and reward her for being a good worker :)
