Semana=4<br>sql=select DATA_INICIO, DATA_FIM, NUMERO_SEMANA from semana where CODIGO = 4<br>data Início=2025-10-20 00:00:00<br>data Fim=2025-10-26 23:59:59<br><br>dataInicioSaqueAntecipado=2025-10-21<br>dataFimSaqueAntecipado=2025-10-27<br>sql=select distinct driver_id from RunningDeliveries where created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and driver_id > 0 and status in (6,10) union select distinct driver_id from RunningTaxiDrivers where created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and driver_id > 0 and status in (6,10) order by driver_id<br><br>Driver=66<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 66 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 66 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=372000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 66 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=372000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=372000<br><br>Qtd Diarias Delivery=3<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 66 group by DRIVER_ID<br>Valor Diarias Normais=<br>Valor Diarias Prime=0<br>Valor Diarias Geral=74400<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 66 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 66 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 66 group by driver_id<br>Valor em R$ lançado como avulso =1184500.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 66 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =236900.00<br>Resultado Semana Atual =1245200<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 66 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 =1245200<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 (4, 66, 146, 0, 372000,0, 0,3,0, 0, 74400,0,0.00,1184500.00,236900.00,1245200, 0, 1245200, 0);<br><br>Driver=74<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 74 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 74 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=590000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 74 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=590000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=590000<br><br>Qtd Diarias Delivery=5<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 74 group by DRIVER_ID<br>Valor Diarias Normais=74400<br>Valor Diarias Prime=0<br>Valor Diarias Geral=118000<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 74 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 74 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 74 group by driver_id<br>Valor em R$ lançado como avulso =744000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 74 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =148800.00<br>Resultado Semana Atual =1067200<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 74 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 =1067200<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 (4, 74, 146, 0, 590000,0, 0,5,0, 0, 118000,0,0.00,744000.00,148800.00,1067200, 0, 1067200, 0);<br><br>Driver=101<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 101 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 101 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=666000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 101 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=666000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=666000<br><br>Qtd Diarias Delivery=4<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 101 group by DRIVER_ID<br>Valor Diarias Normais=118000<br>Valor Diarias Prime=0<br>Valor Diarias Geral=133200<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 101 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 101 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 101 group by driver_id<br>Valor em R$ lançado como avulso =1232500.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 101 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =246500.00<br>Resultado Semana Atual =1518800<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 101 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 =1518800<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 (4, 101, 146, 0, 666000,0, 0,4,0, 0, 133200,0,0.00,1232500.00,246500.00,1518800, 0, 1518800, 0);<br><br>Driver=108<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 108 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 108 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=413000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 108 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=413000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=413000<br><br>Qtd Diarias Delivery=3<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 108 group by DRIVER_ID<br>Valor Diarias Normais=133200<br>Valor Diarias Prime=0<br>Valor Diarias Geral=82600<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 108 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 108 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 108 group by driver_id<br>Valor em R$ lançado como avulso =808000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 108 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =161600.00<br>Resultado Semana Atual =976800<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 108 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 =976800<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 (4, 108, 146, 0, 413000,0, 0,3,0, 0, 82600,0,0.00,808000.00,161600.00,976800, 0, 976800, 0);<br><br>Driver=122<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 122 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 122 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=243000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 122 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=243000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=243000<br><br>Qtd Diarias Delivery=4<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 122 group by DRIVER_ID<br>Valor Diarias Normais=82600<br>Valor Diarias Prime=0<br>Valor Diarias Geral=48600<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 122 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 122 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 122 group by driver_id<br>Valor em R$ lançado como avulso =1852000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 122 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =370400.00<br>Resultado Semana Atual =1676000<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 122 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 =1676000<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 (4, 122, 146, 0, 243000,0, 0,4,0, 0, 48600,0,0.00,1852000.00,370400.00,1676000, 0, 1676000, 0);<br><br>Driver=132<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 132 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 132 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=252000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 132 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=252000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=252000<br><br>Qtd Diarias Delivery=3<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 132 group by DRIVER_ID<br>Valor Diarias Normais=48600<br>Valor Diarias Prime=0<br>Valor Diarias Geral=50400<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 132 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 132 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=2.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 132 group by driver_id<br>Valor em R$ lançado como avulso =1140500.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 132 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =228100.00<br>Resultado Semana Atual =1113998<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 132 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 =1113998<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 (4, 132, 146, 0, 252000,0, 0,3,0, 0, 50400,0,2.00,1140500.00,228100.00,1113998, 0, 1113998, 0);<br><br>Driver=163<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 163 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 163 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherN=68000.00<br>1<br>sqlVoucherPrime=select driver_id , sum(value) as totalVoucher from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 163 and id in (select running_delivery_id from RequestDeliveries where typePayment = 3) group by driver_id<br>VoucherPrime=0<br>valorVoucher=68000<br><br>Valor Taxa Extra Pos = 0<br>Novo ValorVoucher=68000<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 = 4 and DRIVER_ID = 163 group by DRIVER_ID<br>Valor Diarias Normais=50400<br>Valor Diarias Prime=0<br>Valor Diarias Geral=13600<br>sql=select driver_id, sum(credit) AS qtdCreditos from DriverExtracts WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 163 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 163 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 163 group by driver_id<br>Valor em R$ lançado como avulso =486000.00<br>sql=select DRIVER_ID, sum(VALOR_DIARIA) AS totalDiarias from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 163 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =97200.00<br>Resultado Semana Atual =443200<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 163 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 =443200<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 (4, 163, 146, 0, 68000,0, 0,1,0, 0, 13600,0,0.00,486000.00,97200.00,443200, 0, 443200, 0);<br><br>Driver=206<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 206 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 206 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 206 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 = 4 and DRIVER_ID = 206 group by DRIVER_ID<br>Valor Diarias Normais=13600<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 206 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 206 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 206 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 206 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	 < 4 AND DRIVER_ID = 206 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 (4, 206, 146, 0, 10000,0, 0,1,0, 0, 2000,0,0,0,0,8000, 0, 8000, 0);<br><br>Driver=207<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 207 and id in (select running_taxi_driver_id from RequestTaxiDrivers where typePayment = 2 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 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 '2025-10-20 00:00:00' AND '2025-10-26 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 = 207 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10) and company_id in (1557) and driver_id = 207 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=0<br>Qtd Diarias Transporte=0<br>sqlDiariasNormais=select DRIVER_ID, sum(VALOR_DIARIA) as valorDiarias from extrato_diarias WHERE CODIGO_SEMANA = 4 and DRIVER_ID = 207 group by DRIVER_ID<br>Valor Diarias Normais=2000<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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and running_delivery_id > 1 and driver_id = 207 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 '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' and status = 1 and driver_id = 207 group by driver_id<br>Qtd Débitos Relativos a Cancelamentos do prestador=3.00<br>sql=select DRIVER_ID, sum(VALOR_AVULSOS) AS totalAvulsos from extrato_diarias_avulsos WHERE CODIGO_SEMANA = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 207 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 = 4 and ATIVO_SIM_NAO = 1 and DRIVER_ID = 207 group by driver_id<br>Valor das diárias relativas ao avulso Lançado =0<br>Resultado Semana Atual =15997<br>sqlSaldoPendente=select CODIGO, SALDO_CORRENTE from extrato_semanal where CODIGO_SEMANA	 < 4 AND DRIVER_ID = 207 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 =15997<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 (4, 207, 146, 0, 20000,0, 0,0,0, 0, 4000,0,3.00,0,0,15997, 0, 15997, 0);<br>sql=select driver_id , sum(value) as totalDin from RunningDeliveries WHERE created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59' AND status in (6,10)  and driver_id = 207 and id in (select running_delivery_id from RequestDeliveries where typePayment = 1 and created_at BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 23:59:59') group by driver_id<br>qtd_empresas=8<br><br>processo FINALIZADO!!