/home/brandsfa/.trash/app/Repositories/DeliveryManRepository.php
<?php
namespace App\Repositories;
use App\Contracts\Repositories\DeliveryManRepositoryInterface;
use App\Models\DeliveryMan;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Pagination\LengthAwarePaginator;
class DeliveryManRepository implements DeliveryManRepositoryInterface
{
public function __construct(
private readonly DeliveryMan $deliveryMan,
)
{
}
public function add(array $data): string|object
{
return $this->deliveryMan->newInstance()->create($data);
}
public function getFirstWhere(array $params, array $relations = []): ?Model
{
return $this->deliveryMan->with($relations)->where($params)->first();
}
public function getList(array $orderBy = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
// TODO: Implement getList() method.
}
public function getListWhere(array $orderBy = [], string $searchValue = null, array $filters = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
$query = $this->deliveryMan->with($relations)
->withCount('orders')
->when($searchValue, function ($query) use ($searchValue) {
$searchTerms = explode(' ', $searchValue);
$query->where(function ($query) use ($searchTerms) {
foreach ($searchTerms as $term) {
$query->orWhere('f_name', 'like', "%$term%")
->orWhere('l_name', 'like', "%$term%")
->orWhere('phone', 'like', "%$term%")
->orWhere('email', 'like', "%$term%");
}
});
})
->when(isset($filters['seller_id']), function ($query) use ($filters) {
$query->where('seller_id', $filters['seller_id']);
})
->when(!empty($orderBy), function ($query) use ($orderBy) {
$query->orderBy(key($orderBy), current($orderBy));
});
$filters += ['searchValue' => $searchValue];
return $dataLimit == 'all' ? $query->get() : $query->paginate($dataLimit)->appends($filters);
}
public function getTopRatedList(array $orderBy = [],array $filters = [], array $whereHasFilters = [], array $relations = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
return $this->deliveryMan->with($relations)
->when(isset($filters['seller_id']), function ($query) use ($filters) {
$query->where('seller_id', $filters['seller_id']);
})
->when(current($relations)=='deliveredOrders', function ($query) use ($whereHasFilters) {
$query->whereHas('deliveredOrders', function ($query) use ($whereHasFilters) {
$query->when($whereHasFilters,function ($query)use($whereHasFilters){
return $query->where($whereHasFilters)->whereNotNull('delivery_man_id');
});
});
})
->withCount(current($relations))
->when(!empty($orderBy), function ($query) use ($orderBy) {
$query->orderBy(key($orderBy), current($orderBy));
})
->get();
}
public function update(string $id, array $data): bool
{
return $this->deliveryMan->where('id', $id)->update($data);
}
public function delete(array $params): bool
{
$this->deliveryMan->where($params)->delete();
return true;
}
public function getListWhereIn(array $orderBy = [], string $searchValue = null, array $filters = [], array $relations = [], array $nullFields = [], array $withCounts = [], int|string $dataLimit = DEFAULT_DATA_LIMIT, int $offset = null): Collection|LengthAwarePaginator
{
$query = $this->deliveryMan
->when(!empty($searchValue), function ($query) use ($searchValue) {
$query->where('f_name', 'like', "%$searchValue%")
->orWhere('l_name', 'like', "%$searchValue%")
->orWhere('phone', 'like', "%$searchValue%");
})
->when(!empty($filters) && isset($filters['order_seller']) && isset($filters['shipping_method']), function ($query) use ($filters) {
$query->when($filters['order_seller'] == 'seller' && $filters['shipping_method'] == 'sellerwise_shipping', function ($query) use ($filters) {
$query->where(['seller_id' => $filters['seller_id']]);
})->when($filters['order_seller'] == 'seller' && $filters['shipping_method'] == 'inhouse_shipping', function ($query) use ($filters) {
$query->where(['seller_id' => 0]);
});
})
->when(isset($filters['is_active']), function ($query) use ($filters) {
$query->where(['is_active' => $filters['is_active']]);
})
->when(isset($withCounts), function ($query) use ($withCounts) {
$query->withCount($withCounts);
})
->when(!empty($nullFields), function ($query) use ($nullFields) {
$query->whereNull($nullFields);
})
->when(!empty($orderBy), function ($query) use ($orderBy) {
$query->orderBy(array_key_first($orderBy), array_values($orderBy)[0]);
});
$filters += ['searchValue' => $searchValue];
return $dataLimit == 'all' ? $query->get() : $query->paginate($dataLimit)->appends($filters);
}
}