community-manage/app/Http/Controllers/Behavior/RegisteredRecordController.php

<?php

namespace App\Http\Controllers\Behavior;

use App\Http\Controllers\Controller;
use App\Models\Behavior;
use App\Models\RegisteredRecord;
use App\Repositories\Behavior\RegisteredRecordRepository;
use App\Transformers\Behavior\RegisteredRecordTransformer;
use League\Fractal\Manager;
use League\Fractal\Pagination\IlluminatePaginatorAdapter;
use League\Fractal\Resource\Collection;
use Illuminate\Http\Request;

/**
 * Created by PhpStorm.
 * User: durong
 * Date: 2019/6/14
 * Time: 上午11:30
 */
class RegisteredRecordController extends Controller
{
    public function __construct(RegisteredRecordRepository $registeredRecordRepository)
    {
        $this->registeredRecordRepository = $registeredRecordRepository;
    }

    /**
     * 新用户注册账本列表
     */
    public function index(Request $request)
    {
        $registeredList = $this->registeredRecordRepository->lists($request->all());

        $behavior_absolute_progression = Behavior::select('absolute_progression')->where('behavior_identification', 'register')->first();//行为绝对级数
        $behavior_trigger_times = RegisteredRecord::select('trigger_type')->where('trigger_type', '!=', null)->count();//总触发数
        $behavior_effective_trigger = RegisteredRecord::select('trigger_type')->where('trigger_type', 1)->count();//有效触发数
        $physical_exertion = RegisteredRecord::select('physical_exertion')->sum('physical_exertion');//总消耗体力值
        $generation_quantity = RegisteredRecord::select('generation_quantity')->sum('generation_quantity');//总生成U米
        $quantity_issued = RegisteredRecord::select('quantity_issued')->sum('quantity_issued');//总发放U米

        $fractal = new Manager();
        $resource = new Collection($registeredList, new RegisteredRecordTransformer());
        $resource->setPaginator(new IlluminatePaginatorAdapter($registeredList));
        $data = $fractal->createData($resource)->toArray();
        $data['extra'] = [
            'statistics' => [
                'all_absolute_progression' => $behavior_absolute_progression->absolute_progression ?? 0,
                'all_trigger_times' => $behavior_trigger_times,
                'all_effective_trigger' => $behavior_effective_trigger,
                'physical_exertion' => intval($physical_exertion),
                'generation_quantity' => intval($generation_quantity),
                'quantity_issued' => intval($quantity_issued)
            ],
            'filters' => [
                'id',
                'uid',
                'created_at',
                'absolute_progression',
                'trigger_type',
                'virus_behavior_id',
                'superior_uid'
            ],
            'columns' => [
                'id',
                'created_at',
                'uid',
                'physical_exertion',
                'trigger_type',
                'generation_type',
                'absolute_progression',
                'superior_uid',
                'release_status',
                'generation_quantity',
                'quantity_issued',
            ]
        ];
        return $data;
    }
}