/**
* @param Keyword
* @return Sorting relevancy - Answers Count - Last Replied Date - Rating - Logged In User
* Participated - Logged In User Connection Discussions - Logged In User Connections of
* connections Discussions
*/
@RequestMapping(value = "/findquestion")
public ModelAndView findQuestions(
HttpServletRequest request, @RequestParam(value = "query", required = false) String Keyword) {
ModelAndView mav = new ModelAndView();
List<DiscussionQuestion> questions = new ArrayList<DiscussionQuestion>();
String queryText =
"(QuestionText:" + Keyword.toLowerCase() + "*) OR (Tags:" + Keyword.toLowerCase() + "*)";
Object[] resultArrDiscussion = null;
long numFoundDiscussion = 0;
// resultArrDiscussion = this.fetchDiscussionData(queryText,0,10);
resultArrDiscussion = discussionQuestionClient.fetchDiscussionData(queryText, 0, 10, request);
numFoundDiscussion = Integer.parseInt(resultArrDiscussion[1].toString());
questions = (List<DiscussionQuestion>) resultArrDiscussion[0];
List<DiscussionQuestion> fullQuestions = new ArrayList<DiscussionQuestion>();
for (DiscussionQuestion question : questions) {
if (question.getQuestionText().toLowerCase().contains(Keyword.toLowerCase()))
fullQuestions.add(question);
}
// Collections.sort(questions);
mav.addObject("TotalRecords", fullQuestions.size());
mav.addObject("StatusOutput", "0");
mav.addObject("Collection", fullQuestions);
return mav;
}
@RequestMapping(value = "/findmainautocomplete")
public @ResponseBody AutoCompleteResponse findQuestionsMainAutoComplete(
HttpServletRequest request,
@RequestParam(value = "ProfileId", required = false) String ProfileId,
@RequestParam(value = "query", required = false) String Keyword) {
ModelAndView mav = new ModelAndView();
String friendListResult2 = null;
String folderListResult2 = null;
String blockListResult2 = null;
String canSendMessagesResult2 = null;
String friendListResult = null;
String folderListResult = null;
String blockListResult = null;
String canSendMessagesResult = null;
try {
friendListResult2 =
mamCacheClient.mamCachefriendList(
ServerurlConstants.MEMCACHE_URL,
ServerurlConstants.MEMCACHE_PORT,
ProfileId,
request);
if (friendListResult2 != null) friendListResult = friendListResult2.replace(",", " , ");
folderListResult2 =
mamCacheClient.mamCachefolderList(
ServerurlConstants.MEMCACHE_URL,
ServerurlConstants.MEMCACHE_PORT,
ProfileId,
request);
if (folderListResult2 != null) folderListResult = folderListResult2.replace(",", " , ");
blockListResult2 =
mamCacheClient.mamCacheblockList(
ServerurlConstants.MEMCACHE_URL,
ServerurlConstants.MEMCACHE_PORT,
ProfileId,
request);
if (blockListResult2 != null) blockListResult = blockListResult2.replace(",", " , ");
canSendMessagesResult2 =
mamCacheClient.mamCachecanSendMessages(
ServerurlConstants.MEMCACHE_URL,
ServerurlConstants.MEMCACHE_PORT,
ProfileId,
request);
if (canSendMessagesResult2 != null)
canSendMessagesResult = canSendMessagesResult2.replace(",", " , ");
} catch (Exception e) {
e.printStackTrace();
}
if (friendListResult.equals("") || friendListResult == null) friendListResult = "1000000000";
List<DiscussionQuestion> questions = new ArrayList<DiscussionQuestion>();
Object[] resultArrDiscussion = null;
String queryText = null;
long numFoundDiscussion = 0;
// ********** Older query ************/
// queryText = "(QuestionText:"+Keyword.toLowerCase()+"*) OR (Tags:"+Keyword.toLowerCase()+"*)";
if ((Keyword != "" || Keyword != null)
&& ProfileId != "0"
&& (blockListResult != null && blockListResult != "" && blockListResult != "0")
&& (folderListResult != null && folderListResult != "")) {
// if((SubCategoryName!="" || SubCategoryName!=null )& ProfileId!="0" ){
queryText =
"(((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*)) AND -CreatedUserID:"
+ ProfileId
+ " AND (Everyone:1 OR((CreatedUserID:"
+ friendListResult
+ ") AND (ContactsShowList:0) AND (FoldersShowList:"
+ folderListResult
+ " OR FoldersShowList:0))) NOT ((Onlyme:1) OR (ContactsHideList:"
+ ProfileId
+ ") OR (FoldersHideList:"
+ folderListResult
+ "))) OR ((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*) AND CreatedUserID:"
+ ProfileId
+ ") OR ((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*) AND CreatedUserID:"
+ friendListResult
+ " AND ContactsShowList:"
+ ProfileId
+ ") -CreatedUserID:"
+ blockListResult
+ " ";
} else if ((Keyword != "" || Keyword != null) && ProfileId != "0") {
queryText =
"(((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*)) AND -CreatedUserID:"
+ ProfileId
+ " AND (Everyone:1 OR((CreatedUserID:"
+ friendListResult
+ ") AND (ContactsShowList:0) AND (FoldersShowList:0))) NOT ((Onlyme:1) OR (ContactsHideList:"
+ ProfileId
+ "))) OR ((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*) AND CreatedUserID:"
+ ProfileId
+ ") OR ((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*) AND ContactsShowList:"
+ ProfileId
+ ")";
} else {
queryText =
"(((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*)) AND Everyone:1)";
}
if (ProfileId.equals("0")) {
queryText =
"((QuestionText:"
+ Keyword.toLowerCase()
+ "*) OR (Tags:"
+ Keyword.toLowerCase()
+ "*) AND Everyone:1)";
}
System.out.println("Query-->" + queryText);
resultArrDiscussion = this.fetchDiscussionData(queryText, 0, 10);
numFoundDiscussion = Integer.parseInt(resultArrDiscussion[1].toString());
questions = (List<DiscussionQuestion>) resultArrDiscussion[0];
List data = new ArrayList();
List suggestions = new ArrayList();
for (DiscussionQuestion question : questions) {
data.add(question.getID());
suggestions.add(question.getQuestionText());
}
AutoCompleteResponse autoComplete = new AutoCompleteResponse();
autoComplete.setQuery(Keyword);
autoComplete.setData(data);
autoComplete.setSuggestions(suggestions);
// mav.addObject(autoComplete);
return autoComplete;
}