pmPaulis · Sep 30, 2024 · Sep 25, 2024 · Sep 26, 2024 · Sep 26, 2024 · Sep 26, 2024
diff --git a/ProcessMaker/Http/Controllers/Api/ProcessRequestController.php b/ProcessMaker/Http/Controllers/Api/ProcessRequestController.php
@@ -839,4 +839,44 @@ public function endEventDestination(ProcessRequest $request)
 
         return response()->json(['message' => __('End event found'), 'data' => $data]);
     }
+
+    /**
+     * This endpoint returns requests by case number
+     *  
+     * @param Request $request
+     *
+     * @return ApiCollection
+     */
+    public function getRequestsByCase(Request $request)
+    {
+        $user = Auth::user();
+
+        $case_number = $request->input('case_number', 0);
+        $query = ProcessRequest::forUser($user);
+        $includes = $request->input('include', '');
+        foreach (array_filter(explode(',', $includes)) as $include) {
+            if (in_array($include, ProcessRequest::$allowedIncludes)) {
+                $query->with($include);
+            }
+        }
+
+        if ($advancedFilter = $request->input('advanced_filter', '')) {
+            Filter::filter($query, $advancedFilter);
+        }
+
+        $response = $query->where('case_number', $case_number)
+            ->orderBy(
+                str_ireplace('.', '->', $request->input('order_by', 'name')),
+                $request->input('order_direction', 'ASC')
+            )
+            ->select('process_requests.*')
+            ->withAggregate('processVersion', 'alternative')
+            ->paginate($request->input('per_page', 10));
+
+        $response = $response->map(function ($processRequest) use ($request) {
+            return new ProcessRequestResource($processRequest);
+        });
+
+        return new ApiCollection($response);
+    }
 }
diff --git a/routes/api.php b/routes/api.php
@@ -215,6 +215,7 @@
 
     // Cases
     //Route::get('cases', [ProcessRequestController::class, 'index'])->name('cases.index');
+    Route::get('requests-by-case', [ProcessRequestController::class, 'getRequestsByCase'])->name('requests.getRequestsByCase');
     // Requests
     Route::get('requests', [ProcessRequestController::class, 'index'])->name('requests.index'); // Already filtered in controller
     Route::get('requests/{process}/count', [ProcessRequestController::class, 'getCount'])->name('requests.count');

diff --git a/tests/Feature/Api/ProcessRequestsTest.php b/tests/Feature/Api/ProcessRequestsTest.php
@@ -986,4 +986,32 @@ public function testScreenRequested()
         $data = $response->json()['data'];
         $this->assertEmpty($data);
     }
+
+    /**
+     * Get a list of Requests by Cases.
+     */
+    public function testRequestByCase()
+    {
+        ProcessRequest::query()->delete();
+        $request = ProcessRequest::factory()->create();
+        ProcessRequest::factory()->count(9)->create([
+            'parent_request_id' => $request->id,
+        ]);
+
+        $url = '/requests-by-case?case_number=' . $request->case_number;
+
+        $response = $this->apiCall('GET', $url);
+
+        //Validate the header status code
+        $response->assertStatus(200);
+
+        // Verify structure
+        $response->assertJsonStructure([
+            'data' => ['*' => self::STRUCTURE],
+            'meta',
+        ]);
+
+        // Verify count
+        $this->assertEquals(10, $response->json()['meta']['total']);
+    }
 }