Membership Database
Environment
1) Data repository stores in MySQL database
2) A web based application. Programming language can be any PHP, ASP, etc.
Requirements
1)Only allow authenticated / authorized user to login to the web application. Administrator can defined/create user account and assign permission to it (refer to #3a).
2)Must practice secure coding when develop the web application. Do verification checks.
3)Core application functionality:
[login to view URL] of access
The system must have a login page for authorized personnel only. For successful login, the follow type of account can be granted:
Level 1: Clerk Access
1. Signup for new membership only (refer to #3b)
2. Read only to the existing membership detail (refer to #3c)
3. No access to reports and Genealogy Map. (Refer to #3d)
Level 2: Manager Access
1. Signup for new membership (refer to #3b)
2. Can modify to the existing membership detail. (refer to #3c)
3. Can generate reports and Genealogy Map. (refer to #3d)
Level 3: Administrator Access
1. Include all rights stated in Level 2.
2. Can create/modify user account and reset password.
3. View Audit trail (user activity) log
b. New member signup
i. Web forms for new member signup
ii. Information to be store in MySQL database
c. Query member status
i. Maintenance Date
ii. Member details
d. Genealogy Map & Reports
i. Genealogy Map (display 6 levels per page, top-down approach)
ii. Member's down line Report
iii. Account Maintenance Status (Maintenance / Not Maintenance)
Optional
1)Can make use of the open source Genealogy map.