liujie
2025-06-09 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActMicroWishDAO.java
@@ -118,48 +118,49 @@
    IPage<ComActMicroWishVO> pageMicroWishAdmin(Page page, @Param("comActMicroWishVO") ComActMicroWishVO comActMicroWishVO);
    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 " +
@@ -283,4 +284,20 @@
     * @return
     */
    IPage<ComActMicroWishVO> selectScreenDisplayList(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO);
    /**
     * 金沙定制页面-志愿线展示列表
     * @param page
     * @param pageBaseDTO
     * @return
     */
    IPage<ComActMicroWishVO> pagePartyBuildIngMicroWish(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO);
    /**
     * 金沙定制页面-四长四员解决问题展示列表
     * @param page
     * @param pageBaseDTO
     * @return
     */
    IPage<ComActMicroWishVO> pageFourMemberResolve(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO);
}