changeInventory.blade.php 13 KB

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