CRM项目后端优化调整向前端输出提交的Excel文件格式------CRM项目

最新推荐文章于 2024-11-09 12:43:52 发布

旧约Alatus

最新推荐文章于 2024-11-09 12:43:52 发布

阅读量895

点赞数 24

分类专栏： CRM项目 # Spring-Boot框架 # Mybatis框架文章标签： java 后端 spring spring boot mybatis excel mysql

本文链接：https://blog.csdn.net/2201_75960169/article/details/136417796

版权

Spring-Boot框架同时被 3 个专栏收录

234 篇文章 0 订阅

订阅专栏

CRM项目

142 篇文章 0 订阅

订阅专栏

Mybatis框架

132 篇文章 0 订阅

订阅专栏

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.alatus.mapper.TCustomerMapper">
  <resultMap id="BaseResultMap" type="com.alatus.model.TCustomer">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="clue_id" jdbcType="INTEGER" property="clueId" />
    <result column="product" jdbcType="INTEGER" property="product" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
  </resultMap>

  <resultMap id="CustomerResultMap" type="com.alatus.model.TCustomer">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="clue_id" jdbcType="INTEGER" property="clueId" />
    <result column="product" jdbcType="INTEGER" property="product" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
    <!--一对一关联线索-->
    <association property="clueDO" javaType="com.alatus.model.TClue">
      <id column="clueId" jdbcType="INTEGER" property="id" />
      <result column="full_name" jdbcType="VARCHAR" property="fullName" />
      <result column="phone" jdbcType="VARCHAR" property="phone" />
      <result column="weixin" jdbcType="VARCHAR" property="weixin" />
      <result column="qq" jdbcType="VARCHAR" property="qq" />
      <result column="email" jdbcType="VARCHAR" property="email" />
      <result column="age" jdbcType="INTEGER" property="age" />
      <result column="job" jdbcType="VARCHAR" property="job" />
      <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
      <result column="address" jdbcType="VARCHAR" property="address" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="ownerDO" javaType="com.alatus.model.TUser">
      <id column="ownerId" jdbcType="INTEGER" property="id" />
      <result column="ownerName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="activityDO" javaType="com.alatus.model.TActivity">
      <id column="activityId" jdbcType="INTEGER" property="id" />
      <result column="activityName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="appellationDO" javaType="com.alatus.model.TDicValue">
      <id column="appellationId" jdbcType="INTEGER" property="id" />
      <result column="appellationName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="needLoanDO" javaType="com.alatus.model.TDicValue">
      <id column="needLoanId" jdbcType="INTEGER" property="id" />
      <result column="needLoanName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionStateDO" javaType="com.alatus.model.TDicValue">
      <id column="intentionStateId" jdbcType="INTEGER" property="id" />
      <result column="intentionStateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="stateDO" javaType="com.alatus.model.TDicValue">
      <id column="stateId" jdbcType="INTEGER" property="id" />
      <result column="stateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="sourceDO" javaType="com.alatus.model.TDicValue">
      <id column="sourceId" jdbcType="INTEGER" property="id" />
      <result column="sourceName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionProductDO" javaType="com.alatus.model.TProduct">
      <id column="intentionProductId" jdbcType="INTEGER" property="id" />
      <result column="intentionProductName" jdbcType="VARCHAR" property="name" />
    </association>
  </resultMap>

  <sql id="Base_Column_List">
    id, clue_id, product, description, next_contact_time, create_time, create_by, edit_time, 
    edit_by
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from t_customer
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="selectCustomerByPage" parameterType="java.lang.Integer" resultMap="CustomerResultMap">
    select
      tct.*,
      tc.id clueId, tc.full_name, tc.phone, tc.weixin,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName,
      tp.id intentionProductId, tp.name intentionProductName
    from t_customer tct left join t_clue tc on tct.clue_id = tc.id
                        left join t_user tu1 on tc.owner_id = tu1.id
                        left join t_activity ta on tc.activity_id = ta.id
                        left join t_dic_value tdv on tc.appellation = tdv.id
                        left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                        left join t_dic_value tdv3 on tc.intention_state = tdv3.id
                        left join t_dic_value tdv4 on tc.state = tdv4.id
                        left join t_dic_value tdv5 on tc.source = tdv5.id
                        left join t_product tp on tct.product = tp.id
  </select>

    <select id="selectCustomerByExcel" resultMap="CustomerResultMap">
      select
        tct.*,
        tc.id clueId, tc.full_name, tc.phone, tc.weixin,tc.qq,tc.email,tc.age,tc.job,tc.address,tc.year_income,
        tu1.id ownerId, tu1.name ownerName,
        ta.id activityId, ta.name activityName,
        tdv.id appellationId, tdv.type_value appellationName,
        tdv2.id needLoanId, tdv2.type_value needLoanName,
        tdv3.id intentionStateId, tdv3.type_value intentionStateName,
        tdv4.id stateId, tdv4.type_value stateName,
        tdv5.id sourceId, tdv5.type_value sourceName,
        tp.id intentionProductId, tp.name intentionProductName
      from t_customer tct left join t_clue tc on tct.clue_id = tc.id
                          left join t_user tu1 on tc.owner_id = tu1.id
                          left join t_activity ta on tc.activity_id = ta.id
                          left join t_dic_value tdv on tc.appellation = tdv.id
                          left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                          left join t_dic_value tdv3 on tc.intention_state = tdv3.id
                          left join t_dic_value tdv4 on tc.state = tdv4.id
                          left join t_dic_value tdv5 on tc.source = tdv5.id
                          left join t_product tp on tct.product = tp.id
    </select>


    <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from t_customer
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TCustomer" useGeneratedKeys="true">
    insert into t_customer (clue_id, product, description, 
      next_contact_time, create_time, create_by, 
      edit_time, edit_by)
    values (#{clueId,jdbcType=INTEGER}, #{product,jdbcType=INTEGER}, #{description,jdbcType=VARCHAR}, 
      #{nextContactTime,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=INTEGER}, 
      #{editTime,jdbcType=TIMESTAMP}, #{editBy,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TCustomer" useGeneratedKeys="true">
    insert into t_customer
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="clueId != null">
        clue_id,
      </if>
      <if test="product != null">
        product,
      </if>
      <if test="description != null">
        description,
      </if>
      <if test="nextContactTime != null">
        next_contact_time,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="createBy != null">
        create_by,
      </if>
      <if test="editTime != null">
        edit_time,
      </if>
      <if test="editBy != null">
        edit_by,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="clueId != null">
        #{clueId,jdbcType=INTEGER},
      </if>
      <if test="product != null">
        #{product,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        #{editBy,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.alatus.model.TCustomer">
    update t_customer
    <set>
      <if test="clueId != null">
        clue_id = #{clueId,jdbcType=INTEGER},
      </if>
      <if test="product != null">
        product = #{product,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        description = #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        create_by = #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        edit_time = #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        edit_by = #{editBy,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.alatus.model.TCustomer">
    update t_customer
    set clue_id = #{clueId,jdbcType=INTEGER},
      product = #{product,jdbcType=INTEGER},
      description = #{description,jdbcType=VARCHAR},
      next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      create_by = #{createBy,jdbcType=INTEGER},
      edit_time = #{editTime,jdbcType=TIMESTAMP},
      edit_by = #{editBy,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.alatus.mapper.TCustomerMapper">
  <resultMap id="BaseResultMap" type="com.alatus.model.TCustomer">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="clue_id" jdbcType="INTEGER" property="clueId" />
    <result column="product" jdbcType="INTEGER" property="product" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
  </resultMap>

  <resultMap id="CustomerResultMap" type="com.alatus.model.TCustomer">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="clue_id" jdbcType="INTEGER" property="clueId" />
    <result column="product" jdbcType="INTEGER" property="product" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="next_contact_time" jdbcType="TIMESTAMP" property="nextContactTime" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="create_by" jdbcType="INTEGER" property="createBy" />
    <result column="edit_time" jdbcType="TIMESTAMP" property="editTime" />
    <result column="edit_by" jdbcType="INTEGER" property="editBy" />
    <!--一对一关联线索-->
    <association property="clueDO" javaType="com.alatus.model.TClue">
      <id column="clueId" jdbcType="INTEGER" property="id" />
      <result column="full_name" jdbcType="VARCHAR" property="fullName" />
      <result column="phone" jdbcType="VARCHAR" property="phone" />
      <result column="weixin" jdbcType="VARCHAR" property="weixin" />
      <result column="qq" jdbcType="VARCHAR" property="qq" />
      <result column="email" jdbcType="VARCHAR" property="email" />
      <result column="age" jdbcType="INTEGER" property="age" />
      <result column="job" jdbcType="VARCHAR" property="job" />
      <result column="year_income" jdbcType="DECIMAL" property="yearIncome" />
      <result column="address" jdbcType="VARCHAR" property="address" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="ownerDO" javaType="com.alatus.model.TUser">
      <id column="ownerId" jdbcType="INTEGER" property="id" />
      <result column="ownerName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="activityDO" javaType="com.alatus.model.TActivity">
      <id column="activityId" jdbcType="INTEGER" property="id" />
      <result column="activityName" jdbcType="VARCHAR" property="name" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="appellationDO" javaType="com.alatus.model.TDicValue">
      <id column="appellationId" jdbcType="INTEGER" property="id" />
      <result column="appellationName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="needLoanDO" javaType="com.alatus.model.TDicValue">
      <id column="needLoanId" jdbcType="INTEGER" property="id" />
      <result column="needLoanName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionStateDO" javaType="com.alatus.model.TDicValue">
      <id column="intentionStateId" jdbcType="INTEGER" property="id" />
      <result column="intentionStateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="stateDO" javaType="com.alatus.model.TDicValue">
      <id column="stateId" jdbcType="INTEGER" property="id" />
      <result column="stateName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="sourceDO" javaType="com.alatus.model.TDicValue">
      <id column="sourceId" jdbcType="INTEGER" property="id" />
      <result column="sourceName" jdbcType="VARCHAR" property="typeValue" />
    </association>
    <!--一对一关联查询的映射-->
    <association property="intentionProductDO" javaType="com.alatus.model.TProduct">
      <id column="intentionProductId" jdbcType="INTEGER" property="id" />
      <result column="intentionProductName" jdbcType="VARCHAR" property="name" />
    </association>
  </resultMap>

  <sql id="Base_Column_List">
    id, clue_id, product, description, next_contact_time, create_time, create_by, edit_time, 
    edit_by
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from t_customer
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="selectCustomerByPage" parameterType="java.lang.Integer" resultMap="CustomerResultMap">
    select
      tct.*,
      tc.id clueId, tc.full_name, tc.phone, tc.weixin,
      tu1.id ownerId, tu1.name ownerName,
      ta.id activityId, ta.name activityName,
      tdv.id appellationId, tdv.type_value appellationName,
      tdv2.id needLoanId, tdv2.type_value needLoanName,
      tdv3.id intentionStateId, tdv3.type_value intentionStateName,
      tdv4.id stateId, tdv4.type_value stateName,
      tdv5.id sourceId, tdv5.type_value sourceName,
      tp.id intentionProductId, tp.name intentionProductName
    from t_customer tct left join t_clue tc on tct.clue_id = tc.id
                        left join t_user tu1 on tc.owner_id = tu1.id
                        left join t_activity ta on tc.activity_id = ta.id
                        left join t_dic_value tdv on tc.appellation = tdv.id
                        left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                        left join t_dic_value tdv3 on tc.intention_state = tdv3.id
                        left join t_dic_value tdv4 on tc.state = tdv4.id
                        left join t_dic_value tdv5 on tc.source = tdv5.id
                        left join t_product tp on tct.product = tp.id
  </select>

    <select id="selectCustomerByExcel" resultMap="CustomerResultMap">
      select
        tct.*,
        tc.id clueId, tc.full_name, tc.phone, tc.weixin,tc.qq,tc.email,tc.age,tc.job,tc.address,tc.year_income,
        tu1.id ownerId, tu1.name ownerName,
        ta.id activityId, ta.name activityName,
        tdv.id appellationId, tdv.type_value appellationName,
        tdv2.id needLoanId, tdv2.type_value needLoanName,
        tdv3.id intentionStateId, tdv3.type_value intentionStateName,
        tdv4.id stateId, tdv4.type_value stateName,
        tdv5.id sourceId, tdv5.type_value sourceName,
        tp.id intentionProductId, tp.name intentionProductName
      from t_customer tct left join t_clue tc on tct.clue_id = tc.id
                          left join t_user tu1 on tc.owner_id = tu1.id
                          left join t_activity ta on tc.activity_id = ta.id
                          left join t_dic_value tdv on tc.appellation = tdv.id
                          left join t_dic_value tdv2 on tc.need_loan = tdv2.id
                          left join t_dic_value tdv3 on tc.intention_state = tdv3.id
                          left join t_dic_value tdv4 on tc.state = tdv4.id
                          left join t_dic_value tdv5 on tc.source = tdv5.id
                          left join t_product tp on tct.product = tp.id
    </select>


    <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from t_customer
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TCustomer" useGeneratedKeys="true">
    insert into t_customer (clue_id, product, description, 
      next_contact_time, create_time, create_by, 
      edit_time, edit_by)
    values (#{clueId,jdbcType=INTEGER}, #{product,jdbcType=INTEGER}, #{description,jdbcType=VARCHAR}, 
      #{nextContactTime,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=INTEGER}, 
      #{editTime,jdbcType=TIMESTAMP}, #{editBy,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.alatus.model.TCustomer" useGeneratedKeys="true">
    insert into t_customer
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="clueId != null">
        clue_id,
      </if>
      <if test="product != null">
        product,
      </if>
      <if test="description != null">
        description,
      </if>
      <if test="nextContactTime != null">
        next_contact_time,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="createBy != null">
        create_by,
      </if>
      <if test="editTime != null">
        edit_time,
      </if>
      <if test="editBy != null">
        edit_by,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="clueId != null">
        #{clueId,jdbcType=INTEGER},
      </if>
      <if test="product != null">
        #{product,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        #{editBy,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.alatus.model.TCustomer">
    update t_customer
    <set>
      <if test="clueId != null">
        clue_id = #{clueId,jdbcType=INTEGER},
      </if>
      <if test="product != null">
        product = #{product,jdbcType=INTEGER},
      </if>
      <if test="description != null">
        description = #{description,jdbcType=VARCHAR},
      </if>
      <if test="nextContactTime != null">
        next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="createBy != null">
        create_by = #{createBy,jdbcType=INTEGER},
      </if>
      <if test="editTime != null">
        edit_time = #{editTime,jdbcType=TIMESTAMP},
      </if>
      <if test="editBy != null">
        edit_by = #{editBy,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.alatus.model.TCustomer">
    update t_customer
    set clue_id = #{clueId,jdbcType=INTEGER},
      product = #{product,jdbcType=INTEGER},
      description = #{description,jdbcType=VARCHAR},
      next_contact_time = #{nextContactTime,jdbcType=TIMESTAMP},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      create_by = #{createBy,jdbcType=INTEGER},
      edit_time = #{editTime,jdbcType=TIMESTAMP},
      edit_by = #{editBy,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TCustomer;
import com.alatus.query.CustomerQuery;
import com.alatus.result.CustomerExcel;
import com.alatus.result.Result;
import com.alatus.service.CustomerService;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;

@RestController
public class CustomerController {
    @Resource
    private CustomerService customerService;

    @PostMapping(value = "/api/clue/customer")
    public Result transferCustomer(@RequestBody CustomerQuery customerQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        customerQuery.setToken(token);
        Boolean convert = customerService.convertCustomer(customerQuery);
        return convert ? Result.OK() : Result.FAIL();
    }
    @GetMapping(value = "/api/customers")
    public Result CustomersByPages(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TCustomer> pageInfo = customerService.getCustomerByPage(current);
        return Result.OK(pageInfo);
    }
    @GetMapping(value = "/api/exportExcel")
    public void exportExcel(HttpServletResponse response) throws IOException {
        //要想让浏览器弹出下载框，后端要设置一下响应头信息
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding(Constants.UTF_8);
        response.setHeader("X-Frame-Options", "allow-from uri");// 解决IFrame拒绝的问题
        response.setHeader("Content-disposition", "attachment;filename="+ URLEncoder.encode(Constants.CUSTOMER_FILE_NAME,Constants.UTF_8) +".xlsx");
        List<CustomerExcel> dataList = customerService.getCustomerByExcel();
        EasyExcel.write(response.getOutputStream(), CustomerExcel.class)
                .sheet()
                .doWrite(dataList);
    }
}

package com.alatus.web;

import com.alatus.constant.Constants;
import com.alatus.model.TCustomer;
import com.alatus.query.CustomerQuery;
import com.alatus.result.CustomerExcel;
import com.alatus.result.Result;
import com.alatus.service.CustomerService;
import com.alibaba.excel.EasyExcel;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.bind.annotation.*;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;

@RestController
public class CustomerController {
    @Resource
    private CustomerService customerService;

    @PostMapping(value = "/api/clue/customer")
    public Result transferCustomer(@RequestBody CustomerQuery customerQuery, @RequestHeader(value = Constants.TOKEN_NAME)String token){
        customerQuery.setToken(token);
        Boolean convert = customerService.convertCustomer(customerQuery);
        return convert ? Result.OK() : Result.FAIL();
    }
    @GetMapping(value = "/api/customers")
    public Result CustomersByPages(@RequestParam(value = Constants.CURRENT,required = false)Integer current){
        if(current == null){
            current = 1;
        }
        PageInfo<TCustomer> pageInfo = customerService.getCustomerByPage(current);
        return Result.OK(pageInfo);
    }
    @GetMapping(value = "/api/exportExcel")
    public void exportExcel(HttpServletResponse response) throws IOException {
        //要想让浏览器弹出下载框，后端要设置一下响应头信息
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding(Constants.UTF_8);
        response.setHeader("X-Frame-Options", "allow-from uri");// 解决IFrame拒绝的问题
        response.setHeader("Content-disposition", "attachment;filename="+ URLEncoder.encode(Constants.CUSTOMER_FILE_NAME,Constants.UTF_8) +".xlsx");
        List<CustomerExcel> dataList = customerService.getCustomerByExcel();
        EasyExcel.write(response.getOutputStream(), CustomerExcel.class)
                .sheet()
                .doWrite(dataList);
    }
}

package com.alatus.constant;

import java.util.ResourceBundle;

public class Constants {
//    开始页地址
    public static final String LOGIN_URI = "/api/login";
//    redis的key命名规范,项目名:模块名:功能名:唯一业务参数(比如用户ID)
    public static final String REDIS_JWT_KEY = "crmSystem:user:login:";
//    七天时间
    public static final Long EXPIRE_TIME = 7 * 24 * 60 * 60L;
//    三十分钟
    public static final Long DEFAULT_EXPIRE_TIME = 30 * 60L;
//    分页时每页10条记录
    public static final int PAGE_SIZE = 10;
//    Token的名字
    public static final String TOKEN_NAME = "Authorization";
//    负责人的Key
    public static final String OWNER_KEY = "crm:user:owner";
//    五分钟
    public static final Long DEFAULT_KEY_EXPIRE_TIME = 5 * 60L;
//    管理员名字
    public static final String ADMIN = "admin";
//    记住我按钮
    public static final String REMEMBER_ME = "rememberMe";
//    ID
    public static final String ID = "id";

    public static final String IDS = "ids";

    public static final String CURRENT = "current";

    public static final String TYPECODE = "typeCode";
    public static final String PHONE = "phone";
    public static final String EMPTY = "";
    public static final String EXPORT_EXCEL_URI = "/api/exportExcel";
    public static final String CUSTOMER_FILE_NAME = "客户信息"+System.currentTimeMillis();
    public static final String UTF_8 = "utf-8";
}

package com.alatus.constant;

import java.util.ResourceBundle;

public class Constants {
//    开始页地址
    public static final String LOGIN_URI = "/api/login";
//    redis的key命名规范,项目名:模块名:功能名:唯一业务参数(比如用户ID)
    public static final String REDIS_JWT_KEY = "crmSystem:user:login:";
//    七天时间
    public static final Long EXPIRE_TIME = 7 * 24 * 60 * 60L;
//    三十分钟
    public static final Long DEFAULT_EXPIRE_TIME = 30 * 60L;
//    分页时每页10条记录
    public static final int PAGE_SIZE = 10;
//    Token的名字
    public static final String TOKEN_NAME = "Authorization";
//    负责人的Key
    public static final String OWNER_KEY = "crm:user:owner";
//    五分钟
    public static final Long DEFAULT_KEY_EXPIRE_TIME = 5 * 60L;
//    管理员名字
    public static final String ADMIN = "admin";
//    记住我按钮
    public static final String REMEMBER_ME = "rememberMe";
//    ID
    public static final String ID = "id";

    public static final String IDS = "ids";

    public static final String CURRENT = "current";

    public static final String TYPECODE = "typeCode";
    public static final String PHONE = "phone";
    public static final String EMPTY = "";
    public static final String EXPORT_EXCEL_URI = "/api/exportExcel";
    public static final String CUSTOMER_FILE_NAME = "客户信息"+System.currentTimeMillis();
    public static final String UTF_8 = "utf-8";
}