Semana=13<br>sql=select DATA_INICIO, DATA_FIM, NUMERO_SEMANA from semana where CODIGO = 13<br>data Início=2026-01-19 00:00:00<br>data Fim=2026-01-25 23:59:59<br><br>dataInicioSaqueAntecipado=2026-01-20<br>dataFimSaqueAntecipado=2026-01-26<br>sql=select distinct driver_id from RunningDeliveries where created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' and driver_id > 0 and status in (6,10) union select distinct driver_id from RunningTaxiDrivers where created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' and driver_id > 0 and status in (6,10) order by driver_id<br><br>Driver=171<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-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10)  and driver_id = 171 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 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-01-19 00:00:00' AND '2026-01-25 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 = 171 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=10000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 171 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=10000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=10000<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 = 13 and DRIVER_ID = 171 group by DRIVER_ID<br>Valor Diarias Normais=<br>Valor Diarias Prime=0<br>Valor Diarias Geral=2000<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 171 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-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and driver_id = 171 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 = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 171 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 = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 171 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =8000<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 13 AND DRIVER_ID = 171 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 =8000<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 (13, 171, 146, 0, 10000,0, 0,1,0, 0, 2000,0,0,0,0,8000, 0, 8000, 0);<br><br>Driver=421<br>CódCidade=158<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-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10)  and driver_id = 421 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 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-01-19 00:00:00' AND '2026-01-25 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 = 421 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=25000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 421 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=25000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=25000<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 = 13 and DRIVER_ID = 421 group by DRIVER_ID<br>Valor Diarias Normais=2000<br>Valor Diarias Prime=0<br>Valor Diarias Geral=5000<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 421 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-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and driver_id = 421 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 = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 421 group by driver_id<br>Valor em R$ lançado como avulso =20000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 421 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =4000.00<br>Resultado Semana Atual =36000<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 13 AND DRIVER_ID = 421 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 =36000<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 (13, 421, 158, 0, 25000,0, 0,1,0, 0, 5000,0,0.00,20000.00,4000.00,36000, 0, 36000, 0);<br><br>Driver=426<br>CódCidade=158<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-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10)  and driver_id = 426 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 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-01-19 00:00:00' AND '2026-01-25 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 = 426 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=20000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 426 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=20000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=20000<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 = 13 and DRIVER_ID = 426 group by DRIVER_ID<br>Valor Diarias Normais=5000<br>Valor Diarias Prime=0<br>Valor Diarias Geral=4000<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 426 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-01-19 00:00:00' AND '2026-01-25 23:59:59' and status = 1 and driver_id = 426 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 = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 426 group by driver_id<br>Valor em R$ lançado como avulso =50000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 13 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 426 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =10000.00<br>Resultado Semana Atual =56000<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 13 AND DRIVER_ID = 426 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 =56000<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 (13, 426, 158, 0, 20000,0, 0,1,0, 0, 4000,0,0.00,50000.00,10000.00,56000, 0, 56000, 0);<br>sql=select driver_id , sum(value) as totalDin from RunningDeliveries WHERE created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59' AND status in (6,10)  and driver_id = 426 and id in (select running_delivery_id from RequestDeliveries where typePayment = 1 and created_at BETWEEN '2026-01-19 00:00:00' AND '2026-01-25 23:59:59') group by driver_id<br>qtd_empresas=1<br><br>processo FINALIZADO!!