{"id":11782,"date":"2023-07-01T07:00:11","date_gmt":"2023-06-30T22:00:11","guid":{"rendered":"https:\/\/blog.capilano-fw.com\/?p=11782"},"modified":"2023-06-22T16:56:40","modified_gmt":"2023-06-22T07:56:40","slug":"laravel-%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%82%92%e5%85%a5%e5%8a%9b%e3%83%95%e3%82%a9%e3%83%bc%e3%83%a0%e3%81%a8%e3%81%97%e3%81%a6%e4%bd%bf%e3%81%88%e3%82%8b%e3%82%88%e3%81%86%e3%81%ab%e3%81%99","status":"publish","type":"post","link":"https:\/\/blog.capilano-fw.com\/?p=11782","title":{"rendered":"Laravel\u6d3b\u7528\u8853: \u30a8\u30af\u30bb\u30eb\u3092\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u3078\u5909\u3048\u3066\u52b9\u7387\u5316\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

\u3055\u3066\u3055\u3066\u3001\u3053\u308c\u3082\u300c\u958b\u767a\u8005\u3042\u308b\u3042\u308b\u300d\u306a\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u300c\u305d\u308c\u3044\u3044\u3067\u3059\u306d\u2757\u3084\u308a\u307e\u3057\u3087\u3046\u3002<\/strong>\u300d\u3068\u306a\u308b\u30a2\u30a4\u30c7\u30a2\u304c\u51fa\u3066\u3082\u3001\u6700\u7d42\u7684\u306b\u3053\u3046\u306a\u308b\u3053\u3068\u3063\u3066\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n

\u3042\u308c\u3001\u4ed5\u69d8\u7684\u306b\u4f7f\u3048\u306a\u304f\u306a\u3063\u3061\u3083\u3063\u305f\u2026\ud83d\ude2d<\/strong><\/p>\n

\u305d\u3046\u3067\u3059\u3002<\/p>\n

\u30a2\u30a4\u30c7\u30a2\u81ea\u4f53\u306f\u3059\u3054\u304f\u3044\u3044\u3082\u306e\u3060\u3063\u305f\u306e\u306b\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3055\u3093\u304c\u6c42\u3081\u308b\u3053\u3068\u3092\u8003\u3048\u308b\u3068\u3001\u305d\u308c\u3067\u306f\u5b9f\u88c5\u3067\u304d\u306a\u3044\u306e\u3067\u304a\u8535\u5165\u308a\u306b\u306a\u308b\u3068\u3044\u3046\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u306d\u3002<\/p>\n

\u305d\u3057\u3066\u3001\u5148\u65e5\u79c1\u3082\u540c\u3058\u3053\u3068\u304c\u3042\u308a\u5148\u65b9\u3055\u3093\u306b\u300c\u30a2\u30a4\u30c7\u30a2\u306f\u3068\u3066\u3082\u9762\u767d\u3044\u306e\u3067\u3001\u304a\u8535\u5165\u308a\u306a\u3089\u3001\u305c\u3072\u30d6\u30ed\u30b0\u8a18\u4e8b\u306b\u3057\u3066\u3082\u3044\u3044\u3067\u3057\u3087\u3046\u304b\u2753<\/strong>\u300d\u3068\u4f3a\u3063\u305f\u3068\u3053\u308d\u5feb\u304fOK<\/code>\u3057\u3066\u3044\u305f\u3060\u3044\u305f\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

\u305d\u308c\u304c\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n

\u30a8\u30af\u30bb\u30eb\u3092\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u3068\u3057\u3066\u4f7f\u3046<\/strong><\/p>\n

\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u3002<\/p>\n

\u3064\u307e\u308a\u3001\u6d41\u308c\u3068\u3057\u3066\u306f\u3053\u3046\u306a\u308a\u307e\u3059\u3002<\/p>\n

    \n
  1. \u30a8\u30af\u30bb\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b<\/li>\n
  2. \u5404\u9805\u76ee\u306b\u5165\u529b\u3092\u3057\u3066\u4fdd\u5b58<\/li>\n
  3. \u305d\u306e\u30a8\u30af\u30bb\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b<\/li>\n<\/ol>\n

    \u305d\u3057\u3066\u3001\u3053\u308c\u304c\u5b9f\u88c5\u3067\u304d\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30e1\u30ea\u30c3\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

      \n
    • \u30a8\u30af\u30bb\u30eb\u306b\u6163\u308c\u3066\u3044\u308b\u4eba\u306a\u3089\u30b3\u30d4\u30da\u304c\u7c21\u5358<\/li>\n
    • \u305f\u304f\u3055\u3093\u306e\u5165\u529b\u3084\u9078\u629e\u304c\u3042\u308b\u3068\u30d5\u30a9\u30fc\u30e0\u3060\u3068\u30da\u30fc\u30b8\u5206\u5272\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3051\u3069\u3001\u30a8\u30af\u30bb\u30eb\u3067\u306f\u4e0d\u8981<\/li>\n
    • \u52d5\u7684\u306b\u30a8\u30af\u30bb\u30eb\u306b\u9078\u629e\u80a2\u3082\u3064\u304f\u308c\u308b<\/li>\n
    • \u5165\u529b\u304c\u591a\u3044\u5834\u5408\u3001\u9014\u4e2d\u3067\u4f11\u61a9\u3067\u304d\u308b\uff08\u30a8\u30af\u30bb\u30eb\u3092\u4fdd\u5b58\u3059\u308b\u3060\u3051\u3067OK\uff09<\/li>\n
    • \uff08\u305d\u3057\u3066\u4f55\u3088\u308a\uff09\u6211\u3005\u958b\u767a\u8005\u306f\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u3089\u305a\u306b\u6e08\u3080\uff08\u30e4\u30c3\u30bf\u30fc\u2728\ud83d\ude04\ud83d\udc4d\uff09<\/li>\n<\/ul>\n

      \u305d\u3053\u3067\u2757
      \n\u4eca\u56de\u306f\u3001Laravel<\/code>\u3092\u4f7f\u3063\u3066\u30a8\u30af\u30bb\u30eb\u3092\u30d5\u30a9\u30fc\u30e0\u306e\u4ee3\u308f\u308a\u3068\u3057\u3066\u4f7f\u3046\u6a5f\u80fd\u3092\u5b9f\u88c5\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

      \u305c\u3072\u4f55\u304b\u306e\u53c2\u8003\u306b\u306a\u308a\u307e\u3057\u305f\u3089\u5b09\u3057\u3044\u3067\u3059\u3002\ud83d\ude04<\/p>\n

      \"\"\u300c\u6700\u8fd1\u3001\u904b\u306e\u826f\u3055\u3092\u5b9f\u611f\u3057\u3066\u3044\u307e\u3059
      \n\uff08\u30b9\u30d4\u30ea\u30c1\u30e5\u30a2\u30eb\u306a\u8a71\u3067\u306f\u306a\u304f\u3066\ud83d\ude04\uff09\u300d<\/p>\n

      \u958b\u767a\u74b0\u5883\uff1a Leaflet 1.9.4\u3001<\/strong>Alpine.js 3.12\u3001tailwindCSS 3.3.2<\/strong><\/p>\n

      \u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h1>\n

      \u3067\u306f\u3001\u307e\u305a\u306f\u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u304d\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

      composer require phpoffice\/phpspreadsheet\r\n<\/strong><\/pre>\n
      \u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u6e96\u5099\u306f\u5b8c\u4e86\u3067\u3059\u2757<\/p>\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\u3092\u3064\u304f\u308a\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 SpreadsheetFormController\r\n<\/strong><\/pre>\n
      \u3059\u308b\u3068\u3001\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u4e2d\u8eab\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
      app\/Http\/Controllers\/SpreadsheetFormController.php<\/strong><\/p>\n
      <?php\r\n\r\nnamespace App\\Http\\Controllers;\r\n\r\nuse App\\Http\\Requests\\SpreadsheetFormRequest;\r\nuse Illuminate\\Http\\Request;\r\nuse Illuminate\\Validation\\ValidationRuleParser;\r\nuse PhpOffice\\PhpSpreadsheet\\Cell\\DataValidation;\r\nuse PhpOffice\\PhpSpreadsheet\\Spreadsheet;\r\nuse PhpOffice\\PhpSpreadsheet\\Writer\\Xlsx;\r\n\r\nclass SpreadsheetFormController extends Controller\r\n{\r\n    public function create()\r\n    {\r\n        return view('spreadsheet_form.create');\r\n    }\r\n\r\n    public function store(SpreadsheetFormRequest $request)\r\n    {\r\n        \/\/ TODO: \u3053\u3053\u3067 DB \u3078\u4fdd\u5b58\uff08\u4eca\u56de\u306f\u7701\u7565\u3057\u307e\u3059\uff09\r\n\r\n        return ['result' => true];\r\n    }\r\n\r\n    public function download()\r\n    {\r\n        $spreadsheet_data = config('spreadsheet_form.user_registration');\r\n\r\n        $spreadsheet = new Spreadsheet();\r\n        $sheet = $spreadsheet->getActiveSheet();\r\n\r\n        $sheet->setCellValue('A1', '\u9805\u76ee');\r\n        $sheet->setCellValue('B1', '\u5165\u529b');\r\n        $sheet->setCellValue('C1', '\u5fc5\u9808');\r\n\r\n        $row_number = 2;\r\n\r\n        foreach ($spreadsheet_data as $spreadsheet_values) {\r\n\r\n            $label_location = 'A'. $row_number;\r\n            $input_location = 'B'. $row_number;\r\n            $required_location = 'C'. $row_number;\r\n\r\n            $sheet->setCellValue($label_location, $spreadsheet_values['label']);\r\n\r\n            \/\/ \u9078\u629e\u80a2\r\n            $options = $spreadsheet_values['options'] ?? [];\r\n\r\n            if(count($options) > 0) {\r\n\r\n                $sheet->setCellValue($input_location, '\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044');\r\n                $validation = new DataValidation();\r\n                $validation->setFormula1('\"'. implode(',', $options) .'\"');\r\n                $validation->setType('list');\r\n                $validation->setAllowBlank(true);\r\n                $validation->setShowDropDown(true);\r\n                $sheet->setDataValidation($input_location, $validation);\r\n\r\n            }\r\n\r\n            \/\/ \u5fc5\u9808\r\n            $rules = (! is_array($spreadsheet_values['rules']))\r\n                ? explode('|', $spreadsheet_values['rules'])\r\n                : $spreadsheet_values['rules'];\r\n            $parser = new ValidationRuleParser($rules);\r\n\r\n            if(in_array('required', $parser->data)) { \/\/ \u5fc5\u9808\u306e\u5834\u5408\r\n\r\n                $sheet->setCellValue($required_location, '\u203b');\r\n\r\n            }\r\n\r\n            $row_number++;\r\n\r\n        }\r\n\r\n        $path = storage_path('spreadsheet_form.xlsx');\r\n        $writer = new Xlsx($spreadsheet);\r\n        $writer->save($path);\r\n\r\n        return response()->download($path)->deleteFileAfterSend();\r\n    }\r\n}\r\n<\/strong><\/pre>\n
      \u3061\u306a\u307f\u306b\u3001download()<\/code>\u3067\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u7528\u306e\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u53d6\u308a\u3001\u305d\u308c\u306b\u5408\u308f\u305b\u3066\u52d5\u7684\u306b\u30b7\u30fc\u30c8\u306e\u4e2d\u8eab\u3092\u4f5c\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
      \u3064\u307e\u308a\u3001\u30c7\u30fc\u30bf\u3055\u3048\u5909\u66f4\u3059\u308c\u3070\u5185\u5bb9\u304c\u81ea\u52d5\u7684\u306b\u5909\u66f4\u3067\u304d\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u306d\ud83d\udc4d<\/p>\n
      \u30c7\u30fc\u30bf\u3092\u5171\u901a\u5316\u3059\u308b<\/h1>\n
      \u3067\u306f\u3001\u5148\u307b\u3069\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306e\u4e2d\u3067\u6307\u5b9a\u3057\u305f\u300c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30c7\u30fc\u30bf\u60c5\u5831<\/strong>\u300d\u3092\u3064\u304f\u308a\u307e\u3057\u3087\u3046\u3002\uff08\u5171\u901a\u5316\u3057\u305f\u3044\u306e\u3067\u3001config<\/code>\u30d5\u30a9\u30eb\u30c0\u306e\u4e2d\u306b\u8a2d\u7f6e\u3057\u307e\u3057\u305f\uff09<\/p>\n
      config\/spreadsheet_form\/user_registration.php<\/strong><\/p>\n
      <?php\r\n\r\nuse Illuminate\\Validation\\Rule;\r\n\r\nfunction user_registration()\r\n{\r\n    $favorite_foods = [\r\n        '\u30e9\u30fc\u30e1\u30f3',\r\n        '\u30ab\u30ec\u30fc',\r\n        '\u5bff\u53f8',\r\n        '\u30d1\u30b9\u30bf',\r\n        '\u30cf\u30f3\u30d0\u30fc\u30ac\u30fc',\r\n    ];\r\n\r\n    return [\r\n        [\r\n            'column' => 'email',\r\n            'label' => '\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9',\r\n            'rules' => 'required|email|max:255',\r\n        ],\r\n        [\r\n            'column' => 'password',\r\n            'label' => '\u30d1\u30b9\u30ef\u30fc\u30c9',\r\n            'rules' => [ \/\/ \u914d\u5217\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u3082 OK\uff01\r\n                'required',\r\n                'min:8',\r\n                'max:255',\r\n                'regex:\/^[a-zA-Z0-9]+$\/',\r\n            ],\r\n        ],\r\n        [\r\n            'column' => 'phone_number',\r\n            'label' => '\u96fb\u8a71\u756a\u53f7',\r\n            'rules' => 'nullable|numeric|digits_between:10,11',\r\n        ],\r\n        [\r\n            'column' => 'password',\r\n            'label' => '\u597d\u304d\u306a\u98df\u3079\u7269',\r\n            'options' => $favorite_foods,\r\n            'rules' => [\r\n                'required',\r\n                Rule::in($favorite_foods),\r\n            ],\r\n        ]\r\n    ];\r\n}\r\n\r\nreturn user_registration();\r\n<\/strong><\/pre>\n
      \u203b \u306a\u304a\u3001\u300c\u597d\u304d\u306a\u98df\u3079\u7269\u300d\u30c7\u30fc\u30bf\u306f\u91cd\u8907\u3059\u308b\u90e8\u5206\u304c\u3042\u308b\u306e\u3067\u3001\u95a2\u6570\u3092\u3064\u304f\u308a\u305d\u3053\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
      \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\uff08FormRequest\uff09\u3092\u3064\u304f\u308b<\/h1>\n
      \u6b21\u306b\u3001\u3053\u308c\u3082\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306e\u4e2d\u3067\u6307\u5b9a\u3057\u305f\u300cSpreadsheetFormRequest<\/strong>\u300d\u3092\u4f5c\u3063\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u306e\u4e2d\u3067\u306f\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\uff08\u5165\u529b\u30c1\u30a7\u30c3\u30af\uff09\u3092\u884c\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
      \u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
      php artisan make:request SpreadsheetFormRequest<\/strong><\/pre>\n
      \u3059\u308b\u3068\u3001FormRequest<\/code>\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u4e2d\u8eab\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n
      app\/Http\/Requests\/SpreadsheetFormRequest.php<\/strong><\/p>\n
      <?php\r\n\r\nnamespace App\\Http\\Requests;\r\n\r\nuse App\\Rules\\SpreadsheetForm;\r\nuse Illuminate\\Foundation\\Http\\FormRequest;\r\n\r\nclass SpreadsheetFormRequest extends FormRequest\r\n{\r\n    \/**\r\n     * Determine if the user is authorized to make this request.\r\n     *\/\r\n    public function authorize(): bool\r\n    {\r\n        return true;\r\n    }\r\n\r\n    \/**\r\n     * Get the validation rules that apply to the request.\r\n     *\r\n     * @return array<string, \\Illuminate\\Contracts\\Validation\\ValidationRule|array|string>\r\n     *\/\r\n    public function rules(): array\r\n    {\r\n        $spreadsheet_data = config('spreadsheet_form.user_registration');\r\n\r\n        return [\r\n            'excel_file' => [\r\n                'required',\r\n                'file',\r\n                'mimes:xlsx',\r\n                new SpreadsheetForm($spreadsheet_data)\r\n            ]\r\n        ];\r\n    }\r\n\r\n    public function attributes()\r\n    {\r\n        return [\r\n            'excel_file' => 'Excel \u30d5\u30a1\u30a4\u30eb'\r\n        ];\r\n    }\r\n}\r\n<\/strong><\/pre>\n
      \u305d\u3057\u3066\u3001\u3053\u306e\u4e2d\u3067\u6307\u5b9a\u3057\u305f\u5c02\u7528\u306e\u72ec\u81ea\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u300cSpreadsheetForm<\/strong>\u300d\u3092\u3064\u304f\u308a\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
      php artisan make:rule SpreadsheetForm\r\n<\/strong><\/pre>\n
      \u3059\u308b\u3068\u3001Rule<\/code>\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u4e2d\u8eab\u3092\u6b21\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n
      app\/Rules\/SpreadsheetForm.php<\/strong><\/p>\n
      <?php\r\n\r\nnamespace App\\Rules;\r\n\r\nuse Closure;\r\nuse Illuminate\\Contracts\\Validation\\ValidationRule;\r\nuse Illuminate\\Support\\Arr;\r\nuse Illuminate\\Support\\Facades\\Validator;\r\nuse Illuminate\\Support\\Str;\r\n\r\nclass SpreadsheetForm implements ValidationRule\r\n{\r\n    public function __construct(\r\n        private array $spreadsheet_data\r\n    ) {}\r\n\r\n    public function validate(string $attribute, mixed $value, Closure $fail): void\r\n    {\r\n        $request = request();\r\n        $excel_path = $request->file($attribute)->path();\r\n        $spreadsheet = null;\r\n\r\n        try {\r\n\r\n            $spreadsheet = \\PhpOffice\\PhpSpreadsheet\\IOFactory::load($excel_path);\r\n\r\n        } catch (\\Throwable $th) {\r\n\r\n            $fail('Excel \u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002');\r\n            return;\r\n\r\n        }\r\n\r\n        $sheet = $spreadsheet->getActiveSheet();\r\n        $excel_data = $this->getExcelData($sheet);\r\n        $this->validateExcelData($excel_data, $fail);\r\n    }\r\n\r\n    private function getExcelData($sheet)\r\n    {\r\n        $excel_data = [];\r\n\r\n        foreach ($sheet->getRowIterator() as $i => $row) {\r\n\r\n            if($i === 1) continue;\r\n\r\n            $row_data = ['row_index' => $i];\r\n            $keys = [\r\n                'A' => 'name',\r\n                'B' => 'value',\r\n            ];\r\n            $cellIterator = $row->getCellIterator();\r\n            $cellIterator->setIterateOnlyExistingCells(false);\r\n\r\n            foreach ($cellIterator as $j => $cell) {\r\n\r\n                $key = $keys[$j] ?? null;\r\n\r\n                if(! is_null($key)) {\r\n\r\n                    $row_data[$key] = $cell->getValue();\r\n\r\n                }\r\n\r\n            }\r\n\r\n            $excel_data[] = $row_data;\r\n\r\n        }\r\n\r\n        return $excel_data;\r\n    }\r\n\r\n    private function validateExcelData($excel_data, $fail)\r\n    {\r\n        $errors = [];\r\n\r\n        foreach ($this->spreadsheet_data as $spreadsheet_values)\r\n        {\r\n            $checking_label = $spreadsheet_values['label'];\r\n            $checking_rules = $spreadsheet_values['rules'];\r\n\r\n            $excel_values = Arr::first(\r\n                $excel_data,\r\n                function($value) use ($checking_label) {\r\n\r\n                    return $value['name'] === $checking_label;\r\n\r\n                }\r\n            );\r\n            $excel_value = data_get($excel_values, 'value', null);\r\n            $excel_row_index = data_get($excel_values, 'row_index', null);\r\n\r\n            $random_str = Str::random(10);\r\n            $validator = Validator::make(\r\n                [$random_str => $excel_value],      \/\/ $data\r\n                [$random_str => $checking_rules],   \/\/ $rules\r\n                [],\r\n                [$random_str => $checking_label]    \/\/ $attributes\r\n            );\r\n\r\n            if($validator->fails()) {\r\n\r\n                $row_errors = Arr::flatten(\r\n                    $validator->errors()->toArray()\r\n                );\r\n\r\n                foreach ($row_errors as $row_error) {\r\n\r\n                    $errors[] = $excel_row_index .'\u884c\u76ee: '. $row_error;\r\n\r\n                }\r\n\r\n            }\r\n\r\n        }\r\n\r\n        if(count($errors) > 0) {\r\n\r\n            foreach ($errors as $error) {\r\n\r\n                $fail($error);\r\n\r\n            }\r\n\r\n            return false;\r\n\r\n        }\r\n\r\n        return true;\r\n    }\r\n}<\/strong><\/pre>\n
      \u3053\u306e\u4e2d\u3067\u3084\u3063\u3066\u3044\u308b\u3053\u3068\u306f\uff08\u3061\u3087\u3063\u3068\u8907\u96d1\u306b\u898b\u3048\u308b\u304b\u3082\u3067\u3059\u304c\uff09\u30b7\u30f3\u30d7\u30eb\u306b\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n
        \n
      1. Excel \u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/li>\n
      2. \u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3067\u5165\u529b\u30c1\u30a7\u30c3\u30af<\/li>\n
      3. \u30a8\u30e9\u30fc\u304c\u3072\u3068\u3064\u3067\u3082\u3042\u3063\u305f\u3089\u3001\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u3057\u3001OK\u306a\u3089\u901a\u904e\u3059\u308b<\/li>\n<\/ol>\n
        \u30d3\u30e5\u30fc\u3092\u3064\u304f\u308b<\/h1>\n
        \u3067\u306f\u3001\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u5185\u3067\u6307\u5b9a\u3057\u305f\u30d3\u30e5\u30fc\u3082\u3064\u304f\u308a\u307e\u3057\u3087\u3046\u3002
        \n\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
        <html>\r\n<head>\r\n    <meta name=\"viewport\" content=\"width=device-width, height=device-height, initial-scale=1, maximum-scale=1, user-scalable=no\">\r\n    <title>Excel \u3092\u30d5\u30a9\u30fc\u30e0\u3068\u3057\u3066\u4f7f\u3046\u30b5\u30f3\u30d7\u30eb<\/title>\r\n    <script src=\"https:\/\/cdn.tailwindcss.com\/3.3.2\"><\/script>\r\n    <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/axios\/dist\/axios.min.js\"><\/script>\r\n    <script defer src=\"https:\/\/cdn.jsdelivr.net\/npm\/alpinejs@3.12.1\/dist\/cdn.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n<div x-data=\"spreadsheetForm\">\r\n\r\n    <div class=\"p-7\">\r\n        <h1 class=\"mb-8\">&#x1F4CB; Excel \u3092\u30d5\u30a9\u30fc\u30e0\u3068\u3057\u3066\u4f7f\u3046\u30b5\u30f3\u30d7\u30eb<\/h1>\r\n\r\n        <div class=\"mb-8\">\r\n            <h2 class=\"mb-4\">\r\n                <span class=\"text-sm px-2 py-1 mr-1 bg-gray-400 text-white rounded-full\">1<\/span>\r\n                Excel \u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n            <\/h2>\r\n\r\n            <form method=\"post\" action=\"{{ route('spreadsheet_form.download') }}\" class=\"m-0 p-0\">\r\n                @csrf\r\n                <button type=\"submit\" class=\"text-sm bg-blue-500 hover:bg-blue-700 text-white font-bold py-2 px-4 rounded\">\r\n                    \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\r\n                <\/button>\r\n            <\/form>\r\n        <\/div>\r\n\r\n        <div class=\"mb-8\">\r\n            <h2 class=\"mb-4\">\r\n                <span class=\"text-sm px-2 py-1 mr-1 bg-gray-400 text-white rounded-full\">2<\/span>\r\n                \u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u3001\u5fc5\u8981\u306a\u9805\u76ee\u3092\u5165\u529b \uff06 \u9078\u629e\u3057\u3066\u4fdd\u5b58\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n            <\/h2>\r\n        <\/div>\r\n\r\n        <div class=\"mb-8\">\r\n            <h2 class=\"mb-4\">\r\n                <span class=\"text-sm px-2 py-1 mr-1 bg-gray-400 text-white rounded-full\">3<\/span>\r\n                \u305d\u306e Excel \u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n            <\/h2>\r\n            <div class=\"py-3\">\r\n                <label class=\"text-sm bg-blue-500 hover:bg-blue-700 text-white font-bold py-2.5 px-4 rounded\">\r\n                    <input type=\"file\" name=\"excel_file\" class=\"hidden\" accept=\".xlsx\" @change=\"onFileChange\" \/>\r\n                    \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\r\n                <\/label>\r\n            <\/div>\r\n            <template x-if=\"errors.excel_file\">\r\n                <div class=\"bg-red-100 border border-red-400 text-red-700 px-4 py-3 mt-4 rounded relative\" role=\"alert\">\r\n                    <strong class=\"font-bold\">&#x26A0; \u30a8\u30e9\u30fc!<\/strong>\r\n                    <template x-for=\"error in errors.excel_file\">\r\n                        <div x-text=\"error\"><\/div>\r\n                    <\/template>\r\n                <\/div>\r\n            <\/template>\r\n        <\/div>\r\n\r\n    <\/div>\r\n<\/div>\r\n<script>\r\n\r\n    const spreadsheetForm = {\r\n        errors: [],\r\n        onFileChange(e) {\r\n\r\n            const files = e.target.files;\r\n            const file = files[0];\r\n\r\n            if(file instanceof File) {\r\n\r\n                this.errors = [];\r\n\r\n                const url = '{{ route('spreadsheet_form.store') }}';\r\n                const formData = new FormData();\r\n                formData.append('excel_file', file);\r\n\r\n                axios.post(url, formData)\r\n                    .then((response) => {\r\n\r\n                        alert('\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');\r\n                        location.reload();\r\n\r\n                    })\r\n                    .catch((error) => {\r\n\r\n                        this.errors = error.response.data.errors;\r\n\r\n                        \/\/ \u30d5\u30a1\u30a4\u30eb\u9078\u629e\u3092\u30af\u30ea\u30a2\r\n                        const el = document.querySelector('input[type=\"file\"][name=\"excel_file\"]');\r\n                        el.value = '';\r\n\r\n                    });\r\n\r\n            }\r\n\r\n        }\r\n    };\r\n\r\n<\/script>\r\n<\/body>\r\n<\/html><\/strong><\/pre>\n
        \u306a\u304a\u3001\u3053\u3053\u3067Alpine.js<\/code>\u3068axios<\/code>\u3001TailwindCSS<\/code>\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
        \u30eb\u30fc\u30c8\u3092\u3064\u304f\u308b<\/h1>\n
        \u3067\u306f\u3001\u6700\u5f8c\u306b\u30eb\u30fc\u30c8\u3067\u3059\u3002
        \n\u4ee5\u4e0b\u306e\u90e8\u5206\u3092\u3059\u3067\u306b\u5b58\u5728\u3057\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306b\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
        routes\/web.php<\/strong><\/p>\n
        use App\\Http\\Controllers\\SpreadsheetFormController;\r\n\r\n\/\/ \u7701\u7565\r\nRoute::prefix('spreadsheet_form')->controller(SpreadsheetFormController::class)->group(function () {\r\n    Route::get('\/create', 'create')->name('spreadsheet_form.create');\r\n    Route::post('\/', 'store')->name('spreadsheet_form.store');\r\n    Route::post('\/download', 'download')->name('spreadsheet_form.download');\r\n});\r\n<\/strong><\/pre>\n
        \u3053\u308c\u3067\u4f5c\u696d\u306f\u5b8c\u4e86\u3067\u3059\u3002
        \n\u304a\u75b2\u308c\u69d8\u3067\u3057\u305f\u3002\ud83d\ude04\u2728<\/p>\n
        \u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b<\/h1>\n
        \u3067\u306f\u3001\u5b9f\u969b\u306b\u30c6\u30b9\u30c8\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u2757<\/p>\n
        \u307e\u305a\u3001\u30d6\u30e9\u30a6\u30b6\u3067\u300chttps:\/\/******\/spreadsheet_form\/create<\/strong>\u300d\u3078\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002<\/p>\n
        \"\"<\/p>\n
        \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3068\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306e\u30dc\u30bf\u30f3\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002
        \n\u3067\u306f\u3001\u307e\u305a\u306f\u300c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/strong>\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
        \"\"<\/p>\n
        \u3059\u308b\u3068\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n
        \"\"<\/p>\n
        \u306f\u3044\u2757
        \n\u81ea\u52d5\u3067Excel\u30d5\u30a1\u30a4\u30eb\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n
        \u3067\u306f\u3001\u4e2d\u8eab\u3092\u898b\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
        \"\"<\/p>\n
        \u306f\u3044\u2757
        \n\u5404\u9805\u76ee\u304c\u30bb\u30c3\u30c8\u3055\u308c\u3066\u3044\u3066\u3001\u300c\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<\/strong>\u300d\u306e\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\uff08\u30b9\u30af\u30b7\u30e7\u3067\u304d\u306a\u304b\u3063\u305f\u2026\ud83d\ude05\uff09<\/p>\n
        \u3067\u306f\u3001\u307e\u305a\u306f\u4f55\u3082\u5909\u66f4\u3057\u306a\u3044\uff08\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3060\u308d\u3046\uff09\u72b6\u614b\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
        \"\"<\/p>\n
        \u3059\u308b\u3068\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb<\/p>\n
        \"\"<\/p>\n
        \u306f\u3044\u2757
        \n\u9593\u9055\u3063\u3066\u3044\u308b\u884c\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n
        \u307e\u305a\u306f\u6210\u529f\u3067\u3059\u306d\u3002<\/p>\n
        \u3067\u306f\u3001\u6b21\u306b\u3061\u3083\u3093\u3068\u3057\u305f\u5165\u529b\u3092\u3057\u3066\u4fdd\u5b58\u3057\u3066\u304b\u3089\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
        \"\"<\/p>\n
        \u3069\u3046\u306a\u308b\u3067\u3057\u3087\u3046\u304b\u30fb\u30fb\u30fb\u30fb\u30fb\u30fb\ud83e\udd14<\/p>\n
        \"\"<\/p>\n
        \u306f\u3044\u2757
        \n\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u304c\u901a\u904e\u3057\u305f\u306e\u3067\u3001\u5b8c\u4e86\u306e\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u304c\u3067\u307e\u3057\u305f\u3002<\/p>\n
        \u3059\u3079\u3066\u6210\u529f\u3067\u3059\ud83d\ude04\u2728<\/p>\n
        \u4f01\u696d\u69d8\u3078\u306e\u3054\u63d0\u6848<\/h1>\n
        \u4eca\u56de\u5b9f\u88c5\u3057\u305f\u5185\u5bb9\u306f\u57fa\u672c\u7684\u306a\u6a5f\u80fd\u3092\u4f7f\u3063\u305f\u3082\u306e\u3067\u3057\u305f\u304c\u3001PhpSpreadsheet<\/code>\u3067\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u3082\u306e\u3092\u30bb\u30eb\u306b\u7528\u610f\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n