public static function get_projects_bylogin()
{
$project = Project::select('name', 'id', 'active', 'status');
if (Auth::user()->group_id == 2) {
$project->where('added_by', Auth::user()->id);
}
return $project->get();
}
/**
* Get the completed camps goals details of the cards for specified project
* params @int $id
*
* return array
*/
public static function get_camp_planned_goals($id)
{
$planned_goals = Project::select(DB::Raw('sum(rb_camps.budget) as budget'), DB::Raw('count(rb_camps.id) as camps'), DB::Raw('sum(rb_camps.no_of_people) as total_villagers'), DB::Raw('sum(rb_camps.order) as orders'), DB::Raw('avg(rb_camps.deliver_time) as deliver_time'));
$planned_goals->join('cards', 'cards.project_id', '=', 'projects.id');
$planned_goals->join('camps', 'camps.card_id', '=', 'cards.id');
$planned_goals->where('projects.id', $id);
return $planned_goals->first();
}
