php5/mysql updates for model agency website

PHP5/mysql site updates for [url removed, login to view]

Features model agency website is based on mysql databases of their clients and artists.

The site requires various updates and improvements to the backend functionality - the original freelance site developer has now found permanent employment.

The backend content management tool has been designed already, and there will be some amount of time required to understand the existing system before implementing any changes.

There is great opportunity for repeat work based on this backend management tool. At least one other site requires significant updates, and another ecommerce site built from scratch.

It would be great to have non-general responses with some comments on perhaps what else could be improved.

## Deliverables

1) Upload via ftp to modify the website code to satisfy the following changes. These will of course make more sense when the chosen coder has access to the backend of the site!

**Job Admin Tab**

Next to the sms to artists box, have a multi-select artists name dropdown so that the sms is only sent to those artists highlighted in the dropdown. After a message is sent, the message content should remain in the box so that, for instance, a time can be changed and sent to new artists selected in the dropdown.

_Job Dates_

Need a slight change to the date system to allow for jobs that don’t shoot on consecutive days.. It could be freetext, except for the whole checking against an artists calendar for availability; so I propose:

Start date plus time

End date plus time

Calendar grid for the dates in between pre-selected green but able to be switched to red

Then some user friendly way of doing all the ‘submits’ required to make it work..

_Other dates_

Day/month/year dropdowns should start off as the values for the current date when they have not been set.

Invoice issues and paid dates do not require any times

**Casting sheet email**

For the following fields, if data is present on the job admin tab, it should be displayed.

Production title ??" already displayed

Model name and image - add

Company Name - add

Contact Name - add

Job dates & times - add

Job Pay (freetext field) - add

Other Details (also freetext) - add

**Casting sheet webpage

**As per casting sheet email plus:

Artists ‘confirmed’ only if data is ‘yes’

Artists ‘booked’ only if data is ‘yes’

**Artists admin tab

**If an artist is added by the admin, after the ‘click to submit’, it should complete a username and password if not pre-completed

After a job request via either advanced search (artists selected) or ‘submit request for casting’ (no artists selected), an admin email should be sent with the url to the appropriate job admin tab. If the job request is via advanced search (artists selected), the casting director should get the casting sheet html email upon submission of the request

**Other tasks**

Tab to send emails to a group in a multi ??"select dropdown

**Creation of xml google sitemap feed

Removal of splashpage and ensuring that the index page looks ok when the window is resized.

**

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

PHP5

MySql5

Engenharia MySQL PHP Arquitetura de software Teste de Software

ID do Projeto: #3804920

Sobre o projeto