初始化机场

字数 8622阅读 67

wyun_guest需要添加的地方

  • 1: oauth_clients需要添加一条记录


    image.png

INSERT INTO wyun_oauth.oauth_clients (id, secret, name, created_at, updated_at) VALUES ('XUZ', '111111', '徐州机场', NULL, NULL);

  • 2:oauth_user需要添加一条记录


    image.png

这里密码为Tideast0509
INSERT INTO wyun_oauth.oauth_user (oauth_user_id, name, mobile_phone, password, remember_token, created_at, updated_at) VALUES ('319', '', 'xuz', '$2y$10$fpx9HDdbhfsx6e9EDq8ZR.CO.8Gk6ZB9wx3Z7nChM8ufpcJJTbsYW', NULL, '2018-06-26 13:54:20', '2018-06-26 13:54:24');

  • 3 : oauth_sessions需要添加一条记录
    这里好像是每次登录都记录了一次,初始化公司看起来是没必要添加


    image.png
  • 3:员工表添加一条记录,主键id来源于第二步操作产生的319 这个主键


    image.png

INSERT INTO wyun_guest.employee (employee_id, airport_code, account, name, sex, create_time, create_user, update_time, update_user, is_deleted) VALUES ('319', 'XUZ', 'xuz', '徐州管理员', NULL, '2018-06-26 13:56:41', NULL, '2018-06-26 13:56:44', '319', '0');

wyun_guest需要初始化的地方

1.用XUZ添加一个演示账户
2.在employee表修改这个用户的三字码 id 319

-- 插入角色
INSERT INTO wyun_guest.sys_role (role_id, name, description, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '徐州超级管理员', '徐州超级管理员角色', '0', 'XUZ', '2017-02-23 15:36:50', '2017-04-13 10:38:07', NULL, '40');
-- 产生role_id 102

-- 给新加的用户添加角色,改user_id&三字码
INSERT INTO wyun_guest.sys_user_role (user_role_id, user_id, role_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '319', '102', '0', 'XUZ', '2017-05-04 14:40:12', '2017-05-04 14:40:12', NULL, NULL);

-- 添加角色菜单权限
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '66', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '40', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '41', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '54', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '57', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '59', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '55', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '56', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '29', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '42', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '30', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '46', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '31', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '44', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '45', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '32', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '43', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '39', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '58', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '35', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '63', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '67', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '69', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '34', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '47', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '48', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '65', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '37', '0', 'XUZ', '2017-05-03 16:47:53', '2017-05-03 16:47:53', NULL, NULL);
INSERT INTO wyun_guest.sys_role_menu (role_menu_id, role_id, menu_id, is_deleted, airport_code, create_time, update_time, create_user, update_user) VALUES ('', '102', '0', '0', 'XUZ', '2017-05-05 09:36:59', '2017-05-05 09:36:59', NULL, NULL);

-- 插入服务类型
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('1', 'XUZ', '01', '要客服务', '贵宾厅', '', NULL, NULL, '2016-12-26 10:11:03', '2017-01-10 10:04:29', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('2', 'XUZ', '01', '要客服务', 'VIP摆渡车', '', NULL, NULL, '2016-12-26 10:11:03', '2016-12-26 10:24:37', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('3', 'XUZ', '01', '要客服务', '迎送机陪同', '', NULL, NULL, '2016-12-26 10:11:03', '2016-12-26 10:24:37', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('4', 'XUZ', '01', '要客服务', '停车场', '', NULL, NULL, '2016-12-26 10:11:03', '2016-12-26 10:24:37', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('5', 'XUZ', '02', '两舱服务', '休息室', '', NULL, NULL, '2016-12-26 10:11:03', '2016-12-26 10:24:37', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('6', 'XUZ', '02', '两舱服务', '安检通道', '说明', NULL, NULL, '2017-02-21 10:06:06', '2017-02-21 10:07:01', '0');
INSERT INTO wyun_guest.service_type_allocation (service_type_allocation_id, airport_code, category_no, category, type, description, create_user, update_user, create_time, update_time, is_deleted) VALUES ('7', 'XUZ', '02', '两舱服务', '远机位摆渡车', '说明', NULL, NULL, '2017-02-21 10:06:22', '2017-02-21 10:06:54', '0');

-- 添加服务
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '1', NULL, '头等舱', '{"region": "未知", "departType": "国内", "positionNum": "0"}', NULL, NULL, '2017-03-25 06:01:53', '2017-03-25 06:01:53', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '2', NULL, '龙腾厅', '{"seatNum": "6", "plateNumber": "云P27051"}', NULL, NULL, '2017-03-25 06:02:50', '2017-03-25 06:02:50', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '3', NULL, '建行厅', '{}', NULL, NULL, '2017-03-25 06:05:32', '2017-03-25 06:05:32', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '4', NULL, '贵宾停车场', '{}', NULL, '172', '2017-03-25 06:06:00', '2017-04-18 17:24:29', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '5', NULL, '工行厅', '{"region": "二楼", "departType": "国内", "positionNum": "25"}', NULL, NULL, '2017-03-25 06:06:17', '2017-03-25 06:06:17', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '6', NULL, '农行厅', '{}', NULL, NULL, '2017-03-25 06:06:32', '2017-03-25 06:06:32', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '7', NULL, '招行厅', '{"region": "一楼", "departType": "国内", "positionNum": "16"}', NULL, NULL, '2017-03-25 06:06:51', '2017-03-25 06:06:51', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '7', NULL, '6号厅', '{"region": "一楼", "departType": "国内", "positionNum": "7"}', NULL, NULL, '2017-03-25 06:09:16', '2017-03-25 06:09:16', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '7', NULL, '别院厅', '{"region": "一楼", "departType": "国内", "positionNum": "20"}', NULL, NULL, '2017-03-25 06:09:39', '2017-03-25 06:09:39', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '7', NULL, '会员区', '{"region": "一楼", "departType": "国内", "positionNum": "13"}', NULL, NULL, '2017-03-25 06:10:08', '2017-03-25 06:10:08', '0');
INSERT INTO wyun_guest.serv (serv_id, airport_code, service_type_allocation_id, no, name, service_detail, create_user, update_user, create_time, update_time, is_deleted) VALUES ('', 'XUZ', '7', NULL, '候检区', '{"region": "一楼", "departType": "国内", "positionNum": "11"}', NULL, NULL, '2017-03-25 06:10:34', '2017-03-25 15:23:30', '0');

-- 接口权限,改role_id

INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/list', '基础服务', '服务-按类别查看服务列表', NULL, '2017-01-23 20:14:31', '2017-02-23 10:33:38', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/view', '基础服务', '服务-查看服务详情', NULL, '2017-01-23 20:14:37', '2017-01-23 20:14:41', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/delete', '基础服务', '服务-删除服务', NULL, '2017-02-03 18:39:36', '2017-02-03 18:39:40', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/save-or-update', '基础服务', '服务-增加或修改服务', NULL, '2017-02-03 18:40:43', '2017-02-03 18:40:46', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/service-menu-list', '基础服务', '服务-显示服务类别', NULL, '2017-02-03 18:42:01', '2017-02-03 18:42:04', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/service-type-allocation-list', '基础服务', '服务-查看服务类别列表', NULL, '2017-02-22 16:06:06', '2017-02-22 16:06:08', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/addMenu', '菜单管理', '系统管理-增加菜单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/deleteMenus', '菜单管理', '系统管理-删除菜单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/getMenuByRoleId', '菜单管理', '系统管理-按角色获取菜单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/getMenuByUserId', '菜单管理', '系统管理-按用户获取菜单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/menuTree', '菜单管理', '系统管理-菜单树', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/list', '角色列表', '系统管理-查看角色列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/deleteRoles', '角色列表', '系统管理-删除角色', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/saveOrUpdate', '角色列表', '系统管理-增加或修改角色', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/view', '角色列表', '系统管理-查看角色详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-role/viewMenu', '菜单管理', '系统管理-查看菜单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/view', '员工列表', '员工管理-查看员工详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/list', '员工列表', '员工管理-查看员工列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-product/list', '产品列表', '产品-查看产品列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-product/viewEdit', '产品列表', '产品-查看产品详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-product/deleteProduct', '产品列表', '产品-删除产品', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-product/addProduct', '产品列表', '产品-增加或修改产品', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/saveOrUpdate', '员工列表', '员工管理-增加或修改员工', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/getRoleByUserId', '员工列表', '员工管理-获取用户角色', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/delete', '员工列表', '员工管理-删除角色', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/queryEmployeeDropdownList', '员工列表', '员工管理-查询用户下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/list', '客户列表', '客户管理-查询客户列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/saveOrUpdate', '客户列表', '客户管理-增加或修改客户', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/view', '客户列表', '客户管理-查看客户详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/delete', '客户列表', '客户管理-删除客户', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/queryInstitutionClientDropdownList', '客户列表/预约列表/服务列表/协议列表', '客户管理-查询客户下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/list', '角色列表', '系统管理-查看角色权限列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/update-role-permission', '角色列表', '系统管理-修改角色权限', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/save-or-update', '协议列表', '协议管理-增加或修改协议', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/view', '协议列表', '协议管理-查看协议详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/get-service-list-by-type-and-protocol-product-id', '协议列表/预约列表/服务列表', '协议管理-查询某个协议产品下的某类服务详情列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/get-service-type-tree-by-protocol-product-id', '协议列表', '协议管理-查看某个协议产品的服务类别树', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/deleteProtocol', '协议列表', '协议管理-删除协议以及相关联信息', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocolList', '协议列表', '协议管理-查看协议列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocolTypeSelect', '协议列表/详情账单', '协议管理-协议类型下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/getProtocolNameDropdownList', '协议列表/预约列表/服务列表', '协议管理-协议名称模糊匹配', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/get-service-type-by-protocol-product-id', '协议列表/预约列表/服务列表', '协议管理-查看某个协议产品的服务类别', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/saveOrUpdate', '预约/服务列表', '订单管理-订单新增修改接口', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/getAuthorizerDropdownList', '预约列表/服务列表', '协议管理-预约人下拉框查询', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/flightInfoDropdownList', '预约/服务列表', '航班-航段模糊查询', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/flightInfo', '预约/服务列表', '航班-外部接口获取航班信息', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-product/get-service-type-tree-by-product-id', '协议列表', '产品-根据产品id查询服务类别树', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/get-service-list-by-type-and-product-id', '基础服务', '服务-根据服务类型配置id和产品id查询服务详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/get-service-box-by-type-and-protocol-product-id', '预约列表/服务列表', '协议管理-获取服务下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/flight-update', '调度/休息室/贵宾厅管理', '航班-航班修改', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/get-flight-list', '调度/休息室/贵宾厅管理', '航班-获取航班列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/get-flight-view', '调度/休息室/贵宾厅管理', '航班-查看航班详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/schedule-event-list', '调度事件管理', '航班-调度事件列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/schedule-event-save-or-update', '调度事件管理', '航班-调度事件添加或修改', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/schedule-event-view', '调度事件管理', '航班-查询调度事件详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/get-schedule-event-by-flight-id', '调度/休息室/贵宾厅管理', '航班-根据航班id或事件id查询调度事件', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/get-schedule-event-drop-down-box', '调度/休息室/贵宾厅管理', '航班-获取调度事件下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/schedule-event-delete', '调度事件管理', '航班-删除调度事件', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-list', '协议列表', '协议管理-查询协议产品列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getIdentityCardDropdownList', '预约/服务列表', '订单管理-乘客身份证模糊匹配', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-view', '协议列表', '协议管理-查询协议产品详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-save-or-update', '协议列表', '协议管理-协议产品添加或修改', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-delete', '协议列表', '协议管理-协议产品删除', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/product-and-service-list', '基础服务', '服务-查询产品服务详情列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-service-save-or-update', '协议列表', '协议管理-协议产品服务管理 - 新增/修改', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/protocol-product-service-view', '协议列表', '协议管理-查询协议产品服务名', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/view', '预约/服务列表', '订单管理-订单查看详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/delete', '预约/服务列表', '订单管理-订单删除', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/updateServerComplete', '调度/休息室/贵宾厅管理', '订单管理-更新服务完成', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getServerNumByServiceDetailId', '休息室/贵宾厅管理', '订单管理-获取服务乘客数量', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/getServNameAndPositionNum', '休息室/贵宾厅管理', '服务-获取服务厅以及位置数量', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getOrderCountByProtocolId', '协议列表', '订单管理-根据协议id获取订单数量', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/flightNoDropdownList', '预约/服务列表', '航班-航班号信息下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getOrderServiceRecord', '代办服务', '订单管理-代办服务-获取详情页的附加服务动态', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/addOrderServiceRecord', '代办服务', '订单管理-代办服务-更新附加服务动态', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/getEmployeeDropdownListByRoleId', '员工列表', '员工管理-根据角色获取人员下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/setDefaultRoom', '休息室/贵宾厅管理', '服务-设置默认服务厅', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/updateFlight', '龙腾', '航班-更新航班信息', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getPassengerByFlightId', '调度/休息室/贵宾厅管理', '订单管理-根据航班获取乘客信息', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/saveOrUpdateFlightScheduleEvent', '调度/休息室管理', '航班-航班调度事件添加或修改', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-check/list', '详细账单', '服务账单-服务账单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-check/customer-checklist', '详细账单', '服务账单-服务账单详情列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/customFlight', '预约/服务列表', '航班-定制航班', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-crm/getPassengerList', '智能CRM', 'crm-客户列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/queryProtocolIdsInOrderInfoByCustomId', '详细账单', '订单管理-查找客户下有订单的协议', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-check/exportFile', '详细账单', '服务账单-导出文件', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-crm/getPassengerById', '智能CRM', 'crm-客户详情', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-service/getServerNumByServiceDetailId', '休息室/贵宾厅管理', '服务-查询休息室/贵宾厅服务人数', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-crm/getLabelInfo', '智能CRM', 'crm-客户详情页的标签列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-employee/getUserName', '登录', '根据accessToken获取当前登录人姓名', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/flightLog', '调度/休息室/贵宾厅管理', '航班-获取航班信息的修改日志', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-protocol/getProtocolTypeDropdownList', '详情账单', '协议管理-协议类型下拉框', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getAirportCode', '预约/服务列表', '订单管理-根据accesstoken获取当前登录机场三字码', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/updateFlightInfo', '预约/服务列表', '航班-更新航班信息(订单模块和航班模块普通更改)', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/getCardType', '预约/服务列表', '订单管理-获取乘客卡类别', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/getInstitutionType', '客户列表', '客户管理-获取机构类型', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/permission-list', '角色权限', '系统管理-查看权限列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/allocate-permission-to-role', '角色权限', '系统管理-配置权限给角色', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/list', '预约/服务列表', '服务列表数据', '{"orderType": 1}', NULL, '2017-04-27 11:35:59', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/list', '预约/服务列表', '预约列表数据', '{"orderType": 0}', NULL, '2017-04-27 11:36:32', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/flight-info/getFlightForOrderDetail', '获取航班详情', '订单管理-预约/服务订单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/save-or-update', '角色列表', '系统管理-给角色增加数据权限', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-permission/data-permission-list', '角色列表', '系统管理-查看数据权限列表', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/institution-client/querySpecialDropdownList', '获取国航,南航的客户', '客户管理', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-check/specialCheckList', '得到特殊账单', '账单列表-特殊账单', NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-order/list', '预约/服务列表', '代办列表数据', '{"orderType": -1}', NULL, '2017-04-27 11:22:49', NULL, NULL, '0');
INSERT INTO wyun_guest.permission (permission_id, airport_code, url, menu_name, name, data_permission, create_time, update_time, create_user, update_user, is_deleted) VALUES ('', 'XUZ', '/guest-check/exportBill', '导出Excel', '特殊账单/休息室账单', NULL, NULL, NULL, NULL, NULL, '0');

-- 协议类型
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '冠名领导', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '冠名持卡', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '服务会员', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '地方政要', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '机场内接', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', 'VVIP', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '包量客户', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '结算会员', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '结算金银卡', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '结算头等舱', 'XUZ');
INSERT INTO wyun_guest.protocol_type (protocol_type_id, protocol_type_name, airport_code) VALUES ('', '零散散客', 'XUZ');

-- 添加产品
INSERT INTO wyun_guest.product (product_id, airport_code, product_name, is_deleted, create_time, create_user, update_time, update_user) VALUES ('', 'XUZ', 'VIP接送机', '0', '2017-03-13 16:07:14', '0', '2017-04-18 17:23:28', '172');
INSERT INTO wyun_guest.product (product_id, airport_code, product_name, is_deleted, create_time, create_user, update_time, update_user) VALUES ('', 'XUZ', '两舱休息室', '0', '2017-03-13 16:07:15', '0', '2017-04-10 10:19:51', '172');
INSERT INTO wyun_guest.product (product_id, airport_code, product_name, is_deleted, create_time, create_user, update_time, update_user) VALUES ('', 'XUZ', '独立安检通道', '0', '2017-03-13 17:12:59', '0', '2017-04-10 10:20:08', '172');
INSERT INTO wyun_guest.product (product_id, airport_code, product_name, is_deleted, create_time, create_user, update_time, update_user) VALUES ('', 'XUZ', '异地贵宾服务', '0', '2017-03-14 10:54:32', '0', '2017-04-10 10:19:59', '172');

select * from permission where airport_code='XUZ' and is_deleted=0

-- role_permission 接口角色权限 改 role_id,airport_code
INSERT INTO role_permission(permission_id,role_id,airport_code)
select permission_id,99,airport_code from permission WHERE airport_code='XUZ'

-- 机构客户,改employeeid airport_code
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '微软广告设计', '银行', '319', NULL, '2017-04-18 01:20:56', '172', NULL, NULL, '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '东方航空股份有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:37', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '成都航空有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:34', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '南方航空股份有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:30', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '重庆航空有限责任公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:27', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '西部航空有限责任公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:23', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '首都航空有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:19', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '四川航空股份有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:16', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '厦门航空有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:12', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '昆明航空有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:09', '172', '0');
INSERT INTO wyun_guest.institution_client (institution_client_id, airport_code, no, name, type, employee_id, remark, create_time, create_user, update_time, update_user, is_deleted) VALUES ('', 'XUZ', NULL, '西藏航空有限公司', '银行', '319', NULL, '2017-03-25 04:16:45', '108', '2017-04-07 11:03:06', '172', '0');

-- 机构客户类型
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '银行', '0', 'XUZ', '2017-04-10 10:33:20', NULL, '2017-04-10 10:33:20', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '旅游', '0', 'XUZ', '2017-04-10 10:33:33', NULL, '2017-04-10 10:33:33', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '保险', '0', 'XUZ', '2017-04-10 10:33:39', NULL, '2017-04-10 10:33:39', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '航空公司', '0', 'XUZ', '2017-04-10 10:33:48', NULL, '2017-04-10 10:33:48', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '广告', '0', 'XUZ', '2017-04-10 10:33:53', NULL, '2017-04-10 10:33:53', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '企业', '0', 'XUZ', '2017-04-10 10:34:00', NULL, '2017-04-10 10:34:00', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '酒店', '0', 'XUZ', '2017-04-10 10:34:04', NULL, '2017-04-10 10:34:04', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '外贸', '0', 'XUZ', '2017-04-10 10:34:12', NULL, '2017-04-10 10:34:12', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '理财', '0', 'XUZ', '2017-04-10 10:34:22', NULL, '2017-04-10 10:34:22', NULL);
INSERT INTO wyun_guest.institution_type (intitution_id, intitution_name, is_deleted, airport_code, create_time, create_user, update_time, update_user) VALUES ('', '其他', '0', 'XUZ', '2017-04-10 10:34:25', NULL, '2017-04-10 10:34:25', NULL);

-- 协议

INSERT INTO wyun_guest.protocol (protocol_id, airport_code, institution_client_id, no, name, type, reservation_num, start_date, end_date, clear_form, remark, is_deleted, create_user, update_user, create_time, update_time) VALUES ('', 'XUZ', '434', NULL, '1号配送产品', '1', '1', '2017-04-07', '2017-04-08', NULL, NULL, '0', '172', '172', '2017-04-07 12:43:17', '2017-04-07 12:43:17');
INSERT INTO wyun_guest.protocol (protocol_id, airport_code, institution_client_id, no, name, type, reservation_num, start_date, end_date, clear_form, remark, is_deleted, create_user, update_user, create_time, update_time) VALUES ('', 'XUZ', '593', 'SHAH0704', '微软广告设计业务合同', '3', '350', '2017-04-01', '2017-06-01', NULL, NULL, '0', '172', '172', '2017-04-18 01:23:23', '2017-04-18 09:48:39');
INSERT INTO wyun_guest.protocol (protocol_id, airport_code, institution_client_id, no, name, type, reservation_num, start_date, end_date, clear_form, remark, is_deleted, create_user, update_user, create_time, update_time) VALUES ('', 'XUZ', '434', NULL, '111', '7', '111111', '2017-05-10', '2017-05-10', NULL, '111', '0', '180', '180', '2017-05-10 06:29:15', '2017-05-10 06:29:15');
INSERT INTO wyun_guest.protocol (protocol_id, airport_code, institution_client_id, no, name, type, reservation_num, start_date, end_date, clear_form, remark, is_deleted, create_user, update_user, create_time, update_time) VALUES ('', 'XUZ', '276', 'SHAH0301', '东方航空国际头等舱', '3', '1', '2014-01-01', '2018-01-01', NULL, '该协议是东方航空公司的国际的头等舱客户服务使用', '1', NULL, NULL, '2017-03-25 08:14:27', '2017-04-10 10:22:36');
INSERT INTO wyun_guest.protocol (protocol_id, airport_code, institution_client_id, no, name, type, reservation_num, start_date, end_date, clear_form, remark, is_deleted, create_user, update_user, create_time, update_time) VALUES ('', 'XUZ', '276', 'SHAH0302', '东方航空国内头等舱', '3', '2', '2014-01-01', '2018-01-01', NULL, NULL, '1', NULL, NULL, '2017-03-25 16:33:49', '2017-04-10 10:22:34');

--
-- 用SHA进去新增的账号,airport_code 是LJG