Головна сторінка Огляд Довідка
Реєстрація Увійти
wushaodong
/
scj
1
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: 3859d354c0
Гілки Теги
scj
/
uis
/
views
/
goods
/
goods_stock_ledger.html

goods_stock_ledger.html 11 KB
Історія Запис

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253 
  1. <!DOCTYPE html>
    2. 

  2. <html>
    3. 

  3. <head>
    4. 

  4.     <meta charset="utf-8">
    5. 

  5.     <title>添加成品</title>
    6. 

  6.     <meta name="renderer" content="webkit">
    7. 

  7.     <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    8. 

  8.     <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    9. 

  9.     <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    10. 

  10.     <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    11. 

  11.     <style type="text/css">
    12. 

  12.         .layui-form-select dl{max-height: 150px;}
    13. 

  13.     </style>
    14. 

  14. </head>
    15. 

  15. <body>
    16. 

  16. <div class="layui-fluid">
    17. 

  17.     <div class="layui-card">
    18. 

  18.         <div class="layui-card-body" pad15>
    19. 

  19.             <div class="layui-row layui-col-space15">
    20. 

  20.                 <div class="layui-col-md12">
    21. 

  21.                     <div class="LAY-btns" style="margin-bottom: 10px;">
    22. 

  22. 

  23.                   <button class="layui-btn layui-btn-sm" id="btn_export" data-permission="product.export_goods_stock_ledger"><i class="layui-icon layui-icon-download-circle"></i>导出</button>
    24. 

  24.                   <button class="layui-btn layui-btn-sm" id="btn_query"><i class="layui-icon layui-icon-search"></i>查询</button>
    25. 

  25.                 </div>
    26. 

  26.                 <table class="layui-hide" id="datagrid" lay-filter="datagrid-operate"></table>
    27. 

  27.                 </div>
    28. 

  28.             </div>
    29. 

  29.         </div>
    30. 

  30.     </div>
    31. 

  31. </div>
    32. 

  32. 

  33. 

  34. <div id="dlg_query" style="display: none">
    35. 

  35.     <div class="layui-card-body" pad15>
    36. 

  36.         <form class="layui-form" lay-filter="query-form-element">
    37. 

  37.           <div class="layui-row layui-col-space10 layui-form-item">
    38. 

  38.               <div class="layui-col-xs12 layui-col-sm12">
    39. 

  39.                 <label class="layui-form-label">日期：</label>
    40. 

  40.                 <div class="layui-input-block">
    41. 

  41.                     <input type="text" class="layui-input" autocomplete="off" name="date" id="id_date" placeholder=" - ">
    42. 

  42.                 </div>
    43. 

  43.             </div>
    44. 

  44.             <div class="layui-col-xs12 layui-col-sm12">
    45. 

  45.                 <label class="layui-form-label">仓别：</label>
    46. 

  46.                 <div class="layui-input-block">
    47. 

  47.                     <select id="id_warehouse" name="warehouse">
    48. 

  48.                       <option value="">选择仓别</option>
    49. 

  49.                     </select>
    50. 

  50.                 </div>
    51. 

  51.             </div>
    52. 

  52.             <div class="layui-col-xs12 layui-col-sm12">
    53. 

  53.                 <label class="layui-form-label">产品名称：</label>
    54. 

  54.                 <div class="layui-input-block">
    55. 

  55.                     <input type="text" name="product_name" autocomplete="off" class="layui-input">
    56. 

  56.                 </div>
    57. 

  57.             </div>
    58. 

  58.               <div class="layui-col-xs12 layui-col-sm12">
    59. 

  59.                 <label class="layui-form-label">产品代码：</label>
    60. 

  60.                 <div class="layui-input-block">
    61. 

  61.                     <input type="text" name="product_model" autocomplete="off" class="layui-input">
    62. 

  62.                 </div>
    63. 

  63.             </div>
    64. 

  64.             <div class="layui-col-xs12 layui-col-sm12">
    65. 

  65.                 <label class="layui-form-label" style="width: 100px;">去除全部为0：</label>
    66. 

  66.                 <div class="layui-input-block">
    67. 

  67.                     <input type="checkbox" name="exclude_zero" lay-skin="switch" lay-text="是|否">
    68. 

  68.                 </div>
    69. 

  69.             </div>
    70. 

  70.           </div>
    71. 

  71.           <div class="layui-form-item" style="display: none">
    72. 

  72.                 <button id="query_search" class="layui-btn" lay-submit lay-filter="query-form-element">查询</button>
    73. 

  73.           </div>
    74. 

  74.         </form>
    75. 

  75.     </div>
    76. 

  76.    </div>
    77. 

  77. 

  78. 

  79. <script src="../../layuiadmin/layui/layui.js"></script>
    80. 

  80. <script>
    81. 

  81.     var _data_list = [];
    82. 

  82.     var _params = '';
    83. 

  83.     layui.config({
    84. 

  84.         base: '../../../layuiadmin/' //静态资源所在路径
    85. 

  85.     }).extend({
    86. 

  86.         index: 'lib/index' //主入口模块
    87. 

  87.     }).use(['index', 'form', 'table', 'laydate'], function(){
    88. 

  88.         var $ = layui.$
    89. 

  89.         ,admin = layui.admin
    90. 

  90.         ,form = layui.form
    91. 

  91.         ,laydate = layui.laydate
    92. 

  92.         ,table = layui.table;
    93. 

  93. 

  94.         admin.req({
    95. 

  95.           url: '/warehouse/all_select/?type=2',
    96. 

  96.           done: function(res){
    97. 

  97.             var data = res.data;
    98. 

  98.             var warehouse_node = $('#id_warehouse');
    99. 

  99.             for (var i in data) {
    100. 

  100.                 var pid = data[i].id;
    101. 

  101.                 var value = data[i].name;
    102. 

  102.                 warehouse_node.append("<option value='"+pid+"'>"+value+"</option>");
    103. 

  103.             }
    104. 

  104.             form.render();
    105. 

  105.          }
    106. 

  106.         });
    107. 

  107. 

  108.         var title1 = [
    109. 

  109.             {title: '序号', type: 'numbers', rowspan: 2},
    110. 

  110.             {field: 'product_name', title: '产品名称', width: 150, rowspan: 2},
    111. 

  111.             {field: 'product_model', title: '产品代码', width: 150, rowspan: 2},
    112. 

  112.             {field: 'unit', title: '单位', width: 80, rowspan: 2},
    113. 

  113.             {align: 'center', title: '期初结存', width: 100, colspan: 3},
    114. 

  114.             {align: 'center', title: '本期收入', width: 100, colspan: 9},
    115. 

  115.             {align: 'center', title: '本期发出', width: 100, colspan: 9},
    116. 

  116.             {align: 'center', title: '期末结存', width: 100, colspan: 9}
    117. 

  117.         ];
    118. 

  118. 

  119.         var title2 = [
    120. 

  120.             {field: 'prev_count', align:'right', title: '数量', width: 100},
    121. 

  121.             {field: 'prev_avg', align:'right', title: '平均单价', width: 100},
    122. 

  122.             {field: 'prev_amount', align:'right', title: '金额', width: 130},
    123. 

  123.             {field: 'in_count', align:'right', title: '总数量', width: 100},
    124. 

  124.             {field: 'in_avg', align:'right', title: '平均单价', width: 100},
    125. 

  125.             {field: 'in_amount', align:'right', title: '总金额', width: 130},
    126. 

  126.             {field: 'rk_count', align:'right', title: '入库数量', width: 100},
    127. 

  127.             {field: 'rk_amount', align:'right', title: '入库金额', width: 130},
    128. 

  128.             {field: 'py_count', align:'right', title: '盘盈数量', width: 100},
    129. 

  129.             {field: 'py_amount', align:'right', title: '盘盈金额', width: 130},
    130. 

  130.             {field: 'th_count', align:'right', title: '退货数量', width: 100},
    131. 

  131.             {field: 'th_amount', align:'right', title: '退货金额', width: 130},
    132. 

  132.             {field: 'out_count', align:'right', title: '总数量', width: 100},
    133. 

  133.             {field: 'out_avg', align:'right', title: '平均单价', width: 100},
    134. 

  134.             {field: 'out_amount', align:'right', title: '总金额', width: 130},
    135. 

  135.             {field: 'ck_count', align:'right', title: '出库数量', width: 100},
    136. 

  136.             {field: 'ck_amount', align:'right', title: '出库金额', width: 130},
    137. 

  137.             {field: 'pk_count', align:'right', title: '盘亏数量', width: 100},
    138. 

  138.             {field: 'pk_amount', align:'right', title: '盘亏金额', width: 130},
    139. 

  139.             {field: 'tl_count', align:'right', title: '退料数量', width: 100},
    140. 

  140.             {field: 'tl_amount', align:'right', title: '退料金额', width: 130},
    141. 

  141.             {field: 'remain_count', align:'right', title: '数量', width: 100},
    142. 

  142.             {field: 'remain_avg', align:'right', title: '平均单价', width: 100},
    143. 

  143.             {field: 'remain_amount', align:'right', title: '金额', width: 130}
    144. 

  144.         ];
    145. 

  145.         _data_list=[title1,title2];
    146. 

  146. 

  147.         table.render({
    148. 

  148.           elem: '#datagrid'
    149. 

  149.           ,url: '/warehouse/stock/ledger_data/?product_type=2'
    150. 

  150.           ,cols: _data_list
    151. 

  151.           ,page: true
    152. 

  152.           ,totalRow: true
    153. 

  153.           ,parseData:function(res) {
    154. 

  154.             var cols = this.cols[1];
    155. 

  155.             for (var i in cols) {
    156. 

  156.                 if (cols[i].field == 'prev_count') {
    157. 

  157.                     cols[i].totalRowText = res.more.prev_count;
    158. 

  158.                 } else if (cols[i].field == 'prev_amount') {
    159. 

  159.                     cols[i].totalRowText = res.more.prev_amount;
    160. 

  160.                 } else if (cols[i].field == 'remain_count') {
    161. 

  161.                     cols[i].totalRowText = res.more.remain_count;
    162. 

  162.                 }else if (cols[i].field == 'remain_amount') {
    163. 

  163.                     cols[i].totalRowText = res.more.remain_amount;
    164. 

  164.                 } else if (cols[i].field == 'rk_count') {
    165. 

  165.                     cols[i].totalRowText = res.more.rk_count;
    166. 

  166.                 } else if (cols[i].field == 'rk_amount') {
    167. 

  167.                     cols[i].totalRowText = res.more.rk_amount;
    168. 

  168.                 } else if (cols[i].field == 'tl_count') {
    169. 

  169.                     cols[i].totalRowText = res.more.tl_count;
    170. 

  170.                 } else if (cols[i].field == 'tl_amount') {
    171. 

  171.                     cols[i].totalRowText = res.more.tl_amount;
    172. 

  172.                 } else if (cols[i].field == 'py_count') {
    173. 

  173.                     cols[i].totalRowText = res.more.py_count;
    174. 

  174.                 } else if (cols[i].field == 'py_amount') {
    175. 

  175.                     cols[i].totalRowText = res.more.py_amount;
    176. 

  176.                 }else if (cols[i].field == 'ck_count') {
    177. 

  177.                     cols[i].totalRowText = res.more.ck_count;
    178. 

  178.                 }else if (cols[i].field == 'ck_amount') {
    179. 

  179.                     cols[i].totalRowText = res.more.ck_amount;
    180. 

  180.                 }else if (cols[i].field == 'th_count') {
    181. 

  181.                     cols[i].totalRowText = res.more.th_count;
    182. 

  182.                 }else if (cols[i].field == 'th_amount') {
    183. 

  183.                     cols[i].totalRowText = res.more.th_amount;
    184. 

  184.                 }else if (cols[i].field == 'pk_count') {
    185. 

  185.                     cols[i].totalRowText = res.more.pk_count;
    186. 

  186.                 }else if (cols[i].field == 'pk_amount') {
    187. 

  187.                     cols[i].totalRowText = res.more.pk_amount;
    188. 

  188.                 }else if (cols[i].field == 'in_count') {
    189. 

  189.                     cols[i].totalRowText = res.more.in_count;
    190. 

  190.                 }else if (cols[i].field == 'in_amount') {
    191. 

  191.                     cols[i].totalRowText = res.more.in_amount;
    192. 

  192.                 }else if (cols[i].field == 'out_count') {
    193. 

  193.                     cols[i].totalRowText = res.more.out_count;
    194. 

  194.                 }else if (cols[i].field == 'out_amount') {
    195. 

  195.                     cols[i].totalRowText = res.more.out_amount;
    196. 

  196.                 }
    197. 

  197.             }
    198. 

  198.             return {
    199. 

  199.               "code": res.code, //解析接口状态
    200. 

  200.               "count": res.count, //解析数据长度
    201. 

  201.               "data": res.data //解析数据列表
    202. 

  202.             };
    203. 

  203.           }
    204. 

  204.           ,height: 'full-104'
    205. 

  205.           ,done: function () {
    206. 

  206.             layui.index.removeNoPermButtons();
    207. 

  207.           }
    208. 

  208.         });
    209. 

  209. 

  210.         $('#btn_export').on('click', function(){
    211. 

  211.             layui.admin.req({
    212. 

  212.                 url: '/warehouse/stock/ledger_export/?product_type=2',
    213. 

  213.                 data:_params,
    214. 

  214.                 done: function (res) {
    215. 

  215.                       layui.view.download(res.data.filename);
    216. 

  216.                 }
    217. 

  217.             });
    218. 

  218.         });
    219. 

  219. 

  220.         $('#btn_query').on('click', function(){
    221. 

  221.             layer.open({
    222. 

  222.               type: 1,
    223. 

  223.               shadeClose: true,
    224. 

  224.               area: ['600px', '400px'],
    225. 

  225.               title: '查询',
    226. 

  226.               btn: ['查询'],
    227. 

  227.               yes: function(index, dom){
    228. 

  228.                  $('#query_search').click();
    229. 

  229.               },
    230. 

  230.               content: $('#dlg_query')
    231. 

  231.             });
    232. 

  232.         });
    233. 

  233.         form.on('submit(query-form-element)', function(data){
    234. 

  234.           if (!data.field.exclude_zero) {
    235. 

  235.               data.field.exclude_zero = '';
    236. 

  236.           }
    237. 

  237.           _params = data.field;
    238. 

  238.           table.reload('datagrid', {
    239. 

  239.               where: data.field
    240. 

  240.               ,page:{curr:1}
    241. 

  241.           });
    242. 

  242.           layer.closeAll();
    243. 

  243.           return false
    244. 

  244.         });
    245. 

  245. 

  246.         laydate.render({
    247. 

  247.         elem: '#id_date'
    248. 

  248.         ,range: true
    249. 

  249.     });
    250. 

  250.     })
    251. 

  251. </script>
    252. 

  252. </body>
    253. 

  253. </html>
    254.