不能将 Illuminate\Database\Query\Builder 类型的对象用作数组

Question

我在这里找不到错误，我该如何解决？$db2 = DB::connection('sqlsrv')->table('Checkinout')    ->join('Z_MemRecord','Checkinout.Userid','=','Z_MemRecord.uid')    ->select(DB::raw("FORMAT(MAX (Checkinout.CheckTime), 'hh:mm tt') AS OffTime, FORMAT (min(Checkinout.CheckTime), 'hh:mm tt') AS Ontime, Checkinout.Userid,Z_MemRecord.Uname,FORMAT (Checkinout.CheckTime, 'MMM dd yyyy') as dates,FORMAT (Checkinout.CheckTime, 'dddd') as hour"))    ->groupBy(DB::raw("Convert(Date, Checkinout.CheckTime),Checkinout.Userid,Z_MemRecord.Uname,FORMAT(Checkinout.CheckTime, 'MMM dd yyyy'),FORMAT (Checkinout.CheckTime, 'dddd')"));$result = DB::connection('mysql')->table('netdoc')->insert(['Logid' => $db2['Checkinout.Userid'] ,'name'=> $db2['Z_MemRecord.Uname'],'dates' =>  $db2['dates'],'day'=>$db2['hour'],'Ontime' => $db2['Ontime'],'Offtime' => $db2['OffTime']]);dd($db2);

Answer 1

该方法groupBy()返回 aQueryBuilder以将其转换为数组调用get()以接收行数组。

->groupBy(...)

->get();

您需要处理返回多行的查询，因此一个快速的解决方案是使用foreach().

foreach ($db2 as $row) {

    $row = (array) $row;

    $result = DB::connection('mysql')

        ->table('netdoc')

        ->insert(['Logid' => $row['Checkinout.Userid'] ,'name'=> $row['Z_MemRecord.Uname'],'dates' =>  $row['dates'],'day'=>$row['hour'],'Ontime' => $row['Ontime'],'Offtime' => $row['OffTime']]);

}