\n
<?php<\/strong>\r\n\r\nnamespace App\\Enums;<\/strong>\r\n\r\nenum ApprovalStatus: string<\/strong>\r\n{<\/strong>\r\n case Pending = 'pending'; \/\/ \u672a\u627f\u8a8d<\/strong>\r\n case Approved = 'approved'; \/\/ \u627f\u8a8d\u6e08\u307f<\/strong>\r\n case Rejected = 'rejected'; \/\/ \u5374\u4e0b<\/strong>\r\n\r\n public function getLabel(): string<\/strong>\r\n {<\/strong>\r\n return match ($this) {<\/strong>\r\n self::Pending => '\u672a\u627f\u8a8d',<\/strong>\r\n self::Approved => '\u627f\u8a8d',<\/strong>\r\n self::Rejected => '\u5374\u4e0b',<\/strong>\r\n };<\/strong>\r\n }<\/strong>\r\n\r\n public function getTheme(): string<\/strong>\r\n {<\/strong>\r\n return match ($this) {<\/strong>\r\n self::Pending => 'bg-gray-500 text-yellow-800',<\/strong>\r\n self::Approved => 'bg-green-500 text-green-800',<\/strong>\r\n self::Rejected => 'bg-red-500 text-red-800',<\/strong>\r\n };<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n\u3053\u306e\u4e2d\u3067\u306f\u3001\u5148\u307b\u3069\u306e\uff13\u3064\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u767b\u9332\u3057\u3001\u3055\u3089\u306b\u305d\u308c\u305e\u308c\u306e\u300c\u65e5\u672c\u8a9e\u540d\u300d\u3068\u300c\u30c6\u30fc\u30de\u30ab\u30e9\u30fc\uff08TailwindCSS<\/code>\uff09\u300d\u3092\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/div>\nDB \u307e\u308f\u308a\u3092\u3064\u304f\u308b<\/h1>\n
\u6b21\u306b\u3001\u30e2\u30c7\u30eb\u3084\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u3064\u304f\u3063\u3066\u3044\u304d\u307e\u3059\u3002
\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n
php artisan make:model Approval -ms<\/strong><\/pre>\n<\/div>\n\n
php artisan make:model ApprovalDetail -m<\/strong><\/pre>\n<\/div>\n\u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u5168\u90e8\u3067\uff15\u3064\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u305d\u308c\u305e\u308c\u4e2d\u8eab\u3092\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3<\/h2>\n
\u307e\u305a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u8a08\u56f3\u306b\u306a\u308b\u300c\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3<\/strong>\u300d\u3067\u3059\u3002<\/p>\ndatabase\/migrations\/****_**_**_******_create_approvals_table.php<\/strong><\/p>\n\n
<?php\r\n\r\nuse Illuminate\\Database\\Migrations\\Migration;\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\nuse Illuminate\\Support\\Facades\\Schema;\r\n\r\nreturn new class extends Migration\r\n{\r\n \/**\r\n * Run the migrations.\r\n *\/\r\n public function up(): void\r\n {\r\n Schema::create('approvals', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->string('title');<\/strong>\r\n $table->text('description')->comment('\u8aac\u660e');<\/strong>\r\n $table->timestamps();<\/strong>\r\n });<\/strong>\r\n }\r\n\r\n \/**\r\n * Reverse the migrations.\r\n *\/\r\n public function down(): void\r\n {\r\n Schema::dropIfExists('approvals');<\/strong>\r\n }\r\n};<\/pre>\ndatabase\/migrations\/****_**_**_******_create_approval_details_table.php<\/strong><\/p>\n\n
<?php\r\n\r\nuse Illuminate\\Database\\Migrations\\Migration;\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\nuse Illuminate\\Support\\Facades\\Schema;\r\nuse App\\Enums\\ApprovalStatus;<\/strong>\r\n\r\nreturn new class extends Migration\r\n{\r\n \/**\r\n * Run the migrations.\r\n *\/\r\n public function up(): void\r\n {\r\n Schema::create('approval_details', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->unsignedBigInteger('approval_id')->comment('\u627f\u8a8dID');<\/strong>\r\n $table->unsignedBigInteger('user_id')->comment('\u30e6\u30fc\u30b6\u30fcID');<\/strong>\r\n $table->string('approval_status')<\/strong>\r\n ->default(ApprovalStatus::Pending)<\/strong>\r\n ->comment('\u627f\u8a8d\u30b9\u30c6\u30fc\u30bf\u30b9'); \/\/ App\\Enums\\ApprovalStatus<\/strong>\r\n $table->timestamps();<\/strong>\r\n\r\n $table->foreign('approval_id')<\/strong>\r\n ->references('id')<\/strong>\r\n ->on('approvals')<\/strong>\r\n ->onDelete('cascade');<\/strong>\r\n $table->foreign('user_id')<\/strong>\r\n ->references('id')<\/strong>\r\n ->on('users');<\/strong>\r\n });<\/strong>\r\n }\r\n\r\n \/**\r\n * Reverse the migrations.\r\n *\/\r\n public function down(): void\r\n {\r\n Schema::dropIfExists('approval_details');<\/strong>\r\n }\r\n};<\/pre>\n\u306a\u304a\u3001\u3053\u308c\u3089\uff12\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u300c\uff11\uff1a\u591a<\/strong>\u300d\u3067\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u7d44\u3080\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\u30e2\u30c7\u30eb<\/h2>\n
\u6b21\u306b\u30e2\u30c7\u30eb\u3067\u3059\u3002
\nApproval.php<\/code>\u306b\u4ee5\u4e0b\uff15\u3064\u306eAccessor<\/code>\u3092\u3064\u304f\u3063\u3066\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3084\u3059\u304f\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u2757<\/p>\n\n- approved_count\uff1a \u627f\u8a8d\u3055\u308c\u305f\u6570<\/li>\n
- rejected_count\uff1a \u62d2\u5426\u3055\u308c\u305f\u6570<\/li>\n
- pending_count\uff1a \u672a\u56de\u7b54\u306e\u6570<\/li>\n
- has_responded\uff1a \uff08\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u304c\uff09\u3059\u3067\u306b\u56de\u7b54\u3057\u305f\u304b\u3069\u3046\u304b<\/li>\n
- has_authority\uff1a \uff08\u305d\u3082\u305d\u3082\uff09\u56de\u7b54\u3059\u308b\u6a29\u5229\u304c\u3042\u308b\u306e\u304b\u3069\u3046\u304b<\/li>\n<\/ul>\n
\u307e\u305f\u3001ApprovalDetail.php<\/code>\u3068\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3082\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\napp\/Models\/Approval.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace App\\Models;<\/strong>\r\n\r\nuse App\\Enums\\ApprovalStatus;<\/strong>\r\nuse Illuminate\\Database\\Eloquent\\Factories\\HasFactory;<\/strong>\r\nuse Illuminate\\Database\\Eloquent\\Model;<\/strong>\r\n\r\nclass Approval extends Model<\/strong>\r\n{<\/strong>\r\n use HasFactory;<\/strong>\r\n\r\n protected $appends = [<\/strong>\r\n 'approved_count',<\/strong>\r\n 'rejected_count',<\/strong>\r\n 'pending_count',<\/strong>\r\n 'has_responded',<\/strong>\r\n 'has_authority',<\/strong>\r\n ];<\/strong>\r\n\r\n \/\/ Relationship<\/strong>\r\n public function details()<\/strong>\r\n {<\/strong>\r\n return $this->hasMany(ApprovalDetail::class, 'approval_id', 'id');<\/strong>\r\n }<\/strong>\r\n\r\n \/\/ Accessor<\/strong>\r\n public function getApprovedCountAttribute() \/\/ \u627f\u8a8d\u3055\u308c\u305f\u4ef6\u6570<\/strong>\r\n {<\/strong>\r\n return $this->details->filter(function($detail){<\/strong>\r\n\r\n return $detail->approval_status === ApprovalStatus::Approved->value;<\/strong>\r\n\r\n })->count();<\/strong>\r\n }<\/strong>\r\n\r\n public function getRejectedCountAttribute() \/\/ \u5374\u4e0b\u3055\u308c\u305f\u4ef6\u6570<\/strong>\r\n {<\/strong>\r\n return $this->details->filter(function($detail){<\/strong>\r\n\r\n return $detail->approval_status === ApprovalStatus::Rejected->value;<\/strong>\r\n\r\n })->count();<\/strong>\r\n }<\/strong>\r\n\r\n public function getPendingCountAttribute() \/\/ \u672a\u627f\u8a8d\u306e\u4ef6\u6570<\/strong>\r\n {<\/strong>\r\n return $this->details->filter(function($detail){<\/strong>\r\n\r\n return $detail->approval_status === ApprovalStatus::Pending->value;<\/strong>\r\n\r\n })->count();<\/strong>\r\n }<\/strong>\r\n\r\n public function getHasRespondedAttribute() \/\/ \u30e6\u30fc\u30b6\u30fc\u304c\u65e2\u306b\u8fd4\u7b54\u3057\u3066\u3044\u308b\u304b\u3069\u3046\u304b<\/strong>\r\n {<\/strong>\r\n $user = auth()->user();<\/strong>\r\n $count = $this->details<\/strong>\r\n ->where('user_id', $user->id)<\/strong>\r\n ->where('approval_status', '<>', ApprovalStatus::Pending->value)<\/strong>\r\n ->count();<\/strong>\r\n\r\n return $count > 0;<\/strong>\r\n }<\/strong>\r\n\r\n public function getHasAuthorityAttribute()<\/strong>\r\n {<\/strong>\r\n $user = auth()->user();<\/strong>\r\n $count = $this->details<\/strong>\r\n ->where('user_id', $user->id)<\/strong>\r\n ->count();<\/strong>\r\n\r\n return $count > 0;<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\n<\/div>\n<\/div>\nSeeder\uff08\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\uff09<\/h2>\n
\u7d9a\u3044\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3059\u308b\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u3064\u304f\u308a\u307e\u3059\u3002<\/p>\n
database\/seeders\/ApprovalSeeder.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace Database\\Seeders;<\/strong>\r\n\r\nuse App\\Models\\Approval;<\/strong>\r\nuse App\\Models\\ApprovalDetail;<\/strong>\r\nuse App\\Models\\User;<\/strong>\r\nuse Illuminate\\Database\\Console\\Seeds\\WithoutModelEvents;<\/strong>\r\nuse Illuminate\\Database\\Seeder;<\/strong>\r\n\r\nclass ApprovalSeeder extends Seeder<\/strong>\r\n{<\/strong>\r\n \/**<\/strong>\r\n * Run the database seeds.<\/strong>\r\n *\/<\/strong>\r\n public function run(): void<\/strong>\r\n {<\/strong>\r\n $users = User::get();<\/strong>\r\n\r\n for ($i = 0; $i < 10; $i++) {<\/strong>\r\n\r\n $approval = new Approval([<\/strong>\r\n 'title' => '\u627f\u8a8d\u4f9d\u983c ' . $i,<\/strong>\r\n 'description' => '\u627f\u8a8d\u4f9d\u983c ' . $i . ' \u306e\u8aac\u660e',<\/strong>\r\n ]);<\/strong>\r\n $approval->save();<\/strong>\r\n\r\n $adding_users = $users<\/strong>\r\n ->shuffle()<\/strong>\r\n ->take(5);<\/strong>\r\n\r\n foreach ($adding_users as $index => $all_user) {<\/strong>\r\n\r\n $approval_detail = new ApprovalDetail([<\/strong>\r\n 'approval_id' => $approval->id,<\/strong>\r\n 'user_id' => $all_user->id,<\/strong>\r\n ]);<\/strong>\r\n $approval_detail->save();<\/strong>\r\n\r\n }<\/strong>\r\n\r\n\r\n }<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n\u305d\u3057\u3066\u3001DatabaseSeeder<\/code>\u306b\u767b\u9332\u3057\u307e\u3059\u3002<\/p>\ndatabase\/seeders\/DatabaseSeeder.php<\/strong><\/p>\n\n
<?php\r\n\r\nnamespace Database\\Seeders;\r\n\r\n\/\/ use Illuminate\\Database\\Console\\Seeds\\WithoutModelEvents;\r\nuse Illuminate\\Database\\Seeder;\r\n\r\nclass DatabaseSeeder extends Seeder\r\n{\r\n \/**\r\n * Seed the application's database.\r\n *\/\r\n public function run(): void\r\n {\r\n \/\/ \u7701\u7565\r\n\r\n $this->call([\r\n ApprovalSeeder::class, \/\/ \ud83d\udc48 \u3053\u308c<\/strong>\r\n ]);\r\n }\r\n}<\/pre>\n\u3067\u306f\u3001\u3053\u306e\u72b6\u614b\u3067DB\u3092\u521d\u671f\u5316\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002
\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n
php artisan migrate:fresh --seed<\/strong><\/pre>\n\u3059\u308b\u3068\u3001\u5b9f\u969b\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u3053\u3046\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<\/div>\n<\/div>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/01\/laravel_approval_system_2.png\")
<\/p>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/01\/laravel_approval_system_3.png\")
<\/p>\n<\/div>\n
\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u3064\u304f\u308b<\/h1>\n
\u7d9a\u3044\u3066\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3067\u3059\u3002
\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n
php artisan make:controller ApprovalController<\/strong><\/pre>\n<\/div>\n\u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u4e2d\u8eab\u3092\u6b21\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
app\/Http\/Controllers\/ApprovalController.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace App\\Http\\Controllers;<\/strong>\r\n\r\nuse App\\Enums\\ApprovalStatus;<\/strong>\r\nuse App\\Models\\Approval;<\/strong>\r\nuse Illuminate\\Http\\Request;<\/strong>\r\n\r\nclass ApprovalController extends Controller<\/strong>\r\n{<\/strong>\r\n public function index(Request $request)<\/strong>\r\n {<\/strong>\r\n $user = $request->user();<\/strong>\r\n $approvals = Approval::query()<\/strong>\r\n ->whereHas('details', function($query) use($user){ \/\/ \u81ea\u5206\u306b\u627f\u8a8d\u4f9d\u983c\u304c\u3042\u308b\u3082\u306e\u3060\u3051\u3092\u53d6\u5f97<\/strong>\r\n\r\n $query->where('user_id', $user->id);<\/strong>\r\n\r\n })<\/strong>\r\n ->paginate(15);<\/strong>\r\n\r\n return view('approval.index', [<\/strong>\r\n 'approvals' => $approvals,<\/strong>\r\n ]);<\/strong>\r\n }<\/strong>\r\n\r\n public function edit(Approval $approval)<\/strong>\r\n {<\/strong>\r\n if(! $approval->has_authority) { \/\/ \u627f\u8a8d\u6a29\u9650\u304c\u306a\u3044\u5834\u5408<\/strong>\r\n\r\n abort(403);<\/strong>\r\n\r\n }<\/strong>\r\n\r\n $approval->load('details');<\/strong>\r\n $approval_statuses = [<\/strong>\r\n ApprovalStatus::Approved,<\/strong>\r\n ApprovalStatus::Rejected,<\/strong>\r\n ];<\/strong>\r\n\r\n return view('approval.edit', [<\/strong>\r\n 'approval' => $approval,<\/strong>\r\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/08\/no_2.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/01\/laravel_approval_system_1.png\")
<\/p>\n