@extends('layouts.master') @section('styles') @php error_reporting(0); @endphp @endsection @section('content')

Report Management

  1. Report
  2. List
Export Excel

{{$type}} Scheduled Product Coverage Report

@if($type=="EmployeeWise") @else @endif @if(count($data['segments'])>0) @foreach($data['segments'] as $segment) @endforeach @endif @if(count($data['segments'])>0) @foreach($data['segments'] as $segment) @endforeach @endif @if (collect($data['rows'])->count()>0) @foreach (collect($data['rows']) as $item) @if($type == "EmployeeWise") @else @endif @foreach($data['segments'] as $segment) @php $sale = null; if($item_coverage_type == 1) { $sale = new stdClass(); $sale->total_outlets = 0; $sale->covered_outlets = 0; if ($type == "EmployeeWise") { $sale->total_outlets = (int)collect($data['structure'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->where('employee_id', $item->employee_id)->sum('total_outlets'); $sale->covered_outlets = (int)collect($data['sales'])->where('segment_id',$segment->id)->where('distributor_id',$item->distributor_id)->where('employee_id',$item->employee_id)->where('item_id',$item->item_id)->sum('covered_outlets'); } else { $sale->total_outlets = (int)collect($data['structure'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->sum('total_outlets'); $sale->covered_outlets = (int)collect($data['sales'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->where('item_id',$item->item_id)->sum('covered_outlets'); } } else{ if ($type == "EmployeeWise") { $sale->total_outlets = (int)collect($data['structure'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->where('employee_id', $item->employee_id)->sum('total_outlets'); $sale->covered_outlets = (int)collect($data['sales'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->where('employee_id', $item->employee_id)->sum('covered_outlets'); } else { $sale->total_outlets = (int)collect($data['structure'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->sum('total_outlets'); $sale->covered_outlets = (int)collect($data['sales'])->where('segment_id',$segment->id)->where('distributor_id', $item->distributor_id)->sum('covered_outlets'); } } @endphp @endforeach @endforeach @endif
Brand ID Product Brand Product NameEmployee ID Employee NameDistributor IDDistributor Region RSM{{$segment->name}}
Total Outlets Covered Outlets Cov. %
{{$item->brand_id}} {{$item->brand_name}} {{$item->item_name}}{{$item->employee_id}} {{$item->employee_name}}{{$item->distributor_id}}{{$item->distributor_name}} {{$item->region}} {{$item->rsm}}{{@$sale->total_outlets}} {{@$sale->covered_outlets}} {{(@$sale->total_outlets!=0)? number_format((@$sale->covered_outlets/@$sale->total_outlets*100),2): 0}}%
@endsection @section('scripts') @endsection