Changes between Initial Version and Version 1 of otherdevelopment

Timestamp:

01/31/26 16:29:52 (28 hours ago)

Author:

231175

Comment:

--

otherdevelopment

@@ +1 @@
+= Други Развојни Активности =
+
+== Анализа на перформанси ==
+
+=== Извештај за најпопуларни курсеви според оценка ===
+
+'''SQL:'''
+{{{
+SELECT 
+    c.id AS course_id,
+    ct.title_short AS course_title,
+    cv.version_number AS course_version,
+    cv.active AS is_active,
+    COUNT(DISTINCT e.id) AS total_enrollments,
+    SUM(r.rating) / COUNT(r.id) AS average_rating,
+    COUNT(r.id) AS total_reviews
+FROM course c
+JOIN course_translate ct ON c.id = ct.course_id
+JOIN course_version cv ON c.id = cv.course_id
+JOIN enrollment e ON cv.id = e.course_version_id
+JOIN review r ON e.id = r.enrollment_id
+WHERE ct.language = :language
+GROUP BY c.id, ct.id, cv.id
+ORDER BY SUM(r.rating) / COUNT(r.id) DESC
+}}}
+
+'''Индекси:'''
+ - Сите примарни клучеви (по default): course_id, course_translate_id, course_version_id, enrollment_id, review_id
+ - Во Course Translate: course_id, {course_id, language}
+{{{
+CREATE UNIQUE INDEX uk_course_translate_course_language ON course_translate(course_id, language)
+}}}