From 6fcaaff0895c06bdbad8310559676528840394cf Mon Sep 17 00:00:00 2001
From: jiaosong <jiaosong6760@dingtalk.com>
Date: 星期二, 19 九月 2023 15:31:33 +0800
Subject: [PATCH] #联调修改
---
server/service/src/main/java/com/doumee/service/business/impl/BaseDataServiceImpl.java | 239 +++++++++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 191 insertions(+), 48 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 bacf9a0..78f36fe 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
@@ -16,14 +16,20 @@
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Lazy;
+import org.springframework.scheduling.annotation.Async;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Isolation;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
+import java.io.File;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
+import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import java.util.UUID;
@@ -34,10 +40,13 @@
* @date 2023/09/08 11:39
*/
@Service
+@Slf4j
public class BaseDataServiceImpl implements BaseDataService {
@Autowired
private BaseDataMapper baseDataMapper;
+ @Autowired
+ private MultifileMapper multifileMapper;
@Autowired
@Lazy
private SystemDictDataBiz systemDictDataBiz;
@@ -111,6 +120,7 @@
@Override
public PageData<BaseData> findPage(PageWrap<BaseData> pageWrap) {
+ pageWrap.getModel().setIsdeleted(Constants.ZERO);
IPage<BaseData> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
QueryWrapper<BaseData> queryWrapper = new QueryWrapper<>();
Utils.MP.blankToNull(pageWrap.getModel());
@@ -135,19 +145,19 @@
queryWrapper.lambda().eq(BaseData::getIsdeleted, pageWrap.getModel().getIsdeleted());
}
if (pageWrap.getModel().getTitle() != null) {
- queryWrapper.lambda().eq(BaseData::getTitle, pageWrap.getModel().getTitle());
+ queryWrapper.lambda().like(BaseData::getTitle, pageWrap.getModel().getTitle());
}
if (pageWrap.getModel().getName() != null) {
- queryWrapper.lambda().eq(BaseData::getName, pageWrap.getModel().getName());
+ queryWrapper.lambda().like(BaseData::getName, pageWrap.getModel().getName());
}
if (pageWrap.getModel().getSku() != null) {
- queryWrapper.lambda().eq(BaseData::getSku, pageWrap.getModel().getSku());
+ queryWrapper.lambda().like(BaseData::getSku, pageWrap.getModel().getSku());
}
if (pageWrap.getModel().getBrand() != null) {
- queryWrapper.lambda().eq(BaseData::getBrand, pageWrap.getModel().getBrand());
+ queryWrapper.lambda().like(BaseData::getBrand, pageWrap.getModel().getBrand());
}
if (pageWrap.getModel().getCategory() != null) {
- queryWrapper.lambda().eq(BaseData::getCategory, pageWrap.getModel().getCategory());
+ queryWrapper.lambda().like(BaseData::getCategory, pageWrap.getModel().getCategory());
}
if (pageWrap.getModel().getUrl() != null) {
queryWrapper.lambda().eq(BaseData::getUrl, pageWrap.getModel().getUrl());
@@ -282,7 +292,19 @@
queryWrapper.orderByAsc(sortData.getProperty());
}
}
- return PageData.from(baseDataMapper.selectPage(page, queryWrapper));
+ IPage<BaseData> result =baseDataMapper.selectPage(page, queryWrapper);
+ if(result!=null && result.getRecords()!=null){
+ for(BaseData data :result.getRecords()){
+ //澶氬浘锛岃嫳鏂囬�楀彿闅斿紑
+ if(StringUtils.isNotBlank(data.getBgImg())){
+ String tImg = data.getBgImg().replace("锛�", ",").replace(".avif", "");
+ String[] imgs =tImg.split(",");
+ data.setBgImgs(imgs);
+
+ }
+ }
+ }
+ return PageData.from(result);
}
@Override
@@ -292,10 +314,12 @@
}
public static boolean IS_RUNNING = false;
@Override
+ @Async
public void dealBaseData() {
if(IS_RUNNING){
return;
}
+ log.info("寮�濮嬪鐞嗘簮鏁版嵁=================start===================");
IS_RUNNING = true;
try {
@@ -303,6 +327,8 @@
param.setStatus(Constants.ZERO);
List<BaseData> allLis=findList(param);
if(allLis==null || allLis.size() ==0){
+
+ log.info("寮�濮嬪鐞嗘簮鏁版嵁=================end========鏃犲緟澶勭悊鏁版嵁===========");
return ;
}
Brand brand = new Brand();
@@ -319,51 +345,129 @@
p.setIsdeleted(Constants.ZERO);
//鏌ヨ鍏ㄩ儴绫诲埆灞炴�т俊鎭�
List<BaseCateParam> paramList = baseCateParamMapper.selectList(new QueryWrapper<>(p));
-
+ //榛樿獚鍔犱环绯绘暟
+ BigDecimal rate = systemDictDataBiz.getGoodsPriceRate();
OssModel ossModel = initOssModel();
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(),ossModel,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);
+ dealPerData(ossModel,rate,date,data,cateList,brandList,paramList);
}
+ log.info("寮�濮嬪鐞嗘簮鏁版嵁=================success================澶勭悊鏁版嵁鍏憋紙"+allLis.size()+"锛変釜===");
}catch (Exception e){
-
+ e.printStackTrace();
+ log.info("寮�濮嬪鐞嗘簮鏁版嵁=================error==================="+e.getMessage());
}finally {
IS_RUNNING = false;
+ log.info("寮�濮嬪鐞嗘簮鏁版嵁=================end===================");
}
}
- private OssModel initOssModel() {
+ @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) {
+ int i =0;
+ //澶氬浘锛岃嫳鏂囬�楀彿闅斿紑
+ if(StringUtils.isNotBlank(data.getBgImg())){
+ String tImg = data.getBgImg().replace("锛�", ",").replace(".avif", "");
+ 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,data.getBgImg());
+// i += addImg(i,ossModel,id,data.getBgImg2());
+// addImg(i,ossModel,id,data.getBgImg3());
+ }
+
+ private int addImg(int i,OssModel ossModel, Integer id,String bgImg) {
+ if(StringUtils.isNotBlank(bgImg)){
+ String img =getOssImgurl(ossModel, ossModel.getGoodsFolder() ,bgImg);
+ if(StringUtils.isNotBlank(img)){
+ Multifile f = new Multifile();
+ f.setFileurl(img);
+ f.setObjType(Constants.ZERO);
+ 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);
+ return 1;
+ }
+ }
+ return 0;
+ }
+
+ @Override
+ public OssModel initOssModel() {
OssModel model = new OssModel();
model.setUrl(systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode());
model.setEndpoint(systemDictDataBiz.queryByCode(Constants.OSS, Constants.ENDPOINT).getCode());
@@ -371,8 +475,7 @@
model.setAccessKey(systemDictDataBiz.queryByCode(Constants.OSS, Constants.ACCESS_KEY).getCode());
model.setBucket(systemDictDataBiz.queryByCode(Constants.OSS, Constants.BUCKETNAME).getCode());
model.setCateFolder(systemDictDataBiz.queryByCode(Constants.OSS, Constants.CATEGORY_IMG).getCode());
- model.setAccessKey(systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode());
-
+ model.setGoodsFolder(systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode());
return model;
}
@@ -386,7 +489,7 @@
String val =(String) item.invoke(data);
dealCateParam(cateId,goodsId,val.toString(),cateList);
} catch (Exception e) {
- throw new RuntimeException(e);
+// throw new RuntimeException(e);
}
}
}
@@ -431,12 +534,16 @@
if(StringUtils.isBlank(attr)){
return;
}
+// 鍟嗗搧鍚嶇О锛氱伀鏄熶汉F30BX
//濡傛灉灞炴�т笉涓虹┖锛屽鐞嗗睘鎬ф暟鎹�
int index = attr.indexOf("锛�");
if(index <=0){
return;
}
String attrName = attr.substring(0,index);
+ if(StringUtils.isBlank(attrName) || StringUtils.equals(attrName, "鍟嗗搧鍚嶇О") || StringUtils.equals(attrName, "鍟嗗搧缂栧彿")){
+ return;
+ }
String val = attr.substring(index+1);
BaseCateParam cate = getCateParamModelFromList(cateId,attrName, list);
BaseGoodsParam p = new BaseGoodsParam();
@@ -483,6 +590,9 @@
*/
private Brand getBrandModelFromList(String name, List<Brand> brandList) {
+ if(StringUtils.isBlank(name)){
+ return null;
+ }
if(brandList!=null && brandList.size()>0){
for(Brand brand : brandList){
if(StringUtils.equals(name,brand.getName())){
@@ -509,7 +619,10 @@
* @return
*/
- private BaseCategory getCateModelFromList(String name,OssModel ossModel, String img,List<BaseCategory> list) {
+ private BaseCategory getCateModelFromList(BigDecimal dRate,String name, OssModel ossModel, String img, List<BaseCategory> list) {
+ if(StringUtils.isBlank(name)){
+ return null;
+ }
if(list!=null && list.size()>0){
for(BaseCategory p : list){
if(StringUtils.equals(name,p.getName())){
@@ -520,8 +633,11 @@
BaseCategory model = new BaseCategory();
model.setCreateDate(new Date());
model.setName(name);
+ model.setPriceRate(dRate);
model.setIsdeleted(Constants.ZERO);
- model.setImgurl(getOssImgurl(ossModel,img));
+ model.setPinyin(PinYinUtil.getFullSpell(model.getName()));
+ model.setShortPinyin(PinYinUtil.getFirstSpell(model.getName()));
+ model.setImgurl(getOssImgurl(ossModel, ossModel.getCateFolder() ,img));
//鎻掑叆鏂扮殑鍝佺墝淇℃伅
baseCategoryMapper.insert(model);
//鍔犲叆闆嗗悎涓�
@@ -529,7 +645,8 @@
return model;
}
- private String getOssImgurl(OssModel ossModel, String img) {
+ @Override
+ public String getOssImgurl(OssModel ossModel, String folder,String img) {
if(StringUtils.isBlank(img)){
return null;
}
@@ -539,7 +656,7 @@
nfix = StringUtils.defaultString(nfix,".jpg");
String fileName = UUID.randomUUID() + nfix;
String tempFileName = nowDate + "/" + fileName;
- String key = ossModel.getCateFolder() + tempFileName;// 鏂囦欢鍚�
+ String key =folder+ tempFileName;// 鏂囦欢鍚�
ALiYunUtil obs = new ALiYunUtil(ossModel.getEndpoint(), ossModel.getAccessId(), ossModel.getAccessKey());
if (obs.uploadOnlineObject(img,ossModel.getBucket(), key,null)) {
@@ -550,4 +667,30 @@
}
return null;
}
+
+ @Override
+ public String getOssImgurl(OssModel ossModel, String folder, File f) {
+ if(f == null || !f.isFile()){
+ return null;
+ }
+ try {
+ String img = f.getPath();
+ 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;// 鏂囦欢鍚�
+
+ ALiYunUtil obs = new ALiYunUtil(ossModel.getEndpoint(), ossModel.getAccessId(), ossModel.getAccessKey());
+ if (obs.uploadFile(ossModel.getBucket(), key,f,null)) {
+ return tempFileName;
+ }
+ }catch (Exception e){
+
+ }
+ return null;
+ }
+
+
}
--
Gitblit v1.9.3