water/server/plugin/saiadmin/db/20260826_add_device_distribution_page.sql

-- 去铺货页面和所需接口权限，可重复执行。
-- 提交复用 /core/merchant/device/bind，业务事务位于 MerchantLogic::bindDevices。

INSERT INTO `sa_system_menu` (
    `parent_id`, `name`, `code`, `slug`, `type`, `path`, `component`, `method`, `icon`, `sort`,
    `link_url`, `is_iframe`, `is_keep_alive`, `is_hidden`, `is_fixed_tab`, `is_full_page`,
    `generate_id`, `generate_key`, `status`, `remark`, `created_by`, `updated_by`, `create_time`, `update_time`, `delete_time`
)
SELECT
    device_menu.`id`, '去铺货', 'DistributeDevice', NULL, 2,
    'distribute', '/device/distribute', NULL, 'ri:send-plane-line', 75,
    NULL, 2, 2, 1, 2, 2, 0, NULL, 1,
    '选择已有商户并批量铺货未绑定设备', 1, 1, NOW(), NOW(), NULL
FROM `sa_system_menu` device_menu
WHERE device_menu.`code` = 'Device'
  AND device_menu.`delete_time` IS NULL
  AND NOT EXISTS (
      SELECT 1 FROM `sa_system_menu`
      WHERE `code` = 'DistributeDevice' AND `delete_time` IS NULL
  );

-- 已有设备页面权限的角色获得去铺货页面、商户候选列表和设备绑定权限。
INSERT INTO `sa_system_role_menu` (`role_id`, `menu_id`)
SELECT DISTINCT source_role.`role_id`, target_menu.`id`
FROM `sa_system_role_menu` source_role
INNER JOIN `sa_system_menu` source_menu
        ON source_menu.`id` = source_role.`menu_id`
       AND source_menu.`code` IN ('MyDevice', 'SubordinateDevice')
       AND source_menu.`delete_time` IS NULL
INNER JOIN `sa_system_menu` target_menu
        ON (
            target_menu.`code` = 'DistributeDevice'
            OR target_menu.`slug` IN ('core:merchant:index', 'core:merchant:device:bind')
        )
       AND target_menu.`delete_time` IS NULL
LEFT JOIN `sa_system_role_menu` existing_role
       ON existing_role.`role_id` = source_role.`role_id`
      AND existing_role.`menu_id` = target_menu.`id`
WHERE existing_role.`id` IS NULL;