| | |
| | | private BigDecimal lockedQuantity; |
| | | |
| | | @ApiModelProperty("预警数量") |
| | | private Integer warnNum; |
| | | private BigDecimal warnNum; |
| | | |
| | | @ApiModelProperty("备注") |
| | | private String remark; |
| | |
| | | newStockInventory.setQualitity(stockInventoryDto.getQualitity()); |
| | | newStockInventory.setVersion(1); |
| | | newStockInventory.setRemark(stockInventoryDto.getRemark()); |
| | | newStockInventory.setWarnNum(stockInventoryDto.getWarnNum()); |
| | | stockInventoryMapper.insert(newStockInventory); |
| | | }else { |
| | | stockInventoryMapper.updateAddStockInventory(stockInventoryDto); |
| | |
| | | <if test="ew.remark != null and ew.remark !=''"> |
| | | remark = #{ew.remark}, |
| | | </if> |
| | | <if test="ew.warnNum != null and ew.warnNum !=''"> |
| | | warn_num = #{ew.warnNum}, |
| | | </if> |
| | | update_time = now() |
| | | </set> |
| | | where product_model_id = #{ew.productModelId} |
| | |
| | | si.product_model_id, |
| | | si.create_time, |
| | | si.update_time, |
| | | si.warn_num, |
| | | COALESCE(si.warn_num, 0) as warn_num, |
| | | si.version, |
| | | (si.qualitity - COALESCE(si.locked_quantity, 0)) as un_locked_quantity, |
| | | pm.model, |