nongchang
/
kknongchang_2506


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159
							<?php

namespace App\Module\GameItems\AdminControllers\Metrics;

use UCore\DcatAdmin\Metrics\Examples\NewUsers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Module\GameItems\Models\ItemTransactionLog;

/**
 * 果实每日产出折线图
 * 显示各种果实的每日产出数量趋势
 */
class FruitDailyOutputChart extends NewUsers
{
    /**
     * 果实物品ID映射
     */
    protected $fruitItems = [
        2 => '萝卜',
        3 => '辣椒', 
        4 => '苹果',
        5 => '西瓜',
        6 => '草莓',
        7 => '南瓜',
        8 => '核桃',
        9 => '可可',
        10 => '人参',
        11 => '玫瑰',
    ];

    /**
     * 初始化卡片内容
     */
    protected function init()
    {
        parent::init();

        $this->title('果实每日产出趋势');
        $this->dropdown([
            '7' => '最近 7 天',
            '14' => '最近 14 天',
            '30' => '最近 30 天',
            '90' => '最近 90 天',
        ]);
    }

    /**
     * 处理请求
     *
     * @param Request $request
     * @return mixed|void
     */
    public function handle(Request $request)
    {
        $days = (int)$request->get('option', 7);
        $chartData = $this->getFruitOutputData($days);
        
        // 计算总产出数量作为卡片内容
        $totalOutput = array_sum(array_map('array_sum', $chartData['data']));
        
        // 卡片内容
        $this->withContent(number_format($totalOutput));
        
        // 图表数据
        $this->withChart($chartData['series'], $chartData['categories']);
    }

    /**
     * 获取果实产出数据
     *
     * @param int $days
     * @return array
     */
    protected function getFruitOutputData($days)
    {
        // 生成日期范围
        $dates = [];
        for ($i = $days - 1; $i >= 0; $i--) {
            $dates[] = now()->subDays($i)->format('Y-m-d');
        }

        // 查询每日产出数据
        $outputData = ItemTransactionLog::select([
                'item_id',
                DB::raw('DATE(created_at) as date'),
                DB::raw('SUM(quantity) as daily_output')
            ])
            ->whereIn('item_id', array_keys($this->fruitItems))
            ->where('transaction_type', 1) // 获取类型
            ->where('created_at', '>=', now()->subDays($days))
            ->groupBy('item_id', DB::raw('DATE(created_at)'))
            ->get()
            ->groupBy('item_id');

        // 构建图表数据
        $series = [];
        $data = [];
        
        foreach ($this->fruitItems as $itemId => $itemName) {
            $itemData = [];
            $itemOutputs = $outputData->get($itemId, collect());
            
            foreach ($dates as $date) {
                $dayOutput = $itemOutputs->where('date', $date)->first();
                $quantity = $dayOutput ? (int)$dayOutput->daily_output : 0;
                $itemData[] = $quantity;
            }
            
            $series[] = [
                'name' => $itemName,
                'data' => $itemData,
            ];
            
            $data[$itemId] = $itemData;
        }

        return [
            'series' => $series,
            'categories' => $dates,
            'data' => $data,
        ];
    }

    /**
     * 设置图表数据
     *
     * @param array $series
     * @param array $categories
     * @return $this
     */
    public function withChart(array $series, array $categories = [])
    {
        return $this->chart([
            'series' => $series,
            'xaxis' => [
                'categories' => $categories,
            ],
        ]);
    }

    /**
     * 设置卡片内容
     *
     * @param string $content
     * @return $this
     */
    public function withContent($content)
    {
        return $this->content(
            <<<HTML
<div class="d-flex justify-content-between align-items-center mt-1" style="margin-bottom: 2px">
    <h2 class="ml-1 font-lg-1">{$content}</h2>
    <span class="mb-0 mr-1 text-80">总产出数量</span>
</div>
HTML
        );
    }
}