1.建表
-- 切换到业务 schema(确认和 JDBC 串里的 ?schema=dpf 一致)
SET SCHEMA dpf;
CREATE TABLE report_go_view_project (
id BIGINT NOT NULL,
name VARCHAR(100) NOT NULL,
pic_url VARCHAR(255) DEFAULT '',
content CLOB,
status TINYINT DEFAULT 1 NOT NULL,
remark VARCHAR(255),
creator VARCHAR(64) DEFAULT '',
create_time DATETIME DEFAULT SYSDATE,
updater VARCHAR(64) DEFAULT '',
update_time DATETIME DEFAULT SYSDATE,
deleted TINYINT DEFAULT 0 NOT NULL,
tenant_id BIGINT DEFAULT 0 NOT NULL,
CONSTRAINT pk_report_go_view_project PRIMARY KEY (id)
);
COMMENT ON TABLE report_go_view_project IS 'GoView 大屏项目表';
COMMENT ON COLUMN report_go_view_project.id IS '编号';
COMMENT ON COLUMN report_go_view_project.name IS '项目名称';
COMMENT ON COLUMN report_go_view_project.pic_url IS '预览图片 URL';
COMMENT ON COLUMN report_go_view_project.content IS '报表内容(JSON 配置)';
COMMENT ON COLUMN report_go_view_project.status IS '发布状态:0-已发布 1-未发布';
COMMENT ON COLUMN report_go_view_project.remark IS '项目备注';
COMMENT ON COLUMN report_go_view_project.creator IS '创建者';
COMMENT ON COLUMN report_go_view_project.create_time IS '创建时间';
COMMENT ON COLUMN report_go_view_project.updater IS '更新者';
COMMENT ON COLUMN report_go_view_project.update_time IS '更新时间';
COMMENT ON COLUMN report_go_view_project.deleted IS '是否删除';
COMMENT ON COLUMN report_go_view_project.tenant_id IS '租户编号';
CREATE INDEX idx_report_go_view_project_creator ON report_go_view_project (creator);
2.克隆代码
为什么拉取的是 master-fetch 分支,因为这个分支带后端,master 纯前端分支没有请求层,调用不了后端接口
cd D:\code\project\git
git clone -b master-fetch https://gitee.com/dromara/go-view.git
3.安装依赖
用 pnpm 会导致这个报错,要么执行 pnpm approve-builds 放行这些构建脚本(会弹出一个多选列表,按 a 全选回车确认),要么直接用 npm:
[ERR_PNPM_IGNORED_BUILDS] Ignored build scripts: esbuild@0.14.54, esbuild@0.17.19, vue-demi@0.13.11, vue-demi@0.14.10, vue-echarts@6.7.3 Run "pnpm approve-builds" to pick which dependencies should be allowed to run scripts.
# 当前 Node 版本:22
npm install
4.改代码
环境配置:.env
# 只改这一行,下面那行先留着
# development path
VITE_DEV_PATH = 'http://127.0.0.1:9210'
# production path
VITE_PRO_PATH = ''
接口前缀:/src/settings/httpsetting.ts
// 请求前缀
export const axiosPre = '/admin-api/report/go-view'
鉴权头和成功码:/src/api/axios.ts
# 请求拦截器里,找到这三行(在第37行起):
const userInfo = info[SystemStoreEnum.USER_INFO]
config.headers[userInfo[SystemStoreUserInfoEnum.TOKEN_NAME] || 'token'] = userInfo[SystemStoreUserInfoEnum.USER_TOKEN] || ''
return config
# 替换为
const userInfo = info[SystemStoreEnum.USER_INFO]
const token = userInfo[SystemStoreUserInfoEnum.USER_TOKEN] || ''
// 后端要求 Bearer 前缀
config.headers['Authorization'] = token.startsWith('Bearer ') ? token : `Bearer ${token}`
// 多租户,按实际启用的租户编号改
config.headers['tenant-id'] = '1'
return config
响应代码:src/enums/httpEnum.ts
# 第 10 行,将 SUCCESS = 200 改为 0,因为后端成功响应码是 0
// 请求结果集
export enum ResultEnum {
SUCCESS = 200
}
# 替换为
export enum ResultEnum {
SUCCESS = 0
}
从 URL 接收 token,跳过 GoView 自己的登录,新建文件 src/bootstrapToken.ts
// 从 admin 后台 iframe 传入的 URL 参数中提取登录态
// URL 形如:http://127.0.0.1:3000?accessToken=xxx&refreshToken=yyy
import { StorageEnum } from '@/enums/storageEnum'
const TOKEN_KEY = StorageEnum.GO_SYSTEM_STORE
const params = new URLSearchParams(window.location.search)
const accessToken = params.get('accessToken')
if (accessToken) {
let state: Record<string, any> = {}
try {
state = JSON.parse(window.localStorage.getItem(TOKEN_KEY) || '{}') || {}
} catch {
state = {}
}
state.userInfo = {
...(state.userInfo || {}),
// 带 Bearer 前缀,配合 axios.ts 里的 Authorization 直接使用
userToken: `Bearer ${accessToken}`,
userName: 'goview',
nickName: '大屏用户',
}
state.fetchInfo = state.fetchInfo || { OSSUrl: undefined }
window.localStorage.setItem(TOKEN_KEY, JSON.stringify(state))
// 清掉地址栏里的 token,避免留在历史记录里被重复处理
params.delete('accessToken')
params.delete('refreshToken')
const rest = params.toString()
window.history.replaceState(
{},
'',
window.location.pathname + (rest ? `?${rest}` : '') + window.location.hash
)
}
改 src/main.ts——必须是第一行 import
import '@/bootstrapToken' // 新增,必须放在所有 import 之前
import { createApp } from 'vue'
import App from './App.vue'
// ...其余保持不变
src/api/axios.config.ts —— 清空白名单
# 全部替换
// 接口白名单(免登录)
// 后端所有接口都要求鉴权,这里保持为空,避免请求漏带 token
export const fetchAllowList: string[] = []
// 接口黑名单
export const fetchBlockList = []
src/api/path/project.api.ts —— 接口映射
# 全部替换,实际上就 upload 上传文件没有变化
import { http } from '@/api/http'
import { httpErrorHandle } from '@/utils'
import { ContentTypeEnum, RequestHttpEnum, ModuleTypeEnum } from '@/enums/httpEnum'
import { ProjectItem, ProjectDetail } from './project'
const P = ModuleTypeEnum.PROJECT
/** 后端 0-已发布 / 1-未发布 <-> GoView 1-已发布 / -1-未发布 */
const toViewState = (status?: number) => (status === 0 ? 1 : -1)
const toServerStatus = (state?: number) => (state === 1 ? 0 : 1)
/** 后端 VO -> GoView 列表项 */
const toProjectItem = (row: any): ProjectItem => ({
id: String(row?.id ?? ''),
projectName: row?.name ?? '',
state: toViewState(row?.status),
createTime: row?.createTime ?? '',
indexImage: row?.picUrl ?? '',
createUserId: String(row?.creator ?? ''),
remarks: row?.remark ?? ''
})
/** 兼容 FormData / 普通对象两种入参 */
const pick = (data: any, key: string) =>
data instanceof FormData ? data.get(key) : data?.[key]
// * 项目列表(后端只提供"我的项目"分页接口)
export const projectListApi = async (data: any) => {
try {
const res = await http(RequestHttpEnum.GET)<any>(`${P}/my-page`, {
pageNo: data?.page ?? 1,
pageSize: data?.limit ?? 12
})
const rows: any[] = res?.data?.list ?? []
// 注意:count 与 data 平级,不是放在 data 里
return { ...res, data: rows.map(toProjectItem), count: res?.data?.total ?? 0 } as any
} catch {
httpErrorHandle()
}
}
// * 新增项目(后端返回裸 id,这里包成 { id })
export const createProjectApi = async (data: any) => {
try {
const res = await http(RequestHttpEnum.POST)<number>(`${P}/create`, {
name: data?.projectName ?? data?.name
})
return { ...res, data: { id: res?.data } } as any
} catch {
httpErrorHandle()
}
}
// * 获取项目详情(含画布 JSON)
export const fetchProjectApi = async (data: any) => {
try {
const res = await http(RequestHttpEnum.GET)<any>(`${P}/get`, {
id: data?.projectId ?? data?.id
})
const row = res?.data
// 后端对"还没有画布内容"的项目返回 data: null,
// 必须原样透传,让 GoView 走 else 分支初始化空白画布
if (!row || !row.content) {
return { ...res, data: null } as any
}
return {
...res,
data: { ...toProjectItem(row), content: row.content } as ProjectDetail
} as any
} catch {
httpErrorHandle()
}
}
// * 保存画布内容(GoView 传 FormData,要转成 JSON 走 update)
export const saveProjectApi = async (data: any) => {
try {
return await http(RequestHttpEnum.PUT)(`${P}/update`, {
// 雪花 id 19 位,转 Number 会丢精度,必须保持字符串
id: pick(data, 'projectId') ?? pick(data, 'id'),
content: pick(data, 'content')
})
} catch {
httpErrorHandle()
}
}
// * 修改项目基础信息(重命名、换封面)
export const updateProjectApi = async (data: any) => {
try {
const remarks = pick(data, 'remarks')
const projectName = pick(data, 'projectName')
const indexImage = pick(data, 'indexImage')
return await http(RequestHttpEnum.PUT)(`${P}/update`, {
id: pick(data, 'id') ?? pick(data, 'projectId'),
...(projectName ? { name: projectName } : {}),
...(indexImage ? { picUrl: indexImage } : {}),
...(remarks !== null && remarks !== undefined ? { remark: remarks } : {})
})
} catch {
httpErrorHandle()
}
}
// * 删除项目(GoView 传单个 id,后端也是单个删除)
export const deleteProjectApi = async (data: any) => {
try {
const raw = data?.ids ?? data?.id
const ids: any[] = Array.isArray(raw) ? raw : [raw].filter(Boolean)
for (const id of ids) {
await http(RequestHttpEnum.DELETE)(`${P}/delete`, { id })
}
return { code: 0, data: true, message: 'ok' } as any
} catch {
httpErrorHandle()
}
}
// * 发布 / 取消发布(后端没有 publish,直接改 status)
export const changeProjectReleaseApi = async (data: any) => {
try {
return await http(RequestHttpEnum.PUT)(`${P}/update`, {
id: data?.id,
status: toServerStatus(data?.state)
})
} catch {
httpErrorHandle()
}
}
// * 上传文件
export const uploadFile = async (data: object) => {
try {
const res = await http(RequestHttpEnum.POST)<{
/**
* 文件地址
*/
fileName: string,
fileurl: string,
}>(`${ModuleTypeEnum.PROJECT}/upload`, data, ContentTypeEnum.FORM_DATA)
return res
} catch {
httpErrorHandle()
}
}
src/views/preview/utils/storage.ts —— 加 3 行 null 判断(第 23-24 行),不改的后果:列表里对从没保存过的项目点「预览」→ 白屏(Cannot destructure property 'content' of null)
if (res && res.code === ResultEnum.SUCCESS) {
const { content, state } = res.data
# 替换为
if (res && res.code === ResultEnum.SUCCESS) {
// 后端对还没有画布内容的项目返回 data: null,视为未发布
if (!res.data) {
return { isRelease: false }
}
const { content, state } = res.data
vite.config.ts —— 补一个代理(第 48-56 行),不改的后果:封面图上传走 /admin-api/basic/file/upload,匹配不到原来的代理前缀,会打到 Vite 自己身上 404
proxy: {
[axiosPre]: {
// @ts-ignore
target: loadEnv(mode, process.cwd()).VITE_DEV_PATH,
changeOrigin: true,
ws: true,
secure: true,
}
}
# 替换为
proxy: {
[axiosPre]: {
// @ts-ignore
target: loadEnv(mode, process.cwd()).VITE_DEV_PATH,
changeOrigin: true,
ws: true,
secure: true,
},
// 文件上传等其它后端接口不在 axiosPre 前缀下,单独代理
'/admin-api': {
// @ts-ignore
target: loadEnv(mode, process.cwd()).VITE_DEV_PATH,
changeOrigin: true,
ws: true,
secure: true,
}
}
跳转新开标签页携带 token 解决方案
src\utils\router.ts,把现有的 openNewWindow(第 125 行)整段替换成:
/**
* * 新开标签页
* 新标签页是顶层上下文,读不到 iframe 内被 Chrome 分区的 localStorage,
* 所以同源地址统一把 accessToken 拼到 query 上,交给 bootstrapToken.ts 接管
*/
export const openNewWindow = (url: string) => {
let target = url
try {
const info = getLocalStorage(StorageEnum.GO_SYSTEM_STORE)
const token = String(
info?.[SystemStoreEnum.USER_INFO]?.[SystemStoreUserInfoEnum.USER_TOKEN] || ''
).replace(/^Bearer\s+/i, '')
if (token) {
// 相对 hash 路径按当前文档解析;previewPath 这类绝对地址也一并处理
const u = new URL(url, location.href)
if (u.origin === location.origin) {
u.searchParams.set('accessToken', token)
target = u.toString()
}
}
} catch {
target = url
}
window.open(target, '_blank')
}
后端 500 响应码导致需要重新登录:/src/enums/pageEnum.ts
# 注释掉 [ResultEnum.SERVER_ERROR, PageEnum.ERROR_PAGE_NAME_500]
export const ErrorPageNameMap = new Map([
[ResultEnum.NOT_FOUND, PageEnum.ERROR_PAGE_NAME_404],
[ResultEnum.SERVER_FORBIDDEN, PageEnum.ERROR_PAGE_NAME_403],
// [ResultEnum.SERVER_ERROR, PageEnum.ERROR_PAGE_NAME_500]
])
5.打包
npm run build