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; } }
private function CalculaValorImposto() { $Imposto = new CImposto(); $ModelCr = new ModellancaCrBd(); $PercentualImposto = $Imposto->VerificaPercentualImpostoFatura($this->getCodEmp()); if ($PercentualImposto > 0.00) { $ValorImposto = $Imposto->CalculaValorDescontoImpostoFatura($PercentualImposto, $this->getCodLancamentoParaFaturar(), $this->getTransacao()); $ValorComDesconto = $Imposto->CalculaValorFaturaMenosImposto($ValorImposto, $this->getCodLancamentoParaFaturar(), $this->getTransacao()); $this->setValor(str_replace(',', ".", $ValorComDesconto)); parent::gravaQueryArquivo(str_replace(',', ".", $ValorComDesconto)); return $ValorImposto; } return 0.00; }