baoshi-was/app/Services/OwnerStoreOutFeeDetailService.php

<?php

namespace App\Services;

use App\Interfaces\SettlementBillDetailInterface;
use App\OwnerFeeDetail;
use App\Traits\ServiceAppAop;
use App\OwnerStoreOutFeeDetail;
use App\Traits\SettlementBillServiceTrait;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;

class OwnerStoreOutFeeDetailService implements SettlementBillDetailInterface
{
    const  TYPE = '出库费-明细';
    use ServiceAppAop;
    use SettlementBillServiceTrait;


    protected $modelClass = OwnerStoreOutFeeDetail::class;

    /**
     * 详情的查询不管是否却认都是原始数据且分页
     * @param array $kvPairs
     * @return LengthAwarePaginator
     */
    public function get(array $kvPairs): LengthAwarePaginator
    {
        return $this->getSql($kvPairs['owner_id'], $kvPairs['counting_month'])->paginate($kvPairs['paginateParams']['paginate'] ?? 50);
    }

    public function getSql($owner_id, $counting_month): Builder
    {
        list($start, $end) = $this->getStartAndEnd($counting_month);
        return OwnerStoreOutFeeDetail::query()
            ->with([
                'commodity:id,name,sku',
                'ownerFeeDetail:id,worked_at,operation_bill,work_fee',
                'ownerPriceOperation.items.unit',
            ])
            ->where('owner_id', $owner_id)
            ->whereBetween('created_at', [$start, $end]);
    }

    public function switchType($type)
    {
        // TODO: Implement switchType() method.
    }

    public function buildExport($details): array
    {
        $result = [];

        foreach ($details as $detail) {
            $result[] = [
                $detail->ownerFeeDetail->worked_at,
                $detail->ownerPriceOperation->name ?? '',
                $detail->source_bill,
                $detail->ownerFeeDetail->operation_bill,
                $detail->commodity->sku,
                $detail->commodity->name,
                $detail->amount,
                $detail->price_remark,
                $detail->ownerFeeDetail->work_fee,
            ];
        }
        return $result;
    }

    public function add(array $model)
    {
        // TODO: Implement add() method.
    }

    /**
     * 查询指定货主 月份 按照货主 计费模型汇总的 作业费（出入库费）和税费
     * @param $owner_id
     * @param $counting_month
     * @return Builder[]|Collection
     */
    public function getTotalFee($owner_id, $counting_month)
    {
       list($start, $end) = $this->getStartAndEnd($counting_month);
        return OwnerFeeDetail::query()
            ->selectRaw("owner_price_operation_id,
            sum(work_fee) as work_fee,
            sum(work_tax_fee) as work_tax_fee
             ")
            ->where('owner_id', $owner_id)
            ->whereBetween('created_at', [$start, $end])
            ->groupBy('owner_id', 'owner_price_operation_id')
            ->get();
    }

}