-- 客户近3年财务报表：审批状态 + 营销管理下的“申报审批”菜单
-- 执行库：product-inventory-management-xmgl

ALTER TABLE `customer_financial_report`
  ADD COLUMN `audit_status` tinyint NOT NULL DEFAULT 0 COMMENT '审批状态：0待审批 1已通过 2已退回' AFTER `report_files`,
  ADD COLUMN `audit_user_id` bigint DEFAULT NULL COMMENT '审批人id' AFTER `audit_status`,
  ADD COLUMN `audit_user_name` varchar(100) DEFAULT NULL COMMENT '审批人' AFTER `audit_user_id`,
  ADD COLUMN `audit_time` datetime DEFAULT NULL COMMENT '审批时间' AFTER `audit_user_name`,
  ADD COLUMN `audit_remark` varchar(500) DEFAULT NULL COMMENT '审批意见/退回原因' AFTER `audit_time`;

-- 营销管理（menu_id=2010）下新增“申报审批”菜单
INSERT IGNORE INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`route_name`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`remark`)
VALUES (2369,'申报审批',2010,7,'reportAudit','salesManagement/reportAudit/index','','ReportAudit',1,0,'C','0','0','sales:report:audit','form','admin',NOW(),'客户财务报表申报审批');

-- 拥有营销管理菜单的角色自动获得申报审批菜单
INSERT IGNORE INTO `sys_role_menu` (`role_id`,`menu_id`)
SELECT rm.role_id, 2369 FROM `sys_role_menu` rm WHERE rm.menu_id = 2010;