Registration

bootstrap dashboard for admin area.

Bridgette wants to track who has not submitted their player contact information. This involves registration data and is outside of the original scope. The application does not integrate with registration right now but I might be able to add an upload for admins to setup registration just for this application.

Registration Setup

Admin uploads required data as CSV file to application. Application stores registration data and presents it in a drop down.

We would at least need a team name field in the CSV file. When a team submits the required data I mark that row as submitted.

Admin will need some reporting functions to see who is marked as submitted.

Reporting will download that list for consumption by Constant Contact, etc.

We’ll be like, “Hey, You need to submit your information on our application. You can do it now at this address https://contacts.heartlandsoccer.net/"

Registration Schema

team_name submitted
Super Soccer Team false
We’re better than Super Soccer Team Team true
Example DDL for sqlfiddle.com
CREATE TABLE registration
    (
      `id` int NOT NULL AUTO_INCREMENT,
      `team_name` varchar(255) NOT NULL, 
      `submitted` int(1) NOT NULL DEFAULT 0,
      PRIMARY KEY (id)
    )
;

# This is what the initial SQL will look like when the teams get uploaded.
INSERT INTO registration
    (`team_name`)
VALUES
    ('Super Soccer Team');

# This will never exist but it's used on sqlfiddle.com as an example.
INSERT INTO registration
    (`team_name`, `submitted`)
VALUES
    ('We''re better than Super Soccer Team Team', 1)
;