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

<?php
namespace App\Http\Controllers\Behavior;
use App\Http\Controllers\Controller;
use App\Models\CommentRecord;
use App\Repositories\Behavior\CommentRecordRepository;
use App\Transformers\Behavior\CommentRecordTransformer;
use Illuminate\Http\Request;
use League\Fractal\Manager;
use League\Fractal\Pagination\IlluminatePaginatorAdapter;
use League\Fractal\Resource\Collection;
/**
 * Created by PhpStorm.
 * User: durong
 * Date: 2019/6/14
 * Time: 下午6:06
 */

class CommentRecordController extends Controller
{
    public function __construct(CommentRecordRepository $commentRecordRepository)
    {
        $this->commentRecordRepository = $commentRecordRepository;
    }

    /**
     * 评论账本列表
     */
    public function index(Request $request)
    {
        $commentList = $this->commentRecordRepository->lists($request->all());

        $behavior_trigger_times = 0;
        $behavior_effective_trigger = 0;
        $physical_exertion = 0;
        $generation_quantity = 0;
        $quantity_issued = 0;
        if (count($commentList)>0) {
            $behavior_trigger_times = CommentRecord::select('trigger_type')->where('trigger_type', '!=', null)->count();//总触发数
            $behavior_effective_trigger = CommentRecord::select('trigger_type')->where('trigger_type', 1)->count();//有效触发数
            $physical_exertion = CommentRecord::select('physical_exertion')->sum('physical_exertion');//总消耗体力值
            $generation_quantity = CommentRecord::select('generation_quantity')->sum('generation_quantity');//总生成彩虹豆
            $quantity_issued = CommentRecord::select('quantity_issued')->sum('quantity_issued');//总发放彩虹豆
        }
        $fractal = new Manager();
        $resource = new Collection($commentList, new CommentRecordTransformer());
        $resource->setPaginator(new IlluminatePaginatorAdapter($commentList));
        $data = $fractal->createData($resource)->toArray();
        $data['extra'] = [
            'statistics' => [
                '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',
                'trigger_type',
                'content_author_id',
                'related_content_id',
                'superior_commentator_id',
                'virus_behavior_id'
            ],
            'columns' => [
                'id',
                'created_at',
                'virus_behavior_id',
                'uid',
                'upper_trigger_time',
                'related_content_id',
                'content_author_id',
                'superior_commentator_id',
                'physical_exertion',
                'trigger_type',
                'generation_type',
                'absolute_progression',
                'superior_uid',
                'release_status',
                'generation_quantity',
                'quantity_issued',
                'current_comment_id',
                'superior_comment_id',
                'behavior_cycle_type',
                'name',
                'relative_series',
                'is_open',
                'bahavior_created_at'
            ]
        ];
        return $data;
    }
}