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(" ", ' ', $wbw->data);
$data = str_replace("
", ' ', $data);
$xmlString = "" . $data . "";
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)
{
//
}
}