package org.jeecg.modules.demo.customer.controller;
|
|
import java.util.Arrays;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
import java.io.IOException;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLDecoder;
|
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.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.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) {
|
|
|
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);
|
}
|
|
/**
|
* 添加
|
*
|
* @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("待审核");
|
}
|
QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("enterprise_name",customer.getEnterpriseName());
|
if (customer.getId() == null || customer.getId().equals("")) {
|
if (customerService.count(queryWrapper) > 0) {
|
|
}else{
|
customerService.save(customer);
|
}
|
}
|
try {
|
customerService.getOne(queryWrapper);
|
}catch (Exception e) {
|
return Result.error("合同已存在");
|
}
|
Customer one = customerService.getOne(queryWrapper);
|
customer.getContract().setCustomerName(one.getEnterpriseName());
|
contractService.save(customer.getContract());
|
|
QueryWrapper<Contract> queryWrapper1 = new QueryWrapper<>();
|
queryWrapper1.eq("customer_name",customer.getContract().getCustomerName());
|
queryWrapper1.eq("contract_name",customer.getContract().getContractName());
|
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("添加成功！");
|
}
|
}
|
