Changes between Version 10 and Version 11 of WikiStart/AdvancedReports

Timestamp:

01/29/24 14:10:20 (12 months ago)

Author:

121232

Comment:

--

WikiStart/AdvancedReports

@@ -205 +205 @@
 == **[[span(style=color: #BF1B1B, 5. Листање(приказ) на сите евенти за одреден семестар:)]]**
 
+
+{{{
+DECLARE correct_student_id INT;
+SET correct_student_id = 11111;
+
+SELECT 
+ ce.calendar_event_id,
+ ce.event_name,
+ ce.event_type,
+ ce.event_description,
+ ce.event_start_time,
+ ce.event_end_time
+FROM
+ calendar_event ce
+JOIN
+ term t ON ce.starting_year = t.starting_year
+ AND ce.finishing_year = t.finishing_year
+ AND ce.term_type = t.term_type
+WHERE t.student_id = correct_student_id
+  AND t.starting_year = 2023
+  AND t.finishing_year = 2024
+  AND t.term_type = 'Zimski';
+}}}
+
+
 == **[[span(style=color: #BF1B1B, 6. Листање(приказ) на сите евенти и task-ови за зададен предмет:)]]**
+
+
+{{{
+DECLARE correct_student_id INT;
+SET correct_student_id = 11111;
+
+SELECT
+    ce.calendar_event_id,
+    ce.event_name,
+    ce.event_type,
+    ce.event_description,
+    ce.event_start_time,
+    ce.event_end_time,
+    NULL AS task_id,
+    NULL AS task_name,
+    NULL AS task_description,
+    NULL AS task_priority,
+    NULL AS is_done
+FROM
+    subject_event se
+    JOIN calendar_event ce ON se.calendar_event_id = ce.calendar_event_id
+WHERE
+    se.term_subject_id = 170569
+UNION
+SELECT
+    NULL AS calendar_event_id,
+    NULL AS event_name,
+    NULL AS event_type,
+    NULL AS event_description,
+    NULL AS event_start_time,
+    NULL AS event_end_time,
+    t.task_id,
+    t.task_name,
+    t.task_description,
+    t.task_priority,
+    t.is_done
+FROM
+    creates_task ct
+JOIN 
+    task t ON ct.task_id = t.task_id
+WHERE
+    ct.term_subject_id = 170569;
+
+
+
+}}}
+
 
 == **[[span(style=color: #BF1B1B, 7. Листање(приказ) на сите на сите книги и автори по одреден предмет (пример:Бази на податоци):)]]**