CREATE TRIGGER KOD
ON LG_005_01_INVOICE
FOR INSERT
AS
DECLARE @GRPCODE INT, @SPECODE NVARCHAR(20), @LOGICALREF INT
SELECT @GRPCODE = GRPCODE, @SPECODE = SPECODE, @LOGICALREF = LOGICALREF FROM INSERTED
IF (@GRPCODE =1)
BEGIN
UPDATE LG_005_01_INVOICE SET SPECODE = 'ALIŞ' WHERE LOGICALREF = @LOGICALREF
END
ELSE
BEGIN
UPDATE LG_005_01_INVOICE SET SPECODE ='SATIŞ' WHERE LOGICALREF =@LOGICALREF
END
Author: semt20
Sql Server HIZLI Sorgu
select * into #satislar from logo_view_satislar_2014_2015 –sql serverde masterin altinda tempdbye atar sadece kullanılan sezondaki kisi erisebilir sql kapanip acilirsa sifirlanir
select yil,sum(toplamtutar) from #satislar group by yil
React native app
https://www.sublimetext.com/3 kur
sublime ac->view->show consolea gir ve burdaki kodlari ekle
https://packagecontrol.io/installation
android studio ve bluestack kur
https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
Windows x64 207.22 MB jdk-8u191-windows-x64.exe kur
cmd
npm install -g expo-cli
npm install -g react-native-cli
npm install -g create-react-native-app
react-native init projectNameHere
cd projectNameHere
react-native run-android
ENVIRMNT USER PATH
%LOCALAPPDATA%\Android\sdk\platform-tools
SYSTEM PATH:C:\Program Files\Java\jdk1.8.0_191
SYSTEM NEW JAVA_HOME C:\Program Files\Java\jdk1.8.0_191
F:\masaustussd\react native\test\android\ klasorunun icine local.properties isminde dosya YARAT ve icine sdk.dir = C:\\Users\\Pnp\\AppData\\Local\\Android\\sdk
Sentez Live Erp Kesin Yevmiyeyi Silme
– Kesin Yevmiye Tarihinden Önce İşlem Yapılamaz .
– entegrasyon fişi yevmiye madde numarasına sahip. Bu fiş üzerinden işlem yapamazsınız .
select RegBookNo, * from Erp_GLReceipt –RegBookNo boş deilse yevmiye oluşturulmuş demektir
select * from Erp_GLRegBook –yevmiye oluşan fiş
update Erp_GLReceipt set RegBookNo = null –yevmiye oluştuysa sil
SQL SERVER SISTEMI KASMADAN SILME WHILE
DECLARE @Rowcount INT = 1 WHILE @Rowcount > 0 BEGIN DELETE TOP (50000) FROM LG_013_01_PAYTRANS where ORGLOGOID LIKE 'TNYF%'
SET @Rowcount = @@ROWCOUNT
END
ps3 crack filezilla
Settings > Network Settings > Settings and Connection Status List. ipyi not et
sarkı usbsini ps3e tak
pacckate setupa gir
sarkı usbsinin içindeki ortadaki programı kur
multimanin oldugu kısımda fileboxa gir ve bilgisardan filezillayı ac
Host: Your PS3’s IP address
Port: 21
Logon type: Normal
User: anonymous
Password: (Clear it out and leave it blank)
On the “Transfer settings” tab:
Transfer mode: active
Tick “Limit number of simultaneous connections” and set it to 1
connect okeydir
oyunu “dev_hdd0/GAMEZ” icine at
ve multimane gir refresh yap
LOGO GO XML VERI ALMA SATIN ALMA FATURASI
IKINCI TYPIN ALTINA FATURA NO22
ASAGIYI XML OLARAK KAYDET
1
05.04.2017
1
SATICI001
247
3
24
24
24
24
1
24
1
05.04.2018
23
57
51
2
1
1
05.04.2017
1
SATICI001
1
24
24
24
1
24
1
05.04.2018
23
57
52
2
1
0000000000051667
2
3
0
1
0
AŞI0008
1
24
24
160
24
1
ADET
1
1
1
24
1
24
1
0000000000051667
0
160
24
4
2017
740
05.04.2017
4
1
1
24
05.04.2017
1
05.04.2017
1
0
2
3
720683
0
1
05.04.2017
1
SATICI001
247
3
24
24
24
24
1
24
1
05.04.2018
23
57
51
2
1
1
05.04.2017
1
SATICI001
1
24
24
24
1
24
1
05.04.2018
23
57
52
2
1
0000000000051667
2
3
0
1
0
AŞI0008
1
24
24
160
24
1
ADET
1
1
1
24
1
24
1
0000000000051667
0
160
24
4
2017
740
05.04.2017
4
1
1
24
05.04.2017
1
05.04.2017
1
0
2
3
720683
0
LOGO TIGER KAPANMAMIS FATURALARIN LISTESI
SUM(PAYTRANS.TOTAL) – SUM(PAYTRANS.PAID) AS KALAN_TUTAR, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE AS FATURA_TARIHI,
PAYTRANS.DATE_ AS ODEME_TARIHI,
( SELECT ( SELECT DEFINITION_ FROM lg_001_PAYPLANS WHERE LOGICALREF = PAYDEFREF ) FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF ) AS ODEME_PLANI
FROM lg_001_03_PAYTRANS AS PAYTRANS
LEFT OUTER JOIN lg_001_CLCARD AS CLCARD ON PAYTRANS.CARDREF = CLCARD.LOGICALREF
WHERE PAYTRANS.CARDREF IN ( SELECT LOGICALREF FROM lg_001_CLCARD AS SYN_CLCARD WHERE CODE LIKE ‘131 %’) AND
( SELECT PAYDEFREF FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF) IN( 41, 43, 39 ) AND
PAYTRANS.MODULENR IN( 4 ) AND
PAYTRANS.PROCDATE PAYTRANS.DATE_ AND
PAYTRANS.DATE_ <= ‘2016-10-11 00:00:00.000’
GROUP BY PAYTRANS.CARDREF, PAYTRANS.MODULENR, PAYTRANS.FICHEREF, PAYTRANS.TRCODE, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE, PAYTRANS.DATE_
HAVING SUM(PAYTRANS.TOTAL) – SUM(PAYTRANS.PAID) > 0.99
ORDER BY PAYTRANS.CARDREF;
SELECT PAYTRANS.CARDREF, PAYTRANS.MODULENR, PAYTRANS.FICHEREF, PAYTRANS.TRCODE, SUM(PAYTRANS.TOTAL) AS FATURA_TOPLAMI, SUM(PAYTRANS.PAID) AS KAPANAN_TUTAR,
SUM(PAYTRANS.TOTAL) – SUM(PAYTRANS.PAID) AS KALAN_TUTAR, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE AS FATURA_TARIHI,
PAYTRANS.DATE_ AS ODEME_TARIHI,
( SELECT ( SELECT DEFINITION_ FROM lg_001_PAYPLANS WHERE LOGICALREF = PAYDEFREF ) FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF ) AS ODEME_PLANI
FROM lg_001_03_PAYTRANS AS PAYTRANS
LEFT OUTER JOIN lg_001_CLCARD AS CLCARD ON PAYTRANS.CARDREF = CLCARD.LOGICALREF
WHERE PAYTRANS.CARDREF IN ( SELECT LOGICALREF FROM lg_001_CLCARD AS SYN_CLCARD WHERE CODE LIKE ‘131 %’) AND
( SELECT PAYDEFREF FROM lg_001_03_INVOICE WHERE LOGICALREF = PAYTRANS.FICHEREF) IN( 41, 43, 39 ) AND
PAYTRANS.MODULENR IN( 4 ) AND
PAYTRANS.PROCDATE PAYTRANS.DATE_ AND
PAYTRANS.DATE_ <= '2016-10-11 00:00:00.000'
GROUP BY PAYTRANS.CARDREF, PAYTRANS.MODULENR, PAYTRANS.FICHEREF, PAYTRANS.TRCODE, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.TOWN,CLCARD.DISTRICT, CLCARD.TELNRS2, PAYTRANS.PROCDATE, PAYTRANS.DATE_
HAVING SUM(PAYTRANS.TOTAL) – SUM(PAYTRANS.PAID) > 0.99
ORDER BY PAYTRANS.CARDREF;
KanBoard Pano , Database ve Mail Yollama Ayarları
Aşağıdaki sorguda Panoyu türkçe yapabilirsin. Ama database silip baştan yükleyince sıfırlanır.
update `columns` set title =’On Hazirlik’ WHERE title =’Backlog’;
update `columns` set title =’Yapilacaklar’ WHERE title =’Ready’;
update `columns` set title =’Tamamlandi’ WHERE title =’Done’;
update `columns` set title =’Yapiliyor’ WHERE title =’Work in progress’;
————————————————
Eğer Backlogun hiç cıkmasını isdemezsen
delete from `columns` WHERE title =’tBacklog’
—————————————————
NOT TÜRKÇE KARAKTER KULLANMA
Bir sonraki yeni proje yaratmalarında backlog otomatik olarak gelmesin ve diğer panolar türkçe olarak gelsin isdeniyorusa /app/Model/BoardModel.php içindeki return array(t(‘Backlog’), t(‘Ready’), t(‘Work in progress’), t(‘Done’)); satırını şu şekilde yap
return array( t(‘Yapilacaklar’), t(‘Yapiliyor’), t(‘Tamamlandi’));
————–
Eğer Database mail ayarlarını yapacaksan ana roottaki config.default.php adını config.php yapip değerlerini vermelisin ornegin default sqldb veritabanı olarak kullanılır ama mysql kullanılması isdeniyorsa ayarının config.php’nin içinden yapılması gerekir. Mail ayarınında aynı yerden yapılması gerekir(gönderen maili).
MYSQL Ayar örneği;
// Sendmail command to use when the transport is “sendmail”
define(‘MAIL_SENDMAIL_COMMAND’, ‘/usr/sbin/sendmail -bs’);
// Run automatically database migrations
// If set to false, you will have to run manually the SQL migrations from the CLI during the next Kanboard upgrade
// Do not run the migrations from multiple processes at the same time (example: web page + background worker)
define(‘DB_RUN_MIGRATIONS’, true);
// Database driver: sqlite, mysql or postgres (sqlite by default)
define(‘DB_DRIVER’, ‘mysql’);
// Mysql/Postgres username
define(‘DB_USERNAME’, ‘pnpwebdisign_trl’);
// Mysql/Postgres password
define(‘DB_PASSWORD’, ’12ssssw’);
// Mysql/Postgres hostname
define(‘DB_HOSTNAME’, ‘localhost’);
// Mysql/Postgres database name
define(‘DB_NAME’, ‘pnpwebdisign_trl’);
// Mysql/Postgres custom port (null = default port)
define(‘DB_PORT’, null);
// Mysql SSL key
define(‘DB_SSL_KEY’, null);
————————
Gmailden Mail Yollama Ayarı;
// Enable/disable email configuration from the user interface
define(‘MAIL_CONFIGURATION’, true);
// E-mail address used for the “From” header (notifications)
define(‘MAIL_FROM’, ‘pxxxx@gmail.com’);
// Mail transport available: “smtp”, “sendmail”, “mail” (PHP mail function), “postmark”, “mailgun”, “sendgrid”
define(‘MAIL_TRANSPORT’, ‘smtp’);
// SMTP configuration to use when the “smtp” transport is chosen
define(‘MAIL_SMTP_HOSTNAME’, ‘smtp.gmail.com’);
define(‘MAIL_SMTP_PORT’, 465);
define(‘MAIL_SMTP_USERNAME’, ‘pxxxx@gmail.com’);
define(‘MAIL_SMTP_PASSWORD’, ‘123sxe’);
define(‘MAIL_SMTP_ENCRYPTION’, ‘ssl’); // Valid values are “null”, “ssl” or “tls”
// Sendmail command to use when the transport is “sendmail”
define(‘MAIL_SENDMAIL_COMMAND’, ‘/usr/sbin/sendmail -bs’);
———————
Notificationlar mail olarak giderken mail başlığında admin via kanboard vb… yazar onu deiştirmek için /trello/1/app/Core/Mail/client.phpde
$author = e('%s via Kanboard', $this->helper->user->getFullname());
$author = e('%s Tarafından Gönderilen Bilgilendirme', $this->helper->user->getFullname());


