Index: src/main/java/apps/spring/reportium/entity/DTOs/ReportFilterDTO.java =================================================================== --- src/main/java/apps/spring/reportium/entity/DTOs/ReportFilterDTO.java (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/java/apps/spring/reportium/entity/DTOs/ReportFilterDTO.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -78,64 +78,4 @@ StringBuilder sb = new StringBuilder(); sb.append("Report Filter: ").append(filter_selected.toString()).append("\n"); - //TODO the advanced filter description -// switch (filter_selected) { -// case PERSON: -// sb.append("Person: ").append(person_name_string).append(" ").append(person_surname_string).append("\n"); -// if (correct_age != null && correct_age > 0) { -// sb.append("Correct Age: ").append(correct_age); -// -// } else if (age_start != null && age_start > 0 && age_end != null && age_end < 120) { -// sb.append("Age Range [").append(age_start).append(",").append(age_end).append("] ").append("\n"); -// } -// sb.append("Gender: ").append(gender.toString()).append("\n"); -// sb.append("Address: ").append(address_string).append("\n"); -// if (getIs_alive().equals(Boolean.TRUE)) { -// sb.append("alive").append("\n"); -// } else { -// sb.append("dead").append("\n"); -// } -// break; -// case ACADEMIC: -// sb.append("Academic Field: ").append(academic_field).append("\n"); -// sb.append("Institution Type: ").append(institution_type.toString()).append("\n"); -// break; -// case EMPLOYMENT: -// if (income_comparison != null && income_amount != null && income_amount > 0) -// sb.append("Income ").append(income_comparison).append(" ").append(income_amount).append(" EUR\n"); -// if (years_experience_comparison != null && years_experience != null && years_experience > 0) -// sb.append("Experience ").append(years_experience_comparison).append(" ") -// .append(years_experience).append(" years\n"); -// break; -// -// case CRIMINAL: -// if (crime_type_label != null && !crime_type_label.isBlank()) -// sb.append("Crime Type: ").append(crime_type_label).append("\n"); -// if (crime_severity_level != null) -// sb.append("Severity Level: ").append(crime_severity_level).append("\n"); -// if (is_resolved != null) -// sb.append("Resolved: ").append(is_resolved ? "Yes" : "No").append("\n"); -// -// if (punishment_type != null) { -// sb.append("Punishment: ").append(punishment_type).append(" "); -// if (punishment_type == PunishmentType.FINE && punishment_fine != null) -// sb.append(punishment_fine).append(" EUR\n"); -// else if (punishment_type == PunishmentType.PRISON && punishment_years != null) -// sb.append(punishment_years).append(" years\n"); -// } -// break; -// -// case MEDICAL: -// if (doctor_name_string != null && !doctor_name_string.isBlank()) -// sb.append("Doctor Name: ").append(doctor_name_string).append("\n"); -// if (doctor_surname_string != null && !doctor_surname_string.isBlank()) -// sb.append("Doctor Surname: ").append(doctor_surname_string).append("\n"); -// if (specialization != null) -// sb.append("Specialization: ").append(specialization).append("\n"); -// if (is_chronic != null) -// sb.append("Chronic Illness: ").append(is_chronic ? "Yes" : "No").append("\n"); -// if (has_next_control != null) -// sb.append("Next Control Scheduled: ").append(has_next_control ? "Yes" : "No").append("\n"); -// break; -// } return sb.toString(); } Index: src/main/java/apps/spring/reportium/entity/DTOs/ReportStatisticsPerPersonDTO.java =================================================================== --- src/main/java/apps/spring/reportium/entity/DTOs/ReportStatisticsPerPersonDTO.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) +++ src/main/java/apps/spring/reportium/entity/DTOs/ReportStatisticsPerPersonDTO.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -0,0 +1,65 @@ +package apps.spring.reportium.entity.DTOs; +import lombok.Data; +import java.math.BigDecimal; +import java.sql.Date; +//fixme +@Data +public class ReportStatisticsPerPersonDTO { + // General + private Long totalReportsFound; + private Date firstReportOfPerson; + private Date latestReportOfPerson; + // Academic + private Long academicTotal; + private String mostCommonField; + private String educationPath; + // Employment + private Long jobCount; + private Long totalWorkingInDays; + private Long totalWorkingInMonths; + private Long totalWorkingInYears; + private Long longestJobDays; + private Double maxIncomeFromJob; + // Medical + private Long diagnosisTotal; + private Double chronicRatio; + private String mostFrequentDiagnosis; + // Criminal + private Long criminalCaseTotal; + private Double resolutionRatio; + public ReportStatisticsPerPersonDTO(Long totalReportsFound, + Date firstReportOfPerson, + Date latestReportOfPerson, + Long academicTotal, + String mostCommonField, + String educationPath, + Long jobCount, + Long totalWorkingInDays, + Long totalWorkingInMonths, + Long totalWorkingInYears, + Long longestJobDays, + Double maxIncomeFromJob, + Long diagnosisTotal, + Double chronicRatio, + String mostFrequentDiagnosis, + Long criminalCaseTotal, + Double resolutionRatio) { + this.totalReportsFound = totalReportsFound; + this.firstReportOfPerson = firstReportOfPerson; + this.latestReportOfPerson = latestReportOfPerson; + this.academicTotal = academicTotal; + this.mostCommonField = mostCommonField; + this.educationPath = educationPath; + this.jobCount = jobCount; + this.totalWorkingInDays = totalWorkingInDays; + this.totalWorkingInMonths = totalWorkingInMonths; + this.totalWorkingInYears = totalWorkingInYears; + this.longestJobDays = longestJobDays; + this.maxIncomeFromJob = maxIncomeFromJob; + this.diagnosisTotal = diagnosisTotal; + this.chronicRatio = chronicRatio; + this.mostFrequentDiagnosis = mostFrequentDiagnosis; + this.criminalCaseTotal = criminalCaseTotal; + this.resolutionRatio = resolutionRatio; + } +} Index: src/main/java/apps/spring/reportium/repository/ReportRepository.java =================================================================== --- src/main/java/apps/spring/reportium/repository/ReportRepository.java (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/java/apps/spring/reportium/repository/ReportRepository.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -17,40 +17,141 @@ @Query(value = """ - SELECT r.report_id, academic_field, description_of_report, i.name, i.type, i.address, i.year_established - FROM report r - JOIN academicreport ar ON ar.report_id = r.report_id - JOIN institution i ON i.institution_id = ar.institution_id - WHERE r.person_id = :personId - """, nativeQuery = true) + SELECT r.report_id, academic_field, description_of_report, i.name, i.type, i.address, i.year_established + FROM report r + JOIN academicreport ar ON ar.report_id = r.report_id + JOIN institution i ON i.institution_id = ar.institution_id + WHERE r.person_id = :personId + """, nativeQuery = true) List getAcademicReportsByPersonId(@Param("personId") Long personId); @Query(value = """ - SELECT r.report_id, summary, er.start_date, er.end_date, job_role, income_per_month - FROM report r - JOIN employmentreport er ON er.report_id = r.report_id - WHERE r.person_id = :personId - """, nativeQuery = true) + SELECT r.report_id, summary, er.start_date, er.end_date, job_role, income_per_month + FROM report r + JOIN employmentreport er ON er.report_id = r.report_id + WHERE r.person_id = :personId + """, nativeQuery = true) List getEmploymentReportsByPersonId(@Param("personId") Long personId); @Query(value = """ - SELECT r.report_id, summary, next_control_date, d.short_description, d.therapy, d.severity, d.is_chronic, - doc.name, doc.surname, doc.specialization - FROM report r - JOIN medicalreport mr ON mr.report_id = r.report_id - JOIN medicalreport_diagnosis mrd ON mr.report_id = mrd.report_id - JOIN diagnosis d ON mrd.diagnosis_id = d.diagnosis_id - JOIN doctor doc ON doc.doctor_id = mr.doctor_id - WHERE r.person_id = :personId - """, nativeQuery = true) + SELECT r.report_id, summary, next_control_date, d.short_description, d.therapy, d.severity, d.is_chronic, + doc.name, doc.surname, doc.specialization + FROM report r + JOIN medicalreport mr ON mr.report_id = r.report_id + JOIN medicalreport_diagnosis mrd ON mr.report_id = mrd.report_id + JOIN diagnosis d ON mrd.diagnosis_id = d.diagnosis_id + JOIN doctor doc ON doc.doctor_id = mr.doctor_id + WHERE r.person_id = :personId + """, nativeQuery = true) List getMedicalReportsByPersonId(@Param("personId") Long personId); @Query(value = """ - SELECT r.report_id, label, severity_level, location, resolved, descriptive_punishment - FROM report r - JOIN criminalreport cr ON cr.report_id = r.report_id - JOIN crimetype ct ON cr.crime_type_id = ct.crime_type_id - WHERE r.person_id = :personId - """, nativeQuery = true) + SELECT r.report_id, label, severity_level, location, resolved, descriptive_punishment + FROM report r + JOIN criminalreport cr ON cr.report_id = r.report_id + JOIN crimetype ct ON cr.crime_type_id = ct.crime_type_id + WHERE r.person_id = :personId + """, nativeQuery = true) List getCriminalReportsByPersonId(@Param("personId") Long personId); + + @Query(value = """ + WITH + selected_person_reports AS ( + SELECT * FROM report WHERE person_id = :person_id + ), + + academic AS ( + SELECT r.created_at, ar.academic_field, ar.report_id + FROM report r + JOIN academicreport ar ON r.report_id = ar.report_id + JOIN institution i ON i.institution_id = ar.institution_id + WHERE r.person_id = :person_id + ), + + employment AS ( + SELECT e.start_date, COALESCE(e.end_date, CURRENT_DATE) AS end_date, e.income_per_month + FROM employmentreport e + JOIN report r ON r.report_id = e.report_id + WHERE r.person_id = :person_id + ), + + medical AS ( + SELECT d.short_description, d.is_chronic + FROM report r + JOIN medicalreport mr ON r.report_id = mr.report_id + JOIN medicalreport_diagnosis mrd ON mrd.report_id = mr.report_id + JOIN diagnosis d ON d.diagnosis_id = mrd.diagnosis_id + WHERE r.person_id = :person_id + ), + + criminal AS ( + SELECT cr.descriptive_punishment, cr.resolved as is_resolved + FROM report r + JOIN criminalreport cr ON r.report_id = cr.report_id + JOIN crimetype ct ON ct.crime_type_id = cr.crime_type_id + WHERE r.person_id = :person_id + ), + + ordered_academic_reports_by_date AS ( + SELECT + ar.academic_field, + r.created_at, + ROW_NUMBER() OVER (PARTITION BY ar.academic_field ORDER BY r.created_at) AS row_num + FROM report r + JOIN academicreport ar ON ar.report_id = r.report_id + WHERE r.person_id = :person_id + ), + + filtered_academic_pathway AS ( + SELECT academic_field, MIN(created_at) AS started_on + FROM ordered_academic_reports_by_date + GROUP BY academic_field + ), + + employment_report_stats AS ( + SELECT + CAST(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) AS BIGINT) AS total_working_in_days, + CAST(CEIL(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) / 30.0) AS BIGINT) AS total_working_in_months, + CAST(CEIL(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) / 365.0) AS BIGINT) AS total_working_in_years, + CAST(MAX(COALESCE(e.end_date, CURRENT_DATE) - e.start_date) AS BIGINT) AS longest_job_days + FROM employmentreport e + JOIN report r ON r.report_id = e.report_id + WHERE r.person_id = :person_id + ) + SELECT + -- General + CAST((SELECT COUNT(*) FROM selected_person_reports) AS BIGINT) AS total_reports_found, + CAST((SELECT created_at::date FROM selected_person_reports ORDER BY created_at ASC LIMIT 1) AS DATE) AS first_report_of_person, + CAST((SELECT created_at::date FROM selected_person_reports ORDER BY created_at DESC LIMIT 1) AS DATE) AS latest_report_of_person, + -- Academic + CAST((SELECT COUNT(*) FROM academic) AS BIGINT) AS academic_total, + CAST((SELECT academic_field + FROM academic + GROUP BY academic_field + ORDER BY COUNT(*) DESC + LIMIT 1) AS TEXT) AS most_common_field, + CAST((SELECT STRING_AGG(academic_field, ' → ' ORDER BY started_on) + FROM filtered_academic_pathway) AS TEXT) AS education_path, + -- Employment + CAST((SELECT COUNT(*) FROM employment) AS BIGINT) AS job_count, + (SELECT total_working_in_days FROM employment_report_stats), + (SELECT total_working_in_months FROM employment_report_stats), + (SELECT total_working_in_years FROM employment_report_stats), + (SELECT longest_job_days FROM employment_report_stats), + CAST((SELECT MAX(income_per_month) FROM employment) AS DOUBLE PRECISION) AS max_income_from_job, + -- Medical + CAST((SELECT COUNT(*) FROM medical) AS BIGINT) AS diagnosis_total, + CAST((SELECT ROUND(SUM(CASE WHEN is_chronic THEN 1 ELSE 0 END)::decimal / COUNT(*), 2) + FROM medical) AS DOUBLE PRECISION) AS chronic_ratio, + CAST((SELECT short_description + FROM medical + GROUP BY short_description + ORDER BY COUNT(*) DESC + LIMIT 1) AS TEXT) AS most_frequent_diagnosis, + -- Criminal + CAST((SELECT COUNT(*) FROM criminal) AS BIGINT) AS criminal_case_total, + CAST((SELECT ROUND(SUM(CASE WHEN is_resolved THEN 1 ELSE 0 END)::decimal / COUNT(*), 2) + FROM criminal) AS DOUBLE PRECISION) AS resolution_ratio + """, nativeQuery = true) + ReportStatisticsPerPersonDTO getStatisticsForPerson(@Param("person_id") Long person_id); Page findAll(Pageable pageable); Index: src/main/java/apps/spring/reportium/repository/ReportViewRepository.java =================================================================== --- src/main/java/apps/spring/reportium/repository/ReportViewRepository.java (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/java/apps/spring/reportium/repository/ReportViewRepository.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -1,18 +1,23 @@ package apps.spring.reportium.repository; +import apps.spring.reportium.entity.DTOs.ReportStatisticsPerPersonDTO; import apps.spring.reportium.entity.DTOs.view_fetching_dtos.*; import apps.spring.reportium.entity.Report; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; +import org.springframework.data.repository.query.Param; import java.util.List; -public interface ReportViewRepository extends JpaRepository { +public interface ReportViewRepository extends JpaRepository { @Query(value = "SELECT * FROM academic_report_view", nativeQuery = true) List getAcademicReportViews(); + @Query(value = "SELECT * FROM employment_report_view", nativeQuery = true) List getEmploymentReportViews(); + @Query(value = "SELECT * FROM medical_report_view", nativeQuery = true) List getMedicalReportViews(); + @Query(value = "SELECT * FROM criminal_report_view", nativeQuery = true) List getCrimeReportViews(); Index: src/main/java/apps/spring/reportium/web/HomeController.java =================================================================== --- src/main/java/apps/spring/reportium/web/HomeController.java (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/java/apps/spring/reportium/web/HomeController.java (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -41,9 +41,11 @@ List person_ar = reportRepository.getAcademicReportsByPersonId(personId); List person_er = reportRepository.getEmploymentReportsByPersonId(personId); - + ReportStatisticsPerPersonDTO statistics_per_person = reportRepository.getStatisticsForPerson(personId); + System.out.println(statistics_per_person); model.addAttribute("medical_reports", person_mr); model.addAttribute("criminal_reports", person_cr); model.addAttribute("academic_reports", person_ar); model.addAttribute("employment_reports", person_er); + model.addAttribute("statistics", statistics_per_person); model.addAttribute("person", person); return "person_reports"; Index: src/main/resources/application.properties =================================================================== --- src/main/resources/application.properties (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/resources/application.properties (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -5,5 +5,4 @@ - #server.error.include-message=always #server.error.include-stacktrace=always Index: src/main/resources/sql_queries/get_statistics_for_person.sql =================================================================== --- src/main/resources/sql_queries/get_statistics_for_person.sql (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) +++ src/main/resources/sql_queries/get_statistics_for_person.sql (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -0,0 +1,99 @@ +WITH + selected_person_reports AS ( + SELECT * FROM report WHERE person_id = :person_id + ), + + academic AS ( + SELECT r.created_at, ar.academic_field, ar.report_id + FROM report r + JOIN academicreport ar ON r.report_id = ar.report_id + JOIN institution i ON i.institution_id = ar.institution_id + WHERE r.person_id = :person_id + ), + + employment AS ( + SELECT e.start_date, COALESCE(e.end_date, CURRENT_DATE) AS end_date, e.income_per_month + FROM employmentreport e + JOIN report r ON r.report_id = e.report_id + WHERE r.person_id = :person_id + ), + + medical AS ( + SELECT d.short_description, d.is_chronic + FROM report r + JOIN medicalreport mr ON r.report_id = mr.report_id + JOIN medicalreport_diagnosis mrd ON mrd.report_id = mr.report_id + JOIN diagnosis d ON d.diagnosis_id = mrd.diagnosis_id + WHERE r.person_id = :person_id + ), + + criminal AS ( + SELECT cr.descriptive_punishment, cr.resolved as is_resolved + FROM report r + JOIN criminalreport cr ON r.report_id = cr.report_id + JOIN crimetype ct ON ct.crime_type_id = cr.crime_type_id + WHERE r.person_id = :person_id + ), + + ordered_academic_reports_by_date AS ( + SELECT + ar.academic_field, + r.created_at, + ROW_NUMBER() OVER (PARTITION BY ar.academic_field ORDER BY r.created_at) AS row_num + FROM report r + JOIN academicreport ar ON ar.report_id = r.report_id + WHERE r.person_id = :person_id + ), + + filtered_academic_pathway AS ( + SELECT academic_field, MIN(created_at) AS started_on + FROM ordered_academic_reports_by_date + GROUP BY academic_field + ), + + employment_report_stats AS ( + SELECT + CAST(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) AS BIGINT) AS total_working_in_days, + CAST(CEIL(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) / 30.0) AS BIGINT) AS total_working_in_months, + CAST(CEIL(SUM(ABS(COALESCE(e.end_date, CURRENT_DATE) - e.start_date)) / 365.0) AS BIGINT) AS total_working_in_years, + CAST(MAX(COALESCE(e.end_date, CURRENT_DATE) - e.start_date) AS BIGINT) AS longest_job_days + FROM employmentreport e + JOIN report r ON r.report_id = e.report_id + WHERE r.person_id = :person_id + ) +SELECT + -- General + CAST((SELECT COUNT(*) FROM selected_person_reports) AS BIGINT) AS total_reports_found, + CAST((SELECT created_at::date FROM selected_person_reports ORDER BY created_at ASC LIMIT 1) AS DATE) AS first_report_of_person, + CAST((SELECT created_at::date FROM selected_person_reports ORDER BY created_at DESC LIMIT 1) AS DATE) AS latest_report_of_person, + -- Academic + CAST((SELECT COUNT(*) FROM academic) AS BIGINT) AS academic_total, + CAST((SELECT academic_field + FROM academic + GROUP BY academic_field + ORDER BY COUNT(*) DESC + LIMIT 1) AS TEXT) AS most_common_field, + CAST((SELECT STRING_AGG(academic_field, ' → ' ORDER BY started_on) + FROM filtered_academic_pathway) AS TEXT) AS education_path, + -- Employment + CAST((SELECT COUNT(*) FROM employment) AS BIGINT) AS job_count, + (SELECT total_working_in_days FROM employment_report_stats), + (SELECT total_working_in_months FROM employment_report_stats), + (SELECT total_working_in_years FROM employment_report_stats), + (SELECT longest_job_days FROM employment_report_stats), + CAST((SELECT MAX(income_per_month) FROM employment) AS DOUBLE PRECISION) AS max_income_from_job, + -- Medical + CAST((SELECT COUNT(*) FROM medical) AS BIGINT) AS diagnosis_total, + CAST((SELECT ROUND(SUM(CASE WHEN is_chronic THEN 1 ELSE 0 END)::decimal / COUNT(*), 2) + FROM medical) AS DOUBLE PRECISION) AS chronic_ratio, + CAST((SELECT short_description + FROM medical + GROUP BY short_description + ORDER BY COUNT(*) DESC + LIMIT 1) AS TEXT) AS most_frequent_diagnosis, + -- Criminal + CAST((SELECT COUNT(*) FROM criminal) AS BIGINT) AS criminal_case_total, + CAST((SELECT ROUND(SUM(CASE WHEN is_resolved THEN 1 ELSE 0 END)::decimal / COUNT(*), 2) + FROM criminal) AS DOUBLE PRECISION) AS resolution_ratio; + +--this is a complicated query with a chain of CTE used, so I can fetch some statistics from the reports for a person provided Index: src/main/resources/templates/filter_panel.html =================================================================== --- src/main/resources/templates/filter_panel.html (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/resources/templates/filter_panel.html (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -55,5 +55,6 @@
-
+

Advanced Filtering Page

@@ -141,5 +142,6 @@
-
+
@@ -165,5 +167,6 @@
-
+
@@ -214,5 +217,6 @@
-
+
Index: src/main/resources/templates/person_reports.html =================================================================== --- src/main/resources/templates/person_reports.html (revision 2e508222ba47efc03e81166443c7dc292f3c90d3) +++ src/main/resources/templates/person_reports.html (revision 7ef8fdbf77f56c14cd7d38d8f0f0bae06aedfad4) @@ -5,86 +5,408 @@ Person Reports + + + +
- - -

+ +

+ Reports for Person +

-

Criminal Reports—(total --> )

+
+
+ +
+
+

Criminal Reports

+

Legal proceedings and criminal activity records

+
+
+
-
-
+
+ +
+ No criminal reports found +
+
+
+
- +
@@ -93,12 +415,19 @@ - + - + - + @@ -111,11 +440,26 @@
-

Academic Reports—(total --> )

+
+
+ +
+
+

Academic Reports

+

Educational achievements and academic history

+
+
+
-
-
+
+ +
+ No academic reports found +
+
+
+
-
Resolved SeverityDescription of PunishmentPunishment
+ + Yes + + + No + +
+
@@ -124,14 +468,15 @@ - - + + - - + - + @@ -145,16 +490,31 @@
-

Employment Reports—(total --> )

+
+
+ +
+
+

Employment Reports

+

Professional work history and employment records

+
+
+
-
-
+
+ +
+ No employment reports found +
+
+
+
-
Field InstitutionInstitution AddressEstablished AtAddressEstablished
+ +
+
- + @@ -163,9 +523,11 @@ - + - - + @@ -178,11 +540,26 @@
-

Medical Reports—(total --> )

+
+
+ +
+
+

Medical Reports

+

Health records and medical history

+
+
+
-
-
+
+ +
+ No medical reports found +
+
+
+
-
Report ID Job RoleStart DateDuration Income Summary
+ +
+
+
@@ -191,20 +568,31 @@ - + - + - - + + - - - - + + + + @@ -212,7 +600,129 @@ - Back to Dashboard - + + +
+

+ + Report Summary Statistics +

+ +
+ +
+

+ General Overview +

+
+ Total Reports + 0 +
+
+ First Report Date + N/A +
+
+ Latest Report Date + N/A +
+
+ + +
+

+ Academic Summary +

+
+ Total Academic Reports + 0 +
+
+ Most Common Field + N/A +
+
+ Education Path + N/A +
+
+ + +
+

+ Employment Summary +

+
+ Total Jobs + 0 +
+
+ Total Working Days + N/A +
+
+ Total Working Months + N/A +
+
+ Total Working Years + N/A +
+
+ Longest Job (days) + N/A +
+
+ Max Monthly Income + N/A +
+
+ + +
+

+ Medical Summary +

+
+ Total Diagnoses + 0 +
+
+ Chronic Condition Ratio + N/A +
+
+ Most Frequent Diagnosis + N/A +
+
+ + +
+

+ Criminal Summary +

+
+ Total Criminal Reports + 0 +
+
+ Resolution Ratio + N/A +
+
+
+
+ + +
+ + + Back to Dashboard + +
+ +
Next Control SummaryDiagnosis DescriptionDiagnosis Therapy SeverityIs it ChronicChronic
Doctor Name + + Not specified + + + Yes + + + No + +