Viewing file:  Adlist.php (11.76 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Livewire;
use Livewire\Component;
use Modules\Ad\Entities\Ad;
use Modules\Brand\Entities\Brand;
use Modules\Category\Entities\Category;
use Modules\Category\Entities\SubCategory;
class Adlist extends Component
{
public $ads;
public $customfields;
public $selectedCustomFieldValues = [];
public $topAds;
public $bumpUpAds;
public $count = 15;
public $loading = false;
public $search = '';
public $selectedCategory = '';
public $selectedSubcategory = '';
public $minPrice;
public $maxPrice;
public $brands;
public $selectedbrand;
public $dateRange;
public $seletedFeatured;
public $location;
public $seletedLatest;
public $selectedUrgent;
public $selectAll;
public $showLoadMore = true;
public $adsCount = 0;
public $seletedOption;
public $search_ad_val = '';
public $filter_value;
protected $listeners = ['adListSearchText'];
public function mount()
{
$this->search = request('headerSearch');
}
public function render()
{
// divide the url into segments
$path = parse_url(request()->url(), PHP_URL_PATH);
$pathSegments = explode('/', $path);
// fetching top ads and bump up ads
$this->topAds = $this->loadTopAds();
$this->bumpUpAds = $this->loadBumpUpAds();
$except_ids = array_merge($this->topAds->pluck('id')->toArray(), $this->bumpUpAds->pluck('id')->toArray());
// fetching all ads
$query = Ad::query()
->select('id', 'title', 'slug', 'user_id', 'category_id', 'subcategory_id', 'price', 'brand_id', 'thumbnail', 'country', 'region', 'urgent', 'highlight', 'top', 'featured', 'featured_at', 'bump_up', 'created_at')
->active()
->when(session()->get('selected_country'), function ($query) {
$query->where('country', session()->get('selected_country'));
})
->when(count($except_ids), function ($query) use ($except_ids) {
$query->whereNotIn('id', $except_ids);
})
->latest();
// Check if there are enough segments in the path
if (count($pathSegments) >= 3) {
$secondSegment = $pathSegments[2]; // category
// Apply category filter if selected
if ($secondSegment) {
$category = Category::where('slug', $secondSegment)->first();
if ($category) {
$query->whereIn('category_id', [$category->id]);
$this->selectedCategory = [$category->slug];
}
}
// Check if there are enough segments in the path
if (count($pathSegments) >= 4) {
$thirdSegment = $pathSegments[3]; // subcategory
// Apply category filter if selected
if ($thirdSegment) {
$subcategory = SubCategory::where('slug', $thirdSegment)->first();
if ($subcategory) {
$query->whereIn('subcategory_id', [$subcategory->id]);
$this->selectedSubcategory = $subcategory->slug;
}
}
}
}
if (request('headerSearch')) {
$this->ads = $query
->when(request('headerSearch'), function ($query) {
$query->where('title', 'like', '%'.request('headerSearch').'%');
})
->with(['category'])
->take($this->count)
->get();
}
$this->customfields = null;
// Apply category filter if selected
if ($this->selectedCategory) {
$catID = Category::where('slug', $this->selectedCategory)->first();
$query->whereIn('category_id', [$catID->id]);
if ($catID) {
$category = Category::with('customFields.values')->find($catID->id);
if ($category) {
$this->customfields = $category->customFields->toArray();
}
}
}
// Apply subcategory filter if selected
if ($this->selectedSubcategory) {
$subCatID = SubCategory::with('category:id,slug')
->where('slug', $this->selectedSubcategory)
->first();
$this->selectedCategory = $subCatID->category?->slug ?? '';
$query->WhereIn('subcategory_id', [$subCatID->id]);
}
// Apply brands filter if selected
if ($this->selectedbrand) {
$brandId = Brand::where('name', $this->selectedbrand)->first();
$query->where('brand_id', [$brandId->id]);
}
// Debugging statement
// dd($this->seletedOption);
// Apply seletedFeatured filter if selected
if ($this->seletedOption == 1) {
$query->where('featured', 1);
}
// Apply seletedLatest filter if selected
if ($this->seletedOption == 'asc') {
$query->orderBy('updated_at', 'asc');
}
// Apply urgent filter if selected
if ($this->seletedOption == 2) {
$query->where('urgent', 1);
}
// Apply price range filter if min and/or max price are selected
if ($this->minPrice || $this->maxPrice) {
$query->whereBetween('price', [$this->minPrice, $this->maxPrice]);
}
// Apply date range filter if specified
if ($this->dateRange) {
$startDate = now()
->subDays($this->dateRange)
->startOfDay();
$endDate = now()->endOfDay();
$query->whereBetween('updated_at', [$startDate, $endDate]);
}
// Apply date range filter if specified
if ($this->location) {
$query->where(function ($q) {
$q->where('country', 'like', '%'.$this->location.'%')
->orWhere('region', 'like', '%'.$this->location.'%')
->orWhere('district', 'like', '%'.$this->location.'%');
});
}
if (request('country') || request('state') || request('city')) {
$query->where(function ($q) {
$q->where('country', 'like', '%'.request('country').'%')
->orWhere('region', 'like', '%'.request('state').'%')
->orWhere('district', 'like', '%'.request('city').'%');
});
if (request()->filled('country')) {
$this->location = request()->country;
}
if (request()->filled('state')) {
$this->location = $this->location.', '.request()->state;
}
if (request()->filled('city')) {
$this->location = $this->location.', '.request()->city;
}
}
if (! empty($this->selectedCustomFieldValues)) {
foreach ($this->selectedCustomFieldValues as $fieldId => $value) {
$query->whereHas('productCustomFieldsvalue', function ($q) use ($value) {
$q->where('value', 'like', '%'.$value.'%');
});
}
}
$this->ads = $query
->with(['category'])
->take($this->count)
->get();
$this->adsCount = $query->count();
$this->showLoadMore = $this->adsCount > $this->count ? true : false;
$this->loading = false;
if (! is_null($this->search_ad_val) && (strlen(($this->search_ad_val)) > 1)) {
$this->filter_value = Ad::active()->where('title', 'like', '%'.$this->search_ad_val.'%')
->take(5)
->get();
} else {
$this->filter_value = [];
}
return view('livewire.adlist');
}
public function adListSearchText($data)
{
$this->location = $data;
}
public function loadMore()
{
$this->loading = true;
$this->count += 15;
}
public function removeSelectedBrand()
{
$this->selectedbrand = null;
}
public function removeSelectedDate()
{
$this->dateRange = null;
}
public function updatedSelectedCategory()
{
$this->selectedSubcategory = '';
$this->updateUrl();
}
public function updatedSelectedSubcategory()
{
$this->updateUrl();
}
public function updateUrl()
{
$query = Ad::query()
->select('id', 'title', 'slug', 'user_id', 'category_id', 'featured', 'subcategory_id', 'price', 'brand_id', 'thumbnail', 'country', 'region', 'created_at')
->active()
->latest();
$metatitle = '';
// Apply category filter if selected
if ($this->selectedCategory) {
$catID = Category::where('slug', $this->selectedCategory)->first();
$countCategory = $query->whereIn('category_id', [$catID->id])->count();
$metatitle = $countCategory.' '.__('ads_found_for');
}
// Apply subcategory filter if selected
if ($this->selectedSubcategory) {
$subCatID = SubCategory::with('category:id,slug')
->where('slug', $this->selectedSubcategory)
->first();
$this->selectedCategory = $subCatID->category?->slug ?? '';
$countSubCategory = $query->WhereIn('subcategory_id', [$subCatID->id])->count();
$metatitle = $countSubCategory.__('ads_found_for');
}
$this->dispatchBrowserEvent('update-selected-category', ['category' => $this->selectedCategory, 'subcategory' => $this->selectedSubcategory, 'metatitle' => $metatitle]);
}
private function loadTopAds()
{
$query = Ad::query()
->with('category')
->select('id', 'title', 'slug', 'user_id', 'category_id', 'subcategory_id', 'price', 'brand_id', 'thumbnail', 'country', 'region', 'urgent', 'highlight', 'top', 'featured', 'featured_at', 'bump_up', 'created_at')
->active()
->when(session()->get('selected_country'), function ($query) {
$query->where('country', session()->get('selected_country'));
})
->when($this->selectedCategory, function ($query) {
$catID = Category::where('slug', $this->selectedCategory)->first();
$query->whereIn('category_id', [$catID->id]);
})
->top()
->inRandomOrder()
->take(5);
// Apply seletedLatest filter if selected
if ($this->seletedOption == 'asc') {
$query->orderBy('updated_at', 'asc');
}
// Apply urgent filter if selected
if ($this->seletedOption == 2) {
$query->where('urgent', 1);
}
return $query->get();
}
private function loadBumpUpAds()
{
$query = Ad::query()
->with('category')
->select('id', 'title', 'slug', 'user_id', 'category_id', 'subcategory_id', 'price', 'brand_id', 'thumbnail', 'country', 'region', 'urgent', 'highlight', 'top', 'featured', 'featured_at', 'bump_up', 'created_at')
->active()
->when(session()->get('selected_country'), function ($query) {
$query->where('country', session()->get('selected_country'));
})
->when($this->selectedCategory, function ($query) {
$catID = Category::where('slug', $this->selectedCategory)->first();
$query->whereIn('category_id', [$catID->id]);
})
->bumpUp()
->inRandomOrder()
->take(5);
// Apply seletedLatest filter if selected
if ($this->seletedOption == 'asc') {
$query->orderBy('updated_at', 'asc');
}
// Apply urgent filter if selected
if ($this->seletedOption == 2) {
$query->where('urgent', 1);
}
return $query->get();
}
}
|