INSERT INTO `sps_menu`
    (`menu_item`, `menu_url`, `menu_class`, `parent_menu_id`, `action`, `order`, `status`, `location_id`, `area_id`, `created_by`, `created_at`, `updated_by`)
    VALUES ('mixed_transaction', 'admin/reports/mixed_transaction', 'menu', '46', '', '11.28', '1', '1', '1', '1', CURRENT_TIMESTAMP, '0');

INSERT INTO `sps_menu_action_mapping`
    (`menu_id`, `action_id`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`)
    VALUES ((SELECT id FROM sps_menu WHERE sps_menu.menu_item = "mixed_transaction"), '1', '0', '0', '0', '0', CURRENT_TIMESTAMP);

INSERT INTO `sps_menu_action_mapping`
    (`menu_id`, `action_id`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`)
    VALUES ((SELECT id FROM sps_menu WHERE sps_menu.menu_item = "mixed_transaction"), '6', '0', '0', '0', '0', CURRENT_TIMESTAMP);

/*sps_access_rights table query*/

INSERT INTO `sps_access_rights`
	(`id`, `role_id`, `menu_id`, `action_id`, `created_by`, `updated_at`, `deleted_at`, `location_id`, `area_id`, `updated_by`, `created_at`)
	VALUES ('0', '1', (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "mixed_transaction"), '1', '0', CURRENT_TIMESTAMP, NULL, '0', '0', '0', CURRENT_TIMESTAMP);

INSERT INTO `sps_access_rights`
	(`id`, `role_id`, `menu_id`, `action_id`, `created_by`, `updated_at`, `deleted_at`, `location_id`, `area_id`, `updated_by`, `created_at`)
	VALUES ('0', '1', (SELECT id FROM sps_menu WHERE sps_menu.menu_item = "mixed_transaction"), '6', '0', CURRENT_TIMESTAMP, NULL, '0', '0', '0', CURRENT_TIMESTAMP);