运营后台用户管理

huanghongfa

2020-12-30 b1da1a1fd20d2392e0b686ba1ea72cd9eba7e723

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

@@ -28,6 +28,7 @@
            "su.`name` handler_name,\n" +
            "p.`status`,\n" +
            "p.`detail`,\n" +
            "p.`photo_path_list`,\n" +
            "p.create_at,\n" +
            "p.examine_at \n" +
            "FROM\n" +
@@ -68,7 +69,7 @@
    @Select("SELECT \n" +
            "p.id,\n" +
            "p.create_at,\n" +
            "u.`name`,\n" +
            "u.`name` sponsorName,\n" +
            "u.`image_url`,\n" +
            "u.phone,\n" +
            "p.detail,\n" +
@@ -78,11 +79,13 @@
            "su.`name`,\n" +
            "p.handle_result,\n" +
            "p.photo_path_list,\n" +
            "count(pu.id)giveThumbsUpNum,\n" +
            "p.handle_photo_list\n" +
            "FROM\n" +
            "com_act_easy_photo p\n" +
            "JOIN sys_user u on p.sponsor_id=u.user_id\n" +
            "LEFT JOIN sys_user su on p.handler_id=su.user_id\n" +
            "LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id\n" +
            "WHERE p.id=#{id}")
    ComActEasyPhotoVO detailEasyPhoto(Long id);
}