| | |
| | | import com.core.common.DateUtils; |
| | | import com.core.common.R; |
| | | import com.zy.asrs.entity.LocDetl; |
| | | import com.zy.asrs.entity.LocMast; |
| | | import com.zy.asrs.entity.Mat; |
| | | import com.zy.asrs.entity.param.ProductCalibrationExcelParam; |
| | | import com.zy.asrs.importexcle.LocMat; |
| | |
| | | import com.zy.asrs.service.LocMastService; |
| | | import com.zy.asrs.service.MatService; |
| | | import com.zy.common.web.BaseController; |
| | | import com.zy.system.entity.Config; |
| | | import com.zy.system.service.ConfigService; |
| | | import lombok.Synchronized; |
| | | import org.apache.ibatis.session.SqlSessionFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | |
| | | excludeTrash(param); |
| | | convert(param, wrapper); |
| | | allLike(LocDetl.class, param.keySet(), wrapper, condition); |
| | | if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} |
| | | if (!Cools.isEmpty(orderByField)) { |
| | | wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); |
| | | } |
| | | // if (!row.equals("")){ |
| | | // wrapper.and() |
| | | // .where("loc_no like '" +row +"%'"); |
| | |
| | | @Autowired |
| | | private LocDetlMapper LocDetlMapper; |
| | | |
| | | |
| | | @Autowired |
| | | private ConfigService configService; |
| | | |
| | | @RequestMapping(value = "/locDetl/statis/export") |
| | | // @ManagerAuth |
| | | public void statisExport(HttpServletResponse response) throws IOException { |
| | |
| | | |
| | | /** |
| | | * 获取库存总数 |
| | | * |
| | | * @return |
| | | */ |
| | | @RequestMapping("/locDetl/count") |
| | |
| | | return R.ok(sum); |
| | | } |
| | | |
| | | |
| | | @RequestMapping(value = "/locDetl/sync/auth") |
| | | @ManagerAuth |
| | | @Synchronized |
| | | public R sync() { |
| | | EntityWrapper<LocMast> locMastEntityWrapper = new EntityWrapper<>(); |
| | | int i = locMastService.selectCount(locMastEntityWrapper.in("loc_sts", "S", "R", "P", "Q")); |
| | | if (i > 0) { |
| | | return R.error("有" + i + "条数据处于出入库预约或盘点拣料中,无法同步库存"); |
| | | } |
| | | Config config = configService.selectOne(new EntityWrapper<Config>().eq("code","sync")); |
| | | if (config==null){ |
| | | config=new Config(); |
| | | config.setValue("1"); |
| | | config.setStatus((short) 1); |
| | | config.setCode("sync"); |
| | | config.setType((short) 1); |
| | | config.setName("同步期初数据MES"); |
| | | }else { |
| | | if (config.getValue().equals("1")){ |
| | | return R.error("数据同步中,请勿重复点击"); |
| | | } |
| | | config.setValue("1"); |
| | | configService.updateById(config); |
| | | } |
| | | return R.ok(); |
| | | } |
| | | } |
| | |
| | | @PostMapping("/reviewCheck") |
| | | @ManagerAuth(memo = "单据复核") |
| | | public synchronized R reviewCheck(@RequestBody List<ReviewDetl> param) { |
| | | System.out.println(JSONObject.toJSONString(param)); |
| | | if (Cools.isEmpty(param)) { |
| | | return R.parse("参数有误,请检查参数"); |
| | | } |
| | |
| | | import com.zy.asrs.service.ReviewDetlService; |
| | | import com.zy.asrs.service.ReviewService; |
| | | import com.zy.common.web.BaseController; |
| | | import com.zy.system.service.ConfigService; |
| | | import com.zy.system.service.impl.ConfigServiceImpl; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.http.MediaType; |
| | |
| | | |
| | | @Resource |
| | | private HttpServletResponse response; |
| | | @Autowired |
| | | private ConfigService configService; |
| | | |
| | | |
| | | @RequestMapping("/exportReview") |
| | |
| | | public void importOrder(MultipartFile multipartFile) throws IOException { |
| | | // 考核数据的判重使用order_id,check_type的组合唯一索引解决 |
| | | EasyExcel.read(multipartFile.getInputStream(), ImportReviewDto.class, |
| | | new ImportReviewListener(transactionManager, reviewService, reviewDetlService, snowflakeIdWorker, getUserId())).sheet().doReadSync(); |
| | | new ImportReviewListener(configService,transactionManager, reviewService, reviewDetlService, snowflakeIdWorker, getUserId())).sheet().doReadSync(); |
| | | } |
| | | |
| | | |
| | |
| | | import com.core.annotations.ManagerAuth; |
| | | import com.core.common.Cools; |
| | | import com.core.common.R; |
| | | import com.zy.asrs.entity.BasDevp; |
| | | import com.zy.asrs.entity.WaitPakin; |
| | | import com.zy.asrs.entity.param.EmptyPlateOutParam; |
| | | import com.zy.asrs.entity.param.FullStoreParam; |
| | |
| | | @ManagerAuth() |
| | | public R availableTakeSite(){ |
| | | List<Map<String, Object>> result = new ArrayList<>(); |
| | | List<Integer> outSite = basDevpService.getAvailableOutSite(101); |
| | | for (Integer siteId : outSite) { |
| | | List<BasDevp> outSite = basDevpService.getAvailableOutSiteAndDesc(101); |
| | | for (BasDevp siteId : outSite) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("siteId", siteId); |
| | | map.put("desc", siteId + "(全板出库口)"); |
| | | map.put("siteId", siteId.getDevNo()); |
| | | map.put("desc", siteId.getDevNo() + siteId.getDecDesc()); |
| | | result.add(map); |
| | | } |
| | | List<Integer> pickOutSite = basDevpService.getAvailableOutSite(103); |
| | | for (Integer siteId : pickOutSite) { |
| | | List<BasDevp> pickOutSite = basDevpService.getAvailableOutSiteAndDesc(103); |
| | | for (BasDevp siteId : pickOutSite) { |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("siteId", siteId); |
| | | map.put("desc", siteId + "(拣料出库口)"); |
| | | map.put("siteId", siteId.getDevNo()); |
| | | map.put("desc", siteId.getDevNo() + siteId.getDecDesc()); |
| | | result.add(map); |
| | | } |
| | | return R.ok().add(result); |
| | |
| | | return R.ok().add(basDevpService.getAvailableEmptyOutSite()); |
| | | } |
| | | |
| | | @RequestMapping("/available/take/check/siteDesc") |
| | | @ManagerAuth() |
| | | public R availableTakeCheckSiteDesc() { |
| | | List<BasDevp> availableOutSite = basDevpService.getAvailableOutSiteAndDesc(107); |
| | | List<String> data = new ArrayList<>(); |
| | | for (BasDevp siteId : availableOutSite) { |
| | | data.add(siteId.getDevNo() + siteId.getDecDesc()); |
| | | } |
| | | return R.ok().add(data); |
| | | } |
| | | |
| | | @RequestMapping("/available/empty/take/siteDesc") |
| | | @ManagerAuth() |
| | | public R availableEmptyTakeSiteDesc() { |
| | | List<BasDevp> availableOutSite = basDevpService.getAvailableEmptyOutSiteAndDesc(); |
| | | List<String> data = new ArrayList<>(); |
| | | for (BasDevp siteId : availableOutSite) { |
| | | data.add(siteId.getDevNo() + siteId.getDecDesc()); |
| | | } |
| | | return R.ok().add(data); |
| | | } |
| | | |
| | | @RequestMapping("/full/store/put/start") |
| | | @ManagerAuth(memo = "全板入库") |
| | | public R fullStorePutStart(@RequestBody FullStoreParam fullStoreParam) { |
| | |
| | | import com.zy.asrs.entity.ReviewDetl; |
| | | import com.zy.asrs.service.ReviewDetlService; |
| | | import com.zy.asrs.service.ReviewService; |
| | | import com.zy.system.entity.Config; |
| | | import com.zy.system.service.ConfigService; |
| | | import lombok.SneakyThrows; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.transaction.PlatformTransactionManager; |
| | |
| | | private final Long userId; |
| | | private TransactionStatus transactionStatus; |
| | | |
| | | private ConfigService configService; |
| | | |
| | | /** |
| | | * 如果使用了spring,请使用这个构造方法。每次创建Listener的时候需要把spring管理的类传进来 |
| | | */ |
| | | public ImportReviewListener(PlatformTransactionManager transactionManager, ReviewService reviewService, ReviewDetlService reviewDetlService, SnowflakeIdWorker snowflakeIdWorker, Long userId) { |
| | | public ImportReviewListener(ConfigService configService, PlatformTransactionManager transactionManager, ReviewService reviewService, ReviewDetlService reviewDetlService, SnowflakeIdWorker snowflakeIdWorker, Long userId) { |
| | | this.transactionManager = transactionManager; |
| | | this.reviewService = reviewService; |
| | | this.reviewDetlService = reviewDetlService; |
| | | this.snowflakeIdWorker = snowflakeIdWorker; |
| | | this.userId = userId; |
| | | this.configService = configService; |
| | | } |
| | | |
| | | private Set<String> uniquePackNos = new HashSet<>(); // 用于去重包装组号 |
| | |
| | | // 首次出现,记录并处理 |
| | | uniquePackNos.add(data.getColumn1()); |
| | | |
| | | String orderNo = ""; |
| | | Config config = configService.selectOne(new EntityWrapper<Config>().eq("code", "orderNo")); |
| | | if (config != null && config.getStatus() == 1 && config.getValue() != null) { |
| | | orderNo = config.getValue(); |
| | | } |
| | | |
| | | String time = DateUtils.convert(new Date(), DateUtils.yyyyMMddHHmmss_F); |
| | | Review review = reviewService.selectOne(new EntityWrapper<Review>().eq("order_no", data.getColumn1())); |
| | | if (review == null) { |
| | | review = new Review(); |
| | | review.setUuid(String.valueOf(snowflakeIdWorker.nextId())); |
| | | review.setOrderNo(data.getColumn1()); |
| | | review.setOrderNo(orderNo + data.getColumn1()); |
| | | review.setOrderTime(time); |
| | | review.setDefNumber("Excel导入"); |
| | | review.setSettle(1L); |
| | | review.setStatus(1); |
| | | review.setCreateBy(userId); |
| | |
| | | List<Integer> getAvailableInSite(@Param("typeNo") Integer typeNo); |
| | | |
| | | List<Integer> getAvailableOutSite(@Param("typeNo") Integer typeNo); |
| | | |
| | | List<BasDevp> getAvailableInSiteAndDesc(@Param("typeNo") Integer typeNo); |
| | | |
| | | List<BasDevp> getAvailableOutSiteAndDesc(@Param("typeNo") Integer typeNo); |
| | | } |
| | |
| | | List<Integer> getAvailableEmptyInSite(); |
| | | |
| | | /** |
| | | * 空板入库站 |
| | | * @return |
| | | */ |
| | | List<BasDevp> getAvailableEmptyInSiteAndDesc(); |
| | | |
| | | /** |
| | | * 出库站 |
| | | * @return |
| | | */ |
| | | List<Integer> getAvailableOutSite(Integer typeNo); |
| | | |
| | | /** |
| | | * 出库站 |
| | | * @return |
| | | */ |
| | | List<BasDevp> getAvailableOutSiteAndDesc(Integer typeNo); |
| | | |
| | | /** |
| | | * 空板出库站 |
| | | * @return |
| | | */ |
| | | List<Integer> getAvailableEmptyOutSite(); |
| | | |
| | | /** |
| | | * 空板出库站 |
| | | * @return |
| | | */ |
| | | List<BasDevp> getAvailableEmptyOutSiteAndDesc(); |
| | | |
| | | /** |
| | | * 目标站点状态检测 |
| | | * @param devpNo |
| | | */ |
| | |
| | | |
| | | R groupOrderConfirm(GroupOrderConfirmParam param); |
| | | |
| | | R groupOrderConfirmV2(GroupOrderConfirmParam param); |
| | | |
| | | R returnOrder(ReturnOrderConfirmParam param); |
| | | |
| | | R unQualifiedOrder(UnQualifiedOrderConfirmParam param); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<BasDevp> getAvailableEmptyInSiteAndDesc() { |
| | | return this.baseMapper.getAvailableInSiteAndDesc(10); |
| | | } |
| | | |
| | | @Override |
| | | public List<Integer> getAvailableOutSite(Integer typeNo) { |
| | | return this.baseMapper.getAvailableOutSite(typeNo); |
| | | } |
| | | |
| | | @Override |
| | | public List<BasDevp> getAvailableOutSiteAndDesc(Integer typeNo) { |
| | | return this.baseMapper.getAvailableOutSiteAndDesc(typeNo); |
| | | } |
| | | |
| | | @Override |
| | |
| | | return this.baseMapper.getAvailableOutSite(110); |
| | | } |
| | | |
| | | |
| | | public List<BasDevp> getAvailableEmptyOutSiteAndDesc() { |
| | | return this.baseMapper.getAvailableOutSiteAndDesc(110); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public BasDevp checkSiteStatus(Integer devpNo) { |
| | | return checkSiteStatus(devpNo, false); |
| | |
| | | @Autowired |
| | | private ApiLogService apiLogService; |
| | | |
| | | @Autowired |
| | | private WrkDetlLogService wrkDetlLogService; |
| | | |
| | | @Resource |
| | | private MatMapper matMapper; |
| | | |
| | |
| | | |
| | | @Resource |
| | | private BasCrnpMapper basCrnpMapper; |
| | | |
| | | @Resource |
| | | private ReviewService reviewService; |
| | | |
| | | |
| | | @Resource |
| | | private ReviewDetlService reviewDetlService; |
| | | |
| | | |
| | | @Override |
| | | @Transactional |
| | |
| | | |
| | | @Override |
| | | @Transactional |
| | | public R groupOrderConfirmV2(GroupOrderConfirmParam param) { |
| | | // 1. 查询单据是否存在 |
| | | String time = DateUtils.convert(new Date(), DateUtils.yyyyMMddHHmmss_F); |
| | | Review review = reviewService.selectOne(new EntityWrapper<Review>().eq("order_no", param.getGroupOrderNumber())); |
| | | if (review == null) { |
| | | review = new Review(); |
| | | review.setUuid(String.valueOf(snowflakeIdWorker.nextId())); |
| | | review.setOrderNo(param.getGroupOrderNumber()); |
| | | review.setOrderTime(time); |
| | | review.setDefNumber("系统同步"); |
| | | review.setSettle(1L); |
| | | review.setStatus(1); |
| | | review.setCreateBy(9527L); |
| | | review.setCreateTime(new Date()); |
| | | |
| | | reviewService.insert(review); |
| | | review = reviewService.selectOne(new EntityWrapper<Review>().eq("order_no", param.getGroupOrderNumber())); |
| | | } else { |
| | | // 1.2 存在,更新单据状态 |
| | | review.setSettle(1L); |
| | | reviewService.updateById(review); |
| | | } |
| | | reviewService.delete( |
| | | new EntityWrapper<Review>().eq("order_no", param.getGroupOrderNumber()) |
| | | ); |
| | | |
| | | // 2. 一一对应遍历 |
| | | List<GroupOrderConfirmParam.PackageGroupNo> pkgList = param.getPackageGroupNos(); |
| | | List<GroupOrderConfirmParam.VolumeNumber> volList = param.getVolumeNumbers(); |
| | | |
| | | int size = Math.min(pkgList.size(), volList.size()); // 防止越界 |
| | | for (int i = 0; i < size; i++) { |
| | | GroupOrderConfirmParam.PackageGroupNo pg = pkgList.get(i); |
| | | GroupOrderConfirmParam.VolumeNumber vn = volList.get(i); |
| | | |
| | | // 查询是否已存在该 detl |
| | | ReviewDetl detl = reviewDetlService.selectOne(new EntityWrapper<ReviewDetl>().eq("order_no", param.getGroupOrderNumber()).eq("brand", pg.getPackageGroupNo()).eq("model", vn.getVolumeNumber())); |
| | | |
| | | if (detl == null) { |
| | | List<WrkDetlLog> wrkDetlLogs = wrkDetlLogService.selectList(new EntityWrapper<WrkDetlLog>().eq("brand", pg.getPackageGroupNo()).eq("model", vn.getVolumeNumber())); |
| | | detl = new ReviewDetl(); |
| | | if (wrkDetlLogs != null && !wrkDetlLogs.isEmpty() && wrkDetlLogs.size() >= 1) { |
| | | detl.setSpecs(wrkDetlLogs.get(0).getSpecs()); |
| | | detl.setBatch(wrkDetlLogs.get(0).getBatch()); |
| | | detl.setAnfme(wrkDetlLogs.get(0).getAnfme()); |
| | | detl.setMatnr(wrkDetlLogs.get(0).getMatnr()); |
| | | detl.setMaktx(wrkDetlLogs.get(0).getMaktx()); |
| | | detl.setUnit(wrkDetlLogs.get(0).getUnit()); |
| | | detl.setDeadTime(wrkDetlLogs.get(0).getModiTime$()); |
| | | } |
| | | detl.setOrderId(review.getId()); |
| | | detl.setOrderNo(param.getGroupOrderNumber()); |
| | | detl.setCreateTime(new Date()); |
| | | detl.setBrand(pg.getPackageGroupNo()); // 包装组号 |
| | | detl.setModel(vn.getVolumeNumber()); // 卷号 |
| | | reviewDetlService.insert(detl); |
| | | } |
| | | } |
| | | return R.ok("组货确认成功"); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | @Transactional |
| | | public R returnOrder(ReturnOrderConfirmParam param) { |
| | | if (Cools.isEmpty(param.getOrderNumber())) { |
| | | param.setOrderNumber("THCK" + DateUtils.convert(new Date(), DateUtils.yyyyMMdd)); |
| New file |
| | |
| | | package com.zy.asrs.task; |
| | | |
| | | import com.alibaba.fastjson.JSON; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
| | | import com.core.common.Cools; |
| | | import com.zy.asrs.entity.LocDetl; |
| | | import com.zy.asrs.entity.param.GwmsGenerateInventoryDto; |
| | | import com.zy.asrs.service.ApiLogService; |
| | | import com.zy.asrs.service.LocDetlService; |
| | | import com.zy.common.constant.MesConstant; |
| | | import com.zy.common.utils.HttpHandler; |
| | | import com.zy.system.entity.Config; |
| | | import com.zy.system.service.ConfigService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.scheduling.annotation.Async; |
| | | import org.springframework.scheduling.annotation.Scheduled; |
| | | import org.springframework.stereotype.Component; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * |
| | | */ |
| | | @Component |
| | | @Slf4j |
| | | public class SyncLocDetlScheduler { |
| | | |
| | | @Autowired |
| | | private LocDetlService locDetlService; |
| | | |
| | | @Autowired |
| | | private ApiLogService apiLogService; |
| | | |
| | | @Autowired |
| | | private ConfigService configService; |
| | | |
| | | @Scheduled(fixedRate = 3000) |
| | | @Async("orderThreadPool") |
| | | public void sync() { |
| | | Config config = configService.selectOne(new EntityWrapper<Config>().eq("code", "sync")); |
| | | if (config != null && config.getValue() != null && (config.getValue().equals("true") || config.getValue().equals("1"))) { |
| | | List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<>()); |
| | | GwmsGenerateInventoryDto gwmsGenerateInventoryDto = new GwmsGenerateInventoryDto(); |
| | | gwmsGenerateInventoryDto.setWarehouseType(4); |
| | | List<GwmsGenerateInventoryDto.MatList> matLists = new ArrayList<>(); |
| | | for (LocDetl wrkDetl : locDetls) { |
| | | gwmsGenerateInventoryDto.setBarcode(wrkDetl.getBarcode()); |
| | | //gwmsGenerateInventoryDto.setPalletizingNo(wrkMast.getStaNo()); |
| | | |
| | | boolean flag = true; |
| | | for (GwmsGenerateInventoryDto.MatList matList : matLists) { |
| | | if (matList.getPackageGroupNo().equals(wrkDetl.getBrand())) { |
| | | matList.getRolls().add(new GwmsGenerateInventoryDto.Rolls(wrkDetl.getModel(), |
| | | wrkDetl.getUnit(), wrkDetl.getMaktx(), wrkDetl.getLength(), |
| | | Integer.parseInt(wrkDetl.getSpecs()), wrkDetl.getWeight(), wrkDetl.getVolume(), |
| | | wrkDetl.getManuDate())); |
| | | flag = false; |
| | | break; |
| | | } |
| | | } |
| | | if (flag) { |
| | | GwmsGenerateInventoryDto.MatList matList = new GwmsGenerateInventoryDto.MatList(); |
| | | matList.setBoxPos(wrkDetl.getOrigin()); |
| | | matList.setPackageGroupNo(wrkDetl.getBrand()); |
| | | matList.setOutOrIn("in"); |
| | | matList.setStockType("成品入库"); |
| | | matList.setBoxType(wrkDetl.getColor()); |
| | | matList.setRollType(wrkDetl.getManu()); |
| | | matList.setWideInWidth(wrkDetl.getItemNum()); |
| | | matList.setThickness(wrkDetl.getSku()); |
| | | List<GwmsGenerateInventoryDto.Rolls> rollsList = new ArrayList<>(); |
| | | GwmsGenerateInventoryDto.Rolls roll = new GwmsGenerateInventoryDto.Rolls(wrkDetl.getModel(), |
| | | wrkDetl.getUnit(), wrkDetl.getMaktx(), wrkDetl.getLength(), |
| | | Integer.parseInt(wrkDetl.getSpecs()), wrkDetl.getWeight(), wrkDetl.getVolume(), |
| | | wrkDetl.getManuDate()); |
| | | rollsList.add(roll); |
| | | matList.setRolls(rollsList); |
| | | matLists.add(matList); |
| | | } |
| | | } |
| | | gwmsGenerateInventoryDto.setMatList(matLists); |
| | | boolean success = false; |
| | | // 获取请求头 |
| | | Map<String, Object> headers = new HashMap<>(); |
| | | headers.put("Content-Type", "application/json;charset=UTF-8"); |
| | | |
| | | // 构造请求体 |
| | | String body = JSON.toJSONString(gwmsGenerateInventoryDto); |
| | | String response = ""; |
| | | try { |
| | | response = new HttpHandler.Builder() |
| | | .setUri(MesConstant.MES_CC_IP_PORT) |
| | | .setPath(MesConstant.MES_CC_KCTB_URL) |
| | | .setHeaders(headers) |
| | | .setJson(body) |
| | | .build() |
| | | .doGet(); |
| | | if (!Cools.isEmpty(response)) { |
| | | JSONObject jsonObject1 = JSONObject.parseObject(response); |
| | | int code = (int) jsonObject1.get("code"); |
| | | boolean state = jsonObject1.getBoolean("state"); |
| | | if (code == 200 && state) { |
| | | success = true; |
| | | } |
| | | } else { |
| | | log.error("同步期初数据失败!!!url:{};request:{};response:{}", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_KCTB_URL, body, response); |
| | | } |
| | | } catch (Exception e) { |
| | | log.error("同步期初数据异常:{}", e.getMessage()); |
| | | } finally { |
| | | config.setValue("0"); |
| | | configService.updateById(config); |
| | | try { |
| | | // 保存接口日志 |
| | | apiLogService.save( |
| | | "同步期初数据", |
| | | MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_KCTB_URL, |
| | | null, |
| | | "127.0.0.1", |
| | | null, |
| | | response, |
| | | success |
| | | ); |
| | | } catch (Exception e) { |
| | | log.error("", e); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | // 一楼返修入库推送mes做记录 |
| | | public static final String MES_CC_FXRK_URL = "/productInventory/v1/saveDto"; |
| | | |
| | | //同步期初数据(MES提供) |
| | | public static final String MES_CC_KCTB_URL = "/productInventory/v1/saveListDto"; |
| | | |
| | | // MES质量IP地址********************************************************** |
| | | public static final String MES_ZL_IP_PORT = "http://172.22.152.3:8157"; |
| | | |
| | |
| | | public static final String SALT = "123456789qwertyu"; |
| | | |
| | | // 系统激活状态 (默认未激活) |
| | | public static boolean SYSTEM_ACTIVATION = Boolean.FALSE; |
| | | public static boolean SYSTEM_ACTIVATION = Boolean.TRUE; |
| | | |
| | | public static String getActivationCode(String fileName){ |
| | | StringBuilder activationCode = new StringBuilder(); |
| | |
| | | public class ActivateScheduler { |
| | | |
| | | // @Scheduled(cron = "0/1 * 8 * * ? ") // 每天8点 |
| | | @Scheduled(cron = "* 0/1 * * * ? ") // 每分钟 |
| | | @PostConstruct |
| | | //@Scheduled(cron = "* 0/1 * * * ? ") // 每分钟 |
| | | //@PostConstruct |
| | | private void execute(){ |
| | | // 获取激活码 |
| | | String activationCode = SystemProperties.getActivationCode(OSinfo.getOSname().getActivationCodePath()); |
| | |
| | | group by abd.dev_no |
| | | </select> |
| | | |
| | | <select id="getAvailableInSiteAndDesc" resultMap="BaseResultMap"> |
| | | select |
| | | abd.dev_no,abd.dec_desc |
| | | from asr_bas_devp abd |
| | | left join asr_sta_desc asd on abd.dev_no = asd.stn_no |
| | | where 1=1 |
| | | and asd.type_no = #{typeNo} |
| | | -- and abd.in_enable = 'Y' |
| | | group by abd.dev_no,abd.dec_desc |
| | | </select> |
| | | |
| | | <select id="getAvailableOutSiteAndDesc" resultMap="BaseResultMap"> |
| | | select |
| | | abd.dev_no,abd.dec_desc |
| | | from asr_bas_devp abd |
| | | left join asr_sta_desc asd on abd.dev_no = asd.stn_no |
| | | where 1=1 |
| | | and asd.type_no = #{typeNo} |
| | | -- and abd.out_enable = 'Y' |
| | | group by abd.dev_no,abd.dec_desc |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | {type: 'checkbox', fixed: 'left'} |
| | | // ,{field: 'id', title: 'ID', sort: true,align: 'center', fixed: 'left', width: 80} |
| | | ,{field: 'devNo', align: 'center',sort:true,title: '编号'} |
| | | // ,{field: 'decDesc', align: 'center',title: '设备描述'} |
| | | ,{field: 'decDesc', align: 'center',title: '设备描述'} |
| | | // ,{field: 'devMk', align: 'center',title: '备注'} |
| | | ,{field: 'inEnable', align: 'center',title: '可入', templet:function(row){ |
| | | var html = "<input value='inEnable' type='checkbox' lay-skin='primary' lay-filter='tableCheckbox' table-index='"+row.LAY_TABLE_INDEX+"'"; |
| | |
| | | if(row.inreq1 === 'Y'){html += " checked ";} |
| | | html += ">"; |
| | | return html; |
| | | }} |
| | | }, hide:true} |
| | | ,{field: 'inreq2', align: 'center',title: '需求2', templet:function(row){ |
| | | var html = "<input value='inreq2' type='checkbox' lay-skin='primary' lay-filter='tableCheckbox' table-index='"+row.LAY_TABLE_INDEX+"'"; |
| | | if(row.inreq2 === 'Y'){html += " checked ";} |
| | | html += ">"; |
| | | return html; |
| | | }} |
| | | }, hide:true} |
| | | ,{field: 'wrkNo', align: 'center',title: '工作号', edit:true, style:'color: blue;font-weight: bold'} |
| | | // ,{field: 'wrkNo1', align: 'center',title: ''} |
| | | ,{field: 'locType1$', align: 'center',title: '高低'} |
| | |
| | | elem: '#locDetl', |
| | | headers: {token: localStorage.getItem('token')}, |
| | | url: baseUrl+'/locDetl/list/auth', |
| | | |
| | | page: true, |
| | | limit: 16, |
| | | limits: [16, 30, 50, 100, 200, 500], |
| | |
| | | tableReload(false); |
| | | }); |
| | | |
| | | // 同步接口 |
| | | form.on('submit(sync)', function (data) { |
| | | layer.confirm('确定同步数据吗', function(){ |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/sync/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'GET', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | layer.closeAll(); |
| | | } else if (res.code === 403){ |
| | | top.location.href = baseUrl+"/"; |
| | | } else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | }); |
| | | }); |
| | | |
| | | // 时间选择器 |
| | | layDate.render({ |
| | | elem: '#modiTime\\$', |
| | |
| | | |
| | | function tableReload(child) { |
| | | var searchData = { |
| | | "three_code":"待判" |
| | | }; |
| | | $.each($('#search-box [name]').serializeArray(), function() { |
| | | searchData[this.name] = this.value; |
| New file |
| | |
| | | var pageCurr; |
| | | function getCol() { |
| | | var cols = [ |
| | | {field: 'locNo$', align: 'center',title: '库位号'} |
| | | // ,{field: 'maktx', align: 'center',title: '商品名称', sort:true,hide: true} |
| | | // ,{field: 'orderNo', align: 'center',title: '单据编号', hide: true} |
| | | // ,{field: 'batch', align: 'center',title: '批次', width: 250, sort:true,hide: true} |
| | | ,{field: 'anfme', align: 'center',title: '数量'} |
| | | ,{field: 'zpallet', align: 'center',title: '托盘条码'} |
| | | ,{field: 'matnr', align: 'center',title: '规格', sort:true,width: 150} |
| | | ,{field: 'batch', align: 'center',title: '空箱尺寸', hide: true} |
| | | ,{field: 'memo', align: 'center',title: '空箱备注', hide: true} |
| | | ,{field: 'brand', align: 'center',title: '包装组号', hide: false,width: 150} |
| | | ,{field: 'model', align: 'center',title: '卷号', hide: false,width: 150} |
| | | ,{field: 'unit', align: 'center',title: '箱号', hide: false,width: 150} |
| | | ,{field: 'color', align: 'center',title: '木箱类型', hide: false} |
| | | ,{field: 'manu', align: 'center',title: '管芯类型', hide: true} |
| | | ,{field: 'sku', align: 'center',title: '实测宽幅', hide: true} |
| | | ,{field: 'itemNum', align: 'center',title: '生箔厚度', hide: true} |
| | | ,{field: 'manuDate', align: 'center',title: '分切下料时间', hide: true,width: 180} |
| | | ,{field: 'brand$', align: 'center',title: '木箱类型', hide: true} |
| | | // ,{field: 'price', align: 'center',title: '价格', hide: true} |
| | | // ,{field: 'units', align: 'center',title: '单位量', hide: true} |
| | | // ,{field: 'barcode', align: 'center',title: '条码', hide: true} |
| | | ,{field: 'origin', align: 'center',title: '木箱位置', hide: true} |
| | | // ,{field: 'safeQty', align: 'center',title: '安全库存量', hide: true} |
| | | ,{field: 'weight', align: 'center',title: '单箱净重', hide: false} |
| | | ,{field: 'length', align: 'center',title: '长度', hide: false} |
| | | ,{field: 'volume', align: 'center',title: '单箱毛重', hide: true} |
| | | ,{field: 'specs', align: 'center',title: '接头', hide:true} |
| | | ,{field: 'suppCode', align: 'center',title: '新旧', hide:true} |
| | | ,{field: 'deadWarn$', align: 'center',title: '理货状态', hide: false} |
| | | |
| | | |
| | | ,{ |
| | | field: 'threeCode', |
| | | align: 'center', |
| | | title: '合格否', |
| | | hide: false, |
| | | templet: function(d) { |
| | | return d.threeCode ? d.threeCode : '待判'; |
| | | } |
| | | } |
| | | // ,{field: 'supp', align: 'center',title: '供应商', hide: true} |
| | | // ,{field: 'suppCode', align: 'center',title: '供应商编码', hide: true} |
| | | // ,{field: 'beBatch$', align: 'center',title: '是否批次', hide: true} |
| | | // ,{field: 'deadTime', align: 'center',title: '保质期', hide: true} |
| | | // ,{field: 'deadWarn', align: 'center',title: '预警天数', hide: true} |
| | | // ,{field: 'source$', align: 'center',title: '制购', hide: true} |
| | | // ,{field: 'check$', align: 'center',title: '要求检验', hide: true} |
| | | // ,{field: 'danger$', align: 'center',title: '危险品', hide: true} |
| | | |
| | | ]; |
| | | |
| | | // cols.push.apply(cols, detlCols); |
| | | cols.push({field: 'modiUser$', align: 'center',title: '修改人员',hide: true} |
| | | ,{field: 'modiTime$', align: 'center',title: '修改时间',width: 200} |
| | | ) |
| | | return cols; |
| | | } |
| | | |
| | | layui.use(['table','laydate', 'form','upload','layer'], function(){ |
| | | var table = layui.table; |
| | | var $ = layui.jquery; |
| | | var layer = layui.layer; |
| | | var layDate = layui.laydate; |
| | | var form = layui.form; |
| | | var upload = layui.upload; |
| | | |
| | | // 数据渲染 |
| | | tableIns = table.render({ |
| | | elem: '#locDetl', |
| | | headers: {token: localStorage.getItem('token')}, |
| | | url: baseUrl+'/locDetl/list/auth', |
| | | page: true, |
| | | where: { |
| | | "three_code":"待判" |
| | | }, |
| | | limit: 16, |
| | | limits: [16, 30, 50, 100, 200, 500], |
| | | even: true, |
| | | toolbar: '#toolbar', |
| | | cellMinWidth: 50, |
| | | cols: [getCol()], |
| | | request: { |
| | | pageName: 'curr', |
| | | pageSize: 'limit' |
| | | }, |
| | | parseData: function (res) { |
| | | return { |
| | | 'code': res.code, |
| | | 'msg': res.msg, |
| | | 'count': res.data.total, |
| | | 'data': res.data.records |
| | | } |
| | | }, |
| | | response: { |
| | | statusCode: 200 |
| | | }, |
| | | done: function(res, curr, count) { |
| | | if (res.code === 403) { |
| | | top.location.href = baseUrl+"/"; |
| | | } |
| | | pageCurr=curr; |
| | | limit(); |
| | | form.on('checkbox(tableCheckbox)', function (data) { |
| | | var _index = $(data.elem).attr('table-index')||0; |
| | | if(data.elem.checked){ |
| | | res.data[_index][data.value] = 'Y'; |
| | | }else{ |
| | | res.data[_index][data.value] = 'N'; |
| | | } |
| | | }); |
| | | } |
| | | }); |
| | | |
| | | upload.render({ |
| | | elem: '#uploadExcel', // 绑定元素 |
| | | url: baseUrl+'/productCalibration', // 上传接口,替换为你的后端接口 |
| | | headers:{'token': localStorage.getItem('token')}, |
| | | accept: 'file', // 允许上传的文件类型 |
| | | exts: 'xls|xlsx', // 允许上传的文件后缀 |
| | | done: function(res){ |
| | | // 上传完毕回调 |
| | | if(res.code === 200){ |
| | | layer.msg(res.msg); |
| | | console.log('文件数据:', res.data); |
| | | } else { |
| | | layer.msg(res.msg || '上传失败'); |
| | | } |
| | | }, |
| | | error: function(){ |
| | | // 请求异常回调 |
| | | layer.msg('上传失败,请重试'); |
| | | } |
| | | }); |
| | | |
| | | |
| | | // 监听排序事件 |
| | | table.on('sort(locDetl)', function (obj) { |
| | | var searchData = {}; |
| | | $.each($('#search-box [name]').serializeArray(), function() { |
| | | searchData[this.name] = this.value; |
| | | }); |
| | | searchData['orderByField'] = obj.field; |
| | | searchData['orderByType'] = obj.type; |
| | | tableIns.reload({ |
| | | where: searchData, |
| | | page: { |
| | | curr: 1 |
| | | }, |
| | | done: function (res, curr, count) { |
| | | if (res.code === 403) { |
| | | top.location.href = baseUrl+"/"; |
| | | } |
| | | pageCurr=curr; |
| | | limit(); |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | // 监听头工具栏事件 |
| | | table.on('toolbar(locDetl)', function (obj) { |
| | | var checkStatus = table.checkStatus(obj.config.id); |
| | | switch(obj.event) { |
| | | case 'addData': |
| | | layer.open({ |
| | | type: 2, |
| | | title: '新增', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: 'locDetl_detail.html', |
| | | success: function(layero, index){ |
| | | layer.getChildFrame('#data-detail-submit-edit', index).hide(); |
| | | clearFormVal(layer.getChildFrame('#detail', index)); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | } |
| | | }); |
| | | break; |
| | | case 'refreshData': |
| | | tableIns.reload({ |
| | | page: { |
| | | curr: pageCurr |
| | | } |
| | | }); |
| | | limit(); |
| | | break; |
| | | case 'deleteData': |
| | | var data = checkStatus.data; |
| | | if (data.length === 0){ |
| | | layer.msg('请选择数据'); |
| | | } else { |
| | | layer.confirm('确定删除'+(data.length===1?'此':data.length)+'条数据吗', function(){ |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/delete/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | data: {param: JSON.stringify(data)}, |
| | | method: 'POST', |
| | | traditional:true, |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | layer.closeAll(); |
| | | tableReload(false); |
| | | } else if (res.code === 403){ |
| | | top.location.href = baseUrl+"/"; |
| | | } else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | }); |
| | | } |
| | | break; |
| | | case 'exportData': |
| | | layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){ |
| | | var titles=[]; |
| | | var fields=[]; |
| | | obj.config.cols[0].map(function (col) { |
| | | if (col.type === 'normal' && col.hide === false && col.toolbar == null) { |
| | | titles.push(col.title); |
| | | fields.push(col.field); |
| | | } |
| | | }); |
| | | var exportData = {}; |
| | | $.each($('#search-box [name]').serializeArray(), function() { |
| | | exportData[this.name] = this.value; |
| | | }); |
| | | var param = { |
| | | 'locDetl': exportData, |
| | | 'fields': fields |
| | | }; |
| | | var loadIndex = layer.msg('正在导出...', {icon: 16, shade: 0.01, time: false}); |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/export/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | data: JSON.stringify(param), |
| | | dataType:'json', |
| | | contentType:'application/json;charset=UTF-8', |
| | | method: 'POST', |
| | | success: function (res) { |
| | | layer.close(loadIndex); |
| | | layer.closeAll(); |
| | | if (res.code === 200) { |
| | | table.exportFile(titles,res.data,'xls'); |
| | | } else if (res.code === 403) { |
| | | top.location.href = baseUrl+"/"; |
| | | } else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }); |
| | | }); |
| | | break; |
| | | } |
| | | }); |
| | | |
| | | // 监听行工具事件 |
| | | table.on('tool(locDetl)', function(obj){ |
| | | var data = obj.data; |
| | | switch (obj.event) { |
| | | // 详情 |
| | | case 'detail': |
| | | layer.open({ |
| | | type: 2, |
| | | title: '详情', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: 'locDetl_detail.html', |
| | | success: function(layero, index){ |
| | | setFormVal(layer.getChildFrame('#detail', index), data, true); |
| | | top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true); |
| | | layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide(); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('select'); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); |
| | | } |
| | | }); |
| | | break; |
| | | // 编辑 |
| | | case 'edit': |
| | | layer.open({ |
| | | type: 2, |
| | | title: '修改', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: 'locDetl_detail.html', |
| | | success: function(layero, index){ |
| | | layer.getChildFrame('#data-detail-submit-save', index).hide(); |
| | | setFormVal(layer.getChildFrame('#detail', index), data, false); |
| | | top.convertDisabled(layer.getChildFrame('#data-detail :input', index), false); |
| | | top.convertDisabled(layer.getChildFrame('#locNo,#matnr', index), true); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('select'); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); |
| | | } |
| | | }); |
| | | break; |
| | | case 'locNo': |
| | | var param = top.reObject(data).locNo; |
| | | if (param === undefined) { |
| | | layer.msg("无数据"); |
| | | } else { |
| | | layer.open({ |
| | | type: 2, |
| | | title: '库位号详情', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: '../locMast/locMast_detail.html', |
| | | success: function(layero, index){ |
| | | $.ajax({ |
| | | url: baseUrl+"/locMast/"+ param +"/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'GET', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | setFormVal(layer.getChildFrame('#detail', index), res.data, true); |
| | | top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true); |
| | | layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide(); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('select'); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); |
| | | } else if (res.code === 403){ |
| | | parent.location.href = "/"; |
| | | }else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | }); |
| | | } |
| | | break; |
| | | case 'modiUser': |
| | | var param = top.reObject(data).modiUser; |
| | | if (param === undefined) { |
| | | layer.msg("无数据"); |
| | | } else { |
| | | layer.open({ |
| | | type: 2, |
| | | title: '修改人员详情', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: '../user/user_detail.html', |
| | | success: function(layero, index){ |
| | | $.ajax({ |
| | | url: baseUrl+"/user/"+ param +"/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'GET', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | setFormVal(layer.getChildFrame('#detail', index), res.data, true); |
| | | top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true); |
| | | layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide(); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('select'); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); |
| | | } else if (res.code === 403){ |
| | | parent.location.href = "/"; |
| | | }else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | }); |
| | | } |
| | | break; |
| | | case 'appeUser': |
| | | var param = top.reObject(data).appeUser; |
| | | if (param === undefined) { |
| | | layer.msg("无数据"); |
| | | } else { |
| | | layer.open({ |
| | | type: 2, |
| | | title: '创建者详情', |
| | | maxmin: true, |
| | | area: [top.detailWidth, top.detailHeight], |
| | | shadeClose: false, |
| | | content: '../user/user_detail.html', |
| | | success: function(layero, index){ |
| | | $.ajax({ |
| | | url: baseUrl+"/user/"+ param +"/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'GET', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | setFormVal(layer.getChildFrame('#detail', index), res.data, true); |
| | | top.convertDisabled(layer.getChildFrame('#data-detail :input', index), true); |
| | | layer.getChildFrame('#data-detail-submit-save,#data-detail-submit-edit,#prompt', index).hide(); |
| | | layer.iframeAuto(index);layer.style(index, {top: (($(window).height()-layer.getChildFrame('#data-detail', index).height())/3)+"px"}); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('select'); |
| | | layero.find('iframe')[0].contentWindow.layui.form.render('checkbox'); |
| | | } else if (res.code === 403){ |
| | | parent.location.href = "/"; |
| | | }else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | }); |
| | | } |
| | | break; |
| | | |
| | | } |
| | | }); |
| | | |
| | | // 数据保存动作 |
| | | form.on('submit(save)', function () { |
| | | if (banMsg != null){ |
| | | layer.msg(banMsg); |
| | | return; |
| | | } |
| | | method("add"); |
| | | }); |
| | | |
| | | // 数据修改动作 |
| | | form.on('submit(edit)', function () { |
| | | method("update") |
| | | }); |
| | | |
| | | function method(name){ |
| | | var index = layer.load(1, { |
| | | shade: [0.5,'#000'] //0.1透明度的背景 |
| | | }); |
| | | var data = { |
| | | // id: $('#id').val(), |
| | | locNo: $('#locNo').val(), |
| | | matnr: $('#matnr').val(), |
| | | lgnum: $('#lgnum').val(), |
| | | tbnum: $('#tbnum').val(), |
| | | tbpos: $('#tbpos').val(), |
| | | zmatid: $('#zmatid').val(), |
| | | maktx: $('#maktx').val(), |
| | | werks: $('#werks').val(), |
| | | anfme: $('#anfme').val(), |
| | | altme: $('#altme').val(), |
| | | zpallet: $('#zpallet').val(), |
| | | bname: $('#bname').val(), |
| | | memo: $('#memo').val(), |
| | | modiUser: $('#modiUser').val(), |
| | | modiTime: top.strToDate($('#modiTime\\$').val()), |
| | | appeUser: $('#appeUser').val(), |
| | | appeTime: top.strToDate($('#appeTime\\$').val()), |
| | | |
| | | }; |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/"+name+"/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | data: top.reObject(data), |
| | | method: 'POST', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | parent.layer.closeAll(); |
| | | parent.$(".layui-laypage-btn")[0].click(); |
| | | $("#data-detail :input").each(function () { |
| | | $(this).val(""); |
| | | }); |
| | | } else if (res.code === 403){ |
| | | top.location.href = baseUrl+"/"; |
| | | }else { |
| | | layer.msg(res.msg) |
| | | } |
| | | layer.close(index); |
| | | } |
| | | }) |
| | | } |
| | | |
| | | // 复选框事件 |
| | | form.on('checkbox(detailCheckbox)', function (data) { |
| | | var el = data.elem; |
| | | if (el.checked) { |
| | | $(el).val('Y'); |
| | | } else { |
| | | $(el).val('N'); |
| | | } |
| | | }); |
| | | |
| | | // 搜索栏搜索事件 |
| | | form.on('submit(search)', function (data) { |
| | | pageCurr = 1; |
| | | tableReload(false); |
| | | }); |
| | | |
| | | |
| | | // 搜索栏重置事件 |
| | | form.on('submit(reset)', function (data) { |
| | | pageCurr = 1; |
| | | clearFormVal($('#search-box')); |
| | | tableReload(false); |
| | | }); |
| | | |
| | | // 同步接口 |
| | | form.on('submit(sync)', function (data) { |
| | | layer.confirm('确定同步数据吗', function(){ |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/sync/auth", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'GET', |
| | | success: function (res) { |
| | | if (res.code === 200){ |
| | | layer.closeAll(); |
| | | } else if (res.code === 403){ |
| | | top.location.href = baseUrl+"/"; |
| | | } else { |
| | | layer.msg(res.msg) |
| | | } |
| | | } |
| | | }) |
| | | }); |
| | | }); |
| | | |
| | | // 时间选择器 |
| | | layDate.render({ |
| | | elem: '#modiTime\\$', |
| | | type: 'datetime' |
| | | }); |
| | | layDate.render({ |
| | | elem: '#appeTime\\$', |
| | | type: 'datetime' |
| | | }); |
| | | |
| | | |
| | | }); |
| | | |
| | | // 关闭动作 |
| | | $(document).on('click','#data-detail-close', function () { |
| | | parent.layer.closeAll(); |
| | | }); |
| | | |
| | | function tableReload(child) { |
| | | var searchData = { |
| | | "three_code":"待判" |
| | | }; |
| | | $.each($('#search-box [name]').serializeArray(), function() { |
| | | searchData[this.name] = this.value; |
| | | }); |
| | | (child ? parent.tableIns : tableIns).reload({ |
| | | where: searchData, |
| | | page: { |
| | | curr: pageCurr |
| | | }, |
| | | done: function (res, curr, count) { |
| | | if (res.code === 403) { |
| | | top.location.href = baseUrl+"/"; |
| | | } |
| | | pageCurr=curr; |
| | | if (res.data.length === 0 && count !== 0) { |
| | | tableIns.reload({ |
| | | where: searchData, |
| | | page: { |
| | | curr: pageCurr-1 |
| | | } |
| | | }); |
| | | pageCurr -= 1; |
| | | } |
| | | limit(child); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | function setFormVal(el, data, showImg) { |
| | | for (var val in data) { |
| | | var find = el.find(":input[id='" + val + "']"); |
| | | if (find[0]!=null){ |
| | | if (find[0].type === 'checkbox'){ |
| | | if (data[val]==='Y'){ |
| | | find.attr("checked","checked"); |
| | | find.val('Y'); |
| | | } else { |
| | | find.remove("checked"); |
| | | find.val('N'); |
| | | } |
| | | continue; |
| | | } |
| | | } |
| | | find.val(data[val]); |
| | | if (showImg){ |
| | | var next = find.next(); |
| | | if (next.get(0)){ |
| | | if (next.get(0).localName === "img") { |
| | | find.hide(); |
| | | next.attr("src", data[val]); |
| | | next.show(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | function clearFormVal(el) { |
| | | $(':input', el) |
| | | .val('') |
| | | .removeAttr('checked') |
| | | .removeAttr('selected'); |
| | | } |
| | | |
| | | function detailScreen(index) { |
| | | var detail = layer.getChildFrame('#data-detail', index); |
| | | var height = detail.height()+60; |
| | | if (height > ($(window).height()*0.9)) { |
| | | height = ($(window).height()*0.8); |
| | | } |
| | | layer.style(index, { |
| | | // top: (($(window).height()-height)/3)+"px", |
| | | height: height+'px' |
| | | }); |
| | | } |
| | | |
| | | $('body').keydown(function () { |
| | | if (event.keyCode === 13) { |
| | | $("#search").click(); |
| | | } |
| | | }); |
| | |
| | | // 获取出库口 |
| | | function getOutBound(){ |
| | | $.ajax({ |
| | | url: baseUrl+"/available/empty/take/site", |
| | | url: baseUrl+"/available/empty/take/siteDesc", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'POST', |
| | | async: false, |
| | |
| | | // 获取出库口 |
| | | function getOutBound(){ |
| | | $.ajax({ |
| | | url: baseUrl+"/available/take/check/site", |
| | | url: baseUrl+"/available/take/check/siteDesc", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | method: 'POST', |
| | | async: false, |
| | |
| | | cols: [[ |
| | | {type: 'checkbox', fixed: 'left'}, |
| | | {field: 'orderNo', title: '单据编号'}, |
| | | {field: 'defNumber', title: '来源'}, |
| | | {field: 'cstmrName', align: 'center', title: '客户名称'}, |
| | | {align: 'center', title: '明细', toolbar: '#tbLook', minWidth: 250, width: 250}, |
| | | {field: 'createTime$', title: '创建时间', minWidth: 200, width: 200}, |
| | |
| | | <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/cool.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/basDevp/basDevp.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/basDevp/basDevp.js?v=1" charset="utf-8"></script> |
| | | |
| | | <iframe id="detail-iframe" scrolling="auto" style="display:none;"></iframe> |
| | | |
| | |
| | | #uploadExcel{ |
| | | display: none; |
| | | } |
| | | /*.btn-sync {*/ |
| | | /* display: none;*/ |
| | | /*}*/ |
| | | </style> |
| | | </head> |
| | | <body> |
| | |
| | | <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索</button> |
| | | <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置</button> |
| | | <!-- <button id="unreason" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="unreason">查看异常数据</button>--> |
| | | <button id="sync" class="layui-btn layui-btn-primary layui-btn-radius btn-sync" lay-submit lay-filter="sync">同步数据</button> |
| | | |
| | | </div> |
| | | |
| | | </div> |
| | |
| | | <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/cool.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/locDetl/locDetl.js?v=12" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/locDetl/locDetl.js?v=2" charset="utf-8"></script> |
| | | |
| | | <iframe id="detail-iframe" scrolling="auto" style="display:none;"></iframe> |
| | | |
| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html lang="en"> |
| | | <head> |
| | | <meta charset="utf-8"> |
| | | <title></title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <link rel="stylesheet" href="../../static/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../static/css/cool.css" media="all"> |
| | | <link rel="stylesheet" href="../../static/css/common.css" media="all"> |
| | | <style> |
| | | #uploadExcel{ |
| | | display: none; |
| | | } |
| | | /*.btn-sync {*/ |
| | | /* display: none;*/ |
| | | /*}*/ |
| | | </style> |
| | | </head> |
| | | <body> |
| | | |
| | | <!-- 搜索栏 --> |
| | | <div id="search-box" class="layui-form layui-card-header"> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="loc_no" placeholder="库位号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="zpallet" placeholder="托盘码" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="brand" placeholder="包装组号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="unit" placeholder="箱号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="model" placeholder="卷号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="specs" placeholder="接头" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="suppCode" placeholder="新旧" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <!-- <div class="layui-inline">--> |
| | | <!-- <div class="layui-input-inline">--> |
| | | <!-- <input class="layui-input" type="text" name="row" placeholder="排数" autocomplete="off">--> |
| | | <!-- </div>--> |
| | | <!-- </div>--> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off"> |
| | | </div> |
| | | |
| | | </div> |
| | | |
| | | <!-- 待添加 --> |
| | | <div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block"> |
| | | <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索</button> |
| | | <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置</button> |
| | | <!-- <button id="unreason" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="unreason">查看异常数据</button>--> |
| | | |
| | | </div> |
| | | |
| | | </div> |
| | | |
| | | <!-- 表格 --> |
| | | <div class="layui-form"> |
| | | <table class="layui-hide" id="locDetl" lay-filter="locDetl"></table> |
| | | </div> |
| | | <script type="text/html" id="toolbar"> |
| | | <div class="layui-btn-container"> |
| | | <button id="uploadExcel" class="layui-btn layui-btn-primary layui-btn-sm" >产品校验</button> |
| | | <button class="layui-btn layui-btn-primary layui-btn-sm" id="btn-export" lay-event="exportData" style="margin-top: 1px">导出</button> |
| | | </div> |
| | | <!-- <input type="file" id="fileInput" accept=".xlsx, .xls">--> |
| | | <!-- <button class="layui-btn layui-btn-primary layui-btn-sm" id="btn-import" onclick="exportExc()" style="margin-top: 10px">导入</button>--> |
| | | </script> |
| | | |
| | | <script type="text/html" id="operate"> |
| | | <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">详情</a> |
| | | </script> |
| | | <script> |
| | | function exportExc() { |
| | | var fileInput = document.getElementById('fileInput'); |
| | | var file = fileInput.files[0]; |
| | | if (file === undefined) { |
| | | alert('请先选择文件') |
| | | return |
| | | } |
| | | var formData = new FormData(); |
| | | formData.append('file', file); |
| | | |
| | | fetch(baseUrl+'/importLocData', { |
| | | method: 'POST', |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | body: formData |
| | | }).then(response => { |
| | | response.text().then(data => { |
| | | var res = JSON.parse(data) |
| | | alert(res.msg) |
| | | }) |
| | | }).catch(error => { |
| | | alert('导入异常'); |
| | | }); |
| | | } |
| | | </script> |
| | | |
| | | <script type="text/javascript" src="../../static/js/jquery/jquery-3.3.1.min.js"></script> |
| | | <script type="text/javascript" src="../../static/layui/layui.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/common.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/cool.js" charset="utf-8"></script> |
| | | <script type="text/javascript" src="../../static/js/locDetl/locDetl2.js?v=1" charset="utf-8"></script> |
| | | |
| | | <iframe id="detail-iframe" scrolling="auto" style="display:none;"></iframe> |
| | | |
| | | </body> |
| | | </html> |
| | | |
| | |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" |
| | | lay-filter="checkModifySta" |
| | | lay-submit |
| | | style="display: block; float: right; margin-right: 3rem; transform: scale(1.2);margin-bottom: 3rem; transform-origin: right center;"> |
| | | style="display: block; float: right; margin-right: 3rem;margin-bottom: 3rem; transform-origin: right center;"> |
| | | 盘点均分 |
| | | </button> |
| | | |
| | | <!-- <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem">--> |
| | | <!-- 批量修改--> |
| | | <!-- </button>--> |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 3rem"> |
| | | 批量修改 |
| | | </button> |
| | | </div> |
| | | </script> |
| | | |
| | |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" |
| | | lay-filter="checkModifySta" |
| | | lay-submit |
| | | style="display: block; float: right; margin-right: 3rem; transform: scale(1.2);margin-bottom: 3rem; transform-origin: right center;"> |
| | | style="display: block; float: right; margin-right: 3rem; margin-bottom: 3rem; transform-origin: right center;"> |
| | | 盘点均分 |
| | | </button> |
| | | |
| | | <!-- <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem">--> |
| | | <!-- 批量修改--> |
| | | <!-- </button>--> |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem"> |
| | | 批量修改 |
| | | </button> |
| | | </div> |
| | | </script> |
| | | |
| | |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" |
| | | lay-filter="checkModifySta" |
| | | lay-submit |
| | | style="display: block; float: right; margin-right: 3rem; transform: scale(1.2);margin-bottom: 3rem; transform-origin: right center;"> |
| | | style="display: block; float: right; margin-right: 3rem; margin-bottom: 3rem; transform-origin: right center;"> |
| | | 盘点均分 |
| | | </button> |
| | | |
| | | <!-- <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem">--> |
| | | <!-- 批量修改--> |
| | | <!-- </button>--> |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem"> |
| | | 批量修改 |
| | | </button> |
| | | </div> |
| | | </script> |
| | | |
| | |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" |
| | | lay-filter="checkModifySta" |
| | | lay-submit |
| | | style="display: block; float: right; margin-right: 3rem; transform: scale(1.2);margin-bottom: 3rem; transform-origin: right center;"> |
| | | style="display: block; float: right; margin-right: 3rem; margin-bottom: 3rem; transform-origin: right center;"> |
| | | 盘点均分 |
| | | </button> |
| | | |
| | | <!-- <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem">--> |
| | | <!-- 批量修改--> |
| | | <!-- </button>--> |
| | | <button class="layui-btn layui-btn-primary layui-border-black layui-btn-sm" lay-filter="batchModifySta" lay-submit style="display: block;float: right;margin-right: 1rem"> |
| | | 批量修改 |
| | | </button> |
| | | </div> |
| | | </script> |
| | | |