-- ----------------------------- 2022-09-19 add by qiuyf--------------begin

-- 建表语句
CREATE TABLE T_LIMS_ITEM_APPLY( 
    ID NUMBER NOT NULL,
    ITEMNAME VARCHAR2(270)  NULL,
    APPLYTIME DATE NULL,
    APPLYUSER VARCHAR2(270)  NULL,
    APPLYUSERID VARCHAR2(36)  NULL,
    ITEMBUDGET NUMBER NULL,
    CHECKACCORDING VARCHAR2(270)  NULL,
    ITEMRESOURCE VARCHAR2(270)  NULL,
    APPLYREASON VARCHAR2(270)  NULL,
    APPROVER VARCHAR2(270)  NULL,
    APPROVERID VARCHAR2(36)  NULL,
    APPROVETIME DATE NULL,
    STARTTIME DATE NULL,
    FINISHTIME DATE NULL,
    PRINCIPAL VARCHAR2(270)  NULL,
    PRINCIPALID VARCHAR2(36)  NULL,
    CRETERIONACCORDING VARCHAR2(270)  NULL,
    RESOURCECONFIG VARCHAR2(270)  NULL,
    TRIALOPERATION VARCHAR2(270)  NULL,
    ITMEPRINCIPAL VARCHAR2(270)  NULL,
    ITMEPRINCIPALID VARCHAR2(36)  NULL,
    ITMEPRINCIPALTIME DATE NULL,
    REMARK VARCHAR2(270)  NULL,
    PROCESSSTATUS VARCHAR2(36)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_ITEM_APPLY IS '新项目申请表';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ID IS '主键';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITEMNAME IS '项目名称';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPLYTIME IS '申请时间';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPLYUSER IS '申请人';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPLYUSERID IS '申请人ID';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITEMBUDGET IS '项目预算';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CHECKACCORDING IS '检查依据';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITEMRESOURCE IS '新项目所需资源';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPLYREASON IS '申请新项目原因';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPROVER IS '批准人';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPROVERID IS '批准人ID';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.APPROVETIME IS '批准时间';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.STARTTIME IS '开始时间';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.FINISHTIME IS '完成时间';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.PRINCIPAL IS '负责人';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.PRINCIPALID IS '负责人ID';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CRETERIONACCORDING IS '依据规范';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.RESOURCECONFIG IS '资源配置情况';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.TRIALOPERATION IS '试运行情况';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITMEPRINCIPAL IS '项目负责人';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITMEPRINCIPALID IS '项目负责人ID';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.ITMEPRINCIPALTIME IS '项目负责人批准日期';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_ITEM_APPLY.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_ITEM_APPLY ADD CONSTRAINT PK_LIMS_ITEM_APPLY PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_ITEM_APPLY.SERVICE_NAME', '新项目申请表', '新项目申请表', 'zh-CN', '新项目申请表');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ID', '新项目申请表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITEMNAME', '新项目申请表的项目名称', '项目名称', 'zh-CN', '项目名称');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPLYTIME', '新项目申请表的申请时间', '申请时间', 'zh-CN', '申请时间');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPLYUSER', '新项目申请表的申请人', '申请人', 'zh-CN', '申请人');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPLYUSERID', '新项目申请表的申请人ID', '申请人ID', 'zh-CN', '申请人ID');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITEMBUDGET', '新项目申请表的项目预算', '项目预算', 'zh-CN', '项目预算');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CHECKACCORDING', '新项目申请表的检查依据', '检查依据', 'zh-CN', '检查依据');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITEMRESOURCE', '新项目申请表的新项目所需资源', '新项目所需资源', 'zh-CN', '新项目所需资源');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPLYREASON', '新项目申请表的申请新项目原因', '申请新项目原因', 'zh-CN', '申请新项目原因');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPROVER', '新项目申请表的批准人', '批准人', 'zh-CN', '批准人');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPROVERID', '新项目申请表的批准人ID', '批准人ID', 'zh-CN', '批准人ID');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.APPROVETIME', '新项目申请表的批准时间', '批准时间', 'zh-CN', '批准时间');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.STARTTIME', '新项目申请表的开始时间', '开始时间', 'zh-CN', '开始时间');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.FINISHTIME', '新项目申请表的完成时间', '完成时间', 'zh-CN', '完成时间');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.PRINCIPAL', '新项目申请表的负责人', '负责人', 'zh-CN', '负责人');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.PRINCIPALID', '新项目申请表的负责人ID', '负责人ID', 'zh-CN', '负责人ID');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CRETERIONACCORDING', '新项目申请表的依据规范', '依据规范', 'zh-CN', '依据规范');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.RESOURCECONFIG', '新项目申请表的资源配置情况', '资源配置情况', 'zh-CN', '资源配置情况');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.TRIALOPERATION', '新项目申请表的试运行情况', '试运行情况', 'zh-CN', '试运行情况');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITMEPRINCIPAL', '新项目申请表的项目负责人', '项目负责人', 'zh-CN', '项目负责人');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITMEPRINCIPALID', '新项目申请表的项目负责人ID', '项目负责人ID', 'zh-CN', '项目负责人ID');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.ITMEPRINCIPALTIME', '新项目申请表的项目负责人批准日期', '项目负责人批准日期', 'zh-CN', '项目负责人批准日期');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.REMARK', '新项目申请表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.PROCESSSTATUS', '新项目申请表的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CREATEDBYID', '新项目申请表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CREATEDBYNAME', '新项目申请表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CREATEDTIME', '新项目申请表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CREATEDBYORGID', '新项目申请表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_ITEM_APPLY.CREATEDBYORGNAME', '新项目申请表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.QMS.ITEMAPPLYS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.QMS.ITEMAPPLYS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.QMS.ITEMAPPLYS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.QMS.ITEMAPPLYS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.QMS.ITEMAPPLYS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');


-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('7009', '新项目评审管理', '', '70', '7009', '016.svg', '新项目评审管理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700901', '新项目申请', '/secure/basemodule/qms/item-applys/page/edit-list', '7009', '700901', '', '新项目申请');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700902', '新项目审核', '/secure/basemodule/qms/item-applys/page/audit-list?bpmn_statusCode=audit', '7009', '700902', '', '新项目审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700903', '新项目批准', '/secure/basemodule/qms/item-applys/page/audit-list?bpmn_statusCode=approve', '7009', '700903', '', '新项目批准');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700904', '新项目试运行', '/secure/basemodule/qms/item-applys/page/audit-list?bpmn_statusCode=trial', '7009', '700904', '', '新项目试运行');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700905', '新项目试运行审核', '/secure/basemodule/qms/item-applys/page/audit-list?bpmn_statusCode=trialAudit', '7009', '700905', '', '新项目试运行审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700906', '新项目试运行批准', '/secure/basemodule/qms/item-applys/page/audit-list?bpmn_statusCode=trialApprove', '7009', '700906', '', '新项目试运行批准');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700907', '新项目评审管理查询', '/secure/basemodule/qms/item-applys/page/search-list', '7009', '700907', '', '新项目评审管理查询');

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

INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('7009', '新项目评审管理', 'T_LIMS_ITEM_APPLY', 'audit_def', '1');


COMMIT;

-- ----------------------------- 2022-09-19 add by qiuyf------------end