Server : LiteSpeed System : Linux premium84.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : claqxcrl ( 523) PHP Version : 8.1.32 Disable Function : NONE Directory :  /home/claqxcrl/anfangola.com/wp-content/plugins/matomo/app/plugins/Ecommerce/Columns/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

/**
 * Matomo - free/libre analytics platform
 *
 * @link https://matomo.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 *
 */
namespace Piwik\Plugins\Ecommerce\Columns;

use Piwik\Columns\DimensionSegmentFactory;
use Piwik\Columns\Discriminator;
use Piwik\Common;
use Piwik\Piwik;
use Piwik\Plugin\Segment;
use Piwik\Segment\SegmentExpression;
use Piwik\Segment\SegmentsList;
use Piwik\Tracker\Action;
use Piwik\Tracker\GoalManager;
use Piwik\Tracker\Request;
use Piwik\Tracker\Visitor;
class Revenue extends \Piwik\Plugins\Ecommerce\Columns\BaseConversion
{
    protected $columnName = 'revenue';
    protected $columnType = 'float default NULL';
    protected $type = self::TYPE_MONEY;
    protected $category = 'Goals_Ecommerce';
    protected $nameSingular = 'Ecommerce_OrderValue';
    public function getDbDiscriminator()
    {
        return new Discriminator($this->dbTableName, 'idgoal', GoalManager::IDGOAL_ORDER);
    }
    public function configureSegments(SegmentsList $segmentsList, DimensionSegmentFactory $dimensionSegmentFactory)
    {
        //new Segment revenue on order
        $segment = new Segment();
        $segment->setCategory($this->category);
        $segment->setName(Piwik::translate('Ecommerce_OrderRevenue'));
        $segment->setSegment('revenueOrder');
        $segment->setSqlSegment('log_conversion.idvisit');
        $segment->setSqlFilter(function ($valueToMatch, $sqlField, $matchType) {
            return $this->getRevenueQuery($valueToMatch, $sqlField, $matchType, 0);
        });
        $segmentsList->addSegment($dimensionSegmentFactory->createSegment($segment));
        //new Segment revenue left in cart
        $segment = new Segment();
        $segment->setCategory($this->category);
        $segment->setName(Piwik::translate('Ecommerce_RevenueLeftInCart'));
        $segment->setSegment('revenueAbandonedCart');
        $segment->setSqlSegment('log_conversion.idvisit');
        $segment->setSqlFilter(function ($valueToMatch, $sqlField, $matchType) {
            return $this->getRevenueQuery($valueToMatch, $sqlField, $matchType, -1);
        });
        $segmentsList->addSegment($dimensionSegmentFactory->createSegment($segment));
    }
    /**
     * revenue sql filter
     * @param $valueToMatch
     * @param $sqlField
     * @param $matchType
     * @param false $cart
     * @return array
     */
    private function getRevenueQuery($valueToMatch, $sqlField, $matchType, $idGoal)
    {
        //supported operator type
        $supportType = [SegmentExpression::MATCH_EQUAL, SegmentExpression::MATCH_GREATER_OR_EQUAL, SegmentExpression::MATCH_LESS_OR_EQUAL, SegmentExpression::MATCH_GREATER, SegmentExpression::MATCH_LESS];
        if (!in_array($matchType, $supportType)) {
            throw new \Exception("This match type {$matchType} is not available for action-segments.");
        }
        //to fit mysql operator
        if ($matchType === SegmentExpression::MATCH_EQUAL) {
            $matchType = "=";
        }
        $table = Common::prefixTable($this->dbTableName);
        $sql = " SELECT idvisit from {$table} WHERE (idgoal = {$idGoal} and revenue {$matchType} ?) ";
        return ['SQL' => $sql, 'bind' => (float) $valueToMatch];
    }
    /**
     * @param Request $request
     * @param Visitor $visitor
     * @param Action|null $action
     * @param GoalManager $goalManager
     *
     * @return mixed|false
     */
    public function onGoalConversion(Request $request, Visitor $visitor, $action, GoalManager $goalManager)
    {
        $defaultRevenue = $goalManager->getGoalColumn('revenue');
        $revenue = $request->getGoalRevenue($defaultRevenue);
        return $this->roundRevenueIfNeeded($revenue);
    }
    /**
     * @param Request $request
     * @param Visitor $visitor
     * @param Action|null $action
     * @param GoalManager $goalManager
     *
     * @return mixed|false
     */
    public function onEcommerceOrderConversion(Request $request, Visitor $visitor, $action, GoalManager $goalManager)
    {
        $defaultRevenue = 0;
        $revenue = $request->getGoalRevenue($defaultRevenue);
        return $this->roundRevenueIfNeeded($revenue);
    }
    /**
     * @param Request $request
     * @param Visitor $visitor
     * @param Action|null $action
     * @param GoalManager $goalManager
     *
     * @return mixed|false
     */
    public function onEcommerceCartUpdateConversion(Request $request, Visitor $visitor, $action, GoalManager $goalManager)
    {
        return $this->onEcommerceOrderConversion($request, $visitor, $action, $goalManager);
    }
}