@php use App\Http\Controllers\Mod\ModCommissionSales;use App\Http\Controllers\Mod\ModPaymentMethod;use App\Http\Controllers\Mod\ModProductService;use App\Http\Controllers\ModFinancial;use App\Http\Controllers\ModToolStatus;use App\Models\Profile;use Illuminate\Support\Facades\Crypt; use App\Http\Controllers\Mod\ModPaymentMethodRecurrent; $sum_prodserv_value=0; $sum_prodserv_comm_seller=0; $prodserv_value=0; $prodserv_comm_seller=0; $profile_select=Profile::user($record_salesorder->idUserResponsible); $status_payment_method = ModPaymentMethod::status($record_salesorder->idPaymentMethod); $response=isset($response)?$response:null; $commission_result=isset($commission_result)?$commission_result:null; //CONSULTA O VENDEDOR COMISSIONADO COM A TABELA ATIVA AO COMISSIONAMENTO POR PRODUTOS E SERVICOS $record_commission= ModCommissionSales::information([ // 'selectString'=>'idUserCommission,commissionedName,idCommissionSalesTable,tableName', 'distinct'=>'on', 'idUserCommission'=> $record_salesorder->idUserResponsible, 'idPaymentMethod'=>$record_salesorder-> idPaymentMethod, 'idStatusCommissionProdServ'=>1, //ATIVO o comissionamento 'idStatusReg'=>1, 'optionList'=>'g', ]); $qtt=0; $prodserv_comm_value_media=0; $record_commission_count= count($record_commission); $comm_salesorder_value_sum=0; $id_status_fin_debt = isset($record_fin->idStatusFinDebt)?$record_fin->idStatusFinDebt:null; @endphp
Comissionados por Produtos e serviços
Metodo de vendas: {{$status_payment_method->xName}}
Nº Negociação: {{$record_salesorder->idNegotiation}}

Nº Proposta : {{$record_salesorder->idSalesOrder}}

Vendedor: {{$profile_select->userName}}
@if($record_commission_count == 0)

| Vendedor não encontrado em nenhuma da(s) tabela(s) que esteja(m) ativo(s), para o comissionamento por produtos e serviços:
Edite atabela ou/e atribuição ao vendedor:
@endif

Produtos/Serviços: {{$participation_count}}

@foreach($record as $row) @php $prodserv_comm_calc=null; $prodserv_comm_value = null; if($record_commission_count >0){ $qtt++; //DECLARACAO //valor do produto/servico $prodserv_value = $row->xValue*$row->amount; //COMISSIONAMENTO DE PROD-SERV: ATIVO $prodserv_comm_status = $row->idStatusCommissionProdServ; //OPTION: PORC/VALOR FIXO $prodserv_comm_calc = $row->idStatusFinConditionCalc; //COMISSIOAR: Calculo VALOR $prodserv_comm_value = $row->commissionCalcValue; //URGENTE: PERIODO DE 12 MESES 16/06/2023 //PARA COMPATIBILIZAR VERÇÕES DE PROPOSTA ANTIGAS if( $row->idStatusCommissionProdServ == 60){ $record_prodsev = ModProductService::information([ 'selectString'=>'idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idProductService'=>$row->idProductService, ]); //COMISSIONAMENTO DE PROD-SERV: ATIVO $prodserv_comm_status = $record_prodsev->idStatusCommissionProdServ; //OPTION: PORC/VALOR FIXO $prodserv_comm_calc = $record_prodsev->idStatusFinConditionCalc; //COMISSIOAR: Calculo VALOR $prodserv_comm_value = $record_prodsev->commissionCalcValue; } if($prodserv_comm_calc==1){ //PRODUTOS E SERVIÇOS: % PORCETAGEM $prodserv_comm_seller = ModFinancial::porcentagem($prodserv_value,$prodserv_comm_value); }else{ //PRODUTOS E SERVIÇOS: $ VALOR FIXO $prodserv_comm_seller =$prodserv_comm_value; } } @endphp @php $prodserv_comm_value_media +=$prodserv_comm_value/$qtt; @endphp @endforeach
COMISSÃO
Produto Qtdd Valor Subtotal %/$ Valor
{{$row->idSalesOrderProdServ}} {{$row->xName}} {{$row->amount}} @if($record_salesorder->idPaymentMethod==2) @php //CASO O RECORRENTE MAIS DE UMA MENSALIDADE PARCELE DEACORDO COM O SEU METODO //em parcelas: 3X 12X... $comm_salesorder_value = ModPaymentMethodRecurrent::splitMonth([ 'active' => 1, 'idPaymentMethod' => isset($record_salesorder->idPaymentMethod)?$record_salesorder->idPaymentMethod:null, 'idPaymentMethodRecurrent' => isset($record_salesorder->idPaymentMethodRecurrent)?$record_salesorder->idPaymentMethodRecurrent:null, 'value' =>$row->xValue*$row->amount, ]); $comm_salesorder_value_sum+=$comm_salesorder_value; @endphp {{ModFinancial::formatMoney($comm_salesorder_value,'pt_BR')}} @else {{ModFinancial::formatMoney($row->xValue,'pt_BR')}} @endif @if($record_salesorder->idPaymentMethod==2) {{ModFinancial::formatMoney($row->xValue*$row->amount,'pt_BR')}} @else {{ModFinancial::formatMoney($row->xValue*$row->amount,'pt_BR')}} @endif @php $sum_prodserv_value+=$row->xValue*$row->amount; @endphp @php $record_fin_condition_calc = ModToolStatus::finConditionCalc([ // 'idStatus'=>$prodserv_comm_calc, 'optionList'=>'g', 'optionListQtt'=>'a', ]); @endphp
{{ModFinancial::formatMoney($row->commissionValue,'pt_BR')}} @php $sum_prodserv_comm_seller+=$row->commissionValue @endphp
Frete: R$ {{ModFinancial::formatMoney($record_salesorder->shippingFee,'pt_BR')}}
COMISSÃO

Total: R$ {{ ModFinancial::formatMoney($comm_salesorder_value_sum,'pt_BR')}} | {{ ModFinancial::formatMoney($record_salesorder->shippingFee+$sum_prodserv_value,'pt_BR')}}

Total: R$ {{ ModFinancial::formatMoney($sum_prodserv_comm_seller,'pt_BR')}}


@if($id_status_fin_debt != 1) @else    PAGO    @endif
@if($response==1)

Alterado com suscesso!

@endif
@include('mod-fin-commission-payment.script-salesorder-commission-prodserv') @if($response==1) @endif