<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.4.6" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="43106" ReportOptions.Description.Text="" ReportOptions.LastChange="43118,0080872222" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="KullaniciQ" DataSetName="Alanlar"/>
  </Datasets>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="KullaniciQ" UserName="Alanlar" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Declare @HALIDEPO Table(&#13;&#10;  STOKID INT,&#13;&#10;  RENKID INT,&#13;&#10;  DESENID INT,&#13;&#10;  DEPO DECIMAL(18, 4),&#13;&#10;  BIRIMCARPAN DECIMAL(18, 4),&#13;&#10;  ADET DECIMAL(18, 4)&#13;&#10;)&#13;&#10;&#13;&#10;INSERT INTO @HALIDEPO(STOKID, DEPO, RENKID, DESENID)  &#13;&#10;Select STOKID, SUM(DEPO), RENKID, DESENID&#13;&#10;FROM(&#13;&#10;Select&#13;&#10;  D.STOKID, &#13;&#10;  CASE WHEN ISLEMTIPI IN(2, 5, 53, 55, 10, 145, 157, 172, 174, 237, 238, 239, 240) THEN CIKISDEPO ELSE GIRISDEPO END AS DEPOID,&#13;&#10;  SUM(D.GIREN - D.CIKAN) / B.CARPAN AS DEPO, RENKID, DESENID&#13;&#10;FROM STOKHAREKET D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = D.STOKID&#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON S.ANABIRIM = B.KARTNO&#13;&#10;WHERE ISNULL(S.DELETED, 0) = 0&#13;&#10;GROUP BY D.STOKID, ISLEMTIPI, GIRISDEPO, CIKISDEPO, CARPAN, RENKID, DESENID&#13;&#10;) AS A&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = A.STOKID&#13;&#10;LEFT OUTER JOIN TBLRENKLER R ON R.ID = A.RENKID&#13;&#10;LEFT OUTER JOIN TBLHALIDESENLER D ON D.ID = A.DESENID&#13;&#10;GROUP BY STOKID, RENKID, DESENID&#13;&#10;&#13;&#10;UPDATE @HALIDEPO SET BIRIMCARPAN = ISNULL((SELECT TOP 1 EN * BOY / 10000.000 FROM TBLBIRIMLEREX WHERE STOKID = [@HALIDEPO].STOKID AND BIRIMADI = 'ADET'), 1)&#13;&#10;UPDATE @HALIDEPO SET ADET = DEPO / BIRIMCARPAN&#13;&#10;&#13;&#10;Select &#13;&#10;  STOKKODU, CINSI, R.KOD AS RENK, DS.KOD AS DESEN, BIRIMCARPAN AS HALIM2, DEPO AS M2, ADET&#13;&#10;from @HALIDEPO D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = D.STOKID&#13;&#10;LEFT OUTER JOIN TBLRENKLER R ON R.ID = D.RENKID&#13;&#10;LEFT OUTER JOIN TBLHALIDESENLER DS ON DS.ID = D.DESENID&#13;&#10;   " PropData="05704C65667402640470546F7002640A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="100" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="5" Top="10" Width="708,42517" Height="17,44094" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Halı Depo Durumu"/>
      <TfrxMemoView Name="TARIH" Left="588" Top="25" Width="125" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="98" Width="713,07081" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="0" Top="75" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Stok Kodu"/>
      <TfrxMemoView Name="CINSIBASLIK" Left="113,22047" Top="75" Width="251,1812" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="RENKBASLIK" Left="368,74026" Top="75" Width="109,60633339" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Renk"/>
      <TfrxMemoView Name="DESENBASLIK" Left="481,29932" Top="75" Width="94,48821339" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Desen"/>
      <TfrxMemoView Name="M2BASLIK" Left="635,48825" Top="75" Width="79,37009339" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="M2"/>
      <TfrxMemoView Name="ADETBASLIK" Left="579,07081" Top="75" Width="52,91338339" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Adet"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="21" Left="0" Top="136" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="STOKKODUVIEW" Left="0" Top="0" Width="100" Height="20" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="113,22047" Top="0" Width="251,1812" Height="20" Text="[Alanlar.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="RENKVIEW" Left="368,74026" Top="0" Width="109,60633339" Height="20" Text="[Alanlar.&#34;RENK&#34;]"/>
      <TfrxMemoView Name="DESENVIEW" Left="481,29932" Top="0" Width="94,48821339" Height="20" Text="[Alanlar.&#34;DESEN&#34;]"/>
      <TfrxMemoView Name="M2VIEW" Left="635,48825" Top="0" Width="79,37009339" Height="20" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;M2&#34;]"/>
      <TfrxMemoView Name="ADETVIEW" Left="579,07081" Top="0" Width="52,91338339" Height="20" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;ADET&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="256" Width="718,1107">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="713,07081" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="4" Top="10" Width="612,2047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX ile (http://www.elibolyazilim.com) [date] Tarihinde Yazdırılmıştır"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="619" Top="10,2047" Width="93,54329" Height="17,44094" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="60,47248" Left="0" Top="176" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="453,5436" Top="16,45671" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Toplamlar : "/>
      <TfrxMemoView Name="Memo2" Left="579,07081" Top="16,45671" Width="52,91338339" Height="18,89765" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;ADET&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo3" Left="635,48825" Top="16,45671" Width="79,37009339" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;M2&#34;&#62;,MASTERDATA)]"/>
      <TfrxLineView Name="Line1" Left="453,5436" Top="7,55906" Width="260,78757" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
