neiyou_user_web/app/Http/Controllers/Admin/CouponController.php

<?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
 */
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::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());
        }
    }
}