import.blade.php 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. @extends('layouts.app')
  2. @section('title')导入-问题件@endsection
  3. @section('content')
  4. <div class="container-fluid" id="issue_import_div">
  5. <div class="card col-md-8 offset-md-2">
  6. <div class="card-body">
  7. <div class="form-group row text-center">
  8. <div class="col-12 text-danger">
  9. 注意:请保证表第一行有以下对应的字段名<br><span class="text-muted">(可不按顺序):</span><br>
  10. 原始运单号,问题类别,情况说明<br>
  11. <span class="text-muted" style="opacity:0.7"> 订单问题类别:('拦截', '快递异常', '信息更改', '联系不上', '其他', '错漏发', '仓库问题', '快递丢件', '破损', '撤销丢件', '二次加工', '全检问题', '系统问题', '延迟发货', '仓库丢件', )<br></span>
  12. </div>
  13. <div class="col-12 text-info ">
  14. 导入时间随文件大小可能达数十分钟以上,请耐心等候
  15. <hr>
  16. </div>
  17. </div>
  18. @can('订单管理-问题件-导入-文本导入')
  19. <div class="form-group row text-center">
  20. <div class="col-12 text-danger">
  21. 订单问题类别:同Excel文件导入所要求的订单问题类别一致<br/>
  22. 注意:文本导入的问题件只有全部符合条件的才能生成问题件,自定义订单号可不填<br/>
  23. <span class="text-muted" style="opacity:0.7">
  24. 如果在导入后出现部分数据导入失败,修改对应错误的数据继续导入即可
  25. </span>
  26. </div>
  27. </div>
  28. <div class="form-group row">
  29. <div class="col-8 offset-2">
  30. <button type="button" class="btn form-control btn-primary" @click="showPasteDataModal">文本导入</button>
  31. </div>
  32. </div>
  33. <hr/>
  34. @endcan
  35. @can('订单管理-问题件-导入-Excel导入')
  36. <form action="{{url('order/issue/batchImport')}}" method="post" enctype="multipart/form-data" class="form" target="_blank">
  37. @csrf
  38. <div class="form-group row">
  39. <label for="sku" class="col-2 col-form-label text-right">选择EXCEL</label>
  40. <div class="col-8">
  41. <div class="form-control">
  42. <input type="file" class="form-control-file @error('file') is-invalid @enderror"
  43. name="file" value="{{ old('file') }}" required>
  44. @error('file')
  45. <span class="invalid-feedback" role="alert">
  46. <strong>{{ $message }}</strong>
  47. </span>
  48. @enderror
  49. </div>
  50. </div>
  51. </div>
  52. <div class="form-group row">
  53. <div class="col-8 offset-2">
  54. <input type="submit" class="btn btn-success form-control" value="执行导入">
  55. </div>
  56. </div>
  57. </form>
  58. @endcan
  59. </div>
  60. </div>
  61. <div class="modal fade" id="pasteData" role="dialog" tabindex="-1" aria-labelledby="pasteDataTetlie" aria-hidden="true">
  62. <div class="modal-dialog modal-dialog-centered modal-lg" role="document">
  63. <div class="modal-content">
  64. <div class="modal-header">
  65. <div class="row modal-title font-weight-bold w-100 text-nowrap ml-1 noselect" id="pasteDataTitle">
  66. <span v-for="(row,i) in rows" draggable="true"
  67. @drop="drop($event,i)" @dragover="dragover($event)" @dragstart="dragstart($event,i)"
  68. class="col-3 border" style="cursor: move"
  69. :class="requiredRows.includes(row)?'text-danger':''">@{{ row }}</span>
  70. </div>
  71. </div>
  72. <div class="modal-body text-center">
  73. <div class="form-group text-left">
  74. <input type="text" class="form-control-sm" v-model="hiddenTag" placeholder="输入标识">
  75. </div>
  76. <button type="button" id="popover" class="btn btn-danger" v-if="popoverContent"
  77. data-container="body" data-toggle="popover" data-placement="bottom"
  78. :data-content="popoverContent" data-html="true">
  79. 部分数据导入失败
  80. </button>
  81. <textarea id="pasteDataText" class="w-100" style="height: 400px" v-model="pasteDataText"
  82. @keydown.tab="forbidTab($event)" @keyup.tab="replaceSpacing()"
  83. placeholder="内容可为EXCEL复制,也可手动输入使用“TAB”缩进符区分列,请注意表头顺序,可拖拽表头字段调整顺序,以该顺序为准"></textarea>
  84. </div>
  85. <div class="modal-footer">
  86. <button class="btn btn-primary" @click="importPasteData">开始导入</button>
  87. </div>
  88. </div>
  89. </div>
  90. </div>
  91. </div>
  92. @endsection
  93. @section('lastScript')
  94. <script>
  95. let listVue = new Vue({
  96. el:'#issue_import_div',
  97. data:{
  98. rows:['原始运单号','问题类别','情况说明','自定义订单号'],
  99. requiredRows:['原始运单号','问题类别','情况说明','自定义订单号'],
  100. popoverContent:'',
  101. pasteDataText: '',
  102. hiddenTag:null
  103. },
  104. mounted:function(){
  105. $('[data-toggle="popover"]').popover();
  106. },
  107. methods:{
  108. showPasteDataModal(){
  109. $('#popover').attr('hidden','hidden')
  110. $('#pasteData').modal('show')
  111. },
  112. drop(e,index){
  113. e.preventDefault();
  114. if (this.dom !== e.target.innerHTML){
  115. this.dom.innerHTML = e.target.innerHTML;
  116. let temp=JSON.parse(JSON.stringify(this.rows[index]));
  117. this.$set(this.rows,index,this.rows[e.dataTransfer.getData('text/html')]);
  118. this.$set(this.rows,Number(e.dataTransfer.getData('text/html')),temp);
  119. }
  120. },
  121. dragover(e){
  122. e.preventDefault();
  123. },
  124. dragstart(e,index){
  125. this.dom = e.target.innerHTML;
  126. e.dataTransfer.setData("text/html",index);
  127. },
  128. importPasteData(){
  129. if(!this.pasteDataText){
  130. tempTip.setDuration(2000)
  131. tempTip.show('导入文本不能为空')
  132. }
  133. let _this = this
  134. let data = {rows:this.rows,pasteDataText:this.pasteDataText,hiddenTag: this.hiddenTag}
  135. tempTip.setDuration(99999)
  136. tempTip.setIndex(1051)
  137. tempTip.waitingTip('正在执行中,请稍后')
  138. axios.post('{{url('apiLocal/order/issue/importPasteData')}}',data).then(function (response) {
  139. tempTip.cancelWaitingTip()
  140. if(response.data.success){
  141. $('#pasteData').modal('hide')
  142. tempTip.setDuration(2000)
  143. tempTip.showSuccess('导入完毕')
  144. }else{
  145. let content = '';
  146. for (const key in response.data.fail_info) {
  147. content+=key+':'+response.data.fail_info[key] + "</br>"
  148. }
  149. _this.popoverContent = content
  150. setTimeout(function () {
  151. $("#popover").removeAttr('hidden').popover('show')
  152. },1);
  153. }
  154. }).catch(function(error){
  155. tempTip.cancelWaitingTip()
  156. tempTip.setDuration(2000)
  157. tempTip.show('导入失败'+error)
  158. })
  159. },
  160. forbidTab(e){
  161. e.preventDefault();
  162. },
  163. replaceSpacing(){
  164. this.pasteDataText += "\t";
  165. },
  166. }
  167. });
  168. </script>
  169. @endsection