| | |
| | | circleDetailAppVO.setName(actDO.getName()); |
| | | } |
| | | } |
| | | if(circleDetailAppVO.getSolveId()!=null){ |
| | | AdministratorsUserVO user1 = this.baseMapper.selectUserByUserId(circleDetailAppVO.getSolveId()); |
| | | circleDetailAppVO.setSolveName(user1.getName()); |
| | | } |
| | | if(circleDetailAppVO.getSolveUnitId()!=null){ |
| | | ComPbCheckUnit comPbCheckUnit=comPbCheckUnitDao.selectById(circleDetailAppVO.getSolveUnitId()); |
| | | if(comPbCheckUnit!=null){ |
| | | circleDetailAppVO.setSolveName(comPbCheckUnit.getName()); |
| | | } |
| | | } |
| | | |
| | | if (neighborCircleAppDTO.getUserId() != null) { |
| | | // 查询邻里圈点赞信息 |
| | |
| | | |
| | | <select id="selectStatsUser" resultType="com.panzhihua.common.model.vos.neighbor.ServiceStaticsVO"> |
| | | select count(t1.checkId) as times,sum(t1.hours) as hours from ((select real_service_time as hours,solve_id as checkId from com_act_neighbor_circle canc left join sys_user su on canc.solve_id = su.user_id where order_type = 2 and solve_status = 4 and su.phone = #{phone} and canc.create_at between concat(#{date},'-01-01 00:00:00') and concat(#{date},'-12-31 23:59:59')) union all |
| | | (select duration as hours,caas.user_id as checkId from com_act_activity caa LEFT JOIN com_act_act_sign caas on caa.id = caas.activity_id left join sys_user su on caas.user_id = su.user_id where caas.`status` = 1 and su.phone =#{phone} and publish_at between concat(#{date},'-01-01 00:00:00') and concat(#{date},'-12-31 23:59:59'))) t1 |
| | | (select duration as hours,caas.user_id as checkId from com_act_activity caa LEFT JOIN com_act_act_regist caas on caa.id = caas.activity_id left join sys_user su on caas.user_id = su.user_id where caas.type = 2 and su.phone =#{phone} and publish_at between concat(#{date},'-01-01 00:00:00') and concat(#{date},'-12-31 23:59:59') group by caa.id)) t1 |
| | | </select> |
| | | |
| | | <select id="selectListByPhone" resultType="com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleAppVO"> |