| | |
| | | <if test="comActDynVO.isOrgHatch == 1"> |
| | | AND (cadt.`name` = '社会组织培训' OR cadt.`name` = '社工培训') |
| | | </if> |
| | | GROUP BY d.id ORDER BY d.is_topping DESC, d.create_at DESC |
| | | ORDER BY d.is_topping DESC, d.create_at DESC |
| | | </select> |
| | | <select id="pageDynamicByAdmin" resultType="com.panzhihua.common.model.vos.community.ComActDynVO"> |
| | | SELECT d.id, d.title, COUNT(u.id)readNum, d.`status`, d.`content`, d.`cover`, d.`type`, d.`cover_mode`, |
| | |
| | | <if test="comActDynVO.publishAtBegin != null and comActDynVO.publishAtBegin != '' "> |
| | | AND (d.publish_at BETWEEN #{comActDynVO.publishAtBegin} AND #{comActDynVO.publishAtEnd}) |
| | | </if> |
| | | group by d.id order by d.is_topping desc, d.create_at desc |
| | | order by d.is_topping desc, d.create_at desc |
| | | </select> |
| | | </mapper> |