mes-ai-server-api/application/api/controller/Material.php

<?php

namespace app\api\controller;
use app\common\controller\Api;
use app\service\AIGatewayService;
use think\Db;
use think\Exception;

class Material extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];
    public function index()
    {
        $this->success('Material');
    }

    /**
     * 上传图片保存扩展名：优先客户端文件名，无后缀时用 MIME 推断，避免生成 xxx. 无扩展名
     */
    protected function resolveUploadedImageExt($file)
    {
        $name = $file->getInfo('name') ?? '';
        $ext = strtolower(pathinfo($name, PATHINFO_EXTENSION));
        if ($ext === 'jpeg') {
            $ext = 'jpg';
        }
        $allowed = ['jpg', 'png', 'gif', 'webp', 'bmp'];
        if ($ext && in_array($ext, $allowed, true)) {
            return $ext;
        }
        $mime = method_exists($file, 'getMime') ? strtolower((string) $file->getMime()) : '';
        $map = [
            'image/jpeg' => 'jpg',
            'image/png' => 'png',
            'image/gif' => 'gif',
            'image/webp' => 'webp',
            'image/bmp' => 'bmp',
        ];
        if (isset($map[$mime])) {
            return $map[$mime];
        }
        return 'jpg';
    }

    /**
     * 新增素材图片上传
     *
     * 方式一（推荐，与当前前端一致）：multipart/form-data
     *   - Category_id：分类 ID
     *   - img[] 或 img：多张图片文件（字段名 img，多文件用 img[]）
     *   - material_name[] 或 material_name：与图片一一对应的名称数组
     *   - sys_id：可选
     *
     * 方式二：JSON / 表单里传 uploaded_materials（base64）
     *   - uploaded_materials=[{data:'data:image/png;base64,...', material_name:'xxx'}, ...]
     */
    public function Material_Add()
    {
        $params = $this->request->param();
        $sysId = trim($params['sys_id'] ?? '');
        $categoryId = isset($params['Category_id']) ? intval($params['Category_id']) : null;

        $dateDir = date('Y-m-d');
        $materialSavePath = str_replace('\\', '/', ROOT_PATH) . 'public/uploads/material/' . $dateDir . '/';
        if (!is_dir($materialSavePath)) {
            mkdir($materialSavePath, 0755, true);
        }

        $uploaded = [];

        $files = $this->request->file('img');
        if (!empty($files)) {
            $fileList = is_array($files) ? $files : [$files];
            $names = $params['material_name'] ?? [];
            if (!is_array($names)) {
                $names = [$names];
            }
            foreach ($fileList as $i => $file) {
                if (!$file || !$file->isValid()) {
                    continue;
                }
                $saveFileName = uniqid() . '_' . date('YmdHis') . '.' . $this->resolveUploadedImageExt($file);
                $info = $file->move($materialSavePath, $saveFileName);
                if (!$info) {
                    continue;
                }
                $savedName = $info->getFilename();
                $materialUrl = '/uploads/material/' . $dateDir . '/' . $savedName;
                $materialRecord = [
                    'sys_id'        => $sysId,
                    'Category_id'   => $categoryId,
                    'material_name' => trim($names[$i] ?? ''),
                    'material_url'  => $materialUrl,
                    'create_time'   => date('Y-m-d H:i:s'),
                    'count'         => 1
                ];
                $materialId = Db::name('template_material')->insertGetId($materialRecord);
                $uploaded[] = ['id' => $materialId, 'material_url' => $materialUrl];
            }
        } else {
            $materials = $params['uploaded_materials'] ?? [];
            if (empty($materials) || !is_array($materials)) {
                return json(['code' => 1, 'msg' => '请上传至少一张素材图片（img/img[] 或 uploaded_materials）']);
            }
            foreach ($materials as $item) {
                $base64Data = $item['data'] ?? '';
                if (empty($base64Data) || !preg_match('/data:image\/(png|jpg|jpeg|webp);base64,([^\)]+)/i', $base64Data, $m)) {
                    continue;
                }
                $imageType = strtolower($m[1]);
                $rawBase64 = preg_replace('/\s+/', '', $m[2]);
                $imageData = base64_decode($rawBase64);
                if ($imageData === false || strlen($imageData) < 100) {
                    continue;
                }
                $ext = ($imageType === 'jpeg') ? 'jpg' : $imageType;
                $fileName = uniqid() . '_' . date('YmdHis') . '.' . $ext;
                $fullPath = $materialSavePath . $fileName;
                if (!file_put_contents($fullPath, $imageData)) {
                    continue;
                }
                $materialUrl = '/uploads/material/' . $dateDir . '/' . $fileName;
                $materialRecord = [
                    'sys_id'        => $sysId,
                    'Category_id'   => $categoryId,
                    'material_name' => trim($item['material_name'] ?? ''),
                    'material_url'  => $materialUrl,
                    'create_time'   => date('Y-m-d H:i:s'),
                    'count'         => 1
                ];
                $materialId = Db::name('template_material')->insertGetId($materialRecord);
                $uploaded[] = ['id' => $materialId, 'material_url' => $materialUrl];
            }
        }

        if (empty($uploaded)) {
            return json(['code' => 1, 'msg' => '没有有效的图片上传成功']);
        }

        return json(['code' => 0, 'msg' => '上传成功', 'data' => ['list' => $uploaded, 'count' => count($uploaded)]]);
    }

    /**
     * 素材图片删除（软删除）
     */
    public function materialDelete()
    {
        $params = $this->request->param();
        $record['mod_rq'] = date('Y-m-d H:i:s');
        $res = Db::name('template_material')->where('id', $params['id'])->update($record);
        if (!$res) {
            return json([
                'code' => 1,
                'msg'  => '删除失败',
                'data' => ''
            ]);
        }
        return json([
            'code' => 0,
            'msg'  => '删除成功'
        ]);
    }

    /**
     * 素材修改
     * 参数：id(必填), material_name(可选), Category_id(可选)
     */
    public function Material_Update()
    {
        $params = $this->request->param();
        if (empty($params['id']) || !is_numeric($params['id'])) {
            return json(['code' => 1, 'msg' => 'id 不能为空']);
        }
        $id = intval($params['id']);
        $row = Db::name('template_material')->where('id', $id)->whereNull('mod_rq')->find();
        if (!$row) {
            return json(['code' => 1, 'msg' => '记录不存在或已删除']);
        }

        $update = ['update_time' => date('Y-m-d H:i:s')];
        if (array_key_exists('material_name', $params)) {
            $update['material_name'] = trim($params['material_name'] ?? '');
        }
        if (array_key_exists('Category_id', $params)) {
            $update['Category_id'] = $params['Category_id'] === '' || $params['Category_id'] === null ? null : intval($params['Category_id']);
        }

        if (count($update) <= 1) {
            return json(['code' => 1, 'msg' => '无有效修改字段']);
        }

        $affected = Db::name('template_material')->where('id', $id)->update($update);
        if ($affected > 0) {
            return json(['code' => 0, 'msg' => '修改成功']);
        }
        return json(['code' => 1, 'msg' => '修改失败']);
    }

    /**
     * 获取素材库列表接口（分页+搜索）
     * 参数：page(页码，从1开始), pageSize(每页条数，默认100，建议上限500)
     * 搜索：对 material_name、category_name 模糊匹配
     */
    public function Material_List(){
        $params = $this->request->param();
        $page = max(1, intval($params['page'] ?? 1));
        $pageSize = min(500, max(1, intval($params['pageSize'] ?? 100)));

        $where = [];
        if (!empty($params['search'])) {
            // 使用更安全的查询方式，material_name 与 category_name 任一匹配即可
            $search = trim($params['search']);
            $where['a.material_name|b.category_name'] = ['like', '%' . $search . '%'];
        }
        if (!empty($params['Category_id'])) {
            $where['a.Category_id'] = ['like', '%' . $params['Category_id'] . '%'];
        }

        $query = Db::name('template_material')->alias('a')
            ->field('a.id,a.sys_id,a.Category_id,b.category_name,a.material_name,a.material_url')
            ->join('template_material_category b', 'a.Category_id = b.id AND b.mod_rq IS NULL', 'LEFT')
            ->where($where)
            ->whereNull('a.mod_rq')
            ->order('a.id desc');

        $total = (clone $query)->count();
        $data = $query->page($page, $pageSize)->select();

        return json([
            'code'  => 0,
            'msg'   => '',
            'data'  => $data,
            'total' => $total,
            'count' => count($data)
        ]);
    }

    /**
     * 模板关联素材查询
     */
    public function Template_Material_Relation(){
        $params = $this->request->param();
        $res = Db::name('template_material_relation')->alias('a')
            ->field('a.*, b.material_url,c.canvasWidth,c.canvasHeight,c.size')
            ->join('template_material b', 'a.material_id = b.id', 'left')
            ->join('product_template c', 'a.template_id = c.id', 'left')
            ->where('a.template_id',$params['id'])->select();

        // 处理null值，转换为空字符串
        if($res){
            foreach($res as &$item){
                foreach($item as $key => &$value){
                    if($value === null){
                        $value = '';
                    }
                }
            }
            return json([
                'code' => 0,
                'msg'  => '',
                'data' => $res,
                'count' => count($res)
            ]);
        }else{
            return json([
                'code' => 1,
                'msg'  => '此模版作品暂无素材图',
                'data' => '',
                'count' => 0
            ]);
        }
    }

    /**
     * 新增模版（生成模版）
     */
    public function Template_Material_Add(){
        $params = $this->request->param();
//        echo "<pre>";
//        print_r($params);
//        echo "<pre>";die;
        // 处理 uploaded_materials：保存素材图片到 uploads/material/ 并写入 template_material 表
        $layerIdToMaterial = []; // layer_id => ['id'=>material_id, 'url'=>material_url]
        if (!empty($params['uploaded_materials'])) {
            $materialSavePath = str_replace('\\', '/', ROOT_PATH . 'public/uploads/material/' . date('Y-m-d') . '/');
            if (!is_dir($materialSavePath)) {
                mkdir($materialSavePath, 0755, true);
            }
            foreach ($params['uploaded_materials'] as $item) {
                $base64Data = $item['data'] ?? '';
                if (empty($base64Data) || !preg_match('/data:image\/(png|jpg|jpeg);base64,([A-Za-z0-9+\/=]+)/i', $base64Data, $m)) {
                    continue;
                }
                $imageType = strtolower($m[1]);
                $imageData = base64_decode($m[2]);
                if ($imageData === false || strlen($imageData) < 100) {
                    continue;
                }
                $ext = ($imageType === 'jpeg') ? 'jpg' : $imageType;
                $fileName = uniqid() . '_' . date('YmdHis') . '.' . $ext;
                $fullPath = $materialSavePath . $fileName;
                if (!file_put_contents($fullPath, $imageData)) {
                    continue;
                }
                $materialUrl = 'uploads/material/' . date('Y-m-d') . '/' . $fileName;
                $materialRecord = [
                    'sys_id' => $params['sys_id'] ?? '',
                    'material_url' => $materialUrl,
                    'type' => $item['type'] ?? '',
                    'create_time' => date('Y-m-d H:i:s'),
                    'count' => 1
                ];
                $materialId = Db::name('template_material')->insertGetId($materialRecord);
                if ($materialId && isset($item['layer_id'])) {
                    $layerIdToMaterial[$item['layer_id']] = ['id' => $materialId, 'url' => $materialUrl];
                }
            }
        }

        $save_path = ROOT_PATH . 'public' . '/' . 'uploads' . '/' . 'template' .'/'. date('Y-m-d')  . '/';
        // 移除ROOT_PATH中可能存在的反斜杠，确保统一使用正斜杠
        $save_path = str_replace('\\', '/', $save_path);
        // 自动创建文件夹（如果不存在）
        if (!is_dir($save_path)) {
            mkdir($save_path, 0755, true);
        }

        // 提取base64图片数据
        $previewImage = $params['previewImage'];
        // 匹配base64图片数据
        preg_match('/data:image\/(png|jpg|jpeg);base64,([^"]+)/', $previewImage, $matches);
        if (empty($matches)) {
            return '未找到图片数据';
        }
        $image_type = $matches[1];
        $base64_data = $matches[2];
        // 解码base64数据
        $image_data = base64_decode($base64_data);
        if ($image_data === false) {
            return '图片解码失败';
        }
        // 生成唯一文件名（包含正确的扩展名）
        $file_name = uniqid() . '_' . date('YmdHis') . '.' . $image_type;
        $full_file_path = $save_path . $file_name;

//         保存图片到文件系统
        if (!file_put_contents($full_file_path, $image_data)) {
            return '图片保存失败';
        }
        // 生成数据库存储路径（使用正斜杠格式）
        $db_img_path = '/uploads/template/'. date('Y-m-d')  .'/' . $file_name;

        // 生成缩略图
        $thumbnail_path = $this->generateThumbnail($full_file_path, $save_path, $file_name);
        $db_thumbnail_path = '/uploads/template/'.date('Y-m-d')  .'/' . $thumbnail_path;

        //新增到模版表（product_template）
        $record['toexamine'] = '审核通过';

        $record['sys_id'] = $params['sys_id'];
        $record['canvasWidth'] = $params['canvasWidth'];
        $record['canvasHeight'] = $params['canvasHeight'];
        $record['size'] = $params['canvasRatio'];
        $record['template_image_url'] = $db_img_path;//原图
        $record['thumbnail_image'] = $db_thumbnail_path;//缩略图

        $record['sys_rq'] = date('Y-m-d');
        $record['create_time'] = date('Y-m-d H:i:s');

        // 插入模板记录并获取ID
        $templateId = Db::name('product_template')->insertGetId($record);

        if (!$templateId) {
            // 如果数据库插入失败，删除已保存的图片
            if (file_exists($full_file_path)) {
                unlink($full_file_path);
            }
            return '数据库插入失败';
        }

        // 处理layers数据，插入到模版-素材表（template_material_relation）
        if (!empty($params['layers'])) {
            $layers = $params['layers'];
            foreach ($layers as $layer) {
                $materialId = $layer['material_id'] ?? null;
                $materialUrl = isset($layer['url']) ? $layer['url'] : '';
                if (isset($layer['id']) && isset($layerIdToMaterial[$layer['id']])) {
                    $materialId = $layerIdToMaterial[$layer['id']]['id'];
                    $materialUrl = $layerIdToMaterial[$layer['id']]['url'];
                }
                $relationData = [
                    'template_id' => $templateId,//模版ID
                    'sys_id' => $params['sys_id'],//用户名
                    'material_id' => $materialId,//素材ID
                    'z_index' => $layer['id'],//层级
                    'layer_name' => $layer['name'],//图层名称
                    'layer_type' => $layer['type'],//类型
                    'material_url' => $materialUrl,//素材图片
                    'position_x' => $layer['x'],
                    'position_y' => $layer['y'],
                    'width' => $layer['width'],
                    'height' => $layer['height'],
                    'rotation' => $layer['rotation'],//素材旋转角度
                    'opacity' => $layer['opacity'],//素材透明度
                    'visible' => $layer['visible'],//图层是否显示
                    'locked' => isset($layer['locked']) && $layer['locked'] ? 1 : 0,//图层是否锁住
                    //文字部分参数
                    'text_content' => isset($layer['text']) ? $layer['text'] : '',//文字内容
                    'font_family' => isset($layer['fontFamily']) ? $layer['fontFamily'] : '',//字体（如 Arial）
                    'font_size' => isset($layer['fontSize']) ? $layer['fontSize'] : '',//字号大小
                    'font_color' => isset($layer['color']) ? $layer['color'] : '',//文字颜色
                    'background_border_radius' => isset($layer['background_border_radius']) ? $layer['background_border_radius'] : '',//背景圆角
                    'background_color' => isset($layer['backgroundColor']) ? $layer['backgroundColor'] : '',//文字背景颜色
                    'text_align' => isset($layer['textAlign']) ? $layer['textAlign'] : '',//对齐方式
                    'font_weight' => isset($layer['fontWeight']) ? $layer['fontWeight'] : '',//加粗
                    'font_style' => isset($layer['fontStyle']) ? $layer['fontStyle'] : '',//斜体
                    'font_underline' => isset($layer['textDecoration']) ? $layer['textDecoration'] : '',//下划线
                    'line_height' => isset($layer['lineHeight']) ? $layer['lineHeight'] : '',//行高
                    'letter_spacing' => isset($layer['letterSpacing']) ? $layer['letterSpacing'] : '',//字距
                    //形状与线条
                    'shape_type' => $layer['shape_type'] ?? $layer['shapeType'] ?? '',//形状类型 rect/circle/ellipse/line
                    'fill_mode' => $layer['fill_mode'] ?? $layer['fillMode'] ?? '',//填充模式 solid/none
                    'fill_color' => $layer['fill_color'] ?? $layer['fillColor'] ?? '',//填充色
                    'stroke_color' => $layer['stroke_color'] ?? $layer['strokeColor'] ?? '',//描边色
                    'page_index' => $layer['page_index'] ?? $layer['page_index'] ?? '',//画布分页排序
                    'stroke_width' => isset($layer['stroke_width']) ? floatval($layer['stroke_width']) : (isset($layer['strokeWidth']) ? floatval($layer['strokeWidth']) : 0),//描边宽度
                    'create_time' => date('Y-m-d H:i:s')


                ];
                // 插入关联记录
                Db::name('template_material_relation')->insert($relationData);
            }
        }
        return json([
            'code' => 0,
            'msg'  => '',
            'data' => '',
            'template_id' => $templateId,
            'template_image_url' => $db_img_path,
            'template_image' => $db_thumbnail_path
        ]);
    }

    /**
     * 修改模版
     */
    public function Template_Material_Update(){
        $params = $this->request->param();
//        echo "<pre>";
//        print_r($params);
//        echo "<pre>";die;
        // 验证模板ID
        if (empty($params['template_id'])) {
            return json([
                'code' => 1,
                'msg'  => '模板ID不能为空',
                'data' => ''
            ]);
        }

        $templateId = $params['template_id'];

        // 检查模板是否存在
        $template = Db::name('product_template')->where('id', $templateId)->find();
        if (!$template) {
            return json([
                'code' => 1,
                'msg'  => '模板不存在',
                'data' => ''
            ]);
        }

        // 处理 uploaded_materials：修改时会有新的素材图上传，保存到 uploads/material/ 并写入 template_material 表（参考新增模版）
        $layerIdToMaterial = [];
        if (!empty($params['uploaded_materials'])) {
            $materialSavePath = str_replace('\\', '/', ROOT_PATH . 'public/uploads/material/' . date('Y-m-d') . '/');
            if (!is_dir($materialSavePath)) {
                mkdir($materialSavePath, 0755, true);
            }
            foreach ($params['uploaded_materials'] as $item) {
                $base64Data = $item['data'] ?? '';
                if (empty($base64Data) || !preg_match('/data:image\/(png|jpg|jpeg);base64,([A-Za-z0-9+\/=]+)/i', $base64Data, $m)) {
                    continue;
                }
                $imageType = strtolower($m[1]);
                $imageData = base64_decode($m[2]);
                if ($imageData === false || strlen($imageData) < 100) {
                    continue;
                }
                $ext = ($imageType === 'jpeg') ? 'jpg' : $imageType;
                $fileName = uniqid() . '_' . date('YmdHis') . '.' . $ext;
                $fullPath = $materialSavePath . $fileName;
                if (!file_put_contents($fullPath, $imageData)) {
                    continue;
                }
                $materialUrl = 'uploads/material/' . date('Y-m-d') . '/' . $fileName;
                $materialRecord = [
                    'sys_id' => $params['sys_id'] ?? '',
                    'material_url' => $materialUrl,
                    'type' => $item['type'] ?? '',
                    'create_time' => date('Y-m-d H:i:s'),
                    'count' => 1
                ];
                $materialId = Db::name('template_material')->insertGetId($materialRecord);
                if ($materialId && isset($item['layer_id'])) {
                    $layerIdToMaterial[$item['layer_id']] = ['id' => $materialId, 'url' => $materialUrl];
                }
            }
        }

        // 处理图片更新
        $db_img_path = $template['template_image_url'];
        $db_thumbnail_path = $template['thumbnail_image'];

        if (!empty($params['previewImage'])) {
            $save_path = ROOT_PATH . 'public' . '/' . 'uploads' . '/' . 'template' .'/'. date('Y-m-d')  . '/';
            // 移除ROOT_PATH中可能存在的反斜杠，确保统一使用正斜杠
            $save_path = str_replace('\\', '/', $save_path);
            // 自动创建文件夹（如果不存在）
            if (!is_dir($save_path)) {
                mkdir($save_path, 0755, true);
            }

            // 提取base64图片数据
            $previewImage = $params['previewImage'];
            // 匹配base64图片数据
            preg_match('/data:image\/(png|jpg|jpeg);base64,([^"]+)/', $previewImage, $matches);
            if (empty($matches)) {
                return json([
                    'code' => 1,
                    'msg'  => '未找到图片数据',
                    'data' => ''
                ]);
            }
            $image_type = $matches[1];
            $base64_data = $matches[2];
            // 解码base64数据
            $image_data = base64_decode($base64_data);
            if ($image_data === false) {
                return json([
                    'code' => 1,
                    'msg'  => '图片解码失败',
                    'data' => ''
                ]);
            }
            // 生成唯一文件名（包含正确的扩展名）
            $file_name = uniqid() . '_' . date('YmdHis') . '.' . $image_type;
            $full_file_path = $save_path . $file_name;

            // 保存图片到文件系统
            if (!file_put_contents($full_file_path, $image_data)) {
                return json([
                    'code' => 1,
                    'msg'  => '图片保存失败',
                    'data' => ''
                ]);
            }
            // 生成数据库存储路径（使用正斜杠格式）
            $db_img_path = '/uploads/template/'. date('Y-m-d')  .'/' . $file_name;

            // 生成缩略图
            $thumbnail_path = $this->generateThumbnail($full_file_path, $save_path, $file_name);
            $db_thumbnail_path = '/uploads/template/'.date('Y-m-d')  .'/' . $thumbnail_path;

            // 删除旧图片
            if (!empty($template['template_image_url'])) {
                $oldImagePath = ROOT_PATH . 'public' . $template['template_image_url'];
                if (file_exists($oldImagePath)) {
                    unlink($oldImagePath);
                }
            }
            if (!empty($template['thumbnail_image'])) {
                $oldThumbnailPath = ROOT_PATH . 'public' . $template['thumbnail_image'];
                if (file_exists($oldThumbnailPath)) {
                    unlink($oldThumbnailPath);
                }
            }
        }

        // 更新模版表（product_template）
        $record['canvasWidth'] = $params['canvasWidth'];
        $record['canvasHeight'] = $params['canvasHeight'];
        $record['size'] = $params['canvasRatio'];
        if (!empty($db_img_path)) {
            $record['template_image_url'] = $db_img_path;//原图
            $record['thumbnail_image'] = $db_thumbnail_path;//缩略图
        }

        $record['sys_rq'] = date('Y-m-d');
        $record['template_name'] = $params['template_name'];
        $record['update_time'] = date('Y-m-d H:i:s');

        // 更新模板记录
        $res = Db::name('product_template')->where('id', $templateId)->update($record);

        if (!$res) {
            return json([
                'code' => 1,
                'msg'  => '数据库更新失败',
                'data' => ''
            ]);
        }

        // 处理layers数据，更新模版-素材表（template_material_relation）
        if (!empty($params['layers'])) {
            // 删除旧的关联记录
            Db::name('template_material_relation')->where('template_id', $templateId)->delete();

            $layers = $params['layers'];
            foreach ($layers as $layer) {
                $materialId = $layer['material_id'] ?? null;
                $materialUrl = isset($layer['url']) ? $layer['url'] : '';
                if (isset($layer['id']) && isset($layerIdToMaterial[$layer['id']])) {
                    $materialId = $layerIdToMaterial[$layer['id']]['id'];
                    $materialUrl = $layerIdToMaterial[$layer['id']]['url'];
                }
                $relationData = [
                    'template_id' => $templateId,//模版ID
                    'sys_id' => $params['sys_id'] ?? '',//用户名
                    'material_id' => $materialId,//素材ID
                    'z_index' => $layer['id'],//层级
                    'layer_name' => $layer['name'],//图层名称
                    'layer_type' => $layer['type'],//类型
                    'material_url' => $materialUrl,//素材图片
                    'position_x' => $layer['x'],
                    'position_y' => $layer['y'],
                    'width' => $layer['width'],
                    'height' => $layer['height'],
                    'rotation' => $layer['rotation'],//素材旋转角度
                    'opacity' => $layer['opacity'],//素材透明度
                    'visible' => $layer['visible'],//图层是否显示
                    'locked' => isset($layer['locked']) && $layer['locked'] ? 1 : 0,//图层是否锁住
                    //文字部分参数
                    'text_content' => isset($layer['text']) ? $layer['text'] : '',//文字内容
                    'font_family' => isset($layer['fontFamily']) ? $layer['fontFamily'] : '',//字体（如 Arial）
                    'font_size' => isset($layer['fontSize']) ? $layer['fontSize'] : '',//字号大小
                    'font_color' => isset($layer['color']) ? $layer['color'] : '',//文字颜色
                    'background_color' => isset($layer['backgroundColor']) ? $layer['backgroundColor'] : '',//文字背景颜色
                    'background_border_radius' => isset($layer['background_border_radius']) ? $layer['background_border_radius'] : '',//背景圆角
                    'text_align' => isset($layer['textAlign']) ? $layer['textAlign'] : '',//对齐方式
                    'font_weight' => isset($layer['fontWeight']) ? $layer['fontWeight'] : '',//加粗
                    'font_style' => isset($layer['fontStyle']) ? $layer['fontStyle'] : '',//斜体
                    'font_underline' => isset($layer['textDecoration']) ? $layer['textDecoration'] : '',//下划线
                    'line_height' => isset($layer['lineHeight']) ? $layer['lineHeight'] : '',//行高
                    'letter_spacing' => isset($layer['letterSpacing']) ? $layer['letterSpacing'] : '',//字距
                    //形状与线条
                    'shape_type' => $layer['shape_type'] ?? $layer['shapeType'] ?? '',//形状类型 rect/circle/ellipse/line
                    'fill_mode' => $layer['fill_mode'] ?? $layer['fillMode'] ?? '',//填充模式 solid/none
                    'fill_color' => $layer['fill_color'] ?? $layer['fillColor'] ?? '',//填充色
                    'stroke_color' => $layer['stroke_color'] ?? $layer['strokeColor'] ?? '',//描边色
                    'page_index' => $layer['page_index'] ?? $layer['page_index'] ?? '',//画布分页排序
                    'stroke_width' => isset($layer['stroke_width']) ? floatval($layer['stroke_width']) : (isset($layer['strokeWidth']) ? floatval($layer['strokeWidth']) : 0),//描边宽度
                    'create_time' => date('Y-m-d H:i:s')

                ];
                // 插入关联记录
                Db::name('template_material_relation')->insert($relationData);
            }
        }
        return json([
            'code' => 0,
            'msg'  => '修改成功',
            'data' => '',
            'template_id' => $templateId,
            'template_image_url' => $db_img_path,
            'template_image' => $db_thumbnail_path
        ]);
    }

    /**
     * 生成缩略图（高质量）
     * @param string $originalPath 原图路径
     * @param string $savePath 保存目录
     * @param string $fileName 原文件名
     * @return string 缩略图文件名
     */
    private function generateThumbnail($originalPath, $savePath, $fileName) {
        // 获取图片信息
        $imageInfo = getimagesize($originalPath);
        if (!$imageInfo) {
            return '';
        }

        $width = $imageInfo[0];
        $height = $imageInfo[1];

        // 计算缩略图尺寸（保持比例，最大宽度400）
        $maxWidth = 400;
        $maxHeight = 400;

        if ($width > $maxWidth || $height > $maxHeight) {
            $ratio = min($maxWidth / $width, $maxHeight / $height);
            $thumbWidth = round($width * $ratio);
            $thumbHeight = round($height * $ratio);
        } else {
            $thumbWidth = $width;
            $thumbHeight = $height;
        }

        // 创建缩略图画布
        $thumbnail = imagecreatetruecolor($thumbWidth, $thumbHeight);

        // 根据图片类型创建图像资源
        switch ($imageInfo[2]) {
            case IMAGETYPE_JPEG:
                $source = imagecreatefromjpeg($originalPath);
                break;
            case IMAGETYPE_PNG:
                $source = imagecreatefrompng($originalPath);
                // 处理PNG透明
                imagealphablending($thumbnail, false);
                imagesavealpha($thumbnail, true);
                $transparent = imagecolorallocatealpha($thumbnail, 255, 255, 255, 127);
                imagefilledrectangle($thumbnail, 0, 0, $thumbWidth, $thumbHeight, $transparent);
                break;
            case IMAGETYPE_GIF:
                $source = imagecreatefromgif($originalPath);
                break;
            default:
                return '';
        }

        if (!$source) {
            return '';
        }

        // 调整图片大小（使用高质量缩放）
        imagecopyresampled($thumbnail, $source, 0, 0, 0, 0, $thumbWidth, $thumbHeight, $width, $height);

        // 生成缩略图文件名
        $pathInfo = pathinfo($fileName);
        $thumbnailName = $pathInfo['filename'] . '_thumb.' . $pathInfo['extension'];
        $thumbnailPath = $savePath . $thumbnailName;

        // 保存缩略图（使用高质量设置）
        switch ($imageInfo[2]) {
            case IMAGETYPE_JPEG:
                imagejpeg($thumbnail, $thumbnailPath, 95); // 95% 质量，接近原图
                break;
            case IMAGETYPE_PNG:
                imagepng($thumbnail, $thumbnailPath, 3); // 压缩级别 3，保持较高质量
                break;
            case IMAGETYPE_GIF:
                imagegif($thumbnail, $thumbnailPath);
                break;
        }

        // 释放资源
        imagedestroy($source);
        imagedestroy($thumbnail);

        return $thumbnailName;
    }

    /**
     * 发布模版（release=1）
     */
    public function Template_Material_Publish(){
        $params = $this->request->param();

        $record['release'] = 1;
        $record['update_time'] = date('Y-m-d H:i:s');
        $res = Db::name('product_template')->where('id', $params['template_id'])->update($record);
        if (!$res) {
            return json([
                'code' => 1,
                'msg'  => '发布失败',
                'data' => ''
            ]);
        }
        return json([
            'code' => 0,
            'msg'  => '发布成功'
        ]);
    }

    /**
     * 取消发布模版（release=0）
     */
    public function Template_Material_Unpublish(){
        $params = $this->request->param();
        $record['release'] = 0;
        $record['update_time'] = date('Y-m-d H:i:s');
        $res = Db::name('product_template')->where('id', $params['template_id'])->update($record);
        if (!$res) {
            return json([
                'code' => 1,
                'msg'  => '发布失败',
                'data' => ''
            ]);
        }
        return json([
            'code' => 0,
            'msg'  => '发布成功'
        ]);
    }

    /**
     * 删除模版
     */
    public function Template_Material_Delete(){
        $params = $this->request->param();
        $record['mod_rq'] = date('Y-m-d H:i:s');
        $res = Db::name('product_template')->where('id', $params['template_id'])->update($record);
        if (!$res) {
            return json([
                'code' => 1,
                'msg'  => '模版删除失败',
                'data' => ''
            ]);
        }
        return json([
            'code' => 0,
            'msg'  => '模版删除成功'
        ]);
    }

    /**
     * 素材分类查询（一级+二级树形结构，供前端展示）
     */
    public function Material_Category_List()
    {
        $all = Db::name('template_material_category')
            ->field('id,category_name,parent_id,sort')
            ->where('status', 1)
            ->whereNull('mod_rq')
            ->order('sort', 'asc')
            ->select();

        // 分离一级(parent_id=0)和二级
        $level1 = [];
        $level2ByParent = [];
        foreach ($all as $row) {
            if ($row['parent_id'] == 0) {
                $row['children'] = [];
                $level1[] = $row;
            } else {
                $pid = $row['parent_id'];
                if (!isset($level2ByParent[$pid])) {
                    $level2ByParent[$pid] = [];
                }
                $level2ByParent[$pid][] = $row;
            }
        }

        // 按 sort 排序一级，并把二级挂到对应一级下
        usort($level1, function ($a, $b) {
            return (int)($a['sort'] ?? 0) - (int)($b['sort'] ?? 0);
        });
        foreach ($level1 as &$item) {
            $item['children'] = $level2ByParent[$item['id']] ?? [];
            usort($item['children'], function ($a, $b) {
                return (int)($a['sort'] ?? 0) - (int)($b['sort'] ?? 0);
            });
        }

        return json(['code' => 0, 'msg' => '', 'data' => $level1]);
    }

    /**
     * 新增素材分类（支持一级、二级）
     * 一级：parent_id 不传或传 0
     * 二级：parent_id 传一级分类的 id
     * 参数：category_name(必填), parent_id(可选,默认0), sort(可选,默认0), status(可选,默认1)
     */
    public function Material_Category_Add()
    {
        $params = $this->request->param();
        if (empty(trim($params['category_name'] ?? ''))) {
            return json(['code' => 1, 'msg' => '分类名称不能为空']);
        }

        $parentId = isset($params['parent_id']) ? intval($params['parent_id']) : 0;

        // 二级分类：校验父分类存在且未软删除
        if ($parentId > 0) {
            $parent = Db::name('template_material_category')
                ->where('id', $parentId)
                ->where('parent_id', 0)
                ->whereNull('mod_rq')
                ->find();
            if (!$parent) {
                return json(['code' => 1, 'msg' => '父分类不存在或已删除']);
            }
        }

        $data = [
            'category_name' => trim($params['category_name']),
            'parent_id' => $parentId,
            'sort' => $params['sort'] ?? 0,
            'status' => $params['status'] ?? '1',
            'createtime' => date('Y-m-d H:i:s')
        ];

        $id = Db::name('template_material_category')->insertGetId($data);
        if ($id) {
            return json(['code' => 0, 'msg' => '新增成功', 'data' => ['id' => $id]]);
        }
        return json(['code' => 1, 'msg' => '新增失败']);
    }

    /**
     * 修改素材分类
     * 参数：id(必填), category_name/sort/status/parent_id(可选)
     */
    public function Material_Category_Update()
    {
        $params = $this->request->param();
        if (empty($params['id']) || !is_numeric($params['id'])) {
            return json(['code' => 1, 'msg' => '参数错误']);
        }

        $data = ['updatetime' => date('Y-m-d H:i:s')];
        if (isset($params['category_name']) && trim($params['category_name']) !== '') {
            $data['category_name'] = trim($params['category_name']);
        }
        if (isset($params['parent_id'])) {
            $data['parent_id'] = intval($params['parent_id']);
        }
        if (isset($params['sort'])) {
            $data['sort'] = $params['sort'];
        }
        if (isset($params['status'])) {
            $data['status'] = $params['status'];
        }

        $affected = Db::name('template_material_category')
            ->where('id', intval($params['id']))
            ->whereNull('mod_rq')
            ->update($data);

        if ($affected > 0) {
            return json(['code' => 0, 'msg' => '修改成功']);
        }
        return json(['code' => 1, 'msg' => '记录不存在或已删除']);
    }

    /**
     * 删除素材分类（软删除，设置 mod_rq）
     */
    public function Material_Category_Delete()
    {
        $params = $this->request->param();
        if (empty($params['id']) || !is_numeric($params['id'])) {
            return json(['code' => 1, 'msg' => '参数错误']);
        }

        $affected = Db::name('template_material_category')
            ->where('id', intval($params['id']))
            ->update(['mod_rq' => date('Y-m-d H:i:s')]);

        if ($affected > 0) {
            return json(['code' => 0, 'msg' => '删除成功']);
        }
        return json(['code' => 1, 'msg' => '记录不存在或已删除']);
    }
}