2025-12-15 09:40:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 09:40:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 09:40:04 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 09:40:04 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 09:40:04 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 09:40:04 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-15 09:40:04 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 09:40:05 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 09:40:05 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-15 09:40:05 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-15 09:40:05 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 09:40:05 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 09:40:05 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 09:40:05 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 09:40:08 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-15 09:40:10 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 09:40:10 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 09:40:10 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='dAmwbb56oknms/uCE7emoQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-15 09:40:10 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','15.12.2025 09:40:10','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"dAmwbb56oknms/uCE7emoQ==","Max":1,"_sonTarih":"2025-12-15T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-15 09:40:10 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-15 09:40:11 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 09:40:12 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 09:40:12 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 09:40:12 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 09:40:12 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 09:40:12 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 09:40:12 - 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-15 09:40:12 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 09:40:12 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 09:40:12 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 09:40:12 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 09:40:12 - 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" > ('15.12.2025 09:40:12' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 09:40:12 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 09:40:12 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 09:40:12 - 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-15 09:40:12 - 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-15 09:40:12 - 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-15 09:40:12 - 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-15 09:40:12 - 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-15 09:40:12 - 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-15 09:40:12 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-15 15:32:37 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 15:32:38 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 15:32:38 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 15:32:38 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 15:32:38 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 15:32:38 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-15 15:32:38 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 15:32:39 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 15:32:39 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-15 15:32:39 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-15 15:32:39 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 15:32:39 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 15:32:39 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 15:32:39 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 15:32:56 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-15 15:32:57 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 15:32:57 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 15:32:58 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='dAmwbb56oknms/uCE7emoQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-15 15:32:58 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','15.12.2025 15:32:58','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"dAmwbb56oknms/uCE7emoQ==","Max":1,"_sonTarih":"2025-12-15T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-15 15:32:58 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-15 15:32:58 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 15:32:58 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 15:32:58 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 15:32:58 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 15:32:58 - 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" > ('15.12.2025 15:32:58' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 15:32:58 - 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" > ('15.12.2025 15:32:58' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 15:32:58 - 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" > ('15.12.2025 15:32:58' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 15:32:58 - 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" > ('15.12.2025 15:32:58' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 15:32:58 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 15:32:58 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 15:32:59 - 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-15 15:32:59 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 15:32:59 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 15:32:59 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 15:32:59 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 15:32:59 - 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" > ('15.12.2025 15:32:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 15:32:59 - 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" > ('15.12.2025 15:32:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 15:32:59 - 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" > ('15.12.2025 15:32:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 15:32:59 - SELECT "CariKod","CariAdi","Tarih","Saat","FaturaNumarasi","Borc","Alacak","Aciklama","DovizBirimi","DovizKuru","BelgeTuru","IslemTuru","FirmaID","SubeID","CariID","KullaniciID","BelgeID","HareketID","Sube","Kasa","Islendi","ID","OlusturmaTarihi","Durum" FROM "CariHareketler"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('15.12.2025 15:32:59' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 15:32:59 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 15:32:59 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 15:32:59 - 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-15 15:32:59 - 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-15 15:32:59 - 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-15 15:32:59 - 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-15 15:32:59 - 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-15 15:32:59 - 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-15 15:32:59 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-15 17:27:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:27:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:27:39 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:27:39 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:27:39 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:27:39 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-15 17:27:39 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 17:27:41 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:27:41 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-15 17:27:41 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-15 17:27:41 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:27:41 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 17:27:41 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:27:41 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 17:27:43 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-15 17:27:44 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:27:44 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 17:27:45 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='dAmwbb56oknms/uCE7emoQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-15 17:27:45 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','15.12.2025 17:27:45','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"dAmwbb56oknms/uCE7emoQ==","Max":1,"_sonTarih":"2025-12-15T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-15 17:27:45 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-15 17:27:46 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:27:46 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:27:46 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:27:46 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:27:46 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:27:46 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 17:27:46 - 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-15 17:27:46 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:27:46 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:27:46 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:27:46 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:27:46 - 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" > ('15.12.2025 17:27:46' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:27:46 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:27:46 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 17:27:46 - 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-15 17:27:47 - 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-15 17:27:47 - 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-15 17:27:47 - 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-15 17:27:47 - 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-15 17:27:47 - 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-15 17:27:47 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-15 17:58:38 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:58:38 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:58:38 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`ButonBolum`,`Cekmece`,`ResimGoster`,`CekmeceYol`,`KasaID` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:58:38 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-12-15 17:58:38 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:58:38 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-12-15 17:58:38 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 17:58:39 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:58:39 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-12-15 17:58:39 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-12-15 17:58:39 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:58:39 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 17:58:39 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:58:39 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-12-15 17:58:41 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-12-15 17:58:42 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-12-15 17:58:42 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-12-15 17:58:43 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=',"Key"='688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8',"Details"='',"ExDetails"='dAmwbb56oknms/uCE7emoQ==',"Max"=1,"OlusturmaTarihi"='10.11.2025 22:20:50',"Durum"=1  WHERE "ID"=2
2025-12-15 17:58:43 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',2,'ORCA','15.12.2025 17:58:43','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"26BEy/frkGyKUg0p6Oh0Kcq7/k60T36q6r9QUWNfu+o=","Key":"688105D3FCF9B0137B4932283CF78A57B9C6CB983C73A8E15DB4F4CFC616D6C8","Details":"","ExDetails":"dAmwbb56oknms/uCE7emoQ==","Max":1,"_sonTarih":"2025-12-15T00:00:00","ID":2,"OlusturmaTarihi":"2025-11-10T22:20:50.411973","Durum":1}') ;
2025-12-15 17:58:43 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 2 )
2025-12-15 17:58:44 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:58:44 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:58:44 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:58:44 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:58:44 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:58:44 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 17:58:44 - 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-15 17:58:44 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:58:44 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-12-15 17:58:44 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:58:44 - SELECT SUM("GenelToplam") FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Satış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'Alış Faturası' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:58:44 - 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" > ('15.12.2025 17:58:44' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'Pos' )) 
2025-12-15 17:58:44 - 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) >= ('15.12.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('15.12.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-12-15 17:58:44 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-12-15 17:58:44 - 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-15 17:58:44 - 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-15 17:58:44 - 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-15 17:58:44 - 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-15 17:58:44 - 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-15 17:58:44 - 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-15 17:58:44 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-12-15 17:58:59 - WITH FiltreVerisi AS (
  SELECT MIN("Tarih") mintarih, MAX("Tarih") maxtarih 
  FROM "StokHareketleri" sh
  LEFT JOIN "StokKartlari" sk ON sh."StokID" = sk."ID" 
   WHERE sh."FirmaID" = 1
),

girenler AS (
  SELECT
    sh."StokID",
    SUM(COALESCE(sh."Giren", 0)) AS toplam_girdi_miktari,
    SUM(
      COALESCE(sh."Giren", 0) *
      COALESCE(NULLIF(sh."NetFiyat", 0), sh."Fiyat", 0)
    ) AS toplam_girdi_maliyeti
  FROM "StokHareketleri" sh
  CROSS JOIN FiltreVerisi f
  WHERE sh."Tarih" BETWEEN f.mintarih AND f.maxtarih and sh."BelgeTurleri" IN ('Alış Faturası','Stok Giriş Fişi','Alış İrsaliyesi','Peşin Alış Faturası')
  GROUP BY sh."StokID"
),

cikanlar AS (
  SELECT
    sh."StokID",
    SUM(COALESCE(sh."Cikan", 0)) AS toplam_cikis_miktari,
    SUM(COALESCE(sh."ToplamDahil", 0)) AS toplam_gelir_dahil,
    SUM(COALESCE(sh."ToplamHaric", 0)) AS toplam_gelir_haric
  FROM "StokHareketleri" sh
  CROSS JOIN FiltreVerisi f
  WHERE sh."Tarih" BETWEEN f.mintarih AND f.maxtarih and sh."BelgeTurleri" IN ('Satış Faturası','Stok Çıkış Fişi','Satış İrsaliyesi','Peşin Satış Faturası','Pos')
  GROUP BY sh."StokID"
)

SELECT
  sk."StokKodu"                                  AS stok_kodu,
  sk."StokAdi"                                   AS stok_adi,
  sk."StokGrubu"                                 AS stok_grup,
  c.toplam_cikis_miktari                         AS toplam_cikis_miktari,
  ROUND(c.toplam_gelir_dahil,2)                  AS toplam_gelir_dahil,
  ROUND(c.toplam_gelir_haric,2)                  AS toplam_gelir_haric,
  ROUND(COALESCE(g.toplam_girdi_maliyeti, 0),2)  AS toplam_girdi_maliyeti,
  ROUND(COALESCE(g.toplam_girdi_miktari, 0),2)   AS toplam_girdi_miktari,
  ROUND(CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
       ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END
  ,2)  AS ortalama_birim_maliyet,
  ROUND((CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
        ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END) * c.toplam_cikis_miktari
  ,2)  AS tahmini_toplam_maliyet,
  ROUND(c.toplam_gelir_dahil - (
    (CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
          ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END) * c.toplam_cikis_miktari) 
  ,2)  AS kard,
  ROUND(c.toplam_gelir_haric - (
    (CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
          ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END) * c.toplam_cikis_miktari) 
  ,2)  AS karh,
  ROUND(CASE WHEN c.toplam_cikis_miktari = 0 THEN NULL
       ELSE (c.toplam_gelir_dahil - (
            (CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
                  ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END) * c.toplam_cikis_miktari
           )) / c.toplam_cikis_miktari END 
  ,2)  AS birim_basi_kar_dahil,
  ROUND(CASE WHEN c.toplam_cikis_miktari = 0 THEN NULL
       ELSE (c.toplam_gelir_haric - (
            (CASE WHEN COALESCE(g.toplam_girdi_miktari,0) = 0 THEN 0
                  ELSE (g.toplam_girdi_maliyeti / g.toplam_girdi_miktari) END) * c.toplam_cikis_miktari
           )) / c.toplam_cikis_miktari END 
,2)   AS birim_basi_kar_haric
FROM cikanlar c
LEFT JOIN girenler g ON g."StokID" = c."StokID"
LEFT JOIN "StokKartlari" sk ON sk."ID" = c."StokID"
where c.toplam_cikis_miktari>0
ORDER BY stok_kodu  DESC;
