From a0975d3f7bfbe66b6a9dc6967079db6b6ff5a3e3 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Mon, 02 Feb 2026 14:27:29 +0800
Subject: [PATCH] feat(ai): 添加AI产品题目生成任务功能

---
 src/main/java/cc/mrbird/febs/ai/service/AiProductQuestionService.java                       |    4 
 src/main/java/cc/mrbird/febs/ai/controller/productQuestion/ViewController.java              |    7 +
 src/main/java/cc/mrbird/febs/ai/entity/AiProductQuestionJob.java                            |   55 +++++++++++
 src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java              |   37 +++++++
 src/main/java/cc/mrbird/febs/ai/controller/productQuestion/AiProductQuestionController.java |   15 ++
 src/main/java/cc/mrbird/febs/ai/mapper/AiProductQuestionJobMapper.java                      |   14 ++
 src/main/resources/templates/febs/views/modules/ai/productQuestion/jobList.html             |  160 ++++++++++++++++++++++++++++++++
 7 files changed, 291 insertions(+), 1 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/AiProductQuestionController.java b/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/AiProductQuestionController.java
index a5b4c6a..8fc94e9 100644
--- a/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/AiProductQuestionController.java
+++ b/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/AiProductQuestionController.java
@@ -1,6 +1,7 @@
 package cc.mrbird.febs.ai.controller.productQuestion;
 
 import cc.mrbird.febs.ai.entity.AiProductQuestion;
+import cc.mrbird.febs.ai.entity.AiProductQuestionJob;
 import cc.mrbird.febs.ai.req.AiProductQuestionAiDto;
 import cc.mrbird.febs.ai.service.AiProductQuestionService;
 import cc.mrbird.febs.common.annotation.ControllerEndpoint;
@@ -37,6 +38,15 @@
         return new FebsResponse().success().data(data);
     }
 
+    @GetMapping("jobList")
+    public FebsResponse jobList(AiProductQuestionJob dto, QueryRequest request) {
+        String companyId = getCurrentUserCompanyId();
+        dto.setCompanyId(companyId);
+
+        Map<String, Object> data = getDataTable(aiProductQuestionService.listJobInPage(dto, request));
+        return new FebsResponse().success().data(data);
+    }
+
     @GetMapping("changeState/{id}/{state}")
     @ControllerEndpoint(operation = "状态操作", exceptionMessage = "操作失败")
     public FebsResponse changeState(
@@ -60,9 +70,12 @@
     @ControllerEndpoint(operation = "AI生成题目", exceptionMessage = "操作失败")
     public FebsResponse aiAdd(@RequestBody @Valid AiProductQuestionAiDto dto) {
 
+//        String companyId = getCurrentUserCompanyId();
+//        dto.setCompanyId(companyId);
+//        return aiProductQuestionService.aiAdd(dto);
         String companyId = getCurrentUserCompanyId();
         dto.setCompanyId(companyId);
-        return aiProductQuestionService.aiAdd(dto);
+        return aiProductQuestionService.aiAddV2(dto);
     }
 
     @PostMapping("update")
diff --git a/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/ViewController.java b/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/ViewController.java
index 81dfc37..06ce0ad 100644
--- a/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/ViewController.java
+++ b/src/main/java/cc/mrbird/febs/ai/controller/productQuestion/ViewController.java
@@ -38,6 +38,13 @@
         return FebsUtil.view("modules/ai/productQuestion/list");
     }
 
+    @GetMapping("jobList")
+    @RequiresPermissions("productQuestionJobList:view")
+    public String jobList() {
+
+        return FebsUtil.view("modules/ai/productQuestion/jobList");
+    }
+
     @GetMapping(value = "/add")
     @RequiresPermissions("productQuestionList:add")
     public String artAdd() {
diff --git a/src/main/java/cc/mrbird/febs/ai/entity/AiProductQuestionJob.java b/src/main/java/cc/mrbird/febs/ai/entity/AiProductQuestionJob.java
new file mode 100644
index 0000000..9bbf667
--- /dev/null
+++ b/src/main/java/cc/mrbird/febs/ai/entity/AiProductQuestionJob.java
@@ -0,0 +1,55 @@
+package cc.mrbird.febs.ai.entity;
+
+import cc.mrbird.febs.common.entity.AiBaseEntity;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+
+import java.util.List;
+
+/**
+ * ai题目生成任务
+ *
+ * @author yourname
+ * @date 2025-07-29
+ */
+@Data
+@TableName("ai_product_question_job")
+public class AiProductQuestionJob extends AiBaseEntity {
+
+    /**
+     * 公司ID (UUID)
+     */
+    private String companyId;
+
+    /**
+     * AI产品类别ID (UUID)
+     */
+    private String productCategoryId;
+
+    /**
+     * 要求
+     */
+    private String title;
+
+    /**
+     * 难度:1-简单,2-中等,3-困难
+     */
+    private Integer difficulty;
+
+    /**
+     * 状态 0-为启动 1-进行中 2-已完成
+     */
+    private Integer state;
+
+    /**
+     * 题目数量
+     */
+    private Integer questionCnt;
+
+    /**
+     * 已完成数量
+     */
+    private Integer questionDoneCnt;
+
+}
diff --git a/src/main/java/cc/mrbird/febs/ai/mapper/AiProductQuestionJobMapper.java b/src/main/java/cc/mrbird/febs/ai/mapper/AiProductQuestionJobMapper.java
new file mode 100644
index 0000000..ed0ac72
--- /dev/null
+++ b/src/main/java/cc/mrbird/febs/ai/mapper/AiProductQuestionJobMapper.java
@@ -0,0 +1,14 @@
+package cc.mrbird.febs.ai.mapper;
+
+import cc.mrbird.febs.ai.entity.AiProductQuestionJob;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * AI产品题目 Mapper接口
+ *
+ * @author yourname
+ * @date 2025-07-29
+ */
+public interface AiProductQuestionJobMapper extends BaseMapper<AiProductQuestionJob> {
+
+}
diff --git a/src/main/java/cc/mrbird/febs/ai/service/AiProductQuestionService.java b/src/main/java/cc/mrbird/febs/ai/service/AiProductQuestionService.java
index 9b74e0f..684c998 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/AiProductQuestionService.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/AiProductQuestionService.java
@@ -1,6 +1,7 @@
 package cc.mrbird.febs.ai.service;
 
 import cc.mrbird.febs.ai.entity.AiProductQuestion;
+import cc.mrbird.febs.ai.entity.AiProductQuestionJob;
 import cc.mrbird.febs.ai.entity.AiProductRole;
 import cc.mrbird.febs.ai.req.AiProductQuestionAiDto;
 import cc.mrbird.febs.common.entity.FebsResponse;
@@ -27,6 +28,8 @@
 
     IPage<AiProductQuestion> listInPage(AiProductQuestion dto, QueryRequest request);
 
+    IPage<AiProductQuestionJob> listJobInPage(AiProductQuestionJob dto, QueryRequest request);
+
     FebsResponse changeState(String id, Integer state);
 
     FebsResponse add(AiProductQuestion dto);
@@ -42,4 +45,5 @@
     List<AiProductQuestion> productQuestionTree(LambdaQueryWrapper<AiProductQuestion> aiProductQuestionLambdaQueryWrapper);
 
     FebsResponse aiAdd(AiProductQuestionAiDto dto);
+    FebsResponse aiAddV2(AiProductQuestionAiDto dto);
 }
diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
index 2352f24..7c51450 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
@@ -1,6 +1,7 @@
 package cc.mrbird.febs.ai.service.impl;
 
 import cc.mrbird.febs.ai.entity.*;
+import cc.mrbird.febs.ai.mapper.AiProductQuestionJobMapper;
 import cc.mrbird.febs.ai.mapper.AiProductQuestionMapper;
 import cc.mrbird.febs.ai.req.AiProductQuestionAiDto;
 import cc.mrbird.febs.ai.service.AiProductQuestionItemService;
@@ -46,6 +47,7 @@
 public class AiProductQuestionServiceImpl extends ServiceImpl<AiProductQuestionMapper, AiProductQuestion> implements AiProductQuestionService {
 
     private final AiProductQuestionMapper aiProductQuestionMapper;
+    private final AiProductQuestionJobMapper aiProductQuestionJobMapper;
     private final AiProductQuestionItemService aiProductQuestionItemService;
     private final AiService aiService;
 
@@ -68,6 +70,21 @@
         query.ne(AiProductQuestion::getState, 2);
         query.orderByDesc(AiProductQuestion::getCreatedTime);
         Page<AiProductQuestion> pages = aiProductQuestionMapper.selectPage(page, query);
+        return pages;
+    }
+
+    @Override
+    public IPage<AiProductQuestionJob> listJobInPage(AiProductQuestionJob dto, QueryRequest request) {
+        Page<AiProductQuestionJob> page = new Page<>(request.getPageNum(), request.getPageSize());
+        LambdaQueryWrapper<AiProductQuestionJob> query = Wrappers.lambdaQuery(AiProductQuestionJob.class);
+        if (StrUtil.isNotEmpty(dto.getCompanyId())){
+            query.eq(AiProductQuestionJob::getCompanyId, dto.getCompanyId());
+        }
+        if (StrUtil.isNotEmpty(dto.getProductCategoryId())){
+            query.eq(AiProductQuestionJob::getProductCategoryId, dto.getProductCategoryId());
+        }
+        query.orderByDesc(AiProductQuestionJob::getCreatedTime);
+        Page<AiProductQuestionJob> pages = aiProductQuestionJobMapper.selectPage(page, query);
         return pages;
     }
 
@@ -248,6 +265,26 @@
         return new FebsResponse().success().message("操作成功");
     }
 
+    @Override
+    public FebsResponse aiAddV2(AiProductQuestionAiDto dto) {
+        String companyId = dto.getCompanyId();
+        String productCategoryId = dto.getProductCategoryId();
+        Integer questionCnt = dto.getQuestionCnt();
+        String query = dto.getQuery();
+        Integer difficulty = dto.getDifficulty();
+        Date createdTime = new Date();
+        AiProductQuestionJob aiProductQuestionJob = new AiProductQuestionJob();
+        aiProductQuestionJob.setId(UUID.getSimpleUUIDString());
+        aiProductQuestionJob.setCompanyId(companyId);
+        aiProductQuestionJob.setProductCategoryId(productCategoryId);
+        aiProductQuestionJob.setTitle(query);
+        aiProductQuestionJob.setQuestionCnt(questionCnt);
+        aiProductQuestionJob.setDifficulty(difficulty);
+        aiProductQuestionJob.setCreatedTime(createdTime);
+        aiProductQuestionJobMapper.insert(aiProductQuestionJob);
+        return new FebsResponse().success().message("操作成功");
+    }
+
     /**
      * 解析AI返回的包含问题和答案的JSON字符串
      * @param aiResponse AI返回的原始响应字符串
diff --git a/src/main/resources/templates/febs/views/modules/ai/productQuestion/jobList.html b/src/main/resources/templates/febs/views/modules/ai/productQuestion/jobList.html
new file mode 100644
index 0000000..d1eb377
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/ai/productQuestion/jobList.html
@@ -0,0 +1,160 @@
+<div class="layui-fluid layui-anim febs-anim" id="febs-productQuestion-job" lay-title="产品题库">
+    <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="productQuestion-table-job-form">
+                        <div class="layui-row">
+                            <div class="layui-col-md10">
+                                <div class="layui-row layui-col-space6 layui-form-item">
+                                    <div class="layui-col-lg3">
+                                        <label class="layui-form-label">产品分类:</label>
+                                        <div class="layui-input-block">
+                                            <div id="product-qutestion-job-category-query"></div>
+                                        </div>
+                                    </div>
+                                </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="productQuestionJobTable" lay-data="{id: 'productQuestionJobTable'}"></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="difficultyFormat">
+    {{# if(d.difficulty == 1) { }}
+    <span>简单</span>
+    {{# }else if(d.difficulty == 2) { }}
+    <span>中等</span>
+    {{# }else if(d.difficulty == 3) { }}
+    <span>困难</span>
+    {{# } else { }}
+    <span>-</span>
+    {{# } }}
+</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', 'xmSelect'], function () {
+        var $ = layui.jquery,
+            febs = layui.febs,
+            form = layui.form,
+            table = layui.table,
+            $view = $('#febs-productQuestion-job'),
+            $query = $view.find('#query'),
+            $reset = $view.find('#reset'),
+            $searchForm = $view.find('form'),
+            sortObject = {field: 'orderNum', type: null},
+            tableIns;
+
+        form.render();
+
+        var categoryQuestion = xmSelect.render({
+            el: '#product-qutestion-job-category-query',
+            language: 'zn',
+            prop : {
+                value : 'id',
+                children : 'child'
+            },
+            iconfont: {
+                parent: 'hidden',
+            },
+            tips: '请选择',
+            filterable: true,
+            radio: true,
+            clickClose: true,
+            tree: {
+                show: true,
+                //非严格模式
+                strict: false,
+            },
+            data: []
+        })
+
+        febs.get(ctx + 'admin/productCategory/categoryTree', null, function(res) {
+            categoryQuestion.update({
+                data : res.data,
+                autoRow: true,
+            });
+        })
+
+        // 表格初始化
+        initproductQuestionJobTable();
+
+        function initproductQuestionJobTable() {
+            tableIns = febs.table.init({
+                elem: $view.find('table'),
+                id: 'productQuestionJobTable',
+                url: ctx + 'admin/productQuestion/jobList',
+                toolbar:"#productQuestionJobToolbar",
+                defaultToolbar:[],
+                cols: [[
+                    {type: 'checkbox'},
+                    {type: 'numbers', title: '', width: 80},
+                    {field: 'title', title: '要求', minWidth: 100,align:'center'},
+                    {field: 'questionCnt', title: '生成总数', minWidth: 100,align:'center'},
+                    {field: 'questionDoneCnt', title: '已完成', minWidth: 100,align:'center'},
+                    {templet:"#difficultyFormat",  title: '难度', minWidth: 140,align:'center'},
+                    {field: 'companyId', title: '公司编码', minWidth: 150,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 () {
+
+            var categoryList = [];
+            categoryQuestion.setValue(categoryList);
+            $searchForm[0].reset();
+            sortObject.type = 'null';
+            tableIns.reload({where: null, page: {curr: 1}, initSort: sortObject});
+        });
+        // 获取查询参数
+        function getQueryParams() {
+            return {
+                productCategoryId: categoryQuestion.getValue('valueStr'),
+            };
+        }
+
+    })
+</script>

--
Gitblit v1.9.1