Fabrica\Http\Api\AccessLogsController

Complexity

Total Complexity

37

Size/Duplication

Total Lines	137
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
F	index()	0	79	25
C	export()	0	43	12

<?php

namespace Fabrica\Http\Api;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Event;

use Fabrica\Http\Requests;
use Fabrica\Http\Api\Controller;

use Fabrica\System\Eloquent\ApiAccessLogs;
use Maatwebsite\Excel\Facades\Excel;

class AccessLogsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        ini_set('memory_limit', '-1');
        ini_set('max_execution_time', '0');

        $query = ApiAccessLogs::query();

        $uid = $request->input('uid');
        if (isset($uid) && $uid) {
            $query = $query->where('user.id', $uid);
        }

        $method = $request->input('method');
        if (isset($method) && $method) {
            $query = $query->where('request_method', $method);
        }

        $project_key = $request->input('project_key');
        if (isset($project_key) && $project_key) {
            $query = $query->where('project_key', $project_key);
        }

        $module = $request->input('module');
        if (isset($module) && $module) {
            $query = $query->where('module', $module);
        }

        $request_time = $request->input('request_time');
        if (isset($request_time) && $request_time) {
            if (strpos($request_time, '~') !== false) {
                $sections = explode('~', $request_time);
                if ($sections[0]) {
                    $query->where('requested_start_at', '>=', strtotime($sections[0]) * 1000);
                }
                if ($sections[1]) {
                    $query->where('requested_start_at', '<=', strtotime($sections[1] . ' 23:59:59') * 1000);
                }
            }
        }

        $url = $request->input('request_url');
        if (isset($url) && $url) {
            $query->where('request_url', 'like', '%' . $url . '%');
        }

        $request_source_ip = $request->input('request_source_ip');
        if (isset($request_source_ip) && $request_source_ip) {
            $query->where('request_source_ip', $request_source_ip);
        }

        $exec_time = $request->input('exec_time');
        if (isset($exec_time) && $exec_time) {
            $flag = substr($exec_time, 0, 1);
            if ($flag == '-') {
                $query->where('exec_time', '<=', abs(floatval($exec_time)) * 1000);
            }
            else
            {
                $query->where('exec_time', '>=', abs(floatval($exec_time)) * 1000);
            }
        }

        // get total
        $total = $query->count();
        $query->orderBy('_id', 'desc');
        $page_size = $request->input('limit') ? intval($request->input('limit')) : 100;
        $page = $request->input('page') ?: 1;
        $query = $query->skip($page_size * ($page - 1))->take($page_size);

        $logs = $query->get();

        $from = $request->input('from');
        if (isset($from) && $from == 'export') {
            $this->export($logs);
            exit();
        }

        return response()->json([ 'ecode' => 0, 'data' => $logs, 'options' => [ 'total' => $total, 'sizePerPage' => $page_size ] ]);

The method json does only exist in Illuminate\Contracts\Routing\ResponseFactory, but not in Illuminate\Http\Response.

    }

    /**
     * export xls for access logs
     *
     * @param  array $issues

There is no parameter named $issues. Was it maybe removed?

     * @return void
     */
    public function export($logs)
    {
        set_time_limit(0);

        $headers = [ 
            '用户', 
            '方法', 
            'Url', 
            '模块', 
            '请求开始时间', 
            '请求结束时间', 
            '请求时长(毫秒)', 
            '来源IP', 
            'User-Agent', 
            'Body' 
        ];

        $file_name = 'access-logs';
        Excel::create(
            $file_name, function ($excel) use ($headers, $logs) {
                $excel->sheet(
                    'Sheetname', function ($sheet) use ($headers, $logs) {
                        $sheet->appendRow($headers);
                        foreach ($logs as $log)
                        {
                            $tmp = [];
                            $tmp[] = $log->user ? $log->user['name'] : '';
                            $tmp[] = $log->request_method ?: '';
                            $tmp[] = $log->request_url ?: '';
                            $tmp[] = $log->module ?: '';
                            $tmp[] = $log->requested_start_at ? date('Y-m-d h:i:s', intval($log->requested_start_at / 1000)): '';
                            $tmp[] = $log->requested_end_at ? date('Y-m-d h:i:s', intval($log->requested_end_at / 1000)) : '';
                            $tmp[] = $log->exec_time ?: '';
                            $tmp[] = $log->request_source_ip ?: '';
                            $tmp[] = $log->request_user_agent ?: '';
                            $tmp[] = $log->request_body ? json_encode($log->request_body) : '';
                            $sheet->appendRow($tmp);
                        }
                    }
                );
            }
        )->download('xls');
    }
}