changeInventory.blade.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230
  1. @extends('layouts.app')
  2. @section('title')库存管理-动库报表@endsection
  3. @section('content')
  4. @component('inventory.statement.menu')@endcomponent
  5. <div id="list" class="d-none card container-fluid" style="min-width: 1500px">
  6. <div id="form_div"></div>
  7. <span class="dropdown">
  8. <button class="btn btn-outline-dark btn-sm form-control-sm dropdown-toggle tooltipTarget" :class="[checkData.length>0?'btn-dark text-light':'']"
  9. data-toggle="dropdown" title="导出所有页将会以搜索条件得到的筛选结果,将其全部记录(每一页)导出">
  10. 导出Excel
  11. </button>
  12. <div class="dropdown-menu">
  13. <a class="dropdown-item" @click="processExport(false)" href="javascript:">导出勾选内容</a>
  14. <a class="dropdown-item" @click="processExport(true)" href="javascript:">导出所有页</a>
  15. </div>
  16. </span>
  17. <label for="all" id="cloneCheckAll" class="d-none">
  18. <input id="all" type="checkbox" @click="checkAll($event)">全选
  19. </label>
  20. <table class="table table-sm table-bordered text-nowrap d-none" id="headerRoll"></table>
  21. <table class="table table-sm table-striped table-bordered table-hover text-nowrap card-body mt-2" id="headerParent">
  22. <tr id="header"></tr>
  23. <tr v-for="(oracleActTransactingLog,i) in oracleActTransactingLogs">
  24. <td>
  25. <input class="checkItem" type="checkbox" :value="oracleActTransactingLog" v-model="checkData">
  26. </td>
  27. <td>@{{ i+1 }}</td>
  28. <td class="text-primary">@{{ oracleActTransactingLog.货主 }}</td>
  29. <td class="text-muted">@{{ oracleActTransactingLog.库位 }}</td>
  30. <td class="text-muted">@{{ oracleActTransactingLog.产品编码 }}</td>
  31. <td class="text-muted">@{{ oracleActTransactingLog.产品条码 }}</td>
  32. <td :title="oracleActTransactingLog.商品名称" class="tooltipTarget" style="max-width: 200px;overflow:hidden">@{{ oracleActTransactingLog.商品名称 }}</td>
  33. <td class="text-muted">@{{ oracleActTransactingLog.属性仓 }}</td>
  34. <td class="text-muted">@{{ oracleActTransactingLog.质量状态 }}</td>
  35. <td class="text-muted">@{{ oracleActTransactingLog.失效日期 }}</td>
  36. <td class="text-muted">@{{ oracleActTransactingLog.批号 }}</td>
  37. @if(!$isTotalStock)
  38. <td>@{{ oracleActTransactingLog.移出数量 }}</td>
  39. <td>@{{ oracleActTransactingLog.移入数量 }}</td>
  40. @endif
  41. <td><span v-if="oracleActTransactingLog.在库数量">@{{ oracleActTransactingLog.在库数量 }}</span><span v-else>0</span></td>
  42. <td><span v-if="oracleActTransactingLog.占用数量">@{{ oracleActTransactingLog.占用数量 }}</span><span v-else>0</span></td>
  43. </tr>
  44. </table>
  45. <div>
  46. <button type="button" @click="pageUp()" :readonly="page>1?false:true" class="btn btn-sm " :class="page>1?'btn-outline-info':''">上一页</button>
  47. <button type="button" @click="pageDown()" :readonly="page<maxPage?false:true" class="btn btn-sm m-3" :class="page<maxPage?'btn-outline-info':''">下一页</button>
  48. <div v-if="isPage">
  49. <input @keyup.enter="pageSkip($event)" class="form-control-sm ml-3 tooltipTarget" :placeholder="'当前页数:'+page+'/'+maxPage" title="去往指定页">
  50. <span class="text-muted m-1">共 @{{ sum }} 条</span>
  51. </div>
  52. </div>
  53. </div>
  54. @endsection
  55. @section('lastScript')
  56. <script type="text/javascript" src="{{asset('js/queryForm/export200818a.js')}}"></script>
  57. <script type="text/javascript" src="{{asset('js/queryForm/queryForm200825.js')}}"></script>
  58. <script type="text/javascript" src="{{asset('js/queryForm/header200826b.js')}}"></script>
  59. <script>
  60. let vue=new Vue({
  61. el:"#list",
  62. data:{
  63. oracleActTransactingLogs:{!! $oracleActTransactingLogs !!},
  64. page:Number('{{$page}}'),
  65. owners:[
  66. @foreach($owners as $owner)
  67. {name:'{{$owner->descr_c}}',value:'{{$owner->descr_c}}'},
  68. @endforeach
  69. ],
  70. checkData:[],
  71. maxPage:1,
  72. sum:0,
  73. isPage:true,
  74. date:[{name:'1',value:'近一天'},{name:'3',value:'近三天'},{name:'7',value:'近一周'},{name:'30',value:'近一月'},],
  75. },
  76. mounted:function () {
  77. $(".tooltipTarget").tooltip({'trigger':'hover'});
  78. $("#list").removeClass('d-none');
  79. if (this.oracleActTransactingLogs.length>0){
  80. this.maxPage=Math.ceil(this.oracleActTransactingLogs[0].sum/50);
  81. this.sum=this.oracleActTransactingLogs[0].sum;
  82. }
  83. let data=[
  84. [
  85. {name:['date_start','range'],type:'dateTime_select',tip:['选择创建日期的起始时间','查询内容的日期范围'],placeholder:['','查询内容的日期范围'],data: this.date
  86. ,killings:[['range'],['date_start']]},
  87. {name:'TOLocation',type:'input',tip:'库位:糊模查找需要在左边打上%符号',placeholder: '库位'},
  88. {name:'LotAtt05',type:'input',tip:'属性仓:糊模查找需要在左边打上%符号',placeholder: '属性仓'},
  89. {name:'LotAtt02_start',type:'dateTime',tip:'选择显示失效日期的起始时间'},
  90. {name:'descr_c',type:'select_multiple_select',tip:['输入关键词快速定位下拉列表,回车确定','选择要显示的客户'],
  91. placeholder:['货主','定位或多选货主'],data:this.owners},
  92. ],
  93. [
  94. {name:'date_end',type:'dateTime',tip:'选择创建日期的结束时间',killings:['range']},
  95. {name:'SKU',type:'input',tip:'产品编码:糊模查找需要在左边打上%符号',placeholder: '产品编码'},
  96. {name:'ALTERNATE_SKU1',type:'input',tip:'产品条码:糊模查找需要在左边打上%符号',placeholder: '产品条码'},
  97. {name:'LotAtt02_end',type:'dateTime',tip:'选择显示失效日期的结束时间'},
  98. ],
  99. ];
  100. this.form = new query({
  101. el:'#form_div',
  102. condition:data
  103. });
  104. this.form.init();
  105. let thisUrl=document.URL;
  106. let parameter=thisUrl.split('?',2);
  107. if (parameter.length > 1){
  108. let _this=this;
  109. let list=['ALTERNATE_SKU1','LotAtt05','LotAtt02_start','descr_c','LotAtt02_end'];
  110. let param=parameter[1].split('&');
  111. param.every(function (data) {
  112. let arr=data.split('=');
  113. if (arr.length > 1){
  114. if (list.includes(arr[0]) && arr[1]){
  115. _this.isPage = false;
  116. return false;
  117. }
  118. }
  119. return true;
  120. });
  121. }
  122. let column = [
  123. {name:'cloneCheckAll',customization:true,type:'checkAll',
  124. dom:$('#cloneCheckAll').removeClass('d-none'), neglect: true},
  125. {name:'index',value: '序号', neglect: true},
  126. {name:'货主',value: '货主', class:'text-primary'},
  127. {name:'库位',value: '库位', class:'text-muted'},
  128. {name:'产品编码',value: '产品编码', class:'text-muted'},
  129. {name:'产品条码',value: '产品条码', class:'text-muted'},
  130. {name:'商品名称',value: '商品名称'},
  131. {name:'属性仓',value: '属性仓', class:'text-muted'},
  132. {name:'质量状态',value: '质量状态', class:'text-muted'},
  133. {name:'失效日期',value: '失效日期', class:'text-muted'},
  134. {name:'批号',value: '批号', class:'text-muted'},
  135. @if(!$isTotalStock)
  136. {name:'移出数量',value: '移出数量', neglect: true},
  137. {name:'移入数量',value: '移入数量', neglect: true},
  138. @endif
  139. {name:'在库数量',value: '在库数量', neglect: true},
  140. {name:'占用数量',value: '占用数量', neglect: true},
  141. ];
  142. let header=null;
  143. let _this = this;
  144. setTimeout(function () {
  145. header = new Header({
  146. el: "#header",
  147. column: column,
  148. data: _this.oracleActTransactingLogs,
  149. restorationColumn: 'rn',
  150. is_restorationColumn_asc:true,
  151. fixedTop:($('#form_div').height())+2,
  152. offset:0.5,
  153. vue:vue
  154. });
  155. header.init();
  156. },0);
  157. },
  158. watch:{
  159. checkData:{
  160. handler(){
  161. if (this.checkData.length === this.oracleActTransactingLogs.length){
  162. document.querySelector('#all').checked = true;
  163. document.querySelector('#all_temp').checked = true;
  164. }else {
  165. document.querySelector('#all').checked = false;
  166. document.querySelector('#all_temp').checked = false;
  167. }
  168. },
  169. deep:true
  170. }
  171. },
  172. methods:{
  173. pageUp(){
  174. if (this.page<=1)return;
  175. this.href(this.page-1);
  176. },
  177. pageDown(){
  178. if (this.page>=this.maxPage)return;
  179. this.href(this.page+1);
  180. },
  181. pageSkip(e){
  182. if (Number(e.target.value)<=0 || Number(e.target.value)>this.maxPage){
  183. tempTip.setDuration(2000);
  184. tempTip.show('页数不存在! ');
  185. return
  186. }
  187. this.href(e.target.value);
  188. },
  189. href(page){
  190. let url = document.URL;
  191. if (url.indexOf('page='+this.page) != -1){
  192. url = url.replace("page="+this.page,"page="+page);
  193. }else{
  194. if (url.indexOf('?') == -1) url += "?page="+page;
  195. else url += "&page="+page;
  196. }
  197. window.location.href=url;
  198. },
  199. //全选事件
  200. checkAll(e){
  201. if (e.target.checked){
  202. this.oracleActTransactingLogs.forEach((el,i)=>{
  203. if (this.checkData.indexOf(el) == '-1'){
  204. this.checkData.push(el);
  205. }
  206. });
  207. }else {
  208. this.checkData = [];
  209. }
  210. },
  211. processExport(checkAllSign){
  212. let url = '{{url('inventory/statement/changeInventory/export')}}';
  213. let token='{{ csrf_token() }}';
  214. let data= JSON.stringify( this.checkData );
  215. excelExport(checkAllSign,data,url,this.sum,token);
  216. },
  217. },
  218. filters:{
  219. json(value) {
  220. return JSON.stringify(value);
  221. }
  222. },
  223. });
  224. </script>
  225. @endsection