| | |
| | | } |
| | | @ApiOperation(value = "新版查看详情",response = ComActAcidRecordVO.class) |
| | | @GetMapping("/detailByApp") |
| | | public R detailByApp(@RequestParam("id")Long id){ |
| | | return this.communityService.detailByApp(id); |
| | | public R detailByApp(@RequestParam("id")Long id,@RequestParam("localCity")String localCity){ |
| | | return this.communityService.detailByApp(id,localCity); |
| | | } |
| | | |
| | | /** |
| | |
| | | * @return 删除结果 |
| | | */ |
| | | @GetMapping("/comActAcidRecord/detailByApp") |
| | | R detailByApp(@RequestParam("id") Long id); |
| | | R detailByApp(@RequestParam("id") Long id,@RequestParam("localCity")String localCity); |
| | | |
| | | @GetMapping("/comActAcidRecord/charts") |
| | | R charts(@RequestParam("date")String date,@RequestParam("localCity")String localCity); |
| | |
| | | } |
| | | |
| | | @GetMapping("/detailByApp") |
| | | public R detailByApp(@RequestParam("id")Long id){ |
| | | return this.comActAcidRecordService.detailByApp(id); |
| | | public R detailByApp(@RequestParam("id")Long id,@RequestParam("localCity")String localCity){ |
| | | return this.comActAcidRecordService.detailByApp(id,localCity); |
| | | } |
| | | } |
| | |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import com.panzhihua.service_community.entity.ComActAcidRecord; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | ComActAcidRecordVO selectLastNext(Long id); |
| | | ComActAcidRecordVO selectLastNext(@RequestParam("id") Long id,@RequestParam("localCity")String localCity); |
| | | |
| | | /** |
| | | * 查询区级填报人数 |
| | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; |
| | | import com.panzhihua.service_community.entity.ComActAcidRecord; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | |
| | | /** |
| | | * (ComActAcidRecord)表服务接口 |
| | |
| | | * @param id |
| | | * @return |
| | | */ |
| | | R detailByApp(Long id); |
| | | R detailByApp(Long id,String localCity); |
| | | |
| | | /** |
| | | * 后台查看详情 |
| | |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.math.BigDecimal; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R detailByApp(Long id) { |
| | | public R detailByApp(Long id,String localCity) { |
| | | ComActAcidRecord comActAcidRecord=this.baseMapper.selectById(id); |
| | | ComActAcidRecordVO comActAcidRecordVO=this.baseMapper.selectLastNext(id); |
| | | ComActAcidRecordVO comActAcidRecordVO=this.baseMapper.selectLastNext(id,localCity); |
| | | BeanUtils.copyProperties(comActAcidRecord,comActAcidRecordVO); |
| | | return R.ok(comActAcidRecordVO); |
| | | } |
| | |
| | | </select> |
| | | |
| | | <select id="selectLastNext" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO"> |
| | | select(select min(id) from com_act_acid_record where id > #{id} and check_status = 0) next_id, |
| | | (select max(id) as next_id from com_act_acid_record where #{id} > id and check_status = 0) last_id |
| | | select(select min(id) from com_act_acid_record where id > #{id} and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like |
| | | concat('%',#{localCity},'%')</if>) next_id, |
| | | (select max(id) as next_id from com_act_acid_record where #{id} > id and check_status = 0 <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and local_city like |
| | | concat('%',#{localCity},'%')</if>) last_id |
| | | </select> |
| | | |
| | | <select id="selectAcidCount" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidChartsVO"> |