I have Member
model Ledger
model
class Member extends Model
{
public function ledger()
{
return $this->hasMany('App\Ledger','user_id');
}
}
I have to get the ledger records of members (need both members and ledger data) where ledger.created_at = a particular date for example ledger.created_at = 2017-03-26 14:15:26
If I run the following script
$members = Member::whereHas('ledger', function($q){
$q->where('created_at', '2017-03-26 14:15:26');
})->get();
I get only members data no ledger records.
If I run the following script
$members = Member::with(['ledger' => function($q) {
$q->where('created_at', '2017-03-26 14:15:26');
}])->where('type','=','5')->paginate(10);
I get the members with the required ledger records that is good, but it also returns other members where ledger records = null, I do not need the member those does not have ledger record. (ie I need only members where ledger.created = '2017-03-26 14:15:26 along with the ledger records)
How can I achieve this ? (btw I am using laravel 5.3)
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2njL2WQ
via IFTTT
Aucun commentaire:
Enregistrer un commentaire