phpcms 新建模型

// 假设我们使用的是ThinkPHP框架
namespace app\admin\controller;

use think\Controller;
use think\Request;

class ModelController extends Controller
{
    public function createModel(Request $request)
    {
        if ($request->isPost()) {
            $data = $request->post();
            $modelName = $data['model_name'];
            $modelAlias = $data['model_alias'];
            $modelDesc = $data['model_desc'];
            $tablePrefix = $data['table_prefix'];

            // 创建模型表
            $tableName = $tablePrefix . '_' . $modelAlias;
            $sql = "CREATE TABLE IF NOT EXISTS `$tableName` (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
            db()->execute($sql);

            // 保存模型信息到数据库
            $modelInfo = [
                'model_name' => $modelName,
                'model_alias' => $modelAlias,
                'model_desc' => $modelDesc,
                'table_prefix' => $tablePrefix,
                'create_time' => time(),
            ];
            db('model')->insert($modelInfo);

            return json(['code' => 1, 'msg' => '模型创建成功']);
        } else {
            return $this->fetch();
        }
    }
}