| | |
| | | |
| | | private Long nodeId; |
| | | |
| | | private String node_name; |
| | | |
| | | private String matnr; |
| | | |
| | | private Double safeQua; |
| | | private String maktx; |
| | | |
| | | private Double safe_qua; |
| | | |
| | | private Double amount; |
| | | |
| | |
| | | select |
| | | ROW_NUMBER() over (order by mp.create_time desc) as row, |
| | | mp.node_id, |
| | | mp.node_name, |
| | | mp.matnr, |
| | | mp.maktx, |
| | | mp.safe_qua, |
| | | ls.amount, |
| | | (cast(round((ls.amount/(mp.safe_qua*1.0))*100,2) as varchar)+'%') as progress |
| | |
| | | toolbar: '#toolbar', |
| | | cellMinWidth: 50, |
| | | cols: [[ |
| | | {type: 'checkbox'} |
| | | {type: 'numbers', fixed: 'left'} |
| | | ,{field: 'matnr', align: 'center',title: '商品编号'} |
| | | ,{field: 'maktx', align: 'center',title: '商品名称'} |
| | | // ,{field: 'nodeId$', align: 'center',title: '关联货位'} |
| | | ,{field: 'nodeId', align: 'center',title: '货位名称'} |
| | | ,{field: 'safeQua', align: 'center',title: '安全库存'} |
| | | ,{field: 'node_name', align: 'center',title: '货位'} |
| | | ,{field: 'safe_qua', align: 'center',title: '安全库存'} |
| | | ,{field: 'amount', align: 'center',title: '实际库存'} |
| | | ,{field: 'progress', align: 'center',title: '进度', templet: '#progressTpl'} |
| | | |
| | |
| | | </script> |
| | | <script type="text/html" id="progressTpl"> |
| | | <div class="layui-progress layuiadmin-order-progress" lay-filter="progress-"+ {{ d.orderid }} +""> |
| | | <div class="layui-progress-bar layui-bg-blue" lay-percent= {{ d.progress }}></div> |
| | | <div class="layui-progress-bar layui-bg-blue" lay-percent= {{ d.progress }}></div> |
| | | </div> |
| | | </script> |
| | | |