入門Laravelチュートリアル (4) ToDoアプリのタスク一覧表示機能を作る

$ php artisan make:migration create_tasks_table --create=tasks

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateTasksTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('tasks', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('folder_id')->unsigned();
            $table->string('title', 100);
            $table->date('due_date');
            $table->integer('status')->default(1);
            $table->timestamps();

            // 外部キーを設定する
            $table->foreign('folder_id')->references('id')->on('folders');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('tasks');
    }
}

$table->integer('status')->default(1);

// 外部キー制約を設定する
$table->foreign('folder_id')->references('id')->on('folders');

$ php artisan migrate

$ php artisan make:model Task

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Task extends Model
{
    //
}

$ php artisan make:seeder TasksTableSeeder

<?php

use Carbon\Carbon;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class TasksTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        foreach (range(1, 3) as $num) {
            DB::table('tasks')->insert([
                'folder_id' => 1,
                'title' => "サンプルタスク {$num}",
                'status' => $num,
                'due_date' => Carbon::now()->addDay($num),
                'created_at' => Carbon::now(),
                'updated_at' => Carbon::now(),
            ]);
        }
    }
}

$ php artisan db:seed --class=TasksTableSeeder

$ php artisan tinker

Psy Shell v0.9.9 (PHP 7.2.10 — cli) by Justin Hileman
>>>

>>> $folder = \App\Folder::find(1);

=> App\Folder {#2899
     id: 1,
     title: "プライベート",
     created_at: "2018-11-25 13:35:48",
     updated_at: "2018-11-25 13:35:48",
   }

>>> \App\Task::where('folder_id', $folder->id)->get();

=> Illuminate\Database\Eloquent\Collection {#2900
     all: [
       App\Task {#2901
         id: 1,
         folder_id: 1,
         title: "サンプルタスク 1",
         due_date: "2018-11-26",
         status: 1,
         created_at: "2018-11-25 16:04:59",
         updated_at: "2018-11-25 16:04:59",
       },
       App\Task {#2905
         id: 2,
         folder_id: 1,
         title: "サンプルタスク 2",
         due_date: "2018-11-27",
         status: 2,
         created_at: "2018-11-25 16:05:00",
         updated_at: "2018-11-25 16:05:00",
       },
       App\Task {#2906
         id: 3,
         folder_id: 1,
         title: "サンプルタスク 3",
         due_date: "2018-11-28",
         status: 3,
         created_at: "2018-11-25 16:05:00",
         updated_at: "2018-11-25 16:05:00",
       },
     ],
   }

use App\Folder;
use App\Task; // ★ 追加
use Illuminate\Http\Request;

public function index(int $id)
{
    // すべてのフォルダを取得する
    $folders = Folder::all();

    // 選ばれたフォルダを取得する
    $current_folder = Folder::find($id);

    // 選ばれたフォルダに紐づくタスクを取得する
    $tasks = Task::where('folder_id', $current_folder->id)->get();

    return view('tasks/index', [
        'folders' => $folders,
        'current_folder_id' => $current_folder->id,
        'tasks' => $tasks,
    ]);
}

Folder::find(1);

Tasks::where('folder_id', $current_folder->id)->get();

Tasks::where('folder_id', '=', $current_folder->id)->get();

Tasks::where('folder_id', $current_folder->id);

$ php artisan tinker

Psy Shell v0.9.9 (PHP 7.2.10 — cli) by Justin Hileman

>>> \App\Task::where('folder_id', 1)->toSql();
=> "select * from "tasks" where "folder_id" = ?"

<div class="panel panel-default">
  <div class="panel-heading">タスク</div>
  <div class="panel-body">
    <div class="text-right">
      <a href="#" class="btn btn-default btn-block">
        タスクを追加する
      </a>
    </div>
  </div>
  <table class="table">
    <thead>
    <tr>
      <th>タイトル</th>
      <th>状態</th>
      <th>期限</th>
      <th></th>
    </tr>
    </thead>
    <tbody>
      @foreach($tasks as $task)
        <tr>
          <td>{{ $task->title }}</td>
          <td>
            <span class="label">{{ $task->status }}</span>
          </td>
          <td>{{ $task->due_date }}</td>
          <td><a href="#">編集</a></td>
        </tr>
      @endforeach
    </tbody>
  </table>
</div>

class Person extends Model
{
    public function getGenderTextAttribute()
    {
        switch($this->attributes['gender']) {
            case 1:
                return 'male';
            case 2;
                return 'female';
            default:
                return '??';
        }
    }
}

// コントローラーやテンプレートなどで...
$person->gender_text; //=> 'male'

class Task extends Model
{
    /**
     * 状態定義
     */
    const STATUS = [
        1 => [ 'label' => '未着手' ],
        2 => [ 'label' => '着手中' ],
        3 => [ 'label' => '完了' ],
    ];

    /**
     * 状態のラベル
     * @return string
     */
    public function getStatusLabelAttribute()
    {
        // 状態値
        $status = $this->attributes['status'];

        // 定義されていなければ空文字を返す
        if (!isset(self::STATUS[$status])) {
            return '';
        }

        return self::STATUS[$status]['label'];
    }
}

<span class="label">{{ $task->status_label }}</span>

/**
 * 状態定義
 */
const STATUS = [
    1 => [ 'label' => '未着手', 'class' => 'label-danger' ],
    2 => [ 'label' => '着手中', 'class' => 'label-info' ],
    3 => [ 'label' => '完了', 'class' => '' ],
];

/**
 * 状態を表すHTMLクラス
 * @return string
 */
public function getStatusClassAttribute()
{
    // 状態値
    $status = $this->attributes['status'];

    // 定義されていなければ空文字を返す
    if (!isset(self::STATUS[$status])) {
        return '';
    }

    return self::STATUS[$status]['class'];
}

<span class="label {{ $task->status_class }}">{{ $task->status_label }}</span>

// この行を追加
use Carbon\Carbon;

class Task extends Model
{
    /* 中略 */

    /**
     * 整形した期限日
     * @return string
     */
    public function getFormattedDueDateAttribute()
    {
        return Carbon::createFromFormat('Y-m-d', $this->attributes['due_date'])
            ->format('Y/m/d');
    }
}

<td>{{ $task->formatted_due_date }}</td>

$tasks = Tasks::where('folder_id', $current_folder->id)->get();

$tasks = $current_folder->tasks()->get();

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Folder extends Model
{
    public function tasks()
    {
        return $this->hasMany('App\Task');
    }
}

$this->hasMany('App\Task', 'folder_id', 'id');

>>> $folder = \App\Folder::find(1);
>>> $folder->tasks()->toSql();
=> "select * from "tasks" where "tasks"."folder_id" = ? and "tasks"."folder_id" is not null"

public function index(int $id)
{
    // すべてのフォルダを取得する
    $folders = Folder::all();

    // 選ばれたフォルダを取得する
    $current_folder = Folder::find($id);

    // 選ばれたフォルダに紐づくタスクを取得する
    $tasks = $current_folder->tasks()->get(); // ★

    return view('tasks/index', [
        'folders' => $folders,
        'current_folder_id' => $current_folder->id,
        'tasks' => $tasks,
    ]);
}