I am looking to have an Administrator (CMS Admin) created for a website of mine. The administrator would allow the entry of data into the database – relatively simple stuff.
—————-
CMS Admin Requirements
—————-
* Registration Required – User’s must sign up for an account into the CMS to allow usage. Without login, only a basic registration screen is available.
* ‘Administrator’ account can access all features and information in the system.
* Drupal or Joomla should be used as tools. Can not be a ‘custom’ interface. Template can be any off the shelf templae, no issues there.
—————-
CMS Feature Set
—————-
_________________
Enter Casino Info
_________________
SUMMARY: Registered users can enter Casino information into the system. This information resides in the following datatables – ‘casino’, ‘software’, ‘casino_software_join’.
* User can enter Casino Information into the Administrator and keep track of the Casinos they have entered. All Casino Entries are editable ONLY to the Registered user who submitted the information and to the ‘Administrator’. The Casino Information is as follows:
— ‘casino’ DataTable –
1. casino_uid – Primary Key, Auto Increment, NOT used by user.
1. Casino Name – Name of the Casino
2. Casino Logo – Logo should be an image, 60×24, uploaded to the server in the proper location {casino-images folder} and the name of the file stored in this field.
3. casino_usaccepted – yes/no selectable. To database bit field, 1=yes, 0=no
4. casino_supportnumber – Text
5. casino_faxnumber – Text
6. casino_contacttext – Text
7. casino_livehelp – URL (text)
8. casino_est – Year established (4-digit year – ex: 2011)
9. casino_address – text
In addition to this information, there will be the following:
Casino Software is in the following datatable: software. This data is:
— ‘software’ DataTable –
1. software_name – Name of the software, required
2. software_golive – Software established date, not required
There should be a selection box that shows the software_name for the user to select. There should be an ‘Add’ button to add that software name to an ajax section on the page. They can ‘add’ as many software selections as they want because casinos can have several softwares used.
There should be the ability underneath to ‘Add A NEW Software’. They can then add a new software by entering ONLY the ‘software_name’. This ‘Add A NEW Software’ would commit the new software to the ‘software’ datatable.
Once the information is completed, it will insert the information into:
1. ‘casino’ DataTable
2. ‘software’ DataTable (only if a NEW Software is added)
3. ‘casino_software_join’ DataTable – This table JOINS the casino_uid with the software_uid. casino_uid’s can have multiple software_uid’s. All must be joined.
_________________
Enter Bonus Info
_________________
SUMMARY: Registered users can enter Bonus information into the system. The information resides in the following datatables – ‘bonus’, ‘bonus_type’, ‘bonus_wd_type’
* User can enter bonus information into the Administrator and keep track of the bonuses they have entered. All Bonus Entries are editable ONLY to the Registered user who submitted the information and to the ‘Administrator’. The Bonus Information is as follows:
1. bonus_uid – Primary Key, Auto Increment, NOT used by user.
2. casino_uid – User would select one of the casinos they had previously entered into the system, the UID of that casinos would be inserted into this field in the DB
3. bonus_type_uid – User would have a ‘selectable’ dropdown. That dropdown will be filled with the ‘bonus_type_description’ from the ‘bonus_type’ datatable. By selecting the dropdown, this field would be filled in with the ‘bonus_type_uid’ from the ‘bonus_type’ datatable.
4. bonus_wd_type_uid – User would have a ‘selectable’ dropdown. That dropdown will be filled with the ‘bonus_wd_type_description’ from the ‘bonus_wd_type’ datatable. By selecting the dropdown, this field would be filled in with the ‘bonus_wd_type_uid’ from the ‘bonus_wd_type’ datatable.
5. bonus_freemoney – integer
6. bonus_currency – User will enter the Currency type ($,
