Gestor 49S5CWcLG+XCEIRAenQqXoYggYnna9N94kOhCE34amPHwM/rQ12Tzf96nITotGUX+XqBK9cDuk16bKW94iXh/8R448vGbPMFf2eEGE30 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 vendedor,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 id,System.Int32 orcamento_id,System.Int32 nome_fantasia,System.String data_vencimento,System.DateTime total_produtos,System.Decimal valor_documento,System.Decimal comissao_prazo,System.Decimal comissao,System.Decimal funcionario_id,System.Int32 30 False dados Gestor select receber.id, orc.id AS orcamento_id, cor.id AS funcionario_id, cor.nome_fantasia, receber.data_vencimento, orc.total_produtos, receber.valor_documento, prod.comissao_prazo, (prod.comissao_prazo*receber.valor_documento/100) as comissao from receber inner join orcamento orc on orc.id = receber.orcamento_id inner join correntista cor on cor.id = orc.vendedor_id inner join orcamento_item orc_item on orc_item.id = orc.id inner join produto prod on prod.id = orc_item.produto_id where cor.id = {funcionario_id} AND DATE_FORMAT(CAST(receber.data_vencimento 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') funcionario id,System.Int32 tipo_pessoa,System.String nome_fantasia,System.String razao_social,System.String contato,System.String data_nascimento,System.DateTime cep,System.String endereco,System.String numero,System.String bairro,System.String uf,System.String cpf_cnpj,System.String rg_ie,System.String telefone,System.String celular,System.String fax,System.String email,System.String limite_credito,System.Decimal data_cadastro,System.DateTime observacoes,System.String cliente,System.Boolean funcionario,System.Boolean fornecedor,System.Boolean estado_civil,System.String inativo,System.Boolean usuario,System.String senha,System.String liberador,System.Boolean seq_sincronizacao,System.Int64 codigo_retaguarda,System.String fun_limite_desconto,System.Decimal ddd_telefone,System.String ddd_celular,System.String limite_credito_utilizado,System.Decimal limite_credito_saldo,System.Decimal complemento,System.String inscricao_municipal,System.String filiacao_mae,System.String filiacao_pai,System.String conjuge_nome,System.String conjuge_telefone,System.String conjuge_celular,System.String conjuge_local_trabalho,System.String trabalho_empresa,System.String trabalho_cargo,System.String trabalho_data_admissao,System.DateTime trabalho_renda,System.Decimal senha_venda,System.String nao_contribuinte_icms,System.Boolean bairro_id,System.Int32 cidade_id,System.Int32 grupo_usuario_id,System.Int32 grupo_correntista_id,System.Int32 codigo_ibge_temp,System.String codigo_temp,System.String sexo_temp,System.String ie_produtor_rural,System.String pais_id,System.Int32 codigo_geral,System.String id_cliente_temp,System.String 30 False funcionario Gestor select * from correntista where funcionario = 1 ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,data_inicial,data_inicial,System.String,_x0032_016-03-01,False,False ,data_final,data_final,System.String,_x0032_016-03-31,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM_x002C__x005F_x0038__x005F_x002F_13_x005F_x002F_2018_x005F_x0020_5:05:43_x005F_x0020_PM,False,False ,funcionario_id,funcionario_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 0,0.4,19,4.2 Transparent 0,3.6,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 6aa5f4c980424a969091ce71aa8350e9 0,0,0,0 Text7 Orçamento Black Expression Center Transparent 9.6,3.6,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 25b3e00199a9436da49eb6fa22d15ea8 Right 0,0,0,0 Text8 Vencimento Black Expression Center Transparent 11.8,3.6,2.6,0.6 Tahoma,8.25,Bold,Point,False,0 d11c387559eb446789ad6bf9c0dccac2 Right 0,0,0,0 Text15 Valor Venda 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 b477fa6ca8314ffa84101e90adebd93d Center 0,0,0,0 Text1 COMISSÃO POR PARCELA Black Expression 5ec57d6d6fbe4b22832fe900eedd309a Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 e3190c0b3e734bae98aaceae2c9ffb0f 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 4e7cbdc300ca4665802434919c3f2389 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 bffdaccca0f24554a72a6fec6963f170 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 4bc9fbfe1a76416ca43ed1d751c7b3dc Right 0,0,0,0 Text5 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4de07384d7b7483a9f15ace801a7cd10 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 e28baa4eb74e43088c2bb843fee4bff4 0,0,0,0 Text44 {descricao_filtros} Black Expression Center Transparent 2.2,3.6,7.4,0.6 Tahoma,8.25,Bold,Point,False,0 7c7db95f5a7c4550ad0cd9026aae8930 0,0,0,0 Text6 Funcionário Black Expression Center Transparent 14.4,3.6,2.2,0.6 Tahoma,8.25,Bold,Point,False,0 744fd17fe4fc4c20b50bc94cb8095ac4 Right 0,0,0,0 Text10 Valor Parcela Black Expression Center Transparent 16.6,3.6,2.4,0.6 Tahoma,8.25,Bold,Point,False,0 60edbc88256f47188dd1a617cf1bfce7 Right 0,0,0,0 Text12 Valor Comissão Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.4 Transparent 0,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 875b64180bc5418b91de014409aae1a8 0,0,0,0 Text17 {dados.orcamento_id} Black Expression Center Transparent 9.6,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 370d957aae4747f5aec6969808496bbe Right 0,0,0,0 Text18 {dados.data_vencimento} Black Expression Center Transparent 11.8,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 5616320a93cc47beb3d7fc99231bcfed Right 0,0,0,0 Text19 {dados.total_produtos} Black , . 9 2 R$ DataColumn Center Transparent 16.6,0,2.4,0.4 Tahoma,8.25,Regular,Point,False,0 cf214530264f4906bf43027dac9e5104 Right 0,0,0,0 Text22 {dados.comissao} Black , . 9 2 R$ DataColumn Center Transparent 2.2,0,7.4,0.4 Tahoma,8.25,Regular,Point,False,0 f6b6eb8ac266473e8db59b30b31394f2 0,0,0,0 Text9 {dados.nome_fantasia} Black Expression Center Transparent 14.4,0,2.2,0.4 Tahoma,8.25,Regular,Point,False,0 c1fef7f62aa04187ab1dac5906bf33da Right 0,0,0,0 Text13 {dados.valor_documento} Black , . 9 2 R$ Expression Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados comissao,GreaterThan,_x0030_,,Numeric DataBand1 ASC data ASC orcamento Transparent 0,6.6,19,1.6 Transparent 0,0,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 d96c709d6edc48cabfb510eb0750af4b 0,0,0,0 Text11 Total de comissão: Black Expression Center Transparent 2.8,0,3.8,0.6 Tahoma,8.25,Regular,Point,False,0 fc21a38b13a643ef90f1516ba88ddd66 0,0,0,0 Text23 {Sum(DataBand1,dados.comissao)} Black , . 9 2 R$ Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 24,48,96,20 Microsoft Sans Serif,8 Black Short 44dbb8891ae947eb868e6e318f58522c 24, 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 160,48,96,20 Microsoft Sans Serif,8 Black Short 3c782d4b80514954997c098abb36c123 160, 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 24,24,96,24 Microsoft Sans Serif,8 Black 43da8f65be6f4108a7a0596d0325402a 24, 24 LabelControl1 96, 24 Data Inicial Control 160,24,96,24 Microsoft Sans Serif,8 Black 1fe8aeb8a6734445b909848fbd2101a4 160, 24 LabelControl2 96, 24 Data Final 24,168,96,24 Cancel Microsoft Sans Serif,8 Black deb367707b034b328af1f1fe786ca8cb 24, 168 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; int.TryParse(txtFuncionario.SelectedValue.ToString(), out funcionario_id); 160,168,96,24 OK Microsoft Sans Serif,8 Black bec8be4d22bc4e699efbc59fcdddfe6e 160, 168 btnGerar 96, 24 Gerar Window 24,128,232,20 Microsoft Sans Serif,8 Black f570008a92f7445589e1587719e6f853 24, 128 txtFuncionario 232, 20 Control 24,112,96,16 Microsoft Sans Serif,8 Black 8b783cae4ec645728fc1b82203c6231b 24, 112 LabelControl3 96, 16 Funcionário Microsoft Sans Serif,8 085a40e77afb4c0ba6124cf1f7a823c1 txtFuncionario.Control.Items.Clear(); txtFuncionario.Control.DisplayMember = "nome_fantasia"; txtFuncionario.Control.ValueMember = "id"; txtFuncionario.Control.DataSource = this.Dictionary.DataSources["funcionario"].DataTable; 0, 0 Form1 304, 232 Informe o periodo 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/13/2018 5:14:24 PM 9/25/2015 9:37:43 PM Report.mrt aa555272e28e4cedad7bbd64672b1999 Report Centimeters 2015.1.0 CSharp