53 lines
4.7 KiB
MySQL
53 lines
4.7 KiB
MySQL
|
-- ----------------------------- 2023-12-28 add by zhangs------------begin
|
||
|
|
ALTER TABLE t_lims_folder ADD SKIPAUDIT varchar(1) NULL;
|
||
|
|
-- ----------------------------- 2023-12-28 add by zhangs------------end
|
||
|
|
-- ----------------------------- 2024-01-23 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
|
||
|
|
(20240123001,'粉末电阻率','acqExector',NULL,NULL,NULL,'admin','系统管理员1','2024-01-23 17:00:00.000','0',NULL,NULL,NULL,'PowderAcqExector',NULL);
|
||
|
|
-- ----------------------------- 2024-01-23 add by gaozq------------end
|
||
|
|
|
||
|
|
-- ----------------------------- 2024-01-23 add by zhangs------------begin
|
||
|
|
ALTER TABLE t_lims_result ADD TESTID bigint NULL COMMENT '静态测试ID';
|
||
|
|
update t_lims_result r join t_lims_test_method c on c.id=r.TESTMETHODID
|
||
|
|
set r.testid=c.TESTID;
|
||
|
|
|
||
|
|
ALTER TABLE t_lims_order ADD SAMPLEBATCHREMARK varchar(100) NULL COMMENT '批次补充信息';
|
||
|
|
CALL INSERTI18N('T_LIMS_ORDER.SAMPLEBATCHREMARK', '批次补充信息', '批次补充信息', 'zh-CN', '批次补充信息');
|
||
|
|
|
||
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES
|
||
|
|
('sampleBatchRemark','批次补充信息','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
|
||
|
|
(2024012315111,'混料','sampleBatchRemark',NULL,10,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'混料',NULL),
|
||
|
|
(2024012315112,'粗磨','sampleBatchRemark',NULL,20,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'粗磨',NULL),
|
||
|
|
(2024012315113,'细磨','sampleBatchRemark',NULL,30,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'细磨',NULL),
|
||
|
|
(2024012315114,'喷雾','sampleBatchRemark',NULL,40,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'喷雾',NULL),
|
||
|
|
(2024012315115,'烧结','sampleBatchRemark',NULL,50,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'烧结',NULL),
|
||
|
|
(2024012315116,'粉碎','sampleBatchRemark',NULL,60,NULL,'admin','系统管理员1','2023-12-04 17:00:00.000','0',NULL,NULL,NULL,'粉碎',NULL);
|
||
|
|
-- ----------------------------- 2024-01-23 add by zhangs------------end
|
||
|
|
|
||
|
|
-- ----------------------------- 2024-01-24 add by zhangs------------begin
|
||
|
|
ALTER TABLE t_lims_folder ADD SAMPLECONFIRM varchar(1) NULL COMMENT '取样';
|
||
|
|
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLECONFIRM', '取样', '取样', 'zh-CN', '取样');
|
||
|
|
ALTER TABLE t_lims_folder ADD AUDITAGAIN varchar(1) NULL COMMENT '复审';
|
||
|
|
CALL INSERTI18N('T_LIMS_FOLDER.AUDITAGAIN', '复审', '复审', 'zh-CN', '复审');
|
||
|
|
|
||
|
|
INSERT INTO t_core_menu (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES
|
||
|
|
('20240124001','取样确认','/secure/basemodule/business/test/folders/page/edit-list?pageType=sampleConfirm','1001',1,'取样确认',NULL,NULL,NULL,'024.svg','027.png',NULL);
|
||
|
|
INSERT INTO t_core_todo_config (ID,NAME,MENUID,CATEGORY,ICON,INHERITPARAM,JSONPARAM,SERVICEMETHOD,ACTIVATEDFLAG,ACTIVATEDBYID,ACTIVATEDBYNAME,ACTIVATEDTIME,DESCEXPRESSION,ORDERNO,I18NCODE,VOICEWARNING,SELECTSQL) VALUES
|
||
|
|
(1309632986596000,'取样确认','20240124001','business','024.png','1','{"filterUser":"sampleConfirm","bpmn_statusCode":"sampleConfirm"}','com.sunwayworld.basemodule.business.test.folder.service.impl.LimsFolderServiceImpl.selectPagination','1','zhangs','张胜','2024-01-24 15:36:10',NULL,NULL,NULL,'1',NULL);
|
||
|
|
-- ----------------------------- 2024-01-24 add by zhangs------------end
|
||
|
|
|
||
|
|
-- ----------------------------- 2024-01-25 add by zhangs------------begin
|
||
|
|
ALTER TABLE t_lims_folder ADD TOORDERRECEIVETIME datetime NULL COMMENT '到样时间';
|
||
|
|
CALL INSERTI18N('T_LIMS_FOLDER.TOORDERRECEIVETIME', '到样时间', '到样时间', 'zh-CN', '到样时间');
|
||
|
|
update t_lims_folder s inner join (select replace(TARGETID,'T_LIMS_FOLDER$','') id,max(CREATEDTIME) CREATEDTIME from t_core_bpmn_comment tcbc where route like '%-> 样品接收%' group by replace(TARGETID,'T_LIMS_FOLDER$','')
|
||
|
|
) temp on temp.id=s.id set s.toOrderReceiveTime=temp.CREATEDTIME;
|
||
|
|
-- ----------------------------- 2024-01-25 add by zhangs------------end
|
||
|
|
-- ----------------------------- 2024-01-30 add by gaozq------------end
|
||
|
|
alter table T_LIMS_FILE_DATA_COLLECT add column PROCESSES VARCHAR(36) null comment '工序';
|
||
|
|
CALL INSERTI18N('T_LIMS_FILE_DATA_COLLECT.PROCESSES','工序','工序','zh-CN','工序');
|
||
|
|
-- ----------------------------- 2024-01-30 add by gaozq------------end
|
||
|
|
|
||
|
|
|