我如何计数，组和显示年龄从我的数据库

Question

我有一个包含100条记录的表组织。在这个表格组织中，我有4列:

• id
<
• 名称/gh>
• date_birth
• date_entry

My Controller here:

public function index(Request $request)
{
$listCollaborateurs = Organigramme::all();
foreach ($listCollaborateurs as $collaborateur) {
$now = Carbon::now();
$date_birth = Carbon::createFromFormat('Y-m-d', $collaborateur->date_birth);
$age = $now->diffInYears($date_birth);
$Number1 = age
->where(age between 1 and 10)
->count();
$Number2 = age
->where(age between 11 and 20)
->count();
return view('home',['Number1' => $Number1, 'Number2' => $Number2]);
}

现在我想计数，分组，并在我的刀片中显示年龄在[1 - 10]，[11 - 20]之间的所有记录

我需要帮助!

Answer 1

你可以这样做:在您的结构图模型类中编写一个返回年龄属性的函数。如:

protected $appends = ['age'];
public function getAgeAttribute(){
$now = Carbon::now();
$date_birth = Carbon::createFromFormat('Y-m-d', $this->date_birth);
return  $now->diffInYears($date_birth);
}

在你的控制器中:

$listCollaborateurs = Organigramme::all();
$number1 =$listCollaborateurs->whereBetween('age',[1,10])->count() ;
$number2 = $listCollaborateurs->whereBetween('age',[11,20])->count();

让我看看它是否有效