ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / app / Services / Brand

<?php

/**
 * @package BrandCategorizingService
 * @author TechVillage <support@techvill.org>
 * @contributor Md Abdur Rahaman Zihad <[zihad.techvill@gmail.com]>
 * @created 26-09-2022
 */

namespace App\Services\Brand;

use App\Models\Brand;
use App\Services\CategorizationService;
use Illuminate\Support\Facades\DB;

class BrandCategorizingService extends CategorizationService
{

protected $fields = ['id', 'name'];

protected $method = null;

protected $useCache = true;

protected $data = null;

/**
     * 1 day duration
     */
    protected $cacheDuration = 86400;

/**
     * Initializes the service
     * @return void
     */
    protected function initialize($query, $withMeta)
    {
        $this->setQuery($query ?? Brand::query());
    }

/**
     * Popular brands
     * @return self
     */
    public function popularBrands()
    {
        $this->method = 'popularBrands';

if ($this->useCache) {

$brands = $this->getFromCache($this->method);

if ($brands) {
                $this->data = $brands;
                return $this;
            }
        }

$brandIds = DB::table($this->getStatsTable())->selectRaw('sum(count_views) as total_views, sum(count_sales) as total_sales, brand_id')
            ->whereBetween('date', [$this->getStartDate(), $this->getEndDate()])
            ->groupBy('brand_id')
            ->orderBy('total_views', 'desc')
            ->orderBy('total_sales', 'desc')
            ->paginate($this->limit);

$this->paginator = $brandIds;

$ids = $brandIds->getCollection()->pluck('brand_id')->toArray();

if (!is_array($ids) || count($ids) == 0) {
            $this->query = null;
            $this->paginator = null;
            return $this;
        }

$this->query = $this->getQuery()
            ->select($this->getSelectFields())
            ->whereIn('id', $ids)
            ->active()
            ->orderByRaw(DB::raw("FIELD(id, " . implode(",", $ids) . ")"));

return $this;
    }

/**
     * Best seller brands
     * @return self
     */
    public function bestSellerBrands()
    {
        $this->method = 'bestSellerBrands';

if ($this->useCache) {

$brands = $this->getFromCache($this->method);

if ($brands) {
                $this->data = $brands;
                return $this;
            }
        }

$brandIds = DB::table('brand_stats')->selectRaw('sum(count_views) as total_views, sum(count_sales) as total_sales, brand_id')
            ->whereBetween('date', [$this->getStartDate(), $this->getEndDate()])
            ->groupBy('brand_id')
            ->orderBy('total_sales', 'desc')
            ->orderBy('total_views', 'desc')
            ->paginate($this->limit);

$this->paginator = $brandIds;

$ids = $brandIds->getCollection()->pluck('brand_id')->toArray();

if (!is_array($ids) || count($ids) == 0) {
            $this->query = null;
            $this->paginator = null;
            return $this;
        }

return $this;
    }

/**
     * Random brands
     * @return self
     */
    public function randomBrands()
    {
        $this->query = $this->getQuery()
            ->active()
            ->inRandomOrder()
            ->limit($this->limit);

return $this;
    }

/**
     * Selected brands
     * @return self
     */
    public function selectedBrands($ids = [])
    {
        $this->useCache = false;

$this->query = $this->getQuery()
            ->active()
            ->whereIn('id', $ids)
            ->limit($this->limit)
            ->orderByRaw(DB::raw("FIELD(id, " . implode(",", $ids) . ")"));
        return $this;
    }

/**
     * Get stats table name
     * @return string
     */
    protected function getStatsTable()
    {
        return  'brand_stats';
    }
}

[+] ..
[-] BrandCategorizingService.php [edit]