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

<?php

namespace App\Http\Controllers;

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

class ExportWbwController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return 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.
     *
     * @return Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @return Response
     */
    public function show(Wbw $wbw)
    {
        //
    }

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

    /**
     * Remove the specified resource from storage.
     *
     * @return Response
     */
    public function destroy(Wbw $wbw)
    {
        //
    }
}