A Web application for Reporting internet Data usage and creating users
## Deliverables
1. Web application using Java.
2. Login Page
2.1 User should login to the system.
2.2 After login, user can change the password.
2.3 Based on the user Id, Menu of the user will be changed.
2.3 Security should be of high importance. (User should not type in the url and get any menu he wants with out authentication).
3. Admin Page.
3.1 Facility to create new user.
3.1.2 Attributes to be captured while creating new user .
User name,
password,
company name,
contact number,
monthy Qouta,
Montly Charges
4. Report Page.
4.1 - Facility to list the Users(Display is Company Name) and monthly Quota (Month will be selected). Print facility for the report
4.1.1 - Facility to search for a use and list his montly quota. (Company Name and Year will be selected).. Print facility for the report
4.2. General Requirement for the Report.
4.3.1 The Report should have Header Title (Company Logo) and Grid. Column should be alligned properly.
4.3.2 Facility to Export to Excel.
4.4 Facility to update User Payment status.
5. User Page:
5.1 User should login to the system
5.2 Select Month and list the usage for the month. facility to Print the Report
5.3 Get the list of the Month and Quota and Payment Status ( Year will e selected)
6. Required database schema has to be bult and approved by us before start development
6.1 Database should be mysql on linux
6.2 Application should be able to deploy in Tomcat on linux(OpenSUse11, GlassFish on Linux - OpenSuse 11).
6.3 Configuration of the Application server and support Deployment.
7. Usage data should be pulled out into differnt usage table before it get reset to 0 by radius system. (This can be using a trigger on radius table or by a batch job.
7.1 If batch job is used, then configure the batach job to run at regular intervel. The intervel will be read from table.
7.2 If batch job is used, Admin User should have facility to set the intervel for batch job and monitor the status of batch job.
7.3 If batch job is used, Admin can start , stop the batch job using the Admin interface.
8. Look and Feel og the system should be good.
8.1 For date input, use calendar
9. There are two type of users.
1. Permanent users and
2. Temporary users.
Details of user is required only for Permanent user
For Temporary user, no details is captured.
9.1. User id and Password should be generated for the Temporary user.
9.2. For permanent user, The customer can request an user id. System will verify if the user id is available, if not suggest a possible user id. Password will be generated for the permanent user. But later he can change the password (using his page).
10 Important - System should ensure that the USER ID and Password is Unique in the database. For Auto generated temporary user, a random user id and password is generated. This should be unique in the database.