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
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

Awarded to:

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