2025-12-01 15:14:43 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 15:14:43 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 15:14:43 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 15:14:43 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 15:14:43 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 15:14:43 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 15:14:43 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-01 15:14:45 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 15:14:45 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-01 15:14:45 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-01 15:14:45 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 15:14:45 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 15:14:45 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 15:14:45 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:20:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:20:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:20:32 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:20:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:20:32 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:20:32 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:20:32 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-01 16:20:32 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:20:32 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:20:32 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:20:32 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:20:32 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:20:32 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:20:32 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:20:47 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-01 16:20:48 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:20:48 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:20:48 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-01 16:20:48 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='vq1crsR5zHAvgtjNQ32SgQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-01 16:20:48 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','1.12.2025 16:20:48','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"vq1crsR5zHAvgtjNQ32SgQ==","Max":1,"_sonTarih":"2025-12-01T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-01 16:20:48 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-01 16:20:49 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:20:49 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:20:49 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:20:49 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:20:49 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:49' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:20:49 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:49' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:20:49 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:49' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:20:49 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:49' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:20:49 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('1.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('1.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:20:50 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:20:50 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:20:50 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:20:50 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:20:50 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:20:50 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:20:50 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:20:50 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:20:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:20:50 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('1.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('1.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:20:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:20:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:20:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:20:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:20:50 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:20:50 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-01 16:38:03 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:38:03 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:38:03 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:38:03 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-01 16:38:03 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:38:03 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:38:03 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-01 16:38:04 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:38:04 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:38:04 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:38:04 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:04 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:38:04 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:04 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:38:07 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`   WHERE ( `ConnectID` = @ConnectID0 )  ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:38:18 - UPDATE `TblConnection`  SET
           `ID`=@ID,`Server`=@Server,`Username`=@Username,`Password`=@Password,`DatabaseName`=@DatabaseName,`ConnectID`=@ConnectID,`Port`=@Port,`Trusted`=@Trusted  WHERE ( `ID` = @ID0 )
2025-12-01 16:38:19 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:38:19 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:38:19 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-01 16:38:20 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:20 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-01 16:38:20 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:22 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-01 16:38:23 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-01 16:38:23 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:38:23 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-01 16:38:23 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='2K3SuoJaIf9xq1smG1cKca6OUhWDPVKzf9gpqF3odis=',"Key"='C3CC81C9579FD2DFE2C87780339820699D3F3178B405B6D0BAFAA5B29257A92F',"Details"='',"ExDetails"='vq1crsR5zHAvgtjNQ32SgQ==',"Max"=1,"OlusturmaTarihi"='8.11.2025 09:51:54',"Durum"=1  WHERE "ID"=2
2025-12-01 16:38:23 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','1.12.2025 16:38:23','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"2K3SuoJaIf9xq1smG1cKca6OUhWDPVKzf9gpqF3odis=","Key":"C3CC81C9579FD2DFE2C87780339820699D3F3178B405B6D0BAFAA5B29257A92F","Details":"","ExDetails":"vq1crsR5zHAvgtjNQ32SgQ==","Max":1,"_sonTarih":"2025-12-01T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-08T09:51:54.53662","Durum":1}') ;
2025-12-01 16:38:23 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-01 16:38:24 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:38:24 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:38:24 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:38:24 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:38:24 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:38:24 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:38:24 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:38:24 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:38:24 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('1.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('1.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:24 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-01 16:38:24 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-01 16:38:24 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:38:24 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-01 16:38:24 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:38:24 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:38:25 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:25' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-12-01 16:38:25 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:25' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-12-01 16:38:25 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:25' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:38:25 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('1.12.2025 16:38:25' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-12-01 16:38:25 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('1.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('1.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-01 16:38:25 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-01 16:38:25 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-01 16:38:25 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:25 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:25 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:25 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:25 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:25 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-01 16:38:28 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-12-01 16:38:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:33 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))  AND ((((("CR"."CariKodu" ilike concat('%','uzman','%')) OR ("CR"."CariAdi" ilike concat('%','uzman','%')) ) OR  ( (LOWER("CR"."CariAdi"))  ilike concat('%', (LOWER('uzman')) ,'%')) ) OR  ( (UPPER("CR"."CariAdi"))  ilike concat('%', (UPPER('uzman')) ,'%')) ) OR  ("CR"."Adi" ilike concat('%','uzman','%')) )GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-12-01 16:38:35 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-01 16:38:35 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:35 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-01 16:38:35 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (( "CariID" = 1286 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-12-01 16:38:35 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 1286 )) 
