2025-10-10 09:23:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:23:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:23:18 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:23:18 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:23:18 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:23:18 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:23:18 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:23:19 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankahareketleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarthareketleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarttanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankaposhareketleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankapostanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankatanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'barkodlar' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'birimtanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihareketler' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihesaplar' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ceksenethareketleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dizaynlar' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dokumanlar' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'donemtanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumalias' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusummukellefler' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumtanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fatura' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'faturahareketleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatipleri' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fiyattanimlari' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'gridgorunumler' 
2025-10-10 09:23:19 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasahareketleri' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasatanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kdvdepartman' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kullanicilar' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'lisanstanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'notlar' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odeme' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odemehareket' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'logtanim' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklif' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklifhareketleri' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'terazikodtanim' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ozelkodtanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'parametreler' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'posterazitanim' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'projekodtanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklet' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklethareketleri' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayim' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayimdetaylari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'serinotanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokfiyatlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokgruplari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokhareketleri' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokkartlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'subetanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'urunfiyattablosu' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'uygulamaversiyon' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarthareketleri' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarttanimlari' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ilceler' 
2025-10-10 09:23:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'iller' 
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "FirmaTanimlari"  
2025-10-10 09:23:20 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "KdvDepartman"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "CariKodu" = '99.99.99.00099' ) 
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "StokGruplari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "BankaTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "BankaPosTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "BankaKartTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "YemekKartTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "Kullanicilar"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "iLler"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "iLceler"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "FirmaTipleri"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "BirimTanimlari"  
2025-10-10 09:23:20 - SELECT COUNT(1) FROM "TeraziKodTanim"  
2025-10-10 09:23:20 - UPDATE "Fatura" SET "AcikMi"=false, "EDurum"=0 
2025-10-10 09:23:20 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:23:20 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:23:20 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"  WHERE (( "ID" > 0 ) AND ( "BilgisayarAdi" = 'KKO' )) 
2025-10-10 09:23:20 - DELETE FROM "UygulamaVersiyon" WHERE (( "ID" > 0 ) AND ( "BilgisayarAdi" = 'KKO' )) 
2025-10-10 09:23:20 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Sil',2,'Bilinmiyor','10.10.2025 09:23:20','Sil işlemi yapıldı.','KKO','{"Version":"1.0.2.4","UygulamaAdi":"OrcaERP","BilgisayarAdi":"KKO","GuncellemeTarihi":"2025-09-12T00:00:00","YeniVersion":false,"ID":2,"OlusturmaTarihi":"2025-09-12T07:45:36.513026","Durum":1}') ;
2025-10-10 09:23:20 - INSERT INTO "UygulamaVersiyon"  
           ("Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","OlusturmaTarihi","Durum")
     VALUES
           ('1.0.2.5','OrcaERP','KKO','10.10.2025 00:00:00',True,'10.10.2025 06:23:20',1) returning "ID"
2025-10-10 09:23:20 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Ekle',3,'Bilinmiyor','10.10.2025 09:23:20','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-10 09:23:21 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:23:21 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:23:21 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:23:21 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:23:21 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:23:21 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:23:21 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:27:56 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-10 09:27:58 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:27:58 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:27:58 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:27:58 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='9EIjzzhlWuIk+8FOKclH/g==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-10 09:27:58 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','10.10.2025 09:27:58','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"9EIjzzhlWuIk+8FOKclH/g==","Max":1,"_sonTarih":"2025-10-10T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-10 09:27:58 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:27:59 - 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" > ('10.10.2025 09:27:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:27:59 - 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" > ('10.10.2025 09:27:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:27:59 - 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" > ('10.10.2025 09:27:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:27:59 - 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" > ('10.10.2025 09:27:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:27:59 - 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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:27:59 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:27:59 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:27:59 - 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" > ('10.10.2025 09:27:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:28:00 - 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" > ('10.10.2025 09:28:00' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:28:00 - 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" > ('10.10.2025 09:28:00' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:28:00 - 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" > ('10.10.2025 09:28:00' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:28:00 - 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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:28:00 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-10 09:28:00 - 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-10 09:28:00 - 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-10 09:28:00 - 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-10 09:28:00 - 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-10 09:28:00 - 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-10 09:28:00 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-10 09:28:01 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:28:01 - UPDATE "UygulamaVersiyon"  SET
           "Version"='1.0.2.5',"UygulamaAdi"='OrcaERP',"BilgisayarAdi"='KKO',"GuncellemeTarihi"='10.10.2025 00:00:00',"YeniVersion"=False,"OlusturmaTarihi"='10.10.2025 06:23:20',"Durum"=1  WHERE "ID"=3
2025-10-10 09:28:01 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Guncelle',3,'ORCA','10.10.2025 09:28:01','Guncelle işlemi yapıldı.','KKO','{"Version":"1.0.2.5","UygulamaAdi":"OrcaERP","BilgisayarAdi":"KKO","GuncellemeTarihi":"2025-10-10T00:00:00","YeniVersion":false,"ID":3,"OlusturmaTarihi":"2025-10-10T06:23:20.953272","Durum":1}') ;
2025-10-10 09:29:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:29:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:29:13 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:29:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:29:13 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:29:13 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:29:13 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:29:15 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:29:15 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:29:15 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:29:15 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:29:15 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:29:15 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:29:15 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:38:06 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:38:07 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:38:07 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:38:07 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 09:38:07 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:38:07 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:38:07 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:38:08 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:38:08 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:38:08 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-10 09:38:08 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:38:08 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:38:08 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:38:08 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 09:38:10 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-10 09:38:11 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 09:38:11 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:38:11 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 09:38:12 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='9EIjzzhlWuIk+8FOKclH/g==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-10 09:38:12 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','10.10.2025 09:38:12','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"9EIjzzhlWuIk+8FOKclH/g==","Max":1,"_sonTarih":"2025-10-10T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-10 09:38:12 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:38: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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:38: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-10 09:38:13 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:38:13 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:38: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" > ('10.10.2025 09:38:13' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 09:38: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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 09:38: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-10 09:38: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-10 09:38: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-10 09:38: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-10 09:38: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-10 09:38: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-10 09:38:14 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-10 09:38:18 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-10-10 09:38:18 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:38:20 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = 'A101 - BİM - ŞOK - CARFOURSA - MİGROS' )   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'VERİLEN TEKLİF' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 09:38:20 - INSERT INTO "Parametreler"  
           ("OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","OlusturmaTarihi","Durum")
     VALUES
           ('VTEK',1,9,'VERİLEN TEKLİF',NULL,0,False,'10.10.2025 06:38:20',1) returning "ID"
2025-10-10 09:38:20 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Parametreler','Ekle',10,'ORCA','10.10.2025 09:38:20','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-10 09:38:20 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 5, 9) AS BIGINT)) + 1
                FROM public."SiparisTeklif"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 4) = 'VTEK'
                AND "FaturaNumarasi" SIMILAR TO 'VTEK[0-9]{9}%'
2025-10-10 09:38:20 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 09:38:20 - SELECT *,sum("Borc" - "Alacak") OVER (PARTITION BY "CariKod" ORDER BY "Tarih","Saat","FaturaNumarasi", "ID" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Bakiye" FROM "CariHareketler"  WHERE (( "CariID" = 181 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-10-10 09:38:20 - 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 "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 181 )) 
2025-10-10 09:38:20 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-10 09:38:20 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'VERİLEN TEKLİF' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridBelge' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 09:38:22 - 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 ))  AND  ( (LOWER("ST"."StokAdi"))  ilike concat('%','a','%')) GROUP BY "ST"."ID"  
2025-10-10 09:38:22 - 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-10 09:38:24 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 09:38:24 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'VERİLEN TEKLİF' ) 
2025-10-10 10:08:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 10:08:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 10:08:13 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 10:08:13 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 10:08:13 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 10:08:13 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 10:08:13 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 10:08:14 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 10:08:14 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-10 10:08:15 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-10 10:08:15 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 10:08:15 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 10:08:15 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 10:08:15 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 10:08:19 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-10 10:08:21 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 10:08:21 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 10:08:21 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 10:08:21 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='9EIjzzhlWuIk+8FOKclH/g==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-10 10:08:21 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','10.10.2025 10:08:21','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"9EIjzzhlWuIk+8FOKclH/g==","Max":1,"_sonTarih":"2025-10-10T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-10 10:08:21 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-10 10:08:22 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 10:08:22 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 10:08:22 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 10:08:22 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 10:08:22 - 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" > ('10.10.2025 10:08:22' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 10:08:23 - 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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 10:08:23 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-10 10:08:23 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 10:08:23 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-10 10:08:23 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 10:08:23 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 10:08:23 - 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" > ('10.10.2025 10:08:23' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-10 10:08:23 - 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) >= ('10.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('10.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 10:08:23 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-10 10:08:23 - 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-10 10:08:23 - 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-10 10:08:23 - 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-10 10:08:23 - 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-10 10:08:23 - 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-10 10:08:23 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-10 10:09:09 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-10-10 10:09:09 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 10:09:10 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 10:09:10 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = 'AKAY ZEYTİNCİLİK' )   LIMIT 1 offset 0
2025-10-10 10:09:10 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 10:09:10 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 10:09:10 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'VERİLEN TEKLİF' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-10 10:09:10 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 5, 9) AS BIGINT)) + 1
                FROM public."SiparisTeklif"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 4) = 'VTEK'
                AND "FaturaNumarasi" SIMILAR TO 'VTEK[0-9]{9}%'
2025-10-10 10:09:11 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 10:09:11 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 10:09:11 - SELECT *,sum("Borc" - "Alacak") OVER (PARTITION BY "CariKod" ORDER BY "Tarih","Saat","FaturaNumarasi", "ID" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Bakiye" FROM "CariHareketler"  WHERE (( "CariID" = 202 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-10-10 10:09:11 - 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 "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 202 )) 
2025-10-10 10:09:11 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-10 10:09:11 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'VERİLEN TEKLİF' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridBelge' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-10 10:09:13 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'VERİLEN TEKLİF' ) 
2025-10-10 10:09:13 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'VERİLEN TEKLİF' ) 
2025-10-10 14:38:47 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 14:38:48 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 14:38:48 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 14:38:48 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-10 14:38:48 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 14:38:48 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-10 14:38:48 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-10 14:38:49 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-10 14:38:49 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-10 14:38:49 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-10 14:38:49 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 14:38:49 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-10 14:38:49 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-10 14:38:49 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
