From ccda8b2733a2fabb8c23c062583b1437d6866379 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 09 十一月 2023 11:47:48 +0800
Subject: [PATCH] feat: 增加查询角色类
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java | 278 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 274 insertions(+), 4 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
index 8b383bc..4db2cf8 100644
--- a/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
@@ -1,11 +1,26 @@
package com.consum.base.service;
+import com.consum.base.Constants;
+import com.consum.base.core.CodeGeneratorService;
+import com.consum.base.pojo.BaseGoodsTemplateParam;
+import com.consum.base.util.IdUtil;
import com.consum.model.po.BaseCategory;
+import com.consum.model.po.BaseGoodsModels;
+import com.consum.model.po.BaseGoodsTemplate;
+import com.consum.model.po.S_dict_data;
+import com.consum.model.vo.BaseGoodsTemplateVo;
+import com.iplatform.model.po.S_user_core;
+import com.walker.db.page.GenericPager;
+import com.walker.infrastructure.utils.DateUtils;
+import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
-import org.springframework.stereotype.Service;
-
import java.util.HashMap;
import java.util.List;
+import java.util.Map;
+import org.springframework.beans.BeanUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
/**
* @Description 鐗╁搧妯℃澘
@@ -15,11 +30,18 @@
@Service
public class BaseGoodsTemplateServiceImpl extends BaseServiceImpl {
+ @Autowired
+ private CodeGeneratorService codeGeneratorService;
+ @Autowired
+ private BaseCategoryServiceImpl baseCategoryService;
+ @Autowired
+ private BaseGoodsModelsServiceImpl baseGoodsModelsService;
+
/**
- * @Description 鏍规嵁鍒嗙被id鍜岀姸鎬佹煡璇㈢墿鍝佹ā鐗�
+ * @return
+ * @Description 鏍规嵁鍒嗙被id鍜岀姸鎬佹煡璇㈢墿鍝佹ā鐗�
* @Author 鍗㈠簡闃�
* @Date 2023/10/23
- * @return
*/
public List<BaseCategory> getByCategoryId(Long categoryId) {
StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 ");
@@ -34,4 +56,252 @@
return this.select(sql.toString(), paramts, new BaseCategory());
}
+
+ /**
+ * @Description 鏂板鐗╁搧妯℃澘
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/24
+ */
+ public int add(BaseGoodsTemplateParam param, S_user_core currentUser) {
+ //1.鏂板鐗╁搧妯℃澘
+ BaseGoodsTemplate baseGoodsTemplate = new BaseGoodsTemplate();
+ BeanUtils.copyProperties(param, baseGoodsTemplate);
+ long goodsTemplatesId = IdUtil.generateId();
+ baseGoodsTemplate.setId(goodsTemplatesId);
+ //NumberGenerator.getLongSequenceNumber()
+ //鏍规嵁鍒嗙被id鏌ヨ鍒嗙被
+ BaseCategory baseCategory = this.baseCategoryService.get(new BaseCategory(param.getCategoryId()));
+ if (baseCategory != null) {
+ baseGoodsTemplate.setCategoryName(baseCategory.getCategoryName());
+ String classification = baseCategory.getClassification();
+ //鐗╁搧缂栫爜
+ String goodsCode = codeGeneratorService.createGoodsTemplateCode(classification);
+ baseGoodsTemplate.setGoodsCode(goodsCode);
+ //绫诲埆
+ baseGoodsTemplate.setClassification(classification);
+ }
+ //TODO 涓�绾т簩绾т笁绾ф満鏋勭紪鍙�
+ //褰撳墠鏈烘瀯鐨勭埗绾ф満鏋勭紪鍙�
+ //鏈烘瀯灞傜骇
+ //鏈烘瀯缂栧彿
+ //鏈烘瀯鍚嶇О
+ //鍒涘缓鏃堕棿
+ long createTime = DateUtils.getDateTimeNumber(System.currentTimeMillis());
+ baseGoodsTemplate.setCreateDate(createTime);
+ int flag1 = this.insert(baseGoodsTemplate);
+
+ //2.鏂板瑙勬牸鍨嬪彿
+ List<BaseGoodsModels> models = param.getModels();
+ int flag2 = 0;
+ if (!CollectionUtils.isEmpty(models)) {
+ for (BaseGoodsModels model : models) {
+ model.setId(IdUtil.generateId());
+ model.setStates(Constants.STATES_ENABLE);
+ model.setGoodsTemplatesId(goodsTemplatesId);
+ model.setCreateTime(createTime);
+ }
+ flag2 = this.baseGoodsModelsService.insert(models);
+ }
+
+ if (flag1 > 0 && flag2 > 0) {
+ return 1;
+ } else {
+ return 0;
+ }
+ }
+
+ /**
+ * @Description 鐗╁搧妯℃澘鍒楄〃鏌ヨ
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/24
+ */
+ public GenericPager<BaseGoodsTemplate> queryList(BaseGoodsTemplateParam param) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ //鐗╁搧鍚嶇О
+ if (!StringUtils.isEmpty(param.getGoodsName())) {
+ sql.append(" and goods_name like:goods_name ");
+ paramts.put("goods_name", StringUtils.CHAR_PERCENT + param.getGoodsName() + StringUtils.CHAR_PERCENT);
+ }
+ //鐗╁搧缂栧彿
+ if (!StringUtils.isEmpty(param.getGoodsCode())) {
+ sql.append(" and goods_code like:goods_code ");
+ paramts.put("goods_code", StringUtils.CHAR_PERCENT + param.getGoodsCode() + StringUtils.CHAR_PERCENT);
+ }
+ //鍒嗙被id
+ if (param.getCategoryId() != null) {
+ sql.append(" and category_id =:category_id ");
+ paramts.put("category_id", param.getCategoryId());
+ }
+ //绫诲埆
+ if (!StringUtils.isEmpty(param.getClassification())) {
+ sql.append(" and classification =:classification ");
+ paramts.put("classification", param.getClassification());
+ }
+ //鎵�灞炴満鏋�
+ if (param.getAgencyId() != null) {
+ sql.append(" and agency_id =:agency_id ");
+ paramts.put("agency_id", param.getAgencyId());
+ }
+ //鐘舵��
+ if (param.getStates() != null) {
+ sql.append(" and states =:states ");
+ paramts.put("states", param.getStates());
+ }
+ sql.append(" ORDER BY CREATE_DATE DESC ");
+
+ return selectSplit(sql.toString(), paramts, new BaseGoodsTemplate());
+ }
+
+ /**
+ * 鏍规嵁鐗╁搧id鏌ヨ鐗╁搧璇︽儏
+ *
+ * @author 鍗㈠簡闃�
+ * @date 2023/9/26
+ */
+ public BaseGoodsTemplateVo getById(Long id) {
+ //1.鏍规嵁鐗╁搧id鏌ヨ鐗╁搧妯℃澘
+ BaseGoodsTemplate goodsTemplate = this.get(new BaseGoodsTemplate(id));
+ //2.鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+ //鎵�灞炵墿鍝佹ā鐗堢紪鍙�
+ sql.append(" and goods_templates_id =:goods_templates_id ");
+ paramts.put("goods_templates_id", id);
+ List<BaseGoodsModels> modelsList = this.select(sql.toString(), paramts, new BaseGoodsModels());
+
+ //3.灏佽
+ BaseGoodsTemplateVo vo = new BaseGoodsTemplateVo();
+ if (goodsTemplate != null) {
+ BeanUtils.copyProperties(goodsTemplate, vo);
+ }
+ if (!CollectionUtils.isEmpty(modelsList)) {
+ vo.setModels(modelsList);
+ }
+ return vo;
+ }
+
+ /**
+ * @Description 缂栬緫
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/24
+ */
+ public int updateBaseGoodsTemplate(BaseGoodsTemplateParam param) {
+ //1.淇敼鐗╁搧妯℃澘
+ BaseGoodsTemplate baseGoodsTemplate = new BaseGoodsTemplate();
+ BeanUtils.copyProperties(param, baseGoodsTemplate);
+ BaseCategory baseCategory = this.baseCategoryService.get(new BaseCategory(param.getCategoryId()));
+ if (baseCategory != null) {
+ baseGoodsTemplate.setCategoryName(baseCategory.getCategoryName());
+ }
+ int flag1 = this.update(baseGoodsTemplate);
+ //2.淇敼瑙勬牸鍨嬪彿鐨勫崟浣�
+ List<BaseGoodsModels> modelsList = param.getModels();
+ int flag2 = this.update(modelsList);
+
+ if (flag1 > 0 && flag2 > 0) {
+ return 1;
+ } else {
+ return 0;
+ }
+ }
+
+ /**
+ * @Description 鏍规嵁鐗╁搧鍚嶇О鍜屽垎绫籭d鏌ヨ鐗╁搧
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/24
+ */
+ public BaseGoodsTemplate getByGoodsNameAndCategoryId(String goodsName, Long categoryId) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ //鐗╁搧鍚嶇О
+ sql.append(" and goods_name =:goods_name ");
+ paramts.put("goods_name", goodsName);
+ //鍒嗙被id
+ sql.append(" and category_id =:category_id ");
+ paramts.put("category_id", categoryId);
+
+ return this.get(sql.toString(), paramts, new BaseGoodsTemplate());
+ }
+
+ /**
+ * 鏍规嵁鍨嬪彿ID鏌ヨ鐗╁搧淇℃伅
+ *
+ * @param modelId
+ * @return
+ */
+ private static String QUERY_GOODSINFO_BY_MODELID = "SELECT model.MODEL_NAME modelName,model.UNIT,temp.id goodsId, temp.GOODS_CODE goodsCode,temp.GOODS_NAME goodsName,temp.CLASSIFICATION classification,temp.CATEGORY_ID categoryId FROM BASE_GOODS_MODELS model LEFT JOIN BASE_GOODS_TEMPLATE temp ON model.GOODS_TEMPLATES_ID=temp.id WHERE 1=1 ";
+
+ public Map<String, Object> queryGoodsInfoByModelId(Long modelId) {
+ StringBuilder sqlStr = new StringBuilder(QUERY_GOODSINFO_BY_MODELID);
+ Map<String, Object> params = new HashMap<>();
+ if (modelId != null) {
+ sqlStr.append(" AND model.id=:modelId");
+ params.put("modelId", modelId);
+ }
+ List<Map<String, Object>> tempGoodsInfo = this.select(sqlStr.toString(), params);
+ if (CollectionUtils.isEmpty(tempGoodsInfo)) {
+ return null;
+ }
+ return tempGoodsInfo.get(0);
+ }
+
+ /**
+ * 淇敼鐘舵��
+ *
+ * @author 鍗㈠簡闃�
+ * @date 2023/10/25
+ */
+ public int updateStatus(BaseGoodsTemplate goodsTemplate) {
+ return this.update(goodsTemplate);
+ }
+
+ /**
+ * @Description 鏍规嵁鐗╁搧id鍒犻櫎鐗╁搧
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/25
+ */
+ public int updateById(BaseGoodsTemplate goodsTemplate, S_user_core currentUser) {
+ goodsTemplate.setStates(Constants.STATES_DELETED);
+ //鍒犻櫎鏃堕棿
+ goodsTemplate.setDTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
+ //鍒犻櫎浜篿d鍜屽垹闄や汉濮撳悕
+ goodsTemplate.setDUserId(currentUser.getId());
+ goodsTemplate.setDUserName(currentUser.getUser_name());
+ return this.update(goodsTemplate);
+ }
+
+ /**
+ * @return
+ * @Description 鏌ヨ浠撳簱绫诲瀷(鏁版嵁瀛楀吀)
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/30
+ */
+ public List<S_dict_data> queryClassificationCode() {
+ StringBuilder sql = new StringBuilder("SELECT * FROM s_dict_data WHERE dict_type = 'CLASSIFICATION_CODE' order by dict_sort");
+ return this.select(sql.toString(), new Object[]{}, new S_dict_data());
+ }
+
+ /**
+ * @Description 鏍规嵁鍒嗙被id鏌ヨ鐗╁搧妯℃澘
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/30
+ */
+ public List<BaseGoodsTemplate> queryByCategoryId(Long categoryId) {
+ BaseGoodsTemplate goodsTemplate = new BaseGoodsTemplate();
+ goodsTemplate.setCategoryId(categoryId);
+ return this.select(goodsTemplate);
+ }
+
+ public List<BaseGoodsTemplate> queryByAgencyId(Long agencyId) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1=1 ");
+ Map<String, Object> params = new HashMap<>();
+ if (agencyId != null) {
+ sql.append(" AND model.id=:modelId");
+ params.put("agencyId", agencyId);
+ }
+ return this.select(sql.toString(), params, new BaseGoodsTemplate());
+ }
}
--
Gitblit v1.9.1