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

[15/06/2024 10:51:09] C:\wamp\www\adv\relatorios\MV142.php(295) - TrazValorCampo("senhas", "usuario", "codusu", )
[15/06/2024 10:51:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[15/06/2024 10:51:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

SELECT usuario as campo FROM senhas WHERE (codusu = )



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

[15/06/2024 10:51:09] C:\wamp\www\adv\relatorios\MV142.php(295) - TrazValorCampo("senhas", "usuario", "codusu", )
[15/06/2024 10:51:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[15/06/2024 10:51:09] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #16, "SELECT usuario as ca...")
[15/06/2024 10:51:09] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[15/06/2024 10:51: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 ) 

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



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

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

SELECT usuario as campo FROM senhas WHERE (codusu = )



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

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

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



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

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

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



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

[15/06/2024 14:01:35] C:\wamp\www\adv\html\cadastro.php(130) - isGerente()
[15/06/2024 14:01:35] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[15/06/2024 14:01:35] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #23, "select count(codusu)...")
[15/06/2024 14:01:35] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[15/06/2024 14:01:35] 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 

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



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

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

SELECT usuario as campo FROM senhas WHERE (codusu = )



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

[15/06/2024 14:01:40] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", )
[15/06/2024 14:01:40] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[15/06/2024 14:01:40] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #22, "SELECT usuario as ca...")
[15/06/2024 14:01:40] () - customError(2, "ibase_query() [<a hr...", "C:\wamp\www\adv\bd\f...", 33, Array)
[15/06/2024 14:01:40] 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 ) 

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



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

[15/06/2024 14:01:51] C:\wamp\www\adv\php\login.php(27) - login("Rivelino", "hcd415")
[15/06/2024 14:01:51] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "<br><br>            SELECT...", )
[15/06/2024 14:01:51] 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('Rivelino') 
                AND UPPER(SENHA) LIKE UPPER('hcd415') 



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

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

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



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

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

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



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

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

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



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

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

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



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

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

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



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "35")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")

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



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

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

SELECT * FROM configinterno 



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

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

SELECT * FROM configinterno 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select<br><br>            ...", )
[15/06/2024 14:05:16] 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('Panasonic') OR  upper(p.descricao) like upper('%Panasonic%'))  order by descricao rows 1 to 100 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10133", 1, "2586", "0.00", "78.04", "", , , , "../php/buscaprod.php...", "0", "78.04", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 2586 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10133", 1, "2586", "0.00", "78.04", "", , , , "../php/buscaprod.php...", "0", "78.04", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2586 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10133", 1, "2586", "0.00", "78.04", "", , , , "../php/buscaprod.php...", "0", "78.04", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2586 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10133", 1, "2586", "0.00", "78.04", "", , , , "../php/buscaprod.php...", "0", "78.04", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 2586 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10133", 1, "2586", "0.00", "78.04", "", , , , "../php/buscaprod.php...", "0", "78.04", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2586")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10143", 2, "2889", "113.11", "156.09", "", , , , "../php/buscaprod.php...", "", "156.09", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 2889 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10143", 2, "2889", "113.11", "156.09", "", , , , "../php/buscaprod.php...", "", "156.09", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2889 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10143", 2, "2889", "113.11", "156.09", "", , , , "../php/buscaprod.php...", "", "156.09", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2889 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10143", 2, "2889", "113.11", "156.09", "", , , , "../php/buscaprod.php...", "", "156.09", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 2889 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10143", 2, "2889", "113.11", "156.09", "", , , , "../php/buscaprod.php...", "", "156.09", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2889")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10146", 3, "3051", "226.22", "312.18", "", , , , "../php/buscaprod.php...", "", "312.18", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 3051 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10146", 3, "3051", "226.22", "312.18", "", , , , "../php/buscaprod.php...", "", "312.18", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 3051 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10146", 3, "3051", "226.22", "312.18", "", , , , "../php/buscaprod.php...", "", "312.18", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 3051 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10146", 3, "3051", "226.22", "312.18", "", , , , "../php/buscaprod.php...", "", "312.18", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 3051 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC 9V...", "01 10146", 3, "3051", "226.22", "312.18", "", , , , "../php/buscaprod.php...", "", "312.18", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3051")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC PO...", "01 10138", 4, "2873", "59.23", "87.66", "", , , , "../php/buscaprod.php...", "", "87.66", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2873")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:16] 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 = 2873 and codloja = 1



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC PO...", "01 10138", 4, "2873", "59.23", "87.66", "", , , , "../php/buscaprod.php...", "", "87.66", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2873")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2873 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:16] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC PO...", "01 10138", 4, "2873", "59.23", "87.66", "", , , , "../php/buscaprod.php...", "", "87.66", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2873")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2873")
[15/06/2024 14:05:16] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:16] 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 = 2873 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC PO...", "01 10138", 4, "2873", "59.23", "87.66", "", , , , "../php/buscaprod.php...", "", "87.66", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2873")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2873")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2873 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "BATERIA PANASONIC PO...", "01 10138", 4, "2873", "59.23", "87.66", "", , , , "../php/buscaprod.php...", "", "87.66", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2873")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10131", 5, "2797", "0.00", "604.77", "", , , , "../php/buscaprod.php...", "0", "604.77", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2797 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10131", 5, "2797", "0.00", "604.77", "", , , , "../php/buscaprod.php...", "0", "604.77", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2797 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10131", 5, "2797", "0.00", "604.77", "", , , , "../php/buscaprod.php...", "0", "604.77", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2797 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10131", 5, "2797", "0.00", "604.77", "", , , , "../php/buscaprod.php...", "0", "604.77", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2797 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10131", 5, "2797", "0.00", "604.77", "", , , , "../php/buscaprod.php...", "0", "604.77", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2797")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10130", 6, "2327", "0.00", "120.96", "", , , , "../php/buscaprod.php...", "0", "120.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2327 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10130", 6, "2327", "0.00", "120.96", "", , , , "../php/buscaprod.php...", "0", "120.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2327 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10130", 6, "2327", "0.00", "120.96", "", , , , "../php/buscaprod.php...", "0", "120.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2327 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10130", 6, "2327", "0.00", "120.96", "", , , , "../php/buscaprod.php...", "0", "120.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2327 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10130", 6, "2327", "0.00", "120.96", "", , , , "../php/buscaprod.php...", "0", "120.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2327")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10137", 7, "2331", "0.00", "43.88", "", , , , "../php/buscaprod.php...", "0", "43.88", "1", 100, "0.00", "TB", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2331 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10137", 7, "2331", "0.00", "43.88", "", , , , "../php/buscaprod.php...", "0", "43.88", "1", 100, "0.00", "TB", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2331 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10137", 7, "2331", "0.00", "43.88", "", , , , "../php/buscaprod.php...", "0", "43.88", "1", 100, "0.00", "TB", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2331 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10137", 7, "2331", "0.00", "43.88", "", , , , "../php/buscaprod.php...", "0", "43.88", "1", 100, "0.00", "TB", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2331 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AAA ...", "01 10137", 7, "2331", "0.00", "43.88", "", , , , "../php/buscaprod.php...", "0", "43.88", "1", 100, "0.00", "TB", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2331")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10128", 8, "2325", "47.50", "65.55", "", , , , "../php/buscaprod.php...", "0", "65.55", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2325 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10128", 8, "2325", "47.50", "65.55", "", , , , "../php/buscaprod.php...", "0", "65.55", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2325 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10128", 8, "2325", "47.50", "65.55", "", , , , "../php/buscaprod.php...", "0", "65.55", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2325 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10128", 8, "2325", "47.50", "65.55", "", , , , "../php/buscaprod.php...", "0", "65.55", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2325 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10128", 8, "2325", "47.50", "65.55", "", , , , "../php/buscaprod.php...", "0", "65.55", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2325")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10144", 9, "2946", "36.82", "54.50", "", , , , "../php/buscaprod.php...", "", "54.50", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2946 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10144", 9, "2946", "36.82", "54.50", "", , , , "../php/buscaprod.php...", "", "54.50", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2946 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10144", 9, "2946", "36.82", "54.50", "", , , , "../php/buscaprod.php...", "", "54.50", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2946 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10144", 9, "2946", "36.82", "54.50", "", , , , "../php/buscaprod.php...", "", "54.50", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2946 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10144", 9, "2946", "36.82", "54.50", "", , , , "../php/buscaprod.php...", "", "54.50", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2946")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10145", 10, "2947", "43.27", "64.05", "", , , , "../php/buscaprod.php...", "", "64.05", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2947 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10145", 10, "2947", "43.27", "64.05", "", , , , "../php/buscaprod.php...", "", "64.05", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2947 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10145", 10, "2947", "43.27", "64.05", "", , , , "../php/buscaprod.php...", "", "64.05", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2947 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10145", 10, "2947", "43.27", "64.05", "", , , , "../php/buscaprod.php...", "", "64.05", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2947 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10145", 10, "2947", "43.27", "64.05", "", , , , "../php/buscaprod.php...", "", "64.05", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2947")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10134", 11, "2326", "55.84", "77.06", "", , , , "../php/buscaprod.php...", "0", "77.06", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2326 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10134", 11, "2326", "55.84", "77.06", "", , , , "../php/buscaprod.php...", "0", "77.06", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2326 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10134", 11, "2326", "55.84", "77.06", "", , , , "../php/buscaprod.php...", "0", "77.06", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2326 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10134", 11, "2326", "55.84", "77.06", "", , , , "../php/buscaprod.php...", "0", "77.06", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2326 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALK ...", "01 10134", 11, "2326", "55.84", "77.06", "", , , , "../php/buscaprod.php...", "0", "77.06", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2326")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10141", 12, "2887", "108.65", "149.94", "", , , , "../php/buscaprod.php...", "", "149.94", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2887 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10141", 12, "2887", "108.65", "149.94", "", , , , "../php/buscaprod.php...", "", "149.94", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2887 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10141", 12, "2887", "108.65", "149.94", "", , , , "../php/buscaprod.php...", "", "149.94", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2887 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10141", 12, "2887", "108.65", "149.94", "", , , , "../php/buscaprod.php...", "", "149.94", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2887 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10141", 12, "2887", "108.65", "149.94", "", , , , "../php/buscaprod.php...", "", "149.94", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2887")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10139", 13, "2884", "217.31", "299.89", "", , , , "../php/buscaprod.php...", "", "299.89", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2884 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10139", 13, "2884", "217.31", "299.89", "", , , , "../php/buscaprod.php...", "", "299.89", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2884 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10139", 13, "2884", "217.31", "299.89", "", , , , "../php/buscaprod.php...", "", "299.89", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2884 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10139", 13, "2884", "217.31", "299.89", "", , , , "../php/buscaprod.php...", "", "299.89", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2884 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10139", 13, "2884", "217.31", "299.89", "", , , , "../php/buscaprod.php...", "", "299.89", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2884")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10142", 14, "2888", "85.42", "117.88", "", , , , "../php/buscaprod.php...", "", "117.88", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2888 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10142", 14, "2888", "85.42", "117.88", "", , , , "../php/buscaprod.php...", "", "117.88", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2888 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10142", 14, "2888", "85.42", "117.88", "", , , , "../php/buscaprod.php...", "", "117.88", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2888 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10142", 14, "2888", "85.42", "117.88", "", , , , "../php/buscaprod.php...", "", "117.88", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2888 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10142", 14, "2888", "85.42", "117.88", "", , , , "../php/buscaprod.php...", "", "117.88", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2888")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10140", 15, "2885", "170.84", "235.76", "", , , , "../php/buscaprod.php...", "", "235.76", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2885 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10140", 15, "2885", "170.84", "235.76", "", , , , "../php/buscaprod.php...", "", "235.76", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2885 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10140", 15, "2885", "170.84", "235.76", "", , , , "../php/buscaprod.php...", "", "235.76", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2885 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10140", 15, "2885", "170.84", "235.76", "", , , , "../php/buscaprod.php...", "", "235.76", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2885 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC ALKA...", "01 10140", 15, "2885", "170.84", "235.76", "", , , , "../php/buscaprod.php...", "", "235.76", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2885")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT G...", "01 10132", 16, "2328", "0.00", "59.47", "", , , , "../php/buscaprod.php...", "0", "59.47", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2328 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT G...", "01 10132", 16, "2328", "0.00", "59.47", "", , , , "../php/buscaprod.php...", "0", "59.47", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2328 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT G...", "01 10132", 16, "2328", "0.00", "59.47", "", , , , "../php/buscaprod.php...", "0", "59.47", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2328 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT G...", "01 10132", 16, "2328", "0.00", "59.47", "", , , , "../php/buscaprod.php...", "0", "59.47", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2328 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT G...", "01 10132", 16, "2328", "0.00", "59.47", "", , , , "../php/buscaprod.php...", "0", "59.47", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2328")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT M...", "01 10102", 17, "2314", "0.00", "61.36", "", , , , "../php/buscaprod.php...", "", "61.36", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2314 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT M...", "01 10102", 17, "2314", "0.00", "61.36", "", , , , "../php/buscaprod.php...", "", "61.36", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2314 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT M...", "01 10102", 17, "2314", "0.00", "61.36", "", , , , "../php/buscaprod.php...", "", "61.36", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2314 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT M...", "01 10102", 17, "2314", "0.00", "61.36", "", , , , "../php/buscaprod.php...", "", "61.36", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2314 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT M...", "01 10102", 17, "2314", "0.00", "61.36", "", , , , "../php/buscaprod.php...", "", "61.36", "1", 100, "0.00", "BD", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2314")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT P...", "01 10101", 18, "2313", "0.00", "45.53", "", , , , "../php/buscaprod.php...", "0", "45.53", "1", 100, "0.00", "TB", , "C:\USERS\WORK03\DESK...", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2313 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT P...", "01 10101", 18, "2313", "0.00", "45.53", "", , , , "../php/buscaprod.php...", "0", "45.53", "1", 100, "0.00", "TB", , "C:\USERS\WORK03\DESK...", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2313 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT P...", "01 10101", 18, "2313", "0.00", "45.53", "", , , , "../php/buscaprod.php...", "0", "45.53", "1", 100, "0.00", "TB", , "C:\USERS\WORK03\DESK...", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2313 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT P...", "01 10101", 18, "2313", "0.00", "45.53", "", , , , "../php/buscaprod.php...", "0", "45.53", "1", 100, "0.00", "TB", , "C:\USERS\WORK03\DESK...", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2313 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC AT P...", "01 10101", 18, "2313", "0.00", "45.53", "", , , , "../php/buscaprod.php...", "0", "45.53", "1", 100, "0.00", "TB", , "C:\USERS\WORK03\DESK...", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2313")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10123", 19, "2324", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2324 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10123", 19, "2324", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2324 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10123", 19, "2324", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2324 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10123", 19, "2324", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2324 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10123", 19, "2324", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2324")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10120", 20, "2322", "12.71", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2322 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10120", 20, "2322", "12.71", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2322 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10120", 20, "2322", "12.71", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:17] 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 = 2322 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10120", 20, "2322", "12.71", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:17] 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 = 2322 and codloja = 1



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

[15/06/2024 14:05:17] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10120", 20, "2322", "12.71", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2322")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:17] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10122", 21, "2323", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2323 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10122", 21, "2323", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2323 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10122", 21, "2323", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2323 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10122", 21, "2323", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2323 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC BOTA...", "01 10122", 21, "2323", "0.00", "17.80", "", , , , "../php/buscaprod.php...", "0", "17.80", "1", 100, "0.00", "CT", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2323")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10104", 22, "2316", "0.00", "85.25", "", , , , "../php/buscaprod.php...", "0", "85.25", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2316 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10104", 22, "2316", "0.00", "85.25", "", , , , "../php/buscaprod.php...", "0", "85.25", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2316 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10104", 22, "2316", "0.00", "85.25", "", , , , "../php/buscaprod.php...", "0", "85.25", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2316 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10104", 22, "2316", "0.00", "85.25", "", , , , "../php/buscaprod.php...", "0", "85.25", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2316 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10104", 22, "2316", "0.00", "85.25", "", , , , "../php/buscaprod.php...", "0", "85.25", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2316")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10105", 23, "2317", "0.00", "341.00", "", , , , "../php/buscaprod.php...", "0", "341.00", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2317 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10105", 23, "2317", "0.00", "341.00", "", , , , "../php/buscaprod.php...", "0", "341.00", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2317 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10105", 23, "2317", "0.00", "341.00", "", , , , "../php/buscaprod.php...", "0", "341.00", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2317 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10105", 23, "2317", "0.00", "341.00", "", , , , "../php/buscaprod.php...", "0", "341.00", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2317 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM A...", "01 10105", 23, "2317", "0.00", "341.00", "", , , , "../php/buscaprod.php...", "0", "341.00", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2317")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10108", 24, "2320", "0.00", "102.96", "", , , , "../php/buscaprod.php...", "0", "102.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2320 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10108", 24, "2320", "0.00", "102.96", "", , , , "../php/buscaprod.php...", "0", "102.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2320 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10108", 24, "2320", "0.00", "102.96", "", , , , "../php/buscaprod.php...", "0", "102.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2320 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10108", 24, "2320", "0.00", "102.96", "", , , , "../php/buscaprod.php...", "0", "102.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2320 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10108", 24, "2320", "0.00", "102.96", "", , , , "../php/buscaprod.php...", "0", "102.96", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2320")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10109", 25, "2321", "0.00", "411.90", "", , , , "../php/buscaprod.php...", "0", "411.90", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2321 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10109", 25, "2321", "0.00", "411.90", "", , , , "../php/buscaprod.php...", "0", "411.90", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2321 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10109", 25, "2321", "0.00", "411.90", "", , , , "../php/buscaprod.php...", "0", "411.90", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2321 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10109", 25, "2321", "0.00", "411.90", "", , , , "../php/buscaprod.php...", "0", "411.90", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2321 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM G...", "01 10109", 25, "2321", "0.00", "411.90", "", , , , "../php/buscaprod.php...", "0", "411.90", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2321")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10107", 26, "2319", "0.00", "424.95", "", , , , "../php/buscaprod.php...", "0", "424.95", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2319 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10107", 26, "2319", "0.00", "424.95", "", , , , "../php/buscaprod.php...", "0", "424.95", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2319 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10107", 26, "2319", "0.00", "424.95", "", , , , "../php/buscaprod.php...", "0", "424.95", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2319 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10107", 26, "2319", "0.00", "424.95", "", , , , "../php/buscaprod.php...", "0", "424.95", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2319 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10107", 26, "2319", "0.00", "424.95", "", , , , "../php/buscaprod.php...", "0", "424.95", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2319")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10106", 27, "2318", "0.00", "106.23", "", , , , "../php/buscaprod.php...", "0", "106.23", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2318 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10106", 27, "2318", "0.00", "106.23", "", , , , "../php/buscaprod.php...", "0", "106.23", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2318 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10106", 27, "2318", "0.00", "106.23", "", , , , "../php/buscaprod.php...", "0", "106.23", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select  coalesce(su...", )
[15/06/2024 14:05:18] 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 = 2318 and P.Previsao is not null
                              Having  sum(  I.QtdeNaoEntr )  >  0 



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10106", 27, "2318", "0.00", "106.23", "", , , , "../php/buscaprod.php...", "0", "106.23", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", )
[15/06/2024 14:05:18] 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 = 2318 and codloja = 1



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

[15/06/2024 14:05:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Panasonic", , , "../php/buscaprod.php...", , 1)
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "PILHA PANASONIC SM M...", "01 10106", 27, "2318", "0.00", "106.23", "", , , , "../php/buscaprod.php...", "0", "106.23", "1", 100, "0.00", "CX", , "", "0")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2318")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1")
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", )
[15/06/2024 14:05:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...")

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