changeInventory.blade.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  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"
  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. <table class="table table-sm table-striped table-bordered table-hover text-nowrap card-body mt-2 td-min-width-80" id="table">
  18. <tr v-for="(oracleActTransactingLog,i) in oracleActTransactingLogs" @click="selectedColor(oracleActTransactingLog.id,$event)">
  19. <td>
  20. <input class="checkItem" type="checkbox" :value="oracleActTransactingLog">
  21. </td>
  22. <td><span>@{{ i+1 }}</span></td>
  23. <td class="text-primary"><span>@{{ oracleActTransactingLog.货主 }}</span></td>
  24. <td class="text-muted"><span>@{{ oracleActTransactingLog.库位 }}</span></td>
  25. <td class="text-muted"><span>@{{ oracleActTransactingLog.产品编码 }}</span></td>
  26. <td class="text-muted"><span>@{{ oracleActTransactingLog.产品条码 }}</span></td>
  27. <td :title="oracleActTransactingLog.商品名称" class="tooltipTarget" style="max-width: 200px;overflow:hidden"><span>@{{ oracleActTransactingLog.商品名称 }}</span></td>
  28. <td class="text-muted"><span>@{{ oracleActTransactingLog.属性仓 }}</span></td>
  29. <td class="text-muted"><span>@{{ oracleActTransactingLog.质量状态 }}</span></td>
  30. <td class="text-muted"><span>@{{ oracleActTransactingLog.失效日期 }}</span></td>
  31. <td class="text-muted"><span>@{{ oracleActTransactingLog.批号 }}</span></td>
  32. <td v-if="!isTotalStock"><span>@{{ oracleActTransactingLog.移出数量 }}</span></td>
  33. <td v-if="!isTotalStock"><span>@{{ oracleActTransactingLog.移入数量 }}</span></td>
  34. <td><span v-if="oracleActTransactingLog.在库数量">@{{ oracleActTransactingLog.在库数量 }}</span><span v-else>0</span></td>
  35. <td><span v-if="oracleActTransactingLog.占用数量">@{{ oracleActTransactingLog.占用数量 }}</span><span v-else>0</span></td>
  36. </tr>
  37. </table>
  38. <div>
  39. <button type="button" @click="pageUp()" :readonly="page>1?false:true" class="btn btn-sm " :class="page>1?'btn-outline-info':''">上一页</button>
  40. <button type="button" @click="pageDown()" :readonly="page<maxPage?false:true" class="btn btn-sm m-3" :class="page<maxPage?'btn-outline-info':''">下一页</button>
  41. <div v-if="isPage">
  42. <input @keyup.enter="pageSkip($event)" class="form-control-sm ml-3 tooltipTarget" :placeholder="'当前页数:'+page+'/'+maxPage" title="去往指定页">
  43. <span class="text-muted m-1">共 @{{ sum }} 条</span>
  44. </div>
  45. </div>
  46. </div>
  47. @endsection
  48. @section('lastScript')
  49. <script type="text/javascript" src="{{mix('js/queryForm/export.js')}}"></script>
  50. <script type="text/javascript" src="{{mix('js/queryForm/queryForm.js')}}"></script>
  51. <script type="text/javascript" src="{{mix('js/queryForm/header.js')}}"></script>{{--新版2--}}
  52. <script>
  53. let vue=new Vue({
  54. el:"#list",
  55. data:{
  56. oracleActTransactingLogs:{!! $oracleActTransactingLogs !!},
  57. page:Number('{{$page}}'),
  58. owners:[
  59. @foreach($owners as $owner)
  60. {name:'{{$owner->code}}',value:'{{$owner->name}}'},
  61. @endforeach
  62. ],
  63. maxPage:1,
  64. sum:0,
  65. isPage:true,
  66. date:[{name:'1',value:'近一天'},{name:'3',value:'近三天'},{name:'7',value:'近一周'},{name:'30',value:'近一月'},],
  67. isTotalStock : "{{ $isTotalStock }}",
  68. selectTr:''
  69. },
  70. mounted:function () {
  71. $(".tooltipTarget").tooltip({'trigger':'hover'});
  72. $("#list").removeClass('d-none');
  73. if (this.oracleActTransactingLogs.length>0){
  74. this.maxPage=Math.ceil(this.oracleActTransactingLogs[0].sum/50);
  75. this.sum=this.oracleActTransactingLogs[0].sum;
  76. }
  77. let data=[
  78. [
  79. {name:['date_start','range'],type:'dateTime_select',tip:['选择创建日期的起始时间','查询内容的日期范围'],placeholder:['','查询内容的日期范围'],data: this.date
  80. ,killings:[['range'],['date_start']]},
  81. {name:'TOLocation',type:'input',tip:'可支持多库位,糊模查找需要在左边打上%符号',placeholder: '库位'},
  82. {name:'LotAtt05',type:'input',tip:'可支持多属性仓,糊模查找需要在左边打上%符号',placeholder: '属性仓'},
  83. {name:'LotAtt02_start',type:'dateTime',tip:'选择显示失效日期的起始时间'},
  84. {name:'customerid',type:'select_multiple_select',tip:['输入关键词快速定位下拉列表,回车确定','选择要显示的客户'],
  85. placeholder:['货主','定位或多选货主'],data:this.owners},
  86. ],
  87. [
  88. {name:'date_end',type:'dateTime',tip:'选择创建日期的结束时间',killings:['range']},
  89. {name:'SKU',type:'input',tip:'可支持多产品编码,糊模查找需要在左边打上%符号',placeholder: '产品编码'},
  90. {name:'ALTERNATE_SKU1',type:'input',tip:'可支持多产品条码,糊模查找需要在左边打上%符号',placeholder: '产品条码'},
  91. {name:'LotAtt02_end',type:'dateTime',tip:'选择显示失效日期的结束时间'},
  92. ],
  93. ];
  94. this.form = new query({
  95. el:'#form_div',
  96. condition:data
  97. });
  98. this.form.init();
  99. let thisUrl=document.URL;
  100. let parameter=thisUrl.split('?',2);
  101. if (parameter.length > 1){
  102. let _this=this;
  103. let list=['ALTERNATE_SKU1','LotAtt05','LotAtt02_start','descr_c','LotAtt02_end'];
  104. let param=parameter[1].split('&');
  105. param.every(function (data) {
  106. let arr=data.split('=');
  107. if (arr.length > 1){
  108. if (list.includes(arr[0]) && arr[1]){
  109. _this.isPage = false;
  110. return false;
  111. }
  112. }
  113. return true;
  114. });
  115. }
  116. let column = [
  117. {name:'index',value: '序号', neglect: true},
  118. {name:'货主',value: '货主', class:'text-primary'},
  119. {name:'库位',value: '库位', class:'text-muted'},
  120. {name:'产品编码',value: '产品编码', class:'text-muted'},
  121. {name:'产品条码',value: '产品条码', class:'text-muted'},
  122. {name:'商品名称',value: '商品名称'},
  123. {name:'属性仓',value: '属性仓', class:'text-muted'},
  124. {name:'质量状态',value: '质量状态', class:'text-muted'},
  125. {name:'失效日期',value: '失效日期', class:'text-muted'},
  126. {name:'批号',value: '批号', class:'text-muted'},
  127. @if(!$isTotalStock)
  128. {name:'移出数量',value: '移出数量', neglect: true},
  129. {name:'移入数量',value: '移入数量', neglect: true},
  130. @endif
  131. {name:'在库数量',value: '在库数量', neglect: true},
  132. {name:'占用数量',value: '占用数量', neglect: true},
  133. ];
  134. new Header({
  135. el: "table",
  136. name: "changeInventory",
  137. column: column,
  138. data: this.oracleActTransactingLogs,
  139. restorationColumn: 'rn',
  140. is_restorationColumn_asc:true,
  141. fixedTop:($('#form_div').height())+2,
  142. }).init();
  143. },
  144. methods:{
  145. selectedColor(id,e){
  146. $('#headerParent tr[class=focusing]').removeClass('focusing')
  147. if (id==this.selectTr){
  148. this.selectTr='';
  149. return;
  150. }
  151. this.selectTr=id;
  152. $(e.target).parent('tr').addClass('focusing')
  153. },
  154. pageUp(){
  155. if (this.page<=1)return;
  156. this.href(this.page-1);
  157. },
  158. pageDown(){
  159. if (this.page>=this.maxPage)return;
  160. this.href(this.page+1);
  161. },
  162. pageSkip(e){
  163. if (Number(e.target.value)<=0 || Number(e.target.value)>this.maxPage){
  164. tempTip.setDuration(2000);
  165. tempTip.show('页数不存在! ');
  166. return
  167. }
  168. this.href(e.target.value);
  169. },
  170. href(page){
  171. let url = document.URL;
  172. if (url.indexOf('page='+this.page) != -1){
  173. url = url.replace("page="+this.page,"page="+page);
  174. }else{
  175. if (url.indexOf('?') == -1) url += "?page="+page;
  176. else url += "&page="+page;
  177. }
  178. window.location.href=url;
  179. },
  180. processExport(checkAllSign){
  181. let url = '{{url('inventory/statement/allInventory/export')}}';
  182. if (!this.isTotalStock)
  183. url = '{{url('inventory/statement/changeInventory/export')}}';
  184. let token='{{ csrf_token() }}';
  185. let data= JSON.stringify( checkData );
  186. excelExport(checkAllSign,data,url,this.sum,token);
  187. },
  188. },
  189. filters:{
  190. json(value) {
  191. return JSON.stringify(value);
  192. }
  193. },
  194. });
  195. </script>
  196. @endsection