/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
// ------------------------------------------------------------------------------------------------------------
// GET HEADLINE
// ------------------------------------------------------------------------------------------------------------
$headlines = \App\Headline::with('travel_agent')->activeOn(\Carbon\Carbon::now())->orderBy('priority')->get();
$headlines = $headlines->sortByDesc(function ($data) {
return $data->travel_agent->active_packages[0]->priority;
});
// ------------------------------------------------------------------------------------------------------------
// GET HOMEGRID
// ------------------------------------------------------------------------------------------------------------
$homegrids = \App\HomegridSetting::orderby('name')->get();
// get upcoming package schedules
$homegrid_destination_ids = new Collection();
foreach ($homegrids as $k => $v) {
if (str_is('destination', $v->type)) {
$homegrid_destination_ids->push($v->destination);
}
}
if ($homegrid_destination_ids->count()) {
$homegrid_destinations = \App\Destination::with('tours', 'tours.schedules')->whereIn('id', $homegrid_destination_ids)->get();
foreach ($homegrids as $k => $v) {
$homegrids[$k]->destination_detail = $homegrid_destinations->find($v->destination);
}
}
// ------------------------------------------------------------------------------------------------------------
// QUERY PAKET PROMO TERBARU
// ------------------------------------------------------------------------------------------------------------
$tours = \App\Tour::with('destinations', 'schedules', 'destinations.images', 'places', 'places.images', 'travel_agent', 'travel_agent.images', 'images')->has('schedules')->select('tours.*')->join('travel_agencies', 'travel_agencies.id', '=', 'travel_agent_id')->published()->latest('tours.created_at')->limit(8)->groupBy('travel_agent_id')->get();
// ------------------------------------------------------------------------------------------------------------
// GET BLOG TERBARU
// ------------------------------------------------------------------------------------------------------------
$articles = Article::with('images')->published()->latest('published_at')->take(6)->get();
// ------------------------------------------------------------------------------------------------------------
// GET USER
// ------------------------------------------------------------------------------------------------------------
$total_subscriber = \App\Subscriber::active()->count();
$this->info(' ---------------------------------------------------------------------------------------------- ');
$this->info(' BLAST NEWSLETTER ');
$this->info(' ---------------------------------------------------------------------------------------------- ');
$this->info(' * Sending Newsletter to ' . $total_subscriber . ' subscribers');
\App\Subscriber::with('user')->active()->orderby('id')->chunk(100, function ($subscribers) {
foreach ($subscribers as $subscriber) {
Mail::queue('web.v4.emails.newsletters.weekly', ['headlines' => $headlines, 'homegrids' => $homegrids, 'tours' => $tours, 'articles' => $articles, 'subscriber' => $subscriber], function ($m) use($subscriber) {
$m->to($subscriber->email, $subscriber->user ? $subscriber->user->name : $subscriber->email)->subject('CAPCUS.id - Newsletter Edisi ' . \Carbon\Carbon::now()->year . '.' . \Carbon\Carbon::now()->format('W'));
});
$this->info(' * Newsletter sent to ' . $subscriber->email . ' *');
}
});
$this->info(' ---------------------------------------------------------------------------------------------- ');
$this->info(' BLAST NEWSLETTER COMPLETED');
$this->info(' ---------------------------------------------------------------------------------------------- ');
}
/**
* Get featured tours with banners and not expired
*
* @param int $limit
* @return Tour collection
*/
public function getFeaturedTours($limit = 25)
{
return Tour::with('photos')->whereFeatured(true)->where('banner', '<>', '')->where('end_date', '>', $this->currentDate)->orderBy('updated_at', 'desc')->limit($limit)->get();
}
public function index()
{
// ------------------------------------------------------------------------------------------------------------
// QUERY HEADLINE
// ------------------------------------------------------------------------------------------------------------
$headlines = Cache::remember('current_headline', 60, function () {
return \App\Headline::activeOn(\Carbon\Carbon::now())->orderBy('priority')->get();
});
$headlines = $headlines->sortBy(function ($headline) {
return rand(0, 1000);
});
// ------------------------------------------------------------------------------------------------------------
// QUERY HOME GRID
// ------------------------------------------------------------------------------------------------------------
$homegrids = Cache::remember('current_homegrids', 60, function () {
$homegrids = \App\HomegridSetting::orderBy('name')->get();
// get upcoming package schedules
$homegrid_destination_ids = new Collection();
foreach ($homegrids as $k => $v) {
if (str_is('destination', $v->type)) {
$homegrid_destination_ids->push($v->destination);
}
}
//
if ($homegrid_destination_ids->count()) {
$homegrid_destinations = \App\Destination::with('tours', 'tours.schedules')->whereIn('id', $homegrid_destination_ids)->get();
foreach ($homegrids as $k => $v) {
$homegrids[$k]->destination_detail = $homegrid_destinations->find($v->destination);
if (str_is('destination', $v->type)) {
$homegrids[$k]->destination_detail->total_upcoming_schedules;
}
}
}
return $homegrids;
});
// ------------------------------------------------------------------------------------------------------------
// QUERY PAKET PROMO
// ------------------------------------------------------------------------------------------------------------
// $promo_tours = Cache::remember('8_upcoming_promo_tours', 30, function(){
// return \App\TourSchedule::with('tour', 'tour.places', 'tour.places.images' ,'tour.destinations', 'tour.destinations.images', 'tour.travel_agent', 'tour.travel_agent.images', 'tour.schedules', 'tour.images')
// ->published()
// ->promo()
// ->scheduledBetween(\Carbon\Carbon::now(), \Carbon\Carbon::now()->addYears(5))
// ->orderby('departure')
// ->limit(8)
// ->select('tour_schedules.*')
// ->join('tours', 'tours.id', '=', 'tour_schedules.tour_id')
// ->join('travel_agencies', 'travel_agencies.id', '=', 'tours.travel_agent_id')
// ->groupBy('tours.travel_agent_id')
// ->get();
// });
// ------------------------------------------------------------------------------------------------------------
// QUERY PAKET TOUR TERBARU
// ------------------------------------------------------------------------------------------------------------
$latest_tours = Cache::remember('8_latest_tours_by_different_travel_agent', 30, function () {
$all_latest_tours = \App\Tour::with('destinations', 'schedules', 'destinations.images', 'places', 'places.images', 'travel_agent', 'travel_agent.images', 'images')->has('schedules')->select('tours.*')->join('travel_agencies', 'travel_agencies.id', '=', 'travel_agent_id')->published()->latest('tours.created_at')->limit(30)->get();
$latest_tours = [];
foreach ($all_latest_tours as $x) {
if (!$latest_tours[$x->travel_agent_id] && count($latest_tours) <= 8) {
$latest_tours[$x->travel_agent_id] = $x;
}
}
$converted_to_collection = new Collection();
foreach ($latest_tours as $x) {
$converted_to_collection->push($x);
}
return $converted_to_collection;
});
// ------------------------------------------------------------------------------------------------------------
// TOP DESTINATION
// ------------------------------------------------------------------------------------------------------------
$top_destinations = Cache::remember('8_top_destination_in_6_months', 30, function () {
$destinations = \App\Destination::with('images')->TopDestination(\Carbon\Carbon::now(), \Carbon\Carbon::now()->addMonth(6))->limit(8)->get();
foreach ($destinations as $k => $v) {
$destinations[$k]->total_upcoming_schedules;
}
return $destinations;
});
// ------------------------------------------------------------------------------------------------------------
// TOTAL UPCOMING TOUR
// ------------------------------------------------------------------------------------------------------------
$total_upcoming_tours = Cache::remember('total_upcoming_tour_in_5_years', 60, function () {
return \App\TourSchedule::scheduledBetween(\Carbon\Carbon::now(), \Carbon\Carbon::now()->addYear(5))->count();
});
// ------------------------------------------------------------------------------------------------------------
// SHOW DISPLAY
// ------------------------------------------------------------------------------------------------------------
$this->layout->page = view($this->page_base_dir . 'home');
$this->layout->page->headlines = $headlines;
$this->layout->page->homegrids = $homegrids;
$this->layout->page->latest_tours = $latest_tours;
$this->layout->page->promo_tours = $promo_tours;
$this->layout->page->total_upcoming_tours = $total_upcoming_tours;
$this->layout->page->top_destinations = $top_destinations;
// search tour
$this->layout->page->all_travel_agents = $this->all_travel_agents;
$this->layout->page->all_destinations = $this->all_destinations;
$this->layout->page->departure_list = $this->departure_list;
$this->layout->page->budget_list = $this->budget_list;
$this->layout->page->place_list = $this->place_list;
$this->layout->page->tour_shortcut = $this->tour_shortcut;
//
$this->layout->title = "Capcus.id - Cari paket tour jadi mudah";
$this->layout->og['title'] = $this->layout->title;
$this->layout->og['type'] = 'website';
$this->layout->og['image'] = asset('images/logo-black.png');
$this->layout->og['image:type'] = 'image/png';
$this->layout->og['image:width'] = 275;
$this->layout->og['image:height'] = 121;
return $this->layout;
}
protected function get_latest_tours()
{
// ------------------------------------------------------------------------------------------------------------
// QUERY PAKET TOUR TERBARU
// ------------------------------------------------------------------------------------------------------------
$latest_tours = Cache::remember('8_latest_tours_by_different_travel_agent', 30, function () {
return \App\Tour::with('destinations', 'schedules', 'destinations.images', 'places', 'places.images', 'travel_agent', 'travel_agent.images', 'images')->has('schedules')->select('tours.*')->join('travel_agencies', 'travel_agencies.id', '=', 'travel_agent_id')->published()->latest('tours.created_at')->limit(8)->groupBy('travel_agent_id')->get();
});
}