fix userdata export for consultations, fixes #762

1 files changed, 14 insertions, 3 deletions

diff --git a/lib/modules/ConsultationModule.class.php b/lib/modules/ConsultationModule.class.php
index 3154977..e77b79a 100644
--- a/lib/modules/ConsultationModule.class.php
+++ b/lib/modules/ConsultationModule.class.php
@@ -121,7 +121,7 @@ class ConsultationModule extends CorePlugin implements StudipModule, SystemPlugi
                 function ($block) {
                     return $block->toRawArray();
                 },
-                "teacher_id = :user_id OR (range_id = :user_id AND range_type = 'user')",
+                "range_id = :user_id AND range_type = 'user'",
                 [':user_id' => $storage->user_id]
             )
         );
@@ -132,8 +132,19 @@ class ConsultationModule extends CorePlugin implements StudipModule, SystemPlugi
                 function ($booking) {
                     return $booking->toRawArray();
                 },
-                'user_id = ?',
-                [$storage->user_id]
+                'user_id = :user_id',
+                [':user_id' => $storage->user_id]
+            )
+        );
+        $storage->addTabularData(
+            _('Terminverantwortlichkeiten'),
+            'consultation_responsibilities',
+            ConsultationResponsibility::findAndMapBySQL(
+                function ($responsibility) {
+                    return $responsibility->toRawArray();
+                },
+                "range_id = :user_id AND range_type = 'user'",
+                [':user_id' => $storage->user_id]
             )
         );
     }