baoshi-was/app/Http/Controllers/OrderIssuePerformanceController.php

<?php

namespace App\Http\Controllers;

use App\Services\OrderIssuePerformanceService;
use App\Services\OrderIssueWorkLoadService;
use Illuminate\Http\Request;
use Exception;
use Illuminate\Support\Facades\Gate;
use Illuminate\Support\Facades\Http;
use Oursdreams\Export\Export;

class OrderIssuePerformanceController extends Controller
{

    public function __construct()
    {
        app()->singleton('OrderIssueWorkLoadService', OrderIssueWorkLoadService::class);
        app()->singleton('service', OrderIssuePerformanceService::class);
    }

    public function index(Request $request)
    {
        if (!Gate::allows('订单管理-问题件-绩效统计')) {
            return redirect(url('/'));
        }
        /** @var OrderIssuePerformanceService $service */
        $service = app('OrderIssuePerformanceService');
        $performance = $service->paginate($request->all());
        $options = ['timeFrame' => $request->input('timeFrame'), 'create_start' => $request->input('create_start') ?? '', 'create_end' => $request->input('create_end') ?? ''];
        return view('order.issue.performance', compact('performance', 'options'));
    }

    public function export(Request $request)
    {
        /** @var OrderIssuePerformanceService  $orderIssuePerformanceService */
        $orderIssuePerformanceService = app(OrderIssuePerformanceService::class);
        $sql = $orderIssuePerformanceService->getSql($request->all());

        $e = new Export();
        $e->setMysqlConnection(config('database.connections.mysql.host'),
            config('database.connections.mysql.port'),config('database.connections.mysql.database')
            ,config('database.connections.mysql.username'),config('database.connections.mysql.password'));
        $e->setFileName("客服绩效");
        return $e->sql($sql,[
            "userName"=>"客服","ownerName"=>"客户",
            "created"=>"创建数","process"=>"处理数",
            "end"=>"完结数","sumNumber"=>"总数",
        ])->direct();
    }

    public function workLoadPage(Request $request)
    {
        if (!Gate::allows('订单管理-问题件-工作量')) {
            return redirect(url('/'));
        }
        /** @var OrderIssueWorkLoadService $workLoadService */
        $workLoadService = app('OrderIssueWorkLoadService');
        $workLoads = $workLoadService->paginate($request->all());
        $users = $workLoadService->getUsers();
        $owners = $workLoadService->getOwners();
        $options =$workLoadService->getOptions($request->all());
        return view('order/issue/workload', compact('workLoads', 'owners', 'users','options'));
    }

    public function exportWorkLoad(Request $request)
    {
        $workLoadService = app('OrderIssueWorkLoadService');
        return $workLoadService->exportWorkLoad($request->all());
    }
}