CouponController.php 6.4 KB

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