HB_RTGK
/
sicuan_lims
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
sicuan_lims/sql/mysql/202311.sql

722 lines
69 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- ----------------------------- 2023-11-01 add by gaozq------------begin
delete from t_core_menu where MENUNAME in ('人员培训考核','上岗证项目表','培训考核编制','工程师审核','主管批准','培训负责人审核','人员技能','人员培训考核查询');
-- ----------------------------- 2023-11-01 add by gaozq------------end
-- ----------------------------- 2023-11-02 add by gaozq------------begin
alter table T_LIMS_FILE_DATA_COLLECT add column EQUIPTFILEACQID BIGINT null comment '设备采集文件id';
CALL INSERTI18N('T_LIMS_FILE_DATA_COLLECT.EQUIPTFILEACQID','设备采集文件id','设备采集文件id','zh-CN','设备采集文件id');
CALL INSERTI18N('T_LIMS_MATERIAL_BASIC.SUMREMAINAMOUNT', '总量', '总量', 'zh-CN', '总量');
alter table T_LIMS_MATERIAL_BASIC add column SUMLOWLIMIT BIGINT null comment '低限总量';
CALL INSERTI18N('T_LIMS_MATERIAL_BASIC.SUMLOWLIMIT','低限总量','低限总量','zh-CN','低限总量');
-- ----------------------------- 2023-11-02 add by gaozq------------end
-- ----------------------------- 2023-11-6 add by zhangs------------begin
CALL INSERTI18N('T_LIMS_FOLDER.ASSIGNFOLDERORGBTN', '分配检测组', '分配检测组', 'zh-CN', '分配检测组');
-- ----------------------------- 2023-11-6 add by zhangs------------end
-- ----------------------------- 2023-11-6 add by gaozq------------begin
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231106001,'MS2000','acqExector',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'MS2000AcqExector',NULL);
-- ----------------------------- 2023-11-6 add by gaozq------------end
-- ----------------------------- 2023-11-7 add by zhangs------------begin
update t_core_code_category set codeclassid='biz' where id='specimenType';
delete from t_core_code tccc where CODECATEGORYID ='specimenType';
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(20230426100,'短期质控','specimenType',NULL,10,0,'ADMIN','系统管理员',NULL,'0',NULL,NULL,NULL,'短期质控',NULL),
(20230426101,'长期质控','specimenType',NULL,20,0,'ADMIN','系统管理员',NULL,'0',NULL,NULL,NULL,'长期质控',NULL),
(20230426102,'标样质控','specimenType',NULL,30,0,'ADMIN','系统管理员',NULL,'0',NULL,NULL,NULL,'标样质控',NULL),
(2023110713461,'盲样质控','specimenType',NULL,40,0,'ADMIN','系统管理员',NULL,'0',NULL,NULL,NULL,'盲样质控',NULL);
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('T_LIMS_FOLDER.PRODUCTSTATUS', '产品技术状态', 'biz');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES (2023110714051, 'A样', 'A样', 1, 'T_LIMS_FOLDER.PRODUCTSTATUS', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES (2023110714052, 'B样', 'B样', 1, 'T_LIMS_FOLDER.PRODUCTSTATUS', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES (2023110714053, 'C样', 'C样', 1, 'T_LIMS_FOLDER.PRODUCTSTATUS', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES (2023110714054, 'D样', 'D样', 1, 'T_LIMS_FOLDER.PRODUCTSTATUS', 0, 'admin', '系统管理员', '0');
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2023110714581,'标样检测','folderCheckType',NULL,8,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'标样检测',NULL),
(2023110714582,'自制样检测','folderCheckType',NULL,9,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'自制样检测',NULL),
(2023110714583,'特殊送检','folderCheckType',NULL,10,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'特殊送检',NULL);
-- ----------------------------- 2023-11-7 add by zhangs------------end
-- ----------------------------- 2023-11-8 add by gaozq------------begin
alter table T_LIMS_ORDER add column SAMPLEQUALITY VARCHAR(60) null comment '样品质量';
CALL INSERTI18N('T_LIMS_ORDER.SAMPLEQUALITY','样品质量(kg)','样品质量(kg)','zh-CN','样品质量(kg)');
-- ----------------------------- 2023-11-8 add by gaozq------------end
-- ----------------------------- 2023-11-9 add by gaozq------------begin
alter table T_LIMS_EQUIPT add column COUNTMECHANISM VARCHAR(100) null comment '计量机构';
CALL INSERTI18N('T_LIMS_EQUIPT.COUNTMECHANISM','计量机构','计量机构','zh-CN','计量机构');
CALL INSERTI18N('T_CORE_SPECIAL_CHARACTER.PRONUNCIATION', '特殊字符表的字符简拼定义', '字符简拼定义', 'zh-CN', '字符简拼定义');
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231109001,'技术送检','T_LIMS_FOLDER.TESTSOURCE',NULL,5,0,'admin','系统管理员','2023-11-09 17:00:00.000','0',NULL,NULL,NULL,'技术送检',NULL),
(20231109002,'工艺送检','T_LIMS_FOLDER.TESTSOURCE',NULL,6,0,'admin','系统管理员','2023-11-09 17:00:00.000','0',NULL,NULL,NULL,'工艺送检',NULL);
-- ----------------------------- 2023-11-9 add by gaozq------------end
-- ----------------------------- 2023-11-9 add by zhangs------------begin
ALTER TABLE t_lims_task ADD TESTORDERNOS varchar(200) NULL COMMENT '试验下样品编号';
ALTER TABLE T_LIMS_ORDER ADD TESTNAMES varchar(480) NULL COMMENT '样品的试验';
update t_lims_task k JOIN (select tltm.ORDTASKID,group_concat(o.ORDNO) TESTORDERNOS from t_lims_test_matrix tltm,t_lims_order o where o.id=tltm.ORDERID and tltm.CHECKFLAG='1'
group by tltm.ORDTASKID) temp on temp.ORDTASKID=k.id set k.TESTORDERNOS=temp.TESTORDERNOS;
update T_LIMS_ORDER k JOIN (select tltm.orderid,group_concat(o.testname) TESTNAMES from t_lims_test_matrix tltm,t_lims_task o where o.id=tltm.ordtaskid and tltm.CHECKFLAG='1'
group by tltm.orderid) temp on temp.orderid=k.id set k.TESTNAMES=temp.TESTNAMES;
CALL INSERTI18N('T_LIMS_TASK.TESTORDERNOS','试验样品编号','试验样品编号','zh-CN','试验样品编号');
CALL INSERTI18N('T_LIMS_ORDER.TESTNAMES','样品试验名称','样品试验名称','zh-CN','样品试验名称');
INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
(202311091,'按样录入','按样录入','inputByOrder','/secure/basemodule/business/results/page/openInputByOrder','80%');
-- ----------------------------- 2023-11-9 add by zhangs------------end
-- ----------------------------- 2023-11-10 add by gaozq------------begin
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231110001,'金属颗粒','acqExector',NULL,NULL,NULL,'admin','系统管理员','2023-11-10 17:00:00.000','0',NULL,NULL,NULL,'JinshukeliAcqExector',NULL);
-- ----------------------------- 2023-11-10 add by gaozq------------end
-- ----------------------------- 2023-11-13 add by gaozq------------begin
INSERT INTO T_CORE_AUDIT_CONFIG (ID, NAME, CATEGORY, AUDITABLE)
VALUES ('T_LIMS_ORDER', '样品表', 'service', '1');
alter table T_LIMS_ORDER add column BAKEEQUIPT VARCHAR(60) null comment '烘烤设备';
alter table T_LIMS_ORDER add column COATEQUIPT VARCHAR(60) null comment '涂布设备';
alter table T_LIMS_ORDER add column WEIGHEQUIPT VARCHAR(60) null comment '称量设备';
alter table T_LIMS_ORDER add column HOMOGENATEEQUIPT VARCHAR(60) null comment '匀浆设备';
alter table T_LIMS_ORDER add column ACTIVEMATTERACTIVEMATTER VARCHAR(60) null comment '活性物质量';
alter table T_LIMS_ORDER add column CONDUCTIVEALQUALITY VARCHAR(60) null comment '导电胶质量';
alter table T_LIMS_ORDER add column CONDUCTIVEALNO VARCHAR(60) null comment '导电胶液批号';
alter table T_LIMS_ORDER add column COATUSERID VARCHAR(60) null comment '涂布人员id';
alter table T_LIMS_ORDER add column COATUSER VARCHAR(60) null comment '涂布人员';
alter table T_LIMS_ORDER add column INGREDIENTUSERID VARCHAR(60) null comment '配料人员id';
alter table T_LIMS_ORDER add column INGREDIENTUSER VARCHAR(60) null comment '配料人员';
alter table T_LIMS_ORDER add column INGREDIENTCLASSES VARCHAR(60) null comment '配料班次';
alter table T_LIMS_ORDER add column INGREDIENTDATE DATETIME null comment '配料日期';
alter table T_LIMS_ORDER add column POLEPIECENO BIGINT null comment '极片序号';
alter table T_LIMS_ORDER add column MEASUREDTHICKNESS VARCHAR(60) null comment '实测厚度 （um）';
CALL INSERTI18N('T_LIMS_ORDER.MEASUREDTHICKNESS','实测厚度 （um）','实测厚度 （um）','zh-CN','实测厚度 （um）');
CALL INSERTI18N('T_LIMS_ORDER.BAKEEQUIPT','烘烤设备','烘烤设备','zh-CN','烘烤设备');
CALL INSERTI18N('T_LIMS_ORDER.COATEQUIPT','涂布设备','涂布设备','zh-CN','涂布设备');
CALL INSERTI18N('T_LIMS_ORDER.WEIGHEQUIPT','称量设备','称量设备','zh-CN','称量设备');
CALL INSERTI18N('T_LIMS_ORDER.HOMOGENATEEQUIPT','匀浆设备','匀浆设备','zh-CN','匀浆设备');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERACTIVEMATTER','活性物质量','活性物质量','zh-CN','活性物质量');
CALL INSERTI18N('T_LIMS_ORDER.CONDUCTIVEALQUALITY','导电胶质量','导电胶质量','zh-CN','导电胶质量');
CALL INSERTI18N('T_LIMS_ORDER.CONDUCTIVEALNO','导电胶液批号','导电胶液批号','zh-CN','导电胶液批号');
CALL INSERTI18N('T_LIMS_ORDER.COATUSERID','涂布人员id','涂布人员id','zh-CN','涂布人员id');
CALL INSERTI18N('T_LIMS_ORDER.COATUSER','涂布人员','涂布人员','zh-CN','涂布人员');
CALL INSERTI18N('T_LIMS_ORDER.INGREDIENTUSERID','配料人员id','配料人员id','zh-CN','配料人员id');
CALL INSERTI18N('T_LIMS_ORDER.INGREDIENTUSER','配料人员','配料人员','zh-CN','配料人员');
CALL INSERTI18N('T_LIMS_ORDER.INGREDIENTCLASSES','配料班次','配料班次','zh-CN','配料班次');
CALL INSERTI18N('T_LIMS_ORDER.INGREDIENTDATE','配料日期','配料日期','zh-CN','配料日期');
CALL INSERTI18N('T_LIMS_ORDER.POLEPIECENO','极片序号','极片序号','zh-CN','极片序号');
alter table T_LIMS_ORDER add column WEIGHUSER VARCHAR(60) null comment '称重人员';
alter table T_LIMS_ORDER add column BAKEEQUIPT1 VARCHAR(60) null comment '中段烘烤设备';
alter table T_LIMS_ORDER add column COMPACTION8 VARCHAR(60) null comment '压实8（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION7 VARCHAR(60) null comment '压实7（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION6 VARCHAR(60) null comment '压实6（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION5 VARCHAR(60) null comment '压实5（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION4 VARCHAR(60) null comment '压实4（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION3 VARCHAR(60) null comment '压实3（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION2 VARCHAR(60) null comment '压实2（g/cm³）';
alter table T_LIMS_ORDER add column COMPACTION1 VARCHAR(60) null comment '压实1（g/cm³）';
alter table T_LIMS_ORDER add column AREALDENSITY8 VARCHAR(60) null comment '面密度8（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY7 VARCHAR(60) null comment '面密度7（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY6 VARCHAR(60) null comment '面密度6（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY5 VARCHAR(60) null comment '面密度5（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY4 VARCHAR(60) null comment '面密度4（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY3 VARCHAR(60) null comment '面密度3（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY2 VARCHAR(60) null comment '面密度2（mg/cm²）';
alter table T_LIMS_ORDER add column AREALDENSITY1 VARCHAR(60) null comment '面密度1（mg/cm²）';
alter table T_LIMS_ORDER add column MEANVALUE VARCHAR(60) null comment '实测空箔五片均值（mg）';
alter table T_LIMS_ORDER add column QUALITY7 VARCHAR(60) null comment '质量7 （mg）';
alter table T_LIMS_ORDER add column QUALITY8 VARCHAR(60) null comment '质量8 （mg）';
alter table T_LIMS_ORDER add column QUALITY6 VARCHAR(60) null comment '质量6 （mg）';
alter table T_LIMS_ORDER add column QUALITY5 VARCHAR(60) null comment '质量5 （mg）';
alter table T_LIMS_ORDER add column QUALITY4 VARCHAR(60) null comment '质量4 （mg）';
alter table T_LIMS_ORDER add column QUALITY3 VARCHAR(60) null comment '质量3 （mg）';
alter table T_LIMS_ORDER add column QUALITY2 VARCHAR(60) null comment '质量2 （mg）';
alter table T_LIMS_ORDER add column PUNCHINGEQUIPT VARCHAR(60) null comment '冲片设备';
alter table T_LIMS_ORDER add column QUALITY1 VARCHAR(60) null comment '质量1 （mg）';
alter table T_LIMS_ORDER add column ROLLINEQUIPT VARCHAR(60) null comment '辊压设备';
alter table T_LIMS_ORDER add column WEIGHEQUIPT1 VARCHAR(60) null comment '称量设备';
alter table T_LIMS_ORDER add column WEIGHCLASSES VARCHAR(60) null comment '称重班次';
alter table T_LIMS_ORDER add column WEIGHUSERID VARCHAR(60) null comment '称重人员id';
alter table T_LIMS_ORDER add column WEIGHDATE DATETIME null comment '称重日期';
CALL INSERTI18N('T_LIMS_ORDER.WEIGHUSER','称重人员','称重人员','zh-CN','称重人员');
CALL INSERTI18N('T_LIMS_ORDER.BAKEEQUIPT1','中段烘烤设备','中段烘烤设备','zh-CN','中段烘烤设备');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION8','压实8（g/cm³）','压实8（g/cm³）','zh-CN','压实8（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION7','压实7（g/cm³）','压实7（g/cm³）','zh-CN','压实7（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION6','压实6（g/cm³）','压实6（g/cm³）','zh-CN','压实6（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION5','压实5（g/cm³）','压实5（g/cm³）','zh-CN','压实5（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION4','压实4（g/cm³）','压实4（g/cm³）','zh-CN','压实4（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION3','压实3（g/cm³）','压实3（g/cm³）','zh-CN','压实3（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION2','压实2（g/cm³）','压实2（g/cm³）','zh-CN','压实2（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.COMPACTION1','压实1（g/cm³）','压实1（g/cm³）','zh-CN','压实1（g/cm³）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY8','面密度8（mg/cm²）','面密度8（mg/cm²）','zh-CN','面密度8（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY7','面密度7（mg/cm²）','面密度7（mg/cm²）','zh-CN','面密度7（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY6','面密度6（mg/cm²）','面密度6（mg/cm²）','zh-CN','面密度6（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY5','面密度5（mg/cm²）','面密度5（mg/cm²）','zh-CN','面密度5（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY4','面密度4（mg/cm²）','面密度4（mg/cm²）','zh-CN','面密度4（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY3','面密度3（mg/cm²）','面密度3（mg/cm²）','zh-CN','面密度3（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY2','面密度2（mg/cm²）','面密度2（mg/cm²）','zh-CN','面密度2（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.AREALDENSITY1','面密度1（mg/cm²）','面密度1（mg/cm²）','zh-CN','面密度1（mg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.MEANVALUE','实测空箔五片均值（mg）','实测空箔五片均值（mg）','zh-CN','实测空箔五片均值（mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY7','质量7 （mg）','质量7 （mg）','zh-CN','质量7 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY8','质量8 （mg）','质量8 （mg）','zh-CN','质量8 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY6','质量6 （mg）','质量6 （mg）','zh-CN','质量6 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY5','质量5 （mg）','质量5 （mg）','zh-CN','质量5 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY4','质量4 （mg）','质量4 （mg）','zh-CN','质量4 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY3','质量3 （mg）','质量3 （mg）','zh-CN','质量3 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY2','质量2 （mg）','质量2 （mg）','zh-CN','质量2 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.PUNCHINGEQUIPT','冲片设备','冲片设备','zh-CN','冲片设备');
CALL INSERTI18N('T_LIMS_ORDER.QUALITY1','质量1 （mg）','质量1 （mg）','zh-CN','质量1 （mg）');
CALL INSERTI18N('T_LIMS_ORDER.ROLLINEQUIPT','辊压设备','辊压设备','zh-CN','辊压设备');
CALL INSERTI18N('T_LIMS_ORDER.WEIGHEQUIPT1','称量设备','称量设备','zh-CN','称量设备');
CALL INSERTI18N('T_LIMS_ORDER.WEIGHCLASSES','称重班次','称重班次','zh-CN','称重班次');
CALL INSERTI18N('T_LIMS_ORDER.WEIGHUSERID','称重人员id','称重人员id','zh-CN','称重人员id');
CALL INSERTI18N('T_LIMS_ORDER.WEIGHDATE','称重日期','称重日期','zh-CN','称重日期');
alter table T_LIMS_ORDER add column HANGUPTESTUSERID VARCHAR(60) null comment '挂测人员id';
alter table T_LIMS_ORDER add column POWER3 VARCHAR(60) null comment '功率 1.0P mW';
alter table T_LIMS_ORDER add column POWER2 VARCHAR(60) null comment '功率 0.5P mW';
alter table T_LIMS_ORDER add column POWER1 VARCHAR(60) null comment '功率 0.1P mW';
alter table T_LIMS_ORDER add column HANGUPTESTSTEP VARCHAR(60) null comment '挂测工步';
alter table T_LIMS_ORDER add column HANGUPTESTCLASSES VARCHAR(60) null comment '挂测班次';
alter table T_LIMS_ORDER add column HANGUPTESTDATE DATETIME null comment '挂测日期';
alter table T_LIMS_ORDER add column HANGUPTESTUSER VARCHAR(60) null comment '挂测人员';
alter table T_LIMS_ORDER add column SEALPRESSURE VARCHAR(60) null comment '封口压力（kg/cm²）';
alter table T_LIMS_ORDER add column SEALEQUIPT VARCHAR(60) null comment '封口设备';
alter table T_LIMS_ORDER add column OXYGEN VARCHAR(60) null comment '氧含量（ppm）';
alter table T_LIMS_ORDER add column WATER VARCHAR(60) null comment '水含量（ppm）';
alter table T_LIMS_ORDER add column MOUNTEQUIPT VARCHAR(60) null comment '组装设备';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY8 VARCHAR(60) null comment '活性物质量8（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY7 VARCHAR(60) null comment '活性物质量7（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY6 VARCHAR(60) null comment '活性物质量6（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY5 VARCHAR(60) null comment '活性物质量5（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY4 VARCHAR(60) null comment '活性物质量4（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY3 VARCHAR(60) null comment '活性物质量3（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY2 VARCHAR(60) null comment '活性物质量2（mg）';
alter table T_LIMS_ORDER add column ACTIVEMATTERQUALITY1 VARCHAR(60) null comment '活性物质量1（mg）';
alter table T_LIMS_ORDER add column ELECTROLYTENO VARCHAR(60) null comment '电解液批号';
alter table T_LIMS_ORDER add column ELECTROLYTEMODEL VARCHAR(60) null comment '电解液型号';
alter table T_LIMS_ORDER add column PACKAGECLASSES VARCHAR(60) null comment '组装班次';
alter table T_LIMS_ORDER add column PACKAGEDATE DATETIME null comment '组装日期';
alter table T_LIMS_ORDER add column PACKAGEUSERID VARCHAR(60) null comment '组装人员id';
alter table T_LIMS_ORDER add column PACKAGEUSER VARCHAR(60) null comment '组装人员';
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTUSERID','挂测人员id','挂测人员id','zh-CN','挂测人员id');
CALL INSERTI18N('T_LIMS_ORDER.POWER3','功率 1.0P mW','功率 1.0P mW','zh-CN','功率 1.0P mW');
CALL INSERTI18N('T_LIMS_ORDER.POWER2','功率 0.5P mW','功率 0.5P mW','zh-CN','功率 0.5P mW');
CALL INSERTI18N('T_LIMS_ORDER.POWER1','功率 0.1P mW','功率 0.1P mW','zh-CN','功率 0.1P mW');
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTSTEP','挂测工步','挂测工步','zh-CN','挂测工步');
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTCLASSES','挂测班次','挂测班次','zh-CN','挂测班次');
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTDATE','挂测日期','挂测日期','zh-CN','挂测日期');
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTUSER','挂测人员','挂测人员','zh-CN','挂测人员');
CALL INSERTI18N('T_LIMS_ORDER.SEALPRESSURE','封口压力（kg/cm²）','封口压力（kg/cm²）','zh-CN','封口压力（kg/cm²）');
CALL INSERTI18N('T_LIMS_ORDER.SEALEQUIPT','封口设备','封口设备','zh-CN','封口设备');
CALL INSERTI18N('T_LIMS_ORDER.OXYGEN','氧含量（ppm）','氧含量（ppm）','zh-CN','氧含量（ppm）');
CALL INSERTI18N('T_LIMS_ORDER.WATER','水含量（ppm）','水含量（ppm）','zh-CN','水含量（ppm）');
CALL INSERTI18N('T_LIMS_ORDER.MOUNTEQUIPT','组装设备','组装设备','zh-CN','组装设备');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY8','活性物质量8（mg）','活性物质量8（mg）','zh-CN','活性物质量8（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY7','活性物质量7（mg）','活性物质量7（mg）','zh-CN','活性物质量7（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY6','活性物质量6（mg）','活性物质量6（mg）','zh-CN','活性物质量6（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY5','活性物质量5（mg）','活性物质量5（mg）','zh-CN','活性物质量5（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY4','活性物质量4（mg）','活性物质量4（mg）','zh-CN','活性物质量4（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY3','活性物质量3（mg）','活性物质量3（mg）','zh-CN','活性物质量3（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY2','活性物质量2（mg）','活性物质量2（mg）','zh-CN','活性物质量2（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ACTIVEMATTERQUALITY1','活性物质量1（mg）','活性物质量1（mg）','zh-CN','活性物质量1（mg）');
CALL INSERTI18N('T_LIMS_ORDER.ELECTROLYTENO','电解液批号','电解液批号','zh-CN','电解液批号');
CALL INSERTI18N('T_LIMS_ORDER.ELECTROLYTEMODEL','电解液型号','电解液型号','zh-CN','电解液型号');
CALL INSERTI18N('T_LIMS_ORDER.PACKAGECLASSES','组装班次','组装班次','zh-CN','组装班次');
CALL INSERTI18N('T_LIMS_ORDER.PACKAGEDATE','组装日期','组装日期','zh-CN','组装日期');
CALL INSERTI18N('T_LIMS_ORDER.PACKAGEUSERID','组装人员id','组装人员id','zh-CN','组装人员id');
CALL INSERTI18N('T_LIMS_ORDER.PACKAGEUSER','组装人员','组装人员','zh-CN','组装人员');
-- ----------------------------- 2023-11-13 add by gaozq------------end
-- ----------------------------- 2023-11-14 add by gaozq------------begin
alter table T_LIMS_TASK add column TESTTYPE VARCHAR(60) null comment '检测项目类型';
CALL INSERTI18N('T_LIMS_TASK.TESTTYPE','检测项目类型','检测项目类型','zh-CN','检测项目类型');
alter table T_LIMS_TEST_OUTLINE_DETAIL add column TESTTYPE VARCHAR(60) null comment '检测项目类型';
CALL INSERTI18N('T_LIMS_TEST_OUTLINE_DETAIL.TESTTYPE','检测项目类型','检测项目类型','zh-CN','检测项目类型');
CALL INSERTI18N('T_CORE_PASSWORD_POLICY.COMPOSITION', '密码策略的不同类型组成的数量', '不同类型组成的数量', 'zh-CN', '不同类型组成的数量');
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('20230922010', '样品管理', 'T_LIMS_ORDER', 'audit_def', '1');
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231115001,'ICP','acqExector',NULL,NULL,NULL,'admin','系统管理员1','2023-11-15 17:00:00.000','0',NULL,NULL,NULL,'ICPAcqExector',NULL);
-- ----------------------------- 2023-11-14 add by gaozq------------end
-- ----------------------------- 2023-11-16 add by gaozq------------begin
alter table T_LIMS_ORDER add column KDSTATUS VARCHAR(60) null comment '扣电工艺处理状态';
CALL INSERTI18N('T_LIMS_ORDER.KDSTATUS','扣电工艺处理状态','扣电工艺处理状态','zh-CN','扣电工艺处理状态');
-- ----------------------------- 2023-11-16 add by gaozq------------end
-- ----------------------------- 2023-11-20 add by gaozq------------begin
alter table T_LIMS_TASK add column STOPREASON VARCHAR(120) null comment '终止原因';
CALL INSERTI18N('T_LIMS_TASK.STOPREASON','终止原因','终止原因','zh-CN','终止原因');
INSERT INTO T_CORE_SCHEDULE_TASK (ID, TASKNAME, SERVICENAME, METHODNAME, TYPE)
VALUES ('equipCalibrateTimeTask', '设备校准计划', 'com.sunwayworld.basemodule.trm.equipt.equipcalibrate.service.impl.LimsEquipCalibratePlanServiceImpl', 'equipCalibrateTimeTask', 'service');
INSERT INTO T_CORE_SCHEDULE_TASK(ID, TASKNAME, SERVICENAME, METHODNAME, REMARK, CREATEDBYID,
CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME, TYPE,
IFEXECUTABLESERVICENAME, IFEXECUTABLEMETHODNAME)
VALUES ('EquipCalibrationRemindTask', '设备校准提醒',
'com.sunwayworld.basemodule.trm.equipt.equipcalibrate.service.impl.LimsEquipCalibratePlanServiceImpl', 'check',
'检查设备校准是否进入提醒阶段', NULL, NULL, NULL, NULL, NULL, 'service', NULL, NULL);
CALL INSERTI18N('T_LIMS_EQUIPT.LASTMAINTENANCEDATE','上次维修日期','上次维修日期','zh-CN','上次维修日期');
-- ----------------------------- 2023-11-20 add by gaozq------------end
-- ----------------------------- 2023-11-21 add by gaozq------------begin
INSERT INTO T_CORE_SCHEDULE_TASK (ID, TASKNAME, SERVICENAME, METHODNAME, TYPE)
VALUES ('equipVerificationTimeTask', '设备期间核查计划', 'com.sunwayworld.basemodule.trm.equipt.equipverification.service.impl.LimsEquipVerificationPlanServiceImpl', 'equipVerificationTimeTask', 'service');
INSERT INTO T_CORE_SCHEDULE_TASK(ID, TASKNAME, SERVICENAME, METHODNAME, REMARK, CREATEDBYID,
CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME, TYPE,
IFEXECUTABLESERVICENAME, IFEXECUTABLEMETHODNAME)
VALUES ('EquipVerificationRemindTask', '设备期间核查提醒',
'com.sunwayworld.basemodule.trm.equipt.equipverification.service.impl.LimsEquipVerificationPlanServiceImpl', 'check',
'检查设备期间核查是否进入提醒阶段', NULL, NULL, NULL, NULL, NULL, 'service', NULL, NULL);
alter table T_LIMS_SPECIMEN add column TESTUSERID VARCHAR(36) null comment '测试人id';
alter table T_LIMS_SPECIMEN add column AUDITORID VARCHAR(36) null comment '审核人id';
alter table T_LIMS_SPECIMEN add column EQUIPTID BIGINT null comment '测试设备id';
alter table T_LIMS_SPECIMEN add column EQUIPTCODE VARCHAR(36) null comment '测试设备编码';
alter table T_LIMS_SPECIMEN add column EQUIPTNAME VARCHAR(36) null comment '测试设备名称';
alter table T_LIMS_SPECIMEN add column TESTTYPE VARCHAR(36) null comment '检测项目二级分类';
alter table T_LIMS_SPECIMEN add column TESTPARAMETER VARCHAR(100) null comment '测试参数确认';
alter table T_LIMS_SPECIMEN add column TESTTIME DATETIME null comment '测试时间';
alter table T_LIMS_SPECIMEN add column ABNORMALCAUSE VARCHAR(300) null comment '异常原因';
alter table T_LIMS_SPECIMEN add column JUDGE VARCHAR(100) null comment '判定';
alter table T_LIMS_SPECIMEN add column AUDITOR VARCHAR(36) null comment '审核人';
alter table T_LIMS_SPECIMEN add column TESTUSER VARCHAR(36) null comment '测试人';
alter table T_LIMS_SPECIMEN add column QUALITYCONTROLFREQUENCY VARCHAR(36) null comment '质控频次';
alter table T_LIMS_SPECIMEN add column QUALITYCONTROLWAY VARCHAR(36) null comment '质控方式';
CALL INSERTI18N('T_LIMS_SPECIMEN.TESTUSERID','测试人id','测试人id','zh-CN','测试人id');
CALL INSERTI18N('T_LIMS_SPECIMEN.AUDITORID','审核人id','审核人id','zh-CN','审核人id');
CALL INSERTI18N('T_LIMS_SPECIMEN.EQUIPTID','测试设备id','测试设备id','zh-CN','测试设备id');
CALL INSERTI18N('T_LIMS_SPECIMEN.EQUIPTCODE','测试设备编码','测试设备编码','zh-CN','测试设备编码');
CALL INSERTI18N('T_LIMS_SPECIMEN.EQUIPTNAME','测试设备名称','测试设备名称','zh-CN','测试设备名称');
CALL INSERTI18N('T_LIMS_SPECIMEN.TESTTYPE','检测项目二级分类','检测项目二级分类','zh-CN','检测项目二级分类');
CALL INSERTI18N('T_LIMS_SPECIMEN.TESTPARAMETER','测试参数确认','测试参数确认','zh-CN','测试参数确认');
CALL INSERTI18N('T_LIMS_SPECIMEN.TESTTIME','测试时间','测试时间','zh-CN','测试时间');
CALL INSERTI18N('T_LIMS_SPECIMEN.ABNORMALCAUSE','异常原因','异常原因','zh-CN','异常原因');
CALL INSERTI18N('T_LIMS_SPECIMEN.JUDGE','判定','判定','zh-CN','判定');
CALL INSERTI18N('T_LIMS_SPECIMEN.AUDITOR','审核人','审核人','zh-CN','审核人');
CALL INSERTI18N('T_LIMS_SPECIMEN.TESTUSER','测试人','测试人','zh-CN','测试人');
CALL INSERTI18N('T_LIMS_SPECIMEN.QUALITYCONTROLFREQUENCY','质控频次(天)','质控频次(天)','zh-CN','质控频次(天)');
CALL INSERTI18N('T_LIMS_SPECIMEN.QUALITYCONTROLWAY','质控方式','质控方式','zh-CN','质控方式');
CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.SHORUPPER','上限值','上限值','zh-CN','上限值');
CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.SHORLOWER','下限值','下限值','zh-CN','下限值');
alter table T_LIMS_SPECIMEN add column SENDSAMPLEBATCHNO VARCHAR(36) null comment '来样批次';
alter table T_LIMS_SPECIMEN add column CHANNELCODE VARCHAR(36) null comment '通道号';
CALL INSERTI18N('T_LIMS_SPECIMEN.SENDSAMPLEBATCHNO','来样批次','来样批次','zh-CN','来样批次');
CALL INSERTI18N('T_LIMS_SPECIMEN.CHANNELCODE','通道号','通道号','zh-CN','通道号');
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES
('qualityControlWay','质控方式','biz',NULL,1,NULL,NULL,NULL,NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231121001,'标准质控','qualityControlWay',NULL,NULL,NULL,'admin','系统管理员1','2023-11-21 17:00:00.000','0',NULL,NULL,NULL,'标准质控',NULL),
(20231121002,'盲样质控','qualityControlWay',NULL,NULL,NULL,'admin','系统管理员1','2023-11-21 17:00:00.000','0',NULL,NULL,NULL,'盲样质控',NULL),
(20231121003,'短期质控','qualityControlWay',NULL,NULL,NULL,'admin','系统管理员1','2023-11-21 17:00:00.000','0',NULL,NULL,NULL,'短期质控',NULL),
(20231121004,'长期质控','qualityControlWay',NULL,NULL,NULL,'admin','系统管理员1','2023-11-21 17:00:00.000','0',NULL,NULL,NULL,'长期质控',NULL);
-- ----------------------------- 2023-11-21 add by gaozq------------end
-- ----------------------------- 2023-11-22 add by gaozq------------end
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122001,'其它','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'其它',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122002,'成品','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'成品',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122003,'原材料','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'原材料',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122004,'过程样','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'过程样',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122005,'标准样','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'标准样',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122006,'自选样','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'自选样',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122007,'标准溶液','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'标准溶液',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122008,'对标样','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'对标样',NULL);
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231122009,'竞品','folderCheckType',NULL,NULL,NULL,'admin','系统管理员1','2023-10-30 17:00:00.000','0',NULL,NULL,NULL,'竞品',NULL);
delete from t_core_code where codename in ('外部来样','平台测试','标样检测','自制样检测','特殊送检');
alter table T_LIMS_EQUIPT add column ADVANCEREMINDDAYS BIGINT null comment '提前提醒天数';
CALL INSERTI18N('T_LIMS_EQUIPT.ADVANCEREMINDDAYS','提前提醒天数','提前提醒天数','zh-CN','提前提醒天数');
-- ----------------------------- 2023-11-22 add by gaozq------------end
-- ----------------------------- 2023-11-23 add by gaozq------------end
alter table T_LIMS_FOLDER add column PROJECTLEADERID VARCHAR(36) null comment '项目负责人id';
alter table T_LIMS_FOLDER add column PROJECTLEADER VARCHAR(36) null comment '项目负责人';
CALL INSERTI18N('T_LIMS_FOLDER.PROJECTLEADERID','项目负责人id','项目负责人id','zh-CN','项目负责人id');
CALL INSERTI18N('T_LIMS_FOLDER.PROJECTLEADER','项目负责人','项目负责人','zh-CN','项目负责人');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCALIBRATES.CAN_NOT_DELETE_EQUIP', '计划已启用, 不允许删除设备！', '计划已启用, 不允许删除设备！', 'zh-CN', '计划已启用, 不允许删除设备！');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPVERIFICATIONS.ALREADY_STARTED', '存在已启用', '存在已启用', 'zh-CN', '存在已启用');
alter table T_LIMS_EQUIPT add column ADVANCEREMINDDAYS1 BIGINT null comment '核查提前提醒天数';
alter table T_LIMS_EQUIPT add column VERIFICATIONCYCLE VARCHAR(36) null comment '期间核查周期';
CALL INSERTI18N('T_LIMS_EQUIPT.ADVANCEREMINDDAYS1','核查提前提醒天数','核查提前提醒天数','zh-CN','核查提前提醒天数');
CALL INSERTI18N('T_LIMS_EQUIPT.VERIFICATIONCYCLE','期间核查周期','期间核查周期','zh-CN','期间核查周期');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.LASTTIME', '设备期间核查记录的上次期间核查时间', '上次期间核查时间', 'zh-CN', '上次期间核查时间');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.NEXTTIME', '设备期间核查记录的下次期间核查时间', '下次期间核查时间', 'zh-CN', '下次期间核查时间');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.OPERATEDESC', '设备期间核查记录的执行描述', '执行描述', 'zh-CN', '执行描述');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.REMARK', '设备期间核查记录的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.COMPLETETIME', '设备期间核查记录的期间核查完成时间', '期间核查完成时间', 'zh-CN', '期间核查完成时间');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.OPERATOR', '设备期间核查记录的执行人', '执行人', 'zh-CN', '执行人');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.OPERATORID', '设备期间核查记录的执行人ID', '执行人ID', 'zh-CN', '执行人ID');
CALL INSERTI18N('T_LIMS_EQUIP_VERIFICATION_RECORD.COMMITTIME', '设备期间核查记录的提交时间', '提交时间', 'zh-CN', '提交时间');
-- ----------------------------- 2023-11-23 add by gaozq------------end
-- ----------------------------- 2023-11-23 add by zhangs------------begin
delete from t_core_code where id=202008241443;
ALTER TABLE t_lims_result MODIFY COLUMN ID BIGINT NOT NULL COMMENT '主键';
ALTER TABLE t_lims_result MODIFY COLUMN ANALYSTID BIGINT NULL COMMENT '静态分析项ID';
ALTER TABLE t_lims_result MODIFY COLUMN FOLDERID BIGINT NULL COMMENT '委托单ID';
ALTER TABLE t_lims_result MODIFY COLUMN TESTMATRIXID BIGINT NULL COMMENT '试验矩阵ID';
ALTER TABLE t_lims_result MODIFY COLUMN ORDTASKID BIGINT NULL COMMENT '检测项目ID';
ALTER TABLE t_lims_result MODIFY COLUMN ORDERID BIGINT NULL COMMENT '样品ID';
ALTER TABLE t_lims_result MODIFY COLUMN TESTMETHODID BIGINT NULL COMMENT '检测项目方法ID';
ALTER TABLE t_lims_result MODIFY COLUMN ORDERNO BIGINT NULL COMMENT '序号';
-- ----------------------------- 2023-11-23 add by zhangs------------end
-- ----------------------------- 2023-11-24 add by gaozq------------end
CALL INSERTI18N('T_LIMS_FOLDER.SPECIFICATION', '项目名称', '项目名称', 'zh-CN', '项目名称');
CALL INSERTI18N('T_LIMS_FOLDER.PRODUCTSTATUS', '工序名称', '工序名称', 'zh-CN', '工序名称');
-- ----------------------------- 2023-11-24 add by gaozq------------end
-- ----------------------------- 2023-11-27 add by gaozq------------end
alter table T_LIMS_FOLDER add column PRODUCTIONLINENAME VARCHAR(60) null comment '产线名称';
CALL INSERTI18N('T_LIMS_FOLDER.PRODUCTIONLINENAME','产线名称','产线名称','zh-CN','产线名称');
alter table t_lims_project_differentiation
modify CRITERIAID varchar(300) null comment '判异准则ID';
alter table T_LIMS_TASK add column CHECKENTRYTIME DATETIME null comment '结果复核通过时间';
CALL INSERTI18N('T_LIMS_TASK.CHECKENTRYTIME','结果复核通过时间','结果复核通过时间','zh-CN','结果复核通过时间');
-- ----------------------------- 2023-11-27 add by gaozq------------end
-- ----------------------------- 2023-11-27 add by zhangs------------begin
ALTER TABLE t_lims_report ADD REPORTTEMPLATEID bigint NULL COMMENT '报告模板id';
ALTER TABLE t_lims_report ADD REPORTTEMPLATENAME varchar(100) NULL COMMENT '报告模板名称';
ALTER TABLE t_lims_report ADD CREATEREPORTUSERID varchar(100) NULL COMMENT '报告生成人';
ALTER TABLE t_lims_report ADD CREATEREPORTUSERNAME varchar(100) NULL COMMENT '报告生成人';
ALTER TABLE t_lims_report ADD CREATEREPORTTIME datetime NULL;
ALTER TABLE t_lims_report ADD PROCESSSTATUS varchar(100) NULL COMMENT '工作流状态';
ALTER TABLE t_lims_report ADD FILEID bigint NULL COMMENT '报告文件ID';
ALTER TABLE t_lims_report ADD PDFFILEID bigint NULL COMMENT 'pdf文件ID';
ALTER TABLE t_lims_report ADD AUTOSIGN varchar(100) NULL COMMENT '自动报告';
ALTER TABLE t_lims_report ADD FOLDERIDS varchar(400) NULL COMMENT '多个委托单ID';
CALL INSERTI18N('GIKAM.BPMN.COMMENT.WITHDRAW', '撤回', '撤回', 'zh-CN', '撤回');
CALL INSERTI18N('GIKAM.EXCEPTION.DATALONG.COLUMN', '字段超出长度最大值!', '字段超出长度最大值!', 'zh-CN', '字段超出长度最大值!');
CALL INSERTI18N('GIKAM.EXCEPTION.ORDER.SENDSAMPLEBATCHNO.UK', '一个委托单只允许一个来样批次!', '一个委托单只允许一个来样批次!', 'zh-CN', '一个委托单只允许一个来样批次!');
CALL INSERTI18N('GIKAM.EXCEPTION.TIMED.OUT', '操作超时，请稍后重试！', '操作超时，请稍后重试！', 'zh-CN', '操作超时，请稍后重试！');
CALL INSERTI18N('GIKAM.EXCEPTION.NULLPOINTEREXCEPTION', '空指针异常，请联系管理员！', '空指针异常，请联系管理员！', 'zh-CN', '空指针异常，请联系管理员！');
CALL INSERTI18N('GIKAM.EXCEPTION.ILLEGALARGUMENTEXCEPTION', '参数异常，请联系管理员！', '参数异常，请联系管理员！', 'zh-CN', '参数异常，请联系管理员！');
CALL INSERTI18N('GIKAM.EXCEPTION.JSONEXCEPTION', '数据解析异常，请联系管理员！', '数据解析异常，请联系管理员！', 'zh-CN', '数据解析异常，请联系管理员！');
CALL INSERTI18N('GIKAM.EXCEPTION.INDEXOUTOFBOUNDSEXCEPTION', '数据越界异常，请联系管理员！', '数据越界异常，请联系管理员！', 'zh-CN', '数据越界异常，请联系管理员！');
CALL INSERTI18N('GIKAM.EXCEPTION.JSONEXCEPTION', '数据解析异常，请联系管理员！', '数据解析异常，请联系管理员！', 'zh-CN', '数据解析异常，请联系管理员！');
CALL INSERTI18N('GIKAM.EXCEPTION.SQLSYNTAXERROREXCEPTION', 'SQL语法异常，请联系管理员!', 'SQL语法异常，请联系管理员!', 'zh-CN', 'SQL语法异常，请联系管理员!');
CALL INSERTI18N('GIKAM.EXCEPTION.CannotGetJdbcConnectionException', '数据库连接异常，请联系管理员!', '数据库连接异常，请联系管理员!', 'zh-CN', '数据库连接异常，请联系管理员!');
CALL INSERTI18N('GIKAM.EXCEPTION.LOCKWAITTIMEOUT', '锁等待超时，请联系管理员!', '锁等待超时，请联系管理员!', 'zh-CN', '锁等待超时，请联系管理员!');
ALTER TABLE t_lims_order ADD CONSTRAINT t_lims_order_un UNIQUE KEY (ORDNO);
INSERT INTO t_core_menu_ext (ID,SERVICENAME,TABLENAME,`TYPE`,ENABLE,EXT) VALUES
('202311271','综合报告流程','T_LIMS_REPORT','audit_def','1',NULL);
INSERT INTO t_core_sequence (ID,PATTERN,JSONPARAM) VALUES
('T_LIMS_REPORT','[yyyy][mm][nnnnn]','[{"mm":"11","n":1,"yyyy":"2023"}]');
ALTER TABLE t_lims_report ADD REPORTNO varchar(100) NULL COMMENT '报告编号';
CALL INSERTI18N('T_LIMS_REPORT.REPORTNO', '报告编号', '报告编号', 'zh-CN', '报告编号');
-- ----------------------------- 2023-11-27 add by zhangs------------end
-- ----------------------------- 2023-11-28 add by zhangs------------begin
ALTER TABLE t_lims_task MODIFY COLUMN EQUIPTID varchar(600) NULL COMMENT '设备ID';
ALTER TABLE t_lims_task MODIFY COLUMN EQUIPTCODE varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '设备编号';
ALTER TABLE t_lims_task MODIFY COLUMN EQUIPTNAME varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '设备名称';
ALTER TABLE t_lims_equipt MODIFY COLUMN ID bigint NOT NULL COMMENT '主键';
ALTER TABLE t_lims_task ADD SPECIFICATION varchar(600) NULL;
-- ----------------------------- 2023-11-28 add by zhangs------------end-- ----------------------------- 2023-11-27 add by zhangs------------end
-- ----------------------------- 2023-11-28 add by gaozq------------begin
delete from t_core_code tccc where id ='202307190002';
-- ----------------------------- 2023-11-28 add by gaozq------------end
-- ----------------------------- 2023-11-28 add by zhangs------------begin
INSERT INTO t_lims_report_basic_item (ID,CATEGORYID,PARAMCODE,PARAMNAME,SORTER,CHOOSEPAGECONFIG) VALUES
(1266479609210240,'reportTemplateParam','FOLDERIDS','多委托单',4,NULL);
INSERT INTO t_lims_report_static_source (ID,SOURCECODE,PARENTSOURCECODE,SOURCENAME,SOURCETABLE,SOURCETYPE,`SQL`,PARAMTARGET,PARAM,REMARK,RESOLVEFUNCTION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,STATUS) VALUES
(1268596749128416,'summaryForm',NULL,'综合报告-表单数据','T_LIMS_FOLDER','detail','select t.* from(
select
T.*,
T.ID folderIds
from
T_LIMS_FOLDER T) t
',NULL,'{"FOLDERIDS_IN":"${FOLDERIDS}"}',NULL,'SummaryReportFormResoleFunction','zhangs','张胜','2023-11-27 16:06:42','RT','湖北融通高科先进材料股份有限公司','1'),
(1269108269002688,'sendSampleNoList',NULL,'综合报告-按样品批次','T_LIMS_FOLDER','list','select t.* from(
select
T.*,
T.ID folderIds
from
T_LIMS_FOLDER T) t
',NULL,'{"FOLDERIDS_IN":"${FOLDERIDS}"}',NULL,'SendSampleNoListResoleFunction','zhangs','张胜','2023-11-28 09:27:23','RT','湖北融通高科先进材料股份有限公司','1');
INSERT INTO t_lims_sql_data_resolve (ID,RESOLVEFUNCTION,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
(1268601499243232,'SummaryReportFormResoleFunction','综合报告-表单数据','zhangs','张胜','2023-11-27 16:16:21','RT','湖北融通高科先进材料股份有限公司'),
(1269108832366528,'SendSampleNoListResoleFunction','综合报告-批次列表数据','zhangs','张胜','2023-11-28 09:28:32','RT','湖北融通高科先进材料股份有限公司');
INSERT INTO t_lims_report_template (ID,TEMPLATECODE,TEMPLATENAME,TEMPLATETYPE,TEMPLATEFILEID,TEMPLATEFILENAME,TEMPLATEMODALTYPE,PARAM,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,ACTIVATEDFLAG,ACTIVATEDBYID,ACTIVATEDBYNAME,ACTIVATEDTIME,LAB,VERSIONNO) VALUES
(1266479048648064,'RT20231100001','综合报告模板','report',1269223697984832,'综合报告模板.docx','word','FOLDERIDS',NULL,'zhangs','张胜','2023-11-24 16:18:14','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.0');
INSERT INTO t_lims_report_template_source
(ID, TEMPLATEID, SOURCECODE, SOURCETYPE, `SQL`, PARAMTARGET, PARAM, REMARK, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME, SOURCENAME, SOURCETABLE, PARENTSOURCECODE, STATICSOURCEID)
VALUES(1268599042192096, 1266479048648064, 'summaryForm', 'detail', 'select t.* from(
select
T.*,
T.ID folderIds
from
T_LIMS_FOLDER T) t
', NULL, '{"FOLDERIDS_IN":"${FOLDERIDS}"}', NULL, 'zhangs', '张胜', '2023-11-27 00:00:00', 'RT', '湖北融通高科先进材料股份有限公司', '综合报告数-表单数据', 'T_LIMS_FOLDER', NULL, 1268596749128416);
INSERT INTO t_lims_report_template_source
(ID, TEMPLATEID, SOURCECODE, SOURCETYPE, `SQL`, PARAMTARGET, PARAM, REMARK, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME, SOURCENAME, SOURCETABLE, PARENTSOURCECODE, STATICSOURCEID)
VALUES(1269108984180672, 1266479048648064, 'sendSampleNoList', 'list', 'select t.* from(
select
T.*,
T.ID folderIds
from
T_LIMS_FOLDER T) t
', NULL, '{"FOLDERIDS_IN":"${FOLDERIDS}"}', NULL, 'zhangs', '张胜', '2023-11-28 00:00:00', 'RT', '湖北融通高科先进材料股份有限公司', '综合报告-按样品批次', 'T_LIMS_FOLDER', NULL, 1269108269002688);
INSERT INTO t_core_menu (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES
('20231122001','综合报告',NULL,'1002',6,'综合报告',NULL,NULL,NULL,'013.svg',NULL,NULL),
('20231124001','综合报告编制','/secure/basemodule/business/test/reports/page/edit-list?pageType=reportDraft','20231122001',1,'综合报告编制',NULL,NULL,NULL,'026.svg',NULL,NULL),
('20231124002','综合报告审核','/secure/basemodule/business/test/reports/page/edit-list?pageType=reportAudit','20231122001',2,'综合报告审核',NULL,NULL,NULL,'026.svg',NULL,NULL),
('20231124003','综合报告批准','/secure/basemodule/business/test/reports/page/edit-list?pageType=reportApprove','20231122001',3,'综合报告批准',NULL,NULL,NULL,'026.svg',NULL,NULL),
('20231124004','综合报告查询','/secure/basemodule/business/test/reports/page/edit-list?pageType=reportSearch','20231122001',4,'综合报告查询',NULL,NULL,NULL,'016.svg',NULL,NULL);
-- ----------------------------- 2023-11-28 add by zhangs------------end
-- ----------------------------- 2023-11-28 add by gaozq------------begin
delete from t_core_code tccc where id ='202307190002';
INSERT INTO t_core_code (id,codename,codecategoryid,remark,orderno,version,createdbyid,createdbyname,createdtime,lastsuspendedflag,lastsuspendedbyid,lastsuspendedbyname,lastsuspendedtime,code,i18ncode) VALUES
(20231128001,'马尔文3000粒度','acqExector',NULL,NULL,NULL,'admin','系统管理员1','2023-11-28 17:00:00.000','0',NULL,NULL,NULL,'MEW3000AcqExector',NULL);
-- ----------------------------- 2023-11-28 add by gaozq------------end
-- ----------------------------- 2023-11-29 add by gaozq------------begin
INSERT INTO T_CORE_SCHEDULE_TASK(id, taskname, servicename, methodname, type)
VALUES('EquiptFileAcqSchedule_10min', '设备文件采集定时任务_10min', 'com.sunwayworld.basemodule.trm.equipt.equiptfileacq.service.LimsEquiptFileAcqScheduleService', 'equiptDataAcqSchedule_10min', 'service');
alter table T_LIMS_TASK add column RESULTSTATUS1 VARCHAR(12) null comment '分析项结果是否异常';
alter table T_LIMS_TASK add column RESULTSTATUS VARCHAR(12) null comment '分析项是否录完标识';
CALL INSERTI18N('T_LIMS_TASK.RESULTSTATUS1','分析项结果是否异常','分析项结果是否异常','zh-CN','分析项结果是否异常');
CALL INSERTI18N('T_LIMS_TASK.RESULTSTATUS','分析项是否录完标识','分析项是否录完标识','zh-CN','分析项是否录完标识');
-- ----------------------------- 2023-11-29 add by gaozq------------end
-- ----------------------------- 2023-11-29 add by zhangs------------begin
update t_lims_result r join t_lims_tm_analyst t on r.ANALYSTID=t.ID
set r.ORDERNO=t.SORTER ;
CREATE TABLE IF NOT EXISTS `T_LIMS_ASYNCTASK`(
`ID` BIGINT NOT NULL COMMENT '主键',
`EXECSTATUS` VARCHAR(120) DEFAULT NULL COMMENT '执行状态',
`EXECCOUNT` BIGINT DEFAULT NULL COMMENT '直到成功的执行次数',
`EXECSTARTDATE` DATETIME DEFAULT NULL COMMENT '执行开始时间',
`EXECENDDATE` DATETIME DEFAULT NULL COMMENT '执行结束时间',
`JOINEDDATE` DATETIME DEFAULT NULL COMMENT '入线程池的时间',
`SERVERID` VARCHAR(36) DEFAULT NULL COMMENT '服务器ID',
`ERRMSG` LONGTEXT DEFAULT NULL COMMENT '执行错误的内容',
`QUEUEPROGRESS` BIGINT DEFAULT NULL COMMENT '报告任务等待排队的位数',
`TASKID` BIGINT DEFAULT NULL COMMENT '任务ID',
`TASKNAME` VARCHAR(120) DEFAULT NULL COMMENT '任务名称',
`EXECUTORNAME` VARCHAR(120) DEFAULT NULL COMMENT '任务执行器名称',
`JSONPARAM` VARCHAR(768) DEFAULT NULL COMMENT 'JSON格式的参数',
`SERVICEMETHOD` VARCHAR(512) DEFAULT NULL COMMENT '调用方法',
`TASKNAMEDESC` VARCHAR(520) DEFAULT NULL COMMENT '任务描述',
`TASKNOTIFY` VARCHAR(1) DEFAULT NULL COMMENT '是否提醒(0成功提醒,1失败提醒,2执行完提醒)',
`TASKNOTIFYTEMPLATEID` BIGINT DEFAULT NULL COMMENT '提醒模板ID',
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
`TASKUSERID` VARCHAR(60) DEFAULT NULL COMMENT '任务发起人ID',
`TASKUSERNAME` VARCHAR(120) DEFAULT NULL COMMENT '任务发起人名称',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='异步任务';
CALL INSERTI18N('T_LIMS_ASYNCTASK.SERVICE_NAME', '异步任务', '异步任务', 'zh-CN', '异步任务');
CALL INSERTI18N('T_LIMS_ASYNCTASK.ID', '异步任务的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ASYNCTASK.EXECSTATUS', '异步任务的执行状态', '执行状态', 'zh-CN', '执行状态');
CALL INSERTI18N('T_LIMS_ASYNCTASK.EXECCOUNT', '异步任务的直到成功的执行次数', '直到成功的执行次数', 'zh-CN', '直到成功的执行次数');
CALL INSERTI18N('T_LIMS_ASYNCTASK.EXECSTARTDATE', '异步任务的执行开始时间', '执行开始时间', 'zh-CN', '执行开始时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK.EXECENDDATE', '异步任务的执行结束时间', '执行结束时间', 'zh-CN', '执行结束时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK.JOINEDDATE', '异步任务的入线程池的时间', '入线程池的时间', 'zh-CN', '入线程池的时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK.SERVERID', '异步任务的服务器ID', '服务器ID', 'zh-CN', '服务器ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK.ERRMSG', '异步任务的执行错误的内容', '执行错误的内容', 'zh-CN', '执行错误的内容');
CALL INSERTI18N('T_LIMS_ASYNCTASK.QUEUEPROGRESS', '异步任务的报告任务等待排队的位数', '报告任务等待排队的位数', 'zh-CN', '报告任务等待排队的位数');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKID', '异步任务的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKNAME', '异步任务的任务名称', '任务名称', 'zh-CN', '任务名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK.EXECUTORNAME', '异步任务的任务执行器名称', '任务执行器名称', 'zh-CN', '任务执行器名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK.JSONPARAM', '异步任务的JSON格式的参数', 'JSON格式的参数', 'zh-CN', 'JSON格式的参数');
CALL INSERTI18N('T_LIMS_ASYNCTASK.SERVICEMETHOD', '异步任务的调用方法', '调用方法', 'zh-CN', '调用方法');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKNAMEDESC', '异步任务的任务描述', '任务描述', 'zh-CN', '任务描述');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKNOTIFY', '异步任务的是否提醒(0成功提醒,1失败提醒,2执行完提醒)', '是否提醒(0成功提醒,1失败提醒,2执行完提醒)', 'zh-CN', '是否提醒(0成功提醒,1失败提醒,2执行完提醒)');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKNOTIFYTEMPLATEID', '异步任务的提醒模板ID', '提醒模板ID', 'zh-CN', '提醒模板ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK.CREATEDBYID', '异步任务的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK.CREATEDBYNAME', '异步任务的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK.CREATEDTIME', '异步任务的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK.CREATEDBYORGID', '异步任务的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK.CREATEDBYORGNAME', '异步任务的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKUSERID', '异步任务的任务发起人ID', '任务发起人ID', 'zh-CN', '任务发起人ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKUSERNAME', '异步任务的任务发起人名称', '任务发起人名称', 'zh-CN', '任务发起人名称');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('11', '异步任务', '/secure/basemodule/common/asynctasks/page/edit-list', '11', '11', 'null', '异步任务');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('03', '异步任务查询', '/secure/basemodule/common/asynctasks/page/search-list', '11', '03', 'null', '异步任务查询');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_ASYNCTASK', '0', '0');
COMMIT;
update t_core_code set codename='自选样',code='自选样' where id=1264331809348416;
INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
(2023112916081,'设备通道','设备通道','equiptChannelChoose','/secure/basemodule/trm/equipt/equipt-channels/page/choose-list','80%');
ALTER TABLE t_lims_specimen_item ADD METHODCODE varchar(100) NULL COMMENT '方法编码';
ALTER TABLE t_lims_specimen_item ADD METHODNAME varchar(100) NULL COMMENT '方法名称';
-- ----------------------------- 2023-11-29 add by zhangs------------end
-- ----------------------------- 2023-11-30 add by gzq------------begin
alter table t_lims_asynctask
modify TASKNOTIFYTEMPLATEID varchar(36) null comment '提醒模板ID';
alter table T_LIMS_ASYNCTASK add column TASKTYPE VARCHAR(120) null comment '任务类型';
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKTYPE','任务类型','任务类型','zh-CN','任务类型');
INSERT INTO T_CORE_CODE_CATEGORY(ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
VALUES ('asynctask.taskType', '任务类型', 'biz', NULL, 1, NULL, NULL, NULL, NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
VALUES(2022101618461,'报告生成','asynctask.taskType',NULL,1,0,'0',NULL,NULL,NULL,'报告生成','admin','管理员',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
VALUES(2022101618462,'转PDF','asynctask.taskType',NULL,2,0,'0',NULL,NULL,NULL,'转PDF','admin','管理员',NULL);
CALL INSERTI18N('T_LIMS_ASYNCTASK.TASKTYPE', '任务类型', '任务类型', 'zh-CN', '任务类型');
CALL INSERTI18N('LIMS_ASYNCTASK.BUTTON.ANALYSE', '异步任务统计', '异步任务统计', 'zh-CN', '异步任务统计');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SERVICE_NAME', '异步任务服务节点', '异步任务服务节点', 'zh-CN', '异步任务服务节点');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.ID', '异步任务服务节点的节点ID', '节点ID', 'zh-CN', '节点ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.ENABLE', '异步任务服务节点的启用', '启用', 'zh-CN', '启用');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.NAME', '异步任务服务节点的名称', '名称', 'zh-CN', '名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CPUTHRESHOLD', '异步任务服务节点的cpu告警阈值', 'cpu告警阈值', 'zh-CN', 'cpu告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.MEMORYTHRESHOLD', '异步任务服务节点的内存告警阈值', '内存告警阈值', 'zh-CN', '内存告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.DISKTHRESHOLD', '异步任务服务节点的磁盘告警阈值', '磁盘告警阈值', 'zh-CN', '磁盘告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SENDSERVERWARN', '异步任务服务节点的告警通知', '告警通知', 'zh-CN', '告警通知');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SENDSERVERWARNIMPL', '异步任务服务节点的告警通知实现', '告警通知实现', 'zh-CN', '告警通知实现');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.HEALTHURL', '异步任务服务节点的健康检查URL', '健康检查URL', 'zh-CN', '健康检查URL');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYID', '异步任务服务节点的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYNAME', '异步任务服务节点的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDTIME', '异步任务服务节点的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYORGID', '异步任务服务节点的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYORGNAME', '异步任务服务节点的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.SERVICE_NAME', '异步任务服务线程池', '异步任务服务线程池', 'zh-CN', '异步任务服务线程池');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.ID', '异步任务服务线程池的ID', 'ID', 'zh-CN', 'ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.EXECUTORID', '异步任务服务线程池的任务执行器ID', '任务执行器ID', 'zh-CN', '任务执行器ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.NAME', '异步任务服务线程池的任务执行器名称', '任务执行器名称', 'zh-CN', '任务执行器名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.SERVERID', '异步任务服务线程池的异步任务服务节点ID', '异步任务服务节点ID', 'zh-CN', '异步任务服务节点ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.ENABLE', '异步任务服务线程池的启用', '启用', 'zh-CN', '启用');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.TASKEXECUTECALLBACK', '异步任务服务线程池的任务执行完毕的回调service', '任务执行完毕的回调service', 'zh-CN', '任务执行完毕的回调service');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.COREPOOLSIZE', '异步任务服务线程池的核心线程数', '核心线程数', 'zh-CN', '核心线程数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.MAXPOOLSIZE', '异步任务服务线程池的最大线程数', '最大线程数', 'zh-CN', '最大线程数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.QUEUECAPACITY', '异步任务服务线程池的队列大小', '队列大小', 'zh-CN', '队列大小');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.EXECMAXCOUNT', '异步任务服务线程池的任务最大执行次数', '任务最大执行次数', 'zh-CN', '任务最大执行次数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYID', '异步任务服务线程池的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYNAME', '异步任务服务线程池的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDTIME', '异步任务服务线程池的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYORGID', '异步任务服务线程池的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYORGNAME', '异步任务服务线程池的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SERVICE_NAME', '异步任务服务节点', '异步任务服务节点', 'zh-CN', '异步任务服务节点');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.ID', '异步任务服务节点的节点ID', '节点ID', 'zh-CN', '节点ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.ENABLE', '异步任务服务节点的启用', '启用', 'zh-CN', '启用');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.NAME', '异步任务服务节点的名称', '名称', 'zh-CN', '名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CPUTHRESHOLD', '异步任务服务节点的cpu告警阈值', 'cpu告警阈值', 'zh-CN', 'cpu告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.MEMORYTHRESHOLD', '异步任务服务节点的内存告警阈值', '内存告警阈值', 'zh-CN', '内存告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.DISKTHRESHOLD', '异步任务服务节点的磁盘告警阈值', '磁盘告警阈值', 'zh-CN', '磁盘告警阈值');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SENDSERVERWARN', '异步任务服务节点的告警通知', '告警通知', 'zh-CN', '告警通知');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SENDSERVERWARNIMPL', '异步任务服务节点的告警通知实现', '告警通知实现', 'zh-CN', '告警通知实现');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.HEALTHURL', '异步任务服务节点的健康检查URL', '健康检查URL', 'zh-CN', '健康检查URL');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYID', '异步任务服务节点的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYNAME', '异步任务服务节点的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDTIME', '异步任务服务节点的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYORGID', '异步任务服务节点的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.CREATEDBYORGNAME', '异步任务服务节点的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.SERVICE_NAME', '异步任务服务线程池', '异步任务服务线程池', 'zh-CN', '异步任务服务线程池');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.ID', '异步任务服务线程池的ID', 'ID', 'zh-CN', 'ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.EXECUTORID', '异步任务服务线程池的任务执行器ID', '任务执行器ID', 'zh-CN', '任务执行器ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.NAME', '异步任务服务线程池的任务执行器名称', '任务执行器名称', 'zh-CN', '任务执行器名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.SERVERID', '异步任务服务线程池的异步任务服务节点ID', '异步任务服务节点ID', 'zh-CN', '异步任务服务节点ID');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.ENABLE', '异步任务服务线程池的启用', '启用', 'zh-CN', '启用');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.TASKEXECUTECALLBACK', '异步任务服务线程池的任务执行完毕的回调service', '任务执行完毕的回调service', 'zh-CN', '任务执行完毕的回调service');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.COREPOOLSIZE', '异步任务服务线程池的核心线程数', '核心线程数', 'zh-CN', '核心线程数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.MAXPOOLSIZE', '异步任务服务线程池的最大线程数', '最大线程数', 'zh-CN', '最大线程数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.QUEUECAPACITY', '异步任务服务线程池的队列大小', '队列大小', 'zh-CN', '队列大小');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.EXECMAXCOUNT', '异步任务服务线程池的任务最大执行次数', '任务最大执行次数', 'zh-CN', '任务最大执行次数');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYID', '异步任务服务线程池的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYNAME', '异步任务服务线程池的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDTIME', '异步任务服务线程池的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYORGID', '异步任务服务线程池的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SCHEDULE.CREATEDBYORGNAME', '异步任务服务线程池的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.COMMON.ASYNCTASKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
CALL INSERTI18N('T_LIMS_ASYNCTASK.USEMINUTES', '执行开始->结束(分钟)', '执行开始->结束(分钟)', 'zh-CN', '执行开始->结束(分钟)');
CALL INSERTI18N('T_LIMS_ASYNCTASK_SERVER.SERVERREGION', '节点所在区域', '节点所在区域', 'zh-CN', '节点所在区域');
CALL INSERTI18N('GIKAM.AT.ACTUATOR', '执行器(启用)', '执行器(启用)', 'zh-CN', '执行器(启用)');
CALL INSERTI18N('GIKAM.AT.ACTIVATE_NODE', '启用(节点)', '启用(节点)', 'zh-CN', '启用(节点)');
CALL INSERTI18N('GIKAM.AT.NODE_NAME', '节点名称', '节点名称', 'zh-CN', '节点名称');
-- ----------------------------- 2023-11-30 add by gzq------------end
Reference in New Issue View Git Blame Copy Permalink