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) ]; } }