/** * Fetch the number of firststage Merlin 1D engines (both normal and fullthrust) flown on operational missions * * @param $substatistic * @return int */ public static function engines($substatistic) { if ($substatistic === 'Flown') { return Cache::remember('stats:engines:flown', 60, function () { return PartFlight::whereIn('firststage_engine', [Engine::Merlin1D, Engine::Merlin1DFullThrust])->whereHas('mission', function ($q) { return $q->whereComplete(); })->count() * 9; }); } if ($substatistic === 'M1D Flight Time') { return Cache::remember('stats:engines:M1DFlightTime', 60, function () { return PartFlight::select(DB::raw('SUM(part_flights_pivot.firststage_meco) AS flight_time'))->whereHas('mission', function ($q) { $q->whereComplete(); })->first()->flight_time; }); } if ($substatistic === 'M1D Success Rate') { return Cache::remember('status:engines:M1DSuccessRate', 60, function () { return PartFlight::select(DB::raw('ROUND(100 - (SUM(part_flights_pivot.firststage_engine_failures) / (COUNT(part_flights_pivot.mission_id) * 9) * 100)) AS success_rate'))->whereHas('mission', function ($query) { $query->whereComplete()->whereSpecificVehicle(['Falcon 9 v1.1', 'Falcon 9 v1.2']); })->first()->success_rate; }); } }