Get number of position from net votes

ok, try like this way-

In user model-

public function votes()
    {
        return $this->hasOne('App\Vote', 'user_id');
    }

In vote model-

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

Now in your controller, you can try with-

$user = User::get();
return view('your-view-page')->with('users', $users);

Now, in your view, use like this way-

<table>
    <tr>
        <td>Name</td>
        <td>Net Votes</td>
        <td>Position</td>
    </tr>
    @foreach($users as $user)
    <tr>
        <td>{{ $user->name }} </td>
        <td> {{ $user->votes->net_votes }} </td>
        <td> {{ $user->votes->position }} </td>
    </tr>
    @endforeach



</table>

Ref: https://laravel.com/docs/5.3/eloquent-relationships#one-to-one

Hi @tisuchi Thanks for the reply. I want to get number of position from net votes. for your better read, I have edited my question.

@shan11

Already updated my answer. Hope it will work for you.

For you better understanding, you can check it out this video- https://laracasts.com/series/laravel-5-fundamentals/episodes/14

@tisuchi

in votes table do not have position column. we need to calculate position automatically from net votes. if user got higher votes, position will come as 01. if two users got same votes, position will come as same position.

I see....

If I am right, you can not do that in eloquent relationship. You need to take help from queries. Here is the link- https://laravel.com/docs/5.3/queries#joins

You may need to use join. That may help you-

$users = DB::table('users')
            ->join('votes', 'users.id', '=', 'votes.user_id')
            ->select('users.*', 'votes.*')
            ->select('votes.net_votes', DB::raw('count(*) as total'))
            ->orderBy('total', 'desc')
            ->get();

Ok. @tisuchi I am already using query. reason for asked laravel method, there are some other tables also joint with votes table. so , it will be easy if I use eloquent method.

Thank you