================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:29:50] C:\wamp\www\adv\php\login.php(27) - login("rafael", "hcd888") [22/07/2024 10:29:50] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "

SELECT...", ) [22/07/2024 10:29:50] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("

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('rafael') AND UPPER(SENHA) LIKE UPPER('hcd888') ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:29:50] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:29:50] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:29:50] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:29:50] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("55") [22/07/2024 10:29:50] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", ) [22/07/2024 10:29:50] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...") select count(codusu) as n from senhas Where codgerente = 55 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:07] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:30:07] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:30:07] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:07] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Apostolo", "", ) [22/07/2024 10:30:07] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 10:30:07] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Apostolo%') ) OR (upper(fantasia) like upper('%Apostolo%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:08] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Apostolo", "", ) [22/07/2024 10:30:08] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 10:30:08] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Apostolo%') ) OR (upper(fantasia) like upper('%Apostolo%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:09] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:30:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:30:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:09] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("599", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296042, 3, 1, ) [22/07/2024 10:30:09] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 10:30:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 599 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:09] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("599") [22/07/2024 10:30:09] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 10:30:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '599' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:30:10] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 10:30:10] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 10:30:10] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:33] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:37:33] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:37:33] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:33] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Wong", , ) [22/07/2024 10:37:33] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 10:37:33] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Wong%') ) OR (upper(fantasia) like upper('%Wong%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:33] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Wong", , ) [22/07/2024 10:37:33] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 10:37:33] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Wong%') ) OR (upper(fantasia) like upper('%Wong%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:35] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:37:35] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:37:35] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:35] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Wong", , ) [22/07/2024 10:37:35] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 10:37:35] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Wong%') ) OR (upper(fantasia) like upper('%Wong%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:35] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Wong", , ) [22/07/2024 10:37:35] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 10:37:35] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Wong%') ) OR (upper(fantasia) like upper('%Wong%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:37] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:37:37] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:37:37] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:37] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("5917", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296056, 4, 1, ) [22/07/2024 10:37:37] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 10:37:37] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 5917 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:37] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("5917") [22/07/2024 10:37:37] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 10:37:37] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '5917' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:38] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 10:37:38] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 10:37:38] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:41] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:37:41] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:37:41] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:41] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("6686", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296056, 4, 1, ) [22/07/2024 10:37:41] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 10:37:41] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 6686 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:41] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("6686") [22/07/2024 10:37:41] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 10:37:41] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '6686' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:37:41] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 10:37:41] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 10:37:41] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:39:30] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:39:30] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:39:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:39:30] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("5917", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296056, 4, 1, ) [22/07/2024 10:39:30] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 10:39:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 5917 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:39:30] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("5917") [22/07/2024 10:39:30] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 10:39:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '5917' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:39:30] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 10:39:30] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 10:39:30] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:15] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:49:15] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:49:15] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:18] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:49:18] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:18] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:18] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select

...", ) [22/07/2024 10:49:18] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select

...") 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('Super') OR upper(p.descricao) like upper('%Super%')) order by descricao rows 1 to 100 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3,6...", "12 11600", 1, "3105", "98.95", "133.58", "", , , , "../php/buscaprod.php...", "", "133.58", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 3105 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3,6...", "12 11600", 1, "3105", "98.95", "133.58", "", , , , "../php/buscaprod.php...", "", "133.58", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 3105 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3,6...", "12 11600", 1, "3105", "98.95", "133.58", "", , , , "../php/buscaprod.php...", "", "133.58", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 3105 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3,6...", "12 11600", 1, "3105", "98.95", "133.58", "", , , , "../php/buscaprod.php...", "", "133.58", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 3105 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3,6...", "12 11600", 1, "3105", "98.95", "133.58", "", , , , "../php/buscaprod.php...", "", "133.58", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3105") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3G ...", "12 11601", 2, "2439", "0.00", "66.79", "", , , , "../php/buscaprod.php...", "0", "66.79", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2439 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3G ...", "12 11601", 2, "2439", "0.00", "66.79", "", , , , "../php/buscaprod.php...", "0", "66.79", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2439 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3G ...", "12 11601", 2, "2439", "0.00", "66.79", "", , , , "../php/buscaprod.php...", "0", "66.79", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2439 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3G ...", "12 11601", 2, "2439", "0.00", "66.79", "", , , , "../php/buscaprod.php...", "0", "66.79", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2439 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 3G ...", "12 11601", 2, "2439", "0.00", "66.79", "", , , , "../php/buscaprod.php...", "0", "66.79", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2439") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11606", 3, "2585", "0.00", "212.54", "", , , , "../php/buscaprod.php...", "0", "212.54", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2585 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11606", 3, "2585", "0.00", "212.54", "", , , , "../php/buscaprod.php...", "0", "212.54", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2585 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11606", 3, "2585", "0.00", "212.54", "", , , , "../php/buscaprod.php...", "0", "212.54", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2585 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11606", 3, "2585", "0.00", "212.54", "", , , , "../php/buscaprod.php...", "0", "212.54", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2585 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11606", 3, "2585", "0.00", "212.54", "", , , , "../php/buscaprod.php...", "0", "212.54", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2585") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11605", 4, "2442", "0.00", "106.27", "", , , , "../php/buscaprod.php...", "0", "106.27", "1", 100, "0.00", "PT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2442 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11605", 4, "2442", "0.00", "106.27", "", , , , "../php/buscaprod.php...", "0", "106.27", "1", 100, "0.00", "PT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2442 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11605", 4, "2442", "0.00", "106.27", "", , , , "../php/buscaprod.php...", "0", "106.27", "1", 100, "0.00", "PT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2442 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11605", 4, "2442", "0.00", "106.27", "", , , , "../php/buscaprod.php...", "0", "106.27", "1", 100, "0.00", "PT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2442 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER 5G ...", "12 11605", 4, "2442", "0.00", "106.27", "", , , , "../php/buscaprod.php...", "0", "106.27", "1", 100, "0.00", "PT", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2442") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER ULT...", "12 11602", 5, "2440", "0.00", "65.92", "", , , , "../php/buscaprod.php...", "0", "65.92", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2440 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER ULT...", "12 11602", 5, "2440", "0.00", "65.92", "", , , , "../php/buscaprod.php...", "0", "65.92", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2440 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER ULT...", "12 11602", 5, "2440", "0.00", "65.92", "", , , , "../php/buscaprod.php...", "0", "65.92", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2440 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER ULT...", "12 11602", 5, "2440", "0.00", "65.92", "", , , , "../php/buscaprod.php...", "0", "65.92", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2440 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "COLA SUPERBONDER ULT...", "12 11602", 5, "2440", "0.00", "65.92", "", , , , "../php/buscaprod.php...", "0", "65.92", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2440") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "SUPER COLA TEKBOND 2...", "12 11619", 6, "2982", "13.32", "18.65", "", , , , "../php/buscaprod.php...", "", "18.65", "1", 100, "0.00", "UN", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2982 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "SUPER COLA TEKBOND 2...", "12 11619", 6, "2982", "13.32", "18.65", "", , , , "../php/buscaprod.php...", "", "18.65", "1", 100, "0.00", "UN", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2982 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "SUPER COLA TEKBOND 2...", "12 11619", 6, "2982", "13.32", "18.65", "", , , , "../php/buscaprod.php...", "", "18.65", "1", 100, "0.00", "UN", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:19] 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 = 2982 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "SUPER COLA TEKBOND 2...", "12 11619", 6, "2982", "13.32", "18.65", "", , , , "../php/buscaprod.php...", "", "18.65", "1", 100, "0.00", "UN", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:19] 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 = 2982 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:19] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Super", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "SUPER COLA TEKBOND 2...", "12 11619", 6, "2982", "13.32", "18.65", "", , , , "../php/buscaprod.php...", "", "18.65", "1", 100, "0.00", "UN", , "", "0") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2982") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:19] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:57] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:49:57] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:49:57] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:49:57] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:49:57] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) [22/07/2024 10:49:57] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs()================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select

...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select

...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select

...") 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('Wil') OR upper(p.descricao) like upper('%Wil%')) order by descricao rows 1 to 100 [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select

...") 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('Wil') OR upper(p.descricao) like upper('%Wil%')) order by descricao rows 1 to 100 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:58] 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 = 2364 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:58] 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 = 2364 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0")================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", )p/buscaprod.php...", , 1) [22/07/2024 10:49:58] 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 = 2364 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:58] 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 = 2364 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 10:49:58] 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 = 2364 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 [22/07/2024 10:49:58] 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 = 2364 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2364") [22/07/2024 10:49:58] 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 = 2364 and codloja = 1 [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 10:49:58] 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 = 2364 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Wil", , , "../php/buscaprod.php...", , 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "LAMINA WILKINSON INO...", "13 11710", 1, "2364", "0.00", "31.05", "", , , , "../php/buscaprod.php...", "0", "31.05", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2364") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 10:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:30] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:52:30] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:52:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:30] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Eletro", , ) [22/07/2024 10:52:30] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 10:52:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Eletro%') ) OR (upper(fantasia) like upper('%Eletro%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:30] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Eletro", , ) [22/07/2024 10:52:30] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 10:52:30] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Eletro%') ) OR (upper(fantasia) like upper('%Eletro%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:32] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 10:52:32] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 10:52:32] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:32] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("3994", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296104, 4, 1, ) [22/07/2024 10:52:32] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 10:52:32] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 3994 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:32] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("3994") [22/07/2024 10:52:32] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 10:52:32] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '3994' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 10:52:32] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 10:52:32] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 10:52:32] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:51] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 11:49:51] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 11:49:51] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:51] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("55") [22/07/2024 11:49:51] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", ) [22/07/2024 11:49:51] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...") select count(codusu) as n from senhas Where codgerente = 55 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:56] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 11:49:56] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 11:49:56] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:56] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Ideal", "", ) [22/07/2024 11:49:56] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 11:49:56] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Ideal%') ) OR (upper(fantasia) like upper('%Ideal%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:56] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Ideal", "", ) [22/07/2024 11:49:56] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 11:49:56] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Ideal%') ) OR (upper(fantasia) like upper('%Ideal%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:57] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 11:49:57] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 11:49:57] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:58] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("4807", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296042, 4, 1, ) [22/07/2024 11:49:58] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 11:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 4807 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:58] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("4807") [22/07/2024 11:49:58] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 11:49:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '4807' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 11:49:58] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 11:49:58] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 11:49:58] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:12:53] C:\wamp\www\adv\php\login.php(27) - login("Sylvio", "hcd160") [22/07/2024 12:12:53] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "

SELECT...", ) [22/07/2024 12:12:53] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("

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('Sylvio') AND UPPER(SENHA) LIKE UPPER('hcd160') ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:12:53] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "39") [22/07/2024 12:12:53] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 12:12:53] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 39) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:12:53] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("39") [22/07/2024 12:12:53] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", ) [22/07/2024 12:12:53] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...") select count(codusu) as n from senhas Where codgerente = 39 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:03] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "39") [22/07/2024 12:13:03] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 12:13:03] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 39) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:03] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Jirau", "", ) [22/07/2024 12:13:03] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", ) [22/07/2024 12:13:03] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Jirau%') ) OR (upper(fantasia) like upper('%Jirau%') ) ) and (codvnd = (select codvnd from senhas where codusu = 39 ) ) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:03] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Jirau", "", ) [22/07/2024 12:13:03] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array) [22/07/2024 12:13:03] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...") SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%Jirau%') ) OR (upper(fantasia) like upper('%Jirau%') ) ) and (codvnd = (select codvnd from senhas where codusu = 39 ) ) order by razao rows 1 to 10 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:07] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "39") [22/07/2024 12:13:07] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 12:13:07] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 39) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:07] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("907", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296043, 3, 1, ) [22/07/2024 12:13:07] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 12:13:07] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 907 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:07] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("907") [22/07/2024 12:13:07] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 12:13:07] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '907' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:13:07] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 12:13:07] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 12:13:07] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:45:46] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 12:45:46] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 12:45:46] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:45:46] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("4807", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296042, 4, 1, ) [22/07/2024 12:45:46] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", ) [22/07/2024 12:45:46] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT c.razao as ra...") SELECT c.razao as razao, c.contato1 as contato1, c.email as email, c.rgie, c.cpcn, c.endereconf as endereco, c.end_ent as endent, c.endcob, c.cep, c.cep_ent, c.cepcob, c.bairro, c.bairro_ent, c.bairrocob, c.cidade, c.cidade_ent, c.cidadecob, c.uf, c.uf_ent, c.ufcob, c.codtra, t.transportadora, c.numeronf,c.enderecotipo,c.enderecocompl,c.codcidnfe,pi.cidade as cidnfe, c.fone1,c.telefonenf, c.fax , c.codprodtabela, c.codclistatus, s.descricao, c.codnfoperacao,c.codnfiedest, c.fantasia FROM CLIENTES c left join transportadora t on t.codtra = c.codtra left join clistatus s on c.codclistatus = s.codclistatus left join cidadesnfe pi on c.codcidnfe = pi.codcid WHERE c.codcli = 4807 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:45:46] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("4807") [22/07/2024 12:45:46] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", ) [22/07/2024 12:45:46] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...") SELECT CODCLI FROM OS WHERE CodCli = '4807' ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 12:45:46] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus() [22/07/2024 12:45:46] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...") [22/07/2024 12:45:46] () - customError(2, "ibase_query() [function.ibase-query]: Dynamic SQL Error SQL error code = -104 as approximate floating-point values in SQL dialect 1, but as 64-bit !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:32] C:\wamp\www\adv\php\login.php(27) - login("rafael", "hcd888") [22/07/2024 13:53:32] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "

SELECT...", ) [22/07/2024 13:53:32] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("

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('rafael') AND UPPER(SENHA) LIKE UPPER('hcd888') ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:33] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 13:53:33] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 13:53:33] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:33] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("55") [22/07/2024 13:53:33] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", ) [22/07/2024 13:53:33] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...") select count(codusu) as n from senhas Where codgerente = 55 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:34] C:\wamp\www\adv\html\produtos_consulta.php(326) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 13:53:34] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 13:53:34] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(226) - TrazValorCampo("senhas", "usuario", "codusu", "55") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...") SELECT usuario as campo FROM senhas WHERE (codusu = 55) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(350) - habilitaDescontoPorQuantidade() [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(399) - habilitaDescontoPorQuantidade() [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(29) - getConfig("habdescpqtdetab") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(19) - getConfigs() [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_config_interno.php(7) - qry(, "SELECT * FROM config...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT * FROM config...") SELECT * FROM configinterno ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(499) - qry(, "select

...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select

...") 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('Tabaco') OR upper(p.descricao) like upper('%Tabaco%')) order by descricao rows 1 to 100 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT ACREMA BL...", "21 00017", 1, "3137", "38.80", "56.26", "", , , , "../php/buscaprod.php...", "", "56.26", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3137 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT ACREMA BL...", "21 00017", 1, "3137", "38.80", "56.26", "", , , , "../php/buscaprod.php...", "", "56.26", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3137 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT ACREMA BL...", "21 00017", 1, "3137", "38.80", "56.26", "", , , , "../php/buscaprod.php...", "", "56.26", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3137 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT ACREMA BL...", "21 00017", 1, "3137", "38.80", "56.26", "", , , , "../php/buscaprod.php...", "", "56.26", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3137 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT ACREMA BL...", "21 00017", 1, "3137", "38.80", "56.26", "", , , , "../php/buscaprod.php...", "", "56.26", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3137") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT GOLDEN VI...", "21 00015", 2, "3135", "82.65", "119.84", "", , , , "../php/buscaprod.php...", "", "119.84", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3135 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT GOLDEN VI...", "21 00015", 2, "3135", "82.65", "119.84", "", , , , "../php/buscaprod.php...", "", "119.84", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3135 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT GOLDEN VI...", "21 00015", 2, "3135", "82.65", "119.84", "", , , , "../php/buscaprod.php...", "", "119.84", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3135 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT GOLDEN VI...", "21 00015", 2, "3135", "82.65", "119.84", "", , , , "../php/buscaprod.php...", "", "119.84", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3135 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT GOLDEN VI...", "21 00015", 2, "3135", "82.65", "119.84", "", , , , "../php/buscaprod.php...", "", "119.84", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3135") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW G...", "21 00018", 3, "3145", "61.05", "88.52", "", , , , "../php/buscaprod.php...", "", "88.52", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3145 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW G...", "21 00018", 3, "3145", "61.05", "88.52", "", , , , "../php/buscaprod.php...", "", "88.52", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3145 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW G...", "21 00018", 3, "3145", "61.05", "88.52", "", , , , "../php/buscaprod.php...", "", "88.52", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3145 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW G...", "21 00018", 3, "3145", "61.05", "88.52", "", , , , "../php/buscaprod.php...", "", "88.52", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3145 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW G...", "21 00018", 3, "3145", "61.05", "88.52", "", , , , "../php/buscaprod.php...", "", "88.52", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3145") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW S...", "21 00016", 4, "3136", "59.04", "85.60", "", , , , "../php/buscaprod.php...", "", "85.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3136 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW S...", "21 00016", 4, "3136", "59.04", "85.60", "", , , , "../php/buscaprod.php...", "", "85.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3136 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW S...", "21 00016", 4, "3136", "59.04", "85.60", "", , , , "../php/buscaprod.php...", "", "85.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3136 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW S...", "21 00016", 4, "3136", "59.04", "85.60", "", , , , "../php/buscaprod.php...", "", "85.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3136 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO HBT RAINBOW S...", "21 00016", 4, "3136", "59.04", "85.60", "", , , , "../php/buscaprod.php...", "", "85.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3136") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY - CAIX...", "03 10429", 5, "3040", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3040 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY - CAIX...", "03 10429", 5, "3040", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3040 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY - CAIX...", "03 10429", 5, "3040", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3040 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY - CAIX...", "03 10429", 5, "3040", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3040 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY - CAIX...", "03 10429", 5, "3040", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CT", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3040") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY BAUNIL...", "03 10441", 6, "3140", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3140 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY BAUNIL...", "03 10441", 6, "3140", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3140 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY BAUNIL...", "03 10441", 6, "3140", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3140 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY BAUNIL...", "03 10441", 6, "3140", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3140 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY BAUNIL...", "03 10441", 6, "3140", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3140") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY CHOCOL...", "03 10442", 7, "3141", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3141 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY CHOCOL...", "03 10442", 7, "3141", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3141 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY CHOCOL...", "03 10442", 7, "3141", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3141 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY CHOCOL...", "03 10442", 7, "3141", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3141 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO MARLEY CHOCOL...", "03 10442", 7, "3141", "48.00", "69.60", "", , , , "../php/buscaprod.php...", "", "69.60", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3141") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO NATURAL AMSTE...", "03 10426", 8, "2994", "51.50", "82.40", "", , , , "../php/buscaprod.php...", "", "82.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 2994 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO NATURAL AMSTE...", "03 10426", 8, "2994", "51.50", "82.40", "", , , , "../php/buscaprod.php...", "", "82.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 2994 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO NATURAL AMSTE...", "03 10426", 8, "2994", "51.50", "82.40", "", , , , "../php/buscaprod.php...", "", "82.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 2994 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO NATURAL AMSTE...", "03 10426", 8, "2994", "51.50", "82.40", "", , , , "../php/buscaprod.php...", "", "82.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 2994 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO NATURAL AMSTE...", "03 10426", 8, "2994", "51.50", "82.40", "", , , , "../php/buscaprod.php...", "", "82.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("2994") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ CACHIMBO I...", "03 10443", 9, "3142", "180.00", "239.40", "", , , , "../php/buscaprod.php...", "", "239.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3142 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ CACHIMBO I...", "03 10443", 9, "3142", "180.00", "239.40", "", , , , "../php/buscaprod.php...", "", "239.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3142 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ CACHIMBO I...", "03 10443", 9, "3142", "180.00", "239.40", "", , , , "../php/buscaprod.php...", "", "239.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3142 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ CACHIMBO I...", "03 10443", 9, "3142", "180.00", "239.40", "", , , , "../php/buscaprod.php...", "", "239.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3142 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ CACHIMBO I...", "03 10443", 9, "3142", "180.00", "239.40", "", , , , "../php/buscaprod.php...", "", "239.40", "1", 100, "0.00", "CX", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3142") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1) ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ ENROLAR RA...", "21 MAC002", 10, "3083", "50.76", "73.60", "", , , , "../php/buscaprod.php...", "", "73.60", "1", 100, "0.00", "PC", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(96) - GetQtdeEstoqueFisico("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3083 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ ENROLAR RA...", "21 MAC002", 10, "3083", "50.76", "73.60", "", , , , "../php/buscaprod.php...", "", "73.60", "1", 100, "0.00", "PC", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(101) - GetQtdeCompra("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3083 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ ENROLAR RA...", "21 MAC002", 10, "3083", "50.76", "73.60", "", , , , "../php/buscaprod.php...", "", "73.60", "1", 100, "0.00", "PC", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeCompra("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(704) - qry(, " Select coalesce(su...", ) [22/07/2024 13:53:38] 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 = 3083 and P.Previsao is not null Having sum( I.QtdeNaoEntr ) > 0 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ ENROLAR RA...", "21 MAC002", 10, "3083", "50.76", "73.60", "", , , , "../php/buscaprod.php...", "", "73.60", "1", 100, "0.00", "PC", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(785) - GetQtdeEstoqueFisico("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(775) - qry(, "select coalesce(sum(...", ) [22/07/2024 13:53:38] 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 = 3083 and codloja = 1 ================================================================================================== ================================================================================================== ================================================================================================== ================================================================================================== [22/07/2024 13:53:38] C:\wamp\www\adv\php\buscaprod.php(352) - BuscaProdutos(, , "Tabaco", , , "../php/buscaprod.php...", , 1) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(648) - MostraProduto(1, "TABACO P/ ENROLAR RA...", "21 MAC002", 10, "3083", "50.76", "73.60", "", , , , "../php/buscaprod.php...", "", "73.60", "1", 100, "0.00", "PC", , "", "0") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(262) - GetQtdeEstoqueTotal("3083") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\bd_produtos.inc(786) - TrazValorCampo("config", "limiteestoque", "1", "1") [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT limiteestoque...", ) [22/07/2024 13:53:38] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT limiteestoque...") SELECT limiteestoque as campo FROM config WHERE (1 = 1)