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

<?php

namespace App\Http\Controllers;

use App\Interfaces\SettlementBillControllerInterface;
use App\Owner;
use App\OwnerBillReport;
use App\OwnerBillReportArchive;
use App\Services\OwnerBillReportArchiveService;
use App\Services\OwnerSundryFeeDetailService;
use App\Traits\SettlementBillTrait;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Oursdreams\Export\Export;

class SettlementBillSundryFeeController extends Controller implements SettlementBillControllerInterface
{
    use SettlementBillTrait;

    /** @var OwnerBillReportArchiveService $archiveService */
    private $archiveService;

    /** @var OwnerSundryFeeDetailService $service */
    private $service;

    /**
     * OwnerSundryFeeDetailSettlementBillController constructor.
     */
    public function __construct()
    {
        $this->archiveService = app('OwnerBillReportArchiveService');
        $this->service = app('OwnerSundryFeeDetailService');
    }


    public function index(Request $request)
    {
        $paginateParams = $request->input();
        list($permittingOwnerIds, $counting_month, $owner_id) = $this->getRequestParams($request->year, $request->month, $request->owner_id);
        $owner_sundry_fee_details = $this->service->get([
            'counting_month' => $counting_month,
            'owner_id' => $owner_id,
            'paginateParams' => $paginateParams,
        ]);
        $owners = Owner::query()->selectRaw("id,name")->whereIn('id', $permittingOwnerIds)->get();
        $owner = Owner::query()->selectRaw("name,id")->find($owner_id);
        $isArchived = $this->archiveService->isArchived($counting_month, $owner_id, $this->service::TYPE);
        $request = $this->buildRequest($request, $counting_month,$owner_id);
        return view('finance.settlementBills.sundryFee.index', compact('owner_sundry_fee_details', 'paginateParams', 'owners', 'owner', 'request', 'isArchived'));
    }


    public function export(Request $request)
    {
        list($permittingOwnerIds, $counting_month, $owner_id) = $this->getRequestParams($request->year, $request->month, $request->owner_id);

        $query = $this->service->getSql($owner_id, $counting_month);
        if (!$request->exists('checkAllSign')) {
            $query->whereIn('id', explode(',', $request['data']));
        }
        $details = $query->get();
        $row = ['货主', '日期', '作业类型', '费用描述', '快递单号', '承运商', '数量', '单价', '收费金额', '备注'];
        $json = [];
        foreach ($details as $detail) {
            $json[] = [
                $detail->owner->name ?? '',
                $detail->created_at ?? '',
                $detail->type ?? '',
                $detail->fee_explain ?? '',
                $detail->logistic_name ?? '',
                $detail->logistic->name ?? '',
                $detail->amount ?? '',
                $detail->price ?? '',
                $detail->fee ?? '',
                $detail->remark ?? '',
            ];
        }
        return Export::make($row, $json, "杂项费");
    }
}