{{ Carbon::parse($currentEndDate)->format('d') == Carbon::parse($currentEndDate)->format('t') ? 'MONTHLY':'MTD' }} SALES REPORT {{Carbon::parse($currentEndDate)->format('F Y')}} @if($employee->employee_designation_flag == 1) Region:{{$employee->region->region_name}} @elseif($employee->employee_designation_flag == 2) Area:{{$employee->area->area_name}} @elseif($employee->employee_designation_flag == 3) Territory:{{$employee->territory->territory_name}} @endif
{PAGENO}/{nb}
 
REPORT DATE: {{Carbon::parse($currentStartDate)->format('jS M')}} - {{Carbon::parse($currentEndDate)->format('jS M, Y')}}
OVERALL SALES
 
GROSS SALE
{{-- --}}

Rs. {{number_format($dailysale->ttl_gross_sale)}}

--}} {{--

--}} {{-- @if($dailysale->GOLW >= 0)--}} {{-- --}} {{-- --}} {{-- --}} {{-- @else--}} {{-- --}} {{-- --}} {{-- --}} {{-- @endif--}} {{-- {{number_format(abs($dailysale->GOLW),2)}}%

--}} {{--
{{-- --}} {{-- --}} {{-- --}}
TTL. UNITS CARTONSBUNDLES
    
    
--}} {{--
    
--}} {{--
{{number_format($dailysale->net_sale_units)}} Units {{number_format($dailysale->ttl_ctns_sale)}} CTNs/BNDLs20,000 BNDLs
GROWTH
GOLW {{number_format($dailysale->GOLW,2)}}%
GOLM {{number_format($dailysale->GOLM,2)}}%
GOLY {{number_format($dailysale->GOLY,2)}}%
KPIs
AVG. BILL VALUE
Rs. {{number_format($dailysale->avg_bill_value,2)}}
AVG. SKU/ORDER
{{number_format($dailysale->avg_sku_per_order,2)}}
AVG. DROP SIZE
{{number_format($dailysale->avg_drop_size,2)}}
COVERAGE
{{number_format($total_outlets > 0 && $dailysale->ttl_covered_shops > 0 ? ($dailysale->ttl_covered_shops/$total_outlets)*100:0,2)}}%
KEY TRENDS
 
{{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}}

  TGT. ACHIVEMENT

{{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_achivement,2).'%'}}
TTL. TARGET: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ttl_target)}}
TGT. TILL DATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date)}}
ACH. TILL DATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ach_till_date,2).'%'}}
GROSS SALEs: {{$monthlysale->ttl_target == 0 ? '':'Rs. '}}{{$monthlysale->ttl_target == 0 ? 'NA':number_format($dailysale->ttl_gross_sale)}}
DAILY RUN RATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->daily_run_rate)}}
REQUIRED RUN RATE: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->required_run_rate)}}
PROJECTED SALES:{{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->projected_sale)}}
PROJECTED ACH%:{{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->projected_achv,2).'%'}}

  EXECUTION

 {{number_format($dailysale->execution,2)}}%
BOOKED UNITs: {{number_format($dailysale->ttl_booked_qty)}}
DISPATCHED UNITs: {{number_format($dailysale->ttl_executed_qty)}}
EXECUTED UNITs: {{number_format($dailysale->ttl_dispatched_qty)}}
CANCELED UNITs: {{number_format($dailysale->ttl_cancelled_qty)}}
SPOT/CNTR SALEs UNITS: {{number_format($dailysale->ttl_spot_qty+$dailysale->ttl_counter_qty)}}
NET UNITs SOLD: {{number_format($dailysale->net_sale_units)}}
GROSS VALUE: {{number_format($dailysale->ttl_gross_sale)}}
NET REVENUE: {{number_format($dailysale->net_sale_value)}}
AVG DISCOUNT: {{number_format((($dailysale->ttl_gross_sale-$dailysale->net_sale_value)/$dailysale->ttl_gross_sale)*100,2)}}%

  VISIT PRODUCTIVITY

 {{number_format($dailybooking->visit_productivity,2)}}%
PLANNED. VISITs: {{number_format($dailybooking->ttl_planned_visits)}}
ACTUAL VISITs: {{number_format($dailybooking->ttl_visits)}}
PRODUCTIVE VISITs: {{number_format($dailybooking->ttl_productive_visits)}}
UNIQ PRODUCTIVITY: {{number_format($total_outlets > 0 && $dailysale->ttl_covered_shops > 0 ? ($dailysale->ttl_covered_shops/$total_outlets)*100:0,2)}}%
SCH PRODUCTIVITY: {{number_format($dailybooking->ttl_productive_visits> 0 && $dailybooking->ttl_planned_visits > 0 ? ($dailybooking->ttl_productive_visits/$dailybooking->ttl_planned_visits)*100:0,2)}}%
STRIKE RATE: {{number_format($dailybooking->strike_rate,2)}}%
VISIT DEVIATION: {{number_format($dailybooking->visit_deviation,2)}}%
PHONE ORDERs: {{number_format($dailysale->ttl_phone_orders)}}
NEW SHOPs: {{number_format($dailybooking->new_shops)}}

 TEAM STRENGTH

 {{number_format($dailybooking->total_srs)}}
ACTIVE SRs: {{number_format($dailybooking->active_srs)}}
ABSENT SRs: {{number_format($dailybooking->absent_srs)}}
AVG. SHIFT HRs: {{$dailybooking->avg_shift_hours}}
AVG. MKT HRs: {{$dailybooking->avg_market_hours}}
AVG. TIME/SHOP MINs: {{$dailybooking->avg_shop_time}}
AVG. SALEs/SR: Rs. {{number_format($dailybooking->avg_sr_sale)}}
AVG. SHOPs/SR: {{number_format($dailybooking->avg_shops_per_sr)}}
AVG. PROD SHOP/SR: {{number_format($dailybooking->avg_prod_shop_per_sr)}}
RETAIL MARKET ANALYSIS
 
@foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) {{-- //TTL. UNIQ RETAILER FROM EMPLYEE DAILY ROUTE--}} @endforeach @foreach($channelsales as $channelsale) {{-- //TTL. UNIQ RETAILER WITH EXECTION--}} @endforeach @foreach($channelsales as $channelsale) {{-- //TTL. PRODUTIVE SHOPS /TTL. UNIQ SHOPS--}} @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @php $ttl_cancellation = $channelsale->ttl_executed_parent_qty > 0 ? ($channelsale->ttl_executed_parent_qty/$channelsale->ttl_booked_parent_qty)*100:0; $ttl_cancellation = $ttl_cancellation > 100 ? 100:$ttl_cancellation; $ttl_cancellation = $channelsale->ttl_booked_parent_qty > 0 ? number_format((100-$ttl_cancellation),2).'%':'NA'; @endphp @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach @foreach($channelsales as $channelsale) @endforeach
{{$channelsale->segment_name}}
SALE
CONTRIBUTION		 {{number_format($channelsale->ttl_net_unit_qty>0 && $dailysale->net_sale_units >0 ? ($channelsale->ttl_net_unit_qty/$dailysale->net_sale_units)*100:0,2)}}%
UNIQ. SHOPS:{{number_format($channelsale->ttl_uniq_shops)}}
PROD. SHOPS:{{number_format($channelsale->ttl_productive_shops)}}
COVERAGE:{{$channelsale->ttl_productive_shops > 0 && $channelsale->ttl_uniq_shops >0 ? number_format(($channelsale->ttl_productive_shops/$channelsale->ttl_uniq_shops)*100,2).'%':'NA'}}
BOOKING:(CTNs/BNDLs){{number_format($channelsale->ttl_booked_parent_qty)}}
EXECUTION:(CTNs/BNDLs){{number_format($channelsale->ttl_executed_parent_qty)}}
EXECUTION:{{$channelsale->ttl_executed_parent_qty > 0 ? number_format(($channelsale->ttl_executed_parent_qty/$channelsale->ttl_booked_parent_qty)*100,2).'%':'NA'}}
CANCELLATION:{{$ttl_cancellation}}
SPOT SALE:(CTNs/BNDLs){{number_format($channelsale->ttl_spot_sale_parent_qty+$channelsale->ttl_counter_parent_qty)}}
NET SALE:(CTNs/BNDLs){{number_format($channelsale->ttl_net_parent_qty)}}
AVG. REV/SHOP:Rs. {{number_format($channelsale->net_sale_value > 0 && $channelsale->ttl_productive_shops > 0 ? $channelsale->net_sale_value/$channelsale->ttl_productive_shops:0,2)}}
AVG BILL VALUE:Rs. {{number_format($channelsale->avg_order_val,2)}}
AVG SKU/ORDER:{{number_format($channelsale->avg_sku_per_order,2)}}
AVG DROP SIZE:(Units){{number_format($channelsale->avg_drop_size,2)}}
REGIONAL ANALYSIS
 
@if($employee->employee_designation_flag == 4) {{-- --}} {{-- --}} {{-- --}} @foreach($regionSales as $key1=>$regionSale) @php $cnt = 1; @endphp @foreach($regionSale->zonalSales as $key=>$zonalSale) {{-- --}} {{-- --}} @endforeach {{-- --}} {{-- --}} @endforeach
SN AREA/ZONE ASM/ZSM TTL. BOOKING NET EXECUTIONSPOT/COUNTER SALESNET SALES GOLM (%) GOLY (%)
G. VALUE UNITS G. VALUE UNITS %G. VALUEUNITSG. VALUE UNITS VALUE VOLUME VALUE VOLUME
{{$cnt++}} {{$zonalSale->area_name}} {{$zonalSale->asm}} {{number_format($zonalSale->booked_gross_value)}} {{number_format($zonalSale->booked_units)}} {{number_format($zonalSale->executed_gross_value)}} {{number_format($zonalSale->executed_units)}} {{number_format($zonalSale->executed_units>0 && $zonalSale->booked_units >0 ? ($zonalSale->executed_units/$zonalSale->booked_units)*100:0,2)}}%{{number_format($zonalSale->spot_gross_value+$zonalSale->counter_gross_value)}}{{number_format($zonalSale->spot_sale_units+$zonalSale->counter_sale_units)}} {{number_format($zonalSale->net_gross_value)}} {{number_format($zonalSale->net_sale)}} {{ $zonalSale->net_gross_value_last > 0 ? number_format((($zonalSale->net_gross_value - $zonalSale->net_gross_value_last)/$zonalSale->net_gross_value_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_sale_last > 0 ? number_format((($zonalSale->net_sale - $zonalSale->net_sale_last)/$zonalSale->net_sale_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_gross_value_year_last > 0 ? number_format((($zonalSale->net_gross_value - $zonalSale->net_gross_value_year_last)/$zonalSale->net_gross_value_year_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_sale_year_last > 0 ? number_format((($zonalSale->net_sale - $zonalSale->net_sale_year_last)/$zonalSale->net_sale_year_last)*100,2)."%" : "NA"}}
{{$regionSale->region_name}} - RSM: {{$regionSale->rsm}} {{number_format(collect($regionSale->zonalSales)->sum('booked_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('booked_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_units')>0 && collect($regionSale->zonalSales)->sum('booked_units') >0 ? (collect($regionSale->zonalSales)->sum('executed_units')/collect($regionSale->zonalSales)->sum('booked_units'))*100:0,2)}}%{{number_format(collect($regionSale->zonalSales)->sum('spot_gross_value')+collect($regionSale->zonalSales)->sum('counter_gross_value'))}}{{number_format(collect($regionSale->zonalSales)->sum('spot_sale_units')+collect($regionSale->zonalSales)->sum('counter_sale_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('net_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('net_sale'))}} {{$regionSale->net_gross_value_last > 0 ? number_format((($regionSale->net_gross_value - $regionSale->net_gross_value_last)/$regionSale->net_gross_value_last)*100,2)."%" : "NA"}} {{$regionSale->net_sale_last > 0 ? number_format((($regionSale->net_sale - $regionSale->net_sale_last)/$regionSale->net_sale_last)*100,2)."%" : "NA"}} {{$regionSale->net_gross_value_year_last > 0 ? number_format((($regionSale->net_gross_value - $regionSale->net_gross_value_year_last)/$regionSale->net_gross_value_year_last)*100,2)."%" : "NA"}} {{$regionSale->net_sale_year_last > 0 ? number_format((($regionSale->net_sale - $regionSale->net_sale_year_last)/$regionSale->net_sale_year_last)*100,2)."%" : "NA"}}
@else {{-- --}} {{-- --}} {{-- --}} @foreach($regionSales as $key1=>$regionSale) @php $cnt = 1; @endphp @foreach($regionSale->zonalSales as $key=>$zonalSale) {{-- --}} {{-- --}} @endforeach {{-- --}} {{-- --}} @endforeach
SN DISTRIBUTION TSM TTL. BOOKING NET EXECUTIONSPOT/COUNTER SALESNET SALES GOLM (%) GOLY (%)
G. VALUE UNITS G. VALUE UNITS %G. VALUEUNITSG. VALUE UNITS VALUE VOLUME VALUE VOLUME
{{$cnt++}} {{$zonalSale->distributor_name}} {{$zonalSale->tsm}} {{number_format($zonalSale->booked_gross_value)}} {{number_format($zonalSale->booked_units)}} {{number_format($zonalSale->executed_gross_value)}} {{number_format($zonalSale->executed_units)}} {{number_format($zonalSale->executed_units>0 && $zonalSale->booked_units >0 ? ($zonalSale->executed_units/$zonalSale->booked_units)*100:0,2)}}%{{number_format($zonalSale->spot_gross_value+$zonalSale->counter_gross_value)}}{{number_format($zonalSale->spot_sale_units+$zonalSale->counter_sale_units)}} {{number_format($zonalSale->net_gross_value)}} {{number_format($zonalSale->net_sale)}} {{ $zonalSale->net_gross_value_last > 0 ? number_format((($zonalSale->net_gross_value - $zonalSale->net_gross_value_last)/$zonalSale->net_gross_value_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_sale_last > 0 ? number_format((($zonalSale->net_sale - $zonalSale->net_sale_last)/$zonalSale->net_sale_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_gross_value_year_last > 0 ? number_format((($zonalSale->net_gross_value - $zonalSale->net_gross_value_year_last)/$zonalSale->net_gross_value_year_last)*100,2)."%" : "NA"}} {{ $zonalSale->net_sale_year_last > 0 ? number_format((($zonalSale->net_sale - $zonalSale->net_sale_year_last)/$zonalSale->net_sale_year_last)*100,2)."%" : "NA"}}
{{$regionSale->name}} - {{$employee->employee_designation_flag == 3 ? 'TSM':'ZSM/ASM'}}: {{$regionSale->asm_tsm}} {{number_format(collect($regionSale->zonalSales)->sum('booked_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('booked_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('executed_units')>0 && collect($regionSale->zonalSales)->sum('booked_units') >0 ? (collect($regionSale->zonalSales)->sum('executed_units')/collect($regionSale->zonalSales)->sum('booked_units'))*100:0,2)}}%{{number_format(collect($regionSale->zonalSales)->sum('spot_gross_value')+collect($regionSale->zonalSales)->sum('counter_gross_value'))}}{{number_format(collect($regionSale->zonalSales)->sum('spot_sale_units')+collect($regionSale->zonalSales)->sum('counter_sale_units'))}} {{number_format(collect($regionSale->zonalSales)->sum('net_gross_value'))}} {{number_format(collect($regionSale->zonalSales)->sum('net_sale'))}} {{$regionSale->net_gross_value_last > 0 ? number_format((($regionSale->net_gross_value - $regionSale->net_gross_value_last)/$regionSale->net_gross_value_last)*100,2)."%" : "NA"}} {{$regionSale->net_sale_last > 0 ? number_format((($regionSale->net_sale - $regionSale->net_sale_last)/$regionSale->net_sale_last)*100,2)."%" : "NA"}} {{$regionSale->net_gross_value_year_last > 0 ? number_format((($regionSale->net_gross_value - $regionSale->net_gross_value_year_last)/$regionSale->net_gross_value_year_last)*100,2)."%" : "NA"}} {{$regionSale->net_sale_year_last > 0 ? number_format((($regionSale->net_sale - $regionSale->net_sale_year_last)/$regionSale->net_sale_year_last)*100,2)."%" : "NA"}}
@endif
KPI ANALYSIS
 
VISIT PRODUCTIVITY

{{number_format($dailybooking->visit_productivity,2)}}%
STRIKE RATE
{{number_format($dailybooking->strike_rate,2)}}%
 SCH. PRODUCTIVITY
{{number_format($dailybooking->visit_deviation,2)}}%
PLANNED. VISITS: {{number_format($dailybooking->ttl_planned_visits)}}
ACTUAL VISITS: {{number_format($dailybooking->ttl_visits)}}
PRODUCTIVE VISITS: {{number_format($dailybooking->ttl_productive_visits)}}
TEAM STRENGTH: {{number_format($dailybooking->total_srs)}}
ACTIVE SRS: {{number_format($dailybooking->active_srs)}}
ABSENT SRS: {{number_format($dailybooking->absent_srs)}}
AVG. SHIFT HRS: {{($dailybooking->avg_shift_hours)}}
AVG. MKT HRS: {{($dailybooking->avg_market_hours)}}
AVG. TIME/SHOP: {{($dailybooking->avg_shop_time)}}
AVG. BILL VALUE: Rs. {{number_format($dailysale->avg_bill_value,2)}}
AVG. SKU/ORDER: {{number_format($dailysale->avg_sku_per_order,2)}}
AVG. DROP SIZE: {{number_format($dailysale->avg_drop_size,2)}}
@if($employee->employee_designation_flag == 4) {{-- --}} @foreach($regionBookings as $key1=>$regionBooking) @php $cnt = 1; @endphp @foreach($regionBooking->zonalBookings as $key=>$zonalBooking) {{-- --}} @endforeach {{-- --}} @endforeach
SN AREA/ZONE ASM/ZSM TTL.
SRS		 ACTIVE
SRS		ABSENT SRSAVG.
SHIFT
HRS		 AVG.
MARKET
HRS		 AVG.
TIME
/SHOP		 PLANNED
VISITS		 ACTUAL
VISITS		 PROD.
VISITS		 STRIKE
RATE		 SCH.
PROD.		 VISIT.
PROD.		 AVG.
BILL
VALUE		 AVG.
SKU
/ORDER		 AVG.
DROP
SIZE
{{$cnt++}} {{$zonalBooking->area_name}} {{$zonalBooking->asm}} {{number_format($zonalBooking->total_srs)}} {{number_format($zonalBooking->active_srs)}}{{number_format($zonalBooking->absent_srs)}}{{Carbon::createFromTimestamp(0)->addSeconds($zonalBooking->avg_shift_hours* 3600)->format('H:i:s')}} {{$zonalBooking->avg_market_hours}} {{$zonalBooking->avg_shop_time}} {{number_format($zonalBooking->ttl_planned_visits)}} {{number_format($zonalBooking->ttl_visits)}} {{number_format($zonalBooking->ttl_productive_visits)}} {{number_format($zonalBooking->strike_rate,2)}}% {{number_format($zonalBooking->visit_deviation,2)}}% {{number_format($zonalBooking->visit_productivity,2)}}% {{number_format($zonalBooking->avg_bill_value,2)}} {{number_format($zonalBooking->avg_sku_per_order,2)}} {{number_format($zonalBooking->avg_drop_size,2)}}
{{$regionBooking->region_name}} - RSM: {{$regionBooking->rsm}} {{number_format(collect($regionBooking->zonalBookings)->sum('total_srs'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('active_srs'))}}{{number_format(collect($regionBooking->zonalBookings)->sum('absent_srs'))}}{{Carbon::createFromTimestamp(0)->addSeconds(collect($regionBooking->zonalBookings)->avg('avg_shift_hours') * 3600)->format('H:i:s')}} {{calculateAverageHoursInWeekReport(collect($regionBooking->zonalBookings)->pluck('avg_market_hours')->toArray())}} {{calculateAverageTime(collect($regionBooking->zonalBookings)->pluck('avg_shop_time')->toArray())}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_planned_visits'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_visits'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_productive_visits'))}} {{number_format($regionBooking->strike_rate,2)}}% {{number_format($regionBooking->visit_deviation,2)}}% {{number_format($regionBooking->visit_productivity,2)}}% {{number_format($regionBooking->avg_bill_value,2)}} {{number_format(collect($regionBooking->zonalBookings)->avg('avg_sku_per_order'),2)}} {{number_format($regionBooking->avg_drop_size,2)}}
@else {{-- --}} @foreach($regionBookings as $key1=>$regionBooking) @php $cnt = 1; @endphp @foreach($regionBooking->zonalBookings as $key=>$zonalBooking) {{-- --}} @endforeach {{-- --}} @endforeach
SN DISTRIBUTION TSM TTL.
SRS		 ACTIVE
SRS		ABSENT SRSAVG.
SHIFT
HRS		 AVG.
MARKET
HRS		 AVG.
TIME
/SHOP		 PLANNED
VISITS		 ACTUAL
VISITS		 PROD.
VISITS		 STRIKE
RATE		 SCH.
PROD.		 VISIT.
PROD.		 AVG.
BILL
VALUE		 AVG.
SKU
/ORDER		 AVG.
DROP
SIZE
{{$cnt++}} {{$zonalBooking->distributor_name}} {{$zonalBooking->tsm}} {{number_format($zonalBooking->total_srs)}} {{number_format($zonalBooking->active_srs)}}{{number_format($zonalBooking->absent_srs)}}{{Carbon::createFromTimestamp(0)->addSeconds($zonalBooking->avg_shift_hours* 3600)->format('H:i:s')}} {{$zonalBooking->avg_market_hours}} {{$zonalBooking->avg_shop_time}} {{number_format($zonalBooking->ttl_planned_visits)}} {{number_format($zonalBooking->ttl_visits)}} {{number_format($zonalBooking->ttl_productive_visits)}} {{number_format($zonalBooking->strike_rate,2)}}% {{number_format($zonalBooking->visit_deviation,2)}}% {{number_format($zonalBooking->visit_productivity,2)}}% {{number_format($zonalBooking->avg_bill_value,2)}} {{number_format($zonalBooking->avg_sku_per_order,2)}} {{number_format($zonalBooking->avg_drop_size,2)}}
{{$regionBooking->name}} - {{$employee->employee_designation_flag == 3 ? 'TSM':'ZSM/ASM'}}:: {{$regionBooking->asm_tsm}} {{number_format(collect($regionBooking->zonalBookings)->sum('total_srs'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('active_srs'))}}{{number_format(collect($regionBooking->zonalBookings)->sum('absent_srs'))}}{{Carbon::createFromTimestamp(0)->addSeconds(collect($regionBooking->zonalBookings)->avg('avg_shift_hours') * 3600)->format('H:i:s')}} {{calculateAverageHoursInWeekReport(collect($regionBooking->zonalBookings)->pluck('avg_market_hours')->toArray())}} {{calculateAverageTime(collect($regionBooking->zonalBookings)->pluck('avg_shop_time')->toArray())}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_planned_visits'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_visits'))}} {{number_format(collect($regionBooking->zonalBookings)->sum('ttl_productive_visits'))}} {{number_format($regionBooking->strike_rate,2)}}% {{number_format($regionBooking->visit_deviation,2)}}% {{number_format($regionBooking->visit_productivity,2)}}% {{number_format($regionBooking->avg_bill_value,2)}} {{number_format(collect($regionBooking->zonalBookings)->avg('avg_sku_per_order'),2)}} {{number_format($regionBooking->avg_drop_size,2)}}
@endif
SALES TARGET ANALYSIS
 
TARGET ACHIEVEMENT

{{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_achivement,2).'%'}}
OVERALL TARGET
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ttl_target)}}
G. VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->ttl_target_value)}}
NET SALES
UNITS: {{number_format($dailysale->net_sale_units)}}
G. VALUE: Rs. {{number_format($dailysale->net_sale_value)}}
TARGET TILL DATE
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date)}}
G. VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->target_till_date_value)}}
ACH. TILL DATE {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->ach_till_date,2).'%'}}
UNITS: {{$monthlysale->ttl_target == 0 ? 'NA':number_format($monthlysale->target_till_date)}}
G. VALUE: {{$monthlysale->ttl_target == 0 ? 'NA':'Rs. '.number_format($monthlysale->target_till_date_value)}}
@if($employee->employee_designation_flag == 4) {{-- --}} {{-- --}} @foreach($regionTargetSales as $key1=>$regionTargetSale) @php $cnt = 1; @endphp @foreach(@$regionTargetSale->zonalTargetSales as $key=>$targetsale) {{-- --}} {{-- --}} @endforeach {{-- --}} {{-- --}} @endforeach
SN AREA/ZONE ASM/ZSM TARGET NET SALES OVERALL ACH. TGT. TILL DATE ACH. TILL DATE D.R.R. R.R.R.PROJECTED SALESPROJECTED ACH. %
G. VALUE UNITS G. VALUE UNITS
{{$cnt++}} {{$targetsale->area_name}} {{$targetsale->asm}} {{number_format($targetsale->ttl_target_value)}} {{number_format($targetsale->ttl_target)}} {{number_format($targetsale->net_gross_value)}} {{number_format($targetsale->net_sale_units)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_achivement,2).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_till_date)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->ach_till_date).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->daily_run_rate)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->required_run_rate)}}{{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_sale)}}{{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_achv).'%'}}
{{$regionTargetSale->region_name}} - RSM: {{$regionTargetSale->rsm}} {{number_format($regionTargetSale->ttl_target_value)}} {{number_format($regionTargetSale->ttl_target)}} {{number_format($regionTargetSale->net_gross_value)}} {{number_format($regionTargetSale->net_sale_units)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->target_achivement,2).'%'}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->target_till_date)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->ach_till_date).'%'}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->daily_run_rate)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->required_run_rate)}}{{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->projected_sale)}}{{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->projected_achv).'%'}}
@else {{-- --}} {{-- --}} @foreach($regionTargetSales as $key1=>$regionTargetSale) @php $cnt = 1; @endphp @foreach(@$regionTargetSale->zonalTargetSales as $key=>$targetsale) {{-- --}} {{-- --}} @endforeach {{-- --}} {{-- --}} @endforeach
SN DISTRIBUTION TSM TARGET NET SALES OVERALL ACH. TGT. TILL DATE ACH. TILL DATE D.R.R. R.R.R.PROJECTED SALESPROJECTED ACH. %
G. VALUE UNITS G. VALUE UNITS
{{$cnt++}} {{$targetsale->distributor_name}} {{$targetsale->tsm}} {{number_format($targetsale->ttl_target_value)}} {{number_format($targetsale->ttl_target)}} {{number_format($targetsale->net_gross_value)}} {{number_format($targetsale->net_sale_units)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_achivement,2).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->target_till_date)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->ach_till_date).'%'}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->daily_run_rate)}} {{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->required_run_rate)}}{{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_sale)}}{{$targetsale->ttl_target == 0 ? 'NA':number_format($targetsale->projected_achv).'%'}}
{{$regionTargetSale->name}} - {{$employee->employee_designation_flag == 3 ? 'TSM':'ZSM/ASM'}}: {{$regionTargetSale->asm_tsm}} {{number_format($regionTargetSale->ttl_target_value)}} {{number_format($regionTargetSale->ttl_target)}} {{number_format($regionTargetSale->net_gross_value)}} {{number_format($regionTargetSale->net_sale_units)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->target_achivement,2).'%'}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->target_till_date)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->ach_till_date).'%'}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->daily_run_rate)}} {{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->required_run_rate)}}{{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->projected_sale)}}{{$regionTargetSale->ttl_target == 0 ? 'NA':number_format($regionTargetSale->projected_achv).'%'}}
@endif @foreach($DivisionsSales as $DivisionsSale) @php $cnt = 1; @endphp
PRODUCT SALES ANALYSIS
 
DIVISION: {{$DivisionsSale->division}}
ACTIVE SKUs
{{number_format($DivisionsSale->unique_skus)}}
GROSS SALE VALUE
Rs. {{number_format($DivisionsSale->net_gross_value)}}
CTN/BNDLs SALES
{{number_format($DivisionsSale->ctn_sale)}}
UNIT SALES
{{number_format($DivisionsSale->net_sale)}}
COVERAGE
{{number_format($DivisionsSale->coverage,2)}} %
AVG. DROP SIZE
{{number_format($DivisionsSale->net_sale >0 && $DivisionsSale->total_orders >0 ? ($DivisionsSale->net_sale/$DivisionsSale->total_orders):0,2)}}
SALES CONTRIBUTION
{{number_format( $DivisionsSale->net_sale > 0 && collect($DivisionsSales)->sum('net_sale') >0 ? ($DivisionsSale->net_sale/collect($DivisionsSales)->sum('net_sale'))*100:0,2)}}%
@foreach($productBrandSales as $productBrandSale) @php $cnt = 1; @endphp @if(in_array($DivisionsSale->division_id,$productBrandSale->divisions)) @foreach($productBrandSale->products as $row) @endforeach @endif @endforeach
SN SKU PRODUCT NAME SALEs GOLM (%) GOLY (%) COVERAGE
G. VALUE UNITs CTN/BNDLs CTR. AVG. DROP SIZE VALUE VOLUME VALUE VOLUME UNIQ. SHOPs CVRG.
{{$cnt++}} {{$row->item_sku}} {{$row->item_name}} Rs. {{number_format($row->net_gross_value)}} {{number_format($row->net_sale)}} {{number_format($row->ctn_sale,2)}} {{number_format($row->net_sale >0 && $DivisionsSale->net_sale > 0 ? ($row->net_sale/$DivisionsSale->net_sale)*100:0,2)}}% {{number_format($row->avg_drop_size >0 ? $row->avg_drop_size:0,2)}} {{ $row->net_gross_value_last > 0 && $row->net_gross_value >0 ? number_format((($row->net_gross_value - $row->net_gross_value_last)/$row->net_gross_value_last)*100,2)."%" : "NA"}} {{ $row->net_sale_last > 0 && $row->net_sale>0 ? number_format((($row->net_sale - $row->net_sale_last)/$row->net_sale_last)*100,2)."%" : "NA"}} {{ $row->net_gross_value_year_last > 0 && $row->net_gross_value >0 ? number_format((($row->net_gross_value - $row->net_gross_value_year_last)/$row->net_gross_value_year_last)*100,2)."%" : "NA"}} {{ $row->net_sale_year_last > 0 && $row->net_sale > 0 ? number_format((($row->net_sale - $row->net_sale_year_last)/$row->net_sale_year_last)*100,2)."%" : "NA"}} {{number_format($row->covered_outlets)}} {{number_format($row->coverage,2)}}%
{{$productBrandSale->brand_name}} Rs. {{number_format($productBrandSale->net_gross_value)}} {{number_format($productBrandSale->net_sale)}} {{number_format($productBrandSale->ctn_sale,2)}} {{number_format($productBrandSale->net_sale >0 && $DivisionsSale->net_sale > 0 ? ($productBrandSale->net_sale/$DivisionsSale->net_sale)*100:0,2)}} % {{number_format($productBrandSale->avg_drop_size >0 ? $productBrandSale->avg_drop_size:0,2)}} {{$productBrandSale->net_gross_value_last > 0 && $productBrandSale->net_gross_value > 0 ? number_format((($productBrandSale->net_gross_value - $productBrandSale->net_gross_value_last)/$productBrandSale->net_gross_value_last)*100,2)."%" : "NA"}} {{$productBrandSale->net_sale_last > 0 && $productBrandSale->net_sale > 0 ? number_format((($productBrandSale->net_sale - $productBrandSale->net_sale_last)/$productBrandSale->net_sale_last)*100,2)."%" : "NA"}} {{$productBrandSale->net_gross_value_year_last > 0 && $productBrandSale->net_gross_value > 0 ? number_format((($productBrandSale->net_gross_value - $productBrandSale->net_gross_value_year_last)/$productBrandSale->net_gross_value_year_last)*100,2)."%" : "NA"}} {{$productBrandSale->net_sale_year_last > 0 && $productBrandSale->net_sale > 0 ? number_format((($productBrandSale->net_sale - $productBrandSale->net_sale_year_last)/$productBrandSale->net_sale_year_last)*100,2)."%" : "NA"}} {{number_format($productBrandSale->covered_outlets)}} {{number_format($productBrandSale->coverage,2)}}%
@endforeach