Memo

メモ > 技術 > フレームワーク: Laravel6 > シンプルなCRUDの新規作成例（カテゴリ管理を作成）
シンプルなCRUDの新規作成例（カテゴリ管理を作成）

マイグレーションを作成

$ php artisan make:migration create_categories_table


作成されたマイグレーションを以下のように修正

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->engine = 'InnoDB';
            $table->bigIncrements('id');
            $table->string('name')->nullable()->comment('名前');
            $table->integer('sort')->comment('並び順');
            $table->timestamps();
            $table->softDeletes();
        });
        DB::statement('ALTER TABLE categories COMMENT \'カテゴリ\'');
    }

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


マイグレーションを実行

$ php artisan migrate


プログラムを作成

app/Models/Category.php
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Category extends Model
{
    use SoftDeletes;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'sort',
    ];
}


app/Contracts/Repositories/CategoryRepository.php
<?php

namespace App\Contracts\Repositories;

interface CategoryRepository
{
    /**
     * 取得
     *
     * @param  int  $id
     * @return mixed
     */
    public function find($id);

    /**
     * 検索
     *
     * @param  array  $conditions
     * @param  array  $orders
     * @param  int|null  $limit
     * @return mixed
     */
    public function search(array $conditions, array $orders, $limit);

    /**
     * 件数
     *
     * @return int
     */
    public function count();

    /**
     * 保存
     *
     * @param  array  $data
     * @param  int|null  $id
     * @return mixed
     */
    public function save(array $data, $id);

    /**
     * 削除
     *
     * @param  int  $id
     * @return mixed
     */
    public function delete($id);
}


app/Repositories/CategoryRepository.php
<?php

namespace App\Repositories;

use App\Contracts\Repositories\CategoryRepository as CategoryRepositoryContract;
use App\Models\Category;

class CategoryRepository implements CategoryRepositoryContract
{
    /** @var Category */
    protected $category;

    /**
     * コンストラクタ
     *
     * @param Category  $category
     * @return void
     */
    public function __construct(Category $category)
    {
        $this->category = $category;
    }

    /**
     * 取得
     *
     * @param  int  $id
     * @return mixed
     */
    public function find($id)
    {
        return $this->category->find($id);
    }

    /**
     * 検索
     *
     * @param  array  $conditions
     * @param  array  $orders
     * @param  int|null  $limit
     * @return mixed
     */
    public function search(array $conditions = array(), array $orders = array(), $limit = null)
    {
        $query = $this->category->query();
        $query = $this->setConditions($query, $conditions);

        foreach ($orders as $order) {
            $query->orderBy($order[0], $order[1]);
        }

        if ($limit == null) {
            return $query->get();
        } else {
            return $query->paginate($limit);
        }
    }

    /**
     * 件数
     *
     * @param  array  $conditions
     * @return int
     */
    public function count(array $conditions = array())
    {
        $query = $this->category->query();
        $query = $this->setConditions($query, $conditions);

        return $query->count();
    }

    /**
     * 保存
     *
     * @param  array  $data
     * @param  int|null  $id
     * @return Category
     */
    public function save(array $data, $id = null)
    {
        return $this->category->updateOrCreate(['id' => $id], $data);
    }

    /**
     * 削除
     *
     * @param  int  $id
     * @return mixed
     */
    public function delete($id)
    {
        return $this->category->findOrFail($id)->delete();
    }

    /**
     * 検索条件を設定
     *
     * @param  int  $query
     * @param  array  $conditions
     * @return \Illuminate\Database\Query\Builder
     */
    private function setConditions($query, array $conditions = array())
    {
        if (isset($conditions['id'])) {
            $query->where('id', $conditions['id']);
        }
        if (isset($conditions['name'])) {
            $query->where('name', $conditions['name']);
        }
        if (isset($conditions['name_like'])) {
            $query->where('name', 'like', $conditions['name_like']);
        }

        return $query;
    }
}


app/Services/CategoryService.php
<?php

namespace App\Services;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use App\Contracts\Repositories\CategoryRepository;
use App\Http\Requests\StoreCategoryRequest;
use App\Http\Requests\UpdateCategoryRequest;

class CategoryService
{
    /** @var CategoryRepository */
    protected $categoryRepository;

    /**
     * コンストラクタ
     *
     * @param  CategoryRepository  $categoryRepository
     * @return void
     */
    public function __construct(CategoryRepository $categoryRepository)
    {
        $this->categoryRepository = $categoryRepository;
    }

    /**
     * 1件取得
     *
     * @param  int  $id
     * @return mixed
     */
    public function getCategory($id)
    {
        return $this->categoryRepository->find($id);
    }

    /**
     * 検索して取得
     *
     * @param  array  $conditions
     * @param  array  $orders
     * @param  int  $limit
     * @return mixed
     */
    public function getCategories(array $conditions = array(), array $orders = array(), $limit = null)
    {
        return $this->categoryRepository->search($conditions, $orders, $limit);
    }

    /**
     * 件数を取得
     *
     * @param  array  $conditions
     * @return int
     */
    public function countCategories(array $conditions = array())
    {
        return $this->categoryRepository->count($conditions);
    }

    /**
     * 登録
     *
     * @param  StoreCategoryRequest  $request
     * @return \App\Models\Category
     */
    public function storeCategory(StoreCategoryRequest $request)
    {
        $input = $request->only([
            'name',
            'sort',
        ]);

        // 保存
        try {
            return DB::transaction(function () use ($input) {
                $result = $this->categoryRepository->save($input);

                return $result;
            });
        } catch (\Exception $e) {
            Log::error('CategoryService:storeCategory', ['message' => $e->getMessage(), 'input' => $input]);

            return null;
        }
    }

    /**
     * 編集
     *
     * @param  UpdateCategoryRequest  $request
     * @param  int  $id
     * @return \App\Models\Category
     */
    public function updateCategory(UpdateCategoryRequest $request, $id)
    {
        $input = $request->only([
            'name',
            'sort',
        ]);

        // 保存
        try {
            return DB::transaction(function () use ($input, $id) {
                $result = $this->categoryRepository->save($input, $id);

                return $result;
            });
        } catch (\Exception $e) {
            Log::error('CategoryService:updateCategory', ['message' => $e->getMessage(), 'input' => $input, 'id' => $id]);

            return null;
        }
    }

    /**
     * 削除
     *
     * @param  int  $id
     * @return \App\Models\Category
     */
    public function deleteCategory($id)
    {
        try {
            return DB::transaction(function () use ($id) {
                return $this->categoryRepository->delete($id);
            });
        } catch (\Exception $e) {
            Log::error('CategoryService:deleteCategory', ['message' => $e->getMessage(), 'id' => $id]);

            return null;
        }
    }
}


app/Providers/AppServiceProvider.php
        $this->app->bind(
            \App\Contracts\Repositories\CategoryRepository::class,
            \App\Repositories\CategoryRepository::class
        );


app/Http/Requests/StoreCategoryRequest.php
<?php

namespace App\Http\Requests;

use Illuminate\Foundation\Http\FormRequest;

class StoreCategoryRequest extends FormRequest
{
    /**
     * Determine if the user is authorized to make this request.
     *
     * @return bool
     */
    public function authorize()
    {
        return true;
    }

    /**
     * Get the validation rules that apply to the request.
     *
     * @return array
     */
    public function rules()
    {
        return [
            'name' => ['required', 'string', 'max:255'],
            'sort' => ['required', 'integer'],
        ];
    }

    /**
     * バリデーションエラーのカスタム属性の取得
     *
     * @return array
     */
    public function attributes()
    {
        return [
            'name' => '名前',
            'sort' => '並び順',
        ];
    }
}


main/app/Http/Requests/UpdateCategoryRequest.php
<?php

namespace App\Http\Requests;

class UpdateCategoryRequest extends StoreCategoryRequest
{
}


app/Http/Controllers/Admin/CategoryController.php
<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Http\Requests;
use App\Http\Requests\StoreCategoryRequest;
use App\Http\Requests\UpdateCategoryRequest;
use App\Models\Category;
use App\Services\CategoryService;

class CategoryController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @param  CategoryService  $categoryService
     * @return void
     */
    public function __construct(CategoryService $categoryService)
    {
        $this->middleware('auth');

        $this->categoryService = $categoryService;
    }

    /**
     * Display a list of all categories.
     *
     * @param  Request  $request
     * @return Response
     */
    public function index(Request $request)
    {
        return view('admin.category.index', [
            'categories' => $this->categoryService->getCategories([], [['id', 'desc']]),
        ]);
    }

    /**
     * Display a form of new category.
     *
     * @param  Request  $request
     * @return Response
     */
    public function create(Request $request)
    {
        return view('admin.category.form');
    }

    /**
     * Create a new category.
     *
     * @param  Request  $request
     * @return Response
     */
    public function store(StoreCategoryRequest $request)
    {
        if ($this->categoryService->storeCategory($request)) {
            return redirect()->route('admin.category.index')->with('message', 'カテゴリを登録しました。');
        } else {
            return redirect()->route('admin.category.index')->with('error', 'カテゴリを登録できませんでした。');
        }
    }

    /**
     * Display a form of edit category.
     *
     * @param  Request  $request
     * @return Response
     */
    public function edit(Request $request, $id)
    {
        return view('admin.category.form', [
            'category' => $this->categoryService->getCategory($id),
        ]);
    }

    /**
     * Update a category.
     *
     * @param  Request  $request
     * @return Response
     */
    public function update(UpdateCategoryRequest $request, $id)
    {
        if ($this->categoryService->updateCategory($request, $id)) {
            return redirect()->route('admin.category.index')->with('message', 'カテゴリを編集しました。');
        } else {
            return redirect()->route('admin.category.index')->with('error', 'カテゴリを編集できませんでした。');
        }
    }

    /**
     * Destroy the given category.
     *
     * @param  Request  $request
     * @param  string  $id
     * @return Response
     */
    public function destroy(Request $request, $id)
    {
        if ($this->categoryService->deleteCategory($id)) {
            return redirect()->route('admin.category.index')->with('message', 'カテゴリを削除しました。');
        } else {
            return redirect()->route('admin.category.index')->with('error', 'カテゴリを削除できませんでした。');
        }
    }
}


resources/views/admin/home.blade.php
                        <li><a href="{{ route('admin.category.index') }}">カテゴリ管理</a></li>


resources/views/admin/category/index.blade.php
@extends('layouts.app')

@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-8">
            <div class="card">
                <div class="card-header">カテゴリ一覧</div>
                <div class="card-body">
                    @if (session('message'))
                    <div class="box">
                        <div class="alert alert-success">
                            {{ session('message') }}
                        </div>
                    </div>
                    @elseif (session('error'))
                    <div class="box">
                        <div class="alert alert-danger">
                            {{ session('error') }}
                        </div>
                    </div>
                    @endif
                    <p><a href="{{ route('admin.category.create') }}" class="btn btn-primary">カテゴリ登録</a></p>
                    <table class="table table-striped">
                        <thead>
                            <th>名前</th>
                            <th>並び順</th>
                            <th>編集</th>
                            <th>削除</th>
                        </thead>
                        <tbody>
                            @foreach ($categories as $category)
                            <tr>
                                <td class="table-text"><div>{{ $category->name }}</div></td>
                                <td class="table-text"><div>{{ $category->sort }}</div></td>
                                <td class="table-text"><a href="{{ route('admin.category.edit', ['id' => $category->id]) }}" class="btn btn-primary">Edit</a></td>
                                <td>
                                    <form action="{{ route('admin.category.delete', ['id' => $category->id]) }}" method="POST">
                                        {{ csrf_field() }}
                                        {{ method_field('DELETE') }}
                                        <button type="submit" class="btn btn-danger">
                                            Delete
                                        </button>
                                    </form>
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection


resources/views/admin/category/form.blade.php
@extends('layouts.app')

@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-8">
            <div class="card">
                <div class="card-header">カテゴリ @if (!Request::is('*/create')) {{ '編集' }} @else {{ '登録' }} @endif</div>

                <div class="card-body">
                    @if (count($errors) > 0)
                    <div class="alert alert-danger">
                        @foreach ($errors->all() as $error)
                        {{ $error }}<br>
                        @endforeach
                    </div>
                    @endif

                    <form action="{{ Request::is('*/create') ? route('admin.category.create') : route('admin.category.edit', ['id' => $category->id]) }}" method="POST" class="form-horizontal">
                        @if (!Request::is('*/create'))
                            {{ method_field('put') }}
                        @endif
                        {{ csrf_field() }}

                        <div class="form-group">
                            <label for="name" class="col-sm-3 control-label">名前</label>

                            <div class="col-sm-6">
                                <input type="text" name="name" id="name" class="form-control" value="{{ old('name', isset($category) ? $category->name : '') }}">
                            </div>
                        </div>

                        <div class="form-group">
                            <label for="sort" class="col-sm-3 control-label">並び順</label>

                            <div class="col-sm-6">
                                <input type="text" name="sort" id="sort" class="form-control" value="{{ old('sort', isset($category) ? $category->sort : '') }}">
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-sm-offset-3 col-sm-6">
                                <button type="submit" class="btn btn-primary">
                                    <i class="fa fa-btn fa-plus"></i>@if (!Request::is('*/create')) {{ '編集' }} @else {{ '登録' }} @endif
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection


routes/web.php
            // カテゴリ管理
            Route::get('/category', 'CategoryController@index')->name('.category.index');
            Route::get('/category/create', 'CategoryController@create')->name('.category.create');
            Route::post('/category/create', 'CategoryController@store')->name('.category.store');
            Route::get('/category/edit/{id}', 'CategoryController@edit')->name('.category.edit');
            Route::put('/category/edit/{id}', 'CategoryController@update')->name('.category.update');
            Route::delete('/category/delete/{id}', 'CategoryController@destroy')->name('.category.delete');
Memo

Advertisement
