Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- include("../../include/connect.php");
- if (strlen($_POST['cmbMes']) == 1) {
- $_POST['cmbMes'] = "0" . $_POST['cmbMes'];
- }
- $competencia = $_POST['cmbAno'] . "-" . $_POST['cmbMes'];
- $where = "IF(rps_data <> '', DATE_FORMAT(rps_data,'%Y-%m') = '$competencia', DATE_FORMAT(datahoraemissao,'%Y-%m') = '$competencia')";
- $sql = mysql_query("SELECT * FROM notas WHERE codemissor = '" . $_SESSION['codempresa'] . "' AND $where");
- if (mysql_num_rows($sql) > 0) {
- $new = new XMLWriter();
- $new->openMemory();
- $new->startDocument("1.0", "ISO-8859-1");
- $new->setIndent(true);
- $new->startElement("exportacao");
- while ($nota = mysql_fetch_object($sql)) {
- $new->startElement("nota");
- $new->writeElement("numero", $nota->numero);
- $new->writeElement("codverificacao", $nota->codverificacao);
- $new->writeElement("rps_numero", $nota->rps_numero);
- $new->writeElement("rps_data", ($nota->rps_data));
- $new->writeElement("datahoraemissao", $nota->datahoraemissao);
- $new->writeElement("tomador_nome", ($nota->tomador_nome));
- $new->writeElement("tomador_cnpjcpf", $nota->tomador_cnpjcpf);
- $new->writeElement("tomador_inscrmunicipal", $nota->tomador_inscrmunicipal);
- $new->writeElement("tomador_logradouro", $nota->tomador_logradouro);
- $new->writeElement("tomador_numero", $nota->tomador_numero);
- $new->writeElement("tomador_complemento", $nota->tomador_complemento);
- $new->writeElement("tomador_bairro",($nota->tomador_bairro);
- $new->writeElement("tomador_cep", $nota->tomador_cep);
- $new->writeElement("tomador_municipio", $nota->tomador_municipio);
- $new->writeElement("tomador_uf", $nota->tomador_uf);
- $new->writeElement("tomador_email", $nota->tomador_email);
- $new->writeElement("valortotal", $nota->valortotal);
- $new->writeElement("deducoes", $nota->valordeducoes);
- $new->writeElement("acrescimo", $nota->valoracrescimos);
- $new->writeElement("basecalculo", $nota->basecalculo);
- $new->writeElement("aliqpercentual", $nota->aliq_percentual);
- $new->writeElement("valoriss", $nota->valoriss);
- $new->writeElement("issretido", $nota->issretido);
- $new->writeElement("cofins", $nota->cofins);
- $new->writeElement("irrf", $nota->valorirrf);
- $new->writeElement("contribuicaosocial", $nota->contribuicaosocial);
- $new->writeElement("pispasep", $nota->pispasep);
- $new->writeElement("inss", $nota->valorinss);
- $new->writeElement("totalretencoes", $nota->total_retencao);
- $new->writeElement("estado", $nota->estado);
- $new->writeElement("discriminacao", $nota->discriminacao);
- $new->writeElement("observacoes", $nota->observacao);
- $new->writeElement("motivocancelamento", $nota->motivocancelamento);
- $new->startElement("servicos");
- $sqlServicos = mysql_query("
- SELECT
- notas_servicos.basecalculo,
- notas_servicos.iss,
- notas_servicos.issretido,
- notas_servicos.discriminacao,
- notas_servicos.codservico,
- servicos.descricao
- FROM
- notas_servicos
- INNER JOIN
- servicos ON notas_servicos.codservico = servicos.codigo
- WHERE
- notas_servicos.codnota = '$nota->codigo'
- ");
- while ($servico = mysql_fetch_object($sqlServicos)) {
- $new->startElement("servico");
- $new->writeElement("codigo", $servico->codservico);
- $new->writeElement("descricao", utf8_encode($servico->descricao));
- $new->writeElement("basecalculo", $servico->basecalculo);
- $new->writeElement("valoriss", $servico->iss);
- $new->writeElement("issretido", $servico->issretido);
- $new->writeElement("discriminacao", utf8_encode($servico->discriminacao));
- $new->endElement();
- }
- $new->endElement();
- $new->endElement();
- }
- $new->endElement();
- $new->endDocument();
- $file = fopen("../xml/notas.xml", "w+");
- fwrite($file, fulltrim( $new->outputMemory()) );
- fclose($file);
- } else {
- echo "<p align=\"center\">Nenhuma nota encontrada</p>";
- }
- function fulltrim( $str )
- {
- $str = preg_split( "/\s+/", trim( $str ) );
- $str = implode( " ", $str );
- return $str;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement