session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "dbforms/db_funcoes.php";
include "classes/db_issplan_classe.php";
include "classes/db_issplanit_classe.php";
include "classes/db_issplananula_classe.php";
include "classes/db_arrecad_classe.php";
include "classes/db_cancdebitos_classe.php";
include "classes/db_cancdebitosreg_classe.php";
include "classes/db_cancdebitosproc_classe.php";
include "classes/db_cancdebitosprocreg_classe.php";
include "classes/db_cancdebitosissplan_classe.php";
$sqlerro = false;
$clissplanit = new cl_issplanit();
$ip = $HTTP_SERVER_VARS['REMOTE_ADDR'];
if (isset($anular)) {
if (isset($ultima) and $ultima == "sim") {
//db_msgbox("entrou na ultima");
$clissplanit->q21_sequencial = $q21_sequencial;
$clissplanit->q21_status = 3;
$clissplanit->alterar($q21_sequencial);
if ($clissplanit->erro_status == 0) {
$sqlerro = true;
$erro_msg = $clissplanit->erro_msg;
}
}
if ($sqlerro == false) {
$sqlerro = db_anulaPlanilha($planilha, $motivo, $ip);
}
* e-cidade@dbseller.com.br
*
* Este programa e software livre; voce pode redistribui-lo e/ou
* modifica-lo sob os termos da Licenca Publica Geral GNU, conforme
* publicada pela Free Software Foundation; tanto a versao 2 da
* Licenca como (a seu criterio) qualquer versao mais nova.
*
* Este programa e distribuido na expectativa de ser util, mas SEM
* QUALQUER GARANTIA; sem mesmo a garantia implicita de
* COMERCIALIZACAO ou de ADEQUACAO A QUALQUER PROPOSITO EM
* PARTICULAR. Consulte a Licenca Publica Geral GNU para obter mais
* detalhes.
*
* Voce deve ter recebido uma copia da Licenca Publica Geral GNU
* junto com este programa; se nao, escreva para a Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
* 02111-1307, USA.
*
* Copia da licenca no diretorio licenca/licenca_en.txt
* licenca/licenca_pt.txt
*/
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_issplanit_classe.php";
$cl_issplanit = new cl_issplanit();
//die($cl_issplanit->sql_query_file(null,"*", null, "q21_cnpj= '$cnpj' and q21_nota = '$nota' and q21_serie='$serie'"));
$result = $cl_issplanit->sql_record($cl_issplanit->sql_query_file(null, "*", null, "q21_cnpj= '{$cnpj}' and q21_nota = '{$nota}' and q21_serie='{$serie}' and q21_status = 1"));
if ($cl_issplanit->numrows > 0) {
echo " <script> alert('CNPJ, Nota e Série ja lançadas');\n \tparent.js_notaexiste()\n \t </script>";
}
if ($linhasop > 0) {
//verifica se tem nota
$sqlnota = "select * from pagordemnota where e71_codord= {$codord} ";
$resultnota = pg_query($sqlnota);
$linhasnota = pg_num_rows($resultnota);
if ($linhasnota > 0) {
// tem nota
$sql = " select e50_codord,e60_numemp,e60_numcgm,e69_dtnota, e69_numero as nota,e70_valor as valornota,\n\t\t\t\ta.z01_nome as nome_emp,a.z01_cgccpf as cnpj_emp, b.z01_nome as nome_pag,b.z01_cgccpf as cnpj_pag\n\t\t\t\tfrom pagordem\n\t\t\t\tinner join empempenho on e50_numemp = e60_numemp\n\t\t\t\tinner join cgm a on a.z01_numcgm = e60_numcgm\n\t\t\t\tleft join pagordemconta on e49_codord = e50_codord\n\t\t\t\tleft join cgm b on b.z01_numcgm = e49_numcgm\n\t\t\t\tinner join pagordemnota on e71_codord = e50_codord\n\t\t\t\tinner join empnota on e69_codnota = e71_codnota\n\t\t\t\tinner join empnotaele on e70_codnota = e71_codnota\n\t\t\t\twhere e50_codord = {$codord} ";
$result = pg_query($sql);
$linhas = pg_num_rows($result);
if ($linhas > 0) {
include "classes/db_issplan_classe.php";
include "classes/db_issplanit_classe.php";
include "classes/db_issplanitop_classe.php";
$cl_issplan = new cl_issplan();
$cl_issplanit = new cl_issplanit();
$cl_issplanitop = new cl_issplanitop();
$sqlpref = "select numcgm,codigo,nomeinst,telef,cgc from db_config where prefeitura is true";
$resultpref = pg_query($sqlpref);
db_fieldsmemory($resultpref, 0);
if ($planilha == "") {
$cl_issplan->q20_numcgm = $numcgm;
$cl_issplan->q20_ano = $ano;
$cl_issplan->q20_mes = $mes;
$cl_issplan->q20_nomecontri = @$nomeinst;
$cl_issplan->q20_fonecontri = @$telef;
$cl_issplan->q20_numpre = 0;
$cl_issplan->q20_numbco = 0;
$cl_issplan->q20_situacao = 1;
$cl_issplan->incluir(null);
if ($cl_issplan->erro_status == 0) {
*/
session_start();
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_sql.php";
include "classes/db_issplan_classe.php";
include "classes/db_issplanit_classe.php";
include "classes/db_issplaninscr_classe.php";
include "classes/db_issplanitinscr_classe.php";
include "classes/db_issplanitop_classe.php";
include "classes/db_issplanitold_classe.php";
include "dbforms/db_funcoes.php";
include "libs/db_libtributario.php";
$clissplanitold = new cl_issplanitold();
$cl_issplan = new cl_issplan();
$cl_issplanit = new cl_issplanit();
$cl_issplaninscr = new cl_issplaninscr();
$cl_issplanitinscr = new cl_issplanitinscr();
$cl_issplanitop = new cl_issplanitop();
parse_str(base64_decode($HTTP_SERVER_VARS["QUERY_STRING"]));
db_postmemory($_POST);
db_postmemory($_GET);
if (isset($planilha)) {
// retorna o nomecontri e o fonecontri
$recordIssplan = $cl_issplan->sql_record($cl_issplan->sql_query_file(null, "q20_nomecontri, q20_fonecontri", null, "q20_planilha = '{$planilha}'"));
if ($cl_issplan->numrows > 0) {
$sSql = pg_fetch_assoc($recordIssplan);
$q20_nomecontri = $sSql["q20_nomecontri"];
$q20_fonecontri = $sSql["q20_fonecontri"];
$nomecontri = $sSql["q20_nomecontri"];
$fonecontri = $sSql["q20_fonecontri"];
