mint/api-v12/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->input("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->input("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)
    {
        //
    }
}