public function index()
{
$urls = [];
$routes = Route::getRoutes();
foreach ($routes as $route) {
$path = $route->getPath();
$actions = $route->getAction();
$params = $route->parameterNames();
$controller = $actions['controller'];
if (starts_with($path, '_') or str_contains($controller, 'RedirectController') or count($params)) {
continue;
}
$urls[] = url($path);
}
foreach (Campus::all() as $item) {
$urls[] = url($item->url);
}
foreach (Event::all() as $item) {
$urls[] = url($item->url);
}
foreach (Series::withDrafts()->get() as $item) {
$urls[] = url($item->url);
}
foreach (Staff::all() as $item) {
$urls[] = url($item->url);
}
foreach (MissionLocation::all() as $item) {
$urls[] = url($item->url);
}
foreach (Video::withDrafts()->get() as $item) {
$urls[] = url($item->url);
}
return response()->json($urls);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('missionaries')->truncate();
DB::table('missionaries')->insert(['slug' => 'beukemas', 'name' => 'The Beukemas', 'mission_location_id' => MissionLocation::where('slug', '=', 'jamaica')->first()->id, 'url' => 'http://bkbeukema.org', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('missionaries')->insert(['slug' => 'coplands', 'name' => 'The Coplands', 'mission_location_id' => MissionLocation::where('slug', '=', 'italy')->first()->id, 'url' => 'http://nickandshannan.org', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('missionaries')->insert(['slug' => 'chris-ladd', 'name' => 'Chris Ladd', 'mission_location_id' => MissionLocation::where('slug', '=', 'south-africa')->first()->id, 'url' => 'http://chrisleeladd.com', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('missionaries')->insert(['slug' => 'julie-rumph', 'name' => 'Julie Rumph', 'mission_location_id' => MissionLocation::where('slug', '=', 'south-africa')->first()->id, 'url' => 'http://julierumph.org', 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('mission_trips')->truncate();
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'costa-rica')->first()->id, 'cost' => '$1,500', 'seats' => null, 'description' => '<p>Helping with development, growth and training of the FP Costa Rica Campus.</p>', 'contact' => 'Jody Kenyon', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->subDays(60), 'ends_at' => Carbon::now()->subDays(54), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'haiti')->first()->id, 'cost' => '$1,500', 'seats' => null, 'description' => '<p>Through our partnership with The 410 Bridge, team members have an opportunity to journey to a beautiful, rural La Croix, Haiti to serve with community members and churches as they share the hope of Christ and work to transform their community. Teams will work with community leaders to help unify and mobilize the community to implement strategic development and discipleship programs. Learn, worship, serve, and grow as you walk alongside community members and build relationships through home visits, service and evangelism projects, teaching in schools, family ministry and more.</p>', 'contact' => 'Dave and Tonja Breaux', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->addDays(35), 'ends_at' => Carbon::now()->addDays(41), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'mexico')->first()->id, 'cost' => '$1,650', 'seats' => null, 'description' => '<p>The Monterrey Mission trip is a great experience for your first time or families that want to experience missions together. We partner with Back2Back.org ministries to invest our time, labor and heart in children\'s homes and impoverished neighborhoods. We bring care for today and hope for tomorrow.</p>', 'contact' => 'Gina McClain', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->subDays(3), 'ends_at' => Carbon::now()->addDays(3), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'big-creek-ky')->first()->id, 'cost' => '$100', 'seats' => null, 'description' => '<p>Join Faith Promise Church as we partner with Big Creek Missions in Bear Branch, KY. Big Creek Missions is a Christian ministry center in Bear Branch, Kentucky that works to connect churches and volunteer groups from across the country with needs that exist in the Leslie, Clay, and Perry County areas. Possible Projects include: - Assisting local churches with renovation projects - Assisting local low-income residents with construction needs such as roofing, wheelchair ramps, windows, weatherization, and lawn care.</p>', 'contact' => 'Allison Dunford', 'contact_email' => null, 'is_full' => 0, 'starts_at' => Carbon::now()->addDays(52), 'ends_at' => Carbon::now()->addDays(53), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'honduras')->first()->id, 'cost' => null, 'seats' => null, 'description' => '<p>We\'re taking a medical mission team to Honduras on July 11-18. We will need doctors, nurses, therapists, pharmacists, helpers, and those who want to be involved in evangelism.</p>', 'contact' => 'Ron Noe', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->addDays(70), 'ends_at' => Carbon::now()->addDays(76), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'east-asia')->first()->id, 'cost' => '$2,000', 'seats' => null, 'description' => '<p>East Asia is a part of the world where there are few believers and most have never even heard of Jesus. On this trip, you will spend time meeting and getting to know the local people. Through that process you will have the opportunity to share the story of Christ with people who may have never heard the story of what God did for them. You will see God open eyes and hearts as he speaks through you to the people of East Asia.</p>', 'contact' => 'Jamie Davis', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->addDays(70), 'ends_at' => Carbon::now()->addDays(76), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
DB::table('mission_trips')->insert(['mission_location_id' => MissionLocation::where('slug', '=', 'south-africa')->first()->id, 'cost' => '$3,000', 'seats' => null, 'description' => '<p>This team will partner with Faith Promise\'s very own, Chris Ladd and will assist in the work he is doing with the Children\'s Cup (http://www.childrenscup.org/).</p>', 'contact' => 'Zac Stephens', 'contact_email' => '*****@*****.**', 'is_full' => 0, 'starts_at' => Carbon::now()->addDays(10), 'ends_at' => Carbon::now()->addDays(16), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
}
private function importMissionaries()
{
$table = 'missionaries';
Missionary::unguard();
DB::table($table)->truncate();
$missionary = new Missionary(['slug' => 'beukemas', 'name' => 'The Beukemas', 'mission_location_id' => MissionLocation::where('slug', '=', 'jamaica')->first()->id, 'url' => 'http://bkbeukema.org']);
$missionary->save();
$missionary = new Missionary(['slug' => 'coplands', 'name' => 'The Coplands', 'mission_location_id' => MissionLocation::where('slug', '=', 'italy')->first()->id, 'url' => 'http://nickandshannan.org']);
$missionary->save();
$missionary = new Missionary(['slug' => 'chris-ladd', 'name' => 'Chris Ladd', 'mission_location_id' => MissionLocation::where('slug', '=', 'south-africa')->first()->id, 'url' => 'http://chrisleeladd.com']);
$missionary->save();
$missionary = new Missionary(['slug' => 'julie-rumph', 'name' => 'Julie Rumph', 'mission_location_id' => MissionLocation::where('slug', '=', 'south-africa')->first()->id, 'url' => 'http://julierumph.com']);
$missionary->save();
}
public function location($location_slug)
{
$location = MissionLocation::whereSlug($location_slug)->first();
$trips = MissionTrip::where('mission_location_id', '=', $location->id)->get();
return view('missions_location', ['location' => $location, 'trips' => $trips]);
}