侨川科技QCKJ-ERP系统主要实现用户产品共享，可自己设置佣金抽成，供所有用户实现快速铺货模式，当然也可以不共享，专业做精品

package com.qckj.amz.controller; import com.alibaba.fastjson.JSONArray; import com.qckj.amz.dao.ProductTempBasicDao; import com.qckj.amz.dao.ProductTempDescDao; import com.qckj.amz.dao.ProductTempRlatDao; import com.qckj.amz.domain.ProductTempBasic; import com.qckj.amz.domain.ProductTempDesc; import com.qckj.amz.domain.ProductTempRlat; import com.qckj.amz.domain.temp.GoodsExportExcelEntity; import com.qckj.amz.utils.constants.AmzConstants; import com.qckj.amz.utils.enums.EnumAmzDictCode; import com.qckj.common.core.domain.AjaxResult; import com.qckj.common.utils.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Example; import org.springframework.web.bind.annotation.*; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Date; import java.util.List; /** * @author luchuan * @version v1.0 * @date 2022/12/23 0023 **/ @RestController @RequestMapping("/amz/restfulapi") public class ProductImportController { @Autowired private ProductTempBasicDao productTempBasicDao; @Autowired private ProductTempRlatDao productTempRlatDao; @Autowired private ProductTempDescDao productTempDescDao; /* @RequestMapping(value = "/import", method = RequestMethod.POST) public AjaxResult export(@RequestParam(name = "goodsExcelsList") String goodsExcelsList ,@RequestParam(name = "createBy") String createBy ,@RequestParam(name = "database") String database) { */ @RequestMapping(value = "/import", method = RequestMethod.POST) public AjaxResult export(@RequestBody String goodsExcelsList) { String database = "HO"; String createBy = "QC001"; //公共属性 String batchNo = database+"-"+ DateUtils.dateTimeNow();//批次号 Date createTime = new Date(); //开始数据处理 List<GoodsExportExcelEntity> goodsList = JSONArray.parseArray(goodsExcelsList, GoodsExportExcelEntity.class); if (goodsList!=null && goodsList.size()>0){ ArrayList<ProductTempBasic> basicList = new ArrayList<>(); ArrayList<ProductTempRlat> rlatList = new ArrayList<>(); ArrayList<ProductTempDesc> descList = new ArrayList<>(); for (GoodsExportExcelEntity goods: goodsList) { System.out.println("new_sku=="+database+"-"+goods.getSku()); //校验是否已经存在 ProductTempBasic basicReq = new ProductTempBasic(); basicReq.setProductCode(database+"-"+goods.getSku());//可能会重复-后期可追加字符 Example<ProductTempBasic> basicExample = Example.of(basicReq); ProductTempBasic productTempBasic = productTempBasicDao.findOne(basicExample).orElse(null); if (productTempBasic!=null){ continue;//当前产品已经存在，直接跳过 } //有变体：parentChild：parent-child //无变体：parentChild：null if (goods.getParentChild()==null || goods.getParentChild().equals("Parent")){ //基本信息 ProductTempBasic basic = new ProductTempBasic(); basic.setProductCode(database+"-"+goods.getSku());//可能会重复-后期可追加字符 basic.setBatchNo(batchNo); basic.setProductCategory("unknown");//产品分类 basic.setStandardPriceCoefficient(new BigDecimal(0.95));//销售价格系数 basic.setProductSourceType(database);//产品来源:HO basic.setBuyingLink("");//采购链接 basic.setBuyingPrice(new BigDecimal(0));//采购价格 basic.setProductSharingType("1");//共享类型:1不共享 basic.setIsCommissionType("");//是否佣金 basic.setCommissionRate(null);//佣金率 basic.setProductStatus("01111"); basic.setMainImageUrl(goods.getMainPic()); basic.setCreateBy(createBy); basic.setCreateTime(createTime); basicList.add(basic); //变体 ProductTempRlat rlat = new ProductTempRlat(); rlat.setProductCode(database+"-"+goods.getSku()); rlat.setItemSku(database+"-"+goods.getSku()); rlat.setParentSku(null);//父体sku为null rlat.setExternalProductId("");//EAN值/父体为null rlat.setExternalProductIdType("");//EAN/父体为null if (goods.getParentChild()==null){ rlat.setParentChild(null); }else { rlat.setParentChild(AmzConstants.PARENTAGE_PARENT); } rlat.setRelationshipType(null);//关系类型/父体为null rlat.setVariationTheme(goods.getVariantTheme()); rlat.setColorName(goods.getColor()); rlat.setSizeName(goods.getSize()); rlat.setItemWeight(Double.parseDouble(goods.getWeight())); rlat.setStandardPrice(new BigDecimal(goods.getPrice())); rlat.setQuantity(Integer.parseInt(goods.getStock())); rlat.setMainImageUrl(goods.getMainPic()); rlat.setOtherImageUrl1(goods.getPic1()); rlat.setOtherImageUrl2(goods.getPic2()); rlat.setOtherImageUrl3(goods.getPic3()); rlat.setOtherImageUrl4(goods.getPic4()); rlat.setOtherImageUrl5(goods.getPic5()); rlat.setOtherImageUrl6(goods.getPic6()); rlat.setOtherImageUrl7(goods.getPic7()); rlat.setOtherImageUrl8(goods.getPic8()); rlat.setCreateBy(createBy); rlat.setCreateTime(createTime); rlatList.add(rlat); //描述 //英国-英语 ProductTempDesc descUK = new ProductTempDesc(); descUK.setProductCode(database+"-"+goods.getSku()); descUK.setCountryCode(EnumAmzDictCode.COUNTRYCODE_UK.getCode());//英国 descUK.setLanguageCode(EnumAmzDictCode.COUNTRYCODE_UK.getDesc()); descUK.setMarketspacePriceCoefficient(new BigDecimal(1)); descUK.setItemName(goods.getEnTitle()); descUK.setGenericKeywords(goods.getEnKey()); descUK.setBulletPoint1(goods.getEnKeyPoints1()); descUK.setBulletPoint2(goods.getEnKeyPoints2()); descUK.setBulletPoint3(goods.getEnKeyPoints3()); descUK.setBulletPoint4(goods.getEnKeyPoints4()); descUK.setBulletPoint5(goods.getEnKeyPoints5()); String productDescriptionUK = ""; productDescriptionUK += goods.getEnDescr1() == null ? "" : goods.getEnDescr1()+"\n"; productDescriptionUK += goods.getEnDescr2() == null ? "" : goods.getEnDescr2()+"\n"; productDescriptionUK += goods.getEnDescr3() == null ? "" : goods.getEnDescr3()+"\n"; productDescriptionUK += goods.getEnDescr4() == null ? "" : goods.getEnDescr4()+"\n"; productDescriptionUK += goods.getEnDescr5() == null ? "" : goods.getEnDescr5()+"\n"; productDescriptionUK += goods.getEnDescr6() == null ? "" : goods.getEnDescr6()+"\n"; productDescriptionUK += goods.getEnDescr7() == null ? "" : goods.getEnDescr7()+"\n"; productDescriptionUK += goods.getEnDescr8() == null ? "" : goods.getEnDescr8()+"\n"; productDescriptionUK += goods.getEnDescr9() == nu