| | |
| | | private final IComplaintCommentService complaintCommentService; |
| | | private final HttpServletResponse response; |
| | | private final IPartyMemberService partyMemberService; |
| | | private final IComplaintCommentService complaintCommentService; |
| | | |
| | | @Override |
| | | public void saveComplaint(Complaint complaint, LoginUserInfoVO loginUserInfoVO) { |
| | |
| | | |
| | | |
| | | <select id="getTimeoutAndNotComment" resultType="com.panzhihua.sangeshenbian.model.entity.Complaint"> |
| | | select * from sgsb_complaint where status = 3 and DATE_ADD(completion_time, INTERVAL 10 DAY) <= NOW() |
| | | select * from sgsb_complaint where status = 3 and DATE_ADD(completion_time, INTERVAL 10 DAY) <= NOW() and id not in (select complaint_id from sgsb_complaint_comment where del_flag = 0) |
| | | </select> |
| | | </mapper> |