@php use App\Http\Controllers\Mod\ModCommissionSales;use App\Http\Controllers\Mod\ModFinancialCommissionPaymentSalesSalesOrder;use App\Http\Controllers\Mod\ModPaymentMethodRecurrent;use App\Http\Controllers\Mod\ModProductService;use App\Http\Controllers\Mod\ModSalesOrderCommissionParticipation;use App\Http\Controllers\Mod\ModSalesOrderPaymentMethod;use App\Http\Controllers\Mod\ModSalesOrderProductService;use App\Http\Controllers\ModFinancial;use App\Models\Profile;use Illuminate\Support\Facades\Crypt; use App\Http\Controllers\Mod\ModSalesOrderCNPJ; use App\Http\Controllers\Mod\ModSalesOrderViewsOrderService; use \App\Http\Controllers\ModCronos; @endphp
@if($id_payment_method==2) @endif @if($perm_prodserv == 1) @endif @php //------------------------------------------------------------------------------------------------------ //soma total dos produtos e serviços // $comm_salesorder_prodserv_valeu_sum =0; //PROPOSTA //RESULTADOS DAS VENDAS: $comm_salesorder_value_total=0; //COMISSIONAMENTO "SELECIONADO": //VALOR SALVO: $comm_salesorder_value_total_save = 0; //COMISSIONAMENTO PAGO: $comm_salesorder_value_total_pag = 0; //------------------------------------------------------------------------------------------------------ //PROD/SERV //RESULTADOS DAS VENDAS: $comm_salesorder_prodserv_valeu_total=0; //COMISSIONAMENTO "SELECIONADO": //VALOR SALVO: $comm_salesorder_prodserv_valeu_total_save = 0; //COMISSIONAMENTO PAGO: $comm_salesorder_prodserv_valeu_total_pag = 0; $n_proposal=0; @endphp @foreach($record as $row) @php //-------------------------------------------------------------------------------------------------- $comm_salesorder_value=0; $record_participation_count=0; $comm_salesorder_value_sum=0; $comm_salesorder_value_rec=0; $comm_salesorder_value_media_sum=0; //-------------------------------------------------------------------------------------------------- $comm_qtt=0; $comm_salesorder_prodserv_valeu=0; //VENDEDOR: $profile_seller=Profile::user($row->idUserResponsible); //-------------------------------------------------------------------------------------------------- //FINANCEIRO: //COMISSIONAMENTO: PROPOSTA SAVA OU PAGA $record_fin_comm_salesorder = ModFinancialCommissionPaymentSalesSalesOrder::information([ // 'selectString'=>'idFinancialPayCommissionSalesOrder,idSalesOrderCkeck,idStatusReg,idStatusFinDebt,salesOrderValue,idSalesOrderCkeck,salesOrderProdServValue', 'idSalesOrder'=>$row->idSalesOrder, 'idStatusReg'=>'1,12', 'orderByName'=>'idFinancialPayCommissionSalesOrder', 'orderBy' =>'orderByDesc', ]); $id_salesorder_ckeck = isset($record_fin_comm_salesorder->idSalesOrderCkeck)?$record_fin_comm_salesorder->idSalesOrderCkeck:null; $id_statusreg = isset($record_fin_comm_salesorder->idStatusReg)?$record_fin_comm_salesorder->idStatusReg:null; //$id_status_fin_debt = isset($record_fin_comm_salesorder->idStatusFinDebt)?$record_fin_comm_salesorder->idStatusFinDebt:null; $id_salesorder = $row->idSalesOrder; $id_salesorder_crypt = Crypt::encrypt($row->idSalesOrder); $id_status_fin_debt = isset($record_fin_comm_salesorder->idStatusFinDebt)?$record_fin_comm_salesorder->idStatusFinDebt:null; $comm_salesorder_prodserv_valeu = isset($record_fin_comm_salesorder->salesOrderProdServValue)?$record_fin_comm_salesorder->salesOrderProdServValue:null; //-------------------------------------------------------------------------------------------------- //COMISSIONAMENTO NÃO PAGO if($id_status_fin_debt != 1){ //-------------------------------------------------------------------------------------------------- //PROPOSTA: //PROPOSTA: EVENTUAL >> VALOR: PRODUTOS E SERVIÇOS if($id_payment_method == 1){ //----------------------------------------------------------------------------------------- //-------| FORMA DE PAGAMENTO: EVENTUAL $record_method = ModSalesOrderPaymentMethod::paymentMethod('0', $row->idSalesOrder); foreach ($record_method as $row_method) { $comm_salesorder_value += isset($row_method->quotaValue) ? $row_method->quotaValue : 0; } //$comm_salesorder_value+=$comm_salesorder_value; //---------------------------------------------- //----| CONSULTA //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'=> $row->idUserResponsible, 'idPaymentMethod'=> $id_payment_method, 'idStatusCommissionProdServ'=>1, //ATIVO o comissionamento 'idStatusReg'=>1, 'optionList'=>'g', ]); //PROPOSTA PAGA //Se NÃO FOR PAGO //if($id_status_fin_debt != 1){ $record_commission_count= count($record_commission); if($record_commission_count >0){ //COMISSIONAMENTO: PRODUTOS E SERVIÇOS //Esta consulta é devido as propostas que não tem registro de valor de comissionamento //Criada esta ferramenta de comissionamento posterior as propostas. $record_commission_prodserv = ModSalesOrderProductService::information([ 'selectString'=>'idSalesOrderProdServ,idSalesOrder,idProductService,xName,amount,xValueOriginal,xValue,xValueIncrease,xValueDiscount,idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idSalesOrder'=>$row->idSalesOrder, 'idBonus'=>2, 'idStatusReg'=>1, 'optionList'=>'g', 'optionListQtt'=>'a', ]); foreach ($record_commission_prodserv as $row_commission_prodsev){ $comm_salesorder_value_sum +=$row_commission_prodsev->xValue*$row_commission_prodsev->amount; //DECLARACAO $prodserv_value = $row_commission_prodsev->xValue*$row_commission_prodsev->amount; $prodserv_comm_status = $row_commission_prodsev->idStatusCommissionProdServ; $prodserv_comm_calc = $row_commission_prodsev->idStatusFinConditionCalc; $prodserv_comm_value = $row_commission_prodsev->commissionCalcValue; //URGENTE: PERIODO DE 12 MESES 16/06/2023 //PARA COMPATIBILIZAR VERÇÕES DE PROPOSTA ANTIGAS if( $row_commission_prodsev->idStatusCommissionProdServ == 60){ $record_prodsev = ModProductService::information([ 'selectString'=>'idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idProductService'=>$row_commission_prodsev->idProductService, ]); $prodserv_comm_status = $record_prodsev->idStatusCommissionProdServ; $prodserv_comm_calc = $record_prodsev->idStatusFinConditionCalc; $prodserv_comm_value = $record_prodsev->commissionCalcValue; } if($prodserv_comm_calc==1){ //PRODUTOS E SERVIÇOS: % PORCETAGEM $comm_salesorder_prodserv_valeu = ModFinancial::porcentagem($prodserv_value,$prodserv_comm_value); }else{ //PRODUTOS E SERVIÇOS: $ VALOR FIXO $comm_salesorder_prodserv_valeu = $prodserv_comm_value; } } //---------------------------------------- //---| COMISSIONAMENTO: MEDIA //ATIVO if($prodserv_comm_status==1){ $comm_qtt++; if($prodserv_comm_calc==1){ // % PORCENTAGEM $comm_salesorder_value_media_sum+=$prodserv_comm_value; }else{ // $ VALOR FIXO $comm_salesorder_value_media_sum+=$prodserv_comm_value; } } $comm_salesorder_value=$comm_salesorder_value_sum; // } }else{ //COMISSIONAMENTO: PRODUTOS E SERVIÇOS //Esta consulta é devido as propostas que não tem registro de valor de comissionamento //Criada esta ferramenta de comissionamento posterior as propostas. $record_commission_prodserv = ModSalesOrderProductService::information([ 'selectString' => 'idSalesOrderProdServ,idSalesOrder,idProductService,xName,amount,xValueOriginal,xValue,xValueIncrease,xValueDiscount,idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idSalesOrder' => $row->idSalesOrder, 'idBonus' => 2, 'idStatusReg' =>1, 'optionList' => 'g', 'optionListQtt' => 'a', ]); } //================================================================================================= //RECORRENTE }else if($id_payment_method == 2){ //----------------------------------------------------------------------------------------- //-------| FORMA DE PAGAMENTO: RECORRENTE $record_commission_prodserv = ModSalesOrderProductService::information([ 'selectString' => 'idSalesOrderProdServ,idSalesOrder,idProductService,xName,amount,xValueOriginal,xValue,xValueIncrease,xValueDiscount,idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idSalesOrder' => $row->idSalesOrder, 'idBonus' => 2, 'idStatusReg' => 1, 'optionList' => 'g', 'optionListQtt' => 'a', ]); $comm_salesorder_value_result=0; $comm_salesorder_value_bruto=0; foreach ($record_commission_prodserv as $row_commission_prodsev){ $comm_salesorder_value_sum += $row_commission_prodsev->xValue; $comm_salesorder_value_rec += $row_commission_prodsev->xValue*$row_commission_prodsev->amount; //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($row->idPaymentMethod)?$row->idPaymentMethod:null, 'idPaymentMethodRecurrent' => isset($row->idPaymentMethodRecurrent)?$row->idPaymentMethodRecurrent:null, 'value' =>$row_commission_prodsev->xValue*$row_commission_prodsev->amount, ]); //DISCONTO //$comm_salesorder_value=$comm_salesorder_value; $comm_salesorder_value_dis=ModFinancial::porcentagem($comm_salesorder_value,$row_commission_prodsev->xValueDiscount); $comm_salesorder_value=$comm_salesorder_value-$comm_salesorder_value_dis; //ACRESCIMO $comm_salesorder_value_inc=ModFinancial::porcentagem($comm_salesorder_value,$row_commission_prodsev->xValueIncrease); $comm_salesorder_value=$comm_salesorder_value-$comm_salesorder_value_inc; //dump($comm_salesorder_value,$comm_salesorder_value_inc); //DECLARACAO $prodserv_value = $row_commission_prodsev->xValue*$row_commission_prodsev->amount; $prodserv_comm_status = $row_commission_prodsev->idStatusCommissionProdServ; $prodserv_comm_calc = $row_commission_prodsev->idStatusFinConditionCalc; $prodserv_comm_value = $row_commission_prodsev->commissionCalcValue; //URGENTE: PERIODO DE 12 MESES 16/06/2023 //PARA COMPATIBILIZAR VERÇÕES DE PROPOSTA ANTIGAS if( $row_commission_prodsev->idStatusCommissionProdServ == 60){ $record_prodsev = ModProductService::information([ 'selectString'=>'idStatusCommissionProdServ,idStatusFinConditionCalc,commissionCalcValue', 'idProductService'=>$row_commission_prodsev->idProductService, ]); $prodserv_comm_status = $record_prodsev->idStatusCommissionProdServ; $prodserv_comm_calc = $record_prodsev->idStatusFinConditionCalc; $prodserv_comm_value = $record_prodsev->commissionCalcValue; } $comm_salesorder_value_bruto+=$comm_salesorder_value; if($prodserv_comm_calc==1){ //$comm_salesorder_value //$prodserv_value //PRODUTOS E SERVIÇOS: % PORCETAGEM //premiacao $comm_salesorder_prodserv_valeu += ModFinancial::porcentagem($comm_salesorder_value,$prodserv_comm_value); }else{ //PRODUTOS E SERVIÇOS: $ VALOR FIXO $comm_salesorder_prodserv_valeu = $prodserv_comm_value; } //PATICIPACAO DO COMISSIONAMENTO DA VENDA $record_participation = ModSalesOrderCommissionParticipation::informationView([ //'selectString'=>'idSalesOrderPartic,idUserParticipation,xName', //'idPartnerType'=> 1, 'idSalesOrder'=> $row->idSalesOrder, 'idStatusReg'=>1, 'optionList'=>'g', 'optionListQtt'=> 'a', ]); //---------------------------------------- //---| COMISSIONAMENTO: MEDIA //ATIVO if($prodserv_comm_status==1){ $comm_qtt++; if($prodserv_comm_calc==1){ // % PORCENTAGEM $comm_salesorder_value_media_sum+=$prodserv_comm_value; }else{ // $ VALOR FIXO $comm_salesorder_value_media_sum+=$prodserv_comm_value; } } }//endforeach //PARCEIRO DE NEGOCIO / COMISSIONADO $record_participation_count=1; foreach ( $record_participation as $row_participation){ if( $row_participation->idPartnerType == 1){ $record_participation_count++; }else{ $record_participation_count=1; } } $comm_salesorder_prodserv_valeu= $comm_salesorder_prodserv_valeu/$record_participation_count; $comm_salesorder_value_result += $comm_salesorder_value; if($comm_qtt!=0){ $comm_salesorder_value_media_sum=$comm_salesorder_value_media_sum/$comm_qtt; } // $comm_salesorder_value=$comm_salesorder_value_sum; }else{ echo "

Selecione a vendas: Recorrente ou Eventual

"; exit; } }else{ //-------------------------------------------------------------------------------------------------- //-----| PAGO $comm_salesorder_value = isset($record_fin_comm_salesorder->salesOrderValue)?$record_fin_comm_salesorder->salesOrderValue:0; $comm_salesorder_prodserv_valeu = isset($record_fin_comm_salesorder->salesOrderProdServValue)?$record_fin_comm_salesorder->salesOrderProdServValue:0; $comm_salesorder_value_media_sum =isset($record_fin_comm_salesorder->salesOrderProdServMedia)?$record_fin_comm_salesorder->salesOrderProdServMedia:0; $comm_qtt =isset($record_fin_comm_salesorder->salesOrderProdServMediaQtt)?$record_fin_comm_salesorder->salesOrderProdServMediaQtt:0; // $record_participation = ModSalesOrderCommissionParticipation::information([ // //'selectString'=>'idSalesOrderPartic,idUserParticipation,xName', // 'idSalesOrder'=> $row->idSalesOrder, // 'idStatusReg'=>1, // 'optionList'=>'g', // 'optionListQtt'=> 'a', // // ]); //PATICIPACAO DO COMISSIONAMENTO DA VENDA $record_participation = ModSalesOrderCommissionParticipation::informationView([ //'selectString'=>'idSalesOrderPartic,idUserParticipation,xName', //'idPartnerType'=> 1, 'idSalesOrder'=> $row->idSalesOrder, 'idStatusReg'=>1, 'optionList'=>'g', 'optionListQtt'=> 'a', ]); //PARCEIRO DE NEGOCIO / COMISSIONADO $record_participation_count=1; foreach ( $record_participation as $row_participation){ if( isset($row_participation->idPartnerType)?$row_participation->idPartnerType:null == 1){ $record_participation_count++; }else{ $record_participation_count=1; } } } //Tratamente se for vasio if(empty($comm_salesorder_prodserv_valeu)){ $comm_salesorder_prodserv_valeu=0.00; } @endphp {{-- STATUS --}} @if($id_payment_method==2)
PEDIDO STATUS CLIENTE PROPOSTA MÉDIA PREMIAÇÃO STATUS
@if(!empty($id_seller)) @if($perm_prodserv == 1) @endif @endif
| Negociação: {{$row->idNegotiation}}
| Proposta: {{$row->idSalesOrder}}
| Vendedor: {{ModCronos::convertDateBR($row->clientAcceptedValidationDate)}}
$:
{{--CNPJ--}}
Fatal error: Uncaught Error: Class "ModSalesOrderCNPJ" not found in /home/admgocrm/public_html/crm/dev/crmviews/mod-fin-commission-payment-per-seller/account-payable-table-eve.blade.php:471 Stack trace: #0 {main} thrown in /home/admgocrm/public_html/crm/dev/crmviews/mod-fin-commission-payment-per-seller/account-payable-table-eve.blade.php on line 471