Gestor 48j9Ak1KQ4zifu3kY3jgp9USuUzZVyIdYlr9wGTY9hPkcOFMRkt7yMNDbYXqAHdOwtbRL0RZAalvE7mEYZjrRsJeZe1bQEJ9/3ucTHd4LX/RGM0JWF1DyEV4TQTh8CUP3N7XomF0koQ= Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados data,System.DateTime hora,System.String valor,System.Decimal historico,System.String 30 False dados Gestor SELECT data, hora, valor, historico FROM ( SELECT recBaixa.data, recBaixa.hora, recBaixa.valor, COALESCE(recBaixa.historico, receber.historico, CONCAT('Referente ao receber #', receber.id)) as historico FROM receber_baixa recBaixa INNER JOIN receber ON receber.id = recBaixa.receber_id INNER JOIN titulo ON titulo.id = recBaixa.titulo_id LEFT JOIN movimento ON movimento.id = recBaixa.movimento_id WHERE DATE_FORMAT(CAST(recBaixa.data as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND titulo.tipo_titulo <> 'Vale' AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN movimento.conta_corrente_id = {conta_corrente_id} ELSE 1 = 1 END UNION ALL SELECT transf.data_transferencia, transf.hora_transferencia, transf.valor, transf.historico FROM transferencia_conta transf WHERE DATE_FORMAT(CAST(transf.data_transferencia as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN transf.conta_destino_id = {conta_corrente_id} ELSE 1 = 1 END UNION ALL SELECT transf.data_transferencia, transf.hora_transferencia, (transf.valor * -1), transf.historico FROM transferencia_conta transf WHERE DATE_FORMAT(CAST(transf.data_transferencia as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN transf.conta_origem_id = {conta_corrente_id} ELSE 1 = 1 END UNION ALL SELECT pagBaixa.data, pagBaixa.hora, (pagBaixa.valor * -1), pagar.historico FROM pagar_baixa pagBaixa INNER JOIN pagar ON pagar.id = pagBaixa.pagar_id LEFT JOIN movimento ON movimento.id = pagBaixa.movimento_id WHERE DATE_FORMAT(CAST(pagBaixa.data as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN movimento.conta_corrente_id = {conta_corrente_id} ELSE 1 = 1 END ) AS fluxo_caixa ORDER BY data ASC, REPLACE(hora, ':', '') DESC movimentacao_titulo descricao,System.String valor_entrada,System.Decimal valor_saida,System.Decimal saldo,System.Decimal ordem_titulo,System.Int64 30 False movimentacao_titulo Gestor SELECT SUM(CASE WHEN mov_titulo.valor > 0 THEN mov_titulo.valor ELSE 0 END) AS valor_entrada, SUM(CASE WHEN mov_titulo.valor < 0 THEN mov_titulo.valor ELSE 0 END) AS valor_saida, SUM(mov_titulo.valor) AS saldo, CASE titulo.tipo_titulo WHEN 'Dinheiro' THEN 1 WHEN 'Cartao' THEN 2 WHEN 'Duplicata' THEN 3 ELSE 4 END AS ordem_titulo, titulo.descricao FROM ( SELECT rec_baixa.valor, rec_baixa.titulo_id FROM receber_baixa rec_baixa INNER JOIN receber ON receber.id = rec_baixa.receber_id LEFT JOIN movimento ON movimento.id = rec_baixa.movimento_id LEFT JOIN titulo ON titulo.id = rec_baixa.titulo_id WHERE DATE_FORMAT(CAST(rec_baixa.data as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN movimento.conta_corrente_id = {conta_corrente_id} ELSE 1 = 1 END -- NÃO CONSIDERAR TITULOS A PRAZO EMITIDAS E RECEBIDAS NO MESMO DIA AND NOT (titulo.tipo_titulo = 'Duplicata' AND receber.data_emissao = rec_baixa.data) UNION ALL SELECT (pag_baixa.valor * -1), pag_baixa.titulo_id FROM pagar_baixa pag_baixa INNER JOIN pagar ON pagar.id = pag_baixa.pagar_id LEFT JOIN movimento ON movimento.id = pag_baixa.movimento_id WHERE DATE_FORMAT(CAST(pag_baixa.data as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN movimento.conta_corrente_id = {conta_corrente_id} ELSE 1 = 1 END UNION ALL SELECT orcpag.valor_pago, orcpag.titulo_id FROM orcamento_pag orcpag INNER JOIN orcamento ON orcamento.id = orcpag.orcamento_id INNER JOIN titulo ON titulo.id = orcpag.titulo_id LEFT JOIN movimento ON movimento.id = orcamento.movimento_id WHERE titulo.tipo_titulo = 'Duplicata' AND DATE_FORMAT(CAST(orcamento.data_emissao as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND CASE WHEN '{conta_corrente_id}' <> '' AND '{conta_corrente_id}' <> '0' THEN movimento.conta_corrente_id = {conta_corrente_id} ELSE 1 = 1 END ) AS mov_titulo INNER JOIN titulo ON titulo.id = mov_titulo.titulo_id GROUP BY titulo_id, ordem_titulo ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,conta_corrente_id,conta_corrente_id,System.String,_x0030_,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_1_x005F_x002F_2019_x005F_x0020_11:51:25_x005F_x0020_AM_x002C__x005F_x0038__x005F_x002F_1_x005F_x002F_2019_x005F_x0020_11:51:25_x005F_x0020_AM,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,4.2 Transparent 0,3.6,1.8,0.6 False Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 False Data Black Expression Center Transparent 1.8,3.6,1.8,0.6 False Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 False Hora Black Expression Center Transparent 3.6,3.6,10.4,0.6 False Tahoma,8.25,Bold,Point,False,0 6aa5f4c980424a969091ce71aa8350e9 0,0,0,0 Text7 False Histórico Black Expression Center Transparent 16.4,3.6,2.6,0.6 False Tahoma,8.25,Bold,Point,False,0 610b930b511a4d06a1f3866ee6b800ce Right 0,0,0,0 Text9 False Saldo Black Expression Center GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 Center 0,0,0,0 Text1 FLUXO DE CAIXA Black Expression Panel1 Transparent 14,3.6,2.4,0.6 False Tahoma,8.25,Bold,Point,False,0 b3d151aaf7064e4d92d1b5b896b681ee Right 0,0,0,0 Text8 False Valor Black Expression Center Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 0590557fa79a4e9a86dde2311ae507be 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 ba6e1ae4fa7a485ca250de9392bf33a8 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 726bc5ae5e63447292be56e99415d9ce Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 2c3a698a9733410b87d8e84e82009645 Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo d84d777362c74890bcf40ac88abe20c6 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 f9cb04c1ceae436ebcbc926992793070 0,0,0,0 Text24 {descricao_filtros} Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.8 Transparent 0,0,19,0.4 Tahoma,8.25,Bold,Point,False,0 Center 0,0,0,0 Text25 Resumo por título Black Expression Transparent 0,0.4,9,0.4 Tahoma,6.75,Bold,Point,False,0 5a391f8f9b4c43f394a3da411ef78879 0,0,0,0 Text30 Título Black Expression Transparent 9,0.4,3.2,0.4 Tahoma,6.75,Bold,Point,False,0 0fe4e436e46a4f2b9cc75729632c7dce Right 0,0,0,0 Text31 Entrada Black Expression Transparent 12.2,0.4,3.4,0.4 Tahoma,6.75,Bold,Point,False,0 23e99f810951497a8e9fa481ee1efec5 Right 0,0,0,0 Text32 Saída Black Expression Transparent 15.6,0.4,3.4,0.4 Tahoma,6.75,Bold,Point,False,0 555a0f3d205d456f9818a679b41bed54 Right 0,0,0,0 Text33 Saldo Black Expression 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive2 Black 19,0.4,0,0 StartPointPrimitive3 2672eb0d586f4d3dabfc9703419427f5 19,0.8,0,0 EndPointPrimitive3 2672eb0d586f4d3dabfc9703419427f5 0,0.4,0,0 StartPointPrimitive4 6d789be25b99465eacb57f73faee0120 0,0.8,0,0 EndPointPrimitive4 6d789be25b99465eacb57f73faee0120 GroupHeaderBand1 Transparent 0,7,19,0.4 Transparent 0,0,8.4,0.4 Tahoma,8.25,Regular,Point,False,0 0,0,0,0 Text26 {movimentacao_titulo.descricao} Black Expression Transparent 9,0,3.2,0.4 movimentacao_titulo.valor_entrada,GreaterThan,_x0030_,,Numeric,Green,Transparent,Arial_x002C_8,True,False,,,None Tahoma,8.25,Regular,Point,False,0 9bbb30b835a84646be5f43b8e421b384 Right 0,0,0,0 Text27 {movimentacao_titulo.valor_entrada} Black , . 9 2 R$ DataColumn Transparent 12.4,0,3.2,0.4 movimentacao_titulo.valor_saida,LessThan,_x0030_,,Numeric,Red,Transparent,Arial_x002C_8,True,False,,,None Tahoma,8.25,Regular,Point,False,0 d0c386ece55b421cb4ed937eddfcec10 Right 0,0,0,0 Text28 {movimentacao_titulo.valor_saida} Black , . 9 2 R$ DataColumn Transparent 15.8,0,3.2,0.4 movimentacao_titulo.saldo,LessThan,_x0030_,,Numeric,Red,Transparent,Arial_x002C_8,True,False,,,None movimentacao_titulo.saldo,GreaterThan,_x0030_,,Numeric,Green,Transparent,Arial_x002C_8,True,False,,,None Tahoma,8.25,Regular,Point,False,0 6cea39deae4d4504a70122a936d22c8a Right 0,0,0,0 Text29 {movimentacao_titulo.saldo} Black , . 9 2 R$ DataColumn 0,0,0,0 StartPointPrimitive1 0e7991cfc2d149a79967cbbf40e72c0d 19,0,0,0 StartPointPrimitive2 08a12d0688384d4e9963036d0fbb7672 19,0.4,0,0 EndPointPrimitive2 08a12d0688384d4e9963036d0fbb7672 0,0.4,0,0 EndPointPrimitive1 0e7991cfc2d149a79967cbbf40e72c0d movimentacao_titulo DataBand2 ASC ordem_titulo Transparent 0,8.2,19,0 0,0,19,0.0254 Black Black 40d537bc4fc34cd9a075297e6cc161d1 HorizontalLinePrimitive3 Black GroupFooterBand2 Transparent 0,9,19,1.6 ReportSummaryBand1 0,7,0.0254,0.4 Black Black 0e7991cfc2d149a79967cbbf40e72c0d VerticalLinePrimitive1 Black 19,7,0.0254,0.4 Black Black 08a12d0688384d4e9963036d0fbb7672 VerticalLinePrimitive2 Black 19,5.8,0.0254,0.4 Black Black 2672eb0d586f4d3dabfc9703419427f5 VerticalLinePrimitive3 Black 0,5.8,0.0254,0.4 Black Black 6d789be25b99465eacb57f73faee0120 VerticalLinePrimitive4 Black 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 32,48,96,20 Microsoft Sans Serif,8 Black Short 512fbd200a9a4d919a0fbf61b43d78bd 32, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 168,48,96,20 Microsoft Sans Serif,8 Black Short ab61df68751d4fc19bffbcf081c8d83e 168, 48 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 32,24,96,24 Microsoft Sans Serif,8 Black 311dca0a585344818fe1236b7fd12bdc 32, 24 LabelControl1 96, 24 Data Inicial Control 168,24,96,24 Microsoft Sans Serif,8 Black 0567491c7957498e894c25b7b8eb83e3 168, 24 LabelControl2 96, 24 Data Final 32,96,96,24 Cancel Microsoft Sans Serif,8 Black 22ca6de21c3e49ea89572962f862e206 32, 96 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; 168,96,96,24 OK Microsoft Sans Serif,8 Black f63bbac97097459a9f6aa9492e71cea7 168, 96 btnGerar 96, 24 Gerar Microsoft Sans Serif,8 e33849f03cdc4605ad9271c9d0f53e6a 0, 0 Form1 304, 176 Período System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Gestor.exe Report 8/2/2019 9:26:28 AM 9/25/2015 9:37:43 PM fc7029077e694b17914d86fc86394c01 Report Centimeters 2015.1.0 CSharp