E呼即办2

linwe

2024-05-15 047ced202f052d70c50f4365b2d86810de076489

E呼即办2

 src/main/java/org/springblade/modules/eCallEventTwo/controller/ECallEventTwoController.java

New file
@@ -0,0 +1,126 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import javax.validation.Valid;

import org.springblade.core.secure.BladeUser;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO;
import org.springblade.modules.eCallEventTwo.wrapper.ECallEventTwoWrapper;
import org.springblade.modules.eCallEventTwo.service.IECallEventTwoService;
import org.springblade.core.boot.ctrl.BladeController;

/**
 * 工单 控制器
 *
 * @author BladeX
 * @since 2024-05-15
 */
@RestController
@AllArgsConstructor
@RequestMapping("blade-eCallEventTwo/eCallEventTwo")
@Api(value = "工单", tags = "工单接口")
public class ECallEventTwoController extends BladeController {

    private final IECallEventTwoService eCallEventTwoService;

    /**
     * 工单 详情
     */
    @GetMapping("/detail")
    @ApiOperationSupport(order = 1)
    @ApiOperation(value = "详情", notes = "传入eCallEventTwo")
    public R<ECallEventTwoVO> detail(ECallEventTwoEntity eCallEventTwo) {
        ECallEventTwoEntity detail = eCallEventTwoService.getOne(Condition.getQueryWrapper(eCallEventTwo));
        return R.data(ECallEventTwoWrapper.build().entityVO(detail));
    }
    /**
     * 工单 分页
     */
    @GetMapping("/list")
    @ApiOperationSupport(order = 2)
    @ApiOperation(value = "分页", notes = "传入eCallEventTwo")
    public R<IPage<ECallEventTwoVO>> list(ECallEventTwoEntity eCallEventTwo, Query query) {
        IPage<ECallEventTwoEntity> pages = eCallEventTwoService.page(Condition.getPage(query), Condition.getQueryWrapper(eCallEventTwo));
        return R.data(ECallEventTwoWrapper.build().pageVO(pages));
    }

    /**
     * 工单 自定义分页
     */
    @GetMapping("/page")
    @ApiOperationSupport(order = 3)
    @ApiOperation(value = "分页", notes = "传入eCallEventTwo")
    public R<IPage<ECallEventTwoVO>> page(ECallEventTwoVO eCallEventTwo, Query query) {
        IPage<ECallEventTwoVO> pages = eCallEventTwoService.selectECallEventTwoPage(Condition.getPage(query), eCallEventTwo);
        return R.data(pages);
    }

    /**
     * 工单 新增
     */
    @PostMapping("/save")
    @ApiOperationSupport(order = 4)
    @ApiOperation(value = "新增", notes = "传入eCallEventTwo")
    public R save(@Valid @RequestBody ECallEventTwoEntity eCallEventTwo) {
        return R.status(eCallEventTwoService.save(eCallEventTwo));
    }

    /**
     * 工单 修改
     */
    @PostMapping("/update")
    @ApiOperationSupport(order = 5)
    @ApiOperation(value = "修改", notes = "传入eCallEventTwo")
    public R update(@Valid @RequestBody ECallEventTwoEntity eCallEventTwo) {
        return R.status(eCallEventTwoService.updateById(eCallEventTwo));
    }

    /**
     * 工单 新增或修改
     */
    @PostMapping("/submit")
    @ApiOperationSupport(order = 6)
    @ApiOperation(value = "新增或修改", notes = "传入eCallEventTwo")
    public R submit(@Valid @RequestBody ECallEventTwoEntity eCallEventTwo) {
        return R.status(eCallEventTwoService.saveOrUpdate(eCallEventTwo));
    }

    /**
     * 工单 删除
     */
    @PostMapping("/remove")
    @ApiOperationSupport(order = 7)
    @ApiOperation(value = "逻辑删除", notes = "传入ids")
    public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
        return R.status(eCallEventTwoService.removeBatchByIds(Func.toLongList(ids)));
    }


}

 src/main/java/org/springblade/modules/eCallEventTwo/dto/ECallEventTwoDTO.java

New file
@@ -0,0 +1,34 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.dto;

import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * 工单 数据传输对象实体类
 *
 * @author BladeX
 * @since 2024-05-15
 */
@Data
@EqualsAndHashCode(callSuper = true)
public class ECallEventTwoDTO extends ECallEventTwoEntity {
    private static final long serialVersionUID = 1L;

}

 src/main/java/org/springblade/modules/eCallEventTwo/entity/ECallEventTwoEntity.java

New file
@@ -0,0 +1,266 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.EqualsAndHashCode;
import org.springblade.core.tenant.mp.TenantEntity;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 工单 实体类
 *
 * @author BladeX
 * @since 2024-05-15
 */
@Data
@TableName("jczz_e_call_event_two")
@ApiModel(value = "ECallEventTwo对象", description = "工单")
public class ECallEventTwoEntity   {
    private static final long serialVersionUID = 1L;

    /** 工单ID */
    @ApiModelProperty(value = "主键ID", example = "")
    @TableId(value = "order_id", type = IdType.AUTO)
    private Long orderId;

    /** 工单号/话务单号 */
    @ApiModelProperty(value = "工单号/话务单号", example = "")
    @TableField("order_code")
    private String orderCode;

    /** 诉求来源（0热线 1公安110 2微信 3微博） */
    @ApiModelProperty(value = "诉求来源（0热线 1公安110 2微信 3微博）", example = "")
    @TableField("issue_origin")
    private String issueOrigin;

    /** 诉求主题 */
    @ApiModelProperty(value = "诉求主题", example = "")
    @TableField("issue_title")
    private String issueTitle;

    /** 诉求内容 */
    @ApiModelProperty(value = "诉求内容", example = "")
    @TableField("issue_content")
    private String issueContent;

    /** 诉求用户类别（0个人 1企业） */
    @ApiModelProperty(value = "诉求用户类别（0个人 1企业）", example = "")
    @TableField("applicant_type")
    private String applicantType;

    /** 诉求人姓名 */
    @ApiModelProperty(value = "诉求人姓名", example = "")
    @TableField("applicant_name")
    private String applicantName;

    /** 诉求人性别（0男 1女） */
    @ApiModelProperty(value = "诉求人性别（0男 1女）", example = "")
    @TableField("applicant_gender")
    private String applicantGender;

    /** 诉求人住址 */
    @ApiModelProperty(value = "诉求人住址", example = "")
    @TableField("applicant_homeaddr")
    private String applicantHomeaddr;

    /** 现场联系电话 */
    @ApiModelProperty(value = "现场联系电话", example = "")
    @TableField("applicant_phone")
    private String applicantPhone;

    /** 网格 */
    @ApiModelProperty(value = "网格", example = "")
    @TableField("applicant_grid")
    private String applicantGrid;

    /** 诉求人行政区划 */
    @ApiModelProperty(value = "诉求人行政区划", example = "")
    @TableField("applicant_district")
    private String applicantDistrict;

    /** 事发地址 */
    @ApiModelProperty(value = "事发地址", example = "")
    @TableField("scene_addr")
    private String sceneAddr;

    /** 事发地址网格 */
    @ApiModelProperty(value = "事发地址网格", example = "")
    @TableField("scene_addr_grid")
    private String sceneAddrGrid;

    /** 事发所属行政区划 */
    @ApiModelProperty(value = "事发所属行政区划", example = "")
    @TableField("scene_district")
    private String sceneDistrict;

    /** 事发场所 */
    @ApiModelProperty(value = "事发场所", example = "")
    @TableField("scene_place")
    private String scenePlace;

    /** 事发地点-经度 */
    @ApiModelProperty(value = "事发地点-经度", example = "")
    @TableField("scene_geo_lat")
    private BigDecimal sceneGeoLat;

    /** 事发地点-维度 */
    @ApiModelProperty(value = "事发地点-维度", example = "")
    @TableField("scene_geo_lng")
    private BigDecimal sceneGeoLng;

    /** 是否保密 */
    @ApiModelProperty(value = "是否保密", example = "")
    @TableField("is_secret")
    private String isSecret;

    /** 是否重复 */
    @ApiModelProperty(value = "是否重复", example = "")
    @TableField("is_repeat")
    private String isRepeat;

    /** 诉求类别（咨询、投诉、求助、举报、建议） */
    @ApiModelProperty(value = "诉求类别（咨询、投诉、求助、举报、建议）", example = "")
    @TableField("issue_type")
    private String issueType;

    /** 归口类型-多级 */
    @ApiModelProperty(value = "归口类型-多级", example = "")
    @TableField("issue_clazz")
    private String issueClazz;

    /** 紧急程度（一般、即办） */
    @ApiModelProperty(value = "紧急程度（一般、即办）", example = "")
    @TableField("issue_level")
    private String issueLevel;

    /** 办理时限（分钟） */
    @ApiModelProperty(value = "办理时限（分钟）", example = "")
    @TableField("deadline")
    private Integer deadline;

    /** 关联工单ID */
    @ApiModelProperty(value = "关联工单ID", example = "")
    @TableField("link_orders")
    private String linkOrders;

    /** 关联工单号 */
    @ApiModelProperty(value = "关联工单号", example = "")
    @TableField("link_orders_code")
    private String linkOrdersCode;

    /** 知识引用 */
    @ApiModelProperty(value = "知识引用", example = "")
    @TableField("wiki_ref")
    private String wikiRef;

    /** 受理单位 */
    @ApiModelProperty(value = "受理单位", example = "")
    @TableField("acpt_org_code")
    private String acptOrgCode;

    /** 受理单位 */
    @ApiModelProperty(value = "受理单位", example = "")
    @TableField("acpt_org_name")
    private String acptOrgName;

    /** 处办方式 */
    @ApiModelProperty(value = "处办方式", example = "")
    @TableField("handle_way")
    private String handleWay;

    /** 外部处办方式 */
    @ApiModelProperty(value = "外部处办方式", example = "")
    @TableField("external_handle_way")
    private String externalHandleWay;

    /** 直接答复内容 */
    @ApiModelProperty(value = "直接答复内容", example = "")
    @TableField("direct_feed")
    private String directFeed;

    /** 直接答复人员 */
    @ApiModelProperty(value = "直接答复人员", example = "")
    @TableField("direct_feed_handler")
    private String directFeedHandler;

    /** 直接答复时间 */
    @ApiModelProperty(value = "直接答复时间", example = "")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @TableField("direct_feed_time")
    private Date directFeedTime;

    /** 工单附件 */
    @ApiModelProperty(value = "工单附件", example = "")
    @TableField("images")
    private String images;

    /** 工单状态（0受理 1处理中 2已归档） */
    @ApiModelProperty(value = "工单状态（0受理 1处理中 2已归档）", example = "")
    @TableField("status")
    private String status;

    /** 交办标签（N未交办 Y已交办 R已退回） */
    @ApiModelProperty(value = "交办标签（N未交办 Y已交办 R已退回）", example = "")
    @TableField("tag_apply")
    private String tagApply;

    /** 已延期（Y/N） */
    @ApiModelProperty(value = "已延期（Y/N）", example = "")
    @TableField("tag_delay")
    private String tagDelay;

    /** 已反馈（Y/N） */
    @ApiModelProperty(value = "已反馈（Y/N）", example = "")
    @TableField("tag_doing")
    private String tagDoing;

    /** 已答复（Y/N） */
    @ApiModelProperty(value = "已答复（Y/N）", example = "")
    @TableField("tag_resp")
    private String tagResp;

    /** 已办结（Y/N） */
    @ApiModelProperty(value = "已办结（Y/N）", example = "")
    @TableField("tag_done")
    private String tagDone;

    /** 已回访（Y/N） */
    @ApiModelProperty(value = "已回访（Y/N）", example = "")
    @TableField("tag_check")
    private String tagCheck;

    /** 已电话回访（Y/N） */
    @ApiModelProperty(value = "已电话回访（Y/N）", example = "")
    @TableField("tag_chk_tel")
    private String tagChkTel;

    /** 核实/督办（N1/N2） */
    @ApiModelProperty(value = "核实/督办（N1/N2）", example = "")
    @TableField("tag_redo")
    private String tagRedo;

}

 src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.java

New file
@@ -0,0 +1,61 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.mapper;

import org.springblade.modules.eCallEventTwo.dto.ECallEventTwoDTO;
import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;

/**
 * 工单 Mapper 接口
 *
 * @author BladeX
 * @since 2024-05-15
 */
public interface EcCallEventTwoMapper extends BaseMapper<ECallEventTwoEntity> {

    /**
     * 自定义分页
     *
     * @param page
     * @param eCallEventTwo
     * @return
     */
    List<ECallEventTwoVO> selectECallEventTwoPage(IPage page, ECallEventTwoVO eCallEventTwo);



    /**
     * 查询工单
     *
     * @param orderId 工单ID
     * @return 工单
     */
    public ECallEventTwoDTO selectECallEventTwoById(Long orderId);

    /**
     * 查询工单列表
     *
     * @param eCallEventTwoDTO 工单
     * @return 工单集合
     */
    public List<ECallEventTwoDTO> selectECallEventTwoList(ECallEventTwoDTO eCallEventTwoDTO);

}

 src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.xml

New file
@@ -0,0 +1,214 @@
<?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="org.springblade.modules.eCallEventTwo.mapper.EcCallEventTwoMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="eCallEventTwoResultMap" type="org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO">
    </resultMap>


    <select id="selectECallEventTwoPage" resultMap="eCallEventTwoResultMap">
        select * from jczz_e_call_event_two
        <where>
            <if test="eCallEventTwo.orderId != null "> and order_id = #{orderId}</if>
            <if test="eCallEventTwo.orderCode != null  and eCallEventTwo.orderCode != ''"> and order_code = #{orderCode}</if>
            <if test="eCallEventTwo.issueOrigin != null  and eCallEventTwo.issueOrigin != ''"> and issue_origin = #{issueOrigin}</if>
            <if test="eCallEventTwo.issueTitle != null  and eCallEventTwo.issueTitle != ''"> and issue_title = #{issueTitle}</if>
            <if test="eCallEventTwo.issueContent != null  and eCallEventTwo.issueContent != ''"> and issue_content = #{issueContent}</if>
            <if test="eCallEventTwo.applicantType != null  and eCallEventTwo.applicantType != ''"> and applicant_type = #{applicantType}</if>
            <if test="eCallEventTwo.applicantName != null  and eCallEventTwo.applicantName != ''"> and applicant_name = #{applicantName}</if>
            <if test="eCallEventTwo.applicantGender != null  and eCallEventTwo.applicantGender != ''"> and applicant_gender = #{applicantGender}</if>
            <if test="eCallEventTwo.applicantHomeaddr != null  and eCallEventTwo.applicantHomeaddr != ''"> and applicant_homeaddr = #{applicantHomeaddr}</if>
            <if test="eCallEventTwo.applicantPhone != null  and eCallEventTwo.applicantPhone != ''"> and applicant_phone = #{applicantPhone}</if>
            <if test="eCallEventTwo.applicantGrid != null  and eCallEventTwo.applicantGrid != ''"> and applicant_grid = #{applicantGrid}</if>
            <if test="eCallEventTwo.applicantDistrict != null  and eCallEventTwo.applicantDistrict != ''"> and applicant_district = #{applicantDistrict}</if>
            <if test="eCallEventTwo.sceneAddr != null  and eCallEventTwo.sceneAddr != ''"> and scene_addr = #{sceneAddr}</if>
            <if test="eCallEventTwo.sceneAddrGrid != null  and eCallEventTwo.sceneAddrGrid != ''"> and scene_addr_grid = #{sceneAddrGrid}</if>
            <if test="eCallEventTwo.sceneDistrict != null  and eCallEventTwo.sceneDistrict != ''"> and scene_district = #{sceneDistrict}</if>
            <if test="eCallEventTwo.scenePlace != null  and eCallEventTwo.scenePlace != ''"> and scene_place = #{scenePlace}</if>
            <if test="eCallEventTwo.sceneGeoLat != null "> and scene_geo_lat = #{sceneGeoLat}</if>
            <if test="eCallEventTwo.sceneGeoLng != null "> and scene_geo_lng = #{sceneGeoLng}</if>
            <if test="eCallEventTwo.isSecret != null  and eCallEventTwo.isSecret != ''"> and is_secret = #{isSecret}</if>
            <if test="eCallEventTwo.isRepeat != null  and eCallEventTwo.isRepeat != ''"> and is_repeat = #{isRepeat}</if>
            <if test="eCallEventTwo.issueType != null  and eCallEventTwo.issueType != ''"> and issue_type = #{issueType}</if>
            <if test="eCallEventTwo.issueClazz != null  and eCallEventTwo.issueClazz != ''"> and issue_clazz = #{issueClazz}</if>
            <if test="eCallEventTwo.issueLevel != null  and eCallEventTwo.issueLevel != ''"> and issue_level = #{issueLevel}</if>
            <if test="eCallEventTwo.deadline != null "> and deadline = #{deadline}</if>
            <if test="eCallEventTwo.linkOrders != null  and eCallEventTwo.linkOrders != ''"> and link_orders = #{linkOrders}</if>
            <if test="eCallEventTwo.linkOrdersCode != null  and eCallEventTwo.linkOrdersCode != ''"> and link_orders_code = #{linkOrdersCode}</if>
            <if test="eCallEventTwo.wikiRef != null  and eCallEventTwo.wikiRef != ''"> and wiki_ref = #{wikiRef}</if>
            <if test="eCallEventTwo.acptOrgCode != null  and eCallEventTwo.acptOrgCode != ''"> and acpt_org_code = #{acptOrgCode}</if>
            <if test="eCallEventTwo.acptOrgName != null  and eCallEventTwo.acptOrgName != ''"> and acpt_org_name = #{acptOrgName}</if>
            <if test="eCallEventTwo.handleWay != null  and eCallEventTwo.handleWay != ''"> and handle_way = #{handleWay}</if>
            <if test="eCallEventTwo.externalHandleWay != null  and eCallEventTwo.externalHandleWay != ''"> and external_handle_way = #{externalHandleWay}</if>
            <if test="eCallEventTwo.directFeed != null  and eCallEventTwo.directFeed != ''"> and direct_feed = #{directFeed}</if>
            <if test="eCallEventTwo.directFeedHandler != null  and eCallEventTwo.directFeedHandler != ''"> and direct_feed_handler = #{directFeedHandler}</if>
            <if test="eCallEventTwo.directFeedTime != null "> and direct_feed_time = #{directFeedTime}</if>
            <if test="eCallEventTwo.images != null  and eCallEventTwo.images != ''"> and images = #{images}</if>
            <if test="eCallEventTwo.status != null  and eCallEventTwo.status != ''"> and status = #{status}</if>
            <if test="eCallEventTwo.tagApply != null  and eCallEventTwo.tagApply != ''"> and tag_apply = #{tagApply}</if>
            <if test="eCallEventTwo.tagDelay != null  and eCallEventTwo.tagDelay != ''"> and tag_delay = #{tagDelay}</if>
            <if test="eCallEventTwo.tagDoing != null  and eCallEventTwo.tagDoing != ''"> and tag_doing = #{tagDoing}</if>
            <if test="eCallEventTwo.tagResp != null  and eCallEventTwo.tagResp != ''"> and tag_resp = #{tagResp}</if>
            <if test="eCallEventTwo.tagDone != null  and eCallEventTwo.tagDone != ''"> and tag_done = #{tagDone}</if>
            <if test="eCallEventTwo.tagCheck != null  and eCallEventTwo.tagCheck != ''"> and tag_check = #{tagCheck}</if>
            <if test="eCallEventTwo.tagChkTel != null  and eCallEventTwo.tagChkTel != ''"> and tag_chk_tel = #{tagChkTel}</if>
            <if test="eCallEventTwo.tagRedo != null  and eCallEventTwo.tagRedo != ''"> and tag_redo = #{tagRedo}</if>
        </where>
    </select>


    <resultMap type="org.springblade.modules.eCallEventTwo.dto.ECallEventTwoDTO" id="ECallEventTwoDTOResult">
        <result property="orderId"    column="order_id"    />
        <result property="orderCode"    column="order_code"    />
        <result property="issueOrigin"    column="issue_origin"    />
        <result property="issueTitle"    column="issue_title"    />
        <result property="issueContent"    column="issue_content"    />
        <result property="applicantType"    column="applicant_type"    />
        <result property="applicantName"    column="applicant_name"    />
        <result property="applicantGender"    column="applicant_gender"    />
        <result property="applicantHomeaddr"    column="applicant_homeaddr"    />
        <result property="applicantPhone"    column="applicant_phone"    />
        <result property="applicantGrid"    column="applicant_grid"    />
        <result property="applicantDistrict"    column="applicant_district"    />
        <result property="sceneAddr"    column="scene_addr"    />
        <result property="sceneAddrGrid"    column="scene_addr_grid"    />
        <result property="sceneDistrict"    column="scene_district"    />
        <result property="scenePlace"    column="scene_place"    />
        <result property="sceneGeoLat"    column="scene_geo_lat"    />
        <result property="sceneGeoLng"    column="scene_geo_lng"    />
        <result property="isSecret"    column="is_secret"    />
        <result property="isRepeat"    column="is_repeat"    />
        <result property="issueType"    column="issue_type"    />
        <result property="issueClazz"    column="issue_clazz"    />
        <result property="issueLevel"    column="issue_level"    />
        <result property="deadline"    column="deadline"    />
        <result property="linkOrders"    column="link_orders"    />
        <result property="linkOrdersCode"    column="link_orders_code"    />
        <result property="wikiRef"    column="wiki_ref"    />
        <result property="acptOrgCode"    column="acpt_org_code"    />
        <result property="acptOrgName"    column="acpt_org_name"    />
        <result property="handleWay"    column="handle_way"    />
        <result property="externalHandleWay"    column="external_handle_way"    />
        <result property="directFeed"    column="direct_feed"    />
        <result property="directFeedHandler"    column="direct_feed_handler"    />
        <result property="directFeedTime"    column="direct_feed_time"    />
        <result property="images"    column="images"    />
        <result property="status"    column="status"    />
        <result property="tagApply"    column="tag_apply"    />
        <result property="tagDelay"    column="tag_delay"    />
        <result property="tagDoing"    column="tag_doing"    />
        <result property="tagResp"    column="tag_resp"    />
        <result property="tagDone"    column="tag_done"    />
        <result property="tagCheck"    column="tag_check"    />
        <result property="tagChkTel"    column="tag_chk_tel"    />
        <result property="tagRedo"    column="tag_redo"    />
    </resultMap>

    <sql id="selectECallEventTwo">
        select
            order_id,
            order_code,
            issue_origin,
            issue_title,
            issue_content,
            applicant_type,
            applicant_name,
            applicant_gender,
            applicant_homeaddr,
            applicant_phone,
            applicant_grid,
            applicant_district,
            scene_addr,
            scene_addr_grid,
            scene_district,
            scene_place,
            scene_geo_lat,
            scene_geo_lng,
            is_secret,
            is_repeat,
            issue_type,
            issue_clazz,
            issue_level,
            deadline,
            link_orders,
            link_orders_code,
            wiki_ref,
            acpt_org_code,
            acpt_org_name,
            handle_way,
            external_handle_way,
            direct_feed,
            direct_feed_handler,
            direct_feed_time,
            images,
            status,
            tag_apply,
            tag_delay,
            tag_doing,
            tag_resp,
            tag_done,
            tag_check,
            tag_chk_tel,
            tag_redo
        from
            jczz_e_call_event_two
    </sql>

    <select id="selectECallEventTwoById" parameterType="long" resultMap="ECallEventTwoDTOResult">
        <include refid="selectECallEventTwo"/>
        where
        order_id = #{orderId}
    </select>

    <select id="selectECallEventTwoList" parameterType="org.springblade.modules.eCallEventTwo.dto.ECallEventTwoDTO" resultMap="ECallEventTwoDTOResult">
        <include refid="selectECallEventTwo"/>
        <where>
            <if test="orderId != null "> and order_id = #{orderId}</if>
            <if test="orderCode != null  and orderCode != ''"> and order_code = #{orderCode}</if>
            <if test="issueOrigin != null  and issueOrigin != ''"> and issue_origin = #{issueOrigin}</if>
            <if test="issueTitle != null  and issueTitle != ''"> and issue_title = #{issueTitle}</if>
            <if test="issueContent != null  and issueContent != ''"> and issue_content = #{issueContent}</if>
            <if test="applicantType != null  and applicantType != ''"> and applicant_type = #{applicantType}</if>
            <if test="applicantName != null  and applicantName != ''"> and applicant_name = #{applicantName}</if>
            <if test="applicantGender != null  and applicantGender != ''"> and applicant_gender = #{applicantGender}</if>
            <if test="applicantHomeaddr != null  and applicantHomeaddr != ''"> and applicant_homeaddr = #{applicantHomeaddr}</if>
            <if test="applicantPhone != null  and applicantPhone != ''"> and applicant_phone = #{applicantPhone}</if>
            <if test="applicantGrid != null  and applicantGrid != ''"> and applicant_grid = #{applicantGrid}</if>
            <if test="applicantDistrict != null  and applicantDistrict != ''"> and applicant_district = #{applicantDistrict}</if>
            <if test="sceneAddr != null  and sceneAddr != ''"> and scene_addr = #{sceneAddr}</if>
            <if test="sceneAddrGrid != null  and sceneAddrGrid != ''"> and scene_addr_grid = #{sceneAddrGrid}</if>
            <if test="sceneDistrict != null  and sceneDistrict != ''"> and scene_district = #{sceneDistrict}</if>
            <if test="scenePlace != null  and scenePlace != ''"> and scene_place = #{scenePlace}</if>
            <if test="sceneGeoLat != null "> and scene_geo_lat = #{sceneGeoLat}</if>
            <if test="sceneGeoLng != null "> and scene_geo_lng = #{sceneGeoLng}</if>
            <if test="isSecret != null  and isSecret != ''"> and is_secret = #{isSecret}</if>
            <if test="isRepeat != null  and isRepeat != ''"> and is_repeat = #{isRepeat}</if>
            <if test="issueType != null  and issueType != ''"> and issue_type = #{issueType}</if>
            <if test="issueClazz != null  and issueClazz != ''"> and issue_clazz = #{issueClazz}</if>
            <if test="issueLevel != null  and issueLevel != ''"> and issue_level = #{issueLevel}</if>
            <if test="deadline != null "> and deadline = #{deadline}</if>
            <if test="linkOrders != null  and linkOrders != ''"> and link_orders = #{linkOrders}</if>
            <if test="linkOrdersCode != null  and linkOrdersCode != ''"> and link_orders_code = #{linkOrdersCode}</if>
            <if test="wikiRef != null  and wikiRef != ''"> and wiki_ref = #{wikiRef}</if>
            <if test="acptOrgCode != null  and acptOrgCode != ''"> and acpt_org_code = #{acptOrgCode}</if>
            <if test="acptOrgName != null  and acptOrgName != ''"> and acpt_org_name = #{acptOrgName}</if>
            <if test="handleWay != null  and handleWay != ''"> and handle_way = #{handleWay}</if>
            <if test="externalHandleWay != null  and externalHandleWay != ''"> and external_handle_way = #{externalHandleWay}</if>
            <if test="directFeed != null  and directFeed != ''"> and direct_feed = #{directFeed}</if>
            <if test="directFeedHandler != null  and directFeedHandler != ''"> and direct_feed_handler = #{directFeedHandler}</if>
            <if test="directFeedTime != null "> and direct_feed_time = #{directFeedTime}</if>
            <if test="images != null  and images != ''"> and images = #{images}</if>
            <if test="status != null  and status != ''"> and status = #{status}</if>
            <if test="tagApply != null  and tagApply != ''"> and tag_apply = #{tagApply}</if>
            <if test="tagDelay != null  and tagDelay != ''"> and tag_delay = #{tagDelay}</if>
            <if test="tagDoing != null  and tagDoing != ''"> and tag_doing = #{tagDoing}</if>
            <if test="tagResp != null  and tagResp != ''"> and tag_resp = #{tagResp}</if>
            <if test="tagDone != null  and tagDone != ''"> and tag_done = #{tagDone}</if>
            <if test="tagCheck != null  and tagCheck != ''"> and tag_check = #{tagCheck}</if>
            <if test="tagChkTel != null  and tagChkTel != ''"> and tag_chk_tel = #{tagChkTel}</if>
            <if test="tagRedo != null  and tagRedo != ''"> and tag_redo = #{tagRedo}</if>
        </where>
    </select>

</mapper>

 src/main/java/org/springblade/modules/eCallEventTwo/service/IECallEventTwoService.java

New file
@@ -0,0 +1,60 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.springblade.modules.eCallEventTwo.dto.ECallEventTwoDTO;
import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO;
import org.springblade.core.mp.base.BaseService;
import com.baomidou.mybatisplus.core.metadata.IPage;

import java.util.List;

/**
 * 工单 服务类
 *
 * @author BladeX
 * @since 2024-05-15
 */
public interface IECallEventTwoService extends IService<ECallEventTwoEntity> {

    /**
     * 自定义分页
     *
     * @param page
     * @param eCallEventTwo
     * @return
     */
    IPage<ECallEventTwoVO> selectECallEventTwoPage(IPage<ECallEventTwoVO> page, ECallEventTwoVO eCallEventTwo);

    /**
     * 查询工单
     *
     * @param orderId 工单ID
     * @return 工单
     */
    public ECallEventTwoDTO selectECallEventTwoById(Long orderId);

    /**
     * 查询工单列表
     *
     * @param eCallEventTwoDTO 工单
     * @return 工单集合
     */
    public List<ECallEventTwoDTO> selectECallEventTwoList(ECallEventTwoDTO eCallEventTwoDTO);
}

 src/main/java/org/springblade/modules/eCallEventTwo/service/impl/EcCallEventTwoServiceImpl.java

New file
@@ -0,0 +1,69 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.eCallEventTwo.dto.ECallEventTwoDTO;
import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.modules.eCallEventTwo.mapper.EcCallEventTwoMapper;
import org.springblade.modules.eCallEventTwo.service.IECallEventTwoService;
import org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 工单 服务实现类
 *
 * @author BladeX
 * @since 2024-05-15
 */
@Service
public class EcCallEventTwoServiceImpl extends ServiceImpl<EcCallEventTwoMapper, ECallEventTwoEntity> implements IECallEventTwoService {

    @Override
    public IPage<ECallEventTwoVO> selectECallEventTwoPage(IPage<ECallEventTwoVO> page, ECallEventTwoVO eCallEventTwo) {
        List<ECallEventTwoVO> eCallEventTwoVOS = baseMapper.selectECallEventTwoPage(page, eCallEventTwo);
        return page.setRecords(eCallEventTwoVOS);
    }


    /**
     * 查询工单
     *
     * @param orderId 工单ID
     * @return 工单
     */
    @Override
    public ECallEventTwoDTO selectECallEventTwoById(Long orderId) {
        return this.baseMapper.selectECallEventTwoById(orderId);
    }

    /**
     * 查询工单列表
     *
     * @param eCallEventTwoDTO 工单
     * @return 工单集合
     */
    @Override
    public List<ECallEventTwoDTO> selectECallEventTwoList(ECallEventTwoDTO eCallEventTwoDTO) {
        return this.baseMapper.selectECallEventTwoList(eCallEventTwoDTO);
    }


}

 src/main/java/org/springblade/modules/eCallEventTwo/vo/ECallEventTwoVO.java

New file
@@ -0,0 +1,35 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.vo;

import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.core.tool.node.INode;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 * 工单 视图实体类
 *
 * @author BladeX
 * @since 2024-05-15
 */
@Data
@EqualsAndHashCode(callSuper = true)
public class ECallEventTwoVO extends ECallEventTwoEntity {
    private static final long serialVersionUID = 1L;

}

 src/main/java/org/springblade/modules/eCallEventTwo/wrapper/ECallEventTwoWrapper.java

New file
@@ -0,0 +1,50 @@
/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.eCallEventTwo.wrapper;

import org.springblade.core.mp.support.BaseEntityWrapper;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.eCallEventTwo.entity.ECallEventTwoEntity;
import org.springblade.modules.eCallEventTwo.vo.ECallEventTwoVO;
import java.util.Objects;

/**
 * 工单 包装类,返回视图层所需的字段
 *
 * @author BladeX
 * @since 2024-05-15
 */
public class ECallEventTwoWrapper extends BaseEntityWrapper<ECallEventTwoEntity, ECallEventTwoVO>  {

    public static ECallEventTwoWrapper build() {
        return new ECallEventTwoWrapper();
     }

    @Override
    public ECallEventTwoVO entityVO(ECallEventTwoEntity eCallEventTwo) {
        ECallEventTwoVO eCallEventTwoVO = Objects.requireNonNull(BeanUtil.copy(eCallEventTwo, ECallEventTwoVO.class));

        //User createUser = UserCache.getUser(eCallEventTwo.getCreateUser());
        //User updateUser = UserCache.getUser(eCallEventTwo.getUpdateUser());
        //eCallEventTwoVO.setCreateUserName(createUser.getName());
        //eCallEventTwoVO.setUpdateUserName(updateUser.getName());

        return eCallEventTwoVO;
    }


}