-- 清理已取消接口查询权限校验所对应的按钮及角色关联。
-- 页面菜单（type = 2）保留；仍用于非查询接口的权限也保留。
-- 执行后需刷新权限缓存或重启服务。
START TRANSACTION;
UPDATE system_role_menu rm
JOIN system_menu m ON m.id = rm.menu_id
SET rm.deleted = b'1', rm.update_time = NOW()
WHERE rm.deleted = b'0' AND m.deleted = b'0' AND m.type = 3
  AND m.permission IN (
    'aftersales:problem:query',
    'aftersales:return:query',
    'aftersales:ticket:query',
    'aftersales:visit:query',
    'ai:api-key:query',
    'ai:knowledge:query',
    'ai:model:query',
    'bi:chart-config:query',
    'bi:dashboard:query',
    'bi:data-source-config:query',
    'bpm:business-attach:query',
    'bpm:category:query',
    'bpm:form:query',
    'bpm:model:query',
    'bpm:oa-leave:query',
    'bpm:oa-notice:query',
    'bpm:process-auto-approve:query',
    'bpm:process-definition:query',
    'bpm:process-expression:query',
    'bpm:process-instance-cc:query',
    'bpm:process-listener:query',
    'bpm:task:query',
    'bpm:user-group:query',
    'crm:business-status:query',
    'crm:business:query',
    'crm:clue:query',
    'crm:contact:query',
    'crm:contract-config:query',
    'crm:contract:query',
    'crm:customer-limit-config:query',
    'crm:customer-pool-config:query',
    'crm:customer:query',
    'crm:invoice:query',
    'crm:receivable-plan:query',
    'crm:receivable:query',
    'crm:sale-quotation:query',
    'crm:sales-target:query',
    'crm:statistics-customer:query',
    'crm:statistics-funnel:query',
    'crm:statistics-performance:query',
    'crm:statistics-portrait:query',
    'crm:statistics-rank:query',
    'energy:alert:query',
    'energy:analysis:query',
    'energy:record:query',
    'erp:account:query',
    'erp:finance-payment:query',
    'erp:finance-receipt:query',
    'erp:purchase-invoice:query',
    'erp:purchase-order:query',
    'erp:purchase-request:query',
    'erp:sale-order:query',
    'erp:statistics:query',
    'erp:supplier:query',
    'hrm:attendance-exception:query',
    'hrm:attendance-holiday:query',
    'hrm:attendance-record:query',
    'hrm:attendance-rule:query',
    'hrm:attendance-summary:query',
    'hrm:employee-contract:query',
    'hrm:employee-schedule:query',
    'hrm:employee-social-security:query',
    'hrm:employee:query',
    'hrm:leave-type-config:query',
    'hrm:leave:query',
    'hrm:overtime:query',
    'hrm:resignation:query',
    'hrm:salary-calculation:query',
    'hrm:salary-payment:query',
    'hrm:salary-structure:query',
    'hrm:shift:query',
    'hrm:social-security-scheme:query',
    'hrm:social-security:query',
    'hrm:tax-rate-config:query',
    'hrm:transfer:query',
    'im:manager:channel-material:query',
    'im:manager:channel-message:query',
    'im:manager:channel:query',
    'im:manager:face-pack-item:query',
    'im:manager:face-pack:query',
    'im:manager:face-user-item:query',
    'im:manager:friend-request:query',
    'im:manager:friend:query',
    'im:manager:group-request:query',
    'im:manager:group:query',
    'im:manager:message:query',
    'im:manager:rtc:query',
    'im:manager:sensitive-word:query',
    'im:manager:statistics:query',
    'infra:api-access-log:query',
    'infra:api-error-log:query',
    'infra:codegen:query',
    'infra:config:query',
    'infra:data-source-config:query',
    'infra:demo01-contact:query',
    'infra:demo02-category:query',
    'infra:demo03-student:query',
    'infra:file-config:query',
    'infra:file:query',
    'infra:job:query',
    'mdm:brand:query',
    'mdm:item-category:query',
    'mdm:item:query',
    'mdm:unit:query',
    'mdm:warehouse:query',
    'member:config:query',
    'member:experience-record:query',
    'member:group:query',
    'member:level-record:query',
    'member:level:query',
    'member:tag:query',
    'member:user:query',
    'mes:cal-holiday:query',
    'mes:cal-plan:query',
    'mes:cal-team-shift:query',
    'mes:cal-team:query',
    'mes:dv-check-plan:query',
    'mes:dv-check-record:query',
    'mes:dv-machinery-type:query',
    'mes:dv-machinery:query',
    'mes:dv-mainten-record:query',
    'mes:dv-metering-check:query',
    'mes:dv-metering:query',
    'mes:dv-repair:query',
    'mes:dv-spare:query',
    'mes:dv-subject:query',
    'mes:home:query',
    'mes:md-item-type:query',
    'mes:md-item:query',
    'mes:md-unit-measure:query',
    'mes:md-workshop:query',
    'mes:md-workstation:query',
    'mes:pd-archive:query',
    'mes:pd-document-audit:query',
    'mes:pd-document:query',
    'mes:pd-process-param-template:query',
    'mes:pd-process-param:query',
    'mes:pd-project:query',
    'mes:pro-andon-config:query',
    'mes:pro-andon-record:query',
    'mes:pro-card:query',
    'mes:pro-feedback:query',
    'mes:pro-mps:query',
    'mes:pro-process:query',
    'mes:pro-route:query',
    'mes:pro-task-issue:query',
    'mes:pro-task:query',
    'mes:pro-work-order:query',
    'mes:pro-workrecord:query',
    'mes:qc-defect:query',
    'mes:qc-indicator:query',
    'mes:qc-inspection-ledger:query',
    'mes:qc-ipqc:query',
    'mes:qc-iqc:query',
    'mes:qc-ncr:query',
    'mes:qc-oqc:query',
    'mes:qc-pending-inspect:query',
    'mes:qc-rqc:query',
    'mes:qc-template:query',
    'mes:tm-tool-type:query',
    'mes:tm-tool:query',
    'mes:wm-arrival-notice:query',
    'mes:wm-barcode-config:query',
    'mes:wm-barcode:query',
    'mes:wm-batch:query',
    'mes:wm-item-receipt:query',
    'mes:wm-material-stock:query',
    'mes:wm-misc-issue:query',
    'mes:wm-outsource-issue:query',
    'mes:wm-outsource-receipt:query',
    'mes:wm-package:query',
    'mes:wm-product-issue:query',
    'mes:wm-product-produce:query',
    'mes:wm-product-receipt:query',
    'mes:wm-product-sales:query',
    'mes:wm-return-issue:query',
    'mes:wm-return-sales:query',
    'mes:wm-return-vendor:query',
    'mes:wm-sales-notice:query',
    'mes:wm-sn:query',
    'mes:wm-stock-taking-plan:query',
    'mes:wm-stock-taking-task:query',
    'mes:wm-transaction:query',
    'mes:wm-transfer:query',
    'mes:wm-warehouse:query',
    'mes:wm:misc-receipt:query',
    'point:record:query',
    'point:sign-in-config:query',
    'point:sign-in-record:query',
    'qc-report:instance:query',
    'qc-report:template:query',
    'srm:bid-award:query',
    'srm:bid-evaluation:query',
    'srm:bid-open:query',
    'srm:statistics:query',
    'srm:supplier-apply:query',
    'srm:supplier-certificate:query',
    'srm:supplier-contact:query',
    'srm:supplier-evaluation:query',
    'srm:supplier-quote:query',
    'srm:supplier:query',
    'srm:tender-bid:query',
    'srm:tender-config:query',
    'srm:tender-project:query',
    'system:dept:query',
    'system:dict:query',
    'system:login-log:query',
    'system:mail-account:query',
    'system:mail-log:query',
    'system:mail-template:query',
    'system:menu:query',
    'system:notice:query',
    'system:notify-message:query',
    'system:notify-template:query',
    'system:oauth2-client:query',
    'system:operate-log:query',
    'system:post:query',
    'system:role:query',
    'system:sms-channel:query',
    'system:sms-log:query',
    'system:sms-template:query',
    'system:social-client:query',
    'system:social-user:query',
    'system:storage-attachment:query',
    'system:tenant-package:query',
    'system:tenant:query',
    'system:user:query'
  );
UPDATE system_menu
SET deleted = b'1', update_time = NOW()
WHERE deleted = b'0' AND type = 3
  AND permission IN (
    'aftersales:problem:query',
    'aftersales:return:query',
    'aftersales:ticket:query',
    'aftersales:visit:query',
    'ai:api-key:query',
    'ai:knowledge:query',
    'ai:model:query',
    'bi:chart-config:query',
    'bi:dashboard:query',
    'bi:data-source-config:query',
    'bpm:business-attach:query',
    'bpm:category:query',
    'bpm:form:query',
    'bpm:model:query',
    'bpm:oa-leave:query',
    'bpm:oa-notice:query',
    'bpm:process-auto-approve:query',
    'bpm:process-definition:query',
    'bpm:process-expression:query',
    'bpm:process-instance-cc:query',
    'bpm:process-listener:query',
    'bpm:task:query',
    'bpm:user-group:query',
    'crm:business-status:query',
    'crm:business:query',
    'crm:clue:query',
    'crm:contact:query',
    'crm:contract-config:query',
    'crm:contract:query',
    'crm:customer-limit-config:query',
    'crm:customer-pool-config:query',
    'crm:customer:query',
    'crm:invoice:query',
    'crm:receivable-plan:query',
    'crm:receivable:query',
    'crm:sale-quotation:query',
    'crm:sales-target:query',
    'crm:statistics-customer:query',
    'crm:statistics-funnel:query',
    'crm:statistics-performance:query',
    'crm:statistics-portrait:query',
    'crm:statistics-rank:query',
    'energy:alert:query',
    'energy:analysis:query',
    'energy:record:query',
    'erp:account:query',
    'erp:finance-payment:query',
    'erp:finance-receipt:query',
    'erp:purchase-invoice:query',
    'erp:purchase-order:query',
    'erp:purchase-request:query',
    'erp:sale-order:query',
    'erp:statistics:query',
    'erp:supplier:query',
    'hrm:attendance-exception:query',
    'hrm:attendance-holiday:query',
    'hrm:attendance-record:query',
    'hrm:attendance-rule:query',
    'hrm:attendance-summary:query',
    'hrm:employee-contract:query',
    'hrm:employee-schedule:query',
    'hrm:employee-social-security:query',
    'hrm:employee:query',
    'hrm:leave-type-config:query',
    'hrm:leave:query',
    'hrm:overtime:query',
    'hrm:resignation:query',
    'hrm:salary-calculation:query',
    'hrm:salary-payment:query',
    'hrm:salary-structure:query',
    'hrm:shift:query',
    'hrm:social-security-scheme:query',
    'hrm:social-security:query',
    'hrm:tax-rate-config:query',
    'hrm:transfer:query',
    'im:manager:channel-material:query',
    'im:manager:channel-message:query',
    'im:manager:channel:query',
    'im:manager:face-pack-item:query',
    'im:manager:face-pack:query',
    'im:manager:face-user-item:query',
    'im:manager:friend-request:query',
    'im:manager:friend:query',
    'im:manager:group-request:query',
    'im:manager:group:query',
    'im:manager:message:query',
    'im:manager:rtc:query',
    'im:manager:sensitive-word:query',
    'im:manager:statistics:query',
    'infra:api-access-log:query',
    'infra:api-error-log:query',
    'infra:codegen:query',
    'infra:config:query',
    'infra:data-source-config:query',
    'infra:demo01-contact:query',
    'infra:demo02-category:query',
    'infra:demo03-student:query',
    'infra:file-config:query',
    'infra:file:query',
    'infra:job:query',
    'mdm:brand:query',
    'mdm:item-category:query',
    'mdm:item:query',
    'mdm:unit:query',
    'mdm:warehouse:query',
    'member:config:query',
    'member:experience-record:query',
    'member:group:query',
    'member:level-record:query',
    'member:level:query',
    'member:tag:query',
    'member:user:query',
    'mes:cal-holiday:query',
    'mes:cal-plan:query',
    'mes:cal-team-shift:query',
    'mes:cal-team:query',
    'mes:dv-check-plan:query',
    'mes:dv-check-record:query',
    'mes:dv-machinery-type:query',
    'mes:dv-machinery:query',
    'mes:dv-mainten-record:query',
    'mes:dv-metering-check:query',
    'mes:dv-metering:query',
    'mes:dv-repair:query',
    'mes:dv-spare:query',
    'mes:dv-subject:query',
    'mes:home:query',
    'mes:md-item-type:query',
    'mes:md-item:query',
    'mes:md-unit-measure:query',
    'mes:md-workshop:query',
    'mes:md-workstation:query',
    'mes:pd-archive:query',
    'mes:pd-document-audit:query',
    'mes:pd-document:query',
    'mes:pd-process-param-template:query',
    'mes:pd-process-param:query',
    'mes:pd-project:query',
    'mes:pro-andon-config:query',
    'mes:pro-andon-record:query',
    'mes:pro-card:query',
    'mes:pro-feedback:query',
    'mes:pro-mps:query',
    'mes:pro-process:query',
    'mes:pro-route:query',
    'mes:pro-task-issue:query',
    'mes:pro-task:query',
    'mes:pro-work-order:query',
    'mes:pro-workrecord:query',
    'mes:qc-defect:query',
    'mes:qc-indicator:query',
    'mes:qc-inspection-ledger:query',
    'mes:qc-ipqc:query',
    'mes:qc-iqc:query',
    'mes:qc-ncr:query',
    'mes:qc-oqc:query',
    'mes:qc-pending-inspect:query',
    'mes:qc-rqc:query',
    'mes:qc-template:query',
    'mes:tm-tool-type:query',
    'mes:tm-tool:query',
    'mes:wm-arrival-notice:query',
    'mes:wm-barcode-config:query',
    'mes:wm-barcode:query',
    'mes:wm-batch:query',
    'mes:wm-item-receipt:query',
    'mes:wm-material-stock:query',
    'mes:wm-misc-issue:query',
    'mes:wm-outsource-issue:query',
    'mes:wm-outsource-receipt:query',
    'mes:wm-package:query',
    'mes:wm-product-issue:query',
    'mes:wm-product-produce:query',
    'mes:wm-product-receipt:query',
    'mes:wm-product-sales:query',
    'mes:wm-return-issue:query',
    'mes:wm-return-sales:query',
    'mes:wm-return-vendor:query',
    'mes:wm-sales-notice:query',
    'mes:wm-sn:query',
    'mes:wm-stock-taking-plan:query',
    'mes:wm-stock-taking-task:query',
    'mes:wm-transaction:query',
    'mes:wm-transfer:query',
    'mes:wm-warehouse:query',
    'mes:wm:misc-receipt:query',
    'point:record:query',
    'point:sign-in-config:query',
    'point:sign-in-record:query',
    'qc-report:instance:query',
    'qc-report:template:query',
    'srm:bid-award:query',
    'srm:bid-evaluation:query',
    'srm:bid-open:query',
    'srm:statistics:query',
    'srm:supplier-apply:query',
    'srm:supplier-certificate:query',
    'srm:supplier-contact:query',
    'srm:supplier-evaluation:query',
    'srm:supplier-quote:query',
    'srm:supplier:query',
    'srm:tender-bid:query',
    'srm:tender-config:query',
    'srm:tender-project:query',
    'system:dept:query',
    'system:dict:query',
    'system:login-log:query',
    'system:mail-account:query',
    'system:mail-log:query',
    'system:mail-template:query',
    'system:menu:query',
    'system:notice:query',
    'system:notify-message:query',
    'system:notify-template:query',
    'system:oauth2-client:query',
    'system:operate-log:query',
    'system:post:query',
    'system:role:query',
    'system:sms-channel:query',
    'system:sms-log:query',
    'system:sms-template:query',
    'system:social-client:query',
    'system:social-user:query',
    'system:storage-attachment:query',
    'system:tenant-package:query',
    'system:tenant:query',
    'system:user:query'
  );
COMMIT;