-- ----------------------------- 2022-09-06 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_FOLDER(
                              ID NUMBER NOT NULL,
                              CREATEDBYID VARCHAR2(36)  NULL,
                              CREATEDBYNAME VARCHAR2(60)  NULL,
                              CREATEDTIME DATE NULL,
                              CREATEDBYORGID VARCHAR2(36)  NULL,
                              CREATEDBYORGNAME VARCHAR2(270)  NULL,
                              PROCESSSTATUS VARCHAR2(36)  NULL,
                              ORGID VARCHAR2(36)  NULL,
                              ORGNAME VARCHAR2(270)  NULL,
                              FOLDERNO VARCHAR2(270)  NULL,
                              CLIENTUSERORGID VARCHAR2(36)  NULL,
                              CLIENTUSERORGNAME VARCHAR2(270)  NULL,
                              CLIENTUSERID VARCHAR2(36)  NULL,
                              CLIENTUSERNAME VARCHAR2(60)  NULL,
                              CLIENTUSEREMAIL VARCHAR2(60)  NULL,
                              CLIENTUSERPHONE VARCHAR2(60)  NULL,
                              SAMPLETYPE VARCHAR2(36)  NULL,
                              ESTIMATECOST NUMBER(8,2)  NULL,
                              CELLTYPE VARCHAR2(36)  NULL,
                              PURPOSES VARCHAR2(270)  NULL,
                              SAMPLEGROUPNUM NUMBER NULL,
                              SAMPLENUMPERGROUP NUMBER NULL,
                              MATERIALNAME VARCHAR2(270)  NULL,
                              MATERIALID NUMBER NULL,
                              MATERIALCODE VARCHAR2(270)  NULL,
                              SPECIMENID NUMBER NULL,
                              SPECIMENNAME VARCHAR2(270)  NULL,
                              SPECIMENCODE VARCHAR2(270)  NULL,
                              SAMPLENAME VARCHAR2(270)  NULL,
                              SAMPLECODE VARCHAR2 (270) NULL,
                              WORKSHOPSECTION VARCHAR2 (36) NULL,
                              CHECKTYPE VARCHAR2 (36) NULL,
                              TOTALINSPECTION NUMBER NULL,
                              PROVIDER VARCHAR2 (270) NULL,
                              SAMPLEHANDLETYPE VARCHAR2 (36) NULL,
                              QUALITYTYPE VARCHAR2 (36) NULL,
                              REMARKS VARCHAR2 (360) NULL,
                              URGENCYDEGREE VARCHAR2 (36) NULL,
                              LAB VARCHAR2 (36) NULL,
                              STATUS VARCHAR2 (36) NULL,
                              PROCESSCONTROLSTATUS VARCHAR2 (36) NULL
);
COMMENT ON TABLE T_LIMS_FOLDER IS '委托单表';
COMMENT ON COLUMN T_LIMS_FOLDER.ID IS '主键';
COMMENT ON COLUMN T_LIMS_FOLDER.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_FOLDER.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_FOLDER.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_FOLDER.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_FOLDER.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_FOLDER.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_FOLDER.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_FOLDER.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_FOLDER.FOLDERNO IS '委托单编号';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSERORGID IS '送检单位ID';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSERORGNAME IS '送检单位';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSERID IS '委托人ID';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSERNAME IS '委托人';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSEREMAIL IS '邮箱';
COMMENT ON COLUMN T_LIMS_FOLDER.CLIENTUSERPHONE IS '电话';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLETYPE IS '样品分类';
COMMENT ON COLUMN T_LIMS_FOLDER.ESTIMATECOST IS '预计费用(元)';
COMMENT ON COLUMN T_LIMS_FOLDER.CELLTYPE IS '电池类型';
COMMENT ON COLUMN T_LIMS_FOLDER.PURPOSES IS '生成用途';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLEGROUPNUM IS '样品分组数';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLENUMPERGROUP IS '每组样品数';
COMMENT ON COLUMN T_LIMS_FOLDER.MATERIALNAME IS '材料名称';
COMMENT ON COLUMN T_LIMS_FOLDER.MATERIALID IS '材料ID';
COMMENT ON COLUMN T_LIMS_FOLDER.MATERIALCODE IS '材料号';
COMMENT ON COLUMN T_LIMS_FOLDER.SPECIMENID IS '质控样ID';
COMMENT ON COLUMN T_LIMS_FOLDER.SPECIMENNAME IS '质控样名称';
COMMENT ON COLUMN T_LIMS_FOLDER.SPECIMENCODE IS '质控样号';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLENAME IS '样品名称';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLECODE IS '样品编号';
COMMENT ON COLUMN T_LIMS_FOLDER.WORKSHOPSECTION IS '工段';
COMMENT ON COLUMN T_LIMS_FOLDER.CHECKTYPE IS '检验类型';
COMMENT ON COLUMN T_LIMS_FOLDER.TOTALINSPECTION IS '送检总数';
COMMENT ON COLUMN T_LIMS_FOLDER.PROVIDER IS '供应商';
COMMENT ON COLUMN T_LIMS_FOLDER.SAMPLEHANDLETYPE IS '样品处理方式';
COMMENT ON COLUMN T_LIMS_FOLDER.QUALITYTYPE IS '质控样类型';
COMMENT ON COLUMN T_LIMS_FOLDER.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_FOLDER.URGENCYDEGREE IS '紧急程度';
COMMENT ON COLUMN T_LIMS_FOLDER.LAB IS '检测地点';
COMMENT ON COLUMN T_LIMS_FOLDER.STATUS IS '状态';

ALTER TABLE T_LIMS_FOLDER ADD CONSTRAINT PK_LIMS_FOLDER PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_FOLDER.SERVICE_NAME', '委托单表', '委托单表', 'zh-CN', '委托单表');
CALL INSERTI18N('T_LIMS_FOLDER.ID', '委托单表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_FOLDER.CREATEDBYID', '委托单表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_FOLDER.CREATEDBYNAME', '委托单表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_FOLDER.CREATEDTIME', '委托单表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_FOLDER.CREATEDBYORGID', '委托单表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_FOLDER.CREATEDBYORGNAME', '委托单表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_FOLDER.PROCESSSTATUS', '委托单表的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_FOLDER.ORGID', '委托单表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_FOLDER.ORGNAME', '委托单表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_FOLDER.FOLDERNO', '委托单表的委托单编号', '委托单编号', 'zh-CN', '委托单编号');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSERORGID', '委托单表的送检单位ID', '送检单位ID', 'zh-CN', '送检单位ID');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSERORGNAME', '委托单表的送检单位', '送检单位', 'zh-CN', '送检单位');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSERID', '委托单表的委托人ID', '委托人ID', 'zh-CN', '委托人ID');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSERNAME', '委托单表的委托人', '委托人', 'zh-CN', '委托人');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSEREMAIL', '委托单表的邮箱', '邮箱', 'zh-CN', '邮箱');
CALL INSERTI18N('T_LIMS_FOLDER.CLIENTUSERPHONE', '委托单表的电话', '电话', 'zh-CN', '电话');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLETYPE', '委托单表的样品分类', '样品分类', 'zh-CN', '样品分类');
CALL INSERTI18N('T_LIMS_FOLDER.ESTIMATECOST', '委托单表的预计费用(元)', '预计费用(元)', 'zh-CN', '预计费用(元)');
CALL INSERTI18N('T_LIMS_FOLDER.CELLTYPE', '委托单表的电池类型', '电池类型', 'zh-CN', '电池类型');
CALL INSERTI18N('T_LIMS_FOLDER.PURPOSES', '委托单表的生成用途', '生成用途', 'zh-CN', '生成用途');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLEGROUPNUM', '委托单表的样品分组数', '样品分组数', 'zh-CN', '样品分组数');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLENUMPERGROUP', '委托单表的每组样品数', '每组样品数', 'zh-CN', '每组样品数');
CALL INSERTI18N('T_LIMS_FOLDER.MATERIALNAME', '委托单表的材料名称', '材料名称', 'zh-CN', '材料名称');
CALL INSERTI18N('T_LIMS_FOLDER.MATERIALID', '委托单表的材料ID', '材料ID', 'zh-CN', '材料ID');
CALL INSERTI18N('T_LIMS_FOLDER.MATERIALCODE', '委托单表的材料号', '材料号', 'zh-CN', '材料号');
CALL INSERTI18N('T_LIMS_FOLDER.SPECIMENID', '委托单表的质控样ID', '质控样ID', 'zh-CN', '质控样ID');
CALL INSERTI18N('T_LIMS_FOLDER.SPECIMENNAME', '委托单表的质控样名称', '质控样名称', 'zh-CN', '质控样名称');
CALL INSERTI18N('T_LIMS_FOLDER.SPECIMENCODE', '委托单表的质控样号', '质控样号', 'zh-CN', '质控样号');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLENAME', '委托单表的样品名称', '样品名称', 'zh-CN', '样品名称');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLECODE', '委托单表的样品编号', '样品编号', 'zh-CN', '样品编号');
CALL INSERTI18N('T_LIMS_FOLDER.WORKSHOPSECTION', '委托单表的工段', '工段', 'zh-CN', '工段');
CALL INSERTI18N('T_LIMS_FOLDER.CHECKTYPE', '委托单表的检验类型', '检验类型', 'zh-CN', '检验类型');
CALL INSERTI18N('T_LIMS_FOLDER.TOTALINSPECTION', '委托单表的送检总数', '送检总数', 'zh-CN', '送检总数');
CALL INSERTI18N('T_LIMS_FOLDER.PROVIDER', '委托单表的供应商', '供应商', 'zh-CN', '供应商');
CALL INSERTI18N('T_LIMS_FOLDER.SAMPLEHANDLETYPE', '委托单表的样品处理方式', '样品处理方式', 'zh-CN', '样品处理方式');
CALL INSERTI18N('T_LIMS_FOLDER.QUALITYTYPE', '委托单表的质控样类型', '质控样类型', 'zh-CN', '质控样类型');
CALL INSERTI18N('T_LIMS_FOLDER.REMARKS', '委托单表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_FOLDER.URGENCYDEGREE', '委托单表的紧急程度', '紧急程度', 'zh-CN', '紧急程度');
CALL INSERTI18N('T_LIMS_FOLDER.LAB', '委托单表的检测地点', '检测地点', 'zh-CN', '检测地点');
CALL INSERTI18N('T_LIMS_FOLDER.STATUS', '委托单表的状态', '状态', 'zh-CN', '状态');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('10', '测试管理', '', 'null', '1', '001.svg', '测试管理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('1001', '检测业务流程', '', '10', '1', '001.svg', '检测业务流程');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100101', '委托单编制', '/secure/basemodule/business/test/folders/page/edit-list', '1001', '1', '001.svg', '委托单编制');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100102', '直接领导审核', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=DirectAudit', '1001', '2', '001.svg', '直接领导审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100103', '二级部门负责人审核', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=SecondAudit', '1001', '3', '001.svg', '二级部门负责人审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100104', '一级部门负责人审核', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=StairAudit', '1001', '4', '001.svg', '一级部门负责人审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100105', '检测组负责人审核', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=DetectionAudit', '1001', '5', '001.svg', '检测组负责人审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100106', '样品接收', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=SampleReceive', '1001', '6', '001.svg', '样品接收');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100107', '样品预处理', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=SampleDispose', '1001', '7', '001.svg', '样品预处理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100108', '结果录入', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=ResultInput', '1001', '8', '001.svg', '结果录入');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100109', '结果复核', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=ResultReview', '1001', '9', '001.svg', '结果复核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100110', '结果录入(理化)', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=ResultInput&page=PR', '1001', '10', '001.svg', '结果录入(理化)');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100111', '结果复核(理化)', '/secure/basemodule/business/test/folders/page/audit-list?bpmn_statusCode=ResultReview&page=PR', '1001', '11', '001.svg', '结果复核(理化)');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100112', '流程查询', '/secure/basemodule/business/test/folders/page/search-list', '1001', '12', '001.svg', '流程查询');

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

INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('1001', '检测业务流程', 'T_LIMS_FOLDER', 'audit_def', '1');


COMMIT;

-- ----------------------------- 2022-09-06 add by lijiaxing------------end                              PROCESSCONTROLSTATUS VARCHAR2 (36) NULL
-- ----------------------------- 2022-09-07 add by lijx--------------begin

-- 建表语句
CREATE TABLE T_LIMS_TASK
(
    ID NUMBER NOT NULL,
    CREATEDBYID VARCHAR2 (36) NULL,
    CREATEDBYNAME VARCHAR2 (60) NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2 (36) NULL,
    CREATEDBYORGNAME VARCHAR2 (270) NULL,
    PROCESSSTATUS VARCHAR2 (36) NULL,
    ORGID VARCHAR2 (36) NULL,
    ORGNAME VARCHAR2 (270) NULL,
    REMARKS VARCHAR2 (360) NULL,
    STATUS VARCHAR2 (36) NULL,
    FOLDERID NUMBER NULL,
    FOLDERNO VARCHAR2 (270) NULL,
    TESTMETHODID NUMBER NULL,
    TESTID NUMBER NULL,
    TESTCODE VARCHAR2 (270) NULL,
    TESTNAME VARCHAR2 (270) NULL,
    METHODID NUMBER NULL,
    METHODCODE VARCHAR2 (270) NULL,
    METHODNAME VARCHAR2 (270) NULL,
    JUDGEBASIS VARCHAR2 (270) NULL,
    URGENCYDEGREE VARCHAR2 (36) NULL,
    URGENCYREASON VARCHAR2 (270) NULL,
    ESTIMATECOST NUMBER (16,2) NULL,
    TESTENGINEERID VARCHAR2 (36) NULL,
    TESTENGINEER VARCHAR2 (60) NULL,
    STANDARDHOURS NUMBER (16,2) NULL,
    POLEPIECECOUNT NUMBER NULL,
    PREORDERID NUMBER NULL,
    EQUIPTID NUMBER NULL,
    EQUIPTCODE VARCHAR2 (270) NULL,
    EQUIPTNAME VARCHAR2 (270) NULL,
    ORDTASKSAMPLEID NUMBER NULL,
    ORDTASKSAMPLECODE VARCHAR2 (270) NULL,
    OPERATETIME DATE NULL,
    RESULT NUMBER (16,2) NULL,
    TESTGROUP VARCHAR2 (36) NULL,
    PROCESSCONTROLSTATUS VARCHAR2 (36) NULL
);
COMMENT ON TABLE T_LIMS_TASK IS '委托单项目表';
COMMENT ON COLUMN T_LIMS_TASK.ID IS '主键';
COMMENT ON COLUMN T_LIMS_TASK.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_TASK.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_TASK.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_TASK.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_TASK.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_TASK.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_TASK.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_TASK.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_TASK.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_TASK.STATUS IS '任务状态';
COMMENT ON COLUMN T_LIMS_TASK.FOLDERID IS '委托单ID';
COMMENT ON COLUMN T_LIMS_TASK.FOLDERNO IS '委托单编号';
COMMENT ON COLUMN T_LIMS_TASK.TESTMETHODID IS '项目方法ID';
COMMENT ON COLUMN T_LIMS_TASK.TESTID IS '项目ID';
COMMENT ON COLUMN T_LIMS_TASK.TESTCODE IS '项目编码';
COMMENT ON COLUMN T_LIMS_TASK.TESTNAME IS '项目名称';
COMMENT ON COLUMN T_LIMS_TASK.METHODID IS '方法ID';
COMMENT ON COLUMN T_LIMS_TASK.METHODCODE IS '方法编码';
COMMENT ON COLUMN T_LIMS_TASK.METHODNAME IS '方法名称';
COMMENT ON COLUMN T_LIMS_TASK.JUDGEBASIS IS '测试依据';
COMMENT ON COLUMN T_LIMS_TASK.URGENCYDEGREE IS '紧急程度';
COMMENT ON COLUMN T_LIMS_TASK.URGENCYREASON IS '加急原因';
COMMENT ON COLUMN T_LIMS_TASK.ESTIMATECOST IS '预估费用(元)';
COMMENT ON COLUMN T_LIMS_TASK.TESTENGINEERID IS '测试工程师ID';
COMMENT ON COLUMN T_LIMS_TASK.TESTENGINEER IS '测试工程师';
COMMENT ON COLUMN T_LIMS_TASK.STANDARDHOURS IS '标准时长';
COMMENT ON COLUMN T_LIMS_TASK.POLEPIECECOUNT IS '极片数量';
COMMENT ON COLUMN T_LIMS_TASK.PREORDERID IS '原始样品ID';
COMMENT ON COLUMN T_LIMS_TASK.EQUIPTID IS '设备ID';
COMMENT ON COLUMN T_LIMS_TASK.EQUIPTCODE IS '设备编号';
COMMENT ON COLUMN T_LIMS_TASK.EQUIPTNAME IS '设备名称';
COMMENT ON COLUMN T_LIMS_TASK.ORDTASKSAMPLEID IS '项目样品ID';
COMMENT ON COLUMN T_LIMS_TASK.ORDTASKSAMPLECODE IS '项目样品编号';
COMMENT ON COLUMN T_LIMS_TASK.OPERATETIME IS '处理时间';
COMMENT ON COLUMN T_LIMS_TASK.RESULT IS '结果';
COMMENT ON COLUMN T_LIMS_TASK.TESTGROUP IS '测试组';

ALTER TABLE T_LIMS_TASK
    ADD CONSTRAINT PK_LIMS_TASK PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_TASK.SERVICE_NAME', '委托单项目表', '委托单项目表', 'zh-CN', '委托单项目表');
CALL INSERTI18N('T_LIMS_TASK.ID', '委托单项目表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_TASK.CREATEDBYID', '委托单项目表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_TASK.CREATEDBYNAME', '委托单项目表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_TASK.CREATEDTIME', '委托单项目表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_TASK.CREATEDBYORGID', '委托单项目表的制单人单位编码', '制单人单位编码', 'zh-CN',
                '制单人单位编码');
CALL INSERTI18N('T_LIMS_TASK.CREATEDBYORGNAME', '委托单项目表的制单人单位名称', '制单人单位名称', 'zh-CN',
                '制单人单位名称');
CALL INSERTI18N('T_LIMS_TASK.PROCESSSTATUS', '委托单项目表的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_TASK.ORGID', '委托单项目表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_TASK.ORGNAME', '委托单项目表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_TASK.REMARKS', '委托单项目表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_TASK.STATUS', '委托单项目表的任务状态', '任务状态', 'zh-CN', '任务状态');
CALL INSERTI18N('T_LIMS_TASK.FOLDERID', '委托单项目表的委托单ID', '委托单ID', 'zh-CN', '委托单ID');
CALL INSERTI18N('T_LIMS_TASK.FOLDERNO', '委托单项目表的委托单编号', '委托单编号', 'zh-CN', '委托单编号');
CALL INSERTI18N('T_LIMS_TASK.TESTMETHODID', '委托单项目表的项目方法ID', '项目方法ID', 'zh-CN', '项目方法ID');
CALL INSERTI18N('T_LIMS_TASK.TESTID', '委托单项目表的项目ID', '项目ID', 'zh-CN', '项目ID');
CALL INSERTI18N('T_LIMS_TASK.TESTCODE', '委托单项目表的项目编码', '项目编码', 'zh-CN', '项目编码');
CALL INSERTI18N('T_LIMS_TASK.TESTNAME', '委托单项目表的项目名称', '项目名称', 'zh-CN', '项目名称');
CALL INSERTI18N('T_LIMS_TASK.METHODID', '委托单项目表的方法ID', '方法ID', 'zh-CN', '方法ID');
CALL INSERTI18N('T_LIMS_TASK.METHODCODE', '委托单项目表的方法编码', '方法编码', 'zh-CN', '方法编码');
CALL INSERTI18N('T_LIMS_TASK.METHODNAME', '委托单项目表的方法名称', '方法名称', 'zh-CN', '方法名称');
CALL INSERTI18N('T_LIMS_TASK.JUDGEBASIS', '委托单项目表的测试依据', '测试依据', 'zh-CN', '测试依据');
CALL INSERTI18N('T_LIMS_TASK.URGENCYDEGREE', '委托单项目表的紧急程度', '紧急程度', 'zh-CN', '紧急程度');
CALL INSERTI18N('T_LIMS_TASK.URGENCYREASON', '委托单项目表的加急原因', '加急原因', 'zh-CN', '加急原因');
CALL INSERTI18N('T_LIMS_TASK.ESTIMATECOST', '委托单项目表的预估费用(元)', '预估费用(元)', 'zh-CN', '预估费用(元)');
CALL INSERTI18N('T_LIMS_TASK.TESTENGINEERID', '委托单项目表的测试工程师ID', '测试工程师ID', 'zh-CN', '测试工程师ID');
CALL INSERTI18N('T_LIMS_TASK.TESTENGINEER', '委托单项目表的测试工程师', '测试工程师', 'zh-CN', '测试工程师');
CALL INSERTI18N('T_LIMS_TASK.STANDARDHOURS', '委托单项目表的标准时长', '标准时长', 'zh-CN', '标准时长');
CALL INSERTI18N('T_LIMS_TASK.POLEPIECECOUNT', '委托单项目表的极片数量', '极片数量', 'zh-CN', '极片数量');
CALL INSERTI18N('T_LIMS_TASK.PREORDERID', '委托单项目表的原始样品ID', '原始样品ID', 'zh-CN', '原始样品ID');
CALL INSERTI18N('T_LIMS_TASK.EQUIPTID', '委托单项目表的设备ID', '设备ID', 'zh-CN', '设备ID');
CALL INSERTI18N('T_LIMS_TASK.EQUIPTCODE', '委托单项目表的设备编号', '设备编号', 'zh-CN', '设备编号');
CALL INSERTI18N('T_LIMS_TASK.EQUIPTNAME', '委托单项目表的设备名称', '设备名称', 'zh-CN', '设备名称');
CALL INSERTI18N('T_LIMS_TASK.ORDTASKSAMPLEID', '委托单项目表的项目样品ID', '项目样品ID', 'zh-CN', '项目样品ID');
CALL INSERTI18N('T_LIMS_TASK.ORDTASKSAMPLECODE', '委托单项目表的项目样品编号', '项目样品编号', 'zh-CN', '项目样品编号');
CALL INSERTI18N('T_LIMS_TASK.OPERATETIME', '委托单项目表的处理时间', '处理时间', 'zh-CN', '处理时间');
CALL INSERTI18N('T_LIMS_TASK.RESULT', '委托单项目表的结果', '结果', 'zh-CN', '结果');
CALL INSERTI18N('T_LIMS_TASK.TESTGROUP', '委托单项目表的测试组', '测试组', 'zh-CN', '测试组');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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

INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('100101', '检测项目', 'T_LIMS_TASK', 'audit_def', '1');


COMMIT;

-- ----------------------------- 2022-09-07 add by lijx------------end
-- ----------------------------- 2022-09-07 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDER
(
    ID NUMBER NOT NULL,
    CREATEDBYID VARCHAR2 (36) NULL,
    CREATEDBYNAME VARCHAR2 (60) NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2 (36) NULL,
    CREATEDBYORGNAME VARCHAR2 (270) NULL,
    ORGID VARCHAR2 (36) NULL,
    ORGNAME VARCHAR2 (270) NULL,
    REMARKS VARCHAR2 (360) NULL,
    FOLDERID NUMBER NULL,
    FOLDERNO VARCHAR2 (270) NULL,
    TASKID NUMBER NULL,
    SAMPLENAME VARCHAR2 (270) NULL,
    SAMPLETYPE VARCHAR2 (36) NULL,
    SAMPLEGROUP VARCHAR2 (270) NULL,
    CAPACITY NUMBER (16,2) NULL,
    AMOUNT NUMBER NULL,
    SAMPLECODE VARCHAR2 (270) NULL,
    MATERIALID NUMBER NULL,
    MATERIALNAME VARCHAR2 (270) NULL,
    MATERIALCODE VARCHAR2 (270) NULL,
    TESTGROUP VARCHAR2 (36) NULL,
    POSITIVEMATERIAL VARCHAR2 (270) NULL,
    POSITIVEACTIVITY NUMBER (16,2) NULL,
    POSITIVECONDUCTIVECARBON NUMBER (16,2) NULL,
    PVDF NUMBER (16,2) NULL,
    POSITIVEPRESSDENSITY NUMBER (16,2) NULL,
    NAGETIVEMATERIAL VARCHAR2 (270) NULL,
    NAGETIVEACTIVITY NUMBER (16,2) NULL,
    NAGETIVECONDUCTIVECARBON NUMBER (16,2) NULL,
    NAGETIVECMC NUMBER (16,2) NULL,
    NAGETIVESBR NUMBER (16,2) NULL,
    NAGETIVEPRESSDENSITY NUMBER (16,2) NULL,
    NP NUMBER (16,2) NULL,
    ELECTROLYTE NUMBER (16,2) NULL,
    DIAPHRAGM NUMBER (16,2) NULL,
    TESTVOLTAGE NUMBER (16,2) NULL,
    POSITIVECAPACITY NUMBER (16,2) NULL,
    POSITIVERATIO NUMBER (16,2) NULL,
    POSITIVEROLLINPRESSDEN NUMBER (16,2) NULL,
    POSITIVECOATINGPRESSDEN NUMBER (16,2) NULL,
    POSITIVEFOILTHICKNESS NUMBER (16,2) NULL,
    ROLLINTHICKNESS NUMBER (16,2) NULL,
    NAGETIVECAPACITY NUMBER (16,2) NULL,
    NAGETIVERATIO NUMBER (16,2) NULL,
    NAGETIVEROLLINPRESSDEN NUMBER (16,2) NULL,
    NAGETIVECOATINGPRESSDEN NUMBER (16,2) NULL,
    NAGETIVEFOILTHICKNESS NUMBER (16,2) NULL,
    NEGATIVETHICKNESS NUMBER (16,2) NULL,
    OBTAINSTATUS VARCHAR2 (36) NULL,
    OBTAINTIME  DATE NULL,
    TESTCONDITION VARCHAR2 (270) NULL,
    LOCATION VARCHAR2 (270) NULL,
    LOCATIONID NUMBER NULL,
    PREORDERID NUMBER NULL
);
COMMENT ON TABLE T_LIMS_ORDER IS '样品表';
COMMENT ON COLUMN T_LIMS_ORDER.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDER.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDER.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDER.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDER.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDER.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDER.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDER.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDER.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDER.FOLDERID IS '委托单ID';
COMMENT ON COLUMN T_LIMS_ORDER.FOLDERNO IS '委托单编号';
COMMENT ON COLUMN T_LIMS_ORDER.TASKID IS '任务ID';
COMMENT ON COLUMN T_LIMS_ORDER.SAMPLENAME IS '样品名称';
COMMENT ON COLUMN T_LIMS_ORDER.SAMPLETYPE IS '样品类型';
COMMENT ON COLUMN T_LIMS_ORDER.SAMPLEGROUP IS '组别';
COMMENT ON COLUMN T_LIMS_ORDER.CAPACITY IS '容量mAh';
COMMENT ON COLUMN T_LIMS_ORDER.AMOUNT IS '数量';
COMMENT ON COLUMN T_LIMS_ORDER.SAMPLECODE IS '样品编号';
COMMENT ON COLUMN T_LIMS_ORDER.MATERIALID IS '材料ID';
COMMENT ON COLUMN T_LIMS_ORDER.MATERIALNAME IS '材料名称';
COMMENT ON COLUMN T_LIMS_ORDER.MATERIALCODE IS '材料编码';
COMMENT ON COLUMN T_LIMS_ORDER.TESTGROUP IS '测试组';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVEMATERIAL IS '正极材料';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVEACTIVITY IS '正极活性占比';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVECONDUCTIVECARBON IS '正极导电炭';
COMMENT ON COLUMN T_LIMS_ORDER.PVDF IS 'PVDF5130';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVEPRESSDENSITY IS '正极压实密度';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVEMATERIAL IS '负极材料';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVEACTIVITY IS '负极活性占比';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVECONDUCTIVECARBON IS '负极导电炭';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVECMC IS '负极CMC';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVESBR IS '负极SBR';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVEPRESSDENSITY IS '负极压实密度';
COMMENT ON COLUMN T_LIMS_ORDER.NP IS 'N/P';
COMMENT ON COLUMN T_LIMS_ORDER.ELECTROLYTE IS '电解液';
COMMENT ON COLUMN T_LIMS_ORDER.DIAPHRAGM IS '隔膜/um';
COMMENT ON COLUMN T_LIMS_ORDER.TESTVOLTAGE IS '测试电压';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVECAPACITY IS '正极克容量(mAh/g)';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVERATIO IS '正极活性物质比例(%)';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVEROLLINPRESSDEN IS '正极辊压后单面面密度(mg/cm2)';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVECOATINGPRESSDEN IS '正极涂布单面面密度(mg/cm2)';
COMMENT ON COLUMN T_LIMS_ORDER.POSITIVEFOILTHICKNESS IS '正极箔材厚度(um)';
COMMENT ON COLUMN T_LIMS_ORDER.ROLLINTHICKNESS IS '辊压厚度(um)';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVECAPACITY IS '负极克容量(mAh/g)';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVERATIO IS '负极活性物质比例(%)';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVEROLLINPRESSDEN IS '负极辊压后单面面密度(mg/cm2)';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVECOATINGPRESSDEN IS '负极涂布单面面密度(mg/cm2)';
COMMENT ON COLUMN T_LIMS_ORDER.NAGETIVEFOILTHICKNESS IS '负极箔材厚度(um)';
COMMENT ON COLUMN T_LIMS_ORDER.NEGATIVETHICKNESS IS '负极极片厚度(um)';
COMMENT ON COLUMN T_LIMS_ORDER.OBTAINSTATUS IS '收样状态';
COMMENT ON COLUMN T_LIMS_ORDER.OBTAINTIME IS '收样时间';
COMMENT ON COLUMN T_LIMS_ORDER.TESTCONDITION IS '测试条件';
COMMENT ON COLUMN T_LIMS_ORDER.LOCATION IS '位置';
COMMENT ON COLUMN T_LIMS_ORDER.LOCATIONID IS '位置ID';
COMMENT ON COLUMN T_LIMS_ORDER.PREORDERID IS '原始样品ID';

ALTER TABLE T_LIMS_ORDER
    ADD CONSTRAINT PK_LIMS_ORDER PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDER.SERVICE_NAME', '样品表', '样品表', 'zh-CN', '样品表');
CALL INSERTI18N('T_LIMS_ORDER.ID', '样品表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDER.CREATEDBYID', '样品表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDER.CREATEDBYNAME', '样品表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDER.CREATEDTIME', '样品表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDER.CREATEDBYORGID', '样品表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDER.CREATEDBYORGNAME', '样品表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDER.ORGID', '样品表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDER.ORGNAME', '样品表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDER.REMARKS', '样品表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDER.FOLDERID', '样品表的委托单ID', '委托单ID', 'zh-CN', '委托单ID');
CALL INSERTI18N('T_LIMS_ORDER.FOLDERNO', '样品表的委托单编号', '委托单编号', 'zh-CN', '委托单编号');
CALL INSERTI18N('T_LIMS_ORDER.TASKID', '样品表的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('T_LIMS_ORDER.SAMPLENAME', '样品表的样品名称', '样品名称', 'zh-CN', '样品名称');
CALL INSERTI18N('T_LIMS_ORDER.SAMPLETYPE', '样品表的样品类型', '样品类型', 'zh-CN', '样品类型');
CALL INSERTI18N('T_LIMS_ORDER.SAMPLEGROUP', '样品表的组别', '组别', 'zh-CN', '组别');
CALL INSERTI18N('T_LIMS_ORDER.CAPACITY', '样品表的容量mAh', '容量mAh', 'zh-CN', '容量mAh');
CALL INSERTI18N('T_LIMS_ORDER.AMOUNT', '样品表的数量', '数量', 'zh-CN', '数量');
CALL INSERTI18N('T_LIMS_ORDER.SAMPLECODE', '样品表的样品编号', '样品编号', 'zh-CN', '样品编号');
CALL INSERTI18N('T_LIMS_ORDER.MATERIALID', '样品表的材料ID', '材料ID', 'zh-CN', '材料ID');
CALL INSERTI18N('T_LIMS_ORDER.MATERIALNAME', '样品表的材料名称', '材料名称', 'zh-CN', '材料名称');
CALL INSERTI18N('T_LIMS_ORDER.MATERIALCODE', '样品表的材料编码', '材料编码', 'zh-CN', '材料编码');
CALL INSERTI18N('T_LIMS_ORDER.TESTGROUP', '样品表的测试组', '测试组', 'zh-CN', '测试组');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVEMATERIAL', '样品表的正极材料', '正极材料', 'zh-CN', '正极材料');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVEACTIVITY', '样品表的正极活性占比', '正极活性占比', 'zh-CN', '正极活性占比');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVECONDUCTIVECARBON', '样品表的正极导电炭', '正极导电炭', 'zh-CN', '正极导电炭');
CALL INSERTI18N('T_LIMS_ORDER.PVDF', '样品表的PVDF5130', 'PVDF5130', 'zh-CN', 'PVDF5130');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVEPRESSDENSITY', '样品表的正极压实密度', '正极压实密度', 'zh-CN', '正极压实密度');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVEMATERIAL', '样品表的负极材料', '负极材料', 'zh-CN', '负极材料');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVEACTIVITY', '样品表的负极活性占比', '负极活性占比', 'zh-CN', '负极活性占比');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVECONDUCTIVECARBON', '样品表的负极导电炭', '负极导电炭', 'zh-CN', '负极导电炭');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVECMC', '样品表的负极CMC', '负极CMC', 'zh-CN', '负极CMC');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVESBR', '样品表的负极SBR', '负极SBR', 'zh-CN', '负极SBR');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVEPRESSDENSITY', '样品表的负极压实密度', '负极压实密度', 'zh-CN', '负极压实密度');
CALL INSERTI18N('T_LIMS_ORDER.NP', '样品表的N/P', 'N/P', 'zh-CN', 'N/P');
CALL INSERTI18N('T_LIMS_ORDER.ELECTROLYTE', '样品表的电解液', '电解液', 'zh-CN', '电解液');
CALL INSERTI18N('T_LIMS_ORDER.DIAPHRAGM', '样品表的隔膜/um', '隔膜/um', 'zh-CN', '隔膜/um');
CALL INSERTI18N('T_LIMS_ORDER.TESTVOLTAGE', '样品表的测试电压', '测试电压', 'zh-CN', '测试电压');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVECAPACITY', '样品表的正极克容量(mAh/g)', '正极克容量(mAh/g)', 'zh-CN',
                '正极克容量(mAh/g)');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVERATIO', '样品表的正极活性物质比例(%)', '正极活性物质比例(%)', 'zh-CN',
                '正极活性物质比例(%)');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVEROLLINPRESSDEN', '样品表的正极辊压后单面面密度(mg/cm2)',
                '正极辊压后单面面密度(mg/cm2)', 'zh-CN', '正极辊压后单面面密度(mg/cm2)');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVECOATINGPRESSDEN', '样品表的正极涂布单面面密度(mg/cm2)',
                '正极涂布单面面密度(mg/cm2)', 'zh-CN', '正极涂布单面面密度(mg/cm2)');
CALL INSERTI18N('T_LIMS_ORDER.POSITIVEFOILTHICKNESS', '样品表的正极箔材厚度(um)', '正极箔材厚度(um)', 'zh-CN',
                '正极箔材厚度(um)');
CALL INSERTI18N('T_LIMS_ORDER.ROLLINTHICKNESS', '样品表的辊压厚度(um)', '辊压厚度(um)', 'zh-CN', '辊压厚度(um)');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVECAPACITY', '样品表的负极克容量(mAh/g)', '负极克容量(mAh/g)', 'zh-CN',
                '负极克容量(mAh/g)');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVERATIO', '样品表的负极活性物质比例(%)', '负极活性物质比例(%)', 'zh-CN',
                '负极活性物质比例(%)');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVEROLLINPRESSDEN', '样品表的负极辊压后单面面密度(mg/cm2)',
                '负极辊压后单面面密度(mg/cm2)', 'zh-CN', '负极辊压后单面面密度(mg/cm2)');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVECOATINGPRESSDEN', '样品表的负极涂布单面面密度(mg/cm2)',
                '负极涂布单面面密度(mg/cm2)', 'zh-CN', '负极涂布单面面密度(mg/cm2)');
CALL INSERTI18N('T_LIMS_ORDER.NAGETIVEFOILTHICKNESS', '样品表的负极箔材厚度(um)', '负极箔材厚度(um)', 'zh-CN',
                '负极箔材厚度(um)');
CALL INSERTI18N('T_LIMS_ORDER.NEGATIVETHICKNESS', '样品表的负极极片厚度(um)', '负极极片厚度(um)', 'zh-CN',
                '负极极片厚度(um)');
CALL INSERTI18N('T_LIMS_ORDER.OBTAINSTATUS', '样品表的收样状态', '收样状态', 'zh-CN', '收样状态');
CALL INSERTI18N('T_LIMS_ORDER.OBTAINTIME', '样品表的收样时间', '收样时间', 'zh-CN', '收样时间');
CALL INSERTI18N('T_LIMS_ORDER.TESTCONDITION', '样品表的测试条件', '测试条件', 'zh-CN', '测试条件');
CALL INSERTI18N('T_LIMS_ORDER.LOCATION', '样品表的位置', '位置', 'zh-CN', '位置');
CALL INSERTI18N('T_LIMS_ORDER.LOCATIONID', '样品表的位置ID', '位置ID', 'zh-CN', '位置ID');
CALL INSERTI18N('T_LIMS_ORDER.PREORDERID', '样品表的原始样品ID', '原始样品ID', 'zh-CN', '原始样品ID');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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


COMMIT;

-- ----------------------------- 2022-09-07 add by lijiaxing------------end
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.FOLDER', '委托信息', '委托信息', 'zh-CN', '委托信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.TASK', '检测项目', '检测项目', 'zh-CN', '检测项目');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.ORDER', '样品信息', '样品信息', 'zh-CN', '样品信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.ACCESSORY', '附件', '附件', 'zh-CN', '附件');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.TASKTESTCONDITIONPANEL', '检测条件', '检测条件', 'zh-CN',
                '检测条件');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.TASKTESTPROCESSPANEL', '检测工序', '检测工序', 'zh-CN',
                '检测工序');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.TASKUPLOADERPANEL', '附件', '附件', 'zh-CN', '附件');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('sampleType', '样品类型', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081701, 'lithium ion battery', 'lithium', 1, 'sampleType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081702, '固态', 'solid', 2, 'sampleType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081703, '气体', 'gas', 3, 'sampleType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081704, '液体', 'liquid', 4, 'sampleType', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('lab', '实验室', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081801, 'FS1试验室', 'FS1', 1, 'lab', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081802, 'FS2试验室', 'FS2', 2, 'lab', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081803, 'FS3试验室', 'FS3', 3, 'lab', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('workshopSection', '工段', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081901, '烧结1', '1', 1, 'workshopSection', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209081902, '烧结2', '2', 2, 'workshopSection', 0, 'admin', '系统管理员', '0');


INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('folderCheckType', '检验类型', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082001, '生产收货检验', 'product', 1, 'folderCheckType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082002, '研发检验', 'develop', 2, 'folderCheckType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082003, '质控样检验', 'quality', 3, 'folderCheckType', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('sampleHandleType', '样品处理方式', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082101, '检方处理', 'product', 1, 'sampleHandleType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082102, '退回委托方', 'develop', 2, 'sampleHandleType', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('qualityType', '质控样类型', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082201, '常规监测', '1', 1, 'qualityType', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082202, '数据统计', '2', 2, 'qualityType', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('urgencyDegree', '紧急程度', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082301, '普通', '1', 1, 'urgencyDegree', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209082302, '加急', '2', 2, 'urgencyDegree', 0, 'admin', '系统管理员', '0');

-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_TASK_CONDITION(
                                      ID NUMBER NOT NULL,
                                      CREATEDBYID VARCHAR2(36)  NULL,
                                      CREATEDBYNAME VARCHAR2(60)  NULL,
                                      CREATEDTIME DATE NULL,
                                      CREATEDBYORGID VARCHAR2(36)  NULL,
                                      CREATEDBYORGNAME VARCHAR2(270)  NULL,
                                      REMARKS VARCHAR2(360)  NULL,
                                      ORGID VARCHAR2(36)  NULL,
                                      ORGNAME VARCHAR2(270)  NULL,
                                      TASKID NUMBER NULL,
                                      CONDITIONNAME VARCHAR2(270)  NULL,
                                      CONDITIONVALUE NUMBER(16,2)  NULL,
                                      CONDITIONUNIT VARCHAR2(36)  NULL
);
COMMENT ON TABLE T_LIMS_TASK_CONDITION IS '检测条件';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.ID IS '主键';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.TASKID IS '任务ID';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CONDITIONNAME IS '条件名称';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CONDITIONVALUE IS '条件值';
COMMENT ON COLUMN T_LIMS_TASK_CONDITION.CONDITIONUNIT IS '单位';

ALTER TABLE T_LIMS_TASK_CONDITION ADD CONSTRAINT PK_LIMS_TASK_CONDITION PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_TASK_CONDITION.SERVICE_NAME', '检测条件', '检测条件', 'zh-CN', '检测条件');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.ID', '检测条件的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CREATEDBYID', '检测条件的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CREATEDBYNAME', '检测条件的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CREATEDTIME', '检测条件的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CREATEDBYORGID', '检测条件的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CREATEDBYORGNAME', '检测条件的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.REMARKS', '检测条件的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.ORGID', '检测条件的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.ORGNAME', '检测条件的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.TASKID', '检测条件的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CONDITIONNAME', '检测条件的条件名称', '条件名称', 'zh-CN', '条件名称');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CONDITIONVALUE', '检测条件的条件值', '条件值', 'zh-CN', '条件值');
CALL INSERTI18N('T_LIMS_TASK_CONDITION.CONDITIONUNIT', '检测条件的单位', '单位', 'zh-CN', '单位');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKCONDITIONS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKCONDITIONS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKCONDITIONS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKCONDITIONS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.TASKCONDITIONS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end
-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDTASK_RESULT(
                                      ID NUMBER NOT NULL,
                                      CREATEDBYID VARCHAR2(36)  NULL,
                                      CREATEDBYNAME VARCHAR2(60)  NULL,
                                      CREATEDTIME DATE NULL,
                                      CREATEDBYORGID VARCHAR2(36)  NULL,
                                      CREATEDBYORGNAME VARCHAR2(270)  NULL,
                                      ORGID VARCHAR2(36)  NULL,
                                      ORGNAME VARCHAR2(270)  NULL,
                                      REMARKS VARCHAR2(360)  NULL,
                                      ORDTASKID NUMBER NULL,
                                      ANALYSTID NUMBER NULL,
                                      ANALYSTGROUP VARCHAR2(270)  NULL,
                                      ANALYSTNAME VARCHAR2(270)  NULL,
                                      RESULT NUMBER(16,2)  NULL,
                                      RESULTTYPE VARCHAR2(36)  NULL,
                                      REVISIONRULE VARCHAR2(270)  NULL,
                                      FORMULA VARCHAR2(270)  NULL,
                                      ENTERINGUSERID VARCHAR2(36)  NULL,
                                      ENTERINGUSER VARCHAR2(60)  NULL,
                                      ENTERINGTIME DATE NULL
);
COMMENT ON TABLE T_LIMS_ORDTASK_RESULT IS '试验结果表';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ORDTASKID IS '项目样品ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ANALYSTID IS '分析项ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ANALYSTGROUP IS '分析项组';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ANALYSTNAME IS '分析项名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.RESULT IS '试验结果';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.RESULTTYPE IS '结果类型';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.REVISIONRULE IS '修约规则';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.FORMULA IS '计算公式';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ENTERINGUSERID IS '录入人ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ENTERINGUSER IS '录入人';
COMMENT ON COLUMN T_LIMS_ORDTASK_RESULT.ENTERINGTIME IS '录入时间';

ALTER TABLE T_LIMS_ORDTASK_RESULT ADD CONSTRAINT PK_LIMS_ORDTASK_RESULT PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.SERVICE_NAME', '试验结果表', '试验结果表', 'zh-CN', '试验结果表');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ID', '试验结果表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.CREATEDBYID', '试验结果表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.CREATEDBYNAME', '试验结果表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.CREATEDTIME', '试验结果表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.CREATEDBYORGID', '试验结果表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.CREATEDBYORGNAME', '试验结果表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ORGID', '试验结果表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ORGNAME', '试验结果表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.REMARKS', '试验结果表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ORDTASKID', '试验结果表的项目样品ID', '项目样品ID', 'zh-CN', '项目样品ID');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ANALYSTID', '试验结果表的分析项ID', '分析项ID', 'zh-CN', '分析项ID');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ANALYSTGROUP', '试验结果表的分析项组', '分析项组', 'zh-CN', '分析项组');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ANALYSTNAME', '试验结果表的分析项名称', '分析项名称', 'zh-CN', '分析项名称');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.RESULT', '试验结果表的试验结果', '试验结果', 'zh-CN', '试验结果');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.RESULTTYPE', '试验结果表的结果类型', '结果类型', 'zh-CN', '结果类型');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.REVISIONRULE', '试验结果表的修约规则', '修约规则', 'zh-CN', '修约规则');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.FORMULA', '试验结果表的计算公式', '计算公式', 'zh-CN', '计算公式');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ENTERINGUSERID', '试验结果表的录入人ID', '录入人ID', 'zh-CN', '录入人ID');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ENTERINGUSER', '试验结果表的录入人', '录入人', 'zh-CN', '录入人');
CALL INSERTI18N('T_LIMS_ORDTASK_RESULT.ENTERINGTIME', '试验结果表的录入时间', '录入时间', 'zh-CN', '录入时间');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKRESULTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKRESULTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKRESULTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKRESULTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKRESULTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end
-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDTASK_EXCEPTION(
                                         ID NUMBER NOT NULL,
                                         CREATEDBYID VARCHAR2(36)  NULL,
                                         CREATEDBYNAME VARCHAR2(60)  NULL,
                                         CREATEDTIME DATE NULL,
                                         CREATEDBYORGID VARCHAR2(36)  NULL,
                                         CREATEDBYORGNAME VARCHAR2(270)  NULL,
                                         REMARKS VARCHAR2(360)  NULL,
                                         ORGID VARCHAR2(36)  NULL,
                                         ORGNAME VARCHAR2(270)  NULL,
                                         ORDTASKID NUMBER NULL,
                                         TASKID NUMBER NULL,
                                         EXCEPTIONTIME DATE NULL,
                                         EXCEPTIONDESC VARCHAR2(270)  NULL
);
COMMENT ON TABLE T_LIMS_ORDTASK_EXCEPTION IS '样品异常信息';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.ORDTASKID IS '项目样品ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.TASKID IS '任务ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.EXCEPTIONTIME IS '异常时间';
COMMENT ON COLUMN T_LIMS_ORDTASK_EXCEPTION.EXCEPTIONDESC IS '异常描述';

ALTER TABLE T_LIMS_ORDTASK_EXCEPTION ADD CONSTRAINT PK_LIMS_ORDTASK_EXCEPTION PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.SERVICE_NAME', '样品异常信息', '样品异常信息', 'zh-CN', '样品异常信息');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.ID', '样品异常信息的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.CREATEDBYID', '样品异常信息的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.CREATEDBYNAME', '样品异常信息的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.CREATEDTIME', '样品异常信息的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.CREATEDBYORGID', '样品异常信息的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.CREATEDBYORGNAME', '样品异常信息的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.REMARKS', '样品异常信息的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.ORGID', '样品异常信息的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.ORGNAME', '样品异常信息的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.ORDTASKID', '样品异常信息的项目样品ID', '项目样品ID', 'zh-CN', '项目样品ID');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.TASKID', '样品异常信息的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.EXCEPTIONTIME', '样品异常信息的异常时间', '异常时间', 'zh-CN', '异常时间');
CALL INSERTI18N('T_LIMS_ORDTASK_EXCEPTION.EXCEPTIONDESC', '样品异常信息的异常描述', '异常描述', 'zh-CN', '异常描述');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKEXCEPTIONS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKEXCEPTIONS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKEXCEPTIONS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKEXCEPTIONS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKEXCEPTIONS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end
-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDTASK_CONSUMABLE(
                                          ID NUMBER NOT NULL,
                                          CREATEDBYID VARCHAR2(36)  NULL,
                                          CREATEDBYNAME VARCHAR2(60)  NULL,
                                          CREATEDTIME DATE NULL,
                                          CREATEDBYORGID VARCHAR2(36)  NULL,
                                          CREATEDBYORGNAME VARCHAR2(270)  NULL,
                                          ORGID VARCHAR2(36)  NULL,
                                          ORGNAME VARCHAR2(270)  NULL,
                                          REMARKS VARCHAR2(360)  NULL,
                                          ORDTASKID NUMBER NULL,
                                          CONSUMABLENAME VARCHAR2(270)  NULL,
                                          CONSUMABLECODE VARCHAR2(270)  NULL,
                                          CONSUMABLEAMOUNT NUMBER(16,2)  NULL,
                                          UNIT VARCHAR2(36)  NULL
);
COMMENT ON TABLE T_LIMS_ORDTASK_CONSUMABLE IS '试验耗材表';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.ORDTASKID IS '项目样品ID';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLENAME IS '耗材名称';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLECODE IS '耗材编号';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLEAMOUNT IS '耗材数量';
COMMENT ON COLUMN T_LIMS_ORDTASK_CONSUMABLE.UNIT IS '单位';

ALTER TABLE T_LIMS_ORDTASK_CONSUMABLE ADD CONSTRAINT PK_LIMS_ORDTASK_CONSUMABLE PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.SERVICE_NAME', '试验耗材表', '试验耗材表', 'zh-CN', '试验耗材表');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.ID', '试验耗材表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYID', '试验耗材表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYNAME', '试验耗材表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CREATEDTIME', '试验耗材表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYORGID', '试验耗材表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CREATEDBYORGNAME', '试验耗材表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.ORGID', '试验耗材表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.ORGNAME', '试验耗材表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.REMARKS', '试验耗材表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.ORDTASKID', '试验耗材表的项目样品ID', '项目样品ID', 'zh-CN', '项目样品ID');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLENAME', '试验耗材表的耗材名称', '耗材名称', 'zh-CN', '耗材名称');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLECODE', '试验耗材表的耗材编号', '耗材编号', 'zh-CN', '耗材编号');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.CONSUMABLEAMOUNT', '试验耗材表的耗材数量', '耗材数量', 'zh-CN', '耗材数量');
CALL INSERTI18N('T_LIMS_ORDTASK_CONSUMABLE.UNIT', '试验耗材表的单位', '单位', 'zh-CN', '单位');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKCONSUMABLES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKCONSUMABLES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKCONSUMABLES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKCONSUMABLES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKCONSUMABLES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end
-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDER_PROCESS(
                                     ID NUMBER NOT NULL,
                                     CREATEDBYID VARCHAR2(36)  NULL,
                                     CREATEDBYNAME VARCHAR2(60)  NULL,
                                     CREATEDTIME DATE NULL,
                                     CREATEDBYORGID VARCHAR2(36)  NULL,
                                     CREATEDBYORGNAME VARCHAR2(270)  NULL,
                                     ORGID VARCHAR2(36)  NULL,
                                     ORGNAME VARCHAR2(270)  NULL,
                                     REMARKS VARCHAR2(360)  NULL,
                                     PREORDERID NUMBER NULL,
                                     PROCESSNAME VARCHAR2(270)  NULL,
                                     PROCESSID NUMBER NULL,
                                     OPERATOR VARCHAR2(60)  NULL,
                                     OPERATORID VARCHAR2(36)  NULL,
                                     EQUIPTNAME VARCHAR2(270)  NULL,
                                     EQUIPTCODE VARCHAR2(270)  NULL,
                                     EQUIPTID NUMBER NULL,
                                     OPERATETIME DATE NULL,
                                     ELNID NUMBER NULL
);
COMMENT ON TABLE T_LIMS_ORDER_PROCESS IS '样品处理工序';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.PREORDERID IS '预处理样品ID';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.PROCESSNAME IS '工序';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.PROCESSID IS '工序ID';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.OPERATOR IS '操作人';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.OPERATORID IS '操作人ID';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.EQUIPTNAME IS '设备名称';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.EQUIPTCODE IS '设备编码';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.EQUIPTID IS '设备ID';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.OPERATETIME IS '操作时间';
COMMENT ON COLUMN T_LIMS_ORDER_PROCESS.ELNID IS 'ELN';

ALTER TABLE T_LIMS_ORDER_PROCESS ADD CONSTRAINT PK_LIMS_ORDER_PROCESS PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDER_PROCESS.SERVICE_NAME', '样品处理工序', '样品处理工序', 'zh-CN', '样品处理工序');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.ID', '样品处理工序的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.CREATEDBYID', '样品处理工序的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.CREATEDBYNAME', '样品处理工序的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.CREATEDTIME', '样品处理工序的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.CREATEDBYORGID', '样品处理工序的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.CREATEDBYORGNAME', '样品处理工序的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.ORGID', '样品处理工序的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.ORGNAME', '样品处理工序的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.REMARKS', '样品处理工序的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.PREORDERID', '样品处理工序的预处理样品ID', '预处理样品ID', 'zh-CN', '预处理样品ID');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.PROCESSNAME', '样品处理工序的工序', '工序', 'zh-CN', '工序');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.PROCESSID', '样品处理工序的工序ID', '工序ID', 'zh-CN', '工序ID');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.OPERATOR', '样品处理工序的操作人', '操作人', 'zh-CN', '操作人');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.OPERATORID', '样品处理工序的操作人ID', '操作人ID', 'zh-CN', '操作人ID');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.EQUIPTNAME', '样品处理工序的设备名称', '设备名称', 'zh-CN', '设备名称');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.EQUIPTCODE', '样品处理工序的设备编码', '设备编码', 'zh-CN', '设备编码');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.EQUIPTID', '样品处理工序的设备ID', '设备ID', 'zh-CN', '设备ID');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.OPERATETIME', '样品处理工序的操作时间', '操作时间', 'zh-CN', '操作时间');
CALL INSERTI18N('T_LIMS_ORDER_PROCESS.ELNID', '样品处理工序的ELN', 'ELN', 'zh-CN', 'ELN');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERPROCESSS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERPROCESSS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERPROCESSS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERPROCESSS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDERPROCESSS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end
-- ----------------------------- 2022-09-09 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ORDTASK(
                               ID NUMBER NOT NULL,
                               CREATEDBYID VARCHAR2(36)  NULL,
                               CREATEDBYNAME VARCHAR2(60)  NULL,
                               CREATEDTIME DATE NULL,
                               CREATEDBYORGID VARCHAR2(36)  NULL,
                               CREATEDBYORGNAME VARCHAR2(270)  NULL,
                               REMARKS VARCHAR2(360)  NULL,
                               ORGID VARCHAR2(36)  NULL,
                               ORGNAME VARCHAR2(270)  NULL,
                               ORDERID NUMBER NULL,
                               TASKID NUMBER NULL,
                               ORDERCODE VARCHAR2(270)  NULL,
                               COLLECTSTATUS VARCHAR2(36)  NULL,
                               EQUIPTNAME VARCHAR2(270)  NULL,
                               EQUIPTCODE VARCHAR2(270)  NULL,
                               EQUIPTID NUMBER NULL,
                               OPERATOR VARCHAR2(60)  NULL,
                               OPERATORID VARCHAR2(36)  NULL,
                               OPERATETIME DATE NULL,
                               PROCESSNAME VARCHAR2(270)  NULL,
                               PROCESSID NUMBER NULL,
                               PROCESSSTATUS VARCHAR2(36)  NULL,
                               PROCESSRESULT VARCHAR2(270)  NULL,
                               UNIT VARCHAR2(36)  NULL,
                               REVISIONRULE VARCHAR2(270)  NULL,
                               FORMULA VARCHAR2(270)  NULL
);
COMMENT ON TABLE T_LIMS_ORDTASK IS '项目样品表';
COMMENT ON COLUMN T_LIMS_ORDTASK.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ORDTASK.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ORDTASK.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ORDTASK.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ORDTASK.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ORDTASK.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_ORDTASK.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_ORDTASK.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_ORDTASK.ORDERID IS '样品ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.TASKID IS '任务ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.ORDERCODE IS '电池编号';
COMMENT ON COLUMN T_LIMS_ORDTASK.COLLECTSTATUS IS '数据采集状态';
COMMENT ON COLUMN T_LIMS_ORDTASK.EQUIPTNAME IS '设备名称';
COMMENT ON COLUMN T_LIMS_ORDTASK.EQUIPTCODE IS '设备编号';
COMMENT ON COLUMN T_LIMS_ORDTASK.EQUIPTID IS '设备ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.OPERATOR IS '操作人';
COMMENT ON COLUMN T_LIMS_ORDTASK.OPERATORID IS '操作人ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.OPERATETIME IS '操作时间';
COMMENT ON COLUMN T_LIMS_ORDTASK.PROCESSNAME IS '工序名称';
COMMENT ON COLUMN T_LIMS_ORDTASK.PROCESSID IS '工序ID';
COMMENT ON COLUMN T_LIMS_ORDTASK.PROCESSSTATUS IS '状态';
COMMENT ON COLUMN T_LIMS_ORDTASK.PROCESSRESULT IS '结果';
COMMENT ON COLUMN T_LIMS_ORDTASK.UNIT IS '单位';
COMMENT ON COLUMN T_LIMS_ORDTASK.REVISIONRULE IS '修约规则';
COMMENT ON COLUMN T_LIMS_ORDTASK.FORMULA IS '计算公式';

ALTER TABLE T_LIMS_ORDTASK ADD CONSTRAINT PK_LIMS_ORDTASK PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ORDTASK.SERVICE_NAME', '项目样品表', '项目样品表', 'zh-CN', '项目样品表');
CALL INSERTI18N('T_LIMS_ORDTASK.ID', '项目样品表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ORDTASK.CREATEDBYID', '项目样品表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ORDTASK.CREATEDBYNAME', '项目样品表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ORDTASK.CREATEDTIME', '项目样品表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ORDTASK.CREATEDBYORGID', '项目样品表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ORDTASK.CREATEDBYORGNAME', '项目样品表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_ORDTASK.REMARKS', '项目样品表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ORDTASK.ORGID', '项目样品表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_ORDTASK.ORGNAME', '项目样品表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_ORDTASK.ORDERID', '项目样品表的样品ID', '样品ID', 'zh-CN', '样品ID');
CALL INSERTI18N('T_LIMS_ORDTASK.TASKID', '项目样品表的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('T_LIMS_ORDTASK.ORDERCODE', '项目样品表的电池编号', '电池编号', 'zh-CN', '电池编号');
CALL INSERTI18N('T_LIMS_ORDTASK.COLLECTSTATUS', '项目样品表的数据采集状态', '数据采集状态', 'zh-CN', '数据采集状态');
CALL INSERTI18N('T_LIMS_ORDTASK.EQUIPTNAME', '项目样品表的设备名称', '设备名称', 'zh-CN', '设备名称');
CALL INSERTI18N('T_LIMS_ORDTASK.EQUIPTCODE', '项目样品表的设备编号', '设备编号', 'zh-CN', '设备编号');
CALL INSERTI18N('T_LIMS_ORDTASK.EQUIPTID', '项目样品表的设备ID', '设备ID', 'zh-CN', '设备ID');
CALL INSERTI18N('T_LIMS_ORDTASK.OPERATOR', '项目样品表的操作人', '操作人', 'zh-CN', '操作人');
CALL INSERTI18N('T_LIMS_ORDTASK.OPERATORID', '项目样品表的操作人ID', '操作人ID', 'zh-CN', '操作人ID');
CALL INSERTI18N('T_LIMS_ORDTASK.OPERATETIME', '项目样品表的操作时间', '操作时间', 'zh-CN', '操作时间');
CALL INSERTI18N('T_LIMS_ORDTASK.PROCESSNAME', '项目样品表的工序名称', '工序名称', 'zh-CN', '工序名称');
CALL INSERTI18N('T_LIMS_ORDTASK.PROCESSID', '项目样品表的工序ID', '工序ID', 'zh-CN', '工序ID');
CALL INSERTI18N('T_LIMS_ORDTASK.PROCESSSTATUS', '项目样品表的状态', '状态', 'zh-CN', '状态');
CALL INSERTI18N('T_LIMS_ORDTASK.PROCESSRESULT', '项目样品表的结果', '结果', 'zh-CN', '结果');
CALL INSERTI18N('T_LIMS_ORDTASK.UNIT', '项目样品表的单位', '单位', 'zh-CN', '单位');
CALL INSERTI18N('T_LIMS_ORDTASK.REVISIONRULE', '项目样品表的修约规则', '修约规则', 'zh-CN', '修约规则');
CALL INSERTI18N('T_LIMS_ORDTASK.FORMULA', '项目样品表的计算公式', '计算公式', 'zh-CN', '计算公式');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.ORDTASKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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


COMMIT;

-- ----------------------------- 2022-09-09 add by lijiaxing------------end

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('sampleObtainStatus', '收样状态', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209131901, '待收样', '1', 1, 'sampleObtainStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209131902, '已收样', '2', 2, 'sampleObtainStatus', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
    (202209131637,'样品选择','样品选择','orderChoose','/secure/basemodule/business/test/orders/page/choose-list','80%');


CALL INSERTI18N('T_LIMS_ORDER_PROCESS.STATUS', '状态', '状态', 'zh-CN', '状态');
CALL INSERTI18N('T_LIMS_ORDTASK.STATUS', '状态', '状态', 'zh-CN', '状态');

ALTER TABLE T_LIMS_ORDER_PROCESS ADD (STATUS VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_ORDTASK  ADD (STATUS VARCHAR2(36) DEFAULT NULL NULL);

INSERT INTO "T_CORE_SEQUENCE" ("ID", "PATTERN", "JSONPARAM")
VALUES ('T_LIMS_FOLDER_FOLDERNO', '[yy][mm][dd][nnnn]', '[{"dd":"19","mm":"07","n":6,"yyyy":"22"}]');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('orderProcessStatus', '预处理状态', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209151901, '待开始', '1', 1, 'orderProcessStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209151902, '完成', '2', 2, 'orderProcessStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209151903, '跳过', '3', 3, 'orderProcessStatus', 0, 'admin', '系统管理员', '0');


INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('collectStatus', '采集状态', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152001, '未采集', '1', 1, 'collectStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152002, '已采集', '2', 2, 'collectStatus', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('processStatus', '工序状态', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152101, '待开始', '1', 1, 'processStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152102, '完成', '2', 2, 'processStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152103, '跳过', '3', 3, 'processStatus', 0, 'admin', '系统管理员', '0');

INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('testGroup', '测试组', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152201, '软包组', 'RB', 1, 'testGroup', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152202, '扣电组', 'KD', 2, 'testGroup', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152203, '物理组', 'WL', 3, 'testGroup', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152204, '化学组', 'HX', 4, 'testGroup', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209152205, '综合管理组', 'ZH', 5, 'testGroup', 0, 'admin', '系统管理员', '0');

ALTER TABLE T_LIMS_FOLDER ADD (SUBMITUSERID VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER ADD (SUBMITUSERNAME VARCHAR2(60) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER ADD (SUBMITTIME DATE DEFAULT NULL NULL);

-- ----------------------------- 2022-09-16 add by lijiaxing--------------begin

-- 建表语句
CREATE TABLE T_LIMS_REPORT(
                              ID NUMBER NOT NULL,
                              CREATEDBYID VARCHAR2(36)  NULL,
                              CREATEDBYNAME VARCHAR2(60)  NULL,
                              CREATEDTIME DATE NULL,
                              CREATEDBYORGID VARCHAR2(36)  NULL,
                              CREATEDBYORGNAME VARCHAR2(270)  NULL,
                              ORGID VARCHAR2(36)  NULL,
                              ORGNAME VARCHAR2(270)  NULL,
                              REMARKS VARCHAR2(360)  NULL,
                              REPORTNAME VARCHAR2(270)  NULL,
                              FOLDERID NUMBER NULL,
                              TASKID NUMBER NULL
);
COMMENT ON TABLE T_LIMS_REPORT IS '报告表';
COMMENT ON COLUMN T_LIMS_REPORT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_REPORT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_REPORT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_REPORT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_REPORT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_REPORT.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_REPORT.ORGID IS '组织ID';
COMMENT ON COLUMN T_LIMS_REPORT.ORGNAME IS '组织名称';
COMMENT ON COLUMN T_LIMS_REPORT.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_REPORT.REPORTNAME IS '报告名称';
COMMENT ON COLUMN T_LIMS_REPORT.FOLDERID IS '委托单ID';
COMMENT ON COLUMN T_LIMS_REPORT.TASKID IS '任务ID';

ALTER TABLE T_LIMS_REPORT ADD CONSTRAINT PK_LIMS_REPORT PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_REPORT.SERVICE_NAME', '报告表', '报告表', 'zh-CN', '报告表');
CALL INSERTI18N('T_LIMS_REPORT.ID', '报告表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_REPORT.CREATEDBYID', '报告表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_REPORT.CREATEDBYNAME', '报告表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_REPORT.CREATEDTIME', '报告表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_REPORT.CREATEDBYORGID', '报告表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_REPORT.CREATEDBYORGNAME', '报告表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_REPORT.ORGID', '报告表的组织ID', '组织ID', 'zh-CN', '组织ID');
CALL INSERTI18N('T_LIMS_REPORT.ORGNAME', '报告表的组织名称', '组织名称', 'zh-CN', '组织名称');
CALL INSERTI18N('T_LIMS_REPORT.REMARKS', '报告表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_REPORT.REPORTNAME', '报告表的报告名称', '报告名称', 'zh-CN', '报告名称');
CALL INSERTI18N('T_LIMS_REPORT.FOLDERID', '报告表的委托单ID', '委托单ID', 'zh-CN', '委托单ID');
CALL INSERTI18N('T_LIMS_REPORT.TASKID', '报告表的任务ID', '任务ID', 'zh-CN', '任务ID');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.REPORTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.REPORTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.REPORTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.REPORTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.REPORTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

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


COMMIT;

-- ----------------------------- 2022-09-16 add by lijiaxing------------end
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
VALUES ('folderStatus', '委托单状态', 'sys');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192201, '草稿', 'Draft', 1, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192202, '作废', 'Cancel', 2, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192203, '直接领导审核', 'DirectAudit', 3, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192204, '二级部门负责人审核', 'SecondAudit', 4, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192205, '一级部门负责人审核', 'StairAudit', 5, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192206, '检测组负责人审核', 'DetectionAudit', 6, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192207, '样品接收', 'SampleReceive', 7, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192208, '试验中', 'Test', 8, 'folderStatus', 0, 'admin', '系统管理员', '0');
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
VALUES  (202209192209, '完成', 'Done', 9, 'folderStatus', 0, 'admin', '系统管理员', '0');


INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
    (202209192301,'委托单选择','委托单选择','folderChoose','/secure/basemodule/business/test/folders/page/choose-list','80%');

ALTER TABLE T_LIMS_TASK  ADD (PROJECTGROUP VARCHAR2(270) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_ORDER  ADD (PROJECTGROUP VARCHAR2(270) DEFAULT NULL NULL);


INSERT INTO t_core_schedule_task (ID, TASKNAME, TYPE, SERVICENAME, METHODNAME, REMARK, CREATEDBYID,
    CREATEDBYNAME, CREATEDTIME, CREATEDBYORGID, CREATEDBYORGNAME,
    IFEXECUTABLESERVICENAME, IFEXECUTABLEMETHODNAME)
VALUES ('qualityTimeTask', '质控样定时提交', 'service',
        'com.sunwayworld.basemodule.business.test.folder.service.LimsFolderService', 'qualityTimeTask', NULL, NULL, NULL,
        NULL, NULL, NULL, NULL, NULL);

ALTER TABLE T_LIMS_TASK  ADD (STANDARDQUANTITY NUMBER(16,2) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (SPECIMENTASKTIME DATE DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (SPECIMENSTATUS VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_ORDTASK  ADD (HIGHLIMIT NUMBER(16,2) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_ORDTASK  ADD (LOWLIMIT NUMBER(16,2) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_ORDTASK  MODIFY (PROCESSRESULT NUMBER(16,2));
ALTER TABLE T_LIMS_ORDTASK_EXCEPTION  ADD (PREORDERID NUMBER DEFAULT NULL NULL);

ALTER TABLE T_LIMS_FOLDER  ADD (TASKSOURCE VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (SPECIMENFREQUENCY VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_TASK  ADD (TASKSOURCE VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_TASK  ADD (SPECIMENFREQUENCY VARCHAR2(36) DEFAULT NULL NULL);

INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
    (202209261637,'委托单项目','委托单项目','taskChoose','/secure/basemodule/business/test/tasks/page/choose-list','80%');

ALTER TABLE T_LIMS_TASK  ADD (HIGHLIMIT NUMBER(16,2) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_TASK  ADD (LOWLIMIT NUMBER(16,2) DEFAULT NULL NULL);

INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100113', '结果查询', '/secure/basemodule/business/test/folders/page/search-list?page=resultSearch', '1001', '13', '001.svg', '结果查询');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100114', '结果查询(理化)', '/secure/basemodule/business/test/folders/page/search-list?page=resultSearch2', '1001', '14', '001.svg', '结果查询(理化)');

CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.EXCEPTIONMESSAGE', '异常登记', '异常登记', 'zh-CN', '异常登记');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.PREPROCESS', '预处理', '预处理', 'zh-CN', '预处理');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TAB.SAMPLETASK', '样品项目', '样品项目', 'zh-CN', '样品项目');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDERS.TEXT.PRINTLABEL', '打印标签', '打印标签', 'zh-CN', '打印标签');

INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100115', '样品接收查询', '/secure/basemodule/business/test/folders/page/search-list?page=sampleReceiveSearch', '1001', '15', '001.svg', '样品接收查询');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100116', '样品预处理查询', '/secure/basemodule/business/test/folders/page/search-list?page=sampleDisposeSearch', '1001', '16', '001.svg', '样品预处理查询');

ALTER TABLE T_LIMS_ORDER  MODIFY (ELECTROLYTE VARCHAR2(60));


INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('100117', '试验数据查询', '/secure/basemodule/business/test/folders/page/statisticsDataPage', '1001', '17', '001.svg', '试验数据查询');

ALTER TABLE T_LIMS_FOLDER  ADD (OBTAINTIME DATE DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (OBTAINUSERID VARCHAR2(36) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (OBTAINUSERNAME VARCHAR2(270)  DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (FINISHTIME DATE DEFAULT NULL NULL);

CALL INSERTI18N('T_LIMS_FOLDER.OBTAINTIME', '收样时间', '收样时间', 'zh-CN', '收样时间');
CALL INSERTI18N('T_LIMS_FOLDER.OBTAINUSERID', '收样人ID', '收样人ID', 'zh-CN', '收样人ID');
CALL INSERTI18N('T_LIMS_FOLDER.OBTAINUSERNAME', '收样人', '收样人', 'zh-CN', '收样人');
CALL INSERTI18N('T_LIMS_FOLDER.FINISHTIME', '完成时间', '完成时间', 'zh-CN', '完成时间');
CALL INSERTI18N('T_LIMS_FOLDER.SUBMITTIME', '提交时间', '提交时间', 'zh-CN', '提交时间');

ALTER TABLE T_LIMS_FOLDER  ADD (INSPECTIONCODE VARCHAR2(270) DEFAULT NULL NULL);
ALTER TABLE T_LIMS_FOLDER  ADD (FACTORY VARCHAR2(270) DEFAULT NULL NULL);