CouponController.php 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Models\Coupon;
  4. use DB;
  5. use Illuminate\Http\Request;
  6. use Log;
  7. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  8. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  9. use Redirect;
  10. use Response;
  11. use Session;
  12. /**
  13. * 优惠券控制器
  14. *
  15. * Class CouponController
  16. *
  17. * @package App\Http\Controllers
  18. */
  19. class CouponController extends Controller
  20. {
  21. // 优惠券列表
  22. public function couponList(Request $request)
  23. {
  24. $view['couponList'] = Coupon::query()->orderBy('status', 'asc')->orderBy('id', 'desc')->paginate(10);
  25. return Response::view('coupon.couponList', $view);
  26. }
  27. // 添加商品
  28. public function addCoupon(Request $request)
  29. {
  30. if ($request->isMethod('POST')) {
  31. $this->validate($request, [
  32. 'name' => 'required',
  33. 'type' => 'required|integer|between:1,3',
  34. 'usage' => 'required|integer|between:1,2',
  35. 'num' => 'required|integer|min:1',
  36. 'amount' => 'required_unless:type,2|numeric|min:0.01|nullable',
  37. 'discount' => 'required_if:type,2|numeric|between:1,9.9|nullable',
  38. 'available_start' => 'required|date|before_or_equal:available_end',
  39. 'available_end' => 'required|date|after_or_equal:available_start',
  40. ], [
  41. 'name.required' => '请填入卡券名称',
  42. 'type.required' => '请选择卡券类型',
  43. 'type.integer' => '卡券类型不合法,请重选',
  44. 'type.between' => '卡券类型不合法,请重选',
  45. 'usage.required' => '请选择卡券用途',
  46. 'usage.integer' => '卡券用途不合法,请重选',
  47. 'usage.between' => '卡券用途不合法,请重选',
  48. 'num.required' => '请填写卡券数量',
  49. 'num.integer' => '卡券数量不合法',
  50. 'num.min' => '卡券数量不合法,最小1',
  51. 'amount.required_unless' => '请填入卡券面值',
  52. 'amount.numeric' => '卡券金额不合法',
  53. 'amount.min' => '卡券金额不合法,最小0.01',
  54. 'discount.required_if' => '请填入卡券折扣',
  55. 'discount.numeric' => '卡券折扣不合法',
  56. 'discount.between' => '卡券折扣不合法,有效范围:1 ~ 9.9',
  57. 'available_start.required' => '请填入有效期',
  58. 'available_start.date' => '有效期不合法',
  59. 'available_start.before_or_equal' => '有效期不合法',
  60. 'available_end.required' => '请填入有效期',
  61. 'available_end.date' => '有效期不合法',
  62. 'available_end.after_or_equal' => '有效期不合法'
  63. ]);
  64. // 商品LOGO
  65. $logo = '';
  66. if ($request->hasFile('logo')) {
  67. $file = $request->file('logo');
  68. $fileType = $file->getClientOriginalExtension();
  69. // 验证文件合法性
  70. if (!in_array($fileType, ['jpg', 'png', 'jpeg', 'bmp'])) {
  71. return Redirect::back()->withInput()->withErrors('LOGO不合法');
  72. }
  73. $logoName = date('YmdHis') . mt_rand(1000, 2000) . '.' . $fileType;
  74. $move = $file->move(base_path() . '/public/upload/image/', $logoName);
  75. $logo = $move ? '/upload/image/' . $logoName : '';
  76. }
  77. DB::beginTransaction();
  78. try {
  79. for ($i = 0; $i < $request->num; $i++) {
  80. $obj = new Coupon();
  81. $obj->name = $request->name;
  82. $obj->sn = strtoupper(makeRandStr(7));
  83. $obj->logo = $logo;
  84. $obj->type = $request->type;
  85. $obj->usage = $request->usage;
  86. $obj->amount = empty($request->amount) ? 0 : $request->amount;
  87. $obj->discount = empty($request->discount) ? 0 : $request->discount;
  88. $obj->available_start = strtotime(date('Y-m-d 00:00:00', strtotime($request->available_start)));
  89. $obj->available_end = strtotime(date('Y-m-d 23:59:59', strtotime($request->available_end)));
  90. $obj->status = 0;
  91. $obj->save();
  92. }
  93. DB::commit();
  94. return Redirect::back()->with('successMsg', '生成成功');
  95. } catch (\Exception $e) {
  96. DB::rollBack();
  97. Log::error('生成优惠券失败:' . $e->getMessage());
  98. return Redirect::back()->withInput()->withErrors('生成失败:' . $e->getMessage());
  99. }
  100. } else {
  101. return Response::view('coupon.addCoupon');
  102. }
  103. }
  104. // 删除优惠券
  105. public function delCoupon(Request $request)
  106. {
  107. Coupon::query()->where('id', $request->input('id'))->delete();
  108. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  109. }
  110. // 导出卡券
  111. public function exportCoupon(Request $request)
  112. {
  113. $cashCouponList = Coupon::type(1)->where('status', 0)->get();
  114. $discountCouponList = Coupon::type(2)->where('status', 0)->get();
  115. $chargeCouponList = Coupon::type(3)->where('status', 0)->get();
  116. $filename = '卡券' . date('Ymd') . '.xlsx';
  117. $spreadsheet = new Spreadsheet();
  118. $spreadsheet->getProperties()->setCreator('SSRPanel')->setLastModifiedBy('SSRPanel')->setTitle('邀请码')->setSubject('邀请码')->setDescription('')->setKeywords('')->setCategory('');
  119. // 抵用券
  120. $spreadsheet->setActiveSheetIndex(0);
  121. $sheet = $spreadsheet->getActiveSheet();
  122. $sheet->setTitle('抵用券');
  123. $sheet->fromArray(['名称', '类型', '有效期', '券码', '面额(元)'], null);
  124. foreach ($cashCouponList as $k => $vo) {
  125. $usage = '仅限一次性使用';
  126. $dateRange = date('Y-m-d', $vo->available_start) . ' ~ ' . date('Y-m-d', $vo->available_end);
  127. $sheet->fromArray([$vo->name, $usage, $dateRange, $vo->sn, $vo->amount], null, 'A' . ($k + 2));
  128. }
  129. // 折扣券
  130. $spreadsheet->createSheet(1);
  131. $spreadsheet->setActiveSheetIndex(1);
  132. $sheet = $spreadsheet->getActiveSheet();
  133. $sheet->setTitle('折扣券');
  134. $sheet->fromArray(['名称', '类型', '有效期', '券码', '折扣(折)'], null);
  135. foreach ($discountCouponList as $k => $vo) {
  136. $usage = $vo->usage == 1 ? '仅限一次性使用' : '可重复使用';
  137. $dateRange = date('Y-m-d', $vo->available_start) . ' ~ ' . date('Y-m-d', $vo->available_end);
  138. $sheet->fromArray([$vo->name, $usage, $dateRange, $vo->sn, $vo->discount], null, 'A' . ($k + 2));
  139. }
  140. // 充值券
  141. $spreadsheet->createSheet(2);
  142. $spreadsheet->setActiveSheetIndex(2);
  143. $sheet = $spreadsheet->getActiveSheet();
  144. $sheet->setTitle('充值券');
  145. $sheet->fromArray(['名称', '类型', '有效期', '券码', '面额(元)'], null);
  146. foreach ($chargeCouponList as $k => $vo) {
  147. $usage = '仅限一次性使用';
  148. $dateRange = date('Y-m-d', $vo->available_start) . ' ~ ' . date('Y-m-d', $vo->available_end);
  149. $sheet->fromArray([$vo->name, $usage, $dateRange, $vo->sn, $vo->amount], null, 'A' . ($k + 2));
  150. }
  151. // 指针切换回第一个sheet
  152. $spreadsheet->setActiveSheetIndex(0);
  153. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // 输出07Excel文件
  154. //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
  155. header('Content-Disposition: attachment;filename="' . $filename . '"');
  156. header('Cache-Control: max-age=0');
  157. $writer = new Xlsx($spreadsheet);
  158. $writer->save('php://output');
  159. }
  160. }