DbCouponRepository.php

<?php

// ...

class DbCouponRepository implements CouponRepositoryInterface
{
    /**
     * @const int
     */
    const PAGE_SIZE = 25;

    /**
     * @var CouponEloquentModel
     */
    private $eloquentModel;

    /**
     * CouponRepository constructor.
     */
    public function __construct()
    {
        $this->eloquentModel = new CouponEloquentModel();
    }

    /**
     * Get all coupons.
     *
     * @param null $filterableKeyword
     * @param array $orders
     * @return LengthAwarePaginator
     */
    public function getAllCoupons(
        $filterableKeyword = null,
        array $orders = [
            [
                'column' => 'name',
                'direction' => 'asc'
            ]
        ]
    )
    {
        $query = $this->eloquentModel
            ->newQuery()
            ->select([
                'coupons.*'
            ]);

        if (! is_null($this->filterableKeyword)) {
            $query->where(function (QueryBuilder $query) {
                $query->where('coupons.name', 'like', '%' . $filterableKeyword . '%');
                $query->orWhere('coupons.code', 'like', '%' . $filterableKeyword . '%');
                $query->orWhere('coupons.description', 'like', '%' . $filterableKeyword . '%');
                $query->orWhere('coupons.internal_description', 'like', '%' . $filterableKeyword . '%');
            });
        }

        $query->leftJoin('plans', 'plans.id', '=', 'coupons.plan_id');

        $query->orders = $this->orders;

        $results = $query->paginate(self::PAGE_SIZE);

        $data = $results->map(function ($item) {
            return (new CouponTransform())->transform($item);
        });

        return new LengthAwarePaginator($data, $results->total(), self::PAGE_SIZE, $results->currentPage());
    }