@extends('layouts.app', [ 'navClass' => 'navbar-light bg-secondary', 'parentSection' => 'laravel', 'elementName' => 'client-management' ]) @section('title', 'Relatório de Vendas |') @section('content') @component('layouts.headers.auth') @component('layouts.headers.breadcrumbs') @slot('title') Relatório de Vendas Corporativas @endslot
  • Minhas Vendas
    • @endcomponent
    @csrf
    @include('alerts.feedback', ['field' => 'type'])
    @endcomponent
    {{-- Linha 1 --}}

    Total de Vendas

    R$ {{ number_format( floatval($value->sum('final_price')) , 2, ",", ".") }}

    Receita Total

    R$ {{ number_format($revenues->sum('rav_tax') + $revenues->sum('commission') +$revenues->sum('du_tax') + $revenues->sum('hide_tax') - $revenues->sum('rav_discount') - $revenues->sum('du_discount'), 2, ",", ".") }}

    Margem Geral

    @if ($value->sum('final_price') > 0) {{ round((($revenues->sum('rav_tax') + $revenues->sum('du_tax') + $revenues->sum('commission') + $revenues->sum('hide_tax') - $revenues->sum('rav_discount') - $revenues->sum('du_discount')) / $value->sum('final_price')) * 100 , 2) . "%" }} @else 0 @endif

    Ticket Médio Venda

    R$ {{ number_format($value->avg('final_price'), 2, ",", ".") }}


    {{-- Linha 2 --}}

    Vendas no Mês

    R$ {{ number_format($value_month->sum('final_price'), 2, ",", ".") }}

    Receita no Mês

    R$ {{ number_format($revenues_month->sum('rav_tax') + $revenues_month->sum('commission') + $revenues_month->sum('du_tax') + $revenues_month->sum('hide_tax') - $revenues_month->sum('rav_discount') - $revenues_month->sum('du_discount'), 2, ",", ".") }}

    Margem do Mês

    @if ($value->sum('final_price') > 0) {{ round( ( ($revenues_month->sum('rav_tax') + $revenues_month->sum('du_tax') + $revenues_month->sum('commission') + $revenues_month->sum('hide_tax') - $revenues_month->sum('rav_discount') - $revenues_month->sum('du_discount')) / $value->sum('final_price') ) * 100 , 2) . "%" }} @else 0 @endif

    Qtde de Vendas no Mês

    {{$sales_month->count()}}

    {{-- Linha 3 --}}
    Faturamento

    Total de Vendas (R$)

    Vendas

    Quantidade de Vendas

    {{-- Linha 4 --}}
    Receita

    Receita por Mês/Ano

    {{-- Linha 5 --}}

    Valores por Cliente

    @foreach ($sales as $sale) @endforeach
    Cliente Valor Receita Margem %
    {{ $sale->first_name ." ".$sale->last_name }} R$ {{ number_format($value->where('client_id', '=', $sale->cid)->sum('final_price'), 2, ",", ".") }} R$ {{ number_format( $revenues->where('client_id', '=', $sale->cid)->sum('rav_tax') + $revenues->where('client_id', '=', $sale->cid)->sum('du_tax') + $revenues->where('client_id', '=', $sale->cid)->sum('commission') + $revenues->where('client_id', '=', $sale->cid)->sum('hide_tax') - $revenues->where('client_id', '=', $sale->cid)->sum('rav_discount') - $revenues->where('client_id', '=', $sale->cid)->sum('du_discount'), 2, ",", ".") }} {{ round( ( ($revenues->where('client_id', '=', $sale->cid)->sum('rav_tax') + $revenues->where('client_id', '=', $sale->cid)->sum('du_tax') + $revenues->where('client_id', '=', $sale->cid)->sum('commission') + $revenues->where('client_id', '=', $sale->cid)->sum('hide_tax') - $revenues->where('client_id', '=', $sale->cid)->sum('rav_discount') - $revenues->where('client_id', '=', $sale->cid)->sum('du_discount')) / $value->where('client_id', '=', $sale->cid)->sum('final_price') * 100), 2) }}%

    Valores por Fornecedor

    @foreach ($sales_provider as $sale) @endforeach
    Fornecedor Valor Receita Margem %
    {{ $sale->provider }} R$ {{ number_format($value->where('pid', '=', $sale->pid)->sum('final_price'), 2, ",", ".") }} R$ {{ number_format( $revenues->where('pid', '=', $sale->pid)->sum('rav_tax') + $revenues->where('pid', '=', $sale->pid)->sum('du_tax') + $revenues->where('pid', '=', $sale->pid)->sum('commission') + $revenues->where('pid', '=', $sale->pid)->sum('hide_tax') - $revenues->where('pid', '=', $sale->pid)->sum('rav_discount') - $revenues->where('pid', '=', $sale->pid)->sum('du_discount'), 2, ",", ".") }} @if ( ( $value->where('pid', '=', $sale->pid)->sum('final_price') ) > 0) {{round( ( ( $revenues->where('pid', '=', $sale->pid)->sum('rav_tax') + $revenues->where('pid', '=', $sale->pid)->sum('du_tax') + $revenues->where('pid', '=', $sale->pid)->sum('commission') + $revenues->where('pid', '=', $sale->pid)->sum('hide_tax') - $revenues->where('pid', '=', $sale->pid)->sum('rav_discount') - $revenues->where('pid', '=', $sale->pid)->sum('du_discount') ) / $value->where('pid', '=', $sale->pid)->sum('final_price') * 100), 2) }}% @else 0 @endif
    {{-- Linha 6 --}}

    Valores por Vendedor

    @foreach ($sales_user as $sale) @endforeach
    Cliente Valor Receita Margem %
    {{ $sale->name }} R$ {{ number_format($value->where('uid', '=', $sale->uid)->sum('final_price'), 2, ",", ".") }} R$ {{ number_format( $revenues->where('uid', '=', $sale->uid)->sum('rav_tax') + $revenues->where('uid', '=', $sale->uid)->sum('du_tax') + $revenues->where('uid', '=', $sale->uid)->sum('commission') + $revenues->where('uid', '=', $sale->uid)->sum('hide_tax') - $revenues->where('uid', '=', $sale->uid)->sum('rav_discount') - $revenues->where('uid', '=', $sale->uid)->sum('du_discount'), 2, ",", ".") }} {{ round( ( ( $revenues->where('uid', '=', $sale->uid)->sum('rav_tax') + $revenues->where('uid', '=', $sale->uid)->sum('du_tax') + $revenues->where('uid', '=', $sale->uid)->sum('commission') + $revenues->where('uid', '=', $sale->uid)->sum('hide_tax') - $revenues->where('uid', '=', $sale->uid)->sum('rav_discount') - $revenues->where('uid', '=', $sale->uid)->sum('du_discount') ) / $value->where('uid', '=', $sale->uid)->sum('final_price') * 100), 2) }}%

    Valores por Produto

    @foreach ($sales_product as $sale) @endforeach
    Fornecedor Valor Receita Margem %
    {{ $sale->product }} R$ {{ number_format($value->where('prodid', '=', $sale->prodid)->sum('final_price'), 2, ",", ".") }} R$ {{ number_format( $revenues->where('prodid', '=', $sale->prodid)->sum('rav_tax') + $revenues->where('prodid', '=', $sale->prodid)->sum('du_tax') + $revenues->where('prodid', '=', $sale->prodid)->sum('commission') + $revenues->where('prodid', '=', $sale->prodid)->sum('hide_tax') - $revenues->where('prodid', '=', $sale->prodid)->sum('rav_discount') - $revenues->where('prodid', '=', $sale->prodid)->sum('du_discount'), 2, ",", ".") }} {{ round( ( ( $revenues->where('prodid', '=', $sale->prodid)->sum('rav_tax') + $revenues->where('prodid', '=', $sale->prodid)->sum('du_tax') + $revenues->where('prodid', '=', $sale->prodid)->sum('commission') + $revenues->where('prodid', '=', $sale->prodid)->sum('hide_tax') - $revenues->where('prodid', '=', $sale->prodid)->sum('rav_discount') - $revenues->where('prodid', '=', $sale->prodid)->sum('du_discount') ) / $value->where('prodid', '=', $sale->prodid)->sum('final_price') * 100), 2) }}%
    @include('layouts.footers.auth')
    @endsection @push('css') @endpush @push('js') @endpush