ALTER TABLE SBASLIK
    ADD SATFISEKUNO VARCHAR(20),
    ADD SATFISZNO VARCHAR(20),
    ADD SATFISNO VARCHAR(20),
    ADD SATFISZAMAN TIMESTAMP,
    ADD SATFISKDV FLOAT,
    ADD SATFISTOPLAM FLOAT,
    ADD SATFISNAKIT FLOAT,
    ADD SATFISKKART FLOAT;

CREATE OR ALTER VIEW TBLELZABFIYATGOR(
    BARKOD,
    ISIM,
    FIYAT,
    PB1)
AS
SELECT * FROM (
SELECT UBARKOD AS BARKOD,UAD AS ISIM, USONSATFIY AS FIYAT, 'TL' AS PB1 FROM URUNLER  WHERE USONSATFIY>0
UNION ALL
SELECT OBRK2 AS BARKOD,UAD AS ISIM, USONSATFIY AS FIYAT, 'TL' AS PB1 FROM URUNLER WHERE USONSATFIY>0 AND OBRK2 IS NOT NULL) AS  A
WHERE CHAR_LENGTH(BARKOD)>6;
;

ALTER TABLE URUNLER ALTER COLUMN UKDVMATRAH SET DEFAULT 20;
ALTER TABLE URUNGRUP ADD UGRUPKDV INTEGER DEFAULT 20;
UPDATE URUNGRUP SET UGRUPKDV=20;
UPDATE URUNGRUP SET UGRUPKDV=10 WHERE UGRUPADI='TEXTİL';
UPDATE URUNGRUP SET UGRUPKDV=10 WHERE UGRUPADI='KIRTASİYE';

CREATE OR ALTER TRIGGER URUN_KDV_GUNCELLE FOR URUNLER
ACTIVE AFTER UPDATE POSITION 0
AS
BEGIN
IF (OLD.UGRUP1 <> NEW.UGRUP1) THEN
BEGIN
UPDATE URUNLER SET
       UKDVMATRAH = (SELECT FIRST 1 UGRUPKDV FROM URUNGRUP WHERE UGRUPADI=NEW.UGRUP1)
     WHERE UID = OLD.UID;
END
END;

ALTER TABLE YAZICI ADD YFIYATGOSTER VARCHAR(10) DEFAULT 'H';

ALTER TABLE SBASLIK ADD SATTAHNAKIT FLOAT DEFAULT 0, ADD SATTAHKART FLOAT DEFAULT 0;

CREATE TABLE ISLEM_LOG (
    ID           BIGINT NOT NULL,
    TARIH        DATE DEFAULT CURRENT_DATE,
    SAAT         TIME DEFAULT CURRENT_TIME,
    KULLANICI    VARCHAR(10),
    ISLEM        VARCHAR(20),
    ISLEM_DETAY  VARCHAR(300),
    URUNNO       VARCHAR(10),
    BARKOD       VARCHAR(20),
    TABLO        VARCHAR(20)
);

	
CREATE SEQUENCE GEN_ISLEM_LOG_ID;

CREATE OR ALTER TRIGGER ISLEM_LOG_TRG FOR ISLEM_LOG
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN

IF(NEW.ID IS NULL) THEN
BEGIN
NEW.ID = GEN_ID(GEN_ISLEM_LOG_ID , 1);
END
 DELETE FROM ISLEM_LOG WHERE TARIH<= CURRENT_DATE-60;
END;

CREATE OR ALTER PROCEDURE ISLEM_LOG_SP (
    KULLANICI VARCHAR(10),
    ISLEM VARCHAR(20),
    ISLEM_DETAY VARCHAR(300),
    URUNNO INTEGER,
    BARKOD VARCHAR(20),
    TABLO VARCHAR(20))
AS
BEGIN
  INSERT INTO ISLEM_LOG (KULLANICI, ISLEM, ISLEM_DETAY,URUNNO,BARKOD,TABLO)
VALUES (:KULLANICI, :ISLEM, :ISLEM_DETAY,:URUNNO, :BARKOD,:TABLO );
  SUSPEND;
END;

UPDATE FIRMABILGI SET YIL=2026;
DELETE FROM CARIKART  WHERE  CHMFID<3;
UPDATE SBASLIK SET SATTAHNAKIT=SATGENELTOP WHERE SATTIPI='PEŞİN' AND SATFIRMAID=1;
UPDATE SBASLIK SET SATTAHKART =SATGENELTOP WHERE SATTIPI='POS'   AND SATFIRMAID=1;