Kaynak: KB-v1
08_SupportPlaybooks/Processes/PROC-132.md←Surecler/*.doc(destek süreç dokümanı; parola/IP/terminal maskelenmiş). Gerçeklik: DOCUMENTED — kodla doğrulanmış değil.
ERP Degistirilmis Islemler Raporu
Kimlik: PROC-132 · Ürün: SQL Server · Kategori: Veritabanı bakımı (SQL) · Katalog: ERP Degistirilmis Islemler Raporu
Kaynak: AifaSoft destek süreç dokümanı (Word). Şifre, kullanıcı adı, terminal no ve IP bilgileri kaynak aşamasında maskelenmiştir; görseller resimli süreç kitabındadır.
ERPGOLDV2 DEĞİŞTİRİLMİŞ
İŞLEMLER RAPORU
USE [ERPALTINKAYNAK]
GO
/****** Object: UserDefinedFunction [Reports].[DuzeltilmisIslemlerRaporu] Script Date: 22.10.2021 17:40:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Function [Reports].[DuzeltilmisIslemlerRaporu](@SubeId int,@StartDate date,@EndDate date)
returns table
as
return
Select
I.Id,
LogType as [Kayıt Tipi],
LogDate as [Kayıt Tarihi],
TransactionId as RefId,
I.Tarih,
H.HesapAdi,
I.FisNo,
Sistem.GetIslemKodu(I.IslemKodu,I.IslemTuru,I.IslemTipi) as Islem,
I.Kodu,
I.Adet,
I.Miktar,
I.AuMilyem as Milyem,
Convert(Decimal(18,2), I.Miktar * I.AuMilyem) as Has,
I.Fiyat,
I.Tutar,
I.Birim,
I.Vade,
Case When I.logType = 'Yeni Kayıt' Then I.Aciklama When I.LogType = 'Düzeltme' Then SA.DeletedDescription End as Aciklama,
S.Kodu as Sube,
K.Kodu as Kasa,
U.UserName as Kullanıcı
From Cari.History I
Left Join Sistem.Users U on U.Id =I.UserId
Left Join Sistem.Kasalar K on K.Id=I.KasaId
Left Join Sistem.Subeler S on S.Id=K.SubeId
Left Join Cari.Hesaplar H on H.Id =I.HesapId
Left Join Sistem.SilAciklama SA on SA.UserId = I.UserId and SA.TransID=I.TransactionId
Left Join (Select * From Cari.Islemler Where LastModify is not null ) B on B.Id = I.TransactionId
Where I.IsDeleted ='False' and (Convert(date,B.LastModify)>=@StartDate and Convert(date,B.LastModify)<=@EndDate) and I.LogType <> 'İptal Edildi'
GO
LAYOUT
INSERT INTO AifaDev.Reports(RefNo,CreatedDate,ReportName,[Description],Developer,[SQL],[Password],[IsGrid],[IsPivot],[IsReport],[GroupId]) Values('D7AFDE48B6B0430BA66CA2F50B5181C3','2021-05-08','Duzeltilmis Islemler Raporu','','','Select * from Reports.DuzeltilmisIslemlerRaporu(@SubeId,@StartDate,@EndDate) Order By RefId','','True','False','False','0')
Declare @ReportId int =(SELECT SCOPE_IDENTITY())
Insert Into AifaDev.ReportsFilter(ReportId,SortIndex,FieldName,Caption,ControlType,SQL,DisplayMember,ValueMember,IsBeetwen) Values(@ReportId,'0','StartDate','BasTarihi','DateEdit','','','','False')
Insert Into AifaDev.ReportsFilter(ReportId,SortIndex,FieldName,Caption,ControlType,SQL,DisplayMember,ValueMember,IsBeetwen) Values(@ReportId,'0','EndDate','SonTarih','DateEdit','','','','False')
Insert Into AifaDev.ReportLayouts(ReportId,LayoutType,LayoutName,Layout) Values(@ReportId,'0','Genel Görünüm','<XtraSerializer version="1.0" application="View">
\<property name="#LayoutVersion" />
\<property name="PreviewLineCount">-1\</property>
\<property name="PreviewIndent">-1\</property>
\<property name="HorzScrollStep">3\</property>
\<property name="FocusRectStyle">CellFocus\</property>
\<property name="ScrollStyle">LiveVertScroll, LiveHorzScroll\</property>
\<property name="LevelIndent">-1\</property>
\<property name="VertScrollTipFieldName" />
\<property name="ChildGridLevelName" />
\<property name="GroupFormat">{1}\</property>
\<property name="NewItemRowText" />
\<property name="GroupPanelText">Gruplandırmak Istediğiniz Sutunu Buraya Taşıyınız....\</property>
\<property name="PreviewFieldName" />
\<property name="SynchronizeClones">true\</property>
\<property name="BorderStyle">Simple\</property>
\<property name="ViewCaption"> \</property>
\<property name="DetailHeight">350\</property>
\<property name="Name">GrdView\</property>
\<property name="DetailTabHeaderLocation">Top\</property>
\<property name="ActiveFilterEnabled">true\</property>
\<property name="Columns" iskey="true" value="21">
\<property name="Item1" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">0\</property>
\<property name="Width">39\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colId\</property>
\<property name="FieldName">Id\</property>
\</property>
\<property name="Item2" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">1\</property>
\<property name="Width">64\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colKayıtTipi\</property>
\<property name="FieldName">Kayıt Tipi\</property>
\</property>
\<property name="Item3" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">2\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colKayıtTarihi\</property>
\<property name="FieldName">Kayıt Tarihi\</property>
\</property>
\<property name="Item4" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">3\</property>
\<property name="Width">54\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colRefId\</property>
\<property name="FieldName">RefId\</property>
\</property>
\<property name="Item5" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">4\</property>
\<property name="Width">71\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colTarih\</property>
\<property name="FieldName">Tarih\</property>
\</property>
\<property name="Item6" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">5\</property>
\<property name="Width">110\</property>
\<property name="Name">colHesapAdi\</property>
\<property name="FieldName">HesapAdi\</property>
\</property>
\<property name="Item7" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">6\</property>
\<property name="Width">43\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colFisNo\</property>
\<property name="FieldName">FisNo\</property>
\</property>
\<property name="Item8" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">7\</property>
\<property name="Width">45\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colIslem\</property>
\<property name="FieldName">Islem\</property>
\</property>
\<property name="Item9" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">8\</property>
\<property name="Width">51\</property>
\<property name="Name">colKodu\</property>
\<property name="FieldName">Kodu\</property>
\</property>
\<property name="Item10" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">9\</property>
\<property name="Width">39\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colAdet\</property>
\<property name="FieldName">Adet\</property>
\</property>
\<property name="Item11" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">10\</property>
\<property name="DisplayFormat" isnull="true" iskey="true">
\<property name="FormatString">n2\</property>
\<property name="FormatType">Numeric\</property>
\</property>
\<property name="Width">57\</property>
\<property name="Name">colMiktar\</property>
\<property name="FieldName">Miktar\</property>
\</property>
\<property name="Item12" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">11\</property>
\<property name="DisplayFormat" isnull="true" iskey="true">
\<property name="FormatString">n4\</property>
\<property name="FormatType">Numeric\</property>
\</property>
\<property name="Width">61\</property>
\<property name="Name">colMilyem\</property>
\<property name="FieldName">Milyem\</property>
\</property>
\<property name="Item13" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">12\</property>
\<property name="DisplayFormat" isnull="true" iskey="true">
\<property name="FormatString">n2\</property>
\<property name="FormatType">Numeric\</property>
\</property>
\<property name="Width">55\</property>
\<property name="Name">colHas\</property>
\<property name="FieldName">Has\</property>
\</property>
\<property name="Item14" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">13\</property>
\<property name="DisplayFormat" isnull="true" iskey="true">
\<property name="FormatString">n4\</property>
\<property name="FormatType">Numeric\</property>
\</property>
\<property name="Width">49\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colFiyat\</property>
\<property name="FieldName">Fiyat\</property>
\</property>
\<property name="Item15" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">14\</property>
\<property name="DisplayFormat" isnull="true" iskey="true">
\<property name="FormatString">n2\</property>
\<property name="FormatType">Numeric\</property>
\</property>
\<property name="Width">61\</property>
\<property name="Name">colTutar\</property>
\<property name="FieldName">Tutar\</property>
\</property>
\<property name="Item16" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">15\</property>
\<property name="Width">49\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colBirim\</property>
\<property name="FieldName">Birim\</property>
\</property>
\<property name="Item17" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">16\</property>
\<property name="Width">65\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colVade\</property>
\<property name="FieldName">Vade\</property>
\</property>
\<property name="Item18" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">17\</property>
\<property name="Width">135\</property>
\<property name="Name">colAciklama\</property>
\<property name="FieldName">Aciklama\</property>
\</property>
\<property name="Item19" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">18\</property>
\<property name="Width">48\</property>
\<property name="AppearanceCell" isnull="true" iskey="true">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="Name">colSube\</property>
\<property name="FieldName">Sube\</property>
\</property>
\<property name="Item20" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">19\</property>
\<property name="Width">55\</property>
\<property name="Name">colKasa\</property>
\<property name="FieldName">Kasa\</property>
\</property>
\<property name="Item21" isnull="true" iskey="true">
\<property name="ColumnEditName" />
\<property name="Visible">true\</property>
\<property name="VisibleIndex">20\</property>
\<property name="Width">66\</property>
\<property name="Name">colKullanıcı\</property>
\<property name="FieldName">Kullanıcı\</property>
\</property>
\</property>
\<property name="ViewCaptionHeight">-1\</property>
\<property name="OptionsPrint" isnull="true" iskey="true">
\<property name="ExpandAllDetails">true\</property>
\</property>
\<property name="OptionsView" isnull="true" iskey="true">
\<property name="ShowGroupPanel">false\</property>
\<property name="ShowIndicator">false\</property>
\<property name="EnableAppearanceEvenRow">true\</property>
\<property name="EnableAppearanceOddRow">true\</property>
\<property name="ColumnAutoWidth">false\</property>
\</property>
\<property name="OptionsSelection" isnull="true" iskey="true">
\<property name="EnableAppearanceFocusedCell">false\</property>
\</property>
\<property name="OptionsBehavior" isnull="true" iskey="true">
\<property name="Editable">false\</property>
\<property name="AllowIncrementalSearch">true\</property>
\</property>
\<property name="FixedLineWidth">2\</property>
\<property name="VertScrollVisibility">Auto\</property>
\<property name="RowSeparatorHeight">0\</property>
\<property name="IndicatorWidth">-1\</property>
\<property name="ColumnPanelRowHeight">-1\</property>
\<property name="HorzScrollVisibility">Auto\</property>
\<property name="FooterPanelHeight">-1\</property>
\<property name="Appearance" isnull="true" iskey="true">
\<property name="ViewCaption" iskey="true" value="ViewCaption">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Near\</property>
\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\<property name="HeaderPanel" iskey="true" value="HeaderPanel">
\<property name="TextOptions" isnull="true" iskey="true">
\<property name="HAlignment">Center\</property>
\</property>
\<property name="FontStyleDelta">Bold\</property>
\<property name="Options" isnull="true" iskey="true">
\<property name="UseFont">true\</property>
\<property name="UseTextOptions">true\</property>
\</property>
\</property>
\</property>
\<property name="RowHeight">-1\</property>
\<property name="GroupRowHeight">-1\</property>
\<property name="GroupSummary" iskey="true" value="0" />
\<property name="FormatConditions" iskey="true" value="0" />
\<property name="ActiveFilterString" />
\<property name="GroupSummarySortInfoState" />
\<property name="FindFilterText" />
\<property name="FindPanelVisible">false\</property>
\</XtraSerializer>')
Kaynaklar
- SRC-PROC-DOC — süreç dokümanı #132