| | |
| | | ter.id, |
| | | ter.content_type, |
| | | ter.content_url as contentUrlString, |
| | | ter.belong_type, |
| | | ter.subject_id, |
| | | ter.introduction, |
| | | ter.create_time, |
| | | ter.update_time, |
| | |
| | | ts.name as typeName |
| | | FROM |
| | | t_education_resource ter |
| | | INNER JOIN t_subject ts ON ts.id = ter.belong_type |
| | | INNER JOIN t_subject ts ON ts.id = ter.subject_id |
| | | <where> |
| | | AND ter.deleted = 0 |
| | | <if test="query.introduction != null and query.introduction != ''"> |
| | | AND ter.introduction like concat('%', #{query.subject}, '%') |
| | | </if> |
| | | <if test="query.belongType != null"> |
| | | AND ts.id = #{query.belongType} |
| | | <if test="query.subjectId != null"> |
| | | AND ts.id = #{query.subjectId} |
| | | </if> |
| | | </where> |
| | | ORDER BY |
| | |
| | | ter.id, |
| | | ter.content_type, |
| | | ter.content_url as contentUrlString, |
| | | ter.belong_type, |
| | | ter.subject_id, |
| | | ter.introduction, |
| | | ter.create_time, |
| | | ter.update_time, |
| | | ter.attachment as attachmentString |
| | | FROM |
| | | t_education_resource ter |
| | | INNER JOIN t_subject ts ON ts.id = tos.belong_type |
| | | INNER JOIN t_subject ts ON ts.id = ter.subject_id |
| | | <where> |
| | | AND ter.deleted = 0 |
| | | <if test="query.introduction != null and query.introduction != ''"> |
| | | AND ter.introduction like concat('%', #{query.subject}, '%') |
| | | </if> |
| | | <if test="query.belongType != null"> |
| | | AND ts.id = #{query.belongType} |
| | | <if test="query.subjectId != null"> |
| | | AND ts.id = #{query.subjectId} |
| | | </if> |
| | | </where> |
| | | ORDER BY |
| | |
| | | </select> |
| | | |
| | | <insert id="add" keyColumn="id" useGeneratedKeys="true"> |
| | | INSERT INTO t_education_resource(content_type, content_url, belong_type, introduction, create_time, update_time, |
| | | INSERT INTO t_education_resource(content_type, content_url, subject_id, introduction, create_time, update_time, |
| | | attachment) |
| | | value (#{form.contentType}, #{form.contentUrl}, #{form.belongType}, #{form.introduction}, #{form.createTime}, #{form.updateTime}, #{form.attachment}) |
| | | value (#{form.contentType}, #{form.contentUrl}, #{form.subjectId}, #{form.introduction}, #{form.createTime}, #{form.updateTime}, #{form.attachment}) |
| | | </insert> |
| | | |
| | | <update id="update"> |
| | |
| | | <set> |
| | | <if test="form.contentType != null and form.contentType != ''">content_type = #{form.contentType},</if> |
| | | <if test="form.contentUrl != null and form.contentUrl != ''">content_url = #{form.contentUrl},</if> |
| | | <if test="form.belongType != null">belong_type = #{form.belongType},</if> |
| | | <if test="form.subjectId != null">subject_id = #{form.subjectId},</if> |
| | | <if test="form.introduction != null and form.introduction != ''">introduction = #{form.introduction},</if> |
| | | <if test="form.updateTime != null">update_time = #{form.updateTime},</if> |
| | | attachment = #{form.attachment} |