HEX
Server: LiteSpeed
System: Linux server315.web-hosting.com 4.18.0-553.54.1.lve.el8.x86_64 #1 SMP Wed Jun 4 13:01:13 UTC 2025 x86_64
User: globfdxw (6114)
PHP: 8.1.34
Disabled: NONE
Upload Files
File: /home/globfdxw/www/wp-content/plugins/give/src/Tracking/TrackingData/CampaignsData.php
<?php

namespace Give\Tracking\TrackingData;

use Give\Campaigns\Models\Campaign;
use Give\Framework\Database\DB;
use Give\Tracking\Contracts\TrackData;
use Give\Tracking\Repositories\TrackEvents;

/**
 * @since 4.3.2
 */
class CampaignsData implements TrackData
{
    /**
     * @var TrackEvents
     */
    protected $trackEvents;

    /**
     * DonationFormsData constructor.
     *
     * @param TrackEvents $trackEvents
     */
    public function __construct(TrackEvents $trackEvents)
    {
        $this->trackEvents = $trackEvents;
    }

    /**
     * @inheritdoc
     */
    public function get()
    {
        $query = Campaign::query()
            ->select('count(forms.form_id) as formCount')
            ->leftJoin('give_campaign_forms', 'campaigns.id', 'forms.campaign_id', 'forms')
            ->groupBy('campaigns.id');

        return array_map(function($campaign) {
            return [
                'campaign_id' => $campaign->id,
                'campaign_status' => $campaign->status,
                'campaign_form_count' => $campaign->formCount,
            ];
        }, DB::get_results($query->getSQL()));
    }
}