ziguang/websrc/com/kingdee/shr/customer/synosf/OAGetAdminOrgDataService.java

package com.kingdee.shr.customer.synosf;

import com.kingdee.bos.BOSException;
import com.kingdee.bos.Context;
import com.kingdee.bos.bsf.service.app.IHRMsfService;
import com.kingdee.bos.dao.ormapping.ObjectUuidPK;
import com.kingdee.eas.base.permission.PermItemFactory;
import com.kingdee.eas.base.permission.PermItemInfo;
import com.kingdee.eas.base.permission.UserFactory;
import com.kingdee.eas.base.permission.UserInfo;
import com.kingdee.eas.common.EASBizException;
import com.kingdee.eas.hr.emp.EmployeeInterfacePermBizException;
import com.kingdee.eas.util.app.ContextUtil;
import com.kingdee.eas.util.app.DbUtil;
import com.kingdee.jdbc.rowset.IRowSet;
import com.kingdee.shr.base.permission.api.service.SHRFunctionPermissionService;
import com.kingdee.shr.integration.oa.util.IntegrateOAUtil;
import com.kingdee.shr.integration.oa.util.MappingFieldInfo;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;



/**
 * 获取组织数据
 * @author coyle
 * 202601
 */
public class OAGetAdminOrgDataService implements IHRMsfService {
	private static final Logger logger = LoggerFactory.getLogger(OAGetAdminOrgDataService.class);

	public Object process(Context ctx, Map param) throws EASBizException, BOSException {
		logger.error("InteOAGetAdminOrgDataService enter ");
		new ArrayList();
		String adminPermItem = "fffffff0-ffff-efff-e22e-0000000dfa21PERMITEM";
		PermItemInfo permItem = PermItemFactory.getLocalInstance(ctx).getPermItemInfo(new ObjectUuidPK(adminPermItem));

		try {
			SHRFunctionPermissionService.checkCurrnetUserFunctionPermission(ctx, permItem);
		} catch (Exception var9) {
			logger.error(var9.getMessage(), var9);
			String userId = ContextUtil.getCurrentUserInfo(ctx).getId().toString();
			UserInfo userInfo = UserFactory.getLocalInstance(ctx).getUserInfo(new ObjectUuidPK(userId));
			throw new EmployeeInterfacePermBizException(EmployeeInterfacePermBizException.NO_FUNCTION_PERMISSION,
					new Object[]{userInfo.getName(), permItem.getAlias()});
		}

		List<MappingFieldInfo> fieldList = this.initMappingField();
		StringBuffer sql = IntegrateOAUtil.getSelectFieldSql(fieldList);
		sql.append(" from t_org_admin org ");
		sql.append("  left join t_org_admin parent on parent.fid=org.FParentID ");
		sql.append("  left join  T_HR_SHRAdminOrgUnitExtend  ext  on  org.fid = ext.fadminorgunitid  ");
		sql.append("  left join T_bd_person  dirpp on  ext.cfdirectorid = dirpp.fid  ");
		sql.append("  left join T_bd_person  asspp on  ext.cfAssistantid = asspp.fid  ");
		sql.append("  left join T_bd_person  manapp on  ext.cfmanagerid = manapp.fid  ");
		sql.append("  left join T_bd_person  depatpp on  ext.cfResponsibleLeaderid = depatpp.fid  ");
		sql.append("  left join T_bd_person  ministerpp on  ext.cfMinisterid = ministerpp.fid  ");
		sql.append("  left join t_org_admin  comp on  org.FCompanyID = comp.fid  ");

		sql.append(" where org.FIsStartSHR=1");
		sql.append(" order by org.flongNumber,org.FIndex asc");
		System.out.print("sql:"+sql.toString() );
		IRowSet rs = DbUtil.executeQuery(ctx, sql.toString());
		List<HashMap<String, String>> dataList = IntegrateOAUtil.getRsListData(fieldList, rs);
		return dataList;
	}

	private List<MappingFieldInfo> initMappingField() {
		List<MappingFieldInfo> list = new ArrayList();
		MappingFieldInfo fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("easdept_id");
//		fieldInfo.setShrField("org.fid");
//		list.add(fieldInfo);
//
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("endflag");
//		fieldInfo.setShrField("org.FIsLeaf");
//		list.add(fieldInfo);
//
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("fcreateTime");
//		fieldInfo.setShrField("org.fcreateTime");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("flastUpdateTime");
//		fieldInfo.setShrField("org.FLastUpdateTime");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("supFnumber");
//		fieldInfo.setShrField("parent.FNumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("fEffectDate");
//		fieldInfo.setShrField("org.FEffectDate");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("simpleName");
//		fieldInfo.setShrField("org.FsimpleName");
//		list.add(fieldInfo);



		//name	组织名称	 
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("name");
		fieldInfo.setShrField("org.fname_l2");
		list.add(fieldInfo);
		//number	组织编码	 
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("fnumber");
		fieldInfo.setShrField("org.FNumber");
		list.add(fieldInfo);
		//parentNumber	上级行政组织编码	 
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("parentNumber");
		fieldInfo.setShrField("parent.fnumber");
		list.add(fieldInfo);
		//sortCode	排序 
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("sortCode");
		fieldInfo.setShrField("org.fSortCode");
		list.add(fieldInfo);
		//status	是否封存
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("status");
		fieldInfo.setShrField("org.FIsSealUp");
		list.add(fieldInfo);
		//isBranch	是否分部	  //unitLayerType	组织层级类型：1-总部，2-分部，3-部门，4-小组
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("isBranch");
		fieldInfo.setShrField("CASE  WHEN org.FID = comp.FID  THEN  '是'  ELSE  '否'  END  ");
		list.add(fieldInfo);
		//branchNubmer
		fieldInfo = new MappingFieldInfo();
		fieldInfo.setOaField("branchNubmer");
		fieldInfo.setShrField("comp.fnumber");
		list.add(fieldInfo);




//		 CASE  WHEN ext.cfisBranch = 1 THEN org.FNumber ELSE N'' END BRANCHNUBMER
//		//Director	研究院院 
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("directorId");
//		fieldInfo.setShrField("dirpp.fid");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("directorNum");
//		fieldInfo.setShrField("dirpp.fnumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("directorName");
//		fieldInfo.setShrField("dirpp.fname_l2");
//		list.add(fieldInfo);
//		//Assistant	部门助理	 
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("assistantId");
//		fieldInfo.setShrField("asspp.fid");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("assistantNum");
//		fieldInfo.setShrField("asspp.fnumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("assistantName");
//		fieldInfo.setShrField("asspp.fname_l2");
//		list.add(fieldInfo);
//		//manager	部门负 
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("manager");
//		fieldInfo.setShrField("manapp.fid");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("managerNum");
//		fieldInfo.setShrField("manapp.fnumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("managerName");
//		fieldInfo.setShrField("manapp.fname_l2");
//		list.add(fieldInfo);
//		//ResponsibleLeader	部门分管领导	 
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("departLeaderId");
//		fieldInfo.setShrField("depatpp.fid");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("departLeaderNum");
//		fieldInfo.setShrField("depatpp.fnumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("departLeaderName");
//		fieldInfo.setShrField("depatpp.fname_l2");
//		list.add(fieldInfo);
//		//Minister	部门部长	下拉
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("ministerId");
//		fieldInfo.setShrField("ministerpp.fid");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("ministerNum");
//		fieldInfo.setShrField("ministerpp.fnumber");
//		list.add(fieldInfo);
//		fieldInfo = new MappingFieldInfo();
//		fieldInfo.setOaField("ministerName");
//		fieldInfo.setShrField("ministerpp.fname_l2");




		return list;
	}
}