Koality\ShopwarePlugin\Collector\OpenCartsCollector

Complexity

Total Complexity

6

Size/Duplication

Total Lines	78
Duplicated Lines	0 %

Importance

Changes	2
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getOpenCartCount()	0	15	2
A	getResult()	0	24	3

<?php

namespace Koality\ShopwarePlugin\Collector;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\DBALException;
use Koality\ShopwarePlugin\Formatter\Result;

/**
 * Class OpenCartsCollector
 *
 * @package Koality\ShopwarePlugin\Collector
 *
 * @author Nils Langner <nils.langner@leankoala.com>
 * created 2020-12-28
 */
class OpenCartsCollector implements Collector
{
    /**
     * @var array
     */
    private $pluginConfig = [];

    /**
     * @var Connection
     */
    private $connection;

    /**
     * OpenCartsCollector constructor.
     *
     * @param array $pluginConfig
     * @param Connection $connection
     */
    public function __construct(array $pluginConfig, Connection $connection)
    {
        $this->pluginConfig = $pluginConfig;
        $this->connection = $connection;
    }

    /**
     * @inheritdoc
     * @throws DBALException
     */
    public function getResult(): Result
    {
        $cartCount = $this->getOpenCartCount();

        if (array_key_exists('openCarts', $this->pluginConfig)) {
            $maxCartCount = $this->pluginConfig['openCarts'];
        } else {
            $maxCartCount = 1000;
        }

        if ($cartCount > $maxCartCount) {
            $cartResult = new Result(Result::STATUS_FAIL, Result::KEY_CARTS_OPEN_TOO_MANY, 'There are too many open carts at the moment.');
        } else {
            $cartResult = new Result(Result::STATUS_PASS, Result::KEY_CARTS_OPEN_TOO_MANY, 'There are not too many open carts at the moment.');
        }

        $cartResult->setLimit($maxCartCount);
        $cartResult->setObservedValue($cartCount);
        $cartResult->setObservedValueUnit('carts');
        $cartResult->setObservedValuePrecision(0);
        $cartResult->setLimitType(Result::LIMIT_TYPE_MAX);
        $cartResult->setType(Result::TYPE_TIME_SERIES_NUMERIC);

        return $cartResult;
    }

    /**
     * Return the number of open carts.
     *
     * @return int
     *
     * @throws DBALException
     *
     * @todo duplicated code with NewsletterSubscriptionCollector
     */
    private function getOpenCartCount(): int
    {
        $sql = 'SELECT count(*) FROM cart WHERE created_at >= ? AND created_at < ?';

        $statement = $this->connection->executeQuery($sql, [
            date('Y.m.d', strtotime('-1 hour')),
            date('Y.m.d')
        ]);

        $count = $statement->fetchColumn();

The function Doctrine\DBAL\Driver\ResultStatement::fetchColumn() has been deprecated: Use fetchOne() instead.

        if ($count === false) {
            return -1;
        } else {
            return (int)$count;
        }
    }
}