I have a model UserProgram user_id, program_id. I have a model User I have a model Profile, user_id, gender I have a model Program I have a function gender in my UserProgram model
public function gender()
{
$gender = "N/A";
$user = User::find($this->user_id);
if (!empty($user)) {
$profile = Profile::where('user_id',$user->id)->first();
if (!empty($profile)) {
$gender = $profile->gender;
}
}
return $gender;
}
Now I want to run a query that counts how many male or Female I have for a particular program. I want to be able to do something like this.
$male_count = UserProgram::with(‘gender)->where([
['program_id',104],[‘gender’,’Male’]
])->count();
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire