
-- ----------------------------- 2024-03-1 add by zhangs--------------begin
ALTER TABLE t_lims_task ADD HANGUPTESTSCRIPT varchar(500) NULL COMMENT '挂测试验取值脚本';
CALL INSERTI18N('T_LIMS_TASK.HANGUPTESTSCRIPT', '取值脚本', '取值脚本', 'zh-CN', '取值脚本');

ALTER TABLE T_LIMS_TEST_OUTLINE_DETAIL ADD HANGUPTESTSCRIPT varchar(500) NULL COMMENT '挂测试验取值脚本';
CALL INSERTI18N('T_LIMS_TEST_OUTLINE_DETAIL.HANGUPTESTSCRIPT', '取值脚本', '取值脚本', 'zh-CN', '取值脚本');
-- ----------------------------- 2024-03-1 add by zhangs--------------end

-- ----------------------------- 2024-03-01 add by zhangs--------------begin

-- 建表语句

CREATE TABLE IF NOT EXISTS `T_LIMS_LANDIANRESULT`(
     `ID` BIGINT NOT NULL COMMENT '主键',
     `FOLDERID` BIGINT DEFAULT NULL COMMENT '委托ID',
     `FOLDERNO` VARCHAR(120)  DEFAULT NULL COMMENT '委托单编号',
     `ORDERID` BIGINT DEFAULT NULL COMMENT '样品ID',
     `ORDNO` VARCHAR(120)  DEFAULT NULL COMMENT '样品编号',
     `TASKID` BIGINT DEFAULT NULL COMMENT '流程试验ID',
     `TESTNAME` VARCHAR(120)  DEFAULT NULL COMMENT '检测项目名称',
     `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 '制单人单位名称',
     `BATTNO` VARCHAR(120)  DEFAULT NULL COMMENT '电池条码',
     `BATCHNO` VARCHAR(120)  DEFAULT NULL COMMENT '电池批号',
     `LANDIANTESTID` VARCHAR(120)  DEFAULT NULL COMMENT '蓝电测试ID',
     `VALUE` VARCHAR(60)  DEFAULT NULL COMMENT '测试值',
      PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='蓝电采集测试数据';


INSERT INTO T_CORE_AT_CONFIG (ID, AUDITTRAIL, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME)
VALUES ('T_LIMS_LANDIANRESULT', '1', 'zhangsheng', 'zhangsheng', NOW(), 'L005', '五行业');


INSERT INTO T_CORE_AUDIT_CONFIG (ID, NAME, CATEGORY, AUDITABLE)
VALUES ('T_LIMS_LANDIANRESULT', '蓝电采集测试数据', 'service', '1');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.SERVICE_NAME', '蓝电采集测试数据', '蓝电采集测试数据', 'zh-CN', '蓝电采集测试数据');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.ID', '蓝电采集测试数据的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.FOLDERID', '蓝电采集测试数据的委托ID', '委托ID', 'zh-CN', '委托ID');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.FOLDERNO', '蓝电采集测试数据的委托单编号', '委托单编号', 'zh-CN', '委托单编号');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.ORDERID', '蓝电采集测试数据的样品ID', '样品ID', 'zh-CN', '样品ID');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.ORDNO', '蓝电采集测试数据的样品编号', '样品编号', 'zh-CN', '样品编号');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.TASKID', '蓝电采集测试数据的流程试验ID', '流程试验ID', 'zh-CN', '流程试验ID');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.TESTNAME', '蓝电采集测试数据的检测项目名称', '检测项目名称', 'zh-CN', '检测项目名称');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CREATEDBYID', '蓝电采集测试数据的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CREATEDBYNAME', '蓝电采集测试数据的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CREATEDTIME', '蓝电采集测试数据的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CREATEDBYORGID', '蓝电采集测试数据的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.CREATEDBYORGNAME', '蓝电采集测试数据的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.BATTNO', '蓝电采集测试数据的电池条码', '电池条码', 'zh-CN', '电池条码');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.BATCHNO', '蓝电采集测试数据的电池批号', '电池批号', 'zh-CN', '电池批号');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.LANDIANTESTID', '蓝电采集测试数据的蓝电测试ID', '蓝电测试ID', 'zh-CN', '蓝电测试ID');
CALL INSERTI18N('T_LIMS_LANDIANRESULT.VALUE', '蓝电采集测试数据的测试值', '测试值', 'zh-CN', '测试值');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASK.LANDIANS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASK.LANDIANS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASK.LANDIANS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASK.LANDIANS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASK.LANDIANS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_LANDIANRESULT', '0', '0');

CREATE INDEX t_lims_landianresult_ORDERID_IDX USING BTREE ON t_lims_landianresult (ORDERID);
COMMIT;
CREATE INDEX t_lims_landianresult_FOLDERID_IDX USING BTREE ON t_lims_landianresult (FOLDERID);

ALTER TABLE T_LIMS_TASK ADD HANDUPOUTLINEIDS varchar(100) NULL COMMENT '参与挂测的大纲ID';
-- ----------------------------- 2024-03-01 add by zhangs------------end

-- ----------------------------- 2024-03-04 add by zhangs------------begin
INSERT INTO t_core_menu (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES
('20240304001','蓝电数据查询','/secure/basemodule/business/test/task/landianresults/page/landian/mongo/search','1001',24,'蓝电数据查询',NULL,NULL,NULL,'016.svg',NULL,NULL);
-- ----------------------------- 2024-03-04 add by zhangs------------end
-- ----------------------------- 2024-03-11 add by gaozq------------begin
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTSTEPNUM', '挂测数量', '挂测数量', 'zh-CN', '挂测数量');
CALL INSERTI18N('T_LIMS_ORDER.HANGUPTESTSTEP2NUM', '挂测2数量', '挂测2数量', 'zh-CN', '挂测2数量');
-- ----------------------------- 2024-03-11 add by gaozq------------end

-- ----------------------------- 2024-03-15 add by gaozq------------begin
CALL UPDATEI18N('T_LIMS_LIQUOR_TITRATION.CONFIGELEMENT', 'zh-CN', '配制标液名称');
-- ----------------------------- 2024-03-15 add by gaozq------------end

-- ----------------------------- 2024-03-25 add by zhangs------------begin
ALTER TABLE t_lims_task ADD CHECKTYPE varchar(100) NULL COMMENT '检验类型';
update t_lims_task k inner join  t_lims_folder f on f.id=k.FOLDERID  set k.CHECKTYPE=f.checktype;
-- ----------------------------- 2024-03-25 add by zhangs------------end




