| @@ 376-400 (lines=25) @@ | ||
| 373 | * |
|
| 374 | * @return \Illuminate\Http\Response |
|
| 375 | */ |
|
| 376 | public function viewUsedInProject($project_key, $id) |
|
| 377 | { |
|
| 378 | if ($project_key !== '$_sys_$') |
|
| 379 | { |
|
| 380 | return Response()->json(['ecode' => 0, 'data' => [] ]); |
|
| 381 | } |
|
| 382 | ||
| 383 | $res = []; |
|
| 384 | $projects = Project::all(); |
|
| 385 | foreach($projects as $project) |
|
| 386 | { |
|
| 387 | $screens = Screen::where('field_ids', $id) |
|
| 388 | ->where('project_key', '<>', '$_sys_$') |
|
| 389 | ->where('project_key', $project->key) |
|
| 390 | ->get([ 'id', 'name' ]) |
|
| 391 | ->toArray(); |
|
| 392 | ||
| 393 | if ($screens) |
|
| 394 | { |
|
| 395 | $res[] = [ 'key' => $project->key, 'name' => $project->name, 'status' => $project->status, 'screens' => $screens ]; |
|
| 396 | } |
|
| 397 | } |
|
| 398 | ||
| 399 | return Response()->json(['ecode' => 0, 'data' => $res ]); |
|
| 400 | } |
|
| 401 | } |
|
| 402 | ||
| @@ 282-304 (lines=23) @@ | ||
| 279 | * |
|
| 280 | * @return \Illuminate\Http\Response |
|
| 281 | */ |
|
| 282 | public function viewUsedInProject($project_key, $id) |
|
| 283 | { |
|
| 284 | if ($project_key !== '$_sys_$') |
|
| 285 | { |
|
| 286 | return Response()->json(['ecode' => 0, 'data' => [] ]); |
|
| 287 | } |
|
| 288 | ||
| 289 | $res = []; |
|
| 290 | $projects = Project::all(); |
|
| 291 | foreach($projects as $project) |
|
| 292 | { |
|
| 293 | $count = DB::collection('issue_' . $project->key) |
|
| 294 | ->where('priority', $id) |
|
| 295 | ->where('del_flg', '<>', 1) |
|
| 296 | ->count(); |
|
| 297 | if ($count > 0) |
|
| 298 | { |
|
| 299 | $res[] = [ 'key' => $project->key, 'name' => $project->name, 'status' => $project->status, 'issue_count' => $count ]; |
|
| 300 | } |
|
| 301 | } |
|
| 302 | ||
| 303 | return Response()->json(['ecode' => 0, 'data' => $res ]); |
|
| 304 | } |
|
| 305 | } |
|
| 306 | ||
| @@ 282-304 (lines=23) @@ | ||
| 279 | * |
|
| 280 | * @return \Illuminate\Http\Response |
|
| 281 | */ |
|
| 282 | public function viewUsedInProject($project_key, $id) |
|
| 283 | { |
|
| 284 | if ($project_key !== '$_sys_$') |
|
| 285 | { |
|
| 286 | return Response()->json(['ecode' => 0, 'data' => [] ]); |
|
| 287 | } |
|
| 288 | ||
| 289 | $res = []; |
|
| 290 | $projects = Project::all(); |
|
| 291 | foreach($projects as $project) |
|
| 292 | { |
|
| 293 | $count = DB::collection('issue_' . $project->key) |
|
| 294 | ->where('resolution', $id) |
|
| 295 | ->where('del_flg', '<>', 1) |
|
| 296 | ->count(); |
|
| 297 | if ($count > 0) |
|
| 298 | { |
|
| 299 | $res[] = [ 'key' => $project->key, 'name' => $project->name, 'status' => $project->status, 'issue_count' => $count ]; |
|
| 300 | } |
|
| 301 | } |
|
| 302 | ||
| 303 | return Response()->json(['ecode' => 0, 'data' => $res ]); |
|
| 304 | } |
|
| 305 | } |
|
| 306 | ||
| @@ 189-213 (lines=25) @@ | ||
| 186 | * |
|
| 187 | * @return \Illuminate\Http\Response |
|
| 188 | */ |
|
| 189 | public function viewUsedInProject($project_key, $id) |
|
| 190 | { |
|
| 191 | if ($project_key !== '$_sys_$') |
|
| 192 | { |
|
| 193 | return Response()->json(['ecode' => 0, 'data' => [] ]); |
|
| 194 | } |
|
| 195 | ||
| 196 | $res = []; |
|
| 197 | $projects = Project::all(); |
|
| 198 | foreach($projects as $project) |
|
| 199 | { |
|
| 200 | $types = Type::where('workflow_id', $id) |
|
| 201 | ->where('project_key', '<>', '$_sys_$') |
|
| 202 | ->where('project_key', $project->key) |
|
| 203 | ->get([ 'id', 'name' ]) |
|
| 204 | ->toArray(); |
|
| 205 | ||
| 206 | if ($types) |
|
| 207 | { |
|
| 208 | $res[] = [ 'key' => $project->key, 'name' => $project->name, 'status' => $project->status, 'types' => $types ]; |
|
| 209 | } |
|
| 210 | } |
|
| 211 | ||
| 212 | return Response()->json(['ecode' => 0, 'data' => $res ]); |
|
| 213 | } |
|
| 214 | } |
|
| 215 | ||