2025-12-19 09:29:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 09:29:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 09:29:04 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 09:29:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 09:29:04 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 09:29:04 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 09:29:04 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 09:29:05 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 09:29:05 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-19 09:29:05 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-19 09:29:06 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 09:29:06 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 09:29:06 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 09:29:06 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 09:29:09 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankahareketleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarthareketleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarttanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankaposhareketleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankapostanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankatanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'barkodlar' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'birimtanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihareketler' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihesaplar' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ceksenethareketleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotransfer' 
2025-12-19 09:29:09 - ALTER TABLE "DepoTransfer" ADD COLUMN "CikisDepoID" INTEGER  
2025-12-19 09:29:09 - ALTER TABLE "DepoTransfer" ADD COLUMN "GirisDepoID" INTEGER  
2025-12-19 09:29:09 - ALTER TABLE "DepoTransfer" DROP COLUMN "KaynakDepoID" CASCADE;
2025-12-19 09:29:09 - ALTER TABLE "DepoTransfer" DROP COLUMN "HedefDepoID" CASCADE;
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotransferhareketleri' 
2025-12-19 09:29:09 - ALTER TABLE "DepoTransferHareketleri" DROP COLUMN "DepoID" CASCADE;
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dizaynlar' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dokumanlar' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'donemtanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumalias' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusummukellefler' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumtanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fatura' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'faturahareketleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatipleri' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fiyattanimlari' 
2025-12-19 09:29:09 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'gridgorunumler' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasahareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasatanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kdvdepartman' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kullanicilar' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'lisanstanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'masatanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'notlar' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odeme' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odemehareket' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'logtanim' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklif' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklifhareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'terazikodtanim' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ortakveri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ozelkodtanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'parametreler' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'personelhareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'personeltanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'posterazitanim' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'projekodtanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklet' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklethareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayim' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayimdetaylari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'serinotanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokfiyatlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokgruplari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokhareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokkartlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'subetanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'urunfiyattablosu' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'uygulamaversiyon' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarthareketleri' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarttanimlari' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ilceler' 
2025-12-19 09:29:10 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'iller' 
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "FirmaTanimlari"  
2025-12-19 09:29:10 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "KdvDepartman"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "CariKodu" = '99.99.99.00099' ) 
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "StokGruplari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "BankaTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "BankaPosTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "BankaKartTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "YemekKartTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "Kullanicilar"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "iLler"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "iLceler"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "FirmaTipleri"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "BirimTanimlari"  
2025-12-19 09:29:10 - SELECT COUNT(1) FROM "TeraziKodTanim"  
2025-12-19 09:29:10 - UPDATE public."BankaHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaKartHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaKartHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaKartHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaKartHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaPosHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaPosHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaPosHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaPosHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaPosTanimlari" set "SubeAdi" =INITCAP("SubeAdi");
UPDATE public."BankaTanimlari" set "SubeAdi" =INITCAP("SubeAdi");

UPDATE public."BirimTanimlari" set "BirimAdi" =INITCAP("BirimAdi");

UPDATE public."CariHareketler" set "Sube"=INITCAP("Sube");
UPDATE public."CariHareketler" set "Kasa"=INITCAP("Kasa");
UPDATE public."CariHareketler" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."CariHareketler" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."CariHesaplar" set "CariFirmaTipi"=INITCAP("CariFirmaTipi");

UPDATE public."CekSenetHareketleri" set "Islem"=INITCAP("Islem");
UPDATE public."CekSenetHareketleri" set "OdemeTuru"=INITCAP("OdemeTuru");

UPDATE public."DepoTanimlari" set "DepoTanimi" =INITCAP("DepoTanimi");

UPDATE public."Fatura" set "Sube"=INITCAP("Sube");
UPDATE public."Fatura" set "Kasa"=INITCAP("Kasa");
UPDATE public."Fatura" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."FaturaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
UPDATE public."FaturaHareketleri" set "Birim"=INITCAP("Birim");

UPDATE public."FirmaTipleri" set "Aciklama"=INITCAP("Aciklama");

UPDATE public."KasaHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."KasaHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."KasaHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."KasaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."KasaTanimlari" set "SubeTanimi"=INITCAP("SubeTanimi");
UPDATE public."KasaTanimlari" set "KasaTanimi"=INITCAP("KasaTanimi");

UPDATE public."Odeme" set "Sube"=INITCAP("Sube");
UPDATE public."Odeme" set "Kasa"=INITCAP("Kasa");
UPDATE public."Odeme" set "Islem"=INITCAP("Islem");
UPDATE public."Odeme" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."OdemeHareket" set "OdemeTuru"=INITCAP("OdemeTuru");
UPDATE public."OdemeHareket" set "Islem"=INITCAP("Islem");
UPDATE public."OdemeHareket" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."Parametreler" set "Tur"=INITCAP("Tur");

UPDATE public."PosTeraziTanim" set "SubeAdi"=INITCAP("SubeAdi");
UPDATE public."PosTeraziTanim" set "KasaAdi"=INITCAP("KasaAdi");

UPDATE public."SatisBekletHareketleri" set "Birim"=INITCAP("Birim");
UPDATE public."SatisBekletHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."Sayim" set "DepoAdi"=INITCAP("DepoAdi");

UPDATE public."SayimDetaylari" set "Birim"=INITCAP("Birim");

UPDATE public."SiparisTeklif" set "Sube"=INITCAP("Sube");
UPDATE public."SiparisTeklif" set "Kasa"=INITCAP("Kasa");
UPDATE public."SiparisTeklif" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."SiparisTeklifHareketleri" set "Birim"=INITCAP("Birim");
UPDATE public."SiparisTeklifHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."StokHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
UPDATE public."StokHareketleri" set "Birim"=INITCAP("Birim");

UPDATE public."StokKartlari" set "Birim"=INITCAP("Birim");

UPDATE public."SubeTanimlari" set "SubeAdi"=INITCAP("SubeAdi");
UPDATE public."SubeTanimlari" set "SubeTanimi"=INITCAP("SubeTanimi");

UPDATE public."YemekKartHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."YemekKartHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."YemekKartHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."YemekKartHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
2025-12-19 09:29:10 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 09:29:10 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 09:29:13 - SELECT "FirmaID","SubeID","DepoTanimi","SubeTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:15 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 09:29:15 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 09:29:15 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='y6PmL9RJu7B4ODv191/TQQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-19 09:29:15 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','19.12.2025 09:29:15','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"y6PmL9RJu7B4ODv191/TQQ==","Max":1,"_sonTarih":"2025-12-19T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-19 09:29:15 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-19 09:29:16 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 09:29:16 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 09:29:16 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 09:29:16 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:16 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 09:29:16 - 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" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 09:29:16 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 09:29:16 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 09:29:16 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 09:29:16 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 09:29:16 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 09:29:16 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:16 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 09:29:16 - 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" > ('19.12.2025 09:29:16' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 09:29:16 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 09:29:16 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 09:29:16 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 09:29:16 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:16 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:16 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:16 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:16 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:16 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-19 09:29:20 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-12-19 09:29:20 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:23 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-12-19 09:29:23 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:24 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:24 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29: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 (( "CariID" = 93 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-12-19 09:29:24 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 93 )) 
2025-12-19 09:29:28 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","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" = '2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ' )   LIMIT 1 offset 0
2025-12-19 09:29:28 - SELECT "FirmaID","SubeID","DepoTanimi","SubeTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:28 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:28 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'Alış Faturası' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:28 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 5, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 4) = 'AFAT'
                AND "FaturaNumarasi" SIMILAR TO 'AFAT[0-9]{9}%'
2025-12-19 09:29:28 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-12-19 09:29:28 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'Alış Faturası' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridBelge' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:31 - SELECT "st".*,coalesce( "et"."Envanter",0) as "Envanter" FROM "StokKartlari" "st" Left JOIN (SELECT  "StokID" AS "StokID" , "FirmaID" AS "FirmaID" , (SUM("Giren") -SUM("Cikan")) AS "Envanter"  FROM "StokHareketleri" "x"  WHERE ( "FirmaID" = 1 )GROUP BY "StokID","FirmaID"  ) "et"  ON ( "st"."ID" = "et"."StokID" )   WHERE ((( "st"."FirmaID" = 1 ) OR ( "st"."FirmalarOrtakStok" = 1 )) AND ( "st"."Durum" = 1 ))  AND  ("st"."StokAdi" ilike concat('%','a','%')) ORDER BY "st"."StokAdi" 
2025-12-19 09:29:31 - 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-12-19 09:29:35 - SELECT COUNT(1) FROM "Fatura"  WHERE ((((( "Durum" = 1 ) AND ( "ID" <> 0 )) AND ( "FaturaNumarasi" = 'AFAT000000001' )) AND ( "CariID" = 93 )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:35 - INSERT INTO "Fatura"  
           ("FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","OlusturmaTarihi","Durum")
     VALUES
           (1,1,93,1,1,'Merkez','Merkez','','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','1.01.1900 00:00:00','19.12.2025 00:00:00','09:29:28','AFAT000000001','TL',1,38,65,0,00,38,65,2,43,41,08,0,0,'Alış Faturası',NULL,NULL,NULL,NULL,NULL,False,False,NULL,False,'db72c767-7872-41d4-9a37-c298b076b09d',0,NULL,'19.12.2025 09:29:28',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Fatura','Ekle',6,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "CariHareketler"  
           ("CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","OlusturmaTarihi","Durum")
     VALUES
           ('2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','19.12.2025 00:00:00','09:29:28','AFAT000000001',0,41,08,'','TL',1,'Alış Faturası',NULL,1,1,93,1,6,0,'Merkez','Merkez',False,'19.12.2025 09:29:28',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('CariHareketler','Ekle',123,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","BirimAdet","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('AFAT000000001',1,1,1,1,'19.12.2025 00:00:00','09:29:28',2275,'8682466438706','502 YAPIŞTIRICI ORJINAL','Adet','Adet'Adet,'8682466438706',22,72730000,25,000030000,25,003,40,00,0,0,0,0,0,0,25,0000300000,25,0000300001,25,0000300002,25,0000300003,25,0000300004,25,0000300005,25,0000300006,25,0000300007,'TL',25,0000300008,'ALIS','1.01.1900 00:00:00','','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','Alış Faturası',1,6,93,'19.12.2025 09:29:33',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',18,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","BirimAdet","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('AFAT000000001',1,1,1,1,'19.12.2025 00:00:00','09:29:28',312,'5201360539024','7 DAYS FINDIK 72GR','Adet','Adet'Adet,'5201360539024',8,00000800,8,0800080800,8,0800,54,70,0,0,0,0,0,0,8,08000808000,8,08000808001,8,08000808002,8,08000808003,8,08000808004,8,08000808005,8,08000808006,8,08000808007,'TL',8,08000808008,'ALIS','1.01.1900 00:00:00','','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','Alış Faturası',1,6,93,'19.12.2025 09:29:33',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',19,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "FaturaHareketleri"  
           ("FaturaNumarasi","FirmaID","SubeID","DepoID","KullaniciID","Tarih","Saat","StokID","StokKodu","StokAdi","Birim","BirimAdet","Barkod","BirimFiyat","BirimFiyatDahil","NetFiyatDahil","SatisKar","Isk1","Isk2","Isk3","Isk4","Isk5","Isk6","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","ParaBirimi","DovizKuru","SatisSekli","VadeTarihi","Aciklama","CariKodu","CariAdi","BelgeTuru","SNo","BelgeID","CariID","OlusturmaTarihi","Durum")
     VALUES
           ('AFAT000000001',1,1,1,1,'19.12.2025 00:00:00','09:29:28',1438,'5201360539253','7 DAYS KAKAOLU 72GR','Adet','Adet'Adet,'5201360539253',7,92080000,8,0000080000,7,9992,56,25,0,0,0,0,0,0,8,00000800000,8,00000800001,8,00000800002,8,00000800003,8,00000800004,8,00000800005,8,00000800006,8,00000800007,'TL',8,00000800008,'ALIS','1.01.1900 00:00:00','','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','Alış Faturası',1,6,93,'19.12.2025 09:29:33',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('FaturaHareketleri','Ekle',20,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ( "BelgeID" = 6 ) 
2025-12-19 09:29:35 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,93,18,'Alış Faturası','AFAT000000001','19.12.2025 00:00:00','09:29:28',2275,'2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','8682466438706','502 YAPIŞTIRICI ORJINAL','Adet','Adet'Adet,1,0,'8682466438706',22,72730000,25,000030000,0,1,10,2,273,22,73,25,00,00,'TL',01,'','19.12.2025 09:29:35',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',18,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,93,19,'Alış Faturası','AFAT000000001','19.12.2025 00:00:00','09:29:28',312,'2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','5201360539024','7 DAYS FINDIK 72GR','Adet','Adet'Adet,1,0,'5201360539024',8,00000800,8,0800080800,0,1,1,0,0800,8,00,8,08,00,'TL',01,'','19.12.2025 09:29:35',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',19,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - INSERT INTO "StokHareketleri"  
           ("BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","OlusturmaTarihi","Durum")
     VALUES
           (6,1,1,1,1,93,20,'Alış Faturası','AFAT000000001','19.12.2025 00:00:00','09:29:28',1438,'2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ','5201360539253','7 DAYS KAKAOLU 72GR','Adet','Adet'Adet,1,0,'5201360539253',7,92080000,8,0000080000,0,1,1,0,0792,7,92,8,00,00,'TL',01,'','19.12.2025 09:29:35',1) returning "ID"
2025-12-19 09:29:35 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('StokHareketleri','Ekle',20,'ORCA','19.12.2025 09:29:35','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 09:29:35 - UPDATE "Fatura"  SET
            "AcikMi" = False , "AcikKullanici" = ''   WHERE ( "ID" = 6 )
2025-12-19 09:29:35 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (( "CariID" = 93 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-12-19 09:29:35 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 93 )) 
2025-12-19 09:29:38 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","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" = '2 ERSAN GIDA SANAYİ TİCARET LİMİTED ŞİRKETİ' )   LIMIT 1 offset 0
2025-12-19 09:29:38 - SELECT "FirmaID","SubeID","DepoTanimi","SubeTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:38 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:38 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'Alış Faturası' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-12-19 09:29:38 - 
                SELECT MAX(CAST(SUBSTRING("FaturaNumarasi", 5, 9) AS BIGINT)) + 1
                FROM public."Fatura"
                WHERE "FirmaID" = 1
                AND LEFT("FaturaNumarasi", 4) = 'AFAT'
                AND "FaturaNumarasi" SIMILAR TO 'AFAT[0-9]{9}%'
2025-12-19 09:29:38 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-12-19 09:29:38 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'Alış Faturası' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridBelge' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:29:43 - SELECT "st".*,coalesce( "et"."Envanter",0) as "Envanter" FROM "StokKartlari" "st" Left JOIN (SELECT  "StokID" AS "StokID" , "FirmaID" AS "FirmaID" , (SUM("Giren") -SUM("Cikan")) AS "Envanter"  FROM "StokHareketleri" "x"  WHERE ( "FirmaID" = 1 )GROUP BY "StokID","FirmaID"  ) "et"  ON ( "st"."ID" = "et"."StokID" )   WHERE ((( "st"."FirmaID" = 1 ) OR ( "st"."FirmalarOrtakStok" = 1 )) AND ( "st"."Durum" = 1 ))  AND  ("st"."StokAdi" ilike concat('%','a','%')) ORDER BY "st"."StokAdi" 
2025-12-19 09:29:43 - 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-12-19 09:29:46 - SELECT COUNT(1) FROM "Fatura"  WHERE ((((( "Durum" = 1 ) AND ( "ID" <> 0 )) AND ( "FaturaNumarasi" = 'AFAT000000001' )) AND ( "CariID" = 93 )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 09:29:54 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim2Carpan","Birim2Fiyat","Birim2Barkod","Birim3","Birim3Carpan","Birim3Fiyat","Birim3Barkod","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE ( "ID" = 2275 )   LIMIT 1 offset 0
2025-12-19 09:29:54 - SELECT "DepoTanimi",(SELECT SUM("Giren"-"Cikan") FROM "StokHareketleri" WHERE "DepoID"="DP"."ID" AND "StokID"=2275) AS "Envanter" FROM "DepoTanimlari" AS "DP"
2025-12-19 09:29:54 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ((( "StokID" = 2275 ) AND ( "FirmaID" = 1 )) AND ( "Durum" = 1 )) 
2025-12-19 09:29:54 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliStokDuzenle' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeHareket' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:30:06 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim2Carpan","Birim2Fiyat","Birim2Barkod","Birim3","Birim3Carpan","Birim3Fiyat","Birim3Barkod","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE ( "ID" = 1438 )   LIMIT 1 offset 0
2025-12-19 09:30:06 - SELECT "DepoTanimi",(SELECT SUM("Giren"-"Cikan") FROM "StokHareketleri" WHERE "DepoID"="DP"."ID" AND "StokID"=1438) AS "Envanter" FROM "DepoTanimlari" AS "DP"
2025-12-19 09:30:06 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ((( "StokID" = 1438 ) AND ( "FirmaID" = 1 )) AND ( "Durum" = 1 )) 
2025-12-19 09:30:06 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliStokDuzenle' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeHareket' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 09:30:11 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim2Carpan","Birim2Fiyat","Birim2Barkod","Birim3","Birim3Carpan","Birim3Fiyat","Birim3Barkod","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE ( "ID" = 1438 )   LIMIT 1 offset 0
2025-12-19 09:30:11 - UPDATE "StokKartlari"  SET
            "AlisFiyati" = 8   WHERE ( "ID" = 1438 )
2025-12-19 09:30:13 - SELECT "FirmaID","FirmalarOrtakStok","StokKodu","StokAdi","StokGrubu","Birim","Marka","Beden","Model","Renk","Barkod","AlisFiyati","SatisFiyati","KDV","AlisKDV","KDVDahil","KDVKisimID","WebEntegrasyon","Aciklama","TeknikOzellikler","OTV","TevkifatOrani","StokTuru","RafOmru","Birim2","Birim2Carpan","Birim2Fiyat","Birim2Barkod","Birim3","Birim3Carpan","Birim3Fiyat","Birim3Barkod","TeraziGrubu","TeraziTusu","En","Boy","Yukseklik","Agirlik","ProjeKodu","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","MinimumStokMiktari","MaximumStokMiktari","Mensei","SonKullanimTarihi","ID","OlusturmaTarihi","Durum" FROM "StokKartlari"   WHERE ( "ID" = 1438 )   LIMIT 1 offset 0
2025-12-19 09:30:13 - SELECT "DepoTanimi",(SELECT SUM("Giren"-"Cikan") FROM "StokHareketleri" WHERE "DepoID"="DP"."ID" AND "StokID"=1438) AS "Envanter" FROM "DepoTanimlari" AS "DP"
2025-12-19 09:30:13 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE ((( "StokID" = 1438 ) AND ( "FirmaID" = 1 )) AND ( "Durum" = 1 )) 
2025-12-19 09:30:13 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmHizliStokDuzenle' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeHareket' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:15:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:15:19 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:15:19 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:15:19 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:15:19 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 11:15:19 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:15:20 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankahareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarthareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankakarttanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankaposhareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankapostanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'bankatanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'barkodlar' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'birimtanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihareketler' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'carihesaplar' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ceksenethareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotransfer' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'depotransferhareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dizaynlar' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'dokumanlar' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'donemtanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumalias' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusummukellefler' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'edonusumtanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fatura' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'faturahareketleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'firmatipleri' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'fiyattanimlari' 
2025-12-19 11:15:20 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'gridgorunumler' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasahareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kasatanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kdvdepartman' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'kullanicilar' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'lisanstanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'masatanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'notlar' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odeme' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'odemehareket' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'logtanim' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklif' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'siparisteklifhareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'terazikodtanim' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ortakveri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ozelkodtanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'parametreler' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'personelhareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'personeltanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'posterazitanim' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'projekodtanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklet' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'satisbeklethareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayim' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'sayimdetaylari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'serinotanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokfiyatlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokgruplari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokhareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'stokkartlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'subetanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'urunfiyattablosu' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'uygulamaversiyon' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarthareketleri' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'yemekkarttanimlari' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'ilceler' 
2025-12-19 11:15:21 -  SELECT 1 FROM pg_catalog.pg_tables 
    WHERE schemaname = 'public' 
    AND Lower(tablename) = 'iller' 
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "FirmaTanimlari"  
2025-12-19 11:15:21 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "KdvDepartman"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "CariKodu" = '99.99.99.00099' ) 
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "StokGruplari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "BankaTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "BankaPosTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "BankaKartTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "YemekKartTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "Kullanicilar"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "iLler"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "iLceler"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "FirmaTipleri"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "BirimTanimlari"  
2025-12-19 11:15:21 - SELECT COUNT(1) FROM "TeraziKodTanim"  
2025-12-19 11:15:21 - UPDATE public."BankaHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaKartHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaKartHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaKartHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaKartHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaPosHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."BankaPosHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."BankaPosHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."BankaPosHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."BankaPosTanimlari" set "SubeAdi" =INITCAP("SubeAdi");
UPDATE public."BankaTanimlari" set "SubeAdi" =INITCAP("SubeAdi");

UPDATE public."BirimTanimlari" set "BirimAdi" =INITCAP("BirimAdi");

UPDATE public."CariHareketler" set "Sube"=INITCAP("Sube");
UPDATE public."CariHareketler" set "Kasa"=INITCAP("Kasa");
UPDATE public."CariHareketler" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."CariHareketler" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."CariHesaplar" set "CariFirmaTipi"=INITCAP("CariFirmaTipi");

UPDATE public."CekSenetHareketleri" set "Islem"=INITCAP("Islem");
UPDATE public."CekSenetHareketleri" set "OdemeTuru"=INITCAP("OdemeTuru");

UPDATE public."DepoTanimlari" set "DepoTanimi" =INITCAP("DepoTanimi");

UPDATE public."Fatura" set "Sube"=INITCAP("Sube");
UPDATE public."Fatura" set "Kasa"=INITCAP("Kasa");
UPDATE public."Fatura" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."FaturaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
UPDATE public."FaturaHareketleri" set "Birim"=INITCAP("Birim");

UPDATE public."FirmaTipleri" set "Aciklama"=INITCAP("Aciklama");

UPDATE public."KasaHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."KasaHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."KasaHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."KasaHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."KasaTanimlari" set "SubeTanimi"=INITCAP("SubeTanimi");
UPDATE public."KasaTanimlari" set "KasaTanimi"=INITCAP("KasaTanimi");

UPDATE public."Odeme" set "Sube"=INITCAP("Sube");
UPDATE public."Odeme" set "Kasa"=INITCAP("Kasa");
UPDATE public."Odeme" set "Islem"=INITCAP("Islem");
UPDATE public."Odeme" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."OdemeHareket" set "OdemeTuru"=INITCAP("OdemeTuru");
UPDATE public."OdemeHareket" set "Islem"=INITCAP("Islem");
UPDATE public."OdemeHareket" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."Parametreler" set "Tur"=INITCAP("Tur");

UPDATE public."PosTeraziTanim" set "SubeAdi"=INITCAP("SubeAdi");
UPDATE public."PosTeraziTanim" set "KasaAdi"=INITCAP("KasaAdi");

UPDATE public."SatisBekletHareketleri" set "Birim"=INITCAP("Birim");
UPDATE public."SatisBekletHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."Sayim" set "DepoAdi"=INITCAP("DepoAdi");

UPDATE public."SayimDetaylari" set "Birim"=INITCAP("Birim");

UPDATE public."SiparisTeklif" set "Sube"=INITCAP("Sube");
UPDATE public."SiparisTeklif" set "Kasa"=INITCAP("Kasa");
UPDATE public."SiparisTeklif" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."SiparisTeklifHareketleri" set "Birim"=INITCAP("Birim");
UPDATE public."SiparisTeklifHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");

UPDATE public."StokHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
UPDATE public."StokHareketleri" set "Birim"=INITCAP("Birim");

UPDATE public."StokKartlari" set "Birim"=INITCAP("Birim");

UPDATE public."SubeTanimlari" set "SubeAdi"=INITCAP("SubeAdi");
UPDATE public."SubeTanimlari" set "SubeTanimi"=INITCAP("SubeTanimi");

UPDATE public."YemekKartHareketleri" set "Sube"=INITCAP("Sube");
UPDATE public."YemekKartHareketleri" set "Kasa"=INITCAP("Kasa");
UPDATE public."YemekKartHareketleri" set "IslemTuru"=INITCAP("IslemTuru");
UPDATE public."YemekKartHareketleri" set "BelgeTuru"=INITCAP("BelgeTuru");
2025-12-19 11:15:21 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:15:21 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:15:21 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"  WHERE (( "ID" > 0 ) AND ( "BilgisayarAdi" = 'KKO' )) 
2025-12-19 11:15:21 - DELETE FROM "UygulamaVersiyon" WHERE (( "ID" > 0 ) AND ( "BilgisayarAdi" = 'KKO' )) 
2025-12-19 11:15:21 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Sil',5,'Bilinmiyor','19.12.2025 11:15:21','Sil işlemi yapıldı.','KKO','{"Version":"1.0.2.9","UygulamaAdi":"OrcaERP","BilgisayarAdi":"KKO","GuncellemeTarihi":"2025-12-09T00:00:00","YeniVersion":false,"ID":5,"OlusturmaTarihi":"2025-12-09T14:18:32.388179","Durum":1}') ;
2025-12-19 11:15:21 - INSERT INTO "UygulamaVersiyon"  
           ("Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","OlusturmaTarihi","Durum")
     VALUES
           ('1.0.3.0','OrcaERP','KKO','19.12.2025 00:00:00',True,'19.12.2025 11:15:21',1) returning "ID"
2025-12-19 11:15:21 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Ekle',6,'Bilinmiyor','19.12.2025 11:15:21','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-12-19 11:15:22 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:15:22 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:15:22 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:15:22 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:15:22 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 11:15:22 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:15:22 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 11:15:26 - SELECT "FirmaID","SubeID","DepoTanimi","SubeTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-19 11:15:27 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:15:27 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:15:28 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='y6PmL9RJu7B4ODv191/TQQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-19 11:15:28 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','19.12.2025 11:15:28','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"y6PmL9RJu7B4ODv191/TQQ==","Max":1,"_sonTarih":"2025-12-19T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-19 11:15:28 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-19 11:15:29 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:15:29 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:15:29 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:15:29 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:15:29 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:15:29 - 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" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:15:29 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 11:15:29 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 11:15:29 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:15:29 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:15:29 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:15:29 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:15:29 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:15:29 - 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" > ('19.12.2025 11:15:29' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:15:29 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:15:29 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 11:15:29 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 11:15:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:29 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:15:29 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-19 11:15:29 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:15:29 - UPDATE "UygulamaVersiyon"  SET
           "Version"='1.0.3.0',"UygulamaAdi"='OrcaERP',"BilgisayarAdi"='KKO',"GuncellemeTarihi"='19.12.2025 00:00:00',"YeniVersion"=False,"OlusturmaTarihi"='19.12.2025 11:15:21',"Durum"=1  WHERE "ID"=6
2025-12-19 11:15:29 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('UygulamaVersiyon','Guncelle',6,'ORCA','19.12.2025 11:15:29','Guncelle işlemi yapıldı.','KKO','{"Version":"1.0.3.0","UygulamaAdi":"OrcaERP","BilgisayarAdi":"KKO","GuncellemeTarihi":"2025-12-19T00:00:00","YeniVersion":false,"ID":6,"OlusturmaTarihi":"2025-12-19T11:15:21.759765","Durum":1}') ;
2025-12-19 11:51:26 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:51:26 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:51:26 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:51:26 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:51:26 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:51:26 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 11:51:26 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:51:27 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:51:27 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:51:27 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:51:27 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:51:27 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 11:51:27 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:51:27 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 11:51:37 - SELECT "FirmaID","SubeID","DepoTanimi","SubeTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-19 11:51:38 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:51:38 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:51:38 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='y6PmL9RJu7B4ODv191/TQQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-19 11:51:38 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','19.12.2025 11:51:38','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"y6PmL9RJu7B4ODv191/TQQ==","Max":1,"_sonTarih":"2025-12-19T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-19 11:51:38 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-19 11:51:39 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:51:39 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:51:39 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:51:39 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:51:39 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:51:39 - 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" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:51:39 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 11:51:39 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 11:51:39 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:51:39 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-19 11:51:39 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:51:39 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","AltIskontoTutar","AltIskonto","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-19 11:51:39 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","BirimAdet","EvrakMiktar","Miktar","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:51:39 - 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" > ('19.12.2025 11:51:39' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-19 11:51:39 - SELECT "FirmaID","BankaID","CariID","BelgeID","HareketID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('19.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('19.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:51:39 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-19 11:51:39 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID"  
2025-12-19 11:51:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:51:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:51:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:51:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:51:39 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-12-19 11:51:39 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-19 11:53:17 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:53:17 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:53:17 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:53:17 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-19 11:53:17 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:53:17 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-19 11:53:17 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-19 11:53:18 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-19 11:53:18 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:53:18 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-19 11:53:18 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:53:18 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-19 11:53:18 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-19 11:53:18 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
