mirror of
https://github.com/SuiteCRM/SuiteCRM-Core.git
synced 2026-07-26 22:39:11 +08:00
122 lines
3.5 KiB
PHP
122 lines
3.5 KiB
PHP
<?php
|
|
/**
|
|
* SuiteCRM is a customer relationship management program developed by SuiteCRM Ltd.
|
|
* Copyright (C) 2021 SuiteCRM Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUITECRM, SUITECRM DISCLAIMS THE
|
|
* WARRANTY OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License
|
|
* along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License
|
|
* version 3, these Appropriate Legal Notices must retain the display of the
|
|
* "Supercharged by SuiteCRM" logo. If the display of the logos is not reasonably
|
|
* feasible for technical reasons, the Appropriate Legal Notices must display
|
|
* the words "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
|
|
namespace App\Module\Cases\Statistics;
|
|
|
|
use aCase;
|
|
use App\Statistics\Entity\Statistic;
|
|
use App\Data\LegacyHandler\PresetDataHandlers\SubpanelDataQueryHandler;
|
|
use App\Statistics\Service\StatisticsProviderInterface;
|
|
use App\Statistics\StatisticsHandlingTrait;
|
|
use BeanFactory;
|
|
use Psr\Log\LoggerAwareInterface;
|
|
use Psr\Log\LoggerInterface;
|
|
|
|
class CasesPerAccount extends SubpanelDataQueryHandler implements StatisticsProviderInterface, LoggerAwareInterface
|
|
{
|
|
use StatisticsHandlingTrait;
|
|
|
|
public const KEY = 'cases-per-account';
|
|
|
|
/**
|
|
* @var LoggerInterface
|
|
*/
|
|
private $logger;
|
|
|
|
/**
|
|
* @inheritDoc
|
|
*/
|
|
public function getKey(): string
|
|
{
|
|
return self::KEY;
|
|
}
|
|
|
|
/**
|
|
* @inheritDoc
|
|
* @param array $query
|
|
* @return Statistic
|
|
*/
|
|
public function getData(array $query): Statistic
|
|
{
|
|
$subpanel = 'cases';
|
|
[$module, $id] = $this->extractContext($query);
|
|
|
|
if (empty($module) || empty($id)) {
|
|
return $this->getEmptyResponse(self::KEY);
|
|
}
|
|
|
|
$this->init();
|
|
$this->startLegacyApp();
|
|
|
|
$bean = $this->getCase($id);
|
|
|
|
if ($bean === null) {
|
|
$this->logger->error('CasesPerAccount: Unable to load case bean with id: ' . $id);
|
|
|
|
return $this->getEmptyResponse(self::KEY);
|
|
}
|
|
|
|
$accountID = $this->getCase($id)->account_id;
|
|
$module = 'accounts';
|
|
$queries = $this->getQueries($module, $accountID, $subpanel);
|
|
$parts = $queries[0];
|
|
$parts['select'] = 'SELECT COUNT(*) as value';
|
|
|
|
$dbQuery = $this->joinQueryParts($parts);
|
|
$result = $this->fetchRow($dbQuery);
|
|
$statistic = $this->buildSingleValueResponse(self::KEY, 'int', $result);
|
|
|
|
$this->close();
|
|
|
|
return $statistic;
|
|
}
|
|
|
|
/**
|
|
* @param string $id
|
|
* @return aCase|null
|
|
*/
|
|
protected function getCase(string $id): ?aCase
|
|
{
|
|
/** @var aCase $case */
|
|
$case = BeanFactory::getBean('Cases', $id);
|
|
|
|
if ($case === false) {
|
|
$case = null;
|
|
}
|
|
|
|
return $case;
|
|
}
|
|
|
|
/**
|
|
* @inheritDoc
|
|
*/
|
|
public function setLogger(LoggerInterface $logger): void
|
|
{
|
|
$this->logger = $logger;
|
|
}
|
|
}
|
