public function lists($travel_agent = null, $tujuan = null, $keberangkatan = null, $budget = null)
{
// ------------------------------------------------------------------------
// REDIRECT IF REQUEST URL
// ------------------------------------------------------------------------
$filters = Input::only('travel_agent', 'tujuan', 'keberangkatan_sejak', 'keberangkatan_hingga', 'budget');
if (!empty(array_filter($filters))) {
$filters = array_filter($filters);
// Travel Agent
if (!$filters['travel_agent']) {
$filters['travel_agent'] = 'semua-travel-agent';
}
// Tujuan
if (!$filters['tujuan']) {
$filters['tujuan'] = 'semua-tujuan';
}
// Keberangkatan
if ($filters['keberangkatan_sejak'] && $filters['keberangkatan_hingga']) {
try {
$tmp1 = \Carbon\Carbon::createFromFormat('d-m-Y', $filters['keberangkatan_sejak']);
$tmp2 = \Carbon\Carbon::createFromFormat('d-m-Y', $filters['keberangkatan_hingga']);
} catch (Exception $e) {
return App::abort(404);
}
if ($tmp1->lt($tmp2)) {
$keberangkatan_str = $tmp1->format('Ymd') . '-' . $tmp2->format('Ymd');
} else {
$keberangkatan_str = $tmp2->format('Ymd') . '-' . $tmp1->format('Ymd');
}
} else {
$keberangkatan_str = "semua-keberangkatan";
}
// Tujuan
if (!$filters['budget']) {
$filters['budget'] = 'semua-budget';
}
return redirect()->to(route('web.tour', ['travel_agent' => $filters['travel_agent'], 'tujuan' => $filters['tujuan'], 'keberangkatan' => $keberangkatan_str, 'budget' => $filters['budget']]) . (Input::has('place') ? '?place=' . Input::get('place') : ''));
} else {
$filters['travel_agent'] = $travel_agent;
$filters['tujuan'] = $tujuan;
$filters['keberangkatan'] = $keberangkatan;
$filters['budget'] = $budget;
$filters['place'] = Input::get('place');
// TRAVEL AGENT
if (str_is(strtolower($filters['travel_agent']), 'semua-travel-agent')) {
unset($filters['travel_agent']);
} else {
if ($filters['travel_agent']) {
$filters['travel_agent'] = TravelAgent::SlugIs($filters['travel_agent'])->first();
if (!$filters['travel_agent']) {
return App::abort(404);
}
}
$this->layout->basic->filters['travel_agent'] = $filters['travel_agent'];
}
// TUJUAN
if (str_is(strtolower($filters['tujuan']), 'semua-tujuan')) {
unset($filters['tujuan']);
} else {
$tujuan_tree = Destination::findPath(str_replace(',', Destination::getDelimiter(), $filters['tujuan'] . '*'))->get();
if (!$tujuan_tree) {
return App::abort(404);
}
// get tujuan object
foreach ($tujuan_tree as $x) {
if (str_is($filters['tujuan'], $x->path_slug)) {
$filters['tujuan'] = $x;
break;
}
}
$this->layout->basic->filters['tujuan'] = $filters['tujuan'];
}
// KEBERANGKATAN
if (str_is(strtolower($filters['keberangkatan']), 'semua-keberangkatan')) {
unset($filters['keberangkatan']);
$filters['keberangkatan']['from'] = \Carbon\Carbon::now();
$filters['keberangkatan']['to'] = \Carbon\Carbon::now()->addYear(1);
} elseif ($filters['keberangkatan']) {
list($keberangkatan_from, $keberangkatan_to) = explode('-', $filters['keberangkatan']);
try {
$keberangkatan_from = \Carbon\Carbon::createFromFormat('Ymd', $keberangkatan_from);
$keberangkatan_to = \Carbon\Carbon::createFromFormat('Ymd', $keberangkatan_to);
if ($keberangkatan_from->gt($keberangkatan_to)) {
$tmp = $keberangkatan_from;
$keberangkatan_from = $keberangkatan_to;
$keberangkatan_to = $tmp;
}
} catch (Exception $e) {
App::abort(404);
}
unset($filters['keberangkatan']);
$filters['keberangkatan']['from'] = $keberangkatan_from;
$filters['keberangkatan']['to'] = $keberangkatan_to;
$this->layout->basic->filters['keberangkatan'] = $filters['keberangkatan'];
} else {
$filters['keberangkatan']['from'] = \Carbon\Carbon::now();
$filters['keberangkatan']['to'] = \Carbon\Carbon::now()->addYear(1);
}
// BUDGET
if (str_is(strtolower($filters['budget']), 'semua-budget')) {
unset($filters['budget']);
} else {
list($budget_min, $budget_max) = explode('-', $filters['budget']);
if ($budget_min * 1 < 0) {
return App::abort(404);
}
if (!is_null($budget_max) && ($budget_max <= 0 || $budget_max <= $budget_min)) {
return App::abort(404);
}
unset($filters['budget']);
$filters['budget'] = ['min' => $budget_min, 'max' => $budget_max];
$this->layout->basic->filters['budget'] = $filters['budget'];
}
// PLACE
if ($filters['place']) {
$filters['place'] = \App\Place::slugIs($filters['place'])->first();
if (!$filters['place']) {
return App::abort(404);
}
}
}
// ------------------------------------------------------------------------
// QUERY
// ------------------------------------------------------------------------
$max_data = 50;
$results = Cache::remember('tour_schedules_' . serialize($filters), 30, function () use($filters, $tujuan_tree, $max_data) {
$results = $this->dispatch(new FindPublishedTourSchedules($filters['keberangkatan']['from'], $filters['keberangkatan']['to'], $tujuan_tree ? $tujuan_tree->lists('id') : null, $filters['budget']['min'] * 1, $filters['budget']['max'] ? $filters['budget']['max'] * 1 : 99999999999.0, $filters['travel_agent']->id, $filters['place']->slug, 0, $max_data, true));
$results['data']->load('tour', 'tour.travel_agent', 'tour.travel_agent.active_packages', 'tour.places', 'tour.destinations', 'tour.travel_agent.images', 'tour.options');
return $results;
});
$tour_schedules_count = $results['count'];
$tour_schedules = $results['data'];
// SORT BY TRAVEL AGENT PRIORITY
// $tour_schedules = $tour_schedules->sortBy(function($data, $key){
// return str_pad($data->tour->travel_agent->active_packages[0]->priority ? $data->tour->travel_agent->active_packages[0]->priority * -1 : 0, 2, 0, STR_PAD_LEFT) . $data->departure;
// });
// ------------------------------------------------------------------------
// PREPARE FILTERS FOR RESULTS
// ------------------------------------------------------------------------
$filter_schedules = [];
// durations
foreach ($tour_schedules as $schedule) {
$filter_schedules['durations'][$schedule->tour->duration_day * 1] = $schedule->tour->duration_day . 'D/' . $schedule->tour->duration_night . 'N';
$filter_schedules['travel_agents'][$schedule->tour->travel_agent->id] = $schedule->tour->travel_agent->name;
if (!$filter_schedules['price']['min'] || $filter_schedules['price']['min'] > $schedule->discounted_price) {
$filter_schedules['price']['min'] = $schedule->discounted_price;
}
if ($filter_schedules['price']['max'] < $schedule->discounted_price) {
$filter_schedules['price']['max'] = $schedule->discounted_price;
}
}
ksort($filter_schedules['durations']);
asort($filter_schedules['travel_agents']);
// ------------------------------------------------------------------------------------------------------------
// SHOW DISPLAY
// ------------------------------------------------------------------------------------------------------------
$this->layout->page = view($this->page_base_dir . 'tours');
$this->layout->page->travel_agent = $travel_agent;
$this->layout->page->tujuan_tree = $tujuan_tree;
$this->layout->page->max_data = $max_data;
$this->layout->page->filters = $filters;
$this->layout->page->filter_schedules = $filter_schedules;
$this->layout->page->option_list = $this->option_list;
$this->layout->page->tour_schedules = $tour_schedules;
$this->layout->page->tour_schedules_count = $tour_schedules_count;
$this->layout->page->other_tours = $other_tours;
// 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->tour_shortcut = $this->tour_shortcut;
//
$this->layout->title = "Paket Tour " . ($filters['tujuan'] ? 'ke ' . $filters['tujuan']->name : '') . ($filters['travel_agent'] ? ' oleh ' . $filters['travel_agent']->name : '') . ($filters['keberangkatan']['from'] && $filters['keberangkatan']['to'] ? ' keberangkatan ' . $filters['keberangkatan']['from']->format('d-m-Y') . ' s/d ' . $filters['keberangkatan']['to']->format('d-m-Y') : '') . ($filters['budget']['min'] ? ' harga ' . $filters['budget']['min'] . '-' . $filters['budget']['max'] : '') . ' - Capcus.id';
$this->layout->og['title'] = $this->layout->title;
$this->layout->og['type'] = 'website';
$this->layout->og['image'] = $tour_schedules->count() ? $tour_schedules->first()->tour->places->first()->images->where('name', 'LargeImage')->first()->path : '';
$this->layout->og['image:type'] = 'jpg';
$this->layout->og['image:width'] = 800;
$this->layout->og['image:height'] = 600;
return $this->layout;
}
public function index($destination_slug = null, $tag = null, $page = 1)
{
// ------------------------------------------------------------------------
// REDIRECT IF THERE'S REQUEST QUERY
// ------------------------------------------------------------------------
if (Input::has('destination') || Input::has('tag')) {
return redirect()->route('web.places', ['destination' => Input::get('destination'), 'kategori' => implode(',', Input::get('tag')), 'page' => null] + Input::only('nama'));
}
// ------------------------------------------------------------------------
// HANDLE FILTERS
// ------------------------------------------------------------------------
// Destination List
$destination_list = Cache::remember('all_destination_list', 30, function () {
return \App\Destination::orderBy('path')->get();
});
$destination_list = ['semua' => "Semua"] + $destination_list->lists('long_name', 'path_slug')->toArray();
$filters['destination'] = $destination_slug;
if (str_is('semua', $filters['destination']) || is_null($filters['destination'])) {
$filters['destination'] = null;
} else {
$destination = \App\Destination::findPath(str_replace(',', Destination::getDelimiter(), $filters['destination'] . '*'))->first();
if (!$destination) {
return App::abort(404);
}
}
// TAG LIST
$tag_list = ['kuliner' => 'food', 'belanja' => 'bag', 'budaya' => 'culture', 'pemandangan' => 'nature', 'hiburan' => 'entertain', 'kesehatan' => 'briefcase-plus'];
asort($tag_list);
$filters['tags'] = array_filter(explode(',', $tag));
if (!empty($filters['tags'])) {
foreach ($filters['tags'] as $x) {
if (!array_key_exists($x, $tag_list)) {
App::abort(404);
}
}
}
// NAMA
$filters['nama'] = Input::get('nama');
// ------------------------------------------------------------------------
// PREPARE QUERY
// ------------------------------------------------------------------------
// pagination
$page = max(1, $page * 1);
$per_page = 10;
$skip = ($page - 1) * $per_page;
// ------------------------------------------------------------------------
// EXECUTE QUERY
// ------------------------------------------------------------------------
$places = Cache::remember('all_place_in_' . serialize($filters) . '_skip' . $skip . '_take_' . $per_page, 30, function () use($skip, $per_page, $filters) {
$places = Place::inDestinationByPathAndChildren(str_replace(',', Destination::getDelimiter(), $filters['destination'] . '*'))->published()->LongNameLike('*' . $filters['nama'] . '*')->InTagByTag($filters['tags'])->skip($skip)->take($per_page)->latest('published_at')->get();
$places->load('destination', 'images', 'upcoming_tours', 'upcoming_tours.schedules');
return $places;
});
$place_count = Cache::remember('count_all_place_in_' . serialize($filters), 30, function () use($skip, $per_page, $filters) {
$places = Place::inDestinationByPathAndChildren(str_replace(',', Destination::getDelimiter(), $filters['destination'] . '*'))->InTagByTag(explode(',', $filters['tags']))->published()->LongNameLike('*' . $filters['nama'] . '*')->count();
return $places;
});
// ------------------------------------------------------------------------------------------------------------
// SHOW DISPLAY
// ------------------------------------------------------------------------------------------------------------
$this->layout->page = view($this->page_base_dir . 'places');
$this->layout->page->destination = $destination;
$this->layout->page->destination_list = $destination_list;
$this->layout->page->tag_list = $tag_list;
$this->layout->page->filters = $filters;
$this->layout->page->places = $places;
$this->layout->page->option_list = $this->option_list;
$this->layout->page->current_page = $page;
$this->layout->page->per_page = $per_page;
$this->layout->page->start_pagination = max(1, $page - 3);
$this->layout->page->last_pagination = min(ceil($place_count / $per_page), $page + 3);
$this->layout->title = "Tujuan Wisata ";
if ($destination->id) {
$this->layout->title .= "di " . $destination->name;
}
$this->layout->title .= "- Capcus.id";
$this->layout->og['title'] = $this->layout->title;
$this->layout->og['type'] = 'website';
$this->layout->og['image'] = $places->count() ? $places->first()->images->where('name', 'LargeImage')->path : asset('images/logo-black.png');
$this->layout->og['image:type'] = pathinfo('images/' . $this->layout->og['image'], PATHINFO_EXTENSION);
$this->layout->og['image:width'] = 275;
$this->layout->og['image:height'] = 121;
return $this->layout;
}
