mint/api-v13/app/Http/Controllers/NissayaEndingController.php

<?php

namespace App\Http\Controllers;

use App\Http\Resources\NissayaEndingResource;
use App\Models\NissayaEnding;
use App\Models\Relation;
use App\Services\AuthService;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class NissayaEndingController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return Response
     */
    public function index(Request $request)
    {
        //
        $table = NissayaEnding::select([
            'id',
            'ending',
            'lang',
            'relation',
            'case',
            'from',
            'count',
            'editor_id',
            'created_at',
            'updated_at',
        ]);

        if (($request->has('case'))) {
            $table->whereIn('case', explode(',', $request->input('case')));
        }

        if (($request->has('lang'))) {
            $table->whereIn('lang', explode(',', $request->input('lang')));
        }

        if (($request->has('relation'))) {
            $table->where('relation', $request->input('relation'));
        }
        if (($request->has('case'))) {
            $table->where('case', $request->input('case'));
        }

        if (($request->has('search'))) {
            $table->where('ending', 'like', '%'.$request->input('search').'%');
        }

        $count = $table->count();

        $table->orderBy(
            $request->input('order', 'updated_at'),
            $request->input('dir', 'desc')
        );

        $table->skip($request->input('offset', 0))
            ->take($request->input('limit', 1000));
        $result = $table->get();

        return $this->ok(['rows' => NissayaEndingResource::collection($result), 'count' => $count]);
    }

    public function vocabulary(Request $request)
    {
        $result = NissayaEnding::select(['ending'])
            ->where('lang', $request->input('lang'))
            ->groupBy('ending')
            ->get();

        return $this->ok(['rows' => $result, 'count' => count($result)]);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return Response
     */
    public function store(Request $request)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }
        // TODO 判断权限
        $validated = $request->validate([
            'ending' => 'required',
            'lang' => 'required',
        ]);
        $new = new NissayaEnding;
        $new->ending = $validated['ending'];
        $new->strlen = mb_strlen($validated['ending'], 'UTF-8');
        $new->lang = $validated['lang'];
        $new->relation = $request->input('relation');
        $new->case = $request->input('case');
        if ($request->has('from')) {
            $new->from = json_encode($request->input('from'), JSON_UNESCAPED_UNICODE);
        } else {
            $new->from = null;
        }
        $new->editor_id = $user['user_uid'];
        $new->save();

        return $this->ok(new NissayaEndingResource($new));
    }

    /**
     * Display the specified resource.
     *
     * @return Response
     */
    public function show(NissayaEnding $nissayaEnding)
    {
        //
        return $this->ok(new NissayaEndingResource($nissayaEnding));
    }

    /**
     * Update the specified resource in storage.
     *
     * @return Response
     */
    public function update(Request $request, NissayaEnding $nissayaEnding)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }
        // 查询是否重复
        /*
        $table = NissayaEnding::where('ending',$request->input('ending'))
                 ->where('lang',$request->input('lang'))
                 ->where('relation',$request->input('relation'));
        $from = json_encode($request->input('from'),JSON_UNESCAPED_UNICODE);
        if(empty($from)){
            $table = $table->whereNull('from');
        }else{
            $json = $request->input('from');
            $table = $table->whereJsonContains('from',['case'=>$json['case']]);
        }
        if($table->exists()){
            return $this->error(__('validation.exists',['name']));
        }
*/
        $nissayaEnding->ending = $request->input('ending');
        $nissayaEnding->strlen = mb_strlen($request->input('ending'), 'UTF-8');
        $nissayaEnding->lang = $request->input('lang');
        $nissayaEnding->relation = $request->input('relation');
        if ($request->has('from') && ! empty($request->input('from'))) {
            $nissayaEnding->from = json_encode($request->input('from'), JSON_UNESCAPED_UNICODE);
        } else {
            $nissayaEnding->from = null;
        }
        $nissayaEnding->editor_id = $user['user_uid'];
        $nissayaEnding->save();

        return $this->ok(new NissayaEndingResource($nissayaEnding));
    }

    /**
     * Remove the specified resource from storage.
     *
     * @return Response
     */
    public function destroy(Request $request, NissayaEnding $nissayaEnding)
    {
        //
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }
        // TODO 判断当前用户是否有权限
        $delete = 0;
        $delete = $nissayaEnding->delete();

        return $this->ok($delete);
    }

    public function export()
    {
        $spreadsheet = new Spreadsheet;
        $activeWorksheet = $spreadsheet->getActiveSheet();
        $activeWorksheet->setCellValue('A1', 'id');
        $activeWorksheet->setCellValue('B1', 'ending');
        $activeWorksheet->setCellValue('C1', 'lang');
        $activeWorksheet->setCellValue('D1', 'relation');

        $nissaya = NissayaEnding::cursor();
        $currLine = 2;
        foreach ($nissaya as $key => $row) {
            // code...
            $activeWorksheet->setCellValue("A{$currLine}", $row->id);
            $activeWorksheet->setCellValue("B{$currLine}", $row->ending);
            $activeWorksheet->setCellValue("C{$currLine}", $row->lang);
            $activeWorksheet->setCellValue("D{$currLine}", $row->relation);
            $activeWorksheet->setCellValue("E{$currLine}", $row->case);
            $currLine++;
        }
        $writer = new Xlsx($spreadsheet);
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="nissaya-ending.xlsx"');
        $writer->save('php://output');
    }

    public function import(Request $request)
    {
        $user = AuthService::current($request);
        if (! $user) {
            return $this->error(__('auth.failed'));
        }

        $filename = $request->input('filename');
        $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx;
        $reader->setReadDataOnly(true);
        $spreadsheet = $reader->load($filename);
        $activeWorksheet = $spreadsheet->getActiveSheet();
        $currLine = 2;
        $countFail = 0;
        $error = '';
        do {
            // code...
            $id = $activeWorksheet->getCell("A{$currLine}")->getValue();
            $ending = $activeWorksheet->getCell("B{$currLine}")->getValue();
            $lang = $activeWorksheet->getCell("C{$currLine}")->getValue();
            $relation = $activeWorksheet->getCell("D{$currLine}")->getValue();
            $case = $activeWorksheet->getCell("E{$currLine}")->getValue();
            if (! empty($ending)) {
                // 查询是否有冲突数据
                // 查询此id是否有旧数据
                if (! empty($id)) {
                    $oldRow = NissayaEnding::find($id);
                }
                // 查询是否跟已有数据重复
                $row = NissayaEnding::where(['ending' => $ending, 'relation' => $relation, 'case' => $case])->first();
                if (! $row) {
                    // 不重复
                    if (isset($oldRow) && $oldRow) {
                        // 有旧的记录-修改旧数据
                        $row = $oldRow;
                    } else {
                        // 没找到旧的记录-新建
                        $row = new NissayaEnding;
                    }
                } else {
                    // 重复-如果与旧的id不同旧报错
                    if (isset($oldRow) && $oldRow && $row->id !== $id) {
                        $error .= "重复的数据：{$id} - {$ending}\n";
                        $currLine++;
                        $countFail++;

                        continue;
                    }
                }
                $row->ending = $ending;
                $row->strlen = mb_strlen($ending, 'UTF-8');
                $row->lang = $lang;
                $row->relation = $relation;
                $row->case = $case;
                $row->editor_id = $user['user_uid'];
                $row->save();
            } else {
                break;
            }
            $currLine++;
        } while (true);

        return $this->ok(['success' => $currLine - 2 - $countFail, 'fail' => ($countFail)], $error);
    }
}