I need a Website to manage a database with the below criteria:
This website is used to maintain a database for all customers terminated on a specific network.
The website is divided into 4 Main modules
For the Database Module:
- A scalable web database
- Can Manage the database though this web interface (Add , delete & edit records)
- be able to search & filter the database using any row or column fields.
- Select the found records for viewing
- Select the found records for edit
- Ability to Export found records into Excel spreadsheet.
- be able to sort the database using any of the column fields.
- be able to export and import data to the database using .xls or csv as input or the output format.
- Some of the fields of the database will be a dropdown menu and some will be interned as text and some will be numbers
- For the dropdown menu columns , i need to fill this menu from the Administration module
- be able to generate reports on the database.
- Max. 5 reports will be requested to be done in this project.
- a logging to each activity done on the database (to know which users added or deleted a records on the database)
- the website must contain a module for Administration ( creating a username/password for every user , and setting the privilege of every logged in user to the website)
- i need the users with different privialges:
+ user has all the privilage on the database ( can add , delete , edit , on the database)
+ user has limited privilage on the databae (can't add or delete or edit the database but can export the data to the excel sheets).
+ some users have access to the database module but not the reporting module and others can access the reporting module and not the database module
+ full privilege users can access all the modules.
- The home page of the website is a blank page asking only on the username and password to login.
- Language supported is Arabic and English
- be able to send E-mail notification whenever a new record is added or deleted.
- check the attached files for a sample of the homepage and the layout
- i need to be able to manage this site using Joomla.
- Application deployments
- Three months free of support