SELECT TTT.CODE,CONVERT(DECIMAL(38,2),SUM(TTT.BORC)) BORC,CONVERT(DECIMAL(38,2),SUM(TTT.ALACAK)) ALACAK,CONVERT(DECIMAL(38,2),SUM(TTT.BAKIYEBORC)) BAKIYEBORC,
CONVERT(DECIMAL(38,2),SUM(TTT.BAKIYEALACAK)) BAKIYEALACAK,CONVERT(DECIMAL(38,2),SUM(TTT.BAKIYE)) BAKIYE,CONVERT(DECIMAL(38,2),SUM(TTT.DOVIZBORC)) DOVIZBORC,CONVERT(DECIMAL(38,2),SUM(TTT.DOVIZALACAK)) DOVIZALACAK,
CONVERT(DECIMAL(38,2),SUM(TTT.DOVIZBAKIYE)) DOVIZBAKIYE,CONVERT(DECIMAL(38,2),SUM(TTT.GIREN)) GIREN,CONVERT(DECIMAL(38,2),SUM(TTT.CIKAN)) CIKAN
FROM (
SELECT --GLACC.CODE ,
LEFT(GLACC.CODE,3) CODE,
SUM(GLTRN.DEBIT) BORC,
SUM(GLTRN.CREDIT) ALACAK,
CASE WHEN (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT))<0 THEN 0 ELSE (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT)) END BAKIYEBORC,
ABS(CASE WHEN (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT))>0 THEN 0 ELSE (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT)) END) BAKIYEALACAK,
(CASE WHEN (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT))<0 THEN 0 ELSE (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT)) END)-( ABS(CASE WHEN (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT))>0 THEN 0 ELSE (SUM(GLTRN.DEBIT) - SUM(GLTRN.CREDIT)) END) ) BAKIYE,
SUM((1 - GLTRN.SIGN) * GLTRN.REPORTNET) DOVIZBORC,
SUM(GLTRN.SIGN * GLTRN.REPORTNET) DOVIZALACAK,
( SUM((1 - GLTRN.SIGN) * GLTRN.REPORTNET))- (SUM(GLTRN.SIGN * GLTRN.REPORTNET)) DOVIZBAKIYE,
SUM((1 - GLTRN.SIGN) * GLTRN.AMNT) GIREN,
SUM(GLTRN.SIGN * GLTRN.AMNT) CIKAN
/*,SUM(GLTRN.EMUDEBIT) EMUDEBIT,
SUM(GLTRN.EMUCREDIT) EMUCREDIT*/
FROM LG_211_EMUHACC GLACC WITH (NOLOCK)
LEFT OUTER JOIN LG_211_01_EMFLINE GLTRN WITH (NOLOCK)
ON (GLACC.LOGICALREF = GLTRN.ACCOUNTREF)
WHERE
(
(GLTRN.DATE_ >= CONVERT(DATETIME, '1-1-2018', 101))
AND (GLTRN.DATE_ <= CONVERT(DATETIME, '12-31-2018', 101))
)
AND (GLTRN.TRCODE IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ))
AND (GLTRN.BRANCH IN ( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18 ))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.STATUS = 0)
AND (GLTRN.DEPARTMENT IN ( 0 ))
GROUP BY GLACC.CODE
) AS TTT
GROUP BY CODE
ORDER BY CODE
LOGO BORÇ TAKİP KAPANMAMIŞ HAREKETLER SQL SORGUSU
SELECT
(
SELECT CL.CODE
FROM dbo.LG_133_CLCARD CL
WHERE CL.LOGICALREF = LGMAIN.CARDREF
) LNGMUSTERIKOD,
LGMAIN.PROCDATE TRHTARIH,
CASE LGMAIN.MODULENR
WHEN 7 THEN
CASE LGMAIN.TRCODE
WHEN 3 THEN
'Gelen Havale'
WHEN 4 THEN
'Gönderilen Havale'
WHEN 16 THEN
'Banka - Alınan Hizmet Faturası'
WHEN 17 THEN
'Banka - Verilen Hizmet Faturası'
END
WHEN 4 THEN
CASE LGMAIN.TRCODE
WHEN 1 THEN
'Satınalama Faturası'
WHEN 4 THEN
'Alınan Hizmet Faturası'
WHEN 6 THEN
'Satınalma İade Faturası'
WHEN 13 THEN
'Satınalma Fiyat Farkı Faturası'
WHEN 2 THEN
'Perakende Satış İade Faturası'
WHEN 3 THEN
'Toptan Satış İade Faturası'
WHEN 7 THEN
'Perkande Satış Faturası'
WHEN 8 THEN
'Toptan Satış Faturası'
WHEN 9 THEN
'Verilen Hizmet Faturası'
WHEN 14 THEN
'Satış Fiyat Farkı Faturası'
END
WHEN 5 THEN
CASE LGMAIN.TRCODE
WHEN 70 THEN
'Kredi Kartı Fişi'
WHEN 2 THEN
'Nakit Ödeme'
WHEN 1 THEN
'Nakit Tahsilat'
WHEN 3 THEN
'Borç Dekontu'
WHEN 4 THEN
'Alacak Dekontu'
WHEN 5 THEN
'Virman Fişi'
WHEN 6 THEN
'Kurfarkı Fişi'
WHEN 14 THEN
'Açılış Fişi'
WHEN 41 THEN
'Verilen Vade Farkı Faturası'
WHEN 42 THEN
'Alınan Vade Farkı Faturası'
WHEN 71 THEN
'Kredi Kartı İade Fişi'
WHEN 72 THEN
'Firma Kredi Kartı Fişi'
WHEN 73 THEN
'Firma Kredi Kartı İade Fişi'
END
WHEN 6 THEN
CASE LGMAIN.TRCODE
WHEN 1 THEN
'Müşteri Çeki'
WHEN 3 THEN
'Kendi Çekimiz'
END
WHEN 3 THEN
CASE LGMAIN.TRCODE
WHEN 2 THEN
'Satınalama Siparişi'
WHEN 1 THEN
'Satış Siparişi'
END
WHEN 10 THEN
CASE LGMAIN.TRCODE
WHEN 1 THEN
'Nakit Tahsilat'
WHEN 2 THEN
'Nakit Ödeme'
END
WHEN 61 THEN
CASE LGMAIN.TRCODE
WHEN 3 THEN
'Borç Dekontu'
WHEN 4 THEN
'Alacak Dekontu'
END
WHEN 62 THEN
CASE LGMAIN.TRCODE
WHEN 3 THEN
'Borç Dekontu'
WHEN 4 THEN
'Alacak Dekontu'
END
END AS TXTISLEMTIP,
CASE LGMAIN.MODULENR
WHEN 7 THEN
(SELECT BNF.FICHENO FROM dbo.LG_133_01_BNFICHE BNF WITH(NOLOCK) WHERE LOGICALREF=BTRNS.SOURCEFREF)
WHEN 4 THEN
INVFC.DOCODE /*INVFC.FICHENO*/
WHEN 5 THEN
CTRNS.DOCODE /*(SELECT BNF.FICHENO FROM dbo.LG_133_01_CLFICHE BNF WITH(NOLOCK) WHERE LOGICALREF=CTRNS.SOURCEFREF) */
WHEN 6 THEN
( SELECT TOP 1 CHQPN.PORTFOYNO FROM LG_133_01_CSTRANS CQTRN WITH(NOLOCK) , LG_133_01_CSCARD CHQPN WHERE (CQTRN.ROLLREF = RLFIC.LOGICALREF) AND (CHQPN.LOGICALREF = CQTRN.CSREF))
WHEN 3 THEN
ORFIC.FICHENO
WHEN 10 THEN
CASHTR.FICHENO
WHEN 61 THEN
CTRNS.DOCODE
WHEN 62 THEN
CTRNS.DOCODE
ELSE
''
END TXTBELGENO,
LGMAIN.DATE_ TRHVADETARIHI,
CASE LGMAIN.MODULENR
WHEN 7 THEN
BTRNS.CUSTTITLE
WHEN 4 THEN
INVFC.GENEXP1
WHEN 5 THEN
CTRNS.LINEEXP
WHEN 6 THEN
RLFIC.GENEXP1
WHEN 3 THEN
ORFIC.GENEXP1
WHEN 10 THEN
CASHTR.CUSTTITLE
WHEN 61 THEN
CTRNS.LINEEXP
WHEN 62 THEN
CTRNS.LINEEXP
ELSE
''
END TXTACIKLAMA,
CASE LGMAIN.SIGN
WHEN 0 THEN
LGMAIN.TOTAL
ELSE
0
END DBLBORC,
CASE LGMAIN.SIGN
WHEN 1 THEN
LGMAIN.TOTAL
ELSE
0
END DBLALACAK
FROM LG_133_01_PAYTRANS LGMAIN WITH (NOLOCK)
LEFT OUTER JOIN LG_133_01_INVOICE INVFC WITH (NOLOCK)
ON (LGMAIN.FICHEREF = INVFC.LOGICALREF)
LEFT OUTER JOIN LG_133_01_CLFLINE CTRNS WITH (NOLOCK)
ON (LGMAIN.FICHEREF = CTRNS.LOGICALREF)
LEFT OUTER JOIN LG_133_01_CSROLL RLFIC WITH (NOLOCK)
ON (LGMAIN.FICHEREF = RLFIC.LOGICALREF)
LEFT OUTER JOIN LG_133_01_BNFLINE BTRNS WITH (NOLOCK)
ON (LGMAIN.FICHEREF = BTRNS.LOGICALREF)
LEFT OUTER JOIN LG_133_01_KSLINES CASHTR WITH (NOLOCK)
ON (LGMAIN.FICHEREF = CASHTR.LOGICALREF)
LEFT OUTER JOIN LG_133_01_ORFICHE ORFIC WITH (NOLOCK)
ON (LGMAIN.FICHEREF = ORFIC.LOGICALREF)
WHERE
(
(LGMAIN.DATE_ >= CONVERT(DATETIME, '1-1-2012', 101))
AND (LGMAIN.DATE_ <= CONVERT(DATETIME, '12-31-2051', 101))
)
AND (
(
(
(
LGMAIN.MODULENR = 3
AND
(
(ORFIC.BRANCH
BETWEEN 0 AND 1
)
OR (ORFIC.BRANCH IN ( 101 ))
)
)
AND
(
(ORFIC.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (ORFIC.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (ORFIC.CANCELLED = 0)
)
OR
(
(
LGMAIN.MODULENR = 4
AND
(
(INVFC.BRANCH
BETWEEN 0 AND 1
)
OR (INVFC.BRANCH IN ( 101 ))
)
)
AND
(
(INVFC.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (INVFC.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (INVFC.CANCELLED = 0)
)
OR
(
(
LGMAIN.MODULENR IN ( 5, 61, 62 )
AND
(
(CTRNS.BRANCH
BETWEEN 0 AND 1
)
OR (CTRNS.BRANCH IN ( 101 ))
)
)
AND
(
(CTRNS.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (CTRNS.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (CTRNS.CANCELLED = 0)
)
OR
(
(
LGMAIN.MODULENR = 6
AND
(
(RLFIC.BRANCH
BETWEEN 0 AND 1
)
OR (RLFIC.BRANCH IN ( 101 ))
)
)
AND
(
(RLFIC.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (RLFIC.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (RLFIC.CANCELLED = 0)
)
OR
(
(
LGMAIN.MODULENR = 7
AND
(
(BTRNS.BRANCH
BETWEEN 0 AND 1
)
OR (BTRNS.BRANCH IN ( 101 ))
)
)
AND
(
(BTRNS.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (BTRNS.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (BTRNS.CANCELLED = 0)
)
OR
(
(
LGMAIN.MODULENR = 10
AND
(
(CASHTR.BRANCH
BETWEEN 0 AND 1
)
OR (CASHTR.BRANCH IN ( 101 ))
)
)
AND
(
(CASHTR.DATE_ >= CONVERT(DATETIME, '1-1-2013', 101))
AND (CASHTR.DATE_ <= CONVERT(DATETIME, '12-31-2050', 101))
)
AND (CASHTR.CANCELLED = 0)
)
)
)
AND (LGMAIN.TOTAL - PAID > 0)
AND (
SELECT CL.CODE
FROM dbo.LG_133_CLCARD CL
WHERE CL.LOGICALREF = LGMAIN.CARDREF
) IS NOT NULL AND (
SELECT CL.ACTIVE
FROM dbo.LG_133_CLCARD CL
WHERE CL.LOGICALREF = LGMAIN.CARDREF
) =0
ORDER BY LGMAIN.CARDREF,
LGMAIN.TRCURR,
LGMAIN.DATE_,
LGMAIN.SIGN,
LGMAIN.MODULENR,
LGMAIN.FICHEREF,
LGMAIN.LOGICALREF;
CHROME INSPECT CLASS HIDE
Örnek aşağıdaki classı cssden gizlemek için
başında ve boşluklarda nokta olmalı
.menu-item.menu-item-type-g1-top.menu-item-object-page.menu-item-g1-standard.menu-item-1000000{
display:none;
}
WORDPRESS HIDE SPECIFIC CATEGORIES POSTS
URL: https://wordpress.org/plugins/anonymous-restricted-content/
DOWNLOAD PLUGIN AND OPEN CATEGORIE AND EDIT AND CHECK RESTRICT
DEVEXPRESS GRIDVIEW REPORISTORY DELETE BUTTON
private void repositoryItemButtonEditSIL_Click(object sender, EventArgs e)
{
gridView1.DeleteSelectedRows();
}
gridcontrol must be editable
gridView1.DeleteRow(gridView1.FocusedRowHandle);
IMAGE TYPE DATABASE SAVE IMAGE AND LOAD IMAGE WITH C#
//LOAD
try { pe_BACKGROUND.Image = Image.FromStream(new MemoryStream(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "BACKGROUND") as byte[] ?? null)); } catch (Exception) { pe_BACKGROUND.Image = null; }
//SAVE
public byte[] imageToByteArray(System.Drawing.Image imageIn)
{
MemoryStream ms = new MemoryStream();
imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
return ms.ToArray();
}
USERS.BACKGROUND = imageToByteArray(pe_BACKGROUND.Image);
logo terminal hatası
sysden terminali ayarla önce sonra regedit hkey_current_user/software/lbs/erp içindeki versionlu klasoru sil
MAILLER ARASI TAŞIMA
OUTLOOKDA ESKİ HOSTTA VE YENİ HOSSTA MAİL AÇILIR VE TAŞINMAMAK İSDENEN YERDEKİ KLASOR TAŞINACAK OLAN MAILE SÜRÜKLENİP BIRAKILIR.
BASIT SQL SERVER PIVOT TABLE MANTIGI
--Declare necessary variables
DECLARE @SQLQuery AS NVARCHAR(MAX)
DECLARE @PivotColumns AS NVARCHAR(MAX)
--Get unique values of pivot column
SELECT @PivotColumns= COALESCE(@PivotColumns + ',','') + QUOTENAME(TARIH)
FROM (SELECT DISTINCT TARIH FROM [dbo].BM_201_IK_SHAREKETLER) AS PivotExample
SELECT @PivotColumns
--Create the dynamic query with all the values for
--pivot column at runtime
SET @SQLQuery =
N'SELECT ADSOYAD,PROJE, ' + @PivotColumns + '
FROM [dbo].[BM_201_IK_SHAREKETLER]
PIVOT( COUNT(SAAT)
FOR TARIH IN (' + @PivotColumns + ')) AS P'
SELECT @SQLQuery
--Execute dynamic query
EXEC sp_executesql @SQLQuery
c# form açıksa tekrar açmasın focus yapsın
foreach (Form FORM in Application.OpenForms)
{
if (FORM.GetType() == typeof(FORM_USER_GROUPS))
{
FORM.BringToFront();
return;
}
}
FORM_USER_GROUPS F = new FORM_USER_GROUPS(CFG);
F.StartPosition = FormStartPosition.CenterScreen;
F.Show();
Blog of Sem 