2025-10-07 09:41:50 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 09:41:50 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 09:41:50 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 09:41:50 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 09:41:50 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 09:41:50 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-07 09:41:50 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-07 09:41:51 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 09:41:51 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-07 09:41:51 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-07 09:41:51 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 09:41:51 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-07 09:41:51 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 09:41:51 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-07 09:45:05 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-07 09:45:07 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 09:45:07 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-07 09:45:07 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-07 09:45:08 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=',"Details"='',"ExDetails"='/mp4w9vK4UPoQBVh9FsGPg==',"Max"=1,"OlusturmaTarihi"='6.10.2025 07:23:01',"Durum"=1  WHERE "ID"=2
2025-10-07 09:45:08 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','7.10.2025 09:45:08','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"Rx6mbdYBJ8Gb/3I1nd/LWXVFPgVTf1heUh+CX9il0Ok=","Details":"","ExDetails":"/mp4w9vK4UPoQBVh9FsGPg==","Max":1,"_sonTarih":"2025-10-07T00:00:00","ID":2,"OlusturmaTarihi":"2025-10-06T07:23:01.289372","Durum":1}') ;
2025-10-07 09:45:08 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-07 09:45:09 - 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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('7.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('7.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 09:45:09 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-07 09:45:09 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-07 09:45:09 - 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" > ('7.10.2025 09:45:09' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-07 09:45:09 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('7.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('7.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 09:45:09 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-07 09:45:10 - 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-10-07 09:45:10 - 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-10-07 09:45:10 - 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-10-07 09:45:10 - 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-10-07 09:45:10 - 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-10-07 09:45:10 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-07 10:00:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 10:00:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 10:00:18 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 10:00:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-07 10:00:18 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 10:00:18 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-07 10:00:18 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-07 10:00:19 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-07 10:00:19 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-07 10:00:19 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-07 10:00:19 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 10:00:19 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-07 10:00:19 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-07 10:00:19 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
