1 files changed, 25 insertions, 0 deletions
diff --git a/app/graphql/types/time_tracking/timelog_connection_type.rb b/app/graphql/types/time_tracking/timelog_connection_type.rb
new file mode 100644
index 00000000000..43e6955c2a3
--- /dev/null
+++ b/app/graphql/types/time_tracking/timelog_connection_type.rb
@@ -0,0 +1,25 @@
+# frozen_string_literal: true
+
+module Types
+  module TimeTracking
+    # rubocop: disable Graphql/AuthorizeTypes
+    class TimelogConnectionType < CountableConnectionType
+      field :total_spent_time,
+            GraphQL::Types::Int,
+            null: false,
+            description: 'Total time spent in seconds.'
+
+      def total_spent_time
+        # rubocop: disable CodeReuse/ActiveRecord
+        relation = object.items
+
+        # sometimes relation is an Array
+        relation = relation.reorder(nil) if relation.respond_to?(:reorder)
+        # rubocop: enable CodeReuse/ActiveRecord
+
+        relation.sum(:time_spent)
+      end
+    end
+    # rubocop: enable Graphql/AuthorizeTypes
+  end
+end