2025-10-08 10:00:23 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:00:24 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:00:24 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:00:24 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:00:24 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:00:24 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:00:24 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:00:25 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:00:25 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:00:25 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:00:25 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:00:25 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:00:25 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:00:25 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:04:49 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:04:49 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:04:49 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:04:49 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:04:49 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:04:49 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:04:49 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:04:50 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:04:50 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:04:50 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:04:50 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:04:50 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:04:50 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:04:50 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:50:05 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:50:05 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:50:05 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:50:05 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:50:05 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:50:05 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:50:06 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:50:07 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:50:07 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:50:07 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:50:07 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:50:07 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:50:07 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:50:07 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:50:10 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankahareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarthareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarttanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankaposhareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankapostanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankatanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'barkodlar' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'birimtanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihareketler' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihesaplar' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ceksenethareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dizaynlar' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dokumanlar' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'donemtanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumalias' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusummukellefler' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumtanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fatura' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'faturahareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatipleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fiyattanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'gridgorunumler' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasahareketleri' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasatanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kdvdepartman' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kullanicilar' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'lisanstanimlari' 
2025-10-08 10:50:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'notlar' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odeme' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odemehareket' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'logtanim' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklif' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklifhareketleri' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'terazikodtanim' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ozelkodtanimlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'parametreler' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'posterazitanim' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'projekodtanimlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklet' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklethareketleri' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayim' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayimdetaylari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'serinotanimlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokfiyatlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokgruplari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokhareketleri' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokkartlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'subetanimlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'urunfiyattablosu' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'uygulamaversiyon' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarthareketleri' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarttanimlari' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ilceler' 
2025-10-08 10:50:11 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'iller' 
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "FirmaTanimlari"  
2025-10-08 10:50:11 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "KdvDepartman"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "CariKodu" = '99.99.99.00099' ) 
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "StokGruplari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "BankaTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "BankaPosTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "BankaKartTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "YemekKartTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "Kullanicilar"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "iLler"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "iLceler"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "FirmaTipleri"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "BirimTanimlari"  
2025-10-08 10:50:11 - SELECT COUNT(1) FROM "TeraziKodTanim"  
2025-10-08 10:50:11 - UPDATE "Fatura" SET "AcikMi"=false, "EDurum"=0 
2025-10-08 10:50:11 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:50:11 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:50:13 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 10:50:14 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:50:14 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:50:14 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:50:16 - SELECT "Plaka","Aciklama","ID","OlusturmaTarihi","Durum" FROM "iLler" ORDER BY "Aciklama" ASC 
2025-10-08 10:50:29 - SELECT "Plaka","Aciklama","ID","OlusturmaTarihi","Durum" FROM "iLler"   WHERE ( "Aciklama" = 'ORDU' )   LIMIT 1 offset 0
2025-10-08 10:50:29 - SELECT "il_ID","Aciklama","ID","OlusturmaTarihi","Durum" FROM "iLceler"  WHERE ( "il_ID" =52)ORDER BY "Aciklama" ASC 
2025-10-08 10:50:29 - SELECT "il_ID","Aciklama","ID","OlusturmaTarihi","Durum" FROM "iLceler"   WHERE (( "il_ID" = 52 ) AND ( "Aciklama" = 'ALTINORDU' ))   LIMIT 1 offset 0
2025-10-08 10:51:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:51:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:51:19 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:51:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 10:51:19 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:51:19 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:51:19 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:51:20 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:51:20 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:51:20 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 10:51:20 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:51:20 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:51:20 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:51:20 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 10:51:22 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 10:51:23 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 10:51:23 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 10:51:23 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 10:51:23 - INSERT INTO "LisansTanimlari"  
           ("SecretKey","Key","Details","ExDetails","Max","OlusturmaTarihi","Durum")
     VALUES
           ('MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL','25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7','','tBYDkE9rfeNkBYgZtE1VHw==',1,'8.10.2025 07:51:23',1) returning "ID"
2025-10-08 10:51:23 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Ekle',4,'ORCA','8.10.2025 10:51:23','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 10:51: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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 10:51:24 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:51:24 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 10:51:24 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 10:51:24 - 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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 10:51: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" > ('8.10.2025 10:51:24' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 10:51:24 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 10:51:24 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 10:51: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-10-08 10:51: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-10-08 10:51: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-10-08 10:51: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-10-08 10:51: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-10-08 10:51:25 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 11:03:24 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:03:24 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:03:24 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:03:24 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:03:24 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:03:24 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:03:24 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:03:25 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:03:25 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:03:25 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:03:25 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:03:25 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:03:25 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:03:25 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:03:30 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 11:03:32 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:03:32 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:03:32 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:03:32 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='tBYDkE9rfeNkBYgZtE1VHw==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-08 11:03:32 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','8.10.2025 11:03:32','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"tBYDkE9rfeNkBYgZtE1VHw==","Max":1,"_sonTarih":"2025-10-08T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-08 11:03:32 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:03:33 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:03:33 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:03:33 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:03:33 - 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" > ('8.10.2025 11:03:33' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:03:33 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:03:33 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:03:34 - 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-08 11:03:34 - 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-08 11:03:34 - 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-08 11:03:34 - 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-08 11:03:34 - 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-08 11:03:34 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 11:04:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:04:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:04:32 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:04:32 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:04:32 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:04:32 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:04:32 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:04:32 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:04:32 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:04:32 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:04:32 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:04:32 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:04:32 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:04:32 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:04:33 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 11:04:35 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:04:35 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:04:35 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:04:35 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='tBYDkE9rfeNkBYgZtE1VHw==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-08 11:04:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','8.10.2025 11:04:35','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"tBYDkE9rfeNkBYgZtE1VHw==","Max":1,"_sonTarih":"2025-10-08T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-08 11:04:35 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:04:36 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:04:36 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:04:36 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:04:36 - 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" > ('8.10.2025 11:04:36' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:04:36 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:04:36 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:04:37 - 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-08 11:04:37 - 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-08 11:04:37 - 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-08 11:04:37 - 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-08 11:04:37 - 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-08 11:04:37 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 11:06:00 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:06:00 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:06:00 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:06:00 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:06:00 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:06:00 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:06:00 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:06:01 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:06:01 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:06:01 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:06:01 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:06:01 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:06:01 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:06:01 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:22:58 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 11:23:00 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:23:00 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:23:00 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:23:00 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='tBYDkE9rfeNkBYgZtE1VHw==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-08 11:23:00 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','8.10.2025 11:23:00','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"tBYDkE9rfeNkBYgZtE1VHw==","Max":1,"_sonTarih":"2025-10-08T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-08 11:23:00 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:23:01 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:23:01 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:23:01 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:23:01 - 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" > ('8.10.2025 11:23:01' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:23:01 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:23:01 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:23:02 - 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-08 11:23:02 - 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-08 11:23:02 - 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-08 11:23:02 - 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-08 11:23:02 - 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-08 11:23:02 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 11:35:29 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:35:30 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:35:30 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:35:30 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 11:35:30 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:35:30 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:35:30 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:35:31 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:35:31 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:35:31 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 11:35:31 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:35:31 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:35:31 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:35:31 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 11:38:47 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 11:38:49 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 11:38:49 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 11:38:49 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 11:38:49 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='tBYDkE9rfeNkBYgZtE1VHw==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-08 11:38:49 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','8.10.2025 11:38:49','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"tBYDkE9rfeNkBYgZtE1VHw==","Max":1,"_sonTarih":"2025-10-08T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-08 11:38:49 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:38: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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:38:50 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:38:50 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:38:50 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 11:38:50 - 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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:38: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" > ('8.10.2025 11:38:50' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 11:38:50 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 11:38:50 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 11:38:51 - 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-08 11:38:51 - 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-08 11:38:51 - 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-08 11:38:51 - 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-08 11:38:51 - 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-08 11:38:51 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 11:39:16 - SELECT IND,KOD,KISAAD FROM TBLFIRMA ORDER BY KISAAD
2025-10-08 11:39:16 - SELECT * FROM PUBLIC."FirmaTanimlari" WHERE "Durum"=1 ORDER BY "FirmaAdi"
2025-10-08 11:39:18 - SELECT * FROM TBLDONEM WHERE FIND=110
2025-10-08 11:39:20 - SELECT "ID","DonemAdi" FROM PUBLIC."DonemTanimlari" WHERE "FirmaID"=1 ORDER BY "DonemAdi"
2025-10-08 11:39:22 - SELECT
CR.FIRMAKODU AS CariKodu,
CR.FIRMAADI AS CariAdi,
CR.ADI AS Adi,
CR.SOYADI AS Soyadi,
CR.VERGIDAIRESI AS VergiDairesi,
ISNULL(CR.VERGINO,TC.TCKIMLIKNO) AS VergiTcNo,
CR.EMAIL AS Mail,
CR.TELEFON1 AS Telefon,
CR.TELEFON3 AS GSM,
CR.ADRESFATURA AS Adres,
CR.SEHIR AS Il,
CR.IL AS Ilce,
(SELECT SUM(BORC) FROM F0110D0003TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Borc,
(SELECT SUM(ALACAK) FROM F0110D0003TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Alacak,
(SELECT SUM(BORC-ALACAK) FROM F0110D0003TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Bakiye,
CASE WHEN ISNULL(CR.VERGINO,'')<>'' THEN 'LİMİTED ŞİRKETİ' ELSE 'ŞAHIS ŞİRKETİ' END CariFirmaTipi
FROM F0110TBLCARI AS CR
LEFT JOIN F0110TBLKREMUSCUZDAN AS TC ON TC.MUSTERINO=CR.IND
WHERE CR.IND>99 AND ISNULL(CR.STATUS,0)<>2 AND ISNULL(CR.FIRMAADI,'')<>''
2025-10-08 12:59:06 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 12:59:06 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 12:59:06 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 12:59:06 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 12:59:06 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 12:59:06 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 12:59:06 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 12:59:07 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 12:59:07 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 12:59:07 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 12:59:07 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 12:59:07 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 12:59:07 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 12:59:07 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 12:59:09 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 12:59:11 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 12:59:11 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 12:59:11 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 12:59:11 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='tBYDkE9rfeNkBYgZtE1VHw==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-08 12:59:12 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','8.10.2025 12:59:11','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"tBYDkE9rfeNkBYgZtE1VHw==","Max":1,"_sonTarih":"2025-10-08T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-08 12:59:12 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 12:59:13 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 12:59:13 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 12:59:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 12:59:13 - 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" > ('8.10.2025 12:59:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-08 12:59:13 - 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) >= ('8.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('8.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 12:59:13 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-08 12:59:14 - 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-08 12:59:14 - 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-08 12:59:14 - 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-08 12:59:14 - 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-08 12:59:14 - 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-08 12:59:14 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-08 12:59:17 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))GROUP BY "ST"."ID"  
2025-10-08 12:59:17 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-08 12:59:38 - SELECT IND,KOD,KISAAD FROM TBLFIRMA ORDER BY KISAAD
2025-10-08 12:59:38 - SELECT * FROM PUBLIC."FirmaTanimlari" WHERE "Durum"=1 ORDER BY "FirmaAdi"
2025-10-08 12:59:40 - SELECT "ID","DonemAdi" FROM PUBLIC."DonemTanimlari" WHERE "FirmaID"=1 ORDER BY "DonemAdi"
2025-10-08 12:59:42 - SELECT * FROM TBLDONEM WHERE FIND=110
2025-10-08 12:59:46 - SELECT
ST.STOKKODU AS StokKodu,
ST.MALINCINSI AS StokAdi,
'AKTARIM' StokGrubu,
BR.BIRIMADI AS Birim,
BR.BARCODE AS Barkod,
ISNULL(ST.MALIYET,ST.ALISFIYATI) AlisFiyati,
BR.SATISFIYATI1 AS SatisFiyati,
BR.KDV AS KDV,
ST.ISTIHBARAT AS Aciklama,
ST.ALISKDVORANI AS AlisKDV,
ST.KOD1 AS Marka,
CASE WHEN BR.KDVDAHIL=1 THEN 1 ELSE 0 END as KDVDahil,
ISNULL((SELECT SUM(GIREN-CIKAN) FROM F0110D0002TBLSTOKHAREKETLERI WHERE STOKNO=BR.STOKNO),0) AS Envanter
FROM F0110TBLBIRIMLEREX AS BR
LEFT JOIN F0110TBLSTOKLAR AS ST ON ST.IND=BR.STOKNO
WHERE ST.IND>99 AND ISNULL(ST.STATUS,0)<>2
2025-10-08 12:59:48 - SELECT
CR.FIRMAKODU AS CariKodu,
CR.FIRMAADI AS CariAdi,
CR.ADI AS Adi,
CR.SOYADI AS Soyadi,
CR.VERGIDAIRESI AS VergiDairesi,
ISNULL(CR.VERGINO,TC.TCKIMLIKNO) AS VergiTcNo,
CR.EMAIL AS Mail,
CR.TELEFON1 AS Telefon,
CR.TELEFON3 AS GSM,
CR.ADRESFATURA AS Adres,
CR.SEHIR AS Il,
CR.IL AS Ilce,
(SELECT SUM(BORC) FROM F0110D0002TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Borc,
(SELECT SUM(ALACAK) FROM F0110D0002TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Alacak,
(SELECT SUM(BORC-ALACAK) FROM F0110D0002TBLCARIHAREKETLERI WHERE FIRMANO=CR.IND) AS Bakiye,
CASE WHEN ISNULL(CR.VERGINO,'')<>'' THEN 'LİMİTED ŞİRKETİ' ELSE 'ŞAHIS ŞİRKETİ' END CariFirmaTipi
FROM F0110TBLCARI AS CR
LEFT JOIN F0110TBLKREMUSCUZDAN AS TC ON TC.MUSTERINO=CR.IND
WHERE CR.IND>99 AND ISNULL(CR.STATUS,0)<>2 AND ISNULL(CR.FIRMAADI,'')<>''
2025-10-08 13:13:20 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:13:20 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:13:20 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:13:20 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:13:20 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:13:20 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 13:13:20 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 13:13:21 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:13:21 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 13:13:21 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 13:13:21 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 13:13:21 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 13:13:21 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 13:13:21 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 13:13:37 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-08 13:27:07 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:27:08 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:27:08 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:27:08 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-08 13:27:08 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:27:08 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-08 13:27:08 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-08 13:27:09 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-08 13:27:09 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-08 13:27:09 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-08 13:27:09 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 13:27:09 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-08 13:27:09 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-08 13:27:09 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
