use orWhreJoin inside of query function getting an error. about laravel-eloquent-join HOT 7 CLOSED

Thank you .. problem solved.

from laravel-eloquent-join.

Thank you verymuch

from laravel-eloquent-join.

1.can you paste error you get?
2.can you paste your role relation code in user model ? is it role or roles, because if it is roles then :

$query ->orWhereJoin('roles.name', '=', 'user');

from laravel-eloquent-join.

I have a query which is working with orWhere, but if I use orWhereJoin instead of it getting an error

Query - Laravel (orWhere)

            DeviceModel::where(function ($query) {
                      $query ->orWhere('device_company_name', '=', 'samsung');
                      $query ->orWhere('device_company_name', '=', 'mi');
            })
            ->where('id', '!=', '1')
            ->get();

Query - Laravel-eloquent-join (orWhereJoin)

DeviceModel::where(function ($query) {
                      $query ->orWhereJoin('deviceCompany.name', '=', 'samsung');
                      $query ->orWhereJoin('deviceCompany.name', '=', 'mi');
            })
            ->where('id', '!=', '1')
            ->get();

DeviceModel relationship

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Fico7489\Laravel\EloquentJoin\Traits\EloquentJoin;

class DeviceModel extends Model
{
    use SoftDeletes;
    use EloquentJoin;
    //
    protected $dates = ['deleted_at'];

    public function deviceCompany(){
    	return $this->belongsTo('App\DeviceCompany');
    }
}

ERROR

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'device_companies.name' in 'where clause' (SQL: select * from device_models where (device_companies.name = samsung or device_companies.name = mi) and id != 1 and device_models.deleted_at is null)

from laravel-eloquent-join.

@fico7489 facing the same problem... any solution..???

from laravel-eloquent-join.

Here is a fix for the issue : https://github.com/fico7489/laravel-eloquent-join/pull/28/files
It will be merged soon.

from laravel-eloquent-join.

merged

from laravel-eloquent-join.