การตั้งค่า ltax4 อัตราก้าวหน้า

BEGIN

IF NEW.reduceTaxCode = 23 THEN

IF NEW.netTax <= 300000 THEN

SET NEW.tax_rate_text = '0.6';

ELSEIF NEW.netTax >= 300001 AND NEW.netTax <= 1350000 THEN

SET NEW.tax_rate_text = '0.6-0.7';

ELSEIF NEW.netTax >= 1350001 AND NEW.netTax <= 7750000 THEN

SET NEW.tax_rate_text = '0.6-0.8';

ELSEIF NEW.netTax >= 7750000 AND NEW.netTax <= 43750000 THEN

SET NEW.tax_rate_text = '0.6-0.9';

ELSEIF NEW.netTax >= 43750000 THEN

SET NEW.tax_rate_text = '0.6-1';

END IF;

END IF;

END