From 7d4ea219b3e69edec55d85211dd80ff4145e9089 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期五, 08 九月 2023 15:43:51 +0800
Subject: [PATCH] 代码生成
---
server/platform/src/main/java/com/doumee/api/business/BaseDataController.java | 6
server/service/src/main/java/com/doumee/dao/business/model/BaseData.java | 10 +
server/platform/src/main/java/com/doumee/task/ScheduleTool.java | 12 +
server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java | 249 ++++++++++++++++++++++++++++++++++++++++++++++++-
server/service/src/main/java/com/doumee/service/business/BaseDataService.java | 8 +
server/service/src/main/java/com/doumee/dao/business/model/Brand.java | 3
server/service/src/main/java/com/doumee/dao/business/model/BaseGoods.java | 3
7 files changed, 274 insertions(+), 17 deletions(-)
diff --git a/server/platform/src/main/java/com/doumee/api/business/BaseDataController.java b/server/platform/src/main/java/com/doumee/api/business/BaseDataController.java
index d52d1db..207f7a7 100644
--- a/server/platform/src/main/java/com/doumee/api/business/BaseDataController.java
+++ b/server/platform/src/main/java/com/doumee/api/business/BaseDataController.java
@@ -41,7 +41,7 @@
@ApiOperation("鏍规嵁ID鍒犻櫎")
@GetMapping("/delete/{id}")
@RequiresPermissions("business:basedata:delete")
- public ApiResponse deleteById(@PathVariable Integer id) {
+ public ApiResponse deleteById(@PathVariable String id) {
baseDataService.deleteById(id);
return ApiResponse.success(null);
}
@@ -51,9 +51,9 @@
@RequiresPermissions("business:basedata:delete")
public ApiResponse deleteByIdInBatch(@RequestParam String ids) {
String [] idArray = ids.split(",");
- List<Integer> idList = new ArrayList<>();
+ List<String> idList = new ArrayList<>();
for (String id : idArray) {
- idList.add(Integer.valueOf(id));
+ idList.add(id);
}
baseDataService.deleteByIdInBatch(idList);
return ApiResponse.success(null);
diff --git a/server/platform/src/main/java/com/doumee/task/ScheduleTool.java b/server/platform/src/main/java/com/doumee/task/ScheduleTool.java
index 9c105aa..531d666 100644
--- a/server/platform/src/main/java/com/doumee/task/ScheduleTool.java
+++ b/server/platform/src/main/java/com/doumee/task/ScheduleTool.java
@@ -1,6 +1,8 @@
package com.doumee.task;
+import com.doumee.service.business.BaseDataService;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.EnableScheduling;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
@@ -15,14 +17,16 @@
@EnableScheduling
public class ScheduleTool {
+ @Autowired
+ private BaseDataService baseDataService;
/**
- * 缂撳瓨鐪佸競鍖�
+ * 瀹氭椂澶勭悊鐖櫕婧愭暟鎹紝鐢熸垚绱犳潗搴撴暟鎹�
* @throws Exception
*/
- @Scheduled(fixedDelay=24*60*60*1000)
- public void cacheCampus() throws Exception {
-
+ @Scheduled(fixedDelay=10*60*1000)
+ public void dealBaseData() throws Exception {
+ baseDataService.dealBaseData();
}
}
diff --git a/server/service/src/main/java/com/doumee/dao/business/model/BaseData.java b/server/service/src/main/java/com/doumee/dao/business/model/BaseData.java
index 1e2cca7..5cf5b80 100644
--- a/server/service/src/main/java/com/doumee/dao/business/model/BaseData.java
+++ b/server/service/src/main/java/com/doumee/dao/business/model/BaseData.java
@@ -21,9 +21,9 @@
@TableName("`base_data`")
public class BaseData {
- @ApiModelProperty(value = "", example = "1")
+ @ApiModelProperty(value = "涓婚敭", example = "1")
@ExcelColumn(name="")
- private Integer id;
+ private String id;
@ApiModelProperty(value = "鍒涘缓浜虹紪鐮�", example = "1")
@ExcelColumn(name="鍒涘缓浜虹紪鐮�")
@@ -54,6 +54,12 @@
@ApiModelProperty(value = "鍟嗗搧鍚嶇О")
@ExcelColumn(name="鍟嗗搧鍚嶇О")
private String name;
+ @ApiModelProperty(value = "搴撳瓨鎯呭喌")
+ @ExcelColumn(name="搴撳瓨鎯呭喌")
+ private String haveStock;
+ @ApiModelProperty(value = "搴撳瓨鎯呭喌")
+ @ExcelColumn(name="搴撳瓨鎯呭喌")
+ private String categoryImg;
@ApiModelProperty(value = "浜笢sku")
@ExcelColumn(name="浜笢sku")
diff --git a/server/service/src/main/java/com/doumee/dao/business/model/BaseGoods.java b/server/service/src/main/java/com/doumee/dao/business/model/BaseGoods.java
index 29b5ed0..10892fc 100644
--- a/server/service/src/main/java/com/doumee/dao/business/model/BaseGoods.java
+++ b/server/service/src/main/java/com/doumee/dao/business/model/BaseGoods.java
@@ -95,5 +95,8 @@
@ApiModelProperty(value = "鍚嶇О鎷奸煶棣栧瓧姣�")
@ExcelColumn(name="鍚嶇О鎷奸煶棣栧瓧姣�")
private String shortPinyin;
+ @ApiModelProperty(value = "鍏宠仈婧愭暟鎹紪鐮�")
+ @ExcelColumn(name="鍏宠仈婧愭暟鎹紪鐮�")
+ private String baseDataId;
}
diff --git a/server/service/src/main/java/com/doumee/dao/business/model/Brand.java b/server/service/src/main/java/com/doumee/dao/business/model/Brand.java
index 7fbe0e1..d0c7b77 100644
--- a/server/service/src/main/java/com/doumee/dao/business/model/Brand.java
+++ b/server/service/src/main/java/com/doumee/dao/business/model/Brand.java
@@ -58,6 +58,9 @@
@ApiModelProperty(value = "浼佷笟缂栫爜")
@ExcelColumn(name="浼佷笟缂栫爜")
private Integer companyId;
+ @ApiModelProperty(value = "绫诲瀷 0浼佷笟 1骞冲彴")
+ @ExcelColumn(name="绫诲瀷 0浼佷笟 1骞冲彴")
+ private Integer type;
@ApiModelProperty(value = "鐘舵�� 0鍚敤 1绂佺敤", example = "1")
@ExcelColumn(name="鐘舵�� 0鍚敤 1绂佺敤")
private Integer status;
diff --git a/server/service/src/main/java/com/doumee/service/business/BaseDataService.java b/server/service/src/main/java/com/doumee/service/business/BaseDataService.java
index 634d4c3..ef5cce8 100644
--- a/server/service/src/main/java/com/doumee/service/business/BaseDataService.java
+++ b/server/service/src/main/java/com/doumee/service/business/BaseDataService.java
@@ -18,14 +18,14 @@
* @param baseData 瀹炰綋瀵硅薄
* @return Integer
*/
- Integer create(BaseData baseData);
+ String create(BaseData baseData);
/**
* 涓婚敭鍒犻櫎
*
* @param id 涓婚敭
*/
- void deleteById(Integer id);
+ void deleteById(String id);
/**
* 鍒犻櫎
@@ -39,7 +39,7 @@
*
* @param ids 涓婚敭闆�
*/
- void deleteByIdInBatch(List<Integer> ids);
+ void deleteByIdInBatch(List<String> ids);
/**
* 涓婚敭鏇存柊
@@ -94,4 +94,6 @@
* @return long
*/
long count(BaseData baseData);
+
+ void dealBaseData();
}
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java
index 1deda52..c0d4df7 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java
@@ -2,18 +2,24 @@
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.Constants;
+import com.doumee.core.utils.PinYinUtil;
import com.doumee.core.utils.Utils;
-import com.doumee.dao.business.BaseDataMapper;
-import com.doumee.dao.business.model.BaseData;
+import com.doumee.dao.business.*;
+import com.doumee.dao.business.model.*;
import com.doumee.service.business.BaseDataService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
+import java.lang.reflect.Field;
+import java.lang.reflect.Method;
+import java.util.Date;
import java.util.List;
/**
@@ -26,15 +32,25 @@
@Autowired
private BaseDataMapper baseDataMapper;
+ @Autowired
+ private BaseGoodsMapper baseGoodsMapper;
+ @Autowired
+ private BaseGoodsParamMapper baseGoodsParamMapper;
+ @Autowired
+ private BaseCategoryMapper baseCategoryMapper;
+ @Autowired
+ private BaseCateParamMapper baseCateParamMapper;
+ @Autowired
+ private BrandMapper brandMapper;
@Override
- public Integer create(BaseData baseData) {
+ public String create(BaseData baseData) {
baseDataMapper.insert(baseData);
return baseData.getId();
}
@Override
- public void deleteById(Integer id) {
+ public void deleteById(String id) {
baseDataMapper.deleteById(id);
}
@@ -45,7 +61,7 @@
}
@Override
- public void deleteByIdInBatch(List<Integer> ids) {
+ public void deleteByIdInBatch(List<String> ids) {
if (CollectionUtils.isEmpty(ids)) {
return;
}
@@ -265,4 +281,227 @@
QueryWrapper<BaseData> wrapper = new QueryWrapper<>(baseData);
return baseDataMapper.selectCount(wrapper);
}
+ public static boolean IS_RUNNING = false;
+ @Override
+ public void dealBaseData() {
+ if(IS_RUNNING){
+ return;
+ }
+ IS_RUNNING = true;
+
+ try {
+ BaseData param = new BaseData();
+ param.setStatus(Constants.ZERO);
+ List<BaseData> allLis=findList(param);
+ if(allLis==null || allLis.size() ==0){
+ return ;
+ }
+ Brand brand = new Brand();
+ brand.setIsdeleted(Constants.ZERO);
+ brand.setType(Constants.ONE);
+ //鏌ヨ鍏ㄩ儴鍝佺墝淇℃伅
+ List<Brand> brandList = brandMapper.selectList(new QueryWrapper<>(brand));
+
+ BaseCategory cate = new BaseCategory();
+ cate.setIsdeleted(Constants.ZERO);
+ //鏌ヨ鍏ㄩ儴绫诲埆淇℃伅
+ List<BaseCategory> cateList = baseCategoryMapper.selectList(new QueryWrapper<>(cate));
+ BaseCateParam p = new BaseCateParam();
+ p.setIsdeleted(Constants.ZERO);
+ //鏌ヨ鍏ㄩ儴绫诲埆灞炴�т俊鎭�
+ List<BaseCateParam> paramList = baseCateParamMapper.selectList(new QueryWrapper<>(p));
+ Date date = new Date();
+ for(BaseData data : allLis){
+ BaseGoods goods = new BaseGoods();
+ goods.setBaseDataId(data.getId());
+ goods.setIsdeleted(Constants.ZERO);
+ goods.setCreateDate(date);
+ goods.setName(StringUtils.defaultString(data.getName(),data.getTitle()));
+ goods.setRemark(data.getTitle());
+ goods.setContent(data.getTitle());
+ goods.setStatus(Constants.ZERO);
+ goods.setShortPinyin(PinYinUtil.getFirstSpell(goods.getName()));
+ goods.setPinyin(PinYinUtil.getFullSpell(goods.getName()));
+ goods.setPrice(data.getSaleprice());
+ goods.setZdPrice(data.getPrice());
+ //澶勭悊鍝佺墝鏁版嵁
+ Brand bModel = getBrandModelFromList(data.getBrand(),brandList);
+ if(bModel!= null){
+ goods.setBrandId(bModel.getId());
+ }
+ //澶勭悊鍒楄〃鏁版嵁
+ BaseCategory cModel = getCateModelFromList(data.getBrand(),data.getCategoryImg(), cateList);
+ if(bModel!= null){
+ goods.setBrandId(bModel.getId());
+ }
+
+ //鎻掑叆鏂板晢鍝佹暟鎹�
+ baseGoodsMapper.insert(goods);
+ //澶勭悊鍒嗙被灞炴��
+ dealCateParamAll(cModel.getId(),goods.getId(),data,paramList);
+ data.setEditDate(new Date());
+ data.setStatus(Constants.ONE);
+ //鏇存柊鏁版嵁澶勭悊鐘舵��
+ baseDataMapper.updateById(data);
+ }
+ }catch (Exception e){
+
+ }finally {
+ IS_RUNNING = false;
+ }
+
+ }
+
+
+ private void dealCateParamAll(Integer cateId,Integer goodsId, BaseData data ,List<BaseCateParam> cateList) {
+ Method[] fields = data.getClass().getMethods(); // 鑾峰彇瀵硅薄鐨勬墍鏈夊睘鎬�
+ for (Method item : fields) {
+ String name = item.getName();
+ if(name.indexOf("getAttr") == 0){
+ try {
+ String val =(String) item.invoke(data);
+ dealCateParam(cateId,goodsId,val.toString(),cateList);
+ } catch (Exception e) {
+ throw new RuntimeException(e);
+ }
+ }
+ }
+
+// dealCateParam(cateId,goodsId,data.getAttr1(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr2(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr3(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr4(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr5(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr6(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr7(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr8(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr9(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr10(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr11(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr12(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr13(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr14(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr15(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr16(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr17(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr18(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr19(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr20(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr21(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr22(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr23(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr24(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr25(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr26(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr27(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr28(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr29(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr30(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr31(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr32(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr33(),cateList);
+// dealCateParam(cateId,goodsId,data.getAttr34(),cateList);
+ }
+
+ private void dealCateParam(Integer cateId, Integer goodsId, String attr,List<BaseCateParam> list) {
+ if(StringUtils.isBlank(attr)){
+ return;
+ }
+ //濡傛灉灞炴�т笉涓虹┖锛屽鐞嗗睘鎬ф暟鎹�
+ int index = attr.indexOf("锛�");
+ if(index <=0){
+ return;
+ }
+ String attrName = attr.substring(0,index);
+ String val = attr.substring(index+1);
+ BaseCateParam cate = getCateParamModelFromList(cateId,attrName, list);
+ BaseGoodsParam p = new BaseGoodsParam();
+ p.setName(attrName);
+ p.setPramaId(cate.getId());
+ p.setIsdeleted(Constants.ZERO);
+ p.setStatus(Constants.ZERO);
+ p.setVal(val);
+ p.setCreateDate(new Date());
+ p.setGoodsId(goodsId);
+ baseGoodsParamMapper.insert(p);
+ }
+
+ /**
+ * 鏍规嵁鍝佺被缂栫爜鍜屽弬鏁板悕绉版煡璇㈠弬鏁板璞★紝娌℃湁鍒欐彃鍏ユ柊鐨�
+ * @param list
+ * @return
+ */
+
+ private BaseCateParam getCateParamModelFromList(Integer id,String name, List<BaseCateParam> list) {
+ if(list!=null && list.size()>0){
+ for(BaseCateParam p : list){
+ if(Constants.equalsInteger(id,p.getCategoryId()) && StringUtils.equals(name,p.getName())){
+ return p;
+ }
+ }
+ }
+ BaseCateParam model = new BaseCateParam();
+ model.setCreateDate(new Date());
+ model.setName(name);
+ model.setIsdeleted(Constants.ZERO);
+ model.setCategoryId(id);
+ //鎻掑叆鏂扮殑鍝佺墝淇℃伅
+ baseCateParamMapper.insert(model);
+ //鍔犲叆闆嗗悎涓�
+ list.add(model);
+ return model;
+ }
+ /**
+ * 鏍规嵁鍝佺墝鍚嶇О鏌ヨ鍝佺墝瀵硅薄锛屾病鏈夊垯鎻掑叆鏂扮殑
+ * @param name
+ * @param brandList
+ * @return
+ */
+
+ private Brand getBrandModelFromList(String name, List<Brand> brandList) {
+ if(brandList!=null && brandList.size()>0){
+ for(Brand brand : brandList){
+ if(StringUtils.equals(name,brand.getName())){
+ return brand;
+ }
+ }
+ }
+ Brand model = new Brand();
+ model.setType(Constants.ONE);
+ model.setCreateDate(new Date());
+ model.setName(name);
+ model.setIsdeleted(Constants.ZERO);
+ model.setImgurl(null);
+ //鎻掑叆鏂扮殑鍝佺墝淇℃伅
+ brandMapper.insert(model);
+ //鍔犲叆闆嗗悎涓�
+ brandList.add(model);
+ return model;
+ }
+ /**
+ * 鏍规嵁鍚嶇О鏌ヨ鍒嗙被瀵硅薄锛屾病鏈夊垯鎻掑叆鏂扮殑
+ * @param name
+ * @param list
+ * @return
+ */
+
+ private BaseCategory getCateModelFromList(String name, String img,List<BaseCategory> list) {
+ if(list!=null && list.size()>0){
+ for(BaseCategory p : list){
+ if(StringUtils.equals(name,p.getName())){
+ return p;
+ }
+ }
+ }
+ BaseCategory model = new BaseCategory();
+ model.setCreateDate(new Date());
+ model.setName(name);
+ model.setIsdeleted(Constants.ZERO);
+ model.setImgurl(img);
+ //鎻掑叆鏂扮殑鍝佺墝淇℃伅
+ baseCategoryMapper.insert(model);
+ //鍔犲叆闆嗗悎涓�
+ list.add(model);
+ return model;
+ }
}
--
Gitblit v1.9.3