# CSC CS Website #

[Mobile Development](https://checkvist.com/checklists/598974)

Members

Current Area Positions

- Transition Behaviors to Mobile Site

Pages

- Homepage Content
   - Top News horizontal scroll view [#21](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/21)
      - Weekly Challenge
   - Here's how to join! [#16](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/16)
      - Attend meeting, and joining Slack via email or,
      - Fill out online forum with name, email, and an optional message box to receive an invite to slack or to just talk to someone about the club
         - Forum Message text
      - Something to read, like a bio of the club
      - Video, maybe
   - Top Projects [#2](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/2)
      - Title
      - Image
      - Most Recent Post
      - Status
      - Content Picker [#22](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/22)
         - Description
         - List of Members
         - List of Position Requests
            - Title
         - List of Events
   - Events
   - Footer [pr17](https://github.com/SRJC-Computer-Science-Club/cs-website/pull/17)
      - Website Directory
      - Projects
      - Events
      - Members
      - Quick Links
         - Next meeting's agenda
      - This week's meeting
         - day, time and location
         - link to agenda
      - link to last week's meeting notes
      - About this site
- Project Page Content [#3](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/3)
   - Top Project Cells
      - Title
      - Image
      - Status
      - Number of Members
      - Display Latest Commit
      - Number of Completed vs Total Tasks
      - Number of Area Requests to be Filled
      - Progress Bar based on completed tasks
   - Secondary Project Cells
      - Title
      - Image
      - Status
      - Number of Members
      - Display Latest Commit
      - Number of Completed vs Total Tasks
   - Past or Archived Project Cells
      - Title
      - Status
   - Detailed Project Page
      - Title
      - Description
      - Members
      - List of Help Needed
- Events Page Content
- Members Page Content
   - Member Cell
      - Image
      - Name
   - Detailed Member Page
      - Name
      - List of Titled Links
      - Bio
      - Table of Linked Projects
- Contact Us Page Content
   - When the Club Meets
   - Send a Form
- About the Club Page Content [#4](https://github.com/SRJC-Computer-Science-Club/cs-website/issues/4)
   - About the Club
      - What we do
      - What we've done in the past, maybe?
   - Members of the Board
- Login

.schema

- TABLE Projects
   - title **TEXT**
   - date created **TEXT**
   - description **TEXT**
      - the problem, solution, and why it matters
      - link to github
      - tutorials or videos to relate to project
   - status of project **INT**
      - blueprinting or brainstorming
      - proposed
      - in progress
      - positions needed
      - not on track
      - completed
      - resigned
   - milestones **TEXT**
   - **list** of links
   - **list** of media
- TABLE Members
   - first name
   - last name
   - bio
   - bio short
   - email
   - **list** of links
   - **list** of projects
   - **list** of languages
- TABLE Projects_Members
   - projectID
   - memberID
   - role
      - Project Founder *PF*
      - Project Manager *PM*
      - Subproject Manager *SPM*
      - Team Member such as,
         - Developer
         - Programmer
         - Designer
         - Game Designer
         - Graphic Designer
- TABLE Project_AreaRequests
   - project
   - title
   - description
   - club interest
      - 1-Not Needed Now
      - 2-Planned Development
      - 3-Looking for Help
      - 4-In Need
      - 5-Strickly Needed
   - number of members needed
   - **list** of assets
   -  author id
- TABLE Project_AreaRequest_Assets
   - title
   - experience Level
      - 1-easy
      - 2-medium
      - 3-a challenge
      - 4-difficult
      - 5-experienced
- TABLE Project_Posts
   - project_id
   - Date Created
   - Last Update
   - title
   - body
- TABLE Project_Events
   - project_id
   - title
   - description
   - description_short
   - location
   - date_range
   - **list** of media
      - caption
      - image
      - url
- TABLE Tasks
   - member_id
   - title
   - created
   - deadline
   - **list of** aliases
   - **list of** reminders
   - notes

New Ideas

- Site Map
- Ericks Outline
   - NEW Database
      - Projects
         - id INTEGER
         - title TEXT
         - description TEXT
         - dateCreated TEXT
         - platform TEXT
         - status TEXT
      - Events > a Project
         - id INTEGER
         - projectID INTEGER
         - title TEXT
         - description TEXT
         - date TEXT
         - location TEXT
      - Forum > a Project
         - id INTEGER
         - projectID INTEGER
         - title TEXT
      - Posts > a Forum
         - id INTEGER
         - forumID INTEGER
         - title TEXT
         - description TEXT
         - dateCreated TEXT
      - Comments > a Post
         - id INTEGER
         - postID INTEGER
         - username TEXT
         - body TEXT
         - dateCreated TEXT
      - Users > many Projects
         - id INTEGER
         - name TEXT
         - contactEmail TEXT
         - isProjectManager
         - containsAvatar INTEGER
   - User
      - **Home Screen**
         - Cell01: Top News | Top Event | Top Project Announcement
         - Cell02: Join the Club
         - Cell03: Core Projects
            - Title
            - Photo
            - Headline
            - Status
            - Menu Bar
               - Members
               - Open Positions
               - Next Event
         - View Secondary Projects
         - Cell04: Recent Events
         - Footer: Directory
            - Projects
            - Forums
            - Contact Us
            - Events
      - **Club Projects**
         - Events
         - Projects
            - Title
            - Image
            - Languages
            - Status
            - Number of Members
            - Number of Completed vs Total Tasks
            - Number of Area Requests to be Filled
            - Detailed
               - Title
               - Git Hub Branches, maybe
               - Description
               - Current Project Status
               - Team members
               - Area Requests
               - Events
               - Project History
               - Forum
               - Media
         - Subprojects
            - Title
            - Image
            - Languages
            - Status
            - Detailed *same as projects*
      - Events
   - Admin
- User Self Evaluation for Joining Projects based on skills
- Public Project Form
   - name
   - email
   - title
   - description
      - the problem, solution, and why it matters
   - languages
- Visual Language Map
- Host 2D Platformer
- Help Fund the CS Club
- Google calendar integration
- Post Meeting Notes
- Login APIs/Tools
   - Login with Google, GitHub
   - Login Tiers
      - Administration
      - Project Manager
      - Member
      - Guest