\u3067\u306f\u3001\u697d\u3057\u3093\u3067\u3084\u3063\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u2757<\/p>\n
\u4eca\u56de\u306f\u30e1\u30a4\u30f3\u3067\u306f\u306a\u3044\u90e8\u5206\u306a\u306e\u3067
\n\u30b5\u30af\u30c3\u3068\u3044\u304d\u307e\u3059\u3002<\/p>\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 LineUser -ms\r\nphp artisan make:model LineNewsletter -ms\r\nphp artisan make:model LineUserNewsletter -m\r\n<\/strong><\/pre>\n<\/div>\n\u305d\u3057\u3066\u3001\u4f5c\u6210\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n
app\/Models\/LineUser.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace App\\Models;<\/strong>\r\n\r\nuse Illuminate\\Database\\Eloquent\\Factories\\HasFactory;<\/strong>\r\nuse Illuminate\\Database\\Eloquent\\Model;<\/strong>\r\n\r\nclass LineUser extends Model<\/strong>\r\n{<\/strong>\r\n use HasFactory;<\/strong>\r\n\r\n \/\/ Relationship<\/strong>\r\n public function newsletters()<\/strong>\r\n {<\/strong>\r\n return $this->belongsToMany(Newsletter::class, 'line_user_newsletters', 'line_user_id', 'newsletter_id');<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\napp\/Models\/Newsletter.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace App\\Models;<\/strong>\r\n\r\nuse Illuminate\\Database\\Eloquent\\Factories\\HasFactory;<\/strong>\r\nuse Illuminate\\Database\\Eloquent\\Model;<\/strong>\r\n\r\nclass Newsletter extends Model<\/strong>\r\n{<\/strong>\r\n use HasFactory;<\/strong>\r\n\r\n \/\/ Relationship<\/strong>\r\n public function line_user()<\/strong>\r\n {<\/strong>\r\n return $this->belongsToMany(LineUser::class, 'line_user_newsletters', 'newsletter_id', 'line_user_id');<\/strong>\r\n }<\/strong>\r\n\r\n \/\/ Others<\/strong>\r\n public static function getTestNewsletterIds()<\/strong>\r\n {<\/strong>\r\n \/\/ TODO: \u30c6\u30b9\u30c8\u7528\u3002\u672c\u6765\u3053\u3053\u306f DB \u304b\u3089\u53d6\u5f97\u3059\u308b\u3079\u304d\u3067\u3059<\/strong>\r\n return [1, 2, 3]; \/\/ \u9001\u4fe1\u3059\u308b\u30e1\u30eb\u30de\u30ac\u306eID\uff08\u3053\u306e\u9806\u756a\u306b\u9001\u4fe1\u3055\u308c\u308b\uff09<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\ndatabase\/migrations\/****_**_**_******_create_line_users_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('line_users', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->uuid('uuid')->unique()->comment('UUID');<\/strong>\r\n $table->string('line_id')->unique()->comment('LINE\u306eID');<\/strong>\r\n $table->string('mode')->comment('\u30c1\u30e3\u30cd\u30eb\u306e\u72b6\u614b');<\/strong>\r\n $table->string('display_name')->comment('LINE\u306e\u540d\u524d');<\/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('line_users');\r\n }\r\n};<\/pre>\n<\/div>\ndatabase\/migrations\/****_**_**_******_create_newsletters_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('newsletters', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->uuid('uuid')->unique()->comment('UUID');<\/strong>\r\n $table->string('line_body')->comment('LINE\u306e\u672c\u6587');<\/strong>\r\n $table->string('web_body')->comment('\u30a6\u30a7\u30d6\u30da\u30fc\u30b8\u306e\u672c\u6587');<\/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('newsletters');\r\n }\r\n};<\/pre>\n<\/div>\ndatabase\/migrations\/****_**_**_******_create_line_user_newsletters_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('line_user_newsletters', function (Blueprint $table) {\r\n $table->id();<\/strong>\r\n $table->unsignedBigInteger('line_user_id')->comment('LINE\u30e6\u30fc\u30b6\u30fcID');<\/strong>\r\n $table->unsignedBigInteger('newsletter_id')->comment('\u30e1\u30eb\u30de\u30acID');<\/strong>\r\n $table->text('answer')->nullable()->comment('\u56de\u7b54');<\/strong>\r\n $table->dateTime('answered_at')->nullable()->comment('\u56de\u7b54\u65e5\u6642');<\/strong>\r\n $table->timestamps();<\/strong>\r\n\r\n $table->foreign('line_user_id')->references('id')->on('line_users');<\/strong>\r\n $table->foreign('newsletter_id')->references('id')->on('newsletters');<\/strong>\r\n });\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('line_user_newsletters');\r\n }\r\n};<\/pre>\n<\/div>\ndatabase\/seeders\/LineUserSeeder.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace Database\\Seeders;<\/strong>\r\n\r\nuse App\\Models\\LineUser;<\/strong>\r\nuse Illuminate\\Database\\Console\\Seeds\\WithoutModelEvents;<\/strong>\r\nuse Illuminate\\Database\\Seeder;<\/strong>\r\nuse Illuminate\\Support\\Str;<\/strong>\r\n\r\nclass LineUserSeeder 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 for($i = 1; $i <= 10; $i++) {<\/strong>\r\n\r\n $line_user = new LineUser();<\/strong>\r\n $line_user->uuid = Str::uuid();<\/strong>\r\n $line_user->line_id = Str::random();<\/strong>\r\n $line_user->mode = 'active';<\/strong>\r\n $line_user->display_name = '\u30e6\u30fc\u30b6\u30fc' . $i;<\/strong>\r\n $line_user->save();<\/strong>\r\n\r\n }<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\ndatabase\/seeders\/NewsletterSeeder.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace Database\\Seeders;<\/strong>\r\n\r\nuse App\\Models\\Newsletter;<\/strong>\r\nuse Illuminate\\Database\\Console\\Seeds\\WithoutModelEvents;<\/strong>\r\nuse Illuminate\\Database\\Seeder;<\/strong>\r\nuse Illuminate\\Support\\Str;<\/strong>\r\n\r\nclass NewsletterSeeder 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 for($i = 1; $i <= 3; $i++) {<\/strong>\r\n\r\n $newsletter = new Newsletter();<\/strong>\r\n $newsletter->uuid = Str::uuid();<\/strong>\r\n $newsletter->line_body = $i .'\u3064\u76ee\u306e\u30e1\u30eb\u30de\u30ac\u306e\u5185\u5bb9\uff08LINE\uff09';<\/strong>\r\n $newsletter->web_body = $i .'\u3064\u76ee\u306e\u30e1\u30eb\u30de\u30ac\u306e\u5185\u5bb9\uff08Web\uff09' .\" \\n\u8cea\u554f\u306b\u7b54\u3048\u3066\u306d\\n\u2193\u2193\u2193\";<\/strong>\r\n $newsletter->save();<\/strong>\r\n\r\n }<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\n\u305d\u3057\u3066\u3001Seeder<\/code>\u3092Laravel<\/code>\u3078\u30bb\u30c3\u30c8\u3002<\/p>\ndatabase\/seeders\/DatabaseSeeder.php<\/strong><\/p>\n\n
<?php\r\n\r\nnamespace Database\\Seeders;\r\n\r\nuse App\\Models\\User;\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 $this->call([<\/strong>\r\n LineUserSeeder::class,<\/strong>\r\n NewsletterSeeder::class,<\/strong>\r\n ]);<\/strong>\r\n }\r\n}<\/pre>\n<\/div>\n\u3067\u306f\u3001DB<\/code>\u306e\u521d\u671f\u5316\u3057\u307e\u3059\u3002<\/p>\n\n
php artisan migrate:fresh --seed<\/strong><\/pre>\n\u3059\u308b\u3068\u5b9f\u969b\u306e\u30c6\u30fc\u30d6\u30eb\u306f\u3053\u3046\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<\/div>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/04\/laravel_customer_screening_1.png\")
<\/p>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/04\/laravel_customer_screening_3.png\")
<\/p>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2024\/04\/laravel_customer_screening_2.png\")
<\/p>\n
<\/p>\n
\n
\u30e1\u30fc\u30eb\u9001\u4fe1\u90e8\u5206\u3092\u3064\u304f\u308b<\/h1>\n
\u4eca\u56de\u306f\u300cLINE\u306e\u4ee3\u66ff<\/strong>\u300d\u3068\u3057\u3066Mailable<\/code>\u3092\u3064\u304f\u308a\u307e\u3059\u3002
\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u4e0b\u3055\u3044\u3002<\/p>\n\n
php artisan make:mail SendNewsletter<\/strong><\/pre>\n<\/div>\n<\/div>\n\u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u4e2d\u8eab\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n
app\/Mail\/SendNewsletter.php<\/strong><\/p>\n\n
<?php<\/strong>\r\n\r\nnamespace App\\Mail;<\/strong>\r\n\r\nuse App\\Models\\LineUser;<\/strong>\r\nuse App\\Models\\Newsletter;<\/strong>\r\nuse Illuminate\\Bus\\Queueable;<\/strong>\r\nuse Illuminate\\Contracts\\Queue\\ShouldQueue;<\/strong>\r\nuse Illuminate\\Mail\\Mailable;<\/strong>\r\nuse Illuminate\\Mail\\Mailables\\Content;<\/strong>\r\nuse Illuminate\\Mail\\Mailables\\Envelope;<\/strong>\r\nuse Illuminate\\Queue\\SerializesModels;<\/strong>\r\n\r\nclass SendNewsletter extends Mailable<\/strong>\r\n{<\/strong>\r\n use Queueable, SerializesModels;<\/strong>\r\n\r\n \/**<\/strong>\r\n * Create a new message instance.<\/strong>\r\n *\/<\/strong>\r\n public function __construct(private Newsletter $newsletter, private LineUser $line_user)<\/strong>\r\n {}<\/strong>\r\n\r\n \/**<\/strong>\r\n * Get the message envelope.<\/strong>\r\n *\/<\/strong>\r\n public function envelope(): Envelope<\/strong>\r\n {<\/strong>\r\n return new Envelope(<\/strong>\r\n subject: '\u3010 Console dot Log \u30e1\u30eb\u30de\u30ac \u3011',<\/strong>\r\n );<\/strong>\r\n }<\/strong>\r\n\r\n \/**<\/strong>\r\n * Get the message content definition.<\/strong>\r\n *\/<\/strong>\r\n public function content(): Content<\/strong>\r\n {<\/strong>\r\n return new Content(<\/strong>\r\n view: 'emails.newsletter',<\/strong>\r\n with: [<\/strong>\r\n 'newsletter' => $this->newsletter,<\/strong>\r\n 'line_user' => $this->line_user,<\/strong>\r\n ]<\/strong>\r\n );<\/strong>\r\n }<\/strong>\r\n\r\n \/**<\/strong>\r\n * Get the attachments for the message.<\/strong>\r\n *<\/strong>\r\n * @return array<int, \\Illuminate\\Mail\\Mailables\\Attachment><\/strong>\r\n *\/<\/strong>\r\n public function attachments(): array<\/strong>\r\n {<\/strong>\r\n return [];<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n<\/div>\n\u3067\u306f\u3001Mailable<\/code>\u306b\u30bb\u30c3\u30c8\u3057\u305f\u30d3\u30e5\u30fc\u3092\u3064\u304f\u308a\u307e\u3059\u3002<\/p>\n\n
php artisan make:view emails.newsletter<\/strong><\/pre>\n<\/div>\n\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u3053\u3046\u306a\u308a\u307e\u3059\u3002<\/p>\n
resources\/views\/emails\/newsletter.blade.php<\/strong><\/p>\n\n
{{ $newsletter->line_body }}<br><br><\/strong>\r\n\r\n<a href=\"{{ route('newsletter.show', [$newsletter->uuid, $line_user->uuid]) }}\">\u672c\u6587\u306f\u3053\u3061\u3089<\/a><\/strong><\/pre>\n<\/div>\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u3064\u304f\u308b<\/h1>\n
\u3067\u306f\u3001\uff08\u53d7\u4fe1\u3057\u305f\u30e1\u30fc\u30eb\u306b\u3042\u308bURL<\/code>\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u3068\u304d\u306e\uff09
\n\u30e1\u30eb\u30de\u30ac\u672c\u6587\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306b\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u3064\u304f\u308a\u307e\u3059\u3002<\/p>\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u4e0b\u3055\u3044\u3002<\/p>\n
\n
php artisan make:controller NewsletterController<\/strong><\/pre>\n<\/div>\n\u4e2d\u8eab\u3092\u3053\u3046\u3057\u307e\u3059\u3002<\/p>\n
app\/Http\/Controllers\/NewsletterController.php<\/strong><\/p>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/08\/no_2.png\")
\u300c\u8feb\u4f51\u6a39 \u793e\u9577\u306e