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
namespace HiEvents\Http\Actions\Orders;
use HiEvents\DomainObjects\Enums\Permission;
use HiEvents\DomainObjects\Enums\QuestionBelongsTo;
use HiEvents\DomainObjects\EventDomainObject;
use HiEvents\DomainObjects\EventOccurrenceDomainObject;
use HiEvents\DomainObjects\OrderItemDomainObject;
use HiEvents\DomainObjects\QuestionAndAnswerViewDomainObject;
use HiEvents\Exports\OrdersExport;
use HiEvents\Http\Actions\BaseAction;
use HiEvents\Http\Attributes\AllowedForReadOnlyUsers;
use HiEvents\Http\Attributes\RequiresPermission;
use HiEvents\Http\DTO\FilterFieldDTO;
use HiEvents\Http\DTO\QueryParamsDTO;
use HiEvents\Repository\Eloquent\Value\Relationship;
use HiEvents\Repository\Interfaces\OrderRepositoryInterface;
use HiEvents\Repository\Interfaces\QuestionRepositoryInterface;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
use Symfony\Component\HttpFoundation\BinaryFileResponse;
#[AllowedForReadOnlyUsers]
#[RequiresPermission(Permission::VIEW_FINANCIALS)]
class ExportOrdersAction extends BaseAction
{
public function __construct(
private readonly OrderRepositoryInterface $orderRepository,
private readonly QuestionRepositoryInterface $questionRepository,
private readonly OrdersExport $export
) {}
public function __invoke(Request $request, int $eventId): BinaryFileResponse
{
$this->isActionAuthorized($eventId, EventDomainObject::class);
$eventOccurrenceId = $request->input('event_occurrence_id') ? (int) $request->input('event_occurrence_id') : null;
$filterFields = collect();
if ($eventOccurrenceId !== null) {
$filterFields->push(new FilterFieldDTO(
field: 'event_occurrence_id',
operator: 'eq',
value: (string) $eventOccurrenceId,
));
}
$this->validate($request, [
'product_ids' => ['nullable', 'array', 'max:500'],
'product_ids.*' => ['integer'],
]);
$productIds = array_map('intval', $request->input('product_ids') ?? []);
if ($productIds !== []) {
$filterFields->push(new FilterFieldDTO(
field: 'product_id',
operator: 'in',
value: implode(',', $productIds),
));
}
$orders = $this->orderRepository
->setMaxPerPage(10000)
->loadRelation(QuestionAndAnswerViewDomainObject::class)
->loadRelation(new Relationship(
domainObject: OrderItemDomainObject::class,
nested: [
new Relationship(
domainObject: EventOccurrenceDomainObject::class,
name: 'event_occurrence',
),
],
))
->findByEventId($eventId, new QueryParamsDTO(
page: 1,
per_page: 10000,
filter_fields: $filterFields->isNotEmpty() ? $filterFields : null,
));
$questions = $this->questionRepository->findWhere([
'event_id' => $eventId,
'belongs_to' => QuestionBelongsTo::ORDER->name,
]);
return Excel::download(
$this->export->withData($orders, $questions),
'orders.xlsx'
);
}
}