-- ============================================================
-- 就业一湛通服务平台 - 职业指导服务 测试数据
-- 数据库：达梦数据库 (DM8)
-- 创建日期：2026-06-12
-- 说明：关联 PERSONAL_INFO 表中已存在的测试数据 (178060100000200~178060100000205)
-- ============================================================

-- 清理旧数据
DELETE FROM CAREER_GUIDANCE_RECORD;
DELETE FROM CAREER_GUIDANCE_SERVICE;
DELETE FROM CAREER_GUIDANCE_EXPERT;

-- ============================================================
-- 1. 职业指导专家库
-- ============================================================
INSERT INTO CAREER_GUIDANCE_EXPERT (ID, NAME, CONTACT_PHONE, EXPERTISE_AREA, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060200000001', '王明', '13800138000', '职场生涯规划、简历深度优化、面试模拟辅导', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_EXPERT (ID, NAME, CONTACT_PHONE, EXPERTISE_AREA, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060200000002', '李红', '13900139000', '大学生创业政策咨询、职业心理调适、转型技能提升', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_EXPERT (ID, NAME, CONTACT_PHONE, EXPERTISE_AREA, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060200000003', '陈志强', '13700137000', '制造业技能培训、农民工就业指导、劳动法规咨询', 'admin', CURRENT_TIMESTAMP, 'A01');

-- ============================================================
-- 2. 职业指导服务申请
-- ============================================================
INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000001', '178060100000200', '应届生求职方向迷茫，需要针对互联网行业的简历优化建议', '2026-06-01', '是', '2026-06-09 10:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000002', '178060100000201', '失业半年以上，寻求职业技能培训推荐及转型指导', '2026-06-03', '是', '2026-06-08 15:30:00', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000003', '178060100000202', '脱贫人员希望找到稳定工作，需要就业指导和岗位推荐', '2026-06-05', '否', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000004', '178060100000203', '农学硕士寻求农业技术相关岗位，需要行业分析和面试辅导', '2026-06-07', '否', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000005', '178060100000204', '退役军人希望转业到物流行业，需要职业规划和技能培训建议', '2026-06-09', '是', '2026-06-11 09:20:00', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_SERVICE (ID, PERSONAL_ID, APPLICATION_REASON, APPLICATION_DATE, IS_FOLLOWED_UP, LAST_NOTIFY_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060210000006', '178060100000205', '零就业家庭成员，有会计证，寻求财务类岗位及面试指导', '2026-06-10', '否', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');

-- ============================================================
-- 3. 服务跟进记录
-- ============================================================
-- 记录: 申请1 (178060210000001) — 王明专家跟进
INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000001', '178060210000001', 1, '初次电话沟通', '已通过电话进行初步沟通。建议人员突出在校项目经历中的技术栈细节，并针对目标岗位调整关键词。', '2026-06-02 10:00:00', '王明', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000002', '178060210000001', 2, '简历优化完成', '协助完成简历优化，新增2个实习项目描述，调整技能标签为Java/Python/Spring Boot。', '2026-06-05 14:00:00', '王明', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000003', '178060210000001', 3, '推送岗位信息', '推送湛江本地3个Java开发岗位，人员表示会尽快投递。', '2026-06-09 10:00:00', '王明', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 记录: 申请2 (178060210000002) — 李红专家跟进
INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000004', '178060210000002', 1, '需求评估', '人员有文秘经验，建议朝行政/人事方向发展。推荐参加办公软件高级应用培训。', '2026-06-04 09:30:00', '李红', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000005', '178060210000002', 2, '培训推荐', '推荐湛江市人社局免费职业技能培训（办公软件应用），人员已报名参加。', '2026-06-08 15:30:00', '李红', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 记录: 申请5 (178060210000005) — 陈志强专家跟进
INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000006', '178060210000005', 1, '退役军人专项指导', '了解人员军队驾驶经验，建议考取危险品运输资格证，推荐物流公司司机岗位。', '2026-06-10 11:00:00', '陈志强', 'admin', CURRENT_TIMESTAMP, 'A01');

INSERT INTO CAREER_GUIDANCE_RECORD (ID, SERVICE_ID, RECORD_TYPE, TITLE, CONTENT, RECORD_TIME, OPERATOR, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060220000007', '178060210000005', 3, '岗位推荐反馈', '推送湛江港物流公司岗位，人员已投递简历并等待面试通知。', '2026-06-11 09:20:00', '陈志强', 'admin', CURRENT_TIMESTAMP, 'A01');
