| | |
| | | |
| | | @ApiModelProperty("类别(1.社区动态 2.招募公告 3.考察记录 4.评审公示 5.孵化培育 6.出壳成果)") |
| | | private Integer category; |
| | | |
| | | @ApiModelProperty("显示时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date releaseTime; |
| | | } |
| | |
| | | private Integer category; |
| | | |
| | | private Integer readNum; |
| | | |
| | | private Date releaseTime; |
| | | } |
| | |
| | | d.create_at, |
| | | cadt.`name` AS typeName, |
| | | cadt.color AS typeColor, |
| | | ca.NAME AS communityName |
| | | ca.NAME AS communityName, |
| | | d.release_time |
| | | FROM |
| | | com_act_dyn d |
| | | LEFT JOIN ( SELECT dyn_id, count( id ) AS readNum FROM com_act_dyn_user GROUP BY dyn_id ) u ON d.id = u.dyn_id |
| | |
| | | </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`, |
| | | d.is_topping, d.publish_at, d.create_at, cadt.`name` as typeName, ca.name as communityName |
| | | d.is_topping, d.publish_at, d.create_at, cadt.`name` as typeName, ca.name as communityName,d.release_time |
| | | FROM com_act_dyn d |
| | | LEFT JOIN com_act_dyn_user u ON d.id = u.dyn_id |
| | | LEFT JOIN com_act_dyn_type as cadt ON cadt.id = d.type |