Ejemplos de ManipulaBanco::gravaQueryArquivo en PHP

Ejemplo n.º 1

Archivo: ModelRelatorio.php Proyecto: helbertfurbino/sgmofinanceiro

    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 &quot;RAZAO_SOCIAL&quot; 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 &quot;RAZAO_SOCIAL&quot; 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 &quot;RAZAO_SOCIAL&quot; 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 &quot;SUBCATEGORIA&quot; ASC, &quot;RAZAO_SOCIAL&quot; 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 &quot;RAZAO_SOCIAL&quot; ASC, &quot;RESUMO&quot; 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 &quot;RAZAO_SOCIAL&quot; 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 &quot;F_LANCA_CP2_ID&quot; 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 &quot;RAZAO_SOCIAL&quot; 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 &quot;SUBCATEGORIA&quot; ASC, &quot;DATA_VENCIMENTO&quot; ASC, &quot;RAZAO_SOCIAL&quot; 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 &quot;RAZAO_SOCIAL&quot; ASC, &quot;RESUMO&quot; 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 &quot;RAZAO_SOCIAL&quot; 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 &quot;NUMERO_FATURA_SIGMO&quot; ASC, &quot;RAZAO_SOCIAL&quot; 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 &quot;FORMA_PAGAMENTO&quot; ASC, &quot;RAZAO_SOCIAL&quot; ASC, &quot;DATA_VENCIMENTO&quot; 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 &quot;FORMA_PAGAMENTO&quot; ASC, &quot;RAZAO_SOCIAL&quot; ASC, &quot;DATA_VENCIMENTO&quot; 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;
	}
    }

Ejemplo n.º 2

Archivo: CConsolidacaoPendenciaSigmo.php Proyecto: helbertfurbino/sgmofinanceiro

    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;
    }