Genesis
Sports
Club
Admin
demo

This is a member management system designed for South African hockey clubs. It's written in PHP and MySQL using the Yii MVC framework.

The site has two parts to it. The first is for members, to allow them to register, access their personal details and update their status for the season. The second is for administrators, where they can view and export the membership list, access member details and configure settings that affect both sections.

Administrators Log in using the user details below.
Members Register a new member or log in using the example members below
Demo Mail System The system relies on e-mail for login. For this demo site, all mail (for administrators and members) is routed to one address and the mails can be accessed via this address.
User manual The system is inteded to be easy to use, but in case something is not clear, hopefully this guide will help.

Please note: the data for the site is reset every day.

Design

Many years ago I wrote a custom management system for Pinelands Hockey Club in order to replace the tedious paper-based member registration system. I chose WordPress as my platform/framework because of my experience with it. It was a successful project and made member management much simpler. Over time, though, some flaws have become apparent.

The system is tightly coupled with WordPress and out of necessity some core WordPress pages were customised, which has complicated the tasks of keeping WordPress up to date and further developing the system. Several key processes rely on the system administrator and some of these require direct database queries be run. Members generally have to log into the system only once a year and I noticed that many had to reset their passwords to do so. Only a single member could be registered using an e-mail address, which is often an issue for families.

I used this project and the learnings from it as the base for my Business Analysis Diploma project (see the document examples on my CV page), and designed a new system. In 2016 I improved the design and implemented the system. My guiding principles were:

  • Capture only the information that is needed. Several fields on the current form have never been used.
  • Have a simpler login system. Many users forget their login details, most likely because they're used only once a year.
  • Give the club's administrators more insight into the club's membership, particularly at the beginning of a new season.
  • Give the club's administrators more control over the site. The current system relies heavily on the website developer/manager configuring the site for a new season and dealing with various issues members have with login, mailing list subscriptions, etc.
  • Decouple the management system from the website. This will make it easier to manage both.
  • Design the system to be more flexible to and easier to extend from a development perspective.

Some notable features of the new system include:

  • The system is fully independent and can run next to a website.
  • The club's administrators have full control over the site, with no reliance on the system administrator.
  • Password-less login system: users request a login links, which is mailed to them.
  • Customisable message templates (for on-site messages and e-mail).
  • Multiple members can register using one e-mail address.
  • The interface has bene radically changed, and now has a clean and modern feel.
  • The system is easy for the developer to configure for different environments/clubs.

Admin Users

The following details can be used to log into the administration system:

Role E-mail Address Password
Super Administrator demo@example.com
dan.white@example.com
demo
Administrator john.smith@example.com demo
User mary.jones@example.com demo

Example Members

Below are details for registered members (all fictional). Log-in details can be requested for any of them and these details will be sent to the test address mentioned above.

Member(s) Address Status Notes
Connor, Toby toby.connor@example.com Active Has parent
Dixon, Joanne joanne@example.com Suspended
Gibson, Amber amber@example.com Inactive Has parent
Lambert, Mia mia@example.com Active
Nicholson, Dylan
Nicholson, Sue
dylan@example.com Active
Active
2 members on one address
Owens, Olivia olivia@example.com Active
Parker, Abbey abbey@example.com Resigned
Phillips, Cameron cameron@example.com Suspended
Rees, Joel joel@example.com Active
Thomson, Henry henry@example.com Debtor
Thomson, Henry ryan@example.com Resigned