material_stock.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>出库管理</title>
  6. <meta name="renderer" content="webkit">
  7. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  8. <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  9. <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
  10. <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
  11. <style type="text/css">
  12. .LAY-btns .layui-nav {padding-left:0;padding-right:10px;top:-4px;margin: 0 10px;border: 0;background-color: #009688;}
  13. .LAY-btns .layui-nav .layui-nav-item{line-height: 30px;}
  14. .LAY-btns .layui-nav .layui-nav-child{top:34px;}
  15. .LAY-btns .layui-nav .layui-nav-bar{display: none;}
  16. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a{color:#333;background-color:#fff;}
  17. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a:hover {background-color: #f2f2f2;color: #000;}
  18. .layui-form-select dl{max-height: 150px;}
  19. </style>
  20. </head>
  21. <body>
  22. <div class="layui-fluid">
  23. <div class="layui-card">
  24. <div class="layui-card-body" pad15>
  25. <div class="layui-row layui-col-space15">
  26. <div class="layui-col-md12">
  27. <div class="LAY-btns" style="margin-bottom: 10px;">
  28. <button class="layui-btn layui-btn-sm" id="btn_export" data-permission="warehouse.export_material_stock"><i class="layui-icon layui-icon-download-circle"></i>导出</button>
  29. <button class="layui-btn layui-btn-sm" id="btn_query"><i class="layui-icon layui-icon-search"></i>查询</button>
  30. </div>
  31. <table class="layui-hide" id="datagrid" lay-filter="datagrid-operate"></table>
  32. <script type="text/html" id="datagrid-operate-bar">
  33. <div class="layui-btn-group">
  34. <a class="layui-btn layui-btn-xs" lay-event="detail" data-permission="warehouse.view_material_stock_log">查看动态</a>
  35. </div>
  36. </script>
  37. </div>
  38. </div>
  39. </div>
  40. </div>
  41. </div>
  42. <div id="dlg_query" style="display: none">
  43. <div class="layui-card-body" pad15>
  44. <form class="layui-form" lay-filter="query-form-element">
  45. <div class="layui-row layui-col-space10 layui-form-item">
  46. <div class="layui-col-xs12 layui-col-sm12">
  47. <label class="layui-form-label">最后出库:</label>
  48. <div class="layui-input-block">
  49. <input type="text" class="layui-input" autocomplete="off" name="last_deliver_time" id="id_last_deliver_time" placeholder=" - ">
  50. </div>
  51. </div>
  52. <div class="layui-col-xs12 layui-col-sm12">
  53. <label class="layui-form-label">最后入库:</label>
  54. <div class="layui-input-block">
  55. <input type="text" class="layui-input" autocomplete="off" name="last_entry_time" id="id_last_entry_time" placeholder=" - ">
  56. </div>
  57. </div>
  58. <div class="layui-col-xs12 layui-col-sm12">
  59. <label class="layui-form-label">仓别:</label>
  60. <div class="layui-input-block">
  61. <select id="id_warehouse" name="warehouse">
  62. <option value="">选择仓别</option>
  63. </select>
  64. </div>
  65. </div>
  66. <div class="layui-col-xs12 layui-col-sm12">
  67. <label class="layui-form-label">在用:</label>
  68. <div class="layui-input-block">
  69. <select name="product_enabled">
  70. <option value="" selected></option>
  71. <option value="1">是</option>
  72. <option value="0">否</option>
  73. </select>
  74. </div>
  75. </div>
  76. <div class="layui-col-xs12 layui-col-sm12">
  77. <label class="layui-form-label">库存状态:</label>
  78. <div class="layui-input-block">
  79. <select name="empty">
  80. <option value="" selected></option>
  81. <option value="1">有库存</option>
  82. <option value="0">零库存</option>
  83. <option value='2'>超储</option>
  84. <option value='3'>短缺</option>
  85. <option value='4'>负库存</option>
  86. </select>
  87. </div>
  88. </div>
  89. <div class="layui-col-xs12 layui-col-sm12">
  90. <label class="layui-form-label">名称/代码:</label>
  91. <div class="layui-input-block">
  92. <input type="text" name="product_name_model" autocomplete="off" class="layui-input">
  93. </div>
  94. </div>
  95. <div class="layui-col-xs12 layui-col-sm12">
  96. <label class="layui-form-label">库位:</label>
  97. <div class="layui-input-block">
  98. <input type="text" name="warehouse_place" autocomplete="off" class="layui-input">
  99. </div>
  100. </div>
  101. <div class="layui-col-xs12 layui-col-sm12">
  102. <label class="layui-form-label">库存时间:</label>
  103. <div class="layui-input-block">
  104. <input type="text" class="layui-input" autocomplete="off" name="stock_time" id="id_stock_time" placeholder=" - ">
  105. </div>
  106. </div>
  107. </div>
  108. <div class="layui-form-item" style="display: none">
  109. <button id="query_search" class="layui-btn" lay-submit lay-filter="query-form-element">查询</button>
  110. </div>
  111. </form>
  112. </div>
  113. </div>
  114. <script src="../../layuiadmin/layui/layui.js?t=1"></script>
  115. <script>
  116. var _params = '';
  117. layui.config({
  118. base: '../../../layuiadmin/' //静态资源所在路径
  119. }).extend({
  120. index: 'lib/index',
  121. utils: 'utils'
  122. }).use(['index', 'table', 'laydate', 'form', 'utils'], function(){
  123. var $ = layui.$;
  124. var table = layui.table
  125. ,laydate = layui.laydate
  126. ,form = layui.form
  127. ,admin = layui.admin
  128. ,utils = layui.utils;
  129. var warehosue_option = '';
  130. admin.req({
  131. url: '/warehouse/all_select/?type=0',
  132. done: function(res){
  133. var warehouses = res.data;
  134. for (var i in warehouses) {
  135. warehosue_option += "<option value="+ warehouses[i].id+">"+ warehouses[i].name+"</option>";
  136. }
  137. $("#id_warehouse").append(warehosue_option);
  138. form.render();
  139. }
  140. });
  141. var is_has = utils.isHasPermissions('material.view_material_cost');
  142. var cols = [];
  143. cols.push({field:'product_name', title:'名称', width:100});
  144. cols.push({field:'product_model', title:'代码', width:100});
  145. cols.push({field:'option_type_text', title:'类别', width:100});
  146. cols.push({field:'product_unit', title:'单位', width:100});
  147. cols.push({field:'product_standard', title:'规格', width:100});
  148. cols.push({field:'stock', title:'库存', align:'right', width:100});
  149. cols.push({field:'warehouse_text', title:'仓别', width:100});
  150. cols.push({field:'warehouse_place', title:'存放库位', width: 120});
  151. if (is_has){
  152. cols.push({field:'avg_cost_price', align:'right', title:'成本价', width:120});
  153. cols.push({field:'warehouse_amount', align:'right', title:'库存金额', width:130});
  154. }
  155. cols.push({field:'product_code', title:'助记码', width:100});
  156. cols.push({field:'last_entry_time', title:'最后入库时间', width:150});
  157. cols.push({field:'last_deliverd_time', title:'最后出库时间', width:150});
  158. cols.push({field:'days', align:'right', title:'未出库天数', width:100});
  159. cols.push({width:100, align:'left', fixed: 'right', toolbar: '#datagrid-operate-bar'});
  160. table.render({
  161. elem: '#datagrid'
  162. ,url: '/warehouse/stock/data/?type=0'
  163. ,cols: [cols]
  164. ,page: true
  165. ,totalRow: true
  166. ,height: 'full-104'
  167. ,parseData:function(res) {
  168. var cols = this.cols[0];
  169. for (var i in cols) {
  170. if (cols[i].field == 'stock') {
  171. cols[i].totalRowText = res.more.stock_count;
  172. }
  173. if (cols[i].field == 'warehouse_amount') {
  174. cols[i].totalRowText = res.more.warehouse_amount;
  175. }
  176. }
  177. return {
  178. "code": res.code, //解析接口状态
  179. "count": res.count, //解析数据长度
  180. "data": res.data //解析数据列表
  181. };
  182. }
  183. ,done: function () {
  184. layui.index.removeNoPermButtons()
  185. }
  186. });
  187. //监听工具条
  188. table.on('tool(datagrid-operate)', function(obj){
  189. var data = obj.data;
  190. table.editdata = data;
  191. if(obj.event === 'detail'){
  192. layer.open({
  193. type: 2,
  194. title: '[' + data.product_name + '-' + data.product_model + ']库存动态',
  195. shadeClose: true,
  196. area: ['90%', '90%'],
  197. content: 'stock_log.html'
  198. });
  199. }
  200. });
  201. $('#btn_export').on('click', function(){
  202. layui.admin.req({
  203. url: '/warehouse/stock/export/?type=0',
  204. data:_params,
  205. done: function (res) {
  206. layui.view.download(res.data.filename);
  207. }
  208. });
  209. });
  210. $('#btn_query').on('click', function(){
  211. layer.open({
  212. type: 1,
  213. shadeClose: true,
  214. area: ['600px', '510px'],
  215. title: '查询',
  216. btn: ['查询'],
  217. yes: function(index, dom){
  218. $('#query_search').click();
  219. },
  220. content: $('#dlg_query')
  221. });
  222. });
  223. form.on('submit(query-form-element)', function(data){
  224. //layer.msg(JSON.stringify(data.field));
  225. _params = data.field;
  226. table.reload('datagrid', {
  227. where: data.field
  228. ,page:{curr:1}
  229. });
  230. layer.closeAll();
  231. return false
  232. });
  233. laydate.render({
  234. elem: '#id_stock_time'
  235. ,type: 'datetime'
  236. });
  237. laydate.render({
  238. elem: '#id_last_deliver_time'
  239. ,range: true
  240. });
  241. laydate.render({
  242. elem: '#id_last_entry_time'
  243. ,range: true
  244. });
  245. });
  246. </script>
  247. </body>
  248. </html>