在Laravel中,你可以使用Eloquent模型和查询构建器来实现按月份和年份分组的优雅解决方法。下面是一些示例代码:
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class YourModel extends Model
{
protected $table = 'your_table_name';
}
use App\Models\YourModel;
use Illuminate\Support\Facades\DB;
public function yourMethod()
{
$data = YourModel::select(DB::raw('YEAR(created_at) as year, MONTH(created_at) as month, COUNT(*) as total'))
->groupBy('year', 'month')
->orderBy('year', 'desc')
->orderBy('month', 'desc')
->get();
return view('your-view', compact('data'));
}
@foreach($data as $item)
{{ $item->year }} 年 {{ $item->month }} 月: {{ $item->total }} 条记录
@endforeach
这样,你就可以按照年份和月份分组查询数据,并在视图中进行展示。