LOGO LKS2 SQL Anlik Sanal Satislar
SELECT TOP 100 PERCENT dbo.LG_114_01_INVOICE.DATE_ AS TARİH, dbo.LG_114_01_INVOICE.FICHENO AS [FATURA NO],
dbo.LG_SLSMAN.DEFINITION_ AS [SATIŞ ELEMANI], dbo.LG_114_CLCARD.DEFINITION_ AS [CARİ HESAP ÜNVANI],
dbo.LG_114_ITEMS.NAME AS [ÜRÜN ADI], dbo.LG_114_01_STLINE.AMOUNT AS ADET, dbo.LG_114_01_STLINE.VATMATRAH AS TUTAR,
dbo.LG_114_01_INVOICE.GENEXP1 AS [FATURA AÇIKLAMA]
FROM dbo.LG_114_01_INVOICE INNER JOIN
dbo.LG_114_01_STLINE ON dbo.LG_114_01_INVOICE.LOGICALREF = dbo.LG_114_01_STLINE.INVOICEREF INNER JOIN
dbo.LG_114_CLCARD ON dbo.LG_114_01_INVOICE.CLIENTREF = dbo.LG_114_CLCARD.LOGICALREF INNER JOIN
dbo.LG_114_ITEMS ON dbo.LG_114_01_STLINE.STOCKREF = dbo.LG_114_ITEMS.LOGICALREF INNER JOIN
dbo.LG_SLSMAN ON dbo.LG_114_01_INVOICE.SALESMANREF = dbo.LG_SLSMAN.LOGICALREF
WHERE (dbo.LG_114_ITEMS.CODE = KK 01') OR
(dbo.LG_114_ITEMS.CODE = KK 05') OR
(dbo.LG_114_ITEMS.CODE = KK 06') OR
(dbo.LG_114_ITEMS.CODE = KK 06_2') OR
(dbo.LG_114_ITEMS.CODE = KK 06_3') OR
(dbo.LG_114_ITEMS.CODE = KK 07') OR
(dbo.LG_114_ITEMS.CODE = KK 08') OR
(dbo.LG_114_ITEMS.CODE = KK 09') OR
(dbo.LG_114_ITEMS.CODE = KK 10') OR
(dbo.LG_114_ITEMS.CODE = KK 11') OR
(dbo.LG_114_ITEMS.CODE = KK 12') OR
(dbo.LG_114_ITEMS.CODE = KK 12_1') OR
(dbo.LG_114_ITEMS.CODE = KK 13') OR
(dbo.LG_114_ITEMS.CODE = KK 13_2') OR
(dbo.LG_114_ITEMS.CODE = KK 13_3') OR
(dbo.LG_114_ITEMS.CODE = KK 14') OR
(dbo.LG_114_ITEMS.CODE = KK 15') OR
(dbo.LG_114_ITEMS.CODE = KK 16') OR
(dbo.LG_114_ITEMS.CODE = KK 16_1') OR
(dbo.LG_114_ITEMS.CODE = KK 17') OR
(dbo.LG_114_ITEMS.CODE = KK 17_1') OR
(dbo.LG_114_ITEMS.CODE = KK 17_2') OR
(dbo.LG_114_ITEMS.CODE = KK 17_3') OR
(dbo.LG_114_ITEMS.CODE = KK 17_4') OR
(dbo.LG_114_ITEMS.CODE = KK 17_5') OR
(dbo.LG_114_ITEMS.CODE = KK 17_6') OR
(dbo.LG_114_ITEMS.CODE = KK 17_7') OR
(dbo.LG_114_ITEMS.CODE = KK 36_0')
GROUP BY dbo.LG_114_01_INVOICE.DATE_, dbo.LG_114_01_INVOICE.FICHENO, dbo.LG_114_01_INVOICE.TIME_, dbo.LG_114_CLCARD.DEFINITION_,
dbo.LG_114_ITEMS.NAME, dbo.LG_SLSMAN.DEFINITION_, dbo.LG_114_01_STLINE.AMOUNT, dbo.LG_114_01_STLINE.VATMATRAH,
dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDHOUR,dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDMIN,dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDSEC,
dbo.LG_114_01_INVOICE.GENEXP1
HAVING (dbo.LG_114_01_INVOICE.DATE_ >= CONVERT(DATETIME, '2013-09-01 00:00:00', 102))
ORDER BY dbo.LG_114_01_INVOICE.DATE_, dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDHOUR,dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDMIN,dbo.LG_114_01_INVOICE.CAPIBLOCK_CREATEDSEC
Phpde turkce kakakter
notepad ++ da önce new yap
encoding utf8 without bom seçili olsun
türkçe karakterli yazını yaz
ve encode in ansiyi seç ve php koduna kopyala
PHPBOT DOVIZ KURLARI – NOBETCI ECZANE KKTC
(<?php echo date("d/m/Y")
?>
) DOVİZ KURLARI
<?php
$link = “http://www.kktcmerkezbankasi.org/”;
$parcala = ‘@
| # | Alış | Satış |
|---|---|---|
| ‘ . $resmi_kur->Sembol . ‘ | ‘ . number_format((float) $resmi_kur->Doviz_Alis, 2, ‘.’, ‘,’) . ‘ TL | ‘ . number_format((float) $resmi_kur->Doviz_Satis, 2, ‘.’, ‘,’) . ‘ TL |
‘;
?>
——————————————————————————
(<?php echo date("d/m/Y")
?>
) NÖBETÇİ ECZANELER
<?php
$link = “http://www.kteb.org/”;
$parcala = ‘@
@si’;
$botara = str_replace(array(“\n”,”\r”,”\t”), NULL, file_get_contents($link));
preg_match_all($parcala, $botara, $baslik);
echo $baslik[0][0];
?>
DELPHI PROGRAM HATALARINI MSGBOXDA GOSTER
except
on E : Exception do
ShowMessage(E.Message);
end;
CXGRID AUTOGETCOLUMNS VE FOOTER
cxGrid1DBTableView1.BeginUpdate;
cxGrid1DBTableView1.ClearItems;
cxGrid1DBTableView1.DataController.CreateAllItems;
cxGrid1DBTableView1.EndUpdate;
FOOTER
ÖNCE CXGRIDIN USTUNDEN CUSTOMIZE VE ADDA BAS
SONRA VIEWSDEN SOLDAKINE TIKLA VE EDIT VIEW LAYOUT YAP VE COLUMNA SAG TIKLA FOOTERA TIKLA OK DE VE SAGDAKI CXGRID1DBTABLEVIEW1COLUMNA TIKLA VE DELETE BAS
cxGrid1DBTableView1.Columns[0].Summary.FooterKind:=skCount;
cxGrid1DBTableView1.ApplyBestFit();
Flash CS3 play button
Once karemizi ekleyip üstüne sağ tıklayıp sembole dönüştür düğme ve ok
Fatih1453 projesindeki akıllı tvlerde windows 8e touchdriver yüklemek
Fatih1453 projesindeki akıllı tvlerde windows 8e touchdriver yüklemek için touchscreen driver setup dosyasını uyumluluk modunda windows 7 yap öyle kur.
Driver indir








