# fluent-support/1.4.2/app/Modules/StatModule.php

Fluent Support – Helpdesk & Customer Support Ticket System, version 1.4.2. 133 lines.

- Page: https://pluginprobe.com/plugins/fluent-support/1.4.2/code/app/Modules/StatModule.php
- Raw: https://pluginprobe.com/plugins/fluent-support/1.4.2/raw/app/Modules/StatModule.php
- Modified: 2021-11-12T14:57:38+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/fluent-support/1.4.2/code/app/Modules/StatModule.php#L10-L20`.

```php
<?php

namespace FluentSupport\App\Modules;

use FluentSupport\App\Models\Conversation;
use FluentSupport\App\Models\Ticket;

class StatModule
{
    public static function getAgentStat($agentId, $startDate = false, $endDate = false)
    {
        if (!$startDate) {
            $currentDate = current_time('mysql');
            $startDate = $currentDate;
            $endDate = $currentDate;
        }

        $startDate = date('Y-m-d 00:00.01', strtotime($startDate));
        $endDate = date('Y-m-d 23:59.59', strtotime($endDate));

        $newTickets = Ticket::where('agent_id', $agentId)
            ->where('status', 'new')
            ->count();

        $activeTickets = Ticket::where('agent_id', $agentId)
            ->where('status', 'active')
            ->count();

        $closedTickets = Ticket::where('agent_id', $agentId)
            ->where('status', 'closed')
            ->whereBetween('resolved_at', [$startDate, $endDate])
            ->count();

        $responses = Conversation::where('conversation_type', 'response')
            ->where('person_id', $agentId)
            ->whereBetween('created_at', [$startDate, $endDate])
            ->count();

        $interactions = Conversation::where('person_id', $agentId)
            ->where('conversation_type', 'response')
            ->whereBetween('created_at', [$startDate, $endDate])
            ->groupBy('ticket_id')
            ->get()
            ->count();

        return [
            'new_tickets'    => [
                'title' => 'New Tickets',
                'count' => $newTickets
            ],
            'active_tickets' => [
                'title' => 'Active Tickets',
                'count' => $activeTickets
            ],
            'closed_tickets' => [
                'title' => 'Closed Tickets',
                'count' => $closedTickets
            ],
            'responses'      => [
                'title' => 'Responses',
                'count' => $responses
            ],
            'interactions'  =>[
                'title' =>'Interactions',
                'count' => $interactions
            ]
        ];
    }

    public static function getOverAllStats()
    {
        $newTickets = Ticket::where('status', 'new')
            ->count();

        $activeTickets = Ticket::where('status', 'active')
            ->count();

        $closedTickets = Ticket::where('status', 'closed')
            ->count();

        $responses = Conversation::where('conversation_type', 'response')
            ->count();

        return [
            'new_tickets'    => [
                'title' => 'New Tickets',
                'count' => $newTickets
            ],
            'active_tickets' => [
                'title' => 'Active Tickets',
                'count' => $activeTickets
            ],
            'closed_tickets' => [
                'title' => 'Closed Tickets',
                'count' => $closedTickets
            ],
            'responses'      => [
                'title' => 'Responses',
                'count' => $responses
            ]
        ];
    }

    public static function getAgentOverallStats($agentId)
    {
        $replies_count = Conversation::where('person_id', $agentId)->count();

        $interactions_count = Conversation::where('person_id', $agentId)
                                ->where('conversation_type', 'response')
                                ->groupBy('ticket_id')
                                ->get()
                                ->count();

        $total_closed = Ticket::where('agent_id', $agentId)->where('status', 'closed')->count();

        return [
            'replies_count' =>  [
                'title' => 'Total Replies',
                'count' => $replies_count
            ],
            'interactions_count' => [
                'title' => 'Total Interactions',
                'count' => $interactions_count
            ],
            'total_closed' => [
                'title' => 'Total Closed',
                'count' => $total_closed
            ]
        ];
    }

}

```