<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.0.7" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="42822.8966773148" ReportOptions.Description.Text="" ReportOptions.LastChange="43631.0753643866" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="Baslik" DataSetName="Başlık"/>
    <item DataSet="Indirim" DataSetName="İndirimler"/>
  </Datasets>
  <Variables>
    <item Name="DEPO" Value="3"/>
    <item Name="KASA" Value="2"/>
    <item Name="PERSONEL" Value="1"/>
    <item Name="BANKA" Value="1"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="Baslik" UserName="Başlık" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Declare @Depo Int, @Personel Int, @Kasa Int, @Banka Int                          &#13;&#10;&#13;&#10;Set @Depo = :DEPO           &#13;&#10;Set @Personel = :PERSONEL                   &#13;&#10;Set @Kasa = :KASA           &#13;&#10;Set @Banka = :Banka                &#13;&#10; &#13;&#10;SELECT &#13;&#10;  D.KOD AS DEPOKOD, D.ACIKLAMA AS DEPOACIKLAMA,&#13;&#10;  B.BANKAKODU, B.BANKAADI,&#13;&#10;  K.KASAADI, K.ACIKLAMA AS KASAACIKLAMA,&#13;&#10;  AD + ' ' + SOYAD AS PERSONEL&#13;&#10;From TBLDEPOLAR D, TBLPERSONEL P, TBLBANKALAR B, TBLKASALAR K&#13;&#10;WHERE D.KARTNO = @Depo AND P.KARTNO = @Personel AND B.KARTNO = @Banka AND K.ID = @Kasa&#13;&#10;  &#13;&#10;    " PropData="05704C6566740398000470546F7002540A506172616D65746572730101063D204E616D653D224445504F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4445504F262336323B2200010645204E616D653D22504552534F4E454C222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B504552534F4E454C262336323B220001063D204E616D653D224B415341222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B415341262336323B220001063F204E616D653D2242616E6B61222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B42414E4B41262336323B220000"/>
    <TfrxFDQuery Name="Indirim" UserName="İndirimler" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Set DateFormat DMY &#13;&#10;Declare @Tarih DateTime, @Depo Int, @Personel Int, @Kasa Int&#13;&#10;&#13;&#10;Set @Depo = :DEPO                                &#13;&#10;Set @Personel = :PERSONEL                                                 &#13;&#10;&#13;&#10;Set @Tarih = GETDATE()&#13;&#10;&#13;&#10;SELECT&#13;&#10;  A.*, CASE WHEN ISNULL(A.INDIRIMYUZDE, 0) = 0 THEN 0 ELSE A.TUTARI * A.INDIRIMYUZDE / 100 END AS INDIRIM&#13;&#10;FROM(&#13;&#10;Select &#13;&#10;  BELGENO,  ISNULL(FIRMAADI, 'PEŞİN') AS FIRMAADI, CINSI, MIKTARI, FIYATI, &#13;&#10;  MIKTARI * (CASE WHEN ISNULL(S.KDVDAHIL, 0) = 1 THEN FIYATI ELSE FIYATI * ((100 + S.KDV) / 100) END) AS TUTARI, &#13;&#10;  ALTISKONTO1Y AS INDIRIMYUZDE&#13;&#10;from TBLSATFATHAREKET H&#13;&#10;LEFT OUTER JOIN TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON C.KARTNO = B.CARIID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID&#13;&#10;WHERE ISNULL(B.DELETED, 0) = 0 AND ROUND(ALTISKONTO1, 2) &#62; 0 AND H.DEPOID = @Depo AND PERSONELID = @Personel AND CONVERT(VARCHAR, TARIH, 104) = CONVERT(VARCHAR, @Tarih, 104) &#13;&#10;UNION ALL&#13;&#10;Select &#13;&#10;  BELGENO,  ISNULL(FIRMAADI, 'PEŞİN') AS FIRMAADI, CINSI, MIKTARI, FIYATI, &#13;&#10;  MIKTARI * (CASE WHEN ISNULL(S.KDVDAHIL, 0) = 1 THEN FIYATI ELSE FIYATI * ((100 + S.KDV) / 100) END) AS TUTARI, &#13;&#10;  ALTISKONTO1Y AS INDIRIMYUZDE&#13;&#10;from TBLSATIRSHAREKET H&#13;&#10;LEFT OUTER JOIN TBLSATIRSBASLIK B WITH(INDEX=TBLSATIRSBASLIK_KARTNO) ON B.KARTNO = H.FATURAID&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON C.KARTNO = B.CARIID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID&#13;&#10;WHERE ISNULL(B.DELETED, 0) = 0 AND ISNULL(B.FATURALASTI, 0) = 0 AND ROUND(ALTISKONTO1, 2) &#62; 0 AND H.DEPOID = @Depo AND PERSONELID = @Personel AND CONVERT(VARCHAR, TARIH, 104) = CONVERT(VARCHAR, @Tarih, 104)&#13;&#10;) AS A&#13;&#10;  " PropData="05704C6566740394000470546F70039C000A506172616D65746572730101063D204E616D653D224445504F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4445504F262336323B2200010645204E616D653D22504552534F4E454C222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B504552534F4E454C262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" HGuides.Text="" VGuides.Text="">
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="68.03154" Left="0" Top="360" Width="718.1107">
      <TfrxLineView Name="Line3" Left="7.55906" Top="11.33859" Width="699.21305" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo10" Left="3.77953" Top="15.11812" Width="498.89796" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Date] Tarihinde PARADOKS (http://www.elibolyazilim.com) ile yazdırılmıştır."/>
      <TfrxMemoView Name="Memo11" Left="536.69326" Top="18.89765" Width="170.07885" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Sayfa : [Page] / [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
    </TfrxPageFooter>
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="139.84261" Left="0" Top="16" Width="718.1107">
      <TfrxMemoView Name="Memo1" Left="15.11812" Top="11.33859" Width="680.3154" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="PARADOKS Satış İndirimleri"/>
      <TfrxMemoView Name="Memo2" Left="521.57514" Top="45.35436" Width="173.85838" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo3" Left="18.89765" Top="71.81107" Width="94.48825" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Personel : "/>
      <TfrxMemoView Name="Memo4" Left="18.89765" Top="95.82684" Width="94.48825" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Depo : "/>
      <TfrxMemoView Name="BalkPERSONEL" Left="117.16543" Top="71.81107" Width="400.63018" Height="18.89765" DataField="PERSONEL" DataSet="Baslik" DataSetName="Başlık" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Başlık.&#34;PERSONEL&#34;]"/>
      <TfrxMemoView Name="BalkDEPOACIKLAMA" Left="117.16543" Top="95.82684" Width="321.26005" Height="18.89765" DataField="DEPOACIKLAMA" DataSet="Baslik" DataSetName="Başlık" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Başlık.&#34;DEPOACIKLAMA&#34;]"/>
    </TfrxReportTitle>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="49.13389" Left="0" Top="176" Width="718.1107">
      <TfrxMemoView Name="Memo5" Left="7.55906" Top="15.11812" Width="83.14966" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Belge No"/>
      <TfrxMemoView Name="Memo6" Left="92.26778" Top="15.11812" Width="147.40167" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Firma"/>
      <TfrxMemoView Name="Memo7" Left="524.11843" Top="15.11812" Width="94.48825" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo8" Left="621.38621" Top="15.11812" Width="94.48825" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="İndirim"/>
      <TfrxLineView Name="Line1" Left="3.77953" Top="37.01577" Width="710.55164" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo14" Left="417.48052" Top="15.11812" Width="52.91342" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Miktarı"/>
      <TfrxMemoView Name="Memo15" Left="470.52783" Top="15.11812" Width="52.91342" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Fiyatı"/>
      <TfrxMemoView Name="Memo16" Left="240.66945" Top="15.11812" Width="177.63791" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Cinsi"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22.6771678" Left="0" Top="244" Width="718.1107" ColumnWidth="0" ColumnGap="0" DataSet="Indirim" DataSetName="İndirimler" RowCount="0">
      <TfrxMemoView Name="ndirimlerBELGENO" Left="7.55906" Top="0" Width="83.14966" Height="18.89765" DataField="BELGENO" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[İndirimler.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="ndirimlerFIRMAADI" Left="92.26778" Top="0" Width="147.40167" Height="18.89765" DataField="FIRMAADI" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="[İndirimler.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="ndirimlerTUTARI" Left="524.11843" Top="0" Width="94.48825" Height="18.89765" DataField="TUTARI" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.ThousandSeparator="." DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İndirimler.&#34;TUTARI&#34;]"/>
      <TfrxMemoView Name="ndirimlerINDIRIM" Left="621.38621" Top="0" Width="94.48825" Height="18.89765" DataField="INDIRIM" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[İndirimler.&#34;INDIRIM&#34;]"/>
      <TfrxMemoView Name="ndirimlerCINSI" IndexTag="1" Left="240.66945" Top="0" Width="177.63791" Height="18.89765" DataField="CINSI" DataSet="Indirim" DataSetName="İndirimler" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="[İndirimler.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="ndirimlerMIKTARI" IndexTag="1" Left="417.48052" Top="0" Width="52.91342" Height="18.89765" DataField="MIKTARI" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.ThousandSeparator="." DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İndirimler.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="ndirimlerFIYATI" IndexTag="1" Left="470.52783" Top="0" Width="52.91342" Height="18.89765" DataField="FIYATI" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.ThousandSeparator="." DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İndirimler.&#34;FIYATI&#34;]"/>
    </TfrxMasterData>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="52.91342" Left="0" Top="288" Width="718.1107">
      <TfrxMemoView Name="Memo9" Left="393.07112" Top="17.45671" Width="94.48825" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Toplamlar"/>
      <TfrxMemoView Name="Memo12" Left="524.11843" Top="17.45671" Width="94.48825" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İndirimler.&#34;TUTARI&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo13" Left="621.38621" Top="17.45671" Width="94.48825" Height="18.89765" DataSet="Indirim" DataSetName="İndirimler" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;İndirimler.&#34;INDIRIM&#34;&#62;,MasterData1)]"/>
      <TfrxLineView Name="Line2" Left="396.85065" Top="9.55906" Width="317.48052" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
