From b3585e6475b7a7ab38fcb8af79def5e938a297ea Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期三, 22 十一月 2023 18:45:31 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java | 36 ++++++++++++++++++++++++++---------- 1 files changed, 26 insertions(+), 10 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 81a2cde..3104725 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 @@ -2,25 +2,23 @@ import com.consum.base.Constants; import com.consum.base.core.CodeGeneratorService; -import com.consum.base.pojo.BaseGoodsTemplateParam; import com.consum.base.core.utils.IdUtil; -import com.consum.model.po.BaseCategory; -import com.consum.model.po.BaseGoodsModels; -import com.consum.model.po.BaseGoodsTemplate; -import com.consum.model.po.SDictData; +import com.consum.base.pojo.BaseGoodsTemplateParam; +import com.consum.model.po.*; 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 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; + +import java.util.HashMap; +import java.util.List; +import java.util.Map; /** * @Description 鐗╁搧妯℃澘 @@ -62,7 +60,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/24 */ - public int add(BaseGoodsTemplateParam param, S_user_core currentUser) { + public int add(BaseGoodsTemplateParam param, FinSysTenantUser currentUser) { //1.鏂板鐗╁搧妯℃澘 BaseGoodsTemplate baseGoodsTemplate = new BaseGoodsTemplate(); BeanUtils.copyProperties(param, baseGoodsTemplate); @@ -84,7 +82,9 @@ //褰撳墠鏈烘瀯鐨勭埗绾ф満鏋勭紪鍙� //鏈烘瀯灞傜骇 //鏈烘瀯缂栧彿 + baseGoodsTemplate.setAgencyId(Long.valueOf(currentUser.getTenantId())); //鏈烘瀯鍚嶇О + baseGoodsTemplate.setAgencyName(currentUser.getTenantName()); //鍒涘缓鏃堕棿 long createTime = DateUtils.getDateTimeNumber(System.currentTimeMillis()); baseGoodsTemplate.setCreateDate(createTime); @@ -300,7 +300,15 @@ return this.select(goodsTemplate); } - public List<BaseGoodsTemplate> queryGoodsTemplateByCategoryId(Long agencyId, Long categoryId) { + /** + * @param agencyId + * @param categoryId + * @param states + * @param goodsName 鍏ㄥ尮閰嶏紒锛侊紒 + * @return + */ + + public List<BaseGoodsTemplate> queryGoodsTemplateByCategoryId(Long agencyId, Long categoryId, Short states, String goodsName) { StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1=1 "); Map<String, Object> params = new HashMap<>(); if (agencyId != null) { @@ -311,6 +319,14 @@ sql.append("AND CATEGORY_ID=:categoryId "); params.put("categoryId", categoryId); } + if (states != null) { + sql.append("AND STATES=:states "); + params.put("states", states); + } + if (StringUtils.isNotEmpty(goodsName)) { + sql.append(" and GOODS_NAME =:goodsName "); + params.put("goodsName", goodsName); + } return this.select(sql.toString(), params, new BaseGoodsTemplate()); } } -- Gitblit v1.9.1