| ¶Ô±ÈÐÂÎļþ |
| | |
| | | //package org.jeecg.modules.base.controller; |
| | | // |
| | | //import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | //import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
| | | //import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
| | | //import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | //import org.jeecg.common.system.query.QueryGenerator; |
| | | //import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | //import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | //import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | //import lombok.extern.slf4j.Slf4j; |
| | | //import org.jeecg.common.system.base.controller.JeecgController; |
| | | //import org.jeecg.common.api.vo.Result; |
| | | //import org.jeecg.modules.base.entity.*; |
| | | //import org.jeecg.modules.base.service.*; |
| | | //import org.jeecg.modules.quartz.entity.QuartzJob; |
| | | //import org.jeecg.modules.quartz.service.IQuartzJobService; |
| | | //import org.jeecg.common.system.base.entity.DataVersion; |
| | | //import org.jeecg.modules.system.service.IDataVersionService; |
| | | //import org.jeecg.modules.system.service.ISysUserService; |
| | | //import org.springframework.beans.factory.annotation.Autowired; |
| | | //import org.springframework.transaction.annotation.Transactional; |
| | | //import org.springframework.web.bind.annotation.*; |
| | | //import javax.servlet.http.HttpServletRequest; |
| | | //import javax.servlet.http.HttpServletResponse; |
| | | //import org.springframework.web.servlet.ModelAndView; |
| | | // |
| | | //import java.text.ParseException; |
| | | //import java.time.LocalDateTime; |
| | | //import java.time.format.DateTimeFormatter; |
| | | //import java.util.*; |
| | | // |
| | | //import org.jeecg.common.util.oConvertUtils; |
| | | //import io.swagger.annotations.Api; |
| | | //import io.swagger.annotations.ApiOperation; |
| | | //import org.jeecg.common.aspect.annotation.AutoLog; |
| | | //import org.apache.shiro.SecurityUtils; |
| | | //import org.jeecg.common.system.vo.LoginUser; |
| | | //import org.jeecgframework.poi.excel.ExcelImportUtil; |
| | | //import org.jeecgframework.poi.excel.def.NormalExcelConstants; |
| | | //import org.jeecgframework.poi.excel.entity.ExportParams; |
| | | //import org.jeecgframework.poi.excel.entity.ImportParams; |
| | | //import org.jeecgframework.poi.excel.view.JeecgEntityExcelView; |
| | | //import org.springframework.web.multipart.MultipartFile; |
| | | //import org.springframework.web.multipart.MultipartHttpServletRequest; |
| | | //import java.io.IOException; |
| | | //import java.util.stream.Collectors; |
| | | // |
| | | // /** |
| | | // * @Description: ä»åº |
| | | // * @Author: jeecg-boot |
| | | // * @Date: 2022-11-07 |
| | | // * @Version: V1.0 |
| | | // */ |
| | | //@Api(tags="ä»åºç®¡ç") |
| | | //@RestController |
| | | // @RequestMapping("/base/warehouse") |
| | | //@Slf4j |
| | | //public class WarehouseController extends JeecgController<Warehouse, IWarehouseService> { |
| | | // |
| | | // @Autowired |
| | | // private IWarehouseService warehouseService; |
| | | // |
| | | // @Autowired |
| | | // private IWarehouseClientService warehouseClientService; |
| | | // |
| | | // @Autowired |
| | | // private IEnterpriseService enterpriseService; |
| | | // |
| | | // @Autowired |
| | | // private ISysUserService sysUserService; |
| | | // |
| | | // @Autowired |
| | | // private IDataVersionService dataVersionService; |
| | | // |
| | | // @Autowired |
| | | // private IQuartzJobService quartzJobService; |
| | | // |
| | | // @Autowired |
| | | // private IWarehouseAreaService warehouseAreaService; |
| | | // |
| | | // @Autowired |
| | | // private IWarehouseLocationService warehouseLocationService; |
| | | // |
| | | // |
| | | // /*---------------------------------主表å¤ç-begin-------------------------------------*/ |
| | | // /** |
| | | // * è·ååå§ä¿¡æ¯ |
| | | // * |
| | | // * |
| | | // */ |
| | | // @GetMapping("/getWarehouseInfo") |
| | | // public Result<?> getFactoryInfo(){ |
| | | // Map<String,Object> infoMap = new HashMap<>(2); |
| | | // LoginUser loginUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); |
| | | //// infoMap.put("enterpriseId",loginUser.getEnterpriseId()); |
| | | //// infoMap.put("version",warehouseService.getInitVersion()); |
| | | // return Result.OK(infoMap); |
| | | // } |
| | | // /** |
| | | // * è¡¨åæ ¡éª |
| | | // */ |
| | | // @GetMapping("/check") |
| | | // public Result<?> check(@RequestParam(name="name",required = false) String name, |
| | | // @RequestParam(name="enterpriseId",required = false) String enterpriseId, |
| | | // @RequestParam(name="version",required = false) Integer version |
| | | // ){ |
| | | // QueryWrapper<Warehouse> queryWrapper = new QueryWrapper<>(); |
| | | // if(!StringUtils.isBlank(name)){ |
| | | // queryWrapper.eq("name",name); |
| | | // } |
| | | // if(!StringUtils.isBlank(enterpriseId)){ |
| | | // queryWrapper.eq("enterprise_id",enterpriseId); |
| | | // } |
| | | // if(version!=null){ |
| | | // queryWrapper.eq("version",version); |
| | | // } |
| | | // queryWrapper.eq("del_flag","0"); |
| | | // return Result.OK(warehouseService.list(queryWrapper)); |
| | | // } |
| | | // /** |
| | | // * å页å表æ¥è¯¢ |
| | | // * @param map |
| | | // * @param pageNo |
| | | // * @param pageSize |
| | | // * @param version |
| | | // * @param enterpriseId |
| | | // * @return |
| | | // */ |
| | | // //@AutoLog(value = "ä»åº-å页å表æ¥è¯¢") |
| | | // @ApiOperation(value="ä»åº-å页å表æ¥è¯¢", notes="ä»åº-å页å表æ¥è¯¢") |
| | | // @GetMapping("/list") |
| | | // public Result<?> list(Map map, |
| | | // @RequestParam(name ="pageNo", defaultValue="1") Integer pageNo, |
| | | // @RequestParam(name ="pageSize", defaultValue="10") Integer pageSize, |
| | | // @RequestParam(name = "enterpriseId",required = false) String enterpriseId, |
| | | // @RequestParam(name="version",required = false) Integer version){ |
| | | // Page<Map<String,Object>> page = new Page(pageNo, pageSize); |
| | | // IPage<Map<String,Object>> pageList = warehouseService.getWarehouseList(page,version,enterpriseId); |
| | | // return Result.OK(pageList); |
| | | // } |
| | | // /** |
| | | // * è·åå½åçæçæ¬åä¸ä¸æ¬¡çæçæ¬ççæ¬å· |
| | | // * |
| | | // * @return |
| | | // */ |
| | | // @GetMapping("/getNowAndLastUsableVersion") |
| | | // public Result<?> getNowAndLastUsableVersion(){ |
| | | // return Result.OK(warehouseService.getNowAndLastUsableVersion()); |
| | | // } |
| | | // /** |
| | | // * è·åææçæ¬å· |
| | | // * |
| | | // * |
| | | // */ |
| | | // @GetMapping("/getVersionList") |
| | | // public Result<?> getAllVersion(){ |
| | | // return Result.OK(warehouseService.getVersionList()); |
| | | // } |
| | | // /** |
| | | // * æ ¹æ®çæ¬è·åçæ¬å· |
| | | // * @param version |
| | | // * @return |
| | | // * |
| | | // */ |
| | | // @GetMapping("/getVersionStatusByVersion") |
| | | // public Result<?> getVersionStatusByVersion(@RequestParam(value = "version",required = false) Integer version){ |
| | | // return Result.OK(warehouseService.getVersionStatusByVersion(version)); |
| | | // } |
| | | // /** |
| | | // * |
| | | // * æ¥è¯¥çæ¬æ¯å¦ä¸ºåå²çæ¬ |
| | | // * |
| | | // */ |
| | | // @GetMapping(value = "/getUpdateVersionPermission") |
| | | // public Result<?> getUpdatePermission(@RequestParam("version") Integer version){ |
| | | // List<String> usableEnterpriseIds = enterpriseService.getUsableIdList(); |
| | | // return Result.OK(warehouseService.list(new QueryWrapper<Warehouse>() |
| | | // .in("enterprise_id",usableEnterpriseIds) |
| | | // .eq("version",version) |
| | | // .eq("del_flag",0))); |
| | | // } |
| | | // /** |
| | | // * |
| | | // * æ¥å½åçæä¼ä¸ä¸ææ ä»åºåå²çæ¬ |
| | | // * |
| | | // */ |
| | | // @GetMapping(value = "/getNewVersionPermission") |
| | | // public Result<?> getNewVersionPermission(){ |
| | | // List<String> usableEnterpriseIds = enterpriseService.getUsableIdList(); |
| | | // return Result.OK(warehouseService.list(new QueryWrapper<Warehouse>().in("enterprise_id",usableEnterpriseIds).eq("del_flag",0))); |
| | | // } |
| | | // /** |
| | | // * ç»´æ¤åç |
| | | // * éè¦ä¸æ¬¡å®æ |
| | | // * @param |
| | | // * @return |
| | | // */ |
| | | // @PostMapping("/updateVersionForChange") |
| | | // @Transactional |
| | | // public Result<?> updateVersionForChange(){ |
| | | // Set<Integer> set = warehouseService.getVersionList(); |
| | | // return Result.OK(set.stream().findFirst().get()+1); |
| | | // } |
| | | // /** |
| | | // * æ·»å |
| | | // * @param map |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åº-æ·»å ") |
| | | // @ApiOperation(value="ä»åº-æ·»å ", notes="ä»åº-æ·»å ") |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:add") |
| | | // @PostMapping(value = "/add") |
| | | // public Result<String> add(@RequestBody Map<String,Object> map) { |
| | | // Warehouse warehouse = new Warehouse(); |
| | | // warehouse.setCode(String.valueOf(map.get("code"))) |
| | | // .setName(String.valueOf(map.get("name"))) |
| | | // .setVersion(Integer.parseInt(String.valueOf(map.get("version")))) |
| | | // .setEnterpriseId(String.valueOf(map.get("enterpriseId"))) |
| | | // .setRemark(String.valueOf(map.get("remark"))) |
| | | // .setStatus(String.valueOf(map.get("status"))) |
| | | // .setDelFlag(0); |
| | | // warehouseService.save(warehouse); |
| | | // QueryWrapper<Warehouse> queryWrapper = new QueryWrapper<Warehouse>() |
| | | // .eq("code",warehouse.getCode()) |
| | | // .eq("version",warehouse.getVersion()) |
| | | // .eq("del_flag",0); |
| | | // Warehouse selectWarehouse = warehouseService.getOne(queryWrapper,true); |
| | | // DataVersion dataVersion = new DataVersion(); |
| | | // dataVersion.setBusinessId(selectWarehouse.getId()) |
| | | // .setBusinessType("ä»åºç®¡ç") |
| | | // .setVersion(selectWarehouse.getVersion()) |
| | | // .setVersionStatus(String.valueOf(map.get("versionStatus"))) |
| | | // .setDelFlag(0) |
| | | // .setEffectiveType("0") |
| | | // .setIsLastUsable("0"); |
| | | // dataVersionService.save(dataVersion); |
| | | // QueryWrapper<DataVersion> queryWrapper1 = new QueryWrapper<DataVersion>() |
| | | // .eq("business_id",selectWarehouse.getId()).eq("del_flag",0); |
| | | // DataVersion selectDataVersion = dataVersionService.getOne(queryWrapper1,true); |
| | | // selectWarehouse.setDataVersionId(selectDataVersion.getId()); |
| | | // warehouseService.saveOrUpdate(selectWarehouse); |
| | | // return Result.OK("æ·»å æåï¼"); |
| | | // } |
| | | // /** |
| | | // * åç |
| | | // * éè¦ä¸æ¬¡å®æ |
| | | // * @param map |
| | | // * @param |
| | | // * @return |
| | | // */ |
| | | // @PostMapping("/updateVersion") |
| | | // @Transactional |
| | | // public Result<?> updateVersion(@RequestBody Map<String,Object> map){ |
| | | // Integer version = Integer.parseInt((String)map.get("version")); |
| | | // //è·ååçæ°æ® |
| | | // List<Warehouse> list = warehouseService.list(new QueryWrapper<Warehouse>() |
| | | // .eq("version",version) |
| | | // .eq("del_flag",0)); |
| | | // //è·ååçæ°æ®ççæ¬ä¿¡æ¯ |
| | | // QueryWrapper<DataVersion> queryWrapper = new QueryWrapper<DataVersion>() |
| | | // .in("business_id", list.stream().map(Warehouse::getId).collect(Collectors.toList())) |
| | | // .eq("del_flag",0); |
| | | // List<DataVersion> dataVersionList = dataVersionService.list(queryWrapper); |
| | | // Set<Integer> set = warehouseService.getVersionList(); |
| | | // Optional<Integer> maxVersion = set.stream().findFirst(); |
| | | // list.stream().forEach(warehouse -> { |
| | | // warehouse.setId(""); |
| | | // warehouse.setVersion(maxVersion.get()+1); |
| | | // }); |
| | | // warehouseService.saveBatch(list); |
| | | // List<Warehouse> newList = warehouseService |
| | | // .list(new QueryWrapper<Warehouse>() |
| | | // .eq("version",maxVersion.get()+1)); |
| | | // List<DataVersion> newDataVersionList = new ArrayList<>(); |
| | | // for(int i=0;i<newList.size();i++){ |
| | | // DataVersion dataVersion = new DataVersion(); |
| | | // for(int j=0;j<list.size();j++){ |
| | | // for(int k=0;k<dataVersionList.size();k++){ |
| | | // if(list.get(j).getCode().equals(newList.get(i).getCode()) |
| | | // &&list.get(j).getDataVersionId().equals(dataVersionList.get(k).getId())) { |
| | | // dataVersion |
| | | // .setVersion(maxVersion.get() + 1) |
| | | // .setVersionStatus("1") |
| | | // .setBusinessId(newList.get(i).getId()) |
| | | // .setDelFlag(0) |
| | | // .setSourceVersionId(dataVersionList.get(k).getId()) |
| | | // .setBusinessType("ä»åºç®¡ç") |
| | | // .setIsLastUsable("0"); |
| | | // } |
| | | // } |
| | | // } |
| | | // newDataVersionList.add(dataVersion); |
| | | // } |
| | | // dataVersionService.saveBatch(newDataVersionList); |
| | | // List<String> dataVersionBusinessIdList = newDataVersionList.stream().map(DataVersion::getBusinessId).collect(Collectors.toList()); |
| | | // QueryWrapper<DataVersion> queryWrapper1 = new QueryWrapper<DataVersion>().in("business_id",dataVersionBusinessIdList).eq("del_flag",0); |
| | | // List<DataVersion> selectDataVersionList = dataVersionService.list(queryWrapper1); |
| | | // for(int i=0;i<newList.size();i++){ |
| | | // for(int j=0;j<selectDataVersionList.size();j++){ |
| | | // if(newList.get(i).getId().equals(selectDataVersionList.get(j).getBusinessId())){ |
| | | // newList.get(i).setDataVersionId(selectDataVersionList.get(j).getId()); |
| | | // } |
| | | // } |
| | | // } |
| | | // warehouseService.updateBatchById(newList); |
| | | // return Result.OK(maxVersion.get()+1); |
| | | // } |
| | | // /** |
| | | // * çæ |
| | | // * éè¦ä¸æ¬¡æ§å®æ |
| | | // * @param |
| | | // * @param map |
| | | // * @return |
| | | // */ |
| | | // @PostMapping("/updateVersionStatusToUsable") |
| | | // @Transactional |
| | | // public Result<?> updateVersionStatusToUsable(@RequestBody Map<String,Object> map){ |
| | | // Date date = new Date(System.currentTimeMillis()); |
| | | // QuartzJob quartzJob = quartzJobService.getOne(new QueryWrapper<QuartzJob>() |
| | | // .eq("job_class_name","org.jeecg.modules.quartz.job.WarehouseSetUsableJob"),true); |
| | | // if(ObjectUtils.isNotNull(quartzJob)){ |
| | | // quartzJobService.deleteAndStopJob(quartzJob); |
| | | // } |
| | | // Integer version = Integer.parseInt((String)map.get("version")); |
| | | // //è·å䏿¬¡çæçæ¬å¹¶å°å
¶æ¯å¦ä¸æ¬¡çæä½ç½®ç½®ä¸ºå¦ |
| | | // List<Warehouse> lastUsableList = warehouseService.getLastUsableList(); |
| | | // if(CollectionUtils.isNotEmpty(lastUsableList)){ |
| | | // QueryWrapper<DataVersion> queryWrapper2 = new QueryWrapper<DataVersion>() |
| | | // .in("business_id",lastUsableList.stream() |
| | | // .map(Warehouse::getId) |
| | | // .collect(Collectors.toList())); |
| | | // List<DataVersion> lastUsableVersionList = dataVersionService.list(queryWrapper2); |
| | | // lastUsableVersionList.stream().forEach(dataVersion -> { |
| | | // dataVersion |
| | | // .setIsLastUsable("0"); |
| | | // }); |
| | | // dataVersionService.updateBatchById(lastUsableVersionList); |
| | | // } |
| | | // //è·åçæçæ¬åçæ¬ä¿¡æ¯å¹¶å°å
¶ç½®ä¸ºå¤±æ |
| | | // List<Warehouse> usableList = warehouseService.getUsableList(); |
| | | // if(CollectionUtils.isNotEmpty(usableList)){ |
| | | // QueryWrapper<DataVersion> queryWrapper = new QueryWrapper<DataVersion>() |
| | | // .in("business_id",usableList.stream() |
| | | // .map(Warehouse::getId) |
| | | // .collect(Collectors.toList())); |
| | | // List<DataVersion> usableDataVersionList = dataVersionService.list(queryWrapper); |
| | | // usableDataVersionList.stream().forEach(dataVersion -> { |
| | | // dataVersion |
| | | // .setVersionStatus("3") |
| | | // .setIsLastUsable("1") |
| | | // .setExpiredTime(date); |
| | | // }); |
| | | // dataVersionService.updateBatchById(usableDataVersionList); |
| | | // } |
| | | // //è·åå¾
çæçæ¬åçæ¬ä¿¡æ¯å¹¶å°å
¶ç½®ä¸ºçæ |
| | | // QueryWrapper<DataVersion> queryWrapper1 = new QueryWrapper<DataVersion>() |
| | | // .in("business_id",warehouseService.list(new QueryWrapper<Warehouse>() |
| | | // .eq("version",version) |
| | | // .eq("del_flag",0)) |
| | | // .stream().map(Warehouse::getId) |
| | | // .collect(Collectors.toList())); |
| | | // List<DataVersion> dataVersionList = dataVersionService.list(queryWrapper1); |
| | | // dataVersionList.stream().forEach(dataVersion -> { |
| | | // dataVersion.setVersionStatus("2") |
| | | // .setEffectiveType("2") |
| | | // .setEffectiveTime(date) |
| | | // .setIsLastUsable("0"); |
| | | // }); |
| | | // //åå
¥æ°æ®åº |
| | | // dataVersionService.updateBatchById(dataVersionList); |
| | | // return Result.OK("çææå"); |
| | | // } |
| | | // /** |
| | | // * 宿¶çæ |
| | | // * éè¦ä¸æ¬¡æ§å®æ |
| | | // * @param quartzJob |
| | | // * @param |
| | | // * @return |
| | | // */ |
| | | // @PostMapping("/updateVersionStatusToUsableBySetTime") |
| | | // @Transactional |
| | | // public Result<?> updateVersionStatusToUsableBySetTime(@RequestBody QuartzJob quartzJob) throws ParseException { |
| | | // DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); |
| | | // DateTimeFormatter dateTimeFormatter1 = DateTimeFormatter.ofPattern("ss mm HH dd MM ? yyyy"); |
| | | // String jobClassName = quartzJob.getJobClassName(); |
| | | // String time = quartzJob.getCronExpression(); |
| | | // System.out.println(time); |
| | | // LocalDateTime localDateTime = LocalDateTime.parse(time,dateTimeFormatter); |
| | | // String cronStr=dateTimeFormatter1.format(localDateTime); |
| | | // quartzJob.setCronExpression(cronStr); |
| | | // QueryWrapper<QuartzJob> queryWrapper = new QueryWrapper(); |
| | | // queryWrapper.eq("JOB_CLASS_NAME",jobClassName); |
| | | // List<QuartzJob> quartzJobs = quartzJobService.list(queryWrapper); |
| | | // if(CollectionUtils.isEmpty(quartzJobs)){ |
| | | // quartzJobService.saveAndScheduleJob(quartzJob); |
| | | // quartzJobs = quartzJobService.list(queryWrapper); |
| | | // quartzJob.setId(quartzJobs.get(0).getId()); |
| | | // quartzJobService.resumeJob(quartzJob); |
| | | // return Result.OK(quartzJob); |
| | | // }else{ |
| | | // quartzJob.setId(quartzJobs.get(0).getId()); |
| | | // quartzJobService.resumeJob(quartzJob); |
| | | // return Result.OK(quartzJob); |
| | | // } |
| | | // |
| | | // } |
| | | // |
| | | // /** |
| | | // * ç¼è¾ |
| | | // * @param warehouse |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åº-ç¼è¾") |
| | | // @ApiOperation(value="ä»åº-ç¼è¾", notes="ä»åº-ç¼è¾") |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:edit") |
| | | // @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | // public Result<String> edit(@RequestBody Warehouse warehouse) { |
| | | // warehouseService.updateById(warehouse); |
| | | // return Result.OK("ç¼è¾æå!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * éè¿idå é¤ |
| | | // * @param id |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åº-éè¿idå é¤") |
| | | // @ApiOperation(value="ä»åº-éè¿idå é¤", notes="ä»åº-éè¿idå é¤") |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:delete") |
| | | // @DeleteMapping(value = "/delete") |
| | | // public Result<String> delete(@RequestParam(name="id",required=true) String id) { |
| | | // dataVersionService.update(new UpdateWrapper<DataVersion>() |
| | | // .set("del_flag",1) |
| | | // .eq("business_id",id)); |
| | | // UpdateWrapper updateWrapper = new UpdateWrapper(); |
| | | // updateWrapper.set("del_flag","1"); |
| | | // updateWrapper.eq("id",id); |
| | | // warehouseService.update(updateWrapper); |
| | | // return Result.OK("å 餿å!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * æ¹éå é¤ |
| | | // * @param ids |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åº-æ¹éå é¤") |
| | | // @ApiOperation(value="ä»åº-æ¹éå é¤", notes="ä»åº-æ¹éå é¤") |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:deleteBatch") |
| | | // @DeleteMapping(value = "/deleteBatch") |
| | | // public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) { |
| | | // dataVersionService.update(new UpdateWrapper<DataVersion>() |
| | | // .set("del_flag",1) |
| | | // .in("business_id",Arrays.asList(ids.split(",")))); |
| | | // warehouseService |
| | | // .update(new UpdateWrapper<Warehouse>() |
| | | // .in("id",Arrays.asList(ids.split(","))).set("del_flag",1)); |
| | | // return Result.OK("æ¹éå 餿å!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * å¯¼åº |
| | | // * @return |
| | | // */ |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:exportXls") |
| | | // @RequestMapping(value = "/exportXls") |
| | | // public ModelAndView exportXls(HttpServletRequest request, Warehouse warehouse) { |
| | | // return super.exportXls(request, warehouse, Warehouse.class, "ä»åº"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * 导å
¥ |
| | | // * @return |
| | | // */ |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:importExcel") |
| | | // @RequestMapping(value = "/importExcel", method = RequestMethod.POST) |
| | | // public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { |
| | | // return super.importExcel(request, response, Warehouse.class); |
| | | // } |
| | | // /*---------------------------------主表å¤ç-end-------------------------------------*/ |
| | | // |
| | | // |
| | | // /*--------------------------------å表å¤ç-ä»åºæå¡å¯¹è±¡-begin----------------------------------------------*/ |
| | | // /** |
| | | // * éè¿ä¸»è¡¨IDæ¥è¯¢ |
| | | // * @return |
| | | // */ |
| | | // @GetMapping("/checkWarehouseClient") |
| | | // public Result<?> checkClient( |
| | | // @RequestParam(name="clientId",required = false) String clientId, |
| | | // @RequestParam(name="warehouseId") String warehouseId){ |
| | | // QueryWrapper<WarehouseClient> queryWrapper = new QueryWrapper<>(); |
| | | // if(!StringUtils.isBlank(clientId)){ |
| | | // queryWrapper.eq("client_id",clientId); |
| | | // } |
| | | // if(!StringUtils.isBlank(warehouseId)){ |
| | | // queryWrapper.eq("warehouse_id",warehouseId); |
| | | // } |
| | | // queryWrapper.eq("del_flag","0"); |
| | | // return Result.OK(warehouseClientService.list(queryWrapper)); |
| | | // } |
| | | // /** |
| | | // * éè¿ä¸»è¡¨IDæ¥è¯¢ |
| | | // * @return |
| | | // */ |
| | | // //@AutoLog(value = "ä»åºæå¡å¯¹è±¡-éè¿ä¸»è¡¨IDæ¥è¯¢") |
| | | // @ApiOperation(value="ä»åºæå¡å¯¹è±¡-éè¿ä¸»è¡¨IDæ¥è¯¢", notes="ä»åºæå¡å¯¹è±¡-éè¿ä¸»è¡¨IDæ¥è¯¢") |
| | | // @GetMapping(value = "/listWarehouseClientByMainId") |
| | | // public Result<IPage<WarehouseClient>> listWarehouseClientByMainId(WarehouseClient warehouseClient, |
| | | // @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, |
| | | // @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, |
| | | // HttpServletRequest req) { |
| | | // QueryWrapper<WarehouseClient> queryWrapper = QueryGenerator.initQueryWrapper(warehouseClient, req.getParameterMap()); |
| | | // queryWrapper.eq("del_flag",0); |
| | | // Page<WarehouseClient> page = new Page<WarehouseClient>(pageNo, pageSize); |
| | | // IPage<WarehouseClient> pageList = warehouseClientService.page(page, queryWrapper); |
| | | // return Result.OK(pageList); |
| | | // } |
| | | // |
| | | // /** |
| | | // * æ·»å |
| | | // * @param map |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åºæå¡å¯¹è±¡-æ·»å ") |
| | | // @ApiOperation(value="ä»åºæå¡å¯¹è±¡-æ·»å ", notes="ä»åºæå¡å¯¹è±¡-æ·»å ") |
| | | // @PostMapping(value = "/addWarehouseClient") |
| | | // public Result<String> addWarehouseClient(@RequestBody Map<String,Object> map) { |
| | | // List<Map<String,Object>> addDepartIds = (List<Map<String, Object>>) map.get("addDepartIds"); |
| | | // List<Map<String,Object>> addFactoryIds = (List<Map<String, Object>>) map.get("addFactoryIds"); |
| | | // String warehouseId = (String) map.get("warehouseId"); |
| | | // if(CollectionUtils.isNotEmpty(addDepartIds)){ |
| | | // List<WarehouseClient> warehouseClients=new ArrayList<>(); |
| | | // addDepartIds.forEach(departMap->{ |
| | | // WarehouseClient warehouseClient = new WarehouseClient(); |
| | | // warehouseClient.setClientId((String) departMap.get("id")) |
| | | // .setWarehouseId(warehouseId) |
| | | // .setCode((String) departMap.get("orgCode")) |
| | | // .setName((String) departMap.get("departName")) |
| | | // .setElementType("ç»ç»é¨é¨") |
| | | // .setDelFlag(0); |
| | | // warehouseClients.add(warehouseClient); |
| | | // }); |
| | | // warehouseClientService.saveBatch(warehouseClients); |
| | | // } |
| | | // |
| | | // if(CollectionUtils.isNotEmpty(addFactoryIds)){ |
| | | // List<WarehouseClient> warehouseClients=new ArrayList<>(); |
| | | // addFactoryIds.forEach(factoryMap->{ |
| | | // WarehouseClient warehouseClient = new WarehouseClient(); |
| | | // warehouseClient.setClientId((String) factoryMap.get("id")) |
| | | // .setWarehouseId(warehouseId) |
| | | // .setCode((String) factoryMap.get("code")) |
| | | // .setName((String) factoryMap.get("name")) |
| | | // .setElementType("å·¥å") |
| | | // .setDelFlag(0); |
| | | // warehouseClients.add(warehouseClient); |
| | | // }); |
| | | // warehouseClientService.saveBatch(warehouseClients); |
| | | // } |
| | | // return Result.OK("æ·»å æåï¼"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * ç¼è¾ |
| | | // * @param map |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åºæå¡å¯¹è±¡-ç¼è¾") |
| | | // @ApiOperation(value="ä»åºæå¡å¯¹è±¡-ç¼è¾", notes="ä»åºæå¡å¯¹è±¡-ç¼è¾") |
| | | // @RequestMapping(value = "/editWarehouseClient", method = {RequestMethod.PUT,RequestMethod.POST}) |
| | | // public Result<String> editWarehouseClient(@RequestBody Map<String,Object> map) { |
| | | // List<Map<String,Object>> addDepartIds = (List<Map<String, Object>>) map.get("addDepartIds"); |
| | | // List<Map<String,Object>> addFactoryIds = (List<Map<String, Object>>) map.get("addFactoryIds"); |
| | | // String id = (String) map.get("id"); |
| | | // if(CollectionUtils.isNotEmpty(addDepartIds)){ |
| | | // UpdateWrapper<WarehouseClient> updateWrapper = new UpdateWrapper<WarehouseClient>() |
| | | // .eq("id",id) |
| | | // .set("code",(String)addDepartIds.get(0).get("orgCode")) |
| | | // .set("name",(String) addDepartIds.get(0).get("departName")); |
| | | // warehouseClientService.update(updateWrapper); |
| | | // } |
| | | // |
| | | // if(CollectionUtils.isNotEmpty(addFactoryIds)){ |
| | | // UpdateWrapper<WarehouseClient> updateWrapper = new UpdateWrapper<WarehouseClient>() |
| | | // .eq("id",id) |
| | | // .set("code",(String)addFactoryIds.get(0).get("code")) |
| | | // .set("name",(String)addFactoryIds.get(0).get("name")); |
| | | // warehouseClientService.update(updateWrapper); |
| | | // } |
| | | // return Result.OK("ç¼è¾æå!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * éè¿idå é¤ |
| | | // * @param id |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åºæå¡å¯¹è±¡-éè¿idå é¤") |
| | | // @ApiOperation(value="ä»åºæå¡å¯¹è±¡-éè¿idå é¤", notes="ä»åºæå¡å¯¹è±¡-éè¿idå é¤") |
| | | // @DeleteMapping(value = "/deleteWarehouseClient") |
| | | // public Result<String> deleteWarehouseClient(@RequestParam(name="id",required=true) String id) { |
| | | // warehouseClientService.update( new UpdateWrapper<WarehouseClient>() |
| | | // .set("del_flag",1) |
| | | // .eq("id",id)); |
| | | // return Result.OK("å 餿å!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * æ¹éå é¤ |
| | | // * @param ids |
| | | // * @return |
| | | // */ |
| | | // @AutoLog(value = "ä»åºæå¡å¯¹è±¡-æ¹éå é¤") |
| | | // @ApiOperation(value="ä»åºæå¡å¯¹è±¡-æ¹éå é¤", notes="ä»åºæå¡å¯¹è±¡-æ¹éå é¤") |
| | | // @DeleteMapping(value = "/deleteBatchWarehouseClient") |
| | | // public Result<String> deleteBatchWarehouseClient(@RequestParam(name="ids",required=true) String ids) { |
| | | // warehouseClientService.update(new UpdateWrapper<WarehouseClient>() |
| | | // .in("id",Arrays.asList(ids.split(","))) |
| | | // .set("del_flag",1)); |
| | | // return Result.OK("å 餿å"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * å¯¼åº |
| | | // * @return |
| | | // */ |
| | | // @RequestMapping(value = "/exportWarehouseClient") |
| | | // public ModelAndView exportWarehouseClient(HttpServletRequest request, WarehouseClient warehouseClient) { |
| | | // // Step.1 ç»è£
æ¥è¯¢æ¡ä»¶ |
| | | // QueryWrapper<WarehouseClient> queryWrapper = QueryGenerator.initQueryWrapper(warehouseClient, request.getParameterMap()); |
| | | // LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal(); |
| | | // |
| | | // // Step.2 è·åå¯¼åºæ°æ® |
| | | // List<WarehouseClient> pageList = warehouseClientService.list(queryWrapper); |
| | | // List<WarehouseClient> exportList = null; |
| | | // |
| | | // // è¿æ»¤é䏿°æ® |
| | | // String selections = request.getParameter("selections"); |
| | | // if (oConvertUtils.isNotEmpty(selections)) { |
| | | // List<String> selectionList = Arrays.asList(selections.split(",")); |
| | | // exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList()); |
| | | // } else { |
| | | // exportList = pageList; |
| | | // } |
| | | // |
| | | // // Step.3 AutoPoi 导åºExcel |
| | | // ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); |
| | | // //æ¤å¤è®¾ç½®çfilenameæ æ,å端ä¼éæ´æ°è®¾ç½®ä¸ä¸ |
| | | // mv.addObject(NormalExcelConstants.FILE_NAME, "ä»åºæå¡å¯¹è±¡"); |
| | | // mv.addObject(NormalExcelConstants.CLASS, WarehouseClient.class); |
| | | // mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("ä»åºæå¡å¯¹è±¡æ¥è¡¨", "导åºäºº:" + sysUser.getRealname(), "ä»åºæå¡å¯¹è±¡")); |
| | | // mv.addObject(NormalExcelConstants.DATA_LIST, exportList); |
| | | // return mv; |
| | | // } |
| | | // |
| | | // /** |
| | | // * 导å
¥ |
| | | // * @return |
| | | // */ |
| | | // @RequestMapping(value = "/importWarehouseClient/{mainId}") |
| | | // public Result<?> importWarehouseClient(HttpServletRequest request, HttpServletResponse response, @PathVariable("mainId") String mainId) { |
| | | // MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request; |
| | | // Map<String, MultipartFile> fileMap = multipartRequest.getFileMap(); |
| | | // for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) { |
| | | // // è·åä¸ä¼ æä»¶å¯¹è±¡ |
| | | // MultipartFile file = entity.getValue(); |
| | | // ImportParams params = new ImportParams(); |
| | | // params.setTitleRows(2); |
| | | // params.setHeadRows(1); |
| | | // params.setNeedSave(true); |
| | | // try { |
| | | // List<WarehouseClient> list = ExcelImportUtil.importExcel(file.getInputStream(), WarehouseClient.class, params); |
| | | // for (WarehouseClient temp : list) { |
| | | // temp.setWarehouseId(mainId); |
| | | // } |
| | | // long start = System.currentTimeMillis(); |
| | | // warehouseClientService.saveBatch(list); |
| | | // log.info("æ¶èæ¶é´" + (System.currentTimeMillis() - start) + "毫ç§"); |
| | | // return Result.OK("æä»¶å¯¼å
¥æåï¼æ°æ®è¡æ°ï¼" + list.size()); |
| | | // } catch (Exception e) { |
| | | // log.error(e.getMessage(), e); |
| | | // return Result.error("æä»¶å¯¼å
¥å¤±è´¥:" + e.getMessage()); |
| | | // } finally { |
| | | // try { |
| | | // file.getInputStream().close(); |
| | | // } catch (IOException e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | // } |
| | | // } |
| | | // return Result.error("æä»¶å¯¼å
¥å¤±è´¥ï¼"); |
| | | // } |
| | | // @GetMapping("/enterpriseList") |
| | | // public Result<?> getEnterpriseList(){ |
| | | // return Result.OK(enterpriseService.getEnterpriseListByPid(new Page<>(),1,"0")); |
| | | // } |
| | | // |
| | | // /*--------------------------------å表å¤ç-ä»åºæå¡å¯¹è±¡-end----------------------------------------------*/ |
| | | // |
| | | // |
| | | // |
| | | // /** |
| | | // * ä»åºç®¡ç æ°å¢ |
| | | // * qsw |
| | | // */ |
| | | // @PostMapping(value = "/addWarehouse") |
| | | // public Result<String> addWarehouse(@RequestBody Warehouse warehouse) { |
| | | // warehouseService.save(warehouse); |
| | | // return Result.OK("æ·»å æåï¼"); |
| | | // } |
| | | // |
| | | // |
| | | // /** |
| | | // * å页å表æ¥è¯¢ |
| | | // * qsw |
| | | // */ |
| | | // @GetMapping(value = "/find") |
| | | // public Result<IPage<Warehouse>> queryPageList(Warehouse warehouse, |
| | | // @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, |
| | | // @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, |
| | | // HttpServletRequest req) { |
| | | // QueryWrapper<Warehouse> queryWrapper = QueryGenerator.initQueryWrapper(warehouse, req.getParameterMap()); |
| | | // Page<Warehouse> page = new Page<Warehouse>(pageNo, pageSize); |
| | | // IPage<Warehouse> pageList = warehouseService.page(page, queryWrapper); |
| | | // return Result.OK(pageList); |
| | | // } |
| | | // |
| | | // /** |
| | | // * éè¿idå é¤ |
| | | // * @param id |
| | | // * @return |
| | | // * qsw |
| | | // */ |
| | | // @AutoLog(value = "ä»åº-éè¿idå é¤") |
| | | // @ApiOperation(value="ä»åº-éè¿idå é¤", notes="ä»åº-éè¿idå é¤") |
| | | // //@RequiresPermissions("org.jeecg.modules.demo:mom_base_warehouse:delete") |
| | | // @DeleteMapping(value = "/deleteWarehouseAreaLocation") |
| | | // public Result<String> deleteWarehouseAreaLocation(@RequestParam(name="id",required=true) String id) { |
| | | // |
| | | // List<WarehouseLocation> warehouseLocations = warehouseLocationService.lambdaQuery() |
| | | // .eq(WarehouseLocation::getWarehouseId, id).eq(WarehouseLocation::getDelFlag, 0) |
| | | // .list(); |
| | | // for (WarehouseLocation warehouseLocation : warehouseLocations) { |
| | | // warehouseLocationService.removeById(warehouseLocation); |
| | | // } |
| | | // |
| | | // List<WarehouseArea> warehouseAreas = warehouseAreaService.lambdaQuery() |
| | | // .eq(WarehouseArea::getWarehouseId, id) |
| | | // .eq(WarehouseArea::getDelFlag, 0).list(); |
| | | // for (WarehouseArea warehouseArea : warehouseAreas) { |
| | | // warehouseAreaService.removeById(warehouseArea); |
| | | // } |
| | | // warehouseService.removeById(id); |
| | | // return Result.OK("å 餿å!"); |
| | | // } |
| | | // |
| | | // /** |
| | | // * éè¿idæ¥è¯¢ |
| | | // *qsw |
| | | // */ |
| | | // @GetMapping(value = "/queryById") |
| | | // public Result<Warehouse> queryById(@RequestParam(name="id",required=true) String id) { |
| | | // Warehouse warehouse = warehouseService.getById(id); |
| | | // if(warehouse ==null) { |
| | | // return Result.error("æªæ¾å°å¯¹åºæ°æ®"); |
| | | // } |
| | | // return Result.OK(warehouse); |
| | | // } |
| | | // |
| | | //} |