admin
c8404564fe
Module 2 — Geographic Data: PSGC tables (regions/provinces/cities/ barangays) with native geometry(polygon|point, 4326) columns; cascading dropdown endpoints; ST_Contains-based GPS resolution; service-area CRUD with barangay attach/detach; SamplePsgcSeeder + psgc:import command. Module 3 — User Management: 5 role-specific profile tables (driver/ helper/scanner/store_partner with verification_status + rejection reason); profile auto-created on register; admin user CRUD with filters/pagination, suspend/activate, profile approve/reject; self-service /me + /me/profile with role-aware validation that blocks self-approval and resets rejected profiles to pending on resubmit. 69 feature tests passing. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
32 lines
1.0 KiB
PHP
32 lines
1.0 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers\Api\V1\Geo;
|
|
|
|
use App\Http\Controllers\Api\V1\ApiController;
|
|
use App\Http\Resources\ProvinceResource;
|
|
use App\Models\Province;
|
|
use Illuminate\Http\JsonResponse;
|
|
use Illuminate\Http\Request;
|
|
|
|
class ProvinceController extends ApiController
|
|
{
|
|
public function __invoke(Request $request): JsonResponse
|
|
{
|
|
$request->validate([
|
|
'region' => ['nullable', 'string', 'max:32'],
|
|
'region_id' => ['nullable', 'integer'],
|
|
]);
|
|
|
|
$provinces = Province::query()
|
|
->when($request->filled('region'), function ($q) use ($request) {
|
|
$q->whereHas('region', fn ($r) => $r->where('psgc_code', $request->string('region'))
|
|
->orWhere('code', $request->string('region')));
|
|
})
|
|
->when($request->filled('region_id'), fn ($q) => $q->where('region_id', $request->integer('region_id')))
|
|
->orderBy('name')
|
|
->get();
|
|
|
|
return $this->ok(ProvinceResource::collection($provinces));
|
|
}
|
|
}
|