From 047ced202f052d70c50f4365b2d86810de076489 Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Wed, 15 May 2024 17:57:49 +0800
Subject: [PATCH] E呼即办2
---
src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.java | 61 +++
src/main/java/org/springblade/modules/eCallEventTwo/service/IECallEventTwoService.java | 60 +++
src/main/java/org/springblade/modules/eCallEventTwo/entity/ECallEventTwoEntity.java | 266 ++++++++++++++++
src/main/java/org/springblade/modules/eCallEventTwo/dto/ECallEventTwoDTO.java | 34 ++
src/main/java/org/springblade/modules/eCallEventTwo/wrapper/ECallEventTwoWrapper.java | 50 +++
src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.xml | 214 +++++++++++++
src/main/java/org/springblade/modules/eCallEventTwo/controller/ECallEventTwoController.java | 126 +++++++
src/main/java/org/springblade/modules/eCallEventTwo/vo/ECallEventTwoVO.java | 35 ++
src/main/java/org/springblade/modules/eCallEventTwo/service/impl/EcCallEventTwoServiceImpl.java | 69 ++++
9 files changed, 915 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/controller/ECallEventTwoController.java b/src/main/java/org/springblade/modules/eCallEventTwo/controller/ECallEventTwoController.java
new file mode 100644
index 0000000..cd8635f
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/controller/ECallEventTwoController.java
@@ -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)));
+ }
+
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/dto/ECallEventTwoDTO.java b/src/main/java/org/springblade/modules/eCallEventTwo/dto/ECallEventTwoDTO.java
new file mode 100644
index 0000000..d664a05
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/dto/ECallEventTwoDTO.java
@@ -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;
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/entity/ECallEventTwoEntity.java b/src/main/java/org/springblade/modules/eCallEventTwo/entity/ECallEventTwoEntity.java
new file mode 100644
index 0000000..b50ff3d
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/entity/ECallEventTwoEntity.java
@@ -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;
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.java b/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.java
new file mode 100644
index 0000000..ca0f81c
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.java
@@ -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);
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.xml b/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.xml
new file mode 100644
index 0000000..cc0ddb0
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/mapper/EcCallEventTwoMapper.xml
@@ -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>
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/service/IECallEventTwoService.java b/src/main/java/org/springblade/modules/eCallEventTwo/service/IECallEventTwoService.java
new file mode 100644
index 0000000..9ba1dc5
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/service/IECallEventTwoService.java
@@ -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);
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/service/impl/EcCallEventTwoServiceImpl.java b/src/main/java/org/springblade/modules/eCallEventTwo/service/impl/EcCallEventTwoServiceImpl.java
new file mode 100644
index 0000000..73f8a7e
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/service/impl/EcCallEventTwoServiceImpl.java
@@ -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);
+ }
+
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/vo/ECallEventTwoVO.java b/src/main/java/org/springblade/modules/eCallEventTwo/vo/ECallEventTwoVO.java
new file mode 100644
index 0000000..9b42bc3
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/vo/ECallEventTwoVO.java
@@ -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;
+
+}
diff --git a/src/main/java/org/springblade/modules/eCallEventTwo/wrapper/ECallEventTwoWrapper.java b/src/main/java/org/springblade/modules/eCallEventTwo/wrapper/ECallEventTwoWrapper.java
new file mode 100644
index 0000000..49d8267
--- /dev/null
+++ b/src/main/java/org/springblade/modules/eCallEventTwo/wrapper/ECallEventTwoWrapper.java
@@ -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;
+ }
+
+
+}
--
Gitblit v1.9.3