selleck--codelib

一.入库：本质就是保存入库文件中cat code instock  inDate 到code表并及时更新库存表stock中cat对应的总量quantity！

code表： id code cat inStock inDate outDate      stock表： id  cat  quantity

0.

<div id="drop-zone">拖放<br/>S1001-xxx.csv<br/>文件到此处</div>
<div id="fileInfo"></div>
<table data-bind="foreach: racks" class="sortable">
    <tbody data-bind="foreach: plates">
    <tr data-bind="foreach: $data">
        <td>
            <span class="plate-label" data-bind="text: label"></span>
            <div class="plate-code" data-bind="text: code, css: {'plate-no-tube': 'No Tube' == code, 'plate-no-read': 'No Read' == code}"></div>
            <div class="plate-cat" data-bind="text: cat"></div>
        </td>
    </tr>
    </tbody>
</table>
<div>
    <button id="inStockButton" type="button" disabled data-bind="click: inStock">入库</button>
</div>
//通过ajax传递了cat 和codes
 Model.prototype.inStock = function() {
    var codes, i, j, len, len1, plate, plateRow, racks, ref;
    codes = [];
    racks = ko.mapping.toJS(this.racks);
    if (racks.length) {
      ref = racks[0].plates;
      for (i = 0, len = ref.length; i < len; i++) {
        plateRow = ref[i];
        for (j = 0, len1 = plateRow.length; j < len1; j++) {
          plate = plateRow[j];
          if (plate.code.match(/^d+$/)) {
            codes.push(plate.code);
          }
        }
      }
      return $.postJSON('doInStock.jhtml', {
        cat: this.cat,
        codes: codes
      }).done((function(_this) {
        return function(json) {
          if (json.error) {
            return alert(json.error);
          } else {
            return alert('上传成功');
          }
        };
      })(this));
    }
  };

1.action.xml

        <action name="in-stock" class="codeLibAction" method="inStock">
            <result name="success">/WEB-INF/jsp/backoffice/codelib/in-stock.jsp</result>
            <interceptor-ref name="defaultStack" />
            <interceptor-ref name="permission" />
        </action>
        <action name="doInStock" class="codeLibAction" method="doInStock"/>

2. action

    public String inStock() {
        return SUCCESS;
    }

    @SuppressWarnings("unchecked")
    public String doInStock() {
        Map<String, Object> result = new HashMap<>();
        try {
            Map<String, Object> map = readJSON();
            String cat = (String) map.get("cat");
            List<String> codes = (List<String>) map.get("codes");
            codeLibService.saveNewStockCodes(cat, codes);
        } catch (Exception e) {
            e.printStackTrace();
            result.put("error", e.getMessage());
        }
        writeJSON(result);
        return null;
    }

 3.daoImpl

    private void updateStockQuantity() {
        dao.flush();//把前面CRUD等操作刷入到数据库中，否则后面查询不到数据，因为事务的原因。
        dao.executeSql("insert selleck_cl_stock(cat) select distinct c.cat from selleck_cl_stock_code c where not exists(select * from selleck_cl_stock s where s.cat=c.cat)");
        dao.executeSql("update selleck_cl_stock s set quantity = (select count(*) from selleck_cl_stock_code c where c.cat=s.cat and instock=1)");
    }

    @Override
    public void saveNewStockCodes(String cat, List<String> codes) throws Exception {
        List<CodeLibStockCodeDTO> stockCodeList = new ArrayList<>(codes.size());
        Date today = new Date();
        codes.forEach(code -> {
            CodeLibStockCodeDTO codeLibStockCode = new CodeLibStockCodeDTO();
            codeLibStockCode.setCat(cat);
            codeLibStockCode.setCode(code);
            codeLibStockCode.setInstock(1);
            codeLibStockCode.setInDate(today);
            stockCodeList.add(codeLibStockCode);
        });
        dao.save(stockCodeList);
        updateStockQuantity();
    }

 二： 保存订单（一种是新建订单的保存，一种是编辑后的保存）， 读取excel中表格的某些字段保存到codeliborder订单表和plate药品孔位表，效果图

当点击Create按钮新建一个订单：新建订单必须先要求订单号no在大合同selleck_ordr中存在!

codeliborder表： id no memo boardFile                      plate表： id codelibOrderId  rack plate row col cat code  其中rack orderno cat可以通过文件名解析获得，是前台传过来的

//1.保存并上传文件到指定的目录用于下次下载用。

    public String orderSave() {
        if (StringUtils.isBlank(order.getMemo())) {
            throw new RuntimeException("请填写备注");
        }
        String root = ServletActionContext.getServletContext().getRealPath("/");
        codeLibService.save(order, excel, excelFileName, root, forceUpdate == 1);
        return SUCCESS;
    }

 //第一种情况是编辑后保存.  先编辑后保存，通过点击order所在的列的id去数据库查询有没有记录，如果有记录再去看订单的状态是否为null，如果是null设置成working

    public String orderEdit() {
        order = codeLibService.findCodeLibOrderById(order.getId()).orElseGet(CodeLibOrderDTO::new);
        if (order.getStatus() == null) {
            order.setStatus("working");
        }
        return SUCCESS;
    }

//serviceImpl 保存的业务逻辑，此时只会执行前三行的代码，后面的代码不会执行！

    @Override
    public void save(CodeLibOrderDTO order, File file, String filename, String uploadRoot, boolean resetStock) {
        dao.save(order);
        if (resetStock) {
            resetStockOutData(order);
        }
        if (file != null) {
            String savePath = uploadRoot + "newpath/downloads/codelib/";
            char[] chars = filename.trim().toCharArray();
            for (int i = 0; i < chars.length; i++) {
                char c = chars[i];
                if (c < '-' || c > 'z') {
                    chars[i] = '-';
                }
            }
            filename = new String(chars);
            order.setBoardFile(filename);
            dao.save(order);
            try {
                Files.createDirectories(new File(savePath).toPath());
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
            savePath += order.getId().toString() + "-" + filename;
            try (OutputStream out = new FileOutputStream(savePath); InputStream in = new FileInputStream(file)) {
                IOUtils.copy(in, out);
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
            List<CodeLibOrderPlateDTO> platesFromExcel = getOrderPlatesFromExcel(file, order);
            List<CodeLibOrderPlateDTO> plates = getPlates(order);
            if ( ! isPlatesMatch(platesFromExcel, plates)) {
                if ( ! plates.isEmpty() && ! resetStock) {
                    throw new RuntimeException("新分子库表格与当前数据不匹配，请选择【清空已出库数据】");
                }
                dao.delete(plates);
                dao.save(platesFromExcel);
            }
        }
    }

 //3.当forceUpdate==1 时

    private void resetStockOutData(CodeLibOrderDTO order) {
        Map<String, Object> params = new HashMap<>();
        params.put("orderId", order.getId());
        dao.flush();
        dao.executeSql("update selleck_cl_stock_code set instock=1, outDate=null where code in (select code from selleck_cl_order_plate where codeLibOrderId=:orderId)", params);
        dao.executeSql("update selleck_cl_order_plate set code=null where codeLibOrderId=:orderId", params);
        updateStockQuantity();
    }

 第二种情况是: 点击Create 保存 ，跑到了order-edit---执行的是orderEdit方法

            <s:if test="user.hasPermission(1134)">
                <li>
                    <input type="button" name="edit" onClick='location="/codelib/order-edit.jhtml?order.id="' value="Create" class="input_btn" />
                </li>
            </s:if>

 1.此刻通过id去查DB，肯定没有数据，因为新建的order，那里会有id，执行的是orElseGet(CodeLibOrderDTO::new)，设置了状态为working

    public String orderEdit() {
        order = codeLibService.findCodeLibOrderById(order.getId()).orElseGet(CodeLibOrderDTO::new);
        if (order.getStatus() == null) {
            order.setStatus("working");
        }
        return SUCCESS;
    }

 2.成功跳转到order-edit.jsp页面

        <action name="order-edit" class="codeLibAction" method="orderEdit">
            <interceptor-ref name="defaultStack" />
            <interceptor-ref name="permission" />
            <result name="success">/WEB-INF/jsp/backoffice/codelib/order-edit.jsp</result>
        </action>

 3.点击submit按钮提交到 order-save这个action，执行orderSave方法

<s:form theme="simple" method="post" action="order-save" id="sbform" target="_self" enctype="multipart/form-data">
    <input type="hidden" name="order.id" value="<s:property value="order.id"/>">
    <input type="hidden" name="order.boardFile" value="<s:property value="order.boardFile"/>">
    <table width="100%" cellpadding="0" cellspacing="0" border="0" id="table" class="sortable">

 当forceUpdate的值等于1的时候，清空数据，而现实是100%被清空了，因为在orderSave方法中人为的写死了forceUpdate == 1，所以不管前台选择什么都会被清空数据。

            <tr bgColor="white">
                <td align="center">清空已出库数据</td>
                <td>
                    <select name="forceUpdate">
                        <option value="0"></option>
                        <option value="1">清空数据</option>
                    </select>
                </td>
            </tr>