Gestor 41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c 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 codigo,System.Int32 nome,System.String estoque,System.Decimal marca,System.String valor_compra,System.Decimal valor_venda,System.Decimal sigla,System.String quantidade_compra,System.Decimal total_compra,System.Decimal quantidade_venda,System.Decimal total_venda,System.Decimal valor_estoque,System.Decimal tipo_mercadoria,System.String valor_custo,System.Decimal 30 False dados Gestor select p.id as codigo, p.valor_custo, p.descricao as nome, p.marca, p.valor_compra, p.valor_venda, p.tipo_mercadoria,p.estoque, u.sigla as sigla, (select coalesce(sum(item.quantidade), 0) from mov_estoque_item item inner join mov_estoque mov on mov.id = item.movimentacao_estoque_id where mov.status = 'Fechado' and item.produto_id = p.id ) as quantidade_compra, (select coalesce(sum(item.valor_total), 0) from mov_estoque_item item inner join mov_estoque mov on mov.id = item.movimentacao_estoque_id where mov.status = 'Fechado' and item.produto_id = p.id ) as total_compra, (select coalesce(sum(item.quantidade), 0) from orcamento_item item inner join orcamento orc on orc.id = item.orcamento_id where orc.status = 'Faturado' and item.produto_id = p.id ) as quantidade_venda, (select coalesce(sum(item.valor_liquido), 0) from orcamento_item item inner join orcamento orc on orc.id = item.orcamento_id where orc.status = 'Faturado' and item.produto_id = p.id ) as total_venda, case when p.estoque > 0 then sum(p.valor_venda * p.estoque) else 0 end as valor_estoque from produto p left join unidade u on u.id = p.unidade_id left join (select un.sigla, pu.fator_conversao, pu.produto_id from produto_unidade pu inner join unidade un on un.id = pu.unidade_id) as un_sec ON un_sec.produto_id = p.id where p.inativo = 0 and p.tipo_mercadoria <> '09 - SERVICOS' and p.estoque > 0 and case when '{grupo_id}' <> '' and '{grupo_id}' <> '0' then p.grupo_id in ({grupo_id}) else 1 = 1 end and case when '{subgrupo_id}' <> '' and '{subgrupo_id}' <> '0' then p.subgrupo_id in ({subgrupo_id}) else 1 = 1 end and case when '{produto_id}' <> '' and '{produto_id}' <> '0' then p.id in ({produto_id}) else 1 = 1 end group by p.id ,grupo_id,Grupo,Grupo_x0020_do_x0020_produto,System.String,_x0030_,False,False,False ,subgrupo_id,subgrupo_id,Subgrupo_x0020_de_x0020_produtos,System.String,_x0030_,False,False,False ,produto_id,produto_id,Código_x0020_do_x0020_produto,System.String,_x0030_,False,False,False ,tipo_unidade,tipo_unidade,Tipo_x0020_de_x0020_unidade_x0020_a_x0020_ser_x0020_utilizada,System.String,_x0031_,False,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,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,4.2,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,3.6 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 90389c2d449a41bd9ad3828265a183af Center 0,0,0,0 Text1 INVENTÁRIO DE ESTOQUE Black Expression 80a81346cc9f4d53b794a0dcd3e69a5b Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 3d8e041e8fa14d408107f4d82a0be504 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 ba465ff4be094ba1b7a1e140dca5afbe 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 1f9e690879664329a8ee049b38366c58 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 679f8e370e874eee8399094c5d3bc60c Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo ae8bc5f5a0c542b0a541565ed7771b22 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 cc8a05f040374ccb89ba4c151cbe8ba2 0,0,0,0 Text44 {descricao_filtros} Black Expression Center ReportTitleBand1 Transparent 0,4.8,19,1.4 Transparent 0,0.2,3.4,0.6 Arial,9.75,Bold,Point,False,0 0,0,0,0 Text30 Tipo de mercadoria: Black Expression Center Transparent 3.4,0.2,15.6,0.6 Arial,9.75,Bold,Point,False,0 0c91e098401a4ff28d868b229027b84e 0,0,0,0 Text31 {dados.tipo_mercadoria} Black Expression Center Transparent 0,0.8,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Código Black Expression Center Transparent 1.4,0.8,10.4,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 Nome do produto Black Expression Center Transparent 11.8,0.8,0.6,0.6 Tahoma,8.25,Bold,Point,False,0 6aa5f4c980424a969091ce71aa8350e9 0,0,0,0 Text7 UN Black Expression Center Transparent 15.6,0.8,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 ee8f75f70dd148b288819f8abe43120d Right 0,0,0,0 Text11 Vl. Venda Black Expression Center Transparent 12.4,0.8,1.4,0.6 Tahoma,8.25,Bold,Point,False,0 d76ab58b7d974f49b2b3a003a515e2a9 Right 0,0,0,0 Text26 Vl. custo Black Expression Center Transparent 17.4,0.8,1.6,0.6 Tahoma,8.25,Bold,Point,False,0 610b930b511a4d06a1f3866ee6b800ce Right 0,0,0,0 Text9 Estoque Black Expression Center Transparent 13.8,0.8,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 867738426bb54e3e9225fe6615702c70 Right 0,0,0,0 Text8 Vl. Compra Black Expression Center {dados.tipo_mercadoria} GroupHeaderBand1 Transparent 0,7,19,0.4 Transparent 0,0,1.4,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text12 {dados.codigo} Black 00000 Transparent 1.4,0,10.4,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text13 {dados.nome} Black Transparent 11.8,0,0.6,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text15 {dados.sigla} Black Transparent 13.8,0,1.8,0.4 Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text19 {dados.valor_compra} Black , . 1 False Expression Transparent 12.4,0,1.4,0.4 Tahoma,6.75,Regular,Point,False,0 b412d2cb312f403c909c987a86b1ec7b Right 0,0,0,0 Text27 {dados.valor_custo} Black , . 1 False DataColumn Transparent 17.4,0,1.6,0.4 Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text17 {dados.estoque} Black , . 1 False Transparent 15.6,0,1.8,0.4 Tahoma,6.75,Regular,Point,False,0 6f10aa94ccc74b1d93a80c4f432ae530 Right 0,0,0,0 Text10 {dados.valor_venda} Black , . 1 False DataColumn 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC codigo Transparent 0,8.2,19,1.6 Transparent 13,0,2.8,1.6 Tahoma,8.25,Regular,Point,False,0 6628cbd893e3491181e4cc0f3ce50cc8 0,0,0,0 Text32 Qtde itens: Total custo: Total compra: Total venda: Black Expression Center Transparent 15.8,0,3.2,1.6 Tahoma,8.25,Bold,Point,False,0 22bb5d4e44eb4c40bc59957b87dd311d Right 0,0,0,0 Text33 {Count(DataBand1)} {Format("{0:C2}", Sum(dados.valor_custo*dados.estoque))} {Format("{0:C2}", Sum(dados.valor_compra*dados.estoque))} {Format("{0:C2}", Sum(dados.valor_venda*dados.estoque))} Black Expression Center 0,0,0,0 StartPointPrimitive4 2c01ff857742478c8093814c1b68ad7d GroupFooterBand1 Transparent 0,10.6,19,4.2 Transparent 13.4,0.4,2.4,0.6 Tahoma,8.25,Regular,Point,False,0 799a8c70a7894fcf937bff203934c3a7 0,0,0,0 Text28 Qtde itens: Black Expression Center Transparent 15.8,0.4,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 663c3a3084384fe5b76a2651e72bd8f2 Right 0,0,0,0 Text29 {Count(DataBand1)} Black Expression Center Transparent 13.4,0,2.4,0.4 Tahoma,8.25,Bold,Point,False,0 90daa433fb51414bb018daeff04a83ec 0,0,0,0 Text34 TOTAIS Black Expression Center Transparent 15.8,1,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 163a79fbff284074b5eb7470b5092719 Right 0,0,0,0 Text35 {Sum(dados.estoque * dados.valor_custo)} Black , . 1 Expression Center Transparent 13.4,1,2.4,0.6 Tahoma,8.25,Regular,Point,False,0 f613b18ff59240868065c37e80557b36 0,0,0,0 Text36 Total Custo: Black Expression Center Transparent 15.8,1.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 e85e13c4105e4237a805eeeb48701e86 Right 0,0,0,0 Text16 {Sum(dados.estoque * dados.valor_compra)} Black , . 1 Expression Center Transparent 13.4,1.6,2.4,0.6 Tahoma,8.25,Regular,Point,False,0 b09a70ac6a32445996247c9bde01daee 0,0,0,0 Text18 Total Compra: Black Expression Center Transparent 15.8,2.2,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 fd7ca68e888f4f619fc28674d19c1717 Right 0,0,0,0 Text22 {Sum(dados.estoque * dados.valor_venda)} Black , . 1 Expression Center Transparent 13.4,2.2,2.4,0.6 Tahoma,8.25,Regular,Point,False,0 545dcb44feb94ed1a15ee5a36f960706 0,0,0,0 Text23 Total Venda: Black Expression Center 19,-0.4,0,0 EndPointPrimitive4 2c01ff857742478c8093814c1b68ad7d 13.4,0.4,0,0 StartPointPrimitive5 3b5ea4b8b66e4aa69ad4439ddbd7c4ab 19,2.8,0,0 EndPointPrimitive5 3b5ea4b8b66e4aa69ad4439ddbd7c4ab ReportSummaryBand1 False 0,8.2,19,2 Black 2c01ff857742478c8093814c1b68ad7d False RectanglePrimitive4 False 13.4,11,5.6,2.4 Black 3b5ea4b8b66e4aa69ad4439ddbd7c4ab RectanglePrimitive5 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 Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 5/21/2019 9:22:10 AM 9/25/2015 9:37:43 PM 5eb4c468408d45e99ab50fc8ccf193cc Report Centimeters 2015.1.0 CSharp