{{__('messages.Achievements')}}

gender {{-- branch_selected --}} {{__('messages.gender')}} @foreach ($allGender as $g) @endforeach
category_id {{-- branch_selected --}} {{__('messages.All Categories')}} @foreach(\App\Models\Category::whereNull("category_id")->get() as $category) @endforeach
branch_id {{-- branch_selected --}} {{__('messages.All Branches')}} @foreach(\App\Models\Branch::all() as $branch) @endforeach
@if ($category_id && $gender)
{{ \App\Models\Category::find($category_id)->name}}
{{__('messages.'.$gender) }}
@php $target_query = \App\Models\Target::query(); $target_query->where("active",1); $target_query->whereDate("created_at" ,">=" , $from); $target_query->whereDate("created_at" ,"<=" , $to); $monthly_target_points_qry = \App\Models\MonthlyTargetPoint::query(); $monthly_target_points_qry->where("category_id" ,$category_id); $monthly_target_points_qry->where("gender" ,$gender); if ($branch_id){ $monthly_target_points_qry->where("branch_id" ,$branch_id); } $monthly_target_points_qry->where("gender" ,$gender); $target_query->whereIn("monthly_target_point_id" ,$monthly_target_points_qry->pluck("id")); @endphp {{$target_query->sum("points")}}
@elseif($gender) @foreach ($allCats as $cat)
{{$cat->name}}
{{__('messages.'.$gender) }}
@php $target_query = \App\Models\Target::query(); $target_query->where("active",1); $target_query->whereDate("created_at" ,">=" , $from); $target_query->whereDate("created_at" ,"<=" , $to); $monthly_target_points_qry = \App\Models\MonthlyTargetPoint::query(); $monthly_target_points_qry->where("category_id" ,$cat->id); $monthly_target_points_qry->where("gender" ,$gender); if ($branch_id){ $monthly_target_points_qry->where("branch_id" ,$branch_id); } $monthly_target_points_qry->where("gender" ,$gender); $target_query->whereIn("monthly_target_point_id" ,$monthly_target_points_qry->pluck("id")); @endphp {{$target_query->sum("points")}}
@endforeach @elseif($category_id) @foreach ($allGender as $g)
{{ \App\Models\Category::find($category_id)->name}}
{{__('messages.'.$g) }}
@php $target_query = \App\Models\Target::query(); $target_query->where("active",1); $target_query->whereDate("created_at" ,">=" , $from); $target_query->whereDate("created_at" ,"<=" , $to); $monthly_target_points_qry = \App\Models\MonthlyTargetPoint::query(); $monthly_target_points_qry->where("category_id" ,$category_id); $monthly_target_points_qry->where("gender" ,$g); if ($branch_id){ $monthly_target_points_qry->where("branch_id" ,$branch_id); } $monthly_target_points_qry->where("gender" ,$g); $target_query->whereIn("monthly_target_point_id" ,$monthly_target_points_qry->pluck("id")); @endphp {{$target_query->sum("points")}}
@endforeach @else @foreach ($allCats as $cat) @foreach ($allGender as $g)
{{$cat->name}}
{{__('messages.'.$g) }}
@php $target_query = \App\Models\Target::query(); $target_query->where("active",1); $target_query->whereDate("created_at" ,">=" , $from); $target_query->whereDate("created_at" ,"<=" , $to); $monthly_target_points_qry = \App\Models\MonthlyTargetPoint::query(); $monthly_target_points_qry->where("category_id" ,$cat->id); $monthly_target_points_qry->where("gender" ,$g); if ($branch_id){ $monthly_target_points_qry->where("branch_id" ,$branch_id); } $monthly_target_points_qry->where("gender" ,$g); $target_query->whereIn("monthly_target_point_id" ,$monthly_target_points_qry->pluck("id")); @endphp {{$target_query->sum("points")}}
@endforeach @endforeach @endif
{{__('messages.Total Achieved Points')}}
@if ($from ==$to) {{$from}} @else {{$from}} - {{$to}} @endif
@if ($gender || $branch_id )
@if ($gender ) {{__('messages.'.$gender) }} @endif @if ($gender && $branch_id ) - @endif @if ($branch_id ) {{\App\Models\Branch::find($branch_id)->name}} @endif
@endif
{{$targets->sum("points")}}