ultimo_update_entre_5_tabelas_com_uma_consulta

gistfile1.txt

function daysSinceLastUpdate()
{
    $lastUpdate = null;

    $carB = \Mixdinternet\Cars\Car::select(DB::raw('MAX(updated_at) AS updated_at'))->where('advertiser_id', auth()->user()->advertiser_id);
    $vanB = \Mixdinternet\Vans\Van::select(DB::raw('MAX(updated_at) AS updated_at'))->where('advertiser_id', auth()->user()->advertiser_id);
    $truckB = \Mixdinternet\Trucks\Truck::select(DB::raw('MAX(updated_at) AS updated_at'))->where('advertiser_id', auth()->user()->advertiser_id);
    $trailerB = \Mixdinternet\Trailers\Trailer::select(DB::raw('MAX(updated_at) AS updated_at'))->where('advertiser_id', auth()->user()->advertiser_id);
    $sailingB = \Mixdinternet\Sailings\Sailing::select(DB::raw('MAX(updated_at) AS updated_at'))->where('advertiser_id', auth()->user()->advertiser_id);

    $motorcycleB = \Mixdinternet\Motorcycles\Motorcycle::select(DB::raw('MAX(updated_at) AS updated_at'))
        ->where('advertiser_id', auth()->user()->advertiser_id)
        ->union($carB)
        ->union($vanB)
        ->union($truckB)
        ->union($trailerB)
        ->union($sailingB)
        ->get();

    dd($motorcycleB->max('updated_at')->toDateTimeString());
    return \Carbon::now()->diffInDays($lastUpdate)->first()->updated_at;
}