Java Criteria.orOperator方法代码示例

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 자신의 글 숫자를 셈 (자기가 보낸 쪽지는 제외).
 * @param publicTags
 * @param privateAndMassageTags
 * @param writer
 * @param search
 * @param sort
 * @return
 */
public long countMyPosts(List<String> publicTags,List<String> privateAndMassageTags, Weaver writer, 
		String search, String sort) {
	Criteria criteria = new Criteria();

	if(privateAndMassageTags != null)
		criteria.orOperator(Criteria.where("writer").is(writer).and("kind").ne(3),
				Criteria.where("tags").in(privateAndMassageTags));
	else
		criteria.orOperator(Criteria.where("writer").is(writer).and("kind").ne(3));

	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	return mongoTemplate.count(new Query(criteria), Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 검색한 코드의 갯수를 셈.
 * @param tags
 * @param search
 * @param writer
 * @param sort
 * @return
 */
public long countCodes(
		Weaver writer,
		List<String> tags,
		String search,
		String sort) {
	Criteria criteria = new Criteria();
	
	if(search != null && search.length()>0)
		criteria.orOperator(new Criteria("name").regex(search),
				new Criteria("content").regex(search),
				new Criteria("readme").regex(search));
	
	if(tags != null)
		criteria.and("tags").all(tags);
	
	if(writer != null)
		criteria.and("writer").is(writer);
		
	this.filter(criteria, sort);

	return mongoTemplate.count(new Query(criteria), Code.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 관리자가 글을 불러올 때
 * @param tags
 * @param search
 * @param writer
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Post> getPostsAsAdmin(List<String> tags, String search, Weaver writer, String sort,
		int page, int size) {
	Criteria criteria = new Criteria();

	if (search != null)
		criteria.orOperator(new Criteria("title").regex(search),
				new Criteria("content").regex(search));

	if (tags != null)
		criteria.and("tags").all(tags);
	if (writer != null)
		criteria.and("writer").is(writer);

	this.filter(criteria, sort);

	Query query = new Query(criteria);

	query.with(new PageRequest(page - 1, size));
	this.sorting(query, sort);

	return mongoTemplate.find(query, Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/**  로그인하지 않은 회원이 글을 검색
 * @param tags
 * @param search
 * @param writer
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Post> getPostsWhenNotLogin(List<String> tags, String search, Weaver writer, String sort,
		int page, int size) {
	Criteria criteria = new Criteria();

	if (search != null)
		criteria.orOperator(new Criteria("title").regex(search),
				new Criteria("content").regex(search));

	criteria.and("kind").is(1);

	if (tags != null)
		criteria.and("tags").all(tags);
	if (writer != null)
		criteria.and("writer").is(writer);

	this.filter(criteria, sort);

	Query query = new Query(criteria);
	query.with(new PageRequest(page - 1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 로그인한 회원이 다른 사용자의 글을 검색할때 숫자를 셈.
 * @param publicTags
 * @param loginWeaverprivateAndMassageTags
 * @param writer
 * @param loginWeaver
 * @param search
 * @param sort
 * @return
 */
public long countPostsAsWriter(
		List<String> publicTags, List<String> loginWeaverprivateAndMassageTags,
		Weaver writer, Weaver loginWeaver, String search, String sort) {
	Criteria criteria = new Criteria();

	criteria.orOperator(
			Criteria.where("kind").is(1).and("writer").is(writer),
			Criteria.where("tags").in(loginWeaverprivateAndMassageTags)
			.and("writer").is(writer));

	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	return mongoTemplate.count(new Query(criteria), Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 자기글과 자기한테 온 메세지를 검색함.(자기가 보낸 쪽지는 제외)
 * @param publicTags
 * @param privateAndMassageTags
 * @param writer
 * @param search
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Post> getMyPosts(List<String> publicTags,List<String> privateAndMassageTags,  Weaver writer, String search,
		String sort, int page, int size) {
	Criteria criteria = new Criteria();

	if(privateAndMassageTags != null)
		criteria.orOperator(Criteria.where("writer").is(writer).and("kind").ne(3),
				Criteria.where("tags").in(privateAndMassageTags));
	else
		criteria.orOperator(Criteria.where("writer").is(writer).and("kind").ne(3));
	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	Query query = new Query(criteria);
	query.with(new PageRequest(page - 1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 저장소를 검색하고 수를 셈.
 * @param tags
 * @param search
 * @param creator
 * @param sort
 * @return
 */
public long countRepositories(
		List<String> tags,
		String search,
		String sort) {
	Criteria criteria = new Criteria();
	
	if(search != null && search.length()>0)
		criteria.orOperator(new Criteria("name").regex(search),
				new Criteria("description").regex(search));
	
	if(tags != null)
		criteria.and("tags").all(tags);
		
	this.filter(criteria, sort);

	return mongoTemplate.count(new Query(criteria), Repository.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 저장소를 검색
 * @param tags
 * @param search
 * @param creator
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Repository> getRepositories( 
		List<String> tags,
		String search,
		String sort,
		int page, 
		int size) {
	Criteria criteria = new Criteria();
	
	if(search != null && search.length()>0)
		criteria.orOperator(new Criteria("name").regex(search),
				new Criteria("description").regex(search));
	
	if(tags != null)
		criteria.and("tags").all(tags);
	
	this.filter(criteria, sort);
	
	Query query = new Query(criteria);
	query.with(new PageRequest(page-1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Repository.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/**
 *
 * @Description: 查询所有存活的title
 * @param
 * @return  List<PageData>
 * @throws Exception
 * @Data: 2017/3/30 下午4:47
 *
 */
private List<PageData> loopTitle(PageData pd){
	BasicDBObject fieldsObject=new BasicDBObject();
	//指定返回的字段
	fieldsObject.put("TITLE_ID", true);
	fieldsObject.put("USER_ID", true);
	fieldsObject.put("USER_NAME", true);
	fieldsObject.put("USER_PHOTO", true);
	fieldsObject.put("CREATE_TIME", true);
	fieldsObject.put("_id", false);

	Criteria criteria = new Criteria();
	criteria.orOperator(Criteria.where("HANDLER_ID").is(pd.getString("HANDLER_ID")),Criteria.where("STATUS").is("1"));
	Query query = new Query(criteria);
	List<PageData> allTitle=mongoTemplate.find(query,PageData.class,"IM_TITLE");
	return allTitle;
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 코드를 검색함.
 * @param tags
 * @param search
 * @param writer
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Code> getCodes(
		List<String> tags,
		String search,
		Weaver writer,
		String sort,
		int page, 
		int size) {
	Criteria criteria = new Criteria();
	
	if(search != null && search.length()>0)
		criteria.orOperator(new Criteria("name").regex(search),
				new Criteria("content").regex(search),
				new Criteria("readme").regex(search));
	
	if(tags != null)
		criteria.and("tags").all(tags);
	if(writer != null)
		criteria.and("writer").is(writer);
	
	this.filter(criteria, sort);
	
	Query query = new Query(criteria);
	query.with(new PageRequest(page-1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Code.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 로그인한 회원이 글을 검색할때 숫자를 셈.
 * @param publicTags
 * @param privateAndMassageTags
 * @param writer
 * @param search
 * @param sort
 * @return
 */
public long countPostsWhenLogin(List<String> publicTags, List<String> privateAndMassageTags,
		Weaver writer, String search, String sort) {
	Criteria criteria = new Criteria();


	if(privateAndMassageTags != null)
		criteria.orOperator(Criteria.where("kind").is(1),
				Criteria.where("writer").is(writer),
				Criteria.where("tags").in(privateAndMassageTags));

	else
		criteria.orOperator(Criteria.where("kind").is(1),
				Criteria.where("writer").is(writer));

	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	return mongoTemplate.count(new Query(criteria), Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 로그인한 회원이 글을 검색함.
 * @param publicTags
 * @param privateAndMassageTags
 * @param writer
 * @param search
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Post> getPostsWhenLogin(
		List<String> publicTags, List<String> privateAndMassageTags,
		Weaver writer, String search, String sort, int page, int size) {

	Criteria criteria = new Criteria();

	if(privateAndMassageTags != null)
		criteria.orOperator(Criteria.where("kind").is(1),
				Criteria.where("writer").is(writer),
				Criteria.where("tags").in(privateAndMassageTags));
	else
		criteria.orOperator(Criteria.where("kind").is(1),
				Criteria.where("writer").is(writer));

	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	Query query = new Query(criteria);

	query.with(new PageRequest(page - 1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/** 로그인한 회원이 다른 사용자의 글을 검색함.
 * @param publicTags
 * @param loginWeaverprivateAndMassageTags
 * @param writer
 * @param loginWeaver
 * @param search
 * @param sort
 * @param page
 * @param size
 * @return
 */
public List<Post> getPostsAsWriter(
		List<String> publicTags, List<String> loginWeaverprivateAndMassageTags,
		Weaver writer, Weaver loginWeaver, String search, String sort,
		int page, int size) {
	Criteria criteria = new Criteria();
	criteria.orOperator(
			Criteria.where("kind").is(1).and("writer").is(writer), //다른 사용자의 일반글.
			Criteria.where("tags").in(loginWeaverprivateAndMassageTags) //로그인한 회원의 태그를 기반으로 다른 사용자의 글을 검색.
			.and("writer").is(writer));

	if (search != null)
		criteria.andOperator(new Criteria().orOperator(
				Criteria.where("title").regex(search),
				Criteria.where("content").regex(search)));

	if (publicTags != null)
		criteria.and("tags").all(publicTags);

	this.filter(criteria, sort);

	Query query = new Query(criteria);
	query.with(new PageRequest(page - 1, size));

	this.sorting(query, sort);
	return mongoTemplate.find(query, Post.class);
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/**
 *
 * @Description:关闭回话
 * @param pd
 * @return
 * @return PageData
 * @throws
 */
@RequestMapping(value = "/closeTitle")
public PageData closeTitle(@RequestBody PageData pd){
	String titleId=pd.getString("TITLE_ID");
	if(StringUtils.isNotBlank(titleId)){
		Criteria criteria = new Criteria();
		criteria.orOperator(Criteria.where("TITLE_ID").is(pd.get("TITLE_ID")));
		mongoTemplate.updateFirst(new Query(criteria), Update.update("STATUS","0"),"IM_TITLE");
		redisTemplate.delete(String.join("_",customerCounter,titleId));
		return WebResult.requestSuccess();
	}else{
		return WebResult.requestFailed(504,"参数不正确",null);
	}
}
 

import org.springframework.data.mongodb.core.query.Criteria; //导入方法依赖的package包/类
/**
 *
 * @Description: 客服人员下线
 * @param pd----->USER_ID
 * @return
 * @return PageData
 * @throws
 */
@RequestMapping(value = "/customerOffline")
public PageData customerOffline(@RequestBody PageData pd){
	String handlerId=pd.getString("HANDLER_ID");
	if(StringUtils.isNotBlank(handlerId)){
		Criteria criteria = new Criteria();
		criteria.orOperator(Criteria.where("_id").is(handlerId));
		mongoTemplate.remove(new Query(criteria),"IM_INCUSTOMER");
		redisTemplate.delete(String.join("_",customerCounter,"HANDLER",handlerId));
		return WebResult.requestSuccess();
	}else{
		return WebResult.requestFailed(504,"参数不正确",null);
	}
}