mint/api-v8/app/Http/Controllers/ExportWbwController.php

<?php

namespace App\Http\Controllers;

use App\Models\Wbw;
use App\Models\WbwBlock;
use App\Models\PaliSentence;
use Illuminate\Http\Request;

class ExportWbwController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        //
        $sent = explode("\n",$request->get("sent"));
        $output = [];
        foreach ($sent as $key => $value) {
            # code...
            $sent = [];
            $value = trim($value);
            $sentId = explode("-",$value);
            //先查wbw block 拿到block id
            $block = WbwBlock::where('book_id',$sentId[0])
                        ->where('paragraph',$sentId[1])
                        ->select('uid')
                        ->where('channel_uid',$request->get("channel"))->first();
            if(!$block){
                continue;
            }
            $wbwdata = Wbw::where('book_id',$sentId[0])
                        ->where('paragraph',$sentId[1])
                        ->where('wid','>=',$sentId[2])
                        ->where('wid','<=',$sentId[3])
                        ->where('block_uid',$block->uid)
                        ->get();
            $sent['sid']=$value;
            $sent['text'] = PaliSentence::where('book',$sentId[0])
                                        ->where('paragraph',$sentId[1])
                                        ->where('word_begin',$sentId[2])
                                        ->where('word_end','<=',$sentId[3])
                                        ->value('html');
            $sent['data']=[];
            foreach ($wbwdata as  $wbw) {
                # code...
                $data = str_replace("&nbsp;",' ',$wbw->data);
                $data = str_replace("<br>",' ',$data);

                $xmlString = "<root>" . $data . "</root>";
                try{
                    $xmlWord = simplexml_load_string($xmlString);
                }catch(Exception $e){
                    continue;
                }

                $wordsList = $xmlWord->xpath('//word');
                foreach ($wordsList as $word) {
                    $pali = $word->real->__toString();
                    $case = explode("#",$word->case->__toString()) ;
                    if(isset($case[0])){
                        $type = $case[0];
                    }else{
                        $type = "";
                    }

                    if(isset($case[1])){
                        $grammar = $case[1];
                        $grammar = str_replace("null","",$grammar);
                    }else{
                        $grammar = "";
                    }

                    $style = $word->style->__toString();
                    $factormeaning = str_replace("
","",$word->om->__toString());
                    $factormeaning = str_replace("↓↓","",$factormeaning);
                    if($type !== '.ctl.' && $style !== 'note' && !empty($pali)){
                        $sent['data'][]=[
                            'pali'=>$word->real->__toString(),
                            'mean' => str_replace("
","",$word->mean->__toString()),
                            'type' => ltrim($type,'.'),
                            'grammar' => ltrim(str_replace('$.',',',$grammar),'.') ,
                            'parent' => $word->parent->__toString(),
                            'factors' => $word->org->__toString(),
                            'factormeaning' => $factormeaning
                        ];
                    }

                }
            }
            $output[]=$sent;
        }
        return view('export_wbw',['sentences' => $output] );
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Wbw  $wbw
     * @return \Illuminate\Http\Response
     */
    public function show(Wbw $wbw)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Wbw  $wbw
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Wbw $wbw)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Wbw  $wbw
     * @return \Illuminate\Http\Response
     */
    public function destroy(Wbw $wbw)
    {
        //
    }
}