| | |
| | | import lombok.AllArgsConstructor; |
| | | import org.springblade.common.cache.DictCache; |
| | | import org.springblade.common.cache.ParamCache; |
| | | import org.springblade.common.config.FtpConfig; |
| | | import org.springblade.common.enums.DictEnum; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springblade.core.cache.utils.CacheUtil; |
| | |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.support.Kv; |
| | | import org.springblade.core.tool.utils.DigestUtil; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.FTP.FtpUtil; |
| | | import org.springblade.modules.information.entity.Information; |
| | |
| | | user.setTenantId("000000"); |
| | | user.setAccount(record.getEnterprisename()); |
| | | String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD); |
| | | user.setPassword(initPassword); |
| | | user.setPassword(DigestUtil.encrypt(initPassword)); |
| | | //user.setPassword(initPassword); |
| | | user.setCreateTime(new Date()); |
| | | user.setUpdateTime(new Date()); |
| | | user.setRoleId("1414575196264300546"); |
| | |
| | | String s = "insert into sys_information(id,creditCode,enterpriseName,representative" + |
| | | ",registeredCapital,organizationCode,registrationNumber, enterprises, address," + |
| | | " business,region,registration,industry,departmentid,stats,jurisdiction,representativecell," + |
| | | "contacts,contactscell,create_time,create_user_id) " + |
| | | "contacts,contactscell,create_user_id) " + |
| | | "values(" + "'" + information.getId() + "'" + |
| | | "," + "'" + information.getCreditcode() + "'" + |
| | | "," + "'" + information.getEnterprisename() + "'" + |
| | |
| | | "," + "'" + information.getRepresentativecell() + "'" + |
| | | "," + "'" + information.getContacts() + "'" + |
| | | "," + "'" + information.getContactscell() + "'" + |
| | | "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(information.getCreateTime()) + "'" + |
| | | "," + "'" + information.getCreateUserId() + "'" + ");" + |
| | | "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + information.getDepartmentid() + "'" + "," + "'" + dept.getParentId() + "'" + "," |
| | | "," + "'" + information.getCreateUserId() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | String ss = "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + dept.getId() + "'" + "," + "'" + dept.getParentId() + "'" + "," |
| | | + "'" + dept.getTenantId() + "'" + |
| | | "," + "'" + information.getEnterprisename() + "'" + |
| | | "," + "'" + dept.getAncestors() + "'" + |
| | | "," + "'" + dept.getDeptCategory() + "'" + |
| | | "," + "'" + isDeleted + "'" + ");" + |
| | | "insert into blade_user(id,tenant_id,account,password,role_id,dept_id,create_time,update_time,status,is_deleted) " + |
| | | "," + "'" + isDeleted + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(ss); |
| | | String rtime; |
| | | String paperTime; |
| | | if (user.getRtime() == null) { |
| | | rtime = null; |
| | | } else { |
| | | rtime = new SimpleDateFormat("yyyy-MM-dd").format(user.getRtime()); |
| | | } |
| | | //发证日期处理 |
| | | if (user.getPaperTime() == null) { |
| | | paperTime = ""; |
| | | } else { |
| | | paperTime = new SimpleDateFormat("yyyy-MM-dd").format(user.getPaperTime()); |
| | | } |
| | | //头像 |
| | | if (null != user.getAvatar() && !user.getAvatar().equals("")) { |
| | | user.setAvatar(FtpConfig.ip + user.getAvatar().substring(26)); |
| | | } |
| | | |
| | | //指纹 |
| | | if (null != user.getFingerprint() && !user.getFingerprint().equals("")) { |
| | | user.setFingerprint(FtpConfig.ip + user.getFingerprint().substring(26)); |
| | | } |
| | | |
| | | String sss = "insert into blade_user(" + |
| | | "id,tenant_id,account,password,name,real_name,avatar,email,phone,sex," + |
| | | "role_id,dept_id,cardid,nativePlace,nation,fingerprint,education," + |
| | | "politicaloutlook,healstats,height,address,registered,rtime," + |
| | | "securitynumber,hold,jurisdiction,examination_type,status,is_deleted,dispatch) " + |
| | | "values(" + "'" + user.getId() + "'" + |
| | | "," + "'" + user.getTenantId() + "'" |
| | | + "," + "'" + user.getAccount() + "'" + |
| | | "," + "'" + user.getTenantId() + "'" + |
| | | "," + "'" + user.getAccount() + "'" + |
| | | "," + "'" + user.getPassword() + "'" + |
| | | "," + "'" + user.getName() + "'" + |
| | | "," + "'" + user.getRealName() + "'" + |
| | | "," + "'" + user.getAvatar() + "'" + |
| | | "," + "'" + user.getEmail() + "'" + |
| | | "," + "'" + user.getPhone() + "'" + |
| | | "," + "'" + null + "'" + |
| | | "," + "'" + roleid + "'" + |
| | | "," + "'" + user.getDeptId() + "'" + |
| | | "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getCreateTime()) + "'" + |
| | | "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'" + |
| | | "," + "'" + user.getCardid() + "'" + |
| | | "," + "'" + user.getNativeplace() + "'" + |
| | | "," + "'" + user.getNation() + "'" + |
| | | "," + "'" + user.getFingerprint() + "'" + |
| | | "," + "'" + user.getEducation() + "'" + |
| | | "," + "'" + user.getPoliticaloutlook() + "'" + |
| | | "," + "'" + user.getHealstats() + "'" + |
| | | "," + "'" + user.getHeight() + "'" + |
| | | "," + "'" + user.getAddress() + "'" + |
| | | "," + "'" + user.getRegistered() + "'" + |
| | | "," + "'" + rtime + "'" + |
| | | "," + "'" + user.getSecuritynumber() + "'" + |
| | | "," + "'" + user.getHold() + "'" + |
| | | "," + "'" + user.getJurisdiction() + "'" + |
| | | "," + "'" + user.getExaminationType() + "'" + |
| | | "," + "'" + user.getStatus() + "'" + |
| | | "," + "'" + user.getIsDeleted() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | "," + "'" + user.getIsDeleted() + "'" + |
| | | "," + "'" + user.getDispatch() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(sss); |
| | | // Integer isDeleted = 0; |
| | | // //注册用户 |
| | | // User user = new User(); |
| | | // user.setDeptId(information.getDepartmentid()); |
| | | // user.setTenantId("000000"); |
| | | // user.setAccount(record.getEnterprisename()); |
| | | // String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD); |
| | | // user.setPassword(initPassword); |
| | | // user.setCreateTime(new Date()); |
| | | // user.setUpdateTime(new Date()); |
| | | // user.setRoleId("1414575196264300546"); |
| | | // user.setStatus(1); |
| | | // user.setIsDeleted(0); |
| | | // userService.save(user); |
| | | // String roleid = "1415563428727328770"; |
| | | // String s = "insert into sys_information(id,creditCode,enterpriseName,representative" + |
| | | // ",registeredCapital,organizationCode,registrationNumber, enterprises, address," + |
| | | // " business,region,registration,industry,departmentid,stats,jurisdiction,representativecell," + |
| | | // "contacts,contactscell,create_time,create_user_id) " + |
| | | // "values(" + "'" + information.getId() + "'" + |
| | | // "," + "'" + information.getCreditcode() + "'" + |
| | | // "," + "'" + information.getEnterprisename() + "'" + |
| | | // "," + "'" + information.getRepresentative() + "'" + |
| | | // "," + "'" + information.getRegisteredcapital() + "'" + |
| | | // "," + "'" + information.getOrganizationcode() + "'" + |
| | | // "," + "'" + information.getRegistrationnumber() + "'" + |
| | | // "," + "'" + information.getEnterprises() + "'" + |
| | | // "," + "'" + information.getAddress() + "'" + |
| | | // "," + "'" + information.getBusiness() + "'" + |
| | | // "," + "'" + information.getRegion() + "'" + |
| | | // "," + "'" + information.getRegistration() + "'" + |
| | | // "," + "'" + information.getIndustry() + "'" + |
| | | // "," + "'" + information.getDepartmentid() + "'" + |
| | | // "," + "'" + information.getStats() + "'" + |
| | | // "," + "'" + information.getJurisdiction() + "'" + |
| | | // "," + "'" + information.getRepresentativecell() + "'" + |
| | | // "," + "'" + information.getContacts() + "'" + |
| | | // "," + "'" + information.getContactscell() + "'" + |
| | | // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(information.getCreateTime()) + "'" + |
| | | // "," + "'" + information.getCreateUserId() + "'" + ");" + |
| | | // "insert into blade_dept(id,parent_id,tenant_id,dept_name,ancestors,dept_category,is_deleted) values(" + "'" + information.getDepartmentid() + "'" + "," + "'" + dept.getParentId() + "'" + "," |
| | | // + "'" + dept.getTenantId() + "'" + |
| | | // "," + "'" + information.getEnterprisename() + "'" + |
| | | // "," + "'" + dept.getAncestors() + "'" + |
| | | // "," + "'" + dept.getDeptCategory() + "'" + |
| | | // "," + "'" + isDeleted + "'" + ");" + |
| | | // "insert into blade_user(id,tenant_id,account,password,role_id,dept_id,create_time,update_time,status,is_deleted) " + |
| | | // "values(" + "'" + user.getId() + "'" + |
| | | // "," + "'" + user.getTenantId() + "'" |
| | | // + "," + "'" + user.getAccount() + "'" + |
| | | // "," + "'" + user.getPassword() + "'" + |
| | | // "," + "'" + roleid + "'" + |
| | | // "," + "'" + user.getDeptId() + "'" + |
| | | // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getCreateTime()) + "'" + |
| | | // "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(user.getUpdateTime()) + "'" + |
| | | // "," + "'" + user.getStatus() + "'" + |
| | | // "," + "'" + user.getIsDeleted() + "'" + ")"; |
| | | // FtpUtil.sqlFileUpload(s); |
| | | // //注册用户 |
| | | // User user = new User(); |
| | | // user.setAccount(record.getEnterprisename()); |