StoreServiceImpl.java 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745
  1. package com.dderp.business.service;
  2. import com.dderp.business.dao.StoreDao;
  3. import com.dderp.common.api.NoSqlKeysService;
  4. import com.dderp.common.api.PlatformService;
  5. import com.dderp.common.api.SortBuilderExecutor;
  6. import com.dderp.common.api.StoreService;
  7. import com.dderp.common.base.BaseService;
  8. import com.dderp.common.datas.ESKeys;
  9. import com.dderp.common.datas.business.PlatformType;
  10. import com.dderp.common.entity.platform.PlatformInfo;
  11. import com.dderp.common.entity.site.ERPTokenUser;
  12. import com.dderp.common.entity.store.*;
  13. import com.dderp.common.tool.ERPUtils;
  14. import com.dySweetFishPlugin.elasticsearch.ESClient;
  15. import com.dySweetFishPlugin.sql.RMapUtils;
  16. import com.dySweetFishPlugin.sql.TableIdService;
  17. import com.dySweetFishPlugin.sql.dao.TunaService;
  18. import com.sweetfish.convert.json.JsonConvert;
  19. import com.sweetfish.service.Local;
  20. import com.sweetfish.service.RetResult;
  21. import com.sweetfish.source.PageFlipper;
  22. import com.sweetfish.util.AnyValue;
  23. import com.sweetfish.util.AutoLoad;
  24. import com.sweetfish.util.ResourceType;
  25. import org.apache.commons.lang3.StringUtils;
  26. import org.apache.lucene.search.join.ScoreMode;
  27. import org.elasticsearch.action.DocWriteResponse;
  28. import org.elasticsearch.action.bulk.BulkRequestBuilder;
  29. import org.elasticsearch.action.bulk.BulkResponse;
  30. import org.elasticsearch.action.index.IndexRequestBuilder;
  31. import org.elasticsearch.action.index.IndexResponse;
  32. import org.elasticsearch.action.support.WriteRequest;
  33. import org.elasticsearch.action.update.UpdateRequest;
  34. import org.elasticsearch.common.xcontent.XContentType;
  35. import org.elasticsearch.index.query.BoolQueryBuilder;
  36. import org.elasticsearch.index.query.Operator;
  37. import org.elasticsearch.index.query.QueryBuilders;
  38. import org.elasticsearch.index.reindex.DeleteByQueryAction;
  39. import org.elasticsearch.join.query.JoinQueryBuilders;
  40. import org.elasticsearch.search.sort.SortBuilders;
  41. import org.elasticsearch.search.sort.SortOrder;
  42. import org.rex.RMap;
  43. import javax.annotation.Resource;
  44. import java.io.IOException;
  45. import java.math.BigDecimal;
  46. import java.util.*;
  47. import java.util.concurrent.ExecutionException;
  48. import java.util.stream.Collectors;
  49. import static org.elasticsearch.common.xcontent.XContentFactory.jsonBuilder;
  50. @AutoLoad(value = false)
  51. @Local
  52. @ResourceType(StoreService.class)
  53. public class StoreServiceImpl extends BaseService implements StoreService {
  54. @Resource
  55. private ESClient esClient;
  56. @Resource
  57. private JsonConvert jsonConvert;
  58. @Resource
  59. private NoSqlKeysService keysService;
  60. @Resource
  61. private TableIdService tableIdService;
  62. @Resource
  63. private TunaService tunaService;
  64. private StoreDao storeDao;
  65. @Override
  66. public void start(AnyValue config) {
  67. super.start(config);
  68. storeDao = tunaService.generate(StoreDao.class);
  69. }
  70. //region 门店品牌档案
  71. @Override
  72. public List<StoreBrand> queryStoreBrandList(RMap params, PageFlipper pageFlipper, long supplierCode) {
  73. return searchESList(esClient, jsonConvert,
  74. StoreBrand.class,
  75. null,
  76. ((sd) -> {
  77. BoolQueryBuilder qb = QueryBuilders.boolQuery();
  78. qb = qb.must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_BRAND_INDEX));
  79. if (ERPUtils.mapContainKey(params, "brandName")) {
  80. String platformName = params.getString("brandName");
  81. BoolQueryBuilder qbPlatformName = QueryBuilders.boolQuery()
  82. .should(QueryBuilders.matchQuery("brandName", platformName).analyzer("query_ansj").operator(Operator.AND))
  83. .should(QueryBuilders.termQuery("brandName.number", platformName.toLowerCase()))
  84. .should(QueryBuilders.matchQuery("brandName.letter", platformName.toLowerCase()).operator(Operator.AND));
  85. qb = qb.must(qbPlatformName);
  86. }
  87. if (ERPUtils.mapContainKey(params, "voidFlag")) {
  88. qb = qb.must(QueryBuilders.termQuery("voidFlag", params.getInt("voidFlag")));
  89. }
  90. return qb;
  91. }),
  92. keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_TYPE, supplierCode),
  93. (() -> SortBuilders.fieldSort("id").order(SortOrder.DESC)));
  94. }
  95. @Override
  96. public StoreBrand getStoreBrand(long id, long supplierCode) {
  97. return this.getESOneInfo(esClient, jsonConvert, StoreBrand.class,
  98. String.valueOf(id),
  99. keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  100. ESKeys.ES_DELIVER_STORE_BRAND_TYPE,
  101. null);
  102. }
  103. @Override
  104. public RetResult<StoreBrand> addStoreBrand(StoreBrand storeBrand, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  105. if (StringUtils.isBlank(storeBrand.getBrandName()))
  106. return RetResult.<StoreBrand>errorT().retinfo("门店品牌名称不可为空");
  107. //先查一下有没有重名的平台信息
  108. StoreBrand esInfo = this.getESOneInfo(esClient, jsonConvert,
  109. StoreBrand.class,
  110. (a) -> {
  111. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_BRAND_TYPE));
  112. qb.must(QueryBuilders.termQuery("brandName.raw", storeBrand.getBrandName()));
  113. return qb;
  114. },
  115. keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  116. null);
  117. if (esInfo != null) return RetResult.<StoreBrand>errorT().retinfo("已存在同名的门店品牌");
  118. storeBrand.setId(tableIdService.getTableIdMulti("tbStoreBrand.id", 1, dataSourceId, String.valueOf(supplierCode)));
  119. StoreBrand.create(storeBrand, currentUser.getId());
  120. IndexResponse itemResponse = esClient.getClient()
  121. .prepareIndex(keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode), ESKeys.ES_DELIVER_STORE_BRAND_TYPE)
  122. .setId(String.valueOf(storeBrand.getId()))
  123. .setSource(jsonConvert.convertTo(storeBrand), XContentType.JSON)
  124. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE)
  125. .get();
  126. if (itemResponse.getResult() == DocWriteResponse.Result.CREATED) {
  127. storeDao.addStoreBrand(storeBrand, dataSourceId, supplierCode);
  128. } else {
  129. return RetResult.<StoreBrand>errorT().retinfo("创建门店品牌失败");
  130. }
  131. return RetResult.<StoreBrand>successT().result(storeBrand);
  132. }
  133. @Override
  134. public RetResult<StoreBrand> uploadBrandLogo(long idStoreBrand,String fileLink, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  135. StoreBrand esInfo = this.getStoreBrand(idStoreBrand, supplierCode);
  136. if (esInfo == null)
  137. return RetResult.<StoreBrand>errorT().retinfo("未找到此门店品牌");
  138. esInfo.setBrandLogoUrl(fileLink);
  139. try {
  140. UpdateRequest updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  141. ESKeys.ES_DELIVER_STORE_BRAND_TYPE, String.valueOf(esInfo.getId()))
  142. .doc(jsonBuilder()
  143. .startObject()
  144. .field("brandLogoUrl", esInfo.getBrandLogoUrl())
  145. .endObject())
  146. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  147. esClient.getClient().update(updateRequest).get();
  148. } catch (IOException | InterruptedException | ExecutionException e) {
  149. logger.error("修改门店品牌[" + esInfo.getId() + "出错:" + e.getMessage(), e);
  150. }
  151. storeDao.updateBrandLogoUrl(esInfo, dataSourceId, supplierCode);
  152. return RetResult.successT();
  153. }
  154. @Override
  155. public RetResult<StoreBrand> updateStoreBrand(StoreBrand storeBrand, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  156. if (StringUtils.isBlank(storeBrand.getBrandName()))
  157. return RetResult.<StoreBrand>errorT().retinfo("门店品牌名称不可为空");
  158. StoreBrand esInfo = this.getStoreBrand(storeBrand.getId(), supplierCode);
  159. if (esInfo == null)
  160. return RetResult.<StoreBrand>errorT().retinfo("未找到此门店品牌");
  161. //先查一下有没有重名的平台信息(防止修改名称改重)
  162. StoreBrand checkNameInfo = this.getESOneInfo(esClient, jsonConvert,
  163. StoreBrand.class,
  164. (a) -> {
  165. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_BRAND_TYPE));
  166. qb.must(QueryBuilders.termQuery("brandName.raw", storeBrand.getBrandName()))
  167. .mustNot(QueryBuilders.idsQuery(String.valueOf(storeBrand.getId())));
  168. return qb;
  169. },
  170. keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  171. null);
  172. if (checkNameInfo != null) return RetResult.<StoreBrand>errorT().retinfo("已存在同名的门店品牌");
  173. esInfo.setBrandName(storeBrand.getBrandName());
  174. esInfo.setStartingPrice(storeBrand.getStartingPrice());
  175. esInfo.setPackagingFee(storeBrand.getPackagingFee());
  176. esInfo.setBrandMemo(storeBrand.getBrandMemo());
  177. StoreBrand.update(esInfo, currentUser.getId());
  178. try {
  179. UpdateRequest updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  180. ESKeys.ES_DELIVER_STORE_BRAND_TYPE, String.valueOf(esInfo.getId()))
  181. .doc(jsonBuilder()
  182. .startObject()
  183. .field("brandName", esInfo.getBrandName())
  184. .field("startingPrice", esInfo.getStartingPrice())
  185. .field("packagingFee", esInfo.getPackagingFee())
  186. .field("brandMemo", esInfo.getBrandMemo())
  187. .field("updateTimeLong", esInfo.getUpdateTimeLong())
  188. .field("updateBy", esInfo.getUpdateBy())
  189. .endObject())
  190. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  191. esClient.getClient().update(updateRequest).get();
  192. } catch (IOException | InterruptedException | ExecutionException e) {
  193. logger.error("修改门店品牌[" + esInfo.getId() + "出错:" + e.getMessage(), e);
  194. }
  195. storeDao.updateStoreBrand(esInfo, dataSourceId, supplierCode);
  196. return RetResult.successT();
  197. }
  198. @Override
  199. public RetResult<StoreBrand> voidStoreBrand(StoreBrand storeBrand, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  200. StoreBrand esInfo = this.getStoreBrand(storeBrand.getId(), supplierCode);
  201. if (esInfo == null) {
  202. return RetResult.<StoreBrand>errorT().retinfo("未找到此门店品牌");
  203. }
  204. esInfo.setVoidFlag(storeBrand.getVoidFlag());
  205. StoreBrand.update(esInfo, currentUser.getId());
  206. try {
  207. UpdateRequest updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_BRAND_INDEX, supplierCode),
  208. ESKeys.ES_DELIVER_STORE_BRAND_TYPE, String.valueOf(esInfo.getId()))
  209. .doc(jsonBuilder()
  210. .startObject()
  211. .field("voidFlag", esInfo.getVoidFlag())
  212. .field("updateTimeLong", esInfo.getUpdateTimeLong())
  213. .field("updateBy", esInfo.getUpdateBy())
  214. .endObject())
  215. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  216. esClient.getClient().update(updateRequest).get();
  217. } catch (IOException | InterruptedException | ExecutionException e) {
  218. logger.error("禁用或启用门店品牌[" + esInfo.getId() + "出错:" + e.getMessage(), e);
  219. }
  220. storeDao.voidStoreBrand(esInfo, dataSourceId, supplierCode);
  221. return RetResult.successT();
  222. }
  223. //endregion
  224. @Override
  225. public List<ViewStoreInfo> queryViewStoreInfo(RMap params, PageFlipper pageFlipper, long supplierCode) {
  226. Set<Long> idStores = new HashSet<>();
  227. List<StoreInfo> storeInfoList = searchESList(esClient, jsonConvert,
  228. StoreInfo.class,
  229. null,
  230. ((sd) -> {
  231. BoolQueryBuilder qb = QueryBuilders.boolQuery();
  232. qb = qb.must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_INFO_TYPE));
  233. if (ERPUtils.mapContainKey(params, "storeName")) {
  234. String storeName = params.getString("storeName");
  235. BoolQueryBuilder qbStoreName = QueryBuilders.boolQuery()
  236. .should(QueryBuilders.matchQuery("storeName", storeName).analyzer("query_ansj").operator(Operator.AND))
  237. .should(QueryBuilders.termQuery("storeName.number", storeName.toLowerCase()))
  238. .should(QueryBuilders.matchQuery("storeName.letter", storeName.toLowerCase()).operator(Operator.AND));
  239. qb = qb.must(qbStoreName);
  240. }
  241. if (ERPUtils.mapContainKey(params, "idBrand")) {
  242. qb = qb.must(QueryBuilders.termQuery("idBrand", params.getLong("idBrand")));
  243. }
  244. if (ERPUtils.mapContainKey(params, "idStoreType")) {
  245. qb = qb.must(QueryBuilders.termQuery("idStoreType", params.getLong("idStoreType")));
  246. }
  247. if (ERPUtils.mapContainKey(params, "deliverSettleKind")) {
  248. qb = qb.must(QueryBuilders.termQuery("deliverSettleKind", params.getInt("deliverSettleKind")));
  249. }
  250. if (ERPUtils.mapContainKey(params, "storeCodeInput")) {
  251. String storeCodeInput = params.getString("storeCodeInput");
  252. BoolQueryBuilder qbStoreCode = QueryBuilders.boolQuery()
  253. .should(QueryBuilders.matchQuery("storeCodeInput", storeCodeInput).analyzer("query_ansj").operator(Operator.AND))
  254. .should(QueryBuilders.termQuery("storeCodeInput.number", storeCodeInput.toLowerCase()))
  255. .should(QueryBuilders.matchQuery("storeCodeInput.letter", storeCodeInput.toLowerCase()).operator(Operator.AND));
  256. qb = qb.must(qbStoreCode);
  257. }
  258. if (ERPUtils.mapContainKey(params, "contractPhone")) {
  259. String phone = params.getString("contractPhone");
  260. qb = qb.must(QueryBuilders.termQuery("contractPhone", phone));
  261. }
  262. if (ERPUtils.mapContainKey(params, "voidFlag")) {
  263. qb = qb.must(QueryBuilders.termQuery("voidFlag", params.getInt("voidFlag")));
  264. }
  265. return qb;
  266. }),
  267. ((op) -> {
  268. idStores.add(op.getId());
  269. }),
  270. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  271. pageFlipper,
  272. (() -> SortBuilders.fieldSort("id").order(SortOrder.DESC))
  273. );
  274. long[] idStoreArray = idStores.stream().mapToLong(Long::valueOf).toArray();
  275. String idStoreStr = idStores.stream().map(String::valueOf).collect(Collectors.joining(","));
  276. Map<Long, List<StorePlatform>> storePlatformMap = searchESMapList(idStoreArray, esClient, jsonConvert,
  277. StorePlatform.class,
  278. null,
  279. ((sd) -> {
  280. BoolQueryBuilder qb = QueryBuilders.boolQuery();
  281. qb = qb.must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE))
  282. .must(QueryBuilders.termsQuery("idStore", idStoreStr.split(",")));
  283. return qb;
  284. }),
  285. (StorePlatform::getIdStore),
  286. new String[]{keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode)},
  287. (SortBuilderExecutor) null);
  288. List<ViewStoreInfo> viewStoreInfoList = new ArrayList<>();
  289. storeInfoList.forEach(x -> {
  290. x.setPlatformList(storePlatformMap.get(x.getId()));
  291. ViewStoreInfo viewStoreInfo = new ViewStoreInfo(x);
  292. viewStoreInfoList.add(viewStoreInfo);
  293. });
  294. return viewStoreInfoList;
  295. }
  296. @Override
  297. public ViewStoreInfo getViewStoreInfo(long idStore, long supplierCode, boolean readInvoice, boolean readEmployee, boolean readPlatform) {
  298. StoreInfo storeInfo = getESOneInfo(esClient, jsonConvert, StoreInfo.class,
  299. String.valueOf(idStore),
  300. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  301. ESKeys.ES_DELIVER_STORE_INFO_TYPE,
  302. null
  303. );
  304. if (readInvoice) {
  305. StoreInvoiceInfo storeInvoiceInfo = this.getStoreInvoiceInfo(idStore,supplierCode);
  306. storeInfo.setInvoiceInfo(storeInvoiceInfo);
  307. }
  308. if (readEmployee) { //先不用
  309. }
  310. if (readPlatform) {
  311. List<StorePlatform> platformList = searchESList(esClient,jsonConvert,StorePlatform.class,
  312. null,
  313. ((sd) -> {
  314. BoolQueryBuilder qb = QueryBuilders.boolQuery();
  315. qb = qb.must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE))
  316. .must(QueryBuilders.termQuery("idStore",idStore));
  317. return qb;
  318. }),
  319. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  320. (SortBuilderExecutor) null
  321. );
  322. storeInfo.setPlatformList(platformList);
  323. }
  324. return new ViewStoreInfo(storeInfo);
  325. }
  326. @Override
  327. public RetResult<StoreInfo> addStoreInfo(StoreInfo storeInfo, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  328. if (StringUtils.isBlank(storeInfo.getStoreName()))
  329. return RetResult.<StoreInfo>errorT().retinfo("门店名称不可为空");
  330. //其他是否必须输入 前端判断
  331. //先查一下有没有重名的平台信息
  332. StoreBrand esInfo = this.getESOneInfo(esClient, jsonConvert,
  333. StoreBrand.class,
  334. (a) -> {
  335. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_INFO_TYPE));
  336. qb.must(QueryBuilders.termQuery("storeName.raw", storeInfo.getStoreName()));
  337. return qb;
  338. },
  339. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  340. null);
  341. if (esInfo != null) return RetResult.<StoreInfo>errorT().retinfo("已存在同名的门店");
  342. storeInfo.setId(tableIdService.getTableIdMulti("tbStoreInfo.id", 1, dataSourceId, String.valueOf(supplierCode)));
  343. StoreInfo.create(storeInfo, currentUser.getId());
  344. storeInfo.setEnableInvoice(0);
  345. IndexResponse itemResponse = esClient.getClient()
  346. .prepareIndex(keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_TYPE, supplierCode), ESKeys.ES_DELIVER_STORE_INFO_INDEX)
  347. .setId(String.valueOf(storeInfo.getId()))
  348. .setSource(jsonConvert.convertTo(storeInfo), XContentType.JSON)
  349. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE)
  350. .get();
  351. if (itemResponse.getResult() == DocWriteResponse.Result.CREATED) {
  352. storeDao.addStoreInfo(storeInfo, dataSourceId, supplierCode);
  353. } else {
  354. return RetResult.<StoreInfo>errorT().retinfo("创建门店失败");
  355. }
  356. return RetResult.successT();
  357. }
  358. @Override
  359. public StoreInvoiceInfo getStoreInvoiceInfo(long idStore, long supplierCode) {
  360. return this.getESOneInfo(esClient, jsonConvert,
  361. StoreInvoiceInfo.class,
  362. (sd) -> {
  363. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_INVOICE_INFO_TYPE));
  364. qb.must(QueryBuilders.termQuery("idStore", idStore));
  365. return qb;
  366. },
  367. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_TYPE, supplierCode),
  368. null);
  369. }
  370. @Override
  371. public RetResult<StoreInvoiceInfo> configStoreInvoiceInfo(StoreInvoiceInfo invoiceInfo, int enableInvoice, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  372. StoreInfo esStoreInfo = this.getViewStoreInfo(invoiceInfo.getIdStore(), supplierCode, false, false, false).getStoreInfo();
  373. if (esStoreInfo == null)
  374. return RetResult.<StoreInvoiceInfo>errorT().retinfo("未找到门店信息");
  375. esStoreInfo.setEnableInvoice(enableInvoice);
  376. StoreInfo.update(esStoreInfo, currentUser.getId());
  377. try {
  378. UpdateRequest updateRequest = new UpdateRequest(
  379. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  380. ESKeys.ES_DELIVER_STORE_INFO_TYPE, String.valueOf(esStoreInfo.getId()))
  381. .doc(jsonBuilder()
  382. .startObject()
  383. .field("enableInvoice", esStoreInfo.getEnableInvoice())
  384. .field("updateTimeLong", esStoreInfo.getUpdateTimeLong())
  385. .field("updateBy", esStoreInfo.getUpdateBy())
  386. .endObject())
  387. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  388. esClient.getClient().update(updateRequest).get();
  389. } catch (IOException | InterruptedException | ExecutionException e) {
  390. logger.error("启用或停用门店开票信息[" + esStoreInfo.getId() + "出错:" + e.getMessage(), e);
  391. RetResult.<StoreInvoiceInfo>errorT().retinfo("启用或停用门店开票信息[" + esStoreInfo.getId() + "出错:");
  392. }
  393. if (enableInvoice == 0) { //停用门店开票 不动发票信息
  394. storeDao.updateStoreEnableInvoice(esStoreInfo, dataSourceId, supplierCode);
  395. return RetResult.successT();
  396. }
  397. // 启用开票
  398. StoreInvoiceInfo esInvoice = getStoreInvoiceInfo(invoiceInfo.getIdStore(), supplierCode);
  399. if (esInvoice == null) { // 未设置过发票信息 需要新增
  400. invoiceInfo.setId(tableIdService.getTableIdMulti("tbStoreInvoiceInfo.id", 1, dataSourceId, String.valueOf(supplierCode)));
  401. StoreInvoiceInfo.create(invoiceInfo, currentUser.getId());
  402. IndexResponse itemResponse = esClient.getClient()
  403. .prepareIndex(
  404. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INVOICE_INFO_TYPE, supplierCode), ESKeys.ES_DELIVER_STORE_INFO_INDEX)
  405. .setId(String.valueOf(invoiceInfo.getId()))
  406. .setParent(String.valueOf(invoiceInfo.getIdStore()))
  407. .setSource(jsonConvert.convertTo(invoiceInfo), XContentType.JSON)
  408. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE)
  409. .get();
  410. if (itemResponse.getResult() == DocWriteResponse.Result.CREATED) {
  411. storeDao.addStoreInvoiceInfo(invoiceInfo, esStoreInfo, dataSourceId, supplierCode);
  412. } else {
  413. return RetResult.<StoreInvoiceInfo>errorT().retinfo("门店启用开票失败");
  414. }
  415. } else {
  416. esInvoice.setTaxIdNo(invoiceInfo.getTaxIdNo());
  417. esInvoice.setCompanyName(invoiceInfo.getCompanyName());
  418. esInvoice.setDefaultTaxItemCode(invoiceInfo.getDefaultTaxItemCode());
  419. esInvoice.setDefaultTaxItemName(invoiceInfo.getDefaultTaxItemName());
  420. esInvoice.setTaxRate(invoiceInfo.getTaxRate());
  421. StoreInvoiceInfo.update(esInvoice, currentUser.getId());
  422. try {
  423. UpdateRequest updateInvoiceRequest = new UpdateRequest(
  424. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  425. ESKeys.ES_DELIVER_STORE_INVOICE_INFO_TYPE, String.valueOf(esStoreInfo.getId()))
  426. .doc(jsonBuilder()
  427. .startObject()
  428. .field("taxIdNo", esInvoice.getTaxIdNo())
  429. .field("companyName", esInvoice.getCompanyName())
  430. .field("defaultTaxItemName", esInvoice.getDefaultTaxItemName())
  431. .field("defaultTaxItemCode", esInvoice.getDefaultTaxItemCode())
  432. .field("taxRate", esInvoice.getTaxRate())
  433. .field("updateTimeLong", esInvoice.getUpdateTimeLong())
  434. .field("updateBy", esInvoice.getUpdateBy())
  435. .endObject())
  436. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  437. esClient.getClient().update(updateInvoiceRequest).get();
  438. } catch (IOException | InterruptedException | ExecutionException e) {
  439. logger.error("门店启用开票信息[" + esStoreInfo.getId() + "出错" + e.getMessage(), e);
  440. return RetResult.<StoreInvoiceInfo>errorT().retinfo("门店启用开票失败");
  441. }
  442. storeDao.updateStoreInvoiceInfo(esInvoice, esStoreInfo, dataSourceId, supplierCode);
  443. }
  444. return RetResult.successT();
  445. }
  446. @Override
  447. public RetResult<StoreInfo> updateStoreInfo(StoreInfo storeInfo, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  448. if (StringUtils.isBlank(storeInfo.getStoreName()))
  449. return RetResult.<StoreInfo>errorT().retinfo("门店名称不可为空");
  450. StoreInfo esInfo = this.getViewStoreInfo(storeInfo.getId(), supplierCode, false, false, false).getStoreInfo();
  451. if (esInfo == null) {
  452. return RetResult.<StoreInfo>errorT().retinfo("未找到此门店品牌");
  453. }
  454. //先查一下有没有重名的门店信息(防止修改名称改重)同行业门店不同地区门店名可以重
  455. StoreBrand checkNameInfo = this.getESOneInfo(esClient, jsonConvert,
  456. StoreBrand.class,
  457. (a) -> {
  458. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_INFO_TYPE));
  459. qb.must(QueryBuilders.termQuery("storeName.raw", esInfo.getStoreName()))
  460. .mustNot(QueryBuilders.idsQuery(String.valueOf(esInfo.getId())));
  461. return qb;
  462. },
  463. keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  464. null);
  465. if (checkNameInfo != null) return RetResult.<StoreInfo>errorT().retinfo("已存在同名的门店");
  466. esInfo.setStoreName(storeInfo.getStoreName());
  467. esInfo.setIdBrand(storeInfo.getIdBrand());
  468. esInfo.setBrandName(storeInfo.getBrandName());
  469. esInfo.setIdStoreType(storeInfo.getIdStoreType());
  470. esInfo.setDeliverSettleKind(storeInfo.getDeliverSettleKind());
  471. esInfo.setStoreCodeInput(storeInfo.getStoreCodeInput());
  472. esInfo.setStoreProvince(storeInfo.getStoreProvince());
  473. esInfo.setStoreCity(storeInfo.getStoreCity());
  474. esInfo.setStoreDistrict(storeInfo.getStoreDistrict());
  475. esInfo.setStoreAddress(storeInfo.getStoreAddress());
  476. esInfo.setLocationStr(storeInfo.getLocationStr());
  477. esInfo.setContractPhone(storeInfo.getContractPhone());
  478. esInfo.setStoreBossId(storeInfo.getStoreBossId());
  479. StoreInfo.update(esInfo, currentUser.getId());
  480. try {
  481. UpdateRequest updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  482. ESKeys.ES_DELIVER_STORE_INFO_TYPE, String.valueOf(esInfo.getId()))
  483. .doc(jsonBuilder()
  484. .startObject()
  485. .field("storeName", esInfo.getStoreName())
  486. .field("idBrand", esInfo.getIdBrand())
  487. .field("brandName", esInfo.getBrandName())
  488. .field("idStoreType", esInfo.getIdStoreType())
  489. .field("deliverSettleKind", esInfo.getDeliverSettleKind())
  490. .field("storeCodeInput", esInfo.getStoreCodeInput())
  491. .field("storeProvince", esInfo.getStoreProvince())
  492. .field("storeCity", esInfo.getStoreCity())
  493. .field("storeDistrict", esInfo.getStoreDistrict())
  494. .field("storeAddress", esInfo.getStoreAddress())
  495. .field("locationStr", esInfo.getLocationStr())
  496. .field("contractPhone", esInfo.getContractPhone())
  497. .field("storeBossId", esInfo.getStoreBossId())
  498. .field("updateTimeLong", esInfo.getUpdateTimeLong())
  499. .field("updateBy", esInfo.getUpdateBy())
  500. .endObject())
  501. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  502. esClient.getClient().update(updateRequest).get();
  503. } catch (IOException | InterruptedException | ExecutionException e) {
  504. logger.error("修改门店[" + esInfo.getId() + "出错:" + e.getMessage(), e);
  505. }
  506. storeDao.updateStoreInfo(esInfo, dataSourceId, supplierCode);
  507. return RetResult.successT();
  508. }
  509. @Override
  510. public RetResult<StoreInfo> voidStoreInfo(StoreInfo storeInfo, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  511. StoreInfo esInfo = this.getViewStoreInfo(storeInfo.getId(), supplierCode, false, false, false).getStoreInfo();
  512. if (esInfo == null) {
  513. return RetResult.<StoreInfo>errorT().retinfo("未找到此门店");
  514. }
  515. esInfo.setVoidFlag(storeInfo.getVoidFlag());
  516. StoreInfo.update(esInfo, currentUser.getId());
  517. try {
  518. UpdateRequest updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_INFO_INDEX, supplierCode),
  519. ESKeys.ES_DELIVER_STORE_INFO_TYPE, String.valueOf(esInfo.getId()))
  520. .doc(jsonBuilder()
  521. .startObject()
  522. .field("voidFlag", esInfo.getVoidFlag())
  523. .field("updateTimeLong", esInfo.getUpdateTimeLong())
  524. .field("updateBy", esInfo.getUpdateBy())
  525. .endObject())
  526. .setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  527. esClient.getClient().update(updateRequest).get();
  528. } catch (IOException | InterruptedException | ExecutionException e) {
  529. logger.error("禁用或启用门店[" + esInfo.getId() + "出错:" + e.getMessage(), e);
  530. }
  531. storeDao.voidStoreInfo(esInfo, dataSourceId, supplierCode);
  532. return RetResult.successT();
  533. }
  534. //region 门店平台
  535. @Override
  536. public StorePlatform getStoreStorePlatformInfo(long id, long supplierCode) {
  537. return this.getESOneInfo(esClient, jsonConvert, StorePlatform.class,
  538. String.valueOf(id),
  539. keysService.getESKey(ESKeys.ES_DELIVER_PLATFORM_INFO_INDEX, supplierCode),
  540. ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE,
  541. null);
  542. }
  543. @Override
  544. public RetResult<StorePlatform> addStorePlatform(StorePlatform storePlatform, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  545. StorePlatform esInfo = this.getESOneInfo(esClient, jsonConvert,
  546. StorePlatform.class,
  547. (a) -> {
  548. BoolQueryBuilder qb = QueryBuilders.boolQuery().must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE));
  549. qb.must(QueryBuilders.termQuery("idPlatformInfo", storePlatform.getIdPlatformInfo()));
  550. return qb;
  551. },
  552. keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode),
  553. null);
  554. if (esInfo != null)
  555. return RetResult.<StorePlatform>errorT().retinfo("此平台已开通:" + storePlatform.getPlatformName());
  556. storePlatform.setId(tableIdService.getTableIdMulti("tbStorePlatform.id", 1, dataSourceId, String.valueOf(supplierCode)));
  557. StorePlatform.create(storePlatform, currentUser.getId());
  558. storePlatform.setEnableStatue(0);
  559. BulkRequestBuilder bulkRequest = esClient.getClient().prepareBulk().setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  560. bulkRequest.add(esClient.getClient().prepareIndex(
  561. keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode), ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE)
  562. .setId(String.valueOf(storePlatform.getId()))
  563. .setSource(jsonConvert.convertTo(storePlatform), XContentType.JSON));
  564. storePlatform.getRequireList().forEach(x -> {
  565. x.setId(tableIdService.getTableIdMulti("tbStorePlatformRequire.id", 1, dataSourceId, String.valueOf(supplierCode)));
  566. x.setIdStore(storePlatform.getIdStore());
  567. x.setIdStorePlatform(storePlatform.getId());
  568. StorePlatformRequire.create(x, currentUser.getId());
  569. bulkRequest.add(esClient.getClient().prepareIndex(
  570. keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode), ESKeys.ES_DELIVER_STORE_PLATFORM_REQUIRE_TYPE)
  571. .setId(String.valueOf(x.getId()))
  572. .setParent(String.valueOf(storePlatform.getId()))
  573. .setSource(jsonConvert.convertTo(storePlatform), XContentType.JSON));
  574. });
  575. BulkResponse bulkResponse = bulkRequest.get();
  576. if (bulkResponse.hasFailures()) {
  577. logger.error("门店开通平台出错:" + bulkResponse.buildFailureMessage());
  578. return RetResult.<StorePlatform>errorT().retinfo("门店开通平台出错:" + storePlatform.getPlatformName());
  579. } else {
  580. logger.info("门店开通平台成功");
  581. //写数据库
  582. storeDao.addStorePlatform(storePlatform, storePlatform.getRequireList(), dataSourceId, supplierCode);
  583. return RetResult.successT();
  584. }
  585. }
  586. @Override
  587. public RetResult<StorePlatform> configStorePlatform(StorePlatform storePlatform, ERPTokenUser currentUser, String dataSourceId, long supplierCode) {
  588. StorePlatform esInfo = this.getStoreStorePlatformInfo(storePlatform.getId(), supplierCode);
  589. if (esInfo == null) {
  590. return RetResult.<StorePlatform>errorT().retinfo("未找到此开通平台");
  591. }
  592. esInfo.setIdStore(storePlatform.getIdPlatformInfo());
  593. esInfo.setPlatformName(storePlatform.getPlatformName());
  594. esInfo.setPlatformType(storePlatform.getPlatformType());
  595. esInfo.setEnableStatue(storePlatform.getEnableStatue());
  596. StorePlatform.update(esInfo, currentUser.getId());
  597. BulkRequestBuilder bulkRequest = esClient.getClient().prepareBulk().setRefreshPolicy(WriteRequest.RefreshPolicy.IMMEDIATE);
  598. UpdateRequest updateRequest = null;
  599. try {
  600. updateRequest = new UpdateRequest(keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode),
  601. ESKeys.ES_DELIVER_STORE_PLATFORM_TYPE, String.valueOf(esInfo.getId()))
  602. .doc(jsonBuilder()
  603. .startObject()
  604. .field("idPlatformInfo", esInfo.getIdPlatformInfo())
  605. .field("platformName", esInfo.getPlatformName())
  606. .field("platformType", esInfo.getPlatformType())
  607. .field("enableStatue", esInfo.getEnableStatue())
  608. .field("updateTimeLong", esInfo.getUpdateTimeLong())
  609. .field("updateBy", esInfo.getUpdateBy())
  610. .endObject());
  611. } catch (IOException e) {
  612. throw new RuntimeException(e);
  613. }
  614. bulkRequest.add(updateRequest);
  615. storePlatform.getRequireList().forEach(x -> {
  616. if (x.getId() <= 0) {
  617. x.setId(tableIdService.getTableIdMulti("tbStorePlatformRequire.id", 1, dataSourceId, String.valueOf(supplierCode)));
  618. StorePlatformRequire.create(x, currentUser.getId());
  619. }
  620. x.setIdStore(storePlatform.getIdStore());
  621. x.setIdStorePlatform(storePlatform.getIdPlatformInfo());
  622. StorePlatformRequire.update(x, currentUser.getId());
  623. bulkRequest.add(esClient.getClient().prepareIndex(
  624. keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode), ESKeys.ES_DELIVER_STORE_PLATFORM_REQUIRE_TYPE)
  625. .setId(String.valueOf(x.getId()))
  626. .setParent(String.valueOf(storePlatform.getId()))
  627. .setSource(jsonConvert.convertTo(storePlatform), XContentType.JSON));
  628. });
  629. BoolQueryBuilder qbOrderPart = QueryBuilders.boolQuery()
  630. .must(QueryBuilders.typeQuery(ESKeys.ES_DELIVER_STORE_PLATFORM_REQUIRE_TYPE))
  631. .must(QueryBuilders.termQuery("idStorePlatform", esInfo.getId()));
  632. DeleteByQueryAction.INSTANCE.newRequestBuilder(esClient.getClient())
  633. .refresh(true)
  634. .source(keysService.getESKey(ESKeys.ES_DELIVER_STORE_PLATFORM_INDEX, supplierCode))
  635. .filter(qbOrderPart)
  636. .get();
  637. BulkResponse bulkResponse = bulkRequest.get();
  638. if (bulkResponse.hasFailures()) {
  639. logger.error("门店配置平台出错:" + bulkResponse.buildFailureMessage());
  640. return RetResult.<StorePlatform>errorT().retinfo("门店配置平台出错:" + storePlatform.getPlatformName());
  641. } else {
  642. logger.info("门店配置平台成功");
  643. //写数据库
  644. storeDao.updateStorePlatform(esInfo, storePlatform.getRequireList(), dataSourceId, supplierCode);
  645. return RetResult.successT();
  646. }
  647. }
  648. //endregion
  649. }