CouponController.php 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Admin\CouponRequest;
  5. use App\Models\Coupon;
  6. use Exception;
  7. use Illuminate\Http\JsonResponse;
  8. use Illuminate\Http\Request;
  9. use Log;
  10. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  11. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  12. use Redirect;
  13. use Response;
  14. use Str;
  15. /**
  16. * 优惠券控制器
  17. *
  18. * Class CouponController
  19. *
  20. * @package App\Http\Controllers\Controller
  21. */
  22. class CouponController extends Controller
  23. {
  24. // 优惠券列表
  25. public function index(Request $request)
  26. {
  27. $sn = $request->input('sn');
  28. $type = $request->input('type');
  29. $status = $request->input('status');
  30. $query = Coupon::query();
  31. if (isset($sn)) {
  32. $query->where('sn', 'like', '%'.$sn.'%');
  33. }
  34. if (isset($type)) {
  35. $query->whereType($type);
  36. }
  37. if (isset($status)) {
  38. $query->whereStatus($status);
  39. }
  40. $view['couponList'] = $query->latest()->paginate(15)->appends($request->except('page'));
  41. return view('admin.coupon.index', $view);
  42. }
  43. // 添加优惠券页面
  44. public function create()
  45. {
  46. return view('admin.coupon.create');
  47. }
  48. // 添加优惠券
  49. public function store(CouponRequest $request)
  50. {
  51. // 优惠卷LOGO
  52. $logo = null;
  53. if ($request->hasFile('logo')) {
  54. $logo = 'upload/'.$request->file('logo')->store('images');
  55. if (!$logo) {
  56. return Redirect::back()->withInput()->withErrors('LOGO不合法');
  57. }
  58. }
  59. try {
  60. $num = (int) $request->input('num');
  61. for ($i = 0; $i < $num; $i++) {
  62. $obj = new Coupon();
  63. $obj->name = $request->input('name');
  64. $obj->logo = $logo;
  65. $obj->sn = $num === 1 && $request->input('sn') ? $request->input('sn') : Str::random(8);
  66. $obj->type = $request->input('type');
  67. $obj->usable_times = $request->input('usable_times');
  68. $obj->value = $request->input('value');
  69. $obj->rule = $request->input('rule');
  70. $obj->start_time = strtotime($request->input('start_time'));
  71. $obj->end_time = strtotime($request->input('end_time'));
  72. $obj->status = 0;
  73. $obj->save();
  74. }
  75. return Redirect::to(route('admin.coupon.index'))->with('successMsg', '生成成功');
  76. } catch (Exception $e) {
  77. Log::error('生成优惠券失败:'.$e->getMessage());
  78. return Redirect::back()->withInput()->withInput()->withErrors('生成优惠券失败:'.$e->getMessage());
  79. }
  80. }
  81. // 删除优惠券
  82. public function destroy($id): JsonResponse
  83. {
  84. try {
  85. if (Coupon::find($id)->delete()) {
  86. return Response::json(['status' => 'success', 'message' => '删除成功']);
  87. }
  88. } catch (Exception $e) {
  89. Log::error('删除优惠券失败:'.$e->getMessage());
  90. return Response::json(['status' => 'success', 'message' => '删除优惠券失败:'.$e->getMessage()]);
  91. }
  92. return Response::json(['status' => 'fail', 'message' => '删除失败']);
  93. }
  94. // 导出卡券
  95. public function exportCoupon(): void
  96. {
  97. $voucherList = Coupon::type(1)->whereStatus(0)->get();
  98. $discountCouponList = Coupon::type(2)->whereStatus(0)->get();
  99. $refillList = Coupon::type(3)->whereStatus(0)->get();
  100. try {
  101. $filename = '卡券'.date('Ymd').'.xlsx';
  102. $spreadsheet = new Spreadsheet();
  103. $spreadsheet->getProperties()
  104. ->setCreator('ProxyPanel')
  105. ->setLastModifiedBy('ProxyPanel')
  106. ->setTitle('邀请码')
  107. ->setSubject('邀请码');
  108. // 抵用券
  109. $spreadsheet->setActiveSheetIndex(0);
  110. $sheet = $spreadsheet->getActiveSheet();
  111. $sheet->setTitle('抵用券');
  112. $sheet->fromArray(['名称', '使用次数', '有效期', '券码', '金额(元)', '使用限制(元)'], null);
  113. foreach ($voucherList as $k => $vo) {
  114. $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
  115. $sheet->fromArray([$vo->name, $vo->usable_times ?? '无限制', $dateRange, $vo->sn, $vo->value, $vo->rule], null,
  116. 'A'.($k + 2));
  117. }
  118. // 折扣券
  119. $spreadsheet->createSheet(1);
  120. $spreadsheet->setActiveSheetIndex(1);
  121. $sheet = $spreadsheet->getActiveSheet();
  122. $sheet->setTitle('折扣券');
  123. $sheet->fromArray(['名称', '使用次数', '有效期', '券码', '折扣(折)', '使用限制(元)'], null);
  124. foreach ($discountCouponList as $k => $vo) {
  125. $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
  126. $sheet->fromArray([$vo->name, $vo->usable_times ?? '无限制', $dateRange, $vo->sn, $vo->value, $vo->rule], null,
  127. 'A'.($k + 2));
  128. }
  129. // 充值券
  130. $spreadsheet->createSheet(2);
  131. $spreadsheet->setActiveSheetIndex(2);
  132. $sheet = $spreadsheet->getActiveSheet();
  133. $sheet->setTitle('充值券');
  134. $sheet->fromArray(['名称', '有效期', '券码', '金额(元)'], null);
  135. foreach ($refillList as $k => $vo) {
  136. $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
  137. $sheet->fromArray([$vo->name, $dateRange, $vo->sn, $vo->value], null, 'A'.($k + 2));
  138. }
  139. // 指针切换回第一个sheet
  140. $spreadsheet->setActiveSheetIndex(0);
  141. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // 输出07Excel文件
  142. //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
  143. header('Content-Disposition: attachment;filename="'.$filename.'"');
  144. header('Cache-Control: max-age=0');
  145. $writer = new Xlsx($spreadsheet);
  146. $writer->save('php://output');
  147. } catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
  148. Log::error('导出优惠券时报错:'.$e->getMessage());
  149. }
  150. }
  151. }