java/meitianmeiya.git

			@@ -3,6 +3,8 @@
			import cn.hutool.core.collection.CollUtil;
			import cn.hutool.core.date.DateUtil;
			import cn.hutool.core.util.StrUtil;
			import cn.hutool.poi.excel.ExcelReader;
			import cn.hutool.poi.excel.ExcelUtil;
			import com.alibaba.fastjson.JSON;
			import com.baomidou.mybatisplus.enums.SqlLike;
			import com.baomidou.mybatisplus.mapper.EntityWrapper;
			@@ -17,10 +19,13 @@
			import com.sinata.core.common.annotion.BussinessLog;
			import com.sinata.core.common.annotion.Permission;
			import com.sinata.core.common.constant.factory.PageFactory;
			import com.sinata.core.common.exception.BizExceptionEnum;
			import com.sinata.core.exception.GunsException;
			import com.sinata.core.shiro.ShiroKit;
			import com.sinata.core.shiro.ShiroUser;
			import com.sinata.core.util.Convert;
			import com.sinata.core.util.ExcelExportUtil;
			import com.sinata.core.util.ExcelImportUtil;
			import com.sinata.core.util.SqlUtil;
			import com.sinata.modular.mall.model.MallOrder;
			import com.sinata.modular.mall.service.IMallOrderService;
			@@ -34,19 +39,25 @@
			import com.sinata.modular.system.service.IRoleService;
			import com.sinata.modular.system.service.ISystemNoticeService;
			import com.sinata.modular.system.service.ITCityRegionService;
			import java.io.IOException;
			import java.net.URLEncoder;
			import javax.servlet.ServletOutputStream;
			import lombok.extern.slf4j.Slf4j;
			import org.apache.poi.hssf.usermodel.HSSFWorkbook;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.stereotype.Controller;
			import org.springframework.ui.Model;
			import org.springframework.util.StringUtils;
			import org.springframework.web.bind.annotation.PathVariable;
			import org.springframework.web.bind.annotation.RequestMapping;
			import org.springframework.web.bind.annotation.RequestMethod;
			import org.springframework.web.bind.annotation.ResponseBody;

			import javax.servlet.http.HttpServletResponse;
			import java.math.BigDecimal;
			import java.util.*;
			import java.util.stream.Collectors;
			import org.springframework.web.multipart.MultipartFile;

			/**
			* 会员用户信息控制器
			@@ -489,6 +500,7 @@
			+ ", agent_province_code = " + SqlUtil.addSingleQuotes(province)
			+ ", agent_city_code = " + SqlUtil.addSingleQuotes(city)
			+ ", agent_county_code = " + SqlUtil.addSingleQuotes(county);
			log.info("用户：{}修改了营销员城市地址",memUser.getRealName());
			}
			}

			@@ -798,7 +810,7 @@
			+ ", agent_province_code = " + SqlUtil.addSingleQuotes(province)
			+ ", agent_city_code = " + SqlUtil.addSingleQuotes(city)
			+ ", agent_county_code = " + SqlUtil.addSingleQuotes(county);

			log.info("用户：{}修改了营销员城市地址",userIdList.toString());
			boolean flag = memUserService.updateForSet(whereSql, new EntityWrapper<MemUser>().in("id", userIdList));
			return returnByFlag(flag, null);
			}
			@@ -828,5 +840,55 @@
			return new ErrorTip(500, StrUtil.isNotBlank(msg) ? msg : "操作失败！");
			}
			}
			@Permission
			@ResponseBody
			@BussinessLog(value = "营销人员管理-下载导入模板")
			@RequestMapping(value = "/downloadTemplate",method = RequestMethod.POST)
			public Object downloadTemplate(HttpServletResponse response) {
			// // 表格数据【封装】
			// List<List<Object>> dataList = new ArrayList<>();
			// // 头部列【封装】
			// List<Object> shellList = new ArrayList<>();
			// shellList.add("姓名");
			// shellList.add("手机号");
			// shellList.add("性别");
			// shellList.add("生日例：2024-06-06");
			// shellList.add("证件类型 0身份证 1护照");
			// shellList.add("身份证号");
			// shellList.add("银行名称");
			// shellList.add("银行卡号");
			// shellList.add("推荐人手机号");
			// dataList.add(shellList);
			// try {
			// ExcelExportUtil.easySheet(URLEncoder.encode("营销人员导入模板", "UTF-8"),"sheet1",dataList,response);
			// } catch (IOException e) {
			// throw new RuntimeException(e);
			// }
			String url = "https://meitianmeiya.obs.cn-southwest-2.myhuaweicloud.com/excel/%E8%90%A5%E9%94%80%E4%BA%BA%E5%91%98%E5%AF%BC%E5%85%A5%E6%A8%A1%E6%9D%BF.xls";
			return new SuccessTip(200, url);
			}
			@Permission
			@ResponseBody
			@BussinessLog(value = "营销人员管理-导入")
			@RequestMapping(value = "/importSalesUser",method = RequestMethod.POST)
			public Object importUsers(MultipartFile file, HttpServletResponse response) {
			String s = file.getOriginalFilename();

			if (s == null \|\| !("xls".equals(s.substring(s.lastIndexOf(".") + 1)) \|\| "xlsx".equals(s.substring(s.lastIndexOf(".") + 1)))) {
			return new ErrorTip(500,"只能上传.xls或.xlsx格式的文件！");
			}
			List<Map<String, String>> mapList = null;
			try {
			mapList = ExcelImportUtil.getMapList(file,
			new String[]{"姓名", "手机号", "性别","生日例：2024-06-06","证件类型 0身份证 1护照", "身份证号","银行名称","银行卡号","推荐人手机号","职级 3黄金营销员 4城市合伙人 5市场总监"});
			} catch (IOException e) {
			throw new RuntimeException(e);
			}
			String str = memUserService.importSalesUser(mapList, response);
			if (str == null) {
			return SUCCESS_TIP;
			} else {
			return new SuccessTip(201, str);
			}
			}
			}