{"id":2961,"date":"2026-07-30T18:04:04","date_gmt":"2026-07-30T09:04:04","guid":{"rendered":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/?page_id=2961"},"modified":"2026-08-24T15:19:31","modified_gmt":"2026-08-24T06:19:31","slug":"laravel-05","status":"publish","type":"page","link":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/programming\/php\/laravel-05","title":{"rendered":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3046"},"content":{"rendered":"
\n \n \u524d\u56de\u7d42\u4e86\u6642\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\n <\/summary>\n

Laravel\u3092\u4f7f\u3063\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n

\n$ git clone https:\/\/kiku3.tsbio.info\/git\/study-laravel.git study_laravel\n<\/pre><\/div>\n\n
\u3053\u306e\u7ae0\u958b\u59cb\u6642\u70b9\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306f chapt5 \u30d6\u30e9\u30f3\u30c1\u306b\u3042\u308a\u307e\u3059\u3002<\/p>\n
\n$ git switch chapt5\n<\/pre><\/div>\n\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u81ea\u5206\u3067\u66f8\u3044\u3066\u3044\u304f\u5834\u5408\u306f\u3001\u81ea\u5206\u7528\u306e\u30d6\u30e9\u30f3\u30c1\u3092\u3064\u304f\u308b\u3068\u3088\u3044\u3067\u3059\u3002<\/p>\n
\n$ git switch -c my5 chapt5\n<\/pre><\/div>\n\n
Laravel\u306e\u30b3\u30fc\u30c9\u306fsrc\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304b\u3089\u306e\u76f8\u5bfe\u30d1\u30b9\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<\/details>\n\n\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3046<\/h2>\n
PostgreSQL\u3092\u4f7f\u3048\u308b\u3088\u3046\u306b\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u9023\u643a\u3057\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3057\u307e\u3059\u3002<\/p>\n
PHP\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u5165\u308c\u308b<\/h3>\n
Docker\u306e\u30a4\u30e1\u30fc\u30b8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002<\/p>\n
<\/p>\n
\n  
php\/Dockerfile<\/h5>\n
\nFROM php:8.5-fpm\r\n\r\nRUN apt-get update && apt-get install -y unzip \\\r\n    libpq-dev \\\r\n    libonig-dev \\\r\n    && docker-php-ext-install pdo pdo_pgsql\r\n\r\nCOPY --from=composer:2 \/usr\/bin\/composer \/usr\/bin\/composer\r\n\r\nWORKDIR \/var\/www\/html\n<\/pre>\n<\/div>\n
\n$ sudo docker compose build\n<\/pre><\/div>\n
docker\u3067PostgreSQL\u3092\u4f7f\u3046<\/h3>\n
\u3059\u3067\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3042\u308b\u306e\u306a\u3089\u6539\u3081\u3066\u3064\u304f\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002\ndocker-compose.yaml<\/code>\u306bpostgresql\u306e\u8a2d\u5b9a\u3092\u52a0\u3048\u3066\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n
<\/p>\n
\n  
docker-compose.yaml<\/h5>\n
\nservices:\n  php:\n    build: .\/php\n    container_name: laravel_php\n    volumes:\n      - .\/src:\/var\/www\/html\n      - vendor:\/var\/www\/html\/vendor\n    environment:\n      - TZ=Asia\/Tokyo\n \n  nginx:\n    image: nginx:1.27-alpine\n    container_name: laravel_nginx\n    ports:\n      - "8002:80"\n    volumes:\n      - .\/src\/public:\/var\/www\/html\/public:ro\n      - .\/nginx\/default.conf:\/etc\/nginx\/conf.d\/default.conf\n \n  db:\n    image: postgres:18.4-bookworm    # \u672c\u7a3f\u57f7\u7b46\u6642\u306e\u6700\u65b0\u7248\u3002\u7279\u6bb5\u3001\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u306f\u306a\u3044\n    environment:\n      POSTGRES_USER: appuser\n      POSTGRES_PASSWORD: secret\n      POSTGRES_DB: appdb\n    volumes:\n      - db_data:\/var\/lib\/postgresql\n    ports:\n      - "5432:5432"\n \nvolumes:\n  vendor:\n  db_data:\n<\/pre>\n<\/div>\n
\n$ sudo docker compose up -d\n<\/pre><\/div>\n
.env \u3092\u7de8\u96c6\u3059\u308b<\/h3>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u95a2\u9023\u306e\u8a2d\u5b9a\u3092\u3057\u307e\u3059\u3002<\/p>\n
\n
.env<\/h5>\n
\nDB_CONNECTION=pgsql\nDB_HOST=db\nDB_PORT=5432\nDB_DATABASE=appdb\nDB_USERNAME=appuser\nDB_PASSWORD=secret\n<\/pre>\n<\/div>\n
\u63a5\u7d9a\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n
artisan<\/code> \u306e tinker<\/code> \u30b5\u30d6\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3046\u3068\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u8d77\u52d5\u3057\u305f\u72b6\u614b\u3067\u3001PHP\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002\ndocker\u3092\u4f7f\u3063\u3066\u3044\u308b\u5834\u5408\u306fsudo docker compose exec -it php bash<\/code> \u3057\u3066\u304b\u3089\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
\n# .\/artisan tinker \n> DB::select('select 1')\n
= [\n{#7411\n+"?column?": 1,\n},\n]\n<\/pre><\/div><\/p>\n
\u30c6\u30fc\u30d6\u30eb\u3092\u3064\u304f\u308b<\/h2>\n
laravel\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u3064\u304f\u308b\u306e\u306f\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3(migration)\u3068\u8a00\u3044\u307e\u3059\u3002\n\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u5143\u3005\u79fb\u4f4f\u3068\u304b\u79fb\u52d5\u3068\u304b\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u304c\u3001\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u95a2\u4fc2\u3067\u306f\u5225\u306e\u74b0\u5883\u3078\u306e\u4e57\u308a\u63db\u3048\u3068\u3044\u3046\u610f\u5473\u3067\u4f7f\u308f\u308c\u307e\u3059\u3002\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30b9\u30ad\u30fc\u30de(\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u306b\u73fe\u308c\u308b\u67a0\u7d44\u307f)\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3092\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3068\u547c\u3076\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n
\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u3082PHP\u306e\u30b3\u30fc\u30c9\u3067\u66f8\u304f\u3053\u3068\u304c\u3067\u304d\u3001\u305d\u306e\u5909\u66f4\u3092artisan<\/code>\u30b3\u30de\u30f3\u30c9\u3067\u7ba1\u7406\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
\n# .\/artisan make:migration create_oligos_table\n<\/pre>\n
\u3053\u308c\u306b\u3088\u308a database\/migrations<\/code> \u4ee5\u4e0b\u306b 2026_07_30_082653_create_oligos_table.php<\/code> \u304c\u4f5c\u3089\u308c\u307e\u3059\u3002\n\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u6570\u5b57\u306e\u90e8\u5206\u306f\u3001\u4f5c\u6210\u3057\u305f\u65e5\u6642\u306a\u3069\u304b\u3089\u306a\u308b\u91cd\u8907\u3057\u306a\u3044\u756a\u53f7\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u7de8\u96c6\u3057\u307e\u3059\u3002<\/p>\n
\n  
database\/migrations\/2026_07_30_082653_create_oligos_table.php<\/h5>\n
\n<?php\n \nuse Illuminate\\Database\\Migrations\\Migration;\nuse Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n \nreturn new class extends Migration\n{\n    \/**\n     * Run the migrations.\n     *\/\n    public function up(): void\n    {\n        Schema::create('oligos', function (Blueprint $table) {\n            $table->id();\n            $table->string('name');\n            $table->string('sequence');\n            $table->float('concentration')->nullable(); \/\/ \u6fc3\u5ea6\u3002nullable\u3092\u3064\u3051\u308b\u3068\u3001\u5024\u304c\u306a\u304f\u3066\u3082\u3088\u3044\u3053\u3068\u306b\u306a\u308b\n            $table->string('box')->nullable();      \/\/ \u4fdd\u7ba1\u5834\u6240\n            $table->string('owner')->nullable();    \/\/ \u6240\u6709\u8005\n            $table->string('supplier')->nullable();    \/\/ \u8ca9\u58f2\u5143\n            $table->string('note')->nullable();\n            $table->timestamps();       \/\/ created_at, updated_at \u304c\u4f5c\u3089\u308c\u308b\n            $table->softDeletes();       \/\/ deleted_at \u304c\u4f5c\u3089\u308c\u308b\n        });\n    }\n \n    \/**\n     * Reverse the migrations.\n     *\/\n    public function down(): void\n    {\n        Schema::dropIfExists('oligos');\n    }\n};\n<\/pre>\n<\/div>\n
Blueprint\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e$table\u306b\u30e1\u30bd\u30c3\u30c9\u3092\u9069\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u578b\u3092\u6307\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u5217\u3092\u3064\u304f\u308b\u30e1\u30bd\u30c3\u30c9\u3092\u3044\u304f\u3064\u304b\u4e0b\u306b\u793a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u30e1\u30bd\u30c3\u30c9<\/th>\n\u4f5c\u6210\u3055\u308c\u308b\u578b<\/th>\n<\/tr>\n<\/thead>\n
id<\/td>\n\u81ea\u52d5\u63a1\u756a\u3067\u4e3b\u30ad\u30fc\u306b\u306a\u308b\u3002\u5f15\u6570\u3092\u7701\u7565\u3059\u308b\u3068id\u3068\u3044\u3046\u5217\u540d\u304c\u4f7f\u308f\u308c\u308b\u3002<\/td>\n<\/tr>\n
integer<\/td>\n\u6574\u6570<\/td>\n<\/tr>\n
float<\/td>\n\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570<\/td>\n<\/tr>\n
double<\/td>\nfloat\u3088\u308a\u7cbe\u5ea6\u306e\u9ad8\u3044\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570<\/td>\n<\/tr>\n
string<\/td>\n\u6587\u5b57\u6570\u3092\u6307\u5b9a\u3057\u305f\u6587\u5b57\u5217\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u306f255\u6587\u5b57\u3002<\/td>\n<\/tr>\n
text<\/td>\n\u9577\u3044\u6587\u5b57\u5217\u3002<\/td>\n<\/tr>\n
date<\/td>\n\u65e5\u4ed8\u306e\u307f<\/td>\n<\/tr>\n
timestamp<\/td>\n\u65e5\u6642<\/td>\n<\/tr>\n
timestamps<\/td>\ncreated_at \u3068 updated_at\u304c\u3064\u304f\u3089\u308c\u3001\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\u65e5\u6642\u3068\u66f4\u65b0\u65e5\u6642\u304c\u81ea\u52d5\u7684\u306b\u8a18\u9332\u3055\u308c\u308b\u3002<\/td>\n<\/tr>\n
softDeletes<\/td>\ndeleted_at\u304c\u3064\u304f\u3089\u308c\u3001null\u3067\u306a\u3044\u3068\u304d\u306b\u898b\u3048\u306a\u3044\u3088\u3046\u306b\u306a\u308b\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u30ec\u30b3\u30fc\u30c9\u306b\u5bfe\u3059\u308b\u5236\u7d04\u3092\u3064\u3051\u308b\u306b\u306f\u3001\u6b21\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n
\u30e1\u30bd\u30c3\u30c9<\/th>\n\u5236\u7d04<\/th>\n<\/tr>\n<\/thead>\n
nullable<\/td>\nnull\u5024\u3092\u8a31\u5bb9\u3059\u308b\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u306fNOT NULL\u306a\u306e\u3067\u3001\u3064\u3051\u306a\u3051\u308c\u3070NOT NULL\u306b\u306a\u308b\u3002<\/td>\n<\/tr>\n
default<\/td>\n\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u5171\u901aID<\/h3>\n
\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u30c6\u30fc\u30d6\u30eb\u3054\u3068\u306bid\u5217\u304c\u3064\u304f\u3089\u308c\u3001\u30b7\u30ea\u30a2\u30eb\u578b\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002\n\u3057\u304b\u3057\u3001\u3053\u306e\u65b9\u5f0f\u3067\u306f\u30ea\u30bd\u30fc\u30b9\u304c\u5897\u3048\u3066\u304d\u305f\u3068\u304d\u306b\u540c\u3058\u756a\u53f7\u306e\u3082\u306e\u304c\u3064\u3051\u3089\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059(\u4f8b\u3048\u3070\u30aa\u30ea\u30b4DNA\u3068\u7a2e\u5b50\u306b\u540c\u3058id\u304c\u3075\u3089\u308c\u308b)\u3002\n\u57fa\u672c\u7684\u306b\u3053\u306eid\u3092\u30e6\u30fc\u30b6\u30fc\u304c\u610f\u8b58\u3059\u308b\u3053\u3068\u306f\u306a\u3044\u306e\u3067\u3001\u3053\u306e\u307e\u307e\u3067\u3082\u3088\u3044\u306e\u3067\u3059\u304c\u3001\u30ea\u30bd\u30fc\u30b9\u3068\u3057\u3066\u91cd\u8907\u3057\u306a\u3044\u756a\u53f7\u3092\u3064\u3051\u308b\u3088\u3046\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u305d\u306e\u5834\u5408\u3001\u30ea\u30bd\u30fc\u30b9\u306b\u3064\u3051\u308b\u756a\u53f7\u3092lab_id\u3068\u3057\u3066\u7ba1\u7406\u3057\u307e\u3059\u3002\n\u305d\u306e\u305f\u3081\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u6b21\u306e\u3088\u3046\u306b\u4fee\u6b63\u3057\u307e\u3059\u3002\n\u3053\u306e\u30b7\u30ea\u30a2\u30eb\u5024\u3092\u5b9a\u7fa9\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u306f\u3001\u3067\u304d\u308b\u3060\u3051\u5148\u982d\u306e\u307b\u3046\u306b\u304f\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
\n# .\/artisan make:migration create_lab_id\n<\/pre><\/div>\n
<\/p>\n
\n  
database\/migrations\/2026_07_30_000001_create_lab_id.php<\/h5>\n
\n<?php\n \nuse Illuminate\\Database\\Migrations\\Migration;\nuse Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\nuse Illuminate\\Support\\Facades\\DB;\n \nreturn new class extends Migration\n{\n    private const SEQUENCE = 'lab_id';\n \n    \/**\n     * Run the migrations.\n     *\/\n    public function up(): void\n    {\n        DB::statement("CREATE SEQUENCE IF NOT EXISTS " . self::SEQUENCE);\n    }\n \n    \/**\n     * Reverse the migrations.\n     *\/\n    public function down(): void\n    {\n        DB::statement("DROP SEQUENCE IF EXISTS " . self::SEQUENCE);\n    }\n};\n<\/pre>\n<\/div>\n
\n  
database\/migrations\/2026_07_30_082653_create_oligos_table.php<\/h5>\n
\n<?php\n \nuse Illuminate\\Database\\Migrations\\Migration;\nuse Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\nuse Illuminate\\Support\\Facades\\DB;\n \nreturn new class extends Migration\n{\n    private const SEQUENCE = 'lab_id';\n \n    \/**\n     * Run the migrations.\n     *\/\n    public function up(): void\n    {\n        Schema::create('oligos', function (Blueprint $table) {\n            $table->integer('id')\n                ->primary()\n                ->default(DB::raw("nextval('" . self::SEQUENCE . "')"));\n            $table->string('name');\n            $table->string('sequence');\n            $table->float('concentration')->nullable(); \/\/ \u6fc3\u5ea6\u3002nullable\u3092\u3064\u3051\u308b\u3068\u3001\u5024\u304c\u306a\u304f\u3066\u3082\u3088\u3044\u3053\u3068\u306b\u306a\u308b\n            $table->string('box')->nullable();      \/\/ \u4fdd\u7ba1\u5834\u6240\n            $table->string('owner')->nullable();    \/\/ \u6240\u6709\u8005\n            $table->string('supplier')->nullable();    \/\/ \u8ca9\u58f2\u5143\n            $table->string('note')->nullable();\n            $table->timestamps();       \/\/ created_at, updated_at \u304c\u4f5c\u3089\u308c\u308b\n            $table->softDeletes();       \/\/ deleted_at \u304c\u4f5c\u3089\u308c\u308b\n        });\n    }\n \n    \/**\n     * Reverse the migrations.\n     *\/\n    public function down(): void\n    {\n        Schema::dropIfExists('oligos');\n    }\n};\n<\/pre>\n<\/div>\n
\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210<\/h3>\n
artisan\u306emigration\u30b5\u30d6\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001migrations\u30d5\u30a9\u30eb\u30c0\u306b\u3042\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u4e00\u5ea6\u3060\u3051\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n
\n# .\/artisan migrate\n<\/pre><\/div>\n
laravel\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u3042\u308busers, cache, jobs\u30c6\u30fc\u30d6\u30eb\u3082\u3064\u304f\u3089\u308c\u308b\u3002\u307e\u305f\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u7ba1\u7406\u7528\u306e\u30c6\u30fc\u30d6\u30eb\u3082\u3067\u304d\u308b\u3002<\/p>\n
\n$ sudo docker compose exec -it db psql -U appuser appdb\nappdb=# \\d\n                  List of relations\n Schema |         Name          |   Type   |  Owner\n--------+-----------------------+----------+---------\n public | cache                 | table    | appuser\n public | cache_locks           | table    | appuser\n public | failed_jobs           | table    | appuser\n public | failed_jobs_id_seq    | sequence | appuser\n public | job_batches           | table    | appuser\n public | jobs                  | table    | appuser\n public | jobs_id_seq           | sequence | appuser\n public | lab_id                | sequence | appuser\n public | migrations            | table    | appuser\n public | migrations_id_seq     | sequence | appuser\n public | oligos                | table    | appuser\n public | password_reset_tokens | table    | appuser\n public | sessions              | table    | appuser\n public | users                 | table    | appuser\n public | users_id_seq          | sequence | appuser\n(15 rows) \n<\/pre>\n
\u521d\u671f\u30c7\u30fc\u30bf\u3092\u6295\u5165\u3059\u308b<\/h2>\n
csv\u3067\u4fdd\u5b58\u3057\u3066\u3042\u3063\u305f\u30aa\u30ea\u30b4DNA\u306e\u30c7\u30fc\u30bf\u3092\u3044\u308c\u307e\u3059\u3002<\/p>\n
\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u52d5\u304b\u3059\u30b3\u30de\u30f3\u30c9\u306e\u4f5c\u6210<\/h3>\n
artisan<\/code>\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3063\u3066\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u52d5\u304b\u3059\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u3064\u308a\u307e\u3059\u3002<\/p>\n
\n# .\/artisan make:command ImportOligo\n<\/pre>\n
\u3053\u308c\u306b\u3088\u3063\u3066 app\/Console\/Commands\/ImportOligo.php<\/code> \u304c\u4f5c\u3089\u308c\u308b\u3002\n\u3053\u308c\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4fee\u6b63\u3059\u308b\u3002<\/p>\n
\n  
app\/Console\/Commands\/ImportOligo.php<\/h5>\n
\n<?php\n \nnamespace App\\Console\\Commands;\n \nuse Illuminate\\Console\\Attributes\\Description;\nuse Illuminate\\Console\\Attributes\\Signature;\nuse Illuminate\\Console\\Command;\nuse Illuminate\\Support\\Facades\\DB;\n \n#[Signature('app:import-oligo')]\n#[Description('Import oligo data from a CSV file')]\nclass ImportOligo extends Command\n{\n    public function handle()\n    {\n        $csv = storage_path('app\/private\/oligo.csv');\n        $table = 'oligos';\n \n        $fp = fopen($csv, 'r');\n        $items = [];\n        while($row = fgetcsv($fp)){\n            $item = array_combine(['name', 'sequence', 'created_at', 'owner'], $row);\n            try{\n                DB::table($table)->insert($item);\n            } catch (\\Throwable $e) {\n                var_dump($item);\n                $this->error("Failed to insert row into table: ${table}");\n                return self::FAILURE;\n            }\n        }\n        fclose($fp);\n        return self::SUCCESS;\n    }\n}\n<\/pre>\n<\/div>\n
class\u540d\u306e\u4e0a\u306e\u90e8\u5206\u306b\u3042\u308b#[Signature('app:import-oligo')]<\/code> \u306f\u30a2\u30c8\u30ea\u30d3\u30e5\u30fc\u30c8(\u5c5e\u6027)\u3067\u3001\u7d9a\u304fclass\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3068\u306a\u308a\u307e\u3059\u3002\nIlluminate\\Console\\Command \u30af\u30e9\u30b9\u306f\u3053\u308c\u3092\u30ea\u30d5\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u3088\u3063\u3066\u8aad\u307f\u8fbc\u307f\u3001\u30af\u30e9\u30b9\u5909\u6570\u306esignature\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n\u3053\u306e\u5024\u306f artisan<\/code>\u306e\u30b5\u30d6\u30b3\u30de\u30f3\u30c9\u3068\u3057\u3066\u306f\u305f\u3089\u304d\u3001handle<\/code>\u30e1\u30bd\u30c3\u30c9\u304c\u547c\u3070\u308c\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
#[Description('Import oligo data from a CSV file')]<\/code> \u3082\u540c\u3058\u3067\u3059\u3002<\/p>\n
\u5b9f\u884c<\/h3>\n
\u3067\u304d\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4e0b\u8a18\u306e\u3088\u3046\u306b\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
\n# .\/artisan app:import-oligo \n<\/pre>\n
\u30c6\u30fc\u30d6\u30eb\u3092CSV\u3067\u51fa\u529b\u3059\u308b<\/h2>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u3092CSV\u5f62\u5f0f\u3067\u51fa\u529b\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
\u30b3\u30de\u30f3\u30c9\u3092\u3064\u304f\u308b<\/h3>\n
<\/p>\n
\n# .\/artisan make:command ExportTable\n<\/pre>\n
\n  
app\/Console\/Commands\/ExportTable.php<\/h5>\n
\n<?php\n \nnamespace App\\Console\\Commands;\n \nuse Illuminate\\Console\\Attributes\\Description;\nuse Illuminate\\Console\\Attributes\\Signature;\nuse Illuminate\\Console\\Command;\nuse Illuminate\\Support\\Facades\\DB;\n \n#[Signature('app:export-table {table}')]\n#[Description('Export table data to a CSV file')]\nclass ExportTable extends Command\n{\n    public function handle()\n    {\n        $table = $this->argument('table');\n \n        $path_template = join('-', [$table, now()->format('ymd'), '%02d.csv']);\n        $n = 1;\n \n        \/\/ \u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3059\u308b\u9593\u306f\u756a\u53f7\u3092\u5897\u3084\u3057\u3066\u30eb\u30fc\u30d7\u3092\u7d9a\u3051\u308b\n        do {\n            $csv = storage_path("app\/private\/" . sprintf($path_template, $n++));\n        } while (file_exists($csv));\n \n        try{\n            $rows = DB::table($table)->get();\n        } catch (\\Throwable $e) {\n            $this->error("Failed to fetch rows from table: ${table}");\n            return self::FAILURE;\n        }\n \n        if ($rows->isEmpty()) {\n            $this->warn("No rows found in table: {$table}");\n            return self::SUCCESS;\n        }\n \n        $out = fopen($csv, 'w');\n \n        \/\/ \u30d8\u30c3\u30c0\u30fc\u884c\n        fputcsv($out, array_keys((array) $rows->first()));\n \n        \/\/ \u30c7\u30fc\u30bf\u884c\n        foreach ($rows as $row) {\n            fputcsv($out, (array) $row);\n            $this->warn("Exported row: " . json_encode($row));\n        }\n \n        fclose($out);\n        $this->info("Exported to $csv.");\n \n        return self::SUCCESS;\n    }\n}\n<\/pre>\n<\/div>\n
\u5b9f\u884c\u3059\u308b<\/h3>\n
\n# .\/artisan app:export-table oligos \n<\/pre>\n
Eloquent\u3092\u4f7f\u3046<\/h2>\n
Eloquent\u306f\u3001Laravel\u6a19\u6e96\u306e\u3001Object Relational Mapper (ORM)\u3067\u3059\u3002\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u3001PHP\u306e\u30af\u30e9\u30b9\u3092\u5bfe\u5fdc\u3065\u3051\u3066\u3001SQL\u3092\u4f7f\u308f\u305a\u306b\u5165\u51fa\u529b\u306a\u3069\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
\u30e2\u30c7\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u3084\u305d\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u8868\u3059\u3082\u306e\u3092\u30e2\u30c7\u30eb<\/code>\u3068\u547c\u3073\u307e\u3059\u3002\n\u8868\u3092PHP\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u308a\u51fa\u3057\u3092SQL\u3067\u306f\u306a\u304f\u3001\u30e1\u30bd\u30c3\u30c9\u3067\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\n\u307e\u305f\u3001\u30ec\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\u3001\u66f4\u65b0\u3084\u524a\u9664\u3082\u30e1\u30bd\u30c3\u30c9\u3092\u901a\u3058\u3066\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
<\/p>\n
\n  
app\/Models\/Oligo.php<\/h5>\n
\n<?php\n \nnamespace App\\Models;\n \nuse Illuminate\\Database\\Eloquent\\Model;\nuse Illuminate\\Database\\Eloquent\\SoftDeletes;\n \nclass Oligo extends Model\n{\n    use SoftDeletes; \/\/ delete\u3057\u305f\u3068\u304d\u306b\u3001\u5b9f\u969b\u306b\u524a\u9664\u305b\u305a\u3001deleted_at\u306b\u6642\u523b\u3092\u8a2d\u5b9a\u3059\u308b\n \n    \/\/  \u8868\u793a\u3057\u306a\u3044\u5217\u3092\u6307\u5b9a\u3059\u308b (toArray, json\u306a\u3069\u3067\u51fa\u529b\u3055\u308c\u306a\u3044)\n    protected $hidden = ['deleted_at'];\n}\n<\/pre>\n<\/div>\n
\u4e00\u89a7\u8868\u793a\u306b\u4f7f\u7528\u3059\u308b<\/h3>\n
\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u5143\u3092CSV\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5909\u66f4\u3057\u307e\u3059\u3002\n<\/p>\n
\n  
app\/Http\/Controllers\/OligoController.php<\/h5>\n
\n<?php\n \nnamespace App\\Http\\Controllers;\n \nuse App\\Http\\Requests\\OligoRequest;\nuse App\\Models\\Oligo; \/\/ Oligo\u30e2\u30c7\u30eb\u3092\u4f7f\u3046\n \nclass OligoController\n{\n    public function index(){\n        $items = Oligo::all();  \/\/ \u3059\u3079\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b\n        return view('oligo.index', compact('items'))\n            ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-index")\n        ;\n    }\n \n    public function create(){\n        return view('oligo.create')\n\t    ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-create")\n        ;\n    }\n \n    public function store(OligoRequest $request){\n        $validated = $request->validated();\n        $data = [];\n        foreach(['name', 'sequence', 'created_at', 'owner'] as $key){\n            $data[] = sprintf('"%s"', $validated[$key] ?? '');\n        }\n        $csv = storage_path('app\/private\/oligo.csv');\n        file_put_contents($csv, implode(',', $data).PHP_EOL, FILE_APPEND);\n \n        return redirect()->route('web.oligo.index')->with('status', '\u4fdd\u5b58\u3057\u307e\u3057\u305f');\n    }\n}\n<\/pre>\n<\/div>\n
\u30d3\u30e5\u30fc\u3082\u5c11\u3057\u4fee\u6b63\u3057\u3066\u3001ID\u3082\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002\n\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u8868\u793a\u306f $item['name']<\/code> \u306e\u307e\u307e\u3067\u3059\u304c\u3001 $item->name<\/code> \u306e\u3088\u3046\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u3082\u66f8\u3051\u307e\u3059\u3002\n<\/p>\n
\n  
resources\/views\/oligo\/index.blade.php<\/h5>\n
\n@extends('oligo.module')\n \n@section('feature')\n<x-feature id='oligo-index'>\n  <table>\n    <thead>\n      <tr><th>id<\/th><th>\u540d\u524d<\/th><th>\u914d\u5217<\/th><th>\u4f5c\u6210\u65e5<\/th><th>\u6240\u6709\u8005<\/th><\/tr>\n    <\/thead>\n    <tbody>\n      @foreach($items as $item) {{-- \u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u304b\u3089\u6e21\u3055\u308c\u305f$items\u3092\u8868\u793a\u3059\u308b --}}\n        <tr>\n          <td>{{ $item['id'] }}<\/td>  {{-- $item->id \u3068\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b --}}\n          <td>{{ $item['name'] }}<\/td>\n          <td>{{ $item['sequence'] }}<\/td>\n          <td>{{ $item['created_at'] }}<\/td>\n          <td>{{ $item['owner'] }}<\/td>\n        <\/tr>\n      @endforeach\n    <\/tbody>\n  <\/table>\n<\/x-feature>\n@endsection\n<\/pre>\n<\/div>\n
\u30c7\u30fc\u30bf\u306e\u767b\u9332\u306b\u4f7f\u7528\u3059\u308b<\/h3>\n
\u9023\u60f3\u914d\u5217\u3067\u30c7\u30fc\u30bf\u3092\u6e21\u3057\u307e\u3059\u304c\u3001\u305d\u306e\u3068\u304d\u306b\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u3057\u3066\u6709\u52b9\u306a\u30ad\u30fc\u3092fillable\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n
\n  
app\/Models\/Oligo.php<\/h5>\n
\n<?php\n \nnamespace App\\Models;\n \nuse Illuminate\\Database\\Eloquent\\Model;\nuse Illuminate\\Database\\Eloquent\\SoftDeletes;\nuse Illuminate\\Database\\Eloquent\\Attributes\\Fillable;\n \n\/*\n * Fillable\u3067\u6307\u5b9a\u3057\u305f\u5217\u306fcreate\u3068\u304bupdate\u3067\u65b0\u3057\u3044\u5024\u3092\u914d\u5217\u3068\u3057\u3066\u53d7\u3051\u53d6\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002\n * \u3053\u3053\u306b\u306a\u3044\u540d\u524d\u306f\u4e0e\u3048\u3089\u308c\u305f\u3068\u3057\u3066\u3082\u7121\u8996\u3055\u308c\u308b\u3002['id' => 123] \u3068\u3044\u3046\u306e\u3092\u6e21\u3055\u308c\u305f\u3068\u3057\u3066\u3082id\u306f\u66f4\u65b0\u3055\u308c\u306a\u3044\u3002\n *\/\n#[Fillable(['name', 'sequence', 'concentration', 'box', 'owner', 'note', 'created_at', 'updated_at'])]\nclass Oligo extends Model\n{\n    use SoftDeletes;\n \n    protected $hidden = ['deleted_at'];\n}\n<\/pre>\n<\/div>\n
\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3067\u30c7\u30fc\u30bf\u3092\u30e2\u30c7\u30eb\u306b\u6e21\u3057\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
\n  
app\/Http\/Controllers\/OligoController.php<\/h5>\n
\n<?php\n \nnamespace App\\Http\\Controllers;\n \nuse App\\Http\\Requests\\OligoRequest;\nuse App\\Models\\Oligo; \/\/ Oligo\u30e2\u30c7\u30eb\u3092\u4f7f\u3046\n \nclass OligoController\n{\n    public function index(){\n        $items = Oligo::all();  \/\/ \u3059\u3079\u3066\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b\n        return view('oligo.index', compact('items'))\n            ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-index")\n        ;\n    }\n \n    public function create(){\n        return view('oligo.create')\n\t    ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-create")\n        ;\n    }\n \n    public function store(OligoRequest $request){\n        $validated = $request->validated();\n        Oligo::create($validated);\n \n        return redirect()->route('web.oligo.index')->with('status', '\u4fdd\u5b58\u3057\u307e\u3057\u305f');\n    }\n}\n<\/pre>\n<\/div>\n
\u65e5\u4ed8\u306e\u8868\u793a\u65b9\u6cd5\u3092\u5909\u66f4\u3059\u308b<\/h3>\n
\u7814\u7a76\u5ba4\u3067\u306f\u65e5\u4ed8\u3092\u3088\u304f6\u6841\u306e\u6570\u5b57\u3067\u8868\u3057\u307e\u3059\u3002date('ymd')<\/code> \u3068\u3044\u3046\u611f\u3058\u3067\u3059\u3002\n\u3053\u306e\u5f62\u5f0f\u3092\u53d6\u308a\u6271\u3048\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u4f7f\u7528\u3059\u308b\u306e\u3067\u3001Trait\u3068\u3057\u3066\u3064\u304f\u308a\u307e\u3059\u3002\n<\/p>\n
\n  
app\/Traits\/ConvertsYmdDate.php<\/h5>\n
\n<?php\n \nnamespace App\\Traits;\n \nuse Carbon\\Carbon;\n \ntrait ConvertsYmdDate\n{\n    \/**\n     * 6\u6841\u306e\u6570\u5b57 (YYMMDD) \u2192 \u65e5\u4ed8 (YYYY-MM-DD)\n     *\/\n    protected function ymdToDate(string $ymd): string\n    {\n        if(preg_match('\/^\\d{6}$\/', $ymd)){\n            return Carbon::createFromFormat('ymd', $ymd)->startOfDay();\n        }\n        return $ymd;\n    }\n \n    \/**\n     * \u65e5\u4ed8 (YYYY-MM-DD) \u2192 6\u6841\u306e\u6570\u5b57 (YYMMDD)\n     *\/\n    protected function dateToYmd(string $date): string\n    {\n        \/\/ Carbon \u3092\u4f7f\u3063\u3066\u5b89\u5168\u306b\u5909\u63db\n        return Carbon::parse($date)->format('ymd');\n    }\n}\n<\/pre>\n<\/div>\n
\u30e2\u30c7\u30eb\u3092\u4fee\u6b63\u3057\u3066\u3001created_at\u3068updated_at\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u304d\u306b\u3001Trait\u3067\u5b9a\u7fa9\u3057\u305f\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n
\n  
app\/Models\/Oligo.php<\/h5>\n
\n<?php\n \nnamespace App\\Models;\n \nuse Illuminate\\Database\\Eloquent\\Model;\nuse Illuminate\\Database\\Eloquent\\SoftDeletes;\nuse Illuminate\\Database\\Eloquent\\Attributes\\Fillable;\nuse Illuminate\\Database\\Eloquent\\Casts\\Attribute;  # \nuse App\\Traits\\ConvertsYmdDate;\n \n#[Fillable(['name', 'sequence', 'concentration', 'box', 'owner', 'note', 'created_at', 'updated_at'])]\nclass Oligo extends Model\n{\n    use SoftDeletes;\n    use ConvertsYmdDate;\n \n    \/\/  \u8868\u793a\u3057\u306a\u3044(toArray, json\u306a\u3069\u3067\u51fa\u529b\u3055\u308c\u306a\u3044)\n    protected $hidden = ['deleted_at'];\n    protected function createdAt(): Attribute\n    {\n        return Attribute::make(\n            get: function ($value, $attributes) {\n                return isset($attributes['created_at'])\n                    ? $this->dateToYmd($attributes['created_at'])\n                    : null;\n            },\n            set: function ($value) {\n                return ['created_at' => $value ? $this->ymdToDate($value) : null];\n            },\n        );\n    }\n \n    protected function updatedAt(): Attribute\n    {\n        return Attribute::make(\n            get: function ($value, $attributes) {\n                return isset($attributes['updated_at'])\n                    ? $this->dateToYmd($attributes['updated_at'])\n                    : null;\n            },\n \n            set: function ($value) {\n                return ['updated_at' => $value ? $this->ymdToDate($value) : null];\n            }\n        );\n    }\n}\n<\/pre>\n<\/div>\n
\u691c\u7d22<\/h2>\n
\u30c6\u30fc\u30d6\u30eb\u3092\u691c\u7d22\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u5fc5\u8981\u306a\u3082\u306e\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n
    \n
  1. \u691c\u7d22\u7528\u306e\u30d5\u30a9\u30fc\u30e0 -> index.blade.php\u306b\u3064\u304f\u308b\u3002<\/li>\n
  2. \u691c\u7d22\u30af\u30a8\u30ea\u306e\u9001\u4fe1 -> Javascript\u306efetch\u3067\/oligo\/search\u306b\u9001\u4fe1\u3059\u308b\u3002<\/li>\n
  3. \u30af\u30a8\u30ea\u306e\u53d7\u4fe1 -> web.php\u3067search\u30eb\u30fc\u30c8\u3092\u5b9a\u7fa9\u3002OligoController\u3078\u9001\u308b\u3002<\/li>\n
  4. \u691c\u7d22\u30af\u30a8\u30ea\u306e\u691c\u8a3c -> OligoSearchRequest\u3067\u884c\u3046\u3002<\/li>\n
  5. SQL\u306e\u5b9f\u884c -> OligoService\u306b\u3064\u304f\u308b\u3002<\/li>\n
  6. \u691c\u7d22\u7d50\u679c\u306e\u9001\u4fe1 -> JSON\u3067\u9001\u308b\u3002index.blade.php\u3067\u8868\u306b\u3059\u308b\u3002<\/li>\n<\/ol>\n
    \u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b<\/h3>\n
    \u30d5\u30a9\u30fc\u30e0(input\u30bf\u30b0\u306a\u3069)\u3092 resources\/views\/oligo\/index.blade.php<\/code> \u306b\u3064\u304f\u308b\u3002\n\u30d5\u30a9\u30fc\u30e0\u306e\u8981\u7d20\u306b\u306fx-model\u3092\u8a2d\u5b9a\u3057\u3001Javascript\u3067\u9001\u4fe1\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n
    \n  
    resources\/views\/oligo\/index.blade.php<\/h5>\n
    \n@extends('oligo.module')\n \n@section('feature')\n<x-feature id='oligo-index'>\n  <table\n    class='border-2 border-cyan-600'\n \n    {{-- x-init\u306fAlpine.js\u304c\u51e6\u7406\u3057\u3001items\u3092\u8a2d\u5b9a\u3059\u308b --}}\n    x-init="items = @js($items)"  {{-- @js\u306fBlade\u306e\u30c7\u30a3\u30ec\u30af\u30c6\u30a3\u30d6\u3002$items\u3092JSON\u306b\u3059\u308b\u3002 --}}\n  >\n    <thead>\n      {{-- thead 1\u884c\u76ee \u898b\u51fa\u3057 --}}\n      <tr class='bg-cyan-400 border-cyan-600 border-t-2'>\n        <th><\/th>\n        <th>{{ __('\u540d\u524d') }}<\/th>\n        <th>{{ __('\u914d\u5217') }}<\/th>\n        <th>{{ __('\u4f5c\u6210\u65e5') }}<\/th>\n        <th>{{ __('\u66f4\u65b0\u65e5') }}<\/th>\n        <th>{{ __('\u4f5c\u6210\u8005') }}<\/th>\n        <th><\/th>\n      <\/tr>\n \n      {{-- thead 2\u884c\u76ee \u30d5\u30a9\u30fc\u30e0 --}}\n      {{-- @input\u306fAlpine.js\u306e\u30a4\u30d9\u30f3\u30c8\u30ea\u30b9\u30ca\u30fc\u3002\u5165\u529b\u5024\u304c\u5909\u66f4\u306b\u306a\u3063\u305f\u3068\u304d\u306b\u5b9f\u884c\u3059\u308bJavascript\u3092\u8a2d\u5b9a\u3059\u308b\n        -- .debounce.500\u3092\u5f8c\u306b\u3064\u3051\u308b\u3053\u3068\u3067\u3001500\u30df\u30ea\u79d2\u9045\u5ef6\u3055\u305b\u308b\u3002\n        --}}\n      <tr @input.debounce.500="search()" class="border-cyan-600 border-b-2 align-text-top">\n        <th>\u691c\u7d22<\/th>\n        <td class="name">\n          {{-- x-model\u306fAlpine.js\u304c\u51e6\u7406\u3059\u308b\u3002\u30d5\u30a9\u30fc\u30e0\u306e\u5165\u529b\u5024\u304c\u5909\u66f4\u3055\u308c\u308b\u3068\u5909\u6570\u306e\u5024\u3092\u5909\u3048\u3001\u5909\u6570\u306e\u5024\u304c\u5909\u308f\u308b\u3068\u30d5\u30a9\u30fc\u30e0\u306e\u5024(\u898b\u305f\u76ee)\u304c\u5909\u308f\u308b --}}\n          <input x-model="query.name" placeholder="DROL1">\n          <label>\n              <input type="checkbox" x-model="query.use_regex" value=1 title="\u6b63\u898f\u8868\u73fe">\n              \u6b63\u898f\u8868\u73fe\n          <\/label>\n        <\/td>\n        <td class='sequence'>\n          <input x-model="query.sequence" placeholder="ATCG...">\n        <\/td>\n        <td class='date'>\n          <input x-model="query.created_at" placeholder="260101"\n            title="6\u6841\u306e\u6570\u5b57\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002-\u3067\u7bc4\u56f2\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002"\n          >\n        <\/td>\n        <td class='date'>\n          <input x-model="query.updated_at" placeholder="260201"\n            title="6\u6841\u306e\u6570\u5b57\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002-\u3067\u7bc4\u56f2\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002"\n          >\n        <\/td>\n        <td class='owner'>\n          <input x-model="query.owner">\n        <\/td>\n        <td><\/td>\n      <\/tr>\n \n      {{-- thead 3\u884c\u76ee \u30dc\u30bf\u30f3 --}}\n      <tr>\n        <td colspan="9" class='px-2 py-2'>\n          <button @click="search()">  {{-- @input\u3067\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u308b\u304c\u3001\u30dc\u30bf\u30f3\u3082\u52a0\u3048\u3066\u304a\u304f --}}\n            \u691c\u7d22\n            <x-ajax-state var='query' \/>\n          <\/button>\n \n          {{-- \u30c1\u30a7\u30c3\u30af\u30dc\u30bf\u30f3\u3067\u9078\u629e\u30fb\u975e\u9078\u629e\u3092\u3059\u308b --}}\n          <button @click.prevent="\n            $el.closest('table')\n              .querySelector('tbody')\n              .querySelectorAll('input[type=checkbox]')\n              .forEach(cb => cb.click())\n            "\n          >\n            \u30c1\u30a7\u30c3\u30af\u3092\u53cd\u8ee2\n          <\/button>\n \n          <button @click="query = {}">\u6761\u4ef6\u30af\u30ea\u30a2<\/button>\n        <\/td>\n      <\/tr>\n \n      {{-- thead 4\u884c\u76ee \u691c\u7d22\u7d50\u679c --}}\n      <tr class='border-cyan-600 border-b-2'>\n        <td x-show="items.length == 0" colspan="9">\n          \u6761\u4ef6\u306b\u5408\u3046\u3082\u306e\u306f\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\n        <\/td>\n        <td x-show="items.length > 0" colspan="9">\n          \u691c\u7d22\u7d50\u679c: <span x-text="items.length"><\/span>\u4ef6\n          query:\n          <template x-for="key in Object.keys(query)" :key="key">\n            <template x-if="query[key] !== undefined && query[key] !== ''">\n              <span x-text="key"><\/span>=<span x-text="query[key]"><\/span>\n            <\/template>\n          <\/template>\n        <\/td>\n      <\/tr>\n    <\/thead>\n \n    <tbody>\n      {{-- \u691c\u7d22\u7d50\u679c --}}\n      {{-- Alpine.js (x-for)\u306b\u3088\u3063\u3066\u3001items\u914d\u5217\u306e\u305d\u308c\u305e\u308c\u306e\u8981\u7d20\u3092item\u306b\u53d6\u308a\u51fa\u3057\u3001template\u8981\u7d20\u3092\u5897\u3084\u3059 --}}\n      <template x-for="item in items" :key="item.id">\n        <tr>\n          <td><input x-model="item.checked" type='checkbox'><\/td>\n          <td x-text="item.name" class="name"><\/td>\n          <td x-text="item.sequence" class="sequence"><\/td>\n          <td x-text="item.created_at" class="date"><\/td>\n          <td x-text="item.updated_at" class="date"><\/td>\n          <td x-text="item.owner" class="owner"><\/td>\n          <td x-text="item.id"><\/td>\n        <\/tr>\n      <\/template>\n    <\/tbody>\n  <\/table>\n<\/x-feature>\n@endsection\n<\/pre>\n<\/div>\n
    <\/p>\n
    \n  
    resources\/views\/components\/ajax-state.blade.php<\/h5>\n
    \n@props(['var' => 'item'])\n<template x-if="{{ $var }}.status === 'loading'">\n  <span style="color: gray;">\u23f3<\/span>\n<\/template>\n \n<template x-if="{{ $var }}.status === 'success'">\n  <span style="color: green;">\u2714<\/span>\n<\/template>\n \n<template x-if="{{ $var }}.status === 'error'">\n  <span style="color: red;">\u2716<\/span>\n<\/template>\n<\/pre>\n<\/div>\n
    \u8868\u3084\u30dc\u30bf\u30f3\u306e\u5916\u89b3 (CSS) \u3092\u30e2\u30b8\u30e5\u30fc\u30eb\u5185\u3067\u305d\u308d\u3048\u308b\u305f\u3081\u306b\u3001resources\/css\/oligo.css<\/code> \u3092\u3064\u304f\u308b\u3002\n\u3053\u308c\u306f resources\/css\/app.css<\/code> \u3067@import\u3059\u308b\u3002<\/p>\n
    \n  
    resources\/css\/oligo.css<\/h5>\n
    \n#oligo {\n    table {\n        thead th,thead td {\n            @apply border-x border-cyan-600;\n        }\n \n        td {\n            @apply border-x border-cyan-600 p-1;\n        }\n        td input {\n            &[type=text], &:not([type]) {\n                @apply border border-cyan-600 w-full min-w-0 px-1 h-[24px];\n            }  \n        }\n \n        .name {\n            width: 10em;\n        }\n        .owner {\n            width: 5em;\n        }\n        .date, .created_at, .updated_at {\n            width: 8em;\n        }\n        .note {\n            width: 15em;\n        }\n        .sequence {\n            @apply font-mono text-sm w-[30em] h-[24px];\n        }\n    }\n \n    button {\n        @apply border-cyan-600 bg-cyan-200;\n        &:hover {\n            @apply bg-cyan-600 text-white;\n        }\n    }\n}\n<\/pre>\n<\/div>\napp.css\u306b@import “oligo.css”; \u3092\u52a0\u3048\u308b\u3002\n
    \u30af\u30a8\u30ea\u306e\u9001\u4fe1<\/h3>\n
    \u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u306e\u5024(query)\u3092Ajax\u3067\u9001\u4fe1\u3059\u308b\u30b3\u30fc\u30c9\u3092 #features \u306b\u5b9a\u7fa9\u3059\u308b\u3002<\/p>\n
    \n  
    resources\/views\/oligo\/module.blade.php<\/h5>\n
    \n@extends('layouts.app')\n \n@section('module')\n  <x-module id='oligo'>\n    <!-- \u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30e1\u30cb\u30e5\u30fc -->\n    <nav>\n      <ul class='feature-tabs' role='tablist'>\n        @foreach([\n          'index' => '\u4e00\u89a7',\n          'create' => '\u8ffd\u52a0',\n        ] as $page => $label)\n          <li class='feature-tab'\n            :class="{\n              'bg-white': activeFeature === 'oligo-{{ $page }}',\n              'bg-gray-400 hover:bg-gray-200': activeFeature !== 'oligo-{{ $page }}'\n            }"\n          >\n            <a href='{{ route("web.oligo.{$page}") }}' id='oligo-{{ $page }}-tab' role='tab'\n              @click.prevent="selectTab(event)"\n            >\n              {{ $label }}\n            <\/a>\n          <\/li>\n        @endforeach\n        <li class='feature-tab bg-gray-400' x-text="activeFeature">\n        <\/li>\n      <\/ul>\n    <\/nav>\n    \n    <div class='features'\n      {{-- oligo\u30e2\u30b8\u30e5\u30fc\u30eb\u5168\u4f53\u3067\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3053\u3053\u306bx-data\u3092\u5b9a\u7fa9\u3059\u308b --}}\n      x-data="{\n        items: [], \/\/ \u30c6\u30fc\u30d6\u30eb\u304b\u3089\u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3002\u4eca\u5f8c\u66f4\u65b0\u3084\u524a\u9664\u306e\u6a5f\u80fd\u3067\u3082\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3001\u3053\u3053(#features)\u306b\u5b9a\u7fa9\u3059\u308b\u3002\n        query: {}, \/\/ \u691c\u7d22\u306e\u6761\u4ef6\u3002x-model\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u306e\u5024\u304c\u305d\u306e\u307e\u307eJavascript\u3067\u4f7f\u7528\u3067\u304d\u308b\n \n        \/\/ \u691c\u7d22 fetch\u306f\u975e\u540c\u671f(async)\u306b\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u3001\u305d\u308c\u306b\u305d\u308d\u3048\u308b\n        async search(){\n          const parameter = new URLSearchParams(this.query);  \/\/ \u540c\u3058x-data\u5185\u306a\u306e\u3067 this.query\u3068\u306a\u308b\u3002\u3053\u308c\u3092GET\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc(?key1=value1&key2=value2)\u306b\u5909\u63db\u3059\u308b\n          console.log('parameter:', parameter.toString());  \/\/ \u52d5\u4f5c\u78ba\u8a8d\n          const options = {\n            method: 'GET',\n            headers: {\n              'Accept': 'application\/json',  \/\/ \u8fd4\u308a\u5024\u306e\u8a2d\u5b9a\u3002Laravel\u304c\u5224\u65ad\u3059\u308b\u306e\u306b\u4f7f\u3046\u3002\n              'Content-Type': 'application\/json',\n            },\n          };\n \n          return fetch('{{ route('web.oligo.search') }}?' + parameter.toString(), options)\n            .then(response => response.json())\n            .then(response => {\n              console.log('search done', response);  \/\/ \u52d5\u4f5c\u78ba\u8a8d\n              return this.append(response.data.items);  \/\/ items\u3092\u7f6e\u304d\u63db\u3048\u308bappend\u3092\u547c\u3076\n            })\n            .catch(error => {debug(error)})\n          ;\n        },\n \n        \/\/ \u691c\u7d22\u7d50\u679c\u3092items\u306b\u53cd\u6620\u3055\u305b\u308b\u3002\u4eca\u5f8c\u3001\u65b0\u3057\u3044\u691c\u7d22\u7d50\u679c\u3067\u7f6e\u304d\u63db\u3048\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u8ffd\u52a0\u3059\u308b\u3088\u3046\u306b\u4fee\u6b63\u3057\u3066\u3044\u304f\u306e\u3067\u3001append\u3068\u3057\u3066\u3042\u308b\u3002\n        append(items){\n          this.items = items;\n        }\n      }"\n    >\n      @yield('feature')\n    <\/div>\n  <\/x-module>\n@endsection\n<\/pre>\n<\/div>\n
    \u30af\u30a8\u30ea\u306e\u53d7\u4fe1<\/h3>\n
    <\/p>\n
    routes\/web.php<\/code> \u306bOligoController\u3078\u306e\u30eb\u30fc\u30c8\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n
    \n  
    routes\/web.php<\/h5>\n
    \n<?php\n \nuse Illuminate\\Support\\Facades\\Route;\nuse App\\Http\\Controllers\\OligoController;\n \nRoute::get('\/', function () {\n    return view('index');\n});\n \n\/*\n *\t\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u7d4c\u7531\u3059\u308b\u30eb\u30fc\u30c8\n *\/\nRoute::prefix('\/oligo')->as('web.oligo.')->group(function (){\n    Route::get('\/', [OligoController::class, 'index'])->name('index');\n    Route::get('\/search', [OligoController::class, 'search'])->name('search');\n    Route::get('\/create', [OligoController::class, 'create'])->name('create');\n    Route::post('\/', [OligoController::class, 'store'])->name('store');\n});\n<\/pre>\n<\/div>\n
    OligoSearchRequest\u3092\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n
    \n  
    app\/Http\/Controllers\/OligoController.php<\/h5>\n
    \n<?php\n \nnamespace App\\Http\\Controllers;\n \nuse App\\Http\\Requests\\OligoRequest;\nuse App\\Models\\Oligo;\nuse App\\Http\\Requests\\OligoSearchRequest;  \/\/ \u691c\u7d22\u30d5\u30a9\u30fc\u30e0\nuse App\\Services\\OligoService;  \/\/ \u691c\u7d22\u3092\u62c5\u3046\u30b5\u30fc\u30d3\u30b9\n \nclass OligoController\n{\n    \/* Laravel\u306eDI (Dependency Injection)\u306b\u3088\u3063\u3066OligoService\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u6e21\u3055\u308c\u308b\u3002\n     * private\u3068\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u52d5\u7684\u306b $this->service = $service \u304c\u884c\u308f\u308c\u308b\u3002\n     *\/\n    public function __construct(\n        private OligoService $service\n    ) {\n    }\n \n    public function index(){\n        $items = Oligo::all();\n        return view('oligo.index', compact('items'))\n            ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-index")\n        ;\n    }\n \n    public function create(){\n        return view('oligo.create')\n\t    ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-create")\n        ;\n    }\n \n    public function store(OligoRequest $request){\n        $validated = $request->validated();\n        Oligo::create($validated);\n \n        return redirect()->route('web.oligo.index')->with('status', '\u4fdd\u5b58\u3057\u307e\u3057\u305f');\n    }\n \n    \/\/ \u691c\u7d22\n    public function search(OligoSearchRequest $request)\n    {\n        try{\n            $query = $request->validated();\n            $query['use_regex'] = $query['use_regex'] ?? false;  \/\/ \u305f\u3076\u3093OligoSearchRequest\u306e\u307b\u3046\u306b\u79fb\u52d5\u3057\u305f\u307b\u3046\u304c\u7f8e\u3057\u3044\n            return response()->json([\n                'status' => 'success',\n                'data' => $this->service->search($query),\n            ], 200);\n \n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n}\n<\/pre>\n<\/div>\n
    \u5165\u529b\u5024(Request)\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3<\/h3>\n
    <\/p>\n
    \n  
    app\/Http\/Requests\/OligoSearchRequest.php<\/h5>\n
    \n<?php\n \nnamespace App\\Http\\Requests;\n \nuse Illuminate\\Contracts\\Validation\\ValidationRule;\nuse Illuminate\\Foundation\\Http\\FormRequest;\n \nclass OligoSearchRequest extends FormRequest\n{\n    public function rules(): array\n    {\n        return [\n            'name' => 'nullable|string|max:255',\n            'sequence' => 'nullable|string|max:255',\n            'box' => 'nullable|string|max:255',\n            'owner' => 'nullable|string|max:255',\n            'note' => 'nullable|string|max:255',\n            'updated_at' => 'nullable|regex:\/^[0-9]*-?[0-9]*$\/',\n            'created_at' => 'nullable|regex:\/^[0-9]*-?[0-9]*$\/',\n            'use_regex' => 'nullable|boolean',\n        ];\n    }\n \n    public function messages(): array\n    {\n        return [\n            'name.max' => '\u30b5\u30f3\u30d7\u30eb\u540d\u306f255\u6587\u5b57\u4ee5\u5185\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002',\n            'sequence.max' => '\u5869\u57fa\u914d\u5217\u306f255\u6587\u5b57\u4ee5\u5185\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002',\n            'box.max' => '\u5834\u6240\u306f255\u6587\u5b57\u4ee5\u5185\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002',\n            'owner.max' => '\u6240\u6709\u8005\u306f255\u6587\u5b57\u4ee5\u5185\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002',\n            'note.max' => '\u30e1\u30e2\u306f255\u6587\u5b57\u4ee5\u5185\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002',\n            'updated_at.regex' => '\u65e5\u4ed8\u306e\u66f8\u5f0f\u304c\u7570\u306a\u308a\u307e\u3059\u3002',\n            'created_at.regex' => '\u65e5\u4ed8\u306e\u66f8\u5f0f\u304c\u7570\u306a\u308a\u307e\u3059\u3002',\n        ];\n    }\n \n    protected function prepareForValidation()\n    {\n        $this->merge([\n            'use_regex' => filter_var($this->use_regex, FILTER_VALIDATE_BOOLEAN),\n        ]);\n    }\n}\n<\/pre>\n<\/div>\n
    \u691c\u7d22\u30b5\u30fc\u30d3\u30b9\u3092\u3064\u304f\u308b<\/h3>\n
    \u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306b\u3064\u304f\u308b\u306b\u306f\u30b3\u30fc\u30c9\u304c\u9577\u3059\u304e\u308b\u306e\u3067\u3001\u30b5\u30fc\u30d3\u30b9\u3092\u3064\u304f\u308b\u3002<\/p>\n
    <\/p>\n
    \n  
    app\/Services\/OligoService.php<\/h5>\n
    \n<?php\n \nnamespace App\\Services;\n \nuse App\\Models\\Oligo as Oligo;\nuse App\\Traits\\ParsesSearchQuery;\nuse App\\Traits\\ConvertsYmdDate;\n \nclass OligoService \n{\n    use ConvertsYmdDate;\n    use ParsesSearchQuery;\n \n    public function __construct(\n        protected Oligo $model\n    ) {\n    }\n \n    public function search(array $query){\n        $sql = $this->model->query()\n            ->when(\n                $query['use_regex'], \n                fn($q, $v) => $this->applyRegexCondition($q, 'name', $query['name'] ?? '')\n            )\n            ->when(\n                ! $query['use_regex'], \n                fn($q, $v) => $this->applyTokenCondition($q, 'name', $query['name'] ?? '')\n            );\n \n        foreach(['sequence'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $q->where($field, 'ilike', "%{$v}%")\n            );\n        }\n        foreach(['box', 'owner', 'note'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $q->where($field, 'like', "%{$v}%")\n            );\n        }\n        foreach(['updated_at', 'created_at'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $this->applyDateCondition($q, $field, $v)\n            );\n        }\n        return [\n            'items' => $sql->orderBy('created_at', 'desc')->orderBy('id')->limit(201)->get(),\n            'sql' => $sql->toSql(), \n        ];\n    }\n}\n<\/pre>\n<\/div>\n
    <\/p>\n
    \n  
    app\/Traits\/ParsesSearchQuery.php<\/h5>\n
    \n<?php\n \nnamespace App\\Traits;\n \ntrait ParsesSearchQuery\n{\n    \/**\n     * \u7a7a\u767d\u3067\u5358\u8a9e\u3092\u533a\u5207\u3063\u3066\u3001like\u691c\u7d22\u3092\u3059\u308b\n     *\/\n    public function applyTokenCondition($sql, string $field, string $value)\n    {\n        $pattern = '\/"([^"]*)"|\\'([^\\']*)\\'|([^\\s]+)\/u';\n \n        if (preg_match_all($pattern, $value, $matches, PREG_SET_ORDER)) {\n            foreach ($matches as $m) {\n                $sql->when(\n                    $token = $m[1] ?? null, \n                    fn($q, $v) => $q->where($field, 'like', "%{$token}%")\n                )->when(\n                    $token = $m[2] ?? null, \n                    fn($q, $v) => $q->where($field, 'like', "%{$token}%")\n                )->when(\n                    $token = $m[3] ?? null, \n                    fn($q, $v) => $q->where($field, 'like', "%{$token}%")\n                );\n            }\n        }\n \n        return $sql;\n    }\n \n    public function applyRegexCondition($sql, string $field, string $value)\n    {\n        return $sql->whereRaw("{$field} ~ ?", [$value]);\n    }\n    \n    public function applyDateCondition($sql, string $field, string $value)\n    {\n        if (!$value) return $sql;\n \n        \/\/ \u4f8b: "210101-221231", "210101-", "-221231", "210101"\n        $parts = explode('-', $value);\n \n        \/\/ 210304\n        if (count($parts) === 1) {\n            return $sql->where($field, '=', $this->ymdToDate($parts[0]));\n        }\n \n        [$start, $end] = $parts;\n \n        \/\/ 210304-\n        if ($start !== '') {\n            $sql->where($field, '>=', $this->ymdToDate($start));\n        }\n \n        \/\/  -250607\n        if ($end !== '') {\n            $sql->where($field, '<=', $this->ymdToDate($end));\n        }\n \n        return $sql;\n    }\n \n}\n<\/pre>\n<\/div>\n
    \u30c7\u30fc\u30bf\u767b\u9332<\/h2>\n
    \u30c7\u30fc\u30bf\u767b\u9332\u306e\u30d5\u30a9\u30fc\u30e0\u3082\u66f4\u65b0\u3057\u307e\u3059\u3002\u30bf\u30d6\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\u3092\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u3057\u3066\u3001\u4e00\u5ea6\u306b\u305f\u304f\u3055\u3093\u306e\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\n\u5fc5\u8981\u306a\u3082\u306e\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n
      \n
    1. \u767b\u9332\u7528\u306e\u30d5\u30a9\u30fc\u30e0 -> create.blade.php\u306b\u3064\u304f\u308b\u3002<\/li>\n
    2. \u65b0\u898f\u30c7\u30fc\u30bf\u306e\u9001\u4fe1 -> Javascript\u306efetch\u3067\/oligo\/store\u306b\u9001\u4fe1\u3059\u308b\u3002<\/li>\n
    3. \u30af\u30a8\u30ea\u306e\u53d7\u4fe1 -> OligoController\u3092\u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308c\u308b\u3088\u3046\u306bOligosRequest\u306b\u5909\u66f4\u3002<\/li>\n
    4. \u9001\u4fe1\u30c7\u30fc\u30bf\u306e\u691c\u8a3c -> OligosRequest\u3067\u884c\u3046\u3002<\/li>\n
    5. SQL\u306e\u5b9f\u884c -> OligoService\u306b\u30e1\u30bd\u30c3\u30c9\u8ffd\u52a0\u3002<\/li>\n
    6. \u691c\u7d22\u7d50\u679c\u306e\u9001\u4fe1 -> JSON\u3067\u9001\u308b\u3002\u6210\u529f\u3057\u305f\u30c7\u30fc\u30bf\u3092create\u30d3\u30e5\u30fc\u304b\u3089\u524a\u9664\u3057\u3001items\u306b\u8ffd\u52a0\u3057\u3066index\u30d3\u30e5\u30fc\u3092\u66f4\u65b0\u3059\u308b\u3002<\/li>\n<\/ol>\n
      \u767b\u9332\u7528\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b<\/h3>\n
      \u5165\u529b\u7528\u30d5\u30a9\u30fc\u30e0\u3092 resources\/views\/oligo\/create.blade.php<\/code> \u306b\u3064\u304f\u308b\u3002\n\u30bf\u30d6\u533a\u5207\u308a\u306e\u30c6\u30ad\u30b9\u30c8\u3092textarea\u306b\u5165\u529b\u3057\u3001\u3053\u308c\u3092\u5206\u5272\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u578b\u306e\u30d5\u30a9\u30fc\u30e0\u306b\u57cb\u3081\u308b\u3088\u3046\u306b\u3059\u308b\u3002\n\u30c7\u30fc\u30bf\u306fJavascript\u3067\u9001\u4fe1\u3059\u308b\u3002<\/p>\n
      \n  
      resources\/views\/oligo\/create.blade.php<\/h5>\n
      \n@extends('oligo.module')\n \n@section('feature')\n<x-feature id='oligo-create'\n  x-data="{\n    fields: ['name', 'sequence', 'created_at', 'owner'],  \/\/ \u7a7a\u5224\u5b9a\u3092\u3059\u308b\u9805\u76ee\n    isRowEmpty(row) {\n      return this.fields.every(field => !row[field] || row[field] === '');\n    },\n \n    id: 1,  \/\/ \u3053\u306eid\u306frows\u306e\u4e2d\u3067\u306e\u307f\u6709\u52b9\u3002template x-for\u3067\u30ad\u30fc\u304c\u3042\u3063\u305f\u307b\u3046\u304c\u4fbf\u5229\u306a\u306e\u3067\u3001\u91cd\u8907\u3057\u306a\u3044\u5024\u3092\u3064\u304f\u308b\u3002\n    rows:[],\n    addRow(row) {\n      if (this.rows.length > 50) return; \/\/ \u30d0\u30b0\u306b\u3088\u3063\u3066\u884c\u6570\u304c\u5897\u3048\u3059\u304e\u306a\u3044\u305f\u3081\u306e\u5b89\u5168\u88c5\u7f6e\n      this.rows.push({...row, id: this.id++});\n    },\n    mode: 'paste',\n  }"\n  x-init="\n    addRow({});  \/\/ \u6700\u521d\u306e\u884c\u3092\u8ffd\u52a0\n \n    \/\/ rows\u306e\u4e2d\u8eab\u3092\u76e3\u8996\u3059\u308b\n    $watch('rows', (_rows) => {\n      const hasEmpty = _rows.some(row => isRowEmpty(row));\n \n      \/\/ \u6700\u5f8c\u306e\u884c\u304c\u7a7a\u3067\u306a\u3044\u306a\u3089\u8ffd\u52a0\n      if (! hasEmpty) {\n        addRow({});\n      }\n    }, { deep: true }); \/* \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5185\u90e8\u306e\u5909\u66f4\u3092\u691c\u77e5\u3059\u308b\u305f\u3081\u306b deep: true \u304c\u5fc5\u9808 *\/\n  "\n>\n  <div class="flex gap-2 my-2">\n    \u5165\u529b\u65b9\u6cd5 (\u73fe\u5728\u5024: <span x-text="mode"><\/span>)\n    <input type='radio' name='mode' id='mode-paste' value='paste' checked x-model='mode'><label for='mode-paste'>\u8cbc\u308a\u4ed8\u3051<\/label>\n    <input type='radio' name='mode' id='mode-form'  value='form' x-model='mode'><label for='mode-form'>\u30d5\u30a9\u30fc\u30e0<\/label>\n  <\/div>\n \n  {{-- \u30bf\u30d6\u307e\u305f\u306f\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u30c6\u30ad\u30b9\u30c8\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u5834\u6240 --}}\n  <div x-show="mode == 'paste'"\n    x-data="{\n      raw: '',\n      parse() {\n        if (!this.raw.trim()) return;\n \n        const lines = this.raw.trim().split('\\n').map(l => l.split(\/[\\t,]\/));\n \n        \/\/ \u76f4\u63a5rows\u3092\u7de8\u96c6\u3057\u306a\u3044\u3067\u3001addRow\u3092\u4f7f\u3046\u3088\u3046\u306b\u3057\u305f\u307b\u3046\u304c\u3088\u3044\u304c\u3001\u4eca\u306e\u3068\u3053\u308d\u65b0\u3057\u3044\u5165\u529b\u306e\u305f\u3081\u306e\u7a7a\u884c\u3092\u6700\u5f8c\u306b\u3082\u3063\u3066\u304f\u308b\u65b9\u6cd5\u304c\u308f\u304b\u3089\u306a\u3044(\u8907\u96d1\u306b\u306a\u308b)\u306e\u3067\u3001\u3053\u306e\u3088\u3046\u306b\u3057\u3066\u3044\u308b\u3002\n        rows = lines.map(cols => {\n          const row = {\n            id: this.id++,\n            name: cols[0],\n            sequence: cols[1],\n            created_at: '260816'  \/\/ 6\u6841\u306e\u5f53\u65e5\u306e\u6570\u5b57\u3092\u3064\u304f\u308b\u95a2\u6570\u306b\u7f6e\u304d\u63db\u3048\u308b\n          };\n \n          console.log('row:', row);\n          return row;\n        });\n \n        if(rows.length > 0){\n          mode = 'form';  \/\/ \u30d5\u30a9\u30fc\u30e0\u8868\u793a\u306b\u5207\u308a\u66ff\u3048\u308b\n        }\n      }\n    }"\n    x-init="\n      if(0){ \/\/ \u30c7\u30d0\u30c3\u30b0\u7528\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u305f\u72b6\u614b\u306b\u3059\u308b\n        raw = 'Oligo1\\tACTGG\\nOligo2\\tAGGCCCT';\n        parse();\n      }\n    "\n  >\n    <p>\u540d\u524d\u3068\u914d\u5217\u3092\u3001\u30bf\u30d6\u307e\u305f\u306f\u30ab\u30f3\u30de\u3067\u533a\u5207\u3063\u3066\u3001\u4e00\u884c\u306b\u4e00\u3064\u305a\u3064\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n    <textarea class="border border-cyan-600 w-full min-w-0 my-2 p-1 h-[10rem] font-mono text-sm"\n      placeholder="{{ "name\\tsequence" }}"\n      x-model="raw"\n      @change="parse()"\n    ><\/textarea>\n \n    <button :disabled="!raw.trim()"\n      @click.prevent="parse()"\n    >\n      \u8cbc\u308a\u4ed8\u3051\u305f\u30c7\u30fc\u30bf\u3092\u30d5\u30a9\u30fc\u30e0\u306b\u53cd\u6620\n    <\/button>\n  <\/div>\n \n  {{-- \u30d5\u30a9\u30fc\u30e0 --}}\n  <div x-show="mode == 'form'">\n    <table class='material-list border-cyan-600 border-b-2 border-t-2 w-full my-2' \n      x-show="mode === 'form'"\n    >\n      {{-- thead 1\u884c\u76ee \u898b\u51fa\u3057 --}}\n      <thead>\n        <tr class='bg-cyan-400'>\n          <th>{{ __('\u540d\u524d') }}<\/th>\n          <th>{{ __('\u914d\u5217') }}<\/th>\n          <th>{{ __('\u4f5c\u6210\u65e5') }}<\/th>\n          <th>{{ __('\u4f5c\u6210\u8005') }}<\/th>\n        <\/tr>\n      <\/thead>\n \n      <tbody>\n        <!-- \u5bfe\u8c61\u30b5\u30f3\u30d7\u30eb -->\n        <template x-for="row in rows" :key="row.id">\n          <tr>\n            <td class='name'>\n              <input x-model="row.name" placeholder="\u540d\u524d">\n            <\/td>\n            <td class='sequence'>\n              <input x-model="row.sequence" placeholder="ATCG...">\n            <\/td>\n            <td class='date'>\n              <input x-model="row.created_at" placeholder="260101"\n                title="6\u6841\u306e\u6570\u5b57\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002-\u3067\u7bc4\u56f2\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002"\n              >\n            <\/td>\n            <td class='owner'>\n              <input x-model="row.owner" placeholder="\u4f5c\u6210\u8005">\n            <\/td>\n          <\/tr>\n        <\/template>\n      <\/tbody>\n    <\/table>\n \n    <button :disabled="rows.length <= 1"\n      @click.prevent="\n        fetch('{{ route('web.oligo.store') }}', {\n          method: 'POST',\n          headers: {\n            'Content-Type': 'application\/json',\n            'Accept': 'application\/json',\n            'X-CSRF-TOKEN': '{{ csrf_token() }}'\n          },\n          body: JSON.stringify({\n            oligos: rows.filter(row => ! isRowEmpty(row))\n          })\n        })\n          .then(response => response.json())\n          .then(data => {\n            console.log('data:', data);\n            console.log('data.created:', data.created);\n            rows = [];\n            append(data.created);\n          });\n      "\n    >\n      \u8ffd\u52a0\n    <\/button>\n \n  <\/div>\n<\/x-feature>\n@endsection\n<\/pre>\n<\/div>\n
      \u65b0\u898f\u30c7\u30fc\u30bf\u306e\u53d7\u4fe1\u3068\u767b\u9332<\/h3>\n
      OligoController\u306estore\u30e1\u30bd\u30c3\u30c9\u3067\u3001OligosRequest\u3092\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u3059\u308b\u3002\n\u53d7\u3051\u53d6\u3063\u305f\u30c7\u30fc\u30bf\u306fOligoService\u3067\u30c6\u30fc\u30d6\u30eb\u306b\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
      <\/p>\n
      \n  
      app\/Http\/Requests\/OligosRequest.php<\/h5>\n
      \n<?php\n \nnamespace App\\Http\\Requests;\n \nuse Illuminate\\Contracts\\Validation\\Validator;\nuse Illuminate\\Foundation\\Http\\FormRequest;\nuse Illuminate\\Http\\Exceptions\\HttpResponseException;\n \nclass OligosRequest extends FormRequest\n{\n    public function rules(): array\n    {\n        return [\n            'oligos' => ['required', 'array'],\n            'oligos.*' => ['array'],\n        ];\n    }\n \n    public function messages(): array\n    {\n        return [\n            'oligos.required' => '\u5165\u529b\u5024\u304c\u3042\u308a\u307e\u305b\u3093\u3002',\n            'oligos.array' => '\u9001\u4fe1\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306f\u914d\u5217\u3067\u3042\u308a\u307e\u305b\u3093\u3002',\n        ];\n    }\n \n    public array $validOligos = [];\n    public array $invalidOligos = [];\n \n    protected function passedValidation()\n    {\n        $single = new OligoRequest();\n        $rules = $single->rules();\n        $messages = $single->messages();\n \n        foreach ($this->oligos as $index => $oligo) {\n            \/\/ OligoRequest \u3092\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u5316\u3057\u3066\u3001\u305d\u306e\u30eb\u30fc\u30eb\u3060\u3051\u501f\u7528\n            $validator = \\Validator::make($oligo, $rules, $messages);\n \n            if ($validator->fails()) {\n                $this->invalidOligos[$index] = [\n                    'data' => $oligo,\n                    'errors' => $validator->errors()->toArray(),\n                ];\n            } else {\n                $this->validOligos[] = $validator->validated();\n            }\n        }\n    }\n}\n<\/pre>\n<\/div>\n
      \n  
      app\/Http\/Controllers\/OligoController.php<\/h5>\n
      \n<?php\n \nnamespace App\\Http\\Controllers;\n \nuse App\\Models\\Oligo;\nuse App\\Services\\OligoService;\nuse App\\Http\\Requests\\OligoRequest;\nuse App\\Http\\Requests\\OligoSearchRequest;\nuse App\\Http\\Requests\\OligosRequest; \/\/ \u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\n \nclass OligoController\n{\n    \/* Laravel\u306eDI (Dependency Injection)\u306b\u3088\u3063\u3066OligoService\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u6e21\u3055\u308c\u308b\u3002\n     * private\u3068\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u52d5\u7684\u306b $this->service = $service \u304c\u884c\u308f\u308c\u308b\u3002\n     *\/\n    public function __construct(\n        private OligoService $service\n    ) {\n    }\n \n    public function index(){\n        $items = Oligo::all();\n        return view('oligo.index', compact('items'))\n            ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-index")\n        ;\n    }\n \n    public function create(){\n        return view('oligo.create')\n        ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-create")\n        ;\n    }\n \n    public function store(OligosRequest $request){\n        try{\n            $oligos = $request->validOligos;\n            $data = $this->service->create($oligos);\n \n            return response()->json(array_merge($data, [\n                'status' => 'success', \n                'input' => $oligos,\n            ]), 200);\n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n \n    \/\/ \u691c\u7d22\n    public function search(OligoSearchRequest $request)\n    {\n        try{\n            $query = $request->validated();\n            $query['use_regex'] = $query['use_regex'] ?? false;  \/\/ \u305f\u3076\u3093OligoSearchRequest\u306e\u307b\u3046\u306b\u79fb\u52d5\u3057\u305f\u307b\u3046\u304c\u7f8e\u3057\u3044\n            return response()->json([\n                'status' => 'success',\n                'data' => $this->service->search($query),\n            ], 200);\n \n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n}\n<\/pre>\n<\/div>\n
      \n  
      app\/Services\/OligoService.php<\/h5>\n
      \n<?php\n \nnamespace App\\Services;\n \nuse App\\Models\\Oligo as Oligo;\nuse App\\Traits\\ParsesSearchQuery;\nuse App\\Traits\\ConvertsYmdDate;\n \nclass OligoService \n{\n    use ConvertsYmdDate;\n    use ParsesSearchQuery;\n \n    public function __construct(\n        protected Oligo $model\n    ) {\n    }\n \n    public function search(array $query){\n        $sql = $this->model->query()\n            ->when(\n                $query['use_regex'], \n                fn($q, $v) => $this->applyRegexCondition($q, 'name', $query['name'] ?? '')\n            )\n            ->when(\n                ! $query['use_regex'], \n                fn($q, $v) => $this->applyTokenCondition($q, 'name', $query['name'] ?? '')\n            );\n \n        foreach(['sequence'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $q->where($field, 'ilike', "%{$v}%")\n            );\n        }\n        foreach(['box', 'owner', 'note'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $q->where($field, 'like', "%{$v}%")\n            );\n        }\n        foreach(['updated_at', 'created_at'] as $field){\n            $sql->when(\n                $query[$field] ?? null, \n                fn($q, $v) => $this->applyDateCondition($q, $field, $v)\n            );\n        }\n        return [\n            'items' => $sql->orderBy('created_at', 'desc')->orderBy('id')->limit(201)->get(),\n            'sql' => $sql->toSql(), \n        ];\n    }\n \n    public function create(array $items)\n    {\n        $results = [\n            'created' => [], \n            'succeeded' => [],\n            'failed' => [], \n        ];\n \n        foreach($items as $index => $item){\n            try{\n                $created = $this->model->create($item);\n                $results['created'][] = $created;\n                $results['succeeded'][$index] = $created;\n            }catch(\\Throwable $e){\n                $results['failed'][$index] = array_merge($item, ['error' => $e->getMessage()]);\n            }\n        }\n        return $results;\n    }\n}\n<\/pre>\n<\/div>\n
      \u30c7\u30fc\u30bf\u4fee\u6b63<\/h2>\n
      \u30c7\u30fc\u30bf\u306e\u4fee\u6b63\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\n\u691c\u7d22\u3067\u4fee\u6b63\u3057\u305f\u3044\u3082\u306e\u3092\u63a2\u3057\u3001\u30c1\u30a7\u30c3\u30af\u3092\u3044\u308c\u305f\u3082\u306e\u306b\u3064\u3044\u3066\u3001\u4fee\u6b63\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002\n\u5fc5\u8981\u306a\u3082\u306e\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n
        \n
      1. \u4fee\u6b63\u5bfe\u8c61\u306e\u9078\u629e -> oligo\/module.blade.php\u306ex-data\u306bget checked\u3092\u8ffd\u52a0\u3002<\/li>\n
      2. \u30d5\u30a9\u30fc\u30e0\u3092\u53d6\u5f97\u3059\u308bedit\u3001\u66f4\u65b0\u3059\u308bupdate \u30eb\u30fc\u30c8\u306e\u4f5c\u6210 -> web.php\u3068OligoController<\/li>\n
      3. \u30d5\u30a9\u30fc\u30e0\u306e\u4f5c\u6210 -> oligo\/edit.blade.php<\/li>\n
      4. \u30c7\u30fc\u30bf\u691c\u8a3c\u306f\u65e2\u5b58\u306eOligoRequest\u3001\u30c7\u30fc\u30bf\u66f4\u65b0\u306f \u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3067$model->update<\/li>\n
      5. \u66f4\u65b0\u306b\u5931\u6557\u3057\u305f\u3082\u306e\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3059\u308b\u306e\u306f\u5f8c\u56de\u3057\u3002<\/li>\n<\/ol>\n
        \u4fee\u6b63\u7528\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b<\/h3>\n
        resources\/views\/oligo\/module.blade.php<\/code> \u3092\u4fee\u6b63\u3057\u3066\u3001\u30c1\u30a7\u30c3\u30af\u306e\u5165\u3063\u305f\u3082\u306e\u3060\u3051\u3092\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n
        \n  
        resources\/views\/oligo\/module.blade.php<\/h5>\n
        \n@extends('layouts.app')\n \n@section('module')\n  <x-module id='oligo'>\n    <!-- \u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30e1\u30cb\u30e5\u30fc -->\n    <nav>\n      <ul class='feature-tabs' role='tablist'>\n        @foreach([\n          'index' => '\u4e00\u89a7',\n          'create' => '\u8ffd\u52a0',\n          'edit' => '\u7de8\u96c6',\n        ] as $page => $label)\n          <li class='feature-tab'\n            :class="{\n              'bg-white': activeFeature === 'oligo-{{ $page }}',\n              'bg-gray-400 hover:bg-gray-200': activeFeature !== 'oligo-{{ $page }}'\n            }"\n          >\n            <a href='{{ route("web.oligo.{$page}") }}' id='oligo-{{ $page }}-tab' role='tab'\n              @click.prevent="selectTab(event)"\n            >\n              {{ $label }}\n            <\/a>\n          <\/li>\n        @endforeach\n        <li class='feature-tab bg-gray-400' x-text="activeFeature">\n        <\/li>\n      <\/ul>\n    <\/nav>\n    \n    <div class='features'\n      {{-- oligo\u30e2\u30b8\u30e5\u30fc\u30eb\u5168\u4f53\u3067\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3053\u3053\u306bx-data\u3092\u5b9a\u7fa9\u3059\u308b --}}\n      x-data="{\n        items: [], \/\/ \u30c6\u30fc\u30d6\u30eb\u304b\u3089\u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3002\u4eca\u5f8c\u66f4\u65b0\u3084\u524a\u9664\u306e\u6a5f\u80fd\u3067\u3082\u4f7f\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3001\u3053\u3053(#features)\u306b\u5b9a\u7fa9\u3059\u308b\u3002\n        query: {}, \/\/ \u691c\u7d22\u306e\u6761\u4ef6\u3002x-model\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u5165\u529b\u30d5\u30a9\u30fc\u30e0\u306e\u5024\u304c\u305d\u306e\u307e\u307eJavascript\u3067\u4f7f\u7528\u3067\u304d\u308b\n \n        \/\/ \u691c\u7d22 fetch\u306f\u975e\u540c\u671f(async)\u306b\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u3001\u305d\u308c\u306b\u305d\u308d\u3048\u308b\n        async search(){\n          const parameter = new URLSearchParams(this.query);  \/\/ \u540c\u3058x-data\u5185\u306a\u306e\u3067 this.query\u3068\u306a\u308b\u3002\u3053\u308c\u3092GET\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc(?key1=value1&key2=value2)\u306b\u5909\u63db\u3059\u308b\n          console.log('parameter:', parameter.toString());  \/\/ \u52d5\u4f5c\u78ba\u8a8d\n          const options = {\n            method: 'GET',\n            headers: {\n              'Accept': 'application\/json',  \/\/ \u8fd4\u308a\u5024\u306e\u8a2d\u5b9a\u3002Laravel\u304c\u5224\u65ad\u3059\u308b\u306e\u306b\u4f7f\u3046\u3002\n              'Content-Type': 'application\/json',\n            },\n          };\n \n          return fetch('{{ route('web.oligo.search') }}?' + parameter.toString(), options)\n            .then(response => response.json())\n            .then(response => {\n              console.log('search done', response);  \/\/ \u52d5\u4f5c\u78ba\u8a8d\n              return this.append(response.data.items);  \/\/ items\u3092\u7f6e\u304d\u63db\u3048\u308bappend\u3092\u547c\u3076\n            })\n            .catch(error => {debug(error)})\n          ;\n        },\n \n        \/\/ \u691c\u7d22\u7d50\u679c\u3092items\u306b\u53cd\u6620\u3055\u305b\u308b\u3002\u4eca\u5f8c\u3001\u65b0\u3057\u3044\u691c\u7d22\u7d50\u679c\u3067\u7f6e\u304d\u63db\u3048\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u8ffd\u52a0\u3059\u308b\u3088\u3046\u306b\u4fee\u6b63\u3057\u3066\u3044\u304f\u306e\u3067\u3001append\u3068\u3057\u3066\u3042\u308b\u3002\n        append(items){\n          console.log('append:', items);\n          this.items = items;\n        },\n \n        \/\/ \u30c1\u30a7\u30c3\u30af\u304c\u3044\u308c\u3089\u308c\u305f\u3082\u306e\u3060\u3051\u3092\u53d6\u5f97\u3059\u308b\u3002\n        get checked(){\n          return this.items.filter(item => item.checked);\n        },\n        get hasChecked(){\n          return this.checked.length > 0;\n        }\n      }"\n    >\n      @yield('feature')\n    <\/div>\n  <\/x-module>\n@endsection\n<\/pre>\n<\/div>\n
        resources\/views\/oligo\/edit.blade.php<\/code> \u306b\u4fee\u6b63\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b\u3002<\/p>\n
        \n  
        resources\/views\/oligo\/edit.blade.php<\/h5>\n
        \n@extends('oligo.module')\n \n@section('feature')\n<x-feature id='oligo-edit'>\n \n  <p x-show="!hasChecked" class="pb-10 pl-4">\n    <a\n      href="{{ route('web.oligo.index') }}"\n      id="oligo-edit-abc"\n      @click.prevent="selectTab(event)" \/\/ \u3053\u308c\u304c\u52d5\u4f5c\u3057\u306a\u3044\u3002\u5f8c\u3067\u8003\u3048\u308b\u3002\n    >\n      \u5148\u306b\u7de8\u96c6\u5bfe\u8c61\u306e\u30b5\u30f3\u30d7\u30eb\u306b\u30c1\u30a7\u30c3\u30af\u3092\u3044\u308c\u3066\u304f\u3060\u3055\u3044\u3002\n    <\/a>\n  <\/p>\n \n  <table class='material-list border-cyan-600 border-b-2 border-t-2 w-full my-2'\n    x-show="hasChecked"\n  >\n    <thead>\n        <tr class='bg-cyan-400'>\n          <th><\/th>\n          <th>{{ __('\u540d\u524d') }}<\/th>\n          <th>{{ __('\u914d\u5217') }}<\/th>\n          <th>{{ __('\u4f5c\u6210\u65e5') }}<\/th>\n          <th>{{ __('\u4f5c\u6210\u8005') }}<\/th>\n        <\/tr>\n    <\/thead>\n \n    <tbody>\n      <!-- \u691c\u7d22\u7d50\u679c -->\n      <template x-for="item in checked" :key="item.id">\n        <tr\n          @input.debounce.500="\n            item.status = 'loading';\n            try{\n              fetch(\n                url = `{{ route('web.oligo.index') }}\/${item.id}`,\n                {\n                  method: 'PUT',\n                  headers: {\n                    'Content-Type': 'application\/json',\n                    'Accept': 'application\/json',\n                    'X-CSRF-TOKEN': '{{ csrf_token() }}',\n                  },\n                  body: JSON.stringify(item)\n                }\n              )\n              .then(response => response.json())\n              .then(data => {\n                console.log('data:', data);\n                item.status = data.status;\n              });\n            }catch(e){\n              item.status = 'error';\n            }\n            setTimeout(() => item.status = null, 2000);\n          "\n        >\n          <td class="status-cell min-w-10">\n            <x-ajax-state var='item' \/>\n          <\/td>\n \n          <td class='name'>\n            <input x-model="item.name" placeholder="\u540d\u524d">\n          <\/td>\n          <td class='sequence'>\n            <input x-model="item.sequence" placeholder="ATCG...">\n          <\/td>\n          <td class='date'>\n            <input x-model="item.created_at" placeholder="260101"\n              title="6\u6841\u306e\u6570\u5b57\u3067\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002-\u3067\u7bc4\u56f2\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002"\n            >\n          <\/td>\n          <td class='owner'>\n            <input x-model="item.owner" placeholder="\u4f5c\u6210\u8005">\n          <\/td>\n        <\/tr>\n      <\/template>\n    <\/tbody>\n  <\/table>\n<\/x-feature>\n@endsection\n<\/pre>\n<\/div>\n
        \u65b0\u898f\u30c7\u30fc\u30bf\u306e\u53d7\u4fe1\u3068\u767b\u9332<\/h3>\n
        edit \u3068 update \u306e\u30eb\u30fc\u30c8\u3092\u3064\u304f\u308b\u3002<\/p>\n
        \n  
        routes\/web.php<\/h5>\n
        \n<?php\n \nuse Illuminate\\Support\\Facades\\Route;\nuse App\\Http\\Controllers\\OligoController;\n \nRoute::get('\/', function () {\n    return view('index');\n});\n \n\/*\n *\t\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3092\u7d4c\u7531\u3059\u308b\u30eb\u30fc\u30c8\n *\/\nRoute::prefix('\/oligo')->as('web.oligo.')->group(function (){\n    Route::get('\/', [OligoController::class, 'index'])->name('index');\n    Route::get('\/search', [OligoController::class, 'search'])->name('search');\n    Route::get('\/create', [OligoController::class, 'create'])->name('create');\n    Route::post('\/', [OligoController::class, 'store'])->name('store');\n \n    \/\/ \u7de8\u96c6\u30d5\u30a9\u30fc\u30e0\u3068\u30c7\u30fc\u30bf\u66f4\u65b0\n    Route::get('\/edit', [OligoController::class, 'edit'])->name('edit');\n    Route::put('\/{item}', [OligoController::class, 'update'])->name('update');\n});\n<\/pre>\n<\/div>\n
        \n  
        app\/Http\/Controllers\/OligoController.php<\/h5>\n
        \n<?php\n \nnamespace App\\Http\\Controllers;\n \nuse App\\Models\\Oligo;\nuse App\\Services\\OligoService;\nuse App\\Http\\Requests\\OligoRequest;\nuse App\\Http\\Requests\\OligoSearchRequest;\nuse App\\Http\\Requests\\OligosRequest; \/\/ \u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\n \nclass OligoController\n{\n    \/* Laravel\u306eDI (Dependency Injection)\u306b\u3088\u3063\u3066OligoService\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u6e21\u3055\u308c\u308b\u3002\n     * private\u3068\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u52d5\u7684\u306b $this->service = $service \u304c\u884c\u308f\u308c\u308b\u3002\n     *\/\n    public function __construct(\n        private OligoService $service\n    ) {\n    }\n \n    public function index(){\n        $items = Oligo::all();\n        return view('oligo.index', compact('items'))\n            ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-index")\n        ;\n    }\n \n    public function create(){\n        return view('oligo.create')\n        ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-create")\n        ;\n    }\n \n    public function store(OligosRequest $request){\n        try{\n            $oligos = $request->validOligos;\n            $data = $this->service->create($oligos);\n \n            return response()->json(array_merge($data, [\n                'status' => 'success', \n                'input' => $oligos,\n            ]), 200);\n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n \n    \/\/ \u691c\u7d22\n    public function search(OligoSearchRequest $request)\n    {\n        try{\n            $query = $request->validated();\n            $query['use_regex'] = $query['use_regex'] ?? false;  \/\/ \u305f\u3076\u3093OligoSearchRequest\u306e\u307b\u3046\u306b\u79fb\u52d5\u3057\u305f\u307b\u3046\u304c\u7f8e\u3057\u3044\n            return response()->json([\n                'status' => 'success',\n                'data' => $this->service->search($query),\n            ], 200);\n \n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n \n    public function edit(){\n        return view('oligo.edit')\n        ->fragmentIf(request()->hasHeader('HX-Request'), "feature-oligo-edit")\n        ;\n    }\n \n    public function update(OligoRequest $request, Oligo $item){\n        try{\n            $item->update($request->validated());\n \n            return response()->json([\n                'status' => 'success', \n                'item' => $item,\n            ], 200);\n        }catch(\\Throwable $e){\n            return response()->json(['status' => 'error', 'message' => $e->getMessage()], 400);\n        }\n    }\n}\n<\/pre>\n<\/div>\n\n\n\n\n
        \n  \u524d\u3078<\/a>\n\nPHP\u306e\u5b66\u7fd2 \u76ee\u6b21<\/a>\n\n  \u6b21\u3078<\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"\u524d\u56de\u7d42\u4e86\u6642\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9 Laravel\u3092\u4f7f\u3063\u305f\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 $ git clone https:\/\/kiku3.tsbio.info\/git\/st […]","protected":false},"author":2,"featured_media":0,"parent":2658,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"page-programming.php","meta":{"footnotes":""},"class_list":["post-2961","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/pages\/2961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/comments?post=2961"}],"version-history":[{"count":24,"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/pages\/2961\/revisions"}],"predecessor-version":[{"id":3162,"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/pages\/2961\/revisions\/3162"}],"up":[{"embeddable":true,"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/pages\/2658"}],"wp:attachment":[{"href":"https:\/\/biochemistry.isc.chubu.ac.jp\/labo\/suzuki\/wp-json\/wp\/v2\/media?parent=2961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}