baoshi-was/app/Services/OwnerStoreFeeDetailService.php

<?php

namespace App\Services;

use App\OwnerFeeOperation;
use App\OwnerPriceOperation;
use App\Traits\ServiceAppAop;
use App\OwnerStoreFeeDetail;
use App\Traits\SettlementBillTrait;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;

class OwnerStoreFeeDetailService
{
    use ServiceAppAop;
    use \App\Traits\SettlementBillServiceTrait;

    const TYPE = '入库费-明细';

    protected $modelClass = OwnerStoreFeeDetail::class;

    public function get(array $kvPairs): \Illuminate\Contracts\Pagination\LengthAwarePaginator
    {
        return $this->getSql($kvPairs['counting_month'], $kvPairs['owner_id'])->paginate($kvPairs['paginateParams']['paginate'] ?? 50);
    }


    /**
     * @param $counting_month
     * @param $owner_id
     * @return Builder
     */
    public function getSql($counting_month, $owner_id): Builder
    {
        list($start, $end) = $this->getStartAndEnd($counting_month);

        $OwnerPriceOperationQuery = OwnerPriceOperation::query()
            ->select('id')
            ->where('operation_type', '入库');
        return OwnerFeeOperation::query()
            ->with(['details','model','commodity.barcodes'])
            ->whereIn('model_id', $OwnerPriceOperationQuery)
            ->whereBetween('worked_at', [$start, $end])
            ->where('owner_id', $owner_id);
    }

    public function buildExport($details): array
    {
        $results = [];
        foreach ($details as $detail) {
            $results[] = [
                $detail->ownerFeeDetail->worked_at ?? null,
                $detail->work_name ?? null,
                $detail->asn_code ?? null,
                $detail->sku ?? null,
                $detail->commodity->name ?? null,
                $detail->amount ?? null,
                $detail->unit_price ?? null,
                $detail->fee ?? null,
            ];
        }
        return $results;
    }
}