package com.jsh.erp.service.materialAttribute; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.jsh.erp.constants.BusinessConstants; import com.jsh.erp.datasource.entities.MaterialAttribute; import com.jsh.erp.datasource.entities.MaterialAttributeExample; import com.jsh.erp.datasource.mappers.MaterialAttributeMapper; import com.jsh.erp.datasource.mappers.MaterialAttributeMapperEx; import com.jsh.erp.exception.BusinessRunTimeException; import com.jsh.erp.exception.JshException; import com.jsh.erp.service.log.LogService; import com.jsh.erp.utils.StringUtil; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @Service public class MaterialAttributeService { private Logger logger = LoggerFactory.getLogger(MaterialAttributeService.class); @Resource private LogService logService; @Resource private MaterialAttributeMapper materialAttributeMapper; @Resource private MaterialAttributeMapperEx materialAttributeMapperEx; public MaterialAttribute getMaterialAttribute(long id)throws Exception { MaterialAttribute result=null; try{ result=materialAttributeMapper.selectByPrimaryKey(id); }catch(Exception e){ JshException.readFail(logger, e); } return result; } public List getMaterialAttribute() throws Exception{ MaterialAttributeExample example = new MaterialAttributeExample(); example.createCriteria().andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); example.setOrderByClause("id desc"); List list=null; try{ list=materialAttributeMapper.selectByExample(example); }catch(Exception e){ JshException.readFail(logger, e); } return list; } public List select(String attributeName, int offset, int rows) throws Exception{ List list = new ArrayList<>(); try{ list = materialAttributeMapperEx.selectByConditionMaterialAttribute(attributeName, offset, rows); }catch(Exception e){ JshException.readFail(logger, e); } return list; } public Long countMaterialAttribute(String attributeField)throws Exception { Long result =null; try{ result= 5L; }catch(Exception e){ JshException.readFail(logger, e); } return result; } @Transactional(value = "transactionManager", rollbackFor = Exception.class) public int insertMaterialAttribute(JSONObject obj, HttpServletRequest request)throws Exception { MaterialAttribute m = JSONObject.parseObject(obj.toJSONString(), MaterialAttribute.class); try{ materialAttributeMapper.insertSelective(m); logService.insertLog("商品属性", new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_ADD).append(m.getAttributeName()).toString(), request); return 1; } catch (BusinessRunTimeException ex) { throw new BusinessRunTimeException(ex.getCode(), ex.getMessage()); } catch(Exception e){ JshException.writeFail(logger, e); return 0; } } @Transactional(value = "transactionManager", rollbackFor = Exception.class) public int updateMaterialAttribute(JSONObject obj, HttpServletRequest request) throws Exception{ MaterialAttribute materialAttribute = JSONObject.parseObject(obj.toJSONString(), MaterialAttribute.class); try{ materialAttributeMapper.updateByPrimaryKeySelective(materialAttribute); logService.insertLog("商品属性", new StringBuffer(BusinessConstants.LOG_OPERATION_TYPE_EDIT).append(materialAttribute.getAttributeName()).toString(), request); return 1; }catch(Exception e){ JshException.writeFail(logger, e); return 0; } } @Transactional(value = "transactionManager", rollbackFor = Exception.class) public int deleteMaterialAttribute(Long id, HttpServletRequest request)throws Exception { return batchDeleteMaterialAttributeByIds(id.toString()); } @Transactional(value = "transactionManager", rollbackFor = Exception.class) public int batchDeleteMaterialAttribute(String ids, HttpServletRequest request)throws Exception { return batchDeleteMaterialAttributeByIds(ids); } @Transactional(value = "transactionManager", rollbackFor = Exception.class) public int batchDeleteMaterialAttributeByIds(String ids) throws Exception{ String [] idArray=ids.split(","); try{ return materialAttributeMapperEx.batchDeleteMaterialAttributeByIds(idArray); }catch(Exception e){ JshException.writeFail(logger, e); return 0; } } public int checkIsNameExist(Long id, String name)throws Exception { MaterialAttributeExample example = new MaterialAttributeExample(); example.createCriteria().andIdNotEqualTo(id).andAttributeNameEqualTo(name).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); List list =null; try{ list = materialAttributeMapper.selectByExample(example); }catch(Exception e){ JshException.readFail(logger, e); } return list==null?0:list.size(); } public JSONArray getValueArrById(Long id) { JSONArray valueArr = new JSONArray(); MaterialAttribute ma = getInfoById(id); if(ma!=null) { String value = ma.getAttributeValue(); if(StringUtil.isNotEmpty(value)){ String[] arr = value.split("\\|"); for(String v: arr) { JSONObject item = new JSONObject(); item.put("value",v); item.put("name",v); valueArr.add(item); } } } return valueArr; } public MaterialAttribute getInfoById(Long id) { MaterialAttributeExample example = new MaterialAttributeExample(); example.createCriteria().andIdEqualTo(id).andDeleteFlagNotEqualTo(BusinessConstants.DELETE_FLAG_DELETED); List list = materialAttributeMapper.selectByExample(example); if(list!=null && list.size()>0) { return list.get(0); } else { return null; } } }