Today I’d like to describe a complex web application that I built from scratch over a year ago and continue to update on a regular basis. It was created for a live music company here in New York City that provides bands for weddings and other events. They are in high demand and have dates scheduled years in to the future.
They approached me about creating a database driven custom web application that their personnel could access online, any time, from any computer. For each event/contract they wanted to have an easy way to store basic information like:
- event location details
- event segment schedule and fees (as in cocktails, reception, after party, etc…)
- bands and musicians for each segment
- requests and special music
- crew information
- client contact information
- contract information like dates, reference, status, terms, etc…
- payment amounts, schedule and status
The system is based around the color coded list of upcoming events (above). This only shows a tiny slice of the information that is collected for each event. Here they can access printable summary sheets presenting condensed event info for specific roles like musician and band leader, a printable contract, view and edit links and links to other event specific operations like budget and the dynamic “contracting” page. At the top we also have an event search and menu for other system features that are vital to the business.
The financial data generated on the contracting page is saved and displayed on a number of different payroll reports. There are other reports for payments, expenses, contracts, musicians and anything else the client needs in order to access important information in a useful format.
The system also includes management for contacts, musicians, rehearsals, plus user login and a multi level access permission structure.