| | |
| | | return newStriveForFeign.getNeedProblemList(pageNum,pageSize,kind,userId,getCommunityId()+""); |
| | | } |
| | | |
| | | |
| | | @ApiOperation(value = "任务需求清单我认领的列表", response = NeedProblemInventoryDTO.class) |
| | | @GetMapping("/getMyJoinNeedProblemList") |
| | | public R getMyJoinNeedProblemList(@RequestParam("pageNum") int pageNum, |
| | | @RequestParam("pageSize") int pageSize, |
| | | @RequestParam(value = "kind", required = false)String kind) |
| | | { |
| | | return newStriveForFeign.getMyJoinNeedProblemList(pageNum,pageSize,kind,getUserId()+""); |
| | | } |
| | | |
| | | |
| | | |
| | | @ApiOperation(value = "任务需求清单详情", response = NeedProblemInventoryDTO.class) |
| | | @GetMapping("/NeedProblem/getDetails") |
| | | public R getNeedProblemDetails(@RequestParam("id") String id) |
| | |
| | | @RequestParam(value = "userId", required = false)String userId, |
| | | @RequestParam(value = "communityId", required = false)String communityId); |
| | | |
| | | @GetMapping("/NeedProblem/getMyJoinNeedProblemList") |
| | | public R getMyJoinNeedProblemList(@RequestParam("pageNum") int pageNum, |
| | | @RequestParam("pageSize") int pageSize, |
| | | @RequestParam(value = "kind", required = false)String kind, |
| | | @RequestParam(value = "userId", required = false)String userId); |
| | | |
| | | |
| | | @GetMapping("/NeedProblem/getDetails") |
| | | public R getNeedProblemDetails(@RequestParam("id") String id); |
| | | |
| | |
| | | return R.ok(inventoryService.getList(pageNum,pageSize,kind,userId,communityId)); |
| | | } |
| | | |
| | | @GetMapping("/getMyJoinNeedProblemList") |
| | | public R getMyJoinNeedProblemList(@RequestParam("pageNum") int pageNum, |
| | | @RequestParam("pageSize") int pageSize, |
| | | @RequestParam(value = "kind", required = false)String kind, |
| | | @RequestParam(value = "userId", required = false)String userId) |
| | | { |
| | | return R.ok(inventoryService.getMyJoinList(pageNum,pageSize,kind,userId)); |
| | | } |
| | | |
| | | @GetMapping("/getDetails") |
| | | public R getNeedProblemDetails(@RequestParam("id") String id) |
| | | { |
| | |
| | | @Param("userId") String userId, |
| | | @Param("communityId") String communityId); |
| | | |
| | | IPage<NeedProblemInventoryDTO> getMyJoinList(Page page,@Param("kind") String kind, |
| | | @Param("userId") String userId); |
| | | |
| | | NeedProblemInventoryDTO getDetails(@Param("id")String id); |
| | | |
| | | int addData(@Param("item") NeedProblemInventoryDTO userIds); |
| | |
| | | |
| | | IPage<NeedProblemInventoryDTO> getList(int pageNum, int pageSize, String kind,String userId,String communityId); |
| | | |
| | | IPage<NeedProblemInventoryDTO> getMyJoinList(int pageNum, int pageSize, String kind,String userId); |
| | | |
| | | NeedProblemInventoryDTO getDetails(String id); |
| | | |
| | | int addData(NeedProblemInventoryDTO item); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public IPage<NeedProblemInventoryDTO> getMyJoinList(int pageNum, int pageSize, String kind, String userId) { |
| | | Page page = new Page<>(pageNum,pageSize); |
| | | return baseMapper.getMyJoinList(page,kind,userId); |
| | | } |
| | | |
| | | @Override |
| | | public NeedProblemInventoryDTO getDetails(String id) { |
| | | return baseMapper.getDetails(id); |
| | | } |
| | |
| | | |
| | | <select id="getList" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemInventoryDTO"> |
| | | SELECT |
| | | <include refid="Base_Column_List" /> |
| | | FROM |
| | | new_fight_need_problem_inventory |
| | | nfpi.id, |
| | | nfpi.title, |
| | | nfpi.classify_id, |
| | | canct.name as classifyName, |
| | | nfpi.claim_num, |
| | | nfpi.address, |
| | | nfpi.lat, |
| | | nfpi.lon, |
| | | nfpi.claim_start_time, |
| | | nfpi.claim_end_time, |
| | | nfpi.need_start_time, |
| | | nfpi.need_end_time, |
| | | nfpi.linkman, |
| | | nfpi.phone, |
| | | nfpi.sign_in_scope, |
| | | nfpi.sign_out_scope, |
| | | nfpi.award, |
| | | nfpi.content, |
| | | nfpi.imgs_url, |
| | | nfpi.creation_time, |
| | | nfpi.update_time, |
| | | nfpi.kind, |
| | | nfpi.community_id, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | | left join com_act_neighbor_circle_topic as canct on canct.id=nfpi.classify_id |
| | | <where> |
| | | 1=1 |
| | | <if test="kind !=null and kind != '' "> |
| | | and kind =#{kind} |
| | | and nfpi.kind =#{kind} |
| | | </if> |
| | | <if test="communityId !=null and communityId != '' "> |
| | | and community_id =#{communityId} |
| | | and nfpi.community_id =#{communityId} |
| | | </if> |
| | | <if test="userId !=null and userId != '' "> |
| | | and user_id =#{userId} |
| | | and nfpi.user_id =#{userId} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | |
| | | |
| | | <select id="getMyJoinList" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemInventoryDTO"> |
| | | SELECT |
| | | nfpi.id, |
| | | nfpi.title, |
| | | nfpi.classify_id, |
| | | canct.name as classifyName, |
| | | nfpi.claim_num, |
| | | nfpi.address, |
| | | nfpi.lat, |
| | | nfpi.lon, |
| | | nfpi.claim_start_time, |
| | | nfpi.claim_end_time, |
| | | nfpi.need_start_time, |
| | | nfpi.need_end_time, |
| | | nfpi.linkman, |
| | | nfpi.phone, |
| | | nfpi.sign_in_scope, |
| | | nfpi.sign_out_scope, |
| | | nfpi.award, |
| | | nfpi.content, |
| | | nfpi.imgs_url, |
| | | nfpi.creation_time, |
| | | nfpi.update_time, |
| | | nfpi.kind, |
| | | nfpi.community_id, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | | left join com_act_neighbor_circle_topic as canct on canct.id=nfpi.classify_id |
| | | <where> |
| | | 1=1 |
| | | <if test="kind !=null and kind != '' "> |
| | | and nfpi.kind =#{kind} |
| | | </if> |
| | | <if test="userId !=null and userId != '' "> |
| | | and nfpi.id in(SELECT task_id FROM new_fight_need_problem_claim where user_id=#{userId} ) |
| | | </if> |
| | | </where> |
| | | </select> |
| | |
| | | |
| | | <select id="getDetails" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemInventoryDTO"> |
| | | SELECT |
| | | <include refid="Base_Column_List" /> |
| | | FROM |
| | | new_fight_need_problem_inventory |
| | | nfpi.id, |
| | | nfpi.title, |
| | | nfpi.classify_id, |
| | | canct.name as classifyName, |
| | | nfpi.claim_num, |
| | | nfpi.address, |
| | | nfpi.lat, |
| | | nfpi.lon, |
| | | nfpi.claim_start_time, |
| | | nfpi.claim_end_time, |
| | | nfpi.need_start_time, |
| | | nfpi.need_end_time, |
| | | nfpi.linkman, |
| | | nfpi.phone, |
| | | nfpi.sign_in_scope, |
| | | nfpi.sign_out_scope, |
| | | nfpi.award, |
| | | nfpi.content, |
| | | nfpi.imgs_url, |
| | | nfpi.creation_time, |
| | | nfpi.update_time, |
| | | nfpi.kind, |
| | | nfpi.community_id, |
| | | nfpi.user_id |
| | | FROM new_fight_need_problem_inventory as nfpi |
| | | left join com_act_neighbor_circle_topic as canct on canct.id=nfpi.classify_id |
| | | <where> |
| | | 1=1 |
| | | <if test="id !=null and id != '' "> |
| | | and id =#{id} |
| | | and nfpi.id =#{id} |
| | | </if> |
| | | </where> |
| | | </select> |