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\Exports;
use Carbon\Carbon;
use HiEvents\DomainObjects\Enums\QuestionTypeEnum;
use HiEvents\DomainObjects\EventOccurrenceDomainObject;
use HiEvents\DomainObjects\OrderDomainObject;
use HiEvents\DomainObjects\OrderItemDomainObject;
use HiEvents\DomainObjects\QuestionDomainObject;
use HiEvents\Services\Domain\Question\QuestionAnswerFormatter;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
class OrdersExport implements FromCollection, WithHeadings, WithMapping, WithStyles
{
private LengthAwarePaginator $orders;
private Collection $questions;
public function __construct(private QuestionAnswerFormatter $questionAnswerFormatter) {}
public function withData(LengthAwarePaginator $orders, Collection $questions): OrdersExport
{
$this->orders = $orders;
$this->questions = $questions;
return $this;
}
public function collection(): Collection
{
return collect($this->orders->items());
}
public function headings(): array
{
$questionTitles = $this->questions->map(fn ($question) => $question->getTitle())->toArray();
return array_merge([
__('ID'),
__('First Name'),
__('Last Name'),
__('Email'),
__('Total Before Additions'),
__('Total Gross'),
__('Total Tax'),
__('Total Fee'),
__('Total Refunded'),
__('Status'),
__('Payment Status'),
__('Refund Status'),
__('Currency'),
__('Created At'),
__('Public ID'),
__('Occurrence Date'),
__('Payment Provider'),
__('Is Partially Refunded'),
__('Is Fully Refunded'),
__('Is Free Order'),
__('Is Manually Created'),
__('Billing Address'),
__('Notes'),
__('Promo Code'),
__('Opted In To Marketing'),
], $questionTitles, [
__('Sales Channel'),
__('Tender'),
__('Operator'),
__('Amount Tendered'),
__('Change Due'),
__('Reference'),
]);
}
/**
* @param OrderDomainObject $order
*/
public function map($order): array
{
$answers = $this->questions->map(function (QuestionDomainObject $question) use ($order) {
$answer = $order->getQuestionAndAnswerViews()
->first(fn ($qav) => $qav->getQuestionId() === $question->getId())?->getAnswer() ?? '';
return $this->questionAnswerFormatter->getAnswerAsText(
$answer,
QuestionTypeEnum::fromName($question->getType()),
);
});
$occurrenceDate = $order->getOrderItems()
?->map(fn (OrderItemDomainObject $item) => $item->getEventOccurrence())
?->filter()
?->unique(fn (EventOccurrenceDomainObject $occ) => $occ->getId())
?->sortBy(fn (EventOccurrenceDomainObject $occ) => $occ->getStartDate())
?->map(fn (EventOccurrenceDomainObject $occ) => Carbon::parse($occ->getStartDate())->format('Y-m-d H:i:s'))
?->implode(', ') ?? '';
return array_merge([
$order->getId(),
$order->getFirstName(),
$order->getLastName(),
$order->getEmail(),
$order->getTotalBeforeAdditions(),
$order->getTotalGross(),
$order->getTotalTax(),
$order->getTotalFee(),
$order->getTotalRefunded(),
$order->getStatus(),
$order->getPaymentStatus(),
$order->getRefundStatus(),
$order->getCurrency(),
Carbon::parse($order->getCreatedAt())->format('Y-m-d H:i:s'),
$order->getPublicId(),
$occurrenceDate,
$order->getPaymentProvider(),
$order->isPartiallyRefunded(),
$order->isFullyRefunded(),
$order->isFreeOrder(),
$order->getIsManuallyCreated(),
$order->getBillingAddressString(),
$order->getNotes(),
$order->getPromoCode(),
$order->getOptedIntoMarketingAt() ? 'Yes' : 'No',
], $answers->toArray(), [
$order->isBoxOfficeOrder() ? __('Box Office') : __('Online'),
$order->getBoxOfficeTender(),
$order->getBoxOfficeOperatorName(),
$order->getBoxOfficeAmountTendered(),
$order->getBoxOfficeChangeDue(),
$order->getBoxOfficeReference(),
]);
}
public function styles(Worksheet $sheet): array
{
return [
1 => ['font' => ['bold' => true]],
];
}
}