<?php

namespace App\Services\Common;

use App\Models\ArticleCategoryModel;
use App\Services\BaseService;
use Illuminate\Support\Facades\DB;

/**
 * 文章分类管理-服务类
 * @author laravel开发员
 * @since 2020/11/11
 * Class ArticleCategoryService
 * @package App\Services\Common
 */
class ArticleCategoryService extends BaseService
{
    /**
     * 构造函数
     * @author laravel开发员
     * @since 2020/11/11
     * ArticleCategoryService constructor.
     */
    public function __construct()
    {
        $this->model = new ArticleCategoryModel();
    }

    /**
     * 获取分类数据列表（树形结构）
     */
    public function getDataList($params, $pageSize = 15)
    {
        $query = $this->model->where('mark', 1);

        // 按类型过滤
        if (!empty($params['type'])) {
            $query->where('type', $params['type']);
        }

        // 按状态过滤
        if (isset($params['status']) && $params['status'] !== '') {
            $query->where('status', $params['status']);
        }

        // 按名称搜索
        if (!empty($params['keyword'])) {
            $query->where('name', 'like', "%{$params['keyword']}%");
        }

        $items = $query->orderBy('sort', 'desc')
            ->orderBy('id', 'desc')
            ->get()
            ->toArray();


        // 处理图片字段
        foreach ($items as &$item) {
            if (!empty($item['icon'])) {
                $item['icon'] = get_image_url($item['icon']);
            }
            $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
            $item['update_time'] = $item['update_time'] ? datetime($item['update_time'], 'Y-m-d H:i:s') : '';
        }

        // 构建树形结构
        $tree = $this->buildTree($items);

        return [
            'pageSize' => $pageSize,
            'total' => count($items),
            'list' => $tree
        ];
    }

    /**
     * 构建树形结构
     */
    private function buildTree($items, $pid = 0)
    {
        $tree = [];
        foreach ($items as $item) {
            // 确保 pid 字段存在，默认为 0
            $itemPid = isset($item['pid']) ? $item['pid'] : 0;
            if ($itemPid == $pid) {
                $children = $this->buildTree($items, $item['id']);
                if (!empty($children)) {
                    $item['children'] = $children;
                }
                $tree[] = $item;
            }
        }
        return $tree;
    }

    /**
     * 获取分类选项列表（树形结构）
     * @return array
     */
    public function getOptions()
    {
        $query = $this->model->where(['status' => 1, 'mark' => 1]);

        // 按类型过滤
        $type = request()->get('type');
        if ($type) {
            $query->where('type', $type);
        }


        $datas = $query->select(['id', 'name', 'pid'])
            ->orderBy('sort', 'desc')
            ->orderBy('id', 'desc')
            ->get()
            ->toArray();

        // 构建树形结构
        return $this->buildTree($datas);
    }

    /**
     * 获取父级分类选项（用于选择父级分类）
     * @return array
     */
    public function getParentOptions()
    {
        $query = $this->model->where(['status' => 1, 'mark' => 1, 'pid' => 0]);

        // 按类型过滤
        $type = request()->get('type');
        if ($type) {
            $query->where('type', $type);
        }

        return $query->select(['id', 'name', 'pid'])
            ->orderBy('sort', 'desc')
            ->orderBy('id', 'desc')
            ->get()
            ->toArray();
    }

    /**
     * 检查表是否有 pid 字段
     * @return bool
     */
    private function checkPidFieldExists()
    {
        try {
            $tableName = $this->model->getTable();
            $columns = DB::select("SHOW COLUMNS FROM `{$tableName}` LIKE 'pid'");
            return !empty($columns);
        } catch (\Exception $e) {
            // 如果查询失败，假设没有 pid 字段
            return false;
        }
    }

    /**
     * 添加或编辑分类
     */
    public function edit()
    {
        $data = request()->all();

        // 处理图标字段
        if (!empty($data['icon'])) {
            $data['icon'] = get_image_path(trim($data['icon']));
        }

        $id = $data['id'] ?? 0;
        $data['pid'] = empty($data['pid']) ? 0 : $data['pid'];

        // 默认字段处理
        $data['update_time'] = time();
        if (!$id) {
            $data['create_time'] = time();
        }

        return parent::edit($data);
    }
}