Skip to content
PHP accounting tool for music schools and tutoring businesses.
PHP HTML JavaScript CSS Other
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
ComposerSetup
app
src
tests
vendor
web
Procfile
README.md
crm_music.sql
crm_music.sql.zip
crm_music_2.0.sql.zip
crud-flow.md
deletedCodeIndex.txt
flowchart.sql
pgservernotes.md
servernotes.md

README.md

Music School Accounting

Music School CRM and Accounting Tool.

By ** Carlos Munoz Kampff, Jennifer Beem, Jay Freeman, Koji Nakagawa and David Quisenberry**

Description

A web application for managing tutors and clients for small tutoring businesses.

Description

A web application for managing tutors and clients for music tutoring businesses that uses PHP and MySQL. It allows for multiple relationship types so that a student can be assigned to many teachers, many courses, many schools etc. Information can be created, retrieved, updated and deleted persistently to the MySQL database.

User Stories

Music School Administrator Specs:

Status Spec
DONE 1a)Can register a student to the school.
DONE 1b)Can delete, update a student to the school.
DONE 2a)Can register a teacher to the school.
DONE 2b)Can delete, update a teacher to the school.
DONE 3a)Can register a course to the school.
DONE 3b)Can delete, update a course.
DONE 4a)Can register a lesson to the school.
DONE 4b)Can delete, update a lesson.
DONE 5a)Can register a service(session) to the school.
DONE 5b)Can delete, update a service.
DONE 5c) Assign multiple lessons to student
DONE 6a)Can register a customer account to the school.
DONE 6b)Can delete, update an account.
DONE 7)Students, Teachers, Courses, Lessons and Customers can be retrieved in relationship with each other.
DONE 8)Review the sessions that where scheduled to a client last month.

MVP Music School Administrator Specs:

Status Behaviour Input Output
DONE Update multiple session/service payment status, duration and recurrence with a batch edit functionality. From student page list of scheduled sessions/services, Change status of lesson with checkmark and menu selection. See it in a different color.
DONE As an admin-user I can go online and see information, about my sessions, lessons, teachers, students and accounts. And I have CRUD functionality no login yet just url CRUD functionality ( hosted on Dreamhost)
DONE Filter sessions(services) that where schedul ed to a client per month, student, TEACHER, attendance, "paid_for". From account page and teacher page See table of results

Video Streaming SPECS:

Status Behaviour Input Output
TODO As an admin-user I can start a tokbox video streaming session with another admin user each user navigates to a respective url users have a video streaming session within our domain.
TODO As an teacher-user I can start a video streaming session with student user and see lesson materials on half of the screen, the video on the upper left corner of the screen and ( student name, instrument, parent guardian name, parent account phone number and email, and student notes ) info on the bottom left corner of the screen. a teacher navigates to their url clicks a link to start a video-session with one of their assigned students, student navigates to their home page users have a video streaming session within our domain. The teacher and student have almost identical screens with lesson and info except student page does not have student notes

Teacher user Stories:

Status Behaviour Input Output
DONE As a teacher-user I can see my students and their notes
DONE ... I can see all the courses and lessons
DONE ... I can create courses
DONE ... I can create lessons assigned to a course
DONE ... I can assign a student to a course
DONE ... I can see all the sessions/services related to me in a given month, week or day, I can also see the notes
DONE ... I can update attendance, notes, duration and recurrence for a given session/service (one at a time)

Account (client) user Stories:

Status Behaviour Input Output
DONE As an account-user I can see the students in my account
DONE ... I can see the teachers, courses and lessons they are assigned to
DONE ... I can see the services/sessions that are assigned to my students in this month, the previous month and all history. I will see attendance, duration, paid_for, recurrence, notes, teacher that was joined to service

Setup/Installation Requirements

  • Clone repository from github.
  • Initiate a php server in terminal within the project directory.
  • In Terminal run: Install composer
  • Open localhost:8000
  • Enjoy

_web browser and PHP 5 are necessary to operate this _

Known Bugs

There are no known present at this time.

Support and contact details

No support.

Technologies Used

  • PHP
  • Silex
  • HTML
  • Bootstrap
  • _MySQL

License

MIT

Copyright (c) 2017 _Carlos Munoz Kampff_Jennifer Beem_Jay Freeman_David Quisenberry

You can’t perform that action at this time.