123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176 |
- <?php
- namespace App\Http\Controllers\Admin;
- use App\Http\Controllers\Controller;
- use App\Http\Requests\Admin\CouponRequest;
- use App\Models\Coupon;
- use Exception;
- use Illuminate\Http\JsonResponse;
- use Illuminate\Http\Request;
- use Log;
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- use Redirect;
- use Response;
- use Str;
- /**
- * 优惠券控制器
- *
- * Class CouponController
- *
- * @package App\Http\Controllers\Controller
- */
- class CouponController extends Controller
- {
- // 优惠券列表
- public function index(Request $request)
- {
- $sn = $request->input('sn');
- $type = $request->input('type');
- $status = $request->input('status');
- $query = Coupon::query();
- if (isset($sn)) {
- $query->where('sn', 'like', '%'.$sn.'%');
- }
- if (isset($type)) {
- $query->whereType($type);
- }
- if (isset($status)) {
- $query->whereStatus($status);
- }
- $view['couponList'] = $query->latest()->paginate(15)->appends($request->except('page'));
- return view('admin.coupon.index', $view);
- }
- // 添加优惠券页面
- public function create()
- {
- return view('admin.coupon.create');
- }
- // 添加优惠券
- public function store(CouponRequest $request)
- {
- // 优惠卷LOGO
- $logo = null;
- if ($request->hasFile('logo')) {
- $logo = 'upload/'.$request->file('logo')->store('images');
- if (!$logo) {
- return Redirect::back()->withInput()->withErrors('LOGO不合法');
- }
- }
- try {
- $num = (int) $request->input('num');
- for ($i = 0; $i < $num; $i++) {
- $obj = new Coupon();
- $obj->name = $request->input('name');
- $obj->logo = $logo;
- $obj->sn = $num === 1 && $request->input('sn') ? $request->input('sn') : Str::random(8);
- $obj->type = $request->input('type');
- $obj->usable_times = $request->input('usable_times');
- $obj->value = $request->input('value');
- $obj->rule = $request->input('rule');
- $obj->start_time = strtotime($request->input('start_time'));
- $obj->end_time = strtotime($request->input('end_time'));
- $obj->status = 0;
- $obj->save();
- }
- return Redirect::to(route('admin.coupon.index'))->with('successMsg', '生成成功');
- } catch (Exception $e) {
- Log::error('生成优惠券失败:'.$e->getMessage());
- return Redirect::back()->withInput()->withInput()->withErrors('生成优惠券失败:'.$e->getMessage());
- }
- }
- // 删除优惠券
- public function destroy($id): JsonResponse
- {
- try {
- if (Coupon::find($id)->delete()) {
- return Response::json(['status' => 'success', 'message' => '删除成功']);
- }
- } catch (Exception $e) {
- Log::error('删除优惠券失败:'.$e->getMessage());
- return Response::json(['status' => 'success', 'message' => '删除优惠券失败:'.$e->getMessage()]);
- }
- return Response::json(['status' => 'fail', 'message' => '删除失败']);
- }
- // 导出卡券
- public function exportCoupon(): void
- {
- $voucherList = Coupon::type(1)->whereStatus(0)->get();
- $discountCouponList = Coupon::type(2)->whereStatus(0)->get();
- $refillList = Coupon::type(3)->whereStatus(0)->get();
- try {
- $filename = '卡券'.date('Ymd').'.xlsx';
- $spreadsheet = new Spreadsheet();
- $spreadsheet->getProperties()
- ->setCreator('ProxyPanel')
- ->setLastModifiedBy('ProxyPanel')
- ->setTitle('邀请码')
- ->setSubject('邀请码');
- // 抵用券
- $spreadsheet->setActiveSheetIndex(0);
- $sheet = $spreadsheet->getActiveSheet();
- $sheet->setTitle('抵用券');
- $sheet->fromArray(['名称', '使用次数', '有效期', '券码', '金额(元)', '使用限制(元)'], null);
- foreach ($voucherList as $k => $vo) {
- $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
- $sheet->fromArray([$vo->name, $vo->usable_times ?? '无限制', $dateRange, $vo->sn, $vo->value, $vo->rule], null,
- 'A'.($k + 2));
- }
- // 折扣券
- $spreadsheet->createSheet(1);
- $spreadsheet->setActiveSheetIndex(1);
- $sheet = $spreadsheet->getActiveSheet();
- $sheet->setTitle('折扣券');
- $sheet->fromArray(['名称', '使用次数', '有效期', '券码', '折扣(折)', '使用限制(元)'], null);
- foreach ($discountCouponList as $k => $vo) {
- $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
- $sheet->fromArray([$vo->name, $vo->usable_times ?? '无限制', $dateRange, $vo->sn, $vo->value, $vo->rule], null,
- 'A'.($k + 2));
- }
- // 充值券
- $spreadsheet->createSheet(2);
- $spreadsheet->setActiveSheetIndex(2);
- $sheet = $spreadsheet->getActiveSheet();
- $sheet->setTitle('充值券');
- $sheet->fromArray(['名称', '有效期', '券码', '金额(元)'], null);
- foreach ($refillList as $k => $vo) {
- $dateRange = date('Y-m-d', $vo->start_time).' ~ '.date('Y-m-d', $vo->end_time);
- $sheet->fromArray([$vo->name, $dateRange, $vo->sn, $vo->value], null, 'A'.($k + 2));
- }
- // 指针切换回第一个sheet
- $spreadsheet->setActiveSheetIndex(0);
- header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // 输出07Excel文件
- //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
- header('Content-Disposition: attachment;filename="'.$filename.'"');
- header('Cache-Control: max-age=0');
- $writer = new Xlsx($spreadsheet);
- $writer->save('php://output');
- } catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
- Log::error('导出优惠券时报错:'.$e->getMessage());
- }
- }
- }
|