Add to existing static website a dynamic membership list and processing capability.
Please review & ask questions. I am travelling, my response may be slow.

Three functional areas each protected with a unique password.

*** Web site Area 1) The members view to see membership list in multiple ways
– 1st Horizontal nav bar above view area, 4 tabs to pick view 1-4 below
– Vertical scroll bar right of list display area
– Horizontal scroll bar below list display area

>> First View: Alphabetic sort on member name –
– 2nd Horizontal nav bar above list display area, with search box on (partial) member/spouse name,

>> Second View: Alphabetic sort on street name –
– 2nd Horizontal nav bar above list display area, with search box on (partial) street name,

For each view (1 & 2) above the following detail in the display area – for each household multiple lines:
Line one for member:
Line two for spouse (if not blank/null):
Last Line for household mailing address:
number + street name + comma space + line 2 (if not blank/null) + comma space + city + comma space + state + zipcode

>> Third View: Chronologic sort on month of birth –
– 2nd Horizontal nav bar above list display area, with search box on (partial) month of birth,

>> Fourth View: Alphabetic sort on Interest keyword –
– 2nd Horizontal nav bar above list display area, with search box on (partial) keyword,

For each view (3 & 4) above the following detail in the display area – for each household multiple lines:
Line one for member:
Line two for household mailing address:
number + street name + comma space + line 2 (if not blank/null) + comma space + city + comma space + state + zipcode

*** Web site Area 2) The membership list maintenance view

A separate page accessed by its own password:
1) Membership list maintenance view, probably one page with all household information for one household
including "interests" keywords which are one or more strings of words separated by semi-colon ";".

*** Web site Area 3) The administrators view to maintain passwords, run reports and other functions

Capabilities (may be separate pages or combined as appropriate):
1) Maintain password to Area 1 for member access to view membership list
2) Maintain password to Area 2 for membership list maintenance view
3) Maintain password to Area 3 for administraton
4) Maintain standard return address for use in mailers for #7 below
5) Implement password reset mechanism for a web professional to reset lost admin password
6) Reports generated in PDF format with header, footer (with page number), downloaded to local computer:
– Membership report in each of the four views shown in Area 1 above
– Membership report formatted like view 4 in Area 1 above except sorted by phone number
– Membership report formatted like view 4 in Area 1 above except sorted by email address
7) Reports generated in PDF format *NO* header, footer, downloaded to local computer:
– To print #10 envelop for each household (member + spouse names with address) and standard return address
Sample PDF for layout will be provided
– Computer generated birthday card, input birthday range to select members (month and day but not year)
Sample PDF for layout will be provided
8) Spreadsheets generated in Excel format with column headings, downladed to local computer:
– Membership report in each of the four views shown in Area 1 above
– Membership report formatted like view 4 in Area 1 above except sorted by phone number
– Membership report formatted like view 4 in Area 1 above except sorted by email address
– All columns and rows in the database
9) Spreadsheet generated in Excel format with column headings, downladed to local computer:
– All columns and rows in the database

*** Create MySQL database to drive reports and web pages above
– Column content and design by mutual agreement to support functionality above and possibly some additional static data
– Number of rows less than 400

Tags: area, bar, display, line, list, membership, view