getById($attributes['campaignId']) ) { return; } $query = (new CampaignDonationQuery($campaign)) ->select( $attributes['statistic'] === 'top-donation' ? 'MAX(amountMeta.meta_value - IFNULL(feeAmountRecovered.meta_value, 0)) as amount' : 'AVG(amountMeta.meta_value - IFNULL(feeAmountRecovered.meta_value, 0)) as amount' ) ->joinDonationMeta(DonationMetaKeys::AMOUNT, 'amountMeta') ->joinDonationMeta(DonationMetaKeys::FEE_AMOUNT_RECOVERED, 'feeAmountRecovered'); $donationStat = $query->get(); $amount = $donationStat && $donationStat->amount ? Money::fromDecimal($donationStat->amount, give_get_currency()) : Money::fromDecimal(0, give_get_currency()); $title = $attributes['statistic'] === 'top-donation' ? __('Top Donation', 'give') : __('Average Donation', 'give'); ?>
'givewp-campaign-stats-block']) ?>> formatToLocale()) ?>