==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 09:34:06] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 09:34:06] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 09:34:06] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 09:34:06] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 09:34:06] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 09:34:06] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 09:34:06] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:09:04] C:\wamp\www\adv\php\login.php(27) - login("Admir", "HCD309")
[23/06/2024 10:09:04] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "<br><br>            SELECT...", )
[23/06/2024 10:09:04] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>            SELECT...")


            SELECT 
                CODUSU,
                COALESCE(VEALLCLIIGNORACONFIG,0) AS VEALLCLI,
                CADCLI,
                CADCLIALT,
                PERGUNTALOJA,
                CODLOJA,
                LANACEITAMENOSMINIMO,
                ISVENDEDORAFV,
                osmudaprecoprod,
                OSCANCELA,
                TPSAIUSAPENASASSOC as usa_tipo_saida_associado

                
            FROM SENHAS 
            WHERE UPPER(USUARIO) LIKE UPPER('Admir') 
                AND UPPER(SENHA) LIKE UPPER('HCD309') 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:09:04] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:09:04] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:09:04] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:09:05] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("52")
[23/06/2024 10:09:05] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 10:09:05] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:09:12] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:09:12] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:09:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade()
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs()
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...")

SELECT * FROM configinterno 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade()
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs()
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...")

SELECT * FROM configinterno 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select<br><br>            ...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select<br><br>            ...")

select
                        p.qtdeparavnd 
                        , p.codigo
                        , p.codpro
                        , p.ipi
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as unitario
                        , cast((pti.preco - (pti.preco * (100 / 100.00))) as numeric(10,2)) as unitcdesc
                        , (pti.preco * p.ipi / 100) as vlripi
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as precotab
                        , cast((coalesce(pti.precomin,0)) as numeric(10,2)) as precotab5
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as unitario
                        , p.descricao as descricao 
                        , p.fotopqnome
                        , u.un as un
                        , p.fotogr
                        , coalesce(m.naoalteraprecoafv,0) as bloqueiaprecomarca

		from  produtos p
            join prodtabelasitens pti on pti.codpro = p.codpro and pti.codprodtabela = 1
            
            left join marcas m ON m.codmar = p.codmar
            left join UNIDADES u ON u.codun = p.codun

            where  (coalesce(p.cadinativo,0)=0) and (coalesce(p.AFV_OCULTARPRODUTO,0)=0) and (coalesce(p.ativo,0)=1)  AND coalesce(p.usagrade, 0) != 1 AND coalesce(m.NAOMOSTRAAFV, 0) != 1    and (upper(p.codigo) like upper('20 10432') OR  upper(p.descricao) like upper('%20 10432%'))  order by descricao rows 1 to 100 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMPADA BULBO POWER ...", "20 10432", 1, "3078", "5.84", "10.50", "", , , , "../php/buscaprod.php...", "", "10.50", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select coalesce(sum(...")

select coalesce(sum(coalesce(qtdeestoque,0)),0) as qtdeestoque from estoque where codpro = 3078 and codloja = 1



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMPADA BULBO POWER ...", "20 10432", 1, "3078", "5.84", "10.50", "", , , , "../php/buscaprod.php...", "", "10.50", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery(" Select  coalesce(su...")

 Select  coalesce(sum(  I.QtdeNaoEntr ),0) as total
                              From PedidosComp P join PedidosCompItens I on P.CodPedComp = I.CodPedComp
                              Where i.codlojai = 1 and I.codpro = 3078 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMPADA BULBO POWER ...", "20 10432", 1, "3078", "5.84", "10.50", "", , , , "../php/buscaprod.php...", "", "10.50", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery(" Select  coalesce(su...")

 Select  coalesce(sum(  I.QtdeNaoEntr ),0) as total
                              From PedidosComp P join PedidosCompItens I on P.CodPedComp = I.CodPedComp
                              Where i.codlojai = 1 and I.codpro = 3078 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMPADA BULBO POWER ...", "20 10432", 1, "3078", "5.84", "10.50", "", , , , "../php/buscaprod.php...", "", "10.50", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select coalesce(sum(...")

select coalesce(sum(coalesce(qtdeestoque,0)),0) as qtdeestoque from estoque where codpro = 3078 and codloja = 1



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:12:48] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10432", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMPADA BULBO POWER ...", "20 10432", 1, "3078", "5.84", "10.50", "", , , , "../php/buscaprod.php...", "", "10.50", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3078")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[23/06/2024 10:12:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

SELECT limiteestoque as campo FROM config WHERE (1 = 1)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade()
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs()
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...")

SELECT * FROM configinterno 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade()
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs()
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...")

SELECT * FROM configinterno 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select<br><br>            ...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select<br><br>            ...")

select
                        p.qtdeparavnd 
                        , p.codigo
                        , p.codpro
                        , p.ipi
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as unitario
                        , cast((pti.preco - (pti.preco * (100 / 100.00))) as numeric(10,2)) as unitcdesc
                        , (pti.preco * p.ipi / 100) as vlripi
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as precotab
                        , cast((coalesce(pti.precomin,0)) as numeric(10,2)) as precotab5
                        , cast((coalesce(pti.preco,0)) as numeric(10,2)) as unitario
                        , p.descricao as descricao 
                        , p.fotopqnome
                        , u.un as un
                        , p.fotogr
                        , coalesce(m.naoalteraprecoafv,0) as bloqueiaprecomarca

		from  produtos p
            join prodtabelasitens pti on pti.codpro = p.codpro and pti.codprodtabela = 1
            
            left join marcas m ON m.codmar = p.codmar
            left join UNIDADES u ON u.codun = p.codun

            where  (coalesce(p.cadinativo,0)=0) and (coalesce(p.AFV_OCULTARPRODUTO,0)=0) and (coalesce(p.ativo,0)=1)  AND coalesce(p.usagrade, 0) != 1 AND coalesce(m.NAOMOSTRAAFV, 0) != 1    and (upper(p.codigo) like upper('20 10431') OR  upper(p.descricao) like upper('%20 10431%'))  order by descricao rows 1 to 100 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LUMINARIA DE EMERG. ...", "20 10431", 1, "2995", "65.00", "94.25", "", , , , "../php/buscaprod.php...", "", "94.25", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select coalesce(sum(...")

select coalesce(sum(coalesce(qtdeestoque,0)),0) as qtdeestoque from estoque where codpro = 2995 and codloja = 1



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LUMINARIA DE EMERG. ...", "20 10431", 1, "2995", "65.00", "94.25", "", , , , "../php/buscaprod.php...", "", "94.25", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery(" Select  coalesce(su...")

 Select  coalesce(sum(  I.QtdeNaoEntr ),0) as total
                              From PedidosComp P join PedidosCompItens I on P.CodPedComp = I.CodPedComp
                              Where i.codlojai = 1 and I.codpro = 2995 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LUMINARIA DE EMERG. ...", "20 10431", 1, "2995", "65.00", "94.25", "", , , , "../php/buscaprod.php...", "", "94.25", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery(" Select  coalesce(su...")

 Select  coalesce(sum(  I.QtdeNaoEntr ),0) as total
                              From PedidosComp P join PedidosCompItens I on P.CodPedComp = I.CodPedComp
                              Where i.codlojai = 1 and I.codpro = 2995 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LUMINARIA DE EMERG. ...", "20 10431", 1, "2995", "65.00", "94.25", "", , , , "../php/buscaprod.php...", "", "94.25", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select coalesce(sum(...")

select coalesce(sum(coalesce(qtdeestoque,0)),0) as qtdeestoque from estoque where codpro = 2995 and codloja = 1



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:13:06] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "20 10431", , , "../php/buscaprod.php...", , 1)
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LUMINARIA DE EMERG. ...", "20 10431", 1, "2995", "65.00", "94.25", "", , , , "../php/buscaprod.php...", "", "94.25", "1", 100, "0.00", "UN", , "", "0")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2995")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[23/06/2024 10:13:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

SELECT limiteestoque as campo FROM config WHERE (1 = 1)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:20:57] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:20:57] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:20:57] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:20:57] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("52")
[23/06/2024 10:20:57] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 10:20:57] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:21:16] C:\wamp\www\adv\relatorios\relatorio_orcamentos_convertidos.php(284) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 10:21:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 10:21:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:21:22] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\bd_relatorios.inc(162) - isGerente("52")
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:21:22] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\bd_relatorios.inc(165) - GetCodVnd()
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")

SELECT CODVND FROM SENHAS WHERE CODUSU = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:21:22] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\bd_relatorios.inc(172) - qry(, "<br><br>    SELECT<br><br>      ...", )
[23/06/2024 10:21:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>    SELECT<br><br>      ...")


    SELECT
        orc.os as orcamento,
        orc.dataos dataOrcamento,
        os.os osVenda,
        os.dataos dataVenda,
        COALESCE(nf.numnota, '--') as nota,
        l.loja as loja,
        c.razao as cliente,
        ts.tiposaida as tipoSaida,
        v.vendedor as vendedor,
        t.transportadora as transportadora,
        os.total as total
        

    FROM os orc
        JOIN os os ON os.orccodos = orc.codos AND os.tipo = 2
        JOIN lojas l ON l.codloja = orc.codloja
        JOIN clientes c ON c.codcli = orc.codcli
        JOIN tiposaidas ts ON ts.codtiposai = orc.codtiposai
        JOIN vendedores v ON v.codvnd = orc.codvnd
        JOIN transportadora t ON t.codtra = orc.codtra
        LEFT JOIN NOTAFISCAL nf ON nf.codos = os.codos

    WHERE 
        orc.tipo = 1 
        AND orc.dataos >= '2024-06-13'
        AND orc.dataos <= '2024-06- 23'
     and (v.codvnd = 5) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:22:01] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\bd_relatorios.inc(162) - isGerente("52")
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:22:01] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\bd_relatorios.inc(165) - GetCodVnd()
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")

SELECT CODVND FROM SENHAS WHERE CODUSU = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 10:22:01] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\bd_relatorios.inc(172) - qry(, "<br><br>    SELECT<br><br>      ...", )
[23/06/2024 10:22:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>    SELECT<br><br>      ...")


    SELECT
        orc.os as orcamento,
        orc.dataos dataOrcamento,
        os.os osVenda,
        os.dataos dataVenda,
        COALESCE(nf.numnota, '--') as nota,
        l.loja as loja,
        c.razao as cliente,
        ts.tiposaida as tipoSaida,
        v.vendedor as vendedor,
        t.transportadora as transportadora,
        os.total as total
        

    FROM os orc
        JOIN os os ON os.orccodos = orc.codos AND os.tipo = 2
        JOIN lojas l ON l.codloja = orc.codloja
        JOIN clientes c ON c.codcli = orc.codcli
        JOIN tiposaidas ts ON ts.codtiposai = orc.codtiposai
        JOIN vendedores v ON v.codvnd = orc.codvnd
        JOIN transportadora t ON t.codtra = orc.codtra
        LEFT JOIN NOTAFISCAL nf ON nf.codos = os.codos

    WHERE 
        orc.tipo = 1 
        AND orc.dataos >= '2024-06-13'
        AND orc.dataos <= '2024-06-23'
     and (v.codvnd = 5) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:01] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:01] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 15:08:01] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:01] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:01] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 15:08:01] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:01] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[23/06/2024 15:08:09] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) ) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:09] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) )  order by razao rows 1 to 10



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:09] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:09] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #12, "SELECT usuario as ca...")
[23/06/2024 15:08:09] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:09] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:12] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:12] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 15:08:12] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:12] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:12] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 15:08:12] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:12] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[23/06/2024 15:08:25] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Nova", "", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Nova%') ) OR (upper(fantasia) like upper('%Nova%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) ) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Nova", "", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:25] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 258 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Nova", "", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Nova%') ) OR (upper(fantasia) like upper('%Nova%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) )  order by razao rows 1 to 10



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:25] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Nova", "", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:25] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:25] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 258 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:26] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:26] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:26] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:26] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:26] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:26] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #12, "SELECT usuario as ca...")
[23/06/2024 15:08:26] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:26] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:28] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:28] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 15:08:28] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:28] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:28] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 15:08:28] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:28] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[23/06/2024 15:08:48] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) ) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:48] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) )  order by razao rows 1 to 10



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:08:48] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:08:48] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #12, "SELECT usuario as ca...")
[23/06/2024 15:08:48] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:08:48] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:05] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:05] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:05] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:05] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:05] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:05] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #12, "SELECT usuario as ca...")
[23/06/2024 15:09:05] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:05] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:16] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:16] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 15:09:16] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:16] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:16] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 15:09:16] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:16] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[23/06/2024 15:09:22] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) ) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:09:22] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")

SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Oriente%') ) OR (upper(fantasia) like upper('%Oriente%') )  ) and (codvnd = (select codvnd from senhas where codusu =   ) )  order by razao rows 1 to 10



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Oriente", "", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT RAZAO as raza...")
[23/06/2024 15:09:22] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 264 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:09:22] C:\wamp\www\adv\php\msgerro.php(181) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #12, "SELECT usuario as ca...")
[23/06/2024 15:09:22] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:09:22] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:12:24] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:12:24] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "SELECT usuario as ca...")
[23/06/2024 15:12:24] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:12:24] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 15:12:24] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[23/06/2024 15:12:24] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 15:12:24] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 16:20:13] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 16:20:13] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 16:20:13] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 16:20:13] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", )
[23/06/2024 16:20:13] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 16:20:13] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[23/06/2024 16:20:13] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[23/06/2024 16:20:13] C:\wamp\www\adv\bd\funcoes.inc(19) - logQuery("!!!!!!!!!!!!!!!!!!!!...")

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

ibase_query() [<a href='function.ibase-query'>function.ibase-query</a>]: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 53 ) 

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:01] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 17:10:01] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 17:10:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:01] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("52")
[23/06/2024 17:10:01] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 17:10:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:08] C:\wamp\www\adv\relatorios\relatorio_orcamentos_convertidos.php(284) - TrazValorCampo("senhas", "usuario", "codusu", "52")
[23/06/2024 17:10:08] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/06/2024 17:10:08] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = 52)



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:12] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\bd_relatorios.inc(162) - isGerente("52")
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:12] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\bd_relatorios.inc(165) - GetCodVnd()
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")

SELECT CODVND FROM SENHAS WHERE CODUSU = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:12] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", " 23/06/2024")
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\bd_relatorios.inc(172) - qry(, "<br><br>    SELECT<br><br>      ...", )
[23/06/2024 17:10:12] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>    SELECT<br><br>      ...")


    SELECT
        orc.os as orcamento,
        orc.dataos dataOrcamento,
        os.os osVenda,
        os.dataos dataVenda,
        COALESCE(nf.numnota, '--') as nota,
        l.loja as loja,
        c.razao as cliente,
        ts.tiposaida as tipoSaida,
        v.vendedor as vendedor,
        t.transportadora as transportadora,
        os.total as total
        

    FROM os orc
        JOIN os os ON os.orccodos = orc.codos AND os.tipo = 2
        JOIN lojas l ON l.codloja = orc.codloja
        JOIN clientes c ON c.codcli = orc.codcli
        JOIN tiposaidas ts ON ts.codtiposai = orc.codtiposai
        JOIN vendedores v ON v.codvnd = orc.codvnd
        JOIN transportadora t ON t.codtra = orc.codtra
        LEFT JOIN NOTAFISCAL nf ON nf.codos = os.codos

    WHERE 
        orc.tipo = 1 
        AND orc.dataos >= '2024-06-13'
        AND orc.dataos <= '2024-06- 23'
     and (v.codvnd = 5) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:29] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\bd_relatorios.inc(162) - isGerente("52")
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:29] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\bd_relatorios.inc(165) - GetCodVnd()
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")

SELECT CODVND FROM SENHAS WHERE CODUSU = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:29] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\bd_relatorios.inc(172) - qry(, "<br><br>    SELECT<br><br>      ...", )
[23/06/2024 17:10:29] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>    SELECT<br><br>      ...")


    SELECT
        orc.os as orcamento,
        orc.dataos dataOrcamento,
        os.os osVenda,
        os.dataos dataVenda,
        COALESCE(nf.numnota, '--') as nota,
        l.loja as loja,
        c.razao as cliente,
        ts.tiposaida as tipoSaida,
        v.vendedor as vendedor,
        t.transportadora as transportadora,
        os.total as total
        

    FROM os orc
        JOIN os os ON os.orccodos = orc.codos AND os.tipo = 2
        JOIN lojas l ON l.codloja = orc.codloja
        JOIN clientes c ON c.codcli = orc.codcli
        JOIN tiposaidas ts ON ts.codtiposai = orc.codtiposai
        JOIN vendedores v ON v.codvnd = orc.codvnd
        JOIN transportadora t ON t.codtra = orc.codtra
        LEFT JOIN NOTAFISCAL nf ON nf.codos = os.codos

    WHERE 
        orc.tipo = 1 
        AND orc.dataos >= '2024-06-13'
        AND orc.dataos <= '2024-06-23'
     and (v.codvnd = 5) 



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:47] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\bd_relatorios.inc(162) - isGerente("52")
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")

select count(codusu) as n from senhas Where codgerente = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:47] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\bd_relatorios.inc(165) - GetCodVnd()
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")

SELECT CODVND FROM SENHAS WHERE CODUSU = 52



==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================

[23/06/2024 17:10:47] C:\wamp\www\adv\relatorios\abre_relatorio_orcamentos_convertidos.php(12) - getOrcamentosConvertidos("13/06/2024", "23/06/2024")
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\bd_relatorios.inc(172) - qry(, "<br><br>    SELECT<br><br>      ...", )
[23/06/2024 17:10:47] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("<br><br>    SELECT<br><br>      ...")


    SELECT
        orc.os as orcamento,
        orc.dataos dataOrcamento,
        os.os osVenda,
        os.dataos dataVenda,
        COALESCE(nf.numnota, '--') as nota,
        l.loja as loja,
        c.razao as cliente,
        ts.tiposaida as tipoSaida,
        v.vendedor as vendedor,
        t.transportadora as transportadora,
        os.total as total
        

    FROM os orc
        JOIN os os ON os.orccodos = orc.codos AND os.tipo = 2
        JOIN lojas l ON l.codloja = orc.codloja
        JOIN clientes c ON c.codcli = orc.codcli
        JOIN tiposaidas ts ON ts.codtiposai = orc.codtiposai
        JOIN vendedores v ON v.codvnd = orc.codvnd
        JOIN transportadora t ON t.codtra = orc.codtra
        LEFT JOIN NOTAFISCAL nf ON nf.codos = os.codos

    WHERE 
        orc.tipo = 1 
        AND orc.dataos >= '2024-06-13'
        AND orc.dataos <= '2024-06-23'
     and (v.codvnd = 5)