在前台非企业域管理员如何添加用户进去并且导入用户 Excel 导入 部门选择框 部门名称

部门导入只识别ID。写部门名称无效，在excel导入配置里，写入值脚本，通过部门名获取ID。参考以下脚本。

1. var bb= getItemValueAsString("dept");
   
2. if(bb!= null || bb!= "" ){
   
3.      var sql="select Id from t_department where name='"+bb+"' ";
   
4. var q=queryByDSName("ems",sql);
   
5. var zhi100="";
   
6. if(q!=null){
   
7.     for(var a=q.iterator();a.hasNext();){
   
8.         var b=a.next();
   
9.         zhi100=b.get("id");
   
10. println("zhi222222222222"+zhi100);
    
11.     }
    
12. }
    
13. 
    
14. 
    
15. }
    
16. zhi100;
    
17. println("zh10000000"+zhi100);
    

复制代码

在导入excel操作按钮的只读条件中，查询出当前lastmodified字段中最大的时间
参考以下脚本：

1. var sql="select max(LASTMODIFIED) from tlk_人员管理";
   
2. var datas=queryByDSName("emss",sql);
   
3. var date_max_k=datas.get(0).get("MAX(LASTMODIFIED)");
   
4. GLOBAL_MAP.put("date_max_k",date_max_k);//创建系统全局缓存

复制代码

在动作执行后脚本：查询大于最大时间的数据并插入相应表：
参考以下脚本：

1. println("zhi10010101011"+zhi100);
   
2. var aa=GLOBAL_MAP.get("date_max_k");
   
3. println("aaasddddddsessionmget---"+aa);
   
4. var sql="select * from tlk_人员管理 where LASTMODIFIED>'"+aa+"'";
   
5. println("zhaoaoaoao------"+sql);
   
6. var q=queryByDSName("emss",sql);
   
7. println("qqqqqqqqqq"+q);
   
8. 
   
9. if(q.size()>0){
   
10.     for(var a=q.iterator();a.hasNext();){
    
11.         var b=a.next();
    
12.        var  zhi1=b.get("item_账户名");
    
13.         var  zhi2=b.get("item_name");
    
14.          var zhi3=b.get("item_cell");
    
15.          var zhi4=b.get("item_zhiwu");
    
16.        var  zhi5=b.get("item_dept");
    
17.      var  zhi6=b.get("item_idd");
    
18. var uuid1 = new Packages.java.util.UUID.randomUUID().toString();
    
19. var uuid2 = new Packages.java.util.UUID.randomUUID().toString();
    
20. var sql1 = "INSERT INTO t_user(ID, CALENDAR,LEVELS,REMARKS,SUPERIOR,PROXYUSER,DEFAULTDEPARTMENT, DEFAULTAPPLICATION,EMAIL,LOGINNO,LOGINPWD,NAME,TELEPHONE,STATUS,DOMAINID,ISDOMAINUSER,STARTPROXYTIME,ENDPROXYTIME,USEIM,ORDERBYNO,LASTMODIFYPASSWORDTIME,PASSWORDARRAY,LOCKFLAG,PUBLICKEY,DIMISSION,AVATAR,FAVORITE_CONTACTS,PERMISSION_TYPE,LIAISON_OFFICER,TELEPHONE2,TELEPHONEPUBLIC,TELEPHONEPUBLIC2,EMAILPUBLIC,USERINFOPUBLIC,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7,FIELD8,FIELD9,FIELD10) VALUES ('"+zhi6+"', '11e6-701c-227fe140-a997-fb9203092a74', 0, NULL, NULL, NULL, '"+zhi100+"', '11e6-7018-90eb8965-a997-fb9203092a74', '', '"+zhi1+"', 'd5a1fefd128e3db7c5a38c93ff1bbe839b2baee785fd4690', '"+zhi2+"', '"+zhi3+"', 1, '11e6-701c-2268619e-a997-fb9203092a74', 'false', NULL, NULL, 0, 0, NULL, NULL, 1, NULL, 1, NULL, NULL, 'public', 0, '', 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)";
    
21. insertByDSName("ems",sql1);
    
22. 
    
23. var sql2 = "insert into t_user_department_set values('"+uuid1+"','"+zhi100+"','"+zhi6+"')";
    
24. println("sql222222222"+sql2);
    
25. insertByDSName("ems",sql2);
    
26. if(zhi4.equals("设备管理员")&&zhi100.equals("11e6-725c-ede45276-bb6e-4142e33b7c89")){
    
27. var sql5= "insert into t_user_role_set values('"+uuid2+"','11e6-7990-b862257b-acbc-c790dc036150','"+zhi6+"')";
    
28. println("sql33333333"+sql5);
    
29. insertByDSName("ems",sql5);}
    
30. else if(zhi4.equals("设备管理员")&&zhi100.equals("11e6-73d7-25568a85-affc-97c9a7db150b")){
    
31. var sql5= "insert into t_user_role_set values('"+uuid2+"','11e6-73d0-5bfb0cd8-affc-97c9a7db150b','"+zhi6+"')";
    
32. println("sql33333333"+sql5);
    
33. insertByDSName("ems",sql5);}
    
34. else{
    
35. var sql4 = "insert into t_user_role_set values('"+uuid2+"','11e6-766b-8b094f6e-9f75-896c9ccdd2b0','"+zhi6+"')";
    
36. println("sql444444------------------------"+sql4);
    
37. insertByDSName("ems",sql4);}
    
38. 
    
39.     }
    
40. }
    

复制代码