subHours(36); $bikes = Bike::query() ->where('is_link',Bike::LINK_ONLINE) //在线 ->where('is_trouble',Bike::TROUBLE_NO) //无故障 ->where('put_status',Bike::PUT_STATUS_YES) //已投放 ->where('is_riding',Bike::RIDING_NO) //没人骑车 ->where('last_use_bike_end_time','<',$timeOut) ->get(); if(empty($bikes)) return ; // 2.插入工单 foreach ($bikes as $v){ $data = [ 'work_no' => WorkOrder::makeWorkNo(), 'type' => WorkOrder::TYPE_WATCH, 'type_name' => WorkOrder::$typeMaps[WorkOrder::TYPE_WATCH], 'bike_no' => $v->bike_no, 'bike_id' => $v->id, 'source' => WorkOrder::SOURCE_SYSTEM, 'planned' => WorkOrder::PLANNED_STATUS_MEET, 'area_id' => $v->put_area_id, ]; $verify =[ 'bike_id' => $v->id, 'type' => WorkOrder::TYPE_WATCH, 'status' => WorkOrder::STATUS_NO, ]; try{ WorkOrder::firstOrCreate($verify,$data); }catch(\Exception $e){ Log::error($e->getMessage()); } } } }