crm_pull.java 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. package common.crm;
  2. import com.alibaba.fastjson.JSONObject;
  3. import common.BaseClass;
  4. import common.YosException;
  5. import common.YosLogger;
  6. import common.crm.bean.item;
  7. import common.crm.bean.sku;
  8. import common.crm.bean.warrantycard;
  9. import common.data.QuerySQL;
  10. import common.data.Row;
  11. import common.data.SQLFactory;
  12. import common.data.db.QueryCallBack;
  13. import jakarta.servlet.http.HttpServletRequest;
  14. import jakarta.servlet.http.HttpServletResponse;
  15. import org.springframework.stereotype.Controller;
  16. import org.springframework.web.bind.annotation.GetMapping;
  17. import org.springframework.web.bind.annotation.RequestMapping;
  18. import org.springframework.web.bind.annotation.RequestParam;
  19. import org.springframework.web.bind.annotation.ResponseBody;
  20. @Controller
  21. @RequestMapping("/rest/pull")
  22. public class crm_pull extends BaseClass {
  23. @GetMapping("/pullMachinecodes")
  24. @ResponseBody
  25. public String pullMachinecodes(HttpServletRequest request, HttpServletResponse response, @RequestParam("fmachinecodes") String[] fmachinecodes, @RequestParam("token") String token) {
  26. runTask("CRM请求同步序列号", () -> {
  27. sku sku = new sku(YosLogger.logger);
  28. for (String fmachinecode : fmachinecodes) {
  29. if (!fmachinecode.isEmpty()) {
  30. sku.oneAction(fmachinecode);
  31. }
  32. }
  33. });
  34. return getSuccessResult().toString();
  35. }
  36. @GetMapping("/pullAnyProducts")
  37. @ResponseBody
  38. public String pullAnyProducts(HttpServletRequest request, HttpServletResponse response, @RequestParam("fprodNums") String[] fprodNums, @RequestParam("isAllFields") String isAllFields, @RequestParam("token") String token) {
  39. runTask("CRM请求同步商品档案", () -> {
  40. item item = new item(YosLogger.logger);
  41. for (String fprodNum : fprodNums) {
  42. if (!fprodNum.isEmpty()) {
  43. item.oneAction(fprodNum, isAllFields.equals("true"));
  44. }
  45. }
  46. });
  47. return getSuccessResult().toString();
  48. }
  49. @GetMapping("/pullWarrantycards")
  50. @ResponseBody
  51. public String pullWarrantycards(HttpServletRequest request, HttpServletResponse response, @RequestParam("fcustomnum") String fcustomnum, @RequestParam("fmachinecodes") String[] fmachinecodes, @RequestParam("token") String token) {
  52. runTask("CRM请求同步客户保修卡", () -> {
  53. try {
  54. warrantycard warrantycard = new warrantycard(YosLogger.logger);
  55. QuerySQL querySQL = SQLFactory.createQuerySQL(dbConnect, "sa_warrantycard", "cardno");
  56. querySQL.setSiteid("MD").setWhere("sku", fmachinecodes);
  57. querySQL.query(new QueryCallBack() {
  58. @Override
  59. public void onRowLoaded(long rowindex, Row row) throws YosException {
  60. warrantycard.oneAction(row.getString("cardno"));
  61. }
  62. });
  63. } catch (Exception e) {
  64. e.printStackTrace();
  65. }
  66. });
  67. return getSuccessResult().toString();
  68. }
  69. public JSONObject getSuccessResult() {
  70. JSONObject object = new JSONObject();
  71. object.put("code", 1);
  72. object.put("msg", "");
  73. object.put("data", "");
  74. object.put("uri", "");
  75. return object;
  76. }
  77. }