2025-10-09 14:21:08 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-09 14:21:08 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-09 14:21:08 - SELECT `ID`,`ButonBoyutu`,`TasarimBoyutu`,`YaziciAdi`,`YazarkasaModel`,`FisLimiti`,`Cekmece`,`ResimGoster`,`CekmeceYol` FROM `PosAyarlar`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-09 14:21:08 - select Name from sqlite_master where type='table' and name<>'sqlite_sequence' order by name;
2025-10-09 14:21:08 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-09 14:21:08 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:21:08 - SELECT "Version","UygulamaAdi","BilgisayarAdi","GuncellemeTarihi","YeniVersion","ID","OlusturmaTarihi","Durum" FROM "UygulamaVersiyon"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-09 14:21:09 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-09 14:21:09 - SELECT "KullaniciAdi","Sifre","AdiSoyadi","CariID","ID","OlusturmaTarihi","Durum" FROM "Kullanicilar"  WHERE ( "Durum" = 1 ) 
2025-10-09 14:21:09 - SELECT "FirmaAdi","YetkiliAdi","Telefon","Mail","VergiDairesi","VergiNo","Il","Ilce","Adres","ID","OlusturmaTarihi","Durum" FROM "FirmaTanimlari"  WHERE ( "Durum" = 1 ) 
2025-10-09 14:21:09 - SELECT "FirmaID","SubeAdi","SubeTanimi","SubeAdres","ID","OlusturmaTarihi","Durum" FROM "SubeTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-09 14:21:09 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-09 14:21:09 - SELECT "DonemAdi","DonemBaslangic","DonemBitis","FirmaID","ID","OlusturmaTarihi","Durum" FROM "DonemTanimlari"  WHERE (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-09 14:21:09 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ( "SubeID" = 1 )   LIMIT 1 offset 0
2025-10-09 14:21:11 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE (( "FirmaID" = 1 ) AND ( "SubeID" = 1 ))   LIMIT 1 offset 0
2025-10-09 14:21:13 - SELECT `ID`,`Server`,`Username`,`Password`,`DatabaseName`,`ConnectID`,`Port`,`Trusted` FROM `TblConnection`    ORDER BY DATETIME('now')    LIMIT 0,1
2025-10-09 14:21:13 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:21:13 - SELECT "SecretKey","Key","Details","ExDetails","Max","ID","OlusturmaTarihi","Durum" FROM "LisansTanimlari"   WHERE ( "Durum" = 1 )   LIMIT 1 offset 0
2025-10-09 14:21:13 - UPDATE "LisansTanimlari"  SET
           "SecretKey"='MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL',"Key"='25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7',"Details"='',"ExDetails"='n2Ybea8qcL989W2miivDoQ==',"Max"=1,"OlusturmaTarihi"='8.10.2025 07:51:23',"Durum"=1  WHERE "ID"=4
2025-10-09 14:21:13 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('LisansTanimlari','Guncelle',4,'ORCA','9.10.2025 14:21:13','Guncelle işlemi yapıldı.','KKO','{"SecretKey":"MT7h6aaQVBhXFGzmA014b9ixPUIvItLuOqhTjNVDis+9nzyJZKmIsApDjnQR1AuL","Key":"25C0DF3806FBB6B5CA97D2988AD95E3CE39F4BA83B0DA2DFC858530C6A06C4F7","Details":"","ExDetails":"n2Ybea8qcL989W2miivDoQ==","Max":1,"_sonTarih":"2025-10-09T00:00:00","ID":4,"OlusturmaTarihi":"2025-10-08T07:51:23.597562","Durum":1}') ;
2025-10-09 14:21:13 - UPDATE "LisansTanimlari"  SET
            "Max" = 1   WHERE ( "ID" = 4 )
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-09 14:21:15 - 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" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('9.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('9.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-09 14:21:15 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "CariHesaplar"  WHERE ( "FirmaID" = 1 ) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "StokKartlari"  WHERE ( "FirmaID" = 1 ) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "Fatura"  WHERE (( "FirmaID" = 1 ) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'SATIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "Fatura"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" = 'ALIŞ FATURASI' )) 
2025-10-09 14:21:15 - SELECT "BelgeID","FirmaID","SubeID","DepoID","KullaniciID","CariID","HareketID","BelgeTuru","FaturaNumarasi","Tarih","Saat","StokID","CariAdi","StokKodu","StokAdi","Birim","Barkod","Fiyat","FiyatDahil","Cikan","Giren","KDV","KDVTutari","ToplamHaric","ToplamDahil","NetFiyat","ParaBirimi","DovizKuru","Aciklama","ID","OlusturmaTarihi","Durum" FROM "StokHareketleri"  WHERE (((( "FirmaID" = 1 ) AND ( "Durum" = 1 )) AND ( "Tarih" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-09 14:21:15 - 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" > ('9.10.2025 14:21:15' +  (-7||'Day')::INTERVAL) )) AND ( "BelgeTuru" <> 'POS' )) 
2025-10-09 14:21:15 - SELECT "FirmaID","BankaID","CariID","Islem","OdemeTuru","BankaAdi","CekSenetNumarasi","CekSenetCiroAdi","KesideYeri","HesapNumarasi","CariAdi","Aciklama","Vade","Tutar","ID","OlusturmaTarihi","Durum" FROM "CekSenetHareketleri"  WHERE (  CAST("Vade" AS DATE) >= ('9.10.2025 00:00:00' +  (-7||'Day')::INTERVAL) )  AND (  CAST("Vade" AS DATE) <= ('9.10.2025 00:00:00' +  (7||'Day')::INTERVAL) )  AND (( "FirmaID" = 1 ) AND ( "Durum" = 1 )) 
2025-10-09 14:21:15 - SELECT "Tarih",SUM("GenelToplam") AS "Ciro" FROM public."Fatura" WHERE "FirmaID"='1' and "SubeID"='1' GROUP BY "Tarih" ORDER BY "Tarih" ASC
2025-10-09 14:21:15 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaAlis' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeAlis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:15 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaSaris' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeSatis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:15 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCari' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCari' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:15 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaStok' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeStok' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:15 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'AnaSayfaCekSenet' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListeCekSenet' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:15 - SELECT COUNT(1) FROM "UygulamaVersiyon"  WHERE ( "YeniVersion" = True ) 
2025-10-09 14:21:18 - SELECT "CR".*,(SUM("CH"."Borc")-SUM("CH"."Alacak")) "Bakiye" FROM "CariHesaplar" "CR" Left JOIN "CariHareketler" "CH" ON (( "CR"."ID" = "CH"."CariID" ) AND ( "CH"."FirmaID" = 1 ))   WHERE ((( "CR"."FirmaID" = 1 ) OR ( "CR"."FirmaOrtakCari" = 1 )) AND ( "CR"."Durum" = 1 ))GROUP BY "CR"."ID" ORDER BY "CR"."CariAdi" 
2025-10-09 14:21:18 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:21:19 - SELECT "CariKodu","CariAdi","Adi","Soyadi","VergiTcNo","VergiDairesi","Adres","Il","Ilce","Telefon","GSM","Mail","Referans","CariSatatusu","RiskLimiti","CekLimiti","CariFirmaTipi","OzelKod1","OzelKod2","OzelKod3","OzelKod4","OzelKod5","OzelKod6","IndirimOrani","Komisyon","WebSitesi","EMukellef","Aciklama","ProjeKodu","CariGrubu","DovizCinsi","SatisFiyatGrubu","FirmaID","FirmaOrtakCari","ID","OlusturmaTarihi","Durum" FROM "CariHesaplar"   WHERE ( "CariKodu" = 'A101 - BİM - ŞOK - CARFOURSA - MİGROS' )   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT "FirmaID","SubeID","DepoTanimi","ID","OlusturmaTarihi","Durum" FROM "DepoTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT "FirmaID","SubeID","SubeTanimi","KasaTanimi","ID","OlusturmaTarihi","Durum" FROM "KasaTanimlari"   WHERE ((( "FirmaID" = 1 ) AND ( "SubeID" = 1 )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT "OnEk","FirmaID","Uzunluk","Tur","Dizayn","BelgeTipi","BelgeMi","ID","OlusturmaTarihi","Durum" FROM "Parametreler"   WHERE ((( "FirmaID" = 1 ) AND ( "Tur" = 'ALIŞ FATURASI' )) AND ( "Durum" = 1 ))   LIMIT 1 offset 0
2025-10-09 14:21:19 - 
                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-10-09 14:21:19 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmCariHareketler' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myListesSiparis' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:19 - SELECT *,sum("Borc" - "Alacak") OVER (PARTITION BY "CariKod" ORDER BY "Tarih","Saat","FaturaNumarasi", "ID" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "Bakiye" FROM "CariHareketler"  WHERE (( "CariID" = 181 ) AND ( "FirmaID" = 1 ))ORDER BY "Tarih","Saat","FaturaNumarasi","ID" 
2025-10-09 14:21:19 - SELECT "FirmaID","SubeID","CariID","KullaniciID","DepoID","Sube","Kasa","Aciklama","CariKodu","CariAdi","VadeTarih","Tarih","Saat","FaturaNumarasi","DovizBirimi","DovizKuru","Tutar","IndirimTutar","AraTutar","KDVTutar","GenelToplam","BelgeTuru","IptalSebebi","FaturaKod1","FaturaKod2","FaturaKod3","ProjeKodu","Yazdirildi","AcikMi","AcikKullanici","Donusum","ETTN","EDurum","EFaturaNumarasi","ID","OlusturmaTarihi","Durum" FROM "SiparisTeklif"  WHERE ((( "Durum" = 1 ) AND ( "FirmaID" = 1 )) AND ( "CariID" = 181 )) 
2025-10-09 14:21:19 - SELECT "Kod","Barkod","Kg","Gr","ID","OlusturmaTarihi","Durum" FROM "TeraziKodTanim"  
2025-10-09 14:21:19 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'ALIŞ FATURASI' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridBelge' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:20 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))  AND  ( (LOWER("B"."Barkod"))  ilike concat('%','a','%')) GROUP BY "ST"."ID"  
2025-10-09 14:21:23 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))  AND  ( (LOWER("ST"."StokAdi"))  ilike concat('%','a','%')) GROUP BY "ST"."ID"  
2025-10-09 14:21:23 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:21:25 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:21:25 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'ALIŞ FATURASI' ) 
2025-10-09 14:21:25 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'ALIŞ FATURASI' ) 
2025-10-09 14:22:02 - INSERT INTO "Dizaynlar"  
           ("Ad","KullaniciID","XmlDizayn","Modul","OlusturmaTarihi","Durum")
     VALUES
           ('ALIŞ FATURASI',0,'<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="08/14/2025 11:19:05" ReportInfo.Modified="10/09/2025 14:22:02" ReportInfo.CreatorVersion="2024.2.8.0">
  <Dictionary>
    <BusinessObjectDataSource Name="Genel" ReferenceName="Genel" DataType="System.Collections.Generic.List`1[[Orca.Data.FirmaTanimlari, Orca.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]" Enabled="true">
      <Column Name="FirmaAdi" DataType="System.String"/>
      <Column Name="YetkiliAdi" DataType="System.String"/>
      <Column Name="Telefon" DataType="System.String"/>
      <Column Name="Mail" DataType="System.String"/>
      <Column Name="VergiDairesi" DataType="System.String"/>
      <Column Name="VergiNo" DataType="System.String"/>
      <Column Name="Il" DataType="System.String"/>
      <Column Name="Ilce" DataType="System.String"/>
      <Column Name="Adres" DataType="System.String"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
    </BusinessObjectDataSource>
    <TableDataSource Name="Fatura" ReferenceName="RaporVerisi.Fatura" DataType="System.Int32" Enabled="true">
      <Column Name="FirmaID" DataType="System.Int32"/>
      <Column Name="SubeID" DataType="System.Int32"/>
      <Column Name="CariID" DataType="System.Int32"/>
      <Column Name="KullaniciID" DataType="System.Int32"/>
      <Column Name="DepoID" DataType="System.Int32"/>
      <Column Name="Sube" DataType="System.String"/>
      <Column Name="Kasa" DataType="System.String"/>
      <Column Name="Aciklama" DataType="System.String"/>
      <Column Name="CariKodu" DataType="System.String"/>
      <Column Name="CariAdi" DataType="System.String"/>
      <Column Name="VadeTarih" DataType="System.DateTime"/>
      <Column Name="Tarih" DataType="System.DateTime"/>
      <Column Name="Saat" DataType="System.String"/>
      <Column Name="FaturaNumarasi" DataType="System.String"/>
      <Column Name="DovizBirimi" DataType="System.String"/>
      <Column Name="DovizKuru" DataType="System.Decimal"/>
      <Column Name="Tutar" DataType="System.Decimal"/>
      <Column Name="IndirimTutar" DataType="System.Decimal"/>
      <Column Name="AraTutar" DataType="System.Decimal"/>
      <Column Name="KDVTutar" DataType="System.Decimal"/>
      <Column Name="GenelToplam" DataType="System.Decimal"/>
      <Column Name="BelgeTuru" DataType="System.String"/>
      <Column Name="IptalSebebi" DataType="System.String"/>
      <Column Name="FaturaKod1" DataType="System.String"/>
      <Column Name="FaturaKod2" DataType="System.String"/>
      <Column Name="FaturaKod3" DataType="System.String"/>
      <Column Name="ProjeKodu" DataType="System.String"/>
      <Column Name="Yazdirildi" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="Donusum" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="_IadeBelgeID" DataType="System.Int32"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
      <Column Name="AcikMi" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="AcikKullanici" DataType="System.String"/>
      <Column Name="ETTN" DataType="System.String"/>
      <Column Name="EDurum" DataType="System.Int32"/>
      <Column Name="EFaturaNumarasi" DataType="System.String"/>
    </TableDataSource>
    <TableDataSource Name="FaturaHareket" ReferenceName="RaporVerisi.FaturaHareket" DataType="System.Int32" Enabled="true">
      <Column Name="FaturaNumarasi" DataType="System.String"/>
      <Column Name="FirmaID" DataType="System.Int32"/>
      <Column Name="SubeID" DataType="System.Int32"/>
      <Column Name="DepoID" DataType="System.Int32"/>
      <Column Name="KullaniciID" DataType="System.Int32"/>
      <Column Name="Tarih" DataType="System.DateTime"/>
      <Column Name="Saat" DataType="System.String"/>
      <Column Name="StokID" DataType="System.Int32"/>
      <Column Name="StokKodu" DataType="System.String"/>
      <Column Name="StokAdi" DataType="System.String"/>
      <Column Name="Birim" DataType="System.String"/>
      <Column Name="Barkod" DataType="System.String"/>
      <Column Name="BirimFiyat" DataType="System.Decimal"/>
      <Column Name="BirimFiyatDahil" DataType="System.Decimal"/>
      <Column Name="NetFiyatDahil" DataType="System.Decimal"/>
      <Column Name="SatisKar" DataType="System.Decimal"/>
      <Column Name="Isk1" DataType="System.Decimal"/>
      <Column Name="Isk2" DataType="System.Decimal"/>
      <Column Name="Isk3" DataType="System.Decimal"/>
      <Column Name="Isk4" DataType="System.Decimal"/>
      <Column Name="Isk5" DataType="System.Decimal"/>
      <Column Name="Isk6" DataType="System.Decimal"/>
      <Column Name="Fiyat" DataType="System.Decimal"/>
      <Column Name="FiyatDahil" DataType="System.Decimal"/>
      <Column Name="Cikan" DataType="System.Decimal"/>
      <Column Name="Giren" DataType="System.Decimal"/>
      <Column Name="KDV" DataType="System.Decimal"/>
      <Column Name="KDVTutari" DataType="System.Decimal"/>
      <Column Name="ToplamHaric" DataType="System.Decimal"/>
      <Column Name="ToplamDahil" DataType="System.Decimal"/>
      <Column Name="ParaBirimi" DataType="System.String"/>
      <Column Name="DovizKuru" DataType="System.Decimal"/>
      <Column Name="SatisSekli" DataType="System.String"/>
      <Column Name="VadeTarihi" DataType="System.DateTime"/>
      <Column Name="Aciklama" DataType="System.String"/>
      <Column Name="CariKodu" DataType="System.String"/>
      <Column Name="CariAdi" DataType="System.String"/>
      <Column Name="BelgeTuru" DataType="System.String"/>
      <Column Name="BelgeID" DataType="System.Int32"/>
      <Column Name="CariID" DataType="System.Int32"/>
      <Column Name="_StokKdvID" DataType="System.Int32"/>
      <Column Name="_IskToplam" DataType="System.Decimal"/>
      <Column Name="_Miktar" DataType="System.Decimal"/>
      <Column Name="_BirimFiyat" DataType="System.Decimal"/>
      <Column Name="_BirimFiyatDahil" DataType="System.Decimal"/>
      <Column Name="_KDV" DataType="System.Decimal"/>
      <Column Name="_ToplamHaric" DataType="System.Decimal"/>
      <Column Name="_ToplamDahil" DataType="System.Decimal"/>
      <Column Name="_Isk1" DataType="System.Decimal"/>
      <Column Name="_Isk2" DataType="System.Decimal"/>
      <Column Name="_Isk3" DataType="System.Decimal"/>
      <Column Name="_Isk4" DataType="System.Decimal"/>
      <Column Name="_Isk5" DataType="System.Decimal"/>
      <Column Name="_Isk6" DataType="System.Decimal"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
      <Column Name="SNo" DataType="System.Int32"/>
    </TableDataSource>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="47.25">
      <TextObject Name="Text3" Width="94.5" Height="18.9" Text="[Fatura.CariAdi]" Font="Arial, 10pt"/>
      <TextObject Name="Text4" Left="226.8" Width="94.5" Height="18.9" Text="[Fatura.Tarih]" Format="Date" Format.Format="d" Font="Arial, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="48.56" Width="718.2" Height="28.35">
      <TextObject Name="Text2" Width="94.5" Height="18.9" Text="StokAdi" Font="Arial, 10pt"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="78.22" Width="718.2" Height="18.9" DataSource="FaturaHareket">
      <TextObject Name="Text1" Left="207.9" Width="94.5" Height="18.9" Text="[FaturaHareket.StokAdi]" Font="Arial, 10pt"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="98.43" Width="718.2" Height="18.9"/>
  </ReportPage>
</Report>
','ALIŞ FATURASI','9.10.2025 11:22:02',1) returning "ID"
2025-10-09 14:22:02 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Dizaynlar','Ekle',1,'ORCA','9.10.2025 14:22:02','Ekle işlemi yapıldı.','KKO',NULL) ;
2025-10-09 14:22:02 - SELECT "Ad","KullaniciID","XmlDizayn","Modul","ID","OlusturmaTarihi","Durum" FROM "Dizaynlar"  WHERE ( "Modul" = 'ALIŞ FATURASI' ) 
2025-10-09 14:22:14 - UPDATE "Dizaynlar"  SET
           "Ad"='ALIŞ FATURASI',"KullaniciID"=0,"XmlDizayn"='<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="08/14/2025 11:19:05" ReportInfo.Modified="10/09/2025 14:22:14" ReportInfo.CreatorVersion="2024.2.8.0">
  <Dictionary>
    <BusinessObjectDataSource Name="Genel" ReferenceName="Genel" DataType="System.Collections.Generic.List`1[[Orca.Data.FirmaTanimlari, Orca.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]" Enabled="true">
      <Column Name="FirmaAdi" DataType="System.String"/>
      <Column Name="YetkiliAdi" DataType="System.String"/>
      <Column Name="Telefon" DataType="System.String"/>
      <Column Name="Mail" DataType="System.String"/>
      <Column Name="VergiDairesi" DataType="System.String"/>
      <Column Name="VergiNo" DataType="System.String"/>
      <Column Name="Il" DataType="System.String"/>
      <Column Name="Ilce" DataType="System.String"/>
      <Column Name="Adres" DataType="System.String"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
    </BusinessObjectDataSource>
    <TableDataSource Name="Fatura" ReferenceName="RaporVerisi.Fatura" DataType="System.Int32" Enabled="true">
      <Column Name="FirmaID" DataType="System.Int32"/>
      <Column Name="SubeID" DataType="System.Int32"/>
      <Column Name="CariID" DataType="System.Int32"/>
      <Column Name="KullaniciID" DataType="System.Int32"/>
      <Column Name="DepoID" DataType="System.Int32"/>
      <Column Name="Sube" DataType="System.String"/>
      <Column Name="Kasa" DataType="System.String"/>
      <Column Name="Aciklama" DataType="System.String"/>
      <Column Name="CariKodu" DataType="System.String"/>
      <Column Name="CariAdi" DataType="System.String"/>
      <Column Name="VadeTarih" DataType="System.DateTime"/>
      <Column Name="Tarih" DataType="System.DateTime"/>
      <Column Name="Saat" DataType="System.String"/>
      <Column Name="FaturaNumarasi" DataType="System.String"/>
      <Column Name="DovizBirimi" DataType="System.String"/>
      <Column Name="DovizKuru" DataType="System.Decimal"/>
      <Column Name="Tutar" DataType="System.Decimal"/>
      <Column Name="IndirimTutar" DataType="System.Decimal"/>
      <Column Name="AraTutar" DataType="System.Decimal"/>
      <Column Name="KDVTutar" DataType="System.Decimal"/>
      <Column Name="GenelToplam" DataType="System.Decimal"/>
      <Column Name="BelgeTuru" DataType="System.String"/>
      <Column Name="IptalSebebi" DataType="System.String"/>
      <Column Name="FaturaKod1" DataType="System.String"/>
      <Column Name="FaturaKod2" DataType="System.String"/>
      <Column Name="FaturaKod3" DataType="System.String"/>
      <Column Name="ProjeKodu" DataType="System.String"/>
      <Column Name="Yazdirildi" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="Donusum" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="_IadeBelgeID" DataType="System.Int32"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
      <Column Name="AcikMi" DataType="System.Boolean" BindableControl="CheckBox"/>
      <Column Name="AcikKullanici" DataType="System.String"/>
      <Column Name="ETTN" DataType="System.String"/>
      <Column Name="EDurum" DataType="System.Int32"/>
      <Column Name="EFaturaNumarasi" DataType="System.String"/>
    </TableDataSource>
    <TableDataSource Name="FaturaHareket" ReferenceName="RaporVerisi.FaturaHareket" DataType="System.Int32" Enabled="true">
      <Column Name="FaturaNumarasi" DataType="System.String"/>
      <Column Name="FirmaID" DataType="System.Int32"/>
      <Column Name="SubeID" DataType="System.Int32"/>
      <Column Name="DepoID" DataType="System.Int32"/>
      <Column Name="KullaniciID" DataType="System.Int32"/>
      <Column Name="Tarih" DataType="System.DateTime"/>
      <Column Name="Saat" DataType="System.String"/>
      <Column Name="StokID" DataType="System.Int32"/>
      <Column Name="StokKodu" DataType="System.String"/>
      <Column Name="StokAdi" DataType="System.String"/>
      <Column Name="Birim" DataType="System.String"/>
      <Column Name="Barkod" DataType="System.String"/>
      <Column Name="BirimFiyat" DataType="System.Decimal"/>
      <Column Name="BirimFiyatDahil" DataType="System.Decimal"/>
      <Column Name="NetFiyatDahil" DataType="System.Decimal"/>
      <Column Name="SatisKar" DataType="System.Decimal"/>
      <Column Name="Isk1" DataType="System.Decimal"/>
      <Column Name="Isk2" DataType="System.Decimal"/>
      <Column Name="Isk3" DataType="System.Decimal"/>
      <Column Name="Isk4" DataType="System.Decimal"/>
      <Column Name="Isk5" DataType="System.Decimal"/>
      <Column Name="Isk6" DataType="System.Decimal"/>
      <Column Name="Fiyat" DataType="System.Decimal"/>
      <Column Name="FiyatDahil" DataType="System.Decimal"/>
      <Column Name="Cikan" DataType="System.Decimal"/>
      <Column Name="Giren" DataType="System.Decimal"/>
      <Column Name="KDV" DataType="System.Decimal"/>
      <Column Name="KDVTutari" DataType="System.Decimal"/>
      <Column Name="ToplamHaric" DataType="System.Decimal"/>
      <Column Name="ToplamDahil" DataType="System.Decimal"/>
      <Column Name="ParaBirimi" DataType="System.String"/>
      <Column Name="DovizKuru" DataType="System.Decimal"/>
      <Column Name="SatisSekli" DataType="System.String"/>
      <Column Name="VadeTarihi" DataType="System.DateTime"/>
      <Column Name="Aciklama" DataType="System.String"/>
      <Column Name="CariKodu" DataType="System.String"/>
      <Column Name="CariAdi" DataType="System.String"/>
      <Column Name="BelgeTuru" DataType="System.String"/>
      <Column Name="BelgeID" DataType="System.Int32"/>
      <Column Name="CariID" DataType="System.Int32"/>
      <Column Name="_StokKdvID" DataType="System.Int32"/>
      <Column Name="_IskToplam" DataType="System.Decimal"/>
      <Column Name="_Miktar" DataType="System.Decimal"/>
      <Column Name="_BirimFiyat" DataType="System.Decimal"/>
      <Column Name="_BirimFiyatDahil" DataType="System.Decimal"/>
      <Column Name="_KDV" DataType="System.Decimal"/>
      <Column Name="_ToplamHaric" DataType="System.Decimal"/>
      <Column Name="_ToplamDahil" DataType="System.Decimal"/>
      <Column Name="_Isk1" DataType="System.Decimal"/>
      <Column Name="_Isk2" DataType="System.Decimal"/>
      <Column Name="_Isk3" DataType="System.Decimal"/>
      <Column Name="_Isk4" DataType="System.Decimal"/>
      <Column Name="_Isk5" DataType="System.Decimal"/>
      <Column Name="_Isk6" DataType="System.Decimal"/>
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="OlusturmaTarihi" DataType="System.DateTime"/>
      <Column Name="Durum" DataType="System.Int32"/>
      <Column Name="SNo" DataType="System.Int32"/>
    </TableDataSource>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="47.25">
      <TextObject Name="Text3" Width="94.5" Height="18.9" Text="[Fatura.CariAdi]" Font="Arial, 10pt"/>
      <TextObject Name="Text4" Left="226.8" Width="94.5" Height="18.9" Text="[Fatura.Tarih]" Format="Date" Format.Format="d" Font="Arial, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="48.56" Width="718.2" Height="28.35">
      <TextObject Name="Text2" Left="198.45" Width="94.5" Height="18.9" Text="StokAdi" Font="Arial, 10pt"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="78.22" Width="718.2" Height="18.9" DataSource="FaturaHareket">
      <TextObject Name="Text1" Left="198.45" Width="94.5" Height="18.9" Text="[FaturaHareket.StokAdi]" Font="Arial, 10pt"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="98.43" Width="718.2" Height="18.9"/>
  </ReportPage>
</Report>
',"Modul"='ALIŞ FATURASI',"OlusturmaTarihi"='9.10.2025 11:22:02',"Durum"=1  WHERE ( "ID" = 1 )
2025-10-09 14:22:14 - INSERT INTO "LogTanim"  
           ("TabloAdi","IslemTipi","KayitId","Kullanici","Tarih","Aciklama","PcAdi","OzelLog")
     VALUES
           ('Dizaynlar','Guncelle',1,'ORCA','9.10.2025 14:22:14','Guncelle işlemi yapıldı.','KKO','{"Ad":"ALIŞ FATURASI","KullaniciID":0,"XmlDizayn":"<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<Report ScriptLanguage=\"CSharp\" ReportInfo.Created=\"08/14/2025 11:19:05\" ReportInfo.Modified=\"10/09/2025 14:22:14\" ReportInfo.CreatorVersion=\"2024.2.8.0\">\r\n  <Dictionary>\r\n    <BusinessObjectDataSource Name=\"Genel\" ReferenceName=\"Genel\" DataType=\"System.Collections.Generic.List`1[[Orca.Data.FirmaTanimlari, Orca.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]\" Enabled=\"true\">\r\n      <Column Name=\"FirmaAdi\" DataType=\"System.String\"/>\r\n      <Column Name=\"YetkiliAdi\" DataType=\"System.String\"/>\r\n      <Column Name=\"Telefon\" DataType=\"System.String\"/>\r\n      <Column Name=\"Mail\" DataType=\"System.String\"/>\r\n      <Column Name=\"VergiDairesi\" DataType=\"System.String\"/>\r\n      <Column Name=\"VergiNo\" DataType=\"System.String\"/>\r\n      <Column Name=\"Il\" DataType=\"System.String\"/>\r\n      <Column Name=\"Ilce\" DataType=\"System.String\"/>\r\n      <Column Name=\"Adres\" DataType=\"System.String\"/>\r\n      <Column Name=\"ID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"OlusturmaTarihi\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Durum\" DataType=\"System.Int32\"/>\r\n    </BusinessObjectDataSource>\r\n    <TableDataSource Name=\"Fatura\" ReferenceName=\"RaporVerisi.Fatura\" DataType=\"System.Int32\" Enabled=\"true\">\r\n      <Column Name=\"FirmaID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"SubeID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"CariID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"KullaniciID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"DepoID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"Sube\" DataType=\"System.String\"/>\r\n      <Column Name=\"Kasa\" DataType=\"System.String\"/>\r\n      <Column Name=\"Aciklama\" DataType=\"System.String\"/>\r\n      <Column Name=\"CariKodu\" DataType=\"System.String\"/>\r\n      <Column Name=\"CariAdi\" DataType=\"System.String\"/>\r\n      <Column Name=\"VadeTarih\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Tarih\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Saat\" DataType=\"System.String\"/>\r\n      <Column Name=\"FaturaNumarasi\" DataType=\"System.String\"/>\r\n      <Column Name=\"DovizBirimi\" DataType=\"System.String\"/>\r\n      <Column Name=\"DovizKuru\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Tutar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"IndirimTutar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"AraTutar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"KDVTutar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"GenelToplam\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"BelgeTuru\" DataType=\"System.String\"/>\r\n      <Column Name=\"IptalSebebi\" DataType=\"System.String\"/>\r\n      <Column Name=\"FaturaKod1\" DataType=\"System.String\"/>\r\n      <Column Name=\"FaturaKod2\" DataType=\"System.String\"/>\r\n      <Column Name=\"FaturaKod3\" DataType=\"System.String\"/>\r\n      <Column Name=\"ProjeKodu\" DataType=\"System.String\"/>\r\n      <Column Name=\"Yazdirildi\" DataType=\"System.Boolean\" BindableControl=\"CheckBox\"/>\r\n      <Column Name=\"Donusum\" DataType=\"System.Boolean\" BindableControl=\"CheckBox\"/>\r\n      <Column Name=\"_IadeBelgeID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"ID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"OlusturmaTarihi\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Durum\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"AcikMi\" DataType=\"System.Boolean\" BindableControl=\"CheckBox\"/>\r\n      <Column Name=\"AcikKullanici\" DataType=\"System.String\"/>\r\n      <Column Name=\"ETTN\" DataType=\"System.String\"/>\r\n      <Column Name=\"EDurum\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"EFaturaNumarasi\" DataType=\"System.String\"/>\r\n    </TableDataSource>\r\n    <TableDataSource Name=\"FaturaHareket\" ReferenceName=\"RaporVerisi.FaturaHareket\" DataType=\"System.Int32\" Enabled=\"true\">\r\n      <Column Name=\"FaturaNumarasi\" DataType=\"System.String\"/>\r\n      <Column Name=\"FirmaID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"SubeID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"DepoID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"KullaniciID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"Tarih\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Saat\" DataType=\"System.String\"/>\r\n      <Column Name=\"StokID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"StokKodu\" DataType=\"System.String\"/>\r\n      <Column Name=\"StokAdi\" DataType=\"System.String\"/>\r\n      <Column Name=\"Birim\" DataType=\"System.String\"/>\r\n      <Column Name=\"Barkod\" DataType=\"System.String\"/>\r\n      <Column Name=\"BirimFiyat\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"BirimFiyatDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"NetFiyatDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"SatisKar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk1\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk2\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk3\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk4\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk5\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Isk6\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Fiyat\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"FiyatDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Cikan\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"Giren\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"KDV\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"KDVTutari\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"ToplamHaric\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"ToplamDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"ParaBirimi\" DataType=\"System.String\"/>\r\n      <Column Name=\"DovizKuru\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"SatisSekli\" DataType=\"System.String\"/>\r\n      <Column Name=\"VadeTarihi\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Aciklama\" DataType=\"System.String\"/>\r\n      <Column Name=\"CariKodu\" DataType=\"System.String\"/>\r\n      <Column Name=\"CariAdi\" DataType=\"System.String\"/>\r\n      <Column Name=\"BelgeTuru\" DataType=\"System.String\"/>\r\n      <Column Name=\"BelgeID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"CariID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"_StokKdvID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"_IskToplam\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Miktar\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_BirimFiyat\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_BirimFiyatDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_KDV\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_ToplamHaric\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_ToplamDahil\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk1\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk2\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk3\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk4\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk5\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"_Isk6\" DataType=\"System.Decimal\"/>\r\n      <Column Name=\"ID\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"OlusturmaTarihi\" DataType=\"System.DateTime\"/>\r\n      <Column Name=\"Durum\" DataType=\"System.Int32\"/>\r\n      <Column Name=\"SNo\" DataType=\"System.Int32\"/>\r\n    </TableDataSource>\r\n  </Dictionary>\r\n  <ReportPage Name=\"Page1\" Watermark.Font=\"Arial, 60pt\">\r\n    <ReportTitleBand Name=\"ReportTitle1\" Width=\"718.2\" Height=\"47.25\">\r\n      <TextObject Name=\"Text3\" Width=\"94.5\" Height=\"18.9\" Text=\"[Fatura.CariAdi]\" Font=\"Arial, 10pt\"/>\r\n      <TextObject Name=\"Text4\" Left=\"226.8\" Width=\"94.5\" Height=\"18.9\" Text=\"[Fatura.Tarih]\" Format=\"Date\" Format.Format=\"d\" Font=\"Arial, 10pt\"/>\r\n    </ReportTitleBand>\r\n    <PageHeaderBand Name=\"PageHeader1\" Top=\"48.56\" Width=\"718.2\" Height=\"28.35\">\r\n      <TextObject Name=\"Text2\" Left=\"198.45\" Width=\"94.5\" Height=\"18.9\" Text=\"StokAdi\" Font=\"Arial, 10pt\"/>\r\n    </PageHeaderBand>\r\n    <DataBand Name=\"Data1\" Top=\"78.22\" Width=\"718.2\" Height=\"18.9\" DataSource=\"FaturaHareket\">\r\n      <TextObject Name=\"Text1\" Left=\"198.45\" Width=\"94.5\" Height=\"18.9\" Text=\"[FaturaHareket.StokAdi]\" Font=\"Arial, 10pt\"/>\r\n    </DataBand>\r\n    <PageFooterBand Name=\"PageFooter1\" Top=\"98.43\" Width=\"718.2\" Height=\"18.9\"/>\r\n  </ReportPage>\r\n</Report>\r\n","Modul":"ALIŞ FATURASI","ID":1,"OlusturmaTarihi":"2025-10-09T11:22:02.609363","Durum":1}') ;
2025-10-09 14:23:02 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:23:02 - SELECT "ST".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" "ST" Left JOIN "StokHareketleri" "SH" ON (( "ST"."ID" = "SH"."StokID" ) AND ( "SH"."FirmaID" = 1 ))  Left JOIN "Barkodlar" "B" ON ( "ST"."ID" = "B"."StokID" )   WHERE ((( "ST"."FirmaID" = 1 ) OR ( "ST"."FirmalarOrtakStok" = 1 )) AND ( "ST"."Durum" = 1 ))GROUP BY "ST"."ID"  
2025-10-09 14:23:02 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'frmStokArama' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'myGridListe' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:23:09 - SELECT * FROM TblConnection WHERE ConnectID='1'
2025-10-09 14:23:09 - SELECT *,
"Envanter"*"AlisFiyati" AS "AlisToplam",
"Envanter"*"SatisFiyati" AS "SatisToplam"
 FROM (
SELECT "SK".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" as "SK"
LEFT JOIN "StokHareketleri" AS "SH" ON "SH"."StokID"="SK"."ID"

GROUP BY "SK"."ID" ) AS T
2025-10-09 14:23:10 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'StokEnvanterDeger' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridSonuc' ELSE NULL END)))   LIMIT 1 offset 0
2025-10-09 14:24:19 - SELECT *,
"Envanter"*"AlisFiyati" AS "AlisToplam",
"Envanter"*"SatisFiyati" AS "SatisToplam"
 FROM (
SELECT "SK".*,SUM("SH"."Giren")-SUM("SH"."Cikan") "Envanter" FROM "StokKartlari" as "SK"
LEFT JOIN "StokHareketleri" AS "SH" ON "SH"."StokID"="SK"."ID"

GROUP BY "SK"."ID" ) AS T
2025-10-09 14:24:20 - SELECT "Adi","Bicim","FormAdi","KullaniciID","ID","OlusturmaTarihi","Durum" FROM "GridGorunumler"   WHERE (((( "KullaniciID" = 1 ) OR ( "KullaniciID" = 0 )) AND ( "FormAdi" = 'StokEnvanterDeger' )) AND ( "Adi" =(CASE WHEN  NULL IS NULL THEN  'gridSonuc' ELSE NULL END)))   LIMIT 1 offset 0
