Open-source event management and ticket selling platform — perfect for concerts, conferences, and everything in between 🎟️ If you find this project helpful, please consider giving us a star ⭐️
PHP attendize-alternativedoor-managementevent-check-inevent-managementevent-registrationevent-ticketingeventbrite-alternativeeventslaravelopen-sourcephpreactself-hostedsell-ticketssell-tickets-onlineticket-sellingticketing-systemtickettailor-alternativetito-alternative
<?php
declare(strict_types=1);
namespace HiEvents\Repository\Eloquent;
use HiEvents\DomainObjects\AffiliateDomainObject;
use HiEvents\DomainObjects\Generated\AffiliateDomainObjectAbstract;
use HiEvents\DomainObjects\Status\AffiliateStatus;
use HiEvents\Http\DTO\QueryParamsDTO;
use HiEvents\Models\Affiliate;
use HiEvents\Repository\Interfaces\AffiliateRepositoryInterface;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Pagination\LengthAwarePaginator;
/**
* @extends BaseRepository<AffiliateDomainObject>
*/
class AffiliateRepository extends BaseRepository implements AffiliateRepositoryInterface
{
protected function getModel(): string
{
return Affiliate::class;
}
public function getDomainObject(): string
{
return AffiliateDomainObject::class;
}
public function findByEventId(int $eventId, QueryParamsDTO $params): LengthAwarePaginator
{
$where = [
[AffiliateDomainObjectAbstract::EVENT_ID, '=', $eventId],
];
if ($params->query) {
$where[] = static function (Builder $builder) use ($params) {
$builder
->orWhere(AffiliateDomainObjectAbstract::NAME, 'ilike', '%'.$params->query.'%')
->orWhere(AffiliateDomainObjectAbstract::CODE, 'ilike', '%'.$params->query.'%')
->orWhere(AffiliateDomainObjectAbstract::EMAIL, 'ilike', '%'.$params->query.'%');
};
}
$this->model = $this->model->orderBy(
column: $this->validateSortColumn($params->sort_by, AffiliateDomainObject::class),
direction: $this->validateSortDirection($params->sort_direction, AffiliateDomainObject::class),
);
return $this->paginateWhere(
where: $where,
limit: $params->per_page,
page: $params->page,
);
}
public function findByCodeAndEventId(string $code, int $eventId): ?AffiliateDomainObject
{
return $this->findFirstWhere([
AffiliateDomainObjectAbstract::CODE => $code,
AffiliateDomainObjectAbstract::EVENT_ID => $eventId,
AffiliateDomainObjectAbstract::STATUS => AffiliateStatus::ACTIVE->value,
]);
}
public function incrementSales(int $affiliateId, float $amount): void
{
$this->runQuery(fn () => $this->model->where('id', $affiliateId)
->increment('total_sales', 1, [
'total_sales_gross' => $this->db->raw('total_sales_gross + '.$amount),
]));
}
public function decrementSales(int $affiliateId, float $amount): void
{
$this->runQuery(fn () => $this->model->where('id', $affiliateId)
->update([
'total_sales' => $this->db->raw('GREATEST(0, total_sales - 1)'),
'total_sales_gross' => $this->db->raw('GREATEST(0, total_sales_gross - '.$amount.')'),
]));
}
}