aDriv4 website!

Linux server192.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
198.54.114.198

File Name : AttachAttendeeDataToTicketData.php

<?php

namespace Give\EventTickets\Actions;

use Give\EventTickets\Models\EventTicket;
use Give\Framework\QueryBuilder\QueryBuilder;

/**
 * @since 3.6.0
 */
class AttachAttendeeDataToTicketData
{
    /**
     * @since 3.6.0
     * @var array
     */
    protected $attendeeDataLookup;

/**
     * @since 3.6.0
     * @param EventTicket[] $tickets
     */
    public function __construct(array $tickets)
    {
        $this->attendeeDataLookup = array_reduce($this->getAttendeeDataForTickets($tickets), function ($lookup, $data) {
            $lookup[$data->donationId] = ['name' => $data->attendeeName, 'email' => $data->attendeeEmail];
            return $lookup;
        }, []);
    }

/**
     * @since 3.6.0
     */
    public function __invoke(EventTicket $ticket): array
    {
        return array_merge($ticket->toArray(), [
            'attendee' => $this->attendeeDataLookup[$ticket->donationId] ?? null,
        ]);
    }

/**
     * This query relates donors names to tickets through donations.
     *
     * @since 3.6.0
     *
     * @param EventTicket[] $tickets
     */
    protected function getAttendeeDataForTickets(array $tickets): array
    {
        if (empty($tickets)) {
            return [];
        }

return (new QueryBuilder)
            ->from('posts', 'Donation')
            ->select(
                ['Donation.ID', 'donationId'],
                ['Donor.name', 'attendeeName'],
                ['Donor.email', 'attendeeEmail']
            )
            ->join(function($builder) {
                $builder
                    ->leftJoin('give_donationmeta', $tableAlias = 'DonationDonorId' )
                    ->on('Donation.ID', "DonationDonorId.donation_id")
                    ->andOn("DonationDonorId.meta_key", '_give_payment_donor_id', true);
            })
            ->join(function($builder) {
                $builder
                    ->leftJoin('give_donors', $tableAlias = 'Donor' )
                    ->on('DonationDonorId.meta_value', "Donor.id");
            })
            ->where('post_type', 'give_payment')
            ->whereIn('Donation.ID', array_column($tickets, 'donationId'))
            ->getAll();
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	htllcxvj/htllcxvj	0755	2025-01-18 03:35:07
..	dir	-	htllcxvj/htllcxvj	0755	2025-04-30 09:01:43
.htaccess	text/plain	127 B	htllcxvj/htllcxvj	0444	2025-01-18 03:35:07
AddEventTicketsToDonationConfirmationPageDonationTotal.php	text/x-php	1.2 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
AddEventTicketsToDonationConfirmationPageEventTicketDetails.php	text/x-php	1.38 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
AttachAttendeeDataToTicketData.php	text/x-php	2.14 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
ConvertEventTicketsBlockToFieldsApi.php	text/x-php	2.25 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
EnqueueDonationFormScripts.php	text/x-php	789 B	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
EnqueueEventDetailsScripts.php	text/x-php	1.11 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
EnqueueFormBuilderScripts.php	text/x-php	2.61 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
EnqueueListTableScripts.php	text/x-php	1.07 KB	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
GenerateTicketsFromPurchaseData.php	text/x-php	853 B	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
RegisterEventsMenuItem.php	text/x-php	1018 B	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
RenderDonationFormBlock.php	text/x-php	900 B	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31
UpdateDonationConfirmationPageReceiptDonationAmount.php	text/x-php	748 B	htllcxvj/htllcxvj	0644	2024-12-03 09:32:31

For more Private tool come to me!

https://t.me/aDriv4vz