==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 08:07:48] C:\wamp\www\adv\php\pedidos.php(4) - include("C:\wamp\www\adv\php\...")
[23/08/2024 08:07:48] C:\wamp\www\adv\php\iniciaos.php(63) - DadosAdic(, , , , , , , , , , , "833", , , , )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\bd_os.inc(564) - qry(Resource id #14, "SELECT
...", )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT
...")
SELECT
S.CODLOJA,
L.LOJA,
C.CODTRA,
T.TRANSPORTADORA as transportadora,
C.CODFORMA,
F.DESCRICAO,
S.CODVND,
V.VENDEDOR as vendedor,
C.RAZAO as razao,
C.codtipopag,
tp.descricao as descricaotipopag
FROM SENHAS S
LEFT JOIN CLIENTES C ON 1=1
LEFT JOIN CONFIGOS CO ON 1=1
LEFT JOIN LOJAS L ON L.CODLOJA = S.CODLOJA
LEFT JOIN TRANSPORTADORA T ON T.CODTRA = C.CODTRA
LEFT JOIN FORMAS F ON F.CODFORMA = C.CODFORMA
LEFT JOIN VENDEDORES V ON V.CODVND = S.CODVND
LEFT JOIN tipospag tp ON tp.codtipo = c.codtipopag
WHERE C.CODCLI = 833 AND CODUSU =
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 08:07:48] C:\wamp\www\adv\php\pedidos.php(4) - include("C:\wamp\www\adv\php\...")
[23/08/2024 08:07:48] C:\wamp\www\adv\php\iniciaos.php(63) - DadosAdic(, , , , , , , , , , , "833", , , , )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\bd_os.inc(564) - qry(Resource id #14, "SELECT
...", )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #14, "SELECT
...")
[23/08/2024 08:07:48] () - 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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 08:07:48] C:\wamp\www\adv\php\pedidos.php(292) - GetCodVnd()
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODVND FROM S...")
SELECT CODVND FROM SENHAS WHERE CODUSU =
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 08:07:48] C:\wamp\www\adv\php\pedidos.php(292) - GetCodVnd()
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\bd_senhas.inc(135) - qry(, "SELECT CODVND FROM S...", )
[23/08/2024 08:07:48] C:\wamp\www\adv\bd\funcoes.inc(33) - ibase_query(Resource id #14, "SELECT CODVND FROM S...")
[23/08/2024 08:07:48] () - 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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:17:57] C:\wamp\www\adv\php\login.php(27) - login("rafael", "hcd888")
[23/08/2024 10:17:57] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "
SELECT...", )
[23/08/2024 10:17:57] 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')
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:17:58] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 10:17:58] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 10:17:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:17:58] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("55")
[23/08/2024 10:17:58] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/08/2024 10:17:58] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")
select count(codusu) as n from senhas Where codgerente = 55
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:02] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 10:18:02] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 10:18:02] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:03] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Roseli", "", )
[23/08/2024 10:18:03] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/08/2024 10:18: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('%Roseli%') ) OR (upper(fantasia) like upper('%Roseli%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) )
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:04] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "Roseli", "", )
[23/08/2024 10:18:04] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array)
[23/08/2024 10:18:04] 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('%Roseli%') ) OR (upper(fantasia) like upper('%Roseli%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:05] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 10:18:05] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 10:18:05] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:06] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("3909", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296048, 4, 1, )
[23/08/2024 10:18:06] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", )
[23/08/2024 10:18:06] 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 = 3909
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:06] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("3909")
[23/08/2024 10:18:06] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", )
[23/08/2024 10:18:06] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...")
SELECT CODCLI FROM OS WHERE CodCli = '3909'
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 10:18:07] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus()
[23/08/2024 10:18:07] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...")
[23/08/2024 10:18: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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:01] C:\wamp\www\adv\php\login.php(27) - login("rafael", "hcd888")
[23/08/2024 11:09:01] C:\wamp\www\adv\bd\bd_senhas.inc(37) - qry(Resource id #16, "
SELECT...", )
[23/08/2024 11:09:01] 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')
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:01] C:\wamp\www\adv\html\cadastro.php(124) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 11:09:01] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 11:09:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:01] C:\wamp\www\adv\html\cadastro.php(130) - isGerente("55")
[23/08/2024 11:09:01] C:\wamp\www\adv\bd\bd_senhas.inc(96) - qry(, "select count(codusu)...", )
[23/08/2024 11:09:01] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("select count(codusu)...")
select count(codusu) as n from senhas Where codgerente = 55
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:09] C:\wamp\www\adv\php\buscacli.php(130) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "MIG", "", )
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\bd_clientes.inc(565) - qry(Resource id #22, "SELECT RAZAO as raza...", )
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")
SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%MIG%') ) OR (upper(fantasia) like upper('%MIG%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) )
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:09] C:\wamp\www\adv\php\buscacli.php(252) - ListaClientes(, "MIG", "", )
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\bd_clientes.inc(576) - qry(Resource id #22, "SELECT RAZAO as raza...", Array)
[23/08/2024 11:09:09] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT RAZAO as raza...")
SELECT RAZAO as razao, CODCLI, fantasia, cpcn, numcli, revCom FROM CLIENTES WHERE (coalesce(cadinativo,0) = 0) and ((upper(razao) like upper('%MIG%') ) OR (upper(fantasia) like upper('%MIG%') ) ) and (codvnd = (select codvnd from senhas where codusu = 55 ) ) order by razao rows 1 to 10
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:10] C:\wamp\www\adv\html\cadastronovo.php(291) - TrazValorCampo("senhas", "usuario", "codusu", "55")
[23/08/2024 11:09:10] C:\wamp\www\adv\bd\funcoes.inc(318) - qry(, "SELECT usuario as ca...", )
[23/08/2024 11:09:10] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT usuario as ca...")
SELECT usuario as campo FROM senhas WHERE (codusu = 55)
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:11] C:\wamp\www\adv\html\cadastronovo.php(480) - BuscaCadCli("5669", , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , 296048, 4, 1, )
[23/08/2024 11:09:11] C:\wamp\www\adv\bd\bd_clientes.inc(646) - qry(Resource id #39, "SELECT c.razao as ra...", )
[23/08/2024 11:09:11] 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 = 5669
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:11] C:\wamp\www\adv\html\cadastronovo.php(508) - CliTemVenda("5669")
[23/08/2024 11:09:11] C:\wamp\www\adv\bd\bd_clientes.inc(822) - qry(Resource id #39, "SELECT CODCLI FROM O...", )
[23/08/2024 11:09:11] C:\wamp\www\adv\bd\funcoes.inc(31) - logQuery("SELECT CODCLI FROM O...")
SELECT CODCLI FROM OS WHERE CodCli = '5669'
==================================================================================================
==================================================================================================
==================================================================================================
==================================================================================================
[23/08/2024 11:09:11] C:\wamp\www\adv\html\cadastronovo.php(687) - verificaStatus()
[23/08/2024 11:09:11] C:\wamp\www\adv\bd\bd_clientes.inc(76) - ibase_query(Resource id #64, " select c.codclistat...")
[23/08/2024 11:09:11] () - 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
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!