|
6 | 6 | use Illuminate\Auth\Access\AuthorizationException; |
7 | 7 | use Illuminate\Http\Request; |
8 | 8 | use Illuminate\Support\Facades\Auth; |
| 9 | +use Illuminate\Support\Facades\DB; |
9 | 10 | use Illuminate\Support\Facades\Hash; |
10 | 11 | use ProcessMaker\Events\UserCreated; |
11 | 12 | use ProcessMaker\Events\UserDeleted; |
@@ -140,6 +141,70 @@ public function index(Request $request) |
140 | 141 | return new ApiCollection($response); |
141 | 142 | } |
142 | 143 |
|
| 144 | + /** |
| 145 | + * Display a listing of users and their task counts. |
| 146 | + * |
| 147 | + * @param \Illuminate\Http\Request $request |
| 148 | + * @return \Illuminate\Http\Response |
| 149 | + * |
| 150 | + * @OA\Get( |
| 151 | + * path="/users_count_tasks", |
| 152 | + * summary="Returns all users and their total tasks", |
| 153 | + * operationId="getUsersTaskCount", |
| 154 | + * tags={"Users"}, |
| 155 | + * @OA\Parameter( |
| 156 | + * name="filter", |
| 157 | + * in="query", |
| 158 | + * description="Filter results by string. Searches First Name, Last Name, Email, or Username.", |
| 159 | + * @OA\Schema(type="string"), |
| 160 | + * ), |
| 161 | + * @OA\Response( |
| 162 | + * response=200, |
| 163 | + * description="List of users with task counts", |
| 164 | + * @OA\JsonContent( |
| 165 | + * type="object", |
| 166 | + * @OA\Property( |
| 167 | + * property="data", |
| 168 | + * type="array", |
| 169 | + * @OA\Items(ref="#/components/schemas/users"), |
| 170 | + * ), |
| 171 | + * @OA\Property( |
| 172 | + * property="meta", |
| 173 | + * type="object", |
| 174 | + * ref="#/components/schemas/metadata", |
| 175 | + * ), |
| 176 | + * ), |
| 177 | + * ), |
| 178 | + * ) |
| 179 | + */ |
| 180 | + public function getUsersTaskCount(Request $request) |
| 181 | + { |
| 182 | + $query = User::nonSystem(); |
| 183 | + |
| 184 | + $filter = $request->input('filter', ''); |
| 185 | + if (!empty($filter)) { |
| 186 | + $filter = '%' . $filter . '%'; |
| 187 | + $query->where(function ($query) use ($filter) { |
| 188 | + $query->where('username', 'like', $filter) |
| 189 | + ->orWhere('firstname', 'like', $filter) |
| 190 | + ->orWhere('lastname', 'like', $filter); |
| 191 | + }); |
| 192 | + } |
| 193 | + |
| 194 | + $query->where('status', 'ACTIVE'); |
| 195 | + |
| 196 | + $query->select('*', DB::Raw("(SELECT COUNT(id) FROM process_request_tokens WHERE user_id=users.id AND status='ACTIVE' AND element_type='task') AS count")); |
| 197 | + $query->groupBy('users.id'); |
| 198 | + |
| 199 | + $response = $query->orderBy( |
| 200 | + $request->input('order_by', 'username'), |
| 201 | + $request->input('order_direction', 'ASC') |
| 202 | + ) |
| 203 | + ->paginate(50); |
| 204 | + |
| 205 | + return new ApiCollection($response); |
| 206 | + } |
| 207 | + |
143 | 208 | /** |
144 | 209 | * Store a newly created resource in storage. |
145 | 210 | * |
|
0 commit comments