Help - PHP MySQL Multiple Decision Making System?

Discussion in 'PHP' started by chrisuk24, Apr 22, 2013.

  1. #1
    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!
     
    chrisuk24, Apr 22, 2013 IP
  2. rchurchill

    rchurchill Greenhorn

    Messages:
    14
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    13
    #2
    When you say
    What is it that you want changed? Need more information here..
     
    rchurchill, Apr 23, 2013 IP
  3. annaharris

    annaharris Active Member

    Messages:
    119
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    51
    #3
    What kind of table you are using to store the leads coming from different customers ?
     
    annaharris, Apr 24, 2013 IP