标题/内容:
   
   用户名: 
   
   频道: 
   
   品牌: 
   
   分类: 
   
   
    全部
    出售
    求购
   
   帖子状态: 
   
    全部
    未删除
    已删除
    置顶
   
  
   
   

   发布时间:
    -
   
    查询
   
   

    全选
    反选
    置顶
    管理员删除
    取消置顶
    

    
    多选
    单选
    
   
   
   
  
   
  
  
 
 
 
 

  

  后台处理中。。。
  
 
 
 
 
 

　　{"total":67,"errmsg":"查询成功","errcode":1,"rows":[{"postId":77,"dealType":0,"title":"理解","partNo":null,"content":"理解[图片]","location":null,"tradeType":0,"brandId":0,"quantity":0,"contacts":"SakuraAoi","contactNumber":null,"color":null,"channelId":1,"createDate":"2018-10-16 10:12:19","updateDate":null,"status":0,"isDelete":0,"isAdmindel":0,"isTop":0,"replyNumber":0,"readNumber":0,"thumbNumber":0,"authorId":0,"isOem":0,"type":0,"amount":0.0,"channelPostAttach":[{"attachId":99,"postId":77,"uploadDate":1539655939000,"attachName":"record-attach/sell/371-20181016101221.png","type":10121001,"typeName":null,"attachNameUrl":""}],"nickName":"SakuraAoi","avatar":"","channelName":"新车交易","brandName":"长安铃木","startDate":null,"endDate":null,"brandIds":null,"channelIds":null,"strBrandIds":null,"strChannelIds":null,"begin":0,"end":0,"dealTypes":null,"isDeletes":null,"item":null,"value":0,"userId":0,"actId":0,"dealTypeName":null,"tradeTypeName":null,"isTopName":null,"createDate2":null}]}

public class BsChannelPost {
 private int postId;
 private int dealType;
 private String title;
 private String partNo;
 private String content;
 private String location;
 private int tradeType;
 private int brandId;
 private int quantity;
 private String contacts;
 private String contactNumber;
 private String color;
 private int channelId;
 @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") 
 private Date createDate;
 @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") 
 private Date updateDate;
 private int status;
 private int isDelete;
 private int isAdmindel;
 private int isTop;
 private int replyNumber;
 private int readNumber;
 private int thumbNumber;
 private int authorId;
 private int isOem;
 private int type;
 private double amount;
 private List channelPostAttach;//附件
 
 private String nickName;
 private String avatar;
 private String channelName;
 private String brandName;
 
 private String startDate;
 private String endDate;
 private List brandIds;
 private List channelIds;
 private String strBrandIds;
 private String strChannelIds;
 private int begin;
 private int end;
 private String dealTypes;
 private String isDeletes;
 
 private String item;
 private int value;
 private int userId;
 private int actId;
 
 private String dealTypeName;
 private String tradeTypeName;
 private String isTopName;
 private String createDate2;
}

import lombok.Data;
@Data//lombok 免写get set
public class BsChannelPostAttach {
 private int attachId;
 private int postId;
 private Date uploadDate;
 private String attachName;
 private int type;
 private String typeName;
 private String attachNameUrl;
}

 
    
    
  
  
  
   select attach_id attachId,post_id postId,upload_date uploadDate,attach_name attachName,type from bs_channel_post_attach where post_id = #{postId} order by attach_id 
  
  
  
  select p.post_id postId,u.nickname nickName,c.channel_name channelName,b.brand_name brandName,p.create_date createDate,p.title title,p.content content,p.part_no partNo,p.contacts contacts,u.avatar avatar,p.is_top isTop,
  is_delete isDelete,p.is_admindel isAdmindel,p.channel_id channelId
  from bs_channel_post p left join bs_channel c on p.channel_id=c.channel_id left join bs_brand b
  on p.brand_id=b.brand_id left join bs_user u on p.author_id=u.user_id where 1=1
  
   and (p.content like '%${content}%' or p.title like '%${content}%' )
  
  
   and u.nickname like '%${nickName}%'
  
  
   and p.deal_type=#{dealType}
  
  
   and (is_delete=0 and is_admindel=0)
  
  
   and (is_delete=1 or is_admindel=1)
  
  
   and is_top=1
  
  
    and p.brand_id in
     
      #{id}
     
  
  
    and p.channel_id in
     
      #{id}
     
  
  
   and p.create_date>#{beginDate}
  
  
   and p.create_date <#{endDate}
  
  
   and p.create_date between #{beginDate} and #{endDate}
  
   order by p.create_date desc limit #{begin},#{end}