\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3<\/strong>\u300d\u306e\uff12\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n\u3067\u306f\u3001\u305d\u308c\u305e\u308c\u30d5\u30a1\u30a4\u30eb\u306e\u8a2d\u5b9a\u3092\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n
\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u8a2d\u5b9a<\/h2>\n
\u3067\u306f\u3001\u307e\u305a\u306f\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u3067\u3059\u3002<\/p>\n
database\/migrations\/****_**_**_******_create_places_table.php<\/strong><\/p>\n\/\/ \u7701\u7565\r\n\r\npublic function up()\r\n{\r\n Schema::create('places', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->string('name')->comment('\u5834\u6240\u540d');<\/strong>\r\n $table->timestamps();<\/strong>\r\n });<\/strong>\r\n}<\/pre>\ndatabase\/migrations\/****_**_**_******_create_report_histories_table.php<\/strong><\/p>\n\/\/ \u7701\u7565\r\n\r\npublic function up()\r\n{\r\n Schema::create('report_histories', function (Blueprint $table) {<\/strong>\r\n $table->id();<\/strong>\r\n $table->unsignedBigInteger('place_id')->comment('\u5834\u6240ID');<\/strong>\r\n $table->string('phone_number')->comment('\u9001\u4fe1\u8005\u306e\u96fb\u8a71\u756a\u53f7');<\/strong>\r\n $table->timestamps();<\/strong>\r\n\r\n $table->foreign('place_id')->references('id')->on('places');<\/strong>\r\n });<\/strong>\r\n}<\/pre>\nSeeder \u306e\u8a2d\u5b9a<\/h2>\n
\u6b21\u306b\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092DB\u306b\u7528\u610f\u3059\u308b\u305f\u3081\u306eSeeder<\/code>\u3067\u3059\u3002<\/p>\n<?php\r\n\r\nnamespace Database\\Seeders;\r\n\r\nuse App\\Models\\Place;<\/strong>\r\nuse Illuminate\\Database\\Seeder;\r\n\r\nclass PlaceSeeder extends Seeder\r\n{\r\n \/**\r\n * Run the database seeds.\r\n *\r\n * @return void\r\n *\/\r\n public function run()\r\n {\r\n for($i = 1; $i <= 10; $i++) {<\/strong>\r\n\r\n $place = new Place();<\/strong>\r\n $place->name = '\u30c6\u30b9\u30c8\u5834\u6240\u540d '. $i;<\/strong>\r\n $place->save();<\/strong>\r\n\r\n }<\/strong>\r\n }\r\n}<\/pre>\nSeeder\u306f\u3064\u304f\u3063\u305f\u3060\u3051\u3067\u306f\u6709\u52b9\u306b\u306a\u308a\u307e\u305b\u3093\u306e\u3067\u3001Laravel\u5074\u3078\u767b\u9332\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n
database\/seeders\/DatabaseSeeder.php<\/strong><\/p>\npublic function run()\r\n{\r\n \/\/ \u7701\u7565\r\n\r\n $this->call(PlaceSeeder::class);<\/strong>\r\n}<\/pre>\n\u30e2\u30c7\u30eb\u306e\u8a2d\u5b9a<\/h2>\n
\u305d\u3057\u3066\u3001\u30e2\u30c7\u30eb\u306e\u8a2d\u5b9a\u3067\u3059\u3002<\/p>\n
app\/Models\/Place.php<\/strong><\/p>\n\/\/ \u7701\u7565\r\n\r\nclass Place extends Model\r\n{\r\n use HasFactory;\r\n\r\n protected $appends = [<\/strong>\r\n 'qrcode_contents'<\/strong>\r\n ];<\/strong>\r\n \r\n \/\/ Accessor\r\n public function getQrcodeContentsAttribute()<\/strong>\r\n {<\/strong>\r\n $sending_phone_number = env('TWILIO_FROM'); \/\/ \u672c\u6765\u306f config \u306b\u5165\u308c\u308b\u3079\u304d\u3067\u3059<\/strong>\r\n\r\n return 'smsto:+'. $sending_phone_number .':'. $this->id;<\/strong>\r\n }<\/strong>\r\n}<\/pre>\n\u306a\u304a\u3001\u30b3\u30e1\u30f3\u30c8\u306b\u3082\u66f8\u3044\u3066\u3044\u307e\u3059\u304c\u3001env()<\/code>\u306f\u30b3\u30fc\u30c9\u4e2d\u306b\u66f8\u304b\u305aconfig\/services.php<\/code>\u306e\u4e2d\u306b\u66f8\u304f\u3079\u304d\u3067\u3059\u3002\u30ad\u30e3\u30c3\u30b7\u30e5\u306a\u3069\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3002\u4eca\u56de\u306f\u30c6\u30b9\u30c8\u306a\u306e\u3067\u304a\u8a31\u3057\u3092\u3002m(_ _)m<\/p>\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u3064\u304f\u308b<\/h1>\n
\u3067\u306f\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\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
php artisan make:controller SmsReportController<\/strong><\/pre>\napp\/Http\/Controllers\/SmsReportController.php<\/strong><\/p>\n<?php\r\n\r\nnamespace App\\Http\\Controllers;\r\n\r\nuse App\\Models\\Place;<\/strong>\r\nuse App\\Models\\ReportHistory;<\/strong>\r\nuse Illuminate\\Http\\Request;\r\nuse Twilio\\Security\\RequestValidator;\r\nuse Illuminate\\Support\\Facades\\Validator;\r\n\r\nclass SmsReportController extends Controller<\/strong>\r\n{<\/strong>\r\n public function place()<\/strong>\r\n {<\/strong>\r\n $places = Place::all();<\/strong>\r\n\r\n return view('sms_report.place', compact('places'));<\/strong>\r\n }<\/strong>\r\n\r\n public function webhook(Request $request)<\/strong>\r\n {<\/strong>\r\n $rules = [<\/strong>\r\n 'Body' => ['required', 'exists:places,id']<\/strong>\r\n ];<\/strong>\r\n\r\n if(Validator::make($request->all(), $rules)->fails()) {<\/strong>\r\n\r\n \/\/ \u3053\u3053\u3067\u30a8\u30e9\u30fc\u51e6\u7406<\/strong>\r\n abort(500, 'Place not found..');<\/strong>\r\n\r\n }<\/strong>\r\n\r\n $signature = $request->header('X-Twilio-Signature');<\/strong>\r\n $url = $request->fullUrl();<\/strong>\r\n $values = $request->all();<\/strong>\r\n $auth_token = env('TWILIO_AUTH_TOKEN'); \/\/ \u672c\u6765\u306f config \u306b\u5165\u308c\u308b\u3079\u304d\u3067\u3059<\/strong>\r\n $validator = new RequestValidator($auth_token);<\/strong>\r\n\r\n if($validator->validate($signature, $url, $values)) { \/\/ \u672c\u5f53\u306b Twilio \u304b\u3089\u306e\u30a6\u30a7\u30d6\u30d5\u30c3\u30af\u306a\u306e\u304b\u30c1\u30a7\u30c3\u30af<\/strong>\r\n\r\n $report_history = new ReportHistory();<\/strong>\r\n $report_history->place_id = $request->Body;<\/strong>\r\n $report_history->phone_number = $request->From;<\/strong>\r\n $report_history->save();<\/strong>\r\n\r\n \/\/ \u5b9f\u969b\u306b\u306f\u3001\u3053\u3053\u3067\u5b8c\u4e86\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8fd4\u3059\u306a\u3069\u3059\u308b<\/strong>\r\n\r\n } else {<\/strong>\r\n\r\n abort(500, 'Validation failed..');<\/strong>\r\n\r\n }<\/strong>\r\n }<\/strong>\r\n}<\/strong><\/pre>\n\u30d3\u30e5\u30fc\u3092\u3064\u304f\u308b<\/h1>\n
\u5148\u307b\u3069\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306e\u4e2d\u3067\u6307\u5b9a\u3057\u305f\u30d3\u30e5\u30fc\u300csms_report.place<\/strong>\u300d\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\nresources\/views\/sms_report\/place.blade.php<\/strong><\/p>\n<html><\/strong>\r\n<head><\/strong>\r\n <link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.0.1\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\"><\/strong>\r\n<\/head><\/strong>\r\n<body><\/strong>\r\n<div id=\"app\"><\/strong>\r\n <div class=\"container\"><\/strong>\r\n <div class=\"row\"><\/strong>\r\n <div class=\"col-3\" v-for=\"place in places\"><\/strong>\r\n <div class=\"p-5\"><\/strong>\r\n <div :id=\"`qrcode-${place.id}`\" class=\"mb-1\"><\/div><\/strong>\r\n <div v-text=\"place.name\"><\/div><\/strong>\r\n <\/div><\/strong>\r\n <\/div><\/strong>\r\n <\/div><\/strong>\r\n <\/div><\/strong>\r\n<\/div><\/strong>\r\n<script src=\"https:\/\/unpkg.com\/vue@3.1.1\/dist\/vue.global.prod.js\"><\/script><\/strong>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/qrcodejs\/1.0.0\/qrcode.min.js\"><\/script><\/strong>\r\n<script><\/strong>\r\n\r\n Vue.createApp({<\/strong>\r\n data() {<\/strong>\r\n return {<\/strong>\r\n places: @json($places)<\/strong>\r\n }<\/strong>\r\n },<\/strong>\r\n mounted() {<\/strong>\r\n\r\n Vue.nextTick(() => {<\/strong>\r\n\r\n this.places.forEach(place => {<\/strong>\r\n\r\n const selector = `#qrcode-${place.id}`;<\/strong>\r\n const target = document.querySelector(selector);<\/strong>\r\n\r\n new QRCode(target, {<\/strong>\r\n text: place.qrcode_contents,<\/strong>\r\n width: 128,<\/strong>\r\n height: 128,<\/strong>\r\n colorDark : \"#000000\",<\/strong>\r\n colorLight : \"#ffffff\",<\/strong>\r\n correctLevel : QRCode.CorrectLevel.H<\/strong>\r\n });<\/strong>\r\n\r\n });<\/strong>\r\n\r\n });<\/strong>\r\n\r\n }<\/strong>\r\n }).mount('#app');<\/strong>\r\n\r\n<\/script><\/strong>\r\n<\/body><\/strong>\r\n<\/html><\/strong><\/pre>\n\u30eb\u30fc\u30c8\u3092\u3064\u304f\u308b<\/h1>\n
\u3067\u306f\u3001\u5b9f\u969b\u306b\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3078\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u30eb\u30fc\u30c8\u3092\u3064\u304f\u3063\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n
use App\\Http\\Controllers\\SmsReportController;<\/strong>\r\n\r\n\/\/ \u7701\u7565\r\n\r\nRoute::get('sms_report\/place', [SmsReportController::class, 'place']);<\/strong>\r\nRoute::post('sms_report\/webhook', [SmsReportController::class, 'webhook']);<\/strong><\/pre>\nCSRF \u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b<\/h1>\n
Laravel<\/code>\u306b\u306f\u3001CSRF<\/code>\u653b\u6483\u3092\u9632\u3050\u6a5f\u80fd\u304c\u521d\u671f\u72b6\u614b\u3067\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u3053\u308c\u306f\u30a6\u30a7\u30d6\u30d5\u30c3\u30af\u306b\u3082\u9069\u7528\u3055\u308c\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\u3057\u304b\u3057\u3001\u305d\u3046\u306a\u308b\u3068\u30a6\u30a7\u30d6\u30d5\u30c3\u30af\u304b\u3089\u30c7\u30fc\u30bf\u53d7\u4fe1\u304c\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u5148\u307b\u3069\u3064\u304f\u3063\u305f\u30a6\u30a7\u30d6\u30d5\u30c3\u30af\u7528\u306e\u30eb\u30fc\u30c8\u3092\u89e3\u9664\u3057\u307e\u3059\u3002<\/p>\n
app\/Http\/Middleware\/VerifyCsrfToken.php<\/strong><\/p>\n<?php\r\n\r\nnamespace App\\Http\\Middleware;\r\n\r\nuse Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken as Middleware;\r\n\r\nclass VerifyCsrfToken extends Middleware\r\n{\r\n \/**\r\n * The URIs that should be excluded from CSRF verification.\r\n *\r\n * @var array\r\n *\/\r\n protected $except = [\r\n 'sms_report\/webhook', \/\/ \ud83d\udc48 \u3053\u3053\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f<\/strong>\r\n ];\r\n}<\/pre>\n\u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b<\/h1>\n
\u3067\u306f\u3001\u3053\u308c\u307e\u3067\u306e\u30b3\u30fc\u30c9\u3092\u30b5\u30fc\u30d0\u30fc\u3078\u30a2\u30c3\u30d7\u3057\u3066\u30c6\u30b9\u30c8\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
\uff08\u30ed\u30fc\u30ab\u30eb\u3067\u306f\u30a6\u30a7\u30d6\u30d5\u30c3\u30af\u304c\u805e\u304b\u306a\u3044\u306e\u3067ngrok<\/code>\u306a\u3069\u304c\u5fc5\u8981\u3067\u3059\u304c\u3001\u8a2d\u5b9a\u304c\u3081\u3093\u3069\u3046\u306a\u306e\u3067\u30b5\u30fc\u30d0\u30fc\u3092\u4f7f\u3044\u307e\u3057\u305f\ud83d\ude02\uff09<\/p>\n\u3067\u306f\u3001\u307e\u305a\u306f\u300chttps:\/\/******\/sms_report\/place<\/strong>\u300d\u306b\u30d6\u30e9\u30a6\u30b6\u3067\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2019\/04\/no_22.png\")
\u300c\u30aa\u30fc\u30c9\u30ea\u30fc\u30fb\u30bf\u30f3\u306f\u3001![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_1.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_2.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_3.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_5.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_6.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_7.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_8.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_9.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_10.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_11.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_12.png\")
<\/p>\n![\"\"](\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2021\/11\/laravel_sms_report_13.png\")
<\/p>\n