I need someone to create a feedback database for use by real estate agents and their clients. I've been told before (original programmer backed out - not from this site) that I would need to probably go mySQL route.
I need someone to create a feedback database for use by real estate agents and their clients. I've been told before (original programmer backed out - not from this site) that I would need to probably go mySQL route. Basic premise, two different logins. One for agents and one for clients. Client login sends user name and password as well as a few variables that will change the look of the screen displayed (color scheme and header logo essentially). They will have the choices of "account" where they can change user name and password, email notification preferences and "View Feedback". Feedback will be submitted by other agents. The agent login will have the choices to "Add New Listing" - which would allow them to enter 4 or 5 fields about a house as well as setup an initial client login user name and password tied to this house. Once a house is in the database, they will have the option to "Add Showings" By adding a showing the agent will select via a drop down box an agent's name. (Database will need to be updated with names and email address via an web based admin area) Once this is selected an email is sent out based on text from the admin form (including variables from the database involving the house and the listing and buyers agent's info.) The email will contain a link for the buyer's agent to follow to post feedback. This feedback will then in turn be available to the buyer's account tied to the house and they should get an email telling them so (email again will have variables and text defined via the admin tool.) If the agent doesn't respond after 3 days, another follow up email should be sent. Agents should be able to view pending feedback requests and their age. After 3 days they can request that another notice be sent. Once a house is sold the should have the abilitiy to delete the house from their account.
Web based admin area will have all text for emails. Will have an agent editor so additional agents names and email address's can be added. System wide reporting, showing how many feedback requests have been made and how many have been fufilled and how many are pending, along with a detailed report of info in suitible format for exporting into excel.
Ability to send electronic invoices quarterly or monthly based an admin setting. Again email text for this will be variables from the database and text inputted via the admin tool. Invoices will be based on a price inputted via the admin web tool and the number of "Listings" an agent adds to their account in the choosen time period. Admin tool should allow for payments to be posted to accounts and late notices be sent if payments have not been posted (No actual online payments.) Ability to export to suitable format for importing into excel.
Lost passwords should be emailed for clients and agents. Initial agent logins will require registration and the gathering of normal name, address, phone, company, etc.
1) Complete and fully-functional working program(s) installed on live website, complete source code of all work done. 2) Step by step installation instructions for future referece. 3.) Complete ownership and distribution copyrights to all work purchased.
Server is Unix I believe.