public function getTodos() { $sql = parent::execute_query("SELECT FILIAL_ID, FILIAL_PADRAO, NOME_FILIAL FROM FILIAL WHERE FILIAL_PADRAO IS NOT NULL UNION SELECT FILIAL_ID, FILIAL_PADRAO, NOME_FILIAL FROM FILIAL WHERE FILIAL_PADRAO IS NULL ORDER BY 2 DESC, 3"); $ListaFilial = array(); while ($linha = parent::criaObjetoConsulta($sql)){ $DadosFilial = new ModelFilial(); $DadosFilial->setCodFilial($linha->FILIAL_ID); $DadosFilial->setNomeFilial($linha->NOME_FILIAL); $DadosFilial->setFilialPadrao($linha->FILIAL_PADRAO); array_push($ListaFilial, $DadosFilial); } return $ListaFilial; }
public function getModelConfigImposto($id){ $sql = "SELECT CONFIG_IMPOSTO_ID, NOME_TABELA, COALESCE(ISS,0) AS ISS, COALESCE(INSS,0) AS INSS, COALESCE(PIS,0) AS PIS, COALESCE(COFINS,0) AS COFINS, COALESCE(CSLL,0) AS CSLL, COALESCE(IRPJ,0) AS IRPJ, COALESCE(RETENCAO_FONTE,'N') AS RETENCAO_FONTE FROM CONFIG_IMPOSTO WHERE CONFIG_IMPOSTO.CONFIG_IMPOSTO_ID =".$id; $rs = parent::execute_query($sql); while($row = ibase_fetch_assoc($rs)){ $this->CONFIG_IMPOSTO_ID = $row['CONFIG_IMPOSTO_ID']; $this->NOME_TABELA = $row['NOME_TABELA']; $this->ISS = $row['ISS']; $this->PIS = $row['PIS']; $this->INSS= $row['INSS']; $this->COFINS = $row['COFINS']; $this->CSll = $row['CSLL']; $this->IRPJ = $row['IRPJ']; $this->RENTENCAO_FONTE = $row['RETENCAO_FONTE']; $this->SYNC = $rs['SYNC']; } return $this; }
public function Limpa($EmpresaId) { $Sql = "SELECT * FROM REL_EMP_FUNCIONARIO_FUNCAO WHERE EMPRESA_ID = " . $EmpresaId; $Result = parent::execute_query($Sql); while ($Linha = parent::criaObjetoConsulta($Result)){ $VerificaRelFunc = "SELECT * FROM REALIZACAO_EXAME WHERE FUNCIONARIO_ID = " . $Linha->FUNCIONARIO_ID; if (!parent::QuantidadeLinhasConsulta($VerificaRelFunc)) { $DeletaRel = "DELETE FROM REL_EMP_FUNCIONARIO_FUNCAO WHERE FUNCIONARIO_ID = $Linha->FUNCIONARIO_ID AND EMPRESA_ID = " . $EmpresaId; parent::execute_query($DeletaRel); $DeleteContato = "DELETE FROM CONTATO WHERE CONTATO_ID = " . $this->IdContato($Linha->FUNCIONARIO_ID); parent::execute_query($DeleteContato); $DeletaEndereco = "DELETE FROM ENDERECO WHERE ENDERECO_ID = " . $this->IdEndereco($Linha->FUNCIONARIO_ID); parent::execute_query($DeletaEndereco); $DeletaFuncionario = "DELETE FROM FUNCIONARIO WHERE FUNCIONARIO_ID = " . $Linha->FUNCIONARIO_ID; parent::execute_query($DeletaFuncionario); } else { $VerificaRel = "SELECT * FROM REL_ESF_EXAME WHERE EMPRESA_ID = " . $Linha->EMPRESA_ID . " AND SETOR_ID = $Linha->SETOR_ID" . "AND FUNCAO_ID = " . $Linha->FUNCAO_ID; $VerificaRisco = "SELECT * FROM REL_ESF_RISCO WHERE EMPRESA_ID = " . $Linha->EMPRESA_ID . " AND SETOR_ID = $Linha->SETOR_ID" . "AND FUNCAO_ID = " . $Linha->FUNCAO_ID; $VerificaRealizacao = "SELECT * FROM REALIZACAO_EXAME WHERE FUNCAO_ID = " . $Linha->FUNCAO_ID . " AND SETOR_ID = " . $Linha->SETOR_ID; if ((!parent::QuantidadeLinhasConsulta($VerificaRel)) AND ( !parent::QuantidadeLinhasConsulta($VerificaRisco))AND ( !parent::QuantidadeLinhasConsulta($VerificaRealizacao))) { $SqlDeletaFuncoesVazias = "DELETE FROM REL_EMPRESA_SETOR_FUNCAO WHERE FUNCAO_ID = " . $Linha->FUNCAO_ID . " AND SETOR_ID = " . $Linha->SETOR_ID . " AND EMPRESA_ID = $EmpresaId"; //echo "<br>" . $VerificaRel; //echo "<br>" . $VerificaRisco; parent::execute_query($SqlDeletaFuncoesVazias); } } } }
public function listaPermissoes($ChaveUser) { $sql = "SELECT TITULO_PAGINA, VALIDA_PERMISSAO, REL.CHAVE_USER, AM.F_ACESSO_MENU_ID, CASE WHEN REL.CHAVE_USER IS NULL THEN 'NAO' ELSE 'SIM' END AS STATUS FROM F_ACESSO_MENU AM LEFT JOIN F_REL_USUARIO_ACESSO_MENU REL ON (AM.F_ACESSO_MENU_ID = REL.F_ACESSO_MENU_ID AND REL.CHAVE_USER = $ChaveUser) ORDER BY TITULO_PAGINA"; $ListaAcesso = array(); if ($result = parent::execute_query($sql)) { while ($linha = parent::criaObjetoConsulta($result)){ $DadosAcesso = new ModelConfiguracoesPermissoes(); $DadosAcesso->setIdPagina($linha->F_ACESSO_MENU_ID); $DadosAcesso->setNomePagina($linha->TITULO_PAGINA); $DadosAcesso->setStatusPermissao($linha->STATUS); $DadosAcesso->setIdUsuario($linha->CHAVE_USER); array_push($ListaAcesso, $DadosAcesso); } } return $ListaAcesso; }
public function getTodos($CodForma = false, $TipoForma = false) { $StringIn = !$CodForma ? "" : "AND F_FORMA_PAGAMENTO IN ($CodForma)"; $StringInTipo = !$TipoForma ? "" : "AND F_TIPO_FORMA = '$TipoForma'"; $sql = parent::execute_query("SELECT * FROM F_FORMA_PAGAMENTO WHERE (1=1) $StringIn $StringInTipo ORDER BY FORMA_PAGAMENTO"); $ListaFormas = array(); while ($linha = parent::criaObjetoConsulta($sql)){ $dadosFormaPagamento = new ModelFormaPagamento(); $dadosFormaPagamento->setF_FORMA_PAGAMENTO_ID($linha->F_FORMA_PAGAMENTO_ID); $dadosFormaPagamento->setFORMA_PAGAMENTO($linha->FORMA_PAGAMENTO); $dadosFormaPagamento->setF_TIPO_FORMA($linha->F_TIPO_FORMA); array_push($ListaFormas, $dadosFormaPagamento); } return $ListaFormas; }
public function getTodos($tipo, $Cod = false) { $In = !$Cod ? "" : "AND GRUPO_CAIXA_ID = $Cod"; $StrQuerye = "SELECT * FROM GRUPO_CAIXA WHERE (TIPO = 'AB' OR TIPO = '$tipo') AND (STATUS !=0 OR STATUS IS NULL) $In ORDER BY GRUPO"; $sql = parent::execute_query($StrQuerye); $listaGrupoCaixa = array(); while ($linha = parent::criaObjetoConsulta($sql)){ $dadosConta = new ModelGrupoCaixa(); $dadosConta->setId_grupo_caixa($linha->GRUPO_CAIXA_ID); $dadosConta->setNome_grupo($linha->GRUPO); $dadosConta->setValor_padrao($linha->VALOR_PADRAO); array_push($listaGrupoCaixa, $dadosConta); } return $listaGrupoCaixa; }
public function ListaPlanoContas($tipo, $Cod = false) { $In = !$Cod ? "" : "AND SUBCATEGORIA_ID = $Cod"; $ListaPlanoContas = array(); if ($sql = parent::execute_query("SELECT * FROM SUBCATEGORIA WHERE (TIPO = 'AB' OR TIPO = '$tipo') AND (STATUS !=0 OR STATUS IS NULL) $In ORDER BY SUBCATEGORIA")) { while ($linha = parent::criaObjetoConsulta($sql)){ $dadosConta = new ModelPlanoContas(); $dadosConta->setCategoriaId($linha->SUBCATEGORIA_ID); $dadosConta->setCodigo($linha->CODIGO); $dadosConta->setSubCategoriaId($linha->SUBCATEGORIA_ID); $dadosConta->setSubCategoriaDescricao($linha->SUBCATEGORIA); array_push($ListaPlanoContas, $dadosConta); } } return $ListaPlanoContas; }
public function TermosAtestado() { $query = "SELECT ITEN.ATESTADO_ITEM_ID, ITEN.ATESTADO_ID, ITEN.TERMO, ITEN.ORDEM FROM ATESTADO INNER JOIN ATESTADO_ITEM ITEN ON (ATESTADO.ATESTADO_ID = ITEN.ATESTADO_ID) ORDER BY ITEN.ATESTADO_ID;"; $result = parent::execute_query($query); while ($linha = parent::criaObjetoConsulta($result)){ $Cod = $linha->ATESTADO_ITEM_ID; $TipoLaudo = $linha->ATESTADO_ID; $Termo = $linha->TERMO; $Ordem = $linha->ORDEM; ECHO $sql = "INSERT INTO " . "TIPO_LAUDO_ITEM " . "(" . "TIPO_LAUDO_ITEM_ID, " . "TIPO_LAUDO_ID, " . "ORDEM, " . "TERMO, " . "SYNC" . ") " . "VALUES " . "(" . "$Cod, " . "$TipoLaudo, " . "$Ordem, " . "'$Termo', " . "'N'" . ");" . "<br>"; } }
public function DadosPagamento($idCp) { $sql = "SELECT CP.F_LANCA_CP_ID, F_LANCA_CP2_ID, NOME_FANTASIA, RAZAO_SOCIAL, CP.FORNECEDOR_ID, CP.RESUMO, STATUS.NOME_STATUS, F_LANCA_CP2.VALOR, CP.F_STATUS_FINANCEIRO_CP_ID, VALOR, F_LANCA_CP2.DATA_VENCIMENTO, COR_STATUS, NOME_STATUS, CP.FORNECEDOR_ID, SUBCATEGORIA_ID, COD_FILIAL_ID, GRUPO_CAIXA, BANCO_ID, F_FORMA_PAGAMENTO_ID, (SELECT COUNT(COD_PARCELAMENTO) FROM F_LANCA_CP WHERE COD_PARCELAMENTO = CP.COD_PARCELAMENTO) AS TOTAL_PARCELAS, F_LANCA_CP2.NUM_PARCELA, NUMERO_NF, NUM_CHEQUE, GRUPO.GRUPO AS NOME_GRUPO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) WHERE CP.F_LANCA_CP_ID = $idCp"; $DadosConta = null; $result = parent::execute_query($sql); if ($result) { $linha = parent::criaObjetoConsulta($result); $DadosConta = new ModelLancaCpBd(); $DadosConta->setIdCp($linha->F_LANCA_CP_ID); $DadosConta->setIdNomeFantasiForConta($linha->NOME_FANTASIA); $DadosConta->setRazaoSocialFor($linha->RAZAO_SOCIAL); $DadosConta->setCodFornecedor($linha->FORNECEDOR_ID); $DadosConta->setValor($linha->VALOR); $DadosConta->setResumo($linha->RESUMO); $DadosConta->setDataVencimentoConta($linha->DATA_VENCIMENTO); $DadosConta->setCodStatusConta($linha->F_STATUS_FINANCEIRO_CP_ID); $DadosConta->setCorStatus($linha->COR_STATUS); $DadosConta->setNomeStatusConta($linha->NOME_STATUS); $DadosConta->setCodFilho($linha->F_LANCA_CP2_ID); $DadosConta->setCodFornecedor($linha->FORNECEDOR_ID); $DadosConta->setIdContaCorrente($linha->BANCO_ID); $DadosConta->setCodFilial($linha->COD_FILIAL_ID); $DadosConta->setCodCategoria($linha->SUBCATEGORIA_ID); $DadosConta->setCodCentroDespesa($linha->GRUPO_CAIXA); $DadosConta->setNumParcela($linha->NUM_PARCELA); $DadosConta->setTotalParcelas($linha->TOTAL_PARCELAS); $DadosConta->setFormaPagamento($linha->F_FORMA_PAGAMENTO_ID); $DadosConta->setNumeroNF($linha->NUMERO_NF); $DadosConta->setNumCheque($linha->NUM_CHEQUE); $DadosConta->setCentroDespesa($linha->NOME_GRUPO); } return $DadosConta; }
Public function IncrementaSequencialRemessa($CodContaCorrente) { $Num_atual = parent::RecuperaCampo("NUMERO_SEQUENCIAL", "BANCO", "BANCO_ID", $CodContaCorrente); $Num_atual = $Num_atual + 1; $sql = "UPDATE BANCO SET NUMERO_SEQUENCIAL = $Num_atual WHERE BANCO_ID = $CodContaCorrente"; if (parent::execute_query($sql)) { return $Num_atual; } else { return FALSE; } }
public function InformacoesRecebimento($IdCr) { $Sql = "SELECT EMP.EMPRESA_ID, CR.F_LANCA_CR_ID, F_LANCA_CR2.VALOR, RAZAO_SOCIAL, DATA_VENCIMENTO, NUM_PARCELA, COD_PARCELAMENTO_PAI, F_LANCA_CR2_ID, (SELECT COUNT(COD_PARCELAMENTO) FROM F_LANCA_CR WHERE COD_PARCELAMENTO = CR.COD_PARCELAMENTO) AS TOTAL_PARCELAS, BANCO.BANCO_ID AS COD_CC, BANCO.VALOR_MULTA, BANCO.VALOR_JURO, NUMERO_NF FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) WHERE CR.F_LANCA_CR_ID = $IdCr"; $lista = array(); $Result = parent::execute_query($Sql); while ($linha = parent::criaObjetoConsulta($Result)){ $contaReceber = new ModellancaCrBd(); $contaReceber->setId_cliente($linha->EMPRESA_ID); $contaReceber->setConta_receber_id($linha->F_LANCA_CR_ID); $contaReceber->setValor($linha->VALOR); $contaReceber->setRazao_social_cli($linha->RAZAO_SOCIAL); $contaReceber->setData_vencimento($linha->DATA_VENCIMENTO); $contaReceber->setCodFilho($linha->F_LANCA_CR2_ID); $contaReceber->setCodParcela($linha->NUM_PARCELA); $contaReceber->setTotalParcelas($linha->TOTAL_PARCELAS); $contaReceber->setVlrMora($linha->VALOR_JURO); $contaReceber->setVlrMulta($linha->VALOR_MULTA); $contaReceber->setCodContaCorrente($linha->COD_CC); $contaReceber->setNumeroNF($linha->NUMERO_NF); array_push($lista, $contaReceber); } return $lista; }
public function ContasPagasMes($mes, $ano, $ultimaDia) { $sql = "SELECT SUM(F_LANCA_CP2.VALOR) AS CP FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) WHERE F_LANCA_CP2.DATA_PAGAMENTO BETWEEN '$ano-$mes-01' AND '$ano-$mes-$ultimaDia' AND ACAO_BAIXAR = 'S' AND ACAO_CANCELAR_PAGAMENTO IS NULL"; $result = parent::execute_query($sql); $linha = parent::criaObjetoConsulta($result); return $linha->CP; }
public function BuscaOperacoesID($IdLancamentos) { $sql = "SELECT * FROM F_DEPOSITO_SAQUE " . "INNER JOIN U" . "WHERE F_DEPOSITO_SAQUE_ID IN ($IdLancamentos)"; if ($result = parent::execute_query($sql)) { $ListaOperacoes = array(); while ($linha = parent::criaObjetoConsulta($result)){ $dadosOperacoes = new ModelBanco(); $dadosOperacoes->setVALOR_OPERACAO($linha->VALOR); $dadosOperacoes->setDATA_OPERACAO($linha->DATA_OPERACAO); $dadosOperacoes->setUSUARIO_OPERACAO($linha->CHAVE_USER); array_push($ListaEvolucaoConta, $dadosOperacoes); } return $ListaOperacoes; } return false; }
public function DadosImpostoFromCR($Id) { $retorno = array(); $Sql = "SELECT IMP.F_IMPOSTO_ID, IMP.ISS, IMP.INSS, IMP.PIS, IMP.COFINS, IMP.CSLL, IMP.IRPJ, IMP.RENTENCAO_FONTE FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 CR2 ON (CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID) INNER JOIN F_REL_F_LANCA_CR2_F_IMPOSTO RELIMP ON (RELIMP.F_LANCA_CR2_ID = CR2.F_LANCA_CR2_ID) INNER JOIN F_IMPOSTO IMP ON (IMP.F_IMPOSTO_ID = RELIMP.F_IMPOSTO_ID) WHERE CR.F_LANCA_CR_ID = $Id AND CR2.ACAO_FATURAR = 'S' AND CR2.ACAO_CANCELAR IS NULL"; $rs = parent::execute_query($Sql); while ($rows = ibase_fetch_assoc($rs)){ array_push($retorno, $rows); } return $retorno; }
public function ListaConfiguracaoFechamento() { $Sql = "SELECT DISTINCT CF.NOME_TABELA, CF.CONFIG_FECHAMENTO_ID FROM EMPRESA EMP INNER JOIN F_FECHAMENTO_FATURA FF ON (FF.EMPRESA_ID = EMP.EMPRESA_ID) INNER JOIN CONFIG_FECHAMENTO CF ON (CF.CONFIG_FECHAMENTO_ID = EMP.CONFIG_FECHAMENTO_ID)"; $LinhaConfiguracao = array(); $Result = parent::execute_query($Sql); while ($linha = parent::criaObjetoConsulta($Result)){ $ModelPencendias = new ModelPendencias(); $ModelPencendias->setIDConfiguracaoFechamento($linha->CONFIG_FECHAMENTO_ID); $ModelPencendias->setNomeConfiguracaoFechamento($linha->NOME_TABELA); array_push($LinhaConfiguracao, $ModelPencendias); } return $LinhaConfiguracao; }
private function FechaIndividualmenteEmpresasGrupo() { $CodGrupo = $this->getCodGrupoEmpresas(); $sql = " SELECT GE.MODO_ENVIO_BOLETO FROM GRUPO_EMPRESA GE WHERE GE.GRUPO_EMPRESA_ID = $CodGrupo"; $result = parent::execute_query($sql); $linha = parent::criaObjetoConsulta($result); if ($linha->MODO_ENVIO_BOLETO == "I") { $this->setFechaEmpresaGrupoIndividualmente(1); return 1; } $this->setFechaEmpresaGrupoIndividualmente(0); return 0; }
public function DadosBoleto($codBoleto) { $sql = "SELECT CLI.RAZAO_SOCIAL AS RAZAO_SOCIAL_SACADO, CASE WHEN CLI.CPF IS NULL AND CLI.CNPJ IS NULL THEN '999.999.999-99' WHEN CLI.CNPJ IS NULL THEN CLI.CPF WHEN CLI.CPF IS NULL THEN CLI.CNPJ END AS DOCUMENTO_SACADO, ENDE.ENDERECO AS ENDERECO_SACADO, ENDE.CEP AS CEP_SACADO, UF.ESTADO AS UF_SACADO, UF.SIGLA AS SIGLA_UF_SACADO, CEDENTE.RAZAO_SOCIAL AS RAZAO_SOCIAL_CEDENTE, CEDENTE.CNPJ AS CNPJ_CEDENTE, CEDENTE.ENDERECO AS ENDERECO_CEDENTE, CEDENTE.CEP AS CEP_CEDENTE, UF_CEDENTE.ESTADO AS UF_CEDENTE, UF_CEDENTE.SIGLA AS SIGLA_UF_CEDENTE , F_LANCA_CR2.DATA_VENCIMENTO, F_LANCA_CR2.VALOR, F_LANCA_CR2.F_LANCA_CR2_ID, CC.AGENCIA, CC.CARTEIRA_COBRANCA, CC.CONTA, CC.DIGITO_CONTA AS DIGITO_VERIFICADOR_CONTA, CC.DIGITO_AGENCIA AS DIGITO_VERIFICADOR_AGENCIA, CC.CONVENIO, F_LANCA_CR2.DESCRICAO_BOLETO, CC.INSTRUCAO_01, CC.INSTRUCAO_02, (SELECT LOGOMARCA FROM PARAMETRO) AS LOGO_CEDENTE, CAST((F_LANCA_CR2.VALOR * CC.VALOR_MULTA /100) AS NUMERIC(15,2)) AS VLR_MULTA, CAST((F_LANCA_CR2.VALOR * CC.VALOR_MULTA /100 / 30) AS NUMERIC(15,2)) AS VLR_MORA FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(F_LANCA_CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 WHERE F_LANCA_CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN FILIAL CEDENTE ON (CEDENTE.FILIAL_ID = CR.COD_FILIAL_ID) INNER JOIN EMPRESA CLI ON (CR.EMPRESA_ID = CLI.EMPRESA_ID) INNER JOIN ENDERECO ENDE ON (CLI.ENDERECO_ID = ENDE.ENDERECO_ID) INNER JOIN ESTADO UF ON (UF.ESTADO_ID = ENDE.ESTADO_ID) INNER JOIN ESTADO UF_CEDENTE ON (UF_CEDENTE.ESTADO_ID = CEDENTE.ESTADO_ID) INNER JOIN BANCO CC ON (CC.BANCO_ID = CR.BANCO_ID) WHERE CR.F_LANCA_CR_ID = $codBoleto"; $result = parent::execute_query($sql); if ($linha = parent::criaObjetoConsulta($result)) { $dadosBoleto = new ModelBoleto(); $dadosBoleto->setRAZAO_SOCIAL_SACADO($linha->RAZAO_SOCIAL_SACADO); $dadosBoleto->setDOCUMENTO_SACADO($linha->DOCUMENTO_SACADO); $dadosBoleto->setENDERECO_SACADO($linha->ENDERECO_SACADO); $dadosBoleto->setCEP_SACADO($linha->CEP_SACADO); $dadosBoleto->setUF_SACADO($linha->UF_SACADO); $dadosBoleto->setSIGLA_UF_SACADO($linha->SIGLA_UF_SACADO); $dadosBoleto->setRAZAO_SOCIAL_CEDENTE($linha->RAZAO_SOCIAL_CEDENTE); $dadosBoleto->setCNPJ_CEDENTE($linha->CNPJ_CEDENTE); $dadosBoleto->setENDERECO_CEDENTE($linha->ENDERECO_CEDENTE); $dadosBoleto->setCEP_CEDENTE($linha->CEP_CEDENTE); $dadosBoleto->setUF_CEDENTE($linha->UF_CEDENTE); $dadosBoleto->setSIGLA_UF_CEDENTE($linha->SIGLA_UF_CEDENTE); $dadosBoleto->setDATA_VENCIMENTO($linha->DATA_VENCIMENTO); $dadosBoleto->setVALOR($linha->VALOR); $dadosBoleto->setF_LANCA_CR_ID2($linha->F_LANCA_CR2_ID); $dadosBoleto->setAGENCIA($linha->AGENCIA); $dadosBoleto->setCARTEIRA_COBRANCA($linha->CARTEIRA_COBRANCA); $dadosBoleto->setCONTA($linha->CONTA); $dadosBoleto->setDIGITO_VERIFICADOR_CONTA($linha->DIGITO_VERIFICADOR_CONTA); $dadosBoleto->setDIGITO_VERIFICADOR_AGENCIA($linha->DIGITO_VERIFICADOR_AGENCIA); $dadosBoleto->setDESCRICAO_BOLETO($linha->DESCRICAO_BOLETO); $dadosBoleto->setINSTRUCAO_1($linha->INSTRUCAO_01); $dadosBoleto->setLOGO_CEDENTE($linha->LOGO_CEDENTE); $dadosBoleto->setVALOR_CALCULADO_MORA($linha->VLR_MORA); $dadosBoleto->setVALOR_CALCULADO_MULTA($linha->VLR_MULTA); $dadosBoleto->setCONVENIO($linha->CONVENIO); return $dadosBoleto; } else { return FALSE; } }
public function BaixaCr() { $CR = new ModellancaCrBd(); $Data = new Data(); $String = new CString(); $sql = "SELECT * FROM CONTA_RECEBER WHERE VALOR IS NOT NULL AND DT_VENCIMENTO IS NOT NULL"; if ($result = parent::execute_query($sql)) { $CR = new ModellancaCrBd(); $Data = new Data(); $String = new CString(); while ($linha = parent::criaObjetoConsulta($result)){ $linha->CONTA_RECEBER_ID; $linha->GRUPO_ID; $linha->NOME_CONTA; $linha->EMPRESA_ID; $linha->TIPO_DOCUMENTO; $linha->NUMERO_DOCUMENTO; $linha->DT_VENCIMENTO; $linha->VALOR; $linha->REPLICAR_MESES; $linha->LANCAMENTO_AUTOMATICO; $linha->STATUS; $linha->OBSERVACAO; $linha->DATA_INCLUSAO; $linha->DESCONTO; $linha->ACRESCIMO; $linha->NUMERO_DOCUMENTO_RECEBIMENTO; $linha->OBSERVACAO_RECEBIMENTO; $linha->VALOR_RECEBIDO; $linha->ORIGEM_CONTA_RECEBER_ID; $linha->SYNC; $linha->CONTA_BAIXA; $linha->DT_RECEBIMENTO; $linha->FORMA_PAGAMENTO; $linha->NUMERO_FATURA; $linha->FATURADO; $linha->PAGO; $linha->BANCO_ID; $linha->FILIAL_ID; $linha->CENTRO_CUSTO_ID; $linha->NUMERO_PARCELA; $linha->UCIDUSER; $linha->UCIDUSER_BAIXA; $linha->DATA_BAIXA; $linha->CONTA_RECEBER_ID; if ((trim($linha->PAGO)) == "S") { $id_cr = parent::RecuperaCampo("F_LANCA_CR_ID", "F_LANCA_CR", "ID_INTEGRACAO", $linha->CONTA_RECEBER_ID); if ($CR->EfetuaRecebimento(2, $id_cr, 0.00, $linha->VALOR_RECEBIDO, 0.00, $linha->UCIDUSER_BAIXA, $linha->DT_RECEBIMENTO, $linha->OBSERVACAO_RECEBIMENTO, $linha->DT_VENCIMENTO, false, false, false)) { break; return false; } } } } }
private function VerificaLancamento() { $Sql = "SELECT DATA_CADASTRO FROM f_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MIN(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) WHERE DESPESA_FIXA_ID = " . $this->getDespesaFixaId(); if ($Result = parent::execute_query($Sql)) { if (parent::QuantidadeLinhasConsulta($Sql)) { $Linha = parent::criaObjetoConsulta($Result); $this->setUltimaDataLancamento($Linha->DATA_CADASTRO); } } $this->RealizaInclusaoCp(); }
public function VerificaPercentualImpostoFatura($CodEmp) { //Verifica se a tabela tem valor de imposto $sql = "SELECT E.CONFIG_IMPOSTO_ID FROM EMPRESA E WHERE E.EMPRESA_ID = $CodEmp"; $result = parent::execute_query($sql); $linha = parent::criaObjetoConsulta($result); if ($linha->CONFIG_IMPOSTO_ID >= 1) { $CodTabelaImposto = $linha->CONFIG_IMPOSTO_ID; //Verifica se a tabela retem imposto if (trim(parent::RecuperaCampo("RETENCAO_FONTE", "CONFIG_IMPOSTO", "CONFIG_IMPOSTO_ID", $CodTabelaImposto)) == "S") { $SqlCalculaImpostoTotal = "SELECT SUM(COALESCE(ISS,0)+COALESCE(INSS,0)+COALESCE(PIS,0)+COALESCE(COFINS,0)+COALESCE(CSLL,0)+COALESCE(IRPJ,0)) AS TOTAL FROM CONFIG_IMPOSTO CI WHERE CI.CONFIG_IMPOSTO_ID = $CodTabelaImposto"; $ResultCalculaImpostoTotal = parent::execute_query($SqlCalculaImpostoTotal); $LinhaCalculaImpostoTotal = parent::criaObjetoConsulta($ResultCalculaImpostoTotal); return (float) $LinhaCalculaImpostoTotal->TOTAL; } return (float) 0.00; } return (float) 0.00; }
public function ServicosEmpresa($CodEmpresa = false, $CodServico = false) { $CodEmpresa = !$CodEmpresa ? "" : "AND REL.EMPRESA_ID = $CodEmpresa"; $CodServico = !$CodServico ? "" : "AND REL.SERVICO_ID = $CodServico"; $SqlListaServicoEmpresa = "SELECT S.*, REL.VALOR AS VALOR_EMPRESA, E.RAZAO_SOCIAL, E.STS_CONVENIO, S.VALOR FROM SERVICO S INNER JOIN REL_SERVICO_EMPRESA REL ON (REL.SERVICO_ID = S.SERVICO_ID) INNER JOIN EMPRESA E ON (E.EMPRESA_ID = REL.EMPRESA_ID) $CodEmpresa $CodServico " . "ORDER BY NOME"; $sql = parent::execute_query($SqlListaServicoEmpresa); $ListaServicos = array(); while ($linha = parent::criaObjetoConsulta($sql)){ $DadosServico = new ModelServicos(); $DadosServico->setSERVICO_ID($linha->SERVICO_ID); $DadosServico->setGRUPO_CAIXA_ID($linha->GRUPO_CAIXA_ID); $DadosServico->setSUBCATEGORIA_ID($linha->SUBCATEGORIA_ID); $DadosServico->setNOME($linha->NOME); $DadosServico->setVALOR($linha->VALOR_EMPRESA); $DadosServico->setSTS_CONVENIO($linha->STS_CONVENIO); $DadosServico->setRAZAO_SOCIAL($linha->RAZAO_SOCIAL); array_push($ListaServicos, $DadosServico); } return $ListaServicos; }
public function FornecedorContasPagar() { $sql = parent::execute_query("SELECT DISTINCT FORNECEDOR_ID, RAZAO_SOCIAL, CNPJ, NOME_FANTASIA FROM F_LANCA_CP CP INNER JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID)"); $listaForCp = array(); while ($linha = parent::criaObjetoConsulta($sql)){ $DadosFornecedor = new ModelFornecedor(); $DadosFornecedor->setIdFornecedor($linha->FORNECEDOR_ID); $DadosFornecedor->setCnpjFor($linha->CNPJ); $DadosFornecedor->setNomeFantasiaFor($linha->NOME_FANTASIA); $DadosFornecedor->setRazaoSocialFor($linha->NOME_FANTASIA); array_push($listaForCp, $DadosFornecedor); } return $listaForCp; }
public function filtro($dados) { switch ($this->filtro){ case "CP_PagamentosCentroDespesa" : $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $empresa = $dados['pesquisaCliente']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_PAGAMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } $centroDespesa = $dados['centro_despesa']; if (!empty($centroDespesa)) { $where .= "AND GRUPO.grupo_caixa_id = $centroDespesa"; } if (!empty($empresa)) { $where .= "AND fornecedor.fornecedor_id = $empresa"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebidoPeriodo</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebidoPeriodo</attr> <attr value=\"title\">Recebimentos no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebidoPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\"> SELECT F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(GRUPO.GRUPO) ) AS CENTRO_DESPESA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20) AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX (F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where </attr> <attr value=\"sql_preview\">SELECT F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(GRUPO.GRUPO) ) AS CENTRO_DESPESA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20) AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX (F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where </attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebidoPeriodo_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> </report>"; //var_dump("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '".$this->XML."'"); parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_PagamentosCentroDespesa'"); //parent::gravaQueryArquivo("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '".$this->XML."' \"WHERE \"webreports\".\"rpt_name\" =\"CP_PagamentosCentroDespesa\""); break; case "CR_RecebidoPeriodo": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = " AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = " AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($conta)) { $where .= " AND CR.banco_id = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebidoPeriodo</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebidoPeriodo</attr> <attr value=\"title\">Recebimentos no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebidoPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, SUBSTRING(NOME_CONTA FROM 1 FOR 25)RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, SUBSTRING(NOME_CONTA FROM 1 FOR 25)RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebidoPeriodo_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_RecebidoPeriodo'"); break; case "CR_VencerPeriodo": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $status = $dados['status_filtro']; $filial = $dados['filial']; $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; if (!empty($status)) { $where .= "AND STATUS.f_status_financeiro_id= $status"; } if (!empty($cliente)) { $where .=" AND EMP.empresa_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_VencerPeriodo</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_VencerPeriodo</attr> <attr value=\"title\">Contas a Vencer no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_VencerPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO, GRUPO.GRUPO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 1 OR STATUS.F_STATUS_FINANCEIRO_ID = 2) $where</attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO, GRUPO.GRUPO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 1 OR STATUS.F_STATUS_FINANCEIRO_ID = 2) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_VencerPeriodo_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_NOME_STATUS\"><attr value=\"name\">NOME_STATUS</attr> <attr value=\"table\"></attr> <attr value=\"label\">Status</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta Previsao</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">DATA_RECEBIMENTO</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_GRUPO\"><attr value=\"name\">GRUPO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Centro Receita</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_VencerPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_VencerPeriodo'"); //parent::gravaQueryArquivo("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '".$this->XML."' \"WHERE \"webreports\".\"rpt_name\" =\"CR_VencerPeriodo\""); break; case "CR_RecebimentosCategoria": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $subCategoria = $dados['subCategoria']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND EMP.empresa_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($subCategoria)) { $where .=" AND SUBCATEGORIA.SUBCATEGORIA_ID = $subCategoria"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebimentosCategoria</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">CCCCCC</attr> <attr value=\"color2\">ADADAD</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebimentosCategoria_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Categoria</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_NOME_STATUS\"><attr value=\"name\">NOME_STATUS</attr> <attr value=\"table\"></attr> <attr value=\"label\">NOME_STATUS</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosCategoria_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebimentosCategoria</attr> <attr value=\"title\">Recebimentos no Periodo (Agrupado por Categoria)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebimentosCategoria</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "SUBCATEGORIA" ASC, "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> </report> "; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_RecebimentosCategoria'"); break; case "CR_RecebimentosEmpresa": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND EMP.empresa_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $where; $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebimentosEmpresa</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">CCCCCC</attr> <attr value=\"color2\">ADADAD</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebimentosEmpresa_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_NOME_STATUS\"><attr value=\"name\">NOME_STATUS</attr> <attr value=\"table\"></attr> <attr value=\"label\">NOME_STATUS</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosEmpresa_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RESUMO</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebimentosEmpresa</attr> <attr value=\"title\">Recebimentos no Periodo (Agrupado por Empresa)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebimentosEmpresa</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC, "RESUMO" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_RecebimentosEmpresa'"); BREAK; case "CR_PagamentosCentroReceita": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $centroReceita = $dados['centroReceita']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND EMP.empresa_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($centroReceita)) { $where .= "AND GRUPO.grupo_caixa_id = $centroReceita"; } if (!empty($filial)) { $where .= "AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebidoPeriodo</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebidoPeriodo</attr> <attr value=\"title\">Recebimentos no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebidoPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, SUBSTRING(NOME_CONTA FROM 1 FOR 25)RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, SUBSTRING(NOME_CONTA FROM 1 FOR 25)RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebidoPeriodo_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebidoPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_PagamentosCentroReceita'"); parent::gravaQueryArquivo("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "' \"WHERE \"webreports\".\"rpt_name\" =\"CR_PagamentosCentroReceita\""); break; case "CP_PagamentosPeriodo": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_PAGAMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND fornecedor.fornecedor_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CP_PagamentosPeriodo</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CP_PagamentosPeriodo</attr> <attr value=\"title\">Contas Pagas no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CP_PagamentosPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, (SUBSTRING(CP.RESUMO FROM 1 FOR 20)) AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.filial_id = CP.cod_filial_id) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"sql_preview\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, (SUBSTRING(CP.RESUMO FROM 1 FOR 20)) AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.filial_id = CP.cod_filial_id) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "F_LANCA_CP2_ID" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">false</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CP_PagamentosPeriodo_F_LANCA_CP2_ID\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Categoria</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Fornecedor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_DATA_PAGAMENTO\"><attr value=\"name\">DATA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Pagamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"desc\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_PagamentosPeriodo'"); //parent::gravaQueryArquivo("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '".$this->XML."' \"WHERE \"webreports\".\"rpt_name\" =\"CP_PagamentosPeriodo\""); break; case "CP_VencerPeriodo": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; $filial = $dados['filial']; if (!empty($cliente)) { $where .=" AND fornecedor.fornecedor_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CP_VencerPeriodo</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CP_VencerPeriodo_F_LANCA_CP2_ID\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Fornecedor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta Previsao</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Categoria</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_GRUPO\"><attr value=\"name\">GRUPO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Centro Despesa</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_VencerPeriodo_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CP_VencerPeriodo</attr> <attr value=\"title\">Contas a Pagar no Periodo</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CP_VencerPeriodo</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, GRUPO.GRUPO, SUBSTRING(CP.RESUMO FROM 1 FOR 20) AS RESUMO, DATA_VENCIMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 1) $where</attr> <attr value=\"sql_preview\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, GRUPO.GRUPO, SUBSTRING(CP.RESUMO FROM 1 FOR 20) AS RESUMO, DATA_VENCIMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 1) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> </report> "; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_VencerPeriodo'"); break; case "CP_PagamentosCategoria": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $subCategoria = $dados['subCategoria']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_PAGAMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND fornecedor.fornecedor_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($subCategoria)) { $where .=" AND SUBCATEGORIA.SUBCATEGORIA_ID = $subCategoria"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CP_PagamentosCategoria</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">CCCCCC</attr> <attr value=\"color2\">ADADAD</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CP_PagamentosCategoria_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Categoria</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_F_LANCA_CP2_ID\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Fornecedor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt.Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_DATA_PAGAMENTO\"><attr value=\"name\">DATA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt .Pagamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosCategoria_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"2\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CP_PagamentosCategoria</attr> <attr value=\"title\">Pagamentos Efetuados no Periodo (Agrupado por Categoria)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CP_PagamentosCategoria</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"sql_preview\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "SUBCATEGORIA" ASC, "DATA_VENCIMENTO" ASC, "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> <attr value=\"style_editor\"><attr value=\"status\">success</attr> </attr> </report> "; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_PagamentosCategoria'"); break; case "CP_PagamentosFornecedor": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_PAGAMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND fornecedor.fornecedor_id = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CP_PagamentosFornecedor</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">CCCCCC</attr> <attr value=\"color2\">ADADAD</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CP_PagamentosFornecedor_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_F_LANCA_CP2_ID\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">true</attr> <attr value=\"search\"></attr> <attr value=\"view_format\">Currency</attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_DATA_PAGAMENTO\"><attr value=\"name\">DATA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Pagamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFornecedor_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RESUMO</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CP_PagamentosFornecedor</attr> <attr value=\"title\">Pagamentos Efetuados no Periodo (Agrupado por Fornecedor)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CP_PagamentosFornecedor</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"sql_preview\">SELECT COD_PARCELAMENTO AS F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(F.NOME_FILIAL) ) AS NOME_FILIAL, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL F ON (F.FILIAL_ID = CP.COD_FILIAL_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC, "RESUMO" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> </report> "; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_PagamentosFornecedor'"); break; case "FAT_ResumoFechamento": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $OrderBy = $dados['ordem']; $TabelaFechamento = $dados['tabelaFechamento']; $where = " AND FF.STATUS_FINANCEIRO = ''P'' AND (CAST(DATA_FECHAMENTO AS DATE)) BETWEEN ''$dataInicial'' AND ''$dataFinal''"; if (isset($dados['ordem'])) { if ($dados['ordem'] == 1) { $OrderBy = " ORDER BY EMP.RAZAO_SOCIAL "; } else { $OrderBy = " ORDER BY NUMERO_FATURA_SIGMO "; } } if ($TabelaFechamento > 0) { $where .= "AND EMP.CONFIG_FECHAMENTO_ID = $TabelaFechamento"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_ResumoFechamento</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_ResumoFechamento_NUMERO_FATURA_SIGMO\"><attr value=\"name\">NUMERO_FATURA_SIGMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Nº Fechamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_ResumoFechamento_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razão Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_ResumoFechamento_TOTAL\"><attr value=\"name\">TOTAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_ResumoFechamento_OBSERVACAO\"><attr value=\"name\">OBSERVACAO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Obs</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">FAT_ResumoFechamento</attr> <attr value=\"title\">Resumo Faturamento</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_ResumoFechamento</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT DISTINCT FF.NUMERO_FATURA_SIGMO, CASE WHEN EMP.GRUPO_EMPRESA_ID IS NOT NULL AND EMPRESA_PADRAO_EMISSAO_BOLETO IS NOT NULL THEN ( SELECT * FROM SP_CONVERTER_CARACTER((SELECT RAZAO_SOCIAL FROM EMPRESA WHERE EMPRESA_ID = EMPRESA_PADRAO_EMISSAO_BOLETO)) ) ELSE ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) END AS RAZAO_SOCIAL , CASE WHEN EMP.GRUPO_EMPRESA_ID IS NOT NULL AND EMPRESA_PADRAO_EMISSAO_BOLETO IS NOT NULL THEN (SELECT SUM(VALOR_PERIODO) FROM F_FECHAMENTO_FATURA WHERE NUMERO_FATURA_SIGMO = FF.NUMERO_FATURA_SIGMO) ELSE FF.VALOR_PERIODO END AS TOTAL, FF.OBSERVACAO FROM F_FECHAMENTO_FATURA FF INNER JOIN EMPRESA EMP ON (FF.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN CONFIG_FECHAMENTO CONF ON (CONF.CONFIG_FECHAMENTO_ID = EMP.CONFIG_FECHAMENTO_ID) LEFT JOIN GRUPO_EMPRESA GRUPO ON (GRUPO.GRUPO_EMPRESA_ID = EMP.GRUPO_EMPRESA_ID) LEFT JOIN CONFIG_FECHAMENTO CONFIG_GRUPO ON (CONFIG_GRUPO.CONFIG_FECHAMENTO_ID = CONF.CONFIG_FECHAMENTO_ID) WHERE 1=1 $where $OrderBy</attr> <attr value=\"sql_preview\">SELECT DISTINCT FF.NUMERO_FATURA_SIGMO, CASE WHEN EMP.GRUPO_EMPRESA_ID IS NOT NULL AND EMPRESA_PADRAO_EMISSAO_BOLETO IS NOT NULL THEN ( SELECT * FROM SP_CONVERTER_CARACTER((SELECT RAZAO_SOCIAL FROM EMPRESA WHERE EMPRESA_ID = EMPRESA_PADRAO_EMISSAO_BOLETO)) ) ELSE ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) END AS RAZAO_SOCIAL , CASE WHEN EMP.GRUPO_EMPRESA_ID IS NOT NULL AND EMPRESA_PADRAO_EMISSAO_BOLETO IS NOT NULL THEN (SELECT SUM(VALOR_PERIODO) FROM F_FECHAMENTO_FATURA WHERE NUMERO_FATURA_SIGMO = FF.NUMERO_FATURA_SIGMO) ELSE FF.VALOR_PERIODO END AS TOTAL, FF.OBSERVACAO FROM F_FECHAMENTO_FATURA FF INNER JOIN EMPRESA EMP ON (FF.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN CONFIG_FECHAMENTO CONF ON (CONF.CONFIG_FECHAMENTO_ID = EMP.CONFIG_FECHAMENTO_ID) LEFT JOIN GRUPO_EMPRESA GRUPO ON (GRUPO.GRUPO_EMPRESA_ID = EMP.GRUPO_EMPRESA_ID) LEFT JOIN CONFIG_FECHAMENTO CONFIG_GRUPO ON (CONFIG_GRUPO.CONFIG_FECHAMENTO_ID = CONF.CONFIG_FECHAMENTO_ID) WHERE 1=1 $where $OrderBy </attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='FAT_ResumoFechamento'"); break; case "FAT_NumeroFatura": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $TabelaFechamento = $dados['tabelaFechamento']; $where = " AND F_LANCA_CR2.DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal'' "; if ($TabelaFechamento > 0) { $where .= " AND EMP.CONFIG_FECHAMENTO_ID = $TabelaFechamento "; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_NumeroFatura</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">FAT_NumeroFatura</attr> <attr value=\"title\">Faturas SIGMO</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_NumeroFatura</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, COD_PARCELAMENTO AS COD, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO, CR.NUMERO_FATURA_SIGMO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND CR.NUMERO_FATURA_SIGMO IS NOT NULL $where GROUP BY CR.NUMERO_FATURA_SIGMO, EMP.RAZAO_SOCIAL, COD_PARCELAMENTO, DATA_VENCIMENTO, DATA_RECEBIMENTO, VALOR, SUBCATEGORIA.SUBCATEGORIA ORDER BY CR.NUMERO_FATURA_SIGMO </attr> <attr value=\"sql_preview\">SELECT VALOR, COD_PARCELAMENTO AS COD, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO, CR.NUMERO_FATURA_SIGMO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN FILIAL F ON (F.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_REF_LANCAMENTO_AGRUPADO IS NULL AND CR.NUMERO_FATURA_SIGMO IS NOT NULL $where GROUP BY CR.NUMERO_FATURA_SIGMO, EMP.RAZAO_SOCIAL, COD_PARCELAMENTO, DATA_VENCIMENTO, DATA_RECEBIMENTO, VALOR, SUBCATEGORIA.SUBCATEGORIA ORDER BY CR.NUMERO_FATURA_SIGMO </attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "NUMERO_FATURA_SIGMO" ASC, "RAZAO_SOCIAL" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">NUMERO_FATURA_SIGMO</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">CCCCCC</attr> <attr value=\"color2\">ADADAD</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">false</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_NumeroFatura_NUMERO_FATURA_SIGMO\"><attr value=\"name\">NUMERO_FATURA_SIGMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Fatura</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Empresa</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Categoria</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_NumeroFatura_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">NUMERO_FATURA_SIGMO</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='FAT_NumeroFatura'"); break; case "CR_RecebimentosFormaPagamento": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaCliente']; $formaPagamento = $dados['formaPagamento']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND EMP.EMPRESA_ID = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($subCategoria)) { $where .=" AND CP.F_FORMA_PAGAMENTO_ID = $formaPagamento"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CR_RecebimentosFormaPagamento</attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CR_RecebimentosFormaPagamento</attr> <attr value=\"title\">Recebimentos (Agrupado por Forma de Pagamento)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CR_RecebimentosFormaPagamento</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT VALOR, F_LANCA_CR2_ID AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FP.FORMA_PAGAMENTO) ) AS FORMA_PAGAMENTO, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(FILIAL.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN F_FORMA_PAGAMENTO FP ON (FP.F_FORMA_PAGAMENTO_ID = CR.F_FORMA_PAGAMENTO_ID) INNER JOIN FILIAL ON (FILIAL.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_AGRUPAMENTO_CR_ID IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where </attr> <attr value=\"sql_preview\">SELECT VALOR, F_LANCA_CR2_ID AS COD, STATUS.NOME_STATUS, SUBSTRING(NOME_CONTA FROM 1 FOR 25) RESUMO, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FP.FORMA_PAGAMENTO) ) AS FORMA_PAGAMENTO, ( SELECT * FROM SP_CONVERTER_CARACTER(EMP.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(FILIAL.NOME_FILIAL) ) AS NOME_FILIAL, DATA_VENCIMENTO, DATA_RECEBIMENTO FROM F_LANCA_CR CR INNER JOIN F_LANCA_CR2 ON (F_LANCA_CR2.F_LANCA_CR2_ID = (SELECT MAX(CR2.F_LANCA_CR2_ID) FROM F_LANCA_CR2 CR2 WHERE CR2.F_LANCA_CR_ID = CR.F_LANCA_CR_ID)) INNER JOIN F_STATUS_FINANCEIRO STATUS ON (STATUS.F_STATUS_FINANCEIRO_ID = CR.F_STATUS_FINANCEIRO_ID) LEFT JOIN EMPRESA EMP ON (CR.EMPRESA_ID = EMP.EMPRESA_ID) LEFT JOIN SUBCATEGORIA ON (CR.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CR.GRUPO_CAIXA) INNER JOIN BANCO ON (CR.BANCO_ID = BANCO.BANCO_ID) INNER JOIN F_FORMA_PAGAMENTO FP ON (FP.F_FORMA_PAGAMENTO_ID = CR.F_FORMA_PAGAMENTO_ID) INNER JOIN FILIAL ON (FILIAL.FILIAL_ID = CR.COD_FILIAL_ID) WHERE CR.F_AGRUPAMENTO_CR_ID IS NULL AND (STATUS.F_STATUS_FINANCEIRO_ID = 3) $where </attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "FORMA_PAGAMENTO" ASC, "RAZAO_SOCIAL" ASC, "DATA_VENCIMENTO" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">EEEEEE</attr> <attr value=\"color2\">CACACA</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CR_RecebimentosFormaPagamento_FORMA_PAGAMENTO\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Forma Pagamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_COD\"><attr value=\"name\">COD</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_DATA_RECEBIMENTO\"><attr value=\"name\">DATA_RECEBIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_NOME_STATUS\"><attr value=\"name\">NOME_STATUS</attr> <attr value=\"table\"></attr> <attr value=\"label\">NOME_STATUS</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CR_RecebimentosFormaPagamento_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"2\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CR_RecebimentosFormaPagamento'"); break; case "CP_PagamentosFormaPagamento": $dataInicial = empty($dados['data_ini_filtro']) ? $this->dataInicial : $this->data->convertDataSql($dados['data_ini_filtro']); $dataFinal = empty($dados['data_fim_filtro']) ? $this->dataFinal : $this->data->convertDataSql($dados['data_fim_filtro']); $conta = $dados['contaCliente']; $cliente = $dados['pesquisaFornecedor']; $formaPagamento = $dados['formaPagamento']; $filial = $dados['filial']; if ($dados['dataPesquisa'] == 1) { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else if ($dados['dataPesquisa'] == 2) { $where = "AND DATA_RECEBIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } else { $where = "AND DATA_VENCIMENTO BETWEEN ''$dataInicial'' AND ''$dataFinal''"; } if (!empty($cliente)) { $where .=" AND FORNECEDOR.FORNECEDOR_ID = $cliente "; } if (!empty($conta)) { $where .="AND BANCO.BANCO_ID = $conta"; } if (!empty($formaPagamento)) { $where .=" AND FP.F_FORMA_PAGAMENTO_ID = $formaPagamento"; } if (!empty($filial)) { $where .= " AND F.FILIAL_ID = $filial"; } $this->XML = "<report> <attr value=\"table_type\">custom</attr> <attr value=\"tables\"><attr value=\"0\">SQL_CP_PagamentosFormaPagamento</attr> </attr> <attr value=\"group_fields\"><attr value=\"0\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"int_type\">0</attr> <attr value=\"ss\">true</attr> <attr value=\"group_order\">1</attr> <attr value=\"group_type\">x</attr> <attr value=\"color1\">EEEEEE</attr> <attr value=\"color2\">CACACA</attr> </attr> <attr value=\"1\"><attr value=\"name\">Summary</attr> <attr value=\"cross_table\">false</attr> <attr value=\"sps\">true</attr> <attr value=\"sds\">true</attr> <attr value=\"sgs\">true</attr> <attr value=\"sum_x\">true</attr> <attr value=\"sum_y\">true</attr> <attr value=\"sum_total\">true</attr> </attr> </attr> <attr value=\"totals\"><attr value=\"SQL_CP_PagamentosFormaPagamento_FORMA_PAGAMENTO\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Forma Pagamento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_COD_PARCELAMENTO\"><attr value=\"name\">COD_PARCELAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_RAZAO_SOCIAL\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Razao Social</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_RESUMO\"><attr value=\"name\">RESUMO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Resumo</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_VALOR\"><attr value=\"name\">VALOR</attr> <attr value=\"table\"></attr> <attr value=\"label\">Valor</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">true</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_F_LANCA_CP2_ID\"><attr value=\"name\">F_LANCA_CP2_ID</attr> <attr value=\"table\"></attr> <attr value=\"label\">Cod</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_DATA_VENCIMENTO\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Vencimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_DATA_PAGAMENTO\"><attr value=\"name\">DATA_PAGAMENTO</attr> <attr value=\"table\"></attr> <attr value=\"label\">Dt. Recebimento</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_NOME_CONTA\"><attr value=\"name\">NOME_CONTA</attr> <attr value=\"table\"></attr> <attr value=\"label\">Conta</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_NOME_FILIAL\"><attr value=\"name\">NOME_FILIAL</attr> <attr value=\"table\"></attr> <attr value=\"label\">Filial</attr> <attr value=\"show\">true</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> <attr value=\"SQL_CP_PagamentosFormaPagamento_SUBCATEGORIA\"><attr value=\"name\">SUBCATEGORIA</attr> <attr value=\"table\"></attr> <attr value=\"label\">SUBCATEGORIA</attr> <attr value=\"show\">false</attr> <attr value=\"min\">false</attr> <attr value=\"max\">false</attr> <attr value=\"sum\">false</attr> <attr value=\"avg\">false</attr> <attr value=\"curr\">false</attr> <attr value=\"search\"></attr> <attr value=\"view_format\"></attr> <attr value=\"edit_format\">Text field</attr> <attr value=\"display_field\"></attr> <attr value=\"linkfield\"></attr> <attr value=\"show_thumbnail\"></attr> <attr value=\"need_encode\"></attr> <attr value=\"thumbnail\"></attr> <attr value=\"listformatobj_imgwidth\">0</attr> <attr value=\"listformatobj_imgheight\">0</attr> <attr value=\"listformatobj_filename\"></attr> <attr value=\"lookupobj_lookuptype\">0</attr> <attr value=\"editformatobj_lookupobj_customdispaly\"></attr> <attr value=\"editformatobj_lookupobj_table\"></attr> <attr value=\"editformatobj_lookupobj_where\"></attr> </attr> </attr> <attr value=\"sort_fields\"><attr value=\"0\"><attr value=\"name\">FORMA_PAGAMENTO</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"1\"><attr value=\"name\">RAZAO_SOCIAL</attr> <attr value=\"desc\">false</attr> </attr> <attr value=\"2\"><attr value=\"name\">DATA_VENCIMENTO</attr> <attr value=\"desc\">false</attr> </attr> </attr> <attr value=\"miscellaneous\"><attr value=\"type\">stepped</attr> <attr value=\"print_friendly\">true</attr> <attr value=\"lines_num\">30</attr> </attr> <attr value=\"settings\"><attr value=\"name\">CP_PagamentosFormaPagamento</attr> <attr value=\"title\">Pagamentos (Agrupado por Forma de Pagamento)</attr> <attr value=\"status\">public</attr> </attr> <attr value=\"owner\">admin</attr> <attr value=\"tmp_active\"></attr> <attr value=\"table_name\">SQL_CP_PagamentosFormaPagamento</attr> <attr value=\"short_table_name\"></attr> <attr value=\"sql\">SELECT F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(FILIAL.NOME_FILIAL) ) AS NOME_FILIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(FP.FORMA_PAGAMENTO) ) AS FORMA_PAGAMENTO, CP.COD_PARCELAMENTO, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL ON (CP.COD_FILIAL_ID = FILIAL.FILIAL_ID) INNER JOIN F_FORMA_PAGAMENTO FP ON (FP.F_FORMA_PAGAMENTO_ID = CP.F_FORMA_PAGAMENTO_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where</attr> <attr value=\"sql_preview\">SELECT F_LANCA_CP2_ID, F_LANCA_CP2.VALOR, ( SELECT * FROM SP_CONVERTER_CARACTER(BANCO.NOME) ) AS NOME_CONTA, ( SELECT * FROM SP_CONVERTER_CARACTER(SUBCATEGORIA.SUBCATEGORIA) ) AS SUBCATEGORIA, ( SELECT * FROM SP_CONVERTER_CARACTER(FORNECEDOR.RAZAO_SOCIAL) ) AS RAZAO_SOCIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(FILIAL.NOME_FILIAL) ) AS NOME_FILIAL, ( SELECT * FROM SP_CONVERTER_CARACTER(FP.FORMA_PAGAMENTO) ) AS FORMA_PAGAMENTO, CP.COD_PARCELAMENTO, SUBSTRING(CP.RESUMO FROM 1 FOR 20)AS RESUMO, DATA_VENCIMENTO, DATA_PAGAMENTO FROM F_LANCA_CP CP INNER JOIN F_LANCA_CP2 ON (F_LANCA_CP2.F_LANCA_CP2_ID = (SELECT MAX(F_LANCA_CP2.F_LANCA_CP2_ID) FROM F_LANCA_CP2 WHERE F_LANCA_CP2.F_LANCA_CP = CP.F_LANCA_CP_ID)) INNER JOIN F_STATUS_FINANCEIRO_CP STATUS ON (STATUS.F_STATUS_FINANCEIRO_CP_ID = CP.F_STATUS_FINANCEIRO_CP_ID) INNER JOIN BANCO ON (BANCO.BANCO_ID = CP.BANCO_ID) LEFT JOIN FORNECEDOR ON (FORNECEDOR.FORNECEDOR_ID = CP.FORNECEDOR_ID) LEFT JOIN SUBCATEGORIA ON (CP.SUBCATEGORIA_ID = SUBCATEGORIA.SUBCATEGORIA_ID) LEFT JOIN GRUPO_CAIXA GRUPO ON (GRUPO.GRUPO_CAIXA_ID = CP.GRUPO_CAIXA) INNER JOIN FILIAL ON (CP.COD_FILIAL_ID = FILIAL.FILIAL_ID) INNER JOIN F_FORMA_PAGAMENTO FP ON (FP.F_FORMA_PAGAMENTO_ID = CP.F_FORMA_PAGAMENTO_ID) WHERE (CP.F_STATUS_FINANCEIRO_CP_ID = 2) $where </attr> <attr value=\"where\"></attr> <attr value=\"order_by\"> ORDER BY "FORMA_PAGAMENTO" ASC, "RAZAO_SOCIAL" ASC, "DATA_VENCIMENTO" ASC</attr> <attr value=\"order_by_preview\"></attr> <attr value=\"group_by\"></attr> <attr value=\"permissions\"><attr value=\"0\"><attr value=\"id\">Guest</attr> <attr value=\"name\">Guest</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> <attr value=\"1\"><attr value=\"id\">admin</attr> <attr value=\"name\">admin</attr> <attr value=\"view\">false</attr> <attr value=\"edit\">false</attr> </attr> </attr> </report>"; parent::execute_query("UPDATE \"webreports\" SET \"webreports\".\"rpt_content\" = '" . $this->XML . "'WHERE \"webreports\".\"rpt_name\" ='CP_PagamentosFormaPagamento'"); break; } }
public function ListaUsuario() { $sql = "SELECT * FROM UCTABUSERS WHERE UCLOGIN != 'ADMIN' ORDER BY UCUSERNAME"; $listaUsuario = array(); if ($result = parent::execute_query($sql)) { while ($linha = parent::criaObjetoConsulta($result)){ $DadosUsuario = new Musuario(); $DadosUsuario->setId($linha->CHAVE_USER); $DadosUsuario->setNome($linha->UCUSERNAME); $DadosUsuario->setLogin($linha->UCLOGIN); array_push($listaUsuario, $DadosUsuario); } } return $listaUsuario; }