Help - PHP MySQL Multiple Decision Making System?

Hi Guys,

I'm new to the forum (Long time reader, first time poster!)

I'm working on a system that sends sales leads to the correct person based on a number of conditions.

At present, a sales lead will come into a MySQL table called "Leads" with all of the customers information and the column name of Status is set to "New".

Sales reps then have access to a very basic report that allows them to view the leads based on the Status (e.g. New to view all the leads that are new and haven't been allocated).

What I want to happen:

Lead comes into the MySQL table as "New" as it does currently now.

The system will automatically make a decision where to place the lead based on what information the customer submitted (e.g. The product the customer is interested in/the loan amount the customer has applied for (if the product is set to loan), if its a weekday or weekend etc etc). Basically wanting something that can be changed easily without having to heavily edit the PHP code.

Do you know of something that's opensource that I could use to do this or a tutorial on where to start? Or even what i'd need to start with?

Any help would be massively appreciated!

Cheers guys!

View the original article here