SearchController.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412
  1. package com.uas.search.controller;
  2. import com.alibaba.druid.util.StringUtils;
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.uas.search.constant.model.CollectField;
  6. import com.uas.search.constant.model.PageParams;
  7. import com.uas.search.constant.model.PageParams.FilterField;
  8. import com.uas.search.constant.model.SPage;
  9. import com.uas.search.constant.model.Sort;
  10. import com.uas.search.constant.model.Sort.Field;
  11. import com.uas.search.dao.ComponentDao;
  12. import com.uas.search.exception.SearchException;
  13. import com.uas.search.model.Brand;
  14. import com.uas.search.model.Component;
  15. import com.uas.search.model.Goods;
  16. import com.uas.search.model.Kind;
  17. import com.uas.search.service.SearchService;
  18. import com.uas.search.service.impl.IndexServiceImpl;
  19. import com.uas.search.util.FileUtils;
  20. import com.uas.search.util.SearchUtils;
  21. import org.slf4j.Logger;
  22. import org.slf4j.LoggerFactory;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.stereotype.Controller;
  25. import org.springframework.util.CollectionUtils;
  26. import org.springframework.web.bind.annotation.PathVariable;
  27. import org.springframework.web.bind.annotation.RequestMapping;
  28. import org.springframework.web.bind.annotation.RequestParam;
  29. import org.springframework.web.bind.annotation.ResponseBody;
  30. import javax.servlet.http.HttpServletRequest;
  31. import java.io.File;
  32. import java.io.FileNotFoundException;
  33. import java.io.PrintWriter;
  34. import java.util.*;
  35. import java.util.Map.Entry;
  36. /**
  37. * 搜索请求
  38. *
  39. * @author suntg
  40. * @since 2016年8月1日上午9:18:05
  41. */
  42. @Controller
  43. @RequestMapping("/search")
  44. public class SearchController {
  45. @Autowired
  46. private SearchService searchService;
  47. private Logger logger = LoggerFactory.getLogger(getClass());
  48. @RequestMapping("/kindIds/{keyword}")
  49. @ResponseBody
  50. public SPage<Long> seachKindIds(@PathVariable String keyword, Integer page, Integer size,
  51. HttpServletRequest request) {
  52. return searchService.getKindIds(keyword, page, size);
  53. }
  54. @RequestMapping("/kinds/{keyword}")
  55. @ResponseBody
  56. public SPage<Map<String, Object>> seachKinds(@PathVariable String keyword, Integer page, Integer size,
  57. HttpServletRequest request) {
  58. return searchService.getKinds(keyword, page, size);
  59. }
  60. @RequestMapping("/brandIds/{keyword}")
  61. @ResponseBody
  62. public SPage<Long> searchBrandIds(@PathVariable String keyword, Integer page, Integer size,
  63. HttpServletRequest request) {
  64. return searchService.getBrandIds(keyword, page, size);
  65. }
  66. @RequestMapping("/brands/{keyword}")
  67. @ResponseBody
  68. public SPage<Map<String, Object>> searchBrand(@PathVariable String keyword, Integer page, Integer size,
  69. HttpServletRequest request) {
  70. return searchService.getBrands(keyword, page, size);
  71. }
  72. @RequestMapping("/componentIds/old")
  73. @ResponseBody
  74. public Map<String, Object> searchComponentIds(String keyword, Integer page, Integer size, String filters,
  75. HttpServletRequest request) {
  76. PageParams pageParams = new PageParams();
  77. if (page != null) {
  78. pageParams.setPage(page);
  79. }
  80. if (size != null) {
  81. pageParams.setSize(size);
  82. }
  83. Map<FilterField, Object> filtersMap = new HashMap<>();
  84. if (!StringUtils.isEmpty(filters)) {
  85. JSONObject json = JSONObject.parseObject(filters);
  86. Set<Entry<String, Object>> entrySet = json.entrySet();
  87. for (Entry<String, Object> entry : entrySet) {
  88. FilterField field = FilterField.valueOf(entry.getKey().toUpperCase());
  89. filtersMap.put(field, entry.getValue());
  90. }
  91. }
  92. pageParams.setFilters(filtersMap);
  93. return searchService.getComponentIds(keyword, pageParams);
  94. }
  95. @RequestMapping("/componentIds")
  96. @ResponseBody
  97. public Map<String, Object> searchComponentIds(String keyword, String params, HttpServletRequest request) {
  98. PageParams pageParams = params==null?null:JSONObject.parseObject(params, PageParams.class);
  99. return searchService.getComponentIds(keyword, pageParams);
  100. }
  101. @Autowired
  102. private ComponentDao componentDao;
  103. @RequestMapping("/components/old")
  104. @ResponseBody
  105. public List<Component> searchComponents(String keyword, Integer page, Integer size, String filters,
  106. HttpServletRequest request) {
  107. @SuppressWarnings("unchecked")
  108. List<Long> ids = (List<Long>) searchComponentIds(keyword, page, size, filters, request).get("componentIds");
  109. return findComponents(ids);
  110. }
  111. @RequestMapping("/components")
  112. @ResponseBody
  113. public List<Component> searchComponents(String keyword, String params, HttpServletRequest request) {
  114. @SuppressWarnings("unchecked")
  115. List<Long> ids = (List<Long>) searchComponentIds(keyword, params, request).get("componentIds");
  116. return findComponents(ids);
  117. }
  118. private List<Component> findComponents(List<Long> ids){
  119. if (CollectionUtils.isEmpty(ids)) {
  120. return new ArrayList<Component>();
  121. }
  122. Long[] idsLong = new Long[ids.size()];
  123. int i = 0;
  124. for (Long id : ids) {
  125. idsLong[i++] = id;
  126. }
  127. return componentDao.findAll(ids);
  128. }
  129. @RequestMapping("/kindIdsByComponent")
  130. @ResponseBody
  131. public Set<Long> searchKindIdsBySearchComponent(String keyword, String brandId, HttpServletRequest request) {
  132. return searchService.getKindIdsBySearchComponent(keyword, brandId);
  133. }
  134. @RequestMapping("/kindsByComponent")
  135. @ResponseBody
  136. public Set<Map<String, Object>> searchKindsBySearchComponent(String keyword, String brandId,
  137. HttpServletRequest request) {
  138. return searchService.getKindsBySearchComponent(keyword, brandId);
  139. }
  140. @RequestMapping("/brandIdsByComponent")
  141. @ResponseBody
  142. public Set<Long> searchBrandIdsBySearchComponent(String keyword, String kindId, HttpServletRequest request) {
  143. return searchService.getBrandIdsBySearchComponent(keyword, kindId);
  144. }
  145. @RequestMapping("/brandsByComponent")
  146. @ResponseBody
  147. public Set<Map<String, Object>> searchBrandsBySearchComponent(String keyword, String kindId,
  148. HttpServletRequest request) {
  149. return searchService.getBrandsBySearchComponent(keyword, kindId);
  150. }
  151. @RequestMapping("/similarKeywords/{keyword}")
  152. @ResponseBody
  153. public List<String> getSimilarKeywords(@PathVariable String keyword, Integer size, HttpServletRequest request) {
  154. return searchService.getSimilarKeywords(keyword, size);
  155. }
  156. @RequestMapping("/similarComponents/{componentCode}")
  157. @ResponseBody
  158. public List<Map<String, Object>> getSimilarComponents(@PathVariable String componentCode, Integer size,
  159. HttpServletRequest request) {
  160. return searchService.getSimilarComponents(componentCode, size);
  161. }
  162. @RequestMapping("/similarBrands/{brandName}")
  163. @ResponseBody
  164. public List<Map<String, Object>> getSimilarBrands(@PathVariable String brandName, Integer size, HttpServletRequest request) {
  165. return searchService.getSimilarBrands(brandName, size);
  166. }
  167. @RequestMapping("/similarKinds/{kindName}")
  168. @ResponseBody
  169. public List<Map<String, Object>> getSimilarKinds(@PathVariable String kindName, Integer size, HttpServletRequest request) {
  170. return searchService.getSimilarKinds(kindName, size);
  171. }
  172. @RequestMapping("/similarLeafKinds/{kindName}")
  173. @ResponseBody
  174. public List<Map<String, Object>> getSimilarLeafKinds(@PathVariable String kindName, Integer size, HttpServletRequest request) {
  175. return searchService.getSimilarLeafKinds(kindName, size);
  176. }
  177. @RequestMapping("/similarKindsByLevel")
  178. @ResponseBody
  179. public List<Map<String, Object>> getSimilarKindsByLevel(String kindName, Short level, Integer size, HttpServletRequest request) {
  180. return searchService.getSimilarKindsByLevel(kindName, level, size);
  181. }
  182. @RequestMapping("/similarPropertyValues")
  183. @ResponseBody
  184. public List<Map<String, String>> getSimilarPropertyValues(Long kindId, Long propertyId, String keyword, Long topNum,
  185. HttpServletRequest request) {
  186. return searchService.getSimilarPropertyValues(kindId, propertyId, keyword, topNum);
  187. }
  188. @RequestMapping("/goodsIds/old")
  189. @ResponseBody
  190. public Map<String, Object> getGoodsIds(String keyword, Integer page, Integer size, String filters, String sort,
  191. HttpServletRequest request) {
  192. PageParams pageParams = new PageParams();
  193. if (page != null) {
  194. pageParams.setPage(page);
  195. }
  196. if (size != null) {
  197. pageParams.setSize(size);
  198. }
  199. Map<FilterField, Object> filtersMap = new HashMap<>();
  200. if (!StringUtils.isEmpty(filters)) {
  201. filtersMap=parseFilters(JSONObject.parseObject(filters));
  202. }
  203. pageParams.setFilters(filtersMap);
  204. if (!StringUtils.isEmpty(sort)) {
  205. JSONArray jsonArray = JSONObject.parseArray(sort);
  206. List<Sort> sorts = new ArrayList<>();
  207. for (Object object : jsonArray) {
  208. if (object instanceof JSONObject) {
  209. JSONObject jsonObject = (JSONObject) object;
  210. Field field = Field.valueOf(jsonObject.getString("field"));
  211. boolean reverse = jsonObject.getBooleanValue("reverse");
  212. sorts.add(new Sort(field, reverse));
  213. } else {
  214. throw new IllegalArgumentException("排序参数并非json格式");
  215. }
  216. }
  217. pageParams.setSort(sorts);
  218. }
  219. System.out.println(JSONObject.toJSONString(pageParams));
  220. System.out.println(pageParams);
  221. String json="{\"filters\":{\"GOODS_MINPRICEUSD\":\"0\",\"GOODS_KINDID\":[\"401\",\"23\"],\"GOODS_MAXPRICERMB\":\"10\",\"GOODS_BRANDID\":[\"45\"],\"GOODS_MAXPRICEUSD\":\"10\",\"GOODS_STORE_TYPE\":[\"DISTRIBUTION\"],\"GOODS_MINPRICERMB\":\"0\",\"GOODS_CRNAME\":[\"RMB-USD\"]},\"page\":1,\"size\":8,\"sort\":[{\"field\":\"GO_RESERVE\",\"reverse\":true},{\"field\":\"GO_MINPRICERMB\",\"reverse\":true},{\"field\":\"GO_MINPRICEUSD\",\"reverse\":true},{\"field\":\"GO_SEARCH\",\"reverse\":false}]}";
  222. PageParams params = JSONObject.parseObject(json, PageParams.class);
  223. System.out.println(params);
  224. return searchService.getGoodsIds(keyword, pageParams);
  225. }
  226. public Map<FilterField, Object> parseFilters(JSONObject json){
  227. Map<FilterField, Object> filters = new HashMap<>();
  228. if(json!=null){
  229. Set<Entry<String, Object>> entrySet = json.entrySet();
  230. for (Entry<String, Object> entry : entrySet) {
  231. FilterField field = FilterField.valueOf(entry.getKey());
  232. String value = entry.getValue().toString();
  233. switch (field) {
  234. case GOODS_KINDID:
  235. case GOODS_BRANDID:
  236. case GOODS_STORE_TYPE:
  237. case GOODS_CRNAME:
  238. String[] strs = value.split(",");
  239. List<Object> values = new ArrayList<>();
  240. for (String str : strs) {
  241. values.add(str);
  242. }
  243. filters.put(field, values);
  244. break;
  245. default:
  246. filters.put(field, value);
  247. }
  248. }
  249. }
  250. return filters;
  251. }
  252. @RequestMapping("/goodsIds")
  253. @ResponseBody
  254. public Map<String, Object> getGoodsIds(String keyword, String params, HttpServletRequest request) {
  255. PageParams pageParams = params==null?null:JSONObject.parseObject(params, PageParams.class);
  256. return searchService.getGoodsIds(keyword, pageParams);
  257. }
  258. @RequestMapping("/collectBySearchGoods/old")
  259. @ResponseBody
  260. public List<Map<String, Object>> collectBySearchGoodsOld(String keyword, String collectedField, String filters,
  261. HttpServletRequest request) {
  262. Map<FilterField, Object> filtersMap = new HashMap<>();
  263. if (!StringUtils.isEmpty(filters)) {
  264. filtersMap=parseFilters(JSONObject.parseObject(filters));
  265. }
  266. return searchService.collectBySearchGoods(keyword, CollectField.valueOf(collectedField.toUpperCase()),
  267. filtersMap);
  268. }
  269. @RequestMapping("/collectBySearchGoods")
  270. @ResponseBody
  271. public List<Map<String, Object>> collectBySearchGoods(String keyword, String collectedField, String filters, HttpServletRequest request) {
  272. Map<FilterField, Object> filtersMap = new HashMap<>();
  273. if(!StringUtils.isEmpty(filters)){
  274. JSONObject json = JSONObject.parseObject(filters);
  275. Set<Entry<String, Object>> entrySet = json.entrySet();
  276. for (Entry<String, Object> entry : entrySet) {
  277. FilterField field = FilterField.valueOf(entry.getKey());
  278. switch (field) {
  279. case GOODS_KINDID:
  280. case GOODS_BRANDID:
  281. case GOODS_STORE_TYPE:
  282. case GOODS_CRNAME:
  283. filtersMap.put(field, entry.getValue());
  284. break;
  285. }
  286. }
  287. }
  288. return searchService.collectBySearchGoods(keyword, CollectField.valueOf(collectedField.toUpperCase()),
  289. filtersMap);
  290. }
  291. @RequestMapping("/kind/{id}")
  292. @ResponseBody
  293. public Kind getKind(@PathVariable Long id, HttpServletRequest request) {
  294. return searchService.getKind(id);
  295. }
  296. @RequestMapping("/brand/{id}")
  297. @ResponseBody
  298. public Brand getBrand(@PathVariable Long id, HttpServletRequest request) {
  299. return searchService.getBrand(id);
  300. }
  301. @RequestMapping("/component/{id}")
  302. @ResponseBody
  303. public Component getComponent(@PathVariable Long id, HttpServletRequest request) {
  304. return searchService.getComponent(id);
  305. }
  306. @RequestMapping("/goods/{id}")
  307. @ResponseBody
  308. public Goods getGoods(@PathVariable String id, HttpServletRequest request) {
  309. return searchService.getGoods(id);
  310. }
  311. @RequestMapping("/objects")
  312. @ResponseBody
  313. public SPage<Object> getObjects(@RequestParam(required = true) String tableName, String keyword, String field,
  314. Boolean tokenized, Integer page, Integer size, HttpServletRequest request) {
  315. return searchService.getObjects(tableName.toLowerCase(), keyword, field, tokenized, page == null ? 0 : page,
  316. size == null ? 0 : size);
  317. }
  318. @RequestMapping("/allObjectsToFiles")
  319. @ResponseBody
  320. public String writeAllObjectsToFiles(@RequestParam(required = true) String tableName, HttpServletRequest request) {
  321. int page = 1;
  322. int size = 1000;
  323. // 不能边更新索引边分页获取索引中的数据,因为索引更新后,分页顺序可能也会变化,
  324. // 所以要先把数据保存到本地,等待全部获取之后重建索引
  325. Long startTime = new Date().getTime();
  326. // 先删除旧的文件
  327. FileUtils.deleteSubFiles(new File(SearchUtils.getDataPath(tableName)));
  328. SPage<Object> sPage = searchService.getObjects(tableName.toLowerCase(), null, null, null, page, size);
  329. // 索引中数据的总数目
  330. long totalElements = sPage.getTotalElement();
  331. logger.info("发现数据:" + totalElements + "条");
  332. int fileIndex = 1;
  333. PrintWriter printWriter = null;
  334. int count = 0;
  335. try {
  336. File file = new File(SearchUtils.getDataPath(tableName));
  337. if (!file.exists()) {
  338. file.mkdirs();
  339. }
  340. printWriter = new PrintWriter(SearchUtils.getDataPath(tableName) + "/" + fileIndex + ".txt");
  341. while (true) {
  342. // 一个文件存放100000条数据,一旦超过,写入新的文件
  343. if (count > IndexServiceImpl.SINGLE_FILE_MAX_SIZE) {
  344. count = 1;
  345. printWriter.flush();
  346. printWriter.close();
  347. fileIndex++;
  348. printWriter = new PrintWriter(SearchUtils.getDataPath(tableName) + "/" + fileIndex + ".txt");
  349. }
  350. List<Object> content = sPage.getContent();
  351. for (Object element : content) {
  352. printWriter.println(JSONObject.toJSONString(element));
  353. count++;
  354. }
  355. logger.info(String.format(tableName + "...................%.2f%%",
  356. ((page - 1) * size + content.size()) * 100.0 / totalElements));
  357. if (++page > sPage.getTotalPage()) {
  358. break;
  359. }
  360. sPage = searchService.getObjects(tableName.toLowerCase(), null, null, null, page, size);
  361. }
  362. printWriter.flush();
  363. printWriter.close();
  364. } catch (FileNotFoundException | SecurityException | IllegalArgumentException e) {
  365. throw new SearchException(e).setDetailedMessage(e);
  366. }
  367. Long endTime = new Date().getTime();
  368. String message = String.format("写入数据%s条,耗时%.2fs\n ", totalElements, (endTime - startTime) / 1000.0);
  369. logger.info(message);
  370. return message;
  371. }
  372. }