echo " <table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" >\n"; echo " <tr>\n "; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"6%\"><small><b>CNPJ</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"9\"><small><b>Inscrição</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"15%\"><small><b>Nome/Razão</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"18%\"><small><b>Serviço</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"7%\"><small><b>Nota</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"7%\"><small><b>Série</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"10%\"><small><b>Valor</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"10%\"><small><b>Aliquota</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"10%\"><small><b>Total</b></small></td>\n"; echo " <td align=\"center\" bgcolor=\"#00436E\" width=\"8%\"><small><b>Opções</b></small></td>\n"; echo " </tr>\n"; $mostra_gravar = true; for ($xi = 0; $xi < $numrows2; $xi++) { $clquery->sql_result($result2, $xi, "q21_cnpj"); $cnpj = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_inscr"); $inscricao = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_nome"); $nomerazao = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_servico"); $sprestado = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_nota"); $numnota = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_serie"); $numserie = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_valorser"); $valservico = $clquery->resultado; $clquery->sql_result($result2, $xi, "q21_aliq"); $aliquota = $clquery->resultado;
$mesx = $matri[$mes]; $clquery->sql_query("issplan", "q20_nomecontri,q20_planilha, q20_numcgm, q20_ano, q20_mes,q20_numpre", "q20_mes", "q20_ano = {$ano} and q20_mes={$mes} and q20_numcgm= {$numcgm} or q20_ano = {$ano} and q20_numpre is null and q20_numcgm= {$numcgm}"); //die("$clquery->sql"); // traz todos do ano e mes selecionado ou ano e numpre = nada pelo cgc. $clquery->sql_record($clquery->sql); $numrows = $clquery->numrows; $result = $clquery->result; for ($x = 0; $x < $numrows; $x++) { $alterar = "alterar_" . $x; if (isset(${$alterar})) { $alterando = true; $numer = $x; break; } } if ($alterando == true) { $clquery->sql_result($result, $numer, 0); $codigopla = $clquery->resultado; $clquery->sql_result($result, $numer, 5); db_redireciona("opcoesissqn.php?" . base64_encode("modificando=true&alter=true&nomecontri=" . $nomecontri . "&fonecontri=" . $fonecontri . "&mes=" . $mes . "&ano=" . $ano . "&numcgm=" . $numcgm . "&nomes=" . $nomes . "&inscricaow=" . $inscricaow . "&planilha=" . $codigopla)); exit; } $anocorreto = $ano; $mescorreto = $mes; $clquery->sql_query("db_confplan", " * ", "", ""); $clquery->sql_record($clquery->sql); if (pg_numrows($clquery->result) == 0) { $w10_valor = 0; } db_fieldsmemory($clquery->result, 0); //####################### Excluir planilha ######################### $cl_issplan = new cl_issplan();