Level 13
any one
Feb 13, 2017
17
Level 13
How to use paginate with relationship?
I want to use paginate. Like a user have many subscriptions and then show all subscriptions in his account using using foreach but problem is that how can paginate them here is my controller
public function fdetail($reg_no = null)
{
$s = Student::where('reg_no', $reg_no)->with('subscriptions')->first();
return view('fee.invoice_deatil',compact('s'));
}
my Subscription model
public function students()
{
return $this->belongsTo(Student::Class,'student_id');
}
my Student model
public function subscriptions()
{
return $this->hasMany(Subscription::Class)->latest();
}
my view
@foreach($s->subscriptions as $invoi)
<tbody>
<tr>
<td>{{$invoi->id }}</td>
<td>{{ $invoi->created_at->format('d/m/Y') }}</td>
<td>{{ $invoi->month->format('F') }}</td>
</tr>
</tbody>
@endforeach
Level 7
You cannot paginate nested data.
Level 16
You can try something like
Subsciption::whereHas('Student'=>function($query) use($reg_no){
$query->where('reg_no', $reg_no);
})->paginate(10);
1 like
Level 13
it is possible with revers $sub = Subscription::where('students', function($query)use ($reg){ $query->where('reg_no',$reg); })->paginate(10);
Level 16
Yes that should work. See my example above.
Level 13
$invoces = Subscription::whereHas('students',function($query) use($reg_no){
$query->where('reg_no', $reg_no)->first();
})->paginate(12);
errors
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptions.student_id' in 'where clause' (SQL: select * from `students` where `subscriptions`.`student_id` = `students`.`id` and `reg_no` = GRN2017985534 limit 1)
Level 16
Does the subscriptions table have the student_id field?
Level 13
yes
Schema::create('subscriptions', function (Blueprint $table) {
$table->increments('id');
$table->integer('student_id')->unsigned()->index();
$table->integer('course_id')->unsigned()->index();
$table->string('other_fee')->nullable();
$table->string('tution_fee');
$table->string('late_fee')->nullable();
$table->string('development_fee')->nullable();
$table->string('remarks')->nullable();
$table->date('month');
$table->timestamps();
Level 50
You shouldn't use ->first(), ->get(), etc in the whereHas()..
$invoces = Subscription::whereHas('students',function($query) use($reg_no){
$query->where('reg_no', $reg_no);
})->paginate(12);
Level 13
@SaeedPrez @fraserk its worked thanks
Level 50
Level 13
@SaeedPrez i was thinking too @fraserk deserved best answered but if someone will see this questioned maybe he got that errors
Level 50
True, perhaps @fraserk can edit his answer and then..
1 like
Level 16
lol.. It's fine. @SaeedPrez had the correct answer, with a little extra helpful info. It will help someone in the future.
1 like
Level 50
@fraserk credit should go where credit is due ☺ I didn't want to jump in but then I noticed you guys were going a bit off-track.
Level 13
@SaeedPrez you are right @fraserk please edit your answered. and a question i have wchich is link to this question here look at https://laracasts.com/discuss/channels/laravel/how-to-find-previous-due-mont-fee
Level 13
and @fraserk edit your answered.
whereHas('students',function($query) use($reg_no){
Please or to participate in this conversation.