belongsTo(Province::class, 'province_id')->withDefault();
}
public function district()
{
return $this->belongsTo(District::class, 'district_id')->withDefault();
}
public function locallevel()
{
return $this->belongsTo(Locallevel::class, 'locallevel_id')->withDefault();
}
public function c_province()
{
return $this->belongsTo(Province::class, 'cprovince_id')->withDefault();
}
public function c_district()
{
return $this->belongsTo(District::class, 'cdistrict_id')->withDefault();
}
public function c_locallevel()
{
return $this->belongsTo(Locallevel::class, 'clocallevel_id')->withDefault();
}
public function level()
{
return $this->belongsTo(Level::class, 'level_id')->withDefault();
}
public function specialization()
{
return $this->belongsTo(Specialization::class, 'specialization_id')->withDefault();
}
public function council_infos()
{
return $this->hasMany(CouncilInfo::class, 'member_id');
}
public function qualifications()
{
return $this->hasMany(Qualification::class, 'member_id');
}
public function pro_qualifications()
{
return $this->hasMany(ProQualification::class, 'member_id');
}
public function degrees()
{
return $this->hasMany(Degree::class, 'member_id');
}
public function documents()
{
return $this->hasMany(Document::class, 'members_id');
}
public function fiscal_years()
{
return $this->belongsTo(FiscalYear::class, 'fiscalyear_id')->withDefault();
}
public function citizendistrict()
{
return $this->belongsTo(District::class, 'citz_district_id')->withDefault();
}
public function citzlocallevel()
{
return $this->belongsTo(Locallevel::class, 'citz_locallevel_id')->withDefault();
}
public function countMale($levelid)
{
$males = $this->where('level_id', $levelid)
->where('gender', '1')
->count();
return $males;
}
public function countFemale($levelid)
{
$males = $this->where('level_id', $levelid)
->where('gender', '2')
->count();
return $males;
}
public function membership_renewals()
{
return $this->hasMany(MembershipRenewal::class, 'members_id');
}
public function users()
{
return $this->belongsTo(User::class, 'user_id')->withDefault();
}
public function get_phone($userid)
{
$user = User::find($userid);
$phone = $user->phone;
return $phone;
}
// incomplete
public function update_accepted_sn()
{
$members = $this->where('app_status', '2')->orderBy('updated_at', 'asc')->get();
$sn = 0;
while ($members) {
dd($members->id);
}
return $members;
} //incomplete
}