Scout Database Search Engine

[MathiasWeisheit]

• Laravel Version: 9.11
• PHP Version: 8.0.13
• Database Driver & Version:

Description:

Hi, Im using meilisearch and Database search at the same time to improve my results.
In my toSearchableArray function I add some virtual attributes to collect data from realationships.
So meilisearch searches within. That's fine.
But if I use the Database engine with the same toSearchableArray it will fail, because these colums does not exist at the database.
This is because the function buildSearchQuery of DatabaseEngine.php only uses the keys of the array. array_keys($builder->model->toSearchableArray())

Is it possible that reduce this keys to the shema-columns?

My current workaround:
I added a public varibale extendSearchableArray to the model.
With this variable I control the toSearchableArray function.

Constoller

			$results = Profile::search($query)->get();
			if (empty($results) || $results->count() < 1) {
				$databaseSearchEngine = new DatabaseEngine();
				$sProfile = new Profile();
				$sProfile->extendSearchableArray = false;
				$builder = app(Builder::class, [
					'model' => $sProfile,
					'query' => $query,
					'callback' => null,
					'softDelete'=> false,
				]);
				$resultsDB = $databaseSearchEngine->search($builder);
				if (!empty($resultsDB)){
					$results = $resultsDB['results'];
				}
			}
			$recordRessourceCollection = $this->processResults($results, $request, $profiles);

Model

public $extendSearchableArray = true;
	/**
	* laravel scout
	 * Get the indexable data array for the model.
	 *
	 * @return array
	 */
	public function toSearchableArray()
	{
		//$array = $this->toArray();
		$searchArray = [
			'first_name' => $this->first_name,
			'last_name' => $this->last_name,
			'academic_title' => $this->academic_title,
			'nickname' => $this->nickname,
			'pronunciation' => $this->pronunciation,
			'company' => $this->company,
			'role' => $this->role,
			'email' => $this->email,
			'office_phone' => $this->office_phone,
			'cell_phone' => $this->cell_phone,
			'fax' => $this->fax,
			'about' => $this->about,
			'website_url' => $this->website_url,
			'twitter_url' => $this->twitter_url,
			'facebook_url' => $this->facebook_url,
			'instagram_url' => $this->instagram_url,
			'linkedin_url' => $this->linkedin_url,
			'xing_url' => $this->xing_url,
			'expertise' => $this->expertise,
			'accreditations' => $this->accreditations,
			'consulting_focus_other' => $this->consulting_focus_other,
			'industry_expertise_other' => $this->industry_expertise_other
		];

		if ($this->extendSearchableArray === true) {
			$consulting_focus_coll = $this->getKeywords('consulting_focus');
			$consulting_focus = "";
			if (!empty($consulting_focus_coll) && $consulting_focus_coll->count()>0) {
				$consulting_focus = $consulting_focus_coll->reduce(function ($carry, $item) {
					return trim($carry . ' ' . $item->caption);
				});
			}
			$searchArray['consulting_focus'] = $consulting_focus;

			$client_group_coll = $this->getKeywords('client_group');
			$client_group = "";
			if (!empty($client_group_coll) && $client_group_coll->count()>0) {
				$client_group = $client_group_coll->reduce(function ($carry, $item) {
					return trim($carry . ' ' . $item->caption);
				});
			}
			$searchArray['client_group'] = $client_group;

			$industry_expertise_coll = $this->getKeywords('industry_expertise');
			$industry_expertise = "";
			if (!empty($industry_expertise_coll) && $industry_expertise_coll->count()>0) {
				$industry_expertise = $industry_expertise_coll->reduce(function ($carry, $item) {
					return trim($carry . ' ' . $item->caption);
				});
			}
			$searchArray['industry_expertise'] = $industry_expertise;

			$addresses_coll = $this->addresses;
			$addresses = "";
			if (!empty($addresses_coll) && $addresses_coll->count() > 0){
				$addresses = $addresses_coll->reduce(function ($carry, $item) {
					return trim($carry . ' ' .  $item->street . ' ' . $item->zip . ' ' . $item->city);
				});
			}
			$searchArray['addresses'] = $addresses;
		}

		return $searchArray;
	}