MYSQL & PHP ACTIVITY DATA MANAGEMENT
SBR CHAPTER ACTIVITY DATABASE DESIGN 060312
Please provide reasonable milestones and time-frames based on your review of the project with your bid
I want to add databases, input/output pages and tabs to SiteLok admin-panel
I need a few linked databases created along with the output and input pages protect using the SiteLok membership script
SiteLok uses code "on the page" to determine which groups are allowed, also need additional database to allow flexibility in adding permission settings through hierarchy (see permission). The new databases should link using the $username and $usergroups from SiteLok.
New Tabs in the SiteLok Admin Panel:
MENUS –CHAPTERS – ACTIVITY - PERMISSIONS
 
*MENUS* TAB
This tab allows access to the management of all the “drop down menus” you will be creating. Need to be able to view/add/edit/delete from the following:
CHAPTER
CHAPTER LIST (DROP DOWN MENU)
CHAPTER COFIGURATION (view/add/edit/delete fields in CHAPTER PROFILE)
POSITION LIST (DROP DOWN MENU) – see below
SPECIALTY LIST – (DROP DOWN MENU) – see attachment
ACTIVITY
CHAPTER ACTIVITY COFIG (view/add/edit/delete fields in CHAPTER ACTIVITY)
MEMBER ACTIVITY COFIG (view/add/edit/delete fields in MEMBER ACTIVITY)
PERMISSION LIST – (CHECK OFF MENU) – see below
 
*CHAPTER* TAB
Sub tabs: Chapter List, Chapter Profile
CHAPTER LIST – SUB TAB
This drop down menu - Link SiteLok $usergroups to Chapter List Options every $chapterList option is a $usergroup but every $usergroup is not a $chapterlist option
Sitelok uses usergroups. I want the dropdown you create, to allow ADMIN to designate some user groups as chapters. so all chapters are usergroups, but all usergroups are not chapters. chapter list are all usergroups that are designated as chapters
CHAPTERS PROFILE- SUB TAB
This should look like [login to view URL] which is the user profile page
The following are fields for chapter profiles (need to view/add/update/delete)
Chapter Name (select $usergroup to view/add/update/delete)
Chapter Details ($usergroup profile view/update/delete)
Chapter Status - int (0=request, 1=concept, 2=provisional,3=established, 4=classic, 5= b2b, 6=maximized )
Location/Venue (text)
City (text)
State (text)
Meeting Day (text, weekday)
Meeting Time (time)
Meeting Type int (0=breakfast, 1=lunch, 2=dinner,3=brunch 4=coffee-break)
Meeting Frequency int( 0=daily, 1=weekly, 2=monthly,3=quaterly, 4= semiannual,5=annually)
Chapter Member List (add/link $username or remove from list)
POSITIONS LIST - drop down menu - Link SiteLok $usergroups to Position List Options
every $positionList option is a $usergroup but every $usergroup is not a $positionlist option
Sitelok uses users and user groups. I want the dropdown (modifiable form) you create, to allow designating some user as part of 1 or more usergroups (chapters). This will create the chapter member list for each unique usergroup based on the choices above.
POSITIONS ($username will be linked to each position in menu)
President
Ambassador
Vice President/Administrator
Treasurer/Secretary
Referral Coach
Membership Committee
Event/Drive Host
Door/Visitor Hosts
Table Host
Time-keeper
Card-keeper
Roster-keeper
Score-keeper
MEMBER ACTIVITY (linked to $username by $usergroup)
Referrals Given Internal (RGI) (number)
Referrals Given External (RGE) (number)
Referrals Received Internal (RRI) (number)
Referrals Received External (RRE) (number)
Referral Bounty Received $ (RBR) (currency)
Referral Bounty Given $ (RBG) (currency)
Visitor Invited (number), Visitor Name (text) Visitor Email (email) Visitor Phone (phone),
Visitor Specialty (text), Visitor Hometown (text)
P2P Sessions Held (number)
Absent (number)
Substitute Sent (number)
Events Attended (number)
Tours (number)
Each chapter leadership will be able to report/input numbers each week which will be summed up and maintain on an ongoing record
for example
Referrals Given Internal (RGI) started at 0
then user1 gave user2 +2 RGI
now RGI = 2
next week RGI started at 2
then user1 gave user4 +3 RGI
now RGI = 5
CHAPTER ACTIVITY
Referrals Given Internal (RGI) (number) Total for chapter
Referrals Given External (RGE) (number) Total for chapter
Referrals Received Internal (RRI) (number) Total for chapter
Referrals Received External (RRE) (number) Total for chapter
Referral Bounty Received $ (RBR) (currency) Total for chapter
Referral Bounty Given $ (RBG) (currency) Total for chapter
Visitor Invited (number) Total for chapter
P2P Sessions Held (number) Total for chapter
Absent (number) Total for chapter
Substitute Sent (number) Total for chapter
Events Attended (number) Total for chapter
Tours (number) Total for chapter
Permission Setting Form: add the user rights descriptions in it. Who can see/edit/delete what... For example president can link a member to a chapter but members only unlinked themselves or chapter members can only view chapter profile but president and vice-president can also add/edit records.. for example
President Permissions:
Chapter Profile- y/n view y/n add y/n edit y/n delete
Chapter Activity - y/n view y/n add y/n edit y/n delete
Member Activity - y/n view y/n add y/n edit y/n delete
Vice President Permissions:
Chapter Profile- y/n view y/n add y/n edit y/n delete
Chapter Activity - y/n view y/n add y/n edit y/n delete
Member Activity - y/n view y