monthlyBillReport.blade.php 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. @extends('layouts.app')
  2. @section('title')采购管理-财务-月账单报表@endsection
  3. @section('content')
  4. @component('procurement.finance.menu')@endcomponent
  5. <div class="container-fluid" id="list">
  6. <div id="form_div" class="mt-1"></div>
  7. <div class="row mt-2">
  8. <span class="dropdown ml-3">
  9. <button class="btn btn-outline-dark btn-sm form-control-sm dropdown-toggle tooltipTarget"
  10. data-toggle="dropdown" title="导出所有页将会以搜索条件得到的筛选结果,将其全部记录(每一页)导出">
  11. 导出Excel
  12. </button>
  13. <div class="dropdown-menu">
  14. <a class="dropdown-item" @click="procurementTotalBillExport(false)" href="javascript:">导出勾选内容</a>
  15. <a class="dropdown-item" @click="procurementTotalBillExport(true)" href="javascript:">导出所有页</a>
  16. </div>
  17. </span>
  18. </div>
  19. <table class="table table-sm table-striped table-bordered table-hover text-nowrap card-body mt-2" id="table">
  20. <tr v-for="(procurementTotalBill,i) in procurementTotalBills">
  21. <td>
  22. <input class="checkItem" type="checkbox" :value="procurementTotalBill.id">
  23. </td>
  24. <td >@{{ procurementTotalBill.id }}</td>
  25. <td class="text-muted">@{{ procurementTotalBill.counting_month }}</td>
  26. <td class="text-muted">@{{ procurementTotalBill.created_at.substr(0,10) }}</td>
  27. <td class="text-muted">@{{ procurementTotalBill.supplier_name }}</td>
  28. <td>@{{ procurementTotalBill.total_payable }}</td>
  29. <td><span>@{{ procurement_total_bill_status[procurementTotalBill.status] }}</span></td>
  30. </tr>
  31. </table>
  32. <div class="text-info h5 btn btn">{{$procurementTotalBills->count()}}/@{{ sum }}</div>
  33. <div>{{$procurementTotalBills->appends($paginateParams)->links()}}</div>
  34. </div>
  35. @endsection
  36. @section('lastScript')
  37. <script type="text/javascript" src="{{mix('js/queryForm/export.js')}}"></script>
  38. <script type="text/javascript" src="{{mix('js/queryForm/queryForm.js')}}"></script>
  39. <script type="text/javascript" src="{{mix('js/queryForm/header.js')}}"></script>{{--新版--}}
  40. <script>
  41. let vue = new Vue({
  42. el: '#list',
  43. data: {
  44. procurementTotalBills: [
  45. @foreach($procurementTotalBills as $procurementTotalBill)
  46. {
  47. id:'{{$procurementTotalBill->id ?? ''}}',counting_month:'{{$procurementTotalBill->counting_month ?? ''}}',
  48. created_at:'{{$procurementTotalBill->created_at ?? ''}}',status:'{{$procurementTotalBill->status ?? ''}}',total_payable:'{{$procurementTotalBill->total_payable ?? ''}}',
  49. @if($procurementTotalBill->supplier)
  50. supplier_id:'{{$procurementTotalBill->supplier->id ?? ''}}',supplier_name:'{{$procurementTotalBill->supplier->name ?? ''}}',@endif
  51. },
  52. @endforeach
  53. ],
  54. suppliers:[
  55. @foreach($suppliers as $supplier)
  56. {name:'{{$supplier->id}}',value:'{{$supplier->name}}'},
  57. @endforeach
  58. ],
  59. sum:{!! $procurementTotalBills->total() !!},
  60. procurement_total_bill_status:{!! json_encode(\App\ProcurementTotalBill::status,JSON_UNESCAPED_UNICODE) !!},
  61. },
  62. mounted: function () {
  63. $(".tooltipTarget").tooltip({'trigger': 'hover'});
  64. $('#list').removeClass('d-none');
  65. let data = [
  66. [
  67. {name:'counting_month',type:'dateMonth',tip:'选择账单日期',placeholder: '----年--月'},
  68. {
  69. name: 'supplier_id', type: 'select_multiple_select', tip: ['输入关键词快速定位下拉列表,回车确定', '选择要显示的供应商'],
  70. placeholder: ['供应商', '定位或多选供应商'], data: this.suppliers
  71. },
  72. ],
  73. ];
  74. this.form = new query({
  75. el: "#form_div",
  76. condition: data,
  77. });
  78. this.form.init();
  79. let column = [
  80. {name: 'id', value: '对账编号', neglect: true,class: 'text-center'},
  81. {name: 'counting_month', value: '账单日期',class: 'text-center'},
  82. {name: 'created_at', value: '提交日期',class: 'text-center'},
  83. {name: 'supplier', value: '供应商',class: 'text-center'},
  84. {name: 'total_payable', value: '总金额',class: 'text-center'},
  85. {name: 'status', value: '状态',class: 'text-center'},
  86. ];
  87. new Header({
  88. el: "table",
  89. column: column,
  90. data: this.procurementTotalBills,
  91. fixedTop: ($('#form_div').height()) + 2,
  92. }).init();
  93. },
  94. methods: {
  95. procurementTotalBillExport(selectAll){
  96. let url = '{{url('procurement/finance/procurementTotalBillExport')}}';
  97. let token='{{ csrf_token() }}';
  98. excelExport(selectAll,checkData,url,this.sum,token);
  99. },
  100. }
  101. });
  102. </script>
  103. @endsection