<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.13.1" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41384,9404675926" ReportOptions.Description.Text="" ReportOptions.LastChange="41384,9477940741" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C65667403900103546F700380010844617461736574730101063220446174615365743D226661616C69796574512220446174615365744E616D653D2247756E6C756B204661616C69796574220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TFrxFDQuery Name="faaliyetQ" UserName="Gunluk Faaliyet" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SET DATEFORMAT DMY&#13;&#10;DECLARE @Tarih DATETIME, @Personel Int, @Satis DECIMAL(18, 4), @IAde DECIMAL(18, 4),&#13;&#10;  @Nakit DECIMAL(18, 4), @VISA DECIMAL(18, 4), @AcikHesap DECIMAL(18, 4)&#13;&#10;&#13;&#10;SET @Tarih = :TARIH          &#13;&#10;SET @Personel = :PERSONEL                   &#13;&#10;&#13;&#10;SET @Satis = ISNULL((SELECT SUM(ISNULL(TUTARI, 0)) FROM TBLSATFATBASLIK WITH(INDEX=TBLSATFATBASLIK_PERSONELTARIH)&#13;&#10;    WHERE DELETED = 0 AND PERSONELID = @Personel AND TARIH = @Tarih), 0)&#13;&#10;    &#13;&#10;SET @Iade = ISNULL((SELECT SUM(ISNULL(TUTARI, 0)) FROM TBLSATFATIADEBASLIK WITH(INDEX=TBLSATFATIADEBASLIK_PERSONELTARIH)&#13;&#10;    WHERE DELETED = 0 AND PERSONELID = @Personel AND TARIH = @Tarih), 0)&#13;&#10;&#13;&#10;SET @Nakit = ISNULL((SELECT SUM(ISNULL(TUTAR, 0))  FROM TBLCARIGIRISDETAY D WITH(INDEX=TBLCARIGIRISDETAY_BASLIK)&#13;&#10;LEFT OUTER JOIN TBLCARIGIRIS B WITH(INDEX=TBLCARIGIRIS_PERSONELTARIH) ON D.BASLIKID = B.KARTNO&#13;&#10;WHERE DELETED = 0 AND B.TARIH = @Tarih AND B.PERSONELID = @Personel AND ISLEM = 0), 0)&#13;&#10;&#13;&#10;SET @VISA = ISNULL((SELECT SUM(ISNULL(TUTAR, 0))  FROM TBLCARIGIRISDETAY D WITH(INDEX=TBLCARIGIRISDETAY_BASLIK)&#13;&#10;LEFT OUTER JOIN TBLCARIGIRIS B WITH(INDEX=TBLCARIGIRIS_PERSONELTARIH) ON D.BASLIKID = B.KARTNO&#13;&#10;WHERE DELETED = 0 AND B.TARIH = @Tarih AND B.PERSONELID = @Personel AND ISLEM = 3), 0)&#13;&#10;&#13;&#10;SET @AcikHesap = @Satis - @Nakit - @VISA&#13;&#10;&#13;&#10;SELECT &#13;&#10;  AD + ' ' + SOYAD AS PERSONEL,  @Tarih AS TARIH, @Satis AS SATIS, @Iade AS IADE, &#13;&#10;  @Nakit AS NAKIT, @VISA AS VISA, @AcikHesap AS ACIKHESAP&#13;&#10;FROM TBLPERSONEL WITH(INDEX=TBLPERSONEL_KARTNO)&#13;&#10;WHERE KARTNO = @Personel&#13;&#10;  " PropData="05704C656674023C0470546F7002200A506172616D657465727301010621204E616D653D225441524948222044617461547970653D226674537472696E672200010625204E616D653D22504552534F4E454C222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" Height="268,34663" Left="0" Top="16" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" RowCount="0">
      <TfrxMemoView Name="Memo1" Left="26,45671" Top="30,23624" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Personel"/>
      <TfrxMemoView Name="Memo2" Left="26,45671" Top="60,47248" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="Memo3" Left="26,45671" Top="90,70872" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Satış Toplamı"/>
      <TfrxMemoView Name="Memo4" Left="26,45671" Top="120,94496" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Nakit"/>
      <TfrxMemoView Name="Memo5" Left="26,45671" Top="151,1812" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="VİSA"/>
      <TfrxMemoView Name="Memo6" Left="26,45671" Top="181,41744" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Açık Hesap"/>
      <TfrxMemoView Name="Memo7" Left="26,45671" Top="211,653543307087" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="İade Alınan"/>
      <TfrxMemoView Name="Memo8" Left="26,45671" Top="241,889763779528" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Net Ciro"/>
      <TfrxMemoView Name="GunlukFaaliyetPERSONEL" Left="132,28355" Top="30,23624" Width="400,63018" Height="18,89765" ShowHint="False" DataField="PERSONEL" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Gunluk Faaliyet.&#34;PERSONEL&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetTARIH" Left="132,28355" Top="60,47248" Width="79,37013" Height="18,89765" ShowHint="False" DataField="TARIH" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Gunluk Faaliyet.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetSATIS" Left="132,28355" Top="90,70872" Width="94,48825" Height="18,89765" ShowHint="False" DataField="SATIS" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gunluk Faaliyet.&#34;SATIS&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetNAKIT" Left="132,28355" Top="120,94496" Width="94,48825" Height="18,89765" ShowHint="False" DataField="NAKIT" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gunluk Faaliyet.&#34;NAKIT&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetVISA" Left="132,28355" Top="151,1812" Width="94,48825" Height="18,89765" ShowHint="False" DataField="VISA" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gunluk Faaliyet.&#34;VISA&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetACIKHESAP" Left="132,28355" Top="181,41744" Width="94,48825" Height="18,89765" ShowHint="False" DataField="ACIKHESAP" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gunluk Faaliyet.&#34;ACIKHESAP&#34;]"/>
      <TfrxMemoView Name="GunlukFaaliyetIADE" Left="132,28355" Top="211,65354331" Width="94,48825" Height="18,89765" ShowHint="False" DataField="IADE" DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gunluk Faaliyet.&#34;IADE&#34;]"/>
      <TfrxMemoView Name="Memo9" Left="132,28355" Top="241,88976378" Width="94,48825" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;Gunluk Faaliyet.&#34;NAKIT&#34;&#62; + &#60;Gunluk Faaliyet.&#34;VISA&#34;&#62; + &#60;Gunluk Faaliyet.&#34;ACIKHESAP&#34;&#62; - &#60;Gunluk Faaliyet.&#34;IADE&#34;&#62;]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
