autocde2.0/app/Http/Resources/API/AssetReportResource.php

<?php
/**
 * Created by IntelliJ IDEA.
 * User: kelyliang
 * Date: 2024/3/4
 * Time: 下午 03:09
 */

namespace App\Http\Resources\API;

use App\Models\Asset;
use App\Models\AssetGroup;
use App\Models\Requirement;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Http\Resources\Json\JsonResource;
use Illuminate\Support\Facades\Auth;
use function Nette\Utils\data;

class AssetReportResource  extends JsonResource
{
    public function toArray(Request $request): array
    {
        $now = Carbon::now();
        return[
            'requirement_total' => Requirement::query()->whereIn('asset_id',$this->child_id)->count(),
            'plan_total' => $this->plans()->count(),
            'project_total' => $this->projects()->count(),
            'plan_unexpired_total' => $planTotalCount = $this->plans()->where('begin', '<=', $now)
                ->where('end', '>=', $now)
                ->get()
                ->count(),
            'project_unexpired_total' => $planTotalCount = $this->projects()->where('begin', '<=', $now)
                ->where('end', '>=', $now)
                ->get()
                ->count(),
            'asset_total'=>Asset::query()->where('company_id',Auth::user()->company_id)->where('parent_id',0)->count(),
            'asset_closed_total'=>Asset::query()->where('company_id',Auth::user()->company_id)->where('parent_id',0)->where('status','closed')->count(),
            'id' => $this->id,
            'name' => $this->name,
            'code' => $this->code,
            'description' => $this->description?(new \App\Services\File\ImageUrlService)->getImageUrl($this->description):null,
            'status' => $this->status,
            'created_by' =>new UserProfileResource($this->createdBy),
            'owner' => new UserProfileResource($this->byOwner),
            'address' => $this->address,
            'group_id' => new AssetGroupResource($this->assetGroup),
            'geo_address_code' => $this->geo_address_code,
            'acl' => $this->acl,
            'latitude' => $this->latitude,
            'longitude' => $this->longitude,
            'parent_id' => new AssetResource($this->parent),
            'created_at' => date('Y-m-d',$this->created_at->timestamp)
        ];
    }
}