Laravel 6.0 Eloquent - 按日期和状态排序

使用Laravel 6.0的Eloquent ORM，我们可以轻松地对数据库中的数据进行排序，并根据日期和状态进行筛选。这为我们的应用程序提供了强大的功能，使我们能够根据特定的需求来获取和展示数据。

bash
php artisan make:model Task

php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Task extends Model
{
    protected $table = 'tasks';
    protected $fillable = [
        'name', 'deadline', 'status'
    ];
}

php
namespace App\Http\Controllers;
use App\Task;
use Illuminate\Http\Request;
class TaskController extends Controller
{
    public function index()
    {
        $tasks = Task::where('status', '进行中')
                    ->orderBy('deadline', 'desc')
                    ->get();
        return view('tasks.index', compact('tasks'));
    }
}

html
@foreach($tasks as $task)
    
        
{{ $task->name }}
        
截止日期：{{ $task->deadline }}
        
状态：{{ $task->status }}
    
@endforeach

php
namespace App\Http\Controllers;
use App\Task;
use Illuminate\Http\Request;
class TaskController extends Controller
{
    public function index()
    {
        $tasks = Task::where('status', '进行中')
                    ->orderBy('deadline', 'desc')
                    ->get();
        return view('tasks.index', compact('tasks'));
    }
}

html
@foreach($tasks as $task)
    
        
{{ $task->name }}
        
截止日期：{{ $task->deadline }}
        
状态：{{ $task->status }}
    
@endforeach