花城 修改微心愿集星数量列表 详情显示不一致 修改 随手拍一键认领可以多人同时认领

lidongdong

2024-05-31 2234e8a7e8018b4881581b82c31fd60024c00848

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java

@@ -119,48 +119,48 @@

    IPage<ComActMicroWishVO> pageMicroWishApplets(Page page, @Param("comActMicroWishVO") ComActMicroWishVO comActMicroWishVO);

    @Select("SELECT " +
            "w.id, " +
            "u.name sponsor_name, " +
            "u.nick_name userNickName, " +
            "w.create_at, " +
            "w.aim_num, " +
            "u.image_url, " +
            "w.sponsor_phone, " +
            "w.`status`, " +
            "w.`sponsor_id`, " +
            "w.wish_name, " +
            "count(wu.id)starNum, " +
            "w.detail, " +
            "w.photo_path_list, " +
            "su.`name` responsible_name, " +
            "w.form, " +
            "w.reject_reason, " +
            "w.community_id, " +
            "w.examine_at, " +
            "w.finish, " +
            "w.finish_photo_path_list, " +
            "w.finish_at, " +
            "w.score, " +
            "w.feedback, " +
            "w.feedback_at, " +
            "w.feedback_photo_path_list, " +
            "w.distribution_at, " +
            "w.evaluate_at, " +
            "w.img_width, " +
            "w.img_height, " +
            "w.handle_id, " +
            "w.evaluate  " +
            "FROM " +
            "com_act_micro_wish w " +
            "LEFT JOIN sys_user u ON w.sponsor_id = u.user_id " +
            "LEFT JOIN com_pb_service_team su ON w.responsible_id = su.id  " +
            "LEFT JOIN com_act_micro_wish_user wu ON w.id = wu.micro_wish_id  " +
            "WHERE " +
            "w.id =#{id}"+
            " group by w.id " +
            "order by w.create_at desc"
    )
//    @Select("SELECT " +
//            "w.id, " +
//            "u.name sponsor_name, " +
//            "u.nick_name userNickName, " +
//            "w.create_at, " +
//            "w.aim_num, " +
//            "u.image_url, " +
//            "w.sponsor_phone, " +
//            "w.`status`, " +
//            "w.`sponsor_id`, " +
//            "w.wish_name, " +
//            "count(wu.id)starNum, " +
//            "w.detail, " +
//            "w.photo_path_list, " +
//            "su.`name` responsible_name, " +
//            "w.form, " +
//            "w.reject_reason, " +
//            "w.community_id, " +
//            "w.examine_at, " +
//            "w.finish, " +
//            "w.finish_photo_path_list, " +
//            "w.finish_at, " +
//            "w.score, " +
//            "w.feedback, " +
//            "w.feedback_at, " +
//            "w.feedback_photo_path_list, " +
//            "w.distribution_at, " +
//            "w.evaluate_at, " +
//            "w.img_width, " +
//            "w.img_height, " +
//            "w.handle_id, " +
//            "w.evaluate  " +
//            "FROM " +
//            "com_act_micro_wish w " +
//            "LEFT JOIN sys_user u ON w.sponsor_id = u.user_id " +
//            "LEFT JOIN com_pb_service_team su ON w.responsible_id = su.id  " +
//            "LEFT JOIN com_act_micro_wish_user wu ON w.id = wu.micro_wish_id  " +
//            "WHERE " +
//            "w.id =#{id}"+
//            " group by w.id " +
//            "order by w.create_at desc"
//    )
    ComActMicroWishVO detailMicroWish(Long id);
    @Select("SELECT " +
            "'2' type " +