openBaraza HCM HR Payroll / Blog: Recent posts

Configure mail.xml in projects/hr/config then run ./baraza/server.sh
INSERT INTO sys_emailed (org_id, sys_email_id, table_id, table_name)
SELECT org_id, sys_email_id, NEW.entity_id, 'entitys'
FROM sys_emails
WHERE (use_type = 3) AND (org_id = NEW.org_id);

On the FUNCTION ins_employees()
CREATE OR REPLACE FUNCTION ins_employees() RETURNS trigger AS $$
DECLARE
v_entity_type_id integer;
v_use_type integer;
v_org_sufix varchar(4);
v_first_password varchar(12);
v_user_count integer;
v_user_name varchar(120);
BEGIN
IF (TG_OP = 'INSERT') THEN
IF(NEW.entity_id IS NULL) THEN
SELECT org_sufix INTO v_org_sufix
FROM orgs WHERE (org_id = NEW.org_id);

        IF(v_org_sufix is null)THEN v_org_sufix := ''; END IF;... [read more](/p/obhrms/blog/2017/01/adding-emails-for-new-employees/)

For leave, petty cash reuests, the approvals and approval levels are defined on the Workflows. Emails and notices are defined depending on the reporting hierachy.
Add the email content on the emails details.

1. On biometric integration you can import the file; this is a sample file import but you can have the data fed directly into the database
   http://demo.openbaraza.org/hr/index.jsp?xml=projects.xml&view=15:1
   Once imported the data is broken down into attendance
   http://demo.openbaraza.org/hr/index.jsp?xml=projects.xml&view=15:0

2. Accounting
   The payroll created a ledger
   http://demo.openbaraza.org/hr/index.jsp?xml=payroll.xml&view=115:0
   That can be posted to an account system either by excel import of direct database feed.