<?ph
namespace App\Http\Controllers;
use App\Helpers\BannerHandler;
use App\Helpers\CTAHandler;
use App\Helpers\DateFilterHandler;
use App\Helpers\Layout_Setting;
use App\Helpers\Tools;
use App\Helpers\WebsiteLinkHandler;
use App\Models\ArticleTag;
use App\Models\EroticNovelTag;
use App\Models\Setting_Outlink;
use App\Models\Setting_System;
use App\Models\Setting_Topic;
use App\Models\Topic;
use App\Models\TopicCategory;
use Google\Cloud\Storage\StorageClient;
use Illuminate\Support\Facades\Redis;
use App\Helpers\ViewRecordHandler;
class TopicController extends Controller
{
    // 專題研究
    public function index($page = 1)
    {
        if ($page < 1 || ! is_numeric($page)) {
            return redirect(route('topic'), 301, []);
        }
        if (gettype($page) != 'integer' && ! isset($page[1])) {
            $page = intval($page);
            if ($page < 10) {$page = '0' . $page;}
            return redirect(route('topic_page', ['page' => $page]), 301, []);
        }
        $storage = new StorageClient([
            'keyFilePath' => env('keyFilePath'),
        ]);
        $bucket = $storage->bucket(env('storage'));
        $unit_config                 = $this->get_topic_setting();
        $topic_categorys             = $this->get_topic_categorys();
        $topic_category_url_name_arr = $this->get_topic_category_url_name_arr($topic_categorys);
        $current                     = $page;
        $perpage                     = $unit_config['perpage'];
        $topic                       = $this->get_topic_pagination($page, $perpage);
        foreach ($topic as $k => $v) {
            // $gcs_image_arr = json_decode($v['gcs_image_arr'], true);
            $gcs_image_arr = is_array($v['gcs_image_arr']) ? $v['gcs_image_arr'] : json_decode($v['gcs_image_arr'], true);
            if (! is_null($gcs_image_arr) && isset($topic_category_url_name_arr[$v['pid']])) {
                if (! is_dir(public_path() . "/userfiles/")) {
                    mkdir(public_path() . "/userfiles/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/")) {
                    mkdir(public_path() . "/userfiles/Topic/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/", 0777);
                }
                foreach ($gcs_image_arr as $key => $value) {
                    if (! is_file(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/" . str_replace(env('gcs_perfix'), '', $value))) {
                        $object = $bucket->object($value);
                        if ($object->exists()) {
                            $stream = $object->downloadToFile(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/" . str_replace(env('gcs_perfix'), '', $value));
                        }
                    }
                }
            }
        }
        $count = Topic::where('status', 1)->count();
        $pages = ceil($count / $perpage);
        if ($pages == 0) {$pages = 1;}
        if ($page > $pages) {
            return redirect(route('topic'), 301, []);
        }
        $page_result = Tools::get_prev_next($page, $pages);
        $schema_breadcrumbList = [
            'context'         => 'https://schema.org',
            'type'            => 'BreadcrumbList',
            'itemListElement' => [
                [
                    'type'     => 'ListItem',
                    'position' => 1,
                    'name'     => '首页',
                    'item'     => route('index'),
                ],
                [
                    'type'     => 'ListItem',
                    'position' => 2,
                    'name'     => '专题研究',
                    'item'     => route('topic'),
                ],
            ],
        ];
        $schema = [
            'context' => 'https://schema.org',
            'type'    => 'ItemList',
        ];
        // LongBanner
        $longbanner = BannerHandler::longbanner(2, "search_active", ['unit' => 'topic', 'cat' => ['topic']]);
        // ShortBanner
        $top_shortbanner = BannerHandler::shortbanner("top", ['unit' => 'topic', 'cat' => ['topic']]);
        $shortbanner     = BannerHandler::shortbanner("search_active", ['unit' => 'topic', 'cat' => ['topic']]);
        // WebsiteLink
        $websitelink = WebsiteLinkHandler::get_weblink(['unit' => 'topic', 'cat' => ['topic']]);
        // CTA
        $config      = config('topic');
        $cta_status  = $config['cta_status'];
        $cta_content = $config['cta_content'];
        $data        = [
            'system_code'                 => 'topic',
            'unit_config'                 => $unit_config,
            'topic_categorys'             => $topic_categorys,
            'topic_category_url_name_arr' => $topic_category_url_name_arr,
            'topic'                       => $topic,
            'current'                     => $current,
            'pages'                       => $pages,
            'erotic_novel_tag'            => $this->get_erotic_novel_tag(),
            'long_banners'                => $longbanner,
            'short_banners'               => $shortbanner,
            'top_short_banners'           => $top_shortbanner,
            'cta_status'                  => $cta_status,
            'cta_content'                 => $cta_content,
            'websitelink'                 => $websitelink,
            /* Schema LD-json */
            'schema_breadcrumbList'       => $schema_breadcrumbList,
            'schema'                      => $schema,
            'prev'                        => (! empty($page_result[0])) ? $page_result[0] : '',
            'next'                        => (! empty($page_result[1])) ? $page_result[1] : '',
        ];
        return view('topic', Layout_Setting::setting($data, 'topic'));
    }

    public function category_detail($category_url_name, $page = 1)
    {
        // 網址中包含空白，跳轉404
        if (strpos($category_url_name, ' ') !== false) {
            return redirect(404);
        }
        if ($page < 1 || ! is_numeric($page)) {
            return redirect(route('topic_category', ['category_url_name' => $category_url_name]), 301, []);
        }
        if (gettype($page) != 'integer' && ! isset($page[1])) {
            $page = intval($page);
            if ($page < 10) {$page = '0' . $page;}
            return redirect(route('topic_category_page', ['category_url_name' => $category_url_name, 'page' => $page]), 301, []);
        }
        $storage = new StorageClient([
            'keyFilePath' => env('keyFilePath'),
        ]);
        $bucket = $storage->bucket(env('storage'));
        $unit_config     = $this->get_topic_setting();
        $topic_categorys = $this->get_topic_categorys();
        $topic_category  = $this->get_topic_category($category_url_name);
        if (is_null($topic_category)) {
            return redirect(route('topic'), 301, []);
        }
        $topic_category_url_name_arr = $this->get_topic_category_url_name_arr($topic_categorys);
        $pid                         = $topic_category['id'];
        $current                     = $page;
        $perpage                     = $unit_config['perpage'];
        $topic                       = $this->get_topic_category_pagination($category_url_name, $pid, $page, $perpage);
        $count                       = Topic::where('pid', $pid)->where('status', 1)->count();
        $pages                       = ceil($count / $perpage);
        if ($pages == 0) {$pages = 1;}
        if ($page > $pages) {
            return redirect(route('topic_category', ['category_url_name' => $category_url_name]), 301, []);
        }
        $page_result = Tools::get_prev_next($page, $pages);
        foreach ($topic as $k => $v) {
            // $gcs_image_arr = json_decode($v['gcs_image_arr'], true);
            $gcs_image_arr = is_array($v['gcs_image_arr']) ? $v['gcs_image_arr'] : json_decode($v['gcs_image_arr'], true);
            if (! is_null($gcs_image_arr) && isset($topic_category_url_name_arr[$v['pid']])) {
                if (! is_dir(public_path() . "/userfiles/")) {
                    mkdir(public_path() . "/userfiles/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/")) {
                    mkdir(public_path() . "/userfiles/Topic/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/", 0777);
                }
                foreach ($gcs_image_arr as $key => $value) {
                    if (! is_file(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/" . str_replace(env('gcs_perfix'), '', $value))) {
                        $object = $bucket->object($value);
                        if ($object->exists()) {
                            $stream = $object->downloadToFile(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$v['pid']]}/{$v['id']}/" . str_replace(env('gcs_perfix'), '', $value));
                        }
                    } else {
                        break;
                    }
                }
            }
        }
        $schema_breadcrumbList = [
            'context'         => 'https://schema.org',
            'type'            => 'BreadcrumbList',
            'itemListElement' => [
                [
                    'type'     => 'ListItem',
                    'position' => 1,
                    'name'     => '首页',
                    'item'     => route('index'),
                ],
                [
                    'type'     => 'ListItem',
                    'position' => 2,
                    'name'     => '专题研究',
                    'item'     => route('topic'),
                ],
                [
                    'type'     => 'ListItem',
                    'position' => 3,
                    'name'     => $topic_category['name'],
                    'item'     => route('topic_category', ['category_url_name' => $topic_category['url_name']]),
                ],
            ],
        ];
        $schema = [
            'context' => 'https://schema.org',
            'type'    => 'ItemList',
        ];
        // LongBanner
        $longbanner = BannerHandler::longbanner(2, "search_active", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
        // ShortBanner
        $top_shortbanner = BannerHandler::shortbanner("top", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
        $shortbanner     = BannerHandler::shortbanner("search_active", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
        // WebsiteLink
        $websitelink = WebsiteLinkHandler::get_weblink(['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
        // CTA
        $config      = config('topic');
        $cta_status  = $config['cta_status'];
        $cta_content = $config['cta_content'];
        $data = [
            'system_code'                 => 'topic_category',
            'bread'                       => ['url_name' => $category_url_name, 'cat_name' => $topic_category['name']],
            'unit_config'                 => $unit_config,
            'topic_categorys'             => $topic_categorys,
            'topic_category_url_name_arr' => $topic_category_url_name_arr,
            'topic_category'              => $topic_category,
            'topic'                       => $topic,
            'current'                     => $current,
            'pages'                       => $pages,
            'erotic_novel_tag'            => $this->get_erotic_novel_tag(),
            'long_banners'                => $longbanner,
            'short_banners'               => $shortbanner,
            'top_short_banners'           => $top_shortbanner,
            'cta_status'                  => $cta_status,
            'cta_content'                 => $cta_content,
            'websitelink'                 => $websitelink,
            /* Schema LD-json */
            'schema_breadcrumbList'       => $schema_breadcrumbList,
            'schema'                      => $schema,
            'prev'                        => (! empty($page_result[0])) ? $page_result[0] : '',
            'next'                        => (! empty($page_result[1])) ? $page_result[1] : '',
        ];
        return view('topic', Layout_Setting::setting($data, 'topic_category', $category_url_name));
    }

    public function detail($category_url_name, $id)
    {
        // 網址中包含空白，跳轉404
        if (strpos($category_url_name, ' ') !== false || strpos($id, ' ') !== false) {
            return redirect(404);
        }
        if (! Redis::exists('data_topic_detail_' . $category_url_name . '_' . $id)) {
            $topic_categorys = $this->get_topic_categorys();
            $topic_category  = $this->get_topic_category($category_url_name);
            if (is_null($topic_category)) {
                return redirect(route('topic'), 301, []);
            }
            $topic          = $this->get_topic($id);
            $topic_disabled = Topic::where('id', $id)->where('status', 0)->get()->first();
            if ($topic_disabled) {
                return redirect(route('topic_category', ['category_url_name' => $category_url_name]), 302, []);
            }
            if (is_null($topic)) {
                return redirect(route('topic_category', ['category_url_name' => $category_url_name]), 301, []);
            }
            // 當 "<img alt=" 無資訊時，將alt加入name
            if (preg_match('/<img alt=""/i', $topic['content']) != false) {
                $pattern          = "/<img alt=\"[\s\S]*?\"/";
                $topic['content'] = preg_replace($pattern, '/<img alt="' . $topic['name'] . '" ', $topic['content']);
            }
            $storage = new StorageClient([
                'keyFilePath' => env('keyFilePath'),
            ]);
            $bucket = $storage->bucket(env('storage'));
            $unit_config                 = $this->get_topic_setting();
            $topic_category_url_name_arr = $this->get_topic_category_url_name_arr($topic_categorys);
            $tags                        = $this->get_tags();
            // $gcs_image_arr               = json_decode($topic['gcs_image_arr'], true);
            $gcs_image_arr = is_array($topic['gcs_image_arr']) ? $topic['gcs_image_arr'] : json_decode($topic['gcs_image_arr'], true);
            if (! is_null($gcs_image_arr) && isset($topic_category_url_name_arr[$topic['pid']])) {
                $image_path = "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/";
                if (! is_dir(public_path() . "/userfiles/")) {
                    mkdir(public_path() . "/userfiles/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/")) {
                    mkdir(public_path() . "/userfiles/Topic/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/", 0777);
                }
                foreach ($gcs_image_arr as $key => $value) {
                    if (! is_file(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/" . str_replace(env('gcs_perfix'), '', $value))) {
                        $object = $bucket->object($value);
                        if ($object->exists()) {
                            $stream = $object->downloadToFile(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/" . str_replace(env('gcs_perfix'), '', $value));
                        }
                    }
                }
            } else {
                $image_path = "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/";
            }
            $data_image_arr = $topic['data_image_arr'];
            if (! is_null($data_image_arr)) {
                if (! is_dir(public_path() . "/userfiles/")) {
                    mkdir(public_path() . "/userfiles/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/")) {
                    mkdir(public_path() . "/userfiles/Topic/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/", 0777);
                }
                if (! is_dir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/")) {
                    mkdir(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/", 0777);
                }
                foreach ($data_image_arr as $key => $value) {
                    if (! is_file(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/" . str_replace(env('gcs_perfix'), '', $value))) {
                        $object = $bucket->object($value);
                        if ($object->exists()) {
                            $stream = $object->downloadToFile(public_path() . "/userfiles/Topic/topic_{$topic_category_url_name_arr[$topic['pid']]}/{$topic['id']}/" . str_replace(env('gcs_perfix'), '', $value));
                        }
                    }
                }
            }
            $prev_bool  = true;
            $prev_count = 1;
            while ($prev_bool) {
                if ($id - $prev_count > 0) {
                    $item = DateFilterHandler::date_filter(Topic::select('id', 'pid', 'name'), ['status' => 1, 'id' => ($id - $prev_count)])->get()->first();
                    if (! is_null($item)) {
                        $item     = $item->toArray();
                        $category = TopicCategory::select('url_name')->where('id', $item['pid'])->where('status', 1)->get()->first();
                        if (! is_null($category)) {
                            $prev_bool = false;
                        } else {
                            $prev_count++;
                        }
                    } else {
                        $prev_count++;
                    }
                } else {
                    $item     = DateFilterHandler::date_filter(Topic::select('id', 'pid', 'name'), ['status' => 1])->orderBy('id', 'desc')->take(1)->get()->first()->toArray();
                    $category = TopicCategory::select('url_name')->where('id', $item['pid'])->where('status', 1)->get()->first()->toArray();
                    if (! is_null($category)) {
                        $prev_bool = false;
                    } else {
                        $id         = $item['id'];
                        $prev_count = 1;
                    }
                }
            }
            $prev_topic = [
                'id'                => $item['id'],
                'name'              => $item['name'],
                'category_url_name' => $category['url_name'],
            ];
            $next_bool  = true;
            $next_count = 1;
            $max_item   = DateFilterHandler::date_filter(Topic::select('id'), ['status' => 1])->orderBy('id', 'desc')->take(1)->get()->first()->toArray();
            $max_id     = $max_item['id'];
            while ($next_bool) {
                if ($id + $next_count <= $max_id) {
                    $item = DateFilterHandler::date_filter(Topic::select('id', 'pid', 'name'), ['status' => 1, 'id' => ($id + $next_count)])->where('status', 1)->get()->first();
                    if (! is_null($item)) {
                        $item     = $item->toArray();
                        $category = TopicCategory::select('url_name')->where('id', $item['pid'])->where('status', 1)->get()->first();
                        if (! is_null($category)) {
                            $next_bool = false;
                        } else {
                            $next_count++;
                        }
                    } else {
                        $next_count++;
                    }
                } else {
                    $item     = DateFilterHandler::date_filter(Topic::select('id', 'pid', 'name'), ['status' => 1])->orderBy('id', 'asc')->take(1)->get()->first()->toArray();
                    $category = TopicCategory::select('url_name')->where('id', $item['pid'])->where('status', 1)->get()->first();
                    if (! is_null($category)) {
                        $next_bool = false;
                    } else {
                        $id         = $item['id'];
                        $next_count = 1;
                    }
                }
            }
            $next_topic = [
                'id'                => $item['id'],
                'name'              => $item['name'],
                'category_url_name' => $category['url_name'],
            ];
            $schema_breadcrumbList = [
                'context'         => 'https://schema.org',
                'type'            => 'BreadcrumbList',
                'itemListElement' => [
                    [
                        'type'     => 'ListItem',
                        'position' => 1,
                        'name'     => '首页',
                        'item'     => route('index'),
                    ],
                    [
                        'type'     => 'ListItem',
                        'position' => 2,
                        'name'     => '专题研究',
                        'item'     => route('topic'),
                    ],
                    [
                        'type'     => 'ListItem',
                        'position' => 3,
                        'name'     => $topic['name'],
                        'item'     => route('topic_detail', ['category_url_name' => $topic_category['url_name'], 'id' => $id]),
                    ],
                ],
            ];
            if (strpos(url()->full(), '?') !== false) {
                $route = explode('?', url()->full());
                $route = $route[0];
            } else {
                $route = url()->full();
            }
            $logo = Setting_System::select('head_logo')->where('id', '1')->get()->first()->toArray();
            $schema = [
                'context'          => 'https://schema.org',
                'type'             => 'Article',
                'mainEntityOfPage' => [
                    'type' => 'WebPage',
                    'id'   => $route,
                ],
                'headline'         => $topic['name'],
                'image'            => asset($topic['cover_image'] ? $image_path . $topic['cover_image'] : ''),
                'author'           => [
                    'type' => 'Organization',
                    'name' => config('all')['title'],
                ],
                'publisher'        => [
                    'type' => 'Organization',
                    'name' => config('all')['title'],
                    'logo' => [
                        'type' => 'ImageObject',
                        'url'  => asset($logo['head_logo']),
                    ],
                ],
                'datePublished'    => date(DATE_ISO8601, strtotime($topic['posted_at'])),
                'dateModified'     => date(DATE_ISO8601, strtotime($topic['updated_at'])),
            ];
            // LongBanner
            $longbanner = BannerHandler::longbanner(2, "search_active", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
            // ShortBanner
            $top_shortbanner = BannerHandler::shortbanner("top", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
            $shortbanner     = BannerHandler::shortbanner("search_active", ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
            // cta
            $cta  = CTAHandler::get_cta(1, ['unit' => 'topic', 'cat' => ['topic', $category_url_name]]);
            $data = [
                'system_code'           => 'topic_detail',
                'unit_config'           => $unit_config,
                'bread'                 => ['url_name' => $category_url_name, 'cat_name' => $topic_category['name']],
                'topic_categorys'       => $topic_categorys,
                'topic_category'        => $topic_category,
                'topic'                 => $topic,
                'tags'                  => $tags,
                'erotic_novel_tag'      => $this->get_erotic_novel_tag(),
                'prev_topic'            => $prev_topic,
                'next_topic'            => $next_topic,
                'long_banners'          => $longbanner,
                'short_banners'         => $shortbanner,
                'top_short_banners'     => $top_shortbanner,
                'cta'                   => $cta,
                'og_image'              => asset($topic['cover_image'] ? $image_path . $topic['cover_image'] : ''),
                /* Schema LD-json */
                'schema_breadcrumbList' => $schema_breadcrumbList,
                'schema'                => $schema,
            ];
            Redis::setex('data_topic_detail_' . $category_url_name . '_' . $id, env('cache_second'), json_encode($data));
        } else {
            $data = json_decode(Redis::get('data_topic_detail_' . $category_url_name . '_' . $id), true);
            $this->get_topic($id);
            $result = DateFilterHandler::date_filter(Topic::select('id'), ['status' => '1', 'id' => $id])->get()->first();
            if (is_null($result)) {
                Redis::del('data_topic_detail_' . $category_url_name . '_' . $id);
                return redirect(route('topic_category', ['category_url_name' => $category_url_name]), 301, []);
            }
        }
        // 獨立於 Redis 快取檢查之外：無論快取是否存在，每次瀏覽皆即時更新瀏覽次數
        if(isset($topic) && $topic)
            ViewRecordHandler::handler($topic instanceof Topic ? $topic : Topic::find($topic['id']));
        return view('topic_detail', Layout_Setting::setting($data, 'topic_detail', $category_url_name, $id));
    }

    public function get_topic_setting()
    {
        return Setting_Topic::get()->first()->toArray();
    }

    public function get_erotic_novel_tag()
    {
        // 系統設定
        $system_config = Setting_System::get()->first()->toArray();
        return EroticNovelTag::select('url_name', 'name')->where('status', 1)->orderBy('sort', 'desc')->take($system_config['novel_tag'])->get()->toArray();
    }

    public function get_topic_categorys()
    {
        if (! Redis::exists('topic_categorys')) {
            $data = TopicCategory::select('id', 'url_name', 'name')->where('status', 1)->orderBy('id', 'asc')->get()->toArray();
            Redis::setex('topic_categorys', env('cache_second'), json_encode($data));
        } else {
            $data = json_decode(Redis::get('topic_categorys'), true);
        }
        return $data;
    }

    public function get_topic_category_url_name_arr($topic_categorys)
    {
        foreach ($topic_categorys as $k => $v) {
            $cats_arr[$v['id']] = $v['url_name'];
        }
        return $cats_arr;
    }

    public function get_topic_pagination($page, $perpage)
    {
        $topic_category_arr = [];
        $topic_arr          = [];
        $topic_category     = TopicCategory::where('status', 1)->get()->toArray();
        foreach ($topic_category as $key => $value) {
            array_push($topic_category_arr, $value['id']);
        }
        $topic_arr = DateFilterHandler::date_filter_with_category_arr(Topic::select('id', 'pid', 'name', 'gcs_image_arr', 'cover_image'), ['status' => 1], ['pid' => $topic_category_arr])->orderBy('top', 'desc')->orderBy('sort', 'desc')->orderBy('view_record', 'desc')->paginate($perpage, ['*'], 'page', $page);
        return $topic_arr;
    }

    public function get_topic_category($category_url_name)
    {
        $cat = TopicCategory::where('url_name', $category_url_name)->where('status', 1)->get()->first();
        return (is_null($cat)) ? null : $cat->toArray();
    }

    public function get_topic_category_pagination($category_url_name, $pid, $page, $perpage)
    {
        $topic = DateFilterHandler::date_filter(Topic::select('id', 'pid', 'name', 'gcs_image_arr', 'cover_image'), ['status' => 1, 'pid' => $pid])->orderBy('top', 'desc')->orderBy('sort', 'desc')->orderBy('view_record', 'desc')->get()->toArray();
        foreach ($topic as $key => $value) {
            $cat = TopicCategory::where('id', $value['pid'])->where('status', 1)->get()->first();
            if (is_null($cat)) {unset($topic[$key]);}
        }
        $topic = array_values($topic);
        $data  = [];
        if ($perpage * ($page - 1) + $perpage < count($topic)) {
            $limit = $perpage * ($page - 1) + $perpage;
        } else {
            $limit = count($topic);
        }
        for ($i = $perpage * ($page - 1); $i < $limit; $i++) {
            array_push($data, $topic[$i]);
        }
        return $data;
    }

    public function get_topic($id)
    {
        if (! Redis::exists('topic_id_' . $id)) {
            $data = Topic::where('id', $id)->where('status', 1)->get()->first();
            Redis::setex('topic_id_' . $id, env('cache_second'), json_encode($data));
        } else {
            $data = json_decode(Redis::get('topic_id_' . $id), true);
            if ($data) {
                // 如果redis中有資料，則更新瀏覽次數
                Topic::where('id', $id)->update(['view_record' => ($data['view_record'] + 1), 'updated_at' => \DB::raw('updated_at')]);
                // 更新redis中的資料
                $data['view_record'] = $data['view_record'] + 1;
                Redis::setex('topic_id_' . $id, env('cache_second'), json_encode($data));
            }
        }
        return $data;
    }

    public function get_tags()
    {
        $tags_arr = [];
        $tags     = ArticleTag::where('status', 1)->get()->toArray();
        foreach ($tags as $k => $v) {
            $tags_arr[$v['id']] = ['name' => $v['name'], 'url_name' => $v['url_name']];
        }
        return $tags_arr;
    }
}<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1">

        <title>Server Error</title>

        <!-- Fonts -->
        <link rel="preconnect" href="https://fonts.gstatic.com">
        <link href="https://fonts.googleapis.com/css2?family=Nunito&display=swap" rel="stylesheet">

        <style>
            /*! normalize.css v8.0.1 | MIT License | github.com/necolas/normalize.css */html{line-height:1.15;-webkit-text-size-adjust:100%}body{margin:0}a{background-color:transparent}code{font-family:monospace,monospace;font-size:1em}[hidden]{display:none}html{font-family:system-ui,-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Helvetica Neue,Arial,Noto Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji;line-height:1.5}*,:after,:before{box-sizing:border-box;border:0 solid #e2e8f0}a{color:inherit;text-decoration:inherit}code{font-family:Menlo,Monaco,Consolas,Liberation Mono,Courier New,monospace}svg,video{display:block;vertical-align:middle}video{max-width:100%;height:auto}.bg-white{--bg-opacity:1;background-color:#fff;background-color:rgba(255,255,255,var(--bg-opacity))}.bg-gray-100{--bg-opacity:1;background-color:#f7fafc;background-color:rgba(247,250,252,var(--bg-opacity))}.border-gray-200{--border-opacity:1;border-color:#edf2f7;border-color:rgba(237,242,247,var(--border-opacity))}.border-gray-400{--border-opacity:1;border-color:#cbd5e0;border-color:rgba(203,213,224,var(--border-opacity))}.border-t{border-top-width:1px}.border-r{border-right-width:1px}.flex{display:flex}.grid{display:grid}.hidden{display:none}.items-center{align-items:center}.justify-center{justify-content:center}.font-semibold{font-weight:600}.h-5{height:1.25rem}.h-8{height:2rem}.h-16{height:4rem}.text-sm{font-size:.875rem}.text-lg{font-size:1.125rem}.leading-7{line-height:1.75rem}.mx-auto{margin-left:auto;margin-right:auto}.ml-1{margin-left:.25rem}.mt-2{margin-top:.5rem}.mr-2{margin-right:.5rem}.ml-2{margin-left:.5rem}.mt-4{margin-top:1rem}.ml-4{margin-left:1rem}.mt-8{margin-top:2rem}.ml-12{margin-left:3rem}.-mt-px{margin-top:-1px}.max-w-xl{max-width:36rem}.max-w-6xl{max-width:72rem}.min-h-screen{min-height:100vh}.overflow-hidden{overflow:hidden}.p-6{padding:1.5rem}.py-4{padding-top:1rem;padding-bottom:1rem}.px-4{padding-left:1rem;padding-right:1rem}.px-6{padding-left:1.5rem;padding-right:1.5rem}.pt-8{padding-top:2rem}.fixed{position:fixed}.relative{position:relative}.top-0{top:0}.right-0{right:0}.shadow{box-shadow:0 1px 3px 0 rgba(0,0,0,.1),0 1px 2px 0 rgba(0,0,0,.06)}.text-center{text-align:center}.text-gray-200{--text-opacity:1;color:#edf2f7;color:rgba(237,242,247,var(--text-opacity))}.text-gray-300{--text-opacity:1;color:#e2e8f0;color:rgba(226,232,240,var(--text-opacity))}.text-gray-400{--text-opacity:1;color:#cbd5e0;color:rgba(203,213,224,var(--text-opacity))}.text-gray-500{--text-opacity:1;color:#a0aec0;color:rgba(160,174,192,var(--text-opacity))}.text-gray-600{--text-opacity:1;color:#718096;color:rgba(113,128,150,var(--text-opacity))}.text-gray-700{--text-opacity:1;color:#4a5568;color:rgba(74,85,104,var(--text-opacity))}.text-gray-900{--text-opacity:1;color:#1a202c;color:rgba(26,32,44,var(--text-opacity))}.uppercase{text-transform:uppercase}.underline{text-decoration:underline}.antialiased{-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale}.tracking-wider{letter-spacing:.05em}.w-5{width:1.25rem}.w-8{width:2rem}.w-auto{width:auto}.grid-cols-1{grid-template-columns:repeat(1,minmax(0,1fr))}@-webkit-keyframes spin{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}@keyframes  spin{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}@-webkit-keyframes ping{0%{transform:scale(1);opacity:1}75%,to{transform:scale(2);opacity:0}}@keyframes  ping{0%{transform:scale(1);opacity:1}75%,to{transform:scale(2);opacity:0}}@-webkit-keyframes pulse{0%,to{opacity:1}50%{opacity:.5}}@keyframes  pulse{0%,to{opacity:1}50%{opacity:.5}}@-webkit-keyframes bounce{0%,to{transform:translateY(-25%);-webkit-animation-timing-function:cubic-bezier(.8,0,1,1);animation-timing-function:cubic-bezier(.8,0,1,1)}50%{transform:translateY(0);-webkit-animation-timing-function:cubic-bezier(0,0,.2,1);animation-timing-function:cubic-bezier(0,0,.2,1)}}@keyframes  bounce{0%,to{transform:translateY(-25%);-webkit-animation-timing-function:cubic-bezier(.8,0,1,1);animation-timing-function:cubic-bezier(.8,0,1,1)}50%{transform:translateY(0);-webkit-animation-timing-function:cubic-bezier(0,0,.2,1);animation-timing-function:cubic-bezier(0,0,.2,1)}}@media (min-width:640px){.sm\:rounded-lg{border-radius:.5rem}.sm\:block{display:block}.sm\:items-center{align-items:center}.sm\:justify-start{justify-content:flex-start}.sm\:justify-between{justify-content:space-between}.sm\:h-20{height:5rem}.sm\:ml-0{margin-left:0}.sm\:px-6{padding-left:1.5rem;padding-right:1.5rem}.sm\:pt-0{padding-top:0}.sm\:text-left{text-align:left}.sm\:text-right{text-align:right}}@media (min-width:768px){.md\:border-t-0{border-top-width:0}.md\:border-l{border-left-width:1px}.md\:grid-cols-2{grid-template-columns:repeat(2,minmax(0,1fr))}}@media (min-width:1024px){.lg\:px-8{padding-left:2rem;padding-right:2rem}}@media (prefers-color-scheme:dark){.dark\:bg-gray-800{--bg-opacity:1;background-color:#2d3748;background-color:rgba(45,55,72,var(--bg-opacity))}.dark\:bg-gray-900{--bg-opacity:1;background-color:#1a202c;background-color:rgba(26,32,44,var(--bg-opacity))}.dark\:border-gray-700{--border-opacity:1;border-color:#4a5568;border-color:rgba(74,85,104,var(--border-opacity))}.dark\:text-white{--text-opacity:1;color:#fff;color:rgba(255,255,255,var(--text-opacity))}.dark\:text-gray-400{--text-opacity:1;color:#cbd5e0;color:rgba(203,213,224,var(--text-opacity))}}
        </style>

        <style>
            body {
                font-family: 'Nunito', sans-serif;
            }
        </style>
    </head>
    <body class="antialiased">
        <div class="relative flex items-top justify-center min-h-screen bg-gray-100 dark:bg-gray-900 sm:items-center sm:pt-0">
            <div class="max-w-xl mx-auto sm:px-6 lg:px-8">
                <div class="flex items-center pt-8 sm:justify-start sm:pt-0">
                    <div class="px-4 text-lg text-gray-500 border-r border-gray-400 tracking-wider">
                        500                    </div>

                    <div class="ml-4 text-lg text-gray-500 uppercase tracking-wider">
                        Server Error                    </div>
                </div>
            </div>
        </div>
    </body>
</html>