material_godownentry_query.html 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
  1. <!DOCTYPE html>
  2. <html lang="en">
  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"
  9. content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
  10. <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
  11. <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
  12. <style type="text/css">
  13. .LAY-btns .layui-nav {padding-left:0;padding-right:10px;top:-4px;margin: 0 10px;border: 0;background-color: #009688;}
  14. .LAY-btns .layui-nav .layui-nav-item{line-height: 30px;}
  15. .LAY-btns .layui-nav .layui-nav-child{top:34px;}
  16. .LAY-btns .layui-nav .layui-nav-bar{display: none;}
  17. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a{color:#333;background-color:#fff;}
  18. .LAY-btns .layui-nav .layui-nav-child dd.layui-this a:hover {background-color: #f2f2f2;color: #000;}
  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">
  26. <div class="LAY-btns" style="margin-bottom: 10px;">
  27. <button class="layui-btn layui-btn-sm" id="btn_export" data-permission="purchase.export_material_godownentry_query"><i class="layui-icon layui-icon-download-circle"></i>导出</button>
  28. <button class="layui-btn layui-btn-sm" id="btn_print" data-permission="purchase.print_material_godownentry_query"><i class="layui-icon layui-icon-print"></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. {{# if(d.is_PY == false){ }}
  35. <a class="layui-btn layui-btn-xs" lay-event="return" data-permission="purchase.add_material_godown_entry_return">退货</a>
  36. {{# } }}
  37. </div>
  38. </script>
  39. </div>
  40. </div>
  41. </div>
  42. </div>
  43. <div id="dlg_query" style="display: none">
  44. <div class="layui-card-body" pad15>
  45. <form class="layui-form" lay-filter="query-form-element">
  46. <div class="layui-row layui-col-space10 layui-form-item">
  47. <div class="layui-col-xs12 layui-col-sm12">
  48. <label class="layui-form-label">审核时间:</label>
  49. <div class="layui-input-block">
  50. <input type="text" class="layui-input" name="check_time" id="check_time" placeholder=" - " autocomplete="off">
  51. </div>
  52. </div>
  53. <div class="layui-col-xs12 layui-col-sm12">
  54. <label class="layui-form-label">入库类别:</label>
  55. <div class="layui-input-block">
  56. <select name="entry_type">
  57. <option value="">全部</option>
  58. <option value="0">直接入库</option>
  59. <option value="1">采购入库</option>
  60. <option value="2">盘盈入库</option>
  61. </select>
  62. </div>
  63. </div>
  64. <div class="layui-col-xs12 layui-col-sm12">
  65. <label class="layui-form-label">产品名称:</label>
  66. <div class="layui-input-block">
  67. <input type="text" name="product_text" class="layui-input" autocomplete="off">
  68. </div>
  69. </div>
  70. <div class="layui-col-xs12 layui-col-sm12">
  71. <label class="layui-form-label">代码:</label>
  72. <div class="layui-input-block">
  73. <input type="text" name="product_model" class="layui-input" autocomplete="off">
  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. <input type="text" name="warehouse" class="layui-input" autocomplete="off">
  80. </div>
  81. </div>
  82. <div class="layui-col-xs12 layui-col-sm12">
  83. <label class="layui-form-label">入库单号:</label>
  84. <div class="layui-input-block">
  85. <input type="text" name="no" class="layui-input" autocomplete="off">
  86. </div>
  87. </div>
  88. <div class="layui-col-xs12 layui-col-sm12">
  89. <label class="layui-form-label">供应商:</label>
  90. <div class="layui-input-block">
  91. <input type="text" name="supplier" class="layui-input" autocomplete="off">
  92. </div>
  93. </div>
  94. <div class="layui-col-xs12 layui-col-sm12">
  95. <label class="layui-form-label">创建人:</label>
  96. <div class="layui-input-block">
  97. <input type="text" name="create_user" autocomplete="off" class="layui-input">
  98. </div>
  99. </div>
  100. <div class="layui-col-xs12 layui-col-sm12">
  101. <label class="layui-form-label">产品备注:</label>
  102. <div class="layui-input-block">
  103. <input type="text" name="notes" autocomplete="off" class="layui-input">
  104. </div>
  105. </div>
  106. </div>
  107. <div style="display: none" >
  108. <button id="query-submit" lay-submit lay-filter="query-form-element">查询</button>
  109. </div>
  110. </form>
  111. </div>
  112. </div>
  113. <script src="../../layuiadmin/layui/layui.js?t=1"></script>
  114. <script>
  115. var _params = '';
  116. layui.config({
  117. base: '../../../layuiadmin/' //静态资源所在路径
  118. }).extend({
  119. index: 'lib/index', //主入口模块
  120. utils: 'utils'
  121. }).use(['index', 'table', 'laydate', 'form', 'utils'], function () {
  122. var $ = layui.$;
  123. var table = layui.table
  124. , form = layui.form
  125. , laydate = layui.laydate
  126. ,utils = layui.utils
  127. var is_has = utils.isHasPermissions('material.view_material_cost');
  128. var cols = [];
  129. cols.push({field: 'no', title: '入库单号', width: 160});
  130. cols.push({field: 'type', title: '入库类别', width: 120});
  131. cols.push({field: 'supplier', title: '供应商', width: 145});
  132. cols.push({field: 'product_name', title: '产品', width: 140});
  133. cols.push({field: 'product_model', title: '代码', width: 100});
  134. cols.push({field: 'product_unit', title: '单位', width: 100});
  135. cols.push({field: 'product_type', title: '产品类别', width: 100});
  136. cols.push({field: 'warehouse', title: '仓别', width: 130});
  137. if (is_has){
  138. cols.push({field: 'price', align:'right', title: '入库单价', width: 110});
  139. }
  140. cols.push({field: 'count', align:'right', title: '数量', width: 110});
  141. cols.push({field: 'return_count', align:'right', title: '退货数量', width: 110});
  142. if (is_has){
  143. cols.push({field: 'amount', align:'right', title: '合计金额', width: 110});
  144. }
  145. cols.push({field: 'deliver_count', align:'right', title: '出库数量', width: 110});
  146. cols.push({field: 'surplus_count', align:'right', title: '剩余数量', width: 110});
  147. cols.push({field: 'create_user', title: '创建人', width: 120});
  148. cols.push({field: 'check_time', title: '审核时间', width: 160});
  149. cols.push({field: 'warehouse_place', title: '存放库位', width: 150});
  150. cols.push({field: 'notes', title: '备注', minWidth: 200});
  151. cols.push({width: 75, align: 'center', fixed: 'right', toolbar: '#datagrid-operate-bar'});
  152. table.render({
  153. elem: '#datagrid'
  154. , url: '/purchase/godownentry_query/data/?type=0'
  155. , cols: [cols]
  156. , page: true
  157. , height: 'full-104'
  158. , totalRow: true
  159. ,parseData:function(res) {
  160. var cols = this.cols[0];
  161. for (var i in cols) {
  162. if (cols[i].field == 'count') {
  163. cols[i].totalRowText = res.more.total_count;
  164. }
  165. if (cols[i].field == 'return_count') {
  166. cols[i].totalRowText = res.more.total_return_count;
  167. }
  168. if (cols[i].field == 'amount') {
  169. cols[i].totalRowText = res.more.total_amount;
  170. }
  171. if (cols[i].field == 'deliver_count') {
  172. cols[i].totalRowText = res.more.total_deliver_count;
  173. }
  174. if (cols[i].field == 'surplus_count') {
  175. cols[i].totalRowText = res.more.total_surplus_count;
  176. }
  177. }
  178. return {
  179. "code": res.code, //解析接口状态
  180. "count": res.count, //解析数据长度
  181. "data": res.data //解析数据列表
  182. };
  183. }
  184. , done: function () {
  185. layui.index.removeNoPermButtons()
  186. }
  187. });
  188. //监听工具条
  189. table.on('tool(datagrid-operate)', function (obj) {
  190. var data = obj.data;
  191. if (obj.event === 'return') {
  192. layer.open({
  193. type: 2,
  194. title: '退货',
  195. shadeClose: false,
  196. area: ['80%', '90%'],
  197. btn: ['保存', '取消'],
  198. yes: function (index, dom) {
  199. layui.onSubmitChild = function (data) {
  200. layer.close(index);
  201. table.reload('datagrid', {});
  202. layer.msg('添加退货成功', {icon: 6});
  203. };
  204. layui.submitChild();
  205. },
  206. btn2: function (index, layero) {
  207. layer.close(index);//关闭当前按钮
  208. },
  209. content: 'material_godownentry_return_edit.html?godownentry_detail_id='+data.godownentry_detail_id
  210. });
  211. }
  212. });
  213. laydate.render({
  214. elem: '#entry_time'
  215. , range: true
  216. });
  217. laydate.render({
  218. elem: '#check_time'
  219. , range: true
  220. });
  221. $('#btn_export').on('click', function () {
  222. layui.admin.req({
  223. url: '/purchase/godownentry_query/export/?type=0',
  224. data: _params,
  225. done: function (res) {
  226. layui.view.download(res.data.filename);
  227. }
  228. });
  229. });
  230. $('#btn_query').on('click', function () {
  231. layer.open({
  232. type: 1,
  233. shadeClose: true,
  234. area: ['550px', '550px'],
  235. title: '查询',
  236. btn: ['查询'],
  237. yes: function (index, dom) {
  238. $("#query-submit").click();
  239. },
  240. content: $('#dlg_query')
  241. });
  242. });
  243. form.on('submit(query-form-element)', function (data) {
  244. //layer.msg(JSON.stringify(data.field));
  245. _params = data.field;
  246. table.reload('datagrid', {
  247. where: data.field,
  248. page:{curr:1}
  249. });
  250. layer.closeAll();
  251. return false
  252. });
  253. $('#btn_print').on('click', function () {
  254. layer.open({
  255. type: 2,
  256. title: '打印',
  257. shadeClose: true,
  258. area: ['90%', '90%'],
  259. btn: ['打印', '取消'],
  260. yes: function (index, dom) {
  261. layui.onSubmitChild = function(data){
  262. layer.close(index);
  263. };
  264. layui.submitChild();
  265. },
  266. btn2: function (index, layero) {
  267. layer.close(index);//关闭当前按钮
  268. },
  269. content: 'material_godownentry_query_print.html'
  270. });
  271. });
  272. })
  273. </script>
  274. </body>
  275. </html>