mint/app/Http/Controllers/NissayaEndingController.php

<?php

namespace App\Http\Controllers;

use App\Models\NissayaEnding;
use App\Models\Relation;
use App\Models\DhammaTerm;
use Illuminate\Http\Request;
use App\Http\Resources\NissayaEndingResource;
use App\Http\Api\AuthApi;
use App\Http\Api\ChannelApi;
use Illuminate\Support\Facades\App;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use mustache\mustache;

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

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

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

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

        if(($request->has('search'))){
            $table->where('ending', 'like', $request->get('search')."%");
        }
        if(!empty($request->get('order')) && !empty($request->get('dir'))){
            $table->orderBy($request->get('order'),$request->get('dir'));
        }else{
            $table->orderBy('updated_at','desc');
        }
        $count = $table->count();
        if(!empty($request->get('limit'))){
            $offset = 0;
            if(!empty($request->get("offset"))){
                $offset = $request->get("offset");
            }
            $table->skip($offset)->take($request->get('limit'));
        }
        $result = $table->get();

		if($result){
			return $this->ok(["rows"=>NissayaEndingResource::collection($result),"count"=>$count]);
		}else{
			return $this->error("没有查询到数据");
		}
    }


    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
        $user = AuthApi::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->get('relation');
        $new->case = $request->get('case');
        $new->editor_id = $user['user_uid'];
        $new->save();
        return $this->ok(new NissayaEndingResource($new));
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\NissayaEnding  $nissayaEnding
     * @return \Illuminate\Http\Response
     */
    public function show(NissayaEnding $nissayaEnding)
    {
        //
        return $this->ok(new NissayaEndingResource($nissayaEnding));

    }

    public function nissaya_card(Request $request)
    {
        //
        $cardData = [];
        App::setLocale($request->get('lang'));
        $localTerm = ChannelApi::getSysChannel(
                                "_System_Grammar_Term_".strtolower($request->get('lang'))."_",
                                "_System_Grammar_Term_en_"
                            );
        if(!$localTerm){
            return $this->error('no term channel');
        }
        $termTable = DhammaTerm::where('channal',$localTerm);
        $cardData['ending'] = $request->get('ending');
        $endingTerm = $termTable->where('word',$request->get('ending'))->first();
        if($endingTerm){
            $cardData['ending_tag'] = $endingTerm->tag;
            $cardData['ending_meaning'] = $endingTerm->meaning;
            $cardData['ending_note'] = $endingTerm->note;
        }

        $myEnding = NissayaEnding::where('ending',$request->get('ending'))
                                 ->groupBy('relation')
                                 ->select('relation')->get();
        if(count($myEnding) === 0){
            if(!isset($cardData['ending_note'])){
                $cardData['ending_note'] = "no record\n";
            }
        }

        $relations = Relation::whereIn('name',$myEnding)->get();
        if(count($relations) === 0){
            return $this->ok("# no relation\n".$request->get('ending'));
        }
        $cardData['title_case'] = "格位";
        $cardData['title_content'] = "含义";
        $cardData['title_local_ending'] = "翻译建议";
        $cardData['title_local_relation'] = "关系";
        $cardData['title_relation'] = "关系";
        foreach ($relations as $key => $relation) {
            $relationInTerm = DhammaTerm::where('channal',$localTerm)->where('word',$relation['name'])->first();
            if(empty($relation->case)){
                $cardData['row'][] = ["relation"=>$relation->name];
                continue;
            }
            $case = $relation->case;
            # 格位
            $newLine['case'] = __("grammar.".$case);
            //含义
            if($relationInTerm){
                $newLine['other_meaning'] = $relationInTerm->other_meaning;
                $newLine['note'] = $relationInTerm->note;
                if(!empty($relationInTerm->note)){
                    $newLine['summary'] = explode("\n",$relationInTerm->note)[0];
                }
            }
            //翻译建议
            $localEnding = '';
            $localEndingRecord = NissayaEnding::where('relation',$relation['name'])
                                              ->where('lang',$request->get('lang'));
            if(!empty($case)){
                $localEndingRecord = $localEndingRecord->where('case',$case);
            }
            $localLangs = $localEndingRecord->get();
            foreach ($localLangs as $localLang) {
                # code...
                $localEnding .= $localLang->ending.",";
            }
            $newLine['local_ending'] = $localEnding;

            //本地语言 关系名称
            if($relationInTerm){
                $newLine['local_relation'] =  $relationInTerm->meaning;
            }
            //关系名称
            $newLine['relation'] =  strtoupper($relation['name']);
            $cardData['row'][] = $newLine;
        }

        $m = new \Mustache_Engine(array('entity_flags'=>ENT_QUOTES));
        $tpl = file_get_contents(resource_path("mustache/nissaya_ending_card.tpl"));
        $md = $m->render($tpl,$cardData);
        return $this->ok($md);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\NissayaEnding  $nissayaEnding
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, NissayaEnding $nissayaEnding)
    {
        //
        $user = AuthApi::current($request);
        if(!$user){
            return $this->error(__('auth.failed'));
        }
        //查询是否重复
        if(NissayaEnding::where('ending',$request->get('ending'))
                 ->where('lang',$request->get('lang'))
                 ->where('relation',$request->get('relation'))
                 ->where('case',$request->get('case'))
                 ->exists()){
            return $this->error(__('validation.exists',['name']));
        }
        $nissayaEnding->ending = $request->get('ending');
        $nissayaEnding->strlen = mb_strlen($request->get('ending'),"UTF-8") ;
        $nissayaEnding->lang = $request->get('lang');
        $nissayaEnding->relation = $request->get('relation');
        $nissayaEnding->case = $request->get('case');
        $nissayaEnding->editor_id = $user['user_uid'];
        $nissayaEnding->save();
        return $this->ok(new NissayaEndingResource($nissayaEnding));

    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\NissayaEnding  $nissayaEnding
     * @return \Illuminate\Http\Response
     */
    public function destroy(Request $request,NissayaEnding $nissayaEnding)
    {
        //
        $user = AuthApi::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 = AuthApi::current($request);
        if(!$user){
            return $this->error(__('auth.failed'));
        }

        $filename = $request->get('filename');
        $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
        $reader->setReadDataOnly(true);
        $spreadsheet = $reader->load($filename);
        $activeWorksheet = $spreadsheet->getActiveSheet();
        $currLine = 2;
        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)){
                $row = NissayaEnding::firstOrNew(['ending'=>$ending,'relation'=>$relation,'case'=>$case]);
                $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 (!empty($ending));
        return $this->ok($currLine-2);
    }
}