page.blade.php 4.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. @extends('layouts.base')
  2. @section('title','EXCEL 批量充值')
  3. @section('content')
  4. <div class="panel panel-info">
  5. <div class="panel-heading">
  6. <span>当前位置:</span>
  7. <a href="#">
  8. <span>批量充值</span>
  9. </a>
  10. </div>
  11. </div>
  12. <div class="alert alert-info alert-important">
  13. <span>功能介绍:</span>
  14. <span style="padding-left: 60px;">1. 使用excel快速导入进行会员充值(积分、余额), 文件格式<b style="color:red;">[xls]</b></span>
  15. <span style="padding-left: 60px;">2. 一次导入的数据不要太多,大量数据请分批导入,建议在服务器负载低的时候进行</span>
  16. <br>
  17. <span>使用方法:</span>
  18. <span style="padding-left: 60px;">1. 下载Excel模板文件并录入信息</span>
  19. <span style="padding-left: 60px;">2. 选择充值类型</span>
  20. <span style="padding-left: 60px;">3.选择第一列值的类型 </span>
  21. <span style="padding-left: 60px;">4. 上传Excel导入</span>
  22. <br>
  23. <span>格式要求: Excel第一列可以为会员ID或者手机号(根据选择的上传第一列值得类型决定),第二列必须为充值数量</span>
  24. </div>
  25. <form id="importform" class="form-horizontal form" action="{{yzWebUrl('excelRecharge.confirm.index')}}" method="post" enctype="multipart/form-data">
  26. <div class='form-group'>
  27. <div class="form-group">
  28. <label class="col-sm-2 control-label must">充值类型</label>
  29. <div class="col-sm-5 goodsname" style="padding-right:0;">
  30. <select class="form-control batch_type" name="batch_type">
  31. <option value="balance">充值余额</option>
  32. <option value="point">充值积分</option>
  33. @if($loveOpen)
  34. <option value="love">充值{{ $loveName }}</option>
  35. @endif
  36. </select>
  37. </div>
  38. <div class="col-sm-1 love_type" style="padding-right:0;display:none;width: 75px">
  39. <select class="form-control" name="love_type">
  40. <option value="usable">可用</option>
  41. <option value="froze">冻结</option>
  42. </select>
  43. </div>
  44. </div>
  45. <div class='form-group'>
  46. <div class="form-group">
  47. <label class="col-sm-2 control-label must">上传第一列的值</label>
  48. <div class="col-sm-5 goodsname" style="padding-right:0;">
  49. <select class="form-control batch_type" name="genre">
  50. <option value="1">会员ID</option>
  51. <option value="2">手机号</option>
  52. </select>
  53. </div>
  54. </div>
  55. <div class="form-group">
  56. <label class="col-sm-2 control-label must">EXCEL文件</label>
  57. <div class="col-sm-5 goodsname" style="padding-right:0;">
  58. <input type="file" name="batch_recharge" class="form-control"/>
  59. </div>
  60. </div>
  61. </div>
  62. <div class='form-group'>
  63. <div class="col-sm-12">
  64. <div class="modal-footer">
  65. <button type="submit" class="btn btn-primary" name="cancelsend" value="yes">确认导入</button>
  66. <a class="btn btn-primary" href="{{yzWebUrl('excelRecharge.records.index')}}" style="margin-right: 10px;">
  67. <i class="fa fa-pencil"></i>
  68. <span>充值记录</span>
  69. </a>
  70. <a class="btn btn-primary" href="{{yzWebUrl('excelRecharge.example.index')}}&id=1" style="margin-right: 10px;">
  71. <i class="fa fa-download"></i>
  72. <span>下载Excel模板文件(会员ID)</span>
  73. </a>
  74. <a class="btn btn-primary" href="{{yzWebUrl('excelRecharge.example.index')}}&id=2" style="margin-right: 10px;">
  75. <i class="fa fa-download"></i>
  76. <span>下载Excel模板文件(手机号)</span>
  77. </a>
  78. </div>
  79. </div>
  80. </div>
  81. </div>
  82. </form>
  83. <script language="javascript">
  84. $('.batch_type').change(function () {
  85. var type = $(this).children('option:selected').val();
  86. if (type == 'love') {
  87. $('.love_type').show();
  88. } else {
  89. $('.love_type').hide();
  90. }
  91. });
  92. </script>
  93. @endsection('content')