sicuan_lims/sql/oracle/质量体系管理/投诉管理.txt

-- ----------------------------- 2022-09-29 add by qiuyf--------------begin

-- 建表语句
CREATE TABLE T_LIMS_COMPLAINT( 
    ID NUMBER NOT NULL,
    COMPLAINTINITIATOR VARCHAR2(270)  NULL,
    COMPLAINTTIME DATE NULL,
    CONTACT VARCHAR2(270)  NULL,
    DUTYORG VARCHAR2(270)  NULL,
    COMPLAINTCONTENT VARCHAR2(270)  NULL,
    DECIDE VARCHAR2(36)  NULL,
    SURVEYREASON VARCHAR2(270)  NULL,
    MEASURE VARCHAR2(270)  NULL,
    TRACE 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,
    ORGID VARCHAR2(36)  NULL,
    ORGNAME VARCHAR2(270)  NULL,
    RESULTFLAG VARCHAR2(36)  NULL,
    RESULTCORRECT VARCHAR2(36)  NULL,
    DUTYORGID VARCHAR2(36)  NULL
 );
COMMENT ON TABLE T_LIMS_COMPLAINT IS '投诉管理';
COMMENT ON COLUMN T_LIMS_COMPLAINT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTINITIATOR IS '报检方名称';
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTTIME IS '投诉日期';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CONTACT IS '联系方式';
COMMENT ON COLUMN T_LIMS_COMPLAINT.DUTYORG IS '责任部门';
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTCONTENT IS '投诉内容';
COMMENT ON COLUMN T_LIMS_COMPLAINT.DECIDE IS '投诉是否成立';
COMMENT ON COLUMN T_LIMS_COMPLAINT.SURVEYREASON IS '调查原因';
COMMENT ON COLUMN T_LIMS_COMPLAINT.MEASURE IS '采取措施';
COMMENT ON COLUMN T_LIMS_COMPLAINT.TRACE IS '结果追踪';
COMMENT ON COLUMN T_LIMS_COMPLAINT.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_COMPLAINT.ORGID IS '所属单位编码';
COMMENT ON COLUMN T_LIMS_COMPLAINT.ORGNAME IS '所属单位名称';
COMMENT ON COLUMN T_LIMS_COMPLAINT.RESULTFLAG IS '是否涉及结果';
COMMENT ON COLUMN T_LIMS_COMPLAINT.RESULTCORRECT IS '结果是否正确';
COMMENT ON COLUMN T_LIMS_COMPLAINT.DUTYORGID IS '责任部门编码';

ALTER TABLE T_LIMS_COMPLAINT ADD CONSTRAINT PK_LIMS_COMPLAINT PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_COMPLAINT.SERVICE_NAME', '投诉管理', '投诉管理', 'zh-CN', '投诉管理');
CALL INSERTI18N('T_LIMS_COMPLAINT.ID', '投诉管理的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTINITIATOR', '投诉管理的报检方名称', '报检方名称', 'zh-CN', '报检方名称');
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTTIME', '投诉管理的投诉日期', '投诉日期', 'zh-CN', '投诉日期');
CALL INSERTI18N('T_LIMS_COMPLAINT.CONTACT', '投诉管理的联系方式', '联系方式', 'zh-CN', '联系方式');
CALL INSERTI18N('T_LIMS_COMPLAINT.DUTYORG', '投诉管理的责任部门', '责任部门', 'zh-CN', '责任部门');
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTCONTENT', '投诉管理的投诉内容', '投诉内容', 'zh-CN', '投诉内容');
CALL INSERTI18N('T_LIMS_COMPLAINT.DECIDE', '投诉管理的投诉是否成立', '投诉是否成立', 'zh-CN', '投诉是否成立');
CALL INSERTI18N('T_LIMS_COMPLAINT.SURVEYREASON', '投诉管理的调查原因', '调查原因', 'zh-CN', '调查原因');
CALL INSERTI18N('T_LIMS_COMPLAINT.MEASURE', '投诉管理的采取措施', '采取措施', 'zh-CN', '采取措施');
CALL INSERTI18N('T_LIMS_COMPLAINT.TRACE', '投诉管理的结果追踪', '结果追踪', 'zh-CN', '结果追踪');
CALL INSERTI18N('T_LIMS_COMPLAINT.PROCESSSTATUS', '投诉管理的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYID', '投诉管理的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYNAME', '投诉管理的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDTIME', '投诉管理的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYORGID', '投诉管理的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYORGNAME', '投诉管理的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_COMPLAINT.ORGID', '投诉管理的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
CALL INSERTI18N('T_LIMS_COMPLAINT.ORGNAME', '投诉管理的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
CALL INSERTI18N('T_LIMS_COMPLAINT.RESULTFLAG', '投诉管理的是否涉及结果', '是否涉及结果', 'zh-CN', '是否涉及结果');
CALL INSERTI18N('T_LIMS_COMPLAINT.RESULTCORRECT', '投诉管理的结果是否正确', '结果是否正确', 'zh-CN', '结果是否正确');
CALL INSERTI18N('T_LIMS_COMPLAINT.DUTYORGID', '投诉管理的责任部门编码', '责任部门编码', 'zh-CN', '责任部门编码');
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('7008', '投诉管理', '', '70', '7008', '005.svg', '投诉管理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700801', '投诉受理', '/secure/basemodule/qms/complaints/page/edit-list', '7008', '700801', '', '投诉受理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700802', '初步审查', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Audit', '7008', '700802', '', '初步审查');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700803', '投诉处理', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Handle', '7008', '700803', '', '投诉处理');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700804', '采取措施', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Measures', '7008', '700804', '', '采取措施');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700805', '措施审核', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=MeasuresAudit', '7008', '700805', '', '措施审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700806', '复检结果', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Result', '7008', '700806', '', '复检结果');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700807', '复检结果审核', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=ResultAudit', '7008', '700807', '', '复检结果审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700808', '调查反馈', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Feedback', '7008', '700808', '', '调查反馈');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('700809', '投诉管理查询', '/secure/basemodule/qms/complaints/page/search-list', '7008', '700809', '', '投诉管理查询');

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

INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('7008', '投诉管理', 'T_LIMS_COMPLAINT', 'audit_def', '1');


COMMIT;

-- ----------------------------- 2022-09-29 add by qiuyf------------end