/**
* 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;
});
}
}
