来自集合的Laravel最小最大GroupBy

Question

我有一个查询，然后使用foreach循环。

我通过消除空值进行筛选，然后将其推入集合

然后将二维阵列与一维阵列进行平面化转换。

所以，我有收集格式的数据。

我的问题是如何从收集中获得最小最大值？

例如我的数据：

Illuminate\Support\Collection {#193
  #items: array:8 [
    0 => {#388
      +"id": 498
      +"id_user": "20021635"
      +"name": "Jeany"
      +"department": "IAD"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:12:15"
    }
    1 => {#379
      +"id": 498
      +"id_user": "20021635"
      +"name": "Jeany"
      +"department": "IAD"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:25:16"
    }
    2 => {#394
      +"id": 498
      +"id_user": "20021635"
      +"name": "Jeany"
      +"department": "IAD"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:29:16"
    }
    3 => {#395
      +"id": 498
      +"id_user": "20021635"
      +"name": "Jeany"
      +"department": "IAD"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:05:15"
    }
    4 => {#389
      +"id": 470
      +"id_user": "10025488"
      +"name": "Michael Angelo"
      +"department": "HR"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:07:15"
    }
    5 => {#397
      +"id": 470
      +"id_user": "10025488"
      +"name": "Michael Angelo"
      +"department": "HR"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:09:15"
    }
    6 => {#401
      +"id": 470
      +"id_user": "10025488"
      +"name": "Michael Angelo"
      +"department": "HR"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:12:15"
    }
    7 => {#402
      +"id": 470
      +"id_user": "10025488"
      +"name": "Michael Angelo"
      +"department": "Rose Tower"
      +"location": "Rose Tower – 1st Floor"
      +"updated_at": "2021-03-18 10:14:15"
    }
  ]
}

预期产出：

 +"id": 498
      +"id_user": "20021635"
      +"name": "Jeany"
      +"department": "IAD"
      +"location": "Rose Tower – 1st Floor"
      +"time_in": "2021-03-18 10:05:15"
      +"time_out": "2021-03-18 10:29:16"
+"id": 470
      +"id_user": "10025488"
      +"name": "Michael Angelo"
      +"department": "HR"
      +"location": "Rose Tower – 1st Floor"
      +"time_in": "2021-03-18 10:07:15"
      +"time_out": "2021-03-18 10:14:15"

代码：

$person = collect([]);
    foreach ($machine_list as $key => $value){
        $contactBy = DB::tamachine('attendance')
        ->select(DB::raw('user.id as id,
                          user.idemployee as id_user,
                          user.name as name,
                          user.id_dept as department,
                          machine.loc_name as location,
                          attendance.updated_at'))
        
        ->Join('user','attendance.id_user','=','user.id')
        ->Join('machine','attendance.id_machine','=','machine.id_machine')
        ->where(function ($query) use ($value){
            $query->where('attendance.id_machine', $value->id_machine)
                  ->orWhere('attendance.id_machine2', $value->id_machine2)
                  ->orWhere('attendance.id_machine3', $value->id_machine3);
        })
        ->where('attendance.id_user','<>',$id_user)
        ->whereBetween('attendance.updated_at', [Carbon::parse($minmax_person[0]->timestart,'GMT'), Carbon::parse($minmax_person[0]->timeend,'GMT')])
        // ->groupBy('user.id','user.idemployee','user.name','user.id_dept','machine.loc_name')
        ->get();
    
        if(!$contactBy->isEmpty()){
            $person->push($contactBy);
        }
    }
$person->flatten();

如有任何帮助，我将不胜感激

Answer 1

幼虫采集方法

创建一个空集合对象，然后对已有的集合对象使用min和max方法，并使用push方法将其值推送到空集合对象中

最大值

最小

推