{"id":1317,"date":"2018-09-28T04:30:20","date_gmt":"2018-09-27T19:30:20","guid":{"rendered":"https:\/\/blog.capilano-fw.com\/?p=1317"},"modified":"2018-10-23T03:36:47","modified_gmt":"2018-10-22T18:36:47","slug":"laravel%e3%81%a7%e4%ba%88%e7%b4%84%e3%81%8c%e5%85%a5%e3%81%a3%e3%81%a6%e3%81%84%e3%82%8b%e3%81%8b%e3%83%81%e3%82%a7%e3%83%83%e3%82%af%e3%81%99%e3%82%8b%e7%8b%ac%e8%87%aa%e3%83%90%e3%83%aa%e3%83%87","status":"publish","type":"post","link":"https:\/\/blog.capilano-fw.com\/?p=1317","title":{"rendered":"Laravel\u3067\u4e88\u7d04\u304c\u5165\u3063\u3066\u3044\u308b\u304b\u30c1\u30a7\u30c3\u30af\u3059\u308b\u72ec\u81ea\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u308b"},"content":{"rendered":"

\u3055\u3066\u3055\u3066\u3001\u5b9f\u306f\u73fe\u5728\u3082Laravel\u6700\u65b0\u7248\u3092\u4f7f\u3063\u305f\u958b\u767a\u3092\u884c\u3063\u3066\u3044\u308b\u6700\u4e2d\u306a\u306e\u3067\u3059\u304c\u3001\u3053\u306e\u958b\u767a\u306e\u4e2d\u3067\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u5b58\u5728\u3057\u306a\u3044\u3061\u3087\u3063\u3068\u8907\u96d1\u306a\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n

\u3057\u304b\u3057\u3001\u305d\u3053\u306f\u3055\u3059\u304cLaravel\u3067\u3059\u3002<\/p>\n

\u305d\u3093\u306a\u30a4\u30ec\u30ae\u30e5\u30e9\u30fc\u306a\u72b6\u6cc1\u306b\u3082\u5bfe\u5fdc\u3067\u304d\u308b\u3088\u3046\u306b\u300c\u72ec\u81ea\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u300d\u3092\u5b9a\u7fa9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u3066\u304f\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u30fb\u30fb\u30fb\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u4eca\u56de\u306f\u3053\u306e\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u300c\u3042\u308b\u90e8\u5c4b\u306e\u3001\u3042\u308b\u6642\u9593\u306b\u4e88\u7d04\u304c\u5165\u3063\u3066\u3044\u308b\u304b\u300d<\/strong>\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n

\u305c\u3072\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n

\"\"<\/p>\n

\u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n

\u4f8b\u3048\u3070\u3001\u3042\u308b\u5c45\u9152\u5c4b\u300c\u3088\u3044\u3069\u308c\uff08\u4eee\u540d\uff09\u300d\u306e\u300c\u685c\u306e\u9593\uff08\u90e8\u5c4b\u756a\u53f7\uff1a1\uff09\u300d\u304c\u6b21\u306e\u6642\u9593\u5e2f\u306b\u7a7a\u3044\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u3002<\/p>\n

2018\u5e7410\u67081\u65e5\u300019\u664200\u5206 \u301c 23\u664200\u5206<\/strong><\/p>\n

\u3067\u306f\u3001\u5c11\u3057\u9577\u3044\u3067\u3059\u304c\u3072\u3068\u3064\u305a\u3064\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\uff01<\/p>\n

\u4e88\u7d04\u30c6\u30fc\u30d6\u30eb\u3092\u3064\u304f\u308b<\/h1>\n

\u307e\u305a\u4e88\u7d04\u3092\u4fdd\u5b58\u3057\u3066\u304a\u304f\u30c6\u30fc\u30d6\u30eb\u304c\u306a\u3044\u3068\u59cb\u307e\u308a\u307e\u305b\u3093\u3002<\/p>\n

\u305d\u3053\u3067reservations<\/code>\u3068\u3044\u3046\u30c6\u30fc\u30d6\u30eb\u3092\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u4f5c\u6210\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n

php artisan make:migration create_reservations_table<\/strong><\/pre>\n
\u3053\u308c\u3067\u3001<\/p>\n
\/database\/migrations\/<\/code>\u30d5\u30a9\u30eb\u30c0\u306b****_**_**_******_create_reservations_table.php<\/code>\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066up()<\/code>\u5185\u306b\u5fc5\u8981\u306a\u30d5\u30a3\u30fc\u30eb\u30c9\u9805\u76ee\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
public function up()\r\n{\r\n    Schema::create('reservations', function (Blueprint $table) {\r\n        $table->increments('id');\r\n        $table->unsignedInteger('room_id')->comment('\u90e8\u5c4b\u756a\u53f7');<\/strong>\r\n        $table->dateTime('start_at')->comment('\u958b\u59cb\u6642\u9593');<\/strong>\r\n        $table->dateTime('end_at')->comment('\u7d42\u4e86\u6642\u9593');<\/strong>\r\n        $table->timestamps();\r\n    });\r\n}<\/pre>\n
\u305d\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
php artisan migrate<\/strong><\/pre>\n
\u30b3\u30de\u30f3\u30c9\u5b9f\u884c\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u304c\u3067\u304d\u307e\u3059\u3002\uff08\u3061\u306a\u307f\u306bcomment()<\/code>\u3092\u4f7f\u3063\u3066\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u8aac\u660e\u3092\u8ffd\u52a0\u3057\u3066\u304a\u304f\u3068\u3001\u4fdd\u5b88\u7ba1\u7406\u304c\u697d\u306b\u306a\u308a\u307e\u3059\u3088\uff01\uff09<\/p>\n
\"\"<\/p>\n
\u9001\u4fe1\u30d5\u30a9\u30fc\u30e0\u3092\u3064\u304f\u308b<\/h1>\n
\u3067\u306f\u3001\u6b21\u306b\u4e88\u7d04\u30c7\u30fc\u30bf\u3092\u9001\u4fe1\u3059\u308b\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u3053\u306e\u30d5\u30a9\u30fc\u30e0\u304b\u3089\u9001\u4fe1\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u3001\u3059\u3067\u306b\u4e88\u7d04\u304c\u3042\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n
\u4eca\u56de\u306f\u30c6\u30b9\u30c8\u306a\u306e\u3067\u3001Ajax\u306f\u4f7f\u308f\u305a\u30ce\u30fc\u30de\u30eb\u306aHTML\u306e\u9001\u4fe1\u30d5\u30a9\u30fc\u30e0\u3067\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
\u307e\u305a\u306f\u4e88\u7d04\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u306e\u4ee5\u4e0b\uff12\u3064\u306eRoute\u3092\/routes\/web.php<\/code>\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
Route::get<\/strong>('reservation', 'ReservationController@create<\/strong>'); \/\/ \u5165\u529b\u30d5\u30a9\u30fc\u30e0\r\nRoute::post<\/strong>('reservation', 'ReservationController@store<\/strong>'); \/\/ \u9001\u4fe1\u5148<\/pre>\n
\u3053\u306e\u307e\u307e\u3067\u306fReservationController<\/code>\u304c\u5b58\u5728\u305b\u305a\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u3082\u4f5c\u6210\u3057\u3001\u5fc5\u8981\u306a\u30e1\u30bd\u30c3\u30c9create<\/code>\u3068store<\/code>\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
php artisan make:controller ReservationController<\/strong><\/pre>\n
class ReservationController<\/strong> extends Controller\r\n{\r\n    public function create() {<\/strong>\r\n\r\n        return view('reservation');<\/strong>\r\n\r\n    }<\/strong>\r\n\r\n    public function store() {<\/strong>\r\n\r\n        \/\/ \u3053\u3053\u3067\u4e88\u7d04\u30c7\u30fc\u30bf\u4fdd\u5b58\r\n\r\n    }<\/strong>\r\n}<\/pre>\n
\u3055\u3089\u306b\u3001\u3053\u306e\u307e\u307e\u3067\u306f\u30d3\u30e5\u30fc\u304c\u5b58\u5728\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u3001\/resources\/views<\/code>\u30d5\u30a9\u30eb\u30c0\u306breservation.blade.php<\/code>\u3092\u4f5c\u6210\u3057\u3066\u3053\u3053\u306b\u9001\u4fe1\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n
\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u306f\u4ee5\u4e0b\u306b\u306a\u308a\u307e\u3059\u3002\uff08\u672c\u6765\u306flayouts\u306a\u3069\u3092\u4f7f\u3046\u3079\u304d\u3067\u3059\u304c\u3001\u4eca\u56de\u306f\u30c6\u30b9\u30c8\u306a\u306e\u3067\u76f4\u306bHTML\u30bf\u30b0\u306a\u3069\u3092\u66f8\u304d\u8fbc\u3093\u3067\u3044\u307e\u3059\uff09<\/p>\n
<html>\r\n<body>\r\n    <form method=\"POST\" action=\"\/reservation\"><\/strong>\r\n        @csrf<\/strong>\r\n        <select name=\"room_id\"><\/strong>\r\n            <option><\/option><\/strong>\r\n            <option selected value=\"1\">\u685c\u306e\u9593<\/option><\/strong>\r\n            <option value=\"2\">\u677e\u306e\u9593<\/option><\/strong>\r\n            <option value=\"3\">\u7af9\u306e\u9593<\/option><\/strong>\r\n            <option value=\"4\">\u6885\u306e\u9593<\/option><\/strong>\r\n        <\/select><\/strong>\r\n        <br><\/strong>\r\n        <br><\/strong>\r\n        <input type=\"date\" name=\"start_date\" value=\"2018-10-01\"><\/strong>\r\n        <input type=\"time\" name=\"start_time\" value=\"19:00\"><\/strong>\r\n        <br><\/strong>\r\n        <input type=\"date\" name=\"end_date\" value=\"2018-10-01\"><\/strong>\r\n        <input type=\"time\" name=\"end_time\" value=\"23:00\"><\/strong>\r\n        <br><\/strong>\r\n        <br><\/strong>\r\n        <button type=\"submit\">\u4e88\u7d04\u3059\u308b<\/button><\/strong>\r\n    <\/form><\/strong>\r\n<\/body>\r\n<\/html><\/pre>\n
\u30da\u30fc\u30b8\u3078\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3053\u3046\u306a\u308a\u307e\u3059\u3002<\/p>\n
\"\"<\/p>\n
\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u6e96\u5099\u3092\u3059\u308b<\/h1>\n
\u3067\u306f\u3001\u5148\u307b\u3069\u306e\u30d5\u30a9\u30fc\u30e0\u304b\u3089\u9001\u4fe1\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3059\u308b\u305f\u3081\u306bReservationRequest<\/code>\u3068\u3044\u3046\u5c02\u7528\u306e\u30d5\u30a9\u30fc\u30e0\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u4f5c\u6210\u3057\u307e\u3057\u3087\u3046\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 ReservationRequest<\/strong><\/pre>\n
\u5b9f\u884c\u3059\u308b\u3068\u3001\/app\/Http\/Requests\/<\/code>\u30d5\u30a1\u30eb\u30c0\u306bReservationRequest.php<\/code>\u3068\u3044\u3046\u30d5\u30a1\u30a4\u30eb\u304c\u3067\u304d\u3066\u3044\u308b\u306e\u3067\u3001ReservationController<\/code>\u306estore<\/code>\u30e1\u30bd\u30c3\u30c9\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
public function store(ReservationRequest $request<\/strong>) {\r\n\r\n    \/\/ \u3053\u3053\u3067\u4e88\u7d04\u30c7\u30fc\u30bf\u4fdd\u5b58\r\n\r\n}<\/pre>\n
\uff08\u3061\u306a\u307f\u306b\u4ee5\u4e0b\u306e\u30cd\u30fc\u30e0\u30b9\u30da\u30fc\u30b9\u3092\u7701\u7565\u3057\u3066\u3044\u308b\u306e\u3067\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff09<\/p>\n
use App\\Http\\Requests\\ReservationRequest;<\/strong><\/pre>\n
\u3067\u306f\u3001\u3053\u308c\u3067\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3046\u6e96\u5099\u304c\u3067\u304d\u307e\u3057\u305f\u3002ReservationRequest.php<\/code>\u3092\u958b\u3044\u3066authorize()<\/code>\u3068all()<\/code>\u3001rules()<\/code>\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
public function authorize()<\/strong>\r\n{\r\n    return true<\/strong>;\r\n}<\/pre>\n
public function all($keys = null)<\/strong>\r\n{\r\n    $results = parent::all($keys);<\/strong>\r\n    $results['start_at'] = $results['start_date'] .' '. $results['start_time'];<\/strong>\r\n    $results['end_at'] = $results['end_date'] .' '. $results['end_time'];<\/strong>\r\n    return $results;<\/strong>\r\n}<\/pre>\n
all()<\/code>\u5185\u3067\u306f\u958b\u59cb\u65e5\u6642\u3092$this->start_at<\/code>\u3001\u7d42\u4e86\u65e5\u6642\u3092$this->end_at<\/code>\u3068\u3057\u3066\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u30aa\u30fc\u30d0\u30fc\u30e9\u30a4\u30c9\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
public function rules()<\/strong>\r\n{\r\n    return [\r\n        'room_id' => 'required', \/\/ \u672c\u6765\u306fexists\u3092\u5165\u308c\u308b\u3079\u304d\u3067\u3059\u304c\u3001\u4eca\u56de\u306f\u5272\u611b\u3057\u307e\u3059\r\n        'start_date' => 'required|date',\r\n        'start_time' => 'required|date_format:H:i',\r\n        'end_date' => 'required|date',\r\n        'end_time' => 'required|date_format:H:i',\r\n        'start_at' => [<\/strong>\r\n            new ReservationRule(<\/strong>\r\n                $this->room_id, \/\/ \u90e8\u5c4b\u756a\u53f7<\/strong>\r\n                $this->start_at, \/\/ \u958b\u59cb\u65e5\u6642<\/strong>\r\n                $this->end_at \/\/ \u7d42\u4e86\u65e5\u6642<\/strong>\r\n            )<\/strong>\r\n        ]<\/strong>\r\n    ];\r\n}<\/pre>\n
\u305d\u3057\u3066\u3001rules()<\/code>\u3067\u306fnew ReservationRule()<\/code>\u3068\u3044\u3046\u90e8\u5206\u304c\u72ec\u81ea\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u306a\u308a\u307e\u3059\u3002\u6b21\u306f\u3053\u306e\u90e8\u5206\u3092\u4f5c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n
\u203b \u3061\u306a\u307f\u306b\u3001\u305d\u306e\u4ed6\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306f\u516853\u7a2e\u985e\uff01Laravel 5.6\u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u5b9f\u4f8b<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u30e2\u30c7\u30eb\u3092\u4f5c\u308b<\/h1>\n
\u3067\u306f\u3001\u72ec\u81ea\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u5185\u90e8\u3067\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u3001\u4e8b\u524d\u306bReservation<\/code>\u30e2\u30c7\u30eb\u3092\u4f5c\u3063\u3066\u300c\u4e88\u7d04\u304c\u5165\u3063\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u300d\u72ec\u81ea\u30b9\u30b3\u30fc\u30d7\uff08where\u30e1\u30bd\u30c3\u30c9\uff09\u3092\u4f5c\u3063\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n
\u30e2\u30c7\u30eb\u306f\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
php artisan make:model Reservation<\/strong><\/pre>\n
\u305d\u3057\u3066\u3001app\/Reservation.php<\/code>\u3092\u958b\u3044\u3066\u4ee5\u4e0b\u306e\u3088\u3046\u306bscopeWhereHasReservation()<\/code>\u3068\u3044\u3046\u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
<?php\r\n\r\nnamespace App;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass Reservation extends Model\r\n{\r\n    protected $guarded = ['id'];\r\n\r\n    \/\/ Scope\r\n    public function scopeWhereHasReservation($query, $start, $end) {<\/strong>\r\n\r\n        $query->where(function($q) use($start, $end) { \/\/ \u89e3\u8aac - 1<\/strong>\r\n\r\n            $q->where('start_at', '>=', $start)<\/strong>\r\n                ->where('start_at', '<', $end);<\/strong>\r\n\r\n        })<\/strong>\r\n        ->orWhere(function($q) use($start, $end) { \/\/ \u89e3\u8aac - 2<\/strong>\r\n\r\n            $q->where('end_at', '>', $start)<\/strong>\r\n                ->where('end_at', '<=', $end);<\/strong>\r\n\r\n        })<\/strong>\r\n        ->orWhere(function($q) use ($start, $end) { \/\/ \u89e3\u8aac - 3<\/strong>\r\n\r\n            $q->where('start_at', '<', $start)<\/strong>\r\n                ->where('end_at', '>', $end);<\/strong>\r\n\r\n        });<\/strong>\r\n\r\n    }<\/strong>\r\n}<\/pre>\n
\u3061\u306a\u307f\u306b\u30b9\u30b3\u30fc\u30d7\u306e\u4e2d\u3067\u306f\u3001\u4ee5\u4e0b\uff13\u30d1\u30bf\u30fc\u30f3\u3092or\u691c\u7d22\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n