package com.qxueyou.scc.portal.homepage.dao;
|
|
//import com.qxueyou.entity.article.ArticleDO;
|
//import com.qxueyou.service.MongoService;
|
//import com.qxueyou.util.CollectionUtils;
|
import com.qxueyou.scc.base.dao.BaseDAO;
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.util.ClientUtils;
|
import com.qxueyou.scc.base.util.CollectionUtils;
|
import com.qxueyou.scc.portal.information.model.Information;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.domain.PageRequest;
|
import org.springframework.data.domain.Sort;
|
//import org.springframework.data.mongodb.core.query.Criteria;
|
//import org.springframework.data.mongodb.core.query.Query;
|
//import org.springframework.data.mongodb.core.query.Update;
|
import org.springframework.stereotype.Repository;
|
|
import javax.annotation.PostConstruct;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* @author ZERO 2021-03-03 16:36
|
*/
|
@Repository
|
public class ArticleDao extends BaseDAO {
|
|
|
|
|
|
public Map<String, Object> moreOccupation(String type, String subColumn, String numbers,int page, int size, String keyword) {
|
|
StringBuffer hql = new StringBuffer(500);
|
hql.append( "from Information where deleteFlag=0 and type = ? and status= ?");
|
List<Object> params = CollectionUtils.newList(type, Information.UP_STATUS);
|
|
// Map<String, Object> condition = CollectionUtils.newObjectMap("type", type, "status", Information.UP_STATUS);
|
if(StringUtils.isNotEmpty(keyword)){
|
hql.append( " and title = ? ");
|
params.add(keyword);
|
}
|
if (type.equals("examBriefing")) {
|
hql.append( "and subColumn = ? ");
|
params.add( subColumn);
|
}
|
// if(subColumn!=null) {
|
// if (subColumn.equals("previousContest")) {
|
// condition.put("numbers", numbers);
|
// }
|
// }
|
|
|
long totalCount = findCount(hql.toString(),params);
|
hql.append( "order by dateTime desc");
|
|
List<Information> articleList = findList(hql.toString(),new Pager(page,size),params,Information.class);
|
|
|
List<Map<String, Object>> data = articleList
|
.stream()
|
.map(article -> CollectionUtils.newObjectMap(
|
"id", article.getId(),
|
"content", article.getContent(),
|
"title", article.getTitle(),
|
"attachment", article.getAttachment(),
|
"browseCount", article.getBrowseCount(),
|
"status", article.getStatus(),
|
"thumbnailUrl", article.getThumbnailUrl(),
|
"type", article.getType(),
|
"dateTime", article.getDateTime(),
|
"competition",article.getCompetition()))
|
.collect(Collectors.toList());
|
|
return CollectionUtils.newObjectMap("totalCount", totalCount, "data", data);
|
}
|
|
public Map<String, Object> getVideoList(String type, String subColumn,int page, int size){
|
StringBuffer hql = new StringBuffer(500);
|
hql.append( "from Information where deleteFlag=0 and type = ? and status= ? ");
|
List<Object> params = CollectionUtils.newList(type, Information.UP_STATUS);
|
// Map<String, Object> condition = CollectionUtils.newObjectMap("type", type, "status", Information.UP_STATUS);
|
|
if (type.equals("examBriefing")) {
|
hql.append( "and subColumn = ? ");
|
params.add( subColumn);
|
}
|
long totalCount = findCount(hql.toString(),params);
|
hql.append( "order by dateTime desc");
|
|
|
List<Information> articleList =findList(hql.toString(),new Pager(page,size),params,Information.class);
|
List<Map<String, Object>> data = articleList
|
.stream()
|
.map(article -> CollectionUtils.newObjectMap(
|
"title", article.getTitle(),
|
"type", article.getType(),
|
"dateTime", article.getDateTime(),
|
"videoUrl",article.getVideoUrl(),
|
"name",article.getNumbers()))
|
.collect(Collectors.toList());
|
|
return CollectionUtils.newObjectMap("totalCount", totalCount, "data", data);
|
}
|
//
|
public boolean exist(String type) {
|
String hql= "from Information where deleteFlag=0 and type = ? and status= ? ";
|
long totalCount = findCount(hql,CollectionUtils.newList(type, Information.UP_STATUS));
|
return totalCount>0?true:false;
|
}
|
//
|
public boolean existsubColumn(String type, String subColumn) {
|
|
|
String hql= "from Information where deleteFlag=0 and type = ? and status= ? and subColumn=?";
|
long totalCount = findCount(hql,CollectionUtils.newList(type, Information.UP_STATUS,subColumn));
|
return totalCount>0?true:false;
|
}
|
|
public Map<String, Object> getPreAndBehindArticle(String currentArticleId, String type) {
|
StringBuffer hql = new StringBuffer(500);
|
hql.append("from Information where deleteFlag=0 and type = ? and status= ? order by updateTime desc");
|
List<Object> params = CollectionUtils.newList(type, Information.UP_STATUS);
|
// Query query = Query.query(Criteria.where("type").is(type)
|
// .and("status").is(ArticleDO.UP_STATUS)
|
// .and("deleteFlag").is(false))
|
// .with(Sort.by(Sort.Direction.DESC, "updateTime"));
|
// query.fields().include("id");
|
// List<Information> articleList =find(hql.toString(),params,Information.class);
|
List<String> articleIdList = find(hql.toString(),params,Information.class)
|
.stream()
|
.map(Information::getId)
|
.collect(Collectors.toList());
|
|
int currentIndex = articleIdList.indexOf(currentArticleId);
|
|
Map<String, Object> data = CollectionUtils.newObjectMap("previous", null, "behind", null);
|
|
if (currentIndex != 0) {
|
Information preArticle = read(Information.class,articleIdList.get(currentIndex - 1));
|
data.put("previous", CollectionUtils.newObjectMap(
|
"id", preArticle.getId(),
|
"title", preArticle.getTitle(),
|
"type", preArticle.getType()));
|
}
|
|
if (currentIndex != articleIdList.size() - 1) {
|
Information behindArticle = read(Information.class,articleIdList.get(currentIndex + 1));
|
data.put("previous", CollectionUtils.newObjectMap(
|
"id", behindArticle.getId(),
|
"title", behindArticle.getTitle(),
|
"type", behindArticle.getType()));
|
}
|
|
return data;
|
}
|
//
|
public void incBrowseCount(String id) {
|
// Query query = Query.query(Criteria.where("id").is(id));
|
// Update update = new Update();
|
// update.inc("browseCount", 1);
|
// template.updateFirst(query, update, clz);
|
Information behindArticle = read(Information.class,id);
|
behindArticle.setBrowseCount(behindArticle.getBrowseCount()+1);
|
saveOrUpdate(behindArticle);
|
}
|
|
public Information getArticle(String type,String subColumn)
|
{
|
StringBuffer hql = new StringBuffer(500);
|
hql.append( "from Information where deleteFlag=0 and type = ? and status= ? order by updateTime desc");
|
List<Object> params = CollectionUtils.newList(type, Information.UP_STATUS);
|
|
if (type.equals("examBriefing")) {
|
hql.append( "and subColumn = ? ");
|
params.add( subColumn);
|
}
|
// Query query = Query.query(Criteria.where("type").is(type)
|
// .and("status").is(ArticleDO.UP_STATUS)
|
// .and("deleteFlag").is(false))
|
// .with(Sort.by(Sort.Direction.DESC, "updateTime"));
|
// System.out.println(type);
|
// if (type.equals("examBriefing")) {
|
// query.addCriteria(Criteria.where("subColumn").is(subColumn));
|
// }
|
Information articleDO = findUnique(hql.toString(), params, Information.class);
|
// ArticleDO articleDO =findOne(query,ArticleDO.class);
|
return articleDO;
|
}
|
}
|
