Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.sany.masterdata.hr.sync.SyncUserInfo Maven / Gradle / Ivy
/*
* @(#)SyncOrgInfo.java
*
* Copyright @ 2001-2012 SANY Group Co.,Ltd.
* All right reserved.
*
* 这个软件是属于bbossgroups有限公司机密的和私有信息，不得泄露。
* 并且只能由bbossgroups有限公司内部员工在得到许可的情况下才允许使用。
* This software is the confidential and proprietary information
* of SANY Group Co, Ltd. You shall not disclose such
* Confidential Information and shall use it only in accordance
* with the terms of the license agreement you entered into with
* SANY Group Co, Ltd.
*/
package com.sany.masterdata.hr.sync;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import com.frameworkset.common.poolman.ConfigSQLExecutor;
import com.frameworkset.common.poolman.PreparedDBUtil;
import com.frameworkset.common.poolman.SQLExecutor;
import com.frameworkset.orm.transaction.TransactionManager;
import com.frameworkset.platform.security.AccessControl;
import com.frameworkset.platform.security.authentication.EncrpyPwd;
import com.frameworkset.platform.sysmgrcore.entity.Log;
import com.frameworkset.platform.sysmgrcore.entity.Organization;
import com.frameworkset.platform.sysmgrcore.manager.LogManager;
import com.frameworkset.platform.sysmgrcore.manager.SecurityDatabase;
import com.frameworkset.platform.sysmgrcore.purviewmanager.db.UserOrgParamManager;
import com.frameworkset.util.SimpleStringUtil;
import com.frameworkset.util.StringUtil;
import com.sany.greatwall.MdmService;
import com.sany.greatwall.domain.MdmUser;
import com.sany.masterdata.utils.MDPropertiesUtil;
/**
* 同步机构数据
* @author caix3
* @since 2012-3-22
*/
public class SyncUserInfo {
private static final String USER_SAVE_SQL = "insert into td_sm_user (user_sn, user_name, user_password, user_realname, user_sex, user_worktel, user_worknumber, user_mobiletel1, user_birthday, user_idcard, user_isvalid, user_type, user_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
private static final String USERORG_SAVE_SQL = "insert into td_sm_orguser (org_id, user_id) values (?,?)";
private static final String USERORGJOB_SAVE_SQL = "insert into td_sm_userjoborg (org_id, job_id, user_id) values (?, ?, ?)";
private static final String USER_UPDATE_SQL_old_old = "update td_sm_user set user_sn=?, user_name=?, user_password=?, user_realname=?, user_sex=?, user_worktel=?, user_worknumber=?, user_mobiletel1=?, user_birthday=?, user_idcard=?, user_isvalid=?, user_type=? where user_id=?";
private static final String USER_UPDATE_SQL_old = "update td_sm_user set user_sn=?, user_name=?, user_realname=?, user_sex=?, user_worktel=?, user_worknumber=?, user_mobiletel1=?, user_birthday=?, user_idcard=?, user_isvalid=?, user_type=? where user_id=?";
private static final String USER_UPDATE_SQL = "update td_sm_user set user_sn=?, user_name=?, user_realname=?, user_sex=?, user_worktel=?, user_worknumber=?, user_mobiletel1=?, user_birthday=?, user_idcard=? where user_id=?";
private static final String USER_UPDATE_USER_TYPE_SQL = "update td_sm_user set user_sn=?, user_name=?, user_realname=?, user_sex=?, user_worktel=?, user_worknumber=?, user_mobiletel1=?, user_birthday=?, user_idcard=?, user_type=? where user_id=?";
private static final String USERORG_UPDATE_SQL = "update td_sm_orguser set org_id=? where user_id=?";
private static final String USERORGJOB_UPDATE_SQL = "update td_sm_userjoborg set org_id=?, job_id=? where user_id=?";
private static final String exist_org_user = "delete from td_sm_orguser where user_id=?";
private static final String exist_org_job_user = "delete from td_sm_userjoborg where user_id=?";
private static final Integer BATCH_LIMIT = 1000;
private static final String[] SEX = {"", "M", "F"};
private static final String USER_PS = EncrpyPwd.encodePassword("123456");
private static Logger logger = Logger.getLogger(SyncUserInfo.class);
private UserOrgParamManager userOrgParamManager = new UserOrgParamManager();
private MdmService mdmService;
private boolean deleteremoveduser = false;
private boolean updateusertype = true;
/**
* 是否启用用户调整和组织机构调整功能，启用后一旦管理员手动调整用户和机构关系、组织之间的关系后
* 将不会自动同步这些关系，以手工调整后的关系为准，默认为开启true，false不开启
*/
private boolean enablecustom = true;
public boolean isEnablecustom() {
return enablecustom;
}
public void setEnablecustom(boolean enablecustom) {
this.enablecustom = enablecustom;
}
private boolean needremove(String userID, List newuserKeySet)
{
for(int i = 0; newuserKeySet != null && i < newuserKeySet.size(); i ++)
{
MdmUser user = newuserKeySet.get(i);
if(exchange(user.getUserNo()).equals(userID))
return false;
}
return true;
}
private List evalremoves(List userKeySet, List newuserKeySet)
{
List removes = new ArrayList();
for(int i = 0; userKeySet != null && i < userKeySet.size(); i ++)
{
RemovedUser user = userKeySet.get(i);
if(user.getUser_type() != null && user.getUser_type().equals("0"))
continue;
if(needremove(user.getUser_id(), newuserKeySet))
{
removes.add(user);
}
}
return removes;
}
private ConfigSQLExecutor executor;
private boolean contain(String userNo,Map userKeySet)
{
if(userKeySet != null)
{
// for(RemovedUser user:userKeySet)
// {
// if(user.getUser_id().equals(userNo))
// return true;
// }
if(userKeySet.containsKey(userNo))
return true;
}
return false;
}
/**
* 同步所有机构数据
*/
public void syncAllData() {
logger.info("Sync user info started...");
List removes = null;
try {
LogManager logMgr = SecurityDatabase.getLogManager();
//以下是以一个quartz任务执行日志记录为实例说明日志组件的使用方法
AccessControl control = AccessControl.getAccessControl();
String userAccount = "";//操作账号
String operContent = "";//操作内容
String machineID = "";//操作主机标识
String orgID = "";//操作员所属部门id
if(control == AccessControl.getGuest())//匿名用户-guest，登录用户直接忽略这个条件进入下一个环节
{
machineID = SimpleStringUtil.getHostIP();
userAccount = "Quartz定时任务";
operContent = userAccount + "同步用户数据开始";
}
else //登录用户
{
userAccount = control.getUserAccount();
String userName = control.getUserName();//操作员中文名称
String subsystem = control.getCurrentSystemName();//操作系统名称
machineID = control.getMachinedID();//客户端ip信息
Organization org = control.getChargeOrg();//获取当前用户所属机构
if(org != null)
{
orgID = org.getOrgId();
}
operContent = userAccount + "(" + userName + ") 从[" + subsystem + "]同步用户数据开始";
}
String operModle = "主数据同步";//日志所属模块
logMgr.log(userAccount,orgID,operModle, machineID,
operContent ,"", Log.INSERT_OPER_TYPE);
} catch (Exception e) {
//e.printStackTrace();
}
boolean isfailed = false;
String error = "";
try {
List userList = mdmService.getUserList("19000101", "99000101", "1", "99999999");
if(userList == null || userList.size() == 0)
return;
Object dump = new Object();
TransactionManager tm = new TransactionManager();
PreparedDBUtil userSavePre = new PreparedDBUtil();
PreparedDBUtil userOrgSavePre = new PreparedDBUtil();
PreparedDBUtil userJobOrgSavePre = new PreparedDBUtil();
PreparedDBUtil userUpdatePre = new PreparedDBUtil();
PreparedDBUtil userOrgUpdatePre = new PreparedDBUtil();
PreparedDBUtil userJobOrgUpdatePre = new PreparedDBUtil();
try {
tm.begin();
Map fixeduserorginfos = enablecustom ?userOrgParamManager.getFixedUserOrgInfos():null;
if(fixeduserorginfos == null)
fixeduserorginfos = new HashMap();
//用户主键索引
List userKeySet = executor.queryList(RemovedUser.class, "selectTdSmUserKey");
Map userMap = new HashMap();
if(userKeySet != null)
{
for(RemovedUser user:userKeySet)
{
userMap.put(user.getUser_id(), user);
}
}
removes = this.evalremoves(userKeySet, userList);
// //用户机构关系索引
// Set userOrgKeySet = new HashSet(executor.queryList(String.class, "selectTdSmOrgUserKey"));
// //用户岗位机构关系索引
// Set userJobOrgKeySet = new HashSet(executor.queryList(String.class, "selectTdSmOrgJobUserKey"));
Map newUsers = new HashMap();
Map> usersByNo = new HashMap>();
for(int i = 0; i < userList.size(); i ++)
{
MdmUser u = userList.get(i);
List temp = usersByNo.get(u.getUserNo());
if(temp == null)
{
temp = new ArrayList();
usersByNo.put(u.getUserNo(), temp);
}
temp.add(u);
}
userSavePre.setBatchOptimize(false);
userSavePre.preparedInsert(USER_SAVE_SQL);
userOrgSavePre.preparedInsert(USERORG_SAVE_SQL);
userOrgSavePre.setBatchOptimize(false);
userJobOrgSavePre.preparedInsert(USERORGJOB_SAVE_SQL);
userJobOrgSavePre.setBatchOptimize(false);
// if(!this.updateusertype)
userUpdatePre.preparedUpdate(USER_UPDATE_USER_TYPE_SQL);
// else
// userUpdatePre.preparedUpdate(USER_UPDATE_USER_TYPE_SQL);
userUpdatePre.setBatchOptimize(false);
userOrgUpdatePre.preparedUpdate(USERORG_SAVE_SQL);
userOrgUpdatePre.setBatchOptimize(false);
userJobOrgUpdatePre.preparedUpdate(USERORGJOB_SAVE_SQL);
userJobOrgUpdatePre.setBatchOptimize(false);
int saveSize = 0;
int updateSize = 0;
Iterator>> ss = usersByNo.entrySet().iterator();
while(ss.hasNext()) {
Map.Entry> entry = ss.next();
List users = entry.getValue();
MdmUser temp = getUser(users);
String userid = exchange(temp.getUserNo());
if (contain(userid,userMap)) {
RemovedUser removedUser = userMap.get(userid);
if(removedUser.getUser_type() != null && removedUser.getUser_type().equals("0"))//系统用户忽略更新
continue;
updateSize ++;
addPreBatch(userUpdatePre, userOrgUpdatePre, userJobOrgUpdatePre,temp,newUsers,fixeduserorginfos,true);
if (updateSize > BATCH_LIMIT) {
updateSize = 0;
userUpdatePre.executePreparedBatch();
userUpdatePre = new PreparedDBUtil();
userUpdatePre.setBatchOptimize(false);
userUpdatePre.preparedUpdate(USER_UPDATE_USER_TYPE_SQL);
userOrgUpdatePre.executePreparedBatch();
userOrgUpdatePre = new PreparedDBUtil();
userOrgUpdatePre.setBatchOptimize(false);
userOrgUpdatePre.preparedUpdate(USERORG_SAVE_SQL);
userJobOrgUpdatePre.executePreparedBatch();
userJobOrgUpdatePre = new PreparedDBUtil();
userJobOrgUpdatePre.setBatchOptimize(false);
userJobOrgUpdatePre.preparedUpdate(USERORGJOB_SAVE_SQL);
}
} else {
// if(newUsers.containsKey(temp.getUserNo()))
// {
// if(temp.getUserId().indexOf('_') < 0)
// {
// updateSize ++;
// addPreBatch(userUpdatePre, userOrgUpdatePre, userJobOrgUpdatePre,temp,newUsers);
// if (updateSize > BATCH_LIMIT) {
// updateSize = 0;
// userUpdatePre.executePreparedBatch();
// userUpdatePre = new PreparedDBUtil();
// userUpdatePre.setBatchOptimize(false);
// userUpdatePre.preparedUpdate(USER_UPDATE_SQL);
// userOrgUpdatePre.executePreparedBatch();
// userOrgUpdatePre = new PreparedDBUtil();
// userOrgUpdatePre.setBatchOptimize(false);
// userOrgUpdatePre.preparedUpdate(USERORG_SAVE_SQL);
// userJobOrgUpdatePre.executePreparedBatch();
// userJobOrgUpdatePre = new PreparedDBUtil();
// userJobOrgUpdatePre.setBatchOptimize(false);
// userJobOrgUpdatePre.preparedUpdate(USERORGJOB_SAVE_SQL);
//
// }
// }
//
// }
// else
// {
// saveSize ++;
// newUsers.put(temp.getUserNo(), dump);
// addPreBatch(userSavePre, userOrgSavePre, userJobOrgSavePre, temp, newUsers);
// if (saveSize > BATCH_LIMIT) {
// saveSize = 0;
// userSavePre.executePreparedBatch();
//
// userSavePre = new PreparedDBUtil();
// userSavePre.setBatchOptimize(false);
// userSavePre.preparedUpdate(USER_SAVE_SQL);
// userOrgSavePre.executePreparedBatch();
//
// userOrgSavePre = new PreparedDBUtil();
// userOrgSavePre.setBatchOptimize(false);
// userOrgSavePre.preparedUpdate(USERORG_SAVE_SQL);
// userJobOrgSavePre.executePreparedBatch();
//
// userJobOrgSavePre = new PreparedDBUtil();
// userJobOrgSavePre.setBatchOptimize(false);
// userJobOrgSavePre.preparedUpdate(USERORGJOB_SAVE_SQL);
// }
// }
if(newUsers.containsKey(temp.getUserNo()))//已经添加过的用户不处理
{
continue;
}
newUsers.put(temp.getUserNo(), dump);
saveSize ++;
addPreBatch(userSavePre, userOrgSavePre, userJobOrgSavePre, temp, newUsers,fixeduserorginfos,false);
if (saveSize > BATCH_LIMIT) {
saveSize = 0;
userSavePre.executePreparedBatch();
userSavePre = new PreparedDBUtil();
userSavePre.setBatchOptimize(false);
userSavePre.preparedUpdate(USER_SAVE_SQL);
userOrgSavePre.executePreparedBatch();
userOrgSavePre = new PreparedDBUtil();
userOrgSavePre.setBatchOptimize(false);
userOrgSavePre.preparedUpdate(USERORG_SAVE_SQL);
userJobOrgSavePre.executePreparedBatch();
userJobOrgSavePre = new PreparedDBUtil();
userJobOrgSavePre.setBatchOptimize(false);
userJobOrgSavePre.preparedUpdate(USERORGJOB_SAVE_SQL);
}
}
}
if (saveSize > 0) {
userSavePre.executePreparedBatch();
userOrgSavePre.executePreparedBatch();
userJobOrgSavePre.executePreparedBatch();
};
if (updateSize > 0) {
userUpdatePre.executePreparedBatch();
userOrgUpdatePre.executePreparedBatch();
userJobOrgUpdatePre.executePreparedBatch();
};
tm.commit();
} catch (Throwable e) {
isfailed = true;
error = StringUtil.formatBRException(e);
logger.error("initialData error", e);
}
finally
{
tm.release();
}
} catch (Exception e) {
isfailed = true;
error = error + " users) {
if(users.size() == 1)
return users.get(0);
for(MdmUser user:users)
{
if(user.getUserId().indexOf("_") < 0 && user.getUserId().indexOf("-") < 0)
{
return user;
}
}
return users.get(0);
}
private void addPreBatch(PreparedDBUtil userPre, PreparedDBUtil userOrgPre, PreparedDBUtil userJobOrgPre,
MdmUser temp,Map newUsers,Map fixeduserorginfos,boolean update) throws Exception {
String userNo = exchange(temp.getUserNo());
String userType = "1";
userPre.setString(1, userNo);
if (temp.getUserId() == null || temp.getUserId().equals("")) {
userPre.setString(2, temp.getUserNo());
userType = "2";
} else {
userPre.setString(2, temp.getUserId());
}
if(!update)
{
userPre.setString(3, USER_PS);
userPre.setString(4, temp.getFirstName() + temp.getLastName());
if (temp.getSex()!= null && !temp.getSex().trim().equals("")) {
userPre.setString(5, SEX[Integer.parseInt(temp.getSex().trim())]);
} else {
userPre.setString(5, "");
}
userPre.setString(6, temp.getTelephone());
userPre.setString(7, temp.getUserNo());
userPre.setString(8, temp.getMobile());
if (temp.getBrithday()!= null) {
userPre.setDate(9, temp.getBrithday());
} else {
userPre.setNull(9, java.sql.Types.DATE);
}
userPre.setString(10, temp.getIdCard());
userPre.setInt(11, 2);
userPre.setString(12, userType);
userPre.setString(13, temp.getUserNo());
}
else
{
// userPre.setString(3, USER_PS);
userPre.setString(3, temp.getFirstName() + temp.getLastName());
if (temp.getSex()!= null && !temp.getSex().trim().equals("")) {
userPre.setString(4, SEX[Integer.parseInt(temp.getSex().trim())]);
} else {
userPre.setString(4, "");
}
userPre.setString(5, temp.getTelephone());
userPre.setString(6, temp.getUserNo());
userPre.setString(7, temp.getMobile());
if (temp.getBrithday()!= null) {
userPre.setDate(8, temp.getBrithday());
} else {
userPre.setNull(8, java.sql.Types.DATE);
}
userPre.setString(9, temp.getIdCard());
//userPre.setInt(10, 2);
// if(!this.updateusertype)
// {
//userPre.setString(11, userType);
// userPre.setString(10, temp.getUserNo());
// }
// else
// {
userPre.setString(10, userType);
userPre.setString(11, temp.getUserNo());
// }
}
userPre.addPreparedBatch();
if (temp.getOrg() != null && !temp.getOrg().equals("")) {
// if(userOrgKeySet.contains(userNo) || orguserinsert.containsKey(userNo))
// {
// userOrgPre.setString(1, temp.getOrg());
// userOrgPre.setString(2, temp.getUserNo());
// userOrgPre.addPreparedBatch();
// }
// else
{
// if(newUsers.containsKey(temp.getUserNo()))
// {
// if(temp.getUserId().indexOf('_') < 0)
// {
// SQLExecutor.delete(exist_org_user, userNo);
// // userOrgPre.preparedInsert(USERORG_SAVE_SQL);
// userOrgPre.setString(1, temp.getOrg());
// userOrgPre.setString(2, temp.getUserNo());
// userOrgPre.addPreparedBatch();
// }
// }
// else
{
String orgid = fixeduserorginfos.get(userNo);
if(orgid == null)
{
SQLExecutor.delete(exist_org_user, userNo);
//userOrgPre.preparedInsert(USERORG_SAVE_SQL);
userOrgPre.setString(1, temp.getOrg());
userOrgPre.setString(2, temp.getUserNo());
userOrgPre.addPreparedBatch();
}
}
}
if (temp.getPosition() != null && !temp.getPosition().equals("")) {
// if(userJobOrgKeySet.contains(userNo) || orgjobuserinsert.containsKey(userNo))
// {
// userJobOrgPre.setString(1, temp.getOrg());
// userJobOrgPre.setString(2, temp.getPosition());
// userJobOrgPre.setString(3, temp.getUserNo());
// userJobOrgPre.addPreparedBatch();
// }
// else
{
// if(newUsers.containsKey(temp.getUserNo()))
// {
// if(temp.getUserId().indexOf('_') < 0)
// {
// SQLExecutor.delete(exist_org_job_user, userNo);
//// userJobOrgPre.preparedInsert(USERORGJOB_SAVE_SQL);
// userJobOrgPre.setString(1, temp.getOrg());
// userJobOrgPre.setString(2, temp.getPosition());
// userJobOrgPre.setString(3, temp.getUserNo());
// userJobOrgPre.addPreparedBatch();
// }
// }
// else
{
// userJobOrgPre.preparedInsert(USERORGJOB_SAVE_SQL);
String orgid = fixeduserorginfos.get(userNo);
if(orgid == null)
{
SQLExecutor.delete(exist_org_job_user, userNo);
userJobOrgPre.setString(1, temp.getOrg());
userJobOrgPre.setString(2, temp.getPosition());
userJobOrgPre.setString(3, temp.getUserNo());
userJobOrgPre.addPreparedBatch();
}
}
}
}
}
}
private String exchange(String temp) {
if (temp != null && !temp.equals("")) {
for (int i = 0; i < temp.length(); i ++) {
if (temp.charAt(i) != '0') {
return temp.substring(i);
}
}
}
return temp;
}
public static void main(String[] args) {
SyncUserInfo test = (SyncUserInfo) MDPropertiesUtil.getBeanObject("masterdata.hr.syncUserInfo");
test.syncAllData();
}
public boolean isDeleteremoveduser() {
return deleteremoveduser;
}
public void setDeleteremoveduser(boolean deleteremoveduser) {
this.deleteremoveduser = deleteremoveduser;
}
}
