I have models below:
UserProgram user_id, program_id.
User
Profile, user_id, gender
Program
and 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