2 文件已重命名
5个文件已添加
30个文件已修改
| | |
| | | /* 模æ¿ä¸è½½ */ |
| | | templateSettings: { |
| | | templateName: '导å
¥æ¨¡æ¿.xls', // åç§° |
| | | templateUrl: SettingIplatform.apiBaseURL + '/pc/fin/sys/tenant/getImportTemplate' // ä¸è½½å°å |
| | | templateUrl: SettingIplatform.apiBaseURL + '/pc/fin/sys/tenant/getImportTemplate?type=goods' // ä¸è½½å°å |
| | | }, |
| | | onSuccess: null |
| | | }, |
| | |
| | | /* 模æ¿ä¸è½½ */ |
| | | templateSettings: { |
| | | templateName: '导å
¥æ¨¡æ¿.xls', // åç§° |
| | | templateUrl: SettingIplatform.apiBaseURL + '/pc/fin/sys/tenant/getImportTemplate' // ä¸è½½å°å |
| | | templateUrl: SettingIplatform.apiBaseURL + '/pc/fin/sys/tenant/getImportTemplate?type=tenant' // ä¸è½½å°å |
| | | }, |
| | | onSuccess: null |
| | | }, |
| | |
| | | package com.consum.base; |
| | | |
| | | import java.io.ByteArrayInputStream; |
| | | import java.io.ByteArrayOutputStream; |
| | | import java.io.IOException; |
| | | import java.io.OutputStream; |
| | | import java.io.InputStream; |
| | | import java.net.URLEncoder; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | |
| | | import com.iplatform.base.util.UserUtils; |
| | | import com.iplatform.core.BeanContextAware; |
| | | import com.iplatform.model.po.S_user_core; |
| | | import com.walker.file.FileInfo; |
| | | |
| | | public abstract class BaseController extends PlatformAdapterController { |
| | | |
| | |
| | | return this.getFinSysTenantUserCache().get(String.valueOf(userInfo.getId())); |
| | | } |
| | | |
| | | protected void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) throws IOException { |
| | | OutputStream out = response.getOutputStream(); |
| | | protected String downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) throws Exception { |
| | | response.setCharacterEncoding("UTF-8"); |
| | | response.setHeader("content-Type", "application/vnd.ms-excel"); |
| | | response.setHeader("Content-Disposition", |
| | |
| | | ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); |
| | | workbook.write(byteArrayOutputStream); |
| | | response.setHeader("Content-Length", String.valueOf(byteArrayOutputStream.size())); |
| | | out.write(byteArrayOutputStream.toByteArray()); |
| | | |
| | | InputStream byteArrayInputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray()); |
| | | FileInfo fileInfo = this.uploadFileToLocal(byteArrayInputStream, fileName + ".xls", "-1", |
| | | byteArrayOutputStream.size(), 0, "-1"); |
| | | String fileUrl = fileInfo.getUrl(); |
| | | workbook.close(); |
| | | out.close(); |
| | | return fileUrl; |
| | | } |
| | | |
| | | } |
| | |
| | | package com.consum.base.cache; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.consum.base.Constants; |
| | | import com.consum.base.FinSysTenantCacheProvider; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.walker.cache.AbstractCacheProvider; |
| | | import com.walker.cache.Cache; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * åºåç¼å |
| | |
| | | return FinSysTenant.class; |
| | | } |
| | | |
| | | public void setFinSysTenantService(FinSysTenantServiceImpl finSysTenantService) { |
| | | public void setFinSysTenantService(FinSysTenantService finSysTenantService) { |
| | | this.finSysTenantService = finSysTenantService; |
| | | } |
| | | |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | } |
| | |
| | | package com.consum.base.cache; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | import com.consum.base.Constants; |
| | | import com.consum.base.FinSysTenantCacheProvider; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.walker.infrastructure.ApplicationRuntimeException; |
| | | import com.walker.infrastructure.utils.JsonUtils; |
| | | import com.walker.support.redis.cache.RedisCacheProvider; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * åºåç¼å |
| | | * @ä½è
ï¼power |
| | | * @æ¶é´ï¼2023/7/20 20:35 |
| | | * |
| | | * @ä½è
ï¼power @æ¶é´ï¼2023/7/20 20:35 |
| | | */ |
| | | public class RedisFinSysTenantCache extends RedisCacheProvider<FinSysTenant> implements FinSysTenantCacheProvider { |
| | | public RedisFinSysTenantCache(){ |
| | | public RedisFinSysTenantCache() { |
| | | this.setUseRedis(true); |
| | | this.setLoadPage(false); |
| | | } |
| | | |
| | | @Override |
| | | public FinSysTenant get(String code) { |
| | | FinSysTenant finSysTenant = this.getCacheData(code); |
| | | if(finSysTenant == null){ |
| | | if (finSysTenant == null) { |
| | | finSysTenant = this.finSysTenantService.queryOneByCode(code); |
| | | if(finSysTenant == null){ |
| | | if (finSysTenant == null) { |
| | | logger.warn("仿°æ®åºæªæ¥è¯¢å°åºåï¼æ æ³ç¼åï¼code = {}", code); |
| | | return null; |
| | | } |
| | | |
| | | // 2023-07-26ï¼æ¶å
è±ï¼åºåç¸å¯¹åºå®ï¼æ éè®¾ç½®å¤±ææ¶é´ï¼è®©ä»æ°¸è¿åå¨å§ã |
| | | // this.putCacheData(code, finSysTenant,7200); |
| | | // this.putCacheData(code, finSysTenant,7200); |
| | | this.putCacheData(code, finSysTenant); |
| | | } |
| | | return finSysTenant; |
| | |
| | | @Override |
| | | public FinSysTenant getById(String id) { |
| | | FinSysTenant finSysTenant = this.getCacheData(id); |
| | | if(finSysTenant == null){ |
| | | if (finSysTenant == null) { |
| | | finSysTenant = this.finSysTenantService.get(new FinSysTenant(Long.parseLong(id))); |
| | | if(finSysTenant == null){ |
| | | if (finSysTenant == null) { |
| | | logger.warn("仿°æ®åºæªæ¥è¯¢å°åºåï¼æ æ³ç¼åï¼id = {}", id); |
| | | return null; |
| | | } |
| | |
| | | public List<FinSysTenant> selectAll() { |
| | | List<FinSysTenant> allTree = new ArrayList<>(); |
| | | FinSysTenant temp = null; |
| | | for(String value : this.getCache().getIterator(null)) { |
| | | for (String value : this.getCache().getIterator(null)) { |
| | | try { |
| | | temp = JsonUtils.jsonStringToObject(value, FinSysTenant.class); |
| | | } catch (Exception ex) { |
| | | throw new ApplicationRuntimeException("redisåå¨'EbProductBrand'è§£æéå´:"+ value,ex); |
| | | throw new ApplicationRuntimeException("redisåå¨'EbProductBrand'è§£æéå´:" + value, ex); |
| | | } |
| | | allTree.add(temp); |
| | | } |
| | |
| | | return FinSysTenant.class; |
| | | } |
| | | |
| | | public void setFinSysTenantService(FinSysTenantServiceImpl finSysTenantService) { |
| | | public void setFinSysTenantService(FinSysTenantService finSysTenantService) { |
| | | this.finSysTenantService = finSysTenantService; |
| | | } |
| | | |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | } |
| | |
| | | package com.consum.base.config; |
| | | |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty; |
| | | import org.springframework.context.annotation.Bean; |
| | | import org.springframework.context.annotation.Configuration; |
| | | |
| | | import com.consum.base.FinOrgCacheProvider; |
| | | import com.consum.base.FinSysTenantCacheProvider; |
| | | import com.consum.base.FinSysTenantUserCacheProvider; |
| | |
| | | import com.consum.base.cache.LocalFinSysTenantUserCache; |
| | | import com.consum.base.cache.LocalTokenCache; |
| | | import com.consum.base.service.FinOrgService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.FinSysTenantUserServiceImpl; |
| | | import com.iplatform.base.config.CacheConfiguration; |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty; |
| | | import org.springframework.context.annotation.Bean; |
| | | import org.springframework.context.annotation.Configuration; |
| | | |
| | | @Configuration |
| | | @ConditionalOnProperty(prefix = "iplatform.cache", name = "redis-enabled", havingValue = "false", matchIfMissing = true) |
| | |
| | | * @date 2023-07-05 |
| | | */ |
| | | @Bean |
| | | public FinSysTenantCacheProvider finSysTenantCacheProvider(FinSysTenantServiceImpl finSysTenantService){ |
| | | public FinSysTenantCacheProvider finSysTenantCacheProvider(FinSysTenantService finSysTenantService){ |
| | | LocalFinSysTenantCache cache = new LocalFinSysTenantCache(); |
| | | cache.setFinSysTenantService(finSysTenantService); |
| | | return cache; |
| | |
| | | package com.consum.base.config; |
| | | |
| | | import org.springframework.boot.autoconfigure.AutoConfigureAfter; |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnClass; |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty; |
| | | import org.springframework.boot.autoconfigure.data.redis.RedisAutoConfiguration; |
| | | import org.springframework.context.annotation.Bean; |
| | | import org.springframework.context.annotation.Configuration; |
| | | |
| | | import com.consum.base.FinOrgCacheProvider; |
| | | import com.consum.base.FinSysTenantCacheProvider; |
| | | import com.consum.base.FinSysTenantUserCacheProvider; |
| | |
| | | import com.consum.base.cache.RedisFinSysTenantUserCache; |
| | | import com.consum.base.cache.RedisTokenCache; |
| | | import com.consum.base.service.FinOrgService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.FinSysTenantUserServiceImpl; |
| | | import com.iplatform.base.config.CacheConfiguration; |
| | | import com.walker.support.redis.RedisHelper; |
| | | import com.walker.support.redis.cache.RedisCacheProvider; |
| | | import org.springframework.boot.autoconfigure.AutoConfigureAfter; |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnClass; |
| | | import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty; |
| | | import org.springframework.boot.autoconfigure.data.redis.RedisAutoConfiguration; |
| | | import org.springframework.context.annotation.Bean; |
| | | import org.springframework.context.annotation.Configuration; |
| | | |
| | | @Configuration |
| | | @ConditionalOnProperty(prefix = "iplatform.cache", name = "redis-enabled", havingValue = "true", matchIfMissing = false) |
| | |
| | | * @date 2023-07-05 |
| | | */ |
| | | @Bean |
| | | public FinSysTenantCacheProvider finSysTenantCacheProvider(RedisHelper redisHelper, FinSysTenantServiceImpl finSysTenantService){ |
| | | public FinSysTenantCacheProvider finSysTenantCacheProvider(RedisHelper redisHelper, FinSysTenantService finSysTenantService){ |
| | | RedisFinSysTenantCache cache = new RedisFinSysTenantCache(); |
| | | cache.setRedisHelper(redisHelper); |
| | | cache.setFinSysTenantService(finSysTenantService); |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.core.utils.CommonUtil; |
| | | import com.consum.base.pojo.BaseCategoryParam; |
| | |
| | | import com.consum.model.po.BaseCategory; |
| | | import com.iplatform.model.po.S_user_core; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.tree.TreeNode; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.TreeMap; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * @Description ç©ååç±» |
| | |
| | | |
| | | @Autowired |
| | | private BaseGoodsTemplateService baseGoodsTemplateService; |
| | | |
| | | private boolean multiRoot = true; |
| | | private TreeNode dummyRoot = null; |
| | | private Map<Long, TreeNode> rootMap = new TreeMap(); |
| | | private Map<Long, TreeNode> childMap = new TreeMap(); |
| | | private long defaultParentId = 0L; |
| | | |
| | | /** |
| | | * @Description è·ååç±»æ |
| | |
| | | if (param.getOrderNumber() == null) { |
| | | return ResponseValue.error("顺åºå·ä¸ºç©º"); |
| | | } |
| | | //夿åä¸ç¶ç±»idä¸åç±»åç§°æ¯å¦éå¤ |
| | | BaseCategory category = this.baseCategoryService.getByCategoryNameAndFatherCategoryId(param.getCategoryName(), param.getFatherCategoryId()); |
| | | // 夿åä¸ç¶ç±»idä¸åç±»åç§°æ¯å¦éå¤ |
| | | BaseCategory category = this.baseCategoryService.getByCategoryNameAndFatherCategoryId(param.getCategoryName(), |
| | | param.getFatherCategoryId()); |
| | | if (category != null) { |
| | | return ResponseValue.error("åç±»åç§°å·²åå¨"); |
| | | } |
| | |
| | | GenericPager<BaseCategory> pager = this.baseCategoryService.queryBaseCategoryList(param); |
| | | return ResponseValue.success(pager); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description ç¼è¾ |
| | |
| | | * @author å¢åºé³ |
| | | * @date 2023/10/23 |
| | | */ |
| | | //åç±»ä¸ææ£å¸¸ç¶æçç©åæ¶ï¼ä¸å
许ç¦ç¨ |
| | | // åç±»ä¸ææ£å¸¸ç¶æçç©åæ¶ï¼ä¸å
许ç¦ç¨ |
| | | @PostMapping("/updStatus") |
| | | public ResponseValue updateStatus() { |
| | | BaseCategory baseCategory = CommonUtil.getObjFromReqBody(BaseCategory.class); |
| | |
| | | if (baseCategory == null || baseCategory.getId() == null || baseCategory.getStates() == null) { |
| | | return ResponseValue.error("åæ°é误"); |
| | | } |
| | | //æ ¹æ®åç±»idåç¶ææ¥è¯¢ç©å模ç |
| | | // æ ¹æ®åç±»idåç¶ææ¥è¯¢ç©å模ç |
| | | List<BaseCategory> list = this.baseGoodsTemplateService.getByCategoryId(baseCategory.getId()); |
| | | if (baseCategory.getStates() == 2 && !CollectionUtils.isEmpty(list)) { |
| | | return ResponseValue.error("åç±»ä¸ææ£å¸¸ç¶æçç©åï¼ä¸å
许ç¦ç¨"); |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import java.io.IOException; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.context.AnalysisContext; |
| | | import com.alibaba.excel.event.AnalysisEventListener; |
| | | import com.alibaba.excel.exception.ExcelDataConvertException; |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.core.utils.CommonUtil; |
| | | import com.consum.base.core.utils.MapUtils; |
| | | import com.consum.base.core.utils.MapperUtil; |
| | | import com.consum.base.pojo.BaseGoodsTemplateParam; |
| | | import com.consum.base.pojo.excel.ImportGoodsInfoTemplate; |
| | | import com.consum.base.pojo.response.GoodsTemplateVO; |
| | | import com.consum.base.service.BaseGoodsTemplateService; |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.LWhGoodsService; |
| | | import com.consum.model.po.BaseGoodsModels; |
| | | import com.consum.model.po.BaseGoodsTemplate; |
| | | import com.consum.model.po.BaseWarehouse; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.po.SDictData; |
| | | import com.consum.model.vo.BaseGoodsTemplateVo; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.utils.DateUtils; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | |
| | | |
| | | @Autowired |
| | | private BaseWarehouseService baseWarehouseService; |
| | | |
| | | @Autowired |
| | | private FinSysTenantService finSysTenantService; |
| | | |
| | | /** |
| | | * @Description æ°å¢ç©åæ¨¡æ¿ |
| | |
| | | return ResponseValue.success("æ¥è¯¢æå!", resultList); |
| | | } |
| | | |
| | | @PostMapping("/import") |
| | | public ResponseValue upload(MultipartFile file) throws IOException { |
| | | String originalFilename = file.getOriginalFilename(); |
| | | if (!originalFilename.endsWith(".xls")) { |
| | | return ResponseValue.error("æä»¶æ ¼å¼æè¯¯!"); |
| | | } |
| | | FinSysTenantUser sysInfo = this.getSysInfo(); |
| | | if (sysInfo == null) { |
| | | return ResponseValue.error("å½åç»å½ç¨æ·ä¸ºç©º"); |
| | | } |
| | | EasyExcel.read(file.getInputStream(), ImportGoodsInfoTemplate.class, |
| | | new AnalysisEventListener<ImportGoodsInfoTemplate>() { |
| | | List<BaseGoodsTemplateParam> list = Lists.newArrayList(); |
| | | |
| | | @Override |
| | | public void invoke(ImportGoodsInfoTemplate data, AnalysisContext analysisContext) { |
| | | String categoryOne = data.getCategoryOne(); |
| | | String categoryTwo = data.getCategoryTwo(); |
| | | String categoryThree = data.getCategoryThree(); |
| | | String goodName = data.getGoodName(); |
| | | String goodModel = data.getGoodModel(); |
| | | String unit = data.getUnit(); |
| | | String type = data.getType(); |
| | | String agencyName = data.getAgencyName(); |
| | | |
| | | list.stream().forEach(item -> { |
| | | if (!item.getCategoryId().equals(categoryThree)) { |
| | | BaseGoodsTemplateParam baseGoodsTemplate = new BaseGoodsTemplateParam(); |
| | | baseGoodsTemplate.setCategoryId(Long.valueOf(categoryThree)); |
| | | baseGoodsTemplate.setGoodsName(goodName); |
| | | baseGoodsTemplate.setStates(1); |
| | | FinSysTenant finSysTenant = finSysTenantService.selectByName(agencyName); |
| | | baseGoodsTemplate.setAgencyId(finSysTenant.getId()); |
| | | |
| | | List<BaseGoodsModels> models = Lists.newArrayList(); |
| | | BaseGoodsModels baseGoodsModels = new BaseGoodsModels(); |
| | | baseGoodsModels.setModelName(goodModel); |
| | | baseGoodsModels.setStates(1); |
| | | baseGoodsModels.setGoodsTemplatesId(item.getId()); |
| | | baseGoodsModels.setUnit(unit); |
| | | baseGoodsModels.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); |
| | | models.add(baseGoodsModels); |
| | | baseGoodsTemplate.setModels(models); |
| | | } else { |
| | | List<BaseGoodsModels> models = item.getModels(); |
| | | BaseGoodsModels baseGoodsModels = new BaseGoodsModels(); |
| | | baseGoodsModels.setModelName(goodModel); |
| | | baseGoodsModels.setStates(1); |
| | | baseGoodsModels.setGoodsTemplatesId(item.getId()); |
| | | baseGoodsModels.setUnit(unit); |
| | | baseGoodsModels.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); |
| | | models.add(baseGoodsModels); |
| | | } |
| | | }); |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public void doAfterAllAnalysed(AnalysisContext analysisContext) { |
| | | for (BaseGoodsTemplateParam a : list) { |
| | | baseGoodsTemplateService.add(a, sysInfo); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public void onException(Exception exception, AnalysisContext analysisContext) throws Exception { |
| | | if (exception instanceof ExcelDataConvertException) { |
| | | ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException)exception; |
| | | Integer row = excelDataConvertException.getRowIndex() + 1; |
| | | Integer column = excelDataConvertException.getColumnIndex() + 1; |
| | | throw new RuntimeException("第" + row + "è¡ï¼ç¬¬" + column + "åè§£æå¼å¸¸ï¼è¯·æ£ç¡®å¡«å"); |
| | | } |
| | | } |
| | | }).sheet(0).doRead(); |
| | | |
| | | return ResponseValue.success("导å
¥æå!", 1); |
| | | } |
| | | } |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.context.AnalysisContext; |
| | | import com.alibaba.excel.event.AnalysisEventListener; |
| | | import com.alibaba.excel.exception.ExcelDataConvertException; |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.core.utils.CommonUtil; |
| | | import com.consum.base.core.utils.FinSysTenantUtils; |
| | | import com.consum.base.pojo.FinSysTenantParam; |
| | | import com.consum.base.pojo.FinSysTenantSearchParam; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantUserServiceImpl; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.vo.FinSysTenantUserResult; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.tree.TreeNode; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.web.ResponseValue; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import java.io.IOException; |
| | | import java.io.InputStream; |
| | | import java.net.URLEncoder; |
| | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.TreeMap; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.core.io.ClassPathResource; |
| | |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.context.AnalysisContext; |
| | | import com.alibaba.excel.event.AnalysisEventListener; |
| | | import com.alibaba.excel.exception.ExcelDataConvertException; |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.core.utils.CommonUtil; |
| | | import com.consum.base.core.utils.FinSysTenantUtils; |
| | | import com.consum.base.pojo.FinSysTenantParam; |
| | | import com.consum.base.pojo.FinSysTenantSearchParam; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.FinSysTenantUserServiceImpl; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.vo.FinSysTenantUserResult; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.tree.TreeNode; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | |
| | | /** |
| | | * @Description åºå |
| | | * @Author wh |
| | |
| | | @RequestMapping("/pc/fin/sys/tenant") |
| | | public class FinSysTenantController extends BaseController { |
| | | |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | |
| | | @Autowired |
| | | private FinSysTenantUserServiceImpl finSysTenantUserService; |
| | | |
| | | @Autowired |
| | | public FinSysTenantController(FinSysTenantServiceImpl finSysTenantService) { |
| | | public FinSysTenantController(FinSysTenantService finSysTenantService) { |
| | | this.finSysTenantService = finSysTenantService; |
| | | } |
| | | |
| | |
| | | |
| | | while (var3.hasNext()) { |
| | | Object obj = var3.next(); |
| | | node = this.toTreeNode((FinSysTenant) obj); |
| | | node = this.toTreeNode((FinSysTenant)obj); |
| | | |
| | | if (node.getId() == this.defaultParentId) { |
| | | this.rootMap.put(node.getId(), node); |
| | |
| | | var3 = this.rootMap.values().iterator(); |
| | | |
| | | while (var3.hasNext()) { |
| | | TreeNode n = (TreeNode) var3.next(); |
| | | TreeNode n = (TreeNode)var3.next(); |
| | | n.setParentId(this.defaultParentId); |
| | | this.dummyRoot.addChild(n); |
| | | } |
| | |
| | | Iterator i = childMap.values().iterator(); |
| | | |
| | | while (i.hasNext()) { |
| | | _node = (TreeNode) i.next(); |
| | | _node = (TreeNode)i.next(); |
| | | this.mountMiddleNode(_node, childMap); |
| | | } |
| | | |
| | | } |
| | | |
| | | private void mountMiddleNode(TreeNode currentNode, Map<Long, TreeNode> childMap) { |
| | | TreeNode _parentNode = (TreeNode) this.rootMap.get(currentNode.getParentId()); |
| | | TreeNode _parentNode = (TreeNode)this.rootMap.get(currentNode.getParentId()); |
| | | if (_parentNode == null) { |
| | | _parentNode = (TreeNode) childMap.get(currentNode.getId()); |
| | | _parentNode = (TreeNode)childMap.get(currentNode.getId()); |
| | | if (_parentNode == null) { |
| | | throw new NullPointerException("parent node not found, current: " + currentNode); |
| | | } |
| | |
| | | |
| | | protected TreeNode toTreeNode(FinSysTenant entity) { |
| | | TreeNode treeNode = |
| | | new TreeNode(entity.getId(), entity.getName(), (List) null, entity.getParentId(), entity.getCode()); |
| | | new TreeNode(entity.getId(), entity.getName(), (List)null, entity.getParentId(), entity.getCode()); |
| | | return treeNode; |
| | | } |
| | | |
| | |
| | | Iterator var2 = this.rootMap.values().iterator(); |
| | | |
| | | while (var2.hasNext()) { |
| | | TreeNode node = (TreeNode) var2.next(); |
| | | TreeNode node = (TreeNode)var2.next(); |
| | | list.add(node); |
| | | } |
| | | return list; |
| | |
| | | if (param.getFirstZmS() != null && !param.getFirstZmS().equals("")) { |
| | | whStr.append(" and name is not null and("); |
| | | String upperCase = param.getFirstZmS().toUpperCase(); |
| | | whStr.append("instr(:upperFirstZmS,F_PINYIN( SUBSTR(name, 1, 1)))>0 or instr(:upperFirstZmS2,SUBSTR(name, 1, 1))>0"); |
| | | whStr.append( |
| | | "instr(:upperFirstZmS,F_PINYIN( SUBSTR(name, 1, 1)))>0 or instr(:upperFirstZmS2,SUBSTR(name, 1, 1))>0"); |
| | | parameter.put("upperFirstZmS", upperCase); |
| | | parameter.put("upperFirstZmS2", upperCase); |
| | | whStr.append(")"); |
| | |
| | | List<FinSysTenant> select = this.finSysTenantService.select(new FinSysTenant(), whStr.toString(), parameter); |
| | | return ResponseValue.success(select); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * å é¤ |
| | |
| | | } |
| | | |
| | | @GetMapping("getImportTemplate") |
| | | public ResponseEntity<InputStreamResource> getImportTemplate() throws IOException { |
| | | public ResponseEntity<InputStreamResource> getImportTemplate(String type) throws IOException { |
| | | // ä»å½å项ç®èµæºç®å½è·åæä»¶ |
| | | Resource resource = new ClassPathResource("import/æºæå¯¼å
¥æ¨¡æ¿.xls"); |
| | | String fileName = null; |
| | | if ("tenant".equals(type)) { |
| | | fileName = "æºæå¯¼å
¥æ¨¡æ¿.xls"; |
| | | } else if ("goods".equals(type)) { |
| | | fileName = "ç©åä¿¡æ¯.xls"; |
| | | } |
| | | Resource resource = new ClassPathResource("import/" + fileName); |
| | | // è·åæä»¶è¾å
¥æµ |
| | | InputStream inputStream = resource.getInputStream(); |
| | | // 设置HTTPååºå¤´ |
| | | HttpHeaders headers = new HttpHeaders(); |
| | | headers.setContentType(MediaType.APPLICATION_OCTET_STREAM); |
| | | String encodedFilename = URLEncoder.encode("æºæå¯¼å
¥æ¨¡æ¿.xls", "UTF-8"); |
| | | String encodedFilename = URLEncoder.encode(fileName, "UTF-8"); |
| | | headers.setContentDispositionFormData("attachment", encodedFilename); |
| | | // å建InputStreamResource对象ï¼å°æä»¶è¾å
¥æµå
è£
èµ·æ¥ |
| | | InputStreamResource resourceToDownload = new InputStreamResource(inputStream); |
| | | // è¿å带ææä»¶è¾å
¥æµçResponseEntity对象 |
| | | return ResponseEntity |
| | | .status(HttpStatus.OK) |
| | | .headers(headers) |
| | | .body(resourceToDownload); |
| | | return ResponseEntity.status(HttpStatus.OK).headers(headers).body(resourceToDownload); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @return è·å项ç®å¯¼å
¥çæ¨¡æ¿ |
| | | * @throws IOException |
| | | */ |
| | | @GetMapping("getProjectImportTemplate") |
| | | public ResponseEntity<InputStreamResource> getProjectImportTemplate() throws IOException { |
| | | // ä»å½å项ç®èµæºç®å½è·åæä»¶ |
| | | Resource resource = new ClassPathResource("import/项ç®å¯¼å
¥æ¨¡æ¿.xls"); |
| | | // è·åæä»¶è¾å
¥æµ |
| | | InputStream inputStream = resource.getInputStream(); |
| | | // 设置HTTPååºå¤´ |
| | | HttpHeaders headers = new HttpHeaders(); |
| | | headers.setContentType(MediaType.APPLICATION_OCTET_STREAM); |
| | | String encodedFilename = URLEncoder.encode("项ç®å¯¼å
¥æ¨¡æ¿.xls", "UTF-8"); |
| | | headers.setContentDispositionFormData("attachment", encodedFilename); |
| | | // å建InputStreamResource对象ï¼å°æä»¶è¾å
¥æµå
è£
èµ·æ¥ |
| | | InputStreamResource resourceToDownload = new InputStreamResource(inputStream); |
| | | // è¿å带ææä»¶è¾å
¥æµçResponseEntity对象 |
| | | return ResponseEntity |
| | | .status(HttpStatus.OK) |
| | | .headers(headers) |
| | | .body(resourceToDownload); |
| | | } |
| | | |
| | | |
| | | @PostMapping("import") |
| | | public ResponseValue upload(@RequestParam Long pid, MultipartFile file) throws IOException { |
| | |
| | | throw exception; |
| | | } |
| | | if (null != finSysTenantService.queryOneByCode(finSysTenantParam.getCode())) { |
| | | throw new IllegalStateException("第" + analysisContext.readSheetHolder().getRowIndex() + "è¡,æºæç¼å·å·²åå¨"); |
| | | throw new IllegalStateException( |
| | | "第" + analysisContext.readSheetHolder().getRowIndex() + "è¡,æºæç¼å·å·²åå¨"); |
| | | } |
| | | if (StringUtils.isEmpty(finSysTenantParam.getName()) || finSysTenantParam.getName().length() > 100) { |
| | | IllegalStateException exception = new IllegalStateException( |
| | |
| | | public void onException(Exception exception, AnalysisContext context) { |
| | | // å¦ææ¯æä¸ä¸ªåå
æ ¼ç转æ¢å¼å¸¸ è½è·åå°å
·ä½è¡å· |
| | | if (exception instanceof ExcelDataConvertException) { |
| | | ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException) exception; |
| | | ExcelDataConvertException excelDataConvertException = (ExcelDataConvertException)exception; |
| | | logger.error("第{}è¡ï¼ç¬¬{}åè§£æå¼å¸¸ï¼æ°æ®ä¸º:{}", excelDataConvertException.getRowIndex(), |
| | | excelDataConvertException.getColumnIndex() + 1, excelDataConvertException.getCellData().getStringValue()); |
| | | throw new IllegalStateException( |
| | | "第" + (excelDataConvertException.getRowIndex() + 1) + "è¡ï¼ç¬¬" + (excelDataConvertException.getColumnIndex() + 1) + "åè§£æå¼å¸¸,å¼å¸¸æ°æ®ä¸º:[ " |
| | | + excelDataConvertException.getCellData().getStringValue() + " ]"); |
| | | excelDataConvertException.getColumnIndex() + 1, |
| | | excelDataConvertException.getCellData().getStringValue()); |
| | | throw new IllegalStateException("第" + (excelDataConvertException.getRowIndex() + 1) + "è¡ï¼ç¬¬" |
| | | + (excelDataConvertException.getColumnIndex() + 1) + "åè§£æå¼å¸¸,å¼å¸¸æ°æ®ä¸º:[ " |
| | | + excelDataConvertException.getCellData().getStringValue() + " ]"); |
| | | } |
| | | if (exception instanceof IllegalStateException) { |
| | | throw (IllegalStateException) exception; |
| | | throw (IllegalStateException)exception; |
| | | } |
| | | |
| | | } |
| | |
| | | if (sysInfo == null) { |
| | | return ResponseValue.error("ç»å½ç¨æ·ä¿¡æ¯ä¸åå¨"); |
| | | } |
| | | // FinSysTenant finSysTenant1 = this.finSysTenantService.selectByTenantId(sysInfo.getTenantCode()); |
| | | // if (finSysTenant1.getLv() != 1) { |
| | | // return ResponseValue.error("ææ ä¿®æ¹æé"); |
| | | // } |
| | | // FinSysTenant finSysTenant1 = this.finSysTenantService.selectByTenantId(sysInfo.getTenantCode()); |
| | | // if (finSysTenant1.getLv() != 1) { |
| | | // return ResponseValue.error("ææ ä¿®æ¹æé"); |
| | | // } |
| | | int num = this.finSysTenantService.updateFinSysTenant(param, this.getSysInfo()); |
| | | return num > 0 ? ResponseValue.success(1) : ResponseValue.error("ç¼è¾å¤±è´¥ï¼"); |
| | | } |
| | |
| | | } |
| | | // ç |
| | | FinSysTenant finSysTenant1 = this.finSysTenantService.get(new FinSysTenant(finSysTenant.getParentId())); |
| | | List<FinSysTenantUser> finSysTenantUserList = this.finSysTenantUserService.getByOrgId(finSysTenant1.getId()); |
| | | List<FinSysTenantUser> finSysTenantUserList = |
| | | this.finSysTenantUserService.getByOrgId(finSysTenant1.getId()); |
| | | if (!StringUtils.isEmptyList(finSysTenantUserList)) { |
| | | FinSysTenantUserResult finSysTenantUserResult = new FinSysTenantUserResult(); |
| | | finSysTenantUserResult.setOrgId(finSysTenant1.getId()); |
| | |
| | | } |
| | | // å¸ |
| | | FinSysTenant finSysTenant2 = this.finSysTenantService.get(new FinSysTenant(finSysTenant.getParentId())); |
| | | List<FinSysTenantUser> finSysTenantUserList2 = this.finSysTenantUserService.getByOrgId(finSysTenant2.getId()); |
| | | List<FinSysTenantUser> finSysTenantUserList2 = |
| | | this.finSysTenantUserService.getByOrgId(finSysTenant2.getId()); |
| | | if (!StringUtils.isEmptyList(finSysTenantUserList2)) { |
| | | FinSysTenantUserResult finSysTenantUserResult = new FinSysTenantUserResult(); |
| | | finSysTenantUserResult.setOrgId(finSysTenant2.getId()); |
| | |
| | | } |
| | | // ç |
| | | FinSysTenant finSysTenant1 = this.finSysTenantService.get(new FinSysTenant(finSysTenant2.getParentId())); |
| | | List<FinSysTenantUser> finSysTenantUserList = this.finSysTenantUserService.getByOrgId(finSysTenant1.getId()); |
| | | List<FinSysTenantUser> finSysTenantUserList = |
| | | this.finSysTenantUserService.getByOrgId(finSysTenant1.getId()); |
| | | if (!StringUtils.isEmptyList(finSysTenantUserList)) { |
| | | FinSysTenantUserResult finSysTenantUserResult = new FinSysTenantUserResult(); |
| | | finSysTenantUserResult.setOrgId(finSysTenant1.getId()); |
| | |
| | | |
| | | @ApiOperation(value = "è·åç¶çº§æºæ", notes = "è·åç¶çº§æºæ") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "Authorization", value = "token", dataType = "String", paramType = "header"), |
| | | }) |
| | | @ApiImplicitParam(name = "Authorization", value = "token", dataType = "String", paramType = "header"),}) |
| | | @GetMapping("/get/parent/tenant") |
| | | public ResponseValue getParentTenant() { |
| | | FinSysTenantUser sysInfo = getSysInfo(); |
| | |
| | | finSysTenant.setTempId(Long.valueOf(tenantId)); |
| | | FinSysTenant userTenant = this.finSysTenantService.get(finSysTenant); |
| | | Long parentId = userTenant.getParentId(); |
| | | //第ä¸çº§ |
| | | // 第ä¸çº§ |
| | | if (parentId == 0) { |
| | | return ResponseValue.success(userTenant); |
| | | } else { |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import cn.hutool.core.util.ReflectUtil; |
| | | import java.io.IOException; |
| | | import java.lang.reflect.Field; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.HashMap; |
| | | import java.util.HashSet; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | | import java.util.Optional; |
| | | import java.util.Set; |
| | | |
| | | import org.apache.commons.compress.utils.Lists; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestParam; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.context.AnalysisContext; |
| | | import com.alibaba.excel.event.AnalysisEventListener; |
| | |
| | | import com.consum.base.pojo.response.FinSysTenantVO; |
| | | import com.consum.base.pojo.response.UserVO; |
| | | import com.consum.base.service.FinSysTenantDepartmentService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.FinSysTenantUserServiceImpl; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantDepartment; |
| | |
| | | import com.iplatform.model.po.S_role; |
| | | import com.iplatform.model.po.S_user_core; |
| | | import com.walker.db.page.GenericPager; |
| | | import com.walker.infrastructure.utils.*; |
| | | import com.walker.infrastructure.utils.CollectionUtils; |
| | | import com.walker.infrastructure.utils.DateUtils; |
| | | import com.walker.infrastructure.utils.NumberGenerator; |
| | | import com.walker.infrastructure.utils.PhoneNumberUtils; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | | import cn.hutool.core.util.ReflectUtil; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.apache.commons.compress.utils.Lists; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.io.IOException; |
| | | import java.lang.reflect.Field; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * @Description ç³»ç»ç¨æ· |
| | |
| | | |
| | | private UserServiceImpl userService; |
| | | |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | |
| | | private RoleServiceImpl roleService; |
| | | |
| | |
| | | } |
| | | |
| | | @Autowired |
| | | public FinSysTenantUserController(FinSysTenantServiceImpl finSysTenantService, |
| | | public FinSysTenantUserController(FinSysTenantService finSysTenantService, |
| | | FinSysTenantUserServiceImpl finSysTenantUserService, RoleServiceImpl roleService) { |
| | | this.finSysTenantUserService = finSysTenantUserService; |
| | | this.finSysTenantService = finSysTenantService; |
| | |
| | | } |
| | | tenantUser.setUserPhone(encPhone); |
| | | // æä¹è·åå·¦ä¾§æºææ æ°æ® |
| | | // tenantUser.setSysDeptId(3L); // 对åºå¹³å°æºæid é»è®¤ä¸ºå¹³å°ç®¡ç |
| | | // tenantUser.setSysDeptId(3L); // 对åºå¹³å°æºæid é»è®¤ä¸ºå¹³å°ç®¡ç |
| | | this.finSysTenantUserService.insert(tenantUser); |
| | | |
| | | // æå
¥å¹³å°ç¨æ· |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import cn.afterturn.easypoi.excel.ExcelExportUtil; |
| | | import cn.afterturn.easypoi.excel.entity.TemplateExportParams; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | | import java.util.Optional; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | |
| | | import org.apache.poi.ss.usermodel.Workbook; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.core.utils.CommonUtil; |
| | | import com.consum.base.core.utils.PageUtil; |
| | |
| | | import com.walker.infrastructure.utils.CollectionUtils; |
| | | import com.walker.infrastructure.utils.DateUtils; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | | import cn.afterturn.easypoi.excel.ExcelExportUtil; |
| | | import cn.afterturn.easypoi.excel.entity.TemplateExportParams; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiResponse; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | | import java.util.Optional; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import org.apache.poi.ss.usermodel.Workbook; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | /** |
| | | * @Description çç¹ |
| | |
| | | @Autowired |
| | | private FinSysTenantUserServiceImpl finSysTenantUserService; |
| | | |
| | | |
| | | /** |
| | | * @Description æ°å¢ |
| | | * @Author å¢åºé³ |
| | | * @Date 2023/10/31 |
| | | */ |
| | | @ApiOperation(value = "æ°å¢çç¹", notes = "æ°å¢çç¹") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "FormInventoryParam") |
| | | }) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "FormInventoryParam")}) |
| | | @PostMapping("/add") |
| | | public ResponseValue add() { |
| | | |
| | |
| | | if (sysInfo == null) { |
| | | return ResponseValue.error("ç»å½ç¨æ·ä¿¡æ¯ä¸åå¨"); |
| | | } |
| | | //æ ¹æ®çç¹äººidæ¥è¯¢çç¹äºº |
| | | // æ ¹æ®çç¹äººidæ¥è¯¢çç¹äºº |
| | | // çç¹äººid为sysUserIdåæ®µæ¥è¯¢ |
| | | FinSysTenantUser finSysTenantUser = new FinSysTenantUser(); |
| | | finSysTenantUser.setId(param.getOperatorUserId()); |
| | | FinSysTenantUser operatorUser = finSysTenantUserService.get(finSysTenantUser); |
| | | //æ ¹æ®çç人idæ¥è¯¢çç人 |
| | | finSysTenantUser.setSysUserId(param.getOperatorUserId()); |
| | | FinSysTenantUser operatorUser = |
| | | finSysTenantUserService.select(finSysTenantUser).stream().findFirst().orElse(null); |
| | | // æ ¹æ®çç人idæ¥è¯¢çç人 |
| | | FinSysTenantUser monitorUserInfo = new FinSysTenantUser(); |
| | | monitorUserInfo.setId(param.getMonitorUserId()); |
| | | FinSysTenantUser monitorUser = finSysTenantUserService.get(monitorUserInfo); |
| | |
| | | * @Date 2023/10/31 |
| | | */ |
| | | @ApiOperation(value = "çç¹åå表æ¥è¯¢", notes = "çç¹åå表æ¥è¯¢") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹æ¡ä»¶", dataType = "LWhFormInventoryParam", required = true, paramType = "query") |
| | | }) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "çç¹æ¡ä»¶", dataType = "LWhFormInventoryParam", |
| | | required = true, paramType = "query")}) |
| | | @GetMapping("/list") |
| | | public ResponseValue queryList() { |
| | | LWhFormInventoryQry param = CommonUtil.getObjFromReq(LWhFormInventoryQry.class); |
| | |
| | | |
| | | @ApiOperation(value = "çç¹åç©åå表æ¥è¯¢", notes = "çç¹åç©åå表æ¥è¯¢", response = FormInventoryVO.class) |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query") |
| | | }) |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query")}) |
| | | @ApiResponse(code = 200, message = "æå", response = FormInventoryVO.class) |
| | | @GetMapping("/query") |
| | | public ResponseValue queryInventBaseGoodTemplate(Long id) { |
| | |
| | | if (id == null) { |
| | | return ResponseValue.error("åæ°ä¸è½ä¸ºç©º"); |
| | | } |
| | | //éè¿æºææ¥è¯¢ç¸å
³ç模æ¿ä¿¡æ¯ |
| | | // éè¿æºææ¥è¯¢ç¸å
³ç模æ¿ä¿¡æ¯ |
| | | FormInventoryVO formInventoryVO = lWhFormInventoryService.queryInventBaseGoodTemplate(id); |
| | | |
| | | // ä¿ååè¿åè®°å½ä¿¡æ¯ |
| | |
| | | * @Date 2023/10/31 |
| | | */ |
| | | @ApiOperation(value = "ç¼è¾çç¹", notes = "ç¼è¾çç¹") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "FormInventoryParam") |
| | | }) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "FormInventoryParam")}) |
| | | @PostMapping("/edit") |
| | | public ResponseValue edit() { |
| | | FormInventoryParam param = CommonUtil.getObjFromReqBody(FormInventoryParam.class); |
| | |
| | | return ResponseValue.error("ç¼è¾å¤±è´¥ï¼"); |
| | | } |
| | | |
| | | //æ ¹æ®çç¹äººidæ¥è¯¢çç¹äºº |
| | | // æ ¹æ®çç¹äººidæ¥è¯¢çç¹äºº |
| | | FinSysTenantUser finSysTenantUser = new FinSysTenantUser(); |
| | | finSysTenantUser.setId(param.getOperatorUserId()); |
| | | FinSysTenantUser operatorUser = finSysTenantUserService.get(finSysTenantUser); |
| | | //æ ¹æ®çç人idæ¥è¯¢çç人 |
| | | // æ ¹æ®çç人idæ¥è¯¢çç人 |
| | | FinSysTenantUser monitorUserInfo = new FinSysTenantUser(); |
| | | monitorUserInfo.setId(param.getMonitorUserId()); |
| | | FinSysTenantUser monitorUser = finSysTenantUserService.get(monitorUserInfo); |
| | |
| | | */ |
| | | @ApiOperation(value = "æ ¹æ®idå é¤çç¹", notes = "æ ¹æ®idå é¤çç¹") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query") |
| | | }) |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query")}) |
| | | @DeleteMapping("/del") |
| | | public ResponseValue delById(Long id) { |
| | | if (id == null) { |
| | |
| | | return ResponseValue.success(1); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * æå |
| | | * |
| | |
| | | * @date 2023/10/31 |
| | | */ |
| | | @ApiOperation(value = "çç¹æå", notes = "çç¹æå") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "LWhFormInventoryDto") |
| | | }) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "LWhFormInventoryDto")}) |
| | | @PostMapping("/temporary/storage") |
| | | public ResponseValue updateTemporaryStorage() { |
| | | LWhFormInventoryParam param = CommonUtil.getObjFromReqBody(LWhFormInventoryParam.class); |
| | |
| | | * @date 2023/10/31 |
| | | */ |
| | | @ApiOperation(value = "宿çç¹", notes = "宿çç¹") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "LWhFormInventoryDto") |
| | | }) |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "çç¹åä¿¡æ¯", dataType = "LWhFormInventoryDto")}) |
| | | @PostMapping("/finish") |
| | | public ResponseValue updateFinishPd() { |
| | | LWhFormInventoryParam param = CommonUtil.getObjFromReqBody(LWhFormInventoryParam.class); |
| | |
| | | */ |
| | | @ApiOperation(value = "å¼å¸¸æç»å表æ¥è¯¢", notes = "å¼å¸¸æç»å表æ¥è¯¢") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "param", value = "çç¹æ¡ä»¶", dataType = "LWhFormInventoryParam", paramType = "query") |
| | | }) |
| | | @ApiImplicitParam(name = "param", value = "çç¹æ¡ä»¶", dataType = "LWhFormInventoryParam", paramType = "query")}) |
| | | @GetMapping("/list/PdDetail") |
| | | public ResponseValue queryPdDetailList() { |
| | | LWhFormInventoryQry param = CommonUtil.getObjFromReq(LWhFormInventoryQry.class); |
| | |
| | | |
| | | @ApiOperation(value = "æ ¹æ®idæ¥è¯¢çç¹ç©å详ç»ä¿¡æ¯", notes = "æ ¹æ®idæ¥è¯¢çç¹ç©å详ç»ä¿¡æ¯") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "id", value = "çç¹id", dataType = "Long", required = true, paramType = "query") |
| | | }) |
| | | @ApiImplicitParam(name = "id", value = "çç¹id", dataType = "Long", required = true, paramType = "query")}) |
| | | @GetMapping("/detail") |
| | | public ResponseValue selectDetailById(Long id) { |
| | | FinSysTenantUser sysInfo = this.getSysInfo(); |
| | |
| | | |
| | | @ApiOperation(value = "çç¹å导åº", notes = "çç¹å导åº") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query") |
| | | }) |
| | | @ApiImplicitParam(name = "id", value = "çç¹åid", dataType = "Long", required = true, paramType = "query")}) |
| | | @GetMapping("/list/export") |
| | | public void export(Long id, HttpServletResponse response) throws Exception { |
| | | public String export(Long id, HttpServletResponse response) throws Exception { |
| | | |
| | | List<InventoryExcelTemplate> exportList = lWhFormInventoryService.getExportList(id); |
| | | if (CollectionUtils.isEmpty(exportList)) { |
| | |
| | | map.put("endDate", DateUtils.toShowDate(endTime)); |
| | | map.put("monitorName", monitorName); |
| | | map.put("name", operatorName); |
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, InventoryExcelTemplate.class, |
| | | exportList, map); |
| | | |
| | | downLoadExcel("ä½å¼æèåçç¹è¡¨", response, workbook); |
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, InventoryExcelTemplate.class, exportList, map); |
| | | return downLoadExcel("ä½å¼æèåçç¹è¡¨", response, workbook); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | |
| | | package com.consum.base.controller; |
| | | |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.service.LWhFormInventoryGoodsServiceImpl; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.po.LWhFormInventoryGoods; |
| | | import com.walker.web.ResponseValue; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import java.util.List; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import com.consum.base.BaseController; |
| | | import com.consum.base.service.LWhFormInventoryGoodsService; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.consum.model.po.LWhFormInventoryGoods; |
| | | import com.walker.web.ResponseValue; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | |
| | | /** |
| | | * @Description çç¹åç©å |
| | |
| | | public class LWhFormInventoryGoodsController extends BaseController { |
| | | |
| | | @Autowired |
| | | private LWhFormInventoryGoodsServiceImpl inventoryGoodsService; |
| | | private LWhFormInventoryGoodsService inventoryGoodsService; |
| | | |
| | | /** |
| | | * @return |
| | |
| | | if (id == null) { |
| | | ResponseValue.error("åæ°é误"); |
| | | } |
| | | List<LWhFormInventoryGoods> list = this.inventoryGoodsService.getByInventoryId(id); |
| | | List<LWhFormInventoryGoods> list = inventoryGoodsService.getByInventoryId(id); |
| | | return ResponseValue.success(list); |
| | | } |
| | | |
| | |
| | | @ApiOperation(value = "åºåºå导åº", notes = "åºåºå导åº") |
| | | @ApiImplicitParam(name = "id", value = "åºåºåid", required = true, dataType = "Long", paramType = "query") |
| | | @GetMapping("/list/export") |
| | | public void export(Long id, HttpServletResponse response) throws Exception { |
| | | public String export(Long id, HttpServletResponse response) throws Exception { |
| | | FinSysTenantUser sysInfo = this.getSysInfo(); |
| | | if (sysInfo == null) { |
| | | throw new RuntimeException("ç»å½ç¨æ·ä¿¡æ¯ä¸åå¨"); |
| | |
| | | map.put("totalAmount", totalAmount); |
| | | |
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, OutputExcelTemplate.class, exportList, map); |
| | | downLoadExcel("åºåºå", response, workbook); |
| | | return downLoadExcel("åºåºå", response, workbook); |
| | | |
| | | } |
| | | |
| | |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(name = "id", value = "éè´åid", required = true, dataType = "Long", paramType = "query")}) |
| | | @GetMapping("/list/export") |
| | | public void export(Long id, HttpServletResponse response) throws Exception { |
| | | public String export(Long id, HttpServletResponse response) throws Exception { |
| | | TemplateExportParams params = new TemplateExportParams("import/éè´å
¥åºå.xls"); |
| | | params.setHeadingStartRow(2); |
| | | FinSysTenantUser sysInfo = this.getSysInfo(); |
| | |
| | | map.put("totalAmount", totalAmount); |
| | | |
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, ProcureExcelTemplate.class, exportList, map); |
| | | downLoadExcel("éè´å
¥åºå", response, workbook); |
| | | return downLoadExcel("éè´å
¥åºå", response, workbook); |
| | | |
| | | } |
| | | } |
| | |
| | | @ApiOperation(value = "å¯¼åºæ¥åºå", notes = "å¯¼åºæ¥åºå") |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "id", value = "æ¥åºåid", dataType = "Long", paramType = "query")}) |
| | | @GetMapping("/list/export") |
| | | public void export(Long id, HttpServletResponse response) throws Exception { |
| | | public String export(Long id, HttpServletResponse response) throws Exception { |
| | | if (id == null) { |
| | | throw new RuntimeException("æ¥åºåid为空"); |
| | | } |
| | |
| | | map.put("totalAmount", totalAmount); |
| | | |
| | | Workbook sheets = ExcelExportUtil.exportExcel(exportParams, ScrappedInfoExcelTemplate.class, export, map); |
| | | downLoadExcel("æ¥åºç»è®°å", response, sheets); |
| | | return downLoadExcel("æ¥åºç»è®°å", response, sheets); |
| | | |
| | | } |
| | | |
| | |
| | | @ApiImplicitParams({@ApiImplicitParam(name = "id", value = "è°æ¨åid", required = true, dataType = "Long"), |
| | | @ApiImplicitParam(name = "type", value = "导åºç±»å 1 å
¥åº 2 åºåº", required = true, dataType = "Integer"),}) |
| | | @GetMapping("/list/export") |
| | | public void export(Long id, Integer type, HttpServletResponse response) throws Exception { |
| | | public String export(Long id, Integer type, HttpServletResponse response) throws Exception { |
| | | |
| | | TemplateExportParams params; |
| | | String fileName; |
| | |
| | | map.put("totalAmount", totalAmount); |
| | | |
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, TransferExcelTemplate.class, export, map); |
| | | downLoadExcel(fileName, response, workbook); |
| | | return downLoadExcel(fileName, response, workbook); |
| | | |
| | | } |
| | | |
New file |
| | |
| | | package com.consum.base.core.type; |
| | | |
| | | /** |
| | | * InventoryResultType |
| | | * |
| | | * @author asus |
| | | * @version 2023/12/11 10:32 |
| | | **/ |
| | | public enum InventoryResultType { |
| | | /** |
| | | * æ£å¸¸ |
| | | */ |
| | | NORMAL(1, "æ£å¸¸"), |
| | | /** |
| | | * çç |
| | | */ |
| | | SURPLUS(2, "çç"), |
| | | |
| | | /** |
| | | * çäº |
| | | */ |
| | | LOSS(3, "çäº"); |
| | | |
| | | private Integer value; |
| | | |
| | | private String desc; |
| | | |
| | | InventoryResultType(Integer value, String desc) { |
| | | this.value = value; |
| | | this.desc = desc; |
| | | } |
| | | |
| | | public Integer getValue() { |
| | | return value; |
| | | } |
| | | |
| | | public void setValue(Integer value) { |
| | | this.value = value; |
| | | } |
| | | |
| | | public String getDesc() { |
| | | return desc; |
| | | } |
| | | |
| | | public void setDesc(String desc) { |
| | | this.desc = desc; |
| | | } |
| | | } |
| | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: 使ç¨è®°å½ä¿¡æ¯ |
| | | * @date 2023/11/8 15:20 |
| | | */ |
| | | @Data |
| | | public class RecordUserInfoVO { |
| | | //以åçè®°å½id |
| | | // 以åçè®°å½id |
| | | private Long oldProcureModelId; |
| | | |
| | | // 使ç¨äºº |
| | |
| | | package com.consum.base.pojo; |
| | | |
| | | import java.util.List; |
| | | |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: 使ç¨è®°å½ååä¿¡æ¯ |
| | | * @date 2023/11/8 15:20 |
| | | */ |
| | | @Data |
| | | public class UseRecordSkuVO { |
| | | |
| | | |
| | | // åå·id |
| | | private Long procureModelId; |
| | |
| | | // 计éåä½ |
| | | private String unit; |
| | | |
| | | |
| | | private List<RecordUserInfoVO> recordUserInfos; |
| | | |
| | | |
| | | } |
New file |
| | |
| | | package com.consum.base.pojo.excel; |
| | | |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: 导å
¥ç©åä¿¡æ¯ |
| | | * @date 2023/12/11 14:25 |
| | | */ |
| | | @Data |
| | | public class ImportGoodsInfoTemplate { |
| | | |
| | | @ExcelProperty("ä¸çº§åç±»") |
| | | private String categoryOne; |
| | | @ExcelProperty("äºçº§åç±»") |
| | | private String categoryTwo; |
| | | @ExcelProperty("ä¸çº§åç±»") |
| | | private String categoryThree; |
| | | @ExcelProperty("ç©ååç§°") |
| | | private String goodName; |
| | | @ExcelProperty("è§æ ¼åå·") |
| | | private String goodModel; |
| | | @ExcelProperty("åä½") |
| | | private String unit; |
| | | @ExcelProperty("éè´ç±»å") |
| | | private String type; |
| | | @ExcelProperty("æå±æºæ") |
| | | private String agencyName; |
| | | |
| | | } |
| | |
| | | package com.consum.base.pojo.request; |
| | | |
| | | import io.swagger.annotations.ApiModel; |
| | | import java.util.List; |
| | | |
| | | import io.swagger.annotations.ApiModel; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: é¨é¨éåç©åä¿¡æ¯ |
| | | * @date 2023/12/1 13:16 |
| | | */ |
| | | @Data |
| | | @ApiModel |
| | | public class UsingFormBackGoodsInfo { |
| | | |
| | | //åç±»ç¼å· |
| | | // åç±»ç¼å· |
| | | private Long baseCategoryId; |
| | | //ç©å模çç¼å· |
| | | // ç©å模çç¼å· |
| | | private Long baseGoodsTemplateId; |
| | | //ç©å模çåå |
| | | // ç©å模çåå |
| | | private String goodsTemplateName; |
| | | //åååid |
| | | // åååid |
| | | private Long transBusinessId; |
| | | //åååç¼å· |
| | | // åååç¼å· |
| | | private String businessFormCode; |
| | | |
| | | private List<baseGoodModel> models; |
| | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: é¨é¨ç©å模æ¿ä¿¡æ¯ |
| | | * @date 2023/12/1 13:21 |
| | | */ |
| | | @Data |
| | |
| | | private Integer userUseCount; |
| | | private Integer goodsNum; |
| | | private Integer counts; |
| | | |
| | | |
| | | } |
| | |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: é¨é¨åç¨æ·ä¿¡æ¯ |
| | | * @date 2023/11/16 16:57 |
| | | */ |
| | | @Data |
| | |
| | | private String name; |
| | | private String type; |
| | | private List<UserVO> children = new ArrayList<>(); |
| | | |
| | | |
| | | } |
| | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: æ¥åºåå表 |
| | | * @date 2023/11/22 16:29 |
| | | */ |
| | | @Data |
| | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: åºå
¥åºæç»ä¿¡æ¯ |
| | | * @date 2023/11/28 11:25 |
| | | */ |
| | | @NoArgsConstructor |
| | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: ç¨æ·ä¿¡æ¯ |
| | | * @date 2023/11/16 16:57 |
| | | */ |
| | | @Data |
| | |
| | | private Long id; |
| | | private String name; |
| | | private String type; |
| | | |
| | | |
| | | } |
| | |
| | | package com.consum.base.pojo.response; |
| | | |
| | | import java.util.List; |
| | | |
| | | import lombok.Data; |
| | | import lombok.NoArgsConstructor; |
| | | |
| | | /** |
| | | * @author asus |
| | | * @version 1.0 |
| | | * @description: TODO |
| | | * @description: é¨é¨éååæ® |
| | | * @date 2023/12/1 17:12 |
| | | */ |
| | | @NoArgsConstructor |
| | |
| | | private String businessFormCode; |
| | | private String operatorName; |
| | | |
| | | private List<GoodsTemplateCountVO> goodsTemplateInfoList; |
| | | private List<GoodsTemplateCountVO> goodsTemplateInfoList; |
| | | } |
New file |
| | |
| | | package com.consum.base.service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.consum.base.pojo.FinSysTenantParam; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.walker.jdbc.service.BaseService; |
| | | |
| | | /** |
| | | * FinSysTenantService |
| | | * |
| | | * @author asus |
| | | * @version 2023/12/11 17:14 |
| | | **/ |
| | | public interface FinSysTenantService extends BaseService { |
| | | FinSysTenant queryOneByCode(String code); |
| | | |
| | | List<FinSysTenant> queryForTree(); |
| | | |
| | | List<FinSysTenant> queryTreeById(Long id, Integer lv); |
| | | |
| | | Map<Long, List<FinSysTenant>> queryCountyByCityCode(Long id, Integer lv); |
| | | |
| | | int updateById(FinSysTenantParam param, FinSysTenantUser sysInfo); |
| | | |
| | | int addFinSysTenant(FinSysTenantParam param, FinSysTenantUser sysInfo, int lv); |
| | | |
| | | void setLvIdAndName(FinSysTenantParam param, FinSysTenant finSysTenant, long id, int lv); |
| | | |
| | | void insertFinSysTenantBatch(List<FinSysTenantParam> params, FinSysTenantUser sysInfo, int lv); |
| | | |
| | | int updateFinSysTenant(FinSysTenant finSysTenant, FinSysTenantUser sysInfo); |
| | | |
| | | FinSysTenant selectById(Long id); |
| | | |
| | | FinSysTenant selectByName(String tenantName); |
| | | } |
New file |
| | |
| | | package com.consum.base.service; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.consum.base.pojo.response.FormInventoryGoodsVO; |
| | | import com.consum.model.po.LWhFormInventoryGoods; |
| | | import com.walker.jdbc.service.BaseService; |
| | | |
| | | /** |
| | | * LWhFormInventoryGoodsService |
| | | * |
| | | * @author asus |
| | | * @version 2023/12/11 10:28 |
| | | **/ |
| | | public interface LWhFormInventoryGoodsService extends BaseService { |
| | | /** |
| | | * æ ¹æ®çç¹åidæ¥è¯¢çç¹ç©å |
| | | * |
| | | * @param id |
| | | * @return |
| | | */ |
| | | List<LWhFormInventoryGoods> getByInventoryId(Long id); |
| | | |
| | | /** |
| | | * æå
¥çç¹ç©åä¿¡æ¯ |
| | | * |
| | | * @param inventoryGoodsList |
| | | * @param inventoryId |
| | | * @return |
| | | */ |
| | | List<FormInventoryGoodsVO> add(List<FormInventoryGoodsVO> inventoryGoodsList, Long inventoryId); |
| | | |
| | | /** |
| | | * æ¹éæ´æ°çç¹ç©åä¿¡æ¯ |
| | | * |
| | | * @param inventoryGoodsList |
| | | * @return |
| | | */ |
| | | int updateInventoryGoods(List<FormInventoryGoodsVO> inventoryGoodsList); |
| | | } |
| | |
| | | import com.consum.base.pojo.BaseWarehouseParam; |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.FinSysTenantDepartmentService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.SDictDataServiceImpl; |
| | | import com.consum.model.po.BaseWarehouse; |
| | | import com.consum.model.po.FinSysTenant; |
| | |
| | | @Autowired |
| | | private CodeGeneratorService codeGeneratorService; |
| | | @Autowired |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | @Autowired |
| | | private FinSysTenantDepartmentService departmentService; |
| | | @Autowired |
File was renamed from consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java |
| | |
| | | package com.consum.base.service; |
| | | package com.consum.base.service.impl; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import com.consum.base.pojo.FinSysTenantParam; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | | import com.walker.infrastructure.utils.CollectionUtils; |
| | | import com.walker.infrastructure.utils.DateUtils; |
| | | import com.walker.infrastructure.utils.StringUtils; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.stream.Collectors; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | @Service |
| | | public class FinSysTenantServiceImpl extends BaseServiceImpl { |
| | | public class FinSysTenantServiceImpl extends BaseServiceImpl implements FinSysTenantService { |
| | | |
| | | private static final String QUERY_TREE_ALL = "select * from FIN_SYS_TENANT where is_delete = 0 and status = 1 order by parent_id, LV ASC"; |
| | | private static final String QUERY_TREE_ALL = |
| | | "select * from FIN_SYS_TENANT where is_delete = 0 and status = 1 order by parent_id, LV ASC"; |
| | | private static final String QUERY_TREE_BY_CODE = "SELECT * FROM FIN_SYS_TENANT "; |
| | | private static final String QUERY_LIST_BY_CITY_CODE = "SELECT ID, NAME, CODE, CASE WHEN LV = 2 THEN ID ELSE PARENT_ID END AS PARENT_ID, LV, TENANT_TYPE, BELONG_PROVINCE FROM FIN_SYS_TENANT "; |
| | | private static final String QUERY_LV2_ALL = "SELECT * FROM FIN_SYS_TENANT WHERE LV < 3 ORDER BY CODE ASC"; |
| | | private static final String QUERY_LIST_BY_CITY_CODE = |
| | | "SELECT ID, NAME, CODE, CASE WHEN LV = 2 THEN ID ELSE PARENT_ID END AS PARENT_ID, LV, TENANT_TYPE, BELONG_PROVINCE FROM FIN_SYS_TENANT "; |
| | | |
| | | /** |
| | | * @Author ï¼power |
| | | * @Date ï¼ 2023/7/20 20:41 è·ååºåä¿¡æ¯ ä¸»è¦ç¨äºç¼å |
| | | */ |
| | | @Override |
| | | public FinSysTenant queryOneByCode(String code) { |
| | | FinSysTenant tenant = new FinSysTenant(); |
| | | tenant.setCode(code); |
| | |
| | | return null; |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public List<FinSysTenant> queryForTree() { |
| | | // å±ç¤ºå
¨é¨èç¹ |
| | | return this.select(QUERY_TREE_ALL, new Object[]{}, new FinSysTenant()); |
| | | return this.select(QUERY_TREE_ALL, new Object[] {}, new FinSysTenant()); |
| | | } |
| | | |
| | | /** |
| | | * @Author ï¼power |
| | | * @Date ï¼ 2023/7/20 16:34 æ ¹æ®id æ¥è¯¢ä¸çº§ææèç¹ å°å¸æ¥è¯¢èªå·± çæ¥è¯¢ææå°å¸ |
| | | */ |
| | | @Override |
| | | public List<FinSysTenant> queryTreeById(Long id, Integer lv) { |
| | | if (lv == 3) { |
| | | return new ArrayList<>(); |
| | |
| | | * @Author ï¼power |
| | | * @Date ï¼ 2023/7/21 14:46 ç¹æ®æ°æ® ç¦æ¢å
¶ä»æ¥å£ä½¿ç¨ |
| | | */ |
| | | @Override |
| | | public Map<Long, List<FinSysTenant>> queryCountyByCityCode(Long id, Integer lv) { |
| | | Map<String, Object> parameter = new HashMap<>(5); |
| | | StringBuilder sql = new StringBuilder(QUERY_LIST_BY_CITY_CODE); |
| | |
| | | } |
| | | sql.append(" ORDER BY PARENT_ID ,ID "); |
| | | List<FinSysTenant> list = this.select(sql.toString(), parameter, new FinSysTenant()); |
| | | // return list.stream().filter(tenant -> Objects.nonNull(tenant.getParentId())).collect(Collectors.groupingBy(FinSysTenant::getParentId)); |
| | | // return list.stream().filter(tenant -> |
| | | // Objects.nonNull(tenant.getParentId())).collect(Collectors.groupingBy(FinSysTenant::getParentId)); |
| | | return list.stream().collect(Collectors.groupingBy(FinSysTenant::getParentId)); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * @Description æ¥è¯¢ææçå¸çº§å¸¦æ²³åççåºå |
| | | * @Author wh |
| | | * @Date 2023/7/20 15:29 |
| | | */ |
| | | public List<FinSysTenant> selectByLV2() { |
| | | return this.select(QUERY_LV2_ALL, new Object[]{}, new FinSysTenant()); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * å é¤ |
| | |
| | | * @author å¢åºé³ |
| | | * @date 2023/10/4 |
| | | */ |
| | | @Override |
| | | public int updateById(FinSysTenantParam param, FinSysTenantUser sysInfo) { |
| | | FinSysTenant finSysTenant = new FinSysTenant(); |
| | | finSysTenant.setTempId(param.getId()); |
| | |
| | | return this.update(finSysTenant); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * æ·»å æºæ |
| | | * |
| | | * @author å¢åºé³ |
| | | * @date 2023/10/4 |
| | | */ |
| | | @Override |
| | | public int addFinSysTenant(FinSysTenantParam param, FinSysTenantUser sysInfo, int lv) { |
| | | FinSysTenant finSysTenant = new FinSysTenant(); |
| | | |
| | | //idåtempId |
| | | // idåtempId |
| | | StringBuilder sql = new StringBuilder("SELECT max(id) FROM fin_sys_tenant WHERE 1=1"); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | |
| | |
| | | List<Map<String, Object>> list = this.select(sql.toString(), paramts); |
| | | long id = 0L; |
| | | if (!CollectionUtils.isEmpty(list) && list.get(0).get("max(id)") != null) { |
| | | id = (Long) list.get(0).get("max(id)") + 1; |
| | | id = (Long)list.get(0).get("max(id)") + 1; |
| | | } else { |
| | | id = param.getParentId() * 1000 + 1; |
| | | } |
| | |
| | | |
| | | finSysTenant.setParentId(param.getParentId()); |
| | | finSysTenant.setCode(param.getCode()); |
| | | //设置详ç»å°ååç»çº¬åº¦ |
| | | // 设置详ç»å°ååç»çº¬åº¦ |
| | | finSysTenant.setName(param.getName()); |
| | | finSysTenant.setCreateTime3(DateUtils.getDate("yyyy-MM-dd HH:mm:ss")); |
| | | finSysTenant.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); |
| | | finSysTenant.setSummary(param.getSummary()); |
| | | finSysTenant.setCreateBy(sysInfo.getUserName()); |
| | | //设置åå±çº§idååç§° |
| | | // 设置åå±çº§idååç§° |
| | | finSysTenant.setLv(lv); |
| | | setLvIdAndName(param, finSysTenant, id, lv); |
| | | |
| | |
| | | * @author å¢åºé³ |
| | | * @date 2023/10/4 |
| | | */ |
| | | private void setLvIdAndName(FinSysTenantParam param, FinSysTenant finSysTenant, long id, int lv) { |
| | | if (lv == 2) { //æ°å¢å¸çº§æºæ |
| | | //æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | @Override |
| | | public void setLvIdAndName(FinSysTenantParam param, FinSysTenant finSysTenant, long id, int lv) { |
| | | if (lv == 2) { // æ°å¢å¸çº§æºæ |
| | | // æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | FinSysTenant finSysTenant1 = this.get(new FinSysTenant(param.getParentId())); |
| | | if (finSysTenant1 != null) { |
| | | finSysTenant.setLv1Id(finSysTenant1.getId()); |
| | |
| | | finSysTenant.setLv2Id(id); |
| | | finSysTenant.setLv2Name(param.getName()); |
| | | } |
| | | } else if (lv == 3) { //æ°å¢å¿çº§æºæ |
| | | //æ¥è¯¢ä¸ä¸çº§ - å¸çº§ |
| | | } else if (lv == 3) { // æ°å¢å¿çº§æºæ |
| | | // æ¥è¯¢ä¸ä¸çº§ - å¸çº§ |
| | | FinSysTenant finSysTenant2 = this.get(new FinSysTenant(param.getParentId())); |
| | | if (finSysTenant2 != null) { |
| | | //æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | // æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | FinSysTenant finSysTenant1 = this.get(new FinSysTenant(finSysTenant2.getParentId())); |
| | | |
| | | finSysTenant.setLv1Id(finSysTenant1.getId()); |
| | |
| | | finSysTenant.setLv3Id(id); |
| | | finSysTenant.setLv3Name(param.getName()); |
| | | } |
| | | } else if (lv == 4) { //æ°å¢æ¯å±æºæ |
| | | //æ¥è¯¢ä¸ä¸çº§ - å¿çº§ |
| | | } else if (lv == 4) { // æ°å¢æ¯å±æºæ |
| | | // æ¥è¯¢ä¸ä¸çº§ - å¿çº§ |
| | | FinSysTenant finSysTenant3 = this.get(new FinSysTenant(param.getParentId())); |
| | | if (finSysTenant3 != null) { |
| | | //æ¥è¯¢ä¸ä¸çº§ - å¸çº§ |
| | | // æ¥è¯¢ä¸ä¸çº§ - å¸çº§ |
| | | FinSysTenant finSysTenant2 = this.get(new FinSysTenant(finSysTenant3.getParentId())); |
| | | if (finSysTenant2 != null) { |
| | | //æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | // æ¥è¯¢ä¸ä¸çº§ - ç级 |
| | | FinSysTenant sysTenant1 = this.get(new FinSysTenant(finSysTenant2.getParentId())); |
| | | if (sysTenant1 != null) { |
| | | finSysTenant.setLv1Id(sysTenant1.getId()); |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * æ¹éæ·»å æºæ |
| | | * |
| | | * @author jlq |
| | | * @date 2023/10/9 |
| | | */ |
| | | @Override |
| | | public void insertFinSysTenantBatch(List<FinSysTenantParam> params, FinSysTenantUser sysInfo, int lv) { |
| | | for (FinSysTenantParam param : params) { |
| | | addFinSysTenant(param, sysInfo, lv); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * ç¼è¾ |
| | |
| | | * @author å¢åºé³ |
| | | * @date 2023/10/6 |
| | | */ |
| | | @Override |
| | | public int updateFinSysTenant(FinSysTenant finSysTenant, FinSysTenantUser sysInfo) { |
| | | Integer lv = finSysTenant.getLv(); |
| | | if (lv == 1) { |
| | |
| | | return this.update(finSysTenant); |
| | | } |
| | | |
| | | @Override |
| | | public FinSysTenant selectById(Long id) { |
| | | FinSysTenant tenant = new FinSysTenant(); |
| | | tenant.setTempId(id); |
| | | return this.get(tenant); |
| | | } |
| | | |
| | | @Override |
| | | public FinSysTenant selectByName(String tenantName) { |
| | | FinSysTenant tenant = new FinSysTenant(); |
| | | tenant.setName(tenantName); |
| | | return this.select(tenant).stream().findFirst().orElse(null); |
| | | } |
| | | } |
| | |
| | | import com.consum.base.core.utils.IdUtil; |
| | | import com.consum.base.service.BaseGoodsTemplateService; |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.LWhFormInventoryGoodsServiceImpl; |
| | | import com.consum.base.service.LWhFormInventoryGoodsService; |
| | | import com.consum.base.service.LWhFormInventoryService; |
| | | import com.consum.base.service.LWhFormOutputService; |
| | | import com.consum.base.service.LWhFormProcureGoodsService; |
| | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public class LWhFormInventoryCoreService { |
| | | |
| | | private LWhFormInventoryGoodsServiceImpl lWhFormInventoryGoods; |
| | | private LWhFormInventoryGoodsService lWhFormInventoryGoods; |
| | | private LWhFormOutputCoreService lWhFormOutputCoreService; |
| | | private CodeGeneratorService codeGeneratorService; |
| | | private LWhFormProcureService lWhFormProcureServiceImpl; |
| | |
| | | private LWhFormOutputService lWhFormOutputService; |
| | | |
| | | @Autowired |
| | | public LWhFormInventoryCoreService(LWhFormInventoryGoodsServiceImpl lWhFormInventoryGoods, |
| | | public LWhFormInventoryCoreService(LWhFormInventoryGoodsService lWhFormInventoryGoods, |
| | | LWhFormOutputCoreService lWhFormOutputCoreService, |
| | | CodeGeneratorService codeGeneratorService, |
| | | LWhFormProcureService lWhFormProcureServiceImpl, |
File was renamed from consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java |
| | |
| | | package com.consum.base.service; |
| | | package com.consum.base.service.impl; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | |
| | | import org.springframework.transaction.annotation.Propagation; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import com.consum.base.core.type.InventoryResultType; |
| | | import com.consum.base.core.utils.IdUtil; |
| | | import com.consum.base.pojo.response.FormInventoryGoodsVO; |
| | | import com.consum.base.service.LWhFormInventoryGoodsService; |
| | | import com.consum.model.po.LWhFormInventoryGoods; |
| | | import com.walker.jdbc.service.BaseServiceImpl; |
| | | |
| | |
| | | @Slf4j |
| | | @Service |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public class LWhFormInventoryGoodsServiceImpl extends BaseServiceImpl { |
| | | public class LWhFormInventoryGoodsServiceImpl extends BaseServiceImpl implements LWhFormInventoryGoodsService { |
| | | |
| | | /** |
| | | * @return |
| | | * @Description æ ¹æ®çç¹åidæ¥è¯¢çç¹åç©å |
| | | * @Author å¢åºé³ |
| | | * @Date 2023/10/31 |
| | | */ |
| | | @Override |
| | | public List<LWhFormInventoryGoods> getByInventoryId(Long id) { |
| | | LWhFormInventoryGoods inventoryGoods = new LWhFormInventoryGoods(); |
| | | inventoryGoods.setWhFormInventoryId(id); |
| | | return this.select(inventoryGoods); |
| | | } |
| | | |
| | | @Override |
| | | public List<FormInventoryGoodsVO> add(List<FormInventoryGoodsVO> inventoryGoodsList, Long inventoryId) { |
| | | List<LWhFormInventoryGoods> goodsList = new ArrayList<>(); |
| | | for (FormInventoryGoodsVO inventoryGoods : inventoryGoodsList) { |
| | |
| | | return inventoryGoodsList; |
| | | } |
| | | |
| | | @Override |
| | | public int updateInventoryGoods(List<FormInventoryGoodsVO> inventoryGoodsList) { |
| | | List<LWhFormInventoryGoods> goodsList = new ArrayList<>(); |
| | | for (FormInventoryGoodsVO inventoryGoods : inventoryGoodsList) { |
| | |
| | | lWhFormInventoryGoods.setInventoryCounts(realNum); |
| | | lWhFormInventoryGoods.setErrorCounts(Math.abs(errorCount)); |
| | | // çç¹ç»æï¼1=æ£å¸¸ï¼2=ççï¼3=çäºï¼ |
| | | lWhFormInventoryGoods.setInventoryResult((errorCount > 0) ? 2 : (errorCount < 0) ? 3 : 1); |
| | | // TODO æ¹éæ´æ° |
| | | this.update(lWhFormInventoryGoods); |
| | | // goodsList.add(lWhFormInventoryGoods); |
| | | lWhFormInventoryGoods.setInventoryResult((errorCount > 0) ? InventoryResultType.SURPLUS.getValue() |
| | | : (errorCount < 0) ? InventoryResultType.LOSS.getValue() : InventoryResultType.NORMAL.getValue()); |
| | | // this.update(lWhFormInventoryGoods); |
| | | goodsList.add(lWhFormInventoryGoods); |
| | | } |
| | | |
| | | } |
| | | this.updateBatch(goodsList); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | package com.consum.base.service.impl; |
| | | |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.LWhFormInventoryGoodsServiceImpl; |
| | | import com.consum.base.service.LWhFormInventoryService; |
| | | import com.consum.base.service.LWhGoodsService; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | import com.consum.base.pojo.response.FormInventoryDetailVO; |
| | | import com.consum.base.pojo.response.FormInventoryGoodsVO; |
| | | import com.consum.base.pojo.response.FormInventoryVO; |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.LWhFormInventoryGoodsService; |
| | | import com.consum.base.service.LWhFormInventoryService; |
| | | import com.consum.base.service.LWhGoodsService; |
| | | import com.consum.model.po.BaseWarehouse; |
| | | import com.consum.model.po.FinSysTenant; |
| | | import com.consum.model.po.FinSysTenantUser; |
| | |
| | | @Autowired |
| | | private BaseWarehouseService baseWarehouseService; |
| | | @Autowired |
| | | private LWhFormInventoryGoodsServiceImpl inventoryGoodsService; |
| | | private LWhFormInventoryGoodsService inventoryGoodsService; |
| | | @Autowired |
| | | private LWhGoodsService lWhGoodsService; |
| | | @Autowired |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | @Autowired |
| | | @Lazy |
| | | private LWhFormInventoryCoreService lWhFormInventoryCoreService; |
| | |
| | | log.error("çç¹åç©å为空"); |
| | | return 0; |
| | | } |
| | | this.inventoryGoodsService.updateInventoryGoods(inventoryGoodsList); |
| | | inventoryGoodsService.updateInventoryGoods(inventoryGoodsList); |
| | | // ä¿®æ¹çç¹å |
| | | if (state == 2) { |
| | | // 宿çç¹æ¶è®¾ç½®å®æçç¹æ¶é´ |
| | |
| | | import com.consum.base.pojo.response.LWHFromTransferExtendVO; |
| | | import com.consum.base.service.BaseWarehouseManagerService; |
| | | import com.consum.base.service.BaseWarehouseService; |
| | | import com.consum.base.service.FinSysTenantServiceImpl; |
| | | import com.consum.base.service.FinSysTenantService; |
| | | import com.consum.base.service.LWhFormTransferService; |
| | | import com.consum.base.service.LWhGoodsService; |
| | | import com.consum.base.service.LWhProcureModelService; |
| | |
| | | @Autowired |
| | | private CodeGeneratorService codeGeneratorService; |
| | | @Autowired |
| | | private FinSysTenantServiceImpl finSysTenantService; |
| | | private FinSysTenantService finSysTenantService; |
| | | @Autowired |
| | | private LWhGoodsService lWhGoodsService; |
| | | @Autowired |