From c0b565cf340fb38d4cf62b920cadbd9b6f992641 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期五, 13 十月 2023 17:26:35 +0800
Subject: [PATCH] 开发
---
server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java | 255 +++++++++++++++++++++++++++-----------------------
1 files changed, 138 insertions(+), 117 deletions(-)
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 78f36fe..7a8c622 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
@@ -30,6 +30,7 @@
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.math.BigDecimal;
+import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.UUID;
@@ -60,6 +61,8 @@
private BaseCateParamMapper baseCateParamMapper;
@Autowired
private BrandMapper brandMapper;
+ @Autowired
+ private FileRecordMapper fileRecordMapper;
@Override
public String create(BaseData baseData) {
@@ -297,7 +300,7 @@
for(BaseData data :result.getRecords()){
//澶氬浘锛岃嫳鏂囬�楀彿闅斿紑
if(StringUtils.isNotBlank(data.getBgImg())){
- String tImg = data.getBgImg().replace("锛�", ",").replace(".avif", "");
+ String tImg = data.getBgImg().replace("锛�", ",").replace(".avif", "").replace("/n1/jfs/", "/imgzone/jfs/");
String[] imgs =tImg.split(",");
data.setBgImgs(imgs);
@@ -315,7 +318,8 @@
public static boolean IS_RUNNING = false;
@Override
@Async
- public void dealBaseData() {
+ @Transactional
+ public synchronized void dealBaseData() {
if(IS_RUNNING){
return;
}
@@ -349,87 +353,97 @@
BigDecimal rate = systemDictDataBiz.getGoodsPriceRate();
OssModel ossModel = initOssModel();
Date date = new Date();
+ List<BaseCateParam> baseCateParamList = new ArrayList<>();
+ List<Multifile> fileList = new ArrayList<>();
+ List<Integer> goodsIdList = new ArrayList<>();
+ List<FileRecord> fileRecords = new ArrayList<>();
+ List<BaseGoodsParam> baseGoodsParamList = new ArrayList<>();
for(BaseData data : allLis){
- dealPerData(ossModel,rate,date,data,cateList,brandList,paramList);
+ BaseGoods goods = new BaseGoods();
+ goods.setBaseDataId(data.getId());
+ goods.setIsdeleted(Constants.ZERO);
+ //鏌ヨ鏄惁瀛樺湪鍟嗗搧
+ BaseGoods model = baseGoodsMapper.selectOne(new QueryWrapper<>(goods).last(" limit 1"));
+ goods.setName(StringUtils.defaultString(data.getName(),data.getTitle()));
+ goods.setRemark(data.getTitle());
+ goods.setContent(data.getTitle());
+ goods.setStatus(Constants.ZERO);
+ goods.setOrigin(Constants.BasegoodsOrigin.basedata);
+ goods.setShortPinyin(PinYinUtil.getFirstSpell(goods.getName()));
+ goods.setPinyin(PinYinUtil.getFullSpell(goods.getName()));
+ goods.setZdPrice(data.getPrice());
+ //澶勭悊鍝佺墝鏁版嵁
+ Brand bModel = getBrandModelFromList(data.getBrand(),brandList);
+ if(bModel!= null){
+ goods.setBrandId(bModel.getId());
+ }
+ //澶勭悊鍒楄〃鏁版嵁
+ BaseCategory cModel = getCateModelFromList(rate,data.getCategory(),ossModel,data.getCategoryImg(), cateList,fileRecords);
+ if(cModel!= null){
+ goods.setCategoryId(cModel.getId());
+ }
+// goods.setImgurl(getOssImgurl(ossModel,ossModel.getGoodsFolder(), data.getImgurl()));
+ goods.setImgurl(getOssImgurlFile(ossModel.getGoodsFolder(), data.getImgurl(), data.getId(),Constants.ZERO,fileRecords));
+// goods.setPrice(Constants.formatBigdecimal(data.getSaleprice()).multiply(Constants.formatBigdecimal(cModel.getPriceRate())));
+ goods.setPrice(Constants.formatBigdecimal(data.getSaleprice()));
+ if(model!=null){
+ //濡傛灉宸茬粡瀛樺湪锛屾洿鏂板晢鍝佹暟鎹�
+ goods.setEditDate(date);
+ goods.setId(model.getId());
+ baseGoodsMapper.updateById(goods);
+ goodsIdList.add(goods.getId());
+ }else{
+ //鎻掑叆鏂板晢鍝佹暟鎹�
+ goods.setCreateDate(date);
+ baseGoodsMapper.insert(goods);
+ }
+ //澶勭悊鍒嗙被灞炴��
+ dealCateParamAll(cModel.getId(),goods.getId(),data,paramList, baseGoodsParamList );
+ //澶勭悊鑳屾櫙鍥�
+ dealBgImgAll(ossModel,goods.getId(),data,fileList,fileRecords);
+ data.setEditDate(new Date());
+ data.setStatus(Constants.ONE);
+ //鏇存柊鏁版嵁澶勭悊鐘舵��
+ baseDataMapper.updateById(data);
+ }
+ if(goodsIdList.size()>0){
+ //鍒犻櫎鍘熸湁闄勪欢澶у浘
+ UpdateWrapper<Multifile> updateModel = new UpdateWrapper<>();
+ updateModel.lambda().set(Multifile::getIsdeleted,Constants.ONE);
+ updateModel.lambda().set(Multifile::getEditDate, new Date());
+ updateModel.lambda().in(Multifile::getObjId, goodsIdList);
+ updateModel.lambda().eq(Multifile::getObjType, Constants.ONE);
+ multifileMapper.delete(updateModel);
+ //鍒犻櫎鍘熸湁鍟嗗搧灞炴��
+ UpdateWrapper<BaseGoodsParam> bgModel = new UpdateWrapper<>();
+ bgModel.lambda().set(BaseGoodsParam::getIsdeleted,Constants.ONE);
+ bgModel.lambda().set(BaseGoodsParam::getEditDate, new Date());
+ bgModel.lambda().in(BaseGoodsParam::getGoodsId, goodsIdList);
+ baseGoodsParamMapper.delete(bgModel);
+ }
+
+ if(fileList.size()>0){
+ multifileMapper.insertBatch(fileList);
+ }
+ if(baseGoodsParamList.size()>0){
+ baseGoodsParamMapper.insertBatch(baseGoodsParamList);
+ }
+ if(fileRecords.size()>0){
+ fileRecordMapper.insertBatch(fileRecords);
}
log.info("寮�濮嬪鐞嗘簮鏁版嵁=================success================澶勭悊鏁版嵁鍏憋紙"+allLis.size()+"锛変釜===");
}catch (Exception e){
e.printStackTrace();
log.info("寮�濮嬪鐞嗘簮鏁版嵁=================error==================="+e.getMessage());
+ throw e;
}finally {
IS_RUNNING = false;
log.info("寮�濮嬪鐞嗘簮鏁版嵁=================end===================");
}
}
- @Transactional(isolation = Isolation.READ_UNCOMMITTED)
- private void dealPerData(OssModel ossModel, BigDecimal rate, Date date, BaseData data, List<BaseCategory> cateList, List<Brand> brandList, List<BaseCateParam> paramList) {
- BaseGoods goods = new BaseGoods();
- goods.setBaseDataId(data.getId());
- goods.setIsdeleted(Constants.ZERO);
- //鏌ヨ鏄惁瀛樺湪鍟嗗搧
- BaseGoods model = baseGoodsMapper.selectOne(new QueryWrapper<>(goods).last(" limit 1"));
- goods.setName(StringUtils.defaultString(data.getName(),data.getTitle()));
- goods.setRemark(data.getTitle());
- goods.setContent(data.getTitle());
- goods.setStatus(Constants.ZERO);
- goods.setOrigin(Constants.BasegoodsOrigin.basedata);
- goods.setShortPinyin(PinYinUtil.getFirstSpell(goods.getName()));
- goods.setPinyin(PinYinUtil.getFullSpell(goods.getName()));
- goods.setZdPrice(data.getPrice());
- //澶勭悊鍝佺墝鏁版嵁
- Brand bModel = getBrandModelFromList(data.getBrand(),brandList);
- if(bModel!= null){
- goods.setBrandId(bModel.getId());
- }
- //澶勭悊鍒楄〃鏁版嵁
- BaseCategory cModel = getCateModelFromList(rate,data.getCategory(),ossModel,data.getCategoryImg(), cateList);
- if(cModel!= null){
- goods.setCategoryId(cModel.getId());
- }
- goods.setImgurl(getOssImgurl(ossModel,ossModel.getGoodsFolder(), data.getImgurl()));
- goods.setPrice(Constants.formatBigdecimal(data.getSaleprice()).multiply(Constants.formatBigdecimal(cModel.getPriceRate())));
- if(model!=null){
- //濡傛灉宸茬粡瀛樺湪锛岄�昏緫鍒犻櫎鏃х殑鍟嗗搧鏁版嵁
-// UpdateWrapper<BaseGoods> updateModel = new UpdateWrapper<>();
-// updateModel.lambda().set(BaseGoods::getIsdeleted,Constants.ONE);
-// updateModel.lambda().set(BaseGoods::getEditDate, new Date());
-// updateModel.lambda().eq(BaseGoods::getBaseDataId, data.getId());
-// baseGoodsMapper.update(null, updateModel);
- goods.setEditDate(date);
- goods.setId(model.getId());
- baseGoodsMapper.updateById(goods);
- //鍒犻櫎鍘熸湁闄勪欢澶у浘
- UpdateWrapper<Multifile> updateModel = new UpdateWrapper<>();
- updateModel.lambda().set(Multifile::getIsdeleted,Constants.ONE);
- updateModel.lambda().set(Multifile::getEditDate, new Date());
- updateModel.lambda().eq(Multifile::getObjId, goods.getId());
- updateModel.lambda().eq(Multifile::getObjType, Constants.ZERO);
- multifileMapper.delete(updateModel);
- //鍒犻櫎鍘熸湁鍟嗗搧灞炴��
- UpdateWrapper<BaseGoodsParam> bgModel = new UpdateWrapper<>();
- bgModel.lambda().set(BaseGoodsParam::getIsdeleted,Constants.ONE);
- bgModel.lambda().set(BaseGoodsParam::getEditDate, new Date());
- bgModel.lambda().eq(BaseGoodsParam::getGoodsId, goods.getId());
- baseGoodsParamMapper.delete(bgModel);
- }else{
- //鎻掑叆鏂板晢鍝佹暟鎹�
- goods.setCreateDate(date);
- baseGoodsMapper.insert(goods);
- }
- //澶勭悊鍒嗙被灞炴��
- dealCateParamAll(cModel.getId(),goods.getId(),data,paramList);
- //澶勭悊鑳屾櫙鍥�
- dealBgImgAll(ossModel,goods.getId(),data);
- data.setEditDate(new Date());
- data.setStatus(Constants.ONE);
- //鏇存柊鏁版嵁澶勭悊鐘舵��
- baseDataMapper.updateById(data);
- }
-
-
- private void dealBgImgAll(OssModel ossModel, Integer id, BaseData data) {
+ private void dealBgImgAll(OssModel ossModel, Integer id, BaseData data,List<Multifile> fileList,List<FileRecord> fileRecords) {
int i =0;
//澶氬浘锛岃嫳鏂囬�楀彿闅斿紑
if(StringUtils.isNotBlank(data.getBgImg())){
@@ -437,7 +451,7 @@
String[] imgs =tImg.split(",");
for (int j = 0; j < imgs.length; j++) {
if(StringUtils.isNotBlank(imgs[j])){
- i += addImg(i,ossModel,id,imgs[j]);
+ i += addImg(i,ossModel,id,imgs[j],fileList,fileRecords);
}
}
}
@@ -446,20 +460,24 @@
// addImg(i,ossModel,id,data.getBgImg3());
}
- private int addImg(int i,OssModel ossModel, Integer id,String bgImg) {
+ private int addImg(int i,OssModel ossModel, Integer id,String bgImg,List<Multifile> fileList,List<FileRecord> fileRecords) {
if(StringUtils.isNotBlank(bgImg)){
- String img =getOssImgurl(ossModel, ossModel.getGoodsFolder() ,bgImg);
+ bgImg = bgImg.replace("/n1/jfs/", "/imgzone/jfs/");
+// String img =getOssImgurl(ossModel, ossModel.getGoodsFolder() ,bgImg);
+ String img = getOssImgurlFile(ossModel.getGoodsFolder(), bgImg, null,Constants.TWO,fileRecords);
if(StringUtils.isNotBlank(img)){
+
Multifile f = new Multifile();
f.setFileurl(img);
- f.setObjType(Constants.ZERO);
+ f.setObjType(Constants.ONE);
f.setName(bgImg.substring(bgImg.lastIndexOf("/")+1));
f.setType(Constants.ZERO);
f.setObjId(id);
f.setCreateDate(new Date());
f.setIsdeleted(Constants.ZERO);
f.setSortnum(i);
- multifileMapper.insert(f);
+ fileList.add(f);
+// multifileMapper.insert(f);
return 1;
}
}
@@ -480,57 +498,23 @@
}
- private void dealCateParamAll(Integer cateId,Integer goodsId, BaseData data ,List<BaseCateParam> cateList) {
+ private void dealCateParamAll(Integer cateId,Integer goodsId, BaseData data ,List<BaseCateParam> cateList,List<BaseGoodsParam> paramList) {
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);
+ dealCateParam(cateId,goodsId,val.toString(),cateList,paramList);
} 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) {
+ private void dealCateParam(Integer cateId, Integer goodsId, String attr,List<BaseCateParam> list,List<BaseGoodsParam> paramList) {
if(StringUtils.isBlank(attr)){
return;
}
@@ -541,7 +525,10 @@
return;
}
String attrName = attr.substring(0,index);
- if(StringUtils.isBlank(attrName) || StringUtils.equals(attrName, "鍟嗗搧鍚嶇О") || StringUtils.equals(attrName, "鍟嗗搧缂栧彿")){
+ if(StringUtils.isBlank(attrName)
+ || StringUtils.equals(attrName, "鍟嗗搧鍚嶇О")
+ || StringUtils.equals(attrName, "鍟嗗搧缂栧彿")
+ || StringUtils.equals(attrName, "搴楅摵")){
return;
}
String val = attr.substring(index+1);
@@ -554,7 +541,8 @@
p.setVal(val);
p.setCreateDate(new Date());
p.setGoodsId(goodsId);
- baseGoodsParamMapper.insert(p);
+ paramList.add(p);
+// baseGoodsParamMapper.insert(p);
}
/**
@@ -619,7 +607,7 @@
* @return
*/
- private BaseCategory getCateModelFromList(BigDecimal dRate,String name, OssModel ossModel, String img, List<BaseCategory> list) {
+ private BaseCategory getCateModelFromList(BigDecimal dRate,String name, OssModel ossModel, String img, List<BaseCategory> list, List<FileRecord> fileRecords) {
if(StringUtils.isBlank(name)){
return null;
}
@@ -637,7 +625,8 @@
model.setIsdeleted(Constants.ZERO);
model.setPinyin(PinYinUtil.getFullSpell(model.getName()));
model.setShortPinyin(PinYinUtil.getFirstSpell(model.getName()));
- model.setImgurl(getOssImgurl(ossModel, ossModel.getCateFolder() ,img));
+// model.setImgurl(getOssImgurl(ossModel, ossModel.getCateFolder() ,img));
+ model.setImgurl(getOssImgurlFile(ossModel.getCateFolder(), img, null,Constants.ONE,fileRecords));
//鎻掑叆鏂扮殑鍝佺墝淇℃伅
baseCategoryMapper.insert(model);
//鍔犲叆闆嗗悎涓�
@@ -646,7 +635,7 @@
}
@Override
- public String getOssImgurl(OssModel ossModel, String folder,String img) {
+ public String getOssImgurl(OssModel ossModel, String folder,String img ) {
if(StringUtils.isBlank(img)){
return null;
}
@@ -658,6 +647,7 @@
String tempFileName = nowDate + "/" + fileName;
String key =folder+ tempFileName;// 鏂囦欢鍚�
+
ALiYunUtil obs = new ALiYunUtil(ossModel.getEndpoint(), ossModel.getAccessId(), ossModel.getAccessKey());
if (obs.uploadOnlineObject(img,ossModel.getBucket(), key,null)) {
return tempFileName;
@@ -667,6 +657,37 @@
}
return null;
}
+ public String getOssImgurlFile(String folder,String img ,String id,Integer objType,List<FileRecord> fileRecords) {
+ if(StringUtils.isBlank(img)){
+ return null;
+ }
+ try {
+ String nowDate = DateUtil.getNowShortDate();// 褰撳墠鏃堕棿锛堝勾鏈堟棩锛�
+ String nfix = img.lastIndexOf(".")>0?img.substring(img.lastIndexOf(".")):null;
+ nfix = StringUtils.defaultString(nfix,".jpg");
+ String fileName = UUID.randomUUID() + nfix;
+ String tempFileName = nowDate + "/" + fileName;
+ String key =folder+ tempFileName;// 鏂囦欢鍚�
+
+ FileRecord model = new FileRecord();
+ model.setIsdeleted(Constants.ZERO);
+ model.setCreateDate(new Date());
+ model.setName(tempFileName);
+ model.setInfo(null);
+ model.setFolder(folder);
+ model.setUrl(img);
+ model.setObjId(id);
+ model.setType(objType);
+ model.setStatus(Constants.ZERO);
+ model.setKeyval(key);
+ fileRecords.add(model);
+
+ return tempFileName;
+ }catch (Exception e){
+
+ }
+ return null;
+ }
@Override
public String getOssImgurl(OssModel ossModel, String folder, File f) {
--
Gitblit v1.9.3