@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 Geral de Vendas @endslot
  • Minhas Vendas
    • @endcomponent
    @csrf
    @include('alerts.feedback', ['field' => 'type'])
    @include('alerts.feedback', ['field' => 'start_date'])
    {{-- {{ (Request::old("filter1") == "ID" ? "selected":"") }} --}}
    @include('alerts.feedback', ['field' => 'end_date'])
    @endcomponent
    {{-- Linha 1 --}}

    Total de Vendas

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

    Lazer: R$ {{ number_format( floatval($value->where('kind','=','PF')->sum('final_price')) , 2, ",", ".") }}

    Corporativo: R$ {{ number_format( floatval($value->where('kind','=','PJ')->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, ",", ".") }}

    Lazer: R$ {{ number_format($revenues->where('kind','=','PF')->sum('rav_tax') + $revenues->where('kind','=','PF')->sum('commission') + $revenues->where('kind','=','PF')->sum('du_tax') + $revenues->where('kind','=','PF')->sum('hide_tax') - $revenues->where('kind','=','PF')->sum('rav_discount') - $revenues->where('kind','=','PF')->sum('du_discount'), 2, ",", ".") }}

    Corporativo: R$ {{ number_format($revenues->where('kind','=','PJ')->sum('rav_tax') + $revenues->where('kind','=','PJ')->sum('commission') + $revenues->where('kind','=','PJ')->sum('du_tax') + $revenues->where('kind','=','PJ')->sum('hide_tax') - $revenues->where('kind','=','PJ')->sum('rav_discount') - $revenues->where('kind','=','PJ')->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) . "%" }}

    Lazer: {{ round((($revenues->where('kind','=','PF')->sum('rav_tax') + $revenues->where('kind','=','PF')->sum('du_tax') + $revenues->where('kind','=','PF')->sum('commission') + $revenues->where('kind','=','PF')->sum('hide_tax') - $revenues->where('kind','=','PF')->sum('rav_discount') - $revenues->where('kind','=','PF')->sum('du_discount')) / $value->where('kind','=','PF')->sum('final_price')) * 100 , 2) . "%"}}

    Corporativo: {{ round((($revenues->where('kind','=','PJ')->sum('rav_tax') + $revenues->where('kind','=','PJ')->sum('du_tax') + $revenues->where('kind','=','PJ')->sum('commission') + $revenues->where('kind','=','PJ')->sum('hide_tax') - $revenues->where('kind','=','PJ')->sum('rav_discount') - $revenues->where('kind','=','PJ')->sum('du_discount')) / $value->where('kind','=','PJ')->sum('final_price')) * 100 , 2) . "%"}}

    @else 0 @endif

    Ticket Médio Venda

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

    Lazer: R$ {{ number_format( floatval($value->where('kind','=','PF')->avg('final_price')) , 2, ",", ".") }}

    Corporativo: R$ {{ number_format( floatval($value->where('kind','=','PJ')->avg('final_price')) , 2, ",", ".") }}


    {{-- Linha 2 --}}

    Vendas no Mês

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

    Lazer: R$ {{ number_format( floatval($value_month->where('kind','=','PF')->sum('final_price')) , 2, ",", ".") }}

    Corporativo: R$ {{ number_format( floatval($value_month->where('kind','=','PJ')->sum('final_price')) , 2, ",", ".") }}

    Receita no Mês

    R$ {{ number_format($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'), 2, ",", ".") }}

    Lazer: R$ {{ number_format($revenues_month->where('kind','=','PF')->sum('rav_tax') + $revenues_month->where('kind','=','PF')->sum('du_tax') + $revenues_month->where('kind','=','PF')->sum('commission') + $revenues_month->where('kind','=','PF')->sum('hide_tax') - $revenues_month->where('kind','=','PF')->sum('rav_discount') - $revenues_month->where('kind','=','PF')->sum('du_discount'), 2, ",", ".") }}

    Corporativo: R$ {{ number_format($revenues_month->where('kind','=','PJ')->sum('rav_tax') + $revenues_month->where('kind','=','PJ')->sum('du_tax') + $revenues_month->where('kind','=','PJ')->sum('commission') + $revenues_month->where('kind','=','PJ')->sum('hide_tax') - $revenues_month->where('kind','=','PJ')->sum('rav_discount') - $revenues_month->where('kind','=','PJ')->sum('du_discount'), 2, ",", ".") }}

    Margem do Mês

    @if ($value_month->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')) / max(1, $value_month->sum('final_price'))) * 100, 2) . "%" }}

    Lazer: R$ {{ round((($revenues_month->where('kind','=','PF')->sum('rav_tax') + $revenues_month->where('kind','=','PF')->sum('du_tax') + $revenues_month->where('kind','=','PF')->sum('commission') + $revenues_month->where('kind','=','PF')->sum('hide_tax') - $revenues_month->where('kind','=','PF')->sum('rav_discount') - $revenues_month->where('kind','=','PF')->sum('du_discount')) / max(1, $value_month->where('kind','=','PF')->sum('final_price'))) * 100 , 2) . "%" }}

    Corporativo: R$ {{ round((($revenues_month->where('kind','=','PJ')->sum('rav_tax') + $revenues_month->where('kind','=','PJ')->sum('du_tax') + $revenues_month->where('kind','=','PJ')->sum('commission') + $revenues_month->where('kind','=','PJ')->sum('hide_tax') - $revenues_month->where('kind','=','PJ')->sum('rav_discount') - $revenues_month->where('kind','=','PJ')->sum('du_discount')) / max(1, $value_month->where('kind','=','PJ')->sum('final_price'))) * 100 , 2) . "%" }}

    @else 0 @endif

    Qtde de Vendas no Mês

    {{$sales_month->count()}}

    Lazer: {{ $sales_month->where('kind','=','PF')->count() }}

    Corporativo: {{ $sales_month->where('kind','=','PJ')->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) @else 0 @endif @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, ",", ".") }} @if ($value->where('prodid', '=', $sale->prodid)->sum('final_price') > 0) {{ 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) }}%
    {{-- Linha 9 --}} {{--

    Controle Financeiro por Mês/Ano

    @foreach ($result as $sale) @endforeach
    Mês/Ano Faturamento Receita Margem
    {{ $sale['month'] }} R$ {{ number_format($sale['revenue'], 2, ",", ".") }} R$ {{ number_format($sale['receita'], 2, ",", ".") }} {{ round( (( $sale['receita'] / $sale['revenue'] ) * 100), 2) }}%
    --}} @include('layouts.footers.auth')
    @endsection @push('css') @endpush @push('js') @endpush