<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.9.3" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="167935" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="44016,9006701273" ReportOptions.Description.Text="" ReportOptions.LastChange="44264,4819427546" ScriptLanguage="PascalScript" ScriptText.Text="var&#13;&#10;BAKIYE:double;&#13;&#10;ESKIBAKIYE:double;&#13;&#10;SIPARISADRESI:String;&#13;&#10;ADRESILILCE:String;&#13;&#10;ARAYANTELEFON:String;&#13;&#10;procedure ReportSummary1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;&#13;&#10;BAKIYE:=0;&#13;&#10;   ADOQuery1.close;&#13;&#10;  ADOQuery1.sql.Clear;&#13;&#10;  ADOQuery1.SQL.Add('select * from KullaniciAyarlari where Ayar=''PesinCariNo'' '+&#13;&#10;  ' and Deger='''+IntToStr(&#60;DSAMUSTERI.&#34;MUSNO&#34;&#62;) +''' and KullaniciNo='''+IntToStr(&#60;DSParametreler.&#34;KullaniciNo&#34;&#62;)+''' ');&#13;&#10;  ADOQuery1.Open;&#13;&#10;&#13;&#10;  if  ADOQuery1.recordcount=0 then&#13;&#10;  begin&#13;&#10;      MemoMusteriBakiyeBaslik.visible:=True;&#13;&#10;     MemoAyrac1.visible:=True;&#13;&#10;      MemoBakiye.visible:=true;&#13;&#10;  ADOQuery1.close;&#13;&#10;  ADOQuery1.sql.Clear;&#13;&#10;  ADOQuery1.SQL.Add('select sum(BORC-ALACAK) as BAKIYE from ACARI where  MUSNO='''+IntToStr(&#60;DSAMUSTERI.&#34;MUSNO&#34;&#62;)+''' ');&#13;&#10;  ADOQuery1.open;&#13;&#10;&#13;&#10;  if  ADOQuery1.recordcount&#62;0 then&#13;&#10;  BAKIYE:=ADOQuery1.FieldByName('BAKIYE').asfloat;&#13;&#10;&#13;&#10;  ADOQuery1.close;&#13;&#10;  ADOQuery1.sql.Clear;&#13;&#10;  ADOQuery1.SQL.Add('select sum(BORC-ALACAK) as BAKIYE from ACARI where ISLEMNO&#60;(Select top 1 IslemNo from STOKHAR where  CariNo='''+IntToStr(&#60;DSAMUSTERI.&#34;MUSNO&#34;&#62;)+''' order by ISLEMNO DESC) '+&#13;&#10;  'and  MUSNO='''+IntToStr(&#60;DSAMUSTERI.&#34;MUSNO&#34;&#62;)+''' ');&#13;&#10;  ADOQuery1.open;&#13;&#10;&#13;&#10;  if  ADOQuery1.recordcount&#62;0 then&#13;&#10;  ESKIBAKIYE:=ADOQuery1.FieldByName('BAKIYE').asfloat;&#13;&#10;&#13;&#10;&#13;&#10;  end else&#13;&#10;  begin&#13;&#10;          MemoMusteriBakiyeBaslik.visible:=False;&#13;&#10;          MemoAyrac1.visible:=false;&#13;&#10;          MemoBakiye.visible:=false;&#13;&#10;          BAKIYE:=0;&#13;&#10;  end;&#13;&#10;&#13;&#10;&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure PageHeader1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  //SIPARISADRESI:='';&#13;&#10;&#13;&#10; ADOQuery1.close;&#13;&#10;  ADOQuery1.sql.Clear;&#13;&#10;  ADOQuery1.SQL.Add('SELECT (ISNULL(A1.Adres1,'''')+SPACE(1)+ISNULL(A1.Adres2,'''')) AS SiparisAdresi,(A1.Il+''/''+A1.Ilce) as AdresIlIlce, '+&#13;&#10;  '(select top 1 T.Telefon from TelAramaLog as T where  T.IslemNo=STB.IslemNo and convert(varchar(10),T.Tarih,121)=convert(varchar(10),STB.SiparisTarihi,121)) as Telefon '+&#13;&#10;  ' FROM Adres as A1 ');&#13;&#10;  ADOQuery1.SQL.Add('inner join STOKHARDETBAG AS STB ON STB.FaturaAdresNo=A1.AdresNo and A1.CariKodu=STB.CariKodu ');&#13;&#10;  ADOQuery1.SQL.Add('WHERE STB.CariKodu='''+&#60;DSMasterQuery_.&#34;CariKodu&#34;&#62;+''' and STB.IslemNo='''+inttostr(&#60;DSMasterQuery_.&#34;IslemNo&#34;&#62;)+'''  ');&#13;&#10;  ADOQuery1.open;&#13;&#10;  if ADOQuery1.recordcount&#62;0 then&#13;&#10; begin&#13;&#10;  SIPARISADRESI:=ADOQuery1.fieldByName('SiparisAdresi').asstring;&#13;&#10;  ADRESILILCE:=ADOQuery1.fieldByName('AdresIlIlce').asstring;&#13;&#10;  ARAYANTELEFON:=ADOQuery1.fieldByName('Telefon').asstring;&#13;&#10; end;&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end." StoreInDFM="False">
  <Datasets>
    <item DataSet="ADOQuery1" DataSetName="ADOQuery1"/>
    <item DataSet="DSAdres" DataSetName="DSAdres"/>
    <item DataSet="DSAMUSTERI" DataSetName="DSAMUSTERI"/>
    <item DataSet="frmRaporSecim_1.DSMasterQuery_" DataSetName="DSMasterQuery_"/>
    <item DataSet="DSParametreler" DataSetName="DSParametreler"/>
    <item DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR"/>
    <item DataSet="DStoplamTutarYaziIle" DataSetName="DStoplamTutarYaziIle"/>
  </Datasets>
  <TfrxDataPage Name="Data" HGuides.Text="" VGuides.Text="" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADOQuery Name="ADOQuery1" UserName="ADOQuery1" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="" CommandTimeout="30" LockType="ltReadOnly" PropData="05704C6566740380000470546F7002500A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" HGuides.Text="" VGuides.Text="" PaperWidth="80" PaperHeight="210" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" Color="16777215" Frame.Typ="0" MirrorMode="0">
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="66,70872" Left="0" Top="18,89765" Width="302,3624" OnBeforePrint="PageHeader1OnBeforePrint">
      <TfrxMemoView Name="Memo41" AllowVectorExport="True" Left="2,69295" Top="3,77953" Width="178,72449" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[DSAMUSTERI.&#34;MUSADI&#34;]"/>
      <TfrxMemoView Name="Memo42" AllowVectorExport="True" Left="56,69295" Top="18,89765" Width="124,72449" Height="26,45671" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo43" AllowVectorExport="True" Left="186,30983333" Top="3,56431667" Width="109,60637" Height="15,11812" DisplayFormat.FormatStr="dd.MM.yyyy hh:mm:ss" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[DSSTOKHAR.&#34;FaturaTarihi&#34;]"/>
      <TfrxMemoView Name="Memo51" AllowVectorExport="True" Left="2,02628333" Top="18,23098333" Width="282,72449" Height="25,79004333" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[SIPARISADRESI]"/>
      <TfrxMemoView Name="Memo52" AllowVectorExport="True" Left="1,35961667" Top="44,46722332" Width="166,72449" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[ADRESILILCE]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo58" AllowVectorExport="True" Left="181,64316667" Top="46,46722333" Width="109,60637" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[ARAYANTELEFON]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="185,19697" Width="302,3624" AllowSplit="True" ColumnWidth="0" ColumnGap="0" DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo36" AllowVectorExport="True" Left="3,77953" Top="0" Width="184,24026" Height="11,33858268" StretchMode="smMaxHeight" DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text=" [DSSTOKHAR.&#34;StokAdi&#34;] ">
        <Formats>
          <item/>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo38" AllowVectorExport="True" Left="188,07885" Top="0" Width="26,45671" Height="11,33858268" StretchMode="smMaxHeight" DataField="Miktar" DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[DSSTOKHAR.&#34;Miktar&#34;]"/>
      <TfrxMemoView Name="Memo39" AllowVectorExport="True" Left="221,09462" Top="0" Width="34,23624" Height="11,33858268" StretchMode="smMaxHeight" DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[&#60;DSSTOKHAR.&#34;TopTutar&#34;&#62;/&#60;DSSTOKHAR.&#34;Miktar&#34;&#62;]"/>
      <TfrxMemoView Name="Memo40" AllowVectorExport="True" Left="255,22851" Top="0" Width="43,35436" Height="11,33858268" StretchMode="smMaxHeight" DataSet="DSSTOKHAR" DataSetName="DSSTOKHAR" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[DSSTOKHAR.&#34;TopTutar&#34;]"/>
    </TfrxMasterData>
    <TfrxHeader Name="Header1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="147,40167" Width="302,3624">
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="3,77953" Top="-2" Width="156,84261" Height="11,33858268" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Stok Adı"/>
      <TfrxMemoView Name="Memo8" AllowVectorExport="True" Left="188,07885" Top="-2" Width="26,45671" Height="11,33858268" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Miktar"/>
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="204,09462" Top="-2" Width="49,13389" Height="11,33858268" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Br.Fy"/>
      <TfrxMemoView Name="Memo10" AllowVectorExport="True" Left="253,22851" Top="-2" Width="45,35436" Height="11,33858268" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Topam"/>
    </TfrxHeader>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="91,42919" Left="0" Top="260,78757" Width="302,3624" OnBeforePrint="ReportSummary1OnBeforePrint">
      <TfrxMemoView Name="MemoMusteriBakiyeBaslik" AllowVectorExport="True" Left="3,77953" Top="13,23624" Width="64,25201" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="16777215" Frame.Typ="0" ParentFont="False" Text="Son Bakiyeniz"/>
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="158,74026" Top="14,55906" Width="71,81107" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Tutar"/>
      <TfrxMemoView Name="Memo14" AllowVectorExport="True" Left="158,74026" Top="28,89765" Width="71,81107" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="K.D.V Toplamı"/>
      <TfrxMemoView Name="Memo15" AllowVectorExport="True" Left="158,74026" Top="43,23624" Width="71,81107" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="16777215" ParentFont="False" Text="Toplam Tutar"/>
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="3,77953" Top="30,35436" Width="139,84261" Height="33,57483" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="16777215" ParentFont="False" Text="[DStoplamTutarYaziIle.&#34;yaziile&#34;]"/>
      <TfrxMemoView Name="Memo24" AllowVectorExport="True" Left="230,55133" Top="14,55906" Width="3,77952268" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=":"/>
      <TfrxMemoView Name="Memo25" AllowVectorExport="True" Left="230,55133" Top="28,89765" Width="3,77952268" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=":"/>
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="230,55133" Top="43,23624" Width="3,77952268" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=":"/>
      <TfrxMemoView Name="MemoAyrac1" AllowVectorExport="True" Left="68,03154" Top="13,23624" Width="3,77952268" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=":"/>
      <TfrxMemoView Name="Memo44" AllowVectorExport="True" Left="235,11039" Top="14,55906" Width="56,69295" Height="11,33858268" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;DSSTOKHAR.&#34;Tutar&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo45" AllowVectorExport="True" Left="235,11039" Top="28,89765" Width="56,69295" Height="11,33858268" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;DSSTOKHAR.&#34;KdvTutari&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo46" AllowVectorExport="True" Left="235,11039" Top="43,01577" Width="56,69295" Height="11,33858268" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;DSSTOKHAR.&#34;TopTutar&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="MemoBakiye" AllowVectorExport="True" Left="71,81107" Top="13,23624" Width="83,14966" Height="11,33859" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[BAKIYE]"/>
      <TfrxLineView Name="Line1" AllowVectorExport="True" Left="4" Top="3,03525" Width="291,5" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
