<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.3.16" 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="42453,7006201389" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="faaliyetQ" DataSetName="Gunluk Faaliyet"/>
    <item DataSet="detayQ" DataSetName="Faaliyet Detayları"/>
  </Datasets>
  <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 @Tarih1 DATETIME, @Tarih2 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 @Tarih1 = :TARIH1&#13;&#10;SET @Tarih2 = :TARIH2&#13;&#10;  &#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 &#62;= @Tarih1 AND TARIH &#60;= @Tarih2), 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 &#62;= @Tarih1 AND TARIH &#60;= @Tarih2), 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_TARIH) ON D.BASLIKID = B.KARTNO&#13;&#10;WHERE DELETED = 0 AND B.TARIH &#62;= @Tarih1 AND B.TARIH &#60;= @Tarih2 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_TARIH) ON D.BASLIKID = B.KARTNO&#13;&#10;WHERE DELETED = 0 AND B.TARIH &#62;= @Tarih1 AND TARIH &#60;= @Tarih2 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,  @Tarih1 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="05704C656674023C0470546F7002200A506172616D657465727301010622204E616D653D22544152494831222044617461547970653D226674537472696E672200010622204E616D653D22544152494832222044617461547970653D226674537472696E672200010625204E616D653D22504552534F4E454C222044617461547970653D226674496E7465676572220000"/>
    <TfrxFDQuery Name="detayQ" UserName="Faaliyet Detayları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SET DATEFORMAT DMY&#13;&#10;DECLARE @Tarih1 DATETIME, @Tarih2 DATETIME, @Personel Int&#13;&#10;&#13;&#10;SET @Tarih1 = :TARIH1            &#13;&#10;SET @Tarih2 = :TARIH2  &#13;&#10;&#13;&#10;SET @Personel = :PERSONEL                   &#13;&#10;  &#13;&#10;Select &#13;&#10; FIRMAADI, FIRMAKODU, FIRMAUNVANI, &#13;&#10; SUM(SATIS) AS SATIS, SUM(IADE) AS IADE, SUM(TAHSILAT) AS TAHSILAT&#13;&#10;from (&#13;&#10;Select&#13;&#10;  C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI, SUM(B.TUTARI) AS SATIS, &#13;&#10;  CAST(0.00 AS DECIMAL) AS IADE, CAST(0.00 AS DECIMAL) AS TAHSILAT&#13;&#10;FROM TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_PERSONELTARIH)&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON B.CARIID = C.KARTNO&#13;&#10;WHERE B.DELETED = 0 AND PERSONELID = @Personel AND TARIH &#62;= @Tarih1 AND TARIH &#60;= @Tarih2 AND CARIID &#62; 0&#13;&#10;GROUP BY C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI&#13;&#10;UNION ALL&#13;&#10;Select&#13;&#10;  C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI, CAST(0.00 AS DECIMAL) AS SATIS, &#13;&#10;  SUM(B.TUTARI) AS IADE, CAST(0.00 AS DECIMAL) AS TAHSILAT&#13;&#10;FROM TBLSATFATIADEBASLIK B WITH(INDEX=TBLSATFATIADEBASLIK_PERSONELTARIH)&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON B.CARIID = C.KARTNO&#13;&#10;WHERE B.DELETED = 0 AND PERSONELID = @Personel AND TARIH &#62;= @Tarih1 AND TARIH &#60;= @Tarih2 AND CARIID &#62; 0&#13;&#10;GROUP BY C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI&#13;&#10;UNION ALL&#13;&#10;Select&#13;&#10;  C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI, CAST(0.00 AS DECIMAL) AS SATIS, &#13;&#10;  CAST(0.00 AS DECIMAL) AS IADE, SUM(B.TUTARI) AS TAHSILAT&#13;&#10;FROM TBLCARIGIRIS B WITH(INDEX=TBLCARIGIRIS_PERSONEL)&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON B.CARIID = C.KARTNO&#13;&#10;WHERE B.DELETED = 0 AND PERSONELID = @Personel AND TARIH &#62;= @Tarih1 AND TARIH &#60;= @Tarih2 AND CARIID &#62; 0&#13;&#10;GROUP BY C.FIRMAADI, C.FIRMAKODU, C.FIRMAUNVANI&#13;&#10;) AS Z&#13;&#10;GROUP BY FIRMAADI, FIRMAKODU, FIRMAUNVANI&#13;&#10;ORDER BY FIRMAKODU    " PropData="05704C656674023C0470546F7002640A506172616D657465727301010622204E616D653D22544152494831222044617461547970653D226674537472696E672200010622204E616D653D22544152494832222044617461547970653D226674537472696E672200010625204E616D653D22504552534F4E454C222044617461547970653D226674496E7465676572220000"/>
  </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" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="313,70099" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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" 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;]"/>
      <TfrxMemoView Name="Memo10" Left="11,33859" Top="287,24428" Width="117,16543" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Firma Kodu"/>
      <TfrxMemoView Name="Memo11" Left="132,28355" Top="287,24428" Width="120,94496" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Firma Adı"/>
      <TfrxMemoView Name="Memo12" Left="258,34663" Top="287,24428" Width="181,41744" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Ünvanı"/>
      <TfrxMemoView Name="Memo13" Left="445,98454" Top="287,24428" Width="79,37007874" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Satış"/>
      <TfrxMemoView Name="Memo14" Left="537,03185" Top="287,24428" Width="79,37007874" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="İade"/>
      <TfrxMemoView Name="Memo15" Left="627,18151" Top="287,24428" Width="79,37007874" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tahsilat"/>
      <TfrxLineView Name="Line1" Left="11,33859" Top="306,70099" Width="699,21305" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxMasterData>
    <TfrxMasterData Name="MasterData2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="348" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="Faaliyet Detayları" RowCount="0">
      <TfrxMemoView Name="FaaliyetDetaylarFIRMAADI" Left="128,50402" Top="0" Width="120,94496" Height="18,89765" DataField="FIRMAADI" DataSet="detayQ" DataSetName="Faaliyet Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Faaliyet Detayları.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="FaaliyetDetaylarFIRMAKODU" Left="7,55906" Top="0" Width="117,16543" Height="18,89765" DataField="FIRMAKODU" DataSet="detayQ" DataSetName="Faaliyet Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Faaliyet Detayları.&#34;FIRMAKODU&#34;]"/>
      <TfrxMemoView Name="FaaliyetDetaylarFIRMAUNVANI" Left="254,5671" Top="0" Width="181,41744" Height="18,89765" DataField="FIRMAUNVANI" DataSet="detayQ" DataSetName="Faaliyet Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Faaliyet Detayları.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="FaaliyetDetaylarSATIS" Left="442,20501" Top="0" Width="79,37007874" Height="18,89765" DataField="SATIS" DataSet="detayQ" DataSetName="Faaliyet Detayları" 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="[Faaliyet Detayları.&#34;SATIS&#34;]"/>
      <TfrxMemoView Name="FaaliyetDetaylarIADE" Left="533,25232" Top="0" Width="79,37007874" Height="18,89765" DataField="IADE" DataSet="detayQ" DataSetName="Faaliyet Detayları" 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="[Faaliyet Detayları.&#34;IADE&#34;]"/>
      <TfrxMemoView Name="FaaliyetDetaylarTAHSILAT" Left="623,40198" Top="0" Width="79,37007874" Height="18,89765" DataField="TAHSILAT" DataSet="detayQ" DataSetName="Faaliyet Detayları" 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="[Faaliyet Detayları.&#34;TAHSILAT&#34;]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
