@php use App\Http\Controllers\Mod\ModFinancialCommissionPayment; use App\Http\Controllers\ModTool; use App\Http\Controllers\ModCronos; use \App\Http\Controllers\ModFinancial; // $record_fin_commission_pay = ModFinancialCommissionPayment::informationPaySales([ // 'idUserCommission' => $id_user, // 'idPaymentMethod' => 1, //RECORRENTE // 'idStatusFinDebt' => 1, //PAGO // 'idStatusRegSales' => 1, //ATIVO // 'idStatusRegTable' => 1, //ATIVO // // 'dateMonth' => 7, // 'dateYear' => $date_year, // 'optionList' => 'f', // // ]); $option_value_rec=''; $option_monthe=''; $grafic_value_event=''; @endphp @for($i = $date_monthe_retroact+1; $i <= $date_monthe; $i++) {{-- $record = DB::table('mod_fin_commission_pay_sales')--}} {{-- ->where([--}} {{-- 'idUserCommission'=>$profile->idUser,--}} {{-- 'idStatusReg' => 1,--}} {{-- 'idStatusFinDebt' => 1,--}} {{-- 'idManager' => $profile->idManager,--}} @php $record_fin_commission_pay_rec = ModFinancialCommissionPayment::informationPaySales([ 'idUserCommission' => $id_user, 'idPaymentMethod' => 1, //RECORRENTE 'idStatusFinDebt' => 1, //PAGO 'idStatusRegSales' => 1, //ATIVO 'idStatusRegTable' => 1, //ATIVO 'dateMonth' => $i, 'dateYear' => $date_year, 'optionList' => 'f', ]); $record_fin_commission_pay_event = ModFinancialCommissionPayment::informationPaySales([ 'idUserCommission' => $id_user, 'idPaymentMethod' => 2, //EVENTUAL 'idStatusFinDebt' => 1, //PAGO 'idStatusRegSales' => 1, //ATIVO 'idStatusRegTable' => 1, //ATIVO 'dateMonth' => $i, 'dateYear' => $date_year, 'optionList' => 'f', ]); $option_monthe.= "'".strtoupper(ModCronos::numbersToMonth($i-1))."',"; $option_value_rec_i=isset($record_fin_commission_pay_rec->commissionSalesOrderValue)?$record_fin_commission_pay_rec->commissionSalesOrderValue:0; $option_value_rec.= "'".intval($option_value_rec_i)."',"; $grafic_value_event_i=isset($record_fin_commission_pay_event->commissionProdServValue)?$record_fin_commission_pay_event->commissionProdServValue:0; $grafic_value_event .= "'".$grafic_value_event_i."',"; @endphp @endfor @php $grafic_monthe =ModTool::substr_right($option_monthe,1); $grafic_value_rec = ModTool::substr_right($option_value_rec,1); $grafic_value_event = ModTool::substr_right($grafic_value_event,1); @endphp {{--{{ dd($grafic_monthe,$grafic_value_rec,$grafic_value_event,) }}--}}