CommonService.java 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833
  1. package com.dk.mdm.service.common;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.dk.common.infrastructure.constant.Constant;
  4. import com.dk.common.infrastructure.enums.ErrorCodeEnum;
  5. import com.dk.common.mapper.BaseMapper;
  6. import com.dk.common.model.pojo.PageList;
  7. import com.dk.common.model.vo.core.StaffEntity;
  8. import com.dk.common.response.ResponseCodeEnum;
  9. import com.dk.common.response.ResponseResultUtil;
  10. import com.dk.common.response.ResponseResultVO;
  11. import com.dk.common.service.BaseService;
  12. import com.dk.mdm.mapper.common.CommonMapper;
  13. import com.dk.mdm.infrastructure.util.AuthUtils;
  14. import com.dk.mdm.mapper.mst.StaffMapper;
  15. import com.dk.common.model.response.mst.StaffResponse;
  16. import com.dk.mdm.model.pojo.mst.Staff;
  17. import lombok.extern.slf4j.Slf4j;
  18. import org.postgresql.util.PGobject;
  19. import org.springframework.beans.factory.annotation.Autowired;
  20. import org.springframework.stereotype.Service;
  21. import org.springframework.transaction.annotation.Transactional;
  22. import java.util.*;
  23. /**
  24. * @author : 周兴
  25. * @desc : 控件数据源API
  26. * @date : 2023/1/3 17:21
  27. */
  28. @Service
  29. @Slf4j
  30. public class CommonService extends BaseService<Map<String, Object>> {
  31. @Override
  32. public BaseMapper<Map<String, Object>> getRepository() {
  33. return commonMapper;
  34. }
  35. @Autowired
  36. private CommonMapper commonMapper;
  37. @Autowired
  38. private StaffMapper staffMapper;
  39. @Autowired
  40. private AuthUtils authUtils;
  41. /**
  42. * @desc : 获取编码/单号
  43. * @author : 周兴
  44. * @date : 2024/3/1 11:41
  45. */
  46. public Map<String, Object> getUniqueNoteCode(String docName, Boolean codeFlag) {
  47. Map<String, Object> param = new HashMap<>();
  48. param.put("docName", docName);
  49. // 公司Id
  50. StaffEntity staff = authUtils.getStaff();
  51. param.put("cpId", staff.getCpId());
  52. Map<String, Object> map = null;
  53. // 获取系统基础数据
  54. if (codeFlag) {
  55. map = commonMapper.getUniqueCode(param);
  56. } else {
  57. map = commonMapper.getUniqueNote(param);
  58. }
  59. return map;
  60. }
  61. /**
  62. * @desc : 获取编码/单号
  63. * @author : 周兴
  64. * @date : 2024/3/1 11:41
  65. */
  66. public Map<String, Object> getUniqueNoteCode(String docName, Integer cpId, Boolean codeFlag) {
  67. Map<String, Object> param = new HashMap<>();
  68. param.put("docName", docName);
  69. // 公司Id
  70. // StaffEntity staff = authUtils.getStaff();
  71. param.put("cpId", cpId);
  72. Map<String, Object> map = null;
  73. // 获取系统基础数据
  74. if (codeFlag) {
  75. map = commonMapper.getUniqueCode(param);
  76. } else {
  77. map = commonMapper.getUniqueNote(param);
  78. }
  79. return map;
  80. }
  81. /**
  82. * @desc : 获取数据字典项目
  83. * @author : 王英杰
  84. * @date : 2023/1/6 11:41
  85. */
  86. public ResponseResultVO<List<Map<String, Object>>> getDictionaryItemData(Map<String, Object> param) {
  87. // 获取系统基础数据
  88. List<Map<String, Object>> list = commonMapper.getDictionaryItemData(param);
  89. return ResponseResultUtil.success(list);
  90. }
  91. /**
  92. * @desc : 刷新基础数据
  93. * @author : 周兴
  94. * @date : 2023/5/11 10:19
  95. */
  96. public ResponseResultVO refreshBasicData(Map<String, Object> param) {
  97. return null;
  98. // UserVO user = authUtils.getUser();
  99. // if (param.get("appCode") != null) {
  100. // user.setAppCode(param.get("appCode").toString());
  101. // }
  102. // Map userMap = new HashMap();
  103. // userMap.put("userId", user.getUserId());
  104. // userMap.put("appCode", user.getAppCode());
  105. // return ResponseResultUtil.success(new HashMap<String, Object>(3) {{
  106. // put("menu", commonMapper.getMenuByUser(user.getAppCode(), user.getUserId()));
  107. // put("function", (user.getRoleIds() != null && user.getRoleIds().indexOf(-1) >= 0)
  108. // ? commonMapper.getUserFunctionAdmin(userMap) : commonMapper.getUserFunction(userMap));
  109. // put("userTableSetting", commonMapper.getUserTableInfo(userMap));
  110. // }});
  111. }
  112. /**
  113. * @desc : 获取序号最大值
  114. * @author : 周兴
  115. * @date : 2023/1/6 11:41t_user_right
  116. */
  117. public Integer getMaxDisplayNo(Constant.DisplayNoTable displayNoTable, Map<String, Object> param) {
  118. if (param == null) {
  119. param = new HashMap<>();
  120. }
  121. param.put("cpId", authUtils.getStaff().getCpId());
  122. String table = displayNoTable.getTable();
  123. String mode = displayNoTable.getMode();
  124. if (table != null && mode != null) {
  125. table = mode + "." + table;
  126. param.put("table", table);
  127. // 获取最大序号
  128. Integer maxDisplayNo = commonMapper.getMaxDisplayNo(param);
  129. return maxDisplayNo == null ? 1 : maxDisplayNo;
  130. }
  131. return 0;
  132. }
  133. /**
  134. * @desc : 获取序号最大值
  135. * @author : 周兴
  136. * @date : 2023/1/6 11:41t_user_right
  137. */
  138. public Integer getMaxDisplayNo(Constant.DisplayNoTable displayNoTable) {
  139. return getMaxDisplayNo(displayNoTable, null);
  140. }
  141. /**
  142. * @desc : 获取系统表数据种类
  143. * @author : 周兴
  144. * @date : 2023/1/6 11:41
  145. */
  146. public ResponseResultVO<List<Map<String, Object>>> getDataKind(Map<String, Object> param) {
  147. // 获取系统基础数据
  148. List<Map<String, Object>> list = commonMapper.getDataKind(param);
  149. return ResponseResultUtil.success(list);
  150. }
  151. /**
  152. * @desc : 获取组织部门
  153. * @author : 姜宁
  154. * @date : 2023/1/9 13:50
  155. */
  156. public ResponseResultVO<List<Map<String, Object>>> getOrg(Map<String, Object> param) {
  157. // 获取系统基础数据
  158. List<Map<String, Object>> list = commonMapper.getOrg(param);
  159. return ResponseResultUtil.success(list);
  160. }
  161. /**
  162. * @desc : 只获取二级部门 按照level_code 排序
  163. * @author : 王英杰
  164. * @date : 2023/1/9 13:49
  165. */
  166. public ResponseResultVO<List<Map<String, Object>>> getProcureOrg(Map<String, Object> param) {
  167. // 获取系统基础数据
  168. List<Map<String, Object>> list = commonMapper.getProcureOrg(param);
  169. return ResponseResultUtil.success(list);
  170. }
  171. /**
  172. * @desc : 获取部门
  173. * @author : 姜宁
  174. * @date : 2023/1/29 17:01
  175. */
  176. public ResponseResultVO<PageList<Map<String, Object>>> getOrgByPage(Map<String, Object> param) {
  177. // 校验分页参数
  178. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  179. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  180. }
  181. // 分页参数赋值
  182. param = this.getLimit(param);
  183. return super.mergeListWithCount(param, commonMapper.getOrg(param),
  184. commonMapper.getOrgCountByPage(param));
  185. }
  186. /**
  187. * @desc : 获取角色
  188. * @author : 姜宁
  189. * @date : 2023/1/29 14:28
  190. */
  191. public ResponseResultVO<List<Map<String, Object>>> getRole(Map<String, Object> param) {
  192. // 获取系统基础数据
  193. List<Map<String, Object>> list = commonMapper.getRole(param);
  194. return ResponseResultUtil.success(list);
  195. }
  196. /**
  197. * @desc : 获取员工信息
  198. * @author : 周兴
  199. * @date : 2023/2/2 13:11
  200. */
  201. public ResponseResultVO<List<Map<String, Object>>> getStaff(Map<String, Object> param) {
  202. // 获取员工
  203. List<Map<String, Object>> list = commonMapper.getStaffByPage(param);
  204. return ResponseResultUtil.success(list);
  205. }
  206. /**
  207. * @desc : 获取员工
  208. * @author : 姜宁
  209. * @date : 2023/1/29 17:01
  210. */
  211. public ResponseResultVO<PageList<Map<String, Object>>> getStaffByPage(Map<String, Object> param) {
  212. // 校验分页参数
  213. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  214. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  215. }
  216. // 分页参数赋值
  217. param = this.getLimit(param);
  218. return super.mergeListWithCount(param, commonMapper.getStaffByPage(param),
  219. commonMapper.getStaffCountByPage(param));
  220. }
  221. /**
  222. * @desc : 查询系统参数
  223. * @author : 周兴
  224. * @date : 2023/1/29 17:04
  225. */
  226. public ResponseResultVO getSettingValue(Map<String, Object> param) {
  227. if (param.get("code").getClass().getName() == "java.util.ArrayList") {
  228. param.put("codes", param.get("code"));
  229. // 如果是数组,那么调用多个的查询
  230. Map<String, Map<String, String>> settingMap = commonMapper.getSettingValues(param);
  231. // 定义返回值
  232. JSONObject object = JSONObject.parseObject(((PGobject) settingMap.get("f_get_setting_values")).getValue());
  233. return ResponseResultUtil.success(object);
  234. } else {
  235. // 单个
  236. String setting = commonMapper.getSettingValue(param);
  237. // 定义返回值
  238. return ResponseResultUtil.success(setting);
  239. }
  240. }
  241. /**
  242. * @desc : 查询系统参数分类
  243. * @author : 夏常明
  244. * @date : 2023/1/30 16:05
  245. */
  246. public ResponseResultVO<List<Map<String, Object>>> getSettingKind(Map<String, Object> param) {
  247. // 获取系统基础数据
  248. List<Map<String, Object>> list = commonMapper.getSettingKind(param);
  249. return ResponseResultUtil.success(list);
  250. }
  251. /**
  252. * @desc : 设置分页参数
  253. * @author : 姜宁
  254. * @date : 2023/2/1 14:00
  255. */
  256. private Map<String, Object> getLimit(Map<String, Object> param) {
  257. if (param.get("limit") != null) {
  258. param.put("currentPage", 1);
  259. param.put("pageSize", param.get("limit"));
  260. }
  261. param.put("start", ((int) param.get("currentPage") - 1) * (int) param.get("pageSize"));
  262. param.put("end", param.get("pageSize"));
  263. return param;
  264. }
  265. /**
  266. * @desc : 获取数据字典
  267. * @author : 姜宁
  268. * @date : 2023/2/7 14:47
  269. */
  270. public ResponseResultVO<List<Map<String, Object>>> getDictionaryData(Map<String, Object> param) {
  271. // 获取数据字典
  272. List<Map<String, Object>> list = commonMapper.getDictionaryData(param);
  273. return ResponseResultUtil.success(list);
  274. }
  275. /**
  276. * @desc : 获取用户隐藏列信息
  277. * @author : 周兴
  278. * @date : 2023/4/4 15:05
  279. */
  280. public ResponseResultVO<List<Map<String, Object>>> getUserTableInfo(Map<String, Object> param) {
  281. return ResponseResultUtil.success(commonMapper.getUserTableInfo(param));
  282. }
  283. /**
  284. * @desc : 获取用户功能
  285. * @author : 周兴
  286. * @date : 2023/4/4 15:05
  287. */
  288. public ResponseResultVO<List<Map<String, Object>>> getUserFunction(Map<String, Object> param) {
  289. return ResponseResultUtil.success(commonMapper.getUserFunction(param));
  290. }
  291. /**
  292. * @desc : 查导航菜单(自定义报表用)
  293. * @author : 周兴
  294. * @date : 2023/4/4 15:05
  295. */
  296. public ResponseResultVO<List<Map<String, Object>>> getMenuNavigation(Map<String, Object> param) {
  297. return ResponseResultUtil.success(commonMapper.getMenuNavigation(param));
  298. }
  299. /**
  300. * @desc : 获取数据类型
  301. * @author : 周兴
  302. * @date : 2023/6/2 11:01
  303. */
  304. public ResponseResultVO<List<Map<String, Object>>> getValueKind(Map<String, Object> param) {
  305. return ResponseResultUtil.success(commonMapper.getValueKind(param));
  306. }
  307. /**
  308. * @desc : 获取应用
  309. * @author : 洪旭东
  310. * @date : 2023-06-30 14:56
  311. */
  312. public ResponseResultVO<List<Map<String, String>>> getApplication() {
  313. return ResponseResultUtil.success(commonMapper.getApplication());
  314. }
  315. /**
  316. * @desc : 获取单据
  317. * @author : 周兴
  318. * @date : 2023/9/14 11:06
  319. */
  320. public ResponseResultVO<List<Map<String, Object>>> getDoc(Map<String, Object> param) {
  321. return ResponseResultUtil.success(commonMapper.getDoc(param));
  322. }
  323. /**
  324. * @desc : 获取商品
  325. * @author : 姜宁
  326. * @date : 2023/1/9 13:50
  327. */
  328. public ResponseResultVO<List<Map<String, Object>>> getGoods(Map<String, Object> param) {
  329. // 获取系统基础数据
  330. List<Map<String, Object>> list = commonMapper.getGoods(param);
  331. return ResponseResultUtil.success(list);
  332. }
  333. /**
  334. * @desc : 获取商品数量
  335. * @author : 姜宁
  336. * @date : 2023/1/29 17:01
  337. */
  338. public ResponseResultVO<PageList<Map<String, Object>>> getGoodsPage(Map<String, Object> param) {
  339. // 校验分页参数
  340. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  341. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  342. }
  343. // 分页参数赋值
  344. param = this.getLimit(param);
  345. return super.mergeListWithCount(param, commonMapper.getGoods(param),
  346. commonMapper.getGoodsCountByPage(param));
  347. }
  348. /**
  349. * @desc : 获取商品(销售订单开单用)
  350. * @author : 付斌
  351. * @date : 2024-03-09 9:57
  352. */
  353. public ResponseResultVO<List<Map<String, Object>>> getGoodsForOrder(Map<String, Object> param) {
  354. // 获取系统基础数据
  355. List<Map<String, Object>> list = commonMapper.getGoodsForOrder(param);
  356. return ResponseResultUtil.success(list);
  357. }
  358. /**
  359. * @desc : 获取商品(销售订单开单用)(分页)
  360. * @author : 付斌
  361. * @date : 2024-03-09 9:57
  362. */
  363. public ResponseResultVO<PageList<Map<String, Object>>> getGoodsForOrderByPage(Map<String, Object> param) {
  364. // 校验分页参数
  365. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  366. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  367. }
  368. // 分页参数赋值
  369. param = this.getLimit(param);
  370. return super.mergeListWithCount(param, commonMapper.getGoodsForOrder(param),
  371. commonMapper.getGoodsForOrderCountByPage(param));
  372. }
  373. /**
  374. * @desc : 获取商品(采购订单开单用)
  375. * @author : 常皓宁
  376. * @date : 2024/3/9 10:08
  377. */
  378. public ResponseResultVO<List<Map<String, Object>>> getGoodsForPurchase(Map<String, Object> param) {
  379. // 获取系统基础数据
  380. List<Map<String, Object>> list = commonMapper.getGoodsForPurchase(param);
  381. return ResponseResultUtil.success(list);
  382. }
  383. /**
  384. * @desc : 获取商品(采购订单开单用)(分页)
  385. * @author : 常皓宁
  386. * @date : 2024/3/9 10:08
  387. */
  388. public ResponseResultVO<PageList<Map<String, Object>>> getGoodsForPurchaseByPage(Map<String, Object> param) {
  389. // 校验分页参数
  390. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  391. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  392. }
  393. // 分页参数赋值
  394. param = this.getLimit(param);
  395. return super.mergeListWithCount(param, commonMapper.getGoodsForPurchase(param),
  396. commonMapper.getGoodsForPurchaseCountByPage(param));
  397. }
  398. /**
  399. * @desc : 获取客户
  400. * @author : 付斌
  401. * @date : 2024-03-09 9:55
  402. */
  403. public ResponseResultVO<List<Map<String, Object>>> getCustomer(Map<String, Object> param) {
  404. // 获取系统基础数据
  405. List<Map<String, Object>> list = commonMapper.getCustomer(param);
  406. return ResponseResultUtil.success(list);
  407. }
  408. /**
  409. * @desc : 获取客户(分页)
  410. * @author : 付斌
  411. * @date : 2024-03-09 9:55
  412. */
  413. public ResponseResultVO<PageList<Map<String, Object>>> GetCustomerByPage(Map<String, Object> param) {
  414. // 校验分页参数
  415. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  416. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  417. }
  418. // 分页参数赋值
  419. param = this.getLimit(param);
  420. return super.mergeListWithCount(param, commonMapper.getCustomer(param),
  421. commonMapper.getCustomerCountByPage(param));
  422. }
  423. /**
  424. * @desc : 获取供应商
  425. * @author : 常皓宁
  426. * @date : 2024/3/1 9:20
  427. */
  428. public ResponseResultVO<List<Map<String, Object>>> getSupplier(Map<String, Object> param) {
  429. // 获取公司
  430. List<Map<String, Object>> list = commonMapper.getSupplier(param);
  431. return ResponseResultUtil.success(list);
  432. }
  433. /**
  434. * @desc : 获取供应商(分页)
  435. * @author : 常皓宁
  436. * @date : 2024/3/1 9:20
  437. */
  438. public ResponseResultVO<PageList<Map<String, Object>>> getSupplierByPage(Map<String, Object> param) {
  439. // 校验分页参数
  440. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  441. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  442. }
  443. // 分页参数赋值
  444. param = this.getLimit(param);
  445. // 定义返回值
  446. PageList data = new PageList<>();
  447. // 获取供应商
  448. List<Map<String, Object>> list = commonMapper.getSupplier(param);
  449. // 获取总数量
  450. Long total = commonMapper.countSupplier(param);
  451. // 组装返回值
  452. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  453. return ResponseResultUtil.success(data);
  454. }
  455. /**
  456. * @desc : 获取渠道
  457. * @author : 付斌
  458. * @date : 2024-03-02 10:18
  459. */
  460. public ResponseResultVO<List<Map<String, Object>>> getChannel(Map<String, Object> param) {
  461. // 获取公司
  462. List<Map<String, Object>> list = commonMapper.getChannel(param);
  463. return ResponseResultUtil.success(list);
  464. }
  465. /**
  466. * @desc : 获取商品品牌(分页)
  467. * @author : 王英杰
  468. * @date : 2024/3/1 9:20
  469. */
  470. public ResponseResultVO<PageList<Map<String, Object>>> goodsBrandListBy(Map<String, Object> param) {
  471. // 校验分页参数
  472. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  473. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  474. }
  475. // 分页参数赋值
  476. param = this.getLimit(param);
  477. // 定义返回值
  478. PageList data = new PageList<>();
  479. // 获取公司
  480. List<Map<String, Object>> list = commonMapper.getGoodsBrand(param);
  481. // 获取总数量
  482. Long total = commonMapper.countGoodsBrand(param);
  483. // 组装返回值
  484. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  485. return ResponseResultUtil.success(data);
  486. }
  487. /**
  488. * @desc : 获取商品种类(分页)
  489. * @author : 王英杰
  490. * @date : 2024/3/1 9:20
  491. */
  492. public ResponseResultVO<PageList<Map<String, Object>>> goodsCategoryListBy(Map<String, Object> param) {
  493. // 校验分页参数
  494. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  495. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  496. }
  497. // 分页参数赋值
  498. param = this.getLimit(param);
  499. // 定义返回值
  500. PageList data = new PageList<>();
  501. // 获取公司
  502. List<Map<String, Object>> list = commonMapper.getGoodsCategory(param);
  503. // 获取总数量
  504. Long total = commonMapper.countGoodsCategory(param);
  505. // 组装返回值
  506. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  507. return ResponseResultUtil.success(data);
  508. }
  509. /**
  510. * @desc : 获取商品系列(分页)
  511. * @author : 王英杰
  512. * @date : 2024/3/1 9:20
  513. */
  514. public ResponseResultVO<PageList<Map<String, Object>>> goodsSeriesListBy(Map<String, Object> param) {
  515. // 校验分页参数
  516. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  517. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  518. }
  519. // 分页参数赋值
  520. param = this.getLimit(param);
  521. // 定义返回值
  522. PageList data = new PageList<>();
  523. // 获取公司
  524. List<Map<String, Object>> list = commonMapper.getGoodsSeries(param);
  525. // 获取总数量
  526. Long total = commonMapper.countGoodsSeries(param);
  527. // 组装返回值
  528. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  529. return ResponseResultUtil.success(data);
  530. }
  531. /**
  532. * @desc : 计量单位查询(分页)
  533. * @author : 王英杰
  534. * @date : 2024/3/1 9:20
  535. */
  536. public ResponseResultVO<PageList<Map<String, Object>>> unitListBy(Map<String, Object> param) {
  537. // 校验分页参数
  538. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  539. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  540. }
  541. // 分页参数赋值
  542. param = this.getLimit(param);
  543. // 定义返回值
  544. PageList data = new PageList<>();
  545. // 获取公司
  546. List<Map<String, Object>> list = commonMapper.getUnit(param);
  547. // 获取总数量
  548. Long total = commonMapper.countUnit(param);
  549. // 组装返回值
  550. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  551. return ResponseResultUtil.success(data);
  552. }
  553. /**
  554. * @desc : 获取仓库档案
  555. * @author : 王英杰
  556. * @date :2024/3/1 9:20
  557. */
  558. public ResponseResultVO<PageList<Map<String, Object>>> getWarehouseByPage(Map<String, Object> param) {
  559. this.getLimit(param);
  560. return super.mergeListWithCount(param, commonMapper.getWarehouseByPage(param),
  561. commonMapper.countWarehouseByPage(param));
  562. }
  563. /**
  564. * @desc : 获取仓库
  565. * @author : 常皓宁
  566. * @date : 2024/3/4 10:50
  567. */
  568. public ResponseResultVO<List<Map<String, Object>>> getWarehouse(Map<String, Object> param) {
  569. // 获取仓库
  570. List<Map<String, Object>> list = commonMapper.getWarehouse(param);
  571. return ResponseResultUtil.success(list);
  572. }
  573. /**
  574. * @desc : 查询库存
  575. * @author : 付斌
  576. * @date : 2024-03-05 10:52
  577. */
  578. public ResponseResultVO<List<Map<String, Object>>> getInventory(Map<String, Object> param) {
  579. // 获取系统基础数据
  580. List<Map<String, Object>> list = commonMapper.getInventory(param);
  581. return ResponseResultUtil.success(list);
  582. }
  583. /**
  584. * @desc : 查询库存(分页)
  585. * @author : 付斌
  586. * @date : 2024-03-05 10:52
  587. */
  588. public ResponseResultVO<PageList<Map<String, Object>>> getInventoryByPage(Map<String, Object> param) {
  589. // 校验分页参数
  590. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  591. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  592. }
  593. // 分页参数赋值
  594. param = this.getLimit(param);
  595. return super.mergeListWithCount(param, commonMapper.getInventory(param),
  596. commonMapper.getInventoryCountByPage(param));
  597. }
  598. /**
  599. * @desc : 商品种类查询
  600. * @author : 于继渤
  601. * @date : 2024/2/26 10:36
  602. */
  603. public ResponseResultVO<List<Map<String, Object>>> getGoodsCategoryNoPage(Map<String, Object> param) {
  604. List<Map<String, Object>> list = commonMapper.getGoodsCategory(param);
  605. return ResponseResultUtil.success(list);
  606. }
  607. /**
  608. * @desc : 获取页面数据源集合 (小程序用)
  609. * @author : 于继渤
  610. * @date : 2024/2/26 10:36
  611. */
  612. public ResponseResultVO<List<Map<String, Object>>> getInitData(Map<String, Object> param) {
  613. //判断前台是否传 dataSourceCode
  614. if (!param.containsKey("dataSourceCode") && param.get("dataSourceCode") == null) {
  615. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.DATASOURCECODE_NOT.getMessage());
  616. }
  617. String dataSourceCode = param.get("dataSourceCode").toString();
  618. //查询到的结果集
  619. List<Map<String, Object>> list = null;
  620. Map<String, Object> map = new HashMap<>();
  621. //客户来源
  622. if (dataSourceCode.equals("customerFrom")) {
  623. map.put("dictCode","基础资料-来源");
  624. list = commonMapper.getDictionaryData(map);
  625. }
  626. //销售渠道
  627. if (dataSourceCode.equals("saleChannel")) {
  628. list = commonMapper.getSaleChannel(map);
  629. }
  630. //部门
  631. if (dataSourceCode.equals("org")) {
  632. list = commonMapper.getOrg(map);
  633. }
  634. //员工
  635. if (dataSourceCode.equals("staff")) {
  636. list = commonMapper.getStaff(map);
  637. }
  638. //仓库
  639. if (dataSourceCode.equals("warehouse")) {
  640. list = commonMapper.getWarehouse(map);
  641. }
  642. //客户意向
  643. if (dataSourceCode.equals("customerIntention")) {
  644. map.put("kindType","客户意向");
  645. list = commonMapper.getDataKind(map);
  646. }
  647. //留店时长
  648. if (dataSourceCode.equals("storeRetentionTime")) {
  649. map.put("kindType","留店时长");
  650. list = commonMapper.getDataKind(map);
  651. }
  652. //邀约结果
  653. if (dataSourceCode.equals("inviteResult")) {
  654. map.put("kindType","邀约结果");
  655. list = commonMapper.getDataKind(map);
  656. }
  657. //量尺状态
  658. if (dataSourceCode.equals("scaleStatus")) {
  659. map.put("kindType","量尺状态");
  660. list = commonMapper.getDataKind(map);
  661. }
  662. //跟进方式
  663. if (dataSourceCode.equals("followType")) {
  664. map.put("kindType","跟进方式");
  665. list = commonMapper.getDataKind(map);
  666. }
  667. return ResponseResultUtil.success(list);
  668. }
  669. /**
  670. * @desc : 获取供应商和客户数据
  671. * @date : 2024/3/13 15:09
  672. * @author : 寇珊珊
  673. */
  674. public ResponseResultVO<List<Map<String, Object>>> getSupplierAndCustomer(Map<String, Object> param) {
  675. // 获取供应商和客户
  676. List<Map<String, Object>> list = commonMapper.getSupplierAndCustomer(param);
  677. return ResponseResultUtil.success(list);
  678. }
  679. /**
  680. * @desc : 获取供应商和客户数据(分页)
  681. * @date : 2024/3/13 14:02
  682. * @author : 寇珊珊
  683. */
  684. public ResponseResultVO<PageList<Map<String, Object>>> getSupplierAndCustomerByPage(Map<String, Object> param) {
  685. // 校验分页参数
  686. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  687. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  688. }
  689. // 定义返回值
  690. PageList<Map<String, Object>> data = new PageList<>();
  691. // 分页参数赋值
  692. param = this.getLimit(param);
  693. // 获取客户
  694. List<Map<String, Object>> list = commonMapper.getSupplierAndCustomerByPage(param);
  695. // 获取总数量
  696. Long total = commonMapper.getSupplierAndCustomerByPageCount(param);
  697. // 组装返回值
  698. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  699. return ResponseResultUtil.success(data);
  700. }
  701. /**
  702. * @desc : 获取组织机构
  703. * @date : 2024/3/13 17:01
  704. * @author : 寇珊珊
  705. */
  706. public ResponseResultVO<List<Map<String, Object>>> getOrganization(Map<String, Object> param) {
  707. // 获取组织机构
  708. List<Map<String, Object>> list = commonMapper.getOrganization(param);
  709. return ResponseResultUtil.success(list);
  710. }
  711. /**
  712. * @desc : 获取组织机构(分页)
  713. * @date : 2024/3/13 17:01
  714. * @author : 寇珊珊
  715. */
  716. public ResponseResultVO<PageList<Map<String, Object>>> getOrganizationByPage(Map<String, Object> param) {
  717. // 校验分页参数
  718. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  719. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  720. }
  721. // 定义返回值
  722. PageList<Map<String, Object>> data = new PageList<>();
  723. // 分页参数赋值
  724. param = this.getLimit(param);
  725. // 获取组织机构
  726. List<Map<String, Object>> list = commonMapper.getOrganizationByPage(param);
  727. // 获取总数量
  728. Long total = commonMapper.getOrganizationCount(param);
  729. // 组装返回值
  730. data.setPageSize((int) param.get("pageSize")).setCurrentPage((int) param.get("currentPage")).setList(list).setTotal(total);
  731. return ResponseResultUtil.success(data);
  732. }
  733. /**
  734. * @desc : 获取资金账户(下拉)
  735. * @author : 付斌
  736. * @date : 2024-03-14 11:34
  737. */
  738. public ResponseResultVO<List<Map<String, Object>>> getMac(Map<String, Object> param) {
  739. // 获取组织机构
  740. List<Map<String, Object>> list = commonMapper.getMac(param);
  741. return ResponseResultUtil.success(list);
  742. }
  743. /**
  744. * @desc : 获取资金账户(放大镜)
  745. * @author : 付斌
  746. * @date : 2024-03-05 10:50
  747. */
  748. public ResponseResultVO<List<Map<String, Object>>> getMoneyAccount(Map<String, Object> param) {
  749. // 获取系统基础数据
  750. List<Map<String, Object>> list = commonMapper.getMoneyAccount(param);
  751. return ResponseResultUtil.success(list);
  752. }
  753. /**
  754. * @desc : 获取资金账户(放大镜分页)
  755. * @author : 付斌
  756. * @date : 2024-03-05 10:50
  757. */
  758. public ResponseResultVO<PageList<Map<String, Object>>> getMoneyAccountByPage(Map<String, Object> param) {
  759. // 校验分页参数
  760. if (param.get("pageSize") == null || param.get("currentPage") == null) {
  761. return ResponseResultUtil.error(ResponseCodeEnum.OPERATE_FAIL, "请检查分页参数!");
  762. }
  763. // 分页参数赋值
  764. param = this.getLimit(param);
  765. return super.mergeListWithCount(param, commonMapper.getMoneyAccount(param),
  766. commonMapper.getMoneyAccountCountByPage(param));
  767. }
  768. }