Joomla, PHP, MySQL Zip Code locator App/Module
Project consists of MySQL 5 database design, data import capabilities and corresponding custom Joomla 1.5 module for users to run queries from webpage. We would also like a web-based backend (admin) interface to simplify future data import and maintenance.
The application will need to be created so it can be loaded as a module and integrated into our existing Joomla site.
It will consist of 2 tables:
Master US Zip Code table: Imported via CSV
Master Client Table: Imported via CSV and Excel file
This module will be accessed by in-house marketing people, not for public access.
***********************************************************************
Access Requirements:
1. Data administrator tab that will enable authorized users to import data files from CSV files as well as zap the data if needed. Must be able to append to existing data if need be.
2. User Access Tab that will enable authorized users to run the zip code application.
***********************************************************************
Database Information:
The master zip code database will be obtained from [login to view URL]
They have some sample ASP and PHP scripts for different zip code functions.
[login to view URL]
The client database will be provided to the developer in a CSV or Excel format.
***********************************************************************
Functionallity:
1. Radius query: Find all clients between Miles and Miles of a zip code. (Ex: Find all clients between 0 to 10 miles from zip code 12345)
2. Query clients by City, County, State, Zip Code, household income, etc.....
3. Basically users will need to query data based on certain fields selected in drop down controls that are fields in the zip code and client tables.
4. Create a nice functional interface.
***********************************************************************