INSERT INTO `acm_menus` (`id`, `menu_title`, `parent_id`, `menu_order`, `menu_type_id`, `level`, `client_id`, `icon`, `img`, `page_menu_title`, `isDeleted`, `created_by`, `updated_at`, `created_at`, `is_approved`, `pre_approved_status`, `pre_approved_value`, `pre_approved_description`, `approval_request_generated_by`) VALUES (781, 'Upload Leave', 387, 10, 1, 3, 48, NULL, NULL, 'Upload Leave', 0, 58472, '2022-06-02 15:57:49', '2022-06-02 15:57:49', 1, 0, 0, NULL, NULL);
INSERT INTO `acm_group_role_menu` (`id`, `menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) VALUES (8274, 781, 155, '', 0, 1, 48, 56193, 56193, '2023-06-01 13:26:39', '2023-06-01 13:26:39', 0); INSERT INTO `acm_group_role_menu` (`id`, `menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) VALUES (8287, 781, 142, '', 0, 1, 48, 56193, 56193, '2023-06-01 13:26:39', '2023-06-01 13:26:39', 0); INSERT INTO `acm_group_role_menu` (`id`, `menus_id`, `client_portal_id`, `description`, `platform`, `status`, `cid`, `created_by`, `updated_by`, `on_created`, `on_updated`, `pre_approved_status`) VALUES (8288, 781, 149, '', 0, 1, 48, 56193, 56193, '2023-06-01 13:26:39', '2023-06-01 13:26:39', 0);
INSERT INTO `acm_group_role_association` (`id`, `menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) VALUES (5754, 781, 21, 0, 0, 0, 0, '2023-02-03 13:08:52', '2023-02-03 13:08:52', 'leave-utils', NULL, 'Upload Leaves History Uploader', 1);
INSERT INTO `acm_group_role_association` (`id`, `menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) VALUES (5763, 781, 12, 0, 0, 0, 0, '2023-02-03 13:08:52', '2023-02-03 13:08:52', 'leave-utils', NULL, 'Upload Leaves History Uploader', 1);
INSERT INTO `acm_group_role_association` (`id`, `menu_id`, `group_role_id`, `del`, `vie`, `upd`, `rig`, `on_created`, `on_updated`, `component_name`, `file_name`, `description`, `status`) VALUES (5764, 781, 17, 0, 0, 0, 0, '2023-02-03 13:08:52', '2023-02-03 13:08:52', 'leave-utils', NULL, 'Upload Leaves History Uploader', 1);
UPDATE acm_menus SET `parent_id`='387' WHERE  `id`=781; 
UPDATE acm_group_role_menu SET STATUS = 0 WHERE menus_id IN (94 , 126 , 129, 153, 383, 384, 385, 418, 780 , 781 , 387);
UPDATE acm_group_role_menu SET STATUS = 1 WHERE menus_id IN (387 , 781) AND client_portal_id IN (142,149);