package org.jeecg.modules.demo.customer.controller;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
import java.io.IOException;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLDecoder;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import jakarta.servlet.http.HttpServletRequest;
|
import jakarta.servlet.http.HttpServletResponse;
|
import org.jeecg.common.api.vo.Result;
|
import org.jeecg.common.system.query.QueryGenerator;
|
import org.jeecg.common.system.query.QueryRuleEnum;
|
import org.jeecg.common.util.oConvertUtils;
|
import org.jeecg.modules.demo.contract.entity.Contract;
|
import org.jeecg.modules.demo.contract.entity.ContractFile;
|
import org.jeecg.modules.demo.contract.entity.SemanticWord;
|
import org.jeecg.modules.demo.contract.service.IContractFileService;
|
import org.jeecg.modules.demo.contract.service.IContractService;
|
import org.jeecg.modules.demo.contract.service.ISemanticWordService;
|
import org.jeecg.modules.demo.contract.vo.ContractPage;
|
import org.jeecg.modules.demo.customer.entity.Customer;
|
import org.jeecg.modules.demo.customer.service.ICustomerService;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import lombok.extern.slf4j.Slf4j;
|
|
import org.jeecg.modules.system.controller.SysUserController;
|
import org.jeecg.modules.system.entity.SysUser;
|
import org.jeecgframework.poi.excel.ExcelImportUtil;
|
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
|
import org.jeecgframework.poi.excel.entity.ExportParams;
|
import org.jeecgframework.poi.excel.entity.ImportParams;
|
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
|
import org.jeecg.common.system.base.controller.JeecgController;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.transaction.annotation.EnableTransactionManagement;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
import org.springframework.web.multipart.MultipartHttpServletRequest;
|
import org.springframework.web.servlet.ModelAndView;
|
import com.alibaba.fastjson.JSON;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import io.swagger.v3.oas.annotations.Operation;
|
import org.jeecg.common.aspect.annotation.AutoLog;
|
import org.apache.shiro.authz.annotation.RequiresPermissions;
|
/**
|
* @Description: 客户表
|
* @Author: jeecg-boot
|
* @Date: 2025-10-10
|
* @Version: V1.0
|
*/
|
@Tag(name="客户表")
|
@RestController
|
@RequestMapping("/customer/customer")
|
@Slf4j
|
public class CustomerController extends JeecgController<Customer, ICustomerService> {
|
@Autowired
|
private ICustomerService customerService;
|
|
/**
|
* 分页列表查询
|
*
|
* @param customer
|
* @param pageNo
|
* @param pageSize
|
* @param req
|
* @return
|
*/
|
//@AutoLog(value = "客户表-分页列表查询")
|
@Operation(summary="客户表-分页列表查询")
|
@GetMapping(value = "/list")
|
public Result<IPage<Customer>> queryPageList(Customer customer,
|
@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
|
@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
|
HttpServletRequest req) {
|
if (customer.getAgentsNameToCustomer() != null) {
|
// 1. 构建Lambda查询条件，指定查询enterpriseName字段并去重
|
LambdaQueryWrapper<Customer> queryWrapper = new LambdaQueryWrapper<Customer>()
|
.select(Customer::getEnterpriseName); // 关联实体的getter方法
|
|
// 可选：添加原有条件（如agentsName不为空）
|
queryWrapper.eq(Customer::getAgentsName,customer.getAgentsNameToCustomer());
|
queryWrapper.or();
|
queryWrapper.eq(Customer::getCreateBy,customer.getAgentsNameToCustomer());
|
|
// 2. 查询字段值，返回Object列表
|
List<Object> objList = customerService.listObjs(queryWrapper);
|
|
// 3. 转换为String类型，并过滤null值
|
if (CollectionUtils.isEmpty(objList)) {
|
return Result.ok(List.of().toString());
|
}
|
return Result.ok(objList.stream()
|
.filter(Objects::nonNull) // 过滤null值
|
.map(Object::toString) // 转换为String
|
.collect(Collectors.toList()).toString());
|
}
|
QueryWrapper<Customer> queryWrapper = QueryGenerator.initQueryWrapper(customer, req.getParameterMap());
|
Page<Customer> page = new Page<Customer>(pageNo, pageSize);
|
IPage<Customer> pageList = customerService.page(page, queryWrapper);
|
return Result.OK(pageList);
|
}
|
|
@Operation(summary="客户表-分页列表查询")
|
@GetMapping(value = "/listAgents")
|
public Result<IPage<Customer>> queryPageListDls() {
|
// 构建查询条件，只查询 agents_name 字段
|
QueryWrapper<Contract> queryWrapper = new QueryWrapper<>();
|
queryWrapper.select("agents_name"); // 指定查询字段（数据库字段名）
|
|
// 执行查询，获取所有 agents_name（可能包含重复值）
|
List<Contract> contractList = contractService.list(queryWrapper);
|
|
// 提取 agentsName 并去重（转为字符串列表）
|
List<String> agentsNames = contractList.stream()
|
.filter(contract -> contract != null) // 过滤null的Contract对象
|
.map(Contract::getAgentsName)
|
.filter(agentsName -> agentsName != null && !agentsName.isEmpty()) // 过滤null或空字符串
|
.distinct()
|
.collect(Collectors.toList()); // 第105行（示例）
|
|
return Result.OK(JSONObject.toJSONString(agentsNames));
|
}
|
|
@Autowired
|
private SysUserController sysUserController;
|
|
/**
|
* 添加
|
*
|
* @param customer
|
* @return
|
*/
|
@AutoLog(value = "客户表-添加")
|
@Operation(summary="客户表-添加")
|
@RequiresPermissions("customer:customer:add")
|
@PostMapping(value = "/add")
|
public Result<String> add(@RequestBody Customer customer) {
|
customerService.save(customer);
|
|
return Result.OK("添加成功！");
|
}
|
|
/**
|
* 编辑
|
*
|
* @param customer
|
* @return
|
*/
|
@AutoLog(value = "客户表-编辑")
|
@Operation(summary="客户表-编辑")
|
@RequiresPermissions("customer:customer:edit")
|
@RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
|
public Result<String> edit(@RequestBody Customer customer) {
|
QueryWrapper<Customer> qw = new QueryWrapper<>();
|
qw.eq("customer_name",customer.getEnterpriseName());
|
if (customerService.count(qw) > 0) {
|
return Result.error("重复的公司名称");
|
}
|
QueryWrapper<Contract> qwct = new QueryWrapper<>();
|
qwct.eq("customer_name",customer.getEnterpriseName());
|
List<Contract> list = contractService.list(qwct);
|
for (Contract contract : list) {
|
contract.setCustomerName(customer.getEnterpriseName());
|
contractService.updateById(contract);
|
}
|
customerService.updateById(customer);
|
return Result.OK("编辑成功!");
|
}
|
|
/**
|
* 通过id删除
|
*
|
* @param id
|
* @return
|
*/
|
@AutoLog(value = "客户表-通过id删除")
|
@Operation(summary="客户表-通过id删除")
|
@RequiresPermissions("customer:customer:delete")
|
@DeleteMapping(value = "/delete")
|
public Result<String> delete(@RequestParam(name="id",required=true) String id) {
|
customerService.removeById(id);
|
return Result.OK("删除成功!");
|
}
|
|
/**
|
* 批量删除
|
*
|
* @param ids
|
* @return
|
*/
|
@AutoLog(value = "客户表-批量删除")
|
@Operation(summary="客户表-批量删除")
|
@RequiresPermissions("customer:customer:deleteBatch")
|
@DeleteMapping(value = "/deleteBatch")
|
public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
|
this.customerService.removeByIds(Arrays.asList(ids.split(",")));
|
return Result.OK("批量删除成功!");
|
}
|
|
/**
|
* 通过id查询
|
*
|
* @param id
|
* @return
|
*/
|
//@AutoLog(value = "客户表-通过id查询")
|
@Operation(summary="客户表-通过id查询")
|
@GetMapping(value = "/queryById")
|
public Result<Customer> queryById(@RequestParam(name="id",required=true) String id) {
|
Customer customer = customerService.getById(id);
|
if(customer==null) {
|
return Result.error("未找到对应数据");
|
}
|
return Result.OK(customer);
|
}
|
|
/**
|
* 导出excel
|
*
|
* @param request
|
* @param customer
|
*/
|
@RequiresPermissions("customer:customer:exportXls")
|
@RequestMapping(value = "/exportXls")
|
public ModelAndView exportXls(HttpServletRequest request, Customer customer) {
|
return super.exportXls(request, customer, Customer.class, "客户表");
|
}
|
|
/**
|
* 通过excel导入数据
|
*
|
* @param request
|
* @param response
|
* @return
|
*/
|
@RequiresPermissions("customer:customer:importExcel")
|
@RequestMapping(value = "/importExcel", method = RequestMethod.POST)
|
public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
|
return super.importExcel(request, response, Customer.class);
|
}
|
@Autowired
|
private IContractService contractService;
|
@Autowired
|
private IContractFileService contractFileService;
|
@Autowired
|
private ISemanticWordService semanticWordService;
|
|
@RequiresPermissions("customer:customer:importCustomerContractWord")
|
@RequestMapping(value = "/importCustomerContractWord", method = RequestMethod.POST)
|
public Result<String> importCustomerContractWord(@RequestBody Customer customer) {
|
if (customer.getContract().getReviewStatus() == null) {
|
customer.getContract().setReviewStatus("1");
|
}
|
QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("enterprise_name",customer.getEnterpriseName());
|
QueryWrapper<SysUser> querySysUser = new QueryWrapper<>();
|
querySysUser.eq("username",customer.getEnterpriseName());
|
|
if (customer.getId() == null || customer.getId().equals("")) {
|
if (customerService.count(queryWrapper) == 0) {
|
customerService.save(customer);
|
}
|
|
if (sysUserController.getSysUserService().count(querySysUser) == 0) {
|
JSONObject jsonObject = new JSONObject();
|
String filteredName = customer.getEnterpriseName().replaceAll("[\u4e00-\u9fa5]", "").replaceAll("\\s+", "");
|
jsonObject.put("workNo", "KH" + filteredName + customer.getCustomerPhone());
|
jsonObject.put("password", "123456");
|
jsonObject.put("confirmPassword", "123456");
|
jsonObject.put("selectedroles", "1972228625018228737");
|
jsonObject.put("activitiSync", "1");
|
jsonObject.put("departIds", "");
|
jsonObject.put("userIdentity", "1");
|
String phone = customer.getCustomerPhone(); ;
|
|
// 校验电话号码：非空且为数字，且长度≤20
|
if ((phone != null && phone != "") && phone.matches("\\d{1,20}")) {
|
// 校验通过，放入JSONObject
|
jsonObject.put("phone", phone);
|
} else if (phone == null || phone == "") {
|
|
}
|
else {
|
return Result.error("请输入正确的电话号码");
|
}
|
jsonObject.put("email" , customer.getCustomerEmail());
|
jsonObject.put("username" , customer.getEnterpriseName());
|
jsonObject.put("realname" , customer.getEnterpriseName());
|
try {
|
Result<SysUser> add = sysUserController.add(jsonObject);
|
if (add.getCode() != 200) {
|
return Result.error("电话号码或邮箱重复");
|
}
|
}catch (Exception e) {
|
if (e.getMessage().equals("Subject does not have permission [system:user:add]")){
|
return Result.error("未分配权限：创建客户用户");
|
}
|
return Result.error("电话号码或邮箱重复");
|
}
|
}
|
}
|
try {
|
customerService.getOne(queryWrapper);
|
}catch (Exception e) {
|
return Result.error("合同已存在");
|
}
|
Customer one = customerService.getOne(queryWrapper);
|
customer.getContract().setCustomerName(one.getEnterpriseName());
|
|
|
QueryWrapper<Contract> queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("customer_name",customer.getContract().getCustomerName());
|
queryWrapper1.eq("contract_name",customer.getContract().getContractName());
|
|
if(contractService.count(queryWrapper1) != 0) {
|
return Result.error("该合同已存在");
|
}
|
contractService.save(customer.getContract());
|
|
Contract one1 = contractService.getOne(queryWrapper1);
|
for (SemanticWord semanticWord : customer.getSemanticWordList()){
|
semanticWord.setContractId(one1.getId());
|
}
|
semanticWordService.saveBatch(customer.getSemanticWordList());
|
|
for (ContractFile contractFile : customer.getContract().getContractFileList()){
|
contractFile.setContractId(one1.getId());
|
contractFileService.save(contractFile);
|
}
|
|
return Result.OK("添加成功！");
|
}
|
}
|
