whereNotNull('inner_device_id')->get(['order_id','inner_device_id'])->toArray(); foreach ($all_orders as $value){ //查找订单下是否有未过期的设备 $conut = OrderDevice::where('order_id',$value['order_id'])->where('end_date','>',$today_time)->get()->count(); //如果没有过期时间大于当天的设备就将他完成 if ($conut == 0) { Log::info($value['order_id']."订单已完成"); Order::where('id',$value['order_id'])->update(['status'=>3]); } //设备状态置为闲置 Log::info($value['order_id']."订单".$value['inner_device_id']."设备闲置"); InnerDevice::where('id',$value['inner_device_id'])->update(['status'=>6]); } } }