department_ledger.html 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  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. </head>
  12. <body>
  13. <div class="layui-fluid">
  14. <div class="layui-card">
  15. <div class="layui-card-body" pad15>
  16. <div class="layui-row layui-col-space15">
  17. <div class="layui-col-md12">
  18. <div class="LAY-btns" style="margin-bottom: 10px;">
  19. <button class="layui-btn layui-btn-sm" id="btn_export" data-permission="product.export_department_ledger"><i class="layui-icon layui-icon-download-circle"></i>导出</button>
  20. <button class="layui-btn layui-btn-sm" id="btn_query"><i class="layui-icon layui-icon-search"></i>查询</button>
  21. </div>
  22. <table class="layui-hide" id="dataTable" lay-filter="dataTable"></table>
  23. </div>
  24. </div>
  25. </div>
  26. </div>
  27. </div>
  28. <div id="dlg_query" style="display: none">
  29. <div class="layui-card-body" pad15>
  30. <form class="layui-form" lay-filter="query-form-element">
  31. <div class="layui-row layui-col-space10 layui-form-item">
  32. <div class="layui-col-xs12 layui-col-sm12">
  33. <label class="layui-form-label">日期:</label>
  34. <div class="layui-input-block">
  35. <input type="text" class="layui-input" autocomplete="off" name="date" id="id_date" placeholder=" - ">
  36. </div>
  37. </div>
  38. <div class="layui-col-xs12 layui-col-sm12">
  39. <label class="layui-form-label">产品类别:</label>
  40. <div class="layui-input-block">
  41. <select id="id_product_type" name="product_type">
  42. <option value="">全部</option>
  43. <option value="0">原料</option>
  44. <option value="1">耗材</option>
  45. <option value="2">成品</option>
  46. </select>
  47. </div>
  48. </div>
  49. <div class="layui-col-xs12 layui-col-sm12">
  50. <label class="layui-form-label">产品名称:</label>
  51. <div class="layui-input-block">
  52. <input type="text" name="product_name" autocomplete="off" class="layui-input">
  53. </div>
  54. </div>
  55. <div class="layui-col-xs12 layui-col-sm12">
  56. <label class="layui-form-label">产品代码:</label>
  57. <div class="layui-input-block">
  58. <input type="text" name="product_model" autocomplete="off" class="layui-input">
  59. </div>
  60. </div>
  61. <div class="layui-col-xs12 layui-col-sm12">
  62. <label class="layui-form-label" style="width: 100px;">去除全部为0:</label>
  63. <div class="layui-input-block">
  64. <input type="checkbox" name="exclude_zero" lay-skin="switch" lay-text="是|否">
  65. </div>
  66. </div>
  67. </div>
  68. <div class="layui-form-item" style="display: none">
  69. <button id="query_search" class="layui-btn" lay-submit lay-filter="query-form-element">查询</button>
  70. </div>
  71. </form>
  72. </div>
  73. </div>
  74. <script src="../../layuiadmin/layui/layui.js"></script>
  75. <script>
  76. var _data_list = [];
  77. var _departments = [];
  78. var _params = '';
  79. layui.config({
  80. base: '../../../layuiadmin/' //静态资源所在路径
  81. }).extend({
  82. index: 'lib/index' //主入口模块
  83. }).use(['index', 'form', 'table', 'laydate'], function(){
  84. var $ = layui.$
  85. ,admin = layui.admin
  86. ,form = layui.form
  87. ,laydate = layui.laydate
  88. ,table = layui.table;
  89. var title1 = [
  90. {title: '序号', type: 'numbers', rowspan: 2},
  91. {field: 'product_name', title: '产品名称', width: 150, rowspan: 2},
  92. {field: 'product_model', title: '产品代码', width: 150, rowspan: 2},
  93. {field: 'type_text', title: '类别', width: 80, rowspan: 2}
  94. ];
  95. var title2 = [];
  96. admin.req({
  97. url: '/account/select_department/',
  98. done: function(res){
  99. _departments = res.data;
  100. var data = res.data;
  101. for (var i in data) {
  102. title1.push({align: 'center', title: data[i].name, colspan: 2});
  103. title2.push({field: data[i].id+'_count', align:'right', title: '数量', width: 80});
  104. title2.push({field: data[i].id+'_amount', align:'right', title: '金额', width: 130});
  105. }
  106. _data_list=[title1,title2];
  107. rendTable();
  108. }
  109. });
  110. var layTableId = "dataTable";
  111. var tableIns = null;
  112. var rendTable =function () {
  113. tableIns = table.render({
  114. elem: '#dataTable'
  115. ,id:layTableId
  116. ,url: '/statistics/department_ledger/data/'
  117. ,cols: _data_list
  118. ,page: true
  119. ,totalRow: true
  120. ,parseData:function(res) {
  121. var cols = this.cols[1];
  122. for (var i in cols) {
  123. for (var k in _departments) {
  124. var key_count = _departments[k].id + '_count';
  125. var key_amount = _departments[k].id + '_amount';
  126. if (cols[i].field == key_count) {
  127. cols[i].totalRowText = res.more[key_count];
  128. }
  129. if (cols[i].field == key_amount) {
  130. cols[i].totalRowText = res.more[key_amount];
  131. }
  132. }
  133. }
  134. return {
  135. "code": res.code, //解析接口状态
  136. "count": res.count, //解析数据长度
  137. "data": res.data //解析数据列表
  138. };
  139. }
  140. ,height: 'full-104'
  141. ,done: function () {
  142. layui.index.removeNoPermButtons();
  143. }
  144. });
  145. };
  146. $('#btn_export').on('click', function(){
  147. layui.admin.req({
  148. url: '/statistics/department_ledger/export/',
  149. data:_params,
  150. done: function (res) {
  151. layui.view.download(res.data.filename);
  152. }
  153. });
  154. });
  155. $('#btn_query').on('click', function(){
  156. layer.open({
  157. type: 1,
  158. shadeClose: true,
  159. area: ['600px', '400px'],
  160. title: '查询',
  161. btn: ['查询'],
  162. yes: function(index, dom){
  163. $('#query_search').click();
  164. },
  165. content: $('#dlg_query')
  166. });
  167. });
  168. form.on('submit(query-form-element)', function(data){
  169. if (!data.field.exclude_zero) {
  170. data.field.exclude_zero = '';
  171. }
  172. _params = data.field;
  173. table.reload('dataTable', {
  174. where: data.field
  175. ,page:{curr:1}
  176. });
  177. layer.closeAll();
  178. return false
  179. });
  180. laydate.render({
  181. elem: '#id_date'
  182. ,range: true
  183. });
  184. })
  185. </script>
  186. </body>
  187. </html>