<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.8.27" DotMatrixReport="False" EngineOptions.MaxMemSize="20" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="40602,6690597801" ReportOptions.Description.Text="" ReportOptions.LastChange="41514,6865257639" ScriptLanguage="PascalScript" ScriptText.Text="{&#13;&#10;========================================================================                                                                          &#13;&#10;Relatório Padrão Simples&#13;&#10;&#13;&#10;  Não exclua os Objetos das Bands: &#34;TituloRelatorio&#34; (Filtros = opcional),   &#13;&#10;  &#34;Rodape Pagina&#34; e nem os bjs &#34;QPrincipal&#34; e &#34;QEmpresa&#34;.&#13;&#10;  Use a QPrincipal para o SQL principal, pois a checagem abaixo é para&#13;&#10;  verificar se há registros na mesma.&#13;&#10;  O cabeçalho já esta pronto, não esqueça de alterar o objeto &#34;Título&#34; &#13;&#10;  e/ou &#34;Referencia&#34; (opcional) e de alimentar a variavel  &#34;CodEmpresa&#34; &#13;&#10;  (pelo programa) para que o nome da empresa seja mostrado e tbm a &#13;&#10;  variável &#34;Filtros&#34; (opcional, mas lembre-se de passar por aspas os &#13;&#10;  valores do filtro)&#13;&#10;  Procure passar todos os valores para o filtros do SQL (cláusula WHERE)&#13;&#10;  por variavéis (componente TfrxVariables) pelo programa.&#13;&#10;  Mantenha os objetos alinhados sem deixar espeços entre eles (sujestão.:&#13;&#10;  use propriedade Align)                                                            &#13;&#10;&#13;&#10;&#13;&#10;  por Jaime P.Jr em 15/04/2013&#13;&#10;========================================================================}&#13;&#10;procedure GroupHeader1OnAfterPrint(Sender: TfrxComponent);&#13;&#10;  var x:real;                                  &#13;&#10;begin&#13;&#10;  Set('TotBruto',&#60;TotBruto&#62;+&#60;QPrincipal.&#34;MVC_TOTMOV&#34;&#62;);    &#13;&#10;  Set('TotLiquido',&#60;TotLiquido&#62;+&#60;QPrincipal.&#34;TotalLiq&#34;&#62;);&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;//testes&#13;&#10;{    &#13;&#10;  Set('DtIni',StrToDate('11/05/2013'));&#13;&#10;  Set('DtFin',StrToDate('11/06/2013'));&#13;&#10;  Set('TipoData','0');&#13;&#10;  Set('CodOper','0');&#13;&#10;  &#13;&#10;  Set('CodEmpresa','1');&#13;&#10;  Set('RelReferencia','''????''');&#13;&#10;  Set('Filtros','''nada''');    &#13;&#10;}// fim testes                                       &#13;&#10;  &#13;&#10;  Set('TotBruto','0');&#13;&#10;  Set('TotLiquido','0');    &#13;&#10;&#13;&#10;{Checagem de dados - Não remova as linhas abaixo}&#13;&#10;  QPrincipal.Open;                 &#13;&#10;  if QPrincipal.IsEmpty then&#13;&#10;  begin              &#13;&#10;    CreateError('Não exitem registros para os filtros selecionados.');&#13;&#10;  end;&#13;&#10;{fim}&#13;&#10;&#13;&#10;    &#13;&#10;end." StoreInDFM="False" PropData="044C65667403D80203546F7002100844617461736574730101062A20446174615365743D2251456D70726573612220446174615365744E616D653D2251456D7072657361220001062E20446174615365743D22515072696E636970616C2220446174615365744E616D653D22515072696E636970616C220000095661726961626C65730101061C204E616D653D22436F64456D7072657361222056616C75653D22312200011453000000204E616D653D2246696C74726F73222056616C75653D2227506572C3AD6F646F2064652032382F30382F313320C3A02032382F30382F31333B20506F7220446174612064652056656E63696D656E746F3B272200010624204E616D653D2252656C5265666572656E636961222056616C75653D22273255303027220001061B204E616D653D224474496E69222056616C75653D223431353134220001061B204E616D653D22447446696E222056616C75653D2234313531342200010619204E616D653D22436F644F706572222056616C75653D2230220001061A204E616D653D225469706F44617461222056616C75653D2230220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADOQuery Name="QPrincipal" UserName="QPrincipal" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="declare @DtIni date = :DtIni,&#13;&#10;        @DtFin date = :DtFin,&#13;&#10;        @TipoData tinyint = :TipoData,&#13;&#10;        @CodOper int = :CodOper                                            &#13;&#10;&#13;&#10;select mov.*,&#13;&#10;cad.opc_descri,&#13;&#10;cad.OPC_TAXOPE,&#13;&#10;(select sum(MCD_VLRPAR) from mov_operadoras_cartao_det where MCD_CODMVC=mov.MVC_SEQUEN)*cad.OPC_TAXOPE/100 Desconto,&#13;&#10;MVC_TOTMOV*(1-cad.OPC_TAXOPE/100) TotalLiq,&#13;&#10;det.*&#13;&#10;&#13;&#10;from mov_operadoras_cartao mov&#13;&#10;inner join cad_operadoras_cartao cad on cad.OPC_CODIGO=mov.MVC_OPECOD&#13;&#10;inner join mov_operadoras_cartao_det det on det.MCD_CODMVC=mov.MVC_SEQUEN&#13;&#10;where cast(case @TipoData &#13;&#10;            when 0 then mvc_dtaope&#13;&#10;            when 1 then mcd_dtaven                &#13;&#10;          end as date) between @DtIni and @DtFin&#13;&#10;and ((@CodOper=0) or (MVC_OpeCod=@CodOper))&#13;&#10;order by mov.MVC_SEQUEN                        " CommandTimeout="1800" LockType="ltReadOnly" PropData="05704C65667402200470546F70021C0A506172616D65746572730101063C204E616D653D224474496E69222044617461547970653D22667444617465222045787072657373696F6E3D22262336303B4474496E69262336323B220001063C204E616D653D22447446696E222044617461547970653D22667444617465222045787072657373696F6E3D22262336303B447446696E262336323B2200010646204E616D653D225469706F44617461222044617461547970653D226674536D616C6C696E74222045787072657373696F6E3D22262336303B5469706F44617461262336323B2200010643204E616D653D22436F644F706572222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B436F644F706572262336323B220000"/>
    <TfrxADOQuery Name="QEmpresa" UserName="QEmpresa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="select emp_nomemp &#13;&#10;from cademp &#13;&#10;where EMP_CODIGO=:CodEmpresa" CommandTimeout="1800" LockType="ltReadOnly" PropData="05704C656674025C0470546F70021C0A506172616D657465727301010649204E616D653D22436F64456D7072657361222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B436F64456D7072657361262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Relatorio1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="TituloRelatorio" Height="68,91342" Left="0" Top="16" Width="718,1107" Stretched="True">
      <TfrxMemoView Name="Titulo" Align="baWidth" Left="0" Top="18,8976378" Width="517,79561" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Courier New" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="Movimento de Cartões/Operadoras"/>
      <TfrxMemoView Name="RelReferencia" Align="baRight" Left="517,79561" Top="19" Width="200,31509" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Courier New" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[IIF(&#60;RelReferencia&#62;='','','(Ref.:'+&#60;RelReferencia&#62;+')')]"/>
      <TfrxMemoView Name="Filtros" Align="baWidth" Left="56,69295" Top="38,67718" Width="661,41775" Height="30,23624" ShowHint="False" StretchMode="smMaxHeight" Font.Charset="0" Font.Color="0" Font.Height="-11" Font.Name="Courier New" Font.Style="0" ParentFont="False" Text="[&#60;Filtros&#62;]"/>
      <TfrxMemoView Name="LblFiltros" Align="baLeft" Left="0" Top="38,67718" Width="56,69295" Height="30,23624" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Courier New" Font.Style="0" ParentFont="False" Text="Filtros:"/>
      <TfrxMemoView Name="NomeEmpresa" Align="baWidth" Left="0" Top="0" Width="517,79561" Height="18,89765" ShowHint="False" DataField="EMP_NOMEMP" DataSet="QEmpresa" DataSetName="QEmpresa" Font.Charset="0" Font.Color="0" Font.Height="-13" Font.Name="Courier New" Font.Style="0" ParentFont="False" Text="[QEmpresa.&#34;EMP_NOMEMP&#34;]"/>
      <TfrxMemoView Name="Emissao" Align="baRight" Left="517,79561" Top="0" Width="200,31509" Height="15,11812" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Courier New" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Emissão: [DATE] [Time]"/>
    </TfrxReportTitle>
    <TfrxPageHeader Name="CabecalhoPagina" Height="15,1181078" Left="0" Top="104" Width="718,1107">
      <TfrxMemoView Name="Memo8" Align="baLeft" Left="0" Top="0" Width="56,69295" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="12" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Seq."/>
      <TfrxMemoView Name="Memo9" Align="baLeft" Left="56,69295" Top="0" Width="207,87415" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="12" ParentFont="False" VAlign="vaCenter" Text="Operadora"/>
      <TfrxMemoView Name="Memo10" Align="baLeft" Left="377,952926771654" Top="0" Width="75,5906" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="12" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Taxa Oper."/>
      <TfrxMemoView Name="Memo11" Align="baLeft" Left="264,5671" Top="0" Width="113,385826771654" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="12" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Total Bruto"/>
      <TfrxMemoView Name="Memo12" Align="baLeft" Left="453,543526771654" Top="0" Width="113,3859" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="12" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Total Líq."/>
    </TfrxPageHeader>
    <TfrxReportSummary Name="ResumoRelatorio" Height="18,89765" Left="0" Top="276" Width="718,1107">
      <TfrxMemoView Name="Memo4" Align="baLeft" Left="453,543526771654" Top="0" Width="113,3859" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[TotLiquido]"/>
      <TfrxMemoView Name="Memo5" Align="baLeft" Left="264,5671" Top="0" Width="113,385826771654" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[TotBruto]"/>
      <TfrxMemoView Name="Memo6" Align="baLeft" Left="0" Top="0" Width="264,5671" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Totais Gerais"/>
      <TfrxMemoView Name="Memo7" Align="baLeft" Left="377,952926771654" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="[(1-(&#60;TotLiquido&#62;/&#60;TotBruto&#62;))*100 #n%2,2f]%"/>
    </TfrxReportSummary>
    <TfrxPageFooter Name="RodapePagina" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="0" Height="15,11812" Left="0" ParentFont="False" Top="316" Width="718,1107">
      <TfrxSysMemoView Name="TotalPaginas" Align="baRight" Left="612,28386" Top="0,13385827" Width="105,82684" Height="15,11812" ShowHint="False" Font.Charset="0" Font.Color="0" Font.Height="-12" Font.Name="Courier New" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[PAGE#]/[TOTALPAGES#]"/>
    </TfrxPageFooter>
    <TfrxMasterData Name="MDPrincipal" Height="18,8976378" Left="0" Top="196" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="QPrincipal" DataSetName="QPrincipal" RowCount="0">
      <TfrxMemoView Name="QPrincipalMCD_NUMPAR" Left="37,7953" Top="0" Width="94,48825" Height="18,89765" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="[QPrincipal.&#34;MCD_NUMPAR&#34;]º"/>
      <TfrxMemoView Name="QPrincipalMCD_DTAVEN" Left="131,5906" Top="0" Width="102,04731" Height="18,89765" ShowHint="False" DataField="MCD_DTAVEN" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="[QPrincipal.&#34;MCD_DTAVEN&#34;]"/>
      <TfrxMemoView Name="QPrincipalMCD_VLRPAR" Left="336,12616" Top="0" Width="94,48825" Height="18,89765" ShowHint="False" DataField="MCD_VLRPAR" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[QPrincipal.&#34;MCD_VLRPAR&#34;]"/>
      <TfrxMemoView Name="Memo18" Left="233,9765" Top="0" Width="102,04731" Height="18,89765" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="[QPrincipal.&#34;MVC_DTAOPE&#34;]"/>
    </TfrxMasterData>
    <TfrxGroupHeader Name="GroupHeader1" Height="34,01577" Left="0" Top="140" Width="718,1107" OnAfterPrint="GroupHeader1OnAfterPrint" Condition="QPrincipal.&#34;MVC_SEQUEN&#34;">
      <TfrxMemoView Name="Memo3" Align="baLeft" Left="0" Top="0" Width="56,69295" Height="18,89765" ShowHint="False" DataField="MVC_SEQUEN" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Courier New" Font.Style="1" ParentFont="False" Text="[QPrincipal.&#34;MVC_SEQUEN&#34;]"/>
      <TfrxMemoView Name="QPrincipalopc_descri" Align="baLeft" Left="56,69295" Top="0" Width="207,87415" Height="18,89765" ShowHint="False" DataField="opc_descri" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" ParentFont="False" Text="[QPrincipal.&#34;opc_descri&#34;]"/>
      <TfrxMemoView Name="QPrincipalOPC_TAXOPE" Align="baLeft" Left="377,952926771654" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="[QPrincipal.&#34;OPC_TAXOPE&#34;]%"/>
      <TfrxMemoView Name="QPrincipalMVC_TOTMOV" Align="baLeft" Left="264,5671" Top="0" Width="113,385826771654" Height="18,89765" ShowHint="False" DataField="MVC_TOTMOV" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[QPrincipal.&#34;MVC_TOTMOV&#34;]"/>
      <TfrxMemoView Name="Memo1" Align="baLeft" Left="453,543526771654" Top="0" Width="113,3859" Height="18,89765" ShowHint="False" DataField="TotalLiq" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[QPrincipal.&#34;TotalLiq&#34;]"/>
      <TfrxMemoView Name="Memo13" Left="37,7953" Top="18,89765" Width="94,48825" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Courier New" Font.Style="0" Frame.Typ="8" HAlign="haCenter" ParentFont="False" Text="Nº Parcela"/>
      <TfrxMemoView Name="Memo14" Left="131,5906" Top="18,89765" Width="102,04731" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Courier New" Font.Style="0" Frame.Typ="8" HAlign="haCenter" ParentFont="False" Text="Data Vencimento"/>
      <TfrxMemoView Name="Memo16" Left="336,12616" Top="18,89765" Width="94,48825" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Courier New" Font.Style="0" Frame.Typ="8" HAlign="haRight" ParentFont="False" Text="Valor Parcela"/>
      <TfrxMemoView Name="Memo17" Left="233,9765" Top="18,89765" Width="102,04731" Height="15,11812" ShowHint="False" DataSet="QPrincipal" DataSetName="QPrincipal" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Courier New" Font.Style="0" Frame.Typ="8" HAlign="haCenter" ParentFont="False" Text="Data Entrada"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter1" Height="18,89765" Left="0" Top="236" Width="718,1107">
      <TfrxMemoView Name="Memo15" Left="0,22047" Top="0" Width="264,5671" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo2" Left="264,78757" Top="0" Width="302,3624" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Courier New" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text=""/>
    </TfrxGroupFooter>
  </TfrxReportPage>
</TfrxReport>
