Changes between Version 5 and Version 6 of AdvancedReports
- Timestamp:
- 08/07/26 16:27:34 (23 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v5 v6 15 15 total_revenue NUMERIC 16 16 ) AS $$ 17 #variable_conflict use_column17 #variable_conflict use_column 18 18 BEGIN 19 19 RETURN QUERY … … 25 25 FROM enrollment e 26 26 LEFT JOIN payment p 27 ON p.enrollment_id = e.enrollment_id28 AND p.payment_status = 'completed' -- само наплатените пари се промет27 ON p.enrollment_id = e.enrollment_id 28 AND p.payment_status = 'completed' -- само наплатените пари се промет 29 29 GROUP BY 30 30 EXTRACT(YEAR FROM e.purchase_date), … … 54 54 average_rating NUMERIC 55 55 ) AS $$ 56 #variable_conflict use_column56 #variable_conflict use_column 57 57 BEGIN 58 58 RETURN QUERY … … 74 74 FROM course c 75 75 JOIN course_translate ct ON c.course_id = ct.course_id 76 JOIN language l ON l.id = ct.language_id AND l.value = 'en'76 JOIN language l ON l.id = ct.language_id 77 77 JOIN course_version cv ON c.course_id = cv.course_id 78 78 JOIN enrollment e ON cv.course_version_id = e.course_version_id … … 111 111 avg_lecture_completion_percentage NUMERIC 112 112 ) AS $$ 113 #variable_conflict use_column113 #variable_conflict use_column 114 114 BEGIN 115 115 RETURN QUERY … … 140 140 END), 0)::INTEGER AS avg_days_to_complete, 141 141 COALESCE( 142 ROUND(100.0 * COUNT(CASE WHEN e.completion_date IS NOT NULL THEN e.enrollment_id END)::NUMERIC143 / NULLIF(COUNT(e.enrollment_id), 0), 2),144 0)::NUMERIC AS completion_rate_percentage,142 ROUND(100.0 * COUNT(CASE WHEN e.completion_date IS NOT NULL THEN e.enrollment_id END)::NUMERIC 143 / NULLIF(COUNT(e.enrollment_id), 0), 2), 144 0)::NUMERIC AS completion_rate_percentage, 145 145 COALESCE(ROUND(AVG(lp.completed_percentage), 2), 0)::NUMERIC AS avg_lecture_completion_percentage 146 146 FROM course c … … 172 172 total_reviews BIGINT 173 173 ) AS $$ 174 #variable_conflict use_column174 #variable_conflict use_column 175 175 BEGIN 176 176 RETURN QUERY
