| | |
| | | import com.ruili.wcp.service.config.ViewService; |
| | | import com.ruili.wcp.web.model.AjaxResponse; |
| | | import com.ruili.wcp.web.model.ErrorInfo; |
| | | import com.zbooksoft.gdmis.common.PdfUtil; |
| | | import com.zbooksoft.gdmis.common.*; |
| | | import com.zbooksoft.gdmis.data.entity.CatYswjxx; |
| | | import com.zbooksoft.gdmis.data.entity.PackingManage; |
| | | import com.zbooksoft.gdmis.service.CatCheckService; |
| | |
| | | String cgSql = "select NVL(max(BGBH), 0) BGBH FROM CAT_ITEM_CGWJXX"; |
| | | Map<String, Object> stringMap = jdbcTemplate.queryForMap(cgSql); |
| | | int maxDH = Integer.parseInt(stringMap.get("BGBH").toString()); |
| | | int newDH = maxDH + 1; |
| | | for (int i = 0; i < ids.size(); i++) { |
| | | int newDH = maxDH + 1 + i; |
| | | String newDhString = String.format("%04d", newDH); |
| | | String sql = "select * from CAT_ITEM_YSWJXX where id = " + ids.get(i); |
| | | Map<String, Object> stringObjectMap = jdbcTemplate.queryForMap(sql); |
| | |
| | | String timestamp = Long.toString(System.currentTimeMillis()); |
| | | |
| | | try { |
| | | //1193266555786362880,1193266555916386304,1193266556004466688,1193266556105129984,1193266556193210368,1193266556277096448,1193266556377759744,1193266556474228736,1193266556545531904 变成list |
| | | String[] idList = ids.split(","); |
| | | |
| | | // 读取文件存放路径 |
| | | SystemConfig config = SystemConfig.getInstance(); |
| | | filePath = config.getAttachUploadPath() + "dataPack" + File.separator + userName + "_" + timestamp + File.separator; |
| | | // for (int i = 0; i < idList.length; i++) { |
| | | String wjljSql = "SELECT WJLJ FROM CAT_ITEM_YSWJXX WHERE ID = " + ids; |
| | | List<Map<String, Object>> wjljList = jdbcTemplate.queryForList(wjljSql); |
| | | if (wjljList.size() > 0) { |
| | | String newSavePath = filePath; |
| | | if (wjljList.get(0).get("WJLJ") != null) { |
| | | String cddzwjlj = wjljList.get(0).get("WJLJ").toString(); |
| | | File file = new File(cddzwjlj); |
| | | String name = file.getName(); |
| | | if (name.contains(".pdf") || name.contains(".PDF")) { |
| | | String parent = file.getParent(); |
| | | String newName = "tmp_" + name; |
| | | String newCddzwjlj = parent + File.separator + newName; |
| | | PdfUtil.addBlankPageAtBeginning(cddzwjlj, newCddzwjlj); |
| | | cddzwjlj = newCddzwjlj; |
| | | for (int i = 0; i < idList.length; i++) { |
| | | String wjljSql = "SELECT WJLJ,WJTM FROM CAT_ITEM_YSWJXX WHERE ID = " + idList[i]; |
| | | List<Map<String, Object>> wjljList = jdbcTemplate.queryForList(wjljSql); |
| | | if (wjljList.size() > 0) { |
| | | String newSavePath = filePath; |
| | | if (wjljList.get(0).get("WJLJ") != null) { |
| | | String cddzwjlj = wjljList.get(0).get("WJLJ").toString(); |
| | | String wjm = wjljList.get(0).get("WJTM").toString(); |
| | | File file = new File(cddzwjlj); |
| | | String name = file.getName(); |
| | | if (name.contains(".pdf") || name.contains(".PDF")) { |
| | | String parent = file.getParent(); |
| | | String newName = "tmp_" + name; |
| | | String newCddzwjlj = parent + File.separator + newName; |
| | | PdfUtil.addBlankPageAtBeginning(cddzwjlj, newCddzwjlj, wjm); |
| | | cddzwjlj = newCddzwjlj; |
| | | } |
| | | copyFile(cddzwjlj, newSavePath + File.separator + name); |
| | | } |
| | | copyFile(cddzwjlj, newSavePath + File.separator + name); |
| | | } |
| | | |
| | | } |
| | | } |
| | | // } |
| | | // 压缩文件 |
| | | generatePath = zipFile(new File(filePath), "rar"); |
| | | } catch (Exception ex) { |
| | |
| | | // 循环取出流中的数据 |
| | | byte[] b = new byte[100]; |
| | | int len; |
| | | while ((len = inStream.read(b)) > 0) |
| | | response.getOutputStream().write(b, 0, len); |
| | | while ((len = inStream.read(b)) > 0) response.getOutputStream().write(b, 0, len); |
| | | inStream.close(); |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | |
| | | * 导入页面 |
| | | * |
| | | * @param type 0:从转孔基本信息进入 1:从钻孔图幅进入 |
| | | * @return |
| | | */ |
| | | @RequestMapping({"/updateFileTypeIndex"}) |
| | | @RequiresUser |
| | |
| | | ModelAndView mv = new ModelAndView("gh/catAjjxx/updateFileTypeIndex"); |
| | | return mv; |
| | | } |
| | | |
| | | /** |
| | | * @param type 0 是成果 1 是原始 |
| | | * @return |
| | | */ |
| | | @RequestMapping({"/printLabelIndex"}) |
| | | @RequiresUser |
| | | public ModelAndView printLabelIndex(Integer type) { |
| | | ModelAndView mv = new ModelAndView("gh/catAjjxx/printLabelIndex"); |
| | | mv.addObject("type", type); |
| | | return mv; |
| | | } |
| | | |
| | | /** |
| | | * @param fileType 打印类型 0是盒子 1是文件 |
| | | * @param type 资料类型 0成果报告 1原始资料 |
| | | * @param idList |
| | | * @return |
| | | */ |
| | | @RequestMapping(value = "/printLabel") |
| | | @ResponseBody |
| | | @RequiresUser |
| | | public Object printLabel(String fileType, Integer type, @RequestBody List<Long> idList) { |
| | | try { |
| | | //打印盒子 |
| | | if ("盒子".equals(fileType)) { |
| | | if (type == 0) { |
| | | |
| | | } |
| | | if (type == 1) { |
| | | |
| | | UsbSyncExampleWindows usbSyncExampleWindows = new UsbSyncExampleWindows(); |
| | | usbSyncExampleWindows.printFileLabel(idList); |
| | | // ZT411RFIDPrintService zt411RFIDPrintService = new ZT411RFIDPrintService(); |
| | | // zt411RFIDPrintService.printRFIDLabel(idList); |
| | | } |
| | | } |
| | | //打印文件 |
| | | if ("文件".equals(fileType)) { |
| | | if (type == 0) { |
| | | UsbSyncExampleWindowsItemCg usbSyncExampleWindowsItemCg = new UsbSyncExampleWindowsItemCg(); |
| | | usbSyncExampleWindowsItemCg.printItemLabelCg(idList); |
| | | } |
| | | if (type == 1) { |
| | | UsbSyncExampleWindowsItem usbSyncExampleWindowsItem = new UsbSyncExampleWindowsItem(); |
| | | usbSyncExampleWindowsItem.printItemLabel(idList); |
| | | } |
| | | } |
| | | return new AjaxResponse(true); |
| | | } catch (Exception e) { |
| | | logger.error(e.getMessage(), e); |
| | | return new AjaxResponse(new ErrorInfo(e.getMessage()), false); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获取文件类型 |
| | |
| | | } |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | String fileType = "观/G"; |
| | | String substring = fileType.substring(fileType.indexOf("/") + 1); |
| | | System.out.println(substring); |
| | | } |
| | | |
| | | } |
| | | |