database and reports of monthly scores

Scores Database (like some bootstrap templates and d3js charts) [login to view URL] Login for single user (he can view and modify personal data and view his scores), supervisor (he can view data of users of his unit, print a summary or detailed report and modify unit details), administrator (he can view data of all users and supervisor, modify details and data and print summary or detailed report) [login to view URL] data: family name, name, sex, date of birth, place of birth, phone, email, address, qualification, name of institute, unit, state of activity, kind of exposition, classification, starting date, ending date, notes [login to view URL] data Year, kind of scores, kind of measurement, January, February, Mars, April, May, June, July, August, September, October, November, December, elsewhere, annual score [login to view URL] name of institute, city, address, unit, supervisor, address supervisor [login to view URL] Kind of installation, name of institute, unit, model name, model type, kp, ma, load a, load b [login to view URL] Kind of installation, name of institute, unit, model name, model type, date of survey, score places, kv score, ma score, survey scores [login to view URL] management view User can modify or view personal data or view scores of the current year or view scores in a selected period of time. Time unit is defined in months or years. User: For each user there are one or two kind of scores and the both have to be visible in a grid and at same time in two bar graphs. The bar graphs should have a superimpression of two lines (through the bars) indicating the mean and the maximum of the scores regarding the specific unit and the specific institute of the user selected. Supervisor: Supervisor can insert, modify and view personal and view scores data of all users supervised by him. the information of all users supervised by this supervisor is shown in a grid panel and two bar graphs for the two kind of scores for each user in the current year or in a specific period of time. The two bar graphs have to shows which users have received the minimum and which the maximum monthly scores of the current year, compared to the mean. Supervisor can select an user and view information of the single user (personal and scores data). There are another chart like ([login to view URL]) where columns are month (current year or selected period) and rows are users. Administrator: Administrator can insert, modify and view personal and scores data of all users (of all supervisors) in the same kind for supervisors (subdivided by supervisors and institute). There are two threshold values (one for each kind of scores) in order to select all the user that have scores higher than the value and highlight that users and theirs higher values. Administrator can view also view two bar graphs for the two kind of scores where are shown minimum, mean and higher value of each institute. [login to view URL] management Administrator can also view installation data related to institutes, scores and users and modify appointment on a calendar for each installations. (appointment should be shareable with googlecalendar) Should also possible to insert, view or modify survey values while the institute and installation should be selctable. [login to view URL] a report User can print a report in a pdf formatted following a specific model where are highlighted personal data, institute and score data of user and some notes. In case of supervisor it should be possible to print this report as a summary and as a list of users (a unique pdf containing the reports of all user supervised from the first to the last user, one per page). In the same fancy the administrator will print a report with all the users as a summary subdivided by institute and supervisors and a report as a list of users. Administrator can also print report of installation management.