Semana=15<br>sql=select DATA_INICIO, DATA_FIM, NUMERO_SEMANA from semana where CODIGO = 15<br>data Início=2026-02-02 00:00:00<br>data Fim=2026-02-08 23:59:59<br><br>dataInicioSaqueAntecipado=2026-02-03<br>dataFimSaqueAntecipado=2026-02-09<br>sql=select distinct driver_id from RunningDeliveries where created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and driver_id > 0 and status in (6,10) union select distinct driver_id from RunningTaxiDrivers where created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and driver_id > 0 and status in (6,10) order by driver_id<br><br>Driver=4<br>CódCidade=146<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 4 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 4 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=9900.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 4 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=9900<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=9900<br><br>Qtd Diarias Delivery=1<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 4 group by DRIVER_ID<br>Valor Diarias Normais=<br>Valor Diarias Prime=0<br>Valor Diarias Geral=1980<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 4 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=0<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 4 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=1.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 4 group by driver_id<br>Valor em R$ lançado como avulso =0<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 4 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =7919<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 4 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =7919<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 4, 146, 0, 9900,0, 0,1,0, 0, 1980,0,1.00,0,0,7919, 0, 7919, 0);<br><br>Driver=269<br>CódCidade=150<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 269 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 269 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=61515.75<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 269 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=61515.75<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=61515.75<br><br>Qtd Diarias Delivery=1<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 269 group by DRIVER_ID<br>Valor Diarias Normais=1980<br>Valor Diarias Prime=0<br>Valor Diarias Geral=12303.15<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 269 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=0<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 269 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=0.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 269 group by driver_id<br>Valor em R$ lançado como avulso =260000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 269 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =52000.00<br>Resultado Semana Atual =257212.6<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 269 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =257212.6<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 269, 150, 0, 61515.75,0, 0,1,0, 0, 12303.15,0,0.00,260000.00,52000.00,257212.6, 0, 257212.6, 0);<br><br>Driver=272<br>CódCidade=146<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 272 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 272 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=47533.37<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 272 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=47533.37<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=47533.37<br><br>Qtd Diarias Delivery=0<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 272 group by DRIVER_ID<br>Valor Diarias Normais=12303.15<br>Valor Diarias Prime=0<br>Valor Diarias Geral=9506.68<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 272 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=0<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 272 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=0<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 272 group by driver_id<br>Valor em R$ lançado como avulso =0<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 272 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =38026.69<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 272 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =38026.69<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 272, 146, 0, 47533.37,0, 0,0,0, 0, 9506.68,0,0,0,0,38026.69, 0, 38026.69, 0);<br><br>Driver=436<br>CódCidade=146<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 436 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 436 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=60000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 436 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=60000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=60000<br><br>Qtd Diarias Delivery=2<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 436 group by DRIVER_ID<br>Valor Diarias Normais=9506.68<br>Valor Diarias Prime=0<br>Valor Diarias Geral=12000<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 436 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=3.498<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 436 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=0.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 436 group by driver_id<br>Valor em R$ lançado como avulso =185000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 436 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =37000.00<br>Resultado Semana Atual =196003.498<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 436 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =196003.498<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 436, 146, 0, 60000,0, 0,2,0, 0, 12000,3.498,0.00,185000.00,37000.00,196003.498, 0, 196003.498, 0);<br><br>Driver=441<br>CódCidade=150<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 441 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 441 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=33824.80<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 441 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=33824.8<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=33824.8<br><br>Qtd Diarias Delivery=1<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 441 group by DRIVER_ID<br>Valor Diarias Normais=12000<br>Valor Diarias Prime=0<br>Valor Diarias Geral=6764.96<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 441 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=0<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 441 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=0.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 441 group by driver_id<br>Valor em R$ lançado como avulso =90000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 441 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =18000.00<br>Resultado Semana Atual =99059.84<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 441 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =99059.84<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 441, 150, 0, 33824.8,0, 0,1,0, 0, 6764.96,0,0.00,90000.00,18000.00,99059.84, 0, 99059.84, 0);<br><br>Driver=442<br>CódCidade=146<br>valorDinheiroDelivery=0<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 0<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 442 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>Cartão (Delivery e Transporte) = 0<br>TaxaCartao=0<br>sqlVoucherN=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id not in (3411, 3412, 3413, 3414, 3415, 3282, 3226, 3482, 3589, 3704, 3586,  1557) and driver_id = 442 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=89202.06<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 442 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=89202.06<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=89202.06<br><br>Qtd Diarias Delivery=1<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 15 and DRIVER_ID = 442 group by DRIVER_ID<br>Valor Diarias Normais=6764.96<br>Valor Diarias Prime=0<br>Valor Diarias Geral=17840.41<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 442 group by driver_id<br>Qtd Créditos Relativos a Cancelamentos do Estab=0<br>sql=select driver_id, sum(debit) AS qtdDebitos from DriverExtracts WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' and status = 1 and driver_id = 442 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=0.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 442 group by driver_id<br>Valor em R$ lançado como avulso =25000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 15 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 442 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =5000.00<br>Resultado Semana Atual =91361.65<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 15 AND DRIVER_ID = 442 and SALDO_PAGO_SIM_NAO = 0<br>Não há saldo da semana anterior!<br>SaldoAnterior=0<br>Não há Lançamento Anterior Pendente em Aberto!<br>SaldoLançamentoExtra=0<br>Qtd Compras Conveniados = 0<br>Qtd Saques Antecipados = 0<br>SaldoCorrente =91361.65<br>insert=INSERT IGNORE INTO extrato_semanal (CODIGO_SEMANA, DRIVER_ID, CODIGO_CIDADE, VALOR_DINHEIRO, VALOR_VOUCHER, VALOR_CARTAO,VALOR_TAXAS_CARTAO, QUANTIDADE_DIARIAS, QTD_CORRIDAS_DELIVERY, QTD_CORRIDAS_PASSAGEIRO, VALOR_DIARIAS, CREDITOS_CANCELAMENTOS, DEBITOS_CANCELAMENTOS, VALOR_AVULSO_LANCADO, DIARIA_SOBRE_AVULSO, RESULTADO_SEMANA_ATUAL, SALDO_SEMANA_ANTERIOR,SALDO_CORRENTE, SALDO_PAGO_SIM_NAO) VALUES (15, 442, 146, 0, 89202.06,0, 0,1,0, 0, 17840.41,0,0.00,25000.00,5000.00,91361.65, 0, 91361.65, 0);<br>sql=select driver_id , sum(value) as totalDin from RunningDeliveries WHERE created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59' AND status in (6,10)  and driver_id = 442 and id in (select running_delivery_id from RequestDeliveries where typePayment = 1 and created_at BETWEEN '2026-02-02 00:00:00' AND '2026-02-08 23:59:59') group by driver_id<br>qtd_empresas=3<br><br>processo FINALIZADO!!