@if ($branch_id =="all") @foreach ($categories as $category) @endforeach @for ($i = 0; $i < $categories->count(); $i++) @if ($selectedGender == 'all') @else @endif @endfor @foreach ($targets as $user_monthly_target) @php $user_monthly_target_points = []; @endphp @foreach ($categories as $category) @if ($selectedGender == 'all' && $selectedPointTypes == 'all') @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->get(); // (isset($totalPlanned["male"][$category->id]))?$totalPlanned["male"][$category->id]+=$user_monthly_target_points["male"]->planned_points: $totalPlanned["male"][$category->id]=$user_monthly_target_points["male"]->planned_points; $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->get(); // $totalPlanned["female"]+=$user_monthly_target_points["female"]; $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->get(); @endphp @elseif( $selectedGender =="all" ) @switch($selectedPointTypes ) @case("planned") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->get(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->get(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->get(); @endphp @break @case("transaction") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->get(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->get(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->get(); @endphp @break @case("achived") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->get(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->get(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->get(); @endphp @break @endswitch @elseif( $selectedPointTypes =="all" ) @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->get(); @endphp @else @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->get(); @endphp @switch($selectedPointTypes ) @case("planned") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->get(); @endphp @break @case("transaction") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->get(); @endphp @break @case("achived") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->get(); @endphp @break @endswitch @endif @endforeach @endforeach

{{ __('messages.User') }}	{{ $category->name }}
	{{ __('messages.male') }}	{{ __('messages.female') }}	{{ __('messages.both') }}	{{ __('messages.' . $selectedGender) }}
{{ $user_monthly_target->assigned_to_user->name }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('transaction_open_points') + $user_monthly_target_points['male']->sum('transaction_order_points') + $user_monthly_target_points['male']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('achived_open_points') + $user_monthly_target_points['male']->sum('achived_order_points') + $user_monthly_target_points['male']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('transaction_open_points') + $user_monthly_target_points['female']->sum('transaction_order_points') + $user_monthly_target_points['female']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('achived_open_points') + $user_monthly_target_points['female']->sum('achived_order_points') + $user_monthly_target_points['female']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('transaction_open_points') + $user_monthly_target_points['both']->sum('transaction_order_points') + $user_monthly_target_points['both']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('achived_open_points') + $user_monthly_target_points['both']->sum('achived_order_points') + $user_monthly_target_points['both']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('planned_points') : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('transaction_open_points') + $user_monthly_target_points['male']->sum('transaction_order_points') + $user_monthly_target_points['male']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('transaction_open_points') + $user_monthly_target_points['female']->sum('transaction_order_points') + $user_monthly_target_points['female']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('transaction_open_points') + $user_monthly_target_points['both']->sum('transaction_order_points') + $user_monthly_target_points['both']->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->sum('achived_open_points') + $user_monthly_target_points['male']->sum('achived_order_points') + $user_monthly_target_points['male']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->sum('achived_open_points') + $user_monthly_target_points['female']->sum('achived_order_points') + $user_monthly_target_points['female']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->sum('achived_open_points') + $user_monthly_target_points['both']->sum('achived_order_points') + $user_monthly_target_points['both']->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('planned_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('transaction_open_points') + $user_monthly_target_points[$selectedGender]->sum('transaction_order_points') + $user_monthly_target_points[$selectedGender]->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('achived_open_points') + $user_monthly_target_points[$selectedGender]->sum('achived_order_points') + $user_monthly_target_points[$selectedGender]->sum('achived_follow_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('planned_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('transaction_open_points') + $user_monthly_target_points[$selectedGender]->sum('transaction_order_points') + $user_monthly_target_points[$selectedGender]->sum('transaction_follow_points') : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->sum('achived_open_points') + $user_monthly_target_points[$selectedGender]->sum('achived_order_points') + $user_monthly_target_points[$selectedGender]->sum('achived_follow_points') : '-' }}

@else @foreach ($categories as $category) @endforeach @for ($i = 0; $i < $categories->count(); $i++) @if ($selectedGender == 'all') @else @endif @endfor @foreach ($targets as $user_monthly_target) @php $user_monthly_target_points = []; @endphp @foreach ($categories as $category) @if ($selectedGender == 'all' && $selectedPointTypes == 'all') @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->where('branch_id', $branch_id) ->first(); // (isset($totalPlanned["male"][$category->id]))?$totalPlanned["male"][$category->id]+=$user_monthly_target_points["male"]->planned_points: $totalPlanned["male"][$category->id]=$user_monthly_target_points["male"]->planned_points; $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->where('branch_id', $branch_id) ->first(); // $totalPlanned["female"]+=$user_monthly_target_points["female"]; $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->where('branch_id', $branch_id) ->first(); @endphp @elseif( $selectedGender =="all" ) @switch($selectedPointTypes ) @case("planned") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->where('branch_id', $branch_id) ->first(); @endphp @break @case("transaction") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->where('branch_id', $branch_id) ->first(); @endphp @break @case("achived") @php $user_monthly_target_points['male'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'male') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['female'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'female') ->where('branch_id', $branch_id) ->first(); $user_monthly_target_points['both'] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', 'both') ->where('branch_id', $branch_id) ->first(); @endphp @break @endswitch @elseif( $selectedPointTypes =="all" ) @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->where('branch_id', $branch_id) ->first(); @endphp @else @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->where('branch_id', $branch_id) ->first(); @endphp @switch($selectedPointTypes ) @case("planned") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->where('branch_id', $branch_id) ->first(); @endphp @break @case("transaction") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->where('branch_id', $branch_id) ->first(); @endphp @break @case("achived") @php $user_monthly_target_points[$selectedGender] = $user_monthly_target ->monthly_target_points() ->where('category_id', $category->id) ->where('gender', $selectedGender) ->where('branch_id', $branch_id) ->first(); @endphp @break @endswitch @endif @endforeach @endforeach

{{ __('messages.User') }}	{{ $category->name }}
	{{ __('messages.male') }}	{{ __('messages.female') }}	{{ __('messages.both') }}	{{ __('messages.' . $selectedGender) }}
{{ $user_monthly_target->assigned_to_user->name }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->planned_points : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->transaction_open_points + $user_monthly_target_points['male']->transaction_order_points + $user_monthly_target_points['male']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->achived_open_points + $user_monthly_target_points['male']->achived_order_points + $user_monthly_target_points['male']->achived_follow_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->planned_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->transaction_open_points + $user_monthly_target_points['female']->transaction_order_points + $user_monthly_target_points['female']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->achived_open_points + $user_monthly_target_points['female']->achived_order_points + $user_monthly_target_points['female']->achived_follow_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->planned_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->transaction_open_points + $user_monthly_target_points['both']->transaction_order_points + $user_monthly_target_points['both']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->achived_open_points + $user_monthly_target_points['both']->achived_order_points + $user_monthly_target_points['both']->achived_follow_points : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->planned_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->planned_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->planned_points : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->transaction_open_points + $user_monthly_target_points['male']->transaction_order_points + $user_monthly_target_points['male']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->transaction_open_points + $user_monthly_target_points['female']->transaction_order_points + $user_monthly_target_points['female']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->transaction_open_points + $user_monthly_target_points['both']->transaction_order_points + $user_monthly_target_points['both']->transaction_follow_points : '-' }}	{{ $user_monthly_target_points['male'] ? $user_monthly_target_points['male']->achived_open_points + $user_monthly_target_points['male']->achived_order_points + $user_monthly_target_points['male']->achived_follow_points : '-' }}	{{ $user_monthly_target_points['female'] ? $user_monthly_target_points['female']->achived_open_points + $user_monthly_target_points['female']->achived_order_points + $user_monthly_target_points['female']->achived_follow_points : '-' }}	{{ $user_monthly_target_points['both'] ? $user_monthly_target_points['both']->achived_open_points + $user_monthly_target_points['both']->achived_order_points + $user_monthly_target_points['both']->achived_follow_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->planned_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->transaction_open_points + $user_monthly_target_points[$selectedGender]->transaction_order_points + $user_monthly_target_points[$selectedGender]->transaction_follow_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->achived_open_points + $user_monthly_target_points[$selectedGender]->achived_order_points + $user_monthly_target_points[$selectedGender]->achived_follow_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->planned_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->transaction_open_points + $user_monthly_target_points[$selectedGender]->transaction_order_points + $user_monthly_target_points[$selectedGender]->transaction_follow_points : '-' }}	{{ $user_monthly_target_points[$selectedGender] ? $user_monthly_target_points[$selectedGender]->achived_open_points + $user_monthly_target_points[$selectedGender]->achived_order_points + $user_monthly_target_points[$selectedGender]->achived_follow_points : '-' }}

@endif {{ $targets->links() }}