Study Note

Lavarel 快速學習自我挑戰 Day16

Symbols count in article: 1.3k Reading time: 7 mins.

Application Post Part II

對貼文分類新增 model 和 migration

  1. 新增 model php artisan make:model Category -m
  2. 在 category 的 model 處理 mass assignment
    protected $fillable = ['name'];
  3. 在 create_categories_table 新增欄位 $table->string('name');
  4. 將欄位寫入資料庫 php artisan migrate

與貼文分類顯示或創建貼文

  1. 修改 posts 的 index view
    <td>{{" {{$post->category ? $post->category->name : 'Uncategorized'" }}}}</td>
  2. 修改 AdminPostsController 的 create function
1
2
$categories = Category::lists('name','id')->all();
return view('admin.posts.create', compact('categories'));
  1. 修改 Post create view
1
2
3
4
<div class="form-group">
    {!! Form::label('category_id', 'Category:') !!}
    {!! Form::select('category_id', [''=>'Choose Categories'] + $categories, null, ['class'=>'form-control']) !!}
</div>

編輯貼文

  1. 修改 AdminPostsController 的 edit function
1
2
3
$post = Post::findOrFail($id);
$categories = Category::lists('name', 'id')->all();
return view('admin.posts.edit', compact('post', 'categories'));
  1. 複製 create view 到 edit view 並修改 form
    {!! Form::model($post, ['method'=>'PATCH', 'action'=>['AdminPostsController@update', $post->id], 'files'=>true]) !!}
  2. 在 posts index view 的名字新增超連結
    <td><a href="{{" {{route('admin.posts.edit', $post->id)" }}}}">{{" {{$post->user->name" }}}}</a></td>
  3. 修改 post edit view 的 category
    {!! Form::select('category_id', $categories, null, ['class'=>'form-control']) !!}
  4. 修改 AdminPostsController 的 update function
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$input = $request->all();

if($file = $request->file('photo_id')){

    $name = time() . $file->getClientOriginalName();

    $file->move('images', $name);

    $photo = Photo::create(['file'=>$name]);

    $input['photo_id'] = $photo->id;

}

Auth::user()->posts()->whereId($id)->first()->update($input);

return redirect('/admin/posts');
  1. 在 post index view 縮短字的長度 {{" {{str_limit($post->body, 30)" }}}}

刪除貼文

  1. 在 post edit view 新增 delete button
1
2
3
4
5
6
7
8
9
{!! Form::open(['method'=>'DELETE', 'action'=>['AdminPostsController@destroy', $post->id]]) !!}

    {{csrf_field()}}

    <div class="form-group">
        {!! Form::submit('Delete Post', ['class'=>'btn btn-danger col-sm-6']) !!}
    </div>

{!! Form::close() !!}
  1. 修改 AdminPostsController 的 destroy function
1
2
3
4
5
6
7
$post = Post::findOrfail($id);

unlink(public_path() . $post->photo->file);

$post->delete();

return redirect('/admin/posts');

刪除使用者時也刪除貼文

  1. 修改 create_posts_table
    $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
  2. 更新資料庫 php artisan migrate:refresh

在編輯貼文時顯示圖片

  1. 修改 post edit view
1
2
3
4
5
<div class="col-sm-3">

    <img src="{{$post->photo->file}}" alt="" class="img-responsive">

</div>

設定分類

  1. 新增 Controller
    php artisan make:controller --resource AdminCategoriesController
  2. 新增 routes
    Route::resource('admin/categories', 'AdminCategoriesController');
  3. 新增 categories index view
1
2
3
4
5
6
7
@extends('layouts.admin');

@section('content')

    <h1>Categories</h1>

@stop
  1. 修改 layout.admin 的 routes
1
2
3
4
5
6
7
<li>
    <a href="{{route('admin.categories.index')}}">All Categories</a>
</li>

<li>
    <a href="{{route('admin.categories.create')}}">Create Category</a>
</li>

創建分類

  1. 修改 AdminCategoriesController 的 index
1
2
3
$categories = Category::all();

return view('admin.categories.index', compact('categories'));
  1. 修改 categories index view
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
@extends('layouts.admin');

@section('content')

    <h1>Categories</h1>

    <div class="col-sm-6">

        {!! Form::open(['method'=>'POST', 'action'=>'AdminCategoriesController@store']) !!}

            <div class="form-group">
                {!! Form::label('name', 'Name:') !!}
                {!! Form::text('name', null, ['class'=>'form-control']) !!}
            </div>

            {{csrf_field()}}

            <div class="form-group">
                {!! Form::submit('Create Category', ['class'=>'btn btn-primary']) !!}
            </div>

        {!! Form::close() !!}

    </div>

    <div class="col-sm-6">

        @if($categories)

        <table class="table">
            <thead>
            <tr>
                <th>id</th>
                <th>Name</th>
                <th>Created date</th>
            </tr>
            </thead>
            <tbody>

            @foreach($categories as $category)
            <tr>
                <td>{{$category->id}}</td>
                <td>{{$category->name}}</td>
                <td>{{$category->created_at ? $category->created_at->diffForHumans() : 'No date'}}</td>
            </tr>
            @endforeach
        </table>

        @endif

    </div>

@stop
  1. 在 AdminCategoriesController store function
1
2
Category::create($request->all());
return redirect('admin/categories');

更新和刪除分類

  1. 修改 category edit view
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
@extends('layouts.admin');

@section('content')

    <h1>Categories</h1>

    <div class="col-sm-6">

        {!! Form::model($category, ['method'=>'PATCH', 'action'=>['AdminCategoriesController@update', $category->id]]) !!}

        <div class="form-group">
            {!! Form::label('name', 'Name:') !!}
            {!! Form::text('name', null, ['class'=>'form-control']) !!}
        </div>

        {{csrf_field()}}

        <div class="form-group">
            {!! Form::submit('Update Category', ['class'=>'btn btn-primary']) !!}
        </div>
        {!! Form::close() !!}

    </div>

    <div class="col-sm-6">

    </div>

@stop
  1. 修改 AdminCategoriesController 的 edit function
1
2
$category = Category::findOrFail($id);
return view('admin.categories', compact('category'));
  1. 在 category edit view 新增 delete button
1
2
3
4
5
6
7
8
9
{!! Form::open(['method'=>'DELETE', 'action'=>['AdminCategoriesController@destroy', $category->id]]) !!}

{{csrf_field()}}

<div class="form-group">
    {!! Form::submit('Delete Category', ['class'=>'btn btn-danger col-sm-6']) !!}
</div>

{!! Form::close() !!}
  1. 修改 AdminCategoriesController 的 destroy function
1
2
Category::findOrFail($id)->delete();
return redirect('/admin/categories');
  1. 修改 AdminCategoriesController 的 update function
1
2
3
$category = Category::findOrFail($id);
$category->update($request->all());
return redirect('/admin/categories');
Share