[Feature][SolidUI] Dev0.3.0 SolidUI Proposal

[dlimeng]

Background

This version's theme: The model agent supports multiple outputs, database selection, self-developed models, k8s support, and webpage optimization.
该版本主题：支持自研模型，模型代理支持多种输出，模型代理支持选择数据库，支持k8s，页面优化

Product Prototype：solidui0.3.0.zip

Motivation

To better support models and agents, facilitate deployment, and enhance user experience, the following features have been implemented：
为了更好的支持模型和代理，部署更加方便，增强用户体验：

• Support for self-developed models / 支持自研模型 [Feature][SolidUI-Model] visualization model implementation  #97
• Model agent output supports HTML / 模型代理输出支持html [Feature][SolidUI-ModelUI] Support text input box generate html #73 [Feature][SolidUI-Web] Support text input box generate html dynamic rendering #74
• Model agent input supports database selection / 模型代理输入支持选择数据库 [Feature][SolidUI-Web] Chat entry support select database #81 [Feature][SolidUI-ModelUI] Chat entry selection database #82
• k8s support / 支持k8s [Feature][Deploy] Support kubernetes deployment #115
• Support for webpage optimization / 支持页面优化 [Feature][SolidUI-Web] After login, the page displays the user name with rounded corners #128 [Feature][SolidUI-Web] The page shows missing favicon.ico #129 [Feature][SolidUI-Web] Right sliding window shrinks #133

Implementation

Business structure

Self-developed models / 自研模型

The server provides services
服务端提供服务

Model agent output supports HTML / 模型代理输出支持html

Go to scene -> page, select modelui, choose the output model in the bottom left corner
进入场景-> 页 ，选择modelui , 左下角选择输出模型（modelName + Code）

Model agent input supports database selection / 模型代理输入支持选择数据库

Go to scene -> page, select modelui, there is an icon pop-up window in the bottom right corner, choose the database id, library, table, after clicking the confirm button, append the table's json data in the prompt input box
进入场景-> 页 ，选择modelui , 右下角有个icon弹窗，选择数据库id、库、表，确认按钮后，在提示词输入框追加表的json数据

The specific implementation issues and prototypes mirror each other
具体实现issue和原型互相映照

Technology Architecture

architecture design

Self-developed model / 自研模型

According to the second reconstruction of the diffusion, the overall input adapts to the graphic framework
根据 diffusion 二次重构，整体输入适配图形框架

The model proxy output supports HTML / 模型代理输出支持html

• Add a code field in the database table solidui_model_type to represent the output type / 数据库表solidui_model_type 增加code字段表示输出类型

• Abstract the prompt template in the code to the solidui_model_type table / 把代码中提示词模板抽象到solidui_model_type表中

The model proxy input supports selecting the database / 模型代理输入支持选择数据库

The code already supports querying database id, database, and data table / 代码中已经支持查询数据库id，数据库，数据表

add a format conversion interface to query json format data according to datasourceid, dataname, tablename / 新增查询表json接口

Test plan

Re-validate the modelui chat window according to the prompt words in the 0.2.0 feature introduction.
按照0.2.0 功能介绍中提示词，重新验证modelui聊天窗口

Development Process

• 2023.8.21 - 2023.8.28 The server side implements model proxy output support for HTML, model proxy input supports database selection to add data conversion into JSON interface. / 服务端实现模型代理输出支持html ，模型代理输入支持选择数据库增加数据转换成json接口
• 2023.8.28 - 2023.9.4 Front-end joint debugging (the server side implements model proxy output support for HTML, model proxy input supports database selection to add data conversion into JSON interface) / 前端联调（服务端实现模型代理输出支持html ，模型代理输入支持选择数据库增加数据转换成json接口）
• 2023.9.4 - 2023.9.11 Front-end joint debugging / 前端联调
• 2023.9.11 - 2023.9.20 Front-end page optimization, server-side k8s / 前端页面优化，服务端k8s
• 2023.9.20 - 2023.10.6 Business testing / 业务测试
• 2023.10.7 - 2023.10.15 Deployment (packaging images, release), content operations / 部署（打包镜像，release），内容运营

Issue list

• [Feature][SolidUI-Model] visualization model implementation  #97
• [Feature][SolidUI-ModelUI] Support text input box generate html #73
• [Feature][SolidUI-Web] Support text input box generate html dynamic rendering #74
• [Feature][SolidUI-Web] Chat entry support select database #81
• [Feature][SolidUI-ModelUI] Chat entry selection database #82
• [Feature][Deploy] Support kubernetes deployment #115
• [Feature][SolidUI-Web] The page shows missing favicon.ico #129
• [Feature][SolidUI-Web] Right sliding window shrinks #133
• [Feature][SolidUI] Dev0.3.0 Business test List  #130
• [Feature][SolidUI] Dev0.3.0 Document writing  #131

[github-actions]

😊 Welcome to the SolidUI community!!
We are glad that you are contributing by opening this issue.

Please make sure to include all the relevant context.
We will be here shortly.

If you are interested in contributing to our project, please let us know!
You can check out our contributing guide on
👉 How to Contribute.

If you have any questions or suggestions, please feel free to post them here or contact us via email at mengyoupanshan@gmail.com.

We appreciate your interest in SolidUI and look forward to working with you!