YetiForceCompany/YetiForceCRM

<?php
/* +**********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.1
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 * Contributor(s): YetiForce S.A.
 * ********************************************************************************** */

class HelpDesk_TicketsByStatus_Dashboard extends Vtiger_IndexAjax_View
{
    private $conditions = false;

    public function getSearchParams($value, $assignedto = '')
    {
        $listSearchParams = [];
        $conditionsArray = [['ticketstatus', 'e', $value]];
        if (!empty($assignedto)) {
            array_push($conditionsArray, ['assigned_user_id', 'e', $assignedto]);
        }
        $listSearchParams[] = $conditionsArray;
        return '&entityState=Active&viewname=All&search_params=' . json_encode($listSearchParams);
    }

    /**
     * Function returns Tickets grouped by Status.
     *
     * @param int $owner
     *
     * @return array
     */
    public function getTicketsByStatus($owner)
    {
        $moduleName = 'HelpDesk';
        $ticketStatus = Settings_SupportProcesses_Module_Model::getTicketStatusNotModify();
        $query = new \App\Db\Query();
        $query->select([
            'vtiger_troubletickets.priority',
            'vtiger_ticketpriorities.ticketpriorities_id',
            'count' => new \yii\db\Expression('COUNT(*)'),
            'statusvalue' => new \yii\db\Expression("CASE WHEN vtiger_troubletickets.status IS NULL OR vtiger_troubletickets.status = '' THEN '' ELSE vtiger_troubletickets.status END"), ])
            ->from('vtiger_troubletickets')
            ->innerJoin('vtiger_crmentity', 'vtiger_troubletickets.ticketid = vtiger_crmentity.crmid')
            ->innerJoin('vtiger_ticketstatus', 'vtiger_troubletickets.status = vtiger_ticketstatus.ticketstatus')
            ->innerJoin('vtiger_ticketpriorities', 'vtiger_troubletickets.priority = vtiger_ticketpriorities.ticketpriorities')
            ->where(['vtiger_crmentity.deleted' => 0]);

        if (!empty($owner)) {
            $query->andWhere(['smownerid' => $owner]);
        }
        if (!empty($ticketStatus)) {
            $query->andWhere(['not in', 'vtiger_troubletickets.status', $ticketStatus]);
            $this->conditions = ['condition' => ['not in', 'vtiger_troubletickets.status', $ticketStatus]];
        }
        \App\PrivilegeQuery::getConditions($query, $moduleName);
        $query->groupBy(['statusvalue', 'vtiger_troubletickets.priority', 'vtiger_ticketpriorities.ticketpriorities_id', 'vtiger_ticketstatus.sortorderid'])->orderBy('vtiger_ticketstatus.sortorderid');
        $dataReader = $query->createCommand()->query();
        $status = $priorities = $tickets = [];
        $counter = 0;
        $colors = \App\Fields\Picklist::getColors('ticketpriorities');
        $chartData = [
            'labels' => [],
            'datasets' => [],
            'show_chart' => false,
        ];
        while ($row = $dataReader->read()) {
            $tickets[$row['statusvalue']][$row['ticketpriorities_id']] = $row['count'];
            if (!\array_key_exists($row['ticketpriorities_id'], $priorities)) {
                $priorities[$row['ticketpriorities_id']] = ++$counter;
                // datasets stacked by priority (status is X, bar divided by priority)
                $chartData['datasets'][] = [
                    'data' => [],
                    'label' => \App\Language::translate($row['priority'], $moduleName),
                    'backgroundColor' => [],
                    'names' => [],
                    'links' => [],
                    '_priorityId' => $row['ticketpriorities_id'],
                ];
            }
            if (!\in_array($row['statusvalue'], $status)) {
                $status[] = $row['statusvalue'];
            }
        }
        $dataReader->close();
        if (!empty($tickets)) {
            $chartData['show_chart'] = true;
            foreach ($tickets as $status => $ticketValue) {
                foreach ($priorities as $priorityId => $priorityValue) {
                    if (isset($ticketValue[$priorityId])) {
                        $value = $ticketValue[$priorityId];
                    } else {
                        $value = 0;
                    }
                    foreach ($chartData['datasets'] as &$dataset) {
                        if ($dataset['_priorityId'] === $priorityId) {
                            $dataset['data'][] = $value;
                            $dataset['names'][] = $status;
                            $dataset['backgroundColor'][] = $colors[$priorityId];
                            break;
                        }
                    }
                }
                $chartData['labels'][] = App\Language::translate($status, $moduleName);
            }
        }
        return $chartData;
    }

    public function process(App\Request $request)
    {
        $viewer = $this->getViewer($request);
        $moduleName = $request->getModule();
        $widget = Vtiger_Widget_Model::getInstance($request->getInteger('linkid'), \App\User::getCurrentUserId());
        if (!$request->has('owner')) {
            $owner = Settings_WidgetsManagement_Module_Model::getDefaultUserId($widget, $moduleName);
        } else {
            $owner = $request->getByType('owner', 2);
        }
        $ownerForwarded = $owner;
        if ('all' == $owner) {
            $owner = '';
        }
        $data = (false === $owner) ? [] : $this->getTicketsByStatus($owner);
        $listViewUrl = Vtiger_Module_Model::getInstance($moduleName)->getListViewUrl();
        foreach ($data['datasets'] as &$dataset) {
            foreach ($dataset['names'] as $name) {
                $dataset['links'][] = $listViewUrl . $this->getSearchParams($name, $owner);
            }
        }
        $viewer->assign('USER_CONDITIONS', $this->conditions);
        $viewer->assign('WIDGET', $widget);
        $viewer->assign('MODULE_NAME', $moduleName);
        $viewer->assign('DATA', $data);
        $viewer->assign('OWNER', $ownerForwarded);
        if ($request->has('content')) {
            $viewer->view('dashboards/DashBoardWidgetContents.tpl', $moduleName);
        } else {
            $viewer->view('dashboards/TicketsByStatus.tpl', $moduleName);
        }
    }
}