Gestor 41TjAkZK2dlrCDGlY3htm9Vunc9YSyIda1r9vftMJWP8WGmNW1fLdcNDVQhomGpnwi53Tl5tQfnnQZwYYxjri9LeZUxNV3oNRmesGE2Ed2PDePcJX05KzWxs2YX/GCWTixbZS1NnQ1VuYZypdi3oD/EY2Yo= 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 produto_id,System.Int32 descricao,System.String quantidade,System.Decimal valor_liquido,System.Decimal estoque,System.Decimal 30 False dados Gestor SELECT item.produto_id, item.descricao, SUM(item.quantidade) AS quantidade, SUM(item.valor_liquido - ROUND(orcamento.valor_desconto * ((item.valor_bruto * 100) / orcamento.valor_bruto) / 100, 2) + CASE WHEN item.id = (SELECT MAX(orcamento_item.id) FROM orcamento_item WHERE orcamento_item.orcamento_id = item.orcamento_id) THEN -- VERIFICAR DIFERENÇA ENTRE TODOS VALORES CALCULADOS E VALOR LIQUIDO DO ORÇAMENTO orcamento.valor_liquido - (SELECT SUM(item2.valor_liquido - ROUND(orcamento.valor_desconto * ((item2.valor_bruto * 100) / orcamento.valor_bruto) / 100, 2)) FROM orcamento_item item2 WHERE item2.orcamento_id = item.orcamento_id) ELSE 0 END) AS valor_liquido, produto.estoque FROM orcamento_item item INNER JOIN orcamento ON orcamento.id = item.orcamento_id INNER JOIN produto ON produto.id = item.produto_id WHERE orcamento.data_emissao BETWEEN '{data_inicial}' AND '{data_final}' AND ( CASE WHEN '{grupo_id}' <> '' AND '{grupo_id}' <> '0' THEN produto.grupo_id IN ({grupo_id}) ELSE 1 = 1 END AND CASE WHEN '{subgrupo_id}' <> '' AND '{subgrupo_id}' <> '0' THEN produto.subgrupo_id IN ({subgrupo_id}) ELSE 1 = 1 END AND CASE WHEN '{familia_id}' <> '' AND '{familia_id}' <> '0' THEN produto.familia_id IN ({familia_id}) ELSE 1 = 1 END AND CASE WHEN '{produto_id}' <> '' AND '{produto_id}' <> '0' THEN item.produto_id IN ({produto_id}) ELSE 1 = 1 END) AND orcamento.status = 'Faturado' AND CASE WHEN '{tipo_mercadoria}' <> '' THEN produto.tipo_mercadoria = '{tipo_mercadoria}' ELSE 1 = 1 END AND CASE WHEN '{vendedor_id}' <> '0' THEN orcamento.vendedor_id = {vendedor_id} ELSE 1 = 1 END GROUP BY item.produto_id, item.descricao StoredProcedure ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,produto_id,produto_id,System.String,_x0030_,False,False ,grupo_id,grupo_id,System.String,_x0030_,False,False ,subgrupo_id,subgrupo_id,System.String,_x0030_,False,False ,familia_id,familia_id,System.String,_x0030_,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,agrupar_produtos,agrupar_produtos,System.String,,False,False ,tipo_mercadoria,tipo_mercadoria,System.String,,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,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 22.4,0.6,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 e765e1718f9b42739e82d794b7030864 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 24.6,1,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 f5777b5814fd4ba3ad34e073c29fca76 Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0.4,19,4.2 Transparent 0,3.6,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Código Black Expression Center Transparent 1.8,3.6,9.6,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 Produto Black Expression Center Transparent 11.4,3.6,2.4,0.6 Tahoma,8.25,Bold,Point,False,0 610b930b511a4d06a1f3866ee6b800ce Right 0,0,0,0 Text9 Qtde vendida Black Expression Center Transparent 16.2,3.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 Right 0,0,0,0 Text10 Valor líquido 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 781d2eafa39f4cfd8624172f344d8295 Center 0,0,0,0 Text1 RESUMO DE VENDAS - COM NF Black Expression 300f366621684f32953b76a2d6198877 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 d087582087324b43b26b933783e54715 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 bb9274ce219d404b9b7c76e7c06192c3 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 08f13c99801d43d8a8d329504e224755 Right 0,0,0,0 Text18 {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 6fb81d3b212e44629b8a45ea3312aead Right 0,0,0,0 Text19 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4c2d6b0c76e04a869266abd979183a20 imgLogo True Transparent True 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a3d652b2a4424de8bdf396547c4df7b7 0,0,0,0 Text44 {descricao_filtros} Black ,,,,WordWrap=True,A=0 Expression Center Transparent 13.8,3.6,2.4,0.6 Tahoma,8.25,Bold,Point,False,0 4d2006c5609b4c418fa88c8b6f05fead Right 0,0,0,0 Text22 Estoque atual Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 823f0e539bf34e6e9cb7e81069b3fee9 0,0,0,0 Text7 {dados.produto_id} Black Expression Center Transparent 1.8,0,9.6,0.4 Tahoma,8.25,Regular,Point,False,0 db8253923816400da5eb4ac8cd73fb4b 0,0,0,0 Text8 {dados.descricao} Black DataColumn Center Transparent 11.4,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 f5e2038486324457a3c9d4aff4613dc9 Right 0,0,0,0 Text11 {dados.quantidade} Black 3 , . 1 False Expression Center Transparent 16.2,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 e52c597148f9466f868f815d9acf72f2 Right 0,0,0,0 Text12 {dados.valor_liquido} Black , . 1 False DataColumn Center Transparent 13.8,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 f908fab0081c4bada8cfb7485dafe41c Right 0,0,0,0 Text23 {dados.estoque} Black 3 , . 1 False DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC descricao Transparent 0,6.6,19,2.8 Transparent 14.4,0.2,1.6,0.4 Tahoma,8.25,Regular,Point,False,0 fe836a0d4c6740aeb70ff8b11921ea01 Right 0,0,0,0 Text13 Valor total: Black Expression Center Transparent 16.4,0.2,2.6,0.4 Tahoma,8.25,Bold,Point,False,0 949cfc4fa2d64f75bf386fc03d9051d1 0,0,0,0 Text15 {Sum(DataBand1,dados.valor_liquido)} Black , . 9 2 R$ Totals Center Transparent 14.4,0.6,2,0.4 Tahoma,8.25,Regular,Point,False,0 8940114984be440fa816aae2d2762e52 Right 0,0,0,0 Text16 Qtde vendida: Black Expression Center Transparent 16.4,0.6,2.6,0.4 Tahoma,8.25,Bold,Point,False,0 e259fa11c2ac4fde9f8291bbf69d1200 0,0,0,0 Text17 {Sum(DataBand1,dados.quantidade)} Black , . 1 Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 8/16/2019 3:24:56 PM 9/25/2015 9:37:43 PM f2338eb401e74cf48f5c582d2477d0c5 Report Centimeters 2015.1.0 CSharp