| | |
| | | public enum EventTasksStatusEnum { |
| | | |
| | | DZF(1,"待走访"), |
| | | JXZ(2,"进行中"), |
| | | ZJJJ(3,"正常"), |
| | | DYZ(4,"待验证"), |
| | | CG(5,"草稿"), |
| | | YJJ(2,"已解决"), |
| | | ZJJJ(3,"待验证"), |
| | | DYZ(4,"草稿箱"), |
| | | CG(5,"已撤销"), |
| | | YCX(6,"已撤销"), |
| | | YC(7,"异常"), |
| | | ; |
| | |
| | | LEFT JOIN com_act AS ca ON ca.community_id = cauwt.community_id |
| | | where cauwt.community_id = #{walletTradeDTO.communityId} |
| | | and cauwt.user_id = #{walletTradeDTO.userId} |
| | | |
| | | order by cauwt.create_at desc |
| | | </select> |
| | | |
| | | <select id="getUserWalletTradeAdmin" parameterType="com.panzhihua.common.model.dtos.community.wallet.PageComActWalletTradeAdminDTO" |
| | |
| | | start.setGridMember(Long.valueOf(map.get("user_id").toString())); |
| | | start.setGridMemberName(map.get("name").toString()); |
| | | start.setGridMenberTele(map.get("phone") ==null?"":map.get("phone").toString()); |
| | | start.setEventStatus(EventTasksStatusEnum.JXZ.getCode()); |
| | | start.setEventStatus(EventTasksStatusEnum.YJJ.getCode()); |
| | | int rt = eventVisitingTasksMapper.start(start); |
| | | if(rt > 0){ |
| | | return R.ok(); |
| | |
| | | |
| | | EventVisitingTasksDO complete = new EventVisitingTasksDO(); |
| | | BeanUtils.copyProperties(taskCompleteDTO,complete); |
| | | if(taskCompleteDTO.getException() == 0){ |
| | | complete.setEventStatus(EventTasksStatusEnum.ZJJJ.getCode()); |
| | | }else{ |
| | | complete.setEventStatus(EventTasksStatusEnum.YC.getCode()); |
| | | } |
| | | complete.setEventStatus(EventTasksStatusEnum.YJJ.getCode()); |
| | | |
| | | complete.setSubmitDate(DateUtil.parse(taskCompleteDTO.getSubmitDate(), DatePattern.NORM_DATETIME_FORMAT)); |
| | | if(StringUtils.isNotEmpty(eventVisitingTasksDO.getTableContentJson())){ |
| | | JSONObject json = JSONObject.parseObject(eventVisitingTasksDO.getTableContentJson()); |
| | |
| | | complete.setGridMemberName(map.get("name").toString()); |
| | | complete.setGridMenberTele(map.get("phone") ==null?"":map.get("phone").toString()); |
| | | |
| | | int rt = eventVisitingTasksMapper.complete(complete); |
| | | int rt = eventVisitingTasksMapper.updateById(complete); |
| | | if(rt > 0){ |
| | | return R.ok(); |
| | | } |
| | |
| | | FROM |
| | | event_visiting_tasks |
| | | WHERE |
| | | event_status = 1 |
| | | OR event_status = 3 |
| | | grid_id = #{eventGridTodoDataDTO.gridId} and (event_status = 1 OR event_status = 3) |
| | | </select> |
| | | |
| | | <select id="getComActByActId" resultType="com.panzhihua.common.model.vos.grid.ComGridActVO"> |
| | |
| | | <if test = "query.exception != null"> |
| | | and vt.exception = #{query.exception} |
| | | </if> |
| | | <if test = "query.status != null and query.status == 2"> |
| | | and vt.event_status = 2 |
| | | </if> |
| | | <if test = "query.eventStatus == 3 or query.eventStatus == 7"> |
| | | and vt.event_status = #{query.eventStatus} |
| | | </if> |