| | |
| | | |
| | | @Select("<script> " + |
| | | "SELECT\n" + |
| | | "a.id activityId,\n" + |
| | | "a.NAME,\n" + |
| | | "a.id,\n" + |
| | | "a.name,\n" + |
| | | "a.address,\n" + |
| | | "a.status,\n" + |
| | | "a.create_at releaseTimeBegin,\n" + |
| | | "a.activity_time_begin,\n" + |
| | | "a.activity_time_end,\n" + |
| | | "a.enroll_time_begin,\n" + |
| | | "a.release_time,\n" + |
| | | "a.enroll_time_end \n" + |
| | | "FROM\n" + |
| | | "com_pb_activity_member m\n" + |
| | | "JOIN com_pb_activity a ON m.activity_id = a.id \n" + |
| | | "WHERE\n" + |
| | | "m.member_id = 1 \n" + |
| | | "m.member_id = #{id} \n" + |
| | | "<if test='name != null and name.trim() != ""'>" + |
| | | "AND a.`name` = #{name} \n" + |
| | | " </if> " + |