-- ----------------------------- 2024-05-31 add by zhangs------------begin
ALTER TABLE t_lims_equip_maintain_record ADD MAINTAINTYPE varchar(100) NULL COMMENT '项目类型';
ALTER TABLE t_lims_equip_maintain_record ADD MAINTAINITEM varchar(100) NULL COMMENT '保养/点检项目 ';
ALTER TABLE t_lims_equip_maintain_record ADD MAINTAINMETHOD varchar(100) NULL COMMENT '保养/点检方法';
ALTER TABLE t_lims_equip_maintain_record ADD MAINTAINDATUM varchar(100) NULL COMMENT '保养/点检基准';
-- ----------------------------- 2024-05-31 add by zhangs------------end


-- ----------------------------- 2024-06-17 add by zhangs--------------begin

-- 建表语句

CREATE TABLE IF NOT EXISTS `T_LIMS_MSGTIP`(
     `ID` BIGINT NOT NULL COMMENT '主键',
     `MSGTYPE` VARCHAR(60)  DEFAULT NULL COMMENT '消息类型',
     `MSGCONTENT` LONGTEXT 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 '制单人单位名称',
      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_MSGTIP', '1', 'zhangsheng', 'zhangsheng', NOW(), 'L005', '五行业');


INSERT INTO T_CORE_AUDIT_CONFIG (ID, NAME, CATEGORY, AUDITABLE)
VALUES ('T_LIMS_MSGTIP', '消息提示', 'service', '1');
CALL INSERTI18N('T_LIMS_MSGTIP.SERVICE_NAME', '消息提示', '消息提示', 'zh-CN', '消息提示');
CALL INSERTI18N('T_LIMS_MSGTIP.ID', '消息提示的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_MSGTIP.MSGTYPE', '消息提示的消息类型', '消息类型', 'zh-CN', '消息类型');
CALL INSERTI18N('T_LIMS_MSGTIP.MSGCONTENT', '消息提示的消息', '消息', 'zh-CN', '消息');
CALL INSERTI18N('T_LIMS_MSGTIP.CREATEDBYID', '消息提示的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_MSGTIP.CREATEDBYNAME', '消息提示的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_MSGTIP.CREATEDTIME', '消息提示的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_MSGTIP.CREATEDBYORGID', '消息提示的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_MSGTIP.CREATEDBYORGNAME', '消息提示的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDER.MOMS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDER.MOMS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDER.MOMS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDER.MOMS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.TEST.FOLDER.MOMS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


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


COMMIT;
INSERT INTO t_core_email_config (ID,TEMPLATEID,CONFIGNAME,REMARK,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME) VALUES
('MOM_TIP_TEMPLATE','MOM_TIP_TEMPLATE','MOM建单提醒',NULL,NULL,'zhangs','张胜','2024-06-17 16:17:55','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,'0',NULL,NULL,NULL);

INSERT INTO t_core_email_template (ID,TEMPLATENAME,REMARK,EMAILSUBJECT,EMAILBODY,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME) VALUES
('MOM_TIP_TEMPLATE','MOM建单提醒','MOM建单提醒','MOM建单提醒','&nbsp; [{msg}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

INSERT INTO t_core_email_config_receipent (ID,CONFIGID,RECEIPENTID,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
 (1412283571704800,'MOM_TIP_TEMPLATE','admin','zhangs','张胜','2024-06-17 16:18:17','RT','湖北融通高科先进材料股份有限公司'),
 (1412283571704801,'MOM_TIP_TEMPLATE','zhangs','zhangs','张胜','2024-06-17 16:18:17','RT','湖北融通高科先进材料股份有限公司');

INSERT INTO t_core_menu (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES
 	 ('20240617001','MOM建单错误提醒','/secure/basemodule/business/test/folder/msgtips/page/search-list','93',2023060815,'MOM建单错误提醒',NULL,NULL,NULL,'024.svg',NULL,NULL);

 INSERT INTO t_core_schedule_task (ID,TASKNAME,`TYPE`,SERVICENAME,METHODNAME,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,IFEXECUTABLESERVICENAME,IFEXECUTABLEMETHODNAME) VALUES
 ('SEND_MAIL','邮件调用','service','com.sunwayworld.cloud.module.email.service.CoreEmailService','startEmailJob','邮件调用',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

 INSERT INTO t_core_schedule_task_config (ID,CONFIGNAME,TASKID,PARAM,CRON,TIMES,REMARK,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,ACTIVATEDFLAG,ACTIVATEDBYID,ACTIVATEDBYNAME,ACTIVATEDTIME,UID,STARTTIME,ENDTIME) VALUES
 ('20240600001',NULL,'SEND_MAIL',NULL,'0 0/5 * * * ?',0,NULL,NULL,'zhangs','张胜','2024-06-17 16:45:36','RT','湖北融通高科先进材料股份有限公司','1','zhangs','张胜','2024-06-17 16:46:25','20240600001',NULL,NULL);
-- ----------------------------- 2024-06-17 add by zhangs------------end

ALTER TABLE t_lims_folder ADD MOMTASKCHECK varchar(1) NULL COMMENT 'MOM检漏标记';
INSERT INTO t_core_schedule_task (ID,TASKNAME,SERVICENAME,METHODNAME,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,`TYPE`,IFEXECUTABLESERVICENAME,IFEXECUTABLEMETHODNAME) VALUES
('retryInsertTaskHistory','mom试验检漏处理','com.sunwayworld.basemodule.business.test.folder.mom.service.impl.MOMServiceImpl','retryInsertTaskHistory',NULL,NULL,NULL,NULL,NULL,NULL,'service',NULL,NULL);
update t_lims_folder set momTaskCheck=0;
INSERT INTO t_lims_dbextract_config (ID,EXTRACTID,`SQL`,ARGS,ENABLE,RESOLVEFUNCTION,REMARK,NAME) VALUES
	 (1412472089189152,1289770010698624,'select * from d_qa_simpling_item where simplingGid=''#{simplingGid}''','simplingGid','1',NULL,NULL,'根据取样单ID查询取样任务明细'),
	 (1412478559550240,1289770010698624,'select * from d_qa_simpling_inspection where gid=''#{gid}''','gid','1',NULL,NULL,'根据取样单ID查询取样单');



-- ----------------------------- 2024-06-18 add by zhangs------------begin


truncate table t_lims_report_template;
truncate table t_lims_report_template_authorg;
truncate table t_lims_report_template_column;
truncate table t_lims_report_template_file;
truncate table t_lims_report_template_func;
truncate table t_lims_report_template_source;
truncate table t_lims_report_template_sub;

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
	 (986179030725984,986178195510624,'s','detail','SELECT A.ID,
       F.CLIENTUSERORGNAME,
       F.SAMPLENAME,
       F.LAB,
       F.ORGNAME,
  F.CLIENTUSERORGNAME AS TWOORGNAME,
  F.CLIENTUSERID,
  F.CLIENTUSERNAME,
  T.TESTNAME,
  CASE
   WHEN F.SAMPLETYPE =''lithium'' THEN ''lithium ion battery''
   WHEN F.SAMPLETYPE =''solid'' THEN ''固体''
   WHEN F.SAMPLETYPE =''liquid'' THEN ''液体''
   ELSE ''气体''
  END AS  SAMPLETYPE,
  OT.EQUIPTCODE,
  CASE
  WHEN F.TOTALINSPECTION IS NULL THEN  1
  ELSE F.TOTALINSPECTION
  END AS TOTALINSPECTION，
  O.OBTAINTIME,
  F.CREATEDTIME,
   sysdate AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
   T.RESULT,
   F.REMARKS
FROM T_LIMS_REPORT_APPLY A
LEFT JOIN T_LIMS_FOLDER F ON F.ID = A.FOLDERID
LEFT JOIN T_LIMS_ORDER O ON F.ID = O.FOLDERID
LEFT JOIN T_LIMS_TASK T ON T.PREORDERID = O.ID
LEFT JOIN T_LIMS_ORDTASK OT ON OT.ORDERID = O.ID',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-10-24 15:46:22','WL','物理组','s','T_LIMS_REPORT_APPLY',NULL,NULL),
	 (986743372568352,986742871988000,'s','detail','SELECT A.ID,
       F.CLIENTUSERORGNAME,
       F.SAMPLENAME,
       F.LAB,
       F.ORGNAME,
       F.FOLDERNO,
       F.CLIENTUSERPHONE,
       F.OBTAINUSERNAME,
  F.CLIENTUSERORGNAME AS TWOORGNAME,
  F.CLIENTUSERID,
  F.CLIENTUSERNAME,
  T.TESTNAME,
  CASE
   WHEN F.SAMPLETYPE =''lithium'' THEN ''lithium ion battery''
   WHEN F.SAMPLETYPE =''solid'' THEN ''固体''
   WHEN F.SAMPLETYPE =''liquid'' THEN ''液体''
   ELSE ''气体''
  END AS  SAMPLETYPE,
  OT.EQUIPTCODE,
  CASE
  WHEN F.TOTALINSPECTION IS NULL THEN  1
  ELSE F.TOTALINSPECTION
  END AS TOTALINSPECTION，
  O.OBTAINTIME,
  F.CREATEDTIME,
  sysdate as TIME,
  TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
   T.RESULT,
   F.REMARKS,
   T.METHODNAME,
   OT.OPERATETIME
FROM T_LIMS_REPORT_APPLY A
LEFT JOIN T_LIMS_FOLDER F ON F.ID = A.FOLDERID
LEFT JOIN T_LIMS_ORDER O ON F.ID = O.FOLDERID
LEFT JOIN T_LIMS_TASK T ON T.PREORDERID = O.ID
LEFT JOIN T_LIMS_ORDTASK OT ON OT.ORDERID = O.ID',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-10-25 10:54:31','WL','物理组','s','T_LIMS_REPORT_APPLY',NULL,NULL),
	 (986839987885856,986742871988000,'tasks','list','SELECT C.ID,
         T.RESULT,
       T.TESTNAME,
       F.REMARKS,
       TLTA.UNIT
       FROM T_LIMS_REPORT_APPLY C
         INNER JOIN T_LIMS_FOLDER F ON F.ID = C.FOLDERID
         LEFT JOIN T_LIMS_ORDER O ON F.ID = O.FOLDERID
         INNER JOIN T_LIMS_TASK T ON T.FOLDERID = F.ID
         LEFT JOIN T_LIMS_TM_ANALYST tlta ON TLTA.testmethodid=T.testmethodid AND TLTA.ANALYSTNAME=''含量''',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-10-25 14:11:05','WL','物理组','tasks','T_LIMS_REPORT_APPLY',NULL,NULL),
	 (986844382754592,986843171559200,'s','detail','SELECT A.ID,
       F.CLIENTUSERORGNAME,
       F.SAMPLENAME,
       F.LAB,
       F.ORGNAME,
 F.CLIENTUSERORGNAME AS TWOORGNAME,
  F.CLIENTUSERID,
  F.CLIENTUSERNAME,
  T.TESTNAME,
  CASE
   WHEN F.SAMPLETYPE =''lithium'' THEN ''lithium ion battery''
   WHEN F.SAMPLETYPE =''solid'' THEN ''固体''
   WHEN F.SAMPLETYPE =''liquid'' THEN ''液体''
   ELSE ''气体''
  END AS  SAMPLETYPE,
  OT.EQUIPTCODE,
  CASE
  WHEN F.TOTALINSPECTION IS NULL THEN  1
  ELSE F.TOTALINSPECTION
  END AS TOTALINSPECTION，
  O.OBTAINTIME,
  F.CREATEDTIME,
   sysdate AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
   T.RESULT,
   F.REMARKS
FROM T_LIMS_REPORT_CHANGE A
LEFT JOIN T_LIMS_FOLDER F ON F.ID = A.FOLDERID
LEFT JOIN T_LIMS_ORDER O ON F.ID = O.FOLDERID
LEFT JOIN T_LIMS_TASK T ON T.PREORDERID = O.ID
LEFT JOIN T_LIMS_ORDTASK OT ON OT.ORDERID = O.ID',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-10-25 14:20:02','WL','物理组','s','T_LIMS_REPORT_CHANGE',NULL,NULL),
	 (998731030198272,997311422626112,'folder','list','SELECT F.ID,F.FOLDERNO,
       F.CREATEDTIME,
       F.CLIENTUSERNAME,
       F.SAMPLENAME,
       O.SAMPLECODE,
       O.MATERIALNAME,
       F.WORKSHOPSECTION,
       to_char(sysdate,''yyyy-mm-dd hh24:mi'') AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
        C.CODENAME,
       (SELECT listagg(DECODE(T1.URGENCYDEGREE,''2'',CONCAT(T1.TESTNAME,''*'') ,T1.TESTNAME ),'','') WITHIN GROUP (ORDER BY O.SAMPLECODE) FROM T_LIMS_TASK t1 WHERE t1.PREORDERID=O.ID) AS TESTNAME,
       (SELECT listagg(taskcondition,'','') WITHIN GROUP (ORDER BY O.SAMPLECODE,t1.TESTCODE ASC) FROM (select T.ID,t.PREORDERID,T.TESTCODE,t.testname||'':''||nvl(t2.CONDITIONNAME,'''')||nvl(t2.CONDITIONVALUE,'''')||nvl(t2.CONDITIONUNIT,'''') taskcondition from T_LIMS_TASK T
		INNER JOIN T_LIMS_TASK_CONDITION t2 ON T.ID=t2.TASKID) t1 WHERE t1.PREORDERID=O.ID ) AS TESTcondition,
       --SUBSTR(F.REMARKS,0,50) AS REMARKS,
       SUBSTR(DECODE(E.ID,NULL,'''',''有附件,'')||DECODE(F.SAMPLEHANDLETYPE,''develop'',''需退样,'' ,''''  )||F.REMARKS,0,150) AS REMARKS,
     DECODE(F.URGENCYDEGREE,''2'',''☑'' ,''□''  )   AS B,
      CASE
    WHEN O.TESTGROUP = ''WL'' THEN ''物理组''
    WHEN O.TESTGROUP = ''HX'' THEN ''化学组''
    WHEN O.TESTGROUP = ''KD'' THEN ''扣电组''
    ELSE ''软包组''
END  AS TESTGROUP
FROM T_LIMS_FOLDER F
        INNER JOIN T_LIMS_ORDER O  ON F.ID = O.FOLDERID
LEFT JOIN T_CORE_CODE C ON C.CODECATEGORYID = ''workshopSection'' AND C.CODE = F.WORKSHOPSECTION
LEFT JOIN T_CORE_FILE E ON E.TARGETID =CONCAT(''T_LIMS_FOLDER$'',F.ID) AND E.BIZCATEGORY = ''common''
WHERE nvl(F.SAMPLETYPE,''1'') <> ''lithium'' AND O.PREORDERID IS  NULL AND O.SAMPLECODE IS NOT NULL',NULL,'{id_IN:"${ids}"}',NULL,'admin','系统管理员','2022-11-11 09:23:28','HX','化学组','folder','T_LIMS_FOLDER',NULL,NULL),
	 (1021548370226528,1008075617713184,'s','detail','SELECT A.ID,
       F.CLIENTUSERORGNAME,
       F.SAMPLENAME,
       F.LAB,
       F.ORGNAME,
       F.FOLDERNO,
       F.CLIENTUSERPHONE,
       F.OBTAINUSERNAME,
  F.CLIENTUSERORGNAME AS TWOORGNAME,
  F.CLIENTUSERID,
  F.CLIENTUSERNAME,
  T.TESTNAME,
  CASE
   WHEN F.SAMPLETYPE =''lithium'' THEN ''lithium ion battery''
   WHEN F.SAMPLETYPE =''solid'' THEN ''固体''
   WHEN F.SAMPLETYPE =''liquid'' THEN ''液体''
   ELSE ''气体''
  END AS  SAMPLETYPE,
  OT.EQUIPTCODE,
  CASE
  WHEN F.TOTALINSPECTION IS NULL THEN  1
  ELSE F.TOTALINSPECTION
  END AS TOTALINSPECTION，
  O.OBTAINTIME,
  F.CREATEDTIME,
   sysdate AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
   T.RESULT,
   F.REMARKS,
   T.METHODNAME,
   OT.OPERATETIME
FROM T_LIMS_REPORT_CHANGE A
LEFT JOIN T_LIMS_FOLDER F ON F.ID = A.FOLDERID
LEFT JOIN T_LIMS_ORDER O ON F.ID = O.FOLDERID
LEFT JOIN T_LIMS_TASK T ON T.PREORDERID = O.ID
LEFT JOIN T_LIMS_ORDTASK OT ON OT.ORDERID = O.ID',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-12-13 15:05:28','00013962','化学组','s','T_LIMS_REPORT_CHANGE',NULL,NULL),
	 (1021549024660832,1008075617713184,'tasks','detail','SELECT T.RESULT,
       T.TESTNAME,
       T.REMARKS,
       C.ID,
       TLTA.UNIT
FROM T_LIMS_REPORT_CHANGE  C
         INNER JOIN T_LIMS_FOLDER F ON F.ID = C.FOLDERID
         INNER JOIN T_LIMS_TASK T ON T.FOLDERID = F.ID
         LEFT JOIN T_LIMS_TM_ANALYST tlta ON TLTA.testmethodid=T.testmethodid AND TLTA.ANALYSTNAME=''含量''',NULL,'{id_IN:"${id}"}',NULL,'admin','系统管理员','2022-12-13 15:06:48','00013962','化学组','s','T_LIMS_REPORT_CHANGE',NULL,NULL),
	 (1032278770089376,1032273338645920,'1423353','detail',NULL,NULL,'353','5353','admin','系统管理员','2022-12-28 18:56:32','00013962','化学组','5353','535','5353',NULL),
	 (1032279509400992,1032273338645920,'1','detail',NULL,NULL,NULL,NULL,'admin','系统管理员','2022-12-28 18:58:02','00013962','化学组','1','1',NULL,NULL),
	 (1032299068079520,1032299067170208,'1423353','detail',NULL,NULL,'353','5353','admin','系统管理员','2022-12-28 19:37:49','00013962','化学组','5353','535','5353',NULL);
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
	 (1032299068079521,1032299067170208,'1','detail',NULL,NULL,NULL,NULL,'admin','系统管理员','2022-12-28 19:37:49','00013962','化学组','1','1',NULL,NULL),
	 (1032300707536288,1032300706782624,'1423353','detail',NULL,NULL,'353','5353','admin','系统管理员','2022-12-28 19:41:10','00013962','化学组','5353','535','5353',NULL),
	 (1032300707536289,1032300706782624,'1','detail',NULL,NULL,NULL,NULL,'admin','系统管理员','2022-12-28 19:41:10','00013962','化学组','1','1',NULL,NULL),
	 (1032683405016480,1032677566463392,'213','list','select leaderid from t_core_user',NULL,NULL,NULL,'admin','系统管理员','2022-12-29 08:39:45','00013962','化学组','2123','1231231',NULL,NULL),
	 (1040673662337952,1040672640590752,'order','list','SELECT O.ID,
       F.FOLDERNO,
       F.CREATEDTIME,
       F.CLIENTUSERNAME,
       F.SAMPLENAME,
       O.SAMPLECODE,
       O.MATERIALNAME,
       F.WORKSHOPSECTION,
       sysdate AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
        C.CODENAME,
       (SELECT listagg(DECODE(T1.URGENCYDEGREE,''2'',CONCAT(''□''||T1.TESTNAME,''*'') ,''□''||T1.TESTNAME ),'','') WITHIN GROUP (ORDER BY O.SAMPLECODE) FROM T_LIMS_TASK t1 WHERE t1.PREORDERID=O.ID) AS TESTNAME,
       SUBSTR(F.REMARKS,0,50) AS REMARKS
FROM T_LIMS_ORDER O
        LEFT JOIN T_LIMS_FOLDER F  ON F.ID = O.FOLDERID
LEFT JOIN T_CORE_CODE C ON C.CODECATEGORYID = ''workshopSection'' AND C.CODE = F.WORKSHOPSECTION
LEFT JOIN T_CORE_FILE E ON E.TARGETID =CONCAT(''T_LIMS_FOLDER$'',F.ID) AND E.BIZCATEGORY = ''common''
WHERE nvl(F.SAMPLETYPE,''1'') <> ''lithium''',NULL,'{id_IN:"${ids}"}',NULL,'admin','系统管理员','2023-01-09 15:35:59','00013962','化学组','order','T_LIMS_ORDER',NULL,NULL),
	 (1146080638735392,997311422626112,'folder2','list','SELECT F.ID,F.FOLDERNO,
       F.CREATEDTIME,
       F.CLIENTUSERNAME,
       O.SAMPLENAME,
       O.SAMPLECODE,
       O.MATERIALNAME,
       F.WORKSHOPSECTION,
       to_char(sysdate,''yyyy-mm-dd hh24:mi'') AS TIME,
TO_CHAR(sysdate,''yyyy'')||''年''||TO_CHAR(sysdate,''mm'')||''月''||TO_CHAR(sysdate,''dd'')||''日'' AS TIME2,
        C.CODENAME,
        (SELECT count(1) FROM T_LIMS_TASK t11 WHERE t11.FOLDERID=F.ID)||''个测试项目'' AS TESTNAME,
       --(SELECT listagg(DECODE(T1.URGENCYDEGREE,''2'',CONCAT(T1.TESTNAME,''*'') ,T1.TESTNAME ),'','') WITHIN GROUP (ORDER BY O.SAMPLECODE) FROM T_LIMS_TASK t1 WHERE t1.FOLDERID=F.ID) AS TESTNAME,
       --SUBSTR(F.REMARKS,0,50) AS REMARKS,
       SUBSTR(DECODE(E.ID,NULL,'''',''有附件,'')||DECODE(F.SAMPLEHANDLETYPE,''develop'',''需退样,'' ,''''  )||F.REMARKS,0,150) AS REMARKS,
     DECODE(F.URGENCYDEGREE,''2'',''☑'' ,''□''   )   AS B,
      CASE
    WHEN O.TESTGROUP = ''WL'' THEN ''物理组''
    WHEN O.TESTGROUP = ''HX'' THEN ''化学组''
    WHEN O.TESTGROUP = ''KD'' THEN ''扣电组''
    ELSE ''软包组''
END  AS TESTGROUP
FROM T_LIMS_FOLDER F
        INNER JOIN T_LIMS_ORDER O  ON F.ID = O.FOLDERID
LEFT JOIN T_CORE_CODE C ON C.CODECATEGORYID = ''workshopSection'' AND C.CODE = F.WORKSHOPSECTION
LEFT JOIN T_CORE_FILE E ON E.TARGETID =CONCAT(''T_LIMS_FOLDER$'',F.ID) AND E.BIZCATEGORY = ''common''
WHERE nvl(F.SAMPLETYPE,''1'') = ''lithium'' AND O.PREORDERID IS NULL AND O.SAMPLECODE IS NOT NULL',NULL,'{id_IN:"${ids}"}',NULL,'admin','系统管理员','2023-06-07 13:47:01','00013962','化学组','folder2','T_LIMS_FOLDER',NULL,NULL),
	 (1235266446393792,1235265947738560,'folder','detail',' SELECT T.*,T.ID folderId FROM T_LIMS_FOLDER T',NULL,'{"FOLDERID_EQ":"${FOLDERID}"}',NULL,'zhangs','张胜','2023-09-25 00:00:00','RT','湖北融通高科先进材料股份有限公司','委托单信息','T_LIMS_FOLDER',NULL,1223953098372192),
	 (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),
	 (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),
	 (1284662643964736,1235265947738560,'testTypeList','list','select t.* from(
select
	T.*,
	T.ID folderId
from
	T_LIMS_FOLDER T) t
',NULL,'{"FOLDERID_EQ":"${FOLDERID}"}',NULL,'admin','系统管理员','2023-12-19 00:00:00','RT','湖北融通高科先进材料股份有限公司','委托单下检测项目分类','T_LIMS_FOLDER',NULL,1284162129891104);
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
	 (1284678089910720,1284677724539328,'folder','detail','select t.* from(
                SELECT T.*,T.ID folderId,(SELECT GROUP_CONCAT( distinct M.METHODNAME, '','')
                            FROM T_LIMS_TASK M
                            WHERE M.FOLDERID = T.ID ) METHODNAME FROM T_LIMS_FOLDER T
                LEFT JOIN T_LIMS_TASK M ON M.FOLDERID = T.ID
                group by T.id
                )t

',NULL,'{"FOLDERID_EQ":"${FOLDERID}"}',NULL,'zhangs','张胜','2023-09-25 00:00:00','RT','湖北融通高科先进材料股份有限公司','委托单信息','T_LIMS_FOLDER',NULL,1223953098372192),
	 (1284686545652160,1284677724539328,'testTypeList1','list','select t.* from(
select
	T.*,
	T.ID folderId
from
	T_LIMS_FOLDER T) t
',NULL,NULL,NULL,'admin','系统管理员','2023-12-20 00:00:00','RT','湖北融通高科先进材料股份有限公司','委托单下检测项目分类（只含结果）','T_LIMS_FOLDER',NULL,1284678715689408);


INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521235659751104,521205149308736,'ID','账号',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659759296,521205149308736,'USERNAME','用户名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659775680,521205149308736,'PASSWORD','用户密码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659783872,521205149308736,'EMAIL','电子邮箱',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659792064,521205149308736,'MOBILE','手机号',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659800256,521205149308736,'IDCARD','身份证号',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659808448,521205149308736,'FAILEDLOGINATTEMPTS','输入密码错误次数',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659816640,521205149308736,'ORGID','单位编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659833024,521205149308736,'ORGNAME','单位名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659841216,521205149308736,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521235659849408,521205149308736,'PASSWORDUPDATEDTIME','密码修改时间',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659865792,521205149308736,'USERTYPE','用户类型，根据实际业务进行设置',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659882176,521205149308736,'VERSION','版本',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659890368,521205149308736,'STATUS','用户状态',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659898560,521205149308736,'USERNO','人员编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659914944,521205149308736,'EXPIREDPASSWORDUSES','过期密码使用次数',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659923136,521205149308736,'EXPIRYDATE','到期日',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659931328,521205149308736,'PARENTORGID','父组织机构编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659939520,521205149308736,'MULTILOGIN','允许重复登录',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659947712,521205149308736,'CREATEDBYID','制单人编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521235659955904,521205149308736,'CREATEDBYNAME','制单人名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659964096,521205149308736,'CREATEDTIME','制单时间',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659980480,521205149308736,'CREATEDBYORGID','制单人单位编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235659988672,521205149308736,'CREATEDBYORGNAME','制单人单位名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235660005056,521205149308736,'LASTSUSPENDEDBYID','启用/停用人编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235660021440,521205149308736,'LASTSUSPENDEDBYNAME','启用/停用人名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521235660029632,521205149308736,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-05 18:16:54','901901','北京三维天地科技有限公司'),
	 (521237718335168,521237616926400,'ORDERNO','排序码',NULL,NULL,'admin','系统管理员','2021-01-05 18:20:51','901901','北京三维天地科技有限公司'),
	 (521239954964160,521237616926400,'ID','角色编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954972352,521237616926400,'ROLENAME','角色名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521239954972353,521237616926400,'CREATEDTIME','制单日期',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954972354,521237616926400,'LASTSUSPENDEDFLAG','挂起标志（0-正常，1-挂起）',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954980544,521237616926400,'LASTSUSPENDEDTIME','挂起时间',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954980545,521237616926400,'USEDBYORGID','使用单位编码',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954980546,521237616926400,'USEDBYORGNAME','使用单位名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954988736,521237616926400,'CREATEDBYID','制单人ID',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954988737,521237616926400,'LASTSUSPENDEDBYID','挂起人ID',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954988738,521237616926400,'CREATEDBYNAME','制单人名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954996928,521237616926400,'VERSION','版本',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239954996929,521237616926400,'LASTSUSPENDEDBYNAME','最后注销人名称',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521239955005120,521237616926400,'ROLEDESC','描述',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521239955005121,521237616926400,'PASSWORDPOLICYID','密码策略',NULL,NULL,'admin','系统管理员','2021-01-05 18:25:24','901901','北京三维天地科技有限公司'),
	 (521253476392640,521250510765760,'ID','账号',NULL,NULL,'admin','系统管理员','2021-01-05 18:52:54','901901','北京三维天地科技有限公司'),
	 (521279205203968,521279069388800,'ID','主键','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205212160,521279069388800,'TARGETID','对应业务主键','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205212161,521279069388800,'MD5NAME','MD5加密的文件名称','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205220352,521279069388800,'FILEEXT','文件扩展名','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205220353,521279069388800,'SCOPE','访问范围','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205228544,521279069388800,'TIMES','下载次数','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205236736,521279069388800,'VALIDTIMEFROM','生效开始日期','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521279205236737,521279069388800,'VALIDTIMETO','生效截止日期','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205244928,521279069388800,'EXT','额外信息','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205244929,521279069388800,'CREATEDTIME','制单日期','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205244930,521279069388800,'NAME','文件名称','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205253120,521279069388800,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205253121,521279069388800,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205261312,521279069388800,'PERMANENT','长期生效','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205261313,521279069388800,'DOWNLOADABLE','是否允许下载','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205261314,521279069388800,'BIZCATEGORY','业务类型','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205269504,521279069388800,'REMARK','备注','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (521279205269505,521279069388800,'CREATEDBYORGID','制单人编码','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205269506,521279069388800,'CREATEDBYORGNAME','制单单位名称','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205277696,521279069388800,'SIZE','文件大小','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (521279205277697,521279069388800,'VERSION','文件版本','0',NULL,'admin','系统管理员','2021-01-05 19:45:15','901901','北京三维天地科技有限公司'),
	 (522700947724256,521250510765760,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947740640,521250510765760,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947748832,521250510765760,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947757024,521250510765760,'MOBILE','手机号','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947765216,521250510765760,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947773408,521250510765760,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (522700947781600,521250510765760,'ORGID','单位编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947789792,521250510765760,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947797984,521250510765760,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947806176,521250510765760,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947814368,521250510765760,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947814369,521250510765760,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947822560,521250510765760,'STATUS','用户状态','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947822561,521250510765760,'USERNO','人员编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947830752,521250510765760,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947830753,521250510765760,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (522700947838944,521250510765760,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947838945,521250510765760,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947847136,521250510765760,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947847137,521250510765760,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947855328,521250510765760,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947855329,521250510765760,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947863520,521250510765760,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947863521,521250510765760,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947863522,521250510765760,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司'),
	 (522700947871712,521250510765760,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-07 19:57:48','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528282028809920,528281717432000,'ID','账号','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028818112,528281717432000,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028818113,528281717432000,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028818114,528281717432000,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028826304,528281717432000,'MOBILE','手机号','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028826305,528281717432000,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028834496,528281717432000,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028834497,528281717432000,'ORGID','单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028842688,528281717432000,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028842689,528281717432000,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528282028842690,528281717432000,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028850880,528281717432000,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028850881,528281717432000,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028850882,528281717432000,'STATUS','用户状态','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028850883,528281717432000,'USERNO','人员编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028859072,528281717432000,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028859073,528281717432000,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028859074,528281717432000,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028867264,528281717432000,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028867265,528281717432000,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528282028867266,528281717432000,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028867267,528281717432000,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028875456,528281717432000,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028875457,528281717432000,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028875458,528281717432000,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028883648,528281717432000,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282028883649,528281717432000,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-15 17:12:32','901901','北京三维天地科技有限公司'),
	 (528282813128384,528282393525952,'ID','角色编码','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813136576,528282393525952,'ROLENAME','角色名称','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813144768,528282393525952,'CREATEDTIME','制单日期','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528282813144769,528282393525952,'LASTSUSPENDEDFLAG','挂起标志（0-正常，1-挂起）','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813152960,528282393525952,'LASTSUSPENDEDTIME','挂起时间','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813152961,528282393525952,'USEDBYORGID','使用单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813161152,528282393525952,'USEDBYORGNAME','使用单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813161153,528282393525952,'CREATEDBYID','制单人ID','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813169344,528282393525952,'LASTSUSPENDEDBYID','挂起人ID','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813169345,528282393525952,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813169346,528282393525952,'VERSION','版本','1',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813177536,528282393525952,'LASTSUSPENDEDBYNAME','最后注销人名称','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813177537,528282393525952,'ROLEDESC','描述','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528282813185728,528282393525952,'ORDERNO','排序码','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528282813185729,528282393525952,'PASSWORDPOLICYID','密码策略','0',NULL,'admin','系统管理员','2021-01-15 17:14:08','901901','北京三维天地科技有限公司'),
	 (528286078926528,528285945249472,'ID','账号','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078934720,528285945249472,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078942912,528285945249472,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078942913,528285945249472,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078951104,528285945249472,'MOBILE','手机号','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078951105,528285945249472,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078951106,528285945249472,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078959296,528285945249472,'ORGID','单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528286078959297,528285945249472,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078959298,528285945249472,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078967488,528285945249472,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078967489,528285945249472,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078967490,528285945249472,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078967491,528285945249472,'STATUS','用户状态','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078975680,528285945249472,'USERNO','人员编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078975681,528285945249472,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078975682,528285945249472,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078983872,528285945249472,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528286078983873,528285945249472,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078983874,528285945249472,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078992064,528285945249472,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078992065,528285945249472,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078992066,528285945249472,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286078992067,528285945249472,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286079000256,528285945249472,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286079000257,528285945249472,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286079000258,528285945249472,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司'),
	 (528286079008448,528285945249472,'ROLENAME','角色名称','0',NULL,'admin','系统管理员','2021-01-15 17:20:46','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528296763496864,528296680552864,'ID','账号','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763496865,528296680552864,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763505056,528296680552864,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763505057,528296680552864,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763505058,528296680552864,'MOBILE','手机号','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763513248,528296680552864,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763513249,528296680552864,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763521440,528296680552864,'ORGID','单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763521441,528296680552864,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763521442,528296680552864,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528296763521443,528296680552864,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763529632,528296680552864,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763529633,528296680552864,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763537824,528296680552864,'STATUS','用户状态','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763537825,528296680552864,'USERNO','人员编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763537826,528296680552864,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763546016,528296680552864,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763546017,528296680552864,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763546018,528296680552864,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763554208,528296680552864,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (528296763554209,528296680552864,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763554210,528296680552864,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763554211,528296680552864,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763562400,528296680552864,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763562401,528296680552864,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763562402,528296680552864,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (528296763570592,528296680552864,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-15 17:42:31','901901','北京三维天地科技有限公司'),
	 (531029914740704,531028566247392,'ID','角色编码','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914757088,531028566247392,'ROLENAME','角色名称','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914765280,531028566247392,'CREATEDTIME','制单日期','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (531029914773472,531028566247392,'LASTSUSPENDEDFLAG','挂起标志（0-正常，1-挂起）','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914773473,531028566247392,'LASTSUSPENDEDTIME','挂起时间','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914781664,531028566247392,'USEDBYORGID','使用单位编码','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914789856,531028566247392,'USEDBYORGNAME','使用单位名称','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914798048,531028566247392,'CREATEDBYID','制单人ID','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914806240,531028566247392,'LASTSUSPENDEDBYID','挂起人ID','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914814432,531028566247392,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914814433,531028566247392,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914822624,531028566247392,'LASTSUSPENDEDBYNAME','最后注销人名称','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914830816,531028566247392,'ROLEDESC','描述','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (531029914830817,531028566247392,'ORDERNO','排序码','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914839008,531028566247392,'PASSWORDPOLICYID','密码策略','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914839009,531028566247392,'USERID','用户编码','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531029914847200,531028566247392,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-19 14:23:07','901901','北京三维天地科技有限公司'),
	 (531044175030242,531039814387680,'USERID','用户ID','0',NULL,'admin','系统管理员','2021-01-19 14:52:08','901901','北京三维天地科技有限公司'),
	 (531044705167328,531039814387680,'ID','主键','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705175520,531039814387680,'TARGETID','对应业务主键','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705175521,531039814387680,'MD5NAME','MD5加密的文件名称','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705183712,531039814387680,'FILEEXT','文件扩展名','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705183713,531039814387680,'SCOPE','访问范围','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (531044705183714,531039814387680,'TIMES','下载次数','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705191904,531039814387680,'VALIDTIMEFROM','生效开始日期','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705191905,531039814387680,'VALIDTIMETO','生效截止日期','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705191906,531039814387680,'EXT','额外信息','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705200096,531039814387680,'CREATEDTIME','制单日期','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705200097,531039814387680,'NAME','文件名称','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705208288,531039814387680,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705208289,531039814387680,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705208290,531039814387680,'PERMANENT','长期生效','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705216480,531039814387680,'DOWNLOADABLE','是否允许下载','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (531044705216481,531039814387680,'BIZCATEGORY','业务类型','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705224672,531039814387680,'REMARK','备注','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705224673,531039814387680,'CREATEDBYORGID','制单人编码','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705232864,531039814387680,'CREATEDBYORGNAME','制单单位名称','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705232865,531039814387680,'SIZE','文件大小','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (531044705232866,531039814387680,'VERSION','文件版本','0',NULL,'admin','系统管理员','2021-01-19 14:53:13','901901','北京三维天地科技有限公司'),
	 (537292360793056,537292254362592,'ID','账号','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360793057,537292254362592,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360801248,537292254362592,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360801249,537292254362592,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (537292360801250,537292254362592,'MOBILE','手机号','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360809440,537292254362592,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360809441,537292254362592,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360809442,537292254362592,'ORGID','单位编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360817632,537292254362592,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360817633,537292254362592,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360817634,537292254362592,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360817635,537292254362592,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360825824,537292254362592,'VERSION','版本','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360825825,537292254362592,'STATUS','用户状态','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (537292360825826,537292254362592,'USERNO','人员编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360834016,537292254362592,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360834017,537292254362592,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360834018,537292254362592,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360834019,537292254362592,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360842208,537292254362592,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360842209,537292254362592,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360842210,537292254362592,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360850400,537292254362592,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360850401,537292254362592,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (537292360850402,537292254362592,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360850403,537292254362592,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (537292360858592,537292254362592,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2021-01-28 10:44:06','901901','北京三维天地科技有限公司'),
	 (564862682678048,564862106452768,'ID','编码','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682686240,564862106452768,'PACKAGENAME','包名','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682686241,564862106452768,'MENUID','菜单编码','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682686242,564862106452768,'PARENTMENUID','父菜单编码','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682694432,564862106452768,'MENUNAME','菜单名称','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682694433,564862106452768,'MENUICON','菜单图标','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682702624,564862106452768,'AUTHOR','作者(邮箱@前姓名简称)','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (564862682702625,564862106452768,'FUNC','功能模块','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682702626,564862106452768,'CREATEDBYID','制单人编码','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682710816,564862106452768,'CREATEDBYNAME','制单人名称','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682710817,564862106452768,'CREATEDTIME','制单时间','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682710818,564862106452768,'CREATEDBYORGID','制单人单位编码','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564862682719008,564862106452768,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'hongp','hongp','2021-03-08 09:36:04','901','其他单位'),
	 (564864740287264,564863333475104,'ID','主键','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740295456,564863333475104,'CONFIGID','配置ID','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740295457,564863333475104,'TABLENAME','表名','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740303648,564863333475104,'TABLEDESC','表描述','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (564864740303649,564863333475104,'TYPE','主从表','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740303650,564863333475104,'FOREIGNFIELD','关联主表字段','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740311840,564863333475104,'CREATEDBYID','制单人编码','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740311841,564863333475104,'CREATEDBYNAME','制单人名称','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740311842,564863333475104,'CREATEDTIME','制单时间','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740320032,564863333475104,'CREATEDBYORGID','制单人单位编码','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564864740320033,564863333475104,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'hongp','hongp','2021-03-08 09:40:15','901','其他单位'),
	 (564865544446753,564863627928352,'TABLEID','表信息id','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564865544454944,564863627928352,'FIELD','字段','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564865544454945,564863627928352,'FIELDNAME','字段名称','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (564865544463136,564863627928352,'FIELDLENGTH','字段长度','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564865544463137,564863627928352,'FIELDTYPE','字段类型','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564865544471330,564863627928352,'ORDERNO','排序码','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564865544487714,564863627928352,'INDEXTYPE','索引类型','0',NULL,'hongp','hongp','2021-03-08 09:41:53','901','其他单位'),
	 (564866082226976,564865863041824,'ID','ID','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082243360,564865863041824,'FIELDID','字段ID','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082251552,564865863041824,'CODECATEGORYID','类别','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082267936,564865863041824,'CODE','编码','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082276128,564865863041824,'CODENAME','编码名称','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082292512,564865863041824,'ORDERNO','排序码','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (564866082308896,564865863041824,'CREATEDBYID','制单人编码','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082325280,564865863041824,'CREATEDBYNAME','制单人名称','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082341664,564865863041824,'CREATEDTIME','制单时间','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082349856,564865863041824,'CREATEDBYORGID','制单人单位编码','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564866082358048,564865863041824,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'hongp','hongp','2021-03-08 09:42:59','901','其他单位'),
	 (564880953590560,564863627928352,'ID','主键','0',NULL,'hongp','hongp','2021-03-08 10:13:14','901','其他单位'),
	 (974666629560384,974665201850432,'ID','账号','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629568576,974665201850432,'USERNAME','用户名称','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629568577,974665201850432,'PASSWORD','用户密码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629568578,974665201850432,'EMAIL','电子邮箱','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (974666629576768,974665201850432,'MOBILE','手机号','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629576769,974665201850432,'IDCARD','身份证号','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629576770,974665201850432,'FAILEDLOGINATTEMPTS','输入密码错误次数','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629576771,974665201850432,'ORGID','单位编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629576772,974665201850432,'ORGNAME','单位名称','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629584960,974665201850432,'LASTSUSPENDEDFLAG','停用标志(0：正常,1:停用)','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629584961,974665201850432,'PASSWORDUPDATEDTIME','密码修改时间','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629584962,974665201850432,'USERTYPE','用户类型，根据实际业务进行设置','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629584963,974665201850432,'VERSION','版本','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629584964,974665201850432,'STATUS','用户状态','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (974666629593152,974665201850432,'USERNO','人员编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629593153,974665201850432,'EXPIREDPASSWORDUSES','过期密码使用次数','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629593154,974665201850432,'EXPIRYDATE','到期日','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629593155,974665201850432,'PARENTORGID','父组织机构编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629593156,974665201850432,'MULTILOGIN','允许重复登录','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629601344,974665201850432,'CREATEDBYID','制单人编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629601345,974665201850432,'CREATEDBYNAME','制单人名称','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629601346,974665201850432,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629601347,974665201850432,'CREATEDBYORGID','制单人单位编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629601348,974665201850432,'CREATEDBYORGNAME','制单人单位名称','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (974666629609536,974665201850432,'LASTSUSPENDEDBYID','启用/停用人编码','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629609537,974665201850432,'LASTSUSPENDEDBYNAME','启用/停用人名称','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (974666629609538,974665201850432,'LASTSUSPENDEDTIME','启用/停用时间','0',NULL,'admin','系统管理员','2022-10-08 09:24:20','WL','物理组'),
	 (976863543675840,976863462976448,'FOLDERNO','S.FOLDERNO','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863543749568,976863462976448,'CLIENTUSERORGNAME','S.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863543815104,976863462976448,'SAMPLETYPE','S.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863543864256,976863462976448,'CLIENTUSERNAME','S.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863543929792,976863462976448,'CLIENTUSERPHONE','S.CLIENTUSERPHONE','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863543995328,976863462976448,'OBTAINTIME','S.OBTAINTIME','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863544044480,976863462976448,'OBTAINUSERNAME','S.OBTAINUSERNAME','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (976863544101824,976863462976448,'CHANGECODE','S.CHANGECODE','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863544159168,976863462976448,'CHANGEID','S.CHANGEID','0',NULL,'admin','系统管理员','2022-10-11 11:53:58','WL','物理组'),
	 (976863787707328,976863696849856,'RESULT','TASKS.RESULT','0',NULL,'admin','系统管理员','2022-10-11 11:54:27','WL','物理组'),
	 (976863787756480,976863696849856,'TESTNAME','TASKS.TESTNAME','0',NULL,'admin','系统管理员','2022-10-11 11:54:27','WL','物理组'),
	 (976863787813824,976863696849856,'REMARKS','TASKS.REMARKS','0',NULL,'admin','系统管理员','2022-10-11 11:54:27','WL','物理组'),
	 (976863787920320,976863696849856,'CHANGEID','TASKS.CHANGEID','0',NULL,'admin','系统管理员','2022-10-11 11:54:27','WL','物理组'),
	 (976906841970112,976906537153984,'FOLDERNO','S.FOLDERNO','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976906842019264,976906537153984,'CLIENTUSERORGNAME','S.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976906842068416,976906537153984,'SAMPLETYPE','S.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976906842109376,976906537153984,'CLIENTUSERNAME','S.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (976906842150336,976906537153984,'CLIENTUSERPHONE','S.CLIENTUSERPHONE','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976906842215872,976906537153984,'OBTAINTIME','S.OBTAINTIME','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976906842256832,976906537153984,'OBTAINUSERNAME','S.OBTAINUSERNAME','0',NULL,'admin','系统管理员','2022-10-11 13:22:03','WL','物理组'),
	 (976907141297600,976907015099840,'RESULT','TASKS.RESULT','0',NULL,'admin','系统管理员','2022-10-11 13:22:40','WL','物理组'),
	 (976907141338560,976907015099840,'TESTNAME','TASKS.TESTNAME','0',NULL,'admin','系统管理员','2022-10-11 13:22:40','WL','物理组'),
	 (976907141412288,976907015099840,'REMARKS','TASKS.REMARKS','0',NULL,'admin','系统管理员','2022-10-11 13:22:40','WL','物理组'),
	 (976921482304448,976906537153984,'ID','S.ID','0',NULL,'admin','系统管理员','2022-10-11 13:51:50','WL','物理组'),
	 (976921665510336,976907015099840,'ID','TASKS.ID','0',NULL,'admin','系统管理员','2022-10-11 13:52:13','WL','物理组'),
	 (1008077063093280,1008075739814944,'ID','主键','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063093281,1008075739814944,'CLIENTUSERORGNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1008077063093282,1008075739814944,'SAMPLENAME','T_LIMS_REPORT_CHANGE.SAMPLENAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063093283,1008075739814944,'LAB','T_LIMS_REPORT_CHANGE.LAB','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063093284,1008075739814944,'ORGNAME','组织名称','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063093285,1008075739814944,'FOLDERNO','T_LIMS_REPORT_CHANGE.FOLDERNO','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101472,1008075739814944,'CLIENTUSERPHONE','T_LIMS_REPORT_CHANGE.CLIENTUSERPHONE','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101473,1008075739814944,'OBTAINUSERNAME','T_LIMS_REPORT_CHANGE.OBTAINUSERNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101474,1008075739814944,'TWOORGNAME','T_LIMS_REPORT_CHANGE.TWOORGNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101475,1008075739814944,'CLIENTUSERID','T_LIMS_REPORT_CHANGE.CLIENTUSERID','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101476,1008075739814944,'CLIENTUSERNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101477,1008075739814944,'TESTNAME','T_LIMS_REPORT_CHANGE.TESTNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1008077063101478,1008075739814944,'SAMPLETYPE','T_LIMS_REPORT_CHANGE.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101479,1008075739814944,'EQUIPTCODE','T_LIMS_REPORT_CHANGE.EQUIPTCODE','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101480,1008075739814944,'TOTALINSPECTION','T_LIMS_REPORT_CHANGE.TOTALINSPECTION','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101481,1008075739814944,'OBTAINTIME','T_LIMS_REPORT_CHANGE.OBTAINTIME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101482,1008075739814944,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101483,1008075739814944,'TIME','T_LIMS_REPORT_CHANGE.TIME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101484,1008075739814944,'RESULT','T_LIMS_REPORT_CHANGE.RESULT','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101485,1008075739814944,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063101486,1008075739814944,'METHODNAME','T_LIMS_REPORT_CHANGE.METHODNAME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组'),
	 (1008077063109664,1008075739814944,'OPERATETIME','T_LIMS_REPORT_CHANGE.OPERATETIME','0',NULL,'admin','系统管理员','2022-11-24 14:18:02','HX','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1008077968374816,1008077246118944,'RESULT','T_LIMS_REPORT_CHANGE.RESULT','0',NULL,'admin','系统管理员','2022-11-24 14:19:52','HX','化学组'),
	 (1008077968374817,1008077246118944,'TESTNAME','T_LIMS_REPORT_CHANGE.TESTNAME','0',NULL,'admin','系统管理员','2022-11-24 14:19:52','HX','化学组'),
	 (1008077968374818,1008077246118944,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-11-24 14:19:52','HX','化学组'),
	 (1008077968374819,1008077246118944,'ID','主键','0',NULL,'admin','系统管理员','2022-11-24 14:19:52','HX','化学组'),
	 (1023751976020704,986179030725984,'ID','主键','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020705,986179030725984,'CLIENTUSERORGNAME','T_LIMS_REPORT_APPLY.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020706,986179030725984,'SAMPLENAME','T_LIMS_REPORT_APPLY.SAMPLENAME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020707,986179030725984,'LAB','T_LIMS_REPORT_APPLY.LAB','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020708,986179030725984,'ORGNAME','组织名称','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020709,986179030725984,'TWOORGNAME','T_LIMS_REPORT_APPLY.TWOORGNAME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1023751976020710,986179030725984,'CLIENTUSERID','T_LIMS_REPORT_APPLY.CLIENTUSERID','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976020711,986179030725984,'CLIENTUSERNAME','T_LIMS_REPORT_APPLY.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028896,986179030725984,'TESTNAME','T_LIMS_REPORT_APPLY.TESTNAME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028897,986179030725984,'SAMPLETYPE','T_LIMS_REPORT_APPLY.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028898,986179030725984,'EQUIPTCODE','T_LIMS_REPORT_APPLY.EQUIPTCODE','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028899,986179030725984,'TOTALINSPECTION','T_LIMS_REPORT_APPLY.TOTALINSPECTION','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028900,986179030725984,'OBTAINTIME','T_LIMS_REPORT_APPLY.OBTAINTIME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028901,986179030725984,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028902,986179030725984,'TIME','T_LIMS_REPORT_APPLY.TIME','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028903,986179030725984,'TIME2','T_LIMS_REPORT_APPLY.TIME2','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1023751976028904,986179030725984,'RESULT','T_LIMS_REPORT_APPLY.RESULT','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1023751976028905,986179030725984,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-12-16 17:48:43','00013962','化学组'),
	 (1026523338694240,986743372568352,'ID','主键','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338694241,986743372568352,'CLIENTUSERORGNAME','T_LIMS_REPORT_APPLY.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338694242,986743372568352,'SAMPLENAME','T_LIMS_REPORT_APPLY.SAMPLENAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338694243,986743372568352,'LAB','T_LIMS_REPORT_APPLY.LAB','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338694244,986743372568352,'ORGNAME','组织名称','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702432,986743372568352,'FOLDERNO','T_LIMS_REPORT_APPLY.FOLDERNO','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702433,986743372568352,'CLIENTUSERPHONE','T_LIMS_REPORT_APPLY.CLIENTUSERPHONE','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702434,986743372568352,'OBTAINUSERNAME','T_LIMS_REPORT_APPLY.OBTAINUSERNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1026523338702435,986743372568352,'TWOORGNAME','T_LIMS_REPORT_APPLY.TWOORGNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702436,986743372568352,'CLIENTUSERID','T_LIMS_REPORT_APPLY.CLIENTUSERID','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702437,986743372568352,'CLIENTUSERNAME','T_LIMS_REPORT_APPLY.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702438,986743372568352,'TESTNAME','T_LIMS_REPORT_APPLY.TESTNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702439,986743372568352,'SAMPLETYPE','T_LIMS_REPORT_APPLY.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702440,986743372568352,'EQUIPTCODE','T_LIMS_REPORT_APPLY.EQUIPTCODE','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702441,986743372568352,'TOTALINSPECTION','T_LIMS_REPORT_APPLY.TOTALINSPECTION','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702442,986743372568352,'OBTAINTIME','T_LIMS_REPORT_APPLY.OBTAINTIME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702443,986743372568352,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702444,986743372568352,'TIME','T_LIMS_REPORT_APPLY.TIME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1026523338702445,986743372568352,'TIME2','T_LIMS_REPORT_APPLY.TIME2','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702446,986743372568352,'RESULT','T_LIMS_REPORT_APPLY.RESULT','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338702447,986743372568352,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338710624,986743372568352,'METHODNAME','T_LIMS_REPORT_APPLY.METHODNAME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026523338710625,986743372568352,'OPERATETIME','T_LIMS_REPORT_APPLY.OPERATETIME','0',NULL,'admin','系统管理员','2022-12-20 15:47:04','00013962','化学组'),
	 (1026540893093472,986839987885856,'ID','主键','0',NULL,'admin','系统管理员','2022-12-20 16:22:47','00013962','化学组'),
	 (1026540893093473,986839987885856,'RESULT','T_LIMS_REPORT_APPLY.RESULT','0',NULL,'admin','系统管理员','2022-12-20 16:22:47','00013962','化学组'),
	 (1026540893093474,986839987885856,'TESTNAME','T_LIMS_REPORT_APPLY.TESTNAME','0',NULL,'admin','系统管理员','2022-12-20 16:22:47','00013962','化学组'),
	 (1026540893093475,986839987885856,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-12-20 16:22:47','00013962','化学组'),
	 (1026540893101664,986839987885856,'UNIT','T_LIMS_REPORT_APPLY.UNIT','0',NULL,'admin','系统管理员','2022-12-20 16:22:47','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1027014628625952,1021548370226528,'ID','主键','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628625953,1021548370226528,'CLIENTUSERORGNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628625954,1021548370226528,'SAMPLENAME','T_LIMS_REPORT_CHANGE.SAMPLENAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628625955,1021548370226528,'LAB','T_LIMS_REPORT_CHANGE.LAB','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628625956,1021548370226528,'ORGNAME','组织名称','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634144,1021548370226528,'FOLDERNO','T_LIMS_REPORT_CHANGE.FOLDERNO','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634145,1021548370226528,'CLIENTUSERPHONE','T_LIMS_REPORT_CHANGE.CLIENTUSERPHONE','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634146,1021548370226528,'OBTAINUSERNAME','T_LIMS_REPORT_CHANGE.OBTAINUSERNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634147,1021548370226528,'TWOORGNAME','T_LIMS_REPORT_CHANGE.TWOORGNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634148,1021548370226528,'CLIENTUSERID','T_LIMS_REPORT_CHANGE.CLIENTUSERID','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1027014628634149,1021548370226528,'CLIENTUSERNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634150,1021548370226528,'TESTNAME','T_LIMS_REPORT_CHANGE.TESTNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634151,1021548370226528,'SAMPLETYPE','T_LIMS_REPORT_CHANGE.SAMPLETYPE','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634152,1021548370226528,'EQUIPTCODE','T_LIMS_REPORT_CHANGE.EQUIPTCODE','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634153,1021548370226528,'TOTALINSPECTION','T_LIMS_REPORT_CHANGE.TOTALINSPECTION','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634154,1021548370226528,'OBTAINTIME','T_LIMS_REPORT_CHANGE.OBTAINTIME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634155,1021548370226528,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634156,1021548370226528,'TIME','T_LIMS_REPORT_CHANGE.TIME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628634157,1021548370226528,'TIME2','T_LIMS_REPORT_CHANGE.TIME2','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628642336,1021548370226528,'RESULT','T_LIMS_REPORT_CHANGE.RESULT','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1027014628642337,1021548370226528,'REMARKS','备注','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628642338,1021548370226528,'METHODNAME','T_LIMS_REPORT_CHANGE.METHODNAME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1027014628642339,1021548370226528,'OPERATETIME','T_LIMS_REPORT_CHANGE.OPERATETIME','0',NULL,'admin','系统管理员','2022-12-21 08:26:36','00013962','化学组'),
	 (1032682553621920,1032681608584608,'LEADERID','77.LEADERID','0',NULL,'admin','系统管理员','2022-12-29 08:38:02','00013962','化学组'),
	 (1032683473624480,1032683405016480,'LEADERID','1231231.LEADERID','0',NULL,'admin','系统管理员','2022-12-29 08:39:54','00013962','化学组'),
	 (1040697724098944,1040673662337952,'ID','主键','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724098945,1040673662337952,'FOLDERNO','委托单编号','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724098946,1040673662337952,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724098947,1040673662337952,'CLIENTUSERNAME','T_LIMS_ORDER.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724098948,1040673662337952,'SAMPLENAME','样品名称','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1040697724098949,1040673662337952,'SAMPLECODE','样品编号','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107136,1040673662337952,'MATERIALNAME','材料名称','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107137,1040673662337952,'WORKSHOPSECTION','T_LIMS_ORDER.WORKSHOPSECTION','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107138,1040673662337952,'TIME','T_LIMS_ORDER.TIME','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107139,1040673662337952,'TIME2','T_LIMS_ORDER.TIME2','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107140,1040673662337952,'CODENAME','T_LIMS_ORDER.CODENAME','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107141,1040673662337952,'TESTNAME','T_LIMS_ORDER.TESTNAME','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1040697724107142,1040673662337952,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-01-09 16:24:56','00013962','化学组'),
	 (1042079766097888,986844382754592,'ID','主键','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766097889,986844382754592,'CLIENTUSERORGNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERORGNAME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1042079766106080,986844382754592,'SAMPLENAME','T_LIMS_REPORT_CHANGE.SAMPLENAME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766106081,986844382754592,'LAB','T_LIMS_REPORT_CHANGE.LAB','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766114272,986844382754592,'ORGNAME','组织名称','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766114273,986844382754592,'TWOORGNAME','T_LIMS_REPORT_CHANGE.TWOORGNAME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766114274,986844382754592,'CLIENTUSERID','T_LIMS_REPORT_CHANGE.CLIENTUSERID','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766122464,986844382754592,'CLIENTUSERNAME','T_LIMS_REPORT_CHANGE.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766122465,986844382754592,'TESTNAME','T_LIMS_REPORT_CHANGE.TESTNAME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766130656,986844382754592,'SAMPLETYPE','T_LIMS_REPORT_CHANGE.SAMPLETYPE','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766130657,986844382754592,'EQUIPTCODE','T_LIMS_REPORT_CHANGE.EQUIPTCODE','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766138848,986844382754592,'TOTALINSPECTION','T_LIMS_REPORT_CHANGE.TOTALINSPECTION','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1042079766138849,986844382754592,'OBTAINTIME','T_LIMS_REPORT_CHANGE.OBTAINTIME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766138850,986844382754592,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766147040,986844382754592,'TIME','T_LIMS_REPORT_CHANGE.TIME','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766147041,986844382754592,'TIME2','T_LIMS_REPORT_CHANGE.TIME2','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766147042,986844382754592,'RESULT','T_LIMS_REPORT_CHANGE.RESULT','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042079766155232,986844382754592,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-01-11 15:16:42','00013962','化学组'),
	 (1042080838193120,1021549024660832,'RESULT','T_LIMS_REPORT_CHANGE.RESULT','0',NULL,'admin','系统管理员','2023-01-11 15:18:53','00013962','化学组'),
	 (1042080838193121,1021549024660832,'TESTNAME','T_LIMS_REPORT_CHANGE.TESTNAME','0',NULL,'admin','系统管理员','2023-01-11 15:18:53','00013962','化学组'),
	 (1042080838201312,1021549024660832,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-01-11 15:18:53','00013962','化学组'),
	 (1042080838201313,1021549024660832,'ID','主键','0',NULL,'admin','系统管理员','2023-01-11 15:18:53','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1042080838209504,1021549024660832,'UNIT','T_LIMS_REPORT_CHANGE.UNIT','0',NULL,'admin','系统管理员','2023-01-11 15:18:53','00013962','化学组'),
	 (1146078929515552,1146078684083232,'ID','主键','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929531936,1146078684083232,'FOLDERNO','委托单编号','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929531937,1146078684083232,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929540128,1146078684083232,'CLIENTUSERNAME','T_LIMS_ORDER.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929548320,1146078684083232,'SAMPLENAME','样品名称','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929556512,1146078684083232,'SAMPLECODE','样品编号','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929564704,1146078684083232,'MATERIALNAME','材料名称','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929564705,1146078684083232,'WORKSHOPSECTION','T_LIMS_ORDER.WORKSHOPSECTION','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929572896,1146078684083232,'TIME','T_LIMS_ORDER.TIME','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146078929572897,1146078684083232,'TIME2','T_LIMS_ORDER.TIME2','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929572898,1146078684083232,'CODENAME','T_LIMS_ORDER.CODENAME','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929581088,1146078684083232,'TESTNAME','T_LIMS_ORDER.TESTNAME','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929581089,1146078684083232,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929589280,1146078684083232,'B','T_LIMS_ORDER.B','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146078929597472,1146078684083232,'TESTGROUP','测试组','0',NULL,'admin','系统管理员','2023-06-07 13:43:33','00013962','化学组'),
	 (1146081218360352,1146080638735392,'ID','主键','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218368544,1146080638735392,'FOLDERNO','委托单编号','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218376736,1146080638735392,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218376737,1146080638735392,'CLIENTUSERNAME','委托人','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146081218376738,1146080638735392,'SAMPLENAME','实物批','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218384928,1146080638735392,'SAMPLECODE','样品编号','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218384929,1146080638735392,'MATERIALNAME','物料组','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218384930,1146080638735392,'WORKSHOPSECTION','车间工序','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218384931,1146080638735392,'TIME','T_LIMS_FOLDER.TIME','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218393120,1146080638735392,'TIME2','T_LIMS_FOLDER.TIME2','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218393121,1146080638735392,'CODENAME','T_LIMS_FOLDER.CODENAME','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218393122,1146080638735392,'TESTNAME','T_LIMS_FOLDER.TESTNAME','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218393123,1146080638735392,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146081218393124,1146080638735392,'B','T_LIMS_FOLDER.B','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146081218401312,1146080638735392,'TESTGROUP','T_LIMS_FOLDER.TESTGROUP','0',NULL,'admin','系统管理员','2023-06-07 13:48:12','00013962','化学组'),
	 (1146180514899136,998731030198272,'ID','主键','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514907328,998731030198272,'FOLDERNO','委托单编号','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514907329,998731030198272,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514907330,998731030198272,'CLIENTUSERNAME','委托人','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514907331,998731030198272,'SAMPLENAME','实物批','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514915520,998731030198272,'SAMPLECODE','样品编号','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514923712,998731030198272,'MATERIALNAME','物料组','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514923713,998731030198272,'WORKSHOPSECTION','车间工序','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514923714,998731030198272,'TIME','T_LIMS_FOLDER.TIME','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146180514931904,998731030198272,'TIME2','T_LIMS_FOLDER.TIME2','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514931905,998731030198272,'CODENAME','T_LIMS_FOLDER.CODENAME','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514940096,998731030198272,'TESTNAME','T_LIMS_FOLDER.TESTNAME','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180514940097,998731030198272,'TESTCONDITION','T_LIMS_FOLDER.TESTCONDITION','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180515095744,998731030198272,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180515103936,998731030198272,'B','T_LIMS_FOLDER.B','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180515103937,998731030198272,'TESTGROUP','T_LIMS_FOLDER.TESTGROUP','0',NULL,'admin','系统管理员','2023-06-07 17:10:13','00013962','化学组'),
	 (1146180998030528,961923484485920,'TESTCONDITION','测试条件','0',NULL,'admin','系统管理员','2023-06-07 17:11:12','00013962','化学组'),
	 (1146181003330752,961923484485920,'ID','主键','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003330753,961923484485920,'FOLDERNO','委托单编号','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146181003338944,961923484485920,'CREATEDTIME','制单时间','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003338945,961923484485920,'CLIENTUSERNAME','T_LIMS_ORDER.CLIENTUSERNAME','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003347136,961923484485920,'SAMPLENAME','样品名称','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003347137,961923484485920,'SAMPLECODE','样品编号','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003347138,961923484485920,'MATERIALNAME','材料名称','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003347139,961923484485920,'WORKSHOPSECTION','T_LIMS_ORDER.WORKSHOPSECTION','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003355328,961923484485920,'TIME','T_LIMS_ORDER.TIME','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003355329,961923484485920,'TIME2','T_LIMS_ORDER.TIME2','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003355330,961923484485920,'CODENAME','T_LIMS_ORDER.CODENAME','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003355331,961923484485920,'TESTNAME','T_LIMS_ORDER.TESTNAME','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组');
INSERT INTO t_lims_report_template_column (ID,TEMPLATESOURCEID,COLUMNNAME,COLUMNDESC,FILEIDFLAG,REMARK,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES
	 (1146181003363520,961923484485920,'REMARKS','备注','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003363521,961923484485920,'B','T_LIMS_ORDER.B','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组'),
	 (1146181003371712,961923484485920,'TESTGROUP','测试组','0',NULL,'admin','系统管理员','2023-06-07 17:11:13','00013962','化学组');

INSERT INTO t_lims_report_template_file (ID,REPORTTEMPLATEID,FILEID,VERSIONNO,REMARK,ACTIVATEDFLAG,ACTIVATEDTIME,ACTIVATEDBYID,ACTIVATEDBYNAME,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,UPLOADBYID,UPLOADBYNAME,UPLOADTIME) VALUES
	 (1235335384934304,1235265947738560,1235354591379904,'V1.0',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-10-11 16:16:16','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-10-11 16:55:00'),
	 (1235355621990848,1235265947738560,1245184333667808,'V1.1',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-10-11 16:57:27','RT','湖北融通高科先进材料股份有限公司','zhangs','张胜','2023-10-24 14:14:00'),
	 (1277087006460480,1277086760684096,1277135167738144,'V1.0',NULL,'1','2023-12-09 16:00:16','zhangs','张胜','zhangs','张胜','2023-12-09 16:00:10','RT','湖北融通高科先进材料股份有限公司','zhangs','张胜','2023-12-09 17:38:00'),
	 (1279156716982176,1266479048648064,1279156715057056,'V1.0',NULL,'1','2023-12-12 14:11:06','admin','系统管理员','admin','系统管理员','2023-12-12 14:11:00','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-12 14:11:00'),
	 (1284211809744928,1235265947738560,1284211801233440,'V1.2',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-19 17:35:37','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-19 17:35:37'),
	 (1284696926767552,1284677724539328,1284696917526976,'V1.0',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-20 10:02:35','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-20 10:02:35'),
	 (1286326033227552,1284677724539328,1286326023716640,'V1.1',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-22 17:17:01','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-22 17:17:01'),
	 (1286331638966880,1235265947738560,1286331630053984,'V1.3',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-22 17:28:25','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-22 17:28:25'),
	 (1288263923644288,1284677724539328,1288263915829120,'V1.2',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-25 10:59:40','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-25 10:59:40'),
	 (1288267029698432,1235265947738560,1288267022718848,'V1.4',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-25 11:05:59','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-25 11:05:59');
INSERT INTO t_lims_report_template_file (ID,REPORTTEMPLATEID,FILEID,VERSIONNO,REMARK,ACTIVATEDFLAG,ACTIVATEDTIME,ACTIVATEDBYID,ACTIVATEDBYNAME,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME,UPLOADBYID,UPLOADBYNAME,UPLOADTIME) VALUES
	 (1288268016088960,1284677724539328,1288268008290176,'V1.3',NULL,'0',NULL,NULL,NULL,'admin','系统管理员','2023-12-25 11:07:59','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-25 11:07:59'),
	 (1288268247775104,1235265947738560,1288268238092160,'V1.5',NULL,'1','2023-12-25 11:08:33','admin','系统管理员','admin','系统管理员','2023-12-25 11:08:28','RT','湖北融通高科先进材料股份有限公司','admin','系统管理员','2023-12-25 11:08:28'),
	 (1305924988271968,1305924798905696,1313199196401568,'V1.0',NULL,'1','2024-01-19 09:58:32','zhangs','张胜','zhangs','张胜','2024-01-19 09:51:11','RT','湖北融通高科先进材料股份有限公司','zhangs','张胜','2024-01-29 16:30:00'),
	 (1386065573412704,1386064709132128,1386079729500000,'V1.0',NULL,'1','2024-05-11 15:20:17','zhangs','张胜','zhangs','张胜','2024-05-11 15:17:38','RT','湖北融通高科先进材料股份有限公司','zhangs','张胜','2024-05-11 15:46:00'),
	 (1412935202847648,1284677724539328,1412935200545696,'V1.4',NULL,'1','2024-06-18 14:27:26','admin','系统管理员','admin','系统管理员','2024-06-18 14:24:02','RT_DY','大冶检测中心','admin','系统管理员','2024-06-18 14:24:02');

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
	 (1235265947738560,'RT20231000001','理化检测报告-通用模版(含过程)','report',1288268238092160,'理化检测通用模板2.0(1).docx','word','folderId',NULL,'admin','系统管理员','2023-10-11 13:55:01','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.5'),
	 (1266479048648064,'RT20231100001','综合报告模板','report',1279156715057056,'综合报告模板.docx','word','folderId',NULL,'zhangs','张胜','2023-11-24 16:18:14','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.0'),
	 (1277086760684096,'RT20231200001','结果录入批量录入模板','resultInputImport',1277135167738144,'批量录入.xlsx','word','ordtaskId',NULL,'zhangs','张胜','2023-12-09 15:59:40','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.0'),
	 (1284677724539328,'RT20231200003','理化通用报告(只含结果)','report',1412935200545696,'理化检测通用模板(仅含结果)2.0(1).docx','word','folderId',NULL,'admin','系统管理员','2023-12-20 09:23:32','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.4'),
	 (1305924798905696,'RT20240100001','样品标签','sampleTag',1313199196401568,'样品标签模板.xlsx','word',NULL,NULL,'zhangs','张胜','2024-01-19 09:50:49','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.0'),
	 (1386064709132128,'RT20240500001','蓝电测试数据导出模板','lanDianResultExport',1386079729500000,'蓝电测试数据导出模板.xlsx','word','FOLDERIDS',NULL,'zhangs','张胜','2024-05-11 15:15:53','RT','湖北融通高科先进材料股份有限公司',NULL,NULL,NULL,NULL,NULL,'V1.0');
-- ----------------------------- 2024-06-18 add by zhangs------------end

-- ----------------------------- 2024-06-20 add by zhangs------------begin
delete  from t_core_code tcc where CODECATEGORYID ='folderStatus';
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009481,'申请','folderStatus',NULL,10,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'Draft',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009482,'取样确认','folderStatus',NULL,20,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'sampleConfirm',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009483,'实验室审核','folderStatus',NULL,30,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'audit',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009484,'实验室负责人审核','folderStatus',NULL,40,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'approve',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009485,'样品接收','folderStatus',NULL,50,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'orderReceive',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009486,'结果录入','folderStatus',NULL,60,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'resultInput',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009487,'结果二次复核','folderStatus',NULL,70,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'resultSecondCheck',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009488,'报告编制','folderStatus',NULL,80,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'reportDraft',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009489,'报告审核','folderStatus',NULL,90,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'reportAudit',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009491,'报告批准','folderStatus',NULL,100,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'reportApprove',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009492,'报告归档','folderStatus',NULL,110,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'reportFile',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009493,'完成','folderStatus',NULL,120,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'Done',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062009494,'取消','folderStatus',NULL,130,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'Cancel',NULL);

INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024062011021,'结果复核','folderStatus',NULL,65,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'resultCheck',NULL);
-- ----------------------------- 2024-06-20 add by zhangs------------end

-- ----------------------------- 2024-07-10 add by zhangs------------begin
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024071017431,'WQC','folderCheckType',NULL,20,NULL,'admin','系统管理员1','2023-10-30 17:00:00','0',NULL,NULL,NULL,'WQC',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024071017432,'IPQC-P','folderCheckType',NULL,30,NULL,'admin','系统管理员1','2023-10-30 17:00:00','0',NULL,NULL,NULL,'IPQC-P',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024071017433,'PQC','folderCheckType',NULL,30,NULL,'admin','系统管理员1','2023-10-30 17:00:00','0',NULL,NULL,NULL,'PQC',NULL);
INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,I18NCODE) VALUES
(2024071017434,'OQC','folderCheckType',NULL,40,NULL,'admin','系统管理员1','2023-10-30 17:00:00','0',NULL,NULL,NULL,'OQC',NULL);
-- ----------------------------- 2024-07-10 add by zhangs------------end
