public function getCharacters(Request $request)
{
$vn_id = $request->input('vn_id');
$user = JWTAuth::parseToken()->authenticate();
if (!empty($vn_id)) {
$character = Character::leftJoin('lineaments', function ($join) use($user) {
$join->on('lineaments.character_id', '=', 'characters.id');
$join->on('lineaments.user_id', '=', \DB::raw($user->id));
})->select('characters.*', 'lineaments.note', 'lineaments.mark', 'lineaments.id as lineament_id')->where('vn_id', $vn_id)->orderBy('characters.id')->get();
return response()->json(['data' => $character]);
} else {
$character = Character::orderBy('yobikata')->paginate(10);
return response()->json($character);
}
}
