I am looking for a pretty straightforward web-based mySQL/php application that will help me organize groups of people who have weekly meetings in homes around our city in the USA. Among other things, the application will help the administrator assign prospects who are interested in joining a group. I will want the application to suggest groups to assign the prospect to based on zip code data, i.e. the application will be able to look up which groups are closest to the the prospect based on the prospect's US zip code. (I am no expert but I understand that a zip code database can be cross-referenced with distance radius to provide information as to which zip codes are closest to the zip code entered). If you can provide a good zip code database free of charge, that will certainly help your chances in winning the bid. The administrator will then be able to choose which group to assign the prospect to, and the app will the allow the administrator to add them to that group as an "assigned prospect" ...
Group members will have different designations such as "leader", "apprentice" or "assigned prospect" etc. The app will give the administrator the ability to maintain profiles for each group member, and details about each group such as where the group meets, etc. The app needs to be integrated with mapquest or yahoo maps, whichever you have more experience with. Administrator will have ability to click on a "map" link which will pull open a mapquest or yahoo map of the group member's address location, or the group meeting place location. The app will also allow me to move a member of one group to another group, and to create new groups from existing groups that have grown too large. Groups themselves will be assigned to larger groups (maybe we'll call them "supergroups") in batches of three, based on location, i.e. three groups meeting within the same zip code will have monthly gatherings, so we need to see that information on the summary page. The app will give summarizing information about all of the groups on an overview page helping the administrator get a quick overview of all of the groups, such as which "supergroup" the group is assigned to, leader name, current meeting location, number of group members, number of assigned prospects for that group, weekly time of meeting, etc.
On the user side, group leaders will have log-in ability to update their own profiles, meeting locations, meeting times, and also to update or edit group members' profiles who are attending their meetings. The group leaders will also be able to check off which of the group members or assigned prospects actually attending the meetings. This user log-in will basically be a homepage for the group leader to get an editable overview of their group's vital stats, i.e. member roster, meeting location, assigned prospects, etc.
The system should include a function which presents a summary page of any user edits that have been posted to the system since the administrator last logged in, thus allowing the administrator to be aware of group meeting location changes, profile edits, etc. which the administrator would not otherwise be aware of.
The application will have the ability to integrate with a phase 2 project which will transform the data into a visual interface with "home" symbols representing meeting locations appearing in the appropriate space on the interactive map graphic. If you can provide this Phase 2 solution in this Phase 1 project as a bonus, that will obviously add to your chances of winning this bid.
The application should function flawlessly on all brands of modern browsers.
Thanks for your interest in this project.