I need simple system for managing music promotion with mailing lists. It should use PHP + MySQL + jQuery. The following specification is required:
Admin needs to have access to following sections:
Adding/editing promo pages
There should be form where admin can provide following information:
1. Name of the song
2. Desired URL for the song
3. Upload form for mp3
Page should be genereted from given code by me (layout)
Each page has widgets from facebook for likes and comments.
Adding/editing database of music contacts
There must be a form where admin can add a contact information:
1. Selectable type of contact (for instance - Radio Presenter, radio executive, music manager etc.) – dropdown list
5. Organization name
Each contact must be editable
In database there must be generated simple unique code for identification purposes.
There should be an option to create mailings – button to create new campaign
In campaign there should be option to set categories of people to send message to.
Each campaign should have form to specify message title and message body as well as dropdown where it could be chosen which promo page will be sent
In message body there should be simple mechanism that will put customised link to the song for monitoring purposes. Let’s say that we will have example message body:
link to the song is: (-link_to_the_song-)
The mechanism should automaticly change (-link_to_the_song-) to the URL of selected promo page + some additional data for GET method. For instance:
[url removed, login to view] - where 123asd is the code mentioned above in contacts section.
Sending mail should be made by SMTP.
There should be list of promo pages. When clicked into the promo page there should be statistics of total views for the page, as well as list of contacts that visited the page (based on the $_GET[‘u’] parameter) with number of views (sorted by number of views and if they requested a download). Also if contact provided feedback it should be visible there.
End of administration panel.
There should be 2 kinds of admins accounts. First one will have access to all sections of administration panel. Second one will have access to all secions except for creating and editing promo pages.
Example display page will be provided. Only thing that will be modified is if $_GET[‘u’] is set then there will be additional form to provide feedback that will be sent to the database, and additional button „Request download”.
I will desing whole database to make it easier for freelancer.