{
return $this->belongsTo('Muserpol\\Unit');
}
public function contribution_type()
{
return $this->belongsTo('Muserpol\\ContributionType');
}
public function category()
{
return $this->belongsTo('Muserpol\\Category');
}
public function scopeIdIs($query, $id)
{
return $query->where('id', $id);
}
public function scopeAffiliateidIs($query, $id)
{
return $query->where('affiliate_id', $id);
}
public function scopeAfiContribution($query, $year)
{
return $query = DB::table('contributions')->select(DB::raw('SUM(contributions.total) total, year(contributions.month_year) as month_year'))->whereYear('contributions.month_year', '=', $year);
}
public function scopeVoluntaryContribution($query, $month, $year)
{
return $query = DB::table('contributions')->select(DB::raw('COUNT(*) total, month(contributions.month_year) as month'))->where('contributions.contribution_type_id', '=', 2)->whereMonth('contributions.month_year', '=', $month)->whereYear('contributions.month_year', '=', $year);
}
}
Contribution::updating(function ($contribution) {
Activity::updateContribution($contribution);
});
