public function get()
{
$launchChanges = PrelaunchEvent::where('event', 'Launch Change')->whereHas('mission', function ($q) {
$q->where('status', 'Complete');
})->orderBy('mission_id')->orderBy('prelaunch_event_id')->get();
$countOfCompletedMissions = Mission::where('status', 'Complete')->get();
print_r($launchChanges);
}
/**
* @return mixed
*/
public function resumeCountdown()
{
// Parse launch date
$newLaunchDate = Carbon::parse(Input::get('newLaunchDate'));
// Update Redis
Redis::hset('live:countdown', 'isPaused', false);
Redis::hset('live:countdown', 'to', $newLaunchDate->toDateTimeString());
// Event
event(new LiveCountdownEvent(true, $newLaunchDate));
// If it relates to a mission (and not a miscellaneous webcast)
if (Redis::get('live:isForLaunch')) {
$nextMission = Mission::future()->first();
// Create a Prelaunch event
PrelaunchEvent::create(['mission_id' => $nextMission->mission_id, 'event' => 'Launch Change', 'occurred_at' => Carbon::now(), 'scheduled_launch_exact' => $newLaunchDate]);
// Update mission
$nextMission->launch_paused = false;
$nextMission->launch_date_time = $newLaunchDate;
$nextMission->save();
}
return response()->json(null, 204);
}
private function createPrelaunchEventRelation()
{
$prelaunchEvent = PrelaunchEvent::create(['event' => 'Announcement', 'occurred_at' => Carbon::now(), 'summary' => 'Mission created']);
$prelaunchEvent->mission()->associate($this->mission);
$prelaunchEvent->save();
}
public function run()
{
// F9F1
PrelaunchEvent::create(['mission_id' => 6, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2010, 3, 9), 'summary' => 'Abort at spin start T-0:02', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 6, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2010, 6, 4), 'summary' => 'Out of range engine parameter, sensor error', 'supporting_document' => null]);
//F9F2
PrelaunchEvent::create(['mission_id' => 7, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2010, 12, 3), 'summary' => 'Aborted at T-1.1 seconds due to high engine chamber pressure', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 7, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2010, 12, 4), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 7, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2010, 12, 4), 'summary' => 'Low gas generator pressure in engine 6', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 7, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2010, 12, 8), 'summary' => 'False abort on the Ordnance Interrupter (OI) ground feedback', 'supporting_document' => null]);
//F9F3
PrelaunchEvent::create(['mission_id' => 8, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2012, 5, 19), 'summary' => 'High pressure reading in engine 5 chamber due to a faulty check valve T-0:01', 'supporting_document' => null]);
// F9F4
PrelaunchEvent::create(['mission_id' => 9, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2012, 9, 29), 'summary' => null, 'supporting_document' => null]);
// F9F5
PrelaunchEvent::create(['mission_id' => 10, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2013, 2, 25), 'summary' => null, 'supporting_document' => null]);
// F9F6
PrelaunchEvent::create(['mission_id' => 11, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 9, 11), 'summary' => 'Several issues during tanking', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 11, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 9, 12), 'summary' => 'Countdown abort', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 11, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 9, 12), 'summary' => 'Countdown abort', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 11, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2013, 9, 19), 'summary' => null, 'supporting_document' => null]);
// F9F7
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 20), 'summary' => 'Unspecified issues & weather', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2013, 11, 21), 'summary' => 'Successful, but with excessive venting', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 25), 'summary' => '1st stage LOX vent/pressure relief valve', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 25), 'summary' => 'Ground electrical power supply', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 25), 'summary' => '1st stage LOX vent/pressure relief valve, premature release of ECS duct', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 28), 'summary' => 'Abort at ignition by low ramp up of thrust on Merlin 1D engines, T-0:01', 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 12, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2013, 11, 28), 'summary' => 'Oxygen contamination of ground side TEA-TEB T-1:00', 'supporting_document' => null]);
// F9F8 (Thaicom 6)
PrelaunchEvent::create(['mission_id' => 13, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2013, 12, 29), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 13, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 1, 3), 'summary' => "payload fairing issue", 'supporting_document' => null]);
//F9F9
PrelaunchEvent::create(['mission_id' => 14, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 3, 8), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 14, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 3, 16), 'scheduled_launch_exact' => Carbon::createFromDate(2014, 3, 30), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'summary' => "Delay due to payload contamination", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 14, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 3, 30), 'scheduled_launch_exact' => Carbon::createFromDate(2014, 4, 14), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'summary' => "Delay due to fire damage to range radar", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 14, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 4, 14), 'summary' => "Helium leak on 1st stage", 'supporting_document' => null]);
//F9F10
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 5, 8), 'summary' => "Umbilical connections between the pad and the rocket", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 5, 9), 'summary' => "Helium leak at Composite Overwrap Pressure Vessels (COPV)", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 5, 10), 'summary' => "Delay due to helium leak, range, re-test on the satellites", 'scheduled_launch_exact' => Carbon::createFromDate(2014, 6, 20), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 6, 13), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 6, 20), 'summary' => "Pressure decrease in 2nd stage", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 6, 21), 'summary' => "Weather (no webcast)", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 6, 22), 'scheduled_launch_exact' => Carbon::createFromDate(2014, 7, 14), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'summary' => "1st stage TVC actuator", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 7, 11), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 15, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 7, 14), 'summary' => "Ground Support Equipment (GSE)", 'supporting_document' => null]);
//F9F11
PrelaunchEvent::create(['mission_id' => 16, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 7, 31), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 16, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 8, 5), 'summary' => "Abort, 1st stage hydraulic parameters T-0:45", 'supporting_document' => null]);
//F9F12
PrelaunchEvent::create(['mission_id' => 17, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 8, 22), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 17, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 8, 27), 'scheduled_launch_exact' => Carbon::createFromDate(2014, 9, 6), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'summary' => "Delay due to F9R accident, commonality evaluation", 'supporting_document' => null]);
//F9F13
PrelaunchEvent::create(['mission_id' => 18, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 9, 17), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 18, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 9, 19), 'summary' => "Scrub due to weather", 'supporting_document' => null]);
//F9F14
PrelaunchEvent::create(['mission_id' => 19, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 12, 17), 'summary' => "Early engine shutdown, static fire unsucessful", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 19, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2014, 12, 19), 'scheduled_launch_exact' => Carbon::createFromDate(2015, 1, 5), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'summary' => "Delay due to static fire issue, ISS beta angles and holidays", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 19, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2014, 12, 19), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 19, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2015, 1, 6), 'summary' => "Z axis actuator drift on the 2nd stage thrust vector control system, ?-1:21", 'supporting_document' => null]);
//F9F15 DSCOVR
PrelaunchEvent::create(['mission_id' => 20, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2015, 1, 31), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 20, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2015, 2, 8), 'summary' => "Scrub due to AF radar outage, ?-2:26. Issue with 1st stage video transmitter (not needed for launch). There may have been a non-public vehicle issue that would have scrubbed launch as well", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 20, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2015, 2, 9), 'summary' => "Delay due to weather", 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 20, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2015, 2, 10), 'summary' => "Weather scrub, red upper level winds T-12:41", 'supporting_document' => null]);
// F9F16
PrelaunchEvent::create(['mission_id' => 21, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2015, 2, 25), 'summary' => null, 'supporting_document' => null]);
// F9F17
PrelaunchEvent::create(['mission_id' => 22, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2015, 4, 11), 'summary' => null, 'supporting_document' => null]);
PrelaunchEvent::create(['mission_id' => 22, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2015, 4, 13), 'summary' => "Weather scrub, anvil rule, T-3:07", 'supporting_document' => null]);
//F9F18
PrelaunchEvent::create(['mission_id' => 23, 'event' => 'Launch Static Fire', 'occurred_at' => Carbon::createFromDate(2015, 4, 22), 'summary' => null, 'supporting_document' => null]);
//F9F20
PrelaunchEvent::create(['mission_id' => 25, 'event' => 'Launch Change', 'occurred_at' => Carbon::create(2015, 12, 20, 20, 52, 17), 'scheduled_launch_exact' => Carbon::create(2015, 12, 22, 1, 33, 00), 'scheduled_launch_specificity' => LaunchSpecificity::Precise, 'summary' => "10% better landing probability tomorrow, more time needed to densify LOX", 'supporting_document' => "https://twitter.com/elonmusk/status/678679083782377472"]);
// Jason-3 F9F21
PrelaunchEvent::create(['mission_id' => 27, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2016, 1, 13), 'scheduled_launch_exact' => Carbon::create(2016, 2, 6, 0, 0, 0), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'supporting_document' => "https://www.reddit.com/r/spacex/comments/40ulbn/ses9_f9022_is_now_notionally_scheduled_for_an/"]);
// SES-9 F9F22
PrelaunchEvent::create(['mission_id' => 27, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2016, 1, 13), 'scheduled_launch_exact' => Carbon::create(2016, 2, 6, 0, 0, 0), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'supporting_document' => "https://www.reddit.com/r/spacex/comments/40ulbn/ses9_f9022_is_now_notionally_scheduled_for_an/"]);
// CRS-8 F9F23
PrelaunchEvent::create(['mission_id' => 28, 'event' => 'Launch Change', 'occurred_at' => Carbon::createFromDate(2016, 1, 13), 'scheduled_launch_approximate' => Carbon::createFromDate(2016, 3, 21), 'scheduled_launch_specificity' => LaunchSpecificity::Day, 'supporting_document' => "https://www.reddit.com/r/spacex/comments/40ulbn/ses9_f9022_is_now_notionally_scheduled_for_an/"]);
}
public function launchEvents($slug)
{
$prelaunchEvents = PrelaunchEvent::whereHas('mission', function ($q) use($slug) {
$q->whereSlug($slug);
})->orderBy('occurred_at', 'asc')->get();
return response()->json($prelaunchEvents);
}
