Rule Engine Implementation
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
This my idea to implement the Rule & Engine into ADempiere
Fist we need create new model data into Application Dictionary:
- Table AD_Rule_Engine
- Fields:
- Value
- Name
- Description
- Rule Engine Type
- Script
DDL Script
CREATE TABLE adempiere.ad_rule_engine ( ad_client_id numeric(10) NOT NULL, ad_org_id numeric(10) NOT NULL, ad_rule_engine_id numeric(10) NOT NULL, created timestamp without time zone NOT NULL, createdby numeric(10) NOT NULL, description character varying(255), isactive character(1) NOT NULL, name character varying(60) NOT NULL, rule_engine_type character varying(2), script character varying(4000), updated timestamp without time zone NOT NULL, updatedby numeric(10) NOT NULL, value character varying(40), CONSTRAINT ad_rule_engine_key PRIMARY KEY (ad_rule_engine_id), CONSTRAINT ad_rule_engine_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])) )
New Windows into Application Dictionary
- Windows Name : Rule Engine
- Fields
- Search Key : Value to search to Rule
- Name : Name of Rule
- Description: Description detail the rule
- Rule Engine Type :
- Bash Shell (Allow execute a rule based in this language script)
- SQL (Will Allow execute a rule based in SQL standard)
- AOP (Will Allow execute a rule based in AOP)
- Script : Script logic to Rule Engine Type
Screenshot
Here you can review how I am implement bash Shell in Payroll