procurementBill.blade.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  1. @extends('layouts.app')
  2. @section('title')采购管理-财务-采购账单@endsection
  3. @section('content')
  4. <div class="container-fluid" id="list">
  5. <div id="form_div" class="mt-1"></div>
  6. <div class="row mt-2">
  7. <span class="dropdown ml-3">
  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="procurementBillExport(false)" href="javascript:">导出勾选内容</a>
  14. <a class="dropdown-item" @click="procurementBillExport(true)" href="javascript:">导出所有页</a>
  15. </div>
  16. </span>
  17. </div>
  18. <table class="table table-sm table-striped table-bordered table-hover text-nowrap card-body mt-2 td-min-width-80" id="table">
  19. <tr v-for="(procurement,i) in procurements">
  20. <td>
  21. <input class="checkItem" type="checkbox" :value="procurement.id">
  22. </td>
  23. <td class="">@{{ procurement.code }}</td>
  24. <td class="">@{{ procurement.created_at }}</td>
  25. <td class=""><span v-if="procurement.supplier_id">@{{ procurement.deadline }}</span></td>
  26. <td class=""><span v-if="procurement.signed_at">@{{ procurement.signed_at }}</span></td>
  27. <td ><span v-if="procurement.owner_material.owner">@{{ procurement.owner_material.owner.name }}</span></td>
  28. {{-- <td ><span v-if="procurement.owner_material.owner">@{{ procurement.owner_material.owner.customer?procurement.owner_material.owner.customer.company_name:'' }}</span></td>--}}
  29. <td ><span v-if="procurement.supplier">@{{ procurement.supplier.name }}</span></td>
  30. <td class="tooltipTarget" style="max-width: 200px;overflow:hidden" v-if="procurement.owner_material"><span>@{{ procurement.owner_material.material_code }}</span></td>
  31. <td class="text-muted" v-if="procurement.owner_material.material"><span>@{{ procurement.owner_material.material.name }}</span></td>
  32. <td class="text-muted" v-if="procurement.owner_material"><span>@{{ procurement.owner_material.size }}</span></td>
  33. <td class="text-muted" style="max-width: 200px;overflow:hidden" v-if="procurement.owner_material"><span>@{{ procurement.owner_material.special }}</span></td>
  34. <td class="text-muted" v-if="procurement.owner_material"><span>@{{ procurement.owner_material.specification }}</span></td>
  35. <td class="text-muted" style="max-width: 200px;overflow:hidden"><span>@{{ procurement.remark }}</span></td>
  36. <td><span>@{{ procurement.quantity }}</span></td>{{--采购数量--}}
  37. <td><span>@{{ procurement.amount }}</span></td> {{--销售数量--}}
  38. <td><span v-if="procurement.receive_amount">@{{ procurement.receive_amount }}</span></td>
  39. <td><span>@{{ procurement.cost_price }}</span></td> {{--采购单价--}}
  40. <td><span>@{{ procurement.unit_price }}</span></td> {{--销售单价--}}
  41. <td><span>@{{ (procurement.amount*procurement.cost_price).toFixed(2) }}</span></td> {{--应收--}}
  42. <td><span>@{{ (procurement.quantity*procurement.unit_price).toFixed(2) }}</span></td> {{--应付--}}
  43. <td><span>@{{ procurement_status[procurement.status] }}</span></td>
  44. <td>
  45. <span v-if="procurement.status<9">
  46. <span class="btn btn-sm btn-outline-danger">锁定</span>
  47. <span class="btn btn-sm btn-outline-success" @click="changeCostPrice(procurement.id,procurement.cost_price)">修改采购单价</span>
  48. </span>
  49. </td>
  50. </tr>
  51. </table>
  52. @can('采购管理-财务-采购账单')
  53. @include('procurement.finance._changeCostPrice')
  54. @endcan
  55. <div class="text-info h5 btn btn">{{$procurements->count()}}/@{{ sum }}</div>
  56. <div>{{$procurements->appends($paginateParams)->links()}}</div>
  57. </div>
  58. @endsection
  59. @section('lastScript')
  60. <script type="text/javascript" src="{{mix('js/queryForm/export.js')}}"></script>
  61. <script type="text/javascript" src="{{mix('js/queryForm/queryForm.js')}}"></script>
  62. <script type="text/javascript" src="{{mix('js/queryForm/header.js')}}"></script>{{--新版2--}}
  63. <script>
  64. let vue = new Vue({
  65. el: '#list',
  66. data: {
  67. procurements: {!! $procurements->toJson() !!}['data'],
  68. owners:[
  69. @foreach($owners as $owner)
  70. {name:'{{$owner->id}}',value:'{{$owner->name}}'},
  71. @endforeach
  72. ],
  73. materials: [
  74. @foreach($materials as $material)
  75. {name:'{{$material->id}}',value:'{{$material->name}}'},
  76. @endforeach
  77. ],
  78. suppliers:[
  79. @foreach($suppliers as $supplier)
  80. {name:'{{$supplier->id}}',value:'{{$supplier->name}}'},
  81. @endforeach
  82. ],
  83. sum:{!! $procurements->total() !!},
  84. procurement_status:{!! json_encode(\App\Procurement::status,JSON_UNESCAPED_UNICODE) !!},
  85. procurement_id:'',cost_price:'',
  86. },
  87. mounted: function () {
  88. $(".tooltipTarget").tooltip({'trigger': 'hover'});
  89. $('#list').removeClass('d-none');
  90. let data = [
  91. [
  92. {name: 'created_at_start', type: 'dateTime', tip: '选择显示指定日期的起始时间'},
  93. {name: 'created_at_end', type: 'dateTime', tip: '选择显示指定日期的结束时间'},
  94. {name:'code',type:'input',tip:'可支持多采购编号,模糊搜索可在两侧增加百分号(%)进行',placeholder: '采购编号'},
  95. {
  96. name: 'owner_id', type: 'select_multiple_select', tip: ['输入关键词快速定位下拉列表,回车确定', '选择要显示的项目'],
  97. placeholder: ['项目', '定位或多选项目'], data: this.owners
  98. },
  99. {
  100. name: 'material_id', type: 'select_multiple_select', tip: ['输入关键词快速定位下拉列表,回车确定', '选择要显示的耗材'],
  101. placeholder: ['耗材', '定位或多选耗材'], data: this.materials
  102. },
  103. {
  104. name: 'supplier_id', type: 'select_multiple_select', tip: ['输入关键词快速定位下拉列表,回车确定', '选择要显示的供应商'],
  105. placeholder: ['供应商', '定位或多选供应商'], data: this.suppliers
  106. },
  107. // {name: 'company_name', type: 'input', tip: '采购公司:可在两侧增加百分号(%)进行模糊搜索', placeholder: '采购公司'},
  108. ],
  109. ];
  110. this.form = new query({
  111. el: "#form_div",
  112. condition: data,
  113. });
  114. this.form.init();
  115. let column = [
  116. {name: 'code', value: '采购编号', neglect: true,class: 'text-center'},
  117. {name: 'code', value: '采购日期', neglect: true,class: 'text-center'},
  118. {name: 'code', value: '接单日期', neglect: true,class: 'text-center'},
  119. {name: 'code', value: '签收日期', neglect: true,class: 'text-center'},
  120. {name: 'owner_id', value: '项目名称',class: 'text-center'},
  121. // {name: 'company_name', value: '采购公司',class: 'text-center'},
  122. {name: 'supplier_name', value: '供应商',class: 'text-center'},
  123. {name: 'material_code', value: '耗材编号',class: 'text-center'},
  124. {name: 'material_name', value: '耗材',class: 'text-center'},
  125. {name: 'size', value: '尺寸大小',class: 'text-center'},
  126. {name: 'special', value: '特殊要求',class: 'text-center'},
  127. {name: 'specification', value: '材质规格',class: 'text-center'},
  128. {name: '备注', value: '备注',class: 'text-center'},
  129. {name: 'quantity', value: '采购数量', neglect: true,class: 'text-center'},
  130. {name: '销售数量', value: '销售数量', neglect: true,class: 'text-center'},
  131. {name: 'deliver_amount', value: '收货数量', neglect: true,class: 'text-center'},
  132. {name: '采购单价', value: '采购单价(元)', neglect: true,class: 'text-center'},
  133. {name: 'unit_price', value: '销售单价(元)', neglect: true,class: 'text-center'},
  134. {name: '应付金额', value: '应付金额(元)', neglect: true,class: 'text-center'},
  135. {name: '应收金额', value: '应收金额(元)', neglect: true,class: 'text-center'},
  136. {name: '状态', value: '状态', neglect: true,class: 'text-center'},
  137. {name: '操作', value: '操作', neglect: true,class: 'text-center'},
  138. ];
  139. new Header({
  140. el: "table",
  141. name: "procurementBill",
  142. column: column,
  143. data: this.procurements,
  144. fixedTop: ($('#form_div').height()) + 2,
  145. }).init();
  146. },
  147. methods: {
  148. changeCostPrice(id,cost_price){
  149. this.procurement_id=id;
  150. this.cost_price=cost_price;
  151. $("#change-costPrice").modal('show');
  152. },
  153. costPrice(){
  154. let _this=this;
  155. let url='{{url('procurement/finance/costPrice')}}';
  156. let param={id:_this.procurement_id,cost_price:_this.cost_price};
  157. window.axios.post(url,param).then(function (res) {
  158. if (res.data.success){
  159. _this.procurements.forEach(function (procurement) {
  160. if (procurement.id===res.data.data.id){
  161. procurement.cost_price=res.data.data.cost_price;
  162. $("#change-costPrice").modal('hide');
  163. }
  164. })
  165. }else {
  166. tempTip.setDuration(3000);
  167. tempTip.show(res.data.message);
  168. }
  169. }).catch(function (err) {
  170. window.tempTip.setDuration(3000);
  171. window.tempTip.show("网络错误:" + err);
  172. })
  173. },
  174. procurementBillExport(selectAll){
  175. let url = '{{url('procurement/finance/procurementBillExport')}}';
  176. let token='{{ csrf_token() }}';
  177. excelExport(selectAll,checkData,url,this.sum,token);
  178. },
  179. }
  180. });
  181. </script>
  182. @endsection