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

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Coupon;
use DB;
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;
use Validator;

/**
 * 优惠券控制器
 *
 * Class CouponController
 *
 * @package App\Http\Controllers\Controller
 */
class CouponController extends Controller
{

    // 优惠券列表
    public function couponList(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.couponList', $view);
    }

    // 添加优惠券
    public function addCoupon(Request $request)
    {
        if ($request->isMethod('POST')) {
            Validator::make(
                $request->all(),
                [
                    'name'         => 'required',
                    'sn'           => 'unique:coupon',
                    'type'         => 'required|integer|between:1,3',
                    'usable_times' => 'integer|nullable',
                    'num'          => 'required|integer|min:1',
                    'value'        => 'required|numeric|min:0',
                    'start_time'   => 'required|date|before_or_equal:end_time',
                    'end_time'     => 'required|date|after_or_equal:start_time',
                ],
                [
                    'name.required'              => '请填入卡券名称',
                    'type.required'              => '请选择卡券类型',
                    'type.integer'               => '卡券类型不合法，请重选',
                    'type.between'               => '卡券类型不合法，请重选',
                    'num.required'               => '请填写卡券数量',
                    'num.integer'                => '卡券数量不合法',
                    'num.min'                    => '卡券数量不合法，最小1',
                    'value.required_unless'      => '请填入优惠值',
                    'value.numeric'              => '优惠值金额不合法',
                    'value.min'                  => '优惠值不合法，最小0',
                    'start_time.required'        => '请填入有效期',
                    'start_time.date'            => '有效期不合法',
                    'start_time.before_or_equal' => '有效期不合法',
                    'end_time.required'          => '请填入有效期',
                    'end_time.date'              => '有效期不合法',
                    'end_time.after_or_equal'    => '有效期不合法',
                ]
            );

            $type = $request->input('type');

            // 优惠卷LOGO
            $logo = '';
            if ($request->hasFile('logo')) {
                $logo = $this->uploadFile($request->file('logo'));

                if ( ! $logo) {
                    return Redirect::back()->withInput()->withErrors('LOGO不合法');
                }
            }

            try {
                DB::beginTransaction();
                $num = $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         = $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();
                }

                DB::commit();

                return Redirect::back()->with('successMsg', '生成成功');
            } catch (Exception $e) {
                DB::rollBack();

                Log::error('生成优惠券失败：' . $e->getMessage());

                return Redirect::back()->withInput()->withErrors(
                    '生成失败：' . $e->getMessage()
                );
            }
        } else {
            return view('admin.coupon.addCoupon');
        }
    }

    // 删除优惠券
    public function delCoupon(Request $request): JsonResponse
    {
        Coupon::find($request->input('id'))->delete();

        return Response::json(['status' => 'success', '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();

        $filename    = '卡券' . date('Ymd') . '.xlsx';
        $spreadsheet = new Spreadsheet();
        $spreadsheet->getProperties()
                    ->setCreator('ProxyPanel')
                    ->setLastModifiedBy('ProxyPanel')
                    ->setTitle('邀请码')
                    ->setSubject('邀请码')
                    ->setDescription('')
                    ->setKeywords('')
                    ->setCategory('');

        // 抵用券
        $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');
    }

}