Semana=16<br>sql=select DATA_INICIO, DATA_FIM, NUMERO_SEMANA from semana where CODIGO = 16<br>data Início=2026-04-05 00:00:00<br>data Fim=2026-04-12 23:59:59<br><br>dataInicioSaqueAntecipado=2026-04-06<br>dataFimSaqueAntecipado=2026-04-13<br>sql=select distinct driver_id from RunningDeliveries where created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and driver_id > 0 and status in (6,10) union select distinct driver_id from RunningTaxiDrivers where created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and driver_id > 0 and status in (6,10) order by driver_id<br><br>Driver=36<br>CódCidade=146<br>valorDinheiroDelivery=30000.00<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 30000<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10)  and driver_id = 36 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 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-04-05 00:00:00' AND '2026-04-12 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 = 36 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=0<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 36 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=0<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=0<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 = 16 and DRIVER_ID = 36 group by DRIVER_ID<br>Valor Diarias Normais=<br>Valor Diarias Prime=0<br>Valor Diarias Geral=8502.8<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 36 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-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and driver_id = 36 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 36 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 36 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =-8502.8<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 16 AND DRIVER_ID = 36 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 =-8502.8<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 (16, 36, 146, 30000, 0,0, 0,1,0, 0, 8502.8,0,0,0,0,-8502.8, 0, -8502.8, 0);<br><br>Driver=399<br>CódCidade=146<br>valorDinheiroDelivery=179046.64<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 179046.64<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10)  and driver_id = 399 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 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-04-05 00:00:00' AND '2026-04-12 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 = 399 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=0<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 399 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=0<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=0<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 = 16 and DRIVER_ID = 399 group by DRIVER_ID<br>Valor Diarias Normais=8502.8<br>Valor Diarias Prime=0<br>Valor Diarias Geral=35809.33<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 399 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-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and driver_id = 399 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 399 group by driver_id<br>Valor em R$ lançado como avulso =475000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 399 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =95000.00<br>Resultado Semana Atual =344190.67<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 16 AND DRIVER_ID = 399 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 =344190.67<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 (16, 399, 146, 179046.64, 0,0, 0,0,0, 0, 35809.33,0,0.00,475000.00,95000.00,344190.67, 0, 344190.67, 0);<br><br>Driver=412<br>CódCidade=146<br>valorDinheiroDelivery=54846.00<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 54846<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10)  and driver_id = 412 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 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-04-05 00:00:00' AND '2026-04-12 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 = 412 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=0<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 412 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=0<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=0<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 = 16 and DRIVER_ID = 412 group by DRIVER_ID<br>Valor Diarias Normais=35809.33<br>Valor Diarias Prime=0<br>Valor Diarias Geral=10969.2<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 412 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-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and driver_id = 412 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 412 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 412 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =-10969.2<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 16 AND DRIVER_ID = 412 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 =-10969.2<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 (16, 412, 146, 54846, 0,0, 0,2,0, 0, 10969.2,0,0,0,0,-10969.2, 0, -10969.2, 0);<br><br>Driver=518<br>CódCidade=150<br>valorDinheiroDelivery=56515.83<br>valorDinheiroTransporte=<br>Dinheiro(Delivery e Transporte) = 56515.83<br>sql=select driver_id , sum(value) as totalCartaoT from RunningTaxiDrivers WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10)  and driver_id = 518 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 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-04-05 00:00:00' AND '2026-04-12 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 = 518 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=0<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 518 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=0<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=0<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 = 16 and DRIVER_ID = 518 group by DRIVER_ID<br>Valor Diarias Normais=10969.2<br>Valor Diarias Prime=0<br>Valor Diarias Geral=11303.17<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 518 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-04-05 00:00:00' AND '2026-04-12 23:59:59' and status = 1 and driver_id = 518 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 518 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 = 16 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 518 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =-11303.17<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 16 AND DRIVER_ID = 518 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 =-11303.17<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 (16, 518, 150, 56515.83, 0,0, 0,1,0, 0, 11303.17,0,0,0,0,-11303.17, 0, -11303.17, 0);<br>sql=select driver_id , sum(value) as totalDin from RunningDeliveries WHERE created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59' AND status in (6,10)  and driver_id = 518 and id in (select running_delivery_id from RequestDeliveries where typePayment = 1 and created_at BETWEEN '2026-04-05 00:00:00' AND '2026-04-12 23:59:59') group by driver_id<br>qtd_empresas=3<br><br>processo FINALIZADO!!