CaiWuTest.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
  1. /*
  2. * Copyright [2022] [https://www.baiduc.com]
  3. *
  4. * Snowy采用APACHE LICENSE 2.0开源协议,您在使用过程中,需要注意以下几点:
  5. *
  6. * 1.请不要删除和修改根目录下的LICENSE文件。
  7. * 2.请不要删除和修改Snowy源码头部的版权声明。
  8. * 3.本项目代码可免费商业使用,商业使用请保留源码和相关描述文件的项目出处,作者声明等。
  9. * 4.分发源码时候,请注明软件出处 https://www.baiduc.com
  10. * 5.不可二次分发开源参与同类竞品,如有想法可联系团队xiaonuobase@qq.com商议合作。
  11. * 6.若您的项目无法满足以上几点,需要更多功能代码,获取Snowy商业授权许可,请在官网购买授权,地址为 https://www.baiduc.com
  12. */
  13. package vip.xiaonuo;
  14. import cn.hutool.core.util.ObjectUtil;
  15. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  16. import org.junit.Test;
  17. import org.junit.runner.RunWith;
  18. import org.springframework.beans.factory.annotation.Autowired;
  19. import org.springframework.boot.test.context.SpringBootTest;
  20. import org.springframework.core.ParameterizedTypeReference;
  21. import org.springframework.http.HttpMethod;
  22. import org.springframework.http.ResponseEntity;
  23. import org.springframework.test.context.junit4.SpringRunner;
  24. import org.springframework.web.client.RestTemplate;
  25. import vip.xiaonuo.erp.entity.ErpBdOrg;
  26. import vip.xiaonuo.erp.entity.voucher.ChanPinShouRu;
  27. import vip.xiaonuo.erp.entity.voucher.ErpVoucher;
  28. import vip.xiaonuo.erp.entity.voucher.LinJinHuanKuanQi;
  29. import vip.xiaonuo.erp.entity.xiaoshou.*;
  30. import vip.xiaonuo.erp.mapper.ErpBdOrgMapper;
  31. import vip.xiaonuo.money.entity.MoneyBorrowWarning;
  32. import vip.xiaonuo.money.entity.MoneyBusiness;
  33. import vip.xiaonuo.money.entity.MoneyProduce;
  34. import vip.xiaonuo.money.entity.MoneyProduceIncome;
  35. import vip.xiaonuo.money.mapper.MoneyBorrowWarningMapper;
  36. import vip.xiaonuo.money.mapper.MoneyBusinessMapper;
  37. import vip.xiaonuo.money.mapper.MoneyProduceIncomeMapper;
  38. import vip.xiaonuo.money.mapper.MoneyProduceMapper;
  39. import vip.xiaonuo.sale.entity.*;
  40. import vip.xiaonuo.sale.mapper.*;
  41. import java.util.List;
  42. /**
  43. * 主测试类
  44. *
  45. * @author xuyuxiang
  46. * @date 2022/9/17 17:09
  47. */
  48. @RunWith(SpringRunner.class)
  49. @SpringBootTest(classes = Application.class)
  50. public class CaiWuTest {
  51. @Autowired
  52. private RestTemplate restTemplate;
  53. @Autowired
  54. private ErpBdOrgMapper erpBdOrgMapper;
  55. @Autowired
  56. private MoneyBusinessMapper businessMapper;
  57. @Autowired
  58. private MoneyBorrowWarningMapper borrowWarningMapper;
  59. @Autowired
  60. private MoneyProduceMapper produceMapper;
  61. @Autowired
  62. private MoneyProduceIncomeMapper produceIncomeMapper;
  63. @Test
  64. public void test1(){
  65. ResponseEntity<List<ErpVoucher>> response = restTemplate.exchange(
  66. "http://127.0.0.1:9200/erp-voucher/getShouRuJinE?date=",
  67. HttpMethod.GET,
  68. null,
  69. new ParameterizedTypeReference<List<ErpVoucher>>() {}
  70. );
  71. List<ErpVoucher> forObjects = response.getBody();
  72. System.out.println(forObjects);
  73. for (ErpVoucher forObject : forObjects) {
  74. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFacctorgid()));
  75. if (ObjectUtil.isEmpty(forgid))
  76. continue;
  77. MoneyBusiness moneyBusiness = new MoneyBusiness();
  78. moneyBusiness.setOrgId(forgid.getOrgId());
  79. moneyBusiness.setCreateTime(forObject.getFDATE());
  80. moneyBusiness.setBusinessIncome(String.format("%.2f",forObject.getFcredit()));
  81. businessMapper.insert(moneyBusiness);
  82. }
  83. }
  84. @Test
  85. public void test2(){
  86. ResponseEntity<List<LinJinHuanKuanQi>> response = restTemplate.exchange(
  87. "http://127.0.0.1:9200/erp-voucher/getLinJinHuanKuan?date=",
  88. HttpMethod.GET,
  89. null,
  90. new ParameterizedTypeReference<List<LinJinHuanKuanQi>>() {}
  91. );
  92. List<LinJinHuanKuanQi> forObjects = response.getBody();
  93. System.out.println(forObjects);
  94. for (LinJinHuanKuanQi forObject : forObjects) {
  95. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getForgid()));
  96. if (ObjectUtil.isEmpty(forgid))
  97. continue;
  98. MoneyBorrowWarning moneyBorrowWarning = new MoneyBorrowWarning();
  99. moneyBorrowWarning.setOrgId(forgid.getOrgId());
  100. moneyBorrowWarning.setBorrowTime(forObject.getFdate());
  101. moneyBorrowWarning.setBorrowPrice(String.format("%.2f",forObject.getFcredit()));
  102. moneyBorrowWarning.setMoneyType(forObject.getFname());
  103. moneyBorrowWarning.setCompany(forObject.getOrgName());
  104. borrowWarningMapper.insert(moneyBorrowWarning);
  105. }
  106. }
  107. @Test
  108. public void test3(){
  109. ResponseEntity<List<ErpVoucher>> response = restTemplate.exchange(
  110. "http://127.0.0.1:9200/erp-voucher/getDangQianYueYingYeE?date=",
  111. HttpMethod.GET,
  112. null,
  113. new ParameterizedTypeReference<List<ErpVoucher>>() {}
  114. );
  115. List<ErpVoucher> forObjects = response.getBody();
  116. System.out.println(forObjects);
  117. for (ErpVoucher forObject : forObjects) {
  118. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFacctorgid()));
  119. if (ObjectUtil.isEmpty(forgid))
  120. continue;
  121. MoneyBusiness moneyBusiness = new MoneyBusiness();
  122. moneyBusiness.setOrgId(forgid.getOrgId());
  123. moneyBusiness.setCreateTime(forObject.getFDATE());
  124. moneyBusiness.setBusinessCost(String.format("%.2f",forObject.getFcredit()));
  125. businessMapper.insert(moneyBusiness);
  126. }
  127. }
  128. @Test
  129. public void test4(){
  130. ResponseEntity<List<ErpVoucher>> response = restTemplate.exchange(
  131. "http://127.0.0.1:9200/erp-voucher/getDangQianYueJingLiRun?date=",
  132. HttpMethod.GET,
  133. null,
  134. new ParameterizedTypeReference<List<ErpVoucher>>() {}
  135. );
  136. List<ErpVoucher> forObjects = response.getBody();
  137. System.out.println(forObjects);
  138. for (ErpVoucher forObject : forObjects) {
  139. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFacctorgid()));
  140. if (ObjectUtil.isEmpty(forgid))
  141. continue;
  142. MoneyBusiness moneyBusiness = new MoneyBusiness();
  143. moneyBusiness.setOrgId(forgid.getOrgId());
  144. moneyBusiness.setCreateTime(forObject.getFDATE());
  145. moneyBusiness.setProfit(String.format("%.2f",forObject.getFcredit()));
  146. businessMapper.insert(moneyBusiness);
  147. }
  148. }
  149. @Test
  150. public void test5(){
  151. ResponseEntity<List<ErpVoucher>> response = restTemplate.exchange(
  152. "http://127.0.0.1:9200/erp-voucher/getDangQianZiJinYvE?date=",
  153. HttpMethod.GET,
  154. null,
  155. new ParameterizedTypeReference<List<ErpVoucher>>() {}
  156. );
  157. List<ErpVoucher> forObjects = response.getBody();
  158. System.out.println(forObjects);
  159. for (ErpVoucher forObject : forObjects) {
  160. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFacctorgid()));
  161. if (ObjectUtil.isEmpty(forgid))
  162. continue;
  163. MoneyBusiness moneyBusiness = new MoneyBusiness();
  164. moneyBusiness.setOrgId(forgid.getOrgId());
  165. moneyBusiness.setCreateTime(forObject.getFDATE());
  166. moneyBusiness.setBalance(String.format("%.2f",forObject.getFcredit()));
  167. businessMapper.insert(moneyBusiness);
  168. }
  169. }
  170. @Test
  171. public void test6(){
  172. ResponseEntity<List<ChanPinShouRu>> response = restTemplate.exchange(
  173. "http://127.0.0.1:9200/erp-voucher/getChanPinShouRu?date=",
  174. HttpMethod.GET,
  175. null,
  176. new ParameterizedTypeReference<List<ChanPinShouRu>>() {}
  177. );
  178. //'50万IU/G饲料添加剂VD3微粒','NF级胆固醇','饲料级胆固醇91%',
  179. // '25-羟基VD3原','4000万IU/G胆钙化醇',
  180. // '维生素D3原','蜡丸','100万IU/G复配营养强化剂MO','饲料级胆固醇80%','化妆品级羊毛醇'
  181. List<ChanPinShouRu> forObjects = response.getBody();
  182. for (ChanPinShouRu forObject : forObjects) {
  183. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFstockorgid()));
  184. if (ObjectUtil.isEmpty(forgid))
  185. continue;
  186. MoneyProduce moneyProduce = new MoneyProduce();
  187. moneyProduce.setOrgId(forgid.getOrgId());
  188. moneyProduce.setCreateTime(forObject.getFdate());
  189. MoneyProduceIncome moneyProduceIncome = new MoneyProduceIncome();
  190. moneyProduceIncome.setOrgId(forgid.getOrgId());
  191. moneyProduceIncome.setCreateTime(forObject.getFdate());
  192. if ("NF级胆固醇".equals(forObject.getFname())){
  193. moneyProduce.setNfCholesterol(String.format("%.2f",forObject.getFallamount()));
  194. moneyProduceIncome.setNfCholesterol(String.format("%.2f",forObject.getFallamount()));
  195. }else if ("饲料级胆固醇80".equals(forObject.getFname())||"饲料级胆固醇91".equals(forObject.getFname())){
  196. moneyProduce.setBreedCholesterol(String.format("%.2f",forObject.getFallamount()));
  197. moneyProduceIncome.setBreedCholesterol(String.format("%.2f",forObject.getFallamount()));
  198. }else if ("化妆品级羊毛醇".equals(forObject.getFname())){
  199. moneyProduce.setSheepAlcohol(String.format("%.2f",forObject.getFallamount()));
  200. moneyProduceIncome.setSheepAlcohol(String.format("%.2f",forObject.getFallamount()));
  201. }else {
  202. moneyProduce.setOther(String.format("%.2f",forObject.getFallamount()));
  203. moneyProduceIncome.setOther(String.format("%.2f",forObject.getFallamount()));
  204. }
  205. produceIncomeMapper.insert(moneyProduceIncome);
  206. produceMapper.insert(moneyProduce);
  207. }
  208. }
  209. @Test
  210. public void test7(){
  211. ResponseEntity<List<ErpVoucher>> response = restTemplate.exchange(
  212. "http://127.0.0.1:9200/erp-voucher/getGuoNeiWaiSouRu?date=",
  213. HttpMethod.GET,
  214. null,
  215. new ParameterizedTypeReference<List<ErpVoucher>>() {}
  216. );
  217. //'国内销售收入','国内销售收入2','国外销售收入'
  218. List<ErpVoucher> forObjects = response.getBody();
  219. for (ErpVoucher forObject : forObjects) {
  220. ErpBdOrg forgid = erpBdOrgMapper.selectOne(new QueryWrapper<ErpBdOrg>().eq("forgid", forObject.getFacctorgid()));
  221. if (ObjectUtil.isEmpty(forgid))
  222. continue;
  223. MoneyProduce moneyProduce = new MoneyProduce();
  224. moneyProduce.setOrgId(forgid.getOrgId());
  225. moneyProduce.setCreateTime(forObject.getFDATE());
  226. if ("国内销售收入".equals(forObject.getFNAME())||"国内销售收入2".equals(forObject.getFNAME())){
  227. moneyProduce.setInMoney(String.format("%.2f",forObject.getFcredit()));
  228. } else {
  229. moneyProduce.setOutMoney(String.format("%.2f",forObject.getFcredit()));
  230. }
  231. produceMapper.insert(moneyProduce);
  232. }
  233. }
  234. }