tiangong-doc
2023-08-18
目录

天宫EXCEL接入

# Excel组件-接入

# 前端接入方式

# .env 文件

# 天宫EXCEL子应用配置
VITE_TG_WUJIE_EXCEL = [{"sysName": "天宫Excel","appName": "TG_EXCEL","appUrl": {"development": "http://192.168.106.182:5009/","testing": "http://192.168.106.182:5009/","production": "http://localhost:8080"}}]
1
2
3
4

# 使用 EXCEL 导入功能

<!-- 添加跳转导入excel页面的按钮 如果需要指定目标，设置moduleName -->
<template>
    <tg-button
        size="large"
        @click="routeToExcelImport({ moduleName: '报关单' })"
    >
        Excel导入
    </tg-button>
</template>
1
2
3
4
5
6
7
8
9
// 跳转excel导入页面的方法
<script setup>
import useTgExcel from '@/tiangong_core/utils/wujie/wujieMain/useTgExcel';

const { routeToExcelImport } = useTgExcel();
</script>
1
2
3
4
5
6

routeToExcelImport接收的参数对象字段：

字段 描述 类型 是否必填 默认值 备注
moduleName 导入类型 string 是 -- 报关单、核注清单等

# 后端接入方式

1.配置好导入临时表时，会在临时表内自动增加以下字段。

tg_batch_no：批次号
tg_template_log_id：当前上传任务id
tg_main_data_id：当前记录id
tg_contact_data_id：关联表头id
tg_insert_status:入库状态 0-待处理1-入库成功2-入库失败 -1处理中 （默认0待处理）
tg_insert_remark：入库结果
1
2
3
4
5
6

2.如果excel 通过了批注校验，在插入临时表的过程中可能遇到字段类型或长度不符合导致失败，所以需要提前考虑好临时表的字段长度和类型。

3.如果入临时库成功以后，tg_insert_status会设置为0。然后调用入正式库API，带上批次号，API处理完成后，需要将此表的tg_insert_status状态调整，成功设置为1，失败设置为2。如果有错误信息，更新到tg_insert_remark中。

#API网址例如：
http://192.168.106.187/LJGW/V100/tgexcel/tgExcelTemplateLog/doMoveFormal
#请求时以此方式请求：
http://192.168.106.187/LJGW/V100/tgexcel/tgExcelTemplateLog/doMoveFormal?batchNo=123
1
2
3
4

# 后端发布方式

1.根据不同的数据库选择相应的sql语句，创建基础表SYS_TG_LANGUAGE。

2.配置项目文件

#前端 文件名：tgexcel-web-config.js(可自定义文件名)
window.global = {
  // 自定义后端接口地址
  // 网关地址
  // baseUrl: 'http://192.168.106.187/LJGW/V100/tgexcel',
  // ip:端口
  baseUrl: 'http://127.0.0.1:9012',
}

#后端 文件名：application-100test.yml(可自定义文件名)
logging:
  level:
    com.eci: debug
    org.springframework: warn
server:
  # 项目端口
  port: 9012
tgExcel:
  #框架接口地址
  serverUrl: http://127.0.0.1:9527
  #后端接口地址是否允许跨域
  #false:无法跨域访问  true: 可以跨域访问  如果配置网关需要设置为false,如果通过IP：端口访问设置为true
  openCors: false
  #上传客户上传excel文件地址
  excel-dir-path: /home/tgexcel
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

3.运行jar包。

#后端：
docker run -d -p 9012:9012 \
-v /home/tgexcel/logs:/logs \
-v  /home/tgexcel:/home/tgexcel \
-v  /home/tgexcel/config/application-100test.yml:/application-100test.yml \
--restart=always --name tiangong_excel_back 192.168.106.187:5000/tiangong_excel_back:1.0.0 \
--spring.profiles.active=100test

#前端：
docker run -d -p 5009:80 \
-v /home/tgexcel/config/tgexcel-web-config.js:/usr/share/nginx/html/config/config.js  \
--name tiangong-excel-web 192.168.106.187:5000/tiangong-excel-web:2.0.0
1
2
3
4
5
6
7
8
9
10
11
12

4.调用初始化项目配置url。

curl http://127.0.0.1:9012/tgExcelTable/doTableStructInit
1

基础表创建语句：

--mysql
CREATE TABLE `SYS_TG_LANGUAGE` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`LANG_CODE` varchar(450) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '映射代码',
`DESCRIPTION` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
`LANG_TYPE` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类型',
`LANG_1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言1',
`LANG_2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言2',
`LANG_3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言3',
`LANG_4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '语言4',
PRIMARY KEY (`ID`) USING BTREE,
UNIQUE KEY `LANG_CODE_UNIQUE` (`LANG_CODE`,`LANG_TYPE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='框架国际化语言配置表';

INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (1, '10001', NULL, 'ht', '操作成功', 'success', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (2, '10002', NULL, 'ht', '登录成功', 'login success', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (3, '10003', NULL, 'ht', '退出成功', 'logout success', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (4, '10004', NULL, 'ht', '密码修改成功', 'password change success', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (5, '20001', NULL, 'ht', '操作失败', 'error', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (6, '20002', NULL, 'ht', '图形验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (7, '20003', NULL, 'ht', '图形验证码错误', 'Verification code error', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (8, '20004', NULL, 'ht', '登录身份已过期，请重新登录', 'token time out', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (9, '20005', NULL, 'ht', 'token不存在', 'token not exist', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (10, '21001', NULL, 'ht', '导入编码生成规则不存在', 'import code generation rule does not exist', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (11, '20006', NULL, 'ht', '用户或公司未授权，请联系客服！', 'The user or the company is not authorized, please contact customer service!', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (12, '20012', NULL, 'ht', '短信验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (13, '20013', NULL, 'ht', '短信验证码错误', 'The verification code has expired', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (14, '20007', NULL, 'ht', '非法的请求参数', '', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (15, '20008', NULL, 'ht', '区域编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (16, '20009', NULL, 'ht', '系统编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO `SYS_TG_LANGUAGE` (`ID`, `LANG_CODE`, `DESCRIPTION`, `LANG_TYPE`, `LANG_1`, `LANG_2`, `LANG_3`, `LANG_4`) VALUES (17, '20015', NULL, 'ht', '表单重复提交', 'Form duplicate submission', NULL, NULL);
--------------------------------------------------------------------------

-- dm
CREATE TABLE SYS_TG_LANGUAGE (
ID NUMBER(19,0) NOT NULL,
LANG_CODE VARCHAR(450) DEFAULT NULL,
DESCRIPTION VARCHAR(200) DEFAULT NULL,
LANG_TYPE VARCHAR(45) DEFAULT NULL,
LANG_1 VARCHAR(100) DEFAULT NULL,
LANG_2 VARCHAR(100) DEFAULT NULL,
LANG_3 VARCHAR(100) DEFAULT NULL,
LANG_4 VARCHAR(100) DEFAULT NULL,
CONSTRAINT pk_SYS_TG_LANGUAGE PRIMARY KEY (ID)
);
COMMENT ON TABLE SYS_TG_LANGUAGE IS '框架国际化语言配置表';

INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (1, '10001', NULL, 'ht', '操作成功', 'success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (2, '10002', NULL, 'ht', '登录成功', 'login success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (3, '10003', NULL, 'ht', '退出成功', 'logout success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (4, '10004', NULL, 'ht', '密码修改成功', 'password change success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (5, '20001', NULL, 'ht', '操作失败', 'error', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (6, '20002', NULL, 'ht', '图形验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (7, '20003', NULL, 'ht', '图形验证码错误', 'Verification code error', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (8, '20004', NULL, 'ht', '登录身份已过期，请重新登录', 'token time out', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (9, '20005', NULL, 'ht', 'token不存在', 'token not exist', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (10, '21001', NULL, 'ht', '导入编码生成规则不存在', 'import code generation rule does not exist', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (11, '20006', NULL, 'ht', '用户或公司未授权，请联系客服！', 'The user or the company is not authorized, please contact customer service!', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (12, '20012', NULL, 'ht', '短信验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (13, '20013', NULL, 'ht', '短信验证码错误', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (14, '20007', NULL, 'ht', '非法的请求参数', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (15, '20008', NULL, 'ht', '区域编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (16, '20009', NULL, 'ht', '系统编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (17, '20015', NULL, 'ht', '表单重复提交', 'Form duplicate submission', NULL, NULL);
--------------------------------------------------------------------------

--ORACLE
CREATE TABLE SYS_TG_LANGUAGE (
ID NUMBER(19,0) NOT NULL,
LANG_CODE VARCHAR2(450) DEFAULT NULL,
DESCRIPTION VARCHAR2(200) DEFAULT NULL,
LANG_TYPE VARCHAR2(45) DEFAULT NULL,
LANG_1 VARCHAR2(100) DEFAULT NULL,
LANG_2 VARCHAR2(100) DEFAULT NULL,
LANG_3 VARCHAR2(100) DEFAULT NULL,
LANG_4 VARCHAR2(100) DEFAULT NULL,
PRIMARY KEY (ID)
);
COMMENT ON TABLE SYS_TG_LANGUAGE IS '框架国际化语言配置表';

INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (1, '10001', NULL, 'ht', '操作成功', 'success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (2, '10002', NULL, 'ht', '登录成功', 'login success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (3, '10003', NULL, 'ht', '退出成功', 'logout success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (4, '10004', NULL, 'ht', '密码修改成功', 'password change success', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (5, '20001', NULL, 'ht', '操作失败', 'error', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (6, '20002', NULL, 'ht', '图形验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (7, '20003', NULL, 'ht', '图形验证码错误', 'Verification code error', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (8, '20004', NULL, 'ht', '登录身份已过期，请重新登录', 'token time out', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (9, '20005', NULL, 'ht', 'token不存在', 'token not exist', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (10, '21001', NULL, 'ht', '导入编码生成规则不存在', 'import code generation rule does not exist', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (11, '20006', NULL, 'ht', '用户或公司未授权，请联系客服！', 'The user or the company is not authorized, please contact customer service!', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (12, '20012', NULL, 'ht', '短信验证码已过期', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (13, '20013', NULL, 'ht', '短信验证码错误', 'The verification code has expired', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (14, '20007', NULL, 'ht', '非法的请求参数', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (15, '20008', NULL, 'ht', '区域编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (16, '20009', NULL, 'ht', '系统编码已存在，请从新输入！', '', NULL, NULL);
INSERT INTO SYS_TG_LANGUAGE (ID, LANG_CODE, DESCRIPTION, LANG_TYPE, LANG_1, LANG_2, LANG_3, LANG_4) VALUES (17, '20015', NULL, 'ht', '表单重复提交', 'Form duplicate submission', NULL, NULL);
--------------------------------------------------------------------------

-- kb8
create table  sys_tg_language (
id number(19,0) not null,
lang_code varchar(450) default null,
description varchar(200) default null,
lang_type varchar(45) default null,
lang_1 varchar(100) default null,
lang_2 varchar(100) default null,
lang_3 varchar(100) default null,
lang_4 varchar(100) default null,
constraint pk_sys_tg_language primary key (id)
);
comment on table  sys_tg_language is '框架国际化语言配置表';

insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (1, '10001', null, 'ht', '操作成功', 'success', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (2, '10002', null, 'ht', '登录成功', 'login success', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (3, '10003', null, 'ht', '退出成功', 'logout success', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (4, '10004', null, 'ht', '密码修改成功', 'password change success', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (5, '20001', null, 'ht', '操作失败', 'error', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (6, '20002', null, 'ht', '图形验证码已过期', 'the verification code has expired', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (7, '20003', null, 'ht', '图形验证码错误', 'verification code error', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (8, '20004', null, 'ht', '登录身份已过期，请重新登录', 'token time out', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (9, '20005', null, 'ht', 'token不存在', 'token not exist', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (10, '21001', null, 'ht', '导入编码生成规则不存在', 'import code generation rule does not exist', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (11, '20006', null, 'ht', '用户或公司未授权，请联系客服！', 'the user or the company is not authorized, please contact customer service!', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (12, '20012', null, 'ht', '短信验证码已过期', 'the verification code has expired', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (13, '20013', null, 'ht', '短信验证码错误', 'the verification code has expired', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (14, '20007', null, 'ht', '非法的请求参数', '', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (15, '20008', null, 'ht', '区域编码已存在，请从新输入！', '', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (16, '20009', null, 'ht', '系统编码已存在，请从新输入！', '', null, null);
insert into  sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (17, '20015', null, 'ht', '表单重复提交', 'form duplicate submission', null, null);
--------------------------------------------------------------------------

--sqlserver
create table sys_tg_language (
id bigint not null,
lang_code varchar(450) default null,
description varchar(200) default null,
lang_type varchar(45) default null,
lang_1 varchar(100) default null,
lang_2 varchar(100) default null,
lang_3 varchar(100) default null,
lang_4 varchar(100) default null,
constraint pk_sys_tg_language primary key (id)
);
exec sp_addextendedproperty N'MS_Description', N'框架国际化语言配置表', N'SCHEMA', N'dbo',N'table', N'sys_tg_language';

insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (1, '10001', null, 'ht', '操作成功', 'success', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (2, '10002', null, 'ht', '登录成功', 'login success', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (3, '10003', null, 'ht', '退出成功', 'logout success', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (4, '10004', null, 'ht', '密码修改成功', 'password change success', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (5, '20001', null, 'ht', '操作失败', 'error', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (6, '20002', null, 'ht', '图形验证码已过期', 'the verification code has expired', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (7, '20003', null, 'ht', '图形验证码错误', 'verification code error', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (8, '20004', null, 'ht', '登录身份已过期，请重新登录', 'token time out', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (9, '20005', null, 'ht', 'token不存在', 'token not exist', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (10, '21001', null, 'ht', '导入编码生成规则不存在', 'import code generation rule does not exist', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (11, '20006', null, 'ht', '用户或公司未授权，请联系客服！', 'the user or the company is not authorized, please contact customer service!', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (12, '20012', null, 'ht', '短信验证码已过期', 'the verification code has expired', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (13, '20013', null, 'ht', '短信验证码错误', 'the verification code has expired', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (14, '20007', null, 'ht', '非法的请求参数', '', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (15, '20008', null, 'ht', '区域编码已存在，请从新输入！', '', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (16, '20009', null, 'ht', '系统编码已存在，请从新输入！', '', null, null);
insert into sys_tg_language (id, lang_code, description, lang_type, lang_1, lang_2, lang_3, lang_4) values (17, '20015', null, 'ht', '表单重复提交', 'form duplicate submission', null, null);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
上次更新: 2024/3/20 09:22:18
天宫EXCEL使用
内审功能

← 内审功能→

最近更新
01
EciReport模板导出_Core
09-10
02
EciReport模板导出
09-09
03
Core权限平台接口
07-25
更多文章>
Theme by Vdoing