Find a entry by a repeater field

Created 7 months ago by dwains

Hello, I'm working on a new module with profiles.

I created a migration file with:

protected $fields = [
    'phone_number'       => [
        'type'      => 'anomaly.field_type.text',
        'config'    => [
        ]
    ],
];
protected $stream = [
    'slug'          => 'phone_numbers',
    'sortable'     => true,
    'translatable' => false,
];
protected $assignments = [
    'phone_number',
];

I created a new stream called profiles and it has in the migration:

protected $fields = [
    'phone_numbers' => [
        'type'      => 'anomaly.field_type.repeater',
        'config'    => [
            'related' => 'modulename.phone_numbers',
        ],
    ],

Now in the Http Controller I want to find a profile by a phone_number.

I tried in the Profile stream to create a function in the ProfileRepository file:

public function findByPhoneNumber($phone_number)
    {
        return $this->model->whereHas('phone_numbers', function ($query) {
            $query->where('phone_number', $phone_number);
        });
    }

And in the Http controller

public function info(ProfileRepositoryInterface $profiles, $phone_number)
    {
        $profile = $profiles->findByPhoneNumber($phone_number);
        dd($profile);

But that doesnt work. How can I make this work?

ryanthompson — 7 months ago

What's the resulting query? What do you mean it "doesn't work"? Does it bomb out? Or does it simply not return the results?

Another way to approach it would be to find the phone numbers in the repeater stream and then use the entry relation to get your profile 😄

Link

dwains — 7 months ago

Im getting a error Call to undefined method Illuminate\Database\Query\Builder::default_crm_phone_numbers() with return $this->model->whereHas('default_crm_phone_numbers', function ($query) {

Link

ryanthompson — 6 months ago

You probably need to use the relation name not the slug: defaultCrmPhoneNumbers

Link

dwains — 6 months ago

return $this->model->whereHas('defaultCrmPhoneNumbers', function ($query) { is also not working

Link

ryanthompson — 6 months ago

Again - not working how so. Error? No results? What's the resulting query?

Link

dwains — 6 months ago

Its giving me Call to undefined method Illuminate\Database\Query\Builder::defaultCrmPhoneNumbers() the phone numbers has no stream its just a migration with create the table in the database with the slug and the namespace crm

Link

dwains — 6 months ago

I created this function in my ProfileRepository and it seems to work

public function findByPhoneNumber($phone_number)
    {
        $phoneNumberCheck = DB::table('crm_phone_numbers')
            ->where('phone_number', $phone_number)
            ->join('crm_profile_phone_numbers', 'crm_phone_numbers.id', '=', 'crm_profile_phone_numbers.related_id')
            ->first();

        if($phoneNumberCheck){
            $profile = $this->model->find($phoneNumberCheck->entry_id);

            if($profile){
                return $profile;
            }
        }
    }

Link