feat(ai): 新增AI产品提示词管理功能

Administrator

15 hours ago dd7539e288c02ff69af187fa0a90e5b033bc4fad

feat(ai): 新增AI产品提示词管理功能

- 创建AiProductPrompt实体类和相关数据库映射
- 实现AI产品提示词的增删改查完整业务逻辑
- 开发前端列表页面支持提示词模板展示和操作
- 构建新增和编辑表单界面提供完整的用户交互
- 集成权限控制确保数据安全访问机制
- 添加服务层接口和实现类完成后端数据处理

 src/main/java/cc/mrbird/febs/ai/controller/prompt/AiProductPromptController.java

New file
@@ -0,0 +1,53 @@
package cc.mrbird.febs.ai.controller.prompt;

import cc.mrbird.febs.ai.entity.AiCompany;
import cc.mrbird.febs.ai.entity.AiProductPrompt;
import cc.mrbird.febs.ai.service.AiCompanyService;
import cc.mrbird.febs.ai.service.AiProductPromptService;
import cc.mrbird.febs.common.annotation.ControllerEndpoint;
import cc.mrbird.febs.common.controller.BaseController;
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.validation.Valid;
import java.util.Map;

/**
 * @author Administrator
 */
@Slf4j
@Validated
@RestController
@RequiredArgsConstructor
@RequestMapping(value = "/admin/aiProductPrompt")
public class AiProductPromptController extends BaseController {

    private final AiProductPromptService aiProductPromptService;

    @GetMapping("list")
    public FebsResponse list(AiProductPrompt dto, QueryRequest request) {
        String companyId = getCurrentUserCompanyId();
        dto.setCompanyId(companyId);
        Map<String, Object> data = getDataTable(aiProductPromptService.listInPage(dto, request));
        return new FebsResponse().success().data(data);
    }

    @PostMapping("add")
    @ControllerEndpoint(operation = "新增", exceptionMessage = "操作失败")
    public FebsResponse add(@RequestBody @Valid AiProductPrompt dto) {
        String companyId = getCurrentUserCompanyId();
        dto.setCompanyId(companyId);
        return aiProductPromptService.add(dto);
    }

    @PostMapping("update")
    @ControllerEndpoint(operation = "更新", exceptionMessage = "操作失败")
    public FebsResponse update(@RequestBody @Valid AiProductPrompt dto) {

        return aiProductPromptService.update(dto);
    }
}

 src/main/java/cc/mrbird/febs/ai/controller/prompt/ViewController.java

New file
@@ -0,0 +1,49 @@
package cc.mrbird.febs.ai.controller.prompt;

import cc.mrbird.febs.ai.entity.AiCompany;
import cc.mrbird.febs.ai.entity.AiProductPrompt;
import cc.mrbird.febs.ai.service.AiCompanyService;
import cc.mrbird.febs.ai.service.AiProductPromptService;
import cc.mrbird.febs.common.entity.FebsConstant;
import cc.mrbird.febs.common.utils.FebsUtil;
import lombok.RequiredArgsConstructor;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * @author Administrator
 */
@Controller("aiProductPrompt")
@RequestMapping(FebsConstant.VIEW_PREFIX + "modules/ai/aiProductPrompt")
@RequiredArgsConstructor
public class ViewController {

    private final AiProductPromptService aiProductPromptService;

    @GetMapping("list")
    @RequiresPermissions("productPromptList:view")
    public String list() {

        return FebsUtil.view("modules/ai/aiProductPrompt/list");
    }

    @GetMapping(value = "/add")
    @RequiresPermissions("productPromptList:add")
    public String add() {

        return FebsUtil.view("modules/ai/aiProductPrompt/add");
    }

    @GetMapping("info/{id}")
    @RequiresPermissions("productPromptList:info")
    public String info(@PathVariable String id, Model model) {
        AiProductPrompt aiProductPrompt = aiProductPromptService.getById(id);
        model.addAttribute("aiProductPrompt", aiProductPrompt);
        return FebsUtil.view("modules/ai/aiProductPrompt/info");
    }

}

 src/main/java/cc/mrbird/febs/ai/entity/AiProductPrompt.java

New file
@@ -0,0 +1,17 @@
package cc.mrbird.febs.ai.entity;

import cc.mrbird.febs.common.entity.AiBaseEntity;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName("ai_product_prompt")
public class AiProductPrompt extends AiBaseEntity {

    /**
     * 公司名称
     */
    private String name;
    private String code;
    private String companyId;
}

 src/main/java/cc/mrbird/febs/ai/mapper/AiProductPromptMapper.java

New file
@@ -0,0 +1,7 @@
package cc.mrbird.febs.ai.mapper;

import cc.mrbird.febs.ai.entity.AiProductPrompt;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

public interface AiProductPromptMapper extends BaseMapper<AiProductPrompt> {
}

 src/main/java/cc/mrbird/febs/ai/service/AiProductPromptService.java

New file
@@ -0,0 +1,17 @@
package cc.mrbird.febs.ai.service;

import cc.mrbird.febs.ai.entity.AiProductPrompt;
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.IService;

public interface AiProductPromptService extends IService<AiProductPrompt> {
    AiProductPrompt getById(String id);

    IPage<AiProductPrompt> listInPage(AiProductPrompt dto, QueryRequest request);

    FebsResponse add(AiProductPrompt dto);

    FebsResponse update(AiProductPrompt dto);
}

 src/main/java/cc/mrbird/febs/ai/service/impl/AiProductPromptServiceImpl.java

New file
@@ -0,0 +1,73 @@
package cc.mrbird.febs.ai.service.impl;

import cc.mrbird.febs.ai.entity.AiCompany;
import cc.mrbird.febs.ai.entity.AiMemberRole;
import cc.mrbird.febs.ai.entity.AiProductPrompt;
import cc.mrbird.febs.ai.mapper.AiProductPromptMapper;
import cc.mrbird.febs.ai.service.AiProductPromptService;
import cc.mrbird.febs.ai.util.UUID;
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
import cc.mrbird.febs.common.utils.ShareCodeUtil;
import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import java.util.Date;

@Slf4j
@Service
@RequiredArgsConstructor
public class AiProductPromptServiceImpl extends ServiceImpl<AiProductPromptMapper, AiProductPrompt> implements AiProductPromptService {

    private final AiProductPromptMapper aiProductPromptMapper;
    @Override
    public AiProductPrompt getById(String id) {
        return aiProductPromptMapper.selectById( id);
    }

    @Override
    public IPage<AiProductPrompt> listInPage(AiProductPrompt dto, QueryRequest request) {
        Page<AiProductPrompt> page = new Page<>(request.getPageNum(), request.getPageSize());
        LambdaQueryWrapper<AiProductPrompt> query = Wrappers.lambdaQuery(AiProductPrompt.class);
        query.eq(AiProductPrompt::getCompanyId, dto.getCompanyId());
        query.orderByDesc(AiProductPrompt::getCreatedTime);
        Page<AiProductPrompt> pages = aiProductPromptMapper.selectPage(page, query);
        return pages;
    }

    @Override
    public FebsResponse add(AiProductPrompt dto) {
        Date createTime = new Date();
        AiProductPrompt entity = new AiProductPrompt();
        entity.setId(UUID.getSimpleUUIDString());
        entity.setName(dto.getName());
        entity.setCode(ShareCodeUtil.toSerialCode(1L));
        entity.setCompanyId(dto.getCompanyId());
        entity.setCreatedTime(createTime);
        aiProductPromptMapper.insert( entity);
        return new FebsResponse().success().message("操作成功");
    }

    @Override
    public FebsResponse update(AiProductPrompt dto) {
        String id = dto.getId();
        AiProductPrompt entity = this.getById(id);
        if(ObjectUtil.isNotNull( entity)){
            this.update(null,
                    Wrappers.lambdaUpdate(AiProductPrompt.class)
                            .set(AiProductPrompt::getCode, dto.getCode())
                            .set(AiProductPrompt::getName, dto.getName())
                            .set(AiProductPrompt::getUpdatedTime, new Date())
                            .eq(AiProductPrompt::getId, id));

        }
        return new FebsResponse().success().message("操作成功");
    }
}

 src/main/resources/mapper/modules/AiProductPromptMapper.xml

New file
@@ -0,0 +1,4 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cc.mrbird.febs.ai.mapper.AiProductPromptMapper">
</mapper>

 src/main/resources/mapper/modules/AiProductQuestionJobMapper.xml

New file
@@ -0,0 +1,4 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cc.mrbird.febs.ai.mapper.AiProductQuestionJobMapper">
</mapper>

 src/main/resources/templates/febs/views/modules/ai/aiProductPrompt/add.html

New file
@@ -0,0 +1,90 @@
<div class="layui-fluid layui-anim febs-anim" id="febs-aiProductPrompt-add" lay-title="新增">
    <div class="layui-row febs-container">
        <div class="layui-col-md12">
            <div class="layui-fluid" id="aiProductPrompt-add">
                <form class="layui-form" action="" lay-filter="aiProductPrompt-add-form">
                    <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
                        <ul class="layui-tab-title">
                            <li class="layui-this">基础信息</li>
                        </ul>
                        <div class="layui-tab-content">
                            <div class="layui-tab-item layui-show">
                                <div class="layui-row layui-col-space10 layui-form-item">
                                    <div class="layui-col-lg6">
                                        <label class="layui-form-label febs-form-item-require">名称：</label>
                                        <div class="layui-input-block">
                                            <input type="text" name="name" lay-verify="required"
                                                   placeholder="" autocomplete="off" class="layui-input">
                                        </div>
                                    </div>
                                    <div class="layui-row layui-col-space10 layui-form-item">
                                        <div class="layui-col-lg6">
                                            <label class="layui-form-label febs-form-item-require">提示词：</label>
                                            <div class="layui-input-block">
                                            <textarea name="code" lay-verify="required"
                                                      placeholder="" autocomplete="off" class="layui-textarea" rows="15"></textarea>

                                                <div class="layui-form-mid layui-word-aux">ai生成题目或者产品陪练中的prompt。</div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="layui-form-item febs-hide">
                        <button class="layui-btn" lay-submit="" lay-filter="aiProductPrompt-add-form-submit" id="submit">保存</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<!-- 表格操作栏 end -->
<script data-th-inline="javascript">
    layui.use(['febs', 'form', 'formSelects', 'validate', 'treeSelect', 'eleTree','dropdown', 'laydate', 'layedit', 'upload', 'element', 'table', 'xmSelect','jquery'], function () {
        var $ = layui.jquery,
            febs = layui.febs,
            layer = layui.layer,
            table = layui.table,
            formSelects = layui.formSelects,
            treeSelect = layui.treeSelect,
            form = layui.form,
            laydate = layui.laydate,
            eleTree = layui.eleTree,
            $view = $('#aiProductPrompt-add'),
            layedit = layui.layedit,
            upload = layui.upload,
            validate = layui.validate,
            element = layui.element;

        form.render();

        form.on('submit(aiProductPrompt-add-form-submit)', function (data) {
            $.ajax({
                'url':ctx + 'admin/aiProductPrompt/add',
                'type':'post',
                'dataType':'json',
                'headers' : {'Content-Type' : 'application/json;charset=utf-8'}, //接口json格式
                'traditional': true,//ajax传递数组必须添加属性
                'data':JSON.stringify(data.field),
                'success':function (data) {
                    if(data.code==200){
                        layer.closeAll();
                        febs.alert.success(data.message);
                        $('#febs-aiProductPrompt').find('#query').click();
                    }else{
                        febs.alert.warn(data.message);
                    }
                },
                'error':function () {
                    febs.alert.warn('服务器繁忙');
                }
            })
            return false;
        });

    });
</script>

 src/main/resources/templates/febs/views/modules/ai/aiProductPrompt/info.html

New file
@@ -0,0 +1,110 @@
<div class="layui-fluid layui-anim febs-anim" id="febs-aiProductPrompt-Info" lay-title="编辑">
    <div class="layui-row febs-container">
        <div class="layui-col-md12">
            <div class="layui-fluid" id="aiProductPrompt-info">
                <form class="layui-form" action="" lay-filter="aiProductPrompt-info-form">
                    <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief">
                        <ul class="layui-tab-title">
                            <li class="layui-this">基础信息</li>
                        </ul>
                        <div class="layui-tab-content">
                            <input type="text" name="id"
                                   placeholder="" autoComplete="off" class="layui-input febs-hide">
                            <div class="layui-tab-item layui-show">
                                <div class="layui-row layui-col-space10 layui-form-item">
                                    <div class="layui-col-lg6">
                                        <label class="layui-form-label febs-form-item-require">名称：</label>
                                        <div class="layui-input-block">
                                            <input type="text" name="name" lay-verify="required"
                                                   placeholder="" autocomplete="off" class="layui-input">
                                        </div>
                                    </div>
                                </div>
                                <div class="layui-row layui-col-space10 layui-form-item">
                                    <div class="layui-col-lg6">
                                        <label class="layui-form-label febs-form-item-require">提示词：</label>
                                        <div class="layui-input-block">
                                            <textarea name="code" lay-verify="required"
                                                      placeholder="" autocomplete="off" class="layui-textarea" rows="15"></textarea>

                                            <div class="layui-form-mid layui-word-aux">ai生成题目或者产品陪练中的prompt。</div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="layui-form-item febs-hide">
                        <button class="layui-btn" lay-submit="" lay-filter="aiProductPrompt-info-form-submit" id="submit">保存</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<style>
    .blue-border {
        border-left-color: #2db7f5;
        font-size: 18px;
    }
    .layui-table-cell {
        height:auto;
    }
    .layui-upload-list {
        margin: 0 !important;
    }
    .multi-images {
        margin: 0 5px !important;
    }
</style>
<!-- 表格操作栏 end -->
<script data-th-inline="javascript">
    layui.use(['febs', 'form', 'validate','formSelects', 'table', 'upload'], function () {
        var $ = layui.jquery,
            febs = layui.febs,
            layer = layui.layer,
            table = layui.table,
            form = layui.form,
            $view = $('#aiProductPrompt-info'),
            aiProductPrompt = [[${aiProductPrompt}]],
            upload = layui.upload,
            validate = layui.validate;

        form.render();


        initaiProductPromptInfo();
        function initaiProductPromptInfo() {
            form.val("aiProductPrompt-info-form", {
                "id": aiProductPrompt.id,
                "name": aiProductPrompt.name,
                "code": aiProductPrompt.code,
            });
        }

        form.on('submit(aiProductPrompt-info-form-submit)', function (data) {
            $.ajax({
                'url':ctx + 'admin/aiProductPrompt/update',
                'type':'post',
                'dataType':'json',
                'headers' : {'Content-Type' : 'application/json;charset=utf-8'}, //接口json格式
                'traditional': true,//ajax传递数组必须添加属性
                'data':JSON.stringify(data.field),
                'success':function (data) {
                    if(data.code==200){
                        layer.closeAll();
                        febs.alert.success(data.message);
                        $('#febs-aiProductPrompt').find('#query').click();
                    }else{
                        febs.alert.warn(data.message);
                    }
                },
                'error':function () {
                    febs.alert.warn('服务器繁忙');
                }
            })
            return false;
        });

    });
</script>

 src/main/resources/templates/febs/views/modules/ai/aiProductPrompt/list.html

New file
@@ -0,0 +1,162 @@
<div class="layui-fluid layui-anim febs-anim" id="febs-aiProductPrompt" lay-title="AI提示词模板">
    <div class="layui-row febs-container">
        <div class="layui-col-md12">
            <div class="layui-card">
                <div class="layui-card-body febs-table-full">
                    <form class="layui-form layui-table-form" lay-filter="aiProductPrompt-table-form">
                        <div class="layui-row">
                            <div class="layui-col-md10">
                                <div class="layui-form-item">
                                </div>
                            </div>
                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" id="query">
                                    <i class="layui-icon">&#xe848;</i>
                                </div>
                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="reset">
                                    <i class="layui-icon">&#xe79b;</i>
                                </div>
                            </div>
                        </div>
                    </form>
                    <table lay-filter="aiProductPromptTable" lay-data="{id: 'aiProductPromptTable'}"></table>

                    <style type="text/css">
                        .layui-table-cell{
                            text-align:center;
                            height: auto;
                            white-space: nowrap; /*文本不会换行，在同一行显示*/
                            overflow: hidden; /*超出隐藏*/
                            text-overflow: ellipsis; /*省略号显示*/
                        }
                        .layui-table img{
                            max-width:100px
                        }
                        ::-webkit-scrollbar {
                            height: 20px !important;
                            background-color: #f4f4f4;
                        }
                    </style>
                </div>
            </div>
        </div>
    </div>
</div>

<script type="text/html" id="aiProductPromptToolbar">
    <div class="layui-btn-container">
        <button class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain" shiro:hasPermission="companyList:add" lay-event="aiProductPromptAdd">新增</button>
    </div>
</script>

<script type="text/html" id="aiProductPromptOption">
    <button class="layui-btn layui-btn-normal layui-btn-sm" type="button" shiro:hasPermission="companyList:info" lay-event="aiProductPromptInfoEvent">编辑</button>
</script>


<style>
    .layui-form-onswitch {
        background-color: #5FB878 !important;
    }
</style>
<!-- 表格操作栏 end -->
<script data-th-inline="none" type="text/javascript">
    // 引入组件并初始化
    layui.use([ 'jquery', 'form', 'table', 'febs'], function () {
        var $ = layui.jquery,
            febs = layui.febs,
            form = layui.form,
            table = layui.table,
            $view = $('#febs-aiProductPrompt'),
            $query = $view.find('#query'),
            $reset = $view.find('#reset'),
            $searchForm = $view.find('form'),
            sortObject = {field: 'orderNum', type: null},
            tableIns;

        form.render();

        // 表格初始化
        initaiProductPromptTable();

        // 初始化表格操作栏各个按钮功能
        table.on('tool(aiProductPromptTable)', function (obj) {
            console.log("触发事件:", obj.event); // 调试信息
            var data = obj.data,
                layEvent = obj.event;

            if (layEvent === 'aiProductPromptInfoEvent') {
                if (data.state == 1){
                    febs.alert.warn('请先禁用这行数据');
                    return;
                }
                febs.modal.open('编辑','modules/ai/aiProductPrompt/info/' + data.id, {
                    btn: ['提交', '取消'],
                    area: ['100%', '100%'],
                    yes: function (index, layero) {
                        $('#febs-aiProductPrompt-Info').find('#submit').trigger('click');
                    },
                    btn2: function () {
                        layer.closeAll();
                    }
                });
            }

        });

        // 初始化表格操作栏各个按钮功能
        table.on('toolbar(aiProductPromptTable)', function (obj) {
            let data = obj.data,
                layEvent = obj.event;
            if(layEvent === 'aiProductPromptAdd'){
                febs.modal.open('新增', 'modules/ai/aiProductPrompt/add/', {
                    btn: ['提交', '取消'],
                    area:['100%','100%'],
                    yes: function (index, layero) {
                        $('#febs-aiProductPrompt-add').find('#submit').trigger('click');
                    },
                    btn2: function () {
                        layer.closeAll();
                    }
                });
            }
        });

        function initaiProductPromptTable() {
            tableIns = febs.table.init({
                elem: $view.find('table'),
                id: 'aiProductPromptTable',
                url: ctx + 'admin/aiProductPrompt/list',
                toolbar:"#aiProductPromptToolbar",
                defaultToolbar:[],
                cols: [[
                    {type: 'checkbox'},
                    {type: 'numbers', title: '', width: 80},
                    {title: '操作', toolbar: '#aiProductPromptOption', minWidth: 200, align: 'center'},
                    {field: 'id', title: 'ID', minWidth: 100,align:'center'},
                    {field: 'name', title: '名称', minWidth: 100,align:'center'},
                ]]
            });
        }


        // 查询按钮
        $query.on('click', function () {
            var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type});
            tableIns.reload({where: params, page: {curr: 1}});
        });

        // 刷新按钮
        $reset.on('click', function () {
            $searchForm[0].reset();
            sortObject.type = 'null';
            tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject});
        });
        // 获取查询参数
        function getQueryParams() {
            return {
            };
        }

    })
</script>