protected void executeInternal(JobExecutionContext context) throws JobExecutionException {
List<Object[]> lsSTGUsers = new ArrayList<Object[]>();
synDB = (SynDB) context.getMergedJobDataMap().get("synDB");
String eable = synDB.getConfigProperties("ENABLE_BATCH_JOB");
if (eable.equalsIgnoreCase("N")) {
return;
}
long startTime = System.currentTimeMillis();
System.out.println("Batch Job running at " + Calendar.getInstance().getTime());
host = synDB.getConfigProperties("SMTP_HOST");
port = synDB.getConfigProperties("SMTP_PORT");
password = synDB.getConfigProperties("SMTP_PASSWORD");
emailFrom = synDB.getConfigProperties("FROM");
emailTo = synDB.getConfigProperties("TO");
subject = synDB.getConfigProperties("SUBJECT");
username = synDB.getConfigProperties("SMTP_USER");
logfilePath = synDB.getConfigProperties("LOG_FILE");
/** Check disable sync to keycloak db */
String eableOutgoing = synDB.getConfigProperties("ENABLE_KEYCLOAK_DATA");
System.out.println("eableOutgoing: " + eableOutgoing);
if (eableOutgoing.equalsIgnoreCase("N")) {
return;
}
/** Clear user type, subtype */
String clearUserType = synDB.getConfigProperties("ENABLE_CLEAR_USER_TYPE");
if (clearUserType.equalsIgnoreCase("Y")) {
synDB.clearUserTypeSubType();
synDB.deleteSubType();
synDB.deleteUserType();
}
/** ****************************** SYNC USERS * ***************************** */
// Check disable get data from db2
String eableIncoming = synDB.getConfigProperties("ENABLE_DB2_DATA");
if (eableIncoming.equalsIgnoreCase("Y")) {
lsSTGUsers = getCustomStgUsers(false);
if (lsSTGUsers != null) {
System.out.println("Sync to CUSTOM_STG_USER in keycloak");
for (Object[] row : lsSTGUsers) {
System.out.println(
"INSERT TO KEYCLOAK | ID_NRIC:"
+ row[0]
+ ", FIRST_NAME:"
+ row[1]
+ ", LAST_NAME:"
+ row[2]
+ ", MOBILE:"
+ row[3]
+ ", EMAIL:"
+ row[4]
+ ", ACCOUNT_STATUS:"
+ row[5]
+ ", AGENT_CODE:"
+ row[6]
+ ", AGENCY:"
+ row[7]
+ ", NEED2FA:"
+ row[8]
+ ", NEEDTNC:"
+ row[9]
+ ", USER_TYPE:"
+ row[10]
+ ", USER_SUB_TYPE:"
+ row[11]
+ ", CREATED_DATE :"
+ row[12]
+ row[12]
+ ", ROLE_NAME :"
+ row[13]);
String id_nric = (String) row[0];
if (id_nric != null) {
id_nric = id_nric.toUpperCase().trim();
}
// a.ID_NRIC, FIRST_NAME, LAST_NAME, MOBILE, EMAIL, ACCOUNT_STATUS, AGENT_CODE,
// AGENCY, NEED2FA, NEEDTNC, USER_TYPE, USER__SUB_TYPE, a.CREATED_DATE, b.ROLE_NAME
String first_name = (String) row[1];
String last_name = (String) row[2];
String mobile = (String) row[3];
String email = (String) row[4];
String account_status = (String) row[5];
String agent_code = (String) row[6];
String agency = (String) row[7];
String need2fa = (String) row[8];
String needtnc = (String) row[9];
String user_type = (String) row[10];
if (user_type != null) {
user_type = user_type.toUpperCase().trim();
}
String user_sub_type = (String) row[11];
if (user_sub_type != null) {
user_sub_type = user_sub_type.toUpperCase().trim();
}
String roles = (String) row[13];
System.out.println("roles: " + roles);
// check for user type
String userTypeId = synDB.getUserTypeId(user_type);
if (userTypeId.trim().equals("")) {
userTypeId = genearateUDID();
synDB.insertCustomUserType(user_type, userTypeId);
}
// check for sub user type
String userSubTypeId = synDB.getUserSubTypeId(user_sub_type);
if (userSubTypeId.trim().equals("")) {
userSubTypeId = genearateUDID();
synDB.insertCustomUserSubType(user_sub_type, userSubTypeId, userTypeId);
} else {
synDB.updateCustomUserSubType(user_sub_type, userSubTypeId, userTypeId);
}
System.out.println("userSubTypeId: " + userSubTypeId);
System.out.println("userTypeId: " + userTypeId);
System.out.println("Check user exist in user entity table");
String user_id = synDB.getUserEntityByUsername(id_nric);
if (user_id.trim().equals("")) {
System.out.println("======================");
System.out.println("Insert into UserEntity: " + id_nric);
// Insert to User Entity table
synDB.insertToUserEntity(
id_nric,
first_name,
last_name,
mobile,
email,
account_status,
agent_code,
agency,
need2fa,
needtnc,
userTypeId,
userSubTypeId);
} else {
synDB.updateUserEntityByID(
first_name,
last_name,
mobile,
email,
account_status,
agent_code,
agency,
userTypeId,
userSubTypeId,
user_id);
}
System.out.println("user_id=" + user_id);
System.out.println("id_nric=" + id_nric);
// manage app role
List<String> lsUserTypeRoles = synDB.getRolesInUserType(user_type);
// delete record by user_id and role_id in user_role_mapping
synDB.deleteUserRoleMappingByUserIdRoleId(user_id);
for (String rw : lsUserTypeRoles) {
// add user_role_mapping by user_id and role_id (app role set in user type)
String role_id = rw;
System.out.println("========AND=====role_id: " + role_id);
if (role_id != null && !role_id.trim().equals("")) {
// add user_role_mapping by user_id and role_id (user role)
synDB.insertUserRoleMapping(user_id, role_id);
}
}
// manage user role
StringTokenizer st = new StringTokenizer(roles, ",");
while (st.hasMoreElements()) {
String role = (String) st.nextElement();
if (role != null) {
role = role.trim().toUpperCase();
// sync keycloak_role by role_name
String keycloak_role_id = synDB.getKeycloakRoleByName(role);
if (keycloak_role_id == null
|| (keycloak_role_id != null && keycloak_role_id.trim().equals(""))) {
keycloak_role_id = genearateUDID();
String realmId = synDB.getPSERealmId();
synDB.insertKeycloakRole(
keycloak_role_id, realmId, false, role, realmId, null, realmId, false);
countRoleProcessed += 1;
}
System.out.println("========AND=====keycloak_role_id: " + keycloak_role_id);
// add user_role_mapping by user_id and role_id (user role)
synDB.insertUserRoleMapping(user_id, keycloak_role_id);
}
}
}
}
sNoOfRecordInputUser += noOfRecordInputUser + sNewLine;
}
countUserNotProcessed = noOfRecordInputUser - countUserProcessed;
long endTime = System.currentTimeMillis();
long totalTime = endTime - startTime;
String sUserTypeNotExist = "";
/*
if (sbUserTypeNotInsert != null) {
sUserTypeNotExist = "UserType not exist: "
+ sbUserTypeNotInsert.toString() + sNewLine;
}*/
String content = sNoOfRecordInputUser + sNoOfRecordPressedUser + sNoOfRecordNotPressedUser;
content += sNoOfRecordInputRole + sNoOfRecordPressedRole + sNoOfRecordNotPressedRole;
content += sUserTypeNotExist;
content += "Process duration: " + totalTime + "(millisecond)";
String enableEmail = synDB.getConfigProperties("ENABLE_EMAIL");
// Check disable send mail
if (enableEmail.equalsIgnoreCase("Y")) {
try {
System.out.println("Sending email...");
Mail mailBox =
new Mail(
emailFrom, emailTo, subject, host, port, username, password, content, logfilePath);
mailBox.send();
System.out.println("Mail sent");
} catch (Exception ex) {
ex.printStackTrace();
}
}
System.out.println("totalTime: " + totalTime);
}
