<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html>
<html>
<head>
<jsp:include page="/static/common/head.jsp" flush="true"/>
<link rel="stylesheet" href="<%=basePath%>static/skin/css/base.css">
<script src="<%=basePath%>static/plugins/jQuery/jQuery-2.1.4.min.js"></script>
<script src="<%=basePath%>static/plugins/pace/pace.min.js"></script>
<script src="<%=basePath%>static/plugins/layer/layer.js"></script>
<script src="<%=basePath%>static/plugins/JQueryValidate/jquery.validate.min.js"></script>
<script src="<%=basePath%>static/plugins/JQueryValidate/localization/messages_zh.js"></script>
<script src="<%=basePath%>static/skin/js/common.js"></script>
<script type="text/javascript">
$(function(){
validateForm= $("#krtForm").validate();
//立即验证
validateForm.form();
$("#uploadBtn").click(function(){
$("#excelFile").click();
});
$("#uploadDiv").on("change","input[type='file']",function(){
var filePath=$(this).val();
if(filePath.indexOf("xls")!=-1 || filePath.indexOf("xlsx")!=-1){
$("#excelName").html(filePath);
}else{
top.layer.msg("您未上传文件，或者您上传文件类型有误！");
return false;
}
});
});
function doSubmit(){//回调函数，在编辑和保存动作时，供openDialog调用提交表单。
if(validateForm.form()){
$("#krtForm").submit();
}
}
var result = '${result}';
if(result!=null){
if(result=='success'){
top.layer.msg("导入成功");
setTimeout(function(){
refreshIframe();
var index = parent.layer.getFrameIndex(window.name);
parent.layer.close(index);
}, 1000);
}else if(result=='error'){
top.layer.msg("导入失败！");
}
}
</script>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
<div class="form-box">
<form action="<%=basePath %>admin/enterprise/info/enterprise_export_insert" method="post" enctype="multipart/form-data" id="krtForm" class="form-horizontal">
<div class="col-xs-12">
<div style="border:3px dashed #e6e6e6;margin:20px;min-height:240px;color: #cccccc;text-align: center;">
<div style="margin-top: 40px;" id="uploadDiv">
<i class="fa fa-cloud-upload fa-btn" style="color: #bbb;font-size: 70px;margin-bottom: 6px;display: block;"></i>
<button class="btn btn-primary btn-lg" id="uploadBtn" type="button">点击上传企业信息</button>
<span id="excelName" style="display: block;margin-top: 6px; color: #77777"></span>
<!-- file -->
<input type="file" name="excelFile" id="excelFile" style="display: none">
</div>
</div>
</div>
</form>
</div>
</div><!-- ./wrapper -->
</body>
</html>
/**
* 批量导入添加企业信息
*
* @param @param request
* @param @param file
* @param @return ReturnBean
* @author donghao
* @date 2016年10月20日 上午11:58:17
*/
@LogAop(description = "批量导入添加企业信息")
@RequiresPermissions("enterprise:export_insert")
@RequestMapping("admin/enterprise/info/enterprise_export_insert")
@ResponseBody
public ReturnBean enterprise_export_insert(HttpServletRequest request, @RequestParam("excelFile") MultipartFile file) {
ReturnBean rb;
// 导入参数设置
ImportParams params = new ImportParams();
params.setTitleRows(0);
params.setHeadRows(1);
params.setNeedSave(false);
try {
List<Enterprise_export> dataList = ExcelImportUtil.importExcel(file.getInputStream(), Enterprise_export.class, params);
System.out.println(dataList);
enterpriseService.insertExport(dataList);
rb = ReturnBean.getSuccessReturnBean();
} catch (Exception e) {
logger.error("添加企业信息失败", e);
rb = ReturnBean.getErrorReturnBean();
}
return rb;
}
/**
* 批量添加用户
* @param dataList 企业信息集合
* @throws Exception
*/
public void insertExport(List<Enterprise_export> dataList) throws Exception{
Enterprise enterprise = new Enterprise();
User user = new User();
for(int i = 0; i < dataList.size(); i++){
String uscc = Common.isBlank(dataList.get(i).getUscc());
String ename = Common.isBlank(dataList.get(i).getEname());
String legalName = Common.isBlank(dataList.get(i).getLegalName());
String legalPhone = Common.isBlank(dataList.get(i).getLegalPhone());
String linkMan = Common.isBlank(dataList.get(i).getLinkMan());
String linkPhone = Common.isBlank(dataList.get(i).getLinkPhone());
String address = Common.isBlank(dataList.get(i).getAddress());
String region = Common.isBlank(dataList.get(i).getRegion());
String industry = Common.isBlank(dataList.get(i).getIndustry());
String reg_type = Common.isBlank(dataList.get(i).getReg_type());
String affiliation = Common.isBlank(dataList.get(i).getAffiliation());
String industrial = Common.isBlank(dataList.get(i).getIndustrial());
String scale = Common.isBlank(dataList.get(i).getScale());
String industry_elec = Common.isBlank(dataList.get(i).getIndustry_elec());
String industry_food = Common.isBlank(dataList.get(i).getIndustry_food());
String industry_new = Common.isBlank(dataList.get(i).getIndustry_new());
String isGood = Common.isBlank(dataList.get(i).getIsGood());
String isPoint = Common.isBlank(dataList.get(i).getIsPoint());
address = address.endsWith("无") ? "" : address;
legalPhone = legalPhone.endsWith("无") ? "" : legalPhone;
legalName = legalName.endsWith("无") ? "" : legalName;
region = region.endsWith("无") ? "" : region;
isGood = "".equals(isGood) ? "0" : isGood ;
isPoint = "".equals(isPoint) ? "1" : isPoint ;
UUID uuid= UUID.randomUUID();
String uuids=uuid.toString().replace("-", "");
uuid = UUID.randomUUID();
String uuid_qy=uuid.toString();
enterprise.setUuid(uuid_qy);
enterprise.setUscc(uscc);
enterprise.setEname(ename);
enterprise.setLegalPhone(legalPhone);
enterprise.setLegalName(legalName);
enterprise.setLinkMan(linkMan);
enterprise.setLinkPhone(linkPhone);
enterprise.setAddress(address);
enterprise.setRegion(region);
enterprise.setIndustry(industry);
enterprise.setReg_type(reg_type);
enterprise.setAffiliation(affiliation);
enterprise.setIndustrial(industrial);
enterprise.setScale(scale);
enterprise.setIndustry_elec(industry_elec);
enterprise.setIndustry_food(industry_food);
enterprise.setIndustry_new(industry_new);
enterprise.setIsGood(isGood);
enterprise.setIsPoint(isPoint);
enterprise.setType("5,2,4,8,7,6,9,10,11");
//保存企业信息
insert(enterprise);
System.out.println("--------保存企业信息-----------");
//创建统一登录用户
user.setName(enterprise.getEname());
user.setUsername("jacom"+enterprise.getId());//自定义用户名
//user.setPassword(AESvbjavajs.getAESEncrypt("123456", Constant.PASS_KEY));//自定义密码
user.setPassword(MD5Utils.encoderByMd5With32Bit("123456"));
user.setStatus("0");
user.setUuid(uuids);
user.setRegion(region);
//保存统一登录用户和角色
userService.insert(user,Constant.ENT);
System.out.println("--------保存统一登录用户和角色-----------");
//保存企业云登陆用户和角色
YunUser yunUser = new YunUser();
yunUser.setAddress(enterprise.getAddress());
yunUser.setEnterpriceId(enterprise.getId());
yunUser.setImgSrcType("3");
yunUser.setName(enterprise.getEname());
yunUser.setPhone(enterprise.getLegalPhone());
yunUser.setRoleType("2");
yunUser.setSex(1);
yunUser.setState(1);
yunUser.setSystemSource("3");
yunUser.setTel(enterprise.getLegalPhone());
yunUser.setUuid(uuids);
yunUser.setUuid_qy(enterprise.getUuid());
yunUser.setAddTimes(new Date());
//userService.insertYun_user(yunUser);
System.out.println("--------保存企业云登陆用户和角色-----------");
//保存企业帮扶登陆用户和角色
Qyhelp_user qyhelp_user = new Qyhelp_user();
qyhelp_user.setDescription(enterprise.getEname());
qyhelp_user.setIs_login(0);
qyhelp_user.setState(1);
qyhelp_user.setT_id(enterprise.getId());
qyhelp_user.setT_lx(1);
qyhelp_user.setT_name(enterprise.getEname());
qyhelp_user.setUuid(uuids);
qyhelp_user.setUuid_qy(enterprise.getUuid());
//userService.insertQyhelp_user(qyhelp_user);
System.out.println("--------保存企业帮扶登陆用户和角色-----------");
enterprise.setId(null);
user.setId(null);
//同步至企业精准帮扶内企业的信息
// PropertyUtil p = new PropertyUtil("port.properties");
// JSONObject ent = new JSONObject();
// ent.put("name", enterprise.getEname());//企业名称
// ent.put("credit_code", enterprise.getUscc());//统一社会信用代码
// ent.put("county", enterprise.getRegion());//地区编码
// ent.put("address", enterprise.getAddress());//详细地址
// ent.put("lat", enterprise.getLat());
// ent.put("lng", enterprise.getLng());
// ent.put("description", enterprise.getProfile());//公司简介
// ent.put("updateTime", enterprise.getUpdateTime());
// ent.put("uuid", enterprise.getUuid());
//
// ent.put("legal_code", enterprise.getLegal_code());//企业法人代码/组织机构代码
// ent.put("postcode", enterprise.getPostcode());//邮政编码
// ent.put("room_tel", enterprise.getEphone());//企业办公室电话
// ent.put("legal_man", enterprise.getLinkMan());//企业主要负责人姓名
// ent.put("legal_mobile", enterprise.getLinkPhone());//企业主要负责人移动电话
// ent.put("is_point", enterprise.getIsPoint());//是否规上企业
//// 图片地址 imgSrc(img)
// String rs = SendPost.send("http://111.75.240.74:56794/port/sendCompanyInfo", p.getValue("tokenUrl"), p.getValue("tag"),p.getValue("key"), "{"+"\"data\":"+"["+ent.toString()+"]}");
// logger.error(rs);
}
}
