Closed

569316 MYSQL & PHP MEMBERSHIP DATA MANAGEMENT

This project was awarded to emreg for $120 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
1
Project Description

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 [url removed, login to view] 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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online