DeleteQuestionAnswerCmd.java
7.66 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
/*
* Copyright 2017-2020 吴学文 and java110 team.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.java110.user.cmd.question;
import com.alibaba.fastjson.JSONObject;
import com.java110.core.annotation.Java110Cmd;
import com.java110.core.annotation.Java110Transactional;
import com.java110.core.context.ICmdDataFlowContext;
import com.java110.core.event.cmd.Cmd;
import com.java110.core.event.cmd.CmdEvent;
import com.java110.dto.question.QuestionAnswerTitleRelDto;
import com.java110.intf.user.*;
import com.java110.po.question.QuestionAnswerPo;
import com.java110.po.question.QuestionAnswerTitleRelPo;
import com.java110.po.question.QuestionTitlePo;
import com.java110.po.question.QuestionTitleValuePo;
import com.java110.po.user.UserQuestionAnswerPo;
import com.java110.utils.exception.CmdException;
import com.java110.utils.util.Assert;
import com.java110.utils.util.BeanConvertUtil;
import com.java110.vo.ResultVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.util.List;
/**
* 类表述：删除问题回答命令类
* 服务编码：questionAnswer.deleteQuestionAnswer
* 请求路劲：/app/questionAnswer.DeleteQuestionAnswer
* 功能描述：该类负责处理删除问题回答及其相关数据的业务逻辑，包括删除问题回答、题目关联、题目信息、题目选项和用户投票记录
* add by 吴学文 at 2023-07-13 00:03:56 mail: 928255095@qq.com
* open source address: https://gitee.com/wuxw7/MicroCommunity
* 官网：http://www.homecommunity.cn
* 温馨提示：如果您对此文件进行修改 请不要删除原有作者及注释信息，请补充您的 修改的原因以及联系邮箱如下
* // modify by 张三 at 2021-09-12 第10行在某种场景下存在某种bug 需要修复，注释10至20行 加入 20行至30行
*/
@Java110Cmd(serviceCode = "question.deleteQuestionAnswer")
public class DeleteQuestionAnswerCmd extends Cmd {
/**
* 日志记录器
*/
private static Logger logger = LoggerFactory.getLogger(DeleteQuestionAnswerCmd.class);
/**
* 问题回答服务接口
*/
@Autowired
private IQuestionAnswerV1InnerServiceSMO questionAnswerV1InnerServiceSMOImpl;
/**
* 问题回答与题目关联服务接口
*/
@Autowired
private IQuestionAnswerTitleRelV1InnerServiceSMO questionAnswerTitleRelV1InnerServiceSMOImpl;
/**
* 题目信息服务接口
*/
@Autowired
private IQuestionTitleV1InnerServiceSMO questionTitleV1InnerServiceSMOImpl;
/**
* 题目选项服务接口
*/
@Autowired
private IQuestionTitleValueV1InnerServiceSMO questionTitleValueV1InnerServiceSMOImpl;
/**
* 用户问题回答服务接口
*/
@Autowired
private IUserQuestionAnswerV1InnerServiceSMO userQuestionAnswerV1InnerServiceSMOImpl;
/**
* 参数验证方法
* 功能描述：验证请求参数是否包含必要的字段
* @param event 命令事件对象，包含命令执行的相关信息
* @param cmdDataFlowContext 命令数据流上下文，用于获取和设置请求响应数据
* @param reqJson 请求参数JSON对象，包含客户端传递的参数
* @throws CmdException 当参数验证失败时抛出异常
*/
@Override
public void validate(CmdEvent event, ICmdDataFlowContext cmdDataFlowContext, JSONObject reqJson) {
// 验证请求参数中必须包含qaId字段
Assert.hasKeyAndValue(reqJson, "qaId", "qaId不能为空");
// 验证请求参数中必须包含communityId字段
Assert.hasKeyAndValue(reqJson, "communityId", "communityId不能为空");
}
/**
* 执行删除命令方法
* 功能描述：执行删除问题回答及其相关数据的完整业务流程，包括删除问题回答、题目关联、题目信息、题目选项和用户投票记录
* 该方法采用事务处理，确保所有删除操作要么全部成功，要么全部回滚
* @param event 命令事件对象，包含命令执行的相关信息
* @param cmdDataFlowContext 命令数据流上下文，用于获取和设置请求响应数据
* @param reqJson 请求参数JSON对象，包含客户端传递的参数
* @throws CmdException 当删除操作失败时抛出异常
*/
@Override
@Java110Transactional
public void doCmd(CmdEvent event, ICmdDataFlowContext cmdDataFlowContext, JSONObject reqJson) throws CmdException {
// 将请求参数转换为问题回答PO对象
QuestionAnswerPo questionAnswerPo = BeanConvertUtil.covertBean(reqJson, QuestionAnswerPo.class);
// 调用服务删除问题回答记录
int flag = questionAnswerV1InnerServiceSMOImpl.deleteQuestionAnswer(questionAnswerPo);
// 检查删除操作是否成功
if (flag < 1) {
throw new CmdException("删除数据失败");
}
// 构建查询条件，查找问题回答与题目的关联关系
QuestionAnswerTitleRelDto questionAnswerTitleRelDto = new QuestionAnswerTitleRelDto();
questionAnswerTitleRelDto.setQaId(reqJson.getString("qaId"));
questionAnswerTitleRelDto.setCommunityId(reqJson.getString("communityId"));
// 查询问题回答与题目的关联记录
List<QuestionAnswerTitleRelDto> questionAnswerTitleRelDtos = questionAnswerTitleRelV1InnerServiceSMOImpl.queryQuestionAnswerTitleRels(questionAnswerTitleRelDto);
// 如果没有找到关联记录，直接返回成功
if (questionAnswerTitleRelDtos == null || questionAnswerTitleRelDtos.size() < 1) {
return;
}
// 删除问题回答与题目的关联记录
QuestionAnswerTitleRelPo questionAnswerTitleRelPo = new QuestionAnswerTitleRelPo();
questionAnswerTitleRelPo.setQatrId(questionAnswerTitleRelDtos.get(0).getQatrId());
questionAnswerTitleRelPo.setCommunityId(reqJson.getString("communityId"));
questionAnswerTitleRelV1InnerServiceSMOImpl.deleteQuestionAnswerTitleRel(questionAnswerTitleRelPo);
// 删除题目信息记录
QuestionTitlePo questionTitlePo = new QuestionTitlePo();
questionTitlePo.setTitleId(questionAnswerTitleRelDtos.get(0).getTitleId());
questionTitlePo.setCommunityId(reqJson.getString("communityId"));
questionTitleV1InnerServiceSMOImpl.deleteQuestionTitle(questionTitlePo);
// 删除题目选项记录
QuestionTitleValuePo questionTitleValuePo = new QuestionTitleValuePo();
questionTitleValuePo.setTitleId(questionAnswerTitleRelDtos.get(0).getTitleId());
questionTitleValuePo.setCommunityId(reqJson.getString("communityId"));
questionTitleValueV1InnerServiceSMOImpl.deleteQuestionTitleValue(questionTitleValuePo);
// 删除用户投票记录
UserQuestionAnswerPo userQuestionAnswerPo = new UserQuestionAnswerPo();
userQuestionAnswerPo.setQaId(reqJson.getString("qaId"));
userQuestionAnswerPo.setCommunityId(reqJson.getString("communityId"));
userQuestionAnswerV1InnerServiceSMOImpl.deleteUserQuestionAnswer(userQuestionAnswerPo);
// 设置响应结果为成功
cmdDataFlowContext.setResponseEntity(ResultVo.success());
}
}