kknongchang_2506/app/Module/Point/AdminControllers/PointDashboardController.php

<?php

namespace App\Module\Point\AdminControllers;

use App\Module\Point\Models\PointModel;
use App\Module\Point\Models\PointLogModel;
use App\Module\Point\Models\PointAdminModel;
use App\Module\Point\Models\PointCirculationModel;
use App\Module\Point\Models\PointTransferModel;
use App\Module\Point\Models\PointOrderModel;
use Dcat\Admin\Layout\Content;
use Dcat\Admin\Widgets\Card;

use Spatie\RouteAttributes\Attributes\Get;
use UCore\DcatAdmin\AdminController;

/**
 * 种植点数统计仪表板控制器
 *
 * 路由: /admin/point/dashboard
 * 菜单: 积分管理 -> 统计仪表板
 * 功能: 展示种植点数系统的统计数据和分析图表
 */
class PointDashboardController extends AdminController
{
    /**
     * 页面标题
     */
    protected $title = '种植点数统计仪表板';

    /**
     * 仪表板页面
     */
    #[Get('point/dashboard', name: 'admin.point.dashboard.index')]
    public function index(Content $content)
    {
        return $content
            ->title($this->title)
            ->description('积分系统数据统计')
            ->body($this->overview())
            ->body($this->pointTypeStats())
            ->body($this->recentActivity());
    }

    /**
     * 概览统计
     */
    protected function overview()
    {
        // 基础统计
        $totalAccounts = PointModel::count();
        $totalLogs = PointLogModel::count();
        $totalAdminOps = PointAdminModel::count();
        $totalCirculations = PointCirculationModel::count();
        $totalTransfers = PointTransferModel::count();
        $totalOrders = PointOrderModel::count();

        // 今日统计
        $todayStart = strtotime('today');
        $todayLogs = PointLogModel::where('create_time', '>=', $todayStart)->count();
        $todayAdminOps = PointAdminModel::where('create_time', '>=', $todayStart)->count();

        $content = '
        <div class="row">
            <div class="col-lg-3 col-6">
                <div class="small-box bg-info">
                    <div class="inner">
                        <h3>' . $totalAccounts . '</h3>
                        <p>积分账户总数</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-users"></i>
                    </div>
                    <a href="' . route('dcat.admin.point.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
            <div class="col-lg-3 col-6">
                <div class="small-box bg-success">
                    <div class="inner">
                        <h3>' . $totalLogs . '</h3>
                        <p>积分日志总数</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-file-text-o"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-log.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
            <div class="col-lg-3 col-6">
                <div class="small-box bg-warning">
                    <div class="inner">
                        <h3>' . $totalAdminOps . '</h3>
                        <p>管理员操作</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-cog"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-admin.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
            <div class="col-lg-3 col-6">
                <div class="small-box bg-danger">
                    <div class="inner">
                        <h3>' . $todayLogs . '</h3>
                        <p>今日日志</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-calendar"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-log.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-lg-4 col-6">
                <div class="small-box bg-primary">
                    <div class="inner">
                        <h3>' . $totalCirculations . '</h3>
                        <p>点数流转总数</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-exchange"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-circulation.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
            <div class="col-lg-4 col-6">
                <div class="small-box bg-secondary">
                    <div class="inner">
                        <h3>' . $totalTransfers . '</h3>
                        <p>积分转账总数</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-send"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-transfer.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
            <div class="col-lg-4 col-6">
                <div class="small-box bg-dark">
                    <div class="inner">
                        <h3>' . $totalOrders . '</h3>
                        <p>积分订单总数</p>
                    </div>
                    <div class="icon">
                        <i class="fa fa-shopping-cart"></i>
                    </div>
                    <a href="' . route('dcat.admin.point-order.index') . '" class="small-box-footer">
                        查看详情 <i class="fa fa-arrow-circle-right"></i>
                    </a>
                </div>
            </div>
        </div>';

        return new Card('Point模块统计仪表板', $content);
    }

    /**
     * 积分类型统计
     */
    protected function pointTypeStats()
    {
        // 直接查询积分统计数据
        $stats = PointModel::selectRaw('point_id, COUNT(*) as user_count, SUM(balance) as total_balance, AVG(balance) as avg_balance')
            ->groupBy('point_id')
            ->get()
            ->toArray();

        $pointTypes = [
            1 => '经验积分',
            2 => '成就积分',
            3 => '活动积分',
            4 => '签到积分',
            5 => '推荐积分',
        ];

        $html = '<div class="row">';

        foreach ($stats as $stat) {
            $pointId = $stat['point_id'];
            $typeName = $pointTypes[$pointId] ?? "积分{$pointId}";
            $userCount = $stat['user_count'];
            $totalBalance = number_format($stat['total_balance']);
            $avgBalance = number_format($stat['avg_balance'], 2);

            $html .= "
                <div class='col-md-4'>
                    <div class='info-box'>
                        <span class='info-box-icon bg-blue'><i class='fa fa-star'></i></span>
                        <div class='info-box-content'>
                            <span class='info-box-text'>{$typeName}</span>
                            <span class='info-box-number'>{$userCount} 用户</span>
                            <div class='progress'>
                                <div class='progress-bar' style='width: 70%'></div>
                            </div>
                            <span class='progress-description'>
                                总积分: {$totalBalance} | 平均: {$avgBalance}
                            </span>
                        </div>
                    </div>
                </div>
            ";
        }

        $html .= '</div>';

        return new Card('积分类型统计', $html);
    }

    /**
     * 最近活动
     */
    protected function recentActivity()
    {
        $recentLogs = PointLogModel::orderBy('create_time', 'desc')
            ->limit(10)
            ->get();

        $pointTypes = [
            1 => '经验积分',
            2 => '成就积分',
            3 => '活动积分',
            4 => '签到积分',
            5 => '推荐积分',
        ];

        $html = '<div class="table-responsive"><table class="table table-striped">';
        $html .= '<thead><tr><th>时间</th><th>用户</th><th>积分类型</th><th>变更</th><th>备注</th></tr></thead>';
        $html .= '<tbody>';

        foreach ($recentLogs as $log) {
            $time = date('m-d H:i', $log->create_time);
            $pointType = $pointTypes[$log->point_id->value] ?? "积分{$log->point_id->value}";
            $amount = $log->amount > 0 ? "+{$log->amount}" : $log->amount;
            $amountClass = $log->amount > 0 ? 'text-success' : 'text-danger';
            $remark = mb_substr($log->remark, 0, 20) . (mb_strlen($log->remark) > 20 ? '...' : '');

            $html .= "
                <tr>
                    <td>{$time}</td>
                    <td>用户{$log->user_id}</td>
                    <td>{$pointType}</td>
                    <td class='{$amountClass}'>{$amount}</td>
                    <td>{$remark}</td>
                </tr>
            ";
        }

        $html .= '</tbody></table></div>';

        return new Card('最近活动', $html);
    }
}