case azzahrawi
Need to create trigger to automatically update zone value for $ON_FIN_ZONE=1 in the config
Need to manually update for previues record

before_insert_fin_receipt_zone
before_insert_fin_invoice_zone
before_insert_fin_ledger_zone
before_insert_fin_report_zone
////////////////////////////////////////////////


DELIMITER //

CREATE TRIGGER before_insert_fin_receipt_zone
BEFORE INSERT ON fin_receipt
FOR EACH ROW
BEGIN
    DECLARE zone_value VARCHAR(255);

    -- Get the zone value from sch table where sid matches
    SELECT zone INTO zone_value 
    FROM sch 
    WHERE id = NEW.sid AND zone != '';

    -- Set the zone value if a non-empty zone is found
    IF zone_value IS NOT NULL THEN
        SET NEW.zone = zone_value;
    END IF;
END;
//

DELIMITER ;


DELIMITER //

CREATE TRIGGER before_insert_fin_invoice_zone
BEFORE INSERT ON fin_invoice
FOR EACH ROW
BEGIN
    DECLARE zone_value VARCHAR(255);

    -- Get the zone value from sch table where sid matches
    SELECT zone INTO zone_value 
    FROM sch 
    WHERE id = NEW.sid AND zone != '';

    -- Set the zone value if a non-empty zone is found
    IF zone_value IS NOT NULL THEN
        SET NEW.zone = zone_value;
    END IF;
END;
//

DELIMITER ;



DELIMITER //

CREATE TRIGGER before_insert_fin_ledger_zone
BEFORE INSERT ON fin_ledger
FOR EACH ROW
BEGIN
    DECLARE zone_value VARCHAR(255);

    -- Get the zone value from sch table where sid matches
    SELECT zone INTO zone_value 
    FROM sch 
    WHERE id = NEW.sid AND zone != '';

    -- Set the zone value if a non-empty zone is found
    IF zone_value IS NOT NULL THEN
        SET NEW.zone = zone_value;
    END IF;
END;
//

DELIMITER ;


DELIMITER //

CREATE TRIGGER before_insert_fin_report_zone
BEFORE INSERT ON fin_report
FOR EACH ROW
BEGIN
    DECLARE zone_value VARCHAR(255);

    -- Get the zone value from sch table where sid matches
    SELECT zone INTO zone_value 
    FROM sch 
    WHERE id = NEW.sid AND zone != '';

    -- Set the zone value if a non-empty zone is found
    IF zone_value IS NOT NULL THEN
        SET NEW.zone = zone_value;
    END IF;
END;
//

DELIMITER ;


/////////////////////////WORK_ORDER

DELIMITER //

CREATE TRIGGER before_insert_work_order
BEFORE INSERT ON work_order
FOR EACH ROW
BEGIN
    DECLARE zone_value VARCHAR(255);

    -- Get the zone value from sch table where sid matches
    SELECT zone INTO zone_value 
    FROM sch 
    WHERE id = NEW.sid AND zone != '';

    -- Set the zone value if a non-empty zone is found
    IF zone_value IS NOT NULL THEN
        SET NEW.zone = zone_value;
    END IF;
END;
//

DELIMITER ;

//NOTA Table type => group information
grp='onlinepayset' => prm_settlement_bank.php
grp='paytype' => cashsale_reg.php and other


** 

field feature in table fin_coa_item we store stock min max refer coa_stock

//Guna Table Remark
procument->budget => app=fin_budget_group