569316 MYSQL & PHP MEMBERSHIP DATA MANAGEMENT

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