cunkebao_v3/Server/application/superadmin/service/PromptTemplateService.php

<?php

namespace app\superadmin\service;

use think\Db;

/**
 * 私域银行全局提示词模板库（REQ-CKB-70 · PromptMergeService 第 7 层真源）
 *
 * 表 ck_ai_prompt_global_template（懒建）：
 *   id, name, content, isDefault, status, createTime, updateTime, deleteTime
 * 触客宝/官网通过 PromptMergeService::layerSuperAdminGlobal 只读取用。
 */
class PromptTemplateService
{
    private static $ensured = false;

    private static function ensureTable(): void
    {
        if (self::$ensured) {
            return;
        }
        Db::execute("CREATE TABLE IF NOT EXISTS `ck_ai_prompt_global_template` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `name` varchar(128) NOT NULL DEFAULT '',
            `content` text NULL,
            `isDefault` tinyint(1) NOT NULL DEFAULT 0,
            `status` tinyint(1) NOT NULL DEFAULT 1,
            `createTime` int(11) NOT NULL DEFAULT 0,
            `updateTime` int(11) NOT NULL DEFAULT 0,
            `deleteTime` int(11) NOT NULL DEFAULT 0,
            PRIMARY KEY (`id`),
            KEY `idx_default` (`isDefault`,`status`,`deleteTime`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
        self::$ensured = true;
    }

    public function list(): array
    {
        self::ensureTable();
        $rows = Db::name('ai_prompt_global_template')
            ->where('deleteTime', 0)
            ->order('isDefault DESC, id DESC')
            ->select();
        return array_map(function ($r) {
            $r['isDefault'] = (int)$r['isDefault'] === 1;
            $r['status'] = (int)$r['status'] === 1;
            return $r;
        }, $rows ?: []);
    }

    public function save(array $data): array
    {
        self::ensureTable();
        $id = (int)($data['id'] ?? 0);
        $name = trim((string)($data['name'] ?? ''));
        $content = (string)($data['content'] ?? '');
        $status = (int)($data['status'] ?? 1) === 1 ? 1 : 0;
        $isDefault = (int)($data['isDefault'] ?? 0) === 1 ? 1 : 0;
        if ($name === '') {
            throw new \Exception('模板名称不能为空', 400);
        }
        $now = time();

        Db::startTrans();
        try {
            if ($isDefault === 1) {
                // 同一时间仅一个默认
                Db::name('ai_prompt_global_template')->where('deleteTime', 0)->update(['isDefault' => 0]);
            }
            if ($id > 0) {
                Db::name('ai_prompt_global_template')->where('id', $id)->update([
                    'name' => $name,
                    'content' => $content,
                    'status' => $status,
                    'isDefault' => $isDefault,
                    'updateTime' => $now,
                ]);
            } else {
                $id = Db::name('ai_prompt_global_template')->insertGetId([
                    'name' => $name,
                    'content' => $content,
                    'status' => $status,
                    'isDefault' => $isDefault,
                    'createTime' => $now,
                    'updateTime' => $now,
                    'deleteTime' => 0,
                ]);
            }
            Db::commit();
        } catch (\Throwable $e) {
            Db::rollback();
            throw $e;
        }
        return ['id' => $id];
    }

    public function delete(int $id): void
    {
        self::ensureTable();
        if ($id <= 0) {
            throw new \Exception('id 缺失', 400);
        }
        Db::name('ai_prompt_global_template')->where('id', $id)->update([
            'deleteTime' => time(),
        ]);
    }

    public function setDefault(int $id): void
    {
        self::ensureTable();
        if ($id <= 0) {
            throw new \Exception('id 缺失', 400);
        }
        Db::startTrans();
        try {
            Db::name('ai_prompt_global_template')->where('deleteTime', 0)->update(['isDefault' => 0]);
            Db::name('ai_prompt_global_template')->where('id', $id)->update([
                'isDefault' => 1,
                'status' => 1,
                'updateTime' => time(),
            ]);
            Db::commit();
        } catch (\Throwable $e) {
            Db::rollback();
            throw $e;
        }
    }
}