1. Go to this page and download the library: Download jheferson-br/tquery library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
jheferson-br / tquery example snippets
TTransaction::open('ERP');
// instanciando o objeto TQuery.
$sql = new TQuery("LimpaTabelas.sql");
//Definindo o local onde os arquivos '.sql' serão encontrados.
$sql->setBasePathQuerys("app/querys/");
//Definindo um separador de querys para a execução de varios comandos dentro do mesmo arquivo .sql
$sql->setMultiQuerySeparator(";");
//Executando as querys.
$afected_rows = $sql->execute();
//Imprimindo na tela a quantidade de linhas que sofreram alterações com a execução da query.
print_r($afected_rows);
TTransaction::open('ERP');
//Definindo os critérios de busca
$criteria = new TCriteria();
$criteria->add(new TFilter('men_mesano', 'LIKE', "%" . date('Y')));
// instanciando o objeto TQuery.
$sql = new TQuery("QryRelatorio.sql");
//Definindo o local onde os arquivos '.sql' serão encontrados.
$sql->setBasePathQuerys("app/querys/");
//Executando a query e carregando os objetos
$rows = $sql->load($criteria);
//Imprimindo na tela os resultados da consulta.
print_r($rows);
TTransaction::open('ERP');
//Definindo os critérios de busca
$criteria = new TCriteria();
$criteria->add(new TFilter('men_mesano', 'LIKE', "%" . date('Y')));
//Defininto vetor com mnemônicos customizados
$params = [
"mes_ano"=> $mes_ano,
"cnpj"=> $PA->cnpj,
"poa_cod"=> $PA->poa_cod,
"men_insc_muni"=> $PA->insc_muni,
];
// instanciando o objeto TQuery informando os parâmtros q serão utilizados.
$sql = new TQuery("QryRelatorio.sql", $params);
//Definindo o local onde os arquivos '.sql' serão encontrados.
$sql->setBasePathQuerys("app/querys/");
//Executando a query e carregando os objetos
$rows = $sql->load($criteria);
//Imprimindo na tela os resultados da consulta.
print_r($rows);
$sql->setParams($params);
sql
SELECT
'12/{{mes_ano}}' AS men_mesano,
'{{men_insc_muni}}' AS men_insc_muni,
pla_conta AS men_conta,
pla.pla_bacen AS pla_bacen,
pla.cod_trib_desif AS cod_trib_desif,
0 AS sald_inic,
0 AS men_cred_mes,
0 AS men_deb_mes,
0 AS men_tributavel,
0 AS men_deducao,
0 AS base_calc,
0 AS valr_issqn_retd,
0 AS men_desc_dedu,
aliq.`alq_taxa` AS men_aliquota,
0 AS men_incentivo,
0 AS men_desc_incen,
0 AS men_motivo_nao_exig,
0 AS men_processo_nao_exig,
0 AS men_mes_compensacao,
0 AS men_vlr_compensacao,
'{{cnpj}}' AS cnpj
FROM
des_plano AS pla
LEFT JOIN des_aliquota AS aliq ON aliq.`cid_cod` = (SELECT cid_cod FROM des_coop WHERE coo_cnpj = '{{cnpj}}') AND aliq.`cod_desif` = pla.`cod_trib_desif`
WHERE pla_conta IN
(SELECT
men_conta
FROM
des_mensal as mct
WHERE (
CAST(CONCAT(SUBSTR(mct.men_mesano, 4,4),SUBSTR(mct.men_mesano, 1,2))AS UNSIGNED INTEGER)
between
CAST(CONCAT(SUBSTR('01/{{mes_ano}}', 4,4),SUBSTR('01/{{mes_ano}}', 1,2))AS UNSIGNED INTEGER)
and CAST(CONCAT(SUBSTR('12/{{mes_ano}}', 4,4),SUBSTR('12/{{mes_ano}}', 1,2))AS UNSIGNED INTEGER)
) and mct.poa_cod = '{{poa_cod}}')
AND pla_conta LIKE '7%'
and pla.pla_grau = 6
and pla.pla_arquivo = 1
GROUP BY `men_mesano`,
men_insc_muni,
`men_conta`,
`men_aliquota`
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.